From 7d1d61757a39e7f949e65e0d9f8b6555f5010b90 Mon Sep 17 00:00:00 2001 From: dev Date: Sat, 27 Jun 2026 07:01:54 +0200 Subject: feat: split movie synopsis into separate paragraphs Synopsis now splits on \n\n into individual
tags instead of one big text blob. Already implemented, confirmed working with latest DB data. --- ssh/app/Http/Controllers/FeedController.php | 97 ----------------------------- 1 file changed, 97 deletions(-) delete mode 100644 ssh/app/Http/Controllers/FeedController.php (limited to 'ssh/app/Http/Controllers/FeedController.php') diff --git a/ssh/app/Http/Controllers/FeedController.php b/ssh/app/Http/Controllers/FeedController.php deleted file mode 100644 index 9d20fce..0000000 --- a/ssh/app/Http/Controllers/FeedController.php +++ /dev/null @@ -1,97 +0,0 @@ -select('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') - ->groupBy('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') - ->where('view_article.created_at', '<', now()->subMinutes(30)) - ->orderByRaw('MAX(discussion.posted_on) DESC') - ->take(20) - ->get(); - - return Helper::makeFeed($articles, "new"); - } - - public function mastodon() - { - $articles = Article::join('discussion', 'discussion.article_id', '=', 'view_article.id') - ->select('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') - ->groupBy('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') - ->where('view_article.created_at', '<', now()->subMinutes(30)) - ->orderByRaw('MAX(discussion.posted_on) DESC') - ->take(20) - ->get(); - return Helper::makeFeed($articles, "mastodon"); - } - public function mastodon_test() - { - $articles = Article::join('discussion', 'discussion.article_id', '=', 'view_article.id') - ->select('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') - ->groupBy('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') - ->where('view_article.created_at', '<', now()->subMinutes(30)) - ->orderByRaw('MAX(discussion.posted_on) DESC') - ->take(20) - ->get(); - return Helper::makeFeed($articles, "mastodon_test"); - } - - public function popular() - { - - $articles = new Article; - $articles = $articles->setTable('view_popular'); - $articles = $articles->take(20)->get(); - return Helper::makeFeed($articles, "popular"); - } - - public function search(Request $request) { - $search_unsafe = $request->input("q"); - - if ( "" == $search_unsafe ) { - $search_unsafe = ""; - } - - $search_unsafe = explode(",", $request->input("q")); - - $articles = new Article; - - if ( "on" == $request->input("onlypopular") ) { - $articles = $articles->setTable('view_popular'); - } - - foreach($search_unsafe as $q) { - $q = Helper::escapeLike($q); - $q = "%".$q."%"; - $articles = $articles->where(function ($query) use ($q) { - $query->whereHas('getCategories', function ($query) use ($q){ - $query->where('name', 'like', $q); - }) - ->orWhere('title', 'like', $q) - ->orWhere('url', 'like', $q) - ->orWhere('excerpt_html', 'like', $q); - }); - } - $count = $articles->count(); - - if ( "on" == $request->input("onlypopular") ) { - $articles = $articles->orderBy('impact', 'desc'); - } - $articles = $articles->orderBy('created_at', 'desc'); - - return Helper::makeFeed($articles->take(20)->get(), $request->input("q")); - } -} -- cgit v1.2.3