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

Timestamp:

11/16/08 18:16:14 (16 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/datacenter/db

Files:

• menu.php (modified) (1 diff)
• sequinfo-aio.php (modified) (3 diffs)

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

@@ -120 +120 @@
 
     CheckBox("fSequenceLast",      "Last run");
-
-    printf("  </tr><tr>\n");
-
     CheckBox("fLinks",             "Links");
+
+    printf("  </tr><tr>\n");
+
+    CheckBox("fOnlySum",           "only sumtrigger");
     CheckBox("fTest",              "incl. TestSources");
     CheckBox("fOff",               "incl. offsources");

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

@@ -75 +75 @@
                 foreach ($_GET as $key => $element)
                     if ($_GET[$key]=="On")
-                        if ($key!="fLinks" && $key!="fOff" && $key!="fOnlyOff")
+                        if ($key!="fLinks" && $key!="fOff" && $key!="fOnlyOff" && $key!="fOnlySum")
                             if (empty($checkwhere[$key]) || $checkwhere[$key]==0)
                                 $query0 .= ", " . $key . " as '" . $alias[$key] . "' ";
@@ -116 +116 @@
 
             $query0 .= " fSourceName like '%Off%'";
+        }
+
+        if ($_GET["fOnlySum"]=="On")
+        {
+            if (strpos($query0, " WHERE ")==FALSE)
+                $query0 .= " WHERE ";
+            else
+                $query0 .= " AND ";
+
+            $query0 .= " NOT ISNULL(fRateSumEvts) ";
         }
 
@@ -282 +292 @@
         if (empty($_GET["fOnlyOff"]))
             $_GET["fOnlyOff"]=$first?"Off":"";
+
+        if (empty($_GET["fOnlySum"]))
+            $_GET["fOnlySum"]=$first?"Off":"";
 
         InitFindOffData($_GET, $first);