src/Controller/ResourceController.php line 103

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Resource;
  6. use App\Form\ResourceType;
  7. use App\Annotation\CmsAdminDash;
  8. use App\Annotation\CmsComponent;
  9. use App\Entity\ResourceCategory;
  10. use App\Repository\ResourceRepository;
  11. use Doctrine\ORM\EntityManagerInterface;
  12. use Knp\Component\Pager\PaginatorInterface;
  13. use Symfony\Component\HttpFoundation\Request;
  14. use Symfony\Component\HttpFoundation\Response;
  15. use Symfony\Component\Routing\Annotation\Route;
  16. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  18. #[Route('/takeflight/resource')]
  19. class ResourceController extends AbstractController
  20. {
  21. /**
  22. * @CmsAdminDash("Resources", active=true, routeName="app_resource_index",icon="fa fa-file-text-o", menuPosition=10, parentRouteName="control_resource_category_index")
  23. */
  24. #[Route('/', name: 'app_resource_index', methods: ['GET'])]
  25. public function index(ResourceRepository $resourceRepository): Response
  26. {
  27. return $this->render('resource/index.html.twig', [
  28. 'resources' => $resourceRepository->findBy(['deleted' => false]),
  29. ]);
  30. }
  32. #[Route('/new', name: 'app_resource_new', methods: ['GET', 'POST'])]
  33. public function new(Request $request): Response
  34. {
  35. $resource = new Resource();
  36. $form = $this->createForm(ResourceType::class, $resource);
  37. $form->handleRequest($request);
  39. if ($form->isSubmitted() && $form->isValid()) {
  40. // REQUIRED IF USING UPLOAD FILE TRAIT
  41. $resource->uploadFile();
  42. $entityManager = $this->getDoctrine()->getManager();
  43. $entityManager->persist($resource);
  44. $entityManager->flush();
  46. return $this->redirectToRoute('app_resource_index', [], Response::HTTP_SEE_OTHER);
  47. }
  50. return $this->render('resource/new.html.twig', [
  51. 'resource' => $resource,
  52. 'form' => $form->createView(),
  53. ]);
  54. }
  56. #[Route('/{id}', name: 'app_resource_show', methods: ['GET'])]
  57. public function show(Resource $resource): Response
  58. {
  59. return $this->render('resource/show.html.twig', [
  60. 'resource' => $resource,
  61. ]);
  62. }
  64. #[Route('/{id}/edit', name: 'app_resource_edit', methods: ['GET', 'POST'])]
  65. public function edit(Request $request, Resource $resource): Response
  66. {
  67. $form = $this->createForm(ResourceType::class, $resource);
  68. $form->handleRequest($request);
  70. if ($form->isSubmitted() && $form->isValid()) {
  71. // REQUIRED IF USING UPLOAD FILE TRAIT
  72. $resource->uploadFile();
  73. $this->getDoctrine()->getManager()->flush();
  75. return $this->redirectToRoute('app_resource_index', [], Response::HTTP_SEE_OTHER);
  76. }
  78. return $this->render('resource/edit.html.twig', [
  79. 'resource' => $resource,
  80. 'form' => $form->createView(),
  81. ]);
  82. }
  84. #[Route('/{id}', name: 'app_resource_delete', methods: ['POST'])]
  85. public function delete(Request $request, Resource $resource): Response
  86. {
  87. if ($this->isCsrfTokenValid('delete'.$resource->getId(), $request->request->get('_token'))) {
  88. $entityManager = $this->getDoctrine()->getManager();
  89. $resource->setActive(false);
  90. $resource->setDeleted(true);
  91. $entityManager->persist($resource);
  92. $entityManager->flush();
  93. $this->addFlash('success', 'Success - Resource deleted');
  94. }
  96. return $this->redirectToRoute('app_resource_index', [], Response::HTTP_SEE_OTHER);
  97. }
  99. /**
  100. * @CmsComponent("Embed Resources", active=true, routeName="embed_resources")
  101. */
  102. #[Route(path: '/pcgc-resources', name: 'embed_resources')]
  103. public function embedResources(Request $request, EntityManagerInterface $em, PaginatorInterface $paginator): Response
  104. {
  105. $category = null;
  106. $perpage = 12;
  108. $query = $em->createQueryBuilder('e')
  109. ->select('e')
  110. ->from(Resource::class, 'e')
  111. ->where('e.deleted = 0')
  112. ->andWhere('e.active = 1')
  113. ->orderBy('e.sortOrder', 'ASC');
  115. $categoryIds = $this->sanitiseCategoryIds($request);
  117. if ($categoryIds) {
  118. $query
  119. ->andWhere('e.category IN (:categories)')
  120. ->setParameter('categories', $categoryIds);
  121. }
  123. $searchParam = $request->query->get('search', null);
  125. if ($searchParam !== null) {
  126. $query
  127. ->andWhere('e.title LIKE :search OR e.content LIKE :search OR e.file LIKE :search')
  128. ->setParameter('search', '%'.$searchParam.'%')
  129. ;
  130. }
  132. $paginatedResources = $paginator->paginate($query, $request->query->getInt('page', 1), $perpage);
  134. return $this->render('@theme/resource/index.html.twig', [
  135. 'resources' => $paginatedResources,
  136. 'category' => $category,
  137. 'categoryIds' => $categoryIds,
  138. 'searchParam' => $searchParam,
  139. ]);
  140. }
  142. /**
  143. * @CmsComponent("Embed Resources Filters", active=true, routeName="embed_resources_filters")
  144. */
  145. #[Route(path: '/pcgc-resources-filters', name: 'embed_resources_filters')]
  146. public function embedResourceFilters(Request $request, EntityManagerInterface $em): Response
  147. {
  148. $categoryIds = $this->sanitiseCategoryIds($request);
  149. $searchParam = $request->query->get('search', null);
  151. $categories = $em->getRepository(ResourceCategory::class)->findBy(['deleted' => false, 'active' => true], ['sortOrder' => 'ASC']);
  153. return $this->render('@theme/resource/filters.html.twig', [
  154. 'categories' => $categories,
  155. 'categoryIds' => $categoryIds,
  156. 'searchParam' => $searchParam,
  157. ]);
  158. }
  160. private function sanitiseCategoryIds(Request $request): array
  161. {
  162. $categoryIds = $request->query->get('category', []);
  164. // check if categoryIds is an array and only contains numeric values
  165. if (!is_array($categoryIds) || array_filter($categoryIds, 'is_numeric') !== $categoryIds) {
  166. $categoryIds = [];
  167. }
  169. return $categoryIds;
  170. }
  171. }