From 3cc2896376c4ef5b8d01320259010ba4e4576a3a Mon Sep 17 00:00:00 2001 From: Jan-Philipp Litza Date: Wed, 26 Dec 2012 17:27:27 +0100 Subject: multiply night shifts by 2 (confable with raw mysql) --- install/default-conf/config.php | 15 +++++++++++---- 1 file changed, 11 insertions(+), 4 deletions(-) (limited to 'install') diff --git a/install/default-conf/config.php b/install/default-conf/config.php index d27d809a..543d1dce 100644 --- a/install/default-conf/config.php +++ b/install/default-conf/config.php @@ -37,10 +37,6 @@ $gmdateOffset=3600; // für Developen 1, sonst = 0 $debug = 0; -// SSL Cert-KEY -$show_SSLCERT = "MD5:
MD5SED
\n". - "SHA1:
SHA1SED"; - //globale const. fuer schischtplan $GlobalZeileProStunde = 4; @@ -61,4 +57,15 @@ $PentabarfXMLEventID = "31"; /// Passord for external Authorization, function only active if the var is defined //$CurrentExternAuthPass = 23; +// multiply "night shifts" (start or end between 2 and 6 exclusive) by 2 +$shift_sum_formula = "SUM( + (1+( + (HOUR(FROM_UNIXTIME(`Shifts`.`end`)) > 2 AND HOUR(FROM_UNIXTIME(`Shifts`.`end`)) < 6) + OR (HOUR(FROM_UNIXTIME(`Shifts`.`start`)) > 2 AND HOUR(FROM_UNIXTIME(`Shifts`.`start`)) < 6) + OR (HOUR(FROM_UNIXTIME(`Shifts`.`start`)) <= 2 AND HOUR(FROM_UNIXTIME(`Shifts`.`end`)) >= 6) + ))*(`Shifts`.`end` - `Shifts`.`start`) +)"; + +// weigh every shift the same +//$shift_sum_formula = "SUM(`end` - `start`)"; ?> -- cgit v1.2.3-54-g00ecf