From 639c645c0f00c082a735b40f97a4f830c5e84949 Mon Sep 17 00:00:00 2001 From: Christopher Burger Date: Tue, 11 Dec 2018 18:08:18 -0500 Subject: Revert "RT# 74693 - Added ability to bulk edit rates with excel" This reverts commit 1d9fd3b93be720823656cd23db79ff74e2e7a829. --- httemplate/misc/process/tax_edit_excel.html | 9 ---- httemplate/misc/tax_edit_excel.html | 70 ----------------------------- 2 files changed, 79 deletions(-) delete mode 100644 httemplate/misc/process/tax_edit_excel.html delete 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 deleted file mode 100644 index a9928f902..000000000 --- a/httemplate/misc/process/tax_edit_excel.html +++ /dev/null @@ -1,9 +0,0 @@ -<% $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; - - \ No newline at end of file diff --git a/httemplate/misc/tax_edit_excel.html b/httemplate/misc/tax_edit_excel.html deleted file mode 100644 index 1546393d9..000000000 --- a/httemplate/misc/tax_edit_excel.html +++ /dev/null @@ -1,70 +0,0 @@ -<% 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) %> - - - File format should be as follows:
- - - - - - - -
Country as standard two letter code
State as standard two letter code
County name
City name
Tax name
Tax rate

- * first row should be blank or contain headers
- * Tax rate should be formated as a number not percentage. -

- - - - Upload tax rates with Excel (or other .XLS-compatible application) - - - - <% include( '/elements/file-upload.html', - 'field' => 'file', - 'label' => '', - 'label_align' => 'left', - ) - %> - - - - - - - - - - - - -<% 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]; - - \ No newline at end of file -- cgit v1.2.1