summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--FS/FS/access_user.pm6
1 files changed, 5 insertions, 1 deletions
diff --git a/FS/FS/access_user.pm b/FS/FS/access_user.pm
index 830d7f8..874da66 100644
--- a/FS/FS/access_user.pm
+++ b/FS/FS/access_user.pm
@@ -297,8 +297,12 @@ Returns an sql fragement to select only agentnums this user can view.
sub agentnums_sql {
my $self = shift;
+
+ my @agentnums = $self->agentnums;
+ return ' 1 = 0 ' unless scalar(@agentnums);
+
'( '.
- join( ' OR ', map "agentnum = $_", $self->agentnums ).
+ join( ' OR ', map "agentnum = $_", @agentnums ).
' )';
}