Changeset 17601 for trunk/www/dch

Timestamp:

03/04/14 22:07:02 (11 years ago)

Author:

Daniela Dorner

Message:

fixed a small bug in the calculation of the shares

File:

• trunk/www/dch/shifteval.php (modified) (2 diffs)

trunk/www/dch/shifteval.php

@@ -209 +209 @@
         $queryshare="SELECT instituteid, COUNT(*) FROM memberlist.members ";
         $queryshare.=" WHERE start < '".$starttimestamp->format('Y-m-d H:i:s')."'";
-        $queryshare.=" AND stop > '".$stoptimestamp->format('Y-m-d H:i:s')."'";
+        //$queryshare.=" AND stop > '".$stoptimestamp->format('Y-m-d H:i:s')."'";
+        $queryshare.=" AND stop > '".$starttimestamp->format('Y-m-d H:i:s')."'";
         $queryshare.=" GROUP BY instituteid";
         //echo $queryshare." ";
@@ -250 +251 @@
     echo "remark: does not yet take into account institute changes, i.e. only valid from 1.9.2012<br>";
 
+    echo "--> ".$shifthourstotal;