Changeset 9168 for trunk/MagicSoft/Mars/datacenter/db/sequinfo-aio.php

Timestamp:

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

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/sequinfo-aio.php (modified) (3 diffs)

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