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.                         if(!array_key_exists('location', $item)){ $item['location'] = null; }
  419.                         $data = $this->avePackageDeployService->updatePackage( $key, $item['price'], $item['units'], $item['days'], $item['location']);
  420.                     } else {
  421.                         $productInFile->setProductName($item['name']);
  422.                         $productInFile->setServicePrice($item['price']);
  423.                         $productInFile->setUnits($item['units']);
  424.                         $productInFile->setDays($item['days']);
  425.                         $productInFile->setSubTotalPrice($item['price'] * $item['units'] * $item['days']);
  427.                         // *** Primero se debe calcular la comision y luego el over ***
  429.                         // Calculo de comision
  430.                         if ($productInFile->getOpCommission()) {
  431.                             //Over positivo
  432.                             if (!($productInFile->getCommission() == 0) and is_numeric($productInFile->getCommission())) {
  433.                                 $suma = $productInFile->getCommission() / 100;
  434.                                 $suma = $productInFile->getSubTotalPrice() * $suma;
  435.                                 $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + $suma);
  436.                             }
  437.                         } else {
  438.                             //Over negativo
  439.                             if (!($productInFile->getCommission() == 0) and is_numeric($productInFile->getCommission())) {
  440.                                 $suma = $productInFile->getCommission() / 100;
  441.                                 $suma = $productInFile->getSubTotalPrice() * $suma;
  442.                                 if ($productInFile->getSubTotalPrice() > $suma) {            // La comision a restar no puede ser mayor que el precio total
  443.                                     $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() - $suma);
  444.                                 }
  445.                             }
  446.                         }
  448.                         // Calculo con OVER
  449.                         if ($productInFile->getOpOver()) {
  450.                             //Over positivo
  451.                             if (!($productInFile->getOver() == 0) and is_numeric($productInFile->getOver())) {
  452.                                 $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + $productInFile->getOver());
  453.                             }
  454.                         } else {
  455.                             //Over negativo
  456.                             if (!($productInFile->getOver() == 0) and is_numeric($productInFile->getOver())) {
  457.                                 $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + ((-1) * $productInFile->getOver()));
  458.                             }
  459.                         }
  461.                         // IVA
  463. //                    $productInFile->setDescription($item['description']);
  464.                         $productInFile->setUpdatedId($user_id);
  465.                         $productInFile->setUpdatedAt(new \DateTime("now"));
  467.                         //Si las fechas de inicio y fin no coinciden con el campo dias se debe enviar alerta
  468.                         $txtWarning = ($productInFile->getDateOutAt()->diff($productInFile->getDateInAt()))->days + 1 <> $productInFile->getDays() ? '<br>' . $productInFile->getProductName() : '';
  469.                         if (!empty($txtWarning)) {
  470.                             if (empty($srvInconsistentes)) {
  471.                                 $srvInconsistentes = 'Hay inconsistencias en: ' . '<br>' . $txtWarning;
  472.                             } else {
  473.                                 $srvInconsistentes = $srvInconsistentes . '<br>' . $txtWarning;
  474.                             }
  475.                         }
  477.                     }
  479.                     $em->persist($productInFile);
  480.                     $em->flush();
  482.                     //INICIO: Duplicamos en Eventos
  483.                     $proposalId = 0;
  484.                     if (!empty($productInFile->getOriginId())) {
  485.                         $serviceEvent = $em->getRepository(ProposalSupplierServices::class)->findOneById($productInFile->getOriginId());
  486.                         $oldServiceEvent = array(
  487.                             'activityId' => $serviceEvent->getActivityId(),
  488.                             'assistantId' => $serviceEvent->getAssistantId(),
  489.                             'breakdown' => $serviceEvent->getBreakdown(),
  490.                             'commission' => $serviceEvent->getCommission(),
  491.                             'controlId' => $serviceEvent->getControlId(),
  492.                             'currency' => $serviceEvent->getCurrency(),
  493.                             'dateBlockLimit' => $serviceEvent->getDateBlockLimit(),
  494.                             'dateInAt' => $serviceEvent->getDateInAt(),
  495.                             'dateOutAt' => $serviceEvent->getDateOutAt(),
  496.                             'destinationId' => $serviceEvent->getDestinationId(),
  497.                             'directPayment' => $serviceEvent->getDirectPayment(),
  498.                             'hour' => $serviceEvent->getHour(),
  499.                             'ideaId' => $serviceEvent->getIdeaId(),
  500.                             'isFather' => $serviceEvent->getIsFather(),
  501.                             'iva' => $serviceEvent->getIva(),
  502.                             'name' => $serviceEvent->getName(),
  503.                             'opCommission' => $serviceEvent->getOpCommission(),
  504.                             'opIva' => $serviceEvent->getOpIva(),
  505.                             'opOver' => $serviceEvent->getOpOver(),
  506.                             'originalIva' => $serviceEvent->getOriginalIva(),
  507.                             'originalPrice' => $serviceEvent->getOriginalPrice(),
  508.                             'originalopIva' => $serviceEvent->getOriginalopIva(),
  509.                             'over' => $serviceEvent->getOver(),
  510.                             'pax' => $serviceEvent->getPax(),
  511.                             'preCommission' => $serviceEvent->getPreCommission(),
  512.                             'preIva' => $serviceEvent->getPreIva(),
  513.                             'price' => $serviceEvent->getPrice(),
  514.                             'proposalId' => $serviceEvent->getProposalId(),
  515.                             'rank' => $serviceEvent->getRank(),
  516.                             'serviceCatId' => $serviceEvent->getServiceCatId(),
  517.                             'serviceCatName' => $serviceEvent->getServiceCatName(),
  518.                             'serviceId' => $serviceEvent->getServiceId(),
  519.                             'serviceIdFather' => $serviceEvent->getServiceIdFather(),
  520.                             'status' => $serviceEvent->getStatus(),
  521.                             'statusRec' => $serviceEvent->getStatusRec(),
  522.                             'statusinternal' => $serviceEvent->getStatusinternal(),
  523.                             'supplierId' => $serviceEvent->getSupplierId(),
  524.                             'units' => $serviceEvent->getUnits(),
  525.                         );
  527.                         if (!empty($serviceEvent)) {
  528.                             $proposalId = $serviceEvent->getProposalId();
  529.                             $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($serviceEvent->getProposalId());
  530.                             if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  532. //                            $serviceEvent->setUnits(1);                             // Las unidades no se pueden replicar o se genera un sobre calculo del lado de Evenetos
  533.                                 $serviceEvent->setName($productInFile->getProductName());
  535.                                 $priceInOut = $productInFile->getSubTotalPrice();
  536.                                 if (!($productInFile->getPax() == 0)) {
  537.                                     $priceInOut = $priceInOut / $productInFile->getPax();                    // Se devuelve el calculo dividiendo entre personas
  538.                                 }
  539.                                 if (!($productInFile->getUnits() == 0)) {
  540.                                     $priceInOut = $priceInOut / $productInFile->getUnits();                  // Se devuelve el calculo dividiendo entre cantidades
  541.                                 }
  542.                                 if (!($productInFile->getDays() == 0)) {
  543.                                     $priceInOut = $priceInOut / round($productInFile->getDays());            // Se devuelve el calculo dividiendo entre dias, se redondea por si es 1.5
  544.                                 }
  545.                                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  546.                                 $priceInOut = round($priceInOut, 2, PHP_ROUND_HALF_UP);
  548.                                 $serviceEvent->setPrice($priceInOut);
  550.                                 // Se verifican los precios en ambas partes (AV Express e InOut)
  551.                                 if (!($serviceEvent->getPrice() == $productInFile->getServicePrice())) {
  552.                                     // Si ambos precios unitarios son distintos se ha modificado el numero de días en Av Express
  553.                                     $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  554.                                     $serviceEvent->setPrice($newPriceInOut);
  555.                                 } else {
  556.                                     // si son iguales tambien se deben verificar el numero de dias
  557.                                     if (!(($serviceEvent->getDateOutAt()->diff($serviceEvent->getDateInAt())->days + 1) == $productInFile->getDays())) {
  558.                                         $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  559.                                         $serviceEvent->setPrice($newPriceInOut);
  560.                                     }
  561.                                 }
  563.                                 $serviceEvent->setCurrency($productInFile->getCurrency());
  564.                                 $serviceEvent->setUnits($productInFile->getUnits());
  565. //                            $serviceEvent->setIva(21);
  566.                                 if (empty($productInFile->getPax())) {
  567.                                     $serviceEvent->setPax(1);
  568.                                 } else {
  569.                                     $serviceEvent->setPax($productInFile->getPax());
  570.                                 }
  571.                                 $serviceEvent->setDateInAt($productInFile->getDateInAt());
  572.                                 $serviceEvent->setDateOutAt($productInFile->getDateOutAt());
  574.                                 //Verificamos cambios e informamos al agente del proposal
  575.                                 $boolChanges = false;
  576.                                 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; }
  577.                                 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; }
  578.                                 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; }
  579.                                 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; }
  580.                                 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; }
  581.                                 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; }
  582.                                 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; }
  583.                                 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; }
  584.                                 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; }
  585.                                 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; }
  586.                                 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; }
  587.                                 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; }
  588.                                 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; }
  589.                                 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; }
  590.                                 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; }
  591.                                 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; }
  593.                                 $em->persist($serviceEvent);
  594.                                 $em->flush();
  595.                             }
  596.                         }
  597.                     }
  598.                     //FIN: Duplicamos en Eventos
  599.                 }
  600.             }
  601.         }
  602.         // Notificamos al agente de InOut si se hicieron actualizaciones en los servicios desde AvExpress
  603.         if (!empty($txtOfChanges)) { $this->messageOfChangesToAgent($txtOfChanges, $proposalId); }
  605.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  607.         $event = 'Servicios guardados correctamente.';
  608.         $successMessage = $this->translator->trans($event);
  609.         $this->addFlash('mensajeav', $successMessage);
  611.         if (!empty($srvInconsistentes) and !empty($file->getIdProposal())){ $this->addFlash('mensajeaverror', $srvInconsistentes); }
  613.         // Si el proposalId esta vacio no se notifica a nadie por Telegram
  614.         if (empty($file->getIdProposal())){$logTelegram = false;}
  616.         //INICIO: Notificamos al agente por Telegram
  617.         if ($logTelegram){
  618.             //Buscamos todos los agentes del proposal
  619.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($file->getIdProposal());
  621.             //Buscamos el Destino
  622. //            $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  624.             //Buscamos el agente de AVEXPRESS
  625.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  627.             if (!empty($proposalAgents) and !($user_id == 22)){
  628.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  629.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  630.                 }
  631.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  632.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  633.                 }
  634.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  635.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  636.                 }
  637.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  638.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  639.                 }
  640.             }
  641.         }
  642.         //FIN: Notificamos al agente por Telegram
  644.         return $this->redirectToRoute('ave_edit_file', array('id' => $fileId));
  645.     }
  648.     /**
  649.      * @Route("/updateproductfilegridtwo/",  name="ave_update_productfile_grid_two")
  650.      * Editar todos los producto de un expediente con todos sus campos
  651.      */
  652.     public function updateProductFileGridTwoAction(Request $request){
  654.         $em = $this->getDoctrine()->getManager();
  655.         $newRequest = $request->request->get('services');
  656.         $fileId = $request->request->get('fileId');
  657.         $logTelegram = false;
  658.         $srvInconsistentes = '';                    // Mensaje de alerta por inconsistencia en los servicios
  660.         /* Obtengo usuario logueado */
  661.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  662.         $user_id = $user_logueado->getId();
  664.         $txtOfChanges = ''; $boolNotifyOfChanges = false; $proposalId = 0;
  666.         foreach ($newRequest as $item) {
  667.             $productInFile = $em->getRepository(AveProductFile::class)->findOneById($item['productFileId']);
  669.             $logTelegram = true;
  670.             $txtWarning = '';
  672.             $configItems = (str_contains($productInFile->getProductName(), '€')) ? 1 : 0;
  673.             $isPack = ($productInFile->getType() == 'Paquete');
  675.             if ($isPack and ($configItems == 1)){
  676.                 // Se llama la funcion que procesa la actualizacion de los paquetes
  677.                 $data = $this->avePackageDeployService->updatePackage( $productInFile->getId(), $item['price'], $item['units'], $item['days'],$item['location']);
  678.             } else {
  679.                 $productInFile->setProductName($item['name']);
  680.                 $productInFile->setServicePrice($item['price']);
  681. //                $productInFile->setDescription($item['description']);
  682.                 $productInFile->setCurrency($item['currency']);
  683.                 $productInFile->setUnits($item['units']);
  684.                 $productInFile->setType($item['prdType']);
  685.                 $productInFile->setLocation($item['location']);
  686.                 $idGpLounge = $em->getRepository(AveProductFileLocationNames::class)->findOneByName($item['location']);
  687.                 $idGpLounge = empty($idGpLounge) ? null : $idGpLounge->getIdGpLounge();
  688.                 $productInFile->setIdGpLounge($idGpLounge);
  689.                 $productInFile->setRankAv(intval($item['rankAv']));
  691.                 if (array_key_exists('dateInAt', $item)) {
  692.                     $productInFile->setDateStart(new \DateTime($item['dateInAt']));
  693.                     $productInFile->setDateInAt(new \DateTime($item['dateInAt']));
  694.                 } else {
  695.                     // No se requiere accion
  696.                 }
  698.                 if (array_key_exists('dateOutAt', $item)) {
  699.                     $productInFile->setDateEnd(new \DateTime($item['dateOutAt']));
  700.                     $productInFile->setDateOutAt(new \DateTime($item['dateOutAt']));
  701.                 } else {
  702.                     // No se requiere accion
  703.                 }
  705.                 if (empty($item['days'])) {
  706. //                $productInFile->setDays($days = (((new \DateTime($item['dateOutAt']))->diff(new \DateTime($item['dateInAt'])))->days + 1));
  707.                     $productInFile->setDays($days = (($productInFile->getDateOutAt()->diff($productInFile->getDateInAt()))->days + 1));
  708.                 } else {
  709.                     $productInFile->setDays($item['days']);
  710.                 }
  711.                 $productInFile->setPax($item['pax']);
  712.                 $productInFile->setOpCommission($item['opCommission']);
  713.                 $productInFile->setCommission($item['commission']);
  714.                 $productInFile->setOpOver($item['opOver']);
  715.                 $productInFile->setOver($item['over']);
  716.                 $productInFile->setOpIva($item['opIva']);
  717.                 $productInFile->setIva($item['iva']);
  719.                 if (!empty($item['supplierExt'])) {
  720.                     $supplier = $em->getRepository(Supplier::class)->findOneById($item['supplierExt']);
  721.                     $productInFile->setSupplierExt($supplier->getName());
  722.                     $productInFile->setSupplierExtId($item['supplierExt']);
  723.                 } else {
  724.                     $productInFile->setSupplierExt(null);
  725.                     $productInFile->setSupplierExtId(null);
  726.                 }
  728.                 $productInFile->setHourStart(substr($item['start'], 0, 2));
  729.                 $productInFile->setMinStart(substr($item['start'], 3, 2));
  731.                 $productInFile->setHourEnd(substr($item['end'], 0, 2));
  732.                 $productInFile->setMinEnd(substr($item['end'], 3, 2));
  734.                 $productInFile->setUpdatedId($user_id);
  735.                 $productInFile->setUpdatedAt(new \DateTime("now"));
  737.                 $productInFile->setSubTotalPrice($productInFile->getServicePrice());
  739.                 //INICIO: Validaciones para el sub total
  740.                 if (is_numeric($productInFile->getUnits())) {
  741.                     $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() * $productInFile->getUnits());
  742.                 }
  744.                 if (is_numeric($productInFile->getPax())) {
  745.                     $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() * $productInFile->getPax());
  746.                 }
  748.                 $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() * $productInFile->getDays());
  750.                 // *** Primero se debe calcular la comision y luego el over ***
  752.                 // Calculo de comision
  753.                 if ($productInFile->getOpCommission()) {
  754.                     //Over positivo
  755.                     if (!($productInFile->getCommission() == 0) and is_numeric($productInFile->getCommission())) {
  756.                         $suma = $productInFile->getCommission() / 100;
  757.                         $suma = $productInFile->getSubTotalPrice() * $suma;
  758.                         $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + $suma);
  759.                     }
  760.                 } else {
  761.                     //Over negativo
  762.                     if (!($productInFile->getCommission() == 0) and is_numeric($productInFile->getCommission())) {
  763.                         $suma = $productInFile->getCommission() / 100;
  764.                         $suma = $productInFile->getSubTotalPrice() * $suma;
  765.                         if ($productInFile->getSubTotalPrice() > $suma) {            // La comision a restar no puede ser mayor que el precio total
  766.                             $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() - $suma);
  767.                         }
  768.                     }
  769.                 }
  771.                 // Calculo con OVER
  772.                 if ($productInFile->getOpOver()) {
  773.                     //Over positivo
  774.                     if (!($productInFile->getOver() == 0) and is_numeric($productInFile->getOver())) {
  775.                         $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + $productInFile->getOver());
  776.                     }
  777.                 } else {
  778.                     //Over negativo
  779.                     if (!($productInFile->getOver() == 0) and is_numeric($productInFile->getOver())) {
  780.                         $productInFile->setSubTotalPrice($productInFile->getSubTotalPrice() + ((-1) * $productInFile->getOver()));
  781.                     }
  782.                 }
  784.                 // IVA
  785.                 //FIN: Validaciones para el sub total
  787.             }
  789.             //Si las fechas de inicio y fin no coinciden con el campo dias se debe enviar alerta
  790.             $txtWarning = ($productInFile->getDateOutAt()->diff($productInFile->getDateInAt()))->days + 1 <> $productInFile->getDays() ? '<br>'.$productInFile->getProductName() : '';
  791.             if (!empty($txtWarning)){
  792.                 if (empty($srvInconsistentes)){ $srvInconsistentes = 'Hay inconsistencias en: '.'<br>'.$txtWarning; } else { $srvInconsistentes = $srvInconsistentes.'<br>'.$txtWarning; }
  793.             }
  795.             $em->persist($productInFile);
  796.             $em->flush();
  797.             $em->clear();
  799.             //INICIO: Duplicamos en Eventos (SINCRONIZACION)
  800.             if (!empty($productInFile->getOriginId())){
  801.                 $serviceEvent = $em->getRepository(ProposalSupplierServices::class)->findOneById($productInFile->getOriginId());
  802.                 $proposalId = $serviceEvent->getProposalId();
  803.                 $oldServiceEvent = array(
  804.                     'activityId' => $serviceEvent->getActivityId(),
  805.                     'assistantId' => $serviceEvent->getAssistantId(),
  806.                     'breakdown' => $serviceEvent->getBreakdown(),
  807.                     'commission' => $serviceEvent->getCommission(),
  808.                     'controlId' => $serviceEvent->getControlId(),
  809.                     'currency' => $serviceEvent->getCurrency(),
  810.                     'dateBlockLimit' => $serviceEvent->getDateBlockLimit(),
  811.                     'dateInAt' => $serviceEvent->getDateInAt(),
  812.                     'dateOutAt' => $serviceEvent->getDateOutAt(),
  813.                     'destinationId' => $serviceEvent->getDestinationId(),
  814.                     'directPayment' => $serviceEvent->getDirectPayment(),
  815.                     'hour' => $serviceEvent->getHour(),
  816.                     'ideaId' => $serviceEvent->getIdeaId(),
  817.                     'isFather' => $serviceEvent->getIsFather(),
  818.                     'iva' => $serviceEvent->getIva(),
  819.                     'name' => $serviceEvent->getName(),
  820.                     'opCommission' => $serviceEvent->getOpCommission(),
  821.                     'opIva' => $serviceEvent->getOpIva(),
  822.                     'opOver' => $serviceEvent->getOpOver(),
  823.                     'originalIva' => $serviceEvent->getOriginalIva(),
  824.                     'originalPrice' => $serviceEvent->getOriginalPrice(),
  825.                     'originalopIva' => $serviceEvent->getOriginalopIva(),
  826.                     'over' => $serviceEvent->getOver(),
  827.                     'pax' => $serviceEvent->getPax(),
  828.                     'preCommission' => $serviceEvent->getPreCommission(),
  829.                     'preIva' => $serviceEvent->getPreIva(),
  830.                     'price' => $serviceEvent->getPrice(),
  831.                     'proposalId' => $serviceEvent->getProposalId(),
  832.                     'rank' => $serviceEvent->getRank(),
  833.                     'serviceCatId' => $serviceEvent->getServiceCatId(),
  834.                     'serviceCatName' => $serviceEvent->getServiceCatName(),
  835.                     'serviceId' => $serviceEvent->getServiceId(),
  836.                     'serviceIdFather' => $serviceEvent->getServiceIdFather(),
  837.                     'status' => $serviceEvent->getStatus(),
  838.                     'statusRec' => $serviceEvent->getStatusRec(),
  839.                     'statusinternal' => $serviceEvent->getStatusinternal(),
  840.                     'supplierId' => $serviceEvent->getSupplierId(),
  841.                     'units' => $serviceEvent->getUnits(),
  842.                 );
  844.                 if (!empty($serviceEvent)) {
  845.                     $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($serviceEvent->getProposalId());
  846.                     if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  848.                         $serviceEvent->setName($productInFile->getProductName());
  850.                         // Se verifican los precios en ambas partes (AV Express e InOut)
  851.                         if (!($serviceEvent->getPrice() == $productInFile->getServicePrice())) {
  852.                             // Si ambos precios unitarios son distintos se ha modificado el numero de días en Av Express
  853.                             $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  854.                             $serviceEvent->setPrice($newPriceInOut);
  855.                         } else {
  856.                             // si son iguales tambien se deben verificar el numero de dias
  857.                             if (!(($serviceEvent->getDateOutAt()->diff($serviceEvent->getDateInAt())->days + 1) == $productInFile->getDays())) {
  858.                                 $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $item);
  859.                                 $serviceEvent->setPrice($newPriceInOut);
  860.                             }
  861.                         }
  863.                         $serviceEvent->setCurrency($productInFile->getCurrency());
  864.                         $serviceEvent->setUnits($productInFile->getUnits());
  865.                         if (empty($productInFile->getPax())) {
  866.                             $serviceEvent->setPax(1);
  867.                         } else {
  868.                             $serviceEvent->setPax($productInFile->getPax());
  869.                         }
  870.                         $serviceEvent->setDateInAt($productInFile->getDateInAt());
  871.                         $serviceEvent->setDateOutAt($productInFile->getDateOutAt());
  873.                         // Se verifican los precios en ambas partes (AV Express e InOut)
  874.                         if (!($serviceEvent->getPrice() == $productInFile->getServicePrice())) {
  875.                             // Si ambos precios unitarios son distintos se ha modificado el numero de días en Av Express
  876.                             $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  877.                             $serviceEvent->setPrice($newPriceInOut);
  878.                         } else {
  879.                             // si son iguales tambien se deben verificar el numero de dias
  880.                             if (!(($serviceEvent->getDateOutAt()->diff($serviceEvent->getDateInAt())->days + 1) == $productInFile->getDays())) {
  881.                                 $newPriceInOut = $this->precioPorVariacionDeDias($serviceEvent, $productInFile);
  882.                                 $serviceEvent->setPrice($newPriceInOut);
  883.                             }
  884.                         }
  886.                         //Verificamos cambios e informamos al agente del proposal
  887.                         $boolChanges = false;
  888.                         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; }
  889.                         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; }
  890.                         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; }
  891.                         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; }
  892.                         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; }
  893.                         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; }
  894.                         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; }
  895.                         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; }
  896.                         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; }
  897.                         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; }
  898.                         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; }
  899.                         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; }
  900.                         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; }
  901.                         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; }
  902.                         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; }
  903.                         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; }
  905.                         $em->persist($serviceEvent);
  906.                         $em->flush();
  907.                         $em->clear();
  908.                     }
  909.                 }
  910.             }
  911.             //FIN: Duplicamos en Eventos
  912.         }
  914.         // Notificamos al agente de InOut si se hicieron actualizaciones en los servicios desde AvExpress
  915.         if (!empty($txtOfChanges)) { $this->messageOfChangesToAgent($txtOfChanges, $proposalId); }
  917.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  919.         $event = 'Servicios guardados correctamente.';
  920.         $successMessage = $this->translator->trans($event);
  921.         $this->addFlash('mensajeav', $successMessage);
  923.         if (!empty($srvInconsistentes) and !empty($file->getIdProposal())){ $this->addFlash('mensajeaverror', $srvInconsistentes); }
  925.         // Si el proposalId esta vacio no se notifica a nadie por Telegram
  926.         if (empty($file->getIdProposal())){$logTelegram = false;}
  928.         //INICIO: Notificamos al agente por Telegram
  929.         if ($logTelegram){
  930.             //Buscamos todos los agentes del proposal
  931.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($file->getIdProposal());
  933.             //Buscamos el Destino
  934. //            $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  936.             //Buscamos el agente de Develup
  937.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  939.             if (!empty($proposalAgents) and !($user_id == 22)){
  940.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  941.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID2) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  942.                 }
  943.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  944.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID2) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  945.                 }
  946.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  947.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID2) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  948.                 }
  949.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  950.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS (GRID2) __ ID: '.$file->getIdProposal().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  951.                 }
  952.             }
  953.         }
  954.         //FIN: Notificamos al agente por Telegram
  956.         return $this->redirectToRoute('ave_edit_file', array('id' => $fileId));
  957.     }
  960.     /**
  961.      * @Route("/productfilelistmultiple/{id}",  name="ave_list_multiple_productfile")
  962.      * Listar multiples productos para agregar en el expediente id
  963.      */
  964.     public function listMultipleProductFileAction( $id, Request $request){
  966.         $em = $this->getDoctrine()->getManager();
  967. //        $avs = $em->getRepository(AveProduct::class)->findAll();
  969.         // Listamos por orden alfabetico y se deja de primero a "Otro servicio"
  970.         $parameters = array();
  971.         $dql = 'SELECT i
  972.                     FROM AvexpressBundle:AveProduct i
  973.                     ORDER BY i.name ASC';
  974.         $query = $em->createQuery($dql)->setParameters($parameters);
  975.         $avs = $query->getResult();
  976.         $newAvs = array();
  978.         foreach ($avs as $key => $item) {
  979.             if ($item->getName() == 'Otro servicio'){
  980.                 $item->setName('0 - Otro servicio');
  981.                 $newAvs = array($item);
  982.                 unset($avs[$key]);
  983.                 foreach ($avs as $keyTwo => $elem){
  984.                     $ind = $keyTwo + 1;
  985.                     $elem->setName($ind.' - '.$elem->getName());
  986.                     array_push($newAvs,$elem);
  987.                 }
  988.             }
  989.         }
  990.         $avs = $newAvs;
  992.         /* av Description*/
  993.         $data_av = array();
  994.         foreach($avs as $av){
  996.             $data_av[] = array(
  997.                 'id' => $av->getId(),
  998.                 'name' => $av->getName(),
  999.                 'modules' => null,
  1000.                 'type' => $av->getType(),
  1001.                 'currency' => 'Euro',
  1002.                 'price' => $av->getPrice(),
  1003.                 'commission' => 0,
  1004.                 'iva' => 21,
  1005.                 'controlId' => 0,
  1006.                 'description' => null
  1007.             );
  1008.         }
  1010.         // Buscamos las plantilas precargadas
  1011.         $parameters = [];
  1012.         $dql = 'SELECT i
  1013.                     FROM AvexpressBundle:AveTemplate i
  1014.                     ORDER BY i.name ASC';
  1015.         $query = $em->createQuery($dql)->setParameters($parameters);
  1016.         $aveTemplates = $query->getResult();
  1018.         // Buscamos los paquetes
  1019.         $dql = 'SELECT i
  1020.                 FROM AvexpressBundle:AvePackageTemplate i
  1021.                 ORDER BY i.name ASC';
  1022.         $query = $em->createQuery($dql)->setParameters($parameters);
  1023.         $avePackageTemplates = $query->getResult();
  1025.         // Buscamos las proformas
  1026.         $proformas = $em->getRepository(AveDocProforma::class)->findByFileId($id);
  1028.         return $this->render('MDS/AvexpressBundle/Avexpress/add-services.html.twig',
  1029.             array(
  1030.                 'id' => $id,
  1031.                 'avs' => $data_av,
  1032.                 'newAvs' => $newAvs,
  1033.                 'aveTemplates' => $aveTemplates,
  1034.                 'proformas' => $proformas,
  1035.                 'avePackageTemplates' => $avePackageTemplates,
  1036.                 'technology' => null,
  1037.             ));
  1038.     }
  1041.     /**
  1042.      * @Route("/productfilemultipleadd/",  name="ave_add_multiple_productfile")
  1043.      * Agregar multiples productos a un expediente
  1044.      */
  1045.     public function addMultipleProductFileAction( EntityManagerInterface $em,  Request $request){
  1046.         $logTelegram = false;
  1047.         $fileId = $request->request->get('fileId');
  1048.         $products = $request->request->get('av');
  1049.         $template = $request->request->get('avexpress');
  1050.         $template = $template['template'];
  1051.         $package = $request->request->get('avexpress');
  1052.         $packageId = $package['package'];
  1053.         $packageConfig = $request->request->get('avexpress');
  1054.         $packageConfig = (array_key_exists('packageConfig',$packageConfig)) ? 1 : 0 ;   // 0 precio global, 1 precio detallado
  1056.         $srvDestination = $request->request->get('srvDestination');
  1058.         /* Obtengo usuario logueado */
  1059.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1060.         $user_id = $user_logueado->getId();
  1062.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  1063.         $template = $em->getRepository(AveTemplate::class)->findOneById($template);
  1064.         $package = $em->getRepository(AvePackageTemplate::class)->findOneById($packageId);
  1066.         // Buscamos los elementos del paquete seleccionado
  1067.         $packageItems = [];
  1068.         if(!empty($package)){
  1069.             $data = $this->avePackageDeployService->collapsePackage( $packageId, $fileId, $packageConfig );
  1070.         }
  1072.         if(!empty($products)) {
  1073.             foreach ($products as $item) {
  1074.                 $mdvProductSelected = $em->getRepository(AveProduct::class)->findOneById($item);
  1076.                 $newProductFile = new AveProductFile();
  1077.                 $newProductFile->setProductName($mdvProductSelected->getName());
  1078.                 $newProductFile->setProductId($mdvProductSelected->getId());
  1079.                 $newProductFile->setServicePrice($mdvProductSelected->getPrice());
  1080.                 $newProductFile->setDescription($mdvProductSelected->getDescription());
  1081.                 $newProductFile->setType($mdvProductSelected->getType());
  1082.                 $newProductFile->setFileId($fileId);
  1083.                 $newProductFile->setUnits('1');
  1084.                 $newProductFile->setOpIva(true);
  1085.                 $newProductFile->setIva('21');
  1086.                 $newProductFile->setSupplierExt($mdvProductSelected->getSupplierExt());
  1087.                 $newProductFile->setSupplierExtId($mdvProductSelected->getSupplierExtId());
  1088.                 $dataDates = $this->obtenerFechas($newProductFile->getFileId(), $newProductFile->getDateStart(), $newProductFile->getDateEnd());
  1089.                 $newProductFile->setDateStart($dataDates['dateStart']);
  1090.                 $newProductFile->setDateEnd($dataDates['dateEnd']);
  1091.                 $newProductFile->setDateInAt($dataDates['dateStart']);
  1092.                 $newProductFile->setDateOutAt($dataDates['dateEnd']);
  1094.                 $dataRankAv = $this->obtenerRankAv($fileId);
  1095.                 $newProductFile->setRankAv($dataRankAv);
  1097.                 $newProductFile->setCreatedId($user_id);
  1098.                 $newProductFile->setUpdatedId($user_id);
  1099.                 $newProductFile->setCreatedAt(new \DateTime("now"));
  1100.                 $newProductFile->setUpdatedAt(new \DateTime("now"));
  1102.                 if (empty($newProductFile->getType())){ $newProductFile->setType('Otros'); }
  1104.                 $newProductFile->setDays((($newProductFile->getDateEnd()->diff($newProductFile->getDateStart()))->days + 1));
  1105.                 $newProductFile->setSubTotalPrice($newProductFile->getServicePrice() * $newProductFile->getDays());
  1107.                 $em->persist($newProductFile);
  1108.                 $em->flush();
  1110.                 if (!($srvDestination == 0)){
  1111.                     //Se debe agregar el producto a una proforma
  1112.                     $this->addProductFileToProforma($fileId, $newProductFile->getId(), $srvDestination);
  1113.                 }
  1115.                 // Si hay proposal se debe actualizar en el expediente de Eventos
  1116.                 if (!empty($file->getIdProposal()) and is_numeric($file->getIdProposal())) {
  1118.                     // Buscamos el destino donde se encuentre Av Express y ahi agregamos el servicio, si no se encuentra no se agregara el servicio
  1119.                     $control = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  1120.                         array(
  1121.                             'supplierId' => 80,                                          // El supplier 80 es AVEXPRESS
  1122.                             'proposalId' => $file->getIdProposal(),
  1123.                         )
  1124.                     );
  1126.                     if (!empty($control)) {
  1127.                         // Existe un destino con Av Express como proveedor, hay se agregara el servicio
  1129.                         $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($file->getIdProposal());
  1130.                         if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  1131.                             $logTelegram = true;
  1133.                             $service = new ProposalSupplierServices();
  1134.                             $service->setServiceIdFather(0);
  1135.                             $service->setControlId($control->getId());
  1136.                             $service->setProposalId($file->getIdProposal());
  1137.                             $service->setDestinationId($control->getDestinoId());
  1138.                             $service->setSupplierId(80);
  1139.                             $service->setIdeaId(null);
  1140.                             $service->setServiceId($newProductFile->getProductId());
  1141.                             $service->setServiceCatName('Av');
  1142.                             $service->setServiceCatId(3);
  1143.                             $service->setName($newProductFile->getProductName());
  1145.                             $service->setPrice($newProductFile->getSubTotalPrice() / $newProductFile->getDays());
  1146. //                        $priceInOut = $newProductFile->getSubTotalPrice() / $newProductFile->getPax();      // Se devuelve el calculo dividiendo entre personas
  1147. //                        $priceInOut = $priceInOut / $newProductFile->getUnits();                            // Se devuelve el calculo dividiendo entre cantidades
  1148. //                        $priceInOut = $priceInOut / round($newProductFile->getDays());                      // Se devuelve el calculo dividiendo entre dias, se redondea por si es 1.5
  1149. //                        $service->setPrice($priceInOut);
  1151.                             $service->setCurrency($newProductFile->getCurrency());
  1152.                             $service->setUnits($newProductFile->getUnits());
  1153.                             $service->setCommission(0);
  1154.                             $service->setOver(0);
  1155.                             $service->setIva(21);
  1156.                             $service->setPax(1);
  1157.                             $service->setHour(null);
  1158.                             $service->setDateInAt($newProductFile->getDateInAt());
  1159.                             $service->setDateOutAt($newProductFile->getDateOutAt());
  1160.                             $service->setDirectPayment(0);
  1161.                             $service->setStatus('Pending');
  1162.                             $service->setStatusinternal('Additional');
  1163.                             $service->setPreCommission(null);
  1164.                             $service->setPreIva(null);
  1165.                             $service->setDateBlockLimit(null);
  1166.                             $service->setOpCommission(1);
  1167.                             $service->setOpOver(1);
  1168.                             $service->setOpIva(1);
  1169.                             $service->setBreakdown(0);
  1170.                             $service->setIsFather(0);
  1171.                             $service->setRank(1);
  1172.                             $service->setOriginalopIva(1);
  1173.                             $service->setOriginalIva(null);
  1174.                             $service->setOriginalPrice(null);
  1175.                             $service->setStatusRec('normal');
  1176.                             $service->setAssistantId(null);
  1177.                             $service->setCreatedId($user_id);
  1178.                             $service->setUpdatedId($user_id);
  1179.                             $service->setCreatedAt(new \DateTime("now"));
  1180.                             $service->setUpdatedAt(new \DateTime("now"));
  1182.                             $em->persist($service);
  1183.                             $em->flush();
  1185.                             // Guardamos el ID del servicio (Eventos) asociado al producto (AvExpress)
  1186.                             $newProductFile->setOriginId($service->getId());
  1188.                             $em->persist($newProductFile);
  1189.                             $em->flush();
  1190.                         }
  1191.                     }
  1192.                 }
  1193.             }
  1194.         }
  1196.         // Buscamos los elementos de la plantilla seleccionada
  1197.         $templateItems = [];
  1198.         if(!empty($template)){
  1199.             $templateItems = $em->getRepository(AveTemplateItems::class)->findByTemplateId($template);
  1200.         }
  1202.         foreach ($templateItems as $item){
  1204.             $newProductFile = new AveProductFile();
  1205.             $newProductFile->setProductName($item->getProductName());
  1206.             $newProductFile->setProductId($item->getProductId());
  1207.             $newProductFile->setServicePrice($item->getServicePrice());
  1208.             $newProductFile->setFileId($fileId);
  1209.             $newProductFile->setPax($item->getPax());
  1210.             $newProductFile->setType($item->getType());
  1211.             $newProductFile->setHourStart($item->getHourStart());
  1212.             $newProductFile->setMinStart($item->getMinStart());
  1213.             $newProductFile->setHourEnd($item->getHourEnd());
  1214.             $newProductFile->setMinEnd($item->getMinEnd());
  1215.             $newProductFile->setDescription($item->getDescription());
  1216.             $newProductFile->setSupplierExtId($item->getSupplierExtId());
  1217.             $newProductFile->setSupplierExt($item->getSupplierExt());
  1218.             $newProductFile->setServiceIdProposal($item->getServiceIdProposal());
  1219.             $newProductFile->setServiceIdFather($item->getServiceIdFather());
  1220.             $newProductFile->setControlId($item->getControlId());
  1221.             $newProductFile->setProposalId($item->getProposalId());
  1222.             $newProductFile->setDestinationId($item->getDestinationId());
  1223.             $newProductFile->setIdeaId($item->getIdeaId());
  1224.             $newProductFile->setActivityId($item->getActivityId());
  1225.             $newProductFile->setSupplierId($item->getSupplierId());
  1226.             $newProductFile->setAssistantId($item->getAssistantId());
  1227.             $newProductFile->setServiceId($item->getServiceId());
  1228.             $newProductFile->setServiceCatId($item->getServiceCatId());
  1229.             $newProductFile->setServiceCatName($item->getServiceCatName());
  1230.             $newProductFile->setName($item->getName());
  1231.             $newProductFile->setPrice($item->getPrice());
  1232.             $newProductFile->setCurrency($item->getCurrency());
  1233.             $newProductFile->setUnits($item->getUnits());
  1234.             $newProductFile->setOpCommission($item->getOpCommission());
  1235.             $newProductFile->setCommission($item->getCommission());
  1236.             $newProductFile->setOpOver($item->getOpOver());
  1237.             $newProductFile->setOver($item->getOver());
  1238.             $newProductFile->setOpIva($item->getOpIva());
  1239.             $newProductFile->setIva($item->getIva());
  1240.             $newProductFile->setHour($item->getHour());
  1242.             $dataDates = $this->obtenerFechas($newProductFile->getFileId(), $newProductFile->getDateStart(), $newProductFile->getDateEnd());
  1243.             $newProductFile->setDateStart($dataDates['dateStart']);
  1244.             $newProductFile->setDateEnd($dataDates['dateEnd']);
  1245.             $newProductFile->setDateInAt($dataDates['dateStart']);
  1246.             $newProductFile->setDateOutAt($dataDates['dateEnd']);
  1248.             $newProductFile->setContcolor($item->getContcolor());
  1249.             $newProductFile->setRank($item->getRank());
  1251.             $dataRankAv = $this->obtenerRankAv($fileId);
  1252.             $newProductFile->setRankAv($dataRankAv);
  1254.             $newProductFile->setRenovate($item->getRenovate());
  1255.             $newProductFile->setPay($item->getPay());
  1256.             $newProductFile->setDays($item->getDays());
  1257.             $newProductFile->setSubTotalPrice($item->getSubTotalPrice());
  1259.             $newProductFile->setCreatedId($user_id);
  1260.             $newProductFile->setUpdatedId($user_id);
  1261.             $newProductFile->setCreatedAt(new \DateTime("now"));
  1262.             $newProductFile->setUpdatedAt(new \DateTime("now"));
  1264.             if (empty($newProductFile->getType())){ $newProductFile->setType('Otros'); }
  1266.             $em->persist($newProductFile);
  1267.             $em->flush();
  1269.             if (!($srvDestination == 0)){
  1270.                 //Se debe agregar el producto a una proforma
  1271.                 $this->addProductFileToProforma($fileId, $newProductFile->getId(), $srvDestination);
  1272.             }
  1274.             // Si hay proposal se debe actualizar en el expediente de Eventos
  1275.             if (!empty($file->getIdProposal()) and is_numeric($file->getIdProposal())){
  1277.                 // Buscamos el destino donde se encuentre Av Express y ahi agregamos el servicio, si no se encuentra no se agregara el servicio
  1278.                 $control = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  1279.                     array(
  1280.                         'supplierId' => 80,                                          // El supplier 80 es AVEXPRESS
  1281.                         'proposalId' => $file->getIdProposal(),
  1282.                     )
  1283.                 );
  1285.                 if (!empty($control)){
  1286.                     // Existe un destino con Av Express como proveedor, hay se agregara el servicio
  1287.                     $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($file->getIdProposal());
  1288.                     if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  1289.                         $logTelegram = true;
  1291.                         $service = new ProposalSupplierServices();
  1292.                         $service->setServiceIdFather(0);
  1293.                         $service->setControlId($control->getId());
  1294.                         $service->setProposalId($file->getIdProposal());
  1295.                         $service->setDestinationId($control->getDestinoId());
  1296.                         $service->setSupplierId(80);
  1297.                         $service->setIdeaId(null);
  1298.                         $service->setServiceId($newProductFile->getProductId());
  1299.                         $service->setServiceCatName('Av');
  1300.                         $service->setServiceCatId(3);
  1301.                         $service->setName($newProductFile->getProductName());
  1302.                         $service->setPrice($newProductFile->getSubTotalPrice());
  1303.                         $service->setCurrency(null);
  1304.                         $service->setUnits(1);
  1305.                         $service->setCommission(0);
  1306.                         $service->setOver(0);
  1307.                         $service->setIva(21);
  1308.                         $service->setPax(0);
  1309.                         $service->setHour(null);
  1310.                         $service->setDateInAt(new \DateTime("now"));
  1311.                         $service->setDateOutAt(new \DateTime("now"));
  1312.                         $service->setDirectPayment(0);
  1313.                         $service->setStatus('Pending');
  1314.                         $service->setStatusinternal('Additional');
  1315.                         $service->setPreCommission(null);
  1316.                         $service->setPreIva(null);
  1317.                         $service->setDateBlockLimit(null);
  1318.                         $service->setOpCommission(1);
  1319.                         $service->setOpOver(1);
  1320.                         $service->setOpIva(1);
  1321.                         $service->setBreakdown(0);
  1322.                         $service->setIsFather(0);
  1323.                         $service->setRank(1);
  1324.                         $service->setOriginalopIva(1);
  1325.                         $service->setOriginalIva(null);
  1326.                         $service->setOriginalPrice(null);
  1327.                         $service->setStatusRec('normal');
  1328.                         $service->setAssistantId(null);
  1329.                         $service->setCreatedId($user_id);
  1330.                         $service->setUpdatedId($user_id);
  1331.                         $service->setCreatedAt(new \DateTime("now"));
  1332.                         $service->setUpdatedAt(new \DateTime("now"));
  1334.                         $em->persist($service);
  1335.                         $em->flush();
  1337.                         // Guardamos el ID del servicio (Eventos) asociado al producto (AvExpress)
  1338.                         $newProductFile->setOriginId($service->getId());
  1340.                         $em->persist($newProductFile);
  1341.                         $em->flush();
  1342.                     }
  1343.                 }
  1344.             }
  1345.         }
  1347.         //INICIO: Notificamos al agente por Telegram
  1348.         if ($logTelegram){
  1349.             //Buscamos todos los agentes del proposal
  1350.             $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($file->getIdProposal());
  1352.             //Buscamos el Destino
  1353.             $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  1355.             //Buscamos el agente de AvExpress
  1356.             $userData = $em->getRepository(User::class)->findOneById($user_id);
  1358.             if (!empty($proposalAgents) and !($user_id == 22)){
  1359.                 if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  1360.                     $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1361.                 }
  1362.                 if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  1363.                     $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1364.                 }
  1365.                 if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  1366.                     $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1367.                 }
  1368.                 if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  1369.                     $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$file->getIdProposal().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1370.                 }
  1371.             }
  1372.         }
  1373.         //FIN: Notificamos al agente por Telegram
  1375.         return $this->redirectToRoute('ave_edit_file', array( 'id' => $fileId ) );
  1376.     }
  1379.     /**
  1380.      * @Route("/productfileedit/{id}",  name="ave_productfile_edit")
  1381.      * Editar un producto de un expediente
  1382.      */
  1383.     public function editProductFileAction($id, Request $request){
  1385.         $em = $this->getDoctrine()->getManager();
  1386.         $productFile = $em->getRepository(AveProductFile::class)->findOneById($id);
  1388.         $fileId = $productFile->getFileId();
  1390.         // Primero se agrupan por sala (Ubicacion), luego por tipo y finalmente por RankAv
  1391.         // Salvador Guerrero indico, el orden de los productos en la factura o proforma será (Video - Sonido - Iluminacion - Otros)
  1393.         $allProductFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  1394.         $arrayLocation = array();
  1395.         $arrayLocationWithNull = false;
  1396.         foreach ($allProductFile as $item){
  1397.             if (!empty($item->getLocation())){
  1398.                 $arrayLocation[$item->getLocation()] = $item->getLocation();
  1399.             } else {
  1400.                 $arrayLocationWithNull = true;
  1401.             }
  1402.         }
  1403.         if ($arrayLocationWithNull){ $arrayLocation['null'] = 'null'; }
  1405.         $productInFile = array();
  1407.         foreach ($arrayLocation as $item){
  1408.             // VIDEO
  1409.             $parameters = array(
  1410.                 'fileId' => $fileId,
  1411.                 'type' => 'Vídeo',
  1412.                 'location' => $item,
  1413.             );
  1414.             $dql = 'SELECT i
  1415.                     FROM AvexpressBundle:AveProductFile i
  1416.                     WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location
  1417.                     ORDER BY i.rankAv ASC';
  1418.             $query = $em->createQuery($dql)->setParameters($parameters);
  1419.             $productsInFileVid = $query->getResult();
  1421.             // SONIDO
  1422.             $parameters = array(
  1423.                 'fileId' => $fileId,
  1424.                 'type' => 'Sonido',
  1425.                 'location' => $item,
  1426.             );
  1427.             $dql = 'SELECT i
  1428.                     FROM AvexpressBundle:AveProductFile i
  1429.                     WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location
  1430.                     ORDER BY i.rankAv ASC';
  1431.             $query = $em->createQuery($dql)->setParameters($parameters);
  1432.             $productsInFileSound = $query->getResult();
  1434.             // ILUMINACION
  1435.             $parameters = array(
  1436.                 'fileId' => $fileId,
  1437.                 'type' => 'Iluminación',
  1438.                 'location' => $item,
  1439.             );
  1440.             $dql = 'SELECT i
  1441.                     FROM AvexpressBundle:AveProductFile i
  1442.                     WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location
  1443.                     ORDER BY i.rankAv ASC';
  1444.             $query = $em->createQuery($dql)->setParameters($parameters);
  1445.             $productsInFileLights = $query->getResult();
  1447.             // OTROS
  1448.             $parameters = array(
  1449.                 'fileId' => $fileId,
  1450.                 'typeV' => 'Vídeo',
  1451.                 'typeS' => 'Sonido',
  1452.                 'typeI' => 'Iluminación',
  1453.                 'location' => $item,
  1454.             );
  1455.             $dql = 'SELECT i
  1456.                     FROM AvexpressBundle:AveProductFile i
  1457.                     WHERE (i.fileId = :fileId AND i.type != :typeV AND i.type != :typeS AND i.type != :typeI AND i.location = :location)
  1458.                     ORDER BY i.rankAv ASC';
  1459.             $query = $em->createQuery($dql)->setParameters($parameters);
  1460.             $productsInFileOther = $query->getResult();
  1462.             // CASO NULL (Los casos EMPTY estan considerados en las consultas previas)
  1463.             $parameters = array(
  1464.                 'fileId' => $fileId,
  1465.                 'location' => $item,
  1466.             );
  1467.             $dql = 'SELECT i
  1468.                     FROM AvexpressBundle:AveProductFile i
  1469.                     WHERE (i.fileId = :fileId AND i.type IS NULL AND i.location = :location)
  1470.                     ORDER BY i.rankAv ASC';
  1471.             $query = $em->createQuery($dql)->setParameters($parameters);
  1472.             $productsInFileNull = $query->getResult();
  1474.             // Para el location en NULL el SQL tiene que ser diferente por eso el siguiente condicional
  1475.             if ($item == 'null'){
  1477.                 // VIDEO
  1478.                 $parameters = array(
  1479.                     'fileId' => $fileId,
  1480.                     'type' => 'Vídeo',
  1481.                     'location' => '',
  1482.                 );
  1483.                 $dql = 'SELECT i
  1484.                         FROM AvexpressBundle:AveProductFile i
  1485.                         WHERE i.fileId = :fileId AND i.type = :type AND (i.location IS NULL OR i.location = :location)
  1486.                         ORDER BY i.rankAv ASC';
  1487.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1488.                 $productsInFileVid = $query->getResult();
  1490.                 // SONIDO
  1491.                 $parameters = array(
  1492.                     'fileId' => $fileId,
  1493.                     'type' => 'Sonido',
  1494.                     'location' => '',
  1495.                 );
  1496.                 $dql = 'SELECT i
  1497.                         FROM AvexpressBundle:AveProductFile i
  1498.                         WHERE i.fileId = :fileId AND i.type = :type AND (i.location IS NULL OR i.location = :location) 
  1499.                         ORDER BY i.rankAv ASC';
  1500.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1501.                 $productsInFileSound = $query->getResult();
  1503.                 // ILUMINACION
  1504.                 $parameters = array(
  1505.                     'fileId' => $fileId,
  1506.                     'type' => 'Iluminación',
  1507.                     'location' => '',
  1508.                 );
  1509.                 $dql = 'SELECT i
  1510.                         FROM AvexpressBundle:AveProductFile i
  1511.                         WHERE i.fileId = :fileId AND i.type = :type AND (i.location IS NULL OR i.location = :location)
  1512.                         ORDER BY i.rankAv ASC';
  1513.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1514.                 $productsInFileLights = $query->getResult();
  1516.                 // OTROS
  1517.                 $parameters = array(
  1518.                     'fileId' => $fileId,
  1519.                     'typeV' => 'Vídeo',
  1520.                     'typeS' => 'Sonido',
  1521.                     'typeI' => 'Iluminación',
  1522.                     'location' => '',
  1523.                 );
  1524.                 $dql = 'SELECT i
  1525.                         FROM AvexpressBundle:AveProductFile i
  1526.                         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))
  1527.                         ORDER BY i.rankAv ASC';
  1528.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1529.                 $productsInFileOther = $query->getResult();
  1531.                 // CASO NULL DEL TIPO (Los casos EMPTY estan considerados en las consultas previas)
  1532.                 $parameters = array(
  1533.                     'fileId' => $fileId,
  1534.                     'location' => '',
  1535.                 );
  1536.                 $dql = 'SELECT i
  1537.                         FROM AvexpressBundle:AveProductFile i
  1538.                         WHERE (i.fileId = :fileId AND i.type IS NULL AND (i.location IS NULL OR i.location = :location))
  1539.                         ORDER BY i.rankAv ASC';
  1540.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1541.                 $productsInFileNull = $query->getResult();
  1542.             }
  1543.             $productInFile = array_merge($productInFile,$productsInFileVid, $productsInFileSound, $productsInFileLights, $productsInFileOther, $productsInFileNull);
  1544.         }
  1547.         $parameters = array();
  1548.         $dql = 'SELECT p.id, p.name
  1549.                 FROM App\Entity\Supplier p
  1550.                 WHERE p.isSupplierAvExpress = TRUE 
  1551.                 ORDER BY p.name ASC ';
  1553.         $query = $em->createQuery($dql)->setParameters($parameters);
  1554.         $suppliers = $query->getResult();
  1556.         // Quitamos el elemento seleccionado para evitar duplicaciones
  1557.         foreach ($productInFile as $key => $item) {
  1558.             if ($productFile->getId() == $item->getId()){
  1559.                 unset($productInFile[$key]);
  1560.             }
  1561.         }
  1562.         $id = $productFile->getFileId();
  1563.         $numeroItems = sizeof($productInFile) + 1;
  1565.         $productsLocation = $em->getRepository(AveProductFileLocationNames::class)->findAll();
  1567.         return $this->render('MDS/AvexpressBundle/Avexpress/edit-productfiles.html.twig',
  1568.             array(
  1569.                 'id' => $id,
  1570.                 'numeroItems' => $numeroItems,
  1571.                 'arrayProductFile' => $productInFile,
  1572.                 'services' => $productInFile,
  1573.                 'product' => array($productFile),
  1574.                 'suppliers' => $suppliers,
  1575.                 'productsLocation' => $productsLocation,
  1576.             ));
  1577.     }
  1580.     /**
  1581.      * @Route("/cleanproductfile/{id}",  name="ave_clean_productfile")
  1582.      * Eliminar los productos (y servicios en InOut) de un expediente que no estén relacionados con una factura o una proforma
  1583.      */
  1584.     public function cleanProductFileAction($id, Request $request)
  1585.     {
  1586.         $em = $this->getDoctrine()->getManager();
  1588.         /* Obtengo usuario logueado */
  1589.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1590.         $user_id = $user_logueado->getId();
  1592.         $allMdvProductSelected = $em->getRepository(AveProductFile::class)->findByFileId($id);
  1594.         // Si el ProductFile esta asociado a una factura o a una proforma se mantiene, de lo contrario se elimina y su evento asociado
  1595.         foreach ($allMdvProductSelected as $key => $item){
  1596.             $isInInvoice = $em->getRepository(AveDocInvoiceItems::class)->findOneByPrdControlId($item->getId());
  1597.             $isInProforma = $em->getRepository(AveDocProformaItems::class)->findOneByControlId($item->getId());
  1599.             if (!empty($isInInvoice) or !empty($isInProforma)){
  1600.                 //Lo sacamos de la lista de elementos a eliminar
  1602.                 unset($allMdvProductSelected[$key]);
  1603.             }
  1604.         }
  1606.         foreach ($allMdvProductSelected as $mdvProductSelected){
  1607.             $logTelegram = false;
  1609.             //INICIO: Si hay un ID origin se debe eliminar en Eventos
  1610.             if (!empty($mdvProductSelected->getOriginId())){
  1611.                 $logTelegram = true;
  1612.                 $delete = $em->getRepository(ProposalSupplierServices::class)->findOneById($mdvProductSelected->getOriginId());
  1613.                 if (!empty($delete)) {
  1614.                     $destinationId = $delete->getDestinationId();
  1615.                     $nameServEvents = $delete->getName();
  1616.                     $proposalId = $delete->getProposalId();
  1617.                     $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($delete->getProposalId());
  1618.                     if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  1619.                         if (!empty($delete)) {
  1620.                             $delete_sub = $em->getRepository(ProposalSupplierServices::class)->findByServiceIdFather($delete->getId());
  1621.                             foreach ($delete_sub as $deletesub) {
  1622.                                 $em->remove($deletesub);
  1623.                             }
  1625.                             $em->remove($delete);
  1626.                             $em->flush();
  1627.                         }
  1628.                     }
  1629.                 } else {
  1630.                     // El servicio origen no se encontro
  1631.                     $logTelegram = false;
  1632.                 }
  1633.             }
  1635.             //INICIO: Notificamos al agente por Telegram
  1636.             if ($logTelegram){
  1637.                 //Buscamos todos los agentes del proposal
  1638.                 $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposalId);
  1640.                 //Buscamos el Destino
  1641.                 $proposalDestino = $em->getRepository(Destination::class)->findOneById($destinationId);
  1643.                 //Buscamos el agente de Develup
  1644.                 $userData = $em->getRepository(User::class)->findOneById($user_id);
  1646.                 if (!empty($proposalAgents)){
  1647.                     if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  1648.                         $this->sendTelegram($proposalAgents->getAgOne(),'1. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1649.                     }
  1650.                     if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  1651.                         $this->sendTelegram($proposalAgents->getAgTwo(),'2. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1652.                     }
  1653.                     if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  1654.                         $this->sendTelegram($proposalAgents->getAgThree(),'3. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1655.                     }
  1656.                     if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  1657.                         $this->sendTelegram($proposalAgents->getAgFour(),'4. SERVICIO ELIMINADO DESDE AVEXPRESS __ ID: '.$proposalId.' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  1658.                     }
  1659.                 }
  1660.             }
  1661.             //FIN: Notificamos al agente por Telegram
  1663.             //FIN: Si hay un ID origin se debe eliminar en Eventos
  1665.             //INICIO: Si el producto se encuentra dentro de una proforma (Ave_Doc_Proforma_Items) se elimina también
  1666.             $productInProforma = $em->getRepository(AveDocProformaItems::class)->findOneByControlId($mdvProductSelected->getId());
  1667.             if (!empty($productInProforma)){
  1668.                 $productInProforma->setFileId((-1) * $productInProforma->getFileId());      // No lo vamos a eliminar, apuntará al fileId en negativo
  1669.                 $em->persist($productInProforma);
  1670.                 // $em->remove($productInProforma);
  1671.                 $em->flush();
  1672.             }
  1673.             //FIN: Si el producto se encuentra dentro de una proforma (Ave_Doc_Proforma_Items) se elimina también
  1675.             $mdvProductSelected->setFileId((-1) * $mdvProductSelected->getFileId());      // No lo vamos a eliminar, apuntará al fileId en negativo
  1676.             $em->persist($mdvProductSelected);
  1677.             // $em->remove($mdvProductSelected);
  1678.             $em->flush();
  1679.         }
  1681.         return $this->redirectToRoute('ave_edit_file', array('id' => $id));
  1682.     }
  1685.     /**
  1686.      * @Route("/overallproductfile/",  name="ave_over_all_productfile")
  1687.      * Aplicar un Over a todos los productos de un expediente
  1688.      */
  1689.     public function overAllProductFileAction(Request $request){
  1691.         $fileId = $request->request->get('fileId');
  1692.         $opOverAll = $request->request->get('opOverAll');
  1693.         $overAll = $request->request->get('overAll');
  1695.         $em = $this->getDoctrine()->getManager();
  1696.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  1698.         foreach ($productInFile as $item){
  1699.             $itemId = $item->getId();
  1700.             $item->setOpOver($opOverAll);
  1701.             $item->setOver($overAll);
  1703.             $em->persist($item);
  1704.             $em->flush();
  1705.         }
  1707.         return $this->redirectToRoute('ave_productfile_edit', array('id' => $itemId));
  1708.     }
  1711.     /**
  1712.      * @Route("/commissionallproductfile/",  name="ave_commission_all_productfile")
  1713.      * Aplicar una Comision a todos los productos de un expediente
  1714.      */
  1715.     public function commissionAllProductFileAction(Request $request){
  1717.         $fileId = $request->request->get('fileId');
  1718.         $opCommissionAll = $request->request->get('opCommissionAll');
  1719.         $commissionAll = $request->request->get('commissionAll');
  1721.         $em = $this->getDoctrine()->getManager();
  1722.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  1724.         foreach ($productInFile as $item){
  1725.             $itemId = $item->getId();
  1726.             $item->setOpCommission($opCommissionAll);
  1727.             $item->setCommission($commissionAll);
  1729.             $em->persist($item);
  1730.             $em->flush();
  1731.         }
  1733.         return $this->redirectToRoute('ave_productfile_edit', array('id' => $itemId));
  1734.     }
  1736.     /**
  1737.      * @Route("/ivazeroallproductfile/",  name="ave_iva_zero_all_productfile")
  1738.      * Aplicar un IVA de cero a todos los productos de un expediente
  1739.      */
  1740.     public function ivaZeroAllProductFileAction(Request $request){
  1741.         $fileId = $request->request->get('fileId');
  1742. //        $opCommissionAll = $request->request->get('opCommissionAll');
  1743. //        $commissionAll = $request->request->get('commissionAll');
  1744.         $em = $this->getDoctrine()->getManager();
  1745.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  1746.         foreach ($productInFile as $item){
  1747.             $itemId = $item->getId();
  1748.             $item->setOpIva(1);
  1749.             $item->setIva(0);
  1750.             
  1751.             $em->persist($item);
  1752.             $em->flush();
  1753.         }
  1754.         return $this->redirectToRoute('ave_productfile_edit', array('id' => $itemId));
  1755.     }
  1756.     
  1759.     /**
  1760.      * @Route("/productfilelocationadd/",  name="ave_add_productfilelocation")
  1761.      * Agregar una Ubicacion. Salas en donde estara el producto
  1762.      */
  1763.     public function addProductFileLocationAction( Request $request)
  1764.     {
  1765.         $em = $this->getDoctrine()->getManager();
  1766.         $newRequest = $request->request->get('product');
  1768.         /* Obtengo usuario logueado */
  1769.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1770.         $user_id = $user_logueado->getId();
  1772.         $newProductFile = new AveProductFileLocationNames();
  1773.         $newProductFile->setName($newRequest['name']);
  1774.         $newProductFile->setDescription($newRequest['description']);
  1775.         $newProductFile->setIdGpLounge(null);
  1777.         $newProductFile->setCreatedId($user_id);
  1778.         $newProductFile->setUpdatedId($user_id);
  1779.         $newProductFile->setCreatedAt(new \DateTime("now"));
  1780.         $newProductFile->setUpdatedAt(new \DateTime("now"));
  1782.         $em->persist($newProductFile);
  1783.         $em->flush();
  1785.         return $this->redirectToRoute('ave_list_productfilelocation');
  1786.     }
  1789.     /**
  1790.      * @Route("/productfilelocationlist/",  name="ave_list_productfilelocation")
  1791.      * Listar Ubicaciones para los productos
  1792.      */
  1793.     public function listProductFileLocationAction(Request $request){
  1794.         $em = $this->getDoctrine()->getManager();
  1795.         $productsLocation = $em->getRepository(AveProductFileLocationNames::class)->findAll();
  1797.         return $this->render('MDS/AvexpressBundle/Avexpress/list-productsfile-locationnames.html.twig',
  1798.             array(
  1799.                 'productsLocation' => $productsLocation,
  1800.             ));
  1801.     }
  1804.     /**
  1805.      * @Route("/productfilelocationedit/{id}",  name="ave_edit_productfilelocation")
  1806.      * Editar una Ubicacion
  1807.      */
  1808.     public function editProductFileLocationAction( $id, Request $request)
  1809.     {
  1810.         $em = $this->getDoctrine()->getManager();
  1811.         $editProductLocation = $em->getRepository(AveProductFileLocationNames::class)->findOneById($id);
  1813.         return $this->render('MDS/AvexpressBundle/Avexpress/edit-productsfiles-location.html.twig',
  1814.             array(
  1815.                 'id' => $editProductLocation->getId(),
  1816.                 'productLocation' => $editProductLocation,
  1817.             ));
  1818.     }
  1821.     /**
  1822.      * @Route("/productfilelocationupdate/",  name="ave_update_productfilelocation")
  1823.      * Update de una Ubicacion
  1824.      */
  1825.     public function updateProductFileLocationAction(Request $request)
  1826.     {
  1827.         $em = $this->getDoctrine()->getManager();
  1828.         $newRequest = $request->request->get('product');
  1829.         $id = $newRequest['id'];
  1830.         $newProduct = $em->getRepository(AveProductFileLocationNames::class)->findOneById($id);
  1832.         /* Obtengo usuario logueado */
  1833.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1834.         $user_id = $user_logueado->getId();
  1836.         if (!empty($newRequest['name'])){$newProduct->setName($newRequest['name']);}
  1838.         $newProduct->setDescription($newRequest['description']);
  1840.         $newProduct->setUpdatedId($user_id);
  1841.         $newProduct->setUpdatedAt(new \DateTime("now"));
  1843.         $em->persist($newProduct);
  1844.         $em->flush();
  1846.         return $this->redirectToRoute('ave_list_productfilelocation');
  1847.     }
  1850.     /**
  1851.      * @Route("/productfilelocationdelete/{id}",  name="ave_delete_productfilelocation")
  1852.      * Eliminar una Ubicacion
  1853.      */
  1854.     public function deleteProductAction($id, Request $request)
  1855.     {
  1856.         $em = $this->getDoctrine()->getManager();
  1857.         $delProduct = $em->getRepository(AveProductFileLocationNames::class)->findOneById($id);
  1859.         if (!empty($delProduct)){
  1860.             $em->remove($delProduct);
  1861.             $em->flush();
  1862.         }
  1864.         return $this->redirectToRoute('ave_list_productfilelocation');
  1865.     }
  1869.     // Replicar cambios entre FileController y ProductsFilesController
  1870.     private function calculosFile($id, $arrayBools, $number, $type)
  1871.     {
  1872.         // $id Id del Expediente (File)
  1873.         // $arrayBool arreglo de logicos
  1874.         // $number  *********************
  1875.         // $type tipo de calculos a realizar (edicion de expediente, factura, factura de deposito, proforma)
  1876.         
  1877.         
  1878.         $em = $this->getDoctrine()->getManager();
  1879.         $file = $em->getRepository(AveFiles::class)->findOneById($id);
  1880.         $items = $em->getRepository(AveProductFile::class)->findByFileId($file->getId());
  1881.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('3');
  1882.         $client = $em->getRepository(Client::class)->findById($file->getClient());
  1883.         if (!empty($client)){
  1884.             $city = ($em->getRepository(Cities::class)->findOneById($client[0]->getPopulation()));
  1885.             $client[0]->setPopulation($city);
  1886.             $region = ($em->getRepository(Regions::class)->findOneById($client[0]->getRegion()));
  1887.             $client[0]->setRegion($region);
  1888.             $country = ($em->getRepository(Country::class)->findOneById($client[0]->getCountry()));
  1889.             $client[0]->setCountry($country);
  1890.         } else {
  1891.             $client[0] = new Client();
  1892.             $client[0]->setName('');
  1893.             $client[0]->setTitle('');
  1894.             $client[0]->setIdDocument('');
  1895.             $client[0]->setPopulation('');
  1896.             $client[0]->setRegion('');
  1897.             $client[0]->setCountry('');
  1898.         }
  1900.         // Acumuladores de los calculos
  1901.         $totales_neto_all = 0;
  1902.         $data_iva = array(
  1903.             'iva' => 21,
  1904.             'ivaMontoVeintiUno' => 0,
  1905.             'ivaMontoDiez' => 0,
  1906.             'ivaMontoCero' => 0,
  1907.         );
  1909.         //INICIO: Determinamos el numero de factura o proforma
  1910.         if (substr($number,0,1) == 'I'){
  1911.             // Es una Factura
  1913.             $numberInvoiceOrProforma = substr($number,1);
  1914.             $number = $numberInvoiceOrProforma;
  1915.             $type = 'Invoice';
  1917.         } else {
  1918.             // Es una Proforma
  1920.             $numberInvoiceOrProforma = substr($number,1);
  1921.             $number = $numberInvoiceOrProforma;
  1922.             $type = 'Proforma';
  1923.         }
  1924.         //FIN: Determinamos el numero de factura o proforma
  1926.         // Buscamos las salas reservadas, pagos y servicios para el evento
  1928.         $arrayItems = array();
  1929.         $fileProducts = array();
  1930.         if (!empty($arrayBools['lounge'])) {
  1931.             foreach ($arrayBools['lounge'] as $key => $item) {
  1932.                 if ($item == 'true') {
  1933. //                    $fileProducts[] = $em->getRepository('DevelupBundle:ReservationLoungeSimple')->findOneById($key);
  1934.                 }
  1935.             }
  1936.         }
  1938.         $payments = array();
  1939.         if (!empty($arrayBools['payment'])) {
  1940.             foreach ($arrayBools['payment'] as $key => $item) {
  1941.                 if ($item == 'true') {
  1942. //                    $payments[] = $em->getRepository('DevelupBundle:ReservationPaymentsClient')->findOneById($key);
  1943.                 }
  1944.             }
  1945.         }
  1947.         $services = array();
  1948.         if (!empty($arrayBools['service'])) {
  1949.             foreach ($arrayBools['service'] as $key => $item) {
  1950.                 if ($item == 'true') {
  1951. //                    $services[] = $em->getRepository('DevelupBundle:ReservationService')->findOneById($key);
  1952.                 }
  1953.             }
  1954.         }
  1956.         $data_supplier = array();
  1957.         $i = 0;
  1959.         $iva = '21';            // Esteban Rincon: "Por Ley de localización del impuesto, siempre será un 21%"
  1960.         $pax = '-';
  1961.         $qty = '1';
  1962.         $product = array(
  1963.             'neto' => 0,
  1964.             'sumSubT' => 0,
  1965.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1967.         $service = array(
  1968.             'neto' => 0,
  1969.             'sumSubT' => 0,
  1970.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1972.         if (empty($items)){
  1973.             $data_supplier['product'][0] = null;
  1974.         }
  1976.         foreach ($items as $item){
  1978.             if (is_null($item->getServicePrice()) or empty($item->getServicePrice())){
  1979.                 $subtotal = 0;
  1980.                 $neto = 0;
  1981.                 $subtotalProduct = 0;
  1982.             } else {
  1984.                 $subtotalProduct = $item->getServicePrice() * 1.21;
  1985.                 $subneto = $item->getServicePrice();
  1987.                 $subtotal =  $subtotalProduct;
  1988.                 $neto =  $subneto;
  1990.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  1991.                 $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  1992.                 $neto = round($neto,2,PHP_ROUND_HALF_UP);
  1994.                 $arrayItems[] = array(
  1995.                     'type' => 'Product',
  1996.                     'name' => $item->getProductName(),
  1997.                     'amount' => $neto,
  1998.                     'iva' => '21',
  1999.                     'total' => $subtotal,
  2000.                 );
  2001.             }
  2003.             // Acumula netos totales e IVA
  2004.             $totales_neto_all = $totales_neto_all + $neto;
  2005.             $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * 0.21);
  2006.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2007.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  2008.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  2009.             // Acumula netos totales e IVA
  2011.             $product['neto'] = $product['neto'] + $neto;
  2012.             $product['sumSubT'] = $product['sumSubT'] + $subtotal;
  2013.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2014.             $product['neto'] = round($product['neto'],2,PHP_ROUND_HALF_UP);
  2015.             $product['sumSubT'] = round($product['sumSubT'],2,PHP_ROUND_HALF_UP);
  2017.             $data_supplier['product'][$i] = array (
  2018.                 'id' => $item->getId(),
  2019.                 'productName' => $item->getProductName(),
  2020.                 'description' => $item->getDescription(),
  2021.                 'productId' => $item->getProductId(),
  2022.                 'dateStart' => $item->getDateStart(),
  2023.                 'dateEnd' => $item->getDateEnd(),
  2024.                 'servicePrice' => $item->getServicePrice(),
  2025.                 'subtotalProduct' => $subtotalProduct,
  2026.                 'iva' => $iva,
  2027.                 'pax' => $pax,
  2028.                 'qty' => $qty,
  2029.                 'type' => $item->getType(),
  2030.                 'subtotal' => $subtotal,
  2031.             );
  2032.             $i++;
  2033.         }
  2035.         $data_supplier['productSubTotal'] = array(
  2036.             'neto' => $product['neto'],
  2037.             'sumSubT' => $product['sumSubT'],
  2038.         );
  2040.         $payment = array(
  2041.             'sumSubT' => 0,
  2042.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  2044.         $i = 0;
  2045.         foreach ($payments as $item){
  2047.             $payment['sumSubT'] = $payment['sumSubT'] + $item->getAmountTotal();
  2048.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2049.             $payment['sumSubT'] = round($payment['sumSubT'],2,PHP_ROUND_HALF_UP);
  2051.             $data_supplier['payment'][$i] = array (
  2052.                 'id' => $item->getId(),
  2053.                 'amount' => $item->getAmount(),
  2054.                 'amountTotal' => $item->getAmountTotal(),
  2055.                 'vat' => $item->getVat(),
  2056.                 'datePayAt' => $item->getDatePayAt(),
  2057.                 'wayToPay' => $item->getWayToPay(),
  2058.             );
  2060.             $arrayItems[] = array(
  2061.                 'type' => 'Payment',
  2062.                 'name' => $item->getWayToPay(),
  2063.                 'amount' => $item->getAmount(),
  2064.                 'total' => $item->getAmountTotal(),
  2065.                 'iva' => $item->getVat(),
  2066.             );
  2068.             $i++;
  2069.         }
  2071.         if (!empty($payments)) {
  2072.             $data_supplier['paymentSubTotal'] = array(
  2073.                 'sumSubT' => $payment['sumSubT'],
  2074.             );
  2075.         }
  2077.         foreach ($services as $item){
  2078.             if (is_null($item->getPrice()) or empty($item->getPrice())){
  2079.                 $subtotal = 0;
  2080.                 $neto = 0;
  2081.                 $subtotalService = 0;
  2083.             } else {
  2084.                 $subtotalService = $item->getPrice();
  2085.                 $subneto = $item->getPrice();
  2087.                 // Commission
  2088.                 if ($item->getOpCommission()=='1'){
  2089.                     $subtotalService = $subtotalService * (1 + ($item->getCommission()/100));
  2090.                     $subneto = $subneto  * (1 + ($item->getCommission()/100));
  2091.                 } else {
  2092.                     $subtotalService = $subtotalService * (1 - ($item->getCommission()/100));
  2093.                     $subneto = $subneto * (1 - ($item->getCommission()/100));
  2094.                 }
  2096.                 // Over
  2097.                 if ($item->getOpOver()=='1'){
  2098.                     $subtotalService = $subtotalService + $item->getOver();
  2099.                     $subneto = $subneto + $item->getOver();
  2100.                 } else {
  2101.                     $subtotalService = $subtotalService - $item->getOver();
  2102.                     $subneto = $subneto - $item->getOver();
  2103.                 }
  2105.                 // IVA
  2106.                 if ($item->getOpIva()=='1'){
  2107.                     $subtotalService = $subtotalService * (1 + ($item->getIva()/100));
  2108.                 } else {
  2109.                     $subtotalService = $item->getPrice();
  2110.                     $subneto = ($subneto * 100) / (100 + $item->getIva());
  2111.                 }
  2113.                 switch ($item->getServiceCatId()){
  2114.                     case 1: // Alojamiento
  2115.                         // el numero de noches $numNoches; precio unitario $subneto
  2116.                         $numNoches = (($item->getDateOutAt())->diff($item->getDateInAt()))->days;
  2117.                         // La personas no afectan este calculo
  2118.                         $subtotal = $subtotalService * $numNoches * $item->getUnits();
  2119.                         $subnetoUnit = $subneto;
  2121.                         $subneto = $subneto * $numNoches * $item->getUnits();
  2123.                         $data_supplier['service'][$i] = array (
  2124.                             'id' => $item->getId(),
  2125.                             'serviceCatId' => $item->getServiceCatId(),
  2126.                             'serviceName' => $item->getName(),
  2127.                             'serviceType' => 'Hotel',
  2128.                             'date' => ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y'),
  2129.                             'qty' => $item->getUnits(),
  2130.                             'iva' => $item->getIva(),
  2131.                             'pax' => '-',
  2132.                             'precioUnit' => $subnetoUnit,
  2133.                             'subneto' => $subneto,
  2134.                             'subtotal' => $subtotal,
  2135.                         );
  2136.                         break;
  2138.                     case 2: //Actividades
  2139.                         // El número de personas es considerado en el calculo
  2140.                         $pax = $item->getPax();
  2141.                         if (empty($pax) or $pax == "0") {
  2142.                             $pax = 1;
  2143.                         }
  2144.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2146.                         if ($days > 1){
  2147.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2148.                         } else {
  2149.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2150.                         }
  2152.                         $subtotal = $subtotalService * $days * $item->getUnits();
  2153.                         $subnetoUnit = $subneto;
  2154.                         $subneto = $subneto * $days * $item->getUnits();
  2156.                         $data_supplier['service'][$i] = array (
  2157.                             'id' => $item->getId(),
  2158.                             'serviceCatId' => $item->getServiceCatId(),
  2159.                             'serviceName' => $item->getName(),
  2160.                             'serviceType' => 'Actividad',
  2161.                             'date' => $dateServ,
  2162.                             'qty' => $item->getUnits(),
  2163.                             'iva' => $item->getIva(),
  2164.                             'pax' => $item->getPax(),
  2165.                             'precioUnit' => $subnetoUnit,
  2166.                             'subneto' => $subneto,
  2167.                             'subtotal' => $subtotal,
  2168.                         );
  2169.                         break;
  2171.                     case 3: // AV
  2172.                         $pax = $item->getPax();
  2173.                         if (empty($pax) or $pax == "0") {
  2174.                             $pax = 1;
  2175.                         }
  2177.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2178.                         if ($days > 1){
  2179.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2180.                         } else {
  2181.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2182.                         }
  2184.                         $unitsServ = $item->getUnits();
  2185.                         if (empty($unitsServ) or $unitsServ == "0") {
  2186.                             $unitsServ = 1;
  2187.                         }
  2189.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2190.                         $subnetoUnit = $subneto;
  2191.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2193.                         $data_supplier['service'][$i] = array (
  2194.                             'id' => $item->getId(),
  2195.                             'serviceCatId' => $item->getServiceCatId(),
  2196.                             'serviceName' => $item->getName(),
  2197.                             'serviceType' => 'AV',
  2198.                             'date' => $dateServ,
  2199.                             'qty' => $unitsServ,
  2200.                             'iva' => $item->getIva(),
  2201.                             'pax' => $item->getPax(),
  2202.                             'precioUnit' => $subnetoUnit,
  2203.                             'subneto' => $subneto,
  2204.                             'subtotal' => $subtotal,
  2205.                         );
  2206.                         break;
  2208.                     case 4: //Creative
  2209.                         $pax = $item->getPax();
  2210.                         if (empty($pax) or $pax == "0") {
  2211.                             $pax = 1;
  2212.                         }
  2214.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2215.                         if ($days > 1){
  2216.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2217.                         } else {
  2218.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2219.                         }
  2221.                         $unitsServ = $item->getUnits();
  2222.                         if (empty($unitsServ) or $unitsServ == "0") {
  2223.                             $unitsServ = 1;
  2224.                         }
  2226.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2227.                         $subnetoUnit = $subneto;
  2228.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2230.                         $data_supplier['service'][$i] = array (
  2231.                             'id' => $item->getId(),
  2232.                             'serviceCatId' => $item->getServiceCatId(),
  2233.                             'serviceName' => $item->getName(),
  2234.                             'serviceType' => 'Creativo',
  2235.                             'date' => $dateServ,
  2236.                             'qty' => $unitsServ,
  2237.                             'iva' => $item->getIva(),
  2238.                             'pax' => $item->getPax(),
  2239.                             'precioUnit' => $subnetoUnit,
  2240.                             'subneto' => $subneto,
  2241.                             'subtotal' => $subtotal,
  2242.                         );
  2243.                         break;
  2245.                     case 5: //Cruise
  2246.                         $pax = $item->getPax();
  2247.                         if (empty($pax) or $pax == "0") {
  2248.                             $pax = 1;
  2249.                         }
  2251.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days);
  2252.                         if ($days > 1){
  2253.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2254.                         } else {
  2255.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2256.                         }
  2258.                         $unitsServ = $item->getUnits();
  2259.                         if (empty($unitsServ) or $unitsServ == "0") {
  2260.                             $unitsServ = 1;
  2261.                         }
  2263.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2264.                         $subnetoUnit = $subneto;
  2265.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2267.                         $data_supplier['service'][$i] = array (
  2268.                             'id' => $item->getId(),
  2269.                             'serviceCatId' => $item->getServiceCatId(),
  2270.                             'serviceName' => $item->getName(),
  2271.                             'serviceType' => 'Crucero',
  2272.                             'date' => $dateServ,
  2273.                             'qty' => $unitsServ,
  2274.                             'iva' => $item->getIva(),
  2275.                             'pax' => $item->getPax(),
  2276.                             'precioUnit' => $subnetoUnit,
  2277.                             'subneto' => $subneto,
  2278.                             'subtotal' => $subtotal,
  2279.                         );
  2280.                         break;
  2282.                     case 6: //Entertaiment
  2283.                         $pax = $item->getPax();
  2284.                         if (empty($pax) or $pax == "0") {
  2285.                             $pax = 1;
  2286.                         }
  2288.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2289.                         if ($days > 1){
  2290.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2291.                         } else {
  2292.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2293.                         }
  2295.                         $unitsServ = $item->getUnits();
  2296.                         if (empty($unitsServ) or $unitsServ == "0") {
  2297.                             $unitsServ = 1;
  2298.                         }
  2300.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2301.                         $subnetoUnit = $subneto;
  2302.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2304.                         $data_supplier['service'][$i] = array (
  2305.                             'id' => $item->getId(),
  2306.                             'serviceCatId' => $item->getServiceCatId(),
  2307.                             'serviceName' => $item->getName(),
  2308.                             'serviceType' => 'Entretenimiento',
  2309.                             'date' => $dateServ,
  2310.                             'qty' => $unitsServ,
  2311.                             'iva' => $item->getIva(),
  2312.                             'pax' => $item->getPax(),
  2313.                             'precioUnit' => $subnetoUnit,
  2314.                             'subneto' => $subneto,
  2315.                             'subtotal' => $subtotal,
  2316.                         );
  2317.                         break;
  2319.                     case 7: // Gifts
  2320.                         $pax = $item->getPax();
  2321.                         if (empty($pax) or $pax == "0") {
  2322.                             $pax = 1;
  2323.                         }
  2325. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2326.                         $days = 1;
  2327.                         if ($days > 1){
  2328.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2329.                         } else {
  2330.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2331.                         }
  2333.                         $unitsServ = $item->getUnits();
  2334.                         if (empty($unitsServ) or $unitsServ == "0") {
  2335.                             $unitsServ = 1;
  2336.                         }
  2338.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2339.                         $subnetoUnit = $subneto;
  2340.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2342.                         $data_supplier['service'][$i] = array (
  2343.                             'id' => $item->getId(),
  2344.                             'serviceCatId' => $item->getServiceCatId(),
  2345.                             'serviceName' => $item->getName(),
  2346.                             'serviceType' => 'Regalos',
  2347.                             'date' => $dateServ,
  2348.                             'qty' => $unitsServ,
  2349.                             'iva' => $item->getIva(),
  2350.                             'pax' => $item->getPax(),
  2351.                             'precioUnit' => $subnetoUnit,
  2352.                             'subneto' => $subneto,
  2353.                             'subtotal' => $subtotal,
  2354.                         );
  2355.                         break;
  2357.                     case 8: //Guide
  2358.                         $pax = $item->getPax();
  2359.                         if (empty($pax) or $pax == "0") {
  2360.                             $pax = 1;
  2361.                         }
  2363.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2364.                         if ($days > 1){
  2365.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2366.                         } else {
  2367.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2368.                         }
  2370.                         $unitsServ = $item->getUnits();
  2371.                         if (empty($unitsServ) or $unitsServ == "0") {
  2372.                             $unitsServ = 1;
  2373.                         }
  2375.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2376.                         $subnetoUnit = $subneto;
  2377.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2379.                         $data_supplier['service'][$i] = array (
  2380.                             'id' => $item->getId(),
  2381.                             'serviceCatId' => $item->getServiceCatId(),
  2382.                             'serviceName' => $item->getName(),
  2383.                             'serviceType' => 'Regalos',
  2384.                             'date' => $dateServ,
  2385.                             'qty' => $unitsServ,
  2386.                             'iva' => $item->getIva(),
  2387.                             'pax' => $item->getPax(),
  2388.                             'precioUnit' => $subnetoUnit,
  2389.                             'subneto' => $subneto,
  2390.                             'subtotal' => $subtotal,
  2391.                         );
  2392.                         break;
  2394.                     case 9: //Itineraries
  2395.                         $pax = $item->getPax();
  2396.                         if (empty($pax) or $pax == "0") {
  2397.                             $pax = 1;
  2398.                         }
  2400.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2401.                         if ($days > 1){
  2402.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2403.                         } else {
  2404.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2405.                         }
  2407.                         $unitsServ = $item->getUnits();
  2408.                         if (empty($unitsServ) or $unitsServ == "0") {
  2409.                             $unitsServ = 1;
  2410.                         }
  2412.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2413.                         $subnetoUnit = $subneto;
  2414.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2416.                         $data_supplier['service'][$i] = array (
  2417.                             'id' => $item->getId(),
  2418.                             'serviceCatId' => $item->getServiceCatId(),
  2419.                             'serviceName' => $item->getName(),
  2420.                             'serviceType' => 'Itinerarios',
  2421.                             'date' => $dateServ,
  2422.                             'qty' => $unitsServ,
  2423.                             'iva' => $item->getIva(),
  2424.                             'pax' => $item->getPax(),
  2425.                             'precioUnit' => $subnetoUnit,
  2426.                             'subneto' => $subneto,
  2427.                             'subtotal' => $subtotal,
  2428.                         );
  2429.                         break;
  2431.                     case 10: //Lounge  -- No Aplica
  2432. //                        $pax = $item->getPax();
  2433. //                        if (empty($pax) or $pax == "0") {
  2434. //                            $pax = 1;
  2435. //                        }
  2436. //
  2437. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2438. //                        if ($days > 1){
  2439. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2440. //                        } else {
  2441. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2442. //                        }
  2443. //
  2444. //                        $unitsServ = $item->getUnits();
  2445. //                        if (empty($unitsServ) or $unitsServ == "0") {
  2446. //                            $unitsServ = 1;
  2447. //                        }
  2448. //
  2449. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2450. //                        $subnetoUnit = $subneto;
  2451. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  2452. //
  2453. //                        $data_supplier['service'][$i] = array (
  2454. //                            'id' => $item->getId(),
  2455. //                            'serviceCatId' => $item->getServiceCatId(),
  2456. //                            'serviceName' => $item->getName(),
  2457. //                            'serviceType' => 'Itinerarios',
  2458. //                            'date' => $dateServ,
  2459. //                            'qty' => $unitsServ,
  2460. //                            'iva' => $item->getIva(),
  2461. //                            'pax' => $item->getPax(),
  2462. //                            'precioUnit' => $subnetoUnit,
  2463. //                            'subneto' => $subneto,
  2464. //                            'subtotal' => $subtotal,
  2465. //                        );
  2466.                         break;
  2468.                     case 11: //Menu
  2469.                         $pax = $item->getPax();
  2470.                         if (empty($pax) or $pax == "0") {
  2471.                             $pax = 1;
  2472.                         }
  2474.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2475.                         if ($days > 1){
  2476.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2477.                         } else {
  2478.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2479.                         }
  2481.                         $unitsServ = $item->getUnits();
  2482.                         if (empty($unitsServ) or $unitsServ == "0") {
  2483.                             $unitsServ = 1;
  2484.                         }
  2486.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2487.                         $subnetoUnit = $subneto;
  2488.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2490.                         $data_supplier['service'][$i] = array (
  2491.                             'id' => $item->getId(),
  2492.                             'serviceCatId' => $item->getServiceCatId(),
  2493.                             'serviceName' => $item->getName(),
  2494.                             'serviceType' => 'Menú',
  2495.                             'date' => $dateServ,
  2496.                             'qty' => $unitsServ,
  2497.                             'iva' => $item->getIva(),
  2498.                             'pax' => $item->getPax(),
  2499.                             'precioUnit' => $subnetoUnit,
  2500.                             'subneto' => $subneto,
  2501.                             'subtotal' => $subtotal,
  2502.                         );
  2503.                         break;
  2505.                     case 12: //Others
  2506.                         $pax = $item->getPax();
  2507.                         if (empty($pax) or $pax == "0") {
  2508.                             $pax = 1;
  2509.                         }
  2511.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2512.                         if ($days > 1){
  2513.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2514.                         } else {
  2515.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2516.                         }
  2518.                         $unitsServ = $item->getUnits();
  2519.                         if (empty($unitsServ) or $unitsServ == "0") {
  2520.                             $unitsServ = 1;
  2521.                         }
  2523.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2524.                         $subnetoUnit = $subneto;
  2525.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2527.                         $data_supplier['service'][$i] = array (
  2528.                             'id' => $item->getId(),
  2529.                             'serviceCatId' => $item->getServiceCatId(),
  2530.                             'serviceName' => $item->getName(),
  2531.                             'serviceType' => 'Otros',
  2532.                             'date' => $dateServ,
  2533.                             'qty' => $unitsServ,
  2534.                             'iva' => $item->getIva(),
  2535.                             'pax' => $item->getPax(),
  2536.                             'precioUnit' => $subnetoUnit,
  2537.                             'subneto' => $subneto,
  2538.                             'subtotal' => $subtotal,
  2539.                         );
  2540.                         break;
  2542.                     case 13: //Transport
  2543.                         $pax = $item->getPax();
  2544.                         if (empty($pax) or $pax == "0") {
  2545.                             $pax = 1;
  2546.                         }
  2548.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2549.                         if ($days > 1){
  2550.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2551.                         } else {
  2552.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2553.                         }
  2555.                         $unitsServ = $item->getUnits();
  2556.                         if (empty($unitsServ) or $unitsServ == "0") {
  2557.                             $unitsServ = 1;
  2558.                         }
  2560.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2561.                         $subnetoUnit = $subneto;
  2562.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2564.                         $data_supplier['service'][$i] = array (
  2565.                             'id' => $item->getId(),
  2566.                             'serviceCatId' => $item->getServiceCatId(),
  2567.                             'serviceName' => $item->getName(),
  2568.                             'serviceType' => 'Transporte',
  2569.                             'date' => $dateServ,
  2570.                             'qty' => $unitsServ,
  2571.                             'iva' => $item->getIva(),
  2572.                             'pax' => $item->getPax(),
  2573.                             'precioUnit' => $subnetoUnit,
  2574.                             'subneto' => $subneto,
  2575.                             'subtotal' => $subtotal,
  2576.                         );
  2577.                         break;
  2579.                     case 14: //Technology
  2580.                         $pax = $item->getPax();
  2581.                         if (empty($pax) or $pax == "0") {
  2582.                             $pax = 1;
  2583.                         }
  2585. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2586.                         $days = 1;
  2587. //                        if ($days > 1){
  2588. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2589. //                        } else {
  2590. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2591. //                        }
  2592.                         $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2594.                         $unitsServ = $item->getUnits();
  2595.                         if (empty($unitsServ) or $unitsServ == "0") {
  2596.                             $unitsServ = 1;
  2597.                         }
  2599.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2600.                         $subnetoUnit = $subneto;
  2601.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2603.                         $data_supplier['service'][$i] = array (
  2604.                             'id' => $item->getId(),
  2605.                             'serviceCatId' => $item->getServiceCatId(),
  2606.                             'serviceName' => $item->getName(),
  2607.                             'serviceType' => 'Tecnología',
  2608.                             'date' => $dateServ,
  2609.                             'qty' => $unitsServ,
  2610.                             'iva' => $item->getIva(),
  2611.                             'pax' => $item->getPax(),
  2612.                             'precioUnit' => $subnetoUnit,
  2613.                             'subneto' => $subneto,
  2614.                             'subtotal' => $subtotal,
  2615.                         );
  2616.                         break;
  2618.                     case 15: //Assisstant
  2619.                         $pax = $item->getPax();
  2620.                         if (empty($pax) or $pax == "0") {
  2621.                             $pax = 1;
  2622.                         }
  2624.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2625.                         if ($days > 1){
  2626.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2627.                         } else {
  2628.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2629.                         }
  2631.                         $unitsServ = $item->getUnits();
  2632.                         if (empty($unitsServ) or $unitsServ == "0") {
  2633.                             $unitsServ = 1;
  2634.                         }
  2636.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2637.                         $subnetoUnit = $subneto;
  2638.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2640.                         $data_supplier['service'][$i] = array (
  2641.                             'id' => $item->getId(),
  2642.                             'serviceCatId' => $item->getServiceCatId(),
  2643.                             'serviceName' => $item->getName(),
  2644.                             'serviceType' => 'Asistente',
  2645.                             'date' => $dateServ,
  2646.                             'qty' => $unitsServ,
  2647.                             'iva' => $item->getIva(),
  2648.                             'pax' => $item->getPax(),
  2649.                             'precioUnit' => $subnetoUnit,
  2650.                             'subneto' => $subneto,
  2651.                             'subtotal' => $subtotal,
  2652.                         );
  2653.                         break;
  2655.                     case 16: //DDR
  2656.                         $pax = $item->getPax();
  2657.                         if (empty($pax) or $pax == "0") {
  2658.                             $pax = 1;
  2659.                         }
  2661.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2662.                         if ($days > 1){
  2663.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2664.                         } else {
  2665.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2666.                         }
  2668.                         $unitsServ = $item->getUnits();
  2669.                         if (empty($unitsServ) or $unitsServ == "0") {
  2670.                             $unitsServ = 1;
  2671.                         }
  2673.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2674.                         $subnetoUnit = $subneto;
  2675.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2677.                         $data_supplier['service'][$i] = array (
  2678.                             'id' => $item->getId(),
  2679.                             'serviceCatId' => $item->getServiceCatId(),
  2680.                             'serviceName' => $item->getName(),
  2681.                             'serviceType' => 'DDR',
  2682.                             'date' => $dateServ,
  2683.                             'qty' => $unitsServ,
  2684.                             'iva' => $item->getIva(),
  2685.                             'pax' => $item->getPax(),
  2686.                             'precioUnit' => $subnetoUnit,
  2687.                             'subneto' => $subneto,
  2688.                             'subtotal' => $subtotal,
  2689.                         );
  2690.                         break;
  2692.                     default:
  2693.                         break;
  2694.                 }
  2696.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  2697.                 $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  2698.                 $neto = round($subneto,2,PHP_ROUND_HALF_UP);
  2700.                 $arrayItems[] = array(
  2701.                     'type' => 'Service',
  2702.                     'name' => $item->getName(),
  2703.                     'amount' => $neto,
  2704.                     'iva' => $item->getIva(),
  2705.                     'total' => $subtotal,
  2706.                 );
  2708.             }
  2710.             switch ($item->getIva()){
  2711.                 // Acumula IVA
  2712.                 case 21:
  2713.                     $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getIva()/100));
  2714.                     break;
  2716.                 case 10:
  2717.                     $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getIva()/100));
  2718.                     break;
  2720.                 case 0:
  2721.                     break;
  2723.                 default:
  2724.                     break;
  2726.             }
  2728.             $totales_neto_all = $totales_neto_all + $neto;
  2730.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2731.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  2732.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  2733.             $data_iva['ivaMontoDiez'] = round($data_iva['ivaMontoDiez'],2,PHP_ROUND_HALF_UP);
  2734.             // Acumula netos totales e IVA
  2736.             $service['neto'] = $service['neto'] + $neto;
  2737.             $service['sumSubT'] = $service['sumSubT'] + $subtotal;
  2738.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2739.             $service['neto'] = round($service['neto'],2,PHP_ROUND_HALF_UP);
  2740.             $service['sumSubT'] = round($service['sumSubT'],2,PHP_ROUND_HALF_UP);
  2742.             $i++;
  2743.         }
  2745.         $data_supplier['serviceSubTotal'] = array(
  2746.             'neto' => $service['neto'],
  2747.             'sumSubT' => $service['sumSubT'],
  2748.         );
  2749.         $currency = '€';
  2750.         $totales_total = $totales_neto_all + $data_iva['ivaMontoVeintiUno'] + $data_iva['ivaMontoDiez'];
  2751.         if (!empty($payments)) {
  2752.             $amount_pay = $data_supplier['paymentSubTotal']['sumSubT'];
  2753.         } else {
  2754.             $amount_pay = 0;
  2755.         }
  2756.         $totales_all = $totales_total - $amount_pay;
  2758.         if ($type == 'Invoice'){
  2759.             $em->clear();   // sin este clear se producia error al guardar
  2760.             $newInvoice = $em->getRepository(ReservationInvoice::class)->findOneById($numberInvoiceOrProforma);
  2761.             $newInvoice->setBalance($totales_all);
  2762.             $em->persist($newInvoice);
  2763.             $em->flush();
  2764.         }
  2766.         $data = array(
  2767.             'id' => $id,
  2768.             'type' => $type,
  2769.             'number' => $number,
  2770.             'prefix' => 'GPF-'.(new DateTime('now'))->format('dmy').'-',
  2771.             'date' => new DateTime('now'),
  2772.             'file' => $file,
  2773. //            'token' => $reservation->getAccessKey(),
  2774.             'company' => $company,
  2775.             'clients' => $client,
  2776.             'arrayItems' => $arrayItems,
  2777.             'datasupplier' => $data_supplier,
  2778.             'currency' => $currency,
  2779.             'totales_neto' => $totales_neto_all,
  2780.             'bases_imponibles' => $data_iva,
  2781.             'totales' => $totales_total,
  2782.             'balance' => $totales_all,
  2783.             'paymentInvoice' => $amount_pay,
  2784.         );
  2786.         return $data;
  2787.     }
  2789.     private function obtenerRankAv($id)
  2790.     {
  2791.         // $id Id del Expediente (File)
  2792.         $em = $this->getDoctrine()->getManager();
  2793.         $items = $em->getRepository(AveProductFile::class)->findByFileId($id);
  2795.         if (empty($items)){ $num = 1; } else { $num = sizeof($items) + 1; }
  2796.         $data = $num;
  2798.         return $data;
  2799.     }
  2801.     private function obtenerFechas($id, $dateStart, $dateEnd)
  2802.     {
  2803.         // $id Id del Expediente (File)
  2804.         // $dateStart Fecha de inicio (Producto)
  2805.         // $dateEnd Fecha de fin (Producto)
  2807.         $em = $this->getDoctrine()->getManager();
  2808.         $file = $em->getRepository(AveFiles::class)->findOneById($id);
  2810.         if (empty($dateStart)){ $newDateStart = $file->getDateStart(); } else { $newDateStart = $dateStart; }
  2811.         if (empty($dateEnd)){ $newDateEnd = $file->getDateEnd(); } else { $newDateEnd = $dateEnd; }
  2813.         $data = array(
  2814.             'dateStart' => $newDateStart,
  2815.             'dateEnd' => $newDateEnd,
  2816.         );
  2818.         return $data;
  2819.     }
  2821.     private function sendTelegram( $id, $text )
  2822.     {
  2823.         $em = $this->getDoctrine()->getManager();
  2824.         $telegUser = $em->getRepository(MdvTelegramUser::class)->findOneByUserId($id);
  2826.         if (empty($telegUser)){return true;}
  2828.         $parameters = array(
  2829.             'chat_id' => $telegUser->getChatId(),
  2830.             'text' => $text,
  2831.         );
  2833.         $bot_token = $telegUser->getBotToken();
  2834.         $url = "https://api.telegram.org/bot$bot_token/sendMessage";
  2836.         if (!$curl = curl_init()){
  2837.             exit();
  2838.         }
  2840.         curl_setopt($curl,CURLOPT_POST,true);
  2841.         curl_setopt($curl,CURLOPT_POSTFIELDS,$parameters);
  2842.         curl_setopt($curl,CURLOPT_URL,$url);
  2843.         curl_setopt($curl,CURLOPT_RETURNTRANSFER,true);
  2844.         $output = curl_exec($curl);
  2845.         curl_close($curl);
  2847.         return true;
  2848.     }
  2850.     private function addProductFileToProforma( $fileId, $newProductId, $proformaId )
  2851.     {
  2852.         $em = $this->getDoctrine()->getManager();
  2853.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  2854.         $productFile = $em->getRepository(AveProductFile::class)->findOneById($newProductId);
  2855.         $proforma = $em->getRepository(AveDocProforma::class)->findOneById($proformaId);
  2857.         if (!empty($file) and !empty($productFile) and !empty($proforma) ){
  2858.             $newProformaItem = new AveDocProformaItems();
  2859.             $newProformaItem->setControlId($newProductId);
  2860.             $newProformaItem->setType('PRODUCT');
  2861.             $newProformaItem->setFileId($fileId);
  2862.             $newProformaItem->setProformaId($proformaId);
  2864.             $em->persist($newProformaItem);
  2865.             $em->flush();
  2867.             return true;
  2868.         } else {
  2869.             return false;
  2870.         }
  2871.     }
  2873.     private function precioPorVariacionDeDias ($supplierService, $productFile){
  2874.         $em = $this->getDoctrine()->getManager();
  2876.         // El precio unitario debe ser dividido en funcion de los dias que tiene InOut y no en funcion de los dias de Av Express
  2877.         $days = ($supplierService->getDateOutAt()->diff($supplierService->getDateInAt())->days)===0 ? 1 : $supplierService->getDateOutAt()->diff($supplierService->getDateInAt())->days +1;
  2878.         if (array_key_exists('productFileId',$productFile)){
  2879.             // En el GridTwo viene es un arreglo no la entidad
  2880.             $productInFile = $em->getRepository(AveProductFile::class)->findOneById($productFile['productFileId']);
  2881.             $newPrice = $productInFile->getSubTotalPrice() / ( $days );
  2882.         } else {
  2883.             $newPrice = $productFile->getSubTotalPrice() / ( $days );
  2884.         }
  2886.         $newPrice = $newPrice / $supplierService->getUnits();
  2887.         $newPrice = round($newPrice,2,PHP_ROUND_HALF_UP);
  2889.         return $newPrice;
  2890.     }
  2892.     private function messageOfChangesToAgent($message, $proposalId){
  2893.         // $message mensaje a enviar a los agentes del proposal
  2894.         if ($proposalId  == 0){ return true; }
  2895.         $em = $this->getDoctrine()->getManager();
  2896.         $proposal = $em->getRepository(Proposal::class)->findOneById($proposalId);
  2898.         /* Obtengo usuario logueado */
  2899.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  2900.         $user_id = $user_logueado->getId();
  2901.         $agent = $em->getRepository(User::class)->findOneById($user_id);
  2903.         $message = 'El proposal <strong>#'.$proposalId.' '.$proposal->getName().'</strong>'.' ha sido modificacdo por el agente: '.$agent->getName().' '.$agent->getLastName().'<br><br><br>'.$message;
  2904.         $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposalId);
  2905.         $mailArrayTo = array();
  2906.         if (!empty($agent)){ $mailArrayTo[$agent->getEmail()] = $agent->getEmail(); }
  2907.         if (!empty($proposalAgents)){
  2908.             if (!empty($proposalAgents->getAgOne())){
  2909.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgOne());
  2910.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2911.             }
  2913.             if (!empty($proposalAgents->getAgTwo())){
  2914.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgTwo());
  2915.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2916.             }
  2918.             if (!empty($proposalAgents->getAgThree())){
  2919.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgThree());
  2920.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2921.             }
  2923.             if (!empty($proposalAgents->getAgFour())){
  2924.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgFour());
  2925.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2926.             }
  2927.         }
  2929.         if (!empty($mailArrayTo)){
  2930.             $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  2931.             $replyTo = array();
  2932.             foreach ($mailArrayTo as $item){ $replyTo[$item] = $item; }
  2934.             $agentMail = $agent->getEmail();
  2936.             //Se prepara el correo con los agentes a notificar
  2937.             $firmGmail = $agent->getFirmGmail();
  2938.             $data = array(
  2939.                 'body' => $message,
  2940.                 'firm' => $firmGmail,
  2941.             );
  2943.             // EJECUTAR ENVIO DE ALERTA PARA EL AGENTE
  2944.             $transporter = new Swift_SmtpTransport();
  2945.             $transporter->setHost('smtp.gmail.com')
  2946.                 ->setEncryption('ssl')//ssl / tls
  2947.                 ->setPort(465)// 465 / 587
  2948.                 ->setUsername('desarrollo@develup.solutions')
  2949.                 ->setPassword('utvh hzoi wfdo ztjs');
  2950.             $mailer = new Swift_Mailer($transporter);
  2952.             $message = new Swift_Message();
  2953.             $message->setSubject('Actualización de servicios AvExpress del proposal: '. $proposalId)
  2954.                 ->setSender($agentMail)
  2955.                 ->setFrom(array("desarrollo@develup.solutions" => "System Mante 3.0"))
  2956.                 ->setReplyTo($agentMail)
  2957.                 ->setTo($replyTo)
  2958.                 ->setBody(
  2959.                     $this->renderView(
  2960.                         'mail/structure-mail.html.twig',
  2961.                         array('data' => $data)
  2962.                     ),
  2963.                     'text/html'
  2964.                 );
  2965.             $mailer->send($message);
  2966.         }
  2968.         return true;
  2969.     }
  2971. };