diff options
author | Ivan Kohler <ivan@freeside.biz> | 2017-03-21 08:52:29 -0700 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2017-03-21 08:52:29 -0700 |
commit | b391b1ce982eb659dcba167dc1c3a883dd437325 (patch) | |
tree | 1cf41befa3b1ed151bf8a5e7a809172f5440def0 | |
parent | d22004dc0909c8a7fca5a44aa596c4d4f590b558 (diff) |
asterisk v12 CDRs, RT#71704
-rwxr-xr-x | FS/bin/freeside-cdr-asterisk_sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/FS/bin/freeside-cdr-asterisk_sql b/FS/bin/freeside-cdr-asterisk_sql index 6e63ff008..529ec9bb9 100755 --- 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++; - my $where = ''; + my $usql = "UPDATE $table SET freesidestatus = 'done' WHERE "; my @args = (); if ( $opt{V} >= 12 ) { - $where = 'id = '. $row->{'id'}; + $usql .= ' id = '. $row->{'id'}; @args = ( undef ); } else { - $where = 'calldate = ? AND src = ? AND dst = ?'; + $usql .= ' calldate = ? AND src = ? AND 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"; |