diff options
| -rw-r--r-- | app/Http/Controllers/CinemaController.php | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/app/Http/Controllers/CinemaController.php b/app/Http/Controllers/CinemaController.php index c6fec3b..c433eea 100644 --- a/app/Http/Controllers/CinemaController.php +++ b/app/Http/Controllers/CinemaController.php @@ -28,12 +28,14 @@ class CinemaController extends Controller ->orderBy('imdb.average_rating', 'desc') ->orderBy('imdb.num_votes', 'desc') ->whereNotNull('imdb.primary_title') + ->whereNotNull('imdb.wiki_article') ->where('imdb.title_type', 'movie') ->simplePaginate(12); $total = DB::connection('cinema') ->table('imdb') ->whereNotNull('primary_title') + ->whereNotNull('wiki_article') ->where('title_type', 'movie') ->count(); @@ -98,6 +100,7 @@ class CinemaController extends Controller 'imdb.runtime_minutes' ) ->whereNotNull('imdb.primary_title') + ->whereNotNull('imdb.wiki_article') ->where('imdb.title_type', 'movie') ->where(function ($q) use ($query) { $q->where('imdb.primary_title', 'like', '%' . $query . '%') @@ -109,6 +112,7 @@ class CinemaController extends Controller $total = DB::connection('cinema') ->table('imdb') ->whereNotNull('primary_title') + ->whereNotNull('wiki_article') ->where('title_type', 'movie') ->where(function ($q) use ($query) { $q->where('primary_title', 'like', '%' . $query . '%') |