Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

Hi Josh,

Thanks for the answer. Let me explain what I am trying to achieve.

I am working on filter records based on data entered on search form.

---Controller code----

$this->paginate = ['searchFilter'=>true, 'limit'=>10, 'order'=>['Users.id'=>'DESC'], 'conditions'=>['Users.active'=>1]];

$users = $this->paginate('Users')->toArray();

$this->set(compact('users'));

----View code----

Here are search form fields for example First Name, Last Name, Email, Status("", Active, Inactive) etc these should be anything based on configuration

[Search][Reset] buttons

 

Users data in HTML table

----Searchable Behaviour----

FYI- In Search Component I attach a Search behaviour with current model table and pass predefined Search Form Fields(same we displayed in view) to behaviour as config. 

function beforeFind(Event $event, Query $query, $options, $primary) {

// here I have Search Form Fields and based on 'searchFilter' option in $options array I can modify only desired Query.

Case 1-

I can make a new condition array based on search form fields. and call

$query->where($cond);

This way it adds new conditions in existing conditions in query object.

Failing Situation.

Existing condition has Users.active = 1 and If new condition array has Users.active = 0 so this way merged conditions will have Users.active = 1 AND Users.active = 0 //No Result

Case 2-

I can make a new condition array based on search form fields. and call

$query->where($cond, [], ture);

This way it overwrite exiting conditions with new conditions in query object.

Failing Situation.

Existing condition has Users.active = 1 and If new condition array has not Users.active field so this way wrong result comes, means inactive users also comes. //in this case original condition should preserve.

// What I want solution is If some how I get existing condition as an array then I can modify them and can call

$query->where($cond, [], ture);

//As we do in cakephp 2.x.

return $query;

}

I hope it's clear to you. Please let me know if you want any more clarification.

Thanks

On Friday, January 16, 2015 at 12:47:39 AM UTC+5:30, José Lorenzo wrote:

Even though that is possible you are tying to do it the hard way. The easiest way you can implement the same is by using the query as a "command" object,

thus instructing the custom finders to do stuff based on the passed options. An example

$table->find('forUser', ['user' => $user])->find('withStatus', ['status' => 'active']);

Then in your table you would create your finders this way:

public function finWithStatus($query, $options) {

    if (!empty($options['user'])) {

         // The user is available from the previous finder, I can add more conditions here based on that

    }

}

I guess the best way I can help you find the best strategy is if you mention what exactly you are trying to do :D
On Thursday, January 15, 2015 at 3:26:09 PM UTC+1, Cake Developer wrote:

Hello,

I am trying to get and modify query conditions in beforeFind function of Behaviour.

function beforeFind(Event $event, Query $query, $options, $primary) {

   // here is what I tried so far.

$conditions = $query->clause('where');

// this gives me Object of Expression Interface and I am not able to convert it in condition array like we have in cakephp 2.x

//what I want to achieve... 

//I want to modify existing conditions in query.

//I want to add new condition in query

}

I spent last 2 days but could not figure out any solution.

Thanks for any help you may be able to provide regarding this.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.