";
echo "";
exit();
}
else {
/** Configuration */
require_once( "../configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
require_once( "../include/Function.php" );
require_once("../link/function.php");
/** Create Database Object */
$dbObj = new DBConn;
/** Config Table for This Page */
$myTable = "personal_tb";
$myTable1 = "budget_year_tb";
$myTable2 ="durable_type_tb";
/*----- personal_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 formagree ON formagree.Teacher_code = personal_tb.Teacher_code WHERE personal_tb.Teacher_code = '".$_REQUEST["Teacher_code"]." ' ";
$result = $dbObj->execQuery($query);
$rss = $dbObj->fetchArray($result);
$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 training_tb ON personal_tb.Teacher_code = training_tb.Teacher_code LEFT JOIN formaoffice ON training_tb.Teacher_code = formaoffice.Teacher_code LEFT JOIN formofficemoney ON formaoffice.codeId = formofficemoney.codeId WHERE formofficemoney.Teacher_code = '".$_REQUEST["Teacher_code"]." ' and training_tb.Training_code = '".$_REQUEST["Training_code"]." ' and formofficemoney.codeId = '".$_REQUEST["codeId"]." ' and formaoffice.maNo = '".$_REQUEST["maNo"]." ' ";
$result5 = $dbObj->execQuery($query);
$rs = $dbObj->fetchArray($result5);
$query7 = "SELECT * FROM formaoffice WHERE maNo = '$maNo' AND Flag = '$Flag'";
$result7 = $dbObj->execQuery($query7);
$rs7 = $dbObj->fetchArray($result7);
$sql8 = " SELECT * FROM formaoffice f LEFT JOIN personal_tb p ON f.Teacher_code=p.Teacher_code LEFT JOIN prefix ON p.First_name=prefix .prefixId LEFT JOIN position_tb pt ON p.PositionId=pt.PositionId WHERE NOT f.codeId IN ( SELECT codeId FROM form_costestimates) AND maNo = '$maNo' ";
$query8 = mysql_query($sql8);
$rs8 = mysql_fetch_array($query8);
} # else
?>
<?=$_Config_sitename;?>
freeresult($result);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?>