Viewing file: FrmAbsent_01.php (25.9 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" );
/** Create Database Object */
$dbObj = new DBConn;
/** Config Table for This Page */
$myTable = "personal_tb";
$myTable2 = "history_absent_tb";
$myTable1 = "budget_year_tb";
$query = "SELECT *, prefixName as First_name FROM personal_tb
LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId
LEFT JOIN position_tb ON personal_tb.PositionId = position_tb.PositionId
LEFT JOIN faculty_tb ON personal_tb.Faculty_code = faculty_tb.Faculty_code
LEFT JOIN district ON personal_tb.districtId = district.districtId
LEFT JOIN amphur ON personal_tb.amphurId = amphur.amphurId
LEFT JOIN province ON personal_tb.provinceId = province.provinceId
WHERE personal_tb.Teacher_code='".$_REQUEST['Teacher_code']."'";
$result = $dbObj->execQuery($query);
$rss = $dbObj->fetchArray($result);
$query1 = " SELECT * FROM $myTable1 ";
$result1 = $dbObj->execQuery($query1);
$rs4 = $dbObj->fetchObject($result1);
$query2 = " SELECT * FROM $myTable2 WHERE code='$code' ";
$result2 = $dbObj->execQuery($query2);
$rs1 = $dbObj->fetchArray($result2);
$query2 = " SELECT * FROM $myTable2 Where Teacher_code='$rss[Teacher_code]' and Year='$Year' ";
$result2 = $dbObj->execQuery($query2);
$rs2 = $dbObj->fetchObject($result2);
$query2 = " SELECT * FROM $myTable2 WHERE Teacher_code='$Teacher_code' ORDER BY Date_finish DESC ";
$result2 = $dbObj->execQuery($query2);
$rs3 = $dbObj->fetchArray($result2);
/** โฟลเดอร์ไฟล์เอกสาร */
$doc_path = $_Config_live_site."/Absent_pic";
} # else
?>
MIS -- Teacher
freeresult($result);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> bool(false)
|