projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
RT#42043: Check for cancelled packages with a cancellation date age option [hasnt...
[freeside.git]
/
FS
/
bin
/
freeside-cdr-a2billing-import
diff --git
a/FS/bin/freeside-cdr-a2billing-import
b/FS/bin/freeside-cdr-a2billing-import
index
923f5fb
..
a8469e7
100755
(executable)
--- a/
FS/bin/freeside-cdr-a2billing-import
+++ b/
FS/bin/freeside-cdr-a2billing-import
@@
-91,7
+91,7
@@
my %disposition = (
);
my @cols = (
);
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
qw( sessionid
starttime stoptime sessiontime real_sessiontime
terminatecauseid
@@
-101,6
+101,7
@@
my @cols = (
);
my $sql = 'SELECT '.join(',', @cols). " FROM $table".
);
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'") ;
' WHERE freesidestatus IS NULL' .
($start && " AND starttime >= '$start'") .
($end && " AND starttime < '$end'") ;