src/MDS/AvexpressBundle/Controller/ProductsFilesController.php line 274

Open in your IDE?
  1. <?php
  3. namespace App\MDS\AvexpressBundle\Controller;
  5. use App\Entity\Cities;
  6. use App\Entity\Client;
  7. use App\Entity\Configuration;
  8. use App\Entity\Country;
  9. use App\Entity\Destination;
  10. use App\Entity\Regions;
  11. use App\Entity\SettingsCompany;
  12. use App\Entity\Supplier;
  13. use App\Entity\User;
  14. use App\MDS\AvexpressBundle\Entity\AveDocInvoiceItems;
  15. use App\MDS\AvexpressBundle\Entity\AveDocProforma;
  16. use App\MDS\AvexpressBundle\Entity\AveDocProformaItems;
  17. use App\MDS\AvexpressBundle\Entity\AveFiles;
  18. use App\MDS\AvexpressBundle\Entity\AveProduct;
  19. use App\MDS\AvexpressBundle\Entity\AveProductFileLocationNames;
  20. use Symfony\Component\Routing\Annotation\Route;
  21. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  22. use Symfony\Component\HttpFoundation\Request;
  23. use App\MDS\AvexpressBundle\Entity\AveProductFile;
  24. use App\MDS\AvexpressBundle\Entity\AveTemplate;
  25. use App\MDS\AvexpressBundle\Entity\AveTemplateItems;
  26. use App\MDS\DevelupBundle\Entity\MdvTelegramUser;
  27. use App\MDS\EventsBundle\Entity\Proposal;
  28. use App\MDS\EventsBundle\Entity\ProposalAgents;
  29. use App\MDS\EventsBundle\Entity\ProposalInvoice;
  30. use App\MDS\EventsBundle\Entity\ProposalSupplierControl;
  31. use App\MDS\EventsBundle\Entity\ProposalSupplierServices;
  32. use App\MDS\GreenPatioBundle\Entity\ReservationInvoice;
  33. use Swift_Mailer;
  34. use Swift_Message;
  35. use Swift_SmtpTransport;
  36. use Symfony\Contracts\Translation\TranslatorInterface;
  38. class ProductsFilesController extends AbstractController
  39. {
  40.     private $translator;
  42.     public function __construct(TranslatorInterface $translator) {
  43.         $this->translator = $translator;
  44.     }
  45.     
  46.     /**
  47.      * @Route("/productfileadd/",  name="ave_add_productfile")
  48.      * Agregar un producto a un expediente
  49.      */
  50.     public function addProductFileAction( Request $request)
  51.     {
  52.         $em = $this->getDoctrine()->getManager();
  53.         $clients = $em->getRepository(Client::class)->findAll();
  54.         $newRequest = $request->request->get('productfile');
  55.         $editFile = $em->getRepository(AveFiles::class)->findOneById($newRequest['fileId']);
  56.         $mdvProductSelected = $em->getRepository(AveProduct::class)->findOneById($newRequest['productId']);
  57.         $logTelegram = false;
  59.         /* Obtengo usuario logueado */
  60.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  61.         $user_id = $user_logueado->getId();
  63.         $newProductFile = new AveProductFile();
  64.         $newProductFile->setProductName($mdvProductSelected->getName());
  65.         $newProductFile->setProductId($mdvProductSelected->getId());
  66.         $newProductFile->setType($mdvProductSelected->getType());
  68.         if (!empty($newRequest['servicePrice'])){
  69.             $newProductFile->setServicePrice($newRequest['servicePrice']);
  70.         } else {
  71.             // Si el precio viene vacio tomamos el valor por defecto del producto
  72.             $newProductFile->setServicePrice($mdvProductSelected->getPrice());
  73.         }
  74.         $newProductFile->setDescription($mdvProductSelected->getDescription());
  75.         $newProductFile->setFileId($newRequest['fileId']);
  77.         if (!empty($newRequest['dateStart'])) { $newProductFile->setDateStart(new \DateTime($newRequest['dateStart'].' '.$newRequest['hourStart'])); }
  78.         if (!empty($newRequest['dateEnd'])) { $newProductFile->setDateEnd(new \DateTime($newRequest['dateStart'].' '.$newRequest['hourEnd'])); }
  79.         $dataDates = $this->obtenerFechas($newRequest['fileId'], $newProductFile->getDateStart(), $newProductFile->getDateEnd());
  80.         $newProductFile->setDateStart($dataDates['dateStart']);
  81.         $newProductFile->setDateEnd($dataDates['dateEnd']);
  82.         $newProductFile->setDateInAt($dataDates['dateStart']);
  83.         $newProductFile->setDateOutAt($dataDates['dateEnd']);
  85.         $newProductFile->setCreatedId($user_id);
  86.         $newProductFile->setUpdatedId($user_id);
  87.         $newProductFile->setCreatedAt(new \DateTime("now"));
  88.         $newProductFile->setUpdatedAt(new \DateTime("now"));
  90.         $newProductFile->setOpIva(true);
  91.         $newProductFile->setIva('21');
  93.         if (!empty($newRequest['supplierExt'])){
  94.             $supplier = $em->getRepository(Supplier::class)->findOneById($newRequest['supplierExt']);
  95.             $newProductFile->setSupplierExt($supplier->getName());
  96.             $newProductFile->setSupplierExtId($newRequest['supplierExt']);
  97.         } else {
  98.             $newProductFile->setSupplierExt(null);
  99.             $newProductFile->setSupplierExtId(null);
  100.         }
  102.         if (empty($newProductFile->getType())){ $newProductFile->setType('Otros'); }
  104.         $dataRankAv = $this->obtenerRankAv($newRequest['fileId']);
  105.         $newProductFile->setRankAv($dataRankAv);
  107.         $newProductFile->setDays((($newProductFile->getDateEnd()->diff($newProductFile->getDateStart()))->days + 1));
  109.         $em->persist($newProductFile);
  110.         $em->flush();
  112.         $products = $em->getRepository(AveProduct::class)->findAll();
  114.         $data = $this->calculosFile($newRequest['fileId'], null, 0, 'File');
  116.         $sumatoriaTotalNet = 0;
  117.         $sumatoriaTotalVat = 0;
  118.         $sumatoriaTotal = 0;
  120.         $resultados = array(
  121.             'totalNeto' => $sumatoriaTotalNet,
  122.             'vat' => $sumatoriaTotalVat,
  123.             'total' => $sumatoriaTotal,
  125.         );
  127.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($newRequest['fileId']);
  128.         $numeroItems = sizeof($productInFile);
  130.         $file = $editFile;
  131.         // Si hay proposal se debe actualizar en el expediente de Eventos
  132.         if (!empty($file->getIdProposal()) and is_numeric($file->getIdProposal())){
  134.             // Buscamos el destino donde se encuentre Avexpress y ahi agregamos el servicio, si no se encuentra no se agregara el servicio
  135.             $control = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  136.                 array(
  137.                     'supplierId' => 80,                                          // El supplier 80 es Avexpress
  138.                     'proposalId' => $file->getIdProposal(),
  139.                 )
  140.             );
  142.             if (!empty($control)){
  143.                 // Existe un destino con Avexpress como proveedor, hay se agregara el servicio
  145.                 $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($file->getIdProposal());
  146.                 if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  148.                     $logTelegram = true;
  149.                     $service = new ProposalSupplierServices();
  150.                     $service->setServiceIdFather(0);
  151.                     $service->setControlId($control->getId());
  152.                     $service->setProposalId($file->getIdProposal());
  153.                     $service->setDestinationId($control->getDestinoId());
  154.                     $service->setSupplierId(80);
  155.                     $service->setIdeaId(null);
  156.                     $service->setServiceId($newProductFile->getProductId());
  157.                     $service->setServiceCatName('Av');
  158.                     $service->setServiceCatId(3);
  159.                     $service->setName($newProductFile->getProductName());
  160. //                $service->setPrice($mdvProductSelected->getPrice() * 1.21);
  162.                     $priceInOut = $mdvProductSelected->getSubTotalPrice() / $mdvProductSelected->getPax();      // Se devuelve el calculo dividiendo entre personas
  163.                     $priceInOut = $priceInOut / $mdvProductSelected->getUnits();                                // Se devuelve el calculo dividiendo entre cantidades
  164.                     $priceInOut = $priceInOut / round($mdvProductSelected->getDays());                          // Se devuelve el calculo dividiendo entre dias, se redondea por si es 1.5
  165.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  166.                     $priceInOut = round($priceInOut, 2, PHP_ROUND_HALF_UP);
  168.                     $service->setPrice($priceInOut);
  170. //                $service->setPrice($mdvProductSelected->getPrice());
  171.                     $service->setCurrency(null);
  172.                     $service->setUnits(1);
  173.                     $service->setCommission(0);
  174.                     $service->setOver(0);
  175.                     $service->setIva(21);
  176.                     $service->setPax(0);
  177.                     $service->setHour(null);
  178.                     $service->setDateInAt(new \DateTime("now"));
  179.                     $service->setDateOutAt(new \DateTime("now"));
  180.                     $service->setDirectPayment(0);
  181.                     $service->setStatus('Pending');
  182.                     $service->setStatusinternal('Additional');
  183.                     $service->setPreCommission(null);
  184.                     $service->setPreIva(null);
  185.                     $service->setDateBlockLimit(null);
  186.                     $service->setOpCommission(1);
  187.                     $service->setOpOver(1);
  188.                     $service->setOpIva(1);
  189.                     $service->setBreakdown(0);
  190.                     $service->setIsFather(0);
  191.                     $service->setRank(1);
  192.                     $service->setOriginalopIva(1);
  193.                     $service->setOriginalIva(null);
  194.                     $service->setOriginalPrice(null);
  195.                     $service->setStatusRec('normal');
  196.                     $service->setAssistantId(null);
  197.                     $service->setCreatedId($user_id);
  198.                     $service->setUpdatedId($user_id);
  199.                     $service->setCreatedAt(new \DateTime("now"));
  200.                     $service->setUpdatedAt(new \DateTime("now"));
  202.                     $em->persist($service);
  203.                     $em->flush();
  205.                     // Guardamos el ID del servicio (Eventos) asociado al producto (AvExpress)
  206.                     $newProductFile->setOriginId($service->getId());
  208.                     $em->persist($newProductFile);
  209.                     $em->flush();
  210.                 }
  211.             }
  212.         }
  214.         //INICIO: Notificamos al agente por Telegram
  215.         if ($logTelegram){
  216.             //Buscamos todos los agentes del proposal
  217.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($file->getIdProposal());
  219.             //Buscamos el Destino
  220.             $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  222.             //Buscamos el agente de AvExpress
  223.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  225.             if (!empty($proposalAgents) and !($user_id == 22)){
  226.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  227.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (Nuevo Servicio) __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  228.                 }
  229.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  230.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (Nuevo Servicio) __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  231.                 }
  232.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  233.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (Nuevo Servicio) __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  234.                 }
  235.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  236.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (Nuevo Servicio) __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  237.                 }
  238.             }
  239.         }
  240.         //FIN: Notificamos al agente por Telegram
  243.         return $this->render('MDS/AvexpressBundle/Avexpress/edit-files.html.twig',
  244.             array(
  245.                 'id' => $newRequest['fileId'],
  246.                 'clients' => $clients,
  247.                 'clientId' => $editFile->getClient(),
  248.                 'file' => $editFile,
  249.                 'products' => $products,
  250.                 'numeroItems' => $numeroItems,
  251.                 'arrayProductFile' => $data['datasupplier']['product'],
  252.                 'services' => null,
  253.                 'facturas' => null,
  254.                 'paymentNotIvoiced' => null,
  255.                 'paymentsAll' => null,
  256.                 'resultados' => $resultados,
  257.                 'totales_global_con_iva' => $data['totales'], //$data['totales_global_con_iva'],
  258.                 'totales_global_iva' => $data['bases_imponibles']['ivaMontoVeintiUno'], //$data['totales_global_iva'],
  259.                 'totales_global_neto' => $data['totales_neto'], //$data['totales_global_neto'],
  260.                 'totales_global_servicios_con_iva' => 0, //$data['totales_global_servicios_con_iva'],
  261.                 'totales_global_servicios_neto' => 0, //$data['totales_global_servicios_neto'],
  262.                 'totales_global_servicios_iva' => 0, //$data['totales_global_servicios_iva'],
  263.                 'sumatoria_totales_global_con_iva' => 0, //$data['sumatoria_totales_global_con_iva'],
  264.                 'sumatoria_totales_global_neto' => 0, //$data['sumatoria_totales_global_neto'],
  265.                 'sumatoria_totales_global_iva' => 0, //$data['sumatoria_totales_global_iva'],
  266.             ));
  267.     }
  270.     /**
  271.      * @Route("/productfiledelete/{id}",  name="ave_delete_productfile")
  272.      * Eliminar un producto de un expediente
  273.      */
  274.     public function deleteProductFileAction($id, Request $request)
  275.     {
  276.         $em = $this->getDoctrine()->getManager();
  277.         $mdvProductSelected = $em->getRepository(AveProductFile::class)->findOneById($id);
  278.         $id = $mdvProductSelected->getFileId();
  279.         $logTelegram = false;
  281.         /* Obtengo usuario logueado */
  282.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  283.         $user_id = $user_logueado->getId();
  285.         //INICIO: Si hay un ID origin se debe eliminar en Eventos
  286.         if (!empty($mdvProductSelected->getOriginId())){
  287.             $logTelegram = true;
  288.             $delete = $em->getRepository(ProposalSupplierServices::class)->findOneById($mdvProductSelected->getOriginId());
  289.             if (!empty($delete)) {
  290.                 $destinationId = $delete->getDestinationId();
  291.                 $proposalId = $delete->getProposalId();
  292.                 $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($delete->getProposalId());
  293.                 if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  294.                     if (!empty($delete)) {
  295.                         $delete_sub = $em->getRepository(ProposalSupplierServices::class)->findByServiceIdFather($delete->getId());
  296.                         foreach ($delete_sub as $deletesub) {
  297.                             $em->remove($deletesub);
  298.                         }
  300.                         $em->remove($delete);
  301.                         $em->flush();
  302.                     }
  303.                 }
  304.             } else {
  305.                 // El servicio origen no se encontro
  306.                 $logTelegram = false;
  307.             }
  308.         }
  310.         //INICIO: Notificamos al agente por Telegram
  311.         if ($logTelegram){
  312.             //Buscamos todos los agentes del proposal
  313.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposalId);
  315.             //Buscamos el Destino
  316.             $proposalDestino = $em->getRepository(Destination::class)->findOneById($destinationId);
  318.             //Buscamos el agente de Develup
  319.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  321.             if (!empty($proposalAgents)){
  322.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  323.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  324.                 }
  325.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  326.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  327.                 }
  328.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  329.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  330.                 }
  331.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  332.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  333.                 }
  334.             }
  335.         }
  336.         //FIN: Notificamos al agente por Telegram
  338.         //FIN: Si hay un ID origin se debe eliminar en Eventos
  340.         //INICIO: Si el producto se encuentra dentro de una proforma (Ave_Doc_Proforma_Items) se elimina también
  341.         $productInProforma = $em->getRepository(AveDocProformaItems::class)->findByControlId($mdvProductSelected->getId());
  342.         if (!empty($productInProforma)){
  343.             foreach ($productInProforma as $item){
  344.                 $item->setFileId((-1) * $item->getFileId());      // No lo vamos a eliminar, apuntará al fileId en negativo
  345.                 $em->persist($item);
  346.                 // $em->remove($item);
  347.                 $em->flush();
  348.             }
  349.         }
  350.         //FIN: Si el producto se encuentra dentro de una proforma (Ave_Doc_Proforma_Items) se elimina también
  352.         $mdvProductSelected->setFileId((-1) * $mdvProductSelected->getFileId());      // No lo vamos a eliminar, apuntará al fileId en negativo
  353.         $em->persist($mdvProductSelected);
  354.         // $em->remove($mdvProductSelected);
  355.         $em->flush();
  357.         return $this->redirectToRoute('ave_edit_file', array('id' => $id));
  358.     }
  361.     /**
  362.      * @Route("/productfileproformadelete/{id}",  name="ave_delete_productfileproforma")
  363.      * Eliminar un producto de una proforma
  364.      */
  365.     public function deleteProductFileInProformaAction($id, Request $request)
  366.     {
  367.         $em = $this->getDoctrine()->getManager();
  368.         $mdvProductSelected = $em->getRepository(AveDocProformaItems::class)->findOneByControlId($id);
  369.         $id = $mdvProductSelected->getFileId();
  371.         $em->remove($mdvProductSelected);
  372.         $em->flush();
  374.         return $this->redirectToRoute('ave_edit_file', array('id' => $id));
  375.     }
  378.     /**
  379.      * @Route("/updateproductfilegrid/",  name="ave_updategrid_productfile")
  380.      * Actualizar grid de productos de un expediente
  381.      */
  382.     public function updategridProductFileAction(Request $request)
  383.     {
  384.         $em = $this->getDoctrine()->getManager();
  385.         $newRequest = $request->request->get('product');
  386.         $fileId = $request->request->get('fileId');
  387.         $logTelegram = false;
  388.         $srvInconsistentes = '';                    // Mensaje de alerta por inconsistencia en los servicios
  389.         $txtOfChanges = '';
  391.         /* Obtengo usuario logueado */
  392.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  393.         $user_id = $user_logueado->getId();
  395.         foreach ($newRequest as $key => $item) {
  396.             $txtWarning = '';
  397.             if (!empty($item['name'])){
  398.                 if (is_numeric($item['price'])){
  399.                     $logTelegram = true;
  400.                     $productInFile = $em->getRepository(AveProductFile::class)->findOneById($key);
  401.                     $productInFile->setProductName($item['name']);
  402.                     $productInFile->setServicePrice($item['price']);
  403.                     $productInFile->setUnits($item['units']);
  404.                     $productInFile->setDays($item['days']);
  405.                     $productInFile->setSubTotalPrice($item['price'] * $item['units'] *$item['days']);
  407.                     // *** Primero se debe calcular la comision y luego el over ***
  409.                     // Calculo de comision
  410.                     if ($productInFile->getOpCommission()){
  411.                         //Over positivo
  412.                         if (!($productInFile->getCommission() == 0) and is_numeric($productInFile->getCommission())){
  413.                             $suma = $productInFile->getCommission()/100;
  414.                             $suma = $productInFile->getSubTotalPrice() * $suma;
  415.                             $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + $suma);
  416.                         }
  417.                     } else {
  418.                         //Over negativo
  419.                         if (!($productInFile->getCommission() == 0) and is_numeric($productInFile->getCommission())){
  420.                             $suma = $productInFile->getCommission()/100;
  421.                             $suma = $productInFile->getSubTotalPrice() * $suma;
  422.                             if ($productInFile->getSubTotalPrice() > $suma){            // La comision a restar no puede ser mayor que el precio total
  423.                                 $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() - $suma);
  424.                             }
  425.                         }
  426.                     }
  428.                     // Calculo con OVER
  429.                     if ($productInFile->getOpOver()){
  430.                         //Over positivo
  431.                         if (!($productInFile->getOver() == 0) and is_numeric($productInFile->getOver())){
  432.                             $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + $productInFile->getOver());
  433.                         }
  434.                     } else {
  435.                         //Over negativo
  436.                         if (!($productInFile->getOver() == 0) and is_numeric($productInFile->getOver())){
  437.                             $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + ((-1) * $productInFile->getOver()));
  438.                         }
  439.                     }
  441.                     // IVA
  443. //                    $productInFile->setDescription($item['description']);
  444.                     $productInFile->setUpdatedId($user_id);
  445.                     $productInFile->setUpdatedAt(new \DateTime("now"));
  447.                     //Si las fechas de inicio y fin no coinciden con el campo dias se debe enviar alerta
  448.                     $txtWarning = ($productInFile->getDateOutAt()->diff($productInFile->getDateInAt()))->days + 1 <> $productInFile->getDays() ? '<br>'.$productInFile->getProductName() : '';
  449.                     if (!empty($txtWarning)){
  450.                         if (empty($srvInconsistentes)){ $srvInconsistentes = 'Hay inconsistencias en: '.'<br>'.$txtWarning; } else { $srvInconsistentes = $srvInconsistentes.'<br>'.$txtWarning; }
  451.                     }
  453.                     $em->persist($productInFile);
  454.                     $em->flush();
  456.                     //INICIO: Duplicamos en Eventos
  457.                     $proposalId = 0;
  458.                     if (!empty($productInFile->getOriginId())) {
  459.                         $serviceEvent = $em->getRepository(ProposalSupplierServices::class)->findOneById($productInFile->getOriginId());
  460.                         $oldServiceEvent = array(
  461.                             'activityId' => $serviceEvent->getActivityId(),
  462.                             'assistantId' => $serviceEvent->getAssistantId(),
  463.                             'breakdown' => $serviceEvent->getBreakdown(),
  464.                             'commission' => $serviceEvent->getCommission(),
  465.                             'controlId' => $serviceEvent->getControlId(),
  466.                             'currency' => $serviceEvent->getCurrency(),
  467.                             'dateBlockLimit' => $serviceEvent->getDateBlockLimit(),
  468.                             'dateInAt' => $serviceEvent->getDateInAt(),
  469.                             'dateOutAt' => $serviceEvent->getDateOutAt(),
  470.                             'destinationId' => $serviceEvent->getDestinationId(),
  471.                             'directPayment' => $serviceEvent->getDirectPayment(),
  472.                             'hour' => $serviceEvent->getHour(),
  473.                             'ideaId' => $serviceEvent->getIdeaId(),
  474.                             'isFather' => $serviceEvent->getIsFather(),
  475.                             'iva' => $serviceEvent->getIva(),
  476.                             'name' => $serviceEvent->getName(),
  477.                             'opCommission' => $serviceEvent->getOpCommission(),
  478.                             'opIva' => $serviceEvent->getOpIva(),
  479.                             'opOver' => $serviceEvent->getOpOver(),
  480.                             'originalIva' => $serviceEvent->getOriginalIva(),
  481.                             'originalPrice' => $serviceEvent->getOriginalPrice(),
  482.                             'originalopIva' => $serviceEvent->getOriginalopIva(),
  483.                             'over' => $serviceEvent->getOver(),
  484.                             'pax' => $serviceEvent->getPax(),
  485.                             'preCommission' => $serviceEvent->getPreCommission(),
  486.                             'preIva' => $serviceEvent->getPreIva(),
  487.                             'price' => $serviceEvent->getPrice(),
  488.                             'proposalId' => $serviceEvent->getProposalId(),
  489.                             'rank' => $serviceEvent->getRank(),
  490.                             'serviceCatId' => $serviceEvent->getServiceCatId(),
  491.                             'serviceCatName' => $serviceEvent->getServiceCatName(),
  492.                             'serviceId' => $serviceEvent->getServiceId(),
  493.                             'serviceIdFather' => $serviceEvent->getServiceIdFather(),
  494.                             'status' => $serviceEvent->getStatus(),
  495.                             'statusRec' => $serviceEvent->getStatusRec(),
  496.                             'statusinternal' => $serviceEvent->getStatusinternal(),
  497.                             'supplierId' => $serviceEvent->getSupplierId(),
  498.                             'units' => $serviceEvent->getUnits(),
  499.                         );
  501.                         if (!empty($serviceEvent)) {
  502.                             $proposalId = $serviceEvent->getProposalId();
  503.                             $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($serviceEvent->getProposalId());
  504.                             if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  506. //                            $serviceEvent->setUnits(1);                             // Las unidades no se pueden replicar o se genera un sobre calculo del lado de Evenetos
  507.                                 $serviceEvent->setName($productInFile->getProductName());
  509.                                 $priceInOut = $productInFile->getSubTotalPrice();
  510.                                 if (!($productInFile->getPax() == 0)) {
  511.                                     $priceInOut = $priceInOut / $productInFile->getPax();                    // Se devuelve el calculo dividiendo entre personas
  512.                                 }
  513.                                 if (!($productInFile->getUnits() == 0)) {
  514.                                     $priceInOut = $priceInOut / $productInFile->getUnits();                  // Se devuelve el calculo dividiendo entre cantidades
  515.                                 }
  516.                                 if (!($productInFile->getDays() == 0)) {
  517.                                     $priceInOut = $priceInOut / round($productInFile->getDays());            // Se devuelve el calculo dividiendo entre dias, se redondea por si es 1.5
  518.                                 }
  519.                                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  520.                                 $priceInOut = round($priceInOut, 2, PHP_ROUND_HALF_UP);
  522.                                 $serviceEvent->setPrice($priceInOut);
  524.                                 // Se verifican los precios en ambas partes (AV Express e InOut)
  525.                                 if (!($serviceEvent->getPrice() == $productInFile->getServicePrice())) {
  526.                                     // Si ambos precios unitarios son distintos se ha modificado el numero de días en Av Express
  527.                                     $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  528.                                     $serviceEvent->setPrice($newPriceInOut);
  529.                                 } else {
  530.                                     // si son iguales tambien se deben verificar el numero de dias
  531.                                     if (!(($serviceEvent->getDateOutAt()->diff($serviceEvent->getDateInAt())->days + 1) == $productInFile->getDays())) {
  532.                                         $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  533.                                         $serviceEvent->setPrice($newPriceInOut);
  534.                                     }
  535.                                 }
  537.                                 $serviceEvent->setCurrency($productInFile->getCurrency());
  538.                                 $serviceEvent->setUnits($productInFile->getUnits());
  539. //                            $serviceEvent->setIva(21);
  540.                                 if (empty($productInFile->getPax())) {
  541.                                     $serviceEvent->setPax(1);
  542.                                 } else {
  543.                                     $serviceEvent->setPax($productInFile->getPax());
  544.                                 }
  545.                                 $serviceEvent->setDateInAt($productInFile->getDateInAt());
  546.                                 $serviceEvent->setDateOutAt($productInFile->getDateOutAt());
  548.                                 //Verificamos cambios e informamos al agente del proposal
  549.                                 $boolChanges = false;
  550.                                 if (!($serviceEvent->getRank() == $oldServiceEvent['rank'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Orden</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['rank'].', su nuevo valor es: '.$serviceEvent->getRank().'<br>'; $boolChanges = true; }
  551.                                 if (!($serviceEvent->getName() == $oldServiceEvent['name'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Nombre</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['name'].', su nuevo valor es: '.$serviceEvent->getName().'<br>'; $boolChanges = true; }
  552.                                 if (!($serviceEvent->getPrice() == $oldServiceEvent['price'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Precio</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['price'].', su nuevo valor es: '.$serviceEvent->getPrice().'<br>'; $boolChanges = true; }
  553.                                 if (!($serviceEvent->getCurrency() == $oldServiceEvent['currency'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Moneda</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['currency'].', su nuevo valor es: '.$serviceEvent->getCurrency().'<br>'; $boolChanges = true; }
  554.                                 if (!($serviceEvent->getUnits() == $oldServiceEvent['units'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Cantidad</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['units'].', su nuevo valor es: '.$serviceEvent->getUnits().'<br>'; $boolChanges = true; }
  555.                                 if (!($serviceEvent->getPax() == $oldServiceEvent['pax'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Personas</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['pax'].', su nuevo valor es: '.$serviceEvent->getPax().'<br>'; $boolChanges = true; }
  556.                                 if (!($serviceEvent->getOpOver() == $oldServiceEvent['opOver'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Opción (-/+) del Over</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['opOver'].', su nuevo valor es: '.$serviceEvent->getOpOver().'<br>'; $boolChanges = true; }
  557.                                 if (!($serviceEvent->getOver() == $oldServiceEvent['over'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Over</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['over'].', su nuevo valor es: '.$serviceEvent->getOver().'<br>'; $boolChanges = true; }
  558.                                 if (!($serviceEvent->getOpCommission() == $oldServiceEvent['opCommission'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Opción (-/+) de la Comisión</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['opCommission'].', su nuevo valor es: '.$serviceEvent->getOpCommission().'<br>'; $boolChanges = true; }
  559.                                 if (!($serviceEvent->getCommission() == $oldServiceEvent['commission'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Comisión" ha sido modificado. Su valor era: '.$oldServiceEvent['commission'].', su nuevo valor es: '.$serviceEvent->getCommission().'<br>'; $boolChanges = true; }
  560.                                 if (!($serviceEvent->getOpIva() == $oldServiceEvent['opIva'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Opción (-/+) del Iva</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['opIva'].', su nuevo valor es: '.$serviceEvent->getOpIva().'<br>'; $boolChanges = true; }
  561.                                 if (!($serviceEvent->getIva() == $oldServiceEvent['iva'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Iva</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['iva'].', su nuevo valor es: '.$serviceEvent->getIva().'<br>'; $boolChanges = true; }
  562.                                 if (!($serviceEvent->getDateInAt()->format('H:i') == $oldServiceEvent['dateInAt']->format('H:i'))){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Hora inicio</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['dateInAt']->format('H:i').', su nuevo valor es: '.$serviceEvent->getDateInAt()->format('H:i').'<br>'; $boolChanges = true; }
  563.                                 if (!($serviceEvent->getDateInAt()->format('Ymd') == $oldServiceEvent['dateInAt']->format('Ymd'))){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Fecha inicio</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['dateInAt']->format('d/m/Y').', su nuevo valor es: '.$serviceEvent->getDateInAt()->format('d/m/Y').'<br>'; $boolChanges = true; }
  564.                                 if (!($serviceEvent->getDateOutAt()->format('H:i') == $oldServiceEvent['dateOutAt']->format('H:i'))){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Hora fin</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['dateOutAt']->format('H:i').', su nuevo valor es: '.$serviceEvent->getDateOutAt()->format('H:i').'<br>'; $boolChanges = true; }
  565.                                 if (!($serviceEvent->getDateOutAt()->format('Ymd') == $oldServiceEvent['dateOutAt']->format('Ymd'))){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Fecha fin</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['dateOutAt']->format('d/m/Y').', su nuevo valor es: '.$serviceEvent->getDateOutAt()->format('d/m/Y').'<br>'; $boolChanges = true; }
  567.                                 $em->persist($serviceEvent);
  568.                                 $em->flush();
  569.                             }
  570.                         }
  571.                     }
  572.                     //FIN: Duplicamos en Eventos
  573.                 }
  574.             }
  575.         }
  576.         // Notificamos al agente de InOut si se hicieron actualizaciones en los servicios desde AvExpress
  577.         if (!empty($txtOfChanges)) { $this->messageOfChangesToAgent($txtOfChanges, $proposalId); }
  579.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  581.         $event = 'Servicios guardados correctamente.';
  582.         $successMessage = $this->translator->trans($event);
  583.         $this->addFlash('mensajeav', $successMessage);
  585.         if (!empty($srvInconsistentes) and !empty($file->getIdProposal())){ $this->addFlash('mensajeaverror', $srvInconsistentes); }
  587.         // Si el proposalId esta vacio no se notifica a nadie por Telegram
  588.         if (empty($file->getIdProposal())){$logTelegram = false;}
  590.         //INICIO: Notificamos al agente por Telegram
  591.         if ($logTelegram){
  592.             //Buscamos todos los agentes del proposal
  593.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($file->getIdProposal());
  595.             //Buscamos el Destino
  596. //            $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  598.             //Buscamos el agente de AVEXPRESS
  599.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  601.             if (!empty($proposalAgents) and !($user_id == 22)){
  602.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  603.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  604.                 }
  605.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  606.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  607.                 }
  608.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  609.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  610.                 }
  611.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  612.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  613.                 }
  614.             }
  615.         }
  616.         //FIN: Notificamos al agente por Telegram
  618.         return $this->redirectToRoute('ave_edit_file', array('id' => $fileId));
  619.     }
  622.     /**
  623.      * @Route("/updateproductfilegridtwo/",  name="ave_update_productfile_grid_two")
  624.      * Editar todos los producto de un expediente con todos sus campos
  625.      */
  626.     public function updateProductFileGridTwoAction(Request $request){
  628.         $em = $this->getDoctrine()->getManager();
  629.         $newRequest = $request->request->get('services');
  630.         $fileId = $request->request->get('fileId');
  631.         $logTelegram = false;
  632.         $srvInconsistentes = '';                    // Mensaje de alerta por inconsistencia en los servicios
  634.         /* Obtengo usuario logueado */
  635.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  636.         $user_id = $user_logueado->getId();
  638.         $txtOfChanges = ''; $boolNotifyOfChanges = false; $proposalId = 0;
  640.         foreach ($newRequest as $item) {
  641.             $productInFile = $em->getRepository(AveProductFile::class)->findOneById($item['productFileId']);
  642.             $logTelegram = true;
  643.             $txtWarning = '';
  645.             $productInFile->setProductName($item['name']);
  646.             $productInFile->setServicePrice($item['price']);
  647. //            $productInFile->setDescription($item['description']);
  648.             $productInFile->setCurrency($item['currency']);
  649.             $productInFile->setUnits($item['units']);
  650.             $productInFile->setType($item['prdType']);
  651.             $productInFile->setLocation($item['location']);
  652.             $productInFile->setRankAv(intval($item['rankAv']));
  654.             if (array_key_exists('dateInAt',$item)){
  655.                 $productInFile->setDateStart(new \DateTime($item['dateInAt']));
  656.                 $productInFile->setDateInAt(new \DateTime($item['dateInAt']));
  657.             } else {
  658.                 // No se requiere accion
  659.             }
  661.             if (array_key_exists('dateOutAt',$item)){
  662.                 $productInFile->setDateEnd(new \DateTime($item['dateOutAt']));
  663.                 $productInFile->setDateOutAt(new \DateTime($item['dateOutAt']));
  664.             } else {
  665.                 // No se requiere accion
  666.             }
  668.             if (empty($item['days'])){
  669. //                $productInFile->setDays($days = (((new \DateTime($item['dateOutAt']))->diff(new \DateTime($item['dateInAt'])))->days + 1));
  670.                 $productInFile->setDays($days = (($productInFile->getDateOutAt()->diff($productInFile->getDateInAt()))->days + 1));
  671.             } else {
  672.                 $productInFile->setDays($item['days']);
  673.             }
  674.             $productInFile->setPax($item['pax']);
  675.             $productInFile->setOpCommission($item['opCommission']);
  676.             $productInFile->setCommission($item['commission']);
  677.             $productInFile->setOpOver($item['opOver']);
  678.             $productInFile->setOver($item['over']);
  679.             $productInFile->setOpIva($item['opIva']);
  680.             $productInFile->setIva($item['iva']);
  682.             if (!empty($item['supplierExt'])){
  683.                 $supplier = $em->getRepository(Supplier::class)->findOneById($item['supplierExt']);
  684.                 $productInFile->setSupplierExt($supplier->getName());
  685.                 $productInFile->setSupplierExtId($item['supplierExt']);
  686.             } else {
  687.                 $productInFile->setSupplierExt(null);
  688.                 $productInFile->setSupplierExtId(null);
  689.             }
  691.             $productInFile->setHourStart(substr($item['start'],0,2));
  692.             $productInFile->setMinStart(substr($item['start'],3,2));
  694.             $productInFile->setHourEnd(substr($item['end'],0,2));
  695.             $productInFile->setMinEnd(substr($item['end'],3,2));
  697.             $productInFile->setUpdatedId($user_id);
  698.             $productInFile->setUpdatedAt(new \DateTime("now"));
  700.             $productInFile->setSubTotalPrice($productInFile->getServicePrice());
  702.             //INICIO: Validaciones para el sub total
  703.             if (is_numeric($productInFile->getUnits())){
  704.                 $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() * $productInFile->getUnits());
  705.             }
  707.             if (is_numeric($productInFile->getPax())){
  708.                 $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() * $productInFile->getPax());
  709.             }
  711.             $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() * $productInFile->getDays());
  713.             // *** Primero se debe calcular la comision y luego el over ***
  715.             // Calculo de comision
  716.             if ($productInFile->getOpCommission()){
  717.                 //Over positivo
  718.                 if (!($productInFile->getCommission() == 0) and is_numeric($productInFile->getCommission())){
  719.                     $suma = $productInFile->getCommission()/100;
  720.                     $suma = $productInFile->getSubTotalPrice() * $suma;
  721.                     $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + $suma);
  722.                 }
  723.             } else {
  724.                 //Over negativo
  725.                 if (!($productInFile->getCommission() == 0) and is_numeric($productInFile->getCommission())){
  726.                     $suma = $productInFile->getCommission()/100;
  727.                     $suma = $productInFile->getSubTotalPrice() * $suma;
  728.                     if ($productInFile->getSubTotalPrice() > $suma){            // La comision a restar no puede ser mayor que el precio total
  729.                         $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() - $suma);
  730.                     }
  731.                 }
  732.             }
  734.             // Calculo con OVER
  735.             if ($productInFile->getOpOver()){
  736.                 //Over positivo
  737.                 if (!($productInFile->getOver() == 0) and is_numeric($productInFile->getOver())){
  738.                     $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + $productInFile->getOver());
  739.                 }
  740.             } else {
  741.                 //Over negativo
  742.                 if (!($productInFile->getOver() == 0) and is_numeric($productInFile->getOver())){
  743.                     $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + ((-1) * $productInFile->getOver()));
  744.                 }
  745.             }
  747.             // IVA
  748.             //FIN: Validaciones para el sub total
  750.             //Si las fechas de inicio y fin no coinciden con el campo dias se debe enviar alerta
  751.             $txtWarning = ($productInFile->getDateOutAt()->diff($productInFile->getDateInAt()))->days + 1 <> $productInFile->getDays() ? '<br>'.$productInFile->getProductName() : '';
  752.             if (!empty($txtWarning)){
  753.                 if (empty($srvInconsistentes)){ $srvInconsistentes = 'Hay inconsistencias en: '.'<br>'.$txtWarning; } else { $srvInconsistentes = $srvInconsistentes.'<br>'.$txtWarning; }
  754.             }
  756.             $em->persist($productInFile);
  757.             $em->flush();
  758.             $em->clear();
  760.             //INICIO: Duplicamos en Eventos (SINCRONIZACION)
  761.             if (!empty($productInFile->getOriginId())){
  762.                 $serviceEvent = $em->getRepository(ProposalSupplierServices::class)->findOneById($productInFile->getOriginId());
  763.                 $proposalId = $serviceEvent->getProposalId();
  764.                 $oldServiceEvent = array(
  765.                     'activityId' => $serviceEvent->getActivityId(),
  766.                     'assistantId' => $serviceEvent->getAssistantId(),
  767.                     'breakdown' => $serviceEvent->getBreakdown(),
  768.                     'commission' => $serviceEvent->getCommission(),
  769.                     'controlId' => $serviceEvent->getControlId(),
  770.                     'currency' => $serviceEvent->getCurrency(),
  771.                     'dateBlockLimit' => $serviceEvent->getDateBlockLimit(),
  772.                     'dateInAt' => $serviceEvent->getDateInAt(),
  773.                     'dateOutAt' => $serviceEvent->getDateOutAt(),
  774.                     'destinationId' => $serviceEvent->getDestinationId(),
  775.                     'directPayment' => $serviceEvent->getDirectPayment(),
  776.                     'hour' => $serviceEvent->getHour(),
  777.                     'ideaId' => $serviceEvent->getIdeaId(),
  778.                     'isFather' => $serviceEvent->getIsFather(),
  779.                     'iva' => $serviceEvent->getIva(),
  780.                     'name' => $serviceEvent->getName(),
  781.                     'opCommission' => $serviceEvent->getOpCommission(),
  782.                     'opIva' => $serviceEvent->getOpIva(),
  783.                     'opOver' => $serviceEvent->getOpOver(),
  784.                     'originalIva' => $serviceEvent->getOriginalIva(),
  785.                     'originalPrice' => $serviceEvent->getOriginalPrice(),
  786.                     'originalopIva' => $serviceEvent->getOriginalopIva(),
  787.                     'over' => $serviceEvent->getOver(),
  788.                     'pax' => $serviceEvent->getPax(),
  789.                     'preCommission' => $serviceEvent->getPreCommission(),
  790.                     'preIva' => $serviceEvent->getPreIva(),
  791.                     'price' => $serviceEvent->getPrice(),
  792.                     'proposalId' => $serviceEvent->getProposalId(),
  793.                     'rank' => $serviceEvent->getRank(),
  794.                     'serviceCatId' => $serviceEvent->getServiceCatId(),
  795.                     'serviceCatName' => $serviceEvent->getServiceCatName(),
  796.                     'serviceId' => $serviceEvent->getServiceId(),
  797.                     'serviceIdFather' => $serviceEvent->getServiceIdFather(),
  798.                     'status' => $serviceEvent->getStatus(),
  799.                     'statusRec' => $serviceEvent->getStatusRec(),
  800.                     'statusinternal' => $serviceEvent->getStatusinternal(),
  801.                     'supplierId' => $serviceEvent->getSupplierId(),
  802.                     'units' => $serviceEvent->getUnits(),
  803.                 );
  805.                 if (!empty($serviceEvent)) {
  806.                     $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($serviceEvent->getProposalId());
  807.                     if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  809.                         $serviceEvent->setName($productInFile->getProductName());
  811.                         // Se verifican los precios en ambas partes (AV Express e InOut)
  812.                         if (!($serviceEvent->getPrice() == $productInFile->getServicePrice())) {
  813.                             // Si ambos precios unitarios son distintos se ha modificado el numero de días en Av Express
  814.                             $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  815.                             $serviceEvent->setPrice($newPriceInOut);
  816.                         } else {
  817.                             // si son iguales tambien se deben verificar el numero de dias
  818.                             if (!(($serviceEvent->getDateOutAt()->diff($serviceEvent->getDateInAt())->days + 1) == $productInFile->getDays())) {
  819.                                 $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $item);
  820.                                 $serviceEvent->setPrice($newPriceInOut);
  821.                             }
  822.                         }
  824.                         $serviceEvent->setCurrency($productInFile->getCurrency());
  825.                         $serviceEvent->setUnits($productInFile->getUnits());
  826.                         if (empty($productInFile->getPax())) {
  827.                             $serviceEvent->setPax(1);
  828.                         } else {
  829.                             $serviceEvent->setPax($productInFile->getPax());
  830.                         }
  831.                         $serviceEvent->setDateInAt($productInFile->getDateInAt());
  832.                         $serviceEvent->setDateOutAt($productInFile->getDateOutAt());
  834.                         // Se verifican los precios en ambas partes (AV Express e InOut)
  835.                         if (!($serviceEvent->getPrice() == $productInFile->getServicePrice())) {
  836.                             // Si ambos precios unitarios son distintos se ha modificado el numero de días en Av Express
  837.                             $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  838.                             $serviceEvent->setPrice($newPriceInOut);
  839.                         } else {
  840.                             // si son iguales tambien se deben verificar el numero de dias
  841.                             if (!(($serviceEvent->getDateOutAt()->diff($serviceEvent->getDateInAt())->days + 1) == $productInFile->getDays())) {
  842.                                 $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  843.                                 $serviceEvent->setPrice($newPriceInOut);
  844.                             }
  845.                         }
  847.                         //Verificamos cambios e informamos al agente del proposal
  848.                         $boolChanges = false;
  849.                         if (!($serviceEvent->getRank() == $oldServiceEvent['rank'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Orden</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['rank'].', su nuevo valor es: '.$serviceEvent->getRank().'<br>'; $boolChanges = true; }
  850.                         if (!($serviceEvent->getName() == $oldServiceEvent['name'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Nombre</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['name'].', su nuevo valor es: '.$serviceEvent->getName().'<br>'; $boolChanges = true; }
  851.                         if (!($serviceEvent->getPrice() == $oldServiceEvent['price'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Precio</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['price'].', su nuevo valor es: '.$serviceEvent->getPrice().'<br>'; $boolChanges = true; }
  852.                         if (!($serviceEvent->getCurrency() == $oldServiceEvent['currency'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Moneda</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['currency'].', su nuevo valor es: '.$serviceEvent->getCurrency().'<br>'; $boolChanges = true; }
  853.                         if (!($serviceEvent->getUnits() == $oldServiceEvent['units'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Cantidad</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['units'].', su nuevo valor es: '.$serviceEvent->getUnits().'<br>'; $boolChanges = true; }
  854.                         if (!($serviceEvent->getPax() == $oldServiceEvent['pax'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Personas</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['pax'].', su nuevo valor es: '.$serviceEvent->getPax().'<br>'; $boolChanges = true; }
  855.                         if (!($serviceEvent->getOpOver() == $oldServiceEvent['opOver'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Opción (-/+) del Over</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['opOver'].', su nuevo valor es: '.$serviceEvent->getOpOver().'<br>'; $boolChanges = true; }
  856.                         if (!($serviceEvent->getOver() == $oldServiceEvent['over'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Over</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['over'].', su nuevo valor es: '.$serviceEvent->getOver().'<br>'; $boolChanges = true; }
  857.                         if (!($serviceEvent->getOpCommission() == $oldServiceEvent['opCommission'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Opción (-/+) de la Comisión</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['opCommission'].', su nuevo valor es: '.$serviceEvent->getOpCommission().'<br>'; $boolChanges = true; }
  858.                         if (!($serviceEvent->getCommission() == $oldServiceEvent['commission'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Comisión" ha sido modificado. Su valor era: '.$oldServiceEvent['commission'].', su nuevo valor es: '.$serviceEvent->getCommission().'<br>'; $boolChanges = true; }
  859.                         if (!($serviceEvent->getOpIva() == $oldServiceEvent['opIva'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Opción (-/+) del Iva</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['opIva'].', su nuevo valor es: '.$serviceEvent->getOpIva().'<br>'; $boolChanges = true; }
  860.                         if (!($serviceEvent->getIva() == $oldServiceEvent['iva'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Iva</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['iva'].', su nuevo valor es: '.$serviceEvent->getIva().'<br>'; $boolChanges = true; }
  861.                         if (!($serviceEvent->getDateInAt()->format('H:i') == $oldServiceEvent['dateInAt']->format('H:i'))){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Hora inicio</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['dateInAt']->format('H:i').', su nuevo valor es: '.$serviceEvent->getDateInAt()->format('H:i').'<br>'; $boolChanges = true; }
  862.                         if (!($serviceEvent->getDateInAt()->format('Ymd') == $oldServiceEvent['dateInAt']->format('Ymd'))){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Fecha inicio</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['dateInAt']->format('d/m/Y').', su nuevo valor es: '.$serviceEvent->getDateInAt()->format('d/m/Y').'<br>'; $boolChanges = true; }
  863.                         if (!($serviceEvent->getDateOutAt()->format('H:i') == $oldServiceEvent['dateOutAt']->format('H:i'))){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Hora fin</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['dateOutAt']->format('H:i').', su nuevo valor es: '.$serviceEvent->getDateOutAt()->format('H:i').'<br>'; $boolChanges = true; }
  864.                         if (!($serviceEvent->getDateOutAt()->format('Ymd') == $oldServiceEvent['dateOutAt']->format('Ymd'))){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$serviceEvent->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Fecha fin</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['dateOutAt']->format('d/m/Y').', su nuevo valor es: '.$serviceEvent->getDateOutAt()->format('d/m/Y').'<br>'; $boolChanges = true; }
  866.                         $em->persist($serviceEvent);
  867.                         $em->flush();
  868.                         $em->clear();
  869.                     }
  870.                 }
  871.             }
  872.             //FIN: Duplicamos en Eventos
  873.         }
  875.         // Notificamos al agente de InOut si se hicieron actualizaciones en los servicios desde AvExpress
  876.         if (!empty($txtOfChanges)) { $this->messageOfChangesToAgent($txtOfChanges, $proposalId); }
  878.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  880.         $event = 'Servicios guardados correctamente.';
  881.         $successMessage = $this->translator->trans($event);
  882.         $this->addFlash('mensajeav', $successMessage);
  884.         if (!empty($srvInconsistentes) and !empty($file->getIdProposal())){ $this->addFlash('mensajeaverror', $srvInconsistentes); }
  886.         // Si el proposalId esta vacio no se notifica a nadie por Telegram
  887.         if (empty($file->getIdProposal())){$logTelegram = false;}
  889.         //INICIO: Notificamos al agente por Telegram
  890.         if ($logTelegram){
  891.             //Buscamos todos los agentes del proposal
  892.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($file->getIdProposal());
  894.             //Buscamos el Destino
  895. //            $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  897.             //Buscamos el agente de Develup
  898.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  900.             if (!empty($proposalAgents) and !($user_id == 22)){
  901.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  902.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID2) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  903.                 }
  904.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  905.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID2) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  906.                 }
  907.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  908.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID2) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  909.                 }
  910.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  911.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID2) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  912.                 }
  913.             }
  914.         }
  915.         //FIN: Notificamos al agente por Telegram
  917.         return $this->redirectToRoute('ave_edit_file', array('id' => $fileId));
  918.     }
  921.     /**
  922.      * @Route("/productfilelistmultiple/{id}",  name="ave_list_multiple_productfile")
  923.      * Listar multiples productos para agregar en el expediente id
  924.      */
  925.     public function listMultipleProductFileAction( $id, Request $request){
  927.         $em = $this->getDoctrine()->getManager();
  928. //        $avs = $em->getRepository(AveProduct::class)->findAll();
  930.         // Listamos por orden alfabetico y se deja de primero a "Otro servicio"
  931.         $parameters = array();
  932.         $dql = 'SELECT i
  933.                     FROM AvexpressBundle:AveProduct i
  934.                     ORDER BY i.name ASC';
  935.         $query = $em->createQuery($dql)->setParameters($parameters);
  936.         $avs = $query->getResult();
  937.         $newAvs = array();
  939.         foreach ($avs as $key => $item) {
  940.             if ($item->getName() == 'Otro servicio'){
  941.                 $item->setName('0 - Otro servicio');
  942.                 $newAvs = array($item);
  943.                 unset($avs[$key]);
  944.                 foreach ($avs as $keyTwo => $elem){
  945.                     $ind = $keyTwo + 1;
  946.                     $elem->setName($ind.' - '.$elem->getName());
  947.                     array_push($newAvs,$elem);
  948.                 }
  949.             }
  950.         }
  951.         $avs = $newAvs;
  953.         /* av Description*/
  954.         $data_av = array();
  955.         foreach($avs as $av){
  957.             $data_av[] = array(
  958.                 'id' => $av->getId(),
  959.                 'name' => $av->getName(),
  960.                 'modules' => null,
  961.                 'type' => $av->getType(),
  962.                 'currency' => 'Euro',
  963.                 'price' => $av->getPrice(),
  964.                 'commission' => 0,
  965.                 'iva' => 21,
  966.                 'controlId' => 0,
  967.                 'description' => null
  968.             );
  969.         }
  971.         // Buscamos las plantilas precargadas
  972.         $parameters = array();
  973.         $dql = 'SELECT i
  974.                     FROM AvexpressBundle:AveTemplate i
  975.                     ORDER BY i.name ASC';
  976.         $query = $em->createQuery($dql)->setParameters($parameters);
  977.         $aveTemplates = $query->getResult();
  979.         // Buscamos las proformas
  980.         $proformas = $em->getRepository(AveDocProforma::class)->findByFileId($id);
  982.         return $this->render('MDS/AvexpressBundle/Avexpress/add-services.html.twig',
  983.             array(
  984.                 'id' => $id,
  985.                 'avs' => $data_av,
  986.                 'newAvs' => $newAvs,
  987.                 'aveTemplates' => $aveTemplates,
  988.                 'proformas' => $proformas,
  989.                 'technology' => null,
  990.             ));
  991.     }
  994.     /**
  995.      * @Route("/productfilemultipleadd/",  name="ave_add_multiple_productfile")
  996.      * Agregar multiples productos a un expediente
  997.      */
  998.     public function addMultipleProductFileAction( Request $request){
  999.         $logTelegram = false;
  1000.         $fileId = $request->request->get('fileId');
  1001.         $products = $request->request->get('av');
  1002.         $template = $request->request->get('avexpress');
  1003.         $template = $template['template'];
  1004.         $srvDestination = $request->request->get('srvDestination');
  1006.         /* Obtengo usuario logueado */
  1007.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1008.         $user_id = $user_logueado->getId();
  1010.         $em = $this->getDoctrine()->getManager();
  1011.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  1012.         $template = $em->getRepository(AveTemplate::class)->findOneById($template);
  1014.         if(!empty($products)) {
  1015.             foreach ($products as $item) {
  1017.                 $mdvProductSelected = $em->getRepository(AveProduct::class)->findOneById($item);
  1019.                 $newProductFile = new AveProductFile();
  1020.                 $newProductFile->setProductName($mdvProductSelected->getName());
  1021.                 $newProductFile->setProductId($mdvProductSelected->getId());
  1022.                 $newProductFile->setServicePrice($mdvProductSelected->getPrice());
  1023.                 $newProductFile->setDescription($mdvProductSelected->getDescription());
  1024.                 $newProductFile->setType($mdvProductSelected->getType());
  1025.                 $newProductFile->setFileId($fileId);
  1026.                 $newProductFile->setUnits('1');
  1027.                 $newProductFile->setOpIva(true);
  1028.                 $newProductFile->setIva('21');
  1029.                 $newProductFile->setSupplierExt($mdvProductSelected->getSupplierExt());
  1030.                 $newProductFile->setSupplierExtId($mdvProductSelected->getSupplierExtId());
  1031.                 $dataDates = $this->obtenerFechas($newProductFile->getFileId(), $newProductFile->getDateStart(), $newProductFile->getDateEnd());
  1032.                 $newProductFile->setDateStart($dataDates['dateStart']);
  1033.                 $newProductFile->setDateEnd($dataDates['dateEnd']);
  1034.                 $newProductFile->setDateInAt($dataDates['dateStart']);
  1035.                 $newProductFile->setDateOutAt($dataDates['dateEnd']);
  1037.                 $dataRankAv = $this->obtenerRankAv($fileId);
  1038.                 $newProductFile->setRankAv($dataRankAv);
  1040.                 $newProductFile->setCreatedId($user_id);
  1041.                 $newProductFile->setUpdatedId($user_id);
  1042.                 $newProductFile->setCreatedAt(new \DateTime("now"));
  1043.                 $newProductFile->setUpdatedAt(new \DateTime("now"));
  1045.                 if (empty($newProductFile->getType())){ $newProductFile->setType('Otros'); }
  1047.                 $newProductFile->setDays((($newProductFile->getDateEnd()->diff($newProductFile->getDateStart()))->days + 1));
  1048.                 $newProductFile->setSubTotalPrice($newProductFile->getServicePrice() * $newProductFile->getDays());
  1050.                 $em->persist($newProductFile);
  1051.                 $em->flush();
  1053.                 if (!($srvDestination == 0)){
  1054.                     //Se debe agregar el producto a una proforma
  1055.                     $this->addProductFileToProforma($fileId, $newProductFile->getId(), $srvDestination);
  1056.                 }
  1058.                 // Si hay proposal se debe actualizar en el expediente de Eventos
  1059.                 if (!empty($file->getIdProposal()) and is_numeric($file->getIdProposal())) {
  1061.                     // Buscamos el destino donde se encuentre Av Express y ahi agregamos el servicio, si no se encuentra no se agregara el servicio
  1062.                     $control = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  1063.                         array(
  1064.                             'supplierId' => 80,                                          // El supplier 80 es AVEXPRESS
  1065.                             'proposalId' => $file->getIdProposal(),
  1066.                         )
  1067.                     );
  1069.                     if (!empty($control)) {
  1070.                         // Existe un destino con Av Express como proveedor, hay se agregara el servicio
  1072.                         $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($file->getIdProposal());
  1073.                         if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  1074.                             $logTelegram = true;
  1076.                             $service = new ProposalSupplierServices();
  1077.                             $service->setServiceIdFather(0);
  1078.                             $service->setControlId($control->getId());
  1079.                             $service->setProposalId($file->getIdProposal());
  1080.                             $service->setDestinationId($control->getDestinoId());
  1081.                             $service->setSupplierId(80);
  1082.                             $service->setIdeaId(null);
  1083.                             $service->setServiceId($newProductFile->getProductId());
  1084.                             $service->setServiceCatName('Av');
  1085.                             $service->setServiceCatId(3);
  1086.                             $service->setName($newProductFile->getProductName());
  1088.                             $service->setPrice($newProductFile->getSubTotalPrice() / $newProductFile->getDays());
  1089. //                        $priceInOut = $newProductFile->getSubTotalPrice() / $newProductFile->getPax();      // Se devuelve el calculo dividiendo entre personas
  1090. //                        $priceInOut = $priceInOut / $newProductFile->getUnits();                            // Se devuelve el calculo dividiendo entre cantidades
  1091. //                        $priceInOut = $priceInOut / round($newProductFile->getDays());                      // Se devuelve el calculo dividiendo entre dias, se redondea por si es 1.5
  1092. //                        $service->setPrice($priceInOut);
  1094.                             $service->setCurrency($newProductFile->getCurrency());
  1095.                             $service->setUnits($newProductFile->getUnits());
  1096.                             $service->setCommission(0);
  1097.                             $service->setOver(0);
  1098.                             $service->setIva(21);
  1099.                             $service->setPax(1);
  1100.                             $service->setHour(null);
  1101.                             $service->setDateInAt($newProductFile->getDateInAt());
  1102.                             $service->setDateOutAt($newProductFile->getDateOutAt());
  1103.                             $service->setDirectPayment(0);
  1104.                             $service->setStatus('Pending');
  1105.                             $service->setStatusinternal('Additional');
  1106.                             $service->setPreCommission(null);
  1107.                             $service->setPreIva(null);
  1108.                             $service->setDateBlockLimit(null);
  1109.                             $service->setOpCommission(1);
  1110.                             $service->setOpOver(1);
  1111.                             $service->setOpIva(1);
  1112.                             $service->setBreakdown(0);
  1113.                             $service->setIsFather(0);
  1114.                             $service->setRank(1);
  1115.                             $service->setOriginalopIva(1);
  1116.                             $service->setOriginalIva(null);
  1117.                             $service->setOriginalPrice(null);
  1118.                             $service->setStatusRec('normal');
  1119.                             $service->setAssistantId(null);
  1120.                             $service->setCreatedId($user_id);
  1121.                             $service->setUpdatedId($user_id);
  1122.                             $service->setCreatedAt(new \DateTime("now"));
  1123.                             $service->setUpdatedAt(new \DateTime("now"));
  1125.                             $em->persist($service);
  1126.                             $em->flush();
  1128.                             // Guardamos el ID del servicio (Eventos) asociado al producto (AvExpress)
  1129.                             $newProductFile->setOriginId($service->getId());
  1131.                             $em->persist($newProductFile);
  1132.                             $em->flush();
  1133.                         }
  1134.                     }
  1135.                 }
  1136.             }
  1137.         }
  1139.         // Buscamos los elementos de la plantilla seleccionada
  1140.         $templateItems = array();
  1141.         if(!empty($template)){
  1142.             $templateItems = $em->getRepository(AveTemplateItems::class)->findByTemplateId($template);
  1143.         }
  1145.         foreach ($templateItems as $item){
  1147.             $newProductFile = new AveProductFile();
  1148.             $newProductFile->setProductName($item->getProductName());
  1149.             $newProductFile->setProductId($item->getProductId());
  1150.             $newProductFile->setServicePrice($item->getServicePrice());
  1151.             $newProductFile->setFileId($fileId);
  1152.             $newProductFile->setPax($item->getPax());
  1153.             $newProductFile->setType($item->getType());
  1154.             $newProductFile->setHourStart($item->getHourStart());
  1155.             $newProductFile->setMinStart($item->getMinStart());
  1156.             $newProductFile->setHourEnd($item->getHourEnd());
  1157.             $newProductFile->setMinEnd($item->getMinEnd());
  1158.             $newProductFile->setDescription($item->getDescription());
  1159.             $newProductFile->setSupplierExtId($item->getSupplierExtId());
  1160.             $newProductFile->setSupplierExt($item->getSupplierExt());
  1161.             $newProductFile->setServiceIdProposal($item->getServiceIdProposal());
  1162.             $newProductFile->setServiceIdFather($item->getServiceIdFather());
  1163.             $newProductFile->setControlId($item->getControlId());
  1164.             $newProductFile->setProposalId($item->getProposalId());
  1165.             $newProductFile->setDestinationId($item->getDestinationId());
  1166.             $newProductFile->setIdeaId($item->getIdeaId());
  1167.             $newProductFile->setActivityId($item->getActivityId());
  1168.             $newProductFile->setSupplierId($item->getSupplierId());
  1169.             $newProductFile->setAssistantId($item->getAssistantId());
  1170.             $newProductFile->setServiceId($item->getServiceId());
  1171.             $newProductFile->setServiceCatId($item->getServiceCatId());
  1172.             $newProductFile->setServiceCatName($item->getServiceCatName());
  1173.             $newProductFile->setName($item->getName());
  1174.             $newProductFile->setPrice($item->getPrice());
  1175.             $newProductFile->setCurrency($item->getCurrency());
  1176.             $newProductFile->setUnits($item->getUnits());
  1177.             $newProductFile->setOpCommission($item->getOpCommission());
  1178.             $newProductFile->setCommission($item->getCommission());
  1179.             $newProductFile->setOpOver($item->getOpOver());
  1180.             $newProductFile->setOver($item->getOver());
  1181.             $newProductFile->setOpIva($item->getOpIva());
  1182.             $newProductFile->setIva($item->getIva());
  1183.             $newProductFile->setHour($item->getHour());
  1185.             $dataDates = $this->obtenerFechas($newProductFile->getFileId(), $newProductFile->getDateStart(), $newProductFile->getDateEnd());
  1186.             $newProductFile->setDateStart($dataDates['dateStart']);
  1187.             $newProductFile->setDateEnd($dataDates['dateEnd']);
  1188.             $newProductFile->setDateInAt($dataDates['dateStart']);
  1189.             $newProductFile->setDateOutAt($dataDates['dateEnd']);
  1191.             $newProductFile->setContcolor($item->getContcolor());
  1192.             $newProductFile->setRank($item->getRank());
  1194.             $dataRankAv = $this->obtenerRankAv($fileId);
  1195.             $newProductFile->setRankAv($dataRankAv);
  1197.             $newProductFile->setRenovate($item->getRenovate());
  1198.             $newProductFile->setPay($item->getPay());
  1199.             $newProductFile->setDays($item->getDays());
  1200.             $newProductFile->setSubTotalPrice($item->getSubTotalPrice());
  1202.             $newProductFile->setCreatedId($user_id);
  1203.             $newProductFile->setUpdatedId($user_id);
  1204.             $newProductFile->setCreatedAt(new \DateTime("now"));
  1205.             $newProductFile->setUpdatedAt(new \DateTime("now"));
  1207.             if (empty($newProductFile->getType())){ $newProductFile->setType('Otros'); }
  1209.             $em->persist($newProductFile);
  1210.             $em->flush();
  1212.             if (!($srvDestination == 0)){
  1213.                 //Se debe agregar el producto a una proforma
  1214.                 $this->addProductFileToProforma($fileId, $newProductFile->getId(), $srvDestination);
  1215.             }
  1217.             // Si hay proposal se debe actualizar en el expediente de Eventos
  1218.             if (!empty($file->getIdProposal()) and is_numeric($file->getIdProposal())){
  1220.                 // Buscamos el destino donde se encuentre Av Express y ahi agregamos el servicio, si no se encuentra no se agregara el servicio
  1221.                 $control = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  1222.                     array(
  1223.                         'supplierId' => 80,                                          // El supplier 80 es AVEXPRESS
  1224.                         'proposalId' => $file->getIdProposal(),
  1225.                     )
  1226.                 );
  1228.                 if (!empty($control)){
  1229.                     // Existe un destino con Av Express como proveedor, hay se agregara el servicio
  1230.                     $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($file->getIdProposal());
  1231.                     if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  1232.                         $logTelegram = true;
  1234.                         $service = new ProposalSupplierServices();
  1235.                         $service->setServiceIdFather(0);
  1236.                         $service->setControlId($control->getId());
  1237.                         $service->setProposalId($file->getIdProposal());
  1238.                         $service->setDestinationId($control->getDestinoId());
  1239.                         $service->setSupplierId(80);
  1240.                         $service->setIdeaId(null);
  1241.                         $service->setServiceId($newProductFile->getProductId());
  1242.                         $service->setServiceCatName('Av');
  1243.                         $service->setServiceCatId(3);
  1244.                         $service->setName($newProductFile->getProductName());
  1245.                         $service->setPrice($newProductFile->getSubTotalPrice());
  1246.                         $service->setCurrency(null);
  1247.                         $service->setUnits(1);
  1248.                         $service->setCommission(0);
  1249.                         $service->setOver(0);
  1250.                         $service->setIva(21);
  1251.                         $service->setPax(0);
  1252.                         $service->setHour(null);
  1253.                         $service->setDateInAt(new \DateTime("now"));
  1254.                         $service->setDateOutAt(new \DateTime("now"));
  1255.                         $service->setDirectPayment(0);
  1256.                         $service->setStatus('Pending');
  1257.                         $service->setStatusinternal('Additional');
  1258.                         $service->setPreCommission(null);
  1259.                         $service->setPreIva(null);
  1260.                         $service->setDateBlockLimit(null);
  1261.                         $service->setOpCommission(1);
  1262.                         $service->setOpOver(1);
  1263.                         $service->setOpIva(1);
  1264.                         $service->setBreakdown(0);
  1265.                         $service->setIsFather(0);
  1266.                         $service->setRank(1);
  1267.                         $service->setOriginalopIva(1);
  1268.                         $service->setOriginalIva(null);
  1269.                         $service->setOriginalPrice(null);
  1270.                         $service->setStatusRec('normal');
  1271.                         $service->setAssistantId(null);
  1272.                         $service->setCreatedId($user_id);
  1273.                         $service->setUpdatedId($user_id);
  1274.                         $service->setCreatedAt(new \DateTime("now"));
  1275.                         $service->setUpdatedAt(new \DateTime("now"));
  1277.                         $em->persist($service);
  1278.                         $em->flush();
  1280.                         // Guardamos el ID del servicio (Eventos) asociado al producto (AvExpress)
  1281.                         $newProductFile->setOriginId($service->getId());
  1283.                         $em->persist($newProductFile);
  1284.                         $em->flush();
  1285.                     }
  1286.                 }
  1287.             }
  1288.         }
  1290.         //INICIO: Notificamos al agente por Telegram
  1291.         if ($logTelegram){
  1292.             //Buscamos todos los agentes del proposal
  1293.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($file->getIdProposal());
  1295.             //Buscamos el Destino
  1296.             $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  1298.             //Buscamos el agente de AvExpress
  1299.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  1301.             if (!empty($proposalAgents) and !($user_id == 22)){
  1302.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  1303.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1304.                 }
  1305.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  1306.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1307.                 }
  1308.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  1309.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1310.                 }
  1311.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  1312.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1313.                 }
  1314.             }
  1315.         }
  1316.         //FIN: Notificamos al agente por Telegram
  1318.         return $this->redirectToRoute('ave_edit_file',
  1319.             array(
  1320.                 'id' => $fileId
  1321.             )
  1322.         );
  1323.     }
  1326.     /**
  1327.      * @Route("/productfileedit/{id}",  name="ave_productfile_edit")
  1328.      * Editar un producto de un expediente
  1329.      */
  1330.     public function editProductFileAction($id, Request $request){
  1332.         $em = $this->getDoctrine()->getManager();
  1333.         $productFile = $em->getRepository(AveProductFile::class)->findOneById($id);
  1335.         $fileId = $productFile->getFileId();
  1337.         // Primero se agrupan por sala (Ubicacion), luego por tipo y finalmente por RankAv
  1338.         // Salvador Guerrero indico, el orden de los productos en la factura o proforma será (Video - Sonido - Iluminacion - Otros)
  1340.         $allProductFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  1341.         $arrayLocation = array();
  1342.         $arrayLocationWithNull = false;
  1343.         foreach ($allProductFile as $item){
  1344.             if (!empty($item->getLocation())){
  1345.                 $arrayLocation[$item->getLocation()] = $item->getLocation();
  1346.             } else {
  1347.                 $arrayLocationWithNull = true;
  1348.             }
  1349.         }
  1350.         if ($arrayLocationWithNull){ $arrayLocation['null'] = 'null'; }
  1352.         $productInFile = array();
  1354.         foreach ($arrayLocation as $item){
  1355.             // VIDEO
  1356.             $parameters = array(
  1357.                 'fileId' => $fileId,
  1358.                 'type' => 'Vídeo',
  1359.                 'location' => $item,
  1360.             );
  1361.             $dql = 'SELECT i
  1362.                     FROM AvexpressBundle:AveProductFile i
  1363.                     WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location
  1364.                     ORDER BY i.rankAv ASC';
  1365.             $query = $em->createQuery($dql)->setParameters($parameters);
  1366.             $productsInFileVid = $query->getResult();
  1368.             // SONIDO
  1369.             $parameters = array(
  1370.                 'fileId' => $fileId,
  1371.                 'type' => 'Sonido',
  1372.                 'location' => $item,
  1373.             );
  1374.             $dql = 'SELECT i
  1375.                     FROM AvexpressBundle:AveProductFile i
  1376.                     WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location
  1377.                     ORDER BY i.rankAv ASC';
  1378.             $query = $em->createQuery($dql)->setParameters($parameters);
  1379.             $productsInFileSound = $query->getResult();
  1381.             // ILUMINACION
  1382.             $parameters = array(
  1383.                 'fileId' => $fileId,
  1384.                 'type' => 'Iluminación',
  1385.                 'location' => $item,
  1386.             );
  1387.             $dql = 'SELECT i
  1388.                     FROM AvexpressBundle:AveProductFile i
  1389.                     WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location
  1390.                     ORDER BY i.rankAv ASC';
  1391.             $query = $em->createQuery($dql)->setParameters($parameters);
  1392.             $productsInFileLights = $query->getResult();
  1394.             // OTROS
  1395.             $parameters = array(
  1396.                 'fileId' => $fileId,
  1397.                 'typeV' => 'Vídeo',
  1398.                 'typeS' => 'Sonido',
  1399.                 'typeI' => 'Iluminación',
  1400.                 'location' => $item,
  1401.             );
  1402.             $dql = 'SELECT i
  1403.                     FROM AvexpressBundle:AveProductFile i
  1404.                     WHERE (i.fileId = :fileId AND i.type != :typeV AND i.type != :typeS AND i.type != :typeI AND i.location = :location)
  1405.                     ORDER BY i.rankAv ASC';
  1406.             $query = $em->createQuery($dql)->setParameters($parameters);
  1407.             $productsInFileOther = $query->getResult();
  1409.             // CASO NULL (Los casos EMPTY estan considerados en las consultas previas)
  1410.             $parameters = array(
  1411.                 'fileId' => $fileId,
  1412.                 'location' => $item,
  1413.             );
  1414.             $dql = 'SELECT i
  1415.                     FROM AvexpressBundle:AveProductFile i
  1416.                     WHERE (i.fileId = :fileId AND i.type IS NULL AND i.location = :location)
  1417.                     ORDER BY i.rankAv ASC';
  1418.             $query = $em->createQuery($dql)->setParameters($parameters);
  1419.             $productsInFileNull = $query->getResult();
  1421.             // Para el location en NULL el SQL tiene que ser diferente por eso el siguiente condicional
  1422.             if ($item == 'null'){
  1424.                 // VIDEO
  1425.                 $parameters = array(
  1426.                     'fileId' => $fileId,
  1427.                     'type' => 'Vídeo',
  1428.                     'location' => '',
  1429.                 );
  1430.                 $dql = 'SELECT i
  1431.                         FROM AvexpressBundle:AveProductFile i
  1432.                         WHERE i.fileId = :fileId AND i.type = :type AND (i.location IS NULL OR i.location = :location)
  1433.                         ORDER BY i.rankAv ASC';
  1434.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1435.                 $productsInFileVid = $query->getResult();
  1437.                 // SONIDO
  1438.                 $parameters = array(
  1439.                     'fileId' => $fileId,
  1440.                     'type' => 'Sonido',
  1441.                     'location' => '',
  1442.                 );
  1443.                 $dql = 'SELECT i
  1444.                         FROM AvexpressBundle:AveProductFile i
  1445.                         WHERE i.fileId = :fileId AND i.type = :type AND (i.location IS NULL OR i.location = :location) 
  1446.                         ORDER BY i.rankAv ASC';
  1447.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1448.                 $productsInFileSound = $query->getResult();
  1450.                 // ILUMINACION
  1451.                 $parameters = array(
  1452.                     'fileId' => $fileId,
  1453.                     'type' => 'Iluminación',
  1454.                     'location' => '',
  1455.                 );
  1456.                 $dql = 'SELECT i
  1457.                         FROM AvexpressBundle:AveProductFile i
  1458.                         WHERE i.fileId = :fileId AND i.type = :type AND (i.location IS NULL OR i.location = :location)
  1459.                         ORDER BY i.rankAv ASC';
  1460.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1461.                 $productsInFileLights = $query->getResult();
  1463.                 // OTROS
  1464.                 $parameters = array(
  1465.                     'fileId' => $fileId,
  1466.                     'typeV' => 'Vídeo',
  1467.                     'typeS' => 'Sonido',
  1468.                     'typeI' => 'Iluminación',
  1469.                     'location' => '',
  1470.                 );
  1471.                 $dql = 'SELECT i
  1472.                         FROM AvexpressBundle:AveProductFile i
  1473.                         WHERE (i.fileId = :fileId AND i.type != :typeV AND i.type != :typeS AND i.type != :typeI AND (i.location IS NULL OR i.location = :location))
  1474.                         ORDER BY i.rankAv ASC';
  1475.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1476.                 $productsInFileOther = $query->getResult();
  1478.                 // CASO NULL DEL TIPO (Los casos EMPTY estan considerados en las consultas previas)
  1479.                 $parameters = array(
  1480.                     'fileId' => $fileId,
  1481.                     'location' => '',
  1482.                 );
  1483.                 $dql = 'SELECT i
  1484.                         FROM AvexpressBundle:AveProductFile i
  1485.                         WHERE (i.fileId = :fileId AND i.type IS NULL AND (i.location IS NULL OR i.location = :location))
  1486.                         ORDER BY i.rankAv ASC';
  1487.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1488.                 $productsInFileNull = $query->getResult();
  1489.             }
  1490.             $productInFile = array_merge($productInFile,$productsInFileVid, $productsInFileSound, $productsInFileLights, $productsInFileOther, $productsInFileNull);
  1491.         }
  1494.         $parameters = array();
  1495.         $dql = 'SELECT p.id, p.name
  1496.                 FROM App\Entity\Supplier p
  1497.                 WHERE p.isSupplierAvExpress = TRUE 
  1498.                 ORDER BY p.name ASC ';
  1500.         $query = $em->createQuery($dql)->setParameters($parameters);
  1501.         $suppliers = $query->getResult();
  1503.         // Quitamos el elemento seleccionado para evitar duplicaciones
  1504.         foreach ($productInFile as $key => $item) {
  1505.             if ($productFile->getId() == $item->getId()){
  1506.                 unset($productInFile[$key]);
  1507.             }
  1508.         }
  1509.         $id = $productFile->getFileId();
  1510.         $numeroItems = sizeof($productInFile) + 1;
  1512.         $productsLocation = $em->getRepository(AveProductFileLocationNames::class)->findAll();
  1514.         return $this->render('MDS/AvexpressBundle/Avexpress/edit-productfiles.html.twig',
  1515.             array(
  1516.                 'id' => $id,
  1517.                 'numeroItems' => $numeroItems,
  1518.                 'arrayProductFile' => $productInFile,
  1519.                 'services' => $productInFile,
  1520.                 'product' => array($productFile),
  1521.                 'suppliers' => $suppliers,
  1522.                 'productsLocation' => $productsLocation,
  1523.             ));
  1524.     }
  1527.     /**
  1528.      * @Route("/cleanproductfile/{id}",  name="ave_clean_productfile")
  1529.      * Eliminar los productos (y servicios en InOut) de un expediente que no estén relacionados con una factura o una proforma
  1530.      */
  1531.     public function cleanProductFileAction($id, Request $request)
  1532.     {
  1533.         $em = $this->getDoctrine()->getManager();
  1535.         /* Obtengo usuario logueado */
  1536.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1537.         $user_id = $user_logueado->getId();
  1539.         $allMdvProductSelected = $em->getRepository(AveProductFile::class)->findByFileId($id);
  1541.         // Si el ProductFile esta asociado a una factura o a una proforma se mantiene, de lo contrario se elimina y su evento asociado
  1542.         foreach ($allMdvProductSelected as $key => $item){
  1543.             $isInInvoice = $em->getRepository(AveDocInvoiceItems::class)->findOneByPrdControlId($item->getId());
  1544.             $isInProforma = $em->getRepository(AveDocProformaItems::class)->findOneByControlId($item->getId());
  1546.             if (!empty($isInInvoice) or !empty($isInProforma)){
  1547.                 //Lo sacamos de la lista de elementos a eliminar
  1549.                 unset($allMdvProductSelected[$key]);
  1550.             }
  1551.         }
  1553.         foreach ($allMdvProductSelected as $mdvProductSelected){
  1554.             $logTelegram = false;
  1556.             //INICIO: Si hay un ID origin se debe eliminar en Eventos
  1557.             if (!empty($mdvProductSelected->getOriginId())){
  1558.                 $logTelegram = true;
  1559.                 $delete = $em->getRepository(ProposalSupplierServices::class)->findOneById($mdvProductSelected->getOriginId());
  1560.                 if (!empty($delete)) {
  1561.                     $destinationId = $delete->getDestinationId();
  1562.                     $nameServEvents = $delete->getName();
  1563.                     $proposalId = $delete->getProposalId();
  1564.                     $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($delete->getProposalId());
  1565.                     if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  1566.                         if (!empty($delete)) {
  1567.                             $delete_sub = $em->getRepository(ProposalSupplierServices::class)->findByServiceIdFather($delete->getId());
  1568.                             foreach ($delete_sub as $deletesub) {
  1569.                                 $em->remove($deletesub);
  1570.                             }
  1572.                             $em->remove($delete);
  1573.                             $em->flush();
  1574.                         }
  1575.                     }
  1576.                 } else {
  1577.                     // El servicio origen no se encontro
  1578.                     $logTelegram = false;
  1579.                 }
  1580.             }
  1582.             //INICIO: Notificamos al agente por Telegram
  1583.             if ($logTelegram){
  1584.                 //Buscamos todos los agentes del proposal
  1585.                 $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposalId);
  1587.                 //Buscamos el Destino
  1588.                 $proposalDestino = $em->getRepository(Destination::class)->findOneById($destinationId);
  1590.                 //Buscamos el agente de Develup
  1591.                 $userData = $em->getRepository(User::class)->findOneById($user_id);
  1593.                 if (!empty($proposalAgents)){
  1594.                     if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  1595.                         $this->sendTelegram($proposalAgents->getAgOne(),'1. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1596.                     }
  1597.                     if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  1598.                         $this->sendTelegram($proposalAgents->getAgTwo(),'2. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1599.                     }
  1600.                     if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  1601.                         $this->sendTelegram($proposalAgents->getAgThree(),'3. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1602.                     }
  1603.                     if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  1604.                         $this->sendTelegram($proposalAgents->getAgFour(),'4. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1605.                     }
  1606.                 }
  1607.             }
  1608.             //FIN: Notificamos al agente por Telegram
  1610.             //FIN: Si hay un ID origin se debe eliminar en Eventos
  1612.             //INICIO: Si el producto se encuentra dentro de una proforma (Ave_Doc_Proforma_Items) se elimina también
  1613.             $productInProforma = $em->getRepository(AveDocProformaItems::class)->findOneByControlId($mdvProductSelected->getId());
  1614.             if (!empty($productInProforma)){
  1615.                 $productInProforma->setFileId((-1) * $productInProforma->getFileId());      // No lo vamos a eliminar, apuntará al fileId en negativo
  1616.                 $em->persist($productInProforma);
  1617.                 // $em->remove($productInProforma);
  1618.                 $em->flush();
  1619.             }
  1620.             //FIN: Si el producto se encuentra dentro de una proforma (Ave_Doc_Proforma_Items) se elimina también
  1622.             $mdvProductSelected->setFileId((-1) * $mdvProductSelected->getFileId());      // No lo vamos a eliminar, apuntará al fileId en negativo
  1623.             $em->persist($mdvProductSelected);
  1624.             // $em->remove($mdvProductSelected);
  1625.             $em->flush();
  1626.         }
  1628.         return $this->redirectToRoute('ave_edit_file', array('id' => $id));
  1629.     }
  1632.     /**
  1633.      * @Route("/overallproductfile/",  name="ave_over_all_productfile")
  1634.      * Aplicar un Over a todos los productos de un expediente
  1635.      */
  1636.     public function overAllProductFileAction(Request $request){
  1638.         $fileId = $request->request->get('fileId');
  1639.         $opOverAll = $request->request->get('opOverAll');
  1640.         $overAll = $request->request->get('overAll');
  1642.         $em = $this->getDoctrine()->getManager();
  1643.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  1645.         foreach ($productInFile as $item){
  1646.             $itemId = $item->getId();
  1647.             $item->setOpOver($opOverAll);
  1648.             $item->setOver($overAll);
  1650.             $em->persist($item);
  1651.             $em->flush();
  1652.         }
  1654.         return $this->redirectToRoute('ave_productfile_edit', array('id' => $itemId));
  1655.     }
  1658.     /**
  1659.      * @Route("/commissionallproductfile/",  name="ave_commission_all_productfile")
  1660.      * Aplicar una Comision a todos los productos de un expediente
  1661.      */
  1662.     public function commissionAllProductFileAction(Request $request){
  1664.         $fileId = $request->request->get('fileId');
  1665.         $opCommissionAll = $request->request->get('opCommissionAll');
  1666.         $commissionAll = $request->request->get('commissionAll');
  1668.         $em = $this->getDoctrine()->getManager();
  1669.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  1671.         foreach ($productInFile as $item){
  1672.             $itemId = $item->getId();
  1673.             $item->setOpCommission($opCommissionAll);
  1674.             $item->setCommission($commissionAll);
  1676.             $em->persist($item);
  1677.             $em->flush();
  1678.         }
  1680.         return $this->redirectToRoute('ave_productfile_edit', array('id' => $itemId));
  1681.     }
  1683.     /**
  1684.      * @Route("/ivazeroallproductfile/",  name="ave_iva_zero_all_productfile")
  1685.      * Aplicar un IVA de cero a todos los productos de un expediente
  1686.      */
  1687.     public function ivaZeroAllProductFileAction(Request $request){
  1688.         $fileId = $request->request->get('fileId');
  1689. //        $opCommissionAll = $request->request->get('opCommissionAll');
  1690. //        $commissionAll = $request->request->get('commissionAll');
  1691.         $em = $this->getDoctrine()->getManager();
  1692.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  1693.         foreach ($productInFile as $item){
  1694.             $itemId = $item->getId();
  1695.             $item->setOpIva(1);
  1696.             $item->setIva(0);
  1697.             
  1698.             $em->persist($item);
  1699.             $em->flush();
  1700.         }
  1701.         return $this->redirectToRoute('ave_productfile_edit', array('id' => $itemId));
  1702.     }
  1703.     
  1706.     /**
  1707.      * @Route("/productfilelocationadd/",  name="ave_add_productfilelocation")
  1708.      * Agregar una Ubicacion. Salas en donde estara el producto
  1709.      */
  1710.     public function addProductFileLocationAction( Request $request)
  1711.     {
  1712.         $em = $this->getDoctrine()->getManager();
  1713.         $newRequest = $request->request->get('product');
  1715.         /* Obtengo usuario logueado */
  1716.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1717.         $user_id = $user_logueado->getId();
  1719.         $newProductFile = new AveProductFileLocationNames();
  1720.         $newProductFile->setName($newRequest['name']);
  1721.         $newProductFile->setDescription($newRequest['description']);
  1723.         $newProductFile->setCreatedId($user_id);
  1724.         $newProductFile->setUpdatedId($user_id);
  1725.         $newProductFile->setCreatedAt(new \DateTime("now"));
  1726.         $newProductFile->setUpdatedAt(new \DateTime("now"));
  1728.         $em->persist($newProductFile);
  1729.         $em->flush();
  1731.         return $this->redirectToRoute('ave_list_productfilelocation');
  1732.     }
  1735.     /**
  1736.      * @Route("/productfilelocationlist/",  name="ave_list_productfilelocation")
  1737.      * Listar Ubicaciones para los productos
  1738.      */
  1739.     public function listProductFileLocationAction(Request $request){
  1740.         $em = $this->getDoctrine()->getManager();
  1741.         $productsLocation = $em->getRepository(AveProductFileLocationNames::class)->findAll();
  1743.         return $this->render('MDS/AvexpressBundle/Avexpress/list-productsfile-locationnames.html.twig',
  1744.             array(
  1745.                 'productsLocation' => $productsLocation,
  1746.             ));
  1747.     }
  1750.     /**
  1751.      * @Route("/productfilelocationedit/{id}",  name="ave_edit_productfilelocation")
  1752.      * Editar una Ubicacion
  1753.      */
  1754.     public function editProductFileLocationAction( $id, Request $request)
  1755.     {
  1756.         $em = $this->getDoctrine()->getManager();
  1757.         $editProductLocation = $em->getRepository(AveProductFileLocationNames::class)->findOneById($id);
  1759.         return $this->render('MDS/AvexpressBundle/Avexpress/edit-productsfiles-location.html.twig',
  1760.             array(
  1761.                 'id' => $editProductLocation->getId(),
  1762.                 'productLocation' => $editProductLocation,
  1763.             ));
  1764.     }
  1767.     /**
  1768.      * @Route("/productfilelocationupdate/",  name="ave_update_productfilelocation")
  1769.      * Update de una Ubicacion
  1770.      */
  1771.     public function updateProductFileLocationAction(Request $request)
  1772.     {
  1773.         $em = $this->getDoctrine()->getManager();
  1774.         $newRequest = $request->request->get('product');
  1775.         $id = $newRequest['id'];
  1776.         $newProduct = $em->getRepository(AveProductFileLocationNames::class)->findOneById($id);
  1778.         /* Obtengo usuario logueado */
  1779.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1780.         $user_id = $user_logueado->getId();
  1782.         if (!empty($newRequest['name'])){$newProduct->setName($newRequest['name']);}
  1784.         $newProduct->setDescription($newRequest['description']);
  1786.         $newProduct->setUpdatedId($user_id);
  1787.         $newProduct->setUpdatedAt(new \DateTime("now"));
  1789.         $em->persist($newProduct);
  1790.         $em->flush();
  1792.         return $this->redirectToRoute('ave_list_productfilelocation');
  1793.     }
  1796.     /**
  1797.      * @Route("/productfilelocationdelete/{id}",  name="ave_delete_productfilelocation")
  1798.      * Eliminar una Ubicacion
  1799.      */
  1800.     public function deleteProductAction($id, Request $request)
  1801.     {
  1802.         $em = $this->getDoctrine()->getManager();
  1803.         $delProduct = $em->getRepository(AveProductFileLocationNames::class)->findOneById($id);
  1805.         if (!empty($delProduct)){
  1806.             $em->remove($delProduct);
  1807.             $em->flush();
  1808.         }
  1810.         return $this->redirectToRoute('ave_list_productfilelocation');
  1811.     }
  1816.     // Replicar cambios entre FileController y ProductsFilesController
  1817.     private function calculosFile($id, $arrayBools, $number, $type)
  1818.     {
  1819.         // $id Id del Expediente (File)
  1820.         // $arrayBool arreglo de logicos
  1821.         // $number  *********************
  1822.         // $type tipo de calculos a realizar (edicion de expediente, factura, factura de deposito, proforma)
  1823.         
  1824.         
  1825.         $em = $this->getDoctrine()->getManager();
  1826.         $file = $em->getRepository(AveFiles::class)->findOneById($id);
  1827.         $items = $em->getRepository(AveProductFile::class)->findByFileId($file->getId());
  1828.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('3');
  1829.         $client = $em->getRepository(Client::class)->findById($file->getClient());
  1830.         if (!empty($client)){
  1831.             $city = ($em->getRepository(Cities::class)->findOneById($client[0]->getPopulation()));
  1832.             $client[0]->setPopulation($city);
  1833.             $region = ($em->getRepository(Regions::class)->findOneById($client[0]->getRegion()));
  1834.             $client[0]->setRegion($region);
  1835.             $country = ($em->getRepository(Country::class)->findOneById($client[0]->getCountry()));
  1836.             $client[0]->setCountry($country);
  1837.         } else {
  1838.             $client[0] = new Client();
  1839.             $client[0]->setName('');
  1840.             $client[0]->setTitle('');
  1841.             $client[0]->setIdDocument('');
  1842.             $client[0]->setPopulation('');
  1843.             $client[0]->setRegion('');
  1844.             $client[0]->setCountry('');
  1845.         }
  1847.         // Acumuladores de los calculos
  1848.         $totales_neto_all = 0;
  1849.         $data_iva = array(
  1850.             'iva' => 21,
  1851.             'ivaMontoVeintiUno' => 0,
  1852.             'ivaMontoDiez' => 0,
  1853.             'ivaMontoCero' => 0,
  1854.         );
  1856.         //INICIO: Determinamos el numero de factura o proforma
  1857.         if (substr($number,0,1) == 'I'){
  1858.             // Es una Factura
  1860.             $numberInvoiceOrProforma = substr($number,1);
  1861.             $number = $numberInvoiceOrProforma;
  1862.             $type = 'Invoice';
  1864.         } else {
  1865.             // Es una Proforma
  1867.             $numberInvoiceOrProforma = substr($number,1);
  1868.             $number = $numberInvoiceOrProforma;
  1869.             $type = 'Proforma';
  1870.         }
  1871.         //FIN: Determinamos el numero de factura o proforma
  1873.         // Buscamos las salas reservadas, pagos y servicios para el evento
  1875.         $arrayItems = array();
  1876.         $fileProducts = array();
  1877.         if (!empty($arrayBools['lounge'])) {
  1878.             foreach ($arrayBools['lounge'] as $key => $item) {
  1879.                 if ($item == 'true') {
  1880. //                    $fileProducts[] = $em->getRepository('DevelupBundle:ReservationLoungeSimple')->findOneById($key);
  1881.                 }
  1882.             }
  1883.         }
  1885.         $payments = array();
  1886.         if (!empty($arrayBools['payment'])) {
  1887.             foreach ($arrayBools['payment'] as $key => $item) {
  1888.                 if ($item == 'true') {
  1889. //                    $payments[] = $em->getRepository('DevelupBundle:ReservationPaymentsClient')->findOneById($key);
  1890.                 }
  1891.             }
  1892.         }
  1894.         $services = array();
  1895.         if (!empty($arrayBools['service'])) {
  1896.             foreach ($arrayBools['service'] as $key => $item) {
  1897.                 if ($item == 'true') {
  1898. //                    $services[] = $em->getRepository('DevelupBundle:ReservationService')->findOneById($key);
  1899.                 }
  1900.             }
  1901.         }
  1903.         $data_supplier = array();
  1904.         $i = 0;
  1906.         $iva = '21';            // Esteban Rincon: "Por Ley de localización del impuesto, siempre será un 21%"
  1907.         $pax = '-';
  1908.         $qty = '1';
  1909.         $product = array(
  1910.             'neto' => 0,
  1911.             'sumSubT' => 0,
  1912.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1914.         $service = array(
  1915.             'neto' => 0,
  1916.             'sumSubT' => 0,
  1917.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1919.         if (empty($items)){
  1920.             $data_supplier['product'][0] = null;
  1921.         }
  1923.         foreach ($items as $item){
  1925.             if (is_null($item->getServicePrice()) or empty($item->getServicePrice())){
  1926.                 $subtotal = 0;
  1927.                 $neto = 0;
  1928.                 $subtotalProduct = 0;
  1929.             } else {
  1931.                 $subtotalProduct = $item->getServicePrice() * 1.21;
  1932.                 $subneto = $item->getServicePrice();
  1934.                 $subtotal =  $subtotalProduct;
  1935.                 $neto =  $subneto;
  1937.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  1938.                 $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  1939.                 $neto = round($neto,2,PHP_ROUND_HALF_UP);
  1941.                 $arrayItems[] = array(
  1942.                     'type' => 'Product',
  1943.                     'name' => $item->getProductName(),
  1944.                     'amount' => $neto,
  1945.                     'iva' => '21',
  1946.                     'total' => $subtotal,
  1947.                 );
  1948.             }
  1950.             // Acumula netos totales e IVA
  1951.             $totales_neto_all = $totales_neto_all + $neto;
  1952.             $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * 0.21);
  1953.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1954.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  1955.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  1956.             // Acumula netos totales e IVA
  1958.             $product['neto'] = $product['neto'] + $neto;
  1959.             $product['sumSubT'] = $product['sumSubT'] + $subtotal;
  1960.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1961.             $product['neto'] = round($product['neto'],2,PHP_ROUND_HALF_UP);
  1962.             $product['sumSubT'] = round($product['sumSubT'],2,PHP_ROUND_HALF_UP);
  1964.             $data_supplier['product'][$i] = array (
  1965.                 'id' => $item->getId(),
  1966.                 'productName' => $item->getProductName(),
  1967.                 'description' => $item->getDescription(),
  1968.                 'productId' => $item->getProductId(),
  1969.                 'dateStart' => $item->getDateStart(),
  1970.                 'dateEnd' => $item->getDateEnd(),
  1971.                 'servicePrice' => $item->getServicePrice(),
  1972.                 'subtotalProduct' => $subtotalProduct,
  1973.                 'iva' => $iva,
  1974.                 'pax' => $pax,
  1975.                 'qty' => $qty,
  1976.                 'type' => $item->getType(),
  1977.                 'subtotal' => $subtotal,
  1978.             );
  1979.             $i++;
  1980.         }
  1982.         $data_supplier['productSubTotal'] = array(
  1983.             'neto' => $product['neto'],
  1984.             'sumSubT' => $product['sumSubT'],
  1985.         );
  1987.         $payment = array(
  1988.             'sumSubT' => 0,
  1989.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1991.         $i = 0;
  1992.         foreach ($payments as $item){
  1994.             $payment['sumSubT'] = $payment['sumSubT'] + $item->getAmountTotal();
  1995.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1996.             $payment['sumSubT'] = round($payment['sumSubT'],2,PHP_ROUND_HALF_UP);
  1998.             $data_supplier['payment'][$i] = array (
  1999.                 'id' => $item->getId(),
  2000.                 'amount' => $item->getAmount(),
  2001.                 'amountTotal' => $item->getAmountTotal(),
  2002.                 'vat' => $item->getVat(),
  2003.                 'datePayAt' => $item->getDatePayAt(),
  2004.                 'wayToPay' => $item->getWayToPay(),
  2005.             );
  2007.             $arrayItems[] = array(
  2008.                 'type' => 'Payment',
  2009.                 'name' => $item->getWayToPay(),
  2010.                 'amount' => $item->getAmount(),
  2011.                 'total' => $item->getAmountTotal(),
  2012.                 'iva' => $item->getVat(),
  2013.             );
  2015.             $i++;
  2016.         }
  2018.         if (!empty($payments)) {
  2019.             $data_supplier['paymentSubTotal'] = array(
  2020.                 'sumSubT' => $payment['sumSubT'],
  2021.             );
  2022.         }
  2024.         foreach ($services as $item){
  2025.             if (is_null($item->getPrice()) or empty($item->getPrice())){
  2026.                 $subtotal = 0;
  2027.                 $neto = 0;
  2028.                 $subtotalService = 0;
  2030.             } else {
  2031.                 $subtotalService = $item->getPrice();
  2032.                 $subneto = $item->getPrice();
  2034.                 // Commission
  2035.                 if ($item->getOpCommission()=='1'){
  2036.                     $subtotalService = $subtotalService * (1 + ($item->getCommission()/100));
  2037.                     $subneto = $subneto  * (1 + ($item->getCommission()/100));
  2038.                 } else {
  2039.                     $subtotalService = $subtotalService * (1 - ($item->getCommission()/100));
  2040.                     $subneto = $subneto * (1 - ($item->getCommission()/100));
  2041.                 }
  2043.                 // Over
  2044.                 if ($item->getOpOver()=='1'){
  2045.                     $subtotalService = $subtotalService + $item->getOver();
  2046.                     $subneto = $subneto + $item->getOver();
  2047.                 } else {
  2048.                     $subtotalService = $subtotalService - $item->getOver();
  2049.                     $subneto = $subneto - $item->getOver();
  2050.                 }
  2052.                 // IVA
  2053.                 if ($item->getOpIva()=='1'){
  2054.                     $subtotalService = $subtotalService * (1 + ($item->getIva()/100));
  2055.                 } else {
  2056.                     $subtotalService = $item->getPrice();
  2057.                     $subneto = ($subneto * 100) / (100 + $item->getIva());
  2058.                 }
  2060.                 switch ($item->getServiceCatId()){
  2061.                     case 1: // Alojamiento
  2062.                         // el numero de noches $numNoches; precio unitario $subneto
  2063.                         $numNoches = (($item->getDateOutAt())->diff($item->getDateInAt()))->days;
  2064.                         // La personas no afectan este calculo
  2065.                         $subtotal = $subtotalService * $numNoches * $item->getUnits();
  2066.                         $subnetoUnit = $subneto;
  2068.                         $subneto = $subneto * $numNoches * $item->getUnits();
  2070.                         $data_supplier['service'][$i] = array (
  2071.                             'id' => $item->getId(),
  2072.                             'serviceCatId' => $item->getServiceCatId(),
  2073.                             'serviceName' => $item->getName(),
  2074.                             'serviceType' => 'Hotel',
  2075.                             'date' => ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y'),
  2076.                             'qty' => $item->getUnits(),
  2077.                             'iva' => $item->getIva(),
  2078.                             'pax' => '-',
  2079.                             'precioUnit' => $subnetoUnit,
  2080.                             'subneto' => $subneto,
  2081.                             'subtotal' => $subtotal,
  2082.                         );
  2083.                         break;
  2085.                     case 2: //Actividades
  2086.                         // El número de personas es considerado en el calculo
  2087.                         $pax = $item->getPax();
  2088.                         if (empty($pax) or $pax == "0") {
  2089.                             $pax = 1;
  2090.                         }
  2091.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2093.                         if ($days > 1){
  2094.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2095.                         } else {
  2096.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2097.                         }
  2099.                         $subtotal = $subtotalService * $days * $item->getUnits();
  2100.                         $subnetoUnit = $subneto;
  2101.                         $subneto = $subneto * $days * $item->getUnits();
  2103.                         $data_supplier['service'][$i] = array (
  2104.                             'id' => $item->getId(),
  2105.                             'serviceCatId' => $item->getServiceCatId(),
  2106.                             'serviceName' => $item->getName(),
  2107.                             'serviceType' => 'Actividad',
  2108.                             'date' => $dateServ,
  2109.                             'qty' => $item->getUnits(),
  2110.                             'iva' => $item->getIva(),
  2111.                             'pax' => $item->getPax(),
  2112.                             'precioUnit' => $subnetoUnit,
  2113.                             'subneto' => $subneto,
  2114.                             'subtotal' => $subtotal,
  2115.                         );
  2116.                         break;
  2118.                     case 3: // AV
  2119.                         $pax = $item->getPax();
  2120.                         if (empty($pax) or $pax == "0") {
  2121.                             $pax = 1;
  2122.                         }
  2124.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2125.                         if ($days > 1){
  2126.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2127.                         } else {
  2128.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2129.                         }
  2131.                         $unitsServ = $item->getUnits();
  2132.                         if (empty($unitsServ) or $unitsServ == "0") {
  2133.                             $unitsServ = 1;
  2134.                         }
  2136.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2137.                         $subnetoUnit = $subneto;
  2138.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2140.                         $data_supplier['service'][$i] = array (
  2141.                             'id' => $item->getId(),
  2142.                             'serviceCatId' => $item->getServiceCatId(),
  2143.                             'serviceName' => $item->getName(),
  2144.                             'serviceType' => 'AV',
  2145.                             'date' => $dateServ,
  2146.                             'qty' => $unitsServ,
  2147.                             'iva' => $item->getIva(),
  2148.                             'pax' => $item->getPax(),
  2149.                             'precioUnit' => $subnetoUnit,
  2150.                             'subneto' => $subneto,
  2151.                             'subtotal' => $subtotal,
  2152.                         );
  2153.                         break;
  2155.                     case 4: //Creative
  2156.                         $pax = $item->getPax();
  2157.                         if (empty($pax) or $pax == "0") {
  2158.                             $pax = 1;
  2159.                         }
  2161.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2162.                         if ($days > 1){
  2163.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2164.                         } else {
  2165.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2166.                         }
  2168.                         $unitsServ = $item->getUnits();
  2169.                         if (empty($unitsServ) or $unitsServ == "0") {
  2170.                             $unitsServ = 1;
  2171.                         }
  2173.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2174.                         $subnetoUnit = $subneto;
  2175.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2177.                         $data_supplier['service'][$i] = array (
  2178.                             'id' => $item->getId(),
  2179.                             'serviceCatId' => $item->getServiceCatId(),
  2180.                             'serviceName' => $item->getName(),
  2181.                             'serviceType' => 'Creativo',
  2182.                             'date' => $dateServ,
  2183.                             'qty' => $unitsServ,
  2184.                             'iva' => $item->getIva(),
  2185.                             'pax' => $item->getPax(),
  2186.                             'precioUnit' => $subnetoUnit,
  2187.                             'subneto' => $subneto,
  2188.                             'subtotal' => $subtotal,
  2189.                         );
  2190.                         break;
  2192.                     case 5: //Cruise
  2193.                         $pax = $item->getPax();
  2194.                         if (empty($pax) or $pax == "0") {
  2195.                             $pax = 1;
  2196.                         }
  2198.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days);
  2199.                         if ($days > 1){
  2200.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2201.                         } else {
  2202.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2203.                         }
  2205.                         $unitsServ = $item->getUnits();
  2206.                         if (empty($unitsServ) or $unitsServ == "0") {
  2207.                             $unitsServ = 1;
  2208.                         }
  2210.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2211.                         $subnetoUnit = $subneto;
  2212.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2214.                         $data_supplier['service'][$i] = array (
  2215.                             'id' => $item->getId(),
  2216.                             'serviceCatId' => $item->getServiceCatId(),
  2217.                             'serviceName' => $item->getName(),
  2218.                             'serviceType' => 'Crucero',
  2219.                             'date' => $dateServ,
  2220.                             'qty' => $unitsServ,
  2221.                             'iva' => $item->getIva(),
  2222.                             'pax' => $item->getPax(),
  2223.                             'precioUnit' => $subnetoUnit,
  2224.                             'subneto' => $subneto,
  2225.                             'subtotal' => $subtotal,
  2226.                         );
  2227.                         break;
  2229.                     case 6: //Entertaiment
  2230.                         $pax = $item->getPax();
  2231.                         if (empty($pax) or $pax == "0") {
  2232.                             $pax = 1;
  2233.                         }
  2235.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2236.                         if ($days > 1){
  2237.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2238.                         } else {
  2239.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2240.                         }
  2242.                         $unitsServ = $item->getUnits();
  2243.                         if (empty($unitsServ) or $unitsServ == "0") {
  2244.                             $unitsServ = 1;
  2245.                         }
  2247.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2248.                         $subnetoUnit = $subneto;
  2249.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2251.                         $data_supplier['service'][$i] = array (
  2252.                             'id' => $item->getId(),
  2253.                             'serviceCatId' => $item->getServiceCatId(),
  2254.                             'serviceName' => $item->getName(),
  2255.                             'serviceType' => 'Entretenimiento',
  2256.                             'date' => $dateServ,
  2257.                             'qty' => $unitsServ,
  2258.                             'iva' => $item->getIva(),
  2259.                             'pax' => $item->getPax(),
  2260.                             'precioUnit' => $subnetoUnit,
  2261.                             'subneto' => $subneto,
  2262.                             'subtotal' => $subtotal,
  2263.                         );
  2264.                         break;
  2266.                     case 7: // Gifts
  2267.                         $pax = $item->getPax();
  2268.                         if (empty($pax) or $pax == "0") {
  2269.                             $pax = 1;
  2270.                         }
  2272. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2273.                         $days = 1;
  2274.                         if ($days > 1){
  2275.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2276.                         } else {
  2277.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2278.                         }
  2280.                         $unitsServ = $item->getUnits();
  2281.                         if (empty($unitsServ) or $unitsServ == "0") {
  2282.                             $unitsServ = 1;
  2283.                         }
  2285.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2286.                         $subnetoUnit = $subneto;
  2287.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2289.                         $data_supplier['service'][$i] = array (
  2290.                             'id' => $item->getId(),
  2291.                             'serviceCatId' => $item->getServiceCatId(),
  2292.                             'serviceName' => $item->getName(),
  2293.                             'serviceType' => 'Regalos',
  2294.                             'date' => $dateServ,
  2295.                             'qty' => $unitsServ,
  2296.                             'iva' => $item->getIva(),
  2297.                             'pax' => $item->getPax(),
  2298.                             'precioUnit' => $subnetoUnit,
  2299.                             'subneto' => $subneto,
  2300.                             'subtotal' => $subtotal,
  2301.                         );
  2302.                         break;
  2304.                     case 8: //Guide
  2305.                         $pax = $item->getPax();
  2306.                         if (empty($pax) or $pax == "0") {
  2307.                             $pax = 1;
  2308.                         }
  2310.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2311.                         if ($days > 1){
  2312.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2313.                         } else {
  2314.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2315.                         }
  2317.                         $unitsServ = $item->getUnits();
  2318.                         if (empty($unitsServ) or $unitsServ == "0") {
  2319.                             $unitsServ = 1;
  2320.                         }
  2322.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2323.                         $subnetoUnit = $subneto;
  2324.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2326.                         $data_supplier['service'][$i] = array (
  2327.                             'id' => $item->getId(),
  2328.                             'serviceCatId' => $item->getServiceCatId(),
  2329.                             'serviceName' => $item->getName(),
  2330.                             'serviceType' => 'Regalos',
  2331.                             'date' => $dateServ,
  2332.                             'qty' => $unitsServ,
  2333.                             'iva' => $item->getIva(),
  2334.                             'pax' => $item->getPax(),
  2335.                             'precioUnit' => $subnetoUnit,
  2336.                             'subneto' => $subneto,
  2337.                             'subtotal' => $subtotal,
  2338.                         );
  2339.                         break;
  2341.                     case 9: //Itineraries
  2342.                         $pax = $item->getPax();
  2343.                         if (empty($pax) or $pax == "0") {
  2344.                             $pax = 1;
  2345.                         }
  2347.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2348.                         if ($days > 1){
  2349.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2350.                         } else {
  2351.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2352.                         }
  2354.                         $unitsServ = $item->getUnits();
  2355.                         if (empty($unitsServ) or $unitsServ == "0") {
  2356.                             $unitsServ = 1;
  2357.                         }
  2359.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2360.                         $subnetoUnit = $subneto;
  2361.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2363.                         $data_supplier['service'][$i] = array (
  2364.                             'id' => $item->getId(),
  2365.                             'serviceCatId' => $item->getServiceCatId(),
  2366.                             'serviceName' => $item->getName(),
  2367.                             'serviceType' => 'Itinerarios',
  2368.                             'date' => $dateServ,
  2369.                             'qty' => $unitsServ,
  2370.                             'iva' => $item->getIva(),
  2371.                             'pax' => $item->getPax(),
  2372.                             'precioUnit' => $subnetoUnit,
  2373.                             'subneto' => $subneto,
  2374.                             'subtotal' => $subtotal,
  2375.                         );
  2376.                         break;
  2378.                     case 10: //Lounge  -- No Aplica
  2379. //                        $pax = $item->getPax();
  2380. //                        if (empty($pax) or $pax == "0") {
  2381. //                            $pax = 1;
  2382. //                        }
  2383. //
  2384. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2385. //                        if ($days > 1){
  2386. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2387. //                        } else {
  2388. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2389. //                        }
  2390. //
  2391. //                        $unitsServ = $item->getUnits();
  2392. //                        if (empty($unitsServ) or $unitsServ == "0") {
  2393. //                            $unitsServ = 1;
  2394. //                        }
  2395. //
  2396. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2397. //                        $subnetoUnit = $subneto;
  2398. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  2399. //
  2400. //                        $data_supplier['service'][$i] = array (
  2401. //                            'id' => $item->getId(),
  2402. //                            'serviceCatId' => $item->getServiceCatId(),
  2403. //                            'serviceName' => $item->getName(),
  2404. //                            'serviceType' => 'Itinerarios',
  2405. //                            'date' => $dateServ,
  2406. //                            'qty' => $unitsServ,
  2407. //                            'iva' => $item->getIva(),
  2408. //                            'pax' => $item->getPax(),
  2409. //                            'precioUnit' => $subnetoUnit,
  2410. //                            'subneto' => $subneto,
  2411. //                            'subtotal' => $subtotal,
  2412. //                        );
  2413.                         break;
  2415.                     case 11: //Menu
  2416.                         $pax = $item->getPax();
  2417.                         if (empty($pax) or $pax == "0") {
  2418.                             $pax = 1;
  2419.                         }
  2421.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2422.                         if ($days > 1){
  2423.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2424.                         } else {
  2425.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2426.                         }
  2428.                         $unitsServ = $item->getUnits();
  2429.                         if (empty($unitsServ) or $unitsServ == "0") {
  2430.                             $unitsServ = 1;
  2431.                         }
  2433.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2434.                         $subnetoUnit = $subneto;
  2435.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2437.                         $data_supplier['service'][$i] = array (
  2438.                             'id' => $item->getId(),
  2439.                             'serviceCatId' => $item->getServiceCatId(),
  2440.                             'serviceName' => $item->getName(),
  2441.                             'serviceType' => 'Menú',
  2442.                             'date' => $dateServ,
  2443.                             'qty' => $unitsServ,
  2444.                             'iva' => $item->getIva(),
  2445.                             'pax' => $item->getPax(),
  2446.                             'precioUnit' => $subnetoUnit,
  2447.                             'subneto' => $subneto,
  2448.                             'subtotal' => $subtotal,
  2449.                         );
  2450.                         break;
  2452.                     case 12: //Others
  2453.                         $pax = $item->getPax();
  2454.                         if (empty($pax) or $pax == "0") {
  2455.                             $pax = 1;
  2456.                         }
  2458.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2459.                         if ($days > 1){
  2460.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2461.                         } else {
  2462.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2463.                         }
  2465.                         $unitsServ = $item->getUnits();
  2466.                         if (empty($unitsServ) or $unitsServ == "0") {
  2467.                             $unitsServ = 1;
  2468.                         }
  2470.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2471.                         $subnetoUnit = $subneto;
  2472.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2474.                         $data_supplier['service'][$i] = array (
  2475.                             'id' => $item->getId(),
  2476.                             'serviceCatId' => $item->getServiceCatId(),
  2477.                             'serviceName' => $item->getName(),
  2478.                             'serviceType' => 'Otros',
  2479.                             'date' => $dateServ,
  2480.                             'qty' => $unitsServ,
  2481.                             'iva' => $item->getIva(),
  2482.                             'pax' => $item->getPax(),
  2483.                             'precioUnit' => $subnetoUnit,
  2484.                             'subneto' => $subneto,
  2485.                             'subtotal' => $subtotal,
  2486.                         );
  2487.                         break;
  2489.                     case 13: //Transport
  2490.                         $pax = $item->getPax();
  2491.                         if (empty($pax) or $pax == "0") {
  2492.                             $pax = 1;
  2493.                         }
  2495.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2496.                         if ($days > 1){
  2497.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2498.                         } else {
  2499.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2500.                         }
  2502.                         $unitsServ = $item->getUnits();
  2503.                         if (empty($unitsServ) or $unitsServ == "0") {
  2504.                             $unitsServ = 1;
  2505.                         }
  2507.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2508.                         $subnetoUnit = $subneto;
  2509.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2511.                         $data_supplier['service'][$i] = array (
  2512.                             'id' => $item->getId(),
  2513.                             'serviceCatId' => $item->getServiceCatId(),
  2514.                             'serviceName' => $item->getName(),
  2515.                             'serviceType' => 'Transporte',
  2516.                             'date' => $dateServ,
  2517.                             'qty' => $unitsServ,
  2518.                             'iva' => $item->getIva(),
  2519.                             'pax' => $item->getPax(),
  2520.                             'precioUnit' => $subnetoUnit,
  2521.                             'subneto' => $subneto,
  2522.                             'subtotal' => $subtotal,
  2523.                         );
  2524.                         break;
  2526.                     case 14: //Technology
  2527.                         $pax = $item->getPax();
  2528.                         if (empty($pax) or $pax == "0") {
  2529.                             $pax = 1;
  2530.                         }
  2532. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2533.                         $days = 1;
  2534. //                        if ($days > 1){
  2535. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2536. //                        } else {
  2537. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2538. //                        }
  2539.                         $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2541.                         $unitsServ = $item->getUnits();
  2542.                         if (empty($unitsServ) or $unitsServ == "0") {
  2543.                             $unitsServ = 1;
  2544.                         }
  2546.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2547.                         $subnetoUnit = $subneto;
  2548.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2550.                         $data_supplier['service'][$i] = array (
  2551.                             'id' => $item->getId(),
  2552.                             'serviceCatId' => $item->getServiceCatId(),
  2553.                             'serviceName' => $item->getName(),
  2554.                             'serviceType' => 'Tecnología',
  2555.                             'date' => $dateServ,
  2556.                             'qty' => $unitsServ,
  2557.                             'iva' => $item->getIva(),
  2558.                             'pax' => $item->getPax(),
  2559.                             'precioUnit' => $subnetoUnit,
  2560.                             'subneto' => $subneto,
  2561.                             'subtotal' => $subtotal,
  2562.                         );
  2563.                         break;
  2565.                     case 15: //Assisstant
  2566.                         $pax = $item->getPax();
  2567.                         if (empty($pax) or $pax == "0") {
  2568.                             $pax = 1;
  2569.                         }
  2571.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2572.                         if ($days > 1){
  2573.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2574.                         } else {
  2575.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2576.                         }
  2578.                         $unitsServ = $item->getUnits();
  2579.                         if (empty($unitsServ) or $unitsServ == "0") {
  2580.                             $unitsServ = 1;
  2581.                         }
  2583.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2584.                         $subnetoUnit = $subneto;
  2585.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2587.                         $data_supplier['service'][$i] = array (
  2588.                             'id' => $item->getId(),
  2589.                             'serviceCatId' => $item->getServiceCatId(),
  2590.                             'serviceName' => $item->getName(),
  2591.                             'serviceType' => 'Asistente',
  2592.                             'date' => $dateServ,
  2593.                             'qty' => $unitsServ,
  2594.                             'iva' => $item->getIva(),
  2595.                             'pax' => $item->getPax(),
  2596.                             'precioUnit' => $subnetoUnit,
  2597.                             'subneto' => $subneto,
  2598.                             'subtotal' => $subtotal,
  2599.                         );
  2600.                         break;
  2602.                     case 16: //DDR
  2603.                         $pax = $item->getPax();
  2604.                         if (empty($pax) or $pax == "0") {
  2605.                             $pax = 1;
  2606.                         }
  2608.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2609.                         if ($days > 1){
  2610.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2611.                         } else {
  2612.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2613.                         }
  2615.                         $unitsServ = $item->getUnits();
  2616.                         if (empty($unitsServ) or $unitsServ == "0") {
  2617.                             $unitsServ = 1;
  2618.                         }
  2620.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2621.                         $subnetoUnit = $subneto;
  2622.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2624.                         $data_supplier['service'][$i] = array (
  2625.                             'id' => $item->getId(),
  2626.                             'serviceCatId' => $item->getServiceCatId(),
  2627.                             'serviceName' => $item->getName(),
  2628.                             'serviceType' => 'DDR',
  2629.                             'date' => $dateServ,
  2630.                             'qty' => $unitsServ,
  2631.                             'iva' => $item->getIva(),
  2632.                             'pax' => $item->getPax(),
  2633.                             'precioUnit' => $subnetoUnit,
  2634.                             'subneto' => $subneto,
  2635.                             'subtotal' => $subtotal,
  2636.                         );
  2637.                         break;
  2639.                     default:
  2640.                         break;
  2641.                 }
  2643.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  2644.                 $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  2645.                 $neto = round($subneto,2,PHP_ROUND_HALF_UP);
  2647.                 $arrayItems[] = array(
  2648.                     'type' => 'Service',
  2649.                     'name' => $item->getName(),
  2650.                     'amount' => $neto,
  2651.                     'iva' => $item->getIva(),
  2652.                     'total' => $subtotal,
  2653.                 );
  2655.             }
  2657.             switch ($item->getIva()){
  2658.                 // Acumula IVA
  2659.                 case 21:
  2660.                     $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getIva()/100));
  2661.                     break;
  2663.                 case 10:
  2664.                     $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getIva()/100));
  2665.                     break;
  2667.                 case 0:
  2668.                     break;
  2670.                 default:
  2671.                     break;
  2673.             }
  2675.             $totales_neto_all = $totales_neto_all + $neto;
  2677.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2678.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  2679.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  2680.             $data_iva['ivaMontoDiez'] = round($data_iva['ivaMontoDiez'],2,PHP_ROUND_HALF_UP);
  2681.             // Acumula netos totales e IVA
  2683.             $service['neto'] = $service['neto'] + $neto;
  2684.             $service['sumSubT'] = $service['sumSubT'] + $subtotal;
  2685.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2686.             $service['neto'] = round($service['neto'],2,PHP_ROUND_HALF_UP);
  2687.             $service['sumSubT'] = round($service['sumSubT'],2,PHP_ROUND_HALF_UP);
  2689.             $i++;
  2690.         }
  2692.         $data_supplier['serviceSubTotal'] = array(
  2693.             'neto' => $service['neto'],
  2694.             'sumSubT' => $service['sumSubT'],
  2695.         );
  2696.         $currency = '€';
  2697.         $totales_total = $totales_neto_all + $data_iva['ivaMontoVeintiUno'] + $data_iva['ivaMontoDiez'];
  2698.         if (!empty($payments)) {
  2699.             $amount_pay = $data_supplier['paymentSubTotal']['sumSubT'];
  2700.         } else {
  2701.             $amount_pay = 0;
  2702.         }
  2703.         $totales_all = $totales_total - $amount_pay;
  2705.         if ($type == 'Invoice'){
  2706.             $em->clear();   // sin este clear se producia error al guardar
  2707.             $newInvoice = $em->getRepository(ReservationInvoice::class)->findOneById($numberInvoiceOrProforma);
  2708.             $newInvoice->setBalance($totales_all);
  2709.             $em->persist($newInvoice);
  2710.             $em->flush();
  2711.         }
  2713.         $data = array(
  2714.             'id' => $id,
  2715.             'type' => $type,
  2716.             'number' => $number,
  2717.             'prefix' => 'GPF-'.(new DateTime('now'))->format('dmy').'-',
  2718.             'date' => new DateTime('now'),
  2719.             'file' => $file,
  2720. //            'token' => $reservation->getAccessKey(),
  2721.             'company' => $company,
  2722.             'clients' => $client,
  2723.             'arrayItems' => $arrayItems,
  2724.             'datasupplier' => $data_supplier,
  2725.             'currency' => $currency,
  2726.             'totales_neto' => $totales_neto_all,
  2727.             'bases_imponibles' => $data_iva,
  2728.             'totales' => $totales_total,
  2729.             'balance' => $totales_all,
  2730.             'paymentInvoice' => $amount_pay,
  2731.         );
  2733.         return $data;
  2734.     }
  2736.     private function obtenerRankAv($id)
  2737.     {
  2738.         // $id Id del Expediente (File)
  2739.         $em = $this->getDoctrine()->getManager();
  2740.         $items = $em->getRepository(AveProductFile::class)->findByFileId($id);
  2742.         if (empty($items)){ $num = 1; } else { $num = sizeof($items) + 1; }
  2743.         $data = $num;
  2745.         return $data;
  2746.     }
  2748.     private function obtenerFechas($id, $dateStart, $dateEnd)
  2749.     {
  2750.         // $id Id del Expediente (File)
  2751.         // $dateStart Fecha de inicio (Producto)
  2752.         // $dateEnd Fecha de fin (Producto)
  2754.         $em = $this->getDoctrine()->getManager();
  2755.         $file = $em->getRepository(AveFiles::class)->findOneById($id);
  2757.         if (empty($dateStart)){ $newDateStart = $file->getDateStart(); } else { $newDateStart = $dateStart; }
  2758.         if (empty($dateEnd)){ $newDateEnd = $file->getDateEnd(); } else { $newDateEnd = $dateEnd; }
  2760.         $data = array(
  2761.             'dateStart' => $newDateStart,
  2762.             'dateEnd' => $newDateEnd,
  2763.         );
  2765.         return $data;
  2766.     }
  2768.     private function sendTelegram( $id, $text )
  2769.     {
  2770.         $em = $this->getDoctrine()->getManager();
  2771.         $telegUser = $em->getRepository(MdvTelegramUser::class)->findOneByUserId($id);
  2773.         if (empty($telegUser)){return true;}
  2775.         $parameters = array(
  2776.             'chat_id' => $telegUser->getChatId(),
  2777.             'text' => $text,
  2778.         );
  2780.         $bot_token = $telegUser->getBotToken();
  2781.         $url = "https://api.telegram.org/bot$bot_token/sendMessage";
  2783.         if (!$curl = curl_init()){
  2784.             exit();
  2785.         }
  2787.         curl_setopt($curl,CURLOPT_POST,true);
  2788.         curl_setopt($curl,CURLOPT_POSTFIELDS,$parameters);
  2789.         curl_setopt($curl,CURLOPT_URL,$url);
  2790.         curl_setopt($curl,CURLOPT_RETURNTRANSFER,true);
  2791.         $output = curl_exec($curl);
  2792.         curl_close($curl);
  2794.         return true;
  2795.     }
  2797.     private function addProductFileToProforma( $fileId, $newProductId, $proformaId )
  2798.     {
  2799.         $em = $this->getDoctrine()->getManager();
  2800.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  2801.         $productFile = $em->getRepository(AveProductFile::class)->findOneById($newProductId);
  2802.         $proforma = $em->getRepository(AveDocProforma::class)->findOneById($proformaId);
  2804.         if (!empty($file) and !empty($productFile) and !empty($proforma) ){
  2805.             $newProformaItem = new AveDocProformaItems();
  2806.             $newProformaItem->setControlId($newProductId);
  2807.             $newProformaItem->setType('PRODUCT');
  2808.             $newProformaItem->setFileId($fileId);
  2809.             $newProformaItem->setProformaId($proformaId);
  2811.             $em->persist($newProformaItem);
  2812.             $em->flush();
  2814.             return true;
  2815.         } else {
  2816.             return false;
  2817.         }
  2818.     }
  2820.     private function precioPorVariacionDeDias ($supplierService, $productFile){
  2821.         $em = $this->getDoctrine()->getManager();
  2823.         // El precio unitario debe ser dividido en funcion de los dias que tiene InOut y no en funcion de los dias de Av Express
  2824.         $days = ($supplierService->getDateOutAt()->diff($supplierService->getDateInAt())->days)===0 ? 1 : $supplierService->getDateOutAt()->diff($supplierService->getDateInAt())->days +1;
  2825.         if (array_key_exists('productFileId',$productFile)){
  2826.             // En el GridTwo viene es un arreglo no la entidad
  2827.             $productInFile = $em->getRepository(AveProductFile::class)->findOneById($productFile['productFileId']);
  2828.             $newPrice = $productInFile->getSubTotalPrice() / ( $days );
  2829.         } else {
  2830.             $newPrice = $productFile->getSubTotalPrice() / ( $days );
  2831.         }
  2833.         $newPrice = $newPrice / $supplierService->getUnits();
  2834.         $newPrice = round($newPrice,2,PHP_ROUND_HALF_UP);
  2836.         return $newPrice;
  2837.     }
  2839.     private function messageOfChangesToAgent($message, $proposalId){
  2840.         // $message mensaje a enviar a los agentes del proposal
  2841.         if ($proposalId  == 0){ return true; }
  2842.         $em = $this->getDoctrine()->getManager();
  2843.         $proposal = $em->getRepository(Proposal::class)->findOneById($proposalId);
  2845.         /* Obtengo usuario logueado */
  2846.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  2847.         $user_id = $user_logueado->getId();
  2848.         $agent = $em->getRepository(User::class)->findOneById($user_id);
  2850.         $message = 'El proposal <strong>#'.$proposalId.' '.$proposal->getName().'</strong>'.' ha sido modificacdo por el agente: '.$agent->getName().' '.$agent->getLastName().'<br><br><br>'.$message;
  2851.         $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposalId);
  2852.         $mailArrayTo = array();
  2853.         if (!empty($agent)){ $mailArrayTo[$agent->getEmail()] = $agent->getEmail(); }
  2854.         if (!empty($proposalAgents)){
  2855.             if (!empty($proposalAgents->getAgOne())){
  2856.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgOne());
  2857.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2858.             }
  2860.             if (!empty($proposalAgents->getAgTwo())){
  2861.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgTwo());
  2862.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2863.             }
  2865.             if (!empty($proposalAgents->getAgThree())){
  2866.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgThree());
  2867.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2868.             }
  2870.             if (!empty($proposalAgents->getAgFour())){
  2871.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgFour());
  2872.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2873.             }
  2874.         }
  2876.         if (!empty($mailArrayTo)){
  2877.             $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2878.             $replyTo = array();
  2879.             foreach ($mailArrayTo as $item){ $replyTo[$item] = $item; }
  2881.             $agentMail = $agent->getEmail();
  2883.             //Se prepara el correo con los agentes a notificar
  2884.             $firmGmail = $agent->getFirmGmail();
  2885.             $data = array(
  2886.                 'body' => $message,
  2887.                 'firm' => $firmGmail,
  2888.             );
  2890.             // EJECUTAR ENVIO DE ALERTA PARA EL AGENTE
  2891.             $transporter = new Swift_SmtpTransport();
  2892.             $transporter->setHost('smtp.gmail.com')
  2893.                 ->setEncryption('ssl')//ssl / tls
  2894.                 ->setPort(465)// 465 / 587
  2895.                 ->setUsername('desarrollo@develup.solutions')
  2896.                 ->setPassword('MeDITeRRANeAN_Develup30102023#');
  2897.             $mailer = new Swift_Mailer($transporter);
  2899.             $message = new Swift_Message();
  2900.             $message->setSubject('Actualización de servicios AvExpress del proposal: '. $proposalId)
  2901.                 ->setSender($agentMail)
  2902.                 ->setFrom(array("desarrollo@develup.solutions" => "System Mante 3.0"))
  2903.                 ->setReplyTo($agentMail)
  2904.                 ->setTo($replyTo)
  2905.                 ->setBody(
  2906.                     $this->renderView(
  2907.                         'mail/structure-mail.html.twig',
  2908.                         array('data' => $data)
  2909.                     ),
  2910.                     'text/html'
  2911.                 );
  2912.             $mailer->send($message);
  2913.         }
  2915.         return true;
  2916.     }
  2918. };