src/Controller/higotrigo/HtInvoiceController.php line 1048

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.         $invoiceLineBlv = $em->getRepository(HtInvoice::class)->findByPrefix('BL');
  554.         $invoiceLineOther = $em->getRepository(HtInvoice::class)->findByPrefix('F');
  555.         $lastGp = end($invoiceLineGp);
  556.         $lastCvr = end($invoiceLineCvr);
  557.         $lastBlv = end($invoiceLineBlv);
  558.         $lastOther = end($invoiceLineOther);
  560.         // Buscamos los HtIemts del HtFile para saber la sala del servicio para determinar la línea de facturación ($prefix)
  561.         $htItems = $em->getRepository(HtItem::class)->findByHtFile($htFile);
  562.         $lounge = $htItems[0]->getLoungeGp();
  563.         $prefix = empty($lounge) ? 'F' : ($lounge->getId() > 29 ? 'BL' : ($lounge->getId() < 22 ? 'GP' : 'CV'));
  565.         switch ($prefix) {
  566.             case 'F': $idNum = (empty($lastOther)) ? 1 : $lastOther->getIdNum() + 1; break;
  567.             case 'CV': $idNum = (empty($lastCvr)) ? 1 : $lastCvr->getIdNum() + 1; break;
  568.             case 'BL': $idNum = (empty($lastBlv)) ? 1 : $lastBlv->getIdNum() + 1; break;
  569.             default:
  570.                 // Por defecto Green Patio.
  571.                 // Esteban Rincon comenta que en caso de un expediente tener salas de GP y CVR deberiamos tener un expediente por linea de facturación
  572.                 $idNum = (empty($lastGp)) ? 1 : $lastGp->getIdNum() + 1;
  573.                 break;
  574.         }
  576.         $client = (empty($htFile->getClient())) ? null : $htFile->getClient();
  577.         // Si no hay cliente no se puede facturar, se vuelve a la pantalla de seleccion
  578.         if (empty($client)){ return $this->redirectToRoute('ht_select_invoice', ['id' => $htFile->getId()], Response::HTTP_SEE_OTHER); }
  580.         $dateAt = new DateTimeImmutable('now');
  581.         $type = 'Invoice';
  582.         $totalNet = $vatTotalGroup = $total = 0;
  583.         $clientName = $client->getName();
  584.         $clientAddress = $request->request->get('clientAddress');
  585.         $clientDocument = empty($client->getIdDocument()) ? ' ' : $client->getIdDocument();
  586.         $clientType = $request->request->get('clientType');
  587.         if ($clientType == 'supplier'){
  588.             $type = 'commission invoice';
  589.             $clientName = $request->request->get('clientName');
  590.             $clientDocument = $request->request->get('clientDocument');
  591.         }
  593.         $invoice = new HtInvoice();
  594.         $invoice->setIdNum($idNum);
  595.         $invoice->setPrefix($prefix);
  596.         $invoice->setDateAt($dateAt);
  597.         $invoice->setType($type);
  598.         $invoice->setTotalNet($totalNet);
  599.         $invoice->setVatTotalGroup($vatTotalGroup);
  600.         $invoice->setTotal($total);
  601.         $invoice->setClientName($clientName);
  602.         $invoice->setClientAddress($clientAddress);
  603.         $invoice->setClientDocument($clientDocument);
  604.         $invoice->setClientType($clientType);
  605.         $invoice->setHtFile($htFile);
  606.         $invoice->setBenefit($beneficio_total);
  608.         $em->persist($invoice);
  609.         $em->flush();
  611.         $data_iva = []; $data_iva['ivaMontoVeintiUno'] = 0; $data_iva['ivaMontoDiez'] = 0;
  613.         // Se crean los Menus en los HtInvoiceItems
  614.         foreach ($req as $itemServ){
  615.             foreach ($itemServ as $item) {
  616.                 if ($item['boolToInvoice'] == 'true') {
  617.                     $htMenu = $em->getRepository(HtMenu::class)->findOneByHtItem($item['idHtService']);
  618.                     $itemType = 'htMenu';
  619.                     $itemIdOrigin = $htMenu->getId();
  620.                     $itemName = $item['name'];
  621.                     $htItem = $em->getRepository(HtItem::class)->findOneById($htMenu->getHtItem());
  622.                     if (empty($xItem)){ $xItem = $htItem; }
  623.                     $dateStart = ($htItem->getDateStart())->format('Y-m-d');
  624.                     $hourEnd = ($htItem->getHourEnd())->format('Y-m-d');
  625.                     $dateTimeString = $dateStart . ' ' . $hourEnd;
  626.                     $dateEnd = new DateTimeImmutable($dateTimeString);
  627.                     $iva = $htMenu->getIva();
  628.                     switch ($iva) {
  629.                         case 10: $data_iva['ivaMontoDiez'] += ($item['subTotalPrice'] * 0.1); break;
  630.                         case 21: $data_iva['ivaMontoVeintiUno'] += ($item['subTotalPrice'] * 0.21); break;
  631.                         default: break;
  632.                     }
  633.                     $itemCommission = 0;                                                                // Solo htExtra maneja el concepto de over o comision.
  634.                     $itemOver = 0;                                                                      // Solo htExtra maneja el concepto de over o comision.
  635.                     $costeDirecto = $item['subTotalPrice'] - $item['benefit'];
  636.                     $totalNet += round($item['subTotalPrice'], 2);
  637.                     $total += round($item['subTotalPrice'], 2) + (round($item['subTotalPrice'], 2) * ($iva / 100));
  638.                     $xPax = empty($item['qty']) ? 1 : $item['qty'];
  640.                     $htInvItem = new HtInvoiceItems();
  641.                     $htInvItem->setInvoice($invoice);
  642.                     $htInvItem->setHtFile($htFile);
  643.                     $htInvItem->setItemType($itemType);
  644.                     $htInvItem->setItemIdOrigin($itemIdOrigin);
  645.                     $htInvItem->setItemName($itemName);
  646.                     $htInvItem->setItemDateStart($htItem->getDateStart());
  647.                     $htInvItem->setItemDateEnd($dateEnd);
  648.                     $htInvItem->setItemPrice(round($item['servicePrice'], 2));
  649.                     $htInvItem->setItemUnits(1);
  650.                     $htInvItem->setItemPax($xPax);
  651.                     $htInvItem->setItemKgLt(1);
  652.                     $htInvItem->setItemRank(1);
  653.                     $htInvItem->setItemLocation(0);
  654.                     $htInvItem->setItemIva($iva);
  655.                     $htInvItem->setItemOpIva(0);            // +
  656.                     $htInvItem->setItemCommission($itemCommission);
  657.                     $htInvItem->setItemOpCommission(0);
  658.                     $htInvItem->setItemOver($itemOver);
  659.                     $htInvItem->setItemOpOver(0);
  660.                     $htInvItem->setItemSubTotalPrice(round($item['subTotalPrice'], 2));
  661.                     $htInvItem->setItemCosteDirecto(round($costeDirecto, 2));
  662.                     $htInvItem->setItemBeneficio(round($item['benefit'], 2));
  664.                     $em->persist($htInvItem);
  665.                     $em->flush();
  666.                 }
  667.             }
  668.         }
  670.         // Se crean los Extras en los HtInvoiceItems
  671.         if (!empty($req_extra)) {
  672.             foreach ($req_extra as $item) {
  673.                 if($item['boolToInvoice'] == 'true') {
  674.                     $htExtra = $em->getRepository(HtExtra::class)->findOneById($item['idHtExtra']);
  675.                     if ($htExtra->isAppearInvoice()) {
  676.                         $itemType = 'htExtra';
  677.                         $itemIdOrigin = $htExtra->getId();
  678.                         $itemName = $htExtra->getConcept();
  679.                         $htItem = $em->getRepository(HtItem::class)->findOneById($htExtra->getHtItem());
  680.                         $dateStart = ($htItem->getDateStart())->format('Y-m-d');
  681.                         $hourEnd = ($htItem->getHourEnd())->format('Y-m-d');
  682.                         $dateTimeString = $dateStart . ' ' . $hourEnd;
  683.                         $dateEnd = new DateTimeImmutable($dateTimeString);
  684.                         $iva = $htExtra->getVat();
  685.                         $itemCommission = (($htExtra->isOpOverCommission() == 0) ? 0 : $htExtra->getOverCommission());
  686.                         $itemOver = (($htExtra->isOpOverCommission() == 1)  ? 0 : $htExtra->getOverCommission());
  687.                         $costeDirecto = 0;
  688.                         $benefit = $itemOver + ($item['price'] * ($itemCommission / 100));
  689.                         $totalPrice = $item['price'] + $benefit;
  690.                         switch ($iva) {
  691.                             case 10: $data_iva['ivaMontoDiez'] += ($totalPrice * 0.1); break;
  692.                             case 21: $data_iva['ivaMontoVeintiUno'] += ($totalPrice * 0.21); break;
  693.                             default: break;
  694.                         }
  695.                         $totalNet += round($totalPrice, 2);
  696.                         $total += round($totalPrice, 2) + (round($totalPrice, 2) * ($iva / 100));
  698.                         $htInvItem = new HtInvoiceItems();
  699.                         $htInvItem->setInvoice($invoice);
  700.                         $htInvItem->setHtFile($htFile);
  701.                         $htInvItem->setItemType($itemType);
  702.                         $htInvItem->setItemIdOrigin($itemIdOrigin);
  703.                         $htInvItem->setItemName($itemName);
  704.                         $htInvItem->setItemDateStart($htItem->getDateStart());
  705.                         $htInvItem->setItemDateEnd($dateEnd);
  706.                         $htInvItem->setItemPrice(round($item['price'], 2));
  707.                         $htInvItem->setItemUnits(1);
  708.                         $htInvItem->setItemPax(1);
  709.                         $htInvItem->setItemKgLt(1);
  710.                         $htInvItem->setItemRank(1);
  711.                         $htInvItem->setItemLocation(0);
  712.                         $htInvItem->setItemIva($iva);
  713.                         $htInvItem->setItemOpIva(0);            // +
  714.                         $htInvItem->setItemCommission($itemCommission);
  715.                         $htInvItem->setItemOpCommission(0);
  716.                         $htInvItem->setItemOver($itemOver);
  717.                         $htInvItem->setItemOpOver(0);
  718.                         $htInvItem->setItemSubTotalPrice(round($totalPrice, 2));
  719.                         $htInvItem->setItemCosteDirecto(round($costeDirecto, 2));
  720.                         $htInvItem->setItemBeneficio(round($benefit, 2));
  722.                         $em->persist($htInvItem);
  723.                         $em->flush();
  724.                     }
  725.                 }
  726.             }
  727.         }
  729.         $string_data_iva = '[21]'.round($data_iva['ivaMontoVeintiUno'],2).'[21]'.'[10]'.round($data_iva['ivaMontoDiez'],2).'[10]';
  731.         // Se actualiza la factura con los datos globales
  732.         $invoice->setTotalNet($totalNet);
  733.         $invoice->setVatTotalGroup($string_data_iva);
  734.         $invoice->setTotal(round($total,2));
  736.         // Comisión de HT a GreenPatio
  737.         $reserva = $em->getRepository(Reservation::class)->findOneById($htFile->getReservation());
  738.         if (!empty($reserva)){
  739.             if (!is_null($reserva->getComHtGp())) {
  740.                 $infoComissionToService = $totalNet * ($reserva->getComHtGp()/100);
  741.                 $perCom = $reserva->getComHtGp();
  742.             } else {
  743.                 // Valor por defecto de la Comision de Ht 14%
  744.                 $infoComissionToService = $totalNet * (14/100);
  745.                 $perCom = 14;
  746.             }
  748.             $xObservation = $invoice->getPrefix().$invoice->getIdNum().' - Comisión MANTE de Green Patio (Generado automaticamente) del '.$perCom . '%';
  749.             $user_logueado = $this->getUser();
  750.             $now = new \DateTimeImmutable("now");
  752. //            $newHtItem = new HtItem();
  753. //            $newHtItem->setHtFile($htFile)
  754. //                ->setDateStart($htFile->getDateStart())
  755. //                ->setGratitudes(0)
  756. //                ->setCreatedId($user_logueado)
  757. //                ->setUpdatedId($user_logueado)
  758. //                ->setCreatedAt($now)
  759. //                ->setUpdatedAt($now)
  760. //                ->setObservation($xObservation)
  761. //                ->setPax(1);
  762. //            $em->persist($newHtItem);
  763. //            $em->flush();
  765.             $newHtExtra = new HtExtra();
  766.             $newHtExtra->setHtItem($xItem)
  767.                 ->setCreatedId($user_logueado)
  768.                 ->setUpdatedId($user_logueado)
  769.                 ->setCreatedAt($now)
  770.                 ->setUpdatedAt($now)
  771.                 ->setConcept($invoice->getPrefix().$invoice->getIdNum().' - Comisión MANTE de Green Patio (Generado automaticamente)')
  772.                 ->setPrice(0)
  773.                 ->setVat(21)
  774.                 ->setAppearInvoice(0)
  775.                 ->setOverCommission($infoComissionToService)
  776.                 ->setOpOverCommission(0);
  777.             $em->persist($newHtExtra);
  778.             $em->flush();
  780. //            $htMenuExtras = $em->getRepository(HtMenu::class)->findByHtItem($newHtItem->getId());
  781. //            foreach ($htMenuExtras as $item){
  782. //                $htMenuRepository->remove($item, true);
  783. //            }
  785.             $newBenAfterCom = $invoice->getBenefit() - ($infoComissionToService * (1 + ($newHtExtra->getVat()/100)));
  786.             $invoice->setBenefit($newBenAfterCom);
  787.         }
  789.         // Se actualiza el estado del expediente a facturado
  790.         $htFile->setStatus(StatusHelper::STATUS_HT['Facturado']);
  791.         $em->persist($htFile);
  793.         $em->persist($invoice);
  794.         $em->flush();
  796.         $dataService = $this->commisionEnterpriseService->commissionHigoTrigoGreenPatio($invoice->getId(), $user_logueado->getId());
  798.         return $this->redirectToRoute('ht_view_invoice', ['id' => $invoice->getPrefix(). $invoice->getIdNum()], Response::HTTP_SEE_OTHER);
  799.     }
  802.     /**
  803.      * @Route("/viewinvoice/{id}",  name="ht_view_invoice")
  804.      * Ver la factura con el ID
  805.      */
  806.     public function showInvoiceHtAction($id, EntityManagerInterface $em, Request $request)
  807.     {
  808.         $idNum = (substr($id, 0, 1) == 'F') ? substr($id, 1) : substr($id, 2);      // F1, GP1, CV1
  809.         $prefix = (substr($id, 0, 1) == 'F') ? 'F' : substr($id, 0, 2);
  810.         $user = $this->getUser();
  811.         $parameters = array( 'idNum' => $idNum, 'prefix' => $prefix, );
  812.         $dql = 'SELECT p
  813.                 FROM App\Entity\HtInvoice p
  814.                 WHERE p.idNum = :idNum AND p.prefix = :prefix';
  815.         $query = $em->createQuery($dql)->setParameters($parameters);
  816.         $invoice = $query->getResult();
  817.         $invoice = (!empty($invoice)) ? $invoice[0] : null;
  818. //        $id = $invoice->getPrefix() . $invoice->getIdNum();
  820.         // Si no consigue la factura redirige al listado de expedientes
  821.         if (empty($invoice)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  823.         $datAt = (!empty($invoice)) ? $invoice->getDateAt() : null;
  824.         $totales_neto = (!empty($invoice)) ? $invoice->getTotalNet() : 0;
  825.         $totales_iva = (!empty($invoice)) ? $invoice->getVatTotalGroup() : 0;
  826.         $totales = (!empty($invoice)) ? $invoice->getTotal() : 0;
  827.         $htInvoiceItems = $em->getRepository(HtInvoiceItems::class)->findByInvoice($invoice);
  828.         $htFile = $em->getRepository(HtFile::class)->findOneById(($invoice->getHtFile())->getId());
  829.         $clientName = (!empty($invoice)) ? $invoice->getClientName() : 'No se pudo determinar el cliente';
  830.         $clientAddress = (!empty($invoice)) ? $invoice->getClientAddress() : 'No se pudo determinar la dirección';
  831.         $clientDocument = (!empty($invoice)) ? $invoice->getClientDocument() : 'No se pudo determinar';
  832.         $type = $invoice->getType();
  833.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  835.         $bases_imponibles = array('21'=> 0,'10'=> 0,'0'=> 0,);
  836.         $datasupplier = array(); $netoSumItems = 0; $totalSumItems = 0;
  837.         $data_iva = array('ivaMontoDiez' => 0, 'ivaMontoVeintiUno' => 0);
  838.         $datasupplier['invoice_item_net_sum'] = 0; $datasupplier['invoice_item_sum'] = 0;
  839.         $datasupplier['invoice_extra_net_sum'] = 0; $datasupplier['invoice_extra_sum'] = 0;
  841.         foreach ($htInvoiceItems as $key => $item){
  842.             if ($item->getItemType()=='htMenu') {
  843.                 $datasupplier['invoice_item'][] = array(
  844.                     'id' => $item->getId(),
  845.                     'itemName' => $item->getItemName(),
  846.                     'itemPrice' => $item->getItemPrice(),
  847.                     'itemPax' => $item->getItemPax(),
  848.                     'itemDateStart' => $item->getItemDateStart(),
  849.                     'itemDateEnd' => $item->getItemDateEnd(),
  850.                     'itemIva' => $item->getItemIva(),
  851.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  852.                 );
  853.                 $netoSumItems += $item->getItemSubTotalPrice();
  854.                 $datasupplier['invoice_item_net_sum'] += $item->getItemSubTotalPrice();
  855.                 $datasupplier['invoice_item_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  856.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  857.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  858.                 switch ($item->getItemIva()) {
  859.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  860.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  861.                     default: break;
  862.                 }
  863.             }
  865.             if ($item->getItemType()=='htExtra') {
  866.                 $datasupplier['invoice_extra'][] = array(
  867.                     'id' => $item->getId(),
  868.                     'itemType' => $item->getItemType(),
  869.                     'itemIdOrigin' => $item->getItemIdOrigin(),
  870.                     'itemName' => $item->getItemName(),
  871.                     'itemPrice' => $item->getItemSubTotalPrice(),
  872.                     'itemPax' => $item->getItemPax(),
  873.                     'itemDateStart' => $item->getItemDateStart(),
  874.                     'itemDateEnd' => $item->getItemDateEnd(),
  875.                     'itemIva' => $item->getItemIva(),
  876.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  877.                 );
  878.                 $netoSumItems += $item->getItemSubTotalPrice();
  879.                 $datasupplier['invoice_extra_net_sum'] += $item->getItemSubTotalPrice();
  880.                 $datasupplier['invoice_extra_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  881.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  882.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  883.                 switch ($item->getItemIva()) {
  884.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  885.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  886.                     default: break;
  887.                 }
  888.             }
  889.         }
  890.         $allInvoices = $em->getRepository(HtInvoice::class)->findByHtFile($htFile);
  891.         $invoiceRec = $em->getRepository(HtInvoice::class)->findByInvoiceToRec($id);
  892.         $boolToRec = ($invoice->getType() == 'Invoice Rec') ? false : empty($invoiceRec);
  894.         return $this->render('higotrigo/ht_invoice/show-invoice.html.twig',
  895.             array(
  896.                 'id' => $htFile->getId(),
  897.                 'cid' => '',
  898.                 'fid' => $id,
  899.                 'invoice' => $invoice,
  900.                 'allInvoices' => $allInvoices,
  901.                 'proformas' => null,
  902.                 'numberadmin' => '',
  903.                 'type' => $type,
  904.                 'number' => $id,
  905.                 'prefix' => $prefix,
  906.                 'date' => $datAt,
  907.                 'reservation' => $htFile,
  908.                 'company' => $company,
  909.                 'user' => $user,
  910.                 'boolToRec' => $boolToRec,
  911.                 'invoicedeposititems' => '',
  912.                 'datasupplier' => $datasupplier,
  913.                 'totales_neto' => $netoSumItems,
  914.                 'totales_iva' => $totales_iva,
  915.                 'totales' => $totalSumItems,
  916.                 'bases_imponibles' => $data_iva,
  917.                 'paymentInvoice' => null,
  918.                 'currency' => '€',
  919.                 'clientName' => $clientName,
  920.                 'clientAddress' => $clientAddress,
  921.                 'clientDocument' => $clientDocument,
  922.             )
  923.         );
  924.     }
  927.     /**
  928.      * @Route("/viewinvoicerec/{id}",  name="ht_view_invoice_rec")
  929.      * Ver la factura rectificativa con el ID
  930.      */
  931.     public function showInvoiceRecHtAction($id, EntityManagerInterface $em, Request $request)
  932.     {
  933.         $idNum = (substr($id, 0, 2) == 'RF') ? substr($id, 2) : substr($id, 3);      // RF1, RGP1, RCV1
  934.         $prefix = (substr($id, 0, 2) == 'RF') ? 'RF' : substr($id, 0, 3);
  936.         $user = $this->getUser();
  937.         $parameters = array( 'idNum' => $idNum, 'prefix' => $prefix, );
  938.         $dql = 'SELECT p
  939.                 FROM App\Entity\HtInvoice p
  940.                 WHERE p.idNum = :idNum AND p.prefix = :prefix';
  941.         $query = $em->createQuery($dql)->setParameters($parameters);
  942.         $invoice = $query->getResult();
  943.         $invoice = (!empty($invoice)) ? $invoice[0] : null;
  945.         // Si no consigue la factura redirige al listado de expedientes
  946.         if (empty($invoice)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  948.         $datAt = (!empty($invoice)) ? $invoice->getDateAt() : null;
  949.         $totales_neto = (!empty($invoice)) ? $invoice->getTotalNet() : 0;
  950.         $totales_iva = (!empty($invoice)) ? $invoice->getVatTotalGroup() : 0;
  951.         $totales = (!empty($invoice)) ? $invoice->getTotal() : 0;
  952.         $htInvoiceItems = $em->getRepository(HtInvoiceItems::class)->findByInvoice($invoice);
  953.         $htFile = $em->getRepository(HtFile::class)->findOneById(($invoice->getHtFile())->getId());
  954.         $clientName = (!empty($invoice)) ? $invoice->getClientName() : 'No se pudo determinar el cliente';
  955.         $clientAddress = (!empty($invoice)) ? $invoice->getClientAddress() : 'No se pudo determinar la dirección';
  956.         $clientDocument = (!empty($invoice)) ? $invoice->getClientDocument() : 'No se pudo determinar';
  957.         $type = $invoice->getType();
  958.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  960.         $bases_imponibles = array('21'=> 0,'10'=> 0,'0'=> 0,);
  961.         $datasupplier = array(); $netoSumItems = 0; $totalSumItems = 0;
  962.         $data_iva = array('ivaMontoDiez' => 0, 'ivaMontoVeintiUno' => 0);
  963.         $datasupplier['invoice_item_net_sum'] = 0; $datasupplier['invoice_item_sum'] = 0;
  964.         $datasupplier['invoice_extra_net_sum'] = 0; $datasupplier['invoice_extra_sum'] = 0;
  966.         foreach ($htInvoiceItems as $key => $item){
  967.             if ($item->getItemType()=='htMenu') {
  968.                 $datasupplier['invoice_item'][] = $item;
  969.                 $netoSumItems += $item->getItemSubTotalPrice();
  970.                 $datasupplier['invoice_item_net_sum'] += $item->getItemSubTotalPrice();
  971.                 $datasupplier['invoice_item_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  972.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  973.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  974.                 switch ($item->getItemIva()) {
  975.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  976.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  977.                     default: break;
  978.                 }
  979.             }
  981.             if ($item->getItemType()=='htExtra') {
  982. //                $datasupplier['invoice_extra'][] = $item;
  983.                 $datasupplier['invoice_extra'][] = array(
  984.                     'id' => $item->getId(),
  985.                     'itemType' => $item->getItemType(),
  986.                     'itemIdOrigin' => $item->getItemIdOrigin(),
  987.                     'itemName' => $item->getItemName(),
  988.                     'itemPrice' => $item->getItemSubTotalPrice(),
  989.                     'itemPax' => $item->getItemPax(),
  990.                     'itemDateStart' => $item->getItemDateStart(),
  991.                     'itemDateEnd' => $item->getItemDateEnd(),
  992.                     'itemIva' => $item->getItemIva(),
  993.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  994.                 );
  996.                 $netoSumItems += $item->getItemSubTotalPrice();
  997.                 $datasupplier['invoice_extra_net_sum'] += $item->getItemSubTotalPrice();
  998.                 $datasupplier['invoice_extra_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  999.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1000.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1001.                 switch ($item->getItemIva()) {
  1002.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1003.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1004.                     default: break;
  1005.                 }
  1006.             }
  1007.         }
  1008.         $allInvoices = $em->getRepository(HtInvoice::class)->findByHtFile($htFile);
  1010.         return $this->render('higotrigo/ht_invoice/show-invoice.html.twig',
  1011.             array(
  1012.                 'id' => $htFile->getId(),
  1013.                 'cid' => '',
  1014.                 'fid' => $id,
  1015.                 'invoice' => $invoice,
  1016.                 'invoiceIdToRec' => $invoice->getInvoiceToRec(),
  1017.                 'allInvoices' => $allInvoices,
  1018.                 'proformas' => null,
  1019.                 'boolToRec' => false,
  1020.                 'numberadmin' => '',
  1021.                 'type' => $type,
  1022.                 'number' => $id,
  1023.                 'prefix' => $prefix,
  1024.                 'date' => $datAt,
  1025.                 'reservation' => $htFile,
  1026.                 'company' => $company,
  1027.                 'user' => $user,
  1028.                 'invoicedeposititems' => '',
  1029.                 'datasupplier' => $datasupplier,
  1030.                 'totales_neto' => $netoSumItems,
  1031.                 'totales_iva' => $totales_iva,
  1032.                 'totales' => $totalSumItems,
  1033.                 'bases_imponibles' => $data_iva,
  1034.                 'paymentInvoice' => null,
  1035.                 'currency' => '€',
  1036.                 'clientName' => $clientName,
  1037.                 'clientAddress' => $clientAddress,
  1038.                 'clientDocument' => $clientDocument,
  1039.             )
  1040.         );
  1041.     }
  1044.     /**
  1045.      * @Route("/htexternal/viewprintinvoice/{id}",  name="ht_view_print_invoice")
  1046.      * Ver la factura con el ID en modalidad de impresion
  1047.      */
  1048.     public function printInvoiceHtAction($id, EntityManagerInterface $em, Request $request)
  1049.     {
  1050.         $idNum = (substr($id, 0, 1) == 'F') ? substr($id, 1) : substr($id, 2);      // F1, GP1, CV1
  1051.         $prefix = (substr($id, 0, 1) == 'F') ? 'F' : substr($id, 0, 2);
  1052.         $user = $this->getUser();
  1053.         $parameters = array( 'idNum' => $idNum, 'prefix' => $prefix, );
  1054.         $dql = 'SELECT p
  1055.                 FROM App\Entity\HtInvoice p
  1056.                 WHERE p.idNum = :idNum AND p.prefix = :prefix';
  1057.         $query = $em->createQuery($dql)->setParameters($parameters);
  1058.         $invoice = $query->getResult();
  1059.         $invoice = (!empty($invoice)) ? $invoice[0] : null;
  1061.         // Si no consigue la factura redirige al listado de expedientes
  1062.         if (empty($invoice)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  1064.         $datAt = (!empty($invoice)) ? $invoice->getDateAt() : null;
  1065.         $totales_neto = (!empty($invoice)) ? $invoice->getTotalNet() : 0;
  1066.         $totales_iva = (!empty($invoice)) ? $invoice->getVatTotalGroup() : 0;
  1067.         $totales = (!empty($invoice)) ? $invoice->getTotal() : 0;
  1068.         $htInvoiceItems = $em->getRepository(HtInvoiceItems::class)->findByInvoice($invoice);
  1069.         $htFile = $em->getRepository(HtFile::class)->findOneById(($invoice->getHtFile())->getId());
  1070.         $clientName = (!empty($invoice)) ? $invoice->getClientName() : 'No se pudo determinar el cliente';
  1071.         $clientAddress = (!empty($invoice)) ? $invoice->getClientAddress() : 'No se pudo determinar la dirección';
  1072.         $clientDocument = (!empty($invoice)) ? $invoice->getClientDocument() : 'No se pudo determinar';
  1073.         $type = $invoice->getType();
  1074.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  1076.         $bases_imponibles = array('21'=> 0,'10'=> 0,'0'=> 0,);
  1077.         $datasupplier = array(); $netoSumItems = 0; $totalSumItems = 0;
  1078.         $data_iva = array('ivaMontoDiez' => 0, 'ivaMontoVeintiUno' => 0);
  1079.         $datasupplier['invoice_item_net_sum'] = 0; $datasupplier['invoice_item_sum'] = 0;
  1080.         $datasupplier['invoice_extra_net_sum'] = 0; $datasupplier['invoice_extra_sum'] = 0;
  1082.         foreach ($htInvoiceItems as $key => $item){
  1083.             if ($item->getItemType()=='htMenu') {
  1084.                 $datasupplier['invoice_item'][] = array(
  1085.                     'id' => $item->getId(),
  1086.                     'itemName' => $item->getItemName(),
  1087.                     'itemPrice' => $item->getItemPrice(),
  1088.                     'itemPax' => $item->getItemPax(),
  1089.                     'itemDateStart' => $item->getItemDateStart(),
  1090.                     'itemDateEnd' => $item->getItemDateEnd(),
  1091.                     'itemIva' => $item->getItemIva(),
  1092.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1093.                 );
  1094.                 $netoSumItems += $item->getItemSubTotalPrice();
  1095.                 $datasupplier['invoice_item_net_sum'] += $item->getItemSubTotalPrice();
  1096.                 $datasupplier['invoice_item_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1097.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1098.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1099.                 switch ($item->getItemIva()) {
  1100.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1101.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1102.                     default: break;
  1103.                 }
  1104.             }
  1106.             if ($item->getItemType()=='htExtra') {
  1107. //                $datasupplier['invoice_extra'][] = $item;
  1108.                 $datasupplier['invoice_extra'][] = array(
  1109.                     'id' => $item->getId(),
  1110.                     'itemType' => $item->getItemType(),
  1111.                     'itemIdOrigin' => $item->getItemIdOrigin(),
  1112.                     'itemName' => $item->getItemName(),
  1113.                     'itemPrice' => $item->getItemSubTotalPrice(),
  1114.                     'itemPax' => $item->getItemPax(),
  1115.                     'itemDateStart' => $item->getItemDateStart(),
  1116.                     'itemDateEnd' => $item->getItemDateEnd(),
  1117.                     'itemIva' => $item->getItemIva(),
  1118.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1119.                 );
  1120.                 $netoSumItems += $item->getItemSubTotalPrice();
  1121.                 $datasupplier['invoice_extra_net_sum'] += $item->getItemSubTotalPrice();
  1122.                 $datasupplier['invoice_extra_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1123.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1124.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1125.                 switch ($item->getItemIva()) {
  1126.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1127.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1128.                     default: break;
  1129.                 }
  1130.             }
  1131.         }
  1133.         return $this->render('higotrigo/ht_invoice/invoice-print.html.twig',
  1134.             array(
  1135.                 'id' => $htFile->getId(),
  1136.                 'cid' => '',
  1137.                 'fid' => $id,
  1138.                 'invoice' => $invoice,
  1139.                 'proformas' => null,
  1140.                 'boolToRec' => true,
  1141.                 'numberadmin' => '',
  1142.                 'type' => $type,
  1143.                 'number' => $id,
  1144.                 'prefix' => $prefix,
  1145.                 'date' => $datAt,
  1146.                 'reservation' => $htFile,
  1147.                 'company' => $company,
  1148.                 'user' => $user,
  1149.                 'invoicedeposititems' => '',
  1150.                 'datasupplier' => $datasupplier,
  1151.                 'totales_neto' => $netoSumItems,
  1152.                 'totales_iva' => $totales_iva,
  1153.                 'totales' => $totalSumItems,
  1154.                 'bases_imponibles' => $data_iva,
  1155.                 'paymentInvoice' => null,
  1156.                 'currency' => '€',
  1157.                 'clientName' => $clientName,
  1158.                 'clientAddress' => $clientAddress,
  1159.                 'clientDocument' => $clientDocument,
  1160.             )
  1161.         );
  1162.     }
  1165.     /**
  1166.      * @Route("/htexternal/viewprintinvoicerec/{id}", name="ht_view_print_invoicerec")
  1167.      * Ver la factura rectificativa con el ID en modalidad de impresion
  1168.      */
  1169.     public function printInvoiceRecHtAction($id, EntityManagerInterface $em, Request $request)
  1170.     {
  1171.         $idNum = (substr($id, 0, 2) == 'RF') ? substr($id, 2) : substr($id, 3);      // RF1, RGP1, RCV1
  1172.         $prefix = (substr($id, 0, 2) == 'RF') ? 'RF' : substr($id, 0, 3);
  1174.         $user = $this->getUser();
  1175.         $parameters = array( 'idNum' => $idNum, 'prefix' => $prefix, );
  1176.         $dql = 'SELECT p
  1177.                 FROM App\Entity\HtInvoice p
  1178.                 WHERE p.idNum = :idNum AND p.prefix = :prefix';
  1179.         $query = $em->createQuery($dql)->setParameters($parameters);
  1180.         $invoice = $query->getResult();
  1181.         $invoice = (!empty($invoice)) ? $invoice[0] : null;
  1183.         // Si no consigue la factura redirige al listado de expedientes
  1184.         if (empty($invoice)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  1186.         $datAt = (!empty($invoice)) ? $invoice->getDateAt() : null;
  1187.         $totales_neto = (!empty($invoice)) ? $invoice->getTotalNet() : 0;
  1188.         $totales_iva = (!empty($invoice)) ? $invoice->getVatTotalGroup() : 0;
  1189.         $totales = (!empty($invoice)) ? $invoice->getTotal() : 0;
  1190.         $htInvoiceItems = $em->getRepository(HtInvoiceItems::class)->findByInvoice($invoice);
  1191.         $htFile = $em->getRepository(HtFile::class)->findOneById(($invoice->getHtFile())->getId());
  1192.         $clientName = (!empty($invoice)) ? $invoice->getClientName() : 'No se pudo determinar el cliente';
  1193.         $clientAddress = (!empty($invoice)) ? $invoice->getClientAddress() : 'No se pudo determinar la dirección';
  1194.         $clientDocument = (!empty($invoice)) ? $invoice->getClientDocument() : 'No se pudo determinar';
  1195.         $type = $invoice->getType();
  1196.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  1197.         $invoiceIdToRec = $invoice->getInvoiceToRec();
  1199.         $bases_imponibles = array('21'=> 0,'10'=> 0,'0'=> 0,);
  1200.         $datasupplier = array(); $netoSumItems = 0; $totalSumItems = 0;
  1201.         $data_iva = array('ivaMontoDiez' => 0, 'ivaMontoVeintiUno' => 0);
  1202.         $datasupplier['invoice_item_net_sum'] = 0; $datasupplier['invoice_item_sum'] = 0;
  1203.         $datasupplier['invoice_extra_net_sum'] = 0; $datasupplier['invoice_extra_sum'] = 0;
  1205.         foreach ($htInvoiceItems as $key => $item){
  1206.             if ($item->getItemType()=='htMenu') {
  1207.                 $datasupplier['invoice_item'][] = array(
  1208.                     'id' => $item->getId(),
  1209.                     'itemName' => $item->getItemName(),
  1210.                     'itemPrice' => $item->getItemPrice(),
  1211.                     'itemPax' => $item->getItemPax(),
  1212.                     'itemDateStart' => $item->getItemDateStart(),
  1213.                     'itemDateEnd' => $item->getItemDateEnd(),
  1214.                     'itemIva' => $item->getItemIva(),
  1215.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1216.                 );
  1217.                 $netoSumItems += $item->getItemSubTotalPrice();
  1218.                 $datasupplier['invoice_item_net_sum'] += $item->getItemSubTotalPrice();
  1219.                 $datasupplier['invoice_item_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1220.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1221.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1222.                 switch ($item->getItemIva()) {
  1223.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1224.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1225.                     default: break;
  1226.                 }
  1227.             }
  1229.             if ($item->getItemType()=='htExtra') {
  1230. //                $datasupplier['invoice_extra'][] = $item;
  1231.                 $datasupplier['invoice_extra'][] = array(
  1232.                     'id' => $item->getId(),
  1233.                     'itemType' => $item->getItemType(),
  1234.                     'itemIdOrigin' => $item->getItemIdOrigin(),
  1235.                     'itemName' => $item->getItemName(),
  1236.                     'itemPrice' => $item->getItemSubTotalPrice(),
  1237.                     'itemPax' => $item->getItemPax(),
  1238.                     'itemDateStart' => $item->getItemDateStart(),
  1239.                     'itemDateEnd' => $item->getItemDateEnd(),
  1240.                     'itemIva' => $item->getItemIva(),
  1241.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1242.                 );
  1243.                 $netoSumItems += $item->getItemSubTotalPrice();
  1244.                 $datasupplier['invoice_extra_net_sum'] += $item->getItemSubTotalPrice();
  1245.                 $datasupplier['invoice_extra_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1246.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1247.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1248.                 switch ($item->getItemIva()) {
  1249.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1250.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1251.                     default: break;
  1252.                 }
  1253.             }
  1254.         }
  1256.         return $this->render('higotrigo/ht_invoice/invoice-print.html.twig',
  1257.             array(
  1258.                 'id' => $htFile->getId(),
  1259.                 'cid' => '',
  1260.                 'fid' => $id,
  1261.                 'invoice' => $invoice,
  1262.                 'proformas' => null,
  1263.                 'boolToRec' => true,
  1264.                 'numberadmin' => '',
  1265.                 'type' => $type,
  1266.                 'number' => $id,
  1267.                 'prefix' => $prefix,
  1268.                 'date' => $datAt,
  1269.                 'reservation' => $htFile,
  1270.                 'company' => $company,
  1271.                 'user' => $user,
  1272.                 'invoicedeposititems' => '',
  1273.                 'datasupplier' => $datasupplier,
  1274.                 'totales_neto' => $netoSumItems,
  1275.                 'totales_iva' => $totales_iva,
  1276.                 'totales' => $totalSumItems,
  1277.                 'bases_imponibles' => $data_iva,
  1278.                 'paymentInvoice' => null,
  1279.                 'currency' => '€',
  1280.                 'clientName' => $clientName,
  1281.                 'clientAddress' => $clientAddress,
  1282.                 'clientDocument' => $clientDocument,
  1283.                 'invoiceIdToRec' => $invoiceIdToRec,
  1284.             )
  1285.         );
  1286.     }
  1290.     /**
  1291.      * @Route("/createrecinvoice/{id}",  name="ht_create_rec_invoice")
  1292.      * Generar factura rectificativa de la factura ID
  1293.      */
  1294.     public function createRecInvoiceHtAction($id, EntityManagerInterface $em, Request $request)
  1295.     {
  1296.         $idNum = (substr($id, 0, 1) == 'F') ? substr($id, 1) : substr($id, 2);      // F1, GP1, CV1, BL1
  1297.         $prefix = (substr($id, 0, 1) == 'F') ? 'F' : substr($id, 0, 2);
  1298.         $parameters = array( 'idNum' => $idNum, 'prefix' => $prefix, );
  1299.         $dql = 'SELECT p
  1300.                 FROM App\Entity\HtInvoice p
  1301.                 WHERE p.idNum = :idNum AND p.prefix = :prefix';
  1302.         $query = $em->createQuery($dql)->setParameters($parameters);
  1303.         $invoice = $query->getResult();
  1304.         $invoice = (!empty($invoice)) ? $invoice[0] : null;
  1306.         // Si no consigue la factura redirige al listado de expedientes
  1307.         if (empty($invoice)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  1309.         // Buscamos el ID para la nueva rectificativa
  1310.         $parameters = array( 'prefix' => 'R'.$prefix, );
  1311.         $dql = 'SELECT p
  1312.                 FROM App\Entity\HtInvoice p
  1313.                 WHERE p.prefix = :prefix';
  1314.         $query = $em->createQuery($dql)->setParameters($parameters);
  1315.         $invoiceRec = $query->getResult();
  1316.         $invoiceRec = (!empty($invoiceRec)) ? end($invoiceRec) : null;
  1318.         $idNewRec = empty($invoiceRec) ? 1 : ($invoiceRec->getIdNum() + 1) ;
  1319.         $dateAt = new DateTimeImmutable('now');
  1320.         $invoiceItems = $em->getRepository(HtInvoiceItems::class)->findByInvoice($invoice);
  1322.         // Creamos la factura rectificativa
  1323.         $oldIvas = $invoice->getVatTotalGroup();
  1324.         $newIvas = $this->transformarString($oldIvas);
  1326.         $invoiceRec = new HtInvoice();
  1327.         $invoiceRec->setIdNum($idNewRec);
  1328.         $invoiceRec->setPrefix('R'. $prefix);
  1329.         $invoiceRec->setDateAt($dateAt);
  1330.         $invoiceRec->setType('Invoice Rec');
  1331.         $invoiceRec->setClientName($invoice->getClientName());
  1332.         $invoiceRec->setClientAddress($invoice->getClientAddress());
  1333.         $invoiceRec->setClientDocument($invoice->getClientDocument());
  1334.         $invoiceRec->setClientType($invoice->getClientType());
  1335.         $invoiceRec->setHtFile($invoice->getHtFile());
  1336.         $invoiceRec->setBenefit((-1) * $invoice->getBenefit());
  1337.         $invoiceRec->setTotalNet((-1) * $invoice->getTotalNet());
  1338.         $invoiceRec->setVatTotalGroup($newIvas);
  1339.         $invoiceRec->setTotal((-1) * $invoice->getTotal());
  1340.         $invoiceRec->setInvoiceToRec($id);
  1342.         $em->persist($invoiceRec);
  1343.         $em->flush();
  1345.         // Creamos los Items de la factura rectificativa
  1346.         foreach ($invoiceItems as $item){
  1347.             $htInvItem = new HtInvoiceItems();
  1348.             $htInvItem->setInvoice($invoiceRec);
  1349.             $htInvItem->setHtFile($item->getHtFile());
  1350.             $htInvItem->setItemType($item->getItemType());
  1351.             $htInvItem->setItemIdOrigin($item->getItemIdOrigin());
  1352.             $htInvItem->setItemName($item->getItemName());
  1353.             $htInvItem->setItemDateStart($item->getItemDateStart());
  1354.             $htInvItem->setItemDateEnd($item->getItemDateEnd());
  1355.             $htInvItem->setItemPrice((-1) * $item->getItemPrice());
  1356.             $htInvItem->setItemUnits($item->getItemUnits());
  1357.             $htInvItem->setItemPax($item->getItemPax());
  1358.             $htInvItem->setItemKgLt($item->getItemKgLt());
  1359.             $htInvItem->setItemRank($item->getItemRank());
  1360.             $htInvItem->setItemLocation($item->getItemLocation());
  1361.             $htInvItem->setItemIva($item->getItemIva());
  1362.             $htInvItem->setItemOpIva($item->isItemOpIva());
  1363.             $htInvItem->setItemCommission((-1) * $item->getItemCommission());
  1364.             $htInvItem->setItemOpCommission($item->isItemOpCommission());
  1365.             $htInvItem->setItemOver((-1) * $item->getItemOver());
  1366.             $htInvItem->setItemOpOver($item->isItemOpOver());
  1367.             $htInvItem->setItemSubTotalPrice((-1) * $item->getItemSubTotalPrice());
  1368.             $htInvItem->setItemCosteDirecto((-1) * $item->getItemCosteDirecto());
  1369.             $htInvItem->setItemBeneficio((-1) * $item->getItemBeneficio());
  1371.             $em->persist($htInvItem);
  1372.             $em->flush();
  1373.         }
  1375.         $user_logueado = $this->getUser();
  1376.         $dataService = $this->commisionEnterpriseService->rectCommissionHigoTrigoGreenPatio($invoice->getPrefix(), $invoice->getIdNum(), $user_logueado->getId());
  1378.         return $this->redirectToRoute('ht_view_invoice_rec', ['id' => $invoiceRec->getPrefix(). $invoiceRec->getIdNum()], Response::HTTP_SEE_OTHER);
  1379.     }
  1382.     /**
  1383.      * @Route("/createproforma/{id}",  name="ht_create_proforma")
  1384.      * Generar proforma en el expediente ID
  1385.      */
  1386.     public function createProformaHtAction($id, EntityManagerInterface $em, Request $request)
  1387.     {
  1388.         $req = $request->request->get('invoiced_item');
  1389.         $clientName = $request->request->get('clientName');
  1390.         $req_extra = $request->request->get('invoiced_extra');
  1391.         $htFile = $em->getRepository(HtFile::class)->findOneById($id);
  1392.         $beneficio_total = 0;
  1393.         foreach ($req as $itemServ){
  1394.             foreach ($itemServ as $item) {
  1395.                 if ($item['boolToInvoice'] == 'true') {
  1396.                     $beneficio_total += $item['benefit'];
  1397.                 }
  1398.             }
  1399.         }
  1401.         // Se genera la proforma
  1402.         // buscamos por el prefijo de cada linea de facturacion para saber el ultimo ID
  1403.         $invoiceLineGp = $em->getRepository(HtInvoice::class)->findByPrefix('GP');
  1404.         $invoiceLineCvr = $em->getRepository(HtInvoice::class)->findByPrefix('CV');
  1405.         $invoiceLineOther = $em->getRepository(HtInvoice::class)->findByPrefix('F');
  1406.         $lastGp = end($invoiceLineGp);
  1407.         $lastCvr = end($invoiceLineCvr);
  1408.         $lastOther = end($invoiceLineOther);
  1410.         // Buscamos los HtIemts del HtFile para saber la sala del servicio para determinar la línea de facturación ($prefix)
  1411.         $htItems = $em->getRepository(HtItem::class)->findByHtFile($htFile);
  1412.         $lounge = $htItems[0]->getLoungeGp();
  1413.         $prefix = (empty($lounge) ? 'F' : (($lounge->getId() < 22) ? 'GP' : 'CV'));
  1415.         switch ($prefix) {
  1416.             case 'F': $idNum = (empty($lastOther)) ? 1 : $lastOther->getIdNum() + 1; break;
  1417.             case 'CV': $idNum = (empty($lastCvr)) ? 1 : $lastCvr->getIdNum() + 1; break;
  1418.             default:
  1419.                 // Por defecto Green Patio.
  1420.                 // Esteban Rincon comenta que en caso de un expediente tener salas de GP y CVR deberiamos tener un expediente por linea de facturación
  1421.                 $idNum = (empty($lastGp)) ? 1 : $lastGp->getIdNum() + 1;
  1422.                 break;
  1423.         }
  1425.         $client = (empty($htFile->getClient())) ? null : $htFile->getClient();
  1426.         // Si no hay cliente no se puede facturar, se vuelve a la pantalla de seleccion
  1427.         if (empty($client)){ return $this->redirectToRoute('ht_select_invoice', ['id' => $htFile->getId()], Response::HTTP_SEE_OTHER); }
  1429.         $dateAt = new DateTimeImmutable('now');
  1430.         $type = 'Proforma';
  1431.         $totalNet = 0; $vatTotalGroup = 0; $total = 0;
  1432.         if (empty($clientName)){ $clientName = $client->getName(); }
  1433.         $clientAddress = $request->request->get('clientAddress');
  1434.         $clientDocument = $request->request->get('clientDocument');
  1435.         if (empty($clientDocument)){ $clientDocument = empty($client->getIdDocument()) ? ' ' : $client->getIdDocument(); }
  1436.         $clientType = $request->request->get('clientType');
  1437.         if ($clientType == 'supplier'){
  1438.             $type = 'Proforma de Factura de Comision';
  1439.             $clientName = $request->request->get('clientName');
  1440.             $clientDocument = $request->request->get('clientDocument');
  1441.         }
  1443.         $proforma = new HtProforma();
  1444.         $proforma->setIdNum($idNum);
  1445.         $proforma->setPrefix($prefix);
  1446.         $proforma->setDateAt($dateAt);
  1447.         $proforma->setType($type);
  1448.         $proforma->setTotalNet($totalNet);
  1449.         $proforma->setVatTotalGroup($vatTotalGroup);
  1450.         $proforma->setTotal($total);
  1451.         $proforma->setClientName($clientName);
  1452.         $proforma->setClientAddress($clientAddress);
  1453.         $proforma->setClientDocument($clientDocument);
  1454.         $proforma->setClientType($clientType);
  1455.         $proforma->setHtFile($htFile->getId());
  1456.         $proforma->setBenefit($beneficio_total);
  1458.         $em->persist($proforma);
  1459.         $em->flush();
  1461.         $data_iva = array(); $data_iva['ivaMontoVeintiUno'] = 0; $data_iva['ivaMontoDiez'] = 0;
  1463.         // Se crean los Menus en los HtInvoiceItems
  1464.         foreach ($req as $itemServ){
  1465.             foreach ($itemServ as $item) {
  1466.                 if ($item['boolToInvoice'] == 'true') {
  1467.                     $htMenu = $em->getRepository(HtMenu::class)->findOneByHtItem($item['idHtService']);
  1468.                     $itemType = 'htMenu';
  1469.                     $itemIdOrigin = $htMenu->getId();
  1470.                     $itemName = $item['name'];
  1471.                     $htItem = $em->getRepository(HtItem::class)->findOneById($htMenu->getHtItem());
  1472.                     $dateStart = ($htItem->getDateStart())->format('Y-m-d');
  1473.                     $hourEnd = ($htItem->getHourEnd())->format('Y-m-d');
  1474.                     $dateTimeString = $dateStart . ' ' . $hourEnd;
  1475.                     $dateEnd = new DateTimeImmutable($dateTimeString);
  1476.                     $iva = $htMenu->getIva();
  1477.                     switch ($iva) {
  1478.                         case 10: $data_iva['ivaMontoDiez'] += ($item['subTotalPrice'] * 0.1); break;
  1479.                         case 21: $data_iva['ivaMontoVeintiUno'] += ($item['subTotalPrice'] * 0.21); break;
  1480.                         default: break;
  1481.                     }
  1482.                     $itemCommission = 0;                                                                // Solo htExtra maneja el concepto de over o comision.
  1483.                     $itemOver = 0;                                                                      // Solo htExtra maneja el concepto de over o comision.
  1484.                     $costeDirecto = $item['subTotalPrice'] - $item['benefit'];
  1485.                     $totalNet += round($item['subTotalPrice'], 2);
  1486.                     $total += round($item['subTotalPrice'], 2) + (round($item['subTotalPrice'], 2) * ($iva / 100));
  1488.                     $htInvItem = new HtProformaItems();
  1489.                     $htInvItem->setProforma($proforma);
  1490.                     $htInvItem->setHtFile($htFile->getId());
  1491.                     $htInvItem->setItemType($itemType);
  1492.                     $htInvItem->setItemIdOrigin($itemIdOrigin);
  1493.                     $htInvItem->setItemName($itemName);
  1494.                     $htInvItem->setItemDateStart($htItem->getDateStart());
  1495.                     $htInvItem->setItemDateEnd($dateEnd);
  1496.                     $htInvItem->setItemPrice(round($item['servicePrice'], 2));
  1497.                     $htInvItem->setItemUnits(1);
  1498.                     $htInvItem->setItemPax($item['qty']);
  1499.                     $htInvItem->setItemKgLt(1);
  1500.                     $htInvItem->setItemRank(1);
  1501.                     $htInvItem->setItemLocation(0);
  1502.                     $htInvItem->setItemIva($iva);
  1503.                     $htInvItem->setItemOpIva(0);            // +
  1504.                     $htInvItem->setItemCommission($itemCommission);
  1505.                     $htInvItem->setItemOpCommission(0);
  1506.                     $htInvItem->setItemOver($itemOver);
  1507.                     $htInvItem->setItemOpOver(0);
  1508.                     $htInvItem->setItemSubTotalPrice(round($item['subTotalPrice'], 2));
  1509.                     $htInvItem->setItemCosteDirecto(round($costeDirecto, 2));
  1510.                     $htInvItem->setItemBeneficio(round($item['benefit'], 2));
  1512.                     $em->persist($htInvItem);
  1513.                     $em->flush();
  1514.                 }
  1515.             }
  1516.         }
  1518.         // Se crean los Extras en los HtInvoiceItems
  1519.         if (!empty($req_extra)) {
  1520.             foreach ($req_extra as $item) {
  1521.                 if($item['boolToInvoice'] == 'true') {
  1522.                     $htExtra = $em->getRepository(HtExtra::class)->findOneById($item['idHtExtra']);
  1523.                     if ($htExtra->isAppearInvoice()) {
  1524.                         $itemType = 'htExtra';
  1525.                         $itemIdOrigin = $htExtra->getId();
  1526.                         $itemName = $htExtra->getConcept();
  1527.                         $htItem = $em->getRepository(HtItem::class)->findOneById($htExtra->getHtItem());
  1528.                         $dateStart = ($htItem->getDateStart())->format('Y-m-d');
  1529.                         $hourEnd = ($htItem->getHourEnd())->format('Y-m-d');
  1530.                         $dateTimeString = $dateStart . ' ' . $hourEnd;
  1531.                         $dateEnd = new DateTimeImmutable($dateTimeString);
  1532.                         $iva = $htExtra->getVat();
  1533.                         $itemCommission = (($htExtra->isOpOverCommission() == 0) ? 0 : $htExtra->getOverCommission());
  1534.                         $itemOver = (($htExtra->isOpOverCommission() == 1)  ? 0 : $htExtra->getOverCommission());
  1535.                         $costeDirecto = 0;
  1536.                         $benefit = $itemOver + ($item['price'] * ($itemCommission / 100));
  1537.                         $totalPrice = $item['price'] + $benefit;
  1538.                         switch ($iva) {
  1539.                             case 10: $data_iva['ivaMontoDiez'] += ($totalPrice * 0.1); break;
  1540.                             case 21: $data_iva['ivaMontoVeintiUno'] += ($totalPrice * 0.21); break;
  1541.                             default: break;
  1542.                         }
  1543.                         $totalNet += round($totalPrice, 2);
  1544.                         $total += round($totalPrice, 2) + (round($totalPrice, 2) * ($iva / 100));
  1546.                         $htInvItem = new HtProformaItems();
  1547.                         $htInvItem->setProforma($proforma);
  1548.                         $htInvItem->setHtFile($htFile->getId());
  1549.                         $htInvItem->setItemType($itemType);
  1550.                         $htInvItem->setItemIdOrigin($itemIdOrigin);
  1551.                         $htInvItem->setItemName($itemName);
  1552.                         $htInvItem->setItemDateStart($htItem->getDateStart());
  1553.                         $htInvItem->setItemDateEnd($dateEnd);
  1554.                         $htInvItem->setItemPrice(round($item['price'], 2));
  1555.                         $htInvItem->setItemUnits(1);
  1556.                         $htInvItem->setItemPax(1);
  1557.                         $htInvItem->setItemKgLt(1);
  1558.                         $htInvItem->setItemRank(1);
  1559.                         $htInvItem->setItemLocation(0);
  1560.                         $htInvItem->setItemIva($iva);
  1561.                         $htInvItem->setItemOpIva(0);            // +
  1562.                         $htInvItem->setItemCommission($itemCommission);
  1563.                         $htInvItem->setItemOpCommission(0);
  1564.                         $htInvItem->setItemOver($itemOver);
  1565.                         $htInvItem->setItemOpOver(0);
  1566.                         $htInvItem->setItemSubTotalPrice(round($totalPrice, 2));
  1567.                         $htInvItem->setItemCosteDirecto(round($costeDirecto, 2));
  1568.                         $htInvItem->setItemBeneficio(round($benefit, 2));
  1570.                         $em->persist($htInvItem);
  1571.                         $em->flush();
  1572.                     }
  1573.                 }
  1574.             }
  1575.         }
  1577.         $string_data_iva = '[21]'.round($data_iva['ivaMontoVeintiUno'],2).'[21]'.'[10]'.round($data_iva['ivaMontoDiez'],2).'[10]';
  1579.         // Se actualiza la factura con los datos globales
  1580.         $proforma->setTotalNet($totalNet);
  1581.         $proforma->setVatTotalGroup($string_data_iva);
  1582.         $proforma->setTotal(round($total,2));
  1584.         $em->persist($proforma);
  1585.         $em->flush();
  1587.         return $this->redirectToRoute('ht_view_proforma', ['id' => $proforma->getId()], Response::HTTP_SEE_OTHER);
  1588.     }
  1591.     /**
  1592.      * @Route("/viewproforma/{id}",  name="ht_view_proforma")
  1593.      * Ver la proforma número ID
  1594.      */
  1595.     public function showProformaHtAction($id, EntityManagerInterface $em, Request $request)
  1596.     {
  1597.         $user = $this->getUser();
  1598.         $proforma = $em->getRepository(HtProforma::class)->findOneById($id);
  1600.         // Si no consigue la proforma redirige al listado de expedientes
  1601.         if (empty($proforma)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  1603.         $datAt = (!empty($proforma)) ? $proforma->getDateAt() : null;
  1604.         $totales_neto = (!empty($proforma)) ? $proforma->getTotalNet() : 0;
  1605.         $totales_iva = (!empty($proforma)) ? $proforma->getVatTotalGroup() : 0;
  1606.         $totales = (!empty($proforma)) ? $proforma->getTotal() : 0;
  1607.         $htProformaItems = $em->getRepository(HtProformaItems::class)->findByProforma($proforma);
  1608.         $htFile = $em->getRepository(HtFile::class)->findOneById($proforma->getHtFile());
  1609.         $clientName = (!empty($proforma)) ? $proforma->getClientName() : 'No se pudo determinar el cliente';
  1610.         $clientAddress = (!empty($proforma)) ? $proforma->getClientAddress() : 'No se pudo determinar la dirección';
  1611.         $clientDocument = (!empty($proforma)) ? $proforma->getClientDocument() : 'No se pudo determinar';
  1612.         $type = $proforma->getType();
  1613.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  1615.         $bases_imponibles = array('21'=> 0,'10'=> 0,'0'=> 0,);
  1616.         $datasupplier = array(); $netoSumItems = 0; $totalSumItems = 0;
  1617.         $data_iva = array('ivaMontoDiez' => 0, 'ivaMontoVeintiUno' => 0);
  1618.         $datasupplier['invoice_item_net_sum'] = 0; $datasupplier['invoice_item_sum'] = 0;
  1619.         $datasupplier['invoice_extra_net_sum'] = 0; $datasupplier['invoice_extra_sum'] = 0;
  1621.         foreach ($htProformaItems as $key => $item){
  1622.             if ($item->getItemType()=='htMenu') {
  1623.                 $datasupplier['invoice_item'][] = array(
  1624.                     'id' => $item->getId(),
  1625.                     'itemName' => $item->getItemName(),
  1626.                     'itemPrice' => $item->getItemPrice(),
  1627.                     'itemPax' => $item->getItemPax(),
  1628.                     'itemDateStart' => $item->getItemDateStart(),
  1629.                     'itemDateEnd' => $item->getItemDateEnd(),
  1630.                     'itemIva' => $item->getItemIva(),
  1631.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1632.                 );
  1633.                 $netoSumItems += $item->getItemSubTotalPrice();
  1634.                 $datasupplier['invoice_item_net_sum'] += $item->getItemSubTotalPrice();
  1635.                 $datasupplier['invoice_item_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1636.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1637.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1638.                 switch ($item->getItemIva()) {
  1639.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1640.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1641.                     default: break;
  1642.                 }
  1643.             }
  1645.             if ($item->getItemType()=='htExtra') {
  1646.                 $datasupplier['invoice_extra'][] = array(
  1647.                     'id' => $item->getId(),
  1648.                     'itemType' => $item->getItemType(),
  1649.                     'itemIdOrigin' => $item->getItemIdOrigin(),
  1650.                     'itemName' => $item->getItemName(),
  1651.                     'itemPrice' => $item->getItemSubTotalPrice(),
  1652.                     'itemPax' => $item->getItemPax(),
  1653.                     'itemDateStart' => $item->getItemDateStart(),
  1654.                     'itemDateEnd' => $item->getItemDateEnd(),
  1655.                     'itemIva' => $item->getItemIva(),
  1656.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1657.                 );
  1658.                 $netoSumItems += $item->getItemSubTotalPrice();
  1659.                 $datasupplier['invoice_extra_net_sum'] += $item->getItemSubTotalPrice();
  1660.                 $datasupplier['invoice_extra_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1661.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1662.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1663.                 switch ($item->getItemIva()) {
  1664.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1665.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1666.                     default: break;
  1667.                 }
  1668.             }
  1669.         }
  1670.         $allInvoices = $em->getRepository(HtInvoice::class)->findByHtFile($htFile);
  1671.         $boolToRec = false;
  1672.         $proformas = $em->getRepository(HtProforma::class)->findByHtFile($htFile->getId());
  1673.         $fid = $proforma->getId();
  1675.         return $this->render('higotrigo/ht_invoice/show-invoice.html.twig',
  1676.             array(
  1677.                 'id' => $htFile->getId(),
  1678.                 'cid' => '',
  1679.                 'fid' => $fid,
  1680.                 'invoice' => $proforma,
  1681.                 'allInvoices' => $allInvoices,
  1682.                 'proformas' => $proformas,
  1683.                 'numberadmin' => '',
  1684.                 'type' => $type,
  1685.                 'number' => $proforma->getId(),
  1686.                 'prefix' => $proforma->getPrefix(),
  1687.                 'date' => $datAt,
  1688.                 'reservation' => $htFile,
  1689.                 'company' => $company,
  1690.                 'user' => $user,
  1691.                 'boolToRec' => $boolToRec,
  1692.                 'invoicedeposititems' => '',
  1693.                 'datasupplier' => $datasupplier,
  1694.                 'totales_neto' => $netoSumItems,
  1695.                 'totales_iva' => $totales_iva,
  1696.                 'totales' => $totalSumItems,
  1697.                 'bases_imponibles' => $data_iva,
  1698.                 'paymentInvoice' => null,
  1699.                 'currency' => '€',
  1700.                 'clientName' => $clientName,
  1701.                 'clientAddress' => $clientAddress,
  1702.                 'clientDocument' => $clientDocument,
  1703.             )
  1704.         );
  1705.     }
  1708.     /**
  1709.      * @Route("/htexternal/viewprintproforma/{id}",  name="ht_view_print_proforma")
  1710.      * Ver la proforma del expediente ID en modalidad de impresion
  1711.      */
  1712.     public function printProformaHtAction($id, EntityManagerInterface $em, Request $request)
  1713.     {
  1714.         $proforma = $em->getRepository(HtProforma::class)->findOneById($id);
  1716.         // Si no consigue la proforma redirige al listado de expedientes
  1717.         if (empty($proforma)){ return $this->redirectToRoute('app_ht_file_index', [], Response::HTTP_SEE_OTHER); }
  1719.         $datAt = (!empty($proforma)) ? $proforma->getDateAt() : null;
  1720.         $totales_neto = (!empty($proforma)) ? $proforma->getTotalNet() : 0;
  1721.         $totales_iva = (!empty($proforma)) ? $proforma->getVatTotalGroup() : 0;
  1722.         $totales = (!empty($proforma)) ? $proforma->getTotal() : 0;
  1723.         $htProformaItems = $em->getRepository(HtProformaItems::class)->findByProforma($proforma);
  1724.         $htFile = $em->getRepository(HtFile::class)->findOneById($id);
  1725.         $clientName = (!empty($proforma)) ? $proforma->getClientName() : 'No se pudo determinar el cliente';
  1726.         $clientAddress = (!empty($proforma)) ? $proforma->getClientAddress() : 'No se pudo determinar la dirección';
  1727.         $clientDocument = (!empty($proforma)) ? $proforma->getClientDocument() : 'No se pudo determinar';
  1728.         $type = $proforma->getType();
  1729.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('5');
  1731.         $bases_imponibles = array('21'=> 0,'10'=> 0,'0'=> 0,);
  1732.         $datasupplier = array(); $netoSumItems = 0; $totalSumItems = 0;
  1733.         $data_iva = array('ivaMontoDiez' => 0, 'ivaMontoVeintiUno' => 0);
  1734.         $datasupplier['invoice_item_net_sum'] = 0; $datasupplier['invoice_item_sum'] = 0;
  1735.         $datasupplier['invoice_extra_net_sum'] = 0; $datasupplier['invoice_extra_sum'] = 0;
  1737.         foreach ($htProformaItems as $key => $item){
  1738.             if ($item->getItemType()=='htMenu') {
  1739.                 $datasupplier['invoice_item'][] = array(
  1740.                     'id' => $item->getId(),
  1741.                     'itemName' => $item->getItemName(),
  1742.                     'itemPrice' => $item->getItemPrice(),
  1743.                     'itemPax' => $item->getItemPax(),
  1744.                     'itemDateStart' => $item->getItemDateStart(),
  1745.                     'itemDateEnd' => $item->getItemDateEnd(),
  1746.                     'itemIva' => $item->getItemIva(),
  1747.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1748.                 );
  1749.                 $netoSumItems += $item->getItemSubTotalPrice();
  1750.                 $datasupplier['invoice_item_net_sum'] += $item->getItemSubTotalPrice();
  1751.                 $datasupplier['invoice_item_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1752.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1753.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1754.                 switch ($item->getItemIva()) {
  1755.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1756.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1757.                     default: break;
  1758.                 }
  1759.             }
  1761.             if ($item->getItemType()=='htExtra') {
  1762.                 $datasupplier['invoice_extra'][] = array(
  1763.                     'id' => $item->getId(),
  1764.                     'itemType' => $item->getItemType(),
  1765.                     'itemIdOrigin' => $item->getItemIdOrigin(),
  1766.                     'itemName' => $item->getItemName(),
  1767.                     'itemPrice' => $item->getItemSubTotalPrice(),
  1768.                     'itemPax' => $item->getItemPax(),
  1769.                     'itemDateStart' => $item->getItemDateStart(),
  1770.                     'itemDateEnd' => $item->getItemDateEnd(),
  1771.                     'itemIva' => $item->getItemIva(),
  1772.                     'itemSubTotalPrice' => round($item->getItemSubTotalPrice() * (1 + ($item->getItemIva()/100)),2),
  1773.                 );
  1774.                 $netoSumItems += $item->getItemSubTotalPrice();
  1775.                 $datasupplier['invoice_extra_net_sum'] += $item->getItemSubTotalPrice();
  1776.                 $datasupplier['invoice_extra_sum'] += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1777.                 $totalSumItems += $item->getItemSubTotalPrice() * (1 + ($item->getItemIva() / 100));
  1778.                 $montoIva = $item->getItemSubTotalPrice() * ($item->getItemIva() / 100);
  1779.                 switch ($item->getItemIva()) {
  1780.                     case 10: $data_iva['ivaMontoDiez'] += $montoIva; break;
  1781.                     case 21: $data_iva['ivaMontoVeintiUno'] += $montoIva; break;
  1782.                     default: break;
  1783.                 }
  1784.             }
  1785.         }
  1786.         $allInvoices = $em->getRepository(HtInvoice::class)->findByHtFile($htFile);
  1787.         $boolToRec = false;
  1788.         $fid = $proforma->getPrefix() . $proforma->getIdNum();
  1790.         return $this->render('higotrigo/ht_invoice/proforma-print.html.twig',
  1791.             array(
  1792.                 'id' => $id,
  1793.                 'fid' => $fid,
  1794.                 'type' => 'Proforma',
  1795.                 'number' => $id,
  1796.                 'date' => $datAt,
  1797.                 'company' => $company,
  1798.                 'invoicedeposititems' => '',
  1799.                 'datasupplier' => $datasupplier,
  1800.                 'totales_neto' => $netoSumItems,
  1801.                 'totales' => $totalSumItems,
  1802.                 'bases_imponibles' => $data_iva,
  1803.                 'currency' => '€',
  1804.                 'clientName' => $clientName,
  1805.                 'clientAddress' => $clientAddress,
  1806.                 'clientDocument' => $clientDocument,
  1807.             )
  1808.         );
  1810.     }
  1813.     private function transformarString($input) {
  1814.         // Expresión regular para encontrar números entre los delimitadores [21] y [10]
  1815.         $pattern = '/\[21\](\d+\.?\d*)\[21\]|\[10\](\d+\.?\d*)\[10\]/';
  1817.         // Función de reemplazo que multiplica los números por -1
  1818.         $callback = function ($matches) {
  1819.             if (isset($matches[1]) && $matches[1] !== '') { return '[21]' . (-1 * $matches[1]) . '[21]'; } elseif (isset($matches[2]) && $matches[2] !== '') { return '[10]' . (-1 * $matches[2]) . '[10]'; }
  1820.             return $matches[0]; // No debería llegar aquí
  1821.         };
  1823.         // Realizar el reemplazo en el string original
  1824.         $output = preg_replace_callback($pattern, $callback, $input);
  1825.         return $output;
  1826.     }
  1828.     /**
  1829.      * Formatea el campo vatTotalGroup a una cadena como "157.00 (21%)"
  1830.      */
  1831.     private function formatVatTotalGroup($vatTotalGroup): string
  1832.     {
  1833.         // Regex para extraer valores, porcentajes y manejar valores negativos
  1834.         preg_match_all('/\[(\d+)\](-?\d+(\.\d+)?)/', $vatTotalGroup, $matches);
  1835.         $formattedVat = '';
  1837.         foreach ($matches[1] as $index => $percentage) {
  1838.             // Asegurarse de que los números se formateen correctamente
  1839.             $amount = number_format((float)$matches[2][$index], 2, ',', '.');
  1840.             $formattedVat .= "$amount ({$percentage}%)<br>";
  1841.         }
  1843.         return $formattedVat;
  1844.     }
  1845. }