001.<?
002.session_start();
003.
004.include("header.php");
005.
006.#Deasciption
007.echo "
008.<center>
009.<table id=\"tblDescription\">
010.<tr>
011.<td valign=\"top\">
012.
013.<br>
014.<div id=\"titlePage\" align=\"center\">จัดการข้อมูลบริษัทคู่ค้า</div>
015.<br>
016.";
017.
018.#ฟอร์มค้นหาข้อมูล
019.echo "
020.<form action=\"".$_SERVER["PHP_SELF"]."\" method=\"post\" id=\"frmSearch\" name=\"frmSearch\">
021.<div id=\"divSearch\">
022.ค้นหาจาก
023.<select name=\"listSearch\" id=\"listSearch\">
024. <option value=\"0\">---เลือกการค้นหา---</option>
025. <option value=\"1\" ";if($_POST["listSearch"] == "1"){ echo "selected"; } echo ">รหัสบริษัทคู่ค้า</option>
026. <option value=\"2\" ";if($_POST["listSearch"] == "2"){ echo "selected"; } echo ">ชื่อบริษัทคู่ค้า</option>
027.</select>
028.คำค้นหา
029.<input name=\"txtSearch\" id=\"txtSearch\" type=\"text\" value=\"".$_POST["txtSearch"]."\"/>
030.<input name=\"btnSearch\" id=\"btnSearch\" type=\"submit\" value=\"ค้นหา\"/>
031.</div>
032.</form>
033.";
034.
035.#ตรวจสอบเงื่อนไขการค้นหาข้อมูล
036.if($_POST["listSearch"] == "1" && $_POST["txtSearch"] <> ""){
037. $search = "WHERE sup_id LIKE '%".trim($_POST["txtSearch"])."%'";
038.}elseif($_POST["listSearch"] == "2" && $_POST["txtSearch"] <> ""){
039. $search = "WHERE sup_name LIKE '%".trim($_POST["txtSearch"])."%'";
040.}
041.
042.echo "
043.<div id=\"titlePage\" align=\"left\">
044.<a href=\"main.php\" id=\"btnLink\"><img src=\"../images/icons/undo-icon.png\">ย้อนกลับ</a>
045.<a href=\"supplier_add.php\" id=\"btnLink\"><img src=\"../images/icons/Button-Add-icon.png\">เพิ่มข้อมูลบริษัทคู่ค้า</a>
046.</div>
047.
048.<center>
049.<table id=\"tblWhileData\" width=\"100%\" height=\"30\">
050. <tr height=\"30\" bgcolor=\"#CCCCCC\">
051. <th width=\"8%\">ลำดับ</th>
052. <th width=\"8%\">รหัสคู่ค้า</th>
053. <th width=\"30%\">ชื่อบริษัทคู่ค้า</th>
054. <th width=\"35%\">ที่อยู่</th>
055. <th width=\"20%\">ชื่อ</th>
056. <th width=\"20%\">อีเมล</th>
057. <th width=\"15%\">เบอร์โทร</th>
058. <th width=\"10%\">สถานะ</th>
059. <th width=\"5%\">แก้ไข</th>
060. </tr>
061.";
062.
063.$objSql = "SELECT * FROM supplier
064. LEFT JOIN adminis ON (supplier.sup_update_id=adminis.admin_id)
065. LEFT JOIN user ON (supplier.sup_update_id=user.user_id)
066. $search ORDER BY sup_id ASC";
067.$objQuery = mysql_query($objSql) or die ("Not Query Database");
068.$rows = mysql_num_rows($objQuery);
069.
070.#แบ่งหน้าการแสดงผลข้อมูล
071.$fix_rows = 20;#กำหนดแถวการแสดงผล
072.
073.$page = $_GET["page"];
074.if(!$_GET["page"]){
075. $page = 1;
076.}
077.
078.$prev_page = $page - 1;#ก่อนหน้า
079.$next_page = $page + 1;#หน้าถัดไป
080.
081.$page_start = (($fix_rows * $page) - $fix_rows);
082.if($rows <= $fix_rows){#ถ้าจำนวน record น้อยกว่าจำนวนแถวแสดงผล
083. $num_page = 1;
084.}elseif(($rows % $fix_rows) == 0){
085. $num_page = ($rows / $fix_rows);
086.}else{
087. $num_page = ($rows / $fix_rows) + 1;
088. $num_page = (int)$num_page;
089.}
090.$objSql .= " LIMIT $page_start,$fix_rows";
091.$objQuery = mysql_query($objSql) or die ("Not Query Database");
092.$i = 1;
093.if($rows > 0){
094. while($objResult = mysql_fetch_array($objQuery)){
095. #loop ข้อมูลออกมาแสดง
096.echo "
097. <tr height=\"30\" id=\"tblWhileData1\">
098. <td align=\"center\" valign=\"middle\">" . $i . "</td>
099. <td align=\"center\" valign=\"middle\">".$objResult["sup_id"]."</td>
100. <td align=\"left\" valign=\"middle\">".$objResult["sup_name"]."</td>
101. <td align=\"left\" valign=\"middle\">".$objResult["sup_add"]."</td>
102. <td align=\"left\" valign=\"middle\">".$objResult["sup_cname"]."</td>
103. <td align=\"left\" valign=\"middle\">".$objResult["sup_email"]."</td>
104. <td align=\"left\" valign=\"middle\">".$objResult["sup_tel"]."</td>
105. <td align=\"center\" valign=\"middle\">
106.";
107. if($objResult["sup_status"] == "1"){
108. echo "ใช้งาน";
109. }else{
110. echo "<font color=\"#FF0000\">ยกเลิก</font>";
111. }
112.echo "
113. </td>
114. <td align=\"center\" valign=\"middle\">
115. <a href=\"supplier_edit.php?supplier_id=".$objResult["sup_id"]."\"><img src=\"../images/icons/Pencil-icon.png\"></a></td>
116. </tr>
117.";
118. $i++;
119. }
120.}else{
121.echo "
122. <tr height=\"30\">
123. <th colspan=\"6\" align=\"center\" valign=\"middle\"><span id=\"commentStar\">ไม่พบข้อมูล</span></th>
124. </tr>
125.";
126.}
127.echo "
128.</table>
129.<br>
130.<div>
131.";
132.if($rows > 0){
133. if($prev_page){
134. echo " <a href='$_SERVER[SCRIPT_NAME]?page=$prev_page' id='pageLink'><img src='../images/icons/Button-Previous-icon.png'></a> ";
135. }
136. for($i=1; $i<=$num_page; $i++){
137. if($i <> $page){
138. echo " <a href='$_SERVER[SCRIPT_NAME]?page=$i' id='pageLink'>$i</a> ";
139. }
140. else{
141. echo " <span id='pageLink'>$i</span> ";
142. }
143. }
144. if($page <> $num_page){
145. echo " <a href ='$_SERVER[SCRIPT_NAME]?page=$next_page' id='pageLink'><img src='../images/icons/Button-Next-icon.png'></a> ";
146. }
147.}
148.echo "
149.</div>
150.<br>
151.</center>
152.
153.</td>
154.</tr>
155.</table>
156.";
157.
158.include("../inc/inc_footer.php");
159.
160.echo "
161.</center>
162.";
163.mysql_close();
164.?>
