|
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/calculate/ |
Upload File : |
<?
include "../include/top_proc.html"; //공통파일 인클루드
include "_common.php";
$class_AccountCustomer = new AccountCustomer();
$table = "TB_ACCOUNT_HOTEL";
//호텔정산 입출금 저장
if($SqlType=="account_hotel_ins"){
if(!$res_no or !$hseq) exit;
$price_cost_plus = str_replace(",","",$price_cost_plus);
$price_cost_minus = str_replace(",","",$price_cost_minus);
$bank_plus = str_replace(",","",$bank_plus);
$bank_minus = str_replace(",","",$bank_minus);
//예약 완료 정보
$data = $class_AccountCustomer->account_res_complete_hotel(" and a.res_no='{$res_no}' and a.hseq='{$hseq}' ","","0","1");
$row = $data[0];
$code_bank = base_codec("PRD","INBK",$code_bank);//통장
$sql = " insert into {$table} set ";
$sql .= " res_no='$res_no'";
$sql .= ",hseq='$hseq'";
$sql .= ",hotel_code='{$row['hotel_code']}'";
$sql .= ",hotel_nm='{$row['hotel_nm']}'";
$sql .= ",acc_dt=curdate()";
$sql .= ",acnt_cd='{$acnt_cd}'";
$sql .= ",price_cost_plus='{$price_cost_plus}'";
$sql .= ",price_cost_minus='{$price_cost_minus}'";
$sql .= ",bank_plus='{$bank_plus}'";
$sql .= ",bank_minus='{$bank_minus}'";
$sql .= ",bank_cd='{$bank_cd}'";
$sql .= ",bank_nm='{$code_bank[0]['cd_nm']}'";
$sql .= ",bank_number='{$code_bank[0]['cd_memo']}'";
$sql .= ",bank_owner='{$code_bank[0]['cd_memo2']}'";
$sql .= ",ins_dt=now()";
$sql .= ",ins_mb_id='$MemberID'";
db_query($sql);
error_msg("document.location.reload();","script");
//호텔정산 입출금 삭제
}elseif($SqlType=="account_hotel_delete"){
if(!$acidx)exit;
$sql = "update {$table} set delflag='Y' where acidx='{$acidx}'";
db_query($sql);
error_msg("document.location.reload();","script");
//호텔정산 입출금 수정
}elseif($SqlType=="account_hotel_edit"){
if(!$res_no or !$hseq or !$acidx)exit;
$price_cost_plus = str_replace(",","",$price_cost_plus);
$price_cost_minus = str_replace(",","",$price_cost_minus);
$bank_plus = str_replace(",","",$bank_plus);
$bank_minus = str_replace(",","",$bank_minus);
$code_bank = base_codec("PRD","INBK",$code_bank);//통장
$sql = " update {$table} set ";
$sql .= "acc_dt='{$acc_dt}'";
$sql .= ",acnt_cd='{$acnt_cd}'";
$sql .= ",price_cost_plus='{$price_cost_plus}'";
$sql .= ",price_cost_minus='{$price_cost_minus}'";
$sql .= ",bank_plus='{$bank_plus}'";
$sql .= ",bank_minus='{$bank_minus}'";
$sql .= ",bank_cd='{$bank_cd}'";
$sql .= ",bank_nm='{$code_bank[0]['cd_nm']}'";
$sql .= ",bank_number='{$code_bank[0]['cd_memo']}'";
$sql .= ",bank_owner='{$code_bank[0]['cd_memo2']}'";
$sql .= ",edit_dt=now()";
$sql .= ",ins_mb_id='$MemberID'";
$sql .= " where res_no='{$res_no}' and hseq='{$hseq}' and acidx='{$acidx}' ";
db_query($sql);
error_msg("document.location.reload();","script");
}
?>