diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2015-09-23 13:16:36 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2015-09-23 13:16:36 -0700 |
| commit | 26876f94289244e0e3b8645f895265fdf2992490 (patch) | |
| tree | 630231dbd8c210751fe8b8abb287d54a20dd8709 /FS/bin/freeside-cdr-a2billing-import | |
| parent | f0beed098a1b03f5e7d7e00624053019f635f158 (diff) | |
import a2billing username as charged_party, RT#32909
Diffstat (limited to 'FS/bin/freeside-cdr-a2billing-import')
| -rwxr-xr-x | 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 100755 --- 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'") ; |