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

"; echo "EXECUTIVE SUMMARY REPORT"; echo "

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

"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $gTotal = 0; $gReleased = 0; $gOnGoing = 0; $gDeferred = 0; $gReady = 0; $slagRate = 0; $slagOK = 0; $getCompany = mysql_query("SELECT * FROM `vts_company` WHERE `comp_status`=1 ORDER BY `comp_name` ASC"); while($row = mysql_fetch_array($getCompany)){ $clCreated=0; $clReleased = 0; $clTotal = 0; $clOngoing = 0; $clDeferred=0; $clReady=0; $selCompID=$row['comp_id']; $counter = $counter + 1; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

COMPANY NAME	CLEARANCE CREATED	CLEARANCE RELEASED	ON-GOING	DEFERRED	READY FOR RELEASE	SLA COMPLIANCE
".strtoupper($row['comp_name'])."	"; $clCreated = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID'"),0); echo $clCreated; $gTotal = $gTotal + $clCreated; echo "	"; $clTotal = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_h_hr_approval`='CLOSED'"),0); echo $clTotal; $gReleased = $gReleased + $clTotal; echo "	"; $clOngoing = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_h_hr_approval`!='CLOSED'"),0); echo $clOngoing; $gOnGoing = $gOnGoing + $clOngoing; echo "	"; $clDeferred = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_second_wave` = 'DEFERRED'"),0); echo $clDeferred; $gDeferred = $gDeferred + $clDeferred; echo "	"; $clReady= mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_h_hr_approval` = 'READY FOR RELEASE'"),0); echo $clReady; $gReady = $gReady + $clReady; echo "	"; $slaOK = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_consumed_days` < 31"),0); $slaIsNot = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_consumed_days` > 30"),0); $slaRatings= ($slaOK / $clCreated) * 100; $slaRate = number_format($slaRatings,2,'.','')." %"; echo $slaRate; $slagOK = $slagOK + $slaOK; echo "
	"; echo $gTotal; echo "	"; echo $gReleased; echo "	"; echo $gOnGoing ; echo "	"; $clDeferred = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_second_wave` = 'DEFERRED'"),0); echo $clDeferred; $gDeferred = $gDeferred + 1; echo "	"; echo $gReady; echo "	"; $mySLA = number_format((($slagOK / $gTotal) * 100),2, '.','') . " %"; echo $mySLA; echo "

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

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

"; echo "