From 356e12e4aa0230bc47a9daa4f8f488354476c571 Mon Sep 17 00:00:00 2001
From: Developer
Date: Sat, 27 Jun 2026 03:18:39 +0200
Subject: fix: use separate count query in cinema search (SimplePaginator has
 no total())

---
 app/Http/Controllers/CinemaController.php | 12 ++++++++++--
 1 file changed, 10 insertions(+), 2 deletions(-)

(limited to 'app/Http/Controllers/CinemaController.php')

diff --git a/app/Http/Controllers/CinemaController.php b/app/Http/Controllers/CinemaController.php
index c1cb215..c6fec3b 100644
--- a/app/Http/Controllers/CinemaController.php
+++ b/app/Http/Controllers/CinemaController.php
@@ -104,10 +104,18 @@ class CinemaController extends Controller
                   ->orWhere('imdb.original_title', 'like', '%' . $query . '%')
                   ->orWhere('imdb.synopsis', 'like', '%' . $query . '%');
             })
-            ->orderBy('imdb.average_rating', 'desc')
             ->simplePaginate(12);
 
-        $total = $movies->total();
+        $total = DB::connection('cinema')
+            ->table('imdb')
+            ->whereNotNull('primary_title')
+            ->where('title_type', 'movie')
+            ->where(function ($q) use ($query) {
+                $q->where('primary_title', 'like', '%' . $query . '%')
+                  ->orWhere('original_title', 'like', '%' . $query . '%')
+                  ->orWhere('synopsis', 'like', '%' . $query . '%');
+            })
+            ->count();
 
         return view('cinema', ['movies' => $movies, 'count' => $total, 'search_query' => $query]);
     }
-- 
cgit v1.2.3