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
|
<?php
$sub_menu = "300100";
$dir = ".";
include_once($dir."/_common.php");
include("./auth_check.php"); // 관리자 권한 체크
function cate_ico($code,$f,$file_del){
Global $j3;
$dest = $j3['j3_data_path']."/ico/";
$new_file_name = "cate_{$code}";
if($file_del=='Y'){
@unlink($dest.$new_file_name);
}
if($f['name']!=''){
@mkdir($dest);
@chmod($dest,G5_DIR_PERMISSION);
move_uploaded_file($f['tmp_name'],$dest.$new_file_name);
}
}
$mode_ok = "Y";
$all_sql = "";
if($mode=='move' && $mode_ok=='Y'){ // 분류 이동
$sql = "update product_s set prod_cate_code_s = '{$n_cate_name}' where prod_cate_code_s = '{$p_cate_name}' ";
//_pr($sql); exit;
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]},";
$sql = "select * from (select aa.name from product_category_s aa where 1=1 and aa.code = '{$codes[$val]}') ax, (select count(*) as cnt from product_s a where 1=1 and a.prod_cate_code_s = '{$codes[$val]}') az ";
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
$info = mysql_fetch_array($res);
if($info['cnt']>0){
$mode_ok = "N";
$msg = "{$info['name']}:분류에 상품이 등록 사용중이라서 삭제할수 없습니다.";
}
// 이제는 천년3 카테고리가 아니라 쇼핑몰 카테고리로 빠졌기 때문에 이부분을 삭제할수 있도록 변경함
/*if($val=='1' || $val=='2' || $val=='3'){
$mode_ok = "N";
$msg = "{$info['name']}:기본분류 대/중/소는 삭제하실수 없습니다.";
}*/
if($mode_ok=='N'){ break; }
}
if($mode_ok=='Y'){
$code_list = substr($code_list,0,strlen($code_list)-1);
update_del_log("product_category_s", "code", $code_list,"del"); // 삭제 로그 처리
$sql = "delete from product_category_s where code in ({$code_list}) ";
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
}
} else if($code!='' && $mode_ok=='Y'){ // 수정
$mode = "update";
$sql = "select * from product_category_s where code = '$code' ";
$info = sql_fetch($sql,$connect_j3);
if($info['lv']=='0'){
$cate1_name = "";
$cate2_name = "";
} else {
$sql = "select * from product_category_s where code = '{$info['parent_code']}' ";
$pinfo = sql_fetch($sql,$connect_j3);
if($pinfo['lv']=='0'){
$cate1_name = $pinfo['name'];
$cate2_name = "";
} else if($pinfo['lv']=='1'){
$cate1_name = $pinfo['cate1_name'];
$cate2_name = $pinfo['name'];
}
}
$sql = "update product_category_s set
pc_use = '$pc_use', name = '$name', remarks = '{$remarks}', cate1_name = '{$cate1_name}', cate2_name = '{$cate2_name}', data_updated = now()
where code = '$code'
";
//_pr($sql); exit;
mysql_query($sql,$connect_j3); $all_sql .= $sql;
update_del_log("product_category_s", "code", $code,""); // 업데이트 로그 처리
if($info['pc_use']!=$pc_use && $info['lv']<'2'){ // 사용안함/사용함 변경시 하위분류 일괄처리 작업
if($info['lv']=='0'){
$code2sub = substr($info['code2'],0,3);
} else if($info['lv']=='1'){
$code2sub = substr($info['code2'],0,6);
}
if($code2sub!=''){
$sql = "update product_category_s set pc_use = '$pc_use' where code2 like '{$code2sub}%' ";
mysql_query($sql,$connect_j3); $all_sql .= $sql;
}
}
/*$sql = "update product_category_s set
pc_use = {$pc_use}
where pccode = '$code' ";
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql; 사용안함*/
cate_ico($code,$_FILES['ico_file'],$file_del); // 아이콘 처리
//_pr($sql); exit;
} else if($mode_ok=='Y'){ // 신규
$mode = "new";
if($pcode==''){
$lv = 0;
$pcode = "NULL";
$pc_where = "";
} else {
$sql = "select * from product_category_s where code = '$pcode' ";
$pinfo = sql_fetch($sql,$connect_j3);
$lv = ($pinfo['lv']*1)+1;
$pc = substr($pinfo['code2'],0,$lv*3);
$pc_where = " and a.code2 like '$pc%' ";
}
if($lv>=0){
$sql = "select ifnull(max(code2),0) as maxcode from product_category_s a where 1=1 and a.lv = $lv $pc_where";
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
$maxinfo=mysql_fetch_array($res);
if($maxinfo['maxcode']=='0'){
$newcode = $pc."001";
} else {
$v = (substr($maxinfo['maxcode'],$lv*3,3)*1)+1;
$newcode = $pc.str_pad($v,3,'0',STR_PAD_LEFT);
}
$new2code = str_pad($newcode,9,'0',STR_PAD_RIGHT);
if($pinfo['lv']=='0'){
$cate1_name = $pinfo['name'];
$cate2_name = "";
} else if($pinfo['lv']=='1'){
$cate1_name = $pinfo['cate1_name'];
$cate2_name = $pinfo['name'];
} else {
$cate1_name = "";
$cate2_name = "";
}
$sql = "insert into product_category_s set
pc_use = '$pc_use', parent_code = {$pcode}, code2 = '{$new2code}', name = '$name', lv = $lv,
cate1_name = '{$cate1_name}', cate2_name = '{$cate2_name}', remarks = '{$remarks}',
data_created = now(), data_updated = now()
";
//_pr($sql); exit;
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
$code = mysql_insert_id($connect_j3);
/*$sql = "insert into product_category_s set
pccode = {$code}, pc_use = {$pc_use}";
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;*/
cate_ico($code,$_FILES['ico_file'],$file_del); // 아이콘 처리
} else {
$msg = "상단 상품분류가 없습니다.";
$mode_ok = "N";
}
}
if($mode=='new' || $mode=='update'){
echo "<script>document.location.href='product_category.php';</script>";
} 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>";
}
?>
|