X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FUpgrade.pm;h=41349a59aeb8646492e52221301b536440ebd06e;hp=263be80b1c0f9e0cdd27c999ef4a0e0f05ad1eaf;hb=51f97ec141f77064ca020634e7eccd85d9ead753;hpb=a4d4d3df88b33a6db30b565921f6d62efb252351 diff --git a/FS/FS/Upgrade.pm b/FS/FS/Upgrade.pm index 263be80b1..41349a59a 100644 --- a/FS/FS/Upgrade.pm +++ b/FS/FS/Upgrade.pm @@ -10,6 +10,7 @@ use FS::Conf; use FS::Record qw(qsearchs qsearch str2time_sql); use FS::queue; use FS::upgrade_journal; +use FS::Setup qw( enable_banned_pay_pad ); use FS::svc_domain; $FS::svc_domain::whois_hack = 1; @@ -46,6 +47,10 @@ sub upgrade_config { my $conf = new FS::Conf; + # to simplify tokenization upgrades + die "Conf selfservice-payment_gateway no longer supported" + if $conf->config('selfservice-payment_gateway'); + $conf->touch('payment_receipt') if $conf->exists('payment_receipt_email') || $conf->config('payment_receipt_msgnum'); @@ -132,11 +137,11 @@ If you need to continue using the old Form 477 report, turn on the $conf->set($newname, 'location'); } - # boolean enable_taxproducts is now enable_taxproducts = 'cch' - if ( $conf->exists('enable_taxproducts') and - $conf->config('enable_taxproducts') eq '' ) { + # boolean enable_taxproducts is now tax_data_vendor = 'cch' + if ( $conf->exists('enable_taxproducts') ) { - $conf->set('enable_taxproducts', 'cch'); + $conf->delete('enable_taxproducts'); + $conf->set('tax_data_vendor', 'cch'); } @@ -146,6 +151,47 @@ If you need to continue using the old Form 477 report, turn on the $conf->delete('tax-cust_exempt-groups-require_individual_nums'); } + # boolean+text previous_balance-exclude_from_total is now two separate options + my $total_new_charges = $conf->config('previous_balance-exclude_from_total'); + if (length($total_new_charges) > 0) { + $conf->set('previous_balance-text-total_new_charges', $total_new_charges); + $conf->set('previous_balance-exclude_from_total', ''); + } + + # switch from specifying an email address to boolean check + if ( $conf->exists('batch-errors_to') ) { + $conf->touch('batch-errors_not_fatal'); + $conf->delete('batch-errors_to'); + } + + if ( $conf->exists('voip-cust_email_csv_cdr') ) { + $conf->set('voip_cdr_email_attach', 'csv'); + $conf->delete('voip-cust_email_csv_cdr') ; + } + + if ($conf->exists('unsuspendauto') && !$conf->config('unsuspend_balance')) { + $conf->set('unsuspend_balance','Zero'); + $conf->delete('unsuspendauto'); + } + + if ($conf->config('cust-fields') =~ / \| Payment Type/) { + my $cust_fields = $conf->config('cust-fields'); + # so we can potentially use 'Payment Types' or somesuch in the future + $cust_fields =~ s/ \| Payment Type( \|)/$1/; + $cust_fields =~ s/ \| Payment Type$//; + $conf->set('cust-fields',$cust_fields); + } + + enable_banned_pay_pad() unless length($conf->config('banned_pay-pad')); + + # if translate-auto-insert is enabled for a locale, ensure that invoice + # terms are in the msgcat (is there a better place for this?) + if (my $auto_locale = $conf->config('translate-auto-insert')) { + my $lh = FS::L10N->get_handle($auto_locale); + foreach (@FS::Conf::invoice_terms) { + $lh->maketext($_) if length($_); + } + } } sub upgrade_overlimit_groups { @@ -177,8 +223,9 @@ sub upgrade_overlimit_groups { sub upgrade_invoice_from { my ($conf, $agentnum, $agentonly) = @_; if ( - (!$conf->exists('invoice_from_name',$agentnum,$agentonly)) && - ($conf->config('invoice_from',$agentnum,$agentonly) =~ /\<(.*)\>/) + ! $conf->exists('invoice_from_name',$agentnum,$agentonly) + && $conf->exists('invoice_from',$agentnum,$agentonly) + && $conf->config('invoice_from',$agentnum,$agentonly) =~ /\<(.*)\>/ ) { my $realemail = $1; $realemail =~ s/^\s*//; # remove leading spaces @@ -281,7 +328,7 @@ sub upgrade { # decrypt inadvertantly-encrypted payinfo where payby != CARD,DCRD,CHEK,DCHK # kind of a weird spot for this, but it's better than duplicating # all this code in each class... - my @decrypt_tables = qw( cust_main cust_pay_void cust_pay cust_refund cust_pay_pending ); + my @decrypt_tables = qw( cust_payby cust_pay_void cust_pay cust_refund cust_pay_pending ); foreach my $table ( @decrypt_tables ) { my @objects = qsearch({ 'table' => $table, @@ -309,10 +356,17 @@ sub upgrade_data { tie my %hash, 'Tie::IxHash', - #payby conditions to new ones - 'part_event_condition' => [], + #remap log levels + 'log' => [], - #cust_main (remove paycvv from history, locations, cust_payby, etc) + #fix whitespace - before cust_main + 'cust_location' => [], + + # need before cust_main tokenization upgrade, + # blocks tokenization upgrade if deprecated features still in use + 'agent_payment_gateway' => [], + + #cust_main (tokenizes cards, remove paycvv from history, locations, cust_payby, etc) 'cust_main' => [], #contact -> cust_contact / prospect_contact @@ -331,6 +385,12 @@ sub upgrade_data { #customer credits 'cust_credit' => [], + # reason / void_reason migration to reasonnum / void_reasonnum + 'cust_credit_void' => [], + 'cust_bill_void' => [], + # also fix some tax allocation records + 'cust_bill_pkg_void' => [], + #duplicate history records 'h_cust_svc' => [], @@ -377,6 +437,9 @@ sub upgrade_data { 'cust_refund' => [], 'banned_pay' => [], + #paycardtype + 'cust_payby' => [], + #default namespace 'payment_gateway' => [], @@ -424,8 +487,15 @@ sub upgrade_data { #populate state FIPS codes if not already done 'state' => [], + #set default locations on quoted packages + 'quotation_pkg' => [], + #populate tax statuses 'tax_status' => [], + + #mark certain taxes as system-maintained, + # and fix whitespace + 'cust_main_county' => [], ; \%hash; @@ -488,7 +558,9 @@ sub upgrade_schema_data { 'cust_bill_pkg_detail' => [], #add necessary columns to RT schema 'TicketSystem' => [], - + #remove possible dangling records + 'password_history' => [], + 'cust_pay_pending' => [], ; \%hash;