diff options
| author | Mark Wells <mark@freeside.biz> | 2016-09-06 16:08:39 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2016-09-06 16:08:54 -0700 |
| commit | 04c0344d3c8dd9dcbeb0fdbf7b872eb86615e14e (patch) | |
| tree | c7928fccfb1a8fcf4833638a9db567e1a54defaf /bin | |
| parent | 91a6e5e58df70ffad1234cb80ab76eaeaf8359b9 (diff) | |
fix for #72355
Diffstat (limited to 'bin')
| -rwxr-xr-x | bin/taqua-accountcode-rewrite | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/bin/taqua-accountcode-rewrite b/bin/taqua-accountcode-rewrite index 97e0a46..386fc9d 100755 --- a/bin/taqua-accountcode-rewrite +++ b/bin/taqua-accountcode-rewrite @@ -2,9 +2,8 @@ my $usage = " This script is for fixing CDRs that were supposed to receive Taqua -accountcode/caller ID rewrites but didn't. It will skip records that had -any rewrites performed, but will operate on CDRs that have already been -billed. Options: +accountcode/caller ID rewrites but didn't. It will reprocess records that +were already rewritten, so use with caution. Options: -s DATE: find calls on or after DATE (required) -e DATE: find calls on or before DATE (optional, defaults to right now) @@ -25,7 +24,7 @@ die $usage unless $opt{start}; my $fixed = 0; my $notfound = 0; my $failed = 0; -my $extra_sql = 'WHERE lastapp IS NOT NULL AND freesiderewritestatus IS NULL' . +my $extra_sql = 'WHERE lastapp IS NOT NULL '. ' AND cdrtypenum = 1'. ' AND calldate >= to_timestamp('.$opt{start}.')'; if ( $opt{end} ) { |