X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=httemplate%2Fsearch%2F477.html;h=9a412612119dad052ec2e5ff7eb5e355a2e70efb;hb=793956b8a0c19d7d39103e94235b0ca13f0f3e84;hp=fb85f1e09b4771408a54c0c37d8b5192960482ee;hpb=d7cf0d6bb3b81b1c91ef1bcc3252d56f96b65b0f;p=freeside.git
diff --git a/httemplate/search/477.html b/httemplate/search/477.html
index fb85f1e09..9a4126121 100644
--- a/httemplate/search/477.html
+++ b/httemplate/search/477.html
@@ -32,30 +32,78 @@ table.fcc477part thead tr.subhead {
font-size: large;
float: left;
}
+.errortitle {
+ font-weight: bold;
+ color: #ff0000;
+}
+tr.error td {
+ background-color: #ffdddd;
+}
+tr.error td.error {
+ text-align: left;
+ border: none;
+}
+tr.error ul {
+ margin: 0px;
+ list-style-image: url("<% $fsurl %>images/cross.png");
+}
a.download {
float: right;
}
% foreach my $partname (@partnames) {
+% my $this_part = $parts{$partname};
% $cgi->param('parts', $partname);
% $cgi->param('type', 'csv');
<% $part_titles->{$partname} %>
+% if ( $this_part->{num_errors} > 0 ) {
+% # show error heading while it contains errors
+
+ <% emt('This section contains [quant,_1,error].', $this_part->{num_errors}) %>
+
+% }
Download
% my $header = ".header_$partname";
-% my $data = $parts{$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};
<& $header &>
+% my $rownum = 0;
% foreach my $row (@$data) {
-
+% my %eh; # error hash
+% if ( $error->[$rownum] ) {
+% %eh = %{ $error->[$rownum] };
+% }
+
>
+% my $first = 1;
% foreach my $item (@$row) {
- <% $item %> |
+
+% if ($first and $part_link{$partname}) {
+ "><% $item || '(empty)' %>
+% $first = 0;
+% } else {
+ <% $item %>
+% }
+ |
+% } #foreach $item
+% # display errors
+% if ( keys %eh ) {
+
+% foreach my $key (sort keys %eh) {
+ - <% $eh{$key} %>
% }
+ |
+% } # if there are errors
-% }
+% $rownum++;
+% } #foreach $row
% } # foreach $partname
<& /elements/footer.html &>
@@ -64,6 +112,7 @@ die "access denied"
unless $FS::CurrentUser::CurrentUser->access_right('List packages');
my %parts;
+my %part_link;
# load from cache if possible
my $session;
if ( $cgi->param('session') =~ /^(\d+)$/ ) {
@@ -80,11 +129,22 @@ if ($cgi->param('agentnum') =~ /^(\d+)$/ ) {
}
my $date = parse_datetime($cgi->param('date')) || time;
my @partnames = grep /^\w+$/, $cgi->param('parts');
+my $ignore_quantity = ($cgi->param('ignore_quantity') ? 1 : 0);
+
foreach my $partname (@partnames) {
$parts{$partname} ||= FS::Report::FCC_477->report( $partname,
- date => $date,
- agentnum => $agentnum
- );
+ date => $date,
+ agentnum => $agentnum,
+ ignore_quantity => $ignore_quantity,
+ ); # includes error, detail, and data parts
+ my $detail_table = FS::Report::FCC_477->part_table($partname);
+ if ($detail_table eq 'cust_pkg') {
+ my $link = popurl(1).'477_cust_pkg.html?477part='.$partname.";date=$date;";
+ if ($agentnum) {
+ $link .= "agentnum=$agentnum;";
+ }
+ $part_link{$partname} = $link;
+ } # don't include detail links to deploy_blocks, that's pointless
}
$m->cache->set($session, \%parts, '1h');
@@ -92,7 +152,7 @@ my $title = 'FCC Form 477 Data - ' . time2str('%b %o, %Y', $date);
if ( $cgi->param('type') eq 'csv' ) {
my $partname = $partnames[0]; # ignore any beyond the first
- my $data = $parts{$partname};
+ my $data = $parts{$partname}->{data};
my $csv = Text::CSV_XS->new({ eol => "\r\n" }); # i think
my $filename = time2str('%Y-%m-%d', $date) . '-'. $partname . '.csv';
@@ -111,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>
Census Block |
DBA Name |
@@ -128,6 +188,20 @@ my $part_titles = FS::Report::FCC_477->parts;
Up |
%def>
+<%def .header_fbd>
+
+ Census Block |
+ DBA Name |
+ Technology |
+ Consumer? |
+ Advertised Speed (Mbps) |
+ Business? |
+
+
+ Down |
+ Up |
+
+%def>
<%def .header_fbs>
Census Tract |
@@ -190,7 +264,7 @@ my $part_titles = FS::Report::FCC_477->parts;
%def>
<%def .header_voip>
- State |
+ State |
VoIP OTT |
VoIP Non-OTT |