Viewing file: InsertFormPersonN.php (5.73 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( "../include/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
/** Config Table for This Page */
$myTable1 = "personal_tb";
$myTable2 = " formaoffice";
$myTable2PK = "codeId";
$Teacher_code = $_POST['Teacher_code'];
$code = $_POST['code'];
$ProjectId = $_POST['ProjectId'];
$No_in = trim( $_POST['No_in'] ); //้างตามหนังสือราชการเลขที่
$Detail = trim( $_POST['Detail'] );
$Date = $_POST['mYear']."-".$_POST['mMonth']."-".$_POST['mDate'];
$Date_start = $_POST['mYear1']."-".$_POST['mMonth1']."-".$_POST['mDate1'];
$Date_finish = $_POST['mYear2']."-".$_POST['mMonth2']."-".$_POST['mDate2'];
$Training_name = trim( $_POST['Training_name'] ); //ขออนุมัติเดินทางไปราชการ
$Training_type = $_POST['Training_type'];
$Organiz = $_POST['Organiz'];
$Day = trim( $_POST['Day'] ); //
$Year_std = trim( $_POST['Year_std'] ); //
$TeacherId = $_POST['TeacherId'];
$Budget_use = trim( $_POST['Budget_use'] ); //
$assignMent = trim( $_POST['assignMent'] ); //
$assignmentName = trim( $_POST['assignmentName'] ); //
$Status = trim( $_POST['Status'] ); //อ้างตามหนังสือราชการเลขที่
$Project_plan = trim( $_POST['Project_plan'] ); //รายละเอียด
$Fund_resource = trim( $_POST['Fund_resource'] ); // แหล่งเงินสนับสนุน
$Organiz = trim( $_POST['Organiz'] ); //หน่วยงานที่จัด
$Fund_resource = trim( $_POST['Fund_resource'] ); //แหล่งเงินสนับสนุน
$CNEU = trim( $_POST['CNEU'] ); //สถานที่จัด
$Flag2 = 'รออนุมัติ' ;
$Spending_use ="$Budget_use";
///*-------- นำค่า id มาเพิ่มให้กับค่ารหัสครั้งละ1 -----------*//
$query = " SELECT * FROM $myTable2 ORDER BY codeId DESC ";
$result = $dbObj->execQuery($query);
$rss= $dbObj->fetchArray($result);
$myTable2 = $rss[0]+1 ; // นำค่า id มาเพิ่มให้กับค่ารหัสสมาชิกครั้งละ1
$maNo = "$maOF$myTable2" ;
$i = 1;
while($i <= 16){
if($_POST['Teacher_code'.$i]){
InsertTraining ($_POST['Teacher_code'.$i], $Training_name, $Period_code, $Training_type, $Training_std, $Day, $Major, $Year_std, $Place, $Place_des, $Date_start, $Date_finish, $Total_hour, $Fund, $Budget_use, $Fund_resource, $Organiz, $CNEU, $Date_sent, $Period_prop, $Apply );
$Training_code = mysql_insert_id();
InsertFormA( $Training_code, $_POST['Teacher_code'.$i], $code, $Orderlist, $Project_plan, $ProjectId, $Travel, $No_in, $Status, $Detail, $Date, $Date_start, $Date_finish, $Training_name, $Training_type, $Day, $Year_std, $TeacherId, $Flag, $Flag1, $Flag2, $Budget_use,$maNo, $assignMent ,$assignmentName,$provinceId );
InsertProject( $Ind, $ProjectId, $Project_code, $ProjectNo, $MoneyId, $MoneyS_C, $programId, $Orderlist ,$Faculty_code, $_POST['Teacher_code'.$i] , $Orderlist_2, $Training_name ,$Project_plan, $Date, $Budget_use, $Spending_use, $Budget_Year, $Year , $Training_code ,$Flag , $proId );
}
$i++;
}
} # else
?>
MIS -- Teacher
freeresult($result);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> bool(false)
|