tie my %cdr_svc_method, 'Tie::IxHash',
'svc_phone.phonenum' => 'Phone numbers (svc_phone.phonenum)',
'svc_pbx.title' => 'PBX name (svc_pbx.title)',
+ 'svc_pbx.svcnum' => 'Pre-matched to PBX (svc_pbx.svcnum)',
;
tie my %rating_method, 'Tie::IxHash',
) {
my $svc_x = $cust_svc->svc_x;
- foreach my $cdr (
- $svc_x->get_cdrs(
+ my %options = (
'disable_src' => $self->option('disable_src'),
'default_prefix' => $self->option('default_prefix'),
'status' => '',
'for_update' => 1,
- ) # $last_bill, $$sdate )
+ ); # $last_bill, $$sdate )
+ $options{'by_svcnum'} = 1 if $svc_field eq 'svcnum';
+
+ foreach my $cdr (
+ $svc_x->get_cdrs( %options )
) {
if ( $DEBUG > 1 ) {
warn "rating CDR $cdr\n".
=item disable_src => 1: No-op for svc_pbx CDR processing.
+=item by_svcnum => 1: Select CDRs where the svcnum field matches, instead of
+title/charged_party. Normally this field is set after processing.
+
=back
=cut
my $for_update = $options{'for_update'} ? 'FOR UPDATE' : '';
- my $title = $self->title;
+ if ( $options{'by_svcnum'} ) {
+ $hash{'svcnum'} = $self->svcnum;
+ }
+ else {
+ #matching by title
+ my $title = $self->title;
- my $prefix = $options{'default_prefix'};
+ my $prefix = $options{'default_prefix'};
- my @orwhere = map " $_ = '$title' ", @fields;
- push @orwhere, map " $_ = '$prefix$title' ", @fields
- if length($prefix);
- if ( $prefix =~ /^\+(\d+)$/ ) {
- push @orwhere, map " $_ = '$1$title' ", @fields
- }
+ my @orwhere = map " $_ = '$title' ", @fields;
+ push @orwhere, map " $_ = '$prefix$title' ", @fields
+ if length($prefix);
+ if ( $prefix =~ /^\+(\d+)$/ ) {
+ push @orwhere, map " $_ = '$1$title' ", @fields
+ }
- push @where, ' ( '. join(' OR ', @orwhere ). ' ) ';
+ push @where, ' ( '. join(' OR ', @orwhere ). ' ) ';
+ }
if ( $options{'begin'} ) {
push @where, 'startdate >= '. $options{'begin'};
push @where, 'startdate < '. $options{'end'};
}
- my $extra_sql = ( keys(%hash) ? ' AND ' : ' WHERE ' ). join(' AND ', @where );
+ my $extra_sql = ( keys(%hash) ? ' AND ' : ' WHERE ' ). join(' AND ', @where )
+ if @where;
my @cdrs =
qsearch( {