X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fpart_pkg_option.pm;h=2858ba788be2e136157f2777e49919b2e7a6e1bc;hb=3cbdd85a96348a287623e3b97c937c7749e99392;hp=9708f11bca7fb929396994f034b96e579f8e7e4f;hpb=bdbfd5c5a3bb7bc193b82dc39b98ae9ffe99da44;p=freeside.git diff --git a/FS/FS/part_pkg_option.pm b/FS/FS/part_pkg_option.pm index 9708f11bc..2858ba788 100644 --- a/FS/FS/part_pkg_option.pm +++ b/FS/FS/part_pkg_option.pm @@ -1,12 +1,10 @@ package FS::part_pkg_option; +use base qw(FS::Record); use strict; -use vars qw( @ISA ); -use FS::Record qw( qsearch qsearchs dbh ); +use FS::Record qw( dbh ); # qw( qsearch qsearchs dbh ); use FS::part_pkg; -@ISA = qw(FS::Record); - =head1 NAME FS::part_pkg_option - Object methods for part_pkg_option records @@ -127,11 +125,20 @@ sub check { sub _upgrade_data { # class method my ($class, %opts) = @_; - my $sql = "UPDATE part_pkg_option SETUP optionname = 'recur_fee'". + my $sql = "UPDATE part_pkg_option SET optionname = 'recur_fee'". " WHERE optionname = 'recur_flat'"; my $sth = dbh->prepare($sql) or die dbh->errstr; $sth->execute or die $sth->errstr; + $sql = "UPDATE part_pkg_option SET optionname = 'recur_method',". + "optionvalue = 'prorate' WHERE optionname = 'enable_prorate'"; + $sth = dbh->prepare($sql) or die dbh->errstr; + $sth->execute or die $sth->errstr; + + $sql = "UPDATE part_pkg_option SET optionvalue = NULL WHERE ". + "optionname = 'contract_end_months' AND optionvalue = '(none)'"; + $sth = dbh->prepare($sql) or die dbh->errstr; + $sth->execute or die $sth->errstr; ''; }