src/Controller/ManageAccountsController.php line 31

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