"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $getCompany = mysql_query("SELECT * FROM `vts_users` WHERE `approver`= 1 AND `u_status`= 1 AND `company`='$comID' ORDER BY `u_lname` ASC"); while($row = mysql_fetch_array($getCompany)){ $count = $count + 1; $clSigned = 0; $clInSLA = 0; $clOutSLA = 0; $slaRate = 0; $selEmpID=$row['u_id']; $SelFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$selEmpID'"),0); $SelLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$selEmpID'"),0); $selPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$selEmpID'"),0); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } if($count < 1 ){ echo ""; echo ""; echo ""; } echo "

NAME OF APPROVING OFFICERS	COMPANY	CLEARANCE SIGNED	COMPLIANT	NON-COMPLIANT	RATINGS
".strtoupper($SelLName).", ".strtoupper($SelFName)."	".strtoupper($selPosition)."	"; $clSigned = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `cl_sla_start` BETWEEN '$ccsDate' AND '$cceDate' AND `cl_approved_by_id`='$selEmpID'"),0); echo $clSigned; echo "	"; $clInSLA = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `cl_sla_start` BETWEEN '$ccsDate' AND '$cceDate' AND `cl_approved_by_id`='$selEmpID' AND `cl_actual_sla` < 4 "),0); echo $clInSLA; echo "	"; $clOutSLA = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `cl_sla_start` BETWEEN '$ccsDate' AND '$cceDate' AND `cl_approved_by_id`='$selEmpID' AND `cl_actual_sla` > 3 "),0); echo $clOutSLA; echo "	"; $slaRate = ($clInSLA / $clSigned) * 100; $slaRateR = number_format($slaRate,2,'.','')." %"; echo $slaRateR; echo "
-- NO RECORD FOUND -- --

"; //################################################################################################################################ echo "

"; echo "

"; echo ""; echo "

Prepared by: ".$FName." ".$LName."

"; echo "