在Symfony2中使用JOIN标准查找 [英] findBy with JOIN criteria in Symfony2
问题描述
$ role = $ this-> getDoctrine() - > getRepository('TestBackEndBundle:Role') ;
$ roles = $ role-> findBy(array('name'=>'ROLE_PARTNER'));
$ user = $ this-> getDoctrine() - > getRepository('TestBackEndBundle:User');
$ partners = $ user-> findBy(array('userRoles'=> $ roles));
它是未定义的索引:joinColumns in ...。但是我在用户实体中有joinColumns:
/ **
* @ ORM\ManyToMany(targetEntity =Role )
* @ ORM\JoinTable(name =user_x_role,
* joinColumns = {@ ORM\JoinColumn(name =user_id,referencedColumnName =id,onDelete =CASCADE ,onUpdate =CASCADE)},
* inverseJoinColumns = {@ ORM\JoinColumn(name =role_id,referencedColumnName =id,onDelete =CASCADE,onUpdate =CASCADE)}
*)
* @var ArrayCollection
* /
protected $ userRoles;
IMO最好的方法是创建自己的仓库为用户实体。然后在该存储库中创建方法,如getUsersByRole,您可以使用查询构建器进行查询。
$ qb = $ this - > getEntityManager() - > createQueryBuilder();
$ qb-> select('u')
- > from('\\\
amespace\for\User','u')
- > join(' u.roles','r')
- > where(...)
return $ qb-> getQuery() - > getResult();
I have 3 simple tables: user, role, user_x_role with Many-To-Many relation. I have 2 entities: User and Role. User entity has $userRoles property with relation annotation. In Controller I need to fetch all users with specific role. But I don't know how to use JOIN in controller. Current wrong code:
$role = $this->getDoctrine()->getRepository('TestBackEndBundle:Role');
$roles = $role->findBy(array('name' => 'ROLE_PARTNER'));
$user = $this->getDoctrine()->getRepository('TestBackEndBundle:User');
$partners = $user->findBy(array('userRoles' => $roles));
It thows "Undefined index: joinColumns in ...". But I have joinColumns in User entity:
/**
* @ORM\ManyToMany(targetEntity="Role")
* @ORM\JoinTable(name="user_x_role",
* joinColumns={@ORM\JoinColumn(name="user_id", referencedColumnName="id", onDelete="CASCADE", onUpdate="CASCADE")},
* inverseJoinColumns={@ORM\JoinColumn(name="role_id", referencedColumnName="id", onDelete="CASCADE", onUpdate="CASCADE")}
* )
* @var ArrayCollection
*/
protected $userRoles;
IMO the best way for it is create your own repository for User entity. Then in that repository create method like "getUsersByRole" where you make the query you want with query builder.
$qb = $this->getEntityManager()->createQueryBuilder();
$qb->select('u')
->from('\namespace\for\User', 'u')
->join('u.roles', 'r')
->where(...)
return $qb->getQuery()->getResult();
这篇关于在Symfony2中使用JOIN标准查找的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!