summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorivan <ivan>2011-05-02 16:24:50 +0000
committerivan <ivan>2011-05-02 16:24:50 +0000
commitb09958bc22d82835c95967c03f8e3f4b79ba6e8f (patch)
treed2effcf3f56dba99d51c2c4e7a19ae7a82cabfac
parentfbd3dfdb6a0e9cd2a72819b935803e2945d3218a (diff)
lastapp searching, RT#12181
-rw-r--r--httemplate/search/cdr.html8
-rw-r--r--httemplate/search/report_cdr.html11
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>