src/MDS/EventsBundle/Controller/ProposalInvoiceController.php line 269

Open in your IDE?
  1. <?php
  2. /**
  3.  * Created by Mediterranean Develup Solutions
  4.  * User: jorge.defreitas@develup.solutions
  5.  * Date: 04/12/2017
  6.  * Time: 9:49
  7.  */
  9. namespace App\MDS\EventsBundle\Controller;
  11. use App\Constants\VacationsConstants;
  12. use App\Entity\Activities;
  13. use App\Entity\Cities;
  14. use App\Entity\Client;
  15. use App\Entity\Configuration;
  16. use App\Entity\Country;
  17. use App\Entity\Destination;
  18. use App\Entity\Ideas;
  19. use App\Entity\ProposalsInvoiceSummary;
  20. use App\Entity\Provinces;
  21. use App\Entity\Regions;
  22. use App\Entity\SettingsCompany;
  23. use App\Entity\SettingsRol;
  24. use App\Entity\Supplier;
  25. use App\Entity\User;
  26. use App\MDS\EventsBundle\Entity\Proposal;
  27. use App\MDS\EventsBundle\Entity\ProposalDiscount;
  28. use App\MDS\EventsBundle\Entity\ProposalFee;
  29. use App\MDS\EventsBundle\Entity\ProposalFeeInvoice;
  30. use App\MDS\EventsBundle\Entity\ProposalInvoice;
  31. use App\MDS\EventsBundle\Entity\ProposalInvoiceDepositControl;
  32. use App\MDS\EventsBundle\Entity\ProposalInvoiceDepositItems;
  33. use App\MDS\EventsBundle\Entity\ProposalPaymentsClient;
  34. use App\MDS\EventsBundle\Entity\ProposalProforma;
  35. use App\MDS\EventsBundle\Entity\ProposalsSupplierServicesAssistantName;
  36. use App\MDS\EventsBundle\Entity\ProposalSupplierServicesCostsClient;
  37. use App\MDS\EventsBundle\Entity\ProposalTracing;
  38. use App\MDS\EventsBundle\Form\ProposalPaymentsClientType;
  39. use Swift_Mailer;
  40. use Swift_Message;
  41. use Swift_SmtpTransport;
  42. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  43. use Symfony\Component\Routing\Annotation\Route;
  44. use Symfony\Component\HttpFoundation\Request;
  45. use Symfony\Component\HttpFoundation\Response;
  46. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  47. use Symfony\Contracts\Translation\TranslatorInterface;
  49. class ProposalInvoiceController extends AbstractController
  50. {
  51.     private $translator;
  53.     public function __construct(TranslatorInterface $translator) {
  54.         $this->translator = $translator;
  55.     }
  57.     /*
  58.     * ATENCION LAS RAIZ DE @Route POR DEFECTO DEL BUNDLE: EventsBundle ES  /events/, NO PONERLO EN LA @Route("")
  59.     *
  60.     * */
  62.     /**
  63.      * @Route("/proposal/invoice/{id}",  name="proposal_invoice_detector")
  64.      */
  65.     public function detectorInvoiceAction($id, Request $request)
  66.     {
  67.         $em = $this->getDoctrine()->getManager();
  68.         $invoiceconsulta= array();
  69.         $typeconsulta ='';
  71.         $invoice = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  72.         if (!empty($invoice)){
  73.             $invoiceconsulta = $invoice;
  74.             $typeconsulta = $invoice->getType();
  75.         }
  77. //        $novatinvoice= $em->getRepository(ProposalNoVatInvoice::class)->findOneByProposalId($id);
  78. //        if (!empty($novatinvoice)){
  79. //            $invoiceconsulta = $novatinvoice;
  80. //            $typeconsulta = 'No Vat Invoice';
  81. //        }
  83. //        $invoiceconsulta = $em->getRepository(ProposalNoVatInvoice::class)->findOneByProposalId($id);
  84.         if (!empty($invoiceconsulta)){
  85.             $type = $typeconsulta;
  86. //            $number = $invoiceconsulta->getId();
  87.             $number = $invoiceconsulta->getNumber();
  88.             $date = $invoiceconsulta->getDateAt();
  89.             $prefix = $invoiceconsulta->getPrefix();
  91.             /* Obtengo usuario logueado */
  92.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  93.             $user_id = $user_logueado->getId();
  95.             $data = $this->baseInvoiceProposal($id, $type, $number, $prefix, $date, $request);
  96.             $token = $data['token'];
  98.             $em->clear();
  99.             $invoice_query = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  100.             $invoice_query->setTotalnet($data['totales_neto']);
  101.             $invoice_query->setVat(serialize($data['bases_imponibles']));
  102.             $invoice_query->setTotal($data['totales']);
  103.             $em->persist($invoice_query);
  104.             $em->flush();
  106.         }else{
  107.             return $this->redirectToRoute('proposal_generate_proforma',
  108.                 array(
  109.                     'id' => $id
  110.                 )
  111.             );
  112.         }
  114.         $fees = $em->getRepository(ProposalFeeInvoice::class)->findByProposalId($id);
  115.         if (!empty($fees)){ if (!($fees[0]->getToInvoice())){ $fees = null; } }     // Si no se debe mostrar en factura se pone a null
  117.         $summary = $em->getRepository(ProposalsInvoiceSummary::class)->findOneByProposalId($id);
  118.         $summaryInvoice = !empty($summary);
  119.         $summaryInvoiceText = !empty($summary) ? $summary->getDescription() : null;
  121.         return $this->render('MDS/EventsBundle/services/services-invoice-proposal.html.twig',
  122.             array(
  123.                 'id' => $id,
  124.                 'type' => $data['type'],
  125.                 'number' => $data['number'],
  126.                 'prefix' => $data['prefix'],
  127.                 'date' => $data['date'],
  128.                 'token' => $token,
  129.                 'proposal' => $data['proposal'],
  130.                 'company' => $data['company'],
  131.                 'clients' => $data['clients'],
  132.                 'datasupplier' => $data['datasupplier'],
  133.                 'totales_neto_antes' => $data['totales_neto_antes'],
  134.                 'totales_neto' => $data['totales_neto'], // totales neto
  135.                 'bases_imponibles' => $data['bases_imponibles'],
  136.                 'totales_antes' => $data['totales_antes'],
  137.                 'totales' => $data['totales'], // totales generales
  138.                 'balance' => $data['balance'],
  139.                 'totales_generales' => $data['totales_generales'],
  140.                 'currency' => $data['currency'],
  141.                 'detail_iva' => 'no',
  142.                 'discounts' => $data['discounts'],
  143.                 'fees' => $fees,
  144.                 'summaryInvoice' => $summaryInvoice,
  145.                 'summaryInvoiceText' => $summaryInvoiceText,
  146.                 'paymentInvoice' => $data['paymentInvoice'],
  147.                 'invoiceDesposit' => $data['invoiceDesposit'],
  148.                 'mcp' => $data['proposal']->getMcp()
  149.             )
  150.         );
  151.     }
  153.     /**
  154.      * @Route("/proposal/invoice/print/{id}",  name="proposal_invoice_detector_print")
  155.      */
  156.     public function detectorInvoicePrintAction($id, Request $request)
  157.     {
  158.         $em = $this->getDoctrine()->getManager();
  159.         $invoiceconsulta= array();
  160.         $typeconsulta ='';
  162.         $invoice= $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  163.         if (!empty($invoice)){
  164.             $invoiceconsulta = $invoice;
  165.             $typeconsulta = $invoice->getType();
  166.         }
  168. //        $novatinvoice= $em->getRepository(ProposalNoVatInvoice::class)->findOneByProposalId($id);
  169. //        if (!empty($novatinvoice)){
  170. //            $invoiceconsulta = $novatinvoice;
  171. //            $typeconsulta = 'No Vat Invoice';
  172. //        }
  174. //        $invoiceconsulta = $em->getRepository(ProposalNoVatInvoice::class)->findOneByProposalId($id);
  175.         if (!empty($invoiceconsulta)){
  176.             $type = $typeconsulta;
  177. //            $number = $invoiceconsulta->getId();
  178.             $number = $invoiceconsulta->getNumber();
  179.             $date = $invoiceconsulta->getDateAt();
  180.             $prefix = $invoiceconsulta->getPrefix();
  181.             $data = $this->baseInvoiceProposal($id, $type, $number, $prefix, $date, $request);
  182.             $token = $data['token'];
  183.         }else{
  184.             return $this->redirectToRoute('proposal_generate_proforma',
  185.                 array(
  186.                     'id' => $id
  187.                 )
  188.             );
  189.         }
  191.         $fees = $em->getRepository(ProposalFeeInvoice::class)->findByProposalId($id);
  193.         if (!empty($fees)){
  194.             $fees[0]->setAmount($fees[0]->getFeeNet());
  195.             if (!($fees[0]->getToInvoice())){ $fees = null; } } // Si no se debe mostrar en factura se pone a null
  197.         $summary = $em->getRepository(ProposalsInvoiceSummary::class)->findOneByProposalId($id);
  198.         $summaryInvoice = !empty($summary);
  199.         $summaryInvoiceText = !empty($summary) ? $summary->getDescription() : null;
  201.         return $this->render('MDS/EventsBundle/services/services-invoice-print-proposal.html.twig',
  202.             array(
  203.                 'id' => $id,
  204.                 'type' => $data['type'],
  205.                 'number' => $data['number'],
  206.                 'prefix' => $data['prefix'],
  207.                 'date' => $data['date'],
  208.                 'token' => $token,
  209.                 'proposal' => $data['proposal'],
  210.                 'company' => $data['company'],
  211.                 'clients' => $data['clients'],
  212.                 'datasupplier' => $data['datasupplier'],
  213.                 'totales_neto_antes' => $data['totales_neto_antes'],
  214.                 'totales_neto' => $data['totales_neto'],
  215.                 'bases_imponibles' => $data['bases_imponibles'],
  216.                 'totales_antes' => $data['totales_antes'],
  217.                 'totales' => $data['totales'],
  218.                 'balance' => $data['balance'],
  219.                 'totales_generales' => $data['totales_generales'],
  220.                 'currency' => $data['currency'],
  221.                 'detail_iva' => 'no',
  222.                 'discounts' => $data['discounts'],
  223.                 'fees' => $fees,
  224.                 'paymentInvoice' => $data['paymentInvoice'],
  225.                 'invoiceDesposit' => $data['invoiceDesposit'],
  226.                 'summaryInvoice' => $summaryInvoice,
  227.                 'summaryInvoiceText' => $summaryInvoiceText,
  228.             )
  229.         );
  231.     }
  234.     /**
  235.      * @Route("/proposal/generate/proforma/{id}",  name="proposal_generate_proforma")
  236.      */
  237.     public function generateProformaAction($id, Request $request)
  238.     {
  239.         $em = $this->getDoctrine()->getManager();
  240.         $proforma = $em->getRepository(ProposalProforma::class)->findOneByProposalId($id);
  242.         $prefix = "MP".date('ymd')."-";
  243.         if (is_null($proforma)){
  244.             $proforma_new = new ProposalProforma();
  245.             $proforma_new->setProposalId($id);
  246.             $proforma_new->setPrefix($prefix);
  247.             $proforma_new->setDateAt(new \DateTime("now"));
  249.             /* Obtengo usuario logueado */
  250.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  251.             $user_id = $user_logueado->getId();
  253.             $proforma_new->setCreatedId($user_id);
  254.             $proforma_new->setUpdatedId($user_id);
  256.             $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  257.             if($proposal->getStatus() != 'Invoiced'){
  258.                 $em->persist($proforma_new);
  259.                 $em->flush();
  260.             }
  261.         }
  263.         return $this->redirectToRoute('proposal_invoice_proforma', array( 'id' => $id ) );
  264.     }
  266.     /**
  267.      * @Route("/proposal/invoice/proforma/{id}",  name="proposal_invoice_proforma")
  268.      */
  269.     public function detailsProformaAction($id, Request $request)
  270.     {
  271.         $data = array();
  272.         $em = $this->getDoctrine()->getManager();
  273.         $paymentsClient = new ProposalPaymentsClient();
  274.         $paymentsClient->setProposalId($id);
  275.         $form = $this->createProposalPaymentsClientForm($paymentsClient);
  277.         $payments = $em->getRepository(ProposalPaymentsClient::class)->findByProposalId($id);
  279.         $proforma = $em->getRepository(ProposalProforma::class)->findOneByProposalId($id);
  280.         if (!empty($proforma)){
  281.             $type = 'Proforma';
  282.             $number = $proforma->getId();
  283.             $date = $proforma->getDateAt();
  284.             $prefix = $proforma->getPrefix();
  286.             $data = $this->baseInvoiceProposal($id, $type, $number, $prefix, $date, $request);
  287.             $token = $data['token'];
  288.         }else{
  289.             return $this->redirectToRoute('proposal_generate_proforma',
  290.                 array(
  291.                     'id' => $id
  292.                 )
  293.             );
  294.         }
  296.         $fees = $em->getRepository(ProposalFee::class)->findByProposalId($id);
  297.         if (!empty($fees)){ if (!($fees[0]->getToInvoice())){ $fees = null; } } // Si no se debe mostrar en factura se pone a null
  299.         return $this->render('MDS/EventsBundle/services/services-proforma-proposal.html.twig',
  300.             array(
  301.                 'id' => $id,
  302.                 'type' => $data['type'],
  303.                 'number' => $data['number'],
  304.                 'prefix' => $data['prefix'],
  305.                 'date' => $data['date'],
  306.                 'token' => $token,
  307.                 'proposal' => $data['proposal'],
  308.                 'company' => $data['company'],
  309.                 'clients' => $data['clients'],
  310.                 'datasupplier' => $data['datasupplier'],
  311.                 'totales_neto_antes' => $data['totales_neto_antes'],
  312.                 'totales_neto' => $data['totales_neto'],
  313.                 'bases_imponibles' => $data['bases_imponibles'],
  314.                 'totales_antes' => $data['totales_antes'],
  315.                 'totales' => $data['totales'],
  316.                 'balance' => $data['balance'],
  317.                 'totales_generales' => $data['totales_generales'],
  318.                 'currency' => $data['currency'],
  319.                 'detail_iva' => 'yes',
  320.                 'discounts' => $data['discounts'],
  321.                 'fees' => $fees,
  322.                 'paymentInvoice' => $data['paymentInvoice'],
  323.                 'payments' => $payments,
  324.                 'invoiceDesposit' => $data['invoiceDesposit'],
  325.                 'form' => $form->createView(),
  326.                 'mcp' => $data['proposal']->getMcp(),
  328.             )
  329.         );
  330.     }
  332.     private function createProposalPaymentsClientForm(ProposalPaymentsClient $entity)
  333.     {
  334.         $form = $this->createForm(ProposalPaymentsClientType::class, $entity, array(
  335.             'action' => $this->generateUrl('proposal_payments_client_add'),
  336.             'method' => 'POST'
  337.         ));
  339.         return $form;
  340.     }
  342.     /**
  343.      * @Route("/proposal/payments", name="proposal_payments_client_add")
  344.      */
  345.     public function createAction(Request $request)
  346.     {
  348.         $paymentsClient = new ProposalPaymentsClient();
  349.         $form = $this->createProposalPaymentsClientForm($paymentsClient);
  350.         $form->handleRequest($request);
  352.         if($form->isValid())
  353.         {
  355.             $em = $this->getDoctrine()->getManager();
  357.             /* Obtengo usuario logueado */
  358.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  359.             $user_id = $user_logueado->getId();
  361.             $paymentsClient->setCreatedId($user_id);
  362.             $paymentsClient->setUpdatedId($user_id);
  364.             /* Gestión de eventos en Log */
  365.             $user_lastname = $user_logueado->getLastname();
  366.             $user_name = $user_logueado->getName();
  367.             $user_email = $user_logueado->getEmail();
  368.             $user_rol = $user_logueado->getRoles();
  369.             $event_url = $request->getPathInfo();
  370.             $event_complete = $user_name.' '.$user_lastname.' - '.$user_email.' - '.$user_rol[0].' | '.$event_url;
  372.             $proposal = $em->getRepository(Proposal::class)->findOneById($paymentsClient->getProposalId());
  373.             if($proposal->getStatus() != 'Invoiced'){
  374.                 $em->persist($paymentsClient);
  375.                 $em->flush();
  376.                 $event = 'the payment was registered';
  377.                 $successMessage = $this->translator->trans($event);
  378.                 $this->addFlash('mensajepaymentsclient', $successMessage);
  379.             }else{
  380.                 $errorMessage = $this->translator->trans('Error, the proposal is invoiced and cannot be modified');
  381.                 $this->addFlash('mensajepaymentsclienterror', $errorMessage);
  382.             }
  384.             return $this->redirectToRoute('proposal_invoice_proforma',
  386.                 array(
  387.                     'id' => $paymentsClient->getProposalId()
  388.                 )
  390.             );
  392.         }else{
  393.             $errorMessage = $this->translator->trans('Error, some fields are empty');
  394.             $this->addFlash('mensajepaymentsclienterror', $errorMessage);
  395.         }
  398.         return $this->redirectToRoute('proposal_invoice_proforma',
  399.             array(
  400.                 'id' => $paymentsClient->getProposalId()
  401.             )
  402.         );
  404.     }
  406.     /**
  407.      * @Route("/proposal/pdfpdf",  name="proposal_invoice_proforma_pdf_prueba")
  408.      */
  409.     public function pdfAction()
  410.     {
  411.         $snappy = $this->get('knp_snappy.pdf');
  412.         $filename = 'myFirstSnappyPDF';
  413.         $url = 'http://mante.develup.solutions';
  416.         return new Response(
  417.             $snappy->getOutput($url),
  418.             200,
  419.             array(
  420.                 'Content-Type'          => 'application/pdf',
  421.                 'Content-Disposition'   => 'inline; filename="'.$filename.'.pdf"'
  422.             )
  423.         );
  424.     }
  426.     /**
  427.      * @Route("/proposal/invoice/proforma/pdf/{id}",  name="proposal_invoice_proforma_pdf")
  428.      */
  429.     public function detailsProformaPdfActionAction($id, Request $request)
  430.     {
  431.         $snappy = $this->get('knp_snappy.pdf');
  432.         $filename = 'myFirstSnappyPDF';
  434.         // use absolute path !
  435.         $pageUrl = $this->generateUrl('proposal_invoice_proforma_print_externo', array('id'=>$id), UrlGeneratorInterface::ABSOLUTE_URL);
  437.         return new Response(
  438.             $snappy->getOutput($pageUrl),
  439.             200,
  440.             array(
  441.                 'Content-Type'          => 'application/pdf',
  442.                 'Content-Disposition'   => 'inline; filename="'.$filename.'.pdf"'
  443.             )
  444.         );
  445.     }
  447.     /**
  448.      * @Route("/proposal/invoice/pdf/{id}",  name="proposal_invoice_proforma_pdf")
  449.      */
  450.     public function detailsInvoicePdfActionAction($id, Request $request)
  451.     {
  452.         $snappy = $this->get('knp_snappy.pdf');
  453.         $filename = 'myFirstSnappyPDF';
  455.         // use absolute path !
  456.         $pageUrl = $this->generateUrl('proposal_invoice_detector_print_externo', array('id'=>$id), UrlGeneratorInterface::ABSOLUTE_URL);
  458.         return new Response(
  459.             $snappy->getOutput($pageUrl),
  460.             200,
  461.             array(
  462.                 'Content-Type'          => 'application/pdf',
  463.                 'Content-Disposition'   => 'inline; filename="'.$filename.'.pdf"'
  464.             )
  465.         );
  466.     }
  472.     /**
  473.      * @Route("/proposal/invoice/proforma/print/{id}",  name="proposal_invoice_proforma_print")
  474.      */
  475.     public function detailsProformaPrintAction($id, Request $request)
  476.     {
  477. //        $token = "";
  478.         $em = $this->getDoctrine()->getManager();
  479.         $proforma = $em->getRepository(ProposalProforma::class)->findOneByProposalId($id);
  480.         if (!empty($proforma)){
  481.             $type = 'Proforma';
  482.             $number = $proforma->getId();
  483.             $date = $proforma->getDateAt();
  484.             $prefix = $proforma->getPrefix();
  485.             $data = $this->baseInvoiceProposal($id, $type, $number, $prefix, $date, $request);
  486.             $token = $data['token'];
  487.         }else{
  488.             return $this->redirectToRoute('proposal_generate_proforma',
  489.                 array(
  490.                     'id' => $id
  491.                 )
  492.             );
  493.         }
  495.         $fees = $em->getRepository(ProposalFee::class)->findByProposalId($id);
  496.         if (!empty($fees)){ if (!($fees[0]->getToInvoice())){ $fees = null; } } // Si no se debe mostrar en factura se pone a null
  498.         $summary = $em->getRepository(ProposalsInvoiceSummary::class)->findOneByProposalId($id);
  499.         $summaryInvoice = !empty($summary);
  500.         $summaryInvoiceText = !empty($summary) ? $summary->getDescription() : null;
  502.         return $this->render('MDS/EventsBundle/services/services-invoice-print-proposal.html.twig',
  503.             array(
  504.                 'id' => $id,
  505.                 'type' => $data['type'],
  506.                 'number' => $data['number'],
  507.                 'prefix' => $data['prefix'],
  508.                 'date' => $data['date'],
  509.                 'token' => $token,
  510.                 'proposal' => $data['proposal'],
  511.                 'company' => $data['company'],
  512.                 'clients' => $data['clients'],
  513.                 'datasupplier' => $data['datasupplier'],
  514.                 'totales_neto_antes' => $data['totales_neto_antes'],
  515.                 'totales_neto' => $data['totales_neto'],
  516.                 'bases_imponibles' => $data['bases_imponibles'],
  517.                 'totales_antes' => $data['totales_antes'],
  518.                 'totales' => $data['totales'],
  519.                 'balance' => $data['balance'],
  520.                 'totales_generales' => $data['totales_generales'],
  521.                 'currency' => $data['currency'],
  522.                 'detail_iva' => 'yes',
  523.                 'discounts' => $data['discounts'],
  524.                 'fees' => $fees,
  525.                 'paymentInvoice' => $data['paymentInvoice'],
  526.                 'summaryInvoice' => $summaryInvoice,
  527.                 'invoiceDesposit' => $data['invoiceDesposit'],
  528.                 'summaryInvoiceText' => $summaryInvoiceText,
  529.             )
  530.         );
  531.     }
  533.     /**
  534.      * @Route("/proposal/generate/invoice/{id}",  name="proposal_generate_invoice")
  535.      */
  536.     public function generateInvoiceAction($id, Request $request)
  537.     {
  538.         $em = $this->getDoctrine()->getManager();
  539.         $invoiceGenerate = $request->request->get('invoiceGenerate');
  540.         $invoice= $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  541. //        d($invoiceGenerate);
  542. //        exit();
  544.         if (is_null($invoice)){
  545.             $proposal= $em->getRepository(Proposal::class)->findOneById($id);
  546.             $status = $proposal->getStatus(); // Para controlar que se guarde si no está facturado
  547.             $proposal->setStatus('Invoiced');
  549.             $invoice_new = new ProposalInvoice();
  550.             $invoice_new->setNumber($invoiceGenerate['number']);
  551.             $invoice_new->setDateAt(new \DateTime($invoiceGenerate['dateInvoice']));
  552.             $invoice_new->setType($invoiceGenerate['type']);
  553.             $invoice_new->setProposalId($invoiceGenerate['id']);
  554.             $invoice_new->setPrefix('');
  555. //            $invoice_new->setDateAt(new \DateTime("now"));
  557.             /* Obtengo usuario logueado */
  558.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  559.             $user_id = $user_logueado->getId();
  561.             $invoice_new->setCreatedId($user_id);
  562.             $invoice_new->setUpdatedId($user_id);
  564.             if($status != 'Invoiced'){
  565.                 $em->persist($invoice_new);
  566.                 $em->persist($proposal);
  567.                 $em->flush();
  568.             }
  570.             //Envio correo a administracion en el caso que no tenga numero de factura y este como no enviado
  571.             if( empty($invoiceGenerate['number'])){
  572.                 $time = new \DateTime("now");
  573.                 $agent = $em->getRepository(User::class)->findOneBy(
  574.                     array(
  575.                         "id" => $proposal->getAgentId(),
  576.                         "status" => VacationsConstants::PAYROLL_STAFF_STATUS
  577.                     )
  578.                 )
  579.                 ;
  580.                 $mailAgent[] = $agent->getEmail();
  581.                 $agentMail = $agent->getEmail();
  582.                 $passGmail = $agent->getPassGmail();
  583.                 $firmGmail = $agent->getFirmGmail();
  584.                 $mailAgentSent = array(
  585.                     $agent->getEmail() => $agent->getName().' '. $agent->getLastName()
  586.                 );
  588.                 $setting_rol = $em->getRepository(SettingsRol::class)->findBy(
  589.                     array(
  590.                         'weight' => array('2','3'),
  591.                         'madmin' => '1',
  592.                     )
  593.                 );
  594.                 $mailAdmin = array();
  595.                 foreach($setting_rol as $settingRol){
  596.                     $administration = $em->getRepository(User::class)->findByUserrol($settingRol->getId());
  597.                     foreach($administration as $admin){
  598.                         $mailAdmin[] = $admin->getEmail();
  599.                     }
  600.                 }
  601.                 $body ='P#'.$proposal->getId().', '.$proposal->getTitle().'<br><br>
  602.                             <a href="http://'.$request->server->get('HTTP_HOST').'/events/proposal/invoice/number/'.$proposal->getId().'">Asignar Número de Factura</a><br>
  603.                             <a href="http://'.$request->server->get('HTTP_HOST').'/events/proposal/edit/'.$proposal->getId().'">Ir al Proposal</a> - 
  604.                             <a href="http://'.$request->server->get('HTTP_HOST').'/events/proposal/summary/prices/'.$proposal->getId().'">Ver Resumen</a>
  605.                             <br><br>
  606.                             Alerta de solicitud automatizada de número de factura en fecha: '.$time->format('d/m/Y H:i:s').'<br><br>';
  608.                 $data = array(
  609.                     'body' => $body,
  610.                     'firm' => $firmGmail,
  611.                 );
  613.                 $mailTodos = array_merge($mailAgent, $mailAdmin);
  615.                 // EJECUTAR ENVIO DE ALERTA DE VISTO POR CLIENTE
  616.                 $transporter = new Swift_SmtpTransport();
  617.                 $transporter->setHost('smtp.gmail.com')
  618.                     ->setEncryption('ssl') //ssl / tls
  619.                     ->setPort(465) // 465 / 587
  620.                     ->setUsername($agentMail)
  621.                     ->setPassword($passGmail);
  622. //                        ->setUsername('desarrollo@develup.solutions')
  623. //                        ->setPassword('Develup2017');
  624.                 $mailer = new Swift_Mailer($transporter);
  626.                 $message = new Swift_Message();
  627.                 $message->setSubject('P#'.$proposal->getId().', Solicitud de número de factura automatizada')
  628.                     ->setSender($agentMail)
  629.                     ->setFrom($mailAgentSent)
  630.                     ->setReplyTo($mailAgentSent)
  631.                     ->setTo($mailTodos)
  632.                     ->setBody(
  633.                         $this->renderView(
  634.                             'mail/structure-mail.html.twig',
  635.                             array('data' => $data)
  636.                         ),
  637.                         'text/html'
  638.                     )
  639.                 ;
  640.                 $mailer->send($message);
  641.             }
  643.             // Guardo en historico de seguimiento
  644.             $textHistory = $this->translator->trans('Billed Proposal');
  645.             $history = $this->TracingHistoryOperations($proposal->getId(), $textHistory);
  647.             // Verificamos si se debe crear un Fee asociado a la factura
  648.             $fee = $em->getRepository(ProposalFee::class)->findOneByProposalId($id);
  650.             if (!empty($fee)){
  651.                 $feeInvoice = new ProposalFeeInvoice();
  652.                 $feeInvoice->setProposalId($id);
  653.                 $feeInvoice->setName($fee->getName());
  654.                 $feeInvoice->setType($fee->getType());
  655.                 $feeInvoice->setAmount($fee->getAmount());
  656.                 $feeInvoice->setOpIva($fee->getOpIva());
  657.                 $feeInvoice->setIva($fee->getIva());
  658.                 $feeInvoice->setToInvoice($fee->getToInvoice());
  659.                 $feeInvoice->setInvoiceId($invoice_new->getId());
  660.                 $feeInvoice->setFeeNet(0);
  661.                 $feeInvoice->setFeeTotal(0);
  662.                 $feeInvoice->setCreatedId($user_id);
  663.                 $feeInvoice->setCreatedAt(new \DateTime("now"));
  665.                 if($status != 'Invoiced'){
  666.                     $em->persist($feeInvoice);
  667.                     $em->flush();
  668.                 }
  669.             }
  670.         }
  672.         return $this->redirectToRoute('proposal_invoice_detector',
  673.             array(
  674.                 'id' => $invoiceGenerate['id']
  675.             )
  676.         );
  678.     }
  680.     /**
  681.      * @Route("/proposal/invoice/proforma/payments/delete/{id}",  name="proposal_invoice_proforma_payments_delete")
  682.      */
  683.     public function deletePaymentsProformaAction($id, Request $request)
  684.     {
  685.         $em = $this->getDoctrine()->getManager();
  686.         $delete= $em->getRepository(ProposalPaymentsClient::class)->findOneById($id);
  688.         $proposalId = $delete->getProposalId();
  690.         $em->remove($delete);
  691.         $em->flush();
  693.         return $this->redirectToRoute('proposal_invoice_proforma',
  694.             array(
  695.                 'id' =>$proposalId
  696.             )
  697.         );
  699.     }
  702.     private function baseInvoiceProposal($id, $type, $number, $prefix, $date, Request $request)
  703.     {
  704.         $em = $this->getDoctrine()->getManager();
  705.         $proposal= $em->getRepository(Proposal::class)->findOneById($id);
  707.         $services_supplier = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findBy(
  708.             array(
  709.                 'proposalId' => $id,
  710.                 'serviceIdFather' => '0'
  711.             ),
  712.             array(
  713.                 'id' => 'ASC'
  714.             )
  715.         );
  716.         $data_iva = array();
  717.         $supplier_control = array();
  718.         foreach($services_supplier as $servicessupplier){
  719. ////            $supplier_control[$servicessupplier->getSupplierId()] = $servicessupplier->getSupplierId();
  720. //            $supplier_control[$servicessupplier->getSupplierId()] = array(
  721. //                'id' => $servicessupplier->getSupplierId(),
  722. //                'destinoId' => $servicessupplier->getDestinationId(),
  723. //            );
  725.             if(!is_null($servicessupplier->getActivityId())){
  726.                 $supplier_control[$servicessupplier->getActivityId()] = array(
  727.                     'master' => 'activity',
  728.                     'id' => $servicessupplier->getActivityId(),
  729.                     'destinoId' => $servicessupplier->getDestinationId(),
  730.                 );
  731.             }
  732.             if(!is_null($servicessupplier->getIdeaId())){
  733.                 $supplier_control[$servicessupplier->getIdeaId()] = array(
  734.                     'master' => 'idea',
  735.                     'id' => $servicessupplier->getIdeaId(),
  736.                     'destinoId' => $servicessupplier->getDestinationId(),
  737.                 );
  738.             }
  739.             if((!is_null($servicessupplier->getSupplierId())) and ($servicessupplier->getIdeaId() == null) and ($servicessupplier->getActivityId() == null)){
  740.                 $supplier_control[$servicessupplier->getSupplierId()] = array(
  741.                     'master' => 'supplier',
  742.                     'id' => $servicessupplier->getSupplierId(),
  743.                     'destinoId' => $servicessupplier->getDestinationId(),
  744.                 );
  745.             }
  747.         }
  751.         $data_serviceCat = array();
  752.         $data_supplier = array();
  753.         $totales_neto_all = 0;
  754.         $totales_all = 0;
  755.         $currency ="";
  756.         $data_service_supplier = array();
  757.         foreach($supplier_control as $suppliercontrol){
  759. //            $destination = $em->getRepository(Destination::class)->findOneById($suppliercontrol['destinoId']);
  760.             $destination = $em->getRepository(Destination::class)->findOneById($suppliercontrol['destinoId']);
  762.             $colorlabel= "bg-success-300";
  764.             $sqlactivities = "";
  765.             if($suppliercontrol['master'] == 'activity'){
  766.                 $master = "activity";
  767.                 $sqlactivities = $em->getRepository(Activities::class)->findOneById($suppliercontrol['id']);
  769.                 // ORDEN DESCENDENTE Y POR SERVICES
  770.                 $parameters = array(
  771.                     'proposalId' => $id,
  772.                     'serviceIdFather' => '0',
  773.                     'activityId' => $suppliercontrol['id']
  774.                 );
  775.                 $dql = 'SELECT p
  776.                     FROM EventsBundle:ProposalSupplierServicesCostsClient p
  777.                     WHERE p.proposalId = :proposalId AND p.activityId = :activityId AND p.serviceIdFather = :serviceIdFather 
  778.                     ORDER BY p.serviceCatId, p.rank ASC ';
  780.                 $query = $em->createQuery($dql)->setParameters($parameters);
  781.                 $data_service_supplier = $query->getResult();
  782.             }
  784.             $sqlideas = "";
  785.             if($suppliercontrol['master'] == 'idea'){
  786.                 $master = "idea";
  787.                 $sqlideas = $em->getRepository(Ideas::class)->findOneById($suppliercontrol['id']);
  789.                 // ORDEN DESCENDENTE Y POR SERVICES
  790.                 $parameters = array(
  791.                     'proposalId' => $id,
  792.                     'serviceIdFather' => '0',
  793.                     'ideaId' => $suppliercontrol['id']
  794.                 );
  795.                 $dql = 'SELECT p
  796.                     FROM EventsBundle:ProposalSupplierServicesCostsClient p
  797.                     WHERE p.proposalId = :proposalId AND p.ideaId = :ideaId AND p.serviceIdFather = :serviceIdFather 
  798.                     ORDER BY p.serviceCatId, p.rank ASC ';
  800.                 $query = $em->createQuery($dql)->setParameters($parameters);
  801.                 $data_service_supplier = $query->getResult();
  802.             }
  804.             $sqlsuppliers ="";
  805.             if($suppliercontrol['master'] == 'supplier'){
  806.                 $master = "supplier";
  807.                 $sqlsuppliers = $em->getRepository(Supplier::class)->findOneById($suppliercontrol['id']);
  808.                 if(!is_null($sqlsuppliers)){
  809.                     switch ($sqlsuppliers->getStar()) {
  810.                         case 1:
  811.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i>');
  812.                             break;
  813.                         case 2:
  814.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i>');
  815.                             break;
  816.                         case 3:
  817.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i>');
  818.                             break;
  819.                         case 4:
  820.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i>');
  821.                             break;
  822.                         case 5:
  823.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i> SUP');
  824.                             break;
  825.                         case 6:
  826.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i>');
  827.                             break;
  828.                         case 7:
  829.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i> GL');
  830.                             break;
  831.                         case 8:
  832.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i> GL');
  833.                             break;
  834.                     }
  835.                 }
  836.                 // ORDEN DESCENDENTE Y POR SERVICES
  837.                 $parameters = array(
  838.                     'proposalId' => $id,
  839.                     'serviceIdFather' => '0',
  840.                     'supplierId' => $suppliercontrol['id']
  841.                 );
  842.                 $dql = 'SELECT p
  843.                     FROM EventsBundle:ProposalSupplierServicesCostsClient p
  844.                     WHERE p.proposalId = :proposalId AND p.supplierId = :supplierId AND p.ideaId is null AND p.activityId is null AND p.serviceIdFather = :serviceIdFather 
  845.                     ORDER BY p.serviceCatId, p.rank ASC ';
  847.                 $query = $em->createQuery($dql)->setParameters($parameters);
  848.                 $data_service_supplier = $query->getResult();
  850.                 // Agrupamos asistencias de In-Out por ID de Agente
  851.                 $new_data_service_supplier = array();
  852.                 $arregloAcumulador = array();
  853.                 $acumulador = array();
  855.                 if ($sqlsuppliers->getCompany() == 'IN OUT TRAVEL & EVENTS') {
  856.                     // El proveedor es In Out
  858.                     foreach ($data_service_supplier as $dtsp){
  859.                         $zNameSrvOrNameUsr = $em->getRepository(ProposalsSupplierServicesAssistantName::class)->findOneByPrpSupSrvId($dtsp->getServiceIdProposal());
  861.                         if ($dtsp->getServiceCatId() != 15){
  862.                             $new_data_service_supplier[] = $dtsp;
  863.                         } else {
  864.                             // Tenemos una asistencia de In Out
  865.                             // vamos acumulando precios, over, etc
  867.                             if ((! array_key_exists($dtsp->getAssistantId().'-'.$dtsp->getPrice(),$arregloAcumulador) ) and (!is_null($dtsp->getAssistantId()))){
  869. //                                Antes se comprobaba sololo con el id ahora el id del agente y el precio de la asistencia
  870. //                                $zAg= $em->getRepository(User::class)->findOneById($dtsp->getAssistantId());
  871. //                                $dtsp->setName('Staff In Out Events: '. $zAg->getName(). ' ' . $zAg->getLastName());
  872. //                                $dtsp->setUnits(1);
  873. //                                $arregloAcumulador[$dtsp->getAssistantId()] = $dtsp;
  875.                                 $zAg= $em->getRepository(User::class)->findOneById($dtsp->getAssistantId());
  876. //                                if($zAg->getId() == 20){
  877. //                                  AQUI TENDRIAMOS LA CONDICION PARA QUE APAREZCA O NO EL NOMBRE EDL AGENTE (FUTURO DESARROLLO)
  878. //                                }else {
  879.                                 if (empty($zNameSrvOrNameUsr) && !is_null($zAg)) {
  880.                                     $dtsp->setName('Staff In Out Events: ' . $zAg->getName() . ' ' . $zAg->getLastName());
  881.                                 }
  882. //                                }
  883.                                 $dtsp->setUnits(1);
  884.                                 $arregloAcumulador[$dtsp->getAssistantId().'-'.$dtsp->getPrice()] = $dtsp;
  886.                             } else {
  888.                                 if ((!is_null($dtsp->getAssistantId()))){
  889. //                                Antes se comprobaba sololo con el id ahora el id del agente y el precio de la asistencia
  890. //                                $tempAcum = $arregloAcumulador[$dtsp->getAssistantId()];
  891.                                     $tempAcum = $arregloAcumulador[$dtsp->getAssistantId().'-'.$dtsp->getPrice()];
  893.                                     $tempAcum->setUnits($tempAcum->getUnits() + 1);
  895.                                     //Si el dia de inicio es menor actualizas (para establecer rangos de varios dias)
  896.                                     if ($dtsp->getDateInAt() < $tempAcum->getDateInAt()) {
  897.                                         $tempAcum->setDateInAt($dtsp->getDateInAt());
  898.                                     }
  899.                                     //Si el dia de fin es mayor actualizas (para establecer rangos de varios dias)
  900.                                     if ($dtsp->getDateOutAt() > $tempAcum->getDateOutAt()) {
  901.                                         $tempAcum->setDateOutAt($dtsp->getDateOutAt());
  902.                                     }
  904. //                                Antes se comprobaba sololo con el id ahora el id del agente y el precio de la asistencia
  905. //                                $arregloAcumulador[$dtsp->getAssistantId()] = $tempAcum;
  906.                                     $arregloAcumulador[$dtsp->getAssistantId().'-'.$dtsp->getPrice()] = $tempAcum;
  907.                                 } else {
  909.                                     // Tenemos una asistencia de un agente EXTERNO - este agente no se encuentra en el listado de agentes de In Out
  911.                                     if ( array_key_exists($dtsp->getName(),$arregloAcumulador) ){
  912.                                         $tempAcum = $arregloAcumulador[$dtsp->getName()];
  914.                                         $tempAcum->setUnits($tempAcum->getUnits() + 1);
  915.                                         if (empty($zNameSrvOrNameUsr)) {
  916.                                             $tempAcum->setName('Staff In Out Events: ' . $dtsp->getName());
  917.                                         }
  919.                                         //Si el dia de inicio es menor actualizas (para establecer rangos de varios dias)
  920. //                                        if ($dtsp->getDateInAt() < $tempAcum->getDateInAt()) {
  921. //                                            $tempAcum->setDateInAt($dtsp->getDateInAt());
  922. //                                        }
  923. //                                        //Si el dia de fin es mayor actualizas (para establecer rangos de varios dias)
  924. //                                        if ($dtsp->getDateOutAt() > $tempAcum->getDateOutAt()) {
  925. //                                            $tempAcum->setDateOutAt($dtsp->getDateOutAt());
  926. //                                        }
  928.                                         $arregloAcumulador[$dtsp->getName()] = $tempAcum;
  929.                                     } else {
  930.                                         $arregloAcumulador[$dtsp->getName()] = $dtsp;
  931.                                         if (empty($zNameSrvOrNameUsr)) {
  932.                                             $arregloAcumulador[$dtsp->getName()]->setName('Staff In Out Events: ' . $dtsp->getName());
  933.                                         }
  934.                                     }
  935.                                 }
  936.                             }
  937.                         }
  938.                     }
  939.                     //
  940.                     foreach ($arregloAcumulador as $aAc){
  941.                         $new_data_service_supplier[] = $aAc;
  942.                     }
  943.                     $data_service_supplier = $new_data_service_supplier;
  945.                 }
  946.                 // FIN  -  Agrupamos asistencias de In-Out por ID de Agente
  948.             }
  949.             $imagenSmall = null;
  951.             $service_supplier_data = array();
  952.             $totales_neto ='0';
  953.             $totales_iva ='0';
  954.             $totales_con_iva ='0';
  955.             $totales_paying ='0';
  956.             $totales_pago ='0';
  957.             $totales_benefit_moneda ='0';
  958.             $totales_benefit_porsentaje ='0';
  959.             foreach($data_service_supplier as $data_service){
  961. //                d($data_service->getId());
  962.                 //Currency
  963.                 $currency = $data_service->getCurrency();
  964.                 if (isset($currency)){$currency="Euro";}
  965.                 if ($currency == "Euro"){$currency="€";}
  966.                 if ($currency == "Dolar"){$currency=" $";}
  967.                 if ($currency == "MXN"){$currency=" MXN";}
  968.                 $data_service->setCurrency($currency);
  970.                 $idcat = $data_service->getServiceCatId();
  971.                 $price = ($data_service->getPrice() == "")? 0 : $data_service->getPrice();
  972.                 $units = ($data_service->getUnits() == "")? 0 : $data_service->getUnits();
  973.                 $pax = ($data_service->getPax() == "")? 0 : $data_service->getPax();
  974.                 $opcommission = $data_service->getOpCommission();
  975.                 $commission = $data_service->getCommission();
  976.                 $opover = $data_service->getOpOver();
  977.                 $over = $data_service->getOver();
  978.                 $opiva = $data_service->getOpIva();
  979. //                $iva = $data_service->getIva();
  980.                 $iva = empty($data_service->getIva())? 0 : $data_service->getIva();
  981.                 $dateInAt = $data_service->getDateInAt();
  982.                 $dateOutAt = $data_service->getDateOutAt();
  983.                 if (!is_null($dateInAt) and !is_null($dateOutAt)){
  984.                     $days = $dateInAt->diff($dateOutAt);
  985.                     $day = $days->days;
  986.                 }else{
  987.                     $day = "0";
  988.                 }
  989.                 if(!is_null($data_service->getActivityId())){
  990.                     $name_supplier = $em->getRepository(Activities::class)->findOneById($data_service->getActivityId());
  991.                     if (empty($name_supplier)){
  992.                         $namesupplier = '';
  993.                     }else{
  994.                         $namesupplier = $name_supplier->getName();
  995.                     }
  996.                 }
  998.                 if(!is_null($data_service->getIdeaId())){
  999.                     $name_supplier = $em->getRepository(Ideas::class)->findOneById($data_service->getIdeaId());
  1000.                     if (empty($name_supplier)){
  1001.                         $namesupplier = '';
  1002.                     }else{
  1003.                         $namesupplier = $name_supplier->getName();
  1004.                     }
  1005.                 }
  1007.                 if((!is_null($data_service->getSupplierId())) and ($data_service->getIdeaId() == null) and ($data_service->getActivityId() == null) ){
  1008.                     $name_supplier = $em->getRepository(Supplier::class)->findOneById($data_service->getSupplierId());
  1009.                     if (empty($name_supplier)){
  1010.                         $namesupplier = '';
  1011.                     }else{
  1012.                         $namesupplier = $name_supplier->getName();
  1013.                     }
  1015.                 }
  1018. //                $name_supplier = $em->getRepository(Supplier::class)->findOneById($data_service->getSupplierId());
  1019. //                $namesupplier = $name_supplier->getName();
  1021.                 if($type == 'No Vat Invoice'){
  1022.                     $iva="0";
  1023.                     $data_service->setIva($iva);
  1024.                 }
  1026.                 $calculos = $this->CalculoTotalesservices($price, $units, $pax, $day, $opcommission, $commission, $opover, $over, $opiva, $iva, $idcat);
  1027.                 $data_service->setPrice($calculos['precio']); //ojo aqui
  1028.                 $service_supplier_data[] = array(
  1029.                     'calculos' => $calculos,
  1030.                     'services_data' => $data_service,
  1031.                     'namesupplier' => $namesupplier
  1032.                 );
  1034.                 $totales_neto += $calculos['total_neto'];
  1035.                 $totales_iva += $calculos['sub_total_iva'];
  1036.                 $totales_con_iva += $calculos['total'];
  1037.                 $totales_paying += $calculos['total_paying'];
  1038.                 $totales_pago += $calculos['total_pago'];
  1039.                 $totales_benefit_moneda += $calculos['benefit_moneda'];
  1041.                 /* base imponible por servicios */
  1042.                 if (empty($base_imponible_service[$idcat])){
  1043.                     $base_imponible_service[$idcat]= 0;
  1044.                 }
  1045.                 $base_imponible_service[$idcat] += $calculos['total_neto'];
  1047.                 $data_serviceCat[$idcat] = array(
  1048.                     'idcat' => $idcat,
  1049.                     'total_neto' => $base_imponible_service[$idcat],
  1050.                 );
  1052.                 /* base impobnible detalles por diferentes Ivas */
  1053.                 if (empty($base_imponible_iva[$iva])){
  1054.                     $base_imponible_iva[$iva]= 0;
  1055.                 }
  1056.                 $base_imponible_iva[$iva] += $calculos['total_neto'];
  1058.                 if (empty($totales_ivas_all[$iva])){
  1059.                     $totales_ivas_all[$iva]= 0;
  1060.                 }
  1061.                 $totales_ivas_all[$iva] += $calculos['sub_total_iva'];
  1063.                 $totales_neto_all += $calculos['total_neto'];
  1064.                 $totales_all += $calculos['total'];
  1066.                 $data_iva[$iva] = array(
  1067.                     'iva' => $iva,
  1068.                     'ivas' => $totales_ivas_all[$iva],
  1069.                     'total_iva' => $base_imponible_iva[$iva]
  1070.                 );
  1071.                 if ($totales_benefit_moneda == '0'){
  1072.                     $totales_benefit_porsentaje =  '0';
  1073.                 }else{
  1074.                     if ($totales_neto != 0) {
  1075.                         $totales_benefit_porsentaje = $totales_benefit_moneda / $totales_neto * 100; // arreglado or esteban
  1076.                     } else {
  1077.                         $totales_benefit_porsentaje = 0;
  1078.                     }
  1079.                 }
  1080.             }
  1083.             $calculos_totatales = array(
  1084.                 'totales_neto' => $totales_neto,
  1085.                 'totales_iva' => $totales_iva,
  1086.                 'totales_con_iva' => $totales_con_iva,
  1087.                 'totales_paying' => $totales_paying,
  1088.                 'totales_benefit_moneda' => $totales_benefit_moneda,
  1089.                 'totales_benefit_porsentaje' => $totales_benefit_porsentaje
  1090.             );
  1092.             $data_supplier[$destination->getTitle()][] = array(
  1093.                 'master' => $master,
  1094.                 'colorlabel' => $colorlabel,
  1095.                 'control' => "1",
  1096.                 'supplier' => $sqlsuppliers,
  1097.                 'idea' => $sqlideas,
  1098.                 'activity' => $sqlactivities,
  1099.                 'image' => $imagenSmall,
  1100.                 'services' => $service_supplier_data,
  1101.                 'totales_services' => $calculos_totatales
  1102.             );
  1103.         }
  1104.         $totales_neto_antes = $totales_neto_all;
  1105.         $totales_antes = $totales_all;
  1108.         /*Group Everything*/
  1109.         if($type == 'Group Everything'){
  1110.             $data_supplier = array();
  1111.             $service_supplier_data = array();
  1112.             $messageitems = $this->translator->trans('Grouped Services');
  1114.             $data_service = array(
  1115.                 "price" => $totales_neto_antes,
  1116.                 "name" => $messageitems,
  1117.                 "units" => 1,
  1118.                 "iva" => $iva,
  1119.                 "dateInAt" => "2018-4-4",
  1120.                 "dateOutAt" => "2018-4-4",
  1121.             );
  1123.             $calculos = array(
  1124.                 "precio" => $totales_neto_antes,
  1125.                 "total_days" => 1,
  1126.                 "sub_total" => $totales_neto_antes,
  1127.                 "sub_total_iva" => 0,
  1128.                 "total_neto" => $totales_neto_antes,
  1129.                 "total_iva" => 0,
  1130.                 "total_paying" => 0,
  1131.                 "total_pago" => 0,
  1132.                 "total_comision" => "0",
  1133.                 "total" => $totales_antes,
  1134.                 "benefit_moneda" => 0,
  1135.             );
  1137.             $service_supplier_data[] = array(
  1138.                 'calculos' => $calculos,
  1139.                 'services_data' => $data_service,
  1140.                 'namesupplier' => ""
  1141.             );
  1143.             $calculos_totatales = array(
  1144.                 'totales_neto' => $totales_neto_antes,
  1145.                 'totales_iva' => "",
  1146.                 'totales_con_iva' => $totales_antes,
  1147.                 'totales_paying' => "",
  1148.                 'totales_benefit_moneda' => "",
  1149.                 'totales_benefit_porsentaje' => ""
  1150.             );
  1152.             $data_supplier[$messageitems][] = array(
  1153.                 'master' => '',
  1154.                 'colorlabel' => '',
  1155.                 'control' => "1",
  1156.                 'supplier' => '',
  1157.                 'idea' => '',
  1158.                 'activity' => '',
  1159.                 'image' => '',
  1160.                 'services' => $service_supplier_data,
  1161.                 'totales_services' => $calculos_totatales
  1162.             );
  1163.         }
  1165.         $data_serviceOut = array(
  1166.             'idcat' => null,
  1167.             'total_neto' => $totales_neto_all,
  1168.         );
  1169. //        d($data_serviceCat,$data_serviceOut);
  1170.         array_push ( $data_serviceCat, $data_serviceOut );
  1172.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('1');
  1174.         $parameters = array(
  1175.             'id' => $proposal->getclientId(),
  1176.         );
  1177.         $dql = 'SELECT cl,  c.country, re.region, p.name, r.city
  1178.                 FROM App:Client cl
  1179.                 INNER JOIN App:Country c WITH c.id = cl.country
  1180.                 INNER JOIN App:Regions re WITH re.id = cl.region
  1181.                 INNER JOIN App:Provinces p WITH p.id = cl.province
  1182.                 INNER JOIN App:Cities r WITH r.id = cl.population
  1183.                 WHERE cl.id = :id';
  1185.         $query = $em->createQuery($dql)->setParameters($parameters);
  1186.         $client = $query->getResult();
  1188. //        d($data_iva);
  1190.         $data_invoice = array();
  1191.         $inv_neto_total = 0;
  1192.         $inv_total = 0;
  1193.         $invoice_deposit_control = $em->getRepository(ProposalInvoiceDepositControl::class)->findByProposalId($proposal->getId());
  1194.         if (!empty($invoice_deposit_control)){
  1195.             foreach($invoice_deposit_control as $invoicedepositcontrol) {
  1196.                 $data_items_inv = array();
  1197.                 $invoice_deposit_items = $em->getRepository(ProposalInvoiceDepositItems::class)->findByControlId($invoicedepositcontrol->getId());
  1198.                 foreach($invoice_deposit_items as $invoicedeposititems) {
  1199.                     $invamount = $invoicedeposititems->getAmount();
  1200.                     $invamount_iva = $invoicedeposititems->getIva();
  1201.                     $invamount_el_iva = $invamount * ($invamount_iva / 100);
  1202.                     $invamount_con_iva = $invamount * (($invamount_iva / 100) + 1 );
  1204.                     $inv_neto_total += $invamount;
  1205.                     $inv_total += $invamount_con_iva;
  1207.                     if (is_null($invoicedepositcontrol->getNumber())){
  1208.                         $numInvoice = $invoicedepositcontrol->getId();
  1209.                     }else{
  1210.                         $numInvoice = $invoicedepositcontrol->getNumber();
  1211.                     }
  1213.                     $data_items_inv[] = array(
  1214.                         'numInvoice' => $numInvoice,
  1215.                         'name' => $invoicedeposititems->getName(),
  1216.                         'amount' => $invoicedeposititems->getAmount(),
  1217.                         'iva' => $invoicedeposititems->getIva(),
  1218.                         'ivaamount' => $invamount_el_iva,
  1219.                         'total' => $invamount_con_iva,
  1220.                     );
  1222.                     foreach($data_iva as $items_iva) {
  1223.                         if ($items_iva['iva'] == $invoicedeposititems->getIva()){
  1224.                             $new_iva = $items_iva['iva'];
  1225.                             $new_ivas = $items_iva['ivas'] - $invamount_el_iva;
  1226.                             $new_total_iva = $items_iva['total_iva'] - $invoicedeposititems->getAmount();
  1228.                             $new_data_iva = array(
  1229.                                 'iva' => $new_iva,
  1230.                                 'ivas' => $new_ivas,
  1231.                                 'total_iva' => $new_total_iva
  1232.                             );
  1233.                             $data_iva = array_replace($data_iva, array( $new_iva => $new_data_iva ));
  1234.                         }
  1235.                     }
  1239.                 }
  1241.                 $data_invoice[] = array(
  1242.                     'itemsInvoice' => $data_items_inv,
  1243.                 );
  1244.             }
  1248. //            d($inv_neto_total, $inv_total);
  1249.             $totales_neto_all = $totales_neto_all - $inv_neto_total;
  1250.             $totales_all = $totales_all - $inv_total;
  1251. //            d($totales_neto_all, $totales_all);
  1252.         }
  1254. //        d($data_invoice, $data_iva);
  1255. //        d($data_iva);
  1259.         $consulta_discount = $em->getRepository(ProposalDiscount::class)->findByProposalId($id);
  1260.         $cuantosdiscount = count($consulta_discount);
  1262. //
  1263. //
  1264. //        if (!empty($consulta_discount)){
  1265. //            $descuento =array();
  1266. //            $name ="";
  1267. //            $amount = "";
  1268. //            $type_des = "";
  1269. //            $iva_discount="";
  1270. //            $totales_generales="";
  1271. //            $totales_neto_des = $totales_neto_all;
  1272. //            $calculo_net_negativo="";
  1273. //            $total_con_iva_desc="";
  1274. //
  1275. //            foreach($consulta_discount as $consultadiscount) {
  1276. //
  1277. //                $iva = $consultadiscount->getIva() / 100;
  1278. //                if ($consultadiscount->getType()=="0"){
  1279. //                    $por = $consultadiscount->getAmount() / 100;
  1280. //                    $totales_neto_des = $totales_neto_des / ($por + 1) ;
  1281. //
  1282. //                    $name = $consultadiscount->getName();
  1283. //                    $type_des = $consultadiscount->getType();
  1284. //                    $amount = $consultadiscount->getAmount();
  1285. //                }
  1286. //
  1287. //
  1288. //                if ($consultadiscount->getType()=="1"){
  1289. //                    $totales_neto_des = $totales_neto_des - $consultadiscount->getAmount();
  1290. //                    $name = $consultadiscount->getName();
  1291. //                    $type_des = $consultadiscount->getType();
  1292. //                    $amount = $consultadiscount->getAmount();
  1293. //                }
  1294. //
  1295. //                // resultados en negativo
  1296. //                $calculo_net_negativo =  $totales_neto_des - $totales_neto_all;
  1297. //
  1298. //                $total_desc = "0";
  1299. //                // resultados para calculos
  1300. //                $calculo_net = $totales_neto_all - $totales_neto_des;
  1301. //                if($consultadiscount->getOpIva() =='0'){
  1302. //                    $iva_discount = $calculo_net - ($calculo_net / ($iva + 1));
  1303. //                    $calculo_net_negativo = $calculo_net_negativo + $iva_discount;
  1304. //                    $totales_neto_des = $totales_neto_des + $iva_discount;
  1305. //                    $total_desc = $iva_discount;
  1306. //                }
  1307. //                if($consultadiscount->getOpIva() =='1'){
  1308. //                    $iva_discount = $calculo_net * $iva;
  1309. //                    $total_desc = $iva_discount;
  1310. //                }
  1311. //
  1312. //                if($type == 'No Vat Invoice'){
  1313. //                    $iva_discount = "0";
  1314. //                }
  1315. //                // resultados en negativo
  1316. ////                $calculo_net_negativo =  $totales_neto_des - $totales_neto_all;
  1317. //
  1318. //                $total_con_iva_desc = $calculo_net_negativo - $iva_discount;
  1319. //
  1320. //
  1321. //                $operacion = $totales_all - $totales_neto_all;
  1322. //                $totales_generales = $totales_neto_des + $operacion - $total_desc;
  1323. //
  1324. //
  1325. //
  1326. //                $descuento[] = array(
  1327. //                    'name' => $name,
  1328. //                    'type' => $type_des,
  1329. //                    'amount' => $amount,
  1330. //                    'iva' => $consultadiscount->getIva(),
  1331. //                    'totales_neto_des' => $calculo_net_negativo,
  1332. //                    'total' => $total_con_iva_desc,
  1333. //                );
  1334. //
  1335. //                $totales_neto_all = $totales_neto_des;
  1336. //                $totales_all = $totales_generales;
  1337. //
  1338. //            }
  1339. //        }
  1341.         $totales_generales="";
  1342.         $descuento =array();
  1343.         if (!empty($consulta_discount)){
  1344. //            d($data_serviceCat);
  1345.             $quitar_en_todos = 0;
  1346.             $datos_total_neto_suma = 0;
  1348.             foreach($data_serviceCat as $dataserviceat) {
  1349.                 $name ="";
  1350.                 $amount = "";
  1351.                 $type_des = "";
  1352.                 $iva_discount="";
  1353.                 $datos_idcat = $dataserviceat['idcat'];
  1354.                 $datos_total_neto = $dataserviceat['total_neto'];
  1356.                 $totales_neto_des = $datos_total_neto;
  1357.                 $datosiva_neto_des = $datos_total_neto;
  1358.                 $calculo_net_negativo="";
  1359.                 $total_con_iva_desc="";
  1360.                 $contarveces = 1;
  1361.                 foreach($consulta_discount as $consultadiscount) {
  1363.                     if($dataserviceat['idcat'] == null){
  1364.                         if($contarveces > 1 ){
  1365.                             $totales_neto_des = $datos_total_neto_suma;
  1366.                             $datosiva_neto_des = $datos_total_neto_suma;
  1367.                             $datos_total_neto = $datos_total_neto_suma;
  1368.                         }else{
  1369.                             if($cuantosdiscount > 1){
  1370.                                 $totales_neto_des = $dataserviceat['total_neto'] - $quitar_en_todos;
  1371.                                 $datosiva_neto_des = $dataserviceat['total_neto'] - $quitar_en_todos;
  1372.                                 $datos_total_neto = $dataserviceat['total_neto'] - $quitar_en_todos;
  1373.                             }
  1374.                         }
  1375.                         $contarveces += 1;
  1376.                     }
  1379.                     if ($dataserviceat['idcat'] == $consultadiscount->getServiceId()){
  1381.                         $iva = $consultadiscount->getIva() / 100;
  1382.                         if ($consultadiscount->getType()=="0"){
  1383.                             $por = $consultadiscount->getAmount() / 100;
  1385. //                            $datosiva_neto_des = $datosiva_neto_des / ($por + 1) ;
  1386.                             $datosiva_neto_des = $datosiva_neto_des - ($datosiva_neto_des * $por) ;
  1388.                             $name = $consultadiscount->getName();
  1389.                             $type_des = $consultadiscount->getType();
  1390.                             $amount = $consultadiscount->getAmount();
  1391.                         }
  1393.                         if ($consultadiscount->getType()=="1"){
  1394.                             $datosiva_neto_des = $datosiva_neto_des - $consultadiscount->getAmount();
  1396.                             $name = $consultadiscount->getName();
  1397.                             $type_des = $consultadiscount->getType();
  1398.                             $amount = $consultadiscount->getAmount();
  1399.                         }
  1400. //                        d($dataserviceat['idcat'], $datos_total_neto);
  1403.                         // resultados en negativo
  1404.                         $calculo_net_negativo =  $datosiva_neto_des - $datos_total_neto;
  1405. //                        d($calculo_net_negativo);
  1407.                         $total_desc = "0";
  1408.                         // resultados para calculos
  1409.                         $calculo_net = $datos_total_neto - $datosiva_neto_des;
  1410.                         if($consultadiscount->getOpIva() =='0'){
  1411.                             $iva_discount = $calculo_net - ($calculo_net / ($iva + 1));
  1412.                             $calculo_net_negativo = $calculo_net_negativo + $iva_discount;
  1413.                             $totales_neto_des = $totales_neto_des + $iva_discount;
  1414.                             $total_desc = $iva_discount;
  1415.                         }
  1416.                         if($consultadiscount->getOpIva() =='1'){
  1417.                             $iva_discount = $calculo_net * $iva;
  1418.                             $total_desc = $iva_discount;
  1419.                         }
  1421.                         if($type == 'No Vat Invoice'){
  1422.                             $iva_discount = "0";
  1423.                         }
  1425. //                        if($dataserviceat['idcat'] == null){
  1426.                         $datos_total_neto_suma = $datos_total_neto- abs($calculo_net_negativo);
  1428. //                        }
  1430.                         $quitar_en_todos = $quitar_en_todos + abs($calculo_net_negativo);
  1431. //                        d($datosiva_neto_des, $calculo_net_negativo);
  1432. //                        $datosiva_neto_des = $datosiva_neto_des + $calculo_net_negativo;
  1433. //                        d($quitar_en_todos);
  1435.                         $total_con_iva_desc = $calculo_net_negativo - $iva_discount;
  1437.                         $totales_neto_all = $totales_neto_all - abs($calculo_net_negativo);
  1438.                         $totales_all = $totales_all - abs($total_con_iva_desc);
  1440.                         $descuento[] = array(
  1441.                             'name' => $name,
  1442.                             'type' => $type_des,
  1443.                             'amount' => $amount,
  1444.                             'iva' => $consultadiscount->getIva(),
  1445.                             'iva_amount' => $iva_discount,
  1446.                             'totales_neto_des' => $calculo_net_negativo,
  1447.                             'total' => $total_con_iva_desc,
  1448.                         );
  1450.                         // Nueva actualizacion 17-07-2019 Recalcular Ivas
  1451.                         foreach($data_iva as $items_iva) {
  1452.                             if ($items_iva['iva'] == $consultadiscount->getIva()){
  1453.                                 $new_iva = $items_iva['iva'];
  1454.                                 $new_ivas = $items_iva['ivas'] - $iva_discount;
  1455.                                 $new_total_iva = $items_iva['total_iva'] - $iva_discount;
  1457.                                 $new_data_iva = array(
  1458.                                     'iva' => $new_iva,
  1459.                                     'ivas' => $new_ivas,
  1460.                                     'total_iva' => $new_total_iva
  1461.                                 );
  1462.                                 $data_iva = array_replace($data_iva, array( $new_iva => $new_data_iva ));
  1463.                             }
  1464.                         }
  1467.                     }
  1469.                 }
  1471.             }
  1472.         }
  1474. //        d($descuento);
  1475. //        d($data_iva);
  1480.         $payments = $em->getRepository(ProposalPaymentsClient::class)->findByProposalId($id);
  1481.         $amount_pay = 0;
  1482.         foreach($payments as $payment) {
  1483.             $amount_pay = $amount_pay + $payment->getAmount();
  1484.         }
  1486.         $totales_all = round($totales_all,2);
  1487.         $totales_total = $totales_all;
  1488.         if (!empty($payments)){
  1489.             $totales_all = $totales_all - $amount_pay;
  1490.         }
  1493.         //Si hay uno o varios depositos previos el IVA debe ser calculado en funcion de totales_neto = totales_neto_antes - amount
  1494. //        $adelanto = 0;
  1495. //        if(sizeof($data_invoice)!=0){
  1496. //            foreach ($data_invoice as $pago_previo){
  1497. //                foreach ($pago_previo as $adel){
  1498. //                    foreach ($adel as $ade){
  1499. //                        $adelanto = $adelanto + $ade['amount'];
  1500. //                    }
  1501. //                }
  1502. //            }
  1503. //        }
  1504. //
  1505. //        if ($adelanto != 0){
  1506. //            $new_data_iva = null;
  1507. //            $new_iva = number_format($totales_neto_antes, 2, '.','') - number_format($adelanto, 2, '.','');
  1508. //            $new_iva = $new_iva * $data_iva['21']['iva'];
  1509. //            $new_iva =$new_iva/100;
  1510. //            $new_iva = number_format($new_iva, 2, '.','');
  1511. //            foreach ($data_iva as $dativ){
  1512. //                $dativ['ivas'] = $new_iva;
  1513. //                $new_data_iva['21'] = $dativ;
  1514. //            }
  1515. //
  1516. //            $data_iva = $new_data_iva;
  1517. //
  1518. //        }
  1520.         $data = array(
  1521.             'id' => $id,
  1522.             'type' => $type,
  1523.             'number' => $number,
  1524.             'prefix' => $prefix,
  1525.             'date' => $date,
  1526.             'token' => $proposal->getAccessKey(),
  1527.             'proposal' => $proposal,
  1528.             'company' => $company,
  1529.             'clients' => $client,
  1530.             'datasupplier' => $data_supplier,
  1531.             'totales_neto_antes' => $totales_neto_antes,
  1532.             'totales_neto' => $totales_neto_all,
  1533.             'totales_generales' => $totales_generales,
  1534.             'bases_imponibles' => $data_iva,
  1535.             'totales_antes' => $totales_antes,
  1536.             'totales' => $totales_total,
  1537.             'balance' => $totales_all,
  1538.             'currency' => $currency,
  1539.             'paymentInvoice' => $amount_pay,
  1540.             'discounts' => $descuento,
  1541.             'invoiceDesposit' => $data_invoice,
  1542.         );
  1544. // ************************************************  FEE    ************************************************************
  1545.         $fees = $em->getRepository(ProposalFee::class)->findByProposalId($id);
  1546.         $feesInvoice = $em->getRepository(ProposalFeeInvoice::class)->findByProposalId($id);
  1548.         if (!empty($feesInvoice)) {
  1549.             // Fee en factura
  1550.             // Solo se haran los calculos si el Fee va a la factura, en caso contrario es un fee oculto y ya estará cargado en los servicios
  1551.             if ($feesInvoice[0]->getToinvoice() == true) {
  1552.                 foreach ($feesInvoice as $feeInv) {
  1553.                     if ($feeInv->getType() == 0) {
  1554.                         // Tenemos un porcentaje en el Fee de la factura, debe calcularse
  1555.                         $feeNet = ($data['totales_neto_antes'] * $feeInv->getAmount()) / 100;
  1556.                     } else {
  1557.                         $feeNet = $feeInv->getAmount();
  1558.                     }
  1560.                     $feeTotal = $feeNet * 1.21;                     //El fee siempre será al 21%, Esteban Rincón
  1562.                     if ($feeInv->getToInvoice() == true) {
  1563.                         $data['totales_neto'] += $feeNet;
  1564.                         $data['totales'] += $feeTotal;
  1565.                         $data['balance'] += $feeTotal;
  1566.                         if (array_key_exists('21', $data['bases_imponibles'])) {
  1567.                             $data['bases_imponibles']['21']['ivas'] += $feeNet * 0.21;
  1568.                             $data['bases_imponibles']['21']['total_iva'] += $feeNet;
  1569.                         } else {
  1570.                             $data['bases_imponibles']['21']['iva'] = '21';
  1571.                             $data['bases_imponibles']['21']['ivas'] = $feeNet * 0.21;
  1572.                             $data['bases_imponibles']['21']['total_iva'] = $feeNet;
  1573.                         }
  1574.                     }
  1576.                     if ($feeInv->getFeeNet() == 0 or empty($feeInv->getFeeNet())) {
  1577.                         // La asignación solo se hace la primera vez
  1578.                         $feeInv->setFeeNet($feeNet);
  1579.                         $feeInv->setFeeTotal($feeTotal);
  1581.                         $em->persist($feeInv);
  1582.                         $em->flush();
  1583.                     }
  1584.                 }
  1585.             }
  1586.         } else {
  1587.             // Fee en proforma
  1588.             if (!empty($fees)) {
  1589.                 // Solo se haran los calculos si el Fee va a la factura, en caso contrario es un fee oculto y ya estará cargado en los servicios
  1590.                 if ($fees[0]->getToinvoice() == true) {
  1591.                     foreach ($fees as $fee) {
  1592.                         if ($fee->getType() == 0) {
  1593.                             // Tenemos un porcentaje, debe calcularse
  1594.                             $amount = ($data['totales_neto_antes'] * $fee->getAmount()) / 100;
  1595.                             $fee->setAmount($amount);
  1596.                         }
  1597.                         $fee->setFeeTotal($fee->getAmount() * 1.21);        //El fee siempre será al 21%, Esteban Rincón
  1598.                         if ($fee->getToInvoice() == true) {
  1599.                             $data['totales_neto'] += $fee->getAmount();
  1600.                             $data['totales'] += $fee->getFeeTotal();
  1601.                             $data['balance'] += $fee->getFeeTotal();
  1602.                             if (array_key_exists('21', $data['bases_imponibles'])) {
  1603.                                 $data['bases_imponibles']['21']['ivas'] += $fee->getAmount() * 0.21;
  1604.                                 $data['bases_imponibles']['21']['total_iva'] += $fee->getAmount();
  1605.                             } else {
  1606.                                 $data['bases_imponibles']['21']['iva'] = '21';
  1607.                                 $data['bases_imponibles']['21']['ivas'] = $fee->getAmount() * 0.21;
  1608.                                 $data['bases_imponibles']['21']['total_iva'] = $fee->getAmount();
  1609.                             }
  1610.                         }
  1611.                     }
  1612.                 }
  1613.             }
  1614.         }
  1615. // ************************************************  FEE    ************************************************************
  1617.         return $data;
  1618.     }
  1621.     public function CalculoTotalesservices($price, $units, $pax, $days, $opcommission, $commission, $opover, $over, $opiva, $iva, $idcat)
  1622.     {
  1623.         $price = trim($price);
  1624.         $over = trim($over);
  1625.         $price = str_replace(",", ".", $price);
  1626.         $over = str_replace(",", ".", $over);
  1628.         if (empty($iva)){$iva=0;}
  1629.         $iva = $iva / 100;
  1630.         if($opiva =='0'){
  1631.             $price = $price / ($iva + 1);
  1632.         }
  1634.         if(!empty($commission)){
  1635.             if($opcommission=='0'){
  1636.                 $commission = (100 - $commission) / 100;
  1637.                 $precio_units = $price;
  1638.                 $price = $price * $commission;
  1639.             }
  1641.             if($opcommission=='1'){
  1642.                 $commission = ($commission / 100) + 1;
  1643.                 $precio_units = $price * $commission;
  1644.             }
  1645.         }else{
  1646.             $precio_units = $price;
  1647.         }
  1649.         //Units
  1650.         if(empty($units) or $units =="0"){
  1651.             $units = "1";
  1652.         }
  1654.         // Calculo Especial por categoria
  1655.         //Alojamientos
  1656.         if($idcat =="1"){
  1657.             $informativo_days = "si";
  1658.             $pax = "1";
  1659.         }
  1660.         //Transporte
  1661.         elseif($idcat =="13"){
  1662.             $informativo_days = "no";
  1663.             $pax = "1";
  1664.             //            if($days > "1"){
  1665.             //                $days = "2";
  1666.             //            }else{
  1667.             //                $days = "1";
  1668.             //            }
  1669.         }
  1670.         //Lounge
  1671.         elseif($idcat =="10"){
  1672.             $informativo_days = "no";
  1673.             $pax = "1";
  1674.         }
  1675.         //Guia
  1676.         elseif($idcat =="8"){
  1677.             $informativo_days = "no";
  1678.             $pax = "1";
  1679.         }
  1680.         //Asistencia
  1681.         elseif($idcat =="15"){
  1682.             $informativo_days = "no";
  1683.             $days = '0';
  1684.         }else{
  1685.             $informativo_days = "no";
  1686.         }
  1689.         //Pax
  1690.         if(empty($pax) or $pax =="0"){
  1691.             $pax = "1";
  1692.         }
  1694.         //Over
  1695.         if(empty($over)){
  1696.             $over = "0";
  1697.         }
  1699.         if($informativo_days =="no"){
  1700.             //Days
  1701.             if(empty($days) or $days =="0"){
  1702.                 $days = "1";
  1703.             }else{
  1704.                 $days = $days + 1 ;
  1705.             }
  1706.         }
  1708.         $total_items = $price * $units * $pax * $days;
  1709. //        $total_pdirect = $price * $units * $pax * $days;
  1711.         $total_over = $over * $units * $pax * $days;
  1713. //        if($opover=='0'){
  1714. //            $total_neto = $total_items / $commission - $total_over ;
  1715. //            $precio_units = $precio_units - $over;
  1716. //        }
  1717. //        if($opover=='1'){
  1718. //            $total_neto = $total_items / $commission + $total_over;
  1719. //            $precio_units = $precio_units + $over;
  1720. //        }
  1722.         if(!empty($commission)){
  1723.             if($opcommission=='0'){
  1724.                 $total_neto = $total_items / $commission;
  1725.             }
  1726.             if($opcommission=='1'){
  1727.                 $total_neto = $total_items * $commission;
  1728.             }
  1729.         }else{
  1730.             $total_neto = $total_items;
  1731.         }
  1733.         if($opover=='0'){
  1734.             $total_neto = $total_neto - $total_over ;
  1735.             $precio_units = $precio_units - $over;
  1736.         }
  1737.         if($opover=='1'){
  1738.             $total_neto = $total_neto +  $total_over;
  1739.             $precio_units = $precio_units + $over;
  1740.         }
  1744.         $total_paying = $total_items * ($iva + 1);
  1746.         $total_comision ="0";
  1747.         $total_pago = $total_items;
  1748.         $total_iva = $total_items * $iva;
  1749.         $sub_total_iva = $total_neto * $iva;
  1751.         $total = $total_neto + $sub_total_iva;
  1753.         $benefit_moneda = $total_neto - $total_items;
  1755.         $data_calculos = array(
  1756.             'precio' => $precio_units,
  1757.             'total_days' => $days,
  1758.             'sub_total' => $total_items,
  1759.             'sub_total_iva' => $sub_total_iva,
  1760.             'total_neto' => $total_neto,
  1761.             'total_iva' => $total_iva,
  1762.             'total_paying' => $total_paying,
  1763.             'total_pago' => $total_pago,
  1764.             'total_comision' => $total_comision,
  1765.             'total' => $total,
  1766.             'benefit_moneda' => $benefit_moneda
  1767.         );
  1769.         return $data_calculos;
  1770.     }
  1773.     /**
  1774.      * @Route("/proposal/invoice/number/{id}", name="proposal_invoice_number")
  1775.      */
  1776.     public function InvoiceEmptyNumberAction($id, Request $request) {
  1778.         $em = $this->getDoctrine()->getManager();
  1779.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  1780.         $invoice = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  1781.         $client = $em->getRepository(Client::class)->findOneById($proposal->getClientId());
  1783.         $country = $em->getRepository(Country::class)->findOneById($client->getCountry());
  1784.         $client->setCountry($country->getCountry());
  1786.         $regions = $em->getRepository(Regions::class)->findOneById($client->getRegion());
  1787.         $client->setRegion($regions->getRegion());
  1789.         $province = $em->getRepository(Provinces::class)->findOneById($client->getProvince());
  1790.         $client->setProvince($province->getName());
  1792.         $cities = $em->getRepository(Cities::class)->findOneById($client->getPopulation());
  1793.         $client->setPopulation($cities->getCity());
  1796.         return $this->render('MDS/EventsBundle/invoice/add-number-invoice.html.twig', array(
  1797.             'id' => $id,
  1798.             'invoice' => $invoice,
  1799.             'mcp' => $proposal->getMcp(),
  1800.             'token' => $proposal->getAccessKey(),
  1801.             'proposal' => $proposal,
  1802.             'client' => $client,
  1803.         ));
  1805.     }
  1807.     /**
  1808.      * @Route("/proposal/invoice/number/updated/{id}", name="proposal_invoice_number_update")
  1809.      */
  1810.     public function InvoiceEmptyNumberupdateAction($id, Request $request)
  1811.     {
  1812.         $em = $this->getDoctrine()->getManager();
  1813.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  1814.         $invoice = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  1816.         $numberinvoice = $request->request->get('invoice')['number'];
  1817.         $dateAt = new \DateTime($request->request->get('invoice')['dateAt']);
  1819.         if(!empty($numberinvoice))
  1820.         {
  1821.             $invoice->setNumber($numberinvoice);
  1822.             $invoice->setDateAt($dateAt);
  1824.             // Envio correo al agente para informar que fue colocado el numero de factura
  1826.             $time = new \DateTime("now");
  1827.             $agent = $em->getRepository(User::class)->findOneById($proposal->getAgentId());
  1828.             $mailAgent[] = $agent->getEmail();
  1829.             $agentMail = $agent->getEmail();
  1830.             $passGmail = $agent->getPassGmail();
  1831.             $firmGmail = $agent->getFirmGmail();
  1832.             $mailAgentSent = array(
  1833.                 $agent->getEmail() => $agent->getName().' '. $agent->getLastName()
  1834.             );
  1836.             $body = 'P#'.$proposal->getId().', '.$proposal->getTitle().'<br>
  1837.                         <a href="http://'.$request->server->get('HTTP_HOST').'/events/events/proposal/edit/'.$proposal->getId().'">Ir al Proposal</a> - 
  1838.                         <a href="http://'.$request->server->get('HTTP_HOST').'/events/proposal/invoice/'.$proposal->getId().'">Ver Factura</a><br>
  1839.                         <br>Alerta de Fatura activada: '.$time->format('d/m/Y H:i:s').'<br><br>';
  1841.             $data = array(
  1842.                 'body' => $body,
  1843.                 'firm' => $firmGmail,
  1844.             );
  1846.             $mailTodos = array_merge($mailAgent);
  1848.             // EJECUTAR ENVIO DE ALERTA DE VISTO POR CLIENTE
  1849.             $transporter = new Swift_SmtpTransport();
  1850.             $transporter->setHost('smtp.gmail.com')
  1851.                 ->setEncryption('ssl') //ssl / tls
  1852.                 ->setPort(465) // 465 / 587
  1853.                 ->setUsername($agentMail)
  1854.                 ->setPassword($passGmail);
  1855.             //                        ->setUsername('desarrollo@develup.solutions')
  1856.             //                        ->setPassword('MeDITeRRANeAN_Develup30102023#');
  1857.             $mailer = new Swift_Mailer($transporter);
  1859.             $message = new Swift_Message();
  1860.             $message->setSubject('P#'.$proposal->getId().', Alerta de Fatura activada.')
  1861.                 ->setSender($agentMail)
  1862.                 ->setFrom($mailAgentSent)
  1863.                 ->setReplyTo($mailAgentSent)
  1864.                 ->setTo($mailTodos)
  1865.                 ->setBody(
  1866.                     $this->renderView(
  1867.                         'mail/structure-mail.html.twig',
  1868.                         array('data' => $data)
  1869.                     ),
  1870.                     'text/html'
  1871.                 )
  1872.             ;
  1873.             $mailer->send($message);
  1876.             /* Obtengo usuario logueado */
  1877.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1878.             $user_id = $user_logueado->getId();
  1880.             $proposal->setUpdatedId($user_id);
  1882.             $em->persist($invoice);
  1883.             $em->persist($proposal);
  1884.             $em->flush();
  1885.             $event = 'The Invoice has been Updated. Now';
  1887.             $successMessage = $this->translator->trans($event);
  1888.             $this->addFlash('mensajeproposaldestination', $successMessage);
  1891.         }else{
  1892.             $errorMessage = $this->translator->trans('Error, some fields are empty');
  1893.             $this->addFlash('mensajeproposaldestinationerror', $errorMessage);
  1894.         }
  1896.         return $this->redirectToRoute('proposal_invoice_number',
  1897.             array(
  1898.                 'id' => $id
  1899.             )
  1900.         );
  1901.     }
  1903.     /**
  1904.      * @Route("/proposal/invoice/number/liberate/{id}", name="proposal_invoice_number_liberate")
  1905.      */
  1906.     public function InvoiceEmptyNumberliberateAction($id, Request $request)
  1907.     {
  1908.         $em = $this->getDoctrine()->getManager();
  1909.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  1910.         $proposal->setStatus('Confirmed');
  1911.         $em->persist($proposal);
  1913.         $invoice = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  1914.         $em->remove($invoice);
  1915.         $em->flush();
  1916.         $event = 'The Invoice has been Liberate. Now';
  1918.         $successMessage = $this->translator->trans($event);
  1919.         $this->addFlash('mensajeproposaldestination', $successMessage);
  1921.         $feesInvoice = $em->getRepository(ProposalFeeInvoice::class)->findOneByProposalId($id);
  1922.         if (!empty($feesInvoice)){
  1923.             $em->remove($feesInvoice);
  1924.             $em->flush();
  1925.         }
  1927.         return $this->redirectToRoute('proposal_invoice_number',
  1928.             array(
  1929.                 'id' => $id
  1930.             )
  1931.         );
  1932.     }
  1934.     // Funcion para insertar historico de seguimiento
  1935.     // $textHistory = $this->translator->trans('');
  1936.     // $history = $this->TracingHistoryOperations($proposal->getId(), $text);
  1937.     private function TracingHistoryOperations($id, $text)
  1938.     {
  1939.         $em = $this->getDoctrine()->getManager();
  1940.         /* Obtengo usuario logueado */
  1941.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1942.         $user_id = $user_logueado->getId();
  1944.         $history = new ProposalTracing();
  1945.         $history->setDateAt(new \DateTime('now'));
  1946.         $history->setText($text);
  1947.         $history->setAgentId($user_id);
  1948.         $history->setProposalId($id);
  1949.         $history->setViewed('no');
  1950.         $history->setCreatedId($user_id);
  1951.         $history->setUpdatedId($user_id);
  1952.         $em->persist($history);
  1953.         $em->flush();
  1955.         $success = 'success';
  1956.         return $success;
  1957.     }
  1960. }