X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fpart_export%2Fradiator.pm;h=f09d36abbb0405fca6f94c05a54965061ab11e54;hb=389b6f1116c3309c2ee57a6c295ed1a793503095;hp=95f0a0b016b82d43a0733ea592edbe899a4b887f;hpb=673b9a458d9138523026963df6fa3b4683e09bae;p=freeside.git diff --git a/FS/FS/part_export/radiator.pm b/FS/FS/part_export/radiator.pm index 95f0a0b01..f09d36abb 100644 --- a/FS/FS/part_export/radiator.pm +++ b/FS/FS/part_export/radiator.pm @@ -11,6 +11,8 @@ tie my %options, 'Tie::IxHash', %FS::part_export::sqlradius::options; 'desc' => 'Real-time export to RADIATOR', 'options' => \%options, 'nodomain' => '', + 'no_machine' => 1, + 'default_svc_class' => 'Internet', 'notes' => <<'END', Real-time export of the radusers table to any SQL database in Radiator-native format. @@ -68,17 +70,34 @@ sub _radiator_hash { my( $self, $svc_acct ) = @_; my %hash = ( 'username' => $self->export_username($svc_acct), - 'pass_word' => $svc_acct->_password, + 'pass_word' => $svc_acct->crypt_password, 'fullname' => $svc_acct->finger, map { my $method = "radius_$_"; $_ => $svc_acct->$method(); } qw( framed_filter_id framed_mtu framed_netmask framed_protocol framed_routing login_host login_service login_tcp_port ) ); - $hash{timeleft} = $svc_acct->seconds + $hash{'timeleft'} = $svc_acct->seconds if $svc_acct->seconds =~ /^\d+$/; - $hash{staticaddress} = $svc_acct->slipip + $hash{'staticaddress'} = $svc_acct->slipip if $svc_acct->slipip =~ /^[\d\.]+$/; # and $self->slipip ne '0.0.0.0'; + $hash{'servicename'} = ( $svc_acct->radius_groups )[0]; + + my $cust_pkg = $svc_acct->cust_svc->cust_pkg; + $hash{'validto'} = $cust_pkg->bill + if $cust_pkg && $cust_pkg->part_pkg->is_prepaid && $cust_pkg->bill; + + #some other random stuff, should probably be attributes or virtual fields + #$hash{'state'} = 0; #only inserts + #$hash{'badlogins'} = 0; #only inserts + $hash{'maxlogins'} = 1; + $hash{'addeddate'} = $cust_pkg->setup + if $cust_pkg && $cust_pkg->setup; + $hash{'validfrom'} = $cust_pkg->last_bill || $cust_pkg->setup + if $cust_pkg && ( $cust_pkg->last_bill || $cust_pkg->setup ); + $hash{'state'} = $cust_pkg->susp ? 1 : 0 + if $cust_pkg; + %hash; } @@ -99,6 +118,8 @@ sub radiator_queue { sub radiator_insert { #subroutine, not method my $dbh = radiator_connect(shift, shift, shift); my %hash = @_; + $hash{'state'} = 0; #see "random stuff" above + $hash{'badlogins'} = 0; #see "random stuff" above my $sth = $dbh->prepare( "INSERT INTO $radusers ( ". join(', ', keys %hash ). ' ) '.