$sql = "
            SELECT
                resa.id idresa,resa.date,resa.dateAdd,resa.dateUpdate,resa.modePaiement,resa.nombreCouverts,resa.nombreCouvertsReels,resa.statut,resa.idContact,resa.notes,
                de.idClient,cli.nom as clinom,cli.prenom as clipnom,cli.raisonSociale as clirs,cli.statut as clistat,
                resa.idHoraireService,hs.heureDebut as horaire,
                hs.idService,se.nom as service,
                se.idSalle,sa.libelle as salle,
                sa.idER,er.libelle as espace,
                resa.idFormule
            FROM
                PoteletchabotClientBundle:Reservation resa,
                PoteletchabotClientBundle:DossierEvenement de,
                PoteletchabotUserBundle:Client cli,
                PoteletchabotEventBundle:HoraireService hs,
                PoteletchabotEventBundle:Service se,
                PoteletchabotEventBundle:Salle sa,
                PoteletchabotEventBundle:EspaceRestauration er,


            WHERE
                de.id = resa.idDossier
                AND cli.id = de.idClient
                AND resa.idHoraireService = hs.id
                AND resa.isActive = 1
                AND hs.idService = se.id
                AND se.idSalle = sa.id
                AND sa.idER = er.id ".
                ($idEvenement ? " AND de.idEvenement = $idEvenement " : "") .
                ($nomClient ? " AND (cli.raisonSociale LIKE '%$nomClient%' OR cli.nom LIKE '%$nomClient%' OR cli.prenom LIKE '%$nomClient%') " : "") .
                ($libelleSalle ? " AND sa.libelle LIKE '%$libelleSalle%' " : "") .
                ($horraire ? " AND hs.heureDebut = '$horraire'  " : "") .
                ($dateInferieur ? " AND resa.date >= :dateinferieur " : "") .
                ($dateSuperieur ? " AND resa.date <= :datesuperieur   " : "") .
                //($contactRN ? " AND cont.nom LIKE :contactRN " : " ") .
            "
            ORDER BY espace, salle, service, horaire, clirs, clinom ASC
        ";

        $requete_sql = $em->createQuery($sql)
                            ->setParameters(array(
                                'datesuperieur' => $dateSuperieur,
                                'dateinferieur' => $dateInferieur,
                               // 'contactRN' => "%" . $contactRN . "%",
                                ));
        $resultats = $requete_sql->getResult();