Admin generator, filters and I18n |
|
Three easy steps 1) configure function Add an input for each field you want to include in your filter 复制代码 代码如下: $this->widgetSchema[name] = new sfWidgetFormFilterInput(array(with_empty => false)); $this->validatorSchema[name] = new sfValidatorPass(array(required => false)); 2) add a query modification when filtering for that field Ive done it for Doctrine. Pay atention to the method name addFIELDColumnQuery. 复制代码 代码如下: public function addNameColumnQuery(Doctrine_Query $query, $field, $values) { if (is_array($values) && isset($values[text]) && != $values[text]) { $query->leftJoin(r.Translation t) // ->andWhere(t.lang = ?, $especify_one_language) // or it will search in all of them ->andWhere(CONCAT(t.name, t.shortname) like ?, % . $values[text] . %); } } 3) Add your searching fields 复制代码 代码如下: public function getFields() { return parent::getFields() + array(name => Text); } From: http://oldforum.symfony-project.org/index.php/t/24350/ |
