Changeset 18207


Ignore:
Timestamp:
06/15/15 00:04:50 (9 years ago)
Author:
Daniela Dorner
Message:
adapted to ignore moon-entries
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/www/dch/shifteval.php

    r17602 r18207  
    107107        $queryusers="SELECT uid FROM calendar.Data LEFT JOIN logbook.users ON calendar.Data.u=logbook.users.username ";
    108108        $queryusers.="WHERE CONCAT(y,LPAD(m+1,2,0),LPAD(d,2,0))=".$starttimestamp->format('Ymd');
    109         $queryusers.=" AND u NOT IN ('ETHZ', 'ISDC', 'UNIDO', 'UNIWUE')";
     109        $queryusers.=" AND u NOT IN ('ETHZ','ISDC','UNIWUE','TUDO','moon')";
    110110        // get shifthours per user and institute
    111111        $queryshifters=$queryusers." AND x=0";
     
    167167
    168168    echo "<br>\n<br>\n";
    169     echo "Remark: Debugging times before 2013/02 are not taken into account, i.e. first 16 months of debugging is missing in the automatic evaluation system.";
    170     echo "<br>\n<br>\n";
    171169    echo "<b>Total number of hours:</b> ".$hourstotal." h.";
    172170    echo "<table>\n";
     
    174172    foreach ($institutenames as $id=>$name)
    175173    {
    176         if (!$institutetotalhours[$id])
    177             continue;
     174        //if (!$institutetotalhours[$id])
     175        //    continue;
    178176        echo "<tr><td>";
    179177        echo $name;//."(".$id.")";
     
    184182        echo "</td></tr>\n";
    185183    }
    186     echo "</table>\n";
     184    echo "</table><br>\n";
    187185
    188186    echo "<table>\n";
     
    199197    }
    200198    echo "</table>\n<br>\n";
     199    echo "Remark: Debugging times before 2013/02 are not taken into account, i.e. first 16 months of debugging is missing in the automatic evaluation system.";
     200    echo "<br>\n<br>\n";
    201201
    202202    echo "</form>\n";
Note: See TracChangeset for help on using the changeset viewer.