1 files changed, 34 insertions, 0 deletions
diff --git a/site/app/Http/Controllers/PageFeedController.php b/site/app/Http/Controllers/PageFeedController.php
new file mode 100644
index 0000000..e29c8ca
--- /dev/null
+++ b/site/app/Http/Controllers/PageFeedController.php
@@ -0,0 +1,34 @@
+<?php                                                                                                                                                                                                                
+namespace App\Http\Controllers;
+use Illuminate\Http\Request;
+use App\Helpers\CryptoHelper;
+
+use Illuminate\Support\Facades\DB;
+use App\Http\Controllers\Controller;
+
+class PageFeedController extends Controller {
+    /**
+     * Shows the index page.
+     *
+     * @return Response
+     */
+    public function showPage(Request $request) {
+  
+
+	    $views = array("whisky", "wodka", "gin", "rum", "misc", "all");
+	    $query = "";
+
+	    foreach($views as $view) {
+		if ($query != "") {
+			$query .= " UNION ";
+		} 
+		$query .= "(SELECT name, image_url, spirit_type, spirit_type AS url, spirit_type AS feedname, '' AS linktext, created_at FROM ". $view ."_view WHERE original_price > 19.98 ORDER BY created_at DESC LIMIT 1)";
+	    }
+	    	# todo: schlägt manchmal fehl
+		$query .= " UNION (SELECT name, image_url, spirit_type, spirit_type AS url, spirit_type AS feedname, '' AS linktext, created_at FROM ". $view ."_view WHERE original_price > 19.98 AND (procent < (SELECT MAX(procent) FROM all_view)) ORDER BY procent LIMIT 1)";
+
+	    $data = DB::select($query);
+
+        return view('feeds', ['data' => $data, 'views' => $views]);
+    }
+}