httemplate/misc/rate_edit_excel.html

   1 <% include('/elements/header.html', 'Edit rates with Excel' ) %>
   2
   3 <% include( '/elements/form-file_upload.html',
   4               'name'      => 'RateImportForm',
   5               'action'    => 'process/rate_edit_excel.html',
   6               'num_files' => 1,
   7               'fields'    => [ 'format' ], #?
   8               'message'   => 'Rate edit successful',
   9               'url'       => $p."browse/rate_region.html",
  10           )
  11 %>
  12
  13 <% &ntable("#cccccc", 2) %>
  14
  15   <TR>
  16     <TH ALIGN="left">1. Download current rates:</TH>
  17     <TD>
  18       <A HREF="<%$p%>/browse/rate_region.html?show_rates=1;_type=regions.xls">Download rate spreadsheet</A>
  19     </TD>
  20   </TR>
  21
  22   <TR>
  23     <TH ALIGN="left" COLSPAN=2>2. Edit rates with Excel (or other .XLS-compatible application)</TH>
  24   </TR>
  25
  26   <% include( '/elements/file-upload.html',
  27                 'field' => 'file',
  28                 'label' => '3. Upload edited rate file: '. ( '&nbsp'x4 ), #yuck
  29             )
  30   %>
  31
  32   <TR>
  33     <TD COLSPAN=2 ALIGN="center" STYLE="padding-top:6px">
  34       <INPUT TYPE    = "submit"
  35              ID      = "submit"
  36              VALUE   = "Upload"
  37              onClick = "document.RateImportForm.submit.disabled=true;"
  38       >
  39     </TD>
  40   </TR>
  41
  42
  43 </TABLE>
  44
  45 <% include('/elements/footer.html') %>
  46 <%init>
  47
  48 die "access denied"
  49   unless $FS::CurrentUser::CurrentUser->access_right('Configuration');
  50
  51 </%init>