File manager - Edit - /home/autoph/public_html/portal/portal/pod_ticket_dashboard.php
Back
<?php //$trCountOpen = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `current_status`!='CLOSED' AND `routed_to`='$myEMPID '"),0); //$trCountClosed = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `current_status`='CLOSED' AND `routed_to`='$myEMPID '"),0); $ex = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `ratings`='EXCELLENT'"),0); $vs = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `ratings`='VERY SATISFACTORY'"),0); $sa = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `ratings`='SATISFACTORY'"),0); $bs = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `ratings`='BELOW SATISFACTORY'"),0); $po = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `ratings`='POOR'"),0); $na = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `ratings`=''"),0); $totalTicketCount = $trCountOpen + $trCountClosed; $Comply = ($trCountClosed / $totalTicketCount) * 100; $notCOmply = 100 - $Comply; ?> <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load("current", {packages:["corechart"]}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['Language', 'Speakers (in millions)'], ['EX', <?php echo $ex;?>], ['VS', <?php echo $vs;?>], ['SAT', <?php echo $sa;?>], ['BS', <?php echo $bs;?>], ['PO', <?php echo $po;?>], ['NA', <?php echo $na;?>] ]); var options = { legend: 'none', pieSliceText: 'label', title: 'Ticket Breakdown based on ratings', pieStartAngle: 150, }; var chart = new google.visualization.PieChart(document.getElementById('piechart')); chart.draw(data, options); } </script> </head> <body> <div id="piechart" style="float:left;width: 400px; height: 320px;border:0px solid red;border-right:0px solid red;padding:0px"> </div> <div style="float:left;width:150px; height: 320px;border:0px solid red;border-right:0px dashed gray;padding:0px"> <p style='padding:2px;padding-bottom:1px;padding-top:10px;font-family:Calibri Light;font-size:16px;color:blue'><b style='font-family:Calibri;font-size:14px;color:red;margin-right:10px;font-weight:normal'><?php echo $ex;?></b>Excellent </p> <p style='padding:2px;padding-bottom:1px;padding-top:1px;font-family:Calibri Light;font-size:16px;color:blue'><b style='font-family:Calibri;font-size:14px;color:red;margin-right:10px;font-weight:normal'><?php echo $vs;?></b>Very Sat</p> <p style='padding:2px;padding-bottom:1px;padding-top:1px;font-family:Calibri Light;font-size:16px;color:blue'><b style='font-family:Calibri;font-size:14px;color:red;margin-right:10px;font-weight:normal'><?php echo $sa;?></b>Sat</p> <p style='padding:2px;padding-bottom:1px;padding-top:1px;font-family:Calibri Light;font-size:16px;color:blue'><b style='font-family:Calibri;font-size:14px;color:red;margin-right:10px;font-weight:normal'><?php echo $bs;?></b>Below Sat</p> <p style='padding:2px;padding-bottom:1px;padding-top:1px;font-family:Calibri Light;font-size:16px;color:blue'><b style='font-family:Calibri;font-size:14px;color:red;margin-right:10px;font-weight:normal'><?php echo $po;?></b>Poor</p> <p style='padding:2px;padding-bottom:1px;padding-top:1px;font-family:Calibri Light;font-size:16px;color:blue'><b style='font-family:Calibri;font-size:14px;color:red;margin-right:10px;font-weight:normal'><?php echo $na;?></b>NA </p> </div> <div style="float:left;width:500px; height: 320px;border:0px solid red;border-right:0px dashed gray;padding:0px"> <?php include 'ticket_personal_cust_sat.php';?> </div> <?php include 'ticket_progress_bar_chart.php';?> <br> </body> </html>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings