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
|
<?php
$dir = ".";
include_once($dir."/_common.php");
$mode_ok = "Y";
if($eid==''){
$mode = "x"; $mode_ok = "N";
$msg = "e천년경영 로그인 후에 이용가능합니다.";
}
$all_sql = "";
@extract($_POST);
$buyprice = preg_replace("/[^0-9]/", "", $buyprice);
$saleprice = preg_replace("/[^0-9]/", "", $saleprice);
if($sel_del=='Y' && $mode_ok=='Y'){ // 상품 삭제
$mode = "delete";
$code_list = "";
foreach($code_idx as $key=>$val){
$code = $codes[$val];
$code_list .= "{$code},";
$sql = "select sum(a.cnt) as cnt2, b.name, b.code1
from ( select count(*) as cnt from sale_d where pcode = '{$code}' union select count(*) as cnt from buy_d where pcode = '{$code}' ) a , product_m b where b.code = '{$code}' ";
$res = mysql_query($sql,$connect_e1000y); $all_sql .= $sql;
$info = mysql_fetch_array($res);
if($info['cnt2']>0){
$mode_ok = "N";
$msg = "{$info['name']}({$info['code1']})상품이 매출/매입 전표를 사용중이라서 삭제할수 없습니다.";
}
if($mode_ok=='N'){ break; }
}
if($mode_ok=='Y'){
$code_list = substr($code_list,0,strlen($code_list)-1);
$sql = "delete from product_d where pcode in ({$code_list}) ";
$res = mysql_query($sql,$connect_e1000y); $all_sql .= $sql;
$sql = "delete from product_m where code in ({$code_list}) ";
$res = mysql_query($sql,$connect_e1000y); $all_sql .= $sql;
}
} else if($code!='' && $mode_ok=='Y'){ // 상품 수정
$mode = "update";
$sql = "update product_m set
prod_cate_code = '$prod_cate_code', prod_cate_code2 = '$prod_cate_code2', name = '$name', norm = '$norm',
pce_bcode1 = '$pce_bcode1', tax_yn = '$tax_yn', unit = '$unit',
remarks = '$remarks', prod_wt = '$prod_wt', data_updated = now()
where code = '$code'
";
mysql_query($sql,$connect_e1000y); $all_sql .= $sql;
$sql = "update product_d set
buyprice = '$buyprice', saleprice = '$saleprice', data_updated = now()
where pcode = '$code'
";
//_pr($sql);
mysql_query($sql,$connect_e1000y); $all_sql .= $sql;
} else if($mode_ok=='Y'){ // 거래처 신규
$mode = "new";
if($code_auto=='1'){
$sql = "select max(code1) as maxcode from product_m a where 1=1 ";
$res = mysql_query($sql,$connect_e1000y); $all_sql .= $sql;
$info = mysql_fetch_array($res);
$maxcode = ($info['maxcode']*1)+1;
$maxcode = str_pad($maxcode,6,'0',STR_PAD_LEFT);
} else {
$sql = "select count(*) as cnt from product_m a where code1 = '{$code1}' ";
$res = mysql_query($sql,$connect_e1000y); $all_sql .= $sql;
$info = mysql_fetch_array($res);
if($info['cnt']>0){
$msg = "이미 등록된 코드 입니다.";
$mode_ok = "N";
}
$maxcode = $code1;
}
if($mode_ok=='Y'){
$sql = "insert into product_m set
code1 = '$maxcode',
prod_cate_code = '$prod_cate_code', prod_cate_code2 = '$prod_cate_code2', name = '$name', norm = '$norm',
pce_bcode1 = '$pce_bcode1', tax_yn = '$tax_yn', unit = '$unit',
remarks = '$remarks', prod_wt = '$prod_wt', data_created = now()
";
$res = mysql_query($sql,$connect_e1000y); $all_sql .= $sql;
$last_idx = mysql_insert_id($connect_e1000y);
if($last_idx*1>0){
$sql = "insert into product_d set
pcode = '$last_idx', ocode = '1',
buyprice = '$buyprice', saleprice = '$saleprice', data_updated = now()
";
$res = mysql_query($sql,$connect_e1000y); $all_sql .= $sql;
}
}
}
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 "<sql>".$all_sql."</sql>";
echo "</output>";
?>
|