format("Y-m-d");
$toTime =date('H:i:s');
$dateTime = $myDate . " ".$toTime;
if(isset($_POST['done'])){
$clearanceID = mysql_escape_string($_POST['clearanceID']);
$SelUserName = mysql_escape_string($_POST['SelUserName']);
$SelEMPID = mysql_escape_string($_POST['SelEMPID']);
$SelDateCreated = mysql_escape_string($_POST['SelDateCreated']);
$SelPosition = mysql_escape_string($_POST['SelPosition']);
$fileLink = mysql_result(mysql_query("SELECT `cl_final_computation` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0);
$apprCheckRequest = mysql_result(mysql_query("SELECT `cl_check_request_attachment` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0);
$lastPayDate =mysql_result(mysql_query("SELECT `cl_computation_date` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0);
echo "
";
echo "EMPLOYEE ID:
";
echo "".$SelEMPID."
";
echo "EMPLOYEE NAME:
";
echo "".$SelUserName."
";
echo "POSITION:
";
echo "".$SelPosition."
";
echo "CLEARANCE DATE:
";
echo "".$SelDateCreated."
";
echo "COMPUTATION DATE:
";
echo "".$lastPayDate."
";
echo "";
echo "";
//echo "";
exit();
}
?>