src/Controller/ManageAccountsController.php line 49

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\SiteBannedIps;
  6. use App\Entity\CrmEnquiries;
  7. use App\Entity\UserCrms;
  8. use App\Form\ManageCompaniesForm;
  9. use Doctrine\ORM\EntityManagerInterface;
  10. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  11. use Symfony\Component\HttpFoundation\Request;
  12. use Symfony\Component\HttpFoundation\Response;
  13. use Symfony\Component\Routing\Annotation\Route;
  14. use App\Form\Filters\ManageCompaniesFilter;
  15. use App\Form\Filters\CrmRecycleBinFilter;
  16. use App\Repository\CompaniesRepository;
  17. use App\Service\ServiceStorage;
  18. use App\Service\ServiceEnquiry;
  19. use App\Repository\TrashItemsRepository;
  20. use App\Repository\EnquiriesRepository;
  21. use App\Repository\UserSubscriptionsRepository;
  22. use App\Form\Filters\UserSubscriptionsFilter;
  25. #[Route('/manage/accounts')]
  26. class ManageAccountsController extends AbstractController
  27. {
  28.     #[Route('/', defaults: ['page' => '1'], methods: ['GET'], name: 'manage_account_index')]
  29.     #[Route('/page/{page<[1-9]\d*>}', methods: ['GET'], name: 'manage_account_index_paginated')]
  30.     #[Cache(smaxage: 10)]
  31.     public function index(Request $request,int $page,EntityManagerInterface $entityManager,CompaniesRepository $companiesRepository): Response
  32.     {
  33.         $params = $request->query->all();
  34.         $filter = [];
  36.         $filterForm = $this->createForm(ManageCompaniesFilter::class,$params);
  38.         $data = $companiesRepository->adminPaginatorFetchAll($page, $params);
  40.         return $this->render('manage/accounts/index.html.twig', [
  41.             'paginator' => $data,
  42.             'filter' => $params,
  43.             'form' => $filterForm->createView(),
  44.         ]);
  46.     }
  48.     #[Route('/details/{id}', name: 'manage_account_details', methods: ['GET'])]
  49.     public function details(UserCrms $companies): Response
  50.     {
  51.         return $this->render('manage/accounts/details.html.twig', [
  52.             'companies' => $companies,
  53.         ]);
  54.     }
  56.     #[Route('/statistics/{id}', name: 'manage_account_statistics', methods: ['GET'])]
  57.     public function statistics(UserCrms $companies): Response
  58.     {
  59.         return $this->render('manage/accounts/statistics.html.twig', [
  60.             'companies' => $companies,
  61.         ]);
  62.     }
  64.     #[Route('/members/{id}', name: 'manage_account_members', methods: ['GET'])]
  65.     public function listAllMembers($id, UserCrms $companies, EntityManagerInterface $entityManager): Response
  66.     {
  67.         $companyUser = $entityManager->getRepository(\App\Entity\UserCrmRelationships::class)->findBy(array('crmId' => $id));
  69.         return $this->render('manage/accounts/members.html.twig', [
  70.             'companies' => $companies,
  71.             'companyUser' => $companyUser,
  72.         ]);
  73.     }
  75.     #[Route('/transaction/{id}', name: 'manage_account_transaction', methods: ['GET'])]
  76.     public function transactionList($id, UserCrms $companies, EntityManagerInterface $entityManager): Response
  77.     {
  78.         $userTransactions = $entityManager->getRepository(\App\Entity\UserTransactions::class)->findBy(array('crmId' => $id));
  80.         return $this->render('manage/accounts/transaction.html.twig', [
  81.             'companies' => $companies,
  82.             'userTransactions' => $userTransactions,
  83.         ]);
  84.     }
  86.     #[Route('/edit/{id}', name: 'manage_account_edit', methods: ['GET', 'POST'])]
  87.     public function edit(Request $request, UserCrms $companies, EntityManagerInterface $entityManager,ServiceStorage $serviceStorage): Response
  88.     {
  89.         $form = $this->createForm(ManageCompaniesForm::class, $companies);
  90.         $form->handleRequest($request);
  91.         $crm_img_path = $serviceStorage->getFileUrl($companies->getMediaId());
  92.         if ($form->isSubmitted() && $form->isValid()) {
  93.             $lifetime = $form->get('lifetime')->getData();
  94.             $import_csv = $form->get('import_csv')->getData();
  95.             $mass_email = $form->get('mass_email')->getData();
  97.             $csvEnable = $entityManager->getRepository(\App\Entity\CrmSettings::class)->findOneBy(['crmId'=>$companies->getCrmId(), 'name' => 'csv.enable']);
  99.             $massEmailEnable = $entityManager->getRepository(\App\Entity\CrmSettings::class)->findOneBy(['crmId'=>$companies->getCrmId(), 'name' => 'mass_email.enable']);
  101.             $lifetimeEnable = $entityManager->getRepository(\App\Entity\CrmSettings::class)->findOneBy(['crmId'=>$companies->getCrmId(), 'name' => 'lifetime.enable']);
  104.             if($csvEnable){
  105.                 $csvEnable->setValue($import_csv);
  106.                 $entityManager->persist($csvEnable);
  107.                 $entityManager->flush();
  108.             }else{
  109.                 $companySettings = new \App\Entity\CrmSettings();
  110.                 $companySettings->setCrmId($companies->getCrmId());
  111.                 $companySettings->setSection('csv.enable');
  112.                 $companySettings->setName('csv.enable');
  113.                 $companySettings->setValue($import_csv);
  114.                 $entityManager->persist($companySettings);
  115.                 $entityManager->flush();
  116.             }
  117.             if($massEmailEnable){
  118.                 $massEmailEnable->setValue($mass_email);
  119.                 $entityManager->persist($massEmailEnable);
  120.                 $entityManager->flush();
  121.             }else{
  122.                 $companySettings = new \App\Entity\CrmSettings();
  123.                 $companySettings->setCrmId($companies->getCrmId());
  124.                 $companySettings->setSection('mass_email.enable');
  125.                 $companySettings->setName('mass_email.enable');
  126.                 $companySettings->setValue($mass_email);
  127.                 $entityManager->persist($companySettings);
  128.                 $entityManager->flush();
  129.             }
  130.             if($lifetimeEnable){
  131.                 $lifetimeEnable->setValue($lifetime);
  132.                 $entityManager->persist($lifetimeEnable);
  133.                 $entityManager->flush();
  134.             }else{
  135.                 $companySettings = new \App\Entity\CrmSettings();
  136.                 $companySettings->setCrmId($companies->getCrmId());
  137.                 $companySettings->setSection('lifetime.enable');
  138.                 $companySettings->setName('lifetime.enable');
  139.                 $companySettings->setValue($lifetime);
  140.                 $entityManager->persist($companySettings);
  141.                 $entityManager->flush();
  142.             }
  144.             $entityManager->flush();
  145.             $this->addFlash('success', 'Update successfully.');
  146.             return $this->redirectToRoute('manage_account_details', ['id' => $companies->getCrmId()], Response::HTTP_SEE_OTHER);
  147.         }
  148.         
  149.         return $this->renderForm('manage/accounts/edit.html.twig', [
  150.             'companies' => $companies,
  151.             'form' => $form,
  152.             'crm_img_path' => $crm_img_path,
  153.         ]);
  154.     }
  156.     #[Route('/recycle-bin/{id}', defaults: ['page' => '1'], name: 'manage_account_recycle_bin', methods: ['GET'])]
  157.     #[Route('/recycle-bin/{id}/page/{page<[1-9]\d*>}', methods: ['GET'], name: 'manage_account_recycle_bin_paginated')]
  158.     #[Cache(smaxage: 10)]
  159.     public function recycleBin($id, $page, UserCrms $companies, TrashItemsRepository $trashItemsRepository, EntityManagerInterface $entityManager, Request $request): Response
  160.     {
  161.         $filter = $params = $request->query->all();
  162.       
  163.         $restoreAllBtn = false;
  164.         if(isset($params['start_date']) && $params['start_date'] || isset($params['end_date']) && $params['end_date'] || !empty($params['user']) || !empty($params['enquiry_id']) || !empty($params['quote_id']) || !empty($params['job_id'])){
  165.             $restoreAllBtn = true;
  166.         }
  167.         $filterForm = $this->createForm(CrmRecycleBinFilter::class,$filter);
  168.         $data = $trashItemsRepository->adminPaginatorFetchAllByCrm($id, $page, $filter);
  170.         unset($params['_token']);
  172.         return $this->render('manage/accounts/recycle-bin.html.twig', [
  173.             'paginator' => $data,
  174.             'companies' => $companies,
  175.             'filter' => $filter,
  176.             'restoreAllBtn' => $restoreAllBtn,
  177.             'urlParams' => base64_encode(json_encode($params)),
  178.             'form' => $filterForm->createView()
  179.         ]);
  180.     }
  182.     #[Route('/bulk-restore/{id}/{params?}', name: 'company_manage_bulk_restore', methods: ['POST','GET'])]
  183.     public function bulkRestore($id, $params, Request $request, UserCrms $companies, EntityManagerInterface $entityManager): Response
  184.     {   
  185.         $filter = json_decode(base64_decode($params),true);
  186.         $start_at = (isset($filter['start_at']) && $filter['start_at']) ? date('Y-m-d 00:00:00', strtotime($filter['start_at'])) : date('Y-m-d 00:00:00',strtotime('01-01-2000'));
  187.         $end_at = (isset($filter['end_at']) && $filter['end_at']) ? date('Y-m-d 23:59:59',strtotime($filter['end_at'])) : date('Y-m-d 23:59:59');
  188.     
  189.         if ($this->isCsrfTokenValid('restore'.$companies->getCrmId(), $request->request->get('_token'))) {
  190.             $trashItem = $entityManager->getRepository(\App\Entity\TrashItems::class)->createQueryBuilder('p')
  191.                     ->update()
  192.                     ->set('p.isRestoring', 1)
  193.                     ->andWhere("p.crmId = {$id}");
  195.                     if (isset($filter['user']) && !empty($filter['user'])) {
  196.                         $entityManager = $this->getEntityManager();
  197.                         $user = $entityManager->getRepository(\App\Entity\User::class)->createQueryBuilder('u')
  198.                                             ->add('select', 'u.userId')
  199.                                             ->andWhere('u.name LIKE :name OR u.email LIKE :name')
  200.                                             ->setParameter('name', '%'. $filter['user'] . '%')
  201.                                             ->getQuery()->getResult();
  202.                         $userIds = array();
  203.                         if($user){
  204.                             foreach($user as $user){
  205.                                 $userIds[] = $user['userId'];
  206.                             }
  207.                         }
  208.                         if(count($userIds)){
  209.                             $trashItem->andWhere("p.userId IN(:ids)")
  210.                                 ->setParameter('ids', array_values($userIds));
  211.                         }else{
  212.                             $trashItem->andWhere("p.userId = :userId")
  213.                                 ->setParameter('userId',0);
  214.                         }
  215.                     }
  216.                     if (isset($filter['enquiry_id']) && !empty($filter['enquiry_id'])) {   
  217.                         $trashItem->andWhere('p.objectType = :type OR p.resourceType = :type')
  218.                         ->setParameter('type', 'enquiry')
  219.                         ->andWhere('p.objectId LIKE :id OR p.resourceId LIKE :id')
  220.                         ->setParameter('id', '%'. $filter['enquiry_id'] . '%');
  221.                     }
  223.                     if (isset($filter['quote_id']) && !empty($filter['quote_id'])) {
  224.                         $trashItem->andWhere('p.objectType = :type OR p.resourceType = :type')
  225.                             ->setParameter('type', 'quote_outcome')
  226.                             ->andWhere('p.objectId LIKE :id OR p.resourceId LIKE :id')
  227.                             ->setParameter('id', '%'. $filter['quote_id'] . '%')
  228.                         ;
  229.                     }
  230.             
  231.                     if (isset($filter['job_id']) && !empty($filter['job_id'])) {
  232.                         $trashItem->andWhere('p.resourceId LIKE :id')
  233.                             ->setParameter('id', '%'. $filter['job_id'] . '%')
  234.                         ;
  235.                     }
  236.                     if($start_at || $end_at){
  237.                         $trashItem->andwhere('p.createdAt BETWEEN :startAt AND :endAt')
  238.                         ->setParameter('startAt',$start_at)
  239.                         ->setParameter('endAt',$end_at);
  240.                     }
  242.                     $trashItem->getQuery()->execute();
  244.             $this->addFlash('success', 'Data restore starting.');
  245.             return $this->redirectToRoute('manage_account_recycle_bin', ['id'=> $companies->getCrmId()], Response::HTTP_SEE_OTHER);
  246.         }
  248.         return $this->renderForm('manage/accounts/bulk-restore.html.twig', [
  249.             'companies' => $companies,
  250.             'start_at' => $start_at,
  251.             'end_at' => $end_at,
  252.             'params' => $params
  253.         ]);
  254.     }
  256.     #[Route('/enquiry/{id}', defaults: ['page' => '1'], methods: ['GET'], name: 'enquiries_index')]
  257.     #[Route('/enquiry/{id}/page/{page<[1-9]\d*>}', methods: ['GET'], name: 'enquiries_index_paginated')]
  258.     #[Cache(smaxage: 10)]
  259.     public function enquiriesIndex($id, UserCrms $companies, Request $request,int $page,EntityManagerInterface $entityManager,EnquiriesRepository $enquiriesRepository): Response
  260.     {
  261.         $params = $request->query->all();
  262.         $data = $enquiriesRepository->adminPaginatorFetchAll($id, $page, $params);
  263.         return $this->render('manage/accounts/enquiries-index.html.twig', [
  264.             'paginator' => $data,
  265.             'companies' => $companies,
  266.         ]);
  267.     }
  269.     #[Route('/enquiry/customer-view/{id}', name: 'enquiries_customer_view', methods: ['GET'])]
  270.     public function view(CrmEnquiries $crmEnquiries, EntityManagerInterface $entityManager): Response
  271.     {        
  272.         return $this->render('manage/accounts/customer-view.html.twig', [
  273.             'enquiries' => $crmEnquiries,
  274.         ]);
  275.     }
  277.     #[Route('/enquiry/quote/{id}', name: 'quote_view', methods: ['GET'])]
  278.     public function viewQuote(CrmEnquiries $crmEnquiries, EntityManagerInterface $entityManager,$id): Response
  279.     {
  280.         $crmEnquiryQuotes = $entityManager->getRepository(\App\Entity\CrmEnquiryQuotes::class)->findOneBy(array('enquiryId' => $id));
  281.         return $this->render('manage/accounts/view-quote-enquiry.html.twig', [
  282.             'quote' => $crmEnquiryQuotes,
  283.             'enquiries' => $crmEnquiries,
  284.         ]);
  285.     }
  287.     #[Route('/enquiry/job/{id}', name: 'job_view', methods: ['GET'])]
  288.     public function viewJob(CrmEnquiries $crmEnquiries,  EntityManagerInterface $entityManager,$id): Response
  289.     {
  291.         $crmEnquiriesJobBooked = $entityManager->getRepository(\App\Entity\CrmEnquiriesJobBooked::class)->findBy(array('enquiryId' => $id));
  292.         
  293.         return $this->render('manage/accounts/view-job-enquiry.html.twig', [
  294.             'job' => $crmEnquiriesJobBooked,
  295.             'enquiries' => $crmEnquiries,
  296.         ]);
  297.     }
  299.     #[Route('/enquiry/priority/{id}', name: 'priority_view', methods: ['GET'])]
  300.     public function viewPriority(CrmEnquiries $crmEnquiries, EntityManagerInterface $entityManager,$id): Response
  301.     {
  302.         $crmEnquiryPriorities = $entityManager->getRepository(\App\Entity\CrmEnquiryPriorities::class)->findBy(array('enquiryId' => $id));
  304.         return $this->render('manage/accounts/view-priority-enquiry.html.twig', [
  305.             'priority' => $crmEnquiryPriorities,
  306.             'enquiries' => $crmEnquiries,
  307.         ]);
  308.     }
  310.     #[Route('/enquiry/payment/{id}', name: 'payment_view', methods: ['GET'])]
  311.     public function viewPayment(CrmEnquiries $crmEnquiries,  EntityManagerInterface $entityManager,$id): Response
  312.     {
  313.         $crmEnquiriesPaymentSchedule = $entityManager->getRepository(\App\Entity\CrmEnquiriesPaymentSchedule::class)->findBy(array('enquiryId' => $id));
  315.         return $this->render('manage/accounts/view-payment-enquiry.html.twig', [
  316.             'payment_schedule' => $crmEnquiriesPaymentSchedule,
  317.             'enquiries' => $crmEnquiries,
  318.         ]);
  319.     }
  321.     #[Route('/enquiry/sms/{id}', name: 'sms_view', methods: ['GET'])]
  322.     public function viewSms($id, CrmEnquiries $crmEnquiries,  EntityManagerInterface $entityManager): Response
  323.     {
  325.         $crmEnquiryScheduleSms = $entityManager->getRepository(\App\Entity\CrmEnquiryScheduleSms::class)->findBy(array('enquiryId' => $id));
  327.         return $this->render('manage/accounts/view-sms-enquiry.html.twig', [
  328.             'sms_data' => $crmEnquiryScheduleSms,
  329.             'enquiries' => $crmEnquiries,
  330.         ]);
  331.     }
  332.     #[Route('/enquiry/email/{id}', name: 'email_view', methods: ['GET'])]
  333.     public function viewEmail($id, CrmEnquiries $crmEnquiries,  EntityManagerInterface $entityManager, ServiceEnquiry $serviceEnquiry): Response
  334.     {
  335.         $listMailData =[];
  336.         $pendingMailLogs = [];
  337.         $mailLogs = [];
  338.         $crmId = $crmEnquiries->getCrmId();
  339.         
  340.         $welcomeEmails = $entityManager->getRepository(\App\Entity\CrmEnquiryWelcomeMails::class)->findBy(array('crmId' => $crmId, 'enquiryId' => $id));
  341.         foreach($welcomeEmails as $item){
  342.             $mailTo ='';
  343.             $body = unserialize(base64_decode($item->getBody()),[]);
  344.             $emailTo = unserialize($item->getRecipientEmail(),[]);
  345.             if (is_string($emailTo)){
  346.                 $mailTo = $emailTo;
  347.             }else{
  348.                 $mailTo = implode(',',$emailTo);
  349.             }
  350.             $mailLogs[] = array(
  351.                 'id' => $item->getId(),
  352.                 'enquiryId' => $item->getEnquiryId(),
  353.                 'settingId' => 0,
  354.                 'sentDate' => $item->getSentDate(),
  355.                 'date' => $item->getSentDate()->format('Y-m-d H:i:s'),
  356.                 'time' => $item->getSentDate()->format('H:i:s'),
  357.                 'type' => 'general',
  358.                 'templateId' => $body['mail_template'],
  359.                 'subject' => $body['mail_subject'],
  360.                 'body' => str_replace('&nbsp;',' ',strip_tags($body['mail_body'])),
  361.                 'emails' => $mailTo
  362.             );
  363.         }
  365.         $invoiceMails = $entityManager->getRepository(\App\Entity\CrmInvoiceMails::class)->findBy(array('crmId' => $crmId,'enquiryId' => $id));
  366.        
  367.         foreach($invoiceMails as $item){
  368.             $body = unserialize(base64_decode($item->getBody()),[]);
  369.             $templateId = 0;
  370.             $responsible = '';
  371.             $passign = $entityManager->getRepository(\App\Entity\CrmEnquiriesPaymentAssigned::class)->findOneBy(array('scheduleId' => $item->getPaymentId()));
  372.             if($passign){
  373.                 $responsible = $passign->getPaymentAssigned();
  374.             }
  376.             $responsible = $item->getUserId();
  378.             $invSubject = '';
  379.             $invBody = '';
  381.             if($item->getType() == 'invoice'){
  382.                 if(isset($body['pdfData']['params']['reqData']['mail_data']['h_mail_template'])){
  383.                     $templateId = $body['pdfData']['params']['reqData']['mail_data']['h_mail_template'];
  384.                     $invSubject = $body['pdfData']['params']['reqData']['mail_data']['h_mail_subject'];
  385.                     $invBody = $body['pdfData']['params']['reqData']['mail_data']['h_mail_body'];
  386.                 }
  387.                 $type = 'invoice';
  388.             }else{
  389.                 if(isset($body['mail_data']['templateId'])){
  390.                     $templateId = $body['mail_data']['templateId'];
  391.                     $invSubject = $body['mail_data']['subject'];
  392.                     $invBody = $body['mail_data']['body'];
  393.                 }
  394.                 $type = 'payment_receipt';
  395.             }
  396.             
  397.             if(!empty($item->getSentDate())){
  398.                 $emailTo = unserialize($item->getRecipientEmail(),[]);
  399.                 $mailLogs[] = array(
  400.                     'date' => $item->getSentDate(),
  401.                     'time' => $item->getSentDate(),
  402.                     'type' => $type,
  403.                     'templateId' => $templateId,
  404.                     'user_id' => $item->getUserId(),
  405.                     'subject' => $invSubject,
  406.                     'body' => str_replace('&nbsp;',' ',strip_tags($invBody)),
  407.                     'emails' => implode(',',$emailTo)
  408.                 );
  409.             }
  410.         }
  412.         $quoteMails = $entityManager->getRepository(\App\Entity\CrmEnquiryMails::class)->findBy(array('enquiryId' => $id));
  413.         
  414.         foreach($quoteMails as $item){
  415.             $body = unserialize(base64_decode($item->getBody()),[]);
  416.             $templateId = 0;
  417.             $responsible = '';
  418.             if(isset($body['mail_data']['h_mail_template'])){
  419.                 $templateId = $body['mail_data']['h_mail_template'];
  420.             }
  421.             if(isset($body['quoteResponsibleId'])){
  422.                 $responsible = $body['quoteResponsibleId'];
  423.             }
  424.             $quote_user_id = '';
  425.             if(isset($body['items']['user_id'])){
  426.                 $quote_user_id = $body['items']['user_id'];
  427.             }
  429.             $quote = $entityManager->getRepository(\App\Entity\CrmEnquiryQuotes::class)
  430.                     ->findOneBy(array('enquiryId' => $id, 'crmId' => $crmId));
  432.             $bodyContent = str_replace('&nbsp;',' ',strip_tags($body['mail_data']['h_mail_body']));
  433.             $bodyContent = str_replace('p {margin:0px;}', '', $bodyContent);
  434.             $bodyContent = str_replace('&nbsp;', ' ', $bodyContent);
  435.             $emailTo = unserialize($item->getRecipientEmail(),[]);
  436.             $mailLogs[] = array(
  437.                 'date' => $item->getSentDate(),
  438.                 'time' => $item->getSentDate(),
  439.                 'type' => 'quote',
  440.                 'templateId' => $templateId,
  441.                 'templateTitle' =>  $serviceEnquiry->getTemplateNameById($templateId,$crmId),
  442.                 'user_id' => $quote_user_id,
  443.                 'subject' => $body['mail_data']['h_mail_subject'],
  444.                 'body' => $bodyContent,
  445.                 'emails' => implode(',',$emailTo)
  446.             );
  447.         }
  449.         $followupEmails = $entityManager->getRepository(\App\Entity\CrmEmailFollowup::class)->findBy(array('enquiryId' => $id));
  451.         foreach($followupEmails as $item){
  452.             $setting = $serviceEnquiry->getFollowupEmailSetting($item->getSettingId(),$crmId);
  453.             $followupSubject = '';
  454.             $followupBody = '';
  455.             if($setting){
  456.                 //getbody 
  457.                 $crmFollowMailBody = $entityManager->getRepository(\App\Entity\SiteMailLogs::class)->findBy(array('crmId' => $crmId, 'templateId' => $setting->getTemplateId(), 'sourceId' => $item->getId()));
  458.                 if(!$crmFollowMailBody){
  459.                     $crmFollowMailTemplate = $entityManager->getRepository(\App\Entity\CrmMailTemplate::class)->findOneBy(array('crmId' => $crmId, 'id' => $setting->getTemplateId()));
  460.                     $followupSubject = $crmFollowMailTemplate->getSubject();
  461.                     $followupBody = $crmFollowMailTemplate->getBody();
  462.                 }
  463.             }
  464.             $templateTitle = '';
  465.             if($setting){
  466.                 $templateTitle =  $serviceEnquiry->getTemplateNameById($setting->getTemplateId(),$crmId);
  467.             }
  468.             
  469.             if($crmFollowMailBody){
  470.                 foreach ($crmFollowMailBody as $mailBody) {
  471.                     $body =  unserialize(base64_decode($mailBody->getBody()))['body'];
  472.                     $body = str_replace('p {margin:0px;}', '', $body);
  473.                     $mailLogs[] = array(
  474.                         'date' => $item->getSentDate(),
  475.                         'time' => $item->getSentDate(),
  476.                         'type' => 'follow-up',
  477.                         'responsible' => '',
  478.                         'templateId' => $setting ? $setting->getTemplateId() : 0,
  479.                         'isExpired' => $item->getIsExpired(),
  480.                         'subject' => $followupSubject,
  481.                         'body' => str_replace('&nbsp;',' ',strip_tags($body)),
  482.                         'templateTitle' => $templateTitle,
  483.                         'emails' => ''
  484.                     );
  485.                 }
  486.             } else{
  487.                 $mailLogs[] = array(
  488.                     'date' => $item->getSentDate(),
  489.                     'time' => $item->getSentDate(),
  490.                     'type' => 'follow-up',
  491.                     'responsible' => '',
  492.                     'templateId' => $setting ? $setting->getTemplateId() : 0,
  493.                     'isExpired' => $item->getIsExpired(),
  494.                     'subject' => $followupSubject,
  495.                     'body' => str_replace('&nbsp;',' ',strip_tags($followupBody)),
  496.                     'templateTitle' => $templateTitle,
  497.                     'emails' => ""
  498.                 );
  499.             }
  500.         }
  502.         $jobEmails = $entityManager->getRepository(\App\Entity\CrmJobConfirmationMails::class)->findBy(array('enquiryId' => $id));
  504.         foreach($jobEmails as $item){
  505.             $body = unserialize(base64_decode($item->getBody()),[]);
  506.             $emailTo = unserialize($item->getRecipientEmail(),[]);
  507.             $mailLogs[] = array(
  508.                 'date' => $item->getSentDate(),
  509.                 'time' => $item->getSentDate(),
  510.                 'type' => 'job',
  511.                 'templateId' => $body['mail_template'],
  512.                 'subject' => $body['mail_subject'],
  513.                 'body' => str_replace('&nbsp;',' ',str_replace('&nbsp;',' ',strip_tags($body['mail_body']))),
  514.                 'emails' => implode(',',$emailTo)
  515.             );
  516.         }
  518.         $listMailData = $mailLogs;
  519.         return $this->render('manage/accounts/view-email-enquiry.html.twig', [
  520.             'email_data' => $listMailData,
  521.             'enquiries' => $crmEnquiries,
  522.         ]);
  523.     }
  525.     #[Route('/enquiry/job-summary/{id}', name: 'job_summary', methods: ['GET'])]
  526.     public function viewJobSummary(CrmEnquiries $crmEnquiries,  EntityManagerInterface $entityManager,$id): Response
  527.     {
  528.         $enquiryDescriptions = $entityManager->getRepository(\App\Entity\CrmEnquiryDescriptions::class)->findBy(array('enquiryId' => $id));
  529.         
  530.         return $this->render('manage/accounts/view-job-summary.html.twig', [
  531.             'summary' => $enquiryDescriptions,
  532.             'enquiries' => $crmEnquiries,
  533.         ]);
  534.     }
  536.     #[Route('/enquiry/payment-schedule/{id}', name: 'payment_schedule', methods: ['GET'])]
  537.     public function viewPaymentSchedule(CrmEnquiries $crmEnquiries,  EntityManagerInterface $entityManager,$id): Response
  538.     {
  539.         $paymentSchedule = $entityManager->getRepository(\App\Entity\CrmEnquiriesPaymentSchedule::class)->findBy(array('enquiryId' => $id));
  540.         
  541.         return $this->render('manage/accounts/view-payment-schedule.html.twig', [
  542.             'payment_schedule' => $paymentSchedule,
  543.             'enquiries' => $crmEnquiries,
  544.         ]);
  545.     }
  547.     #[Route('/enquiry/followup/{id}', name: 'followup_view', methods: ['GET'])]
  548.     public function viewFollowup(CrmEnquiries $crmEnquiries,  EntityManagerInterface $entityManager,$id): Response
  549.     {
  550.         $crmFollowup = $entityManager->getRepository(\App\Entity\CrmFollowup::class)->findBy(array('enquiryId' => $id));
  552.         return $this->render('manage/accounts/view-followup-enquiry.html.twig', [
  553.             'followup' => $crmFollowup,
  554.             'enquiries' => $crmEnquiries,
  555.         ]);
  556.     }
  557. }