diff options
| -rwxr-xr-x | buglist.cgi | 18 | ||||
| -rwxr-xr-x | colchange.cgi | 2 | ||||
| -rwxr-xr-x | query.cgi | 12 |
3 files changed, 3 insertions, 29 deletions
diff --git a/buglist.cgi b/buglist.cgi index a82238fe0..bc07173b0 100755 --- a/buglist.cgi +++ b/buglist.cgi @@ -118,8 +118,6 @@ proc DefCol {name k t {s ""} {q 0}} { set needquote($name) $q } -DefCol resolved_ts "bugs.resolved_ts" DateResolved bugs.resolved_ts -DefCol verified_ts "bugs.verified_ts" DateVerified bugs.verified_ts DefCol opendate "date_format(bugs.creation_ts,'Y-m-d')" Opened bugs.creation_ts DefCol changeddate "date_format(bugs.delta_ts,'Y-m-d')" Changed bugs.delta_ts DefCol severity "substring(bugs.bug_severity, 1, 3)" Sev bugs.bug_severity @@ -186,7 +184,7 @@ if {[info exists FORM(sql)]} { set legal_fields { bug_id product version rep_platform op_sys bug_status resolution priority bug_severity assigned_to reporter - bug_file_loc component resolved_ts verified_ts} + bug_file_loc component} foreach field [array names FORM] { if { [ lsearch $legal_fields $field ] != -1 && ![cequal $FORM($field) ""]} { @@ -197,18 +195,6 @@ if {[info exists FORM(sql)]} { qadd "\t\t${or}bugs.$field = [DBNameToIdAndCheck $p]\n" set or "or " } - } elseif { $field == "resolved_ts"} { - if {! [cequal $FORM(resolved_ts_2) ""]} { - qadd "\t\tbugs.resolved_ts between \n\t\t\tTO_DATE('$FORM($field)','DD-MON-YY') and\n \t\t\tTO_DATE('$FORM(resolved_ts_2)', 'DD-MON-YY')\n" - } else { - qadd "\t\tTO_CHAR (bugs.resolved_ts,'DD-MON-YY') = '[string toupper $FORM($field)]'\n" - } - } elseif { $field == "verified_ts"} { - if {! [cequal $FORM(verified_ts_2) ""]} { - qadd "\t\tbugs.verified_ts between \n\t\t\tTO_DATE('$FORM($field)','DD-MON-YY') and\n \t\t\tTO_DATE('$FORM(verified_ts_2)', 'DD-MON-YY')\n" - } else { - qadd "\t\tTO_CHAR (bugs.verified_ts,'DD-MON-YY') = '[string toupper $FORM($field)]'\n" - } } else { foreach v $MFORM($field) { if {[cequal $v "(empty)"]} { @@ -418,7 +404,7 @@ set env(TZ) PST8PDT PutHeader "Bug List" "Bug List" puts -nonewline " -<CENTER><H1>M<font -= 2>OZILLA</font> B<font -= 2>UGS</font></H1> +<CENTER> <B>[fmtclock [getclock ]]</B>" if {[info exists FORM(debug)]} { puts "<PRE>$query</PRE>" } diff --git a/colchange.cgi b/colchange.cgi index 35580be9c..0b137f8eb 100755 --- a/colchange.cgi +++ b/colchange.cgi @@ -27,7 +27,7 @@ puts "Content-type: text/html" # they get displayed in. set masterlist {opendate changeddate severity priority platform owner reporter status - resolution component product version project os summary summaryfull resolved_ts verified_ts} + resolution component product version project os summary summaryfull } if {[info exists FORM(rememberedquery)]} { @@ -173,18 +173,6 @@ puts " </tr> </table> -<table border=0><tr><td align=right> -<b><A HREF=\"bug_status.html#resolved_ts\">Date Resolved</a>:</b> </td> -<td align=left><INPUT NAME=resolved_ts SIZE=9> (to <INPUT NAME=resolved_ts_2 SIZE=9>, optional)</td> -</tr> -<tr> -<td align=right><b><A HREF=\"bug_status.html#resolved_ts\">Date Verified</a>:</b> </td> -<td align=left><INPUT NAME=verified_ts SIZE=9> (to <INPUT NAME=verified_ts_2 SIZE=9>, optional) -<font size=-1> date format: 24-FEB-98</font> -</td> -</tr> -</table> - <table border=0> <tr> <td align=right>Summary:</td> |