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 | |
parent | 449e3c3b4fe9b4f55950951c0ecc7aaf954e2212 (diff) |
simple A/P
Diffstat (limited to 'FS')
-rw-r--r-- | FS/FS/Mason.pm | 6 | ||||
-rw-r--r-- | FS/FS/Schema.pm | 64 | ||||
-rw-r--r-- | FS/FS/class_Common.pm | 2 | ||||
-rw-r--r-- | FS/FS/vend_bill.pm | 234 | ||||
-rw-r--r-- | FS/FS/vend_bill_pay.pm | 156 | ||||
-rw-r--r-- | FS/FS/vend_class.pm | 112 | ||||
-rw-r--r-- | FS/FS/vend_main.pm | 124 | ||||
-rw-r--r-- | FS/FS/vend_pay.pm | 152 | ||||
-rw-r--r-- | FS/t/vend_bill.t | 5 | ||||
-rw-r--r-- | FS/t/vend_bill_pay.t | 5 | ||||
-rw-r--r-- | FS/t/vend_class.t | 5 | ||||
-rw-r--r-- | FS/t/vend_main.t | 5 | ||||
-rw-r--r-- | FS/t/vend_pay.t | 5 |
13 files changed, 874 insertions, 1 deletions
diff --git a/FS/FS/Mason.pm b/FS/FS/Mason.pm index 6c12e81..1d4a939 100644 --- a/FS/FS/Mason.pm +++ b/FS/FS/Mason.pm @@ -346,6 +346,12 @@ if ( -e $addl_handler_use_file ) { use FS::agent_currency; use FS::currency_exchange; use FS::part_pkg_currency; + use FS::cust_payby; + use FS::vend_main; + use FS::vend_class; + use FS::vend_bill; + use FS::vend_pay; + use FS::vend_bill_pay; # Sammath Naur if ( $FS::Mason::addl_handler_use ) { diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index b987963..2ce1794 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -236,6 +236,10 @@ sub dbdef_dist { } + my $primary_key_col = $tableobj->column($tableobj->primary_key) + or die "$table: primary key declared as ". $tableobj->primary_key. + ", but no column of that name\n"; + my $historynum_type = ( $tableobj->column($tableobj->primary_key)->type =~ /^(bigserial|bigint|int8)$/i ? 'bigserial' @@ -4258,6 +4262,66 @@ sub tables_hashref { 'index' => [ [ 'devicepart' ], [ 'svcnum' ], ], }, + 'vend_main' => { + 'columns' => [ + 'vendnum', 'serial', '', '', '', '', + 'vendname', 'varchar', '', $char_d, '', '', + 'classnum', 'int', '', '', '', '', + 'disabled', 'char', 'NULL', 1, '', '', + ], + 'primary_key' => 'vendnum', + 'unique' => [ ['vendname', 'disabled'] ], + 'index' => [], + }, + + 'vend_class' => { + 'columns' => [ + 'classnum', 'serial', '', '', '', '', + 'classname', 'varchar', '', $char_d, '', '', + 'disabled', 'char', 'NULL', 1, '', '', + ], + 'primary_key' => 'classnum', + 'unique' => [], + 'index' => [ ['disabled'] ], + }, + + 'vend_bill' => { + 'columns' => [ + 'vendbillnum', 'serial', '', '', '', '', + 'vendnum', 'int', '', '', '', '', + '_date', @date_type, '', '', + 'charged', @money_type, '', '', + ], + 'primary_key' => 'vendbillnum', + 'unique' => [], + 'index' => [ ['vendnum'], ['_date'], ], + }, + + 'vend_pay' => { + 'columns' => [ + 'vendpaynum', 'serial', '', '', '', '', + 'vendnum', 'int', '', '', '', '', + '_date', @date_type, '', '', + 'paid', @money_type, '', '', + ], + 'primary_key' => 'vendpaynum', + 'unique' => [], + 'index' => [ [ 'vendnum' ], [ '_date' ], ], + }, + + 'vend_bill_pay' => { + 'columns' => [ + 'vendbillpaynum', 'serial', '', '', '', '', + 'vendbillnum', 'int', '', '', '', '', + 'vendpaynum', 'int', '', '', '', '', + 'amount', @money_type, '', '', + #? '_date', @date_type, '', '', + ], + 'primary_key' => 'vendbillpaynum', + 'unique' => [], + 'index' => [ [ 'vendbillnum' ], [ 'vendpaynum' ] ], + }, + %{ tables_hashref_torrus() }, # tables of ours for doing torrus virtual port combining diff --git a/FS/FS/class_Common.pm b/FS/FS/class_Common.pm index 5ee8208..455cb9f 100644 --- a/FS/FS/class_Common.pm +++ b/FS/FS/class_Common.pm @@ -68,7 +68,7 @@ returns the error, otherwise returns false. =item check -Checks all fields to make sure this is a valid package classification. If +Checks all fields to make sure this is a valid classification. If there is an error, returns the error, otherwise returns false. Called by the insert and replace methods. 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; + diff --git a/FS/FS/vend_bill_pay.pm b/FS/FS/vend_bill_pay.pm new file mode 100644 index 0000000..c10c9eb --- /dev/null +++ b/FS/FS/vend_bill_pay.pm @@ -0,0 +1,156 @@ +package FS::vend_bill_pay; + +use strict; +use base qw( FS::Record ); +use FS::Record qw( dbh qsearch ); #qsearchs ); +use FS::vend_bill; +use FS::vend_pay; + +=head1 NAME + +FS::vend_bill_pay - Object methods for vend_bill_pay records + +=head1 SYNOPSIS + + use FS::vend_bill_pay; + + $record = new FS::vend_bill_pay \%hash; + $record = new FS::vend_bill_pay { 'column' => 'value' }; + + $error = $record->insert; + + $error = $new_record->replace($old_record); + + $error = $record->delete; + + $error = $record->check; + +=head1 DESCRIPTION + +An FS::vend_bill_pay object represents the application of a vendor payment to a +specific invoice or payment. FS::vend_bill_pay inherits from FS::Record. The +following fields are currently supported: + +=over 4 + +=item vendbillpaynum + +primary key + +=item vendbillnum + +vendbillnum + +=item vendpaynum + +vendpaynum + +=item amount + +amount + + +=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 + +sub table { 'vend_bill_pay'; } + +=item insert + +Adds this record to the database. If there is an error, returns the error, +otherwise returns false. + +=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; + + #magically auto-deleting for the simple case + foreach my $vend_pay ( $self->vend_pay ) { + my $error = $vend_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('vendbillpaynum') + || $self->ut_foreign_key('vendbillnum', 'vend_bill', 'vendbillnum') + || $self->ut_foreign_key('vendpaynum', 'vend_pay', 'vendpaynum') + || $self->ut_money('amount') + ; + return $error if $error; + + $self->SUPER::check; +} + +=item vend_pay + +=cut + +sub vend_pay { + my $self = shift; + qsearch('vend_pay', { 'vendpaynum', $self->vendpaynum }); +} + +=back + +=head1 BUGS + +=head1 SEE ALSO + +L<FS::Record>, schema.html from the base documentation. + +=cut + +1; + diff --git a/FS/FS/vend_class.pm b/FS/FS/vend_class.pm new file mode 100644 index 0000000..30899e5 --- /dev/null +++ b/FS/FS/vend_class.pm @@ -0,0 +1,112 @@ +package FS::vend_class; + +use strict; +use base qw( FS::class_Common ); +#use FS::Record qw( qsearch qsearchs ); + +=head1 NAME + +FS::vend_class - Object methods for vend_class records + +=head1 SYNOPSIS + + use FS::vend_class; + + $record = new FS::vend_class \%hash; + $record = new FS::vend_class { 'column' => 'value' }; + + $error = $record->insert; + + $error = $new_record->replace($old_record); + + $error = $record->delete; + + $error = $record->check; + +=head1 DESCRIPTION + +An FS::vend_class object represents a vendor class. FS::vend_class inherits +from FS::Record. The following fields are currently supported: + +=over 4 + +=item classnum + +primary key + +=item classname + +classname + +=item disabled + +disabled + + +=back + +=head1 METHODS + +=over 4 + +=item new HASHREF + +Creates a new vendor class. To add the vendor class 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 + +sub table { 'vend_class'; } + +sub _target_table { 'vend_main'; } + +=item insert + +Adds this record to the database. If there is an error, returns the error, +otherwise returns false. + +=item delete + +Delete this record from the database. + +=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 vendor class. 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('classnum') + || $self->ut_text('classname') + || $self->ut_enum('disabled', [ '', 'Y' ]) + ; + return $error if $error; + + $self->SUPER::check; +} + +=back + +=head1 BUGS + +=head1 SEE ALSO + +L<FS::Record>, schema.html from the base documentation. + +=cut + +1; + diff --git a/FS/FS/vend_main.pm b/FS/FS/vend_main.pm new file mode 100644 index 0000000..ef79c00 --- /dev/null +++ b/FS/FS/vend_main.pm @@ -0,0 +1,124 @@ +package FS::vend_main; + +use strict; +use base qw( FS::Record ); +use FS::Record qw( qsearchs ); # qsearch qsearchs ); +use FS::vend_class; + +=head1 NAME + +FS::vend_main - Object methods for vend_main records + +=head1 SYNOPSIS + + use FS::vend_main; + + $record = new FS::vend_main \%hash; + $record = new FS::vend_main { 'column' => 'value' }; + + $error = $record->insert; + + $error = $new_record->replace($old_record); + + $error = $record->delete; + + $error = $record->check; + +=head1 DESCRIPTION + +An FS::vend_main object represents a vendor. FS::vend_main inherits from +FS::Record. The following fields are currently supported: + +=over 4 + +=item vendnum + +primary key + +=item vendname + +vendname + +=item classnum + +classnum + +=item disabled + +disabled + + +=back + +=head1 METHODS + +=over 4 + +=item new HASHREF + +Creates a new vendor. To add the vendor 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 + +sub table { 'vend_main'; } + +=item insert + +Adds this record to the database. If there is an error, returns the error, +otherwise returns false. + +=item delete + +Delete this record from the database. + +=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 vendor. 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('vendnum') + || $self->ut_text('vendname') + || $self->ut_foreign_key('classnum', 'vend_class', 'classnum') + || $self->ut_enum('disabled', [ '', 'Y' ] ) + ; + return $error if $error; + + $self->SUPER::check; +} + +=item vend_class + +=cut + +sub vend_class { + my $self = shift; + qsearchs('vend_class', { 'classnum' => $self->classnum } ); +} + +=back + +=head1 BUGS + +=head1 SEE ALSO + +L<FS::Record>, schema.html from the base documentation. + +=cut + +1; + diff --git a/FS/FS/vend_pay.pm b/FS/FS/vend_pay.pm new file mode 100644 index 0000000..3216bdb --- /dev/null +++ b/FS/FS/vend_pay.pm @@ -0,0 +1,152 @@ +package FS::vend_pay; + +use strict; +use base qw( FS::Record ); +use FS::Record qw( dbh ); #qsearch qsearchs ); +use FS::vend_bill_pay; + +=head1 NAME + +FS::vend_pay - Object methods for vend_pay records + +=head1 SYNOPSIS + + use FS::vend_pay; + + $record = new FS::vend_pay \%hash; + $record = new FS::vend_pay { 'column' => 'value' }; + + $error = $record->insert; + + $error = $new_record->replace($old_record); + + $error = $record->delete; + + $error = $record->check; + +=head1 DESCRIPTION + +An FS::vend_pay object represents a vendor payment. FS::vend_pay inherits from +FS::Record. The following fields are currently supported: + +=over 4 + +=item vendpaynum + +primary key + +=item vendnum + +vendnum + +=item _date + +_date + +=item paid + +paid + + +=back + +=head1 METHODS + +=over 4 + +=item new HASHREF + +Creates a new payment. To add the payment 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_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; + + 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_pay: $error"; + } + + if ( $self->get('vendbillnum') ) { + + my $vend_bill_pay = new FS::vend_bill_pay { + 'vendpaynum' => $self->vendpaynum, + 'vendbillnum' => $self->get('vendbillnum'), + 'amount' => $self->paid, + }; + + $error = $vend_bill_pay->insert; + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return "auto-inserting vend_bill_pay: $error"; + } + + } + + $dbh->commit or die $dbh->errstr if $oldAutoCommit; + ''; + +} + +=item delete + +Delete this record from the database. + +=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 payment. 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('vendpaynum') + || $self->ut_foreign_key('vendnum', 'vend_main', 'vendnum') + || $self->ut_numbern('_date') + || $self->ut_money('paid') + ; + return $error if $error; + + $self->SUPER::check; +} + +=back + +=head1 BUGS + +=head1 SEE ALSO + +L<FS::Record>, schema.html from the base documentation. + +=cut + +1; + diff --git a/FS/t/vend_bill.t b/FS/t/vend_bill.t new file mode 100644 index 0000000..710ff6d --- /dev/null +++ b/FS/t/vend_bill.t @@ -0,0 +1,5 @@ +BEGIN { $| = 1; print "1..1\n" } +END {print "not ok 1\n" unless $loaded;} +use FS::vend_bill; +$loaded=1; +print "ok 1\n"; diff --git a/FS/t/vend_bill_pay.t b/FS/t/vend_bill_pay.t new file mode 100644 index 0000000..e6f4cca --- /dev/null +++ b/FS/t/vend_bill_pay.t @@ -0,0 +1,5 @@ +BEGIN { $| = 1; print "1..1\n" } +END {print "not ok 1\n" unless $loaded;} +use FS::vend_bill_pay; +$loaded=1; +print "ok 1\n"; diff --git a/FS/t/vend_class.t b/FS/t/vend_class.t new file mode 100644 index 0000000..b7d759e --- /dev/null +++ b/FS/t/vend_class.t @@ -0,0 +1,5 @@ +BEGIN { $| = 1; print "1..1\n" } +END {print "not ok 1\n" unless $loaded;} +use FS::vend_class; +$loaded=1; +print "ok 1\n"; diff --git a/FS/t/vend_main.t b/FS/t/vend_main.t new file mode 100644 index 0000000..07fbdb4 --- /dev/null +++ b/FS/t/vend_main.t @@ -0,0 +1,5 @@ +BEGIN { $| = 1; print "1..1\n" } +END {print "not ok 1\n" unless $loaded;} +use FS::vend_main; +$loaded=1; +print "ok 1\n"; diff --git a/FS/t/vend_pay.t b/FS/t/vend_pay.t new file mode 100644 index 0000000..9108733 --- /dev/null +++ b/FS/t/vend_pay.t @@ -0,0 +1,5 @@ +BEGIN { $| = 1; print "1..1\n" } +END {print "not ok 1\n" unless $loaded;} +use FS::vend_pay; +$loaded=1; +print "ok 1\n"; |