X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fcust_pkg%2FImport.pm;h=616d39a049015b3f1de00762a1cb799198e4b08c;hb=77269df6caa07bb5ba380ce7816dee49045a9a14;hp=9c93677a7cd4a8688bd8f78eb5ec3982a858f355;hpb=0fb307c305e4bc2c9c27dc25a3308beae3a4d33c;p=freeside.git diff --git a/FS/FS/cust_pkg/Import.pm b/FS/FS/cust_pkg/Import.pm index 9c93677a7..616d39a04 100644 --- a/FS/FS/cust_pkg/Import.pm +++ b/FS/FS/cust_pkg/Import.pm @@ -103,9 +103,11 @@ sub process_batch_import { my %formatfields = ( 'default' => [], + 'all_dates' => [], 'svc_acct' => [qw( username _password domsvc )], 'svc_phone' => [qw( countrycode phonenum sip_password pin )], 'svc_external' => [qw( id title )], + 'location' => [qw( address1 address2 city state zip country )], ); sub _formatfields { @@ -115,11 +117,30 @@ sub _formatfields { my %import_options = ( 'table' => 'cust_pkg', + 'preinsert_callback' => sub { + my($record, $param) = @_; + my @location_params = grep /^location\./, keys %$param; + if (@location_params) { + my $cust_location = FS::cust_location->new({ + 'custnum' => $record->custnum, + }); + foreach my $p (@location_params) { + $p =~ /^location.(\w+)$/; + $cust_location->set($1, $param->{$p}); + } + + my $error = $cust_location->find_or_insert; # this avoids duplicates + return "error creating location: $error" if $error; + $record->set('locationnum', $cust_location->locationnum); + } + ''; + }, + 'postinsert_callback' => sub { my( $record, $param ) = @_; my $formatfields = _formatfields; - foreach my $svc_x ( grep { $_ ne 'default' } keys %$formatfields ) { + foreach my $svc_x ( grep /^svc/, keys %$formatfields ) { my $ff = $formatfields->{$svc_x}; @@ -170,8 +191,9 @@ sub batch_import { my $format = delete $opt->{'format'}; my @fields = (); - if ( $format =~ /^(.*)-agent_custid$/ ) { + if ( $format =~ /^(.*)-agent_custid(-agent_pkgid)?$/ ) { $format = $1; + my $agent_pkgid = $2; @fields = ( sub { my( $self, $value ) = @_; # $conf, $param @@ -182,15 +204,81 @@ sub batch_import { $self->custnum($cust_main->custnum) if $cust_main; }, ); + push @fields, 'agent_pkgid' if $agent_pkgid; } else { @fields = ( 'custnum' ); } + if ( $format =~ /^(.*)-locationnum$/ ) { + $format = $1; + push @fields, 'locationnum'; + } + + if ( $format =~ /^bulk_(.*)$/ ) { + + $format = $1; + + $opt->{'postinsert_callback'} = sub { + my( $record, $param ) = @_; + + my $formatfields = _formatfields; + foreach my $svc_x ( grep /^svc/, keys %$formatfields ) { + + my $ff = $formatfields->{$svc_x}; + + if ( grep $param->{"$svc_x.$_"}, @$ff ) { + + $param->{'svc_phone.phonenum'} =~ /^\s*(\d+)\s*\-\s*(\d+)\s*$/ + or return 'Enter a phone number range, with dash as the separator'; + my($start, $end) = ($1, $2); + if ( length($end) < length($start) ) { + $end = substr($start, 0, length($start) - length($end) ). $end; + } + + foreach my $phonenum ( "$start" .. "$end" ) { + + my $svc = "FS::$svc_x"->new( { + 'pkgnum' => $record->pkgnum, + 'svcpart' => $record->part_pkg->svcpart($svc_x), + map { $_ => $param->{"$svc_x.$_"} } @$ff + } ); + + $svc->phonenum($phonenum); + #$svc->set_default_and_fixed; + my $error = $svc->insert; + return "error inserting service: $error" if $error; + + } + + } + + } + + return ''; #no error + + }; + + } + push @fields, ( 'pkgpart', 'discountnum' ); - foreach my $field ( - qw( start_date setup bill last_bill susp adjourn cancel expire ) - ) { + my @date_fields = (); + if ( $format =~ /all_dates/ ) { + @date_fields = qw( + order_date + start_date setup bill last_bill susp adjourn + resume + cancel expire + contract_end dundate + ); + } else { + @date_fields = qw( + start_date setup bill last_bill susp adjourn + cancel expire + ); + } + + foreach my $field (@date_fields) { push @fields, sub { my( $self, $value ) = @_; # $conf, $param #->$field has undesirable effects @@ -198,17 +286,20 @@ sub batch_import { }; } - my $formatfields = _formatfields(); + my @formats = split /-/, $format; + foreach my $f (@formats){ - die "unknown format $format" unless $formatfields->{$format}; + my $formatfields = _formatfields(); + die "unknown format $format" unless $formatfields->{$f}; - foreach my $field ( @{ $formatfields->{$format} } ) { + foreach my $field ( @{ $formatfields->{$f} } ) { - push @fields, sub { - my( $self, $value, $conf, $param ) = @_; - $param->{"$format.$field"} = $value; - }; + push @fields, sub { + my( $self, $value, $conf, $param ) = @_; + $param->{"$f.$field"} = $value; + }; + } } $opt->{'fields'} = \@fields;