projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
contractually guaranteed speed no longer required as of 2020, RT#85671
[freeside.git]
/
FS
/
FS
/
Report
/
FCC_477.pm
diff --git
a/FS/FS/Report/FCC_477.pm
b/FS/FS/Report/FCC_477.pm
index
75ddee0
..
bb01db4
100644
(file)
--- 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',
'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)
my $from = 'deploy_zone_block
JOIN deploy_zone USING (zonenum)