X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=bin%2Fimport-optigold.pl;h=a251b2322116053c6d3b2eb2a3d164ce9fe48ecc;hp=b254b5c62e68f58842ca5b7a8b694ba7a809270b;hb=793956b8a0c19d7d39103e94235b0ca13f0f3e84;hpb=4267d5656908897b16a6bd2cca6c571b88a23427 diff --git a/bin/import-optigold.pl b/bin/import-optigold.pl index b254b5c62..a251b2322 100755 --- a/bin/import-optigold.pl +++ b/bin/import-optigold.pl @@ -1,7 +1,7 @@ #!/usr/bin/perl -Tw use strict; -use DBI; +use FS::DBI; use HTML::TableParser; use Date::Parse; use Text::CSV_XS; @@ -60,7 +60,7 @@ my @args = ( ); -$s_dbh = DBI->connect($s_dbname, $s_dbuser, $s_dbpass, +$s_dbh = FS::DBI->connect($s_dbname, $s_dbuser, $s_dbpass, { 'AutoCommit' => 0, 'ChopBlanks' => 1, 'ShowErrorStatement' => 1 @@ -393,7 +393,7 @@ part_pkg => { 'stable' => 'product', }, 'comment' => 'product_id', 'freq' => sub { pkg_freq(shift) }, - 'recur' => sub { my $href = shift; + 'recur_fee'=> sub { my $href = shift; my $price = ( pkg_freq($href) ? $href->{'unit_price'} : 0 @@ -448,7 +448,7 @@ part_pkg => { 'stable' => 'product', $part_pkg->$_(''); ($_ => $v); } - qw (setup recur) + qw (setup_fee recur_fee) }; my $error = $part_pkg->insert(options=>$options); @@ -764,7 +764,7 @@ cust_pkg => { 'stable' => 'billcycle', if ($pkg && ($pkg->freq + 0)) { my $recur = 0; - $pkg->recur =~ /\s*(\S[\S ]*?)\s*$/ && ($recur = $1); + $pkg->recur_fee =~ /\s*(\S[\S ]*?)\s*$/ && ($recur = $1); $recur = eval "$recur + 0"; $pkg = '' unless $recur == $price; @@ -792,13 +792,13 @@ cust_pkg => { 'stable' => 'billcycle', my $recur = sprintf("%.2f", ($month ? $price : 0)); for (@pkgs) { my %options = $_->options; - if ($options{recur} eq $recur) { + if ($options{recur_fee} eq $recur) { $pkg = $_; last; } } - $pkghref->{recur} = $recur + $pkghref->{recur_fee} = $recur unless $pkg; my $pkg_svc = {}; @@ -821,7 +821,7 @@ cust_pkg => { 'stable' => 'billcycle', $pkg->$_(''); ($_ => $v); } - qw (setup recur) + qw (setup_fee recur_fee) }; my $error = $pkg->insert(options=>$options);