RT# 74693 - Added ability to bulk edit rates with excel

3 files changed, 81 insertions, 1 deletions

diff --git a/httemplate/browse/cust_main_county.cgi b/httemplate/browse/cust_main_county.cgi
index 26a3e21b9..552327836 100755
--- a/httemplate/browse/cust_main_county.cgi
+++ b/httemplate/browse/cust_main_county.cgi
@@ -411,7 +411,8 @@ my $html_foot = <<END;
 <A HREF="javascript:void(0);" onClick="bulkPopup('add');">Add new tax to selected</A>
 |
 <A HREF="javascript:void(0);" onClick="bulkPopup('edit');">Bulk edit selected</A>
-
+|
+<A HREF="${p}misc/tax_edit_excel.html",">bulk edit with excel file</A>
 END
 
 my $hashref = {};
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