src/Controller/Etudiant/RapportController.php line 201

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Etudiant;
  5. use ZipArchive;
  6. use SplFileObject;
  7. use App\Entity\Rapport;
  8. use Selective\Rar\RarFileReader;
  9. use Doctrine\Persistence\ManagerRegistry;
  10. use phpDocumentor\Reflection\Types\This;
  11. use Symfony\Component\HttpFoundation\Request;
  12. use Symfony\Component\HttpFoundation\Response;
  13. use Symfony\Component\Routing\Annotation\Route;
  14. use Symfony\Component\HttpFoundation\JsonResponse;
  15. use Symfony\Contracts\HttpClient\HttpClientInterface;
  16. use Symfony\Component\String\Slugger\SluggerInterface;
  17. use Symfony\Component\Finder\Exception\AccessDeniedException;
  18. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  19. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  20. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  21. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  22. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  24. #[Route('/etudiant/rapport')]
  25. class RapportController extends AbstractController
  26. {
  27.     private $client;
  28.     private $em;
  29.     public function __construct(HttpClientInterface $client, ManagerRegistry $em)
  30.     {
  31.         $this->client = $client;
  32.         $this->em = $em->getManager();
  33.     }
  34.     #[Route('/', name: 'rapport_index')]
  35.     public function index(): Response
  36.     {
  37.         $response = $this->client->request('GET', $this->getParameter("api")."/getetablissement");
  38.         $etablissements = $response->toArray();
  39.         return $this->render('rapport/index.html.twig', [
  40.             'etablissements' => $etablissements
  41.         ]);
  42.     }
  43.     #[Route('/import', name: 'rapport_import')]
  44.     public function import(Request $request, SluggerInterface $slugger): Response
  45.     {
  46.         $files = $request->files->get('file');
  47.         foreach ($files as $file) {
  48.             if($file->guessExtension() !== 'pdf'){
  49.                 return new JsonResponse('Prière d\'enregister des fichiers pdf!', 500);            
  50.             }
  51.         }
  52.         
  53.         foreach ($files as $file) {
  54.             $name = $file->getClientOriginalName();
  55.             $data = explode("_", $name);
  56.             $stage = $data[1];
  57.             $inscription = $data[2];
  58.             $type = $data[3];
  60.             $originalFilename = pathinfo($name, PATHINFO_FILENAME);
  61.             $safeFilename = $slugger->slug($originalFilename);
  62.             $newFilename = $safeFilename.'-'.uniqid().'.'.$file->guessExtension();
  63.             // dd($originalFilename, $newFilename);
  64.             
  65.             try {
  66.                 // dd("hi");
  67.                 $file->move(
  68.                     $this->getParameter('rapport_directory'),
  69.                     $newFilename
  70.                 );
  71.                 $rapportExist = $this->em->getRepository(Rapport::class)->findOneBy(['stage' => $stage, 'inscription' => $inscription, 'type' => $type]);
  72.                 // dd($rapportExist);
  73.                 if($rapportExist){
  74.                     $rapportExist->setUrl($newFilename);
  75.                     $rapportExist->setDateUpdated(new \DateTime("now"));
  76.                 } else {
  77.                     $rapport = new Rapport();
  78.                     $rapport->setStage($stage);
  79.                     $rapport->setInscription($inscription);
  80.                     $rapport->setType($type);
  81.                     $rapport->setDateCreated(new \DateTime("now"));
  82.                     $rapport->setDateUpdated(new \DateTime("now"));
  83.                     $rapport->setUrl($newFilename);
  84.                     $this->em->persist($rapport);
  85.                 }
  86.                 $this->em->flush();
  87.             } catch (FileException $e) {
  88.                 return new JsonResponse($e, 500);
  89.             }
  90.         }
  91.         
  92.         return new JsonResponse("Bien enregistre");
  93.     }
  94.     #[Route('/list/{id}/{cyclekey}', name: 'rapport_list')]
  95.     public function list(Request $request, $id, $cyclekey): Response
  96.     {
  97.         // dd("test");
  98.         ini_set("pcre.backtrack_limit", "5000000000");
  99.         ini_set('max_execution_time', '-1');
  100.         // dd(ini_get('max_execution_time'));
  101.         // set_time_limit(0);
  102.         $response = $this->client->request('GET', $this->getParameter("api")."/getlistofstagebysemestreannee/$id");
  103.         $session = $request->getSession();
  104.         $data = $response->toArray();
  105.         $inscriptions = $data['inscriptions'];
  106.         // dd($inscriptions);
  107.         $cycles = $data['cycles'];
  108.         // $ncycles = [];
  109.         // if($cycles[$cyclekey]){
  110.         //     array_push($ncycles[$cyclekey], $cycles[$cyclekey]);
  111.         // }
  112.         // $ncycles[$cyclekey] = $ncycles[0];
  113.         $ncycles[$cyclekey]= $cycles[$cyclekey];
  114.         // dd($cycles);
  115.         
  116.         $etab = $inscriptions[0]['etab'];
  117.         $data = [];
  118.         $c = 0;
  119.         $stageSimulation = $stageClinique = $stageSDentaire = $stagePharmacy = $stagePharmacyHopital = $stagePharmacyStaff = $stageFmaGlobal = $stageFpaGlobal = $stageFdaGlobal = null;
  120.         foreach ($inscriptions as $key => $inscription) {
  121.             // if($inscription['id'] == "19265") {
  122.                 $arrayOfStage = [];
  123.                 // if($inscription['id'] == "17835"){
  124.                 //     dd($cycles);
  125.                     
  126.                 // }
  127.                 foreach ($ncycles as $key => $cycle) {
  128.                 //     if($key != $cyclekey){
  129.                 //         continue;
  130.                 //     }
  131.                     switch ($etab) {
  132.                         case 'FMDA':
  133.                             $stageFdaGlobal = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "global");
  134.                             $stageSDentaire = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "dentaire");
  135.                             $stageSimulation = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "simulation");
  136.                             $stageClinique = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "clinique");
  137.                             break;
  138.                         case 'FPA':
  139.                             $stageFpaGlobal = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "global");
  140.                             $stagePharmacyHopital = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "hopital");
  141.                             $stagePharmacy = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "pharmacy");
  142.                             $stagePharmacyStaff = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "staff");
  143.                             $stageSimulation = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "simulation");
  144.                             break;
  145.                         default:
  146.                             $stageFmaGlobal = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "global");
  147.                             $stageSimulation = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "simulation");
  148.                             $stageClinique = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "clinique");
  149.                             break;
  150.                     }
  151.                     
  152.                     // $stageSimulation = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "simulation");
  153.                     // $stageClinique = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "clinique");
  154.                     // $stageSDentaire = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "dentaire");
  155.                     // $stagePharmacy = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "pharmacy");
  156.                     // $stagePharmacyHopital = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "hopital");
  157.                     // $stagePharmacyStaff = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "staff");
  158.                     // dd($stagePharmacyHopital);
  159.                     array_push($arrayOfStage, [
  160.                         'clinique' => $stageClinique,
  161.                         'simulation' => $stageSimulation,
  162.                         'pharmacy' => $stagePharmacy,
  163.                         'dentaire' => $stageSDentaire,
  164.                         'staff' => $stagePharmacyStaff,
  165.                         'hopital' => $stagePharmacyHopital,
  166.                         'fmaglobal' => $stageFmaGlobal,
  167.                         'fdaglobal' => $stageFdaGlobal,
  168.                         'fpaglobal' => $stageFpaGlobal,
  169.                     ]);
  170.                 }
  171.                 
  172.                 // dd($arrayOfStage);
  173.                 array_push($data, [
  174.                     'inscription' => $inscription,
  175.                     'stages' => $arrayOfStage
  176.                 ]);
  177.             // }
  178.         }
  179.         // dd($data);
  180.         $html = $this->render("rapport/page/table.html.twig", [
  181.             'datas' => $data,
  182.             'cycles' => $ncycles
  183.         ])->getContent();
  184.         // dd($cycles);
  185.         $session->set("inscriptions", $inscriptions);
  186.         return new JsonResponse($html);
  187.     }
  188.     #[Route('/stageDetails/{rapport}', name: 'rapport_stageDetails')]
  189.     public function stageDetails(Request $request, Rapport $rapport): Response
  190.     {
  191.         $session = $request->getSession();
  192.         $inscriptions = $session->get("inscriptions");
  193.         $inscription = $inscriptions[array_search($rapport->getInscription(), array_column($inscriptions, 'id'))];
  194.         // dd($rapport);
  195.         return $this->render("rapport/detail.html.twig", [
  196.             'rapport' => $rapport,
  197.             'inscription' => $inscription
  198.         ]);
  199.     }
  200.     #[Route('/rapportsave/{rapport}', name: 'rapport_rapport_save')]
  201.     public function rapport_save(Request $request, Rapport $rapport): Response
  202.     {
  203.         // dd($request);
  204.         if(!in_array('ROLE_ENSEIGNANT', $this->getUser()->getRoles())) {
  205.             throw new AccessDeniedException("Vous avez pas le droit!");
  206.         }
  207.         $rapport->setNote(floatval($request->get('note')));
  208.         $rapport->setObservation($request->get('observation'));
  209.         $rapport->setProf($this->getUser());
  210.         $this->em->flush();
  211.         return $this->redirectToRoute('rapport_stageDetails', [
  212.             'rapport' => $rapport->getId()
  213.         ]);
  214.     }
  217.     #[Route('/export_etat_Notes/{semestre}/{cyclekey}', name: 'export_etat_Notes')]
  218.     public function export_etat_Notes(Request $request, $semestre,$cyclekey)
  219.     {
  220.         // set_time_limit(0);
  221.         // set_time_limit(0);
  222.         // ini_set('max_execution_time', '0');
  223.         // dd(ini_get('max_execution_time'));
  224.         
  225.         $response = $this->client->request('GET', $this->getParameter("api")."/getlistofstagebysemestreannee/$semestre")->toArray();
  226.         $abreviations = $this->client->request('GET', $this->getParameter("api")."/getabreviationsbysemestre/$semestre")->toArray();
  227.         $inscriptions = $response['inscriptions'];
  228.         $cycles = $response['cycles'];
  229.         $etab = $inscriptions[0]['etab'];
  230.         $stageSimulation = $stageClinique = $stageDentaire = $stagePharmacy = $stagePharmacyHopital = $stagePharmacyStaff = $stageFmaGlobal = $stageFpaGlobal = $stageFdaGlobal = null;
  231.         // dd($cycles,$semestre,$cyclekey);
  232.         $spreadsheet = new Spreadsheet();
  233.         $sheet = $spreadsheet->getActiveSheet();
  234.         $sheet->setCellValue('A1', 'ORD');
  235.         // $values = [];
  236.         $i=2;
  237.         $j=1;
  238.         $headers = [];
  239.         foreach ($inscriptions as $inscription) {
  240.             // if($inscription['id'] == "19274" || $inscription['id'] == "19265") {
  241.             $sheet->setCellValue('A'.$i, $j);
  242.             $sheet->fromArray(
  243.                 $inscription,
  244.                 null,
  245.                 'B'.$i
  246.             );
  247.             $k = $cyclekey + 1;
  248.             // $k = 1;
  249.             foreach ($cycles as $key => $cycle) { 
  250.                 if($key != $cyclekey){
  251.                     continue;
  252.                     // dd($cycles,$cycle);
  253.                 }
  254.                     switch ($etab) {
  255.                         case 'FMDA':
  256.                             $stageFdaGlobal = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "global");
  257.                             $stageDentaire = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "dentaire");
  258.                             $stageSimulation = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "simulation");
  259.                             $stageClinique = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "clinique");
  260.                             break;
  261.                         case 'FPA':
  262.                             $stageFpaGlobal = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "global");
  263.                             $stagePharmacyHopital = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "hopital");
  264.                             $stagePharmacy = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "pharmacy");
  265.                             $stagePharmacyStaff = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "staff");
  266.                             $stageSimulation = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "simulation");
  267.                             break;
  268.                         default:
  269.                             $stageFmaGlobal = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "global");
  270.                             $stageSimulation = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "simulation");
  271.                             $stageClinique = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "clinique");
  272.                             break;
  273.                     }
  274.                     
  275.                     if (($stageClinique != null || $stageSimulation != null || $stageFmaGlobal != null) && $stagePharmacyHopital == null ) {
  276.                         // dd($stageSimulation);
  277.                         $inscription['stage'.$k] = $cycle['designation'][0];
  278.                         // $inscription['P-Cli'.$k] = $stageClinique->getProf() == null ? 'null' : $stageClinique->getProf()->getNom() . " " .$stageClinique->getProf()->getPrenom();
  279.                         $inscription['P-Cli'.$k] = $stageClinique != null ? ($stageClinique->getProf() == null ? 'null' : $stageClinique->getProf()->getNom() . " " .$stageClinique->getProf()->getPrenom()) : "";
  280.                         $inscription['N-Cli'.$k] = $stageClinique != null ? ($stageClinique->getNote() == 0 ? "0" : $stageClinique->getNote()) : "";
  281.                         $inscription['OBS Cli'.$k] = $stageClinique != null ? $stageClinique->getObservation() : "";
  282.                         $inscription['P-Sim'.$k] = $stageSimulation != null ? ($stageSimulation->getProf() == null ? 'null' : $stageSimulation->getProf()->getNom() . " " .$stageSimulation->getProf()->getPrenom()) : "";
  283.                         $inscription['N-Sim'.$k] = $stageSimulation != null ? ($stageSimulation->getNote() == 0 ? "0" : $stageSimulation->getNote()) : "";
  284.                         $inscription['OBS Sim'.$k] = $stageSimulation != null ? $stageSimulation->getObservation() : "";
  285.                         $inscription['P-Glb'.$k] = $stageFmaGlobal != null ? ($stageFmaGlobal->getProf() == null ? 'null' : $stageFmaGlobal->getProf()->getNom() . " " .$stageFmaGlobal->getProf()->getPrenom()) : "";
  286.                         $inscription['N-Glb'.$k] = $stageFmaGlobal != null ? ($stageFmaGlobal->getNote() == 0 ? "0" : $stageFmaGlobal->getNote()) : "";
  287.                         $inscription['OBS Glb'.$k] = $stageFmaGlobal != null ? $stageFmaGlobal->getObservation() : "";
  288.                     }
  289.                     
  290.                     elseif ($stageSimulation != null || $stagePharmacyHopital != null || $stageFpaGlobal != null) {
  291.                         $inscription['stage'.$k] = $cycle['designation'][0];
  292.                         $inscription['P-Simulation'.$k] = $stageSimulation != null ? ($stageSimulation->getProf() == null ? 'null' : $stageSimulation->getProf()->getNom() . " " .$stageSimulation->getProf()->getPrenom()) : "";
  293.                         $inscription['N-Simulation'.$k] = $stageSimulation != null ? ($stageSimulation->getNote() == 0 ? "0" : $stageSimulation->getNote()) : "";
  294.                         $inscription['OBS Simulation'.$k] = $stageSimulation != null ? $stageSimulation->getObservation() : "";
  295.                         $inscription['P-Hopital'.$k] = $stagePharmacyHopital != null ? ($stagePharmacyHopital->getProf() == null ? 'null' : $stagePharmacyHopital->getProf()->getNom() . " " .$stagePharmacyHopital->getProf()->getPrenom()) : "";
  296.                         $inscription['N-Hopital'.$k] = $stagePharmacyHopital != null ? ($stagePharmacyHopital->getNote() == 0 ? "0" : $stagePharmacyHopital->getNote()) : "";
  297.                         $inscription['OBS Hopital'.$k] = $stagePharmacyHopital != null ? $stagePharmacyHopital->getObservation() : "";
  298.                         $inscription['P-Glb'.$k] = $stageFpaGlobal != null ? ($stageFpaGlobal->getProf() == null ? 'null' : $stageFpaGlobal->getProf()->getNom() . " " .$stageFpaGlobal->getProf()->getPrenom()) : "";
  299.                         $inscription['N-Glb'.$k] = $stageFpaGlobal != null ? ($stageFpaGlobal->getNote() == 0 ? "0" : $stageFpaGlobal->getNote()) : "";
  300.                         $inscription['OBS Glb'.$k] = $stageFpaGlobal != null ? $stageFpaGlobal->getObservation() : "";
  301.                     }
  302.                     elseif ($stagePharmacy != null) {
  303.                         $inscription['stage'.$k] = $cycle['designation'][0];
  304.                         $inscription['P-Phar'.$k] = $stagePharmacy->getProf() == null ? 'null' : $stagePharmacy->getProf()->getNom() . " " .$stagePharmacy->getProf()->getPrenom();
  305.                         $inscription['N-Phar'.$k] = $stagePharmacy->getNote() == 0 ? "0" : $stagePharmacy->getNote();  
  306.                         $inscription['OBS Phar'.$k] = $stagePharmacy->getObservation();
  307.                     }elseif ($stageDentaire != null || $stageFdaGlobal != null) {
  308.                         $inscription['stage'.$k] = $cycle['designation'][0];
  309.                         $inscription['P-Dent'.$k] = $stageDentaire->getProf() == null ? 'null' : $stageDentaire->getProf()->getNom() . " " .$stageDentaire->getProf()->getPrenom();
  310.                         $inscription['N-Dent'.$k] = $stageDentaire->getNote() == 0 ? "0" : $stageDentaire->getNote();
  311.                         $inscription['OBS Dent'.$k] = $stageDentaire->getObservation();
  312.                         $inscription['P-Glb'.$k] = $stageFdaGlobal->getProf() == null ? 'null' : $stageFdaGlobal->getProf()->getNom() . " " .$stageFdaGlobal->getProf()->getPrenom();
  313.                         $inscription['N-Glb'.$k] = $stageFdaGlobal->getNote() == 0 ? "0" : $stageFdaGlobal->getNote();
  314.                         $inscription['OBS Glb'.$k] = $stageFdaGlobal->getObservation();
  315.                     }else{
  316.                         // $inscription['stage'.$k] = $cycle['designation'][0];
  317.                         $inscription['stage'.$k] = "";
  318.                         $inscription['P-Phar'.$k] = "";
  319.                         $inscription['N-Phar'.$k] = "";  
  320.                         $inscription['OBS Phar'.$k] = "";
  321.                     }
  322.                     if (count($inscription) >= count($headers)) {
  323.                         $headers = $inscription;
  324.                     }
  325.                 $k++;
  326.             }
  327.             $sheet->fromArray(
  328.                 $inscription,
  329.                 null,
  330.                 'B'.$i
  331.             );
  332.             $i++;
  333.             $j++;
  334.             }
  335.         // }
  336.         $sheet->fromArray(
  337.             array_keys($headers),
  338.             null,
  339.             'B1'
  340.         );
  341.         $writer = new Xlsx($spreadsheet);
  342.         $fileName = 'Extraction Des Notes.xlsx';
  343.         $temp_file = tempnam(sys_get_temp_dir(), $fileName);
  344.         $writer->save($temp_file);
  345.         return $this->file($temp_file, $fileName, ResponseHeaderBag::DISPOSITION_INLINE);
  346.     }
  347.     
  348.     // #[Route('/export_etat_Notes/{semestre}', name: 'export_etat_Notes')]
  349.     // public function export_etat_Notes(Request $request, $semestre)
  350.     // {
  351.     //     $response = $this->client->request('GET', $this->getParameter("api")."/getlistofstagebysemestreannee/$semestre")->toArray();
  352.     //     $abreviations = $this->client->request('GET', $this->getParameter("api")."/getabreviationsbysemestre/$semestre")->toArray();
  353.     //     // dd($response);
  354.     //     $inscriptions = $response['inscriptions'];
  355.     //     $cycles = $response['cycles'];
  356.     //     // dd($cycles);
  357.     //     // dd($inscriptions);
  358.     //     $spreadsheet = new Spreadsheet();
  359.     //     $sheet = $spreadsheet->getActiveSheet();
  360.     //     $sheet->setCellValue('A1', 'ORD');
  361.     //     $sheet->fromArray(
  362.     //         array_keys($inscriptions[0]),
  363.     //         null,
  364.     //         'B1'
  365.     //     );
  366.     //     // $sheet->setCellValue('S1', 'CYCLE 1');
  367.     //     // $sheet->setCellValue('T1', 'N-Cli');
  368.     //     // $sheet->setCellValue('U1', 'N-Sim');
  369.     //     // $sheet->setCellValue('V1', 'OBS Cli');
  370.     //     // $sheet->setCellValue('W1', 'OBS Sim');
  372.     //     // $sheet->setCellValue('R1', 'CYCLE 1');
  373.     //     // $sheet->setCellValue('S1', 'N-Cli');
  374.     //     // $sheet->setCellValue('T1', 'N-Sim');
  375.     //     // $sheet->setCellValue('U1', 'N-Phar');
  376.     //     // $sheet->setCellValue('V1', 'N-Dent');
  377.     //     // $sheet->setCellValue('W1', 'OBS Cli');
  378.     //     // $sheet->setCellValue('X1', 'OBS Sim');
  379.     //     // $sheet->setCellValue('Y1', 'OBS Phar');
  380.     //     // $sheet->setCellValue('Z1', 'OBS Dent');
  381.     //     // $sheet->setCellValue('AA1', 'CYCLE 2');
  382.     //     // $sheet->setCellValue('AB1', 'N-Cli');
  383.     //     // $sheet->setCellValue('AC1', 'N-Sim');
  384.     //     // $sheet->setCellValue('AD1', 'N-Phar');
  385.     //     // $sheet->setCellValue('AE1', 'N-Dent');
  386.     //     // $sheet->setCellValue('AF1', 'OBS Cli');
  387.     //     // $sheet->setCellValue('AG1', 'OBS Sim');
  388.     //     // $sheet->setCellValue('AH1', 'OBS Phar');
  389.     //     // $sheet->setCellValue('AI1', 'OBS Dent');
  390.     //     // $sheet->setCellValue('AJ1', 'CYCLE 3');
  391.     //     // $sheet->setCellValue('AK1', 'N-Cli');
  392.     //     // $sheet->setCellValue('AL1', 'N-Sim');
  393.     //     // $sheet->setCellValue('AM1', 'N-Phar');
  394.     //     // $sheet->setCellValue('AN1', 'N-Dent');
  395.     //     // $sheet->setCellValue('AO1', 'OBS Cli');
  396.     //     // $sheet->setCellValue('AP1', 'OBS Sim');
  397.     //     // $sheet->setCellValue('AQ1', 'OBS Phar');
  398.     //     // $sheet->setCellValue('AR1', 'OBS Dent');
  399.     //     // $sheet->setCellValue('AS1', 'CYCLE 4');
  400.     //     // $sheet->setCellValue('AT1', 'N-Cli');
  401.     //     // $sheet->setCellValue('AU1', 'N-Sim');
  402.     //     // $sheet->setCellValue('AV1', 'N-Phar');
  403.     //     // $sheet->setCellValue('AW1', 'N-Dent');
  404.     //     // $sheet->setCellValue('AX1', 'OBS Cli');
  405.     //     // $sheet->setCellValue('AY1', 'OBS Sim');
  406.     //     // $sheet->setCellValue('AZ1', 'OBS Phar');
  407.     //     // $sheet->setCellValue('BA1', 'OBS Dent');
  409.     //     $i=2;
  410.     //     $j=1;
  411.     //     foreach ($inscriptions as $inscription) {
  412.     //         // dd($infoBYinscription);
  413.     //         $sheet->setCellValue('A'.$i, $j);
  414.     //         $sheet->fromArray(
  415.     //             $inscription,
  416.     //             null,
  417.     //             'B'.$i
  418.     //         );
  419.     //         $k = 1;
  420.     //         foreach ($cycles as $cycle) {
  421.     //             if ($k == 1) {
  422.     //                 $stageClinique = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "clinique");
  423.     //                 // dd($cycle['designation']);
  424.     //                 $stageSimulation = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "simulation");
  425.     //                 $stagePharmacy = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "pharmacy");
  426.     //                 $stageDentaire = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "dentaire");
  427.     //                 $stagePharmacy = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "pharmacy");
  428.     //                 $stageSDentaire = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "dentaire");
  429.     //                 $stagePharmacyStaff = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "staff");
  430.     //                 // dd($stagePharmacyStaff);
  431.     //                 $stagePharmacyHopital = $this->em->getRepository(Rapport::class)->findStage($inscription["id"], $cycle['stages'], "hopital");
  433.     //                 $sheet->setCellValue('S1', 'stage'.$k);
  434.     //                 $sheet->setCellValue('S'.$i,$cycle['designation'][0]);
  435.     //                 if ($stageClinique != null || $stageSimulation != null) {
  436.     //                     $sheet->setCellValue('T1', 'N-Cli');
  437.     //                     $sheet->setCellValue('U1', 'N-Sim');
  438.     //                     $sheet->setCellValue('V1', 'OBS Cli');
  439.     //                     $sheet->setCellValue('W1', 'OBS Sim');
  440.     //                     $sheet->setCellValue('T'.$i, $stageClinique->getNote());
  441.     //                     $sheet->setCellValue('U'.$i, $stageSimulation->getNote());
  442.     //                     $sheet->setCellValue('V'.$i, $stageClinique->getObservation());
  443.     //                     $sheet->setCellValue('W'.$i, $stageSimulation->getObservation());
  444.     //                 }elseif ($stagePharmacyStaff != null || $stagePharmacyHopital != null) {
  445.     //                     $sheet->setCellValue('T1', 'N-Staf');
  446.     //                     $sheet->setCellValue('U1', 'N-Hopital');
  447.     //                     $sheet->setCellValue('V1', 'OBS Staf');
  448.     //                     $sheet->setCellValue('W1', 'OBS Hopital');
  449.     //                     $sheet->setCellValue('T'.$i, $stagePharmacyStaff->getNote());
  450.     //                     $sheet->setCellValue('U'.$i, $stagePharmacyHopital->getNote());
  451.     //                     $sheet->setCellValue('V'.$i, $stagePharmacyStaff->getObservation());
  452.     //                     $sheet->setCellValue('W'.$i, $stagePharmacyHopital->getObservation());
  453.     //                 }elseif ($stagePharmacy != null) {
  454.     //                     $sheet->setCellValue('T1', 'N-Phar');
  455.     //                     $sheet->setCellValue('U1', 'OBS Phar');
  456.     //                     $sheet->setCellValue('T'.$i, $stagePharmacy->getNote());
  457.     //                     $sheet->setCellValue('U'.$i, $stagePharmacy->getObservation());
  458.     //                 }elseif ($stageDentaire != null) {
  459.     //                     $sheet->setCellValue('T1', 'N-Dent');
  460.     //                     $sheet->setCellValue('U1', 'OBS Dent');
  461.     //                     $sheet->setCellValue('T'.$i, $stageDentaire->getNote());
  462.     //                     $sheet->setCellValue('U'.$i, $stageDentaire->getObservation());
  463.     //                 }
  464.     //             }
  465.     //             $k++;
  466.     //         }
  467.     //         $i++;
  468.     //         $j++;
  469.     //     }
  470.         
  471.     //     // $sheet = $spreadsheet->getActiveSheet();
  472.         
  473.         
  474.     //     $writer = new Xlsx($spreadsheet);
  475.     //     $fileName = 'Extraction Des Notes.xlsx';
  476.     //     $temp_file = tempnam(sys_get_temp_dir(), $fileName);
  477.     //     $writer->save($temp_file);
  478.     //     return $this->file($temp_file, $fileName, ResponseHeaderBag::DISPOSITION_INLINE);
  479.     // }
  480.     
  481.     
  482. }