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
|
<?php
$sub_menu = "100200";
$dir = ".";
include_once($dir."/_common.php");
include("./auth_check.php"); // 관리자 권한 체크
function options_update($key,$val){
Global $connect_j3;
$sql = "select count(*) as cnt from options where optname = '{$key}' ";
$cnt_info = sql_fetch($sql,$connect_j3);
if($cnt_info['cnt']>0){
$sql = "update options set optvalue = '{$val}' where optname = '{$key}' ";
} else {
$sql = "insert into options set optvalue = '{$val}', optname = '{$key}' ";
}
mysql_query($sql,$connect_j3);
}
$mode_ok = "Y";
//_pr($_POST);
/*$sql = "select * from bankbook where 1=1 and hidden = 0 and ocode = '{$configshop['office_code']}' order by nidx"; // 통장 정보를 가져옴
$res = mysql_query($sql,$connect_j3);
while($info=mysql_fetch_array($res)){
$account_array[] = $info;
} */
$account_array = bankbook_get();
$_POST['deli_amount'] = preg_replace("/[^-0-9]/", "", $_POST['deli_amount']);
$_POST['deli_price'] = preg_replace("/[^-0-9]/", "", $_POST['deli_price']);
$_POST['po_join'] = preg_replace("/[^-0-9]/", "", $_POST['po_join']);
$_POST['po_minpoint'] = preg_replace("/[^-0-9]/", "", $_POST['po_minpoint']);
$_POST['po_maxpoint'] = preg_replace("/[^-0-9]/", "", $_POST['po_maxpoint']);
$_POST['deli_comp_day'] = preg_replace("/[^0-9]/", "", $_POST['deli_comp_day']);
$sql = "select coun(*) as cnt from offices where code = '{$office_code}'";
$info = sql_fetch($sql,$connect_j3);
if($info['cnt']=='0'){
alert('사업장 정보가 없습니다.');
}
$sql = "update offices set
comp_name = '{$comp_name}', ceo_name = '{$ceo_name}', comp_sn = '{$comp_sn}', telno1 = '{$telno1}',
hpno = '{$hpno}', faxno = '{$faxno}', zipcode = '{$zipcode}', addr_m = '{$addr_m}',
addr_d = '{$addr_d}'
where code = '{$office_code}'
";
mysql_query($sql,$connect_j3);
update_del_log("offices", "code", $office_code,""); // 업데이트 로그 처리
$idx = 0;
foreach($nidx as $key=>$val){
if($val==''){
if($shop_bank=="1"){ $add_sql = ", shopyn = '1'"; } else { $add_sql = ""; }
$sql = "insert into bankbook set
bankcode ='{$bankcode[$idx]}', ocode = '{$configshop['office_code']}', name= '쇼핑몰통장', acntnumber = '{$acntnumber[$idx]}',
accountholder = '{$accountholder[$idx]}',hidden = '0',data_created = '".G5_TIME_YMDHIS."' {$add_sql}
";
// bankbook_begin 테이블 추가 하는 문구 넣어야됨
$sql_begin = "insert into bankbook_begin set
yyyymm = '0', bankbook_code = '[bank_code]', begin_amount = 0, data_created = '".date("Y-m-d H:i:s",time())."', data_creator ='1', data_updater = '1' ";
} else {
$sql = "update bankbook set
bankcode ='{$bankcode[$idx]}', ocode = '{$configshop['office_code']}', acntnumber = '{$acntnumber[$idx]}',
accountholder = '{$accountholder[$idx]}',data_updated = '".G5_TIME_YMDHIS."'
where nidx = '{$val}'
";
$sql_begin = "";
}
mysql_query($sql,$connect_j3);
$bank_code = mysql_insert_id($connect_j3);
if($sql_begin!=''){ // 계좌 추가일경우 bankbook_begin 레코드 추가함
$sql_begin = str_replace("[bank_code]",$bank_code,$sql_begin);
mysql_query($sql_begin,$connect_j3);
}
$idx++;
}
update_del_log("bankbook", "ocode", $configshop['office_code'],"bankbook"); // 업데이트 로그 처리
foreach($account_array as $key=>$val){
$del_flag = "Y";
for($i=0;$i<count($nidx);$i++){
if($nidx[$i]==$val['nidx']){
$del_flag = "N";
}
}
if($del_flag=='Y'){
update_del_log("bankbook_begin", "bankbook_code", $val['nidx'],"del"); // 삭제 로그 처리
$sql = "delete from bankbook_begin where bankbook_code = '{$val['nidx']}' ";
mysql_query($sql,$connect_j3);
update_del_log("bankbook", "nidx", $val['nidx'],"del"); // 삭제 로그 처리
$sql = "delete from bankbook where nidx = '{$val['nidx']}' ";
mysql_query($sql,$connect_j3);
}
}
$key_cnt = 0;
foreach($_POST as $key=>$val){
$pass = "N";
if($key_cnt>=1 && $key_cnt<=9){ // comp_name ~ addr_d 까지 그사이 필드가 변경되면 숫자 보정해야됨
$pass = "Y"; // offices 테이블에 저장할거는 그냥 넘어간다.
}
if($key_cnt>=18 && $key_cnt<=21){ // nidx[] ~ accountholder[] 까지 nidx앞쪽의 필드가 변경되면 숫자 보정해야됨(은행계좌번호 처리 부분)
$pass = "Y"; // offices 테이블에 저장할거는 그냥 넘어간다.
}
if($key=='shop_basic_multi_price_no'){
$pass = "Y";
options_update($key,$val);
}
if(substr($key,0,7)=='imgdel_'){ // 로고/배너/아이콘관련 삭제 처리작업
$pass = "Y";
if($val=='1'){
$img_name = substr($key,7,strlen($key));
unlink($j3_data_path."/ico/".$img_name);
}
}
if($pass == "N"){
$sql = "select count(*) as cnt from user_config where menu_name = 'shop_config_shop' and config_key = '$key' ";
$cnt_info = sql_fetch($sql,$connect_j3);
if($cnt_info['cnt']>0){
$sql = "update user_config set config_val = '$val' where menu_name = 'shop_config_shop' and config_key = '$key'";
} else {
$sql = "insert into user_config set config_val = '$val', menu_name = 'shop_config_shop', config_key = '$key'";
}
mysql_query($sql,$connect_j3);
}
$key_cnt++;
}
update_del_log("user_config", "menu_name", "shop_config_shop","config_shop"); // 업데이트 로그 처리
foreach($_FILES as $key=>$f){ // 로고파일 업로드
if($f['name']!=''){
$dest = $j3['j3_data_path']."/ico/";
$new_file_name = $key;
move_uploaded_file($f['tmp_name'],$dest.$new_file_name);
}
}
if($pg_service=='uplus' && $pg_id!='' && $pg_key!=''){ // lguplus mall.conf 갱신
$mallfile = "{$j3_shop_path}/xpay/lgdacom/conf/mall.conf";
$mallfilem = "{$j3_shopm_path}/xpay/lgdacom/conf/mall.conf";
if(!is_writable($mallfile)){ alert("{$j3_shop_url}/xpay/lgdacom/conf/mall.conf 에 쓰기권한을 주시기 바랍니다."); exit; }
if(!is_writable($mallfilem)){ alert("{$j3_shopm_url}/xpay/lgdacom/conf/mall.conf 에 쓰기권한을 주시기 바랍니다."); exit; }
$f = fopen($mallfile,"r");
$cont = fread($f,4096);
fclose($f);
$vv = explode(";;;;;;;;;;",$cont);
$new_cont = $vv[0].";;;;;;;;;;".chr(10)."t".$pg_id." = ".$pg_key.chr(10).$pg_id." = ".$pg_key.chr(10);
$f = fopen($mallfile,"w");
fwrite($f,$new_cont);
fclose($f);
$f = fopen($mallfilem,"w");
fwrite($f,$new_cont);
fclose($f);
$log_dir = "{$j3_shop_path}/xpay/lgdacom/log";
@chmod($log_dir,G5_DIR_PERMISSION);
$log_dir = "{$j3_shopm_path}/xpay/lgdacom/log";
@chmod($log_dir,G5_DIR_PERMISSION);
}
?>
<script>
document.location.href='<?php echo $j3_adm_url;?>/config_shop.php';
</script>
|