";
echo "
❖ CLEARANCE INFORMATION
";
echo "
ID NUMBER:
".strtoupper($uEMPID)."
";
echo "
Employee Name:
".strtoupper($uFName)." ".strtoupper($uLName)."
";
echo "
Position:
".strtoupper($uPosition)."
";
echo "
Company Assignment:
".strtoupper($uCompany)."
";
echo "
Dealerships:
".strtoupper($uDealer)."
";
echo "
Reason for Securing Clearance:
".strtoupper($clReason)."
";
echo "
Unit Assignment:
".strtoupper($clUnitAssignment)."
";
echo "
Form:
".strtoupper($clFrom)."
";
echo "
To:
".strtoupper($clTo)."
";
echo "
Notes / Remarks:
".strtoupper($cLNotes)."
";
echo "
";
$countTotalApprover = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `cl_hdr_id`='$ClearanceDataID' AND `key_code`='$keyCode' AND `cl_approver_id_a` != '0' || `cl_hdr_id`='$ClearanceDataID' AND `key_code`='$keyCode' AND `cl_approver_id_b` != 0"),0);
$countApproved = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `cl_hdr_id`='$ClearanceDataID' AND `key_code`='$keyCode' AND `cl_approved_by_id` != '0' AND `cl_approved_date` !=''"),0);
$compRate = number_format((($countApproved / $countTotalApprover) * 100),2) . "%";
echo "Completion Rate: (".$compRate.")";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
❖ APPROVAL SUMMARY
";
echo "
CREATED BY:
";
echo "
".strtoupper($crLName).", ".strtoupper($crFName).":
".$createdDate."
";
echo "
AUTHORIZED BY:
";
echo "
".strtoupper($uhrLName).", ".strtoupper($uhrFName).":
".$authDate."
";
echo "
ENDORSED BY:
";
echo "
".strtoupper($urcLName).", ".strtoupper($urcFName).":
".$RecoDateA."
";
echo "
CONFIRMED BY:
";
echo "
".strtoupper($urcbLName).", ".strtoupper($urcbFName).":
".$RecoDateB."
";
echo "
APPROVED BY:
";
echo "
".strtoupper($uarLName).", ".strtoupper($uarFName).":
".$AprDate."
";
echo "