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