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:49 -0700 |
| commit | 1e2c9c5f859d18d4dc7da8eb1d9b719fd6244aaa (patch) | |
| tree | 50fbe0b86c5ef6d4b6f3b82ada851689063fd91a /FS | |
| parent | 853dc7fbb572fdf15d257412ede37d45f793715c (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) |