"; echo "


กรุณาทำการ Login ก่อน

"; echo ""; 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; /** Config Table for This Page */ $myTable1 = "personal_tb"; $myTable2 = "formcontract"; $myTable2PK = "codeId"; $Teacher_code = $_POST['Teacher_code']; $Noagree = trim($_POST['Noagree']); $maNo = trim( $_POST['maNo'] ); $Date = dmyE2ymdT($_REQUEST['mDate']); $Training_name = trim( $_POST['Training_name'] ); //ขออนุมัติ $Year_std = trim( $_POST['Year_std'] ); //$Date = ($y+543)."-".$m."-".$d; $Budget_use = $Smtotal + $STtotal + $Vehicletotal +$Crgestotal ; $sql = "SELECT * FROM formagree Where maNo='$maNo' and agreeId ='$agreeId' "; $result1 = mysql_query($sql); $num_rows = mysql_num_rows($result1); if($num_rows){ if($Filetex){ $query1 = " UPDATE formagree SET maNo='$maNo' , Teacher_code='$Teacher_code', contId='$contId' , Training_code='$Training_code' , MoneyS_C='$MoneyS_C' , Training_name='$Training_name' , Date='$Date' , Dayout='$Dayout' , Smtotal ='$Smtotal' , STtotal='$STtotal' , Vehicletotal='$Vehicletotal' , Crgestotal ='$Crgestotal' , Budget_use='$Budget_use' , Filetex='$Filetex' , Flag ='$Flag' , Year_std ='$Year_std' Where maNo='$maNo' and agreeId ='$agreeId' "; } else{ $query1 = " UPDATE formagree SET maNo='$maNo' , Teacher_code='$Teacher_code', contId='$contId' , Training_code='$Training_code' , MoneyS_C='$MoneyS_C' , Training_name='$Training_name' , Date='$Date' , Dayout='$Dayout' , Smtotal ='$Smtotal' , STtotal='$STtotal' , Vehicletotal='$Vehicletotal' , Crgestotal ='$Crgestotal' , Budget_use='$Budget_use' , Year_std ='$Year_std' Where maNo='$maNo' and agreeId ='$agreeId' "; } $result1 = $dbObj->runQuery($query1); $dbObj->freeresult($result1); } } # else ?> MIS -- Teacher
 
 
 
ระบบจัดเก็บข้อมูลของท่านเรียบร้อยแล้ว
กรุณารอส้กครู่ กำลังเปลี่ยนหน้าอัตโนมัติ
"; ?>
 
freeresult($result); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?>