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
|
<?php
$dir = ".";
include_once($dir."/_common.php");
$mode_ok = "Y";
$all_sql = "";
if($sel_del=="R" && $mode_ok=='Y'){ // 쿠폰 사용 초기화
$mode = "release";
$code_list = "";
if($mode_ok=='Y'){
foreach($code_idx as $key=>$val){
coupon_set_do("",$od_id[$val],"release");
}
}
} else if($sel_del=="D" && $mode_ok=='Y'){ // 쿠폰리스트 삭제
$mode = "cp_del";
$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_coupon_list", "idx", $code_list,"del"); // 삭제 로그 처리
$sql = "delete from shop_coupon_list where idx in ({$code_list}) ";
$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_coupon", "idx", $code_list,"del"); // 삭제 로그 처리
$sql = "delete from shop_coupon where idx in ({$code_list}) ";
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
}
} else if($code!='' && $mode_ok=='Y'){ // 수정
$mode = "update";
if($qa_reply!=''){
$rep_date = " , rep_date = now() ";
}
$sql = "update shop_coupon set
cp_name = '{$cp_name}', cp_desc = '{$cp_desc}', cp_kind = '{$cp_kind}',
cp_kind_des = '{$cp_kind_des}', cp_mem_id = '{$cp_mem_id}', cp_sdate = '{$cp_sdate}', cp_edate = '{$cp_edate}',
cp_type = '{$cp_type}', cp_price = '{$cp_price}', cp_min = '{$cp_min}', cp_cnt = '{$cp_cnt}', cp_use = '{$cp_use}', cp_memo = '{$cp_memo}'
where idx = '{$code}'
";
//_pr($sql); exit;
mysql_query($sql,$connect_j3); $all_sql .= $sql;
update_del_log("shop_coupon", "idx", $code,""); // 업데이트 로그 처리
} else if($mode_ok=='Y'){ // 신규
$mode = "new";
$sql = "select count(*) as cnt from shop_coupon where cp_id = '{$cp_id}' ";
$info = sql_fetch($sql,$connect_j3);
if($info['cnt']>0){
$mode_ok = "N";
$msg = "이미 등록된 쿠폰번호 입니다.";
} else{
$sql = "insert into shop_coupon set
cp_id = '{$cp_id}', cp_name = '{$cp_name}', cp_desc = '{$cp_desc}', cp_kind = '{$cp_kind}',
cp_kind_des = '{$cp_kind_des}', cp_mem_id = '{$cp_mem_id}', cp_sdate = '{$cp_sdate}', cp_edate = '{$cp_edate}',
cp_type = '{$cp_type}', cp_price = '{$cp_price}', cp_min = '{$cp_min}', cp_cnt = '{$cp_cnt}', cp_use = '{$cp_use}', cp_memo = '{$cp_memo}',
cp_reg_date = now()
";
//_pr($sql); exit;
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
$code = mysql_insert_id($connect_j3);
}
}
//_pr($_POST); exit;
echo "<?php xml version='1.0' encoding='utf-8'?><output>";
echo "<mode>".$mode."</mode>";
echo "<mode_ok>".$mode_ok."</mode_ok>";
echo "<rtn_url>".$rtn_url."</rtn_url>";
echo "<msg>".$msg."</msg>";
echo "<after_add>".$after_add."</after_add>";
//echo "<sql>".$all_sql."</sql>";
echo "</output>";
?>
|