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

Timestamp:

06/22/09 18:40:48 (15 years ago)

Author:

aparavac

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/datacenter/db

Files:

• plotinclude.php (modified) (1 diff)
• showplots-ds.php (modified) (1 diff)
• showplots-seq.php (modified) (1 diff)
• showplots.php (modified) (1 diff)

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

@@ -197 +197 @@
 }
 
+function getinfofromdb($seq)
+{
+    include("db.php");
+
+    $db_id = mysql_pconnect($host, $user, $pw);
+    if ($db_id==FALSE)
+    {
+        printf("mysql_connect returned the following error: %s\n", mysql_error());
+        die("");
+    }
+    mysql_select_db($db);
+
+    $query0  = "SELECT fSequenceFirst ";
+    $query0 .= ", DATE_FORMAT(ADDDATE(fRunStart,Interval 12 hour), '%Y-%m-%d') as 'ObsNight'";
+    $query0 .= ", fSourceName ";
+    $query0 .= ", fZenithDistanceMin ";
+    $query0 .= ", fZenithDistanceMax ";
+    $query0 .= ", fMeanPedRmsInner ";
+    $query0 .= ", fRunTime/60 as 'UpTime' ";
+    $query0 .= ", if(isnull(fStar), 'N/A', if(isnull(fRateSumEvts), 'no', CONCAT('yes (',fRateSumEvts, ')'))) as 'Sum' ";
+    $query0 .= "FROM Sequences ";
+    $query0 .= "LEFT JOIN Source USING(fSourceKEY) ";
+    $query0 .= "LEFT JOIN Calibration USING(fSequenceFirst) ";
+    $query0 .= "LEFT JOIN Star USING(fSequenceFirst) ";
+    $query0 .= "LEFT JOIN SequenceProcessStatus USING(fSequenceFirst) ";
+    $query0 .= "WHERE fSequenceFirst=".$seq;
+
+//    echo $query0;
+
+    $result0 = mysql_query($query0, $db_id);
+    while ($row0 = mysql_fetch_assoc($result0))
+        $info="<b>".$row0["fSourceName"]."</b> ".$row0["ObsNight"]
+            ." (".$row0["UpTime"]."min)"
+            ." Zd: ".$row0["fZenithDistanceMin"]."-".$row0["fZenithDistanceMax"]
+            ." PedRmsIn: ".$row0["fMeanPedRmsInner"]
+            ." SumTrigger: ".$row0["Sum"];
+
+    mysql_free_result($result0);
+    mysql_close($db_id);
+
+    return $info;
+}
+
 function PrintType2Pulldown($type2)
 {

trunk/MagicSoft/Mars/datacenter/db/showplots-ds.php

@@ -135 +135 @@
 {
     if (in_array($seq, $sequon))
-        printf("<font color='green'>\n");
+        $color="green";
     else
-        printf("<font color='red'>\n");
-    printf("%s <img src='%s'>", $plot, $plot);
+        $color="red";
+
+    printf("<div style='color:%s' onmouseover=\"this.innerHTML='%s';style.color='black'\" onmouseout=\"this.innerHTML='%s';style.color='%s'\"> %s </div>\n", $color, getinfofromdb($seq), $plot, $color, $plot);
+    printf("<img src='%s'>\n", $plot);
 }
 else

trunk/MagicSoft/Mars/datacenter/db/showplots-seq.php

@@ -173 +173 @@
 printf("</td>\n</tr>\n<tr>\n<td align='center' colspan='3'>\n");
 if (!empty($seq))
-    printf("%s <img src='%s'>", $plot, $plot);
+{
+    printf("<div onmouseover=\"this.innerHTML='%s'\" onmouseout=\"this.innerHTML='%s'\"> %s </div>", getinfofromdb($seq), $plot, $plot);
+    printf("<img src='%s'>", $plot);
+}
 else
     printf("Choose a source and/or a range of sequences or just click 'Plot' for going through all sequences.");

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

@@ -92 +92 @@
 PrintHomeHelp();
 printf("<td align='center'>\n");
+if (!empty($seq))
+    printf("<input type='submit' value='<< %d Prev Plot' name='prev'>\n", $prev);
 printf("<input type='text' name='seq' size='10' maxlength='10' value='%s'>\n", $seq);
 PrintType2PullDown($type2);
 printf("<input type='text' name='tabnum' size='2' maxlenght='2' value='%s'>\n", $tabnum);
-printf("<input type='submit' value='Show Plot'><br>\n");
+printf("<input type='submit' value='Show Plot'>\n");
+if (!empty($seq))
+    printf("<input type='submit' value='Next Plot %d >>' name='next'>\n", $next);
+
+printf("</td>\n</tr>\n<tr>\n<td align='center' colspan='2'>\n");
 if (!empty($seq))
 {
-    printf("<input type='submit' value='<< %d Prev Plot' name='prev'>\n", $prev);
-    printf("%s \n", $plot);
-    printf("<input type='submit' value='Next Plot %d >>' name='next'>\n", $next);
+    printf("<div onmouseover=\"this.innerHTML='%s'\" onmouseout=\"this.innerHTML='%s'\"> %s </div>", getinfofromdb($seq), $plot, $plot);
+    printf("<img src='%s'>", $plot);
 }
-printf("</td>\n</tr>\n<tr>\n<td align='center' colspan='2'>\n");
-if (!empty($seq))
-    printf("<img src='%s'>", $plot);
 else
     printf("You have to insert a sequence number into the first field.");