src/Controller/Mouvement/ArretController.php line 726

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Mouvement;
  5. use DateTime;
  6. use App\Entity\PMotif;
  7. use App\Entity\PPiece;
  8. use App\Entity\PDossier;
  9. use App\Entity\Pemploye;
  10. use App\Entity\LContract;
  11. use App\Entity\Prubrique;
  12. use App\Entity\PPrelevement;
  13. use App\Entity\PArretTravail;
  14. use App\Entity\PPrelevementLg;
  15. use App\Entity\PArretTravailLg;
  16. use App\Controller\ApiController;
  17. use App\Service\CalculPaieService;
  18. use Doctrine\Persistence\ManagerRegistry;
  19. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  20. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  21. use Symfony\Component\HttpFoundation\Request;
  22. use Symfony\Component\HttpFoundation\Response;
  23. use Symfony\Component\Routing\Annotation\Route;
  24. use Symfony\Component\HttpFoundation\JsonResponse;
  25. use Symfony\Component\HttpFoundation\ParameterBag;
  26. use PhpOffice\PhpSpreadsheet\Reader\Xlsx as Reader;
  27. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  28. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  31. #[Route('/mouvement/arret')]
  32. class ArretController extends AbstractController
  33. {
  34.     private $em;
  35.     private $calculPaieService;
  36.     private $api;
  37.     public function __construct(ManagerRegistry $doctrine , CalculPaieService $calculPaieService, ApiController $api)
  38.     {
  39.         $this->em = $doctrine->getManager();
  40.         $this->calculPaieService = $calculPaieService;
  41.         $this->api = $api;
  42.         
  43.     }
  44.     #[Route('/', name: 'app_mouvement_arret', options:['expose' => true])]
  45.     public function index(Request $request): Response
  46.     {
  47.         $now = new DateTime();
  49.         // Get the current date in a specific format (e.g., 'Y-m-d H:i:s')
  50.         $currentDate = $now->format('Y-m');
  51.        
  52.         $dossier = $request->getSession()->get('dossier');
  53.         $operations = $this->api->check($this->getUser(), 'app_mouvement_arret', $this->em, $request);
  54.         if(!is_array($operations)) {
  55.             return $this->redirectToRoute('app_site');  
  56.         }elseif(count($operations) == 0) {
  57.             return $this->render('includes/404.html.twig');
  58.         }
  60.         
  62.         // $queryBuilder = $this->em->createQueryBuilder()
  63.         // ->select('a.id as arret_id,p.id as employe_id,p.code as matricule,m.designation as motif,a.DateDebut as date_debut,a.dateFin as date_fin,a.dateReprise as date_rep')
  64.         // ->from(PArretTravail::class, 'a')
  65.         // ->innerJoin('a.contract', 'c')
  66.         // ->innerJoin('c.employe', 'p')
  67.         // ->innerJoin('a.motif', 'm')
  68.         // ->Where('a.active = 1')
  69.         // ->andWhere('c.dossier = :dossier')
  70.         // ->setParameter('dossier', $dossier);
  71.         // $results = $queryBuilder->getQuery()->getResult();
  73.         $pmotif = $this->em->getRepository(PMotif::class)->findBy(['active' => 1 ]);
  74.         
  75.         $queryBuilder = $this->em->createQueryBuilder()
  76.         ->select('contract.id as id, p.nom as nom, p.matricule as matricule , p.prenom')
  77.         ->from(LContract::class, 'contract')
  78.         ->innerJoin('contract.employe', 'p')
  79.         ->innerJoin('contract.dossier', 'd')
  80.         ->Where('contract.active = 1')
  81.         ->andWhere('d.id = :dossier')
  82.         ->setParameter('dossier', $dossier);        // $elements = $this->em->getRepository(Prubrique::class)->findBy(['sens' => [1, -1]]);
  83.         $pemployes = $queryBuilder->getQuery()->getResult();
  85.         return $this->render('mouvement/Arret/index.html.twig', [
  86.             'motifs' => $pmotif,
  87.             'operations' => $operations,
  88.             'pemployes' => $pemployes,
  89.             'date' => $currentDate,
  90.         ]);
  92.     }
  94.     #[Route('/arret_traitement', name: 'app_mouvement_arret_traitement', options:['expose' => true])]
  95.     public function arret_traitement(Request $request): Response
  96.     {
  97.         $startDate = $request->get('datedebut');
  98.         $endDate = $request->get('datefin');
  99.         $dateRanges = $this->generateDateRange($startDate, $endDate);    
  100.         //   dd($dateRanges);
  101.       
  102.         // test period exist : 
  104. //         $arret = $this->em->getRepository(PArretTravail::class)->add_Arret($request);
  105. // // dd($request);
  107. //         $arret_lg = $this->em->getRepository(PArretTravailLg::class)->add_Arret_lg($request,$dateRanges,$arret);
  109.         return new JsonResponse($dateRanges);        
  110.        
  111.     }
  112.     
  113.     #[Route('/arret_traitement_verification', name: 'arret_traitement_verification', options:['expose' => true])]
  114.     public function arret_traitement_verification(Request $request): Response
  115.     {
  116.         $id_cnt = $request->get('id_emp_arret');
  117.         // $endDate = $request->get('datefin');
  118.         // $dateRanges = $this->generateDateRange($startDate, $endDate);    
  119.         // //   dd($dateRanges);
  120.     //   dd($request->get('editedData'));
  121.         // test period exist : 
  123.         foreach ($request->get('editedData') as  $sheet) {
  124.           
  125.            
  126.             $period_exist = $this->period_exist($id_cnt, $this->em);  
  127.             if ($period_exist) {
  128.     
  129.             foreach ($period_exist as $period) {
  130.                        
  131.                 if($sheet['period'] == $period['code']){
  133.                     $days = $sheet['days'] + $period['nbr'];
  134.                     if ($days > 26) {
  135.                         dd('error');
  136.                         $error = 1;
  137.                         $emp = $sheet[1];
  138.                         $prd = $period['code'];
  139.                     }
  140.                     
  141.                 }
  142.                 
  143.             }
  144.           }
  145.         }
  147.         $arret = $this->em->getRepository(PArretTravail::class)->add_Arret($request, $this->getUser());
  148.         $arret_lg = $this->em->getRepository(PArretTravailLg::class)->add_Arret_lg($request,$request->get('editedData'),$arret);
  149.         $this->em->flush();
  151.         return new JsonResponse($arret_lg);        
  152.        
  153.     }
  157. //     public function generateDateRange($startDate, $endDate, $sunday = null) {
  158. //     $currentPeriodeDate = new \DateTime();
  159. //     $currentPeriode = $currentPeriodeDate->modify('first day of this month');
  160. //     $date = new DateTime($startDate);
  161. //     $currentDate = new DateTime($startDate);   // 16-10-2023
  162. //     $currentDateFix = new DateTime($startDate);   // 16-10-2023
  163. //     $endDateFix = new DateTime($endDate);          // 07-11-2023
  164. //     $endDate = new DateTime($endDate);          // 07-11-2023
  165. //     $startDate = new DateTime($startDate);          // 07-11-2023
  166.    
  167. //     // dd($intervalOriginal);
  168. //     if((int)$startDate->format('m') < (int)$currentPeriode->format('m') && (int)$startDate->format('y') == (int)$currentPeriode->format('y')) {
  169. //         $interval = $currentDate->diff($currentPeriodeDate);
  170. //         // dd($interval->days);
  171. //         // dump($endDate);
  172. //         if((int)$endDate->format('m') < (int)$currentPeriode->format('m') && (int)$endDate->format('y') == (int)$currentPeriode->format('y')) {
  173. //             $interval = $currentDate->diff($endDate);
  174. //             $endDate = clone $currentPeriode;
  175. //         }
  176. //         $currentDate = clone $currentPeriode;
  177. //         // dd($currentDate, $endDate);
  178. //         $endDate->modify('+'.$interval->days.' day');
  179. //     }
  180. //     // dd($currentDate, $endDate);
  181. //     $dateRanges = [];
  182. //     $leftDays = 0;
  183. //     while ($currentDate <= $endDate) {
  184. //         $monthEndDate = clone $currentDate; // 16-10-2023
  185. //         $monthEndDateFix = clone $currentDateFix; // 16-10-2023
  186. //         $monthEndDate->modify('last day of this month'); // 31-10-2023
  187. //         $monthEndDateFix = clone $currentDateFix; // 16-10-2023
  189. //         if ($monthEndDate > $endDate) {
  190. //             $monthEndDate = $endDate;
  191. //         }
  193. //         $daysInMonth = 0;
  194. //         $daysInMonthFix = 0;
  196. //         $tmpDate = clone $currentDate;
  197. //         while ($tmpDate <= $monthEndDate) {
  198. //             if($sunday and $sunday == 1) {
  199. //                 $daysInMonth++;   
  200. //                 $tmpDate->modify('+1 day');
  201. //             } else {
  202. //                 if ($tmpDate->format('N') != 7) { // Exclude Sundays
  203. //                     $daysInMonth++;
  204. //                 }
  205. //                 $tmpDate->modify('+1 day');
  206. //             }
  207. //             $daysInMonthFix++;
  208. //         }
  210. //         $periode = $this->calculPaieService->getPeriode($currentDate->format('mY'));
  211. //         $period_my = $currentDate->format('mY');
  212. //         // $periode = $this->calculPaieService->getPeriode($currentDate->format('mY'));
  213. //         // $period_my = $currentDate->format('mY');
  214. //         if(($currentDate->format('m') == '02' && ((int)$startDate->format('m') < (int)$currentDate->format('m') or  $currentDate->format('j') == '1')  && (int)$currentDate->format('m') < (int)$endDate->format('m'))) {
  215. //             if($daysInMonth < 26 or $daysInMonth > 26) {
  216. //                 $daysInMonth = 26;
  217. //             }
  218. //         }
  219. //         elseif ($daysInMonth > 26) {
  220. //             $daysInMonth = 26;
  221. //         }
  222.       
  223. //         // dd($intervalOriginal);
  225. //         $dateRanges[] = [
  226. //             'start' => $currentDateFix->format('Y-m-d'),
  227. //             'end' => $monthEndDateFix->modify('+' . ($daysInMonthFix - 1). ' day')->format('Y-m-d'),
  228. //             'days' => $daysInMonth,
  229. //             'period' => $periode->getid(),
  230. //             'period_my' => $period_my,
  231. //         ];
  233. //         $currentDate->modify('first day of next month');
  234. //         $currentDateFix->modify('first day of next month');
  235. //         $date->modify('+1 month');
  237. //     }
  238. //     // die;
  240. //     return $dateRanges;
  241. // }
  242. public function generateDateRange($startDate, $endDate, $sunday = null) {
  243.     $checkStartDate = new DateTime($startDate);
  244.     $checkCurrentDate = new DateTime();
  245.     $checkStartDate->modify('first day of this month');
  246.     $checkCurrentDate->modify('first day of this month');
  247.     $checkStartDate = $checkStartDate->format('Y-m-d');
  248.     $checkCurrentDate = $checkCurrentDate->format('Y-m-d');
  249.     $date = new DateTime();
  250.     $currentDate = new DateTime($startDate);   // 16-10-2023
  251.     $endDate = new DateTime($endDate);          // 07-11-2023
  252.     $startDate = new DateTime($startDate);
  253.     $dateRanges = [];
  254.     $daysInMonthTotal = 0;
  255.     $periode = $this->calculPaieService->getPeriode($date->format('mY'));
  256.     $period_my = null;
  258.     
  259.     while ($currentDate <= $endDate) {
  260.         $realDate = clone $currentDate; // 16-10-2023
  261.         $monthEndDate = clone $currentDate; // 16-10-2023
  262.         $monthEndDate->modify('last day of this month'); // 31-10-2023
  264.         if ($monthEndDate > $endDate) {
  265.             $monthEndDate = $endDate;
  266.         }
  268.         $daysInMonth = 0;
  270.         $tmpDate = clone $currentDate;
  271.         while ($tmpDate <= $monthEndDate) {
  272.             if($sunday and $sunday == 1) {
  273.                 $daysInMonth++;   
  274.                 $tmpDate->modify('+1 day');
  275.             } else {
  276.                 if ($tmpDate->format('N') != 7) { // Exclude Sundays
  277.                     $daysInMonth++;
  278.                 }
  279.                 $tmpDate->modify('+1 day');
  280.             }
  281.         }
  283.         // $periode = $this->calculPaieService->getPeriode($currentDate->format('mY'));
  284.         // $period_my = $currentDate->format('mY');
  285.         
  286.         if(($currentDate->format('m') == '02' && ((int)$startDate->format('m') < (int)$currentDate->format('m') or  $currentDate->format('j') == '1')  && (int)$currentDate->format('m') < (int)$endDate->format('m'))) {
  287.             if($daysInMonth < 26 or $daysInMonth > 26) {
  288.                 $daysInMonth = 26;
  289.             }
  290.         }
  291.         elseif ($daysInMonth > 26) {
  292.             $daysInMonth = 26;
  293.         }
  294.         // dump($daysInMonth);
  296.         // dd($checkCurrentDate > $checkStartDate);
  297.         $break = 0;
  298.         if($checkCurrentDate > $checkStartDate) {
  299.             if(($daysInMonthTotal + $daysInMonth) > 26) {
  300.                 if($daysInMonth > $daysInMonthTotal) {
  301.                     if($daysInMonth < 26) {
  302.                         $rest = ($daysInMonth - $daysInMonthTotal )+ (26 - $daysInMonth);
  303.                         $daysInMonth = $daysInMonth - $rest;
  304.                     } else {
  305.                         $rest = $daysInMonth - $daysInMonthTotal;
  306.                         $daysInMonth = $daysInMonth - $rest;
  307.                     }
  308.                    
  309.                 } else {
  310.                     // dd($daysInMonth, $daysInMonthTotal);
  311.                     $rest = 26 - $daysInMonthTotal;
  312.                     if($rest == 0) {
  313.                         $break = 1;
  314.                     }
  315.                     $daysInMonth = $daysInMonth - $rest;
  316.                 }
  317.                 $daysInMonthTotal = 0;
  318.                 // dd($realDate, $rest);
  319.                 if($break == 0) {
  320.                     $dateRanges[] = [
  321.                         'start' => $realDate->format('Y-m-d'),
  322.                         'end' => ($sunday and $sunday == 1) ? $this->addDays($realDate, $rest - 1 , 1)->format('Y-m-d') : $this->addDays($realDate, $rest - 1)->format('Y-m-d'),
  323.                         'days' => $rest,
  324.                         'period' => $periode->getid(),
  325.                         'period_my' => $period_my,
  326.                     ];
  327.                     $realDate->modify('+1 day');
  328.                 }
  329.                 $date->modify('+1 month');
  330.                 // dd($realDateEnd);
  331.                 
  332.                 // $startRealDate->modify('+1 day');
  333.             }
  334.             $daysInMonthTotal += $daysInMonth;
  335.         }
  337.         
  338.        
  339.         // dd($daysInMonthTotal);
  340.         $periode = $this->calculPaieService->getPeriode($date->format('mY'));
  341.         $period_my = $date->format('mY');
  344.         $dateRanges[] = [
  345.             'start' => $realDate->format('Y-m-d'),
  346.             'end' => $monthEndDate->format('Y-m-d'),
  347.             'days' => $daysInMonth,
  348.             'period' => $periode->getid(),
  349.             'period_my' => $period_my,
  350.         ];
  352.         // $realDate->modify('+1 day');
  353.         // dd($dateRanges);
  355.         $currentDate->modify('first day of next month');
  356.         if($checkCurrentDate <= $checkStartDate) {
  357.             $date->modify('+1 month');
  358.         }
  359.     }
  360.     // die;
  362.     // $mergedData = [];
  364.     // foreach ($dateRanges as $item) {
  365.     //     $period_my = $item["period_my"];
  367.     //     if (!isset($mergedData[$period_my])) {
  368.     //         // If the period_my is not already in the merged array, add it
  369.     //         $mergedData[$period_my] = $item;
  370.     //     } else {
  371.     //         // If the period_my is already in the merged array, update the "end" and "days" values
  372.     //         $mergedData[$period_my]["end"] = $item["end"];
  373.     //         $mergedData[$period_my]["days"] += $item["days"];
  374.     //     }
  375.     // }
  376.     // $mergedData = array_values($mergedData);
  378.     // dd($mergedData);
  380.     return $dateRanges;
  381. }
  383.     public function period_exist($emp_id,$em) {
  384.         $query = "SELECT SUM(parret_travail_lg.nombre_jour) as nbr,periode.id,periode.code as code 
  385.         FROM `parret_travail_lg` 
  386.                     INNER JOIN parret_travail ON parret_travail_lg.arret_travail_id=parret_travail.id
  387.                     INNER JOIN lcontract ON lcontract.id=parret_travail.contract_id
  388.                     INNER JOIN periode ON periode.id=parret_travail_lg.periode_id 
  389.                     where lcontract.id=$emp_id and parret_travail.active = 1 and parret_travail_lg.active = 1  group BY periode.id";
  390.                         $stmt = $em->getConnection()->prepare($query);
  391.                         $newstmt = $stmt->executeQuery();   
  392.                         $result = $newstmt->fetchAll();
  393.                         // dd($result);
  394.         return $result;
  395.                     
  397.     }
  399. //       public function generateDateRange($startDate, $endDate) {
  400. //     $currentDate = new DateTime($startDate);
  401. //     $endDate = new DateTime($endDate);
  403. //     $dateRanges = [];
  405. //     while ($currentDate <= $endDate) {
  406. //         $monthEndDate = clone $currentDate;
  407. //         $monthEndDate->modify('last day of this month');
  409. //         if ($monthEndDate > $endDate) {
  410. //             $monthEndDate = $endDate;
  411. //         }
  413. //         // Calculate the number of days excluding Sundays
  414. //         $daysInMonth = 0;
  415. //         while ($currentDate <= $monthEndDate) {
  416. //             if ($currentDate->format('N') != 7) { // Exclude Sunday (7)
  417. //                 $daysInMonth++;
  418. //             }
  419. //             $currentDate->modify('+1 day');
  420. //         }
  422. //         // Check if the days in the month exceed 26, if so, move to the next period
  423. //         if ($daysInMonth > 26) {
  424. //             // You need to determine how many days to move to the next period
  425. //             $daysToMove = $daysInMonth - 26;
  426. //             // Adjust the $endDate accordingly
  427. //             $endDate->modify('+' . $daysToMove . ' days');
  428. //         }
  430. //         // Get the period for the current month
  431. //         $periode = $this->calculPaieService->getPeriode($currentDate->format('mY'));
  433. //         $dateRanges[] = [
  434. //             'start' => $currentDate->format('Y-m-d'),
  435. //             'end' => $monthEndDate->format('Y-m-d'),
  436. //             'days' => $daysInMonth,
  437. //             'period' => $periode->getid(),
  438. //         ];
  440. //         // Move to the next month
  441. //         $currentDate->modify('first day of next month');
  442. //     }
  444. //     return $dateRanges;
  445. // }
  447.     // }
  448.    
  449.  
  450. #[Route('/arret_canvas', name: 'app_mouvement_arret_mass_canvas', options:['expose' => true])]
  452. public function epreuveCanvas() {
  453.     $spreadsheet = new Spreadsheet();
  454.     $sheet = $spreadsheet->getActiveSheet();
  455.     $sheet->setCellValue('A1', 'ID_Motif');
  456.     $sheet->setCellValue('B1', 'Id_Contract');
  457.     $sheet->setCellValue('C1', 'Date arret');
  458.     $sheet->setCellValue('D1', 'Fin Previsionnelle');
  459.     $sheet->setCellValue('E1', 'Reprise de travail ');
  460.   
  462.     $writer = new Xlsx($spreadsheet);
  463.     $fileName = 'canvas_arret.xlsx';
  464.     $temp_file = tempnam(sys_get_temp_dir(), $fileName);
  465.     $writer->save($temp_file);
  467.     return $this->file($temp_file, $fileName, ResponseHeaderBag::DISPOSITION_INLINE);
  468. }
  469. #[Route('/app_mouvement_arret_mass_canvas_retard', name: 'app_mouvement_arret_mass_canvas_retard', options:['expose' => true])]
  471. public function app_mouvement_arret_mass_canvas_retard() {
  472.     $spreadsheet = new Spreadsheet();
  473.     $sheet = $spreadsheet->getActiveSheet();
  474.     $sheet->setCellValue('A1', 'Id_Contract');
  475.     $sheet->setCellValue('B1', 'Nombre de jours');
  476.   
  478.     $writer = new Xlsx($spreadsheet);
  479.     $fileName = 'canvas_retard.xlsx';
  480.     $temp_file = tempnam(sys_get_temp_dir(), $fileName);
  481.     $writer->save($temp_file);
  483.     return $this->file($temp_file, $fileName, ResponseHeaderBag::DISPOSITION_INLINE);
  484. }
  485. #[Route('/arret_canvas_motif', name: 'app_mouvement_arret_mass_canvas_motif', options:['expose' => true])]
  487. public function epreuveCanvas_motif() {
  488.   
  489.    
  490.     $count = 0;
  491.     $spreadsheet = new Spreadsheet();
  492.     $sheet = $spreadsheet->getActiveSheet();
  493.     $sheet->setCellValue('A1', 'ID_Motif');
  494.     $sheet->setCellValue('B1', 'Designation');
  495.     $i=2;
  496.     $pmotifs = $this->em->getRepository(PMotif::class)->findBy(['active' => 1]);
  497.     
  498.     foreach ($pmotifs as $motif) {
  499.                   
  500.         $sheet->setCellValue('A'.$i, $motif->getId());
  501.         $sheet->setCellValue('B'.$i, $motif->getDesignation());
  502.     
  503.         $i++;
  504.         $count++;
  505.     }
  506.   
  508.     $writer = new Xlsx($spreadsheet);
  509.     $fileName = 'canvas_Motif.xlsx';
  510.     $temp_file = tempnam(sys_get_temp_dir(), $fileName);
  511.     $writer->save($temp_file);
  513.     return $this->file($temp_file, $fileName, ResponseHeaderBag::DISPOSITION_INLINE);
  514. }
  516. #[Route('/upload_arret', name: 'app_mouvement_arret_mass_upload', options: ['expose' => true])]
  517.     public function app_mouvement_arret_mass_upload(Request $request ): Response
  518.     {
  519.         // $dossier = $this->em->getRepository(PDossier::class)->find($request->get('dossier'));
  520.         $dossier = $request->getSession()->get('dossier');
  521.         $error = 0;
  522.         $prd = '';
  523.         $reader = new Reader();
  524.         $spreadsheet = $reader->load($request->files->get('file'));
  525.         $reader->setReadDataOnly(true); 
  526.         $reader->setReadEmptyCells(false);
  527.         $period = $request->get('period');
  528.         $worksheet = $spreadsheet->getActiveSheet();
  529.         $spreadSheetArys = $worksheet->toArray();
  531.         unset($spreadSheetArys[0]);
  532.         $array = [];
  533.         // dd($spreadSheetArys);
  534.         $count = 0;
  535.         foreach ($spreadSheetArys as $key => $sheet) {
  536.       
  537.             $startDate = new \DateTime($sheet[2]);
  538.             $startDate = $startDate->format('Y-m-d');
  539.             // $parsedDate = strtotime($startDate);
  540.             // if ($parsedDate !== false) {
  541.             // }
  542.             $endDate = new \DateTime($sheet[3]);
  543.             $endDate = $endDate->format('Y-m-d');
  544.             // $parsedDate = strtotime($endDate);
  545.             // if ($parsedDate !== false) {
  546.             // }
  547.             // if($sheet[1] == 1910) {
  548.             //     dd($startDate, $endDate);
  549.             // }
  550.             $dateRanges = $this->generateDateRange($startDate, $endDate, $sheet[5]);  
  551.             // dd($dateRanges);
  552.             $period_exist = $this->period_exist($sheet[1], $this->em);  
  553.             if ($period_exist) {
  554.                 foreach ($period_exist as $period) {
  555.                         foreach ($dateRanges as $date) {
  556.                         
  557.                             if($date['period'] == $period['id']){
  559.                                 $days = $date['days'] + $period['nbr'];
  561.                                 if ($days > 26) {
  562.                                     $error = 1;
  563.                                     $emp = $sheet[1];
  564.                                     $prd = $period['code'];
  565.                                 }
  566.                                 
  567.                             }
  568.                             
  569.                         }
  570.                 }
  571.             }
  573.             $motif = $this->em->getRepository(PMotif::class)->find($sheet[0]);
  575.             if (!$motif) {
  576.                 $error = 2;
  577.             }
  579.         }
  580.         if($error == 0){
  581.             // dd($spreadSheetArys);
  582.             foreach ($spreadSheetArys as $key => $sheet) {
  583.                 $newArray = [];
  584.             
  585.             
  586.                 $newArray = new ParameterBag([
  587.                     "id_emp_arret" => $sheet[1], // Combine elements 0 and 1
  588.                     "motif_id" => $sheet[0], // Element 2
  589.                     "datedebut" => date('Y-m-d', strtotime($sheet[2])), // Format date for element 3
  590.                     "datefin" => date('Y-m-d', strtotime($sheet[3])), // Format date for element 4
  591.                     "datereprise" => date('Y-m-d', strtotime($sheet[4])), 
  592.                 ]);
  594.                 $startDate = $sheet[2];
  595.                 $endDate = $sheet[3];
  596.                 $dateRanges = $this->generateDateRange($startDate, $endDate, $sheet[5]);  
  597.                 $period_exist = $this->period_exist($newArray->get('id_emp_arret'), $this->em);  
  598.                 
  599.                 $arret = $this->em->getRepository(PArretTravail::class)->add_Arret($newArray, $this->getUser());
  600.                 // if(count($dateRanges) == 0) {
  601.                 //     dd($dateRanges, $sheet[1], date('Y-m-d', strtotime($sheet[2])), date('Y-m-d', strtotime($sheet[3])));
  602.                 // } 
  603.                 $arretlg = $this->em->getRepository(PArretTravailLg::class)->add_Arret_lg($newArray,$dateRanges,$arret);
  605.                 }
  607.                 $this->em->flush();
  609.             }
  610.         else if($error == 2){
  611.             return new JsonResponse('Motif ID '. $sheet[0] .' n\'existe pas.', 500);
  612.         }
  613.         else{
  614.             // dd($employe->getcode());
  615.             return new JsonResponse('L employe avec le matricule'.$emp.' a plusieurs de 26 jrs periode  '.$prd, 500);
  617.         }
  621.         return new JsonResponse('ok');
  622.     }
  623. #[Route('/app_mouvement_arret_mass_upload_retard', name: 'app_mouvement_arret_mass_upload_retard', options: ['expose' => true])]
  624.     public function app_mouvement_arret_mass_upload_retard(Request $request ): Response
  625.     {
  626.         $reader = new Reader();
  627.         $spreadsheet = $reader->load($request->files->get('file'));
  628.         $periode = $request->get('period');
  629.         $date = new \DateTime($periode);
  630.         $periode = $this->calculPaieService->getPeriode($date->format('mY'));
  631.         $worksheet = $spreadsheet->getActiveSheet();
  632.         $spreadSheetArys = $worksheet->toArray();
  633.         unset($spreadSheetArys[0]);
  634.         // dd($spreadSheetArys);
  635.         $motif = $this->em->getRepository(PMotif::class)->find(13);
  636.         foreach ($spreadSheetArys as $key => $sheet) {
  637.             $contract = $this->em->getRepository(LContract::class)->findOneBy(['id' => $sheet[0], 'active' => true]);
  638.             if(!$contract) {
  639.                 return new JsonResponse('Contrat introuvable à la ligne '.($key + 1).' !', 500);                
  640.             } 
  641.             $arretTravail = new PArretTravail();
  642.             $arretTravail->setContract($contract);
  643.             $arretTravail->setMotif($motif);
  645.             $this->em->persist($arretTravail);
  646.             
  647.             $arretTravailLg = new PArretTravailLg();
  648.             $arretTravailLg->setArretTravail($arretTravail);
  649.             $arretTravailLg->setPeriode($periode);
  650.             $arretTravailLg->setNombreJour($sheet[1]);
  651.             
  652.             $this->em->persist($arretTravailLg);
  653.             
  654.         }
  655.         $this->em->flush();
  657.         return new JsonResponse('Bien enregistrer');
  658.     }
  660.     
  661.     #[Route('/parret_aff', name: 'app_parret_aff', options: ['expose' => true])]
  662.     public function app_parret_aff(Request $request): Response
  663.     {
  664.         $draw = $request->query->get('draw');
  665.         $start = $request->query->get('start') ?? 0;
  666.         $length = $request->query->get('length') ?? 10;
  667.         $search = $request->query->all('search')["value"];
  668.         $orderColumnIndex = $request->query->all('order')[0]['column'];
  669.         $orderColumn = $request->query->all("columns")[$orderColumnIndex]['name'];
  670.         $orderDir = $request->query->all('order')[0]['dir'] ?? 'asc';
  671.         $dossier = $request->getSession()->get('dossier');
  672.         // dd($dossier);
  674.         $queryBuilder = $this->em->createQueryBuilder()
  675.         ->select('a.id as arret_id,p.id as employe_id,p.nom,p.prenom,
  676.         p.code as matricule,m.designation as motif,a.DateDebut as date_debut,a.dateFin as date_fin,a.dateReprise as date_rep')
  677.         ->from(PArretTravail::class, 'a')
  678.         ->innerJoin('a.contract', 'c')
  679.         ->innerJoin('c.employe', 'p')
  680.         ->innerJoin('a.motif', 'm')
  681.         ->Where('a.active = 1')
  682.         ->andWhere('c.dossier = :dossier')
  683.         ->setParameter('dossier', $dossier);
  684.       
  685.         if (!empty($search)) {
  686.             $queryBuilder->andWhere('(a.id LIKE :search OR p.id LIKE :search OR m.designation LIKE :search OR p.nom LIKE :search OR p.prenom LIKE :search
  687.              OR  a.DateDebut LIKE :search OR a.dateFin LIKE :search OR a.dateReprise LIKE :search OR p.code LIKE :search)')
  688.                 ->setParameter('search', "%$search%");
  689.         }
  691.         if (!empty($orderColumn)) {
  692.             $queryBuilder->orderBy("$orderColumn", $orderDir);
  693.         }
  694.         $filteredRecords = count($queryBuilder->getQuery()->getResult());
  696.         // Paginate results
  697.         $queryBuilder->setFirstResult($start)
  698.             ->setMaxResults($length);
  700.         $results = $queryBuilder->getQuery()->getResult();
  701.     // dd($results);
  702.         
  703.         // dd($results);
  704.         $totalRecords = $this->em->createQueryBuilder()
  705.         ->select('COUNT(a.id)')
  706.         ->from(PArretTravail::class, 'a')
  707.         ->innerJoin('a.contract', 'c')
  708.         ->innerJoin('c.employe', 'p')
  709.         ->innerJoin('a.motif', 'm')
  710.         ->Where('a.active = 1')
  711.         ->andWhere('c.dossier = :dossier')
  712.         ->setParameter('dossier', $dossier)
  713.         ->getQuery()
  714.         ->getSingleScalarResult();
  716.         return new JsonResponse([
  717.             'draw' => $draw,
  718.             'recordsTotal' => $totalRecords,
  719.             'recordsFiltered' => $filteredRecords,
  720.             'data' => $results,
  721.         ]);
  722.     }
  725.     #[Route('/parret_aff_details/{code}', name: 'app_parret_aff_details', options: ['expose' => true])]
  726.     public function app_parret_aff_details($code): Response
  727.     {
  728.         // dd($code)
  729.         $arret = $this->em->getRepository(PArretTravail:: class)->find(['id' => $code]);
  730.         // dd($arret->getActiveArretTravailLgs());
  731.         $html = $this->renderView('mouvement/Arret/includes/arret_detail.html.twig', ['arret' => $arret, 'arretLgs' => $arret->getArretTravailLgs()]);
  732.         // $html = $this->renderView('mouvement/Arret/includes/arret_detail.html.twig', ['arret' => $arret, 'arretLgs' => $arret->getActiveArretTravailLgs()]);
  734.        return new JsonResponse($html);
  735.         
  736. }
  738.    
  740.     #[Route('/parret_lg_desactiver/{code}', name: 'app_parret_lg_desactiver', options: ['expose' => true])]
  741.     public function app_parret_lg_desactiver($code): Response
  742.     {
  743.         // dd($code)
  744.         $arret = $this->em->getRepository(PArretTravailLg:: class)->desactiver($code, $this->getUser());
  745.         // dd($arret->getActiveArretTravailLgs());
  746.         // $html = $this->renderView('mouvement/Arret/includes/arret_detail.html.twig', ['arret' => $arret, 'arretLgs' => $arret->getActiveArretTravailLgs()]);
  748.        return new JsonResponse($arret);
  749.         
  750.     }
  751.     function addDays($start_date, $days_to_add, $sunday = null) {
  752.         $current_date = $start_date;
  753.         // $interval = new \DateInterval('P1D');  // P1D represents a period of 1 day
  754.         // dd($sunday);
  755.         // $i = 1;
  756.         while ($days_to_add > 0) {
  757.             if(is_null($sunday)) {
  758.                 if( $current_date->format('N') != 7) {
  759.                     $days_to_add--;
  760.                 }
  761.             } else {
  762.                 
  763.                 $days_to_add--;
  764.             }
  765.             // if ($current_date->format('N') != 7 && is_null($sunday)) {  // Check if it's not a Sunday (Monday is 1, Sunday is 7)
  766.             //     $days_to_add--;
  767.             // }
  768.             // dd($days_to_add);     
  769.             $current_date->modify('+1 day');
  771.             if ($current_date->format('N') == 7 && is_null($sunday) && $days_to_add == 0) {
  772.                 $current_date->modify('+1 day');
  773.             }
  774.         }
  775.         // dd($i, $originalDays);
  776.         return $current_date;
  777.     }
  779.    
  780. }