projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
optimize customer list, RT#20173
[freeside.git]
/
FS
/
FS
/
prospect_main.pm
diff --git
a/FS/FS/prospect_main.pm
b/FS/FS/prospect_main.pm
index
79efa86
..
f600b23
100644
(file)
--- a/
FS/FS/prospect_main.pm
+++ b/
FS/FS/prospect_main.pm
@@
-288,8
+288,13
@@
Returns the locations (see L<FS::cust_location>) associated with this prospect.
sub cust_location {
my $self = shift;
sub cust_location {
my $self = shift;
- qsearch( 'cust_location', { 'prospectnum' => $self->prospectnum,
- 'custnum' => '' } );
+ qsearch({
+ 'table' => 'cust_location',
+ 'hashref' => { 'prospectnum' => $self->prospectnum,
+ 'custnum' => '',
+ },
+ 'order_by' => 'ORDER BY country, LOWER(state), LOWER(city), LOWER(county), LOWER(address1), LOWER(address2)',
+ });
}
=item qual
}
=item qual