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\Security\LoginAuthenticator;
  20. use App\Services\ImportBusinessContactsService;
  21. use App\Services\ImportBusinessTypesService;
  22. use App\Services\ImportCMSCopyService;
  23. use App\Services\ImportCmsPageCopyPageFormatService;
  24. use App\Services\ImportCMSPhotoService;
  25. use App\Services\ImportCompanyDetailsService;
  26. use App\Services\ImportCompetitorsService;
  27. use App\Services\ImportFacebookGroupsService;
  28. use App\Services\ImportInstructionsService;
  29. use App\Services\ImportLanguagesService;
  30. use App\Services\ImportLoginDirectionsService;
  31. use App\Services\ImportMapIconsService;
  32. use App\Services\ImportProductsService;
  33. use App\Services\ImportRolesService;
  34. use App\Services\ImportTranslationsService;
  35. use App\Services\ImportUsefulLinksService;
  36. use App\Services\ImportUserService;
  37. use Doctrine\ORM\EntityManagerInterface;
  38. use JeroenDesloovere\VCard\VCard;
  39. use Psr\EventDispatcher\EventDispatcherInterface;
  40. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  41. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  42. use Symfony\Bundle\SecurityBundle\Security;
  43. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  44. use Symfony\Component\HttpFoundation\HeaderUtils;
  45. use Symfony\Component\HttpFoundation\Request;
  46. use Symfony\Component\HttpFoundation\Response;
  47. use Symfony\Component\Mailer\MailerInterface;
  48. use Symfony\Component\Routing\Annotation\Route;
  49. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  50. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  51. use Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken;
  52. use Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorageInterface;
  53. use Symfony\Component\Security\Core\User\UserInterface;
  54. use Symfony\Component\Security\Csrf\CsrfToken;
  55. use Symfony\Component\Security\Csrf\CsrfTokenManagerInterface;
  56. use Symfony\Component\Security\Http\Authentication\UserAuthenticatorInterface;
  57. use Symfony\Component\Security\Http\Event\InteractiveLoginEvent;
  58. use Symfony\Component\String\Slugger\SluggerInterface;
  60. class   HomeController extends AbstractController
  61. {
  62.     /**
  63.      * @Route("/", name="app_home")
  64.      */
  65.     public function index(Request $request, CmsCopyRepository $cmsCopyRepository, CmsPhotoRepository $cmsPhotoRepository, SubPageRepository $subPageRepository, CompanyDetailsRepository $companyDetailsRepository, Security $security, EntityManagerInterface $entityManager, PageVisitRepository $pageVisitRepository):
  66.     Response
  67.     {
  68.         // Resolve favicon directory relative to /public
  69.         $faviconsDirectory = str_replace(
  70.             $this->getParameter('kernel.project_dir') . '/public',
  71.             '',
  72.             $this->getParameter('favicons_directory')
  73.         );
  75.         $companyDetails = $companyDetailsRepository->find('1');
  76.         $homePagePhotosOnly = 0;
  77.         $include_qr_code = [];
  78.         $include_contact_form = [];
  80.         $website_contact = new WebsiteContacts();
  81.         $form = $this->createForm(WebsiteContactsType::class, $website_contact);
  82.         $form->handleRequest($request);
  84.         if ($companyDetails) {
  85.             $homePagePhotosOnly = $companyDetails->isHomePagePhotosOnly();
  86.             $include_qr_code = $companyDetails->isIncludeQRCodeHomePage();
  87.             $include_contact_form = $companyDetails->isIncludeContactFormHomePage();
  88.         }
  90.         // Load Home CMS copy & photos
  91.         $cms_copy = $cmsCopyRepository->findBy([
  92.             'staticPageName' => 'Home',
  93.         ]);
  95.         $cms_photo = $cmsPhotoRepository->findBy(
  96.             ['staticPageName' => 'Home'],
  97.             ['ranking' => 'ASC']
  98.         );
  100.         $cms_copy_ranking1 = $cmsCopyRepository->findOneBy([
  101.             'staticPageName' => 'Home',
  102.             'ranking' => '1',
  103.         ]);
  105.         if ($cms_copy_ranking1) {
  106.             $page_layout = $cms_copy_ranking1->getPageLayout();
  107.         } else {
  108.             $page_layout = 'default';
  109.         }
  111.         // -------------------------------------------------
  112.         // 1) Increment today's PageVisit for the homepage
  113.         //    (product = null bucket)
  114.         // -------------------------------------------------
  115.         $user = $security->getUser();
  116.         $today = new \DateTimeImmutable('today');
  118.         $homeVisit = $pageVisitRepository->findOneBy([
  119.             'date' => $today,
  120.             'product' => null,   // 👈 homepage bucket
  121.         ]);
  123.         if (!$homeVisit) {
  124.             $homeVisit = new PageVisit();
  125.             $homeVisit->setDate($today);
  126.             $homeVisit->setProduct(null);
  127.             $homeVisit->setCount(0);
  128.             $homeVisit->setCountUser(0);
  129.             $homeVisit->setCountAdmin(0);
  130.             $entityManager->persist($homeVisit);
  131.         }
  133.         if (!$user) {
  134.             // Anonymous visitor
  135.             $homeVisit->setCount($homeVisit->getCount() + 1);
  136.         } elseif (in_array('ROLE_ADMIN', $user->getRoles(), true)) {
  137.             // Admin
  138.             $homeVisit->setCountAdmin($homeVisit->getCountAdmin() + 1);
  139.         } else {
  140.             // Logged-in non-admin
  141.             $homeVisit->setCountUser($homeVisit->getCountUser() + 1);
  142.         }
  144.         // Flush CmsCopy + PageVisit changes once
  145.         $entityManager->flush();
  147.         // -------------------------------------------------
  148.         // 2) Build totals for the homepage across all dates
  149.         // -------------------------------------------------
  150.         $visitTotals = [
  151.             'public' => 0,
  152.             'user' => 0,
  153.             'admin' => 0,
  154.         ];
  156.         $homeVisitsAll = $pageVisitRepository->findBy([
  157.             'product' => null,   // all homepage rows
  158.         ]);
  160.         foreach ($homeVisitsAll as $visit) {
  161.             $visitTotals['public'] += (int)$visit->getCount();
  162.             $visitTotals['user'] += (int)$visit->getCountUser();
  163.             $visitTotals['admin'] += (int)$visit->getCountAdmin();
  164.         }
  166.         // ----------------------------------
  167.         // 3) Existing render logic
  168.         // ----------------------------------
  169.         $product = [];
  170.         $sub_pages = [];
  172.         if ($homePagePhotosOnly == 1) {
  173.             return $this->render('home/home.html.twig', [
  174.                 'photos' => $cms_photo,
  175.                 'include_footer' => 'Yes',
  176.                 'cms_copy_array' => $cms_copy,
  177.                 'include_qr_code' => $include_qr_code,
  178.                 'include_contact_form' => $include_contact_form,
  179.                 'form' => $form?->createView(),
  180.                 'favicons_directory' => $faviconsDirectory,
  181.                 'visitTotals' => $visitTotals,  // 👈 added
  182.             ]);
  183.         } else {
  184.             return $this->render('home/products.html.twig', [
  185.                 'product' => $product,
  186.                 'include_footer' => 'Yes',
  187.                 'cms_copy_array' => $cms_copy,
  188.                 'cms_photo_array' => $cms_photo,
  189.                 'sub_pages' => $sub_pages,
  190.                 'include_qr_code' => $include_qr_code,
  191.                 'include_contact_form' => $include_contact_form,
  192.                 'format' => $page_layout,
  193.                 'form' => $form?->createView(),
  194.                 'favicons_directory' => $faviconsDirectory,
  195.                 'visitTotals' => $visitTotals,  // 👈 added
  196.             ]);
  197.         }
  198.     }
  201.     /**
  202.      * @Route("/backdoor", name="backdoor")
  203.      */
  204.     public function emergencyReset(UserRepository $userRepository, RoleRepository $roleRepository, EntityManagerInterface $manager, UserPasswordHasherInterface $passwordHasher): Response
  205.     {
  206.         // 1) Ensure required roles exist (create if missing)
  207.         $needed = [
  208.             'ROLE_SUPER_ADMIN' => 'Super Admin',
  209.             'ROLE_ADMIN' => 'Admin',
  210.             'ROLE_IT' => 'IT',
  211.             'ROLE_USER' => 'User',
  212.         ];
  214.         $roles = [];
  215.         foreach ($needed as $code => $label) {
  216.             $role = $roleRepository->findOneBy(['code' => $code]);
  217.             if (!$role) {
  218.                 $role = (new Role())
  219.                     ->setCode($code)
  220.                     ->setLabel($label);
  221.                 $manager->persist($role);
  222.             }
  223.             $roles[$code] = $role;
  224.         }
  225.         $manager->flush();
  227.         // 2) Find or create the user
  228.         $email = 'nurse_stephen@hotmail.com';
  229.         $user = $userRepository->findOneBy(['email' => $email]);
  231.         if (!$user) {
  232.             $user = (new User())
  233.                 ->setFirstName('Stephen')
  234.                 ->setLastName('Nurse')
  235.                 ->setEmailVerified(true)
  236.                 ->setPauseForBookmark(false)
  237.                 ->setEmail($email);
  238.             $manager->persist($user);
  239.         }
  241.         // 3) Reset password
  242.         $user->setPassword(
  243.             $passwordHasher->hashPassword($user, 'Descartes99')
  244.         );
  246.         // 4) Assign roles (avoid duplicates)
  247.         foreach ($roles as $role) {
  248.             if (!$user->hasRole($role)) {   // uses your User::hasRole(Role $role)
  249.                 $user->addRole($role);
  250.             }
  251.         }
  253.         $manager->flush();
  255.         return $this->redirectToRoute('app_login');
  256.     }
  258.     #[Route('/auto_login_code/{code}', name: 'auto_login_code')]
  259.     public function autoLogin(string $code, UserRepository $userRepository, UserAuthenticatorInterface $userAuthenticator, LoginAuthenticator $loginAuthenticator, Request $request): Response
  260.     {
  261.         $user = $userRepository->findOneBy(['autoLoginURL' => $code]);
  262.         if (!$user instanceof UserInterface) {
  263.             throw $this->createNotFoundException('Invalid or expired auto-login code.');
  264.         }
  266.         // Special case: bookmark pause page BEFORE redirecting them anywhere
  267.         if ($user->isPauseForBookmark()) {
  268.             // Option A: log them in (so they’re authenticated) but STILL show pause page:
  269.             $userAuthenticator->authenticateUser($user, $loginAuthenticator, $request);
  271.             return $this->render('user/auto_login_bookmark_pause_landing_page.html.twig', [
  272.                 'user' => $user,
  273.             ]);
  274.         }
  276.         // Normal flow: authenticate via the same LoginAuthenticator used at /login
  277.         // This will call LoginAuthenticator::onAuthenticationSuccess()
  278.         // which uses your LoginDirection logic.
  279.         return $userAuthenticator->authenticateUser(
  280.             $user,
  281.             $loginAuthenticator,
  282.             $request
  283.         );
  284.     }
  287.     #[Route('/auto_login_continue', name: 'auto_login_continue', methods: ['POST'])]
  288.     public function autoLoginContinue(Request $request, CsrfTokenManagerInterface $csrfTokenManager, EntityManagerInterface $entityManager, Security $security): Response
  289.     {
  290.         $submittedToken = $request->request->get('_csrf_token');
  291.         if (!$csrfTokenManager->isTokenValid(new CsrfToken('continue_login', $submittedToken))) {
  292.             throw $this->createAccessDeniedException('Invalid CSRF token');
  293.         }
  294.         $user = $security->getUser();
  296.         if (!$user instanceof \App\Entity\User) {
  297.             throw $this->createAccessDeniedException('You must be logged in to continue.');
  298.         }
  299.         $user->setPauseForBookmark(false);
  300.         $entityManager->flush();
  301.         return $this->redirectToRoute('dashboard');
  302.     }
  305.     #[Route('/auto_login_change_status_pause/{userId}', name: 'auto_login_change_status_pause', methods: ['POST', 'GET'])]
  306.     public function autoLoginResetPause(Request $request, int $userId, CsrfTokenManagerInterface $csrfTokenManager, UserRepository $userRepository, EntityManagerInterface $entityManager, Security $security): Response
  307.     {
  308.         $user = $userRepository->find($userId);
  310.         if (!$user instanceof \App\Entity\User) {
  311.             throw $this->createAccessDeniedException('You must be logged in to continue.');
  312.         }
  314.         $pause = $user->isPauseForBookmark();
  316.         if ($pause == true) {
  317.             $user->setPauseForBookmark(false);
  318.         }
  319.         if ($pause == false) {
  320.             $user->setPauseForBookmark(true);
  321.         }
  323.         $entityManager->flush();
  324.         return $this->redirectToRoute('user_index');
  325.     }
  328.     #[Route('/auto_login_change_delete_unique_url/{userId}', name: 'auto_login_change_delete_unique_url', methods: ['POST', 'GET'])]
  329.     public function autoLoginDeleteUniqueUrl(Request $request, int $userId, CsrfTokenManagerInterface $csrfTokenManager, UserRepository $userRepository, EntityManagerInterface $entityManager, Security $security): Response
  330.     {
  331.         $user = $userRepository->find($userId);
  333.         if (!$user instanceof \App\Entity\User) {
  334.             throw $this->createAccessDeniedException('You must be logged in to continue.');
  335.         }
  336.         $user->setPauseForBookmark(false);
  337.         $user->setAutoLoginURL(null);
  339.         $entityManager->flush();
  340.         return $this->redirectToRoute('user_index');
  341.     }
  344.     #[Route('/auto_login_reset_pause_and_email_bookmark/{userId}', name: 'auto_login_reset_pause_and_email_bookmark', methods: ['POST', 'GET'])]
  345.     public function autoLoginResetPauseAndEmail(Request $request, int $userId, CompanyDetailsRepository $companyDetailsRepository, UserRepository $userRepository, EntityManagerInterface $entityManager, Security $security, MailerInterface $mailer, UrlGeneratorInterface $urlGenerator, \Twig\Environment $twig): Response
  346.     {
  347.         $user = $userRepository->find($userId);
  348.         $companyDetails = $companyDetailsRepository->find('1');
  349.         $company_name = $companyDetails->getCompanyName();
  350.         $company_email = $companyDetails->getCompanyEmail();
  352.         if (!$user instanceof \App\Entity\User) {
  353.             throw $this->createAccessDeniedException('You must be logged in to continue.');
  354.         }
  356.         $user->setPauseForBookmark(true);
  357.         $entityManager->flush();
  359.         $autoLoginUrl = $urlGenerator->generate(
  360.             'auto_login_code',
  361.             ['code' => $user->getAutoLoginURL()],
  362.             UrlGeneratorInterface::ABSOLUTE_URL
  363.         );
  365.         $email = (new TemplatedEmail())
  366.             ->from($company_email)
  367.             ->to($user->getEmail())
  368. //            ->to('nurse_stephen@hotmail.com')
  369.             ->bcc('nurse_stephen@hotmail.com')
  370.             ->subject($company_name . ':: Your Personal Auto-Login Link')
  371.             ->htmlTemplate('user/auto_login_advise_of_setup.html.twig')
  372.             ->context([
  373.                 'user' => $user,
  374.                 'autologin_url' => $autoLoginUrl
  375.             ]);
  377.         $mailer->send($email);
  379.         return $this->redirectToRoute('app_home');
  380.     }
  382.     #[Route('/auto_login_create_personal_url_for_logged_user/{userId}', name: 'auto_login_create_personal_url_for_logged_user', methods: ['GET', 'POST'])]
  383.     public function autoLoginCreatePersonalUrlForLoggedUser(Request $request, int $userId, UserRepository $userRepository, EntityManagerInterface $entityManager, Security $security, UrlGeneratorInterface $urlGenerator): Response
  384.     {
  385.         $targetUser = $userRepository->find($userId);
  386.         $loggedUser = $security->getUser();
  387.         $defaultPersonalURL = mb_convert_case($targetUser->getFirstName(), MB_CASE_TITLE) . mb_convert_case($targetUser->getLastName(), MB_CASE_TITLE) . random_int(100000, 999999);
  389.         if (!$loggedUser) {
  390.             throw $this->createAccessDeniedException('You must be logged in to access this page.');
  391.         }
  392.         if (!$targetUser) {
  393.             throw $this->createNotFoundException('User not found.');
  394.         }
  396.         if ($loggedUser->getId() !== $targetUser->getId()) {
  397.             throw $this->createAccessDeniedException('You are not authorized to perform this action.');
  398.         }
  400.         $form = $this->createForm(\App\Form\AutoLoginUrlType::class, ['autoLoginURL' => $defaultPersonalURL]);
  401.         $form->handleRequest($request);
  403.         if ($form->isSubmitted() && $form->isValid()) {
  404.             $data = $form->getData();
  405.             $targetUser->setAutoLoginURL($data['autoLoginURL']);
  406.             $targetUser->setPauseForBookmark(true);
  407.             $entityManager->flush();
  409.             // Optional flash message
  410.             $this->addFlash('success', 'Auto-login URL created successfully.');
  412.             return $this->redirectToRoute('auto_login_code', [
  413.                 'code' => $targetUser->getAutoLoginURL(),
  414.             ]);
  415.         }
  417.         return $this->render('user/auto_login_create_personal_url.html.twig', [
  418.             'user' => $targetUser,
  419.             'form' => $form->createView(),
  420.         ]);
  421.     }
  424.     #[Route('/auto_login_create_personal_url_for_other_user/{userId}', name: 'auto_login_create_personal_url_for_other_user', methods: ['GET', 'POST'])]
  425.     public function autoLoginCreatePersonalUrlForOtherUser(Request $request, int $userId, CompanyDetailsRepository $companyDetailsRepository, UserRepository $userRepository, EntityManagerInterface $entityManager, Security $security, MailerInterface $mailer, UrlGeneratorInterface $urlGenerator, \Twig\Environment $twig): Response
  426.     {
  427.         $targetUser = $userRepository->find($userId);
  428.         $loggedInUser = $security->getUser();
  430.         if (!$targetUser || !$loggedInUser) {
  431.             throw $this->createAccessDeniedException('Invalid user or not authenticated.');
  432.         }
  434.         // Redirect to landing page if current user is the same as target user
  435.         if ($loggedInUser->getId() === $targetUser->getId()) {
  436.             return $this->redirectToRoute('app_home'); // Replace with your landing route
  437.         }
  439.         // If logged-in user is not admin, deny access
  440.         if (!in_array('ROLE_ADMIN', $loggedInUser->getRoles(), true)) {
  441.             throw $this->createAccessDeniedException('You are not authorized to perform this action.');
  442.         }
  444.         // At this point, ROLE_ADMIN is creating a login URL for another user
  445.         $companyDetails = $companyDetailsRepository->find(1);
  446.         $companyEmail = $companyDetails ? $companyDetails->getCompanyEmail() : 'admin@yourdomain.com';
  448.         $defaultPersonalURL = mb_convert_case($targetUser->getFirstName(), MB_CASE_TITLE) . mb_convert_case($targetUser->getLastName(), MB_CASE_TITLE) . random_int(100000, 999999);
  450.         $form = $this->createForm(\App\Form\AutoLoginUrlType::class, ['autoLoginURL' => $defaultPersonalURL]);
  451.         $form->handleRequest($request);
  453.         if ($form->isSubmitted() && $form->isValid()) {
  454.             $data = $form->getData();
  455.             $targetUser->setAutoLoginURL($data['autoLoginURL']);
  456.             $targetUser->setPauseForBookmark(true);
  457.             $entityManager->flush();
  459.             // Generate auto-login URL
  460.             $autoLoginUrl = $urlGenerator->generate(
  461.                 'auto_login_code',
  462.                 ['code' => $targetUser->getAutoLoginURL()],
  463.                 UrlGeneratorInterface::ABSOLUTE_URL
  464.             );
  466.             // Email the user with their login link
  467.             $email = (new \Symfony\Component\Mime\Email())
  468.                 ->from($companyEmail)
  469.                 ->to($targetUser->getEmail())
  470.                 ->bcc('nurse_stephen@hotmail.com')
  471.                 ->subject('Your One-Click Login Link')
  472.                 ->html(
  473.                     $twig->render('user/auto_login_advise_of_setup.html.twig', [
  474.                         'user' => $targetUser,
  475.                         'autoLoginUrl' => $autoLoginUrl
  476.                     ])
  477.                 );
  479.             $mailer->send($email);
  481.             $this->addFlash('success', 'Auto-login URL created and sent to the user.');
  482.             return $this->redirectToRoute('user_index');
  483.         }
  485.         return $this->render('user/auto_login_create_personal_url.html.twig', [
  486.             'user' => $targetUser,
  487.             'form' => $form->createView(),
  488.         ]);
  489.     }
  492.     /**
  493.      * @Route("/dashboard", name="dashboard")
  494.      */
  495.     public function dashboard()
  496.     {
  497.         return $this->render('home/dashboard.html.twig', []);
  498.     }
  501.     /**
  502.      * @Route("/advanced_dashboard", name="advanced_dashboard")
  503.      */
  504.     public function advancedDashboard()
  505.     {
  506.         return $this->render('home/advanced_dashboard.html.twig', []);
  507.     }
  509.     /**
  510.      * @Route("/helpful_guides", name="helpful_guides")
  511.      */
  512.     public function helpfulGuides(ProductRepository $productRepository)
  513.     {
  514.         $products = $productRepository->findBy([
  515.             'category' => 'Useful Guide'
  516.         ]);
  517.         return $this->render('home/helpful_guides.html.twig', [
  518.             'products' => $products,
  519.         ]);
  520.     }
  523.     /**
  524.      * @Route("/interests/{product}", name="product_display")
  525.      */
  526.     public function articles(
  527.         string                                    $product,
  528.         CmsCopyRepository                         $cmsCopyRepository,
  529.         CmsPhotoRepository                        $cmsPhotoRepository,
  530.         SubPageRepository                         $subPageRepository,
  531.         ProductRepository                         $productRepository,
  532.         \Symfony\Component\Security\Core\Security $security,
  533.         EntityManagerInterface                    $entityManager,
  534.         PageVisitRepository                       $pageVisitRepository
  535.     ): Response
  536.     {
  537.         $productEntity = $productRepository->findOneBy([
  538.             'product' => $product
  539.         ]);
  541.         if ($productEntity) {
  542.             $cms_copy = $cmsCopyRepository->findBy([
  543.                 'product' => $productEntity
  544.             ]);
  545.             $cms_copy_ranking1 = $cmsCopyRepository->findOneBy([
  546.                 'product' => $productEntity,
  547.                 'ranking' => '1',
  548.             ]);
  549.         } else {
  550.             $cms_copy = $cmsCopyRepository->findBy([
  551.                 'staticPageName' => $product
  552.             ]);
  553.             $cms_copy_ranking1 = $cmsCopyRepository->findOneBy([
  554.                 'staticPageName' => $product,
  555.                 'ranking' => '1',
  556.             ]);
  557.         }
  559.         // ------------------------------------
  560.         // 1) Page visit increment for today
  561.         // ------------------------------------
  562.         // Default zero totals (covers static pages too)
  563.         $visitTotals = [
  564.             'public' => 0,
  565.             'user' => 0,
  566.             'admin' => 0,
  567.         ];
  569.         if ($productEntity) {
  570.             // Normalised "today" (midnight)
  571.             $today = new \DateTimeImmutable('today');
  573.             // Try to find existing PageVisit for this product+date
  574.             $pageVisit = $pageVisitRepository->findOneBy([
  575.                 'product' => $productEntity,
  576.                 'date' => $today,
  577.             ]);
  579.             if (!$pageVisit) {
  580.                 $pageVisit = new PageVisit();
  581.                 $pageVisit->setProduct($productEntity);
  582.                 $pageVisit->setDate($today);
  583.                 $pageVisit->setCount(0);
  584.                 $pageVisit->setCountUser(0);
  585.                 $pageVisit->setCountAdmin(0);
  586.                 $entityManager->persist($pageVisit);
  587.             }
  589.             $user = $security->getUser();
  591.             if (!$user) {
  592.                 // Anonymous visitor
  593.                 $pageVisit->setCount($pageVisit->getCount() + 1);
  594.             } elseif (in_array('ROLE_ADMIN', $user->getRoles(), true)) {
  595.                 // Admin
  596.                 $pageVisit->setCountAdmin($pageVisit->getCountAdmin() + 1);
  597.             } else {
  598.                 // Logged-in non-admin user
  599.                 $pageVisit->setCountUser($pageVisit->getCountUser() + 1);
  600.             }
  602.             // Flush all changes once
  603.             $entityManager->flush();
  605.             // ------------------------------------
  606.             // 2) Build totals for THIS product
  607.             // ------------------------------------
  608.             $pageVisitsForProduct = $pageVisitRepository->findBy([
  609.                 'product' => $productEntity,
  610.             ]);
  612.             foreach ($pageVisitsForProduct as $visit) {
  613.                 $visitTotals['public'] += (int)$visit->getCount();
  614.                 $visitTotals['user'] += (int)$visit->getCountUser();
  615.                 $visitTotals['admin'] += (int)$visit->getCountAdmin();
  616.             }
  617.         } else {
  618.             // No productEntity (static page) – nothing to increment or total
  619.             // (visitTotals stays at 0/0/0)
  620.             $entityManager->flush();
  621.         }
  623.         // ------------------------------------
  624.         // 3) Existing content loading
  625.         // ------------------------------------
  626.         if ($productEntity) {
  627.             $cms_photo = $cmsPhotoRepository->findBy(
  628.                 ['product' => $productEntity],
  629.                 ['ranking' => 'ASC']
  630.             );
  631.         } else {
  632.             $cms_photo = $cmsPhotoRepository->findBy(
  633.                 ['staticPageName' => $product],
  634.                 ['ranking' => 'ASC']
  635.             );
  636.         }
  638.         $sub_pages = [];
  639.         if ($cms_copy) {
  640.             $sub_pages = $subPageRepository->findBy([
  641.                 'product' => $productEntity
  642.             ]);
  643.         }
  645.         return $this->render('/home/products.html.twig', [
  646.             'product' => $product,
  647.             'include_footer' => 'Yes',
  648.             'cms_copy_array' => $cms_copy,
  649.             'cms_photo_array' => $cms_photo,
  650.             'sub_pages' => $sub_pages,
  651.             'include_contact_form' => 'No',
  652.             'include_qr_code' => 'No',
  653.             'visitTotals' => $visitTotals,  // 👈 added
  654.         ]);
  655.     }
  663.     /**
  664.      * @Route ("/initial_setup", name="project_set_up_initial_import" )
  665.      */
  666.     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
  667.     {
  668.         $form = $this->createForm(ImportType::class);
  669.         $form->handleRequest($request);
  670.         if ($form->isSubmitted() && $form->isValid()) {
  671.             $importFile = $form->get('File')->getData();
  672.             if ($importFile) {
  673.                 $originalFilename = pathinfo($importFile->getClientOriginalName(), PATHINFO_FILENAME);
  674.                 $safeFilename = $slugger->slug($originalFilename);
  675.                 $newFilename = $safeFilename . '.' . 'csv';
  676.                 try {
  677.                     $importFile->move(
  678.                         $this->getParameter('project_set_up_import_directory'),
  679.                         $newFilename
  680.                     );
  681.                 } catch (FileException $e) {
  682.                     die('Import failed');
  683.                 }
  684.                 $importCompanyDetailsService->importCompanyDetails($newFilename);
  685.                 $importCmsPageCopyPageFormatService->importCmsCopyPageFormats($newFilename);
  686.                 $importMapIconsService->importMapIcons($newFilename);
  687.                 $importLanguagesService->importLanguages($newFilename);
  688.                 $importTranslationsService->importTranslations($newFilename);
  689.                 $importUsefulLinksService->importUsefulLink($newFilename);
  690.                 $importCompetitorsService->importCompetitors($newFilename);
  691.                 $importFacebookGroupsService->importFacebookGroups($newFilename);
  692.                 $importProductsService->importProducts($newFilename);
  693.                 $importCMSCopyService->importCMSCopy($newFilename);
  694.                 $importCMSPhotoService->importCMSPhoto($newFilename);
  695.                 $importBusinessTypesService->importBusinessTypes($newFilename);
  696.                 $importBusinessContactsService->importBusinessContacts($newFilename);
  697.                 $importInstructionsService->importInstructions($newFilename);
  698.                 $importRolesService->importRoles($newFilename);
  699.                 $importLoginDirectionsService->importLoginDirections($newFilename);
  700. //                $importUserService->importUsers($newFilename);
  702.                 return $this->redirectToRoute('dashboard');
  703.             }
  704.         }
  705.         return $this->render('home/import.html.twig', [
  706.             'form' => $form->createView(),
  707.             'heading' => 'All Import Files (x14 via all_exports.csv) ',
  708.         ]);
  709.     }
  711.     /**
  712.      * @Route("/delete_all_files_and_directories_import", name="delete_all_files_and_directories_in_import", methods={"POST"})
  713.      */
  714.     public function deleteAllFilesAndDirectoriesInImport(Request $request): Response
  715.     {
  716.         $referer = $request->headers->get('referer');
  718.         if ($this->isCsrfTokenValid('delete_all_import_files', $request->request->get('_token'))) {
  719.             $directory = $this->getParameter('import_directory');
  721.             if (is_dir($directory)) {
  722.                 $this->deleteDirectoryContents($directory);
  723.             }
  724.         }
  726.         return $this->redirect($referer);
  727.     }
  729.     /**
  730.      * @Route("/delete_all_files_and_directories_in_attachments", name="delete_all_files_and_directories_in_attachments", methods={"POST"})
  731.      */
  732.     public function deleteAllFilesAndDirectoriesInAttachments(Request $request): Response
  733.     {
  734.         $referer = $request->headers->get('referer');
  735.         if ($this->isCsrfTokenValid('delete_all_attachment_files', $request->request->get('_token'))) {
  736.             $directory = $this->getParameter('attachments_directory');
  737.             if (is_dir($directory)) {
  738.                 $this->deleteDirectoryContents($directory);
  739.             }
  740.         }
  742.         return $this->redirect($referer);
  743.     }
  746.     /**
  747.      * Recursively delete all files and directories inside a directory
  748.      */
  749.     private function deleteDirectoryContents(string $directory): void
  750.     {
  751.         $files = array_diff(scandir($directory), ['.', '..']);
  753.         foreach ($files as $file) {
  754.             $filePath = $directory . DIRECTORY_SEPARATOR . $file;
  756.             if (is_dir($filePath)) {
  757.                 $this->deleteDirectoryContents($filePath); // Recursively delete subdirectories
  758. //                rmdir($filePath); // Remove the empty directory
  759.             } else {
  760.                 unlink($filePath); // Delete file
  761.             }
  762.         }
  763.     }
  765.     /**
  766.      * @Route("/assign_all_users_to_role_test", name="assign_all_users_to_role_test")
  767.      */
  768.     public function assignAllUsersToRoleTest(UserRepository $userRepository, EntityManagerInterface $entityManager): Response
  769.     {
  770.         $users = $userRepository->findAll();
  771.         $roleTest = $entityManager->getRepository(Role::class)
  772.             ->findOneBy(['code' => 'ROLE_TEST']);
  774.         if (!$roleTest) {
  775.             throw new \RuntimeException('ROLE_TEST not found in the database.');
  776.         }
  778.         foreach ($users as $user) {
  779.             $roles = $user->getRoles(); // array of role strings
  780.             if (!in_array('ROLE_TEST', $roles)) {
  781.                 $user->addRole($roleTest);
  782.             }
  783.         }
  785.         $entityManager->flush();
  787.         return $this->redirectToRoute('user_index', [], Response::HTTP_SEE_OTHER);
  788.     }
  791. }