cakephp - 按分页上的关联数据查找

Question

我有两个： Providers并Purchasetopay具有以下关联：

$Providers->hasMany('Purchasetopay', [
   'foreignKey' => 'providers_id'
]);

我也有以下行动：

public function fornecedores(){

        $Providers = TableRegistry::get('Providers');

        $pesquisar = $this->request->query('pesquisar');

        if(!empty($pesquisar)){
            $this->paginate = [
                'conditions' => 
                            [ 'OR' => 
                                ['Providers.cnpj' => $pesquisar,
                                 'Providers.corporatename LIKE' => '%'.$pesquisar.'%',
                                ]                              
                            ]
                         ];
        }

        $query = $Providers->find()->contain(['Telephones','Purchasetopay'=>['SupplierNotes']]);
        $providers = $this->paginate($query);
        $this->set(compact('providers'));

    }

我需要将 Purchasetopay 字段添加到OR条件中。如何？我看到了这个解决方案：https ://stackoverflow.com/a/39559315/11239369 但是，我不知道如何调整我的代码以这种方式工作。

标签： cakephpcakephp-3.0model-associations

Answer 1

您可以使用 orWhere/andWhere 如下：

$query = $Providers->find()
          ->contain(['Telephones','Purchasetopay'=>['SupplierNotes']])
          ->where( ['Providers.cnpj' => $pesquisar])
          ->orWhere(['Providers.corporatename LIKE' => '%'.$pesquisar.'%' ]);