I'm using cakephp 2.1 and cakedc search plugin.
The thing is I can't glue it together. Also got:
Notice (8): Indirect modification of overloaded property ProjectsController::$paginate has no effect [APP\Controller\ProjectsController.php, line 48]
Followed cakedc tutorial but something's missing! Simple search just won't filter anything.
I want to filter by name field.
On my projects model
public $actsAs = array('Search.Searchable');
var $name = 'Project';
public $filterArgs = array(
array('name' => 'name', 'type' => 'like'),
array('name' => 'filter', 'type' => 'query', 'method' => 'orConditions'),
);
public function orConditions($data = array()) {
$filter = $data['filter'];
$cond = array(
'OR' => array(
$this->alias . '.name LIKE' => '%' . $filter . '%',
//$this->alias . '.body LIKE' => '%' . $filter . '%',
));
return $cond;
}
in my controller:
public $components = array('Search.Prg');
public $presetVars = array(
array('field' => 'name', 'type' => 'value')
);
index function updated to use index.ctp only (no find function)
public function index() {
$this->Prg->commonProcess();
$this->Project->recursive = 0;
// next line causes
// Notice (8): Indirect modification of overloaded property ProjectsController::$paginate has no effect [APP\Controller\ProjectsController.php, line 48]
//$this->paginate['conditions'] = $this->Project->parseCriteria($this->passedArgs);
$this->set('projects', $this->paginate());
}
and added search form to view.ctp
echo $this->Form->create('Project', array('url' => array_merge(array('action' => 'index'), $this->params['pass'])));
echo $this->Form->input('name', array('div' => false));
echo $this->Form->submit(__('Search', true), array('div' => false));
echo $this->Form->end();
I know this must be some obvious error on my part, please bear with me. Can anyone help?
Thanks a lot !
I'm glad to let people know I found my way to use cakedc search plugin.
First I had to closely follow this tutorial for 1.3 (at first I thought it won't do for 2.1, but it works like charm.)
http://www.youtube.com/watch?v=FAVuLXFVaCw
AND downloaded 1.3 sample code from cakedc
http://cakedc.com/eng/downloads/view/cakephp_search_plugin
to make sense of video tutorial. (tried to run it following readme instructions but got error Fatal error: Class 'Dispatcher' not found in C:\wamp\www\search\webroot\index.php on line 83 so
chose to just get code snippets and have them work in 2.1)
Back to my project:
1.- Downloaded search version 2.1 from cakedc https://github.com/CakeDC/search,
file CakeDC-search-2.1-0-g834f79f.zip.
2.- Placed all files on /plugins/Search/ folder
3.- Added
CakePlugin::load('Search');
to the bottom of /Config/bootstrap.php
4.- On my controller, declared the component and presetVars (I'm using a field called name)
public $components = array('Search.Prg');
public $presetVars = array(
array('field' => 'name', 'type' => 'value'),
array('field' => 'pr_status', 'type' => 'value'),
);
5.- and updated my index function:
public function index() {
$this->Prg->commonProcess();
$this->paginate = array(
'conditions' => $this->Project->parseCriteria($this->passedArgs));
$this->set('projects', $this->paginate());
}
6.- on my model, added
public $actsAs = array('Search.Searchable');
public $filterArgs = array(
array('name' => 'name', 'type' => 'query', 'method' => 'filterName'),
array('name' => 'pr_status', 'type' => 'value'),
);
public function filterName($data, $field = null) {
if (empty($data['name'])) {
return array();
}
$nameField = '%' . $data['name'] . '%';
return array(
'OR' => array(
$this->alias . '.name LIKE' => $nameField,
));
}
// Built a list of search options (unless you have this list somewhere else)
public function __construct($id = false, $table = null, $ds = null) {
$this->statuses = array(
'' => __('All', true),
0 => __('Bid', true),
1 => __('Cancelled', true),
2 => __('Approved', true),
3 => __('On Setup', true),
4 => __('Field', true),
5 => __('Closed', true),
6 => __('Other', true));
parent::__construct($id, $table, $ds);
}
7.- Lastly, created the search form on index.ctp, right above the table tag
<div><?php
echo $this->Form->create('Project', array(
'url' => array_merge(array('action' => 'index'), $this->params['pass'])
));
echo $this->Form->input('name', array('div' => false, 'empty' => true)); // empty creates blank option.
echo $this->Form->input('pr_status', array('label' => 'Status', 'options' => $statuses));
echo $this->Form->submit(__('Search', true), array('div' => false));
echo $this->Form->end();
?>
</div>
I also learned not to discard 1.3 tutorials and documentation even though i'm using 2.1. Next step is to filter by dates and a nicer search form.
Good luck everybody.
Carlos