X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Faccess_user.pm;h=63ae30d36f76f6505f2f2443e5a941b97ab452e3;hb=e4c7cd8602ebb3e70895aee1d7d8a49371ccb70c;hp=21ed2b726b14c9a456c0d5949eba070ae2781c07;hpb=1804c24af6b02e25415dbf27fc75b3399ba79fde;p=freeside.git diff --git a/FS/FS/access_user.pm b/FS/FS/access_user.pm index 21ed2b726..63ae30d36 100644 --- a/FS/FS/access_user.pm +++ b/FS/FS/access_user.pm @@ -7,6 +7,7 @@ use FS::Conf; use FS::Record qw( qsearch qsearchs dbh ); use FS::m2m_Common; use FS::option_Common; +use FS::access_user_pref; use FS::access_usergroup; use FS::agent; @@ -353,7 +354,9 @@ sub agentnums_sql { my $agentnum = $opt{'table'} ? $opt{'table'}.'.agentnum' : 'agentnum'; - my @agentnums = map { "$agentnum = $_" } $self->agentnums; +# my @agentnums = map { "$agentnum = $_" } $self->agentnums; + my @agentnums = (); + push @agentnums, "$agentnum IN (". join(',', $self->agentnums). ')'; push @agentnums, "$agentnum IS NULL" if $opt{'null'} @@ -361,6 +364,7 @@ sub agentnums_sql { return ' 1 = 0 ' unless scalar(@agentnums); '( '. join( ' OR ', @agentnums ). ' )'; + } =item agentnum @@ -396,26 +400,33 @@ sub agents { }); } -=item access_right +=item access_right RIGHTNAME | LISTREF -Given a right name, returns true if this user has this right (currently via -group membership, eventually also via user overrides). +Given a right name or a list reference of right names, returns true if this +user has this right, or, for a list, one of the rights (currently via group +membership, eventually also via user overrides). =cut sub access_right { my( $self, $rightname ) = @_; + $rightname = [ $rightname ] unless ref($rightname); + #some caching of ACL requests for low-hanging fruit perf improvement #since we get a new $CurrentUser object each page view there shouldn't be any #issues with stickiness if ( $self->{_ACLcache} ) { - return $self->{_ACLcache}{$rightname} - if exists($self->{_ACLcache}{$rightname}); + + return grep $self->{_ACLcache}{$_}, @$rightname + unless grep !exists($self->{_ACLcache}{$_}), @$rightname; + } else { $self->{_ACLcache} = {}; } + my $has_right = ' rightname IN ('. join(',', map '?', @$rightname ). ') '; + my $sth = dbh->prepare(" SELECT groupnum FROM access_usergroup LEFT JOIN access_group USING ( groupnum ) @@ -423,10 +434,10 @@ sub access_right { ON ( access_group.groupnum = access_right.rightobjnum ) WHERE usernum = ? AND righttype = 'FS::access_group' - AND rightname = ? + AND $has_right LIMIT 1 ") or die dbh->errstr; - $sth->execute($self->usernum, $rightname) or die $sth->errstr; + $sth->execute($self->usernum, @$rightname) or die $sth->errstr; my $row = $sth->fetchrow_arrayref; #$row ? $row->[0] : '';