Viewing file: InsertFormContract.php (4.46 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | ";
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_use = trim( $_POST['Budget_use'] ); //
$Flag2 = 'N' ;
$Flag = trim($_REQUEST["Flag"]);
//### user_tb
$checkid = 0;
$sql11 = "SELECT * FROM formcontract Where maNo='$maNo' and Teacher_code='$Teacher_code' ";
$result11 = mysql_query($sql11);
while ($rs11 = mysql_fetch_array($result11)){
if ($rs11["Teacher_code"] == $Teacher_code){
echo "";
echo "";
echo "";
exit();
}else{
$checkid = 1;
}
}
if ($check == 0){
InsertFormContract ( $Teacher_code ,$maNo, $provinceId, $Training_name, $Date, $Date_start ,$Date_finish, $WithMon, $MoneyS_C, $Day , $Detail , $Budget, $Flag2 ,$Flag ,$Year_std );
}
} # else
?>
MIS -- Teacher
freeresult($result);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> |