File manager

File manager - Edit - /home/autoph/public_html/portal/portal/pod_progress_bar_chart.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 = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$janDateS' AND '$janDateE'"),0); $janPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$janDateS' AND '$janDateE'"),0); $febPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$febDateS' AND '$febDateE'"),0); $febPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$febDateS' AND '$febDateE'"),0); $marPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$marDateS' AND '$marDateE'"),0); $marPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$marDateS' AND '$marDateE'"),0); $aprPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$aprDateS' AND '$aprDateE'"),0); $aprPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$aprDateS' AND '$aprDateE'"),0); $mayPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$mayDateS' AND '$mayDateE'"),0); $mayPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$mayDateS' AND '$mayDateE'"),0); $junPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$junDateS' AND '$junDateE'"),0); $junPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$junDateS' AND '$junDateE'"),0); $julPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$julDateS' AND '$julDateE'"),0); $julPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$julDateS' AND '$julDateE'"),0); $augPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$augDateS' AND '$augDateE'"),0); $augPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$augDateS' AND '$augDateE'"),0); $sepPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$sepDateS' AND '$sepDateE'"),0); $sepPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$sepDateS' AND '$sepDateE'"),0); $octPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$octDateS' AND '$octDateE'"),0); $octPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$octDateS' AND '$octDateE'"),0); $novPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$novDateS' AND '$novDateE'"),0); $novPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$novDateS' AND '$novDateE'"),0); $decPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$decDateS' AND '$decDateE'"),0); $decPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$decDateS' AND '$decDateE'"),0); ?> <div id="piechart" style="width: 800px; height: 250px;border:0px solid red;padding:0px"> <table style='width:100%'> <tr> <td valign='bottom' style="width: 100%; height: 200px;border:0px solid red;background:white"> <?php $passed = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `ratings`='VERY SATISFACTORY' AND `year`='$mycYear' \|\| `routed_to`='$empID' AND `ratings`='EXCELLENT' AND `year`='$mycYear' \|\| `routed_to`='$empID' AND `ratings`='SATISFACTORY' AND `year`='$mycYear' "),0); $failed = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `ratings`='BELOW SATISFACTORY' AND `year`='$mycYear' \|\| `routed_to`='$empID' AND `ratings`='POOR' AND `year`='$mycYear' "),0); $passPercent = $passed + $failed; $passRate = ($passed / $passPercent) * 100; $failRate = ($failed / $passPercent) * 100; echo "<div style='margin:3px;float:left;text-align:center;width:60%;height:100%;position;relative;font-family:Calibri Light;font-size:30px;color:#0431B4;font-weight:normal;border:1px solid #fafafa;padding:0px;border-radius:0px;border:1px solid #F2F2F2'>"; echo "<div align='center' class='lightGradient' style='padding:3px;width:100%;top:0px;left:0px;position:relative;z-index:2;margin-bottom:5px'>AVERAGE RATING</div>"; echo "<b style='font-family:Calibri;font-size:50px;color:#088A08;margin-right:10px;text-shadow:1px 1px 2px black'>".$passRate . " %</b><img src='images/icon/tup_big.png' style='margin-right:40px'></img>"; echo "<b style='font-family:Calibri;font-size:50px;color:#f00;margin-right:10px;text-shadow:1px 1px 2px black'>".$failRate . " %</b><img src='images/icon/tud_big.png' ></img>"; echo "</div>"; echo "<div style='margin:3px;float:left;text-align:left;width:38%;height:100%;position;relative;font-family:Calibri Light;font-size:40px;color:#0431B4;font-weight:normal;border:1px solid #fafafa;padding:0px;border-radius:0px;border:1px solid #F2F2F2'>"; echo "<div class='lightGradient' style='padding:3px;width:100%;top:0px;left:0px;position:relative;z-index:2;margin-bottom:5px'>YOUR TICKET SUMMARY</div>"; $assignedTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `year`='$mycYear' "),0); $closedTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `year`='$mycYear' AND `current_status`='CLOSED'"),0); $pendingTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `year`='$mycYear' AND `current_status`!='CLOSED'"),0); $slaCompliance = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `year`='$mycYear' AND `ticket_sla` >= '0' AND `ticket_sla` != ''"),0); $slaNonCompliance = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `year`='$mycYear' AND `ticket_sla` < '0' AND `ticket_sla` != ''"),0); echo "<p style='padding-left:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'> <b style='margin-right:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>".$assignedTicket."</b> Total Assigned Tickets</p>"; echo "<p style='padding-left:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'> <b style='margin-right:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>".$closedTicket."</b> Total Closed Tickets</p>"; echo "<p style='padding-left:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'> <b style='margin-right:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>".$pendingTicket."</b> Total Pending Tickets</p>"; echo "<p style='padding-left:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'> <b style='margin-right:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>".$slaCompliance."</b> SLA Compliant</p>"; echo "<p style='padding-left:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'> <b style='margin-right:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>".$slaNonCompliance."</b> SLA NON-Compliant</p>"; echo "</div>"; ?> </td> </tr> </table> </div>

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