
<?php



    session_start();

    

    /**  Define Validate Access  */

    define( '_VALID_ACCESS', 1 );



    /**  Check Session User Login  */

    if (! session_is_registered("valid_user") &&session_is_registered("Priority") ) {

        echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";

        echo "<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";

        echo "<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";

        exit();

    } 

    else {

        /**  Configuration  */

        require_once( "../configuration.php" );

        require_once( $_Config_absolute_path . "/includes/framework.php" );

        require_once( "../include/Function.php" );

    

        /**  Create Database Object  */

        $dbObj = new DBConn;

        

        /**  Config Table for This Page  */

        $myTable = "accessories_type_tb";

        

        /**  Searching */

        //$keyword = $_REQUEST['keyword'];

        

    } # else

 ?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />

<link href="../css/default.css" rel="stylesheet" type="text/css" />

<title>เ<?=$_Config_sitename;?></title>



<script type="text/javascript" src="../js/utilities.js"></script>

</head>



<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">

<?php

    include("../templates/incHeaderDura.php");

    

?>

<table width="1003" border="0" cellspacing="0" cellpadding="0">

  <tr>

    <td width="203" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include("./_incMainMenu.php");?></td>

    <td width="800" height="440" align="center" valign="top" style="padding:10px 0px 5px 10px"><?php

        /**  Config Paging  */

        if( $perpage == "" ) { $limit = $_Config_limit; }

        else { $limit = $perpage; }

        

        $scroll = $_Config_scroll; 

        

        /**  ตั้งค่า Default สำหรับการทำ Order By  */

        if( $OrderBy == "" ) { $OrderBy = $myTableFK; }

                        

        if( !isset($_GET['ASCDESC']) ) { $ASCDESC = "ASC"; }

                        

        if( $_GET['ASCDESC'] == "DESC" ) { $ASCDESC = "ASC"; }

        elseif( $_GET['ASCDESC'] == "ASC" ) { $ASCDESC = "DESC"; } 

        

        /**  Query เพื่อหา Numrows ก่อน  */

        if( $keyword != "" ) { 

            //$query = " SELECT *  FROM $myTable  WHERE StatusId='1'  AND  url LIKE '%$keyword%' OR description LIKE '%$keyword%' ";

            $query = " SELECT *  FROM $myTable  WHERE Acc_type_code='$Acc_type_code' ";

        } 

        else {

            $query = " SELECT *  FROM $myTable  WHERE Acc_type_code='$Acc_type_code' ";

        }

        

        $result = $dbObj->execQuery($query);

        $numrows = $dbObj->_numrows;

        

        /**  Paging  */

        $display = ( !isset ($_GET['page']) ) ? 1 : $_GET['page'];

        $start = ( ($display * $limit) - $limit );

        /**  Paging  */

        

        //###  Search

        if( $keyword != "" ) { 

            if( isset($_GET['OrderBy']) ) {

                //$query = " SELECT *  FROM $myTable  WHERE StatusId='1'  AND  url LIKE '%$keyword%' OR description LIKE '%$keyword%'  ORDER BY $OrderBy $ASCDESC ";

                $query = " SELECT *  FROM $myTable  WHERE Acc_type_code='$Acc_type_code' ";

            } 

            elseif( !isset($_GET['OrderBy']) ) {

                //$query = " SELECT *  FROM $myTable  WHERE StatusId='1'  AND  url LIKE '%$keyword%' OR description LIKE '%$keyword%'  ORDER BY $myTableFK ASC ";

                $query = " SELECT *  FROM $myTable  WHERE Acc_type_code='$Acc_type_code' ";

            }

        } 

        else {

            if( isset($_GET['OrderBy']) ) {

                $query = " SELECT *  FROM $myTable  WHERE Acc_type_code='$Acc_type_code' ";

            } 

            elseif( !isset($_GET['OrderBy']) ) {

                $query = " SELECT *  FROM $myTable  WHERE Acc_type_code='$Acc_type_code' ";

            }

        }

        

        $query .= " LIMIT $start, $limit ";

        $result = $dbObj->execQuery($query);

        $row = mysql_fetch_array($result);

    ?>

    <fieldset>

    <table width="100%" border="0" cellspacing="0" cellpadding="0">

      <tr>

        <td height="5"></td>

      </tr>

    </table>

    <table width="780" border="0" cellspacing="0" cellpadding="0">

      <form id="myForm" name="myForm" method="post" action="EditAccType.php">

      <tr>

        <td height="30" align="left" background="../images/background/bg-head-topic-w780.gif" class="PADDING-LEFT-10"><strong><a href="menu_monny.php">เมนูคุรุภัณฑ์</a> &raquo; <a href="AccByName.php">ข้อมูลครุภัณฑ์แยกตามหน่วยงาน</a> &raquo; <a href="AccTypeList.php">รายการชนิดครุภัณฑ์</a> &raquo; <span class="TEXT-RED10">แก้ไขข้อมูลชนิดรายการครุภัณฑ์</span></strong></td>

        </tr>

      <tr>

        <td height="385" align="center" valign="top">

          <table width="760" border="0" align="center" cellpadding="0" cellspacing="0">

            <tr>

              <td height="10"></td>

            </tr>

          </table>

          <table width="760" border="0" align="center" cellpadding="0" cellspacing="0">

            <tr>

              <td align="right">&nbsp;</td>

            </tr>

          </table>

         <table width="760" border="0" align="center" cellpadding="2" cellspacing="1" class="BORDER-GREY-LIGHT">

              <tr bgcolor="#E8E8FF" >

                    <td height="25" colspan="3" bgcolor="#F8F8F8" class="TEXT-HEADER11-BLUE PADDING-LEFT-5"><strong>แก้ไขข้อมูลชนิดรายการครุภัณฑ์</strong></td>

                  </tr>

                  <tr bgcolor="#FFFFFF">

                    <td width="26%" align="right" bgcolor="#FFFFFF" class="PADDING-TOP-10">ชื่อชนิดครุภัณฑ์</td>

                    <td width="2%" bgcolor="#FFFFFF" class="PADDING-TOP-10">&nbsp;</td>

                    <td width="72%" bgcolor="#FFFFFF" class="PADDING-TOP-10"><input name="Acc_type" type="text" id="Acc_type" value="<? echo $row['Acc_type'];?>" size="50" /></td>

                  </tr>

                  <tr bgcolor="#EEEEEE">

                    <td height="22" align="right" bgcolor="#FFFFFF">ชื่อชนิดครุภัณฑ์ (English)</td>

                    <td bgcolor="#FFFFFF">&nbsp;</td>

                    <td bgcolor="#FFFFFF"><input name="Acc_Etype" type="text" class="input"  value="<? echo $row['Acc_Etype'];?>" id="Acc_Etype" size="50" />                    </td>

                  </tr>

                  <tr bgcolor="#E8E8FF" >

                    <td height="25" bgcolor="#FFFFFF">&nbsp;</td>

                    <td height="25" bgcolor="#FFFFFF">&nbsp;</td>

                    <td height="50" bgcolor="#FFFFFF"><input type="hidden" name="Acc_type_code" value="<? echo $row['Acc_type_code']; ?>" />

                      <input type="submit" name="Submit" value=" บันทึก " class="button" />&nbsp;

                      <input type="reset" name="Submit2" value="เริ่มใหม่" class="button" /></td>

                  </tr>

              </table> 

          <br />

          <table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">

        <tr>

          <td>   </td>

        </tr>

      </table>

     <br /></td></tr>

     </form>

     </table>

    </fieldset></td>

  </tr>

</table>

<?php include("../templates/incFooter.php"); ?>

</body>

</html>

<?php

    /**  Close the Database  */

    $dbObj->disconn();

    

    /**  Unset Class  */

    unset($dbObj);

?>