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

"; echo "COMPLITED CLEARANCE WITHIN SLA"; echo "

Period Covered: ".$jsDate." - ".$jeDate."

"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $getCompany = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_lastpay_released_date` BETWEEN '$jsDate' AND '$jeDate' AND `cl_h_comp_id`='16' AND `cl_h_hr_approval`='CLOSED' AND `cl_consumed_days` < 31 AND `cl_consumed_days` !=0 ORDER BY `cl_h_date_created` ASC "); 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 ""; } if($count < 1 ){ echo ""; echo ""; echo ""; } echo "

NAME OF EMPLOYEE	DEALERSHIP	POSITION	DATE CREATED	DATE RELEASED	TIME FRAME
".strtoupper($SelLName).", ".strtoupper($SelFName)."	".strtoupper($dealershipName)."	".strtoupper($selPosition)."	".strtoupper($row['cl_h_date_created'])."	".strtoupper($row['cl_lastpay_released_date'])."	".strtoupper($row['cl_consumed_days'])."
-- NO RECORD FOUND -- --

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

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

"; echo "