OPEN TICKET

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $qq = mysql_query("SELECT * FROM `pms_tickets` WHERE `current_status`!='CLOSED' AND `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 ""; if($progress >100){ echo ""; $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 ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

STAT	TICKET NO.	DATE.	DESCRIPTION	DEPT.	SENDER	PROMISE TIME	STATUS
"; echo "OVERDUE"; }else{ echo "	"; echo $value." %"; } $progress = number_format(($timeConsumed / $maxSLA * 100),2,'.',','); echo "	".$row['ticket_id']."	".$row['date_sent']."	".substr($row['concerns'],0,100)." Read More...	".$row['sent_to_dept']."	"; $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"	".$row['promise_date']." ".$row['promise_time']."	".$row['current_status']."

		"; //$endDateTime = strtotime("+".$addTime." Minutes", $currentDate_timestamp); echo " ".$value." "; echo "

"; echo "

"; ?>