/** * Pager db request handler * @param \samson\activerecord\dbQuery $query */ public function dbPagerHandler(&$query) { // Create count request to count pagination $countQuery = clone $query; $this->pager->update($countQuery->count()); // Set current page query limits $query->limit($this->pager->start, $this->pager->end); }
/** * Generic SamsonCMS table pagination handler * @param dbQuery $query Query object * @param Pager $pager Pagination object */ public function pagination(dbQuery &$query) { // If pager is passed if (isset($this->pager)) { // Clone query for count request $count_query = clone $query; $this->pager->update($count_query->innerCount()); //elapsed('pagination'.$this->pager->total); // Set originl query limit $query->limit($this->pager->start, $this->pager->end, true); } }