File manager

File manager - Edit - /home/autoph/public_html/portal/includes/body/pms_ticket_body_all.php

Back
<div style='padding:1px;width:99.5%;height:95%;min-height:900px;border:1px solid red;background:#D8D8D8'> <?php echo "<h3 style='margin:0px;font-family:Calibri Light;font-size:18px;padding:2px' class='lightGray'>OPEN TICKET</h3> <div style='width:99.9%;padding:1px;border:0px solid lightgray;height:97%;overflow:auto;background:white'>"; echo "<center><table style='width:100%;border-collapse:collapse'>"; echo "<tr style=''>"; echo "<th class='titleBlue' style='width:5%;border:1px solid lightgray;padding:3px;'>STAT</th>"; echo "<th class='titleBlue' style='width:7%;border:1px solid lightgray;padding:3px;'>TICKET NO.</th>"; echo "<th class='titleBlue' style='width:6%;border:1px solid lightgray;padding:3px;'>DATE.</th>"; echo "<th class='titleBlue' style='width:55%;border:1px solid lightgray;padding:3px;'>DESCRIPTION</th>"; echo "<th class='titleBlue' style='width:5%;border:1px solid lightgray;padding:3px;'>DEPT.</th>"; echo "<th class='titleBlue' style='width:10%;border:1px solid lightgray;padding:3px;'>SENDER</th>"; echo "<th class='titleBlue' style='width:20%;border:1px solid lightgray;padding:3px;'>PROMISE TIME</th>"; echo "<th class='titleBlue' style='width:12%;border:1px solid lightgray;padding:3px;'>STATUS</th>"; echo "</tr>"; $qq = mysql_query("SELECT * FROM `pms_tickets` WHERE `current_status`='NEW' ORDER BY `id` DESC"); while ($row=mysql_fetch_array($qq)){ $count ++; //=========== date_default_timezone_set('Asia/Singapore'); //GET CURRENT DATE TIME $currentDate = date("m/d/Y H:i:s"); $currentDate_timestamp = strtotime($currentDate); //DATE TIME TICKET WAS STARTED $startDateTime = $row['date_routed']. " " .$row['time_routed']; $startDateTimeStamp = strtotime($startDateTime); //GET PROMISE DATA TIME $SLA = $row['promise_date'] . " " . $row['promise_time']; $promise_timestamp = strtotime($SLA); //MAX SLA $maxSLA = ($promise_timestamp - $startDateTimeStamp) / 60; $slaRemaining = $promise_timestamp - $currentDate_timestamp; // IN SECOND $slaInMinutes = $slaRemaining / 60; $timeConsumed = $maxSLA - $slaInMinutes; //SET BAR VALUE $maxW = (($promise_timestamp - $startDateTimeStamp) / 60 ) / $maxSLA * 100; // MAX WIDTH $progress = ($timeConsumed / $maxSLA) * 100 ; //echo $progress; if($progress > 100 AND $row['current_status']!='CLOSED'){ $currentGradient='redGradient'; $value='100'; }else { $currentGradient='orangeGradient'; $value=$progress; } $value = number_format($value,2,'.',','); //=========== echo "<tr style=''>"; if($progress >100){ echo "<td rowspan='3' align='center' style='background:#f00;border:1px solid lightgray;padding:2px;font-family:Calibri;color:white;font-weight:bold'>"; echo "OVERDUE"; }else{ echo "<td rowspan='3' align='center' style='background:#F7FE2E;border:1px solid lightgray;padding:2px;'>"; echo $value." %"; } $progress = number_format(($timeConsumed / $maxSLA * 100),2,'.',','); echo "</td>"; $routedTo = $row['routed_to']; $handlerF = mysql_result(mysql_query("SELECT `u_fname` FROM `c_users` WHERE `emp_id`='$routedTo'"),0); $handlerL = mysql_result(mysql_query("SELECT `u_lname` FROM `c_users` WHERE `emp_id`='$routedTo'"),0); echo "<td align='center' style='border:1px solid lightgray;padding:2px;'><abbr title='Being handled by ".$handlerF." ".$handlerL." : Date Assigned: ".$row['date_routed']." : Time: ".$row['time_routed']."' style='border:0px solid white;border-bottom:none !important;cursor: default !important;text-decoration:none;'>".$row['ticket_id']."</abbr></td>"; echo "<td style='border:1px solid lightgray;padding:2px;'>".$row['date_sent']."</td>"; echo "<td style='border:1px solid lightgray;padding:2px;'><ABBR title='". $row['concerns']."' style='border:0px solid white;border-bottom:none !important;cursor: default !important;text-decoration:none;'>".substr($row['concerns'],0,100)."    <a href=''> Read More...</a></ABBR></td>"; echo "<td style='border:1px solid lightgray;padding:2px;'>".$row['sent_to_dept']."</td>"; echo "<td style='border:1px solid lightgray;padding:2px;'>"; $fromID = $row['emp_id']; $getFname = mysql_result(mysql_query("SELECT `u_fname` FROM `c_users` WHERE `u_id`='$fromID'"),0); $getLname = mysql_result(mysql_query("SELECT `u_lname` FROM `c_users` WHERE `u_id`='$fromID'"),0); echo $getFname ." " .$getLname; echo"</td>"; echo "<td style='border:1px solid lightgray;padding:2px;'>".$row['promise_date']." ".$row['promise_time']."</td>"; echo "<td style='border:1px solid lightgray;padding:2px;'>".$row['current_status']."</td>"; echo "<tr>"; echo "<tr style=''>"; echo "<td colspan='7' style='padding:0px;height:17px;background:lightgray;border:0px solid white;border-bottom:1px solid gray;'>"; //$endDateTime = strtotime("+".$addTime." Minutes", $currentDate_timestamp); echo "<div style='background:#FFBF00;width:".$value."%;font-size:10px;height:100%;font-weight:normal;color:black' align='center' >".$value."</div>"; echo "</td>"; echo "</tr>"; } echo "</table></center>"; echo "</div>"; ?> </div>

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