File manager

File manager - Edit - /home/autoph/public_html/portal/reports/ticket/rptTicketSummaryCount.php

Back
<?php include '../core/init.php'; $deptCode = $user_data['dept_code']; //echo "DPT:". $deptCode; $dateStart=$_GET['dateStart']; $dateEnd=$_GET['dateEnd']; $empID=$_GET['empID']; $reportType=$_GET['reportType']; $fName = mysql_result(mysql_query("SELECT `u_fname` FROM `c_users` WHERE `emp_id`='$empID'"),0); $lName = mysql_result(mysql_query("SELECT `u_lname` FROM `c_users` WHERE `emp_id`='$empID'"),0); //START OF REPORT VIEWER echo "<center>"; echo "<p style='font-family:Calibri;font-size:18px;font-weight:bold;'>AUTOHUB GROUP <br><b style='font-size:12px;font-weight:normal;'>Global City Taguig</b></p>"; echo "<p style='font-family:Calibri;font-size:14px;font-weight:bold;'>TICKET SUMMARY LIST <br> <b style='font-weight:normal'></b></p>"; echo "<p style='font-family:Calibri;font-size:14px;font-weight:normal;'>By: ".$fName." ".$lName."</p><br>"; echo "<table style='border-collapse:collapse;width:99%;margin:10px;'>"; echo "<tr>"; echo "<td colspan='6' style='font-family:Calibri Light;font-size:12px;width:16%;height:25px;padding:2px;border:0px solid gray;background:#fff'> <b style='font-family:Calibri;font-size:16px;margin-right:20px;'>TICKET COUNT SUMMARY </b> Date Range: ".$dateStart." to ".$dateEnd."</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:15%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>TICKET ASSGINED</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:15%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>TICKET CLOSED</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:15%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>PENDING</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:15%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>RESOLVED WITHIN SLA</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:15%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>RESOLVED BEYOND SLA</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:15%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>YOUR AVE. SLA (Minutes)</td>"; echo "</tr>"; $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 "<tr>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".number_format($AssignedTicket,1,'.',',')."</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".number_format($ClosedTickets,1,'.',',')."</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".number_format($PendingTickets,1,'.',',')."</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".number_format($withinSLATickets,1,'.',',')."</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".number_format($beyondSLATickets,1,'.',',')."</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".number_format(($aveSLA/$AssignedTicket),2,'.',',')."</td>"; echo "</tr>"; //==============BY CATEGORY echo "<tr>"; echo "<td colspan='6'style='font-family:Calibri Light;font-size:12px;width:10%;height:100px;padding:2px;border:0px solid gray;background:#fff'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='6' style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:0px solid gray;background:#fff'><b style='font-family:Calibri;font-size:16px;'>TICKET BY CATEGORY </b><br>"; echo "<table style='border-collapse:collapse;width:400px;'>"; echo "<tr>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:40%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>CATEGORY </td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:20%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>COUNT</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:30%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>AVE. SLA(Minutes)</td>"; echo "</tr>"; $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 "<tr>"; echo "<td style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff;padding-left:10px;'>".$crow['name']."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff;padding-left:10px;'>".number_format($ticketByCat,1,'.',',')."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff;padding-left:10px;color:$txtColor;'>".number_format(($CaveSLA/$ticketByCat),1,'.',',')."</td>"; echo "</tr>"; } echo "</table>"; echo"</td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='6'style='font-family:Calibri Light;font-size:12px;width:10%;height:50px;padding:2px;border:0px solid gray;background:#fff'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='6' style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:0px solid gray;background:#fff'><b style='font-family:Calibri;font-size:16px;'>CUSTOMER SATISFACTION RATE</b><br>"; echo "<table style='border-collapse:collapse;width:400px;'>"; echo "<tr>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:50%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>MEASUREMENT </td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;width:20%;height:25px;padding:2px;border:1px solid gray;background:#fff;font-weight:bold'>COUNT</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:50%;height:25px;padding:2px;border:0px solid gray;background:#fff;font-weight:bold'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:50%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>EXCELLENT</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;width:20%;height:25px;padding:2px;border:1px solid gray;background:#fff;font-weight:bold'>".$rEx."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:30%;height:25px;padding:2px;border:0px solid gray;background:#fff;font-weight:bold'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:50%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>VERY SATISFACTORY</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;width:20%;height:25px;padding:2px;border:1px solid gray;background:#fff;font-weight:bold'>".$rVS."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:30%;height:25px;padding:2px;border:0px solid gray;background:#fff;font-weight:bold'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:50%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>SATISFACTORY</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;width:20%;height:25px;padding:2px;border:1px solid gray;background:#fff;font-weight:bold'>".$rSat."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:30%;height:25px;padding:2px;border:0px solid gray;background:#fff;font-weight:bold'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:50%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>BELOW SATISFACTORY</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;width:20%;height:25px;padding:2px;border:1px solid gray;background:#fff;font-weight:bold'>".$rBS."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:30%;height:25px;padding:2px;border:0px solid gray;background:#fff;font-weight:bold'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:50%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>POOR</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;width:20%;height:25px;padding:2px;border:1px solid gray;background:#fff;font-weight:bold'>".$rPoor."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:30%;height:25px;padding:2px;border:0px solid gray;background:#fff;font-weight:bold'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:50%;height:25px;padding:2px;border:1px solid gray;background:#fafafa;font-weight:bold'>NO EVALUATION RECEIVED</td>"; echo "<td align='center' style='font-family:Calibri Light;font-size:12px;width:20%;height:25px;padding:2px;border:1px solid gray;background:#fff;font-weight:bold'>".$rNoRate."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:30%;height:25px;padding:2px;border:0px solid gray;background:#fff;font-weight:bold'> </td>"; echo "</tr>"; echo "</table>"; echo"</td>"; echo "</tr>"; echo "</table>"; echo "</center>"; ?>

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0 | proxy | phpinfo | Settings