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

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 Swift_Mailer;
  41. use Swift_Message;
  42. use Swift_SmtpTransport;
  43. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  44. use Symfony\Component\Routing\Annotation\Route;
  45. use Symfony\Component\HttpFoundation\Request;
  46. use Symfony\Component\HttpFoundation\Response;
  47. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  48. use Symfony\Contracts\Translation\TranslatorInterface;
  51. class ProposalInvoiceController extends AbstractController
  52. {
  53.     private $translator;
  55.     public function __construct(TranslatorInterface $translator) {
  56.         $this->translator = $translator;
  57.     }
  59.     /*
  60.     * ATENCION LAS RAIZ DE @Route POR DEFECTO DEL BUNDLE: EventsBundle ES  /events/, NO PONERLO EN LA @Route("")
  61.     *
  62.     * */
  64.     /**
  65.      * @Route("/proposal/invoice/{id}",  name="proposal_invoice_detector")
  66.      */
  67.     public function detectorInvoiceAction($id, Request $request)
  68.     {
  69.         $em = $this->getDoctrine()->getManager();
  70.         $invoiceconsulta= array();
  71.         $typeconsulta ='';
  73.         $invoice = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  74.         if (!empty($invoice)){
  75.             $invoiceconsulta = $invoice;
  76.             $typeconsulta = $invoice->getType();
  77.         }
  79. //        $novatinvoice= $em->getRepository(ProposalNoVatInvoice::class)->findOneByProposalId($id);
  80. //        if (!empty($novatinvoice)){
  81. //            $invoiceconsulta = $novatinvoice;
  82. //            $typeconsulta = 'No Vat Invoice';
  83. //        }
  85. //        $invoiceconsulta = $em->getRepository(ProposalNoVatInvoice::class)->findOneByProposalId($id);
  86.         if (!empty($invoiceconsulta)){
  87.             $type = $typeconsulta;
  88. //            $number = $invoiceconsulta->getId();
  89.             $number = $invoiceconsulta->getNumber();
  90.             $date = $invoiceconsulta->getDateAt();
  91.             $prefix = $invoiceconsulta->getPrefix();
  93.             /* Obtengo usuario logueado */
  94.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  95.             $user_id = $user_logueado->getId();
  97.             $data = $this->baseInvoiceProposal($id, $type, $number, $prefix, $date, $request);
  98.             $token = $data['token'];
  100.             $em->clear();
  101.             $invoice_query = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  102.             $invoice_query->setTotalnet($data['totales_neto']);
  103.             $invoice_query->setVat(serialize($data['bases_imponibles']));
  104.             $invoice_query->setTotal($data['totales']);
  105.             $em->persist($invoice_query);
  106.             $em->flush();
  108.         }else{
  109.             return $this->redirectToRoute('proposal_generate_proforma',
  110.                 array(
  111.                     'id' => $id
  112.                 )
  113.             );
  114.         }
  116.         $fees = $em->getRepository(ProposalFeeInvoice::class)->findByProposalId($id);
  117.         if (!empty($fees)){ if (!($fees[0]->getToInvoice())){ $fees = null; } }     // Si no se debe mostrar en factura se pone a null
  119.         $summary = $em->getRepository(ProposalsInvoiceSummary::class)->findOneByProposalId($id);
  120.         $summaryInvoice = !empty($summary);
  121.         $summaryInvoiceText = !empty($summary) ? $summary->getDescription() : null;
  123.         $urlResumenPrecios = $this->generateUrl('proposal_summary_price', ['id' => $id]);
  124.         // Si ya existe en ProposalsStatistics el proposal facturado, no es necesario abrir el resumen
  125.         $propStats = $em->getRepository(ProposalsStatistics::class)->findBy([
  126.             'proposalId' => $id,
  127.             'proposalStatus' => 'Invoiced',
  128.         ]);
  129.         if (!empty($propStats)){ $urlResumenPrecios = null; }
  131.         return $this->render('MDS/EventsBundle/services/services-invoice-proposal.html.twig',
  132.             array(
  133.                 'id' => $id,
  134.                 'type' => $data['type'],
  135.                 'number' => $data['number'],
  136.                 'prefix' => $data['prefix'],
  137.                 'date' => $data['date'],
  138.                 'token' => $token,
  139.                 'proposal' => $data['proposal'],
  140.                 'company' => $data['company'],
  141.                 'clients' => $data['clients'],
  142.                 'datasupplier' => $data['datasupplier'],
  143.                 'totales_neto_antes' => $data['totales_neto_antes'],
  144.                 'totales_neto' => $data['totales_neto'], // totales neto
  145.                 'bases_imponibles' => $data['bases_imponibles'],
  146.                 'totales_antes' => $data['totales_antes'],
  147.                 'totales' => $data['totales'], // totales generales
  148.                 'balance' => $data['balance'],
  149.                 'totales_generales' => $data['totales_generales'],
  150.                 'currency' => $data['currency'],
  151.                 'detail_iva' => 'no',
  152.                 'discounts' => $data['discounts'],
  153.                 'fees' => $fees,
  154.                 'summaryInvoice' => $summaryInvoice,
  155.                 'summaryInvoiceText' => $summaryInvoiceText,
  156.                 'paymentInvoice' => $data['paymentInvoice'],
  157.                 'invoiceDesposit' => $data['invoiceDesposit'],
  158.                 'mcp' => $data['proposal']->getMcp(),
  159.                 'urlResumenPrecios' => $urlResumenPrecios,
  160.             )
  161.         );
  162.     }
  164.     /**
  165.      * @Route("/proposal/invoice/print/{id}",  name="proposal_invoice_detector_print")
  166.      */
  167.     public function detectorInvoicePrintAction($id, Request $request)
  168.     {
  169.         $em = $this->getDoctrine()->getManager();
  170.         $invoiceconsulta= array();
  171.         $typeconsulta ='';
  173.         $invoice= $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  174.         if (!empty($invoice)){
  175.             $invoiceconsulta = $invoice;
  176.             $typeconsulta = $invoice->getType();
  177.         }
  179. //        $novatinvoice= $em->getRepository(ProposalNoVatInvoice::class)->findOneByProposalId($id);
  180. //        if (!empty($novatinvoice)){
  181. //            $invoiceconsulta = $novatinvoice;
  182. //            $typeconsulta = 'No Vat Invoice';
  183. //        }
  185. //        $invoiceconsulta = $em->getRepository(ProposalNoVatInvoice::class)->findOneByProposalId($id);
  186.         if (!empty($invoiceconsulta)){
  187.             $type = $typeconsulta;
  188. //            $number = $invoiceconsulta->getId();
  189.             $number = $invoiceconsulta->getNumber();
  190.             $date = $invoiceconsulta->getDateAt();
  191.             $prefix = $invoiceconsulta->getPrefix();
  192.             $data = $this->baseInvoiceProposal($id, $type, $number, $prefix, $date, $request);
  193.             $token = $data['token'];
  194.         }else{
  195.             return $this->redirectToRoute('proposal_generate_proforma', array( 'id' => $id ));
  196.         }
  198.         $fees = $em->getRepository(ProposalFeeInvoice::class)->findByProposalId($id);
  200.         if (!empty($fees)){
  201.             $fees[0]->setAmount($fees[0]->getFeeNet());
  202.             if (!($fees[0]->getToInvoice())){ $fees = null; } } // Si no se debe mostrar en factura se pone a null
  204.         $summary = $em->getRepository(ProposalsInvoiceSummary::class)->findOneByProposalId($id);
  205.         $summaryInvoice = !empty($summary);
  206.         $summaryInvoiceText = !empty($summary) ? $summary->getDescription() : null;
  208.         return $this->render('MDS/EventsBundle/services/services-invoice-print-proposal.html.twig',
  209.             array(
  210.                 'id' => $id,
  211.                 'type' => $data['type'],
  212.                 'number' => $data['number'],
  213.                 'prefix' => $data['prefix'],
  214.                 'date' => $data['date'],
  215.                 'token' => $token,
  216.                 'proposal' => $data['proposal'],
  217.                 'company' => $data['company'],
  218.                 'clients' => $data['clients'],
  219.                 'datasupplier' => $data['datasupplier'],
  220.                 'totales_neto_antes' => $data['totales_neto_antes'],
  221.                 'totales_neto' => $data['totales_neto'],
  222.                 'bases_imponibles' => $data['bases_imponibles'],
  223.                 'totales_antes' => $data['totales_antes'],
  224.                 'totales' => $data['totales'],
  225.                 'balance' => $data['balance'],
  226.                 'totales_generales' => $data['totales_generales'],
  227.                 'currency' => $data['currency'],
  228.                 'detail_iva' => 'no',
  229.                 'discounts' => $data['discounts'],
  230.                 'fees' => $fees,
  231.                 'paymentInvoice' => $data['paymentInvoice'],
  232.                 'invoiceDesposit' => $data['invoiceDesposit'],
  233.                 'summaryInvoice' => $summaryInvoice,
  234.                 'summaryInvoiceText' => $summaryInvoiceText,
  235.             )
  236.         );
  238.     }
  241.     /**
  242.      * @Route("/proposal/generate/proforma/{id}",  name="proposal_generate_proforma")
  243.      */
  244.     public function generateProformaAction($id, Request $request)
  245.     {
  246.         $em = $this->getDoctrine()->getManager();
  247.         $proforma = $em->getRepository(ProposalProforma::class)->findOneByProposalId($id);
  249.         $prefix = "MP".date('ymd')."-";
  250.         if (is_null($proforma)){
  251.             $proforma_new = new ProposalProforma();
  252.             $proforma_new->setProposalId($id);
  253.             $proforma_new->setPrefix($prefix);
  254.             $proforma_new->setDateAt(new \DateTime("now"));
  256.             /* Obtengo usuario logueado */
  257.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  258.             $user_id = $user_logueado->getId();
  260.             $proforma_new->setCreatedId($user_id);
  261.             $proforma_new->setUpdatedId($user_id);
  263.             $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  264.             if($proposal->getStatus() != 'Invoiced'){
  265.                 $em->persist($proforma_new);
  266.                 $em->flush();
  267.             }
  268.         }
  270.         return $this->redirectToRoute('proposal_invoice_proforma', array( 'id' => $id ) );
  271.     }
  273.     /**
  274.      * @Route("/proposal/invoice/proforma/{id}",  name="proposal_invoice_proforma")
  275.      */
  276.     public function detailsProformaAction($id, Request $request)
  277.     {
  278.         $data = array();
  279.         $em = $this->getDoctrine()->getManager();
  280.         $paymentsClient = new ProposalPaymentsClient();
  281.         $paymentsClient->setProposalId($id);
  282.         $form = $this->createProposalPaymentsClientForm($paymentsClient);
  284.         $payments = $em->getRepository(ProposalPaymentsClient::class)->findByProposalId($id);
  286.         $proforma = $em->getRepository(ProposalProforma::class)->findOneByProposalId($id);
  287.         if (!empty($proforma)){
  288.             $type = 'Proforma';
  289.             $number = $proforma->getId();
  290.             $date = $proforma->getDateAt();
  291.             $prefix = $proforma->getPrefix();
  293.             $data = $this->baseInvoiceProposal($id, $type, $number, $prefix, $date, $request);
  294.             $token = $data['token'];
  295.         } else {
  296.             return $this->redirectToRoute('proposal_generate_proforma', array( 'id' => $id ));
  297.         }
  299.         $fees = $em->getRepository(ProposalFee::class)->findByProposalId($id);
  300.         if (!empty($fees)){ if (!($fees[0]->getToInvoice())){ $fees = null; } } // Si no se debe mostrar en factura se pone a null
  302.         return $this->render('MDS/EventsBundle/services/services-proforma-proposal.html.twig',
  303.             array(
  304.                 'id' => $id,
  305.                 'type' => $data['type'],
  306.                 'number' => $data['number'],
  307.                 'prefix' => $data['prefix'],
  308.                 'date' => $data['date'],
  309.                 'token' => $token,
  310.                 'proposal' => $data['proposal'],
  311.                 'company' => $data['company'],
  312.                 'clients' => $data['clients'],
  313.                 'datasupplier' => $data['datasupplier'],
  314.                 'totales_neto_antes' => $data['totales_neto_antes'],
  315.                 'totales_neto' => $data['totales_neto'],
  316.                 'bases_imponibles' => $data['bases_imponibles'],
  317.                 'totales_antes' => $data['totales_antes'],
  318.                 'totales' => $data['totales'],
  319.                 'balance' => $data['balance'],
  320.                 'totales_generales' => $data['totales_generales'],
  321.                 'currency' => $data['currency'],
  322.                 'detail_iva' => 'yes',
  323.                 'discounts' => $data['discounts'],
  324.                 'fees' => $fees,
  325.                 'paymentInvoice' => $data['paymentInvoice'],
  326.                 'payments' => $payments,
  327.                 'invoiceDesposit' => $data['invoiceDesposit'],
  328.                 'form' => $form->createView(),
  329.                 'mcp' => $data['proposal']->getMcp(),
  330.             )
  331.         );
  332.     }
  334.     private function createProposalPaymentsClientForm(ProposalPaymentsClient $entity)
  335.     {
  336.         $form = $this->createForm(ProposalPaymentsClientType::class, $entity, array(
  337.             'action' => $this->generateUrl('proposal_payments_client_add'),
  338.             'method' => 'POST'
  339.         ));
  341.         return $form;
  342.     }
  344.     /**
  345.      * @Route("/proposal/payments", name="proposal_payments_client_add")
  346.      */
  347.     public function createAction(Request $request)
  348.     {
  349.         $paymentsClient = new ProposalPaymentsClient();
  350.         $form = $this->createProposalPaymentsClientForm($paymentsClient);
  351.         $form->handleRequest($request);
  353.         if($form->isValid())
  354.         {
  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', array( 'id' => $paymentsClient->getProposalId()));
  386.         } else {
  387.             $errorMessage = $this->translator->trans('Error, some fields are empty');
  388.             $this->addFlash('mensajepaymentsclienterror', $errorMessage);
  389.         }
  391.         return $this->redirectToRoute('proposal_invoice_proforma', array( 'id' => $paymentsClient->getProposalId()) );
  392.     }
  395.     /**
  396.      * @Route("/proposal/pdfpdf",  name="proposal_invoice_proforma_pdf_prueba")
  397.      */
  398.     public function pdfAction()
  399.     {
  400.         $snappy = $this->get('knp_snappy.pdf');
  401.         $filename = 'myFirstSnappyPDF';
  402.         $url = 'http://mante.develup.solutions';
  404.         return new Response(
  405.             $snappy->getOutput($url),
  406.             200,
  407.             array(
  408.                 'Content-Type'          => 'application/pdf',
  409.                 'Content-Disposition'   => 'inline; filename="'.$filename.'.pdf"'
  410.             )
  411.         );
  412.     }
  415.     /**
  416.      * @Route("/proposal/invoice/proforma/pdf/{id}",  name="proposal_invoice_proforma_pdf")
  417.      */
  418.     public function detailsProformaPdfActionAction($id, Request $request)
  419.     {
  420.         $snappy = $this->get('knp_snappy.pdf');
  421.         $filename = 'myFirstSnappyPDF';
  423.         // use absolute path !
  424.         $pageUrl = $this->generateUrl('proposal_invoice_proforma_print_externo', array('id'=>$id), UrlGeneratorInterface::ABSOLUTE_URL);
  426.         return new Response(
  427.             $snappy->getOutput($pageUrl),
  428.             200,
  429.             array(
  430.                 'Content-Type'          => 'application/pdf',
  431.                 'Content-Disposition'   => 'inline; filename="'.$filename.'.pdf"'
  432.             )
  433.         );
  434.     }
  437.     /**
  438.      * @Route("/proposal/invoice/pdf/{id}",  name="proposal_invoice_proforma_pdf")
  439.      */
  440.     public function detailsInvoicePdfActionAction($id, Request $request)
  441.     {
  442.         $snappy = $this->get('knp_snappy.pdf');
  443.         $filename = 'myFirstSnappyPDF';
  445.         // use absolute path !
  446.         $pageUrl = $this->generateUrl('proposal_invoice_detector_print_externo', array('id'=>$id), UrlGeneratorInterface::ABSOLUTE_URL);
  448.         return new Response(
  449.             $snappy->getOutput($pageUrl),
  450.             200,
  451.             array(
  452.                 'Content-Type'          => 'application/pdf',
  453.                 'Content-Disposition'   => 'inline; filename="'.$filename.'.pdf"'
  454.             )
  455.         );
  456.     }
  459.     /**
  460.      * @Route("/proposal/invoice/proforma/print/{id}",  name="proposal_invoice_proforma_print")
  461.      */
  462.     public function detailsProformaPrintAction($id, Request $request)
  463.     {
  464. //        $token = "";
  465.         $em = $this->getDoctrine()->getManager();
  466.         $proforma = $em->getRepository(ProposalProforma::class)->findOneByProposalId($id);
  467.         if (!empty($proforma)){
  468.             $type = 'Proforma';
  469.             $number = $proforma->getId();
  470.             $date = $proforma->getDateAt();
  471.             $prefix = $proforma->getPrefix();
  472.             $data = $this->baseInvoiceProposal($id, $type, $number, $prefix, $date, $request);
  473.             $token = $data['token'];
  474.         } else {
  475.             return $this->redirectToRoute('proposal_generate_proforma', array( 'id' => $id ));
  476.         }
  478.         $fees = $em->getRepository(ProposalFee::class)->findByProposalId($id);
  479.         if (!empty($fees)){ if (!($fees[0]->getToInvoice())){ $fees = null; } } // Si no se debe mostrar en factura se pone a null
  481.         $summary = $em->getRepository(ProposalsInvoiceSummary::class)->findOneByProposalId($id);
  482.         $summaryInvoice = !empty($summary);
  483.         $summaryInvoiceText = !empty($summary) ? $summary->getDescription() : null;
  485.         return $this->render('MDS/EventsBundle/services/services-invoice-print-proposal.html.twig',
  486.             array(
  487.                 'id' => $id,
  488.                 'type' => $data['type'],
  489.                 'number' => $data['number'],
  490.                 'prefix' => $data['prefix'],
  491.                 'date' => $data['date'],
  492.                 'token' => $token,
  493.                 'proposal' => $data['proposal'],
  494.                 'company' => $data['company'],
  495.                 'clients' => $data['clients'],
  496.                 'datasupplier' => $data['datasupplier'],
  497.                 'totales_neto_antes' => $data['totales_neto_antes'],
  498.                 'totales_neto' => $data['totales_neto'],
  499.                 'bases_imponibles' => $data['bases_imponibles'],
  500.                 'totales_antes' => $data['totales_antes'],
  501.                 'totales' => $data['totales'],
  502.                 'balance' => $data['balance'],
  503.                 'totales_generales' => $data['totales_generales'],
  504.                 'currency' => $data['currency'],
  505.                 'detail_iva' => 'yes',
  506.                 'discounts' => $data['discounts'],
  507.                 'fees' => $fees,
  508.                 'paymentInvoice' => $data['paymentInvoice'],
  509.                 'summaryInvoice' => $summaryInvoice,
  510.                 'invoiceDesposit' => $data['invoiceDesposit'],
  511.                 'summaryInvoiceText' => $summaryInvoiceText,
  512.             )
  513.         );
  514.     }
  517.     /**
  518.      * @Route("/proposal/generate/invoice/{id}",  name="proposal_generate_invoice")
  519.      */
  520.     public function generateInvoiceAction($id, Request $request)
  521.     {
  522.         $em = $this->getDoctrine()->getManager();
  523.         $invoiceGenerate = $request->request->get('invoiceGenerate');
  524.         $invoice= $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  526.         if (is_null($invoice)){
  527.             $proposal= $em->getRepository(Proposal::class)->findOneById($id);
  528.             $status = $proposal->getStatus(); // Para controlar que se guarde si no está facturado
  529.             $proposal->setStatus('Invoiced');
  531.             $invoice_new = new ProposalInvoice();
  532.             $invoice_new->setNumber($invoiceGenerate['number']);
  533.             $invoice_new->setDateAt(new \DateTime($invoiceGenerate['dateInvoice']));
  534.             $invoice_new->setType($invoiceGenerate['type']);
  535.             $invoice_new->setProposalId($invoiceGenerate['id']);
  536.             $invoice_new->setPrefix('');
  537. //            $invoice_new->setDateAt(new \DateTime("now"));
  539.             /* Obtengo usuario logueado */
  540.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  541.             $user_id = $user_logueado->getId();
  543.             $invoice_new->setCreatedId($user_id);
  544.             $invoice_new->setUpdatedId($user_id);
  546.             if($status != 'Invoiced'){
  547.                 $em->persist($invoice_new);
  548.                 $em->persist($proposal);
  549.                 $em->flush();
  550.             }
  552.             //Envio correo a administracion en el caso que no tenga numero de factura y este como no enviado
  553.             if( empty($invoiceGenerate['number'])){
  554.                 $time = new \DateTime("now");
  555.                 $agent = $em->getRepository(User::class)->findOneBy(
  556.                     array(
  557.                         "id" => $proposal->getAgentId(),
  558.                         "status" => VacationsConstants::PAYROLL_STAFF_STATUS
  559.                     )
  560.                 )
  561.                 ;
  562.                 $mailAgent[] = $agent->getEmail();
  563.                 $agentMail = $agent->getEmail();
  564.                 $passGmail = $agent->getPassGmail();
  565.                 $firmGmail = $agent->getFirmGmail();
  566.                 $mailAgentSent = array(
  567.                     $agent->getEmail() => $agent->getName().' '. $agent->getLastName()
  568.                 );
  570.                 $setting_rol = $em->getRepository(SettingsRol::class)->findBy(
  571.                     array(
  572.                         'weight' => array('2','3'),
  573.                         'madmin' => '1',
  574.                     )
  575.                 );
  576.                 $mailAdmin = array();
  577.                 foreach($setting_rol as $settingRol){
  578.                     $administration = $em->getRepository(User::class)->findByUserrol($settingRol->getId());
  579.                     foreach($administration as $admin){ $mailAdmin[] = $admin->getEmail(); }
  580.                 }
  581.                 $body ='P#'.$proposal->getId().', '.$proposal->getTitle().'<br><br>
  582.                             <a href="http://'.$request->server->get('HTTP_HOST').'/events/proposal/invoice/number/'.$proposal->getId().'">Asignar Número de Factura</a><br>
  583.                             <a href="http://'.$request->server->get('HTTP_HOST').'/events/proposal/edit/'.$proposal->getId().'">Ir al Proposal</a> - 
  584.                             <a href="http://'.$request->server->get('HTTP_HOST').'/events/proposal/summary/prices/'.$proposal->getId().'">Ver Resumen</a>
  585.                             <br><br>
  586.                             Alerta de solicitud automatizada de número de factura en fecha: '.$time->format('d/m/Y H:i:s').'<br><br>';
  588.                 $data = array(
  589.                     'body' => $body,
  590.                     'firm' => $firmGmail,
  591.                 );
  593.                 $mailTodos = array_merge($mailAgent, $mailAdmin);
  595.                 // EJECUTAR ENVIO DE ALERTA DE VISTO POR CLIENTE
  596.                 $transporter = new Swift_SmtpTransport();
  597.                 $transporter->setHost('smtp.gmail.com')
  598.                     ->setEncryption('ssl') //ssl / tls
  599.                     ->setPort(465) // 465 / 587
  600.                     ->setUsername('desarrollo@develup.solutions')
  601.                     ->setPassword('utvh hzoi wfdo ztjs');
  602.                 $mailer = new Swift_Mailer($transporter);
  604.                 $message = new Swift_Message();
  605.                 $message->setSubject('P#'.$proposal->getId().', Solicitud de número de factura automatizada')
  606.                     ->setSender($agentMail)
  607.                     ->setFrom($mailAgentSent)
  608.                     ->setReplyTo($mailAgentSent)
  609.                     ->setTo($mailTodos)
  610.                     ->setBody(
  611.                         $this->renderView(
  612.                             'mail/structure-mail.html.twig',
  613.                             array('data' => $data)
  614.                         ),
  615.                         'text/html'
  616.                     )
  617.                 ;
  618.                 $mailer->send($message);
  619.             }
  621.             // Guardo en historico de seguimiento
  622.             $textHistory = $this->translator->trans('Billed Proposal');
  623.             $history = $this->TracingHistoryOperations($proposal->getId(), $textHistory);
  625.             // Verificamos si se debe crear un Fee asociado a la factura
  626.             $fee = $em->getRepository(ProposalFee::class)->findOneByProposalId($id);
  628.             if (!empty($fee)){
  629.                 $feeInvoice = new ProposalFeeInvoice();
  630.                 $feeInvoice->setProposalId($id);
  631.                 $feeInvoice->setName($fee->getName());
  632.                 $feeInvoice->setType($fee->getType());
  633.                 $feeInvoice->setAmount($fee->getAmount());
  634.                 $feeInvoice->setOpIva($fee->getOpIva());
  635.                 $feeInvoice->setIva($fee->getIva());
  636.                 $feeInvoice->setToInvoice($fee->getToInvoice());
  637.                 $feeInvoice->setInvoiceId($invoice_new->getId());
  638.                 $feeInvoice->setFeeNet(0);
  639.                 $feeInvoice->setFeeTotal(0);
  640.                 $feeInvoice->setCreatedId($user_id);
  641.                 $feeInvoice->setCreatedAt(new \DateTime("now"));
  643.                 if($status != 'Invoiced'){
  644.                     $em->persist($feeInvoice);
  645.                     $em->flush();
  646.                 }
  647.             }
  648.         }
  649.         return $this->redirectToRoute('proposal_invoice_detector', array( 'id' => $invoiceGenerate['id']));
  650.     }
  653.     /**
  654.      * @Route("/proposal/invoice/proforma/payments/delete/{id}",  name="proposal_invoice_proforma_payments_delete")
  655.      */
  656.     public function deletePaymentsProformaAction($id, Request $request)
  657.     {
  658.         $em = $this->getDoctrine()->getManager();
  659.         $delete= $em->getRepository(ProposalPaymentsClient::class)->findOneById($id);
  660.         $proposalId = $delete->getProposalId();
  662.         $em->remove($delete);
  663.         $em->flush();
  665.         return $this->redirectToRoute('proposal_invoice_proforma', array( 'id' =>$proposalId ));
  666.     }
  669.     private function baseInvoiceProposal($id, $type, $number, $prefix, $date, Request $request)
  670.     {
  671.         $em = $this->getDoctrine()->getManager();
  672.         $proposal= $em->getRepository(Proposal::class)->findOneById($id);
  674.         $services_supplier = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findBy(
  675.             array(
  676.                 'proposalId' => $id,
  677.                 'serviceIdFather' => '0'
  678.             ),
  679.             array(
  680.                 'id' => 'ASC'
  681.             )
  682.         );
  683.         $data_iva = array();
  684.         $supplier_control = array();
  685.         foreach($services_supplier as $servicessupplier){
  686. ////            $supplier_control[$servicessupplier->getSupplierId()] = $servicessupplier->getSupplierId();
  687. //            $supplier_control[$servicessupplier->getSupplierId()] = array(
  688. //                'id' => $servicessupplier->getSupplierId(),
  689. //                'destinoId' => $servicessupplier->getDestinationId(),
  690. //            );
  692.             if(!is_null($servicessupplier->getActivityId())){
  693.                 $supplier_control[$servicessupplier->getActivityId()] = array(
  694.                     'master' => 'activity',
  695.                     'id' => $servicessupplier->getActivityId(),
  696.                     'destinoId' => $servicessupplier->getDestinationId(),
  697.                 );
  698.             }
  699.             if(!is_null($servicessupplier->getIdeaId())){
  700.                 $supplier_control[$servicessupplier->getIdeaId()] = array(
  701.                     'master' => 'idea',
  702.                     'id' => $servicessupplier->getIdeaId(),
  703.                     'destinoId' => $servicessupplier->getDestinationId(),
  704.                 );
  705.             }
  706.             if((!is_null($servicessupplier->getSupplierId())) and ($servicessupplier->getIdeaId() == null) and ($servicessupplier->getActivityId() == null)){
  707.                 $supplier_control[$servicessupplier->getSupplierId()] = array(
  708.                     'master' => 'supplier',
  709.                     'id' => $servicessupplier->getSupplierId(),
  710.                     'destinoId' => $servicessupplier->getDestinationId(),
  711.                 );
  712.             }
  713.         }
  715.         $data_serviceCat = array();
  716.         $data_supplier = array();
  717.         $totales_neto_all = 0;
  718.         $totales_all = 0;
  719.         $currency ="";
  720.         $data_service_supplier = array();
  721.         foreach($supplier_control as $suppliercontrol){
  722. //            $destination = $em->getRepository(Destination::class)->findOneById($suppliercontrol['destinoId']);
  723.             $destination = $em->getRepository(Destination::class)->findOneById($suppliercontrol['destinoId']);
  725.             $colorlabel= "bg-success-300";
  727.             $sqlactivities = "";
  728.             if($suppliercontrol['master'] == 'activity'){
  729.                 $master = "activity";
  730.                 $sqlactivities = $em->getRepository(Activities::class)->findOneById($suppliercontrol['id']);
  732.                 // ORDEN DESCENDENTE Y POR SERVICES
  733.                 $parameters = array(
  734.                     'proposalId' => $id,
  735.                     'serviceIdFather' => '0',
  736.                     'activityId' => $suppliercontrol['id']
  737.                 );
  738.                 $dql = 'SELECT p
  739.                     FROM EventsBundle:ProposalSupplierServicesCostsClient p
  740.                     WHERE p.proposalId = :proposalId AND p.activityId = :activityId AND p.serviceIdFather = :serviceIdFather 
  741.                     ORDER BY p.serviceCatId, p.rank ASC ';
  743.                 $query = $em->createQuery($dql)->setParameters($parameters);
  744.                 $data_service_supplier = $query->getResult();
  745.             }
  747.             $sqlideas = "";
  748.             if($suppliercontrol['master'] == 'idea'){
  749.                 $master = "idea";
  750.                 $sqlideas = $em->getRepository(Ideas::class)->findOneById($suppliercontrol['id']);
  752.                 // ORDEN DESCENDENTE Y POR SERVICES
  753.                 $parameters = array(
  754.                     'proposalId' => $id,
  755.                     'serviceIdFather' => '0',
  756.                     'ideaId' => $suppliercontrol['id']
  757.                 );
  758.                 $dql = 'SELECT p
  759.                     FROM EventsBundle:ProposalSupplierServicesCostsClient p
  760.                     WHERE p.proposalId = :proposalId AND p.ideaId = :ideaId AND p.serviceIdFather = :serviceIdFather 
  761.                     ORDER BY p.serviceCatId, p.rank ASC ';
  763.                 $query = $em->createQuery($dql)->setParameters($parameters);
  764.                 $data_service_supplier = $query->getResult();
  765.             }
  767.             $sqlsuppliers ="";
  768.             if($suppliercontrol['master'] == 'supplier'){
  769.                 $master = "supplier";
  770.                 $sqlsuppliers = $em->getRepository(Supplier::class)->findOneById($suppliercontrol['id']);
  771.                 if(!is_null($sqlsuppliers)){
  772.                     switch ($sqlsuppliers->getStar()) {
  773.                         case 1: $sqlsuppliers->setStar('<i class="icon-star-full2"></i>'); break;
  774.                         case 2: $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i>'); break;
  775.                         case 3: $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i>'); break;
  776.                         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;
  777.                         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;
  778.                         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;
  779.                         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;
  780.                         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;
  781.                     }
  782.                 }
  783.                 // ORDEN DESCENDENTE Y POR SERVICES
  784.                 $parameters = array(
  785.                     'proposalId' => $id,
  786.                     'serviceIdFather' => '0',
  787.                     'supplierId' => $suppliercontrol['id']
  788.                 );
  789.                 $dql = 'SELECT p
  790.                     FROM EventsBundle:ProposalSupplierServicesCostsClient p
  791.                     WHERE p.proposalId = :proposalId AND p.supplierId = :supplierId AND p.ideaId is null AND p.activityId is null AND p.serviceIdFather = :serviceIdFather 
  792.                     ORDER BY p.serviceCatId, p.rank ASC ';
  794.                 $query = $em->createQuery($dql)->setParameters($parameters);
  795.                 $data_service_supplier = $query->getResult();
  797.                 // Agrupamos asistencias de In-Out por ID de Agente
  798.                 $new_data_service_supplier = array();
  799.                 $arregloAcumulador = array();
  800.                 $acumulador = array();
  802.                 if ($sqlsuppliers->getCompany() == 'IN OUT TRAVEL & EVENTS') {
  803.                     // El proveedor es In Out
  804.                     foreach ($data_service_supplier as $dtsp){
  805.                         $zNameSrvOrNameUsr = $em->getRepository(ProposalsSupplierServicesAssistantName::class)->findOneByPrpSupSrvId($dtsp->getServiceIdProposal());
  807.                         if ($dtsp->getServiceCatId() != 15){
  808.                             $new_data_service_supplier[] = $dtsp;
  809.                         } else {
  810.                             // Tenemos una asistencia de In Out
  811.                             // vamos acumulando precios, over, etc
  813.                             if ((! array_key_exists($dtsp->getAssistantId().'-'.$dtsp->getPrice(),$arregloAcumulador) ) and (!is_null($dtsp->getAssistantId()))){
  815. //                                Antes se comprobaba solo con el id ahora el id del agente y el precio de la asistencia
  816. //                                $zAg= $em->getRepository(User::class)->findOneById($dtsp->getAssistantId());
  817. //                                $dtsp->setName('Staff In Out Events: '. $zAg->getName(). ' ' . $zAg->getLastName());
  818. //                                $dtsp->setUnits(1);
  819. //                                $arregloAcumulador[$dtsp->getAssistantId()] = $dtsp;
  821.                                 $zAg= $em->getRepository(User::class)->findOneById($dtsp->getAssistantId());
  822. //                                if($zAg->getId() == 20){
  823. //                                  AQUI TENDRIAMOS LA CONDICION PARA QUE APAREZCA O NO EL NOMBRE EDL AGENTE (FUTURO DESARROLLO)
  824. //                                }else {
  825.                                 if (empty($zNameSrvOrNameUsr) && !is_null($zAg)) {
  826.                                     $dtsp->setName('Staff In Out Events: ' . $zAg->getName() . ' ' . $zAg->getLastName());
  827.                                 }
  828. //                                }
  829.                                 $dtsp->setUnits(1);
  830.                                 $arregloAcumulador[$dtsp->getAssistantId().'-'.$dtsp->getPrice()] = $dtsp;
  832.                             } else {
  834.                                 if ((!is_null($dtsp->getAssistantId()))){
  835. //                                Antes se comprobaba sololo con el id ahora el id del agente y el precio de la asistencia
  836. //                                $tempAcum = $arregloAcumulador[$dtsp->getAssistantId()];
  837.                                     $tempAcum = $arregloAcumulador[$dtsp->getAssistantId().'-'.$dtsp->getPrice()];
  839.                                     $tempAcum->setUnits($tempAcum->getUnits() + 1);
  841.                                     //Si el dia de inicio es menor actualizas (para establecer rangos de varios dias)
  842.                                     if ($dtsp->getDateInAt() < $tempAcum->getDateInAt()) {
  843.                                         $tempAcum->setDateInAt($dtsp->getDateInAt());
  844.                                     }
  845.                                     //Si el dia de fin es mayor actualizas (para establecer rangos de varios dias)
  846.                                     if ($dtsp->getDateOutAt() > $tempAcum->getDateOutAt()) {
  847.                                         $tempAcum->setDateOutAt($dtsp->getDateOutAt());
  848.                                     }
  850. //                                Antes se comprobaba sololo con el id ahora el id del agente y el precio de la asistencia
  851. //                                $arregloAcumulador[$dtsp->getAssistantId()] = $tempAcum;
  852.                                     $arregloAcumulador[$dtsp->getAssistantId().'-'.$dtsp->getPrice()] = $tempAcum;
  853.                                 } else {
  855.                                     // Tenemos una asistencia de un agente EXTERNO - este agente no se encuentra en el listado de agentes de In Out
  857.                                     if ( array_key_exists($dtsp->getName(),$arregloAcumulador) ){
  858.                                         $tempAcum = $arregloAcumulador[$dtsp->getName()];
  860.                                         $tempAcum->setUnits($tempAcum->getUnits() + 1);
  861.                                         if (empty($zNameSrvOrNameUsr)) {
  862.                                             $tempAcum->setName('Staff In Out Events: ' . $dtsp->getName());
  863.                                         }
  865.                                         //Si el dia de inicio es menor actualizas (para establecer rangos de varios dias)
  866. //                                        if ($dtsp->getDateInAt() < $tempAcum->getDateInAt()) {
  867. //                                            $tempAcum->setDateInAt($dtsp->getDateInAt());
  868. //                                        }
  869. //                                        //Si el dia de fin es mayor actualizas (para establecer rangos de varios dias)
  870. //                                        if ($dtsp->getDateOutAt() > $tempAcum->getDateOutAt()) {
  871. //                                            $tempAcum->setDateOutAt($dtsp->getDateOutAt());
  872. //                                        }
  874.                                         $arregloAcumulador[$dtsp->getName()] = $tempAcum;
  875.                                     } else {
  876.                                         $arregloAcumulador[$dtsp->getName()] = $dtsp;
  877.                                         if (empty($zNameSrvOrNameUsr)) {
  878.                                             $arregloAcumulador[$dtsp->getName()]->setName('Staff In Out Events: ' . $dtsp->getName());
  879.                                         }
  880.                                     }
  881.                                 }
  882.                             }
  883.                         }
  884.                     }
  886.                     foreach ($arregloAcumulador as $aAc){ $new_data_service_supplier[] = $aAc; }
  887.                     $data_service_supplier = $new_data_service_supplier;
  888.                 }
  889.                 // FIN  -  Agrupamos asistencias de In-Out por ID de Agente
  890.             }
  891.             $imagenSmall = null;
  893.             $service_supplier_data = array();
  894.             $totales_neto ='0';
  895.             $totales_iva ='0';
  896.             $totales_con_iva ='0';
  897.             $totales_paying ='0';
  898.             $totales_pago ='0';
  899.             $totales_benefit_moneda ='0';
  900.             $totales_benefit_porsentaje ='0';
  901.             foreach($data_service_supplier as $data_service){
  902.                 //Currency
  903.                 $currency = $data_service->getCurrency();
  904.                 if (isset($currency)){$currency="Euro";}
  905.                 if ($currency == "Euro"){$currency="€";}
  906.                 if ($currency == "Dolar"){$currency=" $";}
  907.                 if ($currency == "MXN"){$currency=" MXN";}
  908.                 $data_service->setCurrency($currency);
  910.                 $idcat = $data_service->getServiceCatId();
  911.                 $price = ($data_service->getPrice() == "")? 0 : $data_service->getPrice();
  912.                 $units = ($data_service->getUnits() == "")? 0 : $data_service->getUnits();
  913.                 $pax = ($data_service->getPax() == "")? 0 : $data_service->getPax();
  914.                 $opcommission = $data_service->getOpCommission();
  915.                 $commission = $data_service->getCommission();
  916.                 $opover = $data_service->getOpOver();
  917.                 $over = $data_service->getOver();
  918.                 $opiva = $data_service->getOpIva();
  919. //                $iva = $data_service->getIva();
  920.                 $iva = empty($data_service->getIva())? 0 : $data_service->getIva();
  921.                 $dateInAt = $data_service->getDateInAt();
  922.                 $dateOutAt = $data_service->getDateOutAt();
  923.                 if (!is_null($dateInAt) and !is_null($dateOutAt)){
  924.                     $days = $dateInAt->diff($dateOutAt);
  925.                     $day = $days->days;
  926.                 }else{
  927.                     $day = "0";
  928.                 }
  929.                 if(!is_null($data_service->getActivityId())){
  930.                     $name_supplier = $em->getRepository(Activities::class)->findOneById($data_service->getActivityId());
  931.                     if (empty($name_supplier)){ $namesupplier = ''; } else { $namesupplier = $name_supplier->getName(); }
  932.                 }
  934.                 if(!is_null($data_service->getIdeaId())){
  935.                     $name_supplier = $em->getRepository(Ideas::class)->findOneById($data_service->getIdeaId());
  936.                     if (empty($name_supplier)){ $namesupplier = ''; } else { $namesupplier = $name_supplier->getName(); }
  937.                 }
  939.                 if((!is_null($data_service->getSupplierId())) and ($data_service->getIdeaId() == null) and ($data_service->getActivityId() == null) ){
  940.                     $name_supplier = $em->getRepository(Supplier::class)->findOneById($data_service->getSupplierId());
  941.                     if (empty($name_supplier)){ $namesupplier = ''; } else { $namesupplier = $name_supplier->getName(); }
  942.                 }
  944. //                $name_supplier = $em->getRepository(Supplier::class)->findOneById($data_service->getSupplierId());
  945. //                $namesupplier = $name_supplier->getName();
  947.                 if($type == 'No Vat Invoice'){
  948.                     $iva="0";
  949.                     $data_service->setIva($iva);
  950.                 }
  952.                 $calculos = $this->CalculoTotalesservices($price, $units, $pax, $day, $opcommission, $commission, $opover, $over, $opiva, $iva, $idcat);
  954.                 if ($data_service->getPrice() == $calculos['precio']){
  955. //                    $data_service->setPrice($calculos['precio']); //ojo aqui
  956.                 } else {
  957.                     $data_service->setPrice($calculos['precio']);
  958.                     if (($over == 0) and empty($over) and ($commission == 0) and empty($commission)) {
  959.                         // Se bajo el precio porque el iva estaba incluido
  960.                         $data_service->setOpIva(1);
  961.                     }
  963.                     if (!(($over == 0) or empty($over))) { $data_service->setOver(0); }
  964.                     if (!(($commission == 0) or empty($commission))) { $data_service->setCommission(0); }
  965.                 }
  967.                 $service_supplier_data[] = array(
  968.                     'calculos' => $calculos,
  969.                     'services_data' => $data_service,
  970.                     'namesupplier' => $namesupplier
  971.                 );
  973.                 $totales_neto += $calculos['total_neto'];
  974.                 $totales_iva += $calculos['sub_total_iva'];
  975.                 $totales_con_iva += $calculos['total'];
  976.                 $totales_paying += $calculos['total_paying'];
  977.                 $totales_pago += $calculos['total_pago'];
  978.                 $totales_benefit_moneda += $calculos['benefit_moneda'];
  980.                 /* base imponible por servicios */
  981.                 if (empty($base_imponible_service[$idcat])){ $base_imponible_service[$idcat]= 0; }
  982.                 $base_imponible_service[$idcat] += $calculos['total_neto'];
  984.                 $data_serviceCat[$idcat] = array(
  985.                     'idcat' => $idcat,
  986.                     'total_neto' => $base_imponible_service[$idcat],
  987.                 );
  989.                 /* base impobnible detalles por diferentes Ivas */
  990.                 if (empty($base_imponible_iva[$iva])){ $base_imponible_iva[$iva]= 0; }
  991.                 $base_imponible_iva[$iva] += $calculos['total_neto'];
  993.                 if (empty($totales_ivas_all[$iva])){ $totales_ivas_all[$iva]= 0; }
  994.                 $totales_ivas_all[$iva] += $calculos['sub_total_iva'];
  996.                 $totales_neto_all += $calculos['total_neto'];
  997.                 $totales_all += $calculos['total'];
  999.                 $data_iva[$iva] = array(
  1000.                     'iva' => $iva,
  1001.                     'ivas' => $totales_ivas_all[$iva],
  1002.                     'total_iva' => $base_imponible_iva[$iva]
  1003.                 );
  1004.                 if ($totales_benefit_moneda == '0'){
  1005.                     $totales_benefit_porsentaje =  '0';
  1006.                 } else {
  1007.                     if ($totales_neto != 0) {
  1008.                         $totales_benefit_porsentaje = $totales_benefit_moneda / $totales_neto * 100; // arreglado or esteban
  1009.                     } else {
  1010.                         $totales_benefit_porsentaje = 0;
  1011.                     }
  1012.                 }
  1013.             }
  1015.             $calculos_totatales = array(
  1016.                 'totales_neto' => $totales_neto,
  1017.                 'totales_iva' => $totales_iva,
  1018.                 'totales_con_iva' => $totales_con_iva,
  1019.                 'totales_paying' => $totales_paying,
  1020.                 'totales_benefit_moneda' => $totales_benefit_moneda,
  1021.                 'totales_benefit_porsentaje' => $totales_benefit_porsentaje
  1022.             );
  1024.             $data_supplier[$destination->getTitle()][] = array(
  1025.                 'master' => $master,
  1026.                 'colorlabel' => $colorlabel,
  1027.                 'control' => "1",
  1028.                 'supplier' => $sqlsuppliers,
  1029.                 'idea' => $sqlideas,
  1030.                 'activity' => $sqlactivities,
  1031.                 'image' => $imagenSmall,
  1032.                 'services' => $service_supplier_data,
  1033.                 'totales_services' => $calculos_totatales
  1034.             );
  1035.         }
  1036.         $totales_neto_antes = $totales_neto_all;
  1037.         $totales_antes = $totales_all;
  1039.         /*Group Everything*/
  1040.         if($type == 'Group Everything'){
  1041.             $data_supplier = array();
  1042.             $service_supplier_data = array();
  1043.             $messageitems = $this->translator->trans('Grouped Services');
  1045.             $data_service = array(
  1046.                 "price" => $totales_neto_antes,
  1047.                 "name" => $messageitems,
  1048.                 "units" => 1,
  1049.                 "iva" => $iva,
  1050.                 "dateInAt" => "2018-4-4",
  1051.                 "dateOutAt" => "2018-4-4",
  1052.             );
  1054.             $calculos = array(
  1055.                 "precio" => $totales_neto_antes,
  1056.                 "total_days" => 1,
  1057.                 "sub_total" => $totales_neto_antes,
  1058.                 "sub_total_iva" => 0,
  1059.                 "total_neto" => $totales_neto_antes,
  1060.                 "total_iva" => 0,
  1061.                 "total_paying" => 0,
  1062.                 "total_pago" => 0,
  1063.                 "total_comision" => "0",
  1064.                 "total" => $totales_antes,
  1065.                 "benefit_moneda" => 0,
  1066.             );
  1068.             $service_supplier_data[] = array(
  1069.                 'calculos' => $calculos,
  1070.                 'services_data' => $data_service,
  1071.                 'namesupplier' => ""
  1072.             );
  1074.             $calculos_totatales = array(
  1075.                 'totales_neto' => $totales_neto_antes,
  1076.                 'totales_iva' => "",
  1077.                 'totales_con_iva' => $totales_antes,
  1078.                 'totales_paying' => "",
  1079.                 'totales_benefit_moneda' => "",
  1080.                 'totales_benefit_porsentaje' => ""
  1081.             );
  1083.             $data_supplier[$messageitems][] = array(
  1084.                 'master' => '',
  1085.                 'colorlabel' => '',
  1086.                 'control' => "1",
  1087.                 'supplier' => '',
  1088.                 'idea' => '',
  1089.                 'activity' => '',
  1090.                 'image' => '',
  1091.                 'services' => $service_supplier_data,
  1092.                 'totales_services' => $calculos_totatales
  1093.             );
  1094.         }
  1096.         $data_serviceOut = array(
  1097.             'idcat' => null,
  1098.             'total_neto' => $totales_neto_all,
  1099.         );
  1101.         array_push ( $data_serviceCat, $data_serviceOut );
  1102.         $company = $em->getRepository(SettingsCompany::class)->findOneByPriority('1');
  1104.         $parameters = array( 'id' => $proposal->getclientId(), );
  1105.         $dql = 'SELECT cl,  c.country, re.region, p.name, r.city
  1106.                 FROM App:Client cl
  1107.                 INNER JOIN App:Country c WITH c.id = cl.country
  1108.                 INNER JOIN App:Regions re WITH re.id = cl.region
  1109.                 INNER JOIN App:Provinces p WITH p.id = cl.province
  1110.                 INNER JOIN App:Cities r WITH r.id = cl.population
  1111.                 WHERE cl.id = :id';
  1113.         $query = $em->createQuery($dql)->setParameters($parameters);
  1114.         $client = $query->getResult();
  1116.         $data_invoice = array();
  1117.         $inv_neto_total = 0;
  1118.         $inv_total = 0;
  1119.         $invoice_deposit_control = $em->getRepository(ProposalInvoiceDepositControl::class)->findByProposalId($proposal->getId());
  1120.         if (!empty($invoice_deposit_control)){
  1121.             foreach($invoice_deposit_control as $invoicedepositcontrol) {
  1122.                 $data_items_inv = array();
  1123.                 $invoice_deposit_items = $em->getRepository(ProposalInvoiceDepositItems::class)->findByControlId($invoicedepositcontrol->getId());
  1124.                 foreach($invoice_deposit_items as $invoicedeposititems) {
  1125.                     $invamount = $invoicedeposititems->getAmount();
  1126.                     $invamount_iva = $invoicedeposititems->getIva();
  1127.                     $invamount_el_iva = $invamount * ($invamount_iva / 100);
  1128.                     $invamount_con_iva = $invamount * (($invamount_iva / 100) + 1 );
  1130.                     $inv_neto_total += $invamount;
  1131.                     $inv_total += $invamount_con_iva;
  1133.                     if (is_null($invoicedepositcontrol->getNumber())){
  1134.                         $numInvoice = $invoicedepositcontrol->getId();
  1135.                     } else {
  1136.                         $numInvoice = $invoicedepositcontrol->getNumber();
  1137.                     }
  1139.                     $data_items_inv[] = array(
  1140.                         'numInvoice' => $numInvoice,
  1141.                         'name' => $invoicedeposititems->getName(),
  1142.                         'amount' => $invoicedeposititems->getAmount(),
  1143.                         'iva' => $invoicedeposititems->getIva(),
  1144.                         'ivaamount' => $invamount_el_iva,
  1145.                         'total' => $invamount_con_iva,
  1146.                     );
  1148.                     foreach($data_iva as $items_iva) {
  1149.                         if ($items_iva['iva'] == $invoicedeposititems->getIva()){
  1150.                             $new_iva = $items_iva['iva'];
  1151.                             $new_ivas = $items_iva['ivas'] - $invamount_el_iva;
  1152.                             $new_total_iva = $items_iva['total_iva'] - $invoicedeposititems->getAmount();
  1154.                             $new_data_iva = array(
  1155.                                 'iva' => $new_iva,
  1156.                                 'ivas' => $new_ivas,
  1157.                                 'total_iva' => $new_total_iva
  1158.                             );
  1159.                             $data_iva = array_replace($data_iva, array( $new_iva => $new_data_iva ));
  1160.                         }
  1161.                     }
  1162.                 }
  1164.                 $data_invoice[] = array( 'itemsInvoice' => $data_items_inv, );
  1165.             }
  1167.             $totales_neto_all = $totales_neto_all - $inv_neto_total;
  1168.             $totales_all = $totales_all - $inv_total;
  1169.         }
  1171.         $consulta_discount = $em->getRepository(ProposalDiscount::class)->findByProposalId($id);
  1172.         $cuantosdiscount = count($consulta_discount);
  1174. //
  1175. //
  1176. //        if (!empty($consulta_discount)){
  1177. //            $descuento =array();
  1178. //            $name ="";
  1179. //            $amount = "";
  1180. //            $type_des = "";
  1181. //            $iva_discount="";
  1182. //            $totales_generales="";
  1183. //            $totales_neto_des = $totales_neto_all;
  1184. //            $calculo_net_negativo="";
  1185. //            $total_con_iva_desc="";
  1186. //
  1187. //            foreach($consulta_discount as $consultadiscount) {
  1188. //
  1189. //                $iva = $consultadiscount->getIva() / 100;
  1190. //                if ($consultadiscount->getType()=="0"){
  1191. //                    $por = $consultadiscount->getAmount() / 100;
  1192. //                    $totales_neto_des = $totales_neto_des / ($por + 1) ;
  1193. //
  1194. //                    $name = $consultadiscount->getName();
  1195. //                    $type_des = $consultadiscount->getType();
  1196. //                    $amount = $consultadiscount->getAmount();
  1197. //                }
  1198. //
  1199. //
  1200. //                if ($consultadiscount->getType()=="1"){
  1201. //                    $totales_neto_des = $totales_neto_des - $consultadiscount->getAmount();
  1202. //                    $name = $consultadiscount->getName();
  1203. //                    $type_des = $consultadiscount->getType();
  1204. //                    $amount = $consultadiscount->getAmount();
  1205. //                }
  1206. //
  1207. //                // resultados en negativo
  1208. //                $calculo_net_negativo =  $totales_neto_des - $totales_neto_all;
  1209. //
  1210. //                $total_desc = "0";
  1211. //                // resultados para calculos
  1212. //                $calculo_net = $totales_neto_all - $totales_neto_des;
  1213. //                if($consultadiscount->getOpIva() =='0'){
  1214. //                    $iva_discount = $calculo_net - ($calculo_net / ($iva + 1));
  1215. //                    $calculo_net_negativo = $calculo_net_negativo + $iva_discount;
  1216. //                    $totales_neto_des = $totales_neto_des + $iva_discount;
  1217. //                    $total_desc = $iva_discount;
  1218. //                }
  1219. //                if($consultadiscount->getOpIva() =='1'){
  1220. //                    $iva_discount = $calculo_net * $iva;
  1221. //                    $total_desc = $iva_discount;
  1222. //                }
  1223. //
  1224. //                if($type == 'No Vat Invoice'){
  1225. //                    $iva_discount = "0";
  1226. //                }
  1227. //                // resultados en negativo
  1228. ////                $calculo_net_negativo =  $totales_neto_des - $totales_neto_all;
  1229. //
  1230. //                $total_con_iva_desc = $calculo_net_negativo - $iva_discount;
  1231. //
  1232. //
  1233. //                $operacion = $totales_all - $totales_neto_all;
  1234. //                $totales_generales = $totales_neto_des + $operacion - $total_desc;
  1235. //
  1236. //
  1237. //
  1238. //                $descuento[] = array(
  1239. //                    'name' => $name,
  1240. //                    'type' => $type_des,
  1241. //                    'amount' => $amount,
  1242. //                    'iva' => $consultadiscount->getIva(),
  1243. //                    'totales_neto_des' => $calculo_net_negativo,
  1244. //                    'total' => $total_con_iva_desc,
  1245. //                );
  1246. //
  1247. //                $totales_neto_all = $totales_neto_des;
  1248. //                $totales_all = $totales_generales;
  1249. //
  1250. //            }
  1251. //        }
  1253.         $totales_generales="";
  1254.         $descuento =array();
  1255.         if (!empty($consulta_discount)){
  1256.             $quitar_en_todos = 0;
  1257.             $datos_total_neto_suma = 0;
  1258.             foreach($data_serviceCat as $dataserviceat) {
  1259.                 $name ="";
  1260.                 $amount = "";
  1261.                 $type_des = "";
  1262.                 $iva_discount="";
  1263.                 $datos_idcat = $dataserviceat['idcat'];
  1264.                 $datos_total_neto = $dataserviceat['total_neto'];
  1266.                 $totales_neto_des = $datos_total_neto;
  1267.                 $datosiva_neto_des = $datos_total_neto;
  1268.                 $calculo_net_negativo="";
  1269.                 $total_con_iva_desc="";
  1270.                 $contarveces = 1;
  1271.                 foreach($consulta_discount as $consultadiscount) {
  1272.                     if($dataserviceat['idcat'] == null){
  1273.                         if($contarveces > 1 ){
  1274.                             $totales_neto_des = $datos_total_neto_suma;
  1275.                             $datosiva_neto_des = $datos_total_neto_suma;
  1276.                             $datos_total_neto = $datos_total_neto_suma;
  1277.                         } else {
  1278.                             if($cuantosdiscount > 1){
  1279.                                 $totales_neto_des = $dataserviceat['total_neto'] - $quitar_en_todos;
  1280.                                 $datosiva_neto_des = $dataserviceat['total_neto'] - $quitar_en_todos;
  1281.                                 $datos_total_neto = $dataserviceat['total_neto'] - $quitar_en_todos;
  1282.                             }
  1283.                         }
  1284.                         $contarveces += 1;
  1285.                     }
  1287.                     if ($dataserviceat['idcat'] == $consultadiscount->getServiceId()){
  1289.                         $iva = $consultadiscount->getIva() / 100;
  1290.                         if ($consultadiscount->getType()=="0"){
  1291.                             $por = $consultadiscount->getAmount() / 100;
  1293. //                            $datosiva_neto_des = $datosiva_neto_des / ($por + 1) ;
  1294.                             $datosiva_neto_des = $datosiva_neto_des - ($datosiva_neto_des * $por) ;
  1296.                             $name = $consultadiscount->getName();
  1297.                             $type_des = $consultadiscount->getType();
  1298.                             $amount = $consultadiscount->getAmount();
  1299.                         }
  1301.                         if ($consultadiscount->getType()=="1"){
  1302.                             $datosiva_neto_des = $datosiva_neto_des - $consultadiscount->getAmount();
  1304.                             $name = $consultadiscount->getName();
  1305.                             $type_des = $consultadiscount->getType();
  1306.                             $amount = $consultadiscount->getAmount();
  1307.                         }
  1309.                         // resultados en negativo
  1310.                         $calculo_net_negativo =  $datosiva_neto_des - $datos_total_neto;
  1312.                         $total_desc = "0";
  1313.                         // resultados para calculos
  1314.                         $calculo_net = $datos_total_neto - $datosiva_neto_des;
  1315.                         if($consultadiscount->getOpIva() =='0'){
  1316.                             $iva_discount = $calculo_net - ($calculo_net / ($iva + 1));
  1317.                             $calculo_net_negativo = $calculo_net_negativo + $iva_discount;
  1318.                             $totales_neto_des = $totales_neto_des + $iva_discount;
  1319.                             $total_desc = $iva_discount;
  1320.                         }
  1321.                         if($consultadiscount->getOpIva() =='1'){
  1322.                             $iva_discount = $calculo_net * $iva;
  1323.                             $total_desc = $iva_discount;
  1324.                         }
  1326.                         if($type == 'No Vat Invoice'){
  1327.                             $iva_discount = "0";
  1328.                         }
  1330. //                        if($dataserviceat['idcat'] == null){
  1331.                         $datos_total_neto_suma = $datos_total_neto- abs($calculo_net_negativo);
  1332. //                        }
  1334.                         $quitar_en_todos = $quitar_en_todos + abs($calculo_net_negativo);
  1335. //                        $datosiva_neto_des = $datosiva_neto_des + $calculo_net_negativo;
  1337.                         $total_con_iva_desc = $calculo_net_negativo - $iva_discount;
  1339.                         $totales_neto_all = $totales_neto_all - abs($calculo_net_negativo);
  1340.                         $totales_all = $totales_all - abs($total_con_iva_desc);
  1342.                         $descuento[] = array(
  1343.                             'name' => $name,
  1344.                             'type' => $type_des,
  1345.                             'amount' => $amount,
  1346.                             'iva' => $consultadiscount->getIva(),
  1347.                             'iva_amount' => $iva_discount,
  1348.                             'totales_neto_des' => $calculo_net_negativo,
  1349.                             'total' => $total_con_iva_desc,
  1350.                         );
  1352.                         // Nueva actualizacion 17-07-2019 Recalcular Ivas
  1353.                         foreach($data_iva as $items_iva) {
  1354.                             if ($items_iva['iva'] == $consultadiscount->getIva()){
  1355.                                 $new_iva = $items_iva['iva'];
  1356.                                 $new_ivas = $items_iva['ivas'] - $iva_discount;
  1357.                                 $new_total_iva = $items_iva['total_iva'] - $iva_discount;
  1359.                                 $new_data_iva = array(
  1360.                                     'iva' => $new_iva,
  1361.                                     'ivas' => $new_ivas,
  1362.                                     'total_iva' => $new_total_iva
  1363.                                 );
  1364.                                 $data_iva = array_replace($data_iva, array( $new_iva => $new_data_iva ));
  1365.                             }
  1366.                         }
  1367.                     }
  1368.                 }
  1369.             }
  1370.         }
  1372.         $payments = $em->getRepository(ProposalPaymentsClient::class)->findByProposalId($id);
  1373.         $amount_pay = 0;
  1374.         foreach($payments as $payment) { $amount_pay = $amount_pay + $payment->getAmount(); }
  1376.         $totales_all = round($totales_all,2);
  1377.         $totales_total = $totales_all;
  1378.         if (!empty($payments)){ $totales_all = $totales_all - $amount_pay; }
  1381.         //Si hay uno o varios depositos previos el IVA debe ser calculado en funcion de totales_neto = totales_neto_antes - amount
  1382. //        $adelanto = 0;
  1383. //        if(sizeof($data_invoice)!=0){
  1384. //            foreach ($data_invoice as $pago_previo){
  1385. //                foreach ($pago_previo as $adel){
  1386. //                    foreach ($adel as $ade){
  1387. //                        $adelanto = $adelanto + $ade['amount'];
  1388. //                    }
  1389. //                }
  1390. //            }
  1391. //        }
  1392. //
  1393. //        if ($adelanto != 0){
  1394. //            $new_data_iva = null;
  1395. //            $new_iva = number_format($totales_neto_antes, 2, '.','') - number_format($adelanto, 2, '.','');
  1396. //            $new_iva = $new_iva * $data_iva['21']['iva'];
  1397. //            $new_iva =$new_iva/100;
  1398. //            $new_iva = number_format($new_iva, 2, '.','');
  1399. //            foreach ($data_iva as $dativ){
  1400. //                $dativ['ivas'] = $new_iva;
  1401. //                $new_data_iva['21'] = $dativ;
  1402. //            }
  1403. //
  1404. //            $data_iva = $new_data_iva;
  1405. //
  1406. //        }
  1408.         $data = array(
  1409.             'id' => $id,
  1410.             'type' => $type,
  1411.             'number' => $number,
  1412.             'prefix' => $prefix,
  1413.             'date' => $date,
  1414.             'token' => $proposal->getAccessKey(),
  1415.             'proposal' => $proposal,
  1416.             'company' => $company,
  1417.             'clients' => $client,
  1418.             'datasupplier' => $data_supplier,
  1419.             'totales_neto_antes' => $totales_neto_antes,
  1420.             'totales_neto' => $totales_neto_all,
  1421.             'totales_generales' => $totales_generales,
  1422.             'bases_imponibles' => $data_iva,
  1423.             'totales_antes' => $totales_antes,
  1424.             'totales' => $totales_total,
  1425.             'balance' => $totales_all,
  1426.             'currency' => $currency,
  1427.             'paymentInvoice' => $amount_pay,
  1428.             'discounts' => $descuento,
  1429.             'invoiceDesposit' => $data_invoice,
  1430.         );
  1432. // ************************************************  FEE    ************************************************************
  1433.         $fees = $em->getRepository(ProposalFee::class)->findByProposalId($id);
  1434.         $feesInvoice = $em->getRepository(ProposalFeeInvoice::class)->findByProposalId($id);
  1436.         if (!empty($feesInvoice)) {
  1437.             // Fee en factura
  1438.             // 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
  1439.             if ($feesInvoice[0]->getToinvoice() == true) {
  1440.                 foreach ($feesInvoice as $feeInv) {
  1441.                     if ($feeInv->getType() == 0) {
  1442.                         // Tenemos un porcentaje en el Fee de la factura, debe calcularse
  1443.                         $feeNet = ($data['totales_neto_antes'] * $feeInv->getAmount()) / 100;
  1444.                     } else {
  1445.                         $feeNet = $feeInv->getAmount();
  1446.                     }
  1448.                     $feeTotal = $feeNet * 1.21;                     //El fee siempre será al 21%, Esteban Rincón
  1450.                     if ($feeInv->getToInvoice() == true) {
  1451.                         $data['totales_neto'] += $feeNet;
  1452.                         $data['totales'] += $feeTotal;
  1453.                         $data['balance'] += $feeTotal;
  1454.                         if (array_key_exists('21', $data['bases_imponibles'])) {
  1455.                             $data['bases_imponibles']['21']['ivas'] += $feeNet * 0.21;
  1456.                             $data['bases_imponibles']['21']['total_iva'] += $feeNet;
  1457.                         } else {
  1458.                             $data['bases_imponibles']['21']['iva'] = '21';
  1459.                             $data['bases_imponibles']['21']['ivas'] = $feeNet * 0.21;
  1460.                             $data['bases_imponibles']['21']['total_iva'] = $feeNet;
  1461.                         }
  1462.                     }
  1464.                     if ($feeInv->getFeeNet() == 0 or empty($feeInv->getFeeNet())) {
  1465.                         // La asignación solo se hace la primera vez
  1466.                         $feeInv->setFeeNet($feeNet);
  1467.                         $feeInv->setFeeTotal($feeTotal);
  1469.                         $em->persist($feeInv);
  1470.                         $em->flush();
  1471.                     }
  1472.                 }
  1473.             }
  1474.         } else {
  1475.             // Fee en proforma
  1476.             if (!empty($fees)) {
  1477.                 // 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
  1478.                 if ($fees[0]->getToinvoice() == true) {
  1479.                     foreach ($fees as $fee) {
  1480.                         if ($fee->getType() == 0) {
  1481.                             // Tenemos un porcentaje, debe calcularse
  1482.                             $amount = ($data['totales_neto_antes'] * $fee->getAmount()) / 100;
  1483.                             $fee->setAmount($amount);
  1484.                         }
  1485.                         $fee->setFeeTotal($fee->getAmount() * 1.21);        //El fee siempre será al 21%, Esteban Rincón
  1486.                         if ($fee->getToInvoice() == true) {
  1487.                             $data['totales_neto'] += $fee->getAmount();
  1488.                             $data['totales'] += $fee->getFeeTotal();
  1489.                             $data['balance'] += $fee->getFeeTotal();
  1490.                             if (array_key_exists('21', $data['bases_imponibles'])) {
  1491.                                 $data['bases_imponibles']['21']['ivas'] += $fee->getAmount() * 0.21;
  1492.                                 $data['bases_imponibles']['21']['total_iva'] += $fee->getAmount();
  1493.                             } else {
  1494.                                 $data['bases_imponibles']['21']['iva'] = '21';
  1495.                                 $data['bases_imponibles']['21']['ivas'] = $fee->getAmount() * 0.21;
  1496.                                 $data['bases_imponibles']['21']['total_iva'] = $fee->getAmount();
  1497.                             }
  1498.                         }
  1499.                     }
  1500.                 }
  1501.             }
  1502.         }
  1503. // ************************************************  FEE    ************************************************************
  1505.         return $data;
  1506.     }
  1509.     public function CalculoTotalesservices($price, $units, $pax, $days, $opcommission, $commission, $opover, $over, $opiva, $iva, $idcat)
  1510.     {
  1511.         $price = trim($price);
  1512.         $over = trim($over);
  1513.         $price = str_replace(",", ".", $price);
  1514.         $over = str_replace(",", ".", $over);
  1516.         if (empty($iva)){$iva=0;}
  1517.         $iva = $iva / 100;
  1518.         if($opiva =='0'){
  1519.             $price = $price / ($iva + 1);
  1520.         }
  1522.         if(!empty($commission)){
  1523.             if($opcommission=='0'){
  1524.                 $commission = (100 - $commission) / 100;
  1525.                 $precio_units = $price;
  1526.                 $price = $price * $commission;
  1527.             }
  1529.             if($opcommission=='1'){
  1530.                 $commission = ($commission / 100) + 1;
  1531.                 $precio_units = $price * $commission;
  1532.             }
  1533.         }else{
  1534.             $precio_units = $price;
  1535.         }
  1537.         //Units
  1538.         if(empty($units) or $units =="0"){
  1539.             $units = "1";
  1540.         }
  1542.         // Calculo Especial por categoria
  1543.         //Alojamientos
  1544.         if($idcat =="1"){
  1545.             $informativo_days = "si";
  1546.             $pax = "1";
  1547.         }
  1548.         //Transporte
  1549.         elseif($idcat =="13"){
  1550.             $informativo_days = "no";
  1551.             $pax = "1";
  1552.             //            if($days > "1"){
  1553.             //                $days = "2";
  1554.             //            }else{
  1555.             //                $days = "1";
  1556.             //            }
  1557.         }
  1558.         //Lounge
  1559.         elseif($idcat =="10"){
  1560.             $informativo_days = "no";
  1561.             $pax = "1";
  1562.         }
  1563.         //Guia
  1564.         elseif($idcat =="8"){
  1565.             $informativo_days = "no";
  1566.             $pax = "1";
  1567.         }
  1568.         //Asistencia
  1569.         elseif($idcat =="15"){
  1570.             $informativo_days = "no";
  1571.             $days = '0';
  1572.         }else{
  1573.             $informativo_days = "no";
  1574.         }
  1576.         //Pax
  1577.         if(empty($pax) or $pax =="0"){
  1578.             $pax = "1";
  1579.         }
  1581.         //Over
  1582.         if(empty($over)){
  1583.             $over = "0";
  1584.         }
  1586.         if($informativo_days =="no"){
  1587.             //Days
  1588.             if(empty($days) or $days =="0"){
  1589.                 $days = "1";
  1590.             }else{
  1591.                 $days = $days + 1 ;
  1592.             }
  1593.         }
  1595.         $total_items = $price * $units * $pax * $days;
  1596. //        $total_pdirect = $price * $units * $pax * $days;
  1598.         $total_over = $over * $units * $pax * $days;
  1600. //        if($opover=='0'){
  1601. //            $total_neto = $total_items / $commission - $total_over ;
  1602. //            $precio_units = $precio_units - $over;
  1603. //        }
  1604. //        if($opover=='1'){
  1605. //            $total_neto = $total_items / $commission + $total_over;
  1606. //            $precio_units = $precio_units + $over;
  1607. //        }
  1609.         if(!empty($commission)){
  1610.             if($opcommission=='0'){
  1611.                 $total_neto = $total_items / $commission;
  1612.             }
  1613.             if($opcommission=='1'){
  1614.                 $total_neto = $total_items * $commission;
  1615.             }
  1616.         }else{
  1617.             $total_neto = $total_items;
  1618.         }
  1620.         if($opover=='0'){
  1621.             $total_neto = $total_neto - $total_over ;
  1622.             $precio_units = $precio_units - $over;
  1623.         }
  1624.         if($opover=='1'){
  1625.             $total_neto = $total_neto +  $total_over;
  1626.             $precio_units = $precio_units + $over;
  1627.         }
  1629.         $total_paying = $total_items * ($iva + 1);
  1631.         $total_comision ="0";
  1632.         $total_pago = $total_items;
  1633.         $total_iva = $total_items * $iva;
  1634.         $sub_total_iva = $total_neto * $iva;
  1636.         $total = $total_neto + $sub_total_iva;
  1638.         $benefit_moneda = $total_neto - $total_items;
  1640.         $data_calculos = array(
  1641.             'precio' => $precio_units,
  1642.             'total_days' => $days,
  1643.             'sub_total' => $total_items,
  1644.             'sub_total_iva' => $sub_total_iva,
  1645.             'total_neto' => $total_neto,
  1646.             'total_iva' => $total_iva,
  1647.             'total_paying' => $total_paying,
  1648.             'total_pago' => $total_pago,
  1649.             'total_comision' => $total_comision,
  1650.             'total' => $total,
  1651.             'benefit_moneda' => $benefit_moneda
  1652.         );
  1653.         return $data_calculos;
  1654.     }
  1657.     /**
  1658.      * @Route("/proposal/invoice/number/{id}", name="proposal_invoice_number")
  1659.      */
  1660.     public function InvoiceEmptyNumberAction($id, Request $request) {
  1661.         $em = $this->getDoctrine()->getManager();
  1662.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  1663.         $invoice = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  1664.         $client = $em->getRepository(Client::class)->findOneById($proposal->getClientId());
  1665.         $country = $em->getRepository(Country::class)->findOneById($client->getCountry());
  1666.         $client->setCountry($country->getCountry());
  1667.         $regions = $em->getRepository(Regions::class)->findOneById($client->getRegion());
  1668.         $client->setRegion($regions->getRegion());
  1669.         $province = $em->getRepository(Provinces::class)->findOneById($client->getProvince());
  1670.         $client->setProvince($province->getName());
  1671.         $cities = $em->getRepository(Cities::class)->findOneById($client->getPopulation());
  1672.         $client->setPopulation($cities->getCity());
  1674.         return $this->render('MDS/EventsBundle/invoice/add-number-invoice.html.twig', array(
  1675.             'id' => $id,
  1676.             'invoice' => $invoice,
  1677.             'mcp' => $proposal->getMcp(),
  1678.             'token' => $proposal->getAccessKey(),
  1679.             'proposal' => $proposal,
  1680.             'client' => $client,
  1681.         ));
  1682.     }
  1685.     /**
  1686.      * @Route("/proposal/invoice/number/updated/{id}", name="proposal_invoice_number_update")
  1687.      */
  1688.     public function InvoiceEmptyNumberupdateAction($id, Request $request)
  1689.     {
  1690.         $em = $this->getDoctrine()->getManager();
  1691.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  1692.         $invoice = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  1694.         $numberinvoice = $request->request->get('invoice')['number'];
  1695.         $dateAt = new \DateTime($request->request->get('invoice')['dateAt']);
  1697.         if(!empty($numberinvoice))
  1698.         {
  1699.             $invoice->setNumber($numberinvoice);
  1700.             $invoice->setDateAt($dateAt);
  1702.             // Envio correo al agente para informar que fue colocado el numero de factura
  1704.             $time = new \DateTime("now");
  1705.             $agent = $em->getRepository(User::class)->findOneById($proposal->getAgentId());
  1706.             $mailAgent[] = $agent->getEmail();
  1707.             $agentMail = $agent->getEmail();
  1708.             $passGmail = $agent->getPassGmail();
  1709.             $firmGmail = $agent->getFirmGmail();
  1710.             $mailAgentSent = array(
  1711.                 $agent->getEmail() => $agent->getName().' '. $agent->getLastName()
  1712.             );
  1714.             $body = 'P#'.$proposal->getId().', '.$proposal->getTitle().'<br>
  1715.                         <a href="http://'.$request->server->get('HTTP_HOST').'/events/events/proposal/edit/'.$proposal->getId().'">Ir al Proposal</a> - 
  1716.                         <a href="http://'.$request->server->get('HTTP_HOST').'/events/proposal/invoice/'.$proposal->getId().'">Ver Factura</a><br>
  1717.                         <br>Alerta de Fatura activada: '.$time->format('d/m/Y H:i:s').'<br><br>';
  1719.             $data = array(
  1720.                 'body' => $body,
  1721.                 'firm' => $firmGmail,
  1722.             );
  1724.             $mailTodos = array_merge($mailAgent);
  1726.             // EJECUTAR ENVIO DE ALERTA DE VISTO POR CLIENTE
  1727.             $transporter = new Swift_SmtpTransport();
  1728.             $transporter->setHost('smtp.gmail.com')
  1729.                 ->setEncryption('ssl') //ssl / tls
  1730.                 ->setPort(465) // 465 / 587
  1731.                 ->setUsername('desarrollo@develup.solutions')
  1732.                 ->setPassword('utvh hzoi wfdo ztjs');
  1733.             $mailer = new Swift_Mailer($transporter);
  1735.             $message = new Swift_Message();
  1736.             $message->setSubject('P#'.$proposal->getId().', Alerta de Fatura activada.')
  1737.                 ->setSender($agentMail)
  1738.                 ->setFrom($mailAgentSent)
  1739.                 ->setReplyTo($mailAgentSent)
  1740.                 ->setTo($mailTodos)
  1741.                 ->setBody(
  1742.                     $this->renderView(
  1743.                         'mail/structure-mail.html.twig',
  1744.                         array('data' => $data)
  1745.                     ),
  1746.                     'text/html'
  1747.                 )
  1748.             ;
  1749.             $mailer->send($message);
  1751.             /* Obtengo usuario logueado */
  1752.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1753.             $user_id = $user_logueado->getId();
  1755.             $proposal->setUpdatedId($user_id);
  1757.             $em->persist($invoice);
  1758.             $em->persist($proposal);
  1759.             $em->flush();
  1760.             $event = 'The Invoice has been Updated. Now';
  1762.             $successMessage = $this->translator->trans($event);
  1763.             $this->addFlash('mensajeproposaldestination', $successMessage);
  1765.         } else {
  1766.             $errorMessage = $this->translator->trans('Error, some fields are empty');
  1767.             $this->addFlash('mensajeproposaldestinationerror', $errorMessage);
  1768.         }
  1770.         return $this->redirectToRoute('proposal_invoice_number', array( 'id' => $id ));
  1771.     }
  1774.     /**
  1775.      * @Route("/proposal/invoice/number/liberate/{id}", name="proposal_invoice_number_liberate")
  1776.      */
  1777.     public function InvoiceEmptyNumberliberateAction($id, Request $request)
  1778.     {
  1779.         $em = $this->getDoctrine()->getManager();
  1780.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  1781.         $proposal->setStatus('Confirmed');
  1782.         $em->persist($proposal);
  1784.         $invoice = $em->getRepository(ProposalInvoice::class)->findOneByProposalId($id);
  1785.         $em->remove($invoice);
  1786.         $em->flush();
  1787.         $event = 'The Invoice has been Liberate. Now';
  1789.         $successMessage = $this->translator->trans($event);
  1790.         $this->addFlash('mensajeproposaldestination', $successMessage);
  1792.         $feesInvoice = $em->getRepository(ProposalFeeInvoice::class)->findOneByProposalId($id);
  1793.         if (!empty($feesInvoice)){
  1794.             $em->remove($feesInvoice);
  1795.             $em->flush();
  1796.         }
  1798.         // Si existe el ProposalsStatistics se debe eliminar de la tabla también
  1799.         $propStats = $em->getRepository(ProposalsStatistics::class)->findOneBy([
  1800.             'proposalId' => $id,
  1801.             'proposalStatus' => 'Invoiced',
  1802.         ]);
  1804.         if (!empty($propStats)){
  1805.             $em->remove($propStats);
  1806.             $em->flush();
  1807.         }
  1809.         return $this->redirectToRoute('proposal_invoice_number', array( 'id' => $id ));
  1810.     }
  1813.     // Funcion para insertar historico de seguimiento
  1814.     // $textHistory = $this->translator->trans('');
  1815.     // $history = $this->TracingHistoryOperations($proposal->getId(), $text);
  1816.     private function TracingHistoryOperations($id, $text)
  1817.     {
  1818.         $em = $this->getDoctrine()->getManager();
  1819.         /* Obtengo usuario logueado */
  1820.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1821.         $user_id = $user_logueado->getId();
  1823.         $history = new ProposalTracing();
  1824.         $history->setDateAt(new \DateTime('now'));
  1825.         $history->setText($text);
  1826.         $history->setAgentId($user_id);
  1827.         $history->setProposalId($id);
  1828.         $history->setViewed('no');
  1829.         $history->setCreatedId($user_id);
  1830.         $history->setUpdatedId($user_id);
  1831.         $em->persist($history);
  1832.         $em->flush();
  1834.         $success = 'success';
  1835.         return $success;
  1836.     }
  1837. }