src/Controller/MainController.php line 161

  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\HttpFoundation\Response;
  7. use Symfony\Component\Routing\Annotation\Route;
  8. use Knp\Component\Pager\PaginatorInterface;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use App\Repository\BusinessInformationRepository;
  11. use App\Repository\BannerRepository;
  12. use App\Repository\LogoPARepository;
  13. use App\Repository\BlogRepository;
  14. use App\Repository\BusinessCategoriesRepository;
  15. use App\Repository\BusinessCategoryGroupRepository;
  16. use App\Repository\CategoryBannerVRepository;
  17. use App\Entity\Company;
  18. use App\Repository\CompanyRepository;
  19. //use App\Repository\CategoryBannerVRepository;
  20. use App\Form\CompanyType;
  21. use Doctrine\Persistence\ManagerRegistry as PersistenceManagerRegistry;
  23. //use Doctrine\ORM\EntityManagerInterface;
  24. use Doctrine\ORM\EntityManagerInterface;
  26. use App\Service\SeoBusinessGenerator;
  30. class MainController extends AbstractController
  31. {
  32. #[Route('/', name: 'app_main')]
  33. public function index(Request $request, BusinessInformationRepository $repository, BlogRepository $blog_repository, LogoPARepository $logo_repository, BannerRepository $banner_repository, PaginatorInterface $paginator): Response
  34. {
  35. // Récupération des statistiques dynamiques
  36. $totalBusinesses = $repository->countAllBusinesses();
  37. $totalWilayas = $repository->countDistinctWilayas();
  39. // 🌟 Récupération du chiffre exact depuis le fichier .env
  40. $googleClicks = $_ENV['MARKETING_GOOGLE_CLICKS'] ?? 18133;
  41. //show banner
  42. $banner= $banner_repository->findBy( ['active' => true]);
  43. //client a la une
  44. $business=$paginator->paginate($repository->findBy(
  45. ['alaune' => true]
  47. ),
  48. $request->query->getInt('page', 1),
  49. 20);
  50. //Logo Page d'Accueil
  51. $logo= $logo_repository->findBy( ['active' => true]);
  52. //Blog Page d'Accueil
  53. $blog= $blog_repository->findBy( ['active' => true]);
  55. return $this->render('main/index.html.twig',[
  56. 'total_businesses' => $totalBusinesses,
  57. 'total_wilayas' => $totalWilayas,
  58. 'google_clicks' => $googleClicks,
  59. "business"=>$business,
  60. "banners"=>$banner,
  61. "logos"=>$logo,
  62. "blogs"=>$blog,
  65. ]);
  66. }
  67. // Fonction ajouter entreprise
  69. #[Route('/ajouter', name: 'ajouter')]
  70. public function ajouter(Request $request, PersistenceManagerRegistry $doctrine) :Response
  72. {
  73. $em = $doctrine->getManager();
  74. $company=new Company();
  75. //$email=$company->getEmail();
  77. $form = $this->createForm(CompanyType::class, $company);
  78. $form->handleRequest($request);
  79. if ($form->isSubmitted() && $form->isValid()){
  80. $em->persist($company);
  81. $em->flush();
  82. // send mail
  84. $this->addFlash('success', 'Ajout avec succes');
  85. return $this->redirectToRoute('ajouter');
  86. }
  87. return $this->render('main/ajouter_entreprise.html.twig',[
  88. 'company'=>$company,
  89. 'form'=>$form->createView()
  90. ]);
  91. }
  93. //SHOW CUSTMER DETAIL
  95. #[Route('/c/{id}-{slug}', name: 'customer.show')]
  96. public function show($id, $slug,Request $request, BusinessInformationRepository $repository, SeoBusinessGenerator $seo) :Response
  97. {
  99. $business = $repository->find($id);
  101. // dd($business);
  102. $seoContent = $seo->generateSeoContent($business);
  106. return $this->render('main/showcustomerdetail.html.twig',[
  107. 'business' => $business ,
  108. 'seoContent' => $seoContent,
  111. ]);
  112. //dd($seoContent);
  113. }
  116. //Recherche par secteur d'activité
  118. // Recherche par secteur d'activité
  119. #[Route('/s/{id}-{slug}', name: 'customer.secteur')]
  120. public function SecteurActivity(
  121. PaginatorInterface $paginator,
  122. Request $request,
  123. $id,
  124. $slug,
  125. BusinessCategoriesRepository $businesscat,
  126. BusinessCategoryGroupRepository $secteur,
  127. CategoryBannerVRepository $banner_repository
  128. ): Response {
  130. $sec = $secteur->find($id);
  131. $banner = $banner_repository->find($id);
  132. $group_id = $id;
  134. // 1. Récupérer toutes les rubriques liées à ce secteur pour la grille interactive
  135. // On les trie par nom de A à Z
  136. $rubriques = $businesscat->findBy(
  137. ['group_id' => $group_id],
  138. ['business_category_name' => 'ASC'] // Ajustez 'nom' selon le nom réel de votre colonne dans l'entité BusinessCategories
  139. );
  141. // 2. Votre pagination actuelle (Liste des clients du secteur)
  142. $business = $paginator->paginate(
  143. $businesscat->findBy(
  144. ['group_id' => $group_id],
  145. ['statut' => 'DESC']
  146. ),
  147. $request->query->getInt('page', 1),
  148. 45
  149. );
  151. // 3. Envoi des variables au template existant
  152. return $this->render('main/showcustomersecteur.html.twig', [
  153. "business" => $business,
  154. "banner" => $banner,
  155. "secteur" => $sec,
  156. "rubriques" => $rubriques, // Nouvelle variable passée à Twig
  157. ]);
  158. }
  161. // Liste client de la rubriques
  164. #[Route('/detail/{id}-{slug}', name: 'customer.detail.rubrique') ]
  165. public function BusinessDetailRubrique(PaginatorInterface $paginator, Request $request, $id, $slug, BusinessInformationRepository $repository, BusinessCategoriesRepository $repository2, CategoryBannerVRepository $banner_v ) :Response
  166. {
  167. //$sec_id=$idsec;
  168. $id_sec = $request->query->get('idsec'); // idsec Récupère la valeur après le '?'
  169. // dd($id_sec); // Ne sera plus null
  170. // dd($sec_id);
  171. $category=$id;
  172. $category = (string)$id;
  173. $category_name=$slug;
  174. //show seo
  175. $seo= $repository2->findBy( ['id' => $id]);
  176. $banner_rub= $banner_v->findBy( ['businessCategoryGroup' => $id_sec]);
  177. //dd($banner_rub);
  178. // $article=$seo;
  179. //$banner=$bv;
  180. // dd($seo);
  181. // echo $category;
  182. // $business = $this->repository->findCategory($category);
  183. // $repository = $this->getDoctrine()->getRepository(BusinessInformation::class);
  184. /* $business=$paginator->paginate($repository->findBy(
  185. ['categories' => $category] ),
  186. $request->query->getInt('page', 1),
  187. 9);
  188. */
  189. $business=$paginator->paginate($repository->findCategory($category),
  190. $request->query->getInt('page', 1),
  191. 45);
  193. // dump($business);
  194. return $this->render('main/showcustomers.html.twig',[
  195. "business"=>$business,
  196. "category_name" =>$category_name,
  197. "article" =>$seo,
  198. "bannerv"=>$banner_rub
  200. ] );
  202. // return new Response( '<html><body>Lucky number: '.$category.'</body></html>' );
  203. }
  206. //Static Routes
  208. #[Route('/qui-sommes-nous', name: 'app_about')]
  209. public function about(): Response
  210. {
  211. return $this->render('main/about.html.twig');
  212. }
  214. #[Route('/nos-offres', name: 'app_nos_offres')]
  215. public function offre(): Response
  216. {
  217. return $this->render('main/offre.html.twig');
  218. }
  220. #[Route('/appel-offres', name: 'app_appel_offres')]
  221. public function appel(): Response
  222. {
  223. return $this->render('main/appel_offre.html.twig');
  224. }
  226. #[Route('/tout-secteur', name: 'app_secteur')]
  227. public function secteur(): Response
  228. {
  229. return $this->render('main/secteurs.html.twig');
  230. }
  231. #[Route('/blogs', name: 'app_blogs')]
  232. public function blog(BlogRepository $blog_repository): Response
  233. {
  234. $blog=$blog_repository->findAll();
  235. return $this->render('main/blogs.html.twig',
  236. [
  237. "blogs"=>$blog
  238. ]);
  239. }
  240. }