Changeset 7620 for trunk/MagicSoft/Mars/datacenter/db

Timestamp:

03/21/06 04:35:34 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

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

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

@@ -132 +132 @@
     }
 
-    function PrintDataSetInfo($result0, $ganymedtabsw, $ganymedtabs)
+    function GetRanges($db_id, $sequences)
+    {
+        $query="SELECT Min(fZenithDistanceMin), Max(fZenithDistanceMax), Min(fRunStart), Max(fRunStart) FROM Sequences WHERE fSequenceFirst IN (";
+        $sequlist=str_replace(" ", ",", trim($sequences));
+//        printf("sequ-after: %s", $sequlist);
+        $query .= $sequlist . ")";
+        $result = mysql_query($query, $db_id);
+//        printf("query: %s", $query);
+        $zdmin=mysql_result($result, $i, 0);
+        $zdmax=mysql_result($result, $i, 1);
+        $starttime=str_replace("-", "/",substr(mysql_result($result, $i, 2),0,10));
+        $stoptime=str_replace("-", "/",substr(mysql_result($result, $i, 3),0,10));
+        printf("<br> Zd: %s - %s degree <br> Observationperiod: %s - %s ", $zdmin, $zdmax, $starttime, $stoptime);
+    }
+
+    function PrintDataSetInfo($db_id, $result0, $ganymedtabsw, $ganymedtabs)
     {
         $numres = mysql_num_rows($result0);
@@ -219 +234 @@
                     foreach($sequences as $key => $sequ)
                         printf("<a href=\"sequence.php?fSequenceNo=%s&fAll=On\">%s</a> ", $sequ, $sequ);
+                    GetRanges($db_id, $sequon);
                     printf("</td></tr>");
 
@@ -227 +243 @@
                         foreach($sequences as $key => $sequ)
                             printf("<a href=\"sequence.php?fSequenceNo=%s&fAll=On\">%s</a> ", $sequ, $sequ);
+                        GetRanges($db_id, $sequoff);
                         printf("</td></tr>");
                     }
@@ -278 +295 @@
         {
             if ($html=="1" || $html=="2")
-                PrintDataSetInfo($result0, $ganymedtabsw, $ganymedtabs);
+                PrintDataSetInfo($db_id, $result0, $ganymedtabsw, $ganymedtabs);
             else
                 PrintText($result0);