public static function absents($id)
{
$absents = DB::table('horaires')->join('absences', 'absences.horaire_id', '=', 'horaires.id')->join('etudiants', 'etudiants.id', '=', 'absences.etudiant_id')->where('horaires.id', '=', $id)->select('etudiants.id as id', 'etudiants.cne as cne', 'etudiants.cin as cin', 'etudiants.nom as nom', 'etudiants.prenom as prenom', 'etudiants.date_naissance as date_naissance', 'etudiants.photo as photo', 'etudiants.email as email', 'etudiants.password as password', 'etudiants.promo_id as promo_id', 'etudiants.admin_id as admin_id', 'etudiants.created_at as created_at', 'etudiants.updated_at as updated_at')->get();
$absents = Etudiant::hydrate($absents);
return $absents;
}
