diff options
Diffstat (limited to 'site/app/Http/Controllers/IndexController.php')
| -rw-r--r-- | site/app/Http/Controllers/IndexController.php | 3 |
1 files changed, 2 insertions, 1 deletions
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); |