X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fquotation_pkg.pm;h=3f6742c7997eb7005d340530439ae87e4675d3a6;hp=4c78be75c8857eeec7bee04e6e2f799f26ad74e6;hb=5372897f367498972c96f5494e142e6e11b29eb8;hpb=c14803e37f1bfdcff882ee5cb35a9b10a93a88c9 diff --git a/FS/FS/quotation_pkg.pm b/FS/FS/quotation_pkg.pm index 4c78be75c..3f6742c79 100644 --- a/FS/FS/quotation_pkg.pm +++ b/FS/FS/quotation_pkg.pm @@ -5,6 +5,7 @@ use strict; use FS::Record qw( qsearchs qsearch dbh ); use FS::part_pkg; use FS::quotation_pkg_discount; #so its loaded when TemplateItem_Mixin needs it +use FS::quotation_pkg_detail; use List::Util qw(sum); =head1 NAME @@ -100,11 +101,16 @@ sub display_table { 'quotation_pkg'; } # # (for invoice display order) sub discount_table { 'quotation_pkg_discount'; } +sub detail_table { 'quotation_pkg_detail'; } =item insert Adds this record to the database. If there is an error, returns the error, -otherwise returns false. +otherwise returns false. Accepts the following options: + +quotation_details - optional arrayref of detail strings to add (creates quotation_pkg_detail records) + +copy_on_order - value for this field when creating quotation_pkg_detail records (same for all details) =cut @@ -115,10 +121,26 @@ sub insert { my $oldAutoCommit = $FS::UID::AutoCommit; local $FS::UID::AutoCommit = 0; + #false laziness w/cust_main::Packages::order_pkg + if ( $options{'locationnum'} and $options{'locationnum'} != -1 ) { + + $self->locationnum($options{'locationnum'}); + + } elsif ( $options{'cust_location'} ) { + + my $error = $options{'cust_location'}->find_or_insert; + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return "inserting cust_location (transaction rolled back): $error"; + } + $self->locationnum($options{'cust_location'}->locationnum); + + } + my $error = $self->SUPER::insert; - if ( !$error and $self->discountnum ) { - warn "inserting discount #".$self->discountnum."\n"; + if ( !$error and ($self->setup_discountnum || $self->recur_discountnum) ) { + #warn "inserting discount\n"; $error = $self->insert_discount; $error .= ' (setting discount)' if $error; } @@ -126,10 +148,22 @@ sub insert { if ( $error ) { $dbh->rollback if $oldAutoCommit; return $error; - } else { - $dbh->commit if $oldAutoCommit; - return ''; } + + if ($options{'quotation_details'}) { + $error = $self->set_details( + details => $options{'quotation_details'}, + copy_on_order => $options{'copy_on_order'} ? 'Y' : '', + ); + if ( $error ) { + $error .= ' (setting details)'; + $dbh->rollback if $oldAutoCommit; + return $error; + } + } + + $dbh->commit if $oldAutoCommit; + return ''; } =item delete @@ -145,15 +179,21 @@ sub delete { my $oldAutoCommit = $FS::UID::AutoCommit; local $FS::UID::AutoCommit = 0; + my $error = $self->delete_details; + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return $error; + } + foreach ($self->quotation_pkg_discount, $self->quotation_pkg_tax) { - my $error = $_->delete; + $error = $_->delete; if ( $error ) { $dbh->rollback if $oldAutoCommit; return $error . ' (deleting discount)'; } } - my $error = $self->SUPER::delete; + $error = $self->SUPER::delete; if ( $error ) { $dbh->rollback if $oldAutoCommit; return $error; @@ -241,28 +281,37 @@ sub insert_discount { #my ($self, %options) = @_; my $self = shift; - my $quotation_pkg_discount = FS::quotation_pkg_discount->new( { - 'quotationpkgnum' => $self->quotationpkgnum, - 'discountnum' => $self->discountnum, - #for the create a new discount case - '_type' => $self->discountnum__type, - 'amount' => $self->discountnum_amount, - 'percent' => $self->discountnum_percent, - 'months' => $self->discountnum_months, - 'setup' => $self->discountnum_setup, - } ); - - $quotation_pkg_discount->insert; + foreach my $x (qw(setup recur)) { + if ( my $discountnum = $self->get("${x}_discountnum") ) { + my $cust_pkg_discount = FS::quotation_pkg_discount->new( { + 'quotationpkgnum' => $self->quotationpkgnum, + 'discountnum' => $discountnum, + 'setuprecur' => $x, + #for the create a new discount case + 'amount' => $self->get("${x}_discountnum_amount"), + 'percent' => $self->get("${x}_discountnum_percent"), + 'months' => $self->get("${x}_discountnum_months"), + } ); + if ( $x eq 'setup' ) { + $cust_pkg_discount->setup('Y'); + $cust_pkg_discount->months(''); + } + my $error = $cust_pkg_discount->insert; + return $error if $error; + } + } } sub _item_discount { my $self = shift; my %options = @_; my $setuprecur = $options{'setuprecur'}; + # a little different from cust_bill_pkg::_item_discount, in that this one + # is asked specifically whether to show setup or recur discounts (because + # on the quotation they're separate sections entirely) - # kind of silly treating this as multiple records, but it works, and will - # work if we allow multiple discounts at some point - my @pkg_discounts = $self->pkg_discount; + my @pkg_discounts = grep { $_->setuprecur eq $setuprecur } + $self->pkg_discount; return if @pkg_discounts == 0; my @ext; @@ -275,7 +324,7 @@ sub _item_discount { }; foreach my $pkg_discount (@pkg_discounts) { push @ext, $pkg_discount->description; - my $amount = $pkg_discount->get($setuprecur.'_amount'); + my $amount = $pkg_discount->get('amount'); $d->{amount} -= $amount; } $d->{amount} = sprintf('%.2f', $d->{amount} * $self->quantity); @@ -285,9 +334,18 @@ sub _item_discount { sub setup { my $self = shift; - ($self->unitsetup - sum(0, map { $_->setup_amount } $self->pkg_discount)) - * ($self->quantity || 1); + return '0.00' if $self->waive_setup eq 'Y';; + my $discount_amount = sum(0, map { $_->amount } + grep { $_->setuprecur eq 'setup' } + $self->pkg_discount + ); + ($self->unitsetup - $discount_amount) * ($self->quantity || 1); + +} +sub setup_show_zero { + my $self = shift; + return $self->part_pkg->setup_show_zero; } sub setup_tax { @@ -297,8 +355,17 @@ sub setup_tax { sub recur { my $self = shift; - ($self->unitrecur - sum(0, map { $_->recur_amount } $self->pkg_discount)) - * ($self->quantity || 1) + my $discount_amount = sum(0, map { $_->amount } + grep { $_->setuprecur eq 'recur' } + $self->pkg_discount + ); + ($self->unitrecur - $discount_amount) * ($self->quantity || 1); + +} + +sub recur_show_zero { + my $self = shift; + return $self->part_pkg->recur_show_zero; } sub recur_tax { @@ -329,6 +396,85 @@ sub part_pkg_currency_option { } } +=item delete_details + +Deletes all quotation_pkgs_details associated with this pkg (see L). + +=cut + +sub delete_details { + my $self = shift; + + my $oldAutoCommit = $FS::UID::AutoCommit; + local $FS::UID::AutoCommit = 0; + my $dbh = dbh; + + foreach my $detail ( qsearch('quotation_pkg_detail',{ 'quotationpkgnum' => $self->quotationpkgnum }) ) { + my $error = $detail->delete; + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return "error removing old detail: $error"; + } + } + + $dbh->commit or die $dbh->errstr if $oldAutoCommit; + ''; + +} + +=item set_details PARAM + +Sets new quotation details for this package (see L), +removing existing details. + +Recognizes the following parameters: + +details - arrayref of strings, one for each new detail + +copy_on_order - if true, sets copy_on_order flag on new details + +If there is an error, returns the error, otherwise returns false. + +=cut + +sub set_details { + my $self = shift; + my %opt = @_; + + $opt{'details'} ||= []; + my @details = @{$opt{'details'}}; + + my $oldAutoCommit = $FS::UID::AutoCommit; + local $FS::UID::AutoCommit = 0; + my $dbh = dbh; + + my $error = $self->delete_details; + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return $error; + } + + foreach my $detail ( @details ) { + my $quotation_pkg_detail = new FS::quotation_pkg_detail { + 'quotationpkgnum' => $self->quotationpkgnum, + 'detail' => $detail, + 'copy_on_order' => $opt{'copy_on_order'} ? 'Y' : '', + }; + $error = $quotation_pkg_detail->insert; + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return "error adding new detail: $error"; + } + } + + $dbh->commit or die $dbh->errstr if $oldAutoCommit; + ''; + +} + +sub details_header { + return (); +} =item cust_bill_pkg_display [ type => TYPE ]