Changeset 8333

Timestamp:

02/26/07 12:59:57 (18 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/datacenter/db

Files:

• builddatasets.php (modified) (2 diffs)
• findoffdata.php (modified) (1 diff)
• include.php (modified) (1 diff)
• menu.php (modified) (1 diff)
• runinfo-aio.php (modified) (1 diff)
• sequinfo-aio.php (modified) (1 diff)

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

@@ -451 +451 @@
         printf("<p>");
         PrintSourceMenu($host,$user,$pw,$db);
-        PrintNightRangeMenu($host,$user,$pw,$db);
+        PrintNightRangeMenu($host,$user,$pw,$db, "Sequences");
         PrintStarRangeMenu($host,$user,$pw,$db);
         printf("<p>");
@@ -930 +930 @@
     $siteuser="dcdb";
 
+
     if (!isset($_SERVER['PHP_AUTH_USER']) || crypt($_SERVER['PHP_AUTH_PW'], $sitepw)!=$sitepw || $_SERVER['PHP_AUTH_USER']!=$siteuser)
     {

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

@@ -349 +349 @@
         PrintSourceMenu($host,$user,$pw,$db);
         printf("<p>\n");
-        PrintNightRangeMenu($host,$user,$pw,$db);
+        PrintNightRangeMenu($host,$user,$pw,$db, "Sequences");
         printf("<p>\n");
 

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

@@ -223 +223 @@
 
     return $max;
+}
+
+function GetMaxDate($field, $table, $host, $user, $pw, $db)
+{
+    $db_id = mysql_connect($host, $user, $pw);
+    if ($db_id==FALSE)
+    {
+            printf("mysql_connect returned the following error:<br>");
+            printf("%s<br>", mysql_error());
+            die("");
+    }
+
+    $query  = "SELECT DATE_FORMAT(if(MAX(" . $field . ")<'13:00:00', MAX(" . $field . "), ADDDATE(MAX(" . $field . "), INTERVAL +1 DAY)), '%Y-%m-%d') FROM " . $db . "." . $table;
+    $result = mysql_query($query);
+    if (!$result)
+        return "0";
+
+    $row = mysql_fetch_row($result);
+
+    $maxdate = $row[0];
+
+    mysql_free_result($result);
+    mysql_close($db_id);
+
+    return $maxdate;
 }
 

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

@@ -483 +483 @@
 }
 
-function PrintNightRangeMenu($host,$user,$pw,$db)
+function PrintNightRangeMenu($host,$user,$pw,$db, $table)
 {
     if (empty($_GET["fStartDate"]))
-        $timemin = GetMin("fRunStart", "Sequences", $host, $user, $pw, $db);
+        $timemin = GetMin("fRunStart", $table, $host, $user, $pw, $db);
     else
         $timemin = $_GET["fStartDate"];
 
     if (empty($_GET["fStopDate"]))
-        $timemax = GetMax("fRunStart", "Sequences", $host, $user, $pw, $db);
+        $timemax = GetMaxDate("fRunStart", $table, $host, $user, $pw, $db);
     else
-            $timemax = $_GET["fStopDate"];
+        $timemax = $_GET["fStopDate"];
 
     printf("Night&nbsp;(yyyy-mm-dd)&nbsp;from&nbsp;<input name=\"fStartDate\" type=\"text\" size=\"10\" maxlength=\"10\" value=\"%s\">\n", $timemin);

trunk/MagicSoft/Mars/datacenter/db/runinfo-aio.php

@@ -248 +248 @@
         printf(" <div id='ranges' style='display:none'>");
         PrintSequMenu($host,$user,$pw,$db);
-        PrintNightRangeMenu($host,$user,$pw,$db);
+        PrintNightRangeMenu($host,$user,$pw,$db, "RunData");
         printf("<p>");
         PrintZdRangeMenu($host,$user,$pw,$db);

trunk/MagicSoft/Mars/datacenter/db/sequinfo-aio.php

@@ -308 +308 @@
         printf("<p>");
         PrintSourceMenu($host,$user,$pw,$db);
-        PrintNightRangeMenu($host,$user,$pw,$db);
+        PrintNightRangeMenu($host,$user,$pw,$db, "Sequences");
         printf("<p>");
         printf("</div>");