src/Controller/higotrigo/HtInvoiceController.php line 728

Open in your IDE?
  1. <?php
  3. namespace App\Controller\higotrigo;
  5. use App\Entity\Client;
  6. use App\Entity\HtProforma;
  7. use App\Entity\HtProformaItems;
  8. use App\Entity\Supplier;
  9. use App\Entity\Country;
  10. use App\Entity\HtExtra;
  11. use App\Entity\HtFile;
  12. use App\Entity\HtInvoice;
  13. use App\Entity\HtInvoiceItems;
  14. use App\Entity\HtItem;
  15. use App\Entity\HtMenu;
  16. use App\Repository\HtItemRepository;
  17. use App\Repository\HtMenuRepository;
  18. use App\Service\CommissionEnterprisesService;
  19. use App\Service\HtService;
  20. use App\Form\HtInvoiceType;
  21. use App\Repository\HtInvoiceRepository;
  22. use App\MDS\GreenPatioBundle\Entity\Reservation;
  23. use Google\Service\Dfareporting\Resource\Countries;
  24. use Google\Service\MigrationCenterAPI\DateTime;
  25. use Monolog\DateTimeImmutable;
  26. use PhpParser\Node\Stmt\Foreach_;
  27. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  28. use Symfony\Component\HttpFoundation\Request;
  29. use Symfony\Component\HttpFoundation\Response;
  30. use Symfony\Component\Routing\Annotation\Route;
  31. use App\Entity\SettingsCompany;
  32. use App\Helper\StatusHelper;
  33. use Doctrine\ORM\EntityManagerInterface;
  34. use Symfony\Component\HttpFoundation\JsonResponse;
  36. /**
  37.  * @Route("/higotrigo/ht/invoice")
  38.  */
  39. class HtInvoiceController extends AbstractController
  40. {
  41.     private $commisionEnterpriseService;
  43.     public function __construct(CommissionEnterprisesService $commisionEnterpriseService)
  44.     {
  45.         $this->commisionEnterpriseService = $commisionEnterpriseService;
  46.     }
  48.     /**
  49.      * @Route("/", name="app_ht_invoice_index", methods={"GET"})
  50.      */
  51.     public function index(HtInvoiceRepository $htInvoiceRepository): Response
  52.     {
  53.         $htInvoices = $htInvoiceRepository->findAll();
  55.         foreach ($htInvoices as $invoice) {
  56.             // Formatear el campo vatTotalGroup
  57.             $invoice->setVatTotalGroup($this->formatVatTotalGroup($invoice->getVatTotalGroup()));
  58.         }
  60.         return $this->render('higotrigo/ht_invoice/index.html.twig', [
  61.             'ht_invoices' => $htInvoices,
  62.         ]);
  63.     }
  66.     /**
  67.      * @Route("/new", name="app_ht_invoice_new", methods={"GET", "POST"})
  68.      */
  69.     public function new(Request $request, HtInvoiceRepository $htInvoiceRepository): Response
  70.     {
  71.         $htInvoice = new HtInvoice();
  72.         $form = $this->createForm(HtInvoiceType::class, $htInvoice);
  73.         $form->handleRequest($request);
  75.         if ($form->isSubmitted() && $form->isValid()) {
  76.             $htInvoiceRepository->add($htInvoice, true);
  78.             return $this->redirectToRoute('app_ht_invoice_index', [], Response::HTTP_SEE_OTHER);
  79.         }
  81.         return $this->renderForm('higotrigo/ht_invoice/new.html.twig', [
  82.             'ht_invoice' => $htInvoice,
  83.             'form' => $form,
  84.         ]);
  85.     }
  88.     /**
  89.      * @Route("/{id}", name="app_ht_invoice_show", methods={"GET"})
  90.      */
  91.     public function show(HtInvoice $htInvoice): Response
  92.     {
  93.         $em = $this->getDoctrine()->getManager();
  94.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  95.         $currency = '€';
  96.         $boolToRec = false;
  99.         return $this->render('higotrigo/ht_invoice/show.html.twig', [
  100.             'ht_invoice' => $htInvoice,
  101.             'company' => $company,
  102.             'currency' => $currency,
  103.             'boolToRec' => $boolToRec,
  104.         ]);
  105.     }
  108.     /**
  109.      * @Route("/{id}/edit", name="app_ht_invoice_edit", methods={"GET", "POST"})
  110.      */
  111.     public function edit(Request $request, HtInvoice $htInvoice, HtInvoiceRepository $htInvoiceRepository): Response
  112.     {
  113.         $form = $this->createForm(HtInvoiceType::class, $htInvoice);
  114.         $form->handleRequest($request);
  116.         if ($form->isSubmitted() && $form->isValid()) {
  117.             $htInvoiceRepository->add($htInvoice, true);
  119.             return $this->redirectToRoute('app_ht_invoice_index', [], Response::HTTP_SEE_OTHER);
  120.         }
  122.         return $this->renderForm('higotrigo/ht_invoice/edit.html.twig', [
  123.             'ht_invoice' => $htInvoice,
  124.             'form' => $form,
  125.         ]);
  126.     }
  129.     /**
  130.      * @Route("/{id}", name="app_ht_invoice_delete", methods={"POST"})
  131.      */
  132.     public function delete(Request $request, HtInvoice $htInvoice, HtInvoiceRepository $htInvoiceRepository): Response
  133.     {
  134.         if ($this->isCsrfTokenValid('delete'.$htInvoice->getId(), $request->request->get('_token'))) {
  135.             $htInvoiceRepository->remove($htInvoice, true);
  136.         }
  138.         return $this->redirectToRoute('app_ht_invoice_index', [], Response::HTTP_SEE_OTHER);
  139.     }
  142.     /**
  143.      * @Route("/selinvoice/{id}",  name="ht_select_invoice")
  144.      * Seleccionar los elementos que pasaran a la proforma o factura
  145.      */
  146.     public function selectItemsInvoiceAction(HtFile $htFile, EntityManagerInterface $em, Request $request)
  147.     {
  148.         $beneficio = $request->query->get('bn');
  149.         // hfile => htitem => htMenu => htExtra ; htMenu => htMenuEscandallo => escandallo
  150.         $data = array();
  151.         $data['file'] = $htFile;
  152.         $allHtItems = $htFile->getHtItems();
  153.         $allHtMenus = array();
  154.         $allHtExtrasinFile = array();
  155.         $allHtEscandallos = array();
  156.         $beneficioItem = 0;
  157.         $indiceBeneficio = -1;
  159.         foreach ($allHtItems as $item) {
  160.             $indiceBeneficio ++;
  161.             $data['items'][$item->getId()]['item'] = $item;
  162.             $data['items'][$item->getId()]['item_beneficio'] = $beneficio[$indiceBeneficio];
  163.             $allHtExtras = $item->getHtExtras();
  164.             foreach ($allHtExtras as $htSinlgeExtra){
  165.                 $htExtraIsInvoiced = $em->getRepository(HtInvoiceItems::class)->findBy(array('itemType' => 'htExtra', 'itemIdOrigin' => $htSinlgeExtra->getId()));
  166.                 $boolIsInvoiced = ((count($htExtraIsInvoiced)) % 2 == 0) ? false : true;
  167.                 $data['items'][$item->getId()]['extras'][] = $htSinlgeExtra;
  168.                 if ($htSinlgeExtra->isAppearInvoice()) {
  169.                     $extra_price_no_vat = $htSinlgeExtra->isOpOverCommission() ? $htSinlgeExtra->getPrice() * (1 + $htSinlgeExtra->getOverCommission() /100) : ($htSinlgeExtra->getPrice() + $htSinlgeExtra->getOverCommission());
  170.                     $extra_price = $extra_price_no_vat * (1 + ($htSinlgeExtra->getVat()/100));
  171.                     $allHtExtrasinFile[$htSinlgeExtra->getId()] = array(
  172.                         'enabledToInvoice' => !$boolIsInvoiced,
  173.                         'extra' => $htSinlgeExtra,
  174.                         'extra_price_no_vat' => ($boolIsInvoiced) ? 0: $extra_price_no_vat,
  175.                         'extra_price' => ($boolIsInvoiced) ? 0: $extra_price,
  176.                     );
  177.                 }
  178.             }
  180.             $htMenus = $item->getHtMenus();
  181.             if (!empty($htMenus)){
  182.                 foreach ($htMenus as $htMenu) {
  183.                     $allHtMenus[] = $htMenu;
  184.                     $data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['menu_info'] = $htMenu;
  185.                     $htExtras = $htMenu->getHtExtras();
  186.                     if (!empty($htExtras)) {
  187.                         foreach ($htExtras as $elem) {
  188.                             $data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['extras'][] = $elem;
  189.                             $allHtExtras[] = $elem;
  190.                         }
  191.                     }
  192.                     $escandallo = $htMenu->getEscandallo();
  193.                     if (!empty($escandallo)) {
  194.                         $data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['escandallos_names'] = null;
  195.                         foreach ($escandallo as $escan) {
  196.                             $data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['escandallos'][] = $escan;
  197.                             $allHtEscandallos[] = $escan;
  198.                             $data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['escandallos_names'] = (empty($data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['escandallos_names'])) ? ($escan->getNombre()) : ($data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['escandallos_names'] . ', ' . $escan->getNombre());
  199.                         }
  200.                     }
  201.                 }
  202.             }
  203.         }
  205.         $data['company'] = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  206.         $data['client'] = $em->getRepository(Client::class)->findOneById($htFile->getClient());
  207.         $data_iva = array();
  208.         $data_iva['ivaMontoVeintiUno'] = 0;
  209.         $data_iva['ivaMontoDiez'] = 0;
  210.         $data_iva['ivaMontoCero'] = 0;
  211.         $netoSum = 0; $totalSum = 0;
  212.         $indiceBeneficio = -1;
  213.         if (array_key_exists("items", $data)) {
  214.             foreach ($data['items'] as $itemFac) {
  215.                 if (array_key_exists("menus", $itemFac)) {
  216.                     $indiceBeneficio++;
  217.                     foreach ($itemFac['menus'] as $htMenu) {
  218.                         $productName = $htMenu['menu']['menu_info']->getName() . ' ( ' . $htMenu['menu']['escandallos_names'] . ' )';
  219.                         $servicePrice = (($htMenu['menu']['menu_info']->getTotalPrice() * 100) / (100 + $htMenu['menu']['menu_info']->getIva()));
  220.                         $subTotalPrice = round((($htMenu['menu']['menu_info']->getTotalPrice() * 100) / (100 + $htMenu['menu']['menu_info']->getIva())), 2) * $itemFac['item']->getPax();
  221.                         $subtotalProduct = $subTotalPrice * (1 + ($htMenu['menu']['menu_info']->getIva() / 100));
  222.                         $ivaAmount = ($htMenu['menu']['menu_info']->getIva() * $subTotalPrice) / 100;
  224.                         $htMenuIsInvoiced = $em->getRepository(HtInvoiceItems::class)->findBy(array('itemType' => 'htMenu', 'itemIdOrigin' => $htMenu['menu']['menu_info']->getId()));
  225.                         $boolIsInvoiced = ((count($htMenuIsInvoiced)) % 2 == 0) ? false : true;
  227.                         if (!$boolIsInvoiced) {
  228.                             $netoSum += $subTotalPrice;
  229.                             $totalSum += $subtotalProduct;
  231.                             switch ($htMenu['menu']['menu_info']->getIva()) {
  232.                                 case 10: $data_iva['ivaMontoDiez'] += $ivaAmount; break;
  233.                                 case 21: $data_iva['ivaMontoVeintiUno'] += $ivaAmount; break;
  234.                                 default: break;
  235.                             }
  236.                         }
  238.                         $data['product'][] = array(
  239.                             'id' => $htMenu['menu']['menu_info']->getId(),     // Id del Menu
  240.                             'idHtItem' => $itemFac['item']->getId(),            // Id del Servicio (HtItem) que contiene el Menu
  241.                             'enabledToInvoice' => !$boolIsInvoiced,
  242.                             'productName' => $productName,
  243.                             'type' => null,
  244.                             'servicePrice' => $servicePrice,
  245.                             'qty' => $itemFac['item']->getPax(),
  246.                             'days' => $itemFac['item']->getDateStart()->format('d/m/Y'),
  247.                             'subTotalPrice' => ($boolIsInvoiced) ? 0 : $subTotalPrice,
  248.                             'iva' => $htMenu['menu']['menu_info']->getIva(),
  249.                             'ivaAmount' => $ivaAmount,
  250.                             'subtotalProduct' => ($boolIsInvoiced) ? 0 : $subtotalProduct,
  251.                             'beneficio' => $beneficio[$indiceBeneficio],
  252.                             'productSubTotal' => array(
  253.                                 'neto' => null,
  254.                                 'sumSubT' => null,
  255.                             ),
  256.                         );
  257.                     }
  258.                 }
  259.             }
  260.         }
  262.         $netoAllSum = $netoSum;
  263.         $totalSumItems = $totalSum;
  265.         //  SERVICIOS ADICIONALES
  266.         $data_extras = array();
  267.         if (!empty($allHtExtrasinFile)){ $data_extras['allHtExtrasinFile'] = $allHtExtrasinFile; }
  268.         $data_extras_sum = array('extra_price_no_vat' => 0, 'extra_price' => 0,);
  270.         foreach ($allHtExtrasinFile as $item){
  271.             $data_extras_sum['extra_price_no_vat'] += $item['extra_price_no_vat'];
  272.             $data_extras_sum['extra_price'] += $item['extra_price'];
  273.             $montoIva = $item['extra_price'] - $item['extra_price_no_vat'];
  274.             switch ($item['extra']->getVat()) {
  275.                 case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  276.                 case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  277.                 default: break;
  278.             }
  279.             $netoAllSum += $item['extra_price_no_vat'];
  280.             $totalSum += $item['extra_price'];
  281.         }
  283.         $clientType = 'client';
  284.         $clientAddress = (array_key_exists("client", $data) and !empty($data['client'])) ? $data['client']->getAddress() : 'No se ha podido determinar la dirección';
  285.         $country = (array_key_exists("client", $data) and !empty($data['client'])) ? $em->getRepository(Country::class)->findOneById($data['client']->getCountry()) : $em->getRepository(Country::class)->findOneById(62);
  286.         $country = $country->getCountry();
  287.         if ($country == 'Spain'){ $country = 'España'; }
  288.         $clientAddress = $clientAddress . ', '. $country;
  289.         $clientDocument = $data['client']->getIdDocument();
  291.         return $this->render('higotrigo/ht_invoice/invoice-select-items.html.twig',
  292.             array(
  293.                 'id' => $htFile->getId(),
  294.                 'htFile' => $htFile,
  295.                 'prefix' => null,
  296.                 'date' => null,
  297.                 'company' => $data['company'],
  298.                 'clientAddress' => $clientAddress,
  299.                 'clientType' => $clientType,
  300.                 'clientDocument' => $clientDocument,
  301.                 'client' => $data['client'],
  302.                 'clients' => null,
  303.                 'datasupplier' => $data,
  304.                 'data_extras' => $data_extras,
  305.                 'data_extras_sum' => $data_extras_sum,
  306.                 'currency' => '€',
  307.                 'totales_coniva_items' => $totalSumItems,
  308.                 'totales_coniva' => $totalSum,
  309.                 'totales_neto_items' => $netoSum,
  310.                 'totales_neto' => $netoAllSum,
  311.                 'bases_imponibles' => $data_iva,
  312.             )
  313.         );
  314.     }
  317.     /**
  318.      * @Route("/selinvoicesp/{id}",  name="ht_select_invoice_special")
  319.      * Vista previa para selecionar a quien se le va a facturar (proveedor - factura de comisión)
  320.      */
  321.     public function generateSpecialInvoiceAction($id, EntityManagerInterface $em, Request $request)
  322.     {
  323.         //Buscamos los proveedores
  324.         $suppliers = $em->getRepository(Supplier::class)->findAll();
  325.         $arrayClients = array();
  327.         foreach ($suppliers as $item){
  328.             $arrayClients[] = array(
  329.                 'nombre' => $item->getCompany(),
  330.                 'id' => $item->getId(),
  331.                 'tipo' => 'PROVEEDOR',
  332.                 'indice' => 'S'.$item->getId(),
  333.             );
  334.         }
  336.         return $this->render('higotrigo/ht_invoice/invoice-select-client-supplier.html.twig',
  337.             array(
  338.                 'id' => $id,
  339.                 'clients' => $arrayClients,
  340.             )
  341.         );
  342.     }
  345.     /**
  346.      * @Route("/selinvoicecom/{id}",  name="ht_select_commision_invoice")
  347.      * Seleccionar los elementos que pasaran a la factura de comision
  348.      */
  349.     public function selectItemsCommisionInvoiceAction($id, HtFile $htFile, HtService $htService, EntityManagerInterface $em, Request $request)
  350.     {
  351.         $supId = $request->request->get('reservation');
  352.         $supId = $supId['client'];
  353.         $supId = substr($supId,1);
  354.         $supplier = $em->getRepository(Supplier::class)->findOneById($supId);
  356.         // El beneficio será del 100% por ser factura de comisión
  357.         $beneficio = $request->query->get('bn');
  358.         // hfile => htitem => htMenu => htExtra ; htMenu => htMenuEscandallo => escandallo
  359.         $data = array();
  360.         $data['file'] = $em->getRepository(HtFile::class)->findOneById($id);
  361.         $htFile = $data['file'];
  362.         $allHtItems = $htFile->getHtItems();
  363.         $allHtMenus = array(); $allHtExtrasinFile = array(); $allHtEscandallos = array();
  364.         $beneficioItem = 0;
  365.         $indiceBeneficio = -1;
  367.         $dataBen = $htService->CalcTotals($htFile);
  369.         foreach ($allHtItems as $item) {
  370.             $indiceBeneficio ++;
  371.             $data['items'][$item->getId()]['item'] = $item;
  372.             $data['items'][$item->getId()]['item_beneficio'] = $dataBen['htItem'][$item->getId()]['precioNeto'] - $dataBen['htItem'][$item->getId()]['coste'];
  373.             $allHtExtras = $item->getHtExtras();
  375.             foreach ($allHtExtras as $htSinlgeExtra){
  376.                 $htExtraIsInvoiced = $em->getRepository(HtInvoiceItems::class)->findBy(array('itemType' => 'htExtra', 'itemIdOrigin' => $htSinlgeExtra->getId()));
  377.                 $boolIsInvoiced = ((count($htExtraIsInvoiced)) % 2 == 0) ? false : true;
  378.                 $data['items'][$item->getId()]['extras'][] = $htSinlgeExtra;
  379.                 if ($htSinlgeExtra->isAppearInvoice()) {
  380.                     $extra_price_no_vat = $htSinlgeExtra->isOpOverCommission() ? $htSinlgeExtra->getPrice() * (1 + $htSinlgeExtra->getOverCommission() /100) : ($htSinlgeExtra->getPrice() + $htSinlgeExtra->getOverCommission());
  381.                     $extra_price = $extra_price_no_vat * (1 + ($htSinlgeExtra->getVat()/100));
  382.                     $allHtExtrasinFile[] = array(
  383.                         'enabledToInvoice' => !$boolIsInvoiced,
  384.                         'extra' => $htSinlgeExtra,
  385.                         'extra_price_no_vat' => ($boolIsInvoiced) ? 0: $extra_price_no_vat,
  386.                         'extra_price' => ($boolIsInvoiced) ? 0: $extra_price,
  387.                     );
  388.                 }
  389.             }
  391.             $htMenus = $item->getHtMenus();
  392.             if (!empty($htMenus)){
  393.                 foreach ($htMenus as $htMenu) {
  394.                     $allHtMenus[] = $htMenu;
  395.                     $data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['menu_info'] = $htMenu;
  396.                     $htExtras = $htMenu->getHtExtras();
  397.                     if (!empty($htExtras)) {
  398.                         foreach ($htExtras as $elem) {
  399.                             $data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['extras'][] = $elem;
  400.                             $allHtExtras[] = $elem;
  401.                         }
  402.                     }
  403.                     $escandallo = $htMenu->getEscandallo();
  404.                     if (!empty($escandallo)) {
  405.                         $data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['escandallos_names'] = null;
  406.                         foreach ($escandallo as $escan) {
  407.                             $data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['escandallos'][] = $escan;
  408.                             $allHtEscandallos[] = $escan;
  409.                             $data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['escandallos_names'] = (empty($data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['escandallos_names'])) ? ($escan->getNombre()) : ($data['items'][$item->getId()]['menus'][$htMenu->getId()]['menu']['escandallos_names'] . ', ' . $escan->getNombre());
  410.                         }
  411.                     }
  412.                 }
  413.             }
  414.         }
  416.         $data['company'] = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  417.         $data['client'] = $supplier;
  418.         $data_iva = array();
  419.         $data_iva['ivaMontoVeintiUno'] = 0;
  420.         $data_iva['ivaMontoDiez'] = 0;
  421.         $data_iva['ivaMontoCero'] = 0;
  422.         $netoSum = 0; $totalSum = 0;
  423.         $indiceBeneficio = -1;
  424.         if (array_key_exists("items", $data)) {
  425.             foreach ($data['items'] as $itemFac) {
  426.                 if (array_key_exists("menus", $itemFac)) {
  427.                     $indiceBeneficio++;
  428.                     foreach ($itemFac['menus'] as $htMenu) {
  429.                         $productName = $htMenu['menu']['menu_info']->getName() . ' ( ' . $htMenu['menu']['escandallos_names'] . ' )';
  430.                         $servicePrice = (($htMenu['menu']['menu_info']->getTotalPrice() * 100) / (100 + $htMenu['menu']['menu_info']->getIva()));
  431.                         $subTotalPrice = round((($htMenu['menu']['menu_info']->getTotalPrice() * 100) / (100 + $htMenu['menu']['menu_info']->getIva())), 2) * $itemFac['item']->getPax();
  432.                         $subtotalProduct = $subTotalPrice * (1 + ($htMenu['menu']['menu_info']->getIva() / 100));
  433.                         $ivaAmount = ($htMenu['menu']['menu_info']->getIva() * $subTotalPrice) / 100;
  435.                         $htMenuIsInvoiced = $em->getRepository(HtInvoiceItems::class)->findBy(array('itemType' => 'htMenu', 'itemIdOrigin' => $htMenu['menu']['menu_info']->getId()));
  436.                         $boolIsInvoiced = ((count($htMenuIsInvoiced)) % 2 == 0) ? false : true;
  438.                         if (!$boolIsInvoiced) {
  439.                             $netoSum += $subTotalPrice;
  440.                             $totalSum += $subtotalProduct;
  442.                             switch ($htMenu['menu']['menu_info']->getIva()) {
  443.                                 case 10: $data_iva['ivaMontoDiez'] += $ivaAmount; break;
  444.                                 case 21: $data_iva['ivaMontoVeintiUno'] += $ivaAmount; break;
  445.                                 default: break;
  446.                             }
  447.                         }
  449.                         $data['product'][] = array(
  450.                             'id' => $htMenu['menu']['menu_info']->getId(),     // Id del Menu
  451.                             'idHtItem' => $itemFac['item']->getId(),            // Id del Servicio (HtItem) que contiene el Menu
  452.                             'enabledToInvoice' => !$boolIsInvoiced,
  453.                             'productName' => $productName,
  454.                             'type' => null,
  455.                             'servicePrice' => $servicePrice,
  456.                             'qty' => $itemFac['item']->getPax(),
  457.                             'days' => $itemFac['item']->getDateStart()->format('d/m/Y'),
  458.                             'subTotalPrice' => ($boolIsInvoiced) ? 0 : $subTotalPrice,
  459.                             'iva' => $htMenu['menu']['menu_info']->getIva(),
  460.                             'ivaAmount' => $ivaAmount,
  461.                             'subtotalProduct' => ($boolIsInvoiced) ? 0 : $subtotalProduct,
  462. //                        'beneficio' => $beneficio[$indiceBeneficio],
  463.                             'beneficio' => $dataBen['htItem'][$itemFac['item']->getId()]['precioNeto'] - $dataBen['htItem'][$itemFac['item']->getId()]['coste'],                      // Se lleva al 100% antes de impuestos ya que es factura de comision
  464.                         );
  465.                     }
  466.                 }
  467.             }
  468.         }
  470.         $netoAllSum = $netoSum;
  471.         $totalSumItems = $totalSum;
  473.         //  SERVICIOS ADICIONALES
  474.         $data_extras = array();
  475.         if (!empty($allHtExtrasinFile)){ $data_extras['allHtExtrasinFile'] = $allHtExtrasinFile; }
  476.         $data_extras_sum = array('extra_price_no_vat' => 0, 'extra_price' => 0,);
  478.         foreach ($allHtExtrasinFile as $item){
  479.             $data_extras_sum['extra_price_no_vat'] += $item['extra_price_no_vat'];
  480.             $data_extras_sum['extra_price'] += $item['extra_price'];
  481.             $montoIva = $item['extra_price'] - $item['extra_price_no_vat'];
  482.             switch ($item['extra']->getVat()) {
  483.                 case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  484.                 case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  485.                 default: break;
  486.             }
  487.             $netoAllSum += $item['extra_price_no_vat'];
  488.             $totalSum += $item['extra_price'];
  489.         }
  491.         $clientType = 'supplier';
  492.         $clientAddress = (array_key_exists("client", $data) and !empty($data['client'])) ? $data['client']->getAddress() : 'No se ha podido determinar la dirección';
  493.         $country = (array_key_exists("client", $data) and !empty($data['client'])) ? $em->getRepository(Country::class)->findOneById($data['client']->getCountry()) : $em->getRepository(Country::class)->findOneById(62);
  494.         $country = $country->getCountry();
  495.         if ($country == 'Spain'){ $country = 'España'; }
  496.         $clientAddress = $clientAddress . ', '. $country;
  497.         $clientDocument = $data['client']->getIdDocument();
  499.         return $this->render('higotrigo/ht_invoice/invoice-select-items.html.twig',
  500.             array(
  501.                 'id' => $htFile->getId(),
  502.                 'htFile' => $htFile,
  503.                 'prefix' => null,
  504.                 'date' => null,
  505.                 'company' => $data['company'],
  506.                 'clientAddress' => $clientAddress,
  507.                 'clientDocument' => $clientDocument,
  508.                 'clientType' => $clientType,
  509.                 'client' => $data['client'],
  510.                 'clients' => null,
  511.                 'datasupplier' => $data,
  512.                 'data_extras' => $data_extras,
  513.                 'data_extras_sum' => $data_extras_sum,
  514.                 'currency' => '€',
  515.                 'totales_coniva_items' => $totalSumItems,
  516.                 'totales_coniva' => $totalSum,
  517.                 'totales_neto_items' => $netoSum,
  518.                 'totales_neto' => $netoAllSum,
  519.                 'bases_imponibles' => $data_iva,
  520.             )
  521.         );
  522.     }
  525.     /**
  526.      * @Route("/createinvoice/{id}",  name="ht_create_invoice")
  527.      * Generar factura en el expediente ID
  528.      */
  529.     public function createInvoiceHtAction($id, EntityManagerInterface $em, HtItemRepository $htItemRepository, HtMenuRepository $htMenuRepository, Request $request)
  530.     {
  531.         $req = $request->request->get('invoiced_item');
  532.         $req_extra = $request->request->get('invoiced_extra');
  533.         $htFile = $em->getRepository(HtFile::class)->findOneById($id);
  534.         $beneficio_total = 0;
  535.         $xItem = null;  //Item donde se agregara el extra por comision de GP
  537.         // El break es necesario ya que el beneficio fue concebido para ser por servicios, luego con el cambio de multi menus en un servicio se debe sumar solamente una vez
  538.         foreach ($req as $itemServ){
  539.             foreach ($itemServ as $item) {
  540.                 if ($item['boolToInvoice'] == 'true') { $beneficio_total += $item['benefit']; break; }
  541.             }
  542.         }
  544.         $boolSeleccionados = false;
  546.         // Si no hay elemento seleccionados se vuelve a la pantalla de seleccion
  547.         if ($boolSeleccionados){ return $this->redirectToRoute('ht_select_invoice', ['id' => $htFile->getId()], Response::HTTP_SEE_OTHER); }
  549.         // Se genera la factura
  550.         // buscamos por el prefijo de cada linea de facturacion para saber el ultimo ID
  551.         $invoiceLineGp = $em->getRepository(HtInvoice::class)->findByPrefix('GP');
  552.         $invoiceLineCvr = $em->getRepository(HtInvoice::class)->findByPrefix('CV');
  553.         $invoiceLineOther = $em->getRepository(HtInvoice::class)->findByPrefix('F');
  554.         $lastGp = end($invoiceLineGp);
  555.         $lastCvr = end($invoiceLineCvr);
  556.         $lastOther = end($invoiceLineOther);
  558.         // Buscamos los HtIemts del HtFile para saber la sala del servicio para determinar la línea de facturación ($prefix)
  559.         $htItems = $em->getRepository(HtItem::class)->findByHtFile($htFile);
  560.         $lounge = $htItems[0]->getLoungeGp();
  561.         $prefix = (empty($lounge) ? 'F' : (($lounge->getId() < 22) ? 'GP' : 'CV'));
  563.         switch ($prefix) {
  564.             case 'F': $idNum = (empty($lastOther)) ? 1 : $lastOther->getIdNum() + 1; break;
  565.             case 'CV': $idNum = (empty($lastCvr)) ? 1 : $lastCvr->getIdNum() + 1; break;
  566.             default:
  567.                 // Por defecto Green Patio.
  568.                 // Esteban Rincon comenta que en caso de un expediente tener salas de GP y CVR deberiamos tener un expediente por linea de facturación
  569.                 $idNum = (empty($lastGp)) ? 1 : $lastGp->getIdNum() + 1;
  570.                 break;
  571.         }
  573.         $client = (empty($htFile->getClient())) ? null : $htFile->getClient();
  574.         // Si no hay cliente no se puede facturar, se vuelve a la pantalla de seleccion
  575.         if (empty($client)){ return $this->redirectToRoute('ht_select_invoice', ['id' => $htFile->getId()], Response::HTTP_SEE_OTHER); }
  577.         $dateAt = new DateTimeImmutable('now');
  578.         $type = 'Invoice';
  579.         $totalNet = 0; $vatTotalGroup = 0; $total = 0;
  580.         $clientName = $client->getName();
  581.         $clientAddress = $request->request->get('clientAddress');
  582.         $clientDocument = empty($client->getIdDocument()) ? ' ' : $client->getIdDocument();
  583.         $clientType = $request->request->get('clientType');
  584.         if ($clientType == 'supplier'){
  585.             $type = 'commission invoice';
  586.             $clientName = $request->request->get('clientName');
  587.             $clientDocument = $request->request->get('clientDocument');
  588.         }
  590.         $invoice = new HtInvoice();
  591.         $invoice->setIdNum($idNum);
  592.         $invoice->setPrefix($prefix);
  593.         $invoice->setDateAt($dateAt);
  594.         $invoice->setType($type);
  595.         $invoice->setTotalNet($totalNet);
  596.         $invoice->setVatTotalGroup($vatTotalGroup);
  597.         $invoice->setTotal($total);
  598.         $invoice->setClientName($clientName);
  599.         $invoice->setClientAddress($clientAddress);
  600.         $invoice->setClientDocument($clientDocument);
  601.         $invoice->setClientType($clientType);
  602.         $invoice->setHtFile($htFile);
  603.         $invoice->setBenefit($beneficio_total);
  605.         $em->persist($invoice);
  606.         $em->flush();
  608.         $data_iva = array(); $data_iva['ivaMontoVeintiUno'] = 0; $data_iva['ivaMontoDiez'] = 0;
  610.         // Se crean los Menus en los HtInvoiceItems
  611.         foreach ($req as $itemServ){
  612.             foreach ($itemServ as $item) {
  613.                 if ($item['boolToInvoice'] == 'true') {
  614.                     $htMenu = $em->getRepository(HtMenu::class)->findOneByHtItem($item['idHtService']);
  615.                     $itemType = 'htMenu';
  616.                     $itemIdOrigin = $htMenu->getId();
  617.                     $itemName = $item['name'];
  618.                     $htItem = $em->getRepository(HtItem::class)->findOneById($htMenu->getHtItem());
  619.                     if (empty($xItem)){ $xItem = $htItem; }
  620.                     $dateStart = ($htItem->getDateStart())->format('Y-m-d');
  621.                     $hourEnd = ($htItem->getHourEnd())->format('Y-m-d');
  622.                     $dateTimeString = $dateStart . ' ' . $hourEnd;
  623.                     $dateEnd = new DateTimeImmutable($dateTimeString);
  624.                     $iva = $htMenu->getIva();
  625.                     switch ($iva) {
  626.                         case 10: $data_iva['ivaMontoDiez'] += ($item['subTotalPrice'] * 0.1); break;
  627.                         case 21: $data_iva['ivaMontoVeintiUno'] += ($item['subTotalPrice'] * 0.21); break;
  628.                         default: break;
  629.                     }
  630.                     $itemCommission = 0;                                                                // Solo htExtra maneja el concepto de over o comision.
  631.                     $itemOver = 0;                                                                      // Solo htExtra maneja el concepto de over o comision.
  632.                     $costeDirecto = $item['subTotalPrice'] - $item['benefit'];
  633.                     $totalNet += round($item['subTotalPrice'], 2);
  634.                     $total += round($item['subTotalPrice'], 2) + (round($item['subTotalPrice'], 2) * ($iva / 100));
  635.                     $xPax = empty($item['qty']) ? 1 : $item['qty'];
  637.                     $htInvItem = new HtInvoiceItems();
  638.                     $htInvItem->setInvoice($invoice);
  639.                     $htInvItem->setHtFile($htFile);
  640.                     $htInvItem->setItemType($itemType);
  641.                     $htInvItem->setItemIdOrigin($itemIdOrigin);
  642.                     $htInvItem->setItemName($itemName);
  643.                     $htInvItem->setItemDateStart($htItem->getDateStart());
  644.                     $htInvItem->setItemDateEnd($dateEnd);
  645.                     $htInvItem->setItemPrice(round($item['servicePrice'], 2));
  646.                     $htInvItem->setItemUnits(1);
  647.                     $htInvItem->setItemPax($xPax);
  648.                     $htInvItem->setItemKgLt(1);
  649.                     $htInvItem->setItemRank(1);
  650.                     $htInvItem->setItemLocation(0);
  651.                     $htInvItem->setItemIva($iva);
  652.                     $htInvItem->setItemOpIva(0);            // +
  653.                     $htInvItem->setItemCommission($itemCommission);
  654.                     $htInvItem->setItemOpCommission(0);
  655.                     $htInvItem->setItemOver($itemOver);
  656.                     $htInvItem->setItemOpOver(0);
  657.                     $htInvItem->setItemSubTotalPrice(round($item['subTotalPrice'], 2));
  658.                     $htInvItem->setItemCosteDirecto(round($costeDirecto, 2));
  659.                     $htInvItem->setItemBeneficio(round($item['benefit'], 2));
  661.                     $em->persist($htInvItem);
  662.                     $em->flush();
  663.                 }
  664.             }
  665.         }
  667.         // Se crean los Extras en los HtInvoiceItems
  668.         if (!empty($req_extra)) {
  669.             foreach ($req_extra as $item) {
  670.                 if($item['boolToInvoice'] == 'true') {
  671.                     $htExtra = $em->getRepository(HtExtra::class)->findOneById($item['idHtExtra']);
  672.                     if ($htExtra->isAppearInvoice()) {
  673.                         $itemType = 'htExtra';
  674.                         $itemIdOrigin = $htExtra->getId();
  675.                         $itemName = $htExtra->getConcept();
  676.                         $htItem = $em->getRepository(HtItem::class)->findOneById($htExtra->getHtItem());
  677.                         $dateStart = ($htItem->getDateStart())->format('Y-m-d');
  678.                         $hourEnd = ($htItem->getHourEnd())->format('Y-m-d');
  679.                         $dateTimeString = $dateStart . ' ' . $hourEnd;
  680.                         $dateEnd = new DateTimeImmutable($dateTimeString);
  681.                         $iva = $htExtra->getVat();
  682.                         $itemCommission = (($htExtra->isOpOverCommission() == 0) ? 0 : $htExtra->getOverCommission());
  683.                         $itemOver = (($htExtra->isOpOverCommission() == 1)  ? 0 : $htExtra->getOverCommission());
  684.                         $costeDirecto = 0;
  685.                         $benefit = $itemOver + ($item['price'] * ($itemCommission / 100));
  686.                         $totalPrice = $item['price'] + $benefit;
  687.                         switch ($iva) {
  688.                             case 10: $data_iva['ivaMontoDiez'] += ($totalPrice * 0.1); break;
  689.                             case 21: $data_iva['ivaMontoVeintiUno'] += ($totalPrice * 0.21); break;
  690.                             default: break;
  691.                         }
  692.                         $totalNet += round($totalPrice, 2);
  693.                         $total += round($totalPrice, 2) + (round($totalPrice, 2) * ($iva / 100));
  695.                         $htInvItem = new HtInvoiceItems();
  696.                         $htInvItem->setInvoice($invoice);
  697.                         $htInvItem->setHtFile($htFile);
  698.                         $htInvItem->setItemType($itemType);
  699.                         $htInvItem->setItemIdOrigin($itemIdOrigin);
  700.                         $htInvItem->setItemName($itemName);
  701.                         $htInvItem->setItemDateStart($htItem->getDateStart());
  702.                         $htInvItem->setItemDateEnd($dateEnd);
  703.                         $htInvItem->setItemPrice(round($item['price'], 2));
  704.                         $htInvItem->setItemUnits(1);
  705.                         $htInvItem->setItemPax(1);
  706.                         $htInvItem->setItemKgLt(1);
  707.                         $htInvItem->setItemRank(1);
  708.                         $htInvItem->setItemLocation(0);
  709.                         $htInvItem->setItemIva($iva);
  710.                         $htInvItem->setItemOpIva(0);            // +
  711.                         $htInvItem->setItemCommission($itemCommission);
  712.                         $htInvItem->setItemOpCommission(0);
  713.                         $htInvItem->setItemOver($itemOver);
  714.                         $htInvItem->setItemOpOver(0);
  715.                         $htInvItem->setItemSubTotalPrice(round($totalPrice, 2));
  716.                         $htInvItem->setItemCosteDirecto(round($costeDirecto, 2));
  717.                         $htInvItem->setItemBeneficio(round($benefit, 2));
  719.                         $em->persist($htInvItem);
  720.                         $em->flush();
  721.                     }
  722.                 }
  723.             }
  724.         }
  726.         $string_data_iva = '[21]'.round($data_iva['ivaMontoVeintiUno'],2).'[21]'.'[10]'.round($data_iva['ivaMontoDiez'],2).'[10]';
  728.         // Se actualiza la factura con los datos globales
  729.         $invoice->setTotalNet($totalNet);
  730.         $invoice->setVatTotalGroup($string_data_iva);
  731.         $invoice->setTotal(round($total,2));
  733.         // Comisión de HT a GreenPatio
  734.         $reserva = $em->getRepository(Reservation::class)->findOneById($htFile->getReservation());
  735.         if (!empty($reserva)){
  736.             if (!is_null($reserva->getComHtGp())) {
  737.                 $infoComissionToService = $totalNet * ($reserva->getComHtGp()/100);
  738.                 $perCom = $reserva->getComHtGp();
  739.             } else {
  740.                 // Valor por defecto de la Comision de Ht 14%
  741.                 $infoComissionToService = $totalNet * (14/100);
  742.                 $perCom = 14;
  743.             }
  745.             $xObservation = $invoice->getPrefix().$invoice->getIdNum().' - Comisión MANTE de Green Patio (Generado automaticamente) del '.$perCom . '%';
  746.             $user_logueado = $this->getUser();
  747.             $now = new \DateTimeImmutable("now");
  749. //            $newHtItem = new HtItem();
  750. //            $newHtItem->setHtFile($htFile)
  751. //                ->setDateStart($htFile->getDateStart())
  752. //                ->setGratitudes(0)
  753. //                ->setCreatedId($user_logueado)
  754. //                ->setUpdatedId($user_logueado)
  755. //                ->setCreatedAt($now)
  756. //                ->setUpdatedAt($now)
  757. //                ->setObservation($xObservation)
  758. //                ->setPax(1);
  759. //            $em->persist($newHtItem);
  760. //            $em->flush();
  762.             $newHtExtra = new HtExtra();
  763.             $newHtExtra->setHtItem($xItem)
  764.                 ->setCreatedId($user_logueado)
  765.                 ->setUpdatedId($user_logueado)
  766.                 ->setCreatedAt($now)
  767.                 ->setUpdatedAt($now)
  768.                 ->setConcept($invoice->getPrefix().$invoice->getIdNum().' - Comisión MANTE de Green Patio (Generado automaticamente)')
  769.                 ->setPrice(0)
  770.                 ->setVat(21)
  771.                 ->setAppearInvoice(0)
  772.                 ->setOverCommission($infoComissionToService)
  773.                 ->setOpOverCommission(0);
  774.             $em->persist($newHtExtra);
  775.             $em->flush();
  777. //            $htMenuExtras = $em->getRepository(HtMenu::class)->findByHtItem($newHtItem->getId());
  778. //            foreach ($htMenuExtras as $item){
  779. //                $htMenuRepository->remove($item, true);
  780. //            }
  782.             $newBenAfterCom = $invoice->getBenefit() - ($infoComissionToService * (1 + ($newHtExtra->getVat()/100)));
  783.             $invoice->setBenefit($newBenAfterCom);
  784.         }
  786.         // Se actualiza el estado del expediente a facturado
  787.         $htFile->setStatus(StatusHelper::STATUS_HT['Facturado']);
  788.         $em->persist($htFile);
  790.         $em->persist($invoice);
  791.         $em->flush();
  793.         $dataService = $this->commisionEnterpriseService->commissionHigoTrigoGreenPatio($invoice->getId(), $user_logueado->getId());
  795.         return $this->redirectToRoute('ht_view_invoice', ['id' => $invoice->getPrefix(). $invoice->getIdNum()], Response::HTTP_SEE_OTHER);
  796.     }
  799.     /**
  800.      * @Route("/viewinvoice/{id}",  name="ht_view_invoice")
  801.      * Ver la factura con el ID
  802.      */
  803.     public function showInvoiceHtAction($id, EntityManagerInterface $em, Request $request)
  804.     {
  805.         $idNum = (substr($id, 0, 1) == 'F') ? substr($id, 1) : substr($id, 2);      // F1, GP1, CV1
  806.         $prefix = (substr($id, 0, 1) == 'F') ? 'F' : substr($id, 0, 2);
  807.         $user = $this->getUser();
  808.         $parameters = array( 'idNum' => $idNum, 'prefix' => $prefix, );
  809.         $dql = 'SELECT p
  810.                 FROM App\Entity\HtInvoice p
  811.                 WHERE p.idNum = :idNum AND p.prefix = :prefix';
  812.         $query = $em->createQuery($dql)->setParameters($parameters);
  813.         $invoice = $query->getResult();
  814.         $invoice = (!empty($invoice)) ? $invoice[0] : null;
  815. //        $id = $invoice->getPrefix() . $invoice->getIdNum();
  817.         // Si no consigue la factura redirige al listado de expedientes
  818.         if (empty($invoice)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  820.         $datAt = (!empty($invoice)) ? $invoice->getDateAt() : null;
  821.         $totales_neto = (!empty($invoice)) ? $invoice->getTotalNet() : 0;
  822.         $totales_iva = (!empty($invoice)) ? $invoice->getVatTotalGroup() : 0;
  823.         $totales = (!empty($invoice)) ? $invoice->getTotal() : 0;
  824.         $htInvoiceItems = $em->getRepository(HtInvoiceItems::class)->findByInvoice($invoice);
  825.         $htFile = $em->getRepository(HtFile::class)->findOneById(($invoice->getHtFile())->getId());
  826.         $clientName = (!empty($invoice)) ? $invoice->getClientName() : 'No se pudo determinar el cliente';
  827.         $clientAddress = (!empty($invoice)) ? $invoice->getClientAddress() : 'No se pudo determinar la dirección';
  828.         $clientDocument = (!empty($invoice)) ? $invoice->getClientDocument() : 'No se pudo determinar';
  829.         $type = $invoice->getType();
  830.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  832.         $bases_imponibles = array('21'=> 0,'10'=> 0,'0'=> 0,);
  833.         $datasupplier = array(); $netoSumItems = 0; $totalSumItems = 0;
  834.         $data_iva = array('ivaMontoDiez' => 0, 'ivaMontoVeintiUno' => 0);
  835.         $datasupplier['invoice_item_net_sum'] = 0; $datasupplier['invoice_item_sum'] = 0;
  836.         $datasupplier['invoice_extra_net_sum'] = 0; $datasupplier['invoice_extra_sum'] = 0;
  838.         foreach ($htInvoiceItems as $key => $item){
  839.             if ($item->getItemType()=='htMenu') {
  840.                 $datasupplier['invoice_item'][] = array(
  841.                     'id' => $item->getId(),
  842.                     'itemName' => $item->getItemName(),
  843.                     'itemPrice' => $item->getItemPrice(),
  844.                     'itemPax' => $item->getItemPax(),
  845.                     'itemDateStart' => $item->getItemDateStart(),
  846.                     'itemDateEnd' => $item->getItemDateEnd(),
  847.                     'itemIva' => $item->getItemIva(),
  848.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  849.                 );
  850.                 $netoSumItems += $item->getItemSubTotalPrice();
  851.                 $datasupplier['invoice_item_net_sum'] += $item->getItemSubTotalPrice();
  852.                 $datasupplier['invoice_item_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  853.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  854.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  855.                 switch ($item->getItemIva()) {
  856.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  857.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  858.                     default: break;
  859.                 }
  860.             }
  862.             if ($item->getItemType()=='htExtra') {
  863.                 $datasupplier['invoice_extra'][] = array(
  864.                     'id' => $item->getId(),
  865.                     'itemType' => $item->getItemType(),
  866.                     'itemIdOrigin' => $item->getItemIdOrigin(),
  867.                     'itemName' => $item->getItemName(),
  868.                     'itemPrice' => $item->getItemSubTotalPrice(),
  869.                     'itemPax' => $item->getItemPax(),
  870.                     'itemDateStart' => $item->getItemDateStart(),
  871.                     'itemDateEnd' => $item->getItemDateEnd(),
  872.                     'itemIva' => $item->getItemIva(),
  873.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  874.                 );
  875.                 $netoSumItems += $item->getItemSubTotalPrice();
  876.                 $datasupplier['invoice_extra_net_sum'] += $item->getItemSubTotalPrice();
  877.                 $datasupplier['invoice_extra_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  878.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  879.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  880.                 switch ($item->getItemIva()) {
  881.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  882.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  883.                     default: break;
  884.                 }
  885.             }
  886.         }
  887.         $allInvoices = $em->getRepository(HtInvoice::class)->findByHtFile($htFile);
  888.         $invoiceRec = $em->getRepository(HtInvoice::class)->findByInvoiceToRec($id);
  889.         $boolToRec = ($invoice->getType() == 'Invoice Rec') ? false : empty($invoiceRec);
  891.         return $this->render('higotrigo/ht_invoice/show-invoice.html.twig',
  892.             array(
  893.                 'id' => $htFile->getId(),
  894.                 'cid' => '',
  895.                 'fid' => $id,
  896.                 'invoice' => $invoice,
  897.                 'allInvoices' => $allInvoices,
  898.                 'proformas' => null,
  899.                 'numberadmin' => '',
  900.                 'type' => $type,
  901.                 'number' => $id,
  902.                 'prefix' => $prefix,
  903.                 'date' => $datAt,
  904.                 'reservation' => $htFile,
  905.                 'company' => $company,
  906.                 'user' => $user,
  907.                 'boolToRec' => $boolToRec,
  908.                 'invoicedeposititems' => '',
  909.                 'datasupplier' => $datasupplier,
  910.                 'totales_neto' => $netoSumItems,
  911.                 'totales_iva' => $totales_iva,
  912.                 'totales' => $totalSumItems,
  913.                 'bases_imponibles' => $data_iva,
  914.                 'paymentInvoice' => null,
  915.                 'currency' => '€',
  916.                 'clientName' => $clientName,
  917.                 'clientAddress' => $clientAddress,
  918.                 'clientDocument' => $clientDocument,
  919.             )
  920.         );
  921.     }
  924.     /**
  925.      * @Route("/viewinvoicerec/{id}",  name="ht_view_invoice_rec")
  926.      * Ver la factura rectificativa con el ID
  927.      */
  928.     public function showInvoiceRecHtAction($id, EntityManagerInterface $em, Request $request)
  929.     {
  930.         $idNum = (substr($id, 0, 2) == 'RF') ? substr($id, 2) : substr($id, 3);      // RF1, RGP1, RCV1
  931.         $prefix = (substr($id, 0, 2) == 'RF') ? 'RF' : substr($id, 0, 3);
  933.         $user = $this->getUser();
  934.         $parameters = array( 'idNum' => $idNum, 'prefix' => $prefix, );
  935.         $dql = 'SELECT p
  936.                 FROM App\Entity\HtInvoice p
  937.                 WHERE p.idNum = :idNum AND p.prefix = :prefix';
  938.         $query = $em->createQuery($dql)->setParameters($parameters);
  939.         $invoice = $query->getResult();
  940.         $invoice = (!empty($invoice)) ? $invoice[0] : null;
  942.         // Si no consigue la factura redirige al listado de expedientes
  943.         if (empty($invoice)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  945.         $datAt = (!empty($invoice)) ? $invoice->getDateAt() : null;
  946.         $totales_neto = (!empty($invoice)) ? $invoice->getTotalNet() : 0;
  947.         $totales_iva = (!empty($invoice)) ? $invoice->getVatTotalGroup() : 0;
  948.         $totales = (!empty($invoice)) ? $invoice->getTotal() : 0;
  949.         $htInvoiceItems = $em->getRepository(HtInvoiceItems::class)->findByInvoice($invoice);
  950.         $htFile = $em->getRepository(HtFile::class)->findOneById(($invoice->getHtFile())->getId());
  951.         $clientName = (!empty($invoice)) ? $invoice->getClientName() : 'No se pudo determinar el cliente';
  952.         $clientAddress = (!empty($invoice)) ? $invoice->getClientAddress() : 'No se pudo determinar la dirección';
  953.         $clientDocument = (!empty($invoice)) ? $invoice->getClientDocument() : 'No se pudo determinar';
  954.         $type = $invoice->getType();
  955.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  957.         $bases_imponibles = array('21'=> 0,'10'=> 0,'0'=> 0,);
  958.         $datasupplier = array(); $netoSumItems = 0; $totalSumItems = 0;
  959.         $data_iva = array('ivaMontoDiez' => 0, 'ivaMontoVeintiUno' => 0);
  960.         $datasupplier['invoice_item_net_sum'] = 0; $datasupplier['invoice_item_sum'] = 0;
  961.         $datasupplier['invoice_extra_net_sum'] = 0; $datasupplier['invoice_extra_sum'] = 0;
  963.         foreach ($htInvoiceItems as $key => $item){
  964.             if ($item->getItemType()=='htMenu') {
  965.                 $datasupplier['invoice_item'][] = $item;
  966.                 $netoSumItems += $item->getItemSubTotalPrice();
  967.                 $datasupplier['invoice_item_net_sum'] += $item->getItemSubTotalPrice();
  968.                 $datasupplier['invoice_item_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  969.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  970.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  971.                 switch ($item->getItemIva()) {
  972.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  973.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  974.                     default: break;
  975.                 }
  976.             }
  978.             if ($item->getItemType()=='htExtra') {
  979. //                $datasupplier['invoice_extra'][] = $item;
  980.                 $datasupplier['invoice_extra'][] = array(
  981.                     'id' => $item->getId(),
  982.                     'itemType' => $item->getItemType(),
  983.                     'itemIdOrigin' => $item->getItemIdOrigin(),
  984.                     'itemName' => $item->getItemName(),
  985.                     'itemPrice' => $item->getItemSubTotalPrice(),
  986.                     'itemPax' => $item->getItemPax(),
  987.                     'itemDateStart' => $item->getItemDateStart(),
  988.                     'itemDateEnd' => $item->getItemDateEnd(),
  989.                     'itemIva' => $item->getItemIva(),
  990.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  991.                 );
  993.                 $netoSumItems += $item->getItemSubTotalPrice();
  994.                 $datasupplier['invoice_extra_net_sum'] += $item->getItemSubTotalPrice();
  995.                 $datasupplier['invoice_extra_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  996.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  997.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  998.                 switch ($item->getItemIva()) {
  999.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1000.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1001.                     default: break;
  1002.                 }
  1003.             }
  1004.         }
  1005.         $allInvoices = $em->getRepository(HtInvoice::class)->findByHtFile($htFile);
  1007.         return $this->render('higotrigo/ht_invoice/show-invoice.html.twig',
  1008.             array(
  1009.                 'id' => $htFile->getId(),
  1010.                 'cid' => '',
  1011.                 'fid' => $id,
  1012.                 'invoice' => $invoice,
  1013.                 'invoiceIdToRec' => $invoice->getInvoiceToRec(),
  1014.                 'allInvoices' => $allInvoices,
  1015.                 'proformas' => null,
  1016.                 'boolToRec' => false,
  1017.                 'numberadmin' => '',
  1018.                 'type' => $type,
  1019.                 'number' => $id,
  1020.                 'prefix' => $prefix,
  1021.                 'date' => $datAt,
  1022.                 'reservation' => $htFile,
  1023.                 'company' => $company,
  1024.                 'user' => $user,
  1025.                 'invoicedeposititems' => '',
  1026.                 'datasupplier' => $datasupplier,
  1027.                 'totales_neto' => $netoSumItems,
  1028.                 'totales_iva' => $totales_iva,
  1029.                 'totales' => $totalSumItems,
  1030.                 'bases_imponibles' => $data_iva,
  1031.                 'paymentInvoice' => null,
  1032.                 'currency' => '€',
  1033.                 'clientName' => $clientName,
  1034.                 'clientAddress' => $clientAddress,
  1035.                 'clientDocument' => $clientDocument,
  1036.             )
  1037.         );
  1038.     }
  1041.     /**
  1042.      * @Route("/htexternal/viewprintinvoice/{id}",  name="ht_view_print_invoice")
  1043.      * Ver la factura con el ID en modalidad de impresion
  1044.      */
  1045.     public function printInvoiceHtAction($id, EntityManagerInterface $em, Request $request)
  1046.     {
  1047.         $idNum = (substr($id, 0, 1) == 'F') ? substr($id, 1) : substr($id, 2);      // F1, GP1, CV1
  1048.         $prefix = (substr($id, 0, 1) == 'F') ? 'F' : substr($id, 0, 2);
  1049.         $user = $this->getUser();
  1050.         $parameters = array( 'idNum' => $idNum, 'prefix' => $prefix, );
  1051.         $dql = 'SELECT p
  1052.                 FROM App\Entity\HtInvoice p
  1053.                 WHERE p.idNum = :idNum AND p.prefix = :prefix';
  1054.         $query = $em->createQuery($dql)->setParameters($parameters);
  1055.         $invoice = $query->getResult();
  1056.         $invoice = (!empty($invoice)) ? $invoice[0] : null;
  1058.         // Si no consigue la factura redirige al listado de expedientes
  1059.         if (empty($invoice)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  1061.         $datAt = (!empty($invoice)) ? $invoice->getDateAt() : null;
  1062.         $totales_neto = (!empty($invoice)) ? $invoice->getTotalNet() : 0;
  1063.         $totales_iva = (!empty($invoice)) ? $invoice->getVatTotalGroup() : 0;
  1064.         $totales = (!empty($invoice)) ? $invoice->getTotal() : 0;
  1065.         $htInvoiceItems = $em->getRepository(HtInvoiceItems::class)->findByInvoice($invoice);
  1066.         $htFile = $em->getRepository(HtFile::class)->findOneById(($invoice->getHtFile())->getId());
  1067.         $clientName = (!empty($invoice)) ? $invoice->getClientName() : 'No se pudo determinar el cliente';
  1068.         $clientAddress = (!empty($invoice)) ? $invoice->getClientAddress() : 'No se pudo determinar la dirección';
  1069.         $clientDocument = (!empty($invoice)) ? $invoice->getClientDocument() : 'No se pudo determinar';
  1070.         $type = $invoice->getType();
  1071.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  1073.         $bases_imponibles = array('21'=> 0,'10'=> 0,'0'=> 0,);
  1074.         $datasupplier = array(); $netoSumItems = 0; $totalSumItems = 0;
  1075.         $data_iva = array('ivaMontoDiez' => 0, 'ivaMontoVeintiUno' => 0);
  1076.         $datasupplier['invoice_item_net_sum'] = 0; $datasupplier['invoice_item_sum'] = 0;
  1077.         $datasupplier['invoice_extra_net_sum'] = 0; $datasupplier['invoice_extra_sum'] = 0;
  1079.         foreach ($htInvoiceItems as $key => $item){
  1080.             if ($item->getItemType()=='htMenu') {
  1081.                 $datasupplier['invoice_item'][] = array(
  1082.                     'id' => $item->getId(),
  1083.                     'itemName' => $item->getItemName(),
  1084.                     'itemPrice' => $item->getItemPrice(),
  1085.                     'itemPax' => $item->getItemPax(),
  1086.                     'itemDateStart' => $item->getItemDateStart(),
  1087.                     'itemDateEnd' => $item->getItemDateEnd(),
  1088.                     'itemIva' => $item->getItemIva(),
  1089.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1090.                 );
  1091.                 $netoSumItems += $item->getItemSubTotalPrice();
  1092.                 $datasupplier['invoice_item_net_sum'] += $item->getItemSubTotalPrice();
  1093.                 $datasupplier['invoice_item_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1094.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1095.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1096.                 switch ($item->getItemIva()) {
  1097.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1098.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1099.                     default: break;
  1100.                 }
  1101.             }
  1103.             if ($item->getItemType()=='htExtra') {
  1104. //                $datasupplier['invoice_extra'][] = $item;
  1105.                 $datasupplier['invoice_extra'][] = array(
  1106.                     'id' => $item->getId(),
  1107.                     'itemType' => $item->getItemType(),
  1108.                     'itemIdOrigin' => $item->getItemIdOrigin(),
  1109.                     'itemName' => $item->getItemName(),
  1110.                     'itemPrice' => $item->getItemSubTotalPrice(),
  1111.                     'itemPax' => $item->getItemPax(),
  1112.                     'itemDateStart' => $item->getItemDateStart(),
  1113.                     'itemDateEnd' => $item->getItemDateEnd(),
  1114.                     'itemIva' => $item->getItemIva(),
  1115.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1116.                 );
  1117.                 $netoSumItems += $item->getItemSubTotalPrice();
  1118.                 $datasupplier['invoice_extra_net_sum'] += $item->getItemSubTotalPrice();
  1119.                 $datasupplier['invoice_extra_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1120.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1121.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1122.                 switch ($item->getItemIva()) {
  1123.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1124.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1125.                     default: break;
  1126.                 }
  1127.             }
  1128.         }
  1130.         return $this->render('higotrigo/ht_invoice/invoice-print.html.twig',
  1131.             array(
  1132.                 'id' => $htFile->getId(),
  1133.                 'cid' => '',
  1134.                 'fid' => $id,
  1135.                 'invoice' => $invoice,
  1136.                 'proformas' => null,
  1137.                 'boolToRec' => true,
  1138.                 'numberadmin' => '',
  1139.                 'type' => $type,
  1140.                 'number' => $id,
  1141.                 'prefix' => $prefix,
  1142.                 'date' => $datAt,
  1143.                 'reservation' => $htFile,
  1144.                 'company' => $company,
  1145.                 'user' => $user,
  1146.                 'invoicedeposititems' => '',
  1147.                 'datasupplier' => $datasupplier,
  1148.                 'totales_neto' => $netoSumItems,
  1149.                 'totales_iva' => $totales_iva,
  1150.                 'totales' => $totalSumItems,
  1151.                 'bases_imponibles' => $data_iva,
  1152.                 'paymentInvoice' => null,
  1153.                 'currency' => '€',
  1154.                 'clientName' => $clientName,
  1155.                 'clientAddress' => $clientAddress,
  1156.                 'clientDocument' => $clientDocument,
  1157.             )
  1158.         );
  1159.     }
  1162.     /**
  1163.      * @Route("/htexternal/viewprintinvoicerec/{id}", name="ht_view_print_invoicerec")
  1164.      * Ver la factura rectificativa con el ID en modalidad de impresion
  1165.      */
  1166.     public function printInvoiceRecHtAction($id, EntityManagerInterface $em, Request $request)
  1167.     {
  1168.         $idNum = (substr($id, 0, 2) == 'RF') ? substr($id, 2) : substr($id, 3);      // RF1, RGP1, RCV1
  1169.         $prefix = (substr($id, 0, 2) == 'RF') ? 'RF' : substr($id, 0, 3);
  1171.         $user = $this->getUser();
  1172.         $parameters = array( 'idNum' => $idNum, 'prefix' => $prefix, );
  1173.         $dql = 'SELECT p
  1174.                 FROM App\Entity\HtInvoice p
  1175.                 WHERE p.idNum = :idNum AND p.prefix = :prefix';
  1176.         $query = $em->createQuery($dql)->setParameters($parameters);
  1177.         $invoice = $query->getResult();
  1178.         $invoice = (!empty($invoice)) ? $invoice[0] : null;
  1180.         // Si no consigue la factura redirige al listado de expedientes
  1181.         if (empty($invoice)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  1183.         $datAt = (!empty($invoice)) ? $invoice->getDateAt() : null;
  1184.         $totales_neto = (!empty($invoice)) ? $invoice->getTotalNet() : 0;
  1185.         $totales_iva = (!empty($invoice)) ? $invoice->getVatTotalGroup() : 0;
  1186.         $totales = (!empty($invoice)) ? $invoice->getTotal() : 0;
  1187.         $htInvoiceItems = $em->getRepository(HtInvoiceItems::class)->findByInvoice($invoice);
  1188.         $htFile = $em->getRepository(HtFile::class)->findOneById(($invoice->getHtFile())->getId());
  1189.         $clientName = (!empty($invoice)) ? $invoice->getClientName() : 'No se pudo determinar el cliente';
  1190.         $clientAddress = (!empty($invoice)) ? $invoice->getClientAddress() : 'No se pudo determinar la dirección';
  1191.         $clientDocument = (!empty($invoice)) ? $invoice->getClientDocument() : 'No se pudo determinar';
  1192.         $type = $invoice->getType();
  1193.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  1194.         $invoiceIdToRec = $invoice->getInvoiceToRec();
  1196.         $bases_imponibles = array('21'=> 0,'10'=> 0,'0'=> 0,);
  1197.         $datasupplier = array(); $netoSumItems = 0; $totalSumItems = 0;
  1198.         $data_iva = array('ivaMontoDiez' => 0, 'ivaMontoVeintiUno' => 0);
  1199.         $datasupplier['invoice_item_net_sum'] = 0; $datasupplier['invoice_item_sum'] = 0;
  1200.         $datasupplier['invoice_extra_net_sum'] = 0; $datasupplier['invoice_extra_sum'] = 0;
  1202.         foreach ($htInvoiceItems as $key => $item){
  1203.             if ($item->getItemType()=='htMenu') {
  1204.                 $datasupplier['invoice_item'][] = array(
  1205.                     'id' => $item->getId(),
  1206.                     'itemName' => $item->getItemName(),
  1207.                     'itemPrice' => $item->getItemPrice(),
  1208.                     'itemPax' => $item->getItemPax(),
  1209.                     'itemDateStart' => $item->getItemDateStart(),
  1210.                     'itemDateEnd' => $item->getItemDateEnd(),
  1211.                     'itemIva' => $item->getItemIva(),
  1212.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1213.                 );
  1214.                 $netoSumItems += $item->getItemSubTotalPrice();
  1215.                 $datasupplier['invoice_item_net_sum'] += $item->getItemSubTotalPrice();
  1216.                 $datasupplier['invoice_item_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1217.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1218.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1219.                 switch ($item->getItemIva()) {
  1220.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1221.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1222.                     default: break;
  1223.                 }
  1224.             }
  1226.             if ($item->getItemType()=='htExtra') {
  1227. //                $datasupplier['invoice_extra'][] = $item;
  1228.                 $datasupplier['invoice_extra'][] = array(
  1229.                     'id' => $item->getId(),
  1230.                     'itemType' => $item->getItemType(),
  1231.                     'itemIdOrigin' => $item->getItemIdOrigin(),
  1232.                     'itemName' => $item->getItemName(),
  1233.                     'itemPrice' => $item->getItemSubTotalPrice(),
  1234.                     'itemPax' => $item->getItemPax(),
  1235.                     'itemDateStart' => $item->getItemDateStart(),
  1236.                     'itemDateEnd' => $item->getItemDateEnd(),
  1237.                     'itemIva' => $item->getItemIva(),
  1238.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1239.                 );
  1240.                 $netoSumItems += $item->getItemSubTotalPrice();
  1241.                 $datasupplier['invoice_extra_net_sum'] += $item->getItemSubTotalPrice();
  1242.                 $datasupplier['invoice_extra_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1243.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1244.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1245.                 switch ($item->getItemIva()) {
  1246.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1247.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1248.                     default: break;
  1249.                 }
  1250.             }
  1251.         }
  1253.         return $this->render('higotrigo/ht_invoice/invoice-print.html.twig',
  1254.             array(
  1255.                 'id' => $htFile->getId(),
  1256.                 'cid' => '',
  1257.                 'fid' => $id,
  1258.                 'invoice' => $invoice,
  1259.                 'proformas' => null,
  1260.                 'boolToRec' => true,
  1261.                 'numberadmin' => '',
  1262.                 'type' => $type,
  1263.                 'number' => $id,
  1264.                 'prefix' => $prefix,
  1265.                 'date' => $datAt,
  1266.                 'reservation' => $htFile,
  1267.                 'company' => $company,
  1268.                 'user' => $user,
  1269.                 'invoicedeposititems' => '',
  1270.                 'datasupplier' => $datasupplier,
  1271.                 'totales_neto' => $netoSumItems,
  1272.                 'totales_iva' => $totales_iva,
  1273.                 'totales' => $totalSumItems,
  1274.                 'bases_imponibles' => $data_iva,
  1275.                 'paymentInvoice' => null,
  1276.                 'currency' => '€',
  1277.                 'clientName' => $clientName,
  1278.                 'clientAddress' => $clientAddress,
  1279.                 'clientDocument' => $clientDocument,
  1280.                 'invoiceIdToRec' => $invoiceIdToRec,
  1281.             )
  1282.         );
  1283.     }
  1287.     /**
  1288.      * @Route("/createrecinvoice/{id}",  name="ht_create_rec_invoice")
  1289.      * Generar factura rectificativa de la factura ID
  1290.      */
  1291.     public function createRecInvoiceHtAction($id, EntityManagerInterface $em, Request $request)
  1292.     {
  1293.         $idNum = (substr($id, 0, 1) == 'F') ? substr($id, 1) : substr($id, 2);      // F1, GP1, CV1
  1294.         $prefix = (substr($id, 0, 1) == 'F') ? 'F' : substr($id, 0, 2);
  1295.         $parameters = array( 'idNum' => $idNum, 'prefix' => $prefix, );
  1296.         $dql = 'SELECT p
  1297.                 FROM App\Entity\HtInvoice p
  1298.                 WHERE p.idNum = :idNum AND p.prefix = :prefix';
  1299.         $query = $em->createQuery($dql)->setParameters($parameters);
  1300.         $invoice = $query->getResult();
  1301.         $invoice = (!empty($invoice)) ? $invoice[0] : null;
  1303.         // Si no consigue la factura redirige al listado de expedientes
  1304.         if (empty($invoice)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  1306.         // Buscamos el ID para la nueva rectificativa
  1307.         $parameters = array( 'prefix' => 'R'.$prefix, );
  1308.         $dql = 'SELECT p
  1309.                 FROM App\Entity\HtInvoice p
  1310.                 WHERE p.prefix = :prefix';
  1311.         $query = $em->createQuery($dql)->setParameters($parameters);
  1312.         $invoiceRec = $query->getResult();
  1313.         $invoiceRec = (!empty($invoiceRec)) ? end($invoiceRec) : null;
  1315.         $idNewRec = empty($invoiceRec) ? 1 : ($invoiceRec->getIdNum() + 1) ;
  1316.         $dateAt = new DateTimeImmutable('now');
  1317.         $invoiceItems = $em->getRepository(HtInvoiceItems::class)->findByInvoice($invoice);
  1319.         // Creamos la factura rectificativa
  1320.         $oldIvas = $invoice->getVatTotalGroup();
  1321.         $newIvas = $this->transformarString($oldIvas);
  1323.         $invoiceRec = new HtInvoice();
  1324.         $invoiceRec->setIdNum($idNewRec);
  1325.         $invoiceRec->setPrefix('R'. $prefix);
  1326.         $invoiceRec->setDateAt($dateAt);
  1327.         $invoiceRec->setType('Invoice Rec');
  1328.         $invoiceRec->setClientName($invoice->getClientName());
  1329.         $invoiceRec->setClientAddress($invoice->getClientAddress());
  1330.         $invoiceRec->setClientDocument($invoice->getClientDocument());
  1331.         $invoiceRec->setClientType($invoice->getClientType());
  1332.         $invoiceRec->setHtFile($invoice->getHtFile());
  1333.         $invoiceRec->setBenefit((-1) * $invoice->getBenefit());
  1334.         $invoiceRec->setTotalNet((-1) * $invoice->getTotalNet());
  1335.         $invoiceRec->setVatTotalGroup($newIvas);
  1336.         $invoiceRec->setTotal((-1) * $invoice->getTotal());
  1337.         $invoiceRec->setInvoiceToRec($id);
  1339.         $em->persist($invoiceRec);
  1340.         $em->flush();
  1342.         // Creamos los Items de la factura rectificativa
  1343.         foreach ($invoiceItems as $item){
  1344.             $htInvItem = new HtInvoiceItems();
  1345.             $htInvItem->setInvoice($invoiceRec);
  1346.             $htInvItem->setHtFile($item->getHtFile());
  1347.             $htInvItem->setItemType($item->getItemType());
  1348.             $htInvItem->setItemIdOrigin($item->getItemIdOrigin());
  1349.             $htInvItem->setItemName($item->getItemName());
  1350.             $htInvItem->setItemDateStart($item->getItemDateStart());
  1351.             $htInvItem->setItemDateEnd($item->getItemDateEnd());
  1352.             $htInvItem->setItemPrice((-1) * $item->getItemPrice());
  1353.             $htInvItem->setItemUnits($item->getItemUnits());
  1354.             $htInvItem->setItemPax($item->getItemPax());
  1355.             $htInvItem->setItemKgLt($item->getItemKgLt());
  1356.             $htInvItem->setItemRank($item->getItemRank());
  1357.             $htInvItem->setItemLocation($item->getItemLocation());
  1358.             $htInvItem->setItemIva($item->getItemIva());
  1359.             $htInvItem->setItemOpIva($item->isItemOpIva());
  1360.             $htInvItem->setItemCommission((-1) * $item->getItemCommission());
  1361.             $htInvItem->setItemOpCommission($item->isItemOpCommission());
  1362.             $htInvItem->setItemOver((-1) * $item->getItemOver());
  1363.             $htInvItem->setItemOpOver($item->isItemOpOver());
  1364.             $htInvItem->setItemSubTotalPrice((-1) * $item->getItemSubTotalPrice());
  1365.             $htInvItem->setItemCosteDirecto((-1) * $item->getItemCosteDirecto());
  1366.             $htInvItem->setItemBeneficio((-1) * $item->getItemBeneficio());
  1368.             $em->persist($htInvItem);
  1369.             $em->flush();
  1370.         }
  1372.         $user_logueado = $this->getUser();
  1373.         $dataService = $this->commisionEnterpriseService->rectCommissionHigoTrigoGreenPatio($invoice->getPrefix(), $invoice->getIdNum(), $user_logueado->getId());
  1375.         return $this->redirectToRoute('ht_view_invoice_rec', ['id' => $invoiceRec->getPrefix(). $invoiceRec->getIdNum()], Response::HTTP_SEE_OTHER);
  1376.     }
  1379.     /**
  1380.      * @Route("/createproforma/{id}",  name="ht_create_proforma")
  1381.      * Generar proforma en el expediente ID
  1382.      */
  1383.     public function createProformaHtAction($id, EntityManagerInterface $em, Request $request)
  1384.     {
  1385.         $req = $request->request->get('invoiced_item');
  1386.         $clientName = $request->request->get('clientName');
  1387.         $req_extra = $request->request->get('invoiced_extra');
  1388.         $htFile = $em->getRepository(HtFile::class)->findOneById($id);
  1389.         $beneficio_total = 0;
  1390.         foreach ($req as $itemServ){
  1391.             foreach ($itemServ as $item) {
  1392.                 if ($item['boolToInvoice'] == 'true') {
  1393.                     $beneficio_total += $item['benefit'];
  1394.                 }
  1395.             }
  1396.         }
  1398.         // Se genera la proforma
  1399.         // buscamos por el prefijo de cada linea de facturacion para saber el ultimo ID
  1400.         $invoiceLineGp = $em->getRepository(HtInvoice::class)->findByPrefix('GP');
  1401.         $invoiceLineCvr = $em->getRepository(HtInvoice::class)->findByPrefix('CV');
  1402.         $invoiceLineOther = $em->getRepository(HtInvoice::class)->findByPrefix('F');
  1403.         $lastGp = end($invoiceLineGp);
  1404.         $lastCvr = end($invoiceLineCvr);
  1405.         $lastOther = end($invoiceLineOther);
  1407.         // Buscamos los HtIemts del HtFile para saber la sala del servicio para determinar la línea de facturación ($prefix)
  1408.         $htItems = $em->getRepository(HtItem::class)->findByHtFile($htFile);
  1409.         $lounge = $htItems[0]->getLoungeGp();
  1410.         $prefix = (empty($lounge) ? 'F' : (($lounge->getId() < 22) ? 'GP' : 'CV'));
  1412.         switch ($prefix) {
  1413.             case 'F': $idNum = (empty($lastOther)) ? 1 : $lastOther->getIdNum() + 1; break;
  1414.             case 'CV': $idNum = (empty($lastCvr)) ? 1 : $lastCvr->getIdNum() + 1; break;
  1415.             default:
  1416.                 // Por defecto Green Patio.
  1417.                 // Esteban Rincon comenta que en caso de un expediente tener salas de GP y CVR deberiamos tener un expediente por linea de facturación
  1418.                 $idNum = (empty($lastGp)) ? 1 : $lastGp->getIdNum() + 1;
  1419.                 break;
  1420.         }
  1422.         $client = (empty($htFile->getClient())) ? null : $htFile->getClient();
  1423.         // Si no hay cliente no se puede facturar, se vuelve a la pantalla de seleccion
  1424.         if (empty($client)){ return $this->redirectToRoute('ht_select_invoice', ['id' => $htFile->getId()], Response::HTTP_SEE_OTHER); }
  1426.         $dateAt = new DateTimeImmutable('now');
  1427.         $type = 'Proforma';
  1428.         $totalNet = 0; $vatTotalGroup = 0; $total = 0;
  1429.         if (empty($clientName)){ $clientName = $client->getName(); }
  1430.         $clientAddress = $request->request->get('clientAddress');
  1431.         $clientDocument = $request->request->get('clientDocument');
  1432.         if (empty($clientDocument)){ $clientDocument = empty($client->getIdDocument()) ? ' ' : $client->getIdDocument(); }
  1433.         $clientType = $request->request->get('clientType');
  1434.         if ($clientType == 'supplier'){
  1435.             $type = 'Proforma de Factura de Comision';
  1436.             $clientName = $request->request->get('clientName');
  1437.             $clientDocument = $request->request->get('clientDocument');
  1438.         }
  1440.         $proforma = new HtProforma();
  1441.         $proforma->setIdNum($idNum);
  1442.         $proforma->setPrefix($prefix);
  1443.         $proforma->setDateAt($dateAt);
  1444.         $proforma->setType($type);
  1445.         $proforma->setTotalNet($totalNet);
  1446.         $proforma->setVatTotalGroup($vatTotalGroup);
  1447.         $proforma->setTotal($total);
  1448.         $proforma->setClientName($clientName);
  1449.         $proforma->setClientAddress($clientAddress);
  1450.         $proforma->setClientDocument($clientDocument);
  1451.         $proforma->setClientType($clientType);
  1452.         $proforma->setHtFile($htFile->getId());
  1453.         $proforma->setBenefit($beneficio_total);
  1455.         $em->persist($proforma);
  1456.         $em->flush();
  1458.         $data_iva = array(); $data_iva['ivaMontoVeintiUno'] = 0; $data_iva['ivaMontoDiez'] = 0;
  1460.         // Se crean los Menus en los HtInvoiceItems
  1461.         foreach ($req as $itemServ){
  1462.             foreach ($itemServ as $item) {
  1463.                 if ($item['boolToInvoice'] == 'true') {
  1464.                     $htMenu = $em->getRepository(HtMenu::class)->findOneByHtItem($item['idHtService']);
  1465.                     $itemType = 'htMenu';
  1466.                     $itemIdOrigin = $htMenu->getId();
  1467.                     $itemName = $item['name'];
  1468.                     $htItem = $em->getRepository(HtItem::class)->findOneById($htMenu->getHtItem());
  1469.                     $dateStart = ($htItem->getDateStart())->format('Y-m-d');
  1470.                     $hourEnd = ($htItem->getHourEnd())->format('Y-m-d');
  1471.                     $dateTimeString = $dateStart . ' ' . $hourEnd;
  1472.                     $dateEnd = new DateTimeImmutable($dateTimeString);
  1473.                     $iva = $htMenu->getIva();
  1474.                     switch ($iva) {
  1475.                         case 10: $data_iva['ivaMontoDiez'] += ($item['subTotalPrice'] * 0.1); break;
  1476.                         case 21: $data_iva['ivaMontoVeintiUno'] += ($item['subTotalPrice'] * 0.21); break;
  1477.                         default: break;
  1478.                     }
  1479.                     $itemCommission = 0;                                                                // Solo htExtra maneja el concepto de over o comision.
  1480.                     $itemOver = 0;                                                                      // Solo htExtra maneja el concepto de over o comision.
  1481.                     $costeDirecto = $item['subTotalPrice'] - $item['benefit'];
  1482.                     $totalNet += round($item['subTotalPrice'], 2);
  1483.                     $total += round($item['subTotalPrice'], 2) + (round($item['subTotalPrice'], 2) * ($iva / 100));
  1485.                     $htInvItem = new HtProformaItems();
  1486.                     $htInvItem->setProforma($proforma);
  1487.                     $htInvItem->setHtFile($htFile->getId());
  1488.                     $htInvItem->setItemType($itemType);
  1489.                     $htInvItem->setItemIdOrigin($itemIdOrigin);
  1490.                     $htInvItem->setItemName($itemName);
  1491.                     $htInvItem->setItemDateStart($htItem->getDateStart());
  1492.                     $htInvItem->setItemDateEnd($dateEnd);
  1493.                     $htInvItem->setItemPrice(round($item['servicePrice'], 2));
  1494.                     $htInvItem->setItemUnits(1);
  1495.                     $htInvItem->setItemPax($item['qty']);
  1496.                     $htInvItem->setItemKgLt(1);
  1497.                     $htInvItem->setItemRank(1);
  1498.                     $htInvItem->setItemLocation(0);
  1499.                     $htInvItem->setItemIva($iva);
  1500.                     $htInvItem->setItemOpIva(0);            // +
  1501.                     $htInvItem->setItemCommission($itemCommission);
  1502.                     $htInvItem->setItemOpCommission(0);
  1503.                     $htInvItem->setItemOver($itemOver);
  1504.                     $htInvItem->setItemOpOver(0);
  1505.                     $htInvItem->setItemSubTotalPrice(round($item['subTotalPrice'], 2));
  1506.                     $htInvItem->setItemCosteDirecto(round($costeDirecto, 2));
  1507.                     $htInvItem->setItemBeneficio(round($item['benefit'], 2));
  1509.                     $em->persist($htInvItem);
  1510.                     $em->flush();
  1511.                 }
  1512.             }
  1513.         }
  1515.         // Se crean los Extras en los HtInvoiceItems
  1516.         if (!empty($req_extra)) {
  1517.             foreach ($req_extra as $item) {
  1518.                 if($item['boolToInvoice'] == 'true') {
  1519.                     $htExtra = $em->getRepository(HtExtra::class)->findOneById($item['idHtExtra']);
  1520.                     if ($htExtra->isAppearInvoice()) {
  1521.                         $itemType = 'htExtra';
  1522.                         $itemIdOrigin = $htExtra->getId();
  1523.                         $itemName = $htExtra->getConcept();
  1524.                         $htItem = $em->getRepository(HtItem::class)->findOneById($htExtra->getHtItem());
  1525.                         $dateStart = ($htItem->getDateStart())->format('Y-m-d');
  1526.                         $hourEnd = ($htItem->getHourEnd())->format('Y-m-d');
  1527.                         $dateTimeString = $dateStart . ' ' . $hourEnd;
  1528.                         $dateEnd = new DateTimeImmutable($dateTimeString);
  1529.                         $iva = $htExtra->getVat();
  1530.                         $itemCommission = (($htExtra->isOpOverCommission() == 0) ? 0 : $htExtra->getOverCommission());
  1531.                         $itemOver = (($htExtra->isOpOverCommission() == 1)  ? 0 : $htExtra->getOverCommission());
  1532.                         $costeDirecto = 0;
  1533.                         $benefit = $itemOver + ($item['price'] * ($itemCommission / 100));
  1534.                         $totalPrice = $item['price'] + $benefit;
  1535.                         switch ($iva) {
  1536.                             case 10: $data_iva['ivaMontoDiez'] += ($totalPrice * 0.1); break;
  1537.                             case 21: $data_iva['ivaMontoVeintiUno'] += ($totalPrice * 0.21); break;
  1538.                             default: break;
  1539.                         }
  1540.                         $totalNet += round($totalPrice, 2);
  1541.                         $total += round($totalPrice, 2) + (round($totalPrice, 2) * ($iva / 100));
  1543.                         $htInvItem = new HtProformaItems();
  1544.                         $htInvItem->setProforma($proforma);
  1545.                         $htInvItem->setHtFile($htFile->getId());
  1546.                         $htInvItem->setItemType($itemType);
  1547.                         $htInvItem->setItemIdOrigin($itemIdOrigin);
  1548.                         $htInvItem->setItemName($itemName);
  1549.                         $htInvItem->setItemDateStart($htItem->getDateStart());
  1550.                         $htInvItem->setItemDateEnd($dateEnd);
  1551.                         $htInvItem->setItemPrice(round($item['price'], 2));
  1552.                         $htInvItem->setItemUnits(1);
  1553.                         $htInvItem->setItemPax(1);
  1554.                         $htInvItem->setItemKgLt(1);
  1555.                         $htInvItem->setItemRank(1);
  1556.                         $htInvItem->setItemLocation(0);
  1557.                         $htInvItem->setItemIva($iva);
  1558.                         $htInvItem->setItemOpIva(0);            // +
  1559.                         $htInvItem->setItemCommission($itemCommission);
  1560.                         $htInvItem->setItemOpCommission(0);
  1561.                         $htInvItem->setItemOver($itemOver);
  1562.                         $htInvItem->setItemOpOver(0);
  1563.                         $htInvItem->setItemSubTotalPrice(round($totalPrice, 2));
  1564.                         $htInvItem->setItemCosteDirecto(round($costeDirecto, 2));
  1565.                         $htInvItem->setItemBeneficio(round($benefit, 2));
  1567.                         $em->persist($htInvItem);
  1568.                         $em->flush();
  1569.                     }
  1570.                 }
  1571.             }
  1572.         }
  1574.         $string_data_iva = '[21]'.round($data_iva['ivaMontoVeintiUno'],2).'[21]'.'[10]'.round($data_iva['ivaMontoDiez'],2).'[10]';
  1576.         // Se actualiza la factura con los datos globales
  1577.         $proforma->setTotalNet($totalNet);
  1578.         $proforma->setVatTotalGroup($string_data_iva);
  1579.         $proforma->setTotal(round($total,2));
  1581.         $em->persist($proforma);
  1582.         $em->flush();
  1584.         return $this->redirectToRoute('ht_view_proforma', ['id' => $proforma->getId()], Response::HTTP_SEE_OTHER);
  1585.     }
  1588.     /**
  1589.      * @Route("/viewproforma/{id}",  name="ht_view_proforma")
  1590.      * Ver la proforma número ID
  1591.      */
  1592.     public function showProformaHtAction($id, EntityManagerInterface $em, Request $request)
  1593.     {
  1594.         $user = $this->getUser();
  1595.         $proforma = $em->getRepository(HtProforma::class)->findOneById($id);
  1597.         // Si no consigue la proforma redirige al listado de expedientes
  1598.         if (empty($proforma)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  1600.         $datAt = (!empty($proforma)) ? $proforma->getDateAt() : null;
  1601.         $totales_neto = (!empty($proforma)) ? $proforma->getTotalNet() : 0;
  1602.         $totales_iva = (!empty($proforma)) ? $proforma->getVatTotalGroup() : 0;
  1603.         $totales = (!empty($proforma)) ? $proforma->getTotal() : 0;
  1604.         $htProformaItems = $em->getRepository(HtProformaItems::class)->findByProforma($proforma);
  1605.         $htFile = $em->getRepository(HtFile::class)->findOneById($proforma->getHtFile());
  1606.         $clientName = (!empty($proforma)) ? $proforma->getClientName() : 'No se pudo determinar el cliente';
  1607.         $clientAddress = (!empty($proforma)) ? $proforma->getClientAddress() : 'No se pudo determinar la dirección';
  1608.         $clientDocument = (!empty($proforma)) ? $proforma->getClientDocument() : 'No se pudo determinar';
  1609.         $type = $proforma->getType();
  1610.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  1612.         $bases_imponibles = array('21'=> 0,'10'=> 0,'0'=> 0,);
  1613.         $datasupplier = array(); $netoSumItems = 0; $totalSumItems = 0;
  1614.         $data_iva = array('ivaMontoDiez' => 0, 'ivaMontoVeintiUno' => 0);
  1615.         $datasupplier['invoice_item_net_sum'] = 0; $datasupplier['invoice_item_sum'] = 0;
  1616.         $datasupplier['invoice_extra_net_sum'] = 0; $datasupplier['invoice_extra_sum'] = 0;
  1618.         foreach ($htProformaItems as $key => $item){
  1619.             if ($item->getItemType()=='htMenu') {
  1620.                 $datasupplier['invoice_item'][] = array(
  1621.                     'id' => $item->getId(),
  1622.                     'itemName' => $item->getItemName(),
  1623.                     'itemPrice' => $item->getItemPrice(),
  1624.                     'itemPax' => $item->getItemPax(),
  1625.                     'itemDateStart' => $item->getItemDateStart(),
  1626.                     'itemDateEnd' => $item->getItemDateEnd(),
  1627.                     'itemIva' => $item->getItemIva(),
  1628.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1629.                 );
  1630.                 $netoSumItems += $item->getItemSubTotalPrice();
  1631.                 $datasupplier['invoice_item_net_sum'] += $item->getItemSubTotalPrice();
  1632.                 $datasupplier['invoice_item_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1633.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1634.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1635.                 switch ($item->getItemIva()) {
  1636.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1637.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1638.                     default: break;
  1639.                 }
  1640.             }
  1642.             if ($item->getItemType()=='htExtra') {
  1643.                 $datasupplier['invoice_extra'][] = array(
  1644.                     'id' => $item->getId(),
  1645.                     'itemType' => $item->getItemType(),
  1646.                     'itemIdOrigin' => $item->getItemIdOrigin(),
  1647.                     'itemName' => $item->getItemName(),
  1648.                     'itemPrice' => $item->getItemSubTotalPrice(),
  1649.                     'itemPax' => $item->getItemPax(),
  1650.                     'itemDateStart' => $item->getItemDateStart(),
  1651.                     'itemDateEnd' => $item->getItemDateEnd(),
  1652.                     'itemIva' => $item->getItemIva(),
  1653.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1654.                 );
  1655.                 $netoSumItems += $item->getItemSubTotalPrice();
  1656.                 $datasupplier['invoice_extra_net_sum'] += $item->getItemSubTotalPrice();
  1657.                 $datasupplier['invoice_extra_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1658.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1659.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1660.                 switch ($item->getItemIva()) {
  1661.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1662.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1663.                     default: break;
  1664.                 }
  1665.             }
  1666.         }
  1667.         $allInvoices = $em->getRepository(HtInvoice::class)->findByHtFile($htFile);
  1668.         $boolToRec = false;
  1669.         $proformas = $em->getRepository(HtProforma::class)->findByHtFile($htFile->getId());
  1670.         $fid = $proforma->getId();
  1672.         return $this->render('higotrigo/ht_invoice/show-invoice.html.twig',
  1673.             array(
  1674.                 'id' => $htFile->getId(),
  1675.                 'cid' => '',
  1676.                 'fid' => $fid,
  1677.                 'invoice' => $proforma,
  1678.                 'allInvoices' => $allInvoices,
  1679.                 'proformas' => $proformas,
  1680.                 'numberadmin' => '',
  1681.                 'type' => $type,
  1682.                 'number' => $proforma->getId(),
  1683.                 'prefix' => $proforma->getPrefix(),
  1684.                 'date' => $datAt,
  1685.                 'reservation' => $htFile,
  1686.                 'company' => $company,
  1687.                 'user' => $user,
  1688.                 'boolToRec' => $boolToRec,
  1689.                 'invoicedeposititems' => '',
  1690.                 'datasupplier' => $datasupplier,
  1691.                 'totales_neto' => $netoSumItems,
  1692.                 'totales_iva' => $totales_iva,
  1693.                 'totales' => $totalSumItems,
  1694.                 'bases_imponibles' => $data_iva,
  1695.                 'paymentInvoice' => null,
  1696.                 'currency' => '€',
  1697.                 'clientName' => $clientName,
  1698.                 'clientAddress' => $clientAddress,
  1699.                 'clientDocument' => $clientDocument,
  1700.             )
  1701.         );
  1702.     }
  1705.     /**
  1706.      * @Route("/htexternal/viewprintproforma/{id}",  name="ht_view_print_proforma")
  1707.      * Ver la proforma del expediente ID en modalidad de impresion
  1708.      */
  1709.     public function printProformaHtAction($id, EntityManagerInterface $em, Request $request)
  1710.     {
  1711.         $proforma = $em->getRepository(HtProforma::class)->findOneById($id);
  1713.         // Si no consigue la proforma redirige al listado de expedientes
  1714.         if (empty($proforma)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  1716.         $datAt = (!empty($proforma)) ? $proforma->getDateAt() : null;
  1717.         $totales_neto = (!empty($proforma)) ? $proforma->getTotalNet() : 0;
  1718.         $totales_iva = (!empty($proforma)) ? $proforma->getVatTotalGroup() : 0;
  1719.         $totales = (!empty($proforma)) ? $proforma->getTotal() : 0;
  1720.         $htProformaItems = $em->getRepository(HtProformaItems::class)->findByProforma($proforma);
  1721.         $htFile = $em->getRepository(HtFile::class)->findOneById($id);
  1722.         $clientName = (!empty($proforma)) ? $proforma->getClientName() : 'No se pudo determinar el cliente';
  1723.         $clientAddress = (!empty($proforma)) ? $proforma->getClientAddress() : 'No se pudo determinar la dirección';
  1724.         $clientDocument = (!empty($proforma)) ? $proforma->getClientDocument() : 'No se pudo determinar';
  1725.         $type = $proforma->getType();
  1726.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  1728.         $bases_imponibles = array('21'=> 0,'10'=> 0,'0'=> 0,);
  1729.         $datasupplier = array(); $netoSumItems = 0; $totalSumItems = 0;
  1730.         $data_iva = array('ivaMontoDiez' => 0, 'ivaMontoVeintiUno' => 0);
  1731.         $datasupplier['invoice_item_net_sum'] = 0; $datasupplier['invoice_item_sum'] = 0;
  1732.         $datasupplier['invoice_extra_net_sum'] = 0; $datasupplier['invoice_extra_sum'] = 0;
  1734.         foreach ($htProformaItems as $key => $item){
  1735.             if ($item->getItemType()=='htMenu') {
  1736.                 $datasupplier['invoice_item'][] = array(
  1737.                     'id' => $item->getId(),
  1738.                     'itemName' => $item->getItemName(),
  1739.                     'itemPrice' => $item->getItemPrice(),
  1740.                     'itemPax' => $item->getItemPax(),
  1741.                     'itemDateStart' => $item->getItemDateStart(),
  1742.                     'itemDateEnd' => $item->getItemDateEnd(),
  1743.                     'itemIva' => $item->getItemIva(),
  1744.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1745.                 );
  1746.                 $netoSumItems += $item->getItemSubTotalPrice();
  1747.                 $datasupplier['invoice_item_net_sum'] += $item->getItemSubTotalPrice();
  1748.                 $datasupplier['invoice_item_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1749.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1750.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1751.                 switch ($item->getItemIva()) {
  1752.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1753.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1754.                     default: break;
  1755.                 }
  1756.             }
  1758.             if ($item->getItemType()=='htExtra') {
  1759.                 $datasupplier['invoice_extra'][] = array(
  1760.                     'id' => $item->getId(),
  1761.                     'itemType' => $item->getItemType(),
  1762.                     'itemIdOrigin' => $item->getItemIdOrigin(),
  1763.                     'itemName' => $item->getItemName(),
  1764.                     'itemPrice' => $item->getItemSubTotalPrice(),
  1765.                     'itemPax' => $item->getItemPax(),
  1766.                     'itemDateStart' => $item->getItemDateStart(),
  1767.                     'itemDateEnd' => $item->getItemDateEnd(),
  1768.                     'itemIva' => $item->getItemIva(),
  1769.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1770.                 );
  1771.                 $netoSumItems += $item->getItemSubTotalPrice();
  1772.                 $datasupplier['invoice_extra_net_sum'] += $item->getItemSubTotalPrice();
  1773.                 $datasupplier['invoice_extra_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1774.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1775.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1776.                 switch ($item->getItemIva()) {
  1777.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1778.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1779.                     default: break;
  1780.                 }
  1781.             }
  1782.         }
  1783.         $allInvoices = $em->getRepository(HtInvoice::class)->findByHtFile($htFile);
  1784.         $boolToRec = false;
  1785.         $fid = $proforma->getPrefix() . $proforma->getIdNum();
  1787.         return $this->render('higotrigo/ht_invoice/proforma-print.html.twig',
  1788.             array(
  1789.                 'id' => $id,
  1790.                 'fid' => $fid,
  1791.                 'type' => 'Proforma',
  1792.                 'number' => $id,
  1793.                 'date' => $datAt,
  1794.                 'company' => $company,
  1795.                 'invoicedeposititems' => '',
  1796.                 'datasupplier' => $datasupplier,
  1797.                 'totales_neto' => $netoSumItems,
  1798.                 'totales' => $totalSumItems,
  1799.                 'bases_imponibles' => $data_iva,
  1800.                 'currency' => '€',
  1801.                 'clientName' => $clientName,
  1802.                 'clientAddress' => $clientAddress,
  1803.                 'clientDocument' => $clientDocument,
  1804.             )
  1805.         );
  1807.     }
  1810.     private function transformarString($input) {
  1811.         // Expresión regular para encontrar números entre los delimitadores [21] y [10]
  1812.         $pattern = '/\[21\](\d+\.?\d*)\[21\]|\[10\](\d+\.?\d*)\[10\]/';
  1814.         // Función de reemplazo que multiplica los números por -1
  1815.         $callback = function ($matches) {
  1816.             if (isset($matches[1]) && $matches[1] !== '') { return '[21]' . (-1 * $matches[1]) . '[21]'; } elseif (isset($matches[2]) && $matches[2] !== '') { return '[10]' . (-1 * $matches[2]) . '[10]'; }
  1817.             return $matches[0]; // No debería llegar aquí
  1818.         };
  1820.         // Realizar el reemplazo en el string original
  1821.         $output = preg_replace_callback($pattern, $callback, $input);
  1822.         return $output;
  1823.     }
  1825.     /**
  1826.      * Formatea el campo vatTotalGroup a una cadena como "157.00 (21%)"
  1827.      */
  1828.     private function formatVatTotalGroup($vatTotalGroup): string
  1829.     {
  1830.         // Regex para extraer valores, porcentajes y manejar valores negativos
  1831.         preg_match_all('/\[(\d+)\](-?\d+(\.\d+)?)/', $vatTotalGroup, $matches);
  1832.         $formattedVat = '';
  1834.         foreach ($matches[1] as $index => $percentage) {
  1835.             // Asegurarse de que los números se formateen correctamente
  1836.             $amount = number_format((float)$matches[2][$index], 2, ',', '.');
  1837.             $formattedVat .= "$amount ({$percentage}%)<br>";
  1838.         }
  1840.         return $formattedVat;
  1841.     }
  1842. }