src/MDS/AvexpressBundle/Controller/FilesController.php line 727

Open in your IDE?
  1. <?php
  3. namespace App\MDS\AvexpressBundle\Controller;
  5. use App\Constants\BusinessTypeSettingsCompanyConstants;
  6. use App\Entity\Cities;
  7. use App\Entity\Client;
  8. use App\Entity\Configuration;
  9. use App\Entity\Country;
  10. use App\Entity\Destination;
  11. use App\Entity\Regions;
  12. use App\Entity\SettingsCompany;
  13. use App\Entity\User;
  14. use App\Entity\HtFile;
  15. use App\MDS\AvexpressBundle\Entity\AveBenefitsSupplier;
  16. use App\MDS\AvexpressBundle\Entity\AveBriefings;
  17. use App\MDS\AvexpressBundle\Entity\AveBudgetPending;
  18. use App\MDS\AvexpressBundle\Service\AvexpressCalculatorService;
  19. use App\MDS\VenuesBundle\Entity\Reservation;
  20. use App\MDS\VenuesBundle\Entity\ReservationLoungeSimple;
  21. use Doctrine\ORM\EntityManagerInterface;
  22. use Symfony\Component\Routing\Annotation\Route;
  23. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  24. use Symfony\Component\HttpFoundation\Request;
  25. use DateTime;
  26. use App\MDS\AvexpressBundle\Entity\AveFiles;
  27. use App\MDS\AvexpressBundle\Entity\AveBudgetToProforma;
  28. use App\MDS\AvexpressBundle\Entity\AveDocInvoice;
  29. use App\MDS\AvexpressBundle\Entity\AveDocInvoiceItems;
  30. use App\MDS\AvexpressBundle\Entity\AveDocInvoiceRec;
  31. use App\MDS\AvexpressBundle\Entity\AveDocInvoiceRecItems;
  32. use App\MDS\AvexpressBundle\Entity\AveDocProforma;
  33. use App\MDS\AvexpressBundle\Entity\AveDocProformaItems;
  34. use App\MDS\AvexpressBundle\Entity\AvePaymentsClient;
  35. use App\MDS\AvexpressBundle\Entity\AveProduct;
  36. use App\MDS\AvexpressBundle\Entity\AveProductFile;
  37. use App\MDS\AvexpressBundle\Entity\AveServices;
  38. use App\MDS\EventsBundle\Entity\Proposal;
  39. use App\MDS\EventsBundle\Entity\ProposalAgents;
  40. use App\MDS\EventsBundle\Entity\ProposalInvoice;
  41. use App\MDS\EventsBundle\Entity\ProposalSupplierControl;
  42. use App\MDS\EventsBundle\Entity\ProposalSupplierServices;
  43. use App\MDS\AvexpressBundle\Repository\AveProductFileRepository;
  44. use Swift_Mailer;
  45. use Swift_Message;
  46. use Swift_SmtpTransport;
  47. use Symfony\Contracts\Translation\TranslatorInterface;
  51. class FilesController extends AbstractController
  52. {
  53.     private $translator;
  55.     public function __construct(TranslatorInterface $translator) {
  56.         $this->translator = $translator;
  57.     }
  58.     
  59.     /**
  60.      * @Route("/fileadd/",  name="ave_add_file")
  61.      * Agregar un expediente
  62.      */
  63.     public function addFileAction( Request $request)
  64.     {
  65.         $em = $this->getDoctrine()->getManager();
  66.         $clients = $em->getRepository(Client::class)->findAll();
  67.         $destinations = $em->getRepository(Destination::class)->findAll();
  68.         $aveFiles = $em->getRepository(AveFiles::class)->findAll();
  69.         $id =0;
  70.         if (empty($aveFiles)){
  71.             $id ++;
  72.         } else {
  73.             $lastElem = end($aveFiles);
  74.             $id = $lastElem->getId() + 1;
  76.         }
  78.         return $this->render('MDS/AvexpressBundle/Avexpress/add-files.html.twig',
  79.             array(
  80.                 'id' => $id,
  81.                 'clients' => $clients,
  82.                 'destinations' => $destinations,
  83.                 'clientId' => 0,
  84.             ));
  85.     }
  87.     /**
  88.      * @Route("/filelist/",  name="ave_list_file")
  89.      * Listar expedientes
  90.      */
  91.     public function listFileAction(Request $request, EntityManagerInterface $em)
  92.     {
  93.         $reservasRaw = $em->getRepository(AveFiles::class)->findAllOptimizedForList();
  95.         $reservas = [];
  96.         foreach ($reservasRaw as $res) {
  97.             $ref = '';
  98.             if ($res['dateStart'] instanceof \DateTimeInterface && $res['dateEnd'] instanceof \DateTimeInterface) {
  99.                 $ref = '#' . $res['dateStart']->format('ymd') . $res['dateEnd']->format('ymd');
  100.             } else {
  101.                 $ref = '#000000000000';
  102.             }
  104.             $reservas[] = [
  105.                 'id'            => $res['id'],
  106.                 'title'         => $res['title'],
  107.                 'client'        => $res['clientName'] ?? 'N/A',
  108.                 'dateStart'     => $res['dateStart'],
  109.                 'dateEnd'       => $res['dateEnd'],
  110.                 'createdId'     => $res['createdId'],
  111.                 'ref'           => $ref,
  112.                 'reservation'   => $res['reservation_id'],
  113.             ];
  114.         }
  116.         return $this->render('MDS/AvexpressBundle/Avexpress/list-files.html.twig', [
  117.             'listofdeletedfiles' => false,
  118.             'reservations'       => $reservas
  119.         ]);
  120.     }
  123.     /**
  124.      * @Route("/filesave/",  name="ave_save_file")
  125.      * Guardar un expediente nuevo
  126.      */
  127.     public function saveFileAction( Request $request)
  128.     {
  129.         $em = $this->getDoctrine()->getManager();
  130.         $newRequest = $request->request->get('avexpress');
  131.         if (empty($newRequest['title'])){ return $this->redirectToRoute('ave_add_file'); }
  133.         /* Obtengo usuario logueado */
  134.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  135.         $user_id = $user_logueado->getId();
  137.         $newFile = new AveFiles();
  138.         $newFile->setTitle($newRequest['title']);
  139.         $newFile->setClient($newRequest['client']);
  140.         if (!empty($newRequest['idProposal'])){
  141.             $newFile->setIdProposal($newRequest['idProposal']);
  142.         } else {
  143.             $newFile->setIdProposal(null);
  144.         }
  145.         $newFile->setStatus($newRequest['status']);
  146.         $newFile->setAdvancePayment($newRequest['advancePayment']);
  147.         $newFile->setDescription($newRequest['description']);
  148.         if (empty($newRequest['dateStart'])){
  149.             $newFile->setDateStart(new \DateTime("now"));
  150.         } else {
  151.             $newFile->setDateStart(new \DateTime($newRequest['dateStart']));}
  152.         if (empty($newRequest['dateEnd'])){
  153.             $newFile->setDateEnd(new \DateTime("now"));
  154.         } else {
  155.             $newFile->setDateEnd(new \DateTime($newRequest['dateEnd']));}
  157.         if (!empty($newRequest['destination'])){
  158.             $newFile->setDestinoId($newRequest['destination']);
  159.         }
  161.         $newFile->setCreatedId($user_id);
  162.         $newFile->setUpdatedId($user_id);
  163.         $newFile->setCreatedAt(new \DateTime("now"));
  164.         $newFile->setUpdatedAt(new \DateTime("now"));
  166.         $em->persist($newFile);
  167.         $em->flush();
  169.         $sumatoriaTotalNet = 0;
  170.         $sumatoriaTotalVat = 0;
  171.         $sumatoriaTotal = 0;
  173.         $resultados = array(
  174.             'totalNeto' => $sumatoriaTotalNet,
  175.             'vat' => $sumatoriaTotalVat,
  176.             'total' => $sumatoriaTotal,
  178.         );
  180.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($newFile->getId());
  181.         $numeroItems = sizeof($productInFile);
  183.         return $this->redirectToRoute('ave_edit_file', array( 'id' => $newFile->getId() ));
  184.     }
  186.     /**
  187.      * @Route("/fileupdate/{id}",  name="ave_update_file")
  188.      * Actualizar un expediente
  189.      */
  190.     public function updateFileAction($id, Request $request)
  191.     {
  192.         $logTelegram = false;
  193.         $numberToPrefix = 0;
  194.         $em = $this->getDoctrine()->getManager();
  195.         $newFile = $em->getRepository(AveFiles::class)->findOneById($id);
  196.         $newRequest = $request->request->get('avexpress');
  197.         $srvInconsistentes = '';                    // Mensaje de alerta por inconsistencia en los servicios
  199.         // INICIO: Si existe un documento creado no se puede cambiar el cliente
  200.         $oldDoc = $em->getRepository(AveDocInvoice::class)->findOneByFileId($id);
  201.         $noexistefactura = empty($oldDoc);
  202.         // FIN: Si existe un documento creado no se puede cambiar el cliente
  204.         /* Obtengo usuario logueado */
  205.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  206.         $user_id = $user_logueado->getId();
  208.         if (!empty($newRequest['title'])){$newFile->setTitle($newRequest['title']);}
  209.         if ($noexistefactura)
  210.             {
  211.                 $newFile->setClient($newRequest['client']);
  212.                 $msjErrorClt = '';
  213.             }
  214.         else
  215.             { /* Hay una factura, no se debe cambiar el cliente */
  216.                 // Verificamos si intenta cambiar el cliente para informar que no es posible hacerlo
  217.                 if (!($newFile->getClient() == $newRequest['client'])){
  218.                     $msjErrorClt = 'El cliente no puede ser modificado, ya existe una factura previa';
  219.                 } else {
  220.                     $msjErrorClt = '';
  221.                 }
  222.             }
  224.         if (!empty($newRequest['idProposal'])){$newFile->setIdProposal($newRequest['idProposal']);} else {$newFile->setIdProposal(null);}
  226.         $newFile->setStatus($newRequest['status']);
  227.         $newFile->setDescription($newRequest['description']);
  228.         $newFile->setUpdatedId($user_id);
  229.         $newFile->setUpdatedAt(new \DateTime("now"));
  231.         if (!empty($newRequest['destination'])){$newFile->setDestinoId($newRequest['destination']);}
  232.         if (!empty($newRequest['dateStart'])){$newFile->setDateStart(new DateTime($newRequest['dateStart']));}
  233.         if (!empty($newRequest['dateEnd'])){$newFile->setDateEnd(new DateTime($newRequest['dateEnd']));}
  234.         if (!empty($newRequest['xtraFieldOne'])){$newFile->setXtraFieldOne($newRequest['xtraFieldOne']);}
  236.         try{
  237.             $em->persist($newFile);
  238.             $em->flush();
  239.             $event = 'El expediente ha sido actualizado. ';
  241.             if (!empty($msjErrorClt)){ $event = $event.$msjErrorClt; }
  243.             $successMessage = $this->translator->trans($event);
  244.             $this->addFlash('mensajeav', $successMessage);
  246.         } catch (\Exception $e){
  248.             $event = 'An error occurred: '.$e->getMessage();
  250.             /* Para el usuario */
  251.             $errorMessage = $this->translator->trans($event);
  252.             $this->addFlash('mensajeaverror', $errorMessage);
  253.         }
  255.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($newFile->getId());
  256.         $txtWarning = '';
  257.         if(!empty($newFile->getIdProposal())){
  258.             // El expediente se ha relacionado con un proposal, se debe actualizar en eventos
  259.             $file = $newFile;
  260.             // Si hay proposal se debe actualizar en el expediente de Eventos
  261.             if (!empty($file->getIdProposal()) and is_numeric($file->getIdProposal())){
  262.                 // Buscamos el destino donde se encuentre Avexpress y ahi agregamos el servicio, si no se encuentra no se agregara el servicio
  263.                 $control = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  264.                     array(
  265.                         'supplierId' => 80,                                          // El supplier 80 es Avexpress
  266.                         'proposalId' => $file->getIdProposal(),
  267.                     )
  268.                 );
  269.                 // INICIO: Buscamos la info del lado de eventos (SINCRONIZACION)
  270.                 $txtOfChanges = ''; //Mensaje para el agente de cambios en los servicios hechos desde AvExpress
  271.                 $proposal = $em->getRepository(Proposal::class)->findOneById($file->getIdProposal());
  272.                 $agent = $em->getRepository(User::class)->findOneById($proposal->getAgentId());
  273.                 $agentFullName = $agent->getName().' '.$agent->getLastName();
  274.                 $proposalTitle = $proposal->getId().' - '.$proposal->getTitle();
  275.                 // FIN: Buscamos la info del lado de eventos
  277.                 foreach ($productInFile as $item){
  278.                     //Si las fechas de inicio y fin no coinciden con el campo dias se debe enviar alerta
  279.                     $txtWarning = ($item->getDateOutAt()->diff($item->getDateInAt()))->days + 1 <> $item->getDays() ? '<br>'.$item->getProductName() : '';
  280.                     if (!empty($txtWarning)){
  281.                         if (empty($srvInconsistentes)){ $srvInconsistentes = 'Hay inconsistencias en: '.'<br>'.$txtWarning; } else { $srvInconsistentes = $srvInconsistentes.'<br>'.$txtWarning; }
  282.                     }
  284.                     if (!empty($control)){
  285.                         // Existe un destino con AvExpress como proveedor, ahí se agregara el servicio
  287.                         $yaexistiaunservicio = false; $proposalServicex = null;
  288.                         // Se verifica que no el productfile Av no tenga imagen en Eventos
  289.                         if (!empty($item->getOriginId())){
  290.                             // Se verifica que aun exista en Eventos  el servicio
  291.                             $proposalServicex = $em->getRepository(ProposalSupplierServices::class)->findOneById($item->getOriginId());
  292.                             if (!empty($proposalServicex)){ $yaexistiaunservicio = true; } else { $yaexistiaunservicio = false; }
  294.                         } else {
  295.                             // no estaba relacionado con nada en eventos, se crea uno nuevo
  296.                             $yaexistiaunservicio = false;
  297.                         }
  299.                         if ($yaexistiaunservicio){
  300.                             $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($file->getIdProposal());
  301.                             if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  302.                                 $service = $proposalServicex;
  303.                                 $oldServiceEvent = array(
  304.                                     'activityId' => $service->getActivityId(),
  305.                                     'assistantId' => $service->getAssistantId(),
  306.                                     'breakdown' => $service->getBreakdown(),
  307.                                     'commission' => $service->getCommission(),
  308.                                     'controlId' => $service->getControlId(),
  309.                                     'currency' => $service->getCurrency(),
  310.                                     'dateBlockLimit' => $service->getDateBlockLimit(),
  311.                                     'dateInAt' => $service->getDateInAt(),
  312.                                     'dateOutAt' => $service->getDateOutAt(),
  313.                                     'destinationId' => $service->getDestinationId(),
  314.                                     'directPayment' => $service->getDirectPayment(),
  315.                                     'hour' => $service->getHour(),
  316.                                     'ideaId' => $service->getIdeaId(),
  317.                                     'isFather' => $service->getIsFather(),
  318.                                     'iva' => $service->getIva(),
  319.                                     'name' => $service->getName(),
  320.                                     'opCommission' => $service->getOpCommission(),
  321.                                     'opIva' => $service->getOpIva(),
  322.                                     'opOver' => $service->getOpOver(),
  323.                                     'originalIva' => $service->getOriginalIva(),
  324.                                     'originalPrice' => $service->getOriginalPrice(),
  325.                                     'originalopIva' => $service->getOriginalopIva(),
  326.                                     'over' => $service->getOver(),
  327.                                     'pax' => $service->getPax(),
  328.                                     'preCommission' => $service->getPreCommission(),
  329.                                     'preIva' => $service->getPreIva(),
  330.                                     'price' => $service->getPrice(),
  331.                                     'proposalId' => $service->getProposalId(),
  332.                                     'rankquote' => $service->getRankQuote(),
  333.                                     'serviceCatId' => $service->getServiceCatId(),
  334.                                     'serviceCatName' => $service->getServiceCatName(),
  335.                                     'serviceId' => $service->getServiceId(),
  336.                                     'serviceIdFather' => $service->getServiceIdFather(),
  337.                                     'status' => $service->getStatus(),
  338.                                     'statusRec' => $service->getStatusRec(),
  339.                                     'statusinternal' => $service->getStatusinternal(),
  340.                                     'supplierId' => $service->getSupplierId(),
  341.                                     'units' => $service->getUnits(),
  342.                                 );
  343.                                 $service->setName($item->getProductName());
  345.                                 // Se verifican los precios en ambas partes (AV Express e InOut)
  346.                                 if (!($service->getPrice() == $item->getServicePrice())) {
  347.                                     // Si ambos precios unitarios son distintos se ha modificado el numero de días en Av Express
  348.                                     $newPriceInOut = $this->precioPorVariacionDeDias($service, $item);
  349.                                     $service->setPrice($newPriceInOut);
  350.                                 } else {
  351.                                     // si son iguales tambien se deben verificar el numero de dias
  352.                                     if (!(($service->getDateOutAt()->diff($service->getDateInAt())->days + 1) == $item->getDays())) {
  353.                                         $newPriceInOut = $this->precioPorVariacionDeDias($service, $item);
  354.                                         $service->setPrice($newPriceInOut);
  355.                                     }
  356.                                 }
  358.                                 $service->setCurrency($item->getCurrency());
  359.                                 $service->setUnits($item->getUnits());
  360. //                            $service->setCommission(0);                                       // InOut puede haber metido una Comision y no se le debe modificar
  361. //                            $service->setOver(0);                                             // InOut puede haber metido un Over y no se le debe modificar
  362.                                 $service->setIva(21);
  363.                                 if (empty($item->getPax())) {
  364.                                     $service->setPax(1);
  365.                                 } else {
  366.                                     $service->setPax($item->getPax());
  367.                                 }
  368.                                 $service->setHour(null);
  369.                                 $service->setDateInAt($item->getDateInAt());
  370.                                 $service->setDateOutAt($item->getDateOutAt());
  371.                                 $service->setDirectPayment(0);
  372. //                            $service->setStatus('Pending');                                   // InOut puede haber Confirmado y no se le debe modificar
  373.                                 $service->setStatusinternal('Additional');
  374.                                 $service->setPreCommission(null);
  375.                                 $service->setPreIva(null);
  376.                                 $service->setDateBlockLimit(null);
  377. //                            $service->setOpCommission(1);                                     // InOut puede haber metido una Op Comision y no se le debe modificar
  378. //                            $service->setOpOver(1);                                           // InOut puede haber metido una Op Over y no se le debe modificar
  379. //                            $service->setOpIva(1);                                            // InOut puede haber metido una Op Iva y no se le debe modificar
  380.                                 $service->setBreakdown(0);
  381.                                 $service->setIsFather(0);
  382.                                 $service->setRankQuote($this->rankquoteAvParaInOutService($item->getId()));
  383.                                 $service->setOriginalopIva(1);
  384.                                 $service->setStatusRec('normal');
  385.                                 $service->setCreatedId($user_id);
  386.                                 $service->setUpdatedId($user_id);
  388.                                 $em->persist($service);
  389.                                 $em->flush();
  391.                                 // Se debe notificar por Telegram al agente de eventos
  392.                                 $logTelegram = true;
  394.                                 //Verificamos cambios e informamos al agente del proposal
  395.                                 $boolChanges = false;
  396.                                 if (!($service->getRankQuote() == $oldServiceEvent['rankquote'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Orden</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['rankquote'].', su nuevo valor es: '.$service->getRankQuote().'<br>'; $boolChanges = true; }
  397.                                 if (!($service->getName() == $oldServiceEvent['name'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Nombre</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['name'].', su nuevo valor es: '.$service->getName().'<br>'; $boolChanges = true; }
  398.                                 if (!($service->getPrice() == $oldServiceEvent['price'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Precio</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['price'].', su nuevo valor es: '.$service->getPrice().'<br>'; $boolChanges = true; }
  399.                                 if (!($service->getCurrency() == $oldServiceEvent['currency'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Moneda</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['currency'].', su nuevo valor es: '.$service->getCurrency().'<br>'; $boolChanges = true; }
  400.                                 if (!($service->getUnits() == $oldServiceEvent['units'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Cantidad</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['units'].', su nuevo valor es: '.$service->getUnits().'<br>'; $boolChanges = true; }
  401.                                 if (!($service->getPax() == $oldServiceEvent['pax'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Personas</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['pax'].', su nuevo valor es: '.$service->getPax().'<br>'; $boolChanges = true; }
  402.                                 if (!($service->getOpOver() == $oldServiceEvent['opOver'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->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: '.$service->getOpOver().'<br>'; $boolChanges = true; }
  403.                                 if (!($service->getOver() == $oldServiceEvent['over'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Over</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['over'].', su nuevo valor es: '.$service->getOver().'<br>'; $boolChanges = true; }
  404.                                 if (!($service->getOpCommission() == $oldServiceEvent['opCommission'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->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: '.$service->getOpCommission().'<br>'; $boolChanges = true; }
  405.                                 if (!($service->getCommission() == $oldServiceEvent['commission'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Comisión" ha sido modificado. Su valor era: '.$oldServiceEvent['commission'].', su nuevo valor es: '.$service->getCommission().'<br>'; $boolChanges = true; }
  406.                                 if (!($service->getOpIva() == $oldServiceEvent['opIva'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->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: '.$service->getOpIva().'<br>'; $boolChanges = true; }
  407.                                 if (!($service->getIva() == $oldServiceEvent['iva'])){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->getName().'<br>'; } $txtOfChanges = $txtOfChanges . '<br><br>El campo "<strong>Iva</strong>" ha sido modificado. Su valor era: '.$oldServiceEvent['iva'].', su nuevo valor es: '.$service->getIva().'<br>'; $boolChanges = true; }
  408.                                 if (!($service->getDateInAt()->format('H:i') == $oldServiceEvent['dateInAt']->format('H:i'))){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->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: '.$service->getDateInAt()->format('H:i').'<br>'; $boolChanges = true; }
  409.                                 if (!($service->getDateInAt()->format('Ymd') == $oldServiceEvent['dateInAt']->format('Ymd'))){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->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: '.$service->getDateInAt()->format('d/m/Y').'<br>'; $boolChanges = true; }
  410.                                 if (!($service->getDateOutAt()->format('H:i') == $oldServiceEvent['dateOutAt']->format('H:i'))){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->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: '.$service->getDateOutAt()->format('H:i').'<br>'; $boolChanges = true; }
  411.                                 if (!($service->getDateOutAt()->format('Ymd') == $oldServiceEvent['dateOutAt']->format('Ymd'))){ if (!$boolChanges){ $txtOfChanges =  $txtOfChanges.'<br><br>En el servicio: '.$service->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: '.$service->getDateOutAt()->format('d/m/Y').'<br>'; $boolChanges = true; }
  412.                             } else {
  413.                                 $srvAlreadyInvoiced = 'Error al sincronizar. <br><br> InOut ya ha facturado.';
  414.                                 $this->addFlash('mensajeaverror', $srvAlreadyInvoiced);
  415.                             }
  417.                         } else{
  419.                             $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($file->getIdProposal());
  420.                             if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  421.                                 $service = new ProposalSupplierServices();
  422.                                 $service->setServiceIdFather(0);
  423.                                 $service->setControlId($control->getId());
  424.                                 $service->setProposalId($file->getIdProposal());
  425.                                 $service->setDestinationId($control->getDestinoId());
  426.                                 $service->setSupplierId(80);                                    // 80 es AvExpress
  427.                                 $service->setIdeaId(null);
  428.                                 $service->setServiceId($item->getProductId());
  429.                                 $service->setServiceCatName('Av');
  430.                                 $service->setServiceCatId(3);
  431.                                 $service->setName($item->getProductName());
  432.                                 $priceInOut = $item->getSubTotalPrice();
  433.                                 if (!($item->getPax() == 0)) {
  434.                                     $priceInOut = $priceInOut / $item->getPax();                    // Se devuelve el calculo dividiendo entre personas
  435.                                 }
  436.                                 if (!($item->getUnits() == 0)) {
  437.                                     $priceInOut = $priceInOut / $item->getUnits();                  // Se devuelve el calculo dividiendo entre cantidades
  438.                                 }
  439.                                 if (!($item->getDays() == 0)) {
  440.                                     $priceInOut = $priceInOut / round($item->getDays());            // Se devuelve el calculo dividiendo entre dias, se redondea por si es 1.5
  441.                                 }
  442.                                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  443.                                 $priceInOut = round($priceInOut, 2, PHP_ROUND_HALF_UP);
  445.                                 $service->setPrice($priceInOut);
  446.                                 $service->setCurrency($item->getCurrency());
  447.                                 $service->setUnits($item->getUnits());
  448.                                 $service->setCommission(0);
  449.                                 $service->setOver(0);
  450.                                 $service->setIva(21);
  451.                                 if (empty($item->getPax())) { $service->setPax(1); } else { $service->setPax($item->getPax()); }
  452.                                 $service->setHour(null);
  453.                                 $service->setDateInAt($item->getDateInAt());
  454.                                 $service->setDateOutAt($item->getDateOutAt());
  455.                                 $service->setDirectPayment(0);
  456.                                 $service->setStatus('Pending');
  457.                                 $service->setStatusinternal('Additional');
  458.                                 $service->setPreCommission(null);
  459.                                 $service->setPreIva(null);
  460.                                 $service->setDateBlockLimit(null);
  461.                                 $service->setOpCommission(1);
  462.                                 $service->setOpOver(1);
  463.                                 $service->setOpIva(1);
  464.                                 $service->setBreakdown(0);
  465.                                 $service->setIsFather(0);
  466.                                 $service->setRankQuote($this->rankquoteAvParaInOutService($item->getId()));
  467.                                 $service->setOriginalopIva(1);
  468.                                 $service->setOriginalIva(null);
  469.                                 $service->setOriginalPrice(null);
  470.                                 $service->setStatusRec('normal');
  471.                                 $service->setAssistantId(null);
  472.                                 $service->setCreatedId($user_id);
  473.                                 $service->setUpdatedId($user_id);
  474.                                 $service->setCreatedAt(new \DateTime("now"));
  475.                                 $service->setUpdatedAt(new \DateTime("now"));
  477.                                 $em->persist($service);
  478.                                 $em->flush();
  480.                                 // Se relaciona el nuevo Servicio InOut con el Servicio AV
  481.                                 $item->setOriginId($service->getId());
  482.                                 $em->persist($item);
  483.                                 $em->flush();
  485.                                 // Se debe notificar por Telegram al agente de eventos
  486.                                 $logTelegram = true;
  487.                             } else {
  488.                                 $srvAlreadyInvoiced = 'Error al sincronizar. <br><br> InOut ya ha facturado.';
  489.                                 $this->addFlash('mensajeaverror', $srvAlreadyInvoiced);
  490.                             }
  491.                         }
  492.                     }
  494.                     // Notificamos al agente de InOut si se hicieron actualizaciones en los servicios desde AvExpress
  495.                     if (!empty($txtOfChanges)) { $this->messageOfChangesToAgent($txtOfChanges, $proposal->getId()); }
  497.                     //INICIO: Creamos una orden de hacer proforma
  499.                     //INICIO: Calculamos el ID de la proforma
  500.                     $numberToPrefix = $em->getRepository(AveDocProforma::class)->findAll();
  501.                     if (empty($numberToPrefix)){
  502.                         $numberToPrefix = 0;
  503.                     } else {
  504.                         $numberToPrefix = end($numberToPrefix)->getId();
  505.                     }
  506.                     $numberToPrefix++;
  507.                     //FIN: Calculamos el ID de la proforma
  509.                     $order = new AveBudgetToProforma();
  510.                     $order->setStatus('Pending');
  511.                     $order->setFileId($file->getId());
  512.                     $order->setProductFileId($item->getId());
  513.                     $order->setUserConfirmedId($proposal->getAgentId());
  514.                     $order->setUserConfirmedFullName($agentFullName);
  515.                     $order->setProposalTitle($proposalTitle);
  516.                     $order->setProformaId($numberToPrefix);
  518.                     $em->persist($order);
  519.                     $em->flush();
  520.                     //FIN: Creamos una orden de hacer proforma
  521.                 }
  523.                 $event = 'Expediente guardado correctamente.';
  524.                 $successMessage = $this->translator->trans($event);
  525.                 $this->addFlash('mensajeav', $successMessage);
  527.                 if (!empty($srvInconsistentes) and !empty($newFile->getIdProposal())){ $this->addFlash('mensajeaverror', $srvInconsistentes); }
  529.                 //INICIO: Notificamos al agente por Telegram
  530.                 if ($logTelegram){
  531.                     //Buscamos todos los agentes del proposal
  532.                     $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposal->getId());
  534.                     //Buscamos el Destino
  535.                     $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  537.                     //Buscamos el agente de Avexpress
  538.                     $userData = $em->getRepository(User::class)->findOneById($user_id);
  540.                     if (!empty($proposalAgents) and !($user_id == 22)){
  541.                         if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  542.                             $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  543.                         }
  544.                         if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  545.                             $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  546.                         }
  547.                         if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  548.                             $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  549.                         }
  550.                         if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  551.                             $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  552.                         }
  553.                     }
  554.                 }
  555.                 //FIN: Notificamos al agente por Telegram
  557.                 //INICIO: Creamos el presupuesto (proforma)
  559.                 $budToPro = $em->getRepository(AveBudgetToProforma::class)->findByProformaId($numberToPrefix);
  561.                 //INICIO: Se agrupan por expediente (fileId)
  562.                 $proformas = [];
  563.                 foreach ($budToPro as $item){
  564.                     $proformas[$item->getFileId()][] = $item;
  565.                 }
  566.                 //FIN: Se agrupan por expediente (fileId)
  568.                 if (!empty($budToPro)){
  569.                     foreach ($proformas as $key => $elemento){
  570.                         //INICIO: Creamos las proformas
  572.                         $newProforma = new AveDocProforma();
  573.                         $newProforma->setPrefix('AVE-' . (new DateTime('now'))->format('dmy') . '-' . $numberToPrefix . '-' . $key);
  574.                         $newProforma->setDateAt(new DateTime('now'));
  575.                         $newProforma->setFileId($key);
  576.                         $newProforma->setCreatedId($user_id);
  577.                         $newProforma->setUpdatedId($user_id);
  578.                         $newProforma->setCreatedAt(new DateTime('now'));
  579.                         $newProforma->setUpdatedAt(new DateTime('now'));
  581. //                        $em->persist($newProforma);
  582.                         $em->flush();
  583.                         //FIN: Creamos las proformas
  585.                         foreach ($elemento as $item) {
  586.                             //$key es el id del expediente
  587.                             // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  589.                             //INICIO: Creamos los elemento que iran dentro de las proformas
  590.                             $itemProforma = new AveDocProformaItems();
  591.                             $itemProforma->setType('PRODUCT');
  592.                             $itemProforma->setFileId($key);
  593.                             $itemProforma->setProformaId($newProforma->getId());
  594.                             $itemProforma->setControlId($item->getProductFileId());
  596. //                            $em->persist($itemProforma);
  597.                             $em->flush();
  599.                             //INICIO: Confirmamos el BudToProforma
  600. //                            $item->setStatus('Tosend');              // El elemento se ha pasado a la proforma, solo falta enviar
  601.                             $item->setProformaId($newProforma->getId());
  603. //                            $em->persist($item);
  604.                             $em->flush();
  605.                             //FIN: Confirmamos el BudToProforma
  607.                             //FIN: Creamos los elemento que iran dentro de las proformas
  608.                         }
  609.                     }
  610.                 }
  611.                 //FIN: Creamos el presupuesto (proforma)
  614.                 // INICIO: Se envia al agente el presupuesto
  615.                 $budToPro = $em->getRepository(AveBudgetToProforma::class)->findByStatus('Tosend');
  617.                 /* Obtengo usuario logueado */
  618.                 $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  619.                 $user_id = $user_logueado->getId();
  621.                 $arrayIdPro = [];          // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  623.                 //INICIO: Se agrupan por expediente (fileId)
  624.                 $proformas = [];
  625.                 foreach ($budToPro as $item){
  626.                     $proformas[$item->getFileId()][] = $item;
  627.                 }
  628.                 //FIN: Se agrupan por expediente (fileId)
  630.                 if (!empty($budToPro)){
  631.                     foreach ($proformas as $key => $elemento){
  632.                         //INICIO: Creamos las proformas
  634.                         foreach ($elemento as $item) {
  635.                             //$key es el id del expediente
  637.                             if (!empty($item->getProformaId())) {
  638.                                 $arrayIdPro[$item->getProformaId()] = $item->getUserConfirmedId();             // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  639.                             }
  641.                             //INICIO: Confirmamos el BudToProforma
  642.                             $item->setStatus('Confirmed');              // El elemento se ha pasado a confirmado porque se enviara por correo
  644.                             $em->persist($item);
  645.                             $em->flush();
  646.                             //FIN: Confirmamos el BudToProforma
  648.                             //FIN: Creamos los elemento que iran dentro de las proformas
  649.                         }
  650.                     }
  651.                 }
  653.                 //INICIO: Notificamos de todos los presupuestos (proformas) que se han creado
  654.                 foreach ($arrayIdPro as $key => $item){
  655.                     //Buscamos la info del proposal
  656.                     $xprof = $em->getRepository(AveDocProforma::class)->findOneById($key);
  657.                     if (!empty($xprof)){
  658.                         $xfile = $em->getRepository(AveFiles::class)->findOneById($xprof->getFileId());
  659.                         $xprop = $em->getRepository(Proposal::class)->findOneById($xfile->getIdProposal());
  660.                         $xcli = $em->getRepository(Client::class)->findOneById($xprop->getClientId());
  661.                         $xbody = 'Proposal #'.$xprop->getId().' - '.$xprop->getName().
  662.                             '<br><a href="http://' . $request->server->get('HTTP_HOST') . '/events/proposal/edit/' . $xprop->getId() . '">Ver el Proposal</a>'.
  663.                             '<br>Cliente: '.$xcli->getName().
  664.                             '<br><br>' .'Presupuesto AvExpress #' . $key  . ', ' . '<br><a href="http://' . $request->server->get('HTTP_HOST') . '/pdf/avexpressproforma/' . $key . '">Ver el PDF del presupuesto</a><br><br>Notificación de nuevo presupuesto: Este presupuesto ha sido creado de forma automática.' .
  665.                             '<br>Si el enlace al presupuesto no funciona correctamente, se debe a que desde AV lo han modificado o descartado.'.
  666.                             '<br><br>';
  667.                     } else {
  668.                         $xbody = 'Presupuesto AvExpress #' . $key  . ', ' . '<br><a href="http://' . $request->server->get('HTTP_HOST') . '/pdf/avexpressproforma/' . $key . '">Ver el PDF del presupuesto</a><br><br>Notificación de nuevo presupuesto: Este presupuesto ha sido creado de forma automática.' . '<br><br>';
  669.                     }
  671.                     //Buscamos los agentes a notificar
  672.                     // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  673.                     $agent = $em->getRepository(User::class)->findOneById($item);
  674.                     $agentMail = $agent->getEmail();
  676.                     $mailAgent = $agentMail;
  678.                     //Se prepara el correo con los agentes a notificar
  679.                     $firmGmail = $agent->getFirmGmail();
  680.                     $data = array(
  681.                         'body' => $xbody,
  682.                         'firm' => $firmGmail,
  683.                     );
  685.                     // EJECUTAR ENVIO DE ALERTA PARA EL AGENTE
  686.                     $transporter = new Swift_SmtpTransport();
  687.                         $transporter->setHost('smtp.gmail.com')
  688.                         ->setEncryption('ssl')//ssl / tls
  689.                         ->setPort(465)// 465 / 587
  690.                         ->setUsername('desarrollo@develup.solutions')
  691.                         ->setPassword('utvh hzoi wfdo ztjs');
  692.                     $mailer = new Swift_Mailer($transporter);
  694.                     $message = new Swift_Message();
  695.                         $message->setSubject('Presupuesto #' . $key . ', Notificación de nuevo presupuesto')
  696.                         ->setSender($agentMail)
  697.                         ->setFrom(array("desarrollo@develup.solutions" => "System Mante 3.0"))
  698.                         ->setReplyTo($agentMail)
  699.                         ->setTo($mailAgent)
  700.                         ->setBody(
  701.                             $this->renderView(
  702.                                 'mail/structure-mail.html.twig',
  703.                                 array('data' => $data)
  704.                             ),
  705.                             'text/html'
  706.                         );
  707.                     $mailer->send($message);
  708.                 }
  709.                 //FIN: Notificamos de todos los presupuestos (proformas) que se han creado
  710.                 // FIN: Se envia al agente el presupuesto
  711.             }
  712.         }
  714.         if(!empty($msjErrorClt)){
  715.             $errorMessage = $this->translator->trans('Error, el cliente no puede ser modificado, ya existe una factura previa');
  716.             $this->addFlash('mensajeaverror', $errorMessage);
  717.             return $this->redirectToRoute('ave_edit_file', array('id' => $newFile->getId()));
  718.         }
  720.         return $this->redirectToRoute('ave_edit_file', array('id' => $newFile->getId()));
  721.     }
  723.     /**
  724.      * @Route("/fileedit/{id}",  name="ave_edit_file")
  725.      * Editar un expediente
  726.      */
  727.     public function editFileAction( $id, Request $request, AvexpressCalculatorService $calculator)
  728.     {
  729.         $em = $this->getDoctrine()->getManager();
  730.         $editFile = $em->getRepository(AveFiles::class)->findOneById($id);
  732.         $clients = $em->getRepository(Client::class)->findAll();
  733.         $clientSelected = $em->getRepository(Client::class)->findOneById($editFile->getClient());
  734.         $products = $em->getRepository(AveProduct::class)->findAll();
  735.         $destinations = $em->getRepository(Destination::class)->findAll();
  737.         /* Obtengo usuario logueado */
  738.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  740.         $data = $calculator->calculateFileTotals((int)$id);
  742.         $sumatoriaTotalNet = 0;
  743.         $sumatoriaTotalVat = 0;
  744.         $sumatoriaTotal = 0;
  746.         $resultados = array(
  747.             'totalNeto' => $sumatoriaTotalNet,
  748.             'vat' => $sumatoriaTotalVat,
  749.             'total' => $sumatoriaTotal,
  751.         );
  753.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($id);
  755.         $numeroItems = sizeof($productInFile);
  757.         $facturas = $em->getRepository(AveDocInvoice::class)->findByFileId($id);
  758.         $facturasRec = $em->getRepository(AveDocInvoiceRec::class)->findByFileId($id);
  760.         foreach ($facturasRec as $item){ array_push($facturas,$item); }
  762.         $proformas = [];
  763.         $allProformas = $em->getRepository(AveDocProforma::class)->findByFileId($id);
  765.         foreach ($allProformas as $item) {
  766.             $dataTwo = $this->baseInvoiceDoneFileTwo($id, $item->getId(), 'P');
  767.             $bases = 0;
  769.             if (is_numeric($dataTwo['totales']) and is_numeric($dataTwo['totales_neto'])) {
  770.                 $bases = $dataTwo['totales'] - $dataTwo['totales_neto'];
  771.             }
  773.             $itemsInProforma = [];
  775.             if (array_key_exists('product', $dataTwo['datasupplier'])) {
  776.                 foreach ($dataTwo['datasupplier']['product'] as $elem) {
  777.                     $itemsInProforma[] = $em->getRepository(AveProductFile::class)->findOneById($elem['id']);
  778.                 }
  780.                 $proformas[] = array(
  781.                     'id' => $dataTwo['number'],
  782.                     'itemsInProforma' => $itemsInProforma,
  783.                     'date' => $dataTwo['date'],
  784.                     'neto' => $dataTwo['totales_neto'],
  785.                     'bases_imponibles' => $bases,
  786.                     'total' => $dataTwo['totales'],
  787.                 );
  788.             }
  789.         }
  790.         // Calculamos el beneficio
  791.         $dataThree = $this->baseBenefits($id);
  793.         // Buscamos los serviicos pendientes
  794.         $pendingBuds = $em->getRepository(AveBudgetPending::class)->findByProposalId($editFile->getIdProposal());
  796.         $pBuds = [];
  798.         // Creamos la agrupacion por proposal
  799.         foreach ($pendingBuds as $item){
  800.             if (!(array_key_exists($item->getProposalId(),$pBuds))){
  801.                 if (!empty($item->getOriginId())){    // Los vacios solo contienen briefings
  802.                     $pBuds[$item->getProposalId()] = null;
  803.                 }
  804.             }
  805.         }
  807.         // Metemos los items en el arreglo clasificado por proposal
  808.         foreach ($pendingBuds as $item){
  809.             if (!empty($item->getOriginId())) {    // Los vacios solo contienen briefings
  810.                 $pBuds[$item->getProposalId()][] = $item;
  811.             }
  812.         }
  814.         ksort($pBuds);
  815.         $keysPbuds = array_keys($pBuds);
  817.         $productsInFile = $em->getRepository(AveProductFile::class)->getSortedProductsByFile($editFile);
  818.         $arrayProductsInFile = [];
  819.         foreach ($productsInFile as $item){
  821.             $priceTotalWithOutVat = $item->getServicePrice() * $item->getPax() * $item->getUnits() * $item->getDays();
  822.             $comi = empty($item->getCommission()) ? 0 : $item->getServicePrice() * $item->getPax() * $item->getUnits() * $item->getDays() * ($item->getCommission() / 100);
  823.             $comi = ($item->getOpCommission() == 0) ? ($comi * -1) : $comi;
  824.             $priceTotalWithOutVat += $comi;
  825.             $over =$item->getOver();
  826.             $over = ($item->getOpOver() == 0) ? ($over * -1) : $over;
  827.             $priceTotalWithOutVat += $over;
  828.             $priceWithVat = ($item->getOpIva() == 0) ? ($priceTotalWithOutVat - ($priceTotalWithOutVat * ($item->getIva()/100))) : ($priceTotalWithOutVat + ($priceTotalWithOutVat * ($item->getIva()/100)));
  830.             $arrayProductsInFile[] = array(
  831.                 'id' => $item->getId(),
  832.                 'productName' => $item->getProductName(),
  833.                 'description' => $item->getDescription(),
  834.                 'productId' => $item->getProductId(),
  835.                 'dateStart' => $item->getDateStart(),
  836.                 'dateEnd' => $item->getDateEnd(),
  837.                 'servicePrice' => $item->getServicePrice(),
  838.                 'subTotalPrice' => $item->getSubTotalPrice(),
  839.                 'subtotalProduct' => $priceTotalWithOutVat,
  840.                 'iva' => $item->getIva(),
  841.                 'pax' => $item->getPax(),
  842.                 'qty' => $item->getUnits(),
  843.                 'days' => $item->getDays(),
  844.                 'type' => $item->getType(),
  845.                 'subtotal' => $priceWithVat,
  846.             );
  847.         }
  849.         // Generamos un arreglo con la previsión posible de venta del espacio
  850.         $gpFile = $em->getRepository(Reservation::class)->findOneById($editFile->getReservation());
  851.         $idGpFile = empty($gpFile) ? null : $gpFile->getId();
  853.         $optionsGp = [];
  855.         if (!empty($idGpFile)) {
  857.             $options = $em->getRepository(ReservationLoungeSimple::class)->findByIdReservation($idGpFile);
  858.             foreach ($options as $option) {
  859.                 $rankQuote = $option->getRankQuote();
  861.                 if (!isset($optionsGp[$rankQuote])) {
  862.                     $optionsGp[$rankQuote] = [
  863.                         'Opcion' => $rankQuote,
  864.                         'Salas'  => [],
  865.                         'Precio' => 0
  866.                     ];
  867.                 }
  869.                 // Agregar sala si no existe
  870.                 $loungeName = $option->getLoungeName();
  872.                 if (!in_array($loungeName, $optionsGp[$rankQuote]['Salas'])) {
  873.                     $optionsGp[$rankQuote]['Salas'][] = $loungeName;
  874.                 }
  876.                 // Sumar precios
  877.                 $optionsGp[$rankQuote]['Precio'] += (float) $option->getServicePrice();
  878.             }
  880.             // Convertimos el array de salas a texto
  881.             foreach ($optionsGp as &$gp) {
  882.                 $gp['Sala'] = implode(', ', $gp['Salas']);
  883.                 unset($gp['Salas']);
  884.             }
  886.             // Reindexar array
  887.             $optionsGp = array_values($optionsGp);
  888.         }
  890.         $htFile = !(empty($gpFile)) ? (in_array($user_logueado->getUserrol()->getId(),[9,23,24,37,47,53]) ? $em->getRepository(HtFile::class)->findOneByReservation($gpFile) : null ) : null;
  891.         $gpFile = in_array($user_logueado->getUserrol()->getId(),[9,23,24,37,47,53]) ? $gpFile : null ;
  893.         return $this->render('MDS/AvexpressBundle/Avexpress/edit-files.html.twig',
  894.             array(
  895.                 'id' => $id,
  896.                 'clients' => $clients,
  897.                 'clientId' => $editFile->getClient(),
  898.                 'clientSelected' => $clientSelected,
  899.                 'file' => $editFile,
  900.                 'numeroItems' => $numeroItems,
  901. //                'arrayProductFile' => $data['datasupplier']['product'],
  902.                 'arrayProductFile' => $arrayProductsInFile,
  903.                 'products' => $products,
  904.                 'services' => null,
  905.                 'facturas' => $facturas,
  906.                 'proformas' => $proformas,
  907.                 'paymentNotIvoiced' => null,
  908.                 'paymentsAll' => null,
  909.                 'optionsGp' => $optionsGp,
  910.                 'resultados' => $resultados,
  911.                 'totales_global_con_iva' => $data['totales'], //$data['totales_global_con_iva'],
  912.                 'totales_global_iva' => $data['bases_imponibles']['ivaMontoVeintiUno'], //$data['totales_global_iva'],
  913.                 'totales_global_neto' => $data['totales_neto'], //$data['totales_global_neto'],
  914.                 'totales_global_servicios_con_iva' => 0, //$data['totales_global_servicios_con_iva'],
  915.                 'totales_global_servicios_neto' => 0, //$data['totales_global_servicios_neto'],
  916.                 'totales_global_servicios_iva' => 0, //$data['totales_global_servicios_iva'],
  917.                 'sumatoria_totales_global_con_iva' => 0, //$data['sumatoria_totales_global_con_iva'],
  918.                 'sumatoria_totales_global_neto' => 0, //$data['sumatoria_totales_global_neto'],
  919.                 'sumatoria_totales_global_iva' => 0, //$data['sumatoria_totales_global_iva'],
  920.                 'benefitEuro' => $dataThree['benefitEuro'],
  921.                 'benefitPerc' => $dataThree['benefitPerc'],
  922.                 'pendingBudgets' => $pBuds,
  923.                 'keysPendingBudgets' => $keysPbuds,
  924.                 'destinations' => $destinations,
  925.                 'htFile' => $htFile,
  926.                 'gpFile' => $gpFile,
  927.             ));
  928.     }
  930.     /**
  931.      * @Route("/filedelete/{id}",  name="ave_delete_file")
  932.      * Actualizar un expediente
  933.      */
  934.     public function deleteFileAction($id, Request $request)
  935.     {
  936.         $em = $this->getDoctrine()->getManager();
  937.         $newFile = $em->getRepository(AveFiles::class)->findOneById($id);
  939.         /* Obtengo usuario logueado */
  940.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  941.         $user_id = $user_logueado->getId();
  943.         $newFile->setStatus('Deleted');
  944.         $newFile->setUpdatedId($user_id);
  945.         $newFile->setUpdatedAt(new \DateTime("now"));
  947.         $em->persist($newFile);
  948.         $em->flush();
  950.         return $this->redirectToRoute('ave_edit_file', array( 'id' => $id ));
  951.     }
  953.     /**
  954.      * @Route("/filefrombudget/{id}",  name="ave_add_file_from_budget")
  955.      * Agregar un expediente desde un presupuesto
  956.      */
  957.     public function addFileFromBudgetAction( $id, Request $request)
  958.     {
  959.         $em = $this->getDoctrine()->getManager();
  960.         $budget = $em->getRepository(AveBudgetPending::class)->findOneById($id);
  961.         $proposal = $em->getRepository(Proposal::class)->findOneById($budget->getProposalId());
  963.         $newFile = $em->getRepository(AveFiles::class)->findOneByIdProposal($proposal->getId());
  965.         /* Obtengo usuario logueado */
  966.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  967.         $user_id = $user_logueado->getId();
  969.         if (empty($newFile)){
  970.             // No hay un File asociado a ese proposal, se debe crear uno nuevo
  971.             $newFile = new AveFiles();
  972.             $newFile->setTitle($proposal->getId().' - ' .$budget->getProposalTitle());
  973.             $newFile->setClient(262);                           // In Out es el cliente
  974.             $newFile->setIdProposal($proposal->getId());
  975.             $newFile->setStatus('Pending');
  976.             $newFile->setAdvancePayment(null);
  977.             if (!empty($budget->getBriefing())){
  978.                 $newFile->setDescription('<p> *********  MENSAJE DEL AGENTE  ********* </p>' . $budget->getBriefing());
  979.             }
  980.             $newFile->setDateStart(new \DateTime("now"));
  981.             $newFile->setDateEnd(new \DateTime("now"));
  983.             $newFile->setCreatedId($user_id);
  984.             $newFile->setUpdatedId($user_id);
  985.             $newFile->setCreatedAt(new \DateTime("now"));
  986.             $newFile->setUpdatedAt(new \DateTime("now"));
  987.         } else {
  988.             // Ya existe un File asociado a ese proposal
  989.             $newFile->setClient(262);                           // In Out es el cliente
  990.             $newFile->setStatus('Pending');
  991.             if (!empty($budget->getBriefing())) {
  992.                 $newFile->setDescription($newFile->getDescription() . '<p> *********  MENSAJE DEL AGENTE  ********* </p>' . $budget->getBriefing());
  993.             }
  994.             $newFile->setUpdatedId($user_id);
  995.             $newFile->setUpdatedAt(new \DateTime("now"));
  996.         }
  998.         $em->persist($newFile);
  999.         $em->flush();
  1001.         $em->remove($budget);
  1002.         $em->flush();
  1004.         //Actualizamos los Briefings que esten en FileId null con el recien generado fileId en base al proposalId
  1005.         $allBriefings = $em->getRepository(AveBriefings::class)->findByProposalId($proposal->getId());
  1006.         foreach ($allBriefings as $item){
  1007.             if (empty($item->getFileId())) {
  1008.                 $item->setFileId($newFile->getId());
  1010.                 $em->persist($item);
  1011.                 $em->flush();
  1012.             }
  1013.         }
  1014.         return $this->redirectToRoute('ave_edit_file', array( 'id' => $newFile->getId() ));
  1015.     }
  1017.     /**
  1018.      * @Route("/filelistbriefings/{id}",  name="ave_list_file_briefings")
  1019.      * Listar briefings del expediente
  1020.      */
  1021.     public function listFileBriefingsAction($id, Request $request){
  1023.         $em = $this->getDoctrine()->getManager();
  1024.         $briefings = $em->getRepository(AveBriefings::class)->findByFileId($id);
  1026.         return $this->render('MDS/AvexpressBundle/Avexpress/list-briefings.html.twig',
  1027.             array(
  1028.                 'id' => $id,
  1029.                 'briefings' => $briefings,
  1030.             )
  1031.         );
  1032.     }
  1035.     /**
  1036.      * @Route("/briefingadd/{id}",  name="ave_add_file_briefings")
  1037.      * Agregar briefing al expediente
  1038.      */
  1039.     public function addFileBriefingsAction($id, Request $request){
  1041.         $brif = $request->request->get('newbriefing');
  1043.         $em = $this->getDoctrine()->getManager();
  1044.         $file = $em->getRepository(AveFiles::class)->findOneById($id);
  1045.         $proposalId = $file->getIdProposal();
  1047.         /* Obtengo usuario logueado */
  1048.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1049.         $user_id = $user_logueado->getId();
  1051.         $userConfirmedFullName = $user_logueado->getName().' '.$user_logueado->getLastName();
  1053.         $briefing = new AveBriefings();
  1054.         $briefing->setProposalId($proposalId);
  1055.         $briefing->setBriefing($brif);
  1056.         $briefing->setBudgetPendingId(null);
  1057.         $briefing->setFileId($id);
  1058.         $briefing->setUserConfirmedFullName($userConfirmedFullName);
  1059.         $briefing->setUserConfirmedId($user_id);
  1060.         $briefing->setCreatedAt(new \DateTime("now"));
  1062.         $em->persist($briefing);
  1063.         $em->flush();
  1065.         $briefings = $em->getRepository(AveBriefings::class)->findByFileId($id);
  1067.         return $this->render('MDS/AvexpressBundle/Avexpress/list-briefings.html.twig',
  1068.             array(
  1069.                 'id' => $id,
  1070.                 'briefings' => $briefings,
  1071.             )
  1072.         );
  1073.     }
  1076.     /**
  1077.      * @Route("/filedeletedlist/",  name="ave_list_file_deleted")
  1078.      * Listar expedientes cancelados
  1079.      */
  1080.     public function listFileDeletedAction( Request $request)
  1081.     {
  1082.         $em = $this->getDoctrine()->getManager();
  1083.         $idgroup = null; $ref = [];
  1084.         $reservas = $em->getRepository(AveFiles::class)->findByStatus('Deleted');
  1086.         foreach ($reservas as $res) {
  1087.             $client = $em->getRepository(Client::class)->findOneById($res->getClient());
  1088.             if (!empty($client)) { $res->setClient($client->getName()); } else { $res->setClient(null); }
  1090.             if (!empty($res->getDateStart()) and !empty($res->getDateEnd())) {
  1091.                 $ref[$res->getId()] = '#' . ($res->getDateStart())->format('ymd') . ($res->getDateEnd())->format('ymd');
  1092.             } else {
  1093.                 $ref[$res->getId()] = '#' . '000000' . '000000';
  1094.             }
  1095.         }
  1097.         $reservasZero = [];
  1098.         foreach ($reservas as $res) {
  1099.             $reservasZero[] = array(
  1100.                 'dateStart' => $res->getDateStart(),
  1101.                 'dateEnd' => $res->getDateEnd(),
  1102.                 'id' => $res->getId(),
  1103.                 'title' => $res->getTitle(),
  1104.                 'client' => $res->getClient(),
  1105.                 'createdId' => $res->getCreatedId(),
  1106.                 'ref' => $ref[$res->getId()],
  1107.                 'reservation' => $res->getReservation(),
  1108.             );
  1109.         }
  1110.         $reservas = $reservasZero;
  1112.         return $this->render('MDS/AvexpressBundle/Avexpress/list-files.html.twig',
  1113.             array(
  1114.                 'groups' => null,
  1115.                 'listofdeletedfiles' => true,
  1116.                 'reservations' => $reservas
  1117.             )
  1118.         );
  1119.     }
  1122.     /**
  1123.      * @Route("/updatefilecomments/{id}",  name="ave_update_file_comments")
  1124.      * Actualizar Comentarios y booleanos del expediente
  1125.      */
  1126.     public function updateFileCommentsAction($id, Request $request){
  1127.         $em = $this->getDoctrine()->getManager();
  1129.         $file = $em->getRepository(AveFiles::class)->findOneById($id);
  1130.         $newComments = $request->request->get('comments');
  1131.         $chkCommentsToPro = $request->request->get('chkCommentsToPro');
  1132.         $chkCommentsToInv = $request->request->get('chkCommentsToInv');
  1134.         if ($chkCommentsToInv == 'on'){ $chkCommentsToInv = true; } else { $chkCommentsToInv = false; }
  1135.         if ($chkCommentsToPro == 'on'){ $chkCommentsToPro = true; } else { $chkCommentsToPro = false; }
  1137.         $file->setComments($newComments);
  1138.         $file->setCommentsInInv($chkCommentsToInv);
  1139.         $file->setCommentsInPro($chkCommentsToPro);
  1141.         $em->persist($file);
  1142.         $em->flush();
  1144.         return $this->redirectToRoute('ave_edit_file', array( 'id' => $id ));
  1145.     }
  1149.     private function baseInvoiceDoneFileTwo($fileId, $invoiceId, $typeBase)
  1150.     {
  1151.         $em = $this->getDoctrine()->getManager();
  1152.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  1153.         $dateDocument = null;                                                                           //Fecha final del documento
  1154.         $subneto = 0;
  1155.         if (($typeBase == 'I') or ($typeBase == 'P')) {
  1156.             if ($typeBase == 'I') {
  1157.                 $items = $em->getRepository(AveDocInvoiceItems::class)->findBy(array('fileId' => $fileId, 'invoiceId' => $invoiceId));
  1158.             } else {
  1160.                 $parameters = array(
  1161.                     'fileId' => $fileId,
  1162.                     'proformaId' => $invoiceId,
  1163.                 );
  1164.                 $dql = 'SELECT i
  1165.                         FROM AvexpressBundle:AveProductFile i
  1166.                         INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1167.                         WHERE i.fileId = :fileId AND c.proformaId =:proformaId
  1168.                         ORDER BY i.rankquoteAv ASC';
  1169.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1170.                 $items = $query->getResult();
  1172.                 $arrayLocation = [];
  1173.                 $arrayLocationWithNull = false;
  1174.                 foreach ($items as $item){
  1175.                     if (!empty($item->getLocation())){
  1176.                         $arrayLocation[$item->getLocation()] = $item->getLocation();
  1177.                     } else {
  1178.                         $arrayLocationWithNull = true;
  1179.                     }
  1180.                 }
  1181.                 if ($arrayLocationWithNull){ $arrayLocation['null'] = 'null'; }
  1183.                 $productsInFile = [];
  1185.                 foreach ($arrayLocation as $item){
  1187.                     // VIDEO
  1188.                     $parameters = array(
  1189.                         'fileId' => $fileId,
  1190.                         'type' => 'Vídeo',
  1191.                         'location' => $item,
  1192.                         'proformaId' => $invoiceId,
  1193.                     );
  1194.                     $dql = 'SELECT i                            
  1195.                             FROM AvexpressBundle:AveProductFile i
  1196.                             INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1197.                             WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location AND c.proformaId =:proformaId
  1198.                             ORDER BY i.rankquoteAv ASC';
  1199.                     $query = $em->createQuery($dql)->setParameters($parameters);
  1200.                     $productsInFileVid = $query->getResult();
  1202.                     // SONIDO
  1203.                     $parameters = array(
  1204.                         'fileId' => $fileId,
  1205.                         'type' => 'Sonido',
  1206.                         'location' => $item,
  1207.                         'proformaId' => $invoiceId,
  1208.                     );
  1209.                     $dql = 'SELECT i
  1210.                             FROM AvexpressBundle:AveProductFile i
  1211.                             INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1212.                             WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location AND c.proformaId =:proformaId
  1213.                             ORDER BY i.rankquoteAv ASC';
  1214.                     $query = $em->createQuery($dql)->setParameters($parameters);
  1215.                     $productsInFileSound = $query->getResult();
  1217.                     // ILUMINACION
  1218.                     $parameters = array(
  1219.                         'fileId' => $fileId,
  1220.                         'type' => 'Iluminación',
  1221.                         'location' => $item,
  1222.                         'proformaId' => $invoiceId,
  1223.                     );
  1224.                     $dql = 'SELECT i
  1225.                             FROM AvexpressBundle:AveProductFile i
  1226.                             INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1227.                             WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location AND c.proformaId =:proformaId
  1228.                             ORDER BY i.rankquoteAv ASC';
  1229.                     $query = $em->createQuery($dql)->setParameters($parameters);
  1230.                     $productsInFileLights = $query->getResult();
  1232.                     // OTROS
  1233.                     $parameters = array(
  1234.                         'fileId' => $fileId,
  1235.                         'typeV' => 'Vídeo',
  1236.                         'typeS' => 'Sonido',
  1237.                         'typeI' => 'Iluminación',
  1238.                         'location' => $item,
  1239.                         'proformaId' => $invoiceId,
  1240.                     );
  1241.                     $dql = 'SELECT i
  1242.                             FROM AvexpressBundle:AveProductFile i
  1243.                             INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1244.                             WHERE (i.fileId = :fileId AND i.type != :typeV AND i.type != :typeS AND i.type != :typeI AND i.location = :location AND c.proformaId =:proformaId)
  1245.                             ORDER BY i.rankquoteAv ASC';
  1246.                     $query = $em->createQuery($dql)->setParameters($parameters);
  1247.                     $productsInFileOther = $query->getResult();
  1249.                     // CASO NULL (Los casos EMPTY estan considerados en las consultas previas)
  1250.                     $parameters = array(
  1251.                         'fileId' => $fileId,
  1252.                         'location' => $item,
  1253.                         'proformaId' => $invoiceId,
  1254.                     );
  1255.                     $dql = 'SELECT i
  1256.                             FROM AvexpressBundle:AveProductFile i
  1257.                             INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1258.                             WHERE (i.fileId = :fileId AND i.type IS NULL AND i.location = :location AND c.proformaId =:proformaId)
  1259.                             ORDER BY i.rankquoteAv ASC';
  1260.                     $query = $em->createQuery($dql)->setParameters($parameters);
  1261.                     $productsInFileNull = $query->getResult();
  1263.                     // Para el location en NULL el SQL tiene que ser diferente por eso el siguiente condicional
  1264.                     if ($item == 'null'){
  1266.                         // VIDEO
  1267.                         $parameters = array(
  1268.                             'fileId' => $fileId,
  1269.                             'type' => 'Vídeo',
  1270.                             'proformaId' => $invoiceId,
  1271. //                    'location' => $item,
  1272.                         );
  1273.                         $dql = 'SELECT i
  1274.                                 FROM AvexpressBundle:AveProductFile i
  1275.                                 INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1276.                                 WHERE i.fileId = :fileId AND i.type = :type AND i.location IS NULL AND c.proformaId =:proformaId
  1277.                                 ORDER BY i.rankquoteAv ASC';
  1278.                         $query = $em->createQuery($dql)->setParameters($parameters);
  1279.                         $productsInFileVid = $query->getResult();
  1281.                         // SONIDO
  1282.                         $parameters = array(
  1283.                             'fileId' => $fileId,
  1284.                             'type' => 'Sonido',
  1285.                             'proformaId' => $invoiceId,
  1286. //                    'location' => $item,
  1287.                         );
  1288.                         $dql = 'SELECT i
  1289.                                 FROM AvexpressBundle:AveProductFile i
  1290.                                 INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1291.                                 WHERE i.fileId = :fileId AND i.type = :type AND i.location IS NULL AND c.proformaId =:proformaId
  1292.                                 ORDER BY i.rankquoteAv ASC';
  1293.                         $query = $em->createQuery($dql)->setParameters($parameters);
  1294.                         $productsInFileSound = $query->getResult();
  1296.                         // ILUMINACION
  1297.                         $parameters = array(
  1298.                             'fileId' => $fileId,
  1299.                             'type' => 'Iluminación',
  1300.                             'proformaId' => $invoiceId,
  1301. //                    'location' => $item,
  1302.                         );
  1303.                         $dql = 'SELECT i
  1304.                                 FROM AvexpressBundle:AveProductFile i
  1305.                                 INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1306.                                 WHERE i.fileId = :fileId AND i.type = :type AND i.location IS NULL AND c.proformaId =:proformaId
  1307.                                 ORDER BY i.rankquoteAv ASC';
  1308.                         $query = $em->createQuery($dql)->setParameters($parameters);
  1309.                         $productsInFileLights = $query->getResult();
  1311.                         // OTROS
  1312.                         $parameters = array(
  1313.                             'fileId' => $fileId,
  1314.                             'typeV' => 'Vídeo',
  1315.                             'typeS' => 'Sonido',
  1316.                             'typeI' => 'Iluminación',
  1317.                             'proformaId' => $invoiceId,
  1318. //                    'location' => $item,
  1319.                         );
  1320.                         $dql = 'SELECT i
  1321.                                 FROM AvexpressBundle:AveProductFile i
  1322.                                 INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1323.                                 WHERE (i.fileId = :fileId AND i.type != :typeV AND i.type != :typeS AND i.type != :typeI AND i.location IS NULL AND c.proformaId =:proformaId)
  1324.                                 ORDER BY i.rankquoteAv ASC';
  1325.                         $query = $em->createQuery($dql)->setParameters($parameters);
  1326.                         $productsInFileOther = $query->getResult();
  1328.                         // CASO NULL (Los casos EMPTY estan considerados en las consultas previas)
  1329.                         $parameters = array(
  1330.                             'fileId' => $fileId,
  1331.                             'proformaId' => $invoiceId,
  1332. //                    'location' => $item,
  1333.                         );
  1334.                         $dql = 'SELECT i
  1335.                                 FROM AvexpressBundle:AveProductFile i
  1336.                                 INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1337.                                 WHERE (i.fileId = :fileId AND i.type IS NULL AND i.location IS NULL AND c.proformaId =:proformaId)
  1338.                                 ORDER BY i.rankquoteAv ASC';
  1339.                         $query = $em->createQuery($dql)->setParameters($parameters);
  1340.                         $productsInFileNull = $query->getResult();
  1341.                     }
  1342.                     $productsInFile = array_merge($productsInFile, $productsInFileVid, $productsInFileSound, $productsInFileLights, $productsInFileOther, $productsInFileNull);
  1343.                 }
  1345.                 $items = $productsInFile;       // En Items estaban todos pero sin ordenamiento, ahora estan organizados por location y tipo
  1356.             }
  1357.         } else {
  1358.             // No es factura ni proforma, es una rectificativa
  1359.             $items = $em->getRepository(AveDocInvoiceRecItems::class)->findBy(array('fileId' => $fileId, 'invoiceRecId' => $invoiceId));
  1360.         }
  1362.         $company = $em->getRepository(SettingsCompany::class)->findOneBy(['businessType' => BusinessTypeSettingsCompanyConstants::AUDIOVISUAL]);
  1363.         $client = $em->getRepository(Client::class)->findById($file->getClient());
  1365.         if (empty($client)){
  1366.             $client[0] = new Client();
  1367.             $client[0]->setName('');
  1368.             $client[0]->setTitle('');
  1369.             $client[0]->setIdDocument('');
  1370.             $client[0]->setPopulation('');
  1371.             $client[0]->setRegion('');
  1372.             $client[0]->setCountry('');
  1373.         } else {
  1374.             if (is_numeric($client[0]->getPopulation())){
  1375.                 $city = ($em->getRepository(Cities::class)->findOneById($client[0]->getPopulation()));
  1376.                 $client[0]->setPopulation($city->getCity());
  1377.             }
  1378.             if (is_numeric($client[0]->getRegion())){
  1379.                 $region = ($em->getRepository(Regions::class)->findOneById($client[0]->getRegion()));
  1380.                 $client[0]->setRegion($region->getRegion());
  1381.             }
  1382.             if (is_numeric($client[0]->getCountry())){
  1383.                 $country = ($em->getRepository(Country::class)->findOneById($client[0]->getCountry()));
  1384.                 $client[0]->setCountry($country->getCountry());
  1385.             }
  1386.         }
  1388.         // Acumuladores de los calculos
  1389.         $totales_neto_all = 0;
  1390.         $data_iva = array(
  1391.             'iva' => 21,
  1392.             'ivaMontoVeintiUno' => 0,
  1393.             'ivaMontoDiez' => 0,
  1394.             'ivaMontoCero' => 0,
  1395.         );
  1397.         //INICIO: Determinamos el numero de factura o proforma
  1398.         if ($typeBase == 'I'){
  1399.             // Es una Factura
  1401.             $number = $em->getRepository(AveDocInvoice::class)->findOneById($invoiceId);
  1402.             $dateDocument = $number->getDateAt();
  1403.             $number = $number->getNumber();
  1404.             $type = 'Invoice';
  1406.         } else {
  1407.             if ($typeBase == 'R'){
  1408.                 // Es una factura rectificativa
  1409.                 $number = $em->getRepository(AveDocInvoiceRec::class)->findOneById($invoiceId);
  1410.                 $dateDocument = $number->getDateAt();
  1411.                 $type = 'Invoice Rec';
  1412.             } else {
  1413.                 // Es una Proforma
  1415.                 $number = $invoiceId;
  1416.                 $type = 'Proforma';
  1417.             }
  1418.         }
  1419.         //FIN: Determinamos el numero de factura o proforma
  1421.         // Buscamos los productos, pagos y servicios
  1423.         $arrayItems = [];
  1424.         $fileProducts = [];
  1425.         $payments = [];
  1426.         $services = [];
  1428.         if (!empty($items)) {
  1429.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1430.                 foreach ($items as $item) {
  1431.                     switch ($item->getItemType()) {
  1432.                         case 'PRODUCT': // Producto
  1433.                             $fileProducts[] = $item;
  1434.                             break;
  1436.                         case 'PAYMENT': // Pago
  1437.                             $payments[] = $item;
  1438.                             break;
  1440.                         case 'SERVICE': // Servicio
  1441.                             $services[] = $item;
  1442.                             break;
  1444.                         default:
  1445.                             break;
  1447.                     }
  1448.                 }
  1449.             } else {
  1450.                 // Es una proforma
  1452.                 foreach ($items as $item) {
  1453.                     switch ($item->getType()) {
  1454.                         case 'PRODUCT': // Producto
  1455.                             $productPro = $em->getRepository(AveProductFile::class)->findOneById($item->getControlId());
  1456.                             if (!empty($productPro)) {
  1457.                                 $fileProducts[] = $productPro;
  1458.                             }
  1459.                             break;
  1461.                         case 'PAYMENT': // Pago
  1462.                             $paymentPro = $em->getRepository(AvePaymentsClient::class)->findOneById($item->getControlId());
  1463.                             if (!empty($paymentPro)) {
  1464.                                 $payments[] = $paymentPro;
  1465.                             }
  1466.                             break;
  1468.                         case 'SERVICE': // Servicio
  1469.                             $servicePro = $em->getRepository(AveServices::class)->findOneById($item->getControlId());
  1470.                             if (!empty($servicePro)) {
  1471.                                 $services[] = $servicePro;
  1472.                             }
  1473.                             break;
  1475.                         default:
  1477.                             // Producto  (Video, Iluminacion, Sonido, Otros)
  1478.                             if (!empty($item)) {
  1479.                                 $fileProducts[] = $item;
  1480.                             }
  1481.                         break;
  1482.                     }
  1483.                 }
  1484.             }
  1485.         }
  1487.         $data_supplier = [];
  1488.         $i = 0;
  1490.         $iva = '21';            // Esteban Rincon: "Por Ley de localización del impuesto, siempre será un 21%"
  1491.         $pax = '1';
  1492.         $qty = '1';
  1493.         $product = array(
  1494.             'neto' => 0,
  1495.             'sumSubT' => 0,
  1496.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1498.         $service = array(
  1499.             'neto' => 0,
  1500.             'sumSubT' => 0,
  1501.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1503.         foreach ($fileProducts as $item){
  1505.             if (!is_null($item->getUnits()) or !empty($item->getUnits())){
  1506.                 $qty = $item->getUnits();
  1507.             }
  1509.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1510.                 if (is_null($item->getPrdServicePrice()) or empty($item->getPrdServicePrice())){
  1511.                     $subtotal = 0;
  1512.                     $neto = 0;
  1513.                     $subtotalProduct = 0;
  1515.                 } else {
  1517. //                    $subtotalProduct = $item->getPrdServicePrice() * 1.21;
  1518.                     $subtotalProduct = $item->getPrdSubTotalPrice() * 1.21;
  1519. //                    $subneto = $item->getPrdServicePrice();
  1520.                     $subneto = $item->getPrdSubTotalPrice();
  1522.                     $subtotal =  $subtotalProduct;
  1523.                     $neto =  $subneto;
  1525.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  1526.                     $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  1527.                     $neto = round($neto,2,PHP_ROUND_HALF_UP);
  1529.                     $arrayItems[] = array(
  1530.                         'type' => 'Product',
  1531.                         'name' => $item->getPrdName(),
  1532.                         'amount' => $neto,
  1533.                         'iva' => '21',
  1534.                         'total' => $subtotal,
  1535.                     );
  1536.                 }
  1537.             } else {
  1538.                 // Es proforma
  1539.                 if (is_null($item->getServicePrice()) or empty($item->getServicePrice())){
  1540.                     $subtotal = 0;
  1541.                     $neto = 0;
  1542.                     $subtotalProduct = 0;
  1544.                 } else {
  1546. //                    $subtotalProduct = $item->getServicePrice() * 1.21;
  1547.                     $subtotalProduct = $item->getSubTotalPrice() * 1.21;
  1548. //                    $subneto = $item->getServicePrice();
  1549.                     $subneto = $item->getSubTotalPrice();
  1551.                     $subtotal =  $subtotalProduct;
  1552.                     $neto =  $subneto;
  1554.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  1555.                     $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  1556.                     $neto = round($neto,2,PHP_ROUND_HALF_UP);
  1558.                     $arrayItems[] = array(
  1559.                         'type' => 'Product',
  1560.                         'name' => $item->getProductName(),
  1561.                         'amount' => $neto,
  1562.                         'iva' => '21',
  1563.                         'total' => $subtotal,
  1564.                     );
  1565.                 }
  1566.             }
  1568.             // Acumula netos totales e IVA
  1569.             $totales_neto_all = $totales_neto_all + $neto;
  1570.             $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * 0.21);
  1571.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1572.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  1573.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  1574.             // Acumula netos totales e IVA
  1576.             $product['neto'] = $product['neto'] + $neto;
  1577.             $product['sumSubT'] = $product['sumSubT'] + $subtotal;
  1578.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1579.             $product['neto'] = round($product['neto'],2,PHP_ROUND_HALF_UP);
  1580.             $product['sumSubT'] = round($product['sumSubT'],2,PHP_ROUND_HALF_UP);
  1582.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1583.                 $data_supplier['product'][$i] = array(
  1584.                     'id' => $item->getId(),
  1585.                     'productName' => $item->getPrdName(),
  1586.                     'productId' => $item->getPrdProductId(),
  1587.                     'dateStart' => $item->getPrdDateStart(),
  1588.                     'dateEnd' => $item->getPrdDateEnd(),
  1589.                     'servicePrice' => $item->getPrdServicePrice(),
  1590.                     'serviceSubTotalPrice' => $subneto,     //antes de IVA
  1591.                     'subtotalProduct' => $subtotalProduct,
  1592.                     'iva' => $iva,
  1593.                     'pax' => $pax,
  1594.                     'qty' => $qty,
  1595.                     'type' => $item->getPrdType(),
  1596.                     'subtotal' => $subtotal,
  1597.                 );
  1598.             } else {
  1599.                 // Es proforma
  1600.                 $data_supplier['product'][$i] = array(
  1601.                     'id' => $item->getId(),
  1602.                     'productName' => $item->getProductName(),
  1603.                     'productId' => $item->getProductId(),
  1604.                     'dateStart' => $item->getDateStart(),
  1605.                     'dateEnd' => $item->getDateEnd(),
  1606.                     'servicePrice' => $item->getServicePrice(),
  1607.                     'subtotalProduct' => $subtotalProduct,
  1608.                     'iva' => $iva,
  1609.                     'pax' => $pax,
  1610.                     'qty' => $qty,
  1611.                     'type' => $item->getType(),
  1612.                     'subtotal' => $subtotal,
  1613.                 );
  1614.             }
  1615.             $i++;
  1616.         }
  1618.         $data_supplier['productSubTotal'] = array(
  1619.             'neto' => $product['neto'],
  1620.             'sumSubT' => $product['sumSubT'],
  1621.         );
  1623.         $payment = array(
  1624.             'sumSubT' => 0,
  1625.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1627.         $i = 0;
  1628.         foreach ($payments as $item){
  1630.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1631.                 $payment['sumSubT'] = $payment['sumSubT'] + $item->getPayAmountTotal();
  1632.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1633.                 $payment['sumSubT'] = round($payment['sumSubT'], 2, PHP_ROUND_HALF_UP);
  1635.                 $data_supplier['payment'][$i] = array(
  1636.                     'id' => $item->getId(),
  1637.                     'amount' => $item->getPayAmount(),
  1638.                     'amountTotal' => $item->getPayAmountTotal(),
  1639.                     'vat' => $item->getPayVat(),
  1640.                     'datePayAt' => $item->getPayDatePayAt(),
  1641.                     'wayToPay' => $item->getPayWayToPay(),
  1642.                 );
  1644.                 $arrayItems[] = array(
  1645.                     'type' => 'Payment',
  1646.                     'name' => $item->getPayWayToPay(),
  1647.                     'amount' => $item->getPayAmount(),
  1648.                     'total' => $item->getPayAmountTotal(),
  1649.                     'iva' => $item->getPayVat(),
  1650.                 );
  1651.             } else {
  1652.                 // Es una proforma
  1653.                 $payment['sumSubT'] = $payment['sumSubT'] + $item->getAmountTotal();
  1654.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1655.                 $payment['sumSubT'] = round($payment['sumSubT'], 2, PHP_ROUND_HALF_UP);
  1657.                 $data_supplier['payment'][$i] = array(
  1658.                     'id' => $item->getId(),
  1659.                     'amount' => $item->getAmount(),
  1660.                     'amountTotal' => $item->getAmountTotal(),
  1661.                     'vat' => $item->getVat(),
  1662.                     'datePayAt' => $item->getDatePayAt(),
  1663.                     'wayToPay' => $item->getWayToPay(),
  1664.                 );
  1666.                 $arrayItems[] = array(
  1667.                     'type' => 'Payment',
  1668.                     'name' => $item->getWayToPay(),
  1669.                     'amount' => $item->getAmount(),
  1670.                     'total' => $item->getAmountTotal(),
  1671.                     'iva' => $item->getVat(),
  1672.                 );
  1673.             }
  1674.             $i++;
  1675.         }
  1677.         if (!empty($payments)) {
  1678.             $data_supplier['paymentSubTotal'] = array(
  1679.                 'sumSubT' => $payment['sumSubT'],
  1680.             );
  1681.         }
  1683.         foreach ($services as $item){
  1684.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1685.                 if (is_null($item->getSrvPrice()) or empty($item->getSrvPrice())) {
  1686.                     $subtotal = 0;
  1687.                     $neto = 0;
  1688.                     $subtotalService = 0;
  1690.                 } else {
  1691.                     $subtotalService = $item->getSrvPrice();
  1692.                     $subneto = $item->getSrvPrice();
  1694.                     // Commission
  1695.                     if ($item->getSrvOpCommission() == '1') {
  1696.                         $subtotalService = $subtotalService * (1 + ($item->getSrvCommission() / 100));
  1697.                         $subneto = $subneto * (1 + ($item->getSrvCommission() / 100));
  1698.                     } else {
  1699.                         $subtotalService = $subtotalService * (1 - ($item->getSrvCommission() / 100));
  1700.                         $subneto = $subneto * (1 - ($item->getSrvCommission() / 100));
  1701.                     }
  1703.                     // Over
  1704.                     if ($item->getSrvOpOver() == '1') {
  1705.                         $subtotalService = $subtotalService + $item->getSrvOver();
  1706.                         $subneto = $subneto + $item->getSrvOver();
  1707.                     } else {
  1708.                         $subtotalService = $subtotalService - $item->getSrvOver();
  1709.                         $subneto = $subneto - $item->getSrvOver();
  1710.                     }
  1712.                     // IVA
  1713.                     if ($item->getSrvOpIva() == '1') {
  1714.                         $subtotalService = $subtotalService * (1 + ($item->getSrvIva() / 100));
  1715.                     } else {
  1716.                         $subtotalService = $item->getSrvPrice();
  1717.                         $subneto = ($subneto * 100) / (100 + $item->getSrvIva());
  1718.                     }
  1720.                     switch ($item->getSrvServiceCatId()) {
  1721.                         case 1: // Alojamiento
  1722.                             // el numero de noches $numNoches; precio unitario $subneto
  1723.                             $numNoches = (($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days;
  1724.                             // La personas no afectan este calculo
  1725.                             $subtotal = $subtotalService * $numNoches * $item->getSrvUnits();
  1726.                             $subnetoUnit = $subneto;
  1728.                             $subneto = $subneto * $numNoches * $item->getSrvUnits();
  1730.                             $data_supplier['service'][$i] = array(
  1731.                                 'id' => $item->getId(),
  1732.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1733.                                 'serviceName' => $item->getSrvName(),
  1734.                                 'serviceType' => 'Hotel',
  1735.                                 'date' => ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y'),
  1736.                                 'qty' => $item->getSrvUnits(),
  1737.                                 'iva' => $item->getSrvIva(),
  1738.                                 'pax' => '-',
  1739.                                 'precioUnit' => $subnetoUnit,
  1740.                                 'subneto' => $subneto,
  1741.                                 'subtotal' => $subtotal,
  1742.                             );
  1743.                             break;
  1745.                         case 2: //Actividades
  1746.                             // El número de personas es considerado en el calculo
  1747.                             $pax = $item->getSrvPax();
  1748.                             if (empty($pax) or $pax == "0") {
  1749.                                 $pax = 1;
  1750.                             }
  1751.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1753.                             if ($days > 1) {
  1754.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1755.                             } else {
  1756.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1757.                             }
  1759.                             $subtotal = $subtotalService * $days * $item->getSrvUnits();
  1760.                             $subnetoUnit = $subneto;
  1761.                             $subneto = $subneto * $days * $item->getSrvUnits();
  1763.                             $data_supplier['service'][$i] = array(
  1764.                                 'id' => $item->getId(),
  1765.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1766.                                 'serviceName' => $item->getSrvName(),
  1767.                                 'serviceType' => 'Actividad',
  1768.                                 'date' => $dateServ,
  1769.                                 'qty' => $item->getSrvUnits(),
  1770.                                 'iva' => $item->getSrvIva(),
  1771.                                 'pax' => $item->getSrvPax(),
  1772.                                 'precioUnit' => $subnetoUnit,
  1773.                                 'subneto' => $subneto,
  1774.                                 'subtotal' => $subtotal,
  1775.                             );
  1776.                             break;
  1778.                         case 3: // AV
  1779.                             $pax = $item->getSrvPax();
  1780.                             if (empty($pax) or $pax == "0") {
  1781.                                 $pax = 1;
  1782.                             }
  1784.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1785.                             if ($days > 1) {
  1786.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1787.                             } else {
  1788.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1789.                             }
  1791.                             $unitsServ = $item->getSrvUnits();
  1792.                             if (empty($unitsServ) or $unitsServ == "0") {
  1793.                                 $unitsServ = 1;
  1794.                             }
  1796.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1797.                             $subnetoUnit = $subneto;
  1798.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1800.                             $data_supplier['service'][$i] = array(
  1801.                                 'id' => $item->getId(),
  1802.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1803.                                 'serviceName' => $item->getSrvName(),
  1804.                                 'serviceType' => 'AV',
  1805.                                 'date' => $dateServ,
  1806.                                 'qty' => $unitsServ,
  1807.                                 'iva' => $item->getSrvIva(),
  1808.                                 'pax' => $item->getSrvPax(),
  1809.                                 'precioUnit' => $subnetoUnit,
  1810.                                 'subneto' => $subneto,
  1811.                                 'subtotal' => $subtotal,
  1812.                             );
  1813.                             break;
  1815.                         case 4: //Creative
  1816.                             $pax = $item->getSrvPax();
  1817.                             if (empty($pax) or $pax == "0") {
  1818.                                 $pax = 1;
  1819.                             }
  1821.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1822.                             if ($days > 1) {
  1823.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1824.                             } else {
  1825.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1826.                             }
  1828.                             $unitsServ = $item->getSrvUnits();
  1829.                             if (empty($unitsServ) or $unitsServ == "0") {
  1830.                                 $unitsServ = 1;
  1831.                             }
  1833.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1834.                             $subnetoUnit = $subneto;
  1835.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1837.                             $data_supplier['service'][$i] = array(
  1838.                                 'id' => $item->getId(),
  1839.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1840.                                 'serviceName' => $item->getSrvName(),
  1841.                                 'serviceType' => 'Creativo',
  1842.                                 'date' => $dateServ,
  1843.                                 'qty' => $unitsServ,
  1844.                                 'iva' => $item->getSrvIva(),
  1845.                                 'pax' => $item->getSrvPax(),
  1846.                                 'precioUnit' => $subnetoUnit,
  1847.                                 'subneto' => $subneto,
  1848.                                 'subtotal' => $subtotal,
  1849.                             );
  1850.                             break;
  1852.                         case 5: //Cruise
  1853.                             $pax = $item->getSrvPax();
  1854.                             if (empty($pax) or $pax == "0") {
  1855.                                 $pax = 1;
  1856.                             }
  1858.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days);
  1859.                             if ($days > 1) {
  1860.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1861.                             } else {
  1862.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1863.                             }
  1865.                             $unitsServ = $item->getSrvUnits();
  1866.                             if (empty($unitsServ) or $unitsServ == "0") {
  1867.                                 $unitsServ = 1;
  1868.                             }
  1870.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1871.                             $subnetoUnit = $subneto;
  1872.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1874.                             $data_supplier['service'][$i] = array(
  1875.                                 'id' => $item->getId(),
  1876.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1877.                                 'serviceName' => $item->getSrvName(),
  1878.                                 'serviceType' => 'Crucero',
  1879.                                 'date' => $dateServ,
  1880.                                 'qty' => $unitsServ,
  1881.                                 'iva' => $item->getSrvIva(),
  1882.                                 'pax' => $item->getSrvPax(),
  1883.                                 'precioUnit' => $subnetoUnit,
  1884.                                 'subneto' => $subneto,
  1885.                                 'subtotal' => $subtotal,
  1886.                             );
  1887.                             break;
  1889.                         case 6: //Entertaiment
  1890.                             $pax = $item->getSrvPax();
  1891.                             if (empty($pax) or $pax == "0") {
  1892.                                 $pax = 1;
  1893.                             }
  1895.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1896.                             if ($days > 1) {
  1897.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1898.                             } else {
  1899.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1900.                             }
  1902.                             $unitsServ = $item->getSrvUnits();
  1903.                             if (empty($unitsServ) or $unitsServ == "0") {
  1904.                                 $unitsServ = 1;
  1905.                             }
  1907.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1908.                             $subnetoUnit = $subneto;
  1909.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1911.                             $data_supplier['service'][$i] = array(
  1912.                                 'id' => $item->getId(),
  1913.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1914.                                 'serviceName' => $item->getSrvName(),
  1915.                                 'serviceType' => 'Entretenimiento',
  1916.                                 'date' => $dateServ,
  1917.                                 'qty' => $unitsServ,
  1918.                                 'iva' => $item->getSrvIva(),
  1919.                                 'pax' => $item->getSrvPax(),
  1920.                                 'precioUnit' => $subnetoUnit,
  1921.                                 'subneto' => $subneto,
  1922.                                 'subtotal' => $subtotal,
  1923.                             );
  1924.                             break;
  1926.                         case 7: // Gifts
  1927.                             $pax = $item->getSrvPax();
  1928.                             if (empty($pax) or $pax == "0") {
  1929.                                 $pax = 1;
  1930.                             }
  1932. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1933.                             $days = 1;
  1934.                             if ($days > 1) {
  1935.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1936.                             } else {
  1937.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1938.                             }
  1940.                             $unitsServ = $item->getSrvUnits();
  1941.                             if (empty($unitsServ) or $unitsServ == "0") {
  1942.                                 $unitsServ = 1;
  1943.                             }
  1945.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1946.                             $subnetoUnit = $subneto;
  1947.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1949.                             $data_supplier['service'][$i] = array(
  1950.                                 'id' => $item->getId(),
  1951.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1952.                                 'serviceName' => $item->getSrvName(),
  1953.                                 'serviceType' => 'Regalos',
  1954.                                 'date' => $dateServ,
  1955.                                 'qty' => $unitsServ,
  1956.                                 'iva' => $item->getSrvIva(),
  1957.                                 'pax' => $item->getSrvPax(),
  1958.                                 'precioUnit' => $subnetoUnit,
  1959.                                 'subneto' => $subneto,
  1960.                                 'subtotal' => $subtotal,
  1961.                             );
  1962.                             break;
  1964.                         case 8: //Guide
  1965.                             $pax = $item->getSrvPax();
  1966.                             if (empty($pax) or $pax == "0") {
  1967.                                 $pax = 1;
  1968.                             }
  1970.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1971.                             if ($days > 1) {
  1972.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1973.                             } else {
  1974.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1975.                             }
  1977.                             $unitsServ = $item->getSrvUnits();
  1978.                             if (empty($unitsServ) or $unitsServ == "0") {
  1979.                                 $unitsServ = 1;
  1980.                             }
  1982.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1983.                             $subnetoUnit = $subneto;
  1984.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1986.                             $data_supplier['service'][$i] = array(
  1987.                                 'id' => $item->getId(),
  1988.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1989.                                 'serviceName' => $item->getSrvName(),
  1990.                                 'serviceType' => 'Regalos',
  1991.                                 'date' => $dateServ,
  1992.                                 'qty' => $unitsServ,
  1993.                                 'iva' => $item->getSrvIva(),
  1994.                                 'pax' => $item->getSrvPax(),
  1995.                                 'precioUnit' => $subnetoUnit,
  1996.                                 'subneto' => $subneto,
  1997.                                 'subtotal' => $subtotal,
  1998.                             );
  1999.                             break;
  2001.                         case 9: //Itineraries
  2002.                             $pax = $item->getSrvPax();
  2003.                             if (empty($pax) or $pax == "0") {
  2004.                                 $pax = 1;
  2005.                             }
  2007.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  2008.                             if ($days > 1) {
  2009.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2010.                             } else {
  2011.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  2012.                             }
  2014.                             $unitsServ = $item->getSrvUnits();
  2015.                             if (empty($unitsServ) or $unitsServ == "0") {
  2016.                                 $unitsServ = 1;
  2017.                             }
  2019.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2020.                             $subnetoUnit = $subneto;
  2021.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2023.                             $data_supplier['service'][$i] = array(
  2024.                                 'id' => $item->getId(),
  2025.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2026.                                 'serviceName' => $item->getSrvName(),
  2027.                                 'serviceType' => 'Itinerarios',
  2028.                                 'date' => $dateServ,
  2029.                                 'qty' => $unitsServ,
  2030.                                 'iva' => $item->getSrvIva(),
  2031.                                 'pax' => $item->getSrvPax(),
  2032.                                 'precioUnit' => $subnetoUnit,
  2033.                                 'subneto' => $subneto,
  2034.                                 'subtotal' => $subtotal,
  2035.                             );
  2036.                             break;
  2038.                         case 10: //Lounge  -- No Aplica
  2039. //                        $pax = $item->getPax();
  2040. //                        if (empty($pax) or $pax == "0") {
  2041. //                            $pax = 1;
  2042. //                        }
  2043. //
  2044. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2045. //                        if ($days > 1){
  2046. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2047. //                        } else {
  2048. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2049. //                        }
  2050. //
  2051. //                        $unitsServ = $item->getUnits();
  2052. //                        if (empty($unitsServ) or $unitsServ == "0") {
  2053. //                            $unitsServ = 1;
  2054. //                        }
  2055. //
  2056. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2057. //                        $subnetoUnit = $subneto;
  2058. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  2059. //
  2060. //                        $data_supplier['service'][$i] = array (
  2061. //                            'id' => $item->getId(),
  2062. //                            'serviceCatId' => $item->getServiceCatId(),
  2063. //                            'serviceName' => $item->getName(),
  2064. //                            'serviceType' => 'Itinerarios',
  2065. //                            'date' => $dateServ,
  2066. //                            'qty' => $unitsServ,
  2067. //                            'iva' => $item->getIva(),
  2068. //                            'pax' => $item->getPax(),
  2069. //                            'precioUnit' => $subnetoUnit,
  2070. //                            'subneto' => $subneto,
  2071. //                            'subtotal' => $subtotal,
  2072. //                        );
  2073.                             break;
  2075.                         case 11: //Menu
  2076.                             $pax = $item->getSrvPax();
  2077.                             if (empty($pax) or $pax == "0") {
  2078.                                 $pax = 1;
  2079.                             }
  2081.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  2082.                             if ($days > 1) {
  2083.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2084.                             } else {
  2085.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  2086.                             }
  2088.                             $unitsServ = $item->getSrvUnits();
  2089.                             if (empty($unitsServ) or $unitsServ == "0") {
  2090.                                 $unitsServ = 1;
  2091.                             }
  2093.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2094.                             $subnetoUnit = $subneto;
  2095.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2097.                             $data_supplier['service'][$i] = array(
  2098.                                 'id' => $item->getId(),
  2099.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2100.                                 'serviceName' => $item->getSrvName(),
  2101.                                 'serviceType' => 'Menú',
  2102.                                 'date' => $dateServ,
  2103.                                 'qty' => $unitsServ,
  2104.                                 'iva' => $item->getSrvIva(),
  2105.                                 'pax' => $item->getSrvPax(),
  2106.                                 'precioUnit' => $subnetoUnit,
  2107.                                 'subneto' => $subneto,
  2108.                                 'subtotal' => $subtotal,
  2109.                             );
  2110.                             break;
  2112.                         case 12: //Others
  2113.                             $pax = $item->getSrvPax();
  2114.                             if (empty($pax) or $pax == "0") {
  2115.                                 $pax = 1;
  2116.                             }
  2118.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  2119.                             if ($days > 1) {
  2120.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2121.                             } else {
  2122.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  2123.                             }
  2125.                             $unitsServ = $item->getSrvUnits();
  2126.                             if (empty($unitsServ) or $unitsServ == "0") {
  2127.                                 $unitsServ = 1;
  2128.                             }
  2130.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2131.                             $subnetoUnit = $subneto;
  2132.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2134.                             $data_supplier['service'][$i] = array(
  2135.                                 'id' => $item->getId(),
  2136.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2137.                                 'serviceName' => $item->getSrvName(),
  2138.                                 'serviceType' => 'Otros',
  2139.                                 'date' => $dateServ,
  2140.                                 'qty' => $unitsServ,
  2141.                                 'iva' => $item->getSrvIva(),
  2142.                                 'pax' => $item->getSrvPax(),
  2143.                                 'precioUnit' => $subnetoUnit,
  2144.                                 'subneto' => $subneto,
  2145.                                 'subtotal' => $subtotal,
  2146.                             );
  2147.                             break;
  2149.                         case 13: //Transport
  2150.                             $pax = $item->getSrvPax();
  2151.                             if (empty($pax) or $pax == "0") {
  2152.                                 $pax = 1;
  2153.                             }
  2155.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  2156.                             if ($days > 1) {
  2157.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2158.                             } else {
  2159.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  2160.                             }
  2162.                             $unitsServ = $item->getSrvUnits();
  2163.                             if (empty($unitsServ) or $unitsServ == "0") {
  2164.                                 $unitsServ = 1;
  2165.                             }
  2167.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2168.                             $subnetoUnit = $subneto;
  2169.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2171.                             $data_supplier['service'][$i] = array(
  2172.                                 'id' => $item->getId(),
  2173.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2174.                                 'serviceName' => $item->getSrvName(),
  2175.                                 'serviceType' => 'Transporte',
  2176.                                 'date' => $dateServ,
  2177.                                 'qty' => $unitsServ,
  2178.                                 'iva' => $item->getSrvIva(),
  2179.                                 'pax' => $item->getSrvPax(),
  2180.                                 'precioUnit' => $subnetoUnit,
  2181.                                 'subneto' => $subneto,
  2182.                                 'subtotal' => $subtotal,
  2183.                             );
  2184.                             break;
  2186.                         case 14: //Technology
  2187.                             $pax = $item->getSrvPax();
  2188.                             if (empty($pax) or $pax == "0") {
  2189.                                 $pax = 1;
  2190.                             }
  2192. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2193.                             $days = 1;
  2194. //                        if ($days > 1){
  2195. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2196. //                        } else {
  2197. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2198. //                        }
  2199.                             $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2201.                             $unitsServ = $item->getSrvUnits();
  2202.                             if (empty($unitsServ) or $unitsServ == "0") {
  2203.                                 $unitsServ = 1;
  2204.                             }
  2206.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2207.                             $subnetoUnit = $subneto;
  2208.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2210.                             $data_supplier['service'][$i] = array(
  2211.                                 'id' => $item->getId(),
  2212.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2213.                                 'serviceName' => $item->getSrvName(),
  2214.                                 'serviceType' => 'Tecnología',
  2215.                                 'date' => $dateServ,
  2216.                                 'qty' => $unitsServ,
  2217.                                 'iva' => $item->getSrvIva(),
  2218.                                 'pax' => $item->getSrvPax(),
  2219.                                 'precioUnit' => $subnetoUnit,
  2220.                                 'subneto' => $subneto,
  2221.                                 'subtotal' => $subtotal,
  2222.                             );
  2223.                             break;
  2225.                         case 15: //Assisstant
  2226.                             $pax = $item->getSrvPax();
  2227.                             if (empty($pax) or $pax == "0") {
  2228.                                 $pax = 1;
  2229.                             }
  2231.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  2232.                             if ($days > 1) {
  2233.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2234.                             } else {
  2235.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  2236.                             }
  2238.                             $unitsServ = $item->getSrvUnits();
  2239.                             if (empty($unitsServ) or $unitsServ == "0") {
  2240.                                 $unitsServ = 1;
  2241.                             }
  2243.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2244.                             $subnetoUnit = $subneto;
  2245.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2247.                             $data_supplier['service'][$i] = array(
  2248.                                 'id' => $item->getId(),
  2249.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2250.                                 'serviceName' => $item->getSrvName(),
  2251.                                 'serviceType' => 'Asistente',
  2252.                                 'date' => $dateServ,
  2253.                                 'qty' => $unitsServ,
  2254.                                 'iva' => $item->getSrvIva(),
  2255.                                 'pax' => $item->getSrvPax(),
  2256.                                 'precioUnit' => $subnetoUnit,
  2257.                                 'subneto' => $subneto,
  2258.                                 'subtotal' => $subtotal,
  2259.                             );
  2260.                             break;
  2262.                         case 16: //DDR
  2263.                             $pax = $item->getSrvPax();
  2264.                             if (empty($pax) or $pax == "0") {
  2265.                                 $pax = 1;
  2266.                             }
  2268.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  2269.                             if ($days > 1) {
  2270.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2271.                             } else {
  2272.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  2273.                             }
  2275.                             $unitsServ = $item->getSrvUnits();
  2276.                             if (empty($unitsServ) or $unitsServ == "0") {
  2277.                                 $unitsServ = 1;
  2278.                             }
  2280.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2281.                             $subnetoUnit = $subneto;
  2282.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2284.                             $data_supplier['service'][$i] = array(
  2285.                                 'id' => $item->getId(),
  2286.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2287.                                 'serviceName' => $item->getSrvName(),
  2288.                                 'serviceType' => 'DDR',
  2289.                                 'date' => $dateServ,
  2290.                                 'qty' => $unitsServ,
  2291.                                 'iva' => $item->getSrvIva(),
  2292.                                 'pax' => $item->getSrvPax(),
  2293.                                 'precioUnit' => $subnetoUnit,
  2294.                                 'subneto' => $subneto,
  2295.                                 'subtotal' => $subtotal,
  2296.                             );
  2297.                             break;
  2299.                         default:
  2300.                             break;
  2301.                     }
  2303.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  2304.                     $subtotal = round($subtotal, 2, PHP_ROUND_HALF_UP);
  2305.                     $neto = round($subneto, 2, PHP_ROUND_HALF_UP);
  2307.                     $arrayItems[] = array(
  2308.                         'type' => 'Service',
  2309.                         'name' => $item->getSrvName(),
  2310.                         'amount' => $neto,
  2311.                         'iva' => $item->getSrvIva(),
  2312.                         'total' => $subtotal,
  2313.                     );
  2315.                 }
  2317.                 switch ($item->getSrvIva()) {
  2318.                     // Acumula IVA
  2319.                     case 21:
  2320.                         $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getSrvIva() / 100));
  2321.                         break;
  2323.                     case 10:
  2324.                         $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getSrvIva() / 100));
  2325.                         break;
  2327.                     case 0:
  2328.                         break;
  2330.                     default:
  2331.                         break;
  2333.                 }
  2334.             } else {
  2335.                 // Es una proforma
  2336.                 if (is_null($item->getPrice()) or empty($item->getPrice())) {
  2337.                     $subtotal = 0;
  2338.                     $neto = 0;
  2339.                     $subtotalService = 0;
  2341.                 } else {
  2342.                     $subtotalService = $item->getPrice();
  2343.                     $subneto = $item->getPrice();
  2345.                     // Commission
  2346.                     if ($item->getOpCommission() == '1') {
  2347.                         $subtotalService = $subtotalService * (1 + ($item->getCommission() / 100));
  2348.                         $subneto = $subneto * (1 + ($item->getCommission() / 100));
  2349.                     } else {
  2350.                         $subtotalService = $subtotalService * (1 - ($item->getCommission() / 100));
  2351.                         $subneto = $subneto * (1 - ($item->getCommission() / 100));
  2352.                     }
  2354.                     // Over
  2355.                     if ($item->getOpOver() == '1') {
  2356.                         $subtotalService = $subtotalService + $item->getOver();
  2357.                         $subneto = $subneto + $item->getOver();
  2358.                     } else {
  2359.                         $subtotalService = $subtotalService - $item->getOver();
  2360.                         $subneto = $subneto - $item->getOver();
  2361.                     }
  2363.                     // IVA
  2364.                     if ($item->getOpIva() == '1') {
  2365.                         $subtotalService = $subtotalService * (1 + ($item->getIva() / 100));
  2366.                     } else {
  2367.                         $subtotalService = $item->getPrice();
  2368.                         $subneto = ($subneto * 100) / (100 + $item->getIva());
  2369.                     }
  2371.                     switch ($item->getServiceCatId()) {
  2372.                         case 1: // Alojamiento
  2373.                             // el numero de noches $numNoches; precio unitario $subneto
  2374.                             $numNoches = (($item->getDateOutAt())->diff($item->getDateInAt()))->days;
  2375.                             // La personas no afectan este calculo
  2376.                             $subtotal = $subtotalService * $numNoches * $item->getUnits();
  2377.                             $subnetoUnit = $subneto;
  2379.                             $subneto = $subneto * $numNoches * $item->getUnits();
  2381.                             $data_supplier['service'][$i] = array(
  2382.                                 'id' => $item->getId(),
  2383.                                 'serviceCatId' => $item->getServiceCatId(),
  2384.                                 'serviceName' => $item->getName(),
  2385.                                 'serviceType' => 'Hotel',
  2386.                                 'date' => ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y'),
  2387.                                 'qty' => $item->getUnits(),
  2388.                                 'iva' => $item->getIva(),
  2389.                                 'pax' => '-',
  2390.                                 'precioUnit' => $subnetoUnit,
  2391.                                 'subneto' => $subneto,
  2392.                                 'subtotal' => $subtotal,
  2393.                             );
  2394.                             break;
  2396.                         case 2: //Actividades
  2397.                             // El número de personas es considerado en el calculo
  2398.                             $pax = $item->getPax();
  2399.                             if (empty($pax) or $pax == "0") {
  2400.                                 $pax = 1;
  2401.                             }
  2402.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2404.                             if ($days > 1) {
  2405.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2406.                             } else {
  2407.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2408.                             }
  2410.                             $subtotal = $subtotalService * $days * $item->getUnits();
  2411.                             $subnetoUnit = $subneto;
  2412.                             $subneto = $subneto * $days * $item->getUnits();
  2414.                             $data_supplier['service'][$i] = array(
  2415.                                 'id' => $item->getId(),
  2416.                                 'serviceCatId' => $item->getServiceCatId(),
  2417.                                 'serviceName' => $item->getName(),
  2418.                                 'serviceType' => 'Actividad',
  2419.                                 'date' => $dateServ,
  2420.                                 'qty' => $item->getUnits(),
  2421.                                 'iva' => $item->getIva(),
  2422.                                 'pax' => $item->getPax(),
  2423.                                 'precioUnit' => $subnetoUnit,
  2424.                                 'subneto' => $subneto,
  2425.                                 'subtotal' => $subtotal,
  2426.                             );
  2427.                             break;
  2429.                         case 3: // AV
  2430.                             $pax = $item->getPax();
  2431.                             if (empty($pax) or $pax == "0") {
  2432.                                 $pax = 1;
  2433.                             }
  2435.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2436.                             if ($days > 1) {
  2437.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2438.                             } else {
  2439.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2440.                             }
  2442.                             $unitsServ = $item->getUnits();
  2443.                             if (empty($unitsServ) or $unitsServ == "0") {
  2444.                                 $unitsServ = 1;
  2445.                             }
  2447.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2448.                             $subnetoUnit = $subneto;
  2449.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2451.                             $data_supplier['service'][$i] = array(
  2452.                                 'id' => $item->getId(),
  2453.                                 'serviceCatId' => $item->getServiceCatId(),
  2454.                                 'serviceName' => $item->getName(),
  2455.                                 'serviceType' => 'AV',
  2456.                                 'date' => $dateServ,
  2457.                                 'qty' => $unitsServ,
  2458.                                 'iva' => $item->getIva(),
  2459.                                 'pax' => $item->getPax(),
  2460.                                 'precioUnit' => $subnetoUnit,
  2461.                                 'subneto' => $subneto,
  2462.                                 'subtotal' => $subtotal,
  2463.                             );
  2464.                             break;
  2466.                         case 4: //Creative
  2467.                             $pax = $item->getPax();
  2468.                             if (empty($pax) or $pax == "0") {
  2469.                                 $pax = 1;
  2470.                             }
  2472.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2473.                             if ($days > 1) {
  2474.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2475.                             } else {
  2476.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2477.                             }
  2479.                             $unitsServ = $item->getUnits();
  2480.                             if (empty($unitsServ) or $unitsServ == "0") {
  2481.                                 $unitsServ = 1;
  2482.                             }
  2484.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2485.                             $subnetoUnit = $subneto;
  2486.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2488.                             $data_supplier['service'][$i] = array(
  2489.                                 'id' => $item->getId(),
  2490.                                 'serviceCatId' => $item->getServiceCatId(),
  2491.                                 'serviceName' => $item->getName(),
  2492.                                 'serviceType' => 'Creativo',
  2493.                                 'date' => $dateServ,
  2494.                                 'qty' => $unitsServ,
  2495.                                 'iva' => $item->getIva(),
  2496.                                 'pax' => $item->getPax(),
  2497.                                 'precioUnit' => $subnetoUnit,
  2498.                                 'subneto' => $subneto,
  2499.                                 'subtotal' => $subtotal,
  2500.                             );
  2501.                             break;
  2503.                         case 5: //Cruise
  2504.                             $pax = $item->getPax();
  2505.                             if (empty($pax) or $pax == "0") {
  2506.                                 $pax = 1;
  2507.                             }
  2509.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days);
  2510.                             if ($days > 1) {
  2511.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2512.                             } else {
  2513.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2514.                             }
  2516.                             $unitsServ = $item->getUnits();
  2517.                             if (empty($unitsServ) or $unitsServ == "0") {
  2518.                                 $unitsServ = 1;
  2519.                             }
  2521.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2522.                             $subnetoUnit = $subneto;
  2523.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2525.                             $data_supplier['service'][$i] = array(
  2526.                                 'id' => $item->getId(),
  2527.                                 'serviceCatId' => $item->getServiceCatId(),
  2528.                                 'serviceName' => $item->getName(),
  2529.                                 'serviceType' => 'Crucero',
  2530.                                 'date' => $dateServ,
  2531.                                 'qty' => $unitsServ,
  2532.                                 'iva' => $item->getIva(),
  2533.                                 'pax' => $item->getPax(),
  2534.                                 'precioUnit' => $subnetoUnit,
  2535.                                 'subneto' => $subneto,
  2536.                                 'subtotal' => $subtotal,
  2537.                             );
  2538.                             break;
  2540.                         case 6: //Entertaiment
  2541.                             $pax = $item->getPax();
  2542.                             if (empty($pax) or $pax == "0") {
  2543.                                 $pax = 1;
  2544.                             }
  2546.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2547.                             if ($days > 1) {
  2548.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2549.                             } else {
  2550.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2551.                             }
  2553.                             $unitsServ = $item->getUnits();
  2554.                             if (empty($unitsServ) or $unitsServ == "0") {
  2555.                                 $unitsServ = 1;
  2556.                             }
  2558.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2559.                             $subnetoUnit = $subneto;
  2560.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2562.                             $data_supplier['service'][$i] = array(
  2563.                                 'id' => $item->getId(),
  2564.                                 'serviceCatId' => $item->getServiceCatId(),
  2565.                                 'serviceName' => $item->getName(),
  2566.                                 'serviceType' => 'Entretenimiento',
  2567.                                 'date' => $dateServ,
  2568.                                 'qty' => $unitsServ,
  2569.                                 'iva' => $item->getIva(),
  2570.                                 'pax' => $item->getPax(),
  2571.                                 'precioUnit' => $subnetoUnit,
  2572.                                 'subneto' => $subneto,
  2573.                                 'subtotal' => $subtotal,
  2574.                             );
  2575.                             break;
  2577.                         case 7: // Gifts
  2578.                             $pax = $item->getPax();
  2579.                             if (empty($pax) or $pax == "0") {
  2580.                                 $pax = 1;
  2581.                             }
  2583. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2584.                             $days = 1;
  2585.                             if ($days > 1) {
  2586.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2587.                             } else {
  2588.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2589.                             }
  2591.                             $unitsServ = $item->getUnits();
  2592.                             if (empty($unitsServ) or $unitsServ == "0") {
  2593.                                 $unitsServ = 1;
  2594.                             }
  2596.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2597.                             $subnetoUnit = $subneto;
  2598.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2600.                             $data_supplier['service'][$i] = array(
  2601.                                 'id' => $item->getId(),
  2602.                                 'serviceCatId' => $item->getServiceCatId(),
  2603.                                 'serviceName' => $item->getName(),
  2604.                                 'serviceType' => 'Regalos',
  2605.                                 'date' => $dateServ,
  2606.                                 'qty' => $unitsServ,
  2607.                                 'iva' => $item->getIva(),
  2608.                                 'pax' => $item->getPax(),
  2609.                                 'precioUnit' => $subnetoUnit,
  2610.                                 'subneto' => $subneto,
  2611.                                 'subtotal' => $subtotal,
  2612.                             );
  2613.                             break;
  2615.                         case 8: //Guide
  2616.                             $pax = $item->getPax();
  2617.                             if (empty($pax) or $pax == "0") {
  2618.                                 $pax = 1;
  2619.                             }
  2621.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2622.                             if ($days > 1) {
  2623.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2624.                             } else {
  2625.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2626.                             }
  2628.                             $unitsServ = $item->getUnits();
  2629.                             if (empty($unitsServ) or $unitsServ == "0") {
  2630.                                 $unitsServ = 1;
  2631.                             }
  2633.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2634.                             $subnetoUnit = $subneto;
  2635.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2637.                             $data_supplier['service'][$i] = array(
  2638.                                 'id' => $item->getId(),
  2639.                                 'serviceCatId' => $item->getServiceCatId(),
  2640.                                 'serviceName' => $item->getName(),
  2641.                                 'serviceType' => 'Regalos',
  2642.                                 'date' => $dateServ,
  2643.                                 'qty' => $unitsServ,
  2644.                                 'iva' => $item->getIva(),
  2645.                                 'pax' => $item->getPax(),
  2646.                                 'precioUnit' => $subnetoUnit,
  2647.                                 'subneto' => $subneto,
  2648.                                 'subtotal' => $subtotal,
  2649.                             );
  2650.                             break;
  2652.                         case 9: //Itineraries
  2653.                             $pax = $item->getPax();
  2654.                             if (empty($pax) or $pax == "0") {
  2655.                                 $pax = 1;
  2656.                             }
  2658.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2659.                             if ($days > 1) {
  2660.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2661.                             } else {
  2662.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2663.                             }
  2665.                             $unitsServ = $item->getUnits();
  2666.                             if (empty($unitsServ) or $unitsServ == "0") {
  2667.                                 $unitsServ = 1;
  2668.                             }
  2670.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2671.                             $subnetoUnit = $subneto;
  2672.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2674.                             $data_supplier['service'][$i] = array(
  2675.                                 'id' => $item->getId(),
  2676.                                 'serviceCatId' => $item->getServiceCatId(),
  2677.                                 'serviceName' => $item->getName(),
  2678.                                 'serviceType' => 'Itinerarios',
  2679.                                 'date' => $dateServ,
  2680.                                 'qty' => $unitsServ,
  2681.                                 'iva' => $item->getIva(),
  2682.                                 'pax' => $item->getPax(),
  2683.                                 'precioUnit' => $subnetoUnit,
  2684.                                 'subneto' => $subneto,
  2685.                                 'subtotal' => $subtotal,
  2686.                             );
  2687.                             break;
  2689.                         case 10: //Lounge  -- No Aplica
  2690. //                        $pax = $item->getPax();
  2691. //                        if (empty($pax) or $pax == "0") {
  2692. //                            $pax = 1;
  2693. //                        }
  2694. //
  2695. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2696. //                        if ($days > 1){
  2697. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2698. //                        } else {
  2699. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2700. //                        }
  2701. //
  2702. //                        $unitsServ = $item->getUnits();
  2703. //                        if (empty($unitsServ) or $unitsServ == "0") {
  2704. //                            $unitsServ = 1;
  2705. //                        }
  2706. //
  2707. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2708. //                        $subnetoUnit = $subneto;
  2709. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  2710. //
  2711. //                        $data_supplier['service'][$i] = array (
  2712. //                            'id' => $item->getId(),
  2713. //                            'serviceCatId' => $item->getServiceCatId(),
  2714. //                            'serviceName' => $item->getName(),
  2715. //                            'serviceType' => 'Itinerarios',
  2716. //                            'date' => $dateServ,
  2717. //                            'qty' => $unitsServ,
  2718. //                            'iva' => $item->getIva(),
  2719. //                            'pax' => $item->getPax(),
  2720. //                            'precioUnit' => $subnetoUnit,
  2721. //                            'subneto' => $subneto,
  2722. //                            'subtotal' => $subtotal,
  2723. //                        );
  2724.                             break;
  2726.                         case 11: //Menu
  2727.                             $pax = $item->getPax();
  2728.                             if (empty($pax) or $pax == "0") {
  2729.                                 $pax = 1;
  2730.                             }
  2732.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2733.                             if ($days > 1) {
  2734.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2735.                             } else {
  2736.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2737.                             }
  2739.                             $unitsServ = $item->getUnits();
  2740.                             if (empty($unitsServ) or $unitsServ == "0") {
  2741.                                 $unitsServ = 1;
  2742.                             }
  2744.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2745.                             $subnetoUnit = $subneto;
  2746.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2748.                             $data_supplier['service'][$i] = array(
  2749.                                 'id' => $item->getId(),
  2750.                                 'serviceCatId' => $item->getServiceCatId(),
  2751.                                 'serviceName' => $item->getName(),
  2752.                                 'serviceType' => 'Menú',
  2753.                                 'date' => $dateServ,
  2754.                                 'qty' => $unitsServ,
  2755.                                 'iva' => $item->getIva(),
  2756.                                 'pax' => $item->getPax(),
  2757.                                 'precioUnit' => $subnetoUnit,
  2758.                                 'subneto' => $subneto,
  2759.                                 'subtotal' => $subtotal,
  2760.                             );
  2761.                             break;
  2763.                         case 12: //Others
  2764.                             $pax = $item->getPax();
  2765.                             if (empty($pax) or $pax == "0") {
  2766.                                 $pax = 1;
  2767.                             }
  2769.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2770.                             if ($days > 1) {
  2771.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2772.                             } else {
  2773.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2774.                             }
  2776.                             $unitsServ = $item->getUnits();
  2777.                             if (empty($unitsServ) or $unitsServ == "0") {
  2778.                                 $unitsServ = 1;
  2779.                             }
  2781.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2782.                             $subnetoUnit = $subneto;
  2783.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2785.                             $data_supplier['service'][$i] = array(
  2786.                                 'id' => $item->getId(),
  2787.                                 'serviceCatId' => $item->getServiceCatId(),
  2788.                                 'serviceName' => $item->getName(),
  2789.                                 'serviceType' => 'Otros',
  2790.                                 'date' => $dateServ,
  2791.                                 'qty' => $unitsServ,
  2792.                                 'iva' => $item->getIva(),
  2793.                                 'pax' => $item->getPax(),
  2794.                                 'precioUnit' => $subnetoUnit,
  2795.                                 'subneto' => $subneto,
  2796.                                 'subtotal' => $subtotal,
  2797.                             );
  2798.                             break;
  2800.                         case 13: //Transport
  2801.                             $pax = $item->getPax();
  2802.                             if (empty($pax) or $pax == "0") {
  2803.                                 $pax = 1;
  2804.                             }
  2806.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2807.                             if ($days > 1) {
  2808.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2809.                             } else {
  2810.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2811.                             }
  2813.                             $unitsServ = $item->getUnits();
  2814.                             if (empty($unitsServ) or $unitsServ == "0") {
  2815.                                 $unitsServ = 1;
  2816.                             }
  2818.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2819.                             $subnetoUnit = $subneto;
  2820.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2822.                             $data_supplier['service'][$i] = array(
  2823.                                 'id' => $item->getId(),
  2824.                                 'serviceCatId' => $item->getServiceCatId(),
  2825.                                 'serviceName' => $item->getName(),
  2826.                                 'serviceType' => 'Transporte',
  2827.                                 'date' => $dateServ,
  2828.                                 'qty' => $unitsServ,
  2829.                                 'iva' => $item->getIva(),
  2830.                                 'pax' => $item->getPax(),
  2831.                                 'precioUnit' => $subnetoUnit,
  2832.                                 'subneto' => $subneto,
  2833.                                 'subtotal' => $subtotal,
  2834.                             );
  2835.                             break;
  2837.                         case 14: //Technology
  2838.                             $pax = $item->getPax();
  2839.                             if (empty($pax) or $pax == "0") {
  2840.                                 $pax = 1;
  2841.                             }
  2843. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2844.                             $days = 1;
  2845. //                        if ($days > 1){
  2846. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2847. //                        } else {
  2848. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2849. //                        }
  2850.                             $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2852.                             $unitsServ = $item->getUnits();
  2853.                             if (empty($unitsServ) or $unitsServ == "0") {
  2854.                                 $unitsServ = 1;
  2855.                             }
  2857.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2858.                             $subnetoUnit = $subneto;
  2859.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2861.                             $data_supplier['service'][$i] = array(
  2862.                                 'id' => $item->getId(),
  2863.                                 'serviceCatId' => $item->getServiceCatId(),
  2864.                                 'serviceName' => $item->getName(),
  2865.                                 'serviceType' => 'Tecnología',
  2866.                                 'date' => $dateServ,
  2867.                                 'qty' => $unitsServ,
  2868.                                 'iva' => $item->getIva(),
  2869.                                 'pax' => $item->getPax(),
  2870.                                 'precioUnit' => $subnetoUnit,
  2871.                                 'subneto' => $subneto,
  2872.                                 'subtotal' => $subtotal,
  2873.                             );
  2874.                             break;
  2876.                         case 15: //Assisstant
  2877.                             $pax = $item->getPax();
  2878.                             if (empty($pax) or $pax == "0") {
  2879.                                 $pax = 1;
  2880.                             }
  2882.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2883.                             if ($days > 1) {
  2884.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2885.                             } else {
  2886.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2887.                             }
  2889.                             $unitsServ = $item->getUnits();
  2890.                             if (empty($unitsServ) or $unitsServ == "0") {
  2891.                                 $unitsServ = 1;
  2892.                             }
  2894.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2895.                             $subnetoUnit = $subneto;
  2896.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2898.                             $data_supplier['service'][$i] = array(
  2899.                                 'id' => $item->getId(),
  2900.                                 'serviceCatId' => $item->getServiceCatId(),
  2901.                                 'serviceName' => $item->getName(),
  2902.                                 'serviceType' => 'Asistente',
  2903.                                 'date' => $dateServ,
  2904.                                 'qty' => $unitsServ,
  2905.                                 'iva' => $item->getIva(),
  2906.                                 'pax' => $item->getPax(),
  2907.                                 'precioUnit' => $subnetoUnit,
  2908.                                 'subneto' => $subneto,
  2909.                                 'subtotal' => $subtotal,
  2910.                             );
  2911.                             break;
  2913.                         case 16: //DDR
  2914.                             $pax = $item->getPax();
  2915.                             if (empty($pax) or $pax == "0") {
  2916.                                 $pax = 1;
  2917.                             }
  2919.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2920.                             if ($days > 1) {
  2921.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2922.                             } else {
  2923.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2924.                             }
  2926.                             $unitsServ = $item->getUnits();
  2927.                             if (empty($unitsServ) or $unitsServ == "0") {
  2928.                                 $unitsServ = 1;
  2929.                             }
  2931.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2932.                             $subnetoUnit = $subneto;
  2933.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2935.                             $data_supplier['service'][$i] = array(
  2936.                                 'id' => $item->getId(),
  2937.                                 'serviceCatId' => $item->getServiceCatId(),
  2938.                                 'serviceName' => $item->getName(),
  2939.                                 'serviceType' => 'DDR',
  2940.                                 'date' => $dateServ,
  2941.                                 'qty' => $unitsServ,
  2942.                                 'iva' => $item->getIva(),
  2943.                                 'pax' => $item->getPax(),
  2944.                                 'precioUnit' => $subnetoUnit,
  2945.                                 'subneto' => $subneto,
  2946.                                 'subtotal' => $subtotal,
  2947.                             );
  2948.                             break;
  2950.                         default:
  2951.                             break;
  2952.                     }
  2954.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  2955.                     $subtotal = round($subtotal, 2, PHP_ROUND_HALF_UP);
  2956.                     $neto = round($subneto, 2, PHP_ROUND_HALF_UP);
  2958.                     $arrayItems[] = array(
  2959.                         'type' => 'Service',
  2960.                         'name' => $item->getName(),
  2961.                         'amount' => $neto,
  2962.                         'iva' => $item->getIva(),
  2963.                         'total' => $subtotal,
  2964.                     );
  2966.                 }
  2968.                 switch ($item->getIva()) {
  2969.                     // Acumula IVA
  2970.                     case 21:
  2971.                         $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getIva() / 100));
  2972.                         break;
  2974.                     case 10:
  2975.                         $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getIva() / 100));
  2976.                         break;
  2978.                     case 0:
  2979.                         break;
  2981.                     default:
  2982.                         break;
  2984.                 }
  2985.             }
  2987.             $totales_neto_all = $totales_neto_all + $neto;
  2989.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2990.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  2991.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  2992.             $data_iva['ivaMontoDiez'] = round($data_iva['ivaMontoDiez'],2,PHP_ROUND_HALF_UP);
  2993.             // Acumula netos totales e IVA
  2995.             $service['neto'] = $service['neto'] + $neto;
  2996.             $service['sumSubT'] = $service['sumSubT'] + $subtotal;
  2997.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2998.             $service['neto'] = round($service['neto'],2,PHP_ROUND_HALF_UP);
  2999.             $service['sumSubT'] = round($service['sumSubT'],2,PHP_ROUND_HALF_UP);
  3001.             $i++;
  3002.         }
  3004.         $data_supplier['serviceSubTotal'] = array(
  3005.             'neto' => $service['neto'],
  3006.             'sumSubT' => $service['sumSubT'],
  3007.         );
  3008.         $currency = '€';
  3009.         $totales_total = $totales_neto_all + $data_iva['ivaMontoVeintiUno'] + $data_iva['ivaMontoDiez'];
  3010.         if (!empty($payments)) {
  3011.             $amount_pay = $data_supplier['paymentSubTotal']['sumSubT'];
  3012.         } else {
  3013.             $amount_pay = 0;
  3014.         }
  3015.         $totales_all = $totales_total - $amount_pay;
  3017.         if (empty($dateDocument)){
  3018.             $dateDocument = new DateTime('now');
  3019.         }
  3021.         $data = array(
  3022.             'id' => $fileId,
  3023.             'type' => $type,
  3024. //            'type' => '',
  3025.             'number' => $number,
  3026. //            'prefix' => $prefix,
  3027.             'prefix' => 'AVE-'.(new DateTime('now'))->format('dmy').'-'.$invoiceId,
  3028.             'date' => $dateDocument,
  3029.             'file' => $file,
  3030.             'token' => $file->getAccessKey(),
  3031.             'company' => $company,
  3032.             'clients' => $client,
  3033.             'arrayItems' => $arrayItems,
  3034.             'datasupplier' => $data_supplier,
  3035.             'currency' => $currency,
  3036.             'totales_neto' => $totales_neto_all,
  3037.             'bases_imponibles' => $data_iva,
  3038.             'totales' => $totales_total,
  3039.             'balance' => $totales_all,
  3040.             'paymentInvoice' => $amount_pay,
  3041.         );
  3043.         return $data;
  3044.     }
  3047.     private function sendTelegram($id, $text )
  3048.     {
  3049.         $em = $this->getDoctrine()->getManager();
  3050.         // No es necesario tener una tabla de TelegramUser para el modulo de AvExpress
  3051.         $telegUser = $em->getRepository(MdvTelegramUser::class)->findOneByUserId($id);
  3053.         if (empty($telegUser)){return true;}
  3055.         $parameters = array(
  3056.             'chat_id' => $telegUser->getChatId(),
  3057.             'text' => $text,
  3058.         );
  3060.         $bot_token = $telegUser->getBotToken();
  3061.         $url = "https://api.telegram.org/bot$bot_token/sendMessage";
  3063.         if (!$curl = curl_init()){
  3064.             exit();
  3065.         }
  3067.         curl_setopt($curl,CURLOPT_POST,true);
  3068.         curl_setopt($curl,CURLOPT_POSTFIELDS,$parameters);
  3069.         curl_setopt($curl,CURLOPT_URL,$url);
  3070.         curl_setopt($curl,CURLOPT_RETURNTRANSFER,true);
  3071.         $output = curl_exec($curl);
  3072.         curl_close($curl);
  3074.         return true;
  3075.     }
  3077.     private function baseBenefits($fileId){
  3078.         $em = $this->getDoctrine()->getManager();
  3079. //        $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  3080.         $productsInFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  3082.         $benefitEuro = 0;
  3083.         $benefitPerc = 0;
  3084.         $totalSale = 0;
  3086.         foreach ($productsInFile as $item){
  3087.             if(empty($item->getSupplierExt()) or ($item->getSupplierExt() == 'AV EXPRESS S.L.')){
  3088.                 // El proveedor es AV, el beneficio es 100%
  3089.                 $benefitEuro = $benefitEuro + $item->getSubTotalPrice();
  3091.             } else {
  3092.                 // El proveedor es externo, el beneficio lo determinan el over y la comision
  3093. //                $subTotalPriceExt = $item->getServicePrice() * $item->getUnits() * $item->getDays();        // Precio sin Over ni Comision
  3094. //                $benefitEuro = $benefitEuro + ($item->getSubTotalPrice() - $subTotalPriceExt);
  3096.                 $prdPrice = $item->getServicePrice(); if (empty($prdPrice)){ $prdPrice = 0; }
  3097.                 $prdUnits = $item->getUnits(); if (empty($prdUnits)){ $prdUnits = 1; }
  3098.                 $prdDays = $item->getDays(); if (empty($prdDays)){ $prdDays = 1; }
  3099.                 $prdPax = $item->getPax(); if (empty($prdPax)){ $prdPax = 1; }
  3100.                 $subTotalPriceExt = $prdPrice * $prdUnits * $prdDays * $prdPax;                             // Precio sin Over ni Comision
  3101.                 $benefitEuro = $benefitEuro + ($item->getSubTotalPrice() - $subTotalPriceExt);
  3104.             }
  3105.             $totalSale = $totalSale + $item->getSubTotalPrice();
  3106.         }
  3108.         // Verificamos beneficios simplificados de proveedores
  3109.         $simplyBen = $em->getRepository(AveBenefitsSupplier::class)->findByFileId($fileId);
  3110.         foreach ($simplyBen as $item){ $benefitEuro = $benefitEuro - $item->getBenefitSupplier(); }
  3112.         if (!($totalSale == 0)){
  3113.             $benefitPerc = ($benefitEuro * 100)/$totalSale;
  3114.         }
  3116.         $data = array(
  3117.             'id' => $fileId,
  3118.             'benefitEuro' => $benefitEuro,
  3119.             'benefitPerc' => $benefitPerc,
  3120.         );
  3122.         return $data;
  3124.     }
  3126.     private function precioPorVariacionDeDias ($supplierService, $productFile){
  3127.         // El precio unitario debe ser dividido en funcion de los dias que tiene InOut y no en funcion de los dias de Av Express
  3128.         $days = ($supplierService->getDateOutAt()->diff($supplierService->getDateInAt())->days)===0 ? 1 : $supplierService->getDateOutAt()->diff($supplierService->getDateInAt())->days +1;
  3129.         $newPrice = $productFile->getSubTotalPrice() / ( $days );
  3130.         $newPrice = $newPrice / $supplierService->getUnits();
  3131.         $newPrice = round($newPrice,2,PHP_ROUND_HALF_UP);
  3133.         return $newPrice;
  3134.     }
  3136.     private function rankquoteAvParaInOutService($idProduct){
  3137.         // con el ID del product buscamos en "ave_doc_invoice_items" con prdControl($idProduct) para determinar la factura, y buscamos elementos dentro de esa factura
  3138.         // luego si es vacio repetimos para proformas en "ave_doc_proforma_items"
  3139.         // Devuelve el numero de RankQuoteAv considerando la posible asociacion por sala y ordenando segun el criterio (video, sonido, iluminacion, otros)
  3140.         $em = $this->getDoctrine()->getManager();
  3141.         $rankquoteAv = 1; $proformaItemsInSameProforma = []; $boolFound = false;
  3142.         $invoiceItem = $em->getRepository(AveDocInvoiceItems::class)->findOneByPrdControlId($idProduct);
  3143.         $invoiceItemsInSameInvoice = (!empty($invoiceItem)) ? $em->getRepository(AveDocInvoiceItems::class)->findByInvoiceId($invoiceItem->getInvoiceId()) : array();
  3145.         if (empty($invoiceItemsInSameInvoice)){
  3146.             // No se encontraba facturado, buscamos en proforma el item y los elementos que esten en esa proforma
  3147.             $proformaItem = $em->getRepository(AveDocProformaItems::class)->findOneByControlId($idProduct);
  3148.             $proformaItemsInSameProforma = (!empty($proformaItem)) ? $em->getRepository(AveDocProformaItems::class)->findByProformaId($proformaItem->getProformaId()) : array();
  3149.         }
  3151.         $arrayItems = empty($invoiceItemsInSameInvoice) ? $proformaItemsInSameProforma : $invoiceItemsInSameInvoice;
  3152.         foreach ($arrayItems as $item){
  3153.             $idToCheck = empty($invoiceItemsInSameInvoice) ? $item->getControlId() : $item->getPrdControlId();
  3154.             if (!($idToCheck == $idProduct)){ if(!($boolFound)){ $rankquoteAv++;} } else { $boolFound = true; }
  3155.         }
  3157.         // 001, 002, ... 010, 011, ..., 100, 101
  3158.         $rankquoteAv = ($rankquoteAv < 100) ? (($rankquoteAv < 10) ? '00'. $rankquoteAv : '0'. $rankquoteAv) : $rankquoteAv;
  3160.         return $rankquoteAv;
  3161.     }
  3163.     private function messageOfChangesToAgent($message, $proposalId){
  3164.         // $message mensaje a enviar a los agentes del proposal
  3165.         if ($proposalId  == 0){ return true; }
  3166.         $em = $this->getDoctrine()->getManager();
  3167.         $proposal = $em->getRepository(Proposal::class)->findOneById($proposalId);
  3169.         /* Obtengo usuario logueado */
  3170.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  3171.         $user_id = $user_logueado->getId();
  3172.         $agent = $em->getRepository(User::class)->findOneById($user_id);
  3174.         $message = 'El proposal <strong>#'.$proposalId.' '.$proposal->getName().'</strong>'.' ha sido modificacdo por el agente: '.$agent->getName().' '.$agent->getLastName().'<br><br><br>'.$message;
  3175.         $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposalId);
  3176.         $mailArrayTo = [];
  3177.         if (!empty($agent)){ $mailArrayTo[$agent->getEmail()] = $agent->getEmail(); }
  3178.         if (!empty($proposalAgents)){
  3179.             if (!empty($proposalAgents->getAgOne())){
  3180.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgOne());
  3181.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  3182.             }
  3184.             if (!empty($proposalAgents->getAgTwo())){
  3185.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgTwo());
  3186.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  3187.             }
  3189.             if (!empty($proposalAgents->getAgThree())){
  3190.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgThree());
  3191.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  3192.             }
  3194.             if (!empty($proposalAgents->getAgFour())){
  3195.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgFour());
  3196.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  3197.             }
  3198.         }
  3200.         if (!empty($mailArrayTo)){
  3201.             $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  3202.             $replyTo = [];
  3203.             foreach ($mailArrayTo as $item){ $replyTo[$item] = $item; }
  3205.             $agentMail = $agent->getEmail();
  3207.             //Se prepara el correo con los agentes a notificar
  3208.             $firmGmail = $agent->getFirmGmail();
  3209.             $data = array(
  3210.                 'body' => $message,
  3211.                 'firm' => $firmGmail,
  3212.             );
  3214.             // EJECUTAR ENVIO DE ALERTA PARA EL AGENTE
  3215.             $transporter = new Swift_SmtpTransport();
  3216.                 $transporter->setHost('smtp.gmail.com')
  3217.                 ->setEncryption('ssl')//ssl / tls
  3218.                 ->setPort(465)// 465 / 587
  3219.                 ->setUsername('desarrollo@develup.solutions')
  3220.                 ->setPassword('utvh hzoi wfdo ztjs');
  3221.             $mailer = new Swift_Mailer($transporter);
  3223.             $message = new Swift_Message();
  3224.                 $message->setSubject('Actualización de servicios AvExpress del proposal: '. $proposalId)
  3225.                 ->setSender($agentMail)
  3226.                 ->setFrom(array("desarrollo@develup.solutions" => "System Mante 3.0"))
  3227.                 ->setReplyTo($agentMail)
  3228.                 ->setTo($replyTo)
  3229.                 ->setBody(
  3230.                     $this->renderView(
  3231.                         'mail/structure-mail.html.twig',
  3232.                         array('data' => $data)
  3233.                     ),
  3234.                     'text/html'
  3235.                 );
  3236.             $mailer->send($message);
  3237.         }
  3239.         return true;
  3240.     }
  3244. };