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.
023.<body>
024.<form>
025.
026.<?php
027.include "header.php"
028.?>
029.
030.<!doctype html>
031.<html>
032.<head>
033.<meta charset="utf-8">
034.<meta name="viewport" content="width=device-width, initial-scale=1">
038.</head>
039.
040.<body>
041.<div class="container"></form>
042.<form id="" action="search_parcle_show.php" name="form1" method="post">
043.<p> </p>
044.<table width="1150px" border="1" align="center">
045.
046.<tr><td width="258" align="center" valign="top"><p align="center">
047.<?php
048.include 'menu_left_admin.php';
049.?>
050.
051. </p>
052.<p align="left"> </p>
053.<p align="left"> </p>
055.<td width="876" align="center" valign="top"><table width="100%" border="0" valign="top">
056.<tbody>
057.<tr class="btn-default">
058.<th height="64" scope="col"> </th>
059.<th align="left" scope="col"><h3>พัสดุ</h3></th>
060.<th scope="col"> </th>
061.</tr></tbody></table>
062.
063.<table width="100%" border="0">
064.<tbody>
065.<tr><td align="center"><table width="100%" border="0"><tbody>
066.
067.<tr>
068.<td align="center"> </td></tr></tbody></table>
069.<label for="textfield"><br>
070.ชื่อ:</label>
071.<input type="text" name="sname" id="textfield"> <input name="bsearch" type="submit" id="button4" value="ค้นหา"> <input name="button4" type="submit" id="button5" formaction="parcle_add.php" value="เพิ่มข้อมูลรับพัสดุ"></td></tr></tbody></table>
072.
073.<p> </p>
074.<table width="98%" border="0">
075.<tbody>
076.<tr><td align="center"><table width="98%" border="1">
077. <tbody>
078. <tr class="table table-hover">
079. <td align="center">รหัสพัสดุ</td>
080. <td align="center">วันที่รับเข้า</td>
081. <td align="center">ชื่อผู้ส่งพัสดุ</td>
082. <td align="center">เบอร์โทรศัพท์ผู้ส่งพัสดุ</td>
083. <td align="center">สถานะพัสดุ</td>
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. </tr>
090. <!--เป็น HTML ของแถวที่ 1 -->
091.
092.<?
093.$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.email_status = '9' ";
094.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
095.$Num_Rows = mysql_num_rows($objQuery);
096.$Per_Page = 20;
097.$Page = $_GET["Page"];
098.if(!$_GET["Page"])
099.{
100. $Page=1;
101.}
102.$Prev_Page = $Page-1;
103.$Next_Page = $Page+1;
104.$Page_Start = (($Per_Page*$Page)-$Per_Page);
105.if($Num_Rows<=$Per_Page)
106.{
107. $Num_Pages =1;
108.}
109.else if(($Num_Rows % $Per_Page)==0)
110.{
111. $Num_Pages =($Num_Rows/$Per_Page) ;
112.}
113.else
114.{
115. $Num_Pages =($Num_Rows/$Per_Page)+1;
116. $Num_Pages = (int)$Num_Pages;
117.}
118.$strSQL .=" order by parcle_id ASC LIMIT $Page_Start , $Per_Page";
119.$objQuery = mysql_query($strSQL);
120.$result =mysqli_query($conn,$strSQL);
121.if(mysqli_num_rows($result)>0){
122. while($array=mysqli_fetch_array($result)){
123. $parcle_id =$array['parcle_id'];
124. $parcle_dt_get =$array['parcle_dt_get'];
125. $parcle_from =$array['parcle_from'];
126. $parcle_tel =$array['parcle_tel'];
127. $parcle_status =$array['parcle_status'];
128. $member_id =$array['member_id'];
129. $member_name =$array['member_name'];
130. $member_surname =$array['member_surname'];
131. $type_id =$array['type_id'];
132. $email_status =$array['email_status'];
133.
134.?>
135.
136.<tr><td align="center"><?php echo $parcle_id; ?></td>
137. <td align="center"><?php echo $parcle_dt_get; ?></td>
138. <td align="center"><?php echo $parcle_from; ?></td>
139. <td align="center"><?php echo $parcle_tel; ?></td>
140. <td align="center"><?php if($parcle_status==1)echo "<font color='blue'>รอนำจ่าย</font>"; if($parcle_status==2)echo "<font color='green'>นำจ่ายแล้ว</font>"; ?></td>
141.
142.<?php
143.$sql2="SELECT type_id, type_name FROM type WHERE type_id=$type_id";
144.$query2=mysqli_query($conn,$sql2);
145.$array2=mysqli_fetch_array($query2);
146. $t_id= $array2['type_id'];
147. $t_name= $array2['type_name'];
148.?>
149. <td align="center"><?php echo $t_name; ?></td>
150. <td align="center"><?php echo $member_name;?> <?php echo $member_surname;?></td>
151. <td align="center"><a href="parcle_del.php?parcle_id=<?php echo $parcle_id; ?>"><span onclick="return confirm('คุณต้องการลบข้อมูลใช่หรือไม่ ?')"class="glyphicon glyphicon-trash"></span></a></td>
152. <td align="center"><a href="parcle_edit.php?parcle_id=<?php echo $parcle_id; ?>"><span class="glyphicon glyphicon-edit"></span></a></td>
153. <td align="center" style="text-align: center"><input name="submit" type="submit" id="submit" formaction="phpSendMailGmail.php?p_id=<?php echo $parcle_id; ?>" onclick="return confirm('คุณต้องการนำจ่ายใช่หรือไม่ ?')"value="แจ้งเตือน">
154.</td>
155. </tr>
156.
157.
158. <!--เป็น HTML ของแถวที่ 2 -->
159.
160.<?php
161.}}else{
162.echo "ไม่มีข้อมูลในฐานข้อมูล";
163.}
164.?>
165.
166.</tbody>
167.</table></td>
168.</tr>
169.</tbody>
170.</table>
171.<br>
172.Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :
173.
174.<?
175.if($Prev_Page)
176.{
177. echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< Back</a> ";
178.}
179.
180.for($i=1; $i<=$Num_Pages; $i++){
181. if($i != $Page)
182. {
183. echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]";
184. }
185. else
186. {
187. echo "<b> $i </b>";
188. }
189.}
190.if($Page!=$Num_Pages)
191.{
192. echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>Next>></a> ";
193.}
194.?>
195.
196.
197.<p> </p>
198.<p> </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.</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>
Load balance : Server 01
