Improves styling, rss feeds and pagination.

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);
+	}
 }