X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-cdrrewrited;h=16f931fbf0108f7c131bf21517f316db01ad6b01;hp=0b7f6883fbcd1b47eef43a56ea0a53a6c1c018ba;hb=cace897d9c5fbe1f80277b0cb14e85c9d2272cf1;hpb=0fb307c305e4bc2c9c27dc25a3308beae3a4d33c diff --git a/FS/bin/freeside-cdrrewrited b/FS/bin/freeside-cdrrewrited index 0b7f6883f..16f931fbf 100644 --- a/FS/bin/freeside-cdrrewrited +++ b/FS/bin/freeside-cdrrewrited @@ -4,7 +4,7 @@ use strict; use vars qw( $conf ); use FS::Daemon ':all'; #daemonize1 drop_root daemonize2 myexit logfile sig* use FS::UID qw( adminsuidsetup ); -use FS::Record qw( qsearch ); #qsearchs); +use FS::Record qw( qsearch qsearchs ); #use FS::cdr; #use FS::cust_pkg; #use FS::queue; @@ -24,12 +24,19 @@ daemonize2(); $conf = new FS::Conf; -die "not running; cdr-asterisk_forward_rewrite and cdr-charged_party_rewrite ". - " conf options are both off\n" +die "not running; cdr-asterisk_forward_rewrite, cdr-charged_party_rewrite ". + " and cdr-taqua-accountcode_rewrite conf options are all off\n" unless _shouldrun(); #-- +my %sessionnum_unmatch = (); +my $sessionnum_retry = 4 * 60 * 60; # 4 hours +my $sessionnum_giveup = 4 * 24 * 60 * 60; # 4 days + +my %cdr_type = map { lc($_->cdrtypename) => $_->cdrtypenum } + qsearch('cdr_type',{}); + while (1) { #hmm... don't want to do an expensive search with an ever-growing bunch @@ -37,18 +44,31 @@ while (1) { # rewritten "skipped", i.e. why we're a daemon in the first place # instead of just doing this search like normal CDRs + #hmm :/ + my @recent = grep { ($sessionnum_unmatch{$_} + $sessionnum_retry) > time } + keys %sessionnum_unmatch; + my $extra_sql = scalar(@recent) + ? ' AND acctid NOT IN ('. join(',', @recent). ') ' + : ''; + my $found = 0; + my %skip = (); + my %warning = (); + foreach my $cdr ( qsearch( { 'table' => 'cdr', 'extra_sql' => 'FOR UPDATE', 'hashref' => {}, - 'extra_sql' => 'WHERE freesidestatus IS NULL'. - ' AND freesiderewritestatus IS NULL'. + 'extra_sql' => 'WHERE freesidestatus IS NULL '. + ' AND freesiderewritestatus IS NULL '. + $extra_sql. ' LIMIT 1024', #arbitrary, but don't eat too much memory } ) ) { + next if $skip{$cdr->acctid}; + $found = 1; my @status = (); @@ -70,6 +90,45 @@ while (1) { } + # XXX weird special case stuff--can we modularize this somehow? + # reference RT#16271 + if ( $conf->exists('cdr-asterisk_australia_rewrite') and + $cdr->disposition eq 'ANSWERED' ) { + my $dst = $cdr->dst; + my $type; + if ( $dst =~ /^0?(12|13|1800|1900|0055)/ ) { + # toll free or smart numbers, any length + $type = 'tollfree'; + $cdr->charged_party($dst); + } + elsif ( $dst =~ /^(11|0011)/ ) { + # will be followed by country code + $type = 'international'; + $dst =~ s/^$1/0011/; #standardize + $cdr->dst($dst); + } + elsif ( length($dst) == 10 and$dst =~ /^04/ ) { + $type = 'mobile'; + } + elsif ( length($dst) == 10 and $dst =~ /^02|03|07|08/ ) { + $type = 'domestic'; + } + elsif ( length($dst) == 8 ) { + # local call, no area code + $type = 'domestic'; + } + else { + $type = 'other'; + } + if ( $type and exists($cdr_type{$type}) ) { + $cdr->cdrtypenum($cdr_type{$type}); + push @status, 'asterisk_australia'; + } + else { + $warning{"no CDR type defined for $type calls"}++; + } + } + if ( $conf->exists('cdr-charged_party_rewrite') && ! $cdr->charged_party ) { $cdr->set_charged_party; @@ -77,6 +136,68 @@ while (1) { } + if ( $cdr->cdrtypenum == 1 + and $cdr->lastapp + and ( + $conf->exists('cdr-taqua-accountcode_rewrite') or + $conf->exists('cdr-taqua-callerid_rewrite') ) + ) + { + + #find the matching CDR + my %search = ( 'sessionnum' => $cdr->sessionnum ); + if ( $cdr->lastapp eq 'acctcode' ) { + $search{'src'} = $cdr->subscriber; + } elsif ( $cdr->lastapp eq 'CallerId' ) { + $search{'dst'} = $cdr->subscriber; + } + my $primary = qsearchs('cdr', \%search); + + unless ( $primary ) { + + my $cantfind = "can't find primary CDR with session ". $cdr->sessionnum. + ", src ". $cdr->subscriber; + if ( $cdr->calldate_unix + $sessionnum_giveup < time ) { + warn "ERROR: $cantfind; giving up\n"; + push @status, 'taqua-sessionnum-NOTFOUND'; + $cdr->status('done'); #so it doesn't try to rate + delete $sessionnum_unmatch{$cdr->acctid}; #so it doesn't suck mem + } else { + warn "WARNING: $cantfind; will keep trying\n"; + $sessionnum_unmatch{$cdr->acctid} = time; + next; + } + + } else { + + if ( $cdr->lastapp eq 'acctcode' ) { + # lastdata contains the dialed account code + $primary->accountcode( $cdr->lastdata ); + push @status, 'taqua-accountcode'; + } elsif ( $cdr->lastapp eq 'CallerId' ) { + # lastdata contains "allowed" or "restricted" + # or case variants thereof + if ( lc($cdr->lastdata) eq 'restricted' ) { + $primary->clid( 'PRIVATE' ); + } + push @status, 'taqua-callerid'; + } else { + warn "unknown Taqua service name: ".$cdr->lastapp."\n"; + } + #$primary->freesiderewritestatus( 'taqua-accountcode-primary' ); + my $error = $primary->replace if $primary->modified; + if ( $error ) { + warn "WARNING: error rewriting primary CDR (will retry): $error\n"; + next; + } + $skip{$primary->acctid} = 1; + + $cdr->status('done'); #so it doesn't try to rate + + } + + } + $cdr->freesiderewritestatus( scalar(@status) ? join('/', @status) : 'skipped' ); @@ -89,7 +210,14 @@ while (1) { sleep 30; #i dunno, wait and see if the database comes back? } + last if sigterm() || sigint(); + + } + + foreach (sort keys %warning) { + warn "WARNING: $_ (x $warning{$_})\n"; } + %warning = (); myexit() if sigterm() || sigint(); #sleep 1 unless $found; @@ -101,7 +229,12 @@ while (1) { sub _shouldrun { $conf->exists('cdr-asterisk_forward_rewrite') - || $conf->exists('cdr-charged_party_rewrite'); + || $conf->exists('cdr-asterisk_australia_rewrite') + || $conf->exists('cdr-charged_party_rewrite') + || $conf->exists('cdr-taqua-accountcode_rewrite') + || $conf->exists('cdr-taqua-callerid_rewrite') + || 0 + ; } sub usage { @@ -118,9 +251,9 @@ freeside-cdrrewrited - Real-time daemon for CDR rewriting =head1 DESCRIPTION -Runs continuously, searches for CDRs and does forwarded-call rewriting if the -"cdr-asterisk_forward_rewrite" or "cdr-charged_party_rewrite" config option is -enabled. +Runs continuously, searches for CDRs and does forwarded-call rewriting if any +of the "cdr-asterisk_forward_rewrite", "cdr-charged_party_rewrite" or +"cdr-taqua-accountcode_rewrite" config options are enabled. =head1 SEE ALSO