summaryrefslogtreecommitdiff
path: root/ssh/app/Http/Controllers/FeedController.php
diff options
context:
space:
mode:
authordev2026-06-27 07:01:54 +0200
committerdev2026-06-27 07:01:54 +0200
commit7d1d61757a39e7f949e65e0d9f8b6555f5010b90 (patch)
tree52cd70504de34513069cbba334e954fc477a3229 /ssh/app/Http/Controllers/FeedController.php
parentb608ced142cd0527906b554e04376292f718f084 (diff)
downloadcurious-7d1d61757a39e7f949e65e0d9f8b6555f5010b90.tar.gz
feat: split movie synopsis into separate paragraphs
Synopsis now splits on \n\n into individual <p> tags instead of one big text blob. Already implemented, confirmed working with latest DB data.
Diffstat (limited to 'ssh/app/Http/Controllers/FeedController.php')
-rw-r--r--ssh/app/Http/Controllers/FeedController.php97
1 files changed, 0 insertions, 97 deletions
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 @@
-<?php
-
-namespace App\Http\Controllers;
-
-use Illuminate\Http\Request;
-use Illuminate\Support\Facades\DB;
-use App\Article;
-use App\Discussion;
-use App\Category;
-use App\Libraries\Helper;
-
-class FeedController extends Controller
-{
-
- public function new()
- {
- // creating rss feed with our most recent 20 posts
- $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, "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"));
- }
-}