
<?php



    session_start();

    

    /**  Define Validate Access  */

    define( '_VALID_ACCESS', 1 ); 

    

    /**  Check Session User Login  */

      header('Content-type: application/xls');

     header('Content-Disposition: attachment; filename="testing.xls"');



    /**  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;



        //=== SESSION

        $Username = $valid_user; 

        

        

        /**  Config Table for This Page  */

        $myTable = "formaoffice";

        $myTable1 = "personal_tb";

        $myTablePK = "codeId";

                    

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

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

    

        

        

    } # 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" />



<title>แผนการดำเนินงาน : รายงานประเภทต่างๆ - ประวัติการขอไปราชการ</title>

</head>



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

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

  <tr bgcolor="#F8F8F8">

    <td width="37" height="25" align="center" bgcolor="#F8F8F8" class="BORDER-RIGHT"><strong>ลำดับ</strong></td>

    <td width="347" align="center" bgcolor="#F8F8F8"><strong>รายชื่อผู้ขออนุมัติเดินทางไปราชการ</strong></a></td>

    <td width="218" align="center" class="BORDER-LEFT">วันที่ไปราชการ</td>

    <td width="60" align="center" class="BORDER-LEFT">ข้อแผน</td>

    <td width="114" align="center" bgcolor="#F8F8F8" class="BORDER-LEFT">จำนวนเงิน</a></td>

  </tr>

  <?php 

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

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

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

          ?>

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

    <td height="22" align="center" class="BORDER-TOP-RIGHT"><span class="BORDER-TOP">

      <?=$no;?>

    </span></td>

    <td align="left" class="PADDING-LEFT-5 BORDER-TOP"><?=$row[maNo];?>

      </a>&nbsp;

        <?php

                         $Teacher_code =  $row["Teacher_code"];

                         $sql = "Select * From $myTable1   Where Teacher_code ='$Teacher_code'  ";

                         $result6 = mysql_query($sql) or die("Error".mysql_error());

                          $rs6 = mysql_fetch_array($result6);

                        echo "$rs6[First_name] $rs6[Teacher_name] &nbsp; $rs6[Teacher_lastname]";?>

      </a></td>

    <td align="center" class="BORDER-TOP BORDER-LEFT PADDING-LEFT-5"><?php 

                $sday = $row['Date_start'];

                $yearthai = explode("-",$sday);

                $day = intval($yearthai[2]);

                $month = intval($yearthai[1]);

                $year = intval($yearthai[0]);     

                $m = getThaiSubMonth($month);

                    echo "$day"." "."$m"." "."$year";

            ?>

-

  <?php 

                $sday = $row['Date_finish'];

                $yearthai = explode("-",$sday);

                $day = intval($yearthai[2]);

                $month =  intval($yearthai[1]);

                $year = intval($yearthai[0]);     

                $m = getThaiSubMonth($month);

                    echo "$day"." "."$m"." "."$year";

            ?></td>

    <td align="center" class="BORDER-TOP BORDER-LEFT PADDING-LEFT-5"></a><font size="2" face="Tahoma">

      <?php

        // $sql = "Select * From   project_tb     Where    ProjectId='$row[ProjectId]'   AND      Teacher_code='$row[Teacher_code]'   ";

        //  $result2 = mysql_query($sql) or die("Error".mysql_error());

        //  $rs2 = mysql_fetch_array($result2);

        //  echo "$rs2[Orderlist]";

        echo "$row[Orderlist]";

                  ?>

      </font></td>

    <td align="center" class="BORDER-TOP BORDER-LEFT PADDING-LEFT-5"><?php 

                //$sql3 = " SELECT SUM(Budget_use) AS SumB1  FROM   project_tb  WHERE  ProjectId='$row[ProjectId]'  And   Teacher_code='$row[Teacher_code]'  ";

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

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

                //    echo number_format($rs3['SumB1'],2,'.',','); 

                echo   number_format($row['Budget_use'],2,'.',','); 

            ?></td>

             <?php 

               $no++;

            } # while 

            $dbObj->freeresult($result);

          ?>

  </tr>

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

    <td height="22" colspan="4" align="center" class="BORDER-TOP-RIGHT">รวมเงิน</td>

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

      <?php

                $sql4 = " SELECT SUM(Budget_use) AS SumB2  FROM $myTable  WHERE  Year_std='$Year_std'  ";

                $result4 = $dbObj->execQuery($sql4);

                $rs4 = $dbObj->fetchArray($result4);

                $dbObj->freeresult($result4);

                    echo number_format($rs4['SumB2'],2,'.',','); 

            ?>

    </strong></td>

  </tr>

 </table>

</body>

</html>

<?php

    /**  Free Resource */

    $dbObj->freeresult($result1);

    

    /**  Close the Database  */

    $dbObj->disconn();

    

    /**  Unset Class  */

    unset($dbObj);

?>