IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
May 17, 2019, 1:44:49 PM (7 years ago)
Author:
tdeboer
Message:

script updated to handle BRIGHT obs_modes

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippScripts/scripts/night_report.pl

    r40701 r40746  
    6868}
    6969
    70 ##################33
     70##################
    7171### testing the diff grouping -- this does not work for the Euclid data taken 2018.07.29 because the OBJECT
    7272### field is missing
    … …  
    382382    $query .= "     AND exp_type = 'OBJECT'";
    383383    $query .= "     AND obs_mode NOT LIKE 'ENGINEERING'";
    384     $query .= "     AND obs_mode like '%SS%'";
     384    $query .= "     AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
    385385    $query .= "     AND rawExp.comment like '%visit%'";
    386386    $query .= "     AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
    … …  
    438438    $query .= "     AND exp_type = 'OBJECT'";
    439439    $query .= "     AND obs_mode NOT LIKE 'ENGINEERING'";
    440     $query .= "     AND obs_mode like '%SS%'";
     440    $query .= "     AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
    441441    $query .= "     AND rawExp.comment like '%visit%'";
    442442    $query .= "     AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
    … …  
    474474    $query .= "     AND exp_type = 'OBJECT'";
    475475    $query .= "     AND obs_mode NOT LIKE 'ENGINEERING'";
    476     $query .= "     AND obs_mode like '%SS%'";
     476    $query .= "     AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
    477477    $query .= "     AND rawExp.comment like '%visit%'";
    478478    $query .= "     AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
    … …  
    660660    $query .= "   AND exp_type = 'OBJECT'";
    661661    $query .= "   AND obs_mode NOT LIKE 'ENGINEERING'";
    662     $query .= "   AND obs_mode NOT like '%SS%'";
     662    $query .= "   AND (obs_mode NOT LIKE '%SS%' AND obs_mode NOT LIKE '%BRIGHT%')";
    663663    $query .= "   AND rawExp.comment like '%visit%'";
    664664    $query .= "   AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
    … …  
    694694    $query .= "    WHERE dateobs like '$date%'";
    695695    $query .= "    AND exp_id > $refExpID"; #REF
    696     $query .= "    AND obs_mode like '%SS%'";
     696    $query .= "    AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
    697697    $query .= "    AND (camProcessedExp.quality = 0)";
    698698    $query .= "  ) AS expall";
    … …  
    724724    while (@row = $result->fetchrow_array()) {
    725725        if ($doHeader) {
    726             print "Unpublished Solar System Exposures ( obs_mode like %SS% ) with good camera quality :\n";
     726            print "Unpublished Solar System Exposures ( obs_mode like %SS% or obs_mode like %BRIGHT%) with good camera quality :\n";
    727727            printf "%12s %12s %12s | %-19s | %-16s\n", "exp_name", "warp_id", "diff_id", "dateobs", "comment";
    728728            $doHeader = 0;
    … …  
    751751    $query .= "     AND exp_type = 'OBJECT'";
    752752    $query .= "     AND obs_mode NOT LIKE 'ENGINEERING'";
    753     $query .= "     AND obs_mode like '%SS%'";
     753    $query .= "     AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
    754754    $query .= "     AND rawExp.comment like '%visit%'";
    755755    $query .= "     AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
Note: See TracChangeset for help on using the changeset viewer.