1 <?php
 2 /**
 3  * @package sapphire
 4  * @subpackage search
 5  */
 6 
 7 /**
 8  * Filters by full-text matching on the given field.
 9  *
10  * Full-text indexes are only available with MyISAM tables. The following column types are
11  * supported:
12  *   - Char
13  *   - Varchar
14  *   - Text
15  *
16  * To enable full-text matching on fields, you also need to add an index to the
17  * database table, using the {$indexes} hash in your DataObject subclass:
18  * 
19  * <code>
20  *   static $indexes = array(
21  *      'SearchFields' => 'fulltext(Name, Title, Description)'
22  *   );
23  * </code>
24  *
25  * @package sapphire
26  * @subpackage search
27  */
28 class FulltextFilter extends SearchFilter {
29 
30     public function apply(SQLQuery $query) {
31         $query->where(sprintf(
32             "MATCH (%s) AGAINST ('%s')",
33             $this->getDbName(),
34             Convert::raw2sql($this->getValue())
35         ));
36         return $query;
37     }
38 
39     public function isEmpty() {
40         return $this->getValue() == null || $this->getValue() == '';
41     }
42 }
43 ?>