X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fcdr.html;h=5544ff58cf90856d91783b3cbdcf66ab214e5738;hp=702dc1bccb7c6f8c0c0aa64d64c34491213c0d56;hb=140b381af1008dad929b4d3b87aa1e54747d534f;hpb=f8f2e2063d597045cbbe16b2f7f8b973f1dde77d diff --git a/httemplate/search/cdr.html b/httemplate/search/cdr.html index 702dc1bcc..5544ff58c 100644 --- a/httemplate/search/cdr.html +++ b/httemplate/search/cdr.html @@ -147,7 +147,7 @@ foreach my $param ( grep /^termpart\d+status$/, $cgi->param ) { } ### -# src/dest/charged_party +# src/dest/charged_party/svcnum ### my $phonenum = qr/^\s*([\d\-\+\ ]+)\s*$/; @@ -175,27 +175,32 @@ if ( $cgi->param('dcontext') =~ /^\s*(.+)\s*$/ ) { push @search, "dcontext = '$dcontext'"; } -if ( $cgi->param('charged_party') =~ $phonenum ) { - ( my $charged_party = $1 ) =~ s/$x//g; - #$hashref->{'charged_party'} = $charged_party; - #push @search, "charged_party = '$charged_party'"; - #XXX countrycode +if ( $cgi->param('charged_party') ) { - my $search = " ( charged_party IN ('$charged_party', '1$charged_party') )"; + my @cp = map { $_, "1$_" } + split(/\s*,\s*/, $cgi->param('charged_party') ); + + my $search = 'charged_party IN ('. join(',', map dbh->quote($_), @cp). ')'; push @search, $search; push @qsearch, $search; } -if ( $cgi->param('charged_party_or_src') =~ $phonenum ) { - ( my $charged_party = $1 ) =~ s/$x//g; - #$hashref->{'charged_party'} = $charged_party; - #push @search, "charged_party = '$charged_party'"; - #XXX countrycode +if ( $cgi->param('charged_party_or_src') ) { - my $search = " ( charged_party IN ('$charged_party', '1$charged_party') - OR src IN ('$charged_party', '1$charged_party') )"; + my @cp = map { $_, "1$_" } + split(/\s*,\s*/, $cgi->param('charged_party_or_src') ); + my $in = join(',', map dbh->quote($_), @cp); + my $search = "( charged_party IN ($in) OR src IN ($in) )"; + + push @search, $search; + push @qsearch, $search; +} + +if ( $cgi->param('svcnum') =~ /^([\d, ]+)$/ ) { + my $svcnum = $1; + my $search = "svcnum IN ($svcnum)"; push @search, $search; push @qsearch, $search; }