From 09ab27a6d19883317f2fc185b57b971b8c780069 Mon Sep 17 00:00:00 2001
From: Max
Date: Sat, 10 Feb 2018 01:59:26 +0100
Subject: Major improvements. (website)

---
 site/app/Http/Controllers/IndexController.php  | 30 ++++++++++++++++++++++++--
 site/app/Http/Controllers/OfferController.php  | 26 ++++++++++++++++++++++
 site/app/Http/Controllers/WhiskyController.php | 18 ----------------
 site/app/Libraries/TemplateFunction.php        | 26 ++++++++++++++++++++++
 4 files changed, 80 insertions(+), 20 deletions(-)
 create mode 100644 site/app/Http/Controllers/OfferController.php
 delete mode 100644 site/app/Http/Controllers/WhiskyController.php
 create mode 100644 site/app/Libraries/TemplateFunction.php

(limited to 'site/app')

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]);
     }
diff --git a/site/app/Http/Controllers/OfferController.php b/site/app/Http/Controllers/OfferController.php
new file mode 100644
index 0000000..99108cd
--- /dev/null
+++ b/site/app/Http/Controllers/OfferController.php
@@ -0,0 +1,26 @@
+<?php                                                                                                                                                                                                                
+namespace App\Http\Controllers;
+use Illuminate\Http\Request;
+use App\Helpers\CryptoHelper;
+
+use Illuminate\Support\Facades\DB;
+use App\Http\Controllers\Controller;
+
+class OfferController extends Controller {
+    /**
+     * Shows the index page.
+     *
+     * @return Response
+     */
+    public function showPage(Request $request) {
+  
+	    $view_name = \Request::route()->getName();
+	$data = DB::table($view_name . '_view')->orderBy('procent', 'DESC')->limit(100)->simplePaginate(20);
+
+	if ( "misc" == $view_name ) {
+		$view_name = "Andere Angebote";
+	}
+
+        return view('offer', ['data' => $data, 'spirit_type' => $view_name]);
+    }
+} 
diff --git a/site/app/Http/Controllers/WhiskyController.php b/site/app/Http/Controllers/WhiskyController.php
deleted file mode 100644
index 620bfc7..0000000
--- a/site/app/Http/Controllers/WhiskyController.php
+++ /dev/null
@@ -1,18 +0,0 @@
-<?php                                                                                                                                                                                                                
-namespace App\Http\Controllers;
-use Illuminate\Http\Request;
-use App\Helpers\CryptoHelper;
-
-class WhiskyController extends Controller {
-    /**
-     * Shows the index page.
-     *
-     * @return Response
-     */
-    public function showPage(Request $request) {
-  
-	$shops = DB:select('SELECT * FROM shop');
-
-        return view('whisky', $shops);
-    }
-} 
diff --git a/site/app/Libraries/TemplateFunction.php b/site/app/Libraries/TemplateFunction.php
new file mode 100644
index 0000000..582995f
--- /dev/null
+++ b/site/app/Libraries/TemplateFunction.php
@@ -0,0 +1,26 @@
+<?php
+namespace App\Libraries;
+use App\Libraries\TemplateFunction;
+
+class TemplateFunction {
+	private static function formatFloat($float, $size = 2) {
+		return number_format($float, $size);
+	}
+
+	private static function stripDot($float) {
+		return str_replace(".", ",", $float);
+	}
+
+	public static function fF($float, $format = "") {
+		$f = TemplateFunction::formatFloat($float);
+		if ($f == intval($f)) {
+			$f = intval($f);
+		}
+
+		return TemplateFunction::stripDot($f); 
+	}
+
+	public static function T($timestamp) {
+		return gmdate("d.m.Y.", $timestamp);
+	}
+}
-- 
cgit v1.2.3