feat: add sort buttons to cinema listing

Order options: Hacker News Mentions (default), Rating, Number of Votes,
Accolades, Release Date. Active sort is highlighted in primary color.

1 files changed, 11 insertions, 3 deletions

diff --git a/app/Http/Controllers/CinemaController.php b/app/Http/Controllers/CinemaController.php
index 160ca33..d79d037 100644
--- a/app/Http/Controllers/CinemaController.php
+++ b/app/Http/Controllers/CinemaController.php
@@ -7,8 +7,14 @@ use Illuminate\Http\Request;
 
 class CinemaController extends Controller
 {
-    public function cinema()
+    public function cinema(Request $request)
     {
+        $order = $request->input('order', 'ref_count');
+        $validOrders = ['ref_count', 'score', 'num_votes', 'num_accolades', 'start_year'];
+        if (! in_array($order, $validOrders)) {
+            $order = 'ref_count';
+        }
+
         $refCounts = DB::connection('cinema')
             ->table('links')
             ->select('links.param', DB::raw('COUNT(*) as ref_count'))
@@ -31,6 +37,8 @@ class CinemaController extends Controller
                 'imdb.title_type',
                 'imdb.runtime_minutes',
                 'imdb.has_people',
+                'imdb.average_rating as score',
+                'imdb.num_accolades',
                 DB::raw('COALESCE(ref.ref_count, 0) as ref_count')
             )
             ->leftJoinSub($refCounts, 'ref', function ($join) {
@@ -39,7 +47,7 @@ class CinemaController extends Controller
             ->whereNotNull('imdb.primary_title')
             ->whereNotNull('imdb.wiki_article')
             ->where('imdb.title_type', 'movie')
-            ->orderBy('ref_count', 'desc')
+            ->orderBy($order, 'desc')
             ->simplePaginate(12);
 
         $total = DB::connection('cinema')
@@ -49,7 +57,7 @@ class CinemaController extends Controller
             ->where('title_type', 'movie')
             ->count();
 
-        return view('cinema', ['movies' => $movies, 'count' => $total]);
+        return view('cinema', ['movies' => $movies, 'count' => $total, 'order' => $order]);
     }
 
     public function show($id)