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

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.                         $service->setDateInAt(new \DateTime("now"));
  316.                         $service->setDateOutAt(new \DateTime("now"));
  317.                         $service->setDirectPayment(0);
  318.                         $service->setStatus('Pending');
  319.                         $service->setStatusinternal('Additional');
  320.                         $service->setPreCommission(null);
  321.                         $service->setPreIva(null);
  322.                         $service->setDateBlockLimit(null);
  323.                         $service->setOpCommission(1);
  324.                         $service->setOpOver(1);
  325.                         $service->setOpIva(1);
  326.                         $service->setBreakdown(0);
  327.                         $service->setIsFather(0);
  328.                         $service->setRank(1);
  329.                         $service->setOriginalopIva(1);
  330.                         $service->setOriginalIva(null);
  331.                         $service->setOriginalPrice(null);
  332.                         $service->setStatusRec('normal');
  333.                         $service->setAssistantId(null);
  334.                         $service->setCreatedId($user_id);
  335.                         $service->setUpdatedId($user_id);
  336.                         $service->setCreatedAt(new \DateTime("now"));
  337.                         $service->setUpdatedAt(new \DateTime("now"));
  339.                         $em->persist($service);
  340.                         $em->flush();
  342.                         // Se debe notificar por Telegram al agente de eventos
  343.                         $logTelegram = true;
  344.                     }
  346.                     //INICIO: Creamos una orden de hacer proforma
  348.                     //INICIO: Calculamos el ID de la proforma
  349.                     $numberToPrefix = $em->getRepository(MdvDocProforma::class)->findAll();
  350.                     if (empty($numberToPrefix)){
  351.                         $numberToPrefix = 0;
  352.                     } else {
  353.                         $numberToPrefix = end($numberToPrefix)->getId();
  354.                     }
  355.                     $numberToPrefix++;
  356.                     //FIN: Calculamos el ID de la proforma
  358.                     $order = new MdvBudgetToProforma();
  359.                     $order->setStatus('Pending');
  360.                     $order->setFileId($file->getId());
  361.                     $order->setProductFileId($item->getId());
  362.                     $order->setUserConfirmedId($proposal->getAgentId());
  363.                     $order->setUserConfirmedFullName($agentFullName);
  364.                     $order->setProposalTitle($proposalTitle);
  365.                     $order->setProformaId($numberToPrefix);
  367.                     $em->persist($order);
  368.                     $em->flush();
  369.                     //FIN: Creamos una orden de hacer proforma
  370.                 }
  372.                 //INICIO: Notificamos al agente por Telegram
  373.                 if ($logTelegram){
  374.                     //Buscamos todos los agentes del proposal
  375.                     $proposalAgents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($proposal->getId());
  377.                     //Buscamos el Destino
  378.                     $proposalDestino = $em->getRepository(Destination::class)->findOneById($control->getDestinoId());
  380.                     //Buscamos el agente de Develup
  381.                     $userData = $em->getRepository(User::class)->findOneById($user_id);
  383.                     if (!empty($proposalAgents)){
  384.                         if ((!empty($proposalAgents->getAgOne())) and (!($proposalAgents->getAgOne() == 0))){
  385.                             $this->sendTelegram($proposalAgents->getAgOne(),'1. PROPOSAL ACTUALIZADO DESDE DEVELUP __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: Develup __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  386.                             //d('entro en 1',$proposalAgents->getAgOne(), $proposalDestino->getTitle());
  387.                         }
  388.                         if ((!empty($proposalAgents->getAgTwo())) and (!($proposalAgents->getAgTwo() == 0))){
  389.                             $this->sendTelegram($proposalAgents->getAgTwo(),'2. PROPOSAL ACTUALIZADO DESDE DEVELUP __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: Develup __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  390.                             //d('entro en 2',$proposalAgents->getAgTwo(), $proposalDestino->getTitle());
  391.                         }
  392.                         if ((!empty($proposalAgents->getAgThree())) and (!($proposalAgents->getAgThree() == 0))){
  393.                             $this->sendTelegram($proposalAgents->getAgThree(),'3. PROPOSAL ACTUALIZADO DESDE DEVELUP __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: Develup __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  394.                             //d('entro en 3', $proposalAgents->getAgThree(), $proposalDestino->getTitle());
  395.                         }
  396.                         if ((!empty($proposalAgents->getAgFour())) and (!($proposalAgents->getAgFour() == 0))){
  397.                             $this->sendTelegram($proposalAgents->getAgFour(),'4. PROPOSAL ACTUALIZADO DESDE DEVELUP __ ID: '.$proposal->getId().' __ DESTINO: '.$proposalDestino->getTitle().' __ PROVEEDOR: Develup __ CONTACTO: '.$userData->getName().' '.$userData->getLastName());
  398.                             //d('entro en 4', $proposalAgents->getAgFour(), $proposalDestino->getTitle());
  399.                         }
  400.                     }
  401.                 }
  402.                 //FIN: Notificamos al agente por Telegram
  404.                 //INICIO: Creamos el presupuesto (proforma)
  406.                 $budToPro = $em->getRepository(MdvBudgetToProforma::class)->findByProformaId($numberToPrefix);
  408.                 //INICIO: Se agrupan por expediente (fileId)
  409.                 $proformas = array();
  410.                 foreach ($budToPro as $item){
  411.                     $proformas[$item->getFileId()][] = $item;
  412.                 }
  413.                 //FIN: Se agrupan por expediente (fileId)
  415.                 if (!empty($budToPro)){
  416.                     foreach ($proformas as $key => $elemento){
  417.                         //INICIO: Creamos las proformas
  419.                         $newProforma = new MdvDocProforma();
  420.                         $newProforma->setPrefix('MDV-' . (new DateTime('now'))->format('dmy') . '-' . $numberToPrefix . '-' . $key);
  421.                         $newProforma->setDateAt(new DateTime('now'));
  422.                         $newProforma->setFileId($key);
  423.                         $newProforma->setCreatedId($user_id);
  424.                         $newProforma->setUpdatedId($user_id);
  425.                         $newProforma->setCreatedAt(new DateTime('now'));
  426.                         $newProforma->setUpdatedAt(new DateTime('now'));
  428.                         $em->persist($newProforma);
  429.                         $em->flush();
  430.                         //FIN: Creamos las proformas
  432.                         foreach ($elemento as $item) {
  433.                             //$key es el id del expediente
  434. //                    $arrayIdPro[$numberToPrefix] = $item->getUserConfirmedId();             // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  436.                             //INICIO: Creamos los elemento que iran dentro de las proformas
  437.                             $itemProforma = new MdvDocProformaItems();
  438.                             $itemProforma->setType('PRODUCT');
  439.                             $itemProforma->setFileId($key);
  440.                             $itemProforma->setProformaId($newProforma->getId());
  441.                             $itemProforma->setControlId($item->getProductFileId());
  443.                             $em->persist($itemProforma);
  444.                             $em->flush();
  446.                             //INICIO: Confirmamos el BudToProforma
  447.                             $item->setStatus('Tosend');              // El elemento se ha pasado a la proforma, solo falta enviar
  448.                             $item->setProformaId($newProforma->getId());
  450.                             $em->persist($item);
  451.                             $em->flush();
  452.                             //FIN: Confirmamos el BudToProforma
  454.                             //FIN: Creamos los elemento que iran dentro de las proformas
  455.                         }
  456.                     }
  457.                 }
  458.                 //FIN: Creamos el presupuesto (proforma)
  461.                 // INICIO: Se envia al agente el presupuesto
  462.                 $budToPro = $em->getRepository(MdvBudgetToProforma::class)->findByStatus('Tosend');
  464.                 /* Obtengo usuario logueado */
  465.                 $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  466.                 $user_id = $user_logueado->getId();
  468.                 $arrayIdPro = array();          // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  470.                 //INICIO: Se agrupan por expediente (fileId)
  471.                 $proformas = array();
  472.                 foreach ($budToPro as $item){
  473.                     $proformas[$item->getFileId()][] = $item;
  474.                 }
  475.                 //FIN: Se agrupan por expediente (fileId)
  477.                 if (!empty($budToPro)){
  478.                     foreach ($proformas as $key => $elemento){
  479.                         //INICIO: Creamos las proformas
  481.                         //INICIO: Calculamos el ID de la proforma
  482. //                $numberToPrefix = $em->getRepository(MdvDocProforma::class)->findAll();
  483. //                if (empty($numberToPrefix)){
  484. //                    $numberToPrefix = 0;
  485. //                } else {
  486. //                    $numberToPrefix = end($numberToPrefix)->getId();
  487. //                }
  488. //                $numberToPrefix++;
  489. //                $numberToPrefix++;
  490.                         //FIN: Calculamos el ID de la proforma
  491. //d($proformas, $elemento);exit();
  492. //                $newProforma = new MdvDocProforma();
  493. //                $newProforma->setPrefix('MDV-' . (new DateTime('now'))->format('dmy') . '-' . $numberToPrefix . '-' . $key);
  494. //                $newProforma->setDateAt(new DateTime('now'));
  495. //                $newProforma->setFileId($key);
  496. //
  497. //                $newProforma->setCreatedId($user_id);
  498. //                $newProforma->setUpdatedId($user_id);
  499. //                $newProforma->setCreatedAt(new DateTime('now'));
  500. //                $newProforma->setUpdatedAt(new DateTime('now'));
  501. //
  502. //                $em->persist($newProforma);
  503. //                $em->flush();
  504.                         //FIN: Creamos las proformas
  506.                         foreach ($elemento as $item) {
  507.                             //$key es el id del expediente
  509.                             if (!empty($item->getProformaId())) {
  510.                                 $arrayIdPro[$item->getProformaId()] = $item->getUserConfirmedId();             // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  511.                             }
  512.                             //INICIO: Creamos los elemento que iran dentro de las proformas
  513. //                    $itemProforma = new MdvDocProformaItems();
  514. //                    $itemProforma->setType('PRODUCT');
  515. //                    $itemProforma->setFileId($key);
  516. //                    $itemProforma->setProformaId($newProforma->getId());
  517. //                    $itemProforma->setControlId($item->getProductFileId());
  518. //
  519. //                    $em->persist($itemProforma);
  520. //                    $em->flush();
  522.                             //INICIO: Confirmamos el BudToProforma
  523.                             $item->setStatus('Confirmed');              // El elemento se ha pasado a confirmado porque se enviara por correo
  525.                             $em->persist($item);
  526.                             $em->flush();
  527.                             //FIN: Confirmamos el BudToProforma
  529.                             //FIN: Creamos los elemento que iran dentro de las proformas
  530.                         }
  531.                     }
  532.                 }
  534.                 //INICIO: Notificamos de todos los presupuestos (proformas) que se han creado
  535.                 foreach ($arrayIdPro as $key => $item){
  536.                     //Buscamos los agentes a notificar
  537.                     // $arrayIdPro['X'] = 'Y'; al agente 'Y' se le informa del presupuesto 'X'
  538.                     $agent = $em->getRepository(User::class)->findOneById($item);
  539.                     $agentMail = $agent->getEmail();
  541.                     $mailAgent = $agentMail;
  543.                     //Se prepara el correo con los agentes a notificar
  544.                     $firmGmail = $agent->getFirmGmail();
  545.                     $data = array(
  546.                         '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>',
  547.                         'firm' => $firmGmail,
  548.                     );
  550.                     // EJECUTAR ENVIO DE ALERTA PARA EL AGENTE
  551.                     $transporter = new Swift_SmtpTransport();
  552.                     $transporter->setHost('smtp.gmail.com')
  553.                         ->setEncryption('ssl')//ssl / tls
  554.                         ->setPort(465)// 465 / 587
  555.                         ->setUsername('desarrollo@develup.solutions')
  556.                         ->setPassword('utvh hzoi wfdo ztjs');
  557.                     $mailer = new Swift_Mailer($transporter);
  559.                     $message = new Swift_Message();
  560.                     $message->setSubject('Presupuesto #' . $key . ', Notificación de nuevo presupuesto')
  561.                         ->setSender($agentMail)
  562.                         ->setFrom(array("desarrollo@develup.solutions" => "System Mante 3.0"))
  563.                         ->setReplyTo($agentMail)
  564.                         ->setTo($mailAgent)
  565.                         ->setBody(
  566.                             $this->renderView(
  567.                                 'mail/structure-mail.html.twig',
  568.                                 array('data' => $data)
  569.                             ),
  570.                             'text/html'
  571.                         );
  572.                     $mailer->send($message);
  573.                 }
  574.                 //FIN: Notificamos de todos los presupuestos (proformas) que se han creado
  575.                 // FIN: Se envia al agente el presupuesto
  576.             }
  577.         }
  579.         return $this->redirectToRoute('mdv_edit_file',
  580.             array(
  581.                 'id' => $newFile->getId()
  582.             )
  583.         );
  584.     }
  586.     /**
  587.      * @Route("/fileedit/{id}", name="mdv_edit_file")
  588.      * Editar un expediente
  589.      */
  590.     public function editFileAction( $id, Request $request)
  591.     {
  592.         $em = $this->getDoctrine()->getManager();
  593.         $editFile = $em->getRepository(MdvFiles::class)->findOneById($id);
  594.         $clients = $em->getRepository(Client::class)->findAll();
  595.         $clientSelected = $em->getRepository(Client::class)->findOneById($editFile->getClient());
  596.         $products = $em->getRepository(MdvProduct::class)->findAll();
  598.         $data = $this->calculosFile($id, null, 0, 'File');
  600.         $sumatoriaTotalNet = 0;
  601.         $sumatoriaTotalVat = 0;
  602.         $sumatoriaTotal = 0;
  604.         $resultados = array(
  605.             'totalNeto' => $sumatoriaTotalNet,
  606.             'vat' => $sumatoriaTotalVat,
  607.             'total' => $sumatoriaTotal,
  608.         );
  610.         $productInFile = $em->getRepository(MdvProductFile::class)->findByFileId($id);
  611.         $numeroItems = sizeof($productInFile);
  613.         $facturas = $em->getRepository(MdvDocInvoice::class)->findByFileId($id);
  614.         $facturasRec = $em->getRepository(MdvDocInvoiceRec::class)->findByFileId($id);
  616.         foreach ($facturasRec as $item){
  617.             array_push($facturas,$item);
  618.         }
  620.         $proformas = array();
  621.         $allProformas = $em->getRepository(MdvDocProforma::class)->findByFileId($id);
  623.         foreach ($allProformas as $item){
  624.             $dataTwo = $this->baseInvoiceDoneFileTwo($id, $item->getId(),'P');
  625.             $bases = 0;
  626.             if (is_numeric($dataTwo['totales']) and is_numeric($dataTwo['totales_neto'])){$bases = $dataTwo['totales'] - $dataTwo['totales_neto'];}
  628.             $allItemsProforma = $em->getRepository(MdvDocProformaItems::class)->findByProformaId($dataTwo['number']);
  630.             $itemsInProforma = array();
  632.             foreach ($allItemsProforma as $elem){
  633.                 $itemsInProforma[] = $em->getRepository(MdvProductFile::class)->findOneById($elem->getControlId());
  634.             }
  636.             $proformas[] = array(
  637.                 'id' => $dataTwo['number'],
  638.                 'itemsInProforma' => $itemsInProforma,
  639.                 'date' => $dataTwo['date'],
  640.                 'neto' => $dataTwo['totales_neto'],
  641.                 'bases_imponibles' => $bases,
  642.                 'total' => $dataTwo['totales'],
  643.             );
  644.         }
  646.         return $this->render('MDS/DevelupBundle/Develup/edit-files.html.twig',
  647.             array(
  648.                 'id' => $id,
  649.                 'clients' => $clients,
  650.                 'clientId' => $editFile->getClient(),
  651.                 'clientSelected' => $clientSelected,
  652.                 'file' => $editFile,
  653.                 'numeroItems' => $numeroItems,
  654.                 'arrayProductFile' => $data['datasupplier']['product'],
  655.                 'products' => $products,
  656.                 'services' => null,
  657.                 'facturas' => $facturas,
  658.                 'proformas' => $proformas,
  659.                 'paymentNotIvoiced' => null,
  660.                 'paymentsAll' => null,
  661.                 'resultados' => $resultados,
  662.                 'totales_global_con_iva' => $data['totales'], //$data['totales_global_con_iva'],
  663.                 'totales_global_iva' => $data['bases_imponibles']['ivaMontoVeintiUno'], //$data['totales_global_iva'],
  664.                 'totales_global_neto' => $data['totales_neto'], //$data['totales_global_neto'],
  665.                 'totales_global_servicios_con_iva' => 0, //$data['totales_global_servicios_con_iva'],
  666.                 'totales_global_servicios_neto' => 0, //$data['totales_global_servicios_neto'],
  667.                 'totales_global_servicios_iva' => 0, //$data['totales_global_servicios_iva'],
  668.                 'sumatoria_totales_global_con_iva' => 0, //$data['sumatoria_totales_global_con_iva'],
  669.                 'sumatoria_totales_global_neto' => 0, //$data['sumatoria_totales_global_neto'],
  670.                 'sumatoria_totales_global_iva' => 0, //$data['sumatoria_totales_global_iva'],
  671.             ));
  672.     }
  675.     /**
  676.      * @Route("/filefrombudget/{id}",  name="mdv_add_file_from_budget")
  677.      * Agregar un expediente desde un presupuesto
  678.      */
  679.     public function addFileFromBudgetAction( $id, Request $request)
  680.     {
  681.         $em = $this->getDoctrine()->getManager();
  682.         $budget = $em->getRepository(MdvBudgetPending::class)->findOneById($id);
  683.         $proposal = $em->getRepository(Proposal::class)->findOneById($budget->getProposalId());
  685.         $newFile = $em->getRepository(MdvFiles::class)->findOneByIdProposal($proposal->getId());
  687.         /* Obtengo usuario logueado */
  688.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  689.         $user_id = $user_logueado->getId();
  691.         if (empty($newFile)){
  692.             // No hay un File asociado a ese proposal, se debe crear uno nuevo
  693.             $newFile = new MdvFiles();
  694.             $newFile->setTitle($proposal->getId().' - ' .$budget->getProposalTitle());
  695.             $newFile->setClient(262);                           // In Out es el cliente
  696.             $newFile->setIdProposal($proposal->getId());
  697.             $newFile->setStatus('Pending');
  698.             $newFile->setAdvancePayment(null);
  699.             if (!empty($budget->getBriefing())) {
  700.                 $newFile->setDescription('<p> *********  MENSAJE DEL AGENTE  ********* </p>' . $budget->getBriefing());
  701.             }
  702.             $newFile->setDateStart(new \DateTime("now"));
  703.             $newFile->setDateEnd(new \DateTime("now"));
  705.             $newFile->setCreatedId($user_id);
  706.             $newFile->setUpdatedId($user_id);
  707.             $newFile->setCreatedAt(new \DateTime("now"));
  708.             $newFile->setUpdatedAt(new \DateTime("now"));
  709.         } else {
  710.             // Ya existe un File asociado a ese proposal
  711.             $newFile->setClient(262);                           // In Out es el cliente
  712.             $newFile->setStatus('Pending');
  713.             if (!empty($budget->getBriefing())) {
  714.                 $newFile->setDescription($newFile->getDescription() . '<p> *********  MENSAJE DEL AGENTE  ********* </p>' . $budget->getBriefing());
  715.             }
  717.             $newFile->setUpdatedId($user_id);
  718.             $newFile->setUpdatedAt(new \DateTime("now"));
  719.         }
  721.         $em->persist($newFile);
  722.         $em->flush();
  724.         $em->remove($budget);
  725.         $em->flush();
  727.         //Actualizamos los Briefings que esten en FileId null con el recien generado fileId en base al proposalId
  728.         $allBriefings = $em->getRepository(MdvBriefings::class)->findByProposalId($proposal->getId());
  729.         foreach ($allBriefings as $item){
  730.             if (empty($item->getFileId())) {
  731.                 $item->setFileId($newFile->getId());
  733.                 $em->persist($item);
  734.                 $em->flush();
  735.             }
  736.         }
  738.         return $this->redirectToRoute('mdv_edit_file',
  739.             array(
  740.                 'id' => $newFile->getId()
  741.             )
  742.         );
  743.     }
  745.     /**
  746.      * @Route("/filelistbriefings/{id}",  name="mdv_list_file_briefings")
  747.      * Listar briefings del expediente
  748.      */
  749.     public function listFileBriefingsAction($id, Request $request){
  751.         $em = $this->getDoctrine()->getManager();
  752.         $briefings = $em->getRepository(MdvBriefings::class)->findByFileId($id);
  755.         return $this->render('MDS/DevelupBundle/Develup/list-briefings.html.twig',
  756.             array(
  757.                 'id' => $id,
  758.                 'briefings' => $briefings,
  759.             )
  760.         );
  761.     }
  764.     /**
  765.      * @Route("/briefingadd/{id}",  name="mdv_add_file_briefings")
  766.      * Agregar briefing al expediente
  767.      */
  768.     public function addFileBriefingsAction($id, Request $request){
  770.         $brif = $request->request->get('newbriefing');
  772.         $em = $this->getDoctrine()->getManager();
  773.         $file = $em->getRepository(MdvFiles::class)->findOneById($id);
  774.         $proposalId = $file->getIdProposal();
  776.         /* Obtengo usuario logueado */
  777.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  778.         $user_id = $user_logueado->getId();
  780.         $userConfirmedFullName = $user_logueado->getName().' '.$user_logueado->getLastName();
  782.         $briefing = new MdvBriefings();
  783.         $briefing->setProposalId($proposalId);
  784.         $briefing->setBriefing($brif);
  785.         $briefing->setBudgetPendingId(null);
  786.         $briefing->setFileId($id);
  787.         $briefing->setUserConfirmedFullName($userConfirmedFullName);
  788.         $briefing->setUserConfirmedId($user_id);
  789.         $briefing->setCreatedAt(new \DateTime("now"));
  791.         $em->persist($briefing);
  792.         $em->flush();
  794.         $briefings = $em->getRepository(MdvBriefings::class)->findByFileId($id);
  796.         return $this->render('MDS/DevelupBundle/Develup/list-briefings.html.twig',
  797.             array(
  798.                 'id' => $id,
  799.                 'briefings' => $briefings,
  800.             )
  801.         );
  802.     }
  805.     private function baseInvoiceDoneFileTwo($fileId, $invoiceId, $typeBase)
  806.     {
  807.         $em = $this->getDoctrine()->getManager();
  808.         $file = $em->getRepository(MdvFiles::class)->findOneById($fileId);
  809.         $dateDocument = null;                                                                           //Fecha final del documento
  810.         $subneto = 0;
  811.         if (($typeBase == 'I') or ($typeBase == 'P')) {
  812.             if ($typeBase == 'I') {
  813.                 $items = $em->getRepository(MdvDocInvoiceItems::class)->findBy(array('fileId' => $fileId, 'invoiceId' => $invoiceId));
  814.             } else {
  815.                 // Es factura ni proforma
  816.                 $items = $em->getRepository(MdvDocProformaItems::class)->findBy(array('fileId' => $fileId, 'proformaId' => $invoiceId));
  817.             }
  818.         } else {
  819.             // No es factura ni proforma, es una rectificativa
  820.             $items = $em->getRepository(MdvDocInvoiceRecItems::class)->findBy(array('fileId' => $fileId, 'invoiceRecId' => $invoiceId));
  821.         }
  823.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('2');
  824.         $client = $em->getRepository(Client::class)->findById($file->getClient());
  826.         if (empty($client)){
  827.             $client[0] = new Client();
  828.             $client[0]->setName('');
  829.             $client[0]->setTitle('');
  830.             $client[0]->setIdDocument('');
  831.             $client[0]->setPopulation('');
  832.             $client[0]->setRegion('');
  833.             $client[0]->setCountry('');
  834.         } else {
  835.             if (is_numeric($client[0]->getPopulation())){
  836.                 $city = ($em->getRepository(Cities::class)->findOneById($client[0]->getPopulation()));
  837.                 $client[0]->setPopulation($city->getCity());
  838.             }
  839.             if (is_numeric($client[0]->getRegion())){
  840.                 $region = ($em->getRepository(Regions::class)->findOneById($client[0]->getRegion()));
  841.                 $client[0]->setRegion($region->getRegion());
  842.             }
  843.             if (is_numeric($client[0]->getCountry())){
  844.                 $country = ($em->getRepository(Country::class)->findOneById($client[0]->getCountry()));
  845.                 $client[0]->setCountry($country->getCountry());
  846.             }
  847.         }
  849.         // Acumuladores de los calculos
  850.         $totales_neto_all = 0;
  851.         $data_iva = array(
  852.             'iva' => 21,
  853.             'ivaMontoVeintiUno' => 0,
  854.             'ivaMontoDiez' => 0,
  855.             'ivaMontoCero' => 0,
  856.         );
  858.         //INICIO: Determinamos el numero de factura o proforma
  859.         if ($typeBase == 'I'){
  860.             // Es una Factura
  862.             $number = $em->getRepository(MdvDocInvoice::class)->findOneById($invoiceId);
  863.             $dateDocument = $number->getDateAt();
  864.             $number = $number->getNumber();
  865.             $type = 'Invoice';
  867.         } else {
  868.             if ($typeBase == 'R'){
  869.                 // Es una factura rectificativa
  870.                 $number = $em->getRepository(MdvDocInvoiceRec::class)->findOneById($invoiceId);
  871.                 $dateDocument = $number->getDateAt();
  872.                 $type = 'Invoice Rec';
  873.             } else {
  874.                 // Es una Proforma
  876.                 $number = $invoiceId;
  877.                 $type = 'Proforma';
  878.             }
  879.         }
  880.         //FIN: Determinamos el numero de factura o proforma
  882.         // Buscamos los productos, pagos y servicios
  884.         $arrayItems = array();
  885.         $fileProducts = array();
  886.         $payments = array();
  887.         $services = array();
  889.         if (!empty($items)) {
  890.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  891.                 foreach ($items as $item) {
  892.                     switch ($item->getItemType()) {
  893.                         case 'PRODUCT': // Producto
  894.                             $fileProducts[] = $item;
  895.                             break;
  897.                         case 'PAYMENT': // Pago
  898.                             $payments[] = $item;
  899.                             break;
  901.                         case 'SERVICE': // Servicio
  902.                             $services[] = $item;
  903.                             break;
  905.                         default:
  906.                             break;
  907.                     }
  908.                 }
  909.             } else {
  910.                 // Es una proforma
  911.                 foreach ($items as $item) {
  912.                     switch ($item->getType()) {
  913.                         case 'PRODUCT': // Producto
  914.                             $productPro = $em->getRepository(MdvProductFile::class)->findOneById($item->getControlId());
  915.                             if (!empty($productPro)) {
  916.                                 $fileProducts[] = $productPro;
  917.                             }
  918.                             break;
  920.                         case 'PAYMENT': // Pago
  921.                             $paymentPro = $em->getRepository(MdvPaymentsClient::class)->findOneById($item->getControlId());
  922.                             if (!empty($paymentPro)) {
  923.                                 $payments[] = $paymentPro;
  924.                             }
  925.                             break;
  927.                         case 'SERVICE': // Servicio
  928.                             $servicePro = $em->getRepository(MdvServices::class)->findOneById($item->getControlId());
  929.                             if (!empty($servicePro)) {
  930.                                 $services[] = $servicePro;
  931.                             }
  932.                             break;
  934.                         default:
  935.                             break;
  936.                     }
  937.                 }
  938.             }
  939.         }
  941.         $data_supplier = array();
  942.         $i = 0;
  944.         $iva = '21';            // Esteban Rincon: "Por Ley de localización del impuesto, siempre será un 21%"
  945.         $pax = '1';
  946.         $qty = '1';
  947.         $product = array(
  948.             'neto' => 0,
  949.             'sumSubT' => 0,
  950.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  952.         $service = array(
  953.             'neto' => 0,
  954.             'sumSubT' => 0,
  955.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  957.         foreach ($fileProducts as $item){
  959.             if (!is_null($item->getUnits()) or !empty($item->getUnits())){
  960.                 $qty = $item->getUnits();
  961.             }
  963.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  964.                 if (is_null($item->getPrdServicePrice()) or empty($item->getPrdServicePrice())){
  965.                     $subtotal = 0;
  966.                     $neto = 0;
  967.                     $subtotalProduct = 0;
  969.                 } else {
  971. //                    $subtotalProduct = $item->getPrdServicePrice() * 1.21;
  972.                     $subtotalProduct = $item->getPrdSubTotalPrice() * 1.21;
  973. //                    $subneto = $item->getPrdServicePrice();
  974.                     $subneto = $item->getPrdSubTotalPrice();
  976.                     $subtotal =  $subtotalProduct;
  977.                     $neto =  $subneto;
  979.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  980.                     $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  981.                     $neto = round($neto,2,PHP_ROUND_HALF_UP);
  983.                     $arrayItems[] = array(
  984.                         'type' => 'Product',
  985.                         'name' => $item->getPrdName(),
  986.                         'amount' => $neto,
  987.                         'iva' => '21',
  988.                         'total' => $subtotal,
  989.                     );
  990.                 }
  991.             } else {
  992.                 // Es proforma
  993.                 if (is_null($item->getServicePrice()) or empty($item->getServicePrice())){
  994.                     $subtotal = 0;
  995.                     $neto = 0;
  996.                     $subtotalProduct = 0;
  998.                 } else {
  1000. //                    $subtotalProduct = $item->getServicePrice() * 1.21;
  1001.                     $subtotalProduct = $item->getSubTotalPrice() * 1.21;
  1002. //                    $subneto = $item->getServicePrice();
  1003.                     $subneto = $item->getSubTotalPrice();
  1005.                     $subtotal =  $subtotalProduct;
  1006.                     $neto =  $subneto;
  1008.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  1009.                     $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  1010.                     $neto = round($neto,2,PHP_ROUND_HALF_UP);
  1012.                     $arrayItems[] = array(
  1013.                         'type' => 'Product',
  1014.                         'name' => $item->getProductName(),
  1015.                         'amount' => $neto,
  1016.                         'iva' => '21',
  1017.                         'total' => $subtotal,
  1018.                     );
  1019.                 }
  1020.             }
  1022.             // Acumula netos totales e IVA
  1023.             $totales_neto_all = $totales_neto_all + $neto;
  1024.             $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * 0.21);
  1025.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1026.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  1027.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  1028.             // Acumula netos totales e IVA
  1030.             $product['neto'] = $product['neto'] + $neto;
  1031.             $product['sumSubT'] = $product['sumSubT'] + $subtotal;
  1032.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1033.             $product['neto'] = round($product['neto'],2,PHP_ROUND_HALF_UP);
  1034.             $product['sumSubT'] = round($product['sumSubT'],2,PHP_ROUND_HALF_UP);
  1036.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1037.                 $data_supplier['product'][$i] = array(
  1038.                     'id' => $item->getId(),
  1039.                     'productName' => $item->getPrdName(),
  1040.                     'productId' => $item->getPrdProductId(),
  1041.                     'dateStart' => $item->getPrdDateStart(),
  1042.                     'dateEnd' => $item->getPrdDateEnd(),
  1043.                     'servicePrice' => $item->getPrdServicePrice(),
  1044.                     'serviceSubTotalPrice' => $subneto,     //antes de IVA
  1045.                     'subtotalProduct' => $subtotalProduct,
  1046.                     'iva' => $iva,
  1047.                     'pax' => $pax,
  1048.                     'qty' => $qty,
  1049.                     'type' => $item->getPrdType(),
  1050.                     'subtotal' => $subtotal,
  1051.                 );
  1052.             } else {
  1053.                 // Es proforma
  1054.                 $data_supplier['product'][$i] = array(
  1055.                     'id' => $item->getId(),
  1056.                     'productName' => $item->getProductName(),
  1057.                     'productId' => $item->getProductId(),
  1058.                     'dateStart' => $item->getDateStart(),
  1059.                     'dateEnd' => $item->getDateEnd(),
  1060.                     'servicePrice' => $item->getServicePrice(),
  1061.                     'subtotalProduct' => $subtotalProduct,
  1062.                     'iva' => $iva,
  1063.                     'pax' => $pax,
  1064.                     'qty' => $qty,
  1065.                     'type' => $item->getType(),
  1066.                     'subtotal' => $subtotal,
  1067.                 );
  1068.             }
  1069.             $i++;
  1070.         }
  1072.         $data_supplier['productSubTotal'] = array(
  1073.             'neto' => $product['neto'],
  1074.             'sumSubT' => $product['sumSubT'],
  1075.         );
  1077.         $payment = array(
  1078.             'sumSubT' => 0,
  1079.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  1081.         $i = 0;
  1082.         foreach ($payments as $item){
  1084.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1085.                 $payment['sumSubT'] = $payment['sumSubT'] + $item->getPayAmountTotal();
  1086.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1087.                 $payment['sumSubT'] = round($payment['sumSubT'], 2, PHP_ROUND_HALF_UP);
  1089.                 $data_supplier['payment'][$i] = array(
  1090.                     'id' => $item->getId(),
  1091.                     'amount' => $item->getPayAmount(),
  1092.                     'amountTotal' => $item->getPayAmountTotal(),
  1093.                     'vat' => $item->getPayVat(),
  1094.                     'datePayAt' => $item->getPayDatePayAt(),
  1095.                     'wayToPay' => $item->getPayWayToPay(),
  1096.                 );
  1098.                 $arrayItems[] = array(
  1099.                     'type' => 'Payment',
  1100.                     'name' => $item->getPayWayToPay(),
  1101.                     'amount' => $item->getPayAmount(),
  1102.                     'total' => $item->getPayAmountTotal(),
  1103.                     'iva' => $item->getPayVat(),
  1104.                 );
  1105.             } else {
  1106.                 // Es una proforma
  1107.                 $payment['sumSubT'] = $payment['sumSubT'] + $item->getAmountTotal();
  1108.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  1109.                 $payment['sumSubT'] = round($payment['sumSubT'], 2, PHP_ROUND_HALF_UP);
  1111.                 $data_supplier['payment'][$i] = array(
  1112.                     'id' => $item->getId(),
  1113.                     'amount' => $item->getAmount(),
  1114.                     'amountTotal' => $item->getAmountTotal(),
  1115.                     'vat' => $item->getVat(),
  1116.                     'datePayAt' => $item->getDatePayAt(),
  1117.                     'wayToPay' => $item->getWayToPay(),
  1118.                 );
  1120.                 $arrayItems[] = array(
  1121.                     'type' => 'Payment',
  1122.                     'name' => $item->getWayToPay(),
  1123.                     'amount' => $item->getAmount(),
  1124.                     'total' => $item->getAmountTotal(),
  1125.                     'iva' => $item->getVat(),
  1126.                 );
  1127.             }
  1128.             $i++;
  1129.         }
  1131.         if (!empty($payments)) {
  1132.             $data_supplier['paymentSubTotal'] = array(
  1133.                 'sumSubT' => $payment['sumSubT'],
  1134.             );
  1135.         }
  1137.         foreach ($services as $item){
  1138.             if (($typeBase == 'I') or ($typeBase == 'R')) {
  1139.                 if (is_null($item->getSrvPrice()) or empty($item->getSrvPrice())) {
  1140.                     $subtotal = 0;
  1141.                     $neto = 0;
  1142.                     $subtotalService = 0;
  1144.                 } else {
  1145.                     $subtotalService = $item->getSrvPrice();
  1146.                     $subneto = $item->getSrvPrice();
  1148.                     // Commission
  1149.                     if ($item->getSrvOpCommission() == '1') {
  1150.                         $subtotalService = $subtotalService * (1 + ($item->getSrvCommission() / 100));
  1151.                         $subneto = $subneto * (1 + ($item->getSrvCommission() / 100));
  1152.                     } else {
  1153.                         $subtotalService = $subtotalService * (1 - ($item->getSrvCommission() / 100));
  1154.                         $subneto = $subneto * (1 - ($item->getSrvCommission() / 100));
  1155.                     }
  1157.                     // Over
  1158.                     if ($item->getSrvOpOver() == '1') {
  1159.                         $subtotalService = $subtotalService + $item->getSrvOver();
  1160.                         $subneto = $subneto + $item->getSrvOver();
  1161.                     } else {
  1162.                         $subtotalService = $subtotalService - $item->getSrvOver();
  1163.                         $subneto = $subneto - $item->getSrvOver();
  1164.                     }
  1166.                     // IVA
  1167.                     if ($item->getSrvOpIva() == '1') {
  1168.                         $subtotalService = $subtotalService * (1 + ($item->getSrvIva() / 100));
  1169.                     } else {
  1170.                         $subtotalService = $item->getSrvPrice();
  1171.                         $subneto = ($subneto * 100) / (100 + $item->getSrvIva());
  1172.                     }
  1174.                     switch ($item->getSrvServiceCatId()) {
  1175.                         case 1: // Alojamiento
  1176.                             // el numero de noches $numNoches; precio unitario $subneto
  1177.                             $numNoches = (($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days;
  1178.                             // La personas no afectan este calculo
  1179.                             $subtotal = $subtotalService * $numNoches * $item->getSrvUnits();
  1180.                             $subnetoUnit = $subneto;
  1182.                             $subneto = $subneto * $numNoches * $item->getSrvUnits();
  1184.                             $data_supplier['service'][$i] = array(
  1185.                                 'id' => $item->getId(),
  1186.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1187.                                 'serviceName' => $item->getSrvName(),
  1188.                                 'serviceType' => 'Hotel',
  1189.                                 'date' => ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y'),
  1190.                                 'qty' => $item->getSrvUnits(),
  1191.                                 'iva' => $item->getSrvIva(),
  1192.                                 'pax' => '-',
  1193.                                 'precioUnit' => $subnetoUnit,
  1194.                                 'subneto' => $subneto,
  1195.                                 'subtotal' => $subtotal,
  1196.                             );
  1197.                             break;
  1199.                         case 2: //Actividades
  1200.                             // El número de personas es considerado en el calculo
  1201.                             $pax = $item->getSrvPax();
  1202.                             if (empty($pax) or $pax == "0") {
  1203.                                 $pax = 1;
  1204.                             }
  1205.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1207.                             if ($days > 1) {
  1208.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1209.                             } else {
  1210.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1211.                             }
  1213.                             $subtotal = $subtotalService * $days * $item->getSrvUnits();
  1214.                             $subnetoUnit = $subneto;
  1215.                             $subneto = $subneto * $days * $item->getSrvUnits();
  1217.                             $data_supplier['service'][$i] = array(
  1218.                                 'id' => $item->getId(),
  1219.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1220.                                 'serviceName' => $item->getSrvName(),
  1221.                                 'serviceType' => 'Actividad',
  1222.                                 'date' => $dateServ,
  1223.                                 'qty' => $item->getSrvUnits(),
  1224.                                 'iva' => $item->getSrvIva(),
  1225.                                 'pax' => $item->getSrvPax(),
  1226.                                 'precioUnit' => $subnetoUnit,
  1227.                                 'subneto' => $subneto,
  1228.                                 'subtotal' => $subtotal,
  1229.                             );
  1230.                             break;
  1232.                         case 3: // AV
  1233.                             $pax = $item->getSrvPax();
  1234.                             if (empty($pax) or $pax == "0") {
  1235.                                 $pax = 1;
  1236.                             }
  1238.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1239.                             if ($days > 1) {
  1240.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1241.                             } else {
  1242.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1243.                             }
  1245.                             $unitsServ = $item->getSrvUnits();
  1246.                             if (empty($unitsServ) or $unitsServ == "0") {
  1247.                                 $unitsServ = 1;
  1248.                             }
  1250.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1251.                             $subnetoUnit = $subneto;
  1252.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1254.                             $data_supplier['service'][$i] = array(
  1255.                                 'id' => $item->getId(),
  1256.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1257.                                 'serviceName' => $item->getSrvName(),
  1258.                                 'serviceType' => 'AV',
  1259.                                 'date' => $dateServ,
  1260.                                 'qty' => $unitsServ,
  1261.                                 'iva' => $item->getSrvIva(),
  1262.                                 'pax' => $item->getSrvPax(),
  1263.                                 'precioUnit' => $subnetoUnit,
  1264.                                 'subneto' => $subneto,
  1265.                                 'subtotal' => $subtotal,
  1266.                             );
  1267.                             break;
  1269.                         case 4: //Creative
  1270.                             $pax = $item->getSrvPax();
  1271.                             if (empty($pax) or $pax == "0") {
  1272.                                 $pax = 1;
  1273.                             }
  1275.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1276.                             if ($days > 1) {
  1277.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1278.                             } else {
  1279.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1280.                             }
  1282.                             $unitsServ = $item->getSrvUnits();
  1283.                             if (empty($unitsServ) or $unitsServ == "0") {
  1284.                                 $unitsServ = 1;
  1285.                             }
  1287.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1288.                             $subnetoUnit = $subneto;
  1289.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1291.                             $data_supplier['service'][$i] = array(
  1292.                                 'id' => $item->getId(),
  1293.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1294.                                 'serviceName' => $item->getSrvName(),
  1295.                                 'serviceType' => 'Creativo',
  1296.                                 'date' => $dateServ,
  1297.                                 'qty' => $unitsServ,
  1298.                                 'iva' => $item->getSrvIva(),
  1299.                                 'pax' => $item->getSrvPax(),
  1300.                                 'precioUnit' => $subnetoUnit,
  1301.                                 'subneto' => $subneto,
  1302.                                 'subtotal' => $subtotal,
  1303.                             );
  1304.                             break;
  1306.                         case 5: //Cruise
  1307.                             $pax = $item->getSrvPax();
  1308.                             if (empty($pax) or $pax == "0") {
  1309.                                 $pax = 1;
  1310.                             }
  1312.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days);
  1313.                             if ($days > 1) {
  1314.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1315.                             } else {
  1316.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1317.                             }
  1319.                             $unitsServ = $item->getSrvUnits();
  1320.                             if (empty($unitsServ) or $unitsServ == "0") {
  1321.                                 $unitsServ = 1;
  1322.                             }
  1324.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1325.                             $subnetoUnit = $subneto;
  1326.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1328.                             $data_supplier['service'][$i] = array(
  1329.                                 'id' => $item->getId(),
  1330.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1331.                                 'serviceName' => $item->getSrvName(),
  1332.                                 'serviceType' => 'Crucero',
  1333.                                 'date' => $dateServ,
  1334.                                 'qty' => $unitsServ,
  1335.                                 'iva' => $item->getSrvIva(),
  1336.                                 'pax' => $item->getSrvPax(),
  1337.                                 'precioUnit' => $subnetoUnit,
  1338.                                 'subneto' => $subneto,
  1339.                                 'subtotal' => $subtotal,
  1340.                             );
  1341.                             break;
  1343.                         case 6: //Entertaiment
  1344.                             $pax = $item->getSrvPax();
  1345.                             if (empty($pax) or $pax == "0") {
  1346.                                 $pax = 1;
  1347.                             }
  1349.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1350.                             if ($days > 1) {
  1351.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1352.                             } else {
  1353.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1354.                             }
  1356.                             $unitsServ = $item->getSrvUnits();
  1357.                             if (empty($unitsServ) or $unitsServ == "0") {
  1358.                                 $unitsServ = 1;
  1359.                             }
  1361.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1362.                             $subnetoUnit = $subneto;
  1363.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1365.                             $data_supplier['service'][$i] = array(
  1366.                                 'id' => $item->getId(),
  1367.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1368.                                 'serviceName' => $item->getSrvName(),
  1369.                                 'serviceType' => 'Entretenimiento',
  1370.                                 'date' => $dateServ,
  1371.                                 'qty' => $unitsServ,
  1372.                                 'iva' => $item->getSrvIva(),
  1373.                                 'pax' => $item->getSrvPax(),
  1374.                                 'precioUnit' => $subnetoUnit,
  1375.                                 'subneto' => $subneto,
  1376.                                 'subtotal' => $subtotal,
  1377.                             );
  1378.                             break;
  1380.                         case 7: // Gifts
  1381.                             $pax = $item->getSrvPax();
  1382.                             if (empty($pax) or $pax == "0") {
  1383.                                 $pax = 1;
  1384.                             }
  1386. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1387.                             $days = 1;
  1388.                             if ($days > 1) {
  1389.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1390.                             } else {
  1391.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1392.                             }
  1394.                             $unitsServ = $item->getSrvUnits();
  1395.                             if (empty($unitsServ) or $unitsServ == "0") {
  1396.                                 $unitsServ = 1;
  1397.                             }
  1399.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1400.                             $subnetoUnit = $subneto;
  1401.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1403.                             $data_supplier['service'][$i] = array(
  1404.                                 'id' => $item->getId(),
  1405.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1406.                                 'serviceName' => $item->getSrvName(),
  1407.                                 'serviceType' => 'Regalos',
  1408.                                 'date' => $dateServ,
  1409.                                 'qty' => $unitsServ,
  1410.                                 'iva' => $item->getSrvIva(),
  1411.                                 'pax' => $item->getSrvPax(),
  1412.                                 'precioUnit' => $subnetoUnit,
  1413.                                 'subneto' => $subneto,
  1414.                                 'subtotal' => $subtotal,
  1415.                             );
  1416.                             break;
  1418.                         case 8: //Guide
  1419.                             $pax = $item->getSrvPax();
  1420.                             if (empty($pax) or $pax == "0") {
  1421.                                 $pax = 1;
  1422.                             }
  1424.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1425.                             if ($days > 1) {
  1426.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1427.                             } else {
  1428.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1429.                             }
  1431.                             $unitsServ = $item->getSrvUnits();
  1432.                             if (empty($unitsServ) or $unitsServ == "0") {
  1433.                                 $unitsServ = 1;
  1434.                             }
  1436.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1437.                             $subnetoUnit = $subneto;
  1438.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1440.                             $data_supplier['service'][$i] = array(
  1441.                                 'id' => $item->getId(),
  1442.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1443.                                 'serviceName' => $item->getSrvName(),
  1444.                                 'serviceType' => 'Regalos',
  1445.                                 'date' => $dateServ,
  1446.                                 'qty' => $unitsServ,
  1447.                                 'iva' => $item->getSrvIva(),
  1448.                                 'pax' => $item->getSrvPax(),
  1449.                                 'precioUnit' => $subnetoUnit,
  1450.                                 'subneto' => $subneto,
  1451.                                 'subtotal' => $subtotal,
  1452.                             );
  1453.                             break;
  1455.                         case 9: //Itineraries
  1456.                             $pax = $item->getSrvPax();
  1457.                             if (empty($pax) or $pax == "0") {
  1458.                                 $pax = 1;
  1459.                             }
  1461.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1462.                             if ($days > 1) {
  1463.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1464.                             } else {
  1465.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1466.                             }
  1468.                             $unitsServ = $item->getSrvUnits();
  1469.                             if (empty($unitsServ) or $unitsServ == "0") {
  1470.                                 $unitsServ = 1;
  1471.                             }
  1473.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1474.                             $subnetoUnit = $subneto;
  1475.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1477.                             $data_supplier['service'][$i] = array(
  1478.                                 'id' => $item->getId(),
  1479.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1480.                                 'serviceName' => $item->getSrvName(),
  1481.                                 'serviceType' => 'Itinerarios',
  1482.                                 'date' => $dateServ,
  1483.                                 'qty' => $unitsServ,
  1484.                                 'iva' => $item->getSrvIva(),
  1485.                                 'pax' => $item->getSrvPax(),
  1486.                                 'precioUnit' => $subnetoUnit,
  1487.                                 'subneto' => $subneto,
  1488.                                 'subtotal' => $subtotal,
  1489.                             );
  1490.                             break;
  1492.                         case 10: //Lounge  -- No Aplica
  1493. //                        $pax = $item->getPax();
  1494. //                        if (empty($pax) or $pax == "0") {
  1495. //                            $pax = 1;
  1496. //                        }
  1497. //
  1498. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1499. //                        if ($days > 1){
  1500. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  1501. //                        } else {
  1502. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1503. //                        }
  1504. //
  1505. //                        $unitsServ = $item->getUnits();
  1506. //                        if (empty($unitsServ) or $unitsServ == "0") {
  1507. //                            $unitsServ = 1;
  1508. //                        }
  1509. //
  1510. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1511. //                        $subnetoUnit = $subneto;
  1512. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  1513. //
  1514. //                        $data_supplier['service'][$i] = array (
  1515. //                            'id' => $item->getId(),
  1516. //                            'serviceCatId' => $item->getServiceCatId(),
  1517. //                            'serviceName' => $item->getName(),
  1518. //                            'serviceType' => 'Itinerarios',
  1519. //                            'date' => $dateServ,
  1520. //                            'qty' => $unitsServ,
  1521. //                            'iva' => $item->getIva(),
  1522. //                            'pax' => $item->getPax(),
  1523. //                            'precioUnit' => $subnetoUnit,
  1524. //                            'subneto' => $subneto,
  1525. //                            'subtotal' => $subtotal,
  1526. //                        );
  1527.                             break;
  1529.                         case 11: //Menu
  1530.                             $pax = $item->getSrvPax();
  1531.                             if (empty($pax) or $pax == "0") {
  1532.                                 $pax = 1;
  1533.                             }
  1535.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1536.                             if ($days > 1) {
  1537.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1538.                             } else {
  1539.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1540.                             }
  1542.                             $unitsServ = $item->getSrvUnits();
  1543.                             if (empty($unitsServ) or $unitsServ == "0") {
  1544.                                 $unitsServ = 1;
  1545.                             }
  1547.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1548.                             $subnetoUnit = $subneto;
  1549.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1551.                             $data_supplier['service'][$i] = array(
  1552.                                 'id' => $item->getId(),
  1553.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1554.                                 'serviceName' => $item->getSrvName(),
  1555.                                 'serviceType' => 'Menú',
  1556.                                 'date' => $dateServ,
  1557.                                 'qty' => $unitsServ,
  1558.                                 'iva' => $item->getSrvIva(),
  1559.                                 'pax' => $item->getSrvPax(),
  1560.                                 'precioUnit' => $subnetoUnit,
  1561.                                 'subneto' => $subneto,
  1562.                                 'subtotal' => $subtotal,
  1563.                             );
  1564.                             break;
  1566.                         case 12: //Others
  1567.                             $pax = $item->getSrvPax();
  1568.                             if (empty($pax) or $pax == "0") {
  1569.                                 $pax = 1;
  1570.                             }
  1572.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1573.                             if ($days > 1) {
  1574.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1575.                             } else {
  1576.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1577.                             }
  1579.                             $unitsServ = $item->getSrvUnits();
  1580.                             if (empty($unitsServ) or $unitsServ == "0") {
  1581.                                 $unitsServ = 1;
  1582.                             }
  1584.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1585.                             $subnetoUnit = $subneto;
  1586.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1588.                             $data_supplier['service'][$i] = array(
  1589.                                 'id' => $item->getId(),
  1590.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1591.                                 'serviceName' => $item->getSrvName(),
  1592.                                 'serviceType' => 'Otros',
  1593.                                 'date' => $dateServ,
  1594.                                 'qty' => $unitsServ,
  1595.                                 'iva' => $item->getSrvIva(),
  1596.                                 'pax' => $item->getSrvPax(),
  1597.                                 'precioUnit' => $subnetoUnit,
  1598.                                 'subneto' => $subneto,
  1599.                                 'subtotal' => $subtotal,
  1600.                             );
  1601.                             break;
  1603.                         case 13: //Transport
  1604.                             $pax = $item->getSrvPax();
  1605.                             if (empty($pax) or $pax == "0") {
  1606.                                 $pax = 1;
  1607.                             }
  1609.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1610.                             if ($days > 1) {
  1611.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1612.                             } else {
  1613.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1614.                             }
  1616.                             $unitsServ = $item->getSrvUnits();
  1617.                             if (empty($unitsServ) or $unitsServ == "0") {
  1618.                                 $unitsServ = 1;
  1619.                             }
  1621.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1622.                             $subnetoUnit = $subneto;
  1623.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1625.                             $data_supplier['service'][$i] = array(
  1626.                                 'id' => $item->getId(),
  1627.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1628.                                 'serviceName' => $item->getSrvName(),
  1629.                                 'serviceType' => 'Transporte',
  1630.                                 'date' => $dateServ,
  1631.                                 'qty' => $unitsServ,
  1632.                                 'iva' => $item->getSrvIva(),
  1633.                                 'pax' => $item->getSrvPax(),
  1634.                                 'precioUnit' => $subnetoUnit,
  1635.                                 'subneto' => $subneto,
  1636.                                 'subtotal' => $subtotal,
  1637.                             );
  1638.                             break;
  1640.                         case 14: //Technology
  1641.                             $pax = $item->getSrvPax();
  1642.                             if (empty($pax) or $pax == "0") {
  1643.                                 $pax = 1;
  1644.                             }
  1646. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1647.                             $days = 1;
  1648. //                        if ($days > 1){
  1649. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  1650. //                        } else {
  1651. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1652. //                        }
  1653.                             $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1655.                             $unitsServ = $item->getSrvUnits();
  1656.                             if (empty($unitsServ) or $unitsServ == "0") {
  1657.                                 $unitsServ = 1;
  1658.                             }
  1660.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1661.                             $subnetoUnit = $subneto;
  1662.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1664.                             $data_supplier['service'][$i] = array(
  1665.                                 'id' => $item->getId(),
  1666.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1667.                                 'serviceName' => $item->getSrvName(),
  1668.                                 'serviceType' => 'Tecnología',
  1669.                                 'date' => $dateServ,
  1670.                                 'qty' => $unitsServ,
  1671.                                 'iva' => $item->getSrvIva(),
  1672.                                 'pax' => $item->getSrvPax(),
  1673.                                 'precioUnit' => $subnetoUnit,
  1674.                                 'subneto' => $subneto,
  1675.                                 'subtotal' => $subtotal,
  1676.                             );
  1677.                             break;
  1679.                         case 15: //Assisstant
  1680.                             $pax = $item->getSrvPax();
  1681.                             if (empty($pax) or $pax == "0") {
  1682.                                 $pax = 1;
  1683.                             }
  1685.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1686.                             if ($days > 1) {
  1687.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1688.                             } else {
  1689.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1690.                             }
  1692.                             $unitsServ = $item->getSrvUnits();
  1693.                             if (empty($unitsServ) or $unitsServ == "0") {
  1694.                                 $unitsServ = 1;
  1695.                             }
  1697.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1698.                             $subnetoUnit = $subneto;
  1699.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1701.                             $data_supplier['service'][$i] = array(
  1702.                                 'id' => $item->getId(),
  1703.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1704.                                 'serviceName' => $item->getSrvName(),
  1705.                                 'serviceType' => 'Asistente',
  1706.                                 'date' => $dateServ,
  1707.                                 'qty' => $unitsServ,
  1708.                                 'iva' => $item->getSrvIva(),
  1709.                                 'pax' => $item->getSrvPax(),
  1710.                                 'precioUnit' => $subnetoUnit,
  1711.                                 'subneto' => $subneto,
  1712.                                 'subtotal' => $subtotal,
  1713.                             );
  1714.                             break;
  1716.                         case 16: //DDR
  1717.                             $pax = $item->getSrvPax();
  1718.                             if (empty($pax) or $pax == "0") {
  1719.                                 $pax = 1;
  1720.                             }
  1722.                             $days = ((($item->getSrvDateOutAt())->diff($item->getSrvDateInAt()))->days + 1);
  1723.                             if ($days > 1) {
  1724.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y') . ' - ' . ($item->getSrvDateOutAt())->format('d/m/Y');
  1725.                             } else {
  1726.                                 $dateServ = ($item->getSrvDateInAt())->format('d/m/Y');
  1727.                             }
  1729.                             $unitsServ = $item->getSrvUnits();
  1730.                             if (empty($unitsServ) or $unitsServ == "0") {
  1731.                                 $unitsServ = 1;
  1732.                             }
  1734.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1735.                             $subnetoUnit = $subneto;
  1736.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1738.                             $data_supplier['service'][$i] = array(
  1739.                                 'id' => $item->getId(),
  1740.                                 'serviceCatId' => $item->getSrvServiceCatId(),
  1741.                                 'serviceName' => $item->getSrvName(),
  1742.                                 'serviceType' => 'DDR',
  1743.                                 'date' => $dateServ,
  1744.                                 'qty' => $unitsServ,
  1745.                                 'iva' => $item->getSrvIva(),
  1746.                                 'pax' => $item->getSrvPax(),
  1747.                                 'precioUnit' => $subnetoUnit,
  1748.                                 'subneto' => $subneto,
  1749.                                 'subtotal' => $subtotal,
  1750.                             );
  1751.                             break;
  1753.                         default:
  1754.                             break;
  1755.                     }
  1757.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  1758.                     $subtotal = round($subtotal, 2, PHP_ROUND_HALF_UP);
  1759.                     $neto = round($subneto, 2, PHP_ROUND_HALF_UP);
  1761.                     $arrayItems[] = array(
  1762.                         'type' => 'Service',
  1763.                         'name' => $item->getSrvName(),
  1764.                         'amount' => $neto,
  1765.                         'iva' => $item->getSrvIva(),
  1766.                         'total' => $subtotal,
  1767.                     );
  1769.                 }
  1771.                 switch ($item->getSrvIva()) {
  1772.                     // Acumula IVA
  1773.                     case 21:
  1774.                         $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getSrvIva() / 100));
  1775.                         break;
  1777.                     case 10:
  1778.                         $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getSrvIva() / 100));
  1779.                         break;
  1781.                     case 0:
  1782.                         break;
  1784.                     default:
  1785.                         break;
  1787.                 }
  1788.             } else {
  1789.                 // Es una proforma
  1790.                 if (is_null($item->getPrice()) or empty($item->getPrice())) {
  1791.                     $subtotal = 0;
  1792.                     $neto = 0;
  1793.                     $subtotalService = 0;
  1795.                 } else {
  1796.                     $subtotalService = $item->getPrice();
  1797.                     $subneto = $item->getPrice();
  1799.                     // Commission
  1800.                     if ($item->getOpCommission() == '1') {
  1801.                         $subtotalService = $subtotalService * (1 + ($item->getCommission() / 100));
  1802.                         $subneto = $subneto * (1 + ($item->getCommission() / 100));
  1803.                     } else {
  1804.                         $subtotalService = $subtotalService * (1 - ($item->getCommission() / 100));
  1805.                         $subneto = $subneto * (1 - ($item->getCommission() / 100));
  1806.                     }
  1808.                     // Over
  1809.                     if ($item->getOpOver() == '1') {
  1810.                         $subtotalService = $subtotalService + $item->getOver();
  1811.                         $subneto = $subneto + $item->getOver();
  1812.                     } else {
  1813.                         $subtotalService = $subtotalService - $item->getOver();
  1814.                         $subneto = $subneto - $item->getOver();
  1815.                     }
  1817.                     // IVA
  1818.                     if ($item->getOpIva() == '1') {
  1819.                         $subtotalService = $subtotalService * (1 + ($item->getIva() / 100));
  1820.                     } else {
  1821.                         $subtotalService = $item->getPrice();
  1822.                         $subneto = ($subneto * 100) / (100 + $item->getIva());
  1823.                     }
  1825.                     switch ($item->getServiceCatId()) {
  1826.                         case 1: // Alojamiento
  1827.                             // el numero de noches $numNoches; precio unitario $subneto
  1828.                             $numNoches = (($item->getDateOutAt())->diff($item->getDateInAt()))->days;
  1829.                             // La personas no afectan este calculo
  1830.                             $subtotal = $subtotalService * $numNoches * $item->getUnits();
  1831.                             $subnetoUnit = $subneto;
  1833.                             $subneto = $subneto * $numNoches * $item->getUnits();
  1835.                             $data_supplier['service'][$i] = array(
  1836.                                 'id' => $item->getId(),
  1837.                                 'serviceCatId' => $item->getServiceCatId(),
  1838.                                 'serviceName' => $item->getName(),
  1839.                                 'serviceType' => 'Hotel',
  1840.                                 'date' => ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y'),
  1841.                                 'qty' => $item->getUnits(),
  1842.                                 'iva' => $item->getIva(),
  1843.                                 'pax' => '-',
  1844.                                 'precioUnit' => $subnetoUnit,
  1845.                                 'subneto' => $subneto,
  1846.                                 'subtotal' => $subtotal,
  1847.                             );
  1848.                             break;
  1850.                         case 2: //Actividades
  1851.                             // El número de personas es considerado en el calculo
  1852.                             $pax = $item->getPax();
  1853.                             if (empty($pax) or $pax == "0") {
  1854.                                 $pax = 1;
  1855.                             }
  1856.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1858.                             if ($days > 1) {
  1859.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  1860.                             } else {
  1861.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1862.                             }
  1864.                             $subtotal = $subtotalService * $days * $item->getUnits();
  1865.                             $subnetoUnit = $subneto;
  1866.                             $subneto = $subneto * $days * $item->getUnits();
  1868.                             $data_supplier['service'][$i] = array(
  1869.                                 'id' => $item->getId(),
  1870.                                 'serviceCatId' => $item->getServiceCatId(),
  1871.                                 'serviceName' => $item->getName(),
  1872.                                 'serviceType' => 'Actividad',
  1873.                                 'date' => $dateServ,
  1874.                                 'qty' => $item->getUnits(),
  1875.                                 'iva' => $item->getIva(),
  1876.                                 'pax' => $item->getPax(),
  1877.                                 'precioUnit' => $subnetoUnit,
  1878.                                 'subneto' => $subneto,
  1879.                                 'subtotal' => $subtotal,
  1880.                             );
  1881.                             break;
  1883.                         case 3: // AV
  1884.                             $pax = $item->getPax();
  1885.                             if (empty($pax) or $pax == "0") {
  1886.                                 $pax = 1;
  1887.                             }
  1889.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1890.                             if ($days > 1) {
  1891.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  1892.                             } else {
  1893.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1894.                             }
  1896.                             $unitsServ = $item->getUnits();
  1897.                             if (empty($unitsServ) or $unitsServ == "0") {
  1898.                                 $unitsServ = 1;
  1899.                             }
  1901.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1902.                             $subnetoUnit = $subneto;
  1903.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1905.                             $data_supplier['service'][$i] = array(
  1906.                                 'id' => $item->getId(),
  1907.                                 'serviceCatId' => $item->getServiceCatId(),
  1908.                                 'serviceName' => $item->getName(),
  1909.                                 'serviceType' => 'AV',
  1910.                                 'date' => $dateServ,
  1911.                                 'qty' => $unitsServ,
  1912.                                 'iva' => $item->getIva(),
  1913.                                 'pax' => $item->getPax(),
  1914.                                 'precioUnit' => $subnetoUnit,
  1915.                                 'subneto' => $subneto,
  1916.                                 'subtotal' => $subtotal,
  1917.                             );
  1918.                             break;
  1920.                         case 4: //Creative
  1921.                             $pax = $item->getPax();
  1922.                             if (empty($pax) or $pax == "0") {
  1923.                                 $pax = 1;
  1924.                             }
  1926.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  1927.                             if ($days > 1) {
  1928.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  1929.                             } else {
  1930.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1931.                             }
  1933.                             $unitsServ = $item->getUnits();
  1934.                             if (empty($unitsServ) or $unitsServ == "0") {
  1935.                                 $unitsServ = 1;
  1936.                             }
  1938.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1939.                             $subnetoUnit = $subneto;
  1940.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1942.                             $data_supplier['service'][$i] = array(
  1943.                                 'id' => $item->getId(),
  1944.                                 'serviceCatId' => $item->getServiceCatId(),
  1945.                                 'serviceName' => $item->getName(),
  1946.                                 'serviceType' => 'Creativo',
  1947.                                 'date' => $dateServ,
  1948.                                 'qty' => $unitsServ,
  1949.                                 'iva' => $item->getIva(),
  1950.                                 'pax' => $item->getPax(),
  1951.                                 'precioUnit' => $subnetoUnit,
  1952.                                 'subneto' => $subneto,
  1953.                                 'subtotal' => $subtotal,
  1954.                             );
  1955.                             break;
  1957.                         case 5: //Cruise
  1958.                             $pax = $item->getPax();
  1959.                             if (empty($pax) or $pax == "0") {
  1960.                                 $pax = 1;
  1961.                             }
  1963.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days);
  1964.                             if ($days > 1) {
  1965.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  1966.                             } else {
  1967.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  1968.                             }
  1970.                             $unitsServ = $item->getUnits();
  1971.                             if (empty($unitsServ) or $unitsServ == "0") {
  1972.                                 $unitsServ = 1;
  1973.                             }
  1975.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  1976.                             $subnetoUnit = $subneto;
  1977.                             $subneto = $subneto * $days * $unitsServ * $pax;
  1979.                             $data_supplier['service'][$i] = array(
  1980.                                 'id' => $item->getId(),
  1981.                                 'serviceCatId' => $item->getServiceCatId(),
  1982.                                 'serviceName' => $item->getName(),
  1983.                                 'serviceType' => 'Crucero',
  1984.                                 'date' => $dateServ,
  1985.                                 'qty' => $unitsServ,
  1986.                                 'iva' => $item->getIva(),
  1987.                                 'pax' => $item->getPax(),
  1988.                                 'precioUnit' => $subnetoUnit,
  1989.                                 'subneto' => $subneto,
  1990.                                 'subtotal' => $subtotal,
  1991.                             );
  1992.                             break;
  1994.                         case 6: //Entertaiment
  1995.                             $pax = $item->getPax();
  1996.                             if (empty($pax) or $pax == "0") {
  1997.                                 $pax = 1;
  1998.                             }
  2000.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2001.                             if ($days > 1) {
  2002.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2003.                             } else {
  2004.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2005.                             }
  2007.                             $unitsServ = $item->getUnits();
  2008.                             if (empty($unitsServ) or $unitsServ == "0") {
  2009.                                 $unitsServ = 1;
  2010.                             }
  2012.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2013.                             $subnetoUnit = $subneto;
  2014.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2016.                             $data_supplier['service'][$i] = array(
  2017.                                 'id' => $item->getId(),
  2018.                                 'serviceCatId' => $item->getServiceCatId(),
  2019.                                 'serviceName' => $item->getName(),
  2020.                                 'serviceType' => 'Entretenimiento',
  2021.                                 'date' => $dateServ,
  2022.                                 'qty' => $unitsServ,
  2023.                                 'iva' => $item->getIva(),
  2024.                                 'pax' => $item->getPax(),
  2025.                                 'precioUnit' => $subnetoUnit,
  2026.                                 'subneto' => $subneto,
  2027.                                 'subtotal' => $subtotal,
  2028.                             );
  2029.                             break;
  2031.                         case 7: // Gifts
  2032.                             $pax = $item->getPax();
  2033.                             if (empty($pax) or $pax == "0") {
  2034.                                 $pax = 1;
  2035.                             }
  2037. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2038.                             $days = 1;
  2039.                             if ($days > 1) {
  2040.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2041.                             } else {
  2042.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2043.                             }
  2045.                             $unitsServ = $item->getUnits();
  2046.                             if (empty($unitsServ) or $unitsServ == "0") {
  2047.                                 $unitsServ = 1;
  2048.                             }
  2050.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2051.                             $subnetoUnit = $subneto;
  2052.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2054.                             $data_supplier['service'][$i] = array(
  2055.                                 'id' => $item->getId(),
  2056.                                 'serviceCatId' => $item->getServiceCatId(),
  2057.                                 'serviceName' => $item->getName(),
  2058.                                 'serviceType' => 'Regalos',
  2059.                                 'date' => $dateServ,
  2060.                                 'qty' => $unitsServ,
  2061.                                 'iva' => $item->getIva(),
  2062.                                 'pax' => $item->getPax(),
  2063.                                 'precioUnit' => $subnetoUnit,
  2064.                                 'subneto' => $subneto,
  2065.                                 'subtotal' => $subtotal,
  2066.                             );
  2067.                             break;
  2069.                         case 8: //Guide
  2070.                             $pax = $item->getPax();
  2071.                             if (empty($pax) or $pax == "0") {
  2072.                                 $pax = 1;
  2073.                             }
  2075.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2076.                             if ($days > 1) {
  2077.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2078.                             } else {
  2079.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2080.                             }
  2082.                             $unitsServ = $item->getUnits();
  2083.                             if (empty($unitsServ) or $unitsServ == "0") {
  2084.                                 $unitsServ = 1;
  2085.                             }
  2087.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2088.                             $subnetoUnit = $subneto;
  2089.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2091.                             $data_supplier['service'][$i] = array(
  2092.                                 'id' => $item->getId(),
  2093.                                 'serviceCatId' => $item->getServiceCatId(),
  2094.                                 'serviceName' => $item->getName(),
  2095.                                 'serviceType' => 'Regalos',
  2096.                                 'date' => $dateServ,
  2097.                                 'qty' => $unitsServ,
  2098.                                 'iva' => $item->getIva(),
  2099.                                 'pax' => $item->getPax(),
  2100.                                 'precioUnit' => $subnetoUnit,
  2101.                                 'subneto' => $subneto,
  2102.                                 'subtotal' => $subtotal,
  2103.                             );
  2104.                             break;
  2106.                         case 9: //Itineraries
  2107.                             $pax = $item->getPax();
  2108.                             if (empty($pax) or $pax == "0") {
  2109.                                 $pax = 1;
  2110.                             }
  2112.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2113.                             if ($days > 1) {
  2114.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2115.                             } else {
  2116.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2117.                             }
  2119.                             $unitsServ = $item->getUnits();
  2120.                             if (empty($unitsServ) or $unitsServ == "0") {
  2121.                                 $unitsServ = 1;
  2122.                             }
  2124.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2125.                             $subnetoUnit = $subneto;
  2126.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2128.                             $data_supplier['service'][$i] = array(
  2129.                                 'id' => $item->getId(),
  2130.                                 'serviceCatId' => $item->getServiceCatId(),
  2131.                                 'serviceName' => $item->getName(),
  2132.                                 'serviceType' => 'Itinerarios',
  2133.                                 'date' => $dateServ,
  2134.                                 'qty' => $unitsServ,
  2135.                                 'iva' => $item->getIva(),
  2136.                                 'pax' => $item->getPax(),
  2137.                                 'precioUnit' => $subnetoUnit,
  2138.                                 'subneto' => $subneto,
  2139.                                 'subtotal' => $subtotal,
  2140.                             );
  2141.                             break;
  2143.                         case 10: //Lounge  -- No Aplica
  2144. //                        $pax = $item->getPax();
  2145. //                        if (empty($pax) or $pax == "0") {
  2146. //                            $pax = 1;
  2147. //                        }
  2148. //
  2149. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2150. //                        if ($days > 1){
  2151. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2152. //                        } else {
  2153. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2154. //                        }
  2155. //
  2156. //                        $unitsServ = $item->getUnits();
  2157. //                        if (empty($unitsServ) or $unitsServ == "0") {
  2158. //                            $unitsServ = 1;
  2159. //                        }
  2160. //
  2161. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2162. //                        $subnetoUnit = $subneto;
  2163. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  2164. //
  2165. //                        $data_supplier['service'][$i] = array (
  2166. //                            'id' => $item->getId(),
  2167. //                            'serviceCatId' => $item->getServiceCatId(),
  2168. //                            'serviceName' => $item->getName(),
  2169. //                            'serviceType' => 'Itinerarios',
  2170. //                            'date' => $dateServ,
  2171. //                            'qty' => $unitsServ,
  2172. //                            'iva' => $item->getIva(),
  2173. //                            'pax' => $item->getPax(),
  2174. //                            'precioUnit' => $subnetoUnit,
  2175. //                            'subneto' => $subneto,
  2176. //                            'subtotal' => $subtotal,
  2177. //                        );
  2178.                             break;
  2180.                         case 11: //Menu
  2181.                             $pax = $item->getPax();
  2182.                             if (empty($pax) or $pax == "0") {
  2183.                                 $pax = 1;
  2184.                             }
  2186.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2187.                             if ($days > 1) {
  2188.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2189.                             } else {
  2190.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2191.                             }
  2193.                             $unitsServ = $item->getUnits();
  2194.                             if (empty($unitsServ) or $unitsServ == "0") {
  2195.                                 $unitsServ = 1;
  2196.                             }
  2198.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2199.                             $subnetoUnit = $subneto;
  2200.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2202.                             $data_supplier['service'][$i] = array(
  2203.                                 'id' => $item->getId(),
  2204.                                 'serviceCatId' => $item->getServiceCatId(),
  2205.                                 'serviceName' => $item->getName(),
  2206.                                 'serviceType' => 'Menú',
  2207.                                 'date' => $dateServ,
  2208.                                 'qty' => $unitsServ,
  2209.                                 'iva' => $item->getIva(),
  2210.                                 'pax' => $item->getPax(),
  2211.                                 'precioUnit' => $subnetoUnit,
  2212.                                 'subneto' => $subneto,
  2213.                                 'subtotal' => $subtotal,
  2214.                             );
  2215.                             break;
  2217.                         case 12: //Others
  2218.                             $pax = $item->getPax();
  2219.                             if (empty($pax) or $pax == "0") {
  2220.                                 $pax = 1;
  2221.                             }
  2223.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2224.                             if ($days > 1) {
  2225.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2226.                             } else {
  2227.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2228.                             }
  2230.                             $unitsServ = $item->getUnits();
  2231.                             if (empty($unitsServ) or $unitsServ == "0") {
  2232.                                 $unitsServ = 1;
  2233.                             }
  2235.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2236.                             $subnetoUnit = $subneto;
  2237.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2239.                             $data_supplier['service'][$i] = array(
  2240.                                 'id' => $item->getId(),
  2241.                                 'serviceCatId' => $item->getServiceCatId(),
  2242.                                 'serviceName' => $item->getName(),
  2243.                                 'serviceType' => 'Otros',
  2244.                                 'date' => $dateServ,
  2245.                                 'qty' => $unitsServ,
  2246.                                 'iva' => $item->getIva(),
  2247.                                 'pax' => $item->getPax(),
  2248.                                 'precioUnit' => $subnetoUnit,
  2249.                                 'subneto' => $subneto,
  2250.                                 'subtotal' => $subtotal,
  2251.                             );
  2252.                             break;
  2254.                         case 13: //Transport
  2255.                             $pax = $item->getPax();
  2256.                             if (empty($pax) or $pax == "0") {
  2257.                                 $pax = 1;
  2258.                             }
  2260.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2261.                             if ($days > 1) {
  2262.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2263.                             } else {
  2264.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2265.                             }
  2267.                             $unitsServ = $item->getUnits();
  2268.                             if (empty($unitsServ) or $unitsServ == "0") {
  2269.                                 $unitsServ = 1;
  2270.                             }
  2272.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2273.                             $subnetoUnit = $subneto;
  2274.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2276.                             $data_supplier['service'][$i] = array(
  2277.                                 'id' => $item->getId(),
  2278.                                 'serviceCatId' => $item->getServiceCatId(),
  2279.                                 'serviceName' => $item->getName(),
  2280.                                 'serviceType' => 'Transporte',
  2281.                                 'date' => $dateServ,
  2282.                                 'qty' => $unitsServ,
  2283.                                 'iva' => $item->getIva(),
  2284.                                 'pax' => $item->getPax(),
  2285.                                 'precioUnit' => $subnetoUnit,
  2286.                                 'subneto' => $subneto,
  2287.                                 'subtotal' => $subtotal,
  2288.                             );
  2289.                             break;
  2291.                         case 14: //Technology
  2292.                             $pax = $item->getPax();
  2293.                             if (empty($pax) or $pax == "0") {
  2294.                                 $pax = 1;
  2295.                             }
  2297. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2298.                             $days = 1;
  2299. //                        if ($days > 1){
  2300. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2301. //                        } else {
  2302. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2303. //                        }
  2304.                             $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2306.                             $unitsServ = $item->getUnits();
  2307.                             if (empty($unitsServ) or $unitsServ == "0") {
  2308.                                 $unitsServ = 1;
  2309.                             }
  2311.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2312.                             $subnetoUnit = $subneto;
  2313.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2315.                             $data_supplier['service'][$i] = array(
  2316.                                 'id' => $item->getId(),
  2317.                                 'serviceCatId' => $item->getServiceCatId(),
  2318.                                 'serviceName' => $item->getName(),
  2319.                                 'serviceType' => 'Tecnología',
  2320.                                 'date' => $dateServ,
  2321.                                 'qty' => $unitsServ,
  2322.                                 'iva' => $item->getIva(),
  2323.                                 'pax' => $item->getPax(),
  2324.                                 'precioUnit' => $subnetoUnit,
  2325.                                 'subneto' => $subneto,
  2326.                                 'subtotal' => $subtotal,
  2327.                             );
  2328.                             break;
  2330.                         case 15: //Assisstant
  2331.                             $pax = $item->getPax();
  2332.                             if (empty($pax) or $pax == "0") {
  2333.                                 $pax = 1;
  2334.                             }
  2336.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2337.                             if ($days > 1) {
  2338.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2339.                             } else {
  2340.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2341.                             }
  2343.                             $unitsServ = $item->getUnits();
  2344.                             if (empty($unitsServ) or $unitsServ == "0") {
  2345.                                 $unitsServ = 1;
  2346.                             }
  2348.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2349.                             $subnetoUnit = $subneto;
  2350.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2352.                             $data_supplier['service'][$i] = array(
  2353.                                 'id' => $item->getId(),
  2354.                                 'serviceCatId' => $item->getServiceCatId(),
  2355.                                 'serviceName' => $item->getName(),
  2356.                                 'serviceType' => 'Asistente',
  2357.                                 'date' => $dateServ,
  2358.                                 'qty' => $unitsServ,
  2359.                                 'iva' => $item->getIva(),
  2360.                                 'pax' => $item->getPax(),
  2361.                                 'precioUnit' => $subnetoUnit,
  2362.                                 'subneto' => $subneto,
  2363.                                 'subtotal' => $subtotal,
  2364.                             );
  2365.                             break;
  2367.                         case 16: //DDR
  2368.                             $pax = $item->getPax();
  2369.                             if (empty($pax) or $pax == "0") {
  2370.                                 $pax = 1;
  2371.                             }
  2373.                             $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2374.                             if ($days > 1) {
  2375.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y') . ' - ' . ($item->getDateOutAt())->format('d/m/Y');
  2376.                             } else {
  2377.                                 $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2378.                             }
  2380.                             $unitsServ = $item->getUnits();
  2381.                             if (empty($unitsServ) or $unitsServ == "0") {
  2382.                                 $unitsServ = 1;
  2383.                             }
  2385.                             $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2386.                             $subnetoUnit = $subneto;
  2387.                             $subneto = $subneto * $days * $unitsServ * $pax;
  2389.                             $data_supplier['service'][$i] = array(
  2390.                                 'id' => $item->getId(),
  2391.                                 'serviceCatId' => $item->getServiceCatId(),
  2392.                                 'serviceName' => $item->getName(),
  2393.                                 'serviceType' => 'DDR',
  2394.                                 'date' => $dateServ,
  2395.                                 'qty' => $unitsServ,
  2396.                                 'iva' => $item->getIva(),
  2397.                                 'pax' => $item->getPax(),
  2398.                                 'precioUnit' => $subnetoUnit,
  2399.                                 'subneto' => $subneto,
  2400.                                 'subtotal' => $subtotal,
  2401.                             );
  2402.                             break;
  2404.                         default:
  2405.                             break;
  2406.                     }
  2408.                     // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  2409.                     $subtotal = round($subtotal, 2, PHP_ROUND_HALF_UP);
  2410.                     $neto = round($subneto, 2, PHP_ROUND_HALF_UP);
  2412.                     $arrayItems[] = array(
  2413.                         'type' => 'Service',
  2414.                         'name' => $item->getName(),
  2415.                         'amount' => $neto,
  2416.                         'iva' => $item->getIva(),
  2417.                         'total' => $subtotal,
  2418.                     );
  2420.                 }
  2422.                 switch ($item->getIva()) {
  2423.                     // Acumula IVA
  2424.                     case 21:
  2425.                         $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getIva() / 100));
  2426.                         break;
  2428.                     case 10:
  2429.                         $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getIva() / 100));
  2430.                         break;
  2432.                     case 0:
  2433.                         break;
  2435.                     default:
  2436.                         break;
  2437.                 }
  2438.             }
  2440.             $totales_neto_all = $totales_neto_all + $neto;
  2442.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2443.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  2444.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  2445.             $data_iva['ivaMontoDiez'] = round($data_iva['ivaMontoDiez'],2,PHP_ROUND_HALF_UP);
  2446.             // Acumula netos totales e IVA
  2448.             $service['neto'] = $service['neto'] + $neto;
  2449.             $service['sumSubT'] = $service['sumSubT'] + $subtotal;
  2450.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2451.             $service['neto'] = round($service['neto'],2,PHP_ROUND_HALF_UP);
  2452.             $service['sumSubT'] = round($service['sumSubT'],2,PHP_ROUND_HALF_UP);
  2454.             $i++;
  2455.         }
  2457.         $data_supplier['serviceSubTotal'] = array(
  2458.             'neto' => $service['neto'],
  2459.             'sumSubT' => $service['sumSubT'],
  2460.         );
  2461.         $currency = '€';
  2462.         $totales_total = $totales_neto_all + $data_iva['ivaMontoVeintiUno'] + $data_iva['ivaMontoDiez'];
  2463.         if (!empty($payments)) {
  2464.             $amount_pay = $data_supplier['paymentSubTotal']['sumSubT'];
  2465.         } else {
  2466.             $amount_pay = 0;
  2467.         }
  2468.         $totales_all = $totales_total - $amount_pay;
  2470.         if (empty($dateDocument)){
  2471.             $dateDocument = new DateTime('now');
  2472.         }
  2474.         $data = array(
  2475.             'id' => $fileId,
  2476.             'type' => $type,
  2477. //            'type' => '',
  2478.             'number' => $number,
  2479. //            'prefix' => $prefix,
  2480.             'prefix' => 'MDV-'.(new DateTime('now'))->format('dmy').'-'.$invoiceId,
  2481.             'date' => $dateDocument,
  2482.             'file' => $file,
  2483.             'token' => $file->getAccessKey(),
  2484.             'company' => $company,
  2485.             'clients' => $client,
  2486.             'arrayItems' => $arrayItems,
  2487.             'datasupplier' => $data_supplier,
  2488.             'currency' => $currency,
  2489.             'totales_neto' => $totales_neto_all,
  2490.             'bases_imponibles' => $data_iva,
  2491.             'totales' => $totales_total,
  2492.             'balance' => $totales_all,
  2493.             'paymentInvoice' => $amount_pay,
  2494.         );
  2495.         return $data;
  2496.     }
  2498.     // Replicar cambios entre FileController y ProductsFilesController
  2499.     private function calculosFile($id, $arrayBools, $number, $type)
  2500.     {
  2501.         // $id Id del Expediente (File)
  2502.         // $arrayBool arreglo de logicos
  2503.         // $number  *********************
  2504.         // $type tipo de calculos a realizar (edicion de expediente, factura, factura de deposito, proforma)
  2507.         $em = $this->getDoctrine()->getManager();
  2508.         $file = $em->getRepository(MdvFiles::class)->findOneById($id);
  2509.         $items = $em->getRepository(MdvProductFile::class)->findByFileId($file->getId());
  2510.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('3');
  2511.         $client = $em->getRepository(Client::class)->findById($file->getClient());
  2512.         if (!empty($client)){
  2513.             $city = ($em->getRepository(Cities::class)->findOneById($client[0]->getPopulation()));
  2514.             $client[0]->setPopulation($city);
  2515.             $region = ($em->getRepository(Regions::class)->findOneById($client[0]->getRegion()));
  2516.             $client[0]->setRegion($region);
  2517.             $country = ($em->getRepository(Country::class)->findOneById($client[0]->getCountry()));
  2518.             $client[0]->setCountry($country);
  2519.         } else {
  2520.             $client[0] = new Client();
  2521.             $client[0]->setName('');
  2522.             $client[0]->setTitle('');
  2523.             $client[0]->setIdDocument('');
  2524.             $client[0]->setPopulation('');
  2525.             $client[0]->setRegion('');
  2526.             $client[0]->setCountry('');
  2527.         }
  2529.         // Acumuladores de los calculos
  2530.         $totales_neto_all = 0;
  2531.         $data_iva = array(
  2532.             'iva' => 21,
  2533.             'ivaMontoVeintiUno' => 0,
  2534.             'ivaMontoDiez' => 0,
  2535.             'ivaMontoCero' => 0,
  2536.         );
  2538.         //INICIO: Determinamos el numero de factura o proforma
  2539.         if (substr($number,0,1) == 'I'){
  2540.             // Es una Factura
  2542.             $numberInvoiceOrProforma = substr($number,1);
  2543.             $number = $numberInvoiceOrProforma;
  2544. //            $number = $em->getRepository('DevelupBundle:FileInvoice')->findOneById($number);
  2545. //            $number = $number->getNumber();
  2546.             $type = 'Invoice';
  2548.         } else {
  2549.             // Es una Proforma
  2551.             $numberInvoiceOrProforma = substr($number,1);
  2552.             $number = $numberInvoiceOrProforma;
  2553. //            $number = $em->getRepository('DevelupBundle:FileProforma')->findOneById($number);
  2554. //            $number = $number->getPrefix().$number->getReservationId();
  2555.             $type = 'Proforma';
  2556.         }
  2557.         //FIN: Determinamos el numero de factura o proforma
  2559.         // Buscamos las salas reservadas, pagos y servicios para el evento
  2561.         $arrayItems = array();
  2562.         $fileProducts = array();
  2563.         if (!empty($arrayBools['lounge'])) {
  2564.             foreach ($arrayBools['lounge'] as $key => $item) {
  2565.                 if ($item == 'true') {
  2566. //                    $fileProducts[] = $em->getRepository('DevelupBundle:ReservationLoungeSimple')->findOneById($key);
  2567.                 }
  2568.             }
  2569.         }
  2571.         $payments = array();
  2572.         if (!empty($arrayBools['payment'])) {
  2573.             foreach ($arrayBools['payment'] as $key => $item) {
  2574.                 if ($item == 'true') {
  2575. //                    $payments[] = $em->getRepository('DevelupBundle:ReservationPaymentsClient')->findOneById($key);
  2576.                 }
  2577.             }
  2578.         }
  2580.         $services = array();
  2581.         if (!empty($arrayBools['service'])) {
  2582.             foreach ($arrayBools['service'] as $key => $item) {
  2583.                 if ($item == 'true') {
  2584. //                    $services[] = $em->getRepository('DevelupBundle:ReservationService')->findOneById($key);
  2585.                 }
  2586.             }
  2587.         }
  2589.         $data_supplier = array();
  2590.         $i = 0;
  2592.         $iva = '21';            // Esteban Rincon: "Por Ley de localización del impuesto, siempre será un 21%"
  2593.         $pax = '-';
  2594.         $qty = '1';
  2595.         $product = array(
  2596.             'neto' => 0,
  2597.             'sumSubT' => 0,
  2598.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  2600.         $service = array(
  2601.             'neto' => 0,
  2602.             'sumSubT' => 0,
  2603.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  2605.         if (empty($items)){
  2606.             $data_supplier['product'][0] = null;
  2607.         }
  2609.         foreach ($items as $item){
  2610.             $days = '1';
  2612.             if (!empty($item->getUnits())){
  2613.                 $qty = $item->getUnits();
  2614.             }
  2616.             if (!empty($item->getDays())){
  2617.                 $days = $item->getDays();
  2618.             }
  2620.             if (is_null($item->getServicePrice()) or empty($item->getServicePrice())){
  2621.                 $subtotal = 0;
  2622.                 $neto = 0;
  2623.                 $subtotalProduct = 0;
  2624.             } else {
  2626. //                $subtotalProduct = $item->getServicePrice() * 1.21;
  2627.                 $subtotalProduct = $item->getSubTotalPrice() * 1.21;
  2628. //                $subneto = $item->getServicePrice();
  2629.                 $subneto = $item->getSubTotalPrice();
  2631.                 $subtotal =  $subtotalProduct;
  2632.                 $neto =  $subneto;
  2634.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  2635.                 $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  2636.                 $neto = round($neto,2,PHP_ROUND_HALF_UP);
  2638.                 $arrayItems[] = array(
  2639.                     'type' => 'Product',
  2640.                     'name' => $item->getProductName(),
  2641.                     'amount' => $neto,
  2642.                     'iva' => '21',
  2643.                     'total' => $subtotal,
  2644.                 );
  2645.             }
  2647.             // Acumula netos totales e IVA
  2648.             $totales_neto_all = $totales_neto_all + $neto;
  2649.             $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * 0.21);
  2650.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2651.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  2652.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  2653.             // Acumula netos totales e IVA
  2655.             $product['neto'] = $product['neto'] + $neto;
  2656.             $product['sumSubT'] = $product['sumSubT'] + $subtotal;
  2657.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2658.             $product['neto'] = round($product['neto'],2,PHP_ROUND_HALF_UP);
  2659.             $product['sumSubT'] = round($product['sumSubT'],2,PHP_ROUND_HALF_UP);
  2661.             $data_supplier['product'][$i] = array (
  2662.                 'id' => $item->getId(),
  2663.                 'productName' => $item->getProductName(),
  2664.                 'description' => $item->getDescription(),
  2665.                 'productId' => $item->getProductId(),
  2666.                 'dateStart' => $item->getDateStart(),
  2667.                 'dateEnd' => $item->getDateEnd(),
  2668.                 'servicePrice' => $item->getServicePrice(),
  2669.                 'subTotalPrice' => $item->getSubTotalPrice(),
  2670.                 'subtotalProduct' => $subtotalProduct,
  2671.                 'iva' => $iva,
  2672.                 'pax' => $pax,
  2673.                 'qty' => $qty,
  2674.                 'days' => $days,
  2675.                 'type' => $item->getType(),
  2676.                 'subtotal' => $subtotal,
  2677.             );
  2678.             $i++;
  2679.         }
  2681.         $data_supplier['productSubTotal'] = array(
  2682.             'neto' => $product['neto'],
  2683.             'sumSubT' => $product['sumSubT'],
  2684.         );
  2686.         $payment = array(
  2687.             'sumSubT' => 0,
  2688.         ); // Acumula sumatoria de netos y sumantoria de subtotales
  2690.         $i = 0;
  2691.         foreach ($payments as $item){
  2693.             $payment['sumSubT'] = $payment['sumSubT'] + $item->getAmountTotal();
  2694.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  2695.             $payment['sumSubT'] = round($payment['sumSubT'],2,PHP_ROUND_HALF_UP);
  2697.             $data_supplier['payment'][$i] = array (
  2698.                 'id' => $item->getId(),
  2699.                 'amount' => $item->getAmount(),
  2700.                 'amountTotal' => $item->getAmountTotal(),
  2701.                 'vat' => $item->getVat(),
  2702.                 'datePayAt' => $item->getDatePayAt(),
  2703.                 'wayToPay' => $item->getWayToPay(),
  2704.             );
  2706.             $arrayItems[] = array(
  2707.                 'type' => 'Payment',
  2708.                 'name' => $item->getWayToPay(),
  2709.                 'amount' => $item->getAmount(),
  2710.                 'total' => $item->getAmountTotal(),
  2711.                 'iva' => $item->getVat(),
  2712. //                    'iva' => '',
  2713. //                    'total' => $item->getAmount(),
  2714.             );
  2716.             $i++;
  2717.         }
  2719.         if (!empty($payments)) {
  2720.             $data_supplier['paymentSubTotal'] = array(
  2721.                 'sumSubT' => $payment['sumSubT'],
  2722.             );
  2723.         }
  2725.         foreach ($services as $item){
  2726.             if (is_null($item->getPrice()) or empty($item->getPrice())){
  2727.                 $subtotal = 0;
  2728.                 $neto = 0;
  2729.                 $subtotalService = 0;
  2731.             } else {
  2732.                 $subtotalService = $item->getPrice();
  2733.                 $subneto = $item->getPrice();
  2735.                 // Commission
  2736.                 if ($item->getOpCommission()=='1'){
  2737.                     $subtotalService = $subtotalService * (1 + ($item->getCommission()/100));
  2738.                     $subneto = $subneto  * (1 + ($item->getCommission()/100));
  2739.                 } else {
  2740.                     $subtotalService = $subtotalService * (1 - ($item->getCommission()/100));
  2741.                     $subneto = $subneto * (1 - ($item->getCommission()/100));
  2742.                 }
  2744.                 // Over
  2745.                 if ($item->getOpOver()=='1'){
  2746.                     $subtotalService = $subtotalService + $item->getOver();
  2747.                     $subneto = $subneto + $item->getOver();
  2748.                 } else {
  2749.                     $subtotalService = $subtotalService - $item->getOver();
  2750.                     $subneto = $subneto - $item->getOver();
  2751.                 }
  2753.                 // IVA
  2754.                 if ($item->getOpIva()=='1'){
  2755.                     $subtotalService = $subtotalService * (1 + ($item->getIva()/100));
  2756.                 } else {
  2757.                     $subtotalService = $item->getPrice();
  2758.                     $subneto = ($subneto * 100) / (100 + $item->getIva());
  2759.                 }
  2761.                 switch ($item->getServiceCatId()){
  2762.                     case 1: // Alojamiento
  2763.                         // el numero de noches $numNoches; precio unitario $subneto
  2764.                         $numNoches = (($item->getDateOutAt())->diff($item->getDateInAt()))->days;
  2765.                         // La personas no afectan este calculo
  2766.                         $subtotal = $subtotalService * $numNoches * $item->getUnits();
  2767.                         $subnetoUnit = $subneto;
  2769.                         $subneto = $subneto * $numNoches * $item->getUnits();
  2771.                         $data_supplier['service'][$i] = array (
  2772.                             'id' => $item->getId(),
  2773.                             'serviceCatId' => $item->getServiceCatId(),
  2774.                             'serviceName' => $item->getName(),
  2775.                             'serviceType' => 'Hotel',
  2776.                             'date' => ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y'),
  2777.                             'qty' => $item->getUnits(),
  2778.                             'iva' => $item->getIva(),
  2779.                             'pax' => '-',
  2780.                             'precioUnit' => $subnetoUnit,
  2781.                             'subneto' => $subneto,
  2782.                             'subtotal' => $subtotal,
  2783.                         );
  2784.                         break;
  2786.                     case 2: //Actividades
  2787.                         // El número de personas es considerado en el calculo
  2788.                         $pax = $item->getPax();
  2789.                         if (empty($pax) or $pax == "0") {
  2790.                             $pax = 1;
  2791.                         }
  2792.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2794.                         if ($days > 1){
  2795.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2796.                         } else {
  2797.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2798.                         }
  2800.                         $subtotal = $subtotalService * $days * $item->getUnits();
  2801.                         $subnetoUnit = $subneto;
  2802.                         $subneto = $subneto * $days * $item->getUnits();
  2804.                         $data_supplier['service'][$i] = array (
  2805.                             'id' => $item->getId(),
  2806.                             'serviceCatId' => $item->getServiceCatId(),
  2807.                             'serviceName' => $item->getName(),
  2808.                             'serviceType' => 'Actividad',
  2809.                             'date' => $dateServ,
  2810.                             'qty' => $item->getUnits(),
  2811.                             'iva' => $item->getIva(),
  2812.                             'pax' => $item->getPax(),
  2813.                             'precioUnit' => $subnetoUnit,
  2814.                             'subneto' => $subneto,
  2815.                             'subtotal' => $subtotal,
  2816.                         );
  2817.                         break;
  2819.                     case 3: // AV
  2820.                         $pax = $item->getPax();
  2821.                         if (empty($pax) or $pax == "0") {
  2822.                             $pax = 1;
  2823.                         }
  2825.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2826.                         if ($days > 1){
  2827.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2828.                         } else {
  2829.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2830.                         }
  2832.                         $unitsServ = $item->getUnits();
  2833.                         if (empty($unitsServ) or $unitsServ == "0") {
  2834.                             $unitsServ = 1;
  2835.                         }
  2837.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2838.                         $subnetoUnit = $subneto;
  2839.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2841.                         $data_supplier['service'][$i] = array (
  2842.                             'id' => $item->getId(),
  2843.                             'serviceCatId' => $item->getServiceCatId(),
  2844.                             'serviceName' => $item->getName(),
  2845.                             'serviceType' => 'AV',
  2846.                             'date' => $dateServ,
  2847.                             'qty' => $unitsServ,
  2848.                             'iva' => $item->getIva(),
  2849.                             'pax' => $item->getPax(),
  2850.                             'precioUnit' => $subnetoUnit,
  2851.                             'subneto' => $subneto,
  2852.                             'subtotal' => $subtotal,
  2853.                         );
  2854.                         break;
  2856.                     case 4: //Creative
  2857.                         $pax = $item->getPax();
  2858.                         if (empty($pax) or $pax == "0") {
  2859.                             $pax = 1;
  2860.                         }
  2862.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2863.                         if ($days > 1){
  2864.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2865.                         } else {
  2866.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2867.                         }
  2869.                         $unitsServ = $item->getUnits();
  2870.                         if (empty($unitsServ) or $unitsServ == "0") {
  2871.                             $unitsServ = 1;
  2872.                         }
  2874.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2875.                         $subnetoUnit = $subneto;
  2876.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2878.                         $data_supplier['service'][$i] = array (
  2879.                             'id' => $item->getId(),
  2880.                             'serviceCatId' => $item->getServiceCatId(),
  2881.                             'serviceName' => $item->getName(),
  2882.                             'serviceType' => 'Creativo',
  2883.                             'date' => $dateServ,
  2884.                             'qty' => $unitsServ,
  2885.                             'iva' => $item->getIva(),
  2886.                             'pax' => $item->getPax(),
  2887.                             'precioUnit' => $subnetoUnit,
  2888.                             'subneto' => $subneto,
  2889.                             'subtotal' => $subtotal,
  2890.                         );
  2891.                         break;
  2893.                     case 5: //Cruise
  2894.                         $pax = $item->getPax();
  2895.                         if (empty($pax) or $pax == "0") {
  2896.                             $pax = 1;
  2897.                         }
  2899.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days);
  2900.                         if ($days > 1){
  2901.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2902.                         } else {
  2903.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2904.                         }
  2906.                         $unitsServ = $item->getUnits();
  2907.                         if (empty($unitsServ) or $unitsServ == "0") {
  2908.                             $unitsServ = 1;
  2909.                         }
  2911.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2912.                         $subnetoUnit = $subneto;
  2913.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2915.                         $data_supplier['service'][$i] = array (
  2916.                             'id' => $item->getId(),
  2917.                             'serviceCatId' => $item->getServiceCatId(),
  2918.                             'serviceName' => $item->getName(),
  2919.                             'serviceType' => 'Crucero',
  2920.                             'date' => $dateServ,
  2921.                             'qty' => $unitsServ,
  2922.                             'iva' => $item->getIva(),
  2923.                             'pax' => $item->getPax(),
  2924.                             'precioUnit' => $subnetoUnit,
  2925.                             'subneto' => $subneto,
  2926.                             'subtotal' => $subtotal,
  2927.                         );
  2928.                         break;
  2930.                     case 6: //Entertaiment
  2931.                         $pax = $item->getPax();
  2932.                         if (empty($pax) or $pax == "0") {
  2933.                             $pax = 1;
  2934.                         }
  2936.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2937.                         if ($days > 1){
  2938.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2939.                         } else {
  2940.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2941.                         }
  2943.                         $unitsServ = $item->getUnits();
  2944.                         if (empty($unitsServ) or $unitsServ == "0") {
  2945.                             $unitsServ = 1;
  2946.                         }
  2948.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2949.                         $subnetoUnit = $subneto;
  2950.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2952.                         $data_supplier['service'][$i] = array (
  2953.                             'id' => $item->getId(),
  2954.                             'serviceCatId' => $item->getServiceCatId(),
  2955.                             'serviceName' => $item->getName(),
  2956.                             'serviceType' => 'Entretenimiento',
  2957.                             'date' => $dateServ,
  2958.                             'qty' => $unitsServ,
  2959.                             'iva' => $item->getIva(),
  2960.                             'pax' => $item->getPax(),
  2961.                             'precioUnit' => $subnetoUnit,
  2962.                             'subneto' => $subneto,
  2963.                             'subtotal' => $subtotal,
  2964.                         );
  2965.                         break;
  2967.                     case 7: // Gifts
  2968.                         $pax = $item->getPax();
  2969.                         if (empty($pax) or $pax == "0") {
  2970.                             $pax = 1;
  2971.                         }
  2973. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  2974.                         $days = 1;
  2975.                         if ($days > 1){
  2976.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  2977.                         } else {
  2978.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  2979.                         }
  2981.                         $unitsServ = $item->getUnits();
  2982.                         if (empty($unitsServ) or $unitsServ == "0") {
  2983.                             $unitsServ = 1;
  2984.                         }
  2986.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  2987.                         $subnetoUnit = $subneto;
  2988.                         $subneto = $subneto * $days * $unitsServ * $pax;
  2990.                         $data_supplier['service'][$i] = array (
  2991.                             'id' => $item->getId(),
  2992.                             'serviceCatId' => $item->getServiceCatId(),
  2993.                             'serviceName' => $item->getName(),
  2994.                             'serviceType' => 'Regalos',
  2995.                             'date' => $dateServ,
  2996.                             'qty' => $unitsServ,
  2997.                             'iva' => $item->getIva(),
  2998.                             'pax' => $item->getPax(),
  2999.                             'precioUnit' => $subnetoUnit,
  3000.                             'subneto' => $subneto,
  3001.                             'subtotal' => $subtotal,
  3002.                         );
  3003.                         break;
  3005.                     case 8: //Guide
  3006.                         $pax = $item->getPax();
  3007.                         if (empty($pax) or $pax == "0") {
  3008.                             $pax = 1;
  3009.                         }
  3011.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3012.                         if ($days > 1){
  3013.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3014.                         } else {
  3015.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3016.                         }
  3018.                         $unitsServ = $item->getUnits();
  3019.                         if (empty($unitsServ) or $unitsServ == "0") {
  3020.                             $unitsServ = 1;
  3021.                         }
  3023.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3024.                         $subnetoUnit = $subneto;
  3025.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3027.                         $data_supplier['service'][$i] = array (
  3028.                             'id' => $item->getId(),
  3029.                             'serviceCatId' => $item->getServiceCatId(),
  3030.                             'serviceName' => $item->getName(),
  3031.                             'serviceType' => 'Regalos',
  3032.                             'date' => $dateServ,
  3033.                             'qty' => $unitsServ,
  3034.                             'iva' => $item->getIva(),
  3035.                             'pax' => $item->getPax(),
  3036.                             'precioUnit' => $subnetoUnit,
  3037.                             'subneto' => $subneto,
  3038.                             'subtotal' => $subtotal,
  3039.                         );
  3040.                         break;
  3042.                     case 9: //Itineraries
  3043.                         $pax = $item->getPax();
  3044.                         if (empty($pax) or $pax == "0") {
  3045.                             $pax = 1;
  3046.                         }
  3048.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3049.                         if ($days > 1){
  3050.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3051.                         } else {
  3052.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3053.                         }
  3055.                         $unitsServ = $item->getUnits();
  3056.                         if (empty($unitsServ) or $unitsServ == "0") {
  3057.                             $unitsServ = 1;
  3058.                         }
  3060.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3061.                         $subnetoUnit = $subneto;
  3062.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3064.                         $data_supplier['service'][$i] = array (
  3065.                             'id' => $item->getId(),
  3066.                             'serviceCatId' => $item->getServiceCatId(),
  3067.                             'serviceName' => $item->getName(),
  3068.                             'serviceType' => 'Itinerarios',
  3069.                             'date' => $dateServ,
  3070.                             'qty' => $unitsServ,
  3071.                             'iva' => $item->getIva(),
  3072.                             'pax' => $item->getPax(),
  3073.                             'precioUnit' => $subnetoUnit,
  3074.                             'subneto' => $subneto,
  3075.                             'subtotal' => $subtotal,
  3076.                         );
  3077.                         break;
  3079.                     case 10: //Lounge  -- No Aplica
  3080. //                        $pax = $item->getPax();
  3081. //                        if (empty($pax) or $pax == "0") {
  3082. //                            $pax = 1;
  3083. //                        }
  3084. //
  3085. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3086. //                        if ($days > 1){
  3087. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3088. //                        } else {
  3089. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3090. //                        }
  3091. //
  3092. //                        $unitsServ = $item->getUnits();
  3093. //                        if (empty($unitsServ) or $unitsServ == "0") {
  3094. //                            $unitsServ = 1;
  3095. //                        }
  3096. //
  3097. //                        $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3098. //                        $subnetoUnit = $subneto;
  3099. //                        $subneto = $subneto * $days * $unitsServ * $pax;
  3100. //
  3101. //                        $data_supplier['service'][$i] = array (
  3102. //                            'id' => $item->getId(),
  3103. //                            'serviceCatId' => $item->getServiceCatId(),
  3104. //                            'serviceName' => $item->getName(),
  3105. //                            'serviceType' => 'Itinerarios',
  3106. //                            'date' => $dateServ,
  3107. //                            'qty' => $unitsServ,
  3108. //                            'iva' => $item->getIva(),
  3109. //                            'pax' => $item->getPax(),
  3110. //                            'precioUnit' => $subnetoUnit,
  3111. //                            'subneto' => $subneto,
  3112. //                            'subtotal' => $subtotal,
  3113. //                        );
  3114.                         break;
  3116.                     case 11: //Menu
  3117.                         $pax = $item->getPax();
  3118.                         if (empty($pax) or $pax == "0") {
  3119.                             $pax = 1;
  3120.                         }
  3122.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3123.                         if ($days > 1){
  3124.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3125.                         } else {
  3126.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3127.                         }
  3129.                         $unitsServ = $item->getUnits();
  3130.                         if (empty($unitsServ) or $unitsServ == "0") {
  3131.                             $unitsServ = 1;
  3132.                         }
  3134.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3135.                         $subnetoUnit = $subneto;
  3136.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3138.                         $data_supplier['service'][$i] = array (
  3139.                             'id' => $item->getId(),
  3140.                             'serviceCatId' => $item->getServiceCatId(),
  3141.                             'serviceName' => $item->getName(),
  3142.                             'serviceType' => 'Menú',
  3143.                             'date' => $dateServ,
  3144.                             'qty' => $unitsServ,
  3145.                             'iva' => $item->getIva(),
  3146.                             'pax' => $item->getPax(),
  3147.                             'precioUnit' => $subnetoUnit,
  3148.                             'subneto' => $subneto,
  3149.                             'subtotal' => $subtotal,
  3150.                         );
  3151.                         break;
  3153.                     case 12: //Others
  3154.                         $pax = $item->getPax();
  3155.                         if (empty($pax) or $pax == "0") {
  3156.                             $pax = 1;
  3157.                         }
  3159.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3160.                         if ($days > 1){
  3161.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3162.                         } else {
  3163.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3164.                         }
  3166.                         $unitsServ = $item->getUnits();
  3167.                         if (empty($unitsServ) or $unitsServ == "0") {
  3168.                             $unitsServ = 1;
  3169.                         }
  3171.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3172.                         $subnetoUnit = $subneto;
  3173.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3175.                         $data_supplier['service'][$i] = array (
  3176.                             'id' => $item->getId(),
  3177.                             'serviceCatId' => $item->getServiceCatId(),
  3178.                             'serviceName' => $item->getName(),
  3179.                             'serviceType' => 'Otros',
  3180.                             'date' => $dateServ,
  3181.                             'qty' => $unitsServ,
  3182.                             'iva' => $item->getIva(),
  3183.                             'pax' => $item->getPax(),
  3184.                             'precioUnit' => $subnetoUnit,
  3185.                             'subneto' => $subneto,
  3186.                             'subtotal' => $subtotal,
  3187.                         );
  3188.                         break;
  3190.                     case 13: //Transport
  3191.                         $pax = $item->getPax();
  3192.                         if (empty($pax) or $pax == "0") {
  3193.                             $pax = 1;
  3194.                         }
  3196.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3197.                         if ($days > 1){
  3198.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3199.                         } else {
  3200.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3201.                         }
  3203.                         $unitsServ = $item->getUnits();
  3204.                         if (empty($unitsServ) or $unitsServ == "0") {
  3205.                             $unitsServ = 1;
  3206.                         }
  3208.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3209.                         $subnetoUnit = $subneto;
  3210.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3212.                         $data_supplier['service'][$i] = array (
  3213.                             'id' => $item->getId(),
  3214.                             'serviceCatId' => $item->getServiceCatId(),
  3215.                             'serviceName' => $item->getName(),
  3216.                             'serviceType' => 'Transporte',
  3217.                             'date' => $dateServ,
  3218.                             'qty' => $unitsServ,
  3219.                             'iva' => $item->getIva(),
  3220.                             'pax' => $item->getPax(),
  3221.                             'precioUnit' => $subnetoUnit,
  3222.                             'subneto' => $subneto,
  3223.                             'subtotal' => $subtotal,
  3224.                         );
  3225.                         break;
  3227.                     case 14: //Technology
  3228.                         $pax = $item->getPax();
  3229.                         if (empty($pax) or $pax == "0") {
  3230.                             $pax = 1;
  3231.                         }
  3233. //                        $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3234.                         $days = 1;
  3235. //                        if ($days > 1){
  3236. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3237. //                        } else {
  3238. //                            $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3239. //                        }
  3240.                         $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3242.                         $unitsServ = $item->getUnits();
  3243.                         if (empty($unitsServ) or $unitsServ == "0") {
  3244.                             $unitsServ = 1;
  3245.                         }
  3247.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3248.                         $subnetoUnit = $subneto;
  3249.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3251.                         $data_supplier['service'][$i] = array (
  3252.                             'id' => $item->getId(),
  3253.                             'serviceCatId' => $item->getServiceCatId(),
  3254.                             'serviceName' => $item->getName(),
  3255.                             'serviceType' => 'Tecnología',
  3256.                             'date' => $dateServ,
  3257.                             'qty' => $unitsServ,
  3258.                             'iva' => $item->getIva(),
  3259.                             'pax' => $item->getPax(),
  3260.                             'precioUnit' => $subnetoUnit,
  3261.                             'subneto' => $subneto,
  3262.                             'subtotal' => $subtotal,
  3263.                         );
  3264.                         break;
  3266.                     case 15: //Assisstant
  3267.                         $pax = $item->getPax();
  3268.                         if (empty($pax) or $pax == "0") {
  3269.                             $pax = 1;
  3270.                         }
  3272.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3273.                         if ($days > 1){
  3274.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3275.                         } else {
  3276.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3277.                         }
  3279.                         $unitsServ = $item->getUnits();
  3280.                         if (empty($unitsServ) or $unitsServ == "0") {
  3281.                             $unitsServ = 1;
  3282.                         }
  3284.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3285.                         $subnetoUnit = $subneto;
  3286.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3288.                         $data_supplier['service'][$i] = array (
  3289.                             'id' => $item->getId(),
  3290.                             'serviceCatId' => $item->getServiceCatId(),
  3291.                             'serviceName' => $item->getName(),
  3292.                             'serviceType' => 'Asistente',
  3293.                             'date' => $dateServ,
  3294.                             'qty' => $unitsServ,
  3295.                             'iva' => $item->getIva(),
  3296.                             'pax' => $item->getPax(),
  3297.                             'precioUnit' => $subnetoUnit,
  3298.                             'subneto' => $subneto,
  3299.                             'subtotal' => $subtotal,
  3300.                         );
  3301.                         break;
  3303.                     case 16: //DDR
  3304.                         $pax = $item->getPax();
  3305.                         if (empty($pax) or $pax == "0") {
  3306.                             $pax = 1;
  3307.                         }
  3309.                         $days = ((($item->getDateOutAt())->diff($item->getDateInAt()))->days + 1);
  3310.                         if ($days > 1){
  3311.                             $dateServ = ($item->getDateInAt())->format('d/m/Y'). ' - '.($item->getDateOutAt())->format('d/m/Y');
  3312.                         } else {
  3313.                             $dateServ = ($item->getDateInAt())->format('d/m/Y');
  3314.                         }
  3316.                         $unitsServ = $item->getUnits();
  3317.                         if (empty($unitsServ) or $unitsServ == "0") {
  3318.                             $unitsServ = 1;
  3319.                         }
  3321.                         $subtotal = $subtotalService * $days * $unitsServ * $pax;
  3322.                         $subnetoUnit = $subneto;
  3323.                         $subneto = $subneto * $days * $unitsServ * $pax;
  3325.                         $data_supplier['service'][$i] = array (
  3326.                             'id' => $item->getId(),
  3327.                             'serviceCatId' => $item->getServiceCatId(),
  3328.                             'serviceName' => $item->getName(),
  3329.                             'serviceType' => 'DDR',
  3330.                             'date' => $dateServ,
  3331.                             'qty' => $unitsServ,
  3332.                             'iva' => $item->getIva(),
  3333.                             'pax' => $item->getPax(),
  3334.                             'precioUnit' => $subnetoUnit,
  3335.                             'subneto' => $subneto,
  3336.                             'subtotal' => $subtotal,
  3337.                         );
  3338.                         break;
  3340.                     default:
  3341.                         break;
  3342.                 }
  3344.                 // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP),
  3345.                 $subtotal = round($subtotal,2,PHP_ROUND_HALF_UP);
  3346.                 $neto = round($subneto,2,PHP_ROUND_HALF_UP);
  3348.                 $arrayItems[] = array(
  3349.                     'type' => 'Service',
  3350.                     'name' => $item->getName(),
  3351.                     'amount' => $neto,
  3352.                     'iva' => $item->getIva(),
  3353.                     'total' => $subtotal,
  3354.                 );
  3356.             }
  3358.             switch ($item->getIva()){
  3359.                 // Acumula IVA
  3360.                 case 21:
  3361.                     $data_iva['ivaMontoVeintiUno'] = $data_iva['ivaMontoVeintiUno'] + ($neto * ($item->getIva()/100));
  3362.                     break;
  3364.                 case 10:
  3365.                     $data_iva['ivaMontoDiez'] = $data_iva['ivaMontoDiez'] + ($neto * ($item->getIva()/100));
  3366.                     break;
  3368.                 case 0:
  3369.                     break;
  3371.                 default:
  3372.                     break;
  3374.             }
  3376.             $totales_neto_all = $totales_neto_all + $neto;
  3378.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  3379.             $totales_neto_all = round($totales_neto_all,2,PHP_ROUND_HALF_UP);
  3380.             $data_iva['ivaMontoVeintiUno'] = round($data_iva['ivaMontoVeintiUno'],2,PHP_ROUND_HALF_UP);
  3381.             $data_iva['ivaMontoDiez'] = round($data_iva['ivaMontoDiez'],2,PHP_ROUND_HALF_UP);
  3382.             // Acumula netos totales e IVA
  3384.             $service['neto'] = $service['neto'] + $neto;
  3385.             $service['sumSubT'] = $service['sumSubT'] + $subtotal;
  3386.             // Se lleva a 2 decimales round($totales_neto_antes,2,PHP_ROUND_HALF_UP)
  3387.             $service['neto'] = round($service['neto'],2,PHP_ROUND_HALF_UP);
  3388.             $service['sumSubT'] = round($service['sumSubT'],2,PHP_ROUND_HALF_UP);
  3390.             $i++;
  3391.         }
  3393.         $data_supplier['serviceSubTotal'] = array(
  3394.             'neto' => $service['neto'],
  3395.             'sumSubT' => $service['sumSubT'],
  3396.         );
  3397.         $currency = '€';
  3398.         $totales_total = $totales_neto_all + $data_iva['ivaMontoVeintiUno'] + $data_iva['ivaMontoDiez'];
  3399.         if (!empty($payments)) {
  3400.             $amount_pay = $data_supplier['paymentSubTotal']['sumSubT'];
  3401.         } else {
  3402.             $amount_pay = 0;
  3403.         }
  3404.         $totales_all = $totales_total - $amount_pay;
  3406.         if ($type == 'Invoice'){
  3407.             $em->clear();   // sin este clear se producia error al guardar
  3408.             $newInvoice = $em->getRepository(MdvDocInvoice::class)->findOneById($numberInvoiceOrProforma);
  3409.             $newInvoice->setBalance($totales_all);
  3410.             $em->persist($newInvoice);
  3411.             $em->flush();
  3412.         }
  3414.         $data = array(
  3415.             'id' => $id,
  3416.             'type' => $type,
  3417.             'number' => $number,
  3418.             'prefix' => 'MDV-'.(new DateTime('now'))->format('dmy').'-',
  3419.             'date' => new DateTime('now'),
  3420.             'file' => $file,
  3421. //            'token' => $reservation->getAccessKey(),
  3422.             'company' => $company,
  3423.             'clients' => $client,
  3424.             'arrayItems' => $arrayItems,
  3425.             'datasupplier' => $data_supplier,
  3426.             'currency' => $currency,
  3427.             'totales_neto' => $totales_neto_all,
  3428.             'bases_imponibles' => $data_iva,
  3429.             'totales' => $totales_total,
  3430.             'balance' => $totales_all,
  3431.             'paymentInvoice' => $amount_pay,
  3432.         );
  3434.         return $data;
  3435.     }
  3437.     private function sendTelegram ( $id, $text )
  3438.     {
  3439.         $em = $this->getDoctrine()->getManager();
  3440.         $telegUser = $em->getRepository(MdvTelegramUser::class)->findOneByUserId($id);
  3442.         if (empty($telegUser)){return true;}
  3444.         $parameters = array(
  3445.             'chat_id' => $telegUser->getChatId(),
  3446.             'text' => $text,
  3447.         );
  3449.         $bot_token = $telegUser->getBotToken();
  3450.         $url = "https://api.telegram.org/bot$bot_token/sendMessage";
  3452.         if (!$curl = curl_init()){
  3453.             exit();
  3454.         }
  3456.         curl_setopt($curl,CURLOPT_POST,true);
  3457.         curl_setopt($curl,CURLOPT_POSTFIELDS,$parameters);
  3458.         curl_setopt($curl,CURLOPT_URL,$url);
  3459.         curl_setopt($curl,CURLOPT_RETURNTRANSFER,true);
  3460.         $output = curl_exec($curl);
  3461.         curl_close($curl);
  3463.         return true;
  3464.     }
  3465. };