Major improvements. (website)

1 files changed, 28 insertions, 2 deletions

diff --git a/site/app/Http/Controllers/IndexController.php b/site/app/Http/Controllers/IndexController.php
index 745a023..c0056d9 100644
--- a/site/app/Http/Controllers/IndexController.php
+++ b/site/app/Http/Controllers/IndexController.php
@@ -14,8 +14,34 @@ class IndexController extends Controller {
      */
     public function showPage(Request $request) {
   
-	//$data = DB::table('angebote')->orderBy('quotient', 'DESC')->limit(100)->get();
-	$data = DB::table('angebote')->orderBy('quotient', 'DESC')->limit(100)->simplePaginate(20);
+
+	    $views = array("whisky", "wodka", "gin", "rum", "misc");
+	    $query = "";
+
+	    foreach($views as $view) {
+		if ($query != "") {
+			$query .= " UNION ";
+		} 
+		$query .= "(SELECT name, image_url, spirit_type, spirit_type AS url, spirit_type AS angebotsname, original_price, discounted_price, procent, '' AS linktext FROM ". $view ."_view WHERE original_price > 19.98 ORDER BY procent DESC LIMIT 1)";
+	    }
+
+	    // removes the last union
+	    #$query .= substr($query, -1, strlen(" UNION "));
+	    #echo "<pre>";
+	    #var_dump($query); exit;
+
+	    /*
+	    $dbh = DB::connection('mysql')->getPdo();
+	    $stmt = $dbh->prepare($query);
+	    $stmt->execute();
+
+	    $data = $stmt->fetchAll(\PDO::FETCH_ASSOC);
+	     */
+
+
+	    #var_dump($query); exit;
+	    $data = DB::select($query);
+		#$data = DB::table('whisky_view')->orderBy('procent', 'DESC')->limit(100)->simplePaginate(20);
 
         return view('index', ['data' => $data]);
     }