1. <?php
3. namespace App\Controller\Admin;
5. use EasyCorp\Bundle\EasyAdminBundle\Config\Dashboard;
6. use EasyCorp\Bundle\EasyAdminBundle\Config\MenuItem;
7. use EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractDashboardController;
8. use Symfony\Component\HttpFoundation\Response;
9. use Symfony\Component\Routing\Annotation\Route;
10. use Aws\S3\S3Client;
11. use Symfony\Component\Uid\Uuid;
12. use Doctrine\Persistence\ManagerRegistry;
13. use Symfony\Component\HttpFoundation\Request;
14. use App\Entity\Caixa;
15. use App\Entity\Documento;
16. use App\Entity\Tipo;
17. use App\Entity\Classificacao;
18. use App\Entity\Cliente;
19. use App\Entity\User;
20. use App\Entity\Cx;
21. use App\Entity\ClienteAll;
22. use App\Entity\Registro;
23. use App\Entity\Fluxo;
24. use App\Entity\Etapa;
25. use App\Entity\MessengerMessages;
26. use Doctrine\ORM\EntityManagerInterface;
27. use setasign\Fpdi\Tcpdf\Fpdi;
28. use setasign\Fpdi\PdfReader;
29. use propa\tcpdi\tcpdi;
30. use Symfony\Component\Dotenv\Dotenv;
31. use Symfony\Component\HttpFoundation\Session\SessionInterface;
32. use Symfony\Component\String\Slugger\AsciiSlugger;
33. use App\Form\UploadType;
34. use PhpOffice\PhpSpreadsheet\IOFactory;
35. use Symfony\Component\Mime\Email;
36. use Symfony\Component\Mailer\MailerInterface;
37. use Knp\Component\Pager\PaginatorInterface;
38. use Dompdf\Dompdf;
39. use Dompdf\Options;
40. use Endroid\QrCode\Builder\Builder;
41. use Endroid\QrCode\Encoding\Encoding;
42. use Twig\Environment;
43. use PhpOffice\PhpSpreadsheet\Spreadsheet;
44. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
45. use PhpOffice\PhpSpreadsheet\Shared\Date;
46. use PhpOffice\PhpSpreadsheet\Style\Color;
47. use PhpOffice\PhpSpreadsheet\Style\Fill;
48. use Endroid\QrCode\ErrorCorrectionLevel\ErrorCorrectionLevelHigh;
49. use Endroid\QrCode\Writer\PngWriter;
50. use App\Message\UploadMultipartMessage;
51. use Symfony\Component\Messenger\MessageBusInterface;
52. use Symfony\Component\HttpFoundation\JsonResponse; 
53. use DateTime;
57. class DashboardController extends AbstractDashboardController
58. {
59.     
60.     #[Route('/', name: 'inicial')]
61.     public function home(): Response
62.     {
63.         
64.         return $this->redirectToRoute('home');
67.     }
68.     
69.     #[Route('/login_sucess', name: 'login_sucess')]
70.     public function login_sucess(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager): Response
71.     {
72.         
73.     
74.         $user_logado = $this->getUser();
75.         $enabled = $user_logado->getEnabled();
77.         if (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) {
78.             $ip_cliente = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR'])[0];
79.         } else {
80.             $ip_cliente = $_SERVER['REMOTE_ADDR'];
81.         }
82.         
83.           if($enabled == false){
85.             $error ="Tentativa de login de usuário desativado";
86.             $user_logado_nome=$user_logado->getNome();
87.             $hoje = new \DateTimeImmutable('America/Sao_Paulo');
88.             $registro = new Registro();
89.             $registro->setOperacao($error);
90.             $registro->setUser($user_logado_nome);
91.             $registro->setData($hoje);
92.             $registro->setIp($ip_cliente);
93.             $entityManager->persist($registro);
94.             $entityManager->flush();
96.             return $this->redirectToRoute('app_logout');
97.         }
98.         
99.         
100.         
101.         
102.         $error ="Login Realizado";
103.         $user_logado_nome=$user_logado->getNome();
104.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
105.         $registro = new Registro();
106.         $registro->setOperacao($error);
107.         $registro->setUser($user_logado_nome);
108.         $registro->setData($hoje);
109.         $registro->setIp($ip_cliente);
110.         $entityManager->persist($registro);
111.         $entityManager->flush();
112.         
113.       
114.         
115.         
116.         
117.         
118.         
119.         return $this->redirectToRoute('home');     
121.     }
122.     
123.     #[Route('/index/home', name: 'home')]
124.     public function inicial(PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer): Response
125.     {
126.         $user_logado = $this->getUser();
127.         $user_logado_id = $user_logado->getId();
128.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
129.         $erro = '';
130.         $pagina = 'home';
131.         $p ='';
132.         
133.         $etapas  = null;
137.         if(isset($_POST["btn_cliente"])){
138.             
139.             $session->set('cliente_id', $_POST["btn_cliente"]);
140.             return $this->redirectToRoute('home');
141.         }
144.         
145.         $clienteId = $session->get('cliente_id');
146.         
147.         $etapas = $doctrine->getRepository(Etapa::class)->findByUserAndUpdatedAt($user_logado);
148.         
149.        
150.         return $this->render('index/index6.html.twig', [
151.     
152.             
153.             'p'=>$p,
154.             'erro'=>$erro,
155.             'pagina' => $pagina,
156.             'etapas'=>$etapas,
157.             'cliente' => $cliente,
158.             'clienteId' => $clienteId
159.             
160.             
162.         ]);
163.     } 
165.     #[Route('/index/troca', name: 'troca')]
166.     public function troca(SessionInterface $session): Response
167.     {
168.        
169.         $session->remove('cliente_id');
170.         $session->invalidate();
172.         return $this->redirectToRoute('home');
175.     }
177.     #[Route('/index/export', name: 'export')]
178.     public function export(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session,MessageBusInterface $bus): Response
179.     {
180.         
181.         
182.         $pendingMessages = $entityManager->getRepository(MessengerMessages::class)->countPendingMessages();
183.         
184.         #dd($pendingMessages);
185.         
186.         $user_logado = $this->getUser();
187.         $user_logado_id = $user_logado->getId();
188.         $userId = $user_logado_id;
189.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
190.         $dotenv = new Dotenv();
191.         $dotenv->load(__DIR__.'/.env');
192.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
193.         $hoje_formt=$hoje->format('Y-m-d') ;
194.         $doc = $entityManager->getRepository(Documento::class)->findByUserAndDate($user_logado_id, $hoje_formt);
195.         $dia_prod = 'de hoje';
197.         
198.    
199.         if(isset($_POST["date_perio"])){
200.             
201.             
202.             $startDate = $_POST["de"];
203.             $endDate = $_POST["ate"];
204.        
205.             $de = new \DateTimeImmutable($startDate);
206.             $ate = new \DateTimeImmutable($endDate);
207.             $de_formt=$de->format('d/m/Y') ;
208.             $ate_formt=$ate->format('d/m/Y') ;
209.             
210.             if($endDate != ""){ 
211.                 
212.                 $doc = $entityManager->getRepository(Documento::class)->findByUserAndDateRange($user_logado_id, $startDate, $endDate);
213.                 $dia_prod = 'de '. $de_formt.' até '.$ate_formt; 
214.             
215.             }
216.             if($endDate == ""){ 
217.                 
218.                 $doc = $entityManager->getRepository(Documento::class)->findByUserAndDate($user_logado_id, $startDate);
219.                 $dia_prod = 'de '. $de_formt; 
220.             }
221.             
222.             
224.         }
225.         
226.         if(isset($_POST["btn_cliente"])){
227.             
228.             $session->set('cliente_id', $_POST["btn_cliente"]);
229.             return $this->redirectToRoute('home');
230.         }
233.         $clienteId = $session->get('cliente_id');
234.         
235.         
236.         
237.         if ($clienteId == null ) {
238.             
239.             $caixas =  "";
240.             $index_all ="";
241.             $documentos="";
242.             $cliente_session = "";
243.             $cliente_alls = "";
244.        
245.         } else {
246.             $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $clienteId]);
247.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
248.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null ,'cliente' => $clienteId]);
249.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
250.             $cliente_alls = $cliente_session->getClienteAll()->getId();
251.         }
253.         $erro = '';
254.         $ii=0;
255.         $pagina = 'export';
256.         $p = '';
257.         $link = '';
258.         $mx = 0;
259.         $xy = 0 ; 
260.         $yz = 0 ; 
261.         $ay = 0 ;
262.         $ky = 0 ;
263.         $pdf ='';
264.         $pagina_h4 ='Documento(s) para indexar';
265.         $nome_menu_ = '';
266.         $index_tipo='';
267.         
268.         $user = $this->getUser();
269.         $user_nome= $user->getEmail();
270.         $user_nome_name= $user->getNome();
271.         $pasta_user=$user_nome.'/';
272.         $arr = [];
273.         $arrr=0;
274.         $index_find = null;
275.         $dt = '';
276.         $clientS3 = new  S3Client([
277.             'region'  => 'sa-east-1',
278.             'version' => 'latest',
279.             'credentials' => [ 
280.                 'key'    => $_ENV['AWS_KEY'],
281.                 'secret' => $_ENV['AWS_SECRET'],
282.             ],
283.         ]);
284.         
285.        if (isset($_POST["botao_export"])) {
286.             $caixaId = $_POST["caixas"];
287.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($_POST["caixas"]);
288.             $cliente_id = $doctrine->getRepository(Cliente::class)->find($clienteId);
289.             $clientes_status= $cliente_id->getExtraFields();
290.             if(!$clientes_status){
291.                 $clientes_status="ged";
292.             }
293.             $cliente_nome = $cliente_id->getNome();
294.             $clientes = $cliente_id->getId();
295.             $conteiner = $_POST["conteiner"];
296.             $cont_file = 0;
297.             $umlautString = $cliente_nome;
298.             $slugger = new AsciiSlugger();
299.             $teste = $slugger->slug($umlautString, $seperator = '-')->toString();
300.             $caminho = strtolower($teste . '/');
301.             if ($clientes == 14) { $caminho = 'cartorio-1deg-oficio-de-volta-redonda-rj/'; }
302.             if ($clientes == 83) { $caminho = 'casf-corretora-apolice-diversos/'; }
303.             if ($clientes == 35) { $caminho = 'pmecj-sp-saude/'; }
304.             if ($clientes == 107) { $caminho = 'pmecj-sp-execucao-fiscal/'; }
305.             if ($clientes == 4) { $caminho = 'cartorio-souza-reis-barra-mansa/'; }
306.             if ($clientes == 112) { $caminho = 'saae-cartao-de-ponto/'; }
307.             if ($clientes == 15) { $caminho = 'cbsi-dossies/'; }
308.             if ($clientes == 55) { $caminho = 'casf-gerep-contratos-de-prestadores-de-saude-pj/'; }
309.             if ($clientes == 13) { $caminho = 'casa-de-saude-santa-maria-c-s-s.M/'; }
310.             if ($clientes == 40) { $caminho = 'fasf-atas-e-diarios/'; }
311.         
312.             $filesTmp  = $_FILES['file']['tmp_name'];
313.             $filesName = $_FILES['file']['name'];
314.             
315.             foreach ($filesTmp as $index => $file) {
316.             
317.                 $uuid = Uuid::v4();
318.                 $cont_file++;
319.                 
320.                 
321.                 // nome original do arquivo
322.                 $originalName = pathinfo($filesName[$index], PATHINFO_FILENAME);
323.                 
324.                 // sanitiza o nome (remove acentos, espaços estranhos etc.)
325.                 $slugger = new AsciiSlugger();
326.                 $safeName = strtolower($slugger->slug($originalName)->toString());
327.                 
329.                 // 🔹 Se cliente for local, usa nome original
330.                 if ($clientes_status === 'local') {
331.             
332.             
333.                     $filename = $safeName . '.pdf';
334.             
335.                 } else {
336.                     if ($cliente_alls === 42) {
337.                          $filename = $originalName . '.pdf';
338.                     }else{
339.                         $filename = $uuid . '.pdf';
340.                     }
341.                 }
342.             
343.                 $tempDir = __DIR__ . '/../../var/uploads/messenger';
344.                 if (!is_dir($tempDir)) {
345.                     mkdir($tempDir, 0777, true);
346.                 }
347.             
348.                 $tempFilePath = $tempDir . '/' . $filename;
349.             
350.                 move_uploaded_file($file, $tempFilePath);
351.                 chmod($tempFilePath, 0644);
352.                 if (!file_exists($tempFilePath) || filesize($tempFilePath) === 0) {
353.                     throw new \RuntimeException(
354.                         'Falha ao gravar PDF temporário: ' . $tempFilePath
355.                     );
356.                 }
357.                 
358.                 // evita race condition de filesystem
359.                 clearstatcache(true, $tempFilePath);
360.                 
361.                 
362.                 
364.                 
365.                 $bus->dispatch(new UploadMultipartMessage(
366.                     $tempFilePath,
367.                     $filename,
368.                     $caminho,
369.                     '',
370.                     $caixaId,
371.                     $clienteId,
372.                     $userId,
373.                     0,
374.                     $conteiner,
375.                     $clientes,
376.                     $clientes_status,
377.                     $safeName,
378.                     $originalName,
379.                     $cliente_alls
380.                 ));
381.             }
382.         
383.             $log = new Registro();
384.             $log->setOperacao('EXPORTOU ' . $cont_file . ' DOCUMENTO(S)');
385.             $log->setUser($user_nome_name);
386.             $log->setCliente($cliente_nome);
387.             $entityManager->persist($log);
388.             $entityManager->flush();
389.         
390.             return $this->redirectToRoute('export');
391.         }
392.       
393.         return $this->render('index/index.html.twig', [
394.             'documentos' => $documentos,
395.             'xy' => $xy,
396.             'yz' => $yz,
397.             'ay'=>$ay,
398.             'link' => $link,
399.             'pdf'=>$pdf,
400.             'p'=>$p,
401.             'erro'=>$erro,
402.             'index_all'=>$index_all,
403.             'index_tipo'=>$index_tipo,
404.             'ky'=>$ky,
405.             'pagina' => $pagina,
406.             'pagina_h4' =>$pagina_h4,
407.             'index_find'=>$index_find,
408.             'mx'=>$mx,
409.             'caixas' => $caixas,
410.             'user_logado' => $user_logado,
411.             'cliente' => $cliente,
412.             'cliente_session' => $cliente_session,
413.             'doc'=>$doc,
414.             'dia_prod' => $dia_prod
415.         ]);
416.     }
417.     
418.     #[Route('/index/planilha', name: 'planilha')]
419.     public function planilha(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session): Response
420.     {
421.         
422.       
423.         $form = $this->createForm(UploadType::class);
424.         $user_logado= $this->getUser();
425.         $user_logado_id = $user_logado->getId();
426.         $user_nome_name= $user_logado->getNome();
427.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
428.         $form->handleRequest($request);
429.         $dotenv = new Dotenv();
430.         $dotenv->load(__DIR__.'/.env');
431.         $erro = '';
432.         $excel = 0;
433.         $pagina = 'index';
434.         $p = '';
435.         $clientS3 = new  S3Client([
436.             'region'  => 'sa-east-1',
437.             'version' => 'latest',
438.             'credentials' => [ 
439.                 'key'    => $_ENV['AWS_KEY'],
440.                 'secret' => $_ENV['AWS_SECRET'],
441.             ],
442.         ]);
443.    
444.         
445.         
446.         if(isset($_POST["btn_cliente"])){
447.             
448.             $session->set('cliente_id', $_POST["btn_cliente"]);
449.             return $this->redirectToRoute('home');
450.         }
453.         $clienteId = $session->get('cliente_id');
454.         
455.         
456.         
457.         if ($clienteId == null ) {
458.             
459.             $caixas =  "";
460.             $index_all ="";
461.             $documentos="";
462.             $cliente_session = "";
463.        
464.         } else {
465.             $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $clienteId]);
466.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
467.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null ,'cliente' => $clienteId]);
468.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
469.             $cliente_nome= $cliente_session->getNome();
470.             
471.         }
472.         
473.         
474.        
475.         
476.       
477.         if ($form->isSubmitted() && $form->isValid()) {
478.             $list =[];
479.             $file = $form['file']->getData();
480.             $spreadsheet = IOFactory::load($file->getPathname());
481.             $sheetData = $spreadsheet->getActiveSheet()->toArray();
483.             foreach ($sheetData as $row) {
484.                 $excel ++;
485.                 $id_cx = null ;
486.                 $selections = $_POST["selections"];
487.                 $nome = array_search('0', $selections);
488.                 $caixa = array_search('1', $selections);
489.                 $assunto = array_search('2', $selections);
490.                 $keywod = array_search('3', $selections);
491.                 $data_documento = array_search('4', $selections);
492.                 $data_vecimento = array_search('5', $selections);
493.                 $descricao  = array_search('6', $selections);
494.                 
495.                 if ($caixa != false ) {
496.                         
497.                     
499.                     $numerosExcel = preg_replace('/\D/', '', $row[$caixa]);
502.                     foreach ($caixas as $key) {
504.                         $nome_cx = $key->getNome();
505.                         $numerosCaixa = preg_replace('/\D/', '', $nome_cx);
507.                         if ($numerosCaixa == $numerosExcel ) {
508.                             
509.                                 $id_cx = $key->getId();
510.                         }
511.                     }
512.                     
513.                     
514.                     if ($id_cx == null) {
516.                         echo '<script>alert("ERRO NA LINHA '.$excel.' NÃO EXISTE ESSA CAIXA CADASTRADA")</script>';
517.                             return $this->render('index/index2.html.twig', [
518.                             'documentos' => $documentos,
519.                             'p'=>$p,
520.                             'erro'=>$erro,
521.                             'index_all'=>$index_all,
522.                             'pagina' => $pagina,
523.                             'caixas' => $caixas,
524.                             'user_logado' => $user_logado,
525.                             'cliente' => $cliente,
526.                             'cliente_session' => $cliente_session,
527.                             'form' => $form->createView(),
528.                                             ]);
529.                     }
531.                 }
533.                 
534.                 
535.                     $yourEntity = new Documento();
536.                     // Ajuste conforme necessário
537.                     $yourEntity->setUser($user_logado);
538.                     $yourEntity->setCliente($cliente_session);
539.                     $yourEntity->setClassificacao($doctrine->getRepository(Classificacao::class)->find(1));
540.                     $yourEntity->setTipo($doctrine->getRepository(Tipo::class)->find($_POST["tipo"]));
541.                     $yourEntity->setNome($row[$nome]); 
542.                     if ($assunto != false ) {$yourEntity->setAssunto($row[$assunto]);}
543.                     if ($caixa != false ) {$yourEntity->setCaixa($doctrine->getRepository(Caixa::class)->find($id_cx));}
544.                     if ($keywod != false ) {$yourEntity->setKeywords($row[$keywod]);}
545.                     if (!empty(trim($row[$data_documento])) && strtoupper(trim($row[$data_documento])) !== "NULL") {
546.                         $yourEntity->setDataDocumento(new \DateTimeImmutable($row[$data_documento]));
547.                     }
548.                     
549.                     #if (!empty(trim($row[$data_vecimento])) && strtoupper(trim($row[$data_vecimento])) !== "NULL") {
550.                      #   $yourEntity->setVencimentoDocumento(new \DateTimeImmutable($row[$data_vecimento]));
551.                     #}
552.                     if ($descricao != false ) {$yourEntity->setExtraFields($row[$descricao]);}
553.                     $entityManager->persist($yourEntity);
554.                     $entityManager->flush();
555.                     $erro = "ok";
556.                     
557.                    
558.                     
559.             }
561.                 
562.                 $log = new Registro();
563.                 $log->setOperacao('PLANILHA EXPORTADA, '.$excel .' CADASTROS INSERIDOS.' ); 
564.                 $log->setUser($user_nome_name);
565.                 $log->setCliente($cliente_nome);
566.                 $entityManager->persist($log);
567.                 $entityManager->flush();
568.                 $erro = "ok";
569.                 if ($excel>1)  {$p =  'PLANILHA EXPORTADA COM SUCESSO, '.$excel .' CADASTROS INSERIDOS , .' ;}
570.                 if ($excel==1) {$p =  'PLANILHA EXPORTADA COM SUCESSO, '.$excel .' CADASTRO INSERIDO ,' ;}
571.             
572.         }
574.         
575.         return $this->render('index/index2.html.twig', [
576.                             'documentos' => $documentos,
577.                             'p'=>$p,
578.                             'erro'=>$erro,
579.                             'index_all'=>$index_all,
580.                             'pagina' => $pagina,
581.                             'caixas' => $caixas,
582.                             'user_logado' => $user_logado,
583.                             'cliente' => $cliente,
584.                             'cliente_session' => $cliente_session,
585.                             'form' => $form->createView(),
586.                                             ]);
587.        
588.     }
589.     
590.     #[Route('/index/planilha/classificacao', name: 'planilha_classificacao')]
591.     public function planilha_classificacao(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session): Response
592.     {
593.         
594.       
595.         $form = $this->createForm(UploadType::class);
596.         $user_logado= $this->getUser();
597.         $user_logado_id = $user_logado->getId();
598.         $user_nome_name= $user_logado->getNome();
599.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
600.         $form->handleRequest($request);
601.         $erro = '';
602.         $excel = 0;
603.         $pagina = 'index';
604.         $p = '';
607.         if(isset($_POST["btn_cliente"])){
608.             
609.             $session->set('cliente_id', $_POST["btn_cliente"]);
610.             return $this->redirectToRoute('home');
611.         }
614.         $clienteId = $session->get('cliente_id');
615.         
616.         
617.         
618.         if ($clienteId == null ) {
619.             
620.             $caixas =  "";
621.             $cliente_session = "";
622.        
623.         } else {
624.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
625.             $cliente_nome= $cliente_session->getNome();  
626.         }
627.         
628.         
629.        
630.         
631.       
632.         if ($form->isSubmitted() && $form->isValid()) {
634.             $list =[];
635.             $file = $form['file']->getData();
636.             $spreadsheet = IOFactory::load($file->getPathname());
637.             $sheetData = $spreadsheet->getActiveSheet()->toArray();
639.             foreach ($sheetData as $row) {
641.                 $excel ++;
642.                 $id_cx = null ;
643.                 $selections = $_POST["selections"];
644.                 $nome = array_search('0', $selections);
645.                 $fase_corrente = array_search('1', $selections);
646.                 $fase_intermediaria = array_search('2', $selections);
647.                 $destinacao_final = array_search('3', $selections);
648.                 $observacoes = array_search('4', $selections);
649.                 $descricao = array_search('5', $selections);
650.                 
651.                 
652.                 if($row[$nome] != null){
653.                 
654.                     $yourEntity = new Classificacao();
655.                     $yourEntity->setNome($row[$nome]);
656.                     $yourEntity->setFaseCorrente($row[$fase_corrente]);
657.                     $yourEntity->setFaseIntermediaria($row[$fase_intermediaria]);
658.                     $yourEntity->setDestinacaoFinal($row[$destinacao_final]);
659.                     $yourEntity->setObservacoes($row[$observacoes]);
660.                     $yourEntity->setExtraFields($row[$descricao]);
661.                     $yourEntity->setCliente($cliente_session);
662.                     $entityManager->persist($yourEntity);
663.                     $entityManager->flush();
664.                     $erro = "ok";
665.                 }
666.                
667.                     
668.                    
669.                     
670.             }
672.                 
673.             $log = new Registro();
674.             $log->setOperacao('PLANILHA EXPORTADA, '.$excel .' CADASTROS INSERIDOS.' ); 
675.             $log->setUser($user_nome_name);
676.             $log->setCliente($cliente_nome);
677.             $entityManager->persist($log);
678.             $entityManager->flush();
679.             $erro = "ok";
680.             if ($excel>1)  {$p =  'PLANILHA EXPORTADA COM SUCESSO, '.$excel .' CADASTROS INSERIDOS , .' ;}
681.             if ($excel==1) {$p =  'PLANILHA EXPORTADA COM SUCESSO, '.$excel .' CADASTRO INSERIDO ,' ;}
682.             
683.         }
685.         
686.         return $this->render('index/index_classificao.html.twig', [
687.                             'p'=>$p,
688.                             'erro'=>$erro,
689.                             'pagina' => $pagina,
690.                             'user_logado' => $user_logado,
691.                             'cliente' => $cliente,
692.                             'cliente_session' => $cliente_session,
693.                             'form' => $form->createView(),
694.                                             ]);
695.        
696.     }
698.     #[Route('/index', name: 'index')]
699.     public function indexar(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager , SessionInterface $session): Response
700.     {
701.         $dotenv = new Dotenv();
702.         $dotenv->load(__DIR__.'/.env');
703.         $user_logado = $this->getUser();
704.         $form = $this->createForm(UploadType::class);
705.         $form->handleRequest($request);
706.         $user_logado_tipoAcesso = $user_logado->getTipoAcesso();
707.         $user_logado_nome = $user_logado->getNome();
708.         $user_logado_id = $user_logado->getId();
709.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
710.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
711.         $hoje_formt=$hoje->format('Y-m-d');
712.         $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $hoje_formt);
713.         $dia_prod = 'de hoje';
714.         $permissao = [];
715.         $list_indexador = [];
716.          
717.         if(isset($_POST["btn_cliente"])){
718.             
719.             $session->set('cliente_id', $_POST["btn_cliente"]);
720.             return $this->redirectToRoute('home');
721.         }
722.         $clienteId = $session->get('cliente_id');
723.         if ($clienteId == null ) {
724.             
725.             $caixas =  "";
726.             $index_all ="";
727.             $documentos="";
728.             $cliente_session = "";
729.        
730.         } else {
731.             
732.             $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $clienteId]);
733.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
734.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null ,'cliente' => $clienteId]);
735.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
736.             
737.             
738.         }
739.        
740.         if(isset($_POST["date_perio"])){
741.             
742.             
743.             $startDate = $_POST["de"];
744.             $endDate = $_POST["ate"];
745.        
746.             $de = new \DateTimeImmutable($startDate);
747.             $ate = new \DateTimeImmutable($endDate);
748.             $de_formt=$de->format('d/m/Y') ;
749.             $ate_formt=$ate->format('d/m/Y') ;
750.             
751.             if($endDate != ""){ 
752.                 
753.                 $doc = $entityManager->getRepository(Documento::class)->findByUserAndDateIndexRange($user_logado_nome, $startDate, $endDate);
754.                 $dia_prod = 'de '. $de_formt.' até '.$ate_formt; 
755.             
756.             }
757.             if($endDate == ""){ 
758.                 
759.                 $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $startDate);
760.                 $dia_prod = 'de '. $de_formt; 
761.             }
762.             
763.             
764.             
765.         }
766.        
767.         
768.         foreach ($user_logado_tipoAcesso["new"] as  $value) {
769.             
770.             foreach ($index_all as $key) {
771.                 if ( $key->getId() ==  $value) {
772.                     
773.                     $permissao[] = $value;
774.                     
775.                 }
776.                
777.             }
778.         }
779.     
780.         $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null , 'cliente' => $clienteId]);
781.         
782.         $class =  $doctrine->getRepository(Classificacao::class)->findBy(['cliente' => $clienteId]);
783.         $cliente_id = $doctrine->getRepository(Cliente::class)->findBy(['id' => $clienteId]);
784.         
785.        
786.         
787.         
788.         foreach ($cliente_id as $cliente_ids) {
789.             
790.             $cliente_nome= $cliente_ids->getNome();
791.             $clientes= $cliente_ids->getId();
792.             $umlautString =$cliente_nome;
793.             $slugger = new AsciiSlugger();
794.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
795.             $caminho = strtolower ($teste.'/');
796.                         
797.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
798.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
799.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
800.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
801.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
802.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
803.             if($clientes ==  15){$caminho='cbsi-dossies/';}
804.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
805.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
806.         }
807.         
808.         
809.         
810.         if ($clienteId == null ) {
811.             
812.             $caixas =  "";
813.        
814.         } else {
815.             
816.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
817.         }   
818.             
819.            
820.         $erro = '';
821.         $ii=0;
822.         $pagina = 'index';
823.         $p = '';
824.         $link = '';
825.         $mx = 0;
826.         $xy = 0 ; 
827.         $yz = 0 ; 
828.         $ay = 0 ;
829.         $ky = 0 ;
830.         $pdf ='';
831.         $pagina_h4 ='Documento(s) para indexar';
832.         $nome_menu_ = '';
833.         $index_tipo='';
834.         $uuid = Uuid::v4();
835.         $user = $this->getUser();
836.         $user_nome= $user->getEmail();
837.         $user_nome_name= $user->getNome();
838.         $pasta_user=$user_nome.'/';
839.         $arr = [];
840.         $arrr=0;
841.         $index_find = null;
842.         $dt = '';
843.         $clientS3 = new  S3Client([
844.                     'region'  => 'sa-east-1',
845.                     'version' => 'latest',
846.                     'credentials' => [ 
847.                         'key'    => $_ENV['AWS_KEY'],
848.                         'secret' => $_ENV['AWS_SECRET'],
849.                     ],
850.                 ]);
851.         
852.      
853.             
854.         if(isset($_POST["dt"]))
855.         {   
857.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => $_POST["dt"]]);
858.             $index_find =  $doctrine->getRepository(Tipo::class)->find($_POST["dt"]);
859.             $pagina =$index_find->getNome();
860.             $pagina_h4 ='Documento(s) do tipo ( '.$pagina.' )';
861.             
862.             
863.         }
864.        
865.         if(isset($_POST["botao_index"])){
866.             
867.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
868.             $link = $pdf->getImage();
869.             $xy = 1 ;
870.             
871.         }
872.         if(isset($_POST["botao_doc"])){
873.             
874.             
875.             $yz = 0 ;
876.             $xy = 1 ;
877.             $ay = 1 ;
878.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
879.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
880.            
881.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
882.             $index_tipo_tipo =  $index_tipo->getNome();
883.             $link = $pdf->getImage();
884.             $fase=$_POST["fase"];
885.             $data = $_POST["data"];
886.             $cx = $_POST["caixas"];
887.             $classifica = $_POST["classifica"];
888.             $fase = $_POST["fase"];
889.             $desc = $_POST["desc"];
890.             $assunto = $_POST["assunto"];
891.             $chave = $_POST["chave"];
892.             $nome = $_POST["nome"];
893.             $conteiner = $_POST["conteiner"];
894.             
896.           
897.             
898.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($cx);
899.             
900.             
901.             
902.             // Encontra todos os números na frase
903.             preg_match_all('/\d+/', $fase, $matches);
905.             // $matches[0] agora contém todos os números encontrados na frase
906.             $numeros = array_map('intval', $matches[0]);
908.             // Exibe os números encontrados
909.             
910.             if ($clientes != 7) {
911.            
912.                 if ($data != "") {
913.                     
914.                     if ($fase != "") {
915.     
916.                         // Número inteiro que você deseja somar ao ano
917.                         $numeroParaSomar = $numeros[0];
918.     
919.                         // Extrair o ano da data
920.                         list($ano, $mes, $dia) = explode('-', $data);
921.     
922.                         // Converter o ano para um número inteiro
923.                         $ano = intval($ano);
924.     
925.                         // Somar o número ao ano
926.                         $data_vecimento =  $ano + $numeroParaSomar.'-'.$mes.'-'. $dia;
927.     
928.                         $pdf->setVencimentoDocumento(new \DateTimeImmutable($data_vecimento));
929.     
930.                     }
931.                 $pdf->setDataDocumento(new \DateTimeImmutable($data));
932.                 }
933.             }    
934.             
935.             if ($clientes == 7) {
936.                   
937.                   $pdf->setVencimentoDocumento(new \DateTimeImmutable($fase));
938.                   $pdf->setDataDocumento(new \DateTimeImmutable($data));
939.              }
940.              
941.             $pdf->setAssunto($assunto);
943.             if ($classifica != "") {
945.                 $classifica_id = $doctrine->getRepository(Classificacao::class)->find($classifica);
946.                 $pdf->setClassificacao($classifica_id);
947.             }
949.             $pdf->setCaixa($caixa_id);
950.             $pdf->setExtraFields($desc);
951.             $pdf->setNome($nome);
952.             $pdf->setKeywords($chave);
953.             $pdf->setUserIndex($user_nome_name);
954.             $pdf->setConteiner($conteiner);
955.             $pdf->setIndexAt(new \DateTimeImmutable('America/Sao_Paulo'));
956.             $pdf->setTipo($index_tipo);
957.             $entityManager->flush();
958.             $id_pd = $pdf->getId();    
959.             $log = new Registro();
960.             $log->setOperacao('Indexou o Documento com id '.$id_pd); 
961.             $log->setUser($user_nome_name);
962.             $log->setCliente($cliente_nome);
963.             $entityManager->persist($log);
964.             $entityManager->flush();
965.             $erro = 'ok';
966.             $p =  $index_tipo_tipo.' indexado com sucesso';
967.             
970.            
971.             
972.            
973.         }   
974.         if(isset($_POST["botao_index_edit"])){
975.             
976.             $yz = 0 ;
977.             $xy = 1 ;
978.             $ay = 1 ;
979.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
980.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
981.             $link = $pdf->getImage();
982.         }
983.         if(isset($_POST["botao_volta"])){
985.             $xy = 0 ;
986.             $yz = 0 ;
987.         }
988.         if(isset($_POST["index_button"])){
989.             
990.             
991.             $yz = 0 ;
992.             $xy = 1 ;
993.             $ay = 1 ;
994.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
995.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["index_button"]);
996.             $link = $pdf->getImage();
997.         }
998.         if(isset($_POST["botao_cancel"])){
999.             $yz = 0 ;
1000.             $xy = 1 ;
1001.             $ay = 0 ;
1002.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1003.             $link = $pdf->getImage();
1004.             
1005.         }
1006.         if(isset($_POST["delet"])){
1007.            
1008.             $ky = 1 ;
1009.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["delet"]);
1010.             $documentos = $doctrine->getRepository(Documento::class)->findBy(['id' => $_POST["delet"]]);
1011.             
1012.             if($pdf->getTipo()!= null){
1013.                 $index_find =  $doctrine->getRepository(Tipo::class)->find($pdf->getTipo());
1014.                 $pagina =$index_find->getTipo();
1015.                 $pagina_h4 ='Documento(s) do tipo ( '.$index_find->getTipo().' )';
1016.             }
1017.                         
1018.         }
1019.         if(isset($_POST["delet_cancel"])){
1020.             $ky = 0 ;
1021.         }
1022.         if(isset($_POST["delet_sim"])){
1023.             
1024.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
1025.             $id_pd = $pdf->getId();
1026.             $entityManager->remove($pdf);
1027.             $entityManager->flush();
1028.           
1029.             $log = new Registro();
1030.             $log->setOperacao('Excluiu Documento com id '.$id_pd); 
1031.             $log->setUser($user_nome_name);
1032.             $log->setCliente($cliente_nome);
1033.             $entityManager->persist($log);
1034.             $entityManager->flush();
1035.             $erro = 'ok';
1036.             $p = 'Documento com id '.$id_pd.' excluido com sucesso '; 
1037.         }
1038.         if(isset($_POST["index_edit"])){
1039.             $yz = 0 ;
1040.             $xy = 1 ;
1041.             $ay = 2 ;
1042.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1043.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
1044.             $link = $pdf->getImage();
1045.         }
1046.        
1047.        
1048.         $cmd = $clientS3->getCommand('GetObject', [
1049.                 'Bucket' => 'arquivosdoc',
1050.                 'Key'    => $caminho. $link, 
1051.             ]);
1052.             
1053.             $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
1054.             $all_Url = (string) $req->getUri();
1055.         return $this->render('index/index1.html.twig', [
1056.             'documentos' => $documentos,
1057.             'xy' => $xy,
1058.             'yz' => $yz,
1059.             'ay'=>$ay,
1060.             'link' => $link,
1061.             'pdf'=>$pdf,
1062.             'p'=>$p,
1063.             'erro'=>$erro,
1064.             'index_all'=>$index_all,
1065.             'index_tipo'=>$index_tipo,
1066.             'ky'=>$ky,
1067.             'pagina' => $pagina,
1068.             'pagina_h4' =>$pagina_h4,
1069.             'index_find'=>$index_find,
1070.             'mx'=>$mx,
1071.             'caixas' => $caixas,
1072.             'class' => $class,
1073.             'permissao'=>$permissao,
1074.             'caminho' =>$caminho,
1075.             'clientes' => $clientes,
1076.             'doc'=>$doc,
1077.             'dia_prod' => $dia_prod,
1078.             'cliente_session' => $cliente_session,
1079.             'all_Url'=>$all_Url
1080.         ]);
1083.     }
1084.     
1085.     
1086.     #[Route('/index/corre', name: 'index_corre')]
1087.     public function index_corre(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager , SessionInterface $session): Response
1088.     {
1089.         $dotenv = new Dotenv();
1090.         $dotenv->load(__DIR__.'/.env');
1091.         $user_logado = $this->getUser();
1092.         $form = $this->createForm(UploadType::class);
1093.         $form->handleRequest($request);
1094.         $user_logado_tipoAcesso = $user_logado->getTipoAcesso();
1095.         $user_logado_nome = $user_logado->getNome();
1096.         $user_logado_id = $user_logado->getId();
1097.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
1098.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
1099.         $hoje_formt=$hoje->format('Y-m-d');
1100.         $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $hoje_formt);
1101.         $dia_prod = 'de hoje';
1102.         $permissao = [];
1103.         $list_indexador = [];
1104.          
1105.         if(isset($_POST["btn_cliente"])){
1106.             
1107.             $session->set('cliente_id', $_POST["btn_cliente"]);
1108.             return $this->redirectToRoute('home');
1109.         }
1110.         $clienteId = $session->get('cliente_id');
1111.         if ($clienteId == null ) {
1112.             
1113.             $caixas =  "";
1114.             $index_all ="";
1115.             $documentos="";
1116.             $cliente_session = "";
1117.        
1118.         } else {
1119.             
1120.             $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $clienteId]);
1121.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
1122.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null ,'cliente' => $clienteId]);
1123.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
1124.             
1125.             
1126.         }
1127.        
1128.         if(isset($_POST["date_perio"])){
1129.             
1130.             
1131.             $startDate = $_POST["de"];
1132.             $endDate = $_POST["ate"];
1133.        
1134.             $de = new \DateTimeImmutable($startDate);
1135.             $ate = new \DateTimeImmutable($endDate);
1136.             $de_formt=$de->format('d/m/Y') ;
1137.             $ate_formt=$ate->format('d/m/Y') ;
1138.             
1139.             if($endDate != ""){ 
1140.                 
1141.                 $doc = $entityManager->getRepository(Documento::class)->findByUserAndDateIndexRange($user_logado_nome, $startDate, $endDate);
1142.                 $dia_prod = 'de '. $de_formt.' até '.$ate_formt; 
1143.             
1144.             }
1145.             if($endDate == ""){ 
1146.                 
1147.                 $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $startDate);
1148.                 $dia_prod = 'de '. $de_formt; 
1149.             }
1150.             
1151.             
1152.             
1153.         }
1154.        
1155.         
1156.         foreach ($user_logado_tipoAcesso["new"] as  $value) {
1157.             
1158.             foreach ($index_all as $key) {
1159.                 if ( $key->getId() ==  $value) {
1160.                     
1161.                     $permissao[] = $value;
1162.                     
1163.                 }
1164.                
1165.             }
1166.         }
1167.         $ids = [
1168.             6872304, 6818199, 6869816, 6869252, 6821222, 6869814, 6866863, 6852698,
1169.             6818244, 6872298, 6826550, 6867034, 6869774, 6868323, 6823222, 6868678,
1170.             6862719, 6826530, 6819080, 6868011, 6823849, 6868443, 6823107, 6858469,
1171.             6819006, 6872241, 6872243, 6836508, 6836538, 6823231, 6841051, 6862616,
1172.             6836483, 6836476, 6823024, 6868690, 6868662, 6867891, 6836582, 6868372,
1173.             6836482, 6823893, 6872268, 6834758, 6821087, 6867018, 6836503, 6872202,
1174.             6836479, 6818242, 6863718, 6834830, 6867256, 6872259, 6868597, 6834172,
1175.             6836492, 6869376, 6818965, 6872168, 6868595, 6860317, 6859908, 6868330,
1176.             6839939, 6872285, 6869366, 6862659, 6824620, 6869847, 6818237, 6834659,
1177.             6834917, 6866975, 6869454, 6861937, 6863512, 6834747, 6819937, 6834280,
1178.             6832406, 6862744, 6818963, 6836480, 6872203, 6818830, 6823892, 6831255,
1179.             6816562, 6872201, 6831256, 6866999, 6836481, 6868423, 6816568, 6862679,
1180.             6868314, 6866634, 6839557, 6869243, 6859933, 6869515, 6832578, 6836535,
1181.             6823855, 6823845, 6823876, 6832397, 6836478, 6863719, 6859935, 6871251,
1182.             6869513, 6869510, 6835848, 6831156, 6836517
1183.         ];
1184.             
1185.         $qb = $doctrine->getRepository(Documento::class)->createQueryBuilder('d');
1187.         $documentos = $qb
1188.             ->where('d.id IN (:ids)')
1189.             ->andWhere(
1190.                 $qb->expr()->orX(
1191.                     'd.extraFields IS NULL',
1192.                     'd.dataDocumento IS NULL'
1193.                 )
1194.             )
1195.             ->setParameter('ids', $ids)
1196.             ->getQuery()
1197.             ->getResult();
1198.         
1200.         $class =  $doctrine->getRepository(Classificacao::class)->findBy(['cliente' => $clienteId]);
1201.         $cliente_id = $doctrine->getRepository(Cliente::class)->findBy(['id' => $clienteId]);
1202.         
1203.        
1204.         
1205.         
1206.         foreach ($cliente_id as $cliente_ids) {
1207.             
1208.             $cliente_nome= $cliente_ids->getNome();
1209.             $clientes= $cliente_ids->getId();
1210.             $umlautString =$cliente_nome;
1211.             $slugger = new AsciiSlugger();
1212.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
1213.             $caminho = strtolower ($teste.'/');
1214.                         
1215.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
1216.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
1217.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
1218.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
1219.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
1220.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
1221.             if($clientes ==  15){$caminho='cbsi-dossies/';}
1222.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
1223.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
1224.         }
1225.         
1226.         
1227.         
1228.         if ($clienteId == null ) {
1229.             
1230.             $caixas =  "";
1231.        
1232.         } else {
1233.             
1234.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
1235.         }   
1236.             
1237.            
1238.         $erro = '';
1239.         $ii=0;
1240.         $pagina = 'index';
1241.         $p = '';
1242.         $link = '';
1243.         $mx = 0;
1244.         $xy = 0 ; 
1245.         $yz = 0 ; 
1246.         $ay = 0 ;
1247.         $ky = 0 ;
1248.         $pdf ='';
1249.         $pagina_h4 ='Documento(s) para indexar';
1250.         $nome_menu_ = '';
1251.         $index_tipo='';
1252.         $uuid = Uuid::v4();
1253.         $user = $this->getUser();
1254.         $user_nome= $user->getEmail();
1255.         $user_nome_name= $user->getNome();
1256.         $pasta_user=$user_nome.'/';
1257.         $arr = [];
1258.         $arrr=0;
1259.         $index_find = null;
1260.         $dt = '';
1261.         $clientS3 = new  S3Client([
1262.                     'region'  => 'sa-east-1',
1263.                     'version' => 'latest',
1264.                     'credentials' => [ 
1265.                         'key'    => $_ENV['AWS_KEY'],
1266.                         'secret' => $_ENV['AWS_SECRET'],
1267.                     ],
1268.                 ]);
1269.         
1270.      
1271.             
1272.         if(isset($_POST["dt"]))
1273.         {   
1275.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => $_POST["dt"]]);
1276.             $index_find =  $doctrine->getRepository(Tipo::class)->find($_POST["dt"]);
1277.             $pagina =$index_find->getNome();
1278.             $pagina_h4 ='Documento(s) do tipo ( '.$pagina.' )';
1279.             
1280.             
1281.         }
1282.        
1283.         if(isset($_POST["botao_index"])){
1284.             
1285.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
1286.             $link = $pdf->getImage();
1287.             $xy = 1 ;
1288.             
1289.         }
1290.         if(isset($_POST["botao_doc"])){
1291.             
1292.             
1293.             $yz = 0 ;
1294.             $xy = 1 ;
1295.             $ay = 1 ;
1296.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1297.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
1298.            
1299.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
1300.             $index_tipo_tipo =  $index_tipo->getNome();
1301.             $link = $pdf->getImage();
1302.             $fase=$_POST["fase"];
1303.             $data = $_POST["data"];
1304.             $cx = $_POST["caixas"];
1305.             $classifica = $_POST["classifica"];
1306.             $fase = $_POST["fase"];
1307.             $desc = $_POST["desc"];
1308.             $assunto = $_POST["assunto"];
1309.             $chave = $_POST["chave"];
1310.             $nome = $_POST["nome"];
1311.             $conteiner = $_POST["conteiner"];
1312.             
1314.           
1315.             
1316.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($cx);
1317.             
1318.             
1319.             
1320.             // Encontra todos os números na frase
1321.             preg_match_all('/\d+/', $fase, $matches);
1323.             // $matches[0] agora contém todos os números encontrados na frase
1324.             $numeros = array_map('intval', $matches[0]);
1326.             // Exibe os números encontrados
1327.             
1328.             if ($clientes != 7) {
1329.            
1330.                 if ($data != "") {
1331.                     
1332.                     if ($fase != "") {
1333.     
1334.                         // Número inteiro que você deseja somar ao ano
1335.                         $numeroParaSomar = $numeros[0];
1336.     
1337.                         // Extrair o ano da data
1338.                         list($ano, $mes, $dia) = explode('-', $data);
1339.     
1340.                         // Converter o ano para um número inteiro
1341.                         $ano = intval($ano);
1342.     
1343.                         // Somar o número ao ano
1344.                         $data_vecimento =  $ano + $numeroParaSomar.'-'.$mes.'-'. $dia;
1345.     
1346.                         $pdf->setVencimentoDocumento(new \DateTimeImmutable($data_vecimento));
1347.     
1348.                     }
1349.                 $pdf->setDataDocumento(new \DateTimeImmutable($data));
1350.                 }
1351.             }    
1352.             
1353.             if ($clientes == 7) {
1354.                   
1355.                   $pdf->setVencimentoDocumento(new \DateTimeImmutable($fase));
1356.                   $pdf->setDataDocumento(new \DateTimeImmutable($data));
1357.              }
1358.              
1359.             $pdf->setAssunto($assunto);
1361.             if ($classifica != "") {
1363.                 $classifica_id = $doctrine->getRepository(Classificacao::class)->find($classifica);
1364.                 $pdf->setClassificacao($classifica_id);
1365.             }
1367.             $pdf->setExtraFields($desc);
1368.             $pdf->setNome($nome);
1369.             $pdf->setKeywords($chave);
1370.             $pdf->setUserIndex($user_nome_name);
1371.             $pdf->setConteiner($conteiner);
1372.             $pdf->setIndexAt(new \DateTimeImmutable('America/Sao_Paulo'));
1373.             $pdf->setTipo($index_tipo);
1374.             $entityManager->flush();
1375.             $id_pd = $pdf->getId();    
1376.             $log = new Registro();
1377.             $log->setOperacao('Indexou o Documento com id '.$id_pd); 
1378.             $log->setUser($user_nome_name);
1379.             $log->setCliente($cliente_nome);
1380.             $entityManager->persist($log);
1381.             $entityManager->flush();
1382.             $erro = 'ok';
1383.             $p =  $index_tipo_tipo.' indexado com sucesso';
1384.             
1387.            
1388.             
1389.            
1390.         }   
1391.         if(isset($_POST["botao_index_edit"])){
1392.             
1393.             $yz = 0 ;
1394.             $xy = 1 ;
1395.             $ay = 1 ;
1396.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
1397.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
1398.             $link = $pdf->getImage();
1399.         }
1400.         if(isset($_POST["botao_volta"])){
1402.             $xy = 0 ;
1403.             $yz = 0 ;
1404.         }
1405.         if(isset($_POST["index_button"])){
1406.             
1407.             
1408.             $yz = 0 ;
1409.             $xy = 1 ;
1410.             $ay = 1 ;
1411.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1412.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["index_button"]);
1413.             $link = $pdf->getImage();
1414.         }
1415.         if(isset($_POST["botao_cancel"])){
1416.             $yz = 0 ;
1417.             $xy = 1 ;
1418.             $ay = 0 ;
1419.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1420.             $link = $pdf->getImage();
1421.             
1422.         }
1423.         if(isset($_POST["delet"])){
1424.            
1425.             $ky = 1 ;
1426.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["delet"]);
1427.             $documentos = $doctrine->getRepository(Documento::class)->findBy(['id' => $_POST["delet"]]);
1428.             
1429.             if($pdf->getTipo()!= null){
1430.                 $index_find =  $doctrine->getRepository(Tipo::class)->find($pdf->getTipo());
1431.                 $pagina =$index_find->getTipo();
1432.                 $pagina_h4 ='Documento(s) do tipo ( '.$index_find->getTipo().' )';
1433.             }
1434.                         
1435.         }
1436.         if(isset($_POST["delet_cancel"])){
1437.             $ky = 0 ;
1438.         }
1439.         if(isset($_POST["delet_sim"])){
1440.             
1441.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
1442.             $id_pd = $pdf->getId();
1443.             $entityManager->remove($pdf);
1444.             $entityManager->flush();
1445.           
1446.             $log = new Registro();
1447.             $log->setOperacao('Excluiu Documento com id '.$id_pd); 
1448.             $log->setUser($user_nome_name);
1449.             $log->setCliente($cliente_nome);
1450.             $entityManager->persist($log);
1451.             $entityManager->flush();
1452.             $erro = 'ok';
1453.             $p = 'Documento com id '.$id_pd.' excluido com sucesso '; 
1454.         }
1455.         if(isset($_POST["index_edit"])){
1456.             $yz = 0 ;
1457.             $xy = 1 ;
1458.             $ay = 2 ;
1459.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1460.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
1461.             $link = $pdf->getImage();
1462.         }
1463.        
1464.        
1465.         $cmd = $clientS3->getCommand('GetObject', [
1466.                 'Bucket' => 'arquivosdoc',
1467.                 'Key'    => $caminho. $link, 
1468.             ]);
1469.             
1470.             $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
1471.             $all_Url = (string) $req->getUri();
1472.         return $this->render('index/index1.html.twig', [
1473.             'documentos' => $documentos,
1474.             'xy' => $xy,
1475.             'yz' => $yz,
1476.             'ay'=>$ay,
1477.             'link' => $link,
1478.             'pdf'=>$pdf,
1479.             'p'=>$p,
1480.             'erro'=>$erro,
1481.             'index_all'=>$index_all,
1482.             'index_tipo'=>$index_tipo,
1483.             'ky'=>$ky,
1484.             'pagina' => $pagina,
1485.             'pagina_h4' =>$pagina_h4,
1486.             'index_find'=>$index_find,
1487.             'mx'=>$mx,
1488.             'caixas' => $caixas,
1489.             'class' => $class,
1490.             'permissao'=>$permissao,
1491.             'caminho' =>$caminho,
1492.             'clientes' => $clientes,
1493.             'doc'=>$doc,
1494.             'dia_prod' => $dia_prod,
1495.             'cliente_session' => $cliente_session,
1496.             'all_Url'=>$all_Url
1497.         ]);
1500.     }
1501.     
1502.     #[Route('/index/novo/fluxo', name: 'fluxo_novo')]
1503.     public function fluxoNovo(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer): Response
1504.     {
1505.         $user_logado = $this->getUser();
1506.         $user_logado_nome = $user_logado->getNome();
1507.         $user_logado_id = $user_logado->getId();
1508.         $erro = '';
1509.         $pagina = 'fluxo';
1510.         $p ='';
1511.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
1512.         
1513.         if(isset($_POST["btn_cliente"])){
1514.             
1515.             $session->set('cliente_id', $_POST["btn_cliente"]);
1516.             return $this->redirectToRoute('home');
1517.         }
1520.         $clienteId = $session->get('cliente_id');
1521.         
1522.       
1523.         
1524.         if ($clienteId == null ) {
1525.             
1526.             $cli =  "";
1527.             return $this->redirectToRoute('home');
1528.           
1529.        
1530.         } else {
1531.             
1532.          
1533.             $cli = $doctrine->getRepository(Cliente::class)->find($clienteId);
1534.             
1535.         }
1536.         
1538.         $query = $doctrine->getManager()->createQuery('
1539.             SELECT u
1540.             FROM App\Entity\User u
1541.             JOIN u.clientes c
1542.             WHERE c.id = :clientId
1543.             AND u.enabled = 1
1544.         ')->setParameter('clientId', $clienteId);
1546.         $usuarios = $query->getArrayResult();
1548.         if(isset($_POST["fluxo"])){
1549.             
1550.             $fluxo = new Fluxo();
1551.             $nome = $cli->getNome();
1552.             $fluxo->setNome($nome);
1553.             $fluxo->setUser($user_logado);
1554.             $fluxo->setCliente($cli);
1555.             $fluxo->setObs($_POST["obs"]);
1556.             $entityManager->persist($fluxo);
1557.             $entityManager->flush();
1558.             $id_fluxo = $fluxo->getId(); 
1559.             
1560.             $prazo = $_POST["prazo"];
1561.             $user_1 = $_POST["user"];
1563.             
1565.             foreach ($user_1 as $users) {
1566.                
1567.                     $etapa = new Etapa();
1568.                     $user = $doctrine->getRepository(User::class)->find($users);
1569.                     $mail = $user->getEmail();
1570.                     
1571.                    
1572.                     $etapa->setNome($_POST["etapa"]);
1573.                     $etapa->setOrdem(1);
1574.                     $etapa->setUser($user);
1575.                     $etapa->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1576.                     $etapa->setPrazo(new \DateTimeImmutable($prazo));
1577.                     $entityManager->persist($etapa);
1578.                     $entityManager->flush();
1579.         
1580.                     /*$email = (new Email())
1581.                         ->from('arquivosdoc@arquivosdoc.com.br')
1582.                         ->to($mail)
1583.                         ->subject('Fluxo de Trabalho')
1584.                         ->html('<div style="text-align: center;">
1585.                             <h1 style="color:#1e4067;">Recebimento<br>
1586.                             Cliente: '.$nome.'<br>
1587.                             Prazo:'.$prazo.'<br>
1588.                             Enviado por: '.$user_logado_nome.'<br>
1589.                             Acesse sua pagina inicial no <a href="https://ged.arquivosdoc.com.br/login">ArquivosGED
1590.                             </a></h1>
1591.                             <img src="cid:logo"><div>')
1592.                         ->embed(fopen('C:/xampp8/htdocs/gedemail/public/img/icon.png', 'r'), 'logo', 'image/png');
1593.                     $mailer->send($email);*/
1594.                     
1595.                  
1596.             }
1597.             
1598.             if(isset($_POST["user_2"])){
1599.                 
1600.                 
1601.                 $prazo_2 = $_POST["prazo_2"];
1602.                 $user_2 = $_POST["user_2"];
1604.                 foreach ($user_2 as $users2) {
1605.                     $etapa2 = new Etapa();
1606.                     $etapa2->setNome($_POST["etapa2"]);
1607.                     $etapa2->setOrdem(2);
1608.                     $etapa2->setUser($doctrine->getRepository(User::class)->find($users2));
1609.                     $etapa2->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1610.                     $etapa2->setPrazo(new \DateTimeImmutable($prazo_2));
1611.                     $entityManager->persist($etapa2);
1612.                     $entityManager->flush();
1614.                 }
1615.             }
1617.             if(isset($_POST["user_3"])){
1618.                 
1619.                 
1620.                 $user_3 = $_POST["user_3"];
1621.                 $prazo_3 = $_POST["prazo_3"];
1623.                 foreach ($user_3 as $users3) {
1624.                     $etapa3 = new Etapa();
1625.                     $etapa3->setNome($_POST["etapa3"]);
1626.                     $etapa3->setOrdem(3);
1627.                     $etapa3->setUser($doctrine->getRepository(User::class)->find($users3));
1628.                     $etapa3->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1629.                     $etapa3->setPrazo(new \DateTimeImmutable($prazo_3));
1630.                     $entityManager->persist($etapa3);
1631.                     $entityManager->flush();
1632.                 }    
1633.             }
1635.             if(isset($_POST["user_4"])){
1637.                 
1638.                 $user_4 = $_POST["user_4"];
1639.                 $prazo_4 = $_POST["prazo_4"];
1641.                 foreach ($user_4 as $users4) {
1642.                     $etapa4 = new Etapa();
1643.                     $etapa4->setNome($_POST["etapa4"]);
1644.                     $etapa4->setOrdem(4);
1645.                     $etapa4->setUser($doctrine->getRepository(User::class)->find($users4));
1646.                     $etapa4->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1647.                     $etapa4->setPrazo(new \DateTimeImmutable($prazo_4));
1648.                     $entityManager->persist($etapa4);
1649.                     $entityManager->flush();
1651.                 }
1652.             } 
1653.             
1654.             
1655.             if(isset($_POST["user_5"])){
1657.                 
1658.                 $user_5 = $_POST["user_5"];
1659.                 $prazo_5 = $_POST["prazo_5"];
1660.                 foreach ($user_5 as $users5) {
1662.                     $etapa5 = new Etapa();
1663.                     $etapa5->setNome($_POST["etapa5"]);
1664.                     $etapa5->setOrdem(5);
1665.                     $etapa5->setUser($doctrine->getRepository(User::class)->find($users5));
1666.                     $etapa5->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1667.                     $etapa5->setPrazo(new \DateTimeImmutable($prazo_5));
1668.                     $entityManager->persist($etapa5);
1669.                     $entityManager->flush();
1670.                 }
1671.             } 
1673.             $erro = "ok";
1674.             $p =  'FLUXO ENVIADO' ;
1675.             
1676.             
1677.         }
1678.         
1679.     
1680.        
1681.         return $this->render('index/index4.html.twig', [
1682.     
1683.             
1684.             'p'=>$p,
1685.             'erro'=>$erro,
1686.             'pagina' => $pagina,
1687.             'usuarios' =>$usuarios,
1688.             'cliente' => $cliente
1689.             
1691.         ]);
1692.     }
1694.     #[Route('/index/fluxo', name: 'fluxo')]
1695.     public function fluxo( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer): Response
1696.     {
1697.         $user_logado = $this->getUser();
1698.         $erro = '';
1699.         $pagina = 'fluxo';
1700.         $p ='';
1701.         $registro = $doctrine->getRepository(Registro::class)->findAll();
1702.         $a = 0;
1703.         $clientS3 = new  S3Client([
1704.             'region'  => 'sa-east-1',
1705.             'version' => 'latest',
1706.             'credentials' => [ 
1707.                 'key'    => $_ENV['AWS_KEY'],
1708.                 'secret' => $_ENV['AWS_SECRET'],
1709.             ],
1710.         
1711.         ]);
1713.         
1715.     
1716.         if(isset($_POST["btn_cliente"])){
1717.             
1718.             $session->set('cliente_id', $_POST["btn_cliente"]);
1719.             return $this->redirectToRoute('home');
1720.         }
1723.         $clienteId = $session->get('cliente_id');
1724.         
1725.         if($clienteId == null){
1726.             
1727.             return $this->redirectToRoute('home');
1728.         }
1729.         
1730.         $cliente = $doctrine->getRepository(Cliente::class)->find($clienteId);
1731.         $fluxo = $doctrine->getRepository(Fluxo::class)->findBy(['cliente' => $clienteId],['id'=> 'DESC']);
1732.       
1733.         
1734.         // Paginar os fluxos
1735.         $fluxos = $paginator->paginate(
1736.             $fluxo, // O queryBuilder ou a query
1737.             $request->query->getInt('page', 1), // A página atual, padrão é 1
1738.             2 // O número de itens por página
1739.         );
1742.         if (isset($_POST["excel"])) {
1743.             
1744.         
1745.             $cx = null;
1746.             $id_fluxo = $_POST["excel"];
1747.             $fluxo_excel = $doctrine->getRepository(Fluxo::class)->find($id_fluxo);
1748.             $nome_fluxo = $fluxo_excel->getNome();
1749.             $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_excel->getId());
1750.             
1751.             
1752.         
1753.             // Cria uma nova planilha
1754.             $spreadsheet = new Spreadsheet();
1755.             $sheet = $spreadsheet->getActiveSheet();
1756.             $sheet->setTitle('CAIXA(S)');
1757.             // Configura o cabeçalho
1758.             $sheet->setCellValue('A1', 'ID');
1759.             $sheet->setCellValue('B1', 'REPOSITOR');
1760.             $sheet->setCellValue('C1', 'DATA DO ENVIO');
1761.         
1762.             // Estiliza o cabeçalho (fundo azul, texto branco e negrito)
1763.             $headerStyle = [
1764.                 'font' => [
1765.                     'bold' => true,
1766.                     'color' => ['rgb' => 'FFFFFF'], // Texto branco
1767.                 ],
1768.                 'fill' => [
1769.                     'fillType' => Fill::FILL_SOLID,
1770.                     'startColor' => ['rgb' => '095f99'], // Fundo azul
1771.                 ],
1772.             ];
1773.             $sheet->getStyle('A1:C1')->applyFromArray($headerStyle);
1774.         
1775.             // Preenche os dados
1776.             $rowCount = 2;
1777.             foreach ($fluxo_caixas as $caixas) {
1778.                 
1779.                     if($caixas->getCx() != null){
1780.                     
1781.                     $nome = $caixas->getNome();
1782.                     $cx = $caixas->getCx()->getNome();
1783.                     $data = $caixas->getCreatedAt();
1784.             
1785.                     // Insere os valores
1786.                     $sheet->setCellValue('A' . $rowCount, $cx);
1787.                     $sheet->setCellValue('B' . $rowCount, $nome);
1788.             
1789.                     // Converte a data para o formato Excel
1790.                     if ($data instanceof \DateTime) {
1791.                         $sheet->setCellValue('C' . $rowCount, Date::PHPToExcel($data));
1792.                     } else {
1793.                         $sheet->setCellValue('C' . $rowCount, $data); // Evita erro se não for DateTime
1794.                     }
1795.             
1796.                     $rowCount++;
1797.                 }
1798.             }
1799.         
1800.             // Formata a coluna C como data (exceto o cabeçalho)
1801.             $sheet->getStyle('C2:C' . ($rowCount - 1))
1802.                 ->getNumberFormat()
1803.                 ->setFormatCode('dd/mm/yyyy');
1804.         
1805.             // Define largura automática das colunas
1806.             foreach (range('A', 'C') as $col) {
1807.                 $sheet->getColumnDimension($col)->setAutoSize(true);
1808.             }
1811.              // Segunda aba - Outras informações (Exemplo)
1812.             $sheet2 = $spreadsheet->createSheet(); // Cria uma nova aba
1813.             $sheet2->setTitle('DOCUMENTO(S)'); // Renomeia a aba
1814.             $sheet2->setCellValue('A1' , 'ID');
1815.             $sheet2->setCellValue('B1' , 'NOME');
1816.             $sheet2->setCellValue('C1' , 'REPOSITOR');
1817.             $sheet2->setCellValue('D1' , 'TIPO');
1818.             $sheet2->setCellValue('E1' , 'ASSUNTO');
1819.             $sheet2->setCellValue('F1' , 'PALAVRA-CHAVE');
1820.             $sheet2->setCellValue('G1' , 'DIGITALIZAÇÃO');
1821.             $sheet2->setCellValue('H1' , 'QUEM DIGITALIZOU?');
1822.             $sheet2->setCellValue('I1' , 'INDEXAÇÃO');
1823.             $sheet2->setCellValue('J1' , 'QUEM INDEXOU?');
1824.             $sheet2->setCellValue('K1' , 'IMAGEN(S)');
1825.             $sheet2->getStyle('A1:K1')->applyFromArray($headerStyle);
1826.             
1827.             $rowCount = 2;
1829.             foreach ($fluxo_caixas as $caixas) {
1831.                 $doc = $caixas->getDocumentos();
1833.                 
1834.                 foreach ($doc as $docs) {
1835.                     $tipo= null;
1836.                     $id = $docs->getId();
1837.                     $nome = $docs->getNome();
1838.                     $caixa = $docs->getCaixa()->getNome();
1839.                     if($docs->getTipo() != null){
1840.                         $tipo = $docs->getTipo()->getNome();
1841.                     }
1842.                     $qtd = $docs->getQtd();
1843.                     $assunto = $docs->getAssunto();
1844.                     $keywords = $docs->getKeywords();
1845.                     $user = $docs->getUser()->getNome();
1846.                     $data  = $docs->getCreatedAt();
1847.                     $index  = $docs->getIndexAt();
1848.                     $user_index  = $docs->getUserIndex();
1850.                     $sheet2->setCellValue('A' . $rowCount,$id);
1851.                     $sheet2->setCellValue('B' . $rowCount,$nome);
1852.                     $sheet2->setCellValue('C' . $rowCount,$caixa);
1853.                     $sheet2->setCellValue('D' . $rowCount,$tipo);
1854.                     $sheet2->setCellValue('E' . $rowCount,$assunto);
1855.                     $sheet2->setCellValue('F' . $rowCount,$keywords);
1856.                     $sheet2->setCellValue('G' . $rowCount,$data);
1857.                     $sheet2->setCellValue('H' . $rowCount,$user);
1858.                     $sheet2->setCellValue('I' . $rowCount,$index);
1859.                     $sheet2->setCellValue('J' . $rowCount,$user_index);
1860.                     $sheet2->setCellValue('K' . $rowCount,$qtd);
1861.                    
1862.                     
1864.                     if ($data instanceof \DateTime) {
1865.                         $sheet2->setCellValue('G' . $rowCount, Date::PHPToExcel($data));
1866.                     } else {
1867.                         $sheet2->setCellValue('G' . $rowCount, $data); // Evita erro se não for DateTime
1868.                     }
1870.                     if ($data instanceof \DateTime) {
1871.                         $sheet2->setCellValue('I' . $rowCount, Date::PHPToExcel($index));
1872.                     } else {
1873.                         $sheet2->setCellValue('I' . $rowCount, $index); // Evita erro se não for DateTime
1874.                     }
1875.             
1876.             
1877.                     $rowCount++;
1878.                 
1879.                 }
1880.             }
1881.             $sheet2->getStyle('I2:I' . ($rowCount - 1))
1882.                 ->getNumberFormat()
1883.                 ->setFormatCode('dd/mm/yyyy');
1885.             $sheet2->getStyle('G2:G' . ($rowCount - 1))
1886.                 ->getNumberFormat()
1887.                 ->setFormatCode('dd/mm/yyyy');    
1888.         
1889.             foreach (range('A', 'K') as $col) {
1890.                 $sheet2->getColumnDimension($col)->setAutoSize(true);
1891.             }
1894.         
1895.             // Gera o arquivo para download
1896.             $writer = new Xlsx($spreadsheet);
1897.             header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
1898.             header('Content-Disposition: attachment; filename="' . $nome_fluxo . '-FLUXO-' . $id_fluxo . '.xlsx"');
1899.             header('Cache-Control: max-age=0');
1900.             $writer->save('php://output');
1901.             exit;
1902.         }
1904.         if (isset($_POST["pdf"])) {
1905.             
1906.             $id_fluxo = $_POST["pdf"];
1907.             $fluxo_pdf = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($id_fluxo);
1908.             $nome_fluxo = $fluxo_pdf->getNome();
1909.             
1910.            
1911.             $html = $this->render('index/pdf.html.twig', [
1912.                 'fluxo_pdf' => $fluxo_pdf,
1913.                 'registro' => $registro
1914.                 
1915.             ]);
1917.             $options = new Options();
1918.             $options->set('isHtml5ParserEnabled', true);
1919.             $options->set('isPhpEnabled', true);
1920.             $options->set('isRemoteEnabled', true); 
1921.             $dompdf = new Dompdf($options);
1922.             $dompdf->loadHtml($html);
1923.             $dompdf->setPaper('A4', 'portrait');
1925.             // Renderiza o HTML para o PDF
1926.             $dompdf->render();
1928.             // Envia o PDF para o navegador para download
1929.             $dompdf->stream("Relatório_Fluxo_".$id_fluxo."_".$nome_fluxo.".pdf", ["Attachment" => 0]); // 0 para exibir no navegador, 1 para download
1930.         }
1932.         if (isset($_POST["etiqueta"])) {
1933.             try {
1934.         
1935.                 // reforça limites (pode ajustar conforme necessário)
1936.                 ini_set('max_execution_time', 500);
1937.                 ini_set('memory_limit', '3512M');
1938.         
1939.                 $id_fluxo = $_POST["etiqueta"];
1940.                 $fluxo_pdf = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($id_fluxo);
1941.                 $cliente_id = $fluxo_pdf->getCliente()->getId();
1942.                 $cliente = $doctrine->getRepository(Cliente::class)->findWithRelations($cliente_id);
1943.                 $nome_fluxo = $fluxo_pdf->getNome();
1944.                 $clienteAll_fluxo = $cliente->getClienteAll()->getLogo();
1945.                 
1946.                 $cmd = $clientS3->getCommand('GetObject', [
1947.                 'Bucket' => 'arquivosdoc',
1948.                 'Key'    => 'LOGO_CLIENTES/'. $clienteAll_fluxo, 
1949.                 ]);
1950.                 
1951.                 $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
1952.                 $cliente_all_Url = (string) $req->getUri();
1953.                 
1954.                 $clienteAll_fluxo_id = $cliente->getClienteAll()->getId();
1955.                 $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_pdf->getId());
1956.                 if ($cliente_id == 139 or $cliente_id == 137){
1957.                         $html = '
1958.                         <!DOCTYPE html>
1959.                         <html lang="pt-BR">
1960.                         <head>
1961.                             <meta charset="UTF-8">
1962.                             <meta name="viewport" content="width=device-width, initial-scale=1.0">
1963.                             <title>FLUXO</title>
1964.                             <style>
1965.                                 * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
1966.                                 body { text-transform: uppercase; }
1967.                                 .filho { border: 2px solid black; width: 57.2mm; height: 100mm; display: inline-block; margin: 2px; position: relative;}
1968.                                 h2 { text-align: center; font-size: 20px; padding: 5px; }
1969.                                 h2 img{width: 250px; height: 250px;}
1970.                                 h4 { text-align: center; font-size: 12px; padding: 10px; }
1971.                                 h5 { text-align: center; font-size: 14px;}
1972.                                 h6 { text-align: center; font-size: 14px; padding: 5px; }
1973.                                 h5 img { text-align: center;max-height: 40px;width:auto;max-width: 40px}
1974.                                 h6 img { text-align: center;margin:auto;  max-height: 130px;width:auto;max-width: 130px}
1975.                                 p { text-align: center; font-size: 8px; font-weight: bold;}
1976.                                 .pai { position: relative; top: 11%; }
1977.                                 hr { color: black; }
1978.                                 .lis2{
1979.                                     
1980.                                     font-weight: bold;
1981.                                     margin:5px;
1982.                                 }
1983.                                 .lis3 {
1984.                                     position: absolute;
1985.                                     bottom: 0;
1986.                                     width: 100%;
1987.                                     font-weight: bold;
1988.                                     text-align: center;
1989.                                     margin-bottom:5px;
1990.                                     margin-top:5px;
1991.                                        
1992.                                 }
1993.                                 .lis{
1994.                                     
1995.                                     margin-left:10px;
1996.                                     font-weight: bold;
1997.                                 }
1998.                                 li{
1999.                                   margin:5px;
2000.                                   font-size: 12px
2001.                                 }
2002.                                 
2003.                             </style>
2004.                         </head>
2005.                         <body>
2006.                         <div class="pai">';
2007.                 
2008.                         $count = 0;
2009.                 
2010.                         foreach ($fluxo_caixas as $caixa) {
2011.                             $count++;
2012.                             $documento_fluxo = $caixa->getDocumentos()->toArray();
2013.                             
2014.                 
2015.                             $html .= '<div class="filho">
2016.                                 
2017.                                 
2018.                                 <h6><img src="'.$cliente_all_Url.'" class="img"></h6>
2019.                                 <hr>
2020.                                 <h2>' . htmlspecialchars($caixa->getNome()) . '</h2>
2021.                                 <hr>
2022.                                 ';
2023.                 
2024.                             $docs = [];
2025.                             
2026.                             if (!empty($documento_fluxo)) {
2027.                                 foreach ($documento_fluxo as $doc) {
2028.                                     if($doc->getTipo() != NULL ){
2029.                                         if ($cliente_id != 122) {
2030.                                             $docs[] = $doc->getTipo()->getNome();
2031.                                         } else {
2032.                                             $docs[] = $doc->getNome();
2033.                                         }
2034.                                     }
2035.                                 }
2036.                                 $docs = array_unique($docs);
2037.                             }
2038.                             
2039.                             
2042.                             $docs_class = [];
2043.                             
2044.                             if (!empty($documento_fluxo)) {
2045.                                 foreach ($documento_fluxo as $doc) {
2046.                                     
2047.                                     if($doc->getClassificacao() != NULL ){
2048.                                        $clss =  $entityManager->getRepository(Classificacao::class)->findBy(['id' => $doc->getClassificacao()->getId()]);
2049.                                        $class_nome =  $clss[0]->getNome();
2050.                                        $docs_class[] = $class_nome;
2051.                                         
2052.                                     }
2053.                                 }
2054.                                 $docs_class = array_unique($docs_class);
2055.                             }
2056.                 
2058.                             $docs_data = [];
2059.                             $docs_assunto=[];
2061.                             if (!empty($documento_fluxo)) {
2062.                                 foreach ($documento_fluxo as $data) {
2063.                                     if ($data->getNome() !== null) {
2064.                                         $docs_data[] = $data->getNome();
2065.                                     }
2066.                                     if ($data->getAssunto() !== null) {
2067.                                         $docs_assunto[] = $data->getAssunto();
2068.                                     }
2069.                                 }
2070.                                 $docs_data = array_unique($docs_data);
2071.                                 $docs_assunto = array_unique($docs_assunto);
2072.                             }
2073.                             
2074.                              if ($cliente_id == 139){
2075.                        
2076.                                 $pl_numeros = [];
2077.                                 $req_numeros = [];
2078.                                 $req_ano = null;
2079.                                 
2080.                                 foreach ($docs_data as $doc) {
2081.                                 
2082.                                 
2083.                                     if (preg_match('/^PL-(\d{1,3}(?:\.\d{3})*)$/', $doc, $m)) {
2084.                                 
2085.                                         $numeroLimpo = str_replace('.', '', $m[1]);
2086.                                         $pl_numeros[] = (int)$numeroLimpo;
2087.                                     }
2088.                                 
2089.                            
2090.                                     elseif (stripos($doc, 'REQUERIMENTO') !== false 
2091.                                         && preg_match('/-(\d+)\.(\d{4})$/', $doc, $m)) {
2092.                                 
2093.                                         $req_numeros[] = (int)$m[1];
2094.                                         $req_ano = $m[2];
2095.                                     }
2096.                                 }
2097.                                 
2098.                         
2099.                                 
2100.                                 $menorNome = null;
2101.                                 $maiorNome = null;
2102.                                 $docs_faltantes = [];
2103.                                 $tipoAtual = null;
2104.                                 
2105.                           
2106.                                 
2107.                                 if (!empty($pl_numeros)) {
2108.                                 
2109.                                     sort($pl_numeros);
2110.                                 
2111.                                     $menor = min($pl_numeros);
2112.                                     $maior = max($pl_numeros);
2113.                                 
2114.                                     $menorNome = 'PL ' . number_format($menor, 0, '', '.');
2115.                                     $maiorNome = 'PL ' . number_format($maior, 0, '', '.');
2116.                                 
2117.                                     $esperado = range($menor, $maior);
2118.                                     $faltantes = array_diff($esperado, $pl_numeros);
2119.                                 
2120.                                     foreach ($faltantes as $f) {
2121.                                         $docs_faltantes[] = 'PL ' . number_format($f, 0, '', '.');
2122.                                     }
2123.                                 
2124.                                     $tipoAtual = 'PL';
2125.                                 }
2126.                                 
2127.                           
2128.                                 
2129.                                 elseif (!empty($req_numeros)) {
2130.                                 
2131.                                     sort($req_numeros);
2132.                                 
2133.                                     $menor = min($req_numeros);
2134.                                     $maior = max($req_numeros);
2135.                                 
2136.                                     $menorNome = str_pad($menor, 2, '0', STR_PAD_LEFT) . '.' . $req_ano;
2137.                                     $maiorNome = str_pad($maior, 2, '0', STR_PAD_LEFT) . '.' . $req_ano;
2138.                                 
2139.                                     $esperado = range($menor, $maior);
2140.                                     $faltantes = array_diff($esperado, $req_numeros);
2141.                                 
2142.                                     foreach ($faltantes as $f) {
2143.                                         $docs_faltantes[] = str_pad($f, 2, '0', STR_PAD_LEFT) . '.' . $req_ano;
2144.                                     }
2145.                                 
2146.                                     $tipoAtual = 'REQUERIMENTO';
2147.                                 }                                                                        
2148.                                                                                                                             
2149.                                                                 
2150.                                     $html .= '<h6>' . htmlspecialchars(implode(', ', $docs)) . '</h6>
2151.                                     <hr>';
2152.                                    
2153.     
2154.     
2155.                                     $html .= '<h6>Conteúdo:</h6>';
2156.     
2157.                                     $html .= '<div class="lis">';
2158.                                     foreach ($docs_class as $classs_nome) {
2159.                                     $html .= '
2160.                                         <li>' . $classs_nome. '</li>';
2161.                                     }
2162.                                     $html .= '</div><br>';
2163.                                     
2164.                                     
2165.                                     if ($menorNome !== null && $maiorNome !== null) {
2166.                                         $html .= '<h6>'.$menorNome.' Até '.$maiorNome.'</h6>';
2167.                                     }
2168.         
2169.                                     if($docs_faltantes != []){
2170.                                         $html .= '
2171.                                         <div class="lis2"><p>';
2172.                                                 $html .= 'Faltantes*</br>';
2173.                                                 $qtdFaltantes = count($docs_faltantes);
2174.     
2175.                                                 if ($qtdFaltantes > 40) {
2176.                                                 
2177.                                                     $html .= '<span style="color:red; font-weight:bold;font-size: 8px">
2178.                                                         Existem ' . $qtdFaltantes . ($tipoAtual === 'PL' ? ' projetos de lei ' : ' requerimentos ') . 'faltantes.
2179.                                                         Conferir no inventário.
2180.                                                     </span>';
2181.                                                 
2182.                                                 } else {
2183.                                                 
2184.                                                 $html .= implode(' | ', $docs_faltantes);
2185.     
2186.                                                 
2187.                                                 }
2188.                                             
2189.                                         $html .= '</p></div>';
2190.                                     }
2191.                                 }
2192.                                 else{
2193.                                     
2194.                                                                 // Remove duplicados
2195.                                 $docs_assunto = array_unique($docs_assunto);
2196.                                 
2197.                                 // Converte para DateTime
2198.                                 $datasObj = array_map(function ($data) {
2199.                                     return DateTime::createFromFormat('m/Y', $data);
2200.                                 }, $docs_assunto);
2201.                                 
2202.                                 // Remove possíveis datas inválidas
2203.                                 $datasObj = array_filter($datasObj);
2204.                                 
2205.                                 // Ordena por data
2206.                                 usort($datasObj, function ($a, $b) {
2207.                                     return $a <=> $b;
2208.                                 });
2209.                                 
2210.                                 $resultado = [];
2211.                                 
2212.                                 if (count($datasObj) > 0) {
2213.                                 
2214.                                     $inicio = $datasObj[0];
2215.                                     $anterior = $datasObj[0];
2216.                                 
2217.                                     for ($i = 1; $i < count($datasObj); $i++) {
2218.                                 
2219.                                         $atual = $datasObj[$i];
2220.                                 
2221.                                         $proximoEsperado = clone $anterior;
2222.                                         $proximoEsperado->modify('+1 month');
2223.                                 
2224.                                         if ($atual->format('m/Y') !== $proximoEsperado->format('m/Y')) {
2225.                                 
2226.                                             if ($inicio->format('m/Y') === $anterior->format('m/Y')) {
2227.                                                 $resultado[] = $inicio->format('m/Y');
2228.                                             } else {
2229.                                                 $resultado[] = $inicio->format('m/Y') . ' até ' . $anterior->format('m/Y');
2230.                                             }
2231.                                 
2232.                                             $inicio = $atual;
2233.                                         }
2234.                                 
2235.                                         $anterior = $atual;
2236.                                     }
2237.                                 
2238.                                     // Fecha o último bloco
2239.                                     if ($inicio->format('m/Y') === $anterior->format('m/Y')) {
2240.                                         $resultado[] = $inicio->format('m/Y');
2241.                                     } else {
2242.                                         $resultado[] = $inicio->format('m/Y') . ' Até ' . $anterior->format('m/Y');
2243.                                     }
2244.                                 }
2246.                                 
2247.                                     
2248.                                     
2249.                                     
2250.                                     
2251.                                     $html .= '<h6>Conteúdo:</h6>';
2252.     
2253.                                     $html .= '<div class="lis">';
2254.                                     foreach ($docs_class as $classs_nome) {
2255.                                     $html .= '
2256.                                         <li>' . $classs_nome. '</li>';
2257.                                     }
2258.                                     $len = count($resultado);
2259.                                     if ($len <5 and $len >0) {
2260.                                          
2261.                                          $html .= '<br>';     
2262.                                     }
2263.                                     foreach ($docs_data as $classs_nome) {
2264.                                     $html .= '
2265.                                         <h6>' . $classs_nome. '</h6>';
2266.                                     }
2267.                                     
2268.                                     
2269.                                     
2270.                                         
2271.                                     foreach ($resultado as $classs_nome) {
2272.                                         if ($len >= 9) {
2273.                                             $fontSize = 8;
2274.                                         } 
2275.                                         elseif ($len <10 and $len >5) {
2276.                                             $fontSize = 10;
2277.                                         }
2278.                                         
2279.                                         elseif ($len <5 and $len >0) {
2280.                                             $fontSize = 12;
2281.                                              
2282.                                         }else{
2283.                                             $fontSize = 8;
2284.                                         }
2285.                                         
2286.                                     $html .= '
2287.                                         <p style="font-size: ' . $fontSize . 'px;">' . $classs_nome. '</p>';
2288.                                     }
2289.                                     
2290.                                     $html .= '</div><br>';
2291.                                 }
2292.                                 $html .= 
2293.                                 
2294.                                 
2295.                                 '<div class="lis3"><hr>
2296.                                 
2297.                                 <p>ARQUIVOS GESTÃO DOCUMENTAL</p>
2298.                                 <h5><img src="https://index.arquivosdoc.com.br/img/logo_menu.png" class="img"></h5>
2299.                                 </div>
2300.                                 
2301.                             </div>';
2302.                 
2303.                             if ($count %  10 == 0) {
2304.                                 $html .= '<div style="page-break-after: always;"></div>';
2305.                             }
2306.                         }
2307.                
2309.                         $html .= '</div></body></html>';
2310.                 }
2311.         
2312.                 if($clienteAll_fluxo_id != 17 and $clienteAll_fluxo_id != 40 and $cliente_id != 139 and $cliente_id != 137){
2313.                         // Construção do HTML com os QR Codes
2314.                         $html = '
2315.                         <!DOCTYPE html>
2316.                         <html lang="pt-BR">
2317.                         <head>
2318.                             <meta charset="UTF-8">
2319.                             <meta name="viewport" content="width=device-width, initial-scale=1.0">
2320.                             <title>FLUXO</title>
2321.                             <style>
2322.                                 * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
2323.                                 body { text-transform: uppercase; }
2324.                                 .filho { border: 2px solid black; width: 120mm; height: 170mm; display: inline-block; margin-left: 45px; }
2325.                                 h2 { text-align: center; font-size: 36px; padding: 5px; }
2326.                                 h2 img{width: 200px; height: 200px;}
2327.                                 h4 { text-align: center; font-size: 12px; padding: 10px; }
2328.                                 h5 { text-align: center; font-size: 22px; padding: 10px; }
2329.                                 h6 { text-align: justify; font-size: 26px; padding: 5px; }
2330.                                 h6 img { float: right;  max-height: 70px;width:auto;max-width: 170px}
2331.                                 p { text-align: justify; font-size: 14px; font-weight: bold; padding: 10px; }
2332.                                 .pai { position: relative; top: 20%; }
2333.                                 hr { color: black; }
2334.                                 .lis{
2335.                                 
2336.                                  width:430px; height: 200px;
2337.                                  margin:auto;
2338.                                  font-weight: bold;
2339.                                 }
2340.                                 li{
2341.                                   margin-left:10px;
2342.                                 }
2343.                                 
2344.                             </style>
2345.                         </head>
2346.                         <body>
2347.                         <div class="pai">';
2348.         
2349.                         $count = 0;
2350.         
2351.                         foreach ($fluxo_caixas as $caixa) {
2352.                             $count++;
2353.                             $documento_fluxo = $caixa->getDocumentos()->toArray();
2354.         
2355.                             // Gerar QR Code
2356.                             $qrCode = Builder::create()
2357.                                 ->writer(new PngWriter())
2358.                                 ->data("https://ged.arquivosdoc.com.br/info/caixa/" . $caixa->getId())
2359.                                 ->build();
2360.                             $qrCodeBase64 = base64_encode($qrCode->getString());
2361.         
2362.                             $html .= '<div class="filho">
2363.                                 <h2>' . htmlspecialchars($caixa->getNome()) . '</h2>
2364.                                 <hr>
2365.                                 <h6>Arquivos:<img src="'.$cliente_all_Url.'" class="img"></h6>
2366.                                 <p>' . htmlspecialchars($fluxo_pdf->getNome()) . '</p>
2367.                                 <hr>
2368.                                 <h6>Título:</h6>';
2369.         
2370.                             $docs = [];
2371.                             
2372.                             if (!empty($documento_fluxo)) {
2373.                                 foreach ($documento_fluxo as $doc) {
2374.                                     if($doc->getTipo() != NULL ){
2375.                                         if ($cliente_id != 122) {
2376.                                             $docs[] = $doc->getTipo()->getNome();
2377.                                         } else {
2378.                                             $docs[] = $doc->getNome();
2379.                                         }
2380.                                     }
2381.                                 }
2382.                                 $docs = array_unique($docs);
2383.                             }
2384.                             
2385.                             $docs_class = [];
2386.                             
2387.                             if (!empty($documento_fluxo)) {
2388.                                 foreach ($documento_fluxo as $doc) {
2389.                                     
2390.                                     if($doc->getClassificacao() != NULL ){
2391.                                        $clss =  $entityManager->getRepository(Classificacao::class)->findBy(['id' => $doc->getClassificacao()->getId()]);
2392.                                        $class_nome =  $clss[0]->getNome();
2393.                                        $docs_class[] = $class_nome;
2394.                                        
2395.                                         
2396.                                     }
2397.                                 }
2398.                                 $docs_class = array_unique($docs_class);
2399.                             }
2400.                             
2401.         
2402.                             $html .= '<p>' . htmlspecialchars(implode(', ', $docs)) . '</p>
2403.                                 <hr>
2404.                                 <h6>Conteúdo:</h6>';
2405.                                 
2406.                                 
2407.                                 
2408.                                   if($clienteAll_fluxo_id == 41){
2409.                                       
2410.                                         $html .= '<div class="lis">';
2411.                                         $len = count($docs_class);
2412.                                      
2413.                                         foreach ($docs_class as $classs_nome) {
2414.                                         
2415.                                         
2416.                                             
2417.                                             if ($len <= 9) {
2418.                                                 $fontSize = 16;
2419.                                             } 
2420.                                             elseif ($len <= 11) {
2421.                                                 $fontSize = 14;
2422.                                             } 
2423.                                             elseif ($len <= 13) {
2424.                                                 $fontSize = 12;
2425.                                             } 
2426.                                             elseif ($len <= 16) {
2427.                                                 $fontSize = 10;
2428.                                             }
2429.                                             elseif ($len <= 18) {
2430.                                                 $fontSize = 9;
2431.                                             }
2432.                                             elseif ($len <= 21) {
2433.                                                 $fontSize =8;
2434.                                             }
2435.                                             elseif ($len <= 23) {
2436.                                                 $fontSize = 7;
2437.                                             }
2438.                                             else {
2439.                                                 $fontSize = 6;
2440.                                             }
2441.                                             $html .= '<li style="font-size: ' . $fontSize . 'px;">' . $classs_nome . '</li>';
2442.                                         }
2443.                                         
2444.                                         $html .= '</div>';
2445.                                         
2446.                                       
2447.                                   }else{
2448.                                              $html .= '
2449.                                                 <h2><img src="data:image/png;base64,' . $qrCodeBase64 . '" alt="QR Code"></h2>';
2450.                                   }  
2451.                                         
2452.                                 
2453.                                 
2454.                                 $html .= '<hr>
2455.                                 <h4>ARQUIVOS GESTÃO DOCUMENTAL</h4>
2456.                                 <h5><img src="https://index.arquivosdoc.com.br/img/arquivos_mini.png" class="img"></h5>
2457.                                 <hr>
2458.                                 <h4>Etiqueta gerada automaticamente pelo ArquivosGED</h4>
2459.                             </div>';
2460.         
2461.                             if ($count % 2 == 0) {
2462.                                 $html .= '<div style="page-break-after: always;"></div>';
2463.                             }
2464.                         }
2465.                
2466.         
2467.                         $html .= '</div></body></html>';
2468.                 }
2469.         
2470.                 
2471.                 if($clienteAll_fluxo_id == 17 ){
2472.                     // Construção do HTML com os QR Codes
2473.                     $html = '
2474.                     <!DOCTYPE html>
2475.                     <html lang="pt-BR">
2476.                     <head>
2477.                         <meta charset="UTF-8">
2478.                         <meta name="viewport" content="width=device-width, initial-scale=1.0">
2479.                         <title>FLUXO</title>
2480.                         <style>
2481.                             * { margin: 0; padding: 0; font-family: Calibri, sans-serif; }
2482.                             .filho { border: 2px solid black; width: 125mm; height: 170mm; display: inline-block; margin-left: 45px; }
2483.                             h2 { font-size: 36px; padding: 5px; }
2484.                             h2 img{width: 200px; height: 200px;}
2485.                             .img_footer{width: 60px; height: 60px;position:relative;top:20px}
2486.                             h4 { text-align: center; font-size: 12px; padding: 10px; }
2487.                             h5 { text-align: center; font-size: 22px; padding: 10px; }
2488.                             h6 { text-align: justify; font-size: 26px; padding: 5px; }
2489.                             h6 img { float: right;  max-height: 77px;width:auto;max-width: 250px}
2490.                             p { text-align: justify; font-size: 18px; font-weight: bold; padding: 10px; }
2491.                             .pai { position: relative; top: 20%; }
2492.                             hr { color: black; }
2493.                             .rodape {
2494.                                 position:relative;bottom:15px
2495.                             }
2496.         
2497.                             
2498.                         </style>
2499.                     </head>
2500.                     <body>
2501.                     <div class="pai">';
2502.             
2503.                     $count = 0;
2504.         
2505.                     $codigo = "";
2506.                     $info = "";
2507.                     $prazo = "";
2508.         
2509.                     if($cliente_id == 113){
2510.                         $codigo = "23.182";
2511.                         $info = "PROCESSOS DIVERSOS";
2512.                         $prazo = "57 ANOS";
2513.                     }
2514.         
2515.                     if($cliente_id == 114){                        
2516.                         $codigo = "23.11";
2517.                         $info = "PROCESSOS DE RECURSOS HUMANOS";
2518.                         $prazo = "100 ANOS";
2519.                     }
2520.             
2521.                     foreach ($fluxo_caixas as $caixa) {
2522.         
2523.         
2524.                         $texto = $caixa->getNome();
2525.         
2526.                         preg_match_all('/\d+/', $texto, $matches);
2527.                         
2528.                         if (count($matches[0]) >= 2) {
2529.                              $numero = str_pad($matches[0][0], 3, '0', STR_PAD_LEFT); 
2530.                             $ano = substr($texto, strpos($texto, $matches[0][0]) + strlen($matches[0][0])); 
2531.                             $ano = trim(str_replace('-', '', $ano)); 
2532.                         } else {
2533.                             echo "Formato inválido!";
2534.                         }
2535.         
2536.         
2537.         
2538.                         $count++;
2539.                         $documento_fluxo = $caixa->getDocumentos()->toArray();
2540.         
2541.                         // Gerar QR Code
2542.                         $qrCode = Builder::create()
2543.                             ->writer(new PngWriter())
2544.                             ->data("https://ged.arquivosdoc.com.br/info/caixa/" . $caixa->getId())
2545.                             ->build();
2546.                         $qrCodeBase64 = base64_encode($qrCode->getString());
2547.             
2548.                         $html .= '<div class="filho">
2549.                             <h2>&nbsp;Caixa nº&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'. htmlspecialchars($numero) . '</h2>
2550.                             <hr>
2551.                             <h6>ARQUIVO:<img src="'.$cliente_all_Url. '" class="img"></h6>
2552.                             <p>SAAE VOLTA REDONDA-RJ</p>
2553.                             <hr>
2554.                             <h6>CÓDIGO TEMPORALIDADE:</h6>
2555.                             <p>'.$codigo.'</p><hr>
2556.                             <h6>TÍTULO:</h6>';
2557.             
2558.         
2559.                         $html .= '<p>' . htmlspecialchars('PROCESSOS ADMINISTRATIVOS') . '</p>
2560.                             <hr>
2561.                             <h6>INFORMAÇÕES:</h6>
2562.                             <p>'.$info.'</p>
2563.                             <hr>
2564.                             <h6>PRAZO DE GUARDA:</h6>
2565.                             <p>'.$prazo.'</p>
2566.                             <hr>
2567.                             <h6>DATA:</h6>
2568.                             <p>'.$ano.'</p>
2569.                             <hr>
2570.                            
2571.                                 <p class="rodape">&nbsp;ARQUIVOS GESTÃO DOCUMENTAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
2572.                                 <img src="https://index.arquivosdoc.com.br/img/arquivos_mini.png" class="img_footer"></p>
2573.                            
2574.                             </div>';
2575.             
2576.                         if ($count % 2 == 0) {
2577.                             $html .= '<div style="page-break-after: always;"></div>';
2578.                         }
2579.                     }
2580.            
2581.         
2582.                     $html .= '</div></body></html>';
2583.                 }
2584.                 
2585.                 if($clienteAll_fluxo_id == 40  ){
2586.                         $documento_all_sebrae = $doctrine->getRepository(Documento::class)
2587.                         ->findBy(
2588.                             ['cliente' => $cliente_id], // filtros
2589.                             ['id' => 'DESC'],            // ordenação (opcional)
2590.                             100,                        // LIMIT
2591.                             0                           // OFFSET
2592.                         );
2593.                         $html = '
2594.                         <!DOCTYPE html>
2595.                         <html lang="pt-BR">
2596.                         <head>
2597.                             <meta charset="UTF-8">
2598.                             <meta name="viewport" content="width=device-width, initial-scale=1.0">
2599.                             <title>FLUXO</title>
2600.                             <style>
2601.                                 * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
2602.                                 body { text-transform: uppercase; }
2603.                                 .filho { border: 2px solid black; width: 120mm; height: 160mm; display: inline-block; margin-left: 20px;padding:10px;} 
2604.                                 h2 { text-align: center; font-size: 36px; padding: 5px; }
2605.                                 h2 img{width: 200px; height: 200px;}
2606.                                 h4 { text-align: center; font-size: 12px; padding: 10px; }
2607.                                 h5 { text-align: center; font-size: 22px; padding: 10px; }
2608.                                 h6 { text-align: justify; font-size: 26px; padding: 5px; }}
2609.                                 p { text-align: justify; font-size: 18px; font-weight: bold; padding: 10px; }
2610.                                 .pai { position: relative; top: 20%;text-align:center; }
2611.                                 hr { color: black; }
2612.                                 
2613.                                     .linha {
2614.                                         margin-bottom: 1mm;
2615.                                         font-size: 10pt;
2616.                                     }
2618.                                     .box-label {
2619.                                         background: #f1f1f1;
2620.                                         border: 1px solid black;
2621.                                         padding: 1mm;
2622.                                         font-size: 8pt;
2623.                                         text-align: center;
2624.                                         margin-top: 1mm;
2625.                                     }
2627.                                     .box-value {
2628.                                         text-align: center;
2629.                                         font-size: 10pt;
2630.                                         margin: 2mm 0 2mm 0;
2631.                                         
2632.                                     }
2633.                                    .box-value_conteudo {
2634.                                         margin: 2mm 0 2mm 0;
2635.                                         text-align: justify;
2636.                                        
2637.                                     }
2638.                                     
2639.                                     img{
2640.                                         width: 120px;
2641.                                         height:80px;
2642.                                         margin: 2mm 0 2mm 0;
2643.                                     }
2644.                                     
2645.                                     .titulo{
2646.                                         margin: 2mm 0 2mm 0;
2647.                                         font-size: 10pt;
2648.                                     }
2649.                                     
2650.                                     .bloco-conteudo {
2651.                                         position: relative;
2652.                                         height: 100%;
2653.                                     }
2654.                                     
2655.                                     .hr-fixo {
2656.                                         position: absolute;
2657.                                         bottom: 0;
2658.                                         left: 0;
2659.                                         width: 100%;
2660.                                         margin: 0 0 0 0;
2661.                                     }
2662.                                     
2664.                                 
2665.                             </style>
2666.                         </head>
2667.                         <body>
2668.                         <div class="pai">';
2669.                 
2670.                         $count = 0;
2671.                 
2672.                         foreach ($documento_all_sebrae as $caixa) {
2673.                             $count++;
2674.                                 $conteudo = htmlspecialchars(str_replace('?', '', $caixa->getExtraFields()));
2675.                                 $tamanho = strlen($conteudo);
2676.                                 $dates="";
2677.                             
2678.                                 if ($tamanho <= 300) {
2679.                                     $fontSize = '8pt';
2680.                                 } elseif ($tamanho <= 600) {
2681.                                     $fontSize = '7pt';
2682.                                 } elseif ($tamanho <= 900) {
2683.                                     $fontSize = '6pt';
2684.                                 } else {
2685.                                     $fontSize = '4pt';
2686.                                 }
2687.                                 
2688.                                 if($caixa->getDataDocumento()){
2689.                                     $dates=$caixa->getDataDocumento()->format('d/m/Y');
2690.                                 }
2691.                             
2692.                                 $html .= 
2693.                                     '<div class="filho">
2694.                                         <div class="bloco-conteudo">
2695.                                         
2696.                                             <img src="'.$cliente_all_Url.'" class="img"></h6>
2697.                             
2698.                                             <div class="titulo">ARQUIVO INATIVO</div><br>
2699.                             
2700.                                             <div class="linha">CAIXA Nº: _______________</div>
2701.                             
2702.                                             <div class="box-label">ÁREA/SIGLA:</div>
2703.                                             <div class="box-value">'. htmlspecialchars($caixa->getAssunto()) .'</div>
2704.                             
2705.                                             <div class="box-label">RESPONSÁVEL:</div>
2706.                                             <div class="box-value">'. htmlspecialchars($caixa->getConteiner()) .'</div>
2707.                             
2708.                                             <div class="box-label">DATA 1º ENVIO:</div>
2709.                                             <div class="box-value">'. htmlspecialchars($dates) .'</div>
2710.                             
2711.                                             <div class="box-label">Conteúdo</div>
2712.                                             <div class="box-value_conteudo" style="font-size: '. $fontSize .'">'. $conteudo .'</div>
2713.                                             
2714.                                             <div class="hr-fixo">
2715.                                                 <hr>
2716.                                                 <div>CXRBM:'. htmlspecialchars($caixa->getNome()) .'</div>
2717.                                             </div>
2718.                             
2719.                                         </div>
2720.         </div>';
2721.                             $docs = [];
2722.                             if ($count % 2 == 0) {
2723.                                 $html .= '<div style="page-break-after: always;"></div>';
2724.                             }
2725.                         }
2726.                
2728.                         $html .= '</div></body></html>';
2729.                 }
2730.                         
2731.                
2732.                
2733.                 // Configurar o Dompdf
2734.                 $options = new Options();
2735.                 $options->set('isHtml5ParserEnabled', true);
2736.                 $options->set('isPhpEnabled', true);
2737.                 $options->set('isRemoteEnabled', true);
2738.                 $dompdf = new Dompdf($options);
2739.                 $dompdf->loadHtml($html);
2740.                 $dompdf->setPaper('A4', 'landscape');
2741.         
2742.                 // LIMPA TODOS OS BUFFERS ANTES DE RENDERIZAR
2743.                 while (ob_get_level()) {
2744.                     ob_end_clean();
2745.                 }
2746.         
2747.                 // Tenta renderizar e, em vez de stream() direto, grava em arquivo temporário e envia
2748.                 try {
2749.                     $dompdf->render();
2750.                 } catch (Throwable $e) {
2751.                     // registra o erro e lança para cair no catch externo
2752.                     error_log('Dompdf render failed: ' . $e->getMessage());
2753.                     throw $e;
2754.                 }
2755.         
2756.                 // Gera arquivo temporário seguro
2757.                 $tempFile = sys_get_temp_dir() . DIRECTORY_SEPARATOR . 'etiqueta_fluxo_' . $id_fluxo . '_' . uniqid() . '.pdf';
2758.                 $output = $dompdf->output();
2759.         
2760.                 if (file_put_contents($tempFile, $output) === false) {
2761.                     throw new Exception('Falha ao escrever arquivo temporário do PDF.');
2762.                 }
2763.         
2764.                 // Força headers corretos para download/visualização
2765.                 header('Content-Type: application/pdf');
2766.                 // Se quiser forçar download use attachment; se quiser abrir no browser use inline
2767.                 header('Content-Disposition: inline; filename="Etiqueta_Fluxo_' . preg_replace('/[^A-Za-z0-9_\-\.]/', '_', $id_fluxo . '_' . $nome_fluxo) . '.pdf"');
2768.                 header('Content-Length: ' . filesize($tempFile));
2769.                 header('Cache-Control: private, max-age=0, must-revalidate');
2770.         
2771.                 // Envia o arquivo binário ao navegador
2772.                 readfile($tempFile);
2773.         
2774.                 // Remove o arquivo temporário com segurança
2775.                 @unlink($tempFile);
2776.         
2777.                 // finaliza execução
2778.                 exit;
2779.         
2780.                 
2781.             } catch (Exception $e) {
2782.                 // Loga para diagnóstico e mostra mensagem amigável
2783.                 error_log('Erro ao gerar o PDF: ' . $e->getMessage());
2784.                 echo 'Erro ao gerar o PDF: ' . htmlspecialchars($e->getMessage());
2785.             }
2786.         
2787.         
2789. }
2791.         if (isset($_POST["qrcode"])) {
2792.                 $id_fluxo = $_POST["qrcode"];
2793.                 $fluxo_qrcode = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($_POST["qrcode"]);
2794.                 $nome_fluxo = $fluxo_qrcode->getNome();
2795.                 $fluxo_caixas_qrcode = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_qrcode->getId());
2796.                 $clienteAll_id = $fluxo_qrcode->getCliente()->getId();
2797.                 
2798.                 if ($fluxo_caixas_qrcode != null ) {
2799.                     $options = new Options();
2800.                     $options->set('isHtml5ParserEnabled', true);
2801.                     $options->set('isPhpEnabled', true);
2802.                     $dompdf = new Dompdf($options);
2803.                             
2804.                     $html = '
2805.                         <html>
2806.                             <head>
2807.                                 <style>
2808.                                     @page {
2809.                                         margin: 35px 18.9px 0px 18.9px;
2810.                                         size: 210mm 297mm; /* Ajuste de tamanho do papel */
2811.                                     }
2812.                                     body {
2813.                                         margin: 0;
2814.                                         padding: 0;
2815.                                     }
2816.                                     .qr-item {
2817.                                         border: 2px dotted #000;
2818.                                         text-align: center;
2819.                                         width: 32.27mm;
2820.                                         height: 34.9mm; 
2821.                                         display: inline-block;
2822.                                     }
2823.                         
2824.                                     .qr-item img {
2825.                                         width: 115px; 
2826.                                         height: 112px;
2827.                                     }
2828.                                     .qr-title {
2829.                                         font-size: 16px;
2830.                                         font-weight: bold;
2831.                                     }
2832.                                     .leo {
2833.                                         display: flex;
2834.                                         flex-wrap: wrap;
2835.                                     }
2836.                                 </style>
2837.                             </head>
2838.                             <body>';
2839.             
2840.                     $count = 0; // Contador de QR Codes
2841.             
2842.                     foreach ($fluxo_caixas_qrcode as $cx) {
2843.                         $id_cx_ultimo = $cx->getCx();
2844.             
2845.                         if ($id_cx_ultimo !== null) {
2846.                             $nome = $id_cx_ultimo->getNome();
2847.             
2848.                             // Gerar QR Code com imagem no centro
2849.                             $result = Builder::create()
2850.                                 ->writer(new PngWriter())
2851.                                 ->writerOptions([])
2852.                                 ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$nome)
2853.                                 ->encoding(new Encoding('UTF-8'))
2854.                                 ->size(500)
2855.                                 ->margin(5)
2856.                                 ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
2857.                                 ->build();
2858.                             
2859.                             // Salvar QR Code como arquivo temporário
2860.                             $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
2861.                             $result->saveToFile($tempFile);
2862.             
2863.                             // Adicionar QR Code ao HTML
2864.                             if ($count % 48 == 0) {
2865.                                 $html .= '<div class="leo">';
2866.                             }
2867.             
2868.                             $html .= '<div class="qr-item">';
2869.                             $html .= '<div class="qr-title">' . $nome . '</div>';
2870.                             $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
2871.                             $html .= '</div>';
2872.             
2873.                             $count++;
2874.             
2875.                             // Fechar a div e inserir quebra de página a cada 63 QR Codes
2876.                             if ($count % 48 == 0) {
2877.                                 $html .= '</div><div style="page-break-after: always;"></div>';
2878.                             }
2879.                         }
2880.                     }
2881.             
2882.                     // Fechar qualquer div aberta sem completar 63 itens
2883.                     if ($count % 48 != 0) {
2884.                         $html .= '</div>';
2885.                     }
2886.             
2887.                     $html .= '</body></html>';
2888.             
2889.                     // Carregar o HTML e gerar o PDF
2890.                     $dompdf->loadHtml($html);
2891.                     $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
2892.                     $dompdf->render();
2893.                     $dompdf->stream("Qrcode_" . $id_fluxo . "_" . $nome_fluxo . ".pdf", ["Attachment" => 1 ]);
2894.                 } else {
2895.                     echo "<script>alert('ERROR, ESSE FLUXO NÃO TEM SETOR DE GUARDA!');</script>";
2896.                 }
2897.             }
2898.         
2899.         if (isset($_POST["container"])) {
2901.             $id_fluxo = $_POST["container"];
2902.             $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($id_fluxo);
2903.             $fluxo_container = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($id_fluxo);
2904.             $clienteAll_id = $fluxo_container->getCliente()->getId();
2905.             $containers = [];
2906.         
2907.             foreach ($fluxo_caixas as $caixa) {
2909.                 $documentos = $caixa->getDocumentos();
2910.         
2911.                 foreach ($documentos as $documento) {
2912.                     $container = $documento->getConteiner(); 
2913.                     $caixaId = $documento->getCaixa()->getId(); 
2914.                     
2915.                     if ($container != null and $caixaId != null) {
2916.                         
2917.                         if (!isset($containers[$container])) {
2918.                             $containers[$container] = [];
2919.                         }
2920.         
2921.                         if (!in_array($caixaId, $containers[$container])) {
2922.                             $containers[$container][] = $caixaId;
2923.                         }
2924.                     }
2925.                 }
2926.             }
2927.             
2929.             $options = new Options();
2930.             $options->set('isHtml5ParserEnabled', true);
2931.             $options->set('isPhpEnabled', true);
2932.             $dompdf = new Dompdf($options);
2933.                     
2934.             $html = '
2936.                 <html>
2937.                     <head>
2938.                         <style>
2939.                             @page {
2940.                                 margin: 35px 18.9px 0px 18.9px;
2941.                                 size: 210mm 297mm; /* Ajuste de tamanho do papel */
2942.                             }
2943.                             body {
2944.                                 margin: 0;
2945.                                 padding: 0;
2946.                             }
2947.                             .qr-item {
2948.                                 border: 2px dotted #000;
2949.                                 width: 200mm;
2950.                                 height: 80mm;
2951.                                 margin-top:15px; 
2952.                                 text-align: center;
2953.                                
2954.                                 
2955.                             }
2957.                              .img_qrcode h2{                           
2958.                                position:relative;
2959.                                top:25px;
2960.                             }
2962.                             .img_qrcode h3{                           
2963.                                position:relative;
2964.                                bottom:25px;
2965.                                font-size: 20px;
2966.                             }
2968.                             .img_qrcode{
2969.                                
2970.                                 display: inline-block;
2971.                                 margin: 5px  30px 5px 30px;
2972.                                
2973.                                
2974.                             }
2975.                 
2976.                             .qr-item img {
2977.                                 
2978.                                 width: 170px; 
2979.                                 height: 170px;
2980.                                 
2981.                             }
2982.                             .qr-title {
2983.                                 font-size: 70px;
2984.                                 font-weight: bold;
2985.                                
2987.                             }
2988.                             .leo {
2989.                                 display: flex;
2990.                                 flex-wrap: wrap;
2991.                             }
2992.                         </style>
2993.                     </head>
2994.                     <body>';
2995.     
2996.             $count = 0; // Contador de QR Codes
3000.             // Exibir resultado
3001.             foreach ($containers as $container => $caixas) {
3003.                 #echo "Container $container => " . implode(", ", $caixas) . "<br>";
3005.                 
3007.                
3008.                 if ($count % 3 == 0) {
3009.                     $html .= '<div class="leo">';
3010.                 }
3012.                 $html .= '<div class="qr-item">';
3013.                 $html .= '<div class="qr-title">' . $container . '</div><hr>';
3016.                 foreach($caixas as $caixa ){
3017.                     $caix = $doctrine->getRepository(Caixa::class)->find($caixa);
3018.                     $caix_nome =$caix->getNome();
3019.                     $caix_cx =$caix->getCx()->getNome();
3020.                     $result = Builder::create()
3021.                     ->writer(new PngWriter())
3022.                     ->writerOptions([])
3023.                     ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$caix_cx)
3024.                     ->encoding(new Encoding('UTF-8'))
3025.                     ->size(350)
3026.                     ->margin(5)
3027.                     ->logoPath(__DIR__ . '/logo.png') 
3028.                     ->build();
3029.                 
3030.                 
3031.                     $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
3032.                     $result->saveToFile($tempFile);
3033.                     
3034.                     $html .= '
3035.                         <div class="img_qrcode">    
3036.                             <h2>'.$caix_cx.'</h2>
3037.                             <img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">
3038.                             <h3>'.$caix_nome.'</h3>
3039.                         </div>
3040.                     
3041.                     ';
3042.                 }
3043.                 $html .= '</div>';
3045.                 $count++;
3047.                 
3048.                 if ($count % 3 == 0) {
3049.                     $html .= '</div><div style="page-break-after: always;"></div>';
3050.                 }
3051.             }
3054.               // Fechar qualquer div aberta sem completar 63 itens
3055.               if ($count % 3 != 0) {
3056.                 $html .= '</div>';
3057.             }
3058.     
3059.             $html .= '</body></html>';
3060.     
3061.             // Carregar o HTML e gerar o PDF
3062.             $dompdf->loadHtml($html);
3063.             $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
3064.             $dompdf->render();
3065.             $dompdf->stream("Qrcode.pdf", ["Attachment" => 1 ]);
3066.             
3070.         }
3071.         
3072.         if (isset($_POST["pasta"])) {
3073.             
3074.                 // reforça limites (pode ajustar conforme necessário)
3075.                 ini_set('max_execution_time', 500);
3076.                 ini_set('memory_limit', '3512M');
3077.         
3078.                 $id_fluxo = $_POST["pasta"];
3079.                 $fluxo_pdf = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($id_fluxo);
3080.                 $cliente_id = $fluxo_pdf->getCliente()->getId();
3081.                 $cliente = $doctrine->getRepository(Cliente::class)->findWithRelations($cliente_id);
3082.                 $nome_fluxo = $fluxo_pdf->getNome();
3083.                 $clienteAll_fluxo = $cliente->getClienteAll()->getLogo();
3084.                 
3085.                 $cmd = $clientS3->getCommand('GetObject', [
3086.                 'Bucket' => 'arquivosdoc',
3087.                 'Key'    => 'LOGO_CLIENTES/'. $clienteAll_fluxo, 
3088.                 ]);
3089.                 
3090.                 $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
3091.                 $cliente_all_Url = (string) $req->getUri();
3092.                 
3093.                 $clienteAll_fluxo_id = $cliente->getClienteAll()->getId();
3094.                 $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_pdf->getId());
3096.                 if($clienteAll_fluxo_id == 39){
3097.                     $html = '
3098.                     <!DOCTYPE html>
3099.                     <html lang="pt-BR">
3100.                     <head>
3101.                         <meta charset="UTF-8">
3102.                         <meta name="viewport" content="width=device-width, initial-scale=1.0">
3103.                         <title>FLUXO</title>
3104.                         <style>
3105.                             * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
3106.                             body { text-transform: uppercase; }
3107.                             .filho { border: 2px solid black; width: 67.8mm; height: 145mm; display: inline-block; margin: 0px 2px 2px 2px; position: relative; }
3108.                             h2 { text-align: center; font-size: 30px; padding: 5px; }
3109.                             h2 img{width: 250px; height: 250px;}
3110.                             h4 { text-align: center; font-size: 14px; padding: 10px; }
3111.                             h5 { text-align: center; font-size: 16px;}
3112.                             h6 { text-align: center; font-size: 18px; padding: 20px; }
3113.                             h5 img { text-align: center;max-height: 40px;width:auto;max-width: 40px}
3114.                             h6 img { text-align: center;margin:auto;  max-height: 200px;width:auto;max-width: 200px}
3115.                             p { text-align: center; font-size: 12px; font-weight: bold;}
3116.                             .pai { position: relative; top: 11%; }
3117.                             hr { color: black; }
3118.                             .lis2{
3119.                                         
3120.                                 font-weight: bold;
3121.                                 margin:5px;
3122.                             }
3123.                             .lis3 {
3124.                                 position: absolute;
3125.                                 bottom: 0;
3126.                                 width: 100%;
3127.                                 font-weight: bold;
3128.                                 text-align: center;
3129.                                 margin-bottom:5px;
3130.                                 margin-top:5px;
3131.                             }
3132.                             .lis{
3133.                                 
3134.                                 margin-left:10px;
3135.                                 font-weight: bold;
3136.                             }
3137.                             li{
3138.                                 margin:10px;
3139.                                 font-size: 18px;
3140.                             }
3141.                             
3142.                         </style>
3143.                     </head>
3144.                     <body>
3145.                     <div class="pai">';
3146.             
3147.                     $count = 0;
3148.             
3149.                     foreach ($fluxo_caixas as $caixa) {
3150.                         $count++;
3151.                         $documento_fluxo = $caixa->getDocumentos()->toArray();
3152.                         
3153.                         
3154.                         $html .= '<div class="filho">
3155.                             
3156.                             
3157.                             <h6><img src="'.$cliente_all_Url.'" class="img"></h6>
3158.                             <hr>
3159.                             <h2>' . htmlspecialchars($caixa->getNome()) . '</h2>
3160.                             <hr>
3161.                             ';
3162.             
3163.                         $docs = [];
3164.                         
3165.                         if (!empty($documento_fluxo)) {
3166.                             foreach ($documento_fluxo as $doc) {
3167.                                 if($doc->getTipo() != NULL ){
3168.                                     if ($cliente_id != 122) {
3169.                                         $docs[] = $doc->getTipo()->getNome();
3170.                                     } else {
3171.                                         $docs[] = $doc->getNome();
3172.                                     }
3173.                                 }
3174.                             }
3175.                             $docs = array_unique($docs);
3176.                         }
3178.                         
3179.                         $docs_class = [];
3180.                         
3181.                         if (!empty($documento_fluxo)) {
3182.                             foreach ($documento_fluxo as $doc) {
3183.                                 
3184.                                 if($doc->getClassificacao() != NULL ){
3185.                                     $clss =  $entityManager->getRepository(Classificacao::class)->findBy(['id' => $doc->getClassificacao()->getId()]);
3186.                                     $class_nome =  $clss[0]->getNome();
3187.                                     $docs_class[] = $class_nome;
3188.                                     
3189.                                 }
3190.                             }
3191.                             $docs_class = array_unique($docs_class);
3192.                         }
3195.                         $docs_data = [];
3196.                         $mapa = [];
3198.                         if (!empty($documento_fluxo)) {
3199.                             foreach ($documento_fluxo as $data) {
3200.                                 if ($data->getNome() != null) {
3201.                                     $docs_data[] = $data->getNome();
3202.                                 }
3203.                             }
3204.                             $docs_data = array_unique($docs_data);
3205.                         }
3207.                         $numeros = [];
3208.                         foreach ($docs_data as $doc) {
3209.                             if (preg_match('/PL-(\d+)/', $doc, $matches)) {
3210.                                 $numero = (int) $matches[1];
3212.                                 $numeros[] = $numero;
3213.                                 $mapa[$numero] = $doc; // ✅ CORRETO
3214.                             }
3215.                         }
3217.                         if (!empty($numeros)) {
3218.                             $menor = min($numeros);
3219.                             $maior = max($numeros);
3221.                             $menorNome = $mapa[$menor];
3222.                             $maiorNome = $mapa[$maior];
3223.                         } else {
3224.                             $menor = null;
3225.                             $maior = null;
3226.                             $menorNome = null;
3227.                             $maiorNome = null;
3228.                         }
3231.                         /* Sequência completa e faltantes */
3232.                         $sequenciaCompleta = range($menor, $maior);
3233.                         $faltantes = array_diff($sequenciaCompleta, $numeros);
3235.                         /* Nomes faltantes */
3236.                         $docs_faltantes = [];
3237.                         
3238.                         if($docs_faltantes != []){
3239.                             foreach ($faltantes as $num) {
3240.                                 $docs_faltantes[] = 'PL_' . str_pad($num, 3, '0', STR_PAD_LEFT);
3241.                             }
3242.                         }
3244.                         
3246.                                                     
3247.                         
3248.                         
3249.                         $html .= '<h6>' . htmlspecialchars(implode(', ', $docs)) . '</h6>
3250.                             <hr>';
3251.                             
3254.                             $html .= '<h6>Conteúdo:</h6>';
3256.                             $html .= '<div class="lis">';
3257.                             foreach ($docs_class as $classs_nome) {
3258.                             $html .= '
3259.                                 <li>' . $classs_nome. '</li>';
3260.                             }
3261.                             $html .= '</div>';
3262.                             $html .= '<h6>'.$menorNome.' Até '.$maiorNome.'</h6>';
3263.                             if($docs_faltantes != []){
3264.                                 $html .= '<div class="lis2"><p>';
3265.                                     
3266.                                         foreach ($docs_faltantes as $data) {
3267.                                             $html .= 'Faltantes*: | ' . $data. ' | ';
3268.                                         }
3269.                                     
3270.                                 $html .= '</p></div>';
3271.                             }
3272.                             /*$html .= '
3273.                                     <div class="lis3"><hr>
3274.                                     
3275.                                     <p>ARQUIVOS GESTÃO DOCUMENTAL</p>
3276.                                     <h5><img src="https://index.arquivosdoc.com.br/img/logo_menu.png" class="img"></h5>
3277.                                     </div>
3278.                                     
3279.                                 </div>';*/
3280.                             
3281.                             $html .= '</div>';
3282.             
3283.                         if ($count %  6 == 0) {
3284.                             $html .= '<div style="page-break-after: always;"></div>';
3285.                         }
3286.                     }
3287.             
3289.                     $html .= '</div></body></html>';
3290.                 }
3291.                 
3292.                 if($clienteAll_fluxo_id == 41){
3293.                      $html = '
3294.                             <!DOCTYPE html>
3295.                             <html lang="pt-BR">
3296.                             <head>
3297.                                 <meta charset="UTF-8">
3298.                                 <meta name="viewport" content="width=device-width, initial-scale=1.0">
3299.                                 <title>FLUXO</title>
3300.                                 <style>
3301.                                     * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
3302.                                     body { text-transform: uppercase; }
3303.                                     .filho { border: 2px solid black; width: 50mm; height: 144mm; display: inline-block; margin: 2px; position: relative;}
3304.                                     h2 { text-align: center; font-size: 20px; padding: 5px; }
3305.                                     h2 img{width: 250px; height: 250px;}
3306.                                     h4 { text-align: center; font-size: 12px; padding: 10px; }
3307.                                     h5 { text-align: center; font-size: 14px;}
3308.                                     h6 { text-align: center; font-size: 14px; padding: 5px; }
3309.                                     h5 img { text-align: center;max-height: 40px;width:auto;max-width: 40px}
3310.                                     h6 img { text-align: center;margin:auto;  max-height: 130px;width:auto;max-width: 130px}
3311.                                     p { text-align: center; font-size: 8px; font-weight: bold;}
3312.                                     .pai { position: relative; top: 11%; }
3313.                                     hr { color: black; }
3314.                                     .lis2{
3315.                                         
3316.                                         font-weight: bold;
3317.                                     }
3318.                                     .lis3 {
3319.                                         position: absolute;
3320.                                         bottom: 0;
3321.                                         width: 100%;
3322.                                         font-weight: bold;
3323.                                         text-align: center;
3324.                                         margin-bottom:5px;
3325.                                         margin-top:5px;
3326.                                            
3327.                                     }
3328.                                     .lis{
3329.                                         
3330.                                         margin-left:10px;
3331.                                         font-weight: bold;
3332.                                     }
3333.                                     li{
3334.                                        font-size: 12px;
3335.                                        margin-left:2px;
3336.                                     }
3337.                                     
3338.                                 </style>
3339.                             </head>
3340.                             <body>
3341.                             <div class="pai">';
3342.             
3343.                     $count = 0;
3344.             
3345.                     
3346.                             foreach ($fluxo_caixas as $caixa) {
3347.                                 $count++;
3348.                                 $documento_fluxo = $caixa->getDocumentos()->toArray();
3349.                                 
3350.                     
3351.                                 $html .= '<div class="filho">
3352.                                     
3353.                                     
3354.                                     <h6><img src="'.$cliente_all_Url.'" class="img"></h6>
3355.                                     <hr>
3356.                                     <h2>' . htmlspecialchars($caixa->getNome()) . '</h2>
3357.                                     <hr>
3358.                                     ';
3359.                     
3360.                                 $docs = [];
3361.                                 
3362.                                 if (!empty($documento_fluxo)) {
3363.                                     foreach ($documento_fluxo as $doc) {
3364.                                         if($doc->getTipo() != NULL ){
3365.                                             if ($cliente_id != 122) {
3366.                                                 $docs[] = $doc->getTipo()->getNome();
3367.                                             } else {
3368.                                                 $docs[] = $doc->getNome();
3369.                                             }
3370.                                         }
3371.                                     }
3372.                                     $docs = array_unique($docs);
3373.                                 }
3374.                                 
3375.                                 
3376.     
3377.     
3378.                                 $docs_class = [];
3379.                                 
3380.                                 if (!empty($documento_fluxo)) {
3381.                                     foreach ($documento_fluxo as $doc) {
3382.                                         
3383.                                         if($doc->getClassificacao() != NULL ){
3384.                                            $clss =  $entityManager->getRepository(Classificacao::class)->findBy(['id' => $doc->getClassificacao()->getId()]);
3385.                                            $class_nome =  $clss[0]->getNome();
3386.                                            $docs_class[] = $class_nome;
3387.                                             
3388.                                         }
3389.                                     }
3390.                                     $docs_class = array_unique($docs_class);
3391.                                 }
3392.                     
3393.     
3394.                                   $docs_data = [];
3395.                                   if (!empty($documento_fluxo)) {
3396.                                         foreach ($documento_fluxo as $data) {
3397.                                             if ($data->getAssunto() !== null) {
3398.                                                 $docs_data[] = $data->getAssunto();
3399.                                             }
3400.                                         }
3401.                                         $docs_data = array_unique($docs_data);
3402.                                     }
3403.                                 
3404.                               
3405.     
3406.                                 
3407.     
3408.     
3409.                                                             
3410.                                 
3411.                                 
3412.                                 $html .= '<h6>' . htmlspecialchars(implode(', ', $docs)) . '</h6>
3413.                                     <hr>';
3414.                                    
3415.     
3416.     
3417.                                     $html .= '<h6>Conteúdo:</h6>';
3418.     
3419.                                     $html .= '<div class="lis">';
3420.                                     foreach ($docs_class as $classs_nome) {
3421.                                     if($classs_nome == '028.11-COM ÔNUS'){
3422.                                      $html .= '<li>SOLICITAÇÃO DE DIÁRIAS</li>';
3423.                                     }
3424.                                     $html .= '
3425.                                         <li>' . $classs_nome. '</li>';
3426.                                     }
3427.                                     $html .= '</div><br>';
3428.                                     $html .= '<h6>Descrição:</h6>';
3429.                                     $html .= '<div class="lis">';
3430.                                     $len = count($docs_data);
3431.                                     foreach ($docs_data as $assunto_nome) {
3432.                                         
3433.                                     $qtd_letra = mb_strlen($assunto_nome, 'UTF-8');
3434.                                      
3435.                                     if ($len <= 20) {
3436.                                         $fontSize = 12;
3437.                                     } 
3438.                                     
3439.                                     else{
3440.                                         $fontSize = 9;
3441.                                     }
3442.                                     if($qtd_letra > 25 ){
3443.                                         $fontSize = 10;
3444.                                     }
3445.                                     $html .= '<li style="font-size: ' . $fontSize . 'px;">' . $assunto_nome. '</li>';
3446.                                     }
3447.                                     $html .= '</div><br>
3448.                                     <div class="lis3"><hr>
3449.                                     
3450.                                     <p>ARQUIVOS GESTÃO DOCUMENTAL</p>
3451.                                     <h5><img src="https://index.arquivosdoc.com.br/img/logo_menu.png" class="img"></h5>
3452.                                     </div>
3453.                                     
3454.                                 </div>';
3455.                     
3456.                                 #if ($count == 4) {
3457.                                  #   $html .= '<div style="page-break-after: always;"></div>';
3458.                                 #}
3459.                             }
3460.                    
3461.     
3462.                     
3463.                     
3464.             
3465.     
3466.                     $html .= '</div></body></html>';
3467.                 }
3468.         
3469.                 // Configurar o Dompdf
3470.                 $options = new Options();
3471.                 $options->set('isHtml5ParserEnabled', true);
3472.                 $options->set('isPhpEnabled', true);
3473.                 $options->set('isRemoteEnabled', true);
3474.                 $dompdf = new Dompdf($options);
3475.                 $dompdf->loadHtml($html);
3476.                 $dompdf->setPaper('A4', 'portrait');
3477.         
3478.                 // LIMPA TODOS OS BUFFERS ANTES DE RENDERIZAR
3479.                 while (ob_get_level()) {
3480.                     ob_end_clean();
3481.                 }
3482.         
3483.                 // Tenta renderizar e, em vez de stream() direto, grava em arquivo temporário e envia
3484.                 try {
3485.                     $dompdf->render();
3486.                 } catch (Throwable $e) {
3487.                     // registra o erro e lança para cair no catch externo
3488.                     error_log('Dompdf render failed: ' . $e->getMessage());
3489.                     throw $e;
3490.                 }
3491.         
3492.                 // Gera arquivo temporário seguro
3493.                 $tempFile = sys_get_temp_dir() . DIRECTORY_SEPARATOR . 'etiqueta_fluxo_' . $id_fluxo . '_' . uniqid() . '.pdf';
3494.                 $output = $dompdf->output();
3495.         
3496.                 if (file_put_contents($tempFile, $output) === false) {
3497.                     throw new Exception('Falha ao escrever arquivo temporário do PDF.');
3498.                 }
3499.         
3500.                 // Força headers corretos para download/visualização
3501.                 header('Content-Type: application/pdf');
3502.                 // Se quiser forçar download use attachment; se quiser abrir no browser use inline
3503.                 header('Content-Disposition: inline; filename="Etiqueta_Fluxo_' . preg_replace('/[^A-Za-z0-9_\-\.]/', '_', $id_fluxo . '_' . $nome_fluxo) . '.pdf"');
3504.                 header('Content-Length: ' . filesize($tempFile));
3505.                 header('Cache-Control: private, max-age=0, must-revalidate');
3506.         
3507.                 // Envia o arquivo binário ao navegador
3508.                 readfile($tempFile);
3509.         
3510.                 // Remove o arquivo temporário com segurança
3511.                 @unlink($tempFile);
3512.         
3513.                 // finaliza execução
3514.                 exit;
3515.         
3516.                 
3517.        
3518.         
3519.         }
3520.        
3521.         
3522.         return $this->render('index/index5.html.twig', [
3523.             'clienteAll' => $cliente->getClienteAll()->getId(),
3524.             'fluxos' => $fluxos,
3525.             'p'=>$p,
3526.             'erro'=>$erro,
3527.             'pagina' => $pagina,
3528.             'a' => $a,
3529.              
3531.         ]);
3532.     }
3533.     
3534.     
3535.     #[Route('/index/fluxo/diagrama/{id}', name: 'diagrama')]
3536.     public function diagrama( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer,$id): Response
3537.     {
3538.         $user_logado = $this->getUser();
3539.         $erro = '';
3540.         $pagina = 'fluxo';
3541.         $p ='';
3544.         $clienteId = $session->get('cliente_id');
3545.         
3546.         if($clienteId == null){
3547.             
3548.             return $this->redirectToRoute('home');
3549.         }
3550.         
3551.         $fluxo_diagrama = $doctrine->getRepository(Fluxo::class)->find($id);
3552.         $fluxo_caixas_diagrama = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_diagrama->getId());
3553.             
3554.  
3555.     
3556.         return $this->render('index/diagrama.html.twig', [
3557.     
3558.             'p'=>$p,
3559.             'erro'=>$erro,
3560.             'pagina' => $pagina,
3561.             "fluxo_diagrama" => $fluxo_diagrama,
3562.             "fluxo_caixas_diagrama" => $fluxo_caixas_diagrama
3563.              
3565.         ]);
3566.     }
3568.     #[Route('/index/recebimento/{id}', name: 'recebimento')]
3569.     public function recebimento( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer,$id): Response
3570.     {
3571.         $user_logado = $this->getUser();
3572.         $user_nome = $user_logado->getNome();
3573.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
3574.         $erro = '';
3575.         $pagina = 'home';
3576.         $p ='';
3577.         $ged = ""; 
3578.         $log = "";
3579.         $caixa_manual = "";
3580.         $caixa_auto = "";
3581.         $cx_ultimo = $doctrine->getRepository(Cx::class)->findUltimo();
3582.         $etapa = $doctrine->getRepository(Etapa::class)->findWithAllRelations($id);
3583.         $fluxo = $etapa->getFluxo();
3584.         $cliente_fluxo = $fluxo->getCliente()->getId();
3585.         $clienteId = $session->get('cliente_id');
3586.         $cliente = $doctrine->getRepository(Cliente::class)->findWithRelations($cliente_fluxo);
3587.         $clienteAll =  $cliente->getClienteAll();
3588.         $cliente_nome =  $cliente->getNome();
3589.         $clienteAll_id =  $clienteAll->getId();
3590.         $count = 0; // Contador de QR Codes
3591.         $id_cx_ultimo = 0;
3592.         $date_hoje = new \DateTimeImmutable('America/Sao_Paulo');
3593.         
3594.         $caixas_setor = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($cliente_fluxo);
3595.         
3596.         $query = $entityManager->createQuery("
3597.             SELECT c FROM App\Entity\Cx c
3598.             LEFT JOIN c.caixas cx
3599.             WHERE c.cliente = :clienteId
3600.             AND cx.id IS NULL
3601.         ");
3603.         $query->setParameter('clienteId', $clienteAll_id);
3604.         $cx_setor = $query->getResult();
3606.         foreach ($cx_ultimo as $key_id) {
3607.             
3608.             $id_cx_ultimo = $key_id->getNome();
3609.         }
3610.         
3612.         if(isset($_POST["btn_cliente"])){
3613.             
3614.             $session->set('cliente_id', $_POST["btn_cliente"]);
3615.             return $this->redirectToRoute('home');
3616.         }
3617.         
3618.         if($clienteId == null){
3619.             
3620.             return $this->redirectToRoute('home');
3621.         }
3622.         
3624.         if ($request->isMethod('POST')) {
3625.             
3626.           
3627.             
3628.             if(isset($_POST["tipo"])){
3629.                  $tp = $_POST["tipo"];
3630.                
3631.                if($tp =='caixa'){
3632.                    
3633.                     if($_POST["qtd_caixa"] != ""){
3634.     
3635.     
3636.                         if (isset($_POST["ged"]) || isset($_POST["log"])) {
3637.     
3638.                                 if (isset($_POST["ged"])) {
3639.                                     
3640.                                     $ged = "ok";
3641.     
3642.                                     if (isset($_POST["caixa_manual"]) || isset($_POST["caixa_auto"])) {
3643.     
3644.                                         if (isset($_POST["caixa_manual"])) {
3645.     
3646.                                             $caixa_manual = "ok";
3647.             
3648.                                         }
3649.                                         if (isset($_POST["caixa_auto"])) {
3650.     
3651.                                             $caixa_auto = "ok";
3652.             
3653.                                         }
3654.     
3655.                                     }else{
3656.                                         echo "<script>alert('ERROR , Selecione o modo de Identificação do ArquivosGED (Manual ou Automático)!');</script>";
3657.                                     }
3658.             
3659.                                 }
3660.     
3661.     
3662.     
3663.                                 if (isset($_POST["log"])) {
3664.     
3665.                                     $log = "ok";
3666.                                     
3667.     
3668.                                 }
3669.     
3670.                                 if ($ged == "ok" and $caixa_manual =="ok") {
3671.     
3672.                                     $caixa = $_POST["caixa"];
3673.                                     $qtd_caixas = 0;
3674.     
3675.     
3676.                                     $options = new Options();
3677.                                     $options->set('isHtml5ParserEnabled', true);
3678.                                     $options->set('isPhpEnabled', true);
3679.                                     $dompdf = new Dompdf($options);
3680.                         
3681.                                     $html = '
3682.                                     <html>
3683.                                         <head>
3684.                                             <style>
3685.                                                 @page {
3686.                                                     margin: 35px 18.9px 0px 18.9px;
3687.                                                     size: 210mm 297mm; /* Ajuste de tamanho do papel */
3688.                                                 }
3689.                         
3690.                                                 body {
3691.                                                     margin: 0;
3692.                                                     padding: 0;
3693.                                                 }
3694.                                                 
3695.                                                 .qr-item {
3696.                                                     border: 2px dotted #000;
3697.                                                     text-align: center;
3698.                                                     width: 32.27mm;
3699.                                                     height: 34.9mm; 
3700.                                                     display: inline-block;
3701.                                                 }
3702.                                     
3703.                                                 .qr-item img {
3704.                                                     width: 115px; 
3705.                                                     height: 112px;
3706.                                                 }
3707.                         
3708.                                                 .qr-title {
3709.                                                     font-size: 16px;
3710.                                                     font-weight: bold;
3711.                                                 }
3712.                         
3713.                                                 .leo {
3714.                                                     display: flex;
3715.                                                     flex-wrap: wrap;
3716.                                                 }
3717.                                             </style>
3718.                                         </head>
3719.                                         <body> 
3720.                                       
3721.                                     ';
3722.                         
3723.                         
3724.                                     
3725.                                     foreach ($caixa as $key) {
3726.     
3727.                                         if ($key != "" ) {
3728.                                             $qtd_caixas ++ ;
3729.                                             $caixas = new Caixa();
3730.                                            
3731.                                            
3732.                                             if ($ged == "ok" and $log =="ok") {
3733.                                                 
3734.                                                 $cx = new Cx();
3735.                                                 $id_cx_ultimo ++;
3736.                                                 $cx->setNome($id_cx_ultimo);
3737.                                                 $cx->setStatus(2);
3738.                                                 $cx->setTexto($key);
3739.                                                 $cx->setImage('ArquivosGED');
3740.                                                 $cx->setCliente($clienteAll);
3741.                                                 $entityManager->persist($cx);
3742.                                                 $entityManager->flush();
3743.     
3744.                                                 $id_cx=$cx->getId();
3745.                                                 $caixas->setCx($entityManager->getRepository(Cx::class)->find($id_cx));
3746.     
3747.                                                 // Gerar QR Code com imagem no centro
3748.                                                 $result = Builder::create()
3749.                                                 ->writer(new PngWriter())
3750.                                                 ->writerOptions([])
3751.                                                 ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$id_cx_ultimo)
3752.                                                 ->encoding(new Encoding('UTF-8'))
3753.                                                 ->size(500)
3754.                                                 ->margin(5)
3755.                                                 ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
3756.                                                 ->build();
3757.                                                 // Salvar QR Code como arquivo temporário
3758.                                                 $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
3759.                                                 $result->saveToFile($tempFile);
3760.                                                 
3761.                                                 // Adicionar QR Code ao HTML
3762.                                                 if ($count % 48 == 0) {
3763.                                                     $html .= '<div class="leo">';
3764.                                                 }
3765.                                 
3766.                                                 // Adicionar QR Code ao HTML
3767.                                                 $html .= '<div class="qr-item">';
3768.                                                 $html .= '<div class="qr-title">' . $id_cx_ultimo . '</div>';
3769.                                                 $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
3770.                                                 $html .= '</div>';
3771.                                                 
3772.                                                 
3773.                                                  $count++;
3774.     
3775.                                                // Fechar a div e inserir quebra de página a cada 63 QR Codes
3776.                                                if ($count % 48 == 0) {
3777.                                                    $html .= '</div><div style="page-break-after: always;"></div>';
3778.                                                }
3779.                                                 
3780.                                             }
3781.     
3782.                                             
3783.                                             $caixas->setNome($key);
3784.                                             $caixas->addCliente($cliente);
3785.                                             $caixas->setFluxo($fluxo);
3786.                                             $entityManager->persist($caixas);
3787.                                             $entityManager->flush();
3788.                                             $id_caixa = $caixas->getId();
3789.                                             
3790.                                                 
3791.                                         }
3792.                                     }
3793.                                         if ($ged == "ok" and $log =="ok") {
3794.                                             
3795.                                               // Fechar qualquer div aberta sem completar 63 itens
3796.                                              if ($count % 48 != 0) {
3797.                                                 $html .= '</div>';
3798.                                             }
3799.     
3800.                                             $html .= '</div></body></html>';
3801.                                 
3802.                                             // Carregar o HTML e gerar o PDF
3803.                                             $dompdf->loadHtml($html);
3804.                                             $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
3805.                                             $dompdf->render();
3806.                                             #file_put_contents('sample1.pdf', $dompdf->output());
3807.                                             $dompdf->stream('dompdf', array('Attachment' => 0));
3808.                                         }
3809.     
3810.                                             $registro = new Registro();
3811.                                             $registro->setOperacao('RECEBIMENTO DE '.$qtd_caixas. ' CAIXA(S)'); 
3812.                                             $registro->setUser($user_nome);
3813.                                             $registro->setCliente($cliente_nome);
3814.                                             $registro->setIp($ip_cliente);
3815.                                             $entityManager->persist($registro);
3816.                                             $entityManager->flush();
3817.     
3818.                                             $etapa->setRegistro($registro);
3819.                                             $etapa->setObs($_POST["obs_caixa"]);
3820.                                             $etapa->setUpdatedAt($date_hoje);
3821.                                             $entityManager->flush();
3822.                                             $erro = 'ok';
3823.                                             $p = "Recbimento com sucesso";
3824.                                     
3825.     
3826.                                 }
3827.     
3828.                                 if ($ged == "ok" and $caixa_auto =="ok") {
3829.     
3830.                                     
3831.                                     if (isset($_POST["auto_ged"])) {
3832.     
3833.                                         $qtd_nome_caixa = $_POST["qtd_caixa"];
3834.                                         $nome_caixa_parti = $_POST["auto_ged"];
3835.                                         
3836.     
3837.     
3838.     
3839.                                         $options = new Options();
3840.                                         $options->set('isHtml5ParserEnabled', true);
3841.                                         $options->set('isPhpEnabled', true);
3842.                                         $dompdf = new Dompdf($options);
3843.                             
3844.                                         $html = '
3845.                                         <html>
3846.                                             <head>
3847.                                                 <style>
3848.                                                     @page {
3849.                                                         margin: 35px 18.9px 0px 18.9px;
3850.                                                         size: 210mm 297mm; /* Ajuste de tamanho do papel */
3851.                                                     }
3852.                             
3853.                                                     body {
3854.                                                         margin: 0;
3855.                                                         padding: 0;
3856.                                                     }
3857.                                                     
3858.                                                    .qr-item {
3859.                                                     border: 2px dotted #000;
3860.                                                     text-align: center;
3861.                                                     width: 32.27mm;
3862.                                                     height: 34.9mm; 
3863.                                                     display: inline-block;
3864.                                                 }
3865.                                     
3866.                                                 .qr-item img {
3867.                                                     width: 115px; 
3868.                                                     height: 112px;
3869.                                                 }
3870.                                     
3871.                                                     .qr-title {
3872.                                                         font-size: 16px;
3873.                                                         font-weight: bold;
3874.                                                     }
3875.                             
3876.                                                     .leo {
3877.                                                         display: flex;
3878.                                                         flex-wrap: wrap;
3879.                                                     }
3880.                                                 </style>
3881.                                             </head>
3882.                                             <body> 
3883.                                               
3884.                                         ';
3885.                         
3886.                         
3887.     
3888.     
3889.                                         for ($i=0; $i < $qtd_nome_caixa; $i++) { 
3890.                                             
3891.                                             $caixas = new Caixa();
3892.     
3893.                                             if ($ged == "ok" and $log =="ok") {
3894.                                                 
3895.                                                 $cx = new Cx();
3896.                                                 $id_cx_ultimo ++;
3897.                                                 $cx->setNome($id_cx_ultimo);
3898.                                                 $cx->setStatus(2);
3899.                                                 $cx->setTexto('Caixa '.$nome_caixa_parti);
3900.                                                 $cx->setImage('ArquivosGED');
3901.                                                 $cx->setCliente($clienteAll);
3902.                                                 $entityManager->persist($cx);
3903.                                                 $entityManager->flush();
3904.     
3905.                                                 $id_cx=$cx->getId();
3906.                                                 $caixas->setCx($entityManager->getRepository(Cx::class)->find($id_cx));
3907.     
3908.                                                   // Gerar QR Code com imagem no centro
3909.                                                 $result = Builder::create()
3910.                                                   ->writer(new PngWriter())
3911.                                                   ->writerOptions([])
3912.                                                   ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$id_cx_ultimo)
3913.                                                   ->encoding(new Encoding('UTF-8'))
3914.                                                   ->size(500)
3915.                                                   ->margin(5)
3916.                                                   ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
3917.                                                   ->build();
3918.                                                   // Salvar QR Code como arquivo temporário
3919.                                                   $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
3920.                                                   $result->saveToFile($tempFile);
3921.                                                     
3922.                                                 // Adicionar QR Code ao HTML
3923.                                                     if ($count % 48 == 0) {
3924.                                                         $html .= '<div class="leo">';
3925.                                                     }    
3926.                                                     
3927.                                                   // Adicionar QR Code ao HTML
3928.                                                   $html .= '<div class="qr-item">';
3929.                                                   $html .= '<div class="qr-title">' . $id_cx_ultimo . '</div>';
3930.                                                   $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
3931.                                                   $html .= '</div>';
3932.                                                   
3933.                                                    $count++;
3934.                                         
3935.                                                    // Fechar a div e inserir quebra de página a cada 63 QR Codes
3936.                                                    if ($count % 48 == 0) {
3937.                                                        $html .= '</div><div style="page-break-after: always;"></div>';
3938.                                                    }
3939.                                                 
3940.                                             }
3941.     
3942.     
3943.                                             $caixas->setNome('Caixa '.$nome_caixa_parti);
3944.                                             $caixas->addCliente($cliente);
3945.                                             $caixas->setFluxo($fluxo);
3946.                                             $entityManager->persist($caixas);
3947.                                             $entityManager->flush();
3948.                                             $nome_caixa_parti++;
3949.                                             
3950.     
3951.                                         }
3952.     
3953.                                         if ($ged == "ok" and $log =="ok") {
3954.                                     
3955.                                              // Fechar qualquer div aberta sem completar 63 itens
3956.                                              if ($count % 48 != 0) {
3957.                                                 $html .= '</div>';
3958.                                             }
3959.                                             
3960.                                             $html .= '</div></body></html>';
3961.                                     
3962.                                             // Carregar o HTML e gerar o PDF
3963.                                             $dompdf->loadHtml($html);
3964.                                             $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
3965.                                             $dompdf->render();
3966.                                             #file_put_contents('sample1.pdf', $dompdf->output());
3967.                                             $dompdf->stream('dompdf', array('Attachment' => 0));
3968.                                         }    
3969.     
3970.                                         $registro = new Registro();
3971.                                         $registro->setOperacao('RECEBIMENTO DE '.$qtd_nome_caixa. ' CAIXA(S)'); 
3972.                                         $registro->setUser($user_nome);
3973.                                         $registro->setCliente($cliente_nome);
3974.                                         $registro->setIp($ip_cliente);
3975.                                         $entityManager->persist($registro);
3976.                                         $entityManager->flush();
3977.                                         
3978.                                         $etapa->setUpdatedAt($date_hoje);
3979.                                         $etapa->setRegistro($registro);
3980.                                         $entityManager->flush();
3981.     
3982.                                         $erro = 'ok';
3983.                                         $p = "Recbimento com sucesso";
3984.                                         
3985.                                     }
3986.     
3987.                                 }
3988.     
3989.     
3990.     
3991.                                 if ($ged != "ok" and $log =="ok") {
3992.                                     
3993.                                     $qtd_caixa_ = $_POST["qtd_caixa"];
3994.                                     $options = new Options();
3995.                                     $options->set('isHtml5ParserEnabled', true);
3996.                                     $options->set('isPhpEnabled', true);
3997.                                     $dompdf = new Dompdf($options);
3998.                             
3999.                                         $html = '
4000.                                         <html>
4001.                                             <head>
4002.                                                 <style>
4003.                                                     @page {
4004.                                                         margin: 35px 18.9px 0px 18.9px;
4005.                                                         size: 210mm 297mm; /* Ajuste de tamanho do papel */
4006.                                                     }
4007.                             
4008.                                                     body {
4009.                                                         margin: 0;
4010.                                                         padding: 0;
4011.                                                     }
4012.                                                     
4013.                                                     .qr-item {
4014.                                                         border: 2px dotted #000;
4015.                                                         text-align: center;
4016.                                                         width: 27.5mm;
4017.                                                         height: 30.5mm; 
4018.                                                         display: inline-block;
4019.                                                     }
4020.                             
4021.                                                     .qr-item img {
4022.                                                         width: 105px; 
4023.                                                         height: 100px;
4024.                                                     }
4025.                             
4026.                                                     .qr-title {
4027.                                                         font-size: 16px;
4028.                                                         font-weight: bold;
4029.                                                     }
4030.                             
4031.                                                     .leo {
4032.                                                         display: flex;
4033.                                                         flex-wrap: wrap;
4034.                                                     }
4035.                                                 </style>
4036.                                             </head>
4037.                                             <body> 
4038.                                                 <div class="leo">    
4039.                                         ';
4040.     
4041.     
4042.     
4043.                                     for ($i=0; $i < $qtd_caixa_; $i++) { 
4044.                                             
4045.                                                 $id_cx_ultimo ++;
4046.                                                 // Gerar QR Code com imagem no centro
4047.                                             $result = Builder::create()
4048.                                                 ->writer(new PngWriter())
4049.                                                 ->writerOptions([])
4050.                                                 ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$id_cx_ultimo)
4051.                                                 ->encoding(new Encoding('UTF-8'))
4052.                                                 ->size(300)
4053.                                                 ->margin(10)
4054.                                                 ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
4055.                                                 ->build();
4056.                                                 // Salvar QR Code como arquivo temporário
4057.                                                 $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
4058.                                                 $result->saveToFile($tempFile);
4059.                                 
4060.                                                 // Adicionar QR Code ao HTML
4061.                                                 $html .= '<div class="qr-item">';
4062.                                                 $html .= '<div class="qr-title">' . $id_cx_ultimo . '</div>';
4063.                                                 $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
4064.                                                 $html .= '</div>';
4065.                                     }
4066.                                     
4067.                                     $html .= '</div></body></html>';
4068.                             
4069.                                     // Carregar o HTML e gerar o PDF
4070.                                     $dompdf->loadHtml($html);
4071.                                     $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
4072.                                     $dompdf->render();
4073.                                     file_put_contents('sample1.pdf', $dompdf->output());
4074.                                     $dompdf->stream('dompdf', array('Attachment' => 1));
4075.     
4076.     
4077.                                     $registro = new Registro();
4078.                                     $registro->setOperacao('RECEBIMENTO DE '.$qtd_caixa_. ' CAIXA(S)'); 
4079.                                     $registro->setUser($user_nome);
4080.                                     $registro->setCliente($cliente_nome);
4081.                                     $registro->setIp($ip_cliente);
4082.                                     $entityManager->persist($registro);
4083.                                     $entityManager->flush();
4084.                                     
4085.                                     $etapa->setUpdatedAt($date_hoje);
4086.                                     $etapa->setRegistro($registro);
4087.                                     $entityManager->flush();
4088.     
4089.                                     $erro = 'ok';
4090.                                     $p = "Recbimento com sucesso";
4091.     
4092.     
4093.                                 }
4094.     
4095.     
4096.     
4097.     
4098.                             } else {
4099.     
4100.                             echo "<script>alert('ERROR , Selecione a Identificação!');</script>";
4101.                         }
4102.                          
4103.                     }else {
4104.                         echo "<script>alert('ERROR , Selecione a Quantidade!');</script>";
4105.                     }
4106.                }
4107.                
4108.                 if($tp =='doc'){
4111.                     if(isset($_POST["check_cx_e"])){
4112.                         $yz = "yes";
4113.                         $checkBoxes = $request->request->all('inputs_cx_e');
4114.                         $xy = 0;
4115.                         $qtd_caixas=0;
4116.                         
4117.       
4118.                         foreach ($checkBoxes as $id => $nome) {
4119.                             $cx_ = $doctrine->getRepository(Cx::class)->find($id);
4120.                             $_nome =  $cx_->getNome();
4121.                            
4122.                             if ($nome =="") {
4123.                                
4124.                                 echo "<script>alert('ERROR, Digite no campo gerado acima da tabela qual será repositorio do  ID: $_nome!');</script>";
4125.                             }
4127.                             if ($nome != "" ) {
4128.                                 $id_cx_ultimo = $_nome ;
4129.                                 $qtd_caixas++;
4130.                                 $xy = 1;
4131.                                 $caixas = new Caixa();
4132.                                 $caixas->setNome($nome);
4133.                                 $caixas->addCliente($cliente);
4134.                                 $caixas->setFluxo($fluxo);
4135.                                 $caixas->setCx($cx_);
4136.                                 $entityManager->persist($caixas);
4137.                                 $entityManager->flush();
4139.                                 $registro = new Registro();
4140.                                 $registro->setOperacao('RECEBIMENTO DA ID EXISTENTE '.$_nome); 
4141.                                 $registro->setUser($user_nome);
4142.                                 $registro->setCliente($cliente_nome);
4143.                                 $registro->setIp($ip_cliente);
4144.                                 $entityManager->persist($registro);
4145.                                 $entityManager->flush();
4147.                                 
4148.                                 
4149.                                 
4150.                             }
4152.                             
4153.                         }
4155.                        
4157.                         if($xy==1){
4159.                             $etapa->setRegistro($registro);
4160.                             $etapa->setObs($_POST["obs_caixa"]);
4161.                             $etapa->setUpdatedAt($date_hoje);
4162.                             $entityManager->flush();
4163.                             
4165.                             $registro = new Registro();
4166.                             $registro->setOperacao('RECEBIMENTO DE  '.$qtd_caixas. ' CAIXA(S) '); 
4167.                             $registro->setUser($user_nome);
4168.                             $registro->setCliente($cliente_nome);
4169.                             $registro->setIp($ip_cliente);
4170.                             $entityManager->persist($registro);
4171.                             $entityManager->flush();
4173.                             $erro = 'ok';
4174.                             $p = "Recbimento com sucesso";
4175.                         }
4178.                       
4179.                     }else{
4180.                         $zy = "not";
4181.                     }
4183.                     if(isset($_POST["check_caixa_e"])){
4184.                         $zy = "yes";
4185.                         $options = new Options();
4186.                         $options->set('isHtml5ParserEnabled', true);
4187.                         $options->set('debugKeepTemp', true);
4188.                         $options->set('isPhpEnabled', true);
4189.                         $dompdf = new Dompdf($options);
4190.                         
4191.                         $html = '
4192.                                     <html>
4193.                                         <head>
4194.                                             <style>
4195.                                                 @page {
4196.                                                     margin: 35px 18.9px 0px 18.9px;
4197.                                                     size: 210mm 297mm; /* Ajuste de tamanho do papel */
4198.                                                 }
4199.                         
4200.                                                 body {
4201.                                                     margin: 0;
4202.                                                     padding: 0;
4203.                                                 }
4204.                                                 
4205.                                                 .qr-item {
4206.                                                     border: 2px dotted #000;
4207.                                                     text-align: center;
4208.                                                     width: 32.27mm;
4209.                                                     height: 34.9mm; 
4210.                                                     display: inline-block;
4211.                                                 }
4212.                                     
4213.                                                 .qr-item img {
4214.                                                     width: 115px; 
4215.                                                     height: 112px;
4216.                                                 }
4217.                         
4218.                                                 .qr-title {
4219.                                                     font-size: 16px;
4220.                                                     font-weight: bold;
4221.                                                 }
4222.                         
4223.                                                 .leo {
4224.                                                     display: flex;
4225.                                                     flex-wrap: wrap;
4226.                                                 }
4227.                                             </style>
4228.                                         </head>
4229.                                         <body> 
4230.                                     
4231.                                     ';
4232.                         
4233.                         $ckeck = $_POST["caixa_e"];
4234.                         $xy = 0;
4235.                         $qtd_caixas=0;
4236.                 
4237.                         foreach ($ckeck as $key) {
4238.                             $nome_k = NULL;
4239.                             $caixa_k = $doctrine->getRepository(Caixa::class)->find($key);
4240.                             if($caixa_k != NULL ){
4241.                                 $nome_k = $caixa_k->getNome();
4242.                             }
4243.                             
4244.                             if ($clienteAll_id != 18) {
4245.                             
4246.                                 $cx = new Cx();
4247.                                 $id_cx_ultimo ++;
4248.                                 $cx->setNome($id_cx_ultimo);
4249.                                 $cx->setStatus(2);
4250.                                 $cx->setTexto($nome_k);
4251.                                 $cx->setImage('ArquivosGED');
4252.                                 $cx->setCliente($clienteAll);
4253.                                 $entityManager->persist($cx);
4254.                                 $entityManager->flush();
4255.                                 $caixa_k->setCx($cx);
4256.                                 
4257.                             }
4258.                             
4259.                             $caixa_k->setFluxo($fluxo);
4260.                             $entityManager->flush();
4262.                             $registro = new Registro();
4263.                             $registro->setOperacao('RECEBIMENTO DA CAIXA EXISTENTE '.$nome_k); 
4264.                             $registro->setUser($user_nome);
4265.                             $registro->setCliente($cliente_nome);
4266.                             $registro->setIp($ip_cliente);
4267.                             $entityManager->persist($registro);
4268.                             $entityManager->flush();
4271.                             // Gerar QR Code com imagem no centro
4272.                             $result = Builder::create()
4273.                              ->writer(new PngWriter())
4274.                              ->writerOptions([])
4275.                              ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$id_cx_ultimo)
4276.                              ->encoding(new Encoding('UTF-8'))
4277.                              ->size(500)
4278.                              ->margin(5)
4279.                              ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
4280.                              ->build();
4281.                              // Salvar QR Code como arquivo temporário
4282.                              $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
4283.                              $result->saveToFile($tempFile);
4284.                              
4285.                              // Adicionar QR Code ao HTML
4286.                              if ($count % 48 == 0) {
4287.                                  $html .= '<div class="leo">';
4288.                              }
4289.              
4290.                              // Adicionar QR Code ao HTML
4291.                              $html .= '<div class="qr-item">';
4292.                              $html .= '<div class="qr-title">' . $id_cx_ultimo . '</div>';
4293.                              $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
4294.                              $html .= '</div>';
4295.                              
4296.                              
4297.                              $count++;
4299.                             // Fechar a div e inserir quebra de página a cada 63 QR Codes
4300.                             if ($count % 48 == 0) {
4301.                                 $html .= '</div><div style="page-break-after: always;"></div>';
4302.                             }
4304.                              
4305.                             
4306.                         }
4308.                         // Fechar qualquer div aberta sem completar 63 itens
4309.                         if ($count % 48 != 0) {
4310.                             $html .= '</div>';
4311.                         }
4312.                          
4313.                         $html .= '</div></body></html>';
4314.                         
4315.                         if ($clienteAll_id != 18) {  
4316.                             // Carregar o HTML e gerar o PDF
4317.                             $dompdf->loadHtml($html);
4318.                             $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
4319.                             $dompdf->render();
4320.                             #file_put_contents('sample1.pdf', $dompdf->output());
4321.                             $dompdf->stream('dompdf', array('Attachment' => 0));
4322.                         }
4324.                         if($xy==1){
4326.                             $etapa->setRegistro($registro);
4327.                             $etapa->setUpdatedAt($date_hoje);
4328.                             $etapa->setObs($_POST["obs_caixa"]);
4329.                             $entityManager->flush();
4330.                             
4332.                             $registro = new Registro();
4333.                             $registro->setOperacao('RECEBIMENTO DE  '.$qtd_caixas. ' CAIXA(S) '); 
4334.                             $registro->setUser($user_nome);
4335.                             $registro->setCliente($cliente_nome);
4336.                             $registro->setIp($ip_cliente);
4337.                             $entityManager->persist($registro);
4338.                             $entityManager->flush();
4340.                             $erro = 'ok';
4341.                             $p = "Recbimento com sucesso";
4342.                         }
4345.                       
4346.                     }else{
4347.                         $yz = "not";
4348.                     }
4350.                     if ($yz == "not" and $zy="not") {
4352.                         echo "<script>alert('ERROR , Preencha corretamente o formulario, está sem valor , selecione todas as opções necessaria!');</script>";
4353.                     }
4354.                    
4355.                 }
4356.                
4357.                
4358.                
4359.                
4360.             }else {
4361.                 echo "<script>alert('ERROR , Selecione o tipo!');</script>";
4362.             }
4363.             
4364.         }
4366.         return $this->render('index/recebimento.html.twig', [
4367.     
4368.             
4369.             'p'=>$p,
4370.             'erro'=>$erro,
4371.             'pagina' => $pagina,
4372.             'etapa'=>$etapa,
4373.             'caixas_setor' => $caixas_setor,
4374.             'cx_setor' => $cx_setor
4375.             
4376.             
4378.         ]);
4379.     }
4381.     #[Route('/index/higienizacao/{id}', name: 'higienizacao')]
4382.     public function higienizacao( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer,$id): Response
4383.     {
4384.         $user_logado = $this->getUser();
4385.         $user_nome = $user_logado->getNome();
4386.         $date_hoje = new \DateTimeImmutable('America/Sao_Paulo');
4387.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
4388.         $erro = '';
4389.         $pagina = 'home';
4390.         $p ='';
4391.         $a = 0 ;
4392.         $clienteAll = null;
4393.         $cx = null;
4394.         $caixa = null; 
4395.         $etapa = $doctrine->getRepository(Etapa::class)->findWithAllRelations($id);
4396.         $fluxo = $etapa->getFluxo();
4397.         $etapa_caixas = $etapa->getCaixa()->toArray();
4398.         $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo->getId());
4399.        
4400.         $e = 0;
4401.         $f = 0;
4402.         $clienteId = $session->get('cliente_id');
4403.         if($clienteId == null){
4404.             
4405.             return $this->redirectToRoute('home');
4406.         }
4407.         
4408.         
4409.         foreach ($etapa_caixas as $key) {
4410.             $e++;
4411.         }
4412.         foreach ($fluxo_caixas as $key) {
4413.             $f++;
4414.         }
4416.         if(isset($_POST["a"])){
4417.             $a = 2;
4418.         }
4419.         
4420.         $qrCodeData = $request->request->get('qrcode');
4421.         if(isset($_POST["id_caixas"])){
4422.             $a = 1 ;
4423.             $caixa = $doctrine->getRepository(Caixa::class)->findBy(['id' => $_POST["id_caixas"]]);
4424.             
4425.             foreach ($caixa as $key) { $caixa_cx_id = $key->getClientes()->toArray();}
4426.             
4427.             $cx =  $caixa_cx_id ;
4428.             
4429.             foreach ($cx as $key) {$cliente_cx_id = $key->getClienteAll()->getId();}
4430.             
4431.             $clienteAll = $doctrine->getRepository(ClienteAll::class)->findClienteWithRelations($cliente_cx_id);
4432.            
4433.             
4434.         }
4435.         if($qrCodeData != null){
4437.             
4438.             $url = $qrCodeData;
4439.             preg_match('/(\d+)\/(\d+)$/', $url, $matches);
4441.             if (!empty($matches)) {
4442.                 $numero1 = $matches[1]; 
4443.                 $numero2 = $matches[2];
4444.                 $clienteAll = $doctrine->getRepository(ClienteAll::class)->find($numero1);
4445.                 $cx = $doctrine->getRepository(Cx::class)->findBy(['nome' => $numero2]);
4446.                 
4447.                 foreach ($cx as $key) {
4449.                     $cx_id = $key->getId();
4450.                 }
4451.                     
4452.                 
4453.                 $caixa = $doctrine->getRepository(Caixa::class)->findBy(['cx' => $cx_id ]);
4454.                 $a = 1 ;
4455.                 
4456.             } else {
4457.                 
4458.               
4459.             }
4460.             
4461.         }
4463.         if(isset($_POST["cx"])){
4465.             $clienteAll = $doctrine->getRepository(ClienteAll::class)->findClienteWithRelations($_POST["clienteAll"]);
4466.             $clienteAll_nome = $clienteAll->getNome();
4467.             
4468.             $cx = $doctrine->getRepository(Cx::class)->find($_POST["cx"]);
4469.             $caixa = $doctrine->getRepository(Caixa::class)->find($_POST["caixas"]);
4470.             $cliente = $doctrine->getRepository(Cliente::class)->find($_POST["cliente"]);
4471.             
4472.             if ($cx != null) {
4473.                 $cx_nome = 'ID: '.$cx->getNome();
4474.             }else{
4475.                 $cx_nome = 'GED: '.$caixa->getNome();
4476.             }
4477.         
4478.             $cliente_nome = $clienteAll_nome;
4480.             if ($cliente_nome == NULL){
4482.                 $cliente_nome = $cliente->getNome();
4484.             }
4485.             
4486.             
4488.             $registro = new Registro();
4489.             $registro->setOperacao('HIGIENIZAÇÃO '.$cx_nome); 
4490.             $registro->setUser($user_nome);
4491.             $registro->setCliente($cliente_nome);
4492.             $registro->setIp($ip_cliente);
4493.             $entityManager->persist($registro);
4494.             $entityManager->flush();
4495.             
4496.             if($cx != null){
4497.                 
4498.                 $etapa->addCx($cx);
4499.             }
4500.             
4501.             $etapa->addCaixa($caixa);
4502.             $caixa->setHigienizaAt($date_hoje);
4503.             $e++;
4505.             if ($e == $f) {
4507.                 
4508.                 $registro = new Registro();
4509.                 $registro->setOperacao('HIGIENIZAÇÃO DE '.$f. ' CAIXA(S)'); 
4510.                 $registro->setUser('CONCLUIDO PELA EQUIPE');
4511.                 $registro->setCliente($cliente_nome);
4512.                 $registro->setIp($ip_cliente);
4513.                 $entityManager->persist($registro);
4514.                 $entityManager->flush();
4516.                 $etapa->setRegistro($registro);
4517.                 $etapa->setUpdatedAt($date_hoje);
4518.                 $entityManager->flush();
4519.             }
4520.             
4521.             $entityManager->flush();
4522.             $erro = 'ok';
4523.             $p = "Etapa concluída com sucesso";
4524.         }
4525.         
4526.         return $this->render('index/higienizacao.html.twig', [
4527.     
4528.             'id'=>$id,
4529.             'p'=>$p,
4530.             'erro'=>$erro,
4531.             'pagina' => $pagina,
4532.             'a'=>$a,
4533.             'clienteAll' => $clienteAll,
4534.             'cx' =>$cx ,
4535.             'caixa' => $caixa,
4536.             'fluxo_caixas'=>$fluxo_caixas
4537.             
4538.             
4539.             
4541.         ]);
4542.     }
4544.    
4545.     #[Route('/index/digitalizacao/{id}', name: 'digitalizacao')]
4546.     public function digitalizacao(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session,MessageBusInterface $bus,$id): Response
4547.     {
4548.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
4549.         $etapa = $doctrine->getRepository(Etapa::class)->findWithAllRelations($id);
4550.         $fluxo = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($etapa->getFluxo()->getId());
4551.         $cliente_nome = $fluxo->getCliente()->getNome();
4552.         $cliente_id = $fluxo->getCliente();
4553.         $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo->getId());
4554.         $form = $this->createForm(UploadType::class);
4555.         $user_logado = $this->getUser();
4556.         $user_logado_id = $user_logado->getId();
4557.         $userId = $user_logado_id;
4558.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
4559.         $form->handleRequest($request);
4560.         $dotenv = new Dotenv();
4561.         $dotenv->load(__DIR__.'/.env');
4562.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
4563.         $hoje_formt=$hoje->format('Y-m-d') ;
4564.         $dia_prod = 'de hoje';
4565.         $erro = '';
4566.         $ii=0;
4567.         $pagina = 'export';
4568.         $p = '';
4569.         $uuid = Uuid::v4();
4570.         $user = $this->getUser();
4571.         $user_nome= $user->getEmail();
4572.         $user_nome_name= $user->getNome();
4573.         $pasta_user=$user_nome.'/';
4574.         $cliente_alls = "";
4575.         $arr = [];
4576.         $arrr=0;
4577.         $f = 0;
4578.         $dt = '';
4579.         $clientS3 = new  S3Client([
4580.             'region'  => 'sa-east-1',
4581.             'version' => 'latest',
4582.             'credentials' => [ 
4583.                 'key'    => $_ENV['AWS_KEY'],
4584.                 'secret' => $_ENV['AWS_SECRET'],
4585.             ],
4586.         
4587.         ]);
4589.         foreach ($fluxo_caixas as $key) {
4590.             $f++;
4591.         }
4593.         if(isset($_POST["btn_cliente"])){
4594.             
4595.             $session->set('cliente_id', $_POST["btn_cliente"]);
4596.             return $this->redirectToRoute('home');
4597.         }
4598.        
4599.             
4600.             
4601.        
4602.         $clienteId = $session->get('cliente_id');
4603.         
4604.         if ($clienteId == null ) {
4605.             
4606.             $caixas =  "";
4607.             $cliente_session = "";
4608.             return $this->redirectToRoute('home');
4609.        
4610.         } else {
4611.             
4612.             $caixas = $fluxo_caixas;
4613.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);       
4614.         }
4615.         
4616.         
4617.         if(isset($_POST["botao_export"]))
4618.         {
4619.             
4620.             $caixaId = $_POST["caixas"];
4621.             
4622.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($_POST["caixas"]);
4623.             $clientes= $cliente_id->getId();
4624.             $cliente_alls = $cliente_id->getClienteAll()->getId();
4625.             $clienteId=$clientes;
4627.             $clientes_status= $cliente_id->getExtraFields();
4628.             if(!$clientes_status){
4629.                 $clientes_status="ged";
4630.             }
4631.             $conteiner = $_POST["conteiner"];
4632.             $cont_file = 0 ;
4633.             $umlautString =$cliente_nome;
4634.             $slugger = new AsciiSlugger();
4635.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
4636.             $caminho = strtolower ($teste.'/');
4637.                     
4638.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
4639.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
4640.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
4641.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
4642.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
4643.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
4644.             if($clientes ==  15){$caminho='cbsi-dossies/';}
4645.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
4646.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
4647.             if($clientes ==  40){$caminho='fasf-atas-e-diario/';}
4648.             if($clientes ==  127){$caminho='pmecj-s-a.A) - ALMOXARIFADO E PATRIMÔNIO/';}
4649.            
4650.             $filesTmp  = $_FILES['file']['tmp_name'];
4651.             $filesName = $_FILES['file']['name'];
4652.             
4653.             foreach ($filesTmp as $index => $file) {
4654.             
4655.                 $uuid = Uuid::v4();
4656.                 $cont_file++;
4657.                 // nome original do arquivo
4658.                 $originalName = pathinfo($filesName[$index], PATHINFO_FILENAME);
4659.                 // sanitiza o nome (remove acentos, espaços estranhos etc.)
4660.                 $slugger = new AsciiSlugger();
4661.                 $safeName = strtolower($slugger->slug($originalName)->toString());
4662.             
4663.                 // 🔹 Se cliente for local, usa nome original
4664.                 if ($clientes_status === 'local') {
4665.             
4666.             
4667.                     $filename = $safeName . '.pdf';
4668.             
4669.                 } else {
4670.                     // padrão: UUID
4671.                     $filename = $uuid . '.pdf';
4672.                 }
4673.             
4674.                 $tempDir = __DIR__ . '/../../var/uploads/messenger';
4675.                 if (!is_dir($tempDir)) {
4676.                     mkdir($tempDir, 0777, true);
4677.                 }
4678.             
4679.                 $tempFilePath = $tempDir . '/' . $filename;
4680.             
4681.                 move_uploaded_file($file, $tempFilePath);
4682.                 chmod($tempFilePath, 0644);
4683.                 if (!file_exists($tempFilePath) || filesize($tempFilePath) === 0) {
4684.                     throw new \RuntimeException(
4685.                         'Falha ao gravar PDF temporário: ' . $tempFilePath
4686.                     );
4687.                 }
4688.                 
4689.                 // evita race condition de filesystem
4690.                 clearstatcache(true, $tempFilePath);
4691.             
4692.                 $bus->dispatch(new UploadMultipartMessage(
4693.                     $tempFilePath,
4694.                     $filename,
4695.                     $caminho,
4696.                     '',
4697.                     $caixaId,
4698.                     $clienteId,
4699.                     $userId,
4700.                     0,
4701.                     $conteiner,
4702.                     $clientes,
4703.                     $clientes_status,
4704.                     $safeName,
4705.                     $originalName,
4706.                     $cliente_alls 
4707.                 ));
4708.             }
4711.            
4712.             $log = new Registro();
4713.             $log->setOperacao('EXPORTOU '.$cont_file.' DOCUMENTO(S)'); 
4714.             $log->setUser($user_nome_name);
4715.             $log->setCliente($cliente_nome);
4716.             $entityManager->persist($log);
4717.             $entityManager->flush();
4718.             
4719.             return $this->redirectToRoute('digitalizacao', ['id' => $id]);
4720.             
4721.         
4722.         }
4724.         if(isset($_POST["caixa_total"])){
4726.             $caixa_total = $_POST["caixa_total"];
4727.             $documento_total =$_POST["documento_total"];
4728.             $qtd_total =$_POST["qtd_total"];
4731.                 $registro = new Registro();
4732.                 $registro->setOperacao('DIGITALIZAÇÃO:  '.$caixa_total. ' CAIXA(S) / '.$documento_total.' DOCUMENTO(S) / '.$qtd_total.' IMAGEN(S)'); 
4733.                 $registro->setUser('CONCLUIDO PELA EQUIPE');
4734.                 $registro->setCliente($cliente_nome);
4735.                 $registro->setIp($ip_cliente);
4736.                 $entityManager->persist($registro);
4737.                 $entityManager->flush();
4739.                 $etapa->setRegistro($registro);
4740.                 $etapa->setUpdatedAt($hoje);
4741.                 $entityManager->flush();
4742.                 $erro = 'ok';
4743.                 $p = "Etapa concluída com sucesso";
4744.         }
4746.        
4747.         return $this->render('index/digitalizacao.html.twig', [
4748.             'id'=>$id,
4749.             'p'=>$p,
4750.             'erro'=>$erro,
4751.             'pagina' => $pagina,
4752.             'caixas' => $caixas,
4753.             'user_logado' => $user_logado,
4754.             'cliente' => $cliente,
4755.             'cliente_session' => $cliente_session,
4756.             'form' => $form->createView(),
4757.             'dia_prod' => $dia_prod,
4758.             'fluxo' => $fluxo
4759.         ]);
4760.     }
4762.     #[Route('/index/indexacao/{id}', name: 'indexacao')]
4763.     public function indexacao(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager , SessionInterface $session,$id): Response
4764.     {   
4765.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
4766.         $etapa = $doctrine->getRepository(Etapa::class)->findWithAllRelations($id);
4767.         $fluxo = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($etapa->getFluxo()->getId());
4768.         $cliente_nome = $fluxo->getCliente()->getNome();
4769.         $cliente_etapa = $fluxo->getCliente();
4770.         $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo->getId());
4771.         $caixaIds = array_map(fn($caixa) => $caixa->getId(), $fluxo_caixas);
4772.         $documentoRepository = $entityManager->getRepository(Documento::class);
4773.         $query = $documentoRepository->createQueryBuilder('d')
4774.             ->where('d.caixa IN (:caixaIds)')
4775.             ->setParameter('caixaIds', $caixaIds)
4776.             #->orderBy('d.qtd', 'ASC') // Ordenando pelo ID da caixa em ordem crescente
4777.             ->getQuery();
4779.         // Executa a query
4780.         $documentos = $query->getResult();
4781.         $caixas = $fluxo_caixas;
4782.         $dotenv = new Dotenv();
4783.         $dotenv->load(__DIR__.'/.env');
4784.         $user_logado = $this->getUser();
4785.         $form = $this->createForm(UploadType::class);
4786.         $form->handleRequest($request);
4787.         $user_logado_tipoAcesso = $user_logado->getTipoAcesso();
4788.         $user_logado_nome = $user_logado->getNome();
4789.         $user_logado_id = $user_logado->getId();
4790.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
4791.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
4792.         $hoje_formt=$hoje->format('Y-m-d');
4793.         $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $hoje_formt);
4794.         $dia_prod = 'de hoje';
4795.         $permissao = [];
4796.         $list_indexador = [];
4797.         $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $cliente_etapa]);
4798.         $class =  $doctrine->getRepository(Classificacao::class)->findBy(['cliente' => $cliente_etapa]);
4799.         $cliente_ids =$cliente_etapa ;
4800.         
4801.        
4802.             
4803.         $cliente_nome= $cliente_ids->getNome();
4804.         $clientes= $cliente_ids->getId();
4805.         $umlautString =$cliente_nome;
4806.         $slugger = new AsciiSlugger();
4807.         $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
4808.         $caminho = strtolower ($teste.'/');
4809.                         
4810.         if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
4811.         if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
4812.         if($clientes == 35){$caminho='pmecj-sp-saude/';}
4813.         if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
4814.         if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
4815.         if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
4816.         if($clientes ==  15){$caminho='cbsi-dossies/';}
4817.         if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
4818.         if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
4819.         if($clientes ==  127){$caminho='pmecj-s-a.A) - ALMOXARIFADO E PATRIMÔNIO/';}
4820.       
4822.           
4823.         if(isset($_POST["btn_cliente"])){
4824.             
4825.             $session->set('cliente_id', $_POST["btn_cliente"]);
4826.             return $this->redirectToRoute('home');
4827.         }
4830.         $clienteId = $session->get('cliente_id');
4831.         
4832.         
4833.         if ($clienteId == null ) {
4834.             
4835.             $caixas =  "";
4836.             $cliente_session = "";
4837.             return $this->redirectToRoute('home');
4838.        
4839.         }
4840.            
4841.         $erro = '';
4842.         $ii=0;
4843.         $pagina = 'index';
4844.         $p = '';
4845.         $link = '';
4846.         $mx = 0;
4847.         $xy = 0 ; 
4848.         $yz = 0 ; 
4849.         $ay = 0 ;
4850.         $ky = 0 ;
4851.         $pdf ='';
4852.         $pagina_h4 ='Documento(s) para indexar';
4853.         $nome_menu_ = '';
4854.         $index_tipo='';
4855.         $uuid = Uuid::v4();
4856.         $user = $this->getUser();
4857.         $user_nome= $user->getEmail();
4858.         $user_nome_name= $user->getNome();
4859.         $pasta_user=$user_nome.'/';
4860.         $arr = [];
4861.         $arrr=0;
4862.         $index_find = null;
4863.         $dt = '';
4864.         $clientS3 = new  S3Client([
4865.                     'region'  => 'sa-east-1',
4866.                     'version' => 'latest',
4867.                     'credentials' => [ 
4868.                         'key'    => $_ENV['AWS_KEY'],
4869.                         'secret' => $_ENV['AWS_SECRET'],
4870.                     ],
4871.                 ]);
4872.         
4873.      
4874.             
4875.        
4876.         if(isset($_POST["botao_index"])){
4877.             
4878.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
4879.             $link = $pdf->getImage();
4880.             $xy = 1 ;
4881.             
4882.         }
4883.         if(isset($_POST["botao_doc"])){
4884.             
4885.             
4886.             $yz = 0 ;
4887.             $xy = 1 ;
4888.             $ay = 1 ;
4889.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
4890.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
4891.            
4892.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
4893.             $index_tipo_tipo =  $index_tipo->getNome();
4894.             $link = $pdf->getImage();
4895.             $fase=$_POST["fase"];
4896.             $data = $_POST["data"];
4897.             $cx = $_POST["caixas"];
4898.             $classifica = $_POST["classifica"];
4899.             $desc = $_POST["desc"];
4900.             $assunto = $_POST["assunto"];
4901.             $chave = $_POST["chave"];
4902.             $nome = $_POST["nome"];
4903.             $conteiner = $_POST["conteiner"];
4905.             
4906.             
4907.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($cx);
4908.             
4909.             
4910.             
4911.             
4913.             // Exibe os números encontrados
4914.             
4915.             if ($clientes != 7) {
4916.                 preg_match_all('/\d+/', $fase, $matches);
4917.                 $numeros = array_map('intval', $matches[0]);
4918.                 if ($data != "") {
4919.                     if ($numeros != [] ) {
4920.                         if ($fase != "") {
4921.         
4922.                             // Número inteiro que você deseja somar ao ano
4923.                             $numeroParaSomar = $numeros[0];
4924.         
4925.                             // Extrair o ano da data
4926.                             list($ano, $mes, $dia) = explode('-', $data);
4927.         
4928.                             // Converter o ano para um número inteiro
4929.                             $ano = intval($ano);
4930.         
4931.                             // Somar o número ao ano
4932.                             $data_vecimento =  $ano + $numeroParaSomar.'-'.$mes.'-'. $dia;
4933.         
4934.                             $pdf->setVencimentoDocumento(new \DateTimeImmutable($data_vecimento));
4935.         
4936.                         }
4937.                 }
4938.                 $pdf->setDataDocumento(new \DateTimeImmutable($data));
4939.                 }
4940.             }    
4941.             
4942.             if ($clientes == 7) {
4943.                   $pdf->setVencimentoDocumento(new \DateTimeImmutable($fase));
4944.                   $pdf->setDataDocumento(new \DateTimeImmutable($data));
4945.              }
4946.             
4947.             
4948.             $pdf->setAssunto($assunto);
4950.             if ($classifica != "") {
4952.                 $classifica_id = $doctrine->getRepository(Classificacao::class)->find($classifica);
4953.                 $pdf->setClassificacao($classifica_id);
4954.             }
4956.             $pdf->setCaixa($caixa_id);
4957.             $pdf->setExtraFields($desc);
4958.             $pdf->setNome($nome);
4959.             $pdf->setKeywords($chave);
4960.             $pdf->setUserIndex($user_nome_name);
4961.             $pdf->setConteiner($conteiner);
4962.             $pdf->setIndexAt(new \DateTimeImmutable('America/Sao_Paulo'));
4963.             $pdf->setTipo($index_tipo);
4964.             $entityManager->flush();
4965.             $id_pd = $pdf->getId();    
4966.             $log = new Registro();
4967.             $log->setOperacao('Indexou o Documento com id '.$id_pd); 
4968.             $log->setUser($user_nome_name);
4969.             $log->setCliente($cliente_nome);
4970.             $entityManager->persist($log);
4971.             $entityManager->flush();
4972.             $erro = 'ok';
4973.             $p =  $index_tipo_tipo.' indexado com sucesso';
4974.             
4977.            
4978.             
4979.            
4980.         }   
4981.         if(isset($_POST["botao_index_edit"])){
4982.             
4983.             $yz = 0 ;
4984.             $xy = 1 ;
4985.             $ay = 1 ;
4986.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
4987.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
4988.             $link = $pdf->getImage();
4989.         }
4990.         if(isset($_POST["botao_volta"])){
4992.             $xy = 0 ;
4993.             $yz = 0 ;
4994.         }
4995.         if(isset($_POST["index_button"])){
4996.             
4997.             
4998.             $yz = 0 ;
4999.             $xy = 1 ;
5000.             $ay = 1 ;
5001.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
5002.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["index_button"]);
5003.             $link = $pdf->getImage();
5004.         }
5005.         if(isset($_POST["botao_cancel"])){
5006.             $yz = 0 ;
5007.             $xy = 1 ;
5008.             $ay = 0 ;
5009.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
5010.             $link = $pdf->getImage();
5011.             
5012.         }
5013.         if(isset($_POST["delet"])){
5014.            
5015.             $ky = 1 ;
5016.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["delet"]);
5017.             $documentos = $doctrine->getRepository(Documento::class)->findBy(['id' => $_POST["delet"]]);
5018.             
5019.             if($pdf->getTipo()!= null){
5020.                 $index_find =  $doctrine->getRepository(Tipo::class)->find($pdf->getTipo());
5021.                 $pagina =$index_find->getTipo();
5022.                 $pagina_h4 ='Documento(s) do tipo ( '.$index_find->getTipo().' )';
5023.             }
5024.                         
5025.         }
5026.         if(isset($_POST["delet_cancel"])){
5027.             $ky = 0 ;
5028.         }
5029.         if(isset($_POST["delet_sim"])){
5030.             
5031.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
5032.             $id_pd = $pdf->getId();
5033.             $entityManager->remove($pdf);
5034.             $entityManager->flush();
5035.           
5036.             $log = new Registro();
5037.             $log->setOperacao('Excluiu Documento com id '.$id_pd); 
5038.             $log->setUser($user_nome_name);
5039.             $log->setCliente($cliente_nome);
5040.             $entityManager->persist($log);
5041.             $entityManager->flush();
5042.             $erro = 'ok';
5043.             $p = 'Documento com id '.$id_pd.' excluido com sucesso '; 
5044.         }
5045.         if(isset($_POST["index_edit"])){
5046.             $yz = 0 ;
5047.             $xy = 1 ;
5048.             $ay = 2 ;
5049.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
5050.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
5051.             $link = $pdf->getImage();
5052.         }
5053.        
5054.         if(isset($_POST["caixa_total"])){
5056.             $caixa_total = $_POST["caixa_total"];
5057.             $documento_total =$_POST["documento_total"];
5058.             $qtd_total =$_POST["qtd_total"];
5061.                 $registro = new Registro();
5062.                 $registro->setOperacao('INDEXADO:  '.$caixa_total. ' CAIXA(S) / '.$documento_total.' DOCUMENTO(S) / '); 
5063.                 $registro->setUser('CONCLUIDO PELA EQUIPE');
5064.                 $registro->setCliente($cliente_nome);
5065.                 $registro->setIp($ip_cliente);
5066.                 $entityManager->persist($registro);
5067.                 $entityManager->flush();
5069.                 $etapa->setRegistro($registro);
5070.                 $etapa->setUpdatedAt($hoje);
5071.                 $entityManager->flush();
5072.                 $erro = 'ok';
5073.                 $p = "Etapa concluída com sucesso";
5074.         }
5075.         
5076.            $cmd = $clientS3->getCommand('GetObject', [
5077.                 'Bucket' => 'arquivosdoc',
5078.                 'Key'    => $caminho. $link, 
5079.             ]);
5080.             
5081.             $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
5082.             $all_Url = (string) $req->getUri();
5083.         
5084.         return $this->render('index/indexacao.html.twig', [
5085.             'documentos' => $documentos,
5086.             'xy' => $xy,
5087.             'yz' => $yz,
5088.             'ay'=>$ay,
5089.             'link' => $link,
5090.             'pdf'=>$pdf,
5091.             'p'=>$p,
5092.             'erro'=>$erro,
5093.             'index_all'=>$index_all,
5094.             'index_tipo'=>$index_tipo,
5095.             'ky'=>$ky,
5096.             'pagina' => $pagina,
5097.             'pagina_h4' =>$pagina_h4,
5098.             'index_find'=>$index_find,
5099.             'mx'=>$mx,
5100.             'class'=>$class,
5101.             'caixas' => $caixas,
5102.             'permissao'=>$permissao,
5103.             'doc'=>$doc,
5104.             'dia_prod' => $dia_prod,
5105.             'fluxo' => $fluxo,
5106.             'id' => $id,
5107.             'caminho' =>$caminho,
5108.             'clientes'=>$clientes,
5109.             'all_Url'=>$all_Url
5111.         ]);
5114.     }
5115.     
5116.     #[Route('/kpis', name: 'kpis')]
5117.     public function kpis(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager): Response
5118.     {
5119.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
5120.         $hoje_formt=$hoje->format('Y-m-d') ;
5121.         $pagina="kpis";
5122.         $motivo ='';
5123.         $error='';
5124.         $user_logado = $this->getUser();
5125.         $de_="";
5126.         $ate_= "";
5127.         $h4 ="TOTAL";
5129.         if (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) {
5130.             $ip_cliente = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR'])[0];
5131.         } else {
5132.             $ip_cliente = $_SERVER['REMOTE_ADDR'];
5133.         }
5134.         
5135.         $payload = json_encode([
5136.             
5137.             'data_inicio' => null,
5138.             'data_fim' => null
5139.             
5140.         ]);
5142.         $options = [
5143.             'http' => [
5144.                 'header'  => "Content-Type: application/json\r\n",
5145.                 'method'  => 'POST',
5146.                 'content' => $payload,
5147.             ],
5148.         ];
5150.         $context  = stream_context_create($options);
5151.         $response = file_get_contents('https://produtive.arquivosdoc.com.br/api/tjrj', false, $context);
5153.         if ($response === false) {
5154.             return new Response("Erro ao consumir API", 500);
5155.         }
5157.         $data = json_decode($response, true);
5158.         
5159.         $conn = $entityManager->getConnection();
5161.         $sql = "
5162.            SELECT 
5163.                 c.nome AS cliente_nome,
5164.                     (SELECT COUNT(cx.id) 
5165.                      FROM cx cx 
5166.                      WHERE cx.caminho IS NOT NULL 
5167.                      AND cx.cliente_id = c.id) AS total_caixas,
5168.                     (SELECT COUNT(d.id) 
5169.                      FROM documento d 
5170.                      JOIN cliente s ON s.id = d.cliente_id
5171.                      WHERE s.cliente_all_id = c.id) AS total_documentos,
5172.                     (SELECT SUM(d.qtd) 
5173.                      FROM documento d 
5174.                      JOIN cliente s ON s.id = d.cliente_id
5175.                      WHERE s.cliente_all_id = c.id) AS imagens_total
5176.                 FROM cliente_all c
5177.                 ORDER BY c.nome ASC
5179.         ";
5181.         $stmt = $conn->prepare($sql);
5182.         $stmt->execute();
5183.         $fed_cliente = $stmt->executeQuery()->fetchAllAssociative();
5184.         
5185.          // 🔹 Adicionando TJRJ no array de clientes
5186.         if (is_array($data)) {
5187.             $fed_cliente[] = [
5188.                 'cliente_nome'     => 'TRIBUNAL DE JUSTICA DO ESTADO DO RIO DE JANEIRO',
5189.                  #'total_caixas'     => $data['total_caixas'] ?? 0,
5190.                 'total_caixas'     => 0,
5191.                 'total_documentos' => $data['total_documentos'] ?? 0,
5192.                 'imagens_total'    => $data['imagens_total'] ?? 0
5193.             ];
5194.         }
5195.         
5196.        
5198.        
5199.         //IMAGENS
5200.         $sql1 = "SELECT SUM(d.qtd) AS total_imagens FROM documento d";
5201.         $totalImagens = $conn->fetchOne($sql1); 
5203.         $totalImagens += $data['imagens_total'] ?? 0;
5204.         
5205.         //DOCUMENTOS
5206.         $sql2 = "SELECT COUNT(d.id) AS total_documentos FROM documento d";
5207.         $documento = $conn->fetchOne($sql2);
5209.         $documento += $data['total_documentos'] ?? 0;
5210.         
5211.         //CX (com filtro de status != 0)
5212.         $sql3 = "SELECT COUNT(d.id) AS total_cx FROM cx d WHERE d.status != 0 AND d.caminho != ''";
5213.         $cx = $conn->fetchOne($sql3);
5214.         
5215.         
5216.          if(isset($_POST["pesq"])){
5217.         
5218.             
5219.             $de = $_POST["de"];
5220.             $ate = $_POST["ate"]." 23:59:59";
5221.             
5222.             
5223.             
5224.             // IMAGENS
5225.             $queryStr = '
5226.                 SELECT SUM(d.qtd) AS total_imagens
5227.                 FROM App\Entity\Documento d
5228.                 WHERE d.createdAt >= :de 
5229.             ';
5230.             if ($ate) {
5231.                 $queryStr .= ' AND d.createdAt <= :ate';
5232.             }
5233.             $query = $entityManager->createQuery($queryStr);
5234.             $query->setParameter('de', $de);
5235.             if ($ate) {$query->setParameter('ate', $ate);}
5236.             $result = $query->getSingleResult();
5237.             $totalImagens = $result['total_imagens'];
5239.             //
5240.         
5241.             // DOCUMENTOS
5242.             $queryStr = '
5243.                 SELECT COUNT(d.id) AS total_documentos
5244.                 FROM App\Entity\Documento d
5245.                 WHERE d.createdAt >= :de
5246.             ';
5247.             if ($ate) {
5248.                 $queryStr .= ' AND d.createdAt <= :ate';
5249.             }
5250.             $query = $entityManager->createQuery($queryStr);
5251.             $query->setParameter('de', $de);
5252.             if ($ate) {$query->setParameter('ate', $ate);}
5253.             $result = $query->getSingleResult();
5254.             $documento = $result['total_documentos'];
5255.             //
5256.         
5257.             // CX
5258.             $queryStr = '
5259.                 SELECT COUNT(d.id) AS total_cx
5260.                 FROM App\Entity\Cx d
5261.                 WHERE d.createdAt >= :de  AND d.caminho IS NOT NULL
5262.             ';
5263.             if ($ate) {
5264.                 $queryStr .= ' AND d.createdAt <= :ate';
5265.             } else {
5266.                 $queryStr .= ' AND DATE(d.createdAt) = DATE(:de)';
5267.             }
5268.             $query = $entityManager->createQuery($queryStr);
5269.             $query->setParameter('de', $de);
5270.             if ($ate) {$query->setParameter('ate', $ate);}
5271.             $result = $query->getSingleResult();
5272.             $cx = $result['total_cx'];
5273.             //
5274.             
5275.             $queryStr = "
5276.                 SELECT 
5277.                     c.nome AS cliente_nome,
5278.                     (SELECT COUNT(cx.id) 
5279.                      FROM App\Entity\Cx cx 
5280.                      WHERE cx.status != 0 
5281.                      AND cx.caminho != '' 
5282.                      AND cx.cliente = c
5283.                      AND cx.createdAt >= :de
5284.             ";
5285.             
5286.             if ($ate) {
5287.                 $queryStr .= " AND cx.createdAt <= :ate";
5288.             } else {
5289.                 $queryStr .= " AND DATE(cx.createdAt) = DATE(:de)";
5290.             }
5291.             
5292.             $queryStr .= ") AS total_caixas,
5293.         
5294.                     (SELECT COUNT(d1.id) 
5295.                      FROM App\Entity\Documento d1 
5296.                      JOIN d1.cliente c1 
5297.                      WHERE c1.clienteAll = c
5298.                      AND d1.createdAt >= :de
5299.             ";
5300.             
5301.             if ($ate) {
5302.                 $queryStr .= " AND d1.createdAt <= :ate";
5303.             } else {
5304.                 $queryStr .= " AND DATE(d1.createdAt) = DATE(:de)";
5305.             }
5306.             
5307.             $queryStr .= ") AS total_documentos,
5308.         
5309.                     (SELECT SUM(d2.qtd) 
5310.                      FROM App\Entity\Documento d2 
5311.                      JOIN d2.cliente c2 
5312.                      WHERE c2.clienteAll = c
5313.                      AND d2.createdAt >= :de
5314.             ";
5315.             
5316.             if ($ate) {
5317.                 $queryStr .= " AND d2.createdAt <= :ate";
5318.             } else {
5319.                 $queryStr .= " AND DATE(d2.createdAt) = DATE(:de)";
5320.             }
5321.             
5322.             $queryStr .= ") AS imagens_total
5323.             FROM App\Entity\ClienteAll c
5324.             ORDER BY c.nome ASC
5325.             ";
5326.             
5327.             // Preparar a consulta com os parâmetros de data
5328.             $query = $entityManager->createQuery($queryStr);
5329.             $query->setParameter('de', $de);
5330.             if ($ate) {
5331.                 $query->setParameter('ate', $ate);
5332.             }
5333.             
5334.             $result = $query->getResult();
5335.                     
5336.             $fed_cliente = $result;
5337.             
5338.             
5339.             
5340.             // 🔹 Chamada API TJRJ
5341.             $payload = json_encode([
5342.                 'data_inicio' => $_POST["de"] ?? null,
5343.                 'data_fim'    => $_POST["ate"] ?? null
5344.             ]);
5345.             
5346.             $options = [
5347.                 'http' => [
5348.                     'header'  => "Content-Type: application/json\r\n",
5349.                     'method'  => 'POST',
5350.                     'content' => $payload,
5351.                 ],
5352.             ];
5353.             
5354.             $context  = stream_context_create($options);
5355.             $response = file_get_contents('https://produtive.arquivosdoc.com.br/api/tjrj', false, $context);
5356.             
5357.             $data = $response ? json_decode($response, true) : [];
5358.             
5359.             // 🔹 Adiciona TJRJ na lista final (igual no geral)
5360.             if (is_array($data)) {
5361.                 $fed_cliente[] = [
5362.                     'cliente_nome'     => 'TRIBUNAL DE JUSTICA DO ESTADO DO RIO DE JANEIRO',
5363.                     'total_caixas'     => 0,
5364.                     'total_documentos' => $data['total_documentos'] ?? 0,
5365.                     'imagens_total'    => $data['imagens_total'] ?? 0
5366.                 ];
5367.             }
5368.             
5369.             
5370.                     
5371.                         
5372.         } 
5373.           
5374.             
5375.      
5376.         
5377.         return $this->render('index/kpis.html.twig',array(
5378.             
5379.             'error' =>$error,
5380.             'motivo' => $motivo,
5381.             'pagina'=>$pagina,
5382.             'user_logado'=> $user_logado ,
5383.             'cx' => $cx,
5384.             'documento' => $documento,
5385.             'de' =>$de_,
5386.             'ate' =>$ate_,
5387.             'h4' => $h4,
5388.             //'documentosPorMes' => $documentosPorMes,
5389.             //'cxPorMes'=>$cxPorMes,
5390.             //'totalImagensPorMes' => $totalImagensPorMes,
5391.             'totalImagens'=>$totalImagens,
5392.             'fed_cliente'=> $fed_cliente
5393.             
5394.             
5395.         ));
5397.     }
5398.     
5399.     #[Route('/fila/count', name: 'fila_count', methods: ['GET'])]
5400.     public function count(EntityManagerInterface $entityManager): JsonResponse
5401.     {
5402.         $user_logado = $this->getUser();
5403.         $user_logado_id = $user_logado->getId();
5404.         $count = $entityManager->getRepository(MessengerMessages::class)->countPendingMessagesByUser($user_logado_id);
5405.         
5406.         return new JsonResponse(['count' => $count]);
5407.     }
5408.     
5409.     #[Route('/index/qualidade', name: 'qualidade')]
5410.     public function qualidade(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager , SessionInterface $session): Response
5411.     {   
5412.         $clienteId = $session->get('cliente_id');
5413.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
5414.         $caixaIds = "LEONARDO DE SOUZA CRUZEIRO";
5415.         $documentoRepository = $entityManager->getRepository(Documento::class);
5416.         $query = $documentoRepository->createQueryBuilder('d')
5417.             ->where('d.user_index IN (:caixaIds)')
5418.             ->andWhere('d.cliente = :clienteId')
5419.             ->andWhere('d.situacao = :situacao OR d.situacao IS NULL')
5420.             ->setParameter('situacao', '')
5421.             ->setParameter('caixaIds', $caixaIds)
5422.             ->setParameter('clienteId', $clienteId)
5423.             ->orderBy('d.caixa', 'ASC') // Ordenando pelo ID da caixa em ordem crescente
5424.             ->getQuery();
5427.         // Executa a query
5428.         $documentos = $query->getResult();
5429.         #dd($documentos);
5430.         $dotenv = new Dotenv();
5431.         $dotenv->load(__DIR__.'/.env');
5432.         $user_logado = $this->getUser();
5433.         $form = $this->createForm(UploadType::class);
5434.         $form->handleRequest($request);
5435.         $user_logado_tipoAcesso = $user_logado->getTipoAcesso();
5436.         $user_nome_name = $user_logado->getNome();
5437.         $user_logado_id = $user_logado->getId();
5438.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
5439.         $hoje_formt=$hoje->format('Y-m-d');
5440.         $dia_prod = 'de hoje';
5441.         $permissao = [];
5442.         $list_indexador = [];
5443.         $slugger = new AsciiSlugger();
5444.         $erro = '';
5445.         $ii=0;
5446.         $pagina = 'qualidade';
5447.         $p = '';
5448.         $link = '';
5449.         $xy = 0 ; 
5450.         $pdf ='';
5451.         $umlautString = '';
5452.         $clientes = 0;
5453.         $caminho ='';
5454.         $class ="";
5455.         $all_Url="";
5456.         
5457.         $clientS3 = new  S3Client([
5458.                     'region'  => 'sa-east-1',
5459.                     'version' => 'latest',
5460.                     'credentials' => [ 
5461.                         'key'    => $_ENV['AWS_KEY'],
5462.                         'secret' => $_ENV['AWS_SECRET'],
5463.                     ],
5464.                 ]);
5465.        
5467.         if(isset($_POST["botao_index"])){
5468.             
5469.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
5470.             $clientes = $pdf->getCliente()->getId();
5471.             $clienteRepository = $entityManager->getRepository(Cliente::class);
5472.             $class =  $doctrine->getRepository(Classificacao::class)->findBy(['cliente' => $clientes]);
5473.             $query = $clienteRepository->createQueryBuilder('c')
5474.                 ->where('c.id = :caixaIds')
5475.                 ->setParameter('caixaIds', $clientes)
5476.                 ->getQuery();
5477.             $cl = $query->getSingleResult();
5478.             $link = $pdf->getImage();
5479.             $xy = 1 ;
5480.             $umlautString = $cl->getNome();
5481.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
5482.             $caminho = strtolower ($teste.'/');
5483.                     
5484.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
5485.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
5486.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
5487.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
5488.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
5489.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
5490.             if($clientes ==  15){$caminho='cbsi-dossies/';}
5491.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
5492.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
5493.             if($clientes ==  127){$caminho='pmecj-s-a.A) - ALMOXARIFADO E PATRIMÔNIO/';}
5494.             
5495.             $cmd = $clientS3->getCommand('GetObject', [
5496.                 'Bucket' => 'arquivosdoc',
5497.                 'Key'    => $caminho. $link, 
5498.                 ]);
5499.                 
5500.             $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
5501.             $all_Url = (string) $req->getUri();
5503.                 
5504.         }
5505.         if(isset($_POST["botao_doc"])){
5506.             
5507.             
5508.             
5509.             
5510.             $yz = 0 ;
5511.             $xy = 1 ;
5512.             $ay = 1 ;
5513.             
5514.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
5515.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($pdf->getTipo());
5516.             $index_tipo_tipo =  $index_tipo->getNome();
5517.             $link = $pdf->getImage();
5518.             $data = $_POST["data"];
5519.             $desc = $_POST["desc"];
5520.             $assunto = $_POST["assunto"];
5521.             $chave = $_POST["chave"];
5522.             $nome = $_POST["nome"];
5523.             $conteiner = $_POST["conteiner"];
5524.             $classifica = $_POST["classifica"];
5525.             $fase = $_POST["fase"];
5526.             
5527.             preg_match_all('/\d+/', $fase, $matches);
5528.             $numeros = array_map('intval', $matches[0]);
5530.             if ($clientes != 7) {
5531.                 if ($data != "") {
5532.                     if ($fase != "") {
5533.                         $numeroParaSomar = $numeros[0];
5534.                         list($ano, $mes, $dia) = explode('-', $data);
5535.                         $ano = intval($ano);
5536.                         $data_vecimento =  $ano + $numeroParaSomar.'-'.$mes.'-'. $dia;
5537.                         $pdf->setVencimentoDocumento(new \DateTimeImmutable($data_vecimento));
5538.                     }
5539.                 $pdf->setDataDocumento(new \DateTimeImmutable($data));
5540.                 }
5541.             }  
5543.             if ($classifica != "") {
5545.                 $classifica_id = $doctrine->getRepository(Classificacao::class)->find($classifica);
5546.                 $pdf->setClassificacao($classifica_id);
5547.             }
5548.             
5549.             
5550.             
5551.             
5552.             $pdf->setAssunto($assunto);
5553.             $pdf->setExtraFields($desc);
5554.             $pdf->setNome($nome);
5555.             $pdf->setKeywords($chave);
5556.             $pdf->setUserIndex($user_nome_name);
5557.             $pdf->setConteiner($conteiner);
5558.             $pdf->setIndexAt(new \DateTimeImmutable('America/Sao_Paulo'));
5559.             $pdf->setSituacao('OK');
5560.             $entityManager->flush();
5561.             $id_pd = $pdf->getId();    
5562.             $log = new Registro();
5563.             $log->setOperacao('Conferiu o Documento com id '.$id_pd); 
5564.             $log->setUser($user_nome_name);
5565.             $log->setCliente($umlautString);
5566.             $entityManager->persist($log);
5567.             $entityManager->flush();
5568.             $erro = 'ok';
5569.             $p =  $index_tipo_tipo.' FOI CONFERIDO COM SUCESSO';
5570.            
5571.         }   
5573.         if(isset($_POST["botao_volta"])){
5575.             $xy = 0 ;
5576.             $yz = 0 ;
5577.         }
5578.         
5579.        
5581.         
5582.         return $this->render('index/qualidade.html.twig', [
5583.             'documentos' => $documentos,
5584.             'xy' => $xy,
5585.             'link' => $link,
5586.             'pdf'=>$pdf,
5587.             'p'=>$p,
5588.             'erro'=>$erro,
5589.             'pagina' => $pagina,
5590.             'caminho' =>$caminho,
5591.             'class' => $class,
5592.             'all_Url'=>$all_Url,
5593.            
5595.         ]);
5598.     }
5599.     
5600.      #[Route('/metas', name: 'metas')]
5601.     public function metas( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer): Response
5602.     {
5603.         
5604.         $fluxos_abertos = $entityManager
5605.             ->getRepository(Fluxo::class)
5606.             ->fluxosAbertosComMaiorPrazo();
5607.             
5608.          $fluxos_mes = $entityManager
5609.         ->getRepository(Fluxo::class)
5610.         ->findMes();
5612.         $totalFluxos     = 0;
5613.         $clientesUnicos  = [];
5614.         $totalCaixas     = 0;
5615.         $totalDocumentos = 0;
5616.         $totalImagens    = 0;
5618.         foreach ($fluxos_mes as $fluxo) {
5620.             $totalFluxos++;
5622.             // 👇 garante cliente único
5623.             if ($fluxo->getCliente()) {
5624.                 $clienteId = $fluxo->getCliente()->getId();
5625.                 $clientesUnicos[$clienteId] = true;
5626.             }
5628.             foreach ($fluxo->getCaixas() as $caixa) {
5629.                 $totalCaixas++;
5631.                 foreach ($caixa->getDocumentos() as $documento) {
5632.                     $totalDocumentos++;
5633.                     $totalImagens += $documento->getQtd();
5634.                 }
5635.             }
5636.         }
5637.         $formatter = new \IntlDateFormatter(
5638.             'pt_BR',
5639.             \IntlDateFormatter::NONE,
5640.             \IntlDateFormatter::NONE,
5641.             'America/Sao_Paulo',
5642.             \IntlDateFormatter::GREGORIAN,
5643.             'MMMM'
5644.         );
5646.         $nomeMes = ucfirst($formatter->format(new \DateTime()));
5648.         $resumo = [
5649.             'fluxos'     => $totalFluxos,
5650.             'clientes'   => count($clientesUnicos), // ✅ não duplica
5651.             'caixas'     => $totalCaixas,
5652.             'documentos' => $totalDocumentos,
5653.             'imagens'    => $totalImagens,
5654.             'nomeMes'     => $nomeMes
5655.         ];
5657.         
5658.         $a = [];
5660.         foreach ($fluxos_abertos as $item) {
5662.             $fluxo = $item[0];
5663.             $maiorData = $item['prazo'];
5665.             $cx = 0;
5666.             $doc = 0;
5667.             $img = 0;
5668.             $cliente_id = $fluxo->getCliente()->getId();
5669.             $cliente = $doctrine->getRepository(Cliente::class)
5670.             ->createQueryBuilder('c')
5671.             ->where('c.id = :id')
5672.             ->setParameter('id', $cliente_id)
5673.             ->getQuery()
5674.             ->getOneOrNullResult();
5676.             foreach ($fluxo->getCaixas() as $caixas) {
5677.                 $cx++;
5678.                 foreach ($caixas->getDocumentos() as $docs) {
5679.                     $doc++;
5680.                     $img += $docs->getQtd();
5681.                 }
5682.             }
5684.             $a[] = [
5685.                 'fluxo'       => $fluxo->getId(),
5686.                 'cliente'     => $cliente->getNome(),
5687.                 'caixas'      => $cx,
5688.                 'documentos'  => $doc,
5689.                 'imagens'     => $img,
5690.                 'prazo'       => $maiorData,
5691.             ];
5692.         }
5693.                 
5695.         return $this->render('index/metas_fluxos.html.twig', [
5696.             'data'=>$a,
5697.             'resumo'=>$resumo
5698.     
5700.         ]);
5701.     }
5702.     
5704.     public function configureDashboard(): Dashboard
5705.     {
5706.         return Dashboard::new()
5707.             ->setTitle('IndexDoc')
5708.             ->setFaviconPath('./img/icon.png');   
5709.     }
5710.     
5712.     public function configureMenuItems(): iterable
5713.     {
5714.         // yield MenuItem::linkToDashboard('Dashboard', 'fa fa-home');
5715.         // yield MenuItem::linkToCrud('The Label', 'fas fa-list', EntityClass::class);
5716.     }
5717. }