summaryrefslogtreecommitdiff
path: root/install/default-conf/config.php
diff options
context:
space:
mode:
authorJan-Philipp Litza <janphilipp@litza.de>2012-12-26 17:27:27 +0100
committerJan-Philipp Litza <janphilipp@litza.de>2012-12-26 17:27:27 +0100
commit3cc2896376c4ef5b8d01320259010ba4e4576a3a (patch)
treeb5fd6883bb65cfc2e09e850b843c2a6c56a7848a /install/default-conf/config.php
parent51c6547610066912c0b0a3e6309cfb6b149aa0c2 (diff)
multiply night shifts by 2 (confable with raw mysql)
Diffstat (limited to 'install/default-conf/config.php')
-rw-r--r--install/default-conf/config.php15
1 files changed, 11 insertions, 4 deletions
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:<br>MD5SED<br>\n".
- "SHA1:<br>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`)";
?>