public static function getContent($item)
{
$prerequisiti = gglmsHelper::_chek_prerequisiti($item['id']);
$stato = gglmsHelper::_check_stato($item['id']);
if ($prerequisiti) {
echo '<div class="box col-md-2 img-rounded">';
//RS echo '<a href="component/gglms/contenuto/' . $item['alias'] . '" title="' . strip_tags($item['descrizione']) . '" >';
$url = 'index.php?option=com_gglms&view=contenuto&alias=' . $item['alias'];
FB::log($url, " URL getContent ");
echo '<a href="' . JROUTE::_($url) . '" title="' . strip_tags($item['descrizione']) . '" >';
}
?>
<div class="boxtitle">
<?php
echo $item['titolo'];
?>
</div>
<div class="boximg">
<?php
if (file_exists('../mediagg/contenuti/' . $item["id"] . '/' . $item["id"] . '.jpg')) {
echo '<img class="img-responsive" src="../mediagg/contenuti/' . $item["id"] . '/' . $item["id"] . '.jpg">';
} else {
echo '<img class="img-responsive" src="components/com_gglms/images/sample.jpg">';
}
?>
</div>
<div class="boxinfo">
<table width="100%">
<tr>
<!--<td rowspan="2" width="33%"><?php
//echo outputHelper::getContentIconStatus($item);
?>
</td>-->
<td rowspan="2" width="20%"><?php
$prerequisiti = gglmsHelper::_chek_prerequisiti($item['id']);
$stato = gglmsHelper::_check_stato($item['id']);
outputHelper::getContentIconStatus($prerequisiti, $stato);
?>
</td>
<td width="20%">Durata</td>
<td width="20%"><?php
echo outputHelper::convertiDurata($item["durata"]);
?>
</td>
<td width="40%"><?php
echo ratingHelper::totRating($item["id"]);
?>
valutazioni</td>
</tr>
<tr>
<td>Visite</td>
<td><?php
echo gglmsHelper::getViews($item['id']);
?>
</td>
<td> <input
type="number"
class="rating"
step=1
data-size="xs"
data-rtl="false"
data-min="0" data-max="5"
data-glyphicon="false"
data-rating-class="rating-fa"
data-show-caption="false"
data-show-clear="false"
readonly="true"
value= "<?php
echo ratingHelper::avgRating($item["id"]);
?>
"
> </td>
</tr>
</table>
</div>
<?php
if ($prerequisiti) {
echo '</a>';
}
echo "</div>";
}
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;
}
