projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
fix error on detail for "tax collected" on vendor tax report, RT#12320
[freeside.git]
/
httemplate
/
search
/
svc_acct.cgi
diff --git
a/httemplate/search/svc_acct.cgi
b/httemplate/search/svc_acct.cgi
index
1407d9e
..
c3ddd66
100755
(executable)
--- a/
httemplate/search/svc_acct.cgi
+++ b/
httemplate/search/svc_acct.cgi
@@
-262,13
+262,13
@@
if ( $cgi->param('magic') =~ /^(all|unlinked)$/ ) {
}
$cgi->param('username') =~ /^([\w\-\.\&]+)$/; #untaint username_text
}
$cgi->param('username') =~ /^([\w\-\.\&]+)$/; #untaint username_text
- my $username =
$1
;
+ my $username =
lc($1)
;
- push @username_sql, "
username I
LIKE '$username'"
+ push @username_sql, "
LOWER(username)
LIKE '$username'"
if $username_type{'Exact'}
|| $username_type{'Fuzzy'};
if $username_type{'Exact'}
|| $username_type{'Fuzzy'};
- push @username_sql, "
username I
LIKE '\%$username\%'"
+ push @username_sql, "
LOWER(username)
LIKE '\%$username\%'"
if $username_type{'Substring'}
|| $username_type{'All'};
if $username_type{'Substring'}
|| $username_type{'All'};