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

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\ProposalsStatistics;
  16. use App\Entity\Configuration;
  17. use App\Entity\Country;
  18. use App\Entity\Destination;
  19. use App\Entity\Ideas;
  20. use App\Entity\ProposalsInvoiceSummary;
  21. use App\Entity\Provinces;
  22. use App\Entity\Regions;
  23. use App\Entity\SettingsCompany;
  24. use App\Entity\SettingsRol;
  25. use App\Entity\Supplier;
  26. use App\Entity\User;
  27. use App\MDS\EventsBundle\Entity\Proposal;
  28. use App\MDS\EventsBundle\Entity\ProposalDiscount;
  29. use App\MDS\EventsBundle\Entity\ProposalFee;
  30. use App\MDS\EventsBundle\Entity\ProposalFeeInvoice;
  31. use App\MDS\EventsBundle\Entity\ProposalInvoice;
  32. use App\MDS\EventsBundle\Entity\ProposalInvoiceDepositControl;
  33. use App\MDS\EventsBundle\Entity\ProposalInvoiceDepositItems;
  34. use App\MDS\EventsBundle\Entity\ProposalPaymentsClient;
  35. use App\MDS\EventsBundle\Entity\ProposalProforma;
  36. use App\MDS\EventsBundle\Entity\ProposalsSupplierServicesAssistantName;
  37. use App\MDS\EventsBundle\Entity\ProposalSupplierServicesCostsClient;
  38. use App\MDS\EventsBundle\Entity\ProposalTracing;
  39. use App\MDS\EventsBundle\Form\ProposalPaymentsClientType;
  40. use Doctrine\ORM\EntityManagerInterface;
  41. use Swift_Mailer;
  42. use Swift_Message;
  43. use Swift_SmtpTransport;
  44. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  45. use Symfony\Component\Routing\Annotation\Route;
  46. use Symfony\Component\HttpFoundation\Request;
  47. use Symfony\Component\HttpFoundation\Response;
  48. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  49. use Symfony\Contracts\Translation\TranslatorInterface;
  52. class ProposalInvoiceController extends AbstractController
  53. {
  54.     private $translator;
  56.     public function __construct(TranslatorInterface $translator) {
  57.         $this->translator = $translator;
  58.     }
  60.     /*
  61.     * ATENCION LAS RAIZ DE @Route POR DEFECTO DEL BUNDLE: EventsBundle ES  /events/, NO PONERLO EN LA @Route("")
  62.     *
  63.     * */
  65.     /**
  66.      * @Route("/proposal/invoice/{id}",  name="proposal_invoice_detector")
  67.      */
  68.     public function detectorInvoiceAction($id, Request $request, EntityManagerInterface $em)
  69.     {
  70.         $invoiceconsulta= [];
  71.         $typeconsulta ='';
  73.         $invoice = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  74.         if (!empty($invoice)){
  75.             $invoiceconsulta = $invoice;
  76.             $typeconsulta = $invoice->getType();
  77.         }
  79.         if (!empty($invoiceconsulta)){
  80.             $type = $typeconsulta;
  81. //            $number = $invoiceconsulta->getId();
  82.             $number = $invoiceconsulta->getNumber();
  83.             $date = $invoiceconsulta->getDateAt();
  84.             $prefix = $invoiceconsulta->getPrefix();
  86.             /* Obtengo usuario logueado */
  87.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  88.             $user_id = $user_logueado->getId();
  90.             $data = $this->baseInvoiceProposal($id, $type, $number, $prefix, $date, $request);
  91.             $token = $data['token'];
  93.             $em->clear();
  94.             $invoice_query = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  95.             $invoice_query->setTotalnet($data['totales_neto']);
  96.             $invoice_query->setVat(serialize($data['bases_imponibles']));
  97.             $invoice_query->setTotal($data['totales']);
  98.             $em->persist($invoice_query);
  99.             $em->flush();
  101.         }else{
  102.             return $this->redirectToRoute('proposal_generate_proforma',
  103.                 array(
  104.                     'id' => $id
  105.                 )
  106.             );
  107.         }
  109.         $fees = $em->getRepository(ProposalFeeInvoice::class)->findByProposalId($id);
  110.         if (!empty($fees)){ if (!($fees[0]->getToInvoice())){ $fees = null; } }     // Si no se debe mostrar en factura se pone a null
  112.         $summary = $em->getRepository(ProposalsInvoiceSummary::class)->findOneByProposalId($id);
  113.         $summaryInvoice = !empty($summary);
  114.         $summaryInvoiceText = !empty($summary) ? $summary->getDescription() : null;
  116.         $urlResumenPrecios = $this->generateUrl('proposal_summary_price', ['id' => $id]);
  117.         // Si ya existe en ProposalsStatistics el proposal facturado, no es necesario abrir el resumen
  118.         $propStats = $em->getRepository(ProposalsStatistics::class)->findBy([
  119.             'proposalId' => $id,
  120.             'proposalStatus' => 'Invoiced',
  121.         ]);
  122.         if (!empty($propStats)){ $urlResumenPrecios = null; }
  124.         return $this->render('MDS/EventsBundle/services/services-invoice-proposal.html.twig',
  125.             array(
  126.                 'id' => $id,
  127.                 'type' => $data['type'],
  128.                 'number' => $data['number'],
  129.                 'prefix' => $data['prefix'],
  130.                 'date' => $data['date'],
  131.                 'token' => $token,
  132.                 'proposal' => $data['proposal'],
  133.                 'company' => $data['company'],
  134.                 'clients' => $data['clients'],
  135.                 'datasupplier' => $data['datasupplier'],
  136.                 'totales_neto_antes' => $data['totales_neto_antes'],
  137.                 'totales_neto' => $data['totales_neto'], // totales neto
  138.                 'bases_imponibles' => $data['bases_imponibles'],
  139.                 'totales_antes' => $data['totales_antes'],
  140.                 'totales' => $data['totales'], // totales generales
  141.                 'balance' => $data['balance'],
  142.                 'totales_generales' => $data['totales_generales'],
  143.                 'currency' => $data['currency'],
  144.                 'detail_iva' => 'no',
  145.                 'discounts' => $data['discounts'],
  146.                 'fees' => $fees,
  147.                 'summaryInvoice' => $summaryInvoice,
  148.                 'summaryInvoiceText' => $summaryInvoiceText,
  149.                 'paymentInvoice' => $data['paymentInvoice'],
  150.                 'invoiceDesposit' => $data['invoiceDesposit'],
  151.                 'mcp' => $data['proposal']->getMcp(),
  152.                 'urlResumenPrecios' => $urlResumenPrecios,
  153.             )
  154.         );
  155.     }
  157.     /**
  158.      * @Route("/proposal/invoice/print/{id}",  name="proposal_invoice_detector_print")
  159.      */
  160.     public function detectorInvoicePrintAction($id, Request $request, EntityManagerInterface $em)
  161.     {
  162.         $invoiceconsulta= [];
  163.         $typeconsulta ='';
  165.         $invoice= $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  166.         if (!empty($invoice)){
  167.             $invoiceconsulta = $invoice;
  168.             $typeconsulta = $invoice->getType();
  169.         }
  171. //        $novatinvoice= $em->getRepository(ProposalNoVatInvoice::class)->findOneByProposalId($id);
  172. //        if (!empty($novatinvoice)){
  173. //            $invoiceconsulta = $novatinvoice;
  174. //            $typeconsulta = 'No Vat Invoice';
  175. //        }
  177. //        $invoiceconsulta = $em->getRepository(ProposalNoVatInvoice::class)->findOneByProposalId($id);
  178.         if (!empty($invoiceconsulta)){
  179.             $type = $typeconsulta;
  180. //            $number = $invoiceconsulta->getId();
  181.             $number = $invoiceconsulta->getNumber();
  182.             $date = $invoiceconsulta->getDateAt();
  183.             $prefix = $invoiceconsulta->getPrefix();
  184.             $data = $this->baseInvoiceProposal($id, $type, $number, $prefix, $date, $request);
  185.             $token = $data['token'];
  186.         } else {
  187.             return $this->redirectToRoute('proposal_generate_proforma', array( 'id' => $id ));
  188.         }
  190.         $fees = $em->getRepository(ProposalFeeInvoice::class)->findByProposalId($id);
  192.         if (!empty($fees)){
  193.             $fees[0]->setAmount($fees[0]->getFeeNet());
  194.             if (!($fees[0]->getToInvoice())){ $fees = null; } } // Si no se debe mostrar en factura se pone a null
  196.         $summary = $em->getRepository(ProposalsInvoiceSummary::class)->findOneByProposalId($id);
  197.         $summaryInvoice = !empty($summary);
  198.         $summaryInvoiceText = !empty($summary) ? $summary->getDescription() : null;
  200.         return $this->render('MDS/EventsBundle/services/services-invoice-print-proposal.html.twig',
  201.             array(
  202.                 'id' => $id,
  203.                 'type' => $data['type'],
  204.                 'number' => $data['number'],
  205.                 'prefix' => $data['prefix'],
  206.                 'date' => $data['date'],
  207.                 'token' => $token,
  208.                 'proposal' => $data['proposal'],
  209.                 'company' => $data['company'],
  210.                 'clients' => $data['clients'],
  211.                 'datasupplier' => $data['datasupplier'],
  212.                 'totales_neto_antes' => $data['totales_neto_antes'],
  213.                 'totales_neto' => $data['totales_neto'],
  214.                 'bases_imponibles' => $data['bases_imponibles'],
  215.                 'totales_antes' => $data['totales_antes'],
  216.                 'totales' => $data['totales'],
  217.                 'balance' => $data['balance'],
  218.                 'totales_generales' => $data['totales_generales'],
  219.                 'currency' => $data['currency'],
  220.                 'detail_iva' => 'no',
  221.                 'discounts' => $data['discounts'],
  222.                 'fees' => $fees,
  223.                 'paymentInvoice' => $data['paymentInvoice'],
  224.                 'invoiceDesposit' => $data['invoiceDesposit'],
  225.                 'summaryInvoice' => $summaryInvoice,
  226.                 'summaryInvoiceText' => $summaryInvoiceText,
  227.             )
  228.         );
  230.     }
  233.     /**
  234.      * @Route("/proposal/generate/proforma/{id}",  name="proposal_generate_proforma")
  235.      */
  236.     public function generateProformaAction($id, Request $request)
  237.     {
  238.         $em = $this->getDoctrine()->getManager();
  239.         $proforma = $em->getRepository(ProposalProforma::class)->findOneByProposalId($id);
  241.         $prefix = "MP".date('ymd')."-";
  242.         if (is_null($proforma)){
  243.             $proforma_new = new ProposalProforma();
  244.             $proforma_new->setProposalId($id);
  245.             $proforma_new->setPrefix($prefix);
  246.             $proforma_new->setDateAt(new \DateTime("now"));
  248.             /* Obtengo usuario logueado */
  249.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  250.             $user_id = $user_logueado->getId();
  252.             $proforma_new->setCreatedId($user_id);
  253.             $proforma_new->setUpdatedId($user_id);
  255.             $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  256.             if($proposal->getStatus() != 'Invoiced'){
  257.                 $em->persist($proforma_new);
  258.                 $em->flush();
  259.             }
  260.         }
  262.         return $this->redirectToRoute('proposal_invoice_proforma', array( 'id' => $id ) );
  263.     }
  265.     /**
  266.      * @Route("/proposal/invoice/proforma/{id}",  name="proposal_invoice_proforma")
  267.      */
  268.     public function detailsProformaAction($id, Request $request)
  269.     {
  270.         $data = [];
  271.         $em = $this->getDoctrine()->getManager();
  272.         $paymentsClient = new ProposalPaymentsClient();
  273.         $paymentsClient->setProposalId($id);
  274.         $form = $this->createProposalPaymentsClientForm($paymentsClient);
  276.         $payments = $em->getRepository(ProposalPaymentsClient::class)->findByProposalId($id);
  278.         $proforma = $em->getRepository(ProposalProforma::class)->findOneByProposalId($id);
  279.         if (!empty($proforma)){
  280.             $type = 'Proforma';
  281.             $number = $proforma->getId();
  282.             $date = $proforma->getDateAt();
  283.             $prefix = $proforma->getPrefix();
  285.             $data = $this->baseInvoiceProposal($id, $type, $number, $prefix, $date, $request);
  286.             $token = $data['token'];
  287.         } else {
  288.             return $this->redirectToRoute('proposal_generate_proforma', array( 'id' => $id ));
  289.         }
  291.         $fees = $em->getRepository(ProposalFee::class)->findByProposalId($id);
  292.         if (!empty($fees)){ if (!($fees[0]->getToInvoice())){ $fees = null; } } // Si no se debe mostrar en factura se pone a null
  294.         return $this->render('MDS/EventsBundle/services/services-proforma-proposal.html.twig',
  295.             array(
  296.                 'id' => $id,
  297.                 'type' => $data['type'],
  298.                 'number' => $data['number'],
  299.                 'prefix' => $data['prefix'],
  300.                 'date' => $data['date'],
  301.                 'token' => $token,
  302.                 'proposal' => $data['proposal'],
  303.                 'company' => $data['company'],
  304.                 'clients' => $data['clients'],
  305.                 'datasupplier' => $data['datasupplier'],
  306.                 'totales_neto_antes' => $data['totales_neto_antes'],
  307.                 'totales_neto' => $data['totales_neto'],
  308.                 'bases_imponibles' => $data['bases_imponibles'],
  309.                 'totales_antes' => $data['totales_antes'],
  310.                 'totales' => $data['totales'],
  311.                 'balance' => $data['balance'],
  312.                 'totales_generales' => $data['totales_generales'],
  313.                 'currency' => $data['currency'],
  314.                 'detail_iva' => 'yes',
  315.                 'discounts' => $data['discounts'],
  316.                 'fees' => $fees,
  317.                 'paymentInvoice' => $data['paymentInvoice'],
  318.                 'payments' => $payments,
  319.                 'invoiceDesposit' => $data['invoiceDesposit'],
  320.                 'form' => $form->createView(),
  321.                 'mcp' => $data['proposal']->getMcp(),
  322.             )
  323.         );
  324.     }
  326.     private function createProposalPaymentsClientForm(ProposalPaymentsClient $entity)
  327.     {
  328.         $form = $this->createForm(ProposalPaymentsClientType::class, $entity, array(
  329.             'action' => $this->generateUrl('proposal_payments_client_add'),
  330.             'method' => 'POST'
  331.         ));
  333.         return $form;
  334.     }
  336.     /**
  337.      * @Route("/proposal/payments", name="proposal_payments_client_add")
  338.      */
  339.     public function createAction(Request $request)
  340.     {
  341.         $paymentsClient = new ProposalPaymentsClient();
  342.         $form = $this->createProposalPaymentsClientForm($paymentsClient);
  343.         $form->handleRequest($request);
  345.         if($form->isValid())
  346.         {
  347.             $em = $this->getDoctrine()->getManager();
  349.             /* Obtengo usuario logueado */
  350.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  351.             $user_id = $user_logueado->getId();
  353.             $paymentsClient->setCreatedId($user_id);
  354.             $paymentsClient->setUpdatedId($user_id);
  356.             /* Gestión de eventos en Log */
  357.             $user_lastname = $user_logueado->getLastname();
  358.             $user_name = $user_logueado->getName();
  359.             $user_email = $user_logueado->getEmail();
  360.             $user_rol = $user_logueado->getRoles();
  361.             $event_url = $request->getPathInfo();
  362.             $event_complete = $user_name.' '.$user_lastname.' - '.$user_email.' - '.$user_rol[0].' | '.$event_url;
  364.             $proposal = $em->getRepository(Proposal::class)->findOneById($paymentsClient->getProposalId());
  365.             if($proposal->getStatus() != 'Invoiced'){
  366.                 $em->persist($paymentsClient);
  367.                 $em->flush();
  368.                 $event = 'the payment was registered';
  369.                 $successMessage = $this->translator->trans($event);
  370.                 $this->addFlash('mensajepaymentsclient', $successMessage);
  371.             }else{
  372.                 $errorMessage = $this->translator->trans('Error, the proposal is invoiced and cannot be modified');
  373.                 $this->addFlash('mensajepaymentsclienterror', $errorMessage);
  374.             }
  376.             return $this->redirectToRoute('proposal_invoice_proforma', array( 'id' => $paymentsClient->getProposalId()));
  378.         } else {
  379.             $errorMessage = $this->translator->trans('Error, some fields are empty');
  380.             $this->addFlash('mensajepaymentsclienterror', $errorMessage);
  381.         }
  383.         return $this->redirectToRoute('proposal_invoice_proforma', array( 'id' => $paymentsClient->getProposalId()) );
  384.     }
  387.     /**
  388.      * @Route("/proposal/pdfpdf",  name="proposal_invoice_proforma_pdf_prueba")
  389.      */
  390.     public function pdfAction()
  391.     {
  392.         $snappy = $this->get('knp_snappy.pdf');
  393.         $filename = 'myFirstSnappyPDF';
  394.         $url = 'http://mante.develup.solutions';
  396.         return new Response(
  397.             $snappy->getOutput($url),
  398.             200,
  399.             array(
  400.                 'Content-Type'          => 'application/pdf',
  401.                 'Content-Disposition'   => 'inline; filename="'.$filename.'.pdf"'
  402.             )
  403.         );
  404.     }
  407.     /**
  408.      * @Route("/proposal/invoice/proforma/pdf/{id}",  name="proposal_invoice_proforma_pdf")
  409.      */
  410.     public function detailsProformaPdfActionAction($id, Request $request)
  411.     {
  412.         $snappy = $this->get('knp_snappy.pdf');
  413.         $filename = 'myFirstSnappyPDF';
  415.         // use absolute path !
  416.         $pageUrl = $this->generateUrl('proposal_invoice_proforma_print_externo', array('id'=>$id), UrlGeneratorInterface::ABSOLUTE_URL);
  418.         return new Response(
  419.             $snappy->getOutput($pageUrl),
  420.             200,
  421.             array(
  422.                 'Content-Type'          => 'application/pdf',
  423.                 'Content-Disposition'   => 'inline; filename="'.$filename.'.pdf"'
  424.             )
  425.         );
  426.     }
  429.     /**
  430.      * @Route("/proposal/invoice/pdf/{id}",  name="proposal_invoice_proforma_pdf")
  431.      */
  432.     public function detailsInvoicePdfActionAction($id, Request $request)
  433.     {
  434.         $snappy = $this->get('knp_snappy.pdf');
  435.         $filename = 'myFirstSnappyPDF';
  437.         // use absolute path !
  438.         $pageUrl = $this->generateUrl('proposal_invoice_detector_print_externo', array('id'=>$id), UrlGeneratorInterface::ABSOLUTE_URL);
  440.         return new Response(
  441.             $snappy->getOutput($pageUrl),
  442.             200,
  443.             array(
  444.                 'Content-Type'          => 'application/pdf',
  445.                 'Content-Disposition'   => 'inline; filename="'.$filename.'.pdf"'
  446.             )
  447.         );
  448.     }
  451.     /**
  452.      * @Route("/proposal/invoice/proforma/print/{id}",  name="proposal_invoice_proforma_print")
  453.      */
  454.     public function detailsProformaPrintAction($id, Request $request)
  455.     {
  456. //        $token = "";
  457.         $em = $this->getDoctrine()->getManager();
  458.         $proforma = $em->getRepository(ProposalProforma::class)->findOneByProposalId($id);
  459.         if (!empty($proforma)){
  460.             $type = 'Proforma';
  461.             $number = $proforma->getId();
  462.             $date = $proforma->getDateAt();
  463.             $prefix = $proforma->getPrefix();
  464.             $data = $this->baseInvoiceProposal($id, $type, $number, $prefix, $date, $request);
  465.             $token = $data['token'];
  466.         } else {
  467.             return $this->redirectToRoute('proposal_generate_proforma', array( 'id' => $id ));
  468.         }
  470.         $fees = $em->getRepository(ProposalFee::class)->findByProposalId($id);
  471.         if (!empty($fees)){ if (!($fees[0]->getToInvoice())){ $fees = null; } } // Si no se debe mostrar en factura se pone a null
  473.         $summary = $em->getRepository(ProposalsInvoiceSummary::class)->findOneByProposalId($id);
  474.         $summaryInvoice = !empty($summary);
  475.         $summaryInvoiceText = !empty($summary) ? $summary->getDescription() : null;
  477.         return $this->render('MDS/EventsBundle/services/services-invoice-print-proposal.html.twig',
  478.             array(
  479.                 'id' => $id,
  480.                 'type' => $data['type'],
  481.                 'number' => $data['number'],
  482.                 'prefix' => $data['prefix'],
  483.                 'date' => $data['date'],
  484.                 'token' => $token,
  485.                 'proposal' => $data['proposal'],
  486.                 'company' => $data['company'],
  487.                 'clients' => $data['clients'],
  488.                 'datasupplier' => $data['datasupplier'],
  489.                 'totales_neto_antes' => $data['totales_neto_antes'],
  490.                 'totales_neto' => $data['totales_neto'],
  491.                 'bases_imponibles' => $data['bases_imponibles'],
  492.                 'totales_antes' => $data['totales_antes'],
  493.                 'totales' => $data['totales'],
  494.                 'balance' => $data['balance'],
  495.                 'totales_generales' => $data['totales_generales'],
  496.                 'currency' => $data['currency'],
  497.                 'detail_iva' => 'yes',
  498.                 'discounts' => $data['discounts'],
  499.                 'fees' => $fees,
  500.                 'paymentInvoice' => $data['paymentInvoice'],
  501.                 'summaryInvoice' => $summaryInvoice,
  502.                 'invoiceDesposit' => $data['invoiceDesposit'],
  503.                 'summaryInvoiceText' => $summaryInvoiceText,
  504.             )
  505.         );
  506.     }
  509.     /**
  510.      * @Route("/proposal/generate/invoice/{id}",  name="proposal_generate_invoice")
  511.      */
  512.     public function generateInvoiceAction($id, Request $request, EntityManagerInterface $em)
  513.     {
  514.         $invoiceGenerate = $request->request->get('invoiceGenerate');
  515.         $invoice= $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  517.         if (is_null($invoice)){
  518.             $proposal= $em->getRepository(Proposal::class)->findOneById($id);
  519.             $status = $proposal->getStatus(); // Para controlar que se guarde si no está facturado
  520.             $proposal->setStatus('Invoiced');
  522.             $invoice_new = new ProposalInvoice();
  523.             $invoice_new->setNumber($invoiceGenerate['number']);
  524.             $invoice_new->setDateAt(new \DateTime($invoiceGenerate['dateInvoice']));
  525.             $invoice_new->setType($invoiceGenerate['type']);
  526.             $invoice_new->setProposalId($invoiceGenerate['id']);
  527.             $invoice_new->setPrefix('');
  528. //            $invoice_new->setDateAt(new \DateTime("now"));
  530.             /* Obtengo usuario logueado */
  531.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  532.             $user_id = $user_logueado->getId();
  534.             $invoice_new->setCreatedId($user_id);
  535.             $invoice_new->setUpdatedId($user_id);
  537.             if($status != 'Invoiced'){
  538.                 $em->persist($invoice_new);
  539.                 $em->persist($proposal);
  540.                 $em->flush();
  541.             }
  543.             //Envio correo a administracion en el caso que no tenga numero de factura y este como no enviado
  544.             if( empty($invoiceGenerate['number'])){
  545.                 $time = new \DateTime("now");
  546.                 $agent = $em->getRepository(User::class)->findOneBy(
  547.                     array(
  548.                         "id" => $proposal->getAgentId(),
  549.                         "status" => VacationsConstants::PAYROLL_STAFF_STATUS
  550.                     )
  551.                 )
  552.                 ;
  553.                 $mailAgent[] = $agent->getEmail();
  554.                 $agentMail = $agent->getEmail();
  555.                 $passGmail = $agent->getPassGmail();
  556.                 $firmGmail = $agent->getFirmGmail();
  557.                 $mailAgentSent = array(
  558.                     $agent->getEmail() => $agent->getName().' '. $agent->getLastName()
  559.                 );
  561.                 $setting_rol = $em->getRepository(SettingsRol::class)->findBy(
  562.                     array(
  563.                         'weight' => array('2','3'),
  564.                         'madmin' => '1',
  565.                     )
  566.                 );
  567.                 $mailAdmin = [];
  568.                 foreach($setting_rol as $settingRol){
  569.                     $administration = $em->getRepository(User::class)->findByUserrol($settingRol->getId());
  570.                     foreach($administration as $admin){ $mailAdmin[] = $admin->getEmail(); }
  571.                 }
  572.                 $body ='P#'.$proposal->getId().', '.$proposal->getTitle().'<br><br>
  573.                             <a href="http://'.$request->server->get('HTTP_HOST').'/events/proposal/invoice/number/'.$proposal->getId().'">Asignar Número de Factura</a><br>
  574.                             <a href="http://'.$request->server->get('HTTP_HOST').'/events/proposal/edit/'.$proposal->getId().'">Ir al Proposal</a> - 
  575.                             <a href="http://'.$request->server->get('HTTP_HOST').'/events/proposal/summary/prices/'.$proposal->getId().'">Ver Resumen</a>
  576.                             <br><br>
  577.                             Alerta de solicitud automatizada de número de factura en fecha: '.$time->format('d/m/Y H:i:s').'<br><br>';
  579.                 $data = array(
  580.                     'body' => $body,
  581.                     'firm' => $firmGmail,
  582.                 );
  584.                 $mailTodos = array_merge($mailAgent, $mailAdmin);
  586.                 // EJECUTAR ENVIO DE ALERTA DE VISTO POR CLIENTE
  587.                 $transporter = new Swift_SmtpTransport();
  588.                 $transporter->setHost('smtp.gmail.com')
  589.                     ->setEncryption('ssl') //ssl / tls
  590.                     ->setPort(465) // 465 / 587
  591.                     ->setUsername('desarrollo@develup.solutions')
  592.                     ->setPassword('utvh hzoi wfdo ztjs');
  593.                 $mailer = new Swift_Mailer($transporter);
  595.                 $message = new Swift_Message();
  596.                 $message->setSubject('P#'.$proposal->getId().', Solicitud de número de factura automatizada')
  597.                     ->setSender($agentMail)
  598.                     ->setFrom($mailAgentSent)
  599.                     ->setReplyTo($mailAgentSent)
  600.                     ->setTo($mailTodos)
  601.                     ->setBody(
  602.                         $this->renderView(
  603.                             'mail/structure-mail.html.twig',
  604.                             array('data' => $data)
  605.                         ),
  606.                         'text/html'
  607.                     )
  608.                 ;
  609.                 $mailer->send($message);
  610.             }
  612.             // Guardo en historico de seguimiento
  613.             $textHistory = $this->translator->trans('Billed Proposal');
  614.             $history = $this->TracingHistoryOperations($proposal->getId(), $textHistory);
  616.             // Verificamos si se debe crear un Fee asociado a la factura
  617.             $fee = $em->getRepository(ProposalFee::class)->findOneByProposalId($id);
  619.             if (!empty($fee)){
  620.                 $feeInvoice = new ProposalFeeInvoice();
  621.                 $feeInvoice->setProposalId($id);
  622.                 $feeInvoice->setName($fee->getName());
  623.                 $feeInvoice->setType($fee->getType());
  624.                 $feeInvoice->setAmount($fee->getAmount());
  625.                 $feeInvoice->setOpIva($fee->getOpIva());
  626.                 $feeInvoice->setIva($fee->getIva());
  627.                 $feeInvoice->setToInvoice($fee->getToInvoice());
  628.                 $feeInvoice->setInvoiceId($invoice_new->getId());
  629.                 $feeInvoice->setFeeNet(0);
  630.                 $feeInvoice->setFeeTotal(0);
  631.                 $feeInvoice->setCreatedId($user_id);
  632.                 $feeInvoice->setCreatedAt(new \DateTime("now"));
  634.                 if($status != 'Invoiced'){
  635.                     $em->persist($feeInvoice);
  636.                     $em->flush();
  637.                 }
  638.             }
  639.         }
  640.         return $this->redirectToRoute('proposal_invoice_detector', array( 'id' => $invoiceGenerate['id']));
  641.     }
  644.     /**
  645.      * @Route("/proposal/invoice/proforma/payments/delete/{id}",  name="proposal_invoice_proforma_payments_delete")
  646.      */
  647.     public function deletePaymentsProformaAction($id, Request $request)
  648.     {
  649.         $em = $this->getDoctrine()->getManager();
  650.         $delete= $em->getRepository(ProposalPaymentsClient::class)->findOneById($id);
  651.         $proposalId = $delete->getProposalId();
  653.         $em->remove($delete);
  654.         $em->flush();
  656.         return $this->redirectToRoute('proposal_invoice_proforma', array( 'id' =>$proposalId ));
  657.     }
  660.     private function baseInvoiceProposal($id, $type, $number, $prefix, $date, Request $request)
  661.     {
  662.         $em = $this->getDoctrine()->getManager();
  663.         $proposal= $em->getRepository(Proposal::class)->findOneById($id);
  665.         $services_supplier = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findBy(
  666.             array(
  667.                 'proposalId' => $id,
  668.                 'serviceIdFather' => '0'
  669.             ),
  670.             array(
  671.                 'id' => 'ASC'
  672.             )
  673.         );
  674.         $data_iva = [];
  675.         $supplier_control = [];
  676.         foreach($services_supplier as $servicessupplier){
  677. ////            $supplier_control[$servicessupplier->getSupplierId()] = $servicessupplier->getSupplierId();
  678. //            $supplier_control[$servicessupplier->getSupplierId()] = array(
  679. //                'id' => $servicessupplier->getSupplierId(),
  680. //                'destinoId' => $servicessupplier->getDestinationId(),
  681. //            );
  683.             if(!is_null($servicessupplier->getActivityId())){
  684.                 $supplier_control[$servicessupplier->getActivityId()] = array(
  685.                     'master' => 'activity',
  686.                     'id' => $servicessupplier->getActivityId(),
  687.                     'destinoId' => $servicessupplier->getDestinationId(),
  688.                 );
  689.             }
  690.             if(!is_null($servicessupplier->getIdeaId())){
  691.                 $supplier_control[$servicessupplier->getIdeaId()] = array(
  692.                     'master' => 'idea',
  693.                     'id' => $servicessupplier->getIdeaId(),
  694.                     'destinoId' => $servicessupplier->getDestinationId(),
  695.                 );
  696.             }
  697.             if((!is_null($servicessupplier->getSupplierId())) and ($servicessupplier->getIdeaId() == null) and ($servicessupplier->getActivityId() == null)){
  698.                 $supplier_control[$servicessupplier->getSupplierId()] = array(
  699.                     'master' => 'supplier',
  700.                     'id' => $servicessupplier->getSupplierId(),
  701.                     'destinoId' => $servicessupplier->getDestinationId(),
  702.                 );
  703.             }
  704.         }
  706.         $data_serviceCat = [];
  707.         $data_supplier = [];
  708.         $totales_neto_all = 0;
  709.         $totales_all = 0;
  710.         $currency ="";
  711.         $data_service_supplier = [];
  712.         foreach($supplier_control as $suppliercontrol){
  713. //            $destination = $em->getRepository(Destination::class)->findOneById($suppliercontrol['destinoId']);
  714.             $destination = $em->getRepository(Destination::class)->findOneById($suppliercontrol['destinoId']);
  716.             $colorlabel= "bg-success-300";
  718.             $sqlactivities = "";
  719.             if($suppliercontrol['master'] == 'activity'){
  720.                 $master = "activity";
  721.                 $sqlactivities = $em->getRepository(Activities::class)->findOneById($suppliercontrol['id']);
  723.                 // ORDEN DESCENDENTE Y POR SERVICES
  724.                 $parameters = array(
  725.                     'proposalId' => $id,
  726.                     'serviceIdFather' => '0',
  727.                     'activityId' => $suppliercontrol['id']
  728.                 );
  729.                 $dql = 'SELECT p
  730.                     FROM EventsBundle:ProposalSupplierServicesCostsClient p
  731.                     WHERE p.proposalId = :proposalId AND p.activityId = :activityId AND p.serviceIdFather = :serviceIdFather 
  732.                     ORDER BY p.serviceCatId, p.rank ASC ';
  734.                 $query = $em->createQuery($dql)->setParameters($parameters);
  735.                 $data_service_supplier = $query->getResult();
  736.             }
  738.             $sqlideas = "";
  739.             if($suppliercontrol['master'] == 'idea'){
  740.                 $master = "idea";
  741.                 $sqlideas = $em->getRepository(Ideas::class)->findOneById($suppliercontrol['id']);
  743.                 // ORDEN DESCENDENTE Y POR SERVICES
  744.                 $parameters = array(
  745.                     'proposalId' => $id,
  746.                     'serviceIdFather' => '0',
  747.                     'ideaId' => $suppliercontrol['id']
  748.                 );
  749.                 $dql = 'SELECT p
  750.                     FROM EventsBundle:ProposalSupplierServicesCostsClient p
  751.                     WHERE p.proposalId = :proposalId AND p.ideaId = :ideaId AND p.serviceIdFather = :serviceIdFather 
  752.                     ORDER BY p.serviceCatId, p.rank ASC ';
  754.                 $query = $em->createQuery($dql)->setParameters($parameters);
  755.                 $data_service_supplier = $query->getResult();
  756.             }
  758.             $sqlsuppliers ="";
  759.             if($suppliercontrol['master'] == 'supplier'){
  760.                 $master = "supplier";
  761.                 $sqlsuppliers = $em->getRepository(Supplier::class)->findOneById($suppliercontrol['id']);
  762.                 if(!is_null($sqlsuppliers)){
  763.                     switch ($sqlsuppliers->getStar()) {
  764.                         case 1: $sqlsuppliers->setStar('<i class="icon-star-full2"></i>'); break;
  765.                         case 2: $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i>'); break;
  766.                         case 3: $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i>'); break;
  767.                         case 4: $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>'); break;
  768.                         case 5: $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'); break;
  769.                         case 6: $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>'); break;
  770.                         case 7: $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'); break;
  771.                         case 8: $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'); break;
  772.                     }
  773.                 }
  774.                 // ORDEN DESCENDENTE Y POR SERVICES
  775.                 $parameters = array(
  776.                     'proposalId' => $id,
  777.                     'serviceIdFather' => '0',
  778.                     'supplierId' => $suppliercontrol['id']
  779.                 );
  780.                 $dql = 'SELECT p
  781.                     FROM EventsBundle:ProposalSupplierServicesCostsClient p
  782.                     WHERE p.proposalId = :proposalId AND p.supplierId = :supplierId AND p.ideaId is null AND p.activityId is null AND p.serviceIdFather = :serviceIdFather 
  783.                     ORDER BY p.serviceCatId, p.rank ASC ';
  785.                 $query = $em->createQuery($dql)->setParameters($parameters);
  786.                 $data_service_supplier = $query->getResult();
  788.                 // Agrupamos asistencias de In-Out por ID de Agente
  789.                 $new_data_service_supplier = [];
  790.                 $arregloAcumulador = [];
  791.                 $acumulador = [];
  793.                 if ($sqlsuppliers->getCompany() == 'IN OUT TRAVEL & EVENTS') {
  794.                     // El proveedor es In Out
  795.                     foreach ($data_service_supplier as $dtsp){
  796.                         $zNameSrvOrNameUsr = $em->getRepository(ProposalsSupplierServicesAssistantName::class)->findOneByPrpSupSrvId($dtsp->getServiceIdProposal());
  798.                         if ($dtsp->getServiceCatId() != 15){
  799.                             $new_data_service_supplier[] = $dtsp;
  800.                         } else {
  801.                             // Tenemos una asistencia de In Out
  802.                             // vamos acumulando precios, over, etc
  804.                             if ((! array_key_exists($dtsp->getAssistantId().'-'.$dtsp->getPrice(),$arregloAcumulador) ) and (!is_null($dtsp->getAssistantId()))){
  806. //                                Antes se comprobaba solo con el id ahora el id del agente y el precio de la asistencia
  807. //                                $zAg= $em->getRepository(User::class)->findOneById($dtsp->getAssistantId());
  808. //                                $dtsp->setName('Staff In Out Events: '. $zAg->getName(). ' ' . $zAg->getLastName());
  809. //                                $dtsp->setUnits(1);
  810. //                                $arregloAcumulador[$dtsp->getAssistantId()] = $dtsp;
  812.                                 $zAg= $em->getRepository(User::class)->findOneById($dtsp->getAssistantId());
  813. //                                if($zAg->getId() == 20){
  814. //                                  AQUI TENDRIAMOS LA CONDICION PARA QUE APAREZCA O NO EL NOMBRE EDL AGENTE (FUTURO DESARROLLO)
  815. //                                }else {
  816.                                 if (empty($zNameSrvOrNameUsr) && !is_null($zAg)) {
  817.                                     $dtsp->setName('Staff In Out Events: ' . $zAg->getName() . ' ' . $zAg->getLastName());
  818.                                 }
  819. //                                }
  820.                                 $dtsp->setUnits(1);
  821.                                 $arregloAcumulador[$dtsp->getAssistantId().'-'.$dtsp->getPrice()] = $dtsp;
  823.                             } else {
  825.                                 if ((!is_null($dtsp->getAssistantId()))){
  826. //                                Antes se comprobaba sololo con el id ahora el id del agente y el precio de la asistencia
  827. //                                $tempAcum = $arregloAcumulador[$dtsp->getAssistantId()];
  828.                                     $tempAcum = $arregloAcumulador[$dtsp->getAssistantId().'-'.$dtsp->getPrice()];
  830.                                     $tempAcum->setUnits($tempAcum->getUnits() + 1);
  832.                                     //Si el dia de inicio es menor actualizas (para establecer rangos de varios dias)
  833.                                     if ($dtsp->getDateInAt() < $tempAcum->getDateInAt()) {
  834.                                         $tempAcum->setDateInAt($dtsp->getDateInAt());
  835.                                     }
  836.                                     //Si el dia de fin es mayor actualizas (para establecer rangos de varios dias)
  837.                                     if ($dtsp->getDateOutAt() > $tempAcum->getDateOutAt()) {
  838.                                         $tempAcum->setDateOutAt($dtsp->getDateOutAt());
  839.                                     }
  841. //                                Antes se comprobaba sololo con el id ahora el id del agente y el precio de la asistencia
  842. //                                $arregloAcumulador[$dtsp->getAssistantId()] = $tempAcum;
  843.                                     $arregloAcumulador[$dtsp->getAssistantId().'-'.$dtsp->getPrice()] = $tempAcum;
  844.                                 } else {
  846.                                     // Tenemos una asistencia de un agente EXTERNO - este agente no se encuentra en el listado de agentes de In Out
  848.                                     if ( array_key_exists($dtsp->getName(),$arregloAcumulador) ){
  849.                                         $tempAcum = $arregloAcumulador[$dtsp->getName()];
  851.                                         $tempAcum->setUnits($tempAcum->getUnits() + 1);
  852.                                         if (empty($zNameSrvOrNameUsr)) {
  853.                                             $tempAcum->setName('Staff In Out Events: ' . $dtsp->getName());
  854.                                         }
  856.                                         //Si el dia de inicio es menor actualizas (para establecer rangos de varios dias)
  857. //                                        if ($dtsp->getDateInAt() < $tempAcum->getDateInAt()) {
  858. //                                            $tempAcum->setDateInAt($dtsp->getDateInAt());
  859. //                                        }
  860. //                                        //Si el dia de fin es mayor actualizas (para establecer rangos de varios dias)
  861. //                                        if ($dtsp->getDateOutAt() > $tempAcum->getDateOutAt()) {
  862. //                                            $tempAcum->setDateOutAt($dtsp->getDateOutAt());
  863. //                                        }
  865.                                         $arregloAcumulador[$dtsp->getName()] = $tempAcum;
  866.                                     } else {
  867.                                         $arregloAcumulador[$dtsp->getName()] = $dtsp;
  868.                                         if (empty($zNameSrvOrNameUsr)) {
  869.                                             $arregloAcumulador[$dtsp->getName()]->setName('Staff In Out Events: ' . $dtsp->getName());
  870.                                         }
  871.                                     }
  872.                                 }
  873.                             }
  874.                         }
  875.                     }
  877.                     foreach ($arregloAcumulador as $aAc){ $new_data_service_supplier[] = $aAc; }
  878.                     $data_service_supplier = $new_data_service_supplier;
  879.                 }
  880.                 // FIN  -  Agrupamos asistencias de In-Out por ID de Agente
  881.             }
  882.             $imagenSmall = null;
  884.             $service_supplier_data = [];
  885.             $totales_neto = $totales_iva = $totales_con_iva = $totales_paying = $totales_pago = $totales_benefit_moneda = $totales_benefit_porsentaje ='0';
  887.             foreach($data_service_supplier as $data_service){
  888.                 //Currency
  889.                 $currency = $data_service->getCurrency();
  890.                 if (isset($currency)){$currency="Euro";}
  891.                 if ($currency == "Euro"){$currency="€";}
  892.                 if ($currency == "Dolar"){$currency=" $";}
  893.                 if ($currency == "MXN"){$currency=" MXN";}
  894.                 $data_service->setCurrency($currency);
  896.                 $idcat = $data_service->getServiceCatId();
  897.                 $price = ($data_service->getPrice() == "")? 0 : $data_service->getPrice();
  898.                 $units = ($data_service->getUnits() == "")? 0 : $data_service->getUnits();
  899.                 $pax = ($data_service->getPax() == "")? 0 : $data_service->getPax();
  900.                 $opcommission = $data_service->getOpCommission();
  901.                 $commission = $data_service->getCommission();
  902.                 $opover = $data_service->getOpOver();
  903.                 $over = $data_service->getOver();
  904.                 $opiva = $data_service->getOpIva();
  905. //                $iva = $data_service->getIva();
  906.                 $iva = empty($data_service->getIva())? 0 : $data_service->getIva();
  907.                 $dateInAt = $data_service->getDateInAt();
  908.                 $dateOutAt = $data_service->getDateOutAt();
  909.                 if (!is_null($dateInAt) and !is_null($dateOutAt)){
  910.                     $days = $dateInAt->diff($dateOutAt);
  911.                     $day = $days->days;
  912.                 } else {
  913.                     $day = "0";
  914.                 }
  915.                 if(!is_null($data_service->getActivityId())){
  916.                     $name_supplier = $em->getRepository(Activities::class)->findOneById($data_service->getActivityId());
  917.                     if (empty($name_supplier)){ $namesupplier = ''; } else { $namesupplier = $name_supplier->getName(); }
  918.                 }
  920.                 if(!is_null($data_service->getIdeaId())){
  921.                     $name_supplier = $em->getRepository(Ideas::class)->findOneById($data_service->getIdeaId());
  922.                     if (empty($name_supplier)){ $namesupplier = ''; } else { $namesupplier = $name_supplier->getName(); }
  923.                 }
  925.                 if((!is_null($data_service->getSupplierId())) and ($data_service->getIdeaId() == null) and ($data_service->getActivityId() == null) ){
  926.                     $name_supplier = $em->getRepository(Supplier::class)->findOneById($data_service->getSupplierId());
  927.                     if (empty($name_supplier)){ $namesupplier = ''; } else { $namesupplier = $name_supplier->getName(); }
  928.                 }
  930. //                $name_supplier = $em->getRepository(Supplier::class)->findOneById($data_service->getSupplierId());
  931. //                $namesupplier = $name_supplier->getName();
  933.                 if($type == 'No Vat Invoice'){
  934.                     $iva="0";
  935.                     $data_service->setIva($iva);
  936.                 }
  938.                 $calculos = $this->CalculoTotalesservices($price, $units, $pax, $day, $opcommission, $commission, $opover, $over, $opiva, $iva, $idcat);
  940.                 // Problema con comisiones
  941. //                if ($data_service->getPrice() == $calculos['precio']){
  942. ////                    $data_service->setPrice($calculos['precio']); //ojo aqui
  943. //                } else {
  944. //                    $data_service->setPrice($calculos['precio']);
  945. //                    if (($over == 0) and empty($over) and ($commission == 0) and empty($commission)) {
  946. //                        // Se bajo el precio porque el iva estaba incluido
  947. //                        $data_service->setOpIva(1);
  948. //                    }
  949. //
  950. //                    if (!(($over == 0) or empty($over))) { $data_service->setOver(0); }
  951. //                    if (!(($commission == 0) or empty($commission))) { $data_service->setCommission(0); }
  952. //                }
  954.                 $service_supplier_data[] = array(
  955.                     'calculos' => $calculos,
  956.                     'services_data' => $data_service,
  957.                     'namesupplier' => $namesupplier
  958.                 );
  960.                 $totales_neto += $calculos['total_neto'];
  961.                 $totales_iva += $calculos['sub_total_iva'];
  962.                 $totales_con_iva += $calculos['total'];
  963.                 $totales_paying += $calculos['total_paying'];
  964.                 $totales_pago += $calculos['total_pago'];
  965.                 $totales_benefit_moneda += $calculos['benefit_moneda'];
  967.                 /* base imponible por servicios */
  968.                 if (empty($base_imponible_service[$idcat])){ $base_imponible_service[$idcat]= 0; }
  969.                 $base_imponible_service[$idcat] += $calculos['total_neto'];
  971.                 $data_serviceCat[$idcat] = array(
  972.                     'idcat' => $idcat,
  973.                     'total_neto' => $base_imponible_service[$idcat],
  974.                 );
  976.                 /* base impobnible detalles por diferentes Ivas */
  977.                 if (empty($base_imponible_iva[$iva])){ $base_imponible_iva[$iva]= 0; }
  978.                 $base_imponible_iva[$iva] += $calculos['total_neto'];
  980.                 if (empty($totales_ivas_all[$iva])){ $totales_ivas_all[$iva]= 0; }
  981.                 $totales_ivas_all[$iva] += $calculos['sub_total_iva'];
  983.                 $totales_neto_all += $calculos['total_neto'];
  984.                 $totales_all += $calculos['total'];
  986.                 $data_iva[$iva] = array(
  987.                     'iva' => $iva,
  988.                     'ivas' => $totales_ivas_all[$iva],
  989.                     'total_iva' => $base_imponible_iva[$iva]
  990.                 );
  991.                 if ($totales_benefit_moneda == '0'){
  992.                     $totales_benefit_porsentaje =  '0';
  993.                 } else {
  994.                     if ($totales_neto != 0) {
  995.                         $totales_benefit_porsentaje = $totales_benefit_moneda / $totales_neto * 100; // arreglado or esteban
  996.                     } else {
  997.                         $totales_benefit_porsentaje = 0;
  998.                     }
  999.                 }
  1000.             }
  1002.             $calculos_totatales = array(
  1003.                 'totales_neto' => $totales_neto,
  1004.                 'totales_iva' => $totales_iva,
  1005.                 'totales_con_iva' => $totales_con_iva,
  1006.                 'totales_paying' => $totales_paying,
  1007.                 'totales_benefit_moneda' => $totales_benefit_moneda,
  1008.                 'totales_benefit_porsentaje' => $totales_benefit_porsentaje
  1009.             );
  1011.             $data_supplier[$destination->getTitle()][] = array(
  1012.                 'master' => $master,
  1013.                 'colorlabel' => $colorlabel,
  1014.                 'control' => "1",
  1015.                 'supplier' => $sqlsuppliers,
  1016.                 'idea' => $sqlideas,
  1017.                 'activity' => $sqlactivities,
  1018.                 'image' => $imagenSmall,
  1019.                 'services' => $service_supplier_data,
  1020.                 'totales_services' => $calculos_totatales
  1021.             );
  1022.         }
  1023.         $totales_neto_antes = $totales_neto_all;
  1024.         $totales_antes = $totales_all;
  1026.         /*Group Everything*/
  1027.         if($type == 'Group Everything'){
  1028.             $data_supplier = [];
  1029.             $service_supplier_data = [];
  1030.             $messageitems = $this->translator->trans('Grouped Services');
  1032.             $data_service = array(
  1033.                 "price" => $totales_neto_antes,
  1034.                 "name" => $messageitems,
  1035.                 "units" => 1,
  1036.                 "iva" => $iva,
  1037.                 "dateInAt" => "2018-4-4",
  1038.                 "dateOutAt" => "2018-4-4",
  1039.             );
  1041.             $calculos = array(
  1042.                 "precio" => $totales_neto_antes,
  1043.                 "total_days" => 1,
  1044.                 "sub_total" => $totales_neto_antes,
  1045.                 "sub_total_iva" => 0,
  1046.                 "total_neto" => $totales_neto_antes,
  1047.                 "total_iva" => 0,
  1048.                 "total_paying" => 0,
  1049.                 "total_pago" => 0,
  1050.                 "total_comision" => "0",
  1051.                 "total" => $totales_antes,
  1052.                 "benefit_moneda" => 0,
  1053.             );
  1055.             $service_supplier_data[] = array(
  1056.                 'calculos' => $calculos,
  1057.                 'services_data' => $data_service,
  1058.                 'namesupplier' => ""
  1059.             );
  1061.             $calculos_totatales = array(
  1062.                 'totales_neto' => $totales_neto_antes,
  1063.                 'totales_iva' => "",
  1064.                 'totales_con_iva' => $totales_antes,
  1065.                 'totales_paying' => "",
  1066.                 'totales_benefit_moneda' => "",
  1067.                 'totales_benefit_porsentaje' => ""
  1068.             );
  1070.             $data_supplier[$messageitems][] = array(
  1071.                 'master' => '',
  1072.                 'colorlabel' => '',
  1073.                 'control' => "1",
  1074.                 'supplier' => '',
  1075.                 'idea' => '',
  1076.                 'activity' => '',
  1077.                 'image' => '',
  1078.                 'services' => $service_supplier_data,
  1079.                 'totales_services' => $calculos_totatales
  1080.             );
  1081.         }
  1083.         $data_serviceOut = array(
  1084.             'idcat' => null,
  1085.             'total_neto' => $totales_neto_all,
  1086.         );
  1088.         array_push ( $data_serviceCat, $data_serviceOut );
  1089.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('1');
  1091.         $parameters = array( 'id' => $proposal->getclientId(), );
  1092.         $dql = 'SELECT cl,  c.country, re.region, p.name, r.city
  1093.                 FROM App:Client cl
  1094.                 INNER JOIN App:Country c WITH c.id = cl.country
  1095.                 INNER JOIN App:Regions re WITH re.id = cl.region
  1096.                 INNER JOIN App:Provinces p WITH p.id = cl.province
  1097.                 INNER JOIN App:Cities r WITH r.id = cl.population
  1098.                 WHERE cl.id = :id';
  1100.         $query = $em->createQuery($dql)->setParameters($parameters);
  1101.         $client = $query->getResult();
  1103.         $data_invoice = [];
  1104.         $inv_neto_total = 0;
  1105.         $inv_total = 0;
  1106.         $invoice_deposit_control = $em->getRepository(ProposalInvoiceDepositControl::class)->findByProposalId($proposal->getId());
  1107.         if (!empty($invoice_deposit_control)){
  1108.             foreach($invoice_deposit_control as $invoicedepositcontrol) {
  1109.                 $data_items_inv = [];
  1110.                 $invoice_deposit_items = $em->getRepository(ProposalInvoiceDepositItems::class)->findByControlId($invoicedepositcontrol->getId());
  1111.                 foreach($invoice_deposit_items as $invoicedeposititems) {
  1112.                     $invamount = $invoicedeposititems->getAmount();
  1113.                     $invamount_iva = $invoicedeposititems->getIva();
  1114.                     $invamount_el_iva = $invamount * ($invamount_iva / 100);
  1115.                     $invamount_con_iva = $invamount * (($invamount_iva / 100) + 1 );
  1117.                     $inv_neto_total += $invamount;
  1118.                     $inv_total += $invamount_con_iva;
  1120.                     if (is_null($invoicedepositcontrol->getNumber())){
  1121.                         $numInvoice = $invoicedepositcontrol->getId();
  1122.                     } else {
  1123.                         $numInvoice = $invoicedepositcontrol->getNumber();
  1124.                     }
  1126.                     $data_items_inv[] = array(
  1127.                         'numInvoice' => $numInvoice,
  1128.                         'name' => $invoicedeposititems->getName(),
  1129.                         'amount' => $invoicedeposititems->getAmount(),
  1130.                         'iva' => $invoicedeposititems->getIva(),
  1131.                         'ivaamount' => $invamount_el_iva,
  1132.                         'total' => $invamount_con_iva,
  1133.                     );
  1135.                     foreach($data_iva as $items_iva) {
  1136.                         if ($items_iva['iva'] == $invoicedeposititems->getIva()){
  1137.                             $new_iva = $items_iva['iva'];
  1138.                             $new_ivas = $items_iva['ivas'] - $invamount_el_iva;
  1139.                             $new_total_iva = $items_iva['total_iva'] - $invoicedeposititems->getAmount();
  1141.                             $new_data_iva = array(
  1142.                                 'iva' => $new_iva,
  1143.                                 'ivas' => $new_ivas,
  1144.                                 'total_iva' => $new_total_iva
  1145.                             );
  1146.                             $data_iva = array_replace($data_iva, array( $new_iva => $new_data_iva ));
  1147.                         }
  1148.                     }
  1149.                 }
  1151.                 $data_invoice[] = array( 'itemsInvoice' => $data_items_inv, );
  1152.             }
  1154.             $totales_neto_all = $totales_neto_all - $inv_neto_total;
  1155.             $totales_all = $totales_all - $inv_total;
  1156.         }
  1158.         $consulta_discount = $em->getRepository(ProposalDiscount::class)->findByProposalId($id);
  1159.         $cuantosdiscount = count($consulta_discount);
  1161.         $totales_generales="";
  1162.         $descuento = [];
  1163.         if (!empty($consulta_discount)){
  1164.             $quitar_en_todos = 0;
  1165.             $datos_total_neto_suma = 0;
  1166.             foreach($data_serviceCat as $dataserviceat) {
  1167.                 $name ="";
  1168.                 $amount = "";
  1169.                 $type_des = "";
  1170.                 $iva_discount="";
  1171.                 $datos_idcat = $dataserviceat['idcat'];
  1172.                 $datos_total_neto = $dataserviceat['total_neto'];
  1174.                 $totales_neto_des = $datos_total_neto;
  1175.                 $datosiva_neto_des = $datos_total_neto;
  1176.                 $calculo_net_negativo="";
  1177.                 $total_con_iva_desc="";
  1178.                 $contarveces = 1;
  1179.                 foreach($consulta_discount as $consultadiscount) {
  1180.                     if($dataserviceat['idcat'] == null){
  1181.                         if($contarveces > 1 ){
  1182.                             $totales_neto_des = $datos_total_neto_suma;
  1183.                             $datosiva_neto_des = $datos_total_neto_suma;
  1184.                             $datos_total_neto = $datos_total_neto_suma;
  1185.                         } else {
  1186.                             if($cuantosdiscount > 1){
  1187.                                 $totales_neto_des = $dataserviceat['total_neto'] - $quitar_en_todos;
  1188.                                 $datosiva_neto_des = $dataserviceat['total_neto'] - $quitar_en_todos;
  1189.                                 $datos_total_neto = $dataserviceat['total_neto'] - $quitar_en_todos;
  1190.                             }
  1191.                         }
  1192.                         $contarveces += 1;
  1193.                     }
  1195.                     if ($dataserviceat['idcat'] == $consultadiscount->getServiceId()){
  1197.                         $iva = $consultadiscount->getIva() / 100;
  1198.                         if ($consultadiscount->getType()=="0"){
  1199.                             $por = $consultadiscount->getAmount() / 100;
  1201. //                            $datosiva_neto_des = $datosiva_neto_des / ($por + 1) ;
  1202.                             $datosiva_neto_des = $datosiva_neto_des - ($datosiva_neto_des * $por) ;
  1204.                             $name = $consultadiscount->getName();
  1205.                             $type_des = $consultadiscount->getType();
  1206.                             $amount = $consultadiscount->getAmount();
  1207.                         }
  1209.                         if ($consultadiscount->getType()=="1"){
  1210.                             $datosiva_neto_des = $datosiva_neto_des - $consultadiscount->getAmount();
  1212.                             $name = $consultadiscount->getName();
  1213.                             $type_des = $consultadiscount->getType();
  1214.                             $amount = $consultadiscount->getAmount();
  1215.                         }
  1217.                         // resultados en negativo
  1218.                         $calculo_net_negativo =  $datosiva_neto_des - $datos_total_neto;
  1220.                         $total_desc = "0";
  1221.                         // resultados para calculos
  1222.                         $calculo_net = $datos_total_neto - $datosiva_neto_des;
  1223.                         if($consultadiscount->getOpIva() =='0'){
  1224.                             $iva_discount = $calculo_net - ($calculo_net / ($iva + 1));
  1225.                             $calculo_net_negativo = $calculo_net_negativo + $iva_discount;
  1226.                             $totales_neto_des = $totales_neto_des + $iva_discount;
  1227.                             $total_desc = $iva_discount;
  1228.                         }
  1229.                         if($consultadiscount->getOpIva() =='1'){
  1230.                             $iva_discount = $calculo_net * $iva;
  1231.                             $total_desc = $iva_discount;
  1232.                         }
  1234.                         if($type == 'No Vat Invoice'){
  1235.                             $iva_discount = "0";
  1236.                         }
  1238. //                        if($dataserviceat['idcat'] == null){
  1239.                         $datos_total_neto_suma = $datos_total_neto- abs($calculo_net_negativo);
  1240. //                        }
  1242.                         $quitar_en_todos = $quitar_en_todos + abs($calculo_net_negativo);
  1243. //                        $datosiva_neto_des = $datosiva_neto_des + $calculo_net_negativo;
  1245.                         $total_con_iva_desc = $calculo_net_negativo - $iva_discount;
  1247.                         $totales_neto_all = $totales_neto_all - abs($calculo_net_negativo);
  1248.                         $totales_all = $totales_all - abs($total_con_iva_desc);
  1250.                         $descuento[] = array(
  1251.                             'name' => $name,
  1252.                             'type' => $type_des,
  1253.                             'amount' => $amount,
  1254.                             'iva' => $consultadiscount->getIva(),
  1255.                             'iva_amount' => $iva_discount,
  1256.                             'totales_neto_des' => $calculo_net_negativo,
  1257.                             'total' => $total_con_iva_desc,
  1258.                         );
  1260.                         // Nueva actualizacion 17-07-2019 Recalcular Ivas
  1261.                         foreach($data_iva as $items_iva) {
  1262.                             if ($items_iva['iva'] == $consultadiscount->getIva()){
  1263.                                 $new_iva = $items_iva['iva'];
  1264.                                 $new_ivas = $items_iva['ivas'] - $iva_discount;
  1265.                                 $new_total_iva = $items_iva['total_iva'] - $iva_discount;
  1267.                                 $new_data_iva = array(
  1268.                                     'iva' => $new_iva,
  1269.                                     'ivas' => $new_ivas,
  1270.                                     'total_iva' => $new_total_iva
  1271.                                 );
  1272.                                 $data_iva = array_replace($data_iva, array( $new_iva => $new_data_iva ));
  1273.                             }
  1274.                         }
  1275.                     }
  1276.                 }
  1277.             }
  1278.         }
  1280.         $payments = $em->getRepository(ProposalPaymentsClient::class)->findByProposalId($id);
  1281.         $amount_pay = 0;
  1282.         foreach($payments as $payment) { $amount_pay = $amount_pay + $payment->getAmount(); }
  1284.         $totales_all = round($totales_all,2);
  1285.         $totales_total = $totales_all;
  1286.         if (!empty($payments)){ $totales_all = $totales_all - $amount_pay; }
  1288.         $data = array(
  1289.             'id' => $id,
  1290.             'type' => $type,
  1291.             'number' => $number,
  1292.             'prefix' => $prefix,
  1293.             'date' => $date,
  1294.             'token' => $proposal->getAccessKey(),
  1295.             'proposal' => $proposal,
  1296.             'company' => $company,
  1297.             'clients' => $client,
  1298.             'datasupplier' => $data_supplier,
  1299.             'totales_neto_antes' => $totales_neto_antes,
  1300.             'totales_neto' => $totales_neto_all,
  1301.             'totales_generales' => $totales_generales,
  1302.             'bases_imponibles' => $data_iva,
  1303.             'totales_antes' => $totales_antes,
  1304.             'totales' => $totales_total,
  1305.             'balance' => $totales_all,
  1306.             'currency' => $currency,
  1307.             'paymentInvoice' => $amount_pay,
  1308.             'discounts' => $descuento,
  1309.             'invoiceDesposit' => $data_invoice,
  1310.         );
  1312. // ************************************************  FEE    ************************************************************
  1313.         $fees = $em->getRepository(ProposalFee::class)->findByProposalId($id);
  1314.         $feesInvoice = $em->getRepository(ProposalFeeInvoice::class)->findByProposalId($id);
  1316.         if (!empty($feesInvoice)) {
  1317.             // Fee en factura
  1318.             // 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
  1319.             if ($feesInvoice[0]->getToinvoice() == true) {
  1320.                 foreach ($feesInvoice as $feeInv) {
  1321.                     if ($feeInv->getType() == 0) {
  1322.                         // Tenemos un porcentaje en el Fee de la factura, debe calcularse
  1323.                         $feeNet = ($data['totales_neto_antes'] * $feeInv->getAmount()) / 100;
  1324.                     } else {
  1325.                         $feeNet = $feeInv->getAmount();
  1326.                     }
  1328.                     $feeTotal = $feeNet * 1.21;                     //El fee siempre será al 21%, Esteban Rincón
  1330.                     if ($feeInv->getToInvoice() == true) {
  1331.                         $data['totales_neto'] += $feeNet;
  1332.                         $data['totales'] += $feeTotal;
  1333.                         $data['balance'] += $feeTotal;
  1334.                         if (array_key_exists('21', $data['bases_imponibles'])) {
  1335.                             $data['bases_imponibles']['21']['ivas'] += $feeNet * 0.21;
  1336.                             $data['bases_imponibles']['21']['total_iva'] += $feeNet;
  1337.                         } else {
  1338.                             $data['bases_imponibles']['21']['iva'] = '21';
  1339.                             $data['bases_imponibles']['21']['ivas'] = $feeNet * 0.21;
  1340.                             $data['bases_imponibles']['21']['total_iva'] = $feeNet;
  1341.                         }
  1342.                     }
  1344.                     if ($feeInv->getFeeNet() == 0 or empty($feeInv->getFeeNet())) {
  1345.                         // La asignación solo se hace la primera vez
  1346.                         $feeInv->setFeeNet($feeNet);
  1347.                         $feeInv->setFeeTotal($feeTotal);
  1349.                         $em->persist($feeInv);
  1350.                         $em->flush();
  1351.                     }
  1352.                 }
  1353.             }
  1354.         } else {
  1355.             // Fee en proforma
  1356.             if (!empty($fees)) {
  1357.                 // 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
  1358.                 if ($fees[0]->getToinvoice() == true) {
  1359.                     foreach ($fees as $fee) {
  1360.                         if ($fee->getType() == 0) {
  1361.                             // Tenemos un porcentaje, debe calcularse
  1362.                             $amount = ($data['totales_neto_antes'] * $fee->getAmount()) / 100;
  1363.                             $fee->setAmount($amount);
  1364.                         }
  1365.                         $fee->setFeeTotal($fee->getAmount() * 1.21);        //El fee siempre será al 21%, Esteban Rincón
  1366.                         if ($fee->getToInvoice() == true) {
  1367.                             $data['totales_neto'] += $fee->getAmount();
  1368.                             $data['totales'] += $fee->getFeeTotal();
  1369.                             $data['balance'] += $fee->getFeeTotal();
  1370.                             if (array_key_exists('21', $data['bases_imponibles'])) {
  1371.                                 $data['bases_imponibles']['21']['ivas'] += $fee->getAmount() * 0.21;
  1372.                                 $data['bases_imponibles']['21']['total_iva'] += $fee->getAmount();
  1373.                             } else {
  1374.                                 $data['bases_imponibles']['21']['iva'] = '21';
  1375.                                 $data['bases_imponibles']['21']['ivas'] = $fee->getAmount() * 0.21;
  1376.                                 $data['bases_imponibles']['21']['total_iva'] = $fee->getAmount();
  1377.                             }
  1378.                         }
  1379.                     }
  1380.                 }
  1381.             }
  1382.         }
  1383. // ************************************************  FEE    ************************************************************
  1385.         return $data;
  1386.     }
  1389.     public function CalculoTotalesservices($price, $units, $pax, $days, $opcommission, $commission, $opover, $over, $opiva, $iva, $idcat)
  1390.     {
  1391.         $price = trim($price);
  1392.         $over = trim($over);
  1393.         $price = str_replace(",", ".", $price);
  1394.         $over = str_replace(",", ".", $over);
  1396.         if (empty($iva)){$iva=0;}
  1397.         $iva = $iva / 100;
  1398.         if($opiva =='0'){
  1399.             $price = $price / ($iva + 1);
  1400.         }
  1402.         if(!empty($commission)){
  1403.             if($opcommission=='0'){
  1404.                 $commission = (100 - $commission) / 100;
  1405.                 $precio_units = $price;
  1406.                 $price = $price * $commission;
  1407.             }
  1409.             if($opcommission=='1'){
  1410.                 $commission = ($commission / 100) + 1;
  1411.                 $precio_units = $price * $commission;
  1412.             }
  1413.         }else{
  1414.             $precio_units = $price;
  1415.         }
  1417.         //Units
  1418.         if(empty($units) or $units =="0"){
  1419.             $units = "1";
  1420.         }
  1422.         // Calculo Especial por categoria
  1423.         //Alojamientos
  1424.         if($idcat =="1"){
  1425.             $informativo_days = "si";
  1426.             $pax = "1";
  1427.         }
  1428.         //Transporte
  1429.         elseif($idcat =="13"){
  1430.             $informativo_days = "no";
  1431.             $pax = "1";
  1432.             //            if($days > "1"){
  1433.             //                $days = "2";
  1434.             //            }else{
  1435.             //                $days = "1";
  1436.             //            }
  1437.         }
  1438.         //Lounge
  1439.         elseif($idcat =="10"){
  1440.             $informativo_days = "no";
  1441.             $pax = "1";
  1442.         }
  1443.         //Guia
  1444.         elseif($idcat =="8"){
  1445.             $informativo_days = "no";
  1446.             $pax = "1";
  1447.         }
  1448.         //Asistencia
  1449.         elseif($idcat =="15"){
  1450.             $informativo_days = "no";
  1451.             $days = '0';
  1452.         }else{
  1453.             $informativo_days = "no";
  1454.         }
  1456.         //Pax
  1457.         if(empty($pax) or $pax =="0"){
  1458.             $pax = "1";
  1459.         }
  1461.         //Over
  1462.         if(empty($over)){
  1463.             $over = "0";
  1464.         }
  1466.         if($informativo_days =="no"){
  1467.             //Days
  1468.             if(empty($days) or $days =="0"){
  1469.                 $days = "1";
  1470.             }else{
  1471.                 $days = $days + 1 ;
  1472.             }
  1473.         }
  1475.         $total_items = $price * $units * $pax * $days;
  1476. //        $total_pdirect = $price * $units * $pax * $days;
  1478.         $total_over = $over * $units * $pax * $days;
  1480. //        if($opover=='0'){
  1481. //            $total_neto = $total_items / $commission - $total_over ;
  1482. //            $precio_units = $precio_units - $over;
  1483. //        }
  1484. //        if($opover=='1'){
  1485. //            $total_neto = $total_items / $commission + $total_over;
  1486. //            $precio_units = $precio_units + $over;
  1487. //        }
  1489.         if(!empty($commission)){
  1490.             if($opcommission=='0'){
  1491.                 $total_neto = $total_items / $commission;
  1492.             }
  1493.             if($opcommission=='1'){
  1494.                 $total_neto = $total_items * $commission;
  1495.             }
  1496.         }else{
  1497.             $total_neto = $total_items;
  1498.         }
  1500.         if($opover=='0'){
  1501.             $total_neto = $total_neto - $total_over ;
  1502.             $precio_units = $precio_units - $over;
  1503.         }
  1504.         if($opover=='1'){
  1505.             $total_neto = $total_neto +  $total_over;
  1506.             $precio_units = $precio_units + $over;
  1507.         }
  1509.         $total_paying = $total_items * ($iva + 1);
  1511.         $total_comision ="0";
  1512.         $total_pago = $total_items;
  1513.         $total_iva = $total_items * $iva;
  1514.         $sub_total_iva = $total_neto * $iva;
  1516.         $total = $total_neto + $sub_total_iva;
  1518.         $benefit_moneda = $total_neto - $total_items;
  1520.         $data_calculos = array(
  1521.             'precio' => $precio_units,
  1522.             'total_days' => $days,
  1523.             'sub_total' => $total_items,
  1524.             'sub_total_iva' => $sub_total_iva,
  1525.             'total_neto' => $total_neto,
  1526.             'total_iva' => $total_iva,
  1527.             'total_paying' => $total_paying,
  1528.             'total_pago' => $total_pago,
  1529.             'total_comision' => $total_comision,
  1530.             'total' => $total,
  1531.             'benefit_moneda' => $benefit_moneda
  1532.         );
  1533.         return $data_calculos;
  1534.     }
  1537.     /**
  1538.      * @Route("/proposal/invoice/number/{id}", name="proposal_invoice_number")
  1539.      */
  1540.     public function InvoiceEmptyNumberAction($id, Request $request) {
  1541.         $em = $this->getDoctrine()->getManager();
  1542.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  1543.         $invoice = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  1544.         $client = $em->getRepository(Client::class)->findOneById($proposal->getClientId());
  1545.         $country = $em->getRepository(Country::class)->findOneById($client->getCountry());
  1546.         $client->setCountry($country->getCountry());
  1547.         $regions = $em->getRepository(Regions::class)->findOneById($client->getRegion());
  1548.         $client->setRegion($regions->getRegion());
  1549.         $province = $em->getRepository(Provinces::class)->findOneById($client->getProvince());
  1550.         $client->setProvince($province->getName());
  1551.         $cities = $em->getRepository(Cities::class)->findOneById($client->getPopulation());
  1552.         $client->setPopulation($cities->getCity());
  1554.         return $this->render('MDS/EventsBundle/invoice/add-number-invoice.html.twig', array(
  1555.             'id' => $id,
  1556.             'invoice' => $invoice,
  1557.             'mcp' => $proposal->getMcp(),
  1558.             'token' => $proposal->getAccessKey(),
  1559.             'proposal' => $proposal,
  1560.             'client' => $client,
  1561.         ));
  1562.     }
  1565.     /**
  1566.      * @Route("/proposal/invoice/number/updated/{id}", name="proposal_invoice_number_update")
  1567.      */
  1568.     public function InvoiceEmptyNumberupdateAction($id, Request $request)
  1569.     {
  1570.         $em = $this->getDoctrine()->getManager();
  1571.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  1572.         $invoice = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  1574.         $numberinvoice = $request->request->get('invoice')['number'];
  1575.         $dateAt = new \DateTime($request->request->get('invoice')['dateAt']);
  1577.         if(!empty($numberinvoice))
  1578.         {
  1579.             $invoice->setNumber($numberinvoice);
  1580.             $invoice->setDateAt($dateAt);
  1582.             // Envio correo al agente para informar que fue colocado el numero de factura
  1584.             $time = new \DateTime("now");
  1585.             $agent = $em->getRepository(User::class)->findOneById($proposal->getAgentId());
  1586.             $mailAgent[] = $agent->getEmail();
  1587.             $agentMail = $agent->getEmail();
  1588.             $passGmail = $agent->getPassGmail();
  1589.             $firmGmail = $agent->getFirmGmail();
  1590.             $mailAgentSent = array(
  1591.                 $agent->getEmail() => $agent->getName().' '. $agent->getLastName()
  1592.             );
  1594.             $body = 'P#'.$proposal->getId().', '.$proposal->getTitle().'<br>
  1595.                         <a href="http://'.$request->server->get('HTTP_HOST').'/events/events/proposal/edit/'.$proposal->getId().'">Ir al Proposal</a> - 
  1596.                         <a href="http://'.$request->server->get('HTTP_HOST').'/events/proposal/invoice/'.$proposal->getId().'">Ver Factura</a><br>
  1597.                         <br>Alerta de Fatura activada: '.$time->format('d/m/Y H:i:s').'<br><br>';
  1599.             $data = array(
  1600.                 'body' => $body,
  1601.                 'firm' => $firmGmail,
  1602.             );
  1604.             $mailTodos = array_merge($mailAgent);
  1606.             // EJECUTAR ENVIO DE ALERTA DE VISTO POR CLIENTE
  1607.             $transporter = new Swift_SmtpTransport();
  1608.             $transporter->setHost('smtp.gmail.com')
  1609.                 ->setEncryption('ssl') //ssl / tls
  1610.                 ->setPort(465) // 465 / 587
  1611.                 ->setUsername('desarrollo@develup.solutions')
  1612.                 ->setPassword('utvh hzoi wfdo ztjs');
  1613.             $mailer = new Swift_Mailer($transporter);
  1615.             $message = new Swift_Message();
  1616.             $message->setSubject('P#'.$proposal->getId().', Alerta de Fatura activada.')
  1617.                 ->setSender($agentMail)
  1618.                 ->setFrom($mailAgentSent)
  1619.                 ->setReplyTo($mailAgentSent)
  1620.                 ->setTo($mailTodos)
  1621.                 ->setBody(
  1622.                     $this->renderView(
  1623.                         'mail/structure-mail.html.twig',
  1624.                         array('data' => $data)
  1625.                     ),
  1626.                     'text/html'
  1627.                 )
  1628.             ;
  1629.             $mailer->send($message);
  1631.             /* Obtengo usuario logueado */
  1632.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1633.             $user_id = $user_logueado->getId();
  1635.             $proposal->setUpdatedId($user_id);
  1637.             $em->persist($invoice);
  1638.             $em->persist($proposal);
  1639.             $em->flush();
  1640.             $event = 'The Invoice has been Updated. Now';
  1642.             $successMessage = $this->translator->trans($event);
  1643.             $this->addFlash('mensajeproposaldestination', $successMessage);
  1645.         } else {
  1646.             $errorMessage = $this->translator->trans('Error, some fields are empty');
  1647.             $this->addFlash('mensajeproposaldestinationerror', $errorMessage);
  1648.         }
  1650.         return $this->redirectToRoute('proposal_invoice_number', array( 'id' => $id ));
  1651.     }
  1654.     /**
  1655.      * @Route("/proposal/invoice/number/liberate/{id}", name="proposal_invoice_number_liberate")
  1656.      */
  1657.     public function InvoiceEmptyNumberliberateAction($id, Request $request)
  1658.     {
  1659.         $em = $this->getDoctrine()->getManager();
  1660.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  1661.         $proposal->setStatus('Confirmed');
  1662.         $em->persist($proposal);
  1664.         $invoice = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  1665.         $em->remove($invoice);
  1666.         $em->flush();
  1667.         $event = 'The Invoice has been Liberate. Now';
  1669.         $successMessage = $this->translator->trans($event);
  1670.         $this->addFlash('mensajeproposaldestination', $successMessage);
  1672.         $feesInvoice = $em->getRepository(ProposalFeeInvoice::class)->findOneByProposalId($id);
  1673.         if (!empty($feesInvoice)){
  1674.             $em->remove($feesInvoice);
  1675.             $em->flush();
  1676.         }
  1678.         // Si existe el ProposalsStatistics se debe eliminar de la tabla también
  1679.         $propStats = $em->getRepository(ProposalsStatistics::class)->findOneBy([
  1680.             'proposalId' => $id,
  1681.             'proposalStatus' => 'Invoiced',
  1682.         ]);
  1684.         if (!empty($propStats)){
  1685.             $em->remove($propStats);
  1686.             $em->flush();
  1687.         }
  1689.         return $this->redirectToRoute('proposal_invoice_number', array( 'id' => $id ));
  1690.     }
  1693.     // Funcion para insertar historico de seguimiento
  1694.     // $textHistory = $this->translator->trans('');
  1695.     // $history = $this->TracingHistoryOperations($proposal->getId(), $text);
  1696.     private function TracingHistoryOperations($id, $text)
  1697.     {
  1698.         $em = $this->getDoctrine()->getManager();
  1699.         /* Obtengo usuario logueado */
  1700.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1701.         $user_id = $user_logueado->getId();
  1703.         $history = new ProposalTracing();
  1704.         $history->setDateAt(new \DateTime('now'));
  1705.         $history->setText($text);
  1706.         $history->setAgentId($user_id);
  1707.         $history->setProposalId($id);
  1708.         $history->setViewed('no');
  1709.         $history->setCreatedId($user_id);
  1710.         $history->setUpdatedId($user_id);
  1711.         $em->persist($history);
  1712.         $em->flush();
  1714.         $success = 'success';
  1715.         return $success;
  1716.     }
  1717. }