package FS::inventory_item; use strict; use vars qw( @ISA ); use FS::Record qw( dbh qsearch qsearchs ); use FS::cust_main_Mixin; use FS::inventory_class; use FS::cust_svc; @ISA = qw( FS::cust_main_Mixin FS::Record ); =head1 NAME FS::inventory_item - Object methods for inventory_item records =head1 SYNOPSIS use FS::inventory_item; $record = new FS::inventory_item \%hash; $record = new FS::inventory_item { 'column' => 'value' }; $error = $record->insert; $error = $new_record->replace($old_record); $error = $record->delete; $error = $record->check; =head1 DESCRIPTION An FS::inventory_item object represents a specific piece of (real or virtual) inventory, such as a specific DID or serial number. FS::inventory_item inherits from FS::Record. The following fields are currently supported: =over 4 =item itemnum - primary key =item classnum - Inventory class (see L) =item item - Item identifier (unique within its inventory class) =item svcnum - Customer servcie (see L) =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 method. =cut # the new method can be inherited from FS::Record, if a table method is defined sub table { 'inventory_item'; } =item insert Adds this record to the database. If there is an error, returns the error, otherwise returns false. =cut # the insert method can be inherited from FS::Record =item delete Delete this record from the database. =cut # the delete method can be inherited from FS::Record =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 # the replace method can be inherited from FS::Record =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 # the check method should currently be supplied - FS::Record contains some # data checking routines sub check { my $self = shift; my $error = $self->ut_numbern('itemnum') || $self->ut_foreign_key('classnum', 'inventory_class', 'classnum' ) || $self->ut_text('item') || $self->ut_foreign_keyn('svcnum', 'cust_svc', 'svcnum' ) ; return $error if $error; $self->SUPER::check; } =item cust_svc Returns the customer service associated with this inventory item, if the item has been used (see L). =cut sub cust_svc { my $self = shift; return '' unless $self->svcnum; qsearchs( 'cust_svc', { 'svcnum' => $self->svcnum } ); } =back =head1 CLASS METHODS =over 4 =item batch_import =cut sub batch_import { my $param = shift; my $fh = $param->{filehandle}; my $imported = 0; 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 $line; while ( defined($line=<$fh>) ) { chomp $line; my $inventory_item = new FS::inventory_item { 'classnum' => $param->{'classnum'}, 'item' => $line, }; my $error = $inventory_item->insert; if ( $error ) { $dbh->rollback if $oldAutoCommit; return $error; #or just skip? #next; } $imported++; } $dbh->commit or die $dbh->errstr if $oldAutoCommit; #might want to disable this if we skip records for any reason... return "Empty file!" unless $imported; ''; } =back =head1 BUGS maybe batch_import should be a regular method in FS::inventory_class =head1 SEE ALSO L, L, L, schema.html from the base documentation. =cut 1;