use strict;
use base qw( FS::option_Common );
-use FS::Record qw( qsearch qsearchs );
+use FS::Record qw( qsearch qsearchs dbh );
=head1 NAME
=item locationnum
-Either one of these cases must be true:
--locationnum is non-null and prospectnum is null and custnum is null
--locationnum is null and (prospectnum is non-null or custnum is non-null, but not both non-null)
-
=item phonenum - Service Telephone Number
=item exportnum - export instance providing service-qualification capabilities,
=cut
-# the insert method can be inherited from FS::Record
+sub insert {
+ my $self = shift;
+ my %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;
+
+ if ( $options{'cust_location'} ) {
+ my $cust_location = $options{'cust_location'};
+ my $method = $cust_location->locationnum ? 'replace' : 'insert';
+ my $error = $cust_location->$method();
+ if ( $error ) {
+ $dbh->rollback if $oldAutoCommit;
+ return $error;
+ }
+ $self->locationnum( $cust_location->locationnum );
+ }
+
+ my @qual_option = ();
+ if ( $self->exportnum ) {
+ my $export = qsearchs( 'part_export', { 'exportnum' => $self->exportnum } )
+ or die 'Invalid exportnum';
+
+ my $qres = $export->qual($self);
+ unless ( ref($qres) ) {
+ $dbh->rollback if $oldAutoCommit;
+ return "Qualification error: $qres";
+ }
+
+ $self->$_($qres->{$_}) foreach grep $qres->{$_}, qw(status vendor_qual_id);
+ @qual_option = ( $qres->{'options'} ) if ref($qres->{'options'});
+ }
+
+ my $error = $self->SUPER::insert(@qual_option);
+ if ( $error ) {
+ $dbh->rollback if $oldAutoCommit;
+ return $error;
+ }
+
+ $dbh->commit or die $dbh->errstr if $oldAutoCommit;
+ '';
+}
=item delete
|| $self->ut_foreign_keyn('prospectnum', 'prospect_main', 'prospectnum')
|| $self->ut_foreign_keyn('locationnum', 'cust_location', 'locationnum')
|| $self->ut_numbern('phonenum')
- || $self->ut_foreign_key('exportnum', 'part_export', 'exportnum')
+ || $self->ut_foreign_keyn('exportnum', 'part_export', 'exportnum')
|| $self->ut_textn('vendor_qual_id')
|| $self->ut_alpha('status')
;
return $error if $error;
-#Either one of these cases must be true:
-#1. locationnum is non-null and prospectnum is null and custnum is null
-#2. locationnum is null and (prospectnum is non-null or custnum is non-null, but not both non-null)
- return "Invalid prospect/customer/location combination" unless (
- ( $self->locationnum && !$self->prospectcnum && !$self->custnum ) #1
- ||
- ( !$self->locationnum && ( $self->prospectnum || $self->custnum )
- && !( $self->custnum && $self->prospectnum ) ) #2
+ return "Invalid prospect/customer/location combination" if (
+ ( $self->locationnum && $self->prospectnum && $self->custnum ) ||
+ ( !$self->locationnum && !$self->prospectnum && !$self->custnum )
);
$self->SUPER::check;
}
+sub part_export {
+ my $self = shift;
+ if ( $self->exportnum ) {
+ return qsearchs('part_export', { exportnum => $self->exportnum } )
+ || die 'invalid exportnum';
+ }
+ '';
+}
+
+sub cust_location {
+ my $self = shift;
+ return '' unless $self->locationnum;
+ qsearchs('cust_location', { 'locationnum' => $self->locationnum } );
+}
+
+sub cust_main {
+ my $self = shift;
+ return '' unless $self->custnum;
+ qsearchs('cust_main', { 'custnum' => $self->custnum } );
+}
+
+sub location_hash {
+ my $self = shift;
+
+ if ( my $l = $self->cust_location ) {
+ my %loc_hash = $l->location_hash;
+ $loc_hash{locationnum} = $self->locationnum;
+ return %loc_hash;
+ }
+
+ if ( my $c = $self->cust_main ) {
+ # always override location_kind as it would never be known in the
+ # case of cust_main "default service address"
+ my %loc_hash = $c->location_hash;
+ $loc_hash{location_kind} = $c->company ? 'B' : 'R';
+ return %loc_hash;
+ }
+
+ warn "prospectnum does not imply any particular address! must specify locationnum";
+ return ();
+}
+
+sub cust_or_prospect {
+ my $self = shift;
+ if ( $self->locationnum ) {
+ my $l = qsearchs( 'cust_location',
+ { 'locationnum' => $self->locationnum });
+ return qsearchs('cust_main',{ 'custnum' => $l->custnum })
+ if $l->custnum;
+ return qsearchs('prospect_main',{ 'prospectnum' => $l->prospectnum })
+ if $l->prospectnum;
+ }
+ return qsearchs('cust_main', { 'custnum' => $self->custnum })
+ if $self->custnum;
+ return qsearchs('prospect_main', { 'prospectnum' => $self->prospectnum })
+ if $self->prospectnum;
+ '';
+}
+
+sub status_long {
+ my $self = shift;
+ my $s = {
+ 'Q' => 'Qualified',
+ 'D' => 'Does not Qualify',
+ 'N' => 'New',
+ };
+ return $s->{$self->status} if defined $s->{$self->status};
+ return 'Unknown';
+}
+
=back
=head1 SEE ALSO