
<?php



    //session_start();

    

    /**  Define Validate Access  */

    define( '_VALID_ACCESS', 1 );



    /**  Check Session User Login  */

    /**  Configuration  */

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

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

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

    

        /**  Create Database Object  */

        $dbObj = new DBConn;



        //=== SESSION

        $Username = $valid_user; 

        

        

        /**  Config Table for This Page  */

        $myTable1 = "personal_tb";

        $myTable2 = "project_type_tb";

        $myTable3 = "projectstdplan_tb";

        $myTalbleOrder = "Orderlist";

        

        $myTableField1 = "Orderlist";

        $myTableField2 = "Project_plan";

        $myTableField3 = "Faculty_code";

        

        

        

        $query = " SELECT *  FROM $myTable2  Where  Budget_Year='$Budget_Year'  and   Flag='Y'  ";

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

        $rs0 = $dbObj->fetchArray($result0);

        

        /**  Paging */

        $page = $_GET['page'];

        if( $page == "" ) { $page = 1; }

        

        /**  จำนวนข้อมูล ต่อ 1 หน้า  */

        $perpage = $_REQUEST['perpage'];

        if( $perpage == "" ) { $perpage = 20; }



        /**  Searching */

        $keyword = trim( $_REQUEST['keyword'] );

        $selectType = $_REQUEST['selectType'];

        

      /*  Parameters  **/

        $params = "Budget_Year=$Budget_Year&Flag=$Flag";

        



 ?>

<!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" />

<script language="javascript" src="../js/utilities.js"></script>



<script language="javascript">

function checkAllDelete(oAllCheckBox,frm) {

    for(i=0; i<frm.elements.length; i++) {

        if( (frm.elements[i].type == "checkbox") && (frm.elements[i] != oAllCheckBox) ) {

            if(oAllCheckBox.checked==true) {

                frm.elements[i].parentElement.parentElement.style.backgroundColor='#E8F6FD';

                frm.elements[i].checked=true;

            } else {

                frm.elements[i].parentElement.parentElement.style.backgroundColor='';            

                frm.elements[i].checked=false;            

            }

        } // end..if

    } // end..for

} // end..function

</script>

<!---------------------------------------Begin JavaScript---------------------------------------->

<SCRIPT LANGUAGE="JavaScript" src="../source/script.js"></SCRIPT>

<script language="JavaScript">

               function ReturnValue(ProjectId,Orderlist,Project_plan,Budget_Year,MoneyS_C,MoneyId,Project_code)

    {

     //    if(id == 1){

            window.opener.document.form1.ProjectId.value = ProjectId;

            window.opener.document.form1.Orderlist.value = Orderlist;            

            window.opener.document.form1.Project_plan.value = Project_plan;        

            window.opener.document.form1.Budget_Year.value = Budget_Year;

            window.opener.document.form1.Year_std.value = Budget_Year;                

            window.opener.document.form1.MoneyS_C.value =  MoneyS_C;        

            window.opener.document.form1.MoneyId.value = MoneyId;    

            window.opener.document.form1.Project_code.value = Project_code;        

             window.close();        

        

        }

        </script>

    



<title>ข้อมูลฝ่ายบริหาร : รายงานบุคลากร - จำนวนครุภัณฑ์ จำแนกตามรายหน่วยงาน - ข้อมูลครุภัณฑ์หน่วยงาน</title>

