function User_Open($ticket, $params)
{
if ($ticket->email) {
FSS_EMail::User_Create_Unreg($ticket, $params['subject'], $params['user_message'], $params['files']);
} else {
FSS_EMail::User_Create($ticket, $params['subject'], $params['user_message'], $params['files']);
}
FSS_EMail::Admin_Create($ticket, $params['subject'], $params['user_message'], $params['files']);
}
function OpenNewTicket($userid, &$messageid)
{
$db = JFactory::getDBO();
$priid = $this->params['pri_id'];
$catid = $this->params['cat_id'];
$deptid = $this->params['dept_id'];
$prodid = $this->params['prod_id'];
$admin_id = FSS_Ticket_Helper::AssignHandler($prodid, $deptid, $catid);
$subject = $this->headers->subject->text;
$body = $this->plainmsg;
$now = FSS_Helper::CurDate();
if ($this->messagetime > 0) {
$now = date("Y-m-d H:i:s", $this->messagetime);
}
$def_open = FSS_Ticket_Helper::GetStatusID('def_open');
$source = "email_accepted";
if (isset($this->params['confirmnew']) && $this->params['confirmnew'] == 1) {
$source = "email";
}
$qry = "INSERT INTO #__fss_ticket_ticket (reference, ticket_status_id, ticket_pri_id, ticket_cat_id, ticket_dept_id, prod_id, title, opened, lastupdate, user_id, admin_id, email, password, unregname, source) VALUES ";
$qry .= "('', {$def_open}, '" . FSSJ3Helper::getEscaped($db, $priid) . "', '" . FSSJ3Helper::getEscaped($db, $catid) . "', '" . FSSJ3Helper::getEscaped($db, $deptid) . "', '" . FSSJ3Helper::getEscaped($db, $prodid) . "', '" . FSSJ3Helper::getEscaped($db, $subject) . "', '{$now}', '{$now}', '" . FSSJ3Helper::getEscaped($db, $userid) . "', '" . FSSJ3Helper::getEscaped($db, $admin_id) . "', '', '', '', '{$source}')";
//echo $qry."<br>";
$db->setQuery($qry);
$db->Query();
$ticketid = $db->insertid();
$ref = FSS_Ticket_Helper::createRef($ticketid);
$qry = "UPDATE #__fss_ticket_ticket SET reference = '" . FSSJ3Helper::getEscaped($db, $ref) . "' WHERE id = '" . FSSJ3Helper::getEscaped($db, $ticketid) . "'";
$db->setQuery($qry);
$db->Query();
//echo $qry."<br>";
$qry = "INSERT INTO #__fss_ticket_messages (ticket_ticket_id, subject, body, user_id, posted, source) VALUES ('";
$qry .= FSSJ3Helper::getEscaped($db, $ticketid) . "','" . FSSJ3Helper::getEscaped($db, $subject) . "','" . FSSJ3Helper::getEscaped($db, $body) . "','" . FSSJ3Helper::getEscaped($db, $userid) . "','{$now}', 'email')";
//$this->Log($qry);
$db->setQuery($qry);
$db->Query();
$messageid = $db->insertid();
// attach files to ticket
if (FSS_Settings::get('support_user_attach')) {
$this->AttachFiles($ticketid, $userid, $messageid);
$this->processInlineImages($messageid, $body);
}
$ticket = $this->getTicket($ticketid);
if (isset($this->params['confirmnew']) && $this->params['confirmnew'] == 1) {
// send admin pending email
FSS_EMail::Admin_Pending($ticket, $subject, $body);
} else {
FSS_EMail::User_Create($ticket, $subject, $body);
FSS_EMail::Admin_Create($ticket, $subject, $body, $this->files);
}
return $ticketid;
}
