1 package FS::part_export::saisei;
4 use vars qw( @ISA %info );
5 use base qw( FS::part_export );
6 use Date::Format 'time2str';
18 FS::part_export::saisei
22 Saisei integration for Freeside
26 This export offers basic svc_broadband provisioning for Saisei.
28 This is a customer integration with Saisei. This will set up a rate plan and tie
29 the rate plan to a host and the access point via the Saisei API when the broadband service is provisioned.
30 It will also untie the host from the rate plan, setting it to the default rate plan via the API upon unprovisioning of the broadband service.
32 This will create and modify the rate plans at Saisei as soon as the broadband service attached to this export is created or modified.
33 This will also create and modify an access point at Saisei as soon as the tower is created or modified.
35 To use this export, follow the below instructions:
37 Create a new service definition and set the table to svc_broadband. The service name will become the Saisei rate plan name.
38 Set the upload and download speed for the service. This is required to be able to export the service to Saisei.
39 Attach this Saisei export to this service.
41 Create a tower and add a sector to that tower. The sector name will be the name of the access point,
42 Make sure you have set the up and down rate limit for the tower and the sector. This is required to be able to export the access point.
43 The tower and sector will be set up as access points at Saisei upon the creation of the tower or sector. They will be modified at Saisei when modified in freeside.
44 Each sector will be attached to its tower access point using the Saisei uplink field.
46 Create a package for the above created service, and order this package for a customer.
48 Provision the service, making sure to enter the IP address associated with this service and select the tower and sector for it's access point.
49 This provisioned service will then be exported as a host to Saisei.
51 Unprovisioning this service will set the host entry at Saisei to the default rate plan with the user and access point set to <none>.
53 After this export is set up and attached to a service, you can export the already provisioned services by clicking the link Export provisioned services attached to this export.
54 Clicking on this link will export all services attached to this export not currently exported to Saisei.
56 This module also provides generic methods for working through the L</Saisei API>.
60 tie my %scripts, 'Tie::IxHash',
61 'export_provisioned_services' => { component => '/elements/popup_link.html',
62 label => 'Export provisioned services',
63 description => 'will export provisioned services of part service with Saisei export attached.',
64 html_label => '<b>Export provisioned services attached to this export.</b>',
68 tie my %options, 'Tie::IxHash',
69 'port' => { label => 'Port',
71 'username' => { label => 'Saisei API User Name',
73 'password' => { label => 'Saisei API Password',
75 'debug' => { type => 'checkbox',
76 label => 'Enable debug warnings' },
80 'svc' => 'svc_broadband',
81 'desc' => 'Export broadband service/account to Saisei',
82 'options' => \%options,
83 'scripts' => \%scripts,
85 This is a customer integration with Saisei. This will set up a rate plan and tie
86 the rate plan to a host and the access point via the Saisei API when the broadband service is provisioned.
87 It will also untie the host from the rate plan, setting it to the default rate plan via the API upon unprovisioning of the broadband service.
89 This will create and modify the rate plans at Saisei as soon as the broadband service attached to this export is created or modified.
90 This will also create and modify an access point at Saisei as soon as the tower is created or modified.
92 To use this export, follow the below instructions:
96 Create a new service definition and set the table to svc_broadband. The service name will become the Saisei rate plan name.
97 Set the upload and download speed for the service. This is required to be able to export the service to Saisei.
98 Attach this Saisei export to this service.
102 Create a tower and add a sector to that tower. The sector name will be the name of the access point,
103 Make sure you have set the up and down rate limit for the tower and the sector. This is required to be able to export the access point.
104 The tower and sector will be set up as access points at Saisei upon the creation of the tower or sector. They will be modified at Saisei when modified in freeside.
105 Each sector will be attached to its tower access point using the Saisei uplink field.
109 Create a package for the above created service, and order this package for a customer.
113 Provision the service, making sure to enter the IP address associated with this service and select the tower and sector for it's access point.
114 This provisioned service will then be exported as a host to Saisei.
116 Unprovisioning this service will set the host entry at Saisei to the default rate plan with the user and access point set to <i>none</i>.
120 After this export is set up and attached to a service, you can export the already provisioned services by clicking the link <b>Export provisioned services attached to this export</b>.
121 Clicking on this link will export all services attached to this export not currently exported to Saisei.
130 my ($self, $svc_broadband) = @_;
132 my $rateplan_name = $self->get_rateplan_name($svc_broadband);
134 # check for existing rate plan
135 my $existing_rateplan;
136 $existing_rateplan = $self->api_get_rateplan($rateplan_name) unless $self->{'__saisei_error'};
138 # if no existing rate plan create one and modify it.
139 $self->api_create_rateplan($svc_broadband, $rateplan_name) unless $existing_rateplan;
140 $self->api_modify_rateplan($svc_broadband, $rateplan_name) unless ($self->{'__saisei_error'} || $existing_rateplan);
141 return $self->api_error if $self->{'__saisei_error'};
143 # set rateplan to existing one or newly created one.
144 my $rateplan = $existing_rateplan ? $existing_rateplan : $self->api_get_rateplan($rateplan_name);
146 my $username = $svc_broadband->{Hash}->{svcnum};
147 my $description = $svc_broadband->{Hash}->{description};
150 $self->{'__saisei_error'} = 'no username - can not export';
151 return $self->api_error;
154 # check for existing user.
156 $existing_user = $self->api_get_user($username) unless $self->{'__saisei_error'};
158 # if no existing user create one.
159 $self->api_create_user($username, $description) unless $existing_user;
160 return $self->api_error if $self->{'__saisei_error'};
162 # set user to existing one or newly created one.
163 my $user = $existing_user ? $existing_user : $self->api_get_user($username);
166 my $tower_sector = FS::Record::qsearchs({
167 'table' => 'tower_sector',
168 'select' => 'tower.towername,
169 tower.up_rate_limit as tower_upratelimit,
170 tower.down_rate_limit as tower_downratelimit,
171 tower_sector.sectorname,
172 tower_sector.up_rate_limit as sector_upratelimit,
173 tower_sector.down_rate_limit as sector_downratelimit ',
174 'addl_from' => 'LEFT JOIN tower USING ( towernum )',
176 'sectornum' => $svc_broadband->{Hash}->{sectornum},
180 my $tower_name = $tower_sector->{Hash}->{towername};
181 $tower_name =~ s/\s/_/g;
184 'tower_name' => $tower_name,
185 'tower_uprate_limit' => $tower_sector->{Hash}->{tower_upratelimit},
186 'tower_downrate_limit' => $tower_sector->{Hash}->{tower_downratelimit},
189 my $tower_ap = process_tower($self, $tower_opt);
190 return $self->api_error if $self->{'__saisei_error'};
192 my $sector_name = $tower_sector->{Hash}->{sectorname};
193 $sector_name =~ s/\s/_/g;
196 'tower_name' => $tower_name,
197 'sector_name' => $sector_name,
198 'sector_uprate_limit' => $tower_sector->{Hash}->{sector_upratelimit},
199 'sector_downrate_limit' => $tower_sector->{Hash}->{sector_downratelimit},
201 my $accesspoint = process_sector($self, $sector_opt);
202 return $self->api_error if $self->{'__saisei_error'};
204 ## tie host to user add sector name as access point.
205 $self->api_add_host_to_user(
206 $user->{collection}->[0]->{name},
207 $rateplan->{collection}->[0]->{name},
208 $svc_broadband->{Hash}->{ip_addr},
209 $accesspoint->{collection}->[0]->{name},
210 ) unless $self->{'__saisei_error'};
213 return $self->api_error;
217 sub _export_replace {
218 my ($self, $svc_broadband) = @_;
219 $self->_export_insert($svc_broadband);
224 my ($self, $svc_broadband) = @_;
226 my $rateplan_name = $self->get_rateplan_name($svc_broadband);
228 my $username = $svc_broadband->{Hash}->{svcnum};
230 ## untie host to user
231 $self->api_delete_host_to_user($username, $rateplan_name, $svc_broadband->{Hash}->{ip_addr}) unless $self->{'__saisei_error'};
236 sub _export_suspend {
237 my ($self, $svc_broadband) = @_;
241 sub _export_unsuspend {
242 my ($self, $svc_broadband) = @_;
247 my ($self, $svc_part) = @_;
250 if ($svc_part->{Hash}->{svc_broadband__speed_down} eq "down" || $svc_part->{Hash}->{svc_broadband__speed_up} eq "up") {
251 for my $type (qw( down up )) {
252 my $speed_type = "broadband_".$type."stream";
253 foreach my $pkg_svc (FS::Record::qsearch({
254 'table' => 'pkg_svc',
255 'select' => 'pkg_svc.*, part_pkg_fcc_option.fccoptionname, part_pkg_fcc_option.optionvalue',
256 'addl_from' => ' LEFT JOIN part_pkg_fcc_option USING (pkgpart) ',
257 'extra_sql' => " WHERE pkg_svc.svcpart = ".$svc_part->{Hash}->{svcpart}." AND pkg_svc.quantity > 0 AND part_pkg_fcc_option.fccoptionname = '".$speed_type."'",
258 })) { $fcc_477_speeds->{
259 $pkg_svc->{Hash}->{pkgpart}}->{$speed_type} = $pkg_svc->{Hash}->{optionvalue} * 1000 unless !$pkg_svc->{Hash}->{optionvalue}; }
263 $fcc_477_speeds->{1}->{broadband_downstream} = $svc_part->{Hash}->{"svc_broadband__speed_down"};
264 $fcc_477_speeds->{1}->{broadband_upstream} = $svc_part->{Hash}->{"svc_broadband__speed_up"};
267 foreach my $key (keys %$fcc_477_speeds) {
269 $svc_part->{Hash}->{speed_down} = $fcc_477_speeds->{$key}->{broadband_downstream};
270 $svc_part->{Hash}->{speed_up} = $fcc_477_speeds->{$key}->{broadband_upstream};
271 $svc_part->{Hash}->{svc_broadband__speed_down} = $fcc_477_speeds->{$key}->{broadband_downstream};
272 $svc_part->{Hash}->{svc_broadband__speed_up} = $fcc_477_speeds->{$key}->{broadband_upstream};
274 my $temp_svc = $svc_part->{Hash};
275 my $svc_broadband = {};
276 map { if ($_ =~ /^svc_broadband__(.*)$/) { $svc_broadband->{Hash}->{$1} = $temp_svc->{$_}; } } keys %$temp_svc;
278 my $rateplan_name = $self->get_rateplan_name($svc_broadband, $svc_part->{Hash}->{svc});
280 # check for existing rate plan
281 my $existing_rateplan;
282 $existing_rateplan = $self->api_get_rateplan($rateplan_name) unless $self->{'__saisei_error'};
284 # Modify the existing rate plan with new service data.
285 $self->api_modify_existing_rateplan($svc_broadband, $rateplan_name) unless ($self->{'__saisei_error'} || !$existing_rateplan);
287 # if no existing rate plan create one and modify it.
288 $self->api_create_rateplan($svc_broadband, $rateplan_name) unless $existing_rateplan;
289 $self->api_modify_rateplan($svc_part, $rateplan_name) unless ($self->{'__saisei_error'} || $existing_rateplan);
293 return $self->api_error;
297 sub export_tower_sector {
298 my ($self, $tower) = @_;
300 #modify tower or create it.
301 my $tower_name = $tower->{Hash}->{towername};
302 $tower_name =~ s/\s/_/g;
304 'tower_name' => $tower_name,
305 'tower_uprate_limit' => $tower->{Hash}->{up_rate_limit},
306 'tower_downrate_limit' => $tower->{Hash}->{down_rate_limit},
307 'modify_existing' => '1', # modify an existing access point with this info
310 my $tower_access_point = process_tower($self, $tower_opt);
312 #get list of all access points
314 'table' => 'tower_sector',
316 'hashref' => { 'towernum' => $tower->{Hash}->{towernum}, },
319 #for each one modify or create it.
320 foreach my $tower_sector ( FS::Record::qsearch($hash_opt) ) {
321 my $sector_name = $tower_sector->{Hash}->{sectorname};
322 $sector_name =~ s/\s/_/g;
324 'tower_name' => $tower_name,
325 'sector_name' => $sector_name,
326 'sector_uprate_limit' => $tower_sector->{Hash}->{up_rate_limit},
327 'sector_downrate_limit' => $tower_sector->{Hash}->{down_rate_limit},
328 'modify_existing' => '1', # modify an existing access point with this info
330 my $sector_access_point = process_sector($self, $sector_opt);
333 return $self->api_error;
336 ## creates the rateplan name
337 sub get_rateplan_name {
338 my ($self, $svc_broadband, $svc_name) = @_;
340 my $service_part = FS::Record::qsearchs( 'part_svc', { 'svcpart' => $svc_broadband->{Hash}->{svcpart} } ) unless $svc_name;
341 my $service_name = $svc_name ? $svc_name : $service_part->{Hash}->{svc};
343 my $rateplan_name = $service_name . " " . $svc_broadband->{Hash}->{speed_down} . "-" . $svc_broadband->{Hash}->{speed_up};
344 $rateplan_name =~ s/\s/_/g;
346 return $rateplan_name;
351 These methods allow access to the Saisei API using the credentials
352 set in the export options.
358 Accepts I<$method>, I<$path>, I<$params> hashref and optional.
359 Places an api call to the specified path and method with the specified params.
360 Returns the decoded json object returned by the api call.
361 Returns empty on failure; retrieve error messages using L</api_error>.
366 my ($self,$method,$path,$params) = @_;
368 $self->{'__saisei_error'} = '';
369 my $auth_info = $self->option('username') . ':' . $self->option('password');
372 warn "Calling $method on http://"
373 .$self->{Hash}->{machine}.':'.$self->option('port')
374 ."/rest/stm/configurations/running/$path\n" if $self->option('debug');
376 my $data = encode_json($params) if keys %{ $params };
378 my $client = REST::Client->new();
379 $client->addHeader("Authorization", "Basic ".encode_base64($auth_info));
380 $client->setHost('http://'.$self->{Hash}->{machine}.':'.$self->option('port'));
381 $client->$method('/rest/stm/configurations/running'.$path, $data, { "Content-type" => 'application/json'});
383 warn "Response Code is ".$client->responseCode()."\n" if $self->option('debug');
387 if ($client->responseCode() eq '200' || $client->responseCode() eq '201') {
388 eval { $result = decode_json($client->responseContent()) };
390 $self->{'__saisei_error'} = "Error decoding json: $@";
395 $self->{'__saisei_error'} = "Bad response from server during $method: " . $client->responseContent()
396 unless ($method eq "GET");
397 warn "Response Content is\n".$client->responseContent."\n" if $self->option('debug');
407 Returns the error string set by L</Saisei API> methods,
408 or a blank string if most recent call produced no errors.
414 return $self->{'__saisei_error'} || '';
417 =head2 api_get_policies
419 Gets a list of global policies.
423 sub api_get_policies {
426 my $get_policies = $self->api_call("GET", '/policies/?token=1&order=name&start=0&limit=20&select=name%2Cpercent_rate%2Cassured%2C');
427 return if $self->api_error;
428 $self->{'__saisei_error'} = "Did not receive any global policies"
429 unless $get_policies;
431 return $get_policies->{collection};
434 =head2 api_get_rateplan
436 Gets rateplan info for specific rateplan.
440 sub api_get_rateplan {
442 my $rateplan = shift;
444 my $get_rateplan = $self->api_call("GET", "/rate_plans/$rateplan");
445 return if $self->api_error;
447 return $get_rateplan;
452 Gets user info for specific user.
460 my $get_user = $self->api_call("GET", "/users/$user");
461 return if $self->api_error;
466 =head2 api_get_accesspoint
468 Gets user info for specific access point.
472 sub api_get_accesspoint {
474 my $accesspoint = shift;
476 my $get_accesspoint = $self->api_call("GET", "/access_points/$accesspoint");
477 return if $self->api_error;
479 return $get_accesspoint;
484 Gets user info for specific host.
492 my $get_host = $self->api_call("GET", "/hosts/$ip");
494 return if $self->api_error;
499 =head2 api_create_rateplan
505 sub api_create_rateplan {
506 my ($self, $svc, $rateplan) = @_;
508 $self->{'__saisei_error'} = "No downrate listed for service $rateplan" if !$svc->{Hash}->{speed_down};
509 $self->{'__saisei_error'} = "No uprate listed for service $rateplan" if !$svc->{Hash}->{speed_up};
511 my $new_rateplan = $self->api_call(
513 "/rate_plans/$rateplan",
515 'downstream_rate' => $svc->{Hash}->{speed_down},
516 'upstream_rate' => $svc->{Hash}->{speed_up},
518 ) unless $self->{'__saisei_error'};
520 $self->{'__saisei_error'} = "Rate Plan not created"
521 unless ($new_rateplan || $self->{'__saisei_error'});
523 return $new_rateplan;
527 =head2 api_modify_rateplan
529 Modify a new rateplan.
533 sub api_modify_rateplan {
534 my ($self,$svc,$rateplan_name) = @_;
537 my $policies = $self->api_get_policies();
539 foreach my $policy (@$policies) {
540 my $policyname = $policy->{name};
541 my $rate_multiplier = '';
542 if ($policy->{background}) { $rate_multiplier = ".01"; }
543 my $modified_rateplan = $self->api_call(
545 "/rate_plans/$rateplan_name/partitions/$policyname",
547 'restricted' => $policy->{assured}, # policy_assured_flag
548 'rate_multiplier' => $rate_multiplier, # policy_background 0.1
549 'rate' => $policy->{percent_rate}, # policy_percent_rate
553 $self->{'__saisei_error'} = "Rate Plan not modified after create"
554 unless ($modified_rateplan || $self->{'__saisei_error'}); # should never happen
562 =head2 api_modify_existing_rateplan
564 Modify a existing rateplan.
568 sub api_modify_existing_rateplan {
569 my ($self,$svc,$rateplan_name) = @_;
571 my $modified_rateplan = $self->api_call(
573 "/rate_plans/$rateplan_name",
575 'downstream_rate' => $svc->{Hash}->{speed_down},
576 'upstream_rate' => $svc->{Hash}->{speed_up},
580 $self->{'__saisei_error'} = "Rate Plan not modified"
581 unless ($modified_rateplan || $self->{'__saisei_error'}); # should never happen
587 =head2 api_create_user
593 sub api_create_user {
594 my ($self,$user, $description) = @_;
596 my $new_user = $self->api_call(
600 'description' => $description,
604 $self->{'__saisei_error'} = "User not created"
605 unless ($new_user || $self->{'__saisei_error'}); # should never happen
611 =head2 api_create_accesspoint
613 Creates a access point.
617 sub api_create_accesspoint {
618 my ($self,$accesspoint, $upratelimit, $downratelimit) = @_;
620 # this has not been tested, but should work, if needed.
621 my $new_accesspoint = $self->api_call(
623 "/access_points/$accesspoint",
625 'downstream_rate_limit' => $downratelimit,
626 'upstream_rate_limit' => $upratelimit,
630 $self->{'__saisei_error'} = "Access point not created"
631 unless ($new_accesspoint || $self->{'__saisei_error'}); # should never happen
636 =head2 api_modify_accesspoint
638 Modify a new access point.
642 sub api_modify_accesspoint {
643 my ($self, $accesspoint, $uplink) = @_;
645 my $modified_accesspoint = $self->api_call(
647 "/access_points/$accesspoint",
649 'uplink' => $uplink, # name of attached access point
653 $self->{'__saisei_error'} = "Rate Plan not modified"
654 unless ($modified_accesspoint || $self->{'__saisei_error'}); # should never happen
660 =head2 api_modify_existing_accesspoint
662 Modify a existing accesspoint.
666 sub api_modify_existing_accesspoint {
667 my ($self, $accesspoint, $uplink, $upratelimit, $downratelimit) = @_;
669 my $modified_accesspoint = $self->api_call(
671 "/access_points/$accesspoint",
673 'downstream_rate_limit' => $downratelimit,
674 'upstream_rate_limit' => $upratelimit,
675 # 'uplink' => $uplink, # name of attached access point
679 $self->{'__saisei_error'} = "Access point not modified"
680 unless ($modified_accesspoint || $self->{'__saisei_error'}); # should never happen
686 =head2 api_add_host_to_user
688 ties host to user, rateplan and default access point.
692 sub api_add_host_to_user {
693 my ($self,$user, $rateplan, $ip, $accesspoint) = @_;
695 my $new_host = $self->api_call(
700 'rate_plan' => $rateplan,
701 'access_point' => $accesspoint,
705 $self->{'__saisei_error'} = "Host not created"
706 unless ($new_host || $self->{'__saisei_error'}); # should never happen
712 =head2 api_delete_host_to_user
714 unties host from user and rateplan.
715 this will set the host entry at Saisei to the default rate plan with the user and access point set to <none>.
719 sub api_delete_host_to_user {
720 my ($self,$user, $rateplan, $ip) = @_;
722 my $default_rate_plan = $self->api_call("GET", '?token=1&select=default_rate_plan');
723 return if $self->api_error;
724 $self->{'__saisei_error'} = "Did not receive a default rate plan"
725 unless $default_rate_plan;
727 my $default_rateplan_name = $default_rate_plan->{collection}->[0]->{default_rate_plan}->{link}->{name};
729 my $delete_host = $self->api_call(
734 'access_point' => '<none>',
735 'rate_plan' => $default_rateplan_name,
739 $self->{'__saisei_error'} = "Host not created"
740 unless ($delete_host || $self->{'__saisei_error'}); # should never happen
747 my ($self, $opt) = @_;
749 my $existing_tower_ap;
750 my $tower_name = $opt->{tower_name};
752 #check if tower has been set up as an access point.
753 $existing_tower_ap = $self->api_get_accesspoint($tower_name) unless $self->{'__saisei_error'};
755 # modify the existing accesspoint if changing tower .
756 $self->api_modify_existing_accesspoint (
758 '', # tower does not have a uplink on sectors.
759 $opt->{tower_uprate_limit},
760 $opt->{tower_downrate_limit},
761 ) if $existing_tower_ap && $opt->{modify_existing};
763 #if tower does not exist as an access point create it.
764 $self->api_create_accesspoint(
766 $opt->{tower_uprate_limit},
767 $opt->{tower_downrate_limit}
768 ) unless $existing_tower_ap;
770 my $accesspoint = $self->api_get_accesspoint($tower_name);
776 my ($self, $opt) = @_;
778 my $existing_sector_ap;
779 my $sector_name = $opt->{sector_name};
781 #check if sector has been set up as an access point.
782 $existing_sector_ap = $self->api_get_accesspoint($sector_name);
784 # modify the existing accesspoint if changing sector .
785 $self->api_modify_existing_accesspoint (
788 $opt->{sector_uprate_limit},
789 $opt->{sector_downrate_limit},
790 ) if $existing_sector_ap && $opt->{modify_existing};
792 #if sector does not exist as an access point create it.
793 $self->api_create_accesspoint(
795 $opt->{sector_uprate_limit},
796 $opt->{sector_downrate_limit},
797 ) unless $existing_sector_ap;
799 # Attach newly created sector to it's tower.
800 $self->api_modify_accesspoint($sector_name, $opt->{tower_name}) unless ($self->{'__saisei_error'} || $existing_sector_ap);
802 # set access point to existing one or newly created one.
803 my $accesspoint = $existing_sector_ap ? $existing_sector_ap : $self->api_get_accesspoint($sector_name);
808 sub export_provisioned_services {
810 my $param = thaw(decode_base64(shift));
812 my $part_export = FS::Record::qsearchs('part_export', { 'exportnum' => $param->{export_provisioned_services_exportnum}, } )
813 or die "unknown exportnum $param->{export_provisioned_services_exportnum}";
816 my @svcparts = FS::Record::qsearch({
817 'table' => 'export_svc',
818 'addl_from' => 'LEFT JOIN part_svc USING ( svcpart ) ',
819 'hashref' => { 'exportnum' => $param->{export_provisioned_services_exportnum}, },
821 my $part_count = scalar @svcparts;
823 my $parts = join "', '", map { $_->{Hash}->{svcpart} } @svcparts;
825 my @svcs = FS::Record::qsearch({
826 'table' => 'cust_svc',
827 'addl_from' => 'LEFT JOIN svc_broadband USING ( svcnum ) ',
828 'extra_sql' => " WHERE svcpart in ('".$parts."')",
831 my $svc_count = scalar @svcs;
834 for (my $c=1; $c <=100; $c=$c+1) { $status{int($svc_count * ($c/100))} = $c; }
837 foreach my $svc (@svcs) {
838 if ($status{$process_count}) { my $s = $status{$process_count}; $job->update_statustext($s); }
839 ## check if service exists as host if not export it.
840 _export_insert($part_export,$svc) unless api_get_host($part_export, $svc->{Hash}->{ip_addr});