Changeset 19500

Timestamp:

05/05/19 17:03:13 (6 years ago)

Author:

Daniela Dorner

Message:

fixed eff-ontime

File:

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

trunk/www/dch/db_explorer.php

@@ -370 +370 @@
     $selecty="SUM(fNumExcEvts)*3600/SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)";
     $selecterr="EXCERR(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)*3600";
-    $isnull="AND NOT ISNULL(fNumExcEvts)";
+    $isnull="AND NOT ISNULL(fNumExcEvts) AND NOT ISNULL(fEffectiveOn)";
     $titley="Excess events";
     $unity="[1/h]";
@@ -554 +554 @@
     ($selectx) AS x,
     ($selecty) AS y,
-    (SUM(fOnTimeAfterCuts)/60) AS ontime,
+    (SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn)/60) AS ontime,
     ($selecterr) AS e,
     (LIMA(SUM(fNumSigEvts), SUM(fNumBgEvts))) AS s,