render("dashboard/index.html.twig"); } #[Route('/jsdashboard', name: 'app_json_dashboard')] public function jsonDashboard( FilmRepository $filmRepository, GenreRepository $genreRepository, RealisateurRepository $realisateurRepository, MediaVideoRepository $mediaVideoRepository, CommentaireRepository $commentaireRepository, UserRepository $userRepository, Security $security ) : JsonResponse { /** @var \App\Entity\User $user */ $user = $security->getUser(); $userId = $user->getId(); $nbComsAll = $commentaireRepository->count([]); $nbComsUser = $commentaireRepository->nbComsByUser($userId); $nbFilmsAll = $filmRepository->count([]); $nbFilmsSeenByUser = $filmRepository->nbFilmSeenBy($userId); $nbFilmsToSeeByUser = $filmRepository->nbFilmToSeeBy($userId); $nbGenres = $genreRepository->count([]); $nbrealisateurs = $realisateurRepository->count([]); $nbUsers = $userRepository->count([]); $nbMediaVideos = $mediaVideoRepository->count([]); $tableau = [ 'commentaires' => [ 'all' => $nbComsAll, 'user' => $nbComsUser ], 'films' => [ 'all' => $nbFilmsAll, 'seen-by-user' => $nbFilmsSeenByUser, 'to-see-by-user' => $nbFilmsToSeeByUser ], 'genres' => $nbGenres, 'realisateurs' => $nbrealisateurs, 'users' => $nbUsers, 'medias' => $nbMediaVideos ]; return new JsonResponse($tableau, 200, [], false); } }