Admin generator, filters and I18n

2023-07-08 10:41 21次浏览 问答

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
I’ve 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/。

相关推荐