App\Movies\Repository\MovieActorRepository

Complexity

Total Complexity

4

Size/Duplication

Total Lines	40
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Test Coverage

Coverage

37.04%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	findAllByMovie()	0	9	1
A	findAllByActor()	0	22	2

<?php

declare(strict_types=1);

namespace App\Movies\Repository;

use App\Movies\Entity\MovieActor;
use App\Users\Entity\User;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\ORM\Query;
use Symfony\Bridge\Doctrine\RegistryInterface;

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

    public function findAllByMovie(int $movieId): Query
    {
        return $this->createQueryBuilder('ma')
            ->leftJoin('ma.actor', 'a')
            ->addSelect('a')
            ->where('ma.movie = :movieId')
            ->setParameter('movieId', $movieId)
            ->getQuery();
    }

    public function findAllByActor(int $actorId, ?User $user = null): Query
    {
        $qb = $this->createQueryBuilder('ma')
            ->leftJoin('ma.movie', 'm')
            ->addSelect('m')
            ->leftJoin('m.translations', 'mt')
            ->addSelect('mt')
            ->leftJoin('m.genres', 'mg')
            ->addSelect('mg')
            ->leftJoin('mg.translations', 'mgt')
            ->addSelect('mgt');

        if ($user !== null) {
            $qb->leftJoin('m.userWatchedMovie', 'uwm', 'WITH', 'uwm.movie = ma.movie AND uwm.user = :user_id')
                ->addSelect('uwm')
                ->setParameter('user_id', $user->getId());
        }

        return $qb->where('ma.actor = :actorId')
            ->setParameter('actorId', $actorId)
            ->getQuery();
    }
}