From: Ivan Kohler <ivan@freeside.biz>
Date: Mon, 30 Jun 2014 21:36:54 +0000 (-0700)
Subject: use a separate table for freesidestatus for IVR imports, RT#39055
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=d5c89b967ff6685e3e7ff363a563102f8b7ef420

use a separate table for freesidestatus for IVR imports, RT#39055
---

diff --git a/FS/FS/cdr/Import.pm b/FS/FS/cdr/Import.pm
index 472e22062..e788712c4 100644
--- a/FS/FS/cdr/Import.pm
+++ b/FS/FS/cdr/Import.pm
@@ -83,7 +83,7 @@ sub dbi_import {
   #my @cols = values %{ $args{column_map} };
   my $sql = "SELECT * FROM $table "; # join(',', @cols). " FROM $table ".
   $sql .=  'LEFT JOIN '. $args{status_table}.
-           ' USING ( '. $args{primary_key}. ' )'
+           " ON ( $table.$pkey = ". $args{status_table}. ".$pkey )"
     if $args{status_table};
   $sql .= ' WHERE freesidestatus IS NULL ';