src/Controller/CadastroController.php line 59

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  6. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  7. use Symfony\Component\HttpFoundation\Response;
  8. use Symfony\Component\Routing\Annotation\Route;
  9. use App\Entity\Cliente;
  10. use App\Entity\Documento;
  11. use App\Entity\User;
  12. use App\Entity\Caixa;
  13. use App\Entity\Classificacao;
  14. use App\Entity\Tipo;
  15. use App\Entity\Registro;
  16. use App\Entity\Categoria;
  17. use App\Entity\Conteiner;
  18. use App\Entity\ConteinerResp;
  19. use Doctrine\Persistence\ManagerRegistry;
  20. use Symfony\Component\HttpFoundation\Request;
  21. use Symfony\Component\HttpFoundation\Session\Session;
  22. use Doctrine\ORM\EntityRepository;
  23. use Aws\S3\S3Client;
  24. use Aws\Common\Exception\MultipartUploadException;
  25. use Aws\S3\MultipartUploader;
  26. use Symfony\Component\Form\Extension\Core\Type\FileType;
  27. use Symfony\Component\Form\Extension\Core\Type\TextType;
  28. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  29. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  30. use Symfony\Component\Form\Extension\Core\Type\CheckboxType;
  31. use Symfony\Component\Form\Extension\Core\Type\RadioType;
  32. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  33. use App\Form\Type\CaixaType;
  34. use Symfony\Component\String\Slugger\AsciiSlugger;
  35. use Symfony\Component\Uid\Uuid;
  36. use setasign\Fpdi\Tcpdf\Fpdi;
  37. use setasign\Fpdi\PdfReader;
  38. use propa\tcpdi\tcpdi;
  39. use Symfony\Component\Dotenv\Dotenv;
  40. use Doctrine\ORM\EntityManagerInterface;
  41. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  42. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  43. use PhpOffice\PhpSpreadsheet\Writer\Xls;
  44. use Symfony\Component\HttpFoundation\BinaryFileResponse;
  45. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  53. class CadastroController extends AbstractController
  54. {
  56.  /**
  57.     * @Route("/", name="_home")
  58.     */
  59.     public function home(Request $request){
  60.   
  61.     return $this->redirect('https://ged.arquivosdoc.com.br/login');
  62.     }
  63.     
  64.     
  65.     
  66.      /**
  67.     * @Route("/excel/{clientes}", name="_excel")
  68.     */
  69.     public function excel(Request $request , ManagerRegistry $doctrine , $clientes){
  70.         
  71.         $i=0;
  72.         $doc = $doctrine->getRepository(Documento::class)->findBy(['cliente' =>$clientes]);
  73.         foreach ($doc as $docs ) {
  75.             $i = $i + 1;
  76.         }
  77.         
  78.             $spreadsheet = new Spreadsheet();
  79.             $sheet = $spreadsheet->getActiveSheet();
  80.             $sheet->setCellValue('A1' , 'DIAS DE EXPORTAÇÃO');
  81.             $sheet->setCellValue('B1' , 'QUANTIDADE PROCESSOS');
  82.             $sheet->setCellValue('C1' , 'CAIXA');
  83.             $sheet->setCellValue('D1' , 'PALAVRA-CHAVE');
  84.             $sheet->setCellValue('E1' , 'DESCRIÇÃO');
  85.             $sheet->setCellValue('F1' , 'DATA DO ENVIO');
  86.             $rowCount = 2;
  88.             foreach ($doc as $docs) {
  89.                 $nome = $docs->getNome();
  90.                 $assunto = $docs->getAssunto();
  91.                 $keywords = $docs->getKeywords();
  92.                 $desc = $docs->getExtraFields();
  93.                 $caixa = $docs->getCaixa()->getNome();
  94.                 $data  = $docs->getCreatedAt();
  95.                 $formattedDate = $data->format('d/m/y');
  96.                 
  97.                 $sheet->setCellValue('A' . $rowCount,$nome);
  98.                 $sheet->setCellValue('B' . $rowCount,$assunto);
  99.                 $sheet->setCellValue('C' . $rowCount,$caixa);
  100.                 $sheet->setCellValue('D' . $rowCount,$keywords);
  101.                 $sheet->setCellValue('E' . $rowCount,$desc);
  102.                 $sheet->setCellValue('F' . $rowCount,$formattedDate);
  103.                 $rowCount++;
  104.                 $count = 0;
  105.             
  106.             }
  108.             
  109.             $writer = new Xls($spreadsheet);
  110.             header('Content-Disposition: attachment;filename="Relátorio_de_quantidade.xls"');
  111.             $writer->save('php://output');
  112.             #dd($i);
  113.         return $this->render('cadastro/teste.html.twig', array(
  114.             
  115.             
  116.         ));
  117.         
  118.     }
  119.     
  120.     
  121.     /**
  122.     * @Route("/Importar-Arquivos/{users}/{clientes}", name="_importar")
  123.     */
  124.     public function importar(Request $request , ManagerRegistry $doctrine , $users , $clientes){
  125.        
  126.          $dotenv = new Dotenv();
  127.         $dotenv->load(__DIR__.'/.env');
  128.          $clientS3 = new  S3Client([
  129.                         'region'  => 'sa-east-1',
  130.                         'version' => 'latest',
  131.                         'credentials' => [
  132.                         'key'    =>$_ENV["AWS_KEY"],
  133.                         'secret' => $_ENV["AWS_SECRET"], 
  134.                         ]
  135.                     ]);
  136.         
  137.         $user = $doctrine->getRepository(User::class)->find($users);
  138.         $cliente = $doctrine->getRepository(Cliente::class)->find($clientes);
  139.         $empresaSelecionada= $cliente;
  140.         $clinetesss = $cliente->getNome();
  142.         $form = $this->createFormBuilder()
  143.         ->add('arquivos', FileType::class, [         
  144.             'label' => 'Arquivos',
  145.             'multiple' => true,
  146.             'attr' => [
  147.                 'class' => 'form-control'
  148.             ]
  149.         ])
  150.         
  151.         ->add('caixa', EntityType::class, [
  152.             // looks for choices from this entity
  153.             'class' => Caixa::class,
  154.            'query_builder' => function (EntityRepository $er) use ($empresaSelecionada) {
  155.                 return $er->createQueryBuilder('c')
  156.                     ->leftJoin('c.clientes', 'clientes')
  157.                     ->where("clientes.id = '" . $empresaSelecionada->getId() . "'")
  158.                     ->orderBy('c.id', 'ASC');
  159.             },
  161.             'attr' => array('data-widget' => 'select2' ,'class' => 'form-control' ,'id'=>'email'),
  162.             'choice_label' => 'nome',
  163.             'placeholder' => 'Selecione',
  164.             'required' => false
  166.             // used to render a select box, check boxes or radios
  167.             // 'multiple' => true,
  168.             // 'expanded' => true,
  169.         ])
  171.   
  172.         ->add('botao', SubmitType::class, [
  173.             
  174.             'label' => 'Importar',
  175.             'attr' => [
  176.                 'class' => 'btn btn-primary btn-lg active'
  177.             ]
  178.         ])
  181.         
  183.         ->getForm();
  184.         $form->handleRequest($request);  
  185.         $entityManager = $doctrine->getManager();
  186.         if (isset($form->getData()['arquivos']) != null ) {
  187.             $caixa = $form->getData()['caixa'];
  188.             
  189.             $arquivos = $form->getData()['arquivos'];
  190.             
  191.             $noFound = [];
  192.            
  193.             if($arquivos != null){
  194.                 foreach($arquivos as $arquivo){
  195.                     $uuid=Uuid::v4();
  196.                     $nome = $arquivo->getClientOriginalName();
  197.                     $nome = str_replace('.pdf', '', $nome);
  198.                     $imagick = new \Imagick();
  199.                     $imagick->pingImage($arquivo);
  200.                     $num5= $imagick->getNumberImages();
  201.                     $filename= $nome.$uuid.'.pdf';
  202.                     $umlautString = $clinetesss;
  203.                     $slugger = new AsciiSlugger();
  204.                     $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
  205.                     $caminho = strtolower ($teste.'/');
  206.                     
  207.                     if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
  208.                     if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
  209.                     if($clientes == 35){$caminho='pmecj-sp-saude/';}
  210.                     if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
  211.                     if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
  212.                     
  213.                      
  214.                     
  215.             
  216.             
  217.             if(isset($element['Caixa'])){
  218.                             
  219.                     $caixa = $element['Caixa'];
  220.                     $entityManager = $doctrine->getManager();
  221.                     $queryBuilder = $entityManager->createQueryBuilder()
  222.                             ->select('caixa')
  223.                             ->from(Caixa::class, 'caixa')
  224.                             ->leftJoin('caixa.clientes', 'clientes')
  225.                             ->AndWhere('LOWER(caixa.nome) LIKE :caixa')->setParameter('caixa', '% '. $caixa)
  226.                             ->AndWhere('clientes.id = :cliente')->setParameter('cliente', $cliente->getId())
  227.                             ;  
  229.                             $caixarepo = $queryBuilder->getQuery()->getArrayResult();
  230.                             foreach($caixarepo as $cx){
  231.                                 $caixaid =  $cx['id'];
  232.                                 $caixarepo = $this->getDoctrine()->getRepository(Caixa::class);
  233.                                 $caixa = $caixarepo->find($caixaid);
  234.                                 
  235.                             }  
  237.                             $documento->setCaixa($caixa);
  238.                         }
  240.                     if($caixa != null)  {$documento = $entityManager->getRepository(Documento::class)->findOneBy(array('cliente'=>$cliente, 'caixa'=>$caixa, 'nome'=>$nome ));}
  241.                     if($caixa == null)  {$documento = $entityManager->getRepository(Documento::class)->findOneBy(array('cliente'=>$cliente,'nome'=>$nome ));}
  242.                 
  243.                    
  244.                 
  245.                       
  246.                     if($documento != null){
  247.                         
  248.                         $image=$documento->getImage();
  249.                         $image1=$documento->getAnexo();
  250.                         $image2=$documento->getAnexo1();
  251.                         $image3=$documento->getAnexo2();
  252.                         $image4=$documento->getAnexo3();
  253.                         $image5=$documento->getAnexo4();
  254.                         $image6=$documento->getAnexo5();
  255.                         $image7=$documento->getAnexo6();
  256.                         $image8=$documento->getAnexo7();
  257.                         $image9=$documento->getAnexo8();
  258.                          
  259.                      
  261.                     if($image == null ){
  263.                             $response = $clientS3->putObject(array(
  264.                             'Bucket' => "arquivosdoc",
  265.                             'Key'    => $caminho . $filename,
  266.                             'SourceFile' => $arquivo,
  267.                             'ContentDisposition'=>'inline',
  268.                             'ContentType'=>'application/pdf',
  269.                         ));
  270.                         
  271.                     
  272.                         
  273.                             $documento->setImage($filename);
  274.                             $documento->setUser($user);
  275.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  276.                             $documento->setIndexAt(new \DateTime('America/Sao_Paulo'));
  277.                             $documento->setQtd1($num5);
  278.                             $qtd1=$documento->getQtd1();
  279.                             $qtd2=$documento->getQtd2();
  280.                             $qtd3=$documento->getQtd3();
  281.                             $qtd4=$documento->getQtd4();
  282.                             $qtd5=$documento->getQtd5();
  283.                             $qtd6=$documento->getQtd6();
  284.                             $qtd7=$documento->getQtd7();
  285.                             $qtd8=$documento->getQtd8();
  286.                             $qtd9=$documento->getQtd9();
  287.                             $qtd10=$documento->getQtd10();
  288.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);}
  290.                     if($image != null ){
  291.                         if($image1 == null ){
  293.                             $response = $clientS3->putObject(array(
  294.                             'Bucket' => "arquivosdoc",
  295.                             'Key'    => $caminho . $filename,
  296.                             'SourceFile' => $arquivo,
  297.                             'ContentDisposition'=>'inline',
  298.                             'ContentType'=>'application/pdf',
  299.                         ));
  300.                        
  301.                             $documento->setAnexo($filename);
  302.                             $documento->setQtd2($num5);
  303.                             $documento->setUser($user);
  304.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  305.                             $documento->setIndexAt(new \DateTime('America/Sao_Paulo'));
  306.                             $qtd1=$documento->getQtd1();
  307.                             $qtd2=$documento->getQtd2();
  308.                             $qtd3=$documento->getQtd3();
  309.                             $qtd4=$documento->getQtd4();
  310.                             $qtd5=$documento->getQtd5();
  311.                             $qtd6=$documento->getQtd6();
  312.                             $qtd7=$documento->getQtd7();
  313.                             $qtd8=$documento->getQtd8();
  314.                             $qtd9=$documento->getQtd9();
  315.                             $qtd10=$documento->getQtd10();
  317.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  319.                         }
  320.                          
  322.                     }
  325.                     if($image1 != null ){
  326.                         if($image2 == null ){
  328.                             $response = $clientS3->putObject(array(
  329.                             'Bucket' => "arquivosdoc",
  330.                             'Key'    => $caminho . $filename,
  331.                             'SourceFile' => $arquivo,
  332.                             'ContentDisposition'=>'inline',
  333.                             'ContentType'=>'application/pdf',
  334.                         ));
  335.                        
  336.                             $documento->setAnexo1($filename);
  337.                             $documento->setQtd3($num5);
  338.                             $documento->setUser($user);
  339.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  340.                             $documento->setIndexAt(new \DateTime('America/Sao_Paulo'));
  341.                             $qtd1=$documento->getQtd1();
  342.                             $qtd2=$documento->getQtd2();
  343.                             $qtd3=$documento->getQtd3();
  344.                             $qtd4=$documento->getQtd4();
  345.                             $qtd5=$documento->getQtd5();
  346.                             $qtd6=$documento->getQtd6();
  347.                             $qtd7=$documento->getQtd7();
  348.                             $qtd8=$documento->getQtd8();
  349.                             $qtd9=$documento->getQtd9();
  350.                             $qtd10=$documento->getQtd10();
  351.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  352.                             
  353.                         }
  354.                         
  355.                     }
  357.                     if($image2 != null ){
  358.                        if($image3 == null ){
  360.                             $response = $clientS3->putObject(array(
  361.                             'Bucket' => "arquivosdoc",
  362.                             'Key'    => $caminho . $filename,
  363.                             'SourceFile' => $arquivo,
  364.                             'ContentDisposition'=>'inline',
  365.                             'ContentType'=>'application/pdf',
  366.                         ));
  367.                         
  368.                             $documento->setAnexo2($filename);
  369.                             $documento->setQtd4($num5);
  370.                             $documento->setUser($user);
  371.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  372.                             $documento->setIndexAt(new \DateTime('America/Sao_Paulo'));
  373.                             $qtd1=$documento->getQtd1();
  374.                             $qtd2=$documento->getQtd2();
  375.                             $qtd3=$documento->getQtd3();
  376.                             $qtd4=$documento->getQtd4();
  377.                             $qtd5=$documento->getQtd5();
  378.                             $qtd6=$documento->getQtd6();
  379.                             $qtd7=$documento->getQtd7();
  380.                             $qtd8=$documento->getQtd8();
  381.                             $qtd9=$documento->getQtd9();
  382.                             $qtd10=$documento->getQtd10();
  383.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  384.                     }
  385.                         
  386.                         
  387.                     }
  389.                     if($image3 != null ){
  390.                         if($image4 == null ){
  392.                             $response = $clientS3->putObject(array(
  393.                             'Bucket' => "arquivosdoc",
  394.                             'Key'    => $caminho . $filename,
  395.                             'SourceFile' => $arquivo,
  396.                             'ContentDisposition'=>'inline',
  397.                             'ContentType'=>'application/pdf',
  398.                         ));
  400.                             $documento->setAnexo3($filename);
  401.                             $documento->setQtd5($num5);
  402.                             $documento->setUser($user);
  403.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  404.                             $documento->setIndexAt(new \DateTime('America/Sao_Paulo'));
  405.                             $qtd1=$documento->getQtd1();
  406.                             $qtd2=$documento->getQtd2();
  407.                             $qtd3=$documento->getQtd3();
  408.                             $qtd4=$documento->getQtd4();
  409.                             $qtd5=$documento->getQtd5();
  410.                             $qtd6=$documento->getQtd6();
  411.                             $qtd7=$documento->getQtd7();
  412.                             $qtd8=$documento->getQtd8();
  413.                             $qtd9=$documento->getQtd9();
  414.                             $qtd10=$documento->getQtd10();
  415.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  416.                             
  417.                             }
  418.                         
  419.                     }
  421.                     if($image4 != null ){
  422.                         if($image5 == null ){
  424.                             $response = $clientS3->putObject(array(
  425.                             'Bucket' => "arquivosdoc",
  426.                             'Key'    => $caminho . $filename,
  427.                             'SourceFile' => $arquivo,
  428.                             'ContentDisposition'=>'inline',
  429.                             'ContentType'=>'application/pdf',
  430.                         ));
  431.                            
  432.                             $documento->setAnexo4($filename);
  433.                             $documento->setQtd6($num5);
  434.                             $documento->setUser($user);
  435.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  436.                             $documento->setIndexAt(new \DateTime('America/Sao_Paulo'));
  437.                             $qtd1=$documento->getQtd1();
  438.                             $qtd2=$documento->getQtd2();
  439.                             $qtd3=$documento->getQtd3();
  440.                             $qtd4=$documento->getQtd4();
  441.                             $qtd5=$documento->getQtd5();
  442.                             $qtd6=$documento->getQtd6();
  443.                             $qtd7=$documento->getQtd7();
  444.                             $qtd8=$documento->getQtd8();
  445.                             $qtd9=$documento->getQtd9();
  446.                             $qtd10=$documento->getQtd10();
  447.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  448.                         }
  449.                         
  450.                     }
  451.                         
  452.                            
  453.                     if($image5 != null ){
  454.                         if($image6 == null ){ 
  456.                             $response = $clientS3->putObject(array(
  457.                             'Bucket' => "arquivosdoc",
  458.                             'Key'    => $caminho . $filename,
  459.                             'SourceFile' => $arquivo,
  460.                             'ContentDisposition'=>'inline',
  461.                             'ContentType'=>'application/pdf',
  462.                         ));      
  463.                             $documento->setAnexo5($filename);
  464.                             $documento->setQtd7($num5);
  465.                             $documento->setUser($user);
  466.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  467.                             $documento->setIndexAt(new \DateTime('America/Sao_Paulo'));
  468.                             $qtd1=$documento->getQtd1();
  469.                             $qtd2=$documento->getQtd2();
  470.                             $qtd3=$documento->getQtd3();
  471.                             $qtd4=$documento->getQtd4();
  472.                             $qtd5=$documento->getQtd5();
  473.                             $qtd6=$documento->getQtd6();
  474.                             $qtd7=$documento->getQtd7();
  475.                             $qtd8=$documento->getQtd8();
  476.                             $qtd9=$documento->getQtd9();
  477.                             $qtd10=$documento->getQtd10();
  478.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  479.                         }    
  480.                         
  481.                     } 
  483.                     if($image6 != null ){
  484.                         if($image7 == null ){
  486.                             $response = $clientS3->putObject(array(
  487.                             'Bucket' => "arquivosdoc",
  488.                             'Key'    => $caminho . $filename,
  489.                             'SourceFile' => $arquivo,
  490.                             'ContentDisposition'=>'inline',
  491.                             'ContentType'=>'application/pdf',
  492.                         ));
  493.                             $documento->setAnexo6($filename);
  494.                             $documento->setQtd8($num5);
  495.                             $documento->setUser($user);
  496.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  497.                             $documento->setIndexAt(new \DateTime('America/Sao_Paulo'));
  498.                             $qtd1=$documento->getQtd1();
  499.                             $qtd2=$documento->getQtd2();
  500.                             $qtd3=$documento->getQtd3();
  501.                             $qtd4=$documento->getQtd4();
  502.                             $qtd5=$documento->getQtd5();
  503.                             $qtd6=$documento->getQtd6();
  504.                             $qtd7=$documento->getQtd7();
  505.                             $qtd8=$documento->getQtd8();
  506.                             $qtd9=$documento->getQtd9();
  507.                             $qtd10=$documento->getQtd10();
  508.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  509.                         }
  510.                         
  511.                     }
  514.                       if($image7 != null ){
  515.                         if($image8 == null ){
  516.                             $response = $clientS3->putObject(array(
  517.                             'Bucket' => "arquivosdoc",
  518.                             'Key'    => $caminho . $filename,
  519.                             'SourceFile' => $arquivo,
  520.                             'ContentDisposition'=>'inline',
  521.                             'ContentType'=>'application/pdf',
  522.                         ));
  524.                             $documento->setAnexo7($filename);
  525.                             $documento->setQtd9($num5);
  526.                             $documento->setUser($user);
  527.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  528.                             $documento->setIndexAt(new \DateTime('America/Sao_Paulo'));
  529.                             $qtd1=$documento->getQtd1();
  530.                             $qtd2=$documento->getQtd2();
  531.                             $qtd3=$documento->getQtd3();
  532.                             $qtd4=$documento->getQtd4();
  533.                             $qtd5=$documento->getQtd5();
  534.                             $qtd6=$documento->getQtd6();
  535.                             $qtd7=$documento->getQtd7();
  536.                             $qtd8=$documento->getQtd8();
  537.                             $qtd9=$documento->getQtd9();
  538.                             $qtd10=$documento->getQtd10();
  539.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  540.                         }    
  541.                             
  542.                     }
  545.                     if($image8 != null ){
  546.                         if($image9 == null ){
  547.                             $response = $clientS3->putObject(array(
  548.                             'Bucket' => "arquivosdoc",
  549.                             'Key'    => $caminho . $filename,
  550.                             'SourceFile' => $arquivo,
  551.                             'ContentDisposition'=>'inline',
  552.                             'ContentType'=>'application/pdf',
  553.                         ));
  555.                             $documento->setAnexo8($filename);
  556.                             $documento->setQtd10($num5);
  557.                             $documento->setUser($user);
  558.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  559.                             $documento->setIndexAt(new \DateTime('America/Sao_Paulo'));
  560.                             $qtd1=$documento->getQtd1();
  561.                             $qtd2=$documento->getQtd2();
  562.                             $qtd3=$documento->getQtd3();
  563.                             $qtd4=$documento->getQtd4();
  564.                             $qtd5=$documento->getQtd5();
  565.                             $qtd6=$documento->getQtd6();
  566.                             $qtd7=$documento->getQtd7();
  567.                             $qtd8=$documento->getQtd8();
  568.                             $qtd9=$documento->getQtd9();
  569.                             $qtd10=$documento->getQtd10();
  570.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  571.                         }
  572.                         
  573.                     }   
  576.                     if($image9 != null ){
  578.                         $response = $clientS3->putObject(array(
  579.                             'Bucket' => "arquivosdoc",
  580.                             'Key'    => $caminho . $filename,
  581.                             'SourceFile' => $arquivo,
  582.                             'ContentDisposition'=>'inline',
  583.                             'ContentType'=>'application/pdf',
  584.                         ));
  585.                          echo '<script>alert("Todos os anexos cheios , anexos 10 foi substituido!")</script>';
  586.                          $documento->setAnexo8($filename);
  587.                          $documento->setQtd10($num5);
  588.                          $documento->setUser($user);
  589.                          $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  590.                          $documento->setIndexAt(new \DateTime('America/Sao_Paulo'));
  591.                          $qtd1=$documento->getQtd1();
  592.                          $qtd2=$documento->getQtd2();
  593.                          $qtd3=$documento->getQtd3();
  594.                          $qtd4=$documento->getQtd4();
  595.                          $qtd5=$documento->getQtd5();
  596.                          $qtd6=$documento->getQtd6();
  597.                          $qtd7=$documento->getQtd7();
  598.                          $qtd8=$documento->getQtd8();
  599.                          $qtd9=$documento->getQtd9();
  600.                          $qtd10=$documento->getQtd10();
  601.                          $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  602.                        
  603.                     
  604.                         
  605.                         
  606.                     }   
  607.                       
  609.                         
  610.                         
  611.                     }
  612.                         
  613.                      
  614.                     
  615.                     else
  616.                         array_push($noFound, $nome);
  617.                 } 
  618.                 $entityManager->flush();
  619.                 if($noFound != null){
  620.                     echo '<script>alert("Importação não Concluída! '
  621.                     . implode(", ", $noFound). ' não encontrado(s).")</script>';
  622.                 }else{
  623.                     echo '<script>alert("Importação  Concluída!")</script>';
  624.                    
  625.                 }
  626.                
  627.             }
  628.         }    
  631.         return $this->render('cadastro/index1.html.twig', array(
  632.             'form' => $form->createView(),
  633.             
  634.         ));
  635.     }
  636.     
  637.       /**
  638.     * @Route("/Importar-Arquivos/{users}/{clientes}/Assinador", name="_importar_assinar")
  639.     */
  640.     public function importarAssinador(Request $request , ManagerRegistry $doctrine , $users , $clientes){
  641.         
  642.         
  643.         $assinatura='';
  644.         $pdfnaoassinados=[];
  645.         $dotenv = new Dotenv();
  646.         $dotenv->load(__DIR__.'/.env');
  647.         $clientS3 = new  S3Client([
  648.                         'region'  => 'sa-east-1',
  649.                         'version' => 'latest',
  650.                         'credentials' => [
  651.                         'key'    =>$_ENV["AWS_KEY"],
  652.                         'secret' => $_ENV["AWS_SECRET"], 
  653.                         ]
  654.                     ]);
  655.         
  656.         $user = $doctrine->getRepository(User::class)->find($users);
  657.         $usersss = $user->getNome();
  658.         $usersss_id = $user->getId();
  659.         $pasta_user=$usersss.'/';
  660.         $cliente = $doctrine->getRepository(Cliente::class)->find($clientes);
  661.         $empresaSelecionada= $cliente;
  662.         $clinetesss = $cliente->getNome();
  664.         $form = $this->createFormBuilder()
  665.         ->add('arquivos', FileType::class, [         
  666.             'label' => 'Arquivos',
  667.             'multiple' => true,
  668.             'attr' => [
  669.                 'class' => 'form-control'
  670.             ]
  671.         ])
  672.         
  673.         ->add('caixa', EntityType::class, [
  674.            'class' => Caixa::class,
  675.            'query_builder' => function (EntityRepository $er) use ($empresaSelecionada) {
  676.                 return $er->createQueryBuilder('c')
  677.                     ->leftJoin('c.clientes', 'clientes')
  678.                     ->where("clientes.id = '" . $empresaSelecionada->getId() . "'")
  679.                     ->orderBy('c.id', 'ASC');
  680.             },
  682.             'attr' => array('class' => 'teste' ),
  683.             'choice_label' => 'nome',
  684.             'placeholder' => 'Selecione',
  685.             'required' => false
  686.         ])
  689.         ->add('assinaturas', CheckboxType::class, [
  690.            
  691.             'label' => ' ',
  692.             'required' => false,
  693.             'attr' => [
  694.                 'class' => 'input-lg'
  695.             ]
  698.         ])
  701.   
  702.         ->add('botao', SubmitType::class, [
  703.             
  704.             'label' => 'Importar',
  705.             'attr' => [
  706.                 'class' => 'btn btn-primary btn-lg active'
  707.             ]
  708.         ])
  711.         
  713.         ->getForm();
  714.         $form->handleRequest($request);  
  715.         $entityManager = $doctrine->getManager();
  716.         if (isset($form->getData()['arquivos']) != null ) {
  717.             $assina=$form->getData()['assinaturas'];
  718.             $caixa = $form->getData()['caixa']; 
  719.             $arquivos = $form->getData()['arquivos'];
  720.             $noFound = [];
  721.             $arr = [];
  725.            
  726.             
  727.             if($arquivos != null){
  728.                 if (file_exists($usersss)) {
  729.                     
  730.                 }
  731.                 
  732.                 else{
  733.                  mkdir($pasta_user, 0777, true);
  734.                 }
  735.                
  737.                 $total_count = is_countable( $arquivos ) ? count( $arquivos ) : 0;
  738.                 for( $i=0 ; $i < $total_count ; $i++ ) { 
  739.                             
  740.                     $tmpFilePath = $form->getData()['arquivos'][$i];
  741.                     $nomes = $tmpFilePath->getClientOriginalName();
  742.                     move_uploaded_file($tmpFilePath,$pasta_user.$nomes);
  743.                     $arr[] = $nomes;
  747.                 
  749.                 }
  751.                 $arrr=0;
  752.                 foreach($arquivos as $arquivo){
  753.                     
  754.                 
  755.                 $version='1';
  756.                 $uuid=Uuid::v4();
  757.                 $variavelconvert='Convertido_'.$uuid.'.pdf';
  758.                 $nome = $arquivo->getClientOriginalName();
  759.                 $nome = str_replace('.pdf', '', $nome);
  760.                 $imagick = new \Imagick();
  761.                 $imagick->pingImage($pasta_user.$arr[$arrr]);
  762.                 $num5= $imagick->getNumberImages();
  763.                 $filename= $nome.$uuid.'.pdf';
  764.                 $filename1= $nome.$uuid.'.pdf';
  765.                 $umlautString = $clinetesss;
  766.                 $slugger = new AsciiSlugger();
  767.                 $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
  768.                 $caminho = strtolower ($teste.'/');
  769.                 #$num5=2;  
  770.                 $filecontent = file_get_contents($pasta_user.$arr[$arrr]); 
  771.                 
  772.                 if($clientes == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
  773.                 if($clientes == 83){$caminho='casf-corretora-apolice-diversos/';}
  774.                 if($clientes == 35){$caminho='pmecj-sp-saude/';}
  775.                 if($clientes == 107){$caminho='pmecj-sp-execucao-fiscal/';}
  776.                 if($clientes ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
  777.                 if($clientes ==  112){$caminho='saae-cartao-de-ponto/';}
  778.                 if($clientes ==  15){$caminho='cbsi-dossies/';}
  779.                 if($clientes ==  55){$caminho='casf-gerep-contratos-de-prestadores-de-saude-pj/';}
  780.                 if($clientes ==  13){$caminho='casa-de-saude-santa-maria-c-s-s.M/';}
  781.                 
  782.                 
  784.                 
  785.                 if ($assina==true) {
  786.                     $doc=$arr[$arrr];
  787.                     
  789.                     if ($version == '0') {
  790.                         $pdfnaoassinados[]=$nome;
  791.                         foreach ($pdfnaoassinados as $pdfnaoassinado) {
  792.                             $filename= $arr[$arrr];
  793.                         
  794.                     } 
  795.                         $arrr++;
  796.                     
  797.                    }
  798.                     if ($version == '1') {
  799.                     //Endereço do arquivo do certificado
  800.                     //Obs.: Tentei usar o certificado no formato PFX e não funcionou
  801.                     //Para converter use o comando no Prompt do Windows ou Terminal do Linux:
  802.                     //openssl pkcs12 -in certificado.pfx -out tcpdf.crt -nodes
  803.                     
  804.                     
  805.                     
  806.                     
  807.                     
  808.                     
  809.                         
  810.                     $cert = 'certicadoVR.crt';
  811.                     
  812.                     
  813.                     //Informações da assinatura - Preencha com os seus dados
  814.                     $info = array(
  815.                        'Name' => 'ARQUIVOS ORGANIZACÃO E GESTÃO DOCUMENTAL',
  816.                        'Location' => 'VOLTA REDONDA',
  817.                        'Reason' => '26157471000100',
  818.                        'ContactInfo' => 'www.arquivosdoc.com.br',
  819.                     );
  821.                     $pdf = new Fpdi();
  822.                     $pdf->SetAutoPageBreak(TRUE, -3);
  823.                     
  824.                   
  825.                     
  826.                     $numPages = $pdf->setSourceFile($pasta_user.$doc);
  827.                     
  828.                     $arrr++;     
  829.                      
  831.                     for ($i=1; $i <= $numPages; $i++) {
  832.                        
  833.                        #if ($i <= 2) {
  834.                          
  835.                        #}
  836.                         
  837.                         $tplId = $pdf->importPage($i);
  838.                         $s = $pdf->getTemplatesize($tplId);
  839.                         $pdf->AddPage($s['orientation'], $s);
  840.                         $pdf->useTemplate($tplId);
  841.                        
  842.                       }
  843.                     
  844.                   
  845.                     $pdf->setSignatureAppearance(160, 238, 40 ,40);
  846.                     $pdf->setSignature('file://'.$cert, 'file://'.realpath($cert), '123456','', 2, $info);
  848.                     
  849.                     if ($s['orientation'] == 'P') {
  850.                         $pdf->Image('/home/wwarqu/gedupload/public/img/removebg2.png',70, 230, 40 ,40 ,'PNG','https://verificador.staging.iti.br');
  851.                     }
  853.                     if ($s['orientation'] == 'L') {
  854.                        $pdf->Image('/home/wwarqu/gedupload/public/img/removebg2.png',70, 165, 40 ,40 ,'PNG','https://verificador.staging.iti.br');
  855.                     }
  859.                     $pdf->Output('/home/wwarqu/gedupload/public/'.$pasta_user.$filename, 'F');
  860.                     
  861.                     
  862.                     
  863.                     }
  865.                 }
  867.                 if ($assina==false) {
  868.                     $filename= $arr[$arrr];
  869.                     $arrr++;
  870.                 }
  871.             
  872.             
  873.                 
  875.             
  876.             
  877.             if(isset($element['Caixa'])){
  878.                             
  879.                     $caixa = $element['Caixa'];
  880.                     $entityManager = $doctrine->getManager();
  881.                     $queryBuilder = $entityManager->createQueryBuilder()
  882.                             ->select('caixa')
  883.                             ->from(Caixa::class, 'caixa')
  884.                             ->leftJoin('caixa.clientes', 'clientes')
  885.                             ->AndWhere('LOWER(caixa.nome) LIKE :caixa')->setParameter('caixa', '% '. $caixa)
  886.                             ->AndWhere('clientes.id = :cliente')->setParameter('cliente', $cliente->getId())
  887.                             ;  
  889.                             $caixarepo = $queryBuilder->getQuery()->getArrayResult();
  890.                             foreach($caixarepo as $cx){
  891.                                 $caixaid =  $cx['id'];
  892.                                 $caixarepo = $this->getDoctrine()->getRepository(Caixa::class);
  893.                                 $caixa = $caixarepo->find($caixaid);
  894.                                 
  895.                             }  
  897.                             $documento->setCaixa($caixa);
  898.                         }
  900.                     if($caixa != null)  {$documento = $entityManager->getRepository(Documento::class)->findOneBy(array('cliente'=>$cliente, 'caixa'=>$caixa, 'nome'=>$nome ));}
  901.                     if($caixa == null)  {$documento = $entityManager->getRepository(Documento::class)->findOneBy(array('cliente'=>$cliente,'nome'=>$nome ));}
  902.                 
  903.                    
  904.                 
  905.                       
  906.                     if($documento != null){
  907.                         $image=$documento->getImage();
  908.                         $image1=$documento->getAnexo();
  909.                         $image2=$documento->getAnexo1();
  910.                         $image3=$documento->getAnexo2();
  911.                         $image4=$documento->getAnexo3();
  912.                         $image5=$documento->getAnexo4();
  913.                         $image6=$documento->getAnexo5();
  914.                         $image7=$documento->getAnexo6();
  915.                         $image8=$documento->getAnexo7();
  916.                         $image9=$documento->getAnexo8();
  917.                          
  918.                       
  920.                     if($image == null ){
  922.                             $response = $clientS3->putObject(array(
  923.                             'Bucket' => "arquivosdoc",
  924.                             'Key'    => $caminho . $filename1,
  925.                             'SourceFile' => $pasta_user.$filename,
  926.                             'ContentDisposition'=>'inline',
  927.                             'ContentType'=>'application/pdf',
  928.                         ));
  929.                         
  930.                     
  931.                         
  932.                             $documento->setImage($filename1);
  933.                             $documento->setUser($user);
  934.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  935.                             $documento->setQtd1($num5);
  936.                             $qtd1=$documento->getQtd1();
  937.                             $qtd2=$documento->getQtd2();
  938.                             $qtd3=$documento->getQtd3();
  939.                             $qtd4=$documento->getQtd4();
  940.                             $qtd5=$documento->getQtd5();
  941.                             $qtd6=$documento->getQtd6();
  942.                             $qtd7=$documento->getQtd7();
  943.                             $qtd8=$documento->getQtd8();
  944.                             $qtd9=$documento->getQtd9();
  945.                             $qtd10=$documento->getQtd10();
  946.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  947.                              ;
  948.                            
  949.                             
  951.                                
  952.                            
  953.                             
  954.                         }
  956.                     if($image != null ){
  957.                       
  958.                             if($image1 == null ){
  959.                                
  960.                                 
  961.                                     
  962.                                         $response = $clientS3->putObject(array(
  963.                                          'Bucket' => "arquivosdoc",
  964.                                          'Key'    => $caminho . $filename1,
  965.                                          'SourceFile' =>$pasta_user.$filename,
  966.                                          'ContentDisposition'=>'inline',
  967.                                          'ContentType'=>'application/pdf',
  968.                                         ));
  969.                                    
  970.                                         $documento->setAnexo($filename1);
  971.                                         $documento->setQtd2($num5);
  972.                                         $documento->setUser($user);
  973.                                         $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  974.                                         $qtd1=$documento->getQtd1();
  975.                                         $qtd2=$documento->getQtd2();
  976.                                         $qtd3=$documento->getQtd3();
  977.                                         $qtd4=$documento->getQtd4();
  978.                                         $qtd5=$documento->getQtd5();
  979.                                         $qtd6=$documento->getQtd6();
  980.                                         $qtd7=$documento->getQtd7();
  981.                                         $qtd8=$documento->getQtd8();
  982.                                         $qtd9=$documento->getQtd9();
  983.                                         $qtd10=$documento->getQtd10();
  984.             
  985.                                         $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  986.                                         
  987.                                     
  988.                                
  989.     
  990.                             }
  991.                         
  993.                     }
  996.                     if($image1 != null ){
  997.                         if($image2 == null ){
  998.                           
  1000.                             $response = $clientS3->putObject(array(
  1001.                             'Bucket' => "arquivosdoc",
  1002.                             'Key'    => $caminho . $filename1,
  1003.                             'SourceFile' =>$pasta_user.$filename,
  1004.                             'ContentDisposition'=>'inline',
  1005.                             'ContentType'=>'application/pdf',
  1006.                         ));
  1007.                        
  1008.                             $documento->setAnexo1($filename1);
  1009.                             $documento->setQtd3($num5);
  1010.                             $documento->setUser($user);
  1011.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  1012.                             $qtd1=$documento->getQtd1();
  1013.                             $qtd2=$documento->getQtd2();
  1014.                             $qtd3=$documento->getQtd3();
  1015.                             $qtd4=$documento->getQtd4();
  1016.                             $qtd5=$documento->getQtd5();
  1017.                             $qtd6=$documento->getQtd6();
  1018.                             $qtd7=$documento->getQtd7();
  1019.                             $qtd8=$documento->getQtd8();
  1020.                             $qtd9=$documento->getQtd9();
  1021.                             $qtd10=$documento->getQtd10();
  1022.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  1023.                             
  1024.                         }
  1025.                         
  1026.                     }
  1028.                     if($image2 != null ){
  1029.                        if($image3 == null ){
  1030.                            
  1031.                           
  1032.                             $response = $clientS3->putObject(array(
  1033.                             'Bucket' => "arquivosdoc",
  1034.                             'Key'    => $caminho . $filename1,
  1035.                             'SourceFile' =>$pasta_user.$filename,
  1036.                             'ContentDisposition'=>'inline',
  1037.                             'ContentType'=>'application/pdf',
  1038.                         ));
  1039.                         
  1040.                             $documento->setAnexo2($filename1);
  1041.                             $documento->setQtd4($num5);
  1042.                             $documento->setUser($user);
  1043.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  1044.                             $qtd1=$documento->getQtd1();
  1045.                             $qtd2=$documento->getQtd2();
  1046.                             $qtd3=$documento->getQtd3();
  1047.                             $qtd4=$documento->getQtd4();
  1048.                             $qtd5=$documento->getQtd5();
  1049.                             $qtd6=$documento->getQtd6();
  1050.                             $qtd7=$documento->getQtd7();
  1051.                             $qtd8=$documento->getQtd8();
  1052.                             $qtd9=$documento->getQtd9();
  1053.                             $qtd10=$documento->getQtd10();
  1054.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  1055.                     }
  1056.                         
  1057.                         
  1058.                     }
  1060.                     if($image3 != null ){
  1061.                         
  1062.                         if($image4 == null ){
  1063.                             
  1064.                            
  1066.                             $response = $clientS3->putObject(array(
  1067.                             'Bucket' => "arquivosdoc",
  1068.                             'Key'    => $caminho . $filename1,
  1069.                             'SourceFile' => $pasta_user.$filename,
  1070.                             'ContentDisposition'=>'inline',
  1071.                             'ContentType'=>'application/pdf',
  1072.                         ));
  1074.                             $documento->setAnexo3($filename1);
  1075.                             $documento->setQtd5($num5);
  1076.                             $documento->setUser($user);
  1077.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  1078.                             $qtd1=$documento->getQtd1();
  1079.                             $qtd2=$documento->getQtd2();
  1080.                             $qtd3=$documento->getQtd3();
  1081.                             $qtd4=$documento->getQtd4();
  1082.                             $qtd5=$documento->getQtd5();
  1083.                             $qtd6=$documento->getQtd6();
  1084.                             $qtd7=$documento->getQtd7();
  1085.                             $qtd8=$documento->getQtd8();
  1086.                             $qtd9=$documento->getQtd9();
  1087.                             $qtd10=$documento->getQtd10();
  1088.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  1089.                             
  1090.                             }
  1091.                         
  1092.                     }
  1094.                     if($image4 != null ){
  1095.                         if($image5 == null ){
  1096.                             
  1097.                            
  1099.                             $response = $clientS3->putObject(array(
  1100.                             'Bucket' => "arquivosdoc",
  1101.                             'Key'    => $caminho . $filename1,
  1102.                             'SourceFile' =>$pasta_user.$filename,
  1103.                             'ContentDisposition'=>'inline',
  1104.                             'ContentType'=>'application/pdf',
  1105.                         ));
  1106.                            
  1107.                             $documento->setAnexo4($filename1);
  1108.                             $documento->setQtd6($num5);
  1109.                             $documento->setUser($user);
  1110.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  1111.                             $qtd1=$documento->getQtd1();
  1112.                             $qtd2=$documento->getQtd2();
  1113.                             $qtd3=$documento->getQtd3();
  1114.                             $qtd4=$documento->getQtd4();
  1115.                             $qtd5=$documento->getQtd5();
  1116.                             $qtd6=$documento->getQtd6();
  1117.                             $qtd7=$documento->getQtd7();
  1118.                             $qtd8=$documento->getQtd8();
  1119.                             $qtd9=$documento->getQtd9();
  1120.                             $qtd10=$documento->getQtd10();
  1121.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  1122.                         }
  1123.                         
  1124.                     }
  1125.                         
  1126.                            
  1127.                     if($image5 != null ){
  1128.                         if($image6 == null ){ 
  1129.                             
  1130.                           
  1132.                             $response = $clientS3->putObject(array(
  1133.                             'Bucket' => "arquivosdoc",
  1134.                             'Key'    => $caminho . $filename1,
  1135.                             'SourceFile' =>$pasta_user.$filename,
  1136.                             'ContentDisposition'=>'inline',
  1137.                             'ContentType'=>'application/pdf',
  1138.                         ));      
  1139.                             $documento->setAnexo5($filename1);
  1140.                             $documento->setQtd7($num5);
  1141.                             $documento->setUser($user);
  1142.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  1143.                             $qtd1=$documento->getQtd1();
  1144.                             $qtd2=$documento->getQtd2();
  1145.                             $qtd3=$documento->getQtd3();
  1146.                             $qtd4=$documento->getQtd4();
  1147.                             $qtd5=$documento->getQtd5();
  1148.                             $qtd6=$documento->getQtd6();
  1149.                             $qtd7=$documento->getQtd7();
  1150.                             $qtd8=$documento->getQtd8();
  1151.                             $qtd9=$documento->getQtd9();
  1152.                             $qtd10=$documento->getQtd10();
  1153.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  1154.                         }    
  1155.                         
  1156.                     } 
  1158.                     if($image6 != null ){
  1159.                         if($image7 == null ){
  1160.                             
  1161.                            
  1163.                             $response = $clientS3->putObject(array(
  1164.                             'Bucket' => "arquivosdoc",
  1165.                             'Key'    => $caminho . $filename1,
  1166.                             'SourceFile' => $pasta_user.$filename,
  1167.                             'ContentDisposition'=>'inline',
  1168.                             'ContentType'=>'application/pdf',
  1169.                         ));
  1170.                             $documento->setAnexo6($filename1);
  1171.                             $documento->setQtd8($num5);
  1172.                             $documento->setUser($user);
  1173.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  1174.                             $qtd1=$documento->getQtd1();
  1175.                             $qtd2=$documento->getQtd2();
  1176.                             $qtd3=$documento->getQtd3();
  1177.                             $qtd4=$documento->getQtd4();
  1178.                             $qtd5=$documento->getQtd5();
  1179.                             $qtd6=$documento->getQtd6();
  1180.                             $qtd7=$documento->getQtd7();
  1181.                             $qtd8=$documento->getQtd8();
  1182.                             $qtd9=$documento->getQtd9();
  1183.                             $qtd10=$documento->getQtd10();
  1184.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  1185.                         }
  1186.                         
  1187.                     }
  1190.                       if($image7 != null ){
  1191.                         if($image8 == null ){
  1192.                             
  1193.                            
  1194.                             
  1195.                             $response = $clientS3->putObject(array(
  1196.                             'Bucket' => "arquivosdoc",
  1197.                             'Key'    => $caminho . $filename1,
  1198.                             'SourceFile' => $pasta_user.$filename,
  1199.                             'ContentDisposition'=>'inline',
  1200.                             'ContentType'=>'application/pdf',
  1201.                         ));
  1203.                             $documento->setAnexo7($filename1);
  1204.                             $documento->setQtd9($num5);
  1205.                             $documento->setUser($user);
  1206.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  1207.                             $qtd1=$documento->getQtd1();
  1208.                             $qtd2=$documento->getQtd2();
  1209.                             $qtd3=$documento->getQtd3();
  1210.                             $qtd4=$documento->getQtd4();
  1211.                             $qtd5=$documento->getQtd5();
  1212.                             $qtd6=$documento->getQtd6();
  1213.                             $qtd7=$documento->getQtd7();
  1214.                             $qtd8=$documento->getQtd8();
  1215.                             $qtd9=$documento->getQtd9();
  1216.                             $qtd10=$documento->getQtd10();
  1217.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  1218.                         }    
  1219.                             
  1220.                     }
  1223.                     if($image8 != null ){
  1224.                         if($image9 == null ){
  1225.                             
  1226.                             
  1227.                             
  1228.                             $response = $clientS3->putObject(array(
  1229.                             'Bucket' => "arquivosdoc",
  1230.                             'Key'    => $caminho . $filename1,
  1231.                             'SourceFile' => $pasta_user.$filename,
  1232.                             'ContentDisposition'=>'inline',
  1233.                             'ContentType'=>'application/pdf',
  1234.                         ));
  1236.                             $documento->setAnexo8($filename1);
  1237.                             $documento->setQtd10($num5);
  1238.                             $documento->setUser($user);
  1239.                             $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  1240.                             $qtd1=$documento->getQtd1();
  1241.                             $qtd2=$documento->getQtd2();
  1242.                             $qtd3=$documento->getQtd3();
  1243.                             $qtd4=$documento->getQtd4();
  1244.                             $qtd5=$documento->getQtd5();
  1245.                             $qtd6=$documento->getQtd6();
  1246.                             $qtd7=$documento->getQtd7();
  1247.                             $qtd8=$documento->getQtd8();
  1248.                             $qtd9=$documento->getQtd9();
  1249.                             $qtd10=$documento->getQtd10();
  1250.                             $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  1251.                         }
  1252.                         
  1253.                     }   
  1256.                     if($image9 != null ){
  1257.                         
  1258.                         
  1260.                         $response = $clientS3->putObject(array(
  1261.                             'Bucket' => "arquivosdoc",
  1262.                             'Key'    => $caminho . $filename1,
  1263.                             'SourceFile' => $pasta_user.$filename,
  1264.                             'ContentDisposition'=>'inline',
  1265.                             'ContentType'=>'application/pdf',
  1266.                         ));
  1267.                          echo '<script>alert("Todos os anexos cheios , anexos 10 foi substituido!")</script>';
  1268.                          $documento->setAnexo8($filename1);
  1269.                          $documento->setQtd10($num5);
  1270.                          $documento->setUser($user);
  1271.                          $documento->setUpdatedAt(new \DateTime('America/Sao_Paulo'));
  1272.                          $qtd1=$documento->getQtd1();
  1273.                          $qtd2=$documento->getQtd2();
  1274.                          $qtd3=$documento->getQtd3();
  1275.                          $qtd4=$documento->getQtd4();
  1276.                          $qtd5=$documento->getQtd5();
  1277.                          $qtd6=$documento->getQtd6();
  1278.                          $qtd7=$documento->getQtd7();
  1279.                          $qtd8=$documento->getQtd8();
  1280.                          $qtd9=$documento->getQtd9();
  1281.                          $qtd10=$documento->getQtd10();
  1282.                          $documento->setQtd($qtd1+$qtd2+$qtd3+$qtd4+$qtd5+$qtd6+$qtd7+$qtd8+$qtd9+$qtd10);
  1283.                        
  1284.                     
  1285.                         
  1286.                         
  1287.                     } 
  1288.                     
  1289.                   
  1290.  
  1291.                             
  1292.                   
  1293.         
  1294.                          
  1295.                 }
  1296.                         
  1297.                      
  1298.                     
  1299.                     
  1300.                     else
  1301.                         array_push($noFound, $nome);
  1302.                 } 
  1303.                 $entityManager->flush();
  1304.                 if($noFound != null){
  1306.                   if($pdfnaoassinados != null){
  1307.                      echo '<script>alert("A assinatura de  '.implode(", ", $pdfnaoassinados).'  *  infelizmeente não foi possivel validar porque a versão do pdf se encontra acima da versão 1.4, que não é permitida pelo nosso assinador até momento.")</script>';}
  1310.                     echo '<script>alert("Importação não Concluída! '
  1311.                     . implode(", ", $noFound). ' não encontrado(s). '.'")</script>';
  1312.                 
  1314.                 
  1315.                 
  1317.                 }else{
  1318.                     
  1319.                      if($pdfnaoassinados != null){
  1320.                      echo '<script>alert("A assinatura de  '.implode(", ", $pdfnaoassinados).'  *  infelizmeente não foi possivel validar porque a versão do pdf se encontra acima da versão 1.4, que não é permitida pelo nosso assinador até momento.")</script>';}
  1321.                     
  1322.                     echo '<script>alert("Importação  Concluída.")</script>';
  1323.                     
  1324.                    
  1325.                 }
  1327.                 
  1330.                
  1331.             }
  1332.         
  1333.         }    
  1335.         $mascara= $pasta_user."*.pdf";
  1336.         array_map( "unlink", glob( $mascara) );
  1337.         if (file_exists($usersss)) {
  1338.             rmdir($usersss);
  1339.         }
  1340.         return $this->render('cadastro/index.html.twig', array(
  1341.             'form' => $form->createView(),
  1342.             
  1343.         ));
  1344.     }
  1345.     
  1346.       /**
  1347.      * @Route("/Cadastro/{setor}/{usuario}", name="app_cadastro_pmcj")
  1348.      */
  1349.     public function indexpmcj(ManagerRegistry $doctrine,EntityManagerInterface $entityManager,$setor,$usuario,Request $request): Response
  1350.     {
  1351.        
  1353.         $dotenv = new Dotenv();
  1354.         $dotenv->load(__DIR__.'/.env');
  1355.         $clientS3 = new  S3Client([
  1356.                         'region'  => 'sa-east-1',
  1357.                         'version' => 'latest',
  1358.                         'credentials' => [
  1359.                         'key'    =>$_ENV["AWS_KEY"],
  1360.                         'secret' => $_ENV["AWS_SECRET"], 
  1361.                         ]
  1362.                     ]);
  1363.         $erro ='';
  1364.         $p='';
  1365.         $user = $doctrine->getRepository(User::class)->find($usuario);
  1366.         $user_nome = $user->getNome();
  1367.         $usersss_id = $user->getId();
  1368.         $pasta_user=$user_nome.'/';
  1369.         $classifica = $doctrine->getRepository(Classificacao::class)->findBy(['cliente' => $setor]);
  1370.         $tips = $doctrine->getRepository(Tipo::class)->findBy(['cliente' => $setor]);
  1371.         $clientearr = $doctrine->getRepository(Cliente::class)->find($setor);
  1372.         $caixass = $clientearr->getCaixas(); 
  1373.         $clie_nome = $clientearr->getNome();
  1374.         $clie_id = $clientearr->getId();
  1375.         $categoria = $doctrine->getRepository(Categoria::class)->findAll();
  1376.        
  1377.         $arr = [];
  1378.         $arrr=0;
  1379.         $qtd = [];
  1380.         $image= [];
  1381.        
  1382.         if(isset($_POST["botao"]))
  1383.         {
  1384.             
  1385.             $nome = $_POST["nome"];
  1386.             $assunto = $_POST["assunto"];
  1387.             $caixas  =  $_POST["caixas"];
  1388.             $tipos = $_POST["tipos"];
  1389.             $dateD =  $_POST["dateD"];
  1390.             $dateV   =  $_POST["dateV"];
  1391.             $text_ = $_POST["text"];
  1392.             $desc_ = $_POST["desc"];
  1393.             
  1394.            
  1395.              
  1396.                     
  1397.             if($clie_id == 14){$caminho='cartorio-1deg-oficio-de-volta-redonda-rj/';}
  1398.             if($clie_id == 83){$caminho='casf-corretora-apolice-diversos/';}
  1399.             if($clie_id == 35){$caminho='pmecj-sp-saude/';}
  1400.             if($clie_id == 107){$caminho='pmecj-sp-execucao-fiscal/';}
  1401.             if($clie_id ==  4){$caminho='cartorio-souza-reis-barra-mansa/';}
  1402.             if($clie_id ==  112){$caminho='saae-cartao-de-ponto/';}
  1403.             if($clie_id ==  15){$caminho='cbsi-dossies/';}
  1404.             if($clie_id ==  118){$caminho='camara-municipal-de-angra-dos-reis/';}
  1405.             
  1406.             
  1407.             $text  = preg_replace( "/\r|\n/", "  ", $text_);
  1408.             $desc  = preg_replace( "/\r|\n/", "  ", $desc_ );
  1409.             
  1410.             
  1411.             
  1412.             
  1413.             $textr='';
  1414.             $dateDr='';
  1415.             $dateVr='';
  1416.             $cliente = $doctrine->getRepository(Cliente::class)->find($setor);
  1417.             
  1418.             $user = $doctrine->getRepository(User::class)->find($usuario);
  1419.             if ($caixas != null){
  1420.                 
  1421.                 $caixa = $doctrine->getRepository(Caixa::class)->find($caixas);
  1422.                 $nome_caixa= $caixa->getNome();
  1423.             }
  1424.             $class = $doctrine->getRepository(Classificacao::class)->find(1);
  1425.             $cates = $doctrine->getRepository(Categoria::class)->find(1);
  1426.             $tipo = $doctrine->getRepository(Tipo::class)->find($tipos);
  1427.     
  1428.             $registro = new Documento();
  1429.             $registro->setNome($nome);
  1430.             $registro->setAssunto($assunto);
  1431.             $registro->setCliente($cliente);
  1432.             $registro->setUser($user);
  1433.             if ($caixas != null){
  1434.                 $registro->setCaixa($caixa);
  1435.             }
  1436.             $registro->setClassificacao($class);
  1437.             $registro->setCategoria($cates);
  1438.             $registro->setTipo($tipo);
  1439.             $registro->setUser($user);
  1440.             $registro->setKeywords($text);
  1441.             $registro->setExtraFields($desc);
  1443.         
  1444.            // PDF
  1445.             $files = $_FILES['file']['tmp_name'];
  1446.           
  1447.            
  1448.             $umlautString = $clie_nome;
  1449.             $slugger = new AsciiSlugger();
  1450.             $teste=$slugger->slug($umlautString, $seperator = '-')->toString();
  1451.             $caminho = strtolower ($teste.'/');
  1452.             if (file_exists($user_nome)) {
  1453.                     
  1454.             }
  1455.             
  1456.             else{
  1457.              mkdir($pasta_user, 0777, true);
  1458.             }
  1459.            
  1461.             $total_count = is_countable( $files ) ? count( $files ) : 0;
  1462.             for( $i=0 ; $i < $total_count ; $i++  ) { 
  1464.                
  1465.                 $tmpFilePath =  $_FILES['file']['tmp_name'][$i];
  1466.                 $nomes = $i . '.pdf';
  1467.                 move_uploaded_file($tmpFilePath,$pasta_user.$nomes);
  1468.                 $arr[] = $nomes;
  1469.             
  1471.             }
  1474.             
  1475.             
  1476.         foreach ($files as $file) {
  1478.                 $uuid = Uuid::v4();
  1479.                 $filename= $uuid.'.pdf';
  1480.                 $imagick = new \Imagick();
  1481.                 $imagick->pingImage($pasta_user.$arr[$arrr]);
  1482.                 $num5= $imagick->getNumberImages();
  1483.                 
  1484.                 $doc=$arr[$arrr];
  1485.              
  1486.                 
  1487.           
  1488.                 
  1489.                 $arrr++;
  1490.                 
  1491.                 $cert = 'certicadoVR.crt';
  1492.                 
  1493.                 
  1494.                 //Informações da assinatura - Preencha com os seus dados
  1495.                 $info = array(
  1496.                    'Name' => 'ARQUIVOS ORGANIZACÃO E GESTÃO DOCUMENTAL',
  1497.                    'Location' => 'VOLTA REDONDA',
  1498.                    'Reason' => '26157471000100',
  1499.                    'ContactInfo' => 'www.arquivosdoc.com.br',
  1500.                 );
  1502.                 $pdf = new Fpdi();
  1503.                 $pdf->SetAutoPageBreak(TRUE, -3);
  1504.                 
  1505.               
  1506.                 
  1507.                 $numPages = $pdf->setSourceFile($pasta_user.$doc);
  1508.                 
  1509.                  
  1510.                  
  1512.                 for ($i=1; $i <= $numPages; $i++) {
  1513.              
  1514.                     
  1515.                     $tplId = $pdf->importPage($i);
  1516.                     $s = $pdf->getTemplatesize($tplId);
  1517.                     $pdf->AddPage($s['orientation'], $s);
  1518.                     $pdf->useTemplate($tplId);
  1519.                    
  1520.                   }
  1521.                 
  1522.               
  1523.                 $pdf->setSignatureAppearance(160, 238, 40 ,40);
  1524.                 $pdf->setSignature('file://'.$cert, 'file://'.realpath($cert), '123456','', 2, $info);
  1526.                 
  1527.                 if ($s['orientation'] == 'P') {
  1528.                     $pdf->Image('/home/wwarqu/gedupload/public/img/removebg2.png',70, 230, 40 ,40 ,'PNG','https://verificador.staging.iti.br');
  1529.                 }
  1531.                 if ($s['orientation'] == 'L') {
  1532.                    $pdf->Image('/home/wwarqu/gedupload/public/img/removebg2.png',70, 165, 40 ,40 ,'PNG','https://verificador.staging.iti.br');
  1533.                 }
  1537.                 $pdf->Output('/home/wwarqu/gedupload/public/'.$pasta_user.$filename, 'F');
  1538.                 
  1539.                 
  1540.        
  1541.                
  1542.                 $response = $clientS3->putObject(array(
  1543.                     'Bucket' => "arquivosdoc",
  1544.                     'Key'    => $caminho . $filename,
  1545.                     'SourceFile' => $pasta_user.$filename,
  1546.                     'ContentDisposition'=>'inline',
  1547.                     'ContentType'=>'application/pdf'
  1548.                 ));
  1550.                 $qtd[] = $num5;
  1551.                 $image[] = $filename;
  1552.             }
  1553.        
  1554.         
  1555.          if (isset($image[0])) {$registro->setImage($image[0]);}
  1556.          if (isset($image[1])) {$registro->setAnexo($image[1]);}
  1557.          if (isset($image[2])) {$registro->setAnexo1($image[2]);}
  1558.          if (isset($image[3])) {$registro->setAnexo2($image[3]);}
  1559.          if (isset($image[4])) {$registro->setAnexo3($image[4]);}
  1560.          if (isset($image[5])) {$registro->setAnexo4($image[5]);}
  1561.          if (isset($image[6])) {$registro->setAnexo5($image[6]);}
  1562.          if (isset($image[7])) {$registro->setAnexo6($image[7]);}
  1563.          if (isset($image[8])) {$registro->setAnexo7($image[8]);}
  1564.          if (isset($image[9])) {$registro->setAnexo8($image[9]);}
  1565.          
  1566.          if (isset($qtd[0])) {$registro->setQtd1($qtd[0]);}
  1567.          if (isset($qtd[1])) {$registro->setQtd2($qtd[1]);}
  1568.          if (isset($qtd[2])) {$registro->setQtd3($qtd[2]);}
  1569.          if (isset($qtd[3])) {$registro->setQtd4($qtd[3]);}
  1570.          if (isset($qtd[4])) {$registro->setQtd5($qtd[4]);}
  1571.          if (isset($qtd[5])) {$registro->setQtd6($qtd[5]);}
  1572.          if (isset($qtd[6])) {$registro->setQtd7($qtd[6]);}
  1573.          if (isset($qtd[7])) {$registro->setQtd8($qtd[7]);}
  1574.          if (isset($qtd[8])) {$registro->setQtd9($qtd[8]);}
  1575.          if (isset($qtd[9])) {$registro->setQtd10($qtd[9]);}
  1576.          
  1577.          $registro->setQtd(array_sum($qtd));
  1578.          
  1579.          
  1580.         
  1581.         
  1582.         
  1583.         
  1584.         
  1585.         
  1586.         
  1587.         
  1588.         if ($dateD != '') {
  1590.         $registro->setDataDocumento(new \DateTime($dateD));
  1591.         $dateDr=$dateD;
  1592.             
  1593.         
  1594.         }
  1595.         if ($dateV != '') {
  1596.         
  1597.         $registro->setVencimentoDocumento(new \DateTime ($dateV));
  1598.         $dateVr=$dateV;
  1600.         }
  1601.         
  1602.         $registro->setExtraFields($desc);
  1603.         $entityManager->persist($registro);
  1604.         $entityManager->flush();
  1606.        
  1607.         $registros = new Registro();
  1608.         $registros->setOperacao('Documento feito pelo formulario com Assinador');
  1609.         $registros->setData(new \DateTime('America/Sao_Paulo'));
  1610.         $registros->setCliente($cliente);
  1611.         $registros->setUser($user);
  1612.         $entityManager->persist($registros);
  1613.         $entityManager->flush();
  1614.         #$erro  = 'ok';
  1615.         #$p=$nome_caixa.'   cadastrada com sucesso';
  1616.         
  1617.         echo '<script>alert("Cadastrado  Concluído!")</script>';
  1618.         return $this->render('cadastro/indexpmcj.html.twig',  array(
  1619.                     'user'=>$user,
  1620.                     'caixass' => $caixass,
  1621.                     'classifica' => $classifica ,
  1622.                     'tips' => $tips,
  1623.                     'categoria'=>$categoria,
  1624.                     'erro'=>$erro ,
  1625.                     'p'=>$p,
  1626.                     'setor'=>$setor,
  1627.                     'usuario'=>$usuario
  1628.                     
  1629.                     
  1630.             
  1631.             
  1632.         ));            
  1633.                     
  1634.             
  1635.    
  1637.         
  1638.         }
  1640.        
  1641.         return $this->render('cadastro/indexpmcj.html.twig',  array(
  1642.                     'user'=>$user,
  1643.                     'caixass' => $caixass,
  1644.                     'classifica' => $classifica ,
  1645.                     'tips' => $tips,
  1646.                     'categoria'=>$categoria,
  1647.                     'erro'=>$erro ,
  1648.                     'p'=>$p,
  1649.                     'setor'=>$setor,
  1650.                     'usuario'=>$usuario
  1651.                     
  1652.                     
  1653.             
  1654.             
  1655.         ));
  1656.     }
  1657.      /**
  1658.      * @Route("/assinador", name="assinador")
  1659.      */
  1660.     public function assinador(Request $request,ManagerRegistry $doctrine, EntityManagerInterface $entityManager): Response
  1661.     {
  1662.         $uuid  = Uuid::v4();
  1663.         $dt_hj = new \DateTimeImmutable('America/Sao_Paulo');
  1664.         $dt_hj_formt = $dt_hj->format('d-m-Y h.i.s');
  1665.         $motivo = '';
  1666.         $error = '';
  1667.         $pasta_user= $uuid.'/';
  1668.         $arr = [];
  1669.         $arrr=0;
  1670.         $r=0;
  1671.         $filesNames  = 'Assinados_'.$dt_hj_formt.'.zip';
  1672.         $path      = $pasta_user ;
  1673.         $fullPath  = $path.$filesNames;
  1675.       
  1677.         if(isset($_FILES['file'])){
  1678.             
  1679.             
  1680.             $files = $_FILES['file']['name'];
  1681.           
  1682.             mkdir($pasta_user, 0777, true);
  1683.         
  1684.             
  1686.                 $total_count = is_countable( $files ) ? count( $files ) : 0;
  1687.                 for( $i=0 ; $i < $total_count ; $i++  ) { 
  1689.                 
  1690.                     $tmpFilePath =  $_FILES['file']['tmp_name'][$i];
  1691.                     $nomes = $_FILES['file']['name'][$i];
  1692.                     move_uploaded_file($tmpFilePath,$pasta_user.$nomes);
  1693.                     $arr[] = $nomes;
  1694.                 
  1696.                 }
  1697.                 foreach ($files as $file) {
  1698.                
  1699.                     $r = $r + 1 ;
  1700.                     $filename = $file;
  1702.                     $doc=$arr[$arrr];
  1703.                        
  1705.                     $cert = 'certicadoVR.crt';
  1706.                     
  1707.                     
  1708.                     $info = array(
  1709.                        'Name' => 'ARQUIVOS ORGANIZACÃO E GESTÃO DOCUMENTAL',
  1710.                        'Location' => 'VOLTA REDONDA',
  1711.                        'Reason' => '26157471000100',
  1712.                        'ContactInfo' => 'www.arquivosdoc.com.br',
  1713.                     );
  1715.                     $pdf = new Fpdi();
  1716.                     $pdf->SetAutoPageBreak(TRUE, -3);
  1717.                     
  1718.                   
  1719.                     
  1720.                     $numPages = $pdf->setSourceFile($pasta_user.$doc);
  1721.                     
  1722.                     $arrr++;     
  1723.                      
  1725.                 for ($i=1; $i <= $numPages; $i++) {
  1726.                        
  1727.                   
  1728.                         $tplId = $pdf->importPage($i);
  1729.                         $s = $pdf->getTemplatesize($tplId);
  1730.                         $pdf->AddPage($s['orientation'], $s);
  1731.                         $pdf->useTemplate($tplId);
  1732.                        
  1733.                       
  1734.                 }
  1735.                   
  1736.                     $pdf->setSignatureAppearance(160, 238, 40 ,40);
  1737.                     $pdf->setSignature('file://'.$cert, 'file://'.realpath($cert), '123456','', 2, $info);
  1739.                     
  1740.                     if ($s['orientation'] == 'P') {
  1741.                         $pdf->Image('/home/wwarqu/gedupload/public/img/removebg2.png',70, 230, 40 ,40 ,'PNG','https://verificador.staging.iti.br');
  1742.                     }
  1744.                     if ($s['orientation'] == 'L') {
  1745.                        $pdf->Image('/home/wwarqu/gedupload/public/img/removebg2.png',70, 165, 40 ,40 ,'PNG','https://verificador.staging.iti.br');
  1746.                     }
  1750.                     $pdf->Output('/home/wwarqu/gedupload/public/'.$pasta_user.$filename, 'F');
  1752.                     
  1753.                          
  1754.                 }
  1756.                
  1757.                 
  1759.                 $scanDir = scandir($path);
  1760.                 
  1761.                 array_shift($scanDir);
  1762.                 array_shift($scanDir);
  1763.                 $zip = new \ZipArchive();
  1765.                 if ($zip->open($fullPath, \ZipArchive::CREATE) ) {
  1767.                     foreach($scanDir as $file){
  1768.                         $zip->addFile($path.'/'.$file, $file);
  1769.                     }
  1770.                     $zip->close();
  1771.                 }
  1773.                 $mascara= $path."*.pdf";
  1774.                 array_map( "unlink", glob($mascara) );
  1775.                 $motivo = 'ATRASO';
  1777.                 if ($r == 1 ) {
  1778.                     $error = $r.' Arquivo foi assinado com sucesso!';
  1779.                 }
  1781.                 if ($r > 1 ) {
  1782.                     $error = $r.'  Arquivos foi assinados com sucesso!';
  1783.                 }
  1787.                 
  1788.                
  1789.             }
  1790.                 
  1791.          
  1792.         
  1793.             
  1794.         if(isset($_POST['baixar'])){
  1795.                 
  1796.                $response = new BinaryFileResponse($_POST['baixar']);
  1797.                 $response->setContentDisposition(
  1798.                     ResponseHeaderBag::DISPOSITION_ATTACHMENT,
  1799.                     $filesNames
  1800.                 );
  1801.                 return $response;
  1803.             }
  1805.         if(isset($_POST['novo'])){
  1806.             unlink($_POST['novo']);   
  1807.             if (file_exists($_POST['path'])) {
  1808.                      
  1809.                 rmdir($_POST['path']);
  1810.             }
  1812.              return $this->redirectToRoute('assinador');
  1813.         }
  1814.         
  1815.             
  1816.             return $this->render('cadastro/assinador.html.twig',array(
  1817.         
  1818.                     'motivo'=>$motivo,
  1819.                     'error'=> $error,
  1820.                     'fullPath' => $fullPath,
  1821.                     'path' => $path
  1822.             
  1823.              
  1825.         ));       
  1827.     }
  1828. }