Update has been saved. The assigned support personnel will be notified via e-mail together with your follow up request. Thank you!

"; $message = "Hi ".$uFname."! Customer ".$sendersFname." is asking for updates regarding ticket#: ".$fulTiket.". Please attend to this concern on or before the committed timeline. Message from customer: ".$notes." Thank you Autohub Support Group"; mail($uMail, 'SUPPORT REQUEST UPDATE', $message, 'From: support@autohubgroup.com'); } }if(isset($_POST['submitRate'])){ $ticketIDA=$_GET['id']; $feedback=$_POST['feedback']; $rate=$_POST['rate']; $feedback=mysql_real_escape_string($feedback); $supportPerson = mysql_result(mysql_query("SELECT `routed_to` FROM `pms_tickets` WHERE `id`='$ticketIDA'"),0); $supTicket = mysql_result(mysql_query("SELECT `ticket_id` FROM `pms_tickets` WHERE `id`='$ticketIDA'"),0); $handlersEmail = mysql_result(mysql_query("SELECT `email` FROM `c_users` WHERE `emp_id`='$supportPerson'"),0); $handlersFname = mysql_result(mysql_query("SELECT `u_fname` FROM `c_users` WHERE `emp_id`='$supportPerson'"),0); mysql_query("UPDATE `pms_tickets` SET `user_feedback`='$feedback',`ratings`='$rate',`date_rated`='$toDate', `time_rated`='$currentTime' WHERE `id`='$ticketIDA'"); $sql="INSERT INTO `pms_ticket_updates` (`id`,`ticket_id`,`update_by`,`updates`,`date`,`time`) VALUES('','$ticketIDA','$myEMPID','$notes','$toDate','$currentTime')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "

Your evaluation has been sent. The person who assisted you will be notified via e-mail. Thank you!

"; $message = "Hi ".$handlersFname."! You have been rated as ".$rate." for the support ticket#: ".$supTicket." you have been assigned to do. Thank you and have a good day! Support Group"; mail($handlersEmail, 'SUPPORT REQUEST UPDATE', $message, 'From: support@autohubgroup.com'); } } //RATINGS if(isset($_GET['rate'])){ $ticketID = $_GET['id']; echo "
"; echo "

RATE THIS TICKET

"; echo "
"; echo "

TYPE YOUR COMMENT HERE...

"; echo "

"; echo "
"; } //FOLLOW UP ALERT if(isset($_GET['ff'])){ $ticketID = $_GET['id']; echo "
"; echo "

UPDATE HISTORY

"; echo "
"; echo ""; echo "
"; echo "
"; echo "
"; $qq = mysql_query("SELECT * FROM `pms_ticket_updates` WHERE `ticket_id`='$ticketID'"); while($row = mysql_fetch_array($qq)){ echo "

Last Update: "; echo $row['updates'] ."
Date: ".$row['date']." / ".$row['time']; echo "

"; } echo "
"; echo "
"; echo "
"; } echo "

OPEN TICKET - OWNED

"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $qq = mysql_query("SELECT * FROM `pms_tickets` WHERE `emp_id`='$uID' AND `ratings`='' 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; if($progress > 100 AND $row['current_status']!='CLOSED'){ $currentGradient='orangeGradient'; $value='100'; }else { $currentGradient='titleBlue'; $value=$progress; } if($value < 1 ){ $value = '0%'; } else{ $value = number_format($value,2,'.',',') ." %"; } //==== echo ""; if($progress > 100){ if($row['current_status']!='CLOSED'){ echo ""; $progress = number_format(($timeConsumed / $maxSLA * 100),2,'.',','); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $ckhSLA = $row['promise_date']." ".$row['promise_time']; $slacurrentDate = date("m/d/Y H:i:s"); $sla_currentDate_timestamp = strtotime($slacurrentDate); $sla_promise_timestamp = strtotime($ckhSLA); if($row['current_status']==='CLOSED'){ echo ""; }else { echo ""; } echo ""; echo ""; echo ""; echo ""; } echo "
NO.TICKET NO.DATE SENT.REQUEST DESCRIPTION / TYPESUPPORTSTATUSPROMISE TIME
"; echo "OVERDUE"; }else { $promisedate = strtotime($row['promise_date']." ".$row['promise_time']); $closingTime = strtotime($row['date_closed']." ".$row['time_closed']); $sla = $promisedate - $closingTime; $totalSLA = $sla / 60; if ($totalSLA > 0){ echo ""; echo "CLOSED"; }else{ echo ""; echo "CLOSED"; } } }else{ if($row['current_status']==='CLOSED'){ echo ""; echo "CLOSED"; }else{ echo ""; echo $value; } } echo ""; if($row['created_by']===$myEMPID){ echo "".$row['ticket_id'].""; }else{ echo "".$row['ticket_id'].""; } echo "".$row['date_sent']."".substr($row['concerns'],0,90)."    Read More..."; $fromID = $row['routed_to']; $getFname = mysql_result(mysql_query("SELECT `u_fname` FROM `c_users` WHERE `emp_id`='$fromID'"),0); $getLname = mysql_result(mysql_query("SELECT `u_lname` FROM `c_users` WHERE `emp_id`='$fromID'"),0); if($fromID==='0'){ echo "UnAssigned"; } else { echo $getFname; } echo"".$row['current_status']."".$row['promise_date']." ".$row['promise_time']."RATEN/A
"; //$endDateTime = strtotime("+".$addTime." Minutes", $currentDate_timestamp); if($row['current_status']==='CLOSED'){ echo "
"; }else{ echo "
"; } echo "
"; echo "
"; ?>