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/
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！