From 8f43d48714a7346d0730145a8ab209c0ff8bc8fe Mon Sep 17 00:00:00 2001 From: Developer Date: Sat, 27 Jun 2026 03:27:06 +0200 Subject: feat: add /genres page listing all genres with movie counts - Add CinemaController::genres() and ::genre($name) methods - /genres shows all genres with movie counts (like /popular/topics) - /genres/{genre} shows movies filtered by that genre with pagination - Genre badges on cinema_show page now link to /genres/{genre} - Add Genres link to navbar next to Cinema --- app/Http/Controllers/CinemaController.php | 65 +++++++++++++ resources/views/cinema_show.blade.php | 2 +- resources/views/genre_movies.blade.php | 156 ++++++++++++++++++++++++++++++ resources/views/genres.blade.php | 42 ++++++++ resources/views/layouts/app.blade.php | 3 + routes/web.php | 2 + 6 files changed, 269 insertions(+), 1 deletion(-) create mode 100644 resources/views/genre_movies.blade.php create mode 100644 resources/views/genres.blade.php diff --git a/app/Http/Controllers/CinemaController.php b/app/Http/Controllers/CinemaController.php index c433eea..a526830 100644 --- a/app/Http/Controllers/CinemaController.php +++ b/app/Http/Controllers/CinemaController.php @@ -80,6 +80,71 @@ class CinemaController extends Controller ]); } + public function genres() + { + $genres = DB::connection('cinema') + ->table('genre') + ->select('genre.name', DB::raw('COUNT(imdb_genre.imdb_id) as count')) + ->join('imdb_genre', 'imdb_genre.genre_id', '=', 'genre.id') + ->join('imdb', 'imdb.id', '=', 'imdb_genre.imdb_id') + ->whereNotNull('imdb.primary_title') + ->whereNotNull('imdb.wiki_article') + ->where('imdb.title_type', 'movie') + ->groupBy('genre.name') + ->orderBy('count', 'desc') + ->get(); + + return view('genres', ['genres' => $genres]); + } + + public function genre($name) + { + $genre = DB::connection('cinema') + ->table('genre') + ->where('name', $name) + ->first(); + + if (! $genre) { + abort(404); + } + + $movies = DB::connection('cinema') + ->table('imdb') + ->select( + 'imdb.id', + 'imdb.imdb_id', + 'imdb.primary_title', + 'imdb.original_title', + 'imdb.start_year', + 'imdb.average_rating', + 'imdb.num_votes', + 'imdb.synopsis', + 'imdb.poster_url', + 'imdb.title_type', + 'imdb.runtime_minutes' + ) + ->join('imdb_genre', 'imdb_genre.imdb_id', '=', 'imdb.id') + ->join('genre', 'genre.id', '=', 'imdb_genre.genre_id') + ->where('genre.name', $name) + ->whereNotNull('imdb.primary_title') + ->whereNotNull('imdb.wiki_article') + ->where('imdb.title_type', 'movie') + ->orderBy('imdb.average_rating', 'desc') + ->simplePaginate(12); + + $count = DB::connection('cinema') + ->table('imdb') + ->join('imdb_genre', 'imdb_genre.imdb_id', '=', 'imdb.id') + ->join('genre', 'genre.id', '=', 'imdb_genre.genre_id') + ->where('genre.name', $name) + ->whereNotNull('imdb.primary_title') + ->whereNotNull('imdb.wiki_article') + ->where('imdb.title_type', 'movie') + ->count(); + + return view('genre_movies', ['movies' => $movies, 'count' => $count, 'genre_name' => $name]); + } + public function search(Request $request) { $query = $request->input('q', ''); diff --git a/resources/views/cinema_show.blade.php b/resources/views/cinema_show.blade.php index 5f849e3..8379a59 100644 --- a/resources/views/cinema_show.blade.php +++ b/resources/views/cinema_show.blade.php @@ -95,7 +95,7 @@ @if ( ! empty($genres) )
@foreach( $genres as $genre ) - {{ $genre }} + {{ $genre }} @endforeach
@endif diff --git a/resources/views/genre_movies.blade.php b/resources/views/genre_movies.blade.php new file mode 100644 index 0000000..05f8ca3 --- /dev/null +++ b/resources/views/genre_movies.blade.php @@ -0,0 +1,156 @@ +@extends('layouts.app') + +@section('styles') +@include ('layouts.footer-style') + +html { + height: inherit; +} + +.movie-grid { + display: flex; + flex-wrap: wrap; + gap: 20px; + margin-top: 20px; +} + +.movie-card { + flex: 1 1 280px; + min-width: 250px; + max-width: 320px; +} + +.movie-card .poster { + width: 100%; + aspect-ratio: 2 / 3; + object-fit: cover; + background-color: #333; + border-radius: 4px 4px 0 0; +} + +.movie-card .year { + color: #868e96; + font-size: 0.85rem; +} + +.movie-card .rating { + font-size: 0.9rem; + color: #868e96; +} + +.movie-card .synopsis { + font-size: 0.875rem; + color: #6c757d; + display: -webkit-box; + -webkit-line-clamp: 4; + -webkit-box-orient: vertical; + overflow: hidden; +} + +.movie-card h1 { + font-size: 1rem; + padding: 10px 12px 4px; + margin: 0; +} + +.movie-card h1 a { + color: inherit; + text-decoration: none; +} + +.movie-card h1 a:hover { + text-decoration: underline; +} + +.movie-card .card-body { + padding: 0 12px 12px; +} + +.no-poster { + display: flex; + align-items: center; + justify-content: center; + width: 100%; + aspect-ratio: 2 / 3; + background-color: #495057; + color: #adb5bd; + font-size: 3rem; + border-radius: 4px 4px 0 0; +} + +@endsection + +@section('content') +
+
+ +
+

+ Genre: {{ $genre_name }} + @if ( "1" != $movies->currentPage() ) + (Page {{ $movies->currentPage() }}) + @endif +

+
+

+ Browse {{ number_format($count) }} movies in the {{ $genre_name }} genre. +

+ All Genres +
+
+ + @if ( 0 != $movies->count() ) +
+ @foreach( $movies as $movie) +
+ + @if ( ! is_null($movie->poster_url) ) + {{ $movie->primary_title }} poster + @else +
🎬
+ @endif + +

+ + {{ $movie->primary_title }} + +

+
+
+ @if ( ! is_null($movie->start_year) ) + {{ $movie->start_year }} + @endif + @if ( ! is_null($movie->runtime_minutes) ) + @if ( ! is_null($movie->start_year) ) + ยท + @endif + {{ $movie->runtime_minutes }} min + @endif +
+
+ @if ( ! is_null($movie->average_rating) ) + ⭐ {{ number_format($movie->average_rating, 1) }} + @if ( ! is_null($movie->num_votes) ) + ({{ number_format($movie->num_votes) }} votes) + @endif + @endif +
+ @if ( ! empty($movie->synopsis) ) +

+ {{ strip_tags($movie->synopsis) }} +

+ @endif +
+
+ @endforeach +
+ +
+ {{ $movies->appends(Request::input())->links() }} + @endif +
+@endsection + +@section('footer') + @include ('layouts.footer') +@endsection diff --git a/resources/views/genres.blade.php b/resources/views/genres.blade.php new file mode 100644 index 0000000..1fff8d2 --- /dev/null +++ b/resources/views/genres.blade.php @@ -0,0 +1,42 @@ +@extends('layouts.app') + +@section('styles') +@include ('layouts.footer-style') +html { + height: inherit; +} +@endsection + +@section('content') + +
+ +
+
+

+ Genres +

+
+

+ Browse movies by genre. Each genre shows all movies that have been categorized. +

+
+
+
+ +
+
+ @foreach ($genres as $genre) + @if ( "" != $genre->name ) + {{ $genre->name }} ({{ $genre->count }} Movies) + @endif + @endforeach +
+
+ +
+@endsection + +@section('footer') + @include ('layouts.footer') +@endsection diff --git a/resources/views/layouts/app.blade.php b/resources/views/layouts/app.blade.php index 35c57b4..9b22bac 100644 --- a/resources/views/layouts/app.blade.php +++ b/resources/views/layouts/app.blade.php @@ -141,6 +141,9 @@
  • {{ __('Cinema') }}
    • +
  • + {{ __('Genres') }} +
    • @else