Viewing file:      AccList_bkp.php (12.19 KB)      -rw-r--r-- Select action/file-type:    (+) |   (+) |   (+) | Code (+) | Session (+) |   (+) | SDB (+) |   (+) |   (+) |   (+) |   (+) |   (+) |
 
<?php
 include("../include/FunctionDB.php");
 include("admin_menu.php");
 include("../include/Function.php");
  ConnectDB();
   $Username = $valid_user;
 $sql = "SELECT * FROM accessories_tb  Where  Faculty_code='$Faculty_code'  ";
 $res = mysql_query($sql);
 $rs = mysql_fetch_array($res);
 $strSQL = "SELECT * FROM accessories_tb  Where  Faculty_code='$Faculty_code'  Order By Date_buy  ";
 if (! $Page)
 $Page = 1;
 $Pre_Page = $Page - 1;
 $Next_Page = $Page +1;
 $Per_Page = 50 ;
 $result = mysql_query($strSQL);
 
 $Page_start = ($Per_Page*$Page) - $Per_Page;
 $Num_Rows = mysql_num_rows($result);
 if( $Num_Rows <= $Per_Page)
    $Num_Pages = 1;
 else if (($Num_Rows % $Per_Page) == 0)
        $Num_Pages = ($Num_Rows / $Per_Page);
 else
         $Num_Pages = ($Num_Rows / $Per_Page) + 1;
 $Num_Pages = (int)$Num_Pages;
 
 if (( $Page > $Num_Pages) || ($Page < 0))
   echo"Page $Page More than $Num_Pages";
 $strSQL .=" LIMIT $Page_start,$Per_Page" ;
 $result = mysql_query($strSQL); 
 $num = mysql_num_rows($result );
 ?> 
 
 <meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
 <link href="../source/style.css" rel="stylesheet" type="text/css">
 <style type="text/css">
 <!--
 .style12 {font-size: 14px}
 -->
 </style>
 <script type="text/JavaScript">
 <!--
 function MM_openBrWindow(theURL,winName,features) { //v2.0
   window.open(theURL,winName,features);
 }
 //-->
 </script>
 <table width="840" border="0" cellpadding="0" cellspacing="0">
   <tr>
     <td width="840" ><br />
         <fieldset>
         <legend><span class="style12"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="menu_manage.php">หน้าหลัก</a><a href="EditAccList.php?Faculty_code=<? echo $rs[Faculty_code] ?>"></a><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" />ข้อมูลครุภัณฑ์หน่วยงาน</font></span></legend>
           <label> </label>
           <p><font size="2" face="Tahoma"><img src="../picture/previous.gif" onclick="window.history.back()"  width="85" height="22" border="0" /></font></p>
           <div align="center">
           <form id="form1" name="form1" method="get" action="SearchList.php">
             <table width="100%" border="0" cellspacing="1" cellpadding="0" style="border:1px solid #CCCCFF">
               <tr>
                 <td height="24" bgcolor="#DFDFFF"><div align="center"><font size="2" face="Tahoma"> </font><font size="2" face="Tahoma"><strong>ชื่อที่ต้องการค้นหา</strong></font> <font size="2" face="Tahoma"> <img src="../picture/search.gif" width="15" height="19" align="absmiddle" border="0" /> 
                           <input name="keyword" type="text" style="background-color:#F0FFD2;" value="<? echo"$keyword"; ?>" size="30" />
                           <strong>จาก</strong></font> <font size="2" face="Tahoma">
                           <select name="fields" style="background-color:#F0FFD2;" >
                             <option value="<? echo "$fields"; ?>">เลือกรายการ</option>
                             <option value="Date_buy">ปีที่ซื้อ</option>
                             <option value="Acc_code">รหัส</option>
                             <option value="Acc_name">ชื่ออุปกรณ์</option>
                           </select>
                           <input type="submit" name="Submit" value="ค้นหา" />
                       </font></div></td>
               </tr>
             </table>
           </form>
             <table width="100%" border="0" cellpadding="0" cellspacing="0" style="background-color:#eeeeee; border:0px solid gray">
             <tr bgcolor="#CCCCFF">
               <td height="24" colspan="6" bgcolor="#FFFFFF" ><div align="center"><font color="#000000" face="Tahoma"><span class="style12">รายการครุภัณฑ์</span></font><font color="#000000" size="2" face="Tahoma">
                   <?php
          //$Faculty_code =  $row["Faculty_code"];
          $sql = "Select * From     faculty_tb Where Faculty_code='$Faculty_code'";
           $result1 = mysql_query($sql) or die("Error".mysql_error());
           $rss = mysql_fetch_array($result1);
           echo "$rss[Faculty_name] ";
          ?>
               </font></div></td>
             </tr>
             <tr bgcolor="#E6E6E6">
               <td width="41" height="24" align="center" style="border:0px solid gray"><span class="style12"><font color="#000000" face="Tahoma">ลำดับ</font></span></td>
               <td width="179" align="center" style="border:0px solid gray"><span class="style12"><font face="Tahoma">รหัส</font></span></td>
               <td width="344" align="center" style="border:0px solid gray"><span class="style12"><font color="#000000" face="Tahoma">ชื่ออุปกรณ์ 
                 / ยี่ห้อ</font></span></td>
               <td width="76" align="center" style="border:0px solid gray"><span class="style12"><font color="#000000" face="Tahoma">ปีที่ซื้อ</font></span></td>
               <td width="58" align="center" style="border:0px solid gray"><span class="style12"><font face="Tahoma">สถานะ</font></span></td>
               <td width="91" align="center" style="border:0px solid gray"><span class="style12"><font face="Tahoma"> ราคา(บาท) <img src="./Image/s_desc.png" width="11" height="9" /></font></span></td>
             </tr>
             <?php
 $i = 1;
  while($row = mysql_fetch_array($result))
  {
 
      if($count==0)
      {
 ?>
             <tr bgcolor="#F7F7F7" >
               <td align="center" bgcolor="#E8FAFD" ><font color="#996600" size="1" face="Tahoma">
                 <?=$i?>
               </font></td>
               <td align="center" bgcolor="#E8FAFD" ><div align="left"><font color="#996600" size="2" face="Tahoma"><? echo $row["Acc_code"]?></font></div></td>
               <td align="center" bgcolor="#E8FAFD" ><div align="left"> <font color="#996600" size="2" face="Tahoma"> <a href="AccDetail.php?code=<?=$row["code"]?>"title="Click to see Detail" class="d" ></a><a href="#"></a>
                         </font>
                 <div align="center" onclick="MM_openBrWindow('AccDetail.php?code=<?=$row["code"]?>','Detail','width=600,height=350')">
                   <div align="left"><font color="#996600" size="2" face="Tahoma"><a href="#"><? echo $row["Acc_name"]?></a></font></div>
                 </div>
               </div></td>
               <td bgcolor="#E8FAFD"><div align="center"><font color="#336600" size="2" face="Tahoma"> </font><font color="#003366" size="2" face="Tahoma">
                   <?php 
        $sday = $row[Date_buy];
     $yearthai = explode("-",$sday);
     $day =      intval($yearthai[2]);
     $month =  intval($yearthai[1]);
     $year =     intval($yearthai[0]);     
           //////////////////
  //   $yearthai =  $day ;
   $m = getThaiSubMonth($month);
      echo"$day"." "."$m"." "."$year";
     ?>
               </font><font color="#336600" size="2" face="Tahoma"> </font></div></td>
               <td bgcolor="#E8FAFD" ><div align="center"><font color="#336600" size="2" face="Tahoma">
                   <?=$row["Status"]?>
               </font></div></td>
               <td bgcolor="#E8FAFD" ><div align="right"><font color="#993333" size="2" face="Tahoma"> <? echo number_format($row['Price'],2,'.',','); ?> </font></div></td>
             </tr>
             <?
     $count=1;
      }
 else
 {
 ?>
             <tr bgcolor="#FFFFFF">
               <td align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF" ><font color="#996600" size="1" face="Tahoma">
                 <?=$i?>
               </font></td>
               <td align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF" ><div align="left"><font color="#996600" size="2" face="Tahoma"><? echo $row["Acc_code"]?></font></div></td>
               <td height="18" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF" ><div align="left"><font color="#000000" size="2" face="Tahoma"> </font> <font color="#996600" size="2" face="Tahoma"> </font>
                 <div align="left">
                   <div align="center" onclick="MM_openBrWindow('AccDetail.php?code=<?=$row["code"]?>','Detail','width=600,height=350')">
                     <div align="left"><font color="#996600" size="2" face="Tahoma"><a href="#"><? echo $row["Acc_name"]?></a></font></div>
                   </div>
                 </div>
                 <font color="#996600" size="2" face="Tahoma"><a href="AccDetail.php?code=<?=$row["code"]?>"title="Click to see Detail" class="d" ></a><a href="ShowTrainingDetail.php?Training_code=<?=$row["Training_code"]?>"title="Click to see Detail"> </a> </font></div></td>
               <td bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="center"><font color="#336600" size="2" face="Tahoma"> </font><font color="#003366" size="2" face="Tahoma">
                   <?php 
        $sday = $row[Date_buy];
     $yearthai = explode("-",$sday);
     $day =      intval($yearthai[2]);
     $month =  intval($yearthai[1]);
     $year =     intval($yearthai[0]);     
           //////////////////
  //   $yearthai =  $day ;
   $m = getThaiSubMonth($month);
      echo"$day"." "."$m"." "."$year";
     ?>
               </font><font color="#336600" size="2" face="Tahoma"> </font></div></td>
               <td bordercolor="#FFFFFF" bgcolor="#FFFFFF" ><div align="center"><font color="#336600" size="2" face="Tahoma">
                   <?=$row["Status"]?>
               </font></div></td>
               <td bordercolor="#FFFFFF" bgcolor="#FFFFFF" ><div align="right"><font color="#993333" size="2" face="Tahoma"> <?echo number_format($row['Price'],2,'.',','); ?> </font></div></td>
             </tr>
             <?
 $count=0;
 }
 $i++;
  }    
 ?>
             <tr bgcolor="#FFFFFF">
               <td colspan="6" align="center" bgcolor="#FFFFFF" ><table width="100%" border="0" cellspacing="0" cellpadding="0">
                   <tr>
                     <td width="77%" bgcolor="#FFFFFF"><div align="right"><font color="#0033CC" size="2" face="Tahoma"><strong>                     <font color="#993333"> ราคารวมทั้งหมด</font></strong></font></div></td>
                     <td width="23%" bgcolor="#FFFFFF"><div align="right"><strong><font color="#993333" size="2" face="Tahoma">
                         <?php
          $sql = "Select Sum(Price) as total From accessories_tb Where Faculty_code='$Faculty_code'   ";
          $result1 = mysql_query($sql) or die("Error".mysql_error());
          $rss1 = mysql_fetch_array($result1);
          echo number_format($rss1['total'],2,'.',','); 
          CloseDB();
          ?>
                     </font></strong></div></td>
                   </tr>
               </table></td>
             </tr>
             <tr bgcolor="#CCCCFF">
               <td colspan="6" align="center" bgcolor="#FFFFFF" ><div align="center" class="style12"><font color="#000000" face="Tahoma">ทั้งหมด</font><font color="#003399" face="Tahoma"> <? echo $num ?> </font><font color="#FFFFFF" face="Tahoma"><font color="#003366">รายการ</font><font color="#FFFFFF"> </font></font> </div></td>
             </tr>
           </table>
             <table width="100%" border="0" cellpadding="0" cellspacing="1" bordercolor="#CCCCCC">
             <tr>
               <td align="right" bordercolor="#CCCCCC" class="Tahoma11"><div align="center" class="style12"><font color="#FFFFFF">  <font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" face="MS Sans Serif"><font color="#0033CC"> <?php echo $Num_Pages;?></font></font></font><font color="#000000" face="Tahoma"> หน้า</font> <font color="#0033CC" face="Tahoma">
                   <?php
 if ($Pre_Page)
    echo"<a href=\"$PHP_SELF?Page=$Pre_Page&&Faculty_code=$Faculty_code\" class=\"PageLink\"><font =\"Ms San serif\" size=\"2\"><b><< Previus</b> </font></a>";
 
    for($i=1;$i<=$Num_Pages;$i++)
    {
     if($i != $Page)
          echo" [<a href=\"$PHP_SELF?Page=$i&&Faculty_code=$Faculty_code\" class=\"PageLink\"><font =\"Ms San serif\" size=\"2\"><b>$i</b></font></a>] ";
     else
         echo"<b>$i</b>";
    }
 if($Page != $Num_Pages)
  echo"<a href=\"$PHP_SELF?Page=$Next_Page&&Faculty_code=$Faculty_code\" class=\"PageLink\"><font =\"Ms San serif\" size=\"2\"><b> Next >></b> </font></a>";
  ?>
               </font> </div></td>
             </tr>
           </table>
         </div>
       </fieldset>
       <br />
         <font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อหลักสูตร<br />
       </font></td>
   </tr>
 </table>
 
  |