Changeset 7527 for trunk/MagicSoft/Mars/datacenter/db/statusrps.php

Timestamp:

02/24/06 19:12:49 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/statusrps.php (modified) (8 diffs)

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

@@ -1 +1 @@
 <?php
 {
-    function CreateQuery($_GET, $alias, $checkstatusgroup, $checkwhere)
+    function CreateQuery($_GET, $alias, $checkstatusgroup, $checkwhere, $needs)
     {
         $query0 = "SELECT ";
@@ -14 +14 @@
             foreach ($checkstatusgroup as $key => $element)
                 if ($element==-1)
-                    $query0 .= " (if(IsNull(" . $key . "), 'not done' ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $key . "', ";
+                    $query0 .= " (if(IsNull(" . $key . "), if(isnull(fStartTime), 'not done', if(isnull(fFailedTime),if(isnull(" . $needs[$key] . "),'not done',if(date_sub(Now(),interval 12 hour) < fStartTime,'running','crashed')),if(isnull(" . $needs[$key] . "),'not done','failed'))) ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $alias[$key] . "', ";
+//                    $query0 .= " (if(IsNull(" . $key . "), 'not done' ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $key . "', ";
 
             $query0 .= " count(*) as 'Run#'";
@@ -36 +37 @@
             $query0 .= " AND ";
 
-        $query0 .= StatusQuery("fCCFileAvail");
-        $query0 .= StatusQuery("fCaCoFileAvail");
-        $query0 .= StatusQuery("fCaCoFileFound");
-        $query0 .= StatusQuery("fRawFileAvail");
-        $query0 .= StatusQuery("fDataCheckDone");
-        $query0 .= StatusQuery("fTimingCorrection");
+        $query0 .= StatusQuery("fCCFileAvail", $needs);
+        $query0 .= StatusQuery("fCaCoFileAvail", $needs);
+        $query0 .= StatusQuery("fCaCoFileFound", $needs);
+        $query0 .= StatusQuery("fRawFileAvail", $needs);
+        $query0 .= StatusQuery("fDataCheckDone", $needs);
+        $query0 .= StatusQuery("fTimingCorrection", $needs);
 
         $query0 .= "fRunNumber BETWEEN " . $_GET["fRunMin"] . " AND " . $_GET["fRunMax"] . " ";
@@ -52 +53 @@
                 if ($element==-1)
                 {
-                    $query0 .= $key;
+                    $query0 .= $alias[$key];
                     if ($num-->1)
                         $query0 .= ", ";
@@ -189 +190 @@
     }
 
-    function PrintPage($html, $db, $alias, $rightalign, $checkstatusgroup, $checkwhere)
+    function PrintPage($html, $db, $alias, $rightalign, $checkstatusgroup, $checkwhere, $needs)
     {
         $db_id = mysql_connect("hercules.astro.uni-wuerzburg.de", "MAGIC", "d99swMT!");
@@ -199 +200 @@
         mysql_select_db($db);
 
-        $query0 = CreateQuery($_GET, $alias, $checkstatusgroup, $checkwhere);
+        $query0 = CreateQuery($_GET, $alias, $checkstatusgroup, $checkwhere, $needs);
 
         $result0 = mysql_query($query0, $db_id);
@@ -230 +231 @@
         header("Content-Disposition: attachment; filename=query-result.txt");
 
-        PrintPage("0", $db, $alias, $rightalign, $checkstatusgroup, $checkwhere);
+        PrintPage("0", $db, $alias, $rightalign, $checkstatusgroup, $checkwhere, $needs);
     }
     else
@@ -244 +245 @@
             printf("No query submitted yet.<BR>");
         else
-            PrintPage("1", $db, $alias, $rightalign, $checkstatusgroup, $checkwhere);
+            PrintPage("1", $db, $alias, $rightalign, $checkstatusgroup, $checkwhere, $needs);
 
         echo (file_get_contents("index-footer.html"));