projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
import to notes
[freeside.git]
/
httemplate
/
misc
/
rate_edit_excel.html
diff --git
a/httemplate/misc/rate_edit_excel.html
b/httemplate/misc/rate_edit_excel.html
index
e73133c
..
442d83a
100644
(file)
--- 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' ) %>
<% 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',
<% 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');
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>
</%init>