Admin generator, filters and I18n
更新時間:2011年10月06日 11:17:28 作者:
You need to modify your EntityFormFilter (where Entity is your object class - Article, Book, etc.).
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/
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/
您可能感興趣的文章:
- 在Node.js中使用Javascript Generators詳解
- Java的MyBatis框架中MyBatis Generator代碼生成器的用法
- 深入學習python的yield和generator
- Java的Struts框架中append標簽與generator標簽的使用
- 小議JavaScript中Generator和Iterator的使用
- 詳解JavaScript ES6中的Generator
- python生成器generator用法實例分析
- Python生成器(Generator)詳解
- Ajax loading gif generator
- 淺析JavaScript 箭頭函數 generator Date JSON
相關文章
How do I change MySQL timezone?
The MySQL timezone is set to MST (-7 hours GMT/UTC) and is not configurable by you. MySQL is only capable of having 1 timezone setting per mysql daemon. Therefore, you cannot select NOW() and expect a result in a timezone other than MST.2008-03-03

