diff options
author | Ivan Kohler <ivan@freeside.biz> | 2014-04-05 12:46:14 -0700 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2014-04-05 12:46:14 -0700 |
commit | 0dfd49189b0ea878e99f1590a2939e55ab02c89c (patch) | |
tree | 51f8d73f4fdb137132a0802e2c33f45ea7607697 /FS/FS | |
parent | 23699764d0d8436b50f5cf88f798c552969714eb (diff) |
installers, RT#16584
Diffstat (limited to 'FS/FS')
-rw-r--r-- | FS/FS/Schema.pm | 38 | ||||
-rw-r--r-- | FS/FS/sched_avail.pm | 125 | ||||
-rw-r--r-- | FS/FS/sched_item.pm | 123 |
3 files changed, 286 insertions, 0 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 4f547725d..bdae73649 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -5479,6 +5479,44 @@ sub tables_hashref { 'index' => [], }, + 'sched_item' => { + 'columns' => [ + 'itemnum', 'serial', '', '', '', '', + 'usernum', 'int', 'NULL', '', '', '', + #'itemname', 'varchar', $char_d, '', '', '', + 'disabled', 'char', 'NULL', 1, '', '', + ], + 'primary_key' => 'itemnum', + 'unique' => [ [ 'usernum' ] ], + 'index' => [], + 'foreign_keys' => [ + { columns => [ 'usernum' ], + table => 'access_user', + }, + ], + }, + + #'sched_item_class' + + 'sched_avail' => { + 'columns' => [ + 'availnum', 'serial', '', '', '', '', + 'itemnum', 'int', '', '', '', '', + 'wday', 'int', '', '', '', '', + 'stime', 'int', '', '', '', '', + 'etime', 'int', '', '', '', '', + 'override_date', @date_type, '', '', + ], + 'primary_key' => 'availnum', + 'unique' => [], + 'index' => [], + 'foreign_keys' => [ + { columns => [ 'itemnum' ], + table => 'sched_item', + }, + ], + }, + 'svc_phone' => { 'columns' => [ 'svcnum', 'int', '', '', '', '', diff --git a/FS/FS/sched_avail.pm b/FS/FS/sched_avail.pm new file mode 100644 index 000000000..62b1a5d69 --- /dev/null +++ b/FS/FS/sched_avail.pm @@ -0,0 +1,125 @@ +package FS::sched_avail; +use base qw( FS::Record ); + +use strict; +#use FS::Record qw( qsearch qsearchs ); + +=head1 NAME + +FS::sched_avail - Object methods for sched_avail records + +=head1 SYNOPSIS + + use FS::sched_avail; + + $record = new FS::sched_avail \%hash; + $record = new FS::sched_avail { 'column' => 'value' }; + + $error = $record->insert; + + $error = $new_record->replace($old_record); + + $error = $record->delete; + + $error = $record->check; + +=head1 DESCRIPTION + +An FS::sched_avail object represents an availability period/interval. +FS::sched_avail inherits from FS::Record. The following fields are currently +supported: + +=over 4 + +=item availnum + +primary key + +=item itemnum + +itemnum + +=item wday + +wday + +=item stime + +stime + +=item etime + +etime + +=item override_date + +override_date + + +=back + +=head1 METHODS + +=over 4 + +=item new HASHREF + +Creates a new period. To add the period 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 { 'sched_avail'; } + +=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 period. 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('availnum') + || $self->ut_foreign_key('itemnum', 'sched_avail', 'itemnum') + || $self->ut_number('wday') + || $self->ut_number('stime') + || $self->ut_number('etime') + || $self->ut_numbern('override_date') + ; + return $error if $error; + + $self->SUPER::check; +} + +=back + +=head1 BUGS + +=head1 SEE ALSO + +L<FS::sched_item>, L<FS::Record> + +=cut + +1; + diff --git a/FS/FS/sched_item.pm b/FS/FS/sched_item.pm new file mode 100644 index 000000000..5f55188e6 --- /dev/null +++ b/FS/FS/sched_item.pm @@ -0,0 +1,123 @@ +package FS::sched_item; +use base qw( FS::Record ); + +use strict; +#use FS::Record qw( qsearch qsearchs ); + +=head1 NAME + +FS::sched_item - Object methods for sched_item records + +=head1 SYNOPSIS + + use FS::sched_item; + + $record = new FS::sched_item \%hash; + $record = new FS::sched_item { 'column' => 'value' }; + + $error = $record->insert; + + $error = $new_record->replace($old_record); + + $error = $record->delete; + + $error = $record->check; + +=head1 DESCRIPTION + +An FS::sched_item object represents an schedulable item, such as an installer, +meeting room or truck. FS::sched_item inherits from FS::Record. The following +fields are currently supported: + +=over 4 + +=item itemnum + +primary key + +=item usernum + +usernum + +=item disabled + +disabled + + +=back + +=head1 METHODS + +=over 4 + +=item new HASHREF + +Creates a new item. To add the item 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 { 'sched_item'; } + +=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 item. 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('itemnum') + || $self->ut_foreign_keyn('usernum', 'access_user', 'usernum') + || $self->ut_enum('disabled', [ '', 'Y' ]) + ; + return $error if $error; + + $self->SUPER::check; +} + +=item name + +Returns a name for this item; either the name of the associated employee (see +L<FS::access_user), or the itemname field. + +=cut + +sub name { + my $self = shift; + my $access_user = $self->access_user; + $access_user ? $access_user->name : $self->itemname; +} + +=back + +=head1 BUGS + +=head1 SEE ALSO + +L<FS::access_user>, L<FS::sched_avail>, L<FS::Record> + +=cut + +1; + |