"; echo "

AUTOHUB GROUP
Global City Taguig

"; echo "

TICKET SUMMARY LIST

"; echo "

By: ".$fName." ".$lName."


"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $qq =mysql_query("SELECT * FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' ORDER BY `id` ASC"); $rEx = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `ratings`='EXCELLENT'"),0); $rVS = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `ratings`='VERY SATISFACTORY'"),0); $rSat = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `ratings`='SATISFACTORY'"),0); $rNoRate = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `ratings`=''"),0); $rBS = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `ratings`='BELOW SATISFACTORY'"),0); $rPoor = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `ratings`='POOR'"),0); $AssignedTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd'"),0); $ClosedTickets = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `current_status`='CLOSED'"),0); $PendingTickets = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `current_status`!='CLOSED' AND `current_status`!='CANCELLED'"),0); $withinSLATickets = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `current_status`='CLOSED' AND `ticket_sla` >= 0"),0); $beyondSLATickets = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `current_status`='CLOSED' AND `ticket_sla` < 0"),0); $aveSLA = mysql_result(mysql_query("SELECT AVG(`ticket_sla`) FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `current_status`='CLOSED'"),0); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //==============BY CATEGORY echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
TICKET COUNT SUMMARY Date Range: ".$dateStart." to ".$dateEnd."
TICKET ASSGINEDTICKET CLOSEDPENDINGRESOLVED WITHIN SLARESOLVED BEYOND SLAYOUR AVE. SLA (Minutes)
".number_format($AssignedTicket,1,'.',',')."".number_format($ClosedTickets,1,'.',',')."".number_format($PendingTickets,1,'.',',')."".number_format($withinSLATickets,1,'.',',')."".number_format($beyondSLATickets,1,'.',',')."".number_format(($aveSLA/$AssignedTicket),2,'.',',')."
TICKET BY CATEGORY
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $qq =mysql_query("SELECT * FROM `pms_ticket_category` WHERE `dept_code` ='$deptCode' ORDER BY `name` ASC"); while($crow=mysql_fetch_array($qq)){ $catID = $crow['id']; $ticketByCat = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `category_id`='$catID' "),0); $CaveSLA = mysql_result(mysql_query("SELECT AVG(`ticket_sla`) FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `current_status`='CLOSED' AND `category_id`='$catID'"),0); $beyondSLATickets = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to` ='$empID' AND `date_sent` BETWEEN '$dateStart' AND '$dateEnd' AND `current_status`='CLOSED' AND `ticket_sla` < 0"),0); if($CaveSLA >= 0){ $txtColor='blue'; }else { $txtColor='red'; } echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
CATEGORY COUNTAVE. SLA(Minutes)
".$crow['name']."".number_format($ticketByCat,1,'.',',')."".number_format(($CaveSLA/$ticketByCat),1,'.',',')."
"; echo"
CUSTOMER SATISFACTION RATE
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
MEASUREMENT COUNT
EXCELLENT".$rEx."
VERY SATISFACTORY".$rVS."
SATISFACTORY".$rSat."
BELOW SATISFACTORY".$rBS."
POOR".$rPoor."
NO EVALUATION RECEIVED".$rNoRate."
"; echo"
"; echo ""; ?>