1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| public function getCreneauAction(Request $request, $now, $nbjours, $mois, $annee) {
$em = $this->getDoctrine()->getManager();
$query = $em->createQuery("select periode.intitule "
. "from CupcakeFactory\siteBundle\Entity\Periode periode "
. "join CupcakeFactory\siteBundle\Entity\Livraison livraison "
. "where livraison.Periode=periode.id "
. "and livraison.dateReservee between '=?1' and '=?2-=?3-=?4' ");
$query->setParameter(1, $now);
$query->setParameter(2,$nbjours );
$query->setParameter(3,$mois );
$query->setParameter(4,$annee );
$result = $query->getResult();
return new Jsonresponse($result);
} |