public function generateMailFromData(Mail $mail, Student $student)
 {
     $twig = new \Twig_Environment(new \Twig_Loader_Array(['mail.' . $mail->getId() => $mail->getContent()]), array('autoescape' => false));
     $subject = $mail->getSubject();
     $message = $this->_twig->render("@BdEMain/Mail/bde.html.twig", array('content' => $twig->render("mail." . $mail->getId(), array('student' => $student)), 'config' => array('title' => $mail->getSubject(), 'company' => "BdE INSA Lyon", 'student' => $student, 'mail_id' => $this->_crypt_data($mail->getId(), $student->getId())), 'why_this_mail' => ""));
     return ['subject' => $subject, 'body' => $message];
 }
 /**
  * @param Etudiant $etudiant
  * @return Bus
  */
 public function getBusForEtudiant(Etudiant $etudiant)
 {
     $qb = $this->createQueryBuilder('b');
     $qb->join('b.students', 'e', 'e.id = :e_id')->setParameter("e_id", $etudiant->getId());
     return $qb->getQuery()->getOneOrNullResult();
 }