IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 41371


Ignore:
Timestamp:
May 28, 2020, 2:10:23 PM (6 years ago)
Author:
tdeboer
Message:

ippMonitor bad warp check update

Location:
trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippMonitor/raw/czartool_labels.php

    r41202 r41371  
    476476    $query .= "    GROUP BY chunk ORDER BY dateobs) as suba ";
    477477    $query .= "LEFT JOIN";
    478     $query .= "    (SELECT subc.chunk, count(if(subc.Nwarpskycellbad < subc.Nwarpskycell,1,NULL)) AS Nwarpgood, count(if(subc.Nwarpskycellbad = subc.Nwarpskycell,1,NULL)) AS Nwarpbad";
     478    $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";
    479479    $query .= "    FROM ";
    480480    $query .= "      (SELECT substr(comment, 1, position(' ' in comment)) AS chunk,count(warpSkyfile.quality) AS Nwarpskycell,count(if(warpSkyfile.quality > 0,1,NULL)) AS Nwarpskycellbad";

  • trunk/ippScripts/scripts/night_report.pl

    r41361 r41371  
    9292    $query .= "LEFT JOIN";
    9393    $query .= "    (SELECT subc.chunk, count(if(subc.Nwarpskycellbad < subc.Nwarpskycell,1,NULL)) AS
    94 Nwarpgood, count(if(subc.Nwarpskycellbad = subc.Nwarpskycell,1,NULL) AND subc.Nwarpskycell > 0) AS Nwarpbad";
     94Nwarpgood, count(if(subc.Nwarpskycellbad = subc.Nwarpskycell AND subc.Nwarpskycell > 0,1,NULL)) AS Nwarpbad";
    9595    $query .= "    FROM ";
    9696    $query .= "      (SELECT substr(comment, 1, position(' ' in comment)) AS chunk,count(warpSkyfile.quality) AS Nwarpskycell,count(if(warpSkyfile.quality > 0,1,NULL)) AS Nwarpskycellbad";
    … …  
    11901190    $query .= "    GROUP BY chunk ORDER BY dateobs) as suba ";
    11911191    $query .= "LEFT JOIN";
    1192     $query .= "    (SELECT subc.chunk, count(if(subc.Nwarpskycellbad < subc.Nwarpskycell,1,NULL)) AS Nwarpgood, count(if(subc.Nwarpskycellbad = subc.Nwarpskycell,1,NULL) AND subc.Nwarpskycell > 0) AS Nwarpbad";
     1192    $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";
    11931193    $query .= "    FROM ";
    11941194    $query .= "      (SELECT substr(comment, 1, position(' ' in comment)) AS chunk,count(warpSkyfile.quality) AS Nwarpskycell,count(if(warpSkyfile.quality > 0,1,NULL)) AS Nwarpskycellbad";
Note: See TracChangeset for help on using the changeset viewer.