diff options
author | ivan <ivan> | 2001-09-01 20:11:07 +0000 |
---|---|---|
committer | ivan <ivan> | 2001-09-01 20:11:07 +0000 |
commit | cdd5aa1d86cd5b266e02bed58570c97c2d7698ba (patch) | |
tree | f83c2929f38cc9c334332059afe7afec338f6796 /FS/FS/cust_bill_pay.pm | |
parent | d70e3f97ae64081dc724c77e64d71f3747fdddf1 (diff) |
cust_bill_pay and cust_credit_refund.
payments can apply to multiple invoices and refunds can apply to multiple
credits.
Diffstat (limited to 'FS/FS/cust_bill_pay.pm')
-rw-r--r-- | FS/FS/cust_bill_pay.pm | 190 |
1 files changed, 190 insertions, 0 deletions
diff --git a/FS/FS/cust_bill_pay.pm b/FS/FS/cust_bill_pay.pm new file mode 100644 index 0000000..045a949 --- /dev/null +++ b/FS/FS/cust_bill_pay.pm @@ -0,0 +1,190 @@ +package cust_bill_pay; + +use strict; +use vars qw( @ISA ); +use FS::Record qw( qsearch qsearchs dbh ); +#use FS::cust_bill + +@ISA = qw( FS::Record ); + +=head1 NAME + +FS::cust_bill_pay - Object methods for cust_bill_pay records + +=head1 SYNOPSIS + + use FS::cust_bill_pay; + + $record = new FS::cust_bill_pay \%hash; + $record = new FS::cust_bill_pay { 'column' => 'value' }; + + $error = $record->insert; + + $error = $new_record->replace($old_record); + + $error = $record->delete; + + $error = $record->check; + +=head1 DESCRIPTION + +An FS::cust_bill_pay object represents the application of a payment to a +specific invoice. FS::cust_bill_pay inherits from FS::Record. The following +fields are currently supported: + +=over 4 + +=item billpaynum - primary key (assigned automatically) + +=item invnum - Invoice (see L<FS::cust_bill>) + +=item paynum - Payment (see L<FS::cust_pay>) + +=item amount - Amount of the payment to apply to the specific invoice. + +=item _date - specified as a UNIX timestamp; see L<perlfunc/"time">. Also see +L<Time::Local> and L<Date::Parse> for conversion functions. + +=back + +=head1 METHODS + +=over 4 + +=item new HASHREF + +Creates a new record. To add the record to the database, see L<"insert">. + +=cut + +sub table { 'cust_bill_pay'; } + +=item insert + +Adds this record to the database. If there is an error, returns the error, +otherwise returns false. + +=cut + +sub insert { + my $self = shift; + + local $SIG{HUP} = 'IGNORE'; + local $SIG{INT} = 'IGNORE'; + local $SIG{QUIT} = 'IGNORE'; + local $SIG{TERM} = 'IGNORE'; + local $SIG{TSTP} = 'IGNORE'; + local $SIG{PIPE} = 'IGNORE'; + + my $oldAutoCommit = $FS::UID::AutoCommit; + local $FS::UID::AutoCommit = 0; + my $dbh = dbh; + + my $error = $self->check; + return $error if $error; + + $error = $self->SUPER::insert; + + my $cust_pay = qsearchs('cust_pay', { 'paynum' => $self->paynum } ) or do { + $dbh->rollback if $oldAutoCommit; + return "unknown cust_pay.paynum: ". $self->paynum; + }; + + my $pay_total = 0; + $pay_total += $_ foreach map { $_->amount } + qsearch('cust_bill_pay', { 'paynum' => $self->paynum } ); + + if ( $pay_total > $cust_pay->paid ) { + $dbh->rollback if $oldAutoCommit; + return "total cust_bill_pay.amount $pay_total for paynum ". $self->paynum. + " greater than cust_pay.paid ". $cust_pay->paid; + } + + my $cust_bill = qsearchs('cust_bill', { 'invnum' => $self->invnum } ) or do { + $dbh->rollback if $oldAutoCommit; + return "unknown cust_bill.invnum: ". $self->invnum; + }; + + my $bill_total = 0; + $bill_total += foreach map { $_->amount } + qsearch('cust_bill_pay', { 'invnum' => $self->invnum } ); +# $bill_total += foreach map { $_->amount } +# qsearch('cust_credit_bill', { 'invnum' => $self->invnum } ); + if ( $bill_total > $cust_bill->charged ) { + $dbh->rollback if $oldAutoCommit; + return "total cust_bill_pay.amount and cust_credit_bill.amount $bill_total". + "for invnum ". $self->invnum. + " greater than cust_bill.charged ". $cust_bill->charged; + } + + $dbh->commit or die $dbh->errstr if $oldAutoCommit; + + ''; +} + +=item delete + +Currently unimplemented (accounting reasons). + +=cut + +sub delete { + return "Can't (yet?) delete cust_bill_pay records!"; +} + +=item replace OLD_RECORD + +Currently unimplemented (accounting reasons). + +=cut + +sub replace { + return "Can't (yet?) modify cust_bill_pay records!"; +} + +=item check + +Checks all fields to make sure this is a valid payment. If there is an error, +returns the error, otherwise returns false. Called by the insert method. + +=cut + +sub check { + my $self = shift; + + my $error = + $self->ut_numbern('billpaynum') + || $self->ut_number('invnum') + || $self->ut_numner('paynum') + || $self->ut_money('amount') + || $self->ut_numbern('_date') + ; + return $error if $error; + + $self->_date(time) unless $self->_date; + + + ''; #no error +} + +=back + +=head1 VERSION + +$Id: cust_bill_pay.pm,v 1.1 2001-09-01 20:11:07 ivan Exp $ + +=head1 BUGS + +Delete and replace methods. + +cust_credit_bill isn't checked yet (uncomment around line 111) + +=head1 SEE ALSO + +L<FS::cust_pay>, L<FS::cust_bill>, L<FS::Record>, schema.html from the +base documentation. + +=cut + +1; + |