function getCategoriesByParent($cat_pid = 0, $start = 0, $perPage = 0, $order = 'ASC') { $criteria = new criteriaCompo(new criteria('cat_pid', $cat_pid)); $criteria->setSort('cat_title'); $criteria->setOrder($order); if ($start > 0) { $criteria->setStart($start); } if ($perPage > 0) { $criteria->setLimit($perPage); } $result =& $this->handler->getObjects($criteria); return $result; }
/** * get entries of categories specified in array sorted order by cat_id, created for index.php * @author hodaka <*****@*****.**> */ function getEntriesByCategoryArray($currentuid, $cid_array = array(), $user_id = 0, $start = 0, $perPage = 0, $order = 'DESC') { $criteria = new criteriaCompo(new criteria('user_id', $currentuid)); $criteria->add(new criteria('private', 'N'), 'OR'); $criteria = new criteriaCompo($criteria); $criteria->add(new Criteria('cat_id', "(" . implode(',', $cid_array) . ")", 'IN')); if ($user_id > 0) { $criteria->add(new criteria('user_id', $user_id)); } $criteria->setSort('cat_id, created'); $criteria->setOrder($order); if ($start > 0) { $criteria->setStart($start); } if ($perPage > 0) { $criteria->setLimit($perPage); } $result =& $this->handler->getObjects($criteria); return $result; }
$start = isset($_GET['start']) ? intval($_GET['start']) : 0; /** * Filter for search pictures in database */ if ($controler->isOwner == 1) { $criteria_uid = new criteria('uid_owner', $controler->uidOwner); } else { $criteria_private = new criteria('private', 0); $criteria_uid2 = new criteria('uid_owner', intval($controler->uidOwner)); $criteria_uid = new criteriaCompo($criteria_uid2); $criteria_uid->add($criteria_private); } $criteria_uid->setLimit($xoopsModuleConfig['picturesperpage']); $criteria_uid->setStart($start); if ($xoopsModuleConfig['images_order'] == 1) { $criteria_uid->setOrder('DESC'); $criteria_uid->setSort('cod_img'); } /** * Fetch pictures from factory */ $pictures_object_array = $controler->album_factory->getObjects($criteria_uid); $criteria_uid->setLimit(''); $criteria_uid->setStart(0); /** * If there is no pictures in the album show in template lang_nopicyet */ if ($nbSections['nbPhotos'] == 0) { $nopicturesyet = _MD_YOGURT_NOTHINGYET; $xoopsTpl->assign('lang_nopicyet', $nopicturesyet); } else {