package FS::svc_Common; use strict; use vars qw( @ISA $noexport_hack $DEBUG ); use Carp; use FS::Record qw( qsearch qsearchs fields dbh ); use FS::cust_main_Mixin; use FS::cust_svc; use FS::part_svc; use FS::queue; use FS::cust_main; @ISA = qw( FS::cust_main_Mixin FS::Record ); $DEBUG = 0; =head1 NAME FS::svc_Common - Object method for all svc_ records =head1 SYNOPSIS use FS::svc_Common; @ISA = qw( FS::svc_Common ); =head1 DESCRIPTION FS::svc_Common is intended as a base class for table-specific classes to inherit from, i.e. FS::svc_acct. FS::svc_Common inherits from FS::Record. =head1 METHODS =over 4 =cut sub new { my $proto = shift; my $class = ref($proto) || $proto; my $self = {}; bless ($self, $class); unless ( defined ( $self->table ) ) { $self->{'Table'} = shift; carp "warning: FS::Record::new called with table name ". $self->{'Table'}; } #$self->{'Hash'} = shift; my $newhash = shift; $self->{'Hash'} = { map { $_ => $newhash->{$_} } qw(svcnum svcpart) }; $self->setdefault; $self->{'Hash'}{$_} = $newhash->{$_} foreach grep { defined($newhash->{$_}) && length($newhash->{$_}) } keys %$newhash; foreach my $field ( grep !defined($self->{'Hash'}{$_}), $self->fields ) { $self->{'Hash'}{$field}=''; } $self->_rebless if $self->can('_rebless'); $self->{'modified'} = 0; $self->_cache($self->{'Hash'}, shift) if $self->can('_cache') && @_; $self; } sub virtual_fields { # This restricts the fields based on part_svc_column and the svcpart of # the service. There are four possible cases: # 1. svcpart passed as part of the svc_x hash. # 2. svcpart fetched via cust_svc based on svcnum. # 3. No svcnum or svcpart. In this case, return ALL the fields with # dbtable eq $self->table. # 4. Called via "fields('svc_acct')" or something similar. In this case # there is no $self object. my $self = shift; my $svcpart; my @vfields = $self->SUPER::virtual_fields; return @vfields unless (ref $self); # Case 4 if ($self->svcpart) { # Case 1 $svcpart = $self->svcpart; } elsif ( $self->svcnum && qsearchs('cust_svc',{'svcnum'=>$self->svcnum} ) ) { #Case 2 $svcpart = $self->cust_svc->svcpart; } else { # Case 3 $svcpart = ''; } if ($svcpart) { #Cases 1 and 2 my %flags = map { $_->columnname, $_->columnflag } ( qsearch ('part_svc_column', { svcpart => $svcpart } ) ); return grep { not ($flags{$_} eq 'X') } @vfields; } else { # Case 3 return @vfields; } return (); } =item check Checks the validity of fields in this record. At present, this does nothing but call FS::Record::check (which, in turn, does nothing but run virtual field checks). =cut sub check { my $self = shift; $self->SUPER::check; } =item insert [ , OPTION => VALUE ... ] Adds this record to the database. If there is an error, returns the error, otherwise returns false. The additional fields pkgnum and svcpart (see L) should be defined. An FS::cust_svc record will be created and inserted. Currently available options are: I, I and I. If I is set to an array reference, the jobnums of any export jobs will be added to the referenced array. If I is set to an array reference of FS::tablename objects (for example, FS::acct_snarf objects), they will have their svcnum field set and will be inserted after this record, but before any exports are run. Each element of the array can also optionally be a two-element array reference containing the child object and the name of an alternate field to be filled in with the newly-inserted svcnum, for example C<[ $svc_forward, 'srcsvc' ]> If I is set (to a scalar jobnum or an array reference of jobnums), all provisioning jobs will have a dependancy on the supplied jobnum(s) (they will not run until the specific job(s) complete(s)). =cut sub insert { my $self = shift; my %options = @_; warn "FS::svc_Common::insert called with options ". join(', ', map { "$_: $options{$_}" } keys %options ). "\n" if $DEBUG; my @jobnums = (); local $FS::queue::jobnums = \@jobnums; warn "FS::svc_Common::insert: set \$FS::queue::jobnums to $FS::queue::jobnums" if $DEBUG; my $objects = $options{'child_objects'} || []; my $depend_jobnums = $options{'depend_jobnum'} || []; $depend_jobnums = [ $depend_jobnums ] unless ref($depend_jobnums); my $error; 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; $error = $self->check; return $error if $error; my $svcnum = $self->svcnum; my $cust_svc = $svcnum ? qsearchs('cust_svc',{'svcnum'=>$self->svcnum}) : ''; #unless ( $svcnum ) { if ( !$svcnum or !$cust_svc ) { $cust_svc = new FS::cust_svc ( { #hua?# 'svcnum' => $svcnum, 'svcnum' => $self->svcnum, 'pkgnum' => $self->pkgnum, 'svcpart' => $self->svcpart, } ); $error = $cust_svc->insert; if ( $error ) { $dbh->rollback if $oldAutoCommit; return $error; } $svcnum = $self->svcnum($cust_svc->svcnum); } else { #$cust_svc = qsearchs('cust_svc',{'svcnum'=>$self->svcnum}); unless ( $cust_svc ) { $dbh->rollback if $oldAutoCommit; return "no cust_svc record found for svcnum ". $self->svcnum; } $self->pkgnum($cust_svc->pkgnum); $self->svcpart($cust_svc->svcpart); } $error = $self->SUPER::insert; if ( $error ) { $dbh->rollback if $oldAutoCommit; return $error; } foreach my $object ( @$objects ) { my($field, $obj); if ( ref($object) eq 'ARRAY' ) { ($obj, $field) = @$object; } else { $obj = $object; $field = 'svcnum'; } $obj->$field($self->svcnum); $error = $obj->insert; if ( $error ) { $dbh->rollback if $oldAutoCommit; return $error; } } #new-style exports! unless ( $noexport_hack ) { warn "FS::svc_Common::insert: \$FS::queue::jobnums is $FS::queue::jobnums" if $DEBUG; foreach my $part_export ( $self->cust_svc->part_svc->part_export ) { my $error = $part_export->export_insert($self); if ( $error ) { $dbh->rollback if $oldAutoCommit; return "exporting to ". $part_export->exporttype. " (transaction rolled back): $error"; } } foreach my $depend_jobnum ( @$depend_jobnums ) { warn "inserting dependancies on supplied job $depend_jobnum\n" if $DEBUG; foreach my $jobnum ( @jobnums ) { my $queue = qsearchs('queue', { 'jobnum' => $jobnum } ); warn "inserting dependancy for job $jobnum on $depend_jobnum\n" if $DEBUG; my $error = $queue->depend_insert($depend_jobnum); if ( $error ) { $dbh->rollback if $oldAutoCommit; return "error queuing job dependancy: $error"; } } } } if ( exists $options{'jobnums'} ) { push @{ $options{'jobnums'} }, @jobnums; } $dbh->commit or die $dbh->errstr if $oldAutoCommit; ''; } =item delete Deletes this account from the database. If there is an error, returns the error, otherwise returns false. The corresponding FS::cust_svc record will be deleted as well. =cut sub delete { my $self = shift; my $error; 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 $svcnum = $self->svcnum; my $oldAutoCommit = $FS::UID::AutoCommit; local $FS::UID::AutoCommit = 0; my $dbh = dbh; $error = $self->SUPER::delete; return $error if $error; #new-style exports! unless ( $noexport_hack ) { foreach my $part_export ( $self->cust_svc->part_svc->part_export ) { my $error = $part_export->export_delete($self); if ( $error ) { $dbh->rollback if $oldAutoCommit; return "exporting to ". $part_export->exporttype. " (transaction rolled back): $error"; } } } return $error if $error; my $cust_svc = $self->cust_svc; $error = $cust_svc->delete; return $error if $error; $dbh->commit or die $dbh->errstr if $oldAutoCommit; ''; } =item replace OLD_RECORD Replaces OLD_RECORD with this one. If there is an error, returns the error, otherwise returns false. =cut sub replace { my ($new, $old) = (shift, 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 = $new->SUPER::replace($old); if ($error) { $dbh->rollback if $oldAutoCommit; return $error; } #new-style exports! unless ( $noexport_hack ) { #not quite false laziness, but same pattern as FS::svc_acct::replace and #FS::part_export::sqlradius::_export_replace. List::Compare or something #would be useful but too much of a pain in the ass to deploy my @old_part_export = $old->cust_svc->part_svc->part_export; my %old_exportnum = map { $_->exportnum => 1 } @old_part_export; my @new_part_export = $new->svcpart ? qsearchs('part_svc', { svcpart=>$new->svcpart } )->part_export : $new->cust_svc->part_svc->part_export; my %new_exportnum = map { $_->exportnum => 1 } @new_part_export; foreach my $delete_part_export ( grep { ! $new_exportnum{$_->exportnum} } @old_part_export ) { my $error = $delete_part_export->export_delete($old); if ( $error ) { $dbh->rollback if $oldAutoCommit; return "error deleting, export to ". $delete_part_export->exporttype. " (transaction rolled back): $error"; } } foreach my $replace_part_export ( grep { $old_exportnum{$_->exportnum} } @new_part_export ) { my $error = $replace_part_export->export_replace($new,$old); if ( $error ) { $dbh->rollback if $oldAutoCommit; return "error exporting to ". $replace_part_export->exporttype. " (transaction rolled back): $error"; } } foreach my $insert_part_export ( grep { ! $old_exportnum{$_->exportnum} } @new_part_export ) { my $error = $insert_part_export->export_insert($new); if ( $error ) { $dbh->rollback if $oldAutoCommit; return "error inserting export to ". $insert_part_export->exporttype. " (transaction rolled back): $error"; } } } $dbh->commit or die $dbh->errstr if $oldAutoCommit; ''; } =item setfixed Sets any fixed fields for this service (see L). If there is an error, returns the error, otherwise returns the FS::part_svc object (use ref() to test the return). Usually called by the check method. =cut sub setfixed { my $self = shift; $self->setx('F'); } =item setdefault Sets all fields to their defaults (see L), overriding their current values. If there is an error, returns the error, otherwise returns the FS::part_svc object (use ref() to test the return). =cut sub setdefault { my $self = shift; $self->setx('D'); } sub setx { my $self = shift; my $x = shift; my $error; $error = $self->ut_numbern('svcnum') ; return $error if $error; #get part_svc my $svcpart; if ( $self->get('svcpart') ) { $svcpart = $self->get('svcpart'); } elsif ( $self->svcnum && qsearchs('cust_svc', {'svcnum'=>$self->svcnum}) ) { my $cust_svc = $self->cust_svc; return "Unknown svcnum" unless $cust_svc; $svcpart = $cust_svc->svcpart; } my $part_svc = qsearchs( 'part_svc', { 'svcpart' => $svcpart } ); return "Unkonwn svcpart" unless $part_svc; #set default/fixed/whatever fields from part_svc my $table = $self->table; foreach my $field ( grep { $_ ne 'svcnum' } $self->fields ) { my $part_svc_column = $part_svc->part_svc_column($field); if ( $part_svc_column->columnflag eq $x ) { $self->setfield( $field, $part_svc_column->columnvalue ); } } $part_svc; } =item cust_svc Returns the cust_svc record associated with this svc_ record, as a FS::cust_svc object (see L). =cut sub cust_svc { my $self = shift; qsearchs('cust_svc', { 'svcnum' => $self->svcnum } ); } =item suspend Runs export_suspend callbacks. =cut sub suspend { 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; #new-style exports! unless ( $noexport_hack ) { foreach my $part_export ( $self->cust_svc->part_svc->part_export ) { my $error = $part_export->export_suspend($self); if ( $error ) { $dbh->rollback if $oldAutoCommit; return "error exporting to ". $part_export->exporttype. " (transaction rolled back): $error"; } } } $dbh->commit or die $dbh->errstr if $oldAutoCommit; ''; } =item unsuspend Runs export_unsuspend callbacks. =cut sub unsuspend { 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; #new-style exports! unless ( $noexport_hack ) { foreach my $part_export ( $self->cust_svc->part_svc->part_export ) { my $error = $part_export->export_unsuspend($self); if ( $error ) { $dbh->rollback if $oldAutoCommit; return "error exporting to ". $part_export->exporttype. " (transaction rolled back): $error"; } } } $dbh->commit or die $dbh->errstr if $oldAutoCommit; ''; } =item cancel Stub - returns false (no error) so derived classes don't need to define these methods. Called by the cancel method of FS::cust_pkg (see L). =cut sub cancel { ''; } =item clone_suspended Constructor used by FS::part_export::_export_suspend fallback. Stub returning same object for svc_ classes which don't implement a suspension fallback (everything except svc_acct at the moment). Document better. =cut sub clone_suspended { shift; } =item clone_kludge_unsuspend Constructor used by FS::part_export::_export_unsuspend fallback. Stub returning same object for svc_ classes which don't implement a suspension fallback (everything except svc_acct at the moment). Document better. =cut sub clone_kludge_unsuspend { shift; } =back =head1 BUGS The setfixed method return value. =head1 SEE ALSO L, L, L, L, schema.html from the base documentation. =cut 1;