</head>



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



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

  <tr>

    <td width="758" 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 = $myTalbleOrder; }

                        

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

                        

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

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

        

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

        if( $keyword != "" ) { // ใส่ Keyword

            if( $selectType != "" ) { // เลือกรายการใน List

                switch( $selectType ) {

                    case 1 :

                        $query = " SELECT *  FROM $myTable2  WHERE  Budget_Year='$Budget_Year'  and  Flag ='Y'    and  ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%' ) 

                                            AND  $myTableField1 LIKE '%$keyword%' ";

                    break;

                    case 2 :

                        $query = " SELECT *  FROM $myTable2    WHERE  Budget_Year='$Budget_Year'  and  Flag ='Y'    and ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%' ) 

                                            AND  $myTableField2  LIKE '%$keyword%' ";

                    break;

                    case 3 :

                        $query = " SELECT *  FROM $myTable2  WHERE   Budget_Year='$Budget_Year'  and  Flag ='Y'  and ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%' ) 

                                            AND  $myTableField3  LIKE '%$keyword%' ";

                    break;

                } # switch

            } else { // หาเฉพาะที่ใส่ Keyword

                $query = " SELECT *  FROM $myTable2  WHERE  Budget_Year='$Budget_Year'  and  Flag ='Y'    and ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%' ) ";

            }

        } 

        else {

            $query = " SELECT *  FROM $myTable2  Where   Budget_Year='$Budget_Year'  and   Flag='Y'    ";

        }

        

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

        $numrows = $dbObj->_numrows;

        

        /**  Paging  */

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

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

        /**  Paging  */

        

        if( $keyword != "" ) { // ใส่ Keyword

            if( $selectType != "" ) { // เลือกรายการใน List

                switch( $selectType ) {

                    case 1 :

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

                            $query = " SELECT *  FROM $myTable2  WHERE   Budget_Year='$Budget_Year'  and  Flag ='Y'    and  ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%' ) 

                                                AND  $myTableField1 LIKE '%$keyword%' 

                                                ORDER BY  $OrderBy  $ASCDESC ";

                        } 

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

                            $query = " SELECT *  FROM $myTable2  WHERE  Budget_Year='$Budget_Year'  and  Flag ='Y'   and   ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%' ) 

                                                AND  $myTableField1 LIKE '%$keyword%' 

                                                ORDER BY  $myTalbleOrder  ASC ";

                        }

                    break;

                    case 2 :

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

                            $query = " SELECT *  FROM $myTable2  WHERE    Budget_Year='$Budget_Year'  and  Flag ='Y'    and  ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%' )     AND  $myTableField2 LIKE '%$keyword%'      ORDER BY  $OrderBy  $ASCDESC ";

                        } 

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

                            $query = " SELECT *  FROM $myTable2  WHERE Budget_Year='$Budget_Year'  and   Flag ='Y'   and ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%' )      AND  $myTableField2 LIKE '%$keyword%'           ORDER BY  $myTalbleOrder  ASC ";

                        }

                    break;

                    case 3 :

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

                            $query = " SELECT *  FROM $myTable2  WHERE  Budget_Year='$Budget_Year'  and  Flag ='Y'   and   ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%' )       AND  $myTableField3 LIKE '%$keyword%'  ORDER BY  $OrderBy  $ASCDESC ";

                        } 

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

                            $query = " SELECT *  FROM $myTable2  WHERE   Budget_Year='$Budget_Year'  and  Flag ='Y'   and  ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%' )      AND  $myTableField3 LIKE '%$keyword%'      ORDER BY  $myTalbleOrder  ASC ";

                        }

                    break;

                } # switch

            } else {  // หาเฉพาะที่ใส่ Keyword

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

                    $query = " SELECT *  FROM $myTable2  WHERE  Budget_Year='$Budget_Year'  and  Flag ='Y'  and  ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%' ) 

                                        ORDER BY  $OrderBy  $ASCDESC ";

                } 

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

                    $query = " SELECT *  FROM $myTable2  WHERE   Budget_Year='$Budget_Year'  and  Flag='Y'   and   ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%' ) 

                                        ORDER BY  $myTalbleOrder  ASC ";

                }

            }

        } #if

        else {

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

                $query = " SELECT *  FROM $myTable2  Where  Budget_Year='$Budget_Year'  and  Flag ='Y'    ORDER BY  $OrderBy  $ASCDESC ";

            } 

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

                $query = " SELECT *  FROM $myTable2  Where  Budget_Year='$Budget_Year'  and  Flag ='Y'   ORDER BY  $myTalbleOrder  ASC ";

            }

        }

        

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

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

    ?>

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

        <form id="myForm" name="myForm" method="post" action="<?=$PHP_SELF;?>?<?=$params ;?>&amp;page=<?=$page;?>">

          <tr>

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

            </tr>

          <tr>

            <td width="466" height="30" background="images/background/bg-head-topic.gif" class="PADDING-LEFT-10"><span class="PADDING-TOP-10"><img src="../images/icons/arrow-circle-225-left.png" width="16" height="16" border="0" align="absmiddle" /> <a href="javascript:;" onclick="window.history.back();"><strong>&lsaquo; ย้อนกลับ</strong></a></span></td>

            <td width="251" align="right" style="padding-right:10px">จำนวนข้อมูลต่อหน้า

              <select name="perpage" id="perpage" onchange="document.myForm.perpage.value=this.value; document.myForm.submit();" style="font-size:9pt; color:darkblue">

                <option value="10" <?php if( $perpage=="10" ) echo 'selected'; ?>>10</option>

                <option value="20" <?php if( $perpage=="20" ) echo 'selected'; ?>>20</option>

                <option value="50" <?php if( $perpage=="50" ) echo 'selected'; ?>>50</option>

                <option value="100" <?php if( $perpage=="100" ) echo 'selected'; ?>>100</option>

              </select></td>

            </tr>

          <tr>

            <td colspan="2"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">

              

              <tr>

                <td align="left" style="padding-bottom:5px;">ค้นหา 

                  <input name="keyword" type="text" id="keyword" value="<?=$keyword;?>" class="TEXT-CLIMSON10" />

                  <select name="selectType" id="selectType">

                    <option value="">--- เลือกทั้งหมด ---</option>

                    <option value="1" <?php if( $selectType == "1" ) echo 'selected'; ?>>ข้อแผน</option>

                    <option value="2" <?php if( $selectType == "2" ) echo 'selected'; ?>>ชื่อ</option>

                    <option value="3" <?php if( $selectType == "3" ) echo 'selected'; ?>>หน่วยงาน</option>

                    </select>

                  <input type="submit" name="action" id="action" value="ค้นหา" class="WIDTH60" /></td>

              </tr>

              </table></td>

            </tr>

          <tr>

            <td height="189" colspan="2" align="center" valign="top">

              <?php if( $numrows > 0 ) { ?>

              <table width="712" border="0" cellspacing="1" cellpadding="1">

                

                <tr>

                  <td width="380" height="28" class="PADDING-TOP-5 PADDING-BOTTOM-5"><span style="padding-bottom:5px;">ทั้งหมด: <span class="TEXT-RED10"><strong>

                    <?=$numrows;?>

                    </strong></span> รายการ</span></td>

                  <td width="325" align="right" class="PADDING-TOP-5 PADDING-BOTTOM-5">&nbsp;</td>

                  </tr>

                </table>

              <table width="727" border="0" align="center" cellpadding="0" cellspacing="0" class="BORDER-GREY">

                <tr bgcolor="#F0F0F0">

                  <td width="40" height="25" align="center"><strong> ข้อ</strong></td>

                  <td width="421" align="center" class="BORDER-LEFT-RIGHT"><strong>รายการโครงการ/กิจกรรมด้านการพัฒนาตนเอง</strong></td>

                  <td width="156" align="center" class="BORDER"><strong>หน่วยงาน</strong></td>

                  <td width="110" align="center" class="BORDER-LEFT"><strong>หมวดเงิน</strong></td>

                  </tr>

                <?php 

           $no = 1+($display-1)*$limit;

            while( $rs = $dbObj->fetchArray($result) ) { 

            

                if( $keyword != "" ) {

                    $Acc_code = eregi_replace( $keyword, "<font color=red>\\0</font>", $rs['Acc_code'] );

                    $Acc_name = eregi_replace( $keyword, "<font color=red>\\0</font>", $rs['Acc_name'] );

                } else {

                    $Acc_code = $rs['Acc_code'];

                    $Acc_name = $rs['Acc_name'];

                }

            

                $bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";

          ?>

                <tr bgcolor="<?=$bgColor;?>" onmouseover="this.style.backgroundColor='#F5F9F9'" onmouseout="this.style.backgroundColor=''">

                  <td height="23" align="center" class="BORDER-TOP"><?=$rs['Orderlist'];?></td>

                  <td colspan="2" align="left" class="PADDING-LEFT-5 BORDER-TOP-LEFT-RIGHT"   onclick='ReturnValue("<?=$rs['ProjectId'];?>","<?=$rs['Orderlist'];?>","<?=$rs['Project_plan'];?>","<?=$rs['Budget_Year'];?>","<?=$rs['MoneyS_C'];?>","<?=$rs['MoneyId'];?>","<?=$rs['Project_code'];?>")'><a href="#" ><?=$rs['Project_plan'];?></a>

                    (<?php 

          

            $sql = " SELECT * FROM faculty_tb  WHERE Faculty_code='$rs[Faculty_code]' ";

            $result1 = mysql_query($sql);

            $rs1 = mysql_fetch_array($result1);

                if( $rs1['Faculty_name'] != "" )

                    echo $rs1['Faculty_name']; 

                else 

                    echo "&nbsp;";

            ?>)

                    </a></a></td>

                  <td align="left" class="PADDING-LEFT-5 BORDER-TOP">

                    <?php

                $MoneyS_C = $rs['MoneyS_C'];

                $sql3 = " Select * From   money_source_tb Where  MoneyS_C='$MoneyS_C' ";

                $result3 = $dbObj->execQuery($sql3);

                $rs3 = $dbObj->fetchArray($result3);

                    echo $rs3['MoneyS_M'];

             ?>

                    </a></td>

                  </tr>

                <?php 

               $no++;

            } # while 

            //$dbObj->freeresult($result1);

          ?>

                </table>

              <?php } #if ?>

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

                <tr>

                  <td align="center">

                    <?php if( $numrows > 0 ) { ?>

                    <table width="99%" height="29" border="0" align="center" cellpadding="0" cellspacing="0">

                      <tr>

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

                        </tr>

                      <tr>

                        <td align="left"><span style="font-size:12px">หน้า: 

                          <?php

                        /**  ตรวจสอบการ Order By ของ Query */

                        if( $ASCDESC=="ASC") { $ASCDESC = "DESC"; }  else { $ASCDESC="ASC"; } 

                        

                        $paging = ceil($numrows/$limit);

                                

                        //=== Display the navigation

                        if ($display > 1) {    

                            $previous = $display - 1;                    

                    ?><a href="<?=$PHP_SELF;?>?Flag=<?=$Flag;?>&amp;page=1&amp;perpage=<?=$perpage;?>&amp;OrderBy=<?=$OrderBy;?>&amp;ASCDESC=<?=$ASCDESC;?>&amp;keyword=<?=$keyword;?>"><font color="#FE830B">|&laquo; หน้าแรก</font></a>&nbsp; <a href="<?=$PHP_SELF;?>?Flag=<?=$Flag;?>&amp;page=<?=$previous;?>&amp;perpage=<?=$perpage;?>&amp;OrderBy=<?=$OrderBy;?>&amp;ASCDESC=<?=$ASCDESC;?>&amp;keyword=<?=$keyword;?>"><font color="#FE830B">&laquo; ก่อนหน้า</font></a>

                          <?php

                        } // end..if

                        if($numrows != $limit) {                 

                            if($paging > $scroll) { 

                                $first = $_GET['page']; 

                                $last = ($scroll - 1) + $_GET['page']; 

                            } else {                         

                                $first = 1;                        

                                $last = $paging;                        

                            } 

                            

                            if($last > $paging ) {                            

                                $first = $paging - ($scroll - 1);                            

                                $last = $paging;                            

                            }

                                            

                            for($i=$first; $i<=$last; $i++) {                        

                                if($display == $i) {        

                                    echo "<font color=red size=2> [<strong>$i</strong>] </font>";

                                } 

                                else {

                                    //echo " <a href=\"$PHP_SELF?page=$i&user_id=$user_id&user_login=$user_login\">$i</a> ";

                                    printf(" <a href=\"%s?Faculty_code=%s&page=%s&perpage=%s&OrderBy=%s&ASCDESC=%s&keyword=%s\">%s</a> ", $_SERVER['PHP_SELF'], $Flag, $i, $perpage, $OrderBy, $ASCDESC, $keyword, $i );

                                }        

                            } // end..for

                        } // end..if

                            

                        if($display < $paging) {

                            $next = $display + 1;                        

                    ?>&nbsp;<a href="<?=$PHP_SELF;?>?Flag=<?=$Flag;?>&amp;page=<?=$next;?>&amp;perpage=<?=$perpage;?>&amp;OrderBy=<?=$OrderBy;?>&amp;ASCDESC=<?=$ASCDESC;?>&amp;keyword=<?=$keyword;?>"><font color="#FE830B">ถัดไป &raquo;</font></a> &nbsp;<a href="<?=$PHP_SELF;?>?Flag=<?=$Flag;?>&amp;page=<?=$paging;?>&amp;perpage=<?=$perpage;?>&amp;OrderBy=<?=$OrderBy;?>&amp;ASCDESC=<?=$ASCDESC;?>&amp;keyword=<?=$keyword;?>">หน้าสุดท้าย &raquo;|</a></a><?php

                    } // end..if

                ?></a></td>

                        </tr>

                      </table>

                    <?php } #if ?></td>

                  </tr>

              </table></td>

          </tr></form>

        </table>

    </fieldset></td>

  </tr>

</table>

</body>

</html>

<?php

    /**  Free Resource */

    $dbObj->freeresult($result);

    $dbObj->freeresult($result0);

    

    /**  Close the Database  */

    $dbObj->disconn();

    

    /**  Unset Class  */

    unset($dbObj);

?>