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
|
<? session_start(); ?>
<?
if(( $id == "" ) && ( $sid == "" )) {
?>
<script>
alert("e¼ö¹ßÁÖ ·Î±×ÀÎ ÈÄ¿¡ ÀÌ¿ë°¡´ÉÇÕ´Ï´Ù.");
location.href = "../onlinecs/intro.php";
</script>
<?
}
include("../onlinecs/commonST.php");
$qry = "SELECT * FROM customer WHERE loginid = '$id'";
$result = mysql_query($qry) or die (mysql_error());
if( mysql_num_rows($result) > 0){
$row = mysql_fetch_array($result);
// mysql_close();
$salestop = $row[salestop];
$salestopbigo = $row[stopsalebigo];
}
if( $salestop == "1"){ //°Å·¡ÁßÁöÀÎ °æ¿ì
?>
<script>
parent.alert('±Í»ç¿¡ ´ëÇÑ ¿Â¶óÀÎ ÁÖ¹®ÀÌ\nÇã¿ëµÇÁö ¾Ê¾Æ ÁÖ¹® ÇÒ ¼ö ¾ø½À´Ï´Ù.\nÁßÁö»çÀ¯: <?=$salestopbigo;?> ');
parent.location.href="buy.php";
</script>
<?
} else {
if($new == "y"){ //½Å±ÔÁÖ¹®
if($optregdate == "1"){
$tiqry = "INSERT INTO ordbook_m ( part, route, ordstate, ocode, ccode, orddate, deldate, bigo) VALUE ( '1', '1', '0', '$ocode', '$ccode', '$orddate', '$deldate', '$bigo')";
} else {
$tiqry = "INSERT INTO ordbook_m ( part, route, ordstate, ocode, ccode, orddate, deldate, ordtime, bigo) VALUE ( '1', '1', '0', '$ocode', '$ccode', '$orddate', '$deldate', '$time', '$bigo')";
}
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 = "buy.php?uid=<?=$maxordno?>&detail=y&txtdate=<?=$txtdate?>&txtdate2=<?=$txtdate2?>"; //ºÎ¸ðâ »õ·Î°íħ
</script>
<?
} ELSE {
?>
<?
//»ó´Ü ÁÖ¹®ÀÏÀÚ,³³Ç°¿¹Á¤,¸Þ¸ð ¾÷µ¥ÀÌÆ®
$tqry = "UPDATE ordbook_m SET orddate = '$orddate', deldate = '$deldate', bigo = '$bigo' 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>
<? } ?>
|