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> | 
