Re: CakeDC Search plugin for CakePhp 2.0, multiple models

I got the same error and I was using related tables.

On Saturday, June 16, 2012 7:13:03 PM UTC-4, Bob Bowen wrote:

Hi and thanks for the reply.

Yea, I had seen this plugin, it's a fork of the CakeDC plugin. And I see in the docs that you can do something like this:

class Article extends AppModel {

  public $filterArgs = array(

'enhanced_search' => array('type' => 'like', 'field' => array('Article.name', 'OtherModel.name'))

  }

}

But what is not explained is, how do I get the plugin to actually search within the 'OtherModel' Model? I ask because later in the Controller you have:

class ArticlesController extends AppController {

    public $components = array('Search.Prg');

    public $presetVars = true; // using the model configuration

    public function find() {

        $this->Prg->commonProcess();

        $this->paginate['conditions'] = $this->Article->parseCriteria($this->passedArgs);

        $this->set('articles', $this->paginate());

    }

}

And in the .ctp you have:

echo $this->Form->create('Article', array(

    'url' => array_merge(array('action' => 'find'), $this->params['pass'])

));

As you can see, the Article Model is always referenced. So if I want to search for a field from another model, like the 'OtherModel.name' example above, it crashes, saying:

Column not found: 1054 Unknown column ' OtherModel.name ' in 'where clause'

The SQL is more or less:

SELECT `Article`.`id`, ... FROM `articles` WHERE ((`Article`.`name` LIKE '%foo%') OR (`OtherModel`.`name` LIKE '%foo%')) 

Obviously OtherModel.name is not going to be found in Article. 

What I need to do is have a general Search box that searches in 4-5 different Models. There is no relation between those Models. So I am not sure which Model to put the filterArgs array, which Controller to put the presetVars array and find() function, and how to call it all in my .ctp so that it can return results from all 5 of these Models, not just one.

Can this plugin do it?

Many thanks!

On Friday, June 15, 2012 10:08:11 AM UTC+2, euromark wrote:

try this one:

https://github.com/dereuromark/search 

it can handle multiple fields across models for a like term etc

    'field' => array('Primary.field', 'Secondary.other_field')

Am Freitag, 15. Juni 2012 00:06:03 UTC+2 schrieb Bob Bowen:

Is there any way to make this work? As I understand it you have to enable Search.Searchable in the $actsAs, and define $filterArgs for each Model, then add Search.Prg to $components and define $presetVars in the Controller.

Then in your .ctp file you put something like this:

echo $this->Form->create('MyModel', array('url' => array_merge(array('action' => 'find'), $this->params['pass'])));

echo $this->Form->input('search', array('div' => false));

echo $this->Form->submit(__('Search', true), array('div' => false));

echo $this->Form->end();

But this allows you to search in one Model at a time. Is there any way to define a search form with one search field and have it look in various fields within various Models?

Thanks

Bob

--
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/groups/opt_out.