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.                 $bus->dispatch(new UploadMultipartMessage(
362.                     $tempFilePath,
363.                     $filename,
364.                     $caminho,
365.                     '',
366.                     $caixaId,
367.                     $clienteId,
368.                     $userId,
369.                     0,
370.                     $conteiner,
371.                     $clientes,
372.                     $clientes_status,
373.                     $safeName,
374.                     $originalName,
375.                     $cliente_alls
376.                 ));
377.             }
378.         
379.             $log = new Registro();
380.             $log->setOperacao('EXPORTOU ' . $cont_file . ' DOCUMENTO(S)');
381.             $log->setUser($user_nome_name);
382.             $log->setCliente($cliente_nome);
383.             $entityManager->persist($log);
384.             $entityManager->flush();
385.         
386.             return $this->redirectToRoute('export');
387.         }
388.       
389.         return $this->render('index/index.html.twig', [
390.             'documentos' => $documentos,
391.             'xy' => $xy,
392.             'yz' => $yz,
393.             'ay'=>$ay,
394.             'link' => $link,
395.             'pdf'=>$pdf,
396.             'p'=>$p,
397.             'erro'=>$erro,
398.             'index_all'=>$index_all,
399.             'index_tipo'=>$index_tipo,
400.             'ky'=>$ky,
401.             'pagina' => $pagina,
402.             'pagina_h4' =>$pagina_h4,
403.             'index_find'=>$index_find,
404.             'mx'=>$mx,
405.             'caixas' => $caixas,
406.             'user_logado' => $user_logado,
407.             'cliente' => $cliente,
408.             'cliente_session' => $cliente_session,
409.             'doc'=>$doc,
410.             'dia_prod' => $dia_prod
411.         ]);
412.     }
413.     
414.     #[Route('/index/planilha', name: 'planilha')]
415.     public function planilha(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session): Response
416.     {
417.         
418.       
419.         $form = $this->createForm(UploadType::class);
420.         $user_logado= $this->getUser();
421.         $user_logado_id = $user_logado->getId();
422.         $user_nome_name= $user_logado->getNome();
423.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
424.         $form->handleRequest($request);
425.         $dotenv = new Dotenv();
426.         $dotenv->load(__DIR__.'/.env');
427.         $erro = '';
428.         $excel = 0;
429.         $pagina = 'index';
430.         $p = '';
431.         $clientS3 = new  S3Client([
432.             'region'  => 'sa-east-1',
433.             'version' => 'latest',
434.             'credentials' => [ 
435.                 'key'    => $_ENV['AWS_KEY'],
436.                 'secret' => $_ENV['AWS_SECRET'],
437.             ],
438.         ]);
439.    
440.         
441.         
442.         if(isset($_POST["btn_cliente"])){
443.             
444.             $session->set('cliente_id', $_POST["btn_cliente"]);
445.             return $this->redirectToRoute('home');
446.         }
449.         $clienteId = $session->get('cliente_id');
450.         
451.         
452.         
453.         if ($clienteId == null ) {
454.             
455.             $caixas =  "";
456.             $index_all ="";
457.             $documentos="";
458.             $cliente_session = "";
459.        
460.         } else {
461.             $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $clienteId]);
462.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
463.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null ,'cliente' => $clienteId]);
464.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
465.             $cliente_nome= $cliente_session->getNome();
466.             
467.         }
468.         
469.         
470.        
471.         
472.       
473.         if ($form->isSubmitted() && $form->isValid()) {
474.             $list =[];
475.             $file = $form['file']->getData();
476.             $spreadsheet = IOFactory::load($file->getPathname());
477.             $sheetData = $spreadsheet->getActiveSheet()->toArray();
479.             foreach ($sheetData as $row) {
480.                 $excel ++;
481.                 $id_cx = null ;
482.                 $selections = $_POST["selections"];
483.                 $nome = array_search('0', $selections);
484.                 $caixa = array_search('1', $selections);
485.                 $assunto = array_search('2', $selections);
486.                 $keywod = array_search('3', $selections);
487.                 $data_documento = array_search('4', $selections);
488.                 $data_vecimento = array_search('5', $selections);
489.                 $descricao  = array_search('6', $selections);
490.                 
491.                 if ($caixa != false ) {
492.                         
493.                     
495.                     $numerosExcel = preg_replace('/\D/', '', $row[$caixa]);
498.                     foreach ($caixas as $key) {
500.                         $nome_cx = $key->getNome();
501.                         $numerosCaixa = preg_replace('/\D/', '', $nome_cx);
503.                         if ($numerosCaixa == $numerosExcel ) {
504.                             
505.                                 $id_cx = $key->getId();
506.                         }
507.                     }
508.                     
509.                     
510.                     if ($id_cx == null) {
512.                         echo '<script>alert("ERRO NA LINHA '.$excel.' NÃO EXISTE ESSA CAIXA CADASTRADA")</script>';
513.                             return $this->render('index/index2.html.twig', [
514.                             'documentos' => $documentos,
515.                             'p'=>$p,
516.                             'erro'=>$erro,
517.                             'index_all'=>$index_all,
518.                             'pagina' => $pagina,
519.                             'caixas' => $caixas,
520.                             'user_logado' => $user_logado,
521.                             'cliente' => $cliente,
522.                             'cliente_session' => $cliente_session,
523.                             'form' => $form->createView(),
524.                                             ]);
525.                     }
527.                 }
529.                 
530.                 
531.                     $yourEntity = new Documento();
532.                     // Ajuste conforme necessário
533.                     $yourEntity->setUser($user_logado);
534.                     $yourEntity->setCliente($cliente_session);
535.                     $yourEntity->setClassificacao($doctrine->getRepository(Classificacao::class)->find(1));
536.                     $yourEntity->setTipo($doctrine->getRepository(Tipo::class)->find($_POST["tipo"]));
537.                     $yourEntity->setNome($row[$nome]); 
538.                     if ($assunto != false ) {$yourEntity->setAssunto($row[$assunto]);}
539.                     if ($caixa != false ) {$yourEntity->setCaixa($doctrine->getRepository(Caixa::class)->find($id_cx));}
540.                     if ($keywod != false ) {$yourEntity->setKeywords($row[$keywod]);}
541.                     if (!empty(trim($row[$data_documento])) && strtoupper(trim($row[$data_documento])) !== "NULL") {
542.                         $yourEntity->setDataDocumento(new \DateTimeImmutable($row[$data_documento]));
543.                     }
544.                     
545.                     #if (!empty(trim($row[$data_vecimento])) && strtoupper(trim($row[$data_vecimento])) !== "NULL") {
546.                      #   $yourEntity->setVencimentoDocumento(new \DateTimeImmutable($row[$data_vecimento]));
547.                     #}
548.                     if ($descricao != false ) {$yourEntity->setExtraFields($row[$descricao]);}
549.                     $entityManager->persist($yourEntity);
550.                     $entityManager->flush();
551.                     $erro = "ok";
552.                     
553.                    
554.                     
555.             }
557.                 
558.                 $log = new Registro();
559.                 $log->setOperacao('PLANILHA EXPORTADA, '.$excel .' CADASTROS INSERIDOS.' ); 
560.                 $log->setUser($user_nome_name);
561.                 $log->setCliente($cliente_nome);
562.                 $entityManager->persist($log);
563.                 $entityManager->flush();
564.                 $erro = "ok";
565.                 if ($excel>1)  {$p =  'PLANILHA EXPORTADA COM SUCESSO, '.$excel .' CADASTROS INSERIDOS , .' ;}
566.                 if ($excel==1) {$p =  'PLANILHA EXPORTADA COM SUCESSO, '.$excel .' CADASTRO INSERIDO ,' ;}
567.             
568.         }
570.         
571.         return $this->render('index/index2.html.twig', [
572.                             'documentos' => $documentos,
573.                             'p'=>$p,
574.                             'erro'=>$erro,
575.                             'index_all'=>$index_all,
576.                             'pagina' => $pagina,
577.                             'caixas' => $caixas,
578.                             'user_logado' => $user_logado,
579.                             'cliente' => $cliente,
580.                             'cliente_session' => $cliente_session,
581.                             'form' => $form->createView(),
582.                                             ]);
583.        
584.     }
585.     
586.     #[Route('/index/planilha/classificacao', name: 'planilha_classificacao')]
587.     public function planilha_classificacao(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session): Response
588.     {
589.         
590.       
591.         $form = $this->createForm(UploadType::class);
592.         $user_logado= $this->getUser();
593.         $user_logado_id = $user_logado->getId();
594.         $user_nome_name= $user_logado->getNome();
595.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
596.         $form->handleRequest($request);
597.         $erro = '';
598.         $excel = 0;
599.         $pagina = 'index';
600.         $p = '';
603.         if(isset($_POST["btn_cliente"])){
604.             
605.             $session->set('cliente_id', $_POST["btn_cliente"]);
606.             return $this->redirectToRoute('home');
607.         }
610.         $clienteId = $session->get('cliente_id');
611.         
612.         
613.         
614.         if ($clienteId == null ) {
615.             
616.             $caixas =  "";
617.             $cliente_session = "";
618.        
619.         } else {
620.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
621.             $cliente_nome= $cliente_session->getNome();  
622.         }
623.         
624.         
625.        
626.         
627.       
628.         if ($form->isSubmitted() && $form->isValid()) {
630.             $list =[];
631.             $file = $form['file']->getData();
632.             $spreadsheet = IOFactory::load($file->getPathname());
633.             $sheetData = $spreadsheet->getActiveSheet()->toArray();
635.             foreach ($sheetData as $row) {
637.                 $excel ++;
638.                 $id_cx = null ;
639.                 $selections = $_POST["selections"];
640.                 $nome = array_search('0', $selections);
641.                 $fase_corrente = array_search('1', $selections);
642.                 $fase_intermediaria = array_search('2', $selections);
643.                 $destinacao_final = array_search('3', $selections);
644.                 $observacoes = array_search('4', $selections);
645.                 $descricao = array_search('5', $selections);
646.                 
647.                 
648.                 if($row[$nome] != null){
649.                 
650.                     $yourEntity = new Classificacao();
651.                     $yourEntity->setNome($row[$nome]);
652.                     $yourEntity->setFaseCorrente($row[$fase_corrente]);
653.                     $yourEntity->setFaseIntermediaria($row[$fase_intermediaria]);
654.                     $yourEntity->setDestinacaoFinal($row[$destinacao_final]);
655.                     $yourEntity->setObservacoes($row[$observacoes]);
656.                     $yourEntity->setExtraFields($row[$descricao]);
657.                     $yourEntity->setCliente($cliente_session);
658.                     $entityManager->persist($yourEntity);
659.                     $entityManager->flush();
660.                     $erro = "ok";
661.                 }
662.                
663.                     
664.                    
665.                     
666.             }
668.                 
669.             $log = new Registro();
670.             $log->setOperacao('PLANILHA EXPORTADA, '.$excel .' CADASTROS INSERIDOS.' ); 
671.             $log->setUser($user_nome_name);
672.             $log->setCliente($cliente_nome);
673.             $entityManager->persist($log);
674.             $entityManager->flush();
675.             $erro = "ok";
676.             if ($excel>1)  {$p =  'PLANILHA EXPORTADA COM SUCESSO, '.$excel .' CADASTROS INSERIDOS , .' ;}
677.             if ($excel==1) {$p =  'PLANILHA EXPORTADA COM SUCESSO, '.$excel .' CADASTRO INSERIDO ,' ;}
678.             
679.         }
681.         
682.         return $this->render('index/index_classificao.html.twig', [
683.                             'p'=>$p,
684.                             'erro'=>$erro,
685.                             'pagina' => $pagina,
686.                             'user_logado' => $user_logado,
687.                             'cliente' => $cliente,
688.                             'cliente_session' => $cliente_session,
689.                             'form' => $form->createView(),
690.                                             ]);
691.        
692.     }
694.     #[Route('/index', name: 'index')]
695.     public function indexar(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager , SessionInterface $session): Response
696.     {
697.         $dotenv = new Dotenv();
698.         $dotenv->load(__DIR__.'/.env');
699.         $user_logado = $this->getUser();
700.         $form = $this->createForm(UploadType::class);
701.         $form->handleRequest($request);
702.         $user_logado_tipoAcesso = $user_logado->getTipoAcesso();
703.         $user_logado_nome = $user_logado->getNome();
704.         $user_logado_id = $user_logado->getId();
705.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
706.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
707.         $hoje_formt=$hoje->format('Y-m-d');
708.         $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $hoje_formt);
709.         $dia_prod = 'de hoje';
710.         $permissao = [];
711.         $list_indexador = [];
712.          
713.         if(isset($_POST["btn_cliente"])){
714.             
715.             $session->set('cliente_id', $_POST["btn_cliente"]);
716.             return $this->redirectToRoute('home');
717.         }
718.         $clienteId = $session->get('cliente_id');
719.         if ($clienteId == null ) {
720.             
721.             $caixas =  "";
722.             $index_all ="";
723.             $documentos="";
724.             $cliente_session = "";
725.        
726.         } else {
727.             
728.             $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $clienteId]);
729.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
730.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null ,'cliente' => $clienteId]);
731.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
732.             
733.             
734.         }
735.        
736.         if(isset($_POST["date_perio"])){
737.             
738.             
739.             $startDate = $_POST["de"];
740.             $endDate = $_POST["ate"];
741.        
742.             $de = new \DateTimeImmutable($startDate);
743.             $ate = new \DateTimeImmutable($endDate);
744.             $de_formt=$de->format('d/m/Y') ;
745.             $ate_formt=$ate->format('d/m/Y') ;
746.             
747.             if($endDate != ""){ 
748.                 
749.                 $doc = $entityManager->getRepository(Documento::class)->findByUserAndDateIndexRange($user_logado_nome, $startDate, $endDate);
750.                 $dia_prod = 'de '. $de_formt.' até '.$ate_formt; 
751.             
752.             }
753.             if($endDate == ""){ 
754.                 
755.                 $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $startDate);
756.                 $dia_prod = 'de '. $de_formt; 
757.             }
758.             
759.             
760.             
761.         }
762.        
763.         
764.         foreach ($user_logado_tipoAcesso["new"] as  $value) {
765.             
766.             foreach ($index_all as $key) {
767.                 if ( $key->getId() ==  $value) {
768.                     
769.                     $permissao[] = $value;
770.                     
771.                 }
772.                
773.             }
774.         }
775.     
776.         $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null , 'cliente' => $clienteId]);
777.         
778.         $class =  $doctrine->getRepository(Classificacao::class)->findBy(['cliente' => $clienteId]);
779.         $cliente_id = $doctrine->getRepository(Cliente::class)->findBy(['id' => $clienteId]);
780.         
781.        
782.         
783.         
784.         foreach ($cliente_id as $cliente_ids) {
785.             
786.             $cliente_nome= $cliente_ids->getNome();
787.             $clientes= $cliente_ids->getId();
788.             $umlautString =$cliente_nome;
789.             $slugger = new AsciiSlugger();
790.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
791.             $caminho = strtolower ($teste.'/');
792.                         
793.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
794.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
795.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
796.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
797.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
798.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
799.             if($clientes ==  15){$caminho='cbsi-dossies/';}
800.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
801.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
802.         }
803.         
804.         
805.         
806.         if ($clienteId == null ) {
807.             
808.             $caixas =  "";
809.        
810.         } else {
811.             
812.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
813.         }   
814.             
815.            
816.         $erro = '';
817.         $ii=0;
818.         $pagina = 'index';
819.         $p = '';
820.         $link = '';
821.         $mx = 0;
822.         $xy = 0 ; 
823.         $yz = 0 ; 
824.         $ay = 0 ;
825.         $ky = 0 ;
826.         $pdf ='';
827.         $pagina_h4 ='Documento(s) para indexar';
828.         $nome_menu_ = '';
829.         $index_tipo='';
830.         $uuid = Uuid::v4();
831.         $user = $this->getUser();
832.         $user_nome= $user->getEmail();
833.         $user_nome_name= $user->getNome();
834.         $pasta_user=$user_nome.'/';
835.         $arr = [];
836.         $arrr=0;
837.         $index_find = null;
838.         $dt = '';
839.         $clientS3 = new  S3Client([
840.                     'region'  => 'sa-east-1',
841.                     'version' => 'latest',
842.                     'credentials' => [ 
843.                         'key'    => $_ENV['AWS_KEY'],
844.                         'secret' => $_ENV['AWS_SECRET'],
845.                     ],
846.                 ]);
847.         
848.      
849.             
850.         if(isset($_POST["dt"]))
851.         {   
853.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => $_POST["dt"]]);
854.             $index_find =  $doctrine->getRepository(Tipo::class)->find($_POST["dt"]);
855.             $pagina =$index_find->getNome();
856.             $pagina_h4 ='Documento(s) do tipo ( '.$pagina.' )';
857.             
858.             
859.         }
860.        
861.         if(isset($_POST["botao_index"])){
862.             
863.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
864.             $link = $pdf->getImage();
865.             $xy = 1 ;
866.             
867.         }
868.         if(isset($_POST["botao_doc"])){
869.             
870.             
871.             $yz = 0 ;
872.             $xy = 1 ;
873.             $ay = 1 ;
874.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
875.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
876.            
877.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
878.             $index_tipo_tipo =  $index_tipo->getNome();
879.             $link = $pdf->getImage();
880.             $fase=$_POST["fase"];
881.             $data = $_POST["data"];
882.             $cx = $_POST["caixas"];
883.             $classifica = $_POST["classifica"];
884.             $fase = $_POST["fase"];
885.             $desc = $_POST["desc"];
886.             $assunto = $_POST["assunto"];
887.             $chave = $_POST["chave"];
888.             $nome = $_POST["nome"];
889.             $conteiner = $_POST["conteiner"];
890.             
892.           
893.             
894.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($cx);
895.             
896.             
897.             
898.             // Encontra todos os números na frase
899.             preg_match_all('/\d+/', $fase, $matches);
901.             // $matches[0] agora contém todos os números encontrados na frase
902.             $numeros = array_map('intval', $matches[0]);
904.             // Exibe os números encontrados
905.             
906.             if ($clientes != 7) {
907.            
908.                 if ($data != "") {
909.                     
910.                     if ($fase != "") {
911.     
912.                         // Número inteiro que você deseja somar ao ano
913.                         $numeroParaSomar = $numeros[0];
914.     
915.                         // Extrair o ano da data
916.                         list($ano, $mes, $dia) = explode('-', $data);
917.     
918.                         // Converter o ano para um número inteiro
919.                         $ano = intval($ano);
920.     
921.                         // Somar o número ao ano
922.                         $data_vecimento =  $ano + $numeroParaSomar.'-'.$mes.'-'. $dia;
923.     
924.                         $pdf->setVencimentoDocumento(new \DateTimeImmutable($data_vecimento));
925.     
926.                     }
927.                 $pdf->setDataDocumento(new \DateTimeImmutable($data));
928.                 }
929.             }    
930.             
931.             if ($clientes == 7) {
932.                   
933.                   $pdf->setVencimentoDocumento(new \DateTimeImmutable($fase));
934.                   $pdf->setDataDocumento(new \DateTimeImmutable($data));
935.              }
936.              
937.             $pdf->setAssunto($assunto);
939.             if ($classifica != "") {
941.                 $classifica_id = $doctrine->getRepository(Classificacao::class)->find($classifica);
942.                 $pdf->setClassificacao($classifica_id);
943.             }
945.             $pdf->setCaixa($caixa_id);
946.             $pdf->setExtraFields($desc);
947.             $pdf->setNome($nome);
948.             $pdf->setKeywords($chave);
949.             $pdf->setUserIndex($user_nome_name);
950.             $pdf->setConteiner($conteiner);
951.             $pdf->setIndexAt(new \DateTimeImmutable('America/Sao_Paulo'));
952.             $pdf->setTipo($index_tipo);
953.             $entityManager->flush();
954.             $id_pd = $pdf->getId();    
955.             $log = new Registro();
956.             $log->setOperacao('Indexou o Documento com id '.$id_pd); 
957.             $log->setUser($user_nome_name);
958.             $log->setCliente($cliente_nome);
959.             $entityManager->persist($log);
960.             $entityManager->flush();
961.             $erro = 'ok';
962.             $p =  $index_tipo_tipo.' indexado com sucesso';
963.             
966.            
967.             
968.            
969.         }   
970.         if(isset($_POST["botao_index_edit"])){
971.             
972.             $yz = 0 ;
973.             $xy = 1 ;
974.             $ay = 1 ;
975.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
976.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
977.             $link = $pdf->getImage();
978.         }
979.         if(isset($_POST["botao_volta"])){
981.             $xy = 0 ;
982.             $yz = 0 ;
983.         }
984.         if(isset($_POST["index_button"])){
985.             
986.             
987.             $yz = 0 ;
988.             $xy = 1 ;
989.             $ay = 1 ;
990.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
991.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["index_button"]);
992.             $link = $pdf->getImage();
993.         }
994.         if(isset($_POST["botao_cancel"])){
995.             $yz = 0 ;
996.             $xy = 1 ;
997.             $ay = 0 ;
998.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
999.             $link = $pdf->getImage();
1000.             
1001.         }
1002.         if(isset($_POST["delet"])){
1003.            
1004.             $ky = 1 ;
1005.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["delet"]);
1006.             $documentos = $doctrine->getRepository(Documento::class)->findBy(['id' => $_POST["delet"]]);
1007.             
1008.             if($pdf->getTipo()!= null){
1009.                 $index_find =  $doctrine->getRepository(Tipo::class)->find($pdf->getTipo());
1010.                 $pagina =$index_find->getTipo();
1011.                 $pagina_h4 ='Documento(s) do tipo ( '.$index_find->getTipo().' )';
1012.             }
1013.                         
1014.         }
1015.         if(isset($_POST["delet_cancel"])){
1016.             $ky = 0 ;
1017.         }
1018.         if(isset($_POST["delet_sim"])){
1019.             
1020.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
1021.             $id_pd = $pdf->getId();
1022.             $entityManager->remove($pdf);
1023.             $entityManager->flush();
1024.           
1025.             $log = new Registro();
1026.             $log->setOperacao('Excluiu Documento com id '.$id_pd); 
1027.             $log->setUser($user_nome_name);
1028.             $log->setCliente($cliente_nome);
1029.             $entityManager->persist($log);
1030.             $entityManager->flush();
1031.             $erro = 'ok';
1032.             $p = 'Documento com id '.$id_pd.' excluido com sucesso '; 
1033.         }
1034.         if(isset($_POST["index_edit"])){
1035.             $yz = 0 ;
1036.             $xy = 1 ;
1037.             $ay = 2 ;
1038.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1039.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
1040.             $link = $pdf->getImage();
1041.         }
1042.        
1043.        
1044.         $cmd = $clientS3->getCommand('GetObject', [
1045.                 'Bucket' => 'arquivosdoc',
1046.                 'Key'    => $caminho. $link, 
1047.             ]);
1048.             
1049.             $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
1050.             $all_Url = (string) $req->getUri();
1051.         return $this->render('index/index1.html.twig', [
1052.             'documentos' => $documentos,
1053.             'xy' => $xy,
1054.             'yz' => $yz,
1055.             'ay'=>$ay,
1056.             'link' => $link,
1057.             'pdf'=>$pdf,
1058.             'p'=>$p,
1059.             'erro'=>$erro,
1060.             'index_all'=>$index_all,
1061.             'index_tipo'=>$index_tipo,
1062.             'ky'=>$ky,
1063.             'pagina' => $pagina,
1064.             'pagina_h4' =>$pagina_h4,
1065.             'index_find'=>$index_find,
1066.             'mx'=>$mx,
1067.             'caixas' => $caixas,
1068.             'class' => $class,
1069.             'permissao'=>$permissao,
1070.             'caminho' =>$caminho,
1071.             'clientes' => $clientes,
1072.             'doc'=>$doc,
1073.             'dia_prod' => $dia_prod,
1074.             'cliente_session' => $cliente_session,
1075.             'all_Url'=>$all_Url
1076.         ]);
1079.     }
1080.     
1081.     #[Route('/index/novo/fluxo', name: 'fluxo_novo')]
1082.     public function fluxoNovo(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer): Response
1083.     {
1084.         $user_logado = $this->getUser();
1085.         $user_logado_nome = $user_logado->getNome();
1086.         $user_logado_id = $user_logado->getId();
1087.         $erro = '';
1088.         $pagina = 'fluxo';
1089.         $p ='';
1090.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
1091.         
1092.         if(isset($_POST["btn_cliente"])){
1093.             
1094.             $session->set('cliente_id', $_POST["btn_cliente"]);
1095.             return $this->redirectToRoute('home');
1096.         }
1099.         $clienteId = $session->get('cliente_id');
1100.         
1101.       
1102.         
1103.         if ($clienteId == null ) {
1104.             
1105.             $cli =  "";
1106.             return $this->redirectToRoute('home');
1107.           
1108.        
1109.         } else {
1110.             
1111.          
1112.             $cli = $doctrine->getRepository(Cliente::class)->find($clienteId);
1113.             
1114.         }
1115.         
1117.         $query = $doctrine->getManager()->createQuery('
1118.             SELECT u
1119.             FROM App\Entity\User u
1120.             JOIN u.clientes c
1121.             WHERE c.id = :clientId
1122.             AND u.enabled = 1
1123.         ')->setParameter('clientId', $clienteId);
1125.         $usuarios = $query->getArrayResult();
1127.         if(isset($_POST["fluxo"])){
1128.             
1129.             $fluxo = new Fluxo();
1130.             $nome = $cli->getNome();
1131.             $fluxo->setNome($nome);
1132.             $fluxo->setUser($user_logado);
1133.             $fluxo->setCliente($cli);
1134.             $fluxo->setObs($_POST["obs"]);
1135.             $entityManager->persist($fluxo);
1136.             $entityManager->flush();
1137.             $id_fluxo = $fluxo->getId(); 
1138.             
1139.             $prazo = $_POST["prazo"];
1140.             $user_1 = $_POST["user"];
1142.             
1144.             foreach ($user_1 as $users) {
1145.                
1146.                     $etapa = new Etapa();
1147.                     $user = $doctrine->getRepository(User::class)->find($users);
1148.                     $mail = $user->getEmail();
1149.                     
1150.                    
1151.                     $etapa->setNome($_POST["etapa"]);
1152.                     $etapa->setOrdem(1);
1153.                     $etapa->setUser($user);
1154.                     $etapa->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1155.                     $etapa->setPrazo(new \DateTimeImmutable($prazo));
1156.                     $entityManager->persist($etapa);
1157.                     $entityManager->flush();
1158.         
1159.                     /*$email = (new Email())
1160.                         ->from('arquivosdoc@arquivosdoc.com.br')
1161.                         ->to($mail)
1162.                         ->subject('Fluxo de Trabalho')
1163.                         ->html('<div style="text-align: center;">
1164.                             <h1 style="color:#1e4067;">Recebimento<br>
1165.                             Cliente: '.$nome.'<br>
1166.                             Prazo:'.$prazo.'<br>
1167.                             Enviado por: '.$user_logado_nome.'<br>
1168.                             Acesse sua pagina inicial no <a href="https://ged.arquivosdoc.com.br/login">ArquivosGED
1169.                             </a></h1>
1170.                             <img src="cid:logo"><div>')
1171.                         ->embed(fopen('C:/xampp8/htdocs/gedemail/public/img/icon.png', 'r'), 'logo', 'image/png');
1172.                     $mailer->send($email);*/
1173.                     
1174.                  
1175.             }
1176.             
1177.             if(isset($_POST["user_2"])){
1178.                 
1179.                 
1180.                 $prazo_2 = $_POST["prazo_2"];
1181.                 $user_2 = $_POST["user_2"];
1183.                 foreach ($user_2 as $users2) {
1184.                     $etapa2 = new Etapa();
1185.                     $etapa2->setNome($_POST["etapa2"]);
1186.                     $etapa2->setOrdem(2);
1187.                     $etapa2->setUser($doctrine->getRepository(User::class)->find($users2));
1188.                     $etapa2->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1189.                     $etapa2->setPrazo(new \DateTimeImmutable($prazo_2));
1190.                     $entityManager->persist($etapa2);
1191.                     $entityManager->flush();
1193.                 }
1194.             }
1196.             if(isset($_POST["user_3"])){
1197.                 
1198.                 
1199.                 $user_3 = $_POST["user_3"];
1200.                 $prazo_3 = $_POST["prazo_3"];
1202.                 foreach ($user_3 as $users3) {
1203.                     $etapa3 = new Etapa();
1204.                     $etapa3->setNome($_POST["etapa3"]);
1205.                     $etapa3->setOrdem(3);
1206.                     $etapa3->setUser($doctrine->getRepository(User::class)->find($users3));
1207.                     $etapa3->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1208.                     $etapa3->setPrazo(new \DateTimeImmutable($prazo_3));
1209.                     $entityManager->persist($etapa3);
1210.                     $entityManager->flush();
1211.                 }    
1212.             }
1214.             if(isset($_POST["user_4"])){
1216.                 
1217.                 $user_4 = $_POST["user_4"];
1218.                 $prazo_4 = $_POST["prazo_4"];
1220.                 foreach ($user_4 as $users4) {
1221.                     $etapa4 = new Etapa();
1222.                     $etapa4->setNome($_POST["etapa4"]);
1223.                     $etapa4->setOrdem(4);
1224.                     $etapa4->setUser($doctrine->getRepository(User::class)->find($users4));
1225.                     $etapa4->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1226.                     $etapa4->setPrazo(new \DateTimeImmutable($prazo_4));
1227.                     $entityManager->persist($etapa4);
1228.                     $entityManager->flush();
1230.                 }
1231.             } 
1232.             
1233.             
1234.             if(isset($_POST["user_5"])){
1236.                 
1237.                 $user_5 = $_POST["user_5"];
1238.                 $prazo_5 = $_POST["prazo_5"];
1239.                 foreach ($user_5 as $users5) {
1241.                     $etapa5 = new Etapa();
1242.                     $etapa5->setNome($_POST["etapa5"]);
1243.                     $etapa5->setOrdem(5);
1244.                     $etapa5->setUser($doctrine->getRepository(User::class)->find($users5));
1245.                     $etapa5->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1246.                     $etapa5->setPrazo(new \DateTimeImmutable($prazo_5));
1247.                     $entityManager->persist($etapa5);
1248.                     $entityManager->flush();
1249.                 }
1250.             } 
1252.             $erro = "ok";
1253.             $p =  'FLUXO ENVIADO' ;
1254.             
1255.             
1256.         }
1257.         
1258.     
1259.        
1260.         return $this->render('index/index4.html.twig', [
1261.     
1262.             
1263.             'p'=>$p,
1264.             'erro'=>$erro,
1265.             'pagina' => $pagina,
1266.             'usuarios' =>$usuarios,
1267.             'cliente' => $cliente
1268.             
1270.         ]);
1271.     }
1273.     #[Route('/index/fluxo', name: 'fluxo')]
1274.     public function fluxo( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer): Response
1275.     {
1276.         $user_logado = $this->getUser();
1277.         $erro = '';
1278.         $pagina = 'fluxo';
1279.         $p ='';
1280.         $registro = $doctrine->getRepository(Registro::class)->findAll();
1281.         $a = 0;
1282.         $clientS3 = new  S3Client([
1283.             'region'  => 'sa-east-1',
1284.             'version' => 'latest',
1285.             'credentials' => [ 
1286.                 'key'    => $_ENV['AWS_KEY'],
1287.                 'secret' => $_ENV['AWS_SECRET'],
1288.             ],
1289.         
1290.         ]);
1292.         
1294.     
1295.         if(isset($_POST["btn_cliente"])){
1296.             
1297.             $session->set('cliente_id', $_POST["btn_cliente"]);
1298.             return $this->redirectToRoute('home');
1299.         }
1302.         $clienteId = $session->get('cliente_id');
1303.         
1304.         if($clienteId == null){
1305.             
1306.             return $this->redirectToRoute('home');
1307.         }
1308.         
1309.         
1310.         $fluxo = $doctrine->getRepository(Fluxo::class)->findBy(['cliente' => $clienteId],['id'=> 'DESC']);
1311.       
1312.         
1313.         // Paginar os fluxos
1314.         $fluxos = $paginator->paginate(
1315.             $fluxo, // O queryBuilder ou a query
1316.             $request->query->getInt('page', 1), // A página atual, padrão é 1
1317.             2 // O número de itens por página
1318.         );
1321.         if (isset($_POST["excel"])) {
1322.             
1323.         
1324.             $cx = null;
1325.             $id_fluxo = $_POST["excel"];
1326.             $fluxo_excel = $doctrine->getRepository(Fluxo::class)->find($id_fluxo);
1327.             $nome_fluxo = $fluxo_excel->getNome();
1328.             $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_excel->getId());
1329.             
1330.             
1331.         
1332.             // Cria uma nova planilha
1333.             $spreadsheet = new Spreadsheet();
1334.             $sheet = $spreadsheet->getActiveSheet();
1335.             $sheet->setTitle('CAIXA(S)');
1336.             // Configura o cabeçalho
1337.             $sheet->setCellValue('A1', 'ID');
1338.             $sheet->setCellValue('B1', 'REPOSITOR');
1339.             $sheet->setCellValue('C1', 'DATA DO ENVIO');
1340.         
1341.             // Estiliza o cabeçalho (fundo azul, texto branco e negrito)
1342.             $headerStyle = [
1343.                 'font' => [
1344.                     'bold' => true,
1345.                     'color' => ['rgb' => 'FFFFFF'], // Texto branco
1346.                 ],
1347.                 'fill' => [
1348.                     'fillType' => Fill::FILL_SOLID,
1349.                     'startColor' => ['rgb' => '095f99'], // Fundo azul
1350.                 ],
1351.             ];
1352.             $sheet->getStyle('A1:C1')->applyFromArray($headerStyle);
1353.         
1354.             // Preenche os dados
1355.             $rowCount = 2;
1356.             foreach ($fluxo_caixas as $caixas) {
1357.                 
1358.                     if($caixas->getCx() != null){
1359.                     
1360.                     $nome = $caixas->getNome();
1361.                     $cx = $caixas->getCx()->getNome();
1362.                     $data = $caixas->getCreatedAt();
1363.             
1364.                     // Insere os valores
1365.                     $sheet->setCellValue('A' . $rowCount, $cx);
1366.                     $sheet->setCellValue('B' . $rowCount, $nome);
1367.             
1368.                     // Converte a data para o formato Excel
1369.                     if ($data instanceof \DateTime) {
1370.                         $sheet->setCellValue('C' . $rowCount, Date::PHPToExcel($data));
1371.                     } else {
1372.                         $sheet->setCellValue('C' . $rowCount, $data); // Evita erro se não for DateTime
1373.                     }
1374.             
1375.                     $rowCount++;
1376.                 }
1377.             }
1378.         
1379.             // Formata a coluna C como data (exceto o cabeçalho)
1380.             $sheet->getStyle('C2:C' . ($rowCount - 1))
1381.                 ->getNumberFormat()
1382.                 ->setFormatCode('dd/mm/yyyy');
1383.         
1384.             // Define largura automática das colunas
1385.             foreach (range('A', 'C') as $col) {
1386.                 $sheet->getColumnDimension($col)->setAutoSize(true);
1387.             }
1390.              // Segunda aba - Outras informações (Exemplo)
1391.             $sheet2 = $spreadsheet->createSheet(); // Cria uma nova aba
1392.             $sheet2->setTitle('DOCUMENTO(S)'); // Renomeia a aba
1393.             $sheet2->setCellValue('A1' , 'ID');
1394.             $sheet2->setCellValue('B1' , 'NOME');
1395.             $sheet2->setCellValue('C1' , 'REPOSITOR');
1396.             $sheet2->setCellValue('D1' , 'TIPO');
1397.             $sheet2->setCellValue('E1' , 'ASSUNTO');
1398.             $sheet2->setCellValue('F1' , 'PALAVRA-CHAVE');
1399.             $sheet2->setCellValue('G1' , 'DIGITALIZAÇÃO');
1400.             $sheet2->setCellValue('H1' , 'QUEM DIGITALIZOU?');
1401.             $sheet2->setCellValue('I1' , 'INDEXAÇÃO');
1402.             $sheet2->setCellValue('J1' , 'QUEM INDEXOU?');
1403.             $sheet2->setCellValue('K1' , 'IMAGEN(S)');
1404.             $sheet2->getStyle('A1:K1')->applyFromArray($headerStyle);
1405.             
1406.             $rowCount = 2;
1408.             foreach ($fluxo_caixas as $caixas) {
1410.                 $doc = $caixas->getDocumentos();
1412.                 
1413.                 foreach ($doc as $docs) {
1414.                     $tipo= null;
1415.                     $id = $docs->getId();
1416.                     $nome = $docs->getNome();
1417.                     $caixa = $docs->getCaixa()->getNome();
1418.                     if($docs->getTipo() != null){
1419.                         $tipo = $docs->getTipo()->getNome();
1420.                     }
1421.                     $qtd = $docs->getQtd();
1422.                     $assunto = $docs->getAssunto();
1423.                     $keywords = $docs->getKeywords();
1424.                     $user = $docs->getUser()->getNome();
1425.                     $data  = $docs->getCreatedAt();
1426.                     $index  = $docs->getIndexAt();
1427.                     $user_index  = $docs->getUserIndex();
1429.                     $sheet2->setCellValue('A' . $rowCount,$id);
1430.                     $sheet2->setCellValue('B' . $rowCount,$nome);
1431.                     $sheet2->setCellValue('C' . $rowCount,$caixa);
1432.                     $sheet2->setCellValue('D' . $rowCount,$tipo);
1433.                     $sheet2->setCellValue('E' . $rowCount,$assunto);
1434.                     $sheet2->setCellValue('F' . $rowCount,$keywords);
1435.                     $sheet2->setCellValue('G' . $rowCount,$data);
1436.                     $sheet2->setCellValue('H' . $rowCount,$user);
1437.                     $sheet2->setCellValue('I' . $rowCount,$index);
1438.                     $sheet2->setCellValue('J' . $rowCount,$user_index);
1439.                     $sheet2->setCellValue('K' . $rowCount,$qtd);
1440.                    
1441.                     
1443.                     if ($data instanceof \DateTime) {
1444.                         $sheet2->setCellValue('G' . $rowCount, Date::PHPToExcel($data));
1445.                     } else {
1446.                         $sheet2->setCellValue('G' . $rowCount, $data); // Evita erro se não for DateTime
1447.                     }
1449.                     if ($data instanceof \DateTime) {
1450.                         $sheet2->setCellValue('I' . $rowCount, Date::PHPToExcel($index));
1451.                     } else {
1452.                         $sheet2->setCellValue('I' . $rowCount, $index); // Evita erro se não for DateTime
1453.                     }
1454.             
1455.             
1456.                     $rowCount++;
1457.                 
1458.                 }
1459.             }
1460.             $sheet2->getStyle('I2:I' . ($rowCount - 1))
1461.                 ->getNumberFormat()
1462.                 ->setFormatCode('dd/mm/yyyy');
1464.             $sheet2->getStyle('G2:G' . ($rowCount - 1))
1465.                 ->getNumberFormat()
1466.                 ->setFormatCode('dd/mm/yyyy');    
1467.         
1468.             foreach (range('A', 'K') as $col) {
1469.                 $sheet2->getColumnDimension($col)->setAutoSize(true);
1470.             }
1473.         
1474.             // Gera o arquivo para download
1475.             $writer = new Xlsx($spreadsheet);
1476.             header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
1477.             header('Content-Disposition: attachment; filename="' . $nome_fluxo . '-FLUXO-' . $id_fluxo . '.xlsx"');
1478.             header('Cache-Control: max-age=0');
1479.             $writer->save('php://output');
1480.             exit;
1481.         }
1483.         if (isset($_POST["pdf"])) {
1484.             
1485.             $id_fluxo = $_POST["pdf"];
1486.             $fluxo_pdf = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($id_fluxo);
1487.             $nome_fluxo = $fluxo_pdf->getNome();
1488.             
1489.            
1490.             $html = $this->render('index/pdf.html.twig', [
1491.                 'fluxo_pdf' => $fluxo_pdf,
1492.                 'registro' => $registro
1493.                 
1494.             ]);
1496.             $options = new Options();
1497.             $options->set('isHtml5ParserEnabled', true);
1498.             $options->set('isPhpEnabled', true);
1499.             $options->set('isRemoteEnabled', true); 
1500.             $dompdf = new Dompdf($options);
1501.             $dompdf->loadHtml($html);
1502.             $dompdf->setPaper('A4', 'portrait');
1504.             // Renderiza o HTML para o PDF
1505.             $dompdf->render();
1507.             // Envia o PDF para o navegador para download
1508.             $dompdf->stream("Relatório_Fluxo_".$id_fluxo."_".$nome_fluxo.".pdf", ["Attachment" => 0]); // 0 para exibir no navegador, 1 para download
1509.         }
1511.         if (isset($_POST["etiqueta"])) {
1512.             try {
1513.         
1514.                 // reforça limites (pode ajustar conforme necessário)
1515.                 ini_set('max_execution_time', 500);
1516.                 ini_set('memory_limit', '3512M');
1517.         
1518.                 $id_fluxo = $_POST["etiqueta"];
1519.                 $fluxo_pdf = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($id_fluxo);
1520.                 $cliente_id = $fluxo_pdf->getCliente()->getId();
1521.                 $cliente = $doctrine->getRepository(Cliente::class)->findWithRelations($cliente_id);
1522.                 $nome_fluxo = $fluxo_pdf->getNome();
1523.                 $clienteAll_fluxo = $cliente->getClienteAll()->getLogo();
1524.                 
1525.                 $cmd = $clientS3->getCommand('GetObject', [
1526.                 'Bucket' => 'arquivosdoc',
1527.                 'Key'    => 'LOGO_CLIENTES/'. $clienteAll_fluxo, 
1528.                 ]);
1529.                 
1530.                 $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
1531.                 $cliente_all_Url = (string) $req->getUri();
1532.                 
1533.                 $clienteAll_fluxo_id = $cliente->getClienteAll()->getId();
1534.                 $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_pdf->getId());
1535.                 if ($cliente_id == 139 or $cliente_id == 137){
1536.                         $html = '
1537.                         <!DOCTYPE html>
1538.                         <html lang="pt-BR">
1539.                         <head>
1540.                             <meta charset="UTF-8">
1541.                             <meta name="viewport" content="width=device-width, initial-scale=1.0">
1542.                             <title>FLUXO</title>
1543.                             <style>
1544.                                 * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
1545.                                 body { text-transform: uppercase; }
1546.                                 .filho { border: 2px solid black; width: 57.2mm; height: 100mm; display: inline-block; margin: 2px; position: relative;}
1547.                                 h2 { text-align: center; font-size: 20px; padding: 5px; }
1548.                                 h2 img{width: 250px; height: 250px;}
1549.                                 h4 { text-align: center; font-size: 12px; padding: 10px; }
1550.                                 h5 { text-align: center; font-size: 14px;}
1551.                                 h6 { text-align: center; font-size: 14px; padding: 5px; }
1552.                                 h5 img { text-align: center;max-height: 40px;width:auto;max-width: 40px}
1553.                                 h6 img { text-align: center;margin:auto;  max-height: 130px;width:auto;max-width: 130px}
1554.                                 p { text-align: center; font-size: 8px; font-weight: bold;}
1555.                                 .pai { position: relative; top: 11%; }
1556.                                 hr { color: black; }
1557.                                 .lis2{
1558.                                     
1559.                                     font-weight: bold;
1560.                                     margin:5px;
1561.                                 }
1562.                                 .lis3 {
1563.                                     position: absolute;
1564.                                     bottom: 0;
1565.                                     width: 100%;
1566.                                     font-weight: bold;
1567.                                     text-align: center;
1568.                                     margin-bottom:5px;
1569.                                     margin-top:5px;
1570.                                        
1571.                                 }
1572.                                 .lis{
1573.                                     
1574.                                     margin-left:10px;
1575.                                     font-weight: bold;
1576.                                 }
1577.                                 li{
1578.                                   margin:5px;
1579.                                   font-size: 12px
1580.                                 }
1581.                                 
1582.                             </style>
1583.                         </head>
1584.                         <body>
1585.                         <div class="pai">';
1586.                 
1587.                         $count = 0;
1588.                 
1589.                         foreach ($fluxo_caixas as $caixa) {
1590.                             $count++;
1591.                             $documento_fluxo = $caixa->getDocumentos()->toArray();
1592.                             
1593.                 
1594.                             $html .= '<div class="filho">
1595.                                 
1596.                                 
1597.                                 <h6><img src="'.$cliente_all_Url.'" class="img"></h6>
1598.                                 <hr>
1599.                                 <h2>' . htmlspecialchars($caixa->getNome()) . '</h2>
1600.                                 <hr>
1601.                                 ';
1602.                 
1603.                             $docs = [];
1604.                             
1605.                             if (!empty($documento_fluxo)) {
1606.                                 foreach ($documento_fluxo as $doc) {
1607.                                     if($doc->getTipo() != NULL ){
1608.                                         if ($cliente_id != 122) {
1609.                                             $docs[] = $doc->getTipo()->getNome();
1610.                                         } else {
1611.                                             $docs[] = $doc->getNome();
1612.                                         }
1613.                                     }
1614.                                 }
1615.                                 $docs = array_unique($docs);
1616.                             }
1617.                             
1618.                             
1621.                             $docs_class = [];
1622.                             
1623.                             if (!empty($documento_fluxo)) {
1624.                                 foreach ($documento_fluxo as $doc) {
1625.                                     
1626.                                     if($doc->getClassificacao() != NULL ){
1627.                                        $clss =  $entityManager->getRepository(Classificacao::class)->findBy(['id' => $doc->getClassificacao()->getId()]);
1628.                                        $class_nome =  $clss[0]->getNome();
1629.                                        $docs_class[] = $class_nome;
1630.                                         
1631.                                     }
1632.                                 }
1633.                                 $docs_class = array_unique($docs_class);
1634.                             }
1635.                 
1637.                             $docs_data = [];
1638.                             $docs_assunto=[];
1640.                             if (!empty($documento_fluxo)) {
1641.                                 foreach ($documento_fluxo as $data) {
1642.                                     if ($data->getNome() !== null) {
1643.                                         $docs_data[] = $data->getNome();
1644.                                     }
1645.                                     if ($data->getAssunto() !== null) {
1646.                                         $docs_assunto[] = $data->getAssunto();
1647.                                     }
1648.                                 }
1649.                                 $docs_data = array_unique($docs_data);
1650.                                 $docs_assunto = array_unique($docs_assunto);
1651.                             }
1652.                             
1653.                              if ($cliente_id == 139){
1654.                        
1655.                                 $pl_numeros = [];
1656.                                 $req_numeros = [];
1657.                                 $req_ano = null;
1658.                                 
1659.                                 foreach ($docs_data as $doc) {
1660.                                 
1661.                                 
1662.                                     if (preg_match('/^PL-(\d{1,3}(?:\.\d{3})*)$/', $doc, $m)) {
1663.                                 
1664.                                         $numeroLimpo = str_replace('.', '', $m[1]);
1665.                                         $pl_numeros[] = (int)$numeroLimpo;
1666.                                     }
1667.                                 
1668.                            
1669.                                     elseif (stripos($doc, 'REQUERIMENTO') !== false 
1670.                                         && preg_match('/-(\d+)\.(\d{4})$/', $doc, $m)) {
1671.                                 
1672.                                         $req_numeros[] = (int)$m[1];
1673.                                         $req_ano = $m[2];
1674.                                     }
1675.                                 }
1676.                                 
1677.                         
1678.                                 
1679.                                 $menorNome = null;
1680.                                 $maiorNome = null;
1681.                                 $docs_faltantes = [];
1682.                                 $tipoAtual = null;
1683.                                 
1684.                           
1685.                                 
1686.                                 if (!empty($pl_numeros)) {
1687.                                 
1688.                                     sort($pl_numeros);
1689.                                 
1690.                                     $menor = min($pl_numeros);
1691.                                     $maior = max($pl_numeros);
1692.                                 
1693.                                     $menorNome = 'PL ' . number_format($menor, 0, '', '.');
1694.                                     $maiorNome = 'PL ' . number_format($maior, 0, '', '.');
1695.                                 
1696.                                     $esperado = range($menor, $maior);
1697.                                     $faltantes = array_diff($esperado, $pl_numeros);
1698.                                 
1699.                                     foreach ($faltantes as $f) {
1700.                                         $docs_faltantes[] = 'PL ' . number_format($f, 0, '', '.');
1701.                                     }
1702.                                 
1703.                                     $tipoAtual = 'PL';
1704.                                 }
1705.                                 
1706.                           
1707.                                 
1708.                                 elseif (!empty($req_numeros)) {
1709.                                 
1710.                                     sort($req_numeros);
1711.                                 
1712.                                     $menor = min($req_numeros);
1713.                                     $maior = max($req_numeros);
1714.                                 
1715.                                     $menorNome = str_pad($menor, 2, '0', STR_PAD_LEFT) . '.' . $req_ano;
1716.                                     $maiorNome = str_pad($maior, 2, '0', STR_PAD_LEFT) . '.' . $req_ano;
1717.                                 
1718.                                     $esperado = range($menor, $maior);
1719.                                     $faltantes = array_diff($esperado, $req_numeros);
1720.                                 
1721.                                     foreach ($faltantes as $f) {
1722.                                         $docs_faltantes[] = str_pad($f, 2, '0', STR_PAD_LEFT) . '.' . $req_ano;
1723.                                     }
1724.                                 
1725.                                     $tipoAtual = 'REQUERIMENTO';
1726.                                 }                                                                        
1727.                                                                                                                             
1728.                                                                 
1729.                                     $html .= '<h6>' . htmlspecialchars(implode(', ', $docs)) . '</h6>
1730.                                     <hr>';
1731.                                    
1732.     
1733.     
1734.                                     $html .= '<h6>Conteúdo:</h6>';
1735.     
1736.                                     $html .= '<div class="lis">';
1737.                                     foreach ($docs_class as $classs_nome) {
1738.                                     $html .= '
1739.                                         <li>' . $classs_nome. '</li>';
1740.                                     }
1741.                                     $html .= '</div><br>';
1742.                                     
1743.                                     
1744.                                     if ($menorNome !== null && $maiorNome !== null) {
1745.                                         $html .= '<h6>'.$menorNome.' Até '.$maiorNome.'</h6>';
1746.                                     }
1747.         
1748.                                     if($docs_faltantes != []){
1749.                                         $html .= '
1750.                                         <div class="lis2"><p>';
1751.                                                 $html .= 'Faltantes*</br>';
1752.                                                 $qtdFaltantes = count($docs_faltantes);
1753.     
1754.                                                 if ($qtdFaltantes > 40) {
1755.                                                 
1756.                                                     $html .= '<span style="color:red; font-weight:bold;font-size: 8px">
1757.                                                         Existem ' . $qtdFaltantes . ($tipoAtual === 'PL' ? ' projetos de lei ' : ' requerimentos ') . 'faltantes.
1758.                                                         Conferir no inventário.
1759.                                                     </span>';
1760.                                                 
1761.                                                 } else {
1762.                                                 
1763.                                                 $html .= implode(' | ', $docs_faltantes);
1764.     
1765.                                                 
1766.                                                 }
1767.                                             
1768.                                         $html .= '</p></div>';
1769.                                     }
1770.                                 }
1771.                                 else{
1772.                                     
1773.                                                                 // Remove duplicados
1774.                                 $docs_assunto = array_unique($docs_assunto);
1775.                                 
1776.                                 // Converte para DateTime
1777.                                 $datasObj = array_map(function ($data) {
1778.                                     return DateTime::createFromFormat('m/Y', $data);
1779.                                 }, $docs_assunto);
1780.                                 
1781.                                 // Remove possíveis datas inválidas
1782.                                 $datasObj = array_filter($datasObj);
1783.                                 
1784.                                 // Ordena por data
1785.                                 usort($datasObj, function ($a, $b) {
1786.                                     return $a <=> $b;
1787.                                 });
1788.                                 
1789.                                 $resultado = [];
1790.                                 
1791.                                 if (count($datasObj) > 0) {
1792.                                 
1793.                                     $inicio = $datasObj[0];
1794.                                     $anterior = $datasObj[0];
1795.                                 
1796.                                     for ($i = 1; $i < count($datasObj); $i++) {
1797.                                 
1798.                                         $atual = $datasObj[$i];
1799.                                 
1800.                                         $proximoEsperado = clone $anterior;
1801.                                         $proximoEsperado->modify('+1 month');
1802.                                 
1803.                                         if ($atual->format('m/Y') !== $proximoEsperado->format('m/Y')) {
1804.                                 
1805.                                             if ($inicio->format('m/Y') === $anterior->format('m/Y')) {
1806.                                                 $resultado[] = $inicio->format('m/Y');
1807.                                             } else {
1808.                                                 $resultado[] = $inicio->format('m/Y') . ' até ' . $anterior->format('m/Y');
1809.                                             }
1810.                                 
1811.                                             $inicio = $atual;
1812.                                         }
1813.                                 
1814.                                         $anterior = $atual;
1815.                                     }
1816.                                 
1817.                                     // Fecha o último bloco
1818.                                     if ($inicio->format('m/Y') === $anterior->format('m/Y')) {
1819.                                         $resultado[] = $inicio->format('m/Y');
1820.                                     } else {
1821.                                         $resultado[] = $inicio->format('m/Y') . ' Até ' . $anterior->format('m/Y');
1822.                                     }
1823.                                 }
1825.                                 
1826.                                     
1827.                                     
1828.                                     
1829.                                     
1830.                                     $html .= '<h6>Conteúdo:</h6>';
1831.     
1832.                                     $html .= '<div class="lis">';
1833.                                     foreach ($docs_class as $classs_nome) {
1834.                                     $html .= '
1835.                                         <li>' . $classs_nome. '</li>';
1836.                                     }
1837.                                     $len = count($resultado);
1838.                                     if ($len <5 and $len >0) {
1839.                                          
1840.                                          $html .= '<br>';     
1841.                                     }
1842.                                     foreach ($docs_data as $classs_nome) {
1843.                                     $html .= '
1844.                                         <h6>' . $classs_nome. '</h6>';
1845.                                     }
1846.                                     
1847.                                     
1848.                                     
1849.                                         
1850.                                     foreach ($resultado as $classs_nome) {
1851.                                         if ($len >= 9) {
1852.                                             $fontSize = 8;
1853.                                         } 
1854.                                         elseif ($len <10 and $len >5) {
1855.                                             $fontSize = 10;
1856.                                         }
1857.                                         
1858.                                         elseif ($len <5 and $len >0) {
1859.                                             $fontSize = 12;
1860.                                              
1861.                                         }else{
1862.                                             $fontSize = 8;
1863.                                         }
1864.                                         
1865.                                     $html .= '
1866.                                         <p style="font-size: ' . $fontSize . 'px;">' . $classs_nome. '</p>';
1867.                                     }
1868.                                     
1869.                                     $html .= '</div><br>';
1870.                                 }
1871.                                 $html .= 
1872.                                 
1873.                                 
1874.                                 '<div class="lis3"><hr>
1875.                                 
1876.                                 <p>ARQUIVOS GESTÃO DOCUMENTAL</p>
1877.                                 <h5><img src="https://index.arquivosdoc.com.br/img/logo_menu.png" class="img"></h5>
1878.                                 </div>
1879.                                 
1880.                             </div>';
1881.                 
1882.                             if ($count %  10 == 0) {
1883.                                 $html .= '<div style="page-break-after: always;"></div>';
1884.                             }
1885.                         }
1886.                
1888.                         $html .= '</div></body></html>';
1889.                 }
1890.         
1891.                 if($clienteAll_fluxo_id != 17 and $clienteAll_fluxo_id != 40 and $cliente_id != 139 and $cliente_id != 137){
1892.                         // Construção do HTML com os QR Codes
1893.                         $html = '
1894.                         <!DOCTYPE html>
1895.                         <html lang="pt-BR">
1896.                         <head>
1897.                             <meta charset="UTF-8">
1898.                             <meta name="viewport" content="width=device-width, initial-scale=1.0">
1899.                             <title>FLUXO</title>
1900.                             <style>
1901.                                 * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
1902.                                 body { text-transform: uppercase; }
1903.                                 .filho { border: 2px solid black; width: 120mm; height: 170mm; display: inline-block; margin-left: 45px; }
1904.                                 h2 { text-align: center; font-size: 36px; padding: 5px; }
1905.                                 h2 img{width: 200px; height: 200px;}
1906.                                 h4 { text-align: center; font-size: 12px; padding: 10px; }
1907.                                 h5 { text-align: center; font-size: 22px; padding: 10px; }
1908.                                 h6 { text-align: justify; font-size: 26px; padding: 5px; }
1909.                                 h6 img { float: right;  max-height: 70px;width:auto;max-width: 170px}
1910.                                 p { text-align: justify; font-size: 14px; font-weight: bold; padding: 10px; }
1911.                                 .pai { position: relative; top: 20%; }
1912.                                 hr { color: black; }
1913.                                 .lis{
1914.                                 
1915.                                  width:430px; height: 200px;
1916.                                  margin:auto;
1917.                                  font-weight: bold;
1918.                                 }
1919.                                 li{
1920.                                   margin-left:10px;
1921.                                 }
1922.                                 
1923.                             </style>
1924.                         </head>
1925.                         <body>
1926.                         <div class="pai">';
1927.         
1928.                         $count = 0;
1929.         
1930.                         foreach ($fluxo_caixas as $caixa) {
1931.                             $count++;
1932.                             $documento_fluxo = $caixa->getDocumentos()->toArray();
1933.         
1934.                             // Gerar QR Code
1935.                             $qrCode = Builder::create()
1936.                                 ->writer(new PngWriter())
1937.                                 ->data("https://ged.arquivosdoc.com.br/info/caixa/" . $caixa->getId())
1938.                                 ->build();
1939.                             $qrCodeBase64 = base64_encode($qrCode->getString());
1940.         
1941.                             $html .= '<div class="filho">
1942.                                 <h2>' . htmlspecialchars($caixa->getNome()) . '</h2>
1943.                                 <hr>
1944.                                 <h6>Arquivos:<img src="'.$cliente_all_Url.'" class="img"></h6>
1945.                                 <p>' . htmlspecialchars($fluxo_pdf->getNome()) . '</p>
1946.                                 <hr>
1947.                                 <h6>Título:</h6>';
1948.         
1949.                             $docs = [];
1950.                             
1951.                             if (!empty($documento_fluxo)) {
1952.                                 foreach ($documento_fluxo as $doc) {
1953.                                     if($doc->getTipo() != NULL ){
1954.                                         if ($cliente_id != 122) {
1955.                                             $docs[] = $doc->getTipo()->getNome();
1956.                                         } else {
1957.                                             $docs[] = $doc->getNome();
1958.                                         }
1959.                                     }
1960.                                 }
1961.                                 $docs = array_unique($docs);
1962.                             }
1963.                             
1964.                             $docs_class = [];
1965.                             
1966.                             if (!empty($documento_fluxo)) {
1967.                                 foreach ($documento_fluxo as $doc) {
1968.                                     
1969.                                     if($doc->getClassificacao() != NULL ){
1970.                                        $clss =  $entityManager->getRepository(Classificacao::class)->findBy(['id' => $doc->getClassificacao()->getId()]);
1971.                                        $class_nome =  $clss[0]->getNome();
1972.                                        $docs_class[] = $class_nome;
1973.                                        
1974.                                         
1975.                                     }
1976.                                 }
1977.                                 $docs_class = array_unique($docs_class);
1978.                             }
1979.                             
1980.         
1981.                             $html .= '<p>' . htmlspecialchars(implode(', ', $docs)) . '</p>
1982.                                 <hr>
1983.                                 <h6>Conteúdo:</h6>';
1984.                                 
1985.                                 
1986.                                 
1987.                                   if($clienteAll_fluxo_id == 41){
1988.                                       
1989.                                         $html .= '<div class="lis">';
1990.                                         $len = count($docs_class);
1991.                                      
1992.                                         foreach ($docs_class as $classs_nome) {
1993.                                         
1994.                                         
1995.                                             
1996.                                             if ($len <= 9) {
1997.                                                 $fontSize = 16;
1998.                                             } 
1999.                                             elseif ($len <= 11) {
2000.                                                 $fontSize = 14;
2001.                                             } 
2002.                                             elseif ($len <= 13) {
2003.                                                 $fontSize = 12;
2004.                                             } 
2005.                                             elseif ($len <= 16) {
2006.                                                 $fontSize = 10;
2007.                                             }
2008.                                             elseif ($len <= 18) {
2009.                                                 $fontSize = 9;
2010.                                             }
2011.                                             elseif ($len <= 21) {
2012.                                                 $fontSize =8;
2013.                                             }
2014.                                             elseif ($len <= 23) {
2015.                                                 $fontSize = 7;
2016.                                             }
2017.                                             else {
2018.                                                 $fontSize = 6;
2019.                                             }
2020.                                             $html .= '<li style="font-size: ' . $fontSize . 'px;">' . $classs_nome . '</li>';
2021.                                         }
2022.                                         
2023.                                         $html .= '</div>';
2024.                                         
2025.                                       
2026.                                   }else{
2027.                                              $html .= '
2028.                                                 <h2><img src="data:image/png;base64,' . $qrCodeBase64 . '" alt="QR Code"></h2>';
2029.                                   }  
2030.                                         
2031.                                 
2032.                                 
2033.                                 $html .= '<hr>
2034.                                 <h4>ARQUIVOS GESTÃO DOCUMENTAL</h4>
2035.                                 <h5><img src="https://index.arquivosdoc.com.br/img/arquivos_mini.png" class="img"></h5>
2036.                                 <hr>
2037.                                 <h4>Etiqueta gerada automaticamente pelo ArquivosGED</h4>
2038.                             </div>';
2039.         
2040.                             if ($count % 2 == 0) {
2041.                                 $html .= '<div style="page-break-after: always;"></div>';
2042.                             }
2043.                         }
2044.                
2045.         
2046.                         $html .= '</div></body></html>';
2047.                 }
2048.         
2049.                 
2050.                 if($clienteAll_fluxo_id == 17 ){
2051.                     // Construção do HTML com os QR Codes
2052.                     $html = '
2053.                     <!DOCTYPE html>
2054.                     <html lang="pt-BR">
2055.                     <head>
2056.                         <meta charset="UTF-8">
2057.                         <meta name="viewport" content="width=device-width, initial-scale=1.0">
2058.                         <title>FLUXO</title>
2059.                         <style>
2060.                             * { margin: 0; padding: 0; font-family: Calibri, sans-serif; }
2061.                             .filho { border: 2px solid black; width: 125mm; height: 170mm; display: inline-block; margin-left: 45px; }
2062.                             h2 { font-size: 36px; padding: 5px; }
2063.                             h2 img{width: 200px; height: 200px;}
2064.                             .img_footer{width: 60px; height: 60px;position:relative;top:20px}
2065.                             h4 { text-align: center; font-size: 12px; padding: 10px; }
2066.                             h5 { text-align: center; font-size: 22px; padding: 10px; }
2067.                             h6 { text-align: justify; font-size: 26px; padding: 5px; }
2068.                             h6 img { float: right;  max-height: 77px;width:auto;max-width: 250px}
2069.                             p { text-align: justify; font-size: 18px; font-weight: bold; padding: 10px; }
2070.                             .pai { position: relative; top: 20%; }
2071.                             hr { color: black; }
2072.                             .rodape {
2073.                                 position:relative;bottom:15px
2074.                             }
2075.         
2076.                             
2077.                         </style>
2078.                     </head>
2079.                     <body>
2080.                     <div class="pai">';
2081.             
2082.                     $count = 0;
2083.         
2084.                     $codigo = "";
2085.                     $info = "";
2086.                     $prazo = "";
2087.         
2088.                     if($cliente_id == 113){
2089.                         $codigo = "23.182";
2090.                         $info = "PROCESSOS DIVERSOS";
2091.                         $prazo = "57 ANOS";
2092.                     }
2093.         
2094.                     if($cliente_id == 114){                        
2095.                         $codigo = "23.11";
2096.                         $info = "PROCESSOS DE RECURSOS HUMANOS";
2097.                         $prazo = "100 ANOS";
2098.                     }
2099.             
2100.                     foreach ($fluxo_caixas as $caixa) {
2101.         
2102.         
2103.                         $texto = $caixa->getNome();
2104.         
2105.                         preg_match_all('/\d+/', $texto, $matches);
2106.                         
2107.                         if (count($matches[0]) >= 2) {
2108.                              $numero = str_pad($matches[0][0], 3, '0', STR_PAD_LEFT); 
2109.                             $ano = substr($texto, strpos($texto, $matches[0][0]) + strlen($matches[0][0])); 
2110.                             $ano = trim(str_replace('-', '', $ano)); 
2111.                         } else {
2112.                             echo "Formato inválido!";
2113.                         }
2114.         
2115.         
2116.         
2117.                         $count++;
2118.                         $documento_fluxo = $caixa->getDocumentos()->toArray();
2119.         
2120.                         // Gerar QR Code
2121.                         $qrCode = Builder::create()
2122.                             ->writer(new PngWriter())
2123.                             ->data("https://ged.arquivosdoc.com.br/info/caixa/" . $caixa->getId())
2124.                             ->build();
2125.                         $qrCodeBase64 = base64_encode($qrCode->getString());
2126.             
2127.                         $html .= '<div class="filho">
2128.                             <h2>&nbsp;Caixa nº&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'. htmlspecialchars($numero) . '</h2>
2129.                             <hr>
2130.                             <h6>ARQUIVO:<img src="'.$cliente_all_Url. '" class="img"></h6>
2131.                             <p>SAAE VOLTA REDONDA-RJ</p>
2132.                             <hr>
2133.                             <h6>CÓDIGO TEMPORALIDADE:</h6>
2134.                             <p>'.$codigo.'</p><hr>
2135.                             <h6>TÍTULO:</h6>';
2136.             
2137.         
2138.                         $html .= '<p>' . htmlspecialchars('PROCESSOS ADMINISTRATIVOS') . '</p>
2139.                             <hr>
2140.                             <h6>INFORMAÇÕES:</h6>
2141.                             <p>'.$info.'</p>
2142.                             <hr>
2143.                             <h6>PRAZO DE GUARDA:</h6>
2144.                             <p>'.$prazo.'</p>
2145.                             <hr>
2146.                             <h6>DATA:</h6>
2147.                             <p>'.$ano.'</p>
2148.                             <hr>
2149.                            
2150.                                 <p class="rodape">&nbsp;ARQUIVOS GESTÃO DOCUMENTAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
2151.                                 <img src="https://index.arquivosdoc.com.br/img/arquivos_mini.png" class="img_footer"></p>
2152.                            
2153.                             </div>';
2154.             
2155.                         if ($count % 2 == 0) {
2156.                             $html .= '<div style="page-break-after: always;"></div>';
2157.                         }
2158.                     }
2159.            
2160.         
2161.                     $html .= '</div></body></html>';
2162.                 }
2163.                 
2164.                 if($clienteAll_fluxo_id == 40  ){
2165.                         $documento_all_sebrae = $doctrine->getRepository(Documento::class)
2166.                         ->findBy(
2167.                             ['cliente' => $cliente_id], // filtros
2168.                             ['id' => 'DESC'],            // ordenação (opcional)
2169.                             100,                        // LIMIT
2170.                             0                           // OFFSET
2171.                         );
2172.                         $html = '
2173.                         <!DOCTYPE html>
2174.                         <html lang="pt-BR">
2175.                         <head>
2176.                             <meta charset="UTF-8">
2177.                             <meta name="viewport" content="width=device-width, initial-scale=1.0">
2178.                             <title>FLUXO</title>
2179.                             <style>
2180.                                 * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
2181.                                 body { text-transform: uppercase; }
2182.                                 .filho { border: 2px solid black; width: 120mm; height: 160mm; display: inline-block; margin-left: 20px;padding:10px;} 
2183.                                 h2 { text-align: center; font-size: 36px; padding: 5px; }
2184.                                 h2 img{width: 200px; height: 200px;}
2185.                                 h4 { text-align: center; font-size: 12px; padding: 10px; }
2186.                                 h5 { text-align: center; font-size: 22px; padding: 10px; }
2187.                                 h6 { text-align: justify; font-size: 26px; padding: 5px; }}
2188.                                 p { text-align: justify; font-size: 18px; font-weight: bold; padding: 10px; }
2189.                                 .pai { position: relative; top: 20%;text-align:center; }
2190.                                 hr { color: black; }
2191.                                 
2192.                                     .linha {
2193.                                         margin-bottom: 1mm;
2194.                                         font-size: 10pt;
2195.                                     }
2197.                                     .box-label {
2198.                                         background: #f1f1f1;
2199.                                         border: 1px solid black;
2200.                                         padding: 1mm;
2201.                                         font-size: 8pt;
2202.                                         text-align: center;
2203.                                         margin-top: 1mm;
2204.                                     }
2206.                                     .box-value {
2207.                                         text-align: center;
2208.                                         font-size: 10pt;
2209.                                         margin: 2mm 0 2mm 0;
2210.                                         
2211.                                     }
2212.                                    .box-value_conteudo {
2213.                                         margin: 2mm 0 2mm 0;
2214.                                         text-align: justify;
2215.                                        
2216.                                     }
2217.                                     
2218.                                     img{
2219.                                         width: 120px;
2220.                                         height:80px;
2221.                                         margin: 2mm 0 2mm 0;
2222.                                     }
2223.                                     
2224.                                     .titulo{
2225.                                         margin: 2mm 0 2mm 0;
2226.                                         font-size: 10pt;
2227.                                     }
2228.                                     
2229.                                     .bloco-conteudo {
2230.                                         position: relative;
2231.                                         height: 100%;
2232.                                     }
2233.                                     
2234.                                     .hr-fixo {
2235.                                         position: absolute;
2236.                                         bottom: 0;
2237.                                         left: 0;
2238.                                         width: 100%;
2239.                                         margin: 0 0 0 0;
2240.                                     }
2241.                                     
2243.                                 
2244.                             </style>
2245.                         </head>
2246.                         <body>
2247.                         <div class="pai">';
2248.                 
2249.                         $count = 0;
2250.                 
2251.                         foreach ($documento_all_sebrae as $caixa) {
2252.                             $count++;
2253.                                 $conteudo = htmlspecialchars(str_replace('?', '', $caixa->getExtraFields()));
2254.                                 $tamanho = strlen($conteudo);
2255.                                 $dates="";
2256.                             
2257.                                 if ($tamanho <= 300) {
2258.                                     $fontSize = '8pt';
2259.                                 } elseif ($tamanho <= 600) {
2260.                                     $fontSize = '7pt';
2261.                                 } elseif ($tamanho <= 900) {
2262.                                     $fontSize = '6pt';
2263.                                 } else {
2264.                                     $fontSize = '4pt';
2265.                                 }
2266.                                 
2267.                                 if($caixa->getDataDocumento()){
2268.                                     $dates=$caixa->getDataDocumento()->format('d/m/Y');
2269.                                 }
2270.                             
2271.                                 $html .= 
2272.                                     '<div class="filho">
2273.                                         <div class="bloco-conteudo">
2274.                                         
2275.                                             <img src="'.$cliente_all_Url.'" class="img"></h6>
2276.                             
2277.                                             <div class="titulo">ARQUIVO INATIVO</div><br>
2278.                             
2279.                                             <div class="linha">CAIXA Nº: _______________</div>
2280.                             
2281.                                             <div class="box-label">ÁREA/SIGLA:</div>
2282.                                             <div class="box-value">'. htmlspecialchars($caixa->getAssunto()) .'</div>
2283.                             
2284.                                             <div class="box-label">RESPONSÁVEL:</div>
2285.                                             <div class="box-value">'. htmlspecialchars($caixa->getConteiner()) .'</div>
2286.                             
2287.                                             <div class="box-label">DATA 1º ENVIO:</div>
2288.                                             <div class="box-value">'. htmlspecialchars($dates) .'</div>
2289.                             
2290.                                             <div class="box-label">Conteúdo</div>
2291.                                             <div class="box-value_conteudo" style="font-size: '. $fontSize .'">'. $conteudo .'</div>
2292.                                             
2293.                                             <div class="hr-fixo">
2294.                                                 <hr>
2295.                                                 <div>CXRBM:'. htmlspecialchars($caixa->getNome()) .'</div>
2296.                                             </div>
2297.                             
2298.                                         </div>
2299.         </div>';
2300.                             $docs = [];
2301.                             if ($count % 2 == 0) {
2302.                                 $html .= '<div style="page-break-after: always;"></div>';
2303.                             }
2304.                         }
2305.                
2307.                         $html .= '</div></body></html>';
2308.                 }
2309.                         
2310.                
2311.                
2312.                 // Configurar o Dompdf
2313.                 $options = new Options();
2314.                 $options->set('isHtml5ParserEnabled', true);
2315.                 $options->set('isPhpEnabled', true);
2316.                 $options->set('isRemoteEnabled', true);
2317.                 $dompdf = new Dompdf($options);
2318.                 $dompdf->loadHtml($html);
2319.                 $dompdf->setPaper('A4', 'landscape');
2320.         
2321.                 // LIMPA TODOS OS BUFFERS ANTES DE RENDERIZAR
2322.                 while (ob_get_level()) {
2323.                     ob_end_clean();
2324.                 }
2325.         
2326.                 // Tenta renderizar e, em vez de stream() direto, grava em arquivo temporário e envia
2327.                 try {
2328.                     $dompdf->render();
2329.                 } catch (Throwable $e) {
2330.                     // registra o erro e lança para cair no catch externo
2331.                     error_log('Dompdf render failed: ' . $e->getMessage());
2332.                     throw $e;
2333.                 }
2334.         
2335.                 // Gera arquivo temporário seguro
2336.                 $tempFile = sys_get_temp_dir() . DIRECTORY_SEPARATOR . 'etiqueta_fluxo_' . $id_fluxo . '_' . uniqid() . '.pdf';
2337.                 $output = $dompdf->output();
2338.         
2339.                 if (file_put_contents($tempFile, $output) === false) {
2340.                     throw new Exception('Falha ao escrever arquivo temporário do PDF.');
2341.                 }
2342.         
2343.                 // Força headers corretos para download/visualização
2344.                 header('Content-Type: application/pdf');
2345.                 // Se quiser forçar download use attachment; se quiser abrir no browser use inline
2346.                 header('Content-Disposition: inline; filename="Etiqueta_Fluxo_' . preg_replace('/[^A-Za-z0-9_\-\.]/', '_', $id_fluxo . '_' . $nome_fluxo) . '.pdf"');
2347.                 header('Content-Length: ' . filesize($tempFile));
2348.                 header('Cache-Control: private, max-age=0, must-revalidate');
2349.         
2350.                 // Envia o arquivo binário ao navegador
2351.                 readfile($tempFile);
2352.         
2353.                 // Remove o arquivo temporário com segurança
2354.                 @unlink($tempFile);
2355.         
2356.                 // finaliza execução
2357.                 exit;
2358.         
2359.                 
2360.             } catch (Exception $e) {
2361.                 // Loga para diagnóstico e mostra mensagem amigável
2362.                 error_log('Erro ao gerar o PDF: ' . $e->getMessage());
2363.                 echo 'Erro ao gerar o PDF: ' . htmlspecialchars($e->getMessage());
2364.             }
2365.         
2366.         
2368. }
2370.         
2371.         if (isset($_POST["qrcode"])) {
2372.                 $id_fluxo = $_POST["qrcode"];
2373.                 $fluxo_qrcode = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($_POST["qrcode"]);
2374.                 $nome_fluxo = $fluxo_qrcode->getNome();
2375.                 $fluxo_caixas_qrcode = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_qrcode->getId());
2376.                 $clienteAll_id = $fluxo_qrcode->getCliente()->getId();
2377.                 
2378.                 if ($fluxo_caixas_qrcode != null ) {
2379.                     $options = new Options();
2380.                     $options->set('isHtml5ParserEnabled', true);
2381.                     $options->set('isPhpEnabled', true);
2382.                     $dompdf = new Dompdf($options);
2383.                             
2384.                     $html = '
2385.                         <html>
2386.                             <head>
2387.                                 <style>
2388.                                     @page {
2389.                                         margin: 35px 18.9px 0px 18.9px;
2390.                                         size: 210mm 297mm; /* Ajuste de tamanho do papel */
2391.                                     }
2392.                                     body {
2393.                                         margin: 0;
2394.                                         padding: 0;
2395.                                     }
2396.                                     .qr-item {
2397.                                         border: 2px dotted #000;
2398.                                         text-align: center;
2399.                                         width: 32.27mm;
2400.                                         height: 34.9mm; 
2401.                                         display: inline-block;
2402.                                     }
2403.                         
2404.                                     .qr-item img {
2405.                                         width: 115px; 
2406.                                         height: 112px;
2407.                                     }
2408.                                     .qr-title {
2409.                                         font-size: 16px;
2410.                                         font-weight: bold;
2411.                                     }
2412.                                     .leo {
2413.                                         display: flex;
2414.                                         flex-wrap: wrap;
2415.                                     }
2416.                                 </style>
2417.                             </head>
2418.                             <body>';
2419.             
2420.                     $count = 0; // Contador de QR Codes
2421.             
2422.                     foreach ($fluxo_caixas_qrcode as $cx) {
2423.                         $id_cx_ultimo = $cx->getCx();
2424.             
2425.                         if ($id_cx_ultimo !== null) {
2426.                             $nome = $id_cx_ultimo->getNome();
2427.             
2428.                             // Gerar QR Code com imagem no centro
2429.                             $result = Builder::create()
2430.                                 ->writer(new PngWriter())
2431.                                 ->writerOptions([])
2432.                                 ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$nome)
2433.                                 ->encoding(new Encoding('UTF-8'))
2434.                                 ->size(500)
2435.                                 ->margin(5)
2436.                                 ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
2437.                                 ->build();
2438.                             
2439.                             // Salvar QR Code como arquivo temporário
2440.                             $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
2441.                             $result->saveToFile($tempFile);
2442.             
2443.                             // Adicionar QR Code ao HTML
2444.                             if ($count % 48 == 0) {
2445.                                 $html .= '<div class="leo">';
2446.                             }
2447.             
2448.                             $html .= '<div class="qr-item">';
2449.                             $html .= '<div class="qr-title">' . $nome . '</div>';
2450.                             $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
2451.                             $html .= '</div>';
2452.             
2453.                             $count++;
2454.             
2455.                             // Fechar a div e inserir quebra de página a cada 63 QR Codes
2456.                             if ($count % 48 == 0) {
2457.                                 $html .= '</div><div style="page-break-after: always;"></div>';
2458.                             }
2459.                         }
2460.                     }
2461.             
2462.                     // Fechar qualquer div aberta sem completar 63 itens
2463.                     if ($count % 48 != 0) {
2464.                         $html .= '</div>';
2465.                     }
2466.             
2467.                     $html .= '</body></html>';
2468.             
2469.                     // Carregar o HTML e gerar o PDF
2470.                     $dompdf->loadHtml($html);
2471.                     $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
2472.                     $dompdf->render();
2473.                     $dompdf->stream("Qrcode_" . $id_fluxo . "_" . $nome_fluxo . ".pdf", ["Attachment" => 1 ]);
2474.                 } else {
2475.                     echo "<script>alert('ERROR, ESSE FLUXO NÃO TEM SETOR DE GUARDA!');</script>";
2476.                 }
2477.             }
2478.         
2479.         if (isset($_POST["container"])) {
2481.             $id_fluxo = $_POST["container"];
2482.             $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($id_fluxo);
2483.             $fluxo_container = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($id_fluxo);
2484.             $clienteAll_id = $fluxo_container->getCliente()->getId();
2485.             $containers = [];
2486.         
2487.             foreach ($fluxo_caixas as $caixa) {
2489.                 $documentos = $caixa->getDocumentos();
2490.         
2491.                 foreach ($documentos as $documento) {
2492.                     $container = $documento->getConteiner(); 
2493.                     $caixaId = $documento->getCaixa()->getId(); 
2494.                     
2495.                     if ($container != null and $caixaId != null) {
2496.                         
2497.                         if (!isset($containers[$container])) {
2498.                             $containers[$container] = [];
2499.                         }
2500.         
2501.                         if (!in_array($caixaId, $containers[$container])) {
2502.                             $containers[$container][] = $caixaId;
2503.                         }
2504.                     }
2505.                 }
2506.             }
2507.             
2509.             $options = new Options();
2510.             $options->set('isHtml5ParserEnabled', true);
2511.             $options->set('isPhpEnabled', true);
2512.             $dompdf = new Dompdf($options);
2513.                     
2514.             $html = '
2516.                 <html>
2517.                     <head>
2518.                         <style>
2519.                             @page {
2520.                                 margin: 35px 18.9px 0px 18.9px;
2521.                                 size: 210mm 297mm; /* Ajuste de tamanho do papel */
2522.                             }
2523.                             body {
2524.                                 margin: 0;
2525.                                 padding: 0;
2526.                             }
2527.                             .qr-item {
2528.                                 border: 2px dotted #000;
2529.                                 width: 200mm;
2530.                                 height: 80mm;
2531.                                 margin-top:15px; 
2532.                                 text-align: center;
2533.                                
2534.                                 
2535.                             }
2537.                              .img_qrcode h2{                           
2538.                                position:relative;
2539.                                top:25px;
2540.                             }
2542.                             .img_qrcode h3{                           
2543.                                position:relative;
2544.                                bottom:25px;
2545.                                font-size: 20px;
2546.                             }
2548.                             .img_qrcode{
2549.                                
2550.                                 display: inline-block;
2551.                                 margin: 5px  30px 5px 30px;
2552.                                
2553.                                
2554.                             }
2555.                 
2556.                             .qr-item img {
2557.                                 
2558.                                 width: 170px; 
2559.                                 height: 170px;
2560.                                 
2561.                             }
2562.                             .qr-title {
2563.                                 font-size: 70px;
2564.                                 font-weight: bold;
2565.                                
2567.                             }
2568.                             .leo {
2569.                                 display: flex;
2570.                                 flex-wrap: wrap;
2571.                             }
2572.                         </style>
2573.                     </head>
2574.                     <body>';
2575.     
2576.             $count = 0; // Contador de QR Codes
2580.             // Exibir resultado
2581.             foreach ($containers as $container => $caixas) {
2583.                 #echo "Container $container => " . implode(", ", $caixas) . "<br>";
2585.                 
2587.                
2588.                 if ($count % 3 == 0) {
2589.                     $html .= '<div class="leo">';
2590.                 }
2592.                 $html .= '<div class="qr-item">';
2593.                 $html .= '<div class="qr-title">' . $container . '</div><hr>';
2596.                 foreach($caixas as $caixa ){
2597.                     $caix = $doctrine->getRepository(Caixa::class)->find($caixa);
2598.                     $caix_nome =$caix->getNome();
2599.                     $caix_cx =$caix->getCx()->getNome();
2600.                     $result = Builder::create()
2601.                     ->writer(new PngWriter())
2602.                     ->writerOptions([])
2603.                     ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$caix_cx)
2604.                     ->encoding(new Encoding('UTF-8'))
2605.                     ->size(350)
2606.                     ->margin(5)
2607.                     ->logoPath(__DIR__ . '/logo.png') 
2608.                     ->build();
2609.                 
2610.                 
2611.                     $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
2612.                     $result->saveToFile($tempFile);
2613.                     
2614.                     $html .= '
2615.                         <div class="img_qrcode">    
2616.                             <h2>'.$caix_cx.'</h2>
2617.                             <img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">
2618.                             <h3>'.$caix_nome.'</h3>
2619.                         </div>
2620.                     
2621.                     ';
2622.                 }
2623.                 $html .= '</div>';
2625.                 $count++;
2627.                 
2628.                 if ($count % 3 == 0) {
2629.                     $html .= '</div><div style="page-break-after: always;"></div>';
2630.                 }
2631.             }
2634.               // Fechar qualquer div aberta sem completar 63 itens
2635.               if ($count % 3 != 0) {
2636.                 $html .= '</div>';
2637.             }
2638.     
2639.             $html .= '</body></html>';
2640.     
2641.             // Carregar o HTML e gerar o PDF
2642.             $dompdf->loadHtml($html);
2643.             $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
2644.             $dompdf->render();
2645.             $dompdf->stream("Qrcode.pdf", ["Attachment" => 1 ]);
2646.             
2650.         }
2651.         
2652.         if (isset($_POST["pasta"])) {
2653.             
2654.                 // reforça limites (pode ajustar conforme necessário)
2655.                 ini_set('max_execution_time', 500);
2656.                 ini_set('memory_limit', '3512M');
2657.         
2658.                 $id_fluxo = $_POST["pasta"];
2659.                 $fluxo_pdf = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($id_fluxo);
2660.                 $cliente_id = $fluxo_pdf->getCliente()->getId();
2661.                 $cliente = $doctrine->getRepository(Cliente::class)->findWithRelations($cliente_id);
2662.                 $nome_fluxo = $fluxo_pdf->getNome();
2663.                 $clienteAll_fluxo = $cliente->getClienteAll()->getLogo();
2664.                 
2665.                 $cmd = $clientS3->getCommand('GetObject', [
2666.                 'Bucket' => 'arquivosdoc',
2667.                 'Key'    => 'LOGO_CLIENTES/'. $clienteAll_fluxo, 
2668.                 ]);
2669.                 
2670.                 $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
2671.                 $cliente_all_Url = (string) $req->getUri();
2672.                 
2673.                 $clienteAll_fluxo_id = $cliente->getClienteAll()->getId();
2674.                 $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_pdf->getId());
2676.                  $html = '
2677.                         <!DOCTYPE html>
2678.                         <html lang="pt-BR">
2679.                         <head>
2680.                             <meta charset="UTF-8">
2681.                             <meta name="viewport" content="width=device-width, initial-scale=1.0">
2682.                             <title>FLUXO</title>
2683.                             <style>
2684.                                 * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
2685.                                 body { text-transform: uppercase; }
2686.                                 .filho { border: 2px solid black; width: 50mm; height: 144mm; display: inline-block; margin: 2px; position: relative;}
2687.                                 h2 { text-align: center; font-size: 20px; padding: 5px; }
2688.                                 h2 img{width: 250px; height: 250px;}
2689.                                 h4 { text-align: center; font-size: 12px; padding: 10px; }
2690.                                 h5 { text-align: center; font-size: 14px;}
2691.                                 h6 { text-align: center; font-size: 14px; padding: 5px; }
2692.                                 h5 img { text-align: center;max-height: 40px;width:auto;max-width: 40px}
2693.                                 h6 img { text-align: center;margin:auto;  max-height: 130px;width:auto;max-width: 130px}
2694.                                 p { text-align: center; font-size: 8px; font-weight: bold;}
2695.                                 .pai { position: relative; top: 11%; }
2696.                                 hr { color: black; }
2697.                                 .lis2{
2698.                                     
2699.                                     font-weight: bold;
2700.                                 }
2701.                                 .lis3 {
2702.                                     position: absolute;
2703.                                     bottom: 0;
2704.                                     width: 100%;
2705.                                     font-weight: bold;
2706.                                     text-align: center;
2707.                                     margin-bottom:5px;
2708.                                     margin-top:5px;
2709.                                        
2710.                                 }
2711.                                 .lis{
2712.                                     
2713.                                     margin-left:10px;
2714.                                     font-weight: bold;
2715.                                 }
2716.                                 li{
2717.                                    font-size: 12px;
2718.                                    margin-left:2px;
2719.                                 }
2720.                                 
2721.                             </style>
2722.                         </head>
2723.                         <body>
2724.                         <div class="pai">';
2725.         
2726.                 $count = 0;
2727.         
2728.                 
2729.                         foreach ($fluxo_caixas as $caixa) {
2730.                             $count++;
2731.                             $documento_fluxo = $caixa->getDocumentos()->toArray();
2732.                             
2733.                 
2734.                             $html .= '<div class="filho">
2735.                                 
2736.                                 
2737.                                 <h6><img src="'.$cliente_all_Url.'" class="img"></h6>
2738.                                 <hr>
2739.                                 <h2>' . htmlspecialchars($caixa->getNome()) . '</h2>
2740.                                 <hr>
2741.                                 ';
2742.                 
2743.                             $docs = [];
2744.                             
2745.                             if (!empty($documento_fluxo)) {
2746.                                 foreach ($documento_fluxo as $doc) {
2747.                                     if($doc->getTipo() != NULL ){
2748.                                         if ($cliente_id != 122) {
2749.                                             $docs[] = $doc->getTipo()->getNome();
2750.                                         } else {
2751.                                             $docs[] = $doc->getNome();
2752.                                         }
2753.                                     }
2754.                                 }
2755.                                 $docs = array_unique($docs);
2756.                             }
2757.                             
2758.                             
2761.                             $docs_class = [];
2762.                             
2763.                             if (!empty($documento_fluxo)) {
2764.                                 foreach ($documento_fluxo as $doc) {
2765.                                     
2766.                                     if($doc->getClassificacao() != NULL ){
2767.                                        $clss =  $entityManager->getRepository(Classificacao::class)->findBy(['id' => $doc->getClassificacao()->getId()]);
2768.                                        $class_nome =  $clss[0]->getNome();
2769.                                        $docs_class[] = $class_nome;
2770.                                         
2771.                                     }
2772.                                 }
2773.                                 $docs_class = array_unique($docs_class);
2774.                             }
2775.                 
2777.                               $docs_data = [];
2778.                               if (!empty($documento_fluxo)) {
2779.                                     foreach ($documento_fluxo as $data) {
2780.                                         if ($data->getAssunto() !== null) {
2781.                                             $docs_data[] = $data->getAssunto();
2782.                                         }
2783.                                     }
2784.                                     $docs_data = array_unique($docs_data);
2785.                                 }
2786.                             
2787.                           
2789.                             
2792.                                                         
2793.                             
2794.                             
2795.                             $html .= '<h6>' . htmlspecialchars(implode(', ', $docs)) . '</h6>
2796.                                 <hr>';
2797.                                
2800.                                 $html .= '<h6>Conteúdo:</h6>';
2802.                                 $html .= '<div class="lis">';
2803.                                 foreach ($docs_class as $classs_nome) {
2804.                                 if($classs_nome == '028.11-COM ÔNUS'){
2805.                                  $html .= '<li>SOLICITAÇÃO DE DIÁRIAS</li>';
2806.                                 }
2807.                                 $html .= '
2808.                                     <li>' . $classs_nome. '</li>';
2809.                                 }
2810.                                 $html .= '</div><br>';
2811.                                 $html .= '<h6>Descrição:</h6>';
2812.                                 $html .= '<div class="lis">';
2813.                                 $len = count($docs_data);
2814.                                 foreach ($docs_data as $assunto_nome) {
2815.                                     
2816.                                 $qtd_letra = mb_strlen($assunto_nome, 'UTF-8');
2817.                                  
2818.                                 if ($len <= 20) {
2819.                                     $fontSize = 12;
2820.                                 } 
2821.                                 
2822.                                 else{
2823.                                     $fontSize = 9;
2824.                                 }
2825.                                 if($qtd_letra > 25 ){
2826.                                     $fontSize = 10;
2827.                                 }
2828.                                 $html .= '<li style="font-size: ' . $fontSize . 'px;">' . $assunto_nome. '</li>';
2829.                                 }
2830.                                 $html .= '</div><br>
2831.                                 <div class="lis3"><hr>
2832.                                 
2833.                                 <p>ARQUIVOS GESTÃO DOCUMENTAL</p>
2834.                                 <h5><img src="https://index.arquivosdoc.com.br/img/logo_menu.png" class="img"></h5>
2835.                                 </div>
2836.                                 
2837.                             </div>';
2838.                 
2839.                             #if ($count == 4) {
2840.                              #   $html .= '<div style="page-break-after: always;"></div>';
2841.                             #}
2842.                         }
2843.                
2845.                 
2846.                 
2847.         
2849.                 $html .= '</div></body></html>';
2850.         
2851.   
2852.                         
2853.                
2854.                
2855.                 // Configurar o Dompdf
2856.                 $options = new Options();
2857.                 $options->set('isHtml5ParserEnabled', true);
2858.                 $options->set('isPhpEnabled', true);
2859.                 $options->set('isRemoteEnabled', true);
2860.                 $dompdf = new Dompdf($options);
2861.                 $dompdf->loadHtml($html);
2862.                 $dompdf->setPaper('A4', 'portrait');
2863.         
2864.                 // LIMPA TODOS OS BUFFERS ANTES DE RENDERIZAR
2865.                 while (ob_get_level()) {
2866.                     ob_end_clean();
2867.                 }
2868.         
2869.                 // Tenta renderizar e, em vez de stream() direto, grava em arquivo temporário e envia
2870.                 try {
2871.                     $dompdf->render();
2872.                 } catch (Throwable $e) {
2873.                     // registra o erro e lança para cair no catch externo
2874.                     error_log('Dompdf render failed: ' . $e->getMessage());
2875.                     throw $e;
2876.                 }
2877.         
2878.                 // Gera arquivo temporário seguro
2879.                 $tempFile = sys_get_temp_dir() . DIRECTORY_SEPARATOR . 'etiqueta_fluxo_' . $id_fluxo . '_' . uniqid() . '.pdf';
2880.                 $output = $dompdf->output();
2881.         
2882.                 if (file_put_contents($tempFile, $output) === false) {
2883.                     throw new Exception('Falha ao escrever arquivo temporário do PDF.');
2884.                 }
2885.         
2886.                 // Força headers corretos para download/visualização
2887.                 header('Content-Type: application/pdf');
2888.                 // Se quiser forçar download use attachment; se quiser abrir no browser use inline
2889.                 header('Content-Disposition: inline; filename="Etiqueta_Fluxo_' . preg_replace('/[^A-Za-z0-9_\-\.]/', '_', $id_fluxo . '_' . $nome_fluxo) . '.pdf"');
2890.                 header('Content-Length: ' . filesize($tempFile));
2891.                 header('Cache-Control: private, max-age=0, must-revalidate');
2892.         
2893.                 // Envia o arquivo binário ao navegador
2894.                 readfile($tempFile);
2895.         
2896.                 // Remove o arquivo temporário com segurança
2897.                 @unlink($tempFile);
2898.         
2899.                 // finaliza execução
2900.                 exit;
2901.         
2902.                 
2903.        
2904.         
2905.         }
2906.        
2907.         
2908.        
2909.        
2910.         return $this->render('index/index5.html.twig', [
2911.     
2912.             'fluxos' => $fluxos,
2913.             'p'=>$p,
2914.             'erro'=>$erro,
2915.             'pagina' => $pagina,
2916.             'a' => $a,
2917.              
2919.         ]);
2920.     }
2921.     
2922.     
2923.     #[Route('/index/fluxo/diagrama/{id}', name: 'diagrama')]
2924.     public function diagrama( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer,$id): Response
2925.     {
2926.         $user_logado = $this->getUser();
2927.         $erro = '';
2928.         $pagina = 'fluxo';
2929.         $p ='';
2932.         $clienteId = $session->get('cliente_id');
2933.         
2934.         if($clienteId == null){
2935.             
2936.             return $this->redirectToRoute('home');
2937.         }
2938.         
2939.         $fluxo_diagrama = $doctrine->getRepository(Fluxo::class)->find($id);
2940.         $fluxo_caixas_diagrama = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_diagrama->getId());
2941.             
2942.  
2943.     
2944.         return $this->render('index/diagrama.html.twig', [
2945.     
2946.             'p'=>$p,
2947.             'erro'=>$erro,
2948.             'pagina' => $pagina,
2949.             "fluxo_diagrama" => $fluxo_diagrama,
2950.             "fluxo_caixas_diagrama" => $fluxo_caixas_diagrama
2951.              
2953.         ]);
2954.     }
2956.     #[Route('/index/recebimento/{id}', name: 'recebimento')]
2957.     public function recebimento( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer,$id): Response
2958.     {
2959.         $user_logado = $this->getUser();
2960.         $user_nome = $user_logado->getNome();
2961.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
2962.         $erro = '';
2963.         $pagina = 'home';
2964.         $p ='';
2965.         $ged = ""; 
2966.         $log = "";
2967.         $caixa_manual = "";
2968.         $caixa_auto = "";
2969.         $cx_ultimo = $doctrine->getRepository(Cx::class)->findUltimo();
2970.         $etapa = $doctrine->getRepository(Etapa::class)->findWithAllRelations($id);
2971.         $fluxo = $etapa->getFluxo();
2972.         $cliente_fluxo = $fluxo->getCliente()->getId();
2973.         $clienteId = $session->get('cliente_id');
2974.         $cliente = $doctrine->getRepository(Cliente::class)->findWithRelations($cliente_fluxo);
2975.         $clienteAll =  $cliente->getClienteAll();
2976.         $cliente_nome =  $cliente->getNome();
2977.         $clienteAll_id =  $clienteAll->getId();
2978.         $count = 0; // Contador de QR Codes
2979.         $id_cx_ultimo = 0;
2980.         $date_hoje = new \DateTimeImmutable('America/Sao_Paulo');
2981.         
2982.         $caixas_setor = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($cliente_fluxo);
2983.         
2984.         $query = $entityManager->createQuery("
2985.             SELECT c FROM App\Entity\Cx c
2986.             LEFT JOIN c.caixas cx
2987.             WHERE c.cliente = :clienteId
2988.             AND cx.id IS NULL
2989.         ");
2991.         $query->setParameter('clienteId', $clienteAll_id);
2992.         $cx_setor = $query->getResult();
2994.         foreach ($cx_ultimo as $key_id) {
2995.             
2996.             $id_cx_ultimo = $key_id->getNome();
2997.         }
2998.         
3000.         if(isset($_POST["btn_cliente"])){
3001.             
3002.             $session->set('cliente_id', $_POST["btn_cliente"]);
3003.             return $this->redirectToRoute('home');
3004.         }
3005.         
3006.         if($clienteId == null){
3007.             
3008.             return $this->redirectToRoute('home');
3009.         }
3010.         
3012.         if ($request->isMethod('POST')) {
3013.             
3014.           
3015.             
3016.             if(isset($_POST["tipo"])){
3017.                  $tp = $_POST["tipo"];
3018.                
3019.                if($tp =='caixa'){
3020.                    
3021.                     if($_POST["qtd_caixa"] != ""){
3022.     
3023.     
3024.                         if (isset($_POST["ged"]) || isset($_POST["log"])) {
3025.     
3026.                                 if (isset($_POST["ged"])) {
3027.                                     
3028.                                     $ged = "ok";
3029.     
3030.                                     if (isset($_POST["caixa_manual"]) || isset($_POST["caixa_auto"])) {
3031.     
3032.                                         if (isset($_POST["caixa_manual"])) {
3033.     
3034.                                             $caixa_manual = "ok";
3035.             
3036.                                         }
3037.                                         if (isset($_POST["caixa_auto"])) {
3038.     
3039.                                             $caixa_auto = "ok";
3040.             
3041.                                         }
3042.     
3043.                                     }else{
3044.                                         echo "<script>alert('ERROR , Selecione o modo de Identificação do ArquivosGED (Manual ou Automático)!');</script>";
3045.                                     }
3046.             
3047.                                 }
3048.     
3049.     
3050.     
3051.                                 if (isset($_POST["log"])) {
3052.     
3053.                                     $log = "ok";
3054.                                     
3055.     
3056.                                 }
3057.     
3058.                                 if ($ged == "ok" and $caixa_manual =="ok") {
3059.     
3060.                                     $caixa = $_POST["caixa"];
3061.                                     $qtd_caixas = 0;
3062.     
3063.     
3064.                                     $options = new Options();
3065.                                     $options->set('isHtml5ParserEnabled', true);
3066.                                     $options->set('isPhpEnabled', true);
3067.                                     $dompdf = new Dompdf($options);
3068.                         
3069.                                     $html = '
3070.                                     <html>
3071.                                         <head>
3072.                                             <style>
3073.                                                 @page {
3074.                                                     margin: 35px 18.9px 0px 18.9px;
3075.                                                     size: 210mm 297mm; /* Ajuste de tamanho do papel */
3076.                                                 }
3077.                         
3078.                                                 body {
3079.                                                     margin: 0;
3080.                                                     padding: 0;
3081.                                                 }
3082.                                                 
3083.                                                 .qr-item {
3084.                                                     border: 2px dotted #000;
3085.                                                     text-align: center;
3086.                                                     width: 32.27mm;
3087.                                                     height: 34.9mm; 
3088.                                                     display: inline-block;
3089.                                                 }
3090.                                     
3091.                                                 .qr-item img {
3092.                                                     width: 115px; 
3093.                                                     height: 112px;
3094.                                                 }
3095.                         
3096.                                                 .qr-title {
3097.                                                     font-size: 16px;
3098.                                                     font-weight: bold;
3099.                                                 }
3100.                         
3101.                                                 .leo {
3102.                                                     display: flex;
3103.                                                     flex-wrap: wrap;
3104.                                                 }
3105.                                             </style>
3106.                                         </head>
3107.                                         <body> 
3108.                                       
3109.                                     ';
3110.                         
3111.                         
3112.                                     
3113.                                     foreach ($caixa as $key) {
3114.     
3115.                                         if ($key != "" ) {
3116.                                             $qtd_caixas ++ ;
3117.                                             $caixas = new Caixa();
3118.                                            
3119.                                            
3120.                                             if ($ged == "ok" and $log =="ok") {
3121.                                                 
3122.                                                 $cx = new Cx();
3123.                                                 $id_cx_ultimo ++;
3124.                                                 $cx->setNome($id_cx_ultimo);
3125.                                                 $cx->setStatus(2);
3126.                                                 $cx->setTexto($key);
3127.                                                 $cx->setImage('ArquivosGED');
3128.                                                 $cx->setCliente($clienteAll);
3129.                                                 $entityManager->persist($cx);
3130.                                                 $entityManager->flush();
3131.     
3132.                                                 $id_cx=$cx->getId();
3133.                                                 $caixas->setCx($entityManager->getRepository(Cx::class)->find($id_cx));
3134.     
3135.                                                 // Gerar QR Code com imagem no centro
3136.                                                 $result = Builder::create()
3137.                                                 ->writer(new PngWriter())
3138.                                                 ->writerOptions([])
3139.                                                 ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$id_cx_ultimo)
3140.                                                 ->encoding(new Encoding('UTF-8'))
3141.                                                 ->size(500)
3142.                                                 ->margin(5)
3143.                                                 ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
3144.                                                 ->build();
3145.                                                 // Salvar QR Code como arquivo temporário
3146.                                                 $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
3147.                                                 $result->saveToFile($tempFile);
3148.                                                 
3149.                                                 // Adicionar QR Code ao HTML
3150.                                                 if ($count % 48 == 0) {
3151.                                                     $html .= '<div class="leo">';
3152.                                                 }
3153.                                 
3154.                                                 // Adicionar QR Code ao HTML
3155.                                                 $html .= '<div class="qr-item">';
3156.                                                 $html .= '<div class="qr-title">' . $id_cx_ultimo . '</div>';
3157.                                                 $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
3158.                                                 $html .= '</div>';
3159.                                                 
3160.                                                 
3161.                                                  $count++;
3162.     
3163.                                                // Fechar a div e inserir quebra de página a cada 63 QR Codes
3164.                                                if ($count % 48 == 0) {
3165.                                                    $html .= '</div><div style="page-break-after: always;"></div>';
3166.                                                }
3167.                                                 
3168.                                             }
3169.     
3170.                                             
3171.                                             $caixas->setNome($key);
3172.                                             $caixas->addCliente($cliente);
3173.                                             $caixas->setFluxo($fluxo);
3174.                                             $entityManager->persist($caixas);
3175.                                             $entityManager->flush();
3176.                                             $id_caixa = $caixas->getId();
3177.                                             
3178.                                                 
3179.                                         }
3180.                                     }
3181.                                         if ($ged == "ok" and $log =="ok") {
3182.                                             
3183.                                               // Fechar qualquer div aberta sem completar 63 itens
3184.                                              if ($count % 48 != 0) {
3185.                                                 $html .= '</div>';
3186.                                             }
3187.     
3188.                                             $html .= '</div></body></html>';
3189.                                 
3190.                                             // Carregar o HTML e gerar o PDF
3191.                                             $dompdf->loadHtml($html);
3192.                                             $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
3193.                                             $dompdf->render();
3194.                                             #file_put_contents('sample1.pdf', $dompdf->output());
3195.                                             $dompdf->stream('dompdf', array('Attachment' => 0));
3196.                                         }
3197.     
3198.                                             $registro = new Registro();
3199.                                             $registro->setOperacao('RECEBIMENTO DE '.$qtd_caixas. ' CAIXA(S)'); 
3200.                                             $registro->setUser($user_nome);
3201.                                             $registro->setCliente($cliente_nome);
3202.                                             $registro->setIp($ip_cliente);
3203.                                             $entityManager->persist($registro);
3204.                                             $entityManager->flush();
3205.     
3206.                                             $etapa->setRegistro($registro);
3207.                                             $etapa->setObs($_POST["obs_caixa"]);
3208.                                             $etapa->setUpdatedAt($date_hoje);
3209.                                             $entityManager->flush();
3210.                                             $erro = 'ok';
3211.                                             $p = "Recbimento com sucesso";
3212.                                     
3213.     
3214.                                 }
3215.     
3216.                                 if ($ged == "ok" and $caixa_auto =="ok") {
3217.     
3218.                                     
3219.                                     if (isset($_POST["auto_ged"])) {
3220.     
3221.                                         $qtd_nome_caixa = $_POST["qtd_caixa"];
3222.                                         $nome_caixa_parti = $_POST["auto_ged"];
3223.                                         
3224.     
3225.     
3226.     
3227.                                         $options = new Options();
3228.                                         $options->set('isHtml5ParserEnabled', true);
3229.                                         $options->set('isPhpEnabled', true);
3230.                                         $dompdf = new Dompdf($options);
3231.                             
3232.                                         $html = '
3233.                                         <html>
3234.                                             <head>
3235.                                                 <style>
3236.                                                     @page {
3237.                                                         margin: 35px 18.9px 0px 18.9px;
3238.                                                         size: 210mm 297mm; /* Ajuste de tamanho do papel */
3239.                                                     }
3240.                             
3241.                                                     body {
3242.                                                         margin: 0;
3243.                                                         padding: 0;
3244.                                                     }
3245.                                                     
3246.                                                    .qr-item {
3247.                                                     border: 2px dotted #000;
3248.                                                     text-align: center;
3249.                                                     width: 32.27mm;
3250.                                                     height: 34.9mm; 
3251.                                                     display: inline-block;
3252.                                                 }
3253.                                     
3254.                                                 .qr-item img {
3255.                                                     width: 115px; 
3256.                                                     height: 112px;
3257.                                                 }
3258.                                     
3259.                                                     .qr-title {
3260.                                                         font-size: 16px;
3261.                                                         font-weight: bold;
3262.                                                     }
3263.                             
3264.                                                     .leo {
3265.                                                         display: flex;
3266.                                                         flex-wrap: wrap;
3267.                                                     }
3268.                                                 </style>
3269.                                             </head>
3270.                                             <body> 
3271.                                               
3272.                                         ';
3273.                         
3274.                         
3275.     
3276.     
3277.                                         for ($i=0; $i < $qtd_nome_caixa; $i++) { 
3278.                                             
3279.                                             $caixas = new Caixa();
3280.     
3281.                                             if ($ged == "ok" and $log =="ok") {
3282.                                                 
3283.                                                 $cx = new Cx();
3284.                                                 $id_cx_ultimo ++;
3285.                                                 $cx->setNome($id_cx_ultimo);
3286.                                                 $cx->setStatus(2);
3287.                                                 $cx->setTexto('Caixa '.$nome_caixa_parti);
3288.                                                 $cx->setImage('ArquivosGED');
3289.                                                 $cx->setCliente($clienteAll);
3290.                                                 $entityManager->persist($cx);
3291.                                                 $entityManager->flush();
3292.     
3293.                                                 $id_cx=$cx->getId();
3294.                                                 $caixas->setCx($entityManager->getRepository(Cx::class)->find($id_cx));
3295.     
3296.                                                   // Gerar QR Code com imagem no centro
3297.                                                 $result = Builder::create()
3298.                                                   ->writer(new PngWriter())
3299.                                                   ->writerOptions([])
3300.                                                   ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$id_cx_ultimo)
3301.                                                   ->encoding(new Encoding('UTF-8'))
3302.                                                   ->size(500)
3303.                                                   ->margin(5)
3304.                                                   ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
3305.                                                   ->build();
3306.                                                   // Salvar QR Code como arquivo temporário
3307.                                                   $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
3308.                                                   $result->saveToFile($tempFile);
3309.                                                     
3310.                                                 // Adicionar QR Code ao HTML
3311.                                                     if ($count % 48 == 0) {
3312.                                                         $html .= '<div class="leo">';
3313.                                                     }    
3314.                                                     
3315.                                                   // Adicionar QR Code ao HTML
3316.                                                   $html .= '<div class="qr-item">';
3317.                                                   $html .= '<div class="qr-title">' . $id_cx_ultimo . '</div>';
3318.                                                   $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
3319.                                                   $html .= '</div>';
3320.                                                   
3321.                                                    $count++;
3322.                                         
3323.                                                    // Fechar a div e inserir quebra de página a cada 63 QR Codes
3324.                                                    if ($count % 48 == 0) {
3325.                                                        $html .= '</div><div style="page-break-after: always;"></div>';
3326.                                                    }
3327.                                                 
3328.                                             }
3329.     
3330.     
3331.                                             $caixas->setNome('Caixa '.$nome_caixa_parti);
3332.                                             $caixas->addCliente($cliente);
3333.                                             $caixas->setFluxo($fluxo);
3334.                                             $entityManager->persist($caixas);
3335.                                             $entityManager->flush();
3336.                                             $nome_caixa_parti++;
3337.                                             
3338.     
3339.                                         }
3340.     
3341.                                         if ($ged == "ok" and $log =="ok") {
3342.                                     
3343.                                              // Fechar qualquer div aberta sem completar 63 itens
3344.                                              if ($count % 48 != 0) {
3345.                                                 $html .= '</div>';
3346.                                             }
3347.                                             
3348.                                             $html .= '</div></body></html>';
3349.                                     
3350.                                             // Carregar o HTML e gerar o PDF
3351.                                             $dompdf->loadHtml($html);
3352.                                             $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
3353.                                             $dompdf->render();
3354.                                             #file_put_contents('sample1.pdf', $dompdf->output());
3355.                                             $dompdf->stream('dompdf', array('Attachment' => 0));
3356.                                         }    
3357.     
3358.                                         $registro = new Registro();
3359.                                         $registro->setOperacao('RECEBIMENTO DE '.$qtd_nome_caixa. ' CAIXA(S)'); 
3360.                                         $registro->setUser($user_nome);
3361.                                         $registro->setCliente($cliente_nome);
3362.                                         $registro->setIp($ip_cliente);
3363.                                         $entityManager->persist($registro);
3364.                                         $entityManager->flush();
3365.                                         
3366.                                         $etapa->setUpdatedAt($date_hoje);
3367.                                         $etapa->setRegistro($registro);
3368.                                         $entityManager->flush();
3369.     
3370.                                         $erro = 'ok';
3371.                                         $p = "Recbimento com sucesso";
3372.                                         
3373.                                     }
3374.     
3375.                                 }
3376.     
3377.     
3378.     
3379.                                 if ($ged != "ok" and $log =="ok") {
3380.                                     
3381.                                     $qtd_caixa_ = $_POST["qtd_caixa"];
3382.                                     $options = new Options();
3383.                                     $options->set('isHtml5ParserEnabled', true);
3384.                                     $options->set('isPhpEnabled', true);
3385.                                     $dompdf = new Dompdf($options);
3386.                             
3387.                                         $html = '
3388.                                         <html>
3389.                                             <head>
3390.                                                 <style>
3391.                                                     @page {
3392.                                                         margin: 35px 18.9px 0px 18.9px;
3393.                                                         size: 210mm 297mm; /* Ajuste de tamanho do papel */
3394.                                                     }
3395.                             
3396.                                                     body {
3397.                                                         margin: 0;
3398.                                                         padding: 0;
3399.                                                     }
3400.                                                     
3401.                                                     .qr-item {
3402.                                                         border: 2px dotted #000;
3403.                                                         text-align: center;
3404.                                                         width: 27.5mm;
3405.                                                         height: 30.5mm; 
3406.                                                         display: inline-block;
3407.                                                     }
3408.                             
3409.                                                     .qr-item img {
3410.                                                         width: 105px; 
3411.                                                         height: 100px;
3412.                                                     }
3413.                             
3414.                                                     .qr-title {
3415.                                                         font-size: 16px;
3416.                                                         font-weight: bold;
3417.                                                     }
3418.                             
3419.                                                     .leo {
3420.                                                         display: flex;
3421.                                                         flex-wrap: wrap;
3422.                                                     }
3423.                                                 </style>
3424.                                             </head>
3425.                                             <body> 
3426.                                                 <div class="leo">    
3427.                                         ';
3428.     
3429.     
3430.     
3431.                                     for ($i=0; $i < $qtd_caixa_; $i++) { 
3432.                                             
3433.                                                 $id_cx_ultimo ++;
3434.                                                 // Gerar QR Code com imagem no centro
3435.                                             $result = Builder::create()
3436.                                                 ->writer(new PngWriter())
3437.                                                 ->writerOptions([])
3438.                                                 ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$id_cx_ultimo)
3439.                                                 ->encoding(new Encoding('UTF-8'))
3440.                                                 ->size(300)
3441.                                                 ->margin(10)
3442.                                                 ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
3443.                                                 ->build();
3444.                                                 // Salvar QR Code como arquivo temporário
3445.                                                 $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
3446.                                                 $result->saveToFile($tempFile);
3447.                                 
3448.                                                 // Adicionar QR Code ao HTML
3449.                                                 $html .= '<div class="qr-item">';
3450.                                                 $html .= '<div class="qr-title">' . $id_cx_ultimo . '</div>';
3451.                                                 $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
3452.                                                 $html .= '</div>';
3453.                                     }
3454.                                     
3455.                                     $html .= '</div></body></html>';
3456.                             
3457.                                     // Carregar o HTML e gerar o PDF
3458.                                     $dompdf->loadHtml($html);
3459.                                     $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
3460.                                     $dompdf->render();
3461.                                     file_put_contents('sample1.pdf', $dompdf->output());
3462.                                     $dompdf->stream('dompdf', array('Attachment' => 1));
3463.     
3464.     
3465.                                     $registro = new Registro();
3466.                                     $registro->setOperacao('RECEBIMENTO DE '.$qtd_caixa_. ' CAIXA(S)'); 
3467.                                     $registro->setUser($user_nome);
3468.                                     $registro->setCliente($cliente_nome);
3469.                                     $registro->setIp($ip_cliente);
3470.                                     $entityManager->persist($registro);
3471.                                     $entityManager->flush();
3472.                                     
3473.                                     $etapa->setUpdatedAt($date_hoje);
3474.                                     $etapa->setRegistro($registro);
3475.                                     $entityManager->flush();
3476.     
3477.                                     $erro = 'ok';
3478.                                     $p = "Recbimento com sucesso";
3479.     
3480.     
3481.                                 }
3482.     
3483.     
3484.     
3485.     
3486.                             } else {
3487.     
3488.                             echo "<script>alert('ERROR , Selecione a Identificação!');</script>";
3489.                         }
3490.                          
3491.                     }else {
3492.                         echo "<script>alert('ERROR , Selecione a Quantidade!');</script>";
3493.                     }
3494.                }
3495.                
3496.                 if($tp =='doc'){
3499.                     if(isset($_POST["check_cx_e"])){
3500.                         $yz = "yes";
3501.                         $checkBoxes = $request->request->all('inputs_cx_e');
3502.                         $xy = 0;
3503.                         $qtd_caixas=0;
3504.                         
3505.       
3506.                         foreach ($checkBoxes as $id => $nome) {
3507.                             $cx_ = $doctrine->getRepository(Cx::class)->find($id);
3508.                             $_nome =  $cx_->getNome();
3509.                            
3510.                             if ($nome =="") {
3511.                                
3512.                                 echo "<script>alert('ERROR, Digite no campo gerado acima da tabela qual será repositorio do  ID: $_nome!');</script>";
3513.                             }
3515.                             if ($nome != "" ) {
3516.                                 $id_cx_ultimo = $_nome ;
3517.                                 $qtd_caixas++;
3518.                                 $xy = 1;
3519.                                 $caixas = new Caixa();
3520.                                 $caixas->setNome($nome);
3521.                                 $caixas->addCliente($cliente);
3522.                                 $caixas->setFluxo($fluxo);
3523.                                 $caixas->setCx($cx_);
3524.                                 $entityManager->persist($caixas);
3525.                                 $entityManager->flush();
3527.                                 $registro = new Registro();
3528.                                 $registro->setOperacao('RECEBIMENTO DA ID EXISTENTE '.$_nome); 
3529.                                 $registro->setUser($user_nome);
3530.                                 $registro->setCliente($cliente_nome);
3531.                                 $registro->setIp($ip_cliente);
3532.                                 $entityManager->persist($registro);
3533.                                 $entityManager->flush();
3535.                                 
3536.                                 
3537.                                 
3538.                             }
3540.                             
3541.                         }
3543.                        
3545.                         if($xy==1){
3547.                             $etapa->setRegistro($registro);
3548.                             $etapa->setObs($_POST["obs_caixa"]);
3549.                             $etapa->setUpdatedAt($date_hoje);
3550.                             $entityManager->flush();
3551.                             
3553.                             $registro = new Registro();
3554.                             $registro->setOperacao('RECEBIMENTO DE  '.$qtd_caixas. ' CAIXA(S) '); 
3555.                             $registro->setUser($user_nome);
3556.                             $registro->setCliente($cliente_nome);
3557.                             $registro->setIp($ip_cliente);
3558.                             $entityManager->persist($registro);
3559.                             $entityManager->flush();
3561.                             $erro = 'ok';
3562.                             $p = "Recbimento com sucesso";
3563.                         }
3566.                       
3567.                     }else{
3568.                         $zy = "not";
3569.                     }
3571.                     if(isset($_POST["check_caixa_e"])){
3572.                         $zy = "yes";
3573.                         $options = new Options();
3574.                         $options->set('isHtml5ParserEnabled', true);
3575.                         $options->set('debugKeepTemp', true);
3576.                         $options->set('isPhpEnabled', true);
3577.                         $dompdf = new Dompdf($options);
3578.                         
3579.                         $html = '
3580.                                     <html>
3581.                                         <head>
3582.                                             <style>
3583.                                                 @page {
3584.                                                     margin: 35px 18.9px 0px 18.9px;
3585.                                                     size: 210mm 297mm; /* Ajuste de tamanho do papel */
3586.                                                 }
3587.                         
3588.                                                 body {
3589.                                                     margin: 0;
3590.                                                     padding: 0;
3591.                                                 }
3592.                                                 
3593.                                                 .qr-item {
3594.                                                     border: 2px dotted #000;
3595.                                                     text-align: center;
3596.                                                     width: 32.27mm;
3597.                                                     height: 34.9mm; 
3598.                                                     display: inline-block;
3599.                                                 }
3600.                                     
3601.                                                 .qr-item img {
3602.                                                     width: 115px; 
3603.                                                     height: 112px;
3604.                                                 }
3605.                         
3606.                                                 .qr-title {
3607.                                                     font-size: 16px;
3608.                                                     font-weight: bold;
3609.                                                 }
3610.                         
3611.                                                 .leo {
3612.                                                     display: flex;
3613.                                                     flex-wrap: wrap;
3614.                                                 }
3615.                                             </style>
3616.                                         </head>
3617.                                         <body> 
3618.                                     
3619.                                     ';
3620.                         
3621.                         $ckeck = $_POST["caixa_e"];
3622.                         $xy = 0;
3623.                         $qtd_caixas=0;
3624.                 
3625.                         foreach ($ckeck as $key) {
3626.                             $nome_k = NULL;
3627.                             $caixa_k = $doctrine->getRepository(Caixa::class)->find($key);
3628.                             if($caixa_k != NULL ){
3629.                                 $nome_k = $caixa_k->getNome();
3630.                             }
3631.                             
3632.                             if ($clienteAll_id != 18) {
3633.                             
3634.                                 $cx = new Cx();
3635.                                 $id_cx_ultimo ++;
3636.                                 $cx->setNome($id_cx_ultimo);
3637.                                 $cx->setStatus(2);
3638.                                 $cx->setTexto($nome_k);
3639.                                 $cx->setImage('ArquivosGED');
3640.                                 $cx->setCliente($clienteAll);
3641.                                 $entityManager->persist($cx);
3642.                                 $entityManager->flush();
3643.                                 $caixa_k->setCx($cx);
3644.                                 
3645.                             }
3646.                             
3647.                             $caixa_k->setFluxo($fluxo);
3648.                             $entityManager->flush();
3650.                             $registro = new Registro();
3651.                             $registro->setOperacao('RECEBIMENTO DA CAIXA EXISTENTE '.$nome_k); 
3652.                             $registro->setUser($user_nome);
3653.                             $registro->setCliente($cliente_nome);
3654.                             $registro->setIp($ip_cliente);
3655.                             $entityManager->persist($registro);
3656.                             $entityManager->flush();
3659.                             // Gerar QR Code com imagem no centro
3660.                             $result = Builder::create()
3661.                              ->writer(new PngWriter())
3662.                              ->writerOptions([])
3663.                              ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$id_cx_ultimo)
3664.                              ->encoding(new Encoding('UTF-8'))
3665.                              ->size(500)
3666.                              ->margin(5)
3667.                              ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
3668.                              ->build();
3669.                              // Salvar QR Code como arquivo temporário
3670.                              $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
3671.                              $result->saveToFile($tempFile);
3672.                              
3673.                              // Adicionar QR Code ao HTML
3674.                              if ($count % 48 == 0) {
3675.                                  $html .= '<div class="leo">';
3676.                              }
3677.              
3678.                              // Adicionar QR Code ao HTML
3679.                              $html .= '<div class="qr-item">';
3680.                              $html .= '<div class="qr-title">' . $id_cx_ultimo . '</div>';
3681.                              $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
3682.                              $html .= '</div>';
3683.                              
3684.                              
3685.                              $count++;
3687.                             // Fechar a div e inserir quebra de página a cada 63 QR Codes
3688.                             if ($count % 48 == 0) {
3689.                                 $html .= '</div><div style="page-break-after: always;"></div>';
3690.                             }
3692.                              
3693.                             
3694.                         }
3696.                         // Fechar qualquer div aberta sem completar 63 itens
3697.                         if ($count % 48 != 0) {
3698.                             $html .= '</div>';
3699.                         }
3700.                          
3701.                         $html .= '</div></body></html>';
3702.                         
3703.                         if ($clienteAll_id != 18) {  
3704.                             // Carregar o HTML e gerar o PDF
3705.                             $dompdf->loadHtml($html);
3706.                             $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
3707.                             $dompdf->render();
3708.                             #file_put_contents('sample1.pdf', $dompdf->output());
3709.                             $dompdf->stream('dompdf', array('Attachment' => 0));
3710.                         }
3712.                         if($xy==1){
3714.                             $etapa->setRegistro($registro);
3715.                             $etapa->setUpdatedAt($date_hoje);
3716.                             $etapa->setObs($_POST["obs_caixa"]);
3717.                             $entityManager->flush();
3718.                             
3720.                             $registro = new Registro();
3721.                             $registro->setOperacao('RECEBIMENTO DE  '.$qtd_caixas. ' CAIXA(S) '); 
3722.                             $registro->setUser($user_nome);
3723.                             $registro->setCliente($cliente_nome);
3724.                             $registro->setIp($ip_cliente);
3725.                             $entityManager->persist($registro);
3726.                             $entityManager->flush();
3728.                             $erro = 'ok';
3729.                             $p = "Recbimento com sucesso";
3730.                         }
3733.                       
3734.                     }else{
3735.                         $yz = "not";
3736.                     }
3738.                     if ($yz == "not" and $zy="not") {
3740.                         echo "<script>alert('ERROR , Preencha corretamente o formulario, está sem valor , selecione todas as opções necessaria!');</script>";
3741.                     }
3742.                    
3743.                 }
3744.                
3745.                
3746.                
3747.                
3748.             }else {
3749.                 echo "<script>alert('ERROR , Selecione o tipo!');</script>";
3750.             }
3751.             
3752.         }
3754.         return $this->render('index/recebimento.html.twig', [
3755.     
3756.             
3757.             'p'=>$p,
3758.             'erro'=>$erro,
3759.             'pagina' => $pagina,
3760.             'etapa'=>$etapa,
3761.             'caixas_setor' => $caixas_setor,
3762.             'cx_setor' => $cx_setor
3763.             
3764.             
3766.         ]);
3767.     }
3769.     #[Route('/index/higienizacao/{id}', name: 'higienizacao')]
3770.     public function higienizacao( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer,$id): Response
3771.     {
3772.         $user_logado = $this->getUser();
3773.         $user_nome = $user_logado->getNome();
3774.         $date_hoje = new \DateTimeImmutable('America/Sao_Paulo');
3775.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
3776.         $erro = '';
3777.         $pagina = 'home';
3778.         $p ='';
3779.         $a = 0 ;
3780.         $clienteAll = null;
3781.         $cx = null;
3782.         $caixa = null; 
3783.         $etapa = $doctrine->getRepository(Etapa::class)->findWithAllRelations($id);
3784.         $fluxo = $etapa->getFluxo();
3785.         $etapa_caixas = $etapa->getCaixa()->toArray();
3786.         $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo->getId());
3787.        
3788.         $e = 0;
3789.         $f = 0;
3790.         $clienteId = $session->get('cliente_id');
3791.         if($clienteId == null){
3792.             
3793.             return $this->redirectToRoute('home');
3794.         }
3795.         
3796.         
3797.         foreach ($etapa_caixas as $key) {
3798.             $e++;
3799.         }
3800.         foreach ($fluxo_caixas as $key) {
3801.             $f++;
3802.         }
3804.         if(isset($_POST["a"])){
3805.             $a = 2;
3806.         }
3807.         
3808.         $qrCodeData = $request->request->get('qrcode');
3809.         if(isset($_POST["id_caixas"])){
3810.             $a = 1 ;
3811.             $caixa = $doctrine->getRepository(Caixa::class)->findBy(['id' => $_POST["id_caixas"]]);
3812.             
3813.             foreach ($caixa as $key) { $caixa_cx_id = $key->getClientes()->toArray();}
3814.             
3815.             $cx =  $caixa_cx_id ;
3816.             
3817.             foreach ($cx as $key) {$cliente_cx_id = $key->getClienteAll()->getId();}
3818.             
3819.             $clienteAll = $doctrine->getRepository(ClienteAll::class)->findClienteWithRelations($cliente_cx_id);
3820.            
3821.             
3822.         }
3823.         if($qrCodeData != null){
3825.             
3826.             $url = $qrCodeData;
3827.             preg_match('/(\d+)\/(\d+)$/', $url, $matches);
3829.             if (!empty($matches)) {
3830.                 $numero1 = $matches[1]; 
3831.                 $numero2 = $matches[2];
3832.                 $clienteAll = $doctrine->getRepository(ClienteAll::class)->find($numero1);
3833.                 $cx = $doctrine->getRepository(Cx::class)->findBy(['nome' => $numero2]);
3834.                 
3835.                 foreach ($cx as $key) {
3837.                     $cx_id = $key->getId();
3838.                 }
3839.                     
3840.                 
3841.                 $caixa = $doctrine->getRepository(Caixa::class)->findBy(['cx' => $cx_id ]);
3842.                 $a = 1 ;
3843.                 
3844.             } else {
3845.                 
3846.               
3847.             }
3848.             
3849.         }
3851.         if(isset($_POST["cx"])){
3853.             $clienteAll = $doctrine->getRepository(ClienteAll::class)->findClienteWithRelations($_POST["clienteAll"]);
3854.             $clienteAll_nome = $clienteAll->getNome();
3855.             
3856.             $cx = $doctrine->getRepository(Cx::class)->find($_POST["cx"]);
3857.             $caixa = $doctrine->getRepository(Caixa::class)->find($_POST["caixas"]);
3858.             $cliente = $doctrine->getRepository(Cliente::class)->find($_POST["cliente"]);
3859.             
3860.             if ($cx != null) {
3861.                 $cx_nome = 'ID: '.$cx->getNome();
3862.             }else{
3863.                 $cx_nome = 'GED: '.$caixa->getNome();
3864.             }
3865.         
3866.             $cliente_nome = $clienteAll_nome;
3868.             if ($cliente_nome == NULL){
3870.                 $cliente_nome = $cliente->getNome();
3872.             }
3873.             
3874.             
3876.             $registro = new Registro();
3877.             $registro->setOperacao('HIGIENIZAÇÃO '.$cx_nome); 
3878.             $registro->setUser($user_nome);
3879.             $registro->setCliente($cliente_nome);
3880.             $registro->setIp($ip_cliente);
3881.             $entityManager->persist($registro);
3882.             $entityManager->flush();
3883.             
3884.             if($cx != null){
3885.                 
3886.                 $etapa->addCx($cx);
3887.             }
3888.             
3889.             $etapa->addCaixa($caixa);
3890.             $caixa->setHigienizaAt($date_hoje);
3891.             $e++;
3893.             if ($e == $f) {
3895.                 
3896.                 $registro = new Registro();
3897.                 $registro->setOperacao('HIGIENIZAÇÃO DE '.$f. ' CAIXA(S)'); 
3898.                 $registro->setUser('CONCLUIDO PELA EQUIPE');
3899.                 $registro->setCliente($cliente_nome);
3900.                 $registro->setIp($ip_cliente);
3901.                 $entityManager->persist($registro);
3902.                 $entityManager->flush();
3904.                 $etapa->setRegistro($registro);
3905.                 $etapa->setUpdatedAt($date_hoje);
3906.                 $entityManager->flush();
3907.             }
3908.             
3909.             $entityManager->flush();
3910.             $erro = 'ok';
3911.             $p = "Etapa concluída com sucesso";
3912.         }
3913.         
3914.         return $this->render('index/higienizacao.html.twig', [
3915.     
3916.             'id'=>$id,
3917.             'p'=>$p,
3918.             'erro'=>$erro,
3919.             'pagina' => $pagina,
3920.             'a'=>$a,
3921.             'clienteAll' => $clienteAll,
3922.             'cx' =>$cx ,
3923.             'caixa' => $caixa,
3924.             'fluxo_caixas'=>$fluxo_caixas
3925.             
3926.             
3927.             
3929.         ]);
3930.     }
3932.    
3933.     #[Route('/index/digitalizacao/{id}', name: 'digitalizacao')]
3934.     public function digitalizacao(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session,MessageBusInterface $bus,$id): Response
3935.     {
3936.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
3937.         $etapa = $doctrine->getRepository(Etapa::class)->findWithAllRelations($id);
3938.         $fluxo = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($etapa->getFluxo()->getId());
3939.         $cliente_nome = $fluxo->getCliente()->getNome();
3940.         $cliente_id = $fluxo->getCliente();
3941.         $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo->getId());
3942.         $form = $this->createForm(UploadType::class);
3943.         $user_logado = $this->getUser();
3944.         $user_logado_id = $user_logado->getId();
3945.         $userId = $user_logado_id;
3946.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
3947.         $form->handleRequest($request);
3948.         $dotenv = new Dotenv();
3949.         $dotenv->load(__DIR__.'/.env');
3950.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
3951.         $hoje_formt=$hoje->format('Y-m-d') ;
3952.         $dia_prod = 'de hoje';
3953.         $erro = '';
3954.         $ii=0;
3955.         $pagina = 'export';
3956.         $p = '';
3957.         $uuid = Uuid::v4();
3958.         $user = $this->getUser();
3959.         $user_nome= $user->getEmail();
3960.         $user_nome_name= $user->getNome();
3961.         $pasta_user=$user_nome.'/';
3962.         $cliente_alls = "";
3963.         $arr = [];
3964.         $arrr=0;
3965.         $f = 0;
3966.         $dt = '';
3967.         $clientS3 = new  S3Client([
3968.             'region'  => 'sa-east-1',
3969.             'version' => 'latest',
3970.             'credentials' => [ 
3971.                 'key'    => $_ENV['AWS_KEY'],
3972.                 'secret' => $_ENV['AWS_SECRET'],
3973.             ],
3974.         
3975.         ]);
3977.         foreach ($fluxo_caixas as $key) {
3978.             $f++;
3979.         }
3981.         if(isset($_POST["btn_cliente"])){
3982.             
3983.             $session->set('cliente_id', $_POST["btn_cliente"]);
3984.             return $this->redirectToRoute('home');
3985.         }
3986.        
3987.             
3988.             
3989.        
3990.         $clienteId = $session->get('cliente_id');
3991.         
3992.         if ($clienteId == null ) {
3993.             
3994.             $caixas =  "";
3995.             $cliente_session = "";
3996.             return $this->redirectToRoute('home');
3997.        
3998.         } else {
3999.             
4000.             $caixas = $fluxo_caixas;
4001.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);       
4002.         }
4003.         
4004.         
4005.         if(isset($_POST["botao_export"]))
4006.         {
4007.             
4008.             $caixaId = $_POST["caixas"];
4009.             
4010.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($_POST["caixas"]);
4011.             $clientes= $cliente_id->getId();
4012.             $clienteId=$clientes;
4014.             $clientes_status= $cliente_id->getExtraFields();
4015.             if(!$clientes_status){
4016.                 $clientes_status="ged";
4017.             }
4018.             $conteiner = $_POST["conteiner"];
4019.             $cont_file = 0 ;
4020.             $umlautString =$cliente_nome;
4021.             $slugger = new AsciiSlugger();
4022.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
4023.             $caminho = strtolower ($teste.'/');
4024.                     
4025.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
4026.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
4027.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
4028.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
4029.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
4030.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
4031.             if($clientes ==  15){$caminho='cbsi-dossies/';}
4032.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
4033.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
4034.             if($clientes ==  40){$caminho='fasf-atas-e-diario/';}
4035.             if($clientes ==  127){$caminho='pmecj-s-a.A) - ALMOXARIFADO E PATRIMÔNIO/';}
4036.            
4037.             $filesTmp  = $_FILES['file']['tmp_name'];
4038.             $filesName = $_FILES['file']['name'];
4039.             
4040.             foreach ($filesTmp as $index => $file) {
4041.             
4042.                 $uuid = Uuid::v4();
4043.                 $cont_file++;
4044.                 // nome original do arquivo
4045.                 $originalName = pathinfo($filesName[$index], PATHINFO_FILENAME);
4046.                 // sanitiza o nome (remove acentos, espaços estranhos etc.)
4047.                 $slugger = new AsciiSlugger();
4048.                 $safeName = strtolower($slugger->slug($originalName)->toString());
4049.             
4050.                 // 🔹 Se cliente for local, usa nome original
4051.                 if ($clientes_status === 'local') {
4052.             
4053.             
4054.                     $filename = $safeName . '.pdf';
4055.             
4056.                 } else {
4057.                     // padrão: UUID
4058.                     $filename = $uuid . '.pdf';
4059.                 }
4060.             
4061.                 $tempDir = __DIR__ . '/../../var/uploads/messenger';
4062.                 if (!is_dir($tempDir)) {
4063.                     mkdir($tempDir, 0777, true);
4064.                 }
4065.             
4066.                 $tempFilePath = $tempDir . '/' . $filename;
4067.             
4068.                 move_uploaded_file($file, $tempFilePath);
4069.                 chmod($tempFilePath, 0644);
4070.                 if (!file_exists($tempFilePath) || filesize($tempFilePath) === 0) {
4071.                     throw new \RuntimeException(
4072.                         'Falha ao gravar PDF temporário: ' . $tempFilePath
4073.                     );
4074.                 }
4075.                 
4076.                 // evita race condition de filesystem
4077.                 clearstatcache(true, $tempFilePath);
4078.             
4079.                 $bus->dispatch(new UploadMultipartMessage(
4080.                     $tempFilePath,
4081.                     $filename,
4082.                     $caminho,
4083.                     '',
4084.                     $caixaId,
4085.                     $clienteId,
4086.                     $userId,
4087.                     0,
4088.                     $conteiner,
4089.                     $clientes,
4090.                     $clientes_status,
4091.                     $safeName,
4092.                     $originalName,
4093.                     $cliente_alls 
4094.                 ));
4095.             }
4098.            
4099.             $log = new Registro();
4100.             $log->setOperacao('EXPORTOU '.$cont_file.' DOCUMENTO(S)'); 
4101.             $log->setUser($user_nome_name);
4102.             $log->setCliente($cliente_nome);
4103.             $entityManager->persist($log);
4104.             $entityManager->flush();
4105.             
4106.             return $this->redirectToRoute('digitalizacao', ['id' => $id]);
4107.             
4108.         
4109.         }
4111.         if(isset($_POST["caixa_total"])){
4113.             $caixa_total = $_POST["caixa_total"];
4114.             $documento_total =$_POST["documento_total"];
4115.             $qtd_total =$_POST["qtd_total"];
4118.                 $registro = new Registro();
4119.                 $registro->setOperacao('DIGITALIZAÇÃO:  '.$caixa_total. ' CAIXA(S) / '.$documento_total.' DOCUMENTO(S) / '.$qtd_total.' IMAGEN(S)'); 
4120.                 $registro->setUser('CONCLUIDO PELA EQUIPE');
4121.                 $registro->setCliente($cliente_nome);
4122.                 $registro->setIp($ip_cliente);
4123.                 $entityManager->persist($registro);
4124.                 $entityManager->flush();
4126.                 $etapa->setRegistro($registro);
4127.                 $etapa->setUpdatedAt($hoje);
4128.                 $entityManager->flush();
4129.                 $erro = 'ok';
4130.                 $p = "Etapa concluída com sucesso";
4131.         }
4133.        
4134.         return $this->render('index/digitalizacao.html.twig', [
4135.             'id'=>$id,
4136.             'p'=>$p,
4137.             'erro'=>$erro,
4138.             'pagina' => $pagina,
4139.             'caixas' => $caixas,
4140.             'user_logado' => $user_logado,
4141.             'cliente' => $cliente,
4142.             'cliente_session' => $cliente_session,
4143.             'form' => $form->createView(),
4144.             'dia_prod' => $dia_prod,
4145.             'fluxo' => $fluxo
4146.         ]);
4147.     }
4149.     #[Route('/index/indexacao/{id}', name: 'indexacao')]
4150.     public function indexacao(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager , SessionInterface $session,$id): Response
4151.     {   
4152.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
4153.         $etapa = $doctrine->getRepository(Etapa::class)->findWithAllRelations($id);
4154.         $fluxo = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($etapa->getFluxo()->getId());
4155.         $cliente_nome = $fluxo->getCliente()->getNome();
4156.         $cliente_etapa = $fluxo->getCliente();
4157.         $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo->getId());
4158.         $caixaIds = array_map(fn($caixa) => $caixa->getId(), $fluxo_caixas);
4159.         $documentoRepository = $entityManager->getRepository(Documento::class);
4160.         $query = $documentoRepository->createQueryBuilder('d')
4161.             ->where('d.caixa IN (:caixaIds)')
4162.             ->setParameter('caixaIds', $caixaIds)
4163.             #->orderBy('d.qtd', 'ASC') // Ordenando pelo ID da caixa em ordem crescente
4164.             ->getQuery();
4166.         // Executa a query
4167.         $documentos = $query->getResult();
4168.         $caixas = $fluxo_caixas;
4169.         $dotenv = new Dotenv();
4170.         $dotenv->load(__DIR__.'/.env');
4171.         $user_logado = $this->getUser();
4172.         $form = $this->createForm(UploadType::class);
4173.         $form->handleRequest($request);
4174.         $user_logado_tipoAcesso = $user_logado->getTipoAcesso();
4175.         $user_logado_nome = $user_logado->getNome();
4176.         $user_logado_id = $user_logado->getId();
4177.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
4178.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
4179.         $hoje_formt=$hoje->format('Y-m-d');
4180.         $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $hoje_formt);
4181.         $dia_prod = 'de hoje';
4182.         $permissao = [];
4183.         $list_indexador = [];
4184.         $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $cliente_etapa]);
4185.         $class =  $doctrine->getRepository(Classificacao::class)->findBy(['cliente' => $cliente_etapa]);
4186.         $cliente_ids =$cliente_etapa ;
4187.         
4188.        
4189.             
4190.         $cliente_nome= $cliente_ids->getNome();
4191.         $clientes= $cliente_ids->getId();
4192.         $umlautString =$cliente_nome;
4193.         $slugger = new AsciiSlugger();
4194.         $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
4195.         $caminho = strtolower ($teste.'/');
4196.                         
4197.         if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
4198.         if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
4199.         if($clientes == 35){$caminho='pmecj-sp-saude/';}
4200.         if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
4201.         if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
4202.         if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
4203.         if($clientes ==  15){$caminho='cbsi-dossies/';}
4204.         if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
4205.         if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
4206.         if($clientes ==  127){$caminho='pmecj-s-a.A) - ALMOXARIFADO E PATRIMÔNIO/';}
4207.       
4209.           
4210.         if(isset($_POST["btn_cliente"])){
4211.             
4212.             $session->set('cliente_id', $_POST["btn_cliente"]);
4213.             return $this->redirectToRoute('home');
4214.         }
4217.         $clienteId = $session->get('cliente_id');
4218.         
4219.         
4220.         if ($clienteId == null ) {
4221.             
4222.             $caixas =  "";
4223.             $cliente_session = "";
4224.             return $this->redirectToRoute('home');
4225.        
4226.         }
4227.            
4228.         $erro = '';
4229.         $ii=0;
4230.         $pagina = 'index';
4231.         $p = '';
4232.         $link = '';
4233.         $mx = 0;
4234.         $xy = 0 ; 
4235.         $yz = 0 ; 
4236.         $ay = 0 ;
4237.         $ky = 0 ;
4238.         $pdf ='';
4239.         $pagina_h4 ='Documento(s) para indexar';
4240.         $nome_menu_ = '';
4241.         $index_tipo='';
4242.         $uuid = Uuid::v4();
4243.         $user = $this->getUser();
4244.         $user_nome= $user->getEmail();
4245.         $user_nome_name= $user->getNome();
4246.         $pasta_user=$user_nome.'/';
4247.         $arr = [];
4248.         $arrr=0;
4249.         $index_find = null;
4250.         $dt = '';
4251.         $clientS3 = new  S3Client([
4252.                     'region'  => 'sa-east-1',
4253.                     'version' => 'latest',
4254.                     'credentials' => [ 
4255.                         'key'    => $_ENV['AWS_KEY'],
4256.                         'secret' => $_ENV['AWS_SECRET'],
4257.                     ],
4258.                 ]);
4259.         
4260.      
4261.             
4262.        
4263.         if(isset($_POST["botao_index"])){
4264.             
4265.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
4266.             $link = $pdf->getImage();
4267.             $xy = 1 ;
4268.             
4269.         }
4270.         if(isset($_POST["botao_doc"])){
4271.             
4272.             
4273.             $yz = 0 ;
4274.             $xy = 1 ;
4275.             $ay = 1 ;
4276.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
4277.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
4278.            
4279.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
4280.             $index_tipo_tipo =  $index_tipo->getNome();
4281.             $link = $pdf->getImage();
4282.             $fase=$_POST["fase"];
4283.             $data = $_POST["data"];
4284.             $cx = $_POST["caixas"];
4285.             $classifica = $_POST["classifica"];
4286.             $desc = $_POST["desc"];
4287.             $assunto = $_POST["assunto"];
4288.             $chave = $_POST["chave"];
4289.             $nome = $_POST["nome"];
4290.             $conteiner = $_POST["conteiner"];
4292.             
4293.             
4294.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($cx);
4295.             
4296.             
4297.             
4298.             
4300.             // Exibe os números encontrados
4301.             
4302.             if ($clientes != 7) {
4303.                 preg_match_all('/\d+/', $fase, $matches);
4304.                 $numeros = array_map('intval', $matches[0]);
4305.                 if ($data != "") {
4306.                     if ($numeros != [] ) {
4307.                         if ($fase != "") {
4308.         
4309.                             // Número inteiro que você deseja somar ao ano
4310.                             $numeroParaSomar = $numeros[0];
4311.         
4312.                             // Extrair o ano da data
4313.                             list($ano, $mes, $dia) = explode('-', $data);
4314.         
4315.                             // Converter o ano para um número inteiro
4316.                             $ano = intval($ano);
4317.         
4318.                             // Somar o número ao ano
4319.                             $data_vecimento =  $ano + $numeroParaSomar.'-'.$mes.'-'. $dia;
4320.         
4321.                             $pdf->setVencimentoDocumento(new \DateTimeImmutable($data_vecimento));
4322.         
4323.                         }
4324.                 }
4325.                 $pdf->setDataDocumento(new \DateTimeImmutable($data));
4326.                 }
4327.             }    
4328.             
4329.             if ($clientes == 7) {
4330.                   $pdf->setVencimentoDocumento(new \DateTimeImmutable($fase));
4331.                   $pdf->setDataDocumento(new \DateTimeImmutable($data));
4332.              }
4333.             
4334.             
4335.             $pdf->setAssunto($assunto);
4337.             if ($classifica != "") {
4339.                 $classifica_id = $doctrine->getRepository(Classificacao::class)->find($classifica);
4340.                 $pdf->setClassificacao($classifica_id);
4341.             }
4343.             $pdf->setCaixa($caixa_id);
4344.             $pdf->setExtraFields($desc);
4345.             $pdf->setNome($nome);
4346.             $pdf->setKeywords($chave);
4347.             $pdf->setUserIndex($user_nome_name);
4348.             $pdf->setConteiner($conteiner);
4349.             $pdf->setIndexAt(new \DateTimeImmutable('America/Sao_Paulo'));
4350.             $pdf->setTipo($index_tipo);
4351.             $entityManager->flush();
4352.             $id_pd = $pdf->getId();    
4353.             $log = new Registro();
4354.             $log->setOperacao('Indexou o Documento com id '.$id_pd); 
4355.             $log->setUser($user_nome_name);
4356.             $log->setCliente($cliente_nome);
4357.             $entityManager->persist($log);
4358.             $entityManager->flush();
4359.             $erro = 'ok';
4360.             $p =  $index_tipo_tipo.' indexado com sucesso';
4361.             
4364.            
4365.             
4366.            
4367.         }   
4368.         if(isset($_POST["botao_index_edit"])){
4369.             
4370.             $yz = 0 ;
4371.             $xy = 1 ;
4372.             $ay = 1 ;
4373.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
4374.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
4375.             $link = $pdf->getImage();
4376.         }
4377.         if(isset($_POST["botao_volta"])){
4379.             $xy = 0 ;
4380.             $yz = 0 ;
4381.         }
4382.         if(isset($_POST["index_button"])){
4383.             
4384.             
4385.             $yz = 0 ;
4386.             $xy = 1 ;
4387.             $ay = 1 ;
4388.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
4389.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["index_button"]);
4390.             $link = $pdf->getImage();
4391.         }
4392.         if(isset($_POST["botao_cancel"])){
4393.             $yz = 0 ;
4394.             $xy = 1 ;
4395.             $ay = 0 ;
4396.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
4397.             $link = $pdf->getImage();
4398.             
4399.         }
4400.         if(isset($_POST["delet"])){
4401.            
4402.             $ky = 1 ;
4403.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["delet"]);
4404.             $documentos = $doctrine->getRepository(Documento::class)->findBy(['id' => $_POST["delet"]]);
4405.             
4406.             if($pdf->getTipo()!= null){
4407.                 $index_find =  $doctrine->getRepository(Tipo::class)->find($pdf->getTipo());
4408.                 $pagina =$index_find->getTipo();
4409.                 $pagina_h4 ='Documento(s) do tipo ( '.$index_find->getTipo().' )';
4410.             }
4411.                         
4412.         }
4413.         if(isset($_POST["delet_cancel"])){
4414.             $ky = 0 ;
4415.         }
4416.         if(isset($_POST["delet_sim"])){
4417.             
4418.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
4419.             $id_pd = $pdf->getId();
4420.             $entityManager->remove($pdf);
4421.             $entityManager->flush();
4422.           
4423.             $log = new Registro();
4424.             $log->setOperacao('Excluiu Documento com id '.$id_pd); 
4425.             $log->setUser($user_nome_name);
4426.             $log->setCliente($cliente_nome);
4427.             $entityManager->persist($log);
4428.             $entityManager->flush();
4429.             $erro = 'ok';
4430.             $p = 'Documento com id '.$id_pd.' excluido com sucesso '; 
4431.         }
4432.         if(isset($_POST["index_edit"])){
4433.             $yz = 0 ;
4434.             $xy = 1 ;
4435.             $ay = 2 ;
4436.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
4437.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
4438.             $link = $pdf->getImage();
4439.         }
4440.        
4441.         if(isset($_POST["caixa_total"])){
4443.             $caixa_total = $_POST["caixa_total"];
4444.             $documento_total =$_POST["documento_total"];
4445.             $qtd_total =$_POST["qtd_total"];
4448.                 $registro = new Registro();
4449.                 $registro->setOperacao('INDEXADO:  '.$caixa_total. ' CAIXA(S) / '.$documento_total.' DOCUMENTO(S) / '); 
4450.                 $registro->setUser('CONCLUIDO PELA EQUIPE');
4451.                 $registro->setCliente($cliente_nome);
4452.                 $registro->setIp($ip_cliente);
4453.                 $entityManager->persist($registro);
4454.                 $entityManager->flush();
4456.                 $etapa->setRegistro($registro);
4457.                 $etapa->setUpdatedAt($hoje);
4458.                 $entityManager->flush();
4459.                 $erro = 'ok';
4460.                 $p = "Etapa concluída com sucesso";
4461.         }
4462.         
4463.            $cmd = $clientS3->getCommand('GetObject', [
4464.                 'Bucket' => 'arquivosdoc',
4465.                 'Key'    => $caminho. $link, 
4466.             ]);
4467.             
4468.             $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
4469.             $all_Url = (string) $req->getUri();
4470.         
4471.         return $this->render('index/indexacao.html.twig', [
4472.             'documentos' => $documentos,
4473.             'xy' => $xy,
4474.             'yz' => $yz,
4475.             'ay'=>$ay,
4476.             'link' => $link,
4477.             'pdf'=>$pdf,
4478.             'p'=>$p,
4479.             'erro'=>$erro,
4480.             'index_all'=>$index_all,
4481.             'index_tipo'=>$index_tipo,
4482.             'ky'=>$ky,
4483.             'pagina' => $pagina,
4484.             'pagina_h4' =>$pagina_h4,
4485.             'index_find'=>$index_find,
4486.             'mx'=>$mx,
4487.             'class'=>$class,
4488.             'caixas' => $caixas,
4489.             'permissao'=>$permissao,
4490.             'doc'=>$doc,
4491.             'dia_prod' => $dia_prod,
4492.             'fluxo' => $fluxo,
4493.             'id' => $id,
4494.             'caminho' =>$caminho,
4495.             'clientes'=>$clientes,
4496.             'all_Url'=>$all_Url
4498.         ]);
4501.     }
4502.     
4503.     #[Route('/kpis', name: 'kpis')]
4504.     public function kpis(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager): Response
4505.     {
4506.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
4507.         $hoje_formt=$hoje->format('Y-m-d') ;
4508.         $pagina="kpis";
4509.         $motivo ='';
4510.         $error='';
4511.         $user_logado = $this->getUser();
4512.         $de_="";
4513.         $ate_= "";
4514.         $h4 ="TOTAL";
4516.         if (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) {
4517.             $ip_cliente = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR'])[0];
4518.         } else {
4519.             $ip_cliente = $_SERVER['REMOTE_ADDR'];
4520.         }
4521.         
4522.         $payload = json_encode([
4523.             
4524.             'data_inicio' => null,
4525.             'data_fim' => null
4526.             
4527.         ]);
4529.         $options = [
4530.             'http' => [
4531.                 'header'  => "Content-Type: application/json\r\n",
4532.                 'method'  => 'POST',
4533.                 'content' => $payload,
4534.             ],
4535.         ];
4537.         $context  = stream_context_create($options);
4538.         $response = file_get_contents('https://produtive.arquivosdoc.com.br/api/tjrj', false, $context);
4540.         if ($response === false) {
4541.             return new Response("Erro ao consumir API", 500);
4542.         }
4544.         $data = json_decode($response, true);
4545.         
4546.         $conn = $entityManager->getConnection();
4548.         $sql = "
4549.            SELECT 
4550.                 c.nome AS cliente_nome,
4551.                     (SELECT COUNT(cx.id) 
4552.                      FROM cx cx 
4553.                      WHERE cx.caminho IS NOT NULL 
4554.                      AND cx.cliente_id = c.id) AS total_caixas,
4555.                     (SELECT COUNT(d.id) 
4556.                      FROM documento d 
4557.                      JOIN cliente s ON s.id = d.cliente_id
4558.                      WHERE s.cliente_all_id = c.id) AS total_documentos,
4559.                     (SELECT SUM(d.qtd) 
4560.                      FROM documento d 
4561.                      JOIN cliente s ON s.id = d.cliente_id
4562.                      WHERE s.cliente_all_id = c.id) AS imagens_total
4563.                 FROM cliente_all c
4564.                 ORDER BY c.nome ASC
4566.         ";
4568.         $stmt = $conn->prepare($sql);
4569.         $stmt->execute();
4570.         $fed_cliente = $stmt->executeQuery()->fetchAllAssociative();
4571.         
4572.          // 🔹 Adicionando TJRJ no array de clientes
4573.         if (is_array($data)) {
4574.             $fed_cliente[] = [
4575.                 'cliente_nome'     => 'TRIBUNAL DE JUSTICA DO ESTADO DO RIO DE JANEIRO',
4576.                  #'total_caixas'     => $data['total_caixas'] ?? 0,
4577.                 'total_caixas'     => 0,
4578.                 'total_documentos' => $data['total_documentos'] ?? 0,
4579.                 'imagens_total'    => $data['imagens_total'] ?? 0
4580.             ];
4581.         }
4582.         
4583.        
4585.        
4586.         //IMAGENS
4587.         $sql1 = "SELECT SUM(d.qtd) AS total_imagens FROM documento d";
4588.         $totalImagens = $conn->fetchOne($sql1); 
4590.         $totalImagens += $data['imagens_total'] ?? 0;
4591.         
4592.         //DOCUMENTOS
4593.         $sql2 = "SELECT COUNT(d.id) AS total_documentos FROM documento d";
4594.         $documento = $conn->fetchOne($sql2);
4596.         $documento += $data['total_documentos'] ?? 0;
4597.         
4598.         //CX (com filtro de status != 0)
4599.         $sql3 = "SELECT COUNT(d.id) AS total_cx FROM cx d WHERE d.status != 0 AND d.caminho != ''";
4600.         $cx = $conn->fetchOne($sql3);
4601.         
4602.         
4603.          if(isset($_POST["pesq"])){
4604.         
4605.             
4606.             $de = $_POST["de"];
4607.             $ate = $_POST["ate"]." 23:59:59";
4608.             
4609.             
4610.             
4611.             // IMAGENS
4612.             $queryStr = '
4613.                 SELECT SUM(d.qtd) AS total_imagens
4614.                 FROM App\Entity\Documento d
4615.                 WHERE d.createdAt >= :de 
4616.             ';
4617.             if ($ate) {
4618.                 $queryStr .= ' AND d.createdAt <= :ate';
4619.             }
4620.             $query = $entityManager->createQuery($queryStr);
4621.             $query->setParameter('de', $de);
4622.             if ($ate) {$query->setParameter('ate', $ate);}
4623.             $result = $query->getSingleResult();
4624.             $totalImagens = $result['total_imagens'];
4626.             //
4627.         
4628.             // DOCUMENTOS
4629.             $queryStr = '
4630.                 SELECT COUNT(d.id) AS total_documentos
4631.                 FROM App\Entity\Documento d
4632.                 WHERE d.createdAt >= :de
4633.             ';
4634.             if ($ate) {
4635.                 $queryStr .= ' AND d.createdAt <= :ate';
4636.             }
4637.             $query = $entityManager->createQuery($queryStr);
4638.             $query->setParameter('de', $de);
4639.             if ($ate) {$query->setParameter('ate', $ate);}
4640.             $result = $query->getSingleResult();
4641.             $documento = $result['total_documentos'];
4642.             //
4643.         
4644.             // CX
4645.             $queryStr = '
4646.                 SELECT COUNT(d.id) AS total_cx
4647.                 FROM App\Entity\Cx d
4648.                 WHERE d.createdAt >= :de  AND d.caminho IS NOT NULL
4649.             ';
4650.             if ($ate) {
4651.                 $queryStr .= ' AND d.createdAt <= :ate';
4652.             } else {
4653.                 $queryStr .= ' AND DATE(d.createdAt) = DATE(:de)';
4654.             }
4655.             $query = $entityManager->createQuery($queryStr);
4656.             $query->setParameter('de', $de);
4657.             if ($ate) {$query->setParameter('ate', $ate);}
4658.             $result = $query->getSingleResult();
4659.             $cx = $result['total_cx'];
4660.             //
4661.             
4662.             $queryStr = "
4663.                 SELECT 
4664.                     c.nome AS cliente_nome,
4665.                     (SELECT COUNT(cx.id) 
4666.                      FROM App\Entity\Cx cx 
4667.                      WHERE cx.status != 0 
4668.                      AND cx.caminho != '' 
4669.                      AND cx.cliente = c
4670.                      AND cx.createdAt >= :de
4671.             ";
4672.             
4673.             if ($ate) {
4674.                 $queryStr .= " AND cx.createdAt <= :ate";
4675.             } else {
4676.                 $queryStr .= " AND DATE(cx.createdAt) = DATE(:de)";
4677.             }
4678.             
4679.             $queryStr .= ") AS total_caixas,
4680.         
4681.                     (SELECT COUNT(d1.id) 
4682.                      FROM App\Entity\Documento d1 
4683.                      JOIN d1.cliente c1 
4684.                      WHERE c1.clienteAll = c
4685.                      AND d1.createdAt >= :de
4686.             ";
4687.             
4688.             if ($ate) {
4689.                 $queryStr .= " AND d1.createdAt <= :ate";
4690.             } else {
4691.                 $queryStr .= " AND DATE(d1.createdAt) = DATE(:de)";
4692.             }
4693.             
4694.             $queryStr .= ") AS total_documentos,
4695.         
4696.                     (SELECT SUM(d2.qtd) 
4697.                      FROM App\Entity\Documento d2 
4698.                      JOIN d2.cliente c2 
4699.                      WHERE c2.clienteAll = c
4700.                      AND d2.createdAt >= :de
4701.             ";
4702.             
4703.             if ($ate) {
4704.                 $queryStr .= " AND d2.createdAt <= :ate";
4705.             } else {
4706.                 $queryStr .= " AND DATE(d2.createdAt) = DATE(:de)";
4707.             }
4708.             
4709.             $queryStr .= ") AS imagens_total
4710.             FROM App\Entity\ClienteAll c
4711.             ORDER BY c.nome ASC
4712.             ";
4713.             
4714.             // Preparar a consulta com os parâmetros de data
4715.             $query = $entityManager->createQuery($queryStr);
4716.             $query->setParameter('de', $de);
4717.             if ($ate) {
4718.                 $query->setParameter('ate', $ate);
4719.             }
4720.             
4721.             $result = $query->getResult();
4722.                     
4723.             $fed_cliente = $result;
4724.             
4725.             
4726.             
4727.             // 🔹 Chamada API TJRJ
4728.             $payload = json_encode([
4729.                 'data_inicio' => $_POST["de"] ?? null,
4730.                 'data_fim'    => $_POST["ate"] ?? null
4731.             ]);
4732.             
4733.             $options = [
4734.                 'http' => [
4735.                     'header'  => "Content-Type: application/json\r\n",
4736.                     'method'  => 'POST',
4737.                     'content' => $payload,
4738.                 ],
4739.             ];
4740.             
4741.             $context  = stream_context_create($options);
4742.             $response = file_get_contents('https://produtive.arquivosdoc.com.br/api/tjrj', false, $context);
4743.             
4744.             $data = $response ? json_decode($response, true) : [];
4745.             
4746.             // 🔹 Adiciona TJRJ na lista final (igual no geral)
4747.             if (is_array($data)) {
4748.                 $fed_cliente[] = [
4749.                     'cliente_nome'     => 'TRIBUNAL DE JUSTICA DO ESTADO DO RIO DE JANEIRO',
4750.                     'total_caixas'     => 0,
4751.                     'total_documentos' => $data['total_documentos'] ?? 0,
4752.                     'imagens_total'    => $data['imagens_total'] ?? 0
4753.                 ];
4754.             }
4755.             
4756.             
4757.                     
4758.                         
4759.         } 
4760.           
4761.             
4762.      
4763.         
4764.         return $this->render('index/kpis.html.twig',array(
4765.             
4766.             'error' =>$error,
4767.             'motivo' => $motivo,
4768.             'pagina'=>$pagina,
4769.             'user_logado'=> $user_logado ,
4770.             'cx' => $cx,
4771.             'documento' => $documento,
4772.             'de' =>$de_,
4773.             'ate' =>$ate_,
4774.             'h4' => $h4,
4775.             //'documentosPorMes' => $documentosPorMes,
4776.             //'cxPorMes'=>$cxPorMes,
4777.             //'totalImagensPorMes' => $totalImagensPorMes,
4778.             'totalImagens'=>$totalImagens,
4779.             'fed_cliente'=> $fed_cliente
4780.             
4781.             
4782.         ));
4784.     }
4785.     
4786.     #[Route('/fila/count', name: 'fila_count', methods: ['GET'])]
4787.     public function count(EntityManagerInterface $entityManager): JsonResponse
4788.     {
4789.         $user_logado = $this->getUser();
4790.         $user_logado_id = $user_logado->getId();
4791.         $count = $entityManager->getRepository(MessengerMessages::class)->countPendingMessagesByUser($user_logado_id);
4792.         
4793.         return new JsonResponse(['count' => $count]);
4794.     }
4795.     
4796.     #[Route('/index/qualidade', name: 'qualidade')]
4797.     public function qualidade(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager , SessionInterface $session): Response
4798.     {   
4799.         $clienteId = $session->get('cliente_id');
4800.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
4801.         $caixaIds = "LEONARDO DE SOUZA CRUZEIRO";
4802.         $documentoRepository = $entityManager->getRepository(Documento::class);
4803.         $query = $documentoRepository->createQueryBuilder('d')
4804.             ->where('d.user_index IN (:caixaIds)')
4805.             ->andWhere('d.cliente = :clienteId')
4806.             ->andWhere('d.situacao = :situacao OR d.situacao IS NULL')
4807.             ->setParameter('situacao', '')
4808.             ->setParameter('caixaIds', $caixaIds)
4809.             ->setParameter('clienteId', $clienteId)
4810.             ->orderBy('d.caixa', 'ASC') // Ordenando pelo ID da caixa em ordem crescente
4811.             ->getQuery();
4814.         // Executa a query
4815.         $documentos = $query->getResult();
4816.         #dd($documentos);
4817.         $dotenv = new Dotenv();
4818.         $dotenv->load(__DIR__.'/.env');
4819.         $user_logado = $this->getUser();
4820.         $form = $this->createForm(UploadType::class);
4821.         $form->handleRequest($request);
4822.         $user_logado_tipoAcesso = $user_logado->getTipoAcesso();
4823.         $user_nome_name = $user_logado->getNome();
4824.         $user_logado_id = $user_logado->getId();
4825.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
4826.         $hoje_formt=$hoje->format('Y-m-d');
4827.         $dia_prod = 'de hoje';
4828.         $permissao = [];
4829.         $list_indexador = [];
4830.         $slugger = new AsciiSlugger();
4831.         $erro = '';
4832.         $ii=0;
4833.         $pagina = 'qualidade';
4834.         $p = '';
4835.         $link = '';
4836.         $xy = 0 ; 
4837.         $pdf ='';
4838.         $umlautString = '';
4839.         $clientes = 0;
4840.         $caminho ='';
4841.         $class ="";
4842.         $all_Url="";
4843.         
4844.         $clientS3 = new  S3Client([
4845.                     'region'  => 'sa-east-1',
4846.                     'version' => 'latest',
4847.                     'credentials' => [ 
4848.                         'key'    => $_ENV['AWS_KEY'],
4849.                         'secret' => $_ENV['AWS_SECRET'],
4850.                     ],
4851.                 ]);
4852.        
4854.         if(isset($_POST["botao_index"])){
4855.             
4856.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
4857.             $clientes = $pdf->getCliente()->getId();
4858.             $clienteRepository = $entityManager->getRepository(Cliente::class);
4859.             $class =  $doctrine->getRepository(Classificacao::class)->findBy(['cliente' => $clientes]);
4860.             $query = $clienteRepository->createQueryBuilder('c')
4861.                 ->where('c.id = :caixaIds')
4862.                 ->setParameter('caixaIds', $clientes)
4863.                 ->getQuery();
4864.             $cl = $query->getSingleResult();
4865.             $link = $pdf->getImage();
4866.             $xy = 1 ;
4867.             $umlautString = $cl->getNome();
4868.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
4869.             $caminho = strtolower ($teste.'/');
4870.                     
4871.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
4872.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
4873.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
4874.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
4875.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
4876.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
4877.             if($clientes ==  15){$caminho='cbsi-dossies/';}
4878.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
4879.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
4880.             if($clientes ==  127){$caminho='pmecj-s-a.A) - ALMOXARIFADO E PATRIMÔNIO/';}
4881.             
4882.             $cmd = $clientS3->getCommand('GetObject', [
4883.                 'Bucket' => 'arquivosdoc',
4884.                 'Key'    => $caminho. $link, 
4885.                 ]);
4886.                 
4887.             $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
4888.             $all_Url = (string) $req->getUri();
4890.                 
4891.         }
4892.         if(isset($_POST["botao_doc"])){
4893.             
4894.             
4895.             
4896.             
4897.             $yz = 0 ;
4898.             $xy = 1 ;
4899.             $ay = 1 ;
4900.             
4901.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
4902.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($pdf->getTipo());
4903.             $index_tipo_tipo =  $index_tipo->getNome();
4904.             $link = $pdf->getImage();
4905.             $data = $_POST["data"];
4906.             $desc = $_POST["desc"];
4907.             $assunto = $_POST["assunto"];
4908.             $chave = $_POST["chave"];
4909.             $nome = $_POST["nome"];
4910.             $conteiner = $_POST["conteiner"];
4911.             $classifica = $_POST["classifica"];
4912.             $fase = $_POST["fase"];
4913.             
4914.             preg_match_all('/\d+/', $fase, $matches);
4915.             $numeros = array_map('intval', $matches[0]);
4917.             if ($clientes != 7) {
4918.                 if ($data != "") {
4919.                     if ($fase != "") {
4920.                         $numeroParaSomar = $numeros[0];
4921.                         list($ano, $mes, $dia) = explode('-', $data);
4922.                         $ano = intval($ano);
4923.                         $data_vecimento =  $ano + $numeroParaSomar.'-'.$mes.'-'. $dia;
4924.                         $pdf->setVencimentoDocumento(new \DateTimeImmutable($data_vecimento));
4925.                     }
4926.                 $pdf->setDataDocumento(new \DateTimeImmutable($data));
4927.                 }
4928.             }  
4930.             if ($classifica != "") {
4932.                 $classifica_id = $doctrine->getRepository(Classificacao::class)->find($classifica);
4933.                 $pdf->setClassificacao($classifica_id);
4934.             }
4935.             
4936.             
4937.             
4938.             
4939.             $pdf->setAssunto($assunto);
4940.             $pdf->setExtraFields($desc);
4941.             $pdf->setNome($nome);
4942.             $pdf->setKeywords($chave);
4943.             $pdf->setUserIndex($user_nome_name);
4944.             $pdf->setConteiner($conteiner);
4945.             $pdf->setIndexAt(new \DateTimeImmutable('America/Sao_Paulo'));
4946.             $pdf->setSituacao('OK');
4947.             $entityManager->flush();
4948.             $id_pd = $pdf->getId();    
4949.             $log = new Registro();
4950.             $log->setOperacao('Conferiu o Documento com id '.$id_pd); 
4951.             $log->setUser($user_nome_name);
4952.             $log->setCliente($umlautString);
4953.             $entityManager->persist($log);
4954.             $entityManager->flush();
4955.             $erro = 'ok';
4956.             $p =  $index_tipo_tipo.' FOI CONFERIDO COM SUCESSO';
4957.            
4958.         }   
4960.         if(isset($_POST["botao_volta"])){
4962.             $xy = 0 ;
4963.             $yz = 0 ;
4964.         }
4965.         
4966.        
4968.         
4969.         return $this->render('index/qualidade.html.twig', [
4970.             'documentos' => $documentos,
4971.             'xy' => $xy,
4972.             'link' => $link,
4973.             'pdf'=>$pdf,
4974.             'p'=>$p,
4975.             'erro'=>$erro,
4976.             'pagina' => $pagina,
4977.             'caminho' =>$caminho,
4978.             'class' => $class,
4979.             'all_Url'=>$all_Url,
4980.            
4982.         ]);
4985.     }
4986.     
4987.      #[Route('/metas', name: 'metas')]
4988.     public function metas( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer): Response
4989.     {
4990.         
4991.         $fluxos_abertos = $entityManager
4992.             ->getRepository(Fluxo::class)
4993.             ->fluxosAbertosComMaiorPrazo();
4994.             
4995.          $fluxos_mes = $entityManager
4996.         ->getRepository(Fluxo::class)
4997.         ->findMes();
4999.         $totalFluxos     = 0;
5000.         $clientesUnicos  = [];
5001.         $totalCaixas     = 0;
5002.         $totalDocumentos = 0;
5003.         $totalImagens    = 0;
5005.         foreach ($fluxos_mes as $fluxo) {
5007.             $totalFluxos++;
5009.             // 👇 garante cliente único
5010.             if ($fluxo->getCliente()) {
5011.                 $clienteId = $fluxo->getCliente()->getId();
5012.                 $clientesUnicos[$clienteId] = true;
5013.             }
5015.             foreach ($fluxo->getCaixas() as $caixa) {
5016.                 $totalCaixas++;
5018.                 foreach ($caixa->getDocumentos() as $documento) {
5019.                     $totalDocumentos++;
5020.                     $totalImagens += $documento->getQtd();
5021.                 }
5022.             }
5023.         }
5024.         $formatter = new \IntlDateFormatter(
5025.             'pt_BR',
5026.             \IntlDateFormatter::NONE,
5027.             \IntlDateFormatter::NONE,
5028.             'America/Sao_Paulo',
5029.             \IntlDateFormatter::GREGORIAN,
5030.             'MMMM'
5031.         );
5033.         $nomeMes = ucfirst($formatter->format(new \DateTime()));
5035.         $resumo = [
5036.             'fluxos'     => $totalFluxos,
5037.             'clientes'   => count($clientesUnicos), // ✅ não duplica
5038.             'caixas'     => $totalCaixas,
5039.             'documentos' => $totalDocumentos,
5040.             'imagens'    => $totalImagens,
5041.             'nomeMes'     => $nomeMes
5042.         ];
5044.         
5045.         $a = [];
5047.         foreach ($fluxos_abertos as $item) {
5049.             $fluxo = $item[0];
5050.             $maiorData = $item['prazo'];
5052.             $cx = 0;
5053.             $doc = 0;
5054.             $img = 0;
5055.             $cliente_id = $fluxo->getCliente()->getId();
5056.             $cliente = $doctrine->getRepository(Cliente::class)
5057.             ->createQueryBuilder('c')
5058.             ->where('c.id = :id')
5059.             ->setParameter('id', $cliente_id)
5060.             ->getQuery()
5061.             ->getOneOrNullResult();
5063.             foreach ($fluxo->getCaixas() as $caixas) {
5064.                 $cx++;
5065.                 foreach ($caixas->getDocumentos() as $docs) {
5066.                     $doc++;
5067.                     $img += $docs->getQtd();
5068.                 }
5069.             }
5071.             $a[] = [
5072.                 'fluxo'       => $fluxo->getId(),
5073.                 'cliente'     => $cliente->getNome(),
5074.                 'caixas'      => $cx,
5075.                 'documentos'  => $doc,
5076.                 'imagens'     => $img,
5077.                 'prazo'       => $maiorData,
5078.             ];
5079.         }
5080.                 
5082.         return $this->render('index/metas_fluxos.html.twig', [
5083.             'data'=>$a,
5084.             'resumo'=>$resumo
5085.     
5087.         ]);
5088.     }
5089.     
5091.     public function configureDashboard(): Dashboard
5092.     {
5093.         return Dashboard::new()
5094.             ->setTitle('IndexDoc')
5095.             ->setFaviconPath('./img/icon.png');   
5096.     }
5097.     
5099.     public function configureMenuItems(): iterable
5100.     {
5101.         // yield MenuItem::linkToDashboard('Dashboard', 'fa fa-home');
5102.         // yield MenuItem::linkToCrud('The Label', 'fas fa-list', EntityClass::class);
5103.     }
5104. }