File manager - Edit - /home/autoph/public_html/portal/reports/ticket/rptTicketSummaryReport.php
Back
<?php include '../core/init.php'; $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'>Date: ".$dateStart." to ".$dateEnd."</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:950px;'>"; 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 SUMMARY LIST - ASSIGNED TICKETS</b> Date Range: ".$dateStart." to ".$dateEnd."</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:5%;height:25px;padding:2px;border:1px solid gray;background:#fafafa'>NO</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:10%;height:25px;padding:2px;border:1px solid gray;background:#fafafa'>TICKET #</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:50%;height:25px;padding:2px;border:1px solid gray;background:#fafafa'>SUPPORT REQUEST DESCRIPTION</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:10%;height:25px;padding:2px;border:1px solid gray;background:#fafafa'>SENDER</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:10%;height:25px;padding:2px;border:1px solid gray;background:#fafafa'>DATE RAISED</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:10%;height:25px;padding:2px;border:1px solid gray;background:#fafafa'>DATE RESOLVED</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:10%;height:25px;padding:2px;border:1px solid gray;background:#fafafa'>SLA in Minutes</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;width:10%;height:25px;padding:2px;border:1px solid gray;background:#fafafa'>RATING</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"); while($row=mysql_fetch_array($qq)){ $count ++; $empTID = $row['emp_id']; $TfName = mysql_result(mysql_query("SELECT `u_fname` FROM `c_users` WHERE `u_id`='$empTID'"),0); $TlName = mysql_result(mysql_query("SELECT `u_lname` FROM `c_users` WHERE `u_id`='$empTID'"),0); echo "<tr>"; echo "<td style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".$count."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".$row['ticket_id']."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".$row['concerns']."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".$TlName.", ".$TfName."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".$row['date_sent']."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".$row['date_closed']."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".number_format($row['ticket_sla'],2,'.',',')."</td>"; echo "<td style='font-family:Calibri Light;font-size:12px;height:25px;padding:2px;border:1px solid gray;background:#fff'>".$row['ratings']."</td>"; echo "</tr>"; } echo "</table>"; echo "</center>"; ?>
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings