I'm making a form that searches users by three parameters:
-Category -Subcategories (multiple choice) -Province
The user entity has a relation manyToOne with Categories, and ManyToMany with the other parameters. If I want to find only by categorie, I suppose that I have to use this code:
$users = $em->getRepository('CASUsuariosBundle:Artist')->findByCategory($category);
But how can I do it with the other parameters? Especially with subcategories, which is a multiple selection.
User entity:
/**
* @ORM\ManyToOne(targetEntity="\CAS\EventBundle\Entity\Category", inversedBy="artists")
* @ORM\JoinColumn(name="category_id", referencedColumnName="id")
*/
private $category;
/**
* @ORM\ManyToMany(targetEntity="\CAS\EventBundle\Entity\Subcategory", inversedBy="artists")
* @ORM\JoinTable(name="artists_subcategories",
* joinColumns={@ORM\JoinColumn(name="artist_id", referencedColumnName="id")},
* inverseJoinColumns={@ORM\JoinColumn(name="subcategory_id", referencedColumnName="id")}
* )
*/
private $subcategories;
/**
* @ORM\ManyToMany(targetEntity="\CAS\EventBundle\Entity\Province", inversedBy="artists")
* @ORM\JoinTable(name="artists_provinces",
* joinColumns={@ORM\JoinColumn(name="artist_id", referencedColumnName="id")},
* inverseJoinColumns={@ORM\JoinColumn(name="province_id", referencedColumnName="id")}
* )
*/
protected $provinces;
SearchController:
public function searchAction(Request $request) {
$search = new Search();
$em = $this->getDoctrine()->getManager();
$form = $this->createForm(new SearchType($this->getDoctrine()->getManager()), $search);
$form->setData($search);
$form->handleRequest($request);
if ($form->isValid() || $form->isSubmitted()) {
$category = $form->get('category')->getData();
$subcategories = $form->get('subcategories')->getData();
$province = $form->get('province')->getData();
return $this->showAction($category, $subcategories, $province);
}
return $this->render('CASUsuariosBundle:Profile:search.html.twig', array(
'form' => $form->createView()
));
}
public function showAction($category, $subcategories, $province) {
return $this->render('CASUsuariosBundle:Profile:search_results.html.twig');
}