|
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/admin/setting/ |
Upload File : |
<?
include "../include/top_proc.html"; //공통파일 인클루드
include "_common.php";
if($SqlType=="codeb_change_flag"){ //2차코드 상태 수정
if(!$CiDX or !$delflag) exit;
$sql = "update TB_CODEB set DelFlag='{$delflag}' where CiDX='{$CiDX}' ";
db_query($sql);
$data = base_codeb("",$CiDX);
$row = $data[0];
echo "<img src='../image/btn/{$row['DelFlag2']}' onClick=\"ajax_obj_loader('basecode_setting_proc.php?SqlType=codeb_change_flag&CiDX=$CiDX&delflag={$row['DelFlag_opp']}','use_codeb_{$row['CiDX']}');\" style=\"cursor:pointer;\">";
exit;
}elseif($SqlType=="codeb_change_ordernum"){ //2차코드 순서 변경
for($i=0 ; $i < count($CiDX_arr) ; $i++){
$sql = "update TB_CODEB set OrderNum='{$OrderNum_arr[$i]}' where CiDX='$CiDX_arr[$i]'";
db_query($sql);
}
error_msg("document.location.reload()","script");
}elseif($SqlType=="codeb_edit"){//2차코드 정보 수정
if( !$CiDX or !$CdName or !$Code) exit;
//2차코드수정
$sql = "update TB_CODEB set Code='{$Code}',CdName='{$CdName}',CdMemo='{$CdMemo}',CdMemo2='{$CdMemo2}',CdImg='{$CdImg}',cd_nm_eng='$cd_nm_eng',cd_nm_cn='{$cd_nm_cn}' where CiDX='{$CiDX}'";
db_query($sql);
error_msg("document.location.reload();","script");
}elseif($SqlType=="codeb_delete"){//2차코드 삭제
if(!$CiDX) exit;
$sql = "delete from TB_CODEB where CiDX='{$CiDX}'";
db_query($sql);
error_msg("document.location.reload();","script");
}elseif($SqlType=="codeb_ins"){//2차코드 새로 저장
if(!$CodeID or !$Code or !$CdName) exit;
//TB_CODEB에 같읕코드가 있는지 체크
$data = base_codeb($CodeID,$Code);
if(count($data)>0) error_msg("입력 오류입니다.(중복된 코드가 있습니다.)","end");
//2차코드 저장
$sql = "insert into TB_CODEB set CodeID='{$CodeID}', Code='{$Code}',CdName='{$CdName}' ";
$rs = db_query($sql);
error_msg("document.location.reload();","script");
}elseif($SqlType=="codec_ins"){ //3차코드 저장
if(!$cd_a or !$cd_b or !$cd_nm or !$code)exit;
//TB_CODEB에 같읕코드가 있는지 체크
$data = base_codec($cd_a,$cd_b,$code);
if(count($data)>0) error_msg("입력 오류입니다.(중복된 코드가 있습니다.)","end");
//3차코드저장
$sql = "insert into TB_CODEC set cd_a='{$cd_a}', cd_b='{$cd_b}', cd_nm='{$cd_nm}',code='{$code}'";
db_query($sql);
error_msg("ajax_loader('basecodec_list_ajax.php?cd_a={$cd_a}&cd_b={$cd_b}','basecodec_ajax');","script");
}elseif($SqlType=="codec_edit"){ //3차코드 수정
if (!$cd_a or !$cd_b or !$cd_nm or !$code or !$seq) {
exit;
}
// 3차코드수정
if (($cd_a == "PRD") && ($cd_b == "INBK")) {
$account_number = $cd_memo;
$account_name = $cd_memo3;
$flag_use = strtoupper($cd_memo4);
$flag_use_source = strtoupper($cd_memo4_source);
$bank_code = $cd_memo5;
$phone_number = $cd_memo6;
$pca_error_message = "";
// PC알리미
if (strtoupper($cf['pca_yn']) == "Y") {
include_once("$cf[path]/Lib/pca_send_common.php");
if ($flag_use == "Y") {
$action_mode = "I";
}
else {
$action_mode = "D";
}
$socket_send_result = pca_send_WS02($action_mode, $cf['pca_customer_id'], $account_number, $account_name, $phone_number, $bank_code);
if ($socket_send_result) {
if (substr($socket_send_result, 0, 1) != "T") {
$temp_array =explode('|' , $socket_send_result);
$pca_error_message = $temp_array[1];
}
}
if (!$socket_send_result || (substr($socket_send_result, 0, 1) != "T")) {
$flag_use = $flag_use_source;
}
}
$sql = " update TB_CODEC set cd_nm = '{$cd_nm}', code = '{$code}', cd_memo = '{$account_number}', cd_memo2 = '{$cd_memo2}', cd_memo3 = '{$account_name}', cd_memo4 = '{$flag_use}', cd_memo5 = '{$bank_code}', cd_memo6 = '{$phone_number}', cd_img = '{$cd_img}', cd_nm_eng = '{$cd_nm_eng}', cd_nm_cn = '{$cd_nm_cn}' where seq = '{$seq}' ";
}
else {
$sql = "update TB_CODEC set cd_nm='{$cd_nm}',code='{$code}',cd_memo='{$cd_memo}',cd_memo2='{$cd_memo2}',cd_memo3='{$cd_memo3}',cd_img='{$cd_img}',cd_nm_eng='{$cd_nm_eng}',cd_nm_cn='{$cd_nm_cn}' where seq='{$seq}' ";
}
db_query($sql);
if ($pca_error_message) {
echo "<script type='text/javascript'>alert('" . $pca_error_message . "');</script>";
}
error_msg("to_dialog.close('{$tmp_layer_id}');ajax_loader('basecodec_list_ajax.php?cd_a={$cd_a}&cd_b={$cd_b}','basecodec_ajax');","script");
}
elseif($SqlType=="codec_delete"){ //3차코드 삭제
//deanLog("Request", $_REQUEST, "k1");
if (!$cd_a or !$cd_b or !$seq) {
exit;
}
$pca_error_message = "";
if (($cd_a == "PRD") && ($cd_b == "INBK")) {
// PC알리미
if (strtoupper($cf['pca_yn']) == "Y") {
include_once("$cf[path]/Lib/pca_send_common.php");
$sql = " select * from TB_CODEC where seq = '{$seq}' ";
$rs = db_query($sql);
$row = db_fetch_array($rs);
//deanLog("row", $row, "k1");
$account_number = $row['cd_memo'];
$account_name = $row['cd_memo3'];
$flag_use = strtoupper($row['cd_memo4']);
$bank_code = $row['cd_memo5'];
$phone_number = $row['cd_memo6'];
if ($flag_use == "Y") {
$socket_send_result = pca_send_WS02("D", $cf['pca_customer_id'], $account_number, $account_name, $phone_number, $bank_code);
if ($socket_send_result) {
if (substr($socket_send_result, 0, 1) != "T") {
$temp_array =explode('|' , $socket_send_result);
$pca_error_message = $temp_array[1];
echo "<script type='text/javascript'>alert('" . $pca_error_message . "');</script>";
}
}
}
}
}
$sql = "delete from TB_CODEC where seq='{$seq}' ";
db_query($sql);
error_msg("ajax_loader('basecodec_list_ajax.php?cd_a={$cd_a}&cd_b={$cd_b}','basecodec_ajax');","script");
}
elseif($SqlType=="codec_change_flag"){ //3차코드 상태 수정
if(!$cd_a or !$cd_b or !$seq or !$delflag) exit;
$sql = "update TB_CODEC set delflag='{$delflag}' where seq='{$seq}' ";
db_query($sql);
$data = base_codec($cd_a,$cd_b,$seq);
$row = $data[0];
echo "<img src='../image/btn/{$row['delflag2']}' onClick=\"ajax_obj_loader('basecode_setting_proc.php?SqlType=codec_change_flag&cd_a={$cd_a}&cd_b={$cd_b}&seq={$seq}&delflag={$row['delflag_opp']}','use_codec_{$seq}');\" style=\"cursor:pointer;\">";
exit;
}elseif($SqlType=="codec_change_ordernum"){ //3차코드 순서 수정
if(!$cd_a or !$cd_b) exit;
for($i=0 ; $i < count($seq_arr) ; $i++){
$sql = "update TB_CODEC set order_num='{$order_num_arr[$i]}' where seq='$seq_arr[$i]'";
db_query($sql);
}
error_msg("ajax_loader('basecodec_list_ajax.php?cd_a={$cd_a}&cd_b={$cd_b}','basecodec_ajax');","script");
}
?>