diff options
| author | horus | 2020-04-11 19:44:37 +0200 |
|---|---|---|
| committer | horus | 2020-04-11 19:44:37 +0200 |
| commit | 3afd5b2fd1f217f12ecad465449524fe93cacf09 (patch) | |
| tree | 0e495bb39f3f2c27b7bd2a53b5ffb1daab06057c /app/Http/Controllers | |
| parent | 6bb11edffaa0850f741022b608a4c032986b45c4 (diff) | |
| download | curious-3afd5b2fd1f217f12ecad465449524fe93cacf09.tar.gz | |
Adds RSS- and Atom-Feeds.
Diffstat (limited to 'app/Http/Controllers')
| -rw-r--r-- | app/Http/Controllers/FeedController.php | 67 |
1 files changed, 67 insertions, 0 deletions
diff --git a/app/Http/Controllers/FeedController.php b/app/Http/Controllers/FeedController.php new file mode 100644 index 0000000..9fd73a5 --- /dev/null +++ b/app/Http/Controllers/FeedController.php @@ -0,0 +1,67 @@ +<?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::orderBy('created_at', 'desc')->take(20)->get(); + return Helper::makeFeed($articles, "new"); + } + + 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")); + } +} |
