From b09958bc22d82835c95967c03f8e3f4b79ba6e8f Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Mon, 2 May 2011 16:24:50 +0000
Subject: [PATCH] lastapp searching, RT#12181

---
 httemplate/search/cdr.html        |  8 +++++++-
 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>
 
-- 
2.11.0