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:38 -0700 |
| commit | 96c3f2f68af47a3ac9dca07c51b7b4d5a0930671 (patch) | |
| tree | a0e229dd6c2cc26d0371a1aa87e35a91b94cb0ef /FS/FS | |
| parent | 9ebca80fb935533c0d9df44eb8a44a631f834d31 (diff) | |
contractually guaranteed speed no longer required as of 2020, RT#85671
Diffstat (limited to 'FS/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 75ddee0..bb01db4 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) |