1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| public function findEtudiantPasPointer($em, $idCours, $idDate, $idCreneau)
{
$query = $em->createQuery("
SELECT u.nomUtilisateur, u.prenomUtilisateur, u.id AS ec_id
FROM App\Entity\EtudiantCours ec
LEFT JOIN App\Entity\Pointage po WITH ec.etudiant = po.utilisateurEtudiant
JOIN App\Entity\Utilisateur u WITH po.utilisateurEtudiant = u.id
JOIN App\Entity\CoursPlanning cp WITH po.cours = cp.id
WHERE cp.cours = :idCours
AND cp.plageHoraire = :idCreneau
AND cp.dateCours = :idDate
")
->setParameter('idCours', $idCours)
->setParameter('idDate', $idDate)
->setParameter('idCreneau', $idCreneau);
$result = $query->getResult();
return $result;
} |
Partager