films-symfony-4-2/src/Repository/RealisateurRepository.php

<?php

namespace App\Repository;

/**
 * RealisateurRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class RealisateurRepository extends \Doctrine\ORM\EntityRepository
{
    public function findByNom($nom)
    {
        $qb = $this->createQueryBuilder ('r');
        $expr = $qb->expr();
        $query = $qb
            ->select('r.id', 'r.nom', 'r.prenom')
            ->where(
                $expr->like('r.nom', ':nom'))
            ->setParameter('nom', $nom.'%')
            ->getQuery();
            
        return $query->getResult();
    }

    public function findByNomComplet($nomComplet)
    {
        $qb = $this->createQueryBuilder ('r');
        $expr = $qb->expr();
        $tableau = explode(' ', $nomComplet);

        if (count($tableau) == 1) {
            $premier = $tableau[0];
            $orPremier = $expr->orX(
                $expr->like('r.nom', ':premier'),
                $expr->like('r.prenom', ':premier')
            );
            $andExpression = $expr->andX($orPremier);
            $qb->setParameter('premier', $premier.'%');
        }

        if (count($tableau) > 1) {
            $premier = $tableau[0];
            $deuxieme = $tableau[1];

            $orPremier = $expr->orX(
                $expr->eq('r.nom', ':premier'),
                $expr->eq('r.prenom', ':premier')
            );

            $orDeuxieme = $expr->orX(
                $expr->like('r.nom', ':deuxieme'),
                $expr->like('r.prenom', ':deuxieme')
            );

            $andExpression = $expr->andX($orPremier, $orDeuxieme);

            $qb
                ->setParameter('premier', $premier)
                ->setParameter('deuxieme', $deuxieme.'%');
        }

        $query = $qb
            ->select('r.id', 'r.nom', 'r.prenom')
            ->where($andExpression)
            ->getQuery();

        return $query->getResult();
    }

    public function findNomsComplets ()
    {
        $qb = $this->createQueryBuilder('r');
        $query = $qb
            ->select('r.nomComplet')
            ->getQuery();

        return $query->getArrayResult();
    }
}