src\Controller\RegimeController.php line 39

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\HttpFoundation\Response;
  7. use Symfony\Component\Routing\Annotation\Route;
  8. use Symfony\Component\HttpFoundation\Request;
  9. use Doctrine\ORM\EntityManagerInterface;
  10. use Knp\Component\Pager\PaginatorInterface;
  12. use App\Entity\Regime;
  13. use App\Entity\Menu;
  14. use App\Entity\Adapte;
  15. use App\Form\RegimeType;
  16. class RegimeController extends AbstractController
  17. {
  18. #[Route('/regime/liste', name: 'app_regime_liste')]
  19. public function liste(EntityManagerInterface $em, PaginatorInterface $paginator,Request $request): Response
  20. {
  21. if ($request->query->get('filterField') && $request->query->get('filterValue') && !is_numeric($request->query->get('filterValue'))) {
  22. $request->query->set('filterValue', "*".$request->query->get('filterValue')."*");
  23. }
  24. // On récupère tous les articles disponibles en base de données
  25. $query = $em->createQuery('SELECT regime FROM App\Entity\Regime regime');
  27. $pagination = $paginator->paginate(
  28. $query, /* query NOT result */
  29. $request->query->getInt('page', 1), /* page number */
  30. 10 /* limit per page */
  31. );
  33. return $this->render('regime/liste.html.twig', [
  34. 'pagination' => $pagination
  35. ]);
  36. }
  38. #[Route('/regime/index/{id}', name: 'app_regime_index')]
  39. public function index(EntityManagerInterface $em,PaginatorInterface $paginator, Request $request,int $id): Response
  40. {
  41. if ($request->query->get('filterField') && $request->query->get('filterValue') && !is_numeric($request->query->get('filterValue'))) {
  42. $request->query->set('filterValue', "*".$request->query->get('filterValue')."*");
  43. }
  44. // On récupère l'regime qui correspond à l'id passé dans l'url
  45. $regime = $em->getRepository(Regime::class)->findOneBy(['regime_id' => $id]);
  47. if (!$regime) {
  48. $this->addFlash('danger', 'Le regime n"existe pas');
  49. return $this->redirectToRoute('app_regime_liste');
  50. }
  52. $menus = $regime->getAdaptes()->map(function($adapte) {
  53. return $adapte->getMenuId();
  54. })->toArray();
  56. if ($menus){
  57. // On récupère tous les articles disponibles en base de données
  58. $queryBuilder = $em->createQueryBuilder()
  59. ->select('menu')
  60. ->from(Menu::class, 'menu')
  61. ->where('menu.menu_id NOT IN (:menus)')
  62. ->setParameter('menus', $menus);
  63. }
  64. else
  65. {
  66. // On récupère tous les articles disponibles en base de données
  67. $queryBuilder = $em->createQueryBuilder()
  68. ->select('menu')
  69. ->from(Menu::class, 'menu');
  70. }
  72. $prixMin = $request->query->get('prix_min');
  73. $prixMax = $request->query->get('prix_max');
  75. if ($prixMin !== null) {
  76. $queryBuilder->andWhere('menu.prix_par_personne >= :prixMin')
  77. ->setParameter('prixMin', $prixMin);
  78. }
  80. if ($prixMax !== null) {
  81. $queryBuilder->andWhere('menu.prix_par_personne <= :prixMax')
  82. ->setParameter('prixMax', $prixMax);
  83. }
  85. $query = $queryBuilder->getQuery();
  87. $pagination = $paginator->paginate(
  88. $query, /* query NOT result */
  89. $request->query->getInt('page', 1), /* page number */
  90. 10 /* limit per page */
  91. );
  93. return $this->render('regime/index.html.twig', [
  94. 'regime' => $regime,
  95. 'menus' => $menus,
  96. 'pagination' => $pagination,
  97. 'page' => $request->query->getInt('page', 1),
  98. 'sort'=> $request->query->get('sort', ''),
  99. 'direction'=> $request->query->get('direction', ''),
  100. 'filterField'=> $request->query->get('filterField', ''),
  101. 'filterValue'=> $request->query->get('filterValue', ''),
  102. 'prix_min' => $prixMin,
  103. 'prix_max' => $prixMax
  104. ]);
  105. }
  107. #[Route('/regime/add', name: 'app_regime_add')]
  108. public function add(EntityManagerInterface $em, Request $request): Response
  109. {
  110. $mode = 'new';
  111. $regime = new Regime();
  113. $form = $this->createForm(RegimeType::class, $regime);
  114. $form->handleRequest($request);
  116. if($form->isSubmitted() && $form->isValid()) {
  118. $this->saveregime($regime, $mode,$em);
  120. return $this->redirectToRoute('app_regime_index', ['id' => $regime->getRegimeId()]);
  121. }
  123. $parameters = array(
  124. 'form' => $form->createView(),
  125. 'regime' => $regime,
  126. 'mode' => $mode
  127. );
  129. return $this->render('regime/edit.html.twig', $parameters);
  130. }
  132. #[Route('/regime/edit/{id}', name: 'app_regime_edit')]
  133. public function edit(EntityManagerInterface $em, Request $request, int $id=null): Response
  134. {
  135. $mode = 'update';
  136. // On récupère l'regime qui correspond à l'id passé dans l'url
  137. $regime = $em->getRepository(regime::class)->findOneBy(['regime_id' => $id]);
  139. if (!$regime) {
  140. $this->addFlash('danger', 'Le regime n"existe pas');
  141. return $this->redirectToRoute('app_regime_liste');
  142. }
  144. $form = $this->createForm(RegimeType::class, $regime);
  145. $form->handleRequest($request);
  147. if($form->isSubmitted() && $form->isValid()) {
  149. $this->saveregime($regime, $mode,$em);
  151. return $this->redirectToRoute('app_regime_index', ['id' => $id]);
  152. }
  154. $parameters = array(
  155. 'form' => $form->createView(),
  156. 'regime' => $regime,
  157. 'mode' => $mode
  158. );
  160. return $this->render('regime/edit.html.twig', $parameters);
  161. }
  163. #[Route('/regime/remove/{id}', name: 'app_regime_remove')]
  164. public function remove(EntityManagerInterface $em, int $id): Response
  165. {
  166. // On récupère l'regime qui correspond à l'id passé dans l'URL
  167. $regime = $em->getRepository(regime::class)->findOneBy(['regime_id' => $id]);
  169. if (!$regime) {
  170. $this->addFlash('danger', 'L"regime n"existe pas');
  171. return $this->redirectToRoute('app_regime_liste');
  172. }
  173. // L'regime est supprimé
  174. $em->remove($regime);
  175. $em->flush();
  177. $this->addFlash('success', 'L"regime a été supprimé avec succès');
  179. return $this->redirectToRoute('app_regime_liste');
  180. }
  181. #[Route('/regime/menuadd/{idregime}/{idmenu}', name: 'app_regime_menuadd')]
  182. public function menuadd(EntityManagerInterface $em, int $idregime, int $idmenu): Response
  183. {
  184. // On récupère le regime qui correspond à l'id passé dans l'url
  185. $regime = $em->getRepository(regime::class)->findOneBy(['regime_id' => $idregime]);
  187. if (!$regime) {
  188. $this->addFlash('danger', 'Le regime n"existe pas');
  189. return $this->redirectToRoute('app_regime_liste');
  190. }
  192. $menu= $em->getRepository(Menu::class)->findOneBy(['menu_id' => $idmenu]);
  194. if (!$menu) {
  195. $this->addFlash('danger', 'Le menu n"existe pas');
  196. return $this->redirectToRoute('app_regime_index', ['id' => $idregime]);
  197. }
  199. $adapte= $menu->getAdapte();
  201. if ($adapte) {
  202. $adapte->setregimeId($regime);
  203. $em->persist($adapte);
  204. $em->flush();
  205. }
  206. else
  207. {
  208. $adapte = new Adapte();
  209. $adapte->setMenuId($menu);
  210. $adapte->setregimeId($regime);
  211. $regime->addAdapte($adapte);
  212. $em->persist($regime);
  213. $em->flush();
  214. }
  216. $this->addFlash('success', 'Le menu a été ajouté avec succès');
  218. return $this->redirectToRoute('app_regime_index', ['id' => $idregime]);
  219. }
  221. #[Route('/regime/menuremove/{idregime}/{idmenu}', name: 'app_regime_menuremove')]
  222. public function menuremove(EntityManagerInterface $em, int $idregime, int $idmenu): Response
  223. {
  224. // On récupère le regime qui correspond à l'id passé dans l'url
  225. $regime = $em->getRepository(Regime::class)->findOneBy(['regime_id' => $idregime]);
  227. if (!$regime) {
  228. $this->addFlash('danger', 'Le regime n"existe pas');
  229. return $this->redirectToRoute('app_regime_liste');
  230. }
  232. $menu= $em->getRepository(Menu::class)->findOneBy(['menu_id' => $idmenu]);
  234. if (!$menu) {
  235. $this->addFlash('danger', 'Le menu n"existe pas');
  236. return $this->redirectToRoute('app_regime_index', ['id' => $idregime]);
  237. }
  239. $adapte= $regime->getAdaptes()->filter(function($adapte) use ($idmenu) {
  240. return $adapte->getMenuId()->getMenuId() === $idmenu;
  241. })->first();
  243. if ($adapte) {
  244. $em->remove($adapte);
  245. $em->flush();
  246. }
  248. $this->addFlash('success', 'Le menu a été supprimé avec succès');
  250. return $this->redirectToRoute('app_regime_index', ['id' => $idregime]);
  251. }
  253. /**
  254. * Enregistrer un regime en base de données
  255. *
  256. * @param Regime $regime
  257. * @param string $mode
  258. */
  259. private function saveregime(Regime $regime, string $mode, EntityManagerInterface $em){
  261. $em->persist($regime);
  262. $em->flush();
  263. if($mode == 'new') {
  264. $this->addFlash('success', 'Le regime a été ajouté avec succès');
  265. } else {
  266. $this->addFlash('success', 'Le regime a été modifié avec succès');
  267. }
  268. }
  270. }