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

"; echo "LIST OF CLEARANCE FORM CREATED"; echo "

Period Covered: ".$lcsDate." - ".$lceDate."

"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //$getCompany = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$lcsDate' AND '$lceDate' AND `cl_status`= 1 AND `cl_h_comp_id`='$comID' ORDER BY `cl_h_date_created` ASC"); $getCompany = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$lcsDate' AND '$lceDate' AND `cl_h_comp_id`='$comID' AND `cl_h_hr_approval`!='DISAPPROVED' AND `cl_h_hr_approval`!='FOR HR APPROVAL'"); while($row = mysql_fetch_array($getCompany)){ $count = $count + 1; $selEmpID=$row['cl_h_emp_id']; $KeyCode=$row['key_code']; $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); $dealershipID = mysql_result(mysql_query("SELECT `dealer` FROM `vts_users` WHERE `u_id`='$selEmpID'"),0); $dealershipName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$dealershipID'"),0); $clApproverCount = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `key_code` ='$KeyCode' AND `cl_approver_id_a`!=0"),0); $clInSLA = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `key_code` ='$KeyCode' AND `cl_approver_id_a`!=0 AND `cl_approved_by_id`!= 0 AND `cl_actual_sla` < 4 AND `cl_actual_sla` != 0"),0); $clSigned = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `key_code` ='$KeyCode' AND `cl_approver_id_a`!=0 AND `cl_approved_by_id`!= 0 AND `cl_actual_sla` > 3 AND `cl_actual_sla` != 0"),0); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } if($count < 1 ){ echo ""; echo ""; echo ""; } echo "

NO	DATE	NAME OF EMPLOYEE	DEALERSHIP	POSITION	REASON	STATUS	SLA RATING
".$count."	".strtoupper($row['cl_h_date_created'])."	".strtoupper($SelLName).", ".strtoupper($SelFName)."	".strtoupper($dealershipName)."	".strtoupper($selPosition)."	".strtoupper($row['cl_h_reason'])."	".strtoupper($row['cl_h_hr_approval'])."	"; $slaRate = ($clInSLA / $clApproverCount) * 100; $slaRateR = number_format($slaRate,2,'.','')." %"; echo $slaRateR; echo "
-- NO RECORD FOUND -- --

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

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

"; echo "