|
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/good_en/ |
Upload File : |
<?
include "../include/top_proc.html";
include "_common.php";
$table = "TB_GOOD_OPTION";
$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");
}
// 옵션상품정보 입력
if ($SqlType=="option_ins")
{
if(!$g_uid) exit;
// 상품정보
$arr = good_list(" and g_uid='{$g_uid}' ");
$row = $arr[0];
$op_nm = str_replace("^","",$op_nm); // 쓸수없는문자
$op_nm = str_replace("|","",$op_nm); // 쓸수없는문자
$sql = "insert into {$table} set ";
$sql .= " g_uid='{$row[g_uid]}' , ";
$sql .= " g_title='".$row[g_title]."' , ";
$sql .= " op_nm='{$op_nm}' , ";
$sql .= " op_price_cost='{$op_price_cost}' , ";
$sql .= " op_price_sell='{$op_price_sell}' , ";
$sql .= " op_price_agent='{$op_price_agent}' , ";
$sql .= " ins_dt=now() ";
db_query($sql);
error_msg("document.location.reload();","script");
}
// 옵션상품 수정
else if($SqlType=="option_updt")
{
if(!$g_uid or !$opid) exit;
$op_nm = str_replace("^","",$op_nm); // 쓸수없는문자
$op_nm = str_replace("|","",$op_nm); // 쓸수없는문자
$sql = "update {$table} set ";
$sql .= " op_nm='{$op_nm}', ";
$sql .= " op_price_cost='{$op_price_cost}', ";
$sql .= " op_price_sell='{$op_price_sell}', ";
$sql .= " op_price_agent='{$op_price_agent}', ";
$sql .= " order_num='{$order_num}' ";
$sql .= " where g_uid='{$g_uid}' and opid='{$opid}' ";
db_query($sql);
error_msg("document.location.reload();","script");
}
// 출력조정
else if($SqlType=="chg_disp")
{
if(!$g_uid or !$opid) exit;
$sql = "update {$table} set disp_yn='{$disp_yn}' where opid='{$opid}' and g_uid='{$g_uid}' ";
db_query($sql);
error_msg("document.location.reload();","script");
}
// 순서수정
else if($SqlType=="order_chg")
{
if(!$g_uid) exit;
for($i=0 ;$i<count($opid_arr) ;$i++)
{
$opid = $opid_arr[$i];
$order_num = $order_num_arr[$i];
if ($opid and $order_num)
{
$sql = "update {$table} set order_num='{$order_num}' where opid='{$opid}' and g_uid='{$g_uid}' ";
db_query($sql);
}
}
error_msg("document.location.reload();","script");
}
// 삭제
else if($SqlType=="option_del")
{
if(!$g_uid or !$opid) exit;
$sql = "delete from {$table} where opid='{$opid}' and g_uid='{$g_uid}' ";
db_query($sql);
error_msg("document.location.reload();","script");
}
?>