Changeset 41371 for trunk/ippMonitor/raw/czartool_labels.php

Timestamp:

May 28, 2020, 2:10:23 PM (6 years ago)

Author:

tdeboer

Message:

ippMonitor bad warp check update

File:

• trunk/ippMonitor/raw/czartool_labels.php (modified) (1 diff)

trunk/ippMonitor/raw/czartool_labels.php

@@ -476 +476 @@
     $query .= "    GROUP BY chunk ORDER BY dateobs) as suba ";
     $query .= "LEFT JOIN";
-    $query .= "    (SELECT subc.chunk, count(if(subc.Nwarpskycellbad < subc.Nwarpskycell,1,NULL)) AS Nwarpgood, count(if(subc.Nwarpskycellbad = subc.Nwarpskycell,1,NULL)) AS Nwarpbad";
+    $query .= "    (SELECT subc.chunk, count(if(subc.Nwarpskycellbad < subc.Nwarpskycell,1,NULL)) AS Nwarpgood, count(if(subc.Nwarpskycellbad = subc.Nwarpskycell AND subc.Nwarpskycell > 0,1,NULL)) AS Nwarpbad";
     $query .= "    FROM ";
     $query .= "      (SELECT substr(comment, 1, position(' ' in comment)) AS chunk,count(warpSkyfile.quality) AS Nwarpskycell,count(if(warpSkyfile.quality > 0,1,NULL)) AS Nwarpskycellbad";