diff options
| -rw-r--r-- | app/Http/Controllers/CinemaController.php | 17 | ||||
| -rw-r--r-- | resources/views/cinema_show.blade.php | 22 | ||||
| -rw-r--r-- | resources/views/layouts/app.blade.php | 2 |
3 files changed, 40 insertions, 1 deletions
diff --git a/app/Http/Controllers/CinemaController.php b/app/Http/Controllers/CinemaController.php index 8a9bb0e..d8adefa 100644 --- a/app/Http/Controllers/CinemaController.php +++ b/app/Http/Controllers/CinemaController.php @@ -94,12 +94,29 @@ class CinemaController extends Controller $directors = $casts->where('profession', 'director'); $screenwriters = $casts->where('profession', 'screenwriter')->take(3); + $hnStories = DB::connection('cinema') + ->table('links') + ->join('story', 'story.id', '=', 'links.story_id') + ->select( + 'story.story_id', + 'story.title', + 'story.score', + 'story.descendants', + 'story.time' + ) + ->where('links.host', 'www.imdb.com') + ->where('links.field', 1) + ->where('links.param', $id) + ->orderBy('story.time', 'desc') + ->get(); + return view('cinema_show', [ 'movie' => $movie, 'genres' => $genres, 'actors' => $actors, 'directors' => $directors, 'screenwriters' => $screenwriters, + 'hnStories' => $hnStories, ]); } diff --git a/resources/views/cinema_show.blade.php b/resources/views/cinema_show.blade.php index 5a3d262..c8b0935 100644 --- a/resources/views/cinema_show.blade.php +++ b/resources/views/cinema_show.blade.php @@ -128,6 +128,28 @@ </div> @endif + @if ( ! empty($hnStories) ) + <div class="mt-3"> + <h4>Hacker News</h4> + <ul class="list-unstyled"> + @foreach($hnStories as $story) + <li> + <a class="card-links" href="https://news.ycombinator.com/item?id={{ $story->story_id }}" target="_blank"> + {{ $story->title ?: 'HN Story' }} + </a> + | {{ \Carbon\Carbon::createFromTimestamp($story->time)->format('Y-m-d') }} + @if ($story->score > 0) + | <span class="badge badge-pill badge-secondary">{{ $story->score }} Upvotes</span> + @endif + @if ($story->descendants > 0) + | <span class="badge badge-pill badge-secondary">{{ $story->descendants }} Comments</span> + @endif + </li> + @endforeach + </ul> + </div> + @endif + @if ( ! is_null($movie->imdb_id) ) <div class="mt-3"> <a class="btn btn-outline-primary btn-sm" href="https://www.imdb.com/title/{{ $movie->imdb_id }}" target="_blank">View on IMDb</a> diff --git a/resources/views/layouts/app.blade.php b/resources/views/layouts/app.blade.php index 5de9a70..e3fe561 100644 --- a/resources/views/layouts/app.blade.php +++ b/resources/views/layouts/app.blade.php @@ -158,7 +158,7 @@ <span class="nav-link" style="pointer-events: none;">|</span> </li> <li class="nav-item"> - <a class="nav-link" href="{{ route('cinema.index') }}">{{ __('Cinema') }}</a> + <a class="nav-link" href="{{ route('cinema.index') }}">{{ __('Movies') }}</a> </li> <li class="nav-item"> <a class="nav-link" href="{{ route('cinema.genres') }}">{{ __('Genres') }}</a> |