From db18a813b59b8254ff19f77770750a781613d79e Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 13 Sep 2007 22:35:20 +0000 Subject: rename svc_acct_rt_transaction to acct_rt_transaction, as it is not a service, its something that hangs off of an svc_acct (like an acct_snarf). thank goodness was able to do this before its any sort of migration problem... --- FS/FS/Schema.pm | 2 +- FS/FS/acct_rt_transaction.pm | 260 +++++++++++++++++++++++++++++++++++++++ FS/FS/svc_acct_rt_transaction.pm | 260 --------------------------------------- FS/MANIFEST | 4 +- FS/t/acct_rt_transaction.t | 5 + FS/t/svc_acct_rt_transaction.t | 5 - 6 files changed, 268 insertions(+), 268 deletions(-) create mode 100644 FS/FS/acct_rt_transaction.pm delete mode 100644 FS/FS/svc_acct_rt_transaction.pm create mode 100644 FS/t/acct_rt_transaction.t delete mode 100644 FS/t/svc_acct_rt_transaction.t (limited to 'FS') diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index da264fa05..e5ac696d4 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -988,7 +988,7 @@ sub tables_hashref { 'index' => [ ['username'], ['domsvc'] ], }, - 'svc_acct_rt_transaction' => { + 'acct_rt_transaction' => { 'columns' => [ 'svcrtid', 'int', '', '', '', '', 'svcnum', 'int', '', '', '', '', diff --git a/FS/FS/acct_rt_transaction.pm b/FS/FS/acct_rt_transaction.pm new file mode 100644 index 000000000..af959e47f --- /dev/null +++ b/FS/FS/acct_rt_transaction.pm @@ -0,0 +1,260 @@ +package FS::acct_rt_transaction; + +use strict; +use vars qw( @ISA ); +use FS::Record qw( qsearch qsearchs dbh ); + +@ISA = qw(FS::Record); + +=head1 NAME + +FS::acct_rt_transaction - Object methods for acct_rt_transaction records + +=head1 SYNOPSIS + + use FS::acct_rt_transaction; + + $record = new FS::acct_rt_transaction \%hash; + $record = new FS::acct_rt_transaction { 'column' => 'value' }; + + $error = $record->insert; + + $error = $new_record->replace($old_record); + + $error = $record->delete; + + $error = $record->check; + +=head1 DESCRIPTION + +An FS::acct_rt_transaction object represents an application of time +from a rt transaction to a svc_acct. FS::acct_rt_transaction inherits from +FS::Record. The following fields are currently supported: + +=over 4 + +=item svcrtid - primary key + +=item svcnum - the svcnum of the svc_acct to which the time applies + +=item transaction_id - the id of the rt transtaction from which the time applies + +=item seconds - the amount of time which applies + + +=back + +=head1 METHODS + +=over 4 + +=item new HASHREF + +Creates a new acct_rt_transaction. To add the example 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 method. + +=cut + +sub table { 'acct_rt_transaction'; } + +=item insert + +Adds this record to the database. If there is an error, returns the error, +otherwise returns false. + +=cut + +sub insert { + my( $self, %options ) = @_; + + 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->SUPER::insert($options{options} ? %{$options{options}} : ()); + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return $error; + } + + my $svc_acct = qsearchs('svc_acct', {'svcnum' => $self->svcnum}); + unless ($svc_acct) { + $dbh->rollback if $oldAutoCommit; + return "Can't find svc_acct " . $self->svcnum; + } + + my $error = $svc_acct->decrement_seconds($self->seconds); + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return "Error incrementing service seconds: $error"; + } + + $dbh->commit or die $dbh->errstr if $oldAutoCommit; + ''; + +} + + +=item delete + +Delete this record from the database. + +=cut + +sub delete { + 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->SUPER::delete; + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return $error; + } + + my $svc_acct = qsearchs('svc_acct', {'svcnum' => $self->svcnum}); + unless ($svc_acct) { + $dbh->rollback if $oldAutoCommit; + return "Can't find svc_acct " . $self->svcnum; + } + + my $error = $svc_acct->increment_seconds($self->seconds); + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return "Error incrementing service seconds: $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. + +=cut + +=item check + +Checks all fields to make sure this is a valid acct_rt_transaction. 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 ($selfref) = $self->hashref; + + my $error = + $self->ut_numbern('svcrtid') + || $self->ut_numbern('svcnum') + || $self->ut_number('transaction_id') + || $self->ut_numbern('_date') + || $self->ut_snumber('seconds') + ; + return $error if $error; + + $self->_date(time) unless $self->_date; + + if ($selfref->{custnum}) { + my $conf = new FS::Conf; + my %packages = map { $_ => 1 } $conf->config('support_packages'); + my $cust_main = qsearchs('cust_main',{ 'custnum' => $selfref->{custnum} } ); + return "Invalid custnum: " . $selfref->{custnum} unless $cust_main; + + my (@svcs) = map { $_->svcnum } $cust_main->support_services; + return "svcnum ". $self->svcnum. " invalid for custnum ".$selfref->{custnum} + unless (!$self->svcnum || scalar(grep { $_ == $self->svcnum } @svcs)); + + $self->svcnum($svcs[0]) unless $self->svcnum; + return "Can't find support service for custnum ".$selfref->{custnum} + unless $self->svcnum; + } + + $self->SUPER::check; +} + +=item batch_insert SVC_ACCT_RT_TRANSACTION_OBJECT, ... + +Class method which inserts multiple time applications. Takes a list of +FS::acct_rt_transaction objects. If there is an error inserting any +application, the entire transaction is rolled back, i.e. all time is applied +or none is. + +For example: + + my $errors = FS::acct_rt_transaction->batch_insert(@transactions); + if ( $error ) { + #success; all payments were inserted + } else { + #failure; no payments were inserted. + } + +=cut + +sub batch_insert { + my $self = shift; #class method + + 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; + foreach (@_) { + $error = $_->insert; + last if $error; + } + + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + } else { + $dbh->commit or die $dbh->errstr if $oldAutoCommit; + } + + $error; + +} + +=back + +=head1 BUGS + +Possibly the delete method or others. + +=head1 SEE ALSO + +L, schema.html from the base documentation. + +=cut + +1; + diff --git a/FS/FS/svc_acct_rt_transaction.pm b/FS/FS/svc_acct_rt_transaction.pm deleted file mode 100644 index 0fb64456b..000000000 --- a/FS/FS/svc_acct_rt_transaction.pm +++ /dev/null @@ -1,260 +0,0 @@ -package FS::svc_acct_rt_transaction; - -use strict; -use vars qw( @ISA ); -use FS::Record qw( qsearch qsearchs dbh ); - -@ISA = qw(FS::Record); - -=head1 NAME - -FS::svc_acct_rt_transaction - Object methods for svc_acct_rt_transaction records - -=head1 SYNOPSIS - - use FS::svc_acct_rt_transaction; - - $record = new FS::svc_acct_rt_transaction \%hash; - $record = new FS::svc_acct_rt_transaction { 'column' => 'value' }; - - $error = $record->insert; - - $error = $new_record->replace($old_record); - - $error = $record->delete; - - $error = $record->check; - -=head1 DESCRIPTION - -An FS::svc_acct_rt_transaction object represents an application of time -from a rt transaction to a svc_acct. FS::svc_acct_rt_transaction inherits from -FS::Record. The following fields are currently supported: - -=over 4 - -=item svcrtid - primary key - -=item svcnum - the svcnum of the svc_acct to which the time applies - -=item transaction_id - the id of the rt transtaction from which the time applies - -=item seconds - the amount of time which applies - - -=back - -=head1 METHODS - -=over 4 - -=item new HASHREF - -Creates a new svc_acct_rt_transaction. To add the example 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 method. - -=cut - -sub table { 'svc_acct_rt_transaction'; } - -=item insert - -Adds this record to the database. If there is an error, returns the error, -otherwise returns false. - -=cut - -sub insert { - my( $self, %options ) = @_; - - 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->SUPER::insert($options{options} ? %{$options{options}} : ()); - if ( $error ) { - $dbh->rollback if $oldAutoCommit; - return $error; - } - - my $svc_acct = qsearchs('svc_acct', {'svcnum' => $self->svcnum}); - unless ($svc_acct) { - $dbh->rollback if $oldAutoCommit; - return "Can't find svc_acct " . $self->svcnum; - } - - my $error = $svc_acct->decrement_seconds($self->seconds); - if ( $error ) { - $dbh->rollback if $oldAutoCommit; - return "Error incrementing service seconds: $error"; - } - - $dbh->commit or die $dbh->errstr if $oldAutoCommit; - ''; - -} - - -=item delete - -Delete this record from the database. - -=cut - -sub delete { - 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->SUPER::delete; - if ( $error ) { - $dbh->rollback if $oldAutoCommit; - return $error; - } - - my $svc_acct = qsearchs('svc_acct', {'svcnum' => $self->svcnum}); - unless ($svc_acct) { - $dbh->rollback if $oldAutoCommit; - return "Can't find svc_acct " . $self->svcnum; - } - - my $error = $svc_acct->increment_seconds($self->seconds); - if ( $error ) { - $dbh->rollback if $oldAutoCommit; - return "Error incrementing service seconds: $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. - -=cut - -=item check - -Checks all fields to make sure this is a valid svc_acct_rt_transaction. 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 ($selfref) = $self->hashref; - - my $error = - $self->ut_numbern('svcrtid') - || $self->ut_numbern('svcnum') - || $self->ut_number('transaction_id') - || $self->ut_numbern('_date') - || $self->ut_snumber('seconds') - ; - return $error if $error; - - $self->_date(time) unless $self->_date; - - if ($selfref->{custnum}) { - my $conf = new FS::Conf; - my %packages = map { $_ => 1 } $conf->config('support_packages'); - my $cust_main = qsearchs('cust_main',{ 'custnum' => $selfref->{custnum} } ); - return "Invalid custnum: " . $selfref->{custnum} unless $cust_main; - - my (@svcs) = map { $_->svcnum } $cust_main->support_services; - return "svcnum ". $self->svcnum. " invalid for custnum ".$selfref->{custnum} - unless (!$self->svcnum || scalar(grep { $_ == $self->svcnum } @svcs)); - - $self->svcnum($svcs[0]) unless $self->svcnum; - return "Can't find support service for custnum ".$selfref->{custnum} - unless $self->svcnum; - } - - $self->SUPER::check; -} - -=item batch_insert SVC_ACCT_RT_TRANSACTION_OBJECT, ... - -Class method which inserts multiple time applications. Takes a list of -FS::svc_acct_rt_transaction objects. If there is an error inserting any -application, the entire transaction is rolled back, i.e. all time is applied -or none is. - -For example: - - my $errors = FS::svc_acct_rt_transaction->batch_insert(@transactions); - if ( $error ) { - #success; all payments were inserted - } else { - #failure; no payments were inserted. - } - -=cut - -sub batch_insert { - my $self = shift; #class method - - 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; - foreach (@_) { - $error = $_->insert; - last if $error; - } - - if ( $error ) { - $dbh->rollback if $oldAutoCommit; - } else { - $dbh->commit or die $dbh->errstr if $oldAutoCommit; - } - - $error; - -} - -=back - -=head1 BUGS - -Possibly the delete method or others. - -=head1 SEE ALSO - -L, schema.html from the base documentation. - -=cut - -1; - diff --git a/FS/MANIFEST b/FS/MANIFEST index 07b1eabf8..559264cbe 100644 --- a/FS/MANIFEST +++ b/FS/MANIFEST @@ -388,5 +388,5 @@ FS/cust_pkg_option.pm t/cust_pkg_option.t FS/conf.pm t/conf.t -FS/svc_acct_rt_transaction.pm -t/svc_acct_rt_transaction.t +FS/acct_rt_transaction.pm +t/acct_rt_transaction.t diff --git a/FS/t/acct_rt_transaction.t b/FS/t/acct_rt_transaction.t new file mode 100644 index 000000000..552bdc84a --- /dev/null +++ b/FS/t/acct_rt_transaction.t @@ -0,0 +1,5 @@ +BEGIN { $| = 1; print "1..1\n" } +END {print "not ok 1\n" unless $loaded;} +use FS::acct_rt_transaction; +$loaded=1; +print "ok 1\n"; diff --git a/FS/t/svc_acct_rt_transaction.t b/FS/t/svc_acct_rt_transaction.t deleted file mode 100644 index d9958317e..000000000 --- a/FS/t/svc_acct_rt_transaction.t +++ /dev/null @@ -1,5 +0,0 @@ -BEGIN { $| = 1; print "1..1\n" } -END {print "not ok 1\n" unless $loaded;} -use FS::svc_acct_rt_transaction; -$loaded=1; -print "ok 1\n"; -- cgit v1.2.1