src/Repository/CategoryRepository.php line 64

  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Category;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Persistence\ManagerRegistry;
  8. use PhpOffice\PhpSpreadsheet\Calculation\LookupRef\Offset;
  9. use Doctrine\ORM\Tools\Pagination\Paginator;
  12. /**
  13.  * @extends ServiceEntityRepository<Category>
  14.  *
  15.  * @method Category|null find($id, $lockMode = null, $lockVersion = null)
  16.  * @method Category|null findOneBy(array $criteria, array $orderBy = null)
  17.  * @method Category[]    findAll()
  18.  * @method Category[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  19.  */
  20. class CategoryRepository extends ServiceEntityRepository
  21. {
  22.     public function __construct(ManagerRegistry $registry)
  23.     {
  24.         parent::__construct($registry, Category::class);
  25.     }
  27.     public function save(Category $entity, bool $flush = false): void
  28.     {
  29.         $this->getEntityManager()->persist($entity);
  31.         if ($flush) {
  32.             $this->getEntityManager()->flush();
  33.         }
  34.     }
  36.     public function remove(Category $entity, bool $flush = false): void
  37.     {
  38.         $this->getEntityManager()->remove($entity);
  40.         if ($flush) {
  41.             $this->getEntityManager()->flush();
  42.         }
  43.     }
  45.     public function getPaginatedCategories(int $offset) : Paginator{
  47.         $query = $this->createQueryBuilder('c')
  48.                         ->setMaxResults(10)
  49.                         ->setFirstResult($offset)
  50.                         ->getQuery();
  52.         return new Paginator($query);
  54.     }
  56.     public function getTotalCount(int $catgeoryId): int
  57.     {
  58.         return $this->createQueryBuilder('c')
  59.                         ->select('COUNT(p.id)')
  60.                         ->join('c.products','p')
  61.                         ->where('c.id = :categoryId')
  62.                         ->setParameter('categoryId',$catgeoryId)
  63.                         ->getQuery()
  64.                         ->getSingleScalarResult();
  65.     }
  66.     
  68. //    /**
  69. //     * @return Category[] Returns an array of Category objects
  70. //     */
  71. //    public function findByExampleField($value): array
  72. //    {
  73. //        return $this->createQueryBuilder('c')
  74. //            ->andWhere('c.exampleField = :val')
  75. //            ->setParameter('val', $value)
  76. //            ->orderBy('c.id', 'ASC')
  77. //            ->setMaxResults(10)
  78. //            ->getQuery()
  79. //            ->getResult()
  80. //        ;
  81. //    }
  83. //    public function findOneBySomeField($value): ?Category
  84. //    {
  85. //        return $this->createQueryBuilder('c')
  86. //            ->andWhere('c.exampleField = :val')
  87. //            ->setParameter('val', $value)
  88. //            ->getQuery()
  89. //            ->getOneOrNullResult()
  90. //        ;
  91. //    }
  92. }