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
|
<? session_start(); ?>
<?php include_once("_common.php");?>
<?
$admin = str_replace("admin+","",$adminid);
include("../onlinecs/commonSTADMIN.php");
$address = $addr1;
?>
<? if($new == "y"){ //½Å±ÔÁÖ¹®
if($optregdate == "1"){
$tiqry = "INSERT INTO ordbook_m
( part, route, ordstate, ocode, ccode, orddate, deldate, bigo, shop_receiver_uname, shop_receiver_zipcode, shop_receiver_address, shop_receiver_phone01,shop_memo )
VALUE ( '1', '1', '0', '1', '$ccode', '$orddate', '$deldate', '$bigo', '$uname', '$zipcode', '$address', '$phone', '$tmemo' )";
} else {
$tiqry = "INSERT INTO ordbook_m
( part, route, ordstate, ocode, ccode, orddate, deldate, ordtime, bigo, shop_receiver_uname, shop_receiver_zipcode, shop_receiver_address, shop_receiver_phone01,shop_memo)
VALUE ( '1', '1', '0', '1', '$ccode', '$orddate', '$deldate', '$time', '$bigo', '$uname', '$zipcode', '$address', '$phone', '$tmemo' )";
}
mysql_query($tiqry);
echo $tiqry;
$mqry = "SELECT max(ordno) AS maxordno FROM ordbook_m";
$mresult = mysql_query($mqry);
$mrow = mysql_fetch_array($mresult);
$maxordno = $mrow[maxordno];
echo ($maxordno);
for($i=0;$i< count( $c_pname ) -1 ;$i++)
{
$newseq = $_REQUEST[newnum][$i]; //DB»óÇ°¹øÈ£
$pcode = $_REQUEST[c_code][$i]; //»óÇ°ÄÚµå
$pname = $_REQUEST[c_pname][$i]; //»óÇ°¸í
$pnorm = $_REQUEST[c_pnorm][$i]; //±Ô°Ý
$ordqnt = $_REQUEST[c_ordqnt][$i]; //¼ö·®
$price = $_REQUEST[c_price2][$i]; //´Ü°¡
$money = $_REQUEST[c_money2][$i]; //±Ý¾×
$bigo = $_REQUEST[c_bigo][$i]; //ºñ°í
$niqry = "INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq) VALUES ( '$pname', '$pcode', '$pnorm', '$ordqnt', '$price', '$bigo', '$maxordno', '$newseq')";
mysql_query($niqry);
$newseq++;
echo ($niqry);
echo ($maxordno);
}
?>
<script language="javascript">
parent.alert('ÀúÀå µÇ¾ú½À´Ï´Ù.');
// parent.location.href = "adminsell.php?uid=<?=$maxordno?>&detail=y&txtdate=<?=$orddate?>&txtdate2=<?=$deldate?>&cuscode=<?=$ccode?>"; //ºÎ¸ðâ »õ·Î°íħ
</script>
<?
} ELSE {
?>
<?
//»ó´Ü ÁÖ¹®ÀÏÀÚ,³³Ç°¿¹Á¤,¸Þ¸ð ¾÷µ¥ÀÌÆ®
$tqry = "UPDATE ordbook_m SET orddate = '$orddate', deldate = '$deldate', bigo = '$bigo', shop_receiver_uname = '$uname', shop_receiver_zipcode = '$zipcode' , shop_receiver_address = '$address', shop_receiver_phone01 = '$phone',shop_memo = '$tmemo' WHERE ordno = '$uid' ";
mysql_query($tqry);
echo $tqry;
echo count( $tablecount);
for($i=0;$i< count( $c_pname ) -1 ;$i++)
{
$seq = $_REQUEST[c_seq][$i]; //DB»óÇ°¹øÈ£
$pcode = $_REQUEST[c_code][$i]; //»óÇ°ÄÚµå
$pname = $_REQUEST[c_pname][$i]; //»óÇ°¸í
$pnorm = $_REQUEST[c_pnorm][$i]; //±Ô°Ý
$ordqnt = $_REQUEST[c_ordqnt][$i]; //¼ö·®
$price = $_REQUEST[c_price2][$i]; //´Ü°¡
$money = $_REQUEST[c_money2][$i]; //±Ý¾×
$bigo = $_REQUEST[c_bigo][$i]; //ºñ°í
echo ($i);
echo ($_REQUEST[c_seq][0]);
if(! $_REQUEST[c_seq][$i] == ''){ //±âÁ¸ÀÚ·áÀÏ °æ¿ì update
echo($pname.'<br>');
$uqry = "UPDATE ordbook_d SET pname = '$pname', pcode = '$pcode', pnorm = '$pnorm', ordqnt = '$ordqnt', price = '$price', bigo = '$bigo' WHERE ordno = '$uid' AND seq = '$seq'";
mysql_query($uqry);
echo($uqry.'<br>');
$newseq = $_REQUEST[c_seq][$i]+1;
} else if( $_REQUEST[c_seq][$i] == ''){ //½Å±ÔÀÚ·áÀÏ °æ¿ì insert
if(! $pcode == ''){
$iqry = "INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq) VALUES ( '$pname', '$pcode', '$pnorm', '$ordqnt', '$price', '$bigo', '$uid', '$newseq')";
mysql_query($iqry);
$newseq++;
}
echo($iqry.'<br>');
}
}
}
?>
<script>
parent.alert('ÀúÀå µÇ¾ú½À´Ï´Ù.');
</script>
|