1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
| public function rechercherAction()
{
$request = $this->container->get('request');
if($request->isXmlHttpRequest())
{
$motcle = '';
$motcle = $request->request->get('motcle');
$em = $this->container->get('doctrine')->getEntityManager();
if($motcle != '')
{
$qb = $em->createQueryBuilder();
$qb->select('a')
->from('MyAppFilmothequeBundle:Acteur', 'a')
->where("a.nom LIKE :motcle OR a.prenom LIKE :motcle")
->orderBy('a.nom', 'ASC')
->setParameter('motcle', '%'.$motcle.'%');
$query = $qb->getQuery();
$acteurs = $query->getResult();
}
else {
$acteurs = $em->getRepository('MyAppFilmothequeBundle:Acteur')->findAll();
}
return $this->container-
>get('templating')->renderResponse('MyAppFilmothequeBundle:Acteur:liste.html.twig', array(
'acteurs' => $acteurs
));
}
else {
return $this->listerAction();
}
} |
