App\Guests\Repository\WatchedMovieRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	24
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Test Coverage

Coverage

0%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	getAllWatchedMoviesByGuestSessionId()	0	16	1

<?php

declare(strict_types=1);

namespace App\Guests\Repository;

use App\Guests\Entity\GuestWatchedMovie;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\ORM\Query;
use Symfony\Bridge\Doctrine\RegistryInterface;

/**
 * @method GuestWatchedMovie|null find($id, $lockMode = null, $lockVersion = null)
 * @method GuestWatchedMovie|null findOneBy(array $criteria, array $orderBy = null)
 * @method GuestWatchedMovie[]    findAll()
 * @method GuestWatchedMovie[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
 */
class WatchedMovieRepository extends ServiceEntityRepository
{
    public function __construct(RegistryInterface $registry)
    {
        parent::__construct($registry, GuestWatchedMovie::class);
    }

    public function getAllWatchedMoviesByGuestSessionId(int $guestSessionId): Query
    {
        return $this->createQueryBuilder('wm')
            ->leftJoin('wm.movie', 'm')
            ->addSelect('m')
            ->leftJoin('m.translations', 'mt')
            ->addSelect('mt')
            ->leftJoin('m.genres', 'mg')
            ->addSelect('mg')
            ->leftJoin('mg.translations', 'mgt')
            ->addSelect('mgt')
            ->where('wm.guestSession = :guestSessionId')
            ->setParameter('guestSessionId', $guestSessionId)
            ->addOrderBy('wm.id', 'DESC')
            ->getQuery();
    }
}