Merge branch 'master' of https://github.com/jgoodman/Freeside

[freeside.git] / httemplate / search / report_477.html

diff --git a/httemplate/search/report_477.html b/httemplate/search/report_477.html
index 7ac497a..a5dd70b 100755 (executable)
--- a/httemplate/search/report_477.html
+++ b/httemplate/search/report_477.html
@@ -17,8 +17,27 @@
                )
     %>
 
+%   # not tr-select-state, we only want to choose from among those that 
+%   # have customers
+    <& /elements/tr-select-table.html,
+        'label'         => 'State',
+        'field'         => 'state',
+        'table'         => 'cust_location',
+        'name_col'      => 'state',
+        'value_col'     => 'state',
+        'disable_empty' => 1,
+        'records'       => \@states,
+    &>
+
+    <& /elements/tr-input-date-field.html, {
+        'label'         => 'As of date',
+        'name'          => 'date',
+        'value'         => '',
+        'format'        => '%m/%d/%Y'
+    } &>
+
     <% include( '/elements/tr-select-pkg_class.html',
-                   'pre_options' => [ '0' => 'all' ],
+                   'multiple'       => 1,
                    'empty_label' => '(empty class)',
                )
     %>
@@ -33,19 +52,30 @@
           element.style.display = 'none';
         }
       }
+      function toggleV() {
+        document.getElementById('enableV').disabled =
+          ! (document.getElementById('enableIIA').checked ||
+             document.getElementById('enableIIB').checked);
+      }
+      function toggleVI() {
+        document.getElementById('enableVI').disabled =
+          ! document.getElementById('enableIA').checked;
+      }
     </SCRIPT>
 
     <% include( '/elements/tr-checkbox.html',
                    'label' => 'Enable part IA?',
                    'field' => 'part',
+                   'id'    => 'enableIA',
                    'value' => 'IA',
-                   'onchange' => 'partchange(this)',
+                   'onchange' => 'partchange(this); toggleVI();',
                )
     %>
 
     <TR id='partIA' style="display:none"><TD>Part IA</TD><TD><TABLE>
       <TR><TD>Download speeds</TD><TD>
         <TABLE>
+%       my $i = 0;
 %       foreach my $speed ( @FS::Report::FCC_477::download ) {
           <TR>
             <TH><% $speed %></TH>
@@ -56,14 +86,18 @@
                            'hashref'      => { 'disabled' => '' },
                            'element_name' => 'part1_column_option',
                            'disable_empty' => 1,
+                           'curr_value'   =>
+                                FS::Report::FCC_477::restore_fcc477map("part1_column_option_$i"),
                        )
             %>
             </TD>
           </TR>
+%       $i++
 %       }
         </TABLE></TD>
       <TD>Upload speeds</TD><TD>
         <TABLE>
+%       $i = 0;
 %       foreach my $speed ( @FS::Report::FCC_477::upload ) {
           <TR>
             <TH><% $speed %></TH>
@@ -74,15 +108,18 @@
                            'hashref'      => { 'disabled' => '' },
                            'element_name' => 'part1_row_option',
                            'disable_empty' => 1,
+                           'curr_value'   =>
+                                FS::Report::FCC_477::restore_fcc477map("part1_row_option_$i"),
                        )
             %>
             </TD>
           </TR>
+%       $i++
 %       }
         </TABLE></TD></TR>
       <TR><TD>Technologies</TD><TD>
         <TABLE>
-%       my $i = 0;
+%       $i = 0;
 %       foreach my $tech ( @FS::Report::FCC_477::technology ) {
           <TR>
             <TH><% $tech %></TH>
@@ -93,6 +130,8 @@
                            'hashref'      => { 'disabled' => '' },
                            'element_name' => "part1_technology_option_$i",
                            'empty_label'  => '(omit)',
+                           'curr_value'   =>
+                                FS::Report::FCC_477::restore_fcc477map("part1_technology_option_$i"),
                        )
             %>
             </TD>
@@ -105,12 +144,14 @@
     <% include( '/elements/tr-checkbox.html',
                    'label' => 'Enable part IIA?',
                    'field' => 'part',
+                   'id'    => 'enableIIA',
                    'value' => 'IIA',
-                   'onchange' => 'partchange(this)',
+                   'onchange' => 'partchange(this); toggleV();',
                )
     %>
 
     <TR id='partIIA' style="display:none"><TD>Part IIA</TD><TD><TABLE>
+%   $i = 0;
 %   foreach my $option ( @FS::Report::FCC_477::part2aoption ) {
     <TR>
       <TH><% $option %></TH>
@@ -120,22 +161,27 @@
                      'name_col'     => 'name',
                      'hashref'      => { 'disabled' => '' },
                      'element_name' => 'part2a_row_option',
+                     'curr_value'   =>
+                           FS::Report::FCC_477::restore_fcc477map("part2a_row_option_$i"),
                  )
       %>
       </TD>
     </TR>
+%    $i++
 %   }
   </TABLE></TD></TR>
 
     <% include( '/elements/tr-checkbox.html',
                    'label' => 'Enable part IIB?',
                    'field' => 'part',
+                   'id'    => 'enableIIB',
                    'value' => 'IIB',
-                   'onchange' => 'partchange(this)',
+                   'onchange' => 'partchange(this); toggleV();',
                )
     %>
 
     <TR id='partIIB' style="display:none"><TD>Part IIB</TD><TD><TABLE>
+%   $i = 0;
 %   foreach my $option ( @FS::Report::FCC_477::part2boption ) {
     <TR>
       <TH><% $option %></TH>
@@ -145,16 +191,20 @@
                      'name_col'     => 'name',
                      'hashref'      => { 'disabled' => '' },
                      'element_name' => 'part2b_row_option',
+                      'curr_value'   =>
+                            FS::Report::FCC_477::restore_fcc477map("part2b_row_option_$i"),
                  )
       %>
       </TD>
     </TR>
+%    $i++
 %   }
   </TABLE></TD></TR>
 
     <% include( '/elements/tr-checkbox.html',
                    'label' => 'Enable part IV?',
                    'field' => 'part',
+                   'id'    => 'enableIV', #unused
                    'value' => 'IV',
                    'onchange' => 'partchange(this)',
                )
@@ -175,16 +225,41 @@
                    'label' => 'Enable part V?',
                    'field' => 'part',
                    'value' => 'V',
+                   'id'    => 'enableV',
+                   'onchange' => 'partchange(this)',
+                   'postfix'  => 
+                    '&nbsp;<FONT SIZE="-1">(requires Part IIA or IIB)</FONT>',
                )
     %>
+    <TR id='partV' style="display:none">
+        <TD>Part V</TD>
+        <TD>
+            <% include( '/elements/select-table.html',
+                     'table'        => 'part_pkg_report_option',
+                     'name_col'     => 'name',
+                     'hashref'      => { 'disabled' => '' },
+                     'element_name' => 'part5_report_option',
+                     'curr_value'   =>
+                            FS::Report::FCC_477::restore_fcc477map("part5_report_option"),
+                 )
+            %>
+        </TD>
+    </TR>
+
 
     <% include( '/elements/tr-checkbox.html',
                    'label' => 'Enable part VI?',
                    'field' => 'part',
+                   'id'    => 'enableVI',
                    'value' => 'VI_census',
+                   'postfix'  =>
+                    '&nbsp;<FONT SIZE="-1">(requires part IA)</FONT>',
                )
     %>
-
+  <SCRIPT TYPE="text/javascript">
+  toggleV();
+  toggleVI();
+  </SCRIPT>
   </TABLE>
 
 <BR>
@@ -198,4 +273,10 @@
 die "access denied"
   unless $FS::CurrentUser::CurrentUser->access_right('List packages');
 
+my @states = qsearch({
+  'table'   => 'cust_location',
+  'select'  => 'DISTINCT(state)',
+  'hashref' => { 'country' => 'US' }, # 477 report isn't relevant elsewhere
+});
+
 </%init>