diff options
Diffstat (limited to 'site/app/Http/Controllers/FeedController.php')
| -rw-r--r-- | site/app/Http/Controllers/FeedController.php | 17 |
1 files changed, 14 insertions, 3 deletions
diff --git a/site/app/Http/Controllers/FeedController.php b/site/app/Http/Controllers/FeedController.php index 7ac39c1..93c3ca1 100644 --- a/site/app/Http/Controllers/FeedController.php +++ b/site/app/Http/Controllers/FeedController.php @@ -58,8 +58,13 @@ class FeedController extends Controller { * Database query */ $view_name = str_replace("_feed", "", \Request::route()->getName()); - #$data = DB::table($view_name . '_view')->orderBy('created_at', 'DESC')->limit(100)->get(); - $data = DB::table($view_name . '_view')->orderBy($sort_by, $order_by)->limit(20)->get(); + if ( "search" == $view_name ) { + $query = Input::get("q"); + $q = "%" . $this->escapeLike($query) . "%"; + $data = DB::table('all_view')->where('name', 'like', $q)->orWhere('spirit_type', 'like', $q)->orderBy($sort_by, $order_by)->limit(20)->get(); + } else { + $data = DB::table($view_name . '_view')->orderBy($sort_by, $order_by)->limit(20)->get(); + } /* * For strftime(). @@ -70,7 +75,7 @@ class FeedController extends Controller { $feed->title = "Sonderangebote"; $feed->description = 'Finde immer die günstigsten Angebote im Bereich Spirituosen. Täglich neue Schnäppchen.'; - $feed->logo = 'https://fuselkoenig.de/favicon.ico'; + $feed->logo = '/img/paw-400-400.png'; $feed->link = url('feed'); $feed->setDateFormat('timestamp'); // 'datetime', 'timestamp' or 'carbon' $feed->pubdate = $data[0]->created_at; @@ -86,4 +91,10 @@ class FeedController extends Controller { return $feed->render('atom'); } + + private function escapeLike($string) { + $search = array('%', '_'); + $replace = array('\%', '\_'); + return str_replace($search, $replace, $string); + } } |