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

"; echo "LIST OF CLERANCE FOR RELEASE"; echo "

Period Covered: ".$hsDate." - ".$heDate."

"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $getCompany = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_date_of_release` BETWEEN '$hsDate' AND '$heDate' AND `cl_status`= 1 AND `cl_h_comp_id`='$comID' AND `cl_h_hr_approval`='READY FOR RELEASE' AND `cl_second_wave`='READY FOR RELEASE' 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 "

DATE CREATED	NAME OF EMPLOYEE	DEALERSHIP	POSITION	SCHEDULE OF RELEASE	STATUS
".strtoupper($row['cl_h_date_created'])."	".strtoupper($SelLName).", ".strtoupper($SelFName)."	".strtoupper($dealershipName)."	".strtoupper($selPosition)."	".strtoupper($row['cl_date_of_release'])."	".strtoupper($row['cl_second_wave'])."
-- NO RECORD FOUND -- --

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

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

"; echo "