src/Controller/ChildsController.php line 243

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Childs; 
  6. use App\Form\ChildsFormType;
  7. use App\Repository\ChildsRepository;
  8. use App\Repository\SessionsRepository;
  9. use Doctrine\ORM\EntityManagerInterface;
  10. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  11. use Symfony\Component\HttpFoundation\Response;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Component\Routing\Annotation\Route;
  14. use Symfony\Component\Validator\Validator\ValidatorInterface;
  15. use Symfony\Component\Security\Core\Security;
  16. use Knp\Component\Pager\PaginatorInterface;
  17. use Symfony\Component\Mailer\MailerInterface;
  18. use Symfony\Component\Mime\Email;
  19. use Monolog\DateTimeImmutable;
  21. class ChildsController extends AbstractController
  22. {
  23.     private $em;
  24.     private $childsRepository;
  25.     private $security;
  27.     public function __construct(ChildsRepository $childsRepository, EntityManagerInterface $em, Security $security, SessionsRepository $sessionsRepository)
  28.     {
  29.         $this->childsRepository = $childsRepository;
  30.         $this->sessionsRepository = $sessionsRepository;
  31.         $this->em = $em;
  32.         $this->security = $security;
  33.     }
  35.     #[Route('/childs', name: 'app_childs')]
  36.     public function index(Request $request, PaginatorInterface $paginator): Response
  37.     {
  38.         $current_user = $this->security->getUser(); 
  40.         $assigned_childs = array();
  41.         foreach ($current_user->getChilds() as $value) {
  42.             $assigned_childs[] = $value;
  43.         }  
  45.         $filter         = $request->query->get('filter');
  46.         $status         = $request->query->get('status');
  47.         $search_term    = $request->query->get('q');
  49.         //if( !empty($assigned_childs) ){
  50.         if( isset($current_user->getRoles()[0]) && $current_user->getRoles()[0] == 'ROLE_STAKEHOLDER' ){
  51.             
  52.             $queryBuilder = $this->childsRepository->findByUser($current_user->getId(), $filter, $search_term, $status);
  53.         }else{ 
  55.             if( !empty($filter) ){
  57.                 $queryBuilder = $this->childsRepository->findAllFilter($filter, $search_term, $status);
  58.             }else{ 
  60.                 $queryBuilder = $this->childsRepository->findAll($search_term, $status);
  61.             }
  62.         } 
  63.         
  64.         $pagination = $paginator->paginate(
  65.             $queryBuilder, /* query NOT result */
  66.             $request->query->getInt('page', 1)/*page number*/,
  67.             10/*limit per page*/
  68.         );
  70.         return $this->render('childs/index.html.twig', [
  71.             'pagination'    => $pagination,
  72.             'filter'        => $filter,
  73.             'status'        => $status,
  74.             'search_term'   => $search_term,
  75.         ]);
  76.     }
  78.     #[Route('/notcheck', name: 'app_notcheck')]
  79.     public function notcheck(Request $request, PaginatorInterface $paginator): Response
  80.     {
  81.         $current_user = $this->security->getUser(); 
  83.         $assigned_childs = array();
  84.         foreach ($current_user->getChilds() as $value) {
  85.             $assigned_childs[] = $value;
  86.         }  
  88.         $filter         = $request->query->get('filter');
  89.         $status         = $request->query->get('status');
  90.         $search_term    = $request->query->get('q');
  92.         //if( !empty($assigned_childs) ){
  93.         if( isset($current_user->getRoles()[0]) && $current_user->getRoles()[0] == 'ROLE_STAKEHOLDER' ){
  94.             
  95.             return $this->redirectToRoute('app_childs');
  96.         }else{ 
  98.             if( !empty($filter) ){
  100.                 $queryBuilder = $this->childsRepository->findAllFilter($filter, $search_term, $status);
  101.             }else{ 
  103.                 $queryBuilder = $this->childsRepository->findAllNotCheck($search_term, $status);
  104.             }
  105.         } 
  106.         
  107.         $pagination = $paginator->paginate(
  108.             $queryBuilder, /* query NOT result */
  109.             $request->query->getInt('page', 1)/*page number*/,
  110.             10/*limit per page*/
  111.         );
  113.         return $this->render('childs/notcheck.html.twig', [
  114.             'pagination'    => $pagination,
  115.             'filter'        => $filter,
  116.             'status'        => $status,
  117.             'search_term'   => $search_term,
  118.         ]);
  119.     }
  121.     #[Route('/childs/create', name: 'create_childs')]
  122.     public function create(Request $request): Response
  123.     { 
  125.         $childs = new Childs();
  126.         $form = $this->createForm(ChildsFormType::class, $childs);
  127.         
  128.         $form->handleRequest($request);
  130.         if ( $form->isSubmitted() && $form->isValid() ) {
  132.             $newChilds = $form->getData(); 
  133.             $imagePath = $form->get('image')->getData();
  134.             $fileone = $form->get('fileone')->getData();
  135.             $filetwo = $form->get('filetwo')->getData();
  136.             $filethree = $form->get('filethree')->getData();
  138.             if( $imagePath ){
  140.                 $newFileName = uniqid() . '.' . $imagePath->guessExtension();
  142.                 try {
  143.                     $imagePath->move(
  144.                         $this->getParameter('kernel.project_dir') . '/public/uploads',
  145.                         $newFileName
  146.                     );
  147.                 } catch (FileException $e) {
  148.                     return new Response($e->getMessage());
  149.                 }
  151.                 $newChilds->setImage('uploads/' . $newFileName);
  152.             }
  154.             if( $fileone ){
  156.                 $fileone_path = array(); 
  158.                 foreach( $fileone as $fileone_single ){ 
  160.                     $fileonename = uniqid() . '.' . $fileone_single->guessExtension();
  162.                     try {
  163.                         $fileone_single->move(
  164.                             $this->getParameter('kernel.project_dir') . '/public/uploads/childfiles',
  165.                             $fileonename
  166.                         );
  167.                     } catch (FileException $e) {
  168.                         return new Response($e->getMessage());
  169.                     }
  171.                     $fileone_path[] = 'uploads/childfiles/' . $fileonename;
  173.                 } 
  174.                 
  175.                 $newChilds->setFileone($fileone_path);
  176.             }
  178.             if( $filetwo ){
  180.                 $filetwo_path = array(); 
  182.                 foreach( $filetwo as $filetwo_single ){ 
  184.                     $filetwoname = uniqid() . '.' . $filetwo_single->guessExtension();
  186.                     try {
  187.                         $filetwo_single->move(
  188.                             $this->getParameter('kernel.project_dir') . '/public/uploads/childfiles',
  189.                             $filetwoname
  190.                         );
  191.                     } catch (FileException $e) {
  192.                         return new Response($e->getMessage());
  193.                     }
  195.                     $filetwo_path[] = 'uploads/childfiles/' . $filetwoname;
  197.                 } 
  198.                 
  199.                 $newChilds->setFiletwo($filetwo_path);
  200.             }
  202.             if( $filethree ){
  204.                 $filethree_path = array(); 
  206.                 foreach( $filethree as $filethree_single ){ 
  208.                     $filethreename = uniqid() . '.' . $filethree_single->guessExtension();
  210.                     try {
  211.                         $filethree_single->move(
  212.                             $this->getParameter('kernel.project_dir') . '/public/uploads/childfiles',
  213.                             $filethreename
  214.                         );
  215.                     } catch (FileException $e) {
  216.                         return new Response($e->getMessage());
  217.                     }
  219.                     $filethree_path[] = 'uploads/childfiles/' . $filethreename;
  221.                 } 
  222.                 
  223.                 $newChilds->setFilethree($filethree_path);
  224.             }
  226.             $current_datetime = new DateTimeImmutable('now');
  227.             $newChilds->setCreationdate($current_datetime);
  228.             $newChilds->setSessionsemail(0);
  230.             $this->em->persist($newChilds);
  231.             $this->em->flush();
  233.             return $this->redirectToRoute('childs');
  234.         }
  236.         return $this->render('childs/create.html.twig', [
  237.             'form' => $form->createView()
  238.         ]);
  239.     }
  241.     // For without login
  242.     #[Route('/childs/inscription', name: 'inscription_childs')]
  243.     public function inscription(Request $request): Response
  244.     { 
  246.         $childs = new Childs();
  247.         $form = $this->createForm(ChildsFormType::class, $childs);
  248.         
  249.         $form->handleRequest($request);
  251.         if ( $form->isSubmitted() && $form->isValid() ) {
  253.             $newChilds = $form->getData(); 
  254.             $imagePath = $form->get('image')->getData();
  255.             $fileone = $form->get('fileone')->getData();
  256.             $filetwo = $form->get('filetwo')->getData();
  257.             $filethree = $form->get('filethree')->getData();
  259.             if( $imagePath ){
  261.                 $newFileName = uniqid() . '.' . $imagePath->guessExtension();
  263.                 try {
  264.                     $imagePath->move(
  265.                         $this->getParameter('kernel.project_dir') . '/public/uploads',
  266.                         $newFileName
  267.                     );
  268.                 } catch (FileException $e) {
  269.                     return new Response($e->getMessage());
  270.                 }
  272.                 $newChilds->setImage('uploads/' . $newFileName);
  273.             }
  275.             if( $fileone ){
  277.                 $fileone_path = array(); 
  279.                 foreach( $fileone as $fileone_single ){ 
  281.                     $fileonename = uniqid() . '.' . $fileone_single->guessExtension();
  283.                     try {
  284.                         $fileone_single->move(
  285.                             $this->getParameter('kernel.project_dir') . '/public/uploads/childfiles',
  286.                             $fileonename
  287.                         );
  288.                     } catch (FileException $e) {
  289.                         return new Response($e->getMessage());
  290.                     }
  292.                     $fileone_path[] = 'uploads/childfiles/' . $fileonename;
  294.                 } 
  295.                 
  296.                 $newChilds->setFileone($fileone_path);
  297.             }
  299.             if( $filetwo ){
  301.                 $filetwo_path = array(); 
  303.                 foreach( $filetwo as $filetwo_single ){ 
  305.                     $filetwoname = uniqid() . '.' . $filetwo_single->guessExtension();
  307.                     try {
  308.                         $filetwo_single->move(
  309.                             $this->getParameter('kernel.project_dir') . '/public/uploads/childfiles',
  310.                             $filetwoname
  311.                         );
  312.                     } catch (FileException $e) {
  313.                         return new Response($e->getMessage());
  314.                     }
  316.                     $filetwo_path[] = 'uploads/childfiles/' . $filetwoname;
  318.                 } 
  319.                 
  320.                 $newChilds->setFiletwo($filetwo_path);
  321.             }
  323.             if( $filethree ){
  325.                 $filethree_path = array(); 
  327.                 foreach( $filethree as $filethree_single ){ 
  329.                     $filethreename = uniqid() . '.' . $filethree_single->guessExtension();
  331.                     try {
  332.                         $filethree_single->move(
  333.                             $this->getParameter('kernel.project_dir') . '/public/uploads/childfiles',
  334.                             $filethreename
  335.                         );
  336.                     } catch (FileException $e) {
  337.                         return new Response($e->getMessage());
  338.                     }
  340.                     $filethree_path[] = 'uploads/childfiles/' . $filethreename;
  342.                 } 
  343.                 
  344.                 $newChilds->setFilethree($filethree_path);
  345.             }
  347.             $newChilds->setStatus('not_check');
  349.             $current_datetime = new DateTimeImmutable('now');
  350.             $newChilds->setCreationdate($current_datetime);
  351.             $newChilds->setSessionsemail(0);
  353.             $this->em->persist($newChilds);
  354.             $this->em->flush();
  356.             return $this->redirectToRoute('childs');
  357.         }
  359.         return $this->render('childs/inscription.html.twig', [
  360.             'form' => $form->createView()
  361.         ]);
  362.     }
  364.     #[Route('/childs/edit/{id}', name: 'edit_child')]
  365.     public function edit($id, Request $request): Response 
  366.     {
  367.         $child = $this->childsRepository->find($id);
  369.         $current_img = $child->getImage();
  370.         $oldStatus = $child->getStatus(); 
  372.         $form = $this->createForm(ChildsFormType::class, $child); 
  374.         $form->handleRequest($request);
  375.         $image = $form->get('image')->getData(); 
  376.         $newStatus = $form->get('status')->getData(); 
  377.         $fileone = $form->get('fileone')->getData();
  378.         $filetwo = $form->get('filetwo')->getData();
  379.         $filethree = $form->get('filethree')->getData();
  381.         if ($form->isSubmitted() && $form->isValid()) {
  382.             if ($image) {
  383.                 if ($child->getImage() !== null) {
  384.                     if (file_exists(
  385.                         $this->getParameter('kernel.project_dir') . $child->getImage()
  386.                         )) {
  387.                             $this->GetParameter('kernel.project_dir') . $child->getImage();
  388.                     }
  389.                     $newFileName = uniqid() . '.' . $image->guessExtension();
  391.                     try {
  392.                         $image->move(
  393.                             $this->getParameter('kernel.project_dir') . '/public/uploads',
  394.                             $newFileName
  395.                         );
  396.                     } catch (FileException $e) {
  397.                         return new Response($e->getMessage());
  398.                     }
  400.                     $child->setImage('uploads/' . $newFileName);
  401.                 }
  402.             } else {
  403.                 $child->setImage($current_img);
  404.             }
  406.             if( $fileone ){  
  408.                 $fileone_path = array(); 
  410.                 foreach( $fileone as $fileone_single ){  
  412.                     $fileonename = uniqid() . '.' . $fileone_single->guessExtension();
  414.                     try {
  415.                         $fileone_single->move(
  416.                             $this->getParameter('kernel.project_dir') . '/public/uploads/childfiles',
  417.                             $fileonename
  418.                         );
  419.                     } catch (FileException $e) {
  420.                         return new Response($e->getMessage());
  421.                     }
  423.                     $fileone_path[] = 'uploads/childfiles/' . $fileonename;
  425.                 } 
  426.                 
  427.                 $child->setFileone($fileone_path);
  428.             }
  430.             if( $filetwo ){
  432.                 $filetwo_path = array(); 
  434.                 foreach( $filetwo as $filetwo_single ){ 
  436.                     $filetwoname = uniqid() . '.' . $filetwo_single->guessExtension();
  438.                     try {
  439.                         $filetwo_single->move(
  440.                             $this->getParameter('kernel.project_dir') . '/public/uploads/childfiles',
  441.                             $filetwoname
  442.                         );
  443.                     } catch (FileException $e) {
  444.                         return new Response($e->getMessage());
  445.                     }
  447.                     $filetwo_path[] = 'uploads/childfiles/' . $filetwoname;
  449.                 } 
  450.                 
  451.                 $child->setFiletwo($filetwo_path);
  452.             }
  454.             if( $filethree ){
  456.                 $filethree_path = array(); 
  458.                 foreach( $filethree as $filethree_single ){ 
  460.                     $filethreename = uniqid() . '.' . $filethree_single->guessExtension();
  462.                     try {
  463.                         $filethree_single->move(
  464.                             $this->getParameter('kernel.project_dir') . '/public/uploads/childfiles',
  465.                             $filethreename
  466.                         );
  467.                     } catch (FileException $e) {
  468.                         return new Response($e->getMessage());
  469.                     }
  471.                     $filethree_path[] = 'uploads/childfiles/' . $filethreename;
  473.                 } 
  474.                 
  475.                 $child->setFilethree($filethree_path);
  476.             }
  478.             // Check old status 
  479.             if( $oldStatus != 'terminé' && $newStatus == 'terminé' ){
  481.                 $finish_datetime = new DateTimeImmutable('now');
  482.                 $child->setFinishdate($finish_datetime);
  483.             }
  485.             $this->em->persist($child);
  487.             $this->em->flush();
  488.             return $this->redirectToRoute('childs');
  489.         }
  491.         return $this->render('childs/edit.html.twig', [
  492.             'child' => $child,
  493.             'form' => $form->createView()
  494.         ]);
  495.     }
  497.     #[Route('/childs/sendsessionemail', name: 'send_session_email')]
  498.     public function sendsessionemail(MailerInterface $mailer)
  499.     {
  501.         $childs = $this->childsRepository->findExpired();
  503.         if( !empty($childs) ){
  505.             foreach($childs as $child){
  506.                 
  507.                 if( $child->getSessionsemail() == 0 ){
  509.                     $email = (new Email())
  510.                     ->from('contact@skykeys.fr')
  511.                     ->to('rranveer4@gmail.com') 
  512.                     ->subject('Rappel de saisie')
  513.                     ->html('<p>Test email</p>');
  515.                     $status = $mailer->send($email);
  517.                     $email = (new Email())
  518.                     ->from('contact@skykeys.fr')
  519.                     ->to('contact@skykeys.fr') 
  520.                     ->subject('Rappel de saisie')
  521.                     ->html('<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><head><title>Attention ! veuillez mettre a jour le profil de cette enfant a terminer</title></head><body><meta charset="UTF-8" />
  522.                     <meta content="width=device-width, initial-scale=1" name="viewport" />
  523.                     <meta name="x-apple-disable-message-reformatting" />
  524.                     <meta content="IE=edge" http-equiv="X-UA-Compatible" />
  525.                     <meta content="telephone=no" name="format-detection" />
  527.                     <!--[if (mso 16)]>
  528.                     <style type="text/css">
  529.                     a {text-decoration: none;}
  530.                     </style>
  531.                     <![endif]--><!--[if gte mso 9]><style>sup { font-size: 100% !important; }</style><![endif]--><!--[if gte mso 9]>
  532.                     <xml>
  533.                     <o:OfficeDocumentSettings>
  534.                     <o:AllowPNG></o:AllowPNG>
  535.                     <o:PixelsPerInch>96</o:PixelsPerInch>
  536.                     </o:OfficeDocumentSettings>
  537.                     </xml>
  538.                     <![endif]-->
  539.                     <style type="text/css">
  540.                     #outlook a {
  541.                     padding:0;
  542.                     }
  543.                     .es-button {
  544.                     mso-style-priority:100!important;
  545.                     text-decoration:none!important;
  546.                     }
  547.                     a[x-apple-data-detectors] {
  548.                     color:inherit!important;
  549.                     text-decoration:none!important;
  550.                     font-size:inherit!important;
  551.                     font-family:inherit!important;
  552.                     font-weight:inherit!important;
  553.                     line-height:inherit!important;
  554.                     }
  555.                     .es-desk-hidden {
  556.                     display:none;
  557.                     float:left;
  558.                     overflow:hidden;
  559.                     width:0;
  560.                     max-height:0;
  561.                     line-height:0;
  562.                     mso-hide:all;
  563.                     }
  564.                     [data-ogsb] .es-button {
  565.                     border-width:0!important;
  566.                     padding:10px 30px 10px 30px!important;
  567.                     }
  568.                     @media only screen and (max-width:600px) {p, ul li, ol li, a { line-height:150%!important } h1, h2, h3, h1 a, h2 a, h3 a { line-height:120% } h1 { font-size:36px!important; text-align:left } h2 { font-size:26px!important; text-align:left } h3 { font-size:20px!important; text-align:left } .es-header-body h1 a, .es-content-body h1 a, .es-footer-body h1 a { font-size:36px!important; text-align:left } .es-header-body h2 a, .es-content-body h2 a, .es-footer-body h2 a { font-size:26px!important; text-align:left } .es-header-body h3 a, .es-content-body h3 a, .es-footer-body h3 a { font-size:20px!important; text-align:left } .es-menu td a { font-size:12px!important } .es-header-body p, .es-header-body ul li, .es-header-body ol li, .es-header-body a { font-size:14px!important } .es-content-body p, .es-content-body ul li, .es-content-body ol li, .es-content-body a { font-size:16px!important } .es-footer-body p, .es-footer-body ul li, .es-footer-body ol li, .es-footer-body a { font-size:14px!important } .es-infoblock p, .es-infoblock ul li, .es-infoblock ol li, .es-infoblock a { font-size:12px!important } *[class="gmail-fix"] { display:none!important } .es-m-txt-c, .es-m-txt-c h1, .es-m-txt-c h2, .es-m-txt-c h3 { text-align:center!important } .es-m-txt-r, .es-m-txt-r h1, .es-m-txt-r h2, .es-m-txt-r h3 { text-align:right!important } .es-m-txt-l, .es-m-txt-l h1, .es-m-txt-l h2, .es-m-txt-l h3 { text-align:left!important } .es-m-txt-r img, .es-m-txt-c img, .es-m-txt-l img { display:inline!important } .es-button-border { display:inline-block!important } a.es-button, button.es-button { font-size:20px!important; display:inline-block!important } .es-adaptive table, .es-left, .es-right { width:100%!important } .es-content table, .es-header table, .es-footer table, .es-content, .es-footer, .es-header { width:100%!important; max-width:600px!important } .es-adapt-td { display:block!important; width:100%!important } .adapt-img { width:100%!important; height:auto!important } .es-m-p0 { padding:0!important } .es-m-p0r { padding-right:0!important } .es-m-p0l { padding-left:0!important } .es-m-p0t { padding-top:0!important } .es-m-p0b { padding-bottom:0!important } .es-m-p20b { padding-bottom:20px!important } .es-mobile-hidden, .es-hidden { display:none!important } tr.es-desk-hidden, td.es-desk-hidden, table.es-desk-hidden { width:auto!important; overflow:visible!important; float:none!important; max-height:inherit!important; line-height:inherit!important } tr.es-desk-hidden { display:table-row!important } table.es-desk-hidden { display:table!important } td.es-desk-menu-hidden { display:table-cell!important } .es-menu td { width:1%!important } table.es-table-not-adapt, .esd-block-html table { width:auto!important } table.es-social { display:inline-block!important } table.es-social td { display:inline-block!important } .es-m-p5 { padding:5px!important } .es-m-p5t { padding-top:5px!important } .es-m-p5b { padding-bottom:5px!important } .es-m-p5r { padding-right:5px!important } .es-m-p5l { padding-left:5px!important } .es-m-p10 { padding:10px!important } .es-m-p10t { padding-top:10px!important } .es-m-p10b { padding-bottom:10px!important } .es-m-p10r { padding-right:10px!important } .es-m-p10l { padding-left:10px!important } .es-m-p15 { padding:15px!important } .es-m-p15t { padding-top:15px!important } .es-m-p15b { padding-bottom:15px!important } .es-m-p15r { padding-right:15px!important } .es-m-p15l { padding-left:15px!important } .es-m-p20 { padding:20px!important } .es-m-p20t { padding-top:20px!important } .es-m-p20r { padding-right:20px!important } .es-m-p20l { padding-left:20px!important } .es-m-p25 { padding:25px!important } .es-m-p25t { padding-top:25px!important } .es-m-p25b { padding-bottom:25px!important } .es-m-p25r { padding-right:25px!important } .es-m-p25l { padding-left:25px!important } .es-m-p30 { padding:30px!important } .es-m-p30t { padding-top:30px!important } .es-m-p30b { padding-bottom:30px!important } .es-m-p30r { padding-right:30px!important } .es-m-p30l { padding-left:30px!important } .es-m-p35 { padding:35px!important } .es-m-p35t { padding-top:35px!important } .es-m-p35b { padding-bottom:35px!important } .es-m-p35r { padding-right:35px!important } .es-m-p35l { padding-left:35px!important } .es-m-p40 { padding:40px!important } .es-m-p40t { padding-top:40px!important } .es-m-p40b { padding-bottom:40px!important } .es-m-p40r { padding-right:40px!important } .es-m-p40l { padding-left:40px!important } .es-desk-hidden { display:table-row!important; width:auto!important; overflow:visible!important; max-height:inherit!important } }</style>
  569.                     <div class="es-wrapper-color" style="background-color:#FAFAFA">
  570.                     <!--[if gte mso 9]>
  571.                     <v:background xmlns:v="urn:schemas-microsoft-com:vml" fill="t">
  572.                     <v:fill type="tile" color="#fafafa"></v:fill>
  573.                     </v:background>
  574.                     <![endif]-->
  575.                     <table cellpadding="0" cellspacing="0" class="es-wrapper" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;padding:0;Margin:0;width:100%;height:100%;background-repeat:repeat;background-position:center top;background-color:#FAFAFA" width="100%">
  576.                     <tbody>
  577.                     <tr>
  578.                     <td style="padding:0;Margin:0" valign="top">
  579.                     <table align="center" cellpadding="0" cellspacing="0" class="es-content" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;table-layout:fixed !important;width:100%">
  580.                     <tbody>
  581.                     <tr>
  582.                     <td align="center" style="padding:0;Margin:0">
  583.                     <table align="center" bgcolor="#ffffff" cellpadding="0" cellspacing="0" class="es-content-body" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;background-color:#FFFFFF;width:600px">
  584.                     <tbody>
  585.                     <tr>
  586.                     <td align="left" style="Margin:0;padding-left:20px;padding-right:20px;padding-top:30px;padding-bottom:30px">
  587.                     <table cellpadding="0" cellspacing="0" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px" width="100%">
  588.                     <tbody>
  589.                     <tr>
  590.                     <td align="center" style="padding:0;Margin:0;width:560px" valign="top">
  591.                     <table cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px" width="100%">
  592.                     <tbody>
  593.                     <tr>
  594.                     <td align="center" style="padding:0;Margin:0;padding-top:10px;padding-bottom:10px;font-size:0px">
  595.                     <img alt="" height="45" src="https://suzielc.fr/wp-content/uploads/2021/11/logo2-2048x576.png" style="display:block;border:0;outline:none;text-decoration:none;-ms-interpolation-mode:bicubic" width="185" /></td>
  596.                     </tr>
  597.                     <tr>
  598.                     <td align="center" class="es-m-txt-c" style="padding:0;Margin:0;padding-bottom:10px">
  599.                     <h1 style="Margin:0;line-height:46px;mso-line-height-rule:exactly;font-family:arial, helvetica neue, helvetica, sans-serif;font-size:46px;font-style:normal;font-weight:bold;color:#333333">
  600.                     Rappel de saisie</h1>
  601.                     </td>
  602.                     </tr>
  603.                     <tr>
  604.                     <td align="center" class="es-m-p0r es-m-p0l" style="Margin:0;padding-top:5px;padding-bottom:5px;padding-left:40px;padding-right:40px">
  605.                     <p class="p1" style="margin: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 19.5px; line-height: normal; font-family: Helvetica; color: rgb(0, 0, 0);">
  606.                     <span style="font-size:16px;">Bonjour , lenfant '. $child->getFirstname() .' '. $child->getLastname() .' a dépasser sa date provisoire de fin de session qui été le '. $child->getSessionseta()->format('Y-m-d') .'</span></p> 
  607.                     <p style="Margin:0;-webkit-text-size-adjust:none;-ms-text-size-adjust:none;mso-line-height-rule:exactly;font-family:arial, helvetica neue, helvetica, sans-serif;line-height:21px;color:#333333;font-size:14px">
  608.                     <span style="font-size:16px;">Merci de modifer son statut de <strong>En cour </strong> à <strong>Terminer</strong></span></p>
  609.                     </td>
  610.                     </tr>
  611.                     <tr>
  612.                     <td align="center" style="padding:0;Margin:0;padding-top:10px;padding-bottom:10px">
  613.                     <span class="es-button-border" style="border-style:solid;border-color:#2CB543;background:#5C68E2;border-width:0px;display:inline-block;border-radius:6px;width:auto"><a class="es-button" href="https://suzielc.com/login" style="mso-style-priority:100 !important;text-decoration:none;-webkit-text-size-adjust:none;-ms-text-size-adjust:none;mso-line-height-rule:exactly;color:#FFFFFF;font-size:20px;border-style:solid;border-color:#5C68E2;border-width:10px 30px 10px 30px;display:inline-block;background:#5C68E2;border-radius:6px;font-family:arial, helvetica neue, helvetica, sans-serif;font-weight:normal;font-style:normal;line-height:24px;width:auto;text-align:center;border-left-width:30px;border-right-width:30px" target="_blank">Connexion</a></span></td>
  614.                     </tr>
  615.                     <tr>
  616.                     <td align="center" class="es-m-p0r es-m-p0l" style="Margin:0;padding-top:5px;padding-bottom:5px;padding-left:40px;padding-right:40px">
  617.                     <p style="Margin:0;-webkit-text-size-adjust:none;-ms-text-size-adjust:none;mso-line-height-rule:exactly;font-family:arial, helvetica neue, helvetica, sans-serif;line-height:21px;color:#333333;font-size:14px">
  618.                     Cette email est confidentiel afin de garantir une total securité </p>
  619.                     </td>
  620.                     </tr>
  621.                     </tbody>
  622.                     </table>
  623.                     </td>
  624.                     </tr>
  625.                     </tbody>
  626.                     </table>
  627.                     </td>
  628.                     </tr>
  629.                     </tbody>
  630.                     </table>
  631.                     </td>
  632.                     </tr>
  633.                     </tbody>
  634.                     </table>
  635.                     </td>
  636.                     </tr>
  637.                     </tbody>
  638.                     </table>
  639.                     </div>
  640.                     <br />
  641.                     </body>');
  643.                     $status = $mailer->send($email);
  645.                     $child->setSessionsemail(1);
  646.                     $this->em->persist($child);
  647.                     $this->em->flush();
  648.                 }
  649.             }
  650.         }         
  652.         exit();
  653.     }
  655.     #[Route('/childs/{id}', methods: ['GET'], name: 'show_childs')]
  656.     public function show($id): Response
  657.     {
  658.         $child = $this->childsRepository->find($id);
  659.         $school = $child->getSchool()->getName();
  660.         
  661.         return $this->render('childs/show.html.twig', [
  662.             'child' => $child,
  663.             'school' => $school
  664.         ]);
  665.     }
  667.     #[Route('/childs/delete/{id}', methods: ['GET', 'DELETE'], name: 'delete_child')]
  668.     public function delete($id): Response
  669.     {
  670.         $child = $this->childsRepository->find($id);
  671.         $sessions = $child->getSessions();
  673.         // Get sessions
  674.         if( !empty($sessions) ){
  676.             foreach($sessions as $session){ 
  677.                 $session = $this->sessionsRepository->find($session->getId());
  678.                 $this->em->remove($session);
  679.                 $this->em->flush();
  680.             }
  681.         }  
  683.         $this->em->remove($child);
  684.         $this->em->flush();
  686.         return $this->redirectToRoute('childs');
  687.     }
  688. }