src/Controller/Frontend/VideoController.php line 18

  1. <?php
  3. namespace App\Controller\Frontend;
  5. use App\Paging;
  6. use App\Repository\ActorRepository;
  7. use App\Repository\StudioRepository;
  8. use App\Repository\TagCategoryRepository;
  9. use App\Repository\TagRepository;
  10. use App\Repository\VideoRepository;
  11. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Component\Routing\Annotation\Route;
  15. class VideoController extends AbstractController
  16. {
  17.     #[Route('/', name: 'video.index')]
  18.     public function index(
  19.         Request $request,
  20.         VideoRepository $repo,
  21.         StudioRepository $repoStudio,
  22.         ActorRepository $repoActor,
  23.         TagCategoryRepository $repoTagCat,
  24.         TagRepository $repoTag,
  25.     )
  26.     {
  27.         $page = (int)$request->query->get('page');
  28.         if ($page === 0) {
  29.             $page = 1;
  30.         }
  32.         $search           = $request->query->get('search');
  33.         $selectedStudioId = $request->query->get('studio');
  34.         $selectedActorId  = $request->query->get('actor');
  35.         $selectedTagIds   = $request->query->get('tags');
  37.         $selectedTagIds = ($selectedTagIds) ? explode(',', $selectedTagIds) : [];
  39.         $query = $repo->getQueryAllWithImage($selectedStudioId, $selectedActorId, $selectedTagIds, $search);
  40.         $count = $repo->countWithNativeQuery($query);
  42.         $paging = new Paging($page, 9);
  43.         $paging->setNumRecords($count);
  45.         $query->setSQL($query->getSQL() . $paging->GetSQL());
  47.         $videos = $query->getResult();
  49.         $selectedActors = ($selectedActorId) ? $repoActor->findSelected([$selectedActorId]) : [];
  50.         $selectedStudios = ($selectedStudioId) ? $repoStudio->findSelected([$selectedStudioId]) : [];
  52.         $urlNextPage = null;
  53.         if ($paging->getNextPage()) {
  54.             $urlNextPage = $this->generateUrl('video.index');
  55.             $urlNextPage .= '?page=' . $paging->getNextPage();
  56.             if ($selectedStudioId) {
  57.                 $urlNextPage .= '&studio='.$selectedStudioId;
  58.             }
  59.             if ($selectedActorId) {
  60.                 $urlNextPage .= '&actor='.$selectedActorId;
  61.             }
  62.             if (count($selectedTagIds)) {
  63.                 $urlNextPage .= '&tags='.implode(',', $selectedTagIds);
  64.             }
  65.             if ($search) {
  66.                 $urlNextPage .= '&search='.urlencode($search);
  67.             }
  68.         }
  70.         $categories = $repoTagCat->findAllIndexed();
  71.         $tags = $repoTag->findAllGroupedByCategory();
  73. // echo '<pre>';
  74. //dump($categories);
  75. //dd($tags);
  78.         return $this->render('Frontend/Video/Index.twig', [
  79.             'videos'  => $videos,
  80.             'selectedActors' => $selectedActors,
  81.             'selectedStudios' => $selectedStudios,
  82.             'selectedTagIds' => $selectedTagIds,
  83.             'search' => $search,
  84.             'paging' => $paging,
  85.             'url_next_page' => $urlNextPage,
  86.             'categories' => $categories,
  87.             'tags' => $tags,
  88.         ]);
  89.     }
  91.     #[Route('/video/{id}', name: 'video.show')]
  92.     public function show($id, VideoRepository $repo)
  93.     {
  94.         $video = $repo->find($id);
  96.         return $this->render('Frontend/Video/Show.twig', [
  97.             'video' => $video,
  98.         ]);
  99.     }
  100. }