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 {
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};
'domain' => $domain, };
unless ( $svc_domain->svcnum ) {
my $error = $svc_domain->insert;
- return $error if $error;
+ return "error auto-inserting domain: $error" if $error;
}
$svc->username($username);
$svc->domsvc($svc_domain->svcnum);
}
my $error = $svc->insert;
- return $error if $error;
+ return "error inserting service: $error" if $error;
}
}
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
$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