Changeset 12694 for trunk/Mars/datacenter/db/fact_runinfo.php

Timestamp:

12/03/11 00:17:04 (13 years ago)

Author:

Daniela Dorner

Message:

added new database values

File:

• trunk/Mars/datacenter/db/fact_runinfo.php (modified) (4 diffs)

trunk/Mars/datacenter/db/fact_runinfo.php

@@ -25 +25 @@
             $query0 .= " Concat(fRunNumber,'_', LPAD(fFileNumber, 3, 0)) as 'Run' ";
 
+            foreach ($_GET as $key => $element)
+                if ($_GET[$key]=="On")
+                    if ($key!="fComments")
+                        if (empty($checkwhere[$key]) || $checkwhere[$key]==0)
+                            $query0 .= ", " . $key . " as '" . $alias[$key] . "' ";
+
             if (!empty($_GET["fComments"]))
             {
@@ -31 +37 @@
             }
 
-            foreach ($_GET as $key => $element)
-                if ($_GET[$key]=="On")
-                    if ($key!="fComments")
-                        if (empty($checkwhere[$key]) || $checkwhere[$key]==0)
-                            $query0 .= ", " . $key . " as '" . $alias[$key] . "' ";
         }
 
@@ -191 +192 @@
             $_GET["fRunTypeName"]=$first?"On":"";
 
+        if (empty($_GET["fTriggerRateMedian"]))
+            $_GET["fTriggerRateMedian"]=$first?"On":"";
+
+        if (empty($_GET["fThresholdMedian"]))
+            $_GET["fThresholdMedian"]=$first?"On":"";
+
+        if (empty($_GET["fBiasVoltageMedian"]))
+            $_GET["fBiasVoltageMedian"]=$first?"On":"";
+
+        if (empty($_GET["fRightAscension"]))
+            $_GET["fRightAscension"]=$first?"On":"";
+
+        if (empty($_GET["fDeclination"]))
+            $_GET["fDeclination"]=$first?"On":"";
+
     }
 
@@ -241 +257 @@
         CheckBox("fMd5sumRaw",         "md5");
         CheckBox("fMd5sumRawZip",      "md5(gz)");
+
+        printf("  </tr>\n");
+        printf("  <tr>\n");
+
+        CheckBox("fTriggerRateMedian",    "mean rate");
+        CheckBox("fThresholdMedian",    "mean threshold");
+        CheckBox("fBiasVoltageMedian",    "mean voltage");
+        CheckBox("fRightAscension",    "RA");
+        CheckBox("fDeclination",    "Dec");
 
         printf("  </tr>\n");