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()); } }