/** * method to close a ticket * */ public function closeTicket() { if (isset($_REQUEST['id']) && !empty($_REQUEST["id"])) { $partTicket = Ticket::find_by_id($_REQUEST["id"]); $partTicket->status = "Closed"; $theUser = Employee::find_by_id($_SESSION['emp_ident']); $cemail = !empty($_REQUEST['cemail']) ? explode(",", $_REQUEST['cemail']) : ""; // print_r($partTicket); array_push($cemail, $partTicket->contact_email, $theUser->emp_email); $client = Client::find_by_id($partTicket->client_id); array_push($cemail, $client->email); $partTicket->datemodified = date("Y-m-d H:i:s"); $msg = "Your Complaint ticket status has been closed<br />"; $subject = "Robert Johnson Holdings(Technical Support) Ticket #'" . $partTicket->id . "' Close"; //print_r($cemail); //mail("*****@*****.**","Robert Johnson Holdings, Technical Support" , "all good"); if ($partTicket->update()) { $schedule = Schedule::find_by_ticket_id($_REQUEST["id"]); if ($schedule) { $schedule->status = "Closed"; $schedule->update(); } $this->sendMail("Customer", $subject, $msg, $cemail); return true; } else { return false; } } }
/** * this the detail listing * for support session between * customer and administrator */ public function detail($id = "") { @$this->loadModel("Support"); $datum = $this->model->getData(); $replyData = $this->model->getTicketData($id); //$this->view->state = $datum['state']; $uri = new Url(""); $ticket = $replyData['ticket']; $replies = $replyData["replies"]; //$this->view->employee = Employee::find_by_sql("SELECT * FROM employee WHERE emp_dept='5'"); $this->view->country = $datum['country']; $this->view->ticket = $replyData['ticket']; //$this->view->mymenu = $this->model->getById($id); $pgdetail = ""; /** * hhhhhh */ if ($ticket) { /** * Load ticket buttons */ $pgdetail .= "<div class='row'><input type='hidden' name='cid' id='cid' value='{$ticket->prod_id}' />\n \t<div class='large-12 columns'><div class='btn-group'><a href='" . $uri->link("support/ticketlist") . "'class='btn btn-info button' >« Back</a>"; if ($ticket->status != "Closed") { //if status is not closed /*Check if a technician has been assigned*/ if (Schedule::find_by_ticket_id($ticket->id)) { /*If exist do not display assign task button*/ $pgdetail .= "<a href='#' id='dh' class='btn btn-primary button'> Reply </a><a href='#' id='close' class='btn btn-danger button' >Close Ticket </a>"; } else { $pgdetail .= "<a href='#' id='dh' class='btn btn-primary button'> Reply </a><a href='#' id='close' class='btn btn-danger button' >Close Ticket </a><a href='#' data-reveal-id='myModal5' class='btn btn-info button'>Assign Task to Employee</a>"; } } $pgdetail .= "</div>\n </div></div>\n </div> <!--closing to reload close -->\n <div id='hideme'><form action='" . $uri->link("support/doCreateAdminReply/" . $ticket->id . "") . "' method='post' enctype='multipart/form-data' name='frmEmp5' id='frmEmp5'>\n\t <fieldset><div id='transalert'></div>\n \t \n\t <div class='row'>\n <div class='large-12 columns'>\n <input type='hidden' name='cname' id='cname' value='Customer Support Robert Johnson Holdings' />\n <input type='hidden' id='disid' name='disid' value='" . $ticket->id . "' />\n \n \n <div>Enter emails to copy here separate with commas</div>\n\t <input type='text' id='cemail' name='cemail' />\n\t\t <input type='hidden' name='email' id='email' />\n\t\t <div id='tm2'></div>\n <div>Response</div>\n\t <textarea name='issue' id='issue' ></textarea></td>\n \n\t\t <a class='btn btn-info' id='replysave' >Send Reply </a>\n </div>\n\t\t \n\t\t \n\t\t \n </fieldset>\n </form></div>"; /** * form close */ $pgdetail .= "<div id='granddiv'><div id='divclose'><div class='row'>\n \t<div class='ticketdetailscontainer'>\n <div class='large-3 columns'>\n <div class='internalpadding'>\n Submitted\n <div class='detail'>" . $ticket->datecreated . "</div>\n </div>\n </div>\n <div class='large-3 columns'>\n <div class='internalpadding'>\n Department\n <div class='detail'>{$ticket->department}</div>\n </div>\n </div>\n <div class='large-3 columns'>\n <div class='internalpadding'>\n Priority\n <div class='detail'>{$ticket->priority}</div>\n </div>\n </div>\n <div class='large-3 columns'>\n <div class='internalpadding'>\n Status\n <div class='detail'>"; $pgdetail .= $ticket->status == "Open" ? "<span style='color:#779500'>Open</span>" : "<span style='color:#f00'>{$ticket->status}</span>"; $pgdetail .= "</div>\n </div>\n </div>\n \n <div class='clear'></div>\n <br clear='all' />\n </div>\n \t </div><!-- Erred Close of grand div -->"; } $pgdetail .= "\n <div class='ticketmsgs'>\n "; if ($replies) { foreach ($replies as $reply) { if ($reply->sender_type == "Client") { $pgdetail .= "<div class='clientheader'>\n <div style='float:right;'>{$reply->datecreated}</div>\n {$reply->sender_name} || Client\n </div>\n <div class='clientmsg'>\n {$reply->message}\n </div>"; } else { $pgdetail .= "<div class='adminheader'>\n <div style='float:right;'>{$reply->datecreated}</div>\n {$reply->sender_name} || Staff\n </div>\n \n <div class='adminmsg'>\n\n {$reply->message}\n \n <div class='clear'></div>\n </div>"; } } } $pgdetail .= "</div></div>"; $this->view->myReplyData = $pgdetail; $this->view->render("support/detail"); }
$prod = Cproduct::find_by_terminal_id($pending->terminal_id); echo "<td>"; if (empty($pending->location)) { echo $prod->install_address . ", " . $prod->install_city; } else { echo $pending->location; } echo " </td>"; echo "<td>"; //$pending->client_name $myclient = Client::find_by_id($pending->client_id); if ($myclient) { echo $myclient->name; } echo "</td><td>"; $schedule = Schedule::find_by_ticket_id($pending->id); //print_r($schedule); if ($schedule) { $myengineer = Employee::find_by_id($schedule->emp_id); echo $myengineer ? $myengineer->emp_lname . " " . $myengineer->emp_fname : ""; } echo " </td><td>{$pending->issue}</td><td>"; if ($pending->status == 'Open') { echo "<span class='label bg-red' style='padding:5px'>{$pending->status}"; } else { echo "<span class='label bg-blue' style='padding:5px'>Pending"; } echo "</td><td>{$pending->datemodified} </td><td><a href='" . $uri->link("support/detail/" . $pending->id . "") . "'>View</a></td><td>\n <select sid='{$pending->id}' class='cschedule2'><option values=''>--Select--</option><option values='0'>Open</option><option values='1'>Closed</option><option values='2'>In Progress</option></select></td></tr>"; } } ?>