src/Controller/WisdomController.php line 25

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\FAQ;
  6. use App\Entity\News;
  7. use App\Annotation\CmsComponent;
  8. use Doctrine\ORM\EntityManagerInterface;
  9. use Symfony\Component\HttpFoundation\Response;
  10. use Symfony\Component\Routing\Annotation\Route;
  11. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  13. class WisdomController extends AbstractController
  14. {
  15. public function __construct(private EntityManagerInterface $em)
  16. {
  17. }
  19. /**
  20. * @CmsComponent("Wisdom Component", active=true, routeName="embed_wisdom_component")
  21. *
  22. * @param mixed $request
  23. */
  24. #[Route('/wisdom', name: 'embed_wisdom_component')]
  25. public function index(): Response
  26. {
  27. $faq = $this->em->getRepository(FAQ::class)->findOneBy(['deleted' => false, 'active' => true, 'featured' => true], ['sortOrder' => 'ASC'], 1, 0);
  29. $news = $this->em->createQuery('SELECT e FROM App:News e WHERE e.deleted = 0 AND e.active = 1 AND e.publishDate <= :now AND e.featuredInWisdomComponent = 1 ORDER BY e.publishDate DESC')
  30. ->setParameter('now', new \DateTime())
  31. ->setMaxResults(1)
  32. ->getOneOrNullResult();
  34. if (! $faq && ! $news) {
  35. return new Response('');
  36. }
  38. return $this->render('@theme/wisdom/featured.html.twig', [
  39. 'faq' => $faq,
  40. 'news' => $news,
  41. ]);
  42. }
  43. }