summaryrefslogtreecommitdiff
path: root/httemplate/misc/rate_edit_excel.html
diff options
context:
space:
mode:
authorivan <ivan>2010-03-21 23:13:24 +0000
committerivan <ivan>2010-03-21 23:13:24 +0000
commitbf4223e554e0eb72f45f82392442780e8af4e0f9 (patch)
tree5896ceb5a364afe44441a18b786387d9683a907c /httemplate/misc/rate_edit_excel.html
parent366d237dfb842d9bcbdf43477cb5eabef8fe6686 (diff)
connection fee for initial N seconds support, RT#7018
Diffstat (limited to 'httemplate/misc/rate_edit_excel.html')
-rw-r--r--httemplate/misc/rate_edit_excel.html9
1 files changed, 9 insertions, 0 deletions
diff --git a/httemplate/misc/rate_edit_excel.html b/httemplate/misc/rate_edit_excel.html
index e73133c05..442d83aca 100644
--- a/httemplate/misc/rate_edit_excel.html
+++ b/httemplate/misc/rate_edit_excel.html
@@ -1,5 +1,9 @@
<% include('/elements/header.html', 'Edit rates with Excel' ) %>
+% if ( $have_conn ) {
+ <FONT COLOR="#FF0000">WARNING: This functionality does not yet preserve connection charges.</FONT><BR><BR>
+% }
+
<% include( '/elements/form-file_upload.html',
'name' => 'RateImportForm',
'action' => 'process/rate_edit_excel.html',
@@ -58,4 +62,9 @@
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>