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
|
<?php
$dir = ".";
include_once($dir."/_common.php");
function upload_ev_file($file,$code){ // 이벤트 파일 업로드
Global $j3, $_POST;
@extract($j3);
if($code==''){ return; }
foreach($file as $key=>$f){
$dest = $j3['j3_data_path']."/ico/";
$new_file_name = "{$key}_{$code}";
if($_POST[$key.'_del']=='1'){
unlink($dest.$new_file_name);
}
if($f['name']!='' && $f['size']>0){
move_uploaded_file($f['tmp_name'],$dest.$new_file_name);
@chmod($dest.$new_file_name, G5_FILE_PERMISSION);
}
}
}
function event_product($ev_code){ // 이벤트 상품 처리
Global $j3, $_POST, $configshop;
@extract($j3);
@extract($_POST);
if($ev_code==''){ return; }
$sql = "delete from shop_event_prod where ev_idx = '{$ev_code}' "; // 기존 상품 삭제
mysql_query($sql,$connect_j3);
foreach($ccode as $key=>$val){
if($configshop['ev_cart_saleprice']=='1' && table_field_ck("shop_event_prod", "ev_saleprice")){
$add_set = ", ev_saleprice = '$ev_saleprice[$key]' ";
}
$sql = "insert into shop_event_prod set
ev_idx = '{$ev_code}', pcode = '{$val}', seq = '{$prod_seq[$key]}' {$add_set}
";
mysql_query($sql,$connect_j3);
}
}
//_pr($_POST); exit;
$mode_ok = "Y";
$all_sql = "";
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_event", "idx", $code_list,"del"); // 삭제 로그 처리
$sql = "delete from shop_event where idx in ({$code_list}) ";
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
$sql = "delete from shop_event_prod where ev_idx in ({$code_list})"; // 이벤트 상품 삭제
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
}
} else if($code!='' && $mode_ok=='Y'){ // 수정
$mode = "update";
//_pr($_FILES); exit;
if($add_type_ck=='1'){ $ev_type = $add_type_name; }
$sql = "update shop_event set
ev_type = '{$ev_type}', ev_subject = '{$ev_subject}', ev_width = '{$ev_width}', ev_height = '{$ev_height}',
ev_width_m = '{$ev_width_m}', ev_height_m = '{$ev_height_m}', ev_row_cnt = '{$ev_row_cnt}', ev_col_cnt = '{$ev_col_cnt}',
ev_cnt_m = '{$ev_cnt_m}', ev_hd_content = '{$ev_hd_content}', ev_ft_content = '{$ev_ft_content}', ev_use = '{$ev_use}'
where idx = '$code'
";
//_pr($sql); exit;
mysql_query($sql,$connect_j3); $all_sql .= $sql;
update_del_log("shop_event", "idx", $code,""); // 업데이트 로그 처리
upload_ev_file($_FILES,$code);
event_product($code);
} else if($mode_ok=='Y'){ // 신규
$mode = "new";
if($add_type_ck=='1'){ $ev_type = $add_type_name; }
if($ev_type==''){
$mode_ok = "N";
$msg = "이벤트분류코드를 추가하시기 바랍니다.";
alert($msg); exit;
}
if($mode_ok=='Y'){
$sql = "insert into shop_event set
ev_type = '{$ev_type}', ev_subject = '{$ev_subject}', ev_width = '{$ev_width}', ev_height = '{$ev_height}',
ev_width_m = '{$ev_width_m}', ev_height_m = '{$ev_height_m}', ev_row_cnt = '{$ev_row_cnt}', ev_col_cnt = '{$ev_col_cnt}',
ev_cnt_m = '{$ev_cnt_m}', ev_hd_content = '{$ev_hd_content}', ev_ft_content = '{$ev_ft_content}', ev_use = '{$ev_use}',
reg_date = now()
";
//_pr($sql); exit;
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
$code = mysql_insert_id($connect_j3);
upload_ev_file($_FILES,$code);
event_product($code);
}
}
//_pr($_POST); exit;
if($mode=='new' || $mode=='update'){
?>
<script>
document.location.href='<?php echo $j3_adm_url;?>/event.php?<?php echo $_COOKIE['qstr'];?>';
</script>
<?php
} else {
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>";
}
?>
|