";
echo "
❖ CLEARANCE INFORMATION
";
echo "
Effectivity Date:
".strtoupper($clEffectivityDate)."
";
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 "
From:
".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 `key_code`='$keyCode' AND `cl_approver_id_a` != '0' || `key_code`='$keyCode' AND `cl_approver_id_b` != 0"),0);
$countApproved = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `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 "