Changeset 9168


Ignore:
Timestamp:
Nov 16, 2008, 6:16:14 PM (12 years ago)
Author:
dorner
Message:
*** empty log message ***
Location:
trunk/MagicSoft/Mars
Files:
4 edited

Legend:

Unmodified
Added
Removed
  • trunk/MagicSoft/Mars/Changelog

    r9167 r9168  
    1818
    1919                                                 -*-*- END OF LINE -*-*-
     20
     21 2008/11/16 Daniela Dorner
     22
     23   * datacenter/db/menu.php, datacenter/db/sequinfo-aio.php:
     24     - added option to query only sumtrigger data
     25
     26
    2027
    2128 2008/11/14 Daniela Dorner
  • trunk/MagicSoft/Mars/NEWS

    r9160 r9168  
    2828     ('-' button at beginning of each line) and get all lines back
    2929     ('+' at top of the column)
     30
     31   * Websites: added option to query only sequences containing sumtrigger
     32     events
    3033
    3134 ;automatic analyis
  • trunk/MagicSoft/Mars/datacenter/db/menu.php

    r9106 r9168  
    120120
    121121    CheckBox("fSequenceLast",      "Last run");
    122 
    123     printf("  </tr><tr>\n");
    124 
    125122    CheckBox("fLinks",             "Links");
     123
     124    printf("  </tr><tr>\n");
     125
     126    CheckBox("fOnlySum",           "only sumtrigger");
    126127    CheckBox("fTest",              "incl. TestSources");
    127128    CheckBox("fOff",               "incl. offsources");
  • trunk/MagicSoft/Mars/datacenter/db/sequinfo-aio.php

    r9151 r9168  
    7575                foreach ($_GET as $key => $element)
    7676                    if ($_GET[$key]=="On")
    77                         if ($key!="fLinks" && $key!="fOff" && $key!="fOnlyOff")
     77                        if ($key!="fLinks" && $key!="fOff" && $key!="fOnlyOff" && $key!="fOnlySum")
    7878                            if (empty($checkwhere[$key]) || $checkwhere[$key]==0)
    7979                                $query0 .= ", " . $key . " as '" . $alias[$key] . "' ";
     
    116116
    117117            $query0 .= " fSourceName like '%Off%'";
     118        }
     119
     120        if ($_GET["fOnlySum"]=="On")
     121        {
     122            if (strpos($query0, " WHERE ")==FALSE)
     123                $query0 .= " WHERE ";
     124            else
     125                $query0 .= " AND ";
     126
     127            $query0 .= " NOT ISNULL(fRateSumEvts) ";
    118128        }
    119129
     
    282292        if (empty($_GET["fOnlyOff"]))
    283293            $_GET["fOnlyOff"]=$first?"Off":"";
     294
     295        if (empty($_GET["fOnlySum"]))
     296            $_GET["fOnlySum"]=$first?"Off":"";
    284297
    285298        InitFindOffData($_GET, $first);
Note: See TracChangeset for help on using the changeset viewer.