Example #1
0
 function User_Reply($ticket, $params)
 {
     if ($params['user_message']) {
         FSS_EMail::User_Reply($ticket, $params['subject'], $params['user_message'], $params['files']);
     }
 }
 function DoTicketReply($ticketid, $userid, $isadmin, &$messageid)
 {
     $db = JFactory::getDBO();
     $subject = $this->subject;
     $body = $this->plainmsg;
     $now = FSS_Helper::CurDate();
     if ($body) {
         $qry = "INSERT INTO #__fss_ticket_messages (ticket_ticket_id, subject, body, user_id, admin, posted) VALUES ('";
         $qry .= FSSJ3Helper::getEscaped($db, $ticketid) . "','" . FSSJ3Helper::getEscaped($db, $subject) . "','" . FSSJ3Helper::getEscaped($db, $body) . "','" . FSSJ3Helper::getEscaped($db, $userid) . "', '" . FSSJ3Helper::getEscaped($db, $isadmin) . "', '{$now}')";
         $db->setQuery($qry);
         $db->Query();
         $messageid = $db->insertid();
         $qry = "SELECT ticket_status_id FROM #__fss_ticket_ticket WHERE id = '" . FSSJ3Helper::getEscaped($db, $ticketid) . "'";
         $db->setQuery($qry);
         $status = $db->loadAssoc();
         if ($isadmin) {
             $newstatus = FSS_Ticket_Helper::GetStatusID('def_admin');
         } else {
             $newstatus = FSS_Ticket_Helper::GetStatusID('def_user');
         }
         if ($newstatus > 0) {
             $qry = "UPDATE #__fss_ticket_ticket SET ticket_status_id = '" . FSSJ3Helper::getEscaped($db, $newstatus) . "', closed = NULL WHERE id = '" . FSSJ3Helper::getEscaped($db, $ticketid) . "'";
         } else {
             $qry = "UPDATE #__fss_ticket_ticket SET closed = NULL WHERE id = '" . FSSJ3Helper::getEscaped($db, $ticketid) . "'";
         }
         $db->setQuery($qry);
         $db->Query();
         if ($newstatus > 0) {
             $oldstatus = $this->GetStatus($status['ticket_status_id']);
             $newstatus = $this->GetStatus($newstatus);
             $this->AddTicketAuditNote($ticketid, "Status changed from '" . $oldstatus['title'] . "' to '" . $newstatus['title'] . "'", $userid);
         }
     }
     $qry = "UPDATE #__fss_ticket_ticket SET lastupdate = '{$now}' WHERE id = '" . FSSJ3Helper::getEscaped($db, $ticketid) . "'";
     $db->setQuery($qry);
     $db->Query();
     $ticket = $this->getTicket($ticketid);
     if ($isadmin) {
         FSS_EMail::Admin_Reply($ticket, $subject, $body, array());
     } else {
         FSS_EMail::User_Reply($ticket, $subject, $body, array());
     }
 }