diff options
| author | ivan <ivan> | 2003-11-03 05:57:28 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2003-11-03 05:57:28 +0000 |
| commit | d9c51bdc266798d01247e0ff72f6d64aefb91a2e (patch) | |
| tree | a8691e10d9bcb01f7aed083a64e25bb5086ccb6a /httemplate/search | |
| parent | de38e11cb5a40c78ef5543f59f6ce968e7fd613b (diff) | |
add suspended/canceled browse, fix the old suspended browse
Diffstat (limited to 'httemplate/search')
| -rwxr-xr-x | httemplate/search/cust_pkg.cgi | 10 |
1 files changed, 2 insertions, 8 deletions
diff --git a/httemplate/search/cust_pkg.cgi b/httemplate/search/cust_pkg.cgi index 1d54a53f6..3c3e17864 100755 --- a/httemplate/search/cust_pkg.cgi +++ b/httemplate/search/cust_pkg.cgi @@ -56,10 +56,10 @@ if ( $cgi->param('magic') && $cgi->param('magic') eq 'bill' ) { $qual = 'WHERE ( susp IS NULL OR susp = 0 )'. ' AND ( cancel IS NULL OR cancel = 0)'; } elsif ( $cgi->param('magic') eq 'suspended' ) { - $qual = 'WHERE susp IS NOT NULL AND susp > 0'. + $qual = 'WHERE susp IS NOT NULL AND susp != 0'. ' AND ( cancel IS NULL OR cancel = 0)'; } elsif ( $cgi->param('magic') eq 'canceled' ) { - $qual = 'WHERE cancel IS NOT NULL AND cancel > 0'; + $qual = 'WHERE cancel IS NOT NULL AND cancel != 0'; } else { die "guru meditation #420"; } @@ -74,12 +74,6 @@ if ( $cgi->param('magic') && $cgi->param('magic') eq 'bill' ) { $sortby=\*pkgnum_sort; - } elsif ( $query eq 'SUSP_pkgnum' ) { - - $sortby=\*pkgnum_sort; - - $qual = 'WHERE susp IS NOT NULL AND susp != 0'; - } elsif ( $query eq 'APKG_pkgnum' ) { $sortby=\*pkgnum_sort; |