src/Domain/Repository/TeamRepository.php line 28

Open in your IDE?
  1. <?php
  3. declare(strict_types = 1);
  5. namespace App\Domain\Repository;
  7. use App\Domain\Entity\Team;
  8. use App\Domain\Repository\Interfaces\TeamRepositoryInterface;
  9. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  10. use Doctrine\Persistence\ManagerRegistry;
  12. class TeamRepository extends ServiceEntityRepository implements TeamRepositoryInterface
  13. {
  14.     public function __construct(ManagerRegistry $registry)
  15.     {
  16.         parent::__construct($registry, Team::class);
  17.     }
  19.     public function findTeams()
  20.     {
  21.         return $this->createQueryBuilder('t')
  22.             ->select('t.name memberName, t.tel memberPhone, t.email memberEmail, t.fonction, t.content memberContent, p.path, tc.content categoryContent, tc.name categoryName')
  23.             ->leftJoin('t.teamCategory', 'tc')
  24.             ->leftJoin('t.picture', 'p')
  25.             ->where('t.active = true')
  26.             ->orderBy('categoryName')
  27.             ->getQuery()
  28.             ->getResult();
  29.     }
  30. }