diff options
author | Ivan Kohler <ivan@freeside.biz> | 2015-09-23 13:16:37 -0700 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2015-09-23 13:16:37 -0700 |
commit | c68e2488e326a85451b16a046691edcd3f58add5 (patch) | |
tree | 391b2c10b0d619fdb6054cc1cc8dbcc2cd432e64 /FS | |
parent | ddbea80d28f423a9e5ad3f879545cff4434a4ed8 (diff) |
import a2billing username as charged_party, RT#32909
Diffstat (limited to 'FS')
-rw-r--r-- | FS/bin/freeside-cdr-a2billing-import | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/FS/bin/freeside-cdr-a2billing-import b/FS/bin/freeside-cdr-a2billing-import index 923f5fbb1..a8469e744 100644 --- a/FS/bin/freeside-cdr-a2billing-import +++ b/FS/bin/freeside-cdr-a2billing-import @@ -91,7 +91,7 @@ my %disposition = ( ); my @cols = ( - 'cc_call.id as id', 'cc_card.username as username', + "$table.id as id", 'cc_card.username as username', qw( sessionid starttime stoptime sessiontime real_sessiontime terminatecauseid @@ -101,6 +101,7 @@ my @cols = ( ); my $sql = 'SELECT '.join(',', @cols). " FROM $table". + " LEFT JOIN cc_card ON ( $table.card_id = cc_card.id ) ". ' WHERE freesidestatus IS NULL' . ($start && " AND starttime >= '$start'") . ($end && " AND starttime < '$end'") ; |