如何扩展在Symfony 1.4中生成backend-form-field的查询？

Question

I want to filter the options of a select-box in a SF-1.4 backend-module according to the logged-in user. Where is the right place to modify/extend the SQL-query, that is creating the SELECT-Box?

Answer 1

Just overwrite the widget/validator for that selectbox in your form filter class. I can give you more information but i need to know what ORM you are using.

---

Both sfWidgetFormDoctrineChoice and sfValidatorDoctrineChoice have an option named query. Use that and set your custom query. So you need to do something like this in you filter class:

$query = Doctrine::getTable('Table')->createQuery()->where('field = ?', $field_value);

$this->widgetSchema['your_form_field']->setOption('query', $query);

$this->validatorSchema['your_form_field']->setOption('query', $query);

`