1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
|
<?php
$dir = ".";
include_once($dir."/_common.php");
//_pr($_POST); exit;
$mode_ok = "Y";
$custinfo = $cinfo;
$vattype = $custinfo['vattype']; // 고객의 부가세 부분
if($sel_del=='cart' && $mode_ok=='Y'){ // 장바구니 담기
$mode = "cart";
$od_id = get_od_id(); //세션에 저장된 주문번호 가져오고 기존 장바구니가 있으면 주문번호 변경한다.
if($dmode=='direct'){ // 바로구매일 경우 기존 장바구니를 모두 담기로 변경
init_cart($od_id);
}
$sql = "select sale_dcrate from customers where code = '{$id_ccode}' "; // 다중단가용 거래처할인율 가져오기
$cinfo = sql_fetch($sql,$connect_j3);
foreach($code_idx as $key=>$val){
$ct_state = "0";
$sql = "select '{$id_ccode}' as ccode, '{$pcode[$val]}' as pcode, a.code as opt_pcode, b.ocode, '{$ct_name[$val]}' as ct_name,
a.name as opt_name, '{$ct_price[$val]}' as ct_price, '{$opt_price[$val]}' as opt_price,
b.saleprice*b.pointrate/100 as ct_point, c.p_deli_type as ct_deli_type, '{$ct_state}' as ct_state, a.tax_yn, a.prod_cate_code,
c.p_use, c.p_soldout, c.p_price_tel, c.p_sell_tel, c.p_min_buy, c.p_max_buy, c.p_pack_buy
from product_m a
left join product_d b on a.code = b.pcode and b.ocode = 1
left join product_s c on a.code = c.pcode
where a.code in ({$opt_code[$val]})";
$res = mysql_query($sql,$connect_j3);
$ct = mysql_fetch_array($res);
$ct['jego'] = product_jego_get($ct['pcode']);
if($ct['p_use']!='1'){
$mode_ok = "N"; $msg = "{$ct['ct_name']} 상품은 판매하지 않는 상품입니다."; break;
}
if($ct['p_soldout']=='1'){
$mode_ok = "N"; $msg = "{$ct['ct_name']} 상품은 품절 상품입니다."; break;
}
if($ct['p_price_tel']=='1'){
$mode_ok = "N"; $msg = "{$ct['ct_name']} 상품은 전화문의 상품이라서 주문하실수 없습니다.";
}
if($ct['p_sell_tel']=='1'){
$mode_ok = "N"; $msg = "{$ct['ct_name']} {$configshop['sell_tel_text']}";
}
if($ct['jego']<$ws_qty[$val]){
$mode_ok = "N"; $msg = "{$ct['ct_name']} 상품의 재고가 부족합니다. 재고:{$ct['jego']}"; break;
}
if($ct['p_min_buy']*1>1 && $ct['p_min_buy']*1>$ws_qty[$val]){
$mode_ok = "N"; $msg = "{$ct['ct_name']} 상품의 최소구매수량이 {$ct['p_min_buy']} 입니다.";
}
if($ct['p_max_buy']*1>0 && $ct['p_max_buy']*1<$ws_qty[$val]){
$mode_ok = "N"; $msg = "{$ct['ct_name']} 상품의 최대구매수량이 {$ct['p_max_buy']} 입니다.";
}
if($ct['p_pack_buy']*1>1 && $ws_qty[$val]%$ct['p_pack_buy']*1!=0){
$mode_ok = "N"; $msg = "{$ct['ct_name']} 상품의 묶음구매수량이 {$ct['p_pack_buy']} 입니다.";
}
if($mode_ok=="Y"){
if($dmode=='direct'){ // 바로구매일 현재 담은 상태값을 주문(1)로 변경함
$ct['ct_state'] = '1';
}
/*if($opt_mode[$val]==''){ // 부가세 계산 위해서 처리금액 선택
$ct['vat_amt'] = $ct['opt_price'];
} else {
$ct['vat_amt'] = $ct['ct_price'];
}
if($ct['tax_yn']=='1'){ // 과세일경우 계산
$ct_vat = round($ct['vat_amt']/11);
$ct_amt = $ct['vat_amt']-$ct_vat;
} else { // 면세,영세일 경우 계산
$ct_amt = $ct['vat_amt']; $ct_vat = 0;
}*/
$ct_ck_cnt = prod_cart_has_ck($od_id, $ct['pcode'], $ct['opt_pcode'],$opt_mode[$val]);
$qty_val = $ws_qty[$val];
if($ct_ck_cnt>'0'){ // 현 주문에 이미 장바구니 담겨 있으면 업데이트 (수량은 추가됨)
if($ct['opt_mode']==''){ $ct['opt_price'] = 0; }
if($od_ids!='' || $dmode=='direct'){ // 장바구니에서 옵션 변경일때나 바로주문일경우 수량을 그냥 집어 넣는다...아닐때는 추가로 플러스 시킴
//$qty_set = " ct_qty = '{$qty_val}', ";
} else {
$qty_val = $qty_val + $ct_ck_cnt;
//$qty_set = " ct_qty = ct_qty + '{$qty_val}', ";
}
if($ct['opt_mode']==''){ $key_price = $ct['ct_price']; } else { $key_price = $ct['opt_price']; } // 부가세용 키금액 처리
$vats = vat_price_get($vattype, $ct['tax_yn'], $key_price*$qty_val); // 부가세 받아옴
$ct_amt = $vats['ct_amt']; $ct_vat = $vats['ct_vat']; $ct_tot_amt = $vats['ct_tot_amt']; // 부가세 정보 분할
$sql = "update shop_cart set
ct_name = '{$ct['ct_name']}', opt_name = '{$ct['opt_name']}', ct_price = '{$ct['ct_price']}', opt_price = '{$ct['opt_price']}', ct_tot_amt = '{$ct_tot_amt}',
ct_qty = '{$qty_val}', ct_point = '{$ct['ct_point']}', ct_deli_type = '{$ct['ct_deli_type']}', ct_state = '{$ct['ct_state']}',
ct_time = '".G5_TIME_YMDHIS."', ct_ip = '".$_SERVER['REMOTE_ADDR']."', ct_amt = '{$ct_amt}', ct_vat = '{$ct_vat}'
where od_id = '{$od_id}' and pcode = '{$ct['pcode']}' and opt_pcode = '{$ct['opt_pcode']}' and ocode = '{$ct['ocode']}' and opt_mode = '{$opt_mode[$val]}'
";
} else {
if($ct['opt_mode']==''){ $ct['opt_price'] = 0; }
if($ct['opt_mode']==''){ $key_price = $ct['ct_price']; } else { $key_price = $ct['opt_price']; } // 부가세용 키금액 처리
$vats = vat_price_get($vattype, $ct['tax_yn'], $key_price*$qty_val); // 부가세 받아옴
$ct_amt = $vats['ct_amt']; $ct_vat = $vats['ct_vat']; $ct_tot_amt = $vats['ct_tot_amt']; // 부가세 정보 분할
$sql = "insert into shop_cart set
od_id = '{$od_id}', ccode = '{$ct['ccode']}', pcode = '{$ct['pcode']}', opt_pcode = '{$ct['opt_pcode']}', ocode = '{$ct['ocode']}', ct_tot_amt = '{$ct_tot_amt}',
opt_mode = '{$opt_mode[$val]}', ct_name = '{$ct['ct_name']}', opt_name = '{$ct['opt_name']}', ct_price = '{$ct['ct_price']}', opt_price = '{$ct['opt_price']}',
ct_qty = '{$qty_val}', ct_point = '{$ct['ct_point']}', ct_deli_type = '{$ct['ct_deli_type']}', ct_state = '{$ct['ct_state']}',
ct_time = '".G5_TIME_YMDHIS."', ct_ip = '".$_SERVER['REMOTE_ADDR']."', od_time = '', ct_amt = '{$ct_amt}', ct_vat = '{$ct_vat}'
";
//echo $sql; exit;
}
$res = mysql_query($sql,$connect_j3);
}
}
} else if($sel_del=='seq' && $mode_ok=='Y'){ // 위시 수량, 순서 수정
$mode = "seq";
foreach($codes as $key=>$val){
$sql = "update shop_wish set ws_qty = '{$ws_qty[$key]}', ws_seq = '{$ws_seq[$key]}' where idx = '{$val}' ";
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
}
} else if($sel_del=='Y' && $mode_ok=='Y') { // 삭제, 선택삭제
$mode = "delete";
$code_list = "";
foreach($code_idx as $key=>$val){
$code_list .= "{$codes[$val]},";
}
if($mode_ok=='Y'){
$code_list = substr($code_list,0,strlen($code_list)-1);
update_del_log("shop_wish", "idx", $code_list,"del"); // 삭제 로그 처리
$sql = "delete from shop_wish where idx in ({$code_list}) and ccode = '{$id_ccode}' ";
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
}
} else if($idx!='' && $mode_ok=='Y'){ // 수정
$mode = "update";
/* $sql = "update shop_prod_qa set
pcode = '{$pcode}', ccode = '{$ccode}', iq_secret = '{$iq_secret}', iq_name = '{$iq_name}',
iq_subject = '{$iq_subject}', iq_question = '{$iq_question}', iq_answer = '{$iq_answer}', iq_time = '{$iq_time}'
, iq_ip = '".$_SERVER['REMOTE_ADDR']."', iq_as_time = '{$iq_as_time}'
where idx = '{$code}'
";
mysql_query($sql,$connect_j3); $all_sql .= $sql;
update_del_log("shop_prod_qa", "idx", $code,""); // 업데이트 로그 처리*/
} else {
$mode = "new";
if($mode_ok=='Y'){
$ins_cnt = 0;
foreach($opt_code as $k=>$optcode){
if($qty[$k]>0){
$sql = "insert into shop_wish set
pcode = '{$code}', ccode = '{$id_ccode}', opt_pcode = '{$optcode}',
opt_mode = '{$opt_mode[$k]}', ocode = '{$configshop['office_code']}', ws_qty = '{$qty[$k]}', ws_time = '".date("Y-m-d H:i:s",time())."'
, ws_ip = '".$_SERVER['REMOTE_ADDR']."', ws_seq = '0'
";
mysql_query($sql,$connect_j3); $all_sql .= $sql;
//echo $sql;
$ins_cnt++;
}
}
}
if($ins_cnt==0){
$mode_ok='N';
$msg='이미 저장된 상품이거나 오류가 났습니다.';
}
}
echo "<?php xml version='1.0' encoding='utf-8'?><output>";
echo "<mode>".$mode."</mode>";
echo "<mode_ok>".$mode_ok."</mode_ok>";
echo "<dmode>".$dmode."</dmode>";
echo "<rtn_url>".$rtn_url."</rtn_url>";
echo "<msg>".$msg."</msg>";
//echo "<sql>".$all_sql."</sql>";
echo "</output>";
?>
|