diff options
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/Mason.pm | 1 | ||||
| -rw-r--r-- | FS/FS/Schema.pm | 19 | ||||
| -rw-r--r-- | FS/FS/legacy_cust_history.pm | 134 | ||||
| -rw-r--r-- | FS/MANIFEST | 2 | ||||
| -rw-r--r-- | FS/t/legacy_cust_history.t | 5 |
5 files changed, 160 insertions, 1 deletions
diff --git a/FS/FS/Mason.pm b/FS/FS/Mason.pm index 49b2d2021..6e3192ef2 100644 --- a/FS/FS/Mason.pm +++ b/FS/FS/Mason.pm @@ -374,6 +374,7 @@ if ( -e $addl_handler_use_file ) { use FS::circuit_provider; use FS::circuit_termination; use FS::svc_circuit; + use FS::legacy_cust_history; # Sammath Naur if ( $FS::Mason::addl_handler_use ) { diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index b896714de..3af31723f 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -194,7 +194,8 @@ sub dbdef_dist { grep { ! /^clientapi_session/ && ! /^h_/ && ! /^log(_context)?$/ - && ( ! /^queue(_arg)?$/ || ! $opt->{'queue-no_history'} ) + && ! /^legacy_cust_history$/ + && ( ! /^queue(_arg|_depend|_stat)?$/ || ! $opt->{'queue-no_history'} ) && ! $tables_hashref_torrus->{$_} } $dbdef->tables @@ -636,6 +637,22 @@ sub tables_hashref { 'index' => [ ['legacyid', 'custnum', 'locale' ], ], }, + 'legacy_cust_history' => { + 'columns' => [ + 'legacyhistorynum', 'serial', '', '', '', '', + 'custnum', 'int', '', '', '', '', + 'history_action', 'varchar', '', $char_d, '', '', + 'history_date', @date_type, '', '', + 'history_usernum', 'int', 'NULL', '', '', '', + 'item', 'varchar', 'NULL', $char_d, '', '', + 'description', 'varchar', 'NULL', 2*$char_d, '', '', + 'change_data', 'text', 'NULL', '', '', '', + ], + 'primary_key' => 'legacyhistorynum', + 'unique' => [], + 'index' => [ ['custnum'], ['history_date'], ], + }, + 'cust_statement' => { 'columns' => [ 'statementnum', 'serial', '', '', '', '', diff --git a/FS/FS/legacy_cust_history.pm b/FS/FS/legacy_cust_history.pm new file mode 100644 index 000000000..9e149036b --- /dev/null +++ b/FS/FS/legacy_cust_history.pm @@ -0,0 +1,134 @@ +package FS::legacy_cust_history; +use base qw( FS::Record ); + +use strict; +use FS::Record qw( qsearch qsearchs ); + +=head1 NAME + +FS::legacy_cust_history - Object methods for legacy_cust_history records + +=head1 SYNOPSIS + + use FS::legacy_cust_history; + + $record = new FS::legacy_cust_history \%hash; + $record = new FS::legacy_cust_history { 'column' => 'value' }; + + $error = $record->insert; + + $error = $new_record->replace($old_record); + + $error = $record->delete; + + $error = $record->check; + +=head1 DESCRIPTION + +An FS::legacy_cust_history object represents an item of customer change history +from a previous billing system. FS::legacy_cust_history inherits from +FS::Record. The following fields are currently supported: + +=over 4 + +=item legacyhistorynum + +primary key + +=item custnum + +Customer (see L<FS::cust_main) + +=item history_action + +Action, such as add, edit, delete, etc. + +=item history_date + +Date, as a UNIX timestamp + +=item history_usernum + +Employee (see L<FS::access_user>) + +=item item + +The item (i.e. table) which was changed. + +=item description + +A text description of the change + +=item change_data + +A text data structure representing the change + +=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 { 'legacy_cust_history'; } + +=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 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('legacyhistorynum') + || $self->ut_foreign_key('custnum', 'cust_main', 'custnum') + || $self->ut_text('history_action') + || $self->ut_numbern('history_date') + || $self->ut_foreign_keyn('history_usernum', 'access_user', 'usernum') + || $self->ut_textn('item') + || $self->ut_textn('description') + || $self->ut_anything('change_data') + ; + return $error if $error; + + $self->SUPER::check; +} + +=back + +=head1 BUGS + +=head1 SEE ALSO + +L<FS::Record> + +=cut + +1; + diff --git a/FS/MANIFEST b/FS/MANIFEST index 78d5b7e45..e5a80d237 100644 --- a/FS/MANIFEST +++ b/FS/MANIFEST @@ -787,3 +787,5 @@ FS/svc_circuit.pm t/svc_circuit.t FS/pkg_discount_Mixin.pm t/pkg_discount_Mixin.t +FS/legacy_cust_history.pm +t/legacy_cust_history.t diff --git a/FS/t/legacy_cust_history.t b/FS/t/legacy_cust_history.t new file mode 100644 index 000000000..ac48aee0c --- /dev/null +++ b/FS/t/legacy_cust_history.t @@ -0,0 +1,5 @@ +BEGIN { $| = 1; print "1..1\n" } +END {print "not ok 1\n" unless $loaded;} +use FS::legacy_cust_history; +$loaded=1; +print "ok 1\n"; |