X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Frate_prefix.pm;h=ce780fefe88afd6bf039a1efd22cf9bd5a37b719;hp=500462a15da5a5f9b242f70c356f3562632a3c8e;hb=ad7f49821d40ffd099a45acc32ba91e0e211aede;hpb=48ba2845d0119c56971d5b724661aa37e73b49dd

diff --git a/FS/FS/rate_prefix.pm b/FS/FS/rate_prefix.pm
index 500462a15..ce780fefe 100644
--- a/FS/FS/rate_prefix.pm
+++ b/FS/FS/rate_prefix.pm
@@ -2,7 +2,7 @@ package FS::rate_prefix;
 
 use strict;
 use vars qw( @ISA );
-use FS::Record qw( qsearch qsearchs );
+use FS::Record qw( qsearch qsearchs dbh );
 use FS::rate_region;
 
 @ISA = qw(FS::Record);
@@ -122,7 +122,28 @@ Returns the rate region (see L<FS::rate_region>) for this prefix.
 
 sub rate_region {
   my $self = shift;
-  qsearch('rate_region', { 'regionnum' => $self->regionnum } );
+  qsearchs('rate_region', { 'regionnum' => $self->regionnum } );
+}
+
+=back
+
+=head1 CLASS METHODS
+
+=over 4
+
+=item all_countrycodes
+
+Returns a list of all countrycodes listed in rate_prefix
+
+=cut
+
+sub all_countrycodes { 
+  #my $class = shift;
+  my $sql =
+    "SELECT DISTINCT(countrycode) FROM rate_prefix ORDER BY countrycode";
+  my $sth = dbh->prepare($sql) or die  dbh->errstr;
+  $sth->execute                or die $sth->errstr;
+  map $_->[0], @{ $sth->fetchall_arrayref };
 }
 
 =back