projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
d22004d
)
asterisk v12 CDRs, RT#71704
author
Ivan Kohler
<ivan@freeside.biz>
Tue, 21 Mar 2017 15:52:29 +0000
(08:52 -0700)
committer
Ivan Kohler
<ivan@freeside.biz>
Tue, 21 Mar 2017 15:52:29 +0000
(08:52 -0700)
FS/bin/freeside-cdr-asterisk_sql
patch
|
blob
|
history
diff --git
a/FS/bin/freeside-cdr-asterisk_sql
b/FS/bin/freeside-cdr-asterisk_sql
index
6e63ff0
..
529ec9b
100755
(executable)
--- a/
FS/bin/freeside-cdr-asterisk_sql
+++ b/
FS/bin/freeside-cdr-asterisk_sql
@@
-104,17
+104,17
@@
while ( my $row = $sth->fetchrow_hashref ) {
$imports++;
$imports++;
- my $
where = ''
;
+ my $
usql = "UPDATE $table SET freesidestatus = 'done' WHERE "
;
my @args = ();
if ( $opt{V} >= 12 ) {
my @args = ();
if ( $opt{V} >= 12 ) {
- $
where = '
id = '. $row->{'id'};
+ $
usql .= '
id = '. $row->{'id'};
@args = ( undef );
} else {
@args = ( undef );
} else {
- $
where = '
calldate = ? AND src = ? AND dst = ?';
+ $
usql .= '
calldate = ? AND src = ? AND dst = ?';
@args = ( undef, $row->{'calldate'}, $row->{'src'}, $row->{'dst'}, );
}
@args = ( undef, $row->{'calldate'}, $row->{'src'}, $row->{'dst'}, );
}
- if ( $dbi->do(
"UPDATE $table SET freesidestatus = 'done' $where"
, @args) ) {
+ if ( $dbi->do(
$usql
, @args) ) {
$updates++;
} else {
warn "failed to set status: ".$dbi->errstr."\n";
$updates++;
} else {
warn "failed to set status: ".$dbi->errstr."\n";