Changeset 7620 for trunk/MagicSoft


Ignore:
Timestamp:
03/21/06 04:35:34 (19 years ago)
Author:
Daniela Dorner
Message:
*** empty log message ***
Location:
trunk/MagicSoft/Mars
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/MagicSoft/Mars/Changelog

    r7619 r7620  
    2323   * datacenter/db/ganymed.php,tabs.php:
    2424     - included different tabs for on/off and wobble
     25
     26   * datacenter/db/ganymed.php:
     27     - added zd angle range and observation period
    2528
    2629
  • trunk/MagicSoft/Mars/datacenter/db/ganymed.php

    r7619 r7620  
    132132    }
    133133
    134     function PrintDataSetInfo($result0, $ganymedtabsw, $ganymedtabs)
     134    function GetRanges($db_id, $sequences)
     135    {
     136        $query="SELECT Min(fZenithDistanceMin), Max(fZenithDistanceMax), Min(fRunStart), Max(fRunStart) FROM Sequences WHERE fSequenceFirst IN (";
     137        $sequlist=str_replace(" ", ",", trim($sequences));
     138//        printf("sequ-after: %s", $sequlist);
     139        $query .= $sequlist . ")";
     140        $result = mysql_query($query, $db_id);
     141//        printf("query: %s", $query);
     142        $zdmin=mysql_result($result, $i, 0);
     143        $zdmax=mysql_result($result, $i, 1);
     144        $starttime=str_replace("-", "/",substr(mysql_result($result, $i, 2),0,10));
     145        $stoptime=str_replace("-", "/",substr(mysql_result($result, $i, 3),0,10));
     146        printf("<br> Zd: %s - %s degree <br> Observationperiod: %s - %s ", $zdmin, $zdmax, $starttime, $stoptime);
     147    }
     148
     149    function PrintDataSetInfo($db_id, $result0, $ganymedtabsw, $ganymedtabs)
    135150    {
    136151        $numres = mysql_num_rows($result0);
     
    219234                    foreach($sequences as $key => $sequ)
    220235                        printf("<a href=\"sequence.php?fSequenceNo=%s&fAll=On\">%s</a> ", $sequ, $sequ);
     236                    GetRanges($db_id, $sequon);
    221237                    printf("</td></tr>");
    222238
     
    227243                        foreach($sequences as $key => $sequ)
    228244                            printf("<a href=\"sequence.php?fSequenceNo=%s&fAll=On\">%s</a> ", $sequ, $sequ);
     245                        GetRanges($db_id, $sequoff);
    229246                        printf("</td></tr>");
    230247                    }
     
    278295        {
    279296            if ($html=="1" || $html=="2")
    280                 PrintDataSetInfo($result0, $ganymedtabsw, $ganymedtabs);
     297                PrintDataSetInfo($db_id, $result0, $ganymedtabsw, $ganymedtabs);
    281298            else
    282299                PrintText($result0);
Note: See TracChangeset for help on using the changeset viewer.