From 9f73c5d4c0954b3a03bfcb5e010fc288a7071209 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Mon, 4 May 2009 00:22:44 +0000
Subject: add menu item and page for d/ling and edit rates with excel.  RT#5108

---
 httemplate/misc/rate_edit_excel.html | 51 ++++++++++++++++++++++++++++++++++++
 1 file changed, 51 insertions(+)
 create mode 100644 httemplate/misc/rate_edit_excel.html

(limited to 'httemplate/misc/rate_edit_excel.html')

diff --git a/httemplate/misc/rate_edit_excel.html b/httemplate/misc/rate_edit_excel.html
new file mode 100644
index 000000000..7d3255301
--- /dev/null
+++ b/httemplate/misc/rate_edit_excel.html
@@ -0,0 +1,51 @@
+<% include('/elements/header.html', 'Edit rates with Excel' ) %>
+
+<% include( '/elements/form-file_upload.html',
+              'name'      => 'RateImportForm',
+              'action'    => 'process/rate_edit_excel.html',
+              'num_files' => 1,
+              'fields'    => [ 'format' ], #?
+              'message'   => 'Rate edit successful',
+              'url'       => $p."browse/rate_region.html",
+          )
+%>
+
+<% &ntable("#cccccc", 2) %>
+
+  <TR>
+    <TH ALIGN="left">1. Download current rates:</TH>
+    <TD>
+      <A HREF="<%$p%>/browse/rate_region.html?show_rates=1;_type=regions.xls">Download rate spreadsheet</A>
+    </TD>
+  </TR>
+
+  <TR>
+    <TH ALIGN="left" COLSPAN=2>2. Edit rates with Excel (or other .XLS-compatible application)</TH>
+  </TR>
+
+  <% include( '/elements/file-upload.html',
+                'field' => 'file',
+                'label' => '3. Upload edited rate file: '. ( '&nbsp'x4 ), #yuck
+            )
+  %>
+
+  <TR>
+    <TD COLSPAN=2 ALIGN="center" STYLE="padding-top:6px">
+      <INPUT TYPE    = "submit"
+             ID      = "submit"
+             VALUE   = "Upload"
+             onClick = "document.RateImportForm.submit.disabled=true;"
+      >
+    </TD>
+  </TR>
+
+
+</TABLE>
+
+<% include('/elements/footer.html') %>
+<%init>
+
+die "access denied"
+  unless $FS::CurrentUser::CurrentUser->access_right('Configuration');
+
+</%init>
-- 
cgit v1.2.1


From 791b34f7cb476e7c645d8eb7019dde9fdf5cf663 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Tue, 5 May 2009 10:40:15 +0000
Subject: finish the import portion of excel rate edit, RT#5108

---
 httemplate/misc/rate_edit_excel.html | 14 ++++++++++++--
 1 file changed, 12 insertions(+), 2 deletions(-)

(limited to 'httemplate/misc/rate_edit_excel.html')

diff --git a/httemplate/misc/rate_edit_excel.html b/httemplate/misc/rate_edit_excel.html
index 7d3255301..e73133c05 100644
--- a/httemplate/misc/rate_edit_excel.html
+++ b/httemplate/misc/rate_edit_excel.html
@@ -4,7 +4,7 @@
               'name'      => 'RateImportForm',
               'action'    => 'process/rate_edit_excel.html',
               'num_files' => 1,
-              'fields'    => [ 'format' ], #?
+              'fields'    => [ 'format' ],
               'message'   => 'Rate edit successful',
               'url'       => $p."browse/rate_region.html",
           )
@@ -23,12 +23,22 @@
     <TH ALIGN="left" COLSPAN=2>2. Edit rates with Excel (or other .XLS-compatible application)</TH>
   </TR>
 
+  <TR>
+    <TD ALIGN="left" COLSPAN=2>
+      &nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;To add rates, add four columns like an existing rate, with headers starting with "NEW: Rate Name" or "Rate Name".<BR>
+     &nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;<FONT SIZE="-2"><I>For rate addition, protection can be turned off in Excel via the Tools-&gt;Protection-&gt;Unprotect Sheet menu command.  Note that only new rates can be added; modified grayed out cells will not be imported.</I></FONT>
+    </TD>
+  </TR>
+
   <% include( '/elements/file-upload.html',
                 'field' => 'file',
-                'label' => '3. Upload edited rate file: '. ( '&nbsp'x4 ), #yuck
+                'label' => '3. Upload edited rate file: ',
+                'label_align' => 'left',
             )
   %>
 
+  <INPUT TYPE="hidden" NAME="format" VALUE="default">
+
   <TR>
     <TD COLSPAN=2 ALIGN="center" STYLE="padding-top:6px">
       <INPUT TYPE    = "submit"
-- 
cgit v1.2.1