1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
<?php
namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;
class CinemaController extends Controller
{
public function cinema()
{
$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',
'imdb.has_people'
)
->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();
return view('cinema', ['movies' => $movies, 'count' => $total]);
}
public function show($id)
{
$movie = DB::connection('cinema')
->table('imdb')
->where('imdb.imdb_id', $id)
->first();
if (! $movie) {
abort(404);
}
$genres = DB::connection('cinema')
->table('imdb_genre')
->join('genre', 'genre.id', '=', 'imdb_genre.genre_id')
->where('imdb_genre.imdb_id', $movie->id)
->pluck('genre.name');
$casts = DB::connection('cinema')
->table('who')
->join('people', 'people.id', '=', 'who.people_id')
->join('profession', 'profession.id', '=', 'who.profession_id')
->where('who.imdb_id', $movie->id)
->select('people.name', 'profession.name as profession')
->get();
$actors = $casts->where('profession', 'actor')->take(8);
$directors = $casts->where('profession', 'director');
$screenwriters = $casts->where('profession', 'screenwriter')->take(3);
return view('cinema_show', [
'movie' => $movie,
'genres' => $genres,
'actors' => $actors,
'directors' => $directors,
'screenwriters' => $screenwriters,
]);
}
public function search(Request $request)
{
$query = $request->input('q', '');
$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'
)
->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 . '%')
->orWhere('imdb.original_title', 'like', '%' . $query . '%')
->orWhere('imdb.synopsis', 'like', '%' . $query . '%');
})
->simplePaginate(12);
$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 . '%')
->orWhere('original_title', 'like', '%' . $query . '%')
->orWhere('synopsis', 'like', '%' . $query . '%');
})
->count();
return view('cinema', ['movies' => $movies, 'count' => $total, 'search_query' => $query]);
}
}
|
