Search functionality of cakephp??07.12.13

Anonymous

this solution given by cakephp is a bit circuitous and mysteriously , looking or better solution later....

1.
create a new table called search_index with the MyISAM engine:

CREATE TABLE IF NOT EXISTS `search_index` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `association_key` int(11) NOT NULL,
  `model` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `data` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `association_key` (`association_key`,`model`),
  FULLTEXT KEY `data` (`data`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

2.
in app/models create the file search_index.php

<?php
class SearchIndex extends AppModel {
	var $name = 'SearchIndex';
	var $useTable = 'search_index';
	private $models = array();

private function bindTo($model) {
		$this->bindModel( 
			array(
				'belongsTo' => array(
					$model => array (
						'className' => $model,
						'conditions' => 'SearchIndex.model = \''.$model.'\'',
						'foreignKey' => 'association_key'
					)
				)
			),false 
		);
	}
	
	
	function searchModels($models = array()) {
		if (is_string($models)) $models = array($models);
		$this->models = $models;
		foreach ($models as $model) {
			$this->bindTo($model);
		}
	}
		
	function beforeFind($queryData) {
		$models_condition = false;
		if (!empty($this->models)) {
			$models_condition = array();
			foreach ($this->models as $model) {
				$Model = ClassRegistry::init($model);
				$models_condition[] = $model . '.'.$Model->primaryKey.' IS NOT NULL'; 
			}
		}
		
		if (isset($queryData['conditions'])) {
			if ($models_condition) {
				if (is_string($queryData['conditions'])) {
					$queryData['conditions'] .= ' AND (' . join(' OR ',$models_condition) . ')';
				} else {
					$queryData['conditions'][] = array('OR' => $models_condition);
				}
			}
		} else {
			if ($models_condition) {
				$queryData['conditions'][] = array('OR' => $models_condition);
			}
		}
		return $queryData; 	
	}
}
?>

add the file app/models/behaviour/searchable.php

<?php
class SearchIndex extends AppModel {
	var $name = 'SearchIndex';
	var $useTable = 'search_index';
	private $models = array();

4.
for the  seachable model file add the line
    var $actsAs = array ('Searchable'); 
example:

<?php

class Post extends AppModel
{
    var $name = 'Post';
    var $actsAs = array ('Searchable'); 
}

07.12.13

http://code.google.com/p/searchable-behaviour-for-cakephp/

Anonymous

Search functionality of cakephp??07.12.13

Information Epoch 1732466854