src/Controller/SendMailController.php line 176

Open in your IDE?
  1. <?php
  2. /**
  3.  * Created by Mediterranean Develup Solutions
  4.  * User: jorge.defreitas@develup.solutions
  5.  * Date: 17/01/2018
  6.  * Time: 18:52
  7.  */
  9. namespace App\Controller;
  11. use App\Entity\Client;
  12. use App\Entity\ClientContact;
  13. use App\Entity\ClientGroupContact;
  14. use App\Entity\SendMail;
  15. use App\Entity\Supplier;
  16. use App\Entity\User;
  17. use App\Form\SendMailType;
  18. use App\MDS\EventsBundle\Entity\Proposal;
  19. use App\MDS\EventsBundle\Entity\ProposalAgents;
  20. use App\MDS\EventsBundle\Entity\ProposalTracing;
  21. use Swift_Mailer;
  22. use Swift_Message;
  23. use Swift_SmtpTransport;
  24. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  25. use Symfony\Component\Routing\Annotation\Route;
  26. use Symfony\Component\HttpFoundation\Request;
  27. use Symfony\Contracts\Translation\TranslatorInterface;
  29. class SendMailController extends AbstractController
  30. {
  31.     private $translator;
  33.     public function __construct(TranslatorInterface $translator) {
  34.         $this->translator = $translator;
  35.     }
  36.     
  37.     /*
  38.     * ATENCION LAS RAIZ DE @Route POR DEFECTO DEL BUNDLE: EventsBundle ES  /events/, NO PONERLO EN LA @Route("")
  39.     *
  40.     * */
  42.     /**
  43.      * @Route("/mail/invoice/{id}",  name="proposal_mail_Invoice_form")
  44.      */
  45.     public function Invoiceaction($id, Request $request)
  46.     {
  47.         $mail = new SendMail();
  48.         $mail->setProposalId($id);
  49.         $mail->setType('Invoice');
  50.         $form = $this->createProposalMailCreateForm($mail);
  52.         $em = $this->getDoctrine()->getManager();
  53.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  54.         $clientcontact = $em->getRepository(ClientContact::class)->findOneById($proposal->getContactId());
  55.             $data_contact[] = array(
  56.                 'name' => $clientcontact->getName(),
  57.                 'lastname' => $clientcontact->getLastName(),
  58.                 'email' => $clientcontact->getEmail()
  59.             );
  61.         $client = $em->getRepository(Client::class)->findOneById($proposal->getClientId());
  62.         $grupo_contact = $em->getRepository(ClientGroupContact::class)->findByGroupId($client->getGroupId());
  63.         $data_groupContact = array();
  64.         foreach($grupo_contact as $grupocontact){
  65.             $data_groupContact[] = array(
  66.                 'name' => $grupocontact->getName(),
  67.                 'lastname' => $grupocontact->getLastName(),
  68.                 'email' => $grupocontact->getEmail()
  69.             );
  70.         }
  72.         $data_agents = $this->findMailsAgentsProposal($id);
  73.         $data_correos = array_merge($data_contact, $data_groupContact, $data_agents);
  75.         return $this->render('MDS/EventsBundle/proposal/send-mail.html.twig',
  76.             array(
  77.                 'id' => $id,
  78.                 'token' => $proposal->getAccessKey(),
  79.                 'subjectAndMessage' => $proposal->getId().' - '.$proposal->getTitle(),
  80.                 'correos' => $data_correos,
  81.                 'mcp' => $proposal->getMcp(),
  82.                 'form' => $form->createView()
  83.             )
  84.         );
  85.     }
  86.     /**
  87.      * @Route("/mail/proforma/{id}",  name="proposal_mail_proforma_form")
  88.      */
  89.     public function Proformaction($id, Request $request)
  90.     {
  91.         $mail = new SendMail();
  92.         $mail->setProposalId($id);
  93.         $mail->setType('Proforma');
  94.         $form = $this->createProposalMailCreateForm($mail);
  96.         $em = $this->getDoctrine()->getManager();
  97.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  98.         $clientcontact = $em->getRepository(ClientContact::class)->findOneById($proposal->getContactId());
  99.             $data_contact[] = array(
  100.                 'name' => $clientcontact->getName(),
  101.                 'lastname' => $clientcontact->getLastName(),
  102.                 'email' => $clientcontact->getEmail()
  103.             );
  105.         $client = $em->getRepository(Client::class)->findOneById($proposal->getClientId());
  106.         $grupo_contact = $em->getRepository(ClientGroupContact::class)->findByGroupId($client->getGroupId());
  107.         $data_groupContact = array();
  108.         foreach($grupo_contact as $grupocontact){
  109.             $data_groupContact[] = array(
  110.                 'name' => $grupocontact->getName(),
  111.                 'lastname' => $grupocontact->getLastName(),
  112.                 'email' => $grupocontact->getEmail()
  113.             );
  114.         }
  115.         $data_agents = $this->findMailsAgentsProposal($id);
  116.         $data_correos = array_merge($data_contact, $data_groupContact, $data_agents);
  118.         return $this->render('MDS/EventsBundle/proposal/send-mail.html.twig',
  119.             array(
  120.                 'id' => $id,
  121.                 'token' => $proposal->getAccessKey(),
  122.                 'correos' => $data_correos,
  123.                 'mcp' => $proposal->getMcp(),
  124.                 'subjectAndMessage' => $proposal->getId().' - '.$proposal->getTitle(),
  125.                 'form' => $form->createView()
  126.             )
  127.         );
  128.     }
  129.     /**
  130.      * @Route("/mail/presentation/{id}",  name="proposal_mail_presentation_form")
  131.      */
  132.     public function Presentationaction($id, Request $request)
  133.     {
  134.         $mail = new SendMail();
  135.         $mail->setProposalId($id);
  136.         $mail->setType('Presentation');
  137.         $form = $this->createProposalMailCreateForm($mail);
  139.         $em = $this->getDoctrine()->getManager();
  140.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  141.         $clientcontact = $em->getRepository(ClientContact::class)->findOneById($proposal->getContactId());
  142.             $data_contact[] = array(
  143.                 'name' => $clientcontact->getName(),
  144.                 'lastname' => $clientcontact->getLastName(),
  145.                 'email' => $clientcontact->getEmail()
  146.             );
  148.         $client = $em->getRepository(Client::class)->findOneById($proposal->getClientId());
  149.         $grupo_contact = $em->getRepository(ClientGroupContact::class)->findByGroupId($client->getGroupId());
  150.         $data_groupContact = array();
  151.         foreach($grupo_contact as $grupocontact){
  152.             $data_groupContact[] = array(
  153.                 'name' => $grupocontact->getName(),
  154.                 'lastname' => $grupocontact->getLastName(),
  155.                 'email' => $grupocontact->getEmail()
  156.             );
  157.         }
  158.         $data_agents = $this->findMailsAgentsProposal($id);
  159.         $data_correos = array_merge($data_contact, $data_groupContact, $data_agents);
  161.         return $this->render('MDS/EventsBundle/proposal/send-mail.html.twig',
  162.             array(
  163.                 'id' => $id,
  164.                 'token' => $proposal->getAccessKey(),
  165.                 'correos' => $data_correos,
  166.                 'subjectAndMessage' => $proposal->getId().' - '.$proposal->getTitle(),
  167.                 'mcp' => $proposal->getMcp(),
  168.                 'form' => $form->createView()
  169.             )
  170.         );
  171.     }
  173.     /**
  174.      * @Route("/mail/normal/{id}",  name="proposal_mail_form")
  175.      */
  176.     public function NormalAction($id, Request $request)
  177.     {
  178.         $mail = new SendMail();
  179.         $mail->setProposalId($id);
  180.         $mail->setType('Normal');
  181.         $form = $this->createProposalMailCreateForm($mail);
  183.         $em = $this->getDoctrine()->getManager();
  184.         $proposal = $em->getRepository(Proposal::class)->findOneById($id);
  185.         $clientcontact = $em->getRepository(ClientContact::class)->findOneById($proposal->getContactId());
  186.             $data_contact[] = array(
  187.                 'name' => $clientcontact->getName(),
  188.                 'lastname' => $clientcontact->getLastName(),
  189.                 'email' => $clientcontact->getEmail()
  190.             );
  192.         $client = $em->getRepository(Client::class)->findOneById($proposal->getClientId());
  193.         $grupo_contact = $em->getRepository(ClientGroupContact::class)->findByGroupId($client->getGroupId());
  194.         $data_groupContact = array();
  195.         foreach($grupo_contact as $grupocontact){
  196.             $data_groupContact[] = array(
  197.                 'name' => $grupocontact->getName(),
  198.                 'lastname' => $grupocontact->getLastName(),
  199.                 'email' => $grupocontact->getEmail()
  200.             );
  201.         }
  202.         $data_agents = $this->findMailsAgentsProposal($id);
  203.         $data_correos = array_merge($data_contact, $data_groupContact, $data_agents);
  205.         return $this->render('MDS/EventsBundle/proposal/send-mail.html.twig',
  206.             array(
  207.                 'id' => $id,
  208.                 'token' => $proposal->getAccessKey(),
  209.                 'subjectAndMessage' => $proposal->getId().' - '.$proposal->getTitle(),
  210.                 'correos' => $data_correos,
  211.                 'mcp' => $proposal->getMcp(),
  212.                 'form' => $form->createView()
  213.             )
  214.         );
  215.     }
  217.     private function createProposalMailCreateForm(SendMail $entity)
  218.     {
  219.         $form = $this->createForm(SendMailType::class, $entity, array(
  220.             'action' => $this->generateUrl('proposal_mail_create'),
  221.             'method' => 'PUT'));
  223.         return $form;
  224.     }
  227.     /**
  228.      * @Route("/mail/create", name="proposal_mail_create")
  229.      */
  230.     public function createProposalMailAction(Request $request, \Swift_Mailer $mailer)
  231.     {
  232.         $proposalsendmail = $request->request->get('sendmail');
  233.         $proposalsendmail_mail = $request->request->get('sendmail_mail')['mail'];
  234.         $proposalsendmail_admail = $request->request->get('sendmail_admail')['mail'];
  235.         $arraysendmail_admail = explode(",", $proposalsendmail_admail);
  236.         foreach ($arraysendmail_admail as $key => $value) {
  237.             if (empty($value)) {
  238.                 unset($arraysendmail_admail[$key]);
  239.             }
  240.         }
  242.         if(empty($proposalsendmail['body'])){ $proposalsendmail['body'] = $proposalsendmail['subject']; }
  244.         $mail = new SendMail();
  245.         $form = $this->createProposalMailCreateForm($mail);
  246.         $form->handleRequest($request);
  247.         $em = $this->getDoctrine()->getManager();
  250.         if($form->isValid())
  251.         {
  253.             $proposal = $em->getRepository(Proposal::class)->findOneById($proposalsendmail['proposalId']);
  254.             $proposal->setSent('Yes');
  255.             $em->persist($proposal);
  257.             $agent = $em->getRepository(User::class)->findOneById($proposal->getAgentId());
  258.             $mailAgent[] = $agent->getEmail();
  259.             $agentMail = $agent->getEmail();
  260.             $passGmail = $agent->getPassGmail();
  261.             $firmGmail = $agent->getFirmGmail();
  262.             $mailAgentSent = array(
  263.                 $agent->getEmail() => $agent->getName().' '. $agent->getLastName()
  264.             );
  266.             $data = array();
  267.             if ($proposalsendmail['type'] == "Normal" ){
  268.                 $data = array(
  269.                     'body' => $proposalsendmail['body'],
  270.                     'firm' => $firmGmail,
  271.                 );
  272.             }elseif ($proposalsendmail['type'] == "Proforma" ){
  273.                 $data = array(
  274.                     'body' => $proposalsendmail['body'],
  275.                     'nameurl' => "Proforma, Proposal: ".$proposal->getTitle(),
  276.                     'urlPdf' => "http://inout.mante.solutions/pdf/pro/".$proposal->getId(),
  277.                     'firm' => $firmGmail,
  278.                 );
  279.             }elseif ($proposalsendmail['type'] == "Invoice" ){
  280.                 $data = array(
  281.                     'body' => $proposalsendmail['body'],
  282.                     'nameurl' => "Factura, Proposal: ".$proposal->getTitle(),
  283.                     'urlPdf' => "http://inout.mante.solutions/pdf/inv/".$proposal->getId(),
  284.                     'firm' => $firmGmail,
  285.                 );
  286.             }elseif ($proposalsendmail['type'] == "Presentation" ){
  287.                 $data = array(
  288.                     'body' => $proposalsendmail['body'],
  289.                     'nameurl' => "Presentación, Proposal: ".$proposal->getTitle(),
  290.                     'urlPdf' => "http://inout.mante.solutions/presentation/home/".$proposal->getAccessKey(),
  291.                     'firm' => $firmGmail,
  292.                 );
  293.                 // Guardo en historico de seguimiento
  294.                 $textHistory = $this->translator->trans('Send Mail Presentation');
  295.                 $history = $this->TracingHistoryOperations($proposal->getId(), $textHistory);
  296.             }elseif ($proposalsendmail['type'] == "Available" ){
  297.                 $data = array(
  298.                     'body' => $proposalsendmail['body'],
  299.                     'firm' => $firmGmail,
  300.                 );
  301.             }
  304.             // Buscamos los correos de los administradores
  305.             $emailarray = array();
  306.             $usermails = $em->getRepository(User::class)->findByRole('ROLE_ADMIN');
  307.             foreach($usermails as $usermail){
  308.                 $emailarray[] = $usermail->getEmail();
  309.             }
  311. //            $mailpruebas[] = '';
  312. //            $mailpruebas[] = 'jorge.defreitas@develup.solutions';
  314.             if (is_null($proposalsendmail_mail)){
  315. //                $mailTodos = array_merge($emailarray, $mailAgent, $proposalsendmail_mail, $arraysendmail_admail);
  316.                 $mailTodos = array_merge($mailAgent,  $arraysendmail_admail);
  317.             }else{
  318. //                $mailTodos = array_merge($emailarray, $mailAgent, $proposalsendmail_mail);
  319.                 $mailTodos = array_merge($mailAgent, $proposalsendmail_mail, $arraysendmail_admail);
  320.             }
  322.             $transporter = new Swift_SmtpTransport();
  323.             $transporter->setHost('smtp.gmail.com')
  324.                 ->setEncryption('ssl') //ssl / tls
  325.                 ->setPort(465) // 465 / 587
  326.                 ->setUsername($agentMail)
  327.                 ->setPassword($passGmail);
  328.             $mailer = new Swift_Mailer($transporter);
  330. //            $message = (new \Swift_Message())
  331.             $message = new Swift_Message();
  332.             $message->setSubject($proposalsendmail['subject'])
  333. //                ->setFrom(array("desarrollo@develup.solutions" => "Prueba"))
  334.                 ->setSender($agentMail)
  335.                 ->setFrom($mailAgentSent)
  336.                 ->setReplyTo($mailAgentSent)
  337.                 ->setTo($mailTodos)
  338.                 ->setBody(
  339.                     $this->renderView(
  340.                         'mail/structure-mail.html.twig',
  341.                         array('data' => $data)
  342.                     ),
  343.                     'text/html'
  344.                 )
  345.             ;
  346.             $mailer->send($message);
  348.             $mailTodos = implode(",", $mailTodos);
  349.             $mail->setMail($mailTodos);
  350.             $mail->setBody($proposalsendmail['body']);
  352.             /* Obtengo usuario logueado */
  353.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  354.             $user_id = $user_logueado->getId();
  356.             $mail->setCreatedId($user_id);
  357.             $mail->setUpdatedId($user_id);
  359.             $em->persist($mail);
  360.             $em->flush();
  361.             $event = 'Sent the mail and registered.';
  363.             $successMessage = $this->translator->trans($event);
  364.             $this->addFlash('mensajeMailSend', $successMessage);
  366.             return $this->redirectToRoute('list_SentMail_Proposal',
  367.                 array(
  368.                     'id' => $mail->getProposalId(),
  369.                 )
  370.             );
  372.         }else{
  373.             $errorMessagebase = $this->translator->trans('Error, some fields are empty');
  374.             $errorMessage = $errorMessagebase;
  375.             $this->addFlash('mensajeMailSenderror', $errorMessage);
  376.         }
  378.         $proposal = $em->getRepository(Proposal::class)->findOneById($mail->getProposalId());
  380.         return $this->render('MDS/EventsBundle/proposal/send-mail.html.twig', array(
  381.                 'id' => $mail->getProposalId(),
  382.                 'token' => $proposal->getAccessKey(),
  383.                 'subjectAndMessage' => $proposal->getId().' - '.$proposal->getTitle(),
  384.                 'correos' => null,
  385.                 'mcp' => $proposal->getMcp(),
  386.                 'form' => $form->createView()
  387.             )
  388.         );
  390.     }
  392.     /**
  393.      * @Route("/mail/searchcreate", name="proposal_mail_create_search")
  394.      */
  395.     public function createProposalMailSearchAction(Request $request, \Swift_Mailer $mailer)
  396.     {
  398.         $proposalsendmail = $request->request->get('sendmail');
  399.         $em = $this->getDoctrine()->getManager();
  400.         $proposal = $em->getRepository(Proposal::class)->findOneById($proposalsendmail['proposalId']);
  401.         $proposalsendmail_mail = $request->request->get('sendmail_mail')['mail'];
  403.         $mailnew = new SendMail();
  404.         $form = $this->createProposalMailCreateForm($mailnew);
  405.         $form->handleRequest($request);
  407.         if($form->isValid())
  408.         {
  410.             $proposal = $em->getRepository(Proposal::class)->findOneById($proposalsendmail['proposalId']);
  411.             $proposal->setSent('Yes');
  412.             $em->persist($proposal);
  414.             $agent = $em->getRepository(User::class)->findOneById($proposal->getAgentId());
  415.             $mailAgent[] = $agent->getEmail();
  416.             $agentMail = $agent->getEmail();
  417.             $passGmail = $agent->getPassGmail();
  418.             $firmGmail = $agent->getFirmGmail();
  419.             $mailAgentSent = array(
  420.                 $agent->getEmail() => $agent->getName().' '. $agent->getLastName()
  421.             );
  423.             $data = array(
  424.                 'body' => $proposalsendmail['body'],
  425.                 'firm' => $firmGmail,
  426.             );
  428.             // Buscamos los correos de los administradores
  429.             $emailarray = array();
  430.             $usermails = $em->getRepository(User::class)->findByRole('ROLE_ADMIN');
  431.             foreach($usermails as $usermail){
  432.                 $emailarray[] = $usermail->getEmail();
  433.             }
  436.             foreach($proposalsendmail_mail as $key => $proposalsendmailmail){
  438.                     $supplier = $em->getRepository(Supplier::class)->findOneById($key);
  439.                     $supplierName = $supplier->getName();
  440.                     $subject = $proposalsendmail['subject']." / ".$supplierName;
  442.                     $mailTodos = array_merge($mailAgent, $proposalsendmailmail);
  443. //                d($subject, $mailTodos);
  445.                     $transporter = new Swift_SmtpTransport();
  446.                     $transporter->setHost('smtp.gmail.com')
  447.                         ->setEncryption('ssl') //ssl / tls
  448.                         ->setPort(465) // 465 / 587
  449.                         ->setUsername($agentMail)
  450.                         ->setPassword($passGmail);
  451.                     $mailer = new Swift_Mailer($transporter);
  453.                     $message = new Swift_Message();
  454.                     $message->setSubject($subject)
  455.                         ->setSender($agentMail)
  456.                         ->setFrom($mailAgentSent)
  457.                         ->setReplyTo($mailAgentSent)
  458.                         ->setTo($mailTodos)
  459.                         ->setBody(
  460.                             $this->renderView(
  461.                                 'mail/structure-mail.html.twig',
  462.                                 array('data' => $data)
  463.                             ),
  464.                             'text/html'
  465.                         )
  466.                     ;
  467.                     $mailer->send($message);
  470.                     $mail = new SendMail();
  472.                     $mailTodos = implode(",", $mailTodos);
  473.                     $mail->setMail($mailTodos);
  474.                     $mail->setType('Available');
  475.                     $mail->setProposalId($proposalsendmail['proposalId']);
  476.                     $mail->setSubject($subject);
  477.                     $mail->setBody($proposalsendmail['body']);
  479.                     /* Obtengo usuario logueado */
  480.                     $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  481.                     $user_id = $user_logueado->getId();
  483.                     $mail->setCreatedId($user_id);
  484.                     $mail->setUpdatedId($user_id);
  486.                     $em->persist($mail);
  487.                     $em->flush();
  488.                     $event = 'Sent the mail and registered. / '.$subject;
  490.                     $successMessage = $this->translator->trans($event);
  491.                     $this->addFlash('mensajesenmail', $successMessage);
  492.             }
  494.             // Guardo en historico de seguimiento
  495.             $textHistory = $this->translator->trans('Send mail request hotels');
  496.             $history = $this->TracingHistoryOperations($proposal->getId(), $textHistory);
  498. //            return $this->redirectToRoute('list_SentMail_Proposal',
  499. //                array(
  500. //                    'id' => $mail->getProposalId(),
  501. //                )
  502. //            );
  504.         }else{
  505.             $errorMessagebase = $this->translator->trans('Error, some fields are empty');
  506.             $errorMessage = $errorMessagebase;
  507.             $this->addFlash('mensajesenmailerror', $errorMessage);
  508.         }
  510.         return $this->redirectToRoute('list_SentMail_Proposal',
  511.             array(
  512.                 'id' => $proposal->getId(),
  513.             )
  514.         );
  516. //        return $this->render('MDS/EventsBundle/proposal/send-mail.html.twig', array(
  517. //                'id' => $proposal->getId(),
  518. //                'token' => $proposal->getAccessKey(),
  519. //                'mcp' => $proposal->getMcp(),
  520. //                'form' => $form->createView()
  521. //            )
  522. //        );
  524.     }
  526.     // Funcion para insertar historico de seguimiento
  527.     // $textHistory = $this->translator->trans('');
  528.     // $history = $this->TracingHistoryOperations($proposal->getId(), $text);
  529.     private function TracingHistoryOperations($id, $text)
  530.     {
  531.         $em = $this->getDoctrine()->getManager();
  532.         /* Obtengo usuario logueado */
  533.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  534.         $user_id = $user_logueado->getId();
  536.         $history = new ProposalTracing();
  537.         $history->setDateAt(new \DateTime('now'));
  538.         $history->setText($text);
  539.         $history->setAgentId($user_id);
  540.         $history->setProposalId($id);
  541.         $history->setViewed('no');
  542.         $history->setCreatedId($user_id);
  543.         $history->setUpdatedId($user_id);
  544.         $em->persist($history);
  545.         $em->flush();
  547.         $success = 'success';
  548.         return $success;
  549.     }
  553.     private function findMailsAgentsProposal($id)
  554.     {
  555.         // INCIO: Buscamos los agentes del proposal para que todos esten informados
  556.         $em = $this->getDoctrine()->getManager();
  557.         $prop_agents = $em->getRepository(ProposalAgents::class)->findOneByIdProp($id);
  558.         $data = array();
  560.         if (($prop_agents->getAgOne() !=0) and !empty($prop_agents->getAgOne())) {
  561.             $agent = $em->getRepository(User::class)->findOneById($prop_agents->getAgOne());
  563.             $data[] = array(
  564.                 'name' => $agent->getName(),
  565.                 'lastname' => $agent->getLastName(),
  566.                 'email' => $agent->getEmail()
  567.             );
  568.         }
  570.         if (($prop_agents->getAgTwo() !=0) and !empty($prop_agents->getAgTwo())) {
  571.             $agent = $em->getRepository(User::class)->findOneById($prop_agents->getAgTwo());
  573.             $data[] = array(
  574.                 'name' => $agent->getName(),
  575.                 'lastname' => $agent->getLastName(),
  576.                 'email' => $agent->getEmail()
  577.             );
  578.         }
  580.         if (($prop_agents->getAgThree() !=0) and !empty($prop_agents->getAgThree())) {
  581.             $agent = $em->getRepository(User::class)->findOneById($prop_agents->getAgThree());
  583.             $data[] = array(
  584.                 'name' => $agent->getName(),
  585.                 'lastname' => $agent->getLastName(),
  586.                 'email' => $agent->getEmail()
  587.             );
  588.         }
  590.         if (($prop_agents->getAgFour() !=0) and !empty($prop_agents->getAgFour())) {
  591.             $agent = $em->getRepository(User::class)->findOneById($prop_agents->getAgFour());
  593.             $data[] = array(
  594.                 'name' => $agent->getName(),
  595.                 'lastname' => $agent->getLastName(),
  596.                 'email' => $agent->getEmail()
  597.             );
  598.         }
  600.         // FIN: Buscamos los agentes del proposal para que todos esten informados
  602.         return $data;
  603.     }
  605. }