001.<?php
002.include "chksession.php";
003.include "header.php";
004.include "connect.php";
005.
006.
007.
008.
009. if($_GET["Action"]=="Delete")
010. {
011.
012. $sql_del= "delete from extra where ex_id='".$_GET["ex_id"]."'";
013. $dbquery_del = mysql_query($sql_del);
014. echo"<script language='JavaScript'>";
015. echo"alert('ลบข้อมูลเรียบร้อยแล้ว');";
016. echo"window.location='extralist.php';";
017. echo"</script>";
018. }
019.
020.if($_GET[id]) {
021. $ex_id=$_GET[id];
022. $sql="select * From extra where ex_id='$ex_id'";
023. $rst=mysql_query($sql);
024. $arr=mysql_fetch_array($rst);
025. if($arr[ex_type]=="เดิม"){
026.
027.
028. mysql_query("Update suite Set suite_amount=suite_amount+$arr[suite_amount] Where suite_name='$arr[suite_name]' and suite_size='$arr[suite_size]'");
029.
030.
031.
032. }elseif($arr[ex_type]=="ใหม่"){
033.
034. $sqlinsert="Insert into suite values ('','$arr[type_id]','$arr[suite_name]','$arr[suite_size]','$arr[suite_detail]','$arr[suite_price_rent]','$arr[suite_price_cut]','$arr[suite_image]','$arr[suite_amount]' )";
035. mysql_query($sqlinsert);
036. }
037. mysql_query("Update extra Set ex_status='ตัดเสร็จแล้ว' Where ex_id='$ex_id'");
038.
039. echo"<center>บันทึกตัดชุดเรียบร้อยแล้ว</center>";
040. echo"<meta http-equiv=\"refresh\" content=\"3; url=extralist.php\" />";
041. include "footer.php";
042. exit;
043.}
044.
045.?>
046.<title>ข้อมูลการสั่งตัด</title>
047.<table width="1000" border="0" align="center" bgcolor="#FFFFFF">
048.<tr>
049.<td width="10%" height="23" align="left" valign="top" bgcolor="#FF99FF">
050. <?php
051. if($_SESSION[sess_position]==2){
052. include "menu1.php";
053. }else{
054. include "menu2.php";
055. }
056. ?>
057. </td>
058.<td valign="top" bgcolor="#FFFFFF"><table width="94%" border="0" align="center">
059. <tr>
060. <td align="left" valign="top"><p align="center">
061. <table width="90%" border="0" align="center">
062. <tr>
063. <td align="center"><form id="form1" name="form1" method="post" action="<? $PHP_SELF ?>">
064. <table width="78%" border="0">
065. <tr>
066. <td height="191" align="left"><fieldset>
067. <legend><strong>ค้นหาข้อมูลการจองชุด</strong></legend>
068. <p> </p>
069. <center>
070. <table width="100%" border="0">
071. <tr>
072. <td width="20%" align="left"><strong>ใส่คำค้นหา : </strong></td>
073. <td width="19%" align="left"><label>
074. <select name="type" id="type">
075. <option value="">---เลือก---</option>
076. <option value="o_id">รหัสรายการ</option>
077. <option value="cus_name">ชื่อลูกค้า</option>
078. </select>
079. </label>
080. </td>
081. <td width="20%" align="left"><strong>รายละเอียด :</strong></td>
082. <td width="29%" align="left"><input type="text" name="keyword" id="keyword" /></td>
083. <td width="12%" align="left"><input type="submit" name="button" id="button" value="ค้นหา" /></td>
084. </tr>
085. </table>
086. <p> </p>
087. </center>
088. </fieldset></td>
089. </tr>
090. </table>
091. </form></td>
092. </tr>
093. </table>
094. <p align="center">
095.
096. <p align="center"><strong>ข้อมูลการสั่งตัดชุด</strong>
097. <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#999999">
098. <tr align="center" bgcolor="#FF9900">
099. <td width="5%" bgcolor="#FF66FF">ลำดับ</td>
100. <td width="15%" bgcolor="#FF66FF">วันที่สั่งตัด</td>
101. <td width="21%" bgcolor="#FF66FF">ชื่อชุด</td>
102. <td width="4%" bgcolor="#FF66FF">ไซส์</td>
103. <td width="7%" bgcolor="#FF66FF">จำนวน </td>
104. <td width="8%" bgcolor="#FF66FF">ประเภท</td>
105. <td width="18%" bgcolor="#FF66FF">สถานะ</td>
106. <td width="10%" bgcolor="#FF66FF">รายละเอียด</td>
107. <td width="6%" bgcolor="#FF66FF">ลบ</td>
108. </tr>
109. <?
110. $sql="select * From extra order by ex_id desc";
111. $rst=mysql_query($sql);
112. $nrowpage=mysql_num_rows($rst);
113.
114. $list_page = 10; if (empty($page)) { $page=1; }
115. $rt = $nrowpage%$list_page;
116. if($rt != 0) { $totalpage = floor($nrowpage/$list_page)+1; } else { $totalpage = floor($nrowpage/$list_page); }
117. $goto = ($page-1)*$list_page;
118. $sql .= " limit $goto, $list_page ";
119. $rst=mysql_query($sql);
120.
121. while ($row=mysql_fetch_array($rst)){
122. $start++;
123. ?>
124. <tr align="center" bgcolor="#FFFFFF">
125. <td><? echo $start ?></td>
126. <td><? echo DateThai($row[ex_date],1); ?></td>
127. <td><? echo $row[suite_name] ?></td>
128. <td><? echo $row[suite_size] ?></td>
129. <td><? echo $row[suite_amount] ?></td>
130. <td><? echo $row[ex_type] ?></td>
131. <td><? echo $row[ex_status ] ?>
132.
133. <? if($row[ex_status]=="สั่งตัด" and $_SESSION[sess_position]==3) {?>
134.
135. <a href="extralist.php?id=<? echo $row[ex_id] ?>"
136. onclick="javascript:if(!confirm('ตัดชุดเสร็จแล้ว?'))return false;">[เสร็จแล้ว]</a>
137. <? } ?> </td>
138. <td><a href="extradetail.php?id=<? echo $row[ex_id];?>"><img src="inc/31.png" width="33" height="23" border="0" /></a></td>
139. <td width="36" bgcolor="#FFFFFF"><div align="center"><a href="<?=$_SERVER['PHP_SELF'];?>?Action=Delete&ex_id=<?=$result["ex_id"];?>" onClick="return Conf<?=$result["ex_id"]; ?>(this)"><img src="inc/delete.gif" width="16" height="16" border="0"></a></div></td>
140. </tr>
141. <?
142. }
143. ?>
144. </table>
145.
146. <center>
147. <?
148. for($i=1 ; $i<$page ; $i++) {
149. print "<a href='$PHP_SELF?type=$type&keyword=$keyword&page=$i'> $i </a> "; }
150. print "<font size='3' color='#EE0000'><b> [$page] </b></font> ";
151. for($i=$page+1 ; $i<=$totalpage ; $i++) {
152. print "<a href='$PHP_SELF?type=$type&keyword=$keyword&page=$i'> $i </a> "; }
153. ?>
154. </center>
155. <p align="center">ทั้งหมด <? echo $nrowpage;?> รายการ</p>
156. <p><br>
157. <? if($_SESSION[sess_position]==2){?>
158. </p>
159. <div align="center">
160. <a href="extraform1.php">[สั่งตัดชุดรูปแบบเดิม]</a>
161. <a href="extraform2.php">[สั่งตัดชุดรูปแบบใหม่]</a>
162. </div>
163. <? }?>
164.
165. </td>
166. </tr>
167. </table>
168.
169.
170. </td>
171. </tr>
172.</table>
173.
174.<? include "footer.php";?>
