File manager - Edit - /home/autoph/public_html/tasks/ticket_dept_response_rate.php.tar
Back
home/autoph/public_html/portal/portal/ticket_dept_response_rate.php 0000644 00000003256 15025116216 0022046 0 ustar 00 <?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); $PASS = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `response_rate` < 11"),0); $FAILED = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `response_rate` > 10 "),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)'], ['PASSED', <?php echo $PASS;?>], ['FAILED', <?php echo $FAILED;?>] ]); var options = { legend: 'none', pieSliceText: 'label', title: 'AVERAGE RESPONSE RATE (BY DEPARTMENT)', pieStartAngle: 100, }; var chart = new google.visualization.PieChart(document.getElementById('piechartC')); chart.draw(data, options); } </script> </head> <body> <div id="piechartC" style="float:left;width: 400px; height: 320px;border:0px solid red;border-right:0px solid red;padding:0px"> </div> </body> </html>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings