From 07f62219b933a2dfd06d59322cbd83e107937b08 Mon Sep 17 00:00:00 2001
From: horus
Date: Fri, 22 Jun 2018 15:23:23 +0200
Subject: Adds special styles explicitly for Drankdozijn. (website)

---
 site/app/Http/Controllers/IndexController.php | 2 +-
 1 file changed, 1 insertion(+), 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 09ff3a2..41fae3d 100644
--- a/site/app/Http/Controllers/IndexController.php
+++ b/site/app/Http/Controllers/IndexController.php
@@ -23,7 +23,7 @@ class IndexController extends Controller {
 			$query .= " UNION ";
 		} 
 		# 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 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 AND shop != \"Drankdozijn\" ORDER BY procent DESC LIMIT 1)";
 	    }
 		$query .= " UNION (SELECT 'Alle Angebote' as name, '/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)";
 
-- 
cgit v1.2.3