src/Repository/MenuTreeRepository.php line 31

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\MenuTree;
  6. use Doctrine\ORM\NonUniqueResultException;
  7. use Gedmo\Tree\Entity\Repository\NestedTreeRepository;
  9. /**
  10. * Class MenuTreeRepository
  11. * @package App\Repository
  12. *
  13. * @method MenuTree findOneBy(array $params)
  14. * @method MenuTree findOneByRoute(string $route)
  15. */
  16. class MenuTreeRepository extends NestedTreeRepository
  17. {
  18. /**
  19. * @param $route
  20. * @return mixed
  21. * @throws NonUniqueResultException
  22. */
  23. public function findOneLeafByRoute($route)
  24. {
  25. $queryBuilder = $this->createQueryBuilder('m');
  26. $queryBuilder->where('m.route = :rte')
  27. ->setParameter('rte', $route)
  28. ->andWhere('m.lft+1 = m.rgt')
  29. ->setMaxResults(1);
  31. return $queryBuilder->getQuery()->getOneOrNullResult();
  32. }
  34. /**
  35. * @param int|null $id
  36. * @return array
  37. */
  38. public function getTreeData(int $id = null)
  39. {
  40. $queryBuilder = $this->createQueryBuilder('m')
  41. ->select('m.id AS id_level, m.libelle AS label_level')
  42. ->orderBy('m.lft');
  44. if ($id) {
  45. $queryBuilder->where('m.parent = :id')
  46. ->setParameter('id', $id);
  47. } else {
  48. $queryBuilder->where('m.parent = 1');
  49. }
  51. $queryBuilder->addSelect('CASE WHEN m.lft + 1 = m.rgt THEN 0 ELSE 1 END AS folder');
  53. return $queryBuilder
  54. ->andWhere('m.root = 1')
  55. ->getQuery()
  56. ->useQueryCache(true)
  57. ->enableResultCache(60)
  58. ->getResult();
  59. }
  60. }