From 4c071113fa35c42d8b324faafdb95f290c209f7f Mon Sep 17 00:00:00 2001
From: horus
Date: Thu, 15 Feb 2018 15:05:39 +0100
Subject: Misc improvements. (website)

---
 site/app/Http/Controllers/IndexController.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'site/app/Http/Controllers/IndexController.php')

diff --git a/site/app/Http/Controllers/IndexController.php b/site/app/Http/Controllers/IndexController.php
index d734ca9..7b5ced4 100644
--- a/site/app/Http/Controllers/IndexController.php
+++ b/site/app/Http/Controllers/IndexController.php
@@ -22,7 +22,8 @@ class IndexController extends Controller {
 		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)";
+		# subquery to get procent, because cheap spirits don't look good
+		$query .= "(SELECT name, image_url, spirit_type, spirit_type AS url, spirit_type AS angebotsname, original_price, discounted_price, (SELECT MAX(procent) FROM " . $view . "_view) as procent, '' AS linktext FROM ". $view ."_view WHERE original_price > 19.98 ORDER BY procent DESC LIMIT 1)";
 	    }
 
 	    $data = DB::select($query);
-- 
cgit v1.2.3