function showSummary($option, $task)
{
global $database, $mainframe;
// get sort field and check against allowable field names
$field = strtolower(mosGetParam($_REQUEST, 'field', ''));
if (!in_array($field, array('agent', 'hits'))) {
$field = '';
}
// get field ordering or set the default field to order
$order = strtolower(mosGetParam($_REQUEST, 'order', 'asc'));
if ($order != 'asc' && $order != 'desc' && $order != 'none') {
$order = 'asc';
} else {
if ($order == 'none') {
$field = 'agent';
$order = 'asc';
}
}
// browser stats
$order_by = '';
$sorts = array();
$tab = mosGetParam($_REQUEST, 'tab', 'tab1');
$sort_base = "index2.php?option={$option}&task={$task}";
switch ($field) {
case 'hits':
$order_by = "hits {$order}";
$sorts['b_agent'] = mosHTML::sortIcon("{$sort_base}&tab=tab1", "agente");
$sorts['b_hits'] = mosHTML::sortIcon("{$sort_base}&tab=tab1", "acessos", $order);
$sorts['o_agent'] = mosHTML::sortIcon("{$sort_base}&tab=tab2", "agente");
$sorts['o_hits'] = mosHTML::sortIcon("{$sort_base}&tab=tab2", "acessos", $order);
$sorts['d_agent'] = mosHTML::sortIcon("{$sort_base}&tab=tab3", "agente");
$sorts['d_hits'] = mosHTML::sortIcon("{$sort_base}&tab=tab3", "acessos", $order);
break;
case 'agent':
default:
$order_by = "agent {$order}";
$sorts['b_agent'] = mosHTML::sortIcon("{$sort_base}&tab=tab1", "agente", $order);
$sorts['b_hits'] = mosHTML::sortIcon("{$sort_base}&tab=tab1", "acessos");
$sorts['o_agent'] = mosHTML::sortIcon("{$sort_base}&tab=tab2", "agente", $order);
$sorts['o_hits'] = mosHTML::sortIcon("{$sort_base}&tab=tab2", "acessos");
$sorts['d_agent'] = mosHTML::sortIcon("{$sort_base}&tab=tab3", "agente", $order);
$sorts['d_hits'] = mosHTML::sortIcon("{$sort_base}&tab=tab3", "acessos");
break;
}
$query = "SELECT *" . "\n FROM #__stats_agents" . "\n WHERE type = 0" . "\n ORDER BY {$order_by}";
$database->setQuery($query);
$browsers = $database->loadObjectList();
$query = "SELECT SUM( hits ) AS totalhits, MAX( hits ) AS maxhits" . "\n FROM #__stats_agents" . "\n WHERE type = 0";
$database->setQuery($query);
$bstats = null;
$database->loadObject($bstats);
// platform statistics
$query = "SELECT *" . "\n FROM #__stats_agents" . "\n WHERE type = 1" . "\n ORDER BY hits DESC";
$database->setQuery($query);
$platforms = $database->loadObjectList();
$query = "SELECT SUM( hits ) AS totalhits, MAX( hits ) AS maxhits" . "\n FROM #__stats_agents" . "\n WHERE type = 1";
$database->setQuery($query);
$pstats = null;
$database->loadObject($pstats);
// domain statistics
$query = "SELECT *" . "\n FROM #__stats_agents" . "\n WHERE type = 2" . "\n ORDER BY hits DESC";
$database->setQuery($query);
$tldomains = $database->loadObjectList();
$query = "SELECT SUM( hits ) AS totalhits, MAX( hits ) AS maxhits" . "\n FROM #__stats_agents" . "\n WHERE type = 2";
$database->setQuery($query);
$dstats = null;
$database->loadObject($dstats);
HTML_statistics::show($browsers, $platforms, $tldomains, $bstats, $pstats, $dstats, $sorts, $option);
}
