diff options
| author | dev | 2026-06-27 07:01:54 +0200 |
|---|---|---|
| committer | dev | 2026-06-27 07:01:54 +0200 |
| commit | 7d1d61757a39e7f949e65e0d9f8b6555f5010b90 (patch) | |
| tree | 52cd70504de34513069cbba334e954fc477a3229 /ssh/app/Http/Controllers/FeedController.php | |
| parent | b608ced142cd0527906b554e04376292f718f084 (diff) | |
| download | curious-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.php | 97 |
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")); - } -} |
