From 34ee983becfa088d0c39c4f0d9b35f038b351a78 Mon Sep 17 00:00:00 2001
From: Developer
Date: Sat, 27 Jun 2026 02:47:40 +0200
Subject: feat: add cinema module for browsing movies from hncrawler DB

- Add 'cinema' database connection (hncrawler DB) to config/database.php
- Create CinemaController with cinema(), show(), search() methods
- Add /cinema, /cinema/movie/{imdb_id}, /cinema/search routes
- Create cinema.blade.php (grid listing with posters, ratings, pagination)
- Create cinema-show.blade.php (detail page with cast, genres, synopsis)
- Add Cinema link to navbar
- Update page title logic for cinema routes
---
 ...0_03_28_131201_create_view_popular_articles.php | 55 ++++++++++++++++++++++
 1 file changed, 55 insertions(+)
 create mode 100644 database/migrations/2020_03_28_131201_create_view_popular_articles.php

(limited to 'database/migrations/2020_03_28_131201_create_view_popular_articles.php')

diff --git a/database/migrations/2020_03_28_131201_create_view_popular_articles.php b/database/migrations/2020_03_28_131201_create_view_popular_articles.php
new file mode 100644
index 0000000..062b8e0
--- /dev/null
+++ b/database/migrations/2020_03_28_131201_create_view_popular_articles.php
@@ -0,0 +1,55 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\DB;
+
+class CreateViewPopularArticles extends Migration
+{
+    /**
+     * Run the migrations.
+     *
+     * @return void
+     */
+    public function up()
+    {
+	DB::statement("
+		CREATE VIEW view_popular AS
+		SELECT 
+			article_id as id,
+			article_id,
+			a.created_at,
+			a.updated_at,
+			a.url,
+			a.title,
+			a.excerpt_html,
+			sum(upvotes)+sum(comments) AS impact,
+			sum(upvotes) AS upvotes,
+			sum(comments) as comments,
+			count(article_id) AS repost
+		FROM 
+			discussion as d 
+		JOIN 
+			article AS a ON d.article_id = a.id 
+		GROUP BY 
+			article_id, 
+			a.created_at,
+			a.updated_at,
+			a.url,
+			a.title,
+			a.excerpt_html
+			HAVING (impact > 300) OR (count(article_id) > 2) 
+		ORDER BY ((sum(upvotes)+sum(comments))*count(article_id)) desc, repost desc, impact desc"
+	);
+    }
+
+    /**
+     * Reverse the migrations.
+     *
+     * @return void
+     */
+    public function down()
+    {
+	DB::statement("DROP VIEW view_popular;");
+    }
+}
-- 
cgit v1.2.3