
<?php

//    print_r($_REQUEST);

    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" );

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

    

        /**  Create Database Object  */

        $dbObj = new DBConn;



        $maNo = $_REQUEST['maNo'];

        $Teacher_code = $_POST['Teacher_code'];

        $Training_code =   $_POST['Training_code'];

        $codeId = $_POST['codeId'];

        $Date = dmyE2ymdT($_REQUEST['mDate']);

        $Smtotal = $_POST['Smtotal'];

        $STtotal = $_POST['STtotal'];

        $Vehicletotal = $_POST['Vehicletotal'];

        $Crgestotal = $_POST['Crgestotal'];

         

         /*-----------------*/

                

        $sql11 = " SELECT * FROM  formaoffice Where maNo='$maNo' ";

        $result11 = mysql_query($sql11);

        while ($rs11 = mysql_fetch_array($result11)){

            $sql ="INSERT IGNORE INTO   form_costestimates(Cost_id, Teacher_code, Training_code, codeId, Smtotal, STtotal, Vehicletotal, Crgestotal) ";     

            $sql =$sql.  "VALUE ( '','".$rs11['Teacher_code']."', '".$rs11['Training_code']."', '".$rs11['codeId']."' , '$Smtotal' , '$STtotal' , '$Vehicletotal' ,  '$Crgestotal') " ;

            $res = mysql_query ($sql) or  die  ("$sql Insert  Has  incorrect".mysql_error()); 

        }

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

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

<title>MIS -- Teacher</title>

</head>



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

<?php

    include("../templates/incHeader.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"><fieldset>

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

      <form id="form1" name="form1" method="post" action="">

      <tr>

        <td>&nbsp;</td>

      </tr>

      <tr>

        <td style="padding-left:15px;"><strong><a href="index.php">หน้าหลัก</a> &raquo; <span class="NOTE">ใบขออนุมัติไปราชการ</span></strong></td>

      </tr>

      <tr>

        <td>&nbsp;</td>

      </tr>

      <tr>

        <td height="150" align="center"><span class="TEXT-GREEN10"><strong>ระบบจัดเก็บข้อมูลของท่านเรียบร้อยแล้ว</strong></span><br />

          กรุณารอส้กครู่ กำลังเปลี่ยนหน้าอัตโนมัติ<br />

          <?php   

         $sql12 = " SELECT * FROM  formaoffice Where maNo='$maNo' ";

        $result12 = mysql_query($sql12);

        $rs12 = mysql_fetch_array($result12);

        $Flag = $rs12["Flag"];

         echo "<meta http-equiv=\"refresh\" content=\"1; URL=CostEstimatesList.php?Flag=$Flag\">"; ?></td>

      </tr>

      <tr>

        <td>&nbsp;</td>

      </tr></form>

    </table>

   </fieldset></td>

  </tr>

</table>

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

</body>

</html>

<?php

    /**  Free Resource */

    $dbObj->freeresult($result);

    

    /**  Close the Database  */

    $dbObj->disconn();

    

    /**  Unset Class  */

    unset($dbObj);

?>