format("Y-m-d");
$toTime =date('H:i:s');
$dateTime = $myDate . " ".$toTime;
if(isset($_POST['done'])){
$clearanceIDa = mysql_escape_string($_POST['clearanceIDa']);
$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`='$clearanceIDa'"),0);
$fileLinkT = mysql_result(mysql_query("SELECT `cl_check_request_attachment` FROM `cl_clearance_header` WHERE `h_id`='$clearanceIDa'"),0);
$resLetter = mysql_result(mysql_query("SELECT `cl_resignation_letter` FROM `cl_clearance_header` WHERE `h_id`='$clearanceIDa'"),0);
$accLetter = mysql_result(mysql_query("SELECT `cl_acceptance_letter` FROM `cl_clearance_header` WHERE `h_id`='$clearanceIDa'"),0);
$lastPayDate =mysql_result(mysql_query("SELECT `cl_lastpay_check_created_date` FROM `cl_clearance_header` WHERE `h_id`='$clearanceIDa'"),0);
$QCLetter = mysql_result(mysql_query("SELECT `cl_quit_claim_document` FROM `cl_clearance_header` WHERE `h_id`='$clearanceIDa'"),0);
$WVLetter =mysql_result(mysql_query("SELECT `cl_waiver_document` FROM `cl_clearance_header` WHERE `h_id`='$clearanceIDa'"),0);
echo "
";
echo "EMPLOYEE ID:
";
echo "".$SelEMPID."
";
echo "EMPLOYEE NAME:
";
echo "".$SelUserName."
";
echo "POSITION:
";
echo "".$SelPosition."
";
echo "CLEARANCE DATE:
";
echo "".$SelDateCreated."
";
echo "CHECK PREPARED DATE:
";
echo "".$lastPayDate."
";
echo "";
echo "Uploaded Documents:
";
if($resLetter != ''){
echo "";
}else{
echo "";
}
if($accLetter != ''){
echo "";
} else{
echo "";
}
echo "";
echo "";
if($QCLetter != ''){
echo "";
}else{
echo "";
}
if(!empty($WVLetter)){
echo "";
}else{
echo "";
}
//echo "";
exit();
}
?>