4 use FS::UID qw(adminsuidsetup);
5 use FS::Record qw(qsearchs qsearch);
8 my $user = shift or die &usage;
9 my $dbh = adminsuidsetup($user);
11 my $fcc_up_speed = "(select part_pkg_fcc_option.optionvalue from part_pkg_fcc_option where fccoptionname = 'broadband_upstream' and pkgpart = cust_pkg.pkgpart) AS fcc477_upstream";
12 my $fcc_down_speed = "(select part_pkg_fcc_option.optionvalue from part_pkg_fcc_option where fccoptionname = 'broadband_downstream' and pkgpart = cust_pkg.pkgpart) AS fcc477_downstream";
13 foreach my $rec (qsearch({
14 'select' => 'svc_broadband.*, cust_svc.svcpart, cust_pkg.pkgpart, '.$fcc_up_speed.', '.$fcc_down_speed,
15 'table' => 'svc_broadband',
16 'addl_from' => 'LEFT JOIN cust_svc USING ( svcnum ) LEFT JOIN cust_pkg USING ( pkgnum )',
18 $rec->{Hash}->{speed_test_up} = $rec->{Hash}->{speed_up};
19 $rec->{Hash}->{speed_test_down} = $rec->{Hash}->{speed_down};
20 $rec->{Hash}->{speed_up} = $rec->{Hash}->{fcc477_upstream} * 1000;
21 $rec->{Hash}->{speed_down} = $rec->{Hash}->{fcc477_downstream} * 1000;
23 warn "Fixing broadband service speeds for service ".$rec->{Hash}->{svcnum}."-".$rec->{Hash}->{description}."\n";
26 warn "Completed fixing broadband service speeds!\n";
32 move_svc_broadband_speeds
36 move_svc_broadband_speeds.pl [ user ]
40 Moves value for speed_down to speed_test_down, speed_up to speed_test_up,
41 and sets speed_down, speed_up to matching fcc_477 speeds from package for
42 all svc_broadband services.
44 user: freeside username