Пример #1
0
 /**
  * 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);
 }
Пример #2
0
 /**
  * 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);
     }
 }