|
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/good/ |
Upload File : |
<?
include "../include/top_proc.html";
include "_common.php";
$table = "TB_GOOD_DISCOUNT";
//$op_price_cost = str_replace(",","",$op_price_cost);
//$op_price_sell = str_replace(",","",$op_price_sell);
//$op_price_agent = str_replace(",","",$op_price_agent);
// 쌍따옴표,홑따옴표 불가 체크
/*if($SqlType == "option_ins" or $SqlType == "option_updt") {
if( isCheckQuot($op_nm) == true )
error_msg("쌍따옴표,홑따옴표는 사용불가합니다","end");
}*/
//p($_POST);
//exit;
// 옵션상품정보 입력
if ($SqlType=="discount_ins")
{
if(!$g_uid) exit;
// 상품정보
$arr = good_list(" and g_uid='{$g_uid}' ");
$row = $arr[0];
$dc_nm = str_replace("^","",$dc_nm); // 쓸수없는문자
$dc_nm = str_replace("|","",$dc_nm); // 쓸수없는문자
$sql = "insert into {$table} set ";
$sql .= " g_uid='{$row[g_uid]}' , ";
$sql .= " g_title='".$row[g_title]."' , ";
$sql .= " dc_nm='{$dc_nm}' , ";
$sql .= " dc_nm_view='{$dc_nm_view}' , ";
$sql .= " dc_rate='{$dc_rate}' , ";
$sql .= " dc_price='{$dc_price}' , ";
$sql .= " dc_people_cnt='{$dc_people_cnt}' , ";
$sql .= " dc_people_max_cnt='{$dc_people_max_cnt}', ";
$sql .= " start_date='{$start_date}', ";
$sql .= " end_date='{$end_date}', ";
$sql .= " ins_dt=now() ";
db_query($sql);
// echo "<script>alert('{$sql}');</script>";
// error_msg("alert('{$sql}');","script");
error_msg("document.location.reload();","script");
}
// 옵션상품 수정
else if($SqlType=="discount_edit")
{
if(!$dcid) exit;
$sql = "update {$table} set ";
$sql .= " dc_nm='{$dc_nm}', ";
$sql .= " dc_nm_view='{$dc_nm_view}', ";
$sql .= " onePlusOne = '{$onePlusOne}', ";
$sql .= " dc_rate='{$dc_rate}', ";
$sql .= " dc_people_cnt='{$dc_people_cnt}', ";
$sql .= " dc_people_max_cnt='{$dc_people_max_cnt}', ";
$sql .= " dc_test='{$dc_test}', ";
$sql .= " disp_yn='{$disp_yn}', ";
$sql .= " order_num='{$order_num}', ";
$sql .= " start_date='{$start_date}', ";
$sql .= " end_date='{$end_date}' ";
$sql .= " where dcid='{$dcid}'";
db_query($sql);
error_msg("document.location.reload();","script");
}
// 삭제
else if($SqlType=="discount_del")
{
if(!$g_uid or !$dcid) exit;
$sql = "delete from {$table} where dcid='{$dcid}' and g_uid='{$g_uid}' ";
db_query($sql);
error_msg("document.location.reload();","script");
}
?>