public static function getTopRated()
{
try {
$user = JFactory::getUser();
$userid = $user->get('id');
$groups = JAccess::getGroupsByUser($userid, true);
$results = array();
$db = JFactory::getDBO();
$query = '
SELECT
c.*,
sum(rating) as totRating
FROM
#__gg_rating AS r
Inner Join #__gg_contenuti AS c ON c.id = r.id_contenuto
Inner Join #__gg_contenuti_acl AS acl ON acl.id_contenuto = c.id
WHERE id_group in (' . implode(",", $groups) . ')
GROUP BY c.id
ORDER BY totRating desc
LIMIT 12
';
$db->setQuery($query);
// FB::LOG($query, 'getMostView');
if (false === ($results = $db->loadAssocList())) {
throw new RuntimeException($db->getErrorMsg(), E_USER_ERROR);
}
foreach ($results as &$contenuto) {
$contenuto['prerequisiti'] = gglmsHelper::_chek_prerequisiti($contenuto['id']);
$contenuto['stato'] = gglmsHelper::_check_stato($contenuto['id']);
$contenuto['giavisto'] = gglmsHelper::getGiaVisto($contenuto['id']);
$contenuto['views'] = gglmsHelper::getViews($contenuto['id']);
}
} catch (Exception $e) {
}
return $results;
}
