projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
7447bd0
)
hide US regions for now, we don't currently need them for rating just invoice/session...
author
ivan
<ivan>
Thu, 23 Dec 2004 07:28:53 +0000
(07:28 +0000)
committer
ivan
<ivan>
Thu, 23 Dec 2004 07:28:53 +0000
(07:28 +0000)
httemplate/edit/rate.cgi
patch
|
blob
|
history
diff --git
a/httemplate/edit/rate.cgi
b/httemplate/edit/rate.cgi
index
83a89c4
..
4fdc837
100644
(file)
--- a/
httemplate/edit/rate.cgi
+++ b/
httemplate/edit/rate.cgi
@@
-22,6
+22,13
@@
my %granularity = (
'60' => 'minute',
);
'60' => 'minute',
);
+my $nous = <<END;
+ WHERE 0 < ( SELECT COUNT(*) FROM rate_prefix
+ WHERE rate_region.regionnum = rate_prefix.regionnum
+ AND countrycode != '1'
+ )
+END
+
%>
<%= header("$action Rate plan", menubar(
%>
<%= header("$action Rate plan", menubar(
@@
-52,7
+59,11
@@
Rate plan
</TR>
<% foreach my $rate_region (
</TR>
<% foreach my $rate_region (
- qsearch('rate_region', {}, '', 'ORDER BY regionname' )
+ qsearch( 'rate_region',
+ {},
+ '',
+ "$nous ORDER BY regionname",
+ )
) {
my $n = $rate_region->regionnum;
my $rate_detail =
) {
my $n = $rate_region->regionnum;
my $rate_detail =