static function &getTicketCount()
{
FSF_Ticket_Helper::getAdminPermissions();
if (empty(FSF_Ticket_Helper::$counts)) {
$db = JFactory::getDBO();
$query = "SELECT count( * ) AS count, ticket_status_id FROM #__fsf_ticket_ticket WHERE 1 ";
$query .= FSF_Ticket_Helper::$_perm_where;
$query .= " GROUP BY ticket_status_id";
$db->setQuery($query);
$rows = $db->loadAssocList();
$out = array();
FSF_Ticket_Helper::GetStatusList();
foreach (FSF_Ticket_Helper::$status_list as $status) {
$out[$status->id] = 0;
}
if (count($rows) > 0) {
foreach ($rows as $row) {
$out[$row['ticket_status_id']] = $row['count'];
}
}
// work out counts for allopen, closed, all, archived
$archived = FSF_Ticket_Helper::GetStatusID("def_archive");
$out['archived'] = 0;
if (array_key_exists($archived, $out)) {
$out['archived'] = $out[$archived];
}
$allopen = FSF_Ticket_Helper::GetStatusIDs("is_closed", true);
$out['allopen'] = 0;
foreach ($allopen as $id) {
if (array_key_exists($id, $out)) {
$out['allopen'] += $out[$id];
}
}
$allclosed = FSF_Ticket_Helper::GetClosedStatus();
$out['allclosed'] = 0;
foreach ($allclosed as $id) {
if (array_key_exists($id, $out)) {
$out['allclosed'] += $out[$id];
}
}
$all = FSF_Ticket_Helper::GetStatusIDs("def_archive", true);
$out['all'] = 0;
foreach ($all as $id) {
if (array_key_exists($id, $out)) {
$out['all'] += $out[$id];
}
}
FSF_Ticket_Helper::$counts = $out;
}
return FSF_Ticket_Helper::$counts;
}
