CakePHP 3.x分页关联模型(belongsToMany)

Question

我有一个模型交易愿望与城市模型(belongsToMany)相关联，结束我获取一个城市对应的ID与城市关联的交易，在DealsTable中我有获取函数:

public function findByCity($city){
    return $this->Cities->get($city , ['contain' => ['Deals']]);
}

在DealsController中，我想对与所获取的城市相关的交易进行分页，我在cakePHP 3书中没有找到解决方案。

Answer 1

据我所知，不可能对关联进行分页。我会这样做:

$city = $this->Cities->get($city);
$deals = $this->paginate($this->Cities->Deals->findByCityId($city->id));
return ['city'=>$city, 'deals'=>$deals];