001.<?php
002.include("conn.php");
003.?>
004.
005.<?php
006.include 'check_ADMIN.php'
007.?>
008.
009.<!doctype html>
010.<html>
011.<head>
012.<meta charset="utf-8">
013.<title>E-POST System NSRU</title>
014.<style type="text/css">
015.@import url("../parcel/bootstrap.css");
016.@import url("../parcel/bootstrap-3.3.7-dist/css/bootstrap.css");
017.@import url("../bootstrap-3.3.7-dist/css/bootstrap.css");
018.body {
019.}
020.</style>
021.</head>
022.<body>
023.<form>
024.
025.<?php
026.include "header.php"
027.?>
028.
029.<!doctype html>
030.<html>
031.<head>
032.<meta charset="utf-8">
033.<meta name="viewport" content="width=device-width, initial-scale=1">
037.</head>
038.<body>
039.<div class="container"></form>
040.<form id="" action="search_send_show.php" name="form1" method="post">
041.<p> </p>
042.<table width="1150px" border="1" align="center">
043.<tr >
044.<td width="258" align="center"><p align="center">
045.
046.<?php
047.include 'menu_left_admin.php'
048.?>
049.
050. </p>
051.<p align="center"> </p>
052.<p align="center"> </p>
054.<td width="876" valign="top"><table width="100%" border="0" valign="top">
055.<tbody>
056.<tr class="btn-default">
057.<th height="64" scope="col"> </th>
058.<th scope="col"><h3>นำจ่ายพัสดุ</h3></th>
059.<th scope="col"> </th>
060.</tr>
061.</tbody>
062.</table>
063.
064.<table align="center" width="100%" border="0">
065.<tbody>
066.<tr>
067.<td align="center"><table width="100%" border="0">
068.<tbody>
069.<tr>
070.<td> </td></tr></tbody></table>
071.<label for="textfield"><br>
072. ชื่อ:</label>
073.<input type="text" name="sname" id="textfield"> <input name="bsearch" type="submit" id="button4" value="ค้นหา"> <input name="button" type="submit" id="button" formaction="sent_show.php" title="ข้อมูลการนำจ่าย" value="ข้อมูลการนำจ่าย"></td>
074.</tr>
075.</tbody>
076.</table>
077. <p> </p>
078. <table align="center" width="98%" border="0">
079. <tbody>
080. <tr>
081. <td><table align="center" width="100%" border="1">
082. <tbody>
083. <tr align="center" class="table table-hover">
084. <td align="center" >รหัสพัสดุ</td>
085. <td align="center">วันที่รับเข้า</td>
086. <td align="center">ชื่อผู้ส่งพัสดุ</td>
087. <td align="center">เบอร์โทรศัพท์</td>
088. <td align="center" >สถานะพัสดุ</td>
089. <td align="center">ประเภทพัสดุ</td>
090. <td align="center">ชื่อผู้รับพัสดุ</td>
091. <td align="center">ผู้รับเเทน (ถ้ามี)</td>
092. <td align="center">นำจ่าย</td>
093. </tr>
094. <!--เป็น HTML ของแถวที่ 1 -->
095.<?
096.$strSQL ="SELECT parcles.parcle_id, parcles.parcle_dt_get, parcles.parcle_from, parcles.parcle_tel,parcles.parcle_status,parcles.member_id,parcles.type_id, members.member_id,members.member_name, members.member_surname From parcles, members WHERE parcles.member_id = members.member_id AND parcles.parcle_status= '1' ";
097.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
098.$Num_Rows = mysql_num_rows($objQuery);
099.$Per_Page = 20;
100.$Page = $_GET["Page"];
101.if(!$_GET["Page"])
102.{
103. $Page=1;
104.}
105.$Prev_Page = $Page-1;
106.$Next_Page = $Page+1;
107.$Page_Start = (($Per_Page*$Page)-$Per_Page);
108.if($Num_Rows<=$Per_Page)
109.{
110. $Num_Pages =1;
111.}
112.else if(($Num_Rows % $Per_Page)==0)
113.{
114. $Num_Pages =($Num_Rows/$Per_Page) ;
115.}
116.else
117.{
118. $Num_Pages =($Num_Rows/$Per_Page)+1;
119. $Num_Pages = (int)$Num_Pages;
120.}
121.$strSQL .=" order by parcle_id ASC LIMIT $Page_Start , $Per_Page";
122.$result =mysqli_query($conn,$strSQL);
123.if(mysqli_num_rows($result)>0){
124. while($array=mysqli_fetch_array($result)){
125. $parcle_id =$array['parcle_id'];
126. $parcle_dt_get =$array['parcle_dt_get'];
127. $parcle_from =$array['parcle_from'];
128. $parcle_tel =$array['parcle_tel'];
129. $parcle_status =$array['parcle_status'];
130. $member_id =$array['member_id'];
131. $member_name =$array['member_name'];
132. $member_surname =$array['member_surname'];
133. $type_id =$array['type_id'];
134. ?>
135.
136. <tr>
137. <td align="center"><?php echo $parcle_id; ?><br>
138. <td align="center"><?php echo $parcle_dt_get ?></td>
139. <td align="center"><?php echo $parcle_from; ?></td>
140. <td align="center"><?php echo $parcle_tel; ?></td>
141. <td align="center" ><?php if($parcle_status==1)echo "<font color='blue'>รอนำจ่าย</font>"; if($parcle_status==2)echo "<font color='green'>นำจ่ายแล้ว</font>"; ?></td>
142.
143.<?php
144.$sql2="SELECT type_id, type_name FROM type WHERE type_id=$type_id";
145.$query2=mysqli_query($conn,$sql2);
146.$array2=mysqli_fetch_array($query2);
147. $t_id= $array2['type_id'];
148. $t_name= $array2['type_name'];
149.?>
150.
151.<td align="center"><?php echo $t_name; ?></td>
152.<td align="center"><?php echo $member_name;?> <?php echo $member_surname;?></td>
153.
154.<form id="" action="send_update.php" name="form2" method="get">
155.<td align="center"><input type="text" name="parcle_getreplaced" id="textfield2" size="10"></td>
156.<td align="center"><input type="hidden" name="parcle_id" id="textfield" value="<?php echo $parcle_id; ?>"> <input name="bsearch" type="submit" id="button4" onclick="return confirm('คุณต้องการนำจ่ายใช่หรือไม่ ?')" value=" นำจ่าย "></td>
157.</from>
158.</tr>
159. <!--เป็น HTML ของแถวที่ 2 -->
160.
161.<?php
162. }}else{
163. echo "ไม่มีข้อมูลในฐานข้อมูล";
164. }
165.?>
166. </tbody>
167. </table>
168. </td>
169. </tr>
170. </tbody>
171. </table>
172.
173. <p style="text-align: center">
174.<br>
175.Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :
176.
177.<?
178.if($Prev_Page)
179.{
180. echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< Back</a> ";
181.}
182.
183.for($i=1; $i<=$Num_Pages; $i++){
184. if($i != $Page)
185. {
186. echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]";
187. }
188. else
189. {
190. echo "<b> $i </b>";
191. }
192.}
193.if($Page!=$Num_Pages)
194.{
195. echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>Next>></a> ";
196.}
197.?>
198. </p>
199. <p> </p>
200. <p> </p>
201. <p> </p>
202. <p> </p>
203. <p> </p>
204. <p> </p>
205. <p> </p>
206. <p> </p>
207. <p> </p>
208. <p> </p></td>
209. </tr>
210.</table>
211.</form>
212.<br>
213.<br>
214.<form>
215.
216.<?php
217.include "footer.php"
218.?>
219.
220.</p>
221.</div>
222.</form>
223.</body>
224.</html>
Quote:
