"; echo ""; echo ""; echo "

"; echo "OFFICERS SLA COMPLIANCE REPORT
Autohub Wide"; echo "

Period Covered: ".$sDate." - ".$eDate."

"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $getCompany = mysql_query("SELECT * FROM `vts_users` WHERE `approver`= 1 AND `u_status`=1 ORDER BY `u_lname` ASC"); while($row = mysql_fetch_array($getCompany)){ $clSigned = 0; $clInSLA = 0; $clOutSLA = 0; $slaRate = 0; $selEmpID=$row['u_id']; $selCompID=$row['company']; $SelCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$selCompID'"),0); $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); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

NAME OF APPROVING OFFICERS	COMPANY	CLEARANCE SIGNED	COMPLIANT	NON-COMPLIANT	RATINGS
".strtoupper($SelLName).", ".strtoupper($SelFName)."	".strtoupper($SelCompName)."	"; $clSigned = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `cl_sla_start` BETWEEN '$sDate' AND '$eDate' 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 '$sDate' AND '$eDate' AND `cl_approved_by_id`='$selEmpID' AND `cl_actual_sla` < 4 AND `cl_actual_sla` != 0"),0); echo $clInSLA; echo "	"; $clOutSLA = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `cl_sla_start` BETWEEN '$sDate' AND '$eDate' AND `cl_approved_by_id`='$selEmpID' AND `cl_actual_sla` > 3 AND `cl_actual_sla` != 0"),0); echo $clOutSLA; echo "	"; $slaRate = ($clInSLA / $clSigned) * 100; $slaRateR = number_format($slaRate,2,'.','')." %"; echo $slaRateR; echo "

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

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

"; echo "