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

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