Changeset 8467 for trunk/MagicSoft/Mars/datacenter/db/ganymed.php

Timestamp:

04/28/07 23:07:56 (17 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/ganymed.php (modified) (6 diffs)

trunk/MagicSoft/Mars/datacenter/db/ganymed.php

@@ -6 +6 @@
         //datasets (0-3)
         $query0 .= " DataSets.fDataSetNumber, fDataSetName, fComment, ";//0,1,2
-        $query0 .= " fSourceName, ";//3
-        //steps (4-7)
-        $query0 .= " fDataSetInserted, fStarFilesAvail, ";//4,5
-        $query0 .= " fGanymed, fFillGanymed, ";//6,7
-        //ganymed (8-13)
-        $query0 .= " fExcessEvents, fBackgroundEvents, fSignalEvents, ";//8,9,10
-        $query0 .= " fSignificance, fScaleFactor, fEffOnTime/3600 ";//11,12,13
+        $query0 .= " fSourceName, fObservationModeName, ";//3, 4
+        //steps (5-8)
+        $query0 .= " fDataSetInserted, fStarFilesAvail, ";//5,6
+        $query0 .= " fGanymed, fFillGanymed, ";//7,8
+        //ganymed (9-14)
+        $query0 .= " fExcessEvents, fBackgroundEvents, fSignalEvents, ";//9,10,11
+        $query0 .= " fSignificance, fScaleFactor, fEffOnTime/3600 ";//12,13, 14
 
         $query0 .= " FROM DataSets ";
 
         $query0 .= " LEFT JOIN Source ON DataSets.fSourceKEY=Source.fSourceKEY ";
+        $query0 .= " LEFT JOIN ObservationMode ON DataSets.fObservationModeKEY=ObservationMode.fObservationModeKEY ";
         $query0 .= " LEFT JOIN DataSetProcessStatus ON DataSets.fDataSetNumber=DataSetProcessStatus.fDataSetNumber ";
         $query0 .= " LEFT JOIN Ganymed ON DataSets.fDataSetNumber=Ganymed.fDataSetNumber ";
@@ -163 +164 @@
             $comment=mysql_result($result0, $i, 2);
             $source=mysql_result($result0, $i, 3);
-            $inserted=mysql_result($result0, $i, 4);
-            $filesavail=mysql_result($result0, $i, 5);
-            $ganymed=mysql_result($result0, $i, 6);
-            $fillganymed=mysql_result($result0, $i, 7);
-            $excess=mysql_result($result0, $i, 8);
-            $bg=mysql_result($result0, $i, 9);
-            $signal=mysql_result($result0, $i, 10);
-            $signif=mysql_result($result0, $i, 11);
-            $scale=mysql_result($result0, $i, 12);
-            $effontime=mysql_result($result0, $i, 13);
+            $wobble=mysql_result($result0, $i, 4);
+            $inserted=mysql_result($result0, $i, 5);
+            $filesavail=mysql_result($result0, $i, 6);
+            $ganymed=mysql_result($result0, $i, 7);
+            $fillganymed=mysql_result($result0, $i, 8);
+            $excess=mysql_result($result0, $i, 9);
+            $bg=mysql_result($result0, $i, 10);
+            $signal=mysql_result($result0, $i, 11);
+            $signif=mysql_result($result0, $i, 12);
+            $scale=mysql_result($result0, $i, 13);
+            $effontime=mysql_result($result0, $i, 14);
             $num=sprintf("%08d",$datasetno);
             $num2=substr($num,0,5);
@@ -184 +186 @@
             printf(" <a href=\"%s\">%s</a>) </th>", $datasetfile, $datasetno);
             printf(" </tr><tr BGCOLOR='#E0E0E0' ALIGN='left'>\n");
-            printf(" <th colspan=\"6\"> %s ", $comment);
+            printf(" <th colspan=\"6\"> <b>%s Mode</b>, %s ", $wobble, $comment);
             printf(" </th></tr><tr>\n");
 
@@ -250 +252 @@
             printf("<tr><td colspan=\"6\">\n Plots: ");
 
-            if ($wobble=='Y')
+            if ($wobble=='Wobble')
                 $tabs=$ganymedtabsw;
             else
@@ -323 +325 @@
     else
     {
-        echo (file_get_contents("index-header.html"));
+        if (empty($_GET["fPrintTable"]))
+            echo (file_get_contents("index-header.html"));
 
         $environment = sizeof($_GET);
@@ -341 +344 @@
         }
 
-        echo (file_get_contents("index-footer.html"));
+        if (empty($_GET["fPrintTable"]))
+            echo (file_get_contents("index-footer.html"));
     }