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

Open in your IDE?
  1. <?php
  3. namespace App\MDS\AvexpressBundle\Controller;
  5. use App\Entity\Cities;
  6. use App\Entity\Client;
  7. use App\Entity\Configuration;
  8. use App\Entity\Country;
  9. use App\Entity\Destination;
  10. use App\Entity\Regions;
  11. use App\Entity\SettingsCompany;
  12. use App\Entity\User;
  13. use App\Entity\HtFile;
  14. use App\MDS\AvexpressBundle\Entity\AveBenefitsSupplier;
  15. use App\MDS\AvexpressBundle\Entity\AveBriefings;
  16. use App\MDS\AvexpressBundle\Entity\AveBudgetPending;
  17. use App\MDS\GreenPatioBundle\Entity\Reservation;
  18. use Symfony\Component\Routing\Annotation\Route;
  19. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  20. use Symfony\Component\HttpFoundation\Request;
  21. use DateTime;
  22. use App\MDS\AvexpressBundle\Entity\AveFiles;
  23. use App\MDS\AvexpressBundle\Entity\AveBudgetToProforma;
  24. use App\MDS\AvexpressBundle\Entity\AveDocInvoice;
  25. use App\MDS\AvexpressBundle\Entity\AveDocInvoiceItems;
  26. use App\MDS\AvexpressBundle\Entity\AveDocInvoiceRec;
  27. use App\MDS\AvexpressBundle\Entity\AveDocInvoiceRecItems;
  28. use App\MDS\AvexpressBundle\Entity\AveDocProforma;
  29. use App\MDS\AvexpressBundle\Entity\AveDocProformaItems;
  30. use App\MDS\AvexpressBundle\Entity\AvePaymentsClient;
  31. use App\MDS\AvexpressBundle\Entity\AveProduct;
  32. use App\MDS\AvexpressBundle\Entity\AveProductFile;
  33. use App\MDS\AvexpressBundle\Entity\AveServices;
  34. use App\MDS\DevelupBundle\Entity\MdvTelegramUser;
  35. use App\MDS\EventsBundle\Entity\Proposal;
  36. use App\MDS\EventsBundle\Entity\ProposalAgents;
  37. use App\MDS\EventsBundle\Entity\ProposalInvoice;
  38. use App\MDS\EventsBundle\Entity\ProposalSupplierControl;
  39. use App\MDS\EventsBundle\Entity\ProposalSupplierServices;
  40. use Swift_Mailer;
  41. use Swift_Message;
  42. use Swift_SmtpTransport;
  43. use Symfony\Contracts\Translation\TranslatorInterface;
  45. class FilesController extends AbstractController
  46. {
  47.     private $translator;
  49.     public function __construct(TranslatorInterface $translator) {
  50.         $this->translator = $translator;
  51.     }
  52.     
  53.     /**
  54.      * @Route("/fileadd/",  name="ave_add_file")
  55.      * Agregar un expediente
  56.      */
  57.     public function addFileAction( Request $request)
  58.     {
  59.         $em = $this->getDoctrine()->getManager();
  60.         $clients = $em->getRepository(Client::class)->findAll();
  61.         $destinations = $em->getRepository(Destination::class)->findAll();
  62.         $aveFiles = $em->getRepository(AveFiles::class)->findAll();
  63.         $id =0;
  64.         if (empty($aveFiles)){
  65.             $id ++;
  66.         } else {
  67.             $lastElem = end($aveFiles);
  68.             $id = $lastElem->getId() + 1;
  70.         }
  72.         return $this->render('MDS/AvexpressBundle/Avexpress/add-files.html.twig',
  73.             array(
  74.                 'id' => $id,
  75.                 'clients' => $clients,
  76.                 'destinations' => $destinations,
  77.                 'clientId' => 0,
  78.             ));
  79.     }
  81.     /**
  82.      * @Route("/filelist/",  name="ave_list_file")
  83.      * Listar expedientes
  84.      */
  85.     public function listFileAction( Request $request)
  86.     {
  87.         $em = $this->getDoctrine()->getManager();
  88.         $idgroup = null;
  89.         $parameters = array( 'status' => 'Deleted' );
  91.         $dql = 'SELECT i
  92.                 FROM AvexpressBundle:AveFiles i
  93.                 WHERE i.status != :status
  94.                 ORDER BY i.dateStart DESC ';
  95.         $query = $em->createQuery($dql)->setParameters($parameters);
  96.         $ref = array();
  98.         $reservas = $query->getResult();
  100.         foreach ($reservas as $res) {
  101.             $client = $em->getRepository(Client::class)->findOneById($res->getClient());
  102.             if (!empty($client)) { $res->setClient($client->getName()); } else { $res->setClient(null); }
  104.             if (!empty($res->getDateStart()) and !empty($res->getDateEnd())) {
  105.                 $ref[$res->getId()] = '#' . ($res->getDateStart())->format('ymd') . ($res->getDateEnd())->format('ymd');
  106.             } else {
  107.                 $ref[$res->getId()] = '#' . '000000' . '000000';
  108.             }
  109.         }
  111.         $reservasZero = array();
  112.         foreach ($reservas as $res) {
  113.             $reservasZero[] = array(
  114.                 'dateStart' => $res->getDateStart(),
  115.                 'dateEnd' => $res->getDateEnd(),
  116.                 'id' => $res->getId(),
  117.                 'title' => $res->getTitle(),
  118.                 'client' => $res->getClient(),
  119.                 'createdId' => $res->getCreatedId(),
  120.                 'ref' => $ref[$res->getId()],
  121.                 'reservation' => $res->getReservation(),
  122.             );
  123.         }
  124.         $reservas = $reservasZero;
  126.         return $this->render('MDS/AvexpressBundle/Avexpress/list-files.html.twig',
  127.             array(
  128.                 'groups' => null,
  129.                 'listofdeletedfiles' => false,
  130.                 'reservations' => $reservas
  131.             )
  132.         );
  133.     }
  135.     /**
  136.      * @Route("/filesave/",  name="ave_save_file")
  137.      * Guardar un expediente nuevo
  138.      */
  139.     public function saveFileAction( Request $request)
  140.     {
  141.         $em = $this->getDoctrine()->getManager();
  142.         $newRequest = $request->request->get('avexpress');
  143.         if (empty($newRequest['title'])){ return $this->redirectToRoute('ave_add_file'); }
  145.         /* Obtengo usuario logueado */
  146.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  147.         $user_id = $user_logueado->getId();
  149.         $newFile = new AveFiles();
  150.         $newFile->setTitle($newRequest['title']);
  151.         $newFile->setClient($newRequest['client']);
  152.         if (!empty($newRequest['idProposal'])){
  153.             $newFile->setIdProposal($newRequest['idProposal']);
  154.         } else {
  155.             $newFile->setIdProposal(null);
  156.         }
  157.         $newFile->setStatus($newRequest['status']);
  158.         $newFile->setAdvancePayment($newRequest['advancePayment']);
  159.         $newFile->setDescription($newRequest['description']);
  160.         if (empty($newRequest['dateStart'])){
  161.             $newFile->setDateStart(new \DateTime("now"));
  162.         } else {
  163.             $newFile->setDateStart(new \DateTime($newRequest['dateStart']));}
  164.         if (empty($newRequest['dateEnd'])){
  165.             $newFile->setDateEnd(new \DateTime("now"));
  166.         } else {
  167.             $newFile->setDateEnd(new \DateTime($newRequest['dateEnd']));}
  169.         if (!empty($newRequest['destination'])){
  170.             $newFile->setDestinoId($newRequest['destination']);
  171.         }
  173.         $newFile->setCreatedId($user_id);
  174.         $newFile->setUpdatedId($user_id);
  175.         $newFile->setCreatedAt(new \DateTime("now"));
  176.         $newFile->setUpdatedAt(new \DateTime("now"));
  178.         $em->persist($newFile);
  179.         $em->flush();
  181.         $clients = $em->getRepository(Client::class)->findAll();
  182.         $products = $em->getRepository(AveProduct::class)->findAll();
  184.         $data = $this->calculosFile($newFile->getId(), null, 0, 'File');
  186.         $sumatoriaTotalNet = 0;
  187.         $sumatoriaTotalVat = 0;
  188.         $sumatoriaTotal = 0;
  190.         $resultados = array(
  191.             'totalNeto' => $sumatoriaTotalNet,
  192.             'vat' => $sumatoriaTotalVat,
  193.             'total' => $sumatoriaTotal,
  195.         );
  197.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($newFile->getId());
  198.         $numeroItems = sizeof($productInFile);
  200.         return $this->redirectToRoute('ave_edit_file', array( 'id' => $newFile->getId() ));
  201.     }
  203.     /**
  204.      * @Route("/fileupdate/{id}",  name="ave_update_file")
  205.      * Actualizar un expediente
  206.      */
  207.     public function updateFileAction($id, Request $request)
  208.     {
  209.         $logTelegram = false;
  210.         $numberToPrefix = 0;
  211.         $em = $this->getDoctrine()->getManager();
  212.         $newFile = $em->getRepository(AveFiles::class)->findOneById($id);
  213.         $newRequest = $request->request->get('avexpress');
  214.         $srvInconsistentes = '';                    // Mensaje de alerta por inconsistencia en los servicios
  216.         // INICIO: Si existe un documento creado no se puede cambiar el cliente
  217.         $oldDoc = $em->getRepository(AveDocInvoice::class)->findOneByFileId($id);
  218.         $noexistefactura = empty($oldDoc);
  219.         // FIN: Si existe un documento creado no se puede cambiar el cliente
  221.         /* Obtengo usuario logueado */
  222.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  223.         $user_id = $user_logueado->getId();
  225.         if (!empty($newRequest['title'])){$newFile->setTitle($newRequest['title']);}
  226.         if ($noexistefactura)
  227.             {
  228.                 $newFile->setClient($newRequest['client']);
  229.                 $msjErrorClt = '';
  230.             }
  231.         else
  232.             { /* Hay una factura, no se debe cambiar el cliente */
  233.                 // Verificamos si intenta cambiar el cliente para informar que no es posible hacerlo
  234.                 if (!($newFile->getClient() == $newRequest['client'])){
  235.                     $msjErrorClt = 'El cliente no puede ser modificado, ya existe una factura previa';
  236.                 } else {
  237.                     $msjErrorClt = '';
  238.                 }
  239.             }
  241.         if (!empty($newRequest['idProposal'])){$newFile->setIdProposal($newRequest['idProposal']);} else {$newFile->setIdProposal(null);}
  243.         $newFile->setStatus($newRequest['status']);
  244.         $newFile->setDescription($newRequest['description']);
  245.         $newFile->setUpdatedId($user_id);
  246.         $newFile->setUpdatedAt(new \DateTime("now"));
  248.         if (!empty($newRequest['destination'])){$newFile->setDestinoId($newRequest['destination']);}
  249.         if (!empty($newRequest['dateStart'])){$newFile->setDateStart(new DateTime($newRequest['dateStart']));}
  250.         if (!empty($newRequest['dateEnd'])){$newFile->setDateEnd(new DateTime($newRequest['dateEnd']));}
  251.         if (!empty($newRequest['xtraFieldOne'])){$newFile->setXtraFieldOne($newRequest['xtraFieldOne']);}
  253.         try{
  254.             $em->persist($newFile);
  255.             $em->flush();
  256.             $event = 'El expediente ha sido actualizado. ';
  258.             if (!empty($msjErrorClt)){ $event = $event.$msjErrorClt; }
  260.             $successMessage = $this->translator->trans($event);
  261.             $this->addFlash('mensajeav', $successMessage);
  263.         } catch (\Exception $e){
  265.             $event = 'An error occurred: '.$e->getMessage();
  267.             /* Para el usuario */
  268.             $errorMessage = $this->translator->trans($event);
  269.             $this->addFlash('mensajeaverror', $errorMessage);
  270.         }
  272.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($newFile->getId());
  273.         $txtWarning = '';
  274.         if(!empty($newFile->getIdProposal())){
  275.             // El expediente se ha relacionado con un proposal, se debe actualizar en eventos
  276.             $file = $newFile;
  277.             // Si hay proposal se debe actualizar en el expediente de Eventos
  278.             if (!empty($file->getIdProposal()) and is_numeric($file->getIdProposal())){
  279.                 // Buscamos el destino donde se encuentre Avexpress y ahi agregamos el servicio, si no se encuentra no se agregara el servicio
  280.                 $control = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  281.                     array(
  282.                         'supplierId' => 80,                                          // El supplier 80 es Avexpress
  283.                         'proposalId' => $file->getIdProposal(),
  284.                     )
  285.                 );
  286.                 // INICIO: Buscamos la info del lado de eventos (SINCRONIZACION)
  287.                 $txtOfChanges = ''; //Mensaje para el agente de cambios en los servicios hechos desde AvExpress
  288.                 $proposal = $em->getRepository(Proposal::class)->findOneById($file->getIdProposal());
  289.                 $agent = $em->getRepository(User::class)->findOneById($proposal->getAgentId());
  290.                 $agentFullName = $agent->getName().' '.$agent->getLastName();
  291.                 $proposalTitle = $proposal->getId().' - '.$proposal->getTitle();
  292.                 // FIN: Buscamos la info del lado de eventos
  294.                 foreach ($productInFile as $item){
  295.                     //Si las fechas de inicio y fin no coinciden con el campo dias se debe enviar alerta
  296.                     $txtWarning = ($item->getDateOutAt()->diff($item->getDateInAt()))->days + 1 <> $item->getDays() ? '<br>'.$item->getProductName() : '';
  297.                     if (!empty($txtWarning)){
  298.                         if (empty($srvInconsistentes)){ $srvInconsistentes = 'Hay inconsistencias en: '.'<br>'.$txtWarning; } else { $srvInconsistentes = $srvInconsistentes.'<br>'.$txtWarning; }
  299.                     }
  301.                     if (!empty($control)){
  302.                         // Existe un destino con AvExpress como proveedor, ahí se agregara el servicio
  304.                         $yaexistiaunservicio = false; $proposalServicex = null;
  305.                         // Se verifica que no el productfile Av no tenga imagen en Eventos
  306.                         if (!empty($item->getOriginId())){
  307.                             // Se verifica que aun exista en Eventos  el servicio
  308.                             $proposalServicex = $em->getRepository(ProposalSupplierServices::class)->findOneById($item->getOriginId());
  309.                             if (!empty($proposalServicex)){ $yaexistiaunservicio = true; } else { $yaexistiaunservicio = false; }
  311.                         } else {
  312.                             // no estaba relacionado con nada en eventos, se crea uno nuevo
  313.                             $yaexistiaunservicio = false;
  314.                         }
  316.                         if ($yaexistiaunservicio){
  317.                             $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($file->getIdProposal());
  318.                             if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  319.                                 $service = $proposalServicex;
  320.                                 $oldServiceEvent = array(
  321.                                     'activityId' => $service->getActivityId(),
  322.                                     'assistantId' => $service->getAssistantId(),
  323.                                     'breakdown' => $service->getBreakdown(),
  324.                                     'commission' => $service->getCommission(),
  325.                                     'controlId' => $service->getControlId(),
  326.                                     'currency' => $service->getCurrency(),
  327.                                     'dateBlockLimit' => $service->getDateBlockLimit(),
  328.                                     'dateInAt' => $service->getDateInAt(),
  329.                                     'dateOutAt' => $service->getDateOutAt(),
  330.                                     'destinationId' => $service->getDestinationId(),
  331.                                     'directPayment' => $service->getDirectPayment(),
  332.                                     'hour' => $service->getHour(),
  333.                                     'ideaId' => $service->getIdeaId(),
  334.                                     'isFather' => $service->getIsFather(),
  335.                                     'iva' => $service->getIva(),
  336.                                     'name' => $service->getName(),
  337.                                     'opCommission' => $service->getOpCommission(),
  338.                                     'opIva' => $service->getOpIva(),
  339.                                     'opOver' => $service->getOpOver(),
  340.                                     'originalIva' => $service->getOriginalIva(),
  341.                                     'originalPrice' => $service->getOriginalPrice(),
  342.                                     'originalopIva' => $service->getOriginalopIva(),
  343.                                     'over' => $service->getOver(),
  344.                                     'pax' => $service->getPax(),
  345.                                     'preCommission' => $service->getPreCommission(),
  346.                                     'preIva' => $service->getPreIva(),
  347.                                     'price' => $service->getPrice(),
  348.                                     'proposalId' => $service->getProposalId(),
  349.                                     'rank' => $service->getRank(),
  350.                                     'serviceCatId' => $service->getServiceCatId(),
  351.                                     'serviceCatName' => $service->getServiceCatName(),
  352.                                     'serviceId' => $service->getServiceId(),
  353.                                     'serviceIdFather' => $service->getServiceIdFather(),
  354.                                     'status' => $service->getStatus(),
  355.                                     'statusRec' => $service->getStatusRec(),
  356.                                     'statusinternal' => $service->getStatusinternal(),
  357.                                     'supplierId' => $service->getSupplierId(),
  358.                                     'units' => $service->getUnits(),
  359.                                 );
  360.                                 $service->setName($item->getProductName());
  362.                                 // Se verifican los precios en ambas partes (AV Express e InOut)
  363.                                 if (!($service->getPrice() == $item->getServicePrice())) {
  364.                                     // Si ambos precios unitarios son distintos se ha modificado el numero de días en Av Express
  365.                                     $newPriceInOut = $this->precioPorVariacionDeDias($service, $item);
  366.                                     $service->setPrice($newPriceInOut);
  367.                                 } else {
  368.                                     // si son iguales tambien se deben verificar el numero de dias
  369.                                     if (!(($service->getDateOutAt()->diff($service->getDateInAt())->days + 1) == $item->getDays())) {
  370.                                         $newPriceInOut = $this->precioPorVariacionDeDias($service, $item);
  371.                                         $service->setPrice($newPriceInOut);
  372.                                     }
  373.                                 }
  375.                                 $service->setCurrency($item->getCurrency());
  376.                                 $service->setUnits($item->getUnits());
  377. //                            $service->setCommission(0);                                       // InOut puede haber metido una Comision y no se le debe modificar
  378. //                            $service->setOver(0);                                             // InOut puede haber metido un Over y no se le debe modificar
  379.                                 $service->setIva(21);
  380.                                 if (empty($item->getPax())) {
  381.                                     $service->setPax(1);
  382.                                 } else {
  383.                                     $service->setPax($item->getPax());
  384.                                 }
  385.                                 $service->setHour(null);
  386.                                 $service->setDateInAt($item->getDateInAt());
  387.                                 $service->setDateOutAt($item->getDateOutAt());
  388.                                 $service->setDirectPayment(0);
  389. //                            $service->setStatus('Pending');                                   // InOut puede haber Confirmado y no se le debe modificar
  390.                                 $service->setStatusinternal('Additional');
  391.                                 $service->setPreCommission(null);
  392.                                 $service->setPreIva(null);
  393.                                 $service->setDateBlockLimit(null);
  394. //                            $service->setOpCommission(1);                                     // InOut puede haber metido una Op Comision y no se le debe modificar
  395. //                            $service->setOpOver(1);                                           // InOut puede haber metido una Op Over y no se le debe modificar
  396. //                            $service->setOpIva(1);                                            // InOut puede haber metido una Op Iva y no se le debe modificar
  397.                                 $service->setBreakdown(0);
  398.                                 $service->setIsFather(0);
  399.                                 $service->setRank($this->rankAvParaInOutService($item->getId()));
  400.                                 $service->setOriginalopIva(1);
  401.                                 $service->setStatusRec('normal');
  402.                                 $service->setCreatedId($user_id);
  403.                                 $service->setUpdatedId($user_id);
  405.                                 $em->persist($service);
  406.                                 $em->flush();
  408.                                 // Se debe notificar por Telegram al agente de eventos
  409.                                 $logTelegram = true;
  411.                                 //Verificamos cambios e informamos al agente del proposal
  412.                                 $boolChanges = false;
  413.                                 if (!($service->getRank() == $oldServiceEvent['rank'])){ 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['rank'].', su nuevo valor es: '.$service->getRank().'<br>'; $boolChanges = true; }
  414.                                 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; }
  415.                                 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; }
  416.                                 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; }
  417.                                 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; }
  418.                                 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; }
  419.                                 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; }
  420.                                 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; }
  421.                                 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; }
  422.                                 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; }
  423.                                 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; }
  424.                                 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; }
  425.                                 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; }
  426.                                 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; }
  427.                                 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; }
  428.                                 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; }
  429.                             } else {
  430.                                 $srvAlreadyInvoiced = 'Error al sincronizar. <br><br> InOut ya ha facturado.';
  431.                                 $this->addFlash('mensajeaverror', $srvAlreadyInvoiced);
  432.                             }
  434.                         } else{
  436.                             $prpInv = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($file->getIdProposal());
  437.                             if (empty($prpInv)) { //Si hay factura en InOut no se debe modificar
  438.                                 $service = new ProposalSupplierServices();
  439.                                 $service->setServiceIdFather(0);
  440.                                 $service->setControlId($control->getId());
  441.                                 $service->setProposalId($file->getIdProposal());
  442.                                 $service->setDestinationId($control->getDestinoId());
  443.                                 $service->setSupplierId(80);                                    // 80 es AvExpress
  444.                                 $service->setIdeaId(null);
  445.                                 $service->setServiceId($item->getProductId());
  446.                                 $service->setServiceCatName('Av');
  447.                                 $service->setServiceCatId(3);
  448.                                 $service->setName($item->getProductName());
  449.                                 $priceInOut = $item->getSubTotalPrice();
  450.                                 if (!($item->getPax() == 0)) {
  451.                                     $priceInOut = $priceInOut / $item->getPax();                    // Se devuelve el calculo dividiendo entre personas
  452.                                 }
  453.                                 if (!($item->getUnits() == 0)) {
  454.                                     $priceInOut = $priceInOut / $item->getUnits();                  // Se devuelve el calculo dividiendo entre cantidades
  455.                                 }
  456.                                 if (!($item->getDays() == 0)) {
  457.                                     $priceInOut = $priceInOut / round($item->getDays());            // Se devuelve el calculo dividiendo entre dias, se redondea por si es 1.5
  458.                                 }
  459.                                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  460.                                 $priceInOut = round($priceInOut, 2, PHP_ROUND_HALF_UP);
  462.                                 $service->setPrice($priceInOut);
  463.                                 $service->setCurrency($item->getCurrency());
  464.                                 $service->setUnits($item->getUnits());
  465.                                 $service->setCommission(0);
  466.                                 $service->setOver(0);
  467.                                 $service->setIva(21);
  468.                                 if (empty($item->getPax())) { $service->setPax(1); } else { $service->setPax($item->getPax()); }
  469.                                 $service->setHour(null);
  470.                                 $service->setDateInAt($item->getDateInAt());
  471.                                 $service->setDateOutAt($item->getDateOutAt());
  472.                                 $service->setDirectPayment(0);
  473.                                 $service->setStatus('Pending');
  474.                                 $service->setStatusinternal('Additional');
  475.                                 $service->setPreCommission(null);
  476.                                 $service->setPreIva(null);
  477.                                 $service->setDateBlockLimit(null);
  478.                                 $service->setOpCommission(1);
  479.                                 $service->setOpOver(1);
  480.                                 $service->setOpIva(1);
  481.                                 $service->setBreakdown(0);
  482.                                 $service->setIsFather(0);
  483.                                 $service->setRank($this->rankAvParaInOutService($item->getId()));
  484.                                 $service->setOriginalopIva(1);
  485.                                 $service->setOriginalIva(null);
  486.                                 $service->setOriginalPrice(null);
  487.                                 $service->setStatusRec('normal');
  488.                                 $service->setAssistantId(null);
  489.                                 $service->setCreatedId($user_id);
  490.                                 $service->setUpdatedId($user_id);
  491.                                 $service->setCreatedAt(new \DateTime("now"));
  492.                                 $service->setUpdatedAt(new \DateTime("now"));
  494.                                 $em->persist($service);
  495.                                 $em->flush();
  497.                                 // Se relaciona el nuevo Servicio InOut con el Servicio AV
  498.                                 $item->setOriginId($service->getId());
  499.                                 $em->persist($item);
  500.                                 $em->flush();
  502.                                 // Se debe notificar por Telegram al agente de eventos
  503.                                 $logTelegram = true;
  504.                             } else {
  505.                                 $srvAlreadyInvoiced = 'Error al sincronizar. <br><br> InOut ya ha facturado.';
  506.                                 $this->addFlash('mensajeaverror', $srvAlreadyInvoiced);
  507.                             }
  508.                         }
  509.                     }
  511.                     // Notificamos al agente de InOut si se hicieron actualizaciones en los servicios desde AvExpress
  512.                     if (!empty($txtOfChanges)) { $this->messageOfChangesToAgent($txtOfChanges, $proposal->getId()); }
  514.                     //INICIO: Creamos una orden de hacer proforma
  516.                     //INICIO: Calculamos el ID de la proforma
  517.                     $numberToPrefix = $em->getRepository(AveDocProforma::class)->findAll();
  518.                     if (empty($numberToPrefix)){
  519.                         $numberToPrefix = 0;
  520.                     } else {
  521.                         $numberToPrefix = end($numberToPrefix)->getId();
  522.                     }
  523.                     $numberToPrefix++;
  524.                     //FIN: Calculamos el ID de la proforma
  526.                     $order = new AveBudgetToProforma();
  527.                     $order->setStatus('Pending');
  528.                     $order->setFileId($file->getId());
  529.                     $order->setProductFileId($item->getId());
  530.                     $order->setUserConfirmedId($proposal->getAgentId());
  531.                     $order->setUserConfirmedFullName($agentFullName);
  532.                     $order->setProposalTitle($proposalTitle);
  533.                     $order->setProformaId($numberToPrefix);
  535.                     $em->persist($order);
  536.                     $em->flush();
  537.                     //FIN: Creamos una orden de hacer proforma
  538.                 }
  540.                 $event = 'Expediente guardado correctamente.';
  541.                 $successMessage = $this->translator->trans($event);
  542.                 $this->addFlash('mensajeav', $successMessage);
  544.                 if (!empty($srvInconsistentes) and !empty($newFile->getIdProposal())){ $this->addFlash('mensajeaverror', $srvInconsistentes); }
  546.                 //INICIO: Notificamos al agente por Telegram
  547.                 if ($logTelegram){
  548.                     //Buscamos todos los agentes del proposal
  549.                     $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposal->getId());
  551.                     //Buscamos el Destino
  552.                     $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  554.                     //Buscamos el agente de Avexpress
  555.                     $userData = $em->getRepository(User::class)->findOneById($user_id);
  557.                     if (!empty($proposalAgents) and !($user_id == 22)){
  558.                         if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  559.                             $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  560.                         }
  561.                         if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  562.                             $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  563.                         }
  564.                         if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  565.                             $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  566.                         }
  567.                         if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  568.                             $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE AVEXPRESS __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: AvExpress __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  569.                         }
  570.                     }
  571.                 }
  572.                 //FIN: Notificamos al agente por Telegram
  574.                 //INICIO: Creamos el presupuesto (proforma)
  576.                 $budToPro = $em->getRepository(AveBudgetToProforma::class)->findByProformaId($numberToPrefix);
  578.                 //INICIO: Se agrupan por expediente (fileId)
  579.                 $proformas = array();
  580.                 foreach ($budToPro as $item){
  581.                     $proformas[$item->getFileId()][] = $item;
  582.                 }
  583.                 //FIN: Se agrupan por expediente (fileId)
  585.                 if (!empty($budToPro)){
  586.                     foreach ($proformas as $key => $elemento){
  587.                         //INICIO: Creamos las proformas
  589.                         $newProforma = new AveDocProforma();
  590.                         $newProforma->setPrefix('AVE-' . (new DateTime('now'))->format('dmy') . '-' . $numberToPrefix . '-' . $key);
  591.                         $newProforma->setDateAt(new DateTime('now'));
  592.                         $newProforma->setFileId($key);
  593.                         $newProforma->setCreatedId($user_id);
  594.                         $newProforma->setUpdatedId($user_id);
  595.                         $newProforma->setCreatedAt(new DateTime('now'));
  596.                         $newProforma->setUpdatedAt(new DateTime('now'));
  598. //                        $em->persist($newProforma);
  599.                         $em->flush();
  600.                         //FIN: Creamos las proformas
  602.                         foreach ($elemento as $item) {
  603.                             //$key es el id del expediente
  604.                             // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  606.                             //INICIO: Creamos los elemento que iran dentro de las proformas
  607.                             $itemProforma = new AveDocProformaItems();
  608.                             $itemProforma->setType('PRODUCT');
  609.                             $itemProforma->setFileId($key);
  610.                             $itemProforma->setProformaId($newProforma->getId());
  611.                             $itemProforma->setControlId($item->getProductFileId());
  613. //                            $em->persist($itemProforma);
  614.                             $em->flush();
  616.                             //INICIO: Confirmamos el BudToProforma
  617. //                            $item->setStatus('Tosend');              // El elemento se ha pasado a la proforma, solo falta enviar
  618.                             $item->setProformaId($newProforma->getId());
  620. //                            $em->persist($item);
  621.                             $em->flush();
  622.                             //FIN: Confirmamos el BudToProforma
  624.                             //FIN: Creamos los elemento que iran dentro de las proformas
  625.                         }
  626.                     }
  627.                 }
  628.                 //FIN: Creamos el presupuesto (proforma)
  631.                 // INICIO: Se envia al agente el presupuesto
  632.                 $budToPro = $em->getRepository(AveBudgetToProforma::class)->findByStatus('Tosend');
  634.                 /* Obtengo usuario logueado */
  635.                 $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  636.                 $user_id = $user_logueado->getId();
  638.                 $arrayIdPro = array();          // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  640.                 //INICIO: Se agrupan por expediente (fileId)
  641.                 $proformas = array();
  642.                 foreach ($budToPro as $item){
  643.                     $proformas[$item->getFileId()][] = $item;
  644.                 }
  645.                 //FIN: Se agrupan por expediente (fileId)
  647.                 if (!empty($budToPro)){
  648.                     foreach ($proformas as $key => $elemento){
  649.                         //INICIO: Creamos las proformas
  651.                         foreach ($elemento as $item) {
  652.                             //$key es el id del expediente
  654.                             if (!empty($item->getProformaId())) {
  655.                                 $arrayIdPro[$item->getProformaId()] = $item->getUserConfirmedId();             // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  656.                             }
  658.                             //INICIO: Confirmamos el BudToProforma
  659.                             $item->setStatus('Confirmed');              // El elemento se ha pasado a confirmado porque se enviara por correo
  661.                             $em->persist($item);
  662.                             $em->flush();
  663.                             //FIN: Confirmamos el BudToProforma
  665.                             //FIN: Creamos los elemento que iran dentro de las proformas
  666.                         }
  667.                     }
  668.                 }
  670.                 //INICIO: Notificamos de todos los presupuestos (proformas) que se han creado
  671.                 foreach ($arrayIdPro as $key => $item){
  672.                     //Buscamos la info del proposal
  673.                     $xprof = $em->getRepository(AveDocProforma::class)->findOneById($key);
  674.                     if (!empty($xprof)){
  675.                         $xfile = $em->getRepository(AveFiles::class)->findOneById($xprof->getFileId());
  676.                         $xprop = $em->getRepository(Proposal::class)->findOneById($xfile->getIdProposal());
  677.                         $xcli = $em->getRepository(Client::class)->findOneById($xprop->getClientId());
  678.                         $xbody = 'Proposal #'.$xprop->getId().' - '.$xprop->getName().
  679.                             '<br><a href="http://' . $request->server->get('HTTP_HOST') . '/events/proposal/edit/' . $xprop->getId() . '">Ver el Proposal</a>'.
  680.                             '<br>Cliente: '.$xcli->getName().
  681.                             '<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.' .
  682.                             '<br>Si el enlace al presupuesto no funciona correctamente, se debe a que desde AV lo han modificado o descartado.'.
  683.                             '<br><br>';
  684.                     } else {
  685.                         $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>';
  686.                     }
  688.                     //Buscamos los agentes a notificar
  689.                     // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  690.                     $agent = $em->getRepository(User::class)->findOneById($item);
  691.                     $agentMail = $agent->getEmail();
  693.                     $mailAgent = $agentMail;
  695.                     //Se prepara el correo con los agentes a notificar
  696.                     $firmGmail = $agent->getFirmGmail();
  697.                     $data = array(
  698.                         'body' => $xbody,
  699.                         'firm' => $firmGmail,
  700.                     );
  702.                     // EJECUTAR ENVIO DE ALERTA PARA EL AGENTE
  703.                     $transporter = new Swift_SmtpTransport();
  704.                         $transporter->setHost('smtp.gmail.com')
  705.                         ->setEncryption('ssl')//ssl / tls
  706.                         ->setPort(465)// 465 / 587
  707.                         ->setUsername('desarrollo@develup.solutions')
  708.                         ->setPassword('utvh hzoi wfdo ztjs');
  709.                     $mailer = new Swift_Mailer($transporter);
  711.                     $message = new Swift_Message();
  712.                         $message->setSubject('Presupuesto #' . $key . ', Notificación de nuevo presupuesto')
  713.                         ->setSender($agentMail)
  714.                         ->setFrom(array("desarrollo@develup.solutions" => "System Mante 3.0"))
  715.                         ->setReplyTo($agentMail)
  716.                         ->setTo($mailAgent)
  717.                         ->setBody(
  718.                             $this->renderView(
  719.                                 'mail/structure-mail.html.twig',
  720.                                 array('data' => $data)
  721.                             ),
  722.                             'text/html'
  723.                         );
  724.                     $mailer->send($message);
  725.                 }
  726.                 //FIN: Notificamos de todos los presupuestos (proformas) que se han creado
  727.                 // FIN: Se envia al agente el presupuesto
  728.             }
  729.         }
  731.         if(!empty($msjErrorClt)){
  732.             $errorMessage = $this->translator->trans('Error, el cliente no puede ser modificado, ya existe una factura previa');
  733.             $this->addFlash('mensajeaverror', $errorMessage);
  734.             return $this->redirectToRoute('ave_edit_file', array('id' => $newFile->getId()));
  735.         }
  737.         return $this->redirectToRoute('ave_edit_file', array('id' => $newFile->getId()));
  738.     }
  740.     /**
  741.      * @Route("/fileedit/{id}",  name="ave_edit_file")
  742.      * Editar un expediente
  743.      */
  744.     public function editFileAction( $id, Request $request)
  745.     {
  746.         $em = $this->getDoctrine()->getManager();
  747.         $editFile = $em->getRepository(AveFiles::class)->findOneById($id);
  749.         $clients = $em->getRepository(Client::class)->findAll();
  750.         $clientSelected = $em->getRepository(Client::class)->findOneById($editFile->getClient());
  751.         $products = $em->getRepository(AveProduct::class)->findAll();
  752.         $destinations = $em->getRepository(Destination::class)->findAll();
  754.         /* Obtengo usuario logueado */
  755.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  757.         $data = $this->calculosFile($id, null, 0, 'File');
  759.         $sumatoriaTotalNet = 0;
  760.         $sumatoriaTotalVat = 0;
  761.         $sumatoriaTotal = 0;
  763.         $resultados = array(
  764.             'totalNeto' => $sumatoriaTotalNet,
  765.             'vat' => $sumatoriaTotalVat,
  766.             'total' => $sumatoriaTotal,
  768.         );
  770.         $productInFile = $em->getRepository(AveProductFile::class)->findByFileId($id);
  771.         $numeroItems = sizeof($productInFile);
  773.         $facturas = $em->getRepository(AveDocInvoice::class)->findByFileId($id);
  774.         $facturasRec = $em->getRepository(AveDocInvoiceRec::class)->findByFileId($id);
  776.         foreach ($facturasRec as $item){ array_push($facturas,$item); }
  778.         $proformas = array();
  779.         $allProformas = $em->getRepository(AveDocProforma::class)->findByFileId($id);
  781.         foreach ($allProformas as $item) {
  782.             $dataTwo = $this->baseInvoiceDoneFileTwo($id, $item->getId(), 'P');
  783.             $bases = 0;
  785.             if (is_numeric($dataTwo['totales']) and is_numeric($dataTwo['totales_neto'])) {
  786.                 $bases = $dataTwo['totales'] - $dataTwo['totales_neto'];
  787.             }
  789.             $itemsInProforma = array();
  791.             if (array_key_exists('product', $dataTwo['datasupplier'])) {
  792.                 foreach ($dataTwo['datasupplier']['product'] as $elem) {
  793.                     $itemsInProforma[] = $em->getRepository(AveProductFile::class)->findOneById($elem['id']);
  794.                 }
  796.                 $proformas[] = array(
  797.                     'id' => $dataTwo['number'],
  798.                     'itemsInProforma' => $itemsInProforma,
  799.                     'date' => $dataTwo['date'],
  800.                     'neto' => $dataTwo['totales_neto'],
  801.                     'bases_imponibles' => $bases,
  802.                     'total' => $dataTwo['totales'],
  803.                 );
  804.             }
  805.         }
  806.         // Calculamos el beneficio
  807.         $dataThree = $this->baseBenefits($id);
  809.         // Buscamos los serviicos pendientes
  810.         $pendingBuds = $em->getRepository(AveBudgetPending::class)->findByProposalId($editFile->getIdProposal());
  812.         $pBuds = array();
  814.         // Creamos la agrupacion por proposal
  815.         foreach ($pendingBuds as $item){
  816.             if (!(array_key_exists($item->getProposalId(),$pBuds))){
  817.                 if (!empty($item->getOriginId())){    // Los vacios solo contienen briefings
  818.                     $pBuds[$item->getProposalId()] = null;
  819.                 }
  820.             }
  821.         }
  823.         // Metemos los items en el arreglo clasificado por proposal
  824.         foreach ($pendingBuds as $item){
  825.             if (!empty($item->getOriginId())) {    // Los vacios solo contienen briefings
  826.                 $pBuds[$item->getProposalId()][] = $item;
  827.             }
  828.         }
  830.         ksort($pBuds);
  831.         $keysPbuds = array_keys($pBuds);
  833.         $gpFile = $em->getRepository(Reservation::class)->findOneById($editFile->getReservation());
  834.         $htFile = !(empty($gpFile)) ? (in_array($user_logueado->getUserrol(),[9,23,24,37,47,53]) ? $em->getRepository(HtFile::class)->findOneByReservation($gpFile) : null ) : null;
  835.         $gpFile = in_array($user_logueado->getUserrol(),[9,23,24,37,47,53]) ? $gpFile : null ;
  837.         return $this->render('MDS/AvexpressBundle/Avexpress/edit-files.html.twig',
  838.             array(
  839.                 'id' => $id,
  840.                 'clients' => $clients,
  841.                 'clientId' => $editFile->getClient(),
  842.                 'clientSelected' => $clientSelected,
  843.                 'file' => $editFile,
  844.                 'numeroItems' => $numeroItems,
  845.                 'arrayProductFile' => $data['datasupplier']['product'],
  846.                 'products' => $products,
  847.                 'services' => null,
  848.                 'facturas' => $facturas,
  849.                 'proformas' => $proformas,
  850.                 'paymentNotIvoiced' => null,
  851.                 'paymentsAll' => null,
  852.                 'resultados' => $resultados,
  853.                 'totales_global_con_iva' => $data['totales'], //$data['totales_global_con_iva'],
  854.                 'totales_global_iva' => $data['bases_imponibles']['ivaMontoVeintiUno'], //$data['totales_global_iva'],
  855.                 'totales_global_neto' => $data['totales_neto'], //$data['totales_global_neto'],
  856.                 'totales_global_servicios_con_iva' => 0, //$data['totales_global_servicios_con_iva'],
  857.                 'totales_global_servicios_neto' => 0, //$data['totales_global_servicios_neto'],
  858.                 'totales_global_servicios_iva' => 0, //$data['totales_global_servicios_iva'],
  859.                 'sumatoria_totales_global_con_iva' => 0, //$data['sumatoria_totales_global_con_iva'],
  860.                 'sumatoria_totales_global_neto' => 0, //$data['sumatoria_totales_global_neto'],
  861.                 'sumatoria_totales_global_iva' => 0, //$data['sumatoria_totales_global_iva'],
  862.                 'benefitEuro' => $dataThree['benefitEuro'],
  863.                 'benefitPerc' => $dataThree['benefitPerc'],
  864.                 'pendingBudgets' => $pBuds,
  865.                 'keysPendingBudgets' => $keysPbuds,
  866.                 'destinations' => $destinations,
  867.                 'htFile' => $htFile,
  868.                 'gpFile' => $gpFile,
  869.             ));
  870.     }
  872.     /**
  873.      * @Route("/filedelete/{id}",  name="ave_delete_file")
  874.      * Actualizar un expediente
  875.      */
  876.     public function deleteFileAction($id, Request $request)
  877.     {
  878.         $em = $this->getDoctrine()->getManager();
  879.         $newFile = $em->getRepository(AveFiles::class)->findOneById($id);
  881.         /* Obtengo usuario logueado */
  882.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  883.         $user_id = $user_logueado->getId();
  885.         $newFile->setStatus('Deleted');
  886.         $newFile->setUpdatedId($user_id);
  887.         $newFile->setUpdatedAt(new \DateTime("now"));
  889.         $em->persist($newFile);
  890.         $em->flush();
  892.         return $this->redirectToRoute('ave_edit_file', array( 'id' => $id ));
  893.     }
  895.     /**
  896.      * @Route("/filefrombudget/{id}",  name="ave_add_file_from_budget")
  897.      * Agregar un expediente desde un presupuesto
  898.      */
  899.     public function addFileFromBudgetAction( $id, Request $request)
  900.     {
  901.         $em = $this->getDoctrine()->getManager();
  902.         $budget = $em->getRepository(AveBudgetPending::class)->findOneById($id);
  903.         $proposal = $em->getRepository(Proposal::class)->findOneById($budget->getProposalId());
  905.         $newFile = $em->getRepository(AveFiles::class)->findOneByIdProposal($proposal->getId());
  907.         /* Obtengo usuario logueado */
  908.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  909.         $user_id = $user_logueado->getId();
  911.         if (empty($newFile)){
  912.             // No hay un File asociado a ese proposal, se debe crear uno nuevo
  913.             $newFile = new AveFiles();
  914.             $newFile->setTitle($proposal->getId().' - ' .$budget->getProposalTitle());
  915.             $newFile->setClient(262);                           // In Out es el cliente
  916.             $newFile->setIdProposal($proposal->getId());
  917.             $newFile->setStatus('Pending');
  918.             $newFile->setAdvancePayment(null);
  919.             if (!empty($budget->getBriefing())){
  920.                 $newFile->setDescription('<p> *********  MENSAJE DEL AGENTE  ********* </p>' . $budget->getBriefing());
  921.             }
  922.             $newFile->setDateStart(new \DateTime("now"));
  923.             $newFile->setDateEnd(new \DateTime("now"));
  925.             $newFile->setCreatedId($user_id);
  926.             $newFile->setUpdatedId($user_id);
  927.             $newFile->setCreatedAt(new \DateTime("now"));
  928.             $newFile->setUpdatedAt(new \DateTime("now"));
  929.         } else {
  930.             // Ya existe un File asociado a ese proposal
  931.             $newFile->setClient(262);                           // In Out es el cliente
  932.             $newFile->setStatus('Pending');
  933.             if (!empty($budget->getBriefing())) {
  934.                 $newFile->setDescription($newFile->getDescription() . '<p> *********  MENSAJE DEL AGENTE  ********* </p>' . $budget->getBriefing());
  935.             }
  936.             $newFile->setUpdatedId($user_id);
  937.             $newFile->setUpdatedAt(new \DateTime("now"));
  938.         }
  940.         $em->persist($newFile);
  941.         $em->flush();
  943.         $em->remove($budget);
  944.         $em->flush();
  946.         //Actualizamos los Briefings que esten en FileId null con el recien generado fileId en base al proposalId
  947.         $allBriefings = $em->getRepository(AveBriefings::class)->findByProposalId($proposal->getId());
  948.         foreach ($allBriefings as $item){
  949.             if (empty($item->getFileId())) {
  950.                 $item->setFileId($newFile->getId());
  952.                 $em->persist($item);
  953.                 $em->flush();
  954.             }
  955.         }
  956.         return $this->redirectToRoute('ave_edit_file', array( 'id' => $newFile->getId() ));
  957.     }
  959.     /**
  960.      * @Route("/filelistbriefings/{id}",  name="ave_list_file_briefings")
  961.      * Listar briefings del expediente
  962.      */
  963.     public function listFileBriefingsAction($id, Request $request){
  965.         $em = $this->getDoctrine()->getManager();
  966.         $briefings = $em->getRepository(AveBriefings::class)->findByFileId($id);
  968.         return $this->render('MDS/AvexpressBundle/Avexpress/list-briefings.html.twig',
  969.             array(
  970.                 'id' => $id,
  971.                 'briefings' => $briefings,
  972.             )
  973.         );
  974.     }
  977.     /**
  978.      * @Route("/briefingadd/{id}",  name="ave_add_file_briefings")
  979.      * Agregar briefing al expediente
  980.      */
  981.     public function addFileBriefingsAction($id, Request $request){
  983.         $brif = $request->request->get('newbriefing');
  985.         $em = $this->getDoctrine()->getManager();
  986.         $file = $em->getRepository(AveFiles::class)->findOneById($id);
  987.         $proposalId = $file->getIdProposal();
  989.         /* Obtengo usuario logueado */
  990.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  991.         $user_id = $user_logueado->getId();
  993.         $userConfirmedFullName = $user_logueado->getName().' '.$user_logueado->getLastName();
  995.         $briefing = new AveBriefings();
  996.         $briefing->setProposalId($proposalId);
  997.         $briefing->setBriefing($brif);
  998.         $briefing->setBudgetPendingId(null);
  999.         $briefing->setFileId($id);
  1000.         $briefing->setUserConfirmedFullName($userConfirmedFullName);
  1001.         $briefing->setUserConfirmedId($user_id);
  1002.         $briefing->setCreatedAt(new \DateTime("now"));
  1004.         $em->persist($briefing);
  1005.         $em->flush();
  1007.         $briefings = $em->getRepository(AveBriefings::class)->findByFileId($id);
  1009.         return $this->render('MDS/AvexpressBundle/Avexpress/list-briefings.html.twig',
  1010.             array(
  1011.                 'id' => $id,
  1012.                 'briefings' => $briefings,
  1013.             )
  1014.         );
  1015.     }
  1018.     /**
  1019.      * @Route("/filedeletedlist/",  name="ave_list_file_deleted")
  1020.      * Listar expedientes cancelados
  1021.      */
  1022.     public function listFileDeletedAction( Request $request)
  1023.     {
  1024.         $em = $this->getDoctrine()->getManager();
  1025.         $idgroup = null; $ref = array();
  1026.         $reservas = $em->getRepository(AveFiles::class)->findByStatus('Deleted');
  1028.         foreach ($reservas as $res) {
  1029.             $client = $em->getRepository(Client::class)->findOneById($res->getClient());
  1030.             if (!empty($client)) { $res->setClient($client->getName()); } else { $res->setClient(null); }
  1032.             if (!empty($res->getDateStart()) and !empty($res->getDateEnd())) {
  1033.                 $ref[$res->getId()] = '#' . ($res->getDateStart())->format('ymd') . ($res->getDateEnd())->format('ymd');
  1034.             } else {
  1035.                 $ref[$res->getId()] = '#' . '000000' . '000000';
  1036.             }
  1037.         }
  1039.         $reservasZero = array();
  1040.         foreach ($reservas as $res) {
  1041.             $reservasZero[] = array(
  1042.                 'dateStart' => $res->getDateStart(),
  1043.                 'dateEnd' => $res->getDateEnd(),
  1044.                 'id' => $res->getId(),
  1045.                 'title' => $res->getTitle(),
  1046.                 'client' => $res->getClient(),
  1047.                 'createdId' => $res->getCreatedId(),
  1048.                 'ref' => $ref[$res->getId()],
  1049.                 'reservation' => $res->getReservation(),
  1050.             );
  1051.         }
  1052.         $reservas = $reservasZero;
  1054.         return $this->render('MDS/AvexpressBundle/Avexpress/list-files.html.twig',
  1055.             array(
  1056.                 'groups' => null,
  1057.                 'listofdeletedfiles' => true,
  1058.                 'reservations' => $reservas
  1059.             )
  1060.         );
  1061.     }
  1064.     /**
  1065.      * @Route("/updatefilecomments/{id}",  name="ave_update_file_comments")
  1066.      * Actualizar Comentarios y booleanos del expediente
  1067.      */
  1068.     public function updateFileCommentsAction($id, Request $request){
  1069.         $em = $this->getDoctrine()->getManager();
  1071.         $file = $em->getRepository(AveFiles::class)->findOneById($id);
  1072.         $newComments = $request->request->get('comments');
  1073.         $chkCommentsToPro = $request->request->get('chkCommentsToPro');
  1074.         $chkCommentsToInv = $request->request->get('chkCommentsToInv');
  1076.         if ($chkCommentsToInv == 'on'){ $chkCommentsToInv = true; } else { $chkCommentsToInv = false; }
  1077.         if ($chkCommentsToPro == 'on'){ $chkCommentsToPro = true; } else { $chkCommentsToPro = false; }
  1079.         $file->setComments($newComments);
  1080.         $file->setCommentsInInv($chkCommentsToInv);
  1081.         $file->setCommentsInPro($chkCommentsToPro);
  1083.         $em->persist($file);
  1084.         $em->flush();
  1086.         return $this->redirectToRoute('ave_edit_file', array( 'id' => $id ));
  1087.     }
  1091.     private function baseInvoiceDoneFileTwo($fileId, $invoiceId, $typeBase)
  1092.     {
  1093.         $em = $this->getDoctrine()->getManager();
  1094.         $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  1095.         $dateDocument = null;                                                                           //Fecha final del documento
  1096.         $subneto = 0;
  1097.         if (($typeBase == 'I') or ($typeBase == 'P')) {
  1098.             if ($typeBase == 'I') {
  1099.                 $items = $em->getRepository(AveDocInvoiceItems::class)->findBy(array('fileId' => $fileId, 'invoiceId' => $invoiceId));
  1100.             } else {
  1102.                 // Es proforma
  1103. //                $items = $em->getRepository(AveDocProformaItems::class)->findBy(array('fileId' => $fileId, 'proformaId' => $invoiceId));
  1106. //                $items = $em->getRepository(AveDocProformaItems::class)->findBy(array('fileId' => $fileId, 'proformaId' => $invoiceId));
  1107.                 $parameters = array(
  1108.                     'fileId' => $fileId,
  1109.                     'proformaId' => $invoiceId,
  1110.                 );
  1111.                 $dql = 'SELECT i
  1112.                         FROM AvexpressBundle:AveProductFile i
  1113.                         INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1114.                         WHERE i.fileId = :fileId AND c.proformaId =:proformaId
  1115.                         ORDER BY i.rankAv ASC';
  1116.                 $query = $em->createQuery($dql)->setParameters($parameters);
  1117.                 $items = $query->getResult();
  1119.                 $arrayLocation = array();
  1120.                 $arrayLocationWithNull = false;
  1121.                 foreach ($items as $item){
  1122.                     if (!empty($item->getLocation())){
  1123.                         $arrayLocation[$item->getLocation()] = $item->getLocation();
  1124.                     } else {
  1125.                         $arrayLocationWithNull = true;
  1126.                     }
  1127.                 }
  1128.                 if ($arrayLocationWithNull){ $arrayLocation['null'] = 'null'; }
  1130.                 $productsInFile = array();
  1132.                 foreach ($arrayLocation as $item){
  1134.                     // VIDEO
  1135.                     $parameters = array(
  1136.                         'fileId' => $fileId,
  1137.                         'type' => 'Vídeo',
  1138.                         'location' => $item,
  1139.                         'proformaId' => $invoiceId,
  1140.                     );
  1141.                     $dql = 'SELECT i                            
  1142.                             FROM AvexpressBundle:AveProductFile i
  1143.                             INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1144.                             WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location AND c.proformaId =:proformaId
  1145.                             ORDER BY i.rankAv ASC';
  1146.                     $query = $em->createQuery($dql)->setParameters($parameters);
  1147.                     $productsInFileVid = $query->getResult();
  1149.                     // SONIDO
  1150.                     $parameters = array(
  1151.                         'fileId' => $fileId,
  1152.                         'type' => 'Sonido',
  1153.                         'location' => $item,
  1154.                         'proformaId' => $invoiceId,
  1155.                     );
  1156.                     $dql = 'SELECT i
  1157.                             FROM AvexpressBundle:AveProductFile i
  1158.                             INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1159.                             WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location AND c.proformaId =:proformaId
  1160.                             ORDER BY i.rankAv ASC';
  1161.                     $query = $em->createQuery($dql)->setParameters($parameters);
  1162.                     $productsInFileSound = $query->getResult();
  1164.                     // ILUMINACION
  1165.                     $parameters = array(
  1166.                         'fileId' => $fileId,
  1167.                         'type' => 'Iluminación',
  1168.                         'location' => $item,
  1169.                         'proformaId' => $invoiceId,
  1170.                     );
  1171.                     $dql = 'SELECT i
  1172.                             FROM AvexpressBundle:AveProductFile i
  1173.                             INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1174.                             WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location AND c.proformaId =:proformaId
  1175.                             ORDER BY i.rankAv ASC';
  1176.                     $query = $em->createQuery($dql)->setParameters($parameters);
  1177.                     $productsInFileLights = $query->getResult();
  1179.                     // OTROS
  1180.                     $parameters = array(
  1181.                         'fileId' => $fileId,
  1182.                         'typeV' => 'Vídeo',
  1183.                         'typeS' => 'Sonido',
  1184.                         'typeI' => 'Iluminación',
  1185.                         'location' => $item,
  1186.                         'proformaId' => $invoiceId,
  1187.                     );
  1188.                     $dql = 'SELECT i
  1189.                             FROM AvexpressBundle:AveProductFile i
  1190.                             INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1191.                             WHERE (i.fileId = :fileId AND i.type != :typeV AND i.type != :typeS AND i.type != :typeI AND i.location = :location AND c.proformaId =:proformaId)
  1192.                             ORDER BY i.rankAv ASC';
  1193.                     $query = $em->createQuery($dql)->setParameters($parameters);
  1194.                     $productsInFileOther = $query->getResult();
  1196.                     // CASO NULL (Los casos EMPTY estan considerados en las consultas previas)
  1197.                     $parameters = array(
  1198.                         'fileId' => $fileId,
  1199.                         'location' => $item,
  1200.                         'proformaId' => $invoiceId,
  1201.                     );
  1202.                     $dql = 'SELECT i
  1203.                             FROM AvexpressBundle:AveProductFile i
  1204.                             INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1205.                             WHERE (i.fileId = :fileId AND i.type IS NULL AND i.location = :location AND c.proformaId =:proformaId)
  1206.                             ORDER BY i.rankAv ASC';
  1207.                     $query = $em->createQuery($dql)->setParameters($parameters);
  1208.                     $productsInFileNull = $query->getResult();
  1210.                     // Para el location en NULL el SQL tiene que ser diferente por eso el siguiente condicional
  1211.                     if ($item == 'null'){
  1213.                         // VIDEO
  1214.                         $parameters = array(
  1215.                             'fileId' => $fileId,
  1216.                             'type' => 'Vídeo',
  1217.                             'proformaId' => $invoiceId,
  1218. //                    'location' => $item,
  1219.                         );
  1220.                         $dql = 'SELECT i
  1221.                                 FROM AvexpressBundle:AveProductFile i
  1222.                                 INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1223.                                 WHERE i.fileId = :fileId AND i.type = :type AND i.location IS NULL AND c.proformaId =:proformaId
  1224.                                 ORDER BY i.rankAv ASC';
  1225.                         $query = $em->createQuery($dql)->setParameters($parameters);
  1226.                         $productsInFileVid = $query->getResult();
  1228.                         // SONIDO
  1229.                         $parameters = array(
  1230.                             'fileId' => $fileId,
  1231.                             'type' => 'Sonido',
  1232.                             'proformaId' => $invoiceId,
  1233. //                    'location' => $item,
  1234.                         );
  1235.                         $dql = 'SELECT i
  1236.                                 FROM AvexpressBundle:AveProductFile i
  1237.                                 INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1238.                                 WHERE i.fileId = :fileId AND i.type = :type AND i.location IS NULL AND c.proformaId =:proformaId
  1239.                                 ORDER BY i.rankAv ASC';
  1240.                         $query = $em->createQuery($dql)->setParameters($parameters);
  1241.                         $productsInFileSound = $query->getResult();
  1243.                         // ILUMINACION
  1244.                         $parameters = array(
  1245.                             'fileId' => $fileId,
  1246.                             'type' => 'Iluminación',
  1247.                             'proformaId' => $invoiceId,
  1248. //                    'location' => $item,
  1249.                         );
  1250.                         $dql = 'SELECT i
  1251.                                 FROM AvexpressBundle:AveProductFile i
  1252.                                 INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1253.                                 WHERE i.fileId = :fileId AND i.type = :type AND i.location IS NULL AND c.proformaId =:proformaId
  1254.                                 ORDER BY i.rankAv ASC';
  1255.                         $query = $em->createQuery($dql)->setParameters($parameters);
  1256.                         $productsInFileLights = $query->getResult();
  1258.                         // OTROS
  1259.                         $parameters = array(
  1260.                             'fileId' => $fileId,
  1261.                             'typeV' => 'Vídeo',
  1262.                             'typeS' => 'Sonido',
  1263.                             'typeI' => 'Iluminación',
  1264.                             'proformaId' => $invoiceId,
  1265. //                    'location' => $item,
  1266.                         );
  1267.                         $dql = 'SELECT i
  1268.                                 FROM AvexpressBundle:AveProductFile i
  1269.                                 INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1270.                                 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)
  1271.                                 ORDER BY i.rankAv ASC';
  1272.                         $query = $em->createQuery($dql)->setParameters($parameters);
  1273.                         $productsInFileOther = $query->getResult();
  1275.                         // CASO NULL (Los casos EMPTY estan considerados en las consultas previas)
  1276.                         $parameters = array(
  1277.                             'fileId' => $fileId,
  1278.                             'proformaId' => $invoiceId,
  1279. //                    'location' => $item,
  1280.                         );
  1281.                         $dql = 'SELECT i
  1282.                                 FROM AvexpressBundle:AveProductFile i
  1283.                                 INNER JOIN AvexpressBundle:AveDocProformaItems c WITH c.controlId = i.id
  1284.                                 WHERE (i.fileId = :fileId AND i.type IS NULL AND i.location IS NULL AND c.proformaId =:proformaId)
  1285.                                 ORDER BY i.rankAv ASC';
  1286.                         $query = $em->createQuery($dql)->setParameters($parameters);
  1287.                         $productsInFileNull = $query->getResult();
  1288.                     }
  1289.                     $productsInFile = array_merge($productsInFile, $productsInFileVid, $productsInFileSound, $productsInFileLights, $productsInFileOther, $productsInFileNull);
  1290.                 }
  1292.                 $items = $productsInFile;       // En Items estaban todos pero sin ordenamiento, ahora estan organizados por location y tipo
  1303.             }
  1304.         } else {
  1305.             // No es factura ni proforma, es una rectificativa
  1306.             $items = $em->getRepository(AveDocInvoiceRecItems::class)->findBy(array('fileId' => $fileId, 'invoiceRecId' => $invoiceId));
  1307.         }
  1309.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('4');
  1310.         $client = $em->getRepository(Client::class)->findById($file->getClient());
  1312.         if (empty($client)){
  1313.             $client[0] = new Client();
  1314.             $client[0]->setName('');
  1315.             $client[0]->setTitle('');
  1316.             $client[0]->setIdDocument('');
  1317.             $client[0]->setPopulation('');
  1318.             $client[0]->setRegion('');
  1319.             $client[0]->setCountry('');
  1320.         } else {
  1321.             if (is_numeric($client[0]->getPopulation())){
  1322.                 $city = ($em->getRepository(Cities::class)->findOneById($client[0]->getPopulation()));
  1323.                 $client[0]->setPopulation($city->getCity());
  1324.             }
  1325.             if (is_numeric($client[0]->getRegion())){
  1326.                 $region = ($em->getRepository(Regions::class)->findOneById($client[0]->getRegion()));
  1327.                 $client[0]->setRegion($region->getRegion());
  1328.             }
  1329.             if (is_numeric($client[0]->getCountry())){
  1330.                 $country = ($em->getRepository(Country::class)->findOneById($client[0]->getCountry()));
  1331.                 $client[0]->setCountry($country->getCountry());
  1332.             }
  1333.         }
  1335.         // Acumuladores de los calculos
  1336.         $totales_neto_all = 0;
  1337.         $data_iva = array(
  1338.             'iva' => 21,
  1339.             'ivaMontoVeintiUno' => 0,
  1340.             'ivaMontoDiez' => 0,
  1341.             'ivaMontoCero' => 0,
  1342.         );
  1344.         //INICIO: Determinamos el numero de factura o proforma
  1345.         if ($typeBase == 'I'){
  1346.             // Es una Factura
  1348.             $number = $em->getRepository(AveDocInvoice::class)->findOneById($invoiceId);
  1349.             $dateDocument = $number->getDateAt();
  1350.             $number = $number->getNumber();
  1351.             $type = 'Invoice';
  1353.         } else {
  1354.             if ($typeBase == 'R'){
  1355.                 // Es una factura rectificativa
  1356.                 $number = $em->getRepository(AveDocInvoiceRec::class)->findOneById($invoiceId);
  1357.                 $dateDocument = $number->getDateAt();
  1358.                 $type = 'Invoice Rec';
  1359.             } else {
  1360.                 // Es una Proforma
  1362.                 $number = $invoiceId;
  1363.                 $type = 'Proforma';
  1364.             }
  1365.         }
  1366.         //FIN: Determinamos el numero de factura o proforma
  1368.         // Buscamos los productos, pagos y servicios
  1370.         $arrayItems = array();
  1371.         $fileProducts = array();
  1372.         $payments = array();
  1373.         $services = array();
  1375.         if (!empty($items)) {
  1376.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1377.                 foreach ($items as $item) {
  1378.                     switch ($item->getItemType()) {
  1379.                         case 'PRODUCT': // Producto
  1380.                             $fileProducts[] = $item;
  1381.                             break;
  1383.                         case 'PAYMENT': // Pago
  1384.                             $payments[] = $item;
  1385.                             break;
  1387.                         case 'SERVICE': // Servicio
  1388.                             $services[] = $item;
  1389.                             break;
  1391.                         default:
  1392.                             break;
  1394.                     }
  1395.                 }
  1396.             } else {
  1397.                 // Es una proforma
  1399.                 foreach ($items as $item) {
  1400.                     switch ($item->getType()) {
  1401.                         case 'PRODUCT': // Producto
  1402.                             $productPro = $em->getRepository(AveProductFile::class)->findOneById($item->getControlId());
  1403.                             if (!empty($productPro)) {
  1404.                                 $fileProducts[] = $productPro;
  1405.                             }
  1406.                             break;
  1408.                         case 'PAYMENT': // Pago
  1409.                             $paymentPro = $em->getRepository(AvePaymentsClient::class)->findOneById($item->getControlId());
  1410.                             if (!empty($paymentPro)) {
  1411.                                 $payments[] = $paymentPro;
  1412.                             }
  1413.                             break;
  1415.                         case 'SERVICE': // Servicio
  1416.                             $servicePro = $em->getRepository(AveServices::class)->findOneById($item->getControlId());
  1417.                             if (!empty($servicePro)) {
  1418.                                 $services[] = $servicePro;
  1419.                             }
  1420.                             break;
  1422.                         default:
  1424.                             // Producto  (Video, Iluminacion, Sonido, Otros)
  1425.                             if (!empty($item)) {
  1426.                                 $fileProducts[] = $item;
  1427.                             }
  1428.                         break;
  1429.                     }
  1430.                 }
  1431.             }
  1432.         }
  1434.         $data_supplier = array();
  1435.         $i = 0;
  1437.         $iva = '21';            // Esteban Rincon: "Por Ley de localización del impuesto, siempre será un 21%"
  1438.         $pax = '1';
  1439.         $qty = '1';
  1440.         $product = array(
  1441.             'neto' => 0,
  1442.             'sumSubT' => 0,
  1443.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1445.         $service = array(
  1446.             'neto' => 0,
  1447.             'sumSubT' => 0,
  1448.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1450.         foreach ($fileProducts as $item){
  1452.             if (!is_null($item->getUnits()) or !empty($item->getUnits())){
  1453.                 $qty = $item->getUnits();
  1454.             }
  1456.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1457.                 if (is_null($item->getPrdServicePrice()) or empty($item->getPrdServicePrice())){
  1458.                     $subtotal = 0;
  1459.                     $neto = 0;
  1460.                     $subtotalProduct = 0;
  1462.                 } else {
  1464. //                    $subtotalProduct = $item->getPrdServicePrice() * 1.21;
  1465.                     $subtotalProduct = $item->getPrdSubTotalPrice() * 1.21;
  1466. //                    $subneto = $item->getPrdServicePrice();
  1467.                     $subneto = $item->getPrdSubTotalPrice();
  1469.                     $subtotal =  $subtotalProduct;
  1470.                     $neto =  $subneto;
  1472.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  1473.                     $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  1474.                     $neto = round($neto,2,PHP_ROUND_HALF_UP);
  1476.                     $arrayItems[] = array(
  1477.                         'type' => 'Product',
  1478.                         'name' => $item->getPrdName(),
  1479.                         'amount' => $neto,
  1480.                         'iva' => '21',
  1481.                         'total' => $subtotal,
  1482.                     );
  1483.                 }
  1484.             } else {
  1485.                 // Es proforma
  1486.                 if (is_null($item->getServicePrice()) or empty($item->getServicePrice())){
  1487.                     $subtotal = 0;
  1488.                     $neto = 0;
  1489.                     $subtotalProduct = 0;
  1491.                 } else {
  1493. //                    $subtotalProduct = $item->getServicePrice() * 1.21;
  1494.                     $subtotalProduct = $item->getSubTotalPrice() * 1.21;
  1495. //                    $subneto = $item->getServicePrice();
  1496.                     $subneto = $item->getSubTotalPrice();
  1498.                     $subtotal =  $subtotalProduct;
  1499.                     $neto =  $subneto;
  1501.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  1502.                     $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  1503.                     $neto = round($neto,2,PHP_ROUND_HALF_UP);
  1505.                     $arrayItems[] = array(
  1506.                         'type' => 'Product',
  1507.                         'name' => $item->getProductName(),
  1508.                         'amount' => $neto,
  1509.                         'iva' => '21',
  1510.                         'total' => $subtotal,
  1511.                     );
  1512.                 }
  1513.             }
  1515.             // Acumula netos totales e IVA
  1516.             $totales_neto_all = $totales_neto_all + $neto;
  1517.             $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * 0.21);
  1518.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1519.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  1520.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  1521.             // Acumula netos totales e IVA
  1523.             $product['neto'] = $product['neto'] + $neto;
  1524.             $product['sumSubT'] = $product['sumSubT'] + $subtotal;
  1525.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1526.             $product['neto'] = round($product['neto'],2,PHP_ROUND_HALF_UP);
  1527.             $product['sumSubT'] = round($product['sumSubT'],2,PHP_ROUND_HALF_UP);
  1529.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1530.                 $data_supplier['product'][$i] = array(
  1531.                     'id' => $item->getId(),
  1532.                     'productName' => $item->getPrdName(),
  1533.                     'productId' => $item->getPrdProductId(),
  1534.                     'dateStart' => $item->getPrdDateStart(),
  1535.                     'dateEnd' => $item->getPrdDateEnd(),
  1536.                     'servicePrice' => $item->getPrdServicePrice(),
  1537.                     'serviceSubTotalPrice' => $subneto,     //antes de IVA
  1538.                     'subtotalProduct' => $subtotalProduct,
  1539.                     'iva' => $iva,
  1540.                     'pax' => $pax,
  1541.                     'qty' => $qty,
  1542.                     'type' => $item->getPrdType(),
  1543.                     'subtotal' => $subtotal,
  1544.                 );
  1545.             } else {
  1546.                 // Es proforma
  1547.                 $data_supplier['product'][$i] = array(
  1548.                     'id' => $item->getId(),
  1549.                     'productName' => $item->getProductName(),
  1550.                     'productId' => $item->getProductId(),
  1551.                     'dateStart' => $item->getDateStart(),
  1552.                     'dateEnd' => $item->getDateEnd(),
  1553.                     'servicePrice' => $item->getServicePrice(),
  1554.                     'subtotalProduct' => $subtotalProduct,
  1555.                     'iva' => $iva,
  1556.                     'pax' => $pax,
  1557.                     'qty' => $qty,
  1558.                     'type' => $item->getType(),
  1559.                     'subtotal' => $subtotal,
  1560.                 );
  1561.             }
  1562.             $i++;
  1563.         }
  1565.         $data_supplier['productSubTotal'] = array(
  1566.             'neto' => $product['neto'],
  1567.             'sumSubT' => $product['sumSubT'],
  1568.         );
  1570.         $payment = array(
  1571.             'sumSubT' => 0,
  1572.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1574.         $i = 0;
  1575.         foreach ($payments as $item){
  1577.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1578.                 $payment['sumSubT'] = $payment['sumSubT'] + $item->getPayAmountTotal();
  1579.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1580.                 $payment['sumSubT'] = round($payment['sumSubT'], 2, PHP_ROUND_HALF_UP);
  1582.                 $data_supplier['payment'][$i] = array(
  1583.                     'id' => $item->getId(),
  1584.                     'amount' => $item->getPayAmount(),
  1585.                     'amountTotal' => $item->getPayAmountTotal(),
  1586.                     'vat' => $item->getPayVat(),
  1587.                     'datePayAt' => $item->getPayDatePayAt(),
  1588.                     'wayToPay' => $item->getPayWayToPay(),
  1589.                 );
  1591.                 $arrayItems[] = array(
  1592.                     'type' => 'Payment',
  1593.                     'name' => $item->getPayWayToPay(),
  1594.                     'amount' => $item->getPayAmount(),
  1595.                     'total' => $item->getPayAmountTotal(),
  1596.                     'iva' => $item->getPayVat(),
  1597.                 );
  1598.             } else {
  1599.                 // Es una proforma
  1600.                 $payment['sumSubT'] = $payment['sumSubT'] + $item->getAmountTotal();
  1601.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1602.                 $payment['sumSubT'] = round($payment['sumSubT'], 2, PHP_ROUND_HALF_UP);
  1604.                 $data_supplier['payment'][$i] = array(
  1605.                     'id' => $item->getId(),
  1606.                     'amount' => $item->getAmount(),
  1607.                     'amountTotal' => $item->getAmountTotal(),
  1608.                     'vat' => $item->getVat(),
  1609.                     'datePayAt' => $item->getDatePayAt(),
  1610.                     'wayToPay' => $item->getWayToPay(),
  1611.                 );
  1613.                 $arrayItems[] = array(
  1614.                     'type' => 'Payment',
  1615.                     'name' => $item->getWayToPay(),
  1616.                     'amount' => $item->getAmount(),
  1617.                     'total' => $item->getAmountTotal(),
  1618.                     'iva' => $item->getVat(),
  1619.                 );
  1620.             }
  1621.             $i++;
  1622.         }
  1624.         if (!empty($payments)) {
  1625.             $data_supplier['paymentSubTotal'] = array(
  1626.                 'sumSubT' => $payment['sumSubT'],
  1627.             );
  1628.         }
  1630.         foreach ($services as $item){
  1631.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1632.                 if (is_null($item->getSrvPrice()) or empty($item->getSrvPrice())) {
  1633.                     $subtotal = 0;
  1634.                     $neto = 0;
  1635.                     $subtotalService = 0;
  1637.                 } else {
  1638.                     $subtotalService = $item->getSrvPrice();
  1639.                     $subneto = $item->getSrvPrice();
  1641.                     // Commission
  1642.                     if ($item->getSrvOpCommission() == '1') {
  1643.                         $subtotalService = $subtotalService * (1 + ($item->getSrvCommission() / 100));
  1644.                         $subneto = $subneto * (1 + ($item->getSrvCommission() / 100));
  1645.                     } else {
  1646.                         $subtotalService = $subtotalService * (1 - ($item->getSrvCommission() / 100));
  1647.                         $subneto = $subneto * (1 - ($item->getSrvCommission() / 100));
  1648.                     }
  1650.                     // Over
  1651.                     if ($item->getSrvOpOver() == '1') {
  1652.                         $subtotalService = $subtotalService + $item->getSrvOver();
  1653.                         $subneto = $subneto + $item->getSrvOver();
  1654.                     } else {
  1655.                         $subtotalService = $subtotalService - $item->getSrvOver();
  1656.                         $subneto = $subneto - $item->getSrvOver();
  1657.                     }
  1659.                     // IVA
  1660.                     if ($item->getSrvOpIva() == '1') {
  1661.                         $subtotalService = $subtotalService * (1 + ($item->getSrvIva() / 100));
  1662.                     } else {
  1663.                         $subtotalService = $item->getSrvPrice();
  1664.                         $subneto = ($subneto * 100) / (100 + $item->getSrvIva());
  1665.                     }
  1667.                     switch ($item->getSrvServiceCatId()) {
  1668.                         case 1: // Alojamiento
  1669.                             // el numero de noches $numNoches; precio unitario $subneto
  1670.                             $numNoches = (($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days;
  1671.                             // La personas no afectan este calculo
  1672.                             $subtotal = $subtotalService * $numNoches * $item->getSrvUnits();
  1673.                             $subnetoUnit = $subneto;
  1675.                             $subneto = $subneto * $numNoches * $item->getSrvUnits();
  1677.                             $data_supplier['service'][$i] = array(
  1678.                                 'id' => $item->getId(),
  1679.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1680.                                 'serviceName' => $item->getSrvName(),
  1681.                                 'serviceType' => 'Hotel',
  1682.                                 'date' => ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y'),
  1683.                                 'qty' => $item->getSrvUnits(),
  1684.                                 'iva' => $item->getSrvIva(),
  1685.                                 'pax' => '-',
  1686.                                 'precioUnit' => $subnetoUnit,
  1687.                                 'subneto' => $subneto,
  1688.                                 'subtotal' => $subtotal,
  1689.                             );
  1690.                             break;
  1692.                         case 2: //Actividades
  1693.                             // El número de personas es considerado en el calculo
  1694.                             $pax = $item->getSrvPax();
  1695.                             if (empty($pax) or $pax == "0") {
  1696.                                 $pax = 1;
  1697.                             }
  1698.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1700.                             if ($days > 1) {
  1701.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1702.                             } else {
  1703.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1704.                             }
  1706.                             $subtotal = $subtotalService * $days * $item->getSrvUnits();
  1707.                             $subnetoUnit = $subneto;
  1708.                             $subneto = $subneto * $days * $item->getSrvUnits();
  1710.                             $data_supplier['service'][$i] = array(
  1711.                                 'id' => $item->getId(),
  1712.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1713.                                 'serviceName' => $item->getSrvName(),
  1714.                                 'serviceType' => 'Actividad',
  1715.                                 'date' => $dateServ,
  1716.                                 'qty' => $item->getSrvUnits(),
  1717.                                 'iva' => $item->getSrvIva(),
  1718.                                 'pax' => $item->getSrvPax(),
  1719.                                 'precioUnit' => $subnetoUnit,
  1720.                                 'subneto' => $subneto,
  1721.                                 'subtotal' => $subtotal,
  1722.                             );
  1723.                             break;
  1725.                         case 3: // AV
  1726.                             $pax = $item->getSrvPax();
  1727.                             if (empty($pax) or $pax == "0") {
  1728.                                 $pax = 1;
  1729.                             }
  1731.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1732.                             if ($days > 1) {
  1733.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1734.                             } else {
  1735.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1736.                             }
  1738.                             $unitsServ = $item->getSrvUnits();
  1739.                             if (empty($unitsServ) or $unitsServ == "0") {
  1740.                                 $unitsServ = 1;
  1741.                             }
  1743.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1744.                             $subnetoUnit = $subneto;
  1745.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1747.                             $data_supplier['service'][$i] = array(
  1748.                                 'id' => $item->getId(),
  1749.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1750.                                 'serviceName' => $item->getSrvName(),
  1751.                                 'serviceType' => 'AV',
  1752.                                 'date' => $dateServ,
  1753.                                 'qty' => $unitsServ,
  1754.                                 'iva' => $item->getSrvIva(),
  1755.                                 'pax' => $item->getSrvPax(),
  1756.                                 'precioUnit' => $subnetoUnit,
  1757.                                 'subneto' => $subneto,
  1758.                                 'subtotal' => $subtotal,
  1759.                             );
  1760.                             break;
  1762.                         case 4: //Creative
  1763.                             $pax = $item->getSrvPax();
  1764.                             if (empty($pax) or $pax == "0") {
  1765.                                 $pax = 1;
  1766.                             }
  1768.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1769.                             if ($days > 1) {
  1770.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1771.                             } else {
  1772.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1773.                             }
  1775.                             $unitsServ = $item->getSrvUnits();
  1776.                             if (empty($unitsServ) or $unitsServ == "0") {
  1777.                                 $unitsServ = 1;
  1778.                             }
  1780.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1781.                             $subnetoUnit = $subneto;
  1782.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1784.                             $data_supplier['service'][$i] = array(
  1785.                                 'id' => $item->getId(),
  1786.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1787.                                 'serviceName' => $item->getSrvName(),
  1788.                                 'serviceType' => 'Creativo',
  1789.                                 'date' => $dateServ,
  1790.                                 'qty' => $unitsServ,
  1791.                                 'iva' => $item->getSrvIva(),
  1792.                                 'pax' => $item->getSrvPax(),
  1793.                                 'precioUnit' => $subnetoUnit,
  1794.                                 'subneto' => $subneto,
  1795.                                 'subtotal' => $subtotal,
  1796.                             );
  1797.                             break;
  1799.                         case 5: //Cruise
  1800.                             $pax = $item->getSrvPax();
  1801.                             if (empty($pax) or $pax == "0") {
  1802.                                 $pax = 1;
  1803.                             }
  1805.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days);
  1806.                             if ($days > 1) {
  1807.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1808.                             } else {
  1809.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1810.                             }
  1812.                             $unitsServ = $item->getSrvUnits();
  1813.                             if (empty($unitsServ) or $unitsServ == "0") {
  1814.                                 $unitsServ = 1;
  1815.                             }
  1817.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1818.                             $subnetoUnit = $subneto;
  1819.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1821.                             $data_supplier['service'][$i] = array(
  1822.                                 'id' => $item->getId(),
  1823.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1824.                                 'serviceName' => $item->getSrvName(),
  1825.                                 'serviceType' => 'Crucero',
  1826.                                 'date' => $dateServ,
  1827.                                 'qty' => $unitsServ,
  1828.                                 'iva' => $item->getSrvIva(),
  1829.                                 'pax' => $item->getSrvPax(),
  1830.                                 'precioUnit' => $subnetoUnit,
  1831.                                 'subneto' => $subneto,
  1832.                                 'subtotal' => $subtotal,
  1833.                             );
  1834.                             break;
  1836.                         case 6: //Entertaiment
  1837.                             $pax = $item->getSrvPax();
  1838.                             if (empty($pax) or $pax == "0") {
  1839.                                 $pax = 1;
  1840.                             }
  1842.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1843.                             if ($days > 1) {
  1844.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1845.                             } else {
  1846.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1847.                             }
  1849.                             $unitsServ = $item->getSrvUnits();
  1850.                             if (empty($unitsServ) or $unitsServ == "0") {
  1851.                                 $unitsServ = 1;
  1852.                             }
  1854.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1855.                             $subnetoUnit = $subneto;
  1856.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1858.                             $data_supplier['service'][$i] = array(
  1859.                                 'id' => $item->getId(),
  1860.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1861.                                 'serviceName' => $item->getSrvName(),
  1862.                                 'serviceType' => 'Entretenimiento',
  1863.                                 'date' => $dateServ,
  1864.                                 'qty' => $unitsServ,
  1865.                                 'iva' => $item->getSrvIva(),
  1866.                                 'pax' => $item->getSrvPax(),
  1867.                                 'precioUnit' => $subnetoUnit,
  1868.                                 'subneto' => $subneto,
  1869.                                 'subtotal' => $subtotal,
  1870.                             );
  1871.                             break;
  1873.                         case 7: // Gifts
  1874.                             $pax = $item->getSrvPax();
  1875.                             if (empty($pax) or $pax == "0") {
  1876.                                 $pax = 1;
  1877.                             }
  1879. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1880.                             $days = 1;
  1881.                             if ($days > 1) {
  1882.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1883.                             } else {
  1884.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1885.                             }
  1887.                             $unitsServ = $item->getSrvUnits();
  1888.                             if (empty($unitsServ) or $unitsServ == "0") {
  1889.                                 $unitsServ = 1;
  1890.                             }
  1892.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1893.                             $subnetoUnit = $subneto;
  1894.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1896.                             $data_supplier['service'][$i] = array(
  1897.                                 'id' => $item->getId(),
  1898.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1899.                                 'serviceName' => $item->getSrvName(),
  1900.                                 'serviceType' => 'Regalos',
  1901.                                 'date' => $dateServ,
  1902.                                 'qty' => $unitsServ,
  1903.                                 'iva' => $item->getSrvIva(),
  1904.                                 'pax' => $item->getSrvPax(),
  1905.                                 'precioUnit' => $subnetoUnit,
  1906.                                 'subneto' => $subneto,
  1907.                                 'subtotal' => $subtotal,
  1908.                             );
  1909.                             break;
  1911.                         case 8: //Guide
  1912.                             $pax = $item->getSrvPax();
  1913.                             if (empty($pax) or $pax == "0") {
  1914.                                 $pax = 1;
  1915.                             }
  1917.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1918.                             if ($days > 1) {
  1919.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1920.                             } else {
  1921.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1922.                             }
  1924.                             $unitsServ = $item->getSrvUnits();
  1925.                             if (empty($unitsServ) or $unitsServ == "0") {
  1926.                                 $unitsServ = 1;
  1927.                             }
  1929.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1930.                             $subnetoUnit = $subneto;
  1931.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1933.                             $data_supplier['service'][$i] = array(
  1934.                                 'id' => $item->getId(),
  1935.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1936.                                 'serviceName' => $item->getSrvName(),
  1937.                                 'serviceType' => 'Regalos',
  1938.                                 'date' => $dateServ,
  1939.                                 'qty' => $unitsServ,
  1940.                                 'iva' => $item->getSrvIva(),
  1941.                                 'pax' => $item->getSrvPax(),
  1942.                                 'precioUnit' => $subnetoUnit,
  1943.                                 'subneto' => $subneto,
  1944.                                 'subtotal' => $subtotal,
  1945.                             );
  1946.                             break;
  1948.                         case 9: //Itineraries
  1949.                             $pax = $item->getSrvPax();
  1950.                             if (empty($pax) or $pax == "0") {
  1951.                                 $pax = 1;
  1952.                             }
  1954.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1955.                             if ($days > 1) {
  1956.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1957.                             } else {
  1958.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1959.                             }
  1961.                             $unitsServ = $item->getSrvUnits();
  1962.                             if (empty($unitsServ) or $unitsServ == "0") {
  1963.                                 $unitsServ = 1;
  1964.                             }
  1966.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1967.                             $subnetoUnit = $subneto;
  1968.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1970.                             $data_supplier['service'][$i] = array(
  1971.                                 'id' => $item->getId(),
  1972.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1973.                                 'serviceName' => $item->getSrvName(),
  1974.                                 'serviceType' => 'Itinerarios',
  1975.                                 'date' => $dateServ,
  1976.                                 'qty' => $unitsServ,
  1977.                                 'iva' => $item->getSrvIva(),
  1978.                                 'pax' => $item->getSrvPax(),
  1979.                                 'precioUnit' => $subnetoUnit,
  1980.                                 'subneto' => $subneto,
  1981.                                 'subtotal' => $subtotal,
  1982.                             );
  1983.                             break;
  1985.                         case 10: //Lounge  -- No Aplica
  1986. //                        $pax = $item->getPax();
  1987. //                        if (empty($pax) or $pax == "0") {
  1988. //                            $pax = 1;
  1989. //                        }
  1990. //
  1991. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1992. //                        if ($days > 1){
  1993. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  1994. //                        } else {
  1995. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1996. //                        }
  1997. //
  1998. //                        $unitsServ = $item->getUnits();
  1999. //                        if (empty($unitsServ) or $unitsServ == "0") {
  2000. //                            $unitsServ = 1;
  2001. //                        }
  2002. //
  2003. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2004. //                        $subnetoUnit = $subneto;
  2005. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  2006. //
  2007. //                        $data_supplier['service'][$i] = array (
  2008. //                            'id' => $item->getId(),
  2009. //                            'serviceCatId' => $item->getServiceCatId(),
  2010. //                            'serviceName' => $item->getName(),
  2011. //                            'serviceType' => 'Itinerarios',
  2012. //                            'date' => $dateServ,
  2013. //                            'qty' => $unitsServ,
  2014. //                            'iva' => $item->getIva(),
  2015. //                            'pax' => $item->getPax(),
  2016. //                            'precioUnit' => $subnetoUnit,
  2017. //                            'subneto' => $subneto,
  2018. //                            'subtotal' => $subtotal,
  2019. //                        );
  2020.                             break;
  2022.                         case 11: //Menu
  2023.                             $pax = $item->getSrvPax();
  2024.                             if (empty($pax) or $pax == "0") {
  2025.                                 $pax = 1;
  2026.                             }
  2028.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  2029.                             if ($days > 1) {
  2030.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2031.                             } else {
  2032.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  2033.                             }
  2035.                             $unitsServ = $item->getSrvUnits();
  2036.                             if (empty($unitsServ) or $unitsServ == "0") {
  2037.                                 $unitsServ = 1;
  2038.                             }
  2040.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2041.                             $subnetoUnit = $subneto;
  2042.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2044.                             $data_supplier['service'][$i] = array(
  2045.                                 'id' => $item->getId(),
  2046.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2047.                                 'serviceName' => $item->getSrvName(),
  2048.                                 'serviceType' => 'Menú',
  2049.                                 'date' => $dateServ,
  2050.                                 'qty' => $unitsServ,
  2051.                                 'iva' => $item->getSrvIva(),
  2052.                                 'pax' => $item->getSrvPax(),
  2053.                                 'precioUnit' => $subnetoUnit,
  2054.                                 'subneto' => $subneto,
  2055.                                 'subtotal' => $subtotal,
  2056.                             );
  2057.                             break;
  2059.                         case 12: //Others
  2060.                             $pax = $item->getSrvPax();
  2061.                             if (empty($pax) or $pax == "0") {
  2062.                                 $pax = 1;
  2063.                             }
  2065.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  2066.                             if ($days > 1) {
  2067.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2068.                             } else {
  2069.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  2070.                             }
  2072.                             $unitsServ = $item->getSrvUnits();
  2073.                             if (empty($unitsServ) or $unitsServ == "0") {
  2074.                                 $unitsServ = 1;
  2075.                             }
  2077.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2078.                             $subnetoUnit = $subneto;
  2079.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2081.                             $data_supplier['service'][$i] = array(
  2082.                                 'id' => $item->getId(),
  2083.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2084.                                 'serviceName' => $item->getSrvName(),
  2085.                                 'serviceType' => 'Otros',
  2086.                                 'date' => $dateServ,
  2087.                                 'qty' => $unitsServ,
  2088.                                 'iva' => $item->getSrvIva(),
  2089.                                 'pax' => $item->getSrvPax(),
  2090.                                 'precioUnit' => $subnetoUnit,
  2091.                                 'subneto' => $subneto,
  2092.                                 'subtotal' => $subtotal,
  2093.                             );
  2094.                             break;
  2096.                         case 13: //Transport
  2097.                             $pax = $item->getSrvPax();
  2098.                             if (empty($pax) or $pax == "0") {
  2099.                                 $pax = 1;
  2100.                             }
  2102.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  2103.                             if ($days > 1) {
  2104.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2105.                             } else {
  2106.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  2107.                             }
  2109.                             $unitsServ = $item->getSrvUnits();
  2110.                             if (empty($unitsServ) or $unitsServ == "0") {
  2111.                                 $unitsServ = 1;
  2112.                             }
  2114.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2115.                             $subnetoUnit = $subneto;
  2116.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2118.                             $data_supplier['service'][$i] = array(
  2119.                                 'id' => $item->getId(),
  2120.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2121.                                 'serviceName' => $item->getSrvName(),
  2122.                                 'serviceType' => 'Transporte',
  2123.                                 'date' => $dateServ,
  2124.                                 'qty' => $unitsServ,
  2125.                                 'iva' => $item->getSrvIva(),
  2126.                                 'pax' => $item->getSrvPax(),
  2127.                                 'precioUnit' => $subnetoUnit,
  2128.                                 'subneto' => $subneto,
  2129.                                 'subtotal' => $subtotal,
  2130.                             );
  2131.                             break;
  2133.                         case 14: //Technology
  2134.                             $pax = $item->getSrvPax();
  2135.                             if (empty($pax) or $pax == "0") {
  2136.                                 $pax = 1;
  2137.                             }
  2139. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2140.                             $days = 1;
  2141. //                        if ($days > 1){
  2142. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2143. //                        } else {
  2144. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2145. //                        }
  2146.                             $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2148.                             $unitsServ = $item->getSrvUnits();
  2149.                             if (empty($unitsServ) or $unitsServ == "0") {
  2150.                                 $unitsServ = 1;
  2151.                             }
  2153.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2154.                             $subnetoUnit = $subneto;
  2155.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2157.                             $data_supplier['service'][$i] = array(
  2158.                                 'id' => $item->getId(),
  2159.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2160.                                 'serviceName' => $item->getSrvName(),
  2161.                                 'serviceType' => 'Tecnología',
  2162.                                 'date' => $dateServ,
  2163.                                 'qty' => $unitsServ,
  2164.                                 'iva' => $item->getSrvIva(),
  2165.                                 'pax' => $item->getSrvPax(),
  2166.                                 'precioUnit' => $subnetoUnit,
  2167.                                 'subneto' => $subneto,
  2168.                                 'subtotal' => $subtotal,
  2169.                             );
  2170.                             break;
  2172.                         case 15: //Assisstant
  2173.                             $pax = $item->getSrvPax();
  2174.                             if (empty($pax) or $pax == "0") {
  2175.                                 $pax = 1;
  2176.                             }
  2178.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  2179.                             if ($days > 1) {
  2180.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2181.                             } else {
  2182.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  2183.                             }
  2185.                             $unitsServ = $item->getSrvUnits();
  2186.                             if (empty($unitsServ) or $unitsServ == "0") {
  2187.                                 $unitsServ = 1;
  2188.                             }
  2190.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2191.                             $subnetoUnit = $subneto;
  2192.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2194.                             $data_supplier['service'][$i] = array(
  2195.                                 'id' => $item->getId(),
  2196.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2197.                                 'serviceName' => $item->getSrvName(),
  2198.                                 'serviceType' => 'Asistente',
  2199.                                 'date' => $dateServ,
  2200.                                 'qty' => $unitsServ,
  2201.                                 'iva' => $item->getSrvIva(),
  2202.                                 'pax' => $item->getSrvPax(),
  2203.                                 'precioUnit' => $subnetoUnit,
  2204.                                 'subneto' => $subneto,
  2205.                                 'subtotal' => $subtotal,
  2206.                             );
  2207.                             break;
  2209.                         case 16: //DDR
  2210.                             $pax = $item->getSrvPax();
  2211.                             if (empty($pax) or $pax == "0") {
  2212.                                 $pax = 1;
  2213.                             }
  2215.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  2216.                             if ($days > 1) {
  2217.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  2218.                             } else {
  2219.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  2220.                             }
  2222.                             $unitsServ = $item->getSrvUnits();
  2223.                             if (empty($unitsServ) or $unitsServ == "0") {
  2224.                                 $unitsServ = 1;
  2225.                             }
  2227.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2228.                             $subnetoUnit = $subneto;
  2229.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2231.                             $data_supplier['service'][$i] = array(
  2232.                                 'id' => $item->getId(),
  2233.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  2234.                                 'serviceName' => $item->getSrvName(),
  2235.                                 'serviceType' => 'DDR',
  2236.                                 'date' => $dateServ,
  2237.                                 'qty' => $unitsServ,
  2238.                                 'iva' => $item->getSrvIva(),
  2239.                                 'pax' => $item->getSrvPax(),
  2240.                                 'precioUnit' => $subnetoUnit,
  2241.                                 'subneto' => $subneto,
  2242.                                 'subtotal' => $subtotal,
  2243.                             );
  2244.                             break;
  2246.                         default:
  2247.                             break;
  2248.                     }
  2250.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  2251.                     $subtotal = round($subtotal, 2, PHP_ROUND_HALF_UP);
  2252.                     $neto = round($subneto, 2, PHP_ROUND_HALF_UP);
  2254.                     $arrayItems[] = array(
  2255.                         'type' => 'Service',
  2256.                         'name' => $item->getSrvName(),
  2257.                         'amount' => $neto,
  2258.                         'iva' => $item->getSrvIva(),
  2259.                         'total' => $subtotal,
  2260.                     );
  2262.                 }
  2264.                 switch ($item->getSrvIva()) {
  2265.                     // Acumula IVA
  2266.                     case 21:
  2267.                         $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getSrvIva() / 100));
  2268.                         break;
  2270.                     case 10:
  2271.                         $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getSrvIva() / 100));
  2272.                         break;
  2274.                     case 0:
  2275.                         break;
  2277.                     default:
  2278.                         break;
  2280.                 }
  2281.             } else {
  2282.                 // Es una proforma
  2283.                 if (is_null($item->getPrice()) or empty($item->getPrice())) {
  2284.                     $subtotal = 0;
  2285.                     $neto = 0;
  2286.                     $subtotalService = 0;
  2288.                 } else {
  2289.                     $subtotalService = $item->getPrice();
  2290.                     $subneto = $item->getPrice();
  2292.                     // Commission
  2293.                     if ($item->getOpCommission() == '1') {
  2294.                         $subtotalService = $subtotalService * (1 + ($item->getCommission() / 100));
  2295.                         $subneto = $subneto * (1 + ($item->getCommission() / 100));
  2296.                     } else {
  2297.                         $subtotalService = $subtotalService * (1 - ($item->getCommission() / 100));
  2298.                         $subneto = $subneto * (1 - ($item->getCommission() / 100));
  2299.                     }
  2301.                     // Over
  2302.                     if ($item->getOpOver() == '1') {
  2303.                         $subtotalService = $subtotalService + $item->getOver();
  2304.                         $subneto = $subneto + $item->getOver();
  2305.                     } else {
  2306.                         $subtotalService = $subtotalService - $item->getOver();
  2307.                         $subneto = $subneto - $item->getOver();
  2308.                     }
  2310.                     // IVA
  2311.                     if ($item->getOpIva() == '1') {
  2312.                         $subtotalService = $subtotalService * (1 + ($item->getIva() / 100));
  2313.                     } else {
  2314.                         $subtotalService = $item->getPrice();
  2315.                         $subneto = ($subneto * 100) / (100 + $item->getIva());
  2316.                     }
  2318.                     switch ($item->getServiceCatId()) {
  2319.                         case 1: // Alojamiento
  2320.                             // el numero de noches $numNoches; precio unitario $subneto
  2321.                             $numNoches = (($item->getDateOutAt())->diff($item->getDateInAt()))->days;
  2322.                             // La personas no afectan este calculo
  2323.                             $subtotal = $subtotalService * $numNoches * $item->getUnits();
  2324.                             $subnetoUnit = $subneto;
  2326.                             $subneto = $subneto * $numNoches * $item->getUnits();
  2328.                             $data_supplier['service'][$i] = array(
  2329.                                 'id' => $item->getId(),
  2330.                                 'serviceCatId' => $item->getServiceCatId(),
  2331.                                 'serviceName' => $item->getName(),
  2332.                                 'serviceType' => 'Hotel',
  2333.                                 'date' => ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y'),
  2334.                                 'qty' => $item->getUnits(),
  2335.                                 'iva' => $item->getIva(),
  2336.                                 'pax' => '-',
  2337.                                 'precioUnit' => $subnetoUnit,
  2338.                                 'subneto' => $subneto,
  2339.                                 'subtotal' => $subtotal,
  2340.                             );
  2341.                             break;
  2343.                         case 2: //Actividades
  2344.                             // El número de personas es considerado en el calculo
  2345.                             $pax = $item->getPax();
  2346.                             if (empty($pax) or $pax == "0") {
  2347.                                 $pax = 1;
  2348.                             }
  2349.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2351.                             if ($days > 1) {
  2352.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2353.                             } else {
  2354.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2355.                             }
  2357.                             $subtotal = $subtotalService * $days * $item->getUnits();
  2358.                             $subnetoUnit = $subneto;
  2359.                             $subneto = $subneto * $days * $item->getUnits();
  2361.                             $data_supplier['service'][$i] = array(
  2362.                                 'id' => $item->getId(),
  2363.                                 'serviceCatId' => $item->getServiceCatId(),
  2364.                                 'serviceName' => $item->getName(),
  2365.                                 'serviceType' => 'Actividad',
  2366.                                 'date' => $dateServ,
  2367.                                 'qty' => $item->getUnits(),
  2368.                                 'iva' => $item->getIva(),
  2369.                                 'pax' => $item->getPax(),
  2370.                                 'precioUnit' => $subnetoUnit,
  2371.                                 'subneto' => $subneto,
  2372.                                 'subtotal' => $subtotal,
  2373.                             );
  2374.                             break;
  2376.                         case 3: // AV
  2377.                             $pax = $item->getPax();
  2378.                             if (empty($pax) or $pax == "0") {
  2379.                                 $pax = 1;
  2380.                             }
  2382.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2383.                             if ($days > 1) {
  2384.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2385.                             } else {
  2386.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2387.                             }
  2389.                             $unitsServ = $item->getUnits();
  2390.                             if (empty($unitsServ) or $unitsServ == "0") {
  2391.                                 $unitsServ = 1;
  2392.                             }
  2394.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2395.                             $subnetoUnit = $subneto;
  2396.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2398.                             $data_supplier['service'][$i] = array(
  2399.                                 'id' => $item->getId(),
  2400.                                 'serviceCatId' => $item->getServiceCatId(),
  2401.                                 'serviceName' => $item->getName(),
  2402.                                 'serviceType' => 'AV',
  2403.                                 'date' => $dateServ,
  2404.                                 'qty' => $unitsServ,
  2405.                                 'iva' => $item->getIva(),
  2406.                                 'pax' => $item->getPax(),
  2407.                                 'precioUnit' => $subnetoUnit,
  2408.                                 'subneto' => $subneto,
  2409.                                 'subtotal' => $subtotal,
  2410.                             );
  2411.                             break;
  2413.                         case 4: //Creative
  2414.                             $pax = $item->getPax();
  2415.                             if (empty($pax) or $pax == "0") {
  2416.                                 $pax = 1;
  2417.                             }
  2419.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2420.                             if ($days > 1) {
  2421.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2422.                             } else {
  2423.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2424.                             }
  2426.                             $unitsServ = $item->getUnits();
  2427.                             if (empty($unitsServ) or $unitsServ == "0") {
  2428.                                 $unitsServ = 1;
  2429.                             }
  2431.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2432.                             $subnetoUnit = $subneto;
  2433.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2435.                             $data_supplier['service'][$i] = array(
  2436.                                 'id' => $item->getId(),
  2437.                                 'serviceCatId' => $item->getServiceCatId(),
  2438.                                 'serviceName' => $item->getName(),
  2439.                                 'serviceType' => 'Creativo',
  2440.                                 'date' => $dateServ,
  2441.                                 'qty' => $unitsServ,
  2442.                                 'iva' => $item->getIva(),
  2443.                                 'pax' => $item->getPax(),
  2444.                                 'precioUnit' => $subnetoUnit,
  2445.                                 'subneto' => $subneto,
  2446.                                 'subtotal' => $subtotal,
  2447.                             );
  2448.                             break;
  2450.                         case 5: //Cruise
  2451.                             $pax = $item->getPax();
  2452.                             if (empty($pax) or $pax == "0") {
  2453.                                 $pax = 1;
  2454.                             }
  2456.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days);
  2457.                             if ($days > 1) {
  2458.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2459.                             } else {
  2460.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2461.                             }
  2463.                             $unitsServ = $item->getUnits();
  2464.                             if (empty($unitsServ) or $unitsServ == "0") {
  2465.                                 $unitsServ = 1;
  2466.                             }
  2468.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2469.                             $subnetoUnit = $subneto;
  2470.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2472.                             $data_supplier['service'][$i] = array(
  2473.                                 'id' => $item->getId(),
  2474.                                 'serviceCatId' => $item->getServiceCatId(),
  2475.                                 'serviceName' => $item->getName(),
  2476.                                 'serviceType' => 'Crucero',
  2477.                                 'date' => $dateServ,
  2478.                                 'qty' => $unitsServ,
  2479.                                 'iva' => $item->getIva(),
  2480.                                 'pax' => $item->getPax(),
  2481.                                 'precioUnit' => $subnetoUnit,
  2482.                                 'subneto' => $subneto,
  2483.                                 'subtotal' => $subtotal,
  2484.                             );
  2485.                             break;
  2487.                         case 6: //Entertaiment
  2488.                             $pax = $item->getPax();
  2489.                             if (empty($pax) or $pax == "0") {
  2490.                                 $pax = 1;
  2491.                             }
  2493.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2494.                             if ($days > 1) {
  2495.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2496.                             } else {
  2497.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2498.                             }
  2500.                             $unitsServ = $item->getUnits();
  2501.                             if (empty($unitsServ) or $unitsServ == "0") {
  2502.                                 $unitsServ = 1;
  2503.                             }
  2505.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2506.                             $subnetoUnit = $subneto;
  2507.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2509.                             $data_supplier['service'][$i] = array(
  2510.                                 'id' => $item->getId(),
  2511.                                 'serviceCatId' => $item->getServiceCatId(),
  2512.                                 'serviceName' => $item->getName(),
  2513.                                 'serviceType' => 'Entretenimiento',
  2514.                                 'date' => $dateServ,
  2515.                                 'qty' => $unitsServ,
  2516.                                 'iva' => $item->getIva(),
  2517.                                 'pax' => $item->getPax(),
  2518.                                 'precioUnit' => $subnetoUnit,
  2519.                                 'subneto' => $subneto,
  2520.                                 'subtotal' => $subtotal,
  2521.                             );
  2522.                             break;
  2524.                         case 7: // Gifts
  2525.                             $pax = $item->getPax();
  2526.                             if (empty($pax) or $pax == "0") {
  2527.                                 $pax = 1;
  2528.                             }
  2530. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2531.                             $days = 1;
  2532.                             if ($days > 1) {
  2533.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2534.                             } else {
  2535.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2536.                             }
  2538.                             $unitsServ = $item->getUnits();
  2539.                             if (empty($unitsServ) or $unitsServ == "0") {
  2540.                                 $unitsServ = 1;
  2541.                             }
  2543.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2544.                             $subnetoUnit = $subneto;
  2545.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2547.                             $data_supplier['service'][$i] = array(
  2548.                                 'id' => $item->getId(),
  2549.                                 'serviceCatId' => $item->getServiceCatId(),
  2550.                                 'serviceName' => $item->getName(),
  2551.                                 'serviceType' => 'Regalos',
  2552.                                 'date' => $dateServ,
  2553.                                 'qty' => $unitsServ,
  2554.                                 'iva' => $item->getIva(),
  2555.                                 'pax' => $item->getPax(),
  2556.                                 'precioUnit' => $subnetoUnit,
  2557.                                 'subneto' => $subneto,
  2558.                                 'subtotal' => $subtotal,
  2559.                             );
  2560.                             break;
  2562.                         case 8: //Guide
  2563.                             $pax = $item->getPax();
  2564.                             if (empty($pax) or $pax == "0") {
  2565.                                 $pax = 1;
  2566.                             }
  2568.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2569.                             if ($days > 1) {
  2570.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2571.                             } else {
  2572.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2573.                             }
  2575.                             $unitsServ = $item->getUnits();
  2576.                             if (empty($unitsServ) or $unitsServ == "0") {
  2577.                                 $unitsServ = 1;
  2578.                             }
  2580.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2581.                             $subnetoUnit = $subneto;
  2582.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2584.                             $data_supplier['service'][$i] = array(
  2585.                                 'id' => $item->getId(),
  2586.                                 'serviceCatId' => $item->getServiceCatId(),
  2587.                                 'serviceName' => $item->getName(),
  2588.                                 'serviceType' => 'Regalos',
  2589.                                 'date' => $dateServ,
  2590.                                 'qty' => $unitsServ,
  2591.                                 'iva' => $item->getIva(),
  2592.                                 'pax' => $item->getPax(),
  2593.                                 'precioUnit' => $subnetoUnit,
  2594.                                 'subneto' => $subneto,
  2595.                                 'subtotal' => $subtotal,
  2596.                             );
  2597.                             break;
  2599.                         case 9: //Itineraries
  2600.                             $pax = $item->getPax();
  2601.                             if (empty($pax) or $pax == "0") {
  2602.                                 $pax = 1;
  2603.                             }
  2605.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2606.                             if ($days > 1) {
  2607.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2608.                             } else {
  2609.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2610.                             }
  2612.                             $unitsServ = $item->getUnits();
  2613.                             if (empty($unitsServ) or $unitsServ == "0") {
  2614.                                 $unitsServ = 1;
  2615.                             }
  2617.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2618.                             $subnetoUnit = $subneto;
  2619.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2621.                             $data_supplier['service'][$i] = array(
  2622.                                 'id' => $item->getId(),
  2623.                                 'serviceCatId' => $item->getServiceCatId(),
  2624.                                 'serviceName' => $item->getName(),
  2625.                                 'serviceType' => 'Itinerarios',
  2626.                                 'date' => $dateServ,
  2627.                                 'qty' => $unitsServ,
  2628.                                 'iva' => $item->getIva(),
  2629.                                 'pax' => $item->getPax(),
  2630.                                 'precioUnit' => $subnetoUnit,
  2631.                                 'subneto' => $subneto,
  2632.                                 'subtotal' => $subtotal,
  2633.                             );
  2634.                             break;
  2636.                         case 10: //Lounge  -- No Aplica
  2637. //                        $pax = $item->getPax();
  2638. //                        if (empty($pax) or $pax == "0") {
  2639. //                            $pax = 1;
  2640. //                        }
  2641. //
  2642. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2643. //                        if ($days > 1){
  2644. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2645. //                        } else {
  2646. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2647. //                        }
  2648. //
  2649. //                        $unitsServ = $item->getUnits();
  2650. //                        if (empty($unitsServ) or $unitsServ == "0") {
  2651. //                            $unitsServ = 1;
  2652. //                        }
  2653. //
  2654. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2655. //                        $subnetoUnit = $subneto;
  2656. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  2657. //
  2658. //                        $data_supplier['service'][$i] = array (
  2659. //                            'id' => $item->getId(),
  2660. //                            'serviceCatId' => $item->getServiceCatId(),
  2661. //                            'serviceName' => $item->getName(),
  2662. //                            'serviceType' => 'Itinerarios',
  2663. //                            'date' => $dateServ,
  2664. //                            'qty' => $unitsServ,
  2665. //                            'iva' => $item->getIva(),
  2666. //                            'pax' => $item->getPax(),
  2667. //                            'precioUnit' => $subnetoUnit,
  2668. //                            'subneto' => $subneto,
  2669. //                            'subtotal' => $subtotal,
  2670. //                        );
  2671.                             break;
  2673.                         case 11: //Menu
  2674.                             $pax = $item->getPax();
  2675.                             if (empty($pax) or $pax == "0") {
  2676.                                 $pax = 1;
  2677.                             }
  2679.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2680.                             if ($days > 1) {
  2681.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2682.                             } else {
  2683.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2684.                             }
  2686.                             $unitsServ = $item->getUnits();
  2687.                             if (empty($unitsServ) or $unitsServ == "0") {
  2688.                                 $unitsServ = 1;
  2689.                             }
  2691.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2692.                             $subnetoUnit = $subneto;
  2693.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2695.                             $data_supplier['service'][$i] = array(
  2696.                                 'id' => $item->getId(),
  2697.                                 'serviceCatId' => $item->getServiceCatId(),
  2698.                                 'serviceName' => $item->getName(),
  2699.                                 'serviceType' => 'Menú',
  2700.                                 'date' => $dateServ,
  2701.                                 'qty' => $unitsServ,
  2702.                                 'iva' => $item->getIva(),
  2703.                                 'pax' => $item->getPax(),
  2704.                                 'precioUnit' => $subnetoUnit,
  2705.                                 'subneto' => $subneto,
  2706.                                 'subtotal' => $subtotal,
  2707.                             );
  2708.                             break;
  2710.                         case 12: //Others
  2711.                             $pax = $item->getPax();
  2712.                             if (empty($pax) or $pax == "0") {
  2713.                                 $pax = 1;
  2714.                             }
  2716.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2717.                             if ($days > 1) {
  2718.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2719.                             } else {
  2720.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2721.                             }
  2723.                             $unitsServ = $item->getUnits();
  2724.                             if (empty($unitsServ) or $unitsServ == "0") {
  2725.                                 $unitsServ = 1;
  2726.                             }
  2728.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2729.                             $subnetoUnit = $subneto;
  2730.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2732.                             $data_supplier['service'][$i] = array(
  2733.                                 'id' => $item->getId(),
  2734.                                 'serviceCatId' => $item->getServiceCatId(),
  2735.                                 'serviceName' => $item->getName(),
  2736.                                 'serviceType' => 'Otros',
  2737.                                 'date' => $dateServ,
  2738.                                 'qty' => $unitsServ,
  2739.                                 'iva' => $item->getIva(),
  2740.                                 'pax' => $item->getPax(),
  2741.                                 'precioUnit' => $subnetoUnit,
  2742.                                 'subneto' => $subneto,
  2743.                                 'subtotal' => $subtotal,
  2744.                             );
  2745.                             break;
  2747.                         case 13: //Transport
  2748.                             $pax = $item->getPax();
  2749.                             if (empty($pax) or $pax == "0") {
  2750.                                 $pax = 1;
  2751.                             }
  2753.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2754.                             if ($days > 1) {
  2755.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2756.                             } else {
  2757.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2758.                             }
  2760.                             $unitsServ = $item->getUnits();
  2761.                             if (empty($unitsServ) or $unitsServ == "0") {
  2762.                                 $unitsServ = 1;
  2763.                             }
  2765.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2766.                             $subnetoUnit = $subneto;
  2767.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2769.                             $data_supplier['service'][$i] = array(
  2770.                                 'id' => $item->getId(),
  2771.                                 'serviceCatId' => $item->getServiceCatId(),
  2772.                                 'serviceName' => $item->getName(),
  2773.                                 'serviceType' => 'Transporte',
  2774.                                 'date' => $dateServ,
  2775.                                 'qty' => $unitsServ,
  2776.                                 'iva' => $item->getIva(),
  2777.                                 'pax' => $item->getPax(),
  2778.                                 'precioUnit' => $subnetoUnit,
  2779.                                 'subneto' => $subneto,
  2780.                                 'subtotal' => $subtotal,
  2781.                             );
  2782.                             break;
  2784.                         case 14: //Technology
  2785.                             $pax = $item->getPax();
  2786.                             if (empty($pax) or $pax == "0") {
  2787.                                 $pax = 1;
  2788.                             }
  2790. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2791.                             $days = 1;
  2792. //                        if ($days > 1){
  2793. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2794. //                        } else {
  2795. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2796. //                        }
  2797.                             $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2799.                             $unitsServ = $item->getUnits();
  2800.                             if (empty($unitsServ) or $unitsServ == "0") {
  2801.                                 $unitsServ = 1;
  2802.                             }
  2804.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2805.                             $subnetoUnit = $subneto;
  2806.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2808.                             $data_supplier['service'][$i] = array(
  2809.                                 'id' => $item->getId(),
  2810.                                 'serviceCatId' => $item->getServiceCatId(),
  2811.                                 'serviceName' => $item->getName(),
  2812.                                 'serviceType' => 'Tecnología',
  2813.                                 'date' => $dateServ,
  2814.                                 'qty' => $unitsServ,
  2815.                                 'iva' => $item->getIva(),
  2816.                                 'pax' => $item->getPax(),
  2817.                                 'precioUnit' => $subnetoUnit,
  2818.                                 'subneto' => $subneto,
  2819.                                 'subtotal' => $subtotal,
  2820.                             );
  2821.                             break;
  2823.                         case 15: //Assisstant
  2824.                             $pax = $item->getPax();
  2825.                             if (empty($pax) or $pax == "0") {
  2826.                                 $pax = 1;
  2827.                             }
  2829.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2830.                             if ($days > 1) {
  2831.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2832.                             } else {
  2833.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2834.                             }
  2836.                             $unitsServ = $item->getUnits();
  2837.                             if (empty($unitsServ) or $unitsServ == "0") {
  2838.                                 $unitsServ = 1;
  2839.                             }
  2841.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2842.                             $subnetoUnit = $subneto;
  2843.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2845.                             $data_supplier['service'][$i] = array(
  2846.                                 'id' => $item->getId(),
  2847.                                 'serviceCatId' => $item->getServiceCatId(),
  2848.                                 'serviceName' => $item->getName(),
  2849.                                 'serviceType' => 'Asistente',
  2850.                                 'date' => $dateServ,
  2851.                                 'qty' => $unitsServ,
  2852.                                 'iva' => $item->getIva(),
  2853.                                 'pax' => $item->getPax(),
  2854.                                 'precioUnit' => $subnetoUnit,
  2855.                                 'subneto' => $subneto,
  2856.                                 'subtotal' => $subtotal,
  2857.                             );
  2858.                             break;
  2860.                         case 16: //DDR
  2861.                             $pax = $item->getPax();
  2862.                             if (empty($pax) or $pax == "0") {
  2863.                                 $pax = 1;
  2864.                             }
  2866.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2867.                             if ($days > 1) {
  2868.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2869.                             } else {
  2870.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2871.                             }
  2873.                             $unitsServ = $item->getUnits();
  2874.                             if (empty($unitsServ) or $unitsServ == "0") {
  2875.                                 $unitsServ = 1;
  2876.                             }
  2878.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2879.                             $subnetoUnit = $subneto;
  2880.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2882.                             $data_supplier['service'][$i] = array(
  2883.                                 'id' => $item->getId(),
  2884.                                 'serviceCatId' => $item->getServiceCatId(),
  2885.                                 'serviceName' => $item->getName(),
  2886.                                 'serviceType' => 'DDR',
  2887.                                 'date' => $dateServ,
  2888.                                 'qty' => $unitsServ,
  2889.                                 'iva' => $item->getIva(),
  2890.                                 'pax' => $item->getPax(),
  2891.                                 'precioUnit' => $subnetoUnit,
  2892.                                 'subneto' => $subneto,
  2893.                                 'subtotal' => $subtotal,
  2894.                             );
  2895.                             break;
  2897.                         default:
  2898.                             break;
  2899.                     }
  2901.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  2902.                     $subtotal = round($subtotal, 2, PHP_ROUND_HALF_UP);
  2903.                     $neto = round($subneto, 2, PHP_ROUND_HALF_UP);
  2905.                     $arrayItems[] = array(
  2906.                         'type' => 'Service',
  2907.                         'name' => $item->getName(),
  2908.                         'amount' => $neto,
  2909.                         'iva' => $item->getIva(),
  2910.                         'total' => $subtotal,
  2911.                     );
  2913.                 }
  2915.                 switch ($item->getIva()) {
  2916.                     // Acumula IVA
  2917.                     case 21:
  2918.                         $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getIva() / 100));
  2919.                         break;
  2921.                     case 10:
  2922.                         $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getIva() / 100));
  2923.                         break;
  2925.                     case 0:
  2926.                         break;
  2928.                     default:
  2929.                         break;
  2931.                 }
  2932.             }
  2934.             $totales_neto_all = $totales_neto_all + $neto;
  2936.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2937.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  2938.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  2939.             $data_iva['ivaMontoDiez'] = round($data_iva['ivaMontoDiez'],2,PHP_ROUND_HALF_UP);
  2940.             // Acumula netos totales e IVA
  2942.             $service['neto'] = $service['neto'] + $neto;
  2943.             $service['sumSubT'] = $service['sumSubT'] + $subtotal;
  2944.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2945.             $service['neto'] = round($service['neto'],2,PHP_ROUND_HALF_UP);
  2946.             $service['sumSubT'] = round($service['sumSubT'],2,PHP_ROUND_HALF_UP);
  2948.             $i++;
  2949.         }
  2951.         $data_supplier['serviceSubTotal'] = array(
  2952.             'neto' => $service['neto'],
  2953.             'sumSubT' => $service['sumSubT'],
  2954.         );
  2955.         $currency = '€';
  2956.         $totales_total = $totales_neto_all + $data_iva['ivaMontoVeintiUno'] + $data_iva['ivaMontoDiez'];
  2957.         if (!empty($payments)) {
  2958.             $amount_pay = $data_supplier['paymentSubTotal']['sumSubT'];
  2959.         } else {
  2960.             $amount_pay = 0;
  2961.         }
  2962.         $totales_all = $totales_total - $amount_pay;
  2964.         if (empty($dateDocument)){
  2965.             $dateDocument = new DateTime('now');
  2966.         }
  2968.         $data = array(
  2969.             'id' => $fileId,
  2970.             'type' => $type,
  2971. //            'type' => '',
  2972.             'number' => $number,
  2973. //            'prefix' => $prefix,
  2974.             'prefix' => 'AVE-'.(new DateTime('now'))->format('dmy').'-'.$invoiceId,
  2975.             'date' => $dateDocument,
  2976.             'file' => $file,
  2977.             'token' => $file->getAccessKey(),
  2978.             'company' => $company,
  2979.             'clients' => $client,
  2980.             'arrayItems' => $arrayItems,
  2981.             'datasupplier' => $data_supplier,
  2982.             'currency' => $currency,
  2983.             'totales_neto' => $totales_neto_all,
  2984.             'bases_imponibles' => $data_iva,
  2985.             'totales' => $totales_total,
  2986.             'balance' => $totales_all,
  2987.             'paymentInvoice' => $amount_pay,
  2988.         );
  2990.         return $data;
  2991.     }
  2993.     // Replicar cambios entre FileController y ProductsFilesController
  2994.     private function calculosFile($id, $arrayBools, $number, $type)
  2995.     {
  2996.         // $id Id del Expediente (File)
  2997.         // $arrayBool arreglo de logicos
  2998.         // $number  *********************
  2999.         // $type tipo de calculos a realizar (edicion de expediente, factura, factura de deposito, proforma)
  3002.         $em = $this->getDoctrine()->getManager();
  3003.         $file = $em->getRepository(AveFiles::class)->findOneById($id);
  3004. //        $items = $em->getRepository(AveProductFile::class)->findByFileId($file->getId());
  3006.         // Primero se agrupan por sala (Ubicacion), luego por tipo y finalmente por RankAv
  3007.         // Salvador Guerrero indico, el orden de los productos en la factura o proforma será (Video - Sonido - Iluminacion - Otros)
  3009.         $allProductFile = $em->getRepository(AveProductFile::class)->findByFileId($id);
  3010.         $arrayLocation = array();
  3011.         $arrayLocationWithNull = false;
  3012.         foreach ($allProductFile as $item){
  3013.             if (!empty($item->getLocation())){
  3014.                 $arrayLocation[$item->getLocation()] = $item->getLocation();
  3015.             } else {
  3016.                 $arrayLocationWithNull = true;
  3017.             }
  3018.         }
  3019.         if ($arrayLocationWithNull){ $arrayLocation['null'] = 'null'; }
  3021.         $productsInFile = array();
  3022.         $items = array();
  3024.         foreach ($arrayLocation as $item){
  3026.             // VIDEO
  3027.             $parameters = array(
  3028.                 'fileId' => $id,
  3029.                 'type' => 'Vídeo',
  3030.                 'location' => $item,
  3031.             );
  3032.             $dql = 'SELECT i
  3033.                     FROM AvexpressBundle:AveProductFile i
  3034.                     WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location
  3035.                     ORDER BY i.rankAv ASC';
  3036.             $query = $em->createQuery($dql)->setParameters($parameters);
  3037.             $productsInFileVid = $query->getResult();
  3039.             // SONIDO
  3040.             $parameters = array(
  3041.                 'fileId' => $id,
  3042.                 'type' => 'Sonido',
  3043.                 'location' => $item,
  3044.             );
  3045.             $dql = 'SELECT i
  3046.                     FROM AvexpressBundle:AveProductFile i
  3047.                     WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location
  3048.                     ORDER BY i.rankAv ASC';
  3049.             $query = $em->createQuery($dql)->setParameters($parameters);
  3050.             $productsInFileSound = $query->getResult();
  3052.             // ILUMINACION
  3053.             $parameters = array(
  3054.                 'fileId' => $id,
  3055.                 'type' => 'Iluminación',
  3056.                 'location' => $item,
  3057.             );
  3058.             $dql = 'SELECT i
  3059.                     FROM AvexpressBundle:AveProductFile i
  3060.                     WHERE i.fileId = :fileId AND i.type = :type AND i.location = :location
  3061.                     ORDER BY i.rankAv ASC';
  3062.             $query = $em->createQuery($dql)->setParameters($parameters);
  3063.             $productsInFileLights = $query->getResult();
  3065.             // OTROS
  3066.             $parameters = array(
  3067.                 'fileId' => $id,
  3068.                 'typeV' => 'Vídeo',
  3069.                 'typeS' => 'Sonido',
  3070.                 'typeI' => 'Iluminación',
  3071.                 'location' => $item,
  3072.             );
  3073.             $dql = 'SELECT i
  3074.                     FROM AvexpressBundle:AveProductFile i
  3075.                     WHERE (i.fileId = :fileId AND i.type != :typeV AND i.type != :typeS AND i.type != :typeI AND i.location = :location)
  3076.                     ORDER BY i.rankAv ASC';
  3077.             $query = $em->createQuery($dql)->setParameters($parameters);
  3078.             $productsInFileOther = $query->getResult();
  3080.             // CASO NULL (Los casos EMPTY estan considerados en las consultas previas)
  3081.             $parameters = array(
  3082.                 'fileId' => $id,
  3083.                 'location' => $item,
  3084.             );
  3085.             $dql = 'SELECT i
  3086.                     FROM AvexpressBundle:AveProductFile i
  3087.                     WHERE (i.fileId = :fileId AND i.type IS NULL AND i.location = :location)
  3088.                     ORDER BY i.rankAv ASC';
  3089.             $query = $em->createQuery($dql)->setParameters($parameters);
  3090.             $productsInFileNull = $query->getResult();
  3092.             // Para el location en NULL el SQL tiene que ser diferente por eso el siguiente condicional
  3093.             if ($item == 'null'){
  3095.                 // VIDEO
  3096.                 $parameters = array(
  3097.                     'fileId' => $id,
  3098.                     'type' => 'Vídeo',
  3099.                     'location' => '',
  3100.                 );
  3101.                 $dql = 'SELECT i
  3102.                         FROM AvexpressBundle:AveProductFile i
  3103.                         WHERE i.fileId = :fileId AND i.type = :type AND (i.location IS NULL OR i.location = :location)
  3104.                         ORDER BY i.rankAv ASC';
  3105.                 $query = $em->createQuery($dql)->setParameters($parameters);
  3106.                 $productsInFileVid = $query->getResult();
  3108.                 // SONIDO
  3109.                 $parameters = array(
  3110.                     'fileId' => $id,
  3111.                     'type' => 'Sonido',
  3112.                     'location' => '',
  3113.                 );
  3114.                 $dql = 'SELECT i
  3115.                         FROM AvexpressBundle:AveProductFile i
  3116.                         WHERE i.fileId = :fileId AND i.type = :type AND (i.location IS NULL OR i.location = :location) 
  3117.                         ORDER BY i.rankAv ASC';
  3118.                 $query = $em->createQuery($dql)->setParameters($parameters);
  3119.                 $productsInFileSound = $query->getResult();
  3121.                 // ILUMINACION
  3122.                 $parameters = array(
  3123.                     'fileId' => $id,
  3124.                     'type' => 'Iluminación',
  3125.                     'location' => '',
  3126.                 );
  3127.                 $dql = 'SELECT i
  3128.                         FROM AvexpressBundle:AveProductFile i
  3129.                         WHERE i.fileId = :fileId AND i.type = :type AND (i.location IS NULL OR i.location = :location)
  3130.                         ORDER BY i.rankAv ASC';
  3131.                 $query = $em->createQuery($dql)->setParameters($parameters);
  3132.                 $productsInFileLights = $query->getResult();
  3134.                 // OTROS
  3135.                 $parameters = array(
  3136.                     'fileId' => $id,
  3137.                     'typeV' => 'Vídeo',
  3138.                     'typeS' => 'Sonido',
  3139.                     'typeI' => 'Iluminación',
  3140.                     'location' => '',
  3141.                 );
  3142.                 $dql = 'SELECT i
  3143.                         FROM AvexpressBundle:AveProductFile i
  3144.                         WHERE (i.fileId = :fileId AND i.type != :typeV AND i.type != :typeS AND i.type != :typeI AND (i.location IS NULL OR i.location = :location))
  3145.                         ORDER BY i.rankAv ASC';
  3146.                 $query = $em->createQuery($dql)->setParameters($parameters);
  3147.                 $productsInFileOther = $query->getResult();
  3149.                 // CASO NULL DEL TIPO (Los casos EMPTY estan considerados en las consultas previas)
  3150.                 $parameters = array(
  3151.                     'fileId' => $id,
  3152.                     'location' => '',
  3153.                 );
  3154.                 $dql = 'SELECT i
  3155.                         FROM AvexpressBundle:AveProductFile i
  3156.                         WHERE (i.fileId = :fileId AND i.type IS NULL AND (i.location IS NULL OR i.location = :location))
  3157.                         ORDER BY i.rankAv ASC';
  3158.                 $query = $em->createQuery($dql)->setParameters($parameters);
  3159.                 $productsInFileNull = $query->getResult();
  3160.             }
  3162.             $items = array_merge($items,$productsInFileVid, $productsInFileSound, $productsInFileLights, $productsInFileOther, $productsInFileNull);
  3163.         }
  3165.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('4');
  3166.         $client = $em->getRepository(Client::class)->findById($file->getClient());
  3167.         if (!empty($client)){
  3168.             $city = ($em->getRepository(Cities::class)->findOneById($client[0]->getPopulation()));
  3169.             $client[0]->setPopulation($city);
  3170.             $region = ($em->getRepository(Regions::class)->findOneById($client[0]->getRegion()));
  3171.             $client[0]->setRegion($region);
  3172.             $country = ($em->getRepository(Country::class)->findOneById($client[0]->getCountry()));
  3173.             $client[0]->setCountry($country);
  3174.         } else {
  3175.             $client[0] = new Client();
  3176.             $client[0]->setName('');
  3177.             $client[0]->setTitle('');
  3178.             $client[0]->setIdDocument('');
  3179.             $client[0]->setPopulation('');
  3180.             $client[0]->setRegion('');
  3181.             $client[0]->setCountry('');
  3182.         }
  3184.         // Acumuladores de los calculos
  3185.         $totales_neto_all = 0;
  3186.         $data_iva = array(
  3187.             'iva' => 21,
  3188.             'ivaMontoVeintiUno' => 0,
  3189.             'ivaMontoDiez' => 0,
  3190.             'ivaMontoCero' => 0,
  3191.         );
  3193.         //INICIO: Determinamos el numero de factura o proforma
  3194.         if (substr($number,0,1) == 'I'){
  3195.             // Es una Factura
  3197.             $numberInvoiceOrProforma = substr($number,1);
  3198.             $number = $numberInvoiceOrProforma;
  3199.             $type = 'Invoice';
  3201.         } else {
  3202.             // Es una Proforma
  3204.             $numberInvoiceOrProforma = substr($number,1);
  3205.             $number = $numberInvoiceOrProforma;
  3206.             $type = 'Proforma';
  3207.         }
  3208.         //FIN: Determinamos el numero de factura o proforma
  3210.         // Buscamos las salas reservadas, pagos y servicios para el evento
  3212.         $arrayItems = array();
  3213.         $fileProducts = array();
  3214.         if (!empty($arrayBools['lounge'])) {
  3215.             foreach ($arrayBools['lounge'] as $key => $item) {
  3216.                 if ($item == 'true') {
  3217. //                    $fileProducts[] = $em->getRepository('DevelupBundle:ReservationLoungeSimple')->findOneById($key);
  3218.                 }
  3219.             }
  3220.         }
  3222.         $payments = array();
  3223.         if (!empty($arrayBools['payment'])) {
  3224.             foreach ($arrayBools['payment'] as $key => $item) {
  3225.                 if ($item == 'true') {
  3226. //                    $payments[] = $em->getRepository('DevelupBundle:ReservationPaymentsClient')->findOneById($key);
  3227.                 }
  3228.             }
  3229.         }
  3231.         $services = array();
  3232.         if (!empty($arrayBools['service'])) {
  3233.             foreach ($arrayBools['service'] as $key => $item) {
  3234.                 if ($item == 'true') {
  3235. //                    $services[] = $em->getRepository('DevelupBundle:ReservationService')->findOneById($key);
  3236.                 }
  3237.             }
  3238.         }
  3240.         $data_supplier = array();
  3241.         $i = 0;
  3243.         $iva = '21';            // Esteban Rincon: "Por Ley de localización del impuesto, siempre será un 21%"
  3244.         $pax = '-';
  3245.         $qty = '1';
  3247.         $product = array(
  3248.             'neto' => 0,
  3249.             'sumSubT' => 0,
  3250.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  3252.         $service = array(
  3253.             'neto' => 0,
  3254.             'sumSubT' => 0,
  3255.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  3257.         if (empty($items)){
  3258.             $data_supplier['product'][0] = null;
  3259.         }
  3261.         foreach ($items as $item){
  3262.             $days = '1';
  3264.             if (!empty($item->getUnits())){
  3265.                 $qty = $item->getUnits();
  3266.             }
  3268.             if (!empty($item->getDays())){
  3269.                 $days = $item->getDays();
  3270.             }
  3272.             if (is_null($item->getServicePrice()) or empty($item->getServicePrice())){
  3273.                 $subtotal = 0;
  3274.                 $neto = 0;
  3275.                 $subtotalProduct = 0;
  3276.             } else {
  3278. //                $subtotalProduct = $item->getServicePrice() * 1.21;
  3279.                 $subtotalProduct = $item->getSubTotalPrice() * 1.21;
  3280. //                $subneto = $item->getServicePrice();
  3281.                 $subneto = $item->getSubTotalPrice();
  3283.                 $subtotal =  $subtotalProduct;
  3284.                 $neto =  $subneto;
  3286.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  3287.                 $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  3288.                 $neto = round($neto,2,PHP_ROUND_HALF_UP);
  3290.                 $arrayItems[] = array(
  3291.                     'type' => 'Product',
  3292.                     'name' => $item->getProductName(),
  3293.                     'amount' => $neto,
  3294.                     'iva' => '21',
  3295.                     'total' => $subtotal,
  3296.                 );
  3297.             }
  3299.             // Acumula netos totales e IVA
  3300.             $totales_neto_all = $totales_neto_all + $neto;
  3301.             switch ($item->getIva()){
  3302.                 case 21: $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * 0.21); break;
  3303.                 case 10: $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * 0.1); break;
  3304.                 case 0: $data_iva['ivaMontoCero'] = $data_iva['ivaMontoCero'] + ($neto * 0); break;
  3305.                 default:  break;
  3306.             }
  3308.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  3309.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  3310.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  3311.             $data_iva['ivaMontoDiez'] = round($data_iva['ivaMontoDiez'],2,PHP_ROUND_HALF_UP);
  3312.             // Acumula netos totales e IVA
  3314.             $product['neto'] = $product['neto'] + $neto;
  3315.             $product['sumSubT'] = $product['sumSubT'] + $subtotal;
  3316.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  3317.             $product['neto'] = round($product['neto'],2,PHP_ROUND_HALF_UP);
  3318.             $product['sumSubT'] = round($product['sumSubT'],2,PHP_ROUND_HALF_UP);
  3320.             $data_supplier['product'][$i] = array (
  3321.                 'id' => $item->getId(),
  3322.                 'productName' => $item->getProductName(),
  3323.                 'description' => $item->getDescription(),
  3324.                 'productId' => $item->getProductId(),
  3325.                 'dateStart' => $item->getDateStart(),
  3326.                 'dateEnd' => $item->getDateEnd(),
  3327.                 'servicePrice' => $item->getServicePrice(),
  3328.                 'subTotalPrice' => $item->getSubTotalPrice(),
  3329.                 'subtotalProduct' => $subtotalProduct,
  3330.                 'iva' => $iva,
  3331.                 'pax' => $pax,
  3332.                 'qty' => $qty,
  3333.                 'days' => $days,
  3334.                 'type' => $item->getType(),
  3335.                 'subtotal' => $subtotal,
  3336.             );
  3337.             $i++;
  3338.         }
  3340.         $data_supplier['productSubTotal'] = array(
  3341.             'neto' => $product['neto'],
  3342.             'sumSubT' => $product['sumSubT'],
  3343.         );
  3345.         $payment = array(
  3346.             'sumSubT' => 0,
  3347.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  3349.         $i = 0;
  3350.         foreach ($payments as $item){
  3352.             $payment['sumSubT'] = $payment['sumSubT'] + $item->getAmountTotal();
  3353.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  3354.             $payment['sumSubT'] = round($payment['sumSubT'],2,PHP_ROUND_HALF_UP);
  3356.             $data_supplier['payment'][$i] = array (
  3357.                 'id' => $item->getId(),
  3358.                 'amount' => $item->getAmount(),
  3359.                 'amountTotal' => $item->getAmountTotal(),
  3360.                 'vat' => $item->getVat(),
  3361.                 'datePayAt' => $item->getDatePayAt(),
  3362.                 'wayToPay' => $item->getWayToPay(),
  3363.             );
  3365.             $arrayItems[] = array(
  3366.                 'type' => 'Payment',
  3367.                 'name' => $item->getWayToPay(),
  3368.                 'amount' => $item->getAmount(),
  3369.                 'total' => $item->getAmountTotal(),
  3370.                 'iva' => $item->getVat(),
  3371.             );
  3373.             $i++;
  3374.         }
  3376.         if (!empty($payments)) {
  3377.             $data_supplier['paymentSubTotal'] = array(
  3378.                 'sumSubT' => $payment['sumSubT'],
  3379.             );
  3380.         }
  3382.         foreach ($services as $item){
  3383.             if (is_null($item->getPrice()) or empty($item->getPrice())){
  3384.                 $subtotal = 0;
  3385.                 $neto = 0;
  3386.                 $subtotalService = 0;
  3388.             } else {
  3389.                 $subtotalService = $item->getPrice();
  3390.                 $subneto = $item->getPrice();
  3392.                 // Commission
  3393.                 if ($item->getOpCommission()=='1'){
  3394.                     $subtotalService = $subtotalService * (1 + ($item->getCommission()/100));
  3395.                     $subneto = $subneto  * (1 + ($item->getCommission()/100));
  3396.                 } else {
  3397.                     $subtotalService = $subtotalService * (1 - ($item->getCommission()/100));
  3398.                     $subneto = $subneto * (1 - ($item->getCommission()/100));
  3399.                 }
  3401.                 // Over
  3402.                 if ($item->getOpOver()=='1'){
  3403.                     $subtotalService = $subtotalService + $item->getOver();
  3404.                     $subneto = $subneto + $item->getOver();
  3405.                 } else {
  3406.                     $subtotalService = $subtotalService - $item->getOver();
  3407.                     $subneto = $subneto - $item->getOver();
  3408.                 }
  3410.                 // IVA
  3411.                 if ($item->getOpIva()=='1'){
  3412.                     $subtotalService = $subtotalService * (1 + ($item->getIva()/100));
  3413.                 } else {
  3414.                     $subtotalService = $item->getPrice();
  3415.                     $subneto = ($subneto * 100) / (100 + $item->getIva());
  3416.                 }
  3418.                 switch ($item->getServiceCatId()){
  3419.                     case 1: // Alojamiento
  3420.                         // el numero de noches $numNoches; precio unitario $subneto
  3421.                         $numNoches = (($item->getDateOutAt())->diff($item->getDateInAt()))->days;
  3422.                         // La personas no afectan este calculo
  3423.                         $subtotal = $subtotalService * $numNoches * $item->getUnits();
  3424.                         $subnetoUnit = $subneto;
  3426.                         $subneto = $subneto * $numNoches * $item->getUnits();
  3428.                         $data_supplier['service'][$i] = array (
  3429.                             'id' => $item->getId(),
  3430.                             'serviceCatId' => $item->getServiceCatId(),
  3431.                             'serviceName' => $item->getName(),
  3432.                             'serviceType' => 'Hotel',
  3433.                             'date' => ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y'),
  3434.                             'qty' => $item->getUnits(),
  3435.                             'iva' => $item->getIva(),
  3436.                             'pax' => '-',
  3437.                             'precioUnit' => $subnetoUnit,
  3438.                             'subneto' => $subneto,
  3439.                             'subtotal' => $subtotal,
  3440.                         );
  3441.                         break;
  3443.                     case 2: //Actividades
  3444.                         // El número de personas es considerado en el calculo
  3445.                         $pax = $item->getPax();
  3446.                         if (empty($pax) or $pax == "0") {
  3447.                             $pax = 1;
  3448.                         }
  3449.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3451.                         if ($days > 1){
  3452.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3453.                         } else {
  3454.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3455.                         }
  3457.                         $subtotal = $subtotalService * $days * $item->getUnits();
  3458.                         $subnetoUnit = $subneto;
  3459.                         $subneto = $subneto * $days * $item->getUnits();
  3461.                         $data_supplier['service'][$i] = array (
  3462.                             'id' => $item->getId(),
  3463.                             'serviceCatId' => $item->getServiceCatId(),
  3464.                             'serviceName' => $item->getName(),
  3465.                             'serviceType' => 'Actividad',
  3466.                             'date' => $dateServ,
  3467.                             'qty' => $item->getUnits(),
  3468.                             'iva' => $item->getIva(),
  3469.                             'pax' => $item->getPax(),
  3470.                             'precioUnit' => $subnetoUnit,
  3471.                             'subneto' => $subneto,
  3472.                             'subtotal' => $subtotal,
  3473.                         );
  3474.                         break;
  3476.                     case 3: // AV
  3477.                         $pax = $item->getPax();
  3478.                         if (empty($pax) or $pax == "0") {
  3479.                             $pax = 1;
  3480.                         }
  3482.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3483.                         if ($days > 1){
  3484.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3485.                         } else {
  3486.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3487.                         }
  3489.                         $unitsServ = $item->getUnits();
  3490.                         if (empty($unitsServ) or $unitsServ == "0") {
  3491.                             $unitsServ = 1;
  3492.                         }
  3494.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3495.                         $subnetoUnit = $subneto;
  3496.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3498.                         $data_supplier['service'][$i] = array (
  3499.                             'id' => $item->getId(),
  3500.                             'serviceCatId' => $item->getServiceCatId(),
  3501.                             'serviceName' => $item->getName(),
  3502.                             'serviceType' => 'AV',
  3503.                             'date' => $dateServ,
  3504.                             'qty' => $unitsServ,
  3505.                             'iva' => $item->getIva(),
  3506.                             'pax' => $item->getPax(),
  3507.                             'precioUnit' => $subnetoUnit,
  3508.                             'subneto' => $subneto,
  3509.                             'subtotal' => $subtotal,
  3510.                         );
  3511.                         break;
  3513.                     case 4: //Creative
  3514.                         $pax = $item->getPax();
  3515.                         if (empty($pax) or $pax == "0") {
  3516.                             $pax = 1;
  3517.                         }
  3519.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3520.                         if ($days > 1){
  3521.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3522.                         } else {
  3523.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3524.                         }
  3526.                         $unitsServ = $item->getUnits();
  3527.                         if (empty($unitsServ) or $unitsServ == "0") {
  3528.                             $unitsServ = 1;
  3529.                         }
  3531.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3532.                         $subnetoUnit = $subneto;
  3533.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3535.                         $data_supplier['service'][$i] = array (
  3536.                             'id' => $item->getId(),
  3537.                             'serviceCatId' => $item->getServiceCatId(),
  3538.                             'serviceName' => $item->getName(),
  3539.                             'serviceType' => 'Creativo',
  3540.                             'date' => $dateServ,
  3541.                             'qty' => $unitsServ,
  3542.                             'iva' => $item->getIva(),
  3543.                             'pax' => $item->getPax(),
  3544.                             'precioUnit' => $subnetoUnit,
  3545.                             'subneto' => $subneto,
  3546.                             'subtotal' => $subtotal,
  3547.                         );
  3548.                         break;
  3550.                     case 5: //Cruise
  3551.                         $pax = $item->getPax();
  3552.                         if (empty($pax) or $pax == "0") {
  3553.                             $pax = 1;
  3554.                         }
  3556.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days);
  3557.                         if ($days > 1){
  3558.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3559.                         } else {
  3560.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3561.                         }
  3563.                         $unitsServ = $item->getUnits();
  3564.                         if (empty($unitsServ) or $unitsServ == "0") {
  3565.                             $unitsServ = 1;
  3566.                         }
  3568.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3569.                         $subnetoUnit = $subneto;
  3570.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3572.                         $data_supplier['service'][$i] = array (
  3573.                             'id' => $item->getId(),
  3574.                             'serviceCatId' => $item->getServiceCatId(),
  3575.                             'serviceName' => $item->getName(),
  3576.                             'serviceType' => 'Crucero',
  3577.                             'date' => $dateServ,
  3578.                             'qty' => $unitsServ,
  3579.                             'iva' => $item->getIva(),
  3580.                             'pax' => $item->getPax(),
  3581.                             'precioUnit' => $subnetoUnit,
  3582.                             'subneto' => $subneto,
  3583.                             'subtotal' => $subtotal,
  3584.                         );
  3585.                         break;
  3587.                     case 6: //Entertaiment
  3588.                         $pax = $item->getPax();
  3589.                         if (empty($pax) or $pax == "0") {
  3590.                             $pax = 1;
  3591.                         }
  3593.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3594.                         if ($days > 1){
  3595.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3596.                         } else {
  3597.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3598.                         }
  3600.                         $unitsServ = $item->getUnits();
  3601.                         if (empty($unitsServ) or $unitsServ == "0") {
  3602.                             $unitsServ = 1;
  3603.                         }
  3605.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3606.                         $subnetoUnit = $subneto;
  3607.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3609.                         $data_supplier['service'][$i] = array (
  3610.                             'id' => $item->getId(),
  3611.                             'serviceCatId' => $item->getServiceCatId(),
  3612.                             'serviceName' => $item->getName(),
  3613.                             'serviceType' => 'Entretenimiento',
  3614.                             'date' => $dateServ,
  3615.                             'qty' => $unitsServ,
  3616.                             'iva' => $item->getIva(),
  3617.                             'pax' => $item->getPax(),
  3618.                             'precioUnit' => $subnetoUnit,
  3619.                             'subneto' => $subneto,
  3620.                             'subtotal' => $subtotal,
  3621.                         );
  3622.                         break;
  3624.                     case 7: // Gifts
  3625.                         $pax = $item->getPax();
  3626.                         if (empty($pax) or $pax == "0") {
  3627.                             $pax = 1;
  3628.                         }
  3630. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3631.                         $days = 1;
  3632.                         if ($days > 1){
  3633.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3634.                         } else {
  3635.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3636.                         }
  3638.                         $unitsServ = $item->getUnits();
  3639.                         if (empty($unitsServ) or $unitsServ == "0") {
  3640.                             $unitsServ = 1;
  3641.                         }
  3643.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3644.                         $subnetoUnit = $subneto;
  3645.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3647.                         $data_supplier['service'][$i] = array (
  3648.                             'id' => $item->getId(),
  3649.                             'serviceCatId' => $item->getServiceCatId(),
  3650.                             'serviceName' => $item->getName(),
  3651.                             'serviceType' => 'Regalos',
  3652.                             'date' => $dateServ,
  3653.                             'qty' => $unitsServ,
  3654.                             'iva' => $item->getIva(),
  3655.                             'pax' => $item->getPax(),
  3656.                             'precioUnit' => $subnetoUnit,
  3657.                             'subneto' => $subneto,
  3658.                             'subtotal' => $subtotal,
  3659.                         );
  3660.                         break;
  3662.                     case 8: //Guide
  3663.                         $pax = $item->getPax();
  3664.                         if (empty($pax) or $pax == "0") {
  3665.                             $pax = 1;
  3666.                         }
  3668.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3669.                         if ($days > 1){
  3670.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3671.                         } else {
  3672.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3673.                         }
  3675.                         $unitsServ = $item->getUnits();
  3676.                         if (empty($unitsServ) or $unitsServ == "0") {
  3677.                             $unitsServ = 1;
  3678.                         }
  3680.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3681.                         $subnetoUnit = $subneto;
  3682.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3684.                         $data_supplier['service'][$i] = array (
  3685.                             'id' => $item->getId(),
  3686.                             'serviceCatId' => $item->getServiceCatId(),
  3687.                             'serviceName' => $item->getName(),
  3688.                             'serviceType' => 'Regalos',
  3689.                             'date' => $dateServ,
  3690.                             'qty' => $unitsServ,
  3691.                             'iva' => $item->getIva(),
  3692.                             'pax' => $item->getPax(),
  3693.                             'precioUnit' => $subnetoUnit,
  3694.                             'subneto' => $subneto,
  3695.                             'subtotal' => $subtotal,
  3696.                         );
  3697.                         break;
  3699.                     case 9: //Itineraries
  3700.                         $pax = $item->getPax();
  3701.                         if (empty($pax) or $pax == "0") {
  3702.                             $pax = 1;
  3703.                         }
  3705.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3706.                         if ($days > 1){
  3707.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3708.                         } else {
  3709.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3710.                         }
  3712.                         $unitsServ = $item->getUnits();
  3713.                         if (empty($unitsServ) or $unitsServ == "0") {
  3714.                             $unitsServ = 1;
  3715.                         }
  3717.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3718.                         $subnetoUnit = $subneto;
  3719.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3721.                         $data_supplier['service'][$i] = array (
  3722.                             'id' => $item->getId(),
  3723.                             'serviceCatId' => $item->getServiceCatId(),
  3724.                             'serviceName' => $item->getName(),
  3725.                             'serviceType' => 'Itinerarios',
  3726.                             'date' => $dateServ,
  3727.                             'qty' => $unitsServ,
  3728.                             'iva' => $item->getIva(),
  3729.                             'pax' => $item->getPax(),
  3730.                             'precioUnit' => $subnetoUnit,
  3731.                             'subneto' => $subneto,
  3732.                             'subtotal' => $subtotal,
  3733.                         );
  3734.                         break;
  3736.                     case 10: //Lounge  -- No Aplica
  3737. //                        $pax = $item->getPax();
  3738. //                        if (empty($pax) or $pax == "0") {
  3739. //                            $pax = 1;
  3740. //                        }
  3741. //
  3742. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3743. //                        if ($days > 1){
  3744. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3745. //                        } else {
  3746. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3747. //                        }
  3748. //
  3749. //                        $unitsServ = $item->getUnits();
  3750. //                        if (empty($unitsServ) or $unitsServ == "0") {
  3751. //                            $unitsServ = 1;
  3752. //                        }
  3753. //
  3754. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3755. //                        $subnetoUnit = $subneto;
  3756. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  3757. //
  3758. //                        $data_supplier['service'][$i] = array (
  3759. //                            'id' => $item->getId(),
  3760. //                            'serviceCatId' => $item->getServiceCatId(),
  3761. //                            'serviceName' => $item->getName(),
  3762. //                            'serviceType' => 'Itinerarios',
  3763. //                            'date' => $dateServ,
  3764. //                            'qty' => $unitsServ,
  3765. //                            'iva' => $item->getIva(),
  3766. //                            'pax' => $item->getPax(),
  3767. //                            'precioUnit' => $subnetoUnit,
  3768. //                            'subneto' => $subneto,
  3769. //                            'subtotal' => $subtotal,
  3770. //                        );
  3771.                         break;
  3773.                     case 11: //Menu
  3774.                         $pax = $item->getPax();
  3775.                         if (empty($pax) or $pax == "0") {
  3776.                             $pax = 1;
  3777.                         }
  3779.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3780.                         if ($days > 1){
  3781.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3782.                         } else {
  3783.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3784.                         }
  3786.                         $unitsServ = $item->getUnits();
  3787.                         if (empty($unitsServ) or $unitsServ == "0") {
  3788.                             $unitsServ = 1;
  3789.                         }
  3791.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3792.                         $subnetoUnit = $subneto;
  3793.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3795.                         $data_supplier['service'][$i] = array (
  3796.                             'id' => $item->getId(),
  3797.                             'serviceCatId' => $item->getServiceCatId(),
  3798.                             'serviceName' => $item->getName(),
  3799.                             'serviceType' => 'Menú',
  3800.                             'date' => $dateServ,
  3801.                             'qty' => $unitsServ,
  3802.                             'iva' => $item->getIva(),
  3803.                             'pax' => $item->getPax(),
  3804.                             'precioUnit' => $subnetoUnit,
  3805.                             'subneto' => $subneto,
  3806.                             'subtotal' => $subtotal,
  3807.                         );
  3808.                         break;
  3810.                     case 12: //Others
  3811.                         $pax = $item->getPax();
  3812.                         if (empty($pax) or $pax == "0") {
  3813.                             $pax = 1;
  3814.                         }
  3816.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3817.                         if ($days > 1){
  3818.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3819.                         } else {
  3820.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3821.                         }
  3823.                         $unitsServ = $item->getUnits();
  3824.                         if (empty($unitsServ) or $unitsServ == "0") {
  3825.                             $unitsServ = 1;
  3826.                         }
  3828.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3829.                         $subnetoUnit = $subneto;
  3830.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3832.                         $data_supplier['service'][$i] = array (
  3833.                             'id' => $item->getId(),
  3834.                             'serviceCatId' => $item->getServiceCatId(),
  3835.                             'serviceName' => $item->getName(),
  3836.                             'serviceType' => 'Otros',
  3837.                             'date' => $dateServ,
  3838.                             'qty' => $unitsServ,
  3839.                             'iva' => $item->getIva(),
  3840.                             'pax' => $item->getPax(),
  3841.                             'precioUnit' => $subnetoUnit,
  3842.                             'subneto' => $subneto,
  3843.                             'subtotal' => $subtotal,
  3844.                         );
  3845.                         break;
  3847.                     case 13: //Transport
  3848.                         $pax = $item->getPax();
  3849.                         if (empty($pax) or $pax == "0") {
  3850.                             $pax = 1;
  3851.                         }
  3853.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3854.                         if ($days > 1){
  3855.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3856.                         } else {
  3857.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3858.                         }
  3860.                         $unitsServ = $item->getUnits();
  3861.                         if (empty($unitsServ) or $unitsServ == "0") {
  3862.                             $unitsServ = 1;
  3863.                         }
  3865.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3866.                         $subnetoUnit = $subneto;
  3867.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3869.                         $data_supplier['service'][$i] = array (
  3870.                             'id' => $item->getId(),
  3871.                             'serviceCatId' => $item->getServiceCatId(),
  3872.                             'serviceName' => $item->getName(),
  3873.                             'serviceType' => 'Transporte',
  3874.                             'date' => $dateServ,
  3875.                             'qty' => $unitsServ,
  3876.                             'iva' => $item->getIva(),
  3877.                             'pax' => $item->getPax(),
  3878.                             'precioUnit' => $subnetoUnit,
  3879.                             'subneto' => $subneto,
  3880.                             'subtotal' => $subtotal,
  3881.                         );
  3882.                         break;
  3884.                     case 14: //Technology
  3885.                         $pax = $item->getPax();
  3886.                         if (empty($pax) or $pax == "0") {
  3887.                             $pax = 1;
  3888.                         }
  3890. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3891.                         $days = 1;
  3892. //                        if ($days > 1){
  3893. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3894. //                        } else {
  3895. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3896. //                        }
  3897.                         $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3899.                         $unitsServ = $item->getUnits();
  3900.                         if (empty($unitsServ) or $unitsServ == "0") {
  3901.                             $unitsServ = 1;
  3902.                         }
  3904.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3905.                         $subnetoUnit = $subneto;
  3906.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3908.                         $data_supplier['service'][$i] = array (
  3909.                             'id' => $item->getId(),
  3910.                             'serviceCatId' => $item->getServiceCatId(),
  3911.                             'serviceName' => $item->getName(),
  3912.                             'serviceType' => 'Tecnología',
  3913.                             'date' => $dateServ,
  3914.                             'qty' => $unitsServ,
  3915.                             'iva' => $item->getIva(),
  3916.                             'pax' => $item->getPax(),
  3917.                             'precioUnit' => $subnetoUnit,
  3918.                             'subneto' => $subneto,
  3919.                             'subtotal' => $subtotal,
  3920.                         );
  3921.                         break;
  3923.                     case 15: //Assisstant
  3924.                         $pax = $item->getPax();
  3925.                         if (empty($pax) or $pax == "0") {
  3926.                             $pax = 1;
  3927.                         }
  3929.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3930.                         if ($days > 1){
  3931.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3932.                         } else {
  3933.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3934.                         }
  3936.                         $unitsServ = $item->getUnits();
  3937.                         if (empty($unitsServ) or $unitsServ == "0") {
  3938.                             $unitsServ = 1;
  3939.                         }
  3941.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3942.                         $subnetoUnit = $subneto;
  3943.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3945.                         $data_supplier['service'][$i] = array (
  3946.                             'id' => $item->getId(),
  3947.                             'serviceCatId' => $item->getServiceCatId(),
  3948.                             'serviceName' => $item->getName(),
  3949.                             'serviceType' => 'Asistente',
  3950.                             'date' => $dateServ,
  3951.                             'qty' => $unitsServ,
  3952.                             'iva' => $item->getIva(),
  3953.                             'pax' => $item->getPax(),
  3954.                             'precioUnit' => $subnetoUnit,
  3955.                             'subneto' => $subneto,
  3956.                             'subtotal' => $subtotal,
  3957.                         );
  3958.                         break;
  3960.                     case 16: //DDR
  3961.                         $pax = $item->getPax();
  3962.                         if (empty($pax) or $pax == "0") {
  3963.                             $pax = 1;
  3964.                         }
  3966.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3967.                         if ($days > 1){
  3968.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3969.                         } else {
  3970.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3971.                         }
  3973.                         $unitsServ = $item->getUnits();
  3974.                         if (empty($unitsServ) or $unitsServ == "0") {
  3975.                             $unitsServ = 1;
  3976.                         }
  3978.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3979.                         $subnetoUnit = $subneto;
  3980.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3982.                         $data_supplier['service'][$i] = array (
  3983.                             'id' => $item->getId(),
  3984.                             'serviceCatId' => $item->getServiceCatId(),
  3985.                             'serviceName' => $item->getName(),
  3986.                             'serviceType' => 'DDR',
  3987.                             'date' => $dateServ,
  3988.                             'qty' => $unitsServ,
  3989.                             'iva' => $item->getIva(),
  3990.                             'pax' => $item->getPax(),
  3991.                             'precioUnit' => $subnetoUnit,
  3992.                             'subneto' => $subneto,
  3993.                             'subtotal' => $subtotal,
  3994.                         );
  3995.                         break;
  3997.                     default:
  3998.                         break;
  3999.                 }
  4001.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  4002.                 $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  4003.                 $neto = round($subneto,2,PHP_ROUND_HALF_UP);
  4005.                 $arrayItems[] = array(
  4006.                     'type' => 'Service',
  4007.                     'name' => $item->getName(),
  4008.                     'amount' => $neto,
  4009.                     'iva' => $item->getIva(),
  4010.                     'total' => $subtotal,
  4011.                 );
  4012.             }
  4014.             switch ($item->getIva()){
  4015.                 // Acumula IVA
  4016.                 case 21:
  4017.                     $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getIva()/100));
  4018.                     break;
  4020.                 case 10:
  4021.                     $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getIva()/100));
  4022.                     break;
  4024.                 case 0:
  4025.                     break;
  4027.                 default:
  4028.                     break;
  4030.             }
  4032.             $totales_neto_all = $totales_neto_all + $neto;
  4034.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  4035.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  4036.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  4037.             $data_iva['ivaMontoDiez'] = round($data_iva['ivaMontoDiez'],2,PHP_ROUND_HALF_UP);
  4038.             // Acumula netos totales e IVA
  4040.             $service['neto'] = $service['neto'] + $neto;
  4041.             $service['sumSubT'] = $service['sumSubT'] + $subtotal;
  4042.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  4043.             $service['neto'] = round($service['neto'],2,PHP_ROUND_HALF_UP);
  4044.             $service['sumSubT'] = round($service['sumSubT'],2,PHP_ROUND_HALF_UP);
  4046.             $i++;
  4047.         }
  4049.         $data_supplier['serviceSubTotal'] = array(
  4050.             'neto' => $service['neto'],
  4051.             'sumSubT' => $service['sumSubT'],
  4052.         );
  4053.         $currency = '€';
  4054.         $totales_total = $totales_neto_all + $data_iva['ivaMontoVeintiUno'] + $data_iva['ivaMontoDiez'];
  4055.         if (!empty($payments)) {
  4056.             $amount_pay = $data_supplier['paymentSubTotal']['sumSubT'];
  4057.         } else {
  4058.             $amount_pay = 0;
  4059.         }
  4060.         $totales_all = $totales_total - $amount_pay;
  4062.         if ($type == 'Invoice'){
  4063.             $em->clear();   // sin este clear se producia error al guardar
  4064.             $newInvoice = $em->getRepository(AveDocInvoice::class)->findOneById($numberInvoiceOrProforma);
  4065.             $newInvoice->setBalance($totales_all);
  4066.             $em->persist($newInvoice);
  4067.             $em->flush();
  4068.         }
  4070.         $data = array(
  4071.             'id' => $id,
  4072.             'type' => $type,
  4073.             'number' => $number,
  4074.             'prefix' => 'AVE-'.(new DateTime('now'))->format('dmy').'-',
  4075.             'date' => new DateTime('now'),
  4076.             'file' => $file,
  4077.             'company' => $company,
  4078.             'clients' => $client,
  4079.             'arrayItems' => $arrayItems,
  4080.             'datasupplier' => $data_supplier,
  4081.             'currency' => $currency,
  4082.             'totales_neto' => $totales_neto_all,
  4083.             'bases_imponibles' => $data_iva,
  4084.             'totales' => $totales_total,
  4085.             'balance' => $totales_all,
  4086.             'paymentInvoice' => $amount_pay,
  4087.         );
  4089.         return $data;
  4090.     }
  4092.     private function sendTelegram($id, $text )
  4093.     {
  4094.         $em = $this->getDoctrine()->getManager();
  4095.         // No es necesario tener una tabla de TelegramUser para el modulo de AvExpress
  4096.         $telegUser = $em->getRepository(MdvTelegramUser::class)->findOneByUserId($id);
  4098.         if (empty($telegUser)){return true;}
  4100.         $parameters = array(
  4101.             'chat_id' => $telegUser->getChatId(),
  4102.             'text' => $text,
  4103.         );
  4105.         $bot_token = $telegUser->getBotToken();
  4106.         $url = "https://api.telegram.org/bot$bot_token/sendMessage";
  4108.         if (!$curl = curl_init()){
  4109.             exit();
  4110.         }
  4112.         curl_setopt($curl,CURLOPT_POST,true);
  4113.         curl_setopt($curl,CURLOPT_POSTFIELDS,$parameters);
  4114.         curl_setopt($curl,CURLOPT_URL,$url);
  4115.         curl_setopt($curl,CURLOPT_RETURNTRANSFER,true);
  4116.         $output = curl_exec($curl);
  4117.         curl_close($curl);
  4119.         return true;
  4120.     }
  4122.     private function baseBenefits($fileId){
  4123.         $em = $this->getDoctrine()->getManager();
  4124. //        $file = $em->getRepository(AveFiles::class)->findOneById($fileId);
  4125.         $productsInFile = $em->getRepository(AveProductFile::class)->findByFileId($fileId);
  4127.         $benefitEuro = 0;
  4128.         $benefitPerc = 0;
  4129.         $totalSale = 0;
  4131.         foreach ($productsInFile as $item){
  4132.             if(empty($item->getSupplierExt()) or ($item->getSupplierExt() == 'AV EXPRESS S.L.')){
  4133.                 // El proveedor es AV, el beneficio es 100%
  4134.                 $benefitEuro = $benefitEuro + $item->getSubTotalPrice();
  4136.             } else {
  4137.                 // El proveedor es externo, el beneficio lo determinan el over y la comision
  4138. //                $subTotalPriceExt = $item->getServicePrice() * $item->getUnits() * $item->getDays();        // Precio sin Over ni Comision
  4139. //                $benefitEuro = $benefitEuro + ($item->getSubTotalPrice() - $subTotalPriceExt);
  4141.                 $prdPrice = $item->getServicePrice(); if (empty($prdPrice)){ $prdPrice = 0; }
  4142.                 $prdUnits = $item->getUnits(); if (empty($prdUnits)){ $prdUnits = 1; }
  4143.                 $prdDays = $item->getDays(); if (empty($prdDays)){ $prdDays = 1; }
  4144.                 $prdPax = $item->getPax(); if (empty($prdPax)){ $prdPax = 1; }
  4145.                 $subTotalPriceExt = $prdPrice * $prdUnits * $prdDays * $prdPax;                             // Precio sin Over ni Comision
  4146.                 $benefitEuro = $benefitEuro + ($item->getSubTotalPrice() - $subTotalPriceExt);
  4149.             }
  4150.             $totalSale = $totalSale + $item->getSubTotalPrice();
  4151.         }
  4153.         // Verificamos beneficios simplificados de proveedores
  4154.         $simplyBen = $em->getRepository(AveBenefitsSupplier::class)->findByFileId($fileId);
  4155.         foreach ($simplyBen as $item){ $benefitEuro = $benefitEuro - $item->getBenefitSupplier(); }
  4157.         if (!($totalSale == 0)){
  4158.             $benefitPerc = ($benefitEuro * 100)/$totalSale;
  4159.         }
  4161.         $data = array(
  4162.             'id' => $fileId,
  4163.             'benefitEuro' => $benefitEuro,
  4164.             'benefitPerc' => $benefitPerc,
  4165.         );
  4167.         return $data;
  4169.     }
  4171.     private function precioPorVariacionDeDias ($supplierService, $productFile){
  4172.         // El precio unitario debe ser dividido en funcion de los dias que tiene InOut y no en funcion de los dias de Av Express
  4173.         $days = ($supplierService->getDateOutAt()->diff($supplierService->getDateInAt())->days)===0 ? 1 : $supplierService->getDateOutAt()->diff($supplierService->getDateInAt())->days +1;
  4174.         $newPrice = $productFile->getSubTotalPrice() / ( $days );
  4175.         $newPrice = $newPrice / $supplierService->getUnits();
  4176.         $newPrice = round($newPrice,2,PHP_ROUND_HALF_UP);
  4178.         return $newPrice;
  4179.     }
  4181.     private function rankAvParaInOutService($idProduct){
  4182.         // 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
  4183.         // luego si es vacio repetimos para proformas en "ave_doc_proforma_items"
  4184.         // Devuelve el numero de RankAv considerando la posible asociacion por sala y ordenando segun el criterio (video, sonido, iluminacion, otros)
  4185.         $em = $this->getDoctrine()->getManager();
  4186.         $rankAv = 1; $proformaItemsInSameProforma = array(); $boolFound = false;
  4187.         $invoiceItem = $em->getRepository(AveDocInvoiceItems::class)->findOneByPrdControlId($idProduct);
  4188.         $invoiceItemsInSameInvoice = (!empty($invoiceItem)) ? $em->getRepository(AveDocInvoiceItems::class)->findByInvoiceId($invoiceItem->getInvoiceId()) : array();
  4190.         if (empty($invoiceItemsInSameInvoice)){
  4191.             // No se encontraba facturado, buscamos en proforma el item y los elementos que esten en esa proforma
  4192.             $proformaItem = $em->getRepository(AveDocProformaItems::class)->findOneByControlId($idProduct);
  4193.             $proformaItemsInSameProforma = (!empty($proformaItem)) ? $em->getRepository(AveDocProformaItems::class)->findByProformaId($proformaItem->getProformaId()) : array();
  4194.         }
  4196.         $arrayItems = empty($invoiceItemsInSameInvoice) ? $proformaItemsInSameProforma : $invoiceItemsInSameInvoice;
  4197.         foreach ($arrayItems as $item){
  4198.             $idToCheck = empty($invoiceItemsInSameInvoice) ? $item->getControlId() : $item->getPrdControlId();
  4199.             if (!($idToCheck == $idProduct)){ if(!($boolFound)){ $rankAv++;} } else { $boolFound = true; }
  4200.         }
  4202.         // 001, 002, ... 010, 011, ..., 100, 101
  4203.         $rankAv = ($rankAv < 100) ? (($rankAv < 10) ? '00'. $rankAv : '0'. $rankAv) : $rankAv;
  4205.         return $rankAv;
  4206.     }
  4208.     private function messageOfChangesToAgent($message, $proposalId){
  4209.         // $message mensaje a enviar a los agentes del proposal
  4210.         if ($proposalId  == 0){ return true; }
  4211.         $em = $this->getDoctrine()->getManager();
  4212.         $proposal = $em->getRepository(Proposal::class)->findOneById($proposalId);
  4214.         /* Obtengo usuario logueado */
  4215.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  4216.         $user_id = $user_logueado->getId();
  4217.         $agent = $em->getRepository(User::class)->findOneById($user_id);
  4219.         $message = 'El proposal <strong>#'.$proposalId.' '.$proposal->getName().'</strong>'.' ha sido modificacdo por el agente: '.$agent->getName().' '.$agent->getLastName().'<br><br><br>'.$message;
  4220.         $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposalId);
  4221.         $mailArrayTo = array();
  4222.         if (!empty($agent)){ $mailArrayTo[$agent->getEmail()] = $agent->getEmail(); }
  4223.         if (!empty($proposalAgents)){
  4224.             if (!empty($proposalAgents->getAgOne())){
  4225.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgOne());
  4226.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  4227.             }
  4229.             if (!empty($proposalAgents->getAgTwo())){
  4230.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgTwo());
  4231.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  4232.             }
  4234.             if (!empty($proposalAgents->getAgThree())){
  4235.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgThree());
  4236.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  4237.             }
  4239.             if (!empty($proposalAgents->getAgFour())){
  4240.                 $agent = $em->getRepository(User::class)->findOneById($proposalAgents->getAgFour());
  4241.                 $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  4242.             }
  4243.         }
  4245.         if (!empty($mailArrayTo)){
  4246.             $mailArrayTo[$agent->getEmail()] = $agent->getEmail();
  4247.             $replyTo = array();
  4248.             foreach ($mailArrayTo as $item){ $replyTo[$item] = $item; }
  4250.             $agentMail = $agent->getEmail();
  4252.             //Se prepara el correo con los agentes a notificar
  4253.             $firmGmail = $agent->getFirmGmail();
  4254.             $data = array(
  4255.                 'body' => $message,
  4256.                 'firm' => $firmGmail,
  4257.             );
  4259.             // EJECUTAR ENVIO DE ALERTA PARA EL AGENTE
  4260.             $transporter = new Swift_SmtpTransport();
  4261.                 $transporter->setHost('smtp.gmail.com')
  4262.                 ->setEncryption('ssl')//ssl / tls
  4263.                 ->setPort(465)// 465 / 587
  4264.                 ->setUsername('desarrollo@develup.solutions')
  4265.                 ->setPassword('utvh hzoi wfdo ztjs');
  4266.             $mailer = new Swift_Mailer($transporter);
  4268.             $message = new Swift_Message();
  4269.                 $message->setSubject('Actualización de servicios AvExpress del proposal: '. $proposalId)
  4270.                 ->setSender($agentMail)
  4271.                 ->setFrom(array("desarrollo@develup.solutions" => "System Mante 3.0"))
  4272.                 ->setReplyTo($agentMail)
  4273.                 ->setTo($replyTo)
  4274.                 ->setBody(
  4275.                     $this->renderView(
  4276.                         'mail/structure-mail.html.twig',
  4277.                         array('data' => $data)
  4278.                     ),
  4279.                     'text/html'
  4280.                 );
  4281.             $mailer->send($message);
  4282.         }
  4284.         return true;
  4285.     }
  4289. };