diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2021-03-17 22:16:16 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2021-03-17 22:16:16 -0700 |
| commit | 5bf0ab2d129310be344a9654c14796c7424138a8 (patch) | |
| tree | 78ddb68d1a60f8d455640e0681df6a8cbaf92b31 /FS | |
| parent | 20961c94ea06ad3aa71fad2bd7f6903f83f02ebc (diff) | |
contractually guaranteed speed no longer required as of 2020, RT#85671
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/Report/FCC_477.pm | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/FS/FS/Report/FCC_477.pm b/FS/FS/Report/FCC_477.pm index 75ddee0d7..bb01db4c8 100644 --- a/FS/FS/Report/FCC_477.pm +++ b/FS/FS/Report/FCC_477.pm @@ -365,10 +365,12 @@ sub fbd_sql { 'adv_speed_down', 'adv_speed_up', 'CASE WHEN is_business IS NOT NULL THEN 1 ELSE 0 END', - 'cir_speed_down', - 'cir_speed_up', ); - push @select, 'blocknum' if $opt{detail}; + push @select, 'cir_speed_down', 'cir_speed_up' + if $opt{date} < 1569826800; #9/30/2019, halfway between the two filing + # "as of" dates when it changed + push @select, 'blocknum' + if $opt{detail}; my $from = 'deploy_zone_block JOIN deploy_zone USING (zonenum) |