diff options
| author | horus | 2019-05-19 17:07:34 +0200 |
|---|---|---|
| committer | horus | 2019-05-19 17:07:34 +0200 |
| commit | 924f23c1c6b5deeea44b08c7d3032426826fa3bb (patch) | |
| tree | 536a904691d9270c4d3fddd815a4867e9df72fc7 /app/Http/Controllers | |
| parent | eaf98cc0e8674e65a3bb4164094908c7a51c8a0c (diff) | |
| download | kategorischeraperitif-924f23c1c6b5deeea44b08c7d3032426826fa3bb.tar.gz | |
Minor improvements.
Diffstat (limited to 'app/Http/Controllers')
| -rw-r--r-- | app/Http/Controllers/IndexController.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/app/Http/Controllers/IndexController.php b/app/Http/Controllers/IndexController.php index a6656e9..df12014 100644 --- a/app/Http/Controllers/IndexController.php +++ b/app/Http/Controllers/IndexController.php @@ -24,7 +24,7 @@ class IndexController extends Controller { } # 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, (SELECT MAX(procent) FROM " . $view . "_view) as procent, '' AS linktext FROM ". $view ."_view WHERE original_price > 19.98 AND shop != \"Drankdozijn\" ORDER BY procent DESC LIMIT 1)"; - $query .= "(SELECT name, image_url, spirit_type, spirit_type AS url, spirit_type AS angebotsname, (SELECT MAX(procent) FROM " . $view . "_view) as procent, '' AS linktext FROM ". $view ."_view WHERE original_price > 19.98 ORDER BY procent DESC LIMIT 1)"; + $query .= "(SELECT name, image_url, spirit_type, spirit_type AS url, spirit_type AS angebotsname, (SELECT MAX(procent) FROM " . $view . "_view) as procent, '' AS linktext FROM ". $view ."_view WHERE original_price > 29.98 AND spirit_type != 'Verschiedenes' ORDER BY procent DESC LIMIT 1)"; } $query .= " UNION (SELECT 'Alle Angebote' as name, 'https://angebote.fuselkoenig.de/img/feed-icon-gray.jpg' as image_url, 'RSS-Feeds' as spirit_type, 'feeds' AS url, 'RSS-Feeds' AS angebotsname, (SELECT MAX(procent) FROM all_view) as procent, 'Zu den RSS-Feeds' AS linktext FROM all_view LIMIT 1)"; |