<?php

namespace App\Repository;

use Doctrine\ORM\EntityRepository;

/**
 * LecturerTeachingLanguageRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class LecturerTeachingLanguageRepository extends EntityRepository
{
    public function findAll(): array
    {
//        parent::findAll();

        return $this->getEntityManager()
                        ->createQuery(
                            "SELECT ltl
                                    FROM App:LecturerTeachingLanguage ltl
                                    INNER JOIN ltl.lecturer l
                                    LEFT JOIN l.department d                                                                      
                                ORDER BY ltl.lecturer"
                        )
                        ->getResult();
    }

    public function deleteAll()
    {
        return $this->getEntityManager()
            ->createQuery(
                "DELETE App:LecturerTeachingLanguage l"
            )
            ->execute();
    }
}