"; echo "

REQUEST INFO

"; echo "
X
"; echo "

".$desc."

"; echo ""; } if(isset($_POST['PulloutTicket'])){ $ticketID = $_POST['ticketID']; $setPromiseTime = mysql_result(mysql_query("SELECT `promise_time` FROM `pms_tickets` WHERE `id`='$ticketID'"),0); $setPromiseDate = mysql_result(mysql_query("SELECT `promise_date` FROM `pms_tickets` WHERE `id`='$ticketID'"),0); echo "
"; echo ""; echo "
"; echo "

TRANSFER TICKET

"; $ticketDesc = mysql_result(mysql_query("SELECT `concerns` FROM `pms_tickets` WHERE `id`='$ticketID'"),0); echo "

SUPPORT REQUEST DESCRIPTION

"; echo "
".$ticketDesc. "
"; echo "
"; echo "Type:
"; echo "
"; echo "
"; echo "Category:
"; echo "
"; echo "
"; echo "Promise Date: "; echo "
"; echo "
"; echo "Promise Time: "; echo "
"; echo "
"; $getdeptEmp = mysql_query("SELECT * FROM `employee_list` WHERE `dept_code`='$deptCode' ORDER BY `last_name` ASC"); echo ""; echo ""; echo " "; echo "
"; echo"
"; echo "
"; } if(isset($_POST['GrabTicket'])){ $ticketID = $_POST['ticketID']; echo "
"; echo ""; echo "
"; echo "

SET PROMISE TIME

"; $ticketDesc = mysql_result(mysql_query("SELECT `concerns` FROM `pms_tickets` WHERE `id`='$ticketID'"),0); echo "

SUPPORT REQUEST DESCRIPTION

"; echo "
".$ticketDesc. "
"; echo "
"; echo "Type:
"; echo "
"; echo "
"; echo "Category:
"; echo "
"; echo "
"; echo "Promise Date: "; echo "
"; echo "
"; echo "Promise Time: "; echo "
"; echo "
"; $getdeptEmp = mysql_query("SELECT * FROM `employee_list` WHERE `dept_code`='$deptCode' ORDER BY `last_name` ASC"); echo ""; echo ""; echo " "; echo "
"; echo"
"; echo "
"; } if(isset($_POST['SavePulloutTicket'])){ $ticketIDA = $_POST['ticketIDA']; $sendersID = mysql_result(mysql_query("SELECT `emp_id` FROM `pms_tickets` WHERE `ticket_id`='$ticketIDA'"),0); $sendersFname = mysql_result(mysql_query("SELECT `u_fname` FROM `c_users` WHERE `u_id`='$sendersID'"),0); $sendersEmail = mysql_result(mysql_query("SELECT `email` FROM `c_users` WHERE `emp_id`='$sendersID'"),0); $requestTYpe = $_POST['requestTYpe']; $requestCategory = $_POST['requestCategory']; $requestTYpeID = mysql_result(mysql_query("SELECT `id` FROM `pms_support_type` WHERE `name`='$requestTYpe'"),0); $requestCategoryID = mysql_result(mysql_query("SELECT `id` FROM `pms_ticket_category` WHERE `name`='$requestCategory'"),0); $promiseTime = $_POST['promiseTime']; $promiseDate = $_POST['promiseDate']; $assignTo= $_POST['assignTo']; $exAssign = explode('---',$assignTo); $assignToID = $exAssign[1]; $curDateAndtIme =$toDate ." ". $currentTime; $promiseDateTime = $promiseDate ." ".$promiseTime; //if($curDateAndtIme >= $promiseDateTime){ // echo "
//

Your promised data/time should be higher than the time ticket was created.

//
//
";break; //} mysql_query("UPDATE `pms_tickets` SET `routed_by`='$myEMPID',`routed_to`='$assignToID', `current_status`='Assigned',`date_routed`='$toDate', `time_routed`='$currentTime',`category_id`='$requestTYpeID',`type_id`='$requestTYpeID' WHERE `id`='$ticketIDA'"); $message = "Hi ".$sendersFname."! Your concern has been re-routed and assigned to ".$uFname ." on | ".$toDate." at exactly ".$currentTime.". We will do our best to meet the set promise time which on ".$promiseDate." at ".$promiseTime.". You will be notified on the status of this concern via e-mail. Please check your e-mail for updates or, you may login to our portal at http://www.autohub.ph/portal for real-time updates of your request. If you do not have an account yet, please visit the site and click Register. Thank you. Autohub Support Group"; mail($sendersEmail, 'NEW TICKET CREATED', $message, 'From: support@autohubgroup.com'); } if(isset($_POST['SaveGrabTicket'])){ $ticketIDA = $_POST['ticketIDA']; $sendersID = mysql_result(mysql_query("SELECT `emp_id` FROM `pms_tickets` WHERE `ticket_id`='$ticketIDA'"),0); $sendersFname = mysql_result(mysql_query("SELECT `u_fname` FROM `c_users` WHERE `u_id`='$sendersID'"),0); $sendersEmail = mysql_result(mysql_query("SELECT `email` FROM `c_users` WHERE `emp_id`='$sendersID'"),0); $requestTYpe = $_POST['requestTYpe']; $requestCategory = $_POST['requestCategory']; $requestTYpeID = mysql_result(mysql_query("SELECT `id` FROM `pms_support_type` WHERE `name`='$requestTYpe'"),0); $requestCategoryID = mysql_result(mysql_query("SELECT `id` FROM `pms_ticket_category` WHERE `name`='$requestCategory'"),0); $promiseTime = $_POST['promiseTime']; $promiseDate = $_POST['promiseDate']; $assignTo= $_POST['assignTo']; $exAssign = explode('---',$assignTo); $assignToID = $exAssign[1]; $curDateAndtIme =$toDate ." ". $currentTime; $promiseDateTime = $promiseDate ." ".$promiseTime; if($curDateAndtIme >= $promiseDateTime){ echo "

Your promised data/time should be higher than the time ticket was created.

";break; } mysql_query("UPDATE `pms_tickets` SET `routed_by`='$myEMPID',`promise_date`='$promiseDate',`promise_time`='$promiseTime',`routed_to`='$assignToID', `current_status`='Assigned',`date_routed`='$toDate', `time_routed`='$currentTime',`category_id`='$requestTYpeID',`type_id`='$requestTYpeID' WHERE `id`='$ticketIDA'"); $message = "Hi ".$sendersFname."! Your concern has been routed and being attended by ".$uFname ." on | ".$toDate." at exactly ".$currentTime.". Estimated time of completion will be on ".$promiseDate." at ".$promiseTime.". You will be notified on the status of this concern via e-mail. Please check your e-mail for updates or, you may login to our portal at http://www.autohub.ph/portal for real-time updates of your request. If you do not have an account yet, please visit the site and click Register. Thank you. Autohub Support Group"; mail($sendersEmail, 'NEW TICKET CREATED', $message, 'From: support@autohubgroup.com'); } echo "

OPEN TICKET - DEPARTMENT

"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $qq = mysql_query("SELECT * FROM `pms_tickets` WHERE `current_status`!='CLOSED' AND `sent_to_dept`='$deptCode' ORDER BY `routed_to`,`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 ""; if($row['routed_to']==='0'){ echo ""; }else { echo ""; } echo ""; echo ""; echo ""; echo ""; } echo "
STATUSTICKET NO.DATE.DESCRIPTIONREQUESTED BYPROMISE TIMESTATUS
"; 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..."; $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 "
"; ?>