src/Controller/OrderController.php line 92

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Company;
  6. use App\Entity\CompanyAddress;
  7. use App\Entity\Order;
  8. use App\Entity\OrderMessage;
  9. use App\Entity\Part;
  10. use App\Entity\Supplier;
  11. use App\Entity\User;
  12. use App\Entity\CompanySupplier;
  13. use App\Form\OrderSearchType;
  14. use App\Form\OrderType;
  15. use App\Form\OrderSupplierType;
  16. use App\Form\OrderBudgetType;
  17. use App\Repository\OrderRepository;
  18. use App\Security\Voter\OrderVoter;
  19. use Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException;
  20. use Doctrine\DBAL\Exception\UniqueConstraintViolationException;
  21. use Knp\Component\Pager\PaginatorInterface;
  22. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  23. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  24. use Symfony\Component\HttpFoundation\Request;
  25. use Symfony\Component\HttpFoundation\Response;
  26. use Symfony\Component\HttpFoundation\JsonResponse;
  27. use Symfony\Component\Mailer\MailerInterface;
  28. use Symfony\Component\Mime\Address;
  29. use Symfony\Component\Routing\Annotation\Route;
  30. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  31. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  32. use Symfony\Component\HttpFoundation\StreamedResponse;
  33. use Symfony\Contracts\Translation\TranslatorInterface;
  34. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  35. use Knp\Snappy\Pdf;
  36. use Knp\Bundle\SnappyBundle\Snappy\Response\PdfResponse;
  37. use App\Service\UtilService;
  38. use App\Service\OrderService;
  39. use App\Service\PartService;
  40. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  41. use Symfony\Component\Filesystem\Exception\IOExceptionInterface;
  42. use Symfony\Component\Filesystem\Filesystem;
  43. use Symfony\Component\String\Slugger\AsciiSlugger;
  44. use Doctrine\Persistence\ManagerRegistry;
  45. use App\Service\EncryptDecryptService;
  48. /**
  49.  * @Route({"en": "/order",
  50.  *          "es": "/orden"})
  51.  */
  52. class OrderController extends AbstractController
  53. {
  54.     private $emailApp;
  55.     public const PAGE_ELEMENTS = 25;
  56.     private $translator;
  57.     private $orderRepository;
  58.     private $util;
  59.     private $pdf;
  60.     private $orderService;
  61.     private $partService;    
  62.     private $em;
  63.     private $partDir;
  65.     public function __construct(
  66.         string $emailApp, 
  67.         TranslatorInterface $translator,
  68.         OrderRepository $orderRepository, 
  69.         UtilService $utilService, 
  70.         OrderService $orderService, 
  71.         PartService $partService, 
  72.         Pdf $knpSnappyPdf,
  73.         ManagerRegistry $doctrine,
  74.         string $partDir,
  75.         private EncryptDecryptService $encryptDecryptService)
  76.     {
  77.         $this->emailApp = $emailApp;
  78.         $this->translator = $translator;
  79.         $this->util = $utilService;
  80.         $this->pdf = $knpSnappyPdf;
  81.         $this->orderRepository = $orderRepository;
  82.         $this->orderService = $orderService;
  83.         $this->partService = $partService;
  84.         $this->em = $doctrine->getManager();
  85.         $this->partDir = $partDir;
  86.     }
  88.     /**
  89.      * @Route({"en": "/list",
  90.      *         "es": "/listado"}, name="order_index", methods={"GET","POST"})
  91.      */
  92.     public function index(Request $request, OrderRepository $orderRepository, PaginatorInterface $paginator): Response
  93.     {
  94.         $admin =$this->getUser();
  95.         $ms = $this->util->getLicenseField($admin->getCompany(),'multi_select') && $admin->getRole()!='ROLE_CLIENT';
  97.         if($admin == NULL){
  98.             return $this->redirectToRoute('app_login');
  99.         }
  101.         $search = [];
  102.         $form = $this->createForm(OrderSearchType::class, $search, ['user_admin' => $admin,'method' => 'GET']);
  103.         $form->handleRequest($request);
  104.         $orderBy = null;
  105.         $filters = [
  106.             ['field'=>'company','title'=>'Empresa'],
  107.             ['field'=>'ref','title'=>'Referencia'],
  108.             ['field'=>'part','title'=>'Pieza'],
  109.             ['field'=>'supplier','title'=>'Centro de trabajo'],
  110.             ['field'=>'units','title'=>'Unidades'],
  111.             ['field'=>'updated_at','title'=>'Última modificación'],
  112.             ['field'=>'state','title'=>'Estado']
  113.         ];
  115.         if ($form->isSubmitted() && $form->isValid())
  116.         {        
  117.             $orderBy = $request->query->get('order_by');
  118.             $orders = $orderRepository->findByName($form->getData(), $admin, $orderBy);   
  120.         } else {
  121.             $orders = $orderRepository->buscarTodos($admin);
  122.         }       
  124.         if($request->isMethod('POST')){
  126.             if($request->request->get('orders_delete')){
  127.                 $delIds = $request->request->get('delIds',null);
  129.                 if($delIds){
  130.                     $orders = explode(',', $delIds);
  131.                     $successMsg = '';
  132.                     $errorMsg = ''; 
  133.                     foreach($orders as $orderId){
  134.                         $order = $this->em->getRepository(Order::class)->find($orderId);
  135.                         if($order){
  136.                             $rmOrder = $this->rmOrder($order);
  137.                             if($rmOrder['error']){
  138.                                 $errorMsg.= $this->translator->trans('Error orden {ref} : ',['{ref}'=>$order->getRef()]) . $rmOrder['msg'].'<br>';
  139.                             }
  140.                             else{
  141.                                 $successMsg.= $this->translator->trans('Orden {ref} eliminada correctamente',['{ref}'=>$order->getRef()]).'<br>';
  142.                             }
  143.                         }
  144.                     }
  146.                     if($successMsg){
  147.                         $this->addFlash('success', $successMsg);
  148.                     }
  150.                     if($errorMsg){
  151.                         $this->addFlash('danger', $successMsg);
  152.                     }
  154.                     return $this->redirectToRoute('order_index');
  155.                 }
  156.             }
  157.         }
  158.         
  159.         // Creating pagnination
  160.         $pagination = $paginator->paginate(
  161.             $orders,
  162.             $request->query->getInt('page', 1),
  163.             self::PAGE_ELEMENTS
  164.         );
  166.         return $this->render('order/index.html.twig', [
  167.             'pagination' => $pagination,
  168.             'search_form' => $form->createView(),
  169.             'filters' => $filters,
  170.             'order_by' => $orderBy,
  171.             'ms' => $ms,
  172.             'user' => $this->getUser(),
  173.             'navbarTitle' => $this->translator->trans("Órdenes de trabajo")
  174.         ]); 
  175.     }
  177.     /**
  178.      * @Route({"en": "/new/{part}",
  179.      *         "es": "/nueva/{part}"}, name="order_new", methods={"GET","POST"})
  180.      */
  181.     public function new(Request $request, MailerInterface $mailer, Part $part, OrderRepository $orderRepository): Response
  182.     { 
  183.         $em = $this->em;
  184.         $admin = $this->getUser();
  185.         $order = new Order();
  186.         
  187.         $this->denyAccessUnlessGranted(OrderVoter::CREATE, $order);
  189.         $cs = $em->getRepository(CompanySupplier::class)->findOneBy(['company'=>$part->getCompany(),'supplier'=>$part->getSupplier()]);
  190.         $form = $this->createForm(OrderType::class, $order, ['user_admin' => $admin, 'part' => $part, 'cs'=>$cs]);
  191.         $form->handleRequest($request);
  193.         if ($form->isSubmitted() && $form->isValid()) {
  195.             $initMsg = $this->translator->trans('Pieza') . ' ' . $part->getRef() . ': ';
  196.             $createOrder = $this->createOrder($order);
  197.             if($createOrder['error']){
  198.                 $this->addFlash('danger', $initMsg . $createOrder['msg']);
  199.             }
  200.             else{
  201.                 $this->addFlash('success', $initMsg . $this->translator->trans('Orden creada correctamente'));
  202.             } 
  203.             
  204.             return $this->redirectToRoute('order_index');
  205.         }
  207.         return $this->render('order/new.html.twig', [
  208.             'order' => $order,
  209.             'cs' => $cs,
  210.             'form' => $form->createView(),
  211.             'user' => $this->getUser(),
  212.             'navbarTitle' => $this->translator->trans("Solicitar presupuesto")
  213.         ]);     
  214.     }
  216.     /**
  217.      * @Route({"en": "/new/bulk/{partIds}",
  218.      *         "es": "/nueva/masiva/{partIds}"}, name="order_bulk_new", methods={"GET","POST"})
  219.      */
  220.     public function newBulk(Request $request, OrderRepository $orderRepository, string $partIds): Response
  221.     {
  222.         $user =$this->getUser();
  223.         $em = $this->em;
  224.         $qb = $em->createQueryBuilder();
  226.         if($user == NULL){
  227.             return $this->redirectToRoute('app_login');
  228.         }
  230.         $decodedPartIds = explode(',',base64_decode($partIds));
  231.         $parts = [];
  232.         foreach($decodedPartIds as $partId){
  233.             $part = $this->em->getRepository(Part::class)->find($partId);
  234.             if($part && $part->getSupplier() && $part->getCompany()==$user->getCompany() && !$part->getLocked()){
  235.                 $parts[] = $part;
  236.             }
  237.         }
  239.         if(empty($parts)){
  240.             $this->addFlash('danger', $this->translator->trans('Error inesperado'));
  241.             return $this->redirectToRoute('part_index');
  242.         }        
  244.         if($request->isMethod('POST')){
  245.             $orders = (array) $request->request->get('orders');
  246.             if(!empty($orders) && count($orders)==4){
  247.                 $errorMsg = [];
  248.                 $successMsg = [];
  250.                 for($i=0;$i<count($orders['parts']);$i++){                    
  251.                     $partId = $orders['parts'][$i];
  253.                     $part = $em->getRepository(Part::class)->find($partId);
  254.                     if(!empty($part)){
  256.                         $shippingAddress = null;
  257.                         if(!empty($orders['shipping_address'][$i])){
  258.                             $shippingAddress = $em->getRepository(CompanyAddress::class)->find($orders['shipping_address'][$i]);
  259.                         }
  261.                         $order = new Order();
  262.                         $order->setPart($part);
  263.                         $order->setCompany($part->getCompany());
  264.                         $order->setSupplier($part->getSupplier());
  265.                         $order->setUser($user);
  266.                         $order->setShippingAddress($shippingAddress);
  267.                         $order->setUnits($orders['units'][$i]);
  268.                         $order->setObservations($orders['observations'][$i]);
  270.                         $initMsg = $this->translator->trans('Pieza') . ' ' . $part->getRef() . ': ';
  271.                         $createOrder = $this->createOrder($order);
  272.                         if($createOrder['error']){
  273.                             $errorMsg[] = $initMsg . $createOrder['msg'];
  274.                         }
  275.                         else{
  276.                             $successMsg[]=$initMsg . $this->translator->trans('Orden creada correctamente');
  277.                         }
  278.                     }   
  279.                     else{
  280.                         $errorMsg[] = $this->translator->trans('Pieza') . ' [' . $partId . ']: ' . $this->translator->trans('Error inesperado');
  281.                     } 
  282.                 }
  284.                 if($errorMsg){
  285.                     $this->addFlash('danger', implode('<br>',$errorMsg));    
  286.                 }
  288.                 if($successMsg){
  289.                     $this->addFlash('success', implode('<br>',$successMsg));    
  290.                 }
  292.                 return $this->redirectToRoute('order_index');
  293.             }
  294.             else{
  295.                 $this->addFlash('danger', $this->translator->trans('Error inesperado'));
  296.                 return $this->redirectToRoute('order_bulk_new',['partIds'=>$partIds]);
  297.             }
  298.             
  299.         }
  301.         return $this->render('order/bulk_new.html.twig', [
  302.             'parts' => $parts,
  303.             'user' => $user,
  304.             'navbarTitle' => $this->translator->trans("Nuevas órdenes de trabajo")
  305.         ]); 
  306.     }
  308.     private function createOrder(Order $order){
  309.         $em = $this->em;
  310.         $orderRepository = $this->orderRepository;
  311.         $part = $order->getPart();
  312.         $user = $this->getUser();
  313.         $roleClient = $user->getRole()=='ROLE_CLIENT';
  314.         $result = ['error'=>false,'msg'=>''];
  316.         $lastRef = $orderRepository->findLastRef($part->getCompany());
  317.         $cs = $em->getRepository(CompanySupplier::class)->findOneBy(['company'=>$part->getCompany(),'supplier'=>$part->getSupplier()]);
  318.         $budgetRequired = $cs ? $cs->getConfigStepBudget() : true;
  319.         $chiefConfirm = $cs ? $cs->getConfigStepChiefConfirm() : true;            
  320.         
  321.         $order->setRef($lastRef);
  322.         $order->setChiefConfirm($chiefConfirm);
  323.         $order->setBudgetRequired($budgetRequired);
  325.         if($roleClient){
  326.             $order->setState(7);
  327.         }
  329.         try 
  330.         {       
  331.             if(!$order->getId()){
  332.                 $em->persist($order);
  333.             }
  335.             //Bloqueo de pieza
  336.             $part = $order->getPart();
  337.             $part->setLocked(true);
  338.             $part->setLockedAt(new \DateTime());
  339.             $part->setLockedUser(null);
  341.             $em->flush();
  343.             $data['message']='Nueva orden creada';
  344.             $data['reference']=$order->getRef();
  345.             $data['path_name']='order_show';
  346.             $data['path_parameters']='id:'.$order->getId();
  348.             //Notificaciones - cliente
  349.             $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  350.             if(!$roleClient && $order->getCompany()!=$order->getSupplier()->getCompany()){
  351.                 //Notificaciones - proveedor
  352.                 $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  353.             }                
  355.         } catch ( UniqueConstraintViolationException $e) {
  356.             $result['error']=true;
  357.             $result['msg'] = $this->translator->trans('Ya existe una orden de trabajo para esta pieza');
  358.         }
  360.         return $result;
  361.     }
  363.     /**
  364.      * @Route({"en": "/show/{id}",
  365.      *         "es": "/mostrar/{id}"}, name="order_show", methods={"GET","POST"})
  366.      */
  367.     public function show(Request $request, Order $order, OrderRepository $orderRepository): Response
  368.     {
  369.         $this->denyAccessUnlessGranted(OrderVoter::VIEW, $order);
  371.         $em = $em = $this->em;
  372.         $fs = new Filesystem();
  373.         $slugger = new AsciiSlugger();
  374.         $ds = DIRECTORY_SEPARATOR;
  375.         $ordersDir = $this->getParameter('kernel.project_dir').$ds.'public'.$ds.'orders';
  376.         $user = $this->getUser();
  377.         $role = $user->getRole();
  378.         $fileMaxsizes = $this->util->getCompanyFileMaxsizes($order->getPart()->getCompany());
  380.         //Formulario envío de presupuesto
  381.         $formBudget = $this->createForm(OrderBudgetType::class, $order, ['user' => $user, 'file_maxsizes' => $fileMaxsizes]);
  382.         
  383.         //Formulario observaciones y carga archivos proveedor
  384.         $form = $this->createForm(OrderSupplierType::class, $order, ['user' => $user, 'part' => $order->getPart(), 'file_maxsizes' => $fileMaxsizes]);
  386.         if(in_array($role,['ROLE_SUPPLIER_CHIEF','ROLE_SUPPLIER'])){
  387.             //Formulario envío de presupuesto
  388.             $formBudget->handleRequest($request);
  390.             if($formBudget->isSubmitted()){
  391.                 if($formBudget->isValid()){
  392.                     $files = $request->files->get('order_budget')['files_budget'];
  393.                     $payTermsId = $form->getData()->getPaymentTermsId();
  394.                     $filenames = !empty($order->getFilesBudget()) ? explode(',',$order->getFilesBudget()) : [];
  395.                     $filesLimit = 5;
  397.                     if(count($files)>0){        
  398.                         try {
  399.                             if(!$fs->exists($ordersDir)){
  400.                                 $fs->mkdir($ordersDir);
  401.                             }
  403.                             foreach($files as $file)
  404.                             {
  405.                                 $originalFilename = pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME);
  406.                                 $safeFilename = $slugger->slug($originalFilename);
  407.                                 $newFilename = $safeFilename.'-budget-'.uniqid().'.'.$file->getClientOriginalExtension();
  409.                                 if(!in_array($newFilename,$filenames)){
  410.                                     $filenames[]=$newFilename;                            
  411.                                     if(count($filenames)>$filesLimit){
  412.                                         $this->addFlash('warning', $this->translator->trans('Se excedió el ḿaximo de archivos que se pueden cargar'));
  413.                                         break;
  414.                                     }
  415.                                     else{
  416.                                         $file->move($ordersDir, $newFilename);
  417.                                         $order->setFilesBudget(implode(',',$filenames));
  418.                                     }
  419.                                 } 
  420.                             }
  421.                         }
  422.                         catch (FileException $e) {
  423.                             $this->addFlash('danger', $this->translator->trans('Fallo en la carga de fichero'));
  424.                         }
  425.                         catch (IOExceptionInterface $e) {
  426.                             $this->addFlash('danger', $this->translator->trans('No se ha podido generar el directorio').' : '.$e->getPath());
  427.                         }
  428.                     }
  430.                     $order->setState(1);
  431.                     $order->setBudgetDate(new \DateTime());
  432.                     $order->markAsAproved();
  433.                     $order->setPaymentTerms($orderRepository->getPaymentTermsText($payTermsId));
  434.                     $em->persist($order);
  435.                     $em->flush();
  436.                     $this->addFlash('success', $this->translator->trans('Presupuesto enviado correctamente'));
  437.                     
  438.                     return $this->redirectToRoute('order_index');
  439.                 }
  440.                 else{
  441.                     $this->addFlash('danger', $this->translator->trans('Ha habido un error al procesar el formulario, revise los campos'));
  442.                 }
  443.             }                
  444.             
  445.             //Formulario observaciones y carga archivos proveedor
  446.             $form->handleRequest($request);
  448.             if($form->isSubmitted()){
  449.                 if($form->isValid()){
  450.                     $obs = $request->get('order_supplier');
  451.                     $files = $request->files->get('order_supplier')['files'];
  452.                     $filenames = !empty($order->getFilesSupplier()) ? explode(',',$order->getFilesSupplier()) : [];
  453.                     $filesLimit = 5;
  455.                     if(count($files)>0){        
  456.                         try {
  457.                             if(!$fs->exists($ordersDir)){
  458.                                 $fs->mkdir($ordersDir);
  459.                             }
  461.                             foreach($files as $file)
  462.                             {
  463.                                 $originalFilename = pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME);
  464.                                 $safeFilename = $slugger->slug($originalFilename);
  465.                                 $newFilename = $safeFilename.'-report-'.uniqid().'.'.$file->getClientOriginalExtension();
  467.                                 if(!in_array($newFilename,$filenames)){
  468.                                     $filenames[]=$newFilename;                            
  469.                                     if(count($filenames)>$filesLimit){
  470.                                         $this->addFlash('warning', $this->translator->trans('Se excedió el ḿaximo de archivos que se pueden cargar'));
  471.                                         break;
  472.                                     }
  473.                                     else{
  474.                                         $file->move($ordersDir, $newFilename);
  475.                                         $order->setFilesSupplier(implode(',',$filenames));
  476.                                     }
  477.                                 } 
  478.                             }
  479.                         }
  480.                         catch (FileException $e) {
  481.                             $this->addFlash('danger', $this->translator->trans('Fallo en la carga de fichero'));
  482.                         }
  483.                         catch (IOExceptionInterface $e) {
  484.                             $this->addFlash('danger', $this->translator->trans('No se ha podido generar el directorio').' : '.$e->getPath());
  485.                         }
  486.                     }
  488.                     $em->persist($order);
  489.                     $em->flush();
  490.                     $this->addFlash('success', $this->translator->trans('Orden editada correctamente'));
  491.                     
  492.                     return $this->redirectToRoute('order_show',['id'=>$order->getId()]);
  493.                 }
  494.                 else{
  495.                     $this->addFlash('danger', $this->translator->trans('Ha habido un error al procesar el formulario, revise los campos'));
  496.                 }
  497.             }                
  499.             if($request->query->has('rm')){
  500.                 $type = $request->query->has('type') && $request->query->get('type')==1 ? 1 : 2;
  501.                 $filenames =  explode(',',($type==1 ? $order->getFilesBudget() : $order->getFilesSupplier()));
  502.                 $index = $request->query->get('rm');
  504.                 if(!empty($filenames[$index])){
  505.                     $fileToRemove = $filenames[$index];
  506.                     if($fs->exists($ordersDir.$ds.$fileToRemove)){
  507.                         try {
  508.                             $fs->remove($ordersDir.$ds.$fileToRemove);
  509.                             unset($filenames[$index]);
  510.                             if($type==1){
  511.                                 $order->setFilesBudget(implode(',',$filenames));
  512.                             }
  513.                             else{
  514.                                 $order->setFilesSupplier(implode(',',$filenames));
  515.                             }
  516.                             
  517.                             $em->flush();                            
  519.                             $this->addFlash('success', $this->translator->trans('Archivo eliminado correctamente'));
  520.                         } catch (IOExceptionInterface $exception) {
  521.                             $this->addFlash('danger',$this->translator->trans('No se ha podido eliminar el archivo'));
  522.                         }
  523.                     }                
  524.                 }
  525.                 return $this->redirectToRoute('order_show',['id'=>$order->getId()]);
  526.                 
  527.             }
  528.         } 
  530.         if($request->query->get('download')){
  532.             $url = $this->generateUrl('order_show',['id'=>$order->getId()], UrlGeneratorInterface::ABSOLUTE_URL);
  533.             $qr = $this->util->generateQrCode($url);
  535.             if($request->query->get('download')==1){
  536.                 $options = [
  537.                     'page-size' => 'A6',
  538.                     'orientation'=>'Landscape'
  539.                 ];
  540.     
  541.                 $html =$this->renderView('order/pdf/tag.html.twig', [
  542.                     'order' => $order,
  543.                     'qr' => $qr,
  544.                     'user' => $user
  545.                 ]);
  547.                 return new PdfResponse(
  548.                     $this->pdf->getOutputFromHtml($html, $options),
  549.                     $order->getRef().'_'.$this->translator->trans('etiqueta').'.pdf'
  550.                 );
  551.                     
  552.             }
  553.             else{
  555.                 $header = $this->renderView( 'order/pdf/report_header.html.twig',[
  556.                     'order' => $order,
  557.                     'partByCat' => $this->partService->getPartByCat($order->getPart()),
  558.                     'qr' => $qr,
  559.                     'preview' => $order->getPart()->getFilePreview() ? $this->partDir . DIRECTORY_SEPARATOR . $order->getPart()->getFilePreview() : '',
  560.                     'user' => $user
  561.                 ] );
  562.                 
  563.                 $footer = $this->renderView( 'order/pdf/report_footer.html.twig',[
  564.                     'order' => $order,
  565.                     'partByCat' => $this->partService->getPartByCat($order->getPart()),
  566.                     'qr' => $qr,
  567.                     'user' => $user
  568.                 ] );
  569.     
  570.                 $options = [
  571.                     'header-html' => $header,
  572.                     'footer-html' => $footer,
  573.                     'page-size' => 'A4'
  574.                 ];
  575.     
  576.                 $html =$this->renderView('order/pdf/report.html.twig', [
  577.                     'order' => $order,
  578.                     'sum' => $this->orderService->getOrderSummary($order),
  579.                     'partByCat' => $this->partService->getPartByCat($order->getPart()),
  580.                     'qr' => $qr,
  581.                     'user' => $user
  582.                 ]);
  584.                 return new PdfResponse(
  585.                     $this->pdf->getOutputFromHtml($html, $options),
  586.                     $order->getRef().'_'.$this->translator->trans('hoja_produccion').'.pdf'
  587.                 );
  588.             }            
  589.         }
  591.         if ($request->getMethod()=='POST') {
  593.             if ($this->isCsrfTokenValid('initiate'.$order->getId(), $request->request->get('_token'))) {
  594.                 $said = $request->request->get('shipping_address');
  595.                 $type = $request->request->get('request_order') ? 1 : 2;
  597.                 if($type==1){
  598.                     if($said>0){
  599.                         $shipping_address = $em->getRepository(CompanyAddress::class)->find($said);
  600.                         $order->setShippingAddress($shipping_address);
  601.                     }
  602.     
  603.                     $order->setState(0);
  604.                 }
  605.                 else{
  606.                     $order->setState(6);
  607.                     $order->setRejectUser($user);
  608.                     $order->setRejectDate(new \DateTime());
  609.                 }
  610.                 
  611.                 $order->markAsAproved(); //updated
  612.                 $em->flush();
  613.                 
  614.                 $data['message']='Orden de cliente solicitada';
  615.                 $data['reference']=$order->getRef();
  616.                 $data['path_name']='order_show';
  617.                 $data['path_parameters']='id:'.$order->getId();
  618.     
  619.                 //Notificaciones - cliente
  620.                 $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  621.                 if($order->getCompany()!=$order->getSupplier()->getCompany()){
  622.                     //Notificaciones - proveedor
  623.                     $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  624.                 }
  625.                     
  626.                 $this->addFlash('success', $this->translator->trans('Orden de cliente solicitada'));
  627.                 
  628.                 return $this->redirectToRoute('order_index');
  629.             }
  630.         }
  632.         $addresses = null;
  633.         if($order->getState()==7){
  634.             $addresses = $em->createQueryBuilder()
  635.                 ->select('ca')
  636.                 ->from(CompanyAddress::class,'ca')
  637.                 ->where("ca.company = {$order->getPart()->getSupplier()->getCompany()->getId()}")
  638.                 ->orderBy('ca.name', 'ASC')->getQuery()->getResult();
  639.         }            
  641.         return $this->render('order/show.html.twig', [
  642.             'order' => $order,
  643.             'cs' => $em->getRepository(CompanySupplier::class)->findOneBy(['company'=>$order->getCompany(),'supplier'=>$order->getSupplier()]),
  644.             'user' => $user,
  645.             'fileMaxsizes' => $fileMaxsizes,
  646.             'form' => $form ? $form->createView() : null,
  647.             'formBudget' => $formBudget->createView(),
  648.             'addresses' => $addresses,
  649.             'navbarTitle' => $this->translator->trans("Orden de trabajo").' - '.$order->getRef()
  650.         ]);
  651.             
  652.     }
  654.     /**
  655.      * @Route({"en": "/edit/{id}/{part}",
  656.      *         "es": "/editar/{id}/{part}"}, name="order_edit", methods={"GET","POST"})
  657.      */
  658.     public function edit(Request $request, Order $order, Part $part): Response
  659.     {
  660.         $this->denyAccessUnlessGranted(OrderVoter::EDIT, $order);
  662.         $admin = $this->getUser();
  663.         $form = $this->createForm(OrderType::class, $order, ['user_admin' => $admin, 'part' => $part]);
  664.         $form->handleRequest($request);
  666.         if ($form->isSubmitted() && $form->isValid()) {
  667.             $order->markAsAproved();
  668.             $this->em->flush();
  670.             $this->addFlash('success', $this->translator->trans('Orden editada correctamente'));
  672.             return $this->redirectToRoute('order_index');
  673.         }
  675.         return $this->render('order/edit.html.twig', [
  676.             'order' => $order,
  677.             'form' => $form->createView(),
  678.             'user' => $this->getUser(),
  679.             'navbarTitle' => $this->translator->trans("Editar orden").' - '.$order->getRef()
  680.         ]);
  681.     }
  683.     /**
  684.      * @Route({"en": "/accept/{id}",
  685.      *         "es": "/aceptar/{id}"}, name="order_accept", methods={"POST"})
  686.      */
  687.     public function accept(Request $request, MailerInterface $mailer, Order $order, OrderRepository $orderRepository): Response
  688.     {
  689.         $this->denyAccessUnlessGranted(OrderVoter::ACCEPT, $order);
  691.         if ($this->isCsrfTokenValid('accept'.$order->getId(), $request->request->get('_token'))) {
  692.             $entityManager = $this->em;
  693.             $user = $this->getUser();
  694.             $role = $user->getRole();
  695.             $currentState = $order->getState();
  697.             if(!in_array($order->getState(),[1,2])){
  698.                 $this->addFlash('danger', $this->translator->trans('El presupuesto ya estaba aceptado'));
  699.                 return $this->redirectToRoute('order_index');
  700.             }
  702.             if($order->getState()==2 && $order->getChiefConfirm() && $role=='ROLE_USER'){
  703.                 $this->addFlash('danger', $this->translator->trans('Requiere confirmación del usuario administrador'));
  704.                 return $this->redirectToRoute('order_index'); 
  705.             }
  707.             $state = $order->getState() == 1 ? 2 : 3;
  709.             $acceptRef=null;
  710.             if($state==3){
  711.                 $acceptRef = $orderRepository->getNewAcceptRef($order->getCompany());
  712.             }
  714.             $order->setState($state);
  715.             $order->setAcceptRef($acceptRef);
  716.             $order->markAsAproved();
  717.             $order->setApproveDate(new \DateTime());
  718.             if($role=='ROLE_USER'){
  719.                 $order->setApproveUserUser($user);
  720.                 $order->setApproveUserDate(new \DateTime());
  721.             }
  722.             else{
  723.                 $order->setApproveChiefUser($user);
  724.                 $order->setApproveChiefDate(new \DateTime());
  725.             }
  727.             $entityManager->persist($order);
  728.             $entityManager->flush();
  730.             if($state==3){
  731.                 try {
  732.                     //Si existen archivos encriptados se les asignan los grants correspondientes
  733.                     $this->encryptDecryptService->encryptPartGrants($order->getPart(), $order->getUnits());
  734.                 } catch (\Exception $e) {   
  735.                     $this->addFlash('warning', $e->getMessage());
  736.                 }
  737.             }
  739.             $adminEmail = $this->em->getRepository(User::class)->findOneBy(['role' => 'ROLE_ADMIN'])->getEmail();
  740.             $email = (new TemplatedEmail())
  741.             ->from(new Address($this->emailApp, 'Addvance3D'))
  742.             ->to($adminEmail)
  743.             ->addTo($order->getUser()->getEmail())
  744.             ->subject('Orden de trabajo aceptada')
  745.             ->htmlTemplate('order/email/acceptedEmail.html.twig')
  746.             ->context([                
  747.                 'order' => $order,
  748.                 'user' => $user
  749.             ]); 
  751.             $mailer->send($email);
  753.             $this->addFlash('success', $this->translator->trans('Presupuesto aceptado'));
  754.                 
  755.             $data['message']='Presupuesto aceptado';
  756.             $data['reference']=$order->getRef();
  757.             $data['path_name']='order_show';
  758.             $data['path_parameters']='id:'.$order->getId();
  760.             //Notificaciones - cliente
  761.             $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  762.             if($order->getCompany()!=$order->getSupplier()->getCompany() && $state==3){
  763.                 //Notificaciones - proveedor
  764.                 $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  765.             }
  766.         }
  768.         return $this->redirectToRoute('order_index');
  769.     }
  771.     /**
  772.      * @Route({"en": "/accept/supplier/{id}",
  773.      *         "es": "/aceptar/proveedor/{id}"}, name="order_accept_supplier", methods={"POST"})
  774.      */
  775.     public function acceptSupplier(Request $request, MailerInterface $mailer, Order $order, OrderRepository $orderRepository): Response
  776.     {
  777.         $this->denyAccessUnlessGranted(OrderVoter::ACCEPT_SUPPLIER, $order);
  779.         if ($this->isCsrfTokenValid('accept'.$order->getId(), $request->request->get('_token'))) {
  780.             $entityManager = $this->em;
  781.             $user = $this->getUser();
  782.             $role = $user->getRole();
  783.             $currentState = $order->getState();
  785.             if ($currentState==0)
  786.             {
  787.                 $acceptRef = $orderRepository->getNewAcceptRef($order->getCompany());
  788.                 $order->setState(3);
  789.                 $order->setAcceptRef($acceptRef);
  790.                 $order->markAsAproved();
  791.                 $order->setApproveSupplierUser($user);
  792.                 $order->setApproveSupplierDate(new \DateTime());
  793.                 $order->setApproveDate(new \DateTime());
  795.                 $entityManager->persist($order);
  796.                 $entityManager->flush();
  798.                 try {
  799.                     //Si existen archivos encriptados se les asignan los grants correspondientes
  800.                     $this->encryptDecryptService->encryptPartGrants($order->getPart(), $order->getUnits());
  801.                 } catch (\Exception $e) {   
  802.                     $this->addFlash('warning', $e->getMessage());
  803.                 }
  805.                 $adminEmail = $this->em->getRepository(User::class)->findOneBy(['role' => 'ROLE_ADMIN'])->getEmail();
  806.                 $email = (new TemplatedEmail())
  807.                 ->from(new Address($this->emailApp, 'Addvance3D'))
  808.                 ->to($adminEmail)
  809.                 ->addTo($order->getUser()->getEmail())
  810.                 ->subject('Orden de trabajo aceptada')
  811.                 ->htmlTemplate('order/email/acceptedEmail.html.twig')
  812.                 ->context([                
  813.                     'order' => $order,
  814.                     'user' => $user
  815.                 ]); 
  817.                 $mailer->send($email);
  819.                 $this->addFlash('success', $this->translator->trans('Orden de trabajo aceptada'));
  820.                 
  821.                 $data['message']='Orden de trabajo aceptada';
  822.                 $data['reference']=$order->getRef();
  823.                 $data['path_name']='order_show';
  824.                 $data['path_parameters']='id:'.$order->getId();
  826.                 //Notificaciones - cliente
  827.                 $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  828.                 if($order->getCompany()!=$order->getSupplier()->getCompany()){
  829.                     //Notificaciones - proveedor
  830.                     $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  831.                 }
  832.             }else{
  833.                 $this->addFlash('danger', $this->translator->trans('La orden de trabajo ya estaba aceptada'));
  834.             }       
  835.         }
  837.         return $this->redirectToRoute('order_index');
  838.     }
  840.     /**
  841.      * @Route({"en": "/reject/{id}",
  842.      *         "es": "/rechazar/{id}"}, name="order_reject", methods={"POST"})
  843.      */
  844.     public function reject(Request $request, MailerInterface $mailer, Order $order): Response
  845.     {
  846.         $this->denyAccessUnlessGranted(OrderVoter::REJECT, $order);
  848.         if ($this->isCsrfTokenValid('reject'.$order->getId(), $request->request->get('_token'))) {
  849.             $entityManager = $this->em;
  850.             $user = $this->getUser();
  851.             $role = $user->getRole();
  852.             $currentState = $order->getState();
  854.             if ($currentState!=6)
  855.             {
  856.                 $order->setState(6);
  857.                 $order->markAsAproved();
  858.                 $order->setRejectUser($user);
  859.                 $order->setRejectDate(new \DateTime());
  860.                 
  861.                 $entityManager->persist($order);
  862.                 $entityManager->flush();
  864.                 $adminEmail = $this->em->getRepository(User::class)->findOneBy(['role' => 'ROLE_ADMIN'])->getEmail();
  865.                 $email = (new TemplatedEmail())
  866.                 ->from(new Address($this->emailApp, 'Addvance3D'))
  867.                 ->to($adminEmail)
  868.                 ->addTo($order->getUser()->getEmail())
  869.                 ->subject('Orden de trabajo rechazada')
  870.                 ->htmlTemplate('order/email/rejectedEmail.html.twig')
  871.                 ->context([                
  872.                     'order' => $order,
  873.                 ]); 
  875.                 $mailer->send($email);
  877.                 $this->addFlash('success', $this->translator->trans('Presupuesto rechazado'));
  879.                 $data['message']='Presupuesto rechazado';
  880.                 $data['reference']=$order->getRef();
  881.                 $data['path_name']='order_show';
  882.                 $data['path_parameters']='id:'.$order->getId();
  884.                 //Notificaciones - cliente
  885.                 $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  886.                 if($order->getCompany()!=$order->getSupplier()->getCompany()){
  887.                     //Notificaciones - proveedor
  888.                     $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  889.                 }
  890.             }else{
  891.                 $this->addFlash('danger', $this->translator->trans('El presupuesto ya estaba rechazado'));
  892.             }       
  893.         }
  895.         return $this->redirectToRoute('order_index');
  896.     }
  898.     /**
  899.      * @Route("/bulk/accept_reject", name="order_bulk_accept_reject", methods={"POST"})
  900.      */
  901.     public function bulk(Request $request, MailerInterface $mailer, OrderRepository $orderRepository): Response
  902.     {
  903.         if ($this->isCsrfTokenValid('bulk_accept_reject', $request->request->get('_token'))) {
  904.             $em = $this->em;
  905.             $user = $this->getUser();
  906.             $role = $user->getRole();
  907.             $state = $request->request->get('type') == 1 ? 3 : 6;
  908.             $orders = explode(',',$request->request->get('orders'));
  910.             if ($this->isGranted('ROLE_USER') && !empty($state) && !empty($orders))
  911.             {
  912.                 $lastSupplierId=null;
  913.                 $acceptRef=null;
  914.                 $ordersRef=[];
  915.                 foreach($orders as $oid){
  916.                     $order = $em->getRepository(Order::class)->find($oid);                    
  917.                     $order->setState($state);
  918.                     $order->markAsAproved();
  919.                     if($state==3){
  920.                         $order->setApproveDate(new \DateTime());
  921.                         if($role=='ROLE_USER'){
  922.                             $order->setApproveUserUser($user);
  923.                             $order->setApproveUserDate(new \DateTime());
  924.                         }
  925.                         else{
  926.                             $order->setApproveChiefUser($user);
  927.                             $order->setApproveChiefDate(new \DateTime());
  928.                         }
  929.                     }
  930.                     else{
  931.                         $order->setRejectUser($user);
  932.                         $order->setRejectDate(new \DateTime());
  933.                     }
  935.                     if($state==3 && empty($acceptRef)){
  936.                         $acceptRef = $orderRepository->getNewAcceptRef($order->getCompany());
  937.                     }
  938.                     
  939.                     $order->setAcceptRef($acceptRef);
  941.                     if(empty($lastSupplierId)){
  942.                         $lastSupplierId = $order->getSupplier()->getId();
  943.                     }
  944.                     elseif($lastSupplierId != $order->getSupplier()->getId()){
  945.                         $lastSupplierId = null;
  946.                         break;
  947.                     }
  949.                     $ordersRef[]=$order->getRef();
  950.                 }
  951.                 
  952.                 if(!empty($lastSupplierId)){
  953.                     $em->flush();
  954.                     
  955.                     if($state==3){
  956.                         foreach($orders as $oid){
  957.                             $order = $em->getRepository(Order::class)->find($oid);                            
  958.                             try {
  959.                                 //Si existen archivos encriptados se les asignan los grants correspondientes
  960.                                 $this->encryptDecryptService->encryptPartGrants($order->getPart(), $order->getUnits());
  961.                             } catch (\Exception $e) {   
  962.                                 $this->addFlash('warning', $e->getMessage());
  963.                             }                            
  964.                         }
  965.                     }
  967.                     $subject = $msgFlash = $state==3 ? 'Presupuestos aceptados' : 'Presupuestos rechazados';
  968.                     $msgType = $state==3 ? 'aprobado' : 'rechazado';
  969.                     $msg = "El usuario {$user->getName()} {$user->getSurname()} ha $msgType los siguientes presupuestos : ";
  970.                     $msg.='<ul>';
  971.                     foreach($ordersRef as $ref){
  972.                         $msg.="<li>$ref</li>";
  973.                     }
  974.                     $msg.='</ul>';
  976.                     $adminEmail = $this->em->getRepository(User::class)->findOneBy(['role' => 'ROLE_ADMIN'])->getEmail();
  977.                     $email = (new TemplatedEmail())
  978.                     ->from(new Address($this->emailApp, 'Addvance3D'))
  979.                     ->to($adminEmail)                    
  980.                     ->subject($this->translator->trans($subject))
  981.                     ->htmlTemplate('order/email/bulkAcceptedRejectedEmail.html.twig')
  982.                     ->context([                
  983.                         'msg' => $msg,
  984.                         'user' => $user
  985.                     ]); 
  987.                     $mailer->send($email);
  989.                     $this->addFlash('success', $this->translator->trans($msgFlash));    
  991.                     $data['message']=$msgFlash;
  992.                     
  993.                     //Notificaciones - cliente
  994.                     $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  995.                     if($order->getCompany()!=$order->getSupplier()->getCompany()){
  996.                         //Notificaciones - proveedor
  997.                         $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  998.                     }
  999.                 }
  1000.                 else{
  1001.                     $this->addFlash('danger', $this->translator->trans('No se pueden aceptar/rechazar presupuestos de distintos centros de trabajo de forma masiva'));
  1002.                 }   
  1003.             }else{
  1004.                 $this->addFlash('danger', $this->translator->trans('Error inesperado'));
  1005.             }       
  1006.         }
  1008.         return $this->redirectToRoute('order_shopping');
  1009.     }
  1011.     /**
  1012.      * @Route({"en": "/send/{id}",
  1013.      *         "es": "/enviar/{id}"}, name="order_send", methods={"POST"})
  1014.      */
  1015.     public function send(Request $request, MailerInterface $mailer, Order $order): Response
  1016.     {
  1017.         $this->denyAccessUnlessGranted(OrderVoter::SEND, $order);
  1019.         if ($this->isCsrfTokenValid('send'.$order->getId(), $request->request->get('_token'))) {
  1020.             $entityManager = $this->em;
  1021.             $user = $this->getUser();
  1022.             $role = $user->getRole();
  1023.             $currentState = $order->getState();
  1025.             if ($currentState!=4)
  1026.             {
  1027.                 $order->setState(4);
  1028.                 $order->markAsAproved();
  1029.                 $order->setSendUser($user);
  1030.                 $order->setSendDate(new \DateTime());
  1031.                 
  1032.                 $entityManager->persist($order);
  1033.                 $entityManager->flush();
  1035.                 $this->addFlash('success', $this->translator->trans('Orden de trabajo enviada'));
  1037.                 $data['message']='Orden de trabajo enviada';
  1038.                 $data['reference']=$order->getRef();
  1039.                 $data['path_name']='order_show';
  1040.                 $data['path_parameters']='id:'.$order->getId();
  1042.                 //Notificaciones - cliente
  1043.                 $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1044.                 if($order->getCompany()!=$order->getSupplier()->getCompany()){
  1045.                     //Notificaciones - proveedor
  1046.                     $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1047.                 }
  1048.             }else{
  1049.                 $this->addFlash('danger', $this->translator->trans('La orden de trabajo ya estaba enviada'));
  1050.             }       
  1051.         }
  1053.         return $this->redirectToRoute('order_index');
  1054.     }
  1056.     /**
  1057.      * @Route({"en": "/complete/{id}",
  1058.      *         "es": "/completar/{id}"}, name="order_complete", methods={"POST"})
  1059.      */
  1060.     public function complete(Request $request, MailerInterface $mailer, Order $order): Response
  1061.     {
  1062.         $this->denyAccessUnlessGranted(OrderVoter::COMPLETE, $order);
  1064.         if ($this->isCsrfTokenValid('complete'.$order->getId(), $request->request->get('_token'))) {
  1065.             $em = $this->em;
  1066.             $user = $this->getUser();
  1067.             $cs = $em->getRepository(CompanySupplier::class)->findOneBy(['company'=>$order->getCompany(),'supplier'=>$order->getSupplier()]);
  1068.             $configInDelivery = $cs ? $cs->getConfigStepInDelivery() : true;
  1070.             if ($order->getState() == 4 || ($order->getState()==3 && !$configInDelivery))
  1071.             {
  1072.                 $order->setState(5);
  1073.                 $order->markAsCompleted();
  1074.                 $order->setCompleteUser($user);
  1075.                 $order->setCompleteDate(new \DateTime());
  1077.                 $em->persist($order);
  1078.                 $em->flush();
  1080.                 $adminEmail = $this->em->getRepository(User::class)->findOneBy(['role' => 'ROLE_ADMIN'])->getEmail();
  1081.                 $email = (new TemplatedEmail())
  1082.                 ->from(new Address($this->emailApp, 'Addvance3D'))
  1083.                 ->to($adminEmail)
  1084.                 ->subject('Orden de trabajo completada')
  1085.                 ->htmlTemplate('order/email/completedEmail.html.twig')
  1086.                 ->context([                
  1087.                     'order' => $order,
  1088.                 ]); 
  1090.                 $mailer->send($email);
  1092.                 $this->addFlash('success', $this->translator->trans('Orden de trabajo completada'));   
  1094.                 $data['message']='Orden de trabajo completada';
  1095.                 $data['reference']=$order->getRef();
  1096.                 $data['path_name']='order_show';
  1097.                 $data['path_parameters']='id:'.$order->getId();
  1099.                 //Notificaciones - cliente
  1100.                 $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1101.                 if($order->getCompany()!=$order->getSupplier()->getCompany()){
  1102.                     //Notificaciones - proveedor
  1103.                     $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1104.                 }
  1105.             }else{
  1106.                 $this->addFlash('danger', $this->translator->trans('La orden debe estar en entrega'));  
  1107.             }       
  1108.         }
  1110.         return $this->redirectToRoute('order_index');
  1111.     }
  1113.     /**
  1114.      * @Route({"en": "/delete/{id}",
  1115.      *         "es": "/borrar/{id}"}, name="order_delete", methods={"DELETE"})
  1116.      */
  1117.     public function delete(Request $request, Order $order): Response
  1118.     {
  1119.         $this->denyAccessUnlessGranted(OrderVoter::DELETE, $order);
  1121.         if ($this->isCsrfTokenValid('delete'.$order->getId(), $request->request->get('_token'))) {
  1122.             $rmOrder = $this->rmOrder($order);
  1124.             if($rmOrder['error']){
  1125.                 $this->addFlash('danger', $rmOrder['msg']);
  1126.             }
  1127.             else{
  1128.                 $this->addFlash('success', $this->translator->trans('Orden eliminada correctamente'));
  1129.             }
  1130.         }
  1132.         return $this->redirectToRoute('order_index');
  1133.     }
  1135.     private function rmOrder(Order $order){
  1136.         $em = $this->em;
  1137.         $result = ['error'=>false,'msg'=>''];
  1138.         
  1139.         try {
  1140.             $em->remove($order);
  1141.             $em->flush();
  1143.         } catch (ForeignKeyConstraintViolationException $e) {
  1144.             $result = ['error'=>true, 'msg'=>$this->translator->trans('No se puede eliminar una orden asociada')];
  1145.         }
  1147.         return $result;
  1148.     }
  1150.     /**
  1151.      * @Route({"en": "/shopping",
  1152.      *         "es": "/cesta"}, name="order_shopping", methods={"GET"})
  1153.      */
  1154.     public function shopping(Request $request, OrderRepository $orderRepository): Response
  1155.     {
  1156.         $admin =$this->getUser();
  1158.         if($admin == NULL){
  1159.             return $this->redirectToRoute('app_login');
  1160.         }
  1162.         $orders = $orderRepository->getShoppingCar($admin);
  1164.         return $this->render('order/shopping.html.twig', [
  1165.             'orders' => $orders,
  1166.             'navbarTitle' => $this->translator->trans("Cesta")
  1167.         ]); 
  1168.     }
  1170.     /**
  1171.      * @Route("/chat/message", name="order_chat_message", methods={"POST"})
  1172.      */
  1173.     public function chatMessage(Request $request, MailerInterface $mailer, OrderRepository $orderRepository): JsonResponse
  1174.     {
  1175.         $result = ['error'=>false,'msg'=>'','data'=>[]];
  1177.         $em = $this->em;
  1178.         $user = $this->getUser();
  1179.         $type = $request->request->get('type',1); //1:Read, 2:Send/read
  1180.         $message = $request->request->get('message');
  1181.         $oid = $request->request->get('oid');
  1182.         
  1183.         if (empty($oid) || empty($user))
  1184.         {
  1185.             $result = ['error'=>true,'msg'=>$this->translator->trans("Error inesperado")];
  1186.         }
  1187.         elseif($type==2 && empty($message)){
  1188.             $result = ['error'=>true,'msg'=>$this->translator->trans("El mensaje no puede estar vacío")];
  1189.         }
  1190.         else{    
  1191.             $order = $em->getRepository(Order::class)->find($oid);
  1192.             if(empty($order)){
  1193.                 $result = ['error'=>true,'msg'=>$this->translator->trans("Error inesperado")];
  1194.             }
  1195.             else{
  1196.                 if($type==2){
  1197.                     $om = new OrderMessage();
  1198.                     $om->setOrder($order);
  1199.                     $om->setUser($user);
  1200.                     $om->setDateAdded(new \DateTime());
  1201.                     $om->setMessage($message);
  1203.                     $em->persist($om);
  1204.                     $em->flush();
  1206.                     $messages = $em->getRepository(OrderMessage::class)->findBy(['order_'=>$order,'user'=>$user],['date_added'=>'DESC'],2);
  1208.                     if(count($messages)<2 || ($messages[0]->getDateAdded()->format('U') - $messages[1]->getDateAdded()->format('U') > 300)){
  1210.                         $data['message']='Nuevo mensaje de chat';
  1211.                         $data['reference']=$order->getRef();
  1212.                         $data['path_name']='order_show';
  1213.                         $data['path_parameters']='id:'.$order->getId();
  1215.                         if($user->getCompany()->getType()==2){
  1216.                             //Msg generado por proveedor, Notificaciones - cliente
  1217.                             $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1218.                         }
  1219.                         else{
  1220.                             //Msg generado por proveedor, Notificaciones - proveedor
  1221.                             $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1222.                         }                        
  1223.                     }                    
  1224.                 }
  1226.                 $messages = $qb = $em->createQueryBuilder()
  1227.                                 ->select('o,u,om')
  1228.                                 ->from(OrderMessage::class,'om')
  1229.                                 ->join('om.order_','o')
  1230.                                 ->join('om.user','u')
  1231.                                 ->where('om.order_ = :order')
  1232.                                 ->orderBy('om.date_added','ASC')
  1233.                                 ->setParameters(['order'=>$order])
  1234.                                 ->getQuery()->getArrayResult();
  1235.                 $result['data']=$messages;
  1236.             }
  1237.             
  1238.         }      
  1240.         return new JsonResponse($result);
  1241.     }
  1243.     /**
  1244.      * @Route({"en": "/export/{id}",
  1245.      *         "es": "/exportar/{id}"}, defaults={"id" = null}, name="order_export", methods={"GET"})
  1246.      */
  1247.     public function export(OrderRepository $orderRepository, Order $order = null)
  1248.     {
  1249.         $trans = $this->translator;
  1251.         if (null !== $order)
  1252.         {
  1253.             $filename = $trans->trans("AD2_orden_"). $order->getRef() . '_' . time() . ".xlsx";
  1254.         }else
  1255.         {
  1256.             $filename = $trans->trans("AD2_ordenes_"). time() . ".xlsx";
  1258.         }
  1260.         $admin =$this->getUser();
  1261.         $company = $admin->getCompany();
  1262.         $colorARGB = $company && $company->getCorporateColor() ? str_replace('#','',$company->getCorporateColor()) : 'DD9933';
  1264.         $spreadsheet = new Spreadsheet();
  1266.         $sheet = $spreadsheet->getActiveSheet();
  1268.         //$sheet->setTitle('Addvance Users');
  1270.         $sheet->getCell('A1')->setValue($trans->trans('Referencia orden'));
  1271.         $sheet->getCell('B1')->setValue($trans->trans('Empresa'));
  1272.         $sheet->getCell('C1')->setValue($trans->trans('Pieza'));
  1273.         $sheet->getCell('D1')->setValue($trans->trans('Referencia pieza'));
  1274.         $sheet->getCell('E1')->setValue($trans->trans('Centro de trabajo'));
  1275.         $sheet->getCell('F1')->setValue($trans->trans('Unidades'));
  1276.         $sheet->getCell('G1')->setValue($trans->trans('Estado'));
  1277.         $sheet->getCell('H1')->setValue($trans->trans('Pedido'));
  1278.         $sheet->getCell('I1')->setValue($trans->trans('Autor'));
  1279.         $sheet->getCell('J1')->setValue($trans->trans('Fecha de creación'));
  1280.         $sheet->getCell('K1')->setValue($trans->trans('Fecha Revisión'));
  1281.         $sheet->getCell('L1')->setValue($trans->trans('Fecha de finalización'));
  1282.         $sheet->getCell('M1')->setValue($trans->trans('Observaciones'));
  1285.         $styleArrayFirstRow = [
  1286.             'font' => [
  1287.                 'bold' => true,
  1288.                 'color' => array('rgb' => 'FFFFFF'),
  1289.             ]
  1290.         ];
  1291.         $highestColumn = $sheet->getHighestColumn();
  1292.         $sheet->getStyle('A1:M1')->applyFromArray($styleArrayFirstRow);
  1293.         //$sheet->getStyle('A')->applyFromArray($styleArrayFirstRow);
  1296.         //$sheet->getColumnDimension('A')->setWidth(30);
  1297.         //$sheet->getStyle('A')->getFont()->setBold(true);
  1298.         $sheet->getDefaultColumnDimension()->setWidth(30);
  1302.         $sheet
  1303.             ->getStyle('A1:M1')
  1304.             ->getFill()
  1305.             ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  1306.             ->getStartColor()
  1307.             ->setARGB($colorARGB);
  1309.         if (null!== $order)
  1310.         {
  1311.             $sheet->fromArray($orderRepository->generateExport($admin, $order),null, 'A2', true);
  1312.         }else
  1313.         {
  1314.             $sheet->fromArray($orderRepository->generateExport($admin),null, 'A2', true);
  1315.         }
  1317.         $writer = new Xlsx($spreadsheet);
  1319.         $response =  new StreamedResponse(
  1320.             function () use ($writer) {
  1321.                 $writer->save('php://output');
  1322.             }
  1323.         );
  1324.         $response->headers->set('Content-Type', 'application/vnd.ms-excel');
  1325.         $response->headers->set('Content-Disposition', 'attachment;filename="'.$filename.'"');
  1326.         $response->headers->set('Cache-Control','max-age=0');
  1327.         return $response;
  1328.     }
  1329. }