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(); }