From 1e2c9c5f859d18d4dc7da8eb1d9b719fd6244aaa Mon Sep 17 00:00:00 2001
From: Ivan Kohler <ivan@freeside.biz>
Date: Wed, 17 Mar 2021 22:16:16 -0700
Subject: [PATCH] contractually guaranteed speed no longer required as of 2020,
 RT#85671

---
 FS/FS/Report/FCC_477.pm                |  8 +++++---
 httemplate/edit/deploy_zone-fixed.html |  3 +++
 httemplate/elements/tr-note.html       | 12 ++++++++++++
 httemplate/search/477.html             | 19 ++++++++++++++++++-
 4 files changed, 38 insertions(+), 4 deletions(-)
 create mode 100644 httemplate/elements/tr-note.html

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)
diff --git a/httemplate/edit/deploy_zone-fixed.html b/httemplate/edit/deploy_zone-fixed.html
index ce98c46e8..fd138543d 100644
--- a/httemplate/edit/deploy_zone-fixed.html
+++ b/httemplate/edit/deploy_zone-fixed.html
@@ -62,6 +62,9 @@
         'adv_speed_up',
         { type => 'tablebreak-tr-title',
           value => 'Contractually guaranteed speed (Mbps)' },
+        { type => 'note',
+          value => 'Only required for filings as of June 30th, 2019 (due Sep. 3rd, 2019) and before',
+        },
         'cir_speed_down',
         'cir_speed_up',
         { type => 'tablebreak-tr-title', value => 'Footprint'},
diff --git a/httemplate/elements/tr-note.html b/httemplate/elements/tr-note.html
new file mode 100644
index 000000000..8493e5a83
--- /dev/null
+++ b/httemplate/elements/tr-note.html
@@ -0,0 +1,12 @@
+<TR>
+  <TD COLSPAN=<% $opt{colspan} || 2 %> ALIGN="left" <%$id%>>
+    <I><% $opt{value} %></I>
+  </TD>
+</TR>
+
+<%init>
+
+my %opt = @_;
+my $id = 'ID="'.$opt{id}.'"' if $opt{id};
+
+</%init>
diff --git a/httemplate/search/477.html b/httemplate/search/477.html
index 84fd7fb9f..9a4126121 100644
--- a/httemplate/search/477.html
+++ b/httemplate/search/477.html
@@ -67,6 +67,9 @@ a.download {
     <a class="download" href="<% $cgi->self_url %>">Download</a>
   </caption>
 %   my $header = ".header_$partname";
+%   $header .= '_old' if $partname eq 'fbd' && $date < 1569826800; #9/30/2019
+%              # ( halfway between the two filing "as of" dates when it changed
+
 %   my $data = $this_part->{data};
 %   my $error = $this_part->{error};
   <thead>
@@ -168,7 +171,7 @@ if ( $cgi->param('type') eq 'csv' ) {
 my $part_titles = FS::Report::FCC_477->parts;
 
 </%init>
-<%def .header_fbd>
+<%def .header_fbd_old>
   <TR CLASS="head">
     <TD ROWSPAN=2>Census Block</TD>
     <TD ROWSPAN=2>DBA Name</TD>
@@ -185,6 +188,20 @@ my $part_titles = FS::Report::FCC_477->parts;
     <TD>Up</TD>
   </TR>
 </%def>
+<%def .header_fbd>
+  <TR CLASS="head">
+    <TD ROWSPAN=2>Census Block</TD>
+    <TD ROWSPAN=2>DBA Name</TD>
+    <TD ROWSPAN=2>Technology</TD>
+    <TD ROWSPAN=2>Consumer?</TD>
+    <TD COLSPAN=2>Advertised Speed (Mbps)</TD>
+    <TD ROWSPAN=2>Business?</TD>
+  </TR>
+  <TR CLASS="subhead">
+    <TD>Down</TD>
+    <TD>Up</TD>
+  </TR>
+</%def>
 <%def .header_fbs>
   <TR CLASS="head">
     <TD ROWSPAN=2>Census Tract</TD>
-- 
2.11.0