src/Controller/OrderController.php line 1346

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\OrderFilesType;
  14. use App\Form\OrderPrototypeType;
  15. use App\Form\OrderSearchType;
  16. use App\Form\OrderType;
  17. use App\Form\OrderSupplierType;
  18. use App\Form\OrderBudgetType;
  19. use App\Repository\OrderRepository;
  20. use App\Security\Voter\OrderVoter;
  21. use Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException;
  22. use Doctrine\DBAL\Exception\UniqueConstraintViolationException;
  23. use Knp\Component\Pager\PaginatorInterface;
  24. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  25. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  26. use Symfony\Component\Form\FormInterface;
  27. use Symfony\Component\HttpFoundation\Request;
  28. use Symfony\Component\HttpFoundation\Response;
  29. use Symfony\Component\HttpFoundation\JsonResponse;
  30. use Symfony\Component\Mailer\MailerInterface;
  31. use Symfony\Component\Mime\Address;
  32. use Symfony\Component\Routing\Annotation\Route;
  33. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  34. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  35. use Symfony\Component\HttpFoundation\StreamedResponse;
  36. use Symfony\Contracts\Translation\TranslatorInterface;
  37. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  38. use Knp\Snappy\Pdf;
  39. use Knp\Bundle\SnappyBundle\Snappy\Response\PdfResponse;
  40. use App\Service\UtilService;
  41. use App\Service\OrderService;
  42. use App\Service\PartService;
  43. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  44. use Symfony\Component\Filesystem\Exception\IOExceptionInterface;
  45. use Symfony\Component\Filesystem\Filesystem;
  46. use Symfony\Component\String\Slugger\AsciiSlugger;
  47. use Doctrine\Persistence\ManagerRegistry;
  48. use App\Service\EncryptDecryptService;
  51. /**
  52.  * @Route({"en": "/order",
  53.  *          "es": "/orden"})
  54.  */
  55. class OrderController extends AbstractController
  56. {
  57.     private $emailApp;
  58.     public const PAGE_ELEMENTS = 25;
  59.     private $translator;
  60.     private $orderRepository;
  61.     private $util;
  62.     private $pdf;
  63.     private $orderService;
  64.     private $partService;
  65.     private $em;
  66.     private $partDir;
  68.     public function __construct(
  69.         string $emailApp,
  70.         TranslatorInterface $translator,
  71.         OrderRepository $orderRepository,
  72.         UtilService $utilService,
  73.         OrderService $orderService,
  74.         PartService $partService,
  75.         Pdf $knpSnappyPdf,
  76.         ManagerRegistry $doctrine,
  77.         string $partDir,
  78.         private EncryptDecryptService $encryptDecryptService)
  79.     {
  80.         $this->emailApp = $emailApp;
  81.         $this->translator = $translator;
  82.         $this->util = $utilService;
  83.         $this->pdf = $knpSnappyPdf;
  84.         $this->orderRepository = $orderRepository;
  85.         $this->orderService = $orderService;
  86.         $this->partService = $partService;
  87.         $this->em = $doctrine->getManager();
  88.         $this->partDir = $partDir;
  89.     }
  91.     /**
  92.      * @Route({"en": "/list",
  93.      *         "es": "/listado"}, name="order_index", methods={"GET","POST"})
  94.      */
  95.     public function index(Request $request, OrderRepository $orderRepository, PaginatorInterface $paginator): Response
  96.     {
  97.         $admin =$this->getUser();
  98.         $ms = $this->util->getLicenseField($admin->getCompany(),'multi_select') && $admin->getRole()!='ROLE_CLIENT';
  100.         if($admin == NULL){
  101.             return $this->redirectToRoute('app_login');
  102.         }
  104.         $search = [];
  105.         $form = $this->createForm(OrderSearchType::class, $search, ['user_admin' => $admin,'method' => 'GET']);
  106.         $form->handleRequest($request);
  107.         $orderBy = null;
  108.         $filters = [
  110.             ['field'=>'company','title'=>'Empresa'],
  111.             ['field'=>'ref','title'=>'Referencia'],
  112.             ['field'=>'part','title'=>'Pieza'],
  113.             ['field'=>'supplier','title'=>'Centro de trabajo'],
  114.             ['field'=>'units','title'=>'Unidades'],
  115.             ['field'=>'updated_at','title'=>'Última modificación'],
  116.             ['field'=>'state','title'=>'Estado']
  117.         ];
  119.         if ($form->isSubmitted() && $form->isValid())
  120.         {
  121.             $orderBy = $request->query->get('order_by');
  122.             $orders = $orderRepository->findByName($form->getData(), $admin, $orderBy);
  124.         } else {
  125.             $orders = $orderRepository->buscarTodos($admin);
  126.         }
  128.         if($request->isMethod('POST')){
  130.             if($request->request->get('orders_delete')){
  131.                 $delIds = $request->request->get('delIds',null);
  133.                 if($delIds){
  134.                     $orders = explode(',', $delIds);
  135.                     $successMsg = '';
  136.                     $errorMsg = '';
  137.                     foreach($orders as $orderId){
  138.                         $order = $this->em->getRepository(Order::class)->find($orderId);
  139.                         if($order){
  140.                             $rmOrder = $this->rmOrder($order);
  141.                             if($rmOrder['error']){
  142.                                 $errorMsg.= $this->translator->trans('Error orden {ref} : ',['{ref}'=>$order->getRef()]) . $rmOrder['msg'].'<br>';
  143.                             }
  144.                             else{
  145.                                 $successMsg.= $this->translator->trans('Orden {ref} eliminada correctamente',['{ref}'=>$order->getRef()]).'<br>';
  146.                             }
  147.                         }
  148.                     }
  150.                     if($successMsg){
  151.                         $this->addFlash('success', $successMsg);
  152.                     }
  154.                     if($errorMsg){
  155.                         $this->addFlash('danger', $successMsg);
  156.                     }
  158.                     return $this->redirectToRoute('order_index');
  159.                 }
  160.             }
  161.         }
  163.         // Creating pagnination
  164.         $pagination = $paginator->paginate(
  165.             $orders,
  166.             $request->query->getInt('page', 1),
  167.             self::PAGE_ELEMENTS
  168.         );
  170.         return $this->render('order/index.html.twig', [
  171.             'pagination' => $pagination,
  172.             'search_form' => $form->createView(),
  173.             'filters' => $filters,
  174.             'order_by' => $orderBy,
  175.             'ms' => $ms,
  176.             'user' => $this->getUser(),
  177.             'navbarTitle' => $this->translator->trans("Órdenes de trabajo")
  178.         ]);
  179.     }
  180.     /**
  181.      * @Route({"en": "/new/prototype",
  182.      *         "es": "/nuevo/prototipo"}, name="order_prototype_new", methods={"GET","POST"})
  183.      */
  184.     public function ºnewPrototype(Request $request, MailerInterface $mailer, OrderRepository $orderRepository): Response
  185.     {
  186.         $em = $this->em;
  187.         $admin = $this->getUser();
  188.         $order = new Order();
  189.         $order->setUnits(1);
  190.         $order->setType(2);
  192.         $this->denyAccessUnlessGranted(OrderVoter::CREATE, $order);
  194.         $fileMaxsizes = $this->util->getCompanyFileMaxsizes($admin->getCompany());
  197.         $cs = $em->getRepository(CompanySupplier::class)->findOneBy(['company'=>$this->getUser()->getCompany(),'supplier'=>$order->getSupplier()]);
  198.         $form = $this->createForm(OrderPrototypeType::class, $order, ['user_admin' => $admin, 'part' => null, 'cs'=>$cs,'file_maxsizes' => $fileMaxsizes]);
  199.         $form->handleRequest($request);
  201.         if ($form->isSubmitted() && $form->isValid()) {
  203.             $createOrder = $this->createOrder($order);
  204.             if($createOrder['error']) {
  205.                 $this->addFlash('danger', 'error: ' . $createOrder['msg']);
  207.             }
  208.             $this->processOtherFiles($form, $order, 5);
  209.             $em->persist($order);
  210.             $em->flush();
  211.             return $this->redirectToRoute('order_index');
  212.         }
  214.         return $this->render('order/new.html.twig', [
  215.             'order' => $order,
  216.             //'cs' => $cs,
  217.             'form' => $form->createView(),
  218.             'user' => $this->getUser(),
  219.             'navbarTitle' => $this->translator->trans("Solicitar presupuesto")
  220.         ]);
  221.     }
  222.     /**
  223.      * @Route({"en": "/new/{part}",
  224.      *         "es": "/nueva/{part}"}, name="order_new", methods={"GET","POST"})
  225.      */
  226.     public function new(Request $request, MailerInterface $mailer, Part $part, OrderRepository $orderRepository): Response
  227.     {
  228.         $em = $this->em;
  229.         $admin = $this->getUser();
  230.         $order = new Order();
  231.         $order->setType(1);
  234.         $this->denyAccessUnlessGranted(OrderVoter::CREATE, $order);
  236.         $cs = $em->getRepository(CompanySupplier::class)->findOneBy(['company'=>$part->getCompany(),'supplier'=>$part->getSupplier()]);
  237.         $form = $this->createForm(OrderType::class, $order, ['user_admin' => $admin, 'part' => $part, 'cs'=>$cs]);
  238.         $form->handleRequest($request);
  240.         if ($form->isSubmitted() && $form->isValid()) {
  242.             $initMsg = $this->translator->trans('Pieza') . ' ' . $part->getRef() . ': ';
  243.             $createOrder = $this->createOrder($order);
  244.             if($createOrder['error']){
  245.                 $this->addFlash('danger', $initMsg . $createOrder['msg']);
  246.             }
  247.             else{
  248.                 $this->addFlash('success', $initMsg . $this->translator->trans('Orden creada correctamente'));
  249.             }
  251.             return $this->redirectToRoute('order_index');
  252.         }
  254.         return $this->render('order/new.html.twig', [
  255.             'order' => $order,
  256.             'cs' => $cs,
  257.             'form' => $form->createView(),
  258.             'user' => $this->getUser(),
  259.             'navbarTitle' => $this->translator->trans("Solicitar presupuesto")
  260.         ]);
  261.     }
  265.     private function processOtherFiles(FormInterface $form, Order $order, $limit=5){
  266.         $files = $form->get('filesOrder')->getData();
  268.         if(count($files)>0){
  269.             $slugger = new AsciiSlugger();
  270.             $filenames = !empty($order->getFilesOrder()) ? explode(',',$order->getFilesOrder()) : [];
  272.             try {
  273.                 foreach($files as $file)
  274.                 {
  276.                     $originalFilename = pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME);
  277.                     $safeFilename = $slugger->slug($originalFilename);
  278.                     $newFilename = $safeFilename.'-'.uniqid().'.'.$file->getClientOriginalExtension();
  280.                     if(!in_array($newFilename,$filenames)){
  282.                         if(count($filenames)>$limit){
  283.                             $this->addFlash('warning', $this->translator->trans('Se excedió el ḿaximo de archivos que se pueden cargar'));
  284.                             break;
  285.                         }
  286.                         else{
  288.                             $file->move($this->partDir, $newFilename);
  290.                             $filenames[]=$newFilename;
  292.                             $order->setFilesOrder(implode(',',$filenames));
  294.                         }
  295.                     }
  296.                 }
  297.             }
  298.             catch (FileException $e) {
  299.                 $this->addFlash('danger', $this->translator->trans('Fallo en la carga de fichero'));
  300.             }
  301.         }
  302.     }
  304.     /**
  305.      * @Route({"en": "/new/bulk/{partIds}",
  306.      *         "es": "/nueva/masiva/{partIds}"}, name="order_bulk_new", methods={"GET","POST"})
  307.      */
  308.     public function newBulk(Request $request, OrderRepository $orderRepository, string $partIds): Response
  309.     {
  310.         $user =$this->getUser();
  311.         $em = $this->em;
  312.         $qb = $em->createQueryBuilder();
  314.         if($user == NULL){
  315.             return $this->redirectToRoute('app_login');
  316.         }
  318.         $decodedPartIds = explode(',',base64_decode($partIds));
  319.         $parts = [];
  320.         foreach($decodedPartIds as $partId){
  321.             $part = $this->em->getRepository(Part::class)->find($partId);
  322.             if($part && $part->getSupplier() && $part->getCompany()==$user->getCompany() && !$part->getLocked()){
  323.                 $parts[] = $part;
  324.             }
  325.         }
  327.         if(empty($parts)){
  328.             $this->addFlash('danger', $this->translator->trans('Error inesperado'));
  329.             return $this->redirectToRoute('part_index');
  330.         }
  332.         if($request->isMethod('POST')){
  333.             $orders = (array) $request->request->get('orders');
  334.             if(!empty($orders) && count($orders)==4){
  335.                 $errorMsg = [];
  336.                 $successMsg = [];
  338.                 for($i=0;$i<count($orders['parts']);$i++){
  339.                     $partId = $orders['parts'][$i];
  341.                     $part = $em->getRepository(Part::class)->find($partId);
  342.                     if(!empty($part)){
  344.                         $shippingAddress = null;
  345.                         if(!empty($orders['shipping_address'][$i])){
  346.                             $shippingAddress = $em->getRepository(CompanyAddress::class)->find($orders['shipping_address'][$i]);
  347.                         }
  349.                         $order = new Order();
  350.                         $order->setPart($part);
  351.                         $order->setCompany($part->getCompany());
  352.                         $order->setSupplier($part->getSupplier());
  353.                         $order->setUser($user);
  354.                         $order->setShippingAddress($shippingAddress);
  355.                         $order->setUnits($orders['units'][$i]);
  356.                         $order->setObservations($orders['observations'][$i]);
  358.                         $initMsg = $this->translator->trans('Pieza') . ' ' . $part->getRef() . ': ';
  359.                         $createOrder = $this->createOrder($order);
  360.                         if($createOrder['error']){
  361.                             $errorMsg[] = $initMsg . $createOrder['msg'];
  362.                         }
  363.                         else{
  364.                             $successMsg[]=$initMsg . $this->translator->trans('Orden creada correctamente');
  365.                         }
  366.                     }
  367.                     else{
  368.                         $errorMsg[] = $this->translator->trans('Pieza') . ' [' . $partId . ']: ' . $this->translator->trans('Error inesperado');
  369.                     }
  370.                 }
  372.                 if($errorMsg){
  373.                     $this->addFlash('danger', implode('<br>',$errorMsg));
  374.                 }
  376.                 if($successMsg){
  377.                     $this->addFlash('success', implode('<br>',$successMsg));
  378.                 }
  380.                 return $this->redirectToRoute('order_index');
  381.             }
  382.             else{
  383.                 $this->addFlash('danger', $this->translator->trans('Error inesperado'));
  384.                 return $this->redirectToRoute('order_bulk_new',['partIds'=>$partIds]);
  385.             }
  387.         }
  389.         return $this->render('order/bulk_new.html.twig', [
  390.             'parts' => $parts,
  391.             'user' => $user,
  392.             'navbarTitle' => $this->translator->trans("Nuevas órdenes de trabajo")
  393.         ]);
  394.     }
  396.     private function createOrder(Order $order){
  397.         $em = $this->em;
  398.         $orderRepository = $this->orderRepository;
  399.         if($order->getPart()) {
  400.             $part = $order->getPart();
  401.         }
  403.         $user = $this->getUser();
  404.         $roleClient = $user->getRole()=='ROLE_CLIENT';
  405.         $result = ['error'=>false,'msg'=>''];
  406.         if($order->getType() == 1) {
  407.             $company = $part->getCompany();
  408.         } else {
  409.             $company = $user->getCompany();
  410.         }
  411.         $lastRef = $orderRepository->findLastRef($company);
  412.         if($order->getType() == 1) {
  413.             $supplierId = $part->getSupplier();
  414.         } else {
  415.             $supplierId = $order->getSupplier();
  416.         }
  417.         $cs = $em->getRepository(CompanySupplier::class)->findOneBy(['company'=>$company,'supplier'=> $supplierId]);
  419.         $budgetRequired = $cs ? $cs->getConfigStepBudget() : true;
  420.         $chiefConfirm = $cs ? $cs->getConfigStepChiefConfirm() : true;
  422.         $order->setRef($lastRef);
  423.         $order->setChiefConfirm($chiefConfirm);
  424.         $order->setBudgetRequired($budgetRequired);
  425.         $order->setUnitsDecrypted($order->getUnits());
  428.         try
  429.         {
  430.             if(!$order->getId()){
  431.                 $em->persist($order);
  432.             }
  434.             //Bloqueo de pieza
  435.             if($order->getType() == 1) {
  436.                 $part = $order->getPart();
  437.                 $part->setLocked(true);
  438.                 $part->setLockedAt(new \DateTime());
  439.                 $part->setLockedUser(null);
  440.             }
  443.             $em->flush();
  445.             $data['message']='Nueva orden creada';
  446.             $data['reference']=$order->getRef();
  447.             $data['path_name']='order_show';
  448.             $data['path_parameters']='id:'.$order->getId();
  450.             //Notificaciones - cliente
  451.             $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  452.             if(!$roleClient && $order->getCompany()!=$order->getSupplier()->getCompany()){
  453.                 //Notificaciones - proveedor
  454.                 $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  455.             }
  457.         } catch ( UniqueConstraintViolationException $e) {
  458.             $result['error']=true;
  459.             $result['msg'] = $this->translator->trans('Ya existe una orden de trabajo para esta pieza');
  460.         }
  462.         return $result;
  463.     }
  465.     /**
  466.      * @Route({"en": "/show/{id}",
  467.      *         "es": "/mostrar/{id}"}, name="order_show", methods={"GET","POST"})
  468.      */
  469.     public function show(Request $request, Order $order, OrderRepository $orderRepository): Response
  470.     {
  471.         $this->denyAccessUnlessGranted(OrderVoter::VIEW, $order);
  473.         $em = $this->em;
  474.         $fs = new Filesystem();
  475.         $slugger = new AsciiSlugger();
  476.         $ds = DIRECTORY_SEPARATOR;
  477.         $ordersDir = $this->getParameter('kernel.project_dir').$ds.'public'.$ds.'orders';
  478.         $user = $this->getUser();
  479.         $role = $user->getRole();
  480.         if($order->getType() == 1){
  481.             $company = $order->getPart()->getCompany();
  482.         } else {
  483.             $company = $order->getCompany();
  484.         }
  485.         $fileMaxsizes = $this->util->getCompanyFileMaxsizes($company);
  487.         //Formulario envío de presupuesto
  488.         $formBudget = $this->createForm(OrderBudgetType::class, $order, ['user' => $user, 'file_maxsizes' => $fileMaxsizes]);
  490.         //Formulario envío de presupuesto
  491.         $formFiles = $this->createForm(OrderFilesType::class, $order, [ 'file_maxsizes' => $fileMaxsizes]);
  493.         //Formulario observaciones y carga archivos proveedor
  494.         $form = $this->createForm(OrderSupplierType::class, $order, ['user' => $user, 'part' => $order->getPart(), 'file_maxsizes' => $fileMaxsizes]);
  496.         if(!in_array($role,['ROLE_SUPPLIER_CHIEF','ROLE_SUPPLIER'])) {
  498.             $formFiles->handleRequest($request);
  499.             if ($formFiles->isSubmitted()) {
  500.                 if ($formFiles->isValid()) {
  501.                     $this->processOtherFiles($formFiles, $order, 5);
  502.                     $em->persist($order);
  503.                     $em->flush();
  504.                 } else {
  505.                     $this->addFlash('danger', $this->translator->trans('Ha habido un error al procesar el formulario, revise los campos'));
  506.                 }
  507.             }
  508.         }
  514.         if(in_array($role,['ROLE_SUPPLIER_CHIEF','ROLE_SUPPLIER'])){
  515.             //Formulario envío de presupuesto
  516.             $formBudget->handleRequest($request);
  518.             if($formBudget->isSubmitted()){
  520.                 if($formBudget->isValid()){
  521.                     $files = $request->files->get('order_budget')['files_budget'];
  522.                     $payTermsId = $form->getData()->getPaymentTermsId();
  523.                     $filenames = !empty($order->getFilesBudget()) ? explode(',',$order->getFilesBudget()) : [];
  524.                     $filesLimit = 5;
  526.                     if(count($files)>0){
  527.                         try {
  528.                             if(!$fs->exists($ordersDir)){
  529.                                 $fs->mkdir($ordersDir);
  530.                             }
  532.                             foreach($files as $file)
  533.                             {
  534.                                 $originalFilename = pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME);
  535.                                 $safeFilename = $slugger->slug($originalFilename);
  536.                                 $newFilename = $safeFilename.'-budget-'.uniqid().'.'.$file->getClientOriginalExtension();
  538.                                 if(!in_array($newFilename,$filenames)){
  539.                                     $filenames[]=$newFilename;
  540.                                     if(count($filenames)>$filesLimit){
  541.                                         $this->addFlash('warning', $this->translator->trans('Se excedió el ḿaximo de archivos que se pueden cargar'));
  542.                                         break;
  543.                                     }
  544.                                     else{
  545.                                         $file->move($ordersDir, $newFilename);
  546.                                         $order->setFilesBudget(implode(',',$filenames));
  547.                                     }
  548.                                 }
  549.                             }
  550.                         }
  551.                         catch (FileException $e) {
  552.                             $this->addFlash('danger', $this->translator->trans('Fallo en la carga de fichero'));
  553.                         }
  554.                         catch (IOExceptionInterface $e) {
  555.                             $this->addFlash('danger', $this->translator->trans('No se ha podido generar el directorio').' : '.$e->getPath());
  556.                         }
  557.                     }
  559.                     $order->setState(1);
  560.                     $order->setBudgetDate(new \DateTime());
  561.                     $order->markAsAproved();
  562.                     $order->setPaymentTerms($orderRepository->getPaymentTermsText($payTermsId));
  563.                     $em->persist($order);
  564.                     $em->flush();
  565.                     $this->addFlash('success', $this->translator->trans('Presupuesto enviado correctamente'));
  567.                     return $this->redirectToRoute('order_index');
  568.                 }
  569.                 else{
  570.                     $this->addFlash('danger', $this->translator->trans('Ha habido un error al procesar el formulario, revise los campos'));
  571.                 }
  572.             }
  574.             //Formulario observaciones y carga archivos proveedor
  575.             $form->handleRequest($request);
  577.             if($form->isSubmitted()){
  578.                 if($form->isValid()){
  579.                     $obs = $request->get('order_supplier');
  580.                     $files = $request->files->get('order_supplier')['files'];
  581.                     $filenames = !empty($order->getFilesSupplier()) ? explode(',',$order->getFilesSupplier()) : [];
  582.                     $filesLimit = 5;
  584.                     if(count($files)>0){
  585.                         try {
  586.                             if(!$fs->exists($ordersDir)){
  587.                                 $fs->mkdir($ordersDir);
  588.                             }
  590.                             foreach($files as $file)
  591.                             {
  592.                                 $originalFilename = pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME);
  593.                                 $safeFilename = $slugger->slug($originalFilename);
  594.                                 $newFilename = $safeFilename.'-report-'.uniqid().'.'.$file->getClientOriginalExtension();
  596.                                 if(!in_array($newFilename,$filenames)){
  597.                                     $filenames[]=$newFilename;
  598.                                     if(count($filenames)>$filesLimit){
  599.                                         $this->addFlash('warning', $this->translator->trans('Se excedió el ḿaximo de archivos que se pueden cargar'));
  600.                                         break;
  601.                                     }
  602.                                     else{
  603.                                         $file->move($ordersDir, $newFilename);
  604.                                         $order->setFilesSupplier(implode(',',$filenames));
  605.                                     }
  606.                                 }
  607.                             }
  608.                         }
  609.                         catch (FileException $e) {
  610.                             $this->addFlash('danger', $this->translator->trans('Fallo en la carga de fichero'));
  611.                         }
  612.                         catch (IOExceptionInterface $e) {
  613.                             $this->addFlash('danger', $this->translator->trans('No se ha podido generar el directorio').' : '.$e->getPath());
  614.                         }
  615.                     }
  617.                     $em->persist($order);
  618.                     $em->flush();
  619.                     $this->addFlash('success', $this->translator->trans('Orden editada correctamente'));
  621.                     return $this->redirectToRoute('order_show',['id'=>$order->getId()]);
  622.                 }
  623.                 else{
  624.                     $this->addFlash('danger', $this->translator->trans('Ha habido un error al procesar el formulario, revise los campos'));
  625.                 }
  626.             }
  628.             if($request->query->has('rm')){
  629.                 $type = $request->query->has('type') && $request->query->get('type')==1 ? 1 : 2;
  630.                 $filenames =  explode(',',($type==1 ? $order->getFilesBudget() : $order->getFilesSupplier()));
  631.                 $index = $request->query->get('rm');
  633.                 if(!empty($filenames[$index])){
  634.                     $fileToRemove = $filenames[$index];
  635.                     if($fs->exists($ordersDir.$ds.$fileToRemove)){
  636.                         try {
  637.                             $fs->remove($ordersDir.$ds.$fileToRemove);
  638.                             unset($filenames[$index]);
  639.                             if($type==1){
  640.                                 $order->setFilesBudget(implode(',',$filenames));
  641.                             }
  642.                             else{
  643.                                 $order->setFilesSupplier(implode(',',$filenames));
  644.                             }
  646.                             $em->flush();
  648.                             $this->addFlash('success', $this->translator->trans('Archivo eliminado correctamente'));
  649.                         } catch (IOExceptionInterface $exception) {
  650.                             $this->addFlash('danger',$this->translator->trans('No se ha podido eliminar el archivo'));
  651.                         }
  652.                     }
  653.                 }
  654.                 return $this->redirectToRoute('order_show',['id'=>$order->getId()]);
  656.             }
  657.         }
  659.         if($request->query->get('download')){
  661.             $url = $this->generateUrl('order_show',['id'=>$order->getId()], UrlGeneratorInterface::ABSOLUTE_URL);
  662.             $qr = $this->util->generateQrCode($url);
  664.             if($request->query->get('download')==1){
  665.                 $options = [
  666.                     'page-size' => 'A6',
  667.                     'orientation'=>'Landscape'
  668.                 ];
  670.                 $html =$this->renderView('order/pdf/tag.html.twig', [
  671.                     'order' => $order,
  672.                     'qr' => $qr,
  673.                     'user' => $user
  674.                 ]);
  676.                 return new PdfResponse(
  677.                     $this->pdf->getOutputFromHtml($html, $options),
  678.                     $order->getRef().'_'.$this->translator->trans('etiqueta').'.pdf'
  679.                 );
  681.             }
  682.             else{
  684.                 $header = $this->renderView( 'order/pdf/report_header.html.twig',[
  685.                     'order' => $order,
  686.                     'partByCat' => $this->partService->getPartByCat($order->getPart()),
  687.                     'qr' => $qr,
  688.                     'preview' => $order->getPart()->getFilePreview() ? $this->partDir . DIRECTORY_SEPARATOR . $order->getPart()->getFilePreview() : '',
  689.                     'user' => $user
  690.                 ] );
  692.                 $footer = $this->renderView( 'order/pdf/report_footer.html.twig',[
  693.                     'order' => $order,
  694.                     'partByCat' => $this->partService->getPartByCat($order->getPart()),
  695.                     'qr' => $qr,
  696.                     'user' => $user
  697.                 ] );
  699.                 $options = [
  700.                     'header-html' => $header,
  701.                     'footer-html' => $footer,
  702.                     'page-size' => 'A4'
  703.                 ];
  705.                 $html =$this->renderView('order/pdf/report.html.twig', [
  706.                     'order' => $order,
  707.                     'sum' => $this->orderService->getOrderSummary($order),
  708.                     'partByCat' => $this->partService->getPartByCat($order->getPart()),
  709.                     'qr' => $qr,
  710.                     'user' => $user
  711.                 ]);
  713.                 return new PdfResponse(
  714.                     $this->pdf->getOutputFromHtml($html, $options),
  715.                     $order->getRef().'_'.$this->translator->trans('hoja_produccion').'.pdf'
  716.                 );
  717.             }
  718.         }
  720.         if ($request->getMethod()=='POST') {
  722.             if ($this->isCsrfTokenValid('initiate'.$order->getId(), $request->request->get('_token'))) {
  723.                 $said = $request->request->get('shipping_address');
  724.                 $type = $request->request->get('request_order') ? 1 : 2;
  726.                 if($type==1){
  727.                     if($said>0){
  728.                         $shipping_address = $em->getRepository(CompanyAddress::class)->find($said);
  729.                         $order->setShippingAddress($shipping_address);
  730.                     }
  732.                     $order->setState(0);
  733.                 }
  734.                 else{
  735.                     $order->setState(6);
  736.                     $order->setRejectUser($user);
  737.                     $order->setRejectDate(new \DateTime());
  738.                 }
  740.                 $order->markAsAproved(); //updated
  741.                 $em->flush();
  743.                 $data['message']='Orden de cliente solicitada';
  744.                 $data['reference']=$order->getRef();
  745.                 $data['path_name']='order_show';
  746.                 $data['path_parameters']='id:'.$order->getId();
  748.                 //Notificaciones - cliente
  749.                 $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  750.                 if($order->getCompany()!=$order->getSupplier()->getCompany()){
  751.                     //Notificaciones - proveedor
  752.                     $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  753.                 }
  755.                 $this->addFlash('success', $this->translator->trans('Orden de cliente solicitada'));
  757.                 return $this->redirectToRoute('order_index');
  758.             }
  759.         }
  761.         $addresses = null;
  762.         if($order->getState()==7 and $order->getPart()){
  763.             $addresses = $em->createQueryBuilder()
  764.                 ->select('ca')
  765.                 ->from(CompanyAddress::class,'ca')
  766.                 ->where("ca.company = {$order->getPart()->getSupplier()->getCompany()->getId()}")
  767.                 ->orderBy('ca.name', 'ASC')->getQuery()->getResult();
  768.         }
  770.         $prototypes = null;
  771.         $canCreateProto =  true;
  772.         if($order->getType() == 2) {
  773.             $prototypes = $em->getRepository(Part::class)->findBy(['prototypeOrder'=>$order->getId()]);
  774.             if($prototypes) {
  775.                 foreach ($prototypes as $prototype) {
  776.                     if($prototype->getPrototypeStatus() != Part::REFUSED ) {
  777.                         $canCreateProto = false;
  778.                     }
  779.                 }
  780.             }
  781.         }
  784.         return $this->render('order/show.html.twig', [
  785.             'order' => $order,
  786.             'cs' => $em->getRepository(CompanySupplier::class)->findOneBy(['company'=>$company,'supplier'=>$order->getSupplier()]),
  787.             'user' => $user,
  788.             'fileMaxsizes' => $fileMaxsizes,
  789.             'form' => $form ? $form->createView() : null,
  790.             'formBudget' => $formBudget->createView(),
  791.             'formFiles' => $formFiles->createView(),
  792.             'addresses' => $addresses,
  793.             'navbarTitle' => $this->translator->trans("Orden de trabajo").' - '.$order->getRef(),
  794.             'prototypes' => $prototypes,
  795.             'canCreateProto' => $canCreateProto
  796.         ]);
  798.     }
  800.     /**
  801.      * @Route({"en": "/edit/{id}/{part}",
  802.      *         "es": "/editar/{id}/{part}"}, name="order_edit", methods={"GET","POST"})
  803.      */
  804.     public function edit(Request $request, Order $order, Part $part): Response
  805.     {
  806.         $this->denyAccessUnlessGranted(OrderVoter::EDIT, $order);
  808.         $admin = $this->getUser();
  809.         $form = $this->createForm(OrderType::class, $order, ['user_admin' => $admin, 'part' => $part]);
  810.         $form->handleRequest($request);
  812.         if ($form->isSubmitted() && $form->isValid()) {
  813.             $order->markAsAproved();
  814.             $this->em->flush();
  816.             $this->addFlash('success', $this->translator->trans('Orden editada correctamente'));
  818.             return $this->redirectToRoute('order_index');
  819.         }
  821.         return $this->render('order/edit.html.twig', [
  822.             'order' => $order,
  823.             'form' => $form->createView(),
  824.             'user' => $this->getUser(),
  825.             'navbarTitle' => $this->translator->trans("Editar orden").' - '.$order->getRef()
  826.         ]);
  827.     }
  829.     /**
  830.      * @Route({"en": "/accept/{id}",
  831.      *         "es": "/aceptar/{id}"}, name="order_accept", methods={"POST"})
  832.      */
  833.     public function accept(Request $request, MailerInterface $mailer, Order $order, OrderRepository $orderRepository): Response
  834.     {
  835.         $this->denyAccessUnlessGranted(OrderVoter::ACCEPT, $order);
  837.         if ($this->isCsrfTokenValid('accept'.$order->getId(), $request->request->get('_token'))) {
  838.             $entityManager = $this->em;
  839.             $user = $this->getUser();
  840.             $role = $user->getRole();
  841.             $currentState = $order->getState();
  843.             if(!in_array($order->getState(),[1,2])){
  844.                 $this->addFlash('danger', $this->translator->trans('El presupuesto ya estaba aceptado'));
  845.                 return $this->redirectToRoute('order_index');
  846.             }
  848.             if($order->getState()==2 && $order->getChiefConfirm() && $role=='ROLE_USER'){
  849.                 $this->addFlash('danger', $this->translator->trans('Requiere confirmación del usuario administrador'));
  850.                 return $this->redirectToRoute('order_index');
  851.             }
  853.             $state = $order->getState() == 1 ? 2 : 3;
  855.             // we dont want that a client use basket
  856.             if($role=='ROLE_CLIENT') {
  857.                 $state = 3;
  858.             }
  860.             $acceptRef=null;
  861.             if($state==3){
  862.                 $acceptRef = $orderRepository->getNewAcceptRef($order->getCompany());
  863.             }
  865.             $order->setState($state);
  866.             $order->setAcceptRef($acceptRef);
  867.             $order->markAsAproved();
  868.             $order->setApproveDate(new \DateTime());
  869.             if($role=='ROLE_USER'){
  870.                 $order->setApproveUserUser($user);
  871.                 $order->setApproveUserDate(new \DateTime());
  872.             }
  873.             else{
  874.                 $order->setApproveChiefUser($user);
  875.                 $order->setApproveChiefDate(new \DateTime());
  876.             }
  878.             $entityManager->persist($order);
  879.             $entityManager->flush();
  881.             if($state==3 && $order->getType() == 1){
  882.                 try {
  883.                     //Si existen archivos encriptados se les asignan los grants correspondientes
  884.                     $this->encryptDecryptService->encryptPartGrants($order->getPart(), $order->getUnits());
  885.                 } catch (\Exception $e) {
  886.                     $this->addFlash('warning', $e->getMessage());
  887.                 }
  888.             }
  890.             $adminEmail = $this->em->getRepository(User::class)->findOneBy(['role' => 'ROLE_ADMIN'])->getEmail();
  891.             $email = (new TemplatedEmail())
  892.             ->from(new Address($this->emailApp, 'Addvance3D'))
  893.             ->to($order->getUser()->getEmail())
  894.             ->bcc($adminEmail)
  895.             ->subject('Orden de trabajo aceptada')
  896.             ->htmlTemplate('order/email/acceptedEmail.html.twig')
  897.             ->context([
  898.                 'order' => $order,
  899.                 'user' => $user
  900.             ]);
  902.             $mailer->send($email);
  904.             $this->addFlash('success', $this->translator->trans('Presupuesto aceptado'));
  906.             $data['message']='Presupuesto aceptado';
  907.             $data['reference']=$order->getRef();
  908.             $data['path_name']='order_show';
  909.             $data['path_parameters']='id:'.$order->getId();
  911.             //Notificaciones - cliente
  912.             $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  913.             if($order->getCompany()!=$order->getSupplier()->getCompany() && $state==3){
  914.                 //Notificaciones - proveedor
  915.                 $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  916.             }
  917.         }
  919.         return $this->redirectToRoute('order_index');
  920.     }
  922.     /**
  923.      * @Route({"en": "/accept/supplier/{id}",
  924.      *         "es": "/aceptar/proveedor/{id}"}, name="order_accept_supplier", methods={"POST"})
  925.      */
  926.     public function acceptSupplier(Request $request, MailerInterface $mailer, Order $order, OrderRepository $orderRepository): Response
  927.     {
  928.         $this->denyAccessUnlessGranted(OrderVoter::ACCEPT_SUPPLIER, $order);
  930.         if ($this->isCsrfTokenValid('accept'.$order->getId(), $request->request->get('_token'))) {
  931.             $entityManager = $this->em;
  932.             $user = $this->getUser();
  933.             $role = $user->getRole();
  934.             $currentState = $order->getState();
  936.             if ($currentState==0)
  937.             {
  938.                 $acceptRef = $orderRepository->getNewAcceptRef($order->getCompany());
  939.                 $order->setState(3);
  940.                 $order->setAcceptRef($acceptRef);
  941.                 $order->markAsAproved();
  942.                 $order->setApproveSupplierUser($user);
  943.                 $order->setApproveSupplierDate(new \DateTime());
  944.                 $order->setApproveDate(new \DateTime());
  946.                 $entityManager->persist($order);
  947.                 $entityManager->flush();
  949.                 try {
  950.                     //Si existen archivos encriptados se les asignan los grants correspondientes para fabricacion
  951.                     if($order->getType() == 1) {
  952.                         $this->encryptDecryptService->encryptPartGrants($order->getPart(), $order->getUnits());
  953.                     }
  955.                 } catch (\Exception $e) {
  956.                     $this->addFlash('warning', $e->getMessage());
  957.                 }
  959.                 $adminEmail = $this->em->getRepository(User::class)->findOneBy(['role' => 'ROLE_ADMIN'])->getEmail();
  960.                 $email = (new TemplatedEmail())
  961.                 ->from(new Address($this->emailApp, 'Addvance3D'))
  962.                 ->to($adminEmail)
  963.                 ->addTo($order->getUser()->getEmail())
  964.                 ->subject('Orden de trabajo aceptada')
  965.                 ->htmlTemplate('order/email/acceptedEmail.html.twig')
  966.                 ->context([
  967.                     'order' => $order,
  968.                     'user' => $user
  969.                 ]);
  971.                 $mailer->send($email);
  973.                 $this->addFlash('success', $this->translator->trans('Orden de trabajo aceptada'));
  975.                 $data['message']='Orden de trabajo aceptada';
  976.                 $data['reference']=$order->getRef();
  977.                 $data['path_name']='order_show';
  978.                 $data['path_parameters']='id:'.$order->getId();
  980.                 //Notificaciones - cliente
  981.                 $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  982.                 if($order->getCompany()!=$order->getSupplier()->getCompany()){
  983.                     //Notificaciones - proveedor
  984.                     $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  985.                 }
  986.             }else{
  987.                 $this->addFlash('danger', $this->translator->trans('La orden de trabajo ya estaba aceptada'));
  988.             }
  989.         }
  991.         return $this->redirectToRoute('order_index');
  992.     }
  994.     /**
  995.      * @Route({"en": "/reject/{id}",
  996.      *         "es": "/rechazar/{id}"}, name="order_reject", methods={"POST"})
  997.      */
  998.     public function reject(Request $request, MailerInterface $mailer, Order $order): Response
  999.     {
  1000.         $this->denyAccessUnlessGranted(OrderVoter::REJECT, $order);
  1002.         if ($this->isCsrfTokenValid('reject'.$order->getId(), $request->request->get('_token'))) {
  1003.             $entityManager = $this->em;
  1004.             $user = $this->getUser();
  1005.             $role = $user->getRole();
  1006.             $currentState = $order->getState();
  1008.             if ($currentState!=6)
  1009.             {
  1010.                 $order->setState(6);
  1011.                 $order->markAsAproved();
  1012.                 $order->setRejectUser($user);
  1013.                 $order->setRejectDate(new \DateTime());
  1015.                 $entityManager->persist($order);
  1016.                 $entityManager->flush();
  1018.                 $adminEmail = $this->em->getRepository(User::class)->findOneBy(['role' => 'ROLE_ADMIN'])->getEmail();
  1019.                 $email = (new TemplatedEmail())
  1020.                 ->from(new Address($this->emailApp, 'Addvance3D'))
  1021.                 ->to($adminEmail)
  1022.                 ->addTo($order->getUser()->getEmail())
  1023.                 ->subject('Orden de trabajo rechazada')
  1024.                 ->htmlTemplate('order/email/rejectedEmail.html.twig')
  1025.                 ->context([
  1026.                     'order' => $order,
  1027.                 ]);
  1029.                 $mailer->send($email);
  1031.                 $this->addFlash('success', $this->translator->trans('Presupuesto rechazado'));
  1033.                 $data['message']='Presupuesto rechazado';
  1034.                 $data['reference']=$order->getRef();
  1035.                 $data['path_name']='order_show';
  1036.                 $data['path_parameters']='id:'.$order->getId();
  1038.                 //Notificaciones - cliente
  1039.                 $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1040.                 if($order->getCompany()!=$order->getSupplier()->getCompany()){
  1041.                     //Notificaciones - proveedor
  1042.                     $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1043.                 }
  1044.             }else{
  1045.                 $this->addFlash('danger', $this->translator->trans('El presupuesto ya estaba rechazado'));
  1046.             }
  1047.         }
  1049.         return $this->redirectToRoute('order_index');
  1050.     }
  1052.     /**
  1053.      * @Route("/bulk/accept_reject", name="order_bulk_accept_reject", methods={"POST"})
  1054.      */
  1055.     public function bulk(Request $request, MailerInterface $mailer, OrderRepository $orderRepository): Response
  1056.     {
  1057.         if ($this->isCsrfTokenValid('bulk_accept_reject', $request->request->get('_token'))) {
  1058.             $em = $this->em;
  1059.             $user = $this->getUser();
  1060.             $role = $user->getRole();
  1061.             $state = $request->request->get('type') == 1 ? 3 : 6;
  1062.             $orders = explode(',',$request->request->get('orders'));
  1064.             if ($this->isGranted('ROLE_USER') && !empty($state) && !empty($orders))
  1065.             {
  1066.                 $lastSupplierId=null;
  1067.                 $acceptRef=null;
  1068.                 $ordersRef=[];
  1069.                 foreach($orders as $oid){
  1070.                     $order = $em->getRepository(Order::class)->find($oid);
  1071.                     $order->setState($state);
  1072.                     $order->markAsAproved();
  1073.                     if($state==3){
  1074.                         $order->setApproveDate(new \DateTime());
  1075.                         if($role=='ROLE_USER'){
  1076.                             $order->setApproveUserUser($user);
  1077.                             $order->setApproveUserDate(new \DateTime());
  1078.                         }
  1079.                         else{
  1080.                             $order->setApproveChiefUser($user);
  1081.                             $order->setApproveChiefDate(new \DateTime());
  1082.                         }
  1083.                     }
  1084.                     else{
  1085.                         $order->setRejectUser($user);
  1086.                         $order->setRejectDate(new \DateTime());
  1087.                     }
  1089.                     if($state==3 && empty($acceptRef)){
  1090.                         $acceptRef = $orderRepository->getNewAcceptRef($order->getCompany());
  1091.                     }
  1093.                     $order->setAcceptRef($acceptRef);
  1095.                     if(empty($lastSupplierId)){
  1096.                         $lastSupplierId = $order->getSupplier()->getId();
  1097.                     }
  1098.                     elseif($lastSupplierId != $order->getSupplier()->getId()){
  1099.                         $lastSupplierId = null;
  1100.                         break;
  1101.                     }
  1103.                     $ordersRef[]=$order->getRef();
  1104.                 }
  1106.                 if(!empty($lastSupplierId)){
  1107.                     $em->flush();
  1109.                     if($state==3){
  1110.                         foreach($orders as $oid){
  1111.                             $order = $em->getRepository(Order::class)->find($oid);
  1112.                             try {
  1113.                                 //Si existen archivos encriptados se les asignan los grants correspondientes
  1114.                                 if($order->getType() == 1) {
  1115.                                     $this->encryptDecryptService->encryptPartGrants($order->getPart(), $order->getUnits());
  1116.                                 }
  1118.                             } catch (\Exception $e) {
  1119.                                 $this->addFlash('warning', $e->getMessage());
  1120.                             }
  1121.                         }
  1122.                     }
  1124.                     $subject = $msgFlash = $state==3 ? 'Presupuestos aceptados' : 'Presupuestos rechazados';
  1125.                     $msgType = $state==3 ? 'aprobado' : 'rechazado';
  1126.                     $msg = "El usuario {$user->getName()} {$user->getSurname()} ha $msgType los siguientes presupuestos : ";
  1127.                     $msg.='<ul>';
  1128.                     foreach($ordersRef as $ref){
  1129.                         $msg.="<li>$ref</li>";
  1130.                     }
  1131.                     $msg.='</ul>';
  1133.                     $adminEmail = $this->em->getRepository(User::class)->findOneBy(['role' => 'ROLE_ADMIN'])->getEmail();
  1134.                     $email = (new TemplatedEmail())
  1135.                     ->from(new Address($this->emailApp, 'Addvance3D'))
  1136.                     ->to($adminEmail)
  1137.                     ->subject($this->translator->trans($subject))
  1138.                     ->htmlTemplate('order/email/bulkAcceptedRejectedEmail.html.twig')
  1139.                     ->context([
  1140.                         'msg' => $msg,
  1141.                         'user' => $user
  1142.                     ]);
  1144.                     $mailer->send($email);
  1146.                     $this->addFlash('success', $this->translator->trans($msgFlash));
  1148.                     $data['message']=$msgFlash;
  1150.                     //Notificaciones - cliente
  1151.                     $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1152.                     if($order->getCompany()!=$order->getSupplier()->getCompany()){
  1153.                         //Notificaciones - proveedor
  1154.                         $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1155.                     }
  1156.                 }
  1157.                 else{
  1158.                     $this->addFlash('danger', $this->translator->trans('No se pueden aceptar/rechazar presupuestos de distintos centros de trabajo de forma masiva'));
  1159.                 }
  1160.             }else{
  1161.                 $this->addFlash('danger', $this->translator->trans('Error inesperado'));
  1162.             }
  1163.         }
  1165.         return $this->redirectToRoute('order_shopping');
  1166.     }
  1168.     /**
  1169.      * @Route({"en": "/send/{id}",
  1170.      *         "es": "/enviar/{id}"}, name="order_send", methods={"POST"})
  1171.      */
  1172.     public function send(Request $request, MailerInterface $mailer, Order $order): Response
  1173.     {
  1174.         $this->denyAccessUnlessGranted(OrderVoter::SEND, $order);
  1176.         if ($this->isCsrfTokenValid('send'.$order->getId(), $request->request->get('_token'))) {
  1177.             $entityManager = $this->em;
  1178.             $user = $this->getUser();
  1179.             $role = $user->getRole();
  1180.             $currentState = $order->getState();
  1182.             if ($currentState!=4)
  1183.             {
  1184.                 $order->setState(4);
  1185.                 $order->markAsAproved();
  1186.                 $order->setSendUser($user);
  1187.                 $order->setSendDate(new \DateTime());
  1189.                 $entityManager->persist($order);
  1190.                 $entityManager->flush();
  1192.                 $this->addFlash('success', $this->translator->trans('Orden de trabajo enviada'));
  1194.                 $data['message']='Orden de trabajo enviada';
  1195.                 $data['reference']=$order->getRef();
  1196.                 $data['path_name']='order_show';
  1197.                 $data['path_parameters']='id:'.$order->getId();
  1199.                 //Notificaciones - cliente
  1200.                 $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1201.                 if($order->getCompany()!=$order->getSupplier()->getCompany()){
  1202.                     //Notificaciones - proveedor
  1203.                     $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1204.                 }
  1205.             }else{
  1206.                 $this->addFlash('danger', $this->translator->trans('La orden de trabajo ya estaba enviada'));
  1207.             }
  1208.         }
  1210.         return $this->redirectToRoute('order_index');
  1211.     }
  1213.     /**
  1214.      * @Route({"en": "/complete/{id}",
  1215.      *         "es": "/completar/{id}"}, name="order_complete", methods={"POST"})
  1216.      */
  1217.     public function complete(Request $request, MailerInterface $mailer, Order $order): Response
  1218.     {
  1219.         $this->denyAccessUnlessGranted(OrderVoter::COMPLETE, $order);
  1221.         if ($this->isCsrfTokenValid('complete'.$order->getId(), $request->request->get('_token'))) {
  1222.             $em = $this->em;
  1223.             $user = $this->getUser();
  1224.             $cs = $em->getRepository(CompanySupplier::class)->findOneBy(['company'=>$order->getCompany(),'supplier'=>$order->getSupplier()]);
  1225.             $configInDelivery = $cs ? $cs->getConfigStepInDelivery() : true;
  1227.             if ($order->getState() == 4 || ($order->getState()==3 && !$configInDelivery))
  1228.             {
  1229.                 $order->setState(5);
  1230.                 $order->markAsCompleted();
  1231.                 $order->setCompleteUser($user);
  1232.                 $order->setCompleteDate(new \DateTime());
  1234.                 $em->persist($order);
  1235.                 $em->flush();
  1237.                 $adminEmail = $this->em->getRepository(User::class)->findOneBy(['role' => 'ROLE_ADMIN'])->getEmail();
  1238.                 $email = (new TemplatedEmail())
  1239.                 ->from(new Address($this->emailApp, 'Addvance3D'))
  1240.                 ->to($adminEmail)
  1241.                 ->subject('Orden de trabajo completada')
  1242.                 ->htmlTemplate('order/email/completedEmail.html.twig')
  1243.                 ->context([
  1244.                     'order' => $order,
  1245.                 ]);
  1247.                 if($order->getType()== 2) {
  1248.                     $prototype = $em->getRepository(Part::class)->findOneBy(array('prototypeOrder' => $order->getId(),'prototypeStatus' => Part::UNDER_VALIDATION));
  1249.                     $part = clone ($prototype);
  1250.                     $part->setType(1);
  1251.                     $part->setName($order->getPrototypeName());
  1252.                     $part->setSupplier(null);
  1254.                     $em->persist($part);
  1256.                     $prototype->setPrototypeStatus(Part::VALIDATED);
  1257.                     $em->persist($prototype);
  1259.                     $em->flush();
  1260.                 }
  1263.                 $mailer->send($email);
  1265.                 $this->addFlash('success', $this->translator->trans('Orden de trabajo completada'));
  1267.                 $data['message']='Orden de trabajo completada';
  1268.                 $data['reference']=$order->getRef();
  1269.                 $data['path_name']='order_show';
  1270.                 $data['path_parameters']='id:'.$order->getId();
  1272.                 //Notificaciones - cliente
  1273.                 $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1274.                 if($order->getCompany()!=$order->getSupplier()->getCompany()){
  1275.                     //Notificaciones - proveedor
  1276.                     $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1277.                 }
  1278.             }else{
  1279.                 $this->addFlash('danger', $this->translator->trans('La orden debe estar en entrega'));
  1280.             }
  1281.         }
  1283.         return $this->redirectToRoute('order_index');
  1284.     }
  1286.     /**
  1287.      * @Route({"en": "/delete/{id}",
  1288.      *         "es": "/borrar/{id}"}, name="order_delete", methods={"DELETE"})
  1289.      */
  1290.     public function delete(Request $request, Order $order): Response
  1291.     {
  1292.         $this->denyAccessUnlessGranted(OrderVoter::DELETE, $order);
  1294.         if ($this->isCsrfTokenValid('delete'.$order->getId(), $request->request->get('_token'))) {
  1295.             $rmOrder = $this->rmOrder($order);
  1297.             if($rmOrder['error']){
  1298.                 $this->addFlash('danger', $rmOrder['msg']);
  1299.             }
  1300.             else{
  1301.                 $this->addFlash('success', $this->translator->trans('Orden eliminada correctamente'));
  1302.             }
  1303.         }
  1305.         return $this->redirectToRoute('order_index');
  1306.     }
  1308.     private function rmOrder(Order $order){
  1309.         $em = $this->em;
  1310.         $result = ['error'=>false,'msg'=>''];
  1312.         try {
  1313.             $em->remove($order);
  1314.             $em->flush();
  1316.         } catch (ForeignKeyConstraintViolationException $e) {
  1317.             $result = ['error'=>true, 'msg'=>$this->translator->trans('No se puede eliminar una orden asociada')];
  1318.         }
  1320.         return $result;
  1321.     }
  1323.     /**
  1324.      * @Route({"en": "/shopping",
  1325.      *         "es": "/cesta"}, name="order_shopping", methods={"GET"})
  1326.      */
  1327.     public function shopping(Request $request, OrderRepository $orderRepository): Response
  1328.     {
  1329.         $admin =$this->getUser();
  1331.         if($admin == NULL){
  1332.             return $this->redirectToRoute('app_login');
  1333.         }
  1335.         $orders = $orderRepository->getShoppingCar($admin);
  1337.         return $this->render('order/shopping.html.twig', [
  1338.             'orders' => $orders,
  1339.             'navbarTitle' => $this->translator->trans("Cesta")
  1340.         ]);
  1341.     }
  1343.     /**
  1344.      * @Route("/chat/message", name="order_chat_message", methods={"POST"})
  1345.      */
  1346.     public function chatMessage(Request $request, MailerInterface $mailer, OrderRepository $orderRepository): JsonResponse
  1347.     {
  1348.         $result = ['error'=>false,'msg'=>'','data'=>[]];
  1350.         $em = $this->em;
  1351.         $user = $this->getUser();
  1352.         $type = $request->request->get('type',1); //1:Read, 2:Send/read
  1353.         $message = $request->request->get('message');
  1354.         $oid = $request->request->get('oid');
  1356.         if (empty($oid) || empty($user))
  1357.         {
  1358.             $result = ['error'=>true,'msg'=>$this->translator->trans("Error inesperado")];
  1359.         }
  1360.         elseif($type==2 && empty($message)){
  1361.             $result = ['error'=>true,'msg'=>$this->translator->trans("El mensaje no puede estar vacío")];
  1362.         }
  1363.         else{
  1364.             $order = $em->getRepository(Order::class)->find($oid);
  1365.             if(empty($order)){
  1366.                 $result = ['error'=>true,'msg'=>$this->translator->trans("Error inesperado")];
  1367.             }
  1368.             else{
  1369.                 if($type==2){
  1370.                     $om = new OrderMessage();
  1371.                     $om->setOrder($order);
  1372.                     $om->setUser($user);
  1373.                     $om->setDateAdded(new \DateTime());
  1374.                     $om->setMessage($message);
  1376.                     $em->persist($om);
  1377.                     $em->flush();
  1379.                     $messages = $em->getRepository(OrderMessage::class)->findBy(['order_'=>$order,'user'=>$user],['date_added'=>'DESC'],2);
  1381.                     if(count($messages)<2 || ($messages[0]->getDateAdded()->format('U') - $messages[1]->getDateAdded()->format('U') > 300)){
  1383.                         $data['message']='Nuevo mensaje de chat';
  1384.                         $data['reference']=$order->getRef();
  1385.                         $data['path_name']='order_show';
  1386.                         $data['path_parameters']='id:'.$order->getId();
  1388.                         if($user->getCompany()->getType()==2){
  1389.                             //Msg generado por proveedor, Notificaciones - cliente
  1390.                             $this->util->notifications($order->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1391.                         }
  1392.                         else{
  1393.                             //Msg generado por proveedor, Notificaciones - proveedor
  1394.                             $this->util->notifications($order->getSupplier()->getCompany(), 3, $data, $this->getUser(), $order->getId());
  1395.                         }
  1396.                     }
  1397.                 }
  1399.                 $messages = $qb = $em->createQueryBuilder()
  1400.                                 ->select('o,u,om')
  1401.                                 ->from(OrderMessage::class,'om')
  1402.                                 ->join('om.order_','o')
  1403.                                 ->join('om.user','u')
  1404.                                 ->where('om.order_ = :order')
  1405.                                 ->orderBy('om.date_added','ASC')
  1406.                                 ->setParameters(['order'=>$order])
  1407.                                 ->getQuery()->getArrayResult();
  1408.                 $result['data']=$messages;
  1409.             }
  1411.         }
  1413.         return new JsonResponse($result);
  1414.     }
  1416.     /**
  1417.      * @Route({"en": "/export/{id}",
  1418.      *         "es": "/exportar/{id}"}, defaults={"id" = null}, name="order_export", methods={"GET"})
  1419.      */
  1420.     public function export(OrderRepository $orderRepository, Order $order = null)
  1421.     {
  1422.         $trans = $this->translator;
  1424.         if (null !== $order)
  1425.         {
  1426.             $filename = $trans->trans("AD2_orden_"). $order->getRef() . '_' . time() . ".xlsx";
  1427.         }else
  1428.         {
  1429.             $filename = $trans->trans("AD2_ordenes_"). time() . ".xlsx";
  1431.         }
  1433.         $admin =$this->getUser();
  1434.         $company = $admin->getCompany();
  1435.         $colorARGB = $company && $company->getCorporateColor() ? str_replace('#','',$company->getCorporateColor()) : 'DD9933';
  1437.         $spreadsheet = new Spreadsheet();
  1439.         $sheet = $spreadsheet->getActiveSheet();
  1441.         //$sheet->setTitle('Addvance Users');
  1443.         $sheet->getCell('A1')->setValue($trans->trans('Referencia orden'));
  1444.         $sheet->getCell('B1')->setValue($trans->trans('Empresa'));
  1445.         $sheet->getCell('C1')->setValue($trans->trans('Pieza'));
  1446.         $sheet->getCell('D1')->setValue($trans->trans('Referencia pieza'));
  1447.         $sheet->getCell('E1')->setValue($trans->trans('Centro de trabajo'));
  1448.         $sheet->getCell('F1')->setValue($trans->trans('Unidades'));
  1449.         $sheet->getCell('G1')->setValue($trans->trans('Estado'));
  1450.         $sheet->getCell('H1')->setValue($trans->trans('Pedido'));
  1451.         $sheet->getCell('I1')->setValue($trans->trans('Autor'));
  1452.         $sheet->getCell('J1')->setValue($trans->trans('Fecha de creación'));
  1453.         $sheet->getCell('K1')->setValue($trans->trans('Fecha Revisión'));
  1454.         $sheet->getCell('L1')->setValue($trans->trans('Fecha de finalización'));
  1455.         $sheet->getCell('M1')->setValue($trans->trans('Observaciones'));
  1458.         $styleArrayFirstRow = [
  1459.             'font' => [
  1460.                 'bold' => true,
  1461.                 'color' => array('rgb' => 'FFFFFF'),
  1462.             ]
  1463.         ];
  1464.         $highestColumn = $sheet->getHighestColumn();
  1465.         $sheet->getStyle('A1:M1')->applyFromArray($styleArrayFirstRow);
  1466.         //$sheet->getStyle('A')->applyFromArray($styleArrayFirstRow);
  1469.         //$sheet->getColumnDimension('A')->setWidth(30);
  1470.         //$sheet->getStyle('A')->getFont()->setBold(true);
  1471.         $sheet->getDefaultColumnDimension()->setWidth(30);
  1475.         $sheet
  1476.             ->getStyle('A1:M1')
  1477.             ->getFill()
  1478.             ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  1479.             ->getStartColor()
  1480.             ->setARGB($colorARGB);
  1482.         if (null!== $order)
  1483.         {
  1484.             $sheet->fromArray($orderRepository->generateExport($admin, $order),null, 'A2', true);
  1485.         }else
  1486.         {
  1487.             $sheet->fromArray($orderRepository->generateExport($admin),null, 'A2', true);
  1488.         }
  1490.         $writer = new Xlsx($spreadsheet);
  1492.         $response =  new StreamedResponse(
  1493.             function () use ($writer) {
  1494.                 $writer->save('php://output');
  1495.             }
  1496.         );
  1497.         $response->headers->set('Content-Type', 'application/vnd.ms-excel');
  1498.         $response->headers->set('Content-Disposition', 'attachment;filename="'.$filename.'"');
  1499.         $response->headers->set('Cache-Control','max-age=0');
  1500.         return $response;
  1501.     }
  1502. }