|
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/toadmin/cal_hotel/ |
Upload File : |
<?
include "../include/top_proc.html";
include "_common.html";
$class_HotelReserv = new HotelReserv();
$table = "TB_ACCOUNT_HOTEL";
$revn_price = str_replace(",","",$revn_price); // 수익금
$exes_price = str_replace(",","",$exes_price); // 비용금
// 정산항목 입력
if ($SqlType=="date_cal_ins")
{
if (!$res_no) exit;
// 행사정보
$data = $class_HotelReserv->res_hotel_master(" and res_no='{$res_no}' ");
$row = $data[0];
// 수익코드
if ($revn_cd) {
$arr_t = base_codec("ACC","LGEV",$revn_cd);
$revn_nm = $arr_t[0]['cd_nm'];
}
// 비용코드
if ($exes_cd) {
$arr_t = base_codec("ACC","LGXE",$exes_cd);
$exes_nm = $arr_t[0]['cd_nm'];
}
// 은행코드
if ($avnk_cd) {
$arr_t = base_codec("ACC","AVNK",$avnk_cd);
$avnk_nm = $arr_t[0]['cd_nm'];
}
// 행사담당자 정보
if ($row['admin_id']) {
$admin_id = $row['admin_id'];
$admin_nm = $row['admin_nm'];
$arr = get_member($admin_id);
$admin_brench = $arr['emp_brench_cd'];
$admin_depart = $arr['emp_depart_cd'];
}
// 상품담당자를 행사 담당자로 세팅
else
{
$arr_t = hotel_list(" and hseq='{$row[hseq]}' ");
$arr = $arr_t[0];
$admin_id = $arr['admin_id'];
$admin_nm = $arr['admin_nm'];
if ($admin_id)
{
$arr = get_member($admin_id);
$admin_brench = $arr['emp_brench_cd'];
$admin_depart = $arr['emp_depart_cd'];
}
}
$sql = "insert into {$table} set ";
$sql .= " res_no='{$res_no}', ";
$sql .= " hseq='{$row[hseq]}', ";
$sql .= " hotel_code='{$row[hotel_code]}', ";
$sql .= " hotel_nm='{$row[hnm]}', ";
$sql .= " ridx='{$row[ridx]}', "; // 룸타입 idx
$sql .= " room_type='{$row[rnm]}', ";
$sql .= " checkin_dt='{$row[room_date]}', ";
$sql .= " checkout_dt='{$row[room_date_out]}', ";
$sql .= " revn_cd='{$revn_cd}', ";
$sql .= " revn_nm='{$revn_nm}', ";
$sql .= " revn_price='{$revn_price}', ";
$sql .= " exes_cd='{$exes_cd}', ";
$sql .= " exes_nm='{$exes_nm}', ";
$sql .= " exes_price='{$exes_price}', ";
$sql .= " agent_id='{$agent_id}', ";
$sql .= " agent_nm='{$agent_nm}', ";
$sql .= " acc_dt='{$acc_dt}', ";
$sql .= " cont='{$cont}', ";
$sql .= " ins_dt=now(), ";
$sql .= " ins_id='{$TO_MB[mb_id]}', ";
$sql .= " ins_nm='{$TO_MB[mb_nm]}', ";
$sql .= " admin_id='{$admin_id}', ";
$sql .= " admin_nm='{$admin_nm}', ";
$sql .= " admin_brench='{$admin_brench}', ";
$sql .= " admin_depart='{$admin_depart}', ";
$sql .= " avnk_cd='{$avnk_cd}', ";
$sql .= " avnk_nm='{$avnk_nm}', ";
$sql .= " avnk_number='{$avnk_number}', ";
$sql .= " avnk_owner='{$avnk_owner}', ";
$sql .= " res_dt='".substr($row[ins_dt],0,10)."' ";
db_query($sql);
error_msg("document.location.reload();","script");
}
// 정산항목 수정
else if($SqlType=="date_cal_updt")
{
if(!$res_no or !$seq) exit;
// 수익코드
if ($revn_cd) {
$arr_t = base_codec("ACC","LGEV",$revn_cd);
$revn_nm = $arr_t[0]['cd_nm'];
}
// 비용코드
if ($exes_cd) {
$arr_t = base_codec("ACC","LGXE",$exes_cd);
$exes_nm = $arr_t[0]['cd_nm'];
}
// 은행코드
if ($avnk_cd) {
$arr_t = base_codec("ACC","AVNK",$avnk_cd);
$avnk_nm = $arr_t[0]['cd_nm'];
}
$sql = "update {$table} set ";
$sql .= " revn_cd='{$revn_cd}', ";
$sql .= " revn_nm='{$revn_nm}', ";
$sql .= " revn_price='{$revn_price}', ";
$sql .= " exes_cd='{$exes_cd}', ";
$sql .= " exes_nm='{$exes_nm}', ";
$sql .= " exes_price='{$exes_price}', ";
$sql .= " agent_id='{$agent_id}', ";
$sql .= " agent_nm='{$agent_nm}', ";
$sql .= " acc_dt='{$acc_dt}', ";
$sql .= " cont='{$cont}', ";
$sql .= " edit_id='{$TO_MB[mb_id]}', ";
$sql .= " edit_nm='{$TO_MB[mb_nm]}', ";
$sql .= " avnk_cd='{$avnk_cd}', ";
$sql .= " avnk_nm='{$avnk_nm}', ";
$sql .= " avnk_number='{$avnk_number}', ";
$sql .= " avnk_owner='{$avnk_owner}', ";
$sql .= " edit_dt=now() ";
$sql .= " where res_no='{$res_no}' and seq='{$seq}' ";
db_query($sql);
error_msg("document.location.reload();","script");
}
// 정산항목 삭제
else if($SqlType=="date_cal_dele")
{
if(!$res_no or !$seq) exit;
$sql = "delete from {$table} where res_no='{$res_no}' and seq='{$seq}' ";
db_query($sql);
error_msg("document.location.reload();","script");
}
?>