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;
54. use App\Service\DriveToOneDriveService;
55. use Symfony\Contracts\Cache\CacheInterface;
56. use Symfony\Contracts\Cache\ItemInterface;
57. use App\Repository\DocumentoRepository;
58. use App\Repository\TipoRepository;
59. use App\Repository\ClassificacaoRepository;
60. use App\Repository\CaixaRepository;
65. class DashboardController extends AbstractDashboardController
66. {
67.     
68.     #[Route('/', name: 'inicial')]
69.     public function home(): Response
70.     {
71.         
72.         return $this->redirectToRoute('home');
75.     }
76.     
77.     #[Route('/login_sucess', name: 'login_sucess')]
78.     public function login_sucess(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager): Response
79.     {
80.         
81.     
82.         $user_logado = $this->getUser();
83.         $enabled = $user_logado->getEnabled();
85.         if (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) {
86.             $ip_cliente = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR'])[0];
87.         } else {
88.             $ip_cliente = $_SERVER['REMOTE_ADDR'];
89.         }
90.         
91.           if($enabled == false){
93.             $error ="Tentativa de login de usuário desativado";
94.             $user_logado_nome=$user_logado->getNome();
95.             $hoje = new \DateTimeImmutable('America/Sao_Paulo');
96.             $registro = new Registro();
97.             $registro->setOperacao($error);
98.             $registro->setUser($user_logado_nome);
99.             $registro->setData($hoje);
100.             $registro->setIp($ip_cliente);
101.             $entityManager->persist($registro);
102.             $entityManager->flush();
104.             return $this->redirectToRoute('app_logout');
105.         }
106.         
107.         
108.         
109.         
110.         $error ="Login Realizado";
111.         $user_logado_nome=$user_logado->getNome();
112.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
113.         $registro = new Registro();
114.         $registro->setOperacao($error);
115.         $registro->setUser($user_logado_nome);
116.         $registro->setData($hoje);
117.         $registro->setIp($ip_cliente);
118.         $entityManager->persist($registro);
119.         $entityManager->flush();
120.         
121.       
122.         
123.         
124.         return $this->redirectToRoute('home');     
126.     }
127.     
128.     #[Route('/index/home', name: 'home')]
129.     public function inicial(PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer): Response
130.     {
131.         $user_logado = $this->getUser();
132.         $user_logado_id = $user_logado->getId();
133.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
134.         $erro = '';
135.         $pagina = 'home';
136.         $p ='';
137.         
138.         $etapas  = null;
142.         if(isset($_POST["btn_cliente"])){
143.             
144.             $session->set('cliente_id', $_POST["btn_cliente"]);
145.             return $this->redirectToRoute('home');
146.         }
149.         
150.         $clienteId = $session->get('cliente_id');
151.         
152.         $etapas = $doctrine->getRepository(Etapa::class)->findByUserAndUpdatedAt($user_logado);
153.         
154.        
155.         return $this->render('index/index6.html.twig', [
156.     
157.             
158.             'p'=>$p,
159.             'erro'=>$erro,
160.             'pagina' => $pagina,
161.             'etapas'=>$etapas,
162.             'cliente' => $cliente,
163.             'clienteId' => $clienteId
164.             
165.             
167.         ]);
168.     } 
170.     #[Route('/index/troca', name: 'troca')]
171.     public function troca(SessionInterface $session): Response
172.     {
173.        
174.         $session->remove('cliente_id');
175.         $session->invalidate();
177.         return $this->redirectToRoute('home');
180.     }
182.     #[Route('/index/export', name: 'export')]
183.     public function export(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session,MessageBusInterface $bus): Response
184.     {
185.         
186.         
187.         $pendingMessages = $entityManager->getRepository(MessengerMessages::class)->countPendingMessages();
188.         
189.         #dd($pendingMessages);
190.         
191.         $user_logado = $this->getUser();
192.         $user_logado_id = $user_logado->getId();
193.         $userId = $user_logado_id;
194.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
195.         $dotenv = new Dotenv();
196.         $dotenv->load(__DIR__.'/.env');
197.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
198.         $hoje_formt=$hoje->format('Y-m-d') ;
199.         $doc = $entityManager->getRepository(Documento::class)->findByUserAndDate($user_logado_id, $hoje_formt);
200.         $dia_prod = 'de hoje';
202.         
203.    
204.         if(isset($_POST["date_perio"])){
205.             
206.             
207.             $startDate = $_POST["de"];
208.             $endDate = $_POST["ate"];
209.        
210.             $de = new \DateTimeImmutable($startDate);
211.             $ate = new \DateTimeImmutable($endDate);
212.             $de_formt=$de->format('d/m/Y') ;
213.             $ate_formt=$ate->format('d/m/Y') ;
214.             
215.             if($endDate != ""){ 
216.                 
217.                 $doc = $entityManager->getRepository(Documento::class)->findByUserAndDateRange($user_logado_id, $startDate, $endDate);
218.                 $dia_prod = 'de '. $de_formt.' até '.$ate_formt; 
219.             
220.             }
221.             if($endDate == ""){ 
222.                 
223.                 $doc = $entityManager->getRepository(Documento::class)->findByUserAndDate($user_logado_id, $startDate);
224.                 $dia_prod = 'de '. $de_formt; 
225.             }
226.             
227.             
229.         }
230.         
231.         if(isset($_POST["btn_cliente"])){
232.             
233.             $session->set('cliente_id', $_POST["btn_cliente"]);
234.             return $this->redirectToRoute('home');
235.         }
238.         $clienteId = $session->get('cliente_id');
239.         
240.         
241.         
242.         if ($clienteId == null ) {
243.             
244.             $caixas =  "";
245.             $index_all ="";
246.             $documentos="";
247.             $cliente_session = "";
248.             $cliente_alls = "";
249.        
250.         } else {
251.             $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $clienteId]);
252.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
253.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null ,'cliente' => $clienteId]);
254.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
255.             $cliente_alls = $cliente_session->getClienteAll()->getId();
256.         }
258.         $erro = '';
259.         $ii=0;
260.         $pagina = 'export';
261.         $p = '';
262.         $link = '';
263.         $mx = 0;
264.         $xy = 0 ; 
265.         $yz = 0 ; 
266.         $ay = 0 ;
267.         $ky = 0 ;
268.         $pdf ='';
269.         $pagina_h4 ='Documento(s) para indexar';
270.         $nome_menu_ = '';
271.         $index_tipo='';
272.         
273.         $user = $this->getUser();
274.         $user_nome= $user->getEmail();
275.         $user_nome_name= $user->getNome();
276.         $pasta_user=$user_nome.'/';
277.         $arr = [];
278.         $arrr=0;
279.         $index_find = null;
280.         $dt = '';
281.         $clientS3 = new  S3Client([
282.             'region'  => 'sa-east-1',
283.             'version' => 'latest',
284.             'credentials' => [ 
285.                 'key'    => $_ENV['AWS_KEY'],
286.                 'secret' => $_ENV['AWS_SECRET'],
287.             ],
288.         ]);
289.         
290.        if (isset($_POST["botao_export"])) {
291.             $caixaId = $_POST["caixas"];
292.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($_POST["caixas"]);
293.             $cliente_id = $doctrine->getRepository(Cliente::class)->find($clienteId);
294.             $clientes_status= $cliente_id->getExtraFields();
295.             if(!$clientes_status){
296.                 $clientes_status="ged";
297.             }
298.             $cliente_nome = $cliente_id->getNome();
299.             $clientes = $cliente_id->getId();
300.             $conteiner = $_POST["conteiner"];
301.             $cont_file = 0;
302.             $umlautString = $cliente_nome;
303.             $slugger = new AsciiSlugger();
304.             $teste = $slugger->slug($umlautString, $seperator = '-')->toString();
305.             $caminho = strtolower($teste . '/');
306.             if ($clientes == 14) { $caminho = 'cartorio-1deg-oficio-de-volta-redonda-rj/'; }
307.             if ($clientes == 83) { $caminho = 'casf-corretora-apolice-diversos/'; }
308.             if ($clientes == 35) { $caminho = 'pmecj-sp-saude/'; }
309.             if ($clientes == 107) { $caminho = 'pmecj-sp-execucao-fiscal/'; }
310.             if ($clientes == 4) { $caminho = 'cartorio-souza-reis-barra-mansa/'; }
311.             if ($clientes == 112) { $caminho = 'saae-cartao-de-ponto/'; }
312.             if ($clientes == 15) { $caminho = 'cbsi-dossies/'; }
313.             if ($clientes == 55) { $caminho = 'casf-gerep-contratos-de-prestadores-de-saude-pj/'; }
314.             if ($clientes == 13) { $caminho = 'casa-de-saude-santa-maria-c-s-s.M/'; }
315.             if ($clientes == 40) { $caminho = 'fasf-atas-e-diarios/'; }
316.         
317.             $filesTmp  = $_FILES['file']['tmp_name'];
318.             $filesName = $_FILES['file']['name'];
319.             
320.             foreach ($filesTmp as $index => $file) {
321.             
322.                 $uuid = Uuid::v4();
323.                 $cont_file++;
324.                 
325.                 
326.                 // nome original do arquivo
327.                 $originalName = pathinfo($filesName[$index], PATHINFO_FILENAME);
328.                 
329.                 // sanitiza o nome (remove acentos, espaços estranhos etc.)
330.                 $slugger = new AsciiSlugger();
331.                 $safeName = strtolower($slugger->slug($originalName)->toString());
332.                 
334.                 // 🔹 Se cliente for local, usa nome original
335.                 if ($clientes_status === 'local') {
336.             
337.             
338.                     $filename = $safeName . '.pdf';
339.             
340.                 } else {
341.                     if ($cliente_alls === 42) {
342.                          $filename = $originalName . '.pdf';
343.                     }else{
344.                         $filename = $uuid . '.pdf';
345.                     }
346.                 }
347.             
348.                 $tempDir = __DIR__ . '/../../var/uploads/messenger';
349.                 if (!is_dir($tempDir)) {
350.                     mkdir($tempDir, 0777, true);
351.                 }
352.             
353.                 $tempFilePath = $tempDir . '/' . $filename;
354.             
355.                 move_uploaded_file($file, $tempFilePath);
356.                 chmod($tempFilePath, 0644);
357.                 if (!file_exists($tempFilePath) || filesize($tempFilePath) === 0) {
358.                     throw new \RuntimeException(
359.                         'Falha ao gravar PDF temporário: ' . $tempFilePath
360.                     );
361.                 }
362.                 
363.                 // evita race condition de filesystem
364.                 clearstatcache(true, $tempFilePath);
365.                 
366.                 
367.                 
369.                 
370.                 $bus->dispatch(new UploadMultipartMessage(
371.                     $tempFilePath,
372.                     $filename,
373.                     $caminho,
374.                     '',
375.                     $caixaId,
376.                     $clienteId,
377.                     $userId,
378.                     0,
379.                     $conteiner,
380.                     $clientes,
381.                     $clientes_status,
382.                     $safeName,
383.                     $originalName,
384.                     $cliente_alls
385.                 ));
386.             }
387.         
388.             $log = new Registro();
389.             $log->setOperacao('EXPORTOU ' . $cont_file . ' DOCUMENTO(S)');
390.             $log->setUser($user_nome_name);
391.             $log->setCliente($cliente_nome);
392.             $entityManager->persist($log);
393.             $entityManager->flush();
394.         
395.             return $this->redirectToRoute('export');
396.         }
397.       
398.         return $this->render('index/index.html.twig', [
399.             'documentos' => $documentos,
400.             'xy' => $xy,
401.             'yz' => $yz,
402.             'ay'=>$ay,
403.             'link' => $link,
404.             'pdf'=>$pdf,
405.             'p'=>$p,
406.             'erro'=>$erro,
407.             'index_all'=>$index_all,
408.             'index_tipo'=>$index_tipo,
409.             'ky'=>$ky,
410.             'pagina' => $pagina,
411.             'pagina_h4' =>$pagina_h4,
412.             'index_find'=>$index_find,
413.             'mx'=>$mx,
414.             'caixas' => $caixas,
415.             'user_logado' => $user_logado,
416.             'cliente' => $cliente,
417.             'cliente_session' => $cliente_session,
418.             'doc'=>$doc,
419.             'dia_prod' => $dia_prod
420.         ]);
421.     }
422.     
423.     #[Route('/index/planilha', name: 'planilha')]
424.     public function planilha(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session): Response
425.     {
426.         
427.       
428.         $form = $this->createForm(UploadType::class);
429.         $user_logado= $this->getUser();
430.         $user_logado_id = $user_logado->getId();
431.         $user_nome_name= $user_logado->getNome();
432.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
433.         $form->handleRequest($request);
434.         $dotenv = new Dotenv();
435.         $dotenv->load(__DIR__.'/.env');
436.         $erro = '';
437.         $excel = 0;
438.         $pagina = 'index';
439.         $p = '';
440.         $clientS3 = new  S3Client([
441.             'region'  => 'sa-east-1',
442.             'version' => 'latest',
443.             'credentials' => [ 
444.                 'key'    => $_ENV['AWS_KEY'],
445.                 'secret' => $_ENV['AWS_SECRET'],
446.             ],
447.         ]);
448.    
449.         
450.         
451.         if(isset($_POST["btn_cliente"])){
452.             
453.             $session->set('cliente_id', $_POST["btn_cliente"]);
454.             return $this->redirectToRoute('home');
455.         }
458.         $clienteId = $session->get('cliente_id');
459.         
460.         
461.         
462.         if ($clienteId == null ) {
463.             
464.             $caixas =  "";
465.             $index_all ="";
466.             $documentos="";
467.             $cliente_session = "";
468.        
469.         } else {
470.             $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $clienteId]);
471.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
472.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null ,'cliente' => $clienteId]);
473.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
474.             $cliente_nome= $cliente_session->getNome();
475.             
476.         }
477.         
478.         
479.        
480.         
481.       
482.         if ($form->isSubmitted() && $form->isValid()) {
483.             $list =[];
484.             $file = $form['file']->getData();
485.             $spreadsheet = IOFactory::load($file->getPathname());
486.             $sheetData = $spreadsheet->getActiveSheet()->toArray();
488.             foreach ($sheetData as $row) {
489.                 $excel ++;
490.                 $id_cx = null ;
491.                 $selections = $_POST["selections"];
492.                 $nome = array_search('0', $selections);
493.                 $caixa = array_search('1', $selections);
494.                 $assunto = array_search('2', $selections);
495.                 $keywod = array_search('3', $selections);
496.                 $data_documento = array_search('4', $selections);
497.                 $data_vecimento = array_search('5', $selections);
498.                 $descricao  = array_search('6', $selections);
499.                 if ($caixa != false ) {
500.                         
501.                     
503.                     $numerosExcel = preg_replace('/\D/', '', $row[$caixa]);
506.                     foreach ($caixas as $key) {
508.                         $nome_cx = $key->getNome();
509.                         $numerosCaixa = preg_replace('/\D/', '', $nome_cx);
511.                         if ($numerosCaixa == $numerosExcel ) {
512.                             
513.                                 $id_cx = $key->getId();
514.                         }
515.                     }
516.                     
517.                     
518.                     if ($id_cx == null) {
520.                         echo '<script>alert("ERRO NA LINHA '.$excel.' NÃO EXISTE ESSA CAIXA CADASTRADA")</script>';
521.                             return $this->render('index/index2.html.twig', [
522.                             'documentos' => $documentos,
523.                             'p'=>$p,
524.                             'erro'=>$erro,
525.                             'index_all'=>$index_all,
526.                             'pagina' => $pagina,
527.                             'caixas' => $caixas,
528.                             'user_logado' => $user_logado,
529.                             'cliente' => $cliente,
530.                             'cliente_session' => $cliente_session,
531.                             'form' => $form->createView(),
532.                                             ]);
533.                     }
535.                 }
537.                 
538.                 
539.                     $yourEntity = new Documento();
540.                     // Ajuste conforme necessário
541.                     $yourEntity->setUser($user_logado);
542.                     $yourEntity->setCliente($cliente_session);
543.                     $yourEntity->setClassificacao($doctrine->getRepository(Classificacao::class)->find(1));
544.                     $yourEntity->setTipo($doctrine->getRepository(Tipo::class)->find($_POST["tipo"]));
545.                     $yourEntity->setNome($row[$nome]); 
546.                     if ($assunto != false ) {$yourEntity->setAssunto($row[$assunto]);}
547.                     if ($caixa != false ) {$yourEntity->setCaixa($doctrine->getRepository(Caixa::class)->find($id_cx));}
548.                     if ($keywod != false ) {$yourEntity->setKeywords($row[$keywod]);}
549.                     
550.                     if ($data_documento != false ) {
551.                         if (!empty(trim($row[$data_documento])) && strtoupper(trim($row[$data_documento])) !== "NULL") {
552.                             $yourEntity->setDataDocumento(new \DateTimeImmutable($row[$data_documento]));
553.                         }
554.                     }
555.                     if ($data_vecimento != false ) {
556.                         if (!empty(trim($row[$data_vecimento])) && strtoupper(trim($row[$data_vecimento])) !== "NULL") {
557.                             $yourEntity->setVencimentoDocumento(new \DateTimeImmutable($row[$data_vecimento]));
558.                         }
559.                     }
560.                     if ($descricao != false ) {$yourEntity->setExtraFields($row[$descricao]);}
561.                     $entityManager->persist($yourEntity);
562.                     $entityManager->flush();
563.                     $erro = "ok";
564.                     
565.                    
566.                     
567.             }
569.                 
570.                 $log = new Registro();
571.                 $log->setOperacao('PLANILHA EXPORTADA, '.$excel .' CADASTROS INSERIDOS.' ); 
572.                 $log->setUser($user_nome_name);
573.                 $log->setCliente($cliente_nome);
574.                 $entityManager->persist($log);
575.                 $entityManager->flush();
576.                 $erro = "ok";
577.                 if ($excel>1)  {$p =  'PLANILHA EXPORTADA COM SUCESSO, '.$excel .' CADASTROS INSERIDOS , .' ;}
578.                 if ($excel==1) {$p =  'PLANILHA EXPORTADA COM SUCESSO, '.$excel .' CADASTRO INSERIDO ,' ;}
579.             
580.         }
582.         
583.         return $this->render('index/index2.html.twig', [
584.                             'documentos' => $documentos,
585.                             'p'=>$p,
586.                             'erro'=>$erro,
587.                             'index_all'=>$index_all,
588.                             'pagina' => $pagina,
589.                             'caixas' => $caixas,
590.                             'user_logado' => $user_logado,
591.                             'cliente' => $cliente,
592.                             'cliente_session' => $cliente_session,
593.                             'form' => $form->createView(),
594.                                             ]);
595.        
596.     }
597.     
598.     #[Route('/index/planilha/classificacao', name: 'planilha_classificacao')]
599.     public function planilha_classificacao(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session): Response
600.     {
601.         
602.       
603.         $form = $this->createForm(UploadType::class);
604.         $user_logado= $this->getUser();
605.         $user_logado_id = $user_logado->getId();
606.         $user_nome_name= $user_logado->getNome();
607.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
608.         $form->handleRequest($request);
609.         $erro = '';
610.         $excel = 0;
611.         $pagina = 'index';
612.         $p = '';
615.         if(isset($_POST["btn_cliente"])){
616.             
617.             $session->set('cliente_id', $_POST["btn_cliente"]);
618.             return $this->redirectToRoute('home');
619.         }
622.         $clienteId = $session->get('cliente_id');
623.         
624.         
625.         
626.         if ($clienteId == null ) {
627.             
628.             $caixas =  "";
629.             $cliente_session = "";
630.        
631.         } else {
632.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
633.             $cliente_nome= $cliente_session->getNome();  
634.         }
635.         
636.         
637.        
638.         
639.       
640.         if ($form->isSubmitted() && $form->isValid()) {
642.             $list =[];
643.             $file = $form['file']->getData();
644.             $spreadsheet = IOFactory::load($file->getPathname());
645.             $sheetData = $spreadsheet->getActiveSheet()->toArray();
647.             foreach ($sheetData as $row) {
649.                 $excel ++;
650.                 $id_cx = null ;
651.                 $selections = $_POST["selections"];
652.                 $nome = array_search('0', $selections);
653.                 $fase_corrente = array_search('1', $selections);
654.                 $fase_intermediaria = array_search('2', $selections);
655.                 $destinacao_final = array_search('3', $selections);
656.                 $observacoes = array_search('4', $selections);
657.                 $descricao = array_search('5', $selections);
658.                 
659.                 
660.                 if($row[$nome] != null){
661.                 
662.                     $yourEntity = new Classificacao();
663.                     $yourEntity->setNome($row[$nome]);
664.                     $yourEntity->setFaseCorrente($row[$fase_corrente]);
665.                     $yourEntity->setFaseIntermediaria($row[$fase_intermediaria]);
666.                     $yourEntity->setDestinacaoFinal($row[$destinacao_final]);
667.                     $yourEntity->setObservacoes($row[$observacoes]);
668.                     $yourEntity->setExtraFields($row[$descricao]);
669.                     $yourEntity->setCliente($cliente_session);
670.                     $entityManager->persist($yourEntity);
671.                     $entityManager->flush();
672.                     $erro = "ok";
673.                 }
674.                
675.                     
676.                    
677.                     
678.             }
680.                 
681.             $log = new Registro();
682.             $log->setOperacao('PLANILHA EXPORTADA, '.$excel .' CADASTROS INSERIDOS.' ); 
683.             $log->setUser($user_nome_name);
684.             $log->setCliente($cliente_nome);
685.             $entityManager->persist($log);
686.             $entityManager->flush();
687.             $erro = "ok";
688.             if ($excel>1)  {$p =  'PLANILHA EXPORTADA COM SUCESSO, '.$excel .' CADASTROS INSERIDOS , .' ;}
689.             if ($excel==1) {$p =  'PLANILHA EXPORTADA COM SUCESSO, '.$excel .' CADASTRO INSERIDO ,' ;}
690.             
691.         }
693.         
694.         return $this->render('index/index_classificao.html.twig', [
695.                             'p'=>$p,
696.                             'erro'=>$erro,
697.                             'pagina' => $pagina,
698.                             'user_logado' => $user_logado,
699.                             'cliente' => $cliente,
700.                             'cliente_session' => $cliente_session,
701.                             'form' => $form->createView(),
702.                                             ]);
703.        
704.     }
706.     #[Route('/index/indexacao', name: 'index')]
707.     public function indexar(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager , SessionInterface $session): Response
708.     {
709.         $dotenv = new Dotenv();
710.         $dotenv->load(__DIR__.'/.env');
711.         $user_logado = $this->getUser();
712.         $form = $this->createForm(UploadType::class);
713.         $form->handleRequest($request);
714.         $user_logado_tipoAcesso = $user_logado->getTipoAcesso();
715.         $user_logado_nome = $user_logado->getNome();
716.         $user_logado_id = $user_logado->getId();
717.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
718.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
719.         $hoje_formt=$hoje->format('Y-m-d');
720.         $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $hoje_formt);
721.         $dia_prod = 'de hoje';
722.         $permissao = [];
723.         $list_indexador = [];
724.          
725.         if(isset($_POST["btn_cliente"])){
726.             
727.             $session->set('cliente_id', $_POST["btn_cliente"]);
728.             return $this->redirectToRoute('home');
729.         }
730.         $clienteId = $session->get('cliente_id');
731.         if ($clienteId == null ) {
732.             
733.             $caixas =  "";
734.             $index_all ="";
735.             $documentos="";
736.             $cliente_session = "";
737.        
738.         } else {
739.             
740.             $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $clienteId]);
741.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
742.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null ,'cliente' => $clienteId]);
743.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
744.             
745.             
746.         }
747.        
748.         if(isset($_POST["date_perio"])){
749.             
750.             
751.             $startDate = $_POST["de"];
752.             $endDate = $_POST["ate"];
753.        
754.             $de = new \DateTimeImmutable($startDate);
755.             $ate = new \DateTimeImmutable($endDate);
756.             $de_formt=$de->format('d/m/Y') ;
757.             $ate_formt=$ate->format('d/m/Y') ;
758.             
759.             if($endDate != ""){ 
760.                 
761.                 $doc = $entityManager->getRepository(Documento::class)->findByUserAndDateIndexRange($user_logado_nome, $startDate, $endDate);
762.                 $dia_prod = 'de '. $de_formt.' até '.$ate_formt; 
763.             
764.             }
765.             if($endDate == ""){ 
766.                 
767.                 $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $startDate);
768.                 $dia_prod = 'de '. $de_formt; 
769.             }
770.             
771.             
772.             
773.         }
774.        
775.         
776.         foreach ($user_logado_tipoAcesso["new"] as  $value) {
777.             
778.             foreach ($index_all as $key) {
779.                 if ( $key->getId() ==  $value) {
780.                     
781.                     $permissao[] = $value;
782.                     
783.                 }
784.                
785.             }
786.         }
787.     
788.         $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null , 'cliente' => $clienteId]);
789.         
790.         $class =  $doctrine->getRepository(Classificacao::class)->findBy(['cliente' => $clienteId]);
791.         $cliente_id = $doctrine->getRepository(Cliente::class)->findBy(['id' => $clienteId]);
792.         
793.        
794.         
795.         
796.         foreach ($cliente_id as $cliente_ids) {
797.             
798.             $cliente_nome= $cliente_ids->getNome();
799.             $clientes= $cliente_ids->getId();
800.             $umlautString =$cliente_nome;
801.             $slugger = new AsciiSlugger();
802.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
803.             $caminho = strtolower ($teste.'/');
804.                         
805.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
806.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
807.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
808.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
809.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
810.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
811.             if($clientes ==  15){$caminho='cbsi-dossies/';}
812.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
813.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
814.         }
815.         
816.         
817.         
818.         if ($clienteId == null ) {
819.             
820.             $caixas =  "";
821.        
822.         } else {
823.             
824.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
825.         }   
826.             
827.            
828.         $erro = '';
829.         $ii=0;
830.         $pagina = 'index';
831.         $p = '';
832.         $link = '';
833.         $mx = 0;
834.         $xy = 0 ; 
835.         $yz = 0 ; 
836.         $ay = 0 ;
837.         $ky = 0 ;
838.         $pdf ='';
839.         $pagina_h4 ='Documento(s) para indexar';
840.         $nome_menu_ = '';
841.         $index_tipo='';
842.         $uuid = Uuid::v4();
843.         $user = $this->getUser();
844.         $user_nome= $user->getEmail();
845.         $user_nome_name= $user->getNome();
846.         $pasta_user=$user_nome.'/';
847.         $arr = [];
848.         $arrr=0;
849.         $index_find = null;
850.         $dt = '';
851.         $clientS3 = new  S3Client([
852.                     'region'  => 'sa-east-1',
853.                     'version' => 'latest',
854.                     'credentials' => [ 
855.                         'key'    => $_ENV['AWS_KEY'],
856.                         'secret' => $_ENV['AWS_SECRET'],
857.                     ],
858.                 ]);
859.         
860.      
861.             
862.         if(isset($_POST["dt"]))
863.         {   
865.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => $_POST["dt"]]);
866.             $index_find =  $doctrine->getRepository(Tipo::class)->find($_POST["dt"]);
867.             $pagina =$index_find->getNome();
868.             $pagina_h4 ='Documento(s) do tipo ( '.$pagina.' )';
869.             
870.             
871.         }
872.        
873.         if(isset($_POST["botao_index"])){
874.             
875.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
876.             $link = $pdf->getImage();
877.             $xy = 1 ;
878.             
879.         }
880.         if(isset($_POST["botao_doc"])){
881.             
882.             
883.             $yz = 0 ;
884.             $xy = 1 ;
885.             $ay = 1 ;
886.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
887.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
888.            
889.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
890.             $index_tipo_tipo =  $index_tipo->getNome();
891.             $link = $pdf->getImage();
892.             $fase=$_POST["fase"];
893.             $data = $_POST["data"];
894.             $cx = $_POST["caixas"];
895.             $classifica = $_POST["classifica"];
896.             $fase = $_POST["fase"];
897.             $desc = $_POST["desc"];
898.             $assunto = $_POST["assunto"];
899.             $chave = $_POST["chave"];
900.             $nome = $_POST["nome"];
901.             $conteiner = $_POST["conteiner"];
902.             
904.           
905.             
906.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($cx);
907.             
908.             
909.             
910.             // Encontra todos os números na frase
911.             preg_match_all('/\d+/', $fase, $matches);
913.             // $matches[0] agora contém todos os números encontrados na frase
914.             $numeros = array_map('intval', $matches[0]);
916.             // Exibe os números encontrados
917.             
918.             if ($clientes != 7) {
919.            
920.                 if ($data != "") {
921.                     
922.                     if ($fase != "") {
923.     
924.                         // Número inteiro que você deseja somar ao ano
925.                         $numeroParaSomar = $numeros[0];
926.     
927.                         // Extrair o ano da data
928.                         list($ano, $mes, $dia) = explode('-', $data);
929.     
930.                         // Converter o ano para um número inteiro
931.                         $ano = intval($ano);
932.     
933.                         // Somar o número ao ano
934.                         $data_vecimento =  $ano + $numeroParaSomar.'-'.$mes.'-'. $dia;
935.     
936.                         $pdf->setVencimentoDocumento(new \DateTimeImmutable($data_vecimento));
937.     
938.                     }
939.                 $pdf->setDataDocumento(new \DateTimeImmutable($data));
940.                 }
941.             }    
942.             
943.             if ($clientes == 7) {
944.                   
945.                   $pdf->setVencimentoDocumento(new \DateTimeImmutable($fase));
946.                   $pdf->setDataDocumento(new \DateTimeImmutable($data));
947.              }
948.              
949.             $pdf->setAssunto($assunto);
951.             if ($classifica != "") {
953.                 $classifica_id = $doctrine->getRepository(Classificacao::class)->find($classifica);
954.                 $pdf->setClassificacao($classifica_id);
955.             }
957.             $pdf->setCaixa($caixa_id);
958.             $pdf->setExtraFields($desc);
959.             $pdf->setNome($nome);
960.             $pdf->setKeywords($chave);
961.             $pdf->setUserIndex($user_nome_name);
962.             $pdf->setConteiner($conteiner);
963.             $pdf->setIndexAt(new \DateTimeImmutable('America/Sao_Paulo'));
964.             $pdf->setTipo($index_tipo);
965.             $entityManager->flush();
966.             $id_pd = $pdf->getId();    
967.             $log = new Registro();
968.             $log->setOperacao('Indexou o Documento com id '.$id_pd); 
969.             $log->setUser($user_nome_name);
970.             $log->setCliente($cliente_nome);
971.             $entityManager->persist($log);
972.             $entityManager->flush();
973.             $erro = 'ok';
974.             $p =  $index_tipo_tipo.' indexado com sucesso';
975.             
978.            
979.             
980.            
981.         }   
982.         if(isset($_POST["botao_index_edit"])){
983.             
984.             $yz = 0 ;
985.             $xy = 1 ;
986.             $ay = 1 ;
987.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
988.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
989.             $link = $pdf->getImage();
990.         }
991.         if(isset($_POST["botao_volta"])){
993.             $xy = 0 ;
994.             $yz = 0 ;
995.         }
996.         if(isset($_POST["index_button"])){
997.             
998.             
999.             $yz = 0 ;
1000.             $xy = 1 ;
1001.             $ay = 1 ;
1002.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1003.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["index_button"]);
1004.             $link = $pdf->getImage();
1005.         }
1006.         if(isset($_POST["botao_cancel"])){
1007.             $yz = 0 ;
1008.             $xy = 1 ;
1009.             $ay = 0 ;
1010.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1011.             $link = $pdf->getImage();
1012.             
1013.         }
1014.         if(isset($_POST["delet"])){
1015.            
1016.             $ky = 1 ;
1017.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["delet"]);
1018.             $documentos = $doctrine->getRepository(Documento::class)->findBy(['id' => $_POST["delet"]]);
1019.             
1020.             if($pdf->getTipo()!= null){
1021.                 $index_find =  $doctrine->getRepository(Tipo::class)->find($pdf->getTipo());
1022.                 $pagina =$index_find->getTipo();
1023.                 $pagina_h4 ='Documento(s) do tipo ( '.$index_find->getTipo().' )';
1024.             }
1025.                         
1026.         }
1027.         if(isset($_POST["delet_cancel"])){
1028.             $ky = 0 ;
1029.         }
1030.         if(isset($_POST["delet_sim"])){
1031.             
1032.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
1033.             $id_pd = $pdf->getId();
1034.             $entityManager->remove($pdf);
1035.             $entityManager->flush();
1036.           
1037.             $log = new Registro();
1038.             $log->setOperacao('Excluiu Documento com id '.$id_pd); 
1039.             $log->setUser($user_nome_name);
1040.             $log->setCliente($cliente_nome);
1041.             $entityManager->persist($log);
1042.             $entityManager->flush();
1043.             $erro = 'ok';
1044.             $p = 'Documento com id '.$id_pd.' excluido com sucesso '; 
1045.         }
1046.         if(isset($_POST["index_edit"])){
1047.             $yz = 0 ;
1048.             $xy = 1 ;
1049.             $ay = 2 ;
1050.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1051.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
1052.             $link = $pdf->getImage();
1053.         }
1054.        
1055.        
1056.         $cmd = $clientS3->getCommand('GetObject', [
1057.                 'Bucket' => 'arquivosdoc',
1058.                 'Key'    => $caminho. $link, 
1059.             ]);
1060.             
1061.             $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
1062.             $all_Url = (string) $req->getUri();
1063.         return $this->render('index/index1.html.twig', [
1064.             'documentos' => $documentos,
1065.             'xy' => $xy,
1066.             'yz' => $yz,
1067.             'ay'=>$ay,
1068.             'link' => $link,
1069.             'pdf'=>$pdf,
1070.             'p'=>$p,
1071.             'erro'=>$erro,
1072.             'index_all'=>$index_all,
1073.             'index_tipo'=>$index_tipo,
1074.             'ky'=>$ky,
1075.             'pagina' => $pagina,
1076.             'pagina_h4' =>$pagina_h4,
1077.             'index_find'=>$index_find,
1078.             'mx'=>$mx,
1079.             'caixas' => $caixas,
1080.             'class' => $class,
1081.             'permissao'=>$permissao,
1082.             'caminho' =>$caminho,
1083.             'clientes' => $clientes,
1084.             'doc'=>$doc,
1085.             'dia_prod' => $dia_prod,
1086.             'cliente_session' => $cliente_session,
1087.             'all_Url'=>$all_Url
1088.         ]);
1091.     }
1092.     
1093.     
1094.     #[Route('/index/corre', name: 'index_corre')]
1095.     public function index_corre(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager , SessionInterface $session): Response
1096.     {
1097.         $dotenv = new Dotenv();
1098.         $dotenv->load(__DIR__.'/.env');
1099.         $user_logado = $this->getUser();
1100.         $form = $this->createForm(UploadType::class);
1101.         $form->handleRequest($request);
1102.         $user_logado_tipoAcesso = $user_logado->getTipoAcesso();
1103.         $user_logado_nome = $user_logado->getNome();
1104.         $user_logado_id = $user_logado->getId();
1105.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
1106.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
1107.         $hoje_formt=$hoje->format('Y-m-d');
1108.         $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $hoje_formt);
1109.         $dia_prod = 'de hoje';
1110.         $permissao = [];
1111.         $list_indexador = [];
1112.          
1113.         if(isset($_POST["btn_cliente"])){
1114.             
1115.             $session->set('cliente_id', $_POST["btn_cliente"]);
1116.             return $this->redirectToRoute('home');
1117.         }
1118.         $clienteId = $session->get('cliente_id');
1119.         if ($clienteId == null ) {
1120.             
1121.             $caixas =  "";
1122.             $index_all ="";
1123.             $documentos="";
1124.             $cliente_session = "";
1125.        
1126.         } else {
1127.             
1128.             $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $clienteId]);
1129.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
1130.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => null ,'cliente' => $clienteId]);
1131.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);
1132.             
1133.             
1134.         }
1135.        
1136.         if(isset($_POST["date_perio"])){
1137.             
1138.             
1139.             $startDate = $_POST["de"];
1140.             $endDate = $_POST["ate"];
1141.        
1142.             $de = new \DateTimeImmutable($startDate);
1143.             $ate = new \DateTimeImmutable($endDate);
1144.             $de_formt=$de->format('d/m/Y') ;
1145.             $ate_formt=$ate->format('d/m/Y') ;
1146.             
1147.             if($endDate != ""){ 
1148.                 
1149.                 $doc = $entityManager->getRepository(Documento::class)->findByUserAndDateIndexRange($user_logado_nome, $startDate, $endDate);
1150.                 $dia_prod = 'de '. $de_formt.' até '.$ate_formt; 
1151.             
1152.             }
1153.             if($endDate == ""){ 
1154.                 
1155.                 $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $startDate);
1156.                 $dia_prod = 'de '. $de_formt; 
1157.             }
1158.             
1159.             
1160.             
1161.         }
1162.        
1163.         
1164.         foreach ($user_logado_tipoAcesso["new"] as  $value) {
1165.             
1166.             foreach ($index_all as $key) {
1167.                 if ( $key->getId() ==  $value) {
1168.                     
1169.                     $permissao[] = $value;
1170.                     
1171.                 }
1172.                
1173.             }
1174.         }
1175.         $ids = [
1176.             6872304, 6818199, 6869816, 6869252, 6821222, 6869814, 6866863, 6852698,
1177.             6818244, 6872298, 6826550, 6867034, 6869774, 6868323, 6823222, 6868678,
1178.             6862719, 6826530, 6819080, 6868011, 6823849, 6868443, 6823107, 6858469,
1179.             6819006, 6872241, 6872243, 6836508, 6836538, 6823231, 6841051, 6862616,
1180.             6836483, 6836476, 6823024, 6868690, 6868662, 6867891, 6836582, 6868372,
1181.             6836482, 6823893, 6872268, 6834758, 6821087, 6867018, 6836503, 6872202,
1182.             6836479, 6818242, 6863718, 6834830, 6867256, 6872259, 6868597, 6834172,
1183.             6836492, 6869376, 6818965, 6872168, 6868595, 6860317, 6859908, 6868330,
1184.             6839939, 6872285, 6869366, 6862659, 6824620, 6869847, 6818237, 6834659,
1185.             6834917, 6866975, 6869454, 6861937, 6863512, 6834747, 6819937, 6834280,
1186.             6832406, 6862744, 6818963, 6836480, 6872203, 6818830, 6823892, 6831255,
1187.             6816562, 6872201, 6831256, 6866999, 6836481, 6868423, 6816568, 6862679,
1188.             6868314, 6866634, 6839557, 6869243, 6859933, 6869515, 6832578, 6836535,
1189.             6823855, 6823845, 6823876, 6832397, 6836478, 6863719, 6859935, 6871251,
1190.             6869513, 6869510, 6835848, 6831156, 6836517
1191.         ];
1192.             
1193.         $qb = $doctrine->getRepository(Documento::class)->createQueryBuilder('d');
1195.         $documentos = $qb
1196.             ->where('d.id IN (:ids)')
1197.             ->andWhere(
1198.                 $qb->expr()->orX(
1199.                     'd.extraFields IS NULL',
1200.                     'd.dataDocumento IS NULL'
1201.                 )
1202.             )
1203.             ->setParameter('ids', $ids)
1204.             ->getQuery()
1205.             ->getResult();
1206.         
1208.         $class =  $doctrine->getRepository(Classificacao::class)->findBy(['cliente' => $clienteId]);
1209.         $cliente_id = $doctrine->getRepository(Cliente::class)->findBy(['id' => $clienteId]);
1210.         
1211.        
1212.         
1213.         
1214.         foreach ($cliente_id as $cliente_ids) {
1215.             
1216.             $cliente_nome= $cliente_ids->getNome();
1217.             $clientes= $cliente_ids->getId();
1218.             $umlautString =$cliente_nome;
1219.             $slugger = new AsciiSlugger();
1220.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
1221.             $caminho = strtolower ($teste.'/');
1222.                         
1223.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
1224.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
1225.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
1226.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
1227.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
1228.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
1229.             if($clientes ==  15){$caminho='cbsi-dossies/';}
1230.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
1231.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
1232.         }
1233.         
1234.         
1235.         
1236.         if ($clienteId == null ) {
1237.             
1238.             $caixas =  "";
1239.        
1240.         } else {
1241.             
1242.             $caixas = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($clienteId);
1243.         }   
1244.             
1245.            
1246.         $erro = '';
1247.         $ii=0;
1248.         $pagina = 'index';
1249.         $p = '';
1250.         $link = '';
1251.         $mx = 0;
1252.         $xy = 0 ; 
1253.         $yz = 0 ; 
1254.         $ay = 0 ;
1255.         $ky = 0 ;
1256.         $pdf ='';
1257.         $pagina_h4 ='Documento(s) para indexar';
1258.         $nome_menu_ = '';
1259.         $index_tipo='';
1260.         $uuid = Uuid::v4();
1261.         $user = $this->getUser();
1262.         $user_nome= $user->getEmail();
1263.         $user_nome_name= $user->getNome();
1264.         $pasta_user=$user_nome.'/';
1265.         $arr = [];
1266.         $arrr=0;
1267.         $index_find = null;
1268.         $dt = '';
1269.         $clientS3 = new  S3Client([
1270.                     'region'  => 'sa-east-1',
1271.                     'version' => 'latest',
1272.                     'credentials' => [ 
1273.                         'key'    => $_ENV['AWS_KEY'],
1274.                         'secret' => $_ENV['AWS_SECRET'],
1275.                     ],
1276.                 ]);
1277.         
1278.      
1279.             
1280.         if(isset($_POST["dt"]))
1281.         {   
1283.             $documentos =  $doctrine->getRepository(Documento::class)->findBy(['tipo' => $_POST["dt"]]);
1284.             $index_find =  $doctrine->getRepository(Tipo::class)->find($_POST["dt"]);
1285.             $pagina =$index_find->getNome();
1286.             $pagina_h4 ='Documento(s) do tipo ( '.$pagina.' )';
1287.             
1288.             
1289.         }
1290.        
1291.         if(isset($_POST["botao_index"])){
1292.             
1293.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
1294.             $link = $pdf->getImage();
1295.             $xy = 1 ;
1296.             
1297.         }
1298.         if(isset($_POST["botao_doc"])){
1299.             
1300.             
1301.             $yz = 0 ;
1302.             $xy = 1 ;
1303.             $ay = 1 ;
1304.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1305.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
1306.            
1307.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
1308.             $index_tipo_tipo =  $index_tipo->getNome();
1309.             $link = $pdf->getImage();
1310.             $fase=$_POST["fase"];
1311.             $data = $_POST["data"];
1312.             $cx = $_POST["caixas"];
1313.             $classifica = $_POST["classifica"];
1314.             $fase = $_POST["fase"];
1315.             $desc = $_POST["desc"];
1316.             $assunto = $_POST["assunto"];
1317.             $chave = $_POST["chave"];
1318.             $nome = $_POST["nome"];
1319.             $conteiner = $_POST["conteiner"];
1320.             
1322.           
1323.             
1324.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($cx);
1325.             
1326.             
1327.             
1328.             // Encontra todos os números na frase
1329.             preg_match_all('/\d+/', $fase, $matches);
1331.             // $matches[0] agora contém todos os números encontrados na frase
1332.             $numeros = array_map('intval', $matches[0]);
1334.             // Exibe os números encontrados
1335.             
1336.             if ($clientes != 7) {
1337.            
1338.                 if ($data != "") {
1339.                     
1340.                     if ($fase != "") {
1341.     
1342.                         // Número inteiro que você deseja somar ao ano
1343.                         $numeroParaSomar = $numeros[0];
1344.     
1345.                         // Extrair o ano da data
1346.                         list($ano, $mes, $dia) = explode('-', $data);
1347.     
1348.                         // Converter o ano para um número inteiro
1349.                         $ano = intval($ano);
1350.     
1351.                         // Somar o número ao ano
1352.                         $data_vecimento =  $ano + $numeroParaSomar.'-'.$mes.'-'. $dia;
1353.     
1354.                         $pdf->setVencimentoDocumento(new \DateTimeImmutable($data_vecimento));
1355.     
1356.                     }
1357.                 $pdf->setDataDocumento(new \DateTimeImmutable($data));
1358.                 }
1359.             }    
1360.             
1361.             if ($clientes == 7) {
1362.                   
1363.                   $pdf->setVencimentoDocumento(new \DateTimeImmutable($fase));
1364.                   $pdf->setDataDocumento(new \DateTimeImmutable($data));
1365.              }
1366.              
1367.             $pdf->setAssunto($assunto);
1369.             if ($classifica != "") {
1371.                 $classifica_id = $doctrine->getRepository(Classificacao::class)->find($classifica);
1372.                 $pdf->setClassificacao($classifica_id);
1373.             }
1375.             $pdf->setExtraFields($desc);
1376.             $pdf->setNome($nome);
1377.             $pdf->setKeywords($chave);
1378.             $pdf->setUserIndex($user_nome_name);
1379.             $pdf->setConteiner($conteiner);
1380.             $pdf->setIndexAt(new \DateTimeImmutable('America/Sao_Paulo'));
1381.             $pdf->setTipo($index_tipo);
1382.             $entityManager->flush();
1383.             $id_pd = $pdf->getId();    
1384.             $log = new Registro();
1385.             $log->setOperacao('Indexou o Documento com id '.$id_pd); 
1386.             $log->setUser($user_nome_name);
1387.             $log->setCliente($cliente_nome);
1388.             $entityManager->persist($log);
1389.             $entityManager->flush();
1390.             $erro = 'ok';
1391.             $p =  $index_tipo_tipo.' indexado com sucesso';
1392.             
1395.            
1396.             
1397.            
1398.         }   
1399.         if(isset($_POST["botao_index_edit"])){
1400.             
1401.             $yz = 0 ;
1402.             $xy = 1 ;
1403.             $ay = 1 ;
1404.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
1405.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
1406.             $link = $pdf->getImage();
1407.         }
1408.         if(isset($_POST["botao_volta"])){
1410.             $xy = 0 ;
1411.             $yz = 0 ;
1412.         }
1413.         if(isset($_POST["index_button"])){
1414.             
1415.             
1416.             $yz = 0 ;
1417.             $xy = 1 ;
1418.             $ay = 1 ;
1419.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1420.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["index_button"]);
1421.             $link = $pdf->getImage();
1422.         }
1423.         if(isset($_POST["botao_cancel"])){
1424.             $yz = 0 ;
1425.             $xy = 1 ;
1426.             $ay = 0 ;
1427.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1428.             $link = $pdf->getImage();
1429.             
1430.         }
1431.         if(isset($_POST["delet"])){
1432.            
1433.             $ky = 1 ;
1434.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["delet"]);
1435.             $documentos = $doctrine->getRepository(Documento::class)->findBy(['id' => $_POST["delet"]]);
1436.             
1437.             if($pdf->getTipo()!= null){
1438.                 $index_find =  $doctrine->getRepository(Tipo::class)->find($pdf->getTipo());
1439.                 $pagina =$index_find->getTipo();
1440.                 $pagina_h4 ='Documento(s) do tipo ( '.$index_find->getTipo().' )';
1441.             }
1442.                         
1443.         }
1444.         if(isset($_POST["delet_cancel"])){
1445.             $ky = 0 ;
1446.         }
1447.         if(isset($_POST["delet_sim"])){
1448.             
1449.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
1450.             $id_pd = $pdf->getId();
1451.             $entityManager->remove($pdf);
1452.             $entityManager->flush();
1453.           
1454.             $log = new Registro();
1455.             $log->setOperacao('Excluiu Documento com id '.$id_pd); 
1456.             $log->setUser($user_nome_name);
1457.             $log->setCliente($cliente_nome);
1458.             $entityManager->persist($log);
1459.             $entityManager->flush();
1460.             $erro = 'ok';
1461.             $p = 'Documento com id '.$id_pd.' excluido com sucesso '; 
1462.         }
1463.         if(isset($_POST["index_edit"])){
1464.             $yz = 0 ;
1465.             $xy = 1 ;
1466.             $ay = 2 ;
1467.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
1468.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
1469.             $link = $pdf->getImage();
1470.         }
1471.        
1472.        
1473.         $cmd = $clientS3->getCommand('GetObject', [
1474.                 'Bucket' => 'arquivosdoc',
1475.                 'Key'    => $caminho. $link, 
1476.             ]);
1477.             
1478.             $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
1479.             $all_Url = (string) $req->getUri();
1480.         return $this->render('index/index1.html.twig', [
1481.             'documentos' => $documentos,
1482.             'xy' => $xy,
1483.             'yz' => $yz,
1484.             'ay'=>$ay,
1485.             'link' => $link,
1486.             'pdf'=>$pdf,
1487.             'p'=>$p,
1488.             'erro'=>$erro,
1489.             'index_all'=>$index_all,
1490.             'index_tipo'=>$index_tipo,
1491.             'ky'=>$ky,
1492.             'pagina' => $pagina,
1493.             'pagina_h4' =>$pagina_h4,
1494.             'index_find'=>$index_find,
1495.             'mx'=>$mx,
1496.             'caixas' => $caixas,
1497.             'class' => $class,
1498.             'permissao'=>$permissao,
1499.             'caminho' =>$caminho,
1500.             'clientes' => $clientes,
1501.             'doc'=>$doc,
1502.             'dia_prod' => $dia_prod,
1503.             'cliente_session' => $cliente_session,
1504.             'all_Url'=>$all_Url
1505.         ]);
1508.     }
1509.     
1510.     #[Route('/index/novo/fluxo', name: 'fluxo_novo')]
1511.     public function fluxoNovo(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer): Response
1512.     {
1513.         $user_logado = $this->getUser();
1514.         $user_logado_nome = $user_logado->getNome();
1515.         $user_logado_id = $user_logado->getId();
1516.         $erro = '';
1517.         $pagina = 'fluxo';
1518.         $p ='';
1519.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
1520.         
1521.         if(isset($_POST["btn_cliente"])){
1522.             
1523.             $session->set('cliente_id', $_POST["btn_cliente"]);
1524.             return $this->redirectToRoute('home');
1525.         }
1528.         $clienteId = $session->get('cliente_id');
1529.         
1530.       
1531.         
1532.         if ($clienteId == null ) {
1533.             
1534.             $cli =  "";
1535.             return $this->redirectToRoute('home');
1536.           
1537.        
1538.         } else {
1539.             
1540.          
1541.             $cli = $doctrine->getRepository(Cliente::class)->find($clienteId);
1542.             
1543.         }
1544.         
1546.         $query = $doctrine->getManager()->createQuery('
1547.             SELECT u
1548.             FROM App\Entity\User u
1549.             JOIN u.clientes c
1550.             WHERE c.id = :clientId
1551.             AND u.enabled = 1
1552.         ')->setParameter('clientId', $clienteId);
1554.         $usuarios = $query->getArrayResult();
1556.         if(isset($_POST["fluxo"])){
1557.             
1558.             $fluxo = new Fluxo();
1559.             $nome = $cli->getNome();
1560.             $fluxo->setNome($nome);
1561.             $fluxo->setUser($user_logado);
1562.             $fluxo->setCliente($cli);
1563.             $fluxo->setObs($_POST["obs"]);
1564.             $entityManager->persist($fluxo);
1565.             $entityManager->flush();
1566.             $id_fluxo = $fluxo->getId(); 
1567.             
1568.             $prazo = $_POST["prazo"];
1569.             $user_1 = $_POST["user"];
1571.             
1573.             foreach ($user_1 as $users) {
1574.                
1575.                     $etapa = new Etapa();
1576.                     $user = $doctrine->getRepository(User::class)->find($users);
1577.                     $mail = $user->getEmail();
1578.                     
1579.                    
1580.                     $etapa->setNome($_POST["etapa"]);
1581.                     $etapa->setOrdem(1);
1582.                     $etapa->setUser($user);
1583.                     $etapa->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1584.                     $etapa->setPrazo(new \DateTimeImmutable($prazo));
1585.                     $entityManager->persist($etapa);
1586.                     $entityManager->flush();
1587.         
1588.                     /*$email = (new Email())
1589.                         ->from('arquivosdoc@arquivosdoc.com.br')
1590.                         ->to($mail)
1591.                         ->subject('Fluxo de Trabalho')
1592.                         ->html('<div style="text-align: center;">
1593.                             <h1 style="color:#1e4067;">Recebimento<br>
1594.                             Cliente: '.$nome.'<br>
1595.                             Prazo:'.$prazo.'<br>
1596.                             Enviado por: '.$user_logado_nome.'<br>
1597.                             Acesse sua pagina inicial no <a href="https://ged.arquivosdoc.com.br/login">ArquivosGED
1598.                             </a></h1>
1599.                             <img src="cid:logo"><div>')
1600.                         ->embed(fopen('C:/xampp8/htdocs/gedemail/public/img/icon.png', 'r'), 'logo', 'image/png');
1601.                     $mailer->send($email);*/
1602.                     
1603.                  
1604.             }
1605.             
1606.             if(isset($_POST["user_2"])){
1607.                 
1608.                 
1609.                 $prazo_2 = $_POST["prazo_2"];
1610.                 $user_2 = $_POST["user_2"];
1612.                 foreach ($user_2 as $users2) {
1613.                     $etapa2 = new Etapa();
1614.                     $etapa2->setNome($_POST["etapa2"]);
1615.                     $etapa2->setOrdem(2);
1616.                     $etapa2->setUser($doctrine->getRepository(User::class)->find($users2));
1617.                     $etapa2->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1618.                     $etapa2->setPrazo(new \DateTimeImmutable($prazo_2));
1619.                     $entityManager->persist($etapa2);
1620.                     $entityManager->flush();
1622.                 }
1623.             }
1625.             if(isset($_POST["user_3"])){
1626.                 
1627.                 
1628.                 $user_3 = $_POST["user_3"];
1629.                 $prazo_3 = $_POST["prazo_3"];
1631.                 foreach ($user_3 as $users3) {
1632.                     $etapa3 = new Etapa();
1633.                     $etapa3->setNome($_POST["etapa3"]);
1634.                     $etapa3->setOrdem(3);
1635.                     $etapa3->setUser($doctrine->getRepository(User::class)->find($users3));
1636.                     $etapa3->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1637.                     $etapa3->setPrazo(new \DateTimeImmutable($prazo_3));
1638.                     $entityManager->persist($etapa3);
1639.                     $entityManager->flush();
1640.                 }    
1641.             }
1643.             if(isset($_POST["user_4"])){
1645.                 
1646.                 $user_4 = $_POST["user_4"];
1647.                 $prazo_4 = $_POST["prazo_4"];
1649.                 foreach ($user_4 as $users4) {
1650.                     $etapa4 = new Etapa();
1651.                     $etapa4->setNome($_POST["etapa4"]);
1652.                     $etapa4->setOrdem(4);
1653.                     $etapa4->setUser($doctrine->getRepository(User::class)->find($users4));
1654.                     $etapa4->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1655.                     $etapa4->setPrazo(new \DateTimeImmutable($prazo_4));
1656.                     $entityManager->persist($etapa4);
1657.                     $entityManager->flush();
1659.                 }
1660.             } 
1661.             
1662.             
1663.             if(isset($_POST["user_5"])){
1665.                 
1666.                 $user_5 = $_POST["user_5"];
1667.                 $prazo_5 = $_POST["prazo_5"];
1668.                 foreach ($user_5 as $users5) {
1670.                     $etapa5 = new Etapa();
1671.                     $etapa5->setNome($_POST["etapa5"]);
1672.                     $etapa5->setOrdem(5);
1673.                     $etapa5->setUser($doctrine->getRepository(User::class)->find($users5));
1674.                     $etapa5->setFluxo($doctrine->getRepository(Fluxo::class)->find($id_fluxo));
1675.                     $etapa5->setPrazo(new \DateTimeImmutable($prazo_5));
1676.                     $entityManager->persist($etapa5);
1677.                     $entityManager->flush();
1678.                 }
1679.             } 
1681.             $erro = "ok";
1682.             $p =  'FLUXO ENVIADO' ;
1683.             
1684.             
1685.         }
1686.         
1687.     
1688.        
1689.         return $this->render('index/index4.html.twig', [
1690.     
1691.             
1692.             'p'=>$p,
1693.             'erro'=>$erro,
1694.             'pagina' => $pagina,
1695.             'usuarios' =>$usuarios,
1696.             'cliente' => $cliente
1697.             
1699.         ]);
1700.     }
1702.     #[Route('/index/fluxo', name: 'fluxo')]
1703.     public function fluxo( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer): Response
1704.     {
1705.         $user_logado = $this->getUser();
1706.         $erro = '';
1707.         $pagina = 'fluxo';
1708.         $p ='';
1709.         #$registro = $doctrine->getRepository(Registro::class)->findAll();
1710.         $a = 0;
1711.         $clientS3 = new  S3Client([
1712.             'region'  => 'sa-east-1',
1713.             'version' => 'latest',
1714.             'credentials' => [ 
1715.                 'key'    => $_ENV['AWS_KEY'],
1716.                 'secret' => $_ENV['AWS_SECRET'],
1717.             ],
1718.         
1719.         ]);
1721.         
1723.     
1724.         if(isset($_POST["btn_cliente"])){
1725.             
1726.             $session->set('cliente_id', $_POST["btn_cliente"]);
1727.             return $this->redirectToRoute('home');
1728.         }
1731.         $clienteId = $session->get('cliente_id');
1732.         
1733.         if($clienteId == null){
1734.             
1735.             return $this->redirectToRoute('home');
1736.         }
1737.         
1738.         $cliente = $doctrine->getRepository(Cliente::class)->find($clienteId);
1739.         $fluxo = $doctrine->getRepository(Fluxo::class)->findBy(['cliente' => $clienteId],['id'=> 'DESC']);
1740.       
1741.         
1742.         // Paginar os fluxos
1743.         $fluxos = $paginator->paginate(
1744.             $fluxo, // O queryBuilder ou a query
1745.             $request->query->getInt('page', 1), // A página atual, padrão é 1
1746.             2 // O número de itens por página
1747.         );
1750.         if (isset($_POST["excel"])) {
1751.             
1752.         
1753.             $cx = null;
1754.             $id_fluxo = $_POST["excel"];
1755.             $fluxo_excel = $doctrine->getRepository(Fluxo::class)->find($id_fluxo);
1756.             $nome_fluxo = $fluxo_excel->getNome();
1757.             $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_excel->getId());
1758.             
1759.             
1760.         
1761.             // Cria uma nova planilha
1762.             $spreadsheet = new Spreadsheet();
1763.             $sheet = $spreadsheet->getActiveSheet();
1764.             $sheet->setTitle('CAIXA(S)');
1765.             // Configura o cabeçalho
1766.             $sheet->setCellValue('A1', 'ID');
1767.             $sheet->setCellValue('B1', 'REPOSITOR');
1768.             $sheet->setCellValue('C1', 'DATA DO ENVIO');
1769.         
1770.             // Estiliza o cabeçalho (fundo azul, texto branco e negrito)
1771.             $headerStyle = [
1772.                 'font' => [
1773.                     'bold' => true,
1774.                     'color' => ['rgb' => 'FFFFFF'], // Texto branco
1775.                 ],
1776.                 'fill' => [
1777.                     'fillType' => Fill::FILL_SOLID,
1778.                     'startColor' => ['rgb' => '095f99'], // Fundo azul
1779.                 ],
1780.             ];
1781.             $sheet->getStyle('A1:C1')->applyFromArray($headerStyle);
1782.         
1783.             // Preenche os dados
1784.             $rowCount = 2;
1785.             foreach ($fluxo_caixas as $caixas) {
1786.                 
1787.                     if($caixas->getCx() != null){
1788.                     
1789.                     $nome = $caixas->getNome();
1790.                     $cx = $caixas->getCx()->getNome();
1791.                     $data = $caixas->getCreatedAt();
1792.             
1793.                     // Insere os valores
1794.                     $sheet->setCellValue('A' . $rowCount, $cx);
1795.                     $sheet->setCellValue('B' . $rowCount, $nome);
1796.             
1797.                     // Converte a data para o formato Excel
1798.                     if ($data instanceof \DateTime) {
1799.                         $sheet->setCellValue('C' . $rowCount, Date::PHPToExcel($data));
1800.                     } else {
1801.                         $sheet->setCellValue('C' . $rowCount, $data); // Evita erro se não for DateTime
1802.                     }
1803.             
1804.                     $rowCount++;
1805.                 }
1806.             }
1807.         
1808.             // Formata a coluna C como data (exceto o cabeçalho)
1809.             $sheet->getStyle('C2:C' . ($rowCount - 1))
1810.                 ->getNumberFormat()
1811.                 ->setFormatCode('dd/mm/yyyy');
1812.         
1813.             // Define largura automática das colunas
1814.             foreach (range('A', 'C') as $col) {
1815.                 $sheet->getColumnDimension($col)->setAutoSize(true);
1816.             }
1819.              // Segunda aba - Outras informações (Exemplo)
1820.             $sheet2 = $spreadsheet->createSheet(); // Cria uma nova aba
1821.             $sheet2->setTitle('DOCUMENTO(S)'); // Renomeia a aba
1822.             $sheet2->setCellValue('A1' , 'ID');
1823.             $sheet2->setCellValue('B1' , 'NOME');
1824.             $sheet2->setCellValue('C1' , 'REPOSITOR');
1825.             $sheet2->setCellValue('D1' , 'TIPO');
1826.             $sheet2->setCellValue('E1' , 'ASSUNTO');
1827.             $sheet2->setCellValue('F1' , 'PALAVRA-CHAVE');
1828.             $sheet2->setCellValue('G1' , 'DIGITALIZAÇÃO');
1829.             $sheet2->setCellValue('H1' , 'QUEM DIGITALIZOU?');
1830.             $sheet2->setCellValue('I1' , 'INDEXAÇÃO');
1831.             $sheet2->setCellValue('J1' , 'QUEM INDEXOU?');
1832.             $sheet2->setCellValue('K1' , 'IMAGEN(S)');
1833.             $sheet2->getStyle('A1:K1')->applyFromArray($headerStyle);
1834.             
1835.             $rowCount = 2;
1837.             foreach ($fluxo_caixas as $caixas) {
1839.                 $doc = $caixas->getDocumentos();
1841.                 
1842.                 foreach ($doc as $docs) {
1843.                     $tipo= null;
1844.                     $id = $docs->getId();
1845.                     $nome = $docs->getNome();
1846.                     $caixa = $docs->getCaixa()->getNome();
1847.                     if($docs->getTipo() != null){
1848.                         $tipo = $docs->getTipo()->getNome();
1849.                     }
1850.                     $qtd = $docs->getQtd();
1851.                     $assunto = $docs->getAssunto();
1852.                     $keywords = $docs->getKeywords();
1853.                     $user = $docs->getUser()->getNome();
1854.                     $data  = $docs->getCreatedAt();
1855.                     $index  = $docs->getIndexAt();
1856.                     $user_index  = $docs->getUserIndex();
1858.                     $sheet2->setCellValue('A' . $rowCount,$id);
1859.                     $sheet2->setCellValue('B' . $rowCount,$nome);
1860.                     $sheet2->setCellValue('C' . $rowCount,$caixa);
1861.                     $sheet2->setCellValue('D' . $rowCount,$tipo);
1862.                     $sheet2->setCellValue('E' . $rowCount,$assunto);
1863.                     $sheet2->setCellValue('F' . $rowCount,$keywords);
1864.                     $sheet2->setCellValue('G' . $rowCount,$data);
1865.                     $sheet2->setCellValue('H' . $rowCount,$user);
1866.                     $sheet2->setCellValue('I' . $rowCount,$index);
1867.                     $sheet2->setCellValue('J' . $rowCount,$user_index);
1868.                     $sheet2->setCellValue('K' . $rowCount,$qtd);
1869.                    
1870.                     
1872.                     if ($data instanceof \DateTime) {
1873.                         $sheet2->setCellValue('G' . $rowCount, Date::PHPToExcel($data));
1874.                     } else {
1875.                         $sheet2->setCellValue('G' . $rowCount, $data); // Evita erro se não for DateTime
1876.                     }
1878.                     if ($data instanceof \DateTime) {
1879.                         $sheet2->setCellValue('I' . $rowCount, Date::PHPToExcel($index));
1880.                     } else {
1881.                         $sheet2->setCellValue('I' . $rowCount, $index); // Evita erro se não for DateTime
1882.                     }
1883.             
1884.             
1885.                     $rowCount++;
1886.                 
1887.                 }
1888.             }
1889.             $sheet2->getStyle('I2:I' . ($rowCount - 1))
1890.                 ->getNumberFormat()
1891.                 ->setFormatCode('dd/mm/yyyy');
1893.             $sheet2->getStyle('G2:G' . ($rowCount - 1))
1894.                 ->getNumberFormat()
1895.                 ->setFormatCode('dd/mm/yyyy');    
1896.         
1897.             foreach (range('A', 'K') as $col) {
1898.                 $sheet2->getColumnDimension($col)->setAutoSize(true);
1899.             }
1902.         
1903.             // Gera o arquivo para download
1904.             $writer = new Xlsx($spreadsheet);
1905.             header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
1906.             header('Content-Disposition: attachment; filename="' . $nome_fluxo . '-FLUXO-' . $id_fluxo . '.xlsx"');
1907.             header('Cache-Control: max-age=0');
1908.             $writer->save('php://output');
1909.             exit;
1910.         }
1912.         if (isset($_POST["pdf"])) {
1913.             
1914.             $id_fluxo = $_POST["pdf"];
1915.             $fluxo_pdf = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($id_fluxo);
1916.             $nome_fluxo = $fluxo_pdf->getNome();
1917.             
1918.            
1919.             $html = $this->render('index/pdf.html.twig', [
1920.                 'fluxo_pdf' => $fluxo_pdf,
1921.                 'registro' => $registro
1922.                 
1923.             ]);
1925.             $options = new Options();
1926.             $options->set('isHtml5ParserEnabled', true);
1927.             $options->set('isPhpEnabled', true);
1928.             $options->set('isRemoteEnabled', true); 
1929.             $dompdf = new Dompdf($options);
1930.             $dompdf->loadHtml($html);
1931.             $dompdf->setPaper('A4', 'portrait');
1933.             // Renderiza o HTML para o PDF
1934.             $dompdf->render();
1936.             // Envia o PDF para o navegador para download
1937.             $dompdf->stream("Relatório_Fluxo_".$id_fluxo."_".$nome_fluxo.".pdf", ["Attachment" => 0]); // 0 para exibir no navegador, 1 para download
1938.         }
1940.         if (isset($_POST["etiqueta"])) {
1941.             try {
1942.         
1943.                 // reforça limites (pode ajustar conforme necessário)
1944.                 ini_set('max_execution_time', 500);
1945.                 ini_set('memory_limit', '3512M');
1946.         
1947.                 $id_fluxo = $_POST["etiqueta"];
1948.                 $fluxo_pdf = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($id_fluxo);
1949.                 $cliente_id = $fluxo_pdf->getCliente()->getId();
1950.                 $cliente = $doctrine->getRepository(Cliente::class)->findWithRelations($cliente_id);
1951.                 $nome_fluxo = $fluxo_pdf->getNome();
1952.                 $clienteAll_fluxo = $cliente->getClienteAll()->getLogo();
1953.                 
1954.                 $cmd = $clientS3->getCommand('GetObject', [
1955.                 'Bucket' => 'arquivosdoc',
1956.                 'Key'    => 'LOGO_CLIENTES/'. $clienteAll_fluxo, 
1957.                 ]);
1958.                 
1959.                 $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
1960.                 $cliente_all_Url = (string) $req->getUri();
1961.                 
1962.                 $clienteAll_fluxo_id = $cliente->getClienteAll()->getId();
1963.                 $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_pdf->getId());
1964.                 if ($cliente_id == 139 or $cliente_id == 137){
1965.                         $html = '
1966.                         <!DOCTYPE html>
1967.                         <html lang="pt-BR">
1968.                         <head>
1969.                             <meta charset="UTF-8">
1970.                             <meta name="viewport" content="width=device-width, initial-scale=1.0">
1971.                             <title>FLUXO</title>
1972.                             <style>
1973.                                 * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
1974.                                 body { text-transform: uppercase; }
1975.                                 .filho { border: 2px solid black; width: 57.2mm; height: 100mm; display: inline-block; margin: 2px; position: relative;}
1976.                                 h2 { text-align: center; font-size: 20px; padding: 5px; }
1977.                                 h2 img{width: 250px; height: 250px;}
1978.                                 h4 { text-align: center; font-size: 12px; padding: 10px; }
1979.                                 h5 { text-align: center; font-size: 14px;}
1980.                                 h6 { text-align: center; font-size: 14px; padding: 5px; }
1981.                                 h5 img { text-align: center;max-height: 40px;width:auto;max-width: 40px}
1982.                                 h6 img { text-align: center;margin:auto;  max-height: 130px;width:auto;max-width: 130px}
1983.                                 p { text-align: center; font-size: 8px; font-weight: bold;}
1984.                                 .pai { position: relative; top: 11%; }
1985.                                 hr { color: black; }
1986.                                 .lis2{
1987.                                     
1988.                                     font-weight: bold;
1989.                                     margin:5px;
1990.                                 }
1991.                                 .lis3 {
1992.                                     position: absolute;
1993.                                     bottom: 0;
1994.                                     width: 100%;
1995.                                     font-weight: bold;
1996.                                     text-align: center;
1997.                                     margin-bottom:5px;
1998.                                     margin-top:5px;
1999.                                        
2000.                                 }
2001.                                 .lis{
2002.                                     
2003.                                     margin-left:10px;
2004.                                     font-weight: bold;
2005.                                 }
2006.                                 li{
2007.                                   margin:5px;
2008.                                   font-size: 12px
2009.                                 }
2010.                                 
2011.                             </style>
2012.                         </head>
2013.                         <body>
2014.                         <div class="pai">';
2015.                 
2016.                         $count = 0;
2017.                 
2018.                         foreach ($fluxo_caixas as $caixa) {
2019.                             $count++;
2020.                             $documento_fluxo = $caixa->getDocumentos()->toArray();
2021.                             
2022.                 
2023.                             $html .= '<div class="filho">
2024.                                 
2025.                                 
2026.                                 <h6><img src="'.$cliente_all_Url.'" class="img"></h6>
2027.                                 <hr>
2028.                                 <h2>' . htmlspecialchars($caixa->getNome()) . '</h2>
2029.                                 <hr>
2030.                                 ';
2031.                 
2032.                             $docs = [];
2033.                             
2034.                             if (!empty($documento_fluxo)) {
2035.                                 foreach ($documento_fluxo as $doc) {
2036.                                     if($doc->getTipo() != NULL ){
2037.                                         if ($cliente_id != 122) {
2038.                                             $docs[] = $doc->getTipo()->getNome();
2039.                                         } else {
2040.                                             $docs[] = $doc->getNome();
2041.                                         }
2042.                                     }
2043.                                 }
2044.                                 $docs = array_unique($docs);
2045.                             }
2046.                             
2047.                             
2050.                             $docs_class = [];
2051.                             
2052.                             if (!empty($documento_fluxo)) {
2053.                                 foreach ($documento_fluxo as $doc) {
2054.                                     
2055.                                     if($doc->getClassificacao() != NULL ){
2056.                                        $clss =  $entityManager->getRepository(Classificacao::class)->findBy(['id' => $doc->getClassificacao()->getId()]);
2057.                                        $class_nome =  $clss[0]->getNome();
2058.                                        $docs_class[] = $class_nome;
2059.                                         
2060.                                     }
2061.                                 }
2062.                                 $docs_class = array_unique($docs_class);
2063.                             }
2064.                 
2066.                             $docs_data = [];
2067.                             $docs_assunto=[];
2069.                             if (!empty($documento_fluxo)) {
2070.                                 foreach ($documento_fluxo as $data) {
2071.                                     if ($data->getNome() !== null) {
2072.                                         $docs_data[] = $data->getNome();
2073.                                     }
2074.                                     if ($data->getAssunto() !== null) {
2075.                                         $docs_assunto[] = $data->getAssunto();
2076.                                     }
2077.                                 }
2078.                                 $docs_data = array_unique($docs_data);
2079.                                 $docs_assunto = array_unique($docs_assunto);
2080.                             }
2081.                             
2082.                              if ($cliente_id == 139){
2083.                        
2084.                                 $pl_numeros = [];
2085.                                 $req_numeros = [];
2086.                                 $req_ano = null;
2087.                                 
2088.                                 foreach ($docs_data as $doc) {
2089.                                 
2090.                                 
2091.                                     if (preg_match('/^PL-(\d{1,3}(?:\.\d{3})*)$/', $doc, $m)) {
2092.                                 
2093.                                         $numeroLimpo = str_replace('.', '', $m[1]);
2094.                                         $pl_numeros[] = (int)$numeroLimpo;
2095.                                     }
2096.                                 
2097.                            
2098.                                     elseif (stripos($doc, 'REQUERIMENTO') !== false 
2099.                                         && preg_match('/-(\d+)\.(\d{4})$/', $doc, $m)) {
2100.                                 
2101.                                         $req_numeros[] = (int)$m[1];
2102.                                         $req_ano = $m[2];
2103.                                     }
2104.                                 }
2105.                                 
2106.                         
2107.                                 
2108.                                 $menorNome = null;
2109.                                 $maiorNome = null;
2110.                                 $docs_faltantes = [];
2111.                                 $tipoAtual = null;
2112.                                 
2113.                           
2114.                                 
2115.                                 if (!empty($pl_numeros)) {
2116.                                 
2117.                                     sort($pl_numeros);
2118.                                 
2119.                                     $menor = min($pl_numeros);
2120.                                     $maior = max($pl_numeros);
2121.                                 
2122.                                     $menorNome = 'PL ' . number_format($menor, 0, '', '.');
2123.                                     $maiorNome = 'PL ' . number_format($maior, 0, '', '.');
2124.                                 
2125.                                     $esperado = range($menor, $maior);
2126.                                     $faltantes = array_diff($esperado, $pl_numeros);
2127.                                 
2128.                                     foreach ($faltantes as $f) {
2129.                                         $docs_faltantes[] = 'PL ' . number_format($f, 0, '', '.');
2130.                                     }
2131.                                 
2132.                                     $tipoAtual = 'PL';
2133.                                 }
2134.                                 
2135.                           
2136.                                 
2137.                                 elseif (!empty($req_numeros)) {
2138.                                 
2139.                                     sort($req_numeros);
2140.                                 
2141.                                     $menor = min($req_numeros);
2142.                                     $maior = max($req_numeros);
2143.                                 
2144.                                     $menorNome = str_pad($menor, 2, '0', STR_PAD_LEFT) . '.' . $req_ano;
2145.                                     $maiorNome = str_pad($maior, 2, '0', STR_PAD_LEFT) . '.' . $req_ano;
2146.                                 
2147.                                     $esperado = range($menor, $maior);
2148.                                     $faltantes = array_diff($esperado, $req_numeros);
2149.                                 
2150.                                     foreach ($faltantes as $f) {
2151.                                         $docs_faltantes[] = str_pad($f, 2, '0', STR_PAD_LEFT) . '.' . $req_ano;
2152.                                     }
2153.                                 
2154.                                     $tipoAtual = 'REQUERIMENTO';
2155.                                 }                                                                        
2156.                                                                                                                             
2157.                                                                 
2158.                                     $html .= '<h6>' . htmlspecialchars(implode(', ', $docs)) . '</h6>
2159.                                     <hr>';
2160.                                    
2161.     
2162.     
2163.                                     $html .= '<h6>Conteúdo:</h6>';
2164.     
2165.                                     $html .= '<div class="lis">';
2166.                                     foreach ($docs_class as $classs_nome) {
2167.                                     $html .= '
2168.                                         <li>' . $classs_nome. '</li>';
2169.                                     }
2170.                                     $html .= '</div><br>';
2171.                                     
2172.                                     
2173.                                     if ($menorNome !== null && $maiorNome !== null) {
2174.                                         $html .= '<h6>'.$menorNome.' Até '.$maiorNome.'</h6>';
2175.                                     }
2176.         
2177.                                     if($docs_faltantes != []){
2178.                                         $html .= '
2179.                                         <div class="lis2"><p>';
2180.                                                 $html .= 'Faltantes*</br>';
2181.                                                 $qtdFaltantes = count($docs_faltantes);
2182.     
2183.                                                 if ($qtdFaltantes > 40) {
2184.                                                 
2185.                                                     $html .= '<span style="color:red; font-weight:bold;font-size: 8px">
2186.                                                         Existem ' . $qtdFaltantes . ($tipoAtual === 'PL' ? ' projetos de lei ' : ' requerimentos ') . 'faltantes.
2187.                                                         Conferir no inventário.
2188.                                                     </span>';
2189.                                                 
2190.                                                 } else {
2191.                                                 
2192.                                                 $html .= implode(' | ', $docs_faltantes);
2193.     
2194.                                                 
2195.                                                 }
2196.                                             
2197.                                         $html .= '</p></div>';
2198.                                     }
2199.                                 }
2200.                                 else{
2201.                                     
2202.                                                                 // Remove duplicados
2203.                                 $docs_assunto = array_unique($docs_assunto);
2204.                                 
2205.                                 // Converte para DateTime
2206.                                 $datasObj = array_map(function ($data) {
2207.                                     return DateTime::createFromFormat('m/Y', $data);
2208.                                 }, $docs_assunto);
2209.                                 
2210.                                 // Remove possíveis datas inválidas
2211.                                 $datasObj = array_filter($datasObj);
2212.                                 
2213.                                 // Ordena por data
2214.                                 usort($datasObj, function ($a, $b) {
2215.                                     return $a <=> $b;
2216.                                 });
2217.                                 
2218.                                 $resultado = [];
2219.                                 
2220.                                 if (count($datasObj) > 0) {
2221.                                 
2222.                                     $inicio = $datasObj[0];
2223.                                     $anterior = $datasObj[0];
2224.                                 
2225.                                     for ($i = 1; $i < count($datasObj); $i++) {
2226.                                 
2227.                                         $atual = $datasObj[$i];
2228.                                 
2229.                                         $proximoEsperado = clone $anterior;
2230.                                         $proximoEsperado->modify('+1 month');
2231.                                 
2232.                                         if ($atual->format('m/Y') !== $proximoEsperado->format('m/Y')) {
2233.                                 
2234.                                             if ($inicio->format('m/Y') === $anterior->format('m/Y')) {
2235.                                                 $resultado[] = $inicio->format('m/Y');
2236.                                             } else {
2237.                                                 $resultado[] = $inicio->format('m/Y') . ' até ' . $anterior->format('m/Y');
2238.                                             }
2239.                                 
2240.                                             $inicio = $atual;
2241.                                         }
2242.                                 
2243.                                         $anterior = $atual;
2244.                                     }
2245.                                 
2246.                                     // Fecha o último bloco
2247.                                     if ($inicio->format('m/Y') === $anterior->format('m/Y')) {
2248.                                         $resultado[] = $inicio->format('m/Y');
2249.                                     } else {
2250.                                         $resultado[] = $inicio->format('m/Y') . ' Até ' . $anterior->format('m/Y');
2251.                                     }
2252.                                 }
2254.                                 
2255.                                     
2256.                                     
2257.                                     
2258.                                     
2259.                                     $html .= '<h6>Conteúdo:</h6>';
2260.     
2261.                                     $html .= '<div class="lis">';
2262.                                     foreach ($docs_class as $classs_nome) {
2263.                                     $html .= '
2264.                                         <li>' . $classs_nome. '</li>';
2265.                                     }
2266.                                     $len = count($resultado);
2267.                                     if ($len <5 and $len >0) {
2268.                                          
2269.                                          $html .= '<br>';     
2270.                                     }
2271.                                     foreach ($docs_data as $classs_nome) {
2272.                                     $html .= '
2273.                                         <h6>' . $classs_nome. '</h6>';
2274.                                     }
2275.                                     
2276.                                     
2277.                                     
2278.                                         
2279.                                     foreach ($resultado as $classs_nome) {
2280.                                         if ($len >= 9) {
2281.                                             $fontSize = 8;
2282.                                         } 
2283.                                         elseif ($len <10 and $len >5) {
2284.                                             $fontSize = 10;
2285.                                         }
2286.                                         
2287.                                         elseif ($len <5 and $len >0) {
2288.                                             $fontSize = 12;
2289.                                              
2290.                                         }else{
2291.                                             $fontSize = 8;
2292.                                         }
2293.                                         
2294.                                     $html .= '
2295.                                         <p style="font-size: ' . $fontSize . 'px;">' . $classs_nome. '</p>';
2296.                                     }
2297.                                     
2298.                                     $html .= '</div><br>';
2299.                                 }
2300.                                 $html .= 
2301.                                 
2302.                                 
2303.                                 '<div class="lis3"><hr>
2304.                                 
2305.                                 <p>ARQUIVOS GESTÃO DOCUMENTAL</p>
2306.                                 <h5><img src="https://index.arquivosdoc.com.br/img/logo_menu.png" class="img"></h5>
2307.                                 </div>
2308.                                 
2309.                             </div>';
2310.                 
2311.                             if ($count %  10 == 0) {
2312.                                 $html .= '<div style="page-break-after: always;"></div>';
2313.                             }
2314.                         }
2315.                
2317.                         $html .= '</div></body></html>';
2318.                 }
2319.         
2320.                 if($clienteAll_fluxo_id != 17 and $clienteAll_fluxo_id != 40 and $cliente_id != 139 and $cliente_id != 137){
2321.                         // Construção do HTML com os QR Codes
2322.                         $html = '
2323.                         <!DOCTYPE html>
2324.                         <html lang="pt-BR">
2325.                         <head>
2326.                             <meta charset="UTF-8">
2327.                             <meta name="viewport" content="width=device-width, initial-scale=1.0">
2328.                             <title>FLUXO</title>
2329.                             <style>
2330.                                 * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
2331.                                 body { text-transform: uppercase; }
2332.                                 .filho { border: 2px solid black; width: 120mm; height: 170mm; display: inline-block; margin-left: 45px; }
2333.                                 h2 { text-align: center; font-size: 36px; padding: 5px; }
2334.                                 h2 img{width: 200px; height: 200px;}
2335.                                 h4 { text-align: center; font-size: 12px; padding: 10px; }
2336.                                 h5 { text-align: center; font-size: 22px; padding: 10px; }
2337.                                 h6 { text-align: justify; font-size: 26px; padding: 5px; }
2338.                                 h6 img { float: right;  max-height: 70px;width:auto;max-width: 170px}
2339.                                 p { text-align: justify; font-size: 14px; font-weight: bold; padding: 10px; }
2340.                                 .pai { position: relative; top: 20%; }
2341.                                 hr { color: black; }
2342.                                 .lis{
2343.                                 
2344.                                  width:430px; height: 200px;
2345.                                  margin:auto;
2346.                                  font-weight: bold;
2347.                                 }
2348.                                 li{
2349.                                   margin-left:10px;
2350.                                 }
2351.                                 
2352.                             </style>
2353.                         </head>
2354.                         <body>
2355.                         <div class="pai">';
2356.         
2357.                         $count = 0;
2358.         
2359.                         foreach ($fluxo_caixas as $caixa) {
2360.                             $count++;
2361.                             $documento_fluxo = $caixa->getDocumentos()->toArray();
2362.         
2363.                             // Gerar QR Code
2364.                             $qrCode = Builder::create()
2365.                                 ->writer(new PngWriter())
2366.                                 ->data("https://ged.arquivosdoc.com.br/info/caixa/" . $caixa->getId())
2367.                                 ->build();
2368.                             $qrCodeBase64 = base64_encode($qrCode->getString());
2369.         
2370.                             $html .= '<div class="filho">
2371.                                 <h2>' . htmlspecialchars($caixa->getNome()) . '</h2>
2372.                                 <hr>
2373.                                 <h6>Arquivos:<img src="'.$cliente_all_Url.'" class="img"></h6>
2374.                                 <p>' . htmlspecialchars($fluxo_pdf->getNome()) . '</p>
2375.                                 <hr>
2376.                                 <h6>Título:</h6>';
2377.         
2378.                             $docs = [];
2379.                             
2380.                             if (!empty($documento_fluxo)) {
2381.                                 foreach ($documento_fluxo as $doc) {
2382.                                     if($doc->getTipo() != NULL ){
2383.                                         if ($cliente_id != 122) {
2384.                                             $docs[] = $doc->getTipo()->getNome();
2385.                                         } else {
2386.                                             $docs[] = $doc->getNome();
2387.                                         }
2388.                                     }
2389.                                 }
2390.                                 $docs = array_unique($docs);
2391.                             }
2392.                             
2393.                             $docs_class = [];
2394.                             
2395.                             if (!empty($documento_fluxo)) {
2396.                                 foreach ($documento_fluxo as $doc) {
2397.                                     
2398.                                     if($doc->getClassificacao() != NULL ){
2399.                                        $clss =  $entityManager->getRepository(Classificacao::class)->findBy(['id' => $doc->getClassificacao()->getId()]);
2400.                                        $class_nome =  $clss[0]->getNome();
2401.                                        $docs_class[] = $class_nome;
2402.                                        
2403.                                         
2404.                                     }
2405.                                 }
2406.                                 $docs_class = array_unique($docs_class);
2407.                             }
2408.                             
2409.         
2410.                             $html .= '<p>' . htmlspecialchars(implode(', ', $docs)) . '</p>
2411.                                 <hr>
2412.                                 <h6>Conteúdo:</h6>';
2413.                                 
2414.                                 
2415.                                 
2416.                                   if($clienteAll_fluxo_id == 41){
2417.                                       
2418.                                         $html .= '<div class="lis">';
2419.                                         $len = count($docs_class);
2420.                                      
2421.                                         foreach ($docs_class as $classs_nome) {
2422.                                         
2423.                                         
2424.                                             
2425.                                             if ($len <= 9) {
2426.                                                 $fontSize = 16;
2427.                                             } 
2428.                                             elseif ($len <= 11) {
2429.                                                 $fontSize = 14;
2430.                                             } 
2431.                                             elseif ($len <= 13) {
2432.                                                 $fontSize = 12;
2433.                                             } 
2434.                                             elseif ($len <= 16) {
2435.                                                 $fontSize = 10;
2436.                                             }
2437.                                             elseif ($len <= 18) {
2438.                                                 $fontSize = 9;
2439.                                             }
2440.                                             elseif ($len <= 21) {
2441.                                                 $fontSize =8;
2442.                                             }
2443.                                             elseif ($len <= 23) {
2444.                                                 $fontSize = 7;
2445.                                             }
2446.                                             else {
2447.                                                 $fontSize = 6;
2448.                                             }
2449.                                             $html .= '<li style="font-size: ' . $fontSize . 'px;">' . $classs_nome . '</li>';
2450.                                         }
2451.                                         
2452.                                         $html .= '</div>';
2453.                                         
2454.                                       
2455.                                   }else{
2456.                                              $html .= '
2457.                                                 <h2><img src="data:image/png;base64,' . $qrCodeBase64 . '" alt="QR Code"></h2>';
2458.                                   }  
2459.                                         
2460.                                 
2461.                                 
2462.                                 $html .= '<hr>
2463.                                 <h4>ARQUIVOS GESTÃO DOCUMENTAL</h4>
2464.                                 <h5><img src="https://index.arquivosdoc.com.br/img/arquivos_mini.png" class="img"></h5>
2465.                                 <hr>
2466.                                 <h4>Etiqueta gerada automaticamente pelo ArquivosGED</h4>
2467.                             </div>';
2468.         
2469.                             if ($count % 2 == 0) {
2470.                                 $html .= '<div style="page-break-after: always;"></div>';
2471.                             }
2472.                         }
2473.                
2474.         
2475.                         $html .= '</div></body></html>';
2476.                 }
2477.         
2478.                 
2479.                 if($clienteAll_fluxo_id == 17 ){
2480.                     // Construção do HTML com os QR Codes
2481.                     $html = '
2482.                     <!DOCTYPE html>
2483.                     <html lang="pt-BR">
2484.                     <head>
2485.                         <meta charset="UTF-8">
2486.                         <meta name="viewport" content="width=device-width, initial-scale=1.0">
2487.                         <title>FLUXO</title>
2488.                         <style>
2489.                             * { margin: 0; padding: 0; font-family: Calibri, sans-serif; }
2490.                             .filho { border: 2px solid black; width: 125mm; height: 170mm; display: inline-block; margin-left: 45px; }
2491.                             h2 { font-size: 36px; padding: 5px; }
2492.                             h2 img{width: 200px; height: 200px;}
2493.                             .img_footer{width: 60px; height: 60px;position:relative;top:20px}
2494.                             h4 { text-align: center; font-size: 12px; padding: 10px; }
2495.                             h5 { text-align: center; font-size: 22px; padding: 10px; }
2496.                             h6 { text-align: justify; font-size: 26px; padding: 5px; }
2497.                             h6 img { float: right;  max-height: 77px;width:auto;max-width: 250px}
2498.                             p { text-align: justify; font-size: 18px; font-weight: bold; padding: 10px; }
2499.                             .pai { position: relative; top: 20%; }
2500.                             hr { color: black; }
2501.                             .rodape {
2502.                                 position:relative;bottom:15px
2503.                             }
2504.         
2505.                             
2506.                         </style>
2507.                     </head>
2508.                     <body>
2509.                     <div class="pai">';
2510.             
2511.                     $count = 0;
2512.         
2513.                     $codigo = "";
2514.                     $info = "";
2515.                     $prazo = "";
2516.         
2517.                     if($cliente_id == 113){
2518.                         $codigo = "23.182";
2519.                         $info = "PROCESSOS DIVERSOS";
2520.                         $prazo = "57 ANOS";
2521.                     }
2522.         
2523.                     if($cliente_id == 114){                        
2524.                         $codigo = "23.11";
2525.                         $info = "PROCESSOS DE RECURSOS HUMANOS";
2526.                         $prazo = "100 ANOS";
2527.                     }
2528.             
2529.                     foreach ($fluxo_caixas as $caixa) {
2530.         
2531.         
2532.                         $texto = $caixa->getNome();
2533.         
2534.                         preg_match_all('/\d+/', $texto, $matches);
2535.                         
2536.                         if (count($matches[0]) >= 2) {
2537.                              $numero = str_pad($matches[0][0], 3, '0', STR_PAD_LEFT); 
2538.                             $ano = substr($texto, strpos($texto, $matches[0][0]) + strlen($matches[0][0])); 
2539.                             $ano = trim(str_replace('-', '', $ano)); 
2540.                         } else {
2541.                             echo "Formato inválido!";
2542.                         }
2543.         
2544.         
2545.         
2546.                         $count++;
2547.                         $documento_fluxo = $caixa->getDocumentos()->toArray();
2548.         
2549.                         // Gerar QR Code
2550.                         $qrCode = Builder::create()
2551.                             ->writer(new PngWriter())
2552.                             ->data("https://ged.arquivosdoc.com.br/info/caixa/" . $caixa->getId())
2553.                             ->build();
2554.                         $qrCodeBase64 = base64_encode($qrCode->getString());
2555.             
2556.                         $html .= '<div class="filho">
2557.                             <h2>&nbsp;Caixa nº&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'. htmlspecialchars($numero) . '</h2>
2558.                             <hr>
2559.                             <h6>ARQUIVO:<img src="'.$cliente_all_Url. '" class="img"></h6>
2560.                             <p>SAAE VOLTA REDONDA-RJ</p>
2561.                             <hr>
2562.                             <h6>CÓDIGO TEMPORALIDADE:</h6>
2563.                             <p>'.$codigo.'</p><hr>
2564.                             <h6>TÍTULO:</h6>';
2565.             
2566.         
2567.                         $html .= '<p>' . htmlspecialchars('PROCESSOS ADMINISTRATIVOS') . '</p>
2568.                             <hr>
2569.                             <h6>INFORMAÇÕES:</h6>
2570.                             <p>'.$info.'</p>
2571.                             <hr>
2572.                             <h6>PRAZO DE GUARDA:</h6>
2573.                             <p>'.$prazo.'</p>
2574.                             <hr>
2575.                             <h6>DATA:</h6>
2576.                             <p>'.$ano.'</p>
2577.                             <hr>
2578.                            
2579.                                 <p class="rodape">&nbsp;ARQUIVOS GESTÃO DOCUMENTAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
2580.                                 <img src="https://index.arquivosdoc.com.br/img/arquivos_mini.png" class="img_footer"></p>
2581.                            
2582.                             </div>';
2583.             
2584.                         if ($count % 2 == 0) {
2585.                             $html .= '<div style="page-break-after: always;"></div>';
2586.                         }
2587.                     }
2588.            
2589.         
2590.                     $html .= '</div></body></html>';
2591.                 }
2592.                 
2593.                 if($clienteAll_fluxo_id == 40  ){
2594.                         $documento_all_sebrae = $doctrine->getRepository(Documento::class)
2595.                         ->findBy(
2596.                             ['cliente' => $cliente_id], // filtros
2597.                             ['id' => 'DESC'],            // ordenação (opcional)
2598.                             100,                        // LIMIT
2599.                             0                           // OFFSET
2600.                         );
2601.                         $html = '
2602.                         <!DOCTYPE html>
2603.                         <html lang="pt-BR">
2604.                         <head>
2605.                             <meta charset="UTF-8">
2606.                             <meta name="viewport" content="width=device-width, initial-scale=1.0">
2607.                             <title>FLUXO</title>
2608.                             <style>
2609.                                 * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
2610.                                 body { text-transform: uppercase; }
2611.                                 .filho { border: 2px solid black; width: 120mm; height: 160mm; display: inline-block; margin-left: 20px;padding:10px;} 
2612.                                 h2 { text-align: center; font-size: 36px; padding: 5px; }
2613.                                 h2 img{width: 200px; height: 200px;}
2614.                                 h4 { text-align: center; font-size: 12px; padding: 10px; }
2615.                                 h5 { text-align: center; font-size: 22px; padding: 10px; }
2616.                                 h6 { text-align: justify; font-size: 26px; padding: 5px; }}
2617.                                 p { text-align: justify; font-size: 18px; font-weight: bold; padding: 10px; }
2618.                                 .pai { position: relative; top: 20%;text-align:center; }
2619.                                 hr { color: black; }
2620.                                 
2621.                                     .linha {
2622.                                         margin-bottom: 1mm;
2623.                                         font-size: 10pt;
2624.                                     }
2626.                                     .box-label {
2627.                                         background: #f1f1f1;
2628.                                         border: 1px solid black;
2629.                                         padding: 1mm;
2630.                                         font-size: 8pt;
2631.                                         text-align: center;
2632.                                         margin-top: 1mm;
2633.                                     }
2635.                                     .box-value {
2636.                                         text-align: center;
2637.                                         font-size: 10pt;
2638.                                         margin: 2mm 0 2mm 0;
2639.                                         
2640.                                     }
2641.                                    .box-value_conteudo {
2642.                                         margin: 2mm 0 2mm 0;
2643.                                         text-align: justify;
2644.                                        
2645.                                     }
2646.                                     
2647.                                     img{
2648.                                         width: 120px;
2649.                                         height:80px;
2650.                                         margin: 2mm 0 2mm 0;
2651.                                     }
2652.                                     
2653.                                     .titulo{
2654.                                         margin: 2mm 0 2mm 0;
2655.                                         font-size: 10pt;
2656.                                     }
2657.                                     
2658.                                     .bloco-conteudo {
2659.                                         position: relative;
2660.                                         height: 100%;
2661.                                     }
2662.                                     
2663.                                     .hr-fixo {
2664.                                         position: absolute;
2665.                                         bottom: 0;
2666.                                         left: 0;
2667.                                         width: 100%;
2668.                                         margin: 0 0 0 0;
2669.                                     }
2670.                                     
2672.                                 
2673.                             </style>
2674.                         </head>
2675.                         <body>
2676.                         <div class="pai">';
2677.                 
2678.                         $count = 0;
2679.                 
2680.                         foreach ($documento_all_sebrae as $caixa) {
2681.                             $count++;
2682.                                 $conteudo = htmlspecialchars(str_replace('?', '', $caixa->getExtraFields()));
2683.                                 $tamanho = strlen($conteudo);
2684.                                 $dates="";
2685.                             
2686.                                 if ($tamanho <= 300) {
2687.                                     $fontSize = '8pt';
2688.                                 } elseif ($tamanho <= 600) {
2689.                                     $fontSize = '7pt';
2690.                                 } elseif ($tamanho <= 900) {
2691.                                     $fontSize = '6pt';
2692.                                 } else {
2693.                                     $fontSize = '4pt';
2694.                                 }
2695.                                 
2696.                                 if($caixa->getDataDocumento()){
2697.                                     $dates=$caixa->getDataDocumento()->format('d/m/Y');
2698.                                 }
2699.                             
2700.                                 $html .= 
2701.                                     '<div class="filho">
2702.                                         <div class="bloco-conteudo">
2703.                                         
2704.                                             <img src="'.$cliente_all_Url.'" class="img"></h6>
2705.                             
2706.                                             <div class="titulo">ARQUIVO INATIVO</div><br>
2707.                             
2708.                                             <div class="linha">CAIXA Nº: _______________</div>
2709.                             
2710.                                             <div class="box-label">ÁREA/SIGLA:</div>
2711.                                             <div class="box-value">'. htmlspecialchars($caixa->getAssunto()) .'</div>
2712.                             
2713.                                             <div class="box-label">RESPONSÁVEL:</div>
2714.                                             <div class="box-value">'. htmlspecialchars($caixa->getConteiner()) .'</div>
2715.                             
2716.                                             <div class="box-label">DATA 1º ENVIO:</div>
2717.                                             <div class="box-value">'. htmlspecialchars($dates) .'</div>
2718.                             
2719.                                             <div class="box-label">Conteúdo</div>
2720.                                             <div class="box-value_conteudo" style="font-size: '. $fontSize .'">'. $conteudo .'</div>
2721.                                             
2722.                                             <div class="hr-fixo">
2723.                                                 <hr>
2724.                                                 <div>CXRBM:'. htmlspecialchars($caixa->getNome()) .'</div>
2725.                                             </div>
2726.                             
2727.                                         </div>
2728.         </div>';
2729.                             $docs = [];
2730.                             if ($count % 2 == 0) {
2731.                                 $html .= '<div style="page-break-after: always;"></div>';
2732.                             }
2733.                         }
2734.                
2736.                         $html .= '</div></body></html>';
2737.                 }
2738.                         
2739.                
2740.                
2741.                 // Configurar o Dompdf
2742.                 $options = new Options();
2743.                 $options->set('isHtml5ParserEnabled', true);
2744.                 $options->set('isPhpEnabled', true);
2745.                 $options->set('isRemoteEnabled', true);
2746.                 $dompdf = new Dompdf($options);
2747.                 $dompdf->loadHtml($html);
2748.                 $dompdf->setPaper('A4', 'landscape');
2749.         
2750.                 // LIMPA TODOS OS BUFFERS ANTES DE RENDERIZAR
2751.                 while (ob_get_level()) {
2752.                     ob_end_clean();
2753.                 }
2754.         
2755.                 // Tenta renderizar e, em vez de stream() direto, grava em arquivo temporário e envia
2756.                 try {
2757.                     $dompdf->render();
2758.                 } catch (Throwable $e) {
2759.                     // registra o erro e lança para cair no catch externo
2760.                     error_log('Dompdf render failed: ' . $e->getMessage());
2761.                     throw $e;
2762.                 }
2763.         
2764.                 // Gera arquivo temporário seguro
2765.                 $tempFile = sys_get_temp_dir() . DIRECTORY_SEPARATOR . 'etiqueta_fluxo_' . $id_fluxo . '_' . uniqid() . '.pdf';
2766.                 $output = $dompdf->output();
2767.         
2768.                 if (file_put_contents($tempFile, $output) === false) {
2769.                     throw new Exception('Falha ao escrever arquivo temporário do PDF.');
2770.                 }
2771.         
2772.                 // Força headers corretos para download/visualização
2773.                 header('Content-Type: application/pdf');
2774.                 // Se quiser forçar download use attachment; se quiser abrir no browser use inline
2775.                 header('Content-Disposition: inline; filename="Etiqueta_Fluxo_' . preg_replace('/[^A-Za-z0-9_\-\.]/', '_', $id_fluxo . '_' . $nome_fluxo) . '.pdf"');
2776.                 header('Content-Length: ' . filesize($tempFile));
2777.                 header('Cache-Control: private, max-age=0, must-revalidate');
2778.         
2779.                 // Envia o arquivo binário ao navegador
2780.                 readfile($tempFile);
2781.         
2782.                 // Remove o arquivo temporário com segurança
2783.                 @unlink($tempFile);
2784.         
2785.                 // finaliza execução
2786.                 exit;
2787.         
2788.                 
2789.             } catch (Exception $e) {
2790.                 // Loga para diagnóstico e mostra mensagem amigável
2791.                 error_log('Erro ao gerar o PDF: ' . $e->getMessage());
2792.                 echo 'Erro ao gerar o PDF: ' . htmlspecialchars($e->getMessage());
2793.             }
2794.         
2795.         
2797.             }
2799.         if (isset($_POST["qrcode"])) {
2800.                 $id_fluxo = $_POST["qrcode"];
2801.                 $fluxo_qrcode = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($_POST["qrcode"]);
2802.                 $nome_fluxo = $fluxo_qrcode->getNome();
2803.                 $fluxo_caixas_qrcode = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_qrcode->getId());
2804.                 $clienteAll_id = $fluxo_qrcode->getCliente()->getId();
2805.                 
2806.                 if ($fluxo_caixas_qrcode != null ) {
2807.                     $options = new Options();
2808.                     $options->set('isHtml5ParserEnabled', true);
2809.                     $options->set('isPhpEnabled', true);
2810.                     $dompdf = new Dompdf($options);
2811.                             
2812.                     $html = '
2813.                         <html>
2814.                             <head>
2815.                                 <style>
2816.                                     @page {
2817.                                         margin: 35px 18.9px 0px 18.9px;
2818.                                         size: 210mm 297mm; /* Ajuste de tamanho do papel */
2819.                                     }
2820.                                     body {
2821.                                         margin: 0;
2822.                                         padding: 0;
2823.                                     }
2824.                                     .qr-item {
2825.                                         border: 2px dotted #000;
2826.                                         text-align: center;
2827.                                         width: 32.27mm;
2828.                                         height: 34.9mm; 
2829.                                         display: inline-block;
2830.                                     }
2831.                         
2832.                                     .qr-item img {
2833.                                         width: 115px; 
2834.                                         height: 112px;
2835.                                     }
2836.                                     .qr-title {
2837.                                         font-size: 16px;
2838.                                         font-weight: bold;
2839.                                     }
2840.                                     .leo {
2841.                                         display: flex;
2842.                                         flex-wrap: wrap;
2843.                                     }
2844.                                 </style>
2845.                             </head>
2846.                             <body>';
2847.             
2848.                     $count = 0; // Contador de QR Codes
2849.             
2850.                     foreach ($fluxo_caixas_qrcode as $cx) {
2851.                         $id_cx_ultimo = $cx->getCx();
2852.             
2853.                         if ($id_cx_ultimo !== null) {
2854.                             $nome = $id_cx_ultimo->getNome();
2855.             
2856.                             // Gerar QR Code com imagem no centro
2857.                             $result = Builder::create()
2858.                                 ->writer(new PngWriter())
2859.                                 ->writerOptions([])
2860.                                 ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$nome)
2861.                                 ->encoding(new Encoding('UTF-8'))
2862.                                 ->size(500)
2863.                                 ->margin(5)
2864.                                 ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
2865.                                 ->build();
2866.                             
2867.                             // Salvar QR Code como arquivo temporário
2868.                             $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
2869.                             $result->saveToFile($tempFile);
2870.             
2871.                             // Adicionar QR Code ao HTML
2872.                             if ($count % 48 == 0) {
2873.                                 $html .= '<div class="leo">';
2874.                             }
2875.             
2876.                             $html .= '<div class="qr-item">';
2877.                             $html .= '<div class="qr-title">' . $nome . '</div>';
2878.                             $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
2879.                             $html .= '</div>';
2880.             
2881.                             $count++;
2882.             
2883.                             // Fechar a div e inserir quebra de página a cada 63 QR Codes
2884.                             if ($count % 48 == 0) {
2885.                                 $html .= '</div><div style="page-break-after: always;"></div>';
2886.                             }
2887.                         }
2888.                     }
2889.             
2890.                     // Fechar qualquer div aberta sem completar 63 itens
2891.                     if ($count % 48 != 0) {
2892.                         $html .= '</div>';
2893.                     }
2894.             
2895.                     $html .= '</body></html>';
2896.             
2897.                     // Carregar o HTML e gerar o PDF
2898.                     $dompdf->loadHtml($html);
2899.                     $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
2900.                     $dompdf->render();
2901.                     $dompdf->stream("Qrcode_" . $id_fluxo . "_" . $nome_fluxo . ".pdf", ["Attachment" => 1 ]);
2902.                 } else {
2903.                     echo "<script>alert('ERROR, ESSE FLUXO NÃO TEM SETOR DE GUARDA!');</script>";
2904.                 }
2905.             }
2906.         
2907.         if (isset($_POST["container"])) {
2909.             $id_fluxo = $_POST["container"];
2910.             $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($id_fluxo);
2911.             $fluxo_container = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($id_fluxo);
2912.             $clienteAll_id = $fluxo_container->getCliente()->getId();
2913.             $containers = [];
2914.         
2915.             foreach ($fluxo_caixas as $caixa) {
2917.                 $documentos = $caixa->getDocumentos();
2918.         
2919.                 foreach ($documentos as $documento) {
2920.                     $container = $documento->getConteiner(); 
2921.                     $caixaId = $documento->getCaixa()->getId(); 
2922.                     
2923.                     if ($container != null and $caixaId != null) {
2924.                         
2925.                         if (!isset($containers[$container])) {
2926.                             $containers[$container] = [];
2927.                         }
2928.         
2929.                         if (!in_array($caixaId, $containers[$container])) {
2930.                             $containers[$container][] = $caixaId;
2931.                         }
2932.                     }
2933.                 }
2934.             }
2935.             
2937.             $options = new Options();
2938.             $options->set('isHtml5ParserEnabled', true);
2939.             $options->set('isPhpEnabled', true);
2940.             $dompdf = new Dompdf($options);
2941.                     
2942.             $html = '
2944.                 <html>
2945.                     <head>
2946.                         <style>
2947.                             @page {
2948.                                 margin: 35px 18.9px 0px 18.9px;
2949.                                 size: 210mm 297mm; /* Ajuste de tamanho do papel */
2950.                             }
2951.                             body {
2952.                                 margin: 0;
2953.                                 padding: 0;
2954.                             }
2955.                             .qr-item {
2956.                                 border: 2px dotted #000;
2957.                                 width: 200mm;
2958.                                 height: 80mm;
2959.                                 margin-top:15px; 
2960.                                 text-align: center;
2961.                                
2962.                                 
2963.                             }
2965.                              .img_qrcode h2{                           
2966.                                position:relative;
2967.                                top:25px;
2968.                             }
2970.                             .img_qrcode h3{                           
2971.                                position:relative;
2972.                                bottom:25px;
2973.                                font-size: 20px;
2974.                             }
2976.                             .img_qrcode{
2977.                                
2978.                                 display: inline-block;
2979.                                 margin: 5px  30px 5px 30px;
2980.                                
2981.                                
2982.                             }
2983.                 
2984.                             .qr-item img {
2985.                                 
2986.                                 width: 170px; 
2987.                                 height: 170px;
2988.                                 
2989.                             }
2990.                             .qr-title {
2991.                                 font-size: 70px;
2992.                                 font-weight: bold;
2993.                                
2995.                             }
2996.                             .leo {
2997.                                 display: flex;
2998.                                 flex-wrap: wrap;
2999.                             }
3000.                         </style>
3001.                     </head>
3002.                     <body>';
3003.     
3004.             $count = 0; // Contador de QR Codes
3008.             // Exibir resultado
3009.             foreach ($containers as $container => $caixas) {
3011.                 #echo "Container $container => " . implode(", ", $caixas) . "<br>";
3013.                 
3015.                
3016.                 if ($count % 3 == 0) {
3017.                     $html .= '<div class="leo">';
3018.                 }
3020.                 $html .= '<div class="qr-item">';
3021.                 $html .= '<div class="qr-title">' . $container . '</div><hr>';
3024.                 foreach($caixas as $caixa ){
3025.                     $caix = $doctrine->getRepository(Caixa::class)->find($caixa);
3026.                     $caix_nome =$caix->getNome();
3027.                     $caix_cx =$caix->getCx()->getNome();
3028.                     $result = Builder::create()
3029.                     ->writer(new PngWriter())
3030.                     ->writerOptions([])
3031.                     ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$caix_cx)
3032.                     ->encoding(new Encoding('UTF-8'))
3033.                     ->size(350)
3034.                     ->margin(5)
3035.                     ->logoPath(__DIR__ . '/logo.png') 
3036.                     ->build();
3037.                 
3038.                 
3039.                     $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
3040.                     $result->saveToFile($tempFile);
3041.                     
3042.                     $html .= '
3043.                         <div class="img_qrcode">    
3044.                             <h2>'.$caix_cx.'</h2>
3045.                             <img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">
3046.                             <h3>'.$caix_nome.'</h3>
3047.                         </div>
3048.                     
3049.                     ';
3050.                 }
3051.                 $html .= '</div>';
3053.                 $count++;
3055.                 
3056.                 if ($count % 3 == 0) {
3057.                     $html .= '</div><div style="page-break-after: always;"></div>';
3058.                 }
3059.             }
3062.               // Fechar qualquer div aberta sem completar 63 itens
3063.               if ($count % 3 != 0) {
3064.                 $html .= '</div>';
3065.             }
3066.     
3067.             $html .= '</body></html>';
3068.     
3069.             // Carregar o HTML e gerar o PDF
3070.             $dompdf->loadHtml($html);
3071.             $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
3072.             $dompdf->render();
3073.             $dompdf->stream("Qrcode.pdf", ["Attachment" => 1 ]);
3074.             
3078.         }
3079.         
3080.         if (isset($_POST["pasta"])) {
3081.             
3082.                 // reforça limites (pode ajustar conforme necessário)
3083.                 ini_set('max_execution_time', 500);
3084.                 ini_set('memory_limit', '3512M');
3085.         
3086.                 $id_fluxo = $_POST["pasta"];
3087.                 $fluxo_pdf = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($id_fluxo);
3088.                 $cliente_id = $fluxo_pdf->getCliente()->getId();
3089.                 $cliente = $doctrine->getRepository(Cliente::class)->findWithRelations($cliente_id);
3090.                 $nome_fluxo = $fluxo_pdf->getNome();
3091.                 $clienteAll_fluxo = $cliente->getClienteAll()->getLogo();
3092.                 
3093.                 $cmd = $clientS3->getCommand('GetObject', [
3094.                 'Bucket' => 'arquivosdoc',
3095.                 'Key'    => 'LOGO_CLIENTES/'. $clienteAll_fluxo, 
3096.                 ]);
3097.                 
3098.                 $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
3099.                 $cliente_all_Url = (string) $req->getUri();
3100.                 
3101.                 $clienteAll_fluxo_id = $cliente->getClienteAll()->getId();
3102.                 $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_pdf->getId());
3104.                 if($clienteAll_fluxo_id == 39){
3105.                     $html = '
3106.                     <!DOCTYPE html>
3107.                     <html lang="pt-BR">
3108.                     <head>
3109.                         <meta charset="UTF-8">
3110.                         <meta name="viewport" content="width=device-width, initial-scale=1.0">
3111.                         <title>FLUXO</title>
3112.                         <style>
3113.                             * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
3114.                             body { text-transform: uppercase; }
3115.                             .filho { border: 2px solid black; width: 67.8mm; height: 145mm; display: inline-block; margin: 0px 2px 2px 2px; position: relative; }
3116.                             h2 { text-align: center; font-size: 30px; padding: 5px; }
3117.                             h2 img{width: 250px; height: 250px;}
3118.                             h4 { text-align: center; font-size: 14px; padding: 10px; }
3119.                             h5 { text-align: center; font-size: 16px;}
3120.                             h6 { text-align: center; font-size: 18px; padding: 20px; }
3121.                             h5 img { text-align: center;max-height: 40px;width:auto;max-width: 40px}
3122.                             h6 img { text-align: center;margin:auto;  max-height: 200px;width:auto;max-width: 200px}
3123.                             p { text-align: center; font-size: 12px; font-weight: bold;}
3124.                             .pai { position: relative; top: 11%; }
3125.                             hr { color: black; }
3126.                             .lis2{
3127.                                         
3128.                                 font-weight: bold;
3129.                                 margin:5px;
3130.                             }
3131.                             .lis3 {
3132.                                 position: absolute;
3133.                                 bottom: 0;
3134.                                 width: 100%;
3135.                                 font-weight: bold;
3136.                                 text-align: center;
3137.                                 margin-bottom:5px;
3138.                                 margin-top:5px;
3139.                             }
3140.                             .lis{
3141.                                 
3142.                                 margin-left:10px;
3143.                                 font-weight: bold;
3144.                             }
3145.                             li{
3146.                                 margin:10px;
3147.                                 font-size: 18px;
3148.                             }
3149.                             
3150.                         </style>
3151.                     </head>
3152.                     <body>
3153.                     <div class="pai">';
3154.             
3155.                     $count = 0;
3156.             
3157.                     foreach ($fluxo_caixas as $caixa) {
3158.                         $count++;
3159.                         $documento_fluxo = $caixa->getDocumentos()->toArray();
3160.                         
3161.                         
3162.                         $html .= '<div class="filho">
3163.                             
3164.                             
3165.                             <h6><img src="'.$cliente_all_Url.'" class="img"></h6>
3166.                             <hr>
3167.                             <h2>' . htmlspecialchars($caixa->getNome()) . '</h2>
3168.                             <hr>
3169.                             ';
3170.             
3171.                         $docs = [];
3172.                         
3173.                         if (!empty($documento_fluxo)) {
3174.                             foreach ($documento_fluxo as $doc) {
3175.                                 if($doc->getTipo() != NULL ){
3176.                                     if ($cliente_id != 122) {
3177.                                         $docs[] = $doc->getTipo()->getNome();
3178.                                     } else {
3179.                                         $docs[] = $doc->getNome();
3180.                                     }
3181.                                 }
3182.                             }
3183.                             $docs = array_unique($docs);
3184.                         }
3186.                         
3187.                         $docs_class = [];
3188.                         
3189.                         if (!empty($documento_fluxo)) {
3190.                             foreach ($documento_fluxo as $doc) {
3191.                                 
3192.                                 if($doc->getClassificacao() != NULL ){
3193.                                     $clss =  $entityManager->getRepository(Classificacao::class)->findBy(['id' => $doc->getClassificacao()->getId()]);
3194.                                     $class_nome =  $clss[0]->getNome();
3195.                                     $docs_class[] = $class_nome;
3196.                                     
3197.                                 }
3198.                             }
3199.                             $docs_class = array_unique($docs_class);
3200.                         }
3203.                         $docs_data = [];
3204.                         $mapa = [];
3206.                         if (!empty($documento_fluxo)) {
3207.                             foreach ($documento_fluxo as $data) {
3208.                                 if ($data->getNome() != null) {
3209.                                     $docs_data[] = $data->getNome();
3210.                                 }
3211.                             }
3212.                             $docs_data = array_unique($docs_data);
3213.                         }
3215.                         $numeros = [];
3216.                         foreach ($docs_data as $doc) {
3217.                             if (preg_match('/PL-(\d+)/', $doc, $matches)) {
3218.                                 $numero = (int) $matches[1];
3220.                                 $numeros[] = $numero;
3221.                                 $mapa[$numero] = $doc; // ✅ CORRETO
3222.                             }
3223.                         }
3225.                         if (!empty($numeros)) {
3226.                             $menor = min($numeros);
3227.                             $maior = max($numeros);
3229.                             $menorNome = $mapa[$menor];
3230.                             $maiorNome = $mapa[$maior];
3231.                         } else {
3232.                             $menor = null;
3233.                             $maior = null;
3234.                             $menorNome = null;
3235.                             $maiorNome = null;
3236.                         }
3239.                         /* Sequência completa e faltantes */
3240.                         $sequenciaCompleta = range($menor, $maior);
3241.                         $faltantes = array_diff($sequenciaCompleta, $numeros);
3243.                         /* Nomes faltantes */
3244.                         $docs_faltantes = [];
3245.                         
3246.                         if($docs_faltantes != []){
3247.                             foreach ($faltantes as $num) {
3248.                                 $docs_faltantes[] = 'PL_' . str_pad($num, 3, '0', STR_PAD_LEFT);
3249.                             }
3250.                         }
3252.                         
3254.                                                     
3255.                         
3256.                         
3257.                         $html .= '<h6>' . htmlspecialchars(implode(', ', $docs)) . '</h6>
3258.                             <hr>';
3259.                             
3262.                             $html .= '<h6>Conteúdo:</h6>';
3264.                             $html .= '<div class="lis">';
3265.                             foreach ($docs_class as $classs_nome) {
3266.                             $html .= '
3267.                                 <li>' . $classs_nome. '</li>';
3268.                             }
3269.                             $html .= '</div>';
3270.                             $html .= '<h6>'.$menorNome.' Até '.$maiorNome.'</h6>';
3271.                             if($docs_faltantes != []){
3272.                                 $html .= '<div class="lis2"><p>';
3273.                                     
3274.                                         foreach ($docs_faltantes as $data) {
3275.                                             $html .= 'Faltantes*: | ' . $data. ' | ';
3276.                                         }
3277.                                     
3278.                                 $html .= '</p></div>';
3279.                             }
3280.                             /*$html .= '
3281.                                     <div class="lis3"><hr>
3282.                                     
3283.                                     <p>ARQUIVOS GESTÃO DOCUMENTAL</p>
3284.                                     <h5><img src="https://index.arquivosdoc.com.br/img/logo_menu.png" class="img"></h5>
3285.                                     </div>
3286.                                     
3287.                                 </div>';*/
3288.                             
3289.                             $html .= '</div>';
3290.             
3291.                         if ($count %  6 == 0) {
3292.                             $html .= '<div style="page-break-after: always;"></div>';
3293.                         }
3294.                     }
3295.             
3297.                     $html .= '</div></body></html>';
3298.                 }
3299.                 
3300.                 if($clienteAll_fluxo_id == 41){
3301.                      $html = '
3302.                             <!DOCTYPE html>
3303.                             <html lang="pt-BR">
3304.                             <head>
3305.                                 <meta charset="UTF-8">
3306.                                 <meta name="viewport" content="width=device-width, initial-scale=1.0">
3307.                                 <title>FLUXO</title>
3308.                                 <style>
3309.                                     * { margin: 0; padding: 0; font-family: Calibri, Arial, sans-serif; }
3310.                                     body { text-transform: uppercase; }
3311.                                     .filho { border: 2px solid black; width: 50mm; height: 144mm; display: inline-block; margin: 2px; position: relative;}
3312.                                     h2 { text-align: center; font-size: 20px; padding: 5px; }
3313.                                     h2 img{width: 250px; height: 250px;}
3314.                                     h4 { text-align: center; font-size: 12px; padding: 10px; }
3315.                                     h5 { text-align: center; font-size: 14px;}
3316.                                     h6 { text-align: center; font-size: 14px; padding: 5px; }
3317.                                     h5 img { text-align: center;max-height: 40px;width:auto;max-width: 40px}
3318.                                     h6 img { text-align: center;margin:auto;  max-height: 130px;width:auto;max-width: 130px}
3319.                                     p { text-align: center; font-size: 8px; font-weight: bold;}
3320.                                     .pai { position: relative; top: 11%; }
3321.                                     hr { color: black; }
3322.                                     .lis2{
3323.                                         
3324.                                         font-weight: bold;
3325.                                     }
3326.                                     .lis3 {
3327.                                         position: absolute;
3328.                                         bottom: 0;
3329.                                         width: 100%;
3330.                                         font-weight: bold;
3331.                                         text-align: center;
3332.                                         margin-bottom:5px;
3333.                                         margin-top:5px;
3334.                                            
3335.                                     }
3336.                                     .lis{
3337.                                         
3338.                                         margin-left:10px;
3339.                                         font-weight: bold;
3340.                                     }
3341.                                     li{
3342.                                        font-size: 12px;
3343.                                        margin-left:2px;
3344.                                     }
3345.                                     
3346.                                 </style>
3347.                             </head>
3348.                             <body>
3349.                             <div class="pai">';
3350.             
3351.                     $count = 0;
3352.             
3353.                     
3354.                             foreach ($fluxo_caixas as $caixa) {
3355.                                 $count++;
3356.                                 $documento_fluxo = $caixa->getDocumentos()->toArray();
3357.                                 
3358.                     
3359.                                 $html .= '<div class="filho">
3360.                                     
3361.                                     
3362.                                     <h6><img src="'.$cliente_all_Url.'" class="img"></h6>
3363.                                     <hr>
3364.                                     <h2>' . htmlspecialchars($caixa->getNome()) . '</h2>
3365.                                     <hr>
3366.                                     ';
3367.                     
3368.                                 $docs = [];
3369.                                 
3370.                                 if (!empty($documento_fluxo)) {
3371.                                     foreach ($documento_fluxo as $doc) {
3372.                                         if($doc->getTipo() != NULL ){
3373.                                             if ($cliente_id != 122) {
3374.                                                 $docs[] = $doc->getTipo()->getNome();
3375.                                             } else {
3376.                                                 $docs[] = $doc->getNome();
3377.                                             }
3378.                                         }
3379.                                     }
3380.                                     $docs = array_unique($docs);
3381.                                 }
3382.                                 
3383.                                 
3384.     
3385.     
3386.                                 $docs_class = [];
3387.                                 
3388.                                 if (!empty($documento_fluxo)) {
3389.                                     foreach ($documento_fluxo as $doc) {
3390.                                         
3391.                                         if($doc->getClassificacao() != NULL ){
3392.                                            $clss =  $entityManager->getRepository(Classificacao::class)->findBy(['id' => $doc->getClassificacao()->getId()]);
3393.                                            $class_nome =  $clss[0]->getNome();
3394.                                            $docs_class[] = $class_nome;
3395.                                             
3396.                                         }
3397.                                     }
3398.                                     $docs_class = array_unique($docs_class);
3399.                                 }
3400.                     
3401.     
3402.                                   $docs_data = [];
3403.                                   if (!empty($documento_fluxo)) {
3404.                                         foreach ($documento_fluxo as $data) {
3405.                                             if ($data->getAssunto() !== null) {
3406.                                                 $docs_data[] = $data->getAssunto();
3407.                                             }
3408.                                         }
3409.                                         $docs_data = array_unique($docs_data);
3410.                                     }
3411.                                 
3412.                               
3413.     
3414.                                 
3415.     
3416.     
3417.                                                             
3418.                                 
3419.                                 
3420.                                 $html .= '<h6>' . htmlspecialchars(implode(', ', $docs)) . '</h6>
3421.                                     <hr>';
3422.                                    
3423.     
3424.     
3425.                                     $html .= '<h6>Conteúdo:</h6>';
3426.     
3427.                                     $html .= '<div class="lis">';
3428.                                     foreach ($docs_class as $classs_nome) {
3429.                                     if($classs_nome == '028.11-COM ÔNUS'){
3430.                                      $html .= '<li>SOLICITAÇÃO DE DIÁRIAS</li>';
3431.                                     }
3432.                                     $html .= '
3433.                                         <li>' . $classs_nome. '</li>';
3434.                                     }
3435.                                     $html .= '</div><br>';
3436.                                     $html .= '<h6>Descrição:</h6>';
3437.                                     $html .= '<div class="lis">';
3438.                                     $len = count($docs_data);
3439.                                     foreach ($docs_data as $assunto_nome) {
3440.                                         
3441.                                     $qtd_letra = mb_strlen($assunto_nome, 'UTF-8');
3442.                                      
3443.                                     if ($len <= 20) {
3444.                                         $fontSize = 12;
3445.                                     } 
3446.                                     
3447.                                     else{
3448.                                         $fontSize = 9;
3449.                                     }
3450.                                     if($qtd_letra > 25 ){
3451.                                         $fontSize = 10;
3452.                                     }
3453.                                     $html .= '<li style="font-size: ' . $fontSize . 'px;">' . $assunto_nome. '</li>';
3454.                                     }
3455.                                     $html .= '</div><br>
3456.                                     <div class="lis3"><hr>
3457.                                     
3458.                                     <p>ARQUIVOS GESTÃO DOCUMENTAL</p>
3459.                                     <h5><img src="https://index.arquivosdoc.com.br/img/logo_menu.png" class="img"></h5>
3460.                                     </div>
3461.                                     
3462.                                 </div>';
3463.                     
3464.                                 #if ($count == 4) {
3465.                                  #   $html .= '<div style="page-break-after: always;"></div>';
3466.                                 #}
3467.                             }
3468.                    
3469.     
3470.                     
3471.                     
3472.             
3473.     
3474.                     $html .= '</div></body></html>';
3475.                 }
3476.         
3477.                 // Configurar o Dompdf
3478.                 $options = new Options();
3479.                 $options->set('isHtml5ParserEnabled', true);
3480.                 $options->set('isPhpEnabled', true);
3481.                 $options->set('isRemoteEnabled', true);
3482.                 $dompdf = new Dompdf($options);
3483.                 $dompdf->loadHtml($html);
3484.                 $dompdf->setPaper('A4', 'portrait');
3485.         
3486.                 // LIMPA TODOS OS BUFFERS ANTES DE RENDERIZAR
3487.                 while (ob_get_level()) {
3488.                     ob_end_clean();
3489.                 }
3490.         
3491.                 // Tenta renderizar e, em vez de stream() direto, grava em arquivo temporário e envia
3492.                 try {
3493.                     $dompdf->render();
3494.                 } catch (Throwable $e) {
3495.                     // registra o erro e lança para cair no catch externo
3496.                     error_log('Dompdf render failed: ' . $e->getMessage());
3497.                     throw $e;
3498.                 }
3499.         
3500.                 // Gera arquivo temporário seguro
3501.                 $tempFile = sys_get_temp_dir() . DIRECTORY_SEPARATOR . 'etiqueta_fluxo_' . $id_fluxo . '_' . uniqid() . '.pdf';
3502.                 $output = $dompdf->output();
3503.         
3504.                 if (file_put_contents($tempFile, $output) === false) {
3505.                     throw new Exception('Falha ao escrever arquivo temporário do PDF.');
3506.                 }
3507.         
3508.                 // Força headers corretos para download/visualização
3509.                 header('Content-Type: application/pdf');
3510.                 // Se quiser forçar download use attachment; se quiser abrir no browser use inline
3511.                 header('Content-Disposition: inline; filename="Etiqueta_Fluxo_' . preg_replace('/[^A-Za-z0-9_\-\.]/', '_', $id_fluxo . '_' . $nome_fluxo) . '.pdf"');
3512.                 header('Content-Length: ' . filesize($tempFile));
3513.                 header('Cache-Control: private, max-age=0, must-revalidate');
3514.         
3515.                 // Envia o arquivo binário ao navegador
3516.                 readfile($tempFile);
3517.         
3518.                 // Remove o arquivo temporário com segurança
3519.                 @unlink($tempFile);
3520.         
3521.                 // finaliza execução
3522.                 exit;
3523.         
3524.                 
3525.        
3526.         
3527.         }
3528.        
3529.         
3530.         return $this->render('index/index5.html.twig', [
3531.             'clienteAll' => $cliente->getClienteAll()->getId(),
3532.             'fluxos' => $fluxos,
3533.             'p'=>$p,
3534.             'erro'=>$erro,
3535.             'pagina' => $pagina,
3536.             'a' => $a,
3537.              
3539.         ]);
3540.     }
3541.     
3542.     
3543.     #[Route('/index/fluxo/diagrama/{id}', name: 'diagrama')]
3544.     public function diagrama( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer,$id): Response
3545.     {
3546.         $user_logado = $this->getUser();
3547.         $erro = '';
3548.         $pagina = 'fluxo';
3549.         $p ='';
3552.         $clienteId = $session->get('cliente_id');
3553.         
3554.         if($clienteId == null){
3555.             
3556.             return $this->redirectToRoute('home');
3557.         }
3558.         
3559.         $fluxo_diagrama = $doctrine->getRepository(Fluxo::class)->find($id);
3560.         $fluxo_caixas_diagrama = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo_diagrama->getId());
3561.             
3562.  
3563.     
3564.         return $this->render('index/diagrama.html.twig', [
3565.     
3566.             'p'=>$p,
3567.             'erro'=>$erro,
3568.             'pagina' => $pagina,
3569.             "fluxo_diagrama" => $fluxo_diagrama,
3570.             "fluxo_caixas_diagrama" => $fluxo_caixas_diagrama
3571.              
3573.         ]);
3574.     }
3576.     #[Route('/index/recebimento/{id}', name: 'recebimento')]
3577.     public function recebimento( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer,$id): Response
3578.     {
3579.         $user_logado = $this->getUser();
3580.         $user_nome = $user_logado->getNome();
3581.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
3582.         $erro = '';
3583.         $pagina = 'home';
3584.         $p ='';
3585.         $ged = ""; 
3586.         $log = "";
3587.         $caixa_manual = "";
3588.         $caixa_auto = "";
3589.         $cx_ultimo = $doctrine->getRepository(Cx::class)->findUltimo();
3590.         $etapa = $doctrine->getRepository(Etapa::class)->findWithAllRelations($id);
3591.         $fluxo = $etapa->getFluxo();
3592.         $cliente_fluxo = $fluxo->getCliente()->getId();
3593.         $clienteId = $session->get('cliente_id');
3594.         $cliente = $doctrine->getRepository(Cliente::class)->findWithRelations($cliente_fluxo);
3595.         $clienteAll =  $cliente->getClienteAll();
3596.         $cliente_nome =  $cliente->getNome();
3597.         $clienteAll_id =  $clienteAll->getId();
3598.         $count = 0; // Contador de QR Codes
3599.         $id_cx_ultimo = 0;
3600.         $date_hoje = new \DateTimeImmutable('America/Sao_Paulo');
3601.         
3602.         $caixas_setor = $entityManager->getRepository(Cliente::class)->findCaixasByClienteId($cliente_fluxo);
3603.         
3604.         $query = $entityManager->createQuery("
3605.             SELECT c FROM App\Entity\Cx c
3606.             LEFT JOIN c.caixas cx
3607.             WHERE c.cliente = :clienteId
3608.             AND cx.id IS NULL
3609.         ");
3611.         $query->setParameter('clienteId', $clienteAll_id);
3612.         $cx_setor = $query->getResult();
3614.         foreach ($cx_ultimo as $key_id) {
3615.             
3616.             $id_cx_ultimo = $key_id->getNome();
3617.         }
3618.         
3620.         if(isset($_POST["btn_cliente"])){
3621.             
3622.             $session->set('cliente_id', $_POST["btn_cliente"]);
3623.             return $this->redirectToRoute('home');
3624.         }
3625.         
3626.         if($clienteId == null){
3627.             
3628.             return $this->redirectToRoute('home');
3629.         }
3630.         
3632.         if ($request->isMethod('POST')) {
3633.             
3634.           
3635.             
3636.             if(isset($_POST["tipo"])){
3637.                  $tp = $_POST["tipo"];
3638.                
3639.                if($tp =='caixa'){
3640.                    
3641.                     if($_POST["qtd_caixa"] != ""){
3642.     
3643.     
3644.                         if (isset($_POST["ged"]) || isset($_POST["log"])) {
3645.     
3646.                                 if (isset($_POST["ged"])) {
3647.                                     
3648.                                     $ged = "ok";
3649.     
3650.                                     if (isset($_POST["caixa_manual"]) || isset($_POST["caixa_auto"])) {
3651.     
3652.                                         if (isset($_POST["caixa_manual"])) {
3653.     
3654.                                             $caixa_manual = "ok";
3655.             
3656.                                         }
3657.                                         if (isset($_POST["caixa_auto"])) {
3658.     
3659.                                             $caixa_auto = "ok";
3660.             
3661.                                         }
3662.     
3663.                                     }else{
3664.                                         echo "<script>alert('ERROR , Selecione o modo de Identificação do ArquivosGED (Manual ou Automático)!');</script>";
3665.                                     }
3666.             
3667.                                 }
3668.     
3669.     
3670.     
3671.                                 if (isset($_POST["log"])) {
3672.     
3673.                                     $log = "ok";
3674.                                     
3675.     
3676.                                 }
3677.     
3678.                                 if ($ged == "ok" and $caixa_manual =="ok") {
3679.     
3680.                                     $caixa = $_POST["caixa"];
3681.                                     $qtd_caixas = 0;
3682.     
3683.     
3684.                                     $options = new Options();
3685.                                     $options->set('isHtml5ParserEnabled', true);
3686.                                     $options->set('isPhpEnabled', true);
3687.                                     $dompdf = new Dompdf($options);
3688.                         
3689.                                     $html = '
3690.                                     <html>
3691.                                         <head>
3692.                                             <style>
3693.                                                 @page {
3694.                                                     margin: 35px 18.9px 0px 18.9px;
3695.                                                     size: 210mm 297mm; /* Ajuste de tamanho do papel */
3696.                                                 }
3697.                         
3698.                                                 body {
3699.                                                     margin: 0;
3700.                                                     padding: 0;
3701.                                                 }
3702.                                                 
3703.                                                 .qr-item {
3704.                                                     border: 2px dotted #000;
3705.                                                     text-align: center;
3706.                                                     width: 32.27mm;
3707.                                                     height: 34.9mm; 
3708.                                                     display: inline-block;
3709.                                                 }
3710.                                     
3711.                                                 .qr-item img {
3712.                                                     width: 115px; 
3713.                                                     height: 112px;
3714.                                                 }
3715.                         
3716.                                                 .qr-title {
3717.                                                     font-size: 16px;
3718.                                                     font-weight: bold;
3719.                                                 }
3720.                         
3721.                                                 .leo {
3722.                                                     display: flex;
3723.                                                     flex-wrap: wrap;
3724.                                                 }
3725.                                             </style>
3726.                                         </head>
3727.                                         <body> 
3728.                                       
3729.                                     ';
3730.                         
3731.                         
3732.                                     
3733.                                     foreach ($caixa as $key) {
3734.     
3735.                                         if ($key != "" ) {
3736.                                             $qtd_caixas ++ ;
3737.                                             $caixas = new Caixa();
3738.                                            
3739.                                            
3740.                                             if ($ged == "ok" and $log =="ok") {
3741.                                                 
3742.                                                 $cx = new Cx();
3743.                                                 $id_cx_ultimo ++;
3744.                                                 $cx->setNome($id_cx_ultimo);
3745.                                                 $cx->setStatus(2);
3746.                                                 $cx->setTexto($key);
3747.                                                 $cx->setImage('ArquivosGED');
3748.                                                 $cx->setCliente($clienteAll);
3749.                                                 $entityManager->persist($cx);
3750.                                                 $entityManager->flush();
3751.     
3752.                                                 $id_cx=$cx->getId();
3753.                                                 $caixas->setCx($entityManager->getRepository(Cx::class)->find($id_cx));
3754.     
3755.                                                 // Gerar QR Code com imagem no centro
3756.                                                 $result = Builder::create()
3757.                                                 ->writer(new PngWriter())
3758.                                                 ->writerOptions([])
3759.                                                 ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$id_cx_ultimo)
3760.                                                 ->encoding(new Encoding('UTF-8'))
3761.                                                 ->size(500)
3762.                                                 ->margin(5)
3763.                                                 ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
3764.                                                 ->build();
3765.                                                 // Salvar QR Code como arquivo temporário
3766.                                                 $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
3767.                                                 $result->saveToFile($tempFile);
3768.                                                 
3769.                                                 // Adicionar QR Code ao HTML
3770.                                                 if ($count % 48 == 0) {
3771.                                                     $html .= '<div class="leo">';
3772.                                                 }
3773.                                 
3774.                                                 // Adicionar QR Code ao HTML
3775.                                                 $html .= '<div class="qr-item">';
3776.                                                 $html .= '<div class="qr-title">' . $id_cx_ultimo . '</div>';
3777.                                                 $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
3778.                                                 $html .= '</div>';
3779.                                                 
3780.                                                 
3781.                                                  $count++;
3782.     
3783.                                                // Fechar a div e inserir quebra de página a cada 63 QR Codes
3784.                                                if ($count % 48 == 0) {
3785.                                                    $html .= '</div><div style="page-break-after: always;"></div>';
3786.                                                }
3787.                                                 
3788.                                             }
3789.     
3790.                                             
3791.                                             $caixas->setNome($key);
3792.                                             $caixas->addCliente($cliente);
3793.                                             $caixas->setFluxo($fluxo);
3794.                                             $entityManager->persist($caixas);
3795.                                             $entityManager->flush();
3796.                                             $id_caixa = $caixas->getId();
3797.                                             
3798.                                                 
3799.                                         }
3800.                                     }
3801.                                         if ($ged == "ok" and $log =="ok") {
3802.                                             
3803.                                               // Fechar qualquer div aberta sem completar 63 itens
3804.                                              if ($count % 48 != 0) {
3805.                                                 $html .= '</div>';
3806.                                             }
3807.     
3808.                                             $html .= '</div></body></html>';
3809.                                 
3810.                                             // Carregar o HTML e gerar o PDF
3811.                                             $dompdf->loadHtml($html);
3812.                                             $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
3813.                                             $dompdf->render();
3814.                                             #file_put_contents('sample1.pdf', $dompdf->output());
3815.                                             $dompdf->stream('dompdf', array('Attachment' => 0));
3816.                                         }
3817.     
3818.                                             $registro = new Registro();
3819.                                             $registro->setOperacao('RECEBIMENTO DE '.$qtd_caixas. ' CAIXA(S)'); 
3820.                                             $registro->setUser($user_nome);
3821.                                             $registro->setCliente($cliente_nome);
3822.                                             $registro->setIp($ip_cliente);
3823.                                             $entityManager->persist($registro);
3824.                                             $entityManager->flush();
3825.     
3826.                                             $etapa->setRegistro($registro);
3827.                                             $etapa->setObs($_POST["obs_caixa"]);
3828.                                             $etapa->setUpdatedAt($date_hoje);
3829.                                             $entityManager->flush();
3830.                                             $erro = 'ok';
3831.                                             $p = "Recbimento com sucesso";
3832.                                     
3833.     
3834.                                 }
3835.     
3836.                                 if ($ged == "ok" and $caixa_auto =="ok") {
3837.     
3838.                                     
3839.                                     if (isset($_POST["auto_ged"])) {
3840.     
3841.                                         $qtd_nome_caixa = $_POST["qtd_caixa"];
3842.                                         $nome_caixa_parti = $_POST["auto_ged"];
3843.                                         
3844.     
3845.     
3846.     
3847.                                         $options = new Options();
3848.                                         $options->set('isHtml5ParserEnabled', true);
3849.                                         $options->set('isPhpEnabled', true);
3850.                                         $dompdf = new Dompdf($options);
3851.                             
3852.                                         $html = '
3853.                                         <html>
3854.                                             <head>
3855.                                                 <style>
3856.                                                     @page {
3857.                                                         margin: 35px 18.9px 0px 18.9px;
3858.                                                         size: 210mm 297mm; /* Ajuste de tamanho do papel */
3859.                                                     }
3860.                             
3861.                                                     body {
3862.                                                         margin: 0;
3863.                                                         padding: 0;
3864.                                                     }
3865.                                                     
3866.                                                    .qr-item {
3867.                                                     border: 2px dotted #000;
3868.                                                     text-align: center;
3869.                                                     width: 32.27mm;
3870.                                                     height: 34.9mm; 
3871.                                                     display: inline-block;
3872.                                                 }
3873.                                     
3874.                                                 .qr-item img {
3875.                                                     width: 115px; 
3876.                                                     height: 112px;
3877.                                                 }
3878.                                     
3879.                                                     .qr-title {
3880.                                                         font-size: 16px;
3881.                                                         font-weight: bold;
3882.                                                     }
3883.                             
3884.                                                     .leo {
3885.                                                         display: flex;
3886.                                                         flex-wrap: wrap;
3887.                                                     }
3888.                                                 </style>
3889.                                             </head>
3890.                                             <body> 
3891.                                               
3892.                                         ';
3893.                         
3894.                         
3895.     
3896.     
3897.                                         for ($i=0; $i < $qtd_nome_caixa; $i++) { 
3898.                                             
3899.                                             $caixas = new Caixa();
3900.     
3901.                                             if ($ged == "ok" and $log =="ok") {
3902.                                                 
3903.                                                 $cx = new Cx();
3904.                                                 $id_cx_ultimo ++;
3905.                                                 $cx->setNome($id_cx_ultimo);
3906.                                                 $cx->setStatus(2);
3907.                                                 $cx->setTexto('Caixa '.$nome_caixa_parti);
3908.                                                 $cx->setImage('ArquivosGED');
3909.                                                 $cx->setCliente($clienteAll);
3910.                                                 $entityManager->persist($cx);
3911.                                                 $entityManager->flush();
3912.     
3913.                                                 $id_cx=$cx->getId();
3914.                                                 $caixas->setCx($entityManager->getRepository(Cx::class)->find($id_cx));
3915.     
3916.                                                   // Gerar QR Code com imagem no centro
3917.                                                 $result = Builder::create()
3918.                                                   ->writer(new PngWriter())
3919.                                                   ->writerOptions([])
3920.                                                   ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$id_cx_ultimo)
3921.                                                   ->encoding(new Encoding('UTF-8'))
3922.                                                   ->size(500)
3923.                                                   ->margin(5)
3924.                                                   ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
3925.                                                   ->build();
3926.                                                   // Salvar QR Code como arquivo temporário
3927.                                                   $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
3928.                                                   $result->saveToFile($tempFile);
3929.                                                     
3930.                                                 // Adicionar QR Code ao HTML
3931.                                                     if ($count % 48 == 0) {
3932.                                                         $html .= '<div class="leo">';
3933.                                                     }    
3934.                                                     
3935.                                                   // Adicionar QR Code ao HTML
3936.                                                   $html .= '<div class="qr-item">';
3937.                                                   $html .= '<div class="qr-title">' . $id_cx_ultimo . '</div>';
3938.                                                   $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
3939.                                                   $html .= '</div>';
3940.                                                   
3941.                                                    $count++;
3942.                                         
3943.                                                    // Fechar a div e inserir quebra de página a cada 63 QR Codes
3944.                                                    if ($count % 48 == 0) {
3945.                                                        $html .= '</div><div style="page-break-after: always;"></div>';
3946.                                                    }
3947.                                                 
3948.                                             }
3949.     
3950.     
3951.                                             $caixas->setNome('Caixa '.$nome_caixa_parti);
3952.                                             $caixas->addCliente($cliente);
3953.                                             $caixas->setFluxo($fluxo);
3954.                                             $entityManager->persist($caixas);
3955.                                             $entityManager->flush();
3956.                                             $nome_caixa_parti++;
3957.                                             
3958.     
3959.                                         }
3960.     
3961.                                         if ($ged == "ok" and $log =="ok") {
3962.                                     
3963.                                              // Fechar qualquer div aberta sem completar 63 itens
3964.                                              if ($count % 48 != 0) {
3965.                                                 $html .= '</div>';
3966.                                             }
3967.                                             
3968.                                             $html .= '</div></body></html>';
3969.                                     
3970.                                             // Carregar o HTML e gerar o PDF
3971.                                             $dompdf->loadHtml($html);
3972.                                             $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
3973.                                             $dompdf->render();
3974.                                             #file_put_contents('sample1.pdf', $dompdf->output());
3975.                                             $dompdf->stream('dompdf', array('Attachment' => 0));
3976.                                         }    
3977.     
3978.                                         $registro = new Registro();
3979.                                         $registro->setOperacao('RECEBIMENTO DE '.$qtd_nome_caixa. ' CAIXA(S)'); 
3980.                                         $registro->setUser($user_nome);
3981.                                         $registro->setCliente($cliente_nome);
3982.                                         $registro->setIp($ip_cliente);
3983.                                         $entityManager->persist($registro);
3984.                                         $entityManager->flush();
3985.                                         
3986.                                         $etapa->setUpdatedAt($date_hoje);
3987.                                         $etapa->setRegistro($registro);
3988.                                         $entityManager->flush();
3989.     
3990.                                         $erro = 'ok';
3991.                                         $p = "Recbimento com sucesso";
3992.                                         
3993.                                     }
3994.     
3995.                                 }
3996.     
3997.     
3998.     
3999.                                 if ($ged != "ok" and $log =="ok") {
4000.                                     
4001.                                     $qtd_caixa_ = $_POST["qtd_caixa"];
4002.                                     $options = new Options();
4003.                                     $options->set('isHtml5ParserEnabled', true);
4004.                                     $options->set('isPhpEnabled', true);
4005.                                     $dompdf = new Dompdf($options);
4006.                             
4007.                                         $html = '
4008.                                         <html>
4009.                                             <head>
4010.                                                 <style>
4011.                                                     @page {
4012.                                                         margin: 35px 18.9px 0px 18.9px;
4013.                                                         size: 210mm 297mm; /* Ajuste de tamanho do papel */
4014.                                                     }
4015.                             
4016.                                                     body {
4017.                                                         margin: 0;
4018.                                                         padding: 0;
4019.                                                     }
4020.                                                     
4021.                                                     .qr-item {
4022.                                                         border: 2px dotted #000;
4023.                                                         text-align: center;
4024.                                                         width: 27.5mm;
4025.                                                         height: 30.5mm; 
4026.                                                         display: inline-block;
4027.                                                     }
4028.                             
4029.                                                     .qr-item img {
4030.                                                         width: 105px; 
4031.                                                         height: 100px;
4032.                                                     }
4033.                             
4034.                                                     .qr-title {
4035.                                                         font-size: 16px;
4036.                                                         font-weight: bold;
4037.                                                     }
4038.                             
4039.                                                     .leo {
4040.                                                         display: flex;
4041.                                                         flex-wrap: wrap;
4042.                                                     }
4043.                                                 </style>
4044.                                             </head>
4045.                                             <body> 
4046.                                                 <div class="leo">    
4047.                                         ';
4048.     
4049.     
4050.     
4051.                                     for ($i=0; $i < $qtd_caixa_; $i++) { 
4052.                                             
4053.                                                 $id_cx_ultimo ++;
4054.                                                 // Gerar QR Code com imagem no centro
4055.                                             $result = Builder::create()
4056.                                                 ->writer(new PngWriter())
4057.                                                 ->writerOptions([])
4058.                                                 ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$id_cx_ultimo)
4059.                                                 ->encoding(new Encoding('UTF-8'))
4060.                                                 ->size(300)
4061.                                                 ->margin(10)
4062.                                                 ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
4063.                                                 ->build();
4064.                                                 // Salvar QR Code como arquivo temporário
4065.                                                 $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
4066.                                                 $result->saveToFile($tempFile);
4067.                                 
4068.                                                 // Adicionar QR Code ao HTML
4069.                                                 $html .= '<div class="qr-item">';
4070.                                                 $html .= '<div class="qr-title">' . $id_cx_ultimo . '</div>';
4071.                                                 $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
4072.                                                 $html .= '</div>';
4073.                                     }
4074.                                     
4075.                                     $html .= '</div></body></html>';
4076.                             
4077.                                     // Carregar o HTML e gerar o PDF
4078.                                     $dompdf->loadHtml($html);
4079.                                     $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
4080.                                     $dompdf->render();
4081.                                     file_put_contents('sample1.pdf', $dompdf->output());
4082.                                     $dompdf->stream('dompdf', array('Attachment' => 1));
4083.     
4084.     
4085.                                     $registro = new Registro();
4086.                                     $registro->setOperacao('RECEBIMENTO DE '.$qtd_caixa_. ' CAIXA(S)'); 
4087.                                     $registro->setUser($user_nome);
4088.                                     $registro->setCliente($cliente_nome);
4089.                                     $registro->setIp($ip_cliente);
4090.                                     $entityManager->persist($registro);
4091.                                     $entityManager->flush();
4092.                                     
4093.                                     $etapa->setUpdatedAt($date_hoje);
4094.                                     $etapa->setRegistro($registro);
4095.                                     $entityManager->flush();
4096.     
4097.                                     $erro = 'ok';
4098.                                     $p = "Recbimento com sucesso";
4099.     
4100.     
4101.                                 }
4102.     
4103.     
4104.     
4105.     
4106.                             } else {
4107.     
4108.                             echo "<script>alert('ERROR , Selecione a Identificação!');</script>";
4109.                         }
4110.                          
4111.                     }else {
4112.                         echo "<script>alert('ERROR , Selecione a Quantidade!');</script>";
4113.                     }
4114.                }
4115.                
4116.                 if($tp =='doc'){
4119.                     if(isset($_POST["check_cx_e"])){
4120.                         $yz = "yes";
4121.                         $checkBoxes = $request->request->all('inputs_cx_e');
4122.                         $xy = 0;
4123.                         $qtd_caixas=0;
4124.                         
4125.       
4126.                         foreach ($checkBoxes as $id => $nome) {
4127.                             $cx_ = $doctrine->getRepository(Cx::class)->find($id);
4128.                             $_nome =  $cx_->getNome();
4129.                            
4130.                             if ($nome =="") {
4131.                                
4132.                                 echo "<script>alert('ERROR, Digite no campo gerado acima da tabela qual será repositorio do  ID: $_nome!');</script>";
4133.                             }
4135.                             if ($nome != "" ) {
4136.                                 $id_cx_ultimo = $_nome ;
4137.                                 $qtd_caixas++;
4138.                                 $xy = 1;
4139.                                 $caixas = new Caixa();
4140.                                 $caixas->setNome($nome);
4141.                                 $caixas->addCliente($cliente);
4142.                                 $caixas->setFluxo($fluxo);
4143.                                 $caixas->setCx($cx_);
4144.                                 $entityManager->persist($caixas);
4145.                                 $entityManager->flush();
4147.                                 $registro = new Registro();
4148.                                 $registro->setOperacao('RECEBIMENTO DA ID EXISTENTE '.$_nome); 
4149.                                 $registro->setUser($user_nome);
4150.                                 $registro->setCliente($cliente_nome);
4151.                                 $registro->setIp($ip_cliente);
4152.                                 $entityManager->persist($registro);
4153.                                 $entityManager->flush();
4155.                                 
4156.                                 
4157.                                 
4158.                             }
4160.                             
4161.                         }
4163.                        
4165.                         if($xy==1){
4167.                             $etapa->setRegistro($registro);
4168.                             $etapa->setObs($_POST["obs_caixa"]);
4169.                             $etapa->setUpdatedAt($date_hoje);
4170.                             $entityManager->flush();
4171.                             
4173.                             $registro = new Registro();
4174.                             $registro->setOperacao('RECEBIMENTO DE  '.$qtd_caixas. ' CAIXA(S) '); 
4175.                             $registro->setUser($user_nome);
4176.                             $registro->setCliente($cliente_nome);
4177.                             $registro->setIp($ip_cliente);
4178.                             $entityManager->persist($registro);
4179.                             $entityManager->flush();
4181.                             $erro = 'ok';
4182.                             $p = "Recbimento com sucesso";
4183.                         }
4186.                       
4187.                     }else{
4188.                         $zy = "not";
4189.                     }
4191.                     if(isset($_POST["check_caixa_e"])){
4192.                         $zy = "yes";
4193.                         $options = new Options();
4194.                         $options->set('isHtml5ParserEnabled', true);
4195.                         $options->set('debugKeepTemp', true);
4196.                         $options->set('isPhpEnabled', true);
4197.                         $dompdf = new Dompdf($options);
4198.                         
4199.                         $html = '
4200.                                     <html>
4201.                                         <head>
4202.                                             <style>
4203.                                                 @page {
4204.                                                     margin: 35px 18.9px 0px 18.9px;
4205.                                                     size: 210mm 297mm; /* Ajuste de tamanho do papel */
4206.                                                 }
4207.                         
4208.                                                 body {
4209.                                                     margin: 0;
4210.                                                     padding: 0;
4211.                                                 }
4212.                                                 
4213.                                                 .qr-item {
4214.                                                     border: 2px dotted #000;
4215.                                                     text-align: center;
4216.                                                     width: 32.27mm;
4217.                                                     height: 34.9mm; 
4218.                                                     display: inline-block;
4219.                                                 }
4220.                                     
4221.                                                 .qr-item img {
4222.                                                     width: 115px; 
4223.                                                     height: 112px;
4224.                                                 }
4225.                         
4226.                                                 .qr-title {
4227.                                                     font-size: 16px;
4228.                                                     font-weight: bold;
4229.                                                 }
4230.                         
4231.                                                 .leo {
4232.                                                     display: flex;
4233.                                                     flex-wrap: wrap;
4234.                                                 }
4235.                                             </style>
4236.                                         </head>
4237.                                         <body> 
4238.                                     
4239.                                     ';
4240.                         
4241.                         $ckeck = $_POST["caixa_e"];
4242.                         $xy = 0;
4243.                         $qtd_caixas=0;
4244.                 
4245.                         foreach ($ckeck as $key) {
4246.                             $nome_k = NULL;
4247.                             $caixa_k = $doctrine->getRepository(Caixa::class)->find($key);
4248.                             if($caixa_k != NULL ){
4249.                                 $nome_k = $caixa_k->getNome();
4250.                             }
4251.                             
4252.                             if ($clienteAll_id != 18) {
4253.                             
4254.                                 $cx = new Cx();
4255.                                 $id_cx_ultimo ++;
4256.                                 $cx->setNome($id_cx_ultimo);
4257.                                 $cx->setStatus(2);
4258.                                 $cx->setTexto($nome_k);
4259.                                 $cx->setImage('ArquivosGED');
4260.                                 $cx->setCliente($clienteAll);
4261.                                 $entityManager->persist($cx);
4262.                                 $entityManager->flush();
4263.                                 $caixa_k->setCx($cx);
4264.                                 
4265.                             }
4266.                             
4267.                             $caixa_k->setFluxo($fluxo);
4268.                             $entityManager->flush();
4270.                             $registro = new Registro();
4271.                             $registro->setOperacao('RECEBIMENTO DA CAIXA EXISTENTE '.$nome_k); 
4272.                             $registro->setUser($user_nome);
4273.                             $registro->setCliente($cliente_nome);
4274.                             $registro->setIp($ip_cliente);
4275.                             $entityManager->persist($registro);
4276.                             $entityManager->flush();
4279.                             // Gerar QR Code com imagem no centro
4280.                             $result = Builder::create()
4281.                              ->writer(new PngWriter())
4282.                              ->writerOptions([])
4283.                              ->data('https://logistica.arquivosdoc.com.br/'.$clienteAll_id.'/'.$id_cx_ultimo)
4284.                              ->encoding(new Encoding('UTF-8'))
4285.                              ->size(500)
4286.                              ->margin(5)
4287.                              ->logoPath(__DIR__ . '/logo.png') // Caminho do logo central
4288.                              ->build();
4289.                              // Salvar QR Code como arquivo temporário
4290.                              $tempFile = tempnam(sys_get_temp_dir(), 'qr_') . '.png';
4291.                              $result->saveToFile($tempFile);
4292.                              
4293.                              // Adicionar QR Code ao HTML
4294.                              if ($count % 48 == 0) {
4295.                                  $html .= '<div class="leo">';
4296.                              }
4297.              
4298.                              // Adicionar QR Code ao HTML
4299.                              $html .= '<div class="qr-item">';
4300.                              $html .= '<div class="qr-title">' . $id_cx_ultimo . '</div>';
4301.                              $html .= '<img src="data:image/png;base64,' . base64_encode(file_get_contents($tempFile)) . '">';
4302.                              $html .= '</div>';
4303.                              
4304.                              
4305.                              $count++;
4307.                             // Fechar a div e inserir quebra de página a cada 63 QR Codes
4308.                             if ($count % 48 == 0) {
4309.                                 $html .= '</div><div style="page-break-after: always;"></div>';
4310.                             }
4312.                              
4313.                             
4314.                         }
4316.                         // Fechar qualquer div aberta sem completar 63 itens
4317.                         if ($count % 48 != 0) {
4318.                             $html .= '</div>';
4319.                         }
4320.                          
4321.                         $html .= '</div></body></html>';
4322.                         
4323.                         if ($clienteAll_id != 18) {  
4324.                             // Carregar o HTML e gerar o PDF
4325.                             $dompdf->loadHtml($html);
4326.                             $dompdf->setPaper([0, 0, 210, 297], 'portrait'); // Configurar o tamanho de página para A4
4327.                             $dompdf->render();
4328.                             #file_put_contents('sample1.pdf', $dompdf->output());
4329.                             $dompdf->stream('dompdf', array('Attachment' => 0));
4330.                         }
4332.                         if($xy==1){
4334.                             $etapa->setRegistro($registro);
4335.                             $etapa->setUpdatedAt($date_hoje);
4336.                             $etapa->setObs($_POST["obs_caixa"]);
4337.                             $entityManager->flush();
4338.                             
4340.                             $registro = new Registro();
4341.                             $registro->setOperacao('RECEBIMENTO DE  '.$qtd_caixas. ' CAIXA(S) '); 
4342.                             $registro->setUser($user_nome);
4343.                             $registro->setCliente($cliente_nome);
4344.                             $registro->setIp($ip_cliente);
4345.                             $entityManager->persist($registro);
4346.                             $entityManager->flush();
4348.                             $erro = 'ok';
4349.                             $p = "Recbimento com sucesso";
4350.                         }
4353.                       
4354.                     }else{
4355.                         $yz = "not";
4356.                     }
4358.                     if ($yz == "not" and $zy="not") {
4360.                         echo "<script>alert('ERROR , Preencha corretamente o formulario, está sem valor , selecione todas as opções necessaria!');</script>";
4361.                     }
4362.                    
4363.                 }
4364.                
4365.                
4366.                
4367.                
4368.             }else {
4369.                 echo "<script>alert('ERROR , Selecione o tipo!');</script>";
4370.             }
4371.             
4372.         }
4374.         return $this->render('index/recebimento.html.twig', [
4375.     
4376.             
4377.             'p'=>$p,
4378.             'erro'=>$erro,
4379.             'pagina' => $pagina,
4380.             'etapa'=>$etapa,
4381.             'caixas_setor' => $caixas_setor,
4382.             'cx_setor' => $cx_setor
4383.             
4384.             
4386.         ]);
4387.     }
4389.     #[Route('/index/higienizacao/{id}', name: 'higienizacao')]
4390.     public function higienizacao( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer,$id): Response
4391.     {
4392.         $user_logado = $this->getUser();
4393.         $user_nome = $user_logado->getNome();
4394.         $date_hoje = new \DateTimeImmutable('America/Sao_Paulo');
4395.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
4396.         $erro = '';
4397.         $pagina = 'home';
4398.         $p ='';
4399.         $a = 0 ;
4400.         $clienteAll = null;
4401.         $cx = null;
4402.         $caixa = null; 
4403.         $etapa = $doctrine->getRepository(Etapa::class)->findWithAllRelations($id);
4404.         $fluxo = $etapa->getFluxo();
4405.         $etapa_caixas = $etapa->getCaixa()->toArray();
4406.         $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo->getId());
4407.        
4408.         $e = 0;
4409.         $f = 0;
4410.         $clienteId = $session->get('cliente_id');
4411.         if($clienteId == null){
4412.             
4413.             return $this->redirectToRoute('home');
4414.         }
4415.         
4416.         
4417.         foreach ($etapa_caixas as $key) {
4418.             $e++;
4419.         }
4420.         foreach ($fluxo_caixas as $key) {
4421.             $f++;
4422.         }
4424.         if(isset($_POST["a"])){
4425.             $a = 2;
4426.         }
4427.         
4428.         $qrCodeData = $request->request->get('qrcode');
4429.         if(isset($_POST["id_caixas"])){
4430.             $a = 1 ;
4431.             $caixa = $doctrine->getRepository(Caixa::class)->findBy(['id' => $_POST["id_caixas"]]);
4432.             
4433.             foreach ($caixa as $key) { $caixa_cx_id = $key->getClientes()->toArray();}
4434.             
4435.             $cx =  $caixa_cx_id ;
4436.             
4437.             foreach ($cx as $key) {$cliente_cx_id = $key->getClienteAll()->getId();}
4438.             
4439.             $clienteAll = $doctrine->getRepository(ClienteAll::class)->findClienteWithRelations($cliente_cx_id);
4440.            
4441.             
4442.         }
4443.         if($qrCodeData != null){
4445.             
4446.             $url = $qrCodeData;
4447.             preg_match('/(\d+)\/(\d+)$/', $url, $matches);
4449.             if (!empty($matches)) {
4450.                 $numero1 = $matches[1]; 
4451.                 $numero2 = $matches[2];
4452.                 $clienteAll = $doctrine->getRepository(ClienteAll::class)->find($numero1);
4453.                 $cx = $doctrine->getRepository(Cx::class)->findBy(['nome' => $numero2]);
4454.                 
4455.                 foreach ($cx as $key) {
4457.                     $cx_id = $key->getId();
4458.                 }
4459.                     
4460.                 
4461.                 $caixa = $doctrine->getRepository(Caixa::class)->findBy(['cx' => $cx_id ]);
4462.                 $a = 1 ;
4463.                 
4464.             } else {
4465.                 
4466.               
4467.             }
4468.             
4469.         }
4471.         if(isset($_POST["cx"])){
4473.             $clienteAll = $doctrine->getRepository(ClienteAll::class)->findClienteWithRelations($_POST["clienteAll"]);
4474.             $clienteAll_nome = $clienteAll->getNome();
4475.             
4476.             $cx = $doctrine->getRepository(Cx::class)->find($_POST["cx"]);
4477.             $caixa = $doctrine->getRepository(Caixa::class)->find($_POST["caixas"]);
4478.             $cliente = $doctrine->getRepository(Cliente::class)->find($_POST["cliente"]);
4479.             
4480.             if ($cx != null) {
4481.                 $cx_nome = 'ID: '.$cx->getNome();
4482.             }else{
4483.                 $cx_nome = 'GED: '.$caixa->getNome();
4484.             }
4485.         
4486.             $cliente_nome = $clienteAll_nome;
4488.             if ($cliente_nome == NULL){
4490.                 $cliente_nome = $cliente->getNome();
4492.             }
4493.             
4494.             
4496.             $registro = new Registro();
4497.             $registro->setOperacao('HIGIENIZAÇÃO '.$cx_nome); 
4498.             $registro->setUser($user_nome);
4499.             $registro->setCliente($cliente_nome);
4500.             $registro->setIp($ip_cliente);
4501.             $entityManager->persist($registro);
4502.             $entityManager->flush();
4503.             
4504.             if($cx != null){
4505.                 
4506.                 $etapa->addCx($cx);
4507.             }
4508.             
4509.             $etapa->addCaixa($caixa);
4510.             $caixa->setHigienizaAt($date_hoje);
4511.             $e++;
4513.             if ($e == $f) {
4515.                 
4516.                 $registro = new Registro();
4517.                 $registro->setOperacao('HIGIENIZAÇÃO DE '.$f. ' CAIXA(S)'); 
4518.                 $registro->setUser('CONCLUIDO PELA EQUIPE');
4519.                 $registro->setCliente($cliente_nome);
4520.                 $registro->setIp($ip_cliente);
4521.                 $entityManager->persist($registro);
4522.                 $entityManager->flush();
4524.                 $etapa->setRegistro($registro);
4525.                 $etapa->setUpdatedAt($date_hoje);
4526.                 $entityManager->flush();
4527.             }
4528.             
4529.             $entityManager->flush();
4530.             $erro = 'ok';
4531.             $p = "Etapa concluída com sucesso";
4532.         }
4533.         
4534.         return $this->render('index/higienizacao.html.twig', [
4535.     
4536.             'id'=>$id,
4537.             'p'=>$p,
4538.             'erro'=>$erro,
4539.             'pagina' => $pagina,
4540.             'a'=>$a,
4541.             'clienteAll' => $clienteAll,
4542.             'cx' =>$cx ,
4543.             'caixa' => $caixa,
4544.             'fluxo_caixas'=>$fluxo_caixas
4545.             
4546.             
4547.             
4549.         ]);
4550.     }
4552.    
4553.     #[Route('/index/digitalizacao/{id}', name: 'digitalizacao')]
4554.     public function digitalizacao(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session,MessageBusInterface $bus,$id): Response
4555.     {
4556.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
4557.         $etapa = $doctrine->getRepository(Etapa::class)->findWithAllRelations($id);
4558.         $fluxo = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($etapa->getFluxo()->getId());
4559.         $cliente_nome = $fluxo->getCliente()->getNome();
4560.         $cliente_id = $fluxo->getCliente();
4561.         $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo->getId());
4562.         $form = $this->createForm(UploadType::class);
4563.         $user_logado = $this->getUser();
4564.         $user_logado_id = $user_logado->getId();
4565.         $userId = $user_logado_id;
4566.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
4567.         $form->handleRequest($request);
4568.         $dotenv = new Dotenv();
4569.         $dotenv->load(__DIR__.'/.env');
4570.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
4571.         $hoje_formt=$hoje->format('Y-m-d') ;
4572.         $dia_prod = 'de hoje';
4573.         $erro = '';
4574.         $ii=0;
4575.         $pagina = 'export';
4576.         $p = '';
4577.         $uuid = Uuid::v4();
4578.         $user = $this->getUser();
4579.         $user_nome= $user->getEmail();
4580.         $user_nome_name= $user->getNome();
4581.         $pasta_user=$user_nome.'/';
4582.         $cliente_alls = "";
4583.         $arr = [];
4584.         $arrr=0;
4585.         $f = 0;
4586.         $dt = '';
4587.         $clientS3 = new  S3Client([
4588.             'region'  => 'sa-east-1',
4589.             'version' => 'latest',
4590.             'credentials' => [ 
4591.                 'key'    => $_ENV['AWS_KEY'],
4592.                 'secret' => $_ENV['AWS_SECRET'],
4593.             ],
4594.         
4595.         ]);
4597.         foreach ($fluxo_caixas as $key) {
4598.             $f++;
4599.         }
4601.         if(isset($_POST["btn_cliente"])){
4602.             
4603.             $session->set('cliente_id', $_POST["btn_cliente"]);
4604.             return $this->redirectToRoute('home');
4605.         }
4606.        
4607.             
4608.             
4609.        
4610.         $clienteId = $session->get('cliente_id');
4611.         
4612.         if ($clienteId == null ) {
4613.             
4614.             $caixas =  "";
4615.             $cliente_session = "";
4616.             return $this->redirectToRoute('home');
4617.        
4618.         } else {
4619.             
4620.             $caixas = $fluxo_caixas;
4621.             $cliente_session =  $doctrine->getRepository(Cliente::class)->find($clienteId);       
4622.         }
4623.         
4624.         
4625.         if(isset($_POST["botao_export"]))
4626.         {
4627.             
4628.             $caixaId = $_POST["caixas"];
4629.             
4630.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($_POST["caixas"]);
4631.             $clientes= $cliente_id->getId();
4632.             $cliente_alls = $cliente_id->getClienteAll()->getId();
4633.             $clienteId=$clientes;
4635.             $clientes_status= $cliente_id->getExtraFields();
4636.             if(!$clientes_status){
4637.                 $clientes_status="ged";
4638.             }
4639.             $conteiner = $_POST["conteiner"];
4640.             $cont_file = 0 ;
4641.             $umlautString =$cliente_nome;
4642.             $slugger = new AsciiSlugger();
4643.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
4644.             $caminho = strtolower ($teste.'/');
4645.                     
4646.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
4647.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
4648.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
4649.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
4650.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
4651.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
4652.             if($clientes ==  15){$caminho='cbsi-dossies/';}
4653.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
4654.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
4655.             if($clientes ==  40){$caminho='fasf-atas-e-diario/';}
4656.             if($clientes ==  127){$caminho='pmecj-s-a.A) - ALMOXARIFADO E PATRIMÔNIO/';}
4657.            
4658.             $filesTmp  = $_FILES['file']['tmp_name'];
4659.             $filesName = $_FILES['file']['name'];
4660.             
4661.             foreach ($filesTmp as $index => $file) {
4662.             
4663.                 $uuid = Uuid::v4();
4664.                 $cont_file++;
4665.                 // nome original do arquivo
4666.                 $originalName = pathinfo($filesName[$index], PATHINFO_FILENAME);
4667.                 // sanitiza o nome (remove acentos, espaços estranhos etc.)
4668.                 $slugger = new AsciiSlugger();
4669.                 $safeName = strtolower($slugger->slug($originalName)->toString());
4670.             
4671.                 // 🔹 Se cliente for local, usa nome original
4672.                 if ($clientes_status === 'local') {
4673.             
4674.             
4675.                     $filename = $safeName . '.pdf';
4676.             
4677.                 } else {
4678.                     // padrão: UUID
4679.                     $filename = $uuid . '.pdf';
4680.                 }
4681.             
4682.                 $tempDir = __DIR__ . '/../../var/uploads/messenger';
4683.                 if (!is_dir($tempDir)) {
4684.                     mkdir($tempDir, 0777, true);
4685.                 }
4686.             
4687.                 $tempFilePath = $tempDir . '/' . $filename;
4688.             
4689.                 move_uploaded_file($file, $tempFilePath);
4690.                 #chmod($tempFilePath, 0644);
4691.                 if (!file_exists($tempFilePath) || filesize($tempFilePath) === 0) {
4692.                     throw new \RuntimeException(
4693.                         'Falha ao gravar PDF temporário: ' . $tempFilePath
4694.                     );
4695.                 }
4696.                 
4697.                 // evita race condition de filesystem
4698.                 clearstatcache(true, $tempFilePath);
4699.             
4700.                 $bus->dispatch(new UploadMultipartMessage(
4701.                     $tempFilePath,
4702.                     $filename,
4703.                     $caminho,
4704.                     '',
4705.                     $caixaId,
4706.                     $clienteId,
4707.                     $userId,
4708.                     0,
4709.                     $conteiner,
4710.                     $clientes,
4711.                     $clientes_status,
4712.                     $safeName,
4713.                     $originalName,
4714.                     $cliente_alls 
4715.                 ));
4716.             }
4719.            
4720.             $log = new Registro();
4721.             $log->setOperacao('EXPORTOU '.$cont_file.' DOCUMENTO(S)'); 
4722.             $log->setUser($user_nome_name);
4723.             $log->setCliente($cliente_nome);
4724.             $entityManager->persist($log);
4725.             $entityManager->flush();
4726.             
4727.             return $this->redirectToRoute('digitalizacao', ['id' => $id]);
4728.             
4729.         
4730.         }
4732.         if(isset($_POST["caixa_total"])){
4734.             $caixa_total = $_POST["caixa_total"];
4735.             $documento_total =$_POST["documento_total"];
4736.             $qtd_total =$_POST["qtd_total"];
4739.                 $registro = new Registro();
4740.                 $registro->setOperacao('DIGITALIZAÇÃO:  '.$caixa_total. ' CAIXA(S) / '.$documento_total.' DOCUMENTO(S) / '.$qtd_total.' IMAGEN(S)'); 
4741.                 $registro->setUser('CONCLUIDO PELA EQUIPE');
4742.                 $registro->setCliente($cliente_nome);
4743.                 $registro->setIp($ip_cliente);
4744.                 $entityManager->persist($registro);
4745.                 $entityManager->flush();
4747.                 $etapa->setRegistro($registro);
4748.                 $etapa->setUpdatedAt($hoje);
4749.                 $entityManager->flush();
4750.                 $erro = 'ok';
4751.                 $p = "Etapa concluída com sucesso";
4752.         }
4754.        
4755.         return $this->render('index/digitalizacao.html.twig', [
4756.             'id'=>$id,
4757.             'p'=>$p,
4758.             'erro'=>$erro,
4759.             'pagina' => $pagina,
4760.             'caixas' => $caixas,
4761.             'user_logado' => $user_logado,
4762.             'cliente' => $cliente,
4763.             'cliente_session' => $cliente_session,
4764.             'form' => $form->createView(),
4765.             'dia_prod' => $dia_prod,
4766.             'fluxo' => $fluxo
4767.         ]);
4768.     }
4770.     #[Route('/index/indexacao/{id}', name: 'indexacao')]
4771.     public function indexacao(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager , SessionInterface $session,$id): Response
4772.     {   
4773.         
4774.         $clientS3 = new  S3Client([
4775.                     'region'  => 'sa-east-1',
4776.                     'version' => 'latest',
4777.                     'credentials' => [ 
4778.                         'key'    => $_ENV['AWS_KEY'],
4779.                         'secret' => $_ENV['AWS_SECRET'],
4780.                     ],
4781.                 ]);
4782.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
4783.         $etapa = $doctrine->getRepository(Etapa::class)->findWithAllRelations($id);
4784.         $fluxo = $doctrine->getRepository(Fluxo::class)->findWithAllRelations($etapa->getFluxo()->getId());
4785.         $cliente_nome = $fluxo->getCliente()->getNome();
4786.         $cliente_etapa = $fluxo->getCliente();
4787.         $fluxo_caixas = $doctrine->getRepository(Caixa::class)->findByFluxoWithRelations($fluxo->getId());
4788.         $caixaIds = array_map(fn($caixa) => $caixa->getId(), $fluxo_caixas);
4789.         $documentoRepository = $entityManager->getRepository(Documento::class);
4791.         $pagina = 1;
4792.         $limite = 100;
4794.         $offset = ($pagina - 1) * $limite;
4796.         $total = $documentoRepository->createQueryBuilder('d')
4797.             ->select('COUNT(d.id)')
4798.             ->where('IDENTITY(d.caixa) IN (:caixas)')
4799.             ->andWhere('d.tipo IS NULL')
4800.             ->setParameter('caixas', $fluxo_caixas)
4801.             ->getQuery()
4802.             ->getSingleScalarResult();
4804.         $documentos = $documentoRepository->createQueryBuilder('d')
4805.             ->where('IDENTITY(d.caixa) IN (:caixas)')
4806.             ->andWhere('d.tipo IS NULL')
4807.             ->setParameter('caixas', $caixaIds)
4808.             ->orderBy('d.createdAt', 'ASC')
4809.             ->setFirstResult($offset)
4810.             ->setMaxResults($limite)
4811.             ->getQuery()
4812.             ->getResult();
4813.         
4814.         
4815.             // Executa a query
4816.         $caixas = $fluxo_caixas;
4817.         $user_logado = $this->getUser();
4818.         $form = $this->createForm(UploadType::class);
4819.         $form->handleRequest($request);
4820.         $user_logado_tipoAcesso = $user_logado->getTipoAcesso();
4821.         $user_logado_nome = $user_logado->getNome();
4822.         $user_logado_id = $user_logado->getId();
4823.         $cliente =  $doctrine->getRepository(User::class)->findClientsByUserId($user_logado_id);
4824.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
4825.         $hoje_formt=$hoje->format('Y-m-d');
4826.         $doc = $entityManager->getRepository(Documento::class)->findByUserIndexAndDate($user_logado_nome, $hoje_formt);
4827.         $dia_prod = 'de hoje';
4828.         $permissao = [];
4829.         $list_indexador = [];
4830.         $index_all =  $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $cliente_etapa]);
4831.         $class =  $doctrine->getRepository(Classificacao::class)->findBy(['cliente' => $cliente_etapa]);
4832.         $cliente_ids =$cliente_etapa ;
4833.         
4834.        
4835.             
4836.         $cliente_nome= $cliente_ids->getNome();
4837.         $clientes= $cliente_ids->getId();
4838.         $umlautString =$cliente_nome;
4839.         $slugger = new AsciiSlugger();
4840.         $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
4841.         $caminho = strtolower ($teste.'/');
4842.                         
4843.         if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
4844.         if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
4845.         if($clientes == 35){$caminho='pmecj-sp-saude/';}
4846.         if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
4847.         if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
4848.         if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
4849.         if($clientes ==  15){$caminho='cbsi-dossies/';}
4850.         if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
4851.         if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
4852.         if($clientes ==  127){$caminho='pmecj-s-a.A) - ALMOXARIFADO E PATRIMÔNIO/';}
4853.       
4855.           
4856.         if(isset($_POST["btn_cliente"])){
4857.             
4858.             $session->set('cliente_id', $_POST["btn_cliente"]);
4859.             return $this->redirectToRoute('home');
4860.         }
4863.         $clienteId = $session->get('cliente_id');
4864.         
4865.         
4866.         if ($clienteId == null ) {
4867.             
4868.             $caixas =  "";
4869.             $cliente_session = "";
4870.             return $this->redirectToRoute('home');
4871.        
4872.         }
4873.            
4874.         $erro = '';
4875.         $ii=0;
4876.         $pagina = 'index';
4877.         $p = '';
4878.         $link = '';
4879.         $mx = 0;
4880.         $xy = 0 ; 
4881.         $yz = 0 ; 
4882.         $ay = 0 ;
4883.         $ky = 0 ;
4884.         $pdf ='';
4885.         $pagina_h4 ='Documento(s) para indexar';
4886.         $nome_menu_ = '';
4887.         $index_tipo='';
4888.         $uuid = Uuid::v4();
4889.         $user = $this->getUser();
4890.         $user_nome= $user->getEmail();
4891.         $user_nome_name= $user->getNome();
4892.         $pasta_user=$user_nome.'/';
4893.         $arr = [];
4894.         $arrr=0;
4895.         $index_find = null;
4896.         $dt = '';
4897.         
4898.         
4899.      
4900.             
4901.        
4902.         if(isset($_POST["botao_index"])){
4903.             
4904.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
4905.             $link = $pdf->getImage();
4906.             $xy = 1 ;
4907.             
4908.         }
4909.         if(isset($_POST["botao_doc"])){
4910.             
4911.             
4912.             $yz = 0 ;
4913.             $xy = 1 ;
4914.             $ay = 1 ;
4915.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
4916.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
4917.            
4918.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
4919.             $index_tipo_tipo =  $index_tipo->getNome();
4920.             $link = $pdf->getImage();
4921.             $fase=$_POST["fase"];
4922.             $data = $_POST["data"];
4923.             $cx = $_POST["caixas"];
4924.             $classifica = $_POST["classifica"];
4925.             $desc = $_POST["desc"];
4926.             $assunto = $_POST["assunto"];
4927.             $chave = $_POST["chave"];
4928.             $nome = $_POST["nome"];
4929.             $conteiner = $_POST["conteiner"];
4931.             
4932.             
4933.             $caixa_id = $doctrine->getRepository(Caixa::class)->find($cx);
4934.             
4935.             
4936.             
4937.             
4939.             // Exibe os números encontrados
4940.             
4941.             if ($clientes != 7) {
4942.                 preg_match_all('/\d+/', $fase, $matches);
4943.                 $numeros = array_map('intval', $matches[0]);
4944.                 if ($data != "") {
4945.                     if ($numeros != [] ) {
4946.                         if ($fase != "") {
4947.         
4948.                             // Número inteiro que você deseja somar ao ano
4949.                             $numeroParaSomar = $numeros[0];
4950.         
4951.                             // Extrair o ano da data
4952.                             list($ano, $mes, $dia) = explode('-', $data);
4953.         
4954.                             // Converter o ano para um número inteiro
4955.                             $ano = intval($ano);
4956.         
4957.                             // Somar o número ao ano
4958.                             $data_vecimento =  $ano + $numeroParaSomar.'-'.$mes.'-'. $dia;
4959.         
4960.                             $pdf->setVencimentoDocumento(new \DateTimeImmutable($data_vecimento));
4961.         
4962.                         }
4963.                 }
4964.                 $pdf->setDataDocumento(new \DateTimeImmutable($data));
4965.                 }
4966.             }    
4967.             
4968.             if ($clientes == 7) {
4969.                   $pdf->setVencimentoDocumento(new \DateTimeImmutable($fase));
4970.                   $pdf->setDataDocumento(new \DateTimeImmutable($data));
4971.              }
4972.             
4973.             
4974.             $pdf->setAssunto($assunto);
4976.             if ($classifica != "") {
4978.                 $classifica_id = $doctrine->getRepository(Classificacao::class)->find($classifica);
4979.                 $pdf->setClassificacao($classifica_id);
4980.             }
4982.             $pdf->setCaixa($caixa_id);
4983.             $pdf->setExtraFields($desc);
4984.             $pdf->setNome($nome);
4985.             $pdf->setKeywords($chave);
4986.             $pdf->setUserIndex($user_nome_name);
4987.             $pdf->setConteiner($conteiner);
4988.             $pdf->setIndexAt(new \DateTimeImmutable('America/Sao_Paulo'));
4989.             $pdf->setTipo($index_tipo);
4990.             $entityManager->flush();
4991.             $id_pd = $pdf->getId();    
4992.             $log = new Registro();
4993.             $log->setOperacao('Indexou o Documento com id '.$id_pd); 
4994.             $log->setUser($user_nome_name);
4995.             $log->setCliente($cliente_nome);
4996.             $entityManager->persist($log);
4997.             $entityManager->flush();
4998.             $erro = 'ok';
4999.             $p =  $index_tipo_tipo.' indexado com sucesso';
5000.             
5003.            
5004.             
5005.            
5006.         }   
5007.         if(isset($_POST["botao_index_edit"])){
5008.             
5009.             $yz = 0 ;
5010.             $xy = 1 ;
5011.             $ay = 1 ;
5012.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
5013.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
5014.             $link = $pdf->getImage();
5015.         }
5016.         if(isset($_POST["botao_volta"])){
5018.             $xy = 0 ;
5019.             $yz = 0 ;
5020.         }
5021.         if(isset($_POST["index_button"])){
5022.             
5023.             
5024.             $yz = 0 ;
5025.             $xy = 1 ;
5026.             $ay = 1 ;
5027.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
5028.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["index_button"]);
5029.             $link = $pdf->getImage();
5030.         }
5031.         if(isset($_POST["botao_cancel"])){
5032.             $yz = 0 ;
5033.             $xy = 1 ;
5034.             $ay = 0 ;
5035.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
5036.             $link = $pdf->getImage();
5037.             
5038.         }
5039.         if(isset($_POST["delet"])){
5040.            
5041.             $ky = 1 ;
5042.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["delet"]);
5043.             $documentos = $doctrine->getRepository(Documento::class)->findBy(['id' => $_POST["delet"]]);
5044.             
5045.             if($pdf->getTipo()!= null){
5046.                 $index_find =  $doctrine->getRepository(Tipo::class)->find($pdf->getTipo());
5047.                 $pagina =$index_find->getTipo();
5048.                 $pagina_h4 ='Documento(s) do tipo ( '.$index_find->getTipo().' )';
5049.             }
5050.                         
5051.         }
5052.         if(isset($_POST["delet_cancel"])){
5053.             $ky = 0 ;
5054.         }
5055.         if(isset($_POST["delet_sim"])){
5056.             
5057.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
5058.             $id_pd = $pdf->getId();
5059.             $entityManager->remove($pdf);
5060.             $entityManager->flush();
5061.           
5062.             $log = new Registro();
5063.             $log->setOperacao('Excluiu Documento com id '.$id_pd); 
5064.             $log->setUser($user_nome_name);
5065.             $log->setCliente($cliente_nome);
5066.             $entityManager->persist($log);
5067.             $entityManager->flush();
5068.             $erro = 'ok';
5069.             $p = 'Documento com id '.$id_pd.' excluido com sucesso '; 
5070.         }
5071.         if(isset($_POST["index_edit"])){
5072.             $yz = 0 ;
5073.             $xy = 1 ;
5074.             $ay = 2 ;
5075.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
5076.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($_POST["id_index"]);
5077.             $link = $pdf->getImage();
5078.         }
5079.        
5080.         if(isset($_POST["caixa_total"])){
5082.             $caixa_total = $_POST["caixa_total"];
5083.             $documento_total =$_POST["documento_total"];
5084.             $qtd_total =$_POST["qtd_total"];
5087.                 $registro = new Registro();
5088.                 $registro->setOperacao('INDEXADO:  '.$caixa_total. ' CAIXA(S) / '.$documento_total.' DOCUMENTO(S) / '); 
5089.                 $registro->setUser('CONCLUIDO PELA EQUIPE');
5090.                 $registro->setCliente($cliente_nome);
5091.                 $registro->setIp($ip_cliente);
5092.                 $entityManager->persist($registro);
5093.                 $entityManager->flush();
5095.                 $etapa->setRegistro($registro);
5096.                 $etapa->setUpdatedAt($hoje);
5097.                 $entityManager->flush();
5098.                 $erro = 'ok';
5099.                 $p = "Etapa concluída com sucesso";
5100.         }
5101.         
5102.            $cmd = $clientS3->getCommand('GetObject', [
5103.                 'Bucket' => 'arquivosdoc',
5104.                 'Key'    => $caminho. $link, 
5105.             ]);
5106.             
5107.             $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
5108.             $all_Url = (string) $req->getUri();
5109.         
5110.         return $this->render('index/indexacao.html.twig', [
5111.             'documentos' => $documentos,
5112.             'xy' => $xy,
5113.             'yz' => $yz,
5114.             'ay'=>$ay,
5115.             'link' => $link,
5116.             'pdf'=>$pdf,
5117.             'p'=>$p,
5118.             'erro'=>$erro,
5119.             'index_all'=>$index_all,
5120.             'index_tipo'=>$index_tipo,
5121.             'ky'=>$ky,
5122.             'pagina' => $pagina,
5123.             'pagina_h4' =>$pagina_h4,
5124.             'index_find'=>$index_find,
5125.             'mx'=>$mx,
5126.             'class'=>$class,
5127.             'caixas' => $caixas,
5128.             'permissao'=>$permissao,
5129.             'doc'=>$doc,
5130.             'dia_prod' => $dia_prod,
5131.             'fluxo' => $fluxo,
5132.             'id' => $id,
5133.             'caminho' =>$caminho,
5134.             'clientes'=>$clientes,
5135.             'all_Url'=>$all_Url,
5136.             'total'=>$total
5138.         ]);
5141.     }
5142.     
5143.    
5144.     
5145.     #[Route('/fila/count', name: 'fila_count', methods: ['GET'])]
5146.     public function count(EntityManagerInterface $entityManager): JsonResponse
5147.     {
5148.         $userLogado = $this->getUser();
5149.         $userLogadoId = $userLogado->getId();
5150.     
5151.         $repository = $entityManager->getRepository(MessengerMessages::class);
5152.     
5153.         $count = $repository->countPendingMessagesByUser($userLogadoId);
5154.     
5155.         $messages = $repository->createQueryBuilder('m')
5156.             ->where('m.delivered_at IS NULL')
5157.             ->orderBy('m.id', 'ASC')
5158.             ->getQuery()
5159.             ->getResult();
5160.     
5161.         $fila = [];
5162.         $usuariosJaProcessados = [];
5163.         $posicaoUsuario = null;
5164.     
5165.         foreach ($messages as $index => $message) {
5166.     
5167.             $body = $message->getBody();
5168.     
5169.             preg_match('/;i:(\d+);s:8:/', $body, $matches);
5170.     
5171.             $userIdFila = $matches[1] ?? null;
5172.     
5173.             if (!$userIdFila) {
5174.                 continue;
5175.             }
5176.     
5177.             // 🔥 evita duplicar usuário na fila
5178.             if (isset($usuariosJaProcessados[$userIdFila])) {
5179.                 continue;
5180.             }
5181.     
5182.             $usuariosJaProcessados[$userIdFila] = true;
5183.     
5184.             $usuario = $entityManager
5185.                 ->getRepository(User::class)
5186.                 ->find($userIdFila);
5187.     
5188.             $posicao = count($fila) + 1;
5189.     
5190.             $item = [
5191.                 'posicao' => $posicao,
5192.                 'user_id' => $userIdFila,
5193.                 'nome' => $usuario?->getNome(),
5194.             ];
5195.     
5196.             $fila[] = $item;
5197.     
5198.             if ((int)$userIdFila === (int)$userLogadoId) {
5199.                 $posicaoUsuario = $posicao;
5200.             }
5201.         }
5202.     
5203.         // calcula quantos faltam para o usuário logado
5204.         $faltam = $posicaoUsuario ? ($posicaoUsuario - 1) : null;
5205.     
5206.         return new JsonResponse([
5207.             'count' => $count,
5208.             'minha_posicao' => $posicaoUsuario,
5209.             'faltam' => $faltam,
5210.             'fila' => $fila,
5211.         ]);
5212.     }
5213.     
5214.     #[Route('/index/qualidade', name: 'qualidade')]
5215.     public function qualidade(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager , SessionInterface $session,DriveToOneDriveService $service): Response
5216.     {   
5217.         $clienteId = $session->get('cliente_id');
5218.         $ip_cliente = $_SERVER['REMOTE_ADDR'];
5219.         $caixaIds = "LEONARDO DE SOUZA CRUZEIRO";
5220.         $documentoRepository = $entityManager->getRepository(Documento::class);
5221.         $query = $documentoRepository->createQueryBuilder('d')
5222.         ->where('d.user_index = :caixaIds')
5223.         ->andWhere('d.cliente = :clienteId')
5224.         ->andWhere('(d.situacao = :situacao OR d.situacao IS NULL)')
5225.         ->andWhere('d.tipo IS NOT NULL')
5226.         ->setParameter('situacao', '')
5227.         ->setParameter('caixaIds', $caixaIds)
5228.         ->setParameter('clienteId', $clienteId)
5229.         ->orderBy('d.indexAt', 'ASC')
5230.         ->setMaxResults(100)
5231.         ->getQuery();
5232.         
5233.         
5234.         $total = $documentoRepository->createQueryBuilder('d')
5235.         ->select('COUNT(d.id)')
5236.         ->where('d.user_index = :caixaIds')
5237.         ->andWhere('d.cliente = :clienteId')
5238.         ->andWhere('(d.situacao = :situacao OR d.situacao IS NULL)')
5239.         ->setParameter('situacao', '')
5240.         ->setParameter('caixaIds', $caixaIds)
5241.         ->setParameter('clienteId', $clienteId)
5242.         ->getQuery()
5243.         ->getSingleScalarResult();
5244.        
5246.         // Executa a query
5247.         $documentos = $query->getResult();
5248.         #dd($documentos);
5249.         $dotenv = new Dotenv();
5250.         $dotenv->load(__DIR__.'/.env');
5251.         $user_logado = $this->getUser();
5252.         $form = $this->createForm(UploadType::class);
5253.         $form->handleRequest($request);
5254.         $user_logado_tipoAcesso = $user_logado->getTipoAcesso();
5255.         $user_nome_name = $user_logado->getNome();
5256.         $user_logado_id = $user_logado->getId();
5257.         $hoje = new \DateTimeImmutable('America/Sao_Paulo');
5258.         $hoje_formt=$hoje->format('Y-m-d');
5259.         $dia_prod = 'de hoje';
5260.         $permissao = [];
5261.         $list_indexador = [];
5262.         $slugger = new AsciiSlugger();
5263.         $erro = '';
5264.         $ii=0;
5265.         $pagina = 'qualidade';
5266.         $p = '';
5267.         $link = '';
5268.         $xy = 0 ; 
5269.         $pdf ='';
5270.         $umlautString = '';
5271.         $clientes = 0;
5272.         $caminho ='';
5273.         $class ="";
5274.         $all_Url="";
5275.         
5276.         $clientS3 = new  S3Client([
5277.                 'region'  => 'sa-east-1',
5278.                 'version' => 'latest',
5279.                 'credentials' => [ 
5280.                     'key'    => $_ENV['AWS_KEY'],
5281.                     'secret' => $_ENV['AWS_SECRET'],
5282.                 ],
5283.             ]);
5284.        
5286.         if(isset($_POST["botao_index"])){
5287.             
5288.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id"]);
5289.             $clientes = $pdf->getCliente()->getId();
5290.             $clienteRepository = $entityManager->getRepository(Cliente::class);
5291.             $class =  $doctrine->getRepository(Classificacao::class)->findBy(['cliente' => $clientes]);
5292.             $query = $clienteRepository->createQueryBuilder('c')
5293.                 ->where('c.id = :caixaIds')
5294.                 ->setParameter('caixaIds', $clientes)
5295.                 ->getQuery();
5296.             $cl = $query->getSingleResult();
5297.             $link = $pdf->getImage();
5298.             $xy = 1 ;
5299.             $umlautString = $cl->getNome();
5300.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
5301.             $caminho = strtolower ($teste.'/');
5302.                     
5303.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
5304.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
5305.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
5306.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
5307.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
5308.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
5309.             if($clientes ==  15){$caminho='cbsi-dossies/';}
5310.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
5311.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
5312.             if($clientes ==  127){$caminho='pmecj-s-a.A) - ALMOXARIFADO E PATRIMÔNIO/';}
5313.             
5314.             $cmd = $clientS3->getCommand('GetObject', [
5315.                 'Bucket' => 'arquivosdoc',
5316.                 'Key'    => $caminho. $link, 
5317.                 ]);
5318.                 
5319.             $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
5320.             $all_Url = (string) $req->getUri();
5322.                 
5323.         }
5324.         if(isset($_POST["botao_doc"])){
5325.             
5326.             $yz = 0 ;
5327.             $xy = 1 ;
5328.             $ay = 1 ;
5329.             
5330.             $pdf =  $doctrine->getRepository(Documento::class)->find($_POST["id_pdf"]);
5331.             
5332.             // 1. Capturar valores originais da IA antes da edição do humano
5333.             $originalAssunto = $pdf->getAssunto();
5334.             $originalDescricao = $pdf->getExtraFields();
5335.             $originalNome = $pdf->getNome();
5336.             $originalKeywords = $pdf->getKeywords();
5337.             $originalConteiner = $pdf->getConteiner();
5338.             $originalDataDoc = $pdf->getDataDocumento() ? $pdf->getDataDocumento()->format('Y-m-d') : null;
5339.             $originalDataVenc = $pdf->getVencimentoDocumento() ? $pdf->getVencimentoDocumento()->format('Y-m-d') : null;
5340.             $originalClassId = $pdf->getClassificacao() ? $pdf->getClassificacao()->getId() : null;
5341.             
5342.             $index_tipo =  $doctrine->getRepository(Tipo::class)->find($pdf->getTipo());
5343.             $index_tipo_tipo =  $index_tipo->getNome();
5344.             $link = $pdf->getImage();
5345.             $data = $_POST["data"];
5346.             $desc = $_POST["desc"];
5347.             $assunto = $_POST["assunto"];
5348.             $chave = $_POST["chave"];
5349.             $nome = $_POST["nome"];
5350.             $conteiner = $_POST["conteiner"];
5351.             $classifica = $_POST["classifica"];
5352.             $fase = $_POST["fase"];
5353.             
5354.             preg_match_all('/\d+/', $fase, $matches);
5355.             $numeros = array_map('intval', $matches[0]);
5357.             $novaDataVencVal = null;
5358.             if ($clientes != 7) {
5359.                 if ($data != "") {
5360.                     if ($fase != "") {
5361.                         $numeroParaSomar = $numeros[0];
5362.                         list($ano, $mes, $dia) = explode('-', $data);
5363.                         $ano = intval($ano);
5364.                         $data_vecimento =  $ano + $numeroParaSomar.'-'.$mes.'-'. $dia;
5365.                         $novaDataVencVal = $data_vecimento;
5366.                         $pdf->setVencimentoDocumento(new \DateTimeImmutable($data_vecimento));
5367.                     }
5368.                 $pdf->setDataDocumento(new \DateTimeImmutable($data));
5369.                 }
5370.             }  
5372.             $classificaObj = null;
5373.             if ($classifica != "") {
5374.                 $classifica_id = $doctrine->getRepository(Classificacao::class)->find($classifica);
5375.                 $classificaObj = $classifica_id;
5376.                 $pdf->setClassificacao($classifica_id);
5377.             }
5378.             
5379.             $clienteExtraFields = $entityManager->createQueryBuilder()
5380.                 ->select('c.extraFields')
5381.                 ->from(Cliente::class, 'c')
5382.                 ->where('c.id = :id')
5383.                 ->setParameter('id', $clienteId)
5384.                 ->getQuery()
5385.                 ->getSingleScalarResult();
5386.             
5387.             if ($clienteExtraFields == "local") {
5388.                 $pdf->setRenomear(1);
5389.             }
5390.             
5391.             $pdf->setAssunto($assunto);
5392.             $pdf->setExtraFields($desc);
5393.             $pdf->setNome($nome);
5394.             $pdf->setKeywords($chave);
5395.             $pdf->setUserIndex($user_nome_name);
5396.             $pdf->setConteiner($conteiner);
5398.             // 2. Cálculo da assertividade usando similaridade de strings e verificação de campos
5399.             $calcularSimilaridade = function(?string $original, ?string $novo): float {
5400.                 $original = trim($original ?? '');
5401.                 $novo = trim($novo ?? '');
5403.                 if ($original === '' && $novo === '') {
5404.                     return 100.0;
5405.                 }
5406.                 
5407.                 if ($original === '' || $novo === '') {
5408.                     return 0.0;
5409.                 }
5411.                 similar_text($original, $novo, $percentual);
5412.                 return $percentual; 
5413.             };
5415.             $scoreAssunto = $calcularSimilaridade($originalAssunto, $assunto);
5416.             $scoreDescricao = $calcularSimilaridade($originalDescricao, $desc);
5417.             $scoreNome = $calcularSimilaridade($originalNome, $nome);
5418.             $scoreKeywords = $calcularSimilaridade($originalKeywords, $chave);
5419.             $scoreConteiner = $calcularSimilaridade($originalConteiner, $conteiner);
5421.             $novaDataDocVal = ($data != "") ? (new \DateTimeImmutable($data))->format('Y-m-d') : null;
5422.             $scoreDataDoc = ($originalDataDoc === $novaDataDocVal) ? 100.0 : 0.0;
5424.             $novaDataVencFormatted = $novaDataVencVal ? (new \DateTimeImmutable($novaDataVencVal))->format('Y-m-d') : null;
5425.             $scoreDataVenc = ($originalDataVenc === $novaDataVencFormatted) ? 100.0 : 0.0;
5427.             $novaClassIdVal = $classificaObj ? $classificaObj->getId() : null;
5428.             $scoreClass = ($originalClassId === $novaClassIdVal) ? 100.0 : 0.0;
5430.             $totalCampos = 8;
5431.             $porcentagemAssertividade = (
5432.                 $scoreAssunto + 
5433.                 $scoreDescricao + 
5434.                 $scoreNome + 
5435.                 $scoreKeywords + 
5436.                 $scoreConteiner + 
5437.                 $scoreDataDoc + 
5438.                 $scoreDataVenc + 
5439.                 $scoreClass
5440.             ) / $totalCampos;
5442.             // Salva a porcentagem na entidade
5443.             $pdf->setAssertividadeIa($porcentagemAssertividade);
5445.             $pdf->setIndexAt(new \DateTimeImmutable('America/Sao_Paulo'));
5446.             $pdf->setSituacao('OK');
5447.             $entityManager->flush();
5448.             $id_pd = $pdf->getId();    
5449.             $log = new Registro();
5450.             $log->setOperacao('Conferiu o Documento com id '.$id_pd); 
5451.             $log->setUser($user_nome_name);
5452.             $log->setCliente($umlautString);
5453.             $entityManager->persist($log);
5454.             $entityManager->flush();
5455.             $erro = 'ok';
5456.             $p =  $index_tipo_tipo.' FOI CONFERIDO COM SUCESSO';
5457.            
5458.         }   
5459.         if(isset($_POST["botao_volta"])){
5461.             $xy = 0 ;
5462.             $yz = 0 ;
5463.         }
5464.         
5465.         
5467.         
5468.         return $this->render('index/qualidade.html.twig', [
5469.             'documentos' => $documentos,
5470.             'xy' => $xy,
5471.             'link' => $link,
5472.             'pdf'=>$pdf,
5473.             'p'=>$p,
5474.             'erro'=>$erro,
5475.             'pagina' => $pagina,
5476.             'caminho' =>$caminho,
5477.             'class' => $class,
5478.             'all_Url'=>$all_Url,
5479.             'total'=>$total
5482.         ]);
5485.     }
5486.     
5487.      #[Route('/metas', name: 'metas')]
5488.     public function metas( PaginatorInterface $paginator,Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager, SessionInterface $session, MailerInterface $mailer): Response
5489.     {
5490.         
5491.         $fluxos_abertos = $entityManager
5492.             ->getRepository(Fluxo::class)
5493.             ->fluxosAbertosComMaiorPrazo();
5494.             
5495.          $fluxos_mes = $entityManager
5496.         ->getRepository(Fluxo::class)
5497.         ->findMes();
5499.         $totalFluxos     = 0;
5500.         $clientesUnicos  = [];
5501.         $totalCaixas     = 0;
5502.         $totalDocumentos = 0;
5503.         $totalImagens    = 0;
5504.         
5505.         $avisosPath = $this->getParameter('kernel.project_dir') . '/public/avisos';
5507.         $avisos = [];
5508.         
5509.         if (is_dir($avisosPath)) {
5510.         
5511.             $arquivos = scandir($avisosPath);
5512.         
5513.             foreach ($arquivos as $arquivo) {
5514.         
5515.                 $ext = strtolower(pathinfo($arquivo, PATHINFO_EXTENSION));
5516.         
5517.                 if (in_array($ext, ['png', 'jpg', 'jpeg', 'webp'])) {
5518.         
5519.                     $avisos[] = '/avisos/' . $arquivo;
5520.                 }
5521.             }
5522.         }
5523.         
5524.         shuffle($avisos);
5525.         
5526.         
5529.         foreach ($fluxos_mes as $fluxo) {
5531.             $totalFluxos++;
5533.             // 👇 garante cliente único
5534.             if ($fluxo->getCliente()) {
5535.                 $clienteId = $fluxo->getCliente()->getId();
5536.                 $clientesUnicos[$clienteId] = true;
5537.             }
5539.             foreach ($fluxo->getCaixas() as $caixa) {
5540.                 $totalCaixas++;
5542.                 foreach ($caixa->getDocumentos() as $documento) {
5543.                     $totalDocumentos++;
5544.                     $totalImagens += $documento->getQtd();
5545.                 }
5546.             }
5547.         }
5548.         $formatter = new \IntlDateFormatter(
5549.             'pt_BR',
5550.             \IntlDateFormatter::NONE,
5551.             \IntlDateFormatter::NONE,
5552.             'America/Sao_Paulo',
5553.             \IntlDateFormatter::GREGORIAN,
5554.             'MMMM'
5555.         );
5557.         $nomeMes = ucfirst($formatter->format(new \DateTime()));
5559.         $resumo = [
5560.             'fluxos'     => $totalFluxos,
5561.             'clientes'   => count($clientesUnicos), // ✅ não duplica
5562.             'caixas'     => $totalCaixas,
5563.             'documentos' => $totalDocumentos,
5564.             'imagens'    => $totalImagens,
5565.             'nomeMes'     => $nomeMes
5566.         ];
5568.         
5569.         $a = [];
5571.         foreach ($fluxos_abertos as $item) {
5573.             $fluxo = $item[0];
5574.             $maiorData = $item['prazo'];
5576.             $cx = 0;
5577.             $doc = 0;
5578.             $img = 0;
5579.             $cliente_id = $fluxo->getCliente()->getId();
5580.             $cliente = $doctrine->getRepository(Cliente::class)
5581.             ->createQueryBuilder('c')
5582.             ->where('c.id = :id')
5583.             ->setParameter('id', $cliente_id)
5584.             ->getQuery()
5585.             ->getOneOrNullResult();
5587.             foreach ($fluxo->getCaixas() as $caixas) {
5588.                 $cx++;
5589.                 foreach ($caixas->getDocumentos() as $docs) {
5590.                     $doc++;
5591.                     $img += $docs->getQtd();
5592.                 }
5593.             }
5595.             $a[] = [
5596.                 'fluxo'       => $fluxo->getId(),
5597.                 'cliente'     => $cliente->getNome(),
5598.                 'caixas'      => $cx,
5599.                 'documentos'  => $doc,
5600.                 'imagens'     => $img,
5601.                 'prazo'       => $maiorData,
5602.             ];
5603.         }
5604.                 
5606.         return $this->render('index/metas_fluxos.html.twig', [
5607.             'data'=>$a,
5608.             'resumo'=>$resumo,
5609.             'avisos' => $avisos
5610.     
5612.         ]);
5613.     }
5614.     
5615.         #[Route('/kpis-dashboard', name: 'kpis-dashboard')]
5616.     public function kpis_dashboard(): Response
5617.     {
5618.         return $this->render('index/kpis-dashboard.html.twig');
5619.     }
5620.     
5621.     #[Route('/kpis-dashboard-ia', name: 'kpis-dashboard-ia')]
5622.     public function kpis_dashboard_ia(): Response
5623.     {
5624.         return $this->render('index/documentos_ia.html.twig');
5625.     }
5627.     #[Route('/kpis', name: 'kpis')]
5628.     public function kpis(): Response
5629.     {
5630.         return $this->render('index/kpis.html.twig');
5631.     }
5632.     
5634.     // ==========================================
5635.     // 1. API CAIXA
5636.     // ==========================================
5637.     #[Route('/api/kpis/caixas', name: 'api_kpis_caixas', methods: ['POST'])]
5638.     public function kpis_caixas(Request $request, EntityManagerInterface $entityManager): Response
5639.     {
5640.             $conn = $entityManager->getConnection();
5641.             $de = $request->request->get('de');
5642.             $ate = $request->request->get('ate');
5643.         
5644.             if (!empty($de)) {
5645.                 if (!empty($ate)) {
5646.                     $ateComHora = $ate . " 23:59:59";
5647.                 } else {
5648.                     $ateComHora = null;
5649.                 }
5650.         
5651.                 $queryStrCx = 'SELECT COUNT(d.id) AS total_cx FROM App\Entity\Cx d WHERE d.createdAt >= :de AND d.caminho IS NOT NULL';
5652.                 if ($ateComHora) { 
5653.                     $queryStrCx .= ' AND d.createdAt <= :ate'; 
5654.                 } else {
5655.                     $queryStrCx .= ' AND DATE(d.createdAt) = DATE(:de)';
5656.                 }
5657.                 $queryCx = $entityManager->createQuery($queryStrCx)->setParameter('de', $de);
5658.                 if ($ateComHora) { $queryCx->setParameter('ate', $ateComHora); }
5659.                 $cx = $queryCx->getSingleScalarResult() ?? 0;
5660.         
5661.                 $queryStrClientes = "
5662.                     SELECT 
5663.                         c.nome AS cliente_nome,
5664.                         (SELECT COUNT(cx.id) 
5665.                         FROM App\Entity\Cx cx 
5666.                         WHERE cx.status != 0 
5667.                         AND cx.caminho != '' 
5668.                         AND cx.cliente = c
5669.                         AND cx.createdAt >= :de " . ($ateComHora ? "AND cx.createdAt <= :ate" : "AND DATE(cx.createdAt) = DATE(:de)") . ") AS total_caixas
5670.                     FROM App\Entity\ClienteAll c
5671.                     ORDER BY c.nome ASC
5672.                 ";
5673.                 $queryClientes = $entityManager->createQuery($queryStrClientes)->setParameter('de', $de);
5674.                 if ($ateComHora) { $queryClientes->setParameter('ate', $ateComHora); }
5675.                 $fed_cliente = $queryClientes->getResult();
5676.         
5677.                 $fed_cliente[] = [
5678.                     'cliente_nome' => 'TRIBUNAL DE JUSTICA DO ESTADO DO RIO DE JANEIRO',
5679.                     'total_caixas' => 0
5680.                 ];
5681.             } else {
5682.                 $sqlClientes = "
5683.                     SELECT 
5684.                         c.nome AS cliente_nome,
5685.                         (SELECT COUNT(cx.id) FROM cx cx WHERE cx.caminho IS NOT NULL AND cx.cliente_id = c.id) AS total_caixas
5686.                     FROM cliente_all c ORDER BY c.nome ASC
5687.                 ";
5688.                 $fed_cliente = $conn->executeQuery($sqlClientes)->fetchAllAssociative();
5689.         
5690.                 $fed_cliente[] = [
5691.                     'cliente_nome' => 'TRIBUNAL DE JUSTICA DO ESTADO DO RIO DE JANEIRO',
5692.                     'total_caixas' => 0
5693.                 ];
5694.         
5695.                 $cx = (int) $conn->fetchOne("SELECT COUNT(d.id) FROM cx d WHERE d.status != 0 AND d.caminho != ''");
5696.             }
5697.             array_walk_recursive($fed_cliente, function (&$item) {
5698.         
5699.                 if (is_string($item) && !preg_match('//u', $item)) {
5700.         
5701.                     $item = utf8_encode($item);
5702.                 }
5703.             });
5704.             return $this->json([
5705.                 'error' => '', 'motivo' => '', 'pagina' => 'kpis', 'h4' => 'TOTAL',
5706.                 'de' => $de ?? '', 'ate' => $ate ?? '',
5707.                 'cx' => $cx,
5708.                 'fed_cliente' => $fed_cliente
5709.             ]);
5710.     }
5712.     // ==========================================
5713.     // 2. API DOCUMENTO
5714.     // ==========================================
5715.     #[Route('/api/kpis/documentos', name: 'api_kpis_documentos', methods: ['POST'])]
5716.     public function kpis_documentos(Request $request, EntityManagerInterface $entityManager): Response
5717.     {
5718.         $conn = $entityManager->getConnection();
5719.         $de = $request->request->get('de');
5720.         $ate = $request->request->get('ate');
5722.         if (!empty($de)) {
5723.             if (!empty($ate)) {
5724.                 $ateComHora = $ate . " 23:59:59";
5725.             } else {
5726.                 $ateComHora = null;
5727.             }
5729.             $queryStrDoc = 'SELECT COUNT(d.id) AS total_documentos FROM App\Entity\Documento d WHERE d.createdAt >= :de';
5730.             if ($ateComHora) { $queryStrDoc .= ' AND d.createdAt <= :ate'; }
5731.             $queryDoc = $entityManager->createQuery($queryStrDoc)->setParameter('de', $de);
5732.             if ($ateComHora) { $queryDoc->setParameter('ate', $ateComHora); }
5733.             $documento = $queryDoc->getSingleScalarResult() ?? 0;
5735.             $queryStrClientes = "
5736.                 SELECT 
5737.                     c.nome AS cliente_nome,
5738.                     (SELECT COUNT(d1.id) 
5739.                     FROM App\Entity\Documento d1 
5740.                     JOIN d1.cliente c1 
5741.                     WHERE c1.clienteAll = c
5742.                     AND d1.createdAt >= :de " . ($ateComHora ? "AND d1.createdAt <= :ate" : "AND DATE(d1.createdAt) = DATE(:de)") . ") AS total_documentos
5743.                 FROM App\Entity\ClienteAll c
5744.                 ORDER BY c.nome ASC
5745.             ";
5746.             $queryClientes = $entityManager->createQuery($queryStrClientes)->setParameter('de', $de);
5747.             if ($ateComHora) { $queryClientes->setParameter('ate', $ateComHora); }
5748.             $fed_cliente = $queryClientes->getResult();
5750.             $dataTjrj = ['total_documentos' => 0];
5751.             $anoFiltro = (int) date('Y', strtotime($de));
5752.             if ($anoFiltro <= 2025) {
5753.                 try {
5754.                     $payload = json_encode(['data_inicio' => $de, 'data_fim' => $ate]);
5755.                     $options = ['http' => ['header' => "Content-Type: application/json\r\n", 'method' => 'POST', 'content' => $payload, 'timeout' => 5]];
5756.                     $context = stream_context_create($options);
5757.                     $response = @file_get_contents('https://produtive.arquivosdoc.com.br/api/tjrj', false, $context);
5758.                     if ($response !== false) { $dataTjrj = json_decode($response, true); }
5759.                 } catch (\Exception $e) {}
5760.             }
5762.             $fed_cliente[] = [
5763.                 'cliente_nome'     => 'TRIBUNAL DE JUSTICA DO ESTADO DO RIO DE JANEIRO',
5764.                 'total_documentos' => $dataTjrj['total_documentos'] ?? 0
5765.             ];
5766.         } else {
5767.             $sqlClientes = "
5768.                 SELECT 
5769.                     c.nome AS cliente_nome,
5770.                     (SELECT COUNT(d.id) FROM documento d JOIN cliente s ON s.id = d.cliente_id WHERE s.cliente_all_id = c.id) AS total_documentos
5771.                 FROM cliente_all c ORDER BY c.nome ASC
5772.             ";
5773.             $fed_cliente = $conn->executeQuery($sqlClientes)->fetchAllAssociative();
5775.             $fed_cliente[] = [
5776.                 'cliente_nome'     => 'TRIBUNAL DE JUSTICA DO ESTADO DO RIO DE JANEIRO',
5777.                 'total_documentos' => 140685
5778.             ];
5780.             $documento = (int) $conn->fetchOne("SELECT COUNT(d.id) FROM documento d") + 140685;
5781.         }
5782.         
5783.         array_walk_recursive($fed_cliente, function (&$item) {
5785.             if (is_string($item) && !preg_match('//u', $item)) {
5787.                 $item = utf8_encode($item);
5788.             }
5789.         });
5790.         return $this->json([
5791.             'error' => '', 'motivo' => '', 'pagina' => 'kpis', 'h4' => 'TOTAL',
5792.             'de' => $de ?? '', 'ate' => $ate ?? '',
5793.             'documento' => $documento,
5794.             'fed_cliente' => $fed_cliente
5795.         ]);
5796.     }
5798.     // ==========================================
5799.     // 3. API IMAGENS (E CLIENTES)
5800.     // ==========================================
5801.     #[Route('/api/kpis/imagens', name: 'api_kpis_imagens', methods: ['POST'])]
5802.     public function kpis_imagens(Request $request, EntityManagerInterface $entityManager): Response
5803.     {
5804.         $conn = $entityManager->getConnection();
5805.         $de = $request->request->get('de');
5806.         $ate = $request->request->get('ate');
5808.         if (!empty($de)) {
5809.             if (!empty($ate)) {
5810.                 $ateComHora = $ate . " 23:59:59";
5811.             } else {
5812.                 $ateComHora = null;
5813.             }
5815.             $queryStrImg = 'SELECT SUM(d.qtd) AS total_imagens FROM App\Entity\Documento d WHERE d.createdAt >= :de';
5816.             if ($ateComHora) { $queryStrImg .= ' AND d.createdAt <= :ate'; }
5817.             $queryImg = $entityManager->createQuery($queryStrImg)->setParameter('de', $de);
5818.             if ($ateComHora) { $queryImg->setParameter('ate', $ateComHora); }
5819.             $totalImagens = $queryImg->getSingleScalarResult() ?? 0;
5821.             $queryStrClientes = "
5822.                 SELECT 
5823.                     c.nome AS cliente_nome,
5824.                     (SELECT SUM(d2.qtd) 
5825.                     FROM App\Entity\Documento d2 
5826.                     JOIN d2.cliente c2 
5827.                     WHERE c2.clienteAll = c
5828.                     AND d2.createdAt >= :de " . ($ateComHora ? "AND d2.createdAt <= :ate" : "AND DATE(d2.createdAt) = DATE(:de)") . ") AS imagens_total
5829.                 FROM App\Entity\ClienteAll c
5830.                 ORDER BY c.nome ASC
5831.             ";
5832.             $queryClientes = $entityManager->createQuery($queryStrClientes)->setParameter('de', $de);
5833.             if ($ateComHora) { $queryClientes->setParameter('ate', $ateComHora); }
5834.             $fed_cliente = $queryClientes->getResult();
5836.             $dataTjrj = ['imagens_total' => 0];
5837.             $anoFiltro = (int) date('Y', strtotime($de));
5838.             if ($anoFiltro <= 2025) {
5839.                 try {
5840.                     $payload = json_encode(['data_inicio' => $de, 'data_fim' => $ate]);
5841.                     $options = ['http' => ['header' => "Content-Type: application/json\r\n", 'method' => 'POST', 'content' => $payload, 'timeout' => 5]];
5842.                     $context = stream_context_create($options);
5843.                     $response = @file_get_contents('https://produtive.arquivosdoc.com.br/api/tjrj', false, $context);
5844.                     if ($response !== false) { $dataTjrj = json_decode($response, true); }
5845.                 } catch (\Exception $e) {}
5846.             }
5848.             $fed_cliente[] = [
5849.                 'cliente_nome'  => 'TRIBUNAL DE JUSTICA DO ESTADO DO RIO DE JANEIRO',
5850.                 'imagens_total' => $dataTjrj['imagens_total'] ?? 0
5851.             ];
5852.         } else {
5853.             $sqlClientes = "
5854.                 SELECT 
5855.                     c.nome AS cliente_nome,
5856.                     (SELECT SUM(d.qtd) FROM documento d JOIN cliente s ON s.id = d.cliente_id WHERE s.cliente_all_id = c.id) AS imagens_total
5857.                 FROM cliente_all c ORDER BY c.nome ASC
5858.             ";
5859.             $fed_cliente = $conn->executeQuery($sqlClientes)->fetchAllAssociative();
5861.             $fed_cliente[] = [
5862.                 'cliente_nome'  => 'TRIBUNAL DE JUSTICA DO ESTADO DO RIO DE JANEIRO',
5863.                 'imagens_total' => 16699398
5864.             ];
5866.             $totalImagens = (float) $conn->fetchOne("SELECT SUM(d.qtd) FROM documento d") + 16699398; 
5867.         }
5868.         array_walk_recursive($fed_cliente, function (&$item) {
5870.             if (is_string($item) && !preg_match('//u', $item)) {
5872.                 $item = utf8_encode($item);
5873.             }
5874.         });
5875.         return $this->json([
5876.             'error' => '', 'motivo' => '', 'pagina' => 'kpis', 'h4' => 'TOTAL',
5877.             'de' => $de ?? '', 'ate' => $ate ?? '',
5878.             'totalImagens' => $totalImagens,
5879.             'fed_cliente' => $fed_cliente
5880.         ]);
5881.     }
5882.     
5883.     // ==========================================
5884.     // 2. API IA
5885.     // ==========================================
5886.    
5887.     #[Route('/api/kpis/documentos/ia', name: 'api_kpis_documentos_ia', methods: ['POST'])]
5888.     public function kpis_documentos_ia(
5889.         Request $request,
5890.         EntityManagerInterface $entityManager
5891.     ): Response {
5892.         $conn = $entityManager->getConnection();
5893.     
5894.         $de = $request->request->get('de');
5895.         $ate = $request->request->get('ate');
5896.     
5897.         if (!empty($de)) {
5898.             $ateComHora = !empty($ate) ? $ate . ' 23:59:59' : null;
5899.     
5900.             // Total de documentos no período
5901.             $queryStrDoc = '
5902.                 SELECT COUNT(d.id) AS total_documentos
5903.                 FROM App\Entity\Documento d
5904.                 WHERE d.createdAt >= :de
5905.             ';
5906.     
5907.             if ($ateComHora) {
5908.                 $queryStrDoc .= ' AND d.createdAt <= :ate';
5909.             }
5910.     
5911.             $queryDoc = $entityManager
5912.                 ->createQuery($queryStrDoc)
5913.                 ->setParameter('de', $de);
5914.     
5915.             if ($ateComHora) {
5916.                 $queryDoc->setParameter('ate', $ateComHora);
5917.             }
5918.     
5919.             $documento = (int) $queryDoc->getSingleScalarResult();
5920.     
5921.             // Quantidade de documentos com assertividade e média da IA por cliente
5922.             $queryStrClientes = "
5923.                 SELECT
5924.                     c.nome AS cliente_nome,
5925.     
5926.                     (
5927.                         SELECT COUNT(d1.id)
5928.                         FROM App\Entity\Documento d1
5929.                         JOIN d1.cliente c1
5930.                         WHERE c1.clienteAll = c
5931.                         AND d1.assertividadeIa IS NOT NULL
5932.                         AND d1.createdAt >= :de
5933.                         " . ($ateComHora ? "AND d1.createdAt <= :ate" : "") . "
5934.                     ) AS total_documentos,
5935.     
5936.                     (
5937.                         SELECT AVG(d2.assertividadeIa)
5938.                         FROM App\Entity\Documento d2
5939.                         JOIN d2.cliente c2
5940.                         WHERE c2.clienteAll = c
5941.                         AND d2.assertividadeIa IS NOT NULL
5942.                         AND d2.createdAt >= :de
5943.                         " . ($ateComHora ? "AND d2.createdAt <= :ate" : "") . "
5944.                     ) AS media_assertividade
5945.     
5946.                 FROM App\Entity\ClienteAll c
5947.                 ORDER BY c.nome ASC
5948.             ";
5949.     
5950.             $queryClientes = $entityManager
5951.                 ->createQuery($queryStrClientes)
5952.                 ->setParameter('de', $de);
5953.     
5954.             if ($ateComHora) {
5955.                 $queryClientes->setParameter('ate', $ateComHora);
5956.             }
5957.     
5958.             $fed_cliente = $queryClientes->getResult();
5959.     
5960.         } else {
5961.             // Consulta sem filtro de datas
5962.             $sqlClientes = "
5963.                 SELECT
5964.                     c.nome AS cliente_nome,
5965.     
5966.                     COUNT(d.id) AS total_documentos,
5967.     
5968.                     AVG(d.assertividade_ia) AS media_assertividade
5969.     
5970.                 FROM cliente_all c
5971.     
5972.                 LEFT JOIN cliente s
5973.                     ON s.cliente_all_id = c.id
5974.     
5975.                 LEFT JOIN documento d
5976.                     ON d.cliente_id = s.id
5977.                     AND d.assertividade_ia IS NOT NULL
5978.     
5979.                 GROUP BY c.id, c.nome
5980.                 ORDER BY c.nome ASC
5981.             ";
5982.     
5983.             $fed_cliente = $conn
5984.                 ->executeQuery($sqlClientes)
5985.                 ->fetchAllAssociative();
5986.     
5987.             $documento = (int) $conn->fetchOne(
5988.                 "SELECT COUNT(d.id) FROM documento d"
5989.             );
5990.         }
5991.     
5992.         // Formata a média para duas casas decimais
5993.         foreach ($fed_cliente as &$cliente) {
5994.             if ($cliente['media_assertividade'] !== null) {
5995.                 $cliente['media_assertividade'] = round(
5996.                     (float) $cliente['media_assertividade'],
5997.                     2
5998.                 );
5999.             }
6000.         }
6001.         unset($cliente);
6002.     
6003.         // Corrige possíveis strings com codificação inválida
6004.         array_walk_recursive($fed_cliente, function (&$item) {
6005.             if (is_string($item) && !preg_match('//u', $item)) {
6006.                 $item = utf8_encode($item);
6007.             }
6008.         });
6009.     
6010.         return $this->json([
6011.             'error' => '',
6012.             'motivo' => '',
6013.             'pagina' => 'kpis',
6014.             'h4' => 'TOTAL',
6015.             'de' => $de ?? '',
6016.             'ate' => $ate ?? '',
6017.             'documento' => $documento,
6018.             'fed_cliente' => $fed_cliente
6019.         ]);
6020.     }
6022.     
6023.     
6024.     
6025.     
6026.     
6027.       #[Route('/api/etapas/ia', name: 'busca_etapa_para_ia', methods: ['GET'])]
6028.     public function busca_etapa_para_ia(
6029.         Request $request,
6030.         EntityManagerInterface $entityManager
6031.     ): Response {
6033.         $clientS3 = new S3Client([
6034.                 'region'  => 'sa-east-1',
6035.                 'version' => 'latest',
6036.                
6037.             ]);
6040.         $etapa = $entityManager->createQuery(
6041.             'SELECT e, f, c
6042.             FROM App\Entity\Etapa e
6043.             JOIN e.fluxo f
6044.             JOIN f.cliente c
6045.             WHERE e.user = :user
6046.             AND e.prompt IS NOT NULL
6047.             AND EXISTS (
6048.                 SELECT 1
6049.                 FROM App\Entity\Documento d
6050.                 JOIN d.caixa cx
6051.                 WHERE cx.fluxo = f
6052.                 AND d.tipo IS NULL
6053.             )
6054.             ORDER BY e.ordem ASC'
6055.         )
6056.         ->setParameter('user', 115)
6057.         ->setMaxResults(1)
6058.         ->getOneOrNullResult();
6060.         
6061.         if(!$etapa){
6062.             return $this->json([
6063.                 'success'=>false,
6064.                 'message'=>'Nenhuma etapa encontrada.'
6065.             ],404);
6066.         }
6068.         $prompt = $entityManager->createQuery(
6069.             'SELECT p
6070.             FROM App\Entity\Prompt p
6071.             WHERE p.id = :id'
6072.             
6073.         )->setParameter('id',$etapa->getPrompt()->getId())
6074.         ->setMaxResults(1)
6075.         ->getOneOrNullResult();
6076.      
6078.         $fluxo = $etapa->getFluxo();
6080.         $caixas = $entityManager
6081.             ->getRepository(Caixa::class)
6082.             ->findBy([
6083.                 'fluxo'=>$fluxo
6084.             ]);
6086.         $caixaIds = array_map(
6087.             fn(Caixa $c)=>$c->getId(),
6088.             $caixas
6089.         );
6091.         $documentos = $entityManager
6092.             ->getRepository(Documento::class)
6093.             ->createQueryBuilder('d')
6094.             ->select('partial d.{id,nome,image,createdAt}')
6095.             ->join('d.caixa', 'c')                // Faz o join com a entidade Caixa
6096.             ->where('d.caixa IN(:caixas)')
6097.             ->andWhere('d.tipo IS NULL')
6098.             ->setParameter('caixas', $caixaIds)
6099.             ->orderBy('c.id', 'ASC')             // Ordena pelo ID da Caixa (menor para o maior)
6100.             ->addOrderBy('d.id', 'ASC')          // (Opcional) Depois ordena pelo ID do documento
6101.             ->getQuery()
6102.             ->getResult();
6104.         $docs=[];
6105.         foreach($documentos as $doc){
6107.             $cliente_nome= $fluxo->getCliente()->getNome();
6108.             $clientes= $fluxo->getCliente()->getId();
6109.             $umlautString =$cliente_nome;
6110.             $slugger = new AsciiSlugger();
6111.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
6112.             $caminho = strtolower ($teste.'/');
6113.                             
6114.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
6115.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
6116.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
6117.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
6118.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
6119.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
6120.             if($clientes ==  15){$caminho='cbsi-dossies/';}
6121.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
6122.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
6123.             if($clientes ==  127){$caminho='pmecj-s-a.A) - ALMOXARIFADO E PATRIMÔNIO/';}
6125.             
6126.             if($fluxo->getCliente()->getExtraFields()!= "local"){
6127.                 $cmd = $clientS3->getCommand('GetObject', [
6128.                     'Bucket' => 'arquivosdoc',
6129.                     'Key'    => $caminho. $doc->getImage(), 
6130.                 ]);
6131.                 
6132.                 $req = $clientS3->createPresignedRequest($cmd,  '+4 hours');
6133.                 $all_Url = (string) $req->getUri();
6134.             }else{
6135.                $all_Url =$doc->getImage();
6136.             }
6138.             $docs[]=[
6139.                 'id'=>$doc->getId(),
6140.                 'image'=>$all_Url,
6141.             ];
6142.         }
6144.         return $this->json([
6146.             'success'=>true,
6147.             'prompt'=>[
6148.                 'id' => $prompt->getId(),
6149.                 'campo1' => $prompt->getNome(),
6150.                 'campo2' => $prompt->getAssunto(),
6151.                 'campo3' => $prompt->getKeywords(),
6152.                 'data' => $prompt->getDataDocumento(),
6153.                 'tipos' => $prompt->getTipos(),
6154.                 'classificacoes' => $prompt->getClassificacoes(),
6155.                 'letras' => $prompt->getLetras(),
6156.             ],
6157.             'documentos'=>$docs,
6160.         ]);
6162.     }
6163.     
6164.     
6165.     
6166.      #[Route('/api/etapas/ia/salvar', name: 'salvar_resultado_ia', methods: ['POST'])]
6167.     public function salvarResultadoIa(
6168.         Request $request,
6169.         EntityManagerInterface $entityManager,
6170.         DocumentoRepository $documentoRepository,
6171.         TipoRepository $tipoRepository,
6172.         CaixaRepository $caixaRepository,
6173.         ClassificacaoRepository $classificacaoRepository
6174.     ): JsonResponse {
6175.         // Recebe o JSON enviado pelo Worker Python
6176.         $dataPayload = json_decode($request->getContent(), true);
6177.         $dadosAlterados = [];
6178.         if (!$dataPayload || !isset($dataPayload['documento_id'])) {
6179.             return $this->json([
6180.                 'success' => false,
6181.                 'message' => 'Payload inválido. "documento_id" é obrigatório.'
6182.             ], Response::HTTP_BAD_REQUEST);
6183.         }
6185.         $documentoId = $dataPayload['documento_id'];
6186.         $dados = $dataPayload['dados_extraidos'] ?? [];
6188.         // 1. Busca o Documento PDF no banco
6189.         $pdf = $documentoRepository->find($documentoId);
6190.         if (!$pdf) {
6191.             return $this->json([
6192.                 'success' => false,
6193.                 'message' => "Documento ID {$documentoId} não encontrado."
6194.             ], Response::HTTP_NOT_FOUND);
6195.         }
6197.          $caixaObj = $caixaRepository->findOneBy(['id'=>$pdf->getCaixa()->getId()]);
6198.          $fluxo = $caixaObj->getFluxo();
6199.         
6200.         $dadosAlterados['Repositor'] = $caixaObj->getNome();
6201.         $tipoNome = $dados['tipos'] ?? null;
6202.         
6203.         if ($tipoNome) {
6204.             $tipoObj = $tipoRepository->findOneBy(['nome' => trim($tipoNome),'cliente'=>$pdf->getCliente()]);
6205.             if ($tipoObj) {
6206.                 $pdf->setTipo($tipoObj);
6207.                 $dadosAlterados['Tipo'] = $tipoObj->getNome();
6208.             }
6209.         }
6210.         
6211.        
6212.         $classificacaoTexto = $dados['classificacoes'] ?? null;
6213.         $classificacaoObj = null;
6215.         if ($classificacaoTexto) {
6216.           
6217.             if (!$classificacaoObj) {
6218.                 $classificacaoObj = $classificacaoRepository->findOneBy(['nome' => trim($classificacaoTexto),'cliente'=>$pdf->getCliente()]);
6219.             }
6221.             if ($classificacaoObj) {
6222.                 $pdf->setClassificacao($classificacaoObj);
6223.                 $dadosAlterados['TDD'] = $classificacaoObj->getNome();
6224.             }
6225.         }
6228.         $dataDocString = $dados['data'] ?? null;
6229.         
6231.         if (!empty($dataDocString) && $dataDocString !== 'null' && $dataDocString !== 'undefined') {
6232.             try {
6233.                 $dataDocumento = \DateTimeImmutable::createFromFormat('!Y-m-d', (string)$dataDocString)
6234.                     ?: \DateTimeImmutable::createFromFormat('!d/m/Y', (string)$dataDocString);
6236.                 if ($dataDocumento !== false) {
6237.                     
6238.                     $pdf->setDataDocumento($dataDocumento);
6239.                     $dadosAlterados['Data Documento'] = $dataDocString;
6241.                     if ($classificacaoObj && method_exists($classificacaoObj, 'getFaseIntermediaria')) {
6242.                         $faseRaw = $classificacaoObj->getFaseIntermediaria();
6244.                         if ($faseRaw !== null && $faseRaw !== '' && $faseRaw !== 'null') {
6245.                             
6246.                             if (preg_match('/\d+/', (string)$faseRaw, $matches)) {
6247.                                 $anosParaSomar = (int) $matches[0];
6249.                                 if ($anosParaSomar > 0) {
6250.                                     $vencimento = $dataDocumento->modify("+{$anosParaSomar} years");
6251.                                     $pdf->setVencimentoDocumento($vencimento);
6252.                                 }
6253.                             }
6254.                         }
6255.                     }
6256.                 }
6257.             } catch (\Throwable $e) {
6258.             }
6259.         }
6260.         
6261.        if (isset($dados['campo1'])) {
6262.             $pdf->setNome($dados['campo1']);
6263.             $dadosAlterados['Nome'] = $dados['campo1'];
6264.         }
6265.         
6266.         if (isset($dados['campo2'])) {
6267.             $pdf->setAssunto($dados['campo2']);
6268.             $dadosAlterados['Assunto'] = $dados['campo2'];
6269.         }
6270.         
6271.         if (isset($dados['campo3'])) {
6272.             $pdf->setKeywords($dados['campo3']);
6273.             $dadosAlterados['Palavra-Chave'] = $dados['campo3'];
6274.         }
6275.         $pdf->setUserIndex("LEONARDO DE SOUZA CRUZEIRO");
6276.         
6277.         $pdf->setIndexAt(
6278.             new \DateTimeImmutable('now', new \DateTimeZone('America/Sao_Paulo'))
6279.         );
6280.         
6282.         
6283.         // Localização / IP
6284.         $ip_cliente = isset($_SERVER['HTTP_X_FORWARDED_FOR']) ? explode(',', $_SERVER['HTTP_X_FORWARDED_FOR'])[0] : $_SERVER['REMOTE_ADDR'];
6285.         $geo = @json_decode(@file_get_contents("http://ip-api.com/json/{$ip_cliente}"));
6286.         $localizacao = ($geo && $geo->status === 'success') 
6287.             ? "IP: {$ip_cliente} | País: {$geo->country} | Estado: {$geo->regionName} | Cidade: {$geo->city} | CEP: {$geo->zip} | ISP: {$geo->isp}"
6288.             : "IP: {$ip_cliente} | Localização não disponível";
6290.         $log = new Registro();
6291.         $log->setOperacao(
6292.             sprintf(
6293.                 "Indexação-(Dados Indexado: %s)",
6294.                 json_encode($dadosAlterados, JSON_UNESCAPED_UNICODE)
6295.             )
6296.         );
6297.         $log->setIp($localizacao);
6298.         $log->setFluxo($fluxo);
6299.         $log->setData(new \DateTimeImmutable('America/Sao_Paulo'));
6300.         $log->setIdUser($entityManager->getRepository(User::class)->find(115));
6301.         $entityManager->persist($log);
6302.         $entityManager->flush();
6303.         
6304.         return $this->json([
6305.             'success' => true,
6306.             'message' => 'Documento indexado com sucesso!',
6307.             'documento_id' => $pdf->getId()
6308.         ]);
6309.     }
6310.     
6311.     #[Route('/api/documentos/vps', name: 'api_documento_store', methods: ['POST'])]
6312.     public function store(Request $request, EntityManagerInterface $em): JsonResponse
6313.     {
6314.         
6315.         $data = json_decode($request->getContent(), true);
6317.         if (!$data) {
6318.             return $this->json(['error' => 'Payload inválido'], 400);
6319.         }
6321.         try {
6322.             // 2. Busca das entidades na VPS (onde o banco está)
6323.             $caixa = $em->getRepository(Caixa::class)->find($data['caixaId']);
6324.             $cliente = $em->getRepository(Cliente::class)->find($data['clienteId']);
6325.             $user = $em->getRepository(User::class)->find($data['userId']);
6327.             if (!$caixa || !$cliente || !$user) {
6328.                 return $this->json(['error' => 'Entidades não encontradas'], 404);
6329.             }
6331.             // 3. Criação do documento com os dados já processados na máquina Gamer
6332.             $documento = new Documento();
6333.             $documento->setCaixa($caixa);
6334.             $documento->setCliente($cliente);
6335.             $documento->setUser($user);
6336.             $documento->setNome($data['nome'] ?? '');
6337.             $documento->setAssunto($data['assunto'] ?? null);
6338.             $documento->setKeywords($data['keywords'] ?? null);
6339.             $documento->setConteiner($data['conteiner'] ?? '');
6340.             $documento->setImage($data['image'] ?? null);
6341.             $documento->setOcr($data['ocr'] ?? null);
6342.             $documento->setQtd($data['qtd'] ?? 0);
6343.             $documento->setQtd1($data['qtd1'] ?? 0);
6344.             $documento->setImgs($data['imgs'] ?? null);
6346.             if (!empty($data['tipoId'])) {
6347.                 $tipo = $em->getRepository(Tipo::class)->find($data['tipoId']);
6348.                 if ($tipo) {
6349.                     $documento->setTipo($tipo);
6350.                 }
6351.             }
6353.             // 4. Salva no banco da VPS
6354.             $em->persist($documento);
6355.             $em->flush();
6357.             return $this->json(['status' => 'sucesso', 'id' => $documento->getId()], 201);
6359.         } catch (\Throwable $e) {
6360.             return $this->json(['error' => $e->getMessage()], 500);
6361.         }
6362.     }
6363.     
6364.     
6367.     #[Route('/api/qualidade/salvar', name: 'api_qualidade_salvar', methods: ['POST'])]
6368.     public function salvarQualidadeApi(
6369.         Request $request, 
6370.         ManagerRegistry $doctrine, 
6371.         EntityManagerInterface $entityManager, 
6372.         DriveToOneDriveService $service
6373.     ): JsonResponse {
6374.         try {
6375.             $data = json_decode($request->getContent(), true);
6376.     
6377.             if (!$data || !isset($data['documento_id'])) {
6378.                 return new JsonResponse([
6379.                     'success' => false, 
6380.                     'message' => 'Dados inválidos ou ID do documento não fornecido.'
6381.                 ], 400);
6382.             }
6383.     
6384.             $pdf = $doctrine->getRepository(Documento::class)->find($data['documento_id']);
6385.     
6386.             if (!$pdf) {
6387.                 return new JsonResponse([
6388.                     'success' => false, 
6389.                     'message' => 'Documento não encontrado.'
6390.                 ], 404);
6391.             }
6392.     
6393.             // 1. Capturar os valores originais da IA antes de atualizar
6394.             $originalAssunto = $pdf->getAssunto();
6395.             $originalDescricao = $pdf->getExtraFields();
6396.             $originalNome = $pdf->getNome();
6397.             $originalKeywords = $pdf->getKeywords();
6398.             $originalConteiner = $pdf->getConteiner();
6399.             
6400.             $originalDataDoc = $pdf->getDataDocumento() ? $pdf->getDataDocumento()->format('Y-m-d') : null;
6401.             $originalDataVenc = $pdf->getVencimentoDocumento() ? $pdf->getVencimentoDocumento()->format('Y-m-d') : null;
6402.             
6403.             $originalClassId = $pdf->getClassificacao() ? $pdf->getClassificacao()->getId() : null;
6404.     
6405.             // 2. Aplicar as alterações enviadas pelo humano
6406.             $clientes = $pdf->getCliente() ? $pdf->getCliente()->getId() : null;
6407.     
6408.             if (!empty($data['data_documento'])) {
6409.                 $pdf->setDataDocumento(new \DateTimeImmutable($data['data_documento']));
6410.             }
6411.     
6412.             if (!empty($data['data_vencimento'])) {
6413.                 $pdf->setVencimentoDocumento(new \DateTimeImmutable($data['data_vencimento']));
6414.             }
6415.     
6416.             if (!empty($data['classificacao_id'])) {
6417.                 $classificacaoObj = $doctrine->getRepository(Classificacao::class)->find($data['classificacao_id']);
6418.                 if ($classificacaoObj) {
6419.                     $pdf->setClassificacao($classificacaoObj);
6420.                 }
6421.             }
6422.             
6423.             $clienteExtraFields = $entityManager->createQueryBuilder()
6424.                     ->select('c.extraFields')
6425.                     ->from(Cliente::class, 'c')
6426.                     ->where('c.id = :id')
6427.                     ->setParameter('id', $clientes)
6428.                     ->getQuery()
6429.                     ->getSingleScalarResult();
6430.     
6431.             if ($clienteExtraFields == "local") {
6432.                 $pdf->setRenomear(1);
6433.             }
6434.     
6435.             $pdf->setAssunto($data['assunto'] ?? null);
6436.             $pdf->setExtraFields($data['descricao'] ?? null);
6437.             $pdf->setNome($data['nome'] ?? null);
6438.             $pdf->setKeywords($data['palavra_chave'] ?? null);
6439.             $pdf->setConteiner($data['container'] ?? null);
6440.     
6441.             // 3. Cálculo da assertividade usando similaridade de strings e verificação de datas/ids
6442.             $calcularSimilaridade = function(?string $original, ?string $novo): float {
6443.                 $original = trim($original ?? '');
6444.                 $novo = trim($novo ?? '');
6445.     
6446.                 if ($original === '' && $novo === '') {
6447.                     return 100.0;
6448.                 }
6449.                 
6450.                 if ($original === '' || $novo === '') {
6451.                     return 0.0;
6452.                 }
6453.     
6454.                 similar_text($original, $novo, $percentual);
6455.                 return $percentual; 
6456.             };
6457.     
6458.             $scoreAssunto = $calcularSimilaridade($originalAssunto, $data['assunto'] ?? null);
6459.             $scoreDescricao = $calcularSimilaridade($originalDescricao, $data['descricao'] ?? null);
6460.             $scoreNome = $calcularSimilaridade($originalNome, $data['nome'] ?? null);
6461.             $scoreKeywords = $calcularSimilaridade($originalKeywords, $data['palavra_chave'] ?? null);
6462.             $scoreConteiner = $calcularSimilaridade($originalConteiner, $data['container'] ?? null);
6463.     
6464.             $novaDataDoc = !empty($data['data_documento']) ? (new \DateTimeImmutable($data['data_documento']))->format('Y-m-d') : null;
6465.             $scoreDataDoc = ($originalDataDoc === $novaDataDoc) ? 100.0 : 0.0;
6466.     
6467.             $novaDataVenc = !empty($data['data_vencimento']) ? (new \DateTimeImmutable($data['data_vencimento']))->format('Y-m-d') : null;
6468.             $scoreDataVenc = ($originalDataVenc === $novaDataVenc) ? 100.0 : 0.0;
6469.     
6470.             $novaClassId = !empty($data['classificacao_id']) ? (int)$data['classificacao_id'] : null;
6471.             $scoreClass = ($originalClassId === $novaClassId) ? 100.0 : 0.0;
6472.     
6473.             $totalCampos = 8;
6474.             $porcentagemAssertividade = (
6475.                 $scoreAssunto + 
6476.                 $scoreDescricao + 
6477.                 $scoreNome + 
6478.                 $scoreKeywords + 
6479.                 $scoreConteiner + 
6480.                 $scoreDataDoc + 
6481.                 $scoreDataVenc + 
6482.                 $scoreClass
6483.             ) / $totalCampos;
6484.     
6485.             // Salva a porcentagem na entidade
6486.             $pdf->setAssertividadeIa($porcentagemAssertividade);
6487.     
6488.             // 4. Finalização
6489.             $user_nome_name = $entityManager->createQueryBuilder()
6490.                 ->select('u.nome')
6491.                 ->from(User::class, 'u')
6492.                 ->where('u.id = :id')
6493.                 ->setParameter('id', $data['etapa_user'])
6494.                 ->getQuery()
6495.                 ->getSingleScalarResult();
6496.             
6497.             $pdf->setUserIndex($user_nome_name);
6498.             $pdf->setIndexAt(new \DateTimeImmutable('America/Sao_Paulo'));
6499.             $pdf->setSituacao('OK');
6500.             
6501.             $entityManager->flush();
6502.     
6503.             return new JsonResponse([
6504.                 'success' => true,
6505.                 'message' => 'Documento conferido com sucesso!',
6506.             ]);
6507.     
6508.         } catch (\Exception $e) {
6509.             return new JsonResponse([
6510.                 'success' => false,
6511.                 'message' => 'Erro interno: ' . $e->getMessage()
6512.             ], 500);
6513.         }
6514.     }
6515.     
6516.     
6517.     #[Route('/api/etapas/renomear', name: 'busca_etapa_para_renomeara', methods: ['GET'])]
6518.     public function busca_etapa_para_renomear(
6519.         Request $request,
6520.         EntityManagerInterface $entityManager
6521.     ): Response {
6523.         $clientS3 = new S3Client([
6524.                 'region'  => 'sa-east-1',
6525.                 'version' => 'latest',
6526.                
6527.             ]);
6530.         $documentos = $entityManager
6531.             ->getRepository(Documento::class)
6532.             ->createQueryBuilder('d')
6533.             ->leftJoin('d.cliente', 'c')
6534.             ->leftJoin('d.classificacao', 'cl')
6535.             ->leftJoin('d.caixa', 'cx')
6536.             ->select('partial d.{id,nome,image,createdAt}')
6537.             ->addSelect('partial c.{id,nome,extraFields}')
6538.             ->addSelect('partial cl.{id,nome}')
6539.             ->addSelect('partial cx.{id,nome}')
6540.             ->where('d.renomear = 1')
6541.             ->orderBy('d.id', 'ASC')
6542.             ->getQuery()
6543.             ->getResult();
6545.         $docs=[];
6546.         
6547.         foreach($documentos as $doc){
6549.             $cliente_nome= $doc->getCliente()->getNome();
6550.             $clientes= $doc->getCliente()->getId();
6551.             $umlautString =$cliente_nome;
6552.             $slugger = new AsciiSlugger();
6553.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
6554.             $caminho = strtolower ($teste.'/');
6555.                             
6556.             if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
6557.             if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
6558.             if($clientes == 35){$caminho='pmecj-sp-saude/';}
6559.             if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
6560.             if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
6561.             if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
6562.             if($clientes ==  15){$caminho='cbsi-dossies/';}
6563.             if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
6564.             if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
6565.             if($clientes ==  127){$caminho='pmecj-s-a.A) - ALMOXARIFADO E PATRIMÔNIO/';}
6567.             
6568.             if($doc->getCliente()->getExtraFields()!= "local"){
6569.                 $cmd = $clientS3->getCommand('GetObject', [
6570.                     'Bucket' => 'arquivosdoc',
6571.                     'Key'    => $caminho. $doc->getImage(), 
6572.                 ]);
6573.                 
6574.                 $req = $clientS3->createPresignedRequest($cmd, '+30 minutes');
6575.                 $all_Url = (string) $req->getUri();
6576.             }else{
6577.                $all_Url =$doc->getImage();
6578.             }
6580.            $docs[] = [
6581.                 'id' => $doc->getId(),
6582.                 'nome' => $doc->getNome(),
6583.                 'cliente' => $cliente_nome,
6584.                 'image' => $all_Url,
6585.                 'caixa' => $doc->getCaixa()?->getNome() ?? 'SEM CAIXA',
6586.                 'cla' => $doc->getClassificacao()?->getNome() ?? 'SEM CLASSIFICAÇÃO',
6587.             ];
6588.         }
6589.         return $this->json([
6591.             'success'=>true,
6592.             'documentos'=>$docs,
6595.         ]);
6597.     }
6598.     
6599.     #[Route('/api/etapas/atualizar-renomear', name: 'busca_etapa_atualizar-renomear', methods: ['POST'])]
6600.     public function atualizarRenomear(Request $request, EntityManagerInterface $entityManager): JsonResponse
6601.     {
6602.         // Pega os dados enviados em JSON pelo Python
6603.         $data = json_decode($request->getContent(), true);
6604.         
6605.         $documentoId = $data['documento_id'] ?? null;
6606.         $caminho = $data['caminho'] ?? null;
6607.         if (!$documentoId) {
6608.             return new JsonResponse([
6609.                 'success' => false,
6610.                 'message' => 'ID do documento não informado.'
6611.             ], 400);
6612.         }
6614.         // Busca o documento no banco de dados
6615.         $documento = $entityManager->getRepository(Documento::class)->find($documentoId);
6617.         if (!$documento) {
6618.             return new JsonResponse([
6619.                 'success' => false,
6620.                 'message' => 'Documento não encontrado.'
6621.             ], 404);
6622.         }
6624.         
6625.         $documento->setRenomear(0); 
6626.         $documento->setMovimentacao($caminho);
6627.     
6628.         $entityManager->flush();
6630.         return new JsonResponse([
6631.             'success' => true,
6632.             'message' => "Documento {$documentoId} atualizado com sucesso (renomear = 0)."
6633.         ]);
6634.     }
6635.     
6636.     
6637.     
6638.     
6639.     
6640.     
6641.     public function configureDashboard(): Dashboard
6642.     {
6643.         return Dashboard::new()
6644.             ->setTitle('IndexDoc')
6645.             ->setFaviconPath('./img/icon.png');   
6646.     }
6647.     
6649.     public function configureMenuItems(): iterable
6650.     {
6651.         // yield MenuItem::linkToDashboard('Dashboard', 'fa fa-home');
6652.         // yield MenuItem::linkToCrud('The Label', 'fas fa-list', EntityClass::class);
6653.     }
6654. }