将数组转换为Cakephp 3中的Cake\ORM\Query对象 [英] convert array to Cake\ORM\Query object in cakephp 3

问题描述

在这里，我将 $ allProductData 转换为数组，因为在这里我必须应用 foreach 循环以及此后的一些条件我将 $ allProductData 分配给分页，但出现错误无法找到与分页兼容的对象。那么如何将数组转换为 Cake\ORM\Query 对象传递给分页？

Here I am converting $allProductData to array because there I have to apply foreach loop and some conditions after that I am assigning $allProductData to pagination but I am getting error "Unable to locate an object compatible with paginate." so how can I convert array to Cake\ORM\Query object to pass into pagination?

$this->PurchaseRequisitionProducts->hasMany('PurchaseOrderProducts', [
    'bindingKey'=>'product_id',
    "foreignKey"=>'product_id'
]);
$allProductData = $this->PurchaseRequisitionProducts->find('all',[
    'contain' => ['PurchaseOrderProducts'=>function($c){
        return $c->where(['PurchaseOrderProducts.id IS NOT NULL']);
    },'PurchaseOrderProducts.PurchaseOrder'=>function($p){
        return $p->where(['PurchaseOrder.id IS NOT NULL'])
            ->where(['PurchaseOrder.is_approve'=>"Y"])
            ->where(['PurchaseOrder.po_type'=>1])
            ->where(['PurchaseOrder.status'=>1]);
    },'PurchaseOrderProducts.PurchaseOrder.CompanyMaster','PurchaseRequisition.Users.EmployeeDetails.Departments','ProductCategory','ProductSubcategory','Currency','PurchaseRequisition','ProductsMaster','Uom'] ,
    'conditions'=>[$condn,$conditions],
    //"sortWhitelist"=>["id",'EmployeeDetails.first_name','Departments.department',"pr_reference_no","pr_date",'purchase_requisition_id', "ProductsMaster.product_name","ref_price","qty","approved_qty"],
    'order'=>["PurchaseRequisitionProducts.id"=>"desc"],
])->toArray();

$pr_product = $this->paginate($allData)->toArray();
if($pr_product){
    foreach($pr_product as $key1=>$prProd){
        if(empty($prProd['purchase_order_products']) || !isset($prProd['purchase_order_products']) || $prProd['purchase_order_products']==null || $prProd['purchase_order_products']=='' || empty($prProd['purchase_order_products'])){
            unset($pr_product[$key1]);
        }

        if(isset($prProd['purchase_order_products'])){
            $supplier=[];
            $poarray=[];
            foreach($prProd['purchase_order_products'] as $key2=>$poProd){
                if($poProd['purchase_order']==null || $poProd['purchase_order']=='' || empty($poProd['purchase_order'])){
                    unset($prProd['purchase_order_products'][$key2]);
                }

                $supplier[]=$poProd['purchase_order']['supplier_id'];
                //debug($supplier);
                $companies= $this->CompanyMaster->find('list', [
                    'keyField' => 'id','valueField' => 'Company_name',
                    'conditions'=>['id IN'=>$supplier],
                ])->toArray();
                $pr_product[$key1]['supplier']=$companies;
            }

            if(empty($prProd['supplier'])){
                unset($pr_product[$key1]);
            }
        }
    }
}

推荐答案

与其在查找所有查询中添加数组，不如在分页结果中添加它，例如：

Instead of adding to array in find all query you should add it on the result of pagination like:

   $allProductData = $this->PurchaseRequisitionProducts->find('all',[
        'contain' => ['PurchaseOrderProducts']
    ]);// remove toArray() from here
    $pr_product = $this->paginate($allProductData)->toArray(); // AddtoArray() here

或者您可以尝试如下操作：

OR you can try like this:

 $paginate = [
                    'contain' => ['PurchaseOrderProducts'],
                    'limit' => 10
                ];
    $this->set('data', $this->Paginator->paginate($this->PurchaseRequisitionProducts->find('all'), $paginate)->toArray());

这篇关于将数组转换为Cakephp 3中的Cake\ORM\Query对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！