src/Repository/ReviewsRepository.php line 46

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Reviews;
  6. use App\Entity\User;
  7. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  8. use Doctrine\Persistence\ManagerRegistry;
  10. /**
  11.  * @method Reviews|null find($id, $lockMode = null, $lockVersion = null)
  12.  * @method Reviews|null findOneBy(array $criteria, array $orderBy = null)
  13.  * @method Reviews[]    findAll()
  14.  * @method Reviews[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  15.  */
  16. class ReviewsRepository extends ServiceEntityRepository
  17. {
  18.     public function __construct(ManagerRegistry $registry)
  19.     {
  20.         parent::__construct($registry, Reviews::class);
  21.     }
  23.     public function findFirstYearOfReview($user) {
  24.         return $this->createQueryBuilder('r')
  25.             ->andWhere('r.user = :user') 
  26.             ->setParameter('user', $user)
  27.             ->orderBy('r.created_at', 'ASC')
  28.             ->getQuery()
  29.             ->setMaxResults(1)
  30.             ->getResult()
  31.         ;
  32.     }
  34.     public function findLastThirtyDaysReviews($user){
  35.         return $this->createQueryBuilder('r')
  36.             ->andWhere('r.user = :user')
  37.             ->andWhere('r.created_at > :m_date')
  38.             ->setParameter('user', $user)
  39.             ->setParameter('m_date', new \DateTime('-30 days'))
  40.             ->orderBy('r.created_at', 'DESC')
  41.             ->getQuery()
  42.             ->getResult()
  43.         ;
  44.     }
  46.     public function findAdminReviewsFilter($dateFilter = null, $admin){
  47.         if($dateFilter !== null){
  48.             return $this->createQueryBuilder('r')
  49.                 ->innerJoin('r.user', 'u')
  50.                 ->andWhere('u.owner = :admin')
  51.                 ->andWhere('r.created_at >= :m_date')
  52.                 ->setParameter('admin', $admin)
  53.                 ->setParameter('m_date', new \DateTime($dateFilter))
  54.                 ->orderBy('r.created_at', 'DESC')
  55.                 ->getQuery()
  56.                 ->getResult()
  57.             ;
  58.         }else{
  59.             return $this->createQueryBuilder('r')
  60.                 ->innerJoin('r.user', 'u')
  61.                 ->andWhere('u.owner = :admin')
  62.                 ->andWhere('r.created_at >= :m_date')
  63.                 ->setParameter('admin', $admin)
  64.                 ->setParameter('m_date', new \DateTime('-24 hours'))
  65.                 ->orderBy('r.created_at', 'DESC')
  66.                 ->getQuery()
  67.                 ->getResult()
  68.             ;
  69.         }
  70.     }
  72.     public function findProfessionalsReviews($admin){
  73.         return $this->createQueryBuilder('r')
  74.             ->innerJoin('r.user', 'u')
  75.             ->andWhere('u.owner = :admin')
  76.             ->setParameter('admin', $admin)
  77.             ->orderBy('r.created_at', 'DESC')
  78.             ->setMaxResults(10)
  79.             ->getQuery()
  80.             ->getResult()
  81.         ;
  82.     }
  84.     public function findTopReviewsOfTheMonth($user, $date)
  85.     {
  86.         return $this->createQueryBuilder('r') 
  87.             ->andWhere('r.user = :user')
  88.             ->andWhere('MONTH(r.created_at) = :month')
  89.             ->andWhere('YEAR(r.created_at) = :year') 
  90.             ->setParameter('month', $date['month'])
  91.             ->setParameter('year', $date['year'])
  92.             ->setParameter('user', $user)
  93.             ->orderBy('r.star_rating', 'DESC') 
  94.             ->getQuery()
  95.             ->getResult()
  96.         ;
  97.     }
  99.     public function findConcernedProfessionals(string $dateFilter = null, User $current_user)
  100.     {
  101.         if($dateFilter !== null){
  103.             return $this->createQueryBuilder('r')
  104.                 ->innerJoin('r.user', 'u')
  105.                 ->andWhere('u.owner = :user')
  106.                 ->andWhere('r.created_at > :date')
  107.                 ->setParameter('user', $current_user)
  108.                 ->setParameter('date', new \DateTime($dateFilter))
  109.                 ->orderBy('r.created_at', 'DESC')
  110.                 ->getQuery()
  111.                 ->getResult()
  112.             ;
  114.         }else{
  116.             return $this->createQueryBuilder('u')
  117.                 ->orderBy('r.created_at', 'DESC')
  118.                 ->getQuery()
  119.                 ->getResult()
  120.             ;
  122.         }
  124.     }
  126.     // /**
  127.     //  * @return Reviews[] Returns an array of Reviews objects
  128.     //  */
  129.     /*
  130.     public function findByExampleField($value)
  131.     {
  132.         return $this->createQueryBuilder('r')
  133.             ->andWhere('r.exampleField = :val')
  134.             ->setParameter('val', $value)
  135.             ->orderBy('r.id', 'ASC')
  136.             ->setMaxResults(10)
  137.             ->getQuery()
  138.             ->getResult()
  139.         ;
  140.     }
  141.     */
  143.     /*
  144.     public function findOneBySomeField($value): ?Reviews
  145.     {
  146.         return $this->createQueryBuilder('r')
  147.             ->andWhere('r.exampleField = :val')
  148.             ->setParameter('val', $value)
  149.             ->getQuery()
  150.             ->getOneOrNullResult()
  151.         ;
  152.     }
  153.     */
  154. }