/** * Method to get property SearchHelper * * @param bool $new * * @return SearchHelper */ public function getSearchHelper($new = false) { if (!$this->searchHelper || $new) { $this->searchHelper = new SearchHelper(); } $this->searchHelper->fuzzySearching((bool) $this->fuzzySearching()); return $this->searchHelper; }
/** * Configure the filter handlers. * * Example: * ``` php * $filterHelper->setHandler( * 'user.date', * function($query, $field, $value) * { * $query->where($field . ' >= ' . $value); * } * ); * ``` * * @param FilterHelperInterface $filterHelper The filter helper object. * * @return void */ protected function configureFilters(FilterHelperInterface $filterHelper) { $filterHelper->setHandler('activation', function (Query $query, $field, $value) { if ((string) $value == '0') { $query->where('CHAR_LENGTH(user.activation) > 0'); } elseif ($value == 1) { $query->where('CHAR_LENGTH(user.activation) = 0'); } }); }