php - CakePHP 分页最大限制不起作用

Question

我正在使用 cakephp 2.x。我无法设置记录的最大限制。

请检查我的代码:

App::uses('AppController', 'Controller');
class BroadcastsController extends AppController {
   public $components = array('Paginator');

   public function broadcast(){           
         $this->Paginator->settings = array('limit' => 10,  'order' => array('Broadcast.no_of_user' => 'DESC'), 'group' => 'Broadcast.broadcaster_id');
         $popularRooms = $this->Paginator->paginate('Broadcast');
         pr($popularRooms); //fetch 200 records
         $this->set('popularRooms', $popularRooms);
   }
}

上面 pr($popularRooms); 我得到 200 条记录，但我想要前 50 条记录，并且每页显示 10 条记录。我使用的是 'maxLimit'=>50 但此代码与 'limit'=>50 相同。请帮助我。

Answer 1

在这种情况下，您可以在分页器设置中使用“extras”数组

$this->Paginator->settings = array('limit' => 10, 'max_record'=>50, 'order' => array('Broadcast.no_of_user' => 'DESC'), 'group' => 'Broadcast.broadcaster_id');

在您的模型或 AppModel 中覆盖 paginateCount 函数

class Broadcast extends AppModel { 
function paginateCount($conditions, $recursive, $extra) {
    $param = array_merge(compact('conditions', 'recursive'), $extra);
    $count = $this->find('count', $param);
    if (!empty($extra['max_record']) && $count > $extra['max_records']) {
      $count = $extra['max_record'];
    }
    return $count;
  } 
}