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);
$fileLinkT = mysql_result(mysql_query("SELECT `cl_check_request_attachment` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0);
$resLetter = mysql_result(mysql_query("SELECT `cl_resignation_letter` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0);
$accLetter = mysql_result(mysql_query("SELECT `cl_acceptance_letter` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0);
$effectiveDate =mysql_result(mysql_query("SELECT `cl_effectivity_date` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0);
$QCLetter = mysql_result(mysql_query("SELECT `cl_quit_claim_document` FROM `cl_clearance_header` WHERE `h_id`='$clearanceID'"),0);
$WVLetter =mysql_result(mysql_query("SELECT `cl_waiver_document` 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 "EFFECTIVITY DATE:
";
echo "".$effectiveDate."
";
echo "";
echo "Uploaded Documents:
";
if($resLetter != ''){
echo "";
}else{
echo "";
}
if($accLetter != ''){
echo "";
} else{
echo "";
}
//echo "";
exit();
}
?>