diff options
author | ivan <ivan> | 2011-05-02 16:24:50 +0000 |
---|---|---|
committer | ivan <ivan> | 2011-05-02 16:24:50 +0000 |
commit | b09958bc22d82835c95967c03f8e3f4b79ba6e8f (patch) | |
tree | d2effcf3f56dba99d51c2c4e7a19ae7a82cabfac | |
parent | fbd3dfdb6a0e9cd2a72819b935803e2945d3218a (diff) |
lastapp searching, RT#12181
-rw-r--r-- | httemplate/search/cdr.html | 8 | ||||
-rw-r--r-- | httemplate/search/report_cdr.html | 11 |
2 files changed, 16 insertions, 3 deletions
diff --git a/httemplate/search/cdr.html b/httemplate/search/cdr.html index bf59ff625..7e6244714 100644 --- a/httemplate/search/cdr.html +++ b/httemplate/search/cdr.html @@ -182,7 +182,7 @@ if ( $cgi->param('dst') ) { if ( $cgi->param('dcontext') =~ /^\s*(.+)\s*$/ ) { my $dcontext = $1; $hashref->{'dcontext'} = $dcontext; - push @search, "dcontext = '$dcontext'"; + push @search, 'dcontext = '. dbh->quote($dcontext); } if ( $cgi->param('charged_party') ) { @@ -208,6 +208,12 @@ if ( $cgi->param('charged_party_or_src') ) { push @qsearch, $search; } +if ( $cgi->param('lastapp') =~ /^\s*(.+)\s*$/ ) { + my $lastapp = $1; + $hashref->{'lastapp'} = $lastapp; + push @search, 'lastapp = '. dbh->quote($lastapp); +} + if ( $cgi->param('svcnum') =~ /^([\d, ]+)$/ ) { my $svcnum = $1; my $search = "svcnum IN ($svcnum)"; diff --git a/httemplate/search/report_cdr.html b/httemplate/search/report_cdr.html index 866606cc1..04cd4178e 100644 --- a/httemplate/search/report_cdr.html +++ b/httemplate/search/report_cdr.html @@ -70,9 +70,16 @@ </TR> <TR> - <TD ALIGN="right">Charged Party or Source #: </TD> + <TD ALIGN="right">Last Application: </TD> <TD> - <INPUT TYPE="text" NAME="charged_party_or_src" VALUE="<% join(',', @charged_party_or_src ) |h %>" > + <INPUT TYPE="text" NAME="lastapp" VALUE="" > + </TD> + </TR> + + <TR> + <TD ALIGN="right">Freeside service #: </TD> + <TD> + <INPUT TYPE="text" NAME="svcnum" VALUE="<% join(',', @svcnum ) %>" > </TD> </TR> |