File manager - Edit - /home/autoph/public_html/portal/portal/admin_ticket_dashboard.php
Back
<div style='padding:1px;width:99.888%;height:95%;min-height:1000px;border:0px solid lightgray;background:#fff;overflow:auto'> <?php //;border-bottom:1px dashed gray echo "<h3 style='margin:0px;font-family:Calibri Light;font-size:18px;padding:2px' class='lightGray'>ADMIN DASHBOARD</h3>"; //===========================================================================================================================' echo "<div align='left' valign='top' style='position:relative;padding:2px;float:left;width:99.5%;height:450px;border:0px solid red;border-top:1px solid lightgray;top:10px;margin-bottom:10px;background:white'>"; echo "<p style='font-family:Calibri Light;font-size:24px;font-weight:normal;color:#DF3A01'>CUSTOMER FEEDBACK RATING</p>"; //============= echo "<div align='center' valign='top' style='position:relative;padding:2px;float:left;width:49%;height:350px;border:0px solid red;border-right:1px dashed lightgray;top:10px;margin-bottom:10px;background:white'>"; include 'ticket_dept_response_rate_ahg_wide.php'; echo "</div>"; //============= echo "<div align='left' valign='bottom' style='margin-left:5px;position:relative;padding:2px;float:left;width:49%;height:350px;border:0px solid red; top:10px;margin-bottom:10px;background:white'>"; include 'ticket_department_donut_cust_ahg_wide.php'; echo "</div>"; //============= echo "</div> "; //===========================================================================================================================' echo "<div style='position:relative;width:98.9%;padding:5px;border:0px solid RED;height:96%;overflow:auto;background:white'>"; echo "<br><div style='padding:2px;float:left;width:100%;height:250px;border:0px solid lightgray;border-top:1px solid lightgray'> <p style='font-family:Calibri Light;font-size:24px;font-weight:normal;color:#DF3A01'>TICKETS RECEIVED BY COMPANY</p>"; $getCom = mysql_query("SELECT * FROM `company` WHERE `status`=1 ORDER BY `code` ASC"); echo "<table style='height:100%;border-collapse:collapse'>"; echo "<tr style='border:0px dashed lightgray;background:white;'>"; while($row=mysql_fetch_array($getCom)){ $cCode =$row['code']; $getTotalTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `comp_id`!=''"),0); $getCompTotalTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `comp_id`='$cCode'"),0); $distributionCount = $getCompTotalTicket / $getTotalTicket * 100; $divHeight = number_format($distributionCount,1) . "%"; echo "<td align='center' class='mydiv' style='padding:0px;height:100%;width:40px;font-family:Calibri Light;font-size:10px;color:blue;border:0px solid red' valign='bottom'> <div style='box-shadow:2px 1px 3px black;height:$divHeight;width:30px;border:0px solid orange;background:#FACC2E;font-size:11px'>".$divHeight."</div> <hr><br><b style='font-size:11px;color:#08298A;font-weight:normal'>".$row['code']."</b></td>"; } echo "</tr>"; echo "</table>"; echo "</div>"; echo "<div align='left' style='margin-top:70px;position:relative;padding:2px;float:left;width:99%;height:250px;border:0px solid lightgray;border-top:1px solid lightgray'>"; echo "<p style='font-family:Calibri Light;font-size:24px;font-weight:normal;color:#DF3A01'>TICKETS CREATED BY COMPANY</p>"; $getCom = mysql_query("SELECT * FROM `company` WHERE `status`=1 ORDER BY `code` ASC"); echo "<table style='height:100%;border-collapse:collapse'>"; echo "<tr style='border:0px dashed lightgray;background:white;'>"; while($row=mysql_fetch_array($getCom)){ $cCode =$row['code']; $getTotalTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `comp_id`!=''"),0); $getCompTotalTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `sent_to_comp`='$cCode'"),0); $distributionCount = $getCompTotalTicket / $getTotalTicket * 100; $divHeight = number_format($distributionCount,1) . "%"; echo "<td align='center' class='mydiv' style='padding:0px;height:100%;width:40px;font-family:Calibri Light;font-size:10px;color:blue;border:0px solid red' valign='bottom'> <div style='box-shadow:2px 1px 3px black;height:$divHeight;width:30px;border:0px solid orange;background:#58FA82;font-size:11px'>".$divHeight."</div> <hr><br><b style='font-size:11px;color:#DF3A01;font-weight:normal'>".$row['code']."</b></td>"; } echo "</tr>"; echo "</table>"; echo "</div>"; echo "<div align='left' valign='bottom' style='position:relative;padding:2px;float:left;width:99.8%;height:250px;border:0px solid red;border-top:1px solid lightgray;top:80px;margin-bottom:100px;'>"; echo "<br><p style='font-family:Calibri Light;font-size:24px;font-weight:normal;color:#DF3A01'>TICKETS RECEIVED BY DEPARTMENT</p>"; $getdep = mysql_query("SELECT * FROM `departments` WHERE `status`=1 ORDER BY `code` ASC"); echo "<table style='height:100%;border-collapse:collapse'>"; echo "<tr style='border:0px dashed lightgray;background:white;'>"; while($row=mysql_fetch_array($getdep)){ $cCode =$row['code']; $getTotalTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `sent_to_dept`!=''"),0); $getCompTotalTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `sent_to_dept`='$cCode'"),0); $distributionCount = $getCompTotalTicket / $getTotalTicket * 100; $divHeight = number_format($distributionCount,1) . "%"; echo "<td align='center' valign='bottom' class='mydiv' style='padding:0px;height:90%;width:40px;font-family:Calibri Light;font-size:10px;color:blue;border:0px solid red' valign='bottom'> <div style='box-shadow:2px 1px 3px black;height:$divHeight;width:30px;border:0px solid orange;background:#2ECCFA;font-size:11px'>".$divHeight."</div> <hr style='margin-bottom:10px;'><b style='font-size:11px;color:#8A0829;font-weight:normal'>".$row['code']."</b></td>"; } echo "</tr>"; echo "</table>"; echo "</div> "; echo "</div>"; ?> </div>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings