src/Dao/Offer/FavouriteOfferDao.php line 19

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace Slivki\Dao\Offer;
  7. use Doctrine\DBAL\Connection;
  8. use Doctrine\DBAL\Types\Types;
  10. final class FavouriteOfferDao implements FavouriteOfferDaoInterface
  11. {
  12.     private Connection $connection;
  14.     public function __construct(Connection $connection)
  15.     {
  16.         $this->connection = $connection;
  17.     }
  19.     public function getUsersWithOfferInFavouritesCount(int $offerId): int
  20.     {
  21.         $qb = $this->connection->createQueryBuilder();
  22.         $expr = $qb->expr();
  24.         return $qb
  25.             ->addSelect('count(distinct fo.user_id)')
  26.             ->from('favourite_offer', 'fo')
  27.             ->andWhere($expr->eq('fo.offer_id', ':offerId'))
  28.             ->setParameter('offerId', $offerId, Types::INTEGER)
  29.             ->execute()
  30.             ->fetchOne();
  31.     }
  32. }