From 1d9fd3b93be720823656cd23db79ff74e2e7a829 Mon Sep 17 00:00:00 2001
From: Christopher Burger <burgerc@freeside.biz>
Date: Wed, 14 Nov 2018 12:55:13 -0500
Subject: RT# 74693 - Added ability to bulk edit rates with excel

---
 httemplate/misc/process/tax_edit_excel.html |  9 ++++
 httemplate/misc/tax_edit_excel.html         | 70 +++++++++++++++++++++++++++++
 2 files changed, 79 insertions(+)
 create mode 100644 httemplate/misc/process/tax_edit_excel.html
 create mode 100644 httemplate/misc/tax_edit_excel.html

(limited to 'httemplate/misc')

diff --git a/httemplate/misc/process/tax_edit_excel.html b/httemplate/misc/process/tax_edit_excel.html
new file mode 100644
index 000000000..a9928f902
--- /dev/null
+++ b/httemplate/misc/process/tax_edit_excel.html
@@ -0,0 +1,9 @@
+<% $server->process %>
+<%init>
+
+die "access denied"
+  unless $FS::CurrentUser::CurrentUser->access_right('Configuration');
+
+my $server = new FS::UI::Web::JSRPC 'FS::cust_main_county::process_edit_import', $cgi;
+
+</%init>
\ No newline at end of file
diff --git a/httemplate/misc/tax_edit_excel.html b/httemplate/misc/tax_edit_excel.html
new file mode 100644
index 000000000..1546393d9
--- /dev/null
+++ b/httemplate/misc/tax_edit_excel.html
@@ -0,0 +1,70 @@
+<% include('/elements/header.html', 'Edit  tax rates with Excel' ) %>
+
+% # 'name' => 'RateImportForm',
+
+<& /elements/form-file_upload.html,
+     'name'      => 'TaxEditForm',
+     'action'    => 'process/tax_edit_excel.html',
+     'num_files' => 1,
+     'fields'    => [ 'format' ],
+     'message'   => 'Tax Rate edit successful',
+     'url'       => $p."browse/cust_main_county.cgi",
+     'onsubmit'  => "document.TaxEditForm.submitButton.disabled=true;"
+&>
+
+<% &ntable("#cccccc", 2) %>
+
+  <TR>
+    <TD ALIGN="left" COLSPAN=2>File format should be as follows:<BR>
+      <TABLE>
+        <TR><TD><B>Country</B> as standard two letter code</TD></TR>
+        <TR><TD><B>State</B> as standard two letter code</TD></TR>
+        <TR><TD><B>County name</B></TD></TR>
+        <TR><TD><B>City name</B></TD></TR>
+        <TR><TD><B>Tax name</B></TD></TR>
+        <TR><TD><B>Tax rate</B></TD></TR>
+      </TABLE><BR>
+      * first row should be blank or contain headers<BR>
+      * Tax rate should be formated as a number not percentage.
+      <P>
+    </TD>
+  </TR>
+  <TR>
+    <TH ALIGN="left" COLSPAN=2>Upload tax rates with Excel (or other .XLS-compatible application)</TH>
+  </TR>
+
+
+  <% include( '/elements/file-upload.html',
+                'field' => 'file',
+                'label' => '',
+                'label_align' => 'left',
+            )
+  %>
+
+  <INPUT TYPE="hidden" NAME="format" VALUE="default">
+
+  <TR>
+    <TD COLSPAN=2 ALIGN="center" STYLE="padding-top:6px">
+      <INPUT TYPE    = "submit"
+             ID      = "submitButton"
+             NAME    = "submitButton"
+             VALUE   = "Upload"
+      >
+    </TD>
+  </TR>
+
+
+</TABLE>
+
+<% include('/elements/footer.html') %>
+<%init>
+
+die "access denied"
+  unless $FS::CurrentUser::CurrentUser->access_right('Configuration');
+
+my $sth = dbh->prepare('SELECT COUNT(*) FROM rate_detail WHERE conn_charge > 0 OR conn_sec > 0 LIMIT 1')
+  or die dbh->errstr;
+$sth->execute or die $sth->errstr;
+my $have_conn = $sth->fetchrow_arrayref->[0];
+
+</%init>
\ No newline at end of file
-- 
cgit v1.2.1