function &getTicket($ticketid)
{
$db = JFactory::getDBO();
$query = "SELECT t.*, u.name, u.username, p.title as product, d.title as dept, d.translation as dtr, c.title as cat, c.translation as ctr, s.title as status, s.translation as str, s.userdisp, ";
$query .= "s.color as scolor, s.id as sid, pr.title as pri, pr.color as pcolor, pr.translation as ptr, pr.id as pid, au.name as assigned, p.translation as prtr ";
$query .= " FROM #__fss_ticket_ticket as t ";
$query .= " LEFT JOIN #__users as u ON t.user_id = u.id ";
$query .= " LEFT JOIN #__fss_prod as p ON t.prod_id = p.id ";
$query .= " LEFT JOIN #__fss_ticket_dept as d ON t.ticket_dept_id = d.id ";
$query .= " LEFT JOIN #__fss_ticket_cat as c ON t.ticket_cat_id = c.id ";
$query .= " LEFT JOIN #__fss_ticket_status as s ON t.ticket_status_id = s.id ";
$query .= " LEFT JOIN #__fss_ticket_pri as pr ON t.ticket_pri_id = pr.id ";
$query .= " LEFT JOIN #__users as au ON t.admin_id = au.id ";
$query .= " WHERE t.id = '" . FSSJ3Helper::getEscaped($db, $ticketid) . "' ";
$query .= " AND " . SupportSource::user_show_sql();
$db->setQuery($query);
$rows = $db->loadAssoc();
return $rows;
}
