Changeset 7548

Timestamp:

02/28/06 21:24:09 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars

Files:

• Changelog (modified) (1 diff)
• datacenter/db/dbstatus.php (modified) (4 diffs)
• datacenter/db/index.html (modified) (2 diffs)
• datacenter/db/queryrbk.php (modified) (2 diffs)

trunk/MagicSoft/Mars/Changelog

@@ -43 +43 @@
      - added value (relative ontime)
 
+   * datacenter/db/dbstatus.php:
+     - fixed bug
+
+   * datacenter/db/queryrbk.php:
+     - added query field 'Night', to query all entries of one night
+       from the runbook
+
 
 

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

@@ -136 +136 @@
             $query0 .= "Sequences.fSequenceFirst BETWEEN " . $_GET["fRunMin"] . " AND " . $_GET["fRunMax"] . " ";
         else
-            $query0 = substr($query0, 0, -4);
+            $query0 = substr($query0, 0, -6);
 
 /*
@@ -222 +222 @@
 
         if (empty($_GET["fAllFilesAvailStatus"]))
-            $_GET["fAllFilesAvailStatus"]="7";
+            $_GET["fAllFilesAvailStatus"]=$first?"7":"";
 
         if (empty($_GET["fCallisto"]))
@@ -228 +228 @@
 
         if (empty($_GET["fCallistoStatus"]))
-            $_GET["fCallistoStatus"]="7";
+            $_GET["fCallistoStatus"]=$first?"7":"";
 
         if (empty($_GET["fFillCallisto"]))
@@ -240 +240 @@
 
         if (empty($_GET["fStarStatus"]))
-            $_GET["fStarStatus"]="7";
+            $_GET["fStarStatus"]=$first?"7":"";
 
         if (empty($_GET["fFillStar"]))

trunk/MagicSoft/Mars/datacenter/db/index.html

@@ -43 +43 @@
 <li><A HREF="queryrbk.php">Runbook Database</A></li>
 <li><A HREF="datasetinfo.php">Dataset Information</A> 
-(<!--<A HREF="http://www.astro.uni-wuerzburg.de/~dorner/analysis/datasets.html">comments</A>, 
--->
-<A HREF="http://www.astro.uni-wuerzburg.de/datacenter/datasets/">dataset files</A>)</li>
+(<A HREF="http://www.astro.uni-wuerzburg.de/datacenter/datasets/">dataset files</A>)</li>
 <li><A HREF="ganymed.php">Results of the Automatic Analysis</A> 
 </ul>
@@ -63 +61 @@
 <li><A HREF="statussps.php">Sequence Process Status</A>: querying only the information from the table SequenceProcessStatus </li>
 <li><A HREF="printtable.php?fTable=MarsVersion">Mars Versions in the DC</A>: querying all information from the table MarsVersions </li>
-<li><A HREF="dbstatus.php?fAllFilesAvailStatus=0&fCallisto=On&fCallistoStatus=7&fStar=On&fStarStatus=7&fFillCallistoStatus=0&fFillStarStatus=0&fSourceName=On&fSourceKEY=0&fSourceN=&fStartDate=0000-00-00&fStopDate=2010-10-04&fRunMin=3340&fRunMax=64713&fNumResults=20">Processing status</A> (a simplified version of sequinfo.php)</li>
+<li><A HREF="dbstatus.php?fAllFilesAvailStatus=0&fCallisto=On&fCallistoStatus=7&fStar=On&fStarStatus=7&fFillCallistoStatus=0&fFillStarStatus=0&fSourceName=On&fSourceKEY=0">Processing status</A> (a simplified version of sequinfo.php)</li>
 </ul>
 Some very simple queries:<p>

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

@@ -19 +19 @@
         ini_set("mysql.trace_mode", "Off");
         ini_set("display_errors", "Off");
+
+        printf("Night&nbsp;(yyyy-mm-dd)&nbsp;<input name=\"fNight\" type=\"text\" size=\"10\" maxlength=\"10\" value=\"");
+        printf("%s\">&nbsp;&nbsp;&nbsp;\n", $_GET["fNight"]);
 
         printf("<input class='Width' type='submit' value='Query Table'>&nbsp;&nbsp;&nbsp;\n");
@@ -48 +51 @@
         if (!empty($_GET["fRegexp"]))
             $query0 .= "AND fRunBookText REGEXP '" . $_GET["fRegexp"] . "' ";
+
+        if (!empty($_GET["fNight"]))
+            $query0 .= "AND fRunBookDate < '" . $_GET["fNight"] . " 13:00:00' AND fRunBookDate > ADDDATE( '" . $_GET["fNight"] . " 13:00:00', INTERVAL -1 DAY) ";
 
         $query0 .= "ORDER BY fRunBookDate";