|
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/ |
Upload File : |
<?
include "../include/top_proc.html";
include "_common.php";
$table = "TB_GOOD_DEPOT";
$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($depot_nm) == true )
error_msg("쌍따옴표,홑따옴표는 사용불가합니다","end");
}
// 옵션상품정보 입력
if ($SqlType=="option_ins")
{
if(!$g_uid) exit;
// 상품정보
$arr = good_list(" and g_uid='{$g_uid}' ");
$row = $arr[0];
$depot_nm = str_replace("^","",$depot_nm); // 쓸수없는문자
$depot_nm = str_replace("|","",$depot_nm); // 쓸수없는문자
$sql = "insert into {$table} set ";
$sql .= " g_uid='{$row[g_uid]}' , ";
$sql .= " g_title='".$row['g_title']."' , ";
$sql .= " depot_nm='{$depot_nm}' , ";
$sql .= " ins_dt=now() ";
db_query($sql);
error_msg("document.location.reload();","script");
}
// 옵션상품 수정
else if($SqlType=="option_updt")
{
if(!$g_uid or !$poid) exit;
$depot_nm = str_replace("^","",$depot_nm); // 쓸수없는문자
$depot_nm = str_replace("|","",$depot_nm); // 쓸수없는문자
$sql = "update {$table} set ";
$sql .= " depot_nm='{$depot_nm}', ";
$sql .= " order_num='{$order_num}' ";
$sql .= " where g_uid='{$g_uid}' and poid='{$poid}' ";
db_query($sql);
error_msg("document.location.reload();","script");
}
// 출력조정
else if($SqlType=="chg_disp")
{
if(!$g_uid or !$poid) exit;
$sql = "update {$table} set disp_yn='{$disp_yn}' where poid='{$poid}' 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($poid_arr) ;$i++)
{
$poid = $poid_arr[$i];
$order_num = $order_num_arr[$i];
if ($poid and $order_num)
{
$sql = "update {$table} set order_num='{$order_num}' where poid='{$poid}' and g_uid='{$g_uid}' ";
db_query($sql);
}
}
error_msg("document.location.reload();","script");
}
// 삭제
else if($SqlType=="option_del")
{
if(!$g_uid or !$poid) exit;
$sql = "delete from {$table} where poid='{$poid}' and g_uid='{$g_uid}' ";
db_query($sql);
error_msg("document.location.reload();","script");
}
?>