File manager

File manager - Edit - /home/autoph/public_html/portal/portal/ticket_personal_cust_sat.php

Back
<?php $janDateS= '01/01/'.$mycYear; $janDateE= '01/31/'.$mycYear; $febDateS= '02/01/'.$mycYear; $febDateE= '02/29/'.$mycYear; $marDateS= '03/01/'.$mycYear; $marDateE= '03/31/'.$mycYear; $aprDateS= '04/01/'.$mycYear; $aprDateE= '04/30/'.$mycYear; $mayDateS= '05/01/'.$mycYear; $mayDateE= '05/31/'.$mycYear; $junDateS= '06/01/'.$mycYear; $junDateE= '06/30/'.$mycYear; $julDateS= '07/01/'.$mycYear; $julDateE= '07/31/'.$mycYear; $augDateS= '08/01/'.$mycYear; $augDateE= '08/31/'.$mycYear; $sepDateS= '09/01/'.$mycYear; $sepDateE= '09/31/'.$mycYear; $octDateS= '10/01/'.$mycYear; $octDateE= '10/31/'.$mycYear; $novDateS= '11/01/'.$mycYear; $novDateE= '11/31/'.$mycYear; $decDateS= '12/01/'.$mycYear; $decDateE= '12/31/'.$mycYear; $janPre = round(((mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `ratings`!='POOR' AND `ratings`!='BELOW SATISFACTORY' AND `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$janDateS' AND '$janDateE'"),0)) / (mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$janDateS' AND '$janDateE'"),0)) 100),2); $febPre = round(((mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `ratings`!='POOR' AND `ratings`!='BELOW SATISFACTORY' AND `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$febDateS' AND '$febDateE'"),0)) / (mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$febDateS' AND '$febDateE'"),0)) 100),2); $marPre = round(((mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `ratings`!='POOR' AND `ratings`!='BELOW SATISFACTORY' AND `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$marDateS' AND '$marDateE'"),0)) / (mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$marDateS' AND '$marDateE'"),0)) 100),2); $aprPre = round(((mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `ratings`!='POOR' AND `ratings`!='BELOW SATISFACTORY' AND `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$aprDateS' AND '$aprDateE'"),0)) / (mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$aprDateS' AND '$aprDateE'"),0)) 100),2); $mayPre =round(((mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `ratings`!='POOR' AND `ratings`!='BELOW SATISFACTORY' AND `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$mayDateS' AND '$mayDateE'"),0)) / (mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$mayDateS' AND '$mayDateE'"),0)) 100),2); $junPre = round(((mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `ratings`!='POOR' AND `ratings`!='BELOW SATISFACTORY' AND `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$junDateS' AND '$junDateE'"),0)) / (mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$junDateS' AND '$junDateE'"),0)) 100),2); $julPre = round(((mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `ratings`!='POOR' AND `ratings`!='BELOW SATISFACTORY' AND `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$julDateS' AND '$julDateE'"),0)) / (mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$julDateS' AND '$julDateE'"),0)) 100),2); $augPre = round(((mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `ratings`!='POOR' AND `ratings`!='BELOW SATISFACTORY' AND `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$augDateS' AND '$augDateE'"),0)) / (mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$augDateS' AND '$augDateE'"),0)) 100),2); $sepPre = round(((mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `ratings`!='POOR' AND `ratings`!='BELOW SATISFACTORY' AND `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$sepDateS' AND '$sepDateE'"),0)) / (mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$sepDateS' AND '$sepDateE'"),0)) 100),2); $octPre = round(((mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `ratings`!='POOR' AND `ratings`!='BELOW SATISFACTORY' AND `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$octDateS' AND '$octDateE'"),0)) / (mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$octDateS' AND '$octDateE'"),0)) 100),2); $novPre = round(((mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `ratings`!='POOR' AND `ratings`!='BELOW SATISFACTORY' AND `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$novDateS' AND '$novDateE'"),0)) / (mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$novDateS' AND '$novDateE'"),0)) 100),2); $decPre = round(((mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `ratings`!='POOR' AND `ratings`!='BELOW SATISFACTORY' AND `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$decDateS' AND '$decDateE'"),0)) / (mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pms_tickets` WHERE `routed_to`='$myEMPID' AND `date_sent` BETWEEN '$decDateS' AND '$decDateE'"),0)) 100),2); ?> <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(drawChartA); function drawChartA() { var data = google.visualization.arrayToDataTable([ ['Year', 'AVE. RATING'], ['Jan', <?php echo $janPre;?>], ['Feb', <?php echo $febPre;?>], ['Mar', <?php echo $marPre;?>], ['Apr', <?php echo $aprPre;?>], ['May', <?php echo $mayPre;?>], ['Jun', <?php echo $junPre;?>], ['Jul', <?php echo $julPre;?>], ['Aug', <?php echo $augPre;?>], ['Sep', <?php echo $sepPre;?>], ['Oct', <?php echo $octPre;?>], ['Nov', <?php echo $novPre;?>], ['Dec', <?php echo $decPre;?>] ]); var options = { title: 'My YTD Customer Satisfaction Rate', curveType: 'function', legend: { position: 'bottom' } }; var chart = new google.visualization.LineChart(document.getElementById('curve_chartA')); chart.draw(data, options); } </script> </head> <body> <div id="curve_chartA" style="width: 620px; height: 300px"></div> </body> </html>

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