public function getRelated($start = 0, $limit = 0, $sort = 'related_name', $order = 'ASC')
{
$criteria = new CriteriaCompo();
$criteria->setSort($sort);
$criteria->setOrder($order);
$criteria->setStart($start);
$criteria->setLimit($limit);
return parent::getAll($criteria, null, false);
}
public function getStats($content_id)
{
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('rating_content_id', $content_id));
$i = 0;
$total = 0;
$obj = parent::getAll($criteria);
foreach ($obj as $k => $v) {
++$i;
$total += $v->getVar('rating_rating');
}
return array('voters' => $i, 'average' => $total / $i);
}
/**
* @param bool $asobject
*
* @return array
*/
public function getAllLanguage($asobject = true)
{
$criteria = new CriteriaCompo();
$criteria->setSort('xlanguage_weight');
$criteria->setOrder('asc');
return parent::getAll($criteria, null, $asobject, true);
}
public function getActiveSmilies($asobject = true)
{
$criteria = new CriteriaCompo(new Criteria('smiley_display', 1));
return parent::getAll($criteria, false, $asobject);
}
public function getPageTitle($status = null, $sort = 'content_weight ASC, content_title', $order = 'ASC')
{
$criteria = new CriteriaCompo();
if (isset($status)) {
$criteria->add(new Criteria('content_status', $status));
}
$criteria->setSort($sort);
$criteria->setOrder($order);
return parent::getAll($criteria, array('content_id', 'content_title'), false);
}
public function getListingPublished($start = 0, $limit = 0, $sort = 'date', $order = 'ASC')
{
$helper = Alumni::getInstance();
$xoops = $helper->xoops();
$module_id = $helper->getModule()->getVar('mid');
// get permitted id
$groups = $xoops->isUser() ? $xoops->user->getGroups() : '3';
$alumni_ids = $helper->getGrouppermHandler()->getItemIds('alumni_view', $groups, $module_id);
// criteria
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('valid', 1, '='));
$criteria->add(new Criteria('cid', '(' . implode(', ', $alumni_ids) . ')', 'IN'));
$criteria->setSort($sort);
$criteria->setOrder($order);
$criteria->setStart($start);
$criteria->setLimit($limit);
return parent::getAll($criteria);
}
public function menu_related($content_id)
{
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('link_content_id', $content_id));
$related = parent::getAll($criteria, null, true, false);
if (count($related) > 0) {
$related_Handler = Page::getInstance()->getRelatedHandler();
$related_arr = $related_Handler->get($related[0]->getVar('link_related_id'));
$ret = $related_arr->getValues();
// create button prev / next
$keys = array_keys($ret['related_links']);
foreach ($keys as $k => $i) {
if ($content_id == $ret['related_links'][$i]['content_id']) {
if ($k - 1 >= 0) {
$ret['prev_id'] = $ret['related_links'][$keys[$k - 1]]['content_id'];
$ret['prev_title'] = $ret['related_links'][$keys[$k - 1]]['content_title'];
}
if ($k + 1 < count($keys)) {
$ret['next_id'] = $ret['related_links'][$keys[$k + 1]]['content_id'];
$ret['next_title'] = $ret['related_links'][$keys[$k + 1]]['content_title'];
}
break;
}
}
return $ret;
}
return array();
}
