我使用symfony表单为我的所有用户创建一个选择框。我按全名显示它们,但希望按字母顺序对它们进行排序。
$builder->add('transferTo', 'document', [
'class' => 'UserBundle:User',
'property' => 'fullname',
'label' => 'Overdragen aan',
'attr' => ['class' => 'form-control selectpicker'],
'label_attr' => ['class' => 'col-sm-2 control-label'],
'multiple' => false,
'required' => true
]);如何根据firstName的全名按字母顺序对用户进行排序?
发布于 2014-03-18 04:39:41
您需要做的是将queryBuilder添加到表单参数中
use Doctrine\ORM\EntityRepository;
$builder->add('transferTo', 'document', [
'class' => 'UserBundle:User',
'query_builder' => function(EntityRepository $repository) {
return $repository->createQueryBuilder('u')->orderBy('u.fullname', 'ASC');
}
'property' => 'fullname',
'label' => 'Overdragen aan',
'attr' => ['class' => 'form-control selectpicker'],
'label_attr' => ['class' => 'col-sm-2 control-label'],
'multiple' => false,
'required' => true
]);我假定您的实体中的字段名为u.fullname
https://stackoverflow.com/questions/22464549
复制相似问题