fix: use separate count query in cinema search (SimplePaginator has no total())

1 files changed, 10 insertions, 2 deletions

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]);
     }