convert array to Cake\ORM\Query object in cakephp 3

Question

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]);
            }
        }
    }
}

Exterminator · Accepted Answer · 2018-10-03 06:01:18Z

0

You can do it this way also, you have to remove toArray() in order to make pagination work.

$allProductData = $this->PurchaseRequisitionProducts->find('all')->contain(['PurchaseOrderProducts']);
$pr_product = $this->paginate($allProductData);

Also, define this public variable

public $paginate = [
    'limit' => 25,
    'order' => [
        'TableName.columnName' => 'asc' //not mandatory
    ]
];

answered Oct 3, 2018 at 6:01

Exterminator

1,2467 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Devendra Over a year ago

when I am doing find all after that I have apply some unset conditions in the find all then I have to assign the variable for paginate

Exterminator Over a year ago

unset conditions like? What do you mean by that?

Devendra Over a year ago

when I am getting all data then I have to apply foreach loop and remove some of the array

Exterminator Over a year ago

you don't need to do that, define that variable in the class of your controller it will take care of it automatically. define limit according to the data you need.

Devendra Over a year ago

I have add my complete code where I am doing too many unset under foreach loop can you please check.

Sehdev · Accepted Answer · 2018-10-03 06:27:07Z

0

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());

edited Oct 3, 2018 at 6:27

answered Oct 3, 2018 at 5:16

Sehdev

5,7123 gold badges14 silver badges34 bronze badges

7 Comments

Devendra Over a year ago

But before to add on pagination I have do some unset conditions in the find all.

Sehdev Over a year ago

What do you want to unset?

Devendra Over a year ago

I have add my complete code where I am doing too many unset under foreach loop can you please check.

Sehdev Over a year ago

You can pass these conditions in query. Anyway just remove toArray() from the $allProductData and set pagination data like $this->set('paginationData', $pr_product); after unsetting variables.

Exterminator Over a year ago

ok sure, and you dont need to unset the data, you can use the column name in condition directly

|

Collectives™ on Stack Overflow

convert array to Cake\ORM\Query object in cakephp 3

2 Answers 2

5 Comments

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related