src/MDS/DevelupBundle/Controller/FilesController.php line 599

Open in your IDE?
  1. <?php
  3. namespace App\MDS\DevelupBundle\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\MDS\DevelupBundle\Entity\MdvDocInvoiceRecItems;
  14. use App\MDS\DevelupBundle\Entity\MdvBriefings;
  15. use App\MDS\DevelupBundle\Entity\MdvBudgetPending;
  16. use Symfony\Component\Routing\Annotation\Route;
  17. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  18. use Symfony\Component\HttpFoundation\Request;
  19. use DateTime;
  20. use App\MDS\DevelupBundle\Entity\MdvFiles;
  21. use App\MDS\EventsBundle\Entity\ProposalSupplierServices;
  22. use App\MDS\DevelupBundle\Entity\MdvBudgetToProforma;
  23. use App\MDS\DevelupBundle\Entity\MdvDocInvoice;
  24. use App\MDS\DevelupBundle\Entity\MdvDocInvoiceItems;
  25. use App\MDS\DevelupBundle\Entity\MdvDocInvoiceRec;
  26. use App\MDS\DevelupBundle\Entity\MdvDocProforma;
  27. use App\MDS\DevelupBundle\Entity\MdvDocProformaItems;
  28. use App\MDS\DevelupBundle\Entity\MdvPaymentsClient;
  29. use App\MDS\DevelupBundle\Entity\MdvProduct;
  30. use App\MDS\DevelupBundle\Entity\MdvProductFile;
  31. use App\MDS\DevelupBundle\Entity\MdvServices;
  32. use App\MDS\DevelupBundle\Entity\MdvTelegramUser;
  33. use App\MDS\EventsBundle\Entity\Proposal;
  34. use App\MDS\EventsBundle\Entity\ProposalAgents;
  35. use App\MDS\EventsBundle\Entity\ProposalSupplierControl;
  36. use Swift_Mailer;
  37. use Swift_Message;
  38. use Swift_SmtpTransport;
  40. class FilesController extends AbstractController
  41. {
  43.     /**
  44.      * @Route("/fileadd/",  name="mdv_add_file")
  45.      * Agregar un expediente
  46.      */
  47.     public function addFileAction( Request $request)
  48.     {
  49.         $em = $this->getDoctrine()->getManager();
  50.         $clients = $em->getRepository(Client::class)->findAll();
  51.         $mdvFiles = $em->getRepository(MdvFiles::class)->findAll();
  52.         $id =0;
  53.         if (empty($mdvFiles)){
  54.             $id ++;
  55.         } else {
  56.             $lastElem = end($mdvFiles);
  57.             $id = $lastElem->getId() + 1;
  59.         }
  61.         return $this->render('MDS/DevelupBundle/Develup/add-files.html.twig',
  62.             array(
  63.                 'id' => $id,
  64.                 'clients' => $clients,
  65.                 'clientId' => 0,
  66.             ));
  67.     }
  69.     /**
  70.      * @Route("/filedelete/{id}",  name="mdv_file_delete")
  71.      * Eliminar un expediente
  72.      */
  73.     public function deleteFileAction($id, Request $request)
  74.     {
  75.         $em = $this->getDoctrine()->getManager();
  76.         $file = $em->getRepository(MdvFiles::class)->findOneById($id);
  78.         if (!empty($file)){
  80.             // se debe verificar que no haya factura asociada al expediente
  81.             $file->setStatus('Deleted');
  82.             $em->persist($file);
  83.             $em->flush();
  84.         }
  86.         return $this->redirectToRoute('mdv_list_file');
  87.     }
  89.     /**
  90.      * @Route("/filelist/",  name="mdv_list_file")
  91.      * Listar expedientes
  92.      */
  93.     public function listFileAction( Request $request)
  94.     {
  95.         $em = $this->getDoctrine()->getManager();
  96.         $idgroup = null;
  97.         $parameters = array(
  98.             'status' => 'Deleted'
  99.         );
  101.         $dql = 'SELECT i
  102.                 FROM DevelupBundle:MdvFiles i
  103.                 WHERE i.status != :status
  104.                 ORDER BY i.dateStart ASC';
  105.         $query = $em->createQuery($dql)->setParameters($parameters);
  106.         $ref = array();
  108.         if ($idgroup == 0) {
  109.             $reservas = $query->getResult();
  110.         } else {
  112.             $reservas = $query->getResult();
  113.         }
  115.         foreach ($reservas as $res) {
  116.             $client = $em->getRepository(Client::class)->findOneById($res->getClient());
  117.             if (!empty($client)) {
  118.                 $res->setClient($client->getName());
  119.             } else {
  120.                 $res->setClient(null);
  121.             }
  123. //            $res->setCreatedBy(
  124. //                ($em->getRepository(User::class)->findOneById($res->getCreatedBy()))->getName() . ' ' .
  125. //                ($em->getRepository(User::class)->findOneById($res->getCreatedBy()))->getLastName());
  127.             if (!empty($res->getDateStart()) and !empty($res->getDateEnd())) {
  128.                 $ref[$res->getId()] = '#' . ($res->getDateStart())->format('ymd') . ($res->getDateEnd())->format('ymd');
  129.             } else {
  130.                 $ref[$res->getId()] = '#' . '000000' . '000000';
  131.             }
  132.         }
  134.         for ($i = 0; $i < sizeof($reservas); $i++) {
  135.             if ($reservas[$i]->getStatus() == "Deleted") {
  136.                 unset($reservas[$i]);
  137.             }
  138.         }
  140.         $reservasZero = array();
  141.         foreach ($reservas as $res) {
  142.             $reservasZero[] = array(
  143.                 'dateStart' => $res->getDateStart(),
  144.                 'dateEnd' => $res->getDateEnd(),
  145.                 'id' => $res->getId(),
  146.                 'title' => $res->getTitle(),
  147.                 'client' => $res->getClient(),
  148.                 'createdId' => $res->getCreatedId(),
  149.                 'ref' => $ref[$res->getId()],
  150.             );
  151.         }
  152.         $reservas = $reservasZero;
  154.         return $this->render('MDS/DevelupBundle/Develup/list-files.html.twig',
  155.             array(
  156.                 'groups' => null,
  157.                 'titleView' => '',
  158.                 'reservations' => $reservas
  159.             )
  160.         );
  161.     }
  163.     /**
  164.      * @Route("/filesave/",  name="mdv_save_file")
  165.      * Guardar un expediente nuevo
  166.      */
  167.     public function saveFileAction( Request $request)
  168.     {
  169.         $em = $this->getDoctrine()->getManager();
  170.         $newRequest = $request->request->get('develup');
  172.         if (empty($newRequest['title'])){
  173.             return $this->redirectToRoute('mdv_add_file');
  174.         }
  176.         /* Obtengo usuario logueado */
  177.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  178.         $user_id = $user_logueado->getId();
  180.         $newFile = new MdvFiles();
  181.         $newFile->setTitle($newRequest['title']);
  182.         $newFile->setClient($newRequest['client']);
  183.         if (!empty($newRequest['idProposal'])){
  184.             $newFile->setIdProposal($newRequest['idProposal']);
  185.         } else {
  186.             $newFile->setIdProposal(null);
  187.         }
  188.         $newFile->setStatus($newRequest['status']);
  189.         $newFile->setAdvancePayment($newRequest['advancePayment']);
  190.         $newFile->setDescription($newRequest['description']);
  191.         if (empty($newRequest['dateStart'])){
  192.             $newFile->setDateStart(new \DateTime("now"));
  193.         } else {
  194.             $newFile->setDateStart(new \DateTime($newRequest['dateStart']));}
  195.         if (empty($newRequest['dateEnd'])){
  196.             $newFile->setDateEnd(new \DateTime("now"));
  197.         } else {
  198.             $newFile->setDateEnd(new \DateTime($newRequest['dateEnd']));}
  199.         $newFile->setCreatedId($user_id);
  200.         $newFile->setUpdatedId($user_id);
  201.         $newFile->setCreatedAt(new \DateTime("now"));
  202.         $newFile->setUpdatedAt(new \DateTime("now"));
  204.         $em->persist($newFile);
  205.         $em->flush();
  207.         $clients = $em->getRepository(Client::class)->findAll();
  208.         $products = $em->getRepository(MdvProduct::class)->findAll();
  210.         $data = $this->calculosFile($newFile->getId(), null, 0, 'File');
  212.         $sumatoriaTotalNet = 0;
  213.         $sumatoriaTotalVat = 0;
  214.         $sumatoriaTotal = 0;
  216.         $resultados = array(
  217.             'totalNeto' => $sumatoriaTotalNet,
  218.             'vat' => $sumatoriaTotalVat,
  219.             'total' => $sumatoriaTotal,
  221.         );
  223.         $productInFile = $em->getRepository(MdvProductFile::class)->findByFileId($newFile->getId());
  224.         $numeroItems = sizeof($productInFile);
  226.         return $this->redirectToRoute('mdv_edit_file', array( 'id' => $newFile->getId() ));
  227.     }
  229.     /**
  230.      * @Route("/fileupdate/{id}",  name="mdv_update_file")
  231.      * Actualizar un expediente
  232.      */
  233.     public function updateFileAction($id, Request $request)
  234.     {
  235.         $logTelegram = false;
  236.         $numberToPrefix = 0;
  237.         $em = $this->getDoctrine()->getManager();
  238.         $newFile = $em->getRepository(MdvFiles::class)->findOneById($id);
  239.         $newRequest = $request->request->get('develup');
  241.         /* Obtengo usuario logueado */
  242.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  243.         $user_id = $user_logueado->getId();
  245.         if (!empty($newRequest['title'])){$newFile->setTitle($newRequest['title']);}
  246.         $newFile->setClient($newRequest['client']);
  248.         if (!empty($newRequest['idProposal'])){$newFile->setIdProposal($newRequest['idProposal']);} else {$newFile->setIdProposal(null);}
  250.         $newFile->setStatus($newRequest['status']);
  251.         $newFile->setAdvancePayment($newRequest['advancePayment']);
  252.         $newFile->setDescription($newRequest['description']);
  253.         $newFile->setUpdatedId($user_id);
  254.         $newFile->setUpdatedAt(new \DateTime("now"));
  256.         $em->persist($newFile);
  257.         $em->flush();
  259.         $productInFile = $em->getRepository(MdvProductFile::class)->findByFileId($newFile->getId());
  261.         if(!empty($newFile->getIdProposal())){
  262.             // El expediente se ha relacionado con un proposal, se debe actualizar en eventos
  263.             $file = $newFile;
  264.             // Si hay proposal se debe actualizar en el expediente de Eventos
  265.             if (!empty($file->getIdProposal()) and is_numeric($file->getIdProposal())){
  266.                 // Buscamos el destino donde se encuentre Develup y ahi agregamos el servicio, si no se encuentra no se agregara el servicio
  267.                 $control = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  268.                     array(
  269.                         'supplierId' => 2,                                          // El supplier 2 es Develup
  270.                         'proposalId' => $file->getIdProposal(),
  271.                     )
  272.                 );
  273.                 // INICIO: Buscamos la info del lado de eventos
  274.                 $proposal = $em->getRepository(Proposal::class)->findOneById($file->getIdProposal());
  275.                 $agent = $em->getRepository(User::class)->findOneById($proposal->getAgentId());
  276.                 $agentFullName = $agent->getName().' '.$agent->getLastName();
  278.                 $proposalTitle = $proposal->getId().' - '.$proposal->getTitle();
  279.                 // FIN: Buscamos la info del lado de eventos
  281.                 foreach ($productInFile as $item){
  282.                     if (!empty($control)){
  283.                         // Existe un destino con Develup  como proveedor, hay se agregara el servicio
  284.                         $productOriginal = $em->getRepository(MdvProduct::class)->findOneById($item->getProductId());
  286.                         $service = new ProposalSupplierServices();
  287.                         $service->setServiceIdFather(0);
  288.                         $service->setControlId($control->getId());
  289.                         $service->setProposalId($file->getIdProposal());
  290.                         $service->setDestinationId($control->getDestinoId());
  291.                         $service->setSupplierId(2);
  292.                         $service->setIdeaId(null);
  293.                         $service->setServiceId($item->getProductId());
  294.                         $service->setServiceCatName('Technology');
  295.                         $service->setServiceCatId(14);
  296.                         $service->setName($item->getProductName());
  298.                         // Si el precio no ha sido modificado se copia el original en Eventos
  299. //                        if (bcdiv($productOriginal->getPrice(), 1.21, 2) == $item->getServicePrice()){
  300. //                            $service->setPrice($productOriginal->getPrice());
  301. //                        } else {
  302. //                             El precio se ha modificado en Develup, en Eventos se debe reflejar el cambio y no es el valor por defecto
  303. //                            $service->setPrice(round($item->getServicePrice()*1.21,2));
  304. //                        }
  305.                         // Siempre vamos a tomar el precio que establezca Develup, se haya modificado o no
  306.                         $service->setPrice($item->getServicePrice());
  308.                         $service->setCurrency(null);
  309.                         $service->setUnits(1);
  310.                         $service->setCommission(0);
  311.                         $service->setOver(0);
  312.                         $service->setIva(21);
  313.                         $service->setPax(0);
  314.                         $service->setHour(null);
  315.                         $now = new \DateTime("now");
  316.                         $service->setDateInAt($now);
  317.                         $service->setDateOutAt($now);
  318.                         $service->setDirectPayment(0);
  319.                         $service->setStatus('Pending');
  320.                         $service->setStatusinternal('Additional');
  321.                         $service->setPreCommission(null);
  322.                         $service->setPreIva(null);
  323.                         $service->setDateBlockLimit(null);
  324.                         $service->setOpCommission(1);
  325.                         $service->setOpOver(1);
  326.                         $service->setOpIva(1);
  327.                         $service->setBreakdown(0);
  328.                         $service->setIsFather(0);
  329.                         $service->setRank(1);
  330.                         $service->setOriginalopIva(1);
  331.                         $service->setOriginalIva(null);
  332.                         $service->setOriginalPrice(null);
  333.                         $service->setStatusRec('normal');
  334.                         $service->setAssistantId(null);
  335.                         $service->setCreatedId($user_id);
  336.                         $service->setUpdatedId($user_id);
  337.                         $service->setCreatedAt($now);
  338.                         $service->setUpdatedAt($now);
  340.                         $em->persist($service);
  341.                         $em->flush();
  343.                         // Guardamos el ID del servicio (Eventos) asociado al producto (Develup)
  344.                         $item->setOriginId($service->getId());
  345.                         $item->setDateInAt($now);
  346.                         $item->setDateOutAt($now);
  348.                         $em->persist($item);
  349.                         $em->flush();
  351.                         // Se debe notificar por Telegram al agente de eventos
  352.                         $logTelegram = true;
  353.                     }
  355.                     //INICIO: Creamos una orden de hacer proforma
  357.                     //INICIO: Calculamos el ID de la proforma
  358.                     $numberToPrefix = $em->getRepository(MdvDocProforma::class)->findAll();
  359.                     if (empty($numberToPrefix)){
  360.                         $numberToPrefix = 0;
  361.                     } else {
  362.                         $numberToPrefix = end($numberToPrefix)->getId();
  363.                     }
  364.                     $numberToPrefix++;
  365.                     //FIN: Calculamos el ID de la proforma
  367.                     $order = new MdvBudgetToProforma();
  368.                     $order->setStatus('Pending');
  369.                     $order->setFileId($file->getId());
  370.                     $order->setProductFileId($item->getId());
  371.                     $order->setUserConfirmedId($proposal->getAgentId());
  372.                     $order->setUserConfirmedFullName($agentFullName);
  373.                     $order->setProposalTitle($proposalTitle);
  374.                     $order->setProformaId($numberToPrefix);
  376.                     $em->persist($order);
  377.                     $em->flush();
  378.                     //FIN: Creamos una orden de hacer proforma
  379.                 }
  381.                 //INICIO: Notificamos al agente por Telegram
  382.                 if ($logTelegram){
  383.                     //Buscamos todos los agentes del proposal
  384.                     $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposal->getId());
  386.                     //Buscamos el Destino
  387.                     $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  389.                     //Buscamos el agente de Develup
  390.                     $userData = $em->getRepository(User::class)->findOneById($user_id);
  392.                     if (!empty($proposalAgents)){
  393.                         if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  394.                             $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE DEVELUP __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: Develup __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  395.                             //d('entro en 1',$proposalAgents->getAgOne(), $proposalDestino->getTitle());
  396.                         }
  397.                         if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  398.                             $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE DEVELUP __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: Develup __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  399.                             //d('entro en 2',$proposalAgents->getAgTwo(), $proposalDestino->getTitle());
  400.                         }
  401.                         if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  402.                             $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE DEVELUP __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: Develup __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  403.                             //d('entro en 3', $proposalAgents->getAgThree(), $proposalDestino->getTitle());
  404.                         }
  405.                         if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  406.                             $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE DEVELUP __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: Develup __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  407.                             //d('entro en 4', $proposalAgents->getAgFour(), $proposalDestino->getTitle());
  408.                         }
  409.                     }
  410.                 }
  411.                 //FIN: Notificamos al agente por Telegram
  413.                 //INICIO: Creamos el presupuesto (proforma)
  415.                 $budToPro = $em->getRepository(MdvBudgetToProforma::class)->findByProformaId($numberToPrefix);
  417.                 //INICIO: Se agrupan por expediente (fileId)
  418.                 $proformas = array();
  419.                 foreach ($budToPro as $item){
  420.                     $proformas[$item->getFileId()][] = $item;
  421.                 }
  422.                 //FIN: Se agrupan por expediente (fileId)
  424.                 if (!empty($budToPro)){
  425.                     foreach ($proformas as $key => $elemento){
  426.                         //INICIO: Creamos las proformas
  428.                         $newProforma = new MdvDocProforma();
  429.                         $newProforma->setPrefix('MDV-' . (new DateTime('now'))->format('dmy') . '-' . $numberToPrefix . '-' . $key);
  430.                         $newProforma->setDateAt(new DateTime('now'));
  431.                         $newProforma->setFileId($key);
  432.                         $newProforma->setCreatedId($user_id);
  433.                         $newProforma->setUpdatedId($user_id);
  434.                         $newProforma->setCreatedAt(new DateTime('now'));
  435.                         $newProforma->setUpdatedAt(new DateTime('now'));
  437.                         $em->persist($newProforma);
  438.                         $em->flush();
  439.                         //FIN: Creamos las proformas
  441.                         foreach ($elemento as $item) {
  442.                             //$key es el id del expediente
  443. //                    $arrayIdPro[$numberToPrefix] = $item->getUserConfirmedId();             // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  445.                             //INICIO: Creamos los elemento que iran dentro de las proformas
  446.                             $itemProforma = new MdvDocProformaItems();
  447.                             $itemProforma->setType('PRODUCT');
  448.                             $itemProforma->setFileId($key);
  449.                             $itemProforma->setProformaId($newProforma->getId());
  450.                             $itemProforma->setControlId($item->getProductFileId());
  452.                             $em->persist($itemProforma);
  453.                             $em->flush();
  455.                             //INICIO: Confirmamos el BudToProforma
  456.                             $item->setStatus('Tosend');              // El elemento se ha pasado a la proforma, solo falta enviar
  457.                             $item->setProformaId($newProforma->getId());
  459.                             $em->persist($item);
  460.                             $em->flush();
  461.                             //FIN: Confirmamos el BudToProforma
  463.                             //FIN: Creamos los elemento que iran dentro de las proformas
  464.                         }
  465.                     }
  466.                 }
  467.                 //FIN: Creamos el presupuesto (proforma)
  470.                 // INICIO: Se envia al agente el presupuesto
  471.                 $budToPro = $em->getRepository(MdvBudgetToProforma::class)->findByStatus('Tosend');
  473.                 /* Obtengo usuario logueado */
  474.                 $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  475.                 $user_id = $user_logueado->getId();
  477.                 $arrayIdPro = array();          // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  479.                 //INICIO: Se agrupan por expediente (fileId)
  480.                 $proformas = array();
  481.                 foreach ($budToPro as $item){
  482.                     $proformas[$item->getFileId()][] = $item;
  483.                 }
  484.                 //FIN: Se agrupan por expediente (fileId)
  486.                 if (!empty($budToPro)){
  487.                     foreach ($proformas as $key => $elemento){
  488.                         //INICIO: Creamos las proformas
  490.                         //INICIO: Calculamos el ID de la proforma
  491. //                $numberToPrefix = $em->getRepository(MdvDocProforma::class)->findAll();
  492. //                if (empty($numberToPrefix)){
  493. //                    $numberToPrefix = 0;
  494. //                } else {
  495. //                    $numberToPrefix = end($numberToPrefix)->getId();
  496. //                }
  497. //                $numberToPrefix++;
  498. //                $numberToPrefix++;
  499.                         //FIN: Calculamos el ID de la proforma
  500. //d($proformas, $elemento);exit();
  501. //                $newProforma = new MdvDocProforma();
  502. //                $newProforma->setPrefix('MDV-' . (new DateTime('now'))->format('dmy') . '-' . $numberToPrefix . '-' . $key);
  503. //                $newProforma->setDateAt(new DateTime('now'));
  504. //                $newProforma->setFileId($key);
  505. //
  506. //                $newProforma->setCreatedId($user_id);
  507. //                $newProforma->setUpdatedId($user_id);
  508. //                $newProforma->setCreatedAt(new DateTime('now'));
  509. //                $newProforma->setUpdatedAt(new DateTime('now'));
  510. //
  511. //                $em->persist($newProforma);
  512. //                $em->flush();
  513.                         //FIN: Creamos las proformas
  515.                         foreach ($elemento as $item) {
  516.                             //$key es el id del expediente
  518.                             if (!empty($item->getProformaId())) {
  519.                                 $arrayIdPro[$item->getProformaId()] = $item->getUserConfirmedId();             // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  520.                             }
  521.                             //INICIO: Creamos los elemento que iran dentro de las proformas
  522. //                    $itemProforma = new MdvDocProformaItems();
  523. //                    $itemProforma->setType('PRODUCT');
  524. //                    $itemProforma->setFileId($key);
  525. //                    $itemProforma->setProformaId($newProforma->getId());
  526. //                    $itemProforma->setControlId($item->getProductFileId());
  527. //
  528. //                    $em->persist($itemProforma);
  529. //                    $em->flush();
  531.                             //INICIO: Confirmamos el BudToProforma
  532.                             $item->setStatus('Confirmed');              // El elemento se ha pasado a confirmado porque se enviara por correo
  534.                             $em->persist($item);
  535.                             $em->flush();
  536.                             //FIN: Confirmamos el BudToProforma
  538.                             //FIN: Creamos los elemento que iran dentro de las proformas
  539.                         }
  540.                     }
  541.                 }
  543.                 //INICIO: Notificamos de todos los presupuestos (proformas) que se han creado
  544.                 foreach ($arrayIdPro as $key => $item){
  545.                     //Buscamos los agentes a notificar
  546.                     // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  547.                     $agent = $em->getRepository(User::class)->findOneById($item);
  548.                     $agentMail = $agent->getEmail();
  550.                     $mailAgent = $agentMail;
  552.                     //Se prepara el correo con los agentes a notificar
  553.                     $firmGmail = $agent->getFirmGmail();
  554.                     $data = array(
  555.                         'body' => 'Presupuesto Develup #' . $key  . ', ' . '<br><a href="http://' . $request->server->get('HTTP_HOST') . '/pdf/develupproforma/' . $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>',
  556.                         'firm' => $firmGmail,
  557.                     );
  559.                     // EJECUTAR ENVIO DE ALERTA PARA EL AGENTE
  560.                     $transporter = new Swift_SmtpTransport();
  561.                     $transporter->setHost('smtp.gmail.com')
  562.                         ->setEncryption('ssl')//ssl / tls
  563.                         ->setPort(465)// 465 / 587
  564.                         ->setUsername('desarrollo@develup.solutions')
  565.                         ->setPassword('utvh hzoi wfdo ztjs');
  566.                     $mailer = new Swift_Mailer($transporter);
  568.                     $message = new Swift_Message();
  569.                     $message->setSubject('Presupuesto #' . $key . ', Notificación de nuevo presupuesto')
  570.                         ->setSender($agentMail)
  571.                         ->setFrom(array("desarrollo@develup.solutions" => "System Mante 3.0"))
  572.                         ->setReplyTo($agentMail)
  573.                         ->setTo($mailAgent)
  574.                         ->setBody(
  575.                             $this->renderView(
  576.                                 'mail/structure-mail.html.twig',
  577.                                 array('data' => $data)
  578.                             ),
  579.                             'text/html'
  580.                         );
  581.                     $mailer->send($message);
  582.                 }
  583.                 //FIN: Notificamos de todos los presupuestos (proformas) que se han creado
  584.                 // FIN: Se envia al agente el presupuesto
  585.             }
  586.         }
  588.         return $this->redirectToRoute('mdv_edit_file',
  589.             array(
  590.                 'id' => $newFile->getId()
  591.             )
  592.         );
  593.     }
  595.     /**
  596.      * @Route("/fileedit/{id}", name="mdv_edit_file")
  597.      * Editar un expediente
  598.      */
  599.     public function editFileAction( $id, Request $request)
  600.     {
  601.         $em = $this->getDoctrine()->getManager();
  602.         $editFile = $em->getRepository(MdvFiles::class)->findOneById($id);
  603.         $clients = $em->getRepository(Client::class)->findAll();
  604.         $clientSelected = $em->getRepository(Client::class)->findOneById($editFile->getClient());
  605.         $products = $em->getRepository(MdvProduct::class)->findAll();
  607.         $data = $this->calculosFile($id, null, 0, 'File');
  609.         $sumatoriaTotalNet = 0;
  610.         $sumatoriaTotalVat = 0;
  611.         $sumatoriaTotal = 0;
  613.         $resultados = array(
  614.             'totalNeto' => $sumatoriaTotalNet,
  615.             'vat' => $sumatoriaTotalVat,
  616.             'total' => $sumatoriaTotal,
  617.         );
  619.         $productInFile = $em->getRepository(MdvProductFile::class)->findByFileId($id);
  620.         $numeroItems = sizeof($productInFile);
  622.         $facturas = $em->getRepository(MdvDocInvoice::class)->findByFileId($id);
  623.         $facturasRec = $em->getRepository(MdvDocInvoiceRec::class)->findByFileId($id);
  625.         foreach ($facturasRec as $item){
  626.             array_push($facturas,$item);
  627.         }
  629.         $proformas = array();
  630.         $allProformas = $em->getRepository(MdvDocProforma::class)->findByFileId($id);
  632.         foreach ($allProformas as $item){
  633.             $dataTwo = $this->baseInvoiceDoneFileTwo($id, $item->getId(),'P');
  634.             $bases = 0;
  635.             if (is_numeric($dataTwo['totales']) and is_numeric($dataTwo['totales_neto'])){$bases = $dataTwo['totales'] - $dataTwo['totales_neto'];}
  637.             $allItemsProforma = $em->getRepository(MdvDocProformaItems::class)->findByProformaId($dataTwo['number']);
  639.             $itemsInProforma = array();
  641.             foreach ($allItemsProforma as $elem){
  642.                 $itemsInProforma[] = $em->getRepository(MdvProductFile::class)->findOneById($elem->getControlId());
  643.             }
  645.             $proformas[] = array(
  646.                 'id' => $dataTwo['number'],
  647.                 'itemsInProforma' => $itemsInProforma,
  648.                 'date' => $dataTwo['date'],
  649.                 'neto' => $dataTwo['totales_neto'],
  650.                 'bases_imponibles' => $bases,
  651.                 'total' => $dataTwo['totales'],
  652.             );
  653.         }
  655.         return $this->render('MDS/DevelupBundle/Develup/edit-files.html.twig',
  656.             array(
  657.                 'id' => $id,
  658.                 'clients' => $clients,
  659.                 'clientId' => $editFile->getClient(),
  660.                 'clientSelected' => $clientSelected,
  661.                 'file' => $editFile,
  662.                 'numeroItems' => $numeroItems,
  663.                 'arrayProductFile' => $data['datasupplier']['product'],
  664.                 'products' => $products,
  665.                 'services' => null,
  666.                 'facturas' => $facturas,
  667.                 'proformas' => $proformas,
  668.                 'paymentNotIvoiced' => null,
  669.                 'paymentsAll' => null,
  670.                 'resultados' => $resultados,
  671.                 'totales_global_con_iva' => $data['totales'], //$data['totales_global_con_iva'],
  672.                 'totales_global_iva' => $data['bases_imponibles']['ivaMontoVeintiUno'], //$data['totales_global_iva'],
  673.                 'totales_global_neto' => $data['totales_neto'], //$data['totales_global_neto'],
  674.                 'totales_global_servicios_con_iva' => 0, //$data['totales_global_servicios_con_iva'],
  675.                 'totales_global_servicios_neto' => 0, //$data['totales_global_servicios_neto'],
  676.                 'totales_global_servicios_iva' => 0, //$data['totales_global_servicios_iva'],
  677.                 'sumatoria_totales_global_con_iva' => 0, //$data['sumatoria_totales_global_con_iva'],
  678.                 'sumatoria_totales_global_neto' => 0, //$data['sumatoria_totales_global_neto'],
  679.                 'sumatoria_totales_global_iva' => 0, //$data['sumatoria_totales_global_iva'],
  680.             ));
  681.     }
  684.     /**
  685.      * @Route("/filefrombudget/{id}",  name="mdv_add_file_from_budget")
  686.      * Agregar un expediente desde un presupuesto
  687.      */
  688.     public function addFileFromBudgetAction( $id, Request $request)
  689.     {
  690.         $em = $this->getDoctrine()->getManager();
  691.         $budget = $em->getRepository(MdvBudgetPending::class)->findOneById($id);
  692.         $proposal = $em->getRepository(Proposal::class)->findOneById($budget->getProposalId());
  694.         $newFile = $em->getRepository(MdvFiles::class)->findOneByIdProposal($proposal->getId());
  696.         /* Obtengo usuario logueado */
  697.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  698.         $user_id = $user_logueado->getId();
  700.         if (empty($newFile)){
  701.             // No hay un File asociado a ese proposal, se debe crear uno nuevo
  702.             $newFile = new MdvFiles();
  703.             $newFile->setTitle($proposal->getId().' - ' .$budget->getProposalTitle());
  704.             $newFile->setClient(262);                           // In Out es el cliente
  705.             $newFile->setIdProposal($proposal->getId());
  706.             $newFile->setStatus('Pending');
  707.             $newFile->setAdvancePayment(null);
  708.             if (!empty($budget->getBriefing())) {
  709.                 $newFile->setDescription('<p> *********  MENSAJE DEL AGENTE  ********* </p>' . $budget->getBriefing());
  710.             }
  711.             $newFile->setDateStart(new \DateTime("now"));
  712.             $newFile->setDateEnd(new \DateTime("now"));
  714.             $newFile->setCreatedId($user_id);
  715.             $newFile->setUpdatedId($user_id);
  716.             $newFile->setCreatedAt(new \DateTime("now"));
  717.             $newFile->setUpdatedAt(new \DateTime("now"));
  718.         } else {
  719.             // Ya existe un File asociado a ese proposal
  720.             $newFile->setClient(262);                           // In Out es el cliente
  721.             $newFile->setStatus('Pending');
  722.             if (!empty($budget->getBriefing())) {
  723.                 $newFile->setDescription($newFile->getDescription() . '<p> *********  MENSAJE DEL AGENTE  ********* </p>' . $budget->getBriefing());
  724.             }
  726.             $newFile->setUpdatedId($user_id);
  727.             $newFile->setUpdatedAt(new \DateTime("now"));
  728.         }
  730.         $em->persist($newFile);
  731.         $em->flush();
  733.         $em->remove($budget);
  734.         $em->flush();
  736.         //Actualizamos los Briefings que esten en FileId null con el recien generado fileId en base al proposalId
  737.         $allBriefings = $em->getRepository(MdvBriefings::class)->findByProposalId($proposal->getId());
  738.         foreach ($allBriefings as $item){
  739.             if (empty($item->getFileId())) {
  740.                 $item->setFileId($newFile->getId());
  742.                 $em->persist($item);
  743.                 $em->flush();
  744.             }
  745.         }
  747.         return $this->redirectToRoute('mdv_edit_file',
  748.             array(
  749.                 'id' => $newFile->getId()
  750.             )
  751.         );
  752.     }
  754.     /**
  755.      * @Route("/filelistbriefings/{id}",  name="mdv_list_file_briefings")
  756.      * Listar briefings del expediente
  757.      */
  758.     public function listFileBriefingsAction($id, Request $request){
  760.         $em = $this->getDoctrine()->getManager();
  761.         $briefings = $em->getRepository(MdvBriefings::class)->findByFileId($id);
  764.         return $this->render('MDS/DevelupBundle/Develup/list-briefings.html.twig',
  765.             array(
  766.                 'id' => $id,
  767.                 'briefings' => $briefings,
  768.             )
  769.         );
  770.     }
  773.     /**
  774.      * @Route("/briefingadd/{id}",  name="mdv_add_file_briefings")
  775.      * Agregar briefing al expediente
  776.      */
  777.     public function addFileBriefingsAction($id, Request $request){
  779.         $brif = $request->request->get('newbriefing');
  781.         $em = $this->getDoctrine()->getManager();
  782.         $file = $em->getRepository(MdvFiles::class)->findOneById($id);
  783.         $proposalId = $file->getIdProposal();
  785.         /* Obtengo usuario logueado */
  786.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  787.         $user_id = $user_logueado->getId();
  789.         $userConfirmedFullName = $user_logueado->getName().' '.$user_logueado->getLastName();
  791.         $briefing = new MdvBriefings();
  792.         $briefing->setProposalId($proposalId);
  793.         $briefing->setBriefing($brif);
  794.         $briefing->setBudgetPendingId(null);
  795.         $briefing->setFileId($id);
  796.         $briefing->setUserConfirmedFullName($userConfirmedFullName);
  797.         $briefing->setUserConfirmedId($user_id);
  798.         $briefing->setCreatedAt(new \DateTime("now"));
  800.         $em->persist($briefing);
  801.         $em->flush();
  803.         $briefings = $em->getRepository(MdvBriefings::class)->findByFileId($id);
  805.         return $this->render('MDS/DevelupBundle/Develup/list-briefings.html.twig',
  806.             array(
  807.                 'id' => $id,
  808.                 'briefings' => $briefings,
  809.             )
  810.         );
  811.     }
  814.     private function baseInvoiceDoneFileTwo($fileId, $invoiceId, $typeBase)
  815.     {
  816.         $em = $this->getDoctrine()->getManager();
  817.         $file = $em->getRepository(MdvFiles::class)->findOneById($fileId);
  818.         $dateDocument = null;                                                                           //Fecha final del documento
  819.         $subneto = 0;
  820.         if (($typeBase == 'I') or ($typeBase == 'P')) {
  821.             if ($typeBase == 'I') {
  822.                 $items = $em->getRepository(MdvDocInvoiceItems::class)->findBy(array('fileId' => $fileId, 'invoiceId' => $invoiceId));
  823.             } else {
  824.                 // Es factura ni proforma
  825.                 $items = $em->getRepository(MdvDocProformaItems::class)->findBy(array('fileId' => $fileId, 'proformaId' => $invoiceId));
  826.             }
  827.         } else {
  828.             // No es factura ni proforma, es una rectificativa
  829.             $items = $em->getRepository(MdvDocInvoiceRecItems::class)->findBy(array('fileId' => $fileId, 'invoiceRecId' => $invoiceId));
  830.         }
  832.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('2');
  833.         $client = $em->getRepository(Client::class)->findById($file->getClient());
  835.         if (empty($client)){
  836.             $client[0] = new Client();
  837.             $client[0]->setName('');
  838.             $client[0]->setTitle('');
  839.             $client[0]->setIdDocument('');
  840.             $client[0]->setPopulation('');
  841.             $client[0]->setRegion('');
  842.             $client[0]->setCountry('');
  843.         } else {
  844.             if (is_numeric($client[0]->getPopulation())){
  845.                 $city = ($em->getRepository(Cities::class)->findOneById($client[0]->getPopulation()));
  846.                 $client[0]->setPopulation($city->getCity());
  847.             }
  848.             if (is_numeric($client[0]->getRegion())){
  849.                 $region = ($em->getRepository(Regions::class)->findOneById($client[0]->getRegion()));
  850.                 $client[0]->setRegion($region->getRegion());
  851.             }
  852.             if (is_numeric($client[0]->getCountry())){
  853.                 $country = ($em->getRepository(Country::class)->findOneById($client[0]->getCountry()));
  854.                 $client[0]->setCountry($country->getCountry());
  855.             }
  856.         }
  858.         // Acumuladores de los calculos
  859.         $totales_neto_all = 0;
  860.         $data_iva = array(
  861.             'iva' => 21,
  862.             'ivaMontoVeintiUno' => 0,
  863.             'ivaMontoDiez' => 0,
  864.             'ivaMontoCero' => 0,
  865.         );
  867.         //INICIO: Determinamos el numero de factura o proforma
  868.         if ($typeBase == 'I'){
  869.             // Es una Factura
  871.             $number = $em->getRepository(MdvDocInvoice::class)->findOneById($invoiceId);
  872.             $dateDocument = $number->getDateAt();
  873.             $number = $number->getNumber();
  874.             $type = 'Invoice';
  876.         } else {
  877.             if ($typeBase == 'R'){
  878.                 // Es una factura rectificativa
  879.                 $number = $em->getRepository(MdvDocInvoiceRec::class)->findOneById($invoiceId);
  880.                 $dateDocument = $number->getDateAt();
  881.                 $type = 'Invoice Rec';
  882.             } else {
  883.                 // Es una Proforma
  885.                 $number = $invoiceId;
  886.                 $type = 'Proforma';
  887.             }
  888.         }
  889.         //FIN: Determinamos el numero de factura o proforma
  891.         // Buscamos los productos, pagos y servicios
  893.         $arrayItems = array();
  894.         $fileProducts = array();
  895.         $payments = array();
  896.         $services = array();
  898.         if (!empty($items)) {
  899.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  900.                 foreach ($items as $item) {
  901.                     switch ($item->getItemType()) {
  902.                         case 'PRODUCT': // Producto
  903.                             $fileProducts[] = $item;
  904.                             break;
  906.                         case 'PAYMENT': // Pago
  907.                             $payments[] = $item;
  908.                             break;
  910.                         case 'SERVICE': // Servicio
  911.                             $services[] = $item;
  912.                             break;
  914.                         default:
  915.                             break;
  916.                     }
  917.                 }
  918.             } else {
  919.                 // Es una proforma
  920.                 foreach ($items as $item) {
  921.                     switch ($item->getType()) {
  922.                         case 'PRODUCT': // Producto
  923.                             $productPro = $em->getRepository(MdvProductFile::class)->findOneById($item->getControlId());
  924.                             if (!empty($productPro)) {
  925.                                 $fileProducts[] = $productPro;
  926.                             }
  927.                             break;
  929.                         case 'PAYMENT': // Pago
  930.                             $paymentPro = $em->getRepository(MdvPaymentsClient::class)->findOneById($item->getControlId());
  931.                             if (!empty($paymentPro)) {
  932.                                 $payments[] = $paymentPro;
  933.                             }
  934.                             break;
  936.                         case 'SERVICE': // Servicio
  937.                             $servicePro = $em->getRepository(MdvServices::class)->findOneById($item->getControlId());
  938.                             if (!empty($servicePro)) {
  939.                                 $services[] = $servicePro;
  940.                             }
  941.                             break;
  943.                         default:
  944.                             break;
  945.                     }
  946.                 }
  947.             }
  948.         }
  950.         $data_supplier = array();
  951.         $i = 0;
  953.         $iva = '21';            // Esteban Rincon: "Por Ley de localización del impuesto, siempre será un 21%"
  954.         $pax = '1';
  955.         $qty = '1';
  956.         $product = array(
  957.             'neto' => 0,
  958.             'sumSubT' => 0,
  959.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  961.         $service = array(
  962.             'neto' => 0,
  963.             'sumSubT' => 0,
  964.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  966.         foreach ($fileProducts as $item){
  968.             if (!is_null($item->getUnits()) or !empty($item->getUnits())){
  969.                 $qty = $item->getUnits();
  970.             }
  972.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  973.                 if (is_null($item->getPrdServicePrice()) or empty($item->getPrdServicePrice())){
  974.                     $subtotal = 0;
  975.                     $neto = 0;
  976.                     $subtotalProduct = 0;
  978.                 } else {
  980. //                    $subtotalProduct = $item->getPrdServicePrice() * 1.21;
  981.                     $subtotalProduct = $item->getPrdSubTotalPrice() * 1.21;
  982. //                    $subneto = $item->getPrdServicePrice();
  983.                     $subneto = $item->getPrdSubTotalPrice();
  985.                     $subtotal =  $subtotalProduct;
  986.                     $neto =  $subneto;
  988.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  989.                     $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  990.                     $neto = round($neto,2,PHP_ROUND_HALF_UP);
  992.                     $arrayItems[] = array(
  993.                         'type' => 'Product',
  994.                         'name' => $item->getPrdName(),
  995.                         'amount' => $neto,
  996.                         'iva' => '21',
  997.                         'total' => $subtotal,
  998.                     );
  999.                 }
  1000.             } else {
  1001.                 // Es proforma
  1002.                 if (is_null($item->getServicePrice()) or empty($item->getServicePrice())){
  1003.                     $subtotal = 0;
  1004.                     $neto = 0;
  1005.                     $subtotalProduct = 0;
  1007.                 } else {
  1009. //                    $subtotalProduct = $item->getServicePrice() * 1.21;
  1010.                     $subtotalProduct = $item->getSubTotalPrice() * 1.21;
  1011. //                    $subneto = $item->getServicePrice();
  1012.                     $subneto = $item->getSubTotalPrice();
  1014.                     $subtotal =  $subtotalProduct;
  1015.                     $neto =  $subneto;
  1017.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  1018.                     $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  1019.                     $neto = round($neto,2,PHP_ROUND_HALF_UP);
  1021.                     $arrayItems[] = array(
  1022.                         'type' => 'Product',
  1023.                         'name' => $item->getProductName(),
  1024.                         'amount' => $neto,
  1025.                         'iva' => '21',
  1026.                         'total' => $subtotal,
  1027.                     );
  1028.                 }
  1029.             }
  1031.             // Acumula netos totales e IVA
  1032.             $totales_neto_all = $totales_neto_all + $neto;
  1033.             $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * 0.21);
  1034.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1035.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  1036.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  1037.             // Acumula netos totales e IVA
  1039.             $product['neto'] = $product['neto'] + $neto;
  1040.             $product['sumSubT'] = $product['sumSubT'] + $subtotal;
  1041.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1042.             $product['neto'] = round($product['neto'],2,PHP_ROUND_HALF_UP);
  1043.             $product['sumSubT'] = round($product['sumSubT'],2,PHP_ROUND_HALF_UP);
  1045.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1046.                 $data_supplier['product'][$i] = array(
  1047.                     'id' => $item->getId(),
  1048.                     'productName' => $item->getPrdName(),
  1049.                     'productId' => $item->getPrdProductId(),
  1050.                     'dateStart' => $item->getPrdDateStart(),
  1051.                     'dateEnd' => $item->getPrdDateEnd(),
  1052.                     'servicePrice' => $item->getPrdServicePrice(),
  1053.                     'serviceSubTotalPrice' => $subneto,     //antes de IVA
  1054.                     'subtotalProduct' => $subtotalProduct,
  1055.                     'iva' => $iva,
  1056.                     'pax' => $pax,
  1057.                     'qty' => $qty,
  1058.                     'type' => $item->getPrdType(),
  1059.                     'subtotal' => $subtotal,
  1060.                 );
  1061.             } else {
  1062.                 // Es proforma
  1063.                 $data_supplier['product'][$i] = array(
  1064.                     'id' => $item->getId(),
  1065.                     'productName' => $item->getProductName(),
  1066.                     'productId' => $item->getProductId(),
  1067.                     'dateStart' => $item->getDateStart(),
  1068.                     'dateEnd' => $item->getDateEnd(),
  1069.                     'servicePrice' => $item->getServicePrice(),
  1070.                     'subtotalProduct' => $subtotalProduct,
  1071.                     'iva' => $iva,
  1072.                     'pax' => $pax,
  1073.                     'qty' => $qty,
  1074.                     'type' => $item->getType(),
  1075.                     'subtotal' => $subtotal,
  1076.                 );
  1077.             }
  1078.             $i++;
  1079.         }
  1081.         $data_supplier['productSubTotal'] = array(
  1082.             'neto' => $product['neto'],
  1083.             'sumSubT' => $product['sumSubT'],
  1084.         );
  1086.         $payment = array(
  1087.             'sumSubT' => 0,
  1088.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1090.         $i = 0;
  1091.         foreach ($payments as $item){
  1093.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1094.                 $payment['sumSubT'] = $payment['sumSubT'] + $item->getPayAmountTotal();
  1095.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1096.                 $payment['sumSubT'] = round($payment['sumSubT'], 2, PHP_ROUND_HALF_UP);
  1098.                 $data_supplier['payment'][$i] = array(
  1099.                     'id' => $item->getId(),
  1100.                     'amount' => $item->getPayAmount(),
  1101.                     'amountTotal' => $item->getPayAmountTotal(),
  1102.                     'vat' => $item->getPayVat(),
  1103.                     'datePayAt' => $item->getPayDatePayAt(),
  1104.                     'wayToPay' => $item->getPayWayToPay(),
  1105.                 );
  1107.                 $arrayItems[] = array(
  1108.                     'type' => 'Payment',
  1109.                     'name' => $item->getPayWayToPay(),
  1110.                     'amount' => $item->getPayAmount(),
  1111.                     'total' => $item->getPayAmountTotal(),
  1112.                     'iva' => $item->getPayVat(),
  1113.                 );
  1114.             } else {
  1115.                 // Es una proforma
  1116.                 $payment['sumSubT'] = $payment['sumSubT'] + $item->getAmountTotal();
  1117.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1118.                 $payment['sumSubT'] = round($payment['sumSubT'], 2, PHP_ROUND_HALF_UP);
  1120.                 $data_supplier['payment'][$i] = array(
  1121.                     'id' => $item->getId(),
  1122.                     'amount' => $item->getAmount(),
  1123.                     'amountTotal' => $item->getAmountTotal(),
  1124.                     'vat' => $item->getVat(),
  1125.                     'datePayAt' => $item->getDatePayAt(),
  1126.                     'wayToPay' => $item->getWayToPay(),
  1127.                 );
  1129.                 $arrayItems[] = array(
  1130.                     'type' => 'Payment',
  1131.                     'name' => $item->getWayToPay(),
  1132.                     'amount' => $item->getAmount(),
  1133.                     'total' => $item->getAmountTotal(),
  1134.                     'iva' => $item->getVat(),
  1135.                 );
  1136.             }
  1137.             $i++;
  1138.         }
  1140.         if (!empty($payments)) {
  1141.             $data_supplier['paymentSubTotal'] = array(
  1142.                 'sumSubT' => $payment['sumSubT'],
  1143.             );
  1144.         }
  1146.         foreach ($services as $item){
  1147.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1148.                 if (is_null($item->getSrvPrice()) or empty($item->getSrvPrice())) {
  1149.                     $subtotal = 0;
  1150.                     $neto = 0;
  1151.                     $subtotalService = 0;
  1153.                 } else {
  1154.                     $subtotalService = $item->getSrvPrice();
  1155.                     $subneto = $item->getSrvPrice();
  1157.                     // Commission
  1158.                     if ($item->getSrvOpCommission() == '1') {
  1159.                         $subtotalService = $subtotalService * (1 + ($item->getSrvCommission() / 100));
  1160.                         $subneto = $subneto * (1 + ($item->getSrvCommission() / 100));
  1161.                     } else {
  1162.                         $subtotalService = $subtotalService * (1 - ($item->getSrvCommission() / 100));
  1163.                         $subneto = $subneto * (1 - ($item->getSrvCommission() / 100));
  1164.                     }
  1166.                     // Over
  1167.                     if ($item->getSrvOpOver() == '1') {
  1168.                         $subtotalService = $subtotalService + $item->getSrvOver();
  1169.                         $subneto = $subneto + $item->getSrvOver();
  1170.                     } else {
  1171.                         $subtotalService = $subtotalService - $item->getSrvOver();
  1172.                         $subneto = $subneto - $item->getSrvOver();
  1173.                     }
  1175.                     // IVA
  1176.                     if ($item->getSrvOpIva() == '1') {
  1177.                         $subtotalService = $subtotalService * (1 + ($item->getSrvIva() / 100));
  1178.                     } else {
  1179.                         $subtotalService = $item->getSrvPrice();
  1180.                         $subneto = ($subneto * 100) / (100 + $item->getSrvIva());
  1181.                     }
  1183.                     switch ($item->getSrvServiceCatId()) {
  1184.                         case 1: // Alojamiento
  1185.                             // el numero de noches $numNoches; precio unitario $subneto
  1186.                             $numNoches = (($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days;
  1187.                             // La personas no afectan este calculo
  1188.                             $subtotal = $subtotalService * $numNoches * $item->getSrvUnits();
  1189.                             $subnetoUnit = $subneto;
  1191.                             $subneto = $subneto * $numNoches * $item->getSrvUnits();
  1193.                             $data_supplier['service'][$i] = array(
  1194.                                 'id' => $item->getId(),
  1195.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1196.                                 'serviceName' => $item->getSrvName(),
  1197.                                 'serviceType' => 'Hotel',
  1198.                                 'date' => ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y'),
  1199.                                 'qty' => $item->getSrvUnits(),
  1200.                                 'iva' => $item->getSrvIva(),
  1201.                                 'pax' => '-',
  1202.                                 'precioUnit' => $subnetoUnit,
  1203.                                 'subneto' => $subneto,
  1204.                                 'subtotal' => $subtotal,
  1205.                             );
  1206.                             break;
  1208.                         case 2: //Actividades
  1209.                             // El número de personas es considerado en el calculo
  1210.                             $pax = $item->getSrvPax();
  1211.                             if (empty($pax) or $pax == "0") {
  1212.                                 $pax = 1;
  1213.                             }
  1214.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1216.                             if ($days > 1) {
  1217.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1218.                             } else {
  1219.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1220.                             }
  1222.                             $subtotal = $subtotalService * $days * $item->getSrvUnits();
  1223.                             $subnetoUnit = $subneto;
  1224.                             $subneto = $subneto * $days * $item->getSrvUnits();
  1226.                             $data_supplier['service'][$i] = array(
  1227.                                 'id' => $item->getId(),
  1228.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1229.                                 'serviceName' => $item->getSrvName(),
  1230.                                 'serviceType' => 'Actividad',
  1231.                                 'date' => $dateServ,
  1232.                                 'qty' => $item->getSrvUnits(),
  1233.                                 'iva' => $item->getSrvIva(),
  1234.                                 'pax' => $item->getSrvPax(),
  1235.                                 'precioUnit' => $subnetoUnit,
  1236.                                 'subneto' => $subneto,
  1237.                                 'subtotal' => $subtotal,
  1238.                             );
  1239.                             break;
  1241.                         case 3: // AV
  1242.                             $pax = $item->getSrvPax();
  1243.                             if (empty($pax) or $pax == "0") {
  1244.                                 $pax = 1;
  1245.                             }
  1247.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1248.                             if ($days > 1) {
  1249.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1250.                             } else {
  1251.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1252.                             }
  1254.                             $unitsServ = $item->getSrvUnits();
  1255.                             if (empty($unitsServ) or $unitsServ == "0") {
  1256.                                 $unitsServ = 1;
  1257.                             }
  1259.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1260.                             $subnetoUnit = $subneto;
  1261.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1263.                             $data_supplier['service'][$i] = array(
  1264.                                 'id' => $item->getId(),
  1265.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1266.                                 'serviceName' => $item->getSrvName(),
  1267.                                 'serviceType' => 'AV',
  1268.                                 'date' => $dateServ,
  1269.                                 'qty' => $unitsServ,
  1270.                                 'iva' => $item->getSrvIva(),
  1271.                                 'pax' => $item->getSrvPax(),
  1272.                                 'precioUnit' => $subnetoUnit,
  1273.                                 'subneto' => $subneto,
  1274.                                 'subtotal' => $subtotal,
  1275.                             );
  1276.                             break;
  1278.                         case 4: //Creative
  1279.                             $pax = $item->getSrvPax();
  1280.                             if (empty($pax) or $pax == "0") {
  1281.                                 $pax = 1;
  1282.                             }
  1284.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1285.                             if ($days > 1) {
  1286.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1287.                             } else {
  1288.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1289.                             }
  1291.                             $unitsServ = $item->getSrvUnits();
  1292.                             if (empty($unitsServ) or $unitsServ == "0") {
  1293.                                 $unitsServ = 1;
  1294.                             }
  1296.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1297.                             $subnetoUnit = $subneto;
  1298.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1300.                             $data_supplier['service'][$i] = array(
  1301.                                 'id' => $item->getId(),
  1302.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1303.                                 'serviceName' => $item->getSrvName(),
  1304.                                 'serviceType' => 'Creativo',
  1305.                                 'date' => $dateServ,
  1306.                                 'qty' => $unitsServ,
  1307.                                 'iva' => $item->getSrvIva(),
  1308.                                 'pax' => $item->getSrvPax(),
  1309.                                 'precioUnit' => $subnetoUnit,
  1310.                                 'subneto' => $subneto,
  1311.                                 'subtotal' => $subtotal,
  1312.                             );
  1313.                             break;
  1315.                         case 5: //Cruise
  1316.                             $pax = $item->getSrvPax();
  1317.                             if (empty($pax) or $pax == "0") {
  1318.                                 $pax = 1;
  1319.                             }
  1321.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days);
  1322.                             if ($days > 1) {
  1323.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1324.                             } else {
  1325.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1326.                             }
  1328.                             $unitsServ = $item->getSrvUnits();
  1329.                             if (empty($unitsServ) or $unitsServ == "0") {
  1330.                                 $unitsServ = 1;
  1331.                             }
  1333.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1334.                             $subnetoUnit = $subneto;
  1335.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1337.                             $data_supplier['service'][$i] = array(
  1338.                                 'id' => $item->getId(),
  1339.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1340.                                 'serviceName' => $item->getSrvName(),
  1341.                                 'serviceType' => 'Crucero',
  1342.                                 'date' => $dateServ,
  1343.                                 'qty' => $unitsServ,
  1344.                                 'iva' => $item->getSrvIva(),
  1345.                                 'pax' => $item->getSrvPax(),
  1346.                                 'precioUnit' => $subnetoUnit,
  1347.                                 'subneto' => $subneto,
  1348.                                 'subtotal' => $subtotal,
  1349.                             );
  1350.                             break;
  1352.                         case 6: //Entertaiment
  1353.                             $pax = $item->getSrvPax();
  1354.                             if (empty($pax) or $pax == "0") {
  1355.                                 $pax = 1;
  1356.                             }
  1358.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1359.                             if ($days > 1) {
  1360.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1361.                             } else {
  1362.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1363.                             }
  1365.                             $unitsServ = $item->getSrvUnits();
  1366.                             if (empty($unitsServ) or $unitsServ == "0") {
  1367.                                 $unitsServ = 1;
  1368.                             }
  1370.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1371.                             $subnetoUnit = $subneto;
  1372.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1374.                             $data_supplier['service'][$i] = array(
  1375.                                 'id' => $item->getId(),
  1376.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1377.                                 'serviceName' => $item->getSrvName(),
  1378.                                 'serviceType' => 'Entretenimiento',
  1379.                                 'date' => $dateServ,
  1380.                                 'qty' => $unitsServ,
  1381.                                 'iva' => $item->getSrvIva(),
  1382.                                 'pax' => $item->getSrvPax(),
  1383.                                 'precioUnit' => $subnetoUnit,
  1384.                                 'subneto' => $subneto,
  1385.                                 'subtotal' => $subtotal,
  1386.                             );
  1387.                             break;
  1389.                         case 7: // Gifts
  1390.                             $pax = $item->getSrvPax();
  1391.                             if (empty($pax) or $pax == "0") {
  1392.                                 $pax = 1;
  1393.                             }
  1395. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1396.                             $days = 1;
  1397.                             if ($days > 1) {
  1398.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1399.                             } else {
  1400.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1401.                             }
  1403.                             $unitsServ = $item->getSrvUnits();
  1404.                             if (empty($unitsServ) or $unitsServ == "0") {
  1405.                                 $unitsServ = 1;
  1406.                             }
  1408.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1409.                             $subnetoUnit = $subneto;
  1410.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1412.                             $data_supplier['service'][$i] = array(
  1413.                                 'id' => $item->getId(),
  1414.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1415.                                 'serviceName' => $item->getSrvName(),
  1416.                                 'serviceType' => 'Regalos',
  1417.                                 'date' => $dateServ,
  1418.                                 'qty' => $unitsServ,
  1419.                                 'iva' => $item->getSrvIva(),
  1420.                                 'pax' => $item->getSrvPax(),
  1421.                                 'precioUnit' => $subnetoUnit,
  1422.                                 'subneto' => $subneto,
  1423.                                 'subtotal' => $subtotal,
  1424.                             );
  1425.                             break;
  1427.                         case 8: //Guide
  1428.                             $pax = $item->getSrvPax();
  1429.                             if (empty($pax) or $pax == "0") {
  1430.                                 $pax = 1;
  1431.                             }
  1433.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1434.                             if ($days > 1) {
  1435.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1436.                             } else {
  1437.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1438.                             }
  1440.                             $unitsServ = $item->getSrvUnits();
  1441.                             if (empty($unitsServ) or $unitsServ == "0") {
  1442.                                 $unitsServ = 1;
  1443.                             }
  1445.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1446.                             $subnetoUnit = $subneto;
  1447.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1449.                             $data_supplier['service'][$i] = array(
  1450.                                 'id' => $item->getId(),
  1451.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1452.                                 'serviceName' => $item->getSrvName(),
  1453.                                 'serviceType' => 'Regalos',
  1454.                                 'date' => $dateServ,
  1455.                                 'qty' => $unitsServ,
  1456.                                 'iva' => $item->getSrvIva(),
  1457.                                 'pax' => $item->getSrvPax(),
  1458.                                 'precioUnit' => $subnetoUnit,
  1459.                                 'subneto' => $subneto,
  1460.                                 'subtotal' => $subtotal,
  1461.                             );
  1462.                             break;
  1464.                         case 9: //Itineraries
  1465.                             $pax = $item->getSrvPax();
  1466.                             if (empty($pax) or $pax == "0") {
  1467.                                 $pax = 1;
  1468.                             }
  1470.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1471.                             if ($days > 1) {
  1472.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1473.                             } else {
  1474.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1475.                             }
  1477.                             $unitsServ = $item->getSrvUnits();
  1478.                             if (empty($unitsServ) or $unitsServ == "0") {
  1479.                                 $unitsServ = 1;
  1480.                             }
  1482.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1483.                             $subnetoUnit = $subneto;
  1484.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1486.                             $data_supplier['service'][$i] = array(
  1487.                                 'id' => $item->getId(),
  1488.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1489.                                 'serviceName' => $item->getSrvName(),
  1490.                                 'serviceType' => 'Itinerarios',
  1491.                                 'date' => $dateServ,
  1492.                                 'qty' => $unitsServ,
  1493.                                 'iva' => $item->getSrvIva(),
  1494.                                 'pax' => $item->getSrvPax(),
  1495.                                 'precioUnit' => $subnetoUnit,
  1496.                                 'subneto' => $subneto,
  1497.                                 'subtotal' => $subtotal,
  1498.                             );
  1499.                             break;
  1501.                         case 10: //Lounge  -- No Aplica
  1502. //                        $pax = $item->getPax();
  1503. //                        if (empty($pax) or $pax == "0") {
  1504. //                            $pax = 1;
  1505. //                        }
  1506. //
  1507. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1508. //                        if ($days > 1){
  1509. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  1510. //                        } else {
  1511. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1512. //                        }
  1513. //
  1514. //                        $unitsServ = $item->getUnits();
  1515. //                        if (empty($unitsServ) or $unitsServ == "0") {
  1516. //                            $unitsServ = 1;
  1517. //                        }
  1518. //
  1519. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1520. //                        $subnetoUnit = $subneto;
  1521. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  1522. //
  1523. //                        $data_supplier['service'][$i] = array (
  1524. //                            'id' => $item->getId(),
  1525. //                            'serviceCatId' => $item->getServiceCatId(),
  1526. //                            'serviceName' => $item->getName(),
  1527. //                            'serviceType' => 'Itinerarios',
  1528. //                            'date' => $dateServ,
  1529. //                            'qty' => $unitsServ,
  1530. //                            'iva' => $item->getIva(),
  1531. //                            'pax' => $item->getPax(),
  1532. //                            'precioUnit' => $subnetoUnit,
  1533. //                            'subneto' => $subneto,
  1534. //                            'subtotal' => $subtotal,
  1535. //                        );
  1536.                             break;
  1538.                         case 11: //Menu
  1539.                             $pax = $item->getSrvPax();
  1540.                             if (empty($pax) or $pax == "0") {
  1541.                                 $pax = 1;
  1542.                             }
  1544.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1545.                             if ($days > 1) {
  1546.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1547.                             } else {
  1548.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1549.                             }
  1551.                             $unitsServ = $item->getSrvUnits();
  1552.                             if (empty($unitsServ) or $unitsServ == "0") {
  1553.                                 $unitsServ = 1;
  1554.                             }
  1556.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1557.                             $subnetoUnit = $subneto;
  1558.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1560.                             $data_supplier['service'][$i] = array(
  1561.                                 'id' => $item->getId(),
  1562.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1563.                                 'serviceName' => $item->getSrvName(),
  1564.                                 'serviceType' => 'Menú',
  1565.                                 'date' => $dateServ,
  1566.                                 'qty' => $unitsServ,
  1567.                                 'iva' => $item->getSrvIva(),
  1568.                                 'pax' => $item->getSrvPax(),
  1569.                                 'precioUnit' => $subnetoUnit,
  1570.                                 'subneto' => $subneto,
  1571.                                 'subtotal' => $subtotal,
  1572.                             );
  1573.                             break;
  1575.                         case 12: //Others
  1576.                             $pax = $item->getSrvPax();
  1577.                             if (empty($pax) or $pax == "0") {
  1578.                                 $pax = 1;
  1579.                             }
  1581.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1582.                             if ($days > 1) {
  1583.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1584.                             } else {
  1585.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1586.                             }
  1588.                             $unitsServ = $item->getSrvUnits();
  1589.                             if (empty($unitsServ) or $unitsServ == "0") {
  1590.                                 $unitsServ = 1;
  1591.                             }
  1593.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1594.                             $subnetoUnit = $subneto;
  1595.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1597.                             $data_supplier['service'][$i] = array(
  1598.                                 'id' => $item->getId(),
  1599.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1600.                                 'serviceName' => $item->getSrvName(),
  1601.                                 'serviceType' => 'Otros',
  1602.                                 'date' => $dateServ,
  1603.                                 'qty' => $unitsServ,
  1604.                                 'iva' => $item->getSrvIva(),
  1605.                                 'pax' => $item->getSrvPax(),
  1606.                                 'precioUnit' => $subnetoUnit,
  1607.                                 'subneto' => $subneto,
  1608.                                 'subtotal' => $subtotal,
  1609.                             );
  1610.                             break;
  1612.                         case 13: //Transport
  1613.                             $pax = $item->getSrvPax();
  1614.                             if (empty($pax) or $pax == "0") {
  1615.                                 $pax = 1;
  1616.                             }
  1618.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1619.                             if ($days > 1) {
  1620.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1621.                             } else {
  1622.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1623.                             }
  1625.                             $unitsServ = $item->getSrvUnits();
  1626.                             if (empty($unitsServ) or $unitsServ == "0") {
  1627.                                 $unitsServ = 1;
  1628.                             }
  1630.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1631.                             $subnetoUnit = $subneto;
  1632.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1634.                             $data_supplier['service'][$i] = array(
  1635.                                 'id' => $item->getId(),
  1636.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1637.                                 'serviceName' => $item->getSrvName(),
  1638.                                 'serviceType' => 'Transporte',
  1639.                                 'date' => $dateServ,
  1640.                                 'qty' => $unitsServ,
  1641.                                 'iva' => $item->getSrvIva(),
  1642.                                 'pax' => $item->getSrvPax(),
  1643.                                 'precioUnit' => $subnetoUnit,
  1644.                                 'subneto' => $subneto,
  1645.                                 'subtotal' => $subtotal,
  1646.                             );
  1647.                             break;
  1649.                         case 14: //Technology
  1650.                             $pax = $item->getSrvPax();
  1651.                             if (empty($pax) or $pax == "0") {
  1652.                                 $pax = 1;
  1653.                             }
  1655. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1656.                             $days = 1;
  1657. //                        if ($days > 1){
  1658. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  1659. //                        } else {
  1660. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1661. //                        }
  1662.                             $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1664.                             $unitsServ = $item->getSrvUnits();
  1665.                             if (empty($unitsServ) or $unitsServ == "0") {
  1666.                                 $unitsServ = 1;
  1667.                             }
  1669.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1670.                             $subnetoUnit = $subneto;
  1671.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1673.                             $data_supplier['service'][$i] = array(
  1674.                                 'id' => $item->getId(),
  1675.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1676.                                 'serviceName' => $item->getSrvName(),
  1677.                                 'serviceType' => 'Tecnología',
  1678.                                 'date' => $dateServ,
  1679.                                 'qty' => $unitsServ,
  1680.                                 'iva' => $item->getSrvIva(),
  1681.                                 'pax' => $item->getSrvPax(),
  1682.                                 'precioUnit' => $subnetoUnit,
  1683.                                 'subneto' => $subneto,
  1684.                                 'subtotal' => $subtotal,
  1685.                             );
  1686.                             break;
  1688.                         case 15: //Assisstant
  1689.                             $pax = $item->getSrvPax();
  1690.                             if (empty($pax) or $pax == "0") {
  1691.                                 $pax = 1;
  1692.                             }
  1694.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1695.                             if ($days > 1) {
  1696.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1697.                             } else {
  1698.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1699.                             }
  1701.                             $unitsServ = $item->getSrvUnits();
  1702.                             if (empty($unitsServ) or $unitsServ == "0") {
  1703.                                 $unitsServ = 1;
  1704.                             }
  1706.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1707.                             $subnetoUnit = $subneto;
  1708.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1710.                             $data_supplier['service'][$i] = array(
  1711.                                 'id' => $item->getId(),
  1712.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1713.                                 'serviceName' => $item->getSrvName(),
  1714.                                 'serviceType' => 'Asistente',
  1715.                                 'date' => $dateServ,
  1716.                                 'qty' => $unitsServ,
  1717.                                 'iva' => $item->getSrvIva(),
  1718.                                 'pax' => $item->getSrvPax(),
  1719.                                 'precioUnit' => $subnetoUnit,
  1720.                                 'subneto' => $subneto,
  1721.                                 'subtotal' => $subtotal,
  1722.                             );
  1723.                             break;
  1725.                         case 16: //DDR
  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' => 'DDR',
  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.                         default:
  1763.                             break;
  1764.                     }
  1766.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  1767.                     $subtotal = round($subtotal, 2, PHP_ROUND_HALF_UP);
  1768.                     $neto = round($subneto, 2, PHP_ROUND_HALF_UP);
  1770.                     $arrayItems[] = array(
  1771.                         'type' => 'Service',
  1772.                         'name' => $item->getSrvName(),
  1773.                         'amount' => $neto,
  1774.                         'iva' => $item->getSrvIva(),
  1775.                         'total' => $subtotal,
  1776.                     );
  1778.                 }
  1780.                 switch ($item->getSrvIva()) {
  1781.                     // Acumula IVA
  1782.                     case 21:
  1783.                         $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getSrvIva() / 100));
  1784.                         break;
  1786.                     case 10:
  1787.                         $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getSrvIva() / 100));
  1788.                         break;
  1790.                     case 0:
  1791.                         break;
  1793.                     default:
  1794.                         break;
  1796.                 }
  1797.             } else {
  1798.                 // Es una proforma
  1799.                 if (is_null($item->getPrice()) or empty($item->getPrice())) {
  1800.                     $subtotal = 0;
  1801.                     $neto = 0;
  1802.                     $subtotalService = 0;
  1804.                 } else {
  1805.                     $subtotalService = $item->getPrice();
  1806.                     $subneto = $item->getPrice();
  1808.                     // Commission
  1809.                     if ($item->getOpCommission() == '1') {
  1810.                         $subtotalService = $subtotalService * (1 + ($item->getCommission() / 100));
  1811.                         $subneto = $subneto * (1 + ($item->getCommission() / 100));
  1812.                     } else {
  1813.                         $subtotalService = $subtotalService * (1 - ($item->getCommission() / 100));
  1814.                         $subneto = $subneto * (1 - ($item->getCommission() / 100));
  1815.                     }
  1817.                     // Over
  1818.                     if ($item->getOpOver() == '1') {
  1819.                         $subtotalService = $subtotalService + $item->getOver();
  1820.                         $subneto = $subneto + $item->getOver();
  1821.                     } else {
  1822.                         $subtotalService = $subtotalService - $item->getOver();
  1823.                         $subneto = $subneto - $item->getOver();
  1824.                     }
  1826.                     // IVA
  1827.                     if ($item->getOpIva() == '1') {
  1828.                         $subtotalService = $subtotalService * (1 + ($item->getIva() / 100));
  1829.                     } else {
  1830.                         $subtotalService = $item->getPrice();
  1831.                         $subneto = ($subneto * 100) / (100 + $item->getIva());
  1832.                     }
  1834.                     switch ($item->getServiceCatId()) {
  1835.                         case 1: // Alojamiento
  1836.                             // el numero de noches $numNoches; precio unitario $subneto
  1837.                             $numNoches = (($item->getDateOutAt())->diff($item->getDateInAt()))->days;
  1838.                             // La personas no afectan este calculo
  1839.                             $subtotal = $subtotalService * $numNoches * $item->getUnits();
  1840.                             $subnetoUnit = $subneto;
  1842.                             $subneto = $subneto * $numNoches * $item->getUnits();
  1844.                             $data_supplier['service'][$i] = array(
  1845.                                 'id' => $item->getId(),
  1846.                                 'serviceCatId' => $item->getServiceCatId(),
  1847.                                 'serviceName' => $item->getName(),
  1848.                                 'serviceType' => 'Hotel',
  1849.                                 'date' => ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y'),
  1850.                                 'qty' => $item->getUnits(),
  1851.                                 'iva' => $item->getIva(),
  1852.                                 'pax' => '-',
  1853.                                 'precioUnit' => $subnetoUnit,
  1854.                                 'subneto' => $subneto,
  1855.                                 'subtotal' => $subtotal,
  1856.                             );
  1857.                             break;
  1859.                         case 2: //Actividades
  1860.                             // El número de personas es considerado en el calculo
  1861.                             $pax = $item->getPax();
  1862.                             if (empty($pax) or $pax == "0") {
  1863.                                 $pax = 1;
  1864.                             }
  1865.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1867.                             if ($days > 1) {
  1868.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  1869.                             } else {
  1870.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1871.                             }
  1873.                             $subtotal = $subtotalService * $days * $item->getUnits();
  1874.                             $subnetoUnit = $subneto;
  1875.                             $subneto = $subneto * $days * $item->getUnits();
  1877.                             $data_supplier['service'][$i] = array(
  1878.                                 'id' => $item->getId(),
  1879.                                 'serviceCatId' => $item->getServiceCatId(),
  1880.                                 'serviceName' => $item->getName(),
  1881.                                 'serviceType' => 'Actividad',
  1882.                                 'date' => $dateServ,
  1883.                                 'qty' => $item->getUnits(),
  1884.                                 'iva' => $item->getIva(),
  1885.                                 'pax' => $item->getPax(),
  1886.                                 'precioUnit' => $subnetoUnit,
  1887.                                 'subneto' => $subneto,
  1888.                                 'subtotal' => $subtotal,
  1889.                             );
  1890.                             break;
  1892.                         case 3: // AV
  1893.                             $pax = $item->getPax();
  1894.                             if (empty($pax) or $pax == "0") {
  1895.                                 $pax = 1;
  1896.                             }
  1898.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1899.                             if ($days > 1) {
  1900.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  1901.                             } else {
  1902.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1903.                             }
  1905.                             $unitsServ = $item->getUnits();
  1906.                             if (empty($unitsServ) or $unitsServ == "0") {
  1907.                                 $unitsServ = 1;
  1908.                             }
  1910.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1911.                             $subnetoUnit = $subneto;
  1912.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1914.                             $data_supplier['service'][$i] = array(
  1915.                                 'id' => $item->getId(),
  1916.                                 'serviceCatId' => $item->getServiceCatId(),
  1917.                                 'serviceName' => $item->getName(),
  1918.                                 'serviceType' => 'AV',
  1919.                                 'date' => $dateServ,
  1920.                                 'qty' => $unitsServ,
  1921.                                 'iva' => $item->getIva(),
  1922.                                 'pax' => $item->getPax(),
  1923.                                 'precioUnit' => $subnetoUnit,
  1924.                                 'subneto' => $subneto,
  1925.                                 'subtotal' => $subtotal,
  1926.                             );
  1927.                             break;
  1929.                         case 4: //Creative
  1930.                             $pax = $item->getPax();
  1931.                             if (empty($pax) or $pax == "0") {
  1932.                                 $pax = 1;
  1933.                             }
  1935.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1936.                             if ($days > 1) {
  1937.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  1938.                             } else {
  1939.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1940.                             }
  1942.                             $unitsServ = $item->getUnits();
  1943.                             if (empty($unitsServ) or $unitsServ == "0") {
  1944.                                 $unitsServ = 1;
  1945.                             }
  1947.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1948.                             $subnetoUnit = $subneto;
  1949.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1951.                             $data_supplier['service'][$i] = array(
  1952.                                 'id' => $item->getId(),
  1953.                                 'serviceCatId' => $item->getServiceCatId(),
  1954.                                 'serviceName' => $item->getName(),
  1955.                                 'serviceType' => 'Creativo',
  1956.                                 'date' => $dateServ,
  1957.                                 'qty' => $unitsServ,
  1958.                                 'iva' => $item->getIva(),
  1959.                                 'pax' => $item->getPax(),
  1960.                                 'precioUnit' => $subnetoUnit,
  1961.                                 'subneto' => $subneto,
  1962.                                 'subtotal' => $subtotal,
  1963.                             );
  1964.                             break;
  1966.                         case 5: //Cruise
  1967.                             $pax = $item->getPax();
  1968.                             if (empty($pax) or $pax == "0") {
  1969.                                 $pax = 1;
  1970.                             }
  1972.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days);
  1973.                             if ($days > 1) {
  1974.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  1975.                             } else {
  1976.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1977.                             }
  1979.                             $unitsServ = $item->getUnits();
  1980.                             if (empty($unitsServ) or $unitsServ == "0") {
  1981.                                 $unitsServ = 1;
  1982.                             }
  1984.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1985.                             $subnetoUnit = $subneto;
  1986.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1988.                             $data_supplier['service'][$i] = array(
  1989.                                 'id' => $item->getId(),
  1990.                                 'serviceCatId' => $item->getServiceCatId(),
  1991.                                 'serviceName' => $item->getName(),
  1992.                                 'serviceType' => 'Crucero',
  1993.                                 'date' => $dateServ,
  1994.                                 'qty' => $unitsServ,
  1995.                                 'iva' => $item->getIva(),
  1996.                                 'pax' => $item->getPax(),
  1997.                                 'precioUnit' => $subnetoUnit,
  1998.                                 'subneto' => $subneto,
  1999.                                 'subtotal' => $subtotal,
  2000.                             );
  2001.                             break;
  2003.                         case 6: //Entertaiment
  2004.                             $pax = $item->getPax();
  2005.                             if (empty($pax) or $pax == "0") {
  2006.                                 $pax = 1;
  2007.                             }
  2009.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2010.                             if ($days > 1) {
  2011.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2012.                             } else {
  2013.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2014.                             }
  2016.                             $unitsServ = $item->getUnits();
  2017.                             if (empty($unitsServ) or $unitsServ == "0") {
  2018.                                 $unitsServ = 1;
  2019.                             }
  2021.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2022.                             $subnetoUnit = $subneto;
  2023.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2025.                             $data_supplier['service'][$i] = array(
  2026.                                 'id' => $item->getId(),
  2027.                                 'serviceCatId' => $item->getServiceCatId(),
  2028.                                 'serviceName' => $item->getName(),
  2029.                                 'serviceType' => 'Entretenimiento',
  2030.                                 'date' => $dateServ,
  2031.                                 'qty' => $unitsServ,
  2032.                                 'iva' => $item->getIva(),
  2033.                                 'pax' => $item->getPax(),
  2034.                                 'precioUnit' => $subnetoUnit,
  2035.                                 'subneto' => $subneto,
  2036.                                 'subtotal' => $subtotal,
  2037.                             );
  2038.                             break;
  2040.                         case 7: // Gifts
  2041.                             $pax = $item->getPax();
  2042.                             if (empty($pax) or $pax == "0") {
  2043.                                 $pax = 1;
  2044.                             }
  2046. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2047.                             $days = 1;
  2048.                             if ($days > 1) {
  2049.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2050.                             } else {
  2051.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2052.                             }
  2054.                             $unitsServ = $item->getUnits();
  2055.                             if (empty($unitsServ) or $unitsServ == "0") {
  2056.                                 $unitsServ = 1;
  2057.                             }
  2059.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2060.                             $subnetoUnit = $subneto;
  2061.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2063.                             $data_supplier['service'][$i] = array(
  2064.                                 'id' => $item->getId(),
  2065.                                 'serviceCatId' => $item->getServiceCatId(),
  2066.                                 'serviceName' => $item->getName(),
  2067.                                 'serviceType' => 'Regalos',
  2068.                                 'date' => $dateServ,
  2069.                                 'qty' => $unitsServ,
  2070.                                 'iva' => $item->getIva(),
  2071.                                 'pax' => $item->getPax(),
  2072.                                 'precioUnit' => $subnetoUnit,
  2073.                                 'subneto' => $subneto,
  2074.                                 'subtotal' => $subtotal,
  2075.                             );
  2076.                             break;
  2078.                         case 8: //Guide
  2079.                             $pax = $item->getPax();
  2080.                             if (empty($pax) or $pax == "0") {
  2081.                                 $pax = 1;
  2082.                             }
  2084.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2085.                             if ($days > 1) {
  2086.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2087.                             } else {
  2088.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2089.                             }
  2091.                             $unitsServ = $item->getUnits();
  2092.                             if (empty($unitsServ) or $unitsServ == "0") {
  2093.                                 $unitsServ = 1;
  2094.                             }
  2096.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2097.                             $subnetoUnit = $subneto;
  2098.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2100.                             $data_supplier['service'][$i] = array(
  2101.                                 'id' => $item->getId(),
  2102.                                 'serviceCatId' => $item->getServiceCatId(),
  2103.                                 'serviceName' => $item->getName(),
  2104.                                 'serviceType' => 'Regalos',
  2105.                                 'date' => $dateServ,
  2106.                                 'qty' => $unitsServ,
  2107.                                 'iva' => $item->getIva(),
  2108.                                 'pax' => $item->getPax(),
  2109.                                 'precioUnit' => $subnetoUnit,
  2110.                                 'subneto' => $subneto,
  2111.                                 'subtotal' => $subtotal,
  2112.                             );
  2113.                             break;
  2115.                         case 9: //Itineraries
  2116.                             $pax = $item->getPax();
  2117.                             if (empty($pax) or $pax == "0") {
  2118.                                 $pax = 1;
  2119.                             }
  2121.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2122.                             if ($days > 1) {
  2123.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2124.                             } else {
  2125.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2126.                             }
  2128.                             $unitsServ = $item->getUnits();
  2129.                             if (empty($unitsServ) or $unitsServ == "0") {
  2130.                                 $unitsServ = 1;
  2131.                             }
  2133.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2134.                             $subnetoUnit = $subneto;
  2135.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2137.                             $data_supplier['service'][$i] = array(
  2138.                                 'id' => $item->getId(),
  2139.                                 'serviceCatId' => $item->getServiceCatId(),
  2140.                                 'serviceName' => $item->getName(),
  2141.                                 'serviceType' => 'Itinerarios',
  2142.                                 'date' => $dateServ,
  2143.                                 'qty' => $unitsServ,
  2144.                                 'iva' => $item->getIva(),
  2145.                                 'pax' => $item->getPax(),
  2146.                                 'precioUnit' => $subnetoUnit,
  2147.                                 'subneto' => $subneto,
  2148.                                 'subtotal' => $subtotal,
  2149.                             );
  2150.                             break;
  2152.                         case 10: //Lounge  -- No Aplica
  2153. //                        $pax = $item->getPax();
  2154. //                        if (empty($pax) or $pax == "0") {
  2155. //                            $pax = 1;
  2156. //                        }
  2157. //
  2158. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2159. //                        if ($days > 1){
  2160. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2161. //                        } else {
  2162. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2163. //                        }
  2164. //
  2165. //                        $unitsServ = $item->getUnits();
  2166. //                        if (empty($unitsServ) or $unitsServ == "0") {
  2167. //                            $unitsServ = 1;
  2168. //                        }
  2169. //
  2170. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2171. //                        $subnetoUnit = $subneto;
  2172. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  2173. //
  2174. //                        $data_supplier['service'][$i] = array (
  2175. //                            'id' => $item->getId(),
  2176. //                            'serviceCatId' => $item->getServiceCatId(),
  2177. //                            'serviceName' => $item->getName(),
  2178. //                            'serviceType' => 'Itinerarios',
  2179. //                            'date' => $dateServ,
  2180. //                            'qty' => $unitsServ,
  2181. //                            'iva' => $item->getIva(),
  2182. //                            'pax' => $item->getPax(),
  2183. //                            'precioUnit' => $subnetoUnit,
  2184. //                            'subneto' => $subneto,
  2185. //                            'subtotal' => $subtotal,
  2186. //                        );
  2187.                             break;
  2189.                         case 11: //Menu
  2190.                             $pax = $item->getPax();
  2191.                             if (empty($pax) or $pax == "0") {
  2192.                                 $pax = 1;
  2193.                             }
  2195.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2196.                             if ($days > 1) {
  2197.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2198.                             } else {
  2199.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2200.                             }
  2202.                             $unitsServ = $item->getUnits();
  2203.                             if (empty($unitsServ) or $unitsServ == "0") {
  2204.                                 $unitsServ = 1;
  2205.                             }
  2207.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2208.                             $subnetoUnit = $subneto;
  2209.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2211.                             $data_supplier['service'][$i] = array(
  2212.                                 'id' => $item->getId(),
  2213.                                 'serviceCatId' => $item->getServiceCatId(),
  2214.                                 'serviceName' => $item->getName(),
  2215.                                 'serviceType' => 'Menú',
  2216.                                 'date' => $dateServ,
  2217.                                 'qty' => $unitsServ,
  2218.                                 'iva' => $item->getIva(),
  2219.                                 'pax' => $item->getPax(),
  2220.                                 'precioUnit' => $subnetoUnit,
  2221.                                 'subneto' => $subneto,
  2222.                                 'subtotal' => $subtotal,
  2223.                             );
  2224.                             break;
  2226.                         case 12: //Others
  2227.                             $pax = $item->getPax();
  2228.                             if (empty($pax) or $pax == "0") {
  2229.                                 $pax = 1;
  2230.                             }
  2232.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2233.                             if ($days > 1) {
  2234.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2235.                             } else {
  2236.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2237.                             }
  2239.                             $unitsServ = $item->getUnits();
  2240.                             if (empty($unitsServ) or $unitsServ == "0") {
  2241.                                 $unitsServ = 1;
  2242.                             }
  2244.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2245.                             $subnetoUnit = $subneto;
  2246.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2248.                             $data_supplier['service'][$i] = array(
  2249.                                 'id' => $item->getId(),
  2250.                                 'serviceCatId' => $item->getServiceCatId(),
  2251.                                 'serviceName' => $item->getName(),
  2252.                                 'serviceType' => 'Otros',
  2253.                                 'date' => $dateServ,
  2254.                                 'qty' => $unitsServ,
  2255.                                 'iva' => $item->getIva(),
  2256.                                 'pax' => $item->getPax(),
  2257.                                 'precioUnit' => $subnetoUnit,
  2258.                                 'subneto' => $subneto,
  2259.                                 'subtotal' => $subtotal,
  2260.                             );
  2261.                             break;
  2263.                         case 13: //Transport
  2264.                             $pax = $item->getPax();
  2265.                             if (empty($pax) or $pax == "0") {
  2266.                                 $pax = 1;
  2267.                             }
  2269.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2270.                             if ($days > 1) {
  2271.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2272.                             } else {
  2273.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2274.                             }
  2276.                             $unitsServ = $item->getUnits();
  2277.                             if (empty($unitsServ) or $unitsServ == "0") {
  2278.                                 $unitsServ = 1;
  2279.                             }
  2281.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2282.                             $subnetoUnit = $subneto;
  2283.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2285.                             $data_supplier['service'][$i] = array(
  2286.                                 'id' => $item->getId(),
  2287.                                 'serviceCatId' => $item->getServiceCatId(),
  2288.                                 'serviceName' => $item->getName(),
  2289.                                 'serviceType' => 'Transporte',
  2290.                                 'date' => $dateServ,
  2291.                                 'qty' => $unitsServ,
  2292.                                 'iva' => $item->getIva(),
  2293.                                 'pax' => $item->getPax(),
  2294.                                 'precioUnit' => $subnetoUnit,
  2295.                                 'subneto' => $subneto,
  2296.                                 'subtotal' => $subtotal,
  2297.                             );
  2298.                             break;
  2300.                         case 14: //Technology
  2301.                             $pax = $item->getPax();
  2302.                             if (empty($pax) or $pax == "0") {
  2303.                                 $pax = 1;
  2304.                             }
  2306. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2307.                             $days = 1;
  2308. //                        if ($days > 1){
  2309. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2310. //                        } else {
  2311. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2312. //                        }
  2313.                             $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2315.                             $unitsServ = $item->getUnits();
  2316.                             if (empty($unitsServ) or $unitsServ == "0") {
  2317.                                 $unitsServ = 1;
  2318.                             }
  2320.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2321.                             $subnetoUnit = $subneto;
  2322.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2324.                             $data_supplier['service'][$i] = array(
  2325.                                 'id' => $item->getId(),
  2326.                                 'serviceCatId' => $item->getServiceCatId(),
  2327.                                 'serviceName' => $item->getName(),
  2328.                                 'serviceType' => 'Tecnología',
  2329.                                 'date' => $dateServ,
  2330.                                 'qty' => $unitsServ,
  2331.                                 'iva' => $item->getIva(),
  2332.                                 'pax' => $item->getPax(),
  2333.                                 'precioUnit' => $subnetoUnit,
  2334.                                 'subneto' => $subneto,
  2335.                                 'subtotal' => $subtotal,
  2336.                             );
  2337.                             break;
  2339.                         case 15: //Assisstant
  2340.                             $pax = $item->getPax();
  2341.                             if (empty($pax) or $pax == "0") {
  2342.                                 $pax = 1;
  2343.                             }
  2345.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2346.                             if ($days > 1) {
  2347.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2348.                             } else {
  2349.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2350.                             }
  2352.                             $unitsServ = $item->getUnits();
  2353.                             if (empty($unitsServ) or $unitsServ == "0") {
  2354.                                 $unitsServ = 1;
  2355.                             }
  2357.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2358.                             $subnetoUnit = $subneto;
  2359.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2361.                             $data_supplier['service'][$i] = array(
  2362.                                 'id' => $item->getId(),
  2363.                                 'serviceCatId' => $item->getServiceCatId(),
  2364.                                 'serviceName' => $item->getName(),
  2365.                                 'serviceType' => 'Asistente',
  2366.                                 'date' => $dateServ,
  2367.                                 'qty' => $unitsServ,
  2368.                                 'iva' => $item->getIva(),
  2369.                                 'pax' => $item->getPax(),
  2370.                                 'precioUnit' => $subnetoUnit,
  2371.                                 'subneto' => $subneto,
  2372.                                 'subtotal' => $subtotal,
  2373.                             );
  2374.                             break;
  2376.                         case 16: //DDR
  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' => 'DDR',
  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.                         default:
  2414.                             break;
  2415.                     }
  2417.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  2418.                     $subtotal = round($subtotal, 2, PHP_ROUND_HALF_UP);
  2419.                     $neto = round($subneto, 2, PHP_ROUND_HALF_UP);
  2421.                     $arrayItems[] = array(
  2422.                         'type' => 'Service',
  2423.                         'name' => $item->getName(),
  2424.                         'amount' => $neto,
  2425.                         'iva' => $item->getIva(),
  2426.                         'total' => $subtotal,
  2427.                     );
  2429.                 }
  2431.                 switch ($item->getIva()) {
  2432.                     // Acumula IVA
  2433.                     case 21:
  2434.                         $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getIva() / 100));
  2435.                         break;
  2437.                     case 10:
  2438.                         $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getIva() / 100));
  2439.                         break;
  2441.                     case 0:
  2442.                         break;
  2444.                     default:
  2445.                         break;
  2446.                 }
  2447.             }
  2449.             $totales_neto_all = $totales_neto_all + $neto;
  2451.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2452.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  2453.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  2454.             $data_iva['ivaMontoDiez'] = round($data_iva['ivaMontoDiez'],2,PHP_ROUND_HALF_UP);
  2455.             // Acumula netos totales e IVA
  2457.             $service['neto'] = $service['neto'] + $neto;
  2458.             $service['sumSubT'] = $service['sumSubT'] + $subtotal;
  2459.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2460.             $service['neto'] = round($service['neto'],2,PHP_ROUND_HALF_UP);
  2461.             $service['sumSubT'] = round($service['sumSubT'],2,PHP_ROUND_HALF_UP);
  2463.             $i++;
  2464.         }
  2466.         $data_supplier['serviceSubTotal'] = array(
  2467.             'neto' => $service['neto'],
  2468.             'sumSubT' => $service['sumSubT'],
  2469.         );
  2470.         $currency = '€';
  2471.         $totales_total = $totales_neto_all + $data_iva['ivaMontoVeintiUno'] + $data_iva['ivaMontoDiez'];
  2472.         if (!empty($payments)) {
  2473.             $amount_pay = $data_supplier['paymentSubTotal']['sumSubT'];
  2474.         } else {
  2475.             $amount_pay = 0;
  2476.         }
  2477.         $totales_all = $totales_total - $amount_pay;
  2479.         if (empty($dateDocument)){
  2480.             $dateDocument = new DateTime('now');
  2481.         }
  2483.         $data = array(
  2484.             'id' => $fileId,
  2485.             'type' => $type,
  2486. //            'type' => '',
  2487.             'number' => $number,
  2488. //            'prefix' => $prefix,
  2489.             'prefix' => 'MDV-'.(new DateTime('now'))->format('dmy').'-'.$invoiceId,
  2490.             'date' => $dateDocument,
  2491.             'file' => $file,
  2492.             'token' => $file->getAccessKey(),
  2493.             'company' => $company,
  2494.             'clients' => $client,
  2495.             'arrayItems' => $arrayItems,
  2496.             'datasupplier' => $data_supplier,
  2497.             'currency' => $currency,
  2498.             'totales_neto' => $totales_neto_all,
  2499.             'bases_imponibles' => $data_iva,
  2500.             'totales' => $totales_total,
  2501.             'balance' => $totales_all,
  2502.             'paymentInvoice' => $amount_pay,
  2503.         );
  2504.         return $data;
  2505.     }
  2507.     // Replicar cambios entre FileController y ProductsFilesController
  2508.     private function calculosFile($id, $arrayBools, $number, $type)
  2509.     {
  2510.         // $id Id del Expediente (File)
  2511.         // $arrayBool arreglo de logicos
  2512.         // $number  *********************
  2513.         // $type tipo de calculos a realizar (edicion de expediente, factura, factura de deposito, proforma)
  2516.         $em = $this->getDoctrine()->getManager();
  2517.         $file = $em->getRepository(MdvFiles::class)->findOneById($id);
  2518.         $items = $em->getRepository(MdvProductFile::class)->findByFileId($file->getId());
  2519.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('3');
  2520.         $client = $em->getRepository(Client::class)->findById($file->getClient());
  2521.         if (!empty($client)){
  2522.             $city = ($em->getRepository(Cities::class)->findOneById($client[0]->getPopulation()));
  2523.             $client[0]->setPopulation($city);
  2524.             $region = ($em->getRepository(Regions::class)->findOneById($client[0]->getRegion()));
  2525.             $client[0]->setRegion($region);
  2526.             $country = ($em->getRepository(Country::class)->findOneById($client[0]->getCountry()));
  2527.             $client[0]->setCountry($country);
  2528.         } else {
  2529.             $client[0] = new Client();
  2530.             $client[0]->setName('');
  2531.             $client[0]->setTitle('');
  2532.             $client[0]->setIdDocument('');
  2533.             $client[0]->setPopulation('');
  2534.             $client[0]->setRegion('');
  2535.             $client[0]->setCountry('');
  2536.         }
  2538.         // Acumuladores de los calculos
  2539.         $totales_neto_all = 0;
  2540.         $data_iva = array(
  2541.             'iva' => 21,
  2542.             'ivaMontoVeintiUno' => 0,
  2543.             'ivaMontoDiez' => 0,
  2544.             'ivaMontoCero' => 0,
  2545.         );
  2547.         //INICIO: Determinamos el numero de factura o proforma
  2548.         if (substr($number,0,1) == 'I'){
  2549.             // Es una Factura
  2551.             $numberInvoiceOrProforma = substr($number,1);
  2552.             $number = $numberInvoiceOrProforma;
  2553. //            $number = $em->getRepository('DevelupBundle:FileInvoice')->findOneById($number);
  2554. //            $number = $number->getNumber();
  2555.             $type = 'Invoice';
  2557.         } else {
  2558.             // Es una Proforma
  2560.             $numberInvoiceOrProforma = substr($number,1);
  2561.             $number = $numberInvoiceOrProforma;
  2562. //            $number = $em->getRepository('DevelupBundle:FileProforma')->findOneById($number);
  2563. //            $number = $number->getPrefix().$number->getReservationId();
  2564.             $type = 'Proforma';
  2565.         }
  2566.         //FIN: Determinamos el numero de factura o proforma
  2568.         // Buscamos las salas reservadas, pagos y servicios para el evento
  2570.         $arrayItems = array();
  2571.         $fileProducts = array();
  2572.         if (!empty($arrayBools['lounge'])) {
  2573.             foreach ($arrayBools['lounge'] as $key => $item) {
  2574.                 if ($item == 'true') {
  2575. //                    $fileProducts[] = $em->getRepository('DevelupBundle:ReservationLoungeSimple')->findOneById($key);
  2576.                 }
  2577.             }
  2578.         }
  2580.         $payments = array();
  2581.         if (!empty($arrayBools['payment'])) {
  2582.             foreach ($arrayBools['payment'] as $key => $item) {
  2583.                 if ($item == 'true') {
  2584. //                    $payments[] = $em->getRepository('DevelupBundle:ReservationPaymentsClient')->findOneById($key);
  2585.                 }
  2586.             }
  2587.         }
  2589.         $services = array();
  2590.         if (!empty($arrayBools['service'])) {
  2591.             foreach ($arrayBools['service'] as $key => $item) {
  2592.                 if ($item == 'true') {
  2593. //                    $services[] = $em->getRepository('DevelupBundle:ReservationService')->findOneById($key);
  2594.                 }
  2595.             }
  2596.         }
  2598.         $data_supplier = array();
  2599.         $i = 0;
  2601.         $iva = '21';            // Esteban Rincon: "Por Ley de localización del impuesto, siempre será un 21%"
  2602.         $pax = '-';
  2603.         $qty = '1';
  2604.         $product = array(
  2605.             'neto' => 0,
  2606.             'sumSubT' => 0,
  2607.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  2609.         $service = array(
  2610.             'neto' => 0,
  2611.             'sumSubT' => 0,
  2612.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  2614.         if (empty($items)){
  2615.             $data_supplier['product'][0] = null;
  2616.         }
  2618.         foreach ($items as $item){
  2619.             $days = '1';
  2621.             if (!empty($item->getUnits())){
  2622.                 $qty = $item->getUnits();
  2623.             }
  2625.             if (!empty($item->getDays())){
  2626.                 $days = $item->getDays();
  2627.             }
  2629.             if (is_null($item->getServicePrice()) or empty($item->getServicePrice())){
  2630.                 $subtotal = 0;
  2631.                 $neto = 0;
  2632.                 $subtotalProduct = 0;
  2633.             } else {
  2635. //                $subtotalProduct = $item->getServicePrice() * 1.21;
  2636.                 $subtotalProduct = $item->getSubTotalPrice() * 1.21;
  2637. //                $subneto = $item->getServicePrice();
  2638.                 $subneto = $item->getSubTotalPrice();
  2640.                 $subtotal =  $subtotalProduct;
  2641.                 $neto =  $subneto;
  2643.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  2644.                 $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  2645.                 $neto = round($neto,2,PHP_ROUND_HALF_UP);
  2647.                 $arrayItems[] = array(
  2648.                     'type' => 'Product',
  2649.                     'name' => $item->getProductName(),
  2650.                     'amount' => $neto,
  2651.                     'iva' => '21',
  2652.                     'total' => $subtotal,
  2653.                 );
  2654.             }
  2656.             // Acumula netos totales e IVA
  2657.             $totales_neto_all = $totales_neto_all + $neto;
  2658.             $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * 0.21);
  2659.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2660.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  2661.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  2662.             // Acumula netos totales e IVA
  2664.             $product['neto'] = $product['neto'] + $neto;
  2665.             $product['sumSubT'] = $product['sumSubT'] + $subtotal;
  2666.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2667.             $product['neto'] = round($product['neto'],2,PHP_ROUND_HALF_UP);
  2668.             $product['sumSubT'] = round($product['sumSubT'],2,PHP_ROUND_HALF_UP);
  2670.             $data_supplier['product'][$i] = array (
  2671.                 'id' => $item->getId(),
  2672.                 'productName' => $item->getProductName(),
  2673.                 'description' => $item->getDescription(),
  2674.                 'productId' => $item->getProductId(),
  2675.                 'dateStart' => $item->getDateStart(),
  2676.                 'dateEnd' => $item->getDateEnd(),
  2677.                 'servicePrice' => $item->getServicePrice(),
  2678.                 'subTotalPrice' => $item->getSubTotalPrice(),
  2679.                 'subtotalProduct' => $subtotalProduct,
  2680.                 'iva' => $iva,
  2681.                 'pax' => $pax,
  2682.                 'qty' => $qty,
  2683.                 'days' => $days,
  2684.                 'type' => $item->getType(),
  2685.                 'subtotal' => $subtotal,
  2686.             );
  2687.             $i++;
  2688.         }
  2690.         $data_supplier['productSubTotal'] = array(
  2691.             'neto' => $product['neto'],
  2692.             'sumSubT' => $product['sumSubT'],
  2693.         );
  2695.         $payment = array(
  2696.             'sumSubT' => 0,
  2697.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  2699.         $i = 0;
  2700.         foreach ($payments as $item){
  2702.             $payment['sumSubT'] = $payment['sumSubT'] + $item->getAmountTotal();
  2703.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2704.             $payment['sumSubT'] = round($payment['sumSubT'],2,PHP_ROUND_HALF_UP);
  2706.             $data_supplier['payment'][$i] = array (
  2707.                 'id' => $item->getId(),
  2708.                 'amount' => $item->getAmount(),
  2709.                 'amountTotal' => $item->getAmountTotal(),
  2710.                 'vat' => $item->getVat(),
  2711.                 'datePayAt' => $item->getDatePayAt(),
  2712.                 'wayToPay' => $item->getWayToPay(),
  2713.             );
  2715.             $arrayItems[] = array(
  2716.                 'type' => 'Payment',
  2717.                 'name' => $item->getWayToPay(),
  2718.                 'amount' => $item->getAmount(),
  2719.                 'total' => $item->getAmountTotal(),
  2720.                 'iva' => $item->getVat(),
  2721. //                    'iva' => '',
  2722. //                    'total' => $item->getAmount(),
  2723.             );
  2725.             $i++;
  2726.         }
  2728.         if (!empty($payments)) {
  2729.             $data_supplier['paymentSubTotal'] = array(
  2730.                 'sumSubT' => $payment['sumSubT'],
  2731.             );
  2732.         }
  2734.         foreach ($services as $item){
  2735.             if (is_null($item->getPrice()) or empty($item->getPrice())){
  2736.                 $subtotal = 0;
  2737.                 $neto = 0;
  2738.                 $subtotalService = 0;
  2740.             } else {
  2741.                 $subtotalService = $item->getPrice();
  2742.                 $subneto = $item->getPrice();
  2744.                 // Commission
  2745.                 if ($item->getOpCommission()=='1'){
  2746.                     $subtotalService = $subtotalService * (1 + ($item->getCommission()/100));
  2747.                     $subneto = $subneto  * (1 + ($item->getCommission()/100));
  2748.                 } else {
  2749.                     $subtotalService = $subtotalService * (1 - ($item->getCommission()/100));
  2750.                     $subneto = $subneto * (1 - ($item->getCommission()/100));
  2751.                 }
  2753.                 // Over
  2754.                 if ($item->getOpOver()=='1'){
  2755.                     $subtotalService = $subtotalService + $item->getOver();
  2756.                     $subneto = $subneto + $item->getOver();
  2757.                 } else {
  2758.                     $subtotalService = $subtotalService - $item->getOver();
  2759.                     $subneto = $subneto - $item->getOver();
  2760.                 }
  2762.                 // IVA
  2763.                 if ($item->getOpIva()=='1'){
  2764.                     $subtotalService = $subtotalService * (1 + ($item->getIva()/100));
  2765.                 } else {
  2766.                     $subtotalService = $item->getPrice();
  2767.                     $subneto = ($subneto * 100) / (100 + $item->getIva());
  2768.                 }
  2770.                 switch ($item->getServiceCatId()){
  2771.                     case 1: // Alojamiento
  2772.                         // el numero de noches $numNoches; precio unitario $subneto
  2773.                         $numNoches = (($item->getDateOutAt())->diff($item->getDateInAt()))->days;
  2774.                         // La personas no afectan este calculo
  2775.                         $subtotal = $subtotalService * $numNoches * $item->getUnits();
  2776.                         $subnetoUnit = $subneto;
  2778.                         $subneto = $subneto * $numNoches * $item->getUnits();
  2780.                         $data_supplier['service'][$i] = array (
  2781.                             'id' => $item->getId(),
  2782.                             'serviceCatId' => $item->getServiceCatId(),
  2783.                             'serviceName' => $item->getName(),
  2784.                             'serviceType' => 'Hotel',
  2785.                             'date' => ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y'),
  2786.                             'qty' => $item->getUnits(),
  2787.                             'iva' => $item->getIva(),
  2788.                             'pax' => '-',
  2789.                             'precioUnit' => $subnetoUnit,
  2790.                             'subneto' => $subneto,
  2791.                             'subtotal' => $subtotal,
  2792.                         );
  2793.                         break;
  2795.                     case 2: //Actividades
  2796.                         // El número de personas es considerado en el calculo
  2797.                         $pax = $item->getPax();
  2798.                         if (empty($pax) or $pax == "0") {
  2799.                             $pax = 1;
  2800.                         }
  2801.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2803.                         if ($days > 1){
  2804.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2805.                         } else {
  2806.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2807.                         }
  2809.                         $subtotal = $subtotalService * $days * $item->getUnits();
  2810.                         $subnetoUnit = $subneto;
  2811.                         $subneto = $subneto * $days * $item->getUnits();
  2813.                         $data_supplier['service'][$i] = array (
  2814.                             'id' => $item->getId(),
  2815.                             'serviceCatId' => $item->getServiceCatId(),
  2816.                             'serviceName' => $item->getName(),
  2817.                             'serviceType' => 'Actividad',
  2818.                             'date' => $dateServ,
  2819.                             'qty' => $item->getUnits(),
  2820.                             'iva' => $item->getIva(),
  2821.                             'pax' => $item->getPax(),
  2822.                             'precioUnit' => $subnetoUnit,
  2823.                             'subneto' => $subneto,
  2824.                             'subtotal' => $subtotal,
  2825.                         );
  2826.                         break;
  2828.                     case 3: // AV
  2829.                         $pax = $item->getPax();
  2830.                         if (empty($pax) or $pax == "0") {
  2831.                             $pax = 1;
  2832.                         }
  2834.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2835.                         if ($days > 1){
  2836.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2837.                         } else {
  2838.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2839.                         }
  2841.                         $unitsServ = $item->getUnits();
  2842.                         if (empty($unitsServ) or $unitsServ == "0") {
  2843.                             $unitsServ = 1;
  2844.                         }
  2846.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2847.                         $subnetoUnit = $subneto;
  2848.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2850.                         $data_supplier['service'][$i] = array (
  2851.                             'id' => $item->getId(),
  2852.                             'serviceCatId' => $item->getServiceCatId(),
  2853.                             'serviceName' => $item->getName(),
  2854.                             'serviceType' => 'AV',
  2855.                             'date' => $dateServ,
  2856.                             'qty' => $unitsServ,
  2857.                             'iva' => $item->getIva(),
  2858.                             'pax' => $item->getPax(),
  2859.                             'precioUnit' => $subnetoUnit,
  2860.                             'subneto' => $subneto,
  2861.                             'subtotal' => $subtotal,
  2862.                         );
  2863.                         break;
  2865.                     case 4: //Creative
  2866.                         $pax = $item->getPax();
  2867.                         if (empty($pax) or $pax == "0") {
  2868.                             $pax = 1;
  2869.                         }
  2871.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2872.                         if ($days > 1){
  2873.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2874.                         } else {
  2875.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2876.                         }
  2878.                         $unitsServ = $item->getUnits();
  2879.                         if (empty($unitsServ) or $unitsServ == "0") {
  2880.                             $unitsServ = 1;
  2881.                         }
  2883.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2884.                         $subnetoUnit = $subneto;
  2885.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2887.                         $data_supplier['service'][$i] = array (
  2888.                             'id' => $item->getId(),
  2889.                             'serviceCatId' => $item->getServiceCatId(),
  2890.                             'serviceName' => $item->getName(),
  2891.                             'serviceType' => 'Creativo',
  2892.                             'date' => $dateServ,
  2893.                             'qty' => $unitsServ,
  2894.                             'iva' => $item->getIva(),
  2895.                             'pax' => $item->getPax(),
  2896.                             'precioUnit' => $subnetoUnit,
  2897.                             'subneto' => $subneto,
  2898.                             'subtotal' => $subtotal,
  2899.                         );
  2900.                         break;
  2902.                     case 5: //Cruise
  2903.                         $pax = $item->getPax();
  2904.                         if (empty($pax) or $pax == "0") {
  2905.                             $pax = 1;
  2906.                         }
  2908.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days);
  2909.                         if ($days > 1){
  2910.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2911.                         } else {
  2912.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2913.                         }
  2915.                         $unitsServ = $item->getUnits();
  2916.                         if (empty($unitsServ) or $unitsServ == "0") {
  2917.                             $unitsServ = 1;
  2918.                         }
  2920.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2921.                         $subnetoUnit = $subneto;
  2922.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2924.                         $data_supplier['service'][$i] = array (
  2925.                             'id' => $item->getId(),
  2926.                             'serviceCatId' => $item->getServiceCatId(),
  2927.                             'serviceName' => $item->getName(),
  2928.                             'serviceType' => 'Crucero',
  2929.                             'date' => $dateServ,
  2930.                             'qty' => $unitsServ,
  2931.                             'iva' => $item->getIva(),
  2932.                             'pax' => $item->getPax(),
  2933.                             'precioUnit' => $subnetoUnit,
  2934.                             'subneto' => $subneto,
  2935.                             'subtotal' => $subtotal,
  2936.                         );
  2937.                         break;
  2939.                     case 6: //Entertaiment
  2940.                         $pax = $item->getPax();
  2941.                         if (empty($pax) or $pax == "0") {
  2942.                             $pax = 1;
  2943.                         }
  2945.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2946.                         if ($days > 1){
  2947.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2948.                         } else {
  2949.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2950.                         }
  2952.                         $unitsServ = $item->getUnits();
  2953.                         if (empty($unitsServ) or $unitsServ == "0") {
  2954.                             $unitsServ = 1;
  2955.                         }
  2957.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2958.                         $subnetoUnit = $subneto;
  2959.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2961.                         $data_supplier['service'][$i] = array (
  2962.                             'id' => $item->getId(),
  2963.                             'serviceCatId' => $item->getServiceCatId(),
  2964.                             'serviceName' => $item->getName(),
  2965.                             'serviceType' => 'Entretenimiento',
  2966.                             'date' => $dateServ,
  2967.                             'qty' => $unitsServ,
  2968.                             'iva' => $item->getIva(),
  2969.                             'pax' => $item->getPax(),
  2970.                             'precioUnit' => $subnetoUnit,
  2971.                             'subneto' => $subneto,
  2972.                             'subtotal' => $subtotal,
  2973.                         );
  2974.                         break;
  2976.                     case 7: // Gifts
  2977.                         $pax = $item->getPax();
  2978.                         if (empty($pax) or $pax == "0") {
  2979.                             $pax = 1;
  2980.                         }
  2982. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2983.                         $days = 1;
  2984.                         if ($days > 1){
  2985.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2986.                         } else {
  2987.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2988.                         }
  2990.                         $unitsServ = $item->getUnits();
  2991.                         if (empty($unitsServ) or $unitsServ == "0") {
  2992.                             $unitsServ = 1;
  2993.                         }
  2995.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2996.                         $subnetoUnit = $subneto;
  2997.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2999.                         $data_supplier['service'][$i] = array (
  3000.                             'id' => $item->getId(),
  3001.                             'serviceCatId' => $item->getServiceCatId(),
  3002.                             'serviceName' => $item->getName(),
  3003.                             'serviceType' => 'Regalos',
  3004.                             'date' => $dateServ,
  3005.                             'qty' => $unitsServ,
  3006.                             'iva' => $item->getIva(),
  3007.                             'pax' => $item->getPax(),
  3008.                             'precioUnit' => $subnetoUnit,
  3009.                             'subneto' => $subneto,
  3010.                             'subtotal' => $subtotal,
  3011.                         );
  3012.                         break;
  3014.                     case 8: //Guide
  3015.                         $pax = $item->getPax();
  3016.                         if (empty($pax) or $pax == "0") {
  3017.                             $pax = 1;
  3018.                         }
  3020.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3021.                         if ($days > 1){
  3022.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3023.                         } else {
  3024.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3025.                         }
  3027.                         $unitsServ = $item->getUnits();
  3028.                         if (empty($unitsServ) or $unitsServ == "0") {
  3029.                             $unitsServ = 1;
  3030.                         }
  3032.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3033.                         $subnetoUnit = $subneto;
  3034.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3036.                         $data_supplier['service'][$i] = array (
  3037.                             'id' => $item->getId(),
  3038.                             'serviceCatId' => $item->getServiceCatId(),
  3039.                             'serviceName' => $item->getName(),
  3040.                             'serviceType' => 'Regalos',
  3041.                             'date' => $dateServ,
  3042.                             'qty' => $unitsServ,
  3043.                             'iva' => $item->getIva(),
  3044.                             'pax' => $item->getPax(),
  3045.                             'precioUnit' => $subnetoUnit,
  3046.                             'subneto' => $subneto,
  3047.                             'subtotal' => $subtotal,
  3048.                         );
  3049.                         break;
  3051.                     case 9: //Itineraries
  3052.                         $pax = $item->getPax();
  3053.                         if (empty($pax) or $pax == "0") {
  3054.                             $pax = 1;
  3055.                         }
  3057.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3058.                         if ($days > 1){
  3059.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3060.                         } else {
  3061.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3062.                         }
  3064.                         $unitsServ = $item->getUnits();
  3065.                         if (empty($unitsServ) or $unitsServ == "0") {
  3066.                             $unitsServ = 1;
  3067.                         }
  3069.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3070.                         $subnetoUnit = $subneto;
  3071.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3073.                         $data_supplier['service'][$i] = array (
  3074.                             'id' => $item->getId(),
  3075.                             'serviceCatId' => $item->getServiceCatId(),
  3076.                             'serviceName' => $item->getName(),
  3077.                             'serviceType' => 'Itinerarios',
  3078.                             'date' => $dateServ,
  3079.                             'qty' => $unitsServ,
  3080.                             'iva' => $item->getIva(),
  3081.                             'pax' => $item->getPax(),
  3082.                             'precioUnit' => $subnetoUnit,
  3083.                             'subneto' => $subneto,
  3084.                             'subtotal' => $subtotal,
  3085.                         );
  3086.                         break;
  3088.                     case 10: //Lounge  -- No Aplica
  3089. //                        $pax = $item->getPax();
  3090. //                        if (empty($pax) or $pax == "0") {
  3091. //                            $pax = 1;
  3092. //                        }
  3093. //
  3094. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3095. //                        if ($days > 1){
  3096. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3097. //                        } else {
  3098. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3099. //                        }
  3100. //
  3101. //                        $unitsServ = $item->getUnits();
  3102. //                        if (empty($unitsServ) or $unitsServ == "0") {
  3103. //                            $unitsServ = 1;
  3104. //                        }
  3105. //
  3106. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3107. //                        $subnetoUnit = $subneto;
  3108. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  3109. //
  3110. //                        $data_supplier['service'][$i] = array (
  3111. //                            'id' => $item->getId(),
  3112. //                            'serviceCatId' => $item->getServiceCatId(),
  3113. //                            'serviceName' => $item->getName(),
  3114. //                            'serviceType' => 'Itinerarios',
  3115. //                            'date' => $dateServ,
  3116. //                            'qty' => $unitsServ,
  3117. //                            'iva' => $item->getIva(),
  3118. //                            'pax' => $item->getPax(),
  3119. //                            'precioUnit' => $subnetoUnit,
  3120. //                            'subneto' => $subneto,
  3121. //                            'subtotal' => $subtotal,
  3122. //                        );
  3123.                         break;
  3125.                     case 11: //Menu
  3126.                         $pax = $item->getPax();
  3127.                         if (empty($pax) or $pax == "0") {
  3128.                             $pax = 1;
  3129.                         }
  3131.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3132.                         if ($days > 1){
  3133.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3134.                         } else {
  3135.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3136.                         }
  3138.                         $unitsServ = $item->getUnits();
  3139.                         if (empty($unitsServ) or $unitsServ == "0") {
  3140.                             $unitsServ = 1;
  3141.                         }
  3143.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3144.                         $subnetoUnit = $subneto;
  3145.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3147.                         $data_supplier['service'][$i] = array (
  3148.                             'id' => $item->getId(),
  3149.                             'serviceCatId' => $item->getServiceCatId(),
  3150.                             'serviceName' => $item->getName(),
  3151.                             'serviceType' => 'Menú',
  3152.                             'date' => $dateServ,
  3153.                             'qty' => $unitsServ,
  3154.                             'iva' => $item->getIva(),
  3155.                             'pax' => $item->getPax(),
  3156.                             'precioUnit' => $subnetoUnit,
  3157.                             'subneto' => $subneto,
  3158.                             'subtotal' => $subtotal,
  3159.                         );
  3160.                         break;
  3162.                     case 12: //Others
  3163.                         $pax = $item->getPax();
  3164.                         if (empty($pax) or $pax == "0") {
  3165.                             $pax = 1;
  3166.                         }
  3168.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3169.                         if ($days > 1){
  3170.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3171.                         } else {
  3172.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3173.                         }
  3175.                         $unitsServ = $item->getUnits();
  3176.                         if (empty($unitsServ) or $unitsServ == "0") {
  3177.                             $unitsServ = 1;
  3178.                         }
  3180.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3181.                         $subnetoUnit = $subneto;
  3182.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3184.                         $data_supplier['service'][$i] = array (
  3185.                             'id' => $item->getId(),
  3186.                             'serviceCatId' => $item->getServiceCatId(),
  3187.                             'serviceName' => $item->getName(),
  3188.                             'serviceType' => 'Otros',
  3189.                             'date' => $dateServ,
  3190.                             'qty' => $unitsServ,
  3191.                             'iva' => $item->getIva(),
  3192.                             'pax' => $item->getPax(),
  3193.                             'precioUnit' => $subnetoUnit,
  3194.                             'subneto' => $subneto,
  3195.                             'subtotal' => $subtotal,
  3196.                         );
  3197.                         break;
  3199.                     case 13: //Transport
  3200.                         $pax = $item->getPax();
  3201.                         if (empty($pax) or $pax == "0") {
  3202.                             $pax = 1;
  3203.                         }
  3205.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3206.                         if ($days > 1){
  3207.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3208.                         } else {
  3209.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3210.                         }
  3212.                         $unitsServ = $item->getUnits();
  3213.                         if (empty($unitsServ) or $unitsServ == "0") {
  3214.                             $unitsServ = 1;
  3215.                         }
  3217.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3218.                         $subnetoUnit = $subneto;
  3219.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3221.                         $data_supplier['service'][$i] = array (
  3222.                             'id' => $item->getId(),
  3223.                             'serviceCatId' => $item->getServiceCatId(),
  3224.                             'serviceName' => $item->getName(),
  3225.                             'serviceType' => 'Transporte',
  3226.                             'date' => $dateServ,
  3227.                             'qty' => $unitsServ,
  3228.                             'iva' => $item->getIva(),
  3229.                             'pax' => $item->getPax(),
  3230.                             'precioUnit' => $subnetoUnit,
  3231.                             'subneto' => $subneto,
  3232.                             'subtotal' => $subtotal,
  3233.                         );
  3234.                         break;
  3236.                     case 14: //Technology
  3237.                         $pax = $item->getPax();
  3238.                         if (empty($pax) or $pax == "0") {
  3239.                             $pax = 1;
  3240.                         }
  3242. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3243.                         $days = 1;
  3244. //                        if ($days > 1){
  3245. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3246. //                        } else {
  3247. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3248. //                        }
  3249.                         $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3251.                         $unitsServ = $item->getUnits();
  3252.                         if (empty($unitsServ) or $unitsServ == "0") {
  3253.                             $unitsServ = 1;
  3254.                         }
  3256.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3257.                         $subnetoUnit = $subneto;
  3258.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3260.                         $data_supplier['service'][$i] = array (
  3261.                             'id' => $item->getId(),
  3262.                             'serviceCatId' => $item->getServiceCatId(),
  3263.                             'serviceName' => $item->getName(),
  3264.                             'serviceType' => 'Tecnología',
  3265.                             'date' => $dateServ,
  3266.                             'qty' => $unitsServ,
  3267.                             'iva' => $item->getIva(),
  3268.                             'pax' => $item->getPax(),
  3269.                             'precioUnit' => $subnetoUnit,
  3270.                             'subneto' => $subneto,
  3271.                             'subtotal' => $subtotal,
  3272.                         );
  3273.                         break;
  3275.                     case 15: //Assisstant
  3276.                         $pax = $item->getPax();
  3277.                         if (empty($pax) or $pax == "0") {
  3278.                             $pax = 1;
  3279.                         }
  3281.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3282.                         if ($days > 1){
  3283.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3284.                         } else {
  3285.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3286.                         }
  3288.                         $unitsServ = $item->getUnits();
  3289.                         if (empty($unitsServ) or $unitsServ == "0") {
  3290.                             $unitsServ = 1;
  3291.                         }
  3293.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3294.                         $subnetoUnit = $subneto;
  3295.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3297.                         $data_supplier['service'][$i] = array (
  3298.                             'id' => $item->getId(),
  3299.                             'serviceCatId' => $item->getServiceCatId(),
  3300.                             'serviceName' => $item->getName(),
  3301.                             'serviceType' => 'Asistente',
  3302.                             'date' => $dateServ,
  3303.                             'qty' => $unitsServ,
  3304.                             'iva' => $item->getIva(),
  3305.                             'pax' => $item->getPax(),
  3306.                             'precioUnit' => $subnetoUnit,
  3307.                             'subneto' => $subneto,
  3308.                             'subtotal' => $subtotal,
  3309.                         );
  3310.                         break;
  3312.                     case 16: //DDR
  3313.                         $pax = $item->getPax();
  3314.                         if (empty($pax) or $pax == "0") {
  3315.                             $pax = 1;
  3316.                         }
  3318.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3319.                         if ($days > 1){
  3320.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3321.                         } else {
  3322.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3323.                         }
  3325.                         $unitsServ = $item->getUnits();
  3326.                         if (empty($unitsServ) or $unitsServ == "0") {
  3327.                             $unitsServ = 1;
  3328.                         }
  3330.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3331.                         $subnetoUnit = $subneto;
  3332.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3334.                         $data_supplier['service'][$i] = array (
  3335.                             'id' => $item->getId(),
  3336.                             'serviceCatId' => $item->getServiceCatId(),
  3337.                             'serviceName' => $item->getName(),
  3338.                             'serviceType' => 'DDR',
  3339.                             'date' => $dateServ,
  3340.                             'qty' => $unitsServ,
  3341.                             'iva' => $item->getIva(),
  3342.                             'pax' => $item->getPax(),
  3343.                             'precioUnit' => $subnetoUnit,
  3344.                             'subneto' => $subneto,
  3345.                             'subtotal' => $subtotal,
  3346.                         );
  3347.                         break;
  3349.                     default:
  3350.                         break;
  3351.                 }
  3353.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  3354.                 $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  3355.                 $neto = round($subneto,2,PHP_ROUND_HALF_UP);
  3357.                 $arrayItems[] = array(
  3358.                     'type' => 'Service',
  3359.                     'name' => $item->getName(),
  3360.                     'amount' => $neto,
  3361.                     'iva' => $item->getIva(),
  3362.                     'total' => $subtotal,
  3363.                 );
  3365.             }
  3367.             switch ($item->getIva()){
  3368.                 // Acumula IVA
  3369.                 case 21:
  3370.                     $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getIva()/100));
  3371.                     break;
  3373.                 case 10:
  3374.                     $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getIva()/100));
  3375.                     break;
  3377.                 case 0:
  3378.                     break;
  3380.                 default:
  3381.                     break;
  3383.             }
  3385.             $totales_neto_all = $totales_neto_all + $neto;
  3387.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  3388.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  3389.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  3390.             $data_iva['ivaMontoDiez'] = round($data_iva['ivaMontoDiez'],2,PHP_ROUND_HALF_UP);
  3391.             // Acumula netos totales e IVA
  3393.             $service['neto'] = $service['neto'] + $neto;
  3394.             $service['sumSubT'] = $service['sumSubT'] + $subtotal;
  3395.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  3396.             $service['neto'] = round($service['neto'],2,PHP_ROUND_HALF_UP);
  3397.             $service['sumSubT'] = round($service['sumSubT'],2,PHP_ROUND_HALF_UP);
  3399.             $i++;
  3400.         }
  3402.         $data_supplier['serviceSubTotal'] = array(
  3403.             'neto' => $service['neto'],
  3404.             'sumSubT' => $service['sumSubT'],
  3405.         );
  3406.         $currency = '€';
  3407.         $totales_total = $totales_neto_all + $data_iva['ivaMontoVeintiUno'] + $data_iva['ivaMontoDiez'];
  3408.         if (!empty($payments)) {
  3409.             $amount_pay = $data_supplier['paymentSubTotal']['sumSubT'];
  3410.         } else {
  3411.             $amount_pay = 0;
  3412.         }
  3413.         $totales_all = $totales_total - $amount_pay;
  3415.         if ($type == 'Invoice'){
  3416.             $em->clear();   // sin este clear se producia error al guardar
  3417.             $newInvoice = $em->getRepository(MdvDocInvoice::class)->findOneById($numberInvoiceOrProforma);
  3418.             $newInvoice->setBalance($totales_all);
  3419.             $em->persist($newInvoice);
  3420.             $em->flush();
  3421.         }
  3423.         $data = array(
  3424.             'id' => $id,
  3425.             'type' => $type,
  3426.             'number' => $number,
  3427.             'prefix' => 'MDV-'.(new DateTime('now'))->format('dmy').'-',
  3428.             'date' => new DateTime('now'),
  3429.             'file' => $file,
  3430. //            'token' => $reservation->getAccessKey(),
  3431.             'company' => $company,
  3432.             'clients' => $client,
  3433.             'arrayItems' => $arrayItems,
  3434.             'datasupplier' => $data_supplier,
  3435.             'currency' => $currency,
  3436.             'totales_neto' => $totales_neto_all,
  3437.             'bases_imponibles' => $data_iva,
  3438.             'totales' => $totales_total,
  3439.             'balance' => $totales_all,
  3440.             'paymentInvoice' => $amount_pay,
  3441.         );
  3443.         return $data;
  3444.     }
  3446.     private function sendTelegram ( $id, $text )
  3447.     {
  3448.         $em = $this->getDoctrine()->getManager();
  3449.         $telegUser = $em->getRepository(MdvTelegramUser::class)->findOneByUserId($id);
  3451.         if (empty($telegUser)){return true;}
  3453.         $parameters = array(
  3454.             'chat_id' => $telegUser->getChatId(),
  3455.             'text' => $text,
  3456.         );
  3458.         $bot_token = $telegUser->getBotToken();
  3459.         $url = "https://api.telegram.org/bot$bot_token/sendMessage";
  3461.         if (!$curl = curl_init()){
  3462.             exit();
  3463.         }
  3465.         curl_setopt($curl,CURLOPT_POST,true);
  3466.         curl_setopt($curl,CURLOPT_POSTFIELDS,$parameters);
  3467.         curl_setopt($curl,CURLOPT_URL,$url);
  3468.         curl_setopt($curl,CURLOPT_RETURNTRANSFER,true);
  3469.         $output = curl_exec($curl);
  3470.         curl_close($curl);
  3472.         return true;
  3473.     }
  3474. };