public function findActiveEpisodes(Series $series, $query_only = false) { $query = $this->getEntityManager()->createQuery("SELECT e FROM AppBundle:Episode e\n WHERE e.series = :series_id\n AND (e.onlineStart < :online_start OR e.onlineStart IS NULL)\n AND e.isActive = 1")->setParameter('series_id', $series->getId())->setParameter('online_start', new \DateTime()); if ($query_only) { return $query; } return $query->getResult(); }
/** * Edits an existing Series entity. * * @Route("/{id}/edit", name="series_edit") * @Method("PUT|GET") */ public function updateAction(Request $request, Series $series) { $em = $this->getDoctrine()->getManager(); $deleteForm = $this->createDeleteForm($series->getId()); $editForm = $this->createForm(new SeriesType(), $series, array('action' => $this->generateUrl('series_edit', array('id' => $series->getId())), 'method' => 'PUT')); $editForm->add('submit', 'submit', array('label' => 'Update')); $editForm->handleRequest($request); if ($editForm->isValid()) { $em->flush(); return $this->redirect($this->generateUrl('series')); } return $this->render('AppBundle:Series:edit.html.twig', ['serie' => $series, 'edit_form' => $editForm->createView(), 'delete_form' => $deleteForm->createView()]); }