Changeset 9168

Timestamp:

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

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars

Files:

• Changelog (modified) (1 diff)
• NEWS (modified) (1 diff)
• datacenter/db/menu.php (modified) (1 diff)
• datacenter/db/sequinfo-aio.php (modified) (3 diffs)

trunk/MagicSoft/Mars/Changelog

@@ -18 +18 @@
 
                                                  -*-*- END OF LINE -*-*-
+
+ 2008/11/16 Daniela Dorner
+
+   * datacenter/db/menu.php, datacenter/db/sequinfo-aio.php:
+     - added option to query only sumtrigger data
+
+
 
  2008/11/14 Daniela Dorner

trunk/MagicSoft/Mars/NEWS

@@ -28 +28 @@
      ('-' button at beginning of each line) and get all lines back 
      ('+' at top of the column)
+
+   * Websites: added option to query only sequences containing sumtrigger 
+     events
 
  ;automatic analyis

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);