Cakephpでページネートを利用する時、条件(オプション)はpaginateへ代入後、実行すればよいです。
以下、サンプルコードです。※条件にまったく意味はありません。
public function hogefuga($staff)
{
$options = [
'fields' => [
'id',
'ipaddress' => "REPLACE(ipaddress, '::ffff:', '')", // SQL関数も使える
],
'conditions' => [
'OR' => [
'staff_id' => $staff->id,
'login_id' => $staff->login_id,
],
],
'limit' => 30,
];
// paginateに条件を代入すればOK
$this->paginate = $options;
$this->set('data', $this->paginate());
public function hogefuga($staff)
{
$options = [
'fields' => [
'id',
'ipaddress' => "REPLACE(ipaddress, '::ffff:', '')", // SQL関数も使える
],
'conditions' => [
'OR' => [
'staff_id' => $staff->id,
'login_id' => $staff->login_id,
],
],
'limit' => 30,
];
// paginateに条件を代入すればOK
$this->paginate = $options;
$this->set('data', $this->paginate());
public function hogefuga($staff) { $options = [ 'fields' => [ 'id', 'ipaddress' => "REPLACE(ipaddress, '::ffff:', '')", // SQL関数も使える ], 'conditions' => [ 'OR' => [ 'staff_id' => $staff->id, 'login_id' => $staff->login_id, ], ], 'limit' => 30, ]; // paginateに条件を代入すればOK $this->paginate = $options; $this->set('data', $this->paginate());