feat: add Hacker News stories section to movie detail page

Links to every HN story referencing this movie, ordered by most recent.
Each entry shows date, score (if > 0), and descendants (if > 0).

1 files changed, 17 insertions, 0 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,
         ]);
     }