"; 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"; list($d,$m,$y) = split('/',$_REQUEST["Date"]); list($dStart,$mStart,$yStart) = split('/',$_REQUEST["dateStart"]); list($dFinish,$mFinish,$yFinish) = split('/',$_REQUEST["dateFinish"]); $Teacher_code = $_POST['Teacher_code']; $maNo = trim( $_POST['maNo'] ); $Date = ($y+543)."-".$m."-".$d; $Date_start = ($yStart+543)."-".$mStart."-".$dStart; $Date_finish = ($yFinish+543)."-".$mFinish."-".$dFinish; $Training_name = trim( $_POST['Training_name'] ); //ขออนุมัติเดินทางไปราชการ $WithMon = trim( $_POST['WithMon'] ); $MoneyS_C = $_POST['MoneyS_C']; $Day = trim( $_POST['Day'] ); // $Detail = trim( $_POST['Detail'] ); // $Budget = trim( $_POST['Budget'] ); // $Flag2 = 'N' ; $Flag = trim($_REQUEST["Flag"]); $sql = "SELECT * FROM formcontract Where maNo='$maNo' and contId ='$contId' "; $result1 = mysql_query($sql); $num_rows = mysql_num_rows($result1); if($num_rows){ if($Filetex){ $query1 = " UPDATE formcontract SET Teacher_code='$Teacher_code' , maNo='$maNo' , provinceId='$provinceId', Training_name='$Training_name', Date='$Date', Date_start='$Date_start' , Date_finish='$Date_finish', WithMon='$WithMon', MoneyS_C='$MoneyS_C', Day='$Day' , Detail='$Detail' , Budget='$Budget', Flag2='$Flag2' ,Flag='$Flag' , Year_std='$Year_std' ,Filetext ='$Filetex' Where maNo='$maNo' and contId ='$contId' "; } else{ $query1 = " UPDATE formcontract SET Teacher_code='$Teacher_code' , maNo='$maNo' , provinceId='$provinceId', Training_name='$Training_name', Date='$Date', Date_start='$Date_start' , Date_finish='$Date_finish', WithMon='$WithMon', MoneyS_C='$MoneyS_C', Day='$Day' , Detail='$Detail' , Budget='$Budget', Flag2='$Flag2' ,Flag='$Flag' , Year_std='$Year_std' Where maNo='$maNo' and contId ='$contId' "; } $result1 = $dbObj->runQuery($query1); $dbObj->freeresult($result1); } } # else ?> MIS -- Teacher
 
 
 
ระบบจัดเก็บข้อมูลของท่านเรียบร้อยแล้ว
กรุณารอส้กครู่ กำลังเปลี่ยนหน้าอัตโนมัติ
"; ?>
 
freeresult($result); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?>