File manager - Edit - /home/autoph/public_html/portal/portal/ticket_department_donut.php
Back
<?php $dex = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `sent_to_dept`='$deptCode' AND `year`='$mycYear' AND `ratings`='EXCELLENT'"),0); $dvs = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `sent_to_dept`='$deptCode' AND `year`='$mycYear' AND `ratings`='VERY SATISFACTORY'"),0); $dsa = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `sent_to_dept`='$deptCode' AND `year`='$mycYear' AND `ratings`='SATISFACTORY'"),0); $dbs = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `sent_to_dept`='$deptCode' AND `year`='$mycYear' AND `ratings`='BELOW SATISFACTORY'"),0); $dpo = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `sent_to_dept`='$deptCode' AND `year`='$mycYear' AND `ratings`='POOR'"),0); $dna = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `sent_to_dept`='$deptCode' AND `year`='$mycYear' AND `ratings`=''"),0); ?> <html> <head> <script type="text/javascript" src="ajs/vendor/jQueryUI/loader.js"></script> <script type="text/javascript"> google.charts.load("current", {packages:["corechart"]}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['RATE', 'RATING'], ['EXCELLENT', <?php echo $dex;?>], ['VERY SAT', <?php echo $dvs;?>], ['SAT', <?php echo $dsa;?>], ['BELOW SAT', <?php echo $dbs;?>], ['POOR', <?php echo $dpo;?>] ]); var options = { title: 'DEPT. OVERALL RATINGS', pieHole: 0.2, }; var chart = new google.visualization.PieChart(document.getElementById('donutchart')); chart.draw(data, options); } </script> </head> <body> <div id="donutchart" style="width: 450px; height: 300px;"></div> </body> </html>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings