Changeset 40428 for trunk/ippMonitor

Timestamp:

May 15, 2018, 9:58:14 AM (8 years ago)

Author:

eugene

Message:

add column of exposures which have been dropped or manually excluded

File:

• trunk/ippMonitor/raw/czartool_labels_old.php (modified) (3 diffs)

trunk/ippMonitor/raw/czartool_labels_old.php

@@ -349 +349 @@
     echo $table;
     echo "<tr>";
-    createTableTitle("Status of last night's data", 3);
+    createTableTitle("Status of last night's data", 4);
     echo "<tr>";
     createTableColumnHeader("Exposure type");
-    createTableColumnHeader("At summit");
+    createTableColumnHeader("At summit (OK)");
     createTableColumnHeader("Registered at MHPCC");
+    createTableColumnHeader("At summit (Dropped)");
 
     $msg = "No science images taken since $date";
@@ -360 +361 @@
     while ($qry->fetchInto($expType)) {
 
+#       $sql = "SELECT COUNT(*) FROM summitExp WHERE dateobs > '$date' AND exp_type = '$expType[0]' and status != 'drop'";
         $sql = "SELECT COUNT(*) FROM summitExp WHERE dateobs > '$date' AND exp_type = '$expType[0]'";
         $qry2 = $projectdb->query($sql);
         $qry2->fetchInto($summit);
+
+#       $sql = "SELECT COUNT(*) FROM summitExp JOIN rawExp ON summitExp.exp_name = rawExp.exp_name WHERE summitExp.dateobs > '$date' AND summitExp.exp_type = '$expType[0]' AND summitExp.status != 'drop'";
         $sql = "SELECT COUNT(*) FROM summitExp JOIN rawExp ON summitExp.exp_name = rawExp.exp_name WHERE summitExp.dateobs > '$date' AND summitExp.exp_type = '$expType[0]'";
         $qry2 = $projectdb->query($sql);
         $qry2->fetchInto($mhpcc);
 
+        $sql = "SELECT COUNT(*) FROM summitExp WHERE dateobs > '$date' AND exp_type = '$expType[0]'";
+        $qry2 = $projectdb->query($sql);
+        $qry2->fetchInto($dropped);
+
         echo "<tr>";
 
@@ -374 +382 @@
         echo "<td>$expType[0]</td>";
         echo "<td>$summit[0]</td>";
-        
         createFormattedTableCell("", "", $mhpcc[0], $error, 0);
+        echo "<td>$dropped[0]</td>";
 
         echo "</tr>";