|
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/exchange/ |
Upload File : |
<?
include "../include/top_proc.html"; // 공통파일 인클루드
$ext_to_krw = str_replace(",","",$ext_to_krw);
// 환율저장
if($SqlType=="exchange_ins"){
if(!$ext_nm or !$ext_to_krw) exit;
$sql = "insert into TB_EXCHANGE set ";
$sql .= " ext_nm='{$ext_nm}', ";
$sql .= " ext_eng='{$ext_eng}', ";
$sql .= " ext_mark='{$ext_mark}', ";
$sql .= " ext_to_krw='{$ext_to_krw}', ";
$sql .= " ext_unit='{$ext_unit}', ";
$sql .= " ext_round='{$ext_round}', ";
$sql .= " ins_dt=now() ";
db_query($sql);
error_msg("parent.document.location.reload();","script");
}
// 사용상태 변경
elseif($SqlType=="use_change"){
if(!$exid) exit;
$sql = "update TB_EXCHANGE set del_fg='{$delflag}' where exid='{$exid}' ";
db_query($sql);
$m = new CommonTour();
$data = $m->exchangeList($rdata=array("sql_where"=>" and exid='{$exid}' "));
$r = $data[0];
echo "<img src=\"{$r[del_fg_icon]}\" onclick=\"ajax_obj_loader('exchange_proc.html?SqlType=use_change&exid={$r[exid]}&delflag={$r[del_fg_opp]}','delflag_{$r[exid]}')\" style='cursor:pointer;' />";
exit;
}
// 환율수정
elseif($SqlType=="exchange_updt"){
if(!$exid or !$ext_nm or !$ext_to_krw) exit;
$sql = "update TB_EXCHANGE set ";
$sql .= " ext_nm='{$ext_nm}', ";
$sql .= " ext_eng='{$ext_eng}', ";
$sql .= " ext_mark='{$ext_mark}', ";
$sql .= " ext_to_krw='{$ext_to_krw}', ";
$sql .= " ext_unit='{$ext_unit}', ";
$sql .= " ext_round='{$ext_round}', ";
$sql .= " edit_id='{$TO_MB[mb_id]}', ";
$sql .= " edit_nm='{$TO_MB[mb_nm]}', ";
$sql .= " edit_dt=now() ";
$sql .= " where exid={$exid} ";
db_query($sql);
// 호텔상품 최저가 업데이트
if($cf['tab']['L']=="Y"){
$sql = "SELECT a.hseq FROM TB_HOTEL a WHERE disp_yn='Y' AND exchange_fg='Y' AND (SELECT COUNT(*) FROM TB_HOTEL_DATE b WHERE a.hseq=b.h_seq AND b.room_date > CURDATE()) > 0 ";
$rs = db_query($sql);
while($r = db_fetch_array($rs)){
db_query("call SP_HOTEL_PRICE_LOWHIGH('".$r['hseq']."');");
}}
error_msg("document.location.reload();","script");
}
// 환율삭제
elseif($SqlType=="ex_delete"){
if(!$exid) exit;
$sql = "delete from TB_EXCHANGE where exid={$exid} ";
db_query($sql);
error_msg("document.location.reload();","script");
}
// 순서수정
elseif($SqlType=="order_chg"){
for($i=0 ; $i<count($exid_arr) ; $i++) {
$exid = $exid_arr[$i];
$order_num = $ordernum_arr[$i];
if($exid) {
$sql ="update TB_EXCHANGE set order_num='{$order_num}' where exid='{$exid}' ";
db_query($sql);
}
}
error_msg("document.location.reload();","script");
}
//1HKD당 TWD 수정
elseif($SqlType=="tw_ins"){
//if(!$ex_tw) exit;
$sql = "update TB_HWANYULL set ";
$sql .= " price_tw_hk='{$ex_tw}' ";
$sql .= " where seq='{$seq}' ";
db_query($sql);
echo $sql;
//error_msg("location.href='exchange_admin.html'","script");
}