diff options
author | Ivan Kohler <ivan@freeside.biz> | 2013-07-31 03:36:14 -0700 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2013-07-31 03:36:14 -0700 |
commit | f264598260908d2442fe1aed2ce3784ce51254e6 (patch) | |
tree | bd0f6efc5b41c49084a9d193a59c3e4a7672ba81 /FS/FS/vend_bill.pm | |
parent | 449e3c3b4fe9b4f55950951c0ecc7aaf954e2212 (diff) |
simple A/P
Diffstat (limited to 'FS/FS/vend_bill.pm')
-rw-r--r-- | FS/FS/vend_bill.pm | 234 |
1 files changed, 234 insertions, 0 deletions
diff --git a/FS/FS/vend_bill.pm b/FS/FS/vend_bill.pm new file mode 100644 index 0000000..cd20f95 --- /dev/null +++ b/FS/FS/vend_bill.pm @@ -0,0 +1,234 @@ +package FS::vend_bill; + +use strict; +use base qw( FS::Record ); +use FS::Record qw( dbh qsearch qsearchs ); +use FS::vend_main; +use FS::vend_pay; +use FS::vend_bill_pay; + +=head1 NAME + +FS::vend_bill - Object methods for vend_bill records + +=head1 SYNOPSIS + + use FS::vend_bill; + + $record = new FS::vend_bill \%hash; + $record = new FS::vend_bill { 'column' => 'value' }; + + $error = $record->insert; + + $error = $new_record->replace($old_record); + + $error = $record->delete; + + $error = $record->check; + +=head1 DESCRIPTION + +An FS::vend_bill object represents a vendor invoice or payable. FS::vend_bill +inherits from FS::Record. The following fields are currently supported: + +=over 4 + +=item vendbillnum + +primary key + +=item vendnum + +vendnum + +=item _date + +_date + +=item charged + +charged + + +=back + +=head1 METHODS + +=over 4 + +=item new HASHREF + +Creates a new record. To add the record to the database, see L<"insert">. + +Note that this stores the hash reference, not a distinct copy of the hash it +points to. You can ask the object for a copy with the I<hash> method. + +=cut + +# the new method can be inherited from FS::Record, if a table method is defined + +sub table { 'vend_bill'; } + +=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; + + my $oldAutoCommit = $FS::UID::AutoCommit; + local $FS::UID::AutoCommit = 0; + my $dbh = dbh; + + my $error = $self->SUPER::insert; + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return "inserting vend_bill: $error"; + } + + #magically auto-inserting for the simple case + my $vend_pay = new FS::vend_pay { + 'vendnum' => $self->vendnum, + 'vendbillnum' => $self->vendbillnum, + '_date' => $self->get('payment_date') || $self->_date, + 'paid' => $self->charged, + }; + + $error = $vend_pay->insert; + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return "auto-inserting vend_pay: $error"; + } + + $dbh->commit or die $dbh->errstr if $oldAutoCommit; + ''; + +} + +=item delete + +Delete this record from the database. + +=cut + +sub delete { + my $self = shift; + + my $oldAutoCommit = $FS::UID::AutoCommit; + local $FS::UID::AutoCommit = 0; + my $dbh = dbh; + + foreach my $vend_bill_pay ( $self->vend_bill_pay ) { + my $error = $vend_bill_pay->delete; + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return $error; + } + } + + my $error = $self->SUPER::delete; + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return $error; + } + + $dbh->commit or die $dbh->errstr if $oldAutoCommit; + ''; + +} + +=item replace OLD_RECORD + +Replaces the OLD_RECORD with this one in the database. If there is an error, +returns the error, otherwise returns false. + +=item check + +Checks all fields to make sure this is a valid record. If there is +an error, returns the error, otherwise returns false. Called by the insert +and replace methods. + +=cut + +sub check { + my $self = shift; + + my $error = + $self->ut_numbern('vendbillnum') + || $self->ut_foreign_key('vendnum', 'vend_main', 'vendnum') + || $self->ut_numbern('_date') + || $self->ut_money('charged') + ; + return $error if $error; + + $self->SUPER::check; +} + +=item vend_main + +=cut + +sub vend_main { + my $self = shift; + qsearchs('vend_main', { 'vendnum', $self->vendnum }); +} + +=item vend_bill_pay + +=cut + +sub vend_bill_pay { + my $self = shift; + qsearch('vend_bill_pay', { 'vendbillnum', $self->vendbillnum }); +} + +=item search + +=cut + +sub search { + my ($class, $param) = @_; + + my @where = (); + + #_date + if ( $param->{_date} ) { + my($beginning, $ending) = @{$param->{_date}}; + + push @where, "vend_bill._date >= $beginning", + "vend_bill._date < $ending"; + } + + my $extra_sql = scalar(@where) ? ' WHERE '. join(' AND ', @where) : ''; + + #my $count_query = "SELECT COUNT(*) FROM vend_bill $addl_from $extra_sql"; + my $count_query = "SELECT COUNT(*), SUM(charged) FROM vend_bill $extra_sql"; + + +{ + 'table' => 'vend_bill', + #'select' => $select, + #'addl_from' => $addl_from, + 'hashref' => {}, + 'extra_sql' => $extra_sql, + 'order_by' => 'ORDER BY _date', + 'count_query' => $count_query, + #'extra_headers' => \@extra_headers, + #'extra_fields' => \@extra_fields, + }; +} + +=back + +=head1 BUGS + +=head1 SEE ALSO + +L<FS::Record>, schema.html from the base documentation. + +=cut + +1; + |