From: ivan <ivan>
Date: Thu, 23 Dec 2004 07:28:53 +0000 (+0000)
Subject: hide US regions for now, we don't currently need them for rating just invoice/session... 
X-Git-Tag: BEFORE_FINAL_MASONIZE~767
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=584caeef2ac90ab10fc028a7928b9ebc53e8b33a

hide US regions for now, we don't currently need them for rating just invoice/session display and the web pages are so giant they're timing out
---

diff --git a/httemplate/edit/rate.cgi b/httemplate/edit/rate.cgi
index 83a89c475..4fdc837bb 100644
--- a/httemplate/edit/rate.cgi
+++ b/httemplate/edit/rate.cgi
@@ -22,6 +22,13 @@ my %granularity = (
   '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(
@@ -52,7 +59,11 @@ Rate plan
 </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 =