Ignore:
Timestamp:
10/18/10 17:14:38 (14 years ago)
Author:
Daniela Dorner
Message:
added 'done and avail' as status option
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/Mars/datacenter/db/mcinfo.php

    r9895 r10012  
    3333                            ." AND ISNULL(" . $key . "Status.fStopTime) "
    3434                            ." AND ISNULL(" . $key . "Status.fReturnCode), 'not done', "
     35                            //crashed
    3536                            ." IF (NOT ISNULL(" . $key . "Status.fStartTime) "
    3637                            ." AND DATE_SUB(Now(),INTERVAL " . $timelimits[$key] . " HOUR) > " . $key . "Status.fStartTime "
    3738                            ." AND ISNULL(" . $key . "Status.fStopTime) "
    3839                            ." AND ISNULL(" . $key . "Status.fReturnCode), 'crashed', "
     40                            //running
    3941                            ." IF (NOT ISNULL(" . $key . "Status.fStartTime) "
    4042                            ." AND DATE_SUB(Now(),INTERVAL " . $timelimits[$key] . " HOUR) < " . $key . "Status.fStartTime "
    4143                            ." AND ISNULL(" . $key . "Status.fStopTime) "
    4244                            ." AND ISNULL(" . $key . "Status.fReturnCode), 'running', "
     45                            //failed
    4346                            ." IF (NOT ISNULL(" . $key . "Status.fStartTime) "
    4447                            ." AND NOT ISNULL(" . $key . "Status.fStopTime) "
    45                             ." AND ISNULL(" . $key . "Status.fReturnCode), 'done', 'failed' "
    46                             ." )))) AS '". $key . "', ";
     48                            ." AND NOT ISNULL(" . $key . "Status.fReturnCode), 'failed', "
     49                            //done or done and avail
     50                            ." IF (NOT ISNULL(" . $key . "Status.fStartTime) "
     51                            ." AND NOT ISNULL(" . $key . "Status.fStopTime) "
     52                            ." AND ISNULL(" . $key . "Status.fReturnCode)"
     53                            ." AND ISNULL(" . $key . "Status.fAvailable), 'done', 'done and avail' "
     54                            ." ))))) AS '". $key . "', ";
    4755            }
    4856            $query0 .= " COUNT(*) as '# Files' ";
    4957            $query0 .= ", SUM(fNumEvents) as '" . $alias["SUM(fNumEvents)"] . "' ";
     58            $query0 .= ", SUM(fNumEvents*fNumReUseShowers) as '" . $alias["SUM(fNumEvents*fNumReUseShowers)"] . "' ";
    5059        }
    5160        else
Note: See TracChangeset for help on using the changeset viewer.