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

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\AvePackageTemplate;
  19. use App\MDS\AvexpressBundle\Entity\AvePackageTemplateItems;
  20. use App\MDS\AvexpressBundle\Entity\AveProduct;
  21. use App\MDS\AvexpressBundle\Entity\AveProductFileLocationNames;
  22. use App\Service\AvePackageDeployService;
  23. use Doctrine\ORM\EntityManagerInterface;
  24. use Symfony\Component\Routing\Annotation\Route;
  25. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  26. use Symfony\Component\HttpFoundation\Request;
  27. use App\MDS\AvexpressBundle\Entity\AveProductFile;
  28. use App\MDS\AvexpressBundle\Entity\AveTemplate;
  29. use App\MDS\AvexpressBundle\Entity\AveTemplateItems;
  30. use App\MDS\DevelupBundle\Entity\MdvTelegramUser;
  31. use App\MDS\EventsBundle\Entity\Proposal;
  32. use App\MDS\EventsBundle\Entity\ProposalAgents;
  33. use App\MDS\EventsBundle\Entity\ProposalInvoice;
  34. use App\MDS\EventsBundle\Entity\ProposalSupplierControl;
  35. use App\MDS\EventsBundle\Entity\ProposalSupplierServices;
  36. use App\MDS\GreenPatioBundle\Entity\ReservationInvoice;
  37. use Swift_Mailer;
  38. use Swift_Message;
  39. use Swift_SmtpTransport;
  40. use Symfony\Contracts\Translation\TranslatorInterface;
  42. class ProductsFilesController extends AbstractController
  43. {
  44.     private $translator;
  46.     public function __construct(TranslatorInterface $translator, AvePackageDeployService $avePackageDeployService)
  47.     {
  48.         $this->translator = $translator;
  49.         $this->avePackageDeployService = $avePackageDeployService;
  50.     }
  52.     private $avePackageDeployService;
  53.     
  54.     /**
  55.      * @Route("/productfileadd/",  name="ave_add_productfile")
  56.      * Agregar un producto a un expediente
  57.      */
  58.     public function addProductFileAction( Request $request)
  59.     {
  60.         $em = $this->getDoctrine()->getManager();
  61.         $clients = $em->getRepository(Client::class)->findAll();
  62.         $newRequest = $request->request->get('productfile');
  63.         $editFile = $em->getRepository(AveFiles::class)->findOneById($newRequest['fileId']);
  64.         $mdvProductSelected = $em->getRepository(AveProduct::class)->findOneById($newRequest['productId']);
  65.         $logTelegram = false;
  67.         /* Obtengo usuario logueado */
  68.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  69.         $user_id = $user_logueado->getId();
  71.         $newProductFile = new AveProductFile();
  72.         $newProductFile->setProductName($mdvProductSelected->getName());
  73.         $newProductFile->setProductId($mdvProductSelected->getId());
  74.         $newProductFile->setType($mdvProductSelected->getType());
  76.         if (!empty($newRequest['servicePrice'])){
  77.             $newProductFile->setServicePrice($newRequest['servicePrice']);
  78.         } else {
  79.             // Si el precio viene vacio tomamos el valor por defecto del producto
  80.             $newProductFile->setServicePrice($mdvProductSelected->getPrice());
  81.         }
  82.         $newProductFile->setDescription($mdvProductSelected->getDescription());
  83.         $newProductFile->setFileId($newRequest['fileId']);
  85.         if (!empty($newRequest['dateStart'])) { $newProductFile->setDateStart(new \DateTime($newRequest['dateStart'].' '.$newRequest['hourStart'])); }
  86.         if (!empty($newRequest['dateEnd'])) { $newProductFile->setDateEnd(new \DateTime($newRequest['dateStart'].' '.$newRequest['hourEnd'])); }
  87.         $dataDates = $this->obtenerFechas($newRequest['fileId'], $newProductFile->getDateStart(), $newProductFile->getDateEnd());
  88.         $newProductFile->setDateStart($dataDates['dateStart']);
  89.         $newProductFile->setDateEnd($dataDates['dateEnd']);
  90.         $newProductFile->setDateInAt($dataDates['dateStart']);
  91.         $newProductFile->setDateOutAt($dataDates['dateEnd']);
  93.         $newProductFile->setCreatedId($user_id);
  94.         $newProductFile->setUpdatedId($user_id);
  95.         $newProductFile->setCreatedAt(new \DateTime("now"));
  96.         $newProductFile->setUpdatedAt(new \DateTime("now"));
  98.         $newProductFile->setOpIva(true);
  99.         $newProductFile->setIva('21');
  101.         if (!empty($newRequest['supplierExt'])){
  102.             $supplier = $em->getRepository(Supplier::class)->findOneById($newRequest['supplierExt']);
  103.             $newProductFile->setSupplierExt($supplier->getName());
  104.             $newProductFile->setSupplierExtId($newRequest['supplierExt']);
  105.         } else {
  106.             $newProductFile->setSupplierExt(null);
  107.             $newProductFile->setSupplierExtId(null);
  108.         }
  110.         if (empty($newProductFile->getType())){ $newProductFile->setType('Otros'); }
  112.         $dataRankAv = $this->obtenerRankAv($newRequest['fileId']);
  113.         $newProductFile->setRankAv($dataRankAv);
  115.         $newProductFile->setDays((($newProductFile->getDateEnd()->diff($newProductFile->getDateStart()))->days + 1));
  117.         $em->persist($newProductFile);
  118.         $em->flush();
  120.         $products = $em->getRepository(AveProduct::class)->findAll();
  122.         $data = $this->calculosFile($newRequest['fileId'], null, 0, 'File');
  124.         $sumatoriaTotalNet = 0;
  125.         $sumatoriaTotalVat = 0;
  126.         $sumatoriaTotal = 0;
  128.         $resultados = array(
  129.             'totalNeto' => $sumatoriaTotalNet,
  130.             'vat' => $sumatoriaTotalVat,
  131.             'total' => $sumatoriaTotal,
  133.         );
  135.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($newRequest['fileId']);
  136.         $numeroItems = sizeof($productInFile);
  138.         $file = $editFile;
  139.         // Si hay proposal se debe actualizar en el expediente de Eventos
  140.         if (!empty($file->getIdProposal()) and is_numeric($file->getIdProposal())){
  142.             // Buscamos el destino donde se encuentre Avexpress y ahi agregamos el servicio, si no se encuentra no se agregara el servicio
  143.             $control = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  144.                 array(
  145.                     'supplierId' => 80,                                          // El supplier 80 es Avexpress
  146.                     'proposalId' => $file->getIdProposal(),
  147.                 )
  148.             );
  150.             if (!empty($control)){
  151.                 // Existe un destino con Avexpress como proveedor, hay se agregara el servicio
  153.                 $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($file->getIdProposal());
  154.                 if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  156.                     $logTelegram = true;
  157.                     $service = new ProposalSupplierServices();
  158.                     $service->setServiceIdFather(0);
  159.                     $service->setControlId($control->getId());
  160.                     $service->setProposalId($file->getIdProposal());
  161.                     $service->setDestinationId($control->getDestinoId());
  162.                     $service->setSupplierId(80);
  163.                     $service->setIdeaId(null);
  164.                     $service->setServiceId($newProductFile->getProductId());
  165.                     $service->setServiceCatName('Av');
  166.                     $service->setServiceCatId(3);
  167.                     $service->setName($newProductFile->getProductName());
  168. //                $service->setPrice($mdvProductSelected->getPrice() * 1.21);
  170.                     $priceInOut = $mdvProductSelected->getSubTotalPrice() / $mdvProductSelected->getPax();      // Se devuelve el calculo dividiendo entre personas
  171.                     $priceInOut = $priceInOut / $mdvProductSelected->getUnits();                                // Se devuelve el calculo dividiendo entre cantidades
  172.                     $priceInOut = $priceInOut / round($mdvProductSelected->getDays());                          // Se devuelve el calculo dividiendo entre dias, se redondea por si es 1.5
  173.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  174.                     $priceInOut = round($priceInOut, 2, PHP_ROUND_HALF_UP);
  176.                     $service->setPrice($priceInOut);
  178. //                $service->setPrice($mdvProductSelected->getPrice());
  179.                     $service->setCurrency(null);
  180.                     $service->setUnits(1);
  181.                     $service->setCommission(0);
  182.                     $service->setOver(0);
  183.                     $service->setIva(21);
  184.                     $service->setPax(0);
  185.                     $service->setHour(null);
  186.                     $service->setDateInAt(new \DateTime("now"));
  187.                     $service->setDateOutAt(new \DateTime("now"));
  188.                     $service->setDirectPayment(0);
  189.                     $service->setStatus('Pending');
  190.                     $service->setStatusinternal('Additional');
  191.                     $service->setPreCommission(null);
  192.                     $service->setPreIva(null);
  193.                     $service->setDateBlockLimit(null);
  194.                     $service->setOpCommission(1);
  195.                     $service->setOpOver(1);
  196.                     $service->setOpIva(1);
  197.                     $service->setBreakdown(0);
  198.                     $service->setIsFather(0);
  199.                     $service->setRank(1);
  200.                     $service->setOriginalopIva(1);
  201.                     $service->setOriginalIva(null);
  202.                     $service->setOriginalPrice(null);
  203.                     $service->setStatusRec('normal');
  204.                     $service->setAssistantId(null);
  205.                     $service->setCreatedId($user_id);
  206.                     $service->setUpdatedId($user_id);
  207.                     $service->setCreatedAt(new \DateTime("now"));
  208.                     $service->setUpdatedAt(new \DateTime("now"));
  210.                     $em->persist($service);
  211.                     $em->flush();
  213.                     // Guardamos el ID del servicio (Eventos) asociado al producto (AvExpress)
  214.                     $newProductFile->setOriginId($service->getId());
  216.                     $em->persist($newProductFile);
  217.                     $em->flush();
  218.                 }
  219.             }
  220.         }
  222.         //INICIO: Notificamos al agente por Telegram
  223.         if ($logTelegram){
  224.             //Buscamos todos los agentes del proposal
  225.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($file->getIdProposal());
  227.             //Buscamos el Destino
  228.             $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  230.             //Buscamos el agente de AvExpress
  231.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  233.             if (!empty($proposalAgents) and !($user_id == 22)){
  234.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  235.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (Nuevo Servicio) __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  236.                 }
  237.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  238.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (Nuevo Servicio) __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  239.                 }
  240.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  241.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (Nuevo Servicio) __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  242.                 }
  243.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  244.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (Nuevo Servicio) __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  245.                 }
  246.             }
  247.         }
  248.         //FIN: Notificamos al agente por Telegram
  251.         return $this->render('MDS/AvexpressBundle/Avexpress/edit-files.html.twig',
  252.             array(
  253.                 'id' => $newRequest['fileId'],
  254.                 'clients' => $clients,
  255.                 'clientId' => $editFile->getClient(),
  256.                 'file' => $editFile,
  257.                 'products' => $products,
  258.                 'numeroItems' => $numeroItems,
  259.                 'arrayProductFile' => $data['datasupplier']['product'],
  260.                 'services' => null,
  261.                 'facturas' => null,
  262.                 'paymentNotIvoiced' => null,
  263.                 'paymentsAll' => null,
  264.                 'resultados' => $resultados,
  265.                 'totales_global_con_iva' => $data['totales'], //$data['totales_global_con_iva'],
  266.                 'totales_global_iva' => $data['bases_imponibles']['ivaMontoVeintiUno'], //$data['totales_global_iva'],
  267.                 'totales_global_neto' => $data['totales_neto'], //$data['totales_global_neto'],
  268.                 'totales_global_servicios_con_iva' => 0, //$data['totales_global_servicios_con_iva'],
  269.                 'totales_global_servicios_neto' => 0, //$data['totales_global_servicios_neto'],
  270.                 'totales_global_servicios_iva' => 0, //$data['totales_global_servicios_iva'],
  271.                 'sumatoria_totales_global_con_iva' => 0, //$data['sumatoria_totales_global_con_iva'],
  272.                 'sumatoria_totales_global_neto' => 0, //$data['sumatoria_totales_global_neto'],
  273.                 'sumatoria_totales_global_iva' => 0, //$data['sumatoria_totales_global_iva'],
  274.             ));
  275.     }
  278.     /**
  279.      * @Route("/productfiledelete/{id}",  name="ave_delete_productfile")
  280.      * Eliminar un producto de un expediente
  281.      */
  282.     public function deleteProductFileAction($id, Request $request)
  283.     {
  284.         $em = $this->getDoctrine()->getManager();
  285.         $mdvProductSelected = $em->getRepository(AveProductFile::class)->findOneById($id);
  286.         $id = $mdvProductSelected->getFileId();
  287.         $logTelegram = false;
  289.         /* Obtengo usuario logueado */
  290.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  291.         $user_id = $user_logueado->getId();
  293.         //INICIO: Si hay un ID origin se debe eliminar en Eventos
  294.         if (!empty($mdvProductSelected->getOriginId())){
  295.             $logTelegram = true;
  296.             $delete = $em->getRepository(ProposalSupplierServices::class)->findOneById($mdvProductSelected->getOriginId());
  297.             if (!empty($delete)) {
  298.                 $destinationId = $delete->getDestinationId();
  299.                 $proposalId = $delete->getProposalId();
  300.                 $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($delete->getProposalId());
  301.                 if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  302.                     if (!empty($delete)) {
  303.                         $delete_sub = $em->getRepository(ProposalSupplierServices::class)->findByServiceIdFather($delete->getId());
  304.                         foreach ($delete_sub as $deletesub) {
  305.                             $em->remove($deletesub);
  306.                         }
  308.                         $em->remove($delete);
  309.                         $em->flush();
  310.                     }
  311.                 }
  312.             } else {
  313.                 // El servicio origen no se encontro
  314.                 $logTelegram = false;
  315.             }
  316.         }
  318.         //INICIO: Notificamos al agente por Telegram
  319.         if ($logTelegram){
  320.             //Buscamos todos los agentes del proposal
  321.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposalId);
  323.             //Buscamos el Destino
  324.             $proposalDestino = $em->getRepository(Destination::class)->findOneById($destinationId);
  326.             //Buscamos el agente de Develup
  327.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  329.             if (!empty($proposalAgents)){
  330.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  331.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  332.                 }
  333.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  334.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  335.                 }
  336.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  337.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  338.                 }
  339.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  340.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  341.                 }
  342.             }
  343.         }
  344.         //FIN: Notificamos al agente por Telegram
  346.         //FIN: Si hay un ID origin se debe eliminar en Eventos
  348.         //INICIO: Si el producto se encuentra dentro de una proforma (Ave_Doc_Proforma_Items) se elimina también
  349.         $productInProforma = $em->getRepository(AveDocProformaItems::class)->findByControlId($mdvProductSelected->getId());
  350.         if (!empty($productInProforma)){
  351.             foreach ($productInProforma as $item){
  352.                 $item->setFileId((-1) * $item->getFileId());      // No lo vamos a eliminar, apuntará al fileId en negativo
  353.                 $em->persist($item);
  354.                 // $em->remove($item);
  355.                 $em->flush();
  356.             }
  357.         }
  358.         //FIN: Si el producto se encuentra dentro de una proforma (Ave_Doc_Proforma_Items) se elimina también
  360.         $mdvProductSelected->setFileId((-1) * $mdvProductSelected->getFileId());      // No lo vamos a eliminar, apuntará al fileId en negativo
  361.         $em->persist($mdvProductSelected);
  362.         // $em->remove($mdvProductSelected);
  363.         $em->flush();
  365.         return $this->redirectToRoute('ave_edit_file', array('id' => $id));
  366.     }
  369.     /**
  370.      * @Route("/productfileproformadelete/{id}",  name="ave_delete_productfileproforma")
  371.      * Eliminar un producto de una proforma
  372.      */
  373.     public function deleteProductFileInProformaAction($id, Request $request)
  374.     {
  375.         $em = $this->getDoctrine()->getManager();
  376.         $mdvProductSelected = $em->getRepository(AveDocProformaItems::class)->findOneByControlId($id);
  377.         $id = $mdvProductSelected->getFileId();
  379.         $em->remove($mdvProductSelected);
  380.         $em->flush();
  382.         return $this->redirectToRoute('ave_edit_file', array('id' => $id));
  383.     }
  386.     /**
  387.      * @Route("/updateproductfilegrid/",  name="ave_updategrid_productfile")
  388.      * Actualizar grid de productos de un expediente
  389.      */
  390.     public function updategridProductFileAction(Request $request)
  391.     {
  392.         $em = $this->getDoctrine()->getManager();
  393.         $newRequest = $request->request->get('product');
  394.         $fileId = $request->request->get('fileId');
  395.         $logTelegram = false;
  396.         $srvInconsistentes = '';                    // Mensaje de alerta por inconsistencia en los servicios
  397.         $txtOfChanges = '';
  399.         /* Obtengo usuario logueado */
  400.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  401.         $user_id = $user_logueado->getId();
  403.         foreach ($newRequest as $key => $item) {
  404.             $txtWarning = '';
  405.             if (!empty($item['name'])){
  406.                 if (is_numeric($item['price'])){
  407.                     $logTelegram = true;
  408.                     $productInFile = $em->getRepository(AveProductFile::class)->findOneById($key);
  410.                     if ($productInFile->getType() =='Paquete'){
  411.                         // Se llama la funcion que procesa la actualizacion de los paquetes
  412.                         $data = $this->avePackageDeployService->updatePackage( $key, $item['price'], $item['units'], $item['days']);
  413.                     } else {
  414.                         $productInFile->setProductName($item['name']);
  415.                         $productInFile->setServicePrice($item['price']);
  416.                         $productInFile->setUnits($item['units']);
  417.                         $productInFile->setDays($item['days']);
  418.                         $productInFile->setSubTotalPrice($item['price'] * $item['units'] * $item['days']);
  420.                         // *** Primero se debe calcular la comision y luego el over ***
  422.                         // Calculo de comision
  423.                         if ($productInFile->getOpCommission()) {
  424.                             //Over positivo
  425.                             if (!($productInFile->getCommission() == 0) and is_numeric($productInFile->getCommission())) {
  426.                                 $suma = $productInFile->getCommission() / 100;
  427.                                 $suma = $productInFile->getSubTotalPrice() * $suma;
  428.                                 $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + $suma);
  429.                             }
  430.                         } else {
  431.                             //Over negativo
  432.                             if (!($productInFile->getCommission() == 0) and is_numeric($productInFile->getCommission())) {
  433.                                 $suma = $productInFile->getCommission() / 100;
  434.                                 $suma = $productInFile->getSubTotalPrice() * $suma;
  435.                                 if ($productInFile->getSubTotalPrice() > $suma) {            // La comision a restar no puede ser mayor que el precio total
  436.                                     $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() - $suma);
  437.                                 }
  438.                             }
  439.                         }
  441.                         // Calculo con OVER
  442.                         if ($productInFile->getOpOver()) {
  443.                             //Over positivo
  444.                             if (!($productInFile->getOver() == 0) and is_numeric($productInFile->getOver())) {
  445.                                 $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + $productInFile->getOver());
  446.                             }
  447.                         } else {
  448.                             //Over negativo
  449.                             if (!($productInFile->getOver() == 0) and is_numeric($productInFile->getOver())) {
  450.                                 $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + ((-1) * $productInFile->getOver()));
  451.                             }
  452.                         }
  454.                         // IVA
  456. //                    $productInFile->setDescription($item['description']);
  457.                         $productInFile->setUpdatedId($user_id);
  458.                         $productInFile->setUpdatedAt(new \DateTime("now"));
  460.                         //Si las fechas de inicio y fin no coinciden con el campo dias se debe enviar alerta
  461.                         $txtWarning = ($productInFile->getDateOutAt()->diff($productInFile->getDateInAt()))->days + 1 <> $productInFile->getDays() ? '<br>' . $productInFile->getProductName() : '';
  462.                         if (!empty($txtWarning)) {
  463.                             if (empty($srvInconsistentes)) {
  464.                                 $srvInconsistentes = 'Hay inconsistencias en: ' . '<br>' . $txtWarning;
  465.                             } else {
  466.                                 $srvInconsistentes = $srvInconsistentes . '<br>' . $txtWarning;
  467.                             }
  468.                         }
  470.                     }
  472.                     $em->persist($productInFile);
  473.                     $em->flush();
  475.                     //INICIO: Duplicamos en Eventos
  476.                     $proposalId = 0;
  477.                     if (!empty($productInFile->getOriginId())) {
  478.                         $serviceEvent = $em->getRepository(ProposalSupplierServices::class)->findOneById($productInFile->getOriginId());
  479.                         $oldServiceEvent = array(
  480.                             'activityId' => $serviceEvent->getActivityId(),
  481.                             'assistantId' => $serviceEvent->getAssistantId(),
  482.                             'breakdown' => $serviceEvent->getBreakdown(),
  483.                             'commission' => $serviceEvent->getCommission(),
  484.                             'controlId' => $serviceEvent->getControlId(),
  485.                             'currency' => $serviceEvent->getCurrency(),
  486.                             'dateBlockLimit' => $serviceEvent->getDateBlockLimit(),
  487.                             'dateInAt' => $serviceEvent->getDateInAt(),
  488.                             'dateOutAt' => $serviceEvent->getDateOutAt(),
  489.                             'destinationId' => $serviceEvent->getDestinationId(),
  490.                             'directPayment' => $serviceEvent->getDirectPayment(),
  491.                             'hour' => $serviceEvent->getHour(),
  492.                             'ideaId' => $serviceEvent->getIdeaId(),
  493.                             'isFather' => $serviceEvent->getIsFather(),
  494.                             'iva' => $serviceEvent->getIva(),
  495.                             'name' => $serviceEvent->getName(),
  496.                             'opCommission' => $serviceEvent->getOpCommission(),
  497.                             'opIva' => $serviceEvent->getOpIva(),
  498.                             'opOver' => $serviceEvent->getOpOver(),
  499.                             'originalIva' => $serviceEvent->getOriginalIva(),
  500.                             'originalPrice' => $serviceEvent->getOriginalPrice(),
  501.                             'originalopIva' => $serviceEvent->getOriginalopIva(),
  502.                             'over' => $serviceEvent->getOver(),
  503.                             'pax' => $serviceEvent->getPax(),
  504.                             'preCommission' => $serviceEvent->getPreCommission(),
  505.                             'preIva' => $serviceEvent->getPreIva(),
  506.                             'price' => $serviceEvent->getPrice(),
  507.                             'proposalId' => $serviceEvent->getProposalId(),
  508.                             'rank' => $serviceEvent->getRank(),
  509.                             'serviceCatId' => $serviceEvent->getServiceCatId(),
  510.                             'serviceCatName' => $serviceEvent->getServiceCatName(),
  511.                             'serviceId' => $serviceEvent->getServiceId(),
  512.                             'serviceIdFather' => $serviceEvent->getServiceIdFather(),
  513.                             'status' => $serviceEvent->getStatus(),
  514.                             'statusRec' => $serviceEvent->getStatusRec(),
  515.                             'statusinternal' => $serviceEvent->getStatusinternal(),
  516.                             'supplierId' => $serviceEvent->getSupplierId(),
  517.                             'units' => $serviceEvent->getUnits(),
  518.                         );
  520.                         if (!empty($serviceEvent)) {
  521.                             $proposalId = $serviceEvent->getProposalId();
  522.                             $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($serviceEvent->getProposalId());
  523.                             if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  525. //                            $serviceEvent->setUnits(1);                             // Las unidades no se pueden replicar o se genera un sobre calculo del lado de Evenetos
  526.                                 $serviceEvent->setName($productInFile->getProductName());
  528.                                 $priceInOut = $productInFile->getSubTotalPrice();
  529.                                 if (!($productInFile->getPax() == 0)) {
  530.                                     $priceInOut = $priceInOut / $productInFile->getPax();                    // Se devuelve el calculo dividiendo entre personas
  531.                                 }
  532.                                 if (!($productInFile->getUnits() == 0)) {
  533.                                     $priceInOut = $priceInOut / $productInFile->getUnits();                  // Se devuelve el calculo dividiendo entre cantidades
  534.                                 }
  535.                                 if (!($productInFile->getDays() == 0)) {
  536.                                     $priceInOut = $priceInOut / round($productInFile->getDays());            // Se devuelve el calculo dividiendo entre dias, se redondea por si es 1.5
  537.                                 }
  538.                                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  539.                                 $priceInOut = round($priceInOut, 2, PHP_ROUND_HALF_UP);
  541.                                 $serviceEvent->setPrice($priceInOut);
  543.                                 // Se verifican los precios en ambas partes (AV Express e InOut)
  544.                                 if (!($serviceEvent->getPrice() == $productInFile->getServicePrice())) {
  545.                                     // Si ambos precios unitarios son distintos se ha modificado el numero de días en Av Express
  546.                                     $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  547.                                     $serviceEvent->setPrice($newPriceInOut);
  548.                                 } else {
  549.                                     // si son iguales tambien se deben verificar el numero de dias
  550.                                     if (!(($serviceEvent->getDateOutAt()->diff($serviceEvent->getDateInAt())->days + 1) == $productInFile->getDays())) {
  551.                                         $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  552.                                         $serviceEvent->setPrice($newPriceInOut);
  553.                                     }
  554.                                 }
  556.                                 $serviceEvent->setCurrency($productInFile->getCurrency());
  557.                                 $serviceEvent->setUnits($productInFile->getUnits());
  558. //                            $serviceEvent->setIva(21);
  559.                                 if (empty($productInFile->getPax())) {
  560.                                     $serviceEvent->setPax(1);
  561.                                 } else {
  562.                                     $serviceEvent->setPax($productInFile->getPax());
  563.                                 }
  564.                                 $serviceEvent->setDateInAt($productInFile->getDateInAt());
  565.                                 $serviceEvent->setDateOutAt($productInFile->getDateOutAt());
  567.                                 //Verificamos cambios e informamos al agente del proposal
  568.                                 $boolChanges = false;
  569.                                 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; }
  570.                                 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; }
  571.                                 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; }
  572.                                 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; }
  573.                                 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; }
  574.                                 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; }
  575.                                 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; }
  576.                                 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; }
  577.                                 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; }
  578.                                 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; }
  579.                                 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; }
  580.                                 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; }
  581.                                 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; }
  582.                                 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; }
  583.                                 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; }
  584.                                 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; }
  586.                                 $em->persist($serviceEvent);
  587.                                 $em->flush();
  588.                             }
  589.                         }
  590.                     }
  591.                     //FIN: Duplicamos en Eventos
  592.                 }
  593.             }
  594.         }
  595.         // Notificamos al agente de InOut si se hicieron actualizaciones en los servicios desde AvExpress
  596.         if (!empty($txtOfChanges)) { $this->messageOfChangesToAgent($txtOfChanges, $proposalId); }
  598.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  600.         $event = 'Servicios guardados correctamente.';
  601.         $successMessage = $this->translator->trans($event);
  602.         $this->addFlash('mensajeav', $successMessage);
  604.         if (!empty($srvInconsistentes) and !empty($file->getIdProposal())){ $this->addFlash('mensajeaverror', $srvInconsistentes); }
  606.         // Si el proposalId esta vacio no se notifica a nadie por Telegram
  607.         if (empty($file->getIdProposal())){$logTelegram = false;}
  609.         //INICIO: Notificamos al agente por Telegram
  610.         if ($logTelegram){
  611.             //Buscamos todos los agentes del proposal
  612.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($file->getIdProposal());
  614.             //Buscamos el Destino
  615. //            $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  617.             //Buscamos el agente de AVEXPRESS
  618.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  620.             if (!empty($proposalAgents) and !($user_id == 22)){
  621.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  622.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  623.                 }
  624.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  625.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  626.                 }
  627.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  628.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  629.                 }
  630.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  631.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  632.                 }
  633.             }
  634.         }
  635.         //FIN: Notificamos al agente por Telegram
  637.         return $this->redirectToRoute('ave_edit_file', array('id' => $fileId));
  638.     }
  641.     /**
  642.      * @Route("/updateproductfilegridtwo/",  name="ave_update_productfile_grid_two")
  643.      * Editar todos los producto de un expediente con todos sus campos
  644.      */
  645.     public function updateProductFileGridTwoAction(Request $request){
  647.         $em = $this->getDoctrine()->getManager();
  648.         $newRequest = $request->request->get('services');
  649.         $fileId = $request->request->get('fileId');
  650.         $logTelegram = false;
  651.         $srvInconsistentes = '';                    // Mensaje de alerta por inconsistencia en los servicios
  653.         /* Obtengo usuario logueado */
  654.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  655.         $user_id = $user_logueado->getId();
  657.         $txtOfChanges = ''; $boolNotifyOfChanges = false; $proposalId = 0;
  659.         foreach ($newRequest as $item) {
  660.             $productInFile = $em->getRepository(AveProductFile::class)->findOneById($item['productFileId']);
  662.             $logTelegram = true;
  663.             $txtWarning = '';
  665.             $configItems = (str_contains($productInFile->getProductName(), '€')) ? 1 : 0;
  666.             $isPack = ($productInFile->getType() == 'Paquete');
  668.             if ($isPack and ($configItems == 1)){
  669.                 // Se llama la funcion que procesa la actualizacion de los paquetes
  670.                 $data = $this->avePackageDeployService->updatePackage( $productInFile->getId(), $item['price'], $item['units'], $item['days']);
  671.             } else {
  672.                 $productInFile->setProductName($item['name']);
  673.                 $productInFile->setServicePrice($item['price']);
  674. //                $productInFile->setDescription($item['description']);
  675.                 $productInFile->setCurrency($item['currency']);
  676.                 $productInFile->setUnits($item['units']);
  677.                 $productInFile->setType($item['prdType']);
  678.                 $productInFile->setLocation($item['location']);
  679.                 $productInFile->setRankAv(intval($item['rankAv']));
  681.                 if (array_key_exists('dateInAt', $item)) {
  682.                     $productInFile->setDateStart(new \DateTime($item['dateInAt']));
  683.                     $productInFile->setDateInAt(new \DateTime($item['dateInAt']));
  684.                 } else {
  685.                     // No se requiere accion
  686.                 }
  688.                 if (array_key_exists('dateOutAt', $item)) {
  689.                     $productInFile->setDateEnd(new \DateTime($item['dateOutAt']));
  690.                     $productInFile->setDateOutAt(new \DateTime($item['dateOutAt']));
  691.                 } else {
  692.                     // No se requiere accion
  693.                 }
  695.                 if (empty($item['days'])) {
  696. //                $productInFile->setDays($days = (((new \DateTime($item['dateOutAt']))->diff(new \DateTime($item['dateInAt'])))->days + 1));
  697.                     $productInFile->setDays($days = (($productInFile->getDateOutAt()->diff($productInFile->getDateInAt()))->days + 1));
  698.                 } else {
  699.                     $productInFile->setDays($item['days']);
  700.                 }
  701.                 $productInFile->setPax($item['pax']);
  702.                 $productInFile->setOpCommission($item['opCommission']);
  703.                 $productInFile->setCommission($item['commission']);
  704.                 $productInFile->setOpOver($item['opOver']);
  705.                 $productInFile->setOver($item['over']);
  706.                 $productInFile->setOpIva($item['opIva']);
  707.                 $productInFile->setIva($item['iva']);
  709.                 if (!empty($item['supplierExt'])) {
  710.                     $supplier = $em->getRepository(Supplier::class)->findOneById($item['supplierExt']);
  711.                     $productInFile->setSupplierExt($supplier->getName());
  712.                     $productInFile->setSupplierExtId($item['supplierExt']);
  713.                 } else {
  714.                     $productInFile->setSupplierExt(null);
  715.                     $productInFile->setSupplierExtId(null);
  716.                 }
  718.                 $productInFile->setHourStart(substr($item['start'], 0, 2));
  719.                 $productInFile->setMinStart(substr($item['start'], 3, 2));
  721.                 $productInFile->setHourEnd(substr($item['end'], 0, 2));
  722.                 $productInFile->setMinEnd(substr($item['end'], 3, 2));
  724.                 $productInFile->setUpdatedId($user_id);
  725.                 $productInFile->setUpdatedAt(new \DateTime("now"));
  727.                 $productInFile->setSubTotalPrice($productInFile->getServicePrice());
  729.                 //INICIO: Validaciones para el sub total
  730.                 if (is_numeric($productInFile->getUnits())) {
  731.                     $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() * $productInFile->getUnits());
  732.                 }
  734.                 if (is_numeric($productInFile->getPax())) {
  735.                     $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() * $productInFile->getPax());
  736.                 }
  738.                 $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() * $productInFile->getDays());
  740.                 // *** Primero se debe calcular la comision y luego el over ***
  742.                 // Calculo de comision
  743.                 if ($productInFile->getOpCommission()) {
  744.                     //Over positivo
  745.                     if (!($productInFile->getCommission() == 0) and is_numeric($productInFile->getCommission())) {
  746.                         $suma = $productInFile->getCommission() / 100;
  747.                         $suma = $productInFile->getSubTotalPrice() * $suma;
  748.                         $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + $suma);
  749.                     }
  750.                 } else {
  751.                     //Over negativo
  752.                     if (!($productInFile->getCommission() == 0) and is_numeric($productInFile->getCommission())) {
  753.                         $suma = $productInFile->getCommission() / 100;
  754.                         $suma = $productInFile->getSubTotalPrice() * $suma;
  755.                         if ($productInFile->getSubTotalPrice() > $suma) {            // La comision a restar no puede ser mayor que el precio total
  756.                             $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() - $suma);
  757.                         }
  758.                     }
  759.                 }
  761.                 // Calculo con OVER
  762.                 if ($productInFile->getOpOver()) {
  763.                     //Over positivo
  764.                     if (!($productInFile->getOver() == 0) and is_numeric($productInFile->getOver())) {
  765.                         $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + $productInFile->getOver());
  766.                     }
  767.                 } else {
  768.                     //Over negativo
  769.                     if (!($productInFile->getOver() == 0) and is_numeric($productInFile->getOver())) {
  770.                         $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + ((-1) * $productInFile->getOver()));
  771.                     }
  772.                 }
  774.                 // IVA
  775.                 //FIN: Validaciones para el sub total
  777.             }
  779.             //Si las fechas de inicio y fin no coinciden con el campo dias se debe enviar alerta
  780.             $txtWarning = ($productInFile->getDateOutAt()->diff($productInFile->getDateInAt()))->days + 1 <> $productInFile->getDays() ? '<br>'.$productInFile->getProductName() : '';
  781.             if (!empty($txtWarning)){
  782.                 if (empty($srvInconsistentes)){ $srvInconsistentes = 'Hay inconsistencias en: '.'<br>'.$txtWarning; } else { $srvInconsistentes = $srvInconsistentes.'<br>'.$txtWarning; }
  783.             }
  785.             $em->persist($productInFile);
  786.             $em->flush();
  787.             $em->clear();
  789.             //INICIO: Duplicamos en Eventos (SINCRONIZACION)
  790.             if (!empty($productInFile->getOriginId())){
  791.                 $serviceEvent = $em->getRepository(ProposalSupplierServices::class)->findOneById($productInFile->getOriginId());
  792.                 $proposalId = $serviceEvent->getProposalId();
  793.                 $oldServiceEvent = array(
  794.                     'activityId' => $serviceEvent->getActivityId(),
  795.                     'assistantId' => $serviceEvent->getAssistantId(),
  796.                     'breakdown' => $serviceEvent->getBreakdown(),
  797.                     'commission' => $serviceEvent->getCommission(),
  798.                     'controlId' => $serviceEvent->getControlId(),
  799.                     'currency' => $serviceEvent->getCurrency(),
  800.                     'dateBlockLimit' => $serviceEvent->getDateBlockLimit(),
  801.                     'dateInAt' => $serviceEvent->getDateInAt(),
  802.                     'dateOutAt' => $serviceEvent->getDateOutAt(),
  803.                     'destinationId' => $serviceEvent->getDestinationId(),
  804.                     'directPayment' => $serviceEvent->getDirectPayment(),
  805.                     'hour' => $serviceEvent->getHour(),
  806.                     'ideaId' => $serviceEvent->getIdeaId(),
  807.                     'isFather' => $serviceEvent->getIsFather(),
  808.                     'iva' => $serviceEvent->getIva(),
  809.                     'name' => $serviceEvent->getName(),
  810.                     'opCommission' => $serviceEvent->getOpCommission(),
  811.                     'opIva' => $serviceEvent->getOpIva(),
  812.                     'opOver' => $serviceEvent->getOpOver(),
  813.                     'originalIva' => $serviceEvent->getOriginalIva(),
  814.                     'originalPrice' => $serviceEvent->getOriginalPrice(),
  815.                     'originalopIva' => $serviceEvent->getOriginalopIva(),
  816.                     'over' => $serviceEvent->getOver(),
  817.                     'pax' => $serviceEvent->getPax(),
  818.                     'preCommission' => $serviceEvent->getPreCommission(),
  819.                     'preIva' => $serviceEvent->getPreIva(),
  820.                     'price' => $serviceEvent->getPrice(),
  821.                     'proposalId' => $serviceEvent->getProposalId(),
  822.                     'rank' => $serviceEvent->getRank(),
  823.                     'serviceCatId' => $serviceEvent->getServiceCatId(),
  824.                     'serviceCatName' => $serviceEvent->getServiceCatName(),
  825.                     'serviceId' => $serviceEvent->getServiceId(),
  826.                     'serviceIdFather' => $serviceEvent->getServiceIdFather(),
  827.                     'status' => $serviceEvent->getStatus(),
  828.                     'statusRec' => $serviceEvent->getStatusRec(),
  829.                     'statusinternal' => $serviceEvent->getStatusinternal(),
  830.                     'supplierId' => $serviceEvent->getSupplierId(),
  831.                     'units' => $serviceEvent->getUnits(),
  832.                 );
  834.                 if (!empty($serviceEvent)) {
  835.                     $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($serviceEvent->getProposalId());
  836.                     if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  838.                         $serviceEvent->setName($productInFile->getProductName());
  840.                         // Se verifican los precios en ambas partes (AV Express e InOut)
  841.                         if (!($serviceEvent->getPrice() == $productInFile->getServicePrice())) {
  842.                             // Si ambos precios unitarios son distintos se ha modificado el numero de días en Av Express
  843.                             $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  844.                             $serviceEvent->setPrice($newPriceInOut);
  845.                         } else {
  846.                             // si son iguales tambien se deben verificar el numero de dias
  847.                             if (!(($serviceEvent->getDateOutAt()->diff($serviceEvent->getDateInAt())->days + 1) == $productInFile->getDays())) {
  848.                                 $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $item);
  849.                                 $serviceEvent->setPrice($newPriceInOut);
  850.                             }
  851.                         }
  853.                         $serviceEvent->setCurrency($productInFile->getCurrency());
  854.                         $serviceEvent->setUnits($productInFile->getUnits());
  855.                         if (empty($productInFile->getPax())) {
  856.                             $serviceEvent->setPax(1);
  857.                         } else {
  858.                             $serviceEvent->setPax($productInFile->getPax());
  859.                         }
  860.                         $serviceEvent->setDateInAt($productInFile->getDateInAt());
  861.                         $serviceEvent->setDateOutAt($productInFile->getDateOutAt());
  863.                         // Se verifican los precios en ambas partes (AV Express e InOut)
  864.                         if (!($serviceEvent->getPrice() == $productInFile->getServicePrice())) {
  865.                             // Si ambos precios unitarios son distintos se ha modificado el numero de días en Av Express
  866.                             $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  867.                             $serviceEvent->setPrice($newPriceInOut);
  868.                         } else {
  869.                             // si son iguales tambien se deben verificar el numero de dias
  870.                             if (!(($serviceEvent->getDateOutAt()->diff($serviceEvent->getDateInAt())->days + 1) == $productInFile->getDays())) {
  871.                                 $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  872.                                 $serviceEvent->setPrice($newPriceInOut);
  873.                             }
  874.                         }
  876.                         //Verificamos cambios e informamos al agente del proposal
  877.                         $boolChanges = false;
  878.                         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; }
  879.                         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; }
  880.                         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; }
  881.                         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; }
  882.                         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; }
  883.                         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; }
  884.                         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; }
  885.                         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; }
  886.                         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; }
  887.                         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; }
  888.                         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; }
  889.                         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; }
  890.                         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; }
  891.                         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; }
  892.                         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; }
  893.                         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; }
  895.                         $em->persist($serviceEvent);
  896.                         $em->flush();
  897.                         $em->clear();
  898.                     }
  899.                 }
  900.             }
  901.             //FIN: Duplicamos en Eventos
  902.         }
  904.         // Notificamos al agente de InOut si se hicieron actualizaciones en los servicios desde AvExpress
  905.         if (!empty($txtOfChanges)) { $this->messageOfChangesToAgent($txtOfChanges, $proposalId); }
  907.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  909.         $event = 'Servicios guardados correctamente.';
  910.         $successMessage = $this->translator->trans($event);
  911.         $this->addFlash('mensajeav', $successMessage);
  913.         if (!empty($srvInconsistentes) and !empty($file->getIdProposal())){ $this->addFlash('mensajeaverror', $srvInconsistentes); }
  915.         // Si el proposalId esta vacio no se notifica a nadie por Telegram
  916.         if (empty($file->getIdProposal())){$logTelegram = false;}
  918.         //INICIO: Notificamos al agente por Telegram
  919.         if ($logTelegram){
  920.             //Buscamos todos los agentes del proposal
  921.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($file->getIdProposal());
  923.             //Buscamos el Destino
  924. //            $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  926.             //Buscamos el agente de Develup
  927.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  929.             if (!empty($proposalAgents) and !($user_id == 22)){
  930.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  931.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID2) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  932.                 }
  933.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  934.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID2) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  935.                 }
  936.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  937.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID2) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  938.                 }
  939.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  940.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID2) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  941.                 }
  942.             }
  943.         }
  944.         //FIN: Notificamos al agente por Telegram
  946.         return $this->redirectToRoute('ave_edit_file', array('id' => $fileId));
  947.     }
  950.     /**
  951.      * @Route("/productfilelistmultiple/{id}",  name="ave_list_multiple_productfile")
  952.      * Listar multiples productos para agregar en el expediente id
  953.      */
  954.     public function listMultipleProductFileAction( $id, Request $request){
  956.         $em = $this->getDoctrine()->getManager();
  957. //        $avs = $em->getRepository(AveProduct::class)->findAll();
  959.         // Listamos por orden alfabetico y se deja de primero a "Otro servicio"
  960.         $parameters = array();
  961.         $dql = 'SELECT i
  962.                     FROM AvexpressBundle:AveProduct i
  963.                     ORDER BY i.name ASC';
  964.         $query = $em->createQuery($dql)->setParameters($parameters);
  965.         $avs = $query->getResult();
  966.         $newAvs = array();
  968.         foreach ($avs as $key => $item) {
  969.             if ($item->getName() == 'Otro servicio'){
  970.                 $item->setName('0 - Otro servicio');
  971.                 $newAvs = array($item);
  972.                 unset($avs[$key]);
  973.                 foreach ($avs as $keyTwo => $elem){
  974.                     $ind = $keyTwo + 1;
  975.                     $elem->setName($ind.' - '.$elem->getName());
  976.                     array_push($newAvs,$elem);
  977.                 }
  978.             }
  979.         }
  980.         $avs = $newAvs;
  982.         /* av Description*/
  983.         $data_av = array();
  984.         foreach($avs as $av){
  986.             $data_av[] = array(
  987.                 'id' => $av->getId(),
  988.                 'name' => $av->getName(),
  989.                 'modules' => null,
  990.                 'type' => $av->getType(),
  991.                 'currency' => 'Euro',
  992.                 'price' => $av->getPrice(),
  993.                 'commission' => 0,
  994.                 'iva' => 21,
  995.                 'controlId' => 0,
  996.                 'description' => null
  997.             );
  998.         }
  1000.         // Buscamos las plantilas precargadas
  1001.         $parameters = [];
  1002.         $dql = 'SELECT i
  1003.                     FROM AvexpressBundle:AveTemplate i
  1004.                     ORDER BY i.name ASC';
  1005.         $query = $em->createQuery($dql)->setParameters($parameters);
  1006.         $aveTemplates = $query->getResult();
  1008.         // Buscamos los paquetes
  1009.         $dql = 'SELECT i
  1010.                 FROM AvexpressBundle:AvePackageTemplate i
  1011.                 ORDER BY i.name ASC';
  1012.         $query = $em->createQuery($dql)->setParameters($parameters);
  1013.         $avePackageTemplates = $query->getResult();
  1015.         // Buscamos las proformas
  1016.         $proformas = $em->getRepository(AveDocProforma::class)->findByFileId($id);
  1018.         return $this->render('MDS/AvexpressBundle/Avexpress/add-services.html.twig',
  1019.             array(
  1020.                 'id' => $id,
  1021.                 'avs' => $data_av,
  1022.                 'newAvs' => $newAvs,
  1023.                 'aveTemplates' => $aveTemplates,
  1024.                 'proformas' => $proformas,
  1025.                 'avePackageTemplates' => $avePackageTemplates,
  1026.                 'technology' => null,
  1027.             ));
  1028.     }
  1031.     /**
  1032.      * @Route("/productfilemultipleadd/",  name="ave_add_multiple_productfile")
  1033.      * Agregar multiples productos a un expediente
  1034.      */
  1035.     public function addMultipleProductFileAction( EntityManagerInterface $em,  Request $request){
  1036.         $logTelegram = false;
  1037.         $fileId = $request->request->get('fileId');
  1038.         $products = $request->request->get('av');
  1039.         $template = $request->request->get('avexpress');
  1040.         $template = $template['template'];
  1041.         $package = $request->request->get('avexpress');
  1042.         $packageId = $package['package'];
  1043.         $packageConfig = $request->request->get('avexpress');
  1044.         $packageConfig = (array_key_exists('packageConfig',$packageConfig)) ? 1 : 0 ;   // 0 precio global, 1 precio detallado
  1046.         $srvDestination = $request->request->get('srvDestination');
  1048.         /* Obtengo usuario logueado */
  1049.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1050.         $user_id = $user_logueado->getId();
  1052.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  1053.         $template = $em->getRepository(AveTemplate::class)->findOneById($template);
  1054.         $package = $em->getRepository(AvePackageTemplate::class)->findOneById($packageId);
  1056.         // Buscamos los elementos del paquete seleccionado
  1057.         $packageItems = [];
  1058.         if(!empty($package)){
  1059.             $data = $this->avePackageDeployService->collapsePackage( $packageId, $fileId, $packageConfig );
  1060.         }
  1062.         if(!empty($products)) {
  1063.             foreach ($products as $item) {
  1064.                 $mdvProductSelected = $em->getRepository(AveProduct::class)->findOneById($item);
  1066.                 $newProductFile = new AveProductFile();
  1067.                 $newProductFile->setProductName($mdvProductSelected->getName());
  1068.                 $newProductFile->setProductId($mdvProductSelected->getId());
  1069.                 $newProductFile->setServicePrice($mdvProductSelected->getPrice());
  1070.                 $newProductFile->setDescription($mdvProductSelected->getDescription());
  1071.                 $newProductFile->setType($mdvProductSelected->getType());
  1072.                 $newProductFile->setFileId($fileId);
  1073.                 $newProductFile->setUnits('1');
  1074.                 $newProductFile->setOpIva(true);
  1075.                 $newProductFile->setIva('21');
  1076.                 $newProductFile->setSupplierExt($mdvProductSelected->getSupplierExt());
  1077.                 $newProductFile->setSupplierExtId($mdvProductSelected->getSupplierExtId());
  1078.                 $dataDates = $this->obtenerFechas($newProductFile->getFileId(), $newProductFile->getDateStart(), $newProductFile->getDateEnd());
  1079.                 $newProductFile->setDateStart($dataDates['dateStart']);
  1080.                 $newProductFile->setDateEnd($dataDates['dateEnd']);
  1081.                 $newProductFile->setDateInAt($dataDates['dateStart']);
  1082.                 $newProductFile->setDateOutAt($dataDates['dateEnd']);
  1084.                 $dataRankAv = $this->obtenerRankAv($fileId);
  1085.                 $newProductFile->setRankAv($dataRankAv);
  1087.                 $newProductFile->setCreatedId($user_id);
  1088.                 $newProductFile->setUpdatedId($user_id);
  1089.                 $newProductFile->setCreatedAt(new \DateTime("now"));
  1090.                 $newProductFile->setUpdatedAt(new \DateTime("now"));
  1092.                 if (empty($newProductFile->getType())){ $newProductFile->setType('Otros'); }
  1094.                 $newProductFile->setDays((($newProductFile->getDateEnd()->diff($newProductFile->getDateStart()))->days + 1));
  1095.                 $newProductFile->setSubTotalPrice($newProductFile->getServicePrice() * $newProductFile->getDays());
  1097.                 $em->persist($newProductFile);
  1098.                 $em->flush();
  1100.                 if (!($srvDestination == 0)){
  1101.                     //Se debe agregar el producto a una proforma
  1102.                     $this->addProductFileToProforma($fileId, $newProductFile->getId(), $srvDestination);
  1103.                 }
  1105.                 // Si hay proposal se debe actualizar en el expediente de Eventos
  1106.                 if (!empty($file->getIdProposal()) and is_numeric($file->getIdProposal())) {
  1108.                     // Buscamos el destino donde se encuentre Av Express y ahi agregamos el servicio, si no se encuentra no se agregara el servicio
  1109.                     $control = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  1110.                         array(
  1111.                             'supplierId' => 80,                                          // El supplier 80 es AVEXPRESS
  1112.                             'proposalId' => $file->getIdProposal(),
  1113.                         )
  1114.                     );
  1116.                     if (!empty($control)) {
  1117.                         // Existe un destino con Av Express como proveedor, hay se agregara el servicio
  1119.                         $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($file->getIdProposal());
  1120.                         if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  1121.                             $logTelegram = true;
  1123.                             $service = new ProposalSupplierServices();
  1124.                             $service->setServiceIdFather(0);
  1125.                             $service->setControlId($control->getId());
  1126.                             $service->setProposalId($file->getIdProposal());
  1127.                             $service->setDestinationId($control->getDestinoId());
  1128.                             $service->setSupplierId(80);
  1129.                             $service->setIdeaId(null);
  1130.                             $service->setServiceId($newProductFile->getProductId());
  1131.                             $service->setServiceCatName('Av');
  1132.                             $service->setServiceCatId(3);
  1133.                             $service->setName($newProductFile->getProductName());
  1135.                             $service->setPrice($newProductFile->getSubTotalPrice() / $newProductFile->getDays());
  1136. //                        $priceInOut = $newProductFile->getSubTotalPrice() / $newProductFile->getPax();      // Se devuelve el calculo dividiendo entre personas
  1137. //                        $priceInOut = $priceInOut / $newProductFile->getUnits();                            // Se devuelve el calculo dividiendo entre cantidades
  1138. //                        $priceInOut = $priceInOut / round($newProductFile->getDays());                      // Se devuelve el calculo dividiendo entre dias, se redondea por si es 1.5
  1139. //                        $service->setPrice($priceInOut);
  1141.                             $service->setCurrency($newProductFile->getCurrency());
  1142.                             $service->setUnits($newProductFile->getUnits());
  1143.                             $service->setCommission(0);
  1144.                             $service->setOver(0);
  1145.                             $service->setIva(21);
  1146.                             $service->setPax(1);
  1147.                             $service->setHour(null);
  1148.                             $service->setDateInAt($newProductFile->getDateInAt());
  1149.                             $service->setDateOutAt($newProductFile->getDateOutAt());
  1150.                             $service->setDirectPayment(0);
  1151.                             $service->setStatus('Pending');
  1152.                             $service->setStatusinternal('Additional');
  1153.                             $service->setPreCommission(null);
  1154.                             $service->setPreIva(null);
  1155.                             $service->setDateBlockLimit(null);
  1156.                             $service->setOpCommission(1);
  1157.                             $service->setOpOver(1);
  1158.                             $service->setOpIva(1);
  1159.                             $service->setBreakdown(0);
  1160.                             $service->setIsFather(0);
  1161.                             $service->setRank(1);
  1162.                             $service->setOriginalopIva(1);
  1163.                             $service->setOriginalIva(null);
  1164.                             $service->setOriginalPrice(null);
  1165.                             $service->setStatusRec('normal');
  1166.                             $service->setAssistantId(null);
  1167.                             $service->setCreatedId($user_id);
  1168.                             $service->setUpdatedId($user_id);
  1169.                             $service->setCreatedAt(new \DateTime("now"));
  1170.                             $service->setUpdatedAt(new \DateTime("now"));
  1172.                             $em->persist($service);
  1173.                             $em->flush();
  1175.                             // Guardamos el ID del servicio (Eventos) asociado al producto (AvExpress)
  1176.                             $newProductFile->setOriginId($service->getId());
  1178.                             $em->persist($newProductFile);
  1179.                             $em->flush();
  1180.                         }
  1181.                     }
  1182.                 }
  1183.             }
  1184.         }
  1186.         // Buscamos los elementos de la plantilla seleccionada
  1187.         $templateItems = [];
  1188.         if(!empty($template)){
  1189.             $templateItems = $em->getRepository(AveTemplateItems::class)->findByTemplateId($template);
  1190.         }
  1192.         foreach ($templateItems as $item){
  1194.             $newProductFile = new AveProductFile();
  1195.             $newProductFile->setProductName($item->getProductName());
  1196.             $newProductFile->setProductId($item->getProductId());
  1197.             $newProductFile->setServicePrice($item->getServicePrice());
  1198.             $newProductFile->setFileId($fileId);
  1199.             $newProductFile->setPax($item->getPax());
  1200.             $newProductFile->setType($item->getType());
  1201.             $newProductFile->setHourStart($item->getHourStart());
  1202.             $newProductFile->setMinStart($item->getMinStart());
  1203.             $newProductFile->setHourEnd($item->getHourEnd());
  1204.             $newProductFile->setMinEnd($item->getMinEnd());
  1205.             $newProductFile->setDescription($item->getDescription());
  1206.             $newProductFile->setSupplierExtId($item->getSupplierExtId());
  1207.             $newProductFile->setSupplierExt($item->getSupplierExt());
  1208.             $newProductFile->setServiceIdProposal($item->getServiceIdProposal());
  1209.             $newProductFile->setServiceIdFather($item->getServiceIdFather());
  1210.             $newProductFile->setControlId($item->getControlId());
  1211.             $newProductFile->setProposalId($item->getProposalId());
  1212.             $newProductFile->setDestinationId($item->getDestinationId());
  1213.             $newProductFile->setIdeaId($item->getIdeaId());
  1214.             $newProductFile->setActivityId($item->getActivityId());
  1215.             $newProductFile->setSupplierId($item->getSupplierId());
  1216.             $newProductFile->setAssistantId($item->getAssistantId());
  1217.             $newProductFile->setServiceId($item->getServiceId());
  1218.             $newProductFile->setServiceCatId($item->getServiceCatId());
  1219.             $newProductFile->setServiceCatName($item->getServiceCatName());
  1220.             $newProductFile->setName($item->getName());
  1221.             $newProductFile->setPrice($item->getPrice());
  1222.             $newProductFile->setCurrency($item->getCurrency());
  1223.             $newProductFile->setUnits($item->getUnits());
  1224.             $newProductFile->setOpCommission($item->getOpCommission());
  1225.             $newProductFile->setCommission($item->getCommission());
  1226.             $newProductFile->setOpOver($item->getOpOver());
  1227.             $newProductFile->setOver($item->getOver());
  1228.             $newProductFile->setOpIva($item->getOpIva());
  1229.             $newProductFile->setIva($item->getIva());
  1230.             $newProductFile->setHour($item->getHour());
  1232.             $dataDates = $this->obtenerFechas($newProductFile->getFileId(), $newProductFile->getDateStart(), $newProductFile->getDateEnd());
  1233.             $newProductFile->setDateStart($dataDates['dateStart']);
  1234.             $newProductFile->setDateEnd($dataDates['dateEnd']);
  1235.             $newProductFile->setDateInAt($dataDates['dateStart']);
  1236.             $newProductFile->setDateOutAt($dataDates['dateEnd']);
  1238.             $newProductFile->setContcolor($item->getContcolor());
  1239.             $newProductFile->setRank($item->getRank());
  1241.             $dataRankAv = $this->obtenerRankAv($fileId);
  1242.             $newProductFile->setRankAv($dataRankAv);
  1244.             $newProductFile->setRenovate($item->getRenovate());
  1245.             $newProductFile->setPay($item->getPay());
  1246.             $newProductFile->setDays($item->getDays());
  1247.             $newProductFile->setSubTotalPrice($item->getSubTotalPrice());
  1249.             $newProductFile->setCreatedId($user_id);
  1250.             $newProductFile->setUpdatedId($user_id);
  1251.             $newProductFile->setCreatedAt(new \DateTime("now"));
  1252.             $newProductFile->setUpdatedAt(new \DateTime("now"));
  1254.             if (empty($newProductFile->getType())){ $newProductFile->setType('Otros'); }
  1256.             $em->persist($newProductFile);
  1257.             $em->flush();
  1259.             if (!($srvDestination == 0)){
  1260.                 //Se debe agregar el producto a una proforma
  1261.                 $this->addProductFileToProforma($fileId, $newProductFile->getId(), $srvDestination);
  1262.             }
  1264.             // Si hay proposal se debe actualizar en el expediente de Eventos
  1265.             if (!empty($file->getIdProposal()) and is_numeric($file->getIdProposal())){
  1267.                 // Buscamos el destino donde se encuentre Av Express y ahi agregamos el servicio, si no se encuentra no se agregara el servicio
  1268.                 $control = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  1269.                     array(
  1270.                         'supplierId' => 80,                                          // El supplier 80 es AVEXPRESS
  1271.                         'proposalId' => $file->getIdProposal(),
  1272.                     )
  1273.                 );
  1275.                 if (!empty($control)){
  1276.                     // Existe un destino con Av Express como proveedor, hay se agregara el servicio
  1277.                     $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($file->getIdProposal());
  1278.                     if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  1279.                         $logTelegram = true;
  1281.                         $service = new ProposalSupplierServices();
  1282.                         $service->setServiceIdFather(0);
  1283.                         $service->setControlId($control->getId());
  1284.                         $service->setProposalId($file->getIdProposal());
  1285.                         $service->setDestinationId($control->getDestinoId());
  1286.                         $service->setSupplierId(80);
  1287.                         $service->setIdeaId(null);
  1288.                         $service->setServiceId($newProductFile->getProductId());
  1289.                         $service->setServiceCatName('Av');
  1290.                         $service->setServiceCatId(3);
  1291.                         $service->setName($newProductFile->getProductName());
  1292.                         $service->setPrice($newProductFile->getSubTotalPrice());
  1293.                         $service->setCurrency(null);
  1294.                         $service->setUnits(1);
  1295.                         $service->setCommission(0);
  1296.                         $service->setOver(0);
  1297.                         $service->setIva(21);
  1298.                         $service->setPax(0);
  1299.                         $service->setHour(null);
  1300.                         $service->setDateInAt(new \DateTime("now"));
  1301.                         $service->setDateOutAt(new \DateTime("now"));
  1302.                         $service->setDirectPayment(0);
  1303.                         $service->setStatus('Pending');
  1304.                         $service->setStatusinternal('Additional');
  1305.                         $service->setPreCommission(null);
  1306.                         $service->setPreIva(null);
  1307.                         $service->setDateBlockLimit(null);
  1308.                         $service->setOpCommission(1);
  1309.                         $service->setOpOver(1);
  1310.                         $service->setOpIva(1);
  1311.                         $service->setBreakdown(0);
  1312.                         $service->setIsFather(0);
  1313.                         $service->setRank(1);
  1314.                         $service->setOriginalopIva(1);
  1315.                         $service->setOriginalIva(null);
  1316.                         $service->setOriginalPrice(null);
  1317.                         $service->setStatusRec('normal');
  1318.                         $service->setAssistantId(null);
  1319.                         $service->setCreatedId($user_id);
  1320.                         $service->setUpdatedId($user_id);
  1321.                         $service->setCreatedAt(new \DateTime("now"));
  1322.                         $service->setUpdatedAt(new \DateTime("now"));
  1324.                         $em->persist($service);
  1325.                         $em->flush();
  1327.                         // Guardamos el ID del servicio (Eventos) asociado al producto (AvExpress)
  1328.                         $newProductFile->setOriginId($service->getId());
  1330.                         $em->persist($newProductFile);
  1331.                         $em->flush();
  1332.                     }
  1333.                 }
  1334.             }
  1335.         }
  1337.         //INICIO: Notificamos al agente por Telegram
  1338.         if ($logTelegram){
  1339.             //Buscamos todos los agentes del proposal
  1340.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($file->getIdProposal());
  1342.             //Buscamos el Destino
  1343.             $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  1345.             //Buscamos el agente de AvExpress
  1346.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  1348.             if (!empty($proposalAgents) and !($user_id == 22)){
  1349.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  1350.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1351.                 }
  1352.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  1353.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1354.                 }
  1355.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  1356.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1357.                 }
  1358.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  1359.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1360.                 }
  1361.             }
  1362.         }
  1363.         //FIN: Notificamos al agente por Telegram
  1365.         return $this->redirectToRoute('ave_edit_file', array( 'id' => $fileId ) );
  1366.     }
  1369.     /**
  1370.      * @Route("/productfileedit/{id}",  name="ave_productfile_edit")
  1371.      * Editar un producto de un expediente
  1372.      */
  1373.     public function editProductFileAction($id, Request $request){
  1375.         $em = $this->getDoctrine()->getManager();
  1376.         $productFile = $em->getRepository(AveProductFile::class)->findOneById($id);
  1378.         $fileId = $productFile->getFileId();
  1380.         // Primero se agrupan por sala (Ubicacion), luego por tipo y finalmente por RankAv
  1381.         // Salvador Guerrero indico, el orden de los productos en la factura o proforma será (Video - Sonido - Iluminacion - Otros)
  1383.         $allProductFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  1384.         $arrayLocation = array();
  1385.         $arrayLocationWithNull = false;
  1386.         foreach ($allProductFile as $item){
  1387.             if (!empty($item->getLocation())){
  1388.                 $arrayLocation[$item->getLocation()] = $item->getLocation();
  1389.             } else {
  1390.                 $arrayLocationWithNull = true;
  1391.             }
  1392.         }
  1393.         if ($arrayLocationWithNull){ $arrayLocation['null'] = 'null'; }
  1395.         $productInFile = array();
  1397.         foreach ($arrayLocation as $item){
  1398.             // VIDEO
  1399.             $parameters = array(
  1400.                 'fileId' => $fileId,
  1401.                 'type' => 'Vídeo',
  1402.                 'location' => $item,
  1403.             );
  1404.             $dql = 'SELECT i
  1405.                     FROM AvexpressBundle:AveProductFile i
  1406.                     WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location
  1407.                     ORDER BY i.rankAv ASC';
  1408.             $query = $em->createQuery($dql)->setParameters($parameters);
  1409.             $productsInFileVid = $query->getResult();
  1411.             // SONIDO
  1412.             $parameters = array(
  1413.                 'fileId' => $fileId,
  1414.                 'type' => 'Sonido',
  1415.                 'location' => $item,
  1416.             );
  1417.             $dql = 'SELECT i
  1418.                     FROM AvexpressBundle:AveProductFile i
  1419.                     WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location
  1420.                     ORDER BY i.rankAv ASC';
  1421.             $query = $em->createQuery($dql)->setParameters($parameters);
  1422.             $productsInFileSound = $query->getResult();
  1424.             // ILUMINACION
  1425.             $parameters = array(
  1426.                 'fileId' => $fileId,
  1427.                 'type' => 'Iluminación',
  1428.                 'location' => $item,
  1429.             );
  1430.             $dql = 'SELECT i
  1431.                     FROM AvexpressBundle:AveProductFile i
  1432.                     WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location
  1433.                     ORDER BY i.rankAv ASC';
  1434.             $query = $em->createQuery($dql)->setParameters($parameters);
  1435.             $productsInFileLights = $query->getResult();
  1437.             // OTROS
  1438.             $parameters = array(
  1439.                 'fileId' => $fileId,
  1440.                 'typeV' => 'Vídeo',
  1441.                 'typeS' => 'Sonido',
  1442.                 'typeI' => 'Iluminación',
  1443.                 'location' => $item,
  1444.             );
  1445.             $dql = 'SELECT i
  1446.                     FROM AvexpressBundle:AveProductFile i
  1447.                     WHERE (i.fileId = :fileId AND i.type != :typeV AND i.type != :typeS AND i.type != :typeI AND i.location = :location)
  1448.                     ORDER BY i.rankAv ASC';
  1449.             $query = $em->createQuery($dql)->setParameters($parameters);
  1450.             $productsInFileOther = $query->getResult();
  1452.             // CASO NULL (Los casos EMPTY estan considerados en las consultas previas)
  1453.             $parameters = array(
  1454.                 'fileId' => $fileId,
  1455.                 'location' => $item,
  1456.             );
  1457.             $dql = 'SELECT i
  1458.                     FROM AvexpressBundle:AveProductFile i
  1459.                     WHERE (i.fileId = :fileId AND i.type IS NULL AND i.location = :location)
  1460.                     ORDER BY i.rankAv ASC';
  1461.             $query = $em->createQuery($dql)->setParameters($parameters);
  1462.             $productsInFileNull = $query->getResult();
  1464.             // Para el location en NULL el SQL tiene que ser diferente por eso el siguiente condicional
  1465.             if ($item == 'null'){
  1467.                 // VIDEO
  1468.                 $parameters = array(
  1469.                     'fileId' => $fileId,
  1470.                     'type' => 'Vídeo',
  1471.                     'location' => '',
  1472.                 );
  1473.                 $dql = 'SELECT i
  1474.                         FROM AvexpressBundle:AveProductFile i
  1475.                         WHERE i.fileId = :fileId AND i.type = :type AND (i.location IS NULL OR i.location = :location)
  1476.                         ORDER BY i.rankAv ASC';
  1477.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1478.                 $productsInFileVid = $query->getResult();
  1480.                 // SONIDO
  1481.                 $parameters = array(
  1482.                     'fileId' => $fileId,
  1483.                     'type' => 'Sonido',
  1484.                     'location' => '',
  1485.                 );
  1486.                 $dql = 'SELECT i
  1487.                         FROM AvexpressBundle:AveProductFile i
  1488.                         WHERE i.fileId = :fileId AND i.type = :type AND (i.location IS NULL OR i.location = :location) 
  1489.                         ORDER BY i.rankAv ASC';
  1490.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1491.                 $productsInFileSound = $query->getResult();
  1493.                 // ILUMINACION
  1494.                 $parameters = array(
  1495.                     'fileId' => $fileId,
  1496.                     'type' => 'Iluminación',
  1497.                     'location' => '',
  1498.                 );
  1499.                 $dql = 'SELECT i
  1500.                         FROM AvexpressBundle:AveProductFile i
  1501.                         WHERE i.fileId = :fileId AND i.type = :type AND (i.location IS NULL OR i.location = :location)
  1502.                         ORDER BY i.rankAv ASC';
  1503.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1504.                 $productsInFileLights = $query->getResult();
  1506.                 // OTROS
  1507.                 $parameters = array(
  1508.                     'fileId' => $fileId,
  1509.                     'typeV' => 'Vídeo',
  1510.                     'typeS' => 'Sonido',
  1511.                     'typeI' => 'Iluminación',
  1512.                     'location' => '',
  1513.                 );
  1514.                 $dql = 'SELECT i
  1515.                         FROM AvexpressBundle:AveProductFile i
  1516.                         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))
  1517.                         ORDER BY i.rankAv ASC';
  1518.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1519.                 $productsInFileOther = $query->getResult();
  1521.                 // CASO NULL DEL TIPO (Los casos EMPTY estan considerados en las consultas previas)
  1522.                 $parameters = array(
  1523.                     'fileId' => $fileId,
  1524.                     'location' => '',
  1525.                 );
  1526.                 $dql = 'SELECT i
  1527.                         FROM AvexpressBundle:AveProductFile i
  1528.                         WHERE (i.fileId = :fileId AND i.type IS NULL AND (i.location IS NULL OR i.location = :location))
  1529.                         ORDER BY i.rankAv ASC';
  1530.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1531.                 $productsInFileNull = $query->getResult();
  1532.             }
  1533.             $productInFile = array_merge($productInFile,$productsInFileVid, $productsInFileSound, $productsInFileLights, $productsInFileOther, $productsInFileNull);
  1534.         }
  1537.         $parameters = array();
  1538.         $dql = 'SELECT p.id, p.name
  1539.                 FROM App\Entity\Supplier p
  1540.                 WHERE p.isSupplierAvExpress = TRUE 
  1541.                 ORDER BY p.name ASC ';
  1543.         $query = $em->createQuery($dql)->setParameters($parameters);
  1544.         $suppliers = $query->getResult();
  1546.         // Quitamos el elemento seleccionado para evitar duplicaciones
  1547.         foreach ($productInFile as $key => $item) {
  1548.             if ($productFile->getId() == $item->getId()){
  1549.                 unset($productInFile[$key]);
  1550.             }
  1551.         }
  1552.         $id = $productFile->getFileId();
  1553.         $numeroItems = sizeof($productInFile) + 1;
  1555.         $productsLocation = $em->getRepository(AveProductFileLocationNames::class)->findAll();
  1557.         return $this->render('MDS/AvexpressBundle/Avexpress/edit-productfiles.html.twig',
  1558.             array(
  1559.                 'id' => $id,
  1560.                 'numeroItems' => $numeroItems,
  1561.                 'arrayProductFile' => $productInFile,
  1562.                 'services' => $productInFile,
  1563.                 'product' => array($productFile),
  1564.                 'suppliers' => $suppliers,
  1565.                 'productsLocation' => $productsLocation,
  1566.             ));
  1567.     }
  1570.     /**
  1571.      * @Route("/cleanproductfile/{id}",  name="ave_clean_productfile")
  1572.      * Eliminar los productos (y servicios en InOut) de un expediente que no estén relacionados con una factura o una proforma
  1573.      */
  1574.     public function cleanProductFileAction($id, Request $request)
  1575.     {
  1576.         $em = $this->getDoctrine()->getManager();
  1578.         /* Obtengo usuario logueado */
  1579.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1580.         $user_id = $user_logueado->getId();
  1582.         $allMdvProductSelected = $em->getRepository(AveProductFile::class)->findByFileId($id);
  1584.         // Si el ProductFile esta asociado a una factura o a una proforma se mantiene, de lo contrario se elimina y su evento asociado
  1585.         foreach ($allMdvProductSelected as $key => $item){
  1586.             $isInInvoice = $em->getRepository(AveDocInvoiceItems::class)->findOneByPrdControlId($item->getId());
  1587.             $isInProforma = $em->getRepository(AveDocProformaItems::class)->findOneByControlId($item->getId());
  1589.             if (!empty($isInInvoice) or !empty($isInProforma)){
  1590.                 //Lo sacamos de la lista de elementos a eliminar
  1592.                 unset($allMdvProductSelected[$key]);
  1593.             }
  1594.         }
  1596.         foreach ($allMdvProductSelected as $mdvProductSelected){
  1597.             $logTelegram = false;
  1599.             //INICIO: Si hay un ID origin se debe eliminar en Eventos
  1600.             if (!empty($mdvProductSelected->getOriginId())){
  1601.                 $logTelegram = true;
  1602.                 $delete = $em->getRepository(ProposalSupplierServices::class)->findOneById($mdvProductSelected->getOriginId());
  1603.                 if (!empty($delete)) {
  1604.                     $destinationId = $delete->getDestinationId();
  1605.                     $nameServEvents = $delete->getName();
  1606.                     $proposalId = $delete->getProposalId();
  1607.                     $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($delete->getProposalId());
  1608.                     if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  1609.                         if (!empty($delete)) {
  1610.                             $delete_sub = $em->getRepository(ProposalSupplierServices::class)->findByServiceIdFather($delete->getId());
  1611.                             foreach ($delete_sub as $deletesub) {
  1612.                                 $em->remove($deletesub);
  1613.                             }
  1615.                             $em->remove($delete);
  1616.                             $em->flush();
  1617.                         }
  1618.                     }
  1619.                 } else {
  1620.                     // El servicio origen no se encontro
  1621.                     $logTelegram = false;
  1622.                 }
  1623.             }
  1625.             //INICIO: Notificamos al agente por Telegram
  1626.             if ($logTelegram){
  1627.                 //Buscamos todos los agentes del proposal
  1628.                 $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposalId);
  1630.                 //Buscamos el Destino
  1631.                 $proposalDestino = $em->getRepository(Destination::class)->findOneById($destinationId);
  1633.                 //Buscamos el agente de Develup
  1634.                 $userData = $em->getRepository(User::class)->findOneById($user_id);
  1636.                 if (!empty($proposalAgents)){
  1637.                     if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  1638.                         $this->sendTelegram($proposalAgents->getAgOne(),'1. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1639.                     }
  1640.                     if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  1641.                         $this->sendTelegram($proposalAgents->getAgTwo(),'2. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1642.                     }
  1643.                     if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  1644.                         $this->sendTelegram($proposalAgents->getAgThree(),'3. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1645.                     }
  1646.                     if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  1647.                         $this->sendTelegram($proposalAgents->getAgFour(),'4. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1648.                     }
  1649.                 }
  1650.             }
  1651.             //FIN: Notificamos al agente por Telegram
  1653.             //FIN: Si hay un ID origin se debe eliminar en Eventos
  1655.             //INICIO: Si el producto se encuentra dentro de una proforma (Ave_Doc_Proforma_Items) se elimina también
  1656.             $productInProforma = $em->getRepository(AveDocProformaItems::class)->findOneByControlId($mdvProductSelected->getId());
  1657.             if (!empty($productInProforma)){
  1658.                 $productInProforma->setFileId((-1) * $productInProforma->getFileId());      // No lo vamos a eliminar, apuntará al fileId en negativo
  1659.                 $em->persist($productInProforma);
  1660.                 // $em->remove($productInProforma);
  1661.                 $em->flush();
  1662.             }
  1663.             //FIN: Si el producto se encuentra dentro de una proforma (Ave_Doc_Proforma_Items) se elimina también
  1665.             $mdvProductSelected->setFileId((-1) * $mdvProductSelected->getFileId());      // No lo vamos a eliminar, apuntará al fileId en negativo
  1666.             $em->persist($mdvProductSelected);
  1667.             // $em->remove($mdvProductSelected);
  1668.             $em->flush();
  1669.         }
  1671.         return $this->redirectToRoute('ave_edit_file', array('id' => $id));
  1672.     }
  1675.     /**
  1676.      * @Route("/overallproductfile/",  name="ave_over_all_productfile")
  1677.      * Aplicar un Over a todos los productos de un expediente
  1678.      */
  1679.     public function overAllProductFileAction(Request $request){
  1681.         $fileId = $request->request->get('fileId');
  1682.         $opOverAll = $request->request->get('opOverAll');
  1683.         $overAll = $request->request->get('overAll');
  1685.         $em = $this->getDoctrine()->getManager();
  1686.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  1688.         foreach ($productInFile as $item){
  1689.             $itemId = $item->getId();
  1690.             $item->setOpOver($opOverAll);
  1691.             $item->setOver($overAll);
  1693.             $em->persist($item);
  1694.             $em->flush();
  1695.         }
  1697.         return $this->redirectToRoute('ave_productfile_edit', array('id' => $itemId));
  1698.     }
  1701.     /**
  1702.      * @Route("/commissionallproductfile/",  name="ave_commission_all_productfile")
  1703.      * Aplicar una Comision a todos los productos de un expediente
  1704.      */
  1705.     public function commissionAllProductFileAction(Request $request){
  1707.         $fileId = $request->request->get('fileId');
  1708.         $opCommissionAll = $request->request->get('opCommissionAll');
  1709.         $commissionAll = $request->request->get('commissionAll');
  1711.         $em = $this->getDoctrine()->getManager();
  1712.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  1714.         foreach ($productInFile as $item){
  1715.             $itemId = $item->getId();
  1716.             $item->setOpCommission($opCommissionAll);
  1717.             $item->setCommission($commissionAll);
  1719.             $em->persist($item);
  1720.             $em->flush();
  1721.         }
  1723.         return $this->redirectToRoute('ave_productfile_edit', array('id' => $itemId));
  1724.     }
  1726.     /**
  1727.      * @Route("/ivazeroallproductfile/",  name="ave_iva_zero_all_productfile")
  1728.      * Aplicar un IVA de cero a todos los productos de un expediente
  1729.      */
  1730.     public function ivaZeroAllProductFileAction(Request $request){
  1731.         $fileId = $request->request->get('fileId');
  1732. //        $opCommissionAll = $request->request->get('opCommissionAll');
  1733. //        $commissionAll = $request->request->get('commissionAll');
  1734.         $em = $this->getDoctrine()->getManager();
  1735.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  1736.         foreach ($productInFile as $item){
  1737.             $itemId = $item->getId();
  1738.             $item->setOpIva(1);
  1739.             $item->setIva(0);
  1740.             
  1741.             $em->persist($item);
  1742.             $em->flush();
  1743.         }
  1744.         return $this->redirectToRoute('ave_productfile_edit', array('id' => $itemId));
  1745.     }
  1746.     
  1749.     /**
  1750.      * @Route("/productfilelocationadd/",  name="ave_add_productfilelocation")
  1751.      * Agregar una Ubicacion. Salas en donde estara el producto
  1752.      */
  1753.     public function addProductFileLocationAction( Request $request)
  1754.     {
  1755.         $em = $this->getDoctrine()->getManager();
  1756.         $newRequest = $request->request->get('product');
  1758.         /* Obtengo usuario logueado */
  1759.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1760.         $user_id = $user_logueado->getId();
  1762.         $newProductFile = new AveProductFileLocationNames();
  1763.         $newProductFile->setName($newRequest['name']);
  1764.         $newProductFile->setDescription($newRequest['description']);
  1766.         $newProductFile->setCreatedId($user_id);
  1767.         $newProductFile->setUpdatedId($user_id);
  1768.         $newProductFile->setCreatedAt(new \DateTime("now"));
  1769.         $newProductFile->setUpdatedAt(new \DateTime("now"));
  1771.         $em->persist($newProductFile);
  1772.         $em->flush();
  1774.         return $this->redirectToRoute('ave_list_productfilelocation');
  1775.     }
  1778.     /**
  1779.      * @Route("/productfilelocationlist/",  name="ave_list_productfilelocation")
  1780.      * Listar Ubicaciones para los productos
  1781.      */
  1782.     public function listProductFileLocationAction(Request $request){
  1783.         $em = $this->getDoctrine()->getManager();
  1784.         $productsLocation = $em->getRepository(AveProductFileLocationNames::class)->findAll();
  1786.         return $this->render('MDS/AvexpressBundle/Avexpress/list-productsfile-locationnames.html.twig',
  1787.             array(
  1788.                 'productsLocation' => $productsLocation,
  1789.             ));
  1790.     }
  1793.     /**
  1794.      * @Route("/productfilelocationedit/{id}",  name="ave_edit_productfilelocation")
  1795.      * Editar una Ubicacion
  1796.      */
  1797.     public function editProductFileLocationAction( $id, Request $request)
  1798.     {
  1799.         $em = $this->getDoctrine()->getManager();
  1800.         $editProductLocation = $em->getRepository(AveProductFileLocationNames::class)->findOneById($id);
  1802.         return $this->render('MDS/AvexpressBundle/Avexpress/edit-productsfiles-location.html.twig',
  1803.             array(
  1804.                 'id' => $editProductLocation->getId(),
  1805.                 'productLocation' => $editProductLocation,
  1806.             ));
  1807.     }
  1810.     /**
  1811.      * @Route("/productfilelocationupdate/",  name="ave_update_productfilelocation")
  1812.      * Update de una Ubicacion
  1813.      */
  1814.     public function updateProductFileLocationAction(Request $request)
  1815.     {
  1816.         $em = $this->getDoctrine()->getManager();
  1817.         $newRequest = $request->request->get('product');
  1818.         $id = $newRequest['id'];
  1819.         $newProduct = $em->getRepository(AveProductFileLocationNames::class)->findOneById($id);
  1821.         /* Obtengo usuario logueado */
  1822.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1823.         $user_id = $user_logueado->getId();
  1825.         if (!empty($newRequest['name'])){$newProduct->setName($newRequest['name']);}
  1827.         $newProduct->setDescription($newRequest['description']);
  1829.         $newProduct->setUpdatedId($user_id);
  1830.         $newProduct->setUpdatedAt(new \DateTime("now"));
  1832.         $em->persist($newProduct);
  1833.         $em->flush();
  1835.         return $this->redirectToRoute('ave_list_productfilelocation');
  1836.     }
  1839.     /**
  1840.      * @Route("/productfilelocationdelete/{id}",  name="ave_delete_productfilelocation")
  1841.      * Eliminar una Ubicacion
  1842.      */
  1843.     public function deleteProductAction($id, Request $request)
  1844.     {
  1845.         $em = $this->getDoctrine()->getManager();
  1846.         $delProduct = $em->getRepository(AveProductFileLocationNames::class)->findOneById($id);
  1848.         if (!empty($delProduct)){
  1849.             $em->remove($delProduct);
  1850.             $em->flush();
  1851.         }
  1853.         return $this->redirectToRoute('ave_list_productfilelocation');
  1854.     }
  1859.     // Replicar cambios entre FileController y ProductsFilesController
  1860.     private function calculosFile($id, $arrayBools, $number, $type)
  1861.     {
  1862.         // $id Id del Expediente (File)
  1863.         // $arrayBool arreglo de logicos
  1864.         // $number  *********************
  1865.         // $type tipo de calculos a realizar (edicion de expediente, factura, factura de deposito, proforma)
  1866.         
  1867.         
  1868.         $em = $this->getDoctrine()->getManager();
  1869.         $file = $em->getRepository(AveFiles::class)->findOneById($id);
  1870.         $items = $em->getRepository(AveProductFile::class)->findByFileId($file->getId());
  1871.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('3');
  1872.         $client = $em->getRepository(Client::class)->findById($file->getClient());
  1873.         if (!empty($client)){
  1874.             $city = ($em->getRepository(Cities::class)->findOneById($client[0]->getPopulation()));
  1875.             $client[0]->setPopulation($city);
  1876.             $region = ($em->getRepository(Regions::class)->findOneById($client[0]->getRegion()));
  1877.             $client[0]->setRegion($region);
  1878.             $country = ($em->getRepository(Country::class)->findOneById($client[0]->getCountry()));
  1879.             $client[0]->setCountry($country);
  1880.         } else {
  1881.             $client[0] = new Client();
  1882.             $client[0]->setName('');
  1883.             $client[0]->setTitle('');
  1884.             $client[0]->setIdDocument('');
  1885.             $client[0]->setPopulation('');
  1886.             $client[0]->setRegion('');
  1887.             $client[0]->setCountry('');
  1888.         }
  1890.         // Acumuladores de los calculos
  1891.         $totales_neto_all = 0;
  1892.         $data_iva = array(
  1893.             'iva' => 21,
  1894.             'ivaMontoVeintiUno' => 0,
  1895.             'ivaMontoDiez' => 0,
  1896.             'ivaMontoCero' => 0,
  1897.         );
  1899.         //INICIO: Determinamos el numero de factura o proforma
  1900.         if (substr($number,0,1) == 'I'){
  1901.             // Es una Factura
  1903.             $numberInvoiceOrProforma = substr($number,1);
  1904.             $number = $numberInvoiceOrProforma;
  1905.             $type = 'Invoice';
  1907.         } else {
  1908.             // Es una Proforma
  1910.             $numberInvoiceOrProforma = substr($number,1);
  1911.             $number = $numberInvoiceOrProforma;
  1912.             $type = 'Proforma';
  1913.         }
  1914.         //FIN: Determinamos el numero de factura o proforma
  1916.         // Buscamos las salas reservadas, pagos y servicios para el evento
  1918.         $arrayItems = array();
  1919.         $fileProducts = array();
  1920.         if (!empty($arrayBools['lounge'])) {
  1921.             foreach ($arrayBools['lounge'] as $key => $item) {
  1922.                 if ($item == 'true') {
  1923. //                    $fileProducts[] = $em->getRepository('DevelupBundle:ReservationLoungeSimple')->findOneById($key);
  1924.                 }
  1925.             }
  1926.         }
  1928.         $payments = array();
  1929.         if (!empty($arrayBools['payment'])) {
  1930.             foreach ($arrayBools['payment'] as $key => $item) {
  1931.                 if ($item == 'true') {
  1932. //                    $payments[] = $em->getRepository('DevelupBundle:ReservationPaymentsClient')->findOneById($key);
  1933.                 }
  1934.             }
  1935.         }
  1937.         $services = array();
  1938.         if (!empty($arrayBools['service'])) {
  1939.             foreach ($arrayBools['service'] as $key => $item) {
  1940.                 if ($item == 'true') {
  1941. //                    $services[] = $em->getRepository('DevelupBundle:ReservationService')->findOneById($key);
  1942.                 }
  1943.             }
  1944.         }
  1946.         $data_supplier = array();
  1947.         $i = 0;
  1949.         $iva = '21';            // Esteban Rincon: "Por Ley de localización del impuesto, siempre será un 21%"
  1950.         $pax = '-';
  1951.         $qty = '1';
  1952.         $product = array(
  1953.             'neto' => 0,
  1954.             'sumSubT' => 0,
  1955.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1957.         $service = array(
  1958.             'neto' => 0,
  1959.             'sumSubT' => 0,
  1960.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1962.         if (empty($items)){
  1963.             $data_supplier['product'][0] = null;
  1964.         }
  1966.         foreach ($items as $item){
  1968.             if (is_null($item->getServicePrice()) or empty($item->getServicePrice())){
  1969.                 $subtotal = 0;
  1970.                 $neto = 0;
  1971.                 $subtotalProduct = 0;
  1972.             } else {
  1974.                 $subtotalProduct = $item->getServicePrice() * 1.21;
  1975.                 $subneto = $item->getServicePrice();
  1977.                 $subtotal =  $subtotalProduct;
  1978.                 $neto =  $subneto;
  1980.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  1981.                 $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  1982.                 $neto = round($neto,2,PHP_ROUND_HALF_UP);
  1984.                 $arrayItems[] = array(
  1985.                     'type' => 'Product',
  1986.                     'name' => $item->getProductName(),
  1987.                     'amount' => $neto,
  1988.                     'iva' => '21',
  1989.                     'total' => $subtotal,
  1990.                 );
  1991.             }
  1993.             // Acumula netos totales e IVA
  1994.             $totales_neto_all = $totales_neto_all + $neto;
  1995.             $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * 0.21);
  1996.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1997.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  1998.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  1999.             // Acumula netos totales e IVA
  2001.             $product['neto'] = $product['neto'] + $neto;
  2002.             $product['sumSubT'] = $product['sumSubT'] + $subtotal;
  2003.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2004.             $product['neto'] = round($product['neto'],2,PHP_ROUND_HALF_UP);
  2005.             $product['sumSubT'] = round($product['sumSubT'],2,PHP_ROUND_HALF_UP);
  2007.             $data_supplier['product'][$i] = array (
  2008.                 'id' => $item->getId(),
  2009.                 'productName' => $item->getProductName(),
  2010.                 'description' => $item->getDescription(),
  2011.                 'productId' => $item->getProductId(),
  2012.                 'dateStart' => $item->getDateStart(),
  2013.                 'dateEnd' => $item->getDateEnd(),
  2014.                 'servicePrice' => $item->getServicePrice(),
  2015.                 'subtotalProduct' => $subtotalProduct,
  2016.                 'iva' => $iva,
  2017.                 'pax' => $pax,
  2018.                 'qty' => $qty,
  2019.                 'type' => $item->getType(),
  2020.                 'subtotal' => $subtotal,
  2021.             );
  2022.             $i++;
  2023.         }
  2025.         $data_supplier['productSubTotal'] = array(
  2026.             'neto' => $product['neto'],
  2027.             'sumSubT' => $product['sumSubT'],
  2028.         );
  2030.         $payment = array(
  2031.             'sumSubT' => 0,
  2032.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  2034.         $i = 0;
  2035.         foreach ($payments as $item){
  2037.             $payment['sumSubT'] = $payment['sumSubT'] + $item->getAmountTotal();
  2038.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2039.             $payment['sumSubT'] = round($payment['sumSubT'],2,PHP_ROUND_HALF_UP);
  2041.             $data_supplier['payment'][$i] = array (
  2042.                 'id' => $item->getId(),
  2043.                 'amount' => $item->getAmount(),
  2044.                 'amountTotal' => $item->getAmountTotal(),
  2045.                 'vat' => $item->getVat(),
  2046.                 'datePayAt' => $item->getDatePayAt(),
  2047.                 'wayToPay' => $item->getWayToPay(),
  2048.             );
  2050.             $arrayItems[] = array(
  2051.                 'type' => 'Payment',
  2052.                 'name' => $item->getWayToPay(),
  2053.                 'amount' => $item->getAmount(),
  2054.                 'total' => $item->getAmountTotal(),
  2055.                 'iva' => $item->getVat(),
  2056.             );
  2058.             $i++;
  2059.         }
  2061.         if (!empty($payments)) {
  2062.             $data_supplier['paymentSubTotal'] = array(
  2063.                 'sumSubT' => $payment['sumSubT'],
  2064.             );
  2065.         }
  2067.         foreach ($services as $item){
  2068.             if (is_null($item->getPrice()) or empty($item->getPrice())){
  2069.                 $subtotal = 0;
  2070.                 $neto = 0;
  2071.                 $subtotalService = 0;
  2073.             } else {
  2074.                 $subtotalService = $item->getPrice();
  2075.                 $subneto = $item->getPrice();
  2077.                 // Commission
  2078.                 if ($item->getOpCommission()=='1'){
  2079.                     $subtotalService = $subtotalService * (1 + ($item->getCommission()/100));
  2080.                     $subneto = $subneto  * (1 + ($item->getCommission()/100));
  2081.                 } else {
  2082.                     $subtotalService = $subtotalService * (1 - ($item->getCommission()/100));
  2083.                     $subneto = $subneto * (1 - ($item->getCommission()/100));
  2084.                 }
  2086.                 // Over
  2087.                 if ($item->getOpOver()=='1'){
  2088.                     $subtotalService = $subtotalService + $item->getOver();
  2089.                     $subneto = $subneto + $item->getOver();
  2090.                 } else {
  2091.                     $subtotalService = $subtotalService - $item->getOver();
  2092.                     $subneto = $subneto - $item->getOver();
  2093.                 }
  2095.                 // IVA
  2096.                 if ($item->getOpIva()=='1'){
  2097.                     $subtotalService = $subtotalService * (1 + ($item->getIva()/100));
  2098.                 } else {
  2099.                     $subtotalService = $item->getPrice();
  2100.                     $subneto = ($subneto * 100) / (100 + $item->getIva());
  2101.                 }
  2103.                 switch ($item->getServiceCatId()){
  2104.                     case 1: // Alojamiento
  2105.                         // el numero de noches $numNoches; precio unitario $subneto
  2106.                         $numNoches = (($item->getDateOutAt())->diff($item->getDateInAt()))->days;
  2107.                         // La personas no afectan este calculo
  2108.                         $subtotal = $subtotalService * $numNoches * $item->getUnits();
  2109.                         $subnetoUnit = $subneto;
  2111.                         $subneto = $subneto * $numNoches * $item->getUnits();
  2113.                         $data_supplier['service'][$i] = array (
  2114.                             'id' => $item->getId(),
  2115.                             'serviceCatId' => $item->getServiceCatId(),
  2116.                             'serviceName' => $item->getName(),
  2117.                             'serviceType' => 'Hotel',
  2118.                             'date' => ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y'),
  2119.                             'qty' => $item->getUnits(),
  2120.                             'iva' => $item->getIva(),
  2121.                             'pax' => '-',
  2122.                             'precioUnit' => $subnetoUnit,
  2123.                             'subneto' => $subneto,
  2124.                             'subtotal' => $subtotal,
  2125.                         );
  2126.                         break;
  2128.                     case 2: //Actividades
  2129.                         // El número de personas es considerado en el calculo
  2130.                         $pax = $item->getPax();
  2131.                         if (empty($pax) or $pax == "0") {
  2132.                             $pax = 1;
  2133.                         }
  2134.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2136.                         if ($days > 1){
  2137.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2138.                         } else {
  2139.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2140.                         }
  2142.                         $subtotal = $subtotalService * $days * $item->getUnits();
  2143.                         $subnetoUnit = $subneto;
  2144.                         $subneto = $subneto * $days * $item->getUnits();
  2146.                         $data_supplier['service'][$i] = array (
  2147.                             'id' => $item->getId(),
  2148.                             'serviceCatId' => $item->getServiceCatId(),
  2149.                             'serviceName' => $item->getName(),
  2150.                             'serviceType' => 'Actividad',
  2151.                             'date' => $dateServ,
  2152.                             'qty' => $item->getUnits(),
  2153.                             'iva' => $item->getIva(),
  2154.                             'pax' => $item->getPax(),
  2155.                             'precioUnit' => $subnetoUnit,
  2156.                             'subneto' => $subneto,
  2157.                             'subtotal' => $subtotal,
  2158.                         );
  2159.                         break;
  2161.                     case 3: // AV
  2162.                         $pax = $item->getPax();
  2163.                         if (empty($pax) or $pax == "0") {
  2164.                             $pax = 1;
  2165.                         }
  2167.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2168.                         if ($days > 1){
  2169.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2170.                         } else {
  2171.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2172.                         }
  2174.                         $unitsServ = $item->getUnits();
  2175.                         if (empty($unitsServ) or $unitsServ == "0") {
  2176.                             $unitsServ = 1;
  2177.                         }
  2179.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2180.                         $subnetoUnit = $subneto;
  2181.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2183.                         $data_supplier['service'][$i] = array (
  2184.                             'id' => $item->getId(),
  2185.                             'serviceCatId' => $item->getServiceCatId(),
  2186.                             'serviceName' => $item->getName(),
  2187.                             'serviceType' => 'AV',
  2188.                             'date' => $dateServ,
  2189.                             'qty' => $unitsServ,
  2190.                             'iva' => $item->getIva(),
  2191.                             'pax' => $item->getPax(),
  2192.                             'precioUnit' => $subnetoUnit,
  2193.                             'subneto' => $subneto,
  2194.                             'subtotal' => $subtotal,
  2195.                         );
  2196.                         break;
  2198.                     case 4: //Creative
  2199.                         $pax = $item->getPax();
  2200.                         if (empty($pax) or $pax == "0") {
  2201.                             $pax = 1;
  2202.                         }
  2204.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2205.                         if ($days > 1){
  2206.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2207.                         } else {
  2208.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2209.                         }
  2211.                         $unitsServ = $item->getUnits();
  2212.                         if (empty($unitsServ) or $unitsServ == "0") {
  2213.                             $unitsServ = 1;
  2214.                         }
  2216.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2217.                         $subnetoUnit = $subneto;
  2218.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2220.                         $data_supplier['service'][$i] = array (
  2221.                             'id' => $item->getId(),
  2222.                             'serviceCatId' => $item->getServiceCatId(),
  2223.                             'serviceName' => $item->getName(),
  2224.                             'serviceType' => 'Creativo',
  2225.                             'date' => $dateServ,
  2226.                             'qty' => $unitsServ,
  2227.                             'iva' => $item->getIva(),
  2228.                             'pax' => $item->getPax(),
  2229.                             'precioUnit' => $subnetoUnit,
  2230.                             'subneto' => $subneto,
  2231.                             'subtotal' => $subtotal,
  2232.                         );
  2233.                         break;
  2235.                     case 5: //Cruise
  2236.                         $pax = $item->getPax();
  2237.                         if (empty($pax) or $pax == "0") {
  2238.                             $pax = 1;
  2239.                         }
  2241.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days);
  2242.                         if ($days > 1){
  2243.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2244.                         } else {
  2245.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2246.                         }
  2248.                         $unitsServ = $item->getUnits();
  2249.                         if (empty($unitsServ) or $unitsServ == "0") {
  2250.                             $unitsServ = 1;
  2251.                         }
  2253.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2254.                         $subnetoUnit = $subneto;
  2255.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2257.                         $data_supplier['service'][$i] = array (
  2258.                             'id' => $item->getId(),
  2259.                             'serviceCatId' => $item->getServiceCatId(),
  2260.                             'serviceName' => $item->getName(),
  2261.                             'serviceType' => 'Crucero',
  2262.                             'date' => $dateServ,
  2263.                             'qty' => $unitsServ,
  2264.                             'iva' => $item->getIva(),
  2265.                             'pax' => $item->getPax(),
  2266.                             'precioUnit' => $subnetoUnit,
  2267.                             'subneto' => $subneto,
  2268.                             'subtotal' => $subtotal,
  2269.                         );
  2270.                         break;
  2272.                     case 6: //Entertaiment
  2273.                         $pax = $item->getPax();
  2274.                         if (empty($pax) or $pax == "0") {
  2275.                             $pax = 1;
  2276.                         }
  2278.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2279.                         if ($days > 1){
  2280.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2281.                         } else {
  2282.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2283.                         }
  2285.                         $unitsServ = $item->getUnits();
  2286.                         if (empty($unitsServ) or $unitsServ == "0") {
  2287.                             $unitsServ = 1;
  2288.                         }
  2290.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2291.                         $subnetoUnit = $subneto;
  2292.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2294.                         $data_supplier['service'][$i] = array (
  2295.                             'id' => $item->getId(),
  2296.                             'serviceCatId' => $item->getServiceCatId(),
  2297.                             'serviceName' => $item->getName(),
  2298.                             'serviceType' => 'Entretenimiento',
  2299.                             'date' => $dateServ,
  2300.                             'qty' => $unitsServ,
  2301.                             'iva' => $item->getIva(),
  2302.                             'pax' => $item->getPax(),
  2303.                             'precioUnit' => $subnetoUnit,
  2304.                             'subneto' => $subneto,
  2305.                             'subtotal' => $subtotal,
  2306.                         );
  2307.                         break;
  2309.                     case 7: // Gifts
  2310.                         $pax = $item->getPax();
  2311.                         if (empty($pax) or $pax == "0") {
  2312.                             $pax = 1;
  2313.                         }
  2315. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2316.                         $days = 1;
  2317.                         if ($days > 1){
  2318.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2319.                         } else {
  2320.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2321.                         }
  2323.                         $unitsServ = $item->getUnits();
  2324.                         if (empty($unitsServ) or $unitsServ == "0") {
  2325.                             $unitsServ = 1;
  2326.                         }
  2328.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2329.                         $subnetoUnit = $subneto;
  2330.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2332.                         $data_supplier['service'][$i] = array (
  2333.                             'id' => $item->getId(),
  2334.                             'serviceCatId' => $item->getServiceCatId(),
  2335.                             'serviceName' => $item->getName(),
  2336.                             'serviceType' => 'Regalos',
  2337.                             'date' => $dateServ,
  2338.                             'qty' => $unitsServ,
  2339.                             'iva' => $item->getIva(),
  2340.                             'pax' => $item->getPax(),
  2341.                             'precioUnit' => $subnetoUnit,
  2342.                             'subneto' => $subneto,
  2343.                             'subtotal' => $subtotal,
  2344.                         );
  2345.                         break;
  2347.                     case 8: //Guide
  2348.                         $pax = $item->getPax();
  2349.                         if (empty($pax) or $pax == "0") {
  2350.                             $pax = 1;
  2351.                         }
  2353.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2354.                         if ($days > 1){
  2355.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2356.                         } else {
  2357.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2358.                         }
  2360.                         $unitsServ = $item->getUnits();
  2361.                         if (empty($unitsServ) or $unitsServ == "0") {
  2362.                             $unitsServ = 1;
  2363.                         }
  2365.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2366.                         $subnetoUnit = $subneto;
  2367.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2369.                         $data_supplier['service'][$i] = array (
  2370.                             'id' => $item->getId(),
  2371.                             'serviceCatId' => $item->getServiceCatId(),
  2372.                             'serviceName' => $item->getName(),
  2373.                             'serviceType' => 'Regalos',
  2374.                             'date' => $dateServ,
  2375.                             'qty' => $unitsServ,
  2376.                             'iva' => $item->getIva(),
  2377.                             'pax' => $item->getPax(),
  2378.                             'precioUnit' => $subnetoUnit,
  2379.                             'subneto' => $subneto,
  2380.                             'subtotal' => $subtotal,
  2381.                         );
  2382.                         break;
  2384.                     case 9: //Itineraries
  2385.                         $pax = $item->getPax();
  2386.                         if (empty($pax) or $pax == "0") {
  2387.                             $pax = 1;
  2388.                         }
  2390.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2391.                         if ($days > 1){
  2392.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2393.                         } else {
  2394.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2395.                         }
  2397.                         $unitsServ = $item->getUnits();
  2398.                         if (empty($unitsServ) or $unitsServ == "0") {
  2399.                             $unitsServ = 1;
  2400.                         }
  2402.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2403.                         $subnetoUnit = $subneto;
  2404.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2406.                         $data_supplier['service'][$i] = array (
  2407.                             'id' => $item->getId(),
  2408.                             'serviceCatId' => $item->getServiceCatId(),
  2409.                             'serviceName' => $item->getName(),
  2410.                             'serviceType' => 'Itinerarios',
  2411.                             'date' => $dateServ,
  2412.                             'qty' => $unitsServ,
  2413.                             'iva' => $item->getIva(),
  2414.                             'pax' => $item->getPax(),
  2415.                             'precioUnit' => $subnetoUnit,
  2416.                             'subneto' => $subneto,
  2417.                             'subtotal' => $subtotal,
  2418.                         );
  2419.                         break;
  2421.                     case 10: //Lounge  -- No Aplica
  2422. //                        $pax = $item->getPax();
  2423. //                        if (empty($pax) or $pax == "0") {
  2424. //                            $pax = 1;
  2425. //                        }
  2426. //
  2427. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2428. //                        if ($days > 1){
  2429. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2430. //                        } else {
  2431. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2432. //                        }
  2433. //
  2434. //                        $unitsServ = $item->getUnits();
  2435. //                        if (empty($unitsServ) or $unitsServ == "0") {
  2436. //                            $unitsServ = 1;
  2437. //                        }
  2438. //
  2439. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2440. //                        $subnetoUnit = $subneto;
  2441. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  2442. //
  2443. //                        $data_supplier['service'][$i] = array (
  2444. //                            'id' => $item->getId(),
  2445. //                            'serviceCatId' => $item->getServiceCatId(),
  2446. //                            'serviceName' => $item->getName(),
  2447. //                            'serviceType' => 'Itinerarios',
  2448. //                            'date' => $dateServ,
  2449. //                            'qty' => $unitsServ,
  2450. //                            'iva' => $item->getIva(),
  2451. //                            'pax' => $item->getPax(),
  2452. //                            'precioUnit' => $subnetoUnit,
  2453. //                            'subneto' => $subneto,
  2454. //                            'subtotal' => $subtotal,
  2455. //                        );
  2456.                         break;
  2458.                     case 11: //Menu
  2459.                         $pax = $item->getPax();
  2460.                         if (empty($pax) or $pax == "0") {
  2461.                             $pax = 1;
  2462.                         }
  2464.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2465.                         if ($days > 1){
  2466.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2467.                         } else {
  2468.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2469.                         }
  2471.                         $unitsServ = $item->getUnits();
  2472.                         if (empty($unitsServ) or $unitsServ == "0") {
  2473.                             $unitsServ = 1;
  2474.                         }
  2476.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2477.                         $subnetoUnit = $subneto;
  2478.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2480.                         $data_supplier['service'][$i] = array (
  2481.                             'id' => $item->getId(),
  2482.                             'serviceCatId' => $item->getServiceCatId(),
  2483.                             'serviceName' => $item->getName(),
  2484.                             'serviceType' => 'Menú',
  2485.                             'date' => $dateServ,
  2486.                             'qty' => $unitsServ,
  2487.                             'iva' => $item->getIva(),
  2488.                             'pax' => $item->getPax(),
  2489.                             'precioUnit' => $subnetoUnit,
  2490.                             'subneto' => $subneto,
  2491.                             'subtotal' => $subtotal,
  2492.                         );
  2493.                         break;
  2495.                     case 12: //Others
  2496.                         $pax = $item->getPax();
  2497.                         if (empty($pax) or $pax == "0") {
  2498.                             $pax = 1;
  2499.                         }
  2501.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2502.                         if ($days > 1){
  2503.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2504.                         } else {
  2505.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2506.                         }
  2508.                         $unitsServ = $item->getUnits();
  2509.                         if (empty($unitsServ) or $unitsServ == "0") {
  2510.                             $unitsServ = 1;
  2511.                         }
  2513.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2514.                         $subnetoUnit = $subneto;
  2515.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2517.                         $data_supplier['service'][$i] = array (
  2518.                             'id' => $item->getId(),
  2519.                             'serviceCatId' => $item->getServiceCatId(),
  2520.                             'serviceName' => $item->getName(),
  2521.                             'serviceType' => 'Otros',
  2522.                             'date' => $dateServ,
  2523.                             'qty' => $unitsServ,
  2524.                             'iva' => $item->getIva(),
  2525.                             'pax' => $item->getPax(),
  2526.                             'precioUnit' => $subnetoUnit,
  2527.                             'subneto' => $subneto,
  2528.                             'subtotal' => $subtotal,
  2529.                         );
  2530.                         break;
  2532.                     case 13: //Transport
  2533.                         $pax = $item->getPax();
  2534.                         if (empty($pax) or $pax == "0") {
  2535.                             $pax = 1;
  2536.                         }
  2538.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2539.                         if ($days > 1){
  2540.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2541.                         } else {
  2542.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2543.                         }
  2545.                         $unitsServ = $item->getUnits();
  2546.                         if (empty($unitsServ) or $unitsServ == "0") {
  2547.                             $unitsServ = 1;
  2548.                         }
  2550.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2551.                         $subnetoUnit = $subneto;
  2552.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2554.                         $data_supplier['service'][$i] = array (
  2555.                             'id' => $item->getId(),
  2556.                             'serviceCatId' => $item->getServiceCatId(),
  2557.                             'serviceName' => $item->getName(),
  2558.                             'serviceType' => 'Transporte',
  2559.                             'date' => $dateServ,
  2560.                             'qty' => $unitsServ,
  2561.                             'iva' => $item->getIva(),
  2562.                             'pax' => $item->getPax(),
  2563.                             'precioUnit' => $subnetoUnit,
  2564.                             'subneto' => $subneto,
  2565.                             'subtotal' => $subtotal,
  2566.                         );
  2567.                         break;
  2569.                     case 14: //Technology
  2570.                         $pax = $item->getPax();
  2571.                         if (empty($pax) or $pax == "0") {
  2572.                             $pax = 1;
  2573.                         }
  2575. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2576.                         $days = 1;
  2577. //                        if ($days > 1){
  2578. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2579. //                        } else {
  2580. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2581. //                        }
  2582.                         $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2584.                         $unitsServ = $item->getUnits();
  2585.                         if (empty($unitsServ) or $unitsServ == "0") {
  2586.                             $unitsServ = 1;
  2587.                         }
  2589.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2590.                         $subnetoUnit = $subneto;
  2591.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2593.                         $data_supplier['service'][$i] = array (
  2594.                             'id' => $item->getId(),
  2595.                             'serviceCatId' => $item->getServiceCatId(),
  2596.                             'serviceName' => $item->getName(),
  2597.                             'serviceType' => 'Tecnología',
  2598.                             'date' => $dateServ,
  2599.                             'qty' => $unitsServ,
  2600.                             'iva' => $item->getIva(),
  2601.                             'pax' => $item->getPax(),
  2602.                             'precioUnit' => $subnetoUnit,
  2603.                             'subneto' => $subneto,
  2604.                             'subtotal' => $subtotal,
  2605.                         );
  2606.                         break;
  2608.                     case 15: //Assisstant
  2609.                         $pax = $item->getPax();
  2610.                         if (empty($pax) or $pax == "0") {
  2611.                             $pax = 1;
  2612.                         }
  2614.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2615.                         if ($days > 1){
  2616.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2617.                         } else {
  2618.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2619.                         }
  2621.                         $unitsServ = $item->getUnits();
  2622.                         if (empty($unitsServ) or $unitsServ == "0") {
  2623.                             $unitsServ = 1;
  2624.                         }
  2626.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2627.                         $subnetoUnit = $subneto;
  2628.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2630.                         $data_supplier['service'][$i] = array (
  2631.                             'id' => $item->getId(),
  2632.                             'serviceCatId' => $item->getServiceCatId(),
  2633.                             'serviceName' => $item->getName(),
  2634.                             'serviceType' => 'Asistente',
  2635.                             'date' => $dateServ,
  2636.                             'qty' => $unitsServ,
  2637.                             'iva' => $item->getIva(),
  2638.                             'pax' => $item->getPax(),
  2639.                             'precioUnit' => $subnetoUnit,
  2640.                             'subneto' => $subneto,
  2641.                             'subtotal' => $subtotal,
  2642.                         );
  2643.                         break;
  2645.                     case 16: //DDR
  2646.                         $pax = $item->getPax();
  2647.                         if (empty($pax) or $pax == "0") {
  2648.                             $pax = 1;
  2649.                         }
  2651.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2652.                         if ($days > 1){
  2653.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2654.                         } else {
  2655.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2656.                         }
  2658.                         $unitsServ = $item->getUnits();
  2659.                         if (empty($unitsServ) or $unitsServ == "0") {
  2660.                             $unitsServ = 1;
  2661.                         }
  2663.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2664.                         $subnetoUnit = $subneto;
  2665.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2667.                         $data_supplier['service'][$i] = array (
  2668.                             'id' => $item->getId(),
  2669.                             'serviceCatId' => $item->getServiceCatId(),
  2670.                             'serviceName' => $item->getName(),
  2671.                             'serviceType' => 'DDR',
  2672.                             'date' => $dateServ,
  2673.                             'qty' => $unitsServ,
  2674.                             'iva' => $item->getIva(),
  2675.                             'pax' => $item->getPax(),
  2676.                             'precioUnit' => $subnetoUnit,
  2677.                             'subneto' => $subneto,
  2678.                             'subtotal' => $subtotal,
  2679.                         );
  2680.                         break;
  2682.                     default:
  2683.                         break;
  2684.                 }
  2686.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  2687.                 $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  2688.                 $neto = round($subneto,2,PHP_ROUND_HALF_UP);
  2690.                 $arrayItems[] = array(
  2691.                     'type' => 'Service',
  2692.                     'name' => $item->getName(),
  2693.                     'amount' => $neto,
  2694.                     'iva' => $item->getIva(),
  2695.                     'total' => $subtotal,
  2696.                 );
  2698.             }
  2700.             switch ($item->getIva()){
  2701.                 // Acumula IVA
  2702.                 case 21:
  2703.                     $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getIva()/100));
  2704.                     break;
  2706.                 case 10:
  2707.                     $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getIva()/100));
  2708.                     break;
  2710.                 case 0:
  2711.                     break;
  2713.                 default:
  2714.                     break;
  2716.             }
  2718.             $totales_neto_all = $totales_neto_all + $neto;
  2720.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2721.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  2722.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  2723.             $data_iva['ivaMontoDiez'] = round($data_iva['ivaMontoDiez'],2,PHP_ROUND_HALF_UP);
  2724.             // Acumula netos totales e IVA
  2726.             $service['neto'] = $service['neto'] + $neto;
  2727.             $service['sumSubT'] = $service['sumSubT'] + $subtotal;
  2728.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2729.             $service['neto'] = round($service['neto'],2,PHP_ROUND_HALF_UP);
  2730.             $service['sumSubT'] = round($service['sumSubT'],2,PHP_ROUND_HALF_UP);
  2732.             $i++;
  2733.         }
  2735.         $data_supplier['serviceSubTotal'] = array(
  2736.             'neto' => $service['neto'],
  2737.             'sumSubT' => $service['sumSubT'],
  2738.         );
  2739.         $currency = '€';
  2740.         $totales_total = $totales_neto_all + $data_iva['ivaMontoVeintiUno'] + $data_iva['ivaMontoDiez'];
  2741.         if (!empty($payments)) {
  2742.             $amount_pay = $data_supplier['paymentSubTotal']['sumSubT'];
  2743.         } else {
  2744.             $amount_pay = 0;
  2745.         }
  2746.         $totales_all = $totales_total - $amount_pay;
  2748.         if ($type == 'Invoice'){
  2749.             $em->clear();   // sin este clear se producia error al guardar
  2750.             $newInvoice = $em->getRepository(ReservationInvoice::class)->findOneById($numberInvoiceOrProforma);
  2751.             $newInvoice->setBalance($totales_all);
  2752.             $em->persist($newInvoice);
  2753.             $em->flush();
  2754.         }
  2756.         $data = array(
  2757.             'id' => $id,
  2758.             'type' => $type,
  2759.             'number' => $number,
  2760.             'prefix' => 'GPF-'.(new DateTime('now'))->format('dmy').'-',
  2761.             'date' => new DateTime('now'),
  2762.             'file' => $file,
  2763. //            'token' => $reservation->getAccessKey(),
  2764.             'company' => $company,
  2765.             'clients' => $client,
  2766.             'arrayItems' => $arrayItems,
  2767.             'datasupplier' => $data_supplier,
  2768.             'currency' => $currency,
  2769.             'totales_neto' => $totales_neto_all,
  2770.             'bases_imponibles' => $data_iva,
  2771.             'totales' => $totales_total,
  2772.             'balance' => $totales_all,
  2773.             'paymentInvoice' => $amount_pay,
  2774.         );
  2776.         return $data;
  2777.     }
  2779.     private function obtenerRankAv($id)
  2780.     {
  2781.         // $id Id del Expediente (File)
  2782.         $em = $this->getDoctrine()->getManager();
  2783.         $items = $em->getRepository(AveProductFile::class)->findByFileId($id);
  2785.         if (empty($items)){ $num = 1; } else { $num = sizeof($items) + 1; }
  2786.         $data = $num;
  2788.         return $data;
  2789.     }
  2791.     private function obtenerFechas($id, $dateStart, $dateEnd)
  2792.     {
  2793.         // $id Id del Expediente (File)
  2794.         // $dateStart Fecha de inicio (Producto)
  2795.         // $dateEnd Fecha de fin (Producto)
  2797.         $em = $this->getDoctrine()->getManager();
  2798.         $file = $em->getRepository(AveFiles::class)->findOneById($id);
  2800.         if (empty($dateStart)){ $newDateStart = $file->getDateStart(); } else { $newDateStart = $dateStart; }
  2801.         if (empty($dateEnd)){ $newDateEnd = $file->getDateEnd(); } else { $newDateEnd = $dateEnd; }
  2803.         $data = array(
  2804.             'dateStart' => $newDateStart,
  2805.             'dateEnd' => $newDateEnd,
  2806.         );
  2808.         return $data;
  2809.     }
  2811.     private function sendTelegram( $id, $text )
  2812.     {
  2813.         $em = $this->getDoctrine()->getManager();
  2814.         $telegUser = $em->getRepository(MdvTelegramUser::class)->findOneByUserId($id);
  2816.         if (empty($telegUser)){return true;}
  2818.         $parameters = array(
  2819.             'chat_id' => $telegUser->getChatId(),
  2820.             'text' => $text,
  2821.         );
  2823.         $bot_token = $telegUser->getBotToken();
  2824.         $url = "https://api.telegram.org/bot$bot_token/sendMessage";
  2826.         if (!$curl = curl_init()){
  2827.             exit();
  2828.         }
  2830.         curl_setopt($curl,CURLOPT_POST,true);
  2831.         curl_setopt($curl,CURLOPT_POSTFIELDS,$parameters);
  2832.         curl_setopt($curl,CURLOPT_URL,$url);
  2833.         curl_setopt($curl,CURLOPT_RETURNTRANSFER,true);
  2834.         $output = curl_exec($curl);
  2835.         curl_close($curl);
  2837.         return true;
  2838.     }
  2840.     private function addProductFileToProforma( $fileId, $newProductId, $proformaId )
  2841.     {
  2842.         $em = $this->getDoctrine()->getManager();
  2843.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  2844.         $productFile = $em->getRepository(AveProductFile::class)->findOneById($newProductId);
  2845.         $proforma = $em->getRepository(AveDocProforma::class)->findOneById($proformaId);
  2847.         if (!empty($file) and !empty($productFile) and !empty($proforma) ){
  2848.             $newProformaItem = new AveDocProformaItems();
  2849.             $newProformaItem->setControlId($newProductId);
  2850.             $newProformaItem->setType('PRODUCT');
  2851.             $newProformaItem->setFileId($fileId);
  2852.             $newProformaItem->setProformaId($proformaId);
  2854.             $em->persist($newProformaItem);
  2855.             $em->flush();
  2857.             return true;
  2858.         } else {
  2859.             return false;
  2860.         }
  2861.     }
  2863.     private function precioPorVariacionDeDias ($supplierService, $productFile){
  2864.         $em = $this->getDoctrine()->getManager();
  2866.         // El precio unitario debe ser dividido en funcion de los dias que tiene InOut y no en funcion de los dias de Av Express
  2867.         $days = ($supplierService->getDateOutAt()->diff($supplierService->getDateInAt())->days)===0 ? 1 : $supplierService->getDateOutAt()->diff($supplierService->getDateInAt())->days +1;
  2868.         if (array_key_exists('productFileId',$productFile)){
  2869.             // En el GridTwo viene es un arreglo no la entidad
  2870.             $productInFile = $em->getRepository(AveProductFile::class)->findOneById($productFile['productFileId']);
  2871.             $newPrice = $productInFile->getSubTotalPrice() / ( $days );
  2872.         } else {
  2873.             $newPrice = $productFile->getSubTotalPrice() / ( $days );
  2874.         }
  2876.         $newPrice = $newPrice / $supplierService->getUnits();
  2877.         $newPrice = round($newPrice,2,PHP_ROUND_HALF_UP);
  2879.         return $newPrice;
  2880.     }
  2882.     private function messageOfChangesToAgent($message, $proposalId){
  2883.         // $message mensaje a enviar a los agentes del proposal
  2884.         if ($proposalId  == 0){ return true; }
  2885.         $em = $this->getDoctrine()->getManager();
  2886.         $proposal = $em->getRepository(Proposal::class)->findOneById($proposalId);
  2888.         /* Obtengo usuario logueado */
  2889.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  2890.         $user_id = $user_logueado->getId();
  2891.         $agent = $em->getRepository(User::class)->findOneById($user_id);
  2893.         $message = 'El proposal <strong>#'.$proposalId.' '.$proposal->getName().'</strong>'.' ha sido modificacdo por el agente: '.$agent->getName().' '.$agent->getLastName().'<br><br><br>'.$message;
  2894.         $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposalId);
  2895.         $mailArrayTo = array();
  2896.         if (!empty($agent)){ $mailArrayTo[$agent->getEmail()] = $agent->getEmail(); }
  2897.         if (!empty($proposalAgents)){
  2898.             if (!empty($proposalAgents->getAgOne())){
  2899.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgOne());
  2900.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2901.             }
  2903.             if (!empty($proposalAgents->getAgTwo())){
  2904.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgTwo());
  2905.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2906.             }
  2908.             if (!empty($proposalAgents->getAgThree())){
  2909.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgThree());
  2910.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2911.             }
  2913.             if (!empty($proposalAgents->getAgFour())){
  2914.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgFour());
  2915.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2916.             }
  2917.         }
  2919.         if (!empty($mailArrayTo)){
  2920.             $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2921.             $replyTo = array();
  2922.             foreach ($mailArrayTo as $item){ $replyTo[$item] = $item; }
  2924.             $agentMail = $agent->getEmail();
  2926.             //Se prepara el correo con los agentes a notificar
  2927.             $firmGmail = $agent->getFirmGmail();
  2928.             $data = array(
  2929.                 'body' => $message,
  2930.                 'firm' => $firmGmail,
  2931.             );
  2933.             // EJECUTAR ENVIO DE ALERTA PARA EL AGENTE
  2934.             $transporter = new Swift_SmtpTransport();
  2935.             $transporter->setHost('smtp.gmail.com')
  2936.                 ->setEncryption('ssl')//ssl / tls
  2937.                 ->setPort(465)// 465 / 587
  2938.                 ->setUsername('desarrollo@develup.solutions')
  2939.                 ->setPassword('utvh hzoi wfdo ztjs');
  2940.             $mailer = new Swift_Mailer($transporter);
  2942.             $message = new Swift_Message();
  2943.             $message->setSubject('Actualización de servicios AvExpress del proposal: '. $proposalId)
  2944.                 ->setSender($agentMail)
  2945.                 ->setFrom(array("desarrollo@develup.solutions" => "System Mante 3.0"))
  2946.                 ->setReplyTo($agentMail)
  2947.                 ->setTo($replyTo)
  2948.                 ->setBody(
  2949.                     $this->renderView(
  2950.                         'mail/structure-mail.html.twig',
  2951.                         array('data' => $data)
  2952.                     ),
  2953.                     'text/html'
  2954.                 );
  2955.             $mailer->send($message);
  2956.         }
  2958.         return true;
  2959.     }
  2961. };