protected function loadblogSections() { $blogSectionList = new ProblogList(); $blogSectionList->setItemsPerPage($this->num); $blogSectionList->filterByBlogSection(1); $blogSectionList->sortBy('cvName', 'asc'); $tmpSections = $blogSectionList->get(); $sections = array(); foreach ($tmpSections as $_c) { $sections[$_c->getCollectionID()] = $_c->getCollectionName(); } $this->set('sections', $sections); }
public function getPrevPost($c) { $cID = $c->getCollectionID(); $this->loadblogSections(); $pl = new ProblogList(); $pl->setItemsPerPage(1); $pl->filter(false, "cv.cID < {$cID}"); //$pl->filter(false,"(CHAR_LENGTH(cv.cvName) > 4 OR cv.cvName NOT REGEXP '^[0-9]')"); $pl->filter(false, "ak_is_canonical_page < 1"); $pl->filterByPublicDate(date('Y-m-d H:i:s'), '<='); $sections = $this->sections; $keys = array_keys($sections); if (is_array($keys)) { foreach ($keys as $id) { if ($fs) { $fs .= ' OR '; } $path = Page::getByID($id)->getCollectionPath() . '/'; $fs .= "pp.cPath LIKE '{$path}%'"; } $pl->filter(false, "({$fs})"); } $posts = $pl->get(); $np = $posts[0]; if ($np) { return Loader::helper('navigation')->getLinkToCollection($np); } }