SubAdmin::getGroupsSubAdmins() - Code Metrics - Inspection of "Merge pull request #8255 from nextcloud/bugfix/noi..." - nextcloud/server - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( fde08a...208e38 )

by Blizzz

created 2018-03-15 11:07 UTC

SubAdmin::getGroupsSubAdmins() A

↳ Parent: SubAdmin

Complexity

Conditions	3
Paths	3

Size

Total Lines	19
Code Lines	13

Duplication

Lines	19
Ratio	100 %

Importance

Changes

Metric	Value
cc	3
eloc	13
nc	3
nop	1
dl	19
loc	19
rs	9.4285
c	0
b	0
f	0

<?php
/**
 * @copyright Copyright (c) 2016, ownCloud, Inc.
 *
 * @author Arthur Schiwon <[email protected]>
 * @author Bart Visscher <[email protected]>
 * @author Georg Ehrke <[email protected]>
 * @author Joas Schilling <[email protected]>
 * @author Lukas Reschke <[email protected]>
 * @author Morris Jobke <[email protected]>
 * @author Roeland Jago Douma <[email protected]>
 *
 * @license AGPL-3.0
 *
 * This code is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License, version 3,
 * as published by the Free Software Foundation.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License, version 3,
 * along with this program.  If not, see <http://www.gnu.org/licenses/>
 *
 */

namespace OC;

use OC\Hooks\PublicEmitter;
use OCP\IUser;
use OCP\IUserManager;
use OCP\IGroup;
use OCP\IGroupManager;
use OCP\IDBConnection;

class SubAdmin extends PublicEmitter {

	/** @var IUserManager */
	private $userManager;

	/** @var IGroupManager */
	private $groupManager;

	/** @var IDBConnection */
	private $dbConn;

	/**
	 * @param IUserManager $userManager
	 * @param IGroupManager $groupManager
	 * @param IDBConnection $dbConn
	 */
	public function __construct(IUserManager $userManager,
	                            IGroupManager $groupManager,
								IDBConnection $dbConn) {
		$this->userManager = $userManager;
		$this->groupManager = $groupManager;
		$this->dbConn = $dbConn;

		$this->userManager->listen('\OC\User', 'postDelete', function($user) {
			$this->post_deleteUser($user);
		});
		$this->groupManager->listen('\OC\Group', 'postDelete', function($group) {
			$this->post_deleteGroup($group);
		});
	}

	/**
	 * add a SubAdmin
	 * @param IUser $user user to be SubAdmin
	 * @param IGroup $group group $user becomes subadmin of
	 * @return bool
	 */
	public function createSubAdmin(IUser $user, IGroup $group) {
		$qb = $this->dbConn->getQueryBuilder();

		$qb->insert('group_admin')
			->values([
				'gid' => $qb->createNamedParameter($group->getGID()),
				'uid' => $qb->createNamedParameter($user->getUID())
			])
			->execute();

		$this->emit('\OC\SubAdmin', 'postCreateSubAdmin', [$user, $group]);
		\OC_Hook::emit("OC_SubAdmin", "post_createSubAdmin", ["gid" => $group->getGID()]);
		return true;
	}

	/**
	 * delete a SubAdmin
	 * @param IUser $user the user that is the SubAdmin
	 * @param IGroup $group the group
	 * @return bool
	 */
	public function deleteSubAdmin(IUser $user, IGroup $group) {
		$qb = $this->dbConn->getQueryBuilder();

		$qb->delete('group_admin')
			->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID())))
			->andWhere($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
			->execute();

		$this->emit('\OC\SubAdmin', 'postDeleteSubAdmin', [$user, $group]);
		\OC_Hook::emit("OC_SubAdmin", "post_deleteSubAdmin", ["gid" => $group->getGID()]);
		return true;
	}

	/**
	 * get groups of a SubAdmin
	 * @param IUser $user the SubAdmin
	 * @return IGroup[]
	 */
	public function getSubAdminsGroups(IUser $user) {
		$qb = $this->dbConn->getQueryBuilder();

		$result = $qb->select('gid')
			->from('group_admin')
			->where($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
			->execute();

		$groups = [];
		while($row = $result->fetch()) {
			$group = $this->groupManager->get($row['gid']);
			if(!is_null($group)) {
				$groups[$group->getGID()] = $group;
			}
		}
		$result->closeCursor();

		return $groups;
	}

	/**
	 * get an array of groupid and displayName for a user
	 * @param IUser $user
	 * @return array ['displayName' => displayname]
	 */
	public function getSubAdminsGroupsName(IUser $user) {
		return array_map(function($group) {
			return array('displayName' => $group->getDisplayName());
		}, $this->getSubAdminsGroups($user));
	}

	/**
	 * get SubAdmins of a group
	 * @param IGroup $group the group
	 * @return IUser[]
	 */
	public function getGroupsSubAdmins(IGroup $group) {
		$qb = $this->dbConn->getQueryBuilder();

		$result = $qb->select('uid')
			->from('group_admin')
			->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID())))
			->execute();

		$users = [];
		while($row = $result->fetch()) {
			$user = $this->userManager->get($row['uid']);
			if(!is_null($user)) {
				$users[] = $user;
			}
		}
		$result->closeCursor();

		return $users;
	}

	/**
	 * get all SubAdmins
	 * @return array
	 */
	public function getAllSubAdmins() {
		$qb = $this->dbConn->getQueryBuilder();

		$result = $qb->select('*')
			->from('group_admin')
			->execute();

		$subadmins = [];
		while($row = $result->fetch()) {
			$user = $this->userManager->get($row['uid']);
			$group = $this->groupManager->get($row['gid']);
			if(!is_null($user) && !is_null($group)) {
				$subadmins[] = [
					'user'  => $user,
					'group' => $group
				];
			}
		}
		$result->closeCursor();

		return $subadmins;
	}

	/**
	 * checks if a user is a SubAdmin of a group
	 * @param IUser $user
	 * @param IGroup $group
	 * @return bool
	 */
	public function isSubAdminOfGroup(IUser $user, IGroup $group) {
		$qb = $this->dbConn->getQueryBuilder();

		/*
		 * Primary key is ('gid', 'uid') so max 1 result possible here
		 */
		$result = $qb->select('*')
			->from('group_admin')
			->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID())))
			->andWhere($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
			->execute();

		$fetch =  $result->fetch();
		$result->closeCursor();
		$result = !empty($fetch) ? true : false;

		return $result;
	}

	/**
	 * checks if a user is a SubAdmin
	 * @param IUser $user
	 * @return bool
	 */
	public function isSubAdmin(IUser $user) {
		// Check if the user is already an admin
		if ($this->groupManager->isAdmin($user->getUID())) {
			return true;
		}

		$qb = $this->dbConn->getQueryBuilder();

		$result = $qb->select('gid')
			->from('group_admin')
			->andWhere($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
			->setMaxResults(1)
			->execute();

		$isSubAdmin = $result->fetch();
		$result->closeCursor();

		return $isSubAdmin !== false;
	}

	/**
	 * checks if a user is a accessible by a subadmin
	 * @param IUser $subadmin
	 * @param IUser $user
	 * @return bool
	 */
	public function isUserAccessible($subadmin, $user) {
		if(!$this->isSubAdmin($subadmin)) {
			return false;
		}
		if($this->groupManager->isAdmin($user->getUID())) {
			return false;
		}
		$accessibleGroups = $this->getSubAdminsGroups($subadmin);
		foreach($accessibleGroups as $accessibleGroup) {
			if($accessibleGroup->inGroup($user)) {
				return true;
			}
		}
		return false;
	}

	/**
	 * delete all SubAdmins by $user
	 * @param IUser $user
	 * @return boolean
	 */
	private function post_deleteUser($user) {
		$qb = $this->dbConn->getQueryBuilder();

		$qb->delete('group_admin')
			->where($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
			->execute();

		return true;
	}

	/**
	 * delete all SubAdmins by $group
	 * @param IGroup $group
	 * @return boolean
	 */
	private function post_deleteGroup($group) {
		$qb = $this->dbConn->getQueryBuilder();

		$qb->delete('group_admin')
			->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID())))
			->execute();

		return true;
	}
}


1		<?php
2		/**
3		* @copyright Copyright (c) 2016, ownCloud, Inc.
4		*
5		* @author Arthur Schiwon <[email protected]>
6		* @author Bart Visscher <[email protected]>
7		* @author Georg Ehrke <[email protected]>
8		* @author Joas Schilling <[email protected]>
9		* @author Lukas Reschke <[email protected]>
10		* @author Morris Jobke <[email protected]>
11		* @author Roeland Jago Douma <[email protected]>
12		*
13		* @license AGPL-3.0
14		*
15		* This code is free software: you can redistribute it and/or modify
16		* it under the terms of the GNU Affero General Public License, version 3,
17		* as published by the Free Software Foundation.
18		*
19		* This program is distributed in the hope that it will be useful,
20		* but WITHOUT ANY WARRANTY; without even the implied warranty of
21		* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
22		* GNU Affero General Public License for more details.
23		*
24		* You should have received a copy of the GNU Affero General Public License, version 3,
25		* along with this program. If not, see <http://www.gnu.org/licenses/>
26		*
27		*/
28
29		namespace OC;
30
31		use OC\Hooks\PublicEmitter;
32		use OCP\IUser;
33		use OCP\IUserManager;
34		use OCP\IGroup;
35		use OCP\IGroupManager;
36		use OCP\IDBConnection;
37
38		class SubAdmin extends PublicEmitter {
39
40		/** @var IUserManager */
41		private $userManager;
42
43		/** @var IGroupManager */
44		private $groupManager;
45
46		/** @var IDBConnection */
47		private $dbConn;
48
49		/**
50		* @param IUserManager $userManager
51		* @param IGroupManager $groupManager
52		* @param IDBConnection $dbConn
53		*/
54		public function __construct(IUserManager $userManager,
55		IGroupManager $groupManager,
56		IDBConnection $dbConn) {
57		$this->userManager = $userManager;
58		$this->groupManager = $groupManager;
59		$this->dbConn = $dbConn;
60
61		$this->userManager->listen('\OC\User', 'postDelete', function($user) {
62		$this->post_deleteUser($user);
63		});
64		$this->groupManager->listen('\OC\Group', 'postDelete', function($group) {
65		$this->post_deleteGroup($group);
66		});
67		}
68
69		/**
70		* add a SubAdmin
71		* @param IUser $user user to be SubAdmin
72		* @param IGroup $group group $user becomes subadmin of
73		* @return bool
74		*/
75		public function createSubAdmin(IUser $user, IGroup $group) {
76		$qb = $this->dbConn->getQueryBuilder();
77
78		$qb->insert('group_admin')
79		->values([
80		'gid' => $qb->createNamedParameter($group->getGID()),
81		'uid' => $qb->createNamedParameter($user->getUID())
82		])
83		->execute();
84
85		$this->emit('\OC\SubAdmin', 'postCreateSubAdmin', [$user, $group]);
86		\OC_Hook::emit("OC_SubAdmin", "post_createSubAdmin", ["gid" => $group->getGID()]);
87		return true;
88		}
89
90		/**
91		* delete a SubAdmin
92		* @param IUser $user the user that is the SubAdmin
93		* @param IGroup $group the group
94		* @return bool
95		*/
96		public function deleteSubAdmin(IUser $user, IGroup $group) {
97		$qb = $this->dbConn->getQueryBuilder();
98
99		$qb->delete('group_admin')
100		->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID())))
101		->andWhere($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
102		->execute();
103
104		$this->emit('\OC\SubAdmin', 'postDeleteSubAdmin', [$user, $group]);
105		\OC_Hook::emit("OC_SubAdmin", "post_deleteSubAdmin", ["gid" => $group->getGID()]);
106		return true;
107		}
108
109		/**
110		* get groups of a SubAdmin
111		* @param IUser $user the SubAdmin
112		* @return IGroup[]
113		*/
114	View Code Duplication	public function getSubAdminsGroups(IUser $user) {
115		$qb = $this->dbConn->getQueryBuilder();
116
117		$result = $qb->select('gid')
118		->from('group_admin')
119		->where($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
120		->execute();
121
122		$groups = [];
123		while($row = $result->fetch()) {
124		$group = $this->groupManager->get($row['gid']);
125		if(!is_null($group)) {
126		$groups[$group->getGID()] = $group;
127		}
128		}
129		$result->closeCursor();
130
131		return $groups;
132		}
133
134		/**
135		* get an array of groupid and displayName for a user
136		* @param IUser $user
137		* @return array ['displayName' => displayname]
138		*/
139		public function getSubAdminsGroupsName(IUser $user) {
140		return array_map(function($group) {
141		return array('displayName' => $group->getDisplayName());
142		}, $this->getSubAdminsGroups($user));
143		}
144
145		/**
146		* get SubAdmins of a group
147		* @param IGroup $group the group
148		* @return IUser[]
149		*/
150	View Code Duplication	public function getGroupsSubAdmins(IGroup $group) {
151		$qb = $this->dbConn->getQueryBuilder();
152
153		$result = $qb->select('uid')
154		->from('group_admin')
155		->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID())))
156		->execute();
157
158		$users = [];
159		while($row = $result->fetch()) {
160		$user = $this->userManager->get($row['uid']);
161		if(!is_null($user)) {
162		$users[] = $user;
163		}
164		}
165		$result->closeCursor();
166
167		return $users;
168		}
169
170		/**
171		* get all SubAdmins
172		* @return array
173		*/
174		public function getAllSubAdmins() {
175		$qb = $this->dbConn->getQueryBuilder();
176
177		$result = $qb->select('*')
178		->from('group_admin')
179		->execute();
180
181		$subadmins = [];
182		while($row = $result->fetch()) {
183		$user = $this->userManager->get($row['uid']);
184		$group = $this->groupManager->get($row['gid']);
185		if(!is_null($user) && !is_null($group)) {
186		$subadmins[] = [
187		'user' => $user,
188		'group' => $group
189		];
190		}
191		}
192		$result->closeCursor();
193
194		return $subadmins;
195		}
196
197		/**
198		* checks if a user is a SubAdmin of a group
199		* @param IUser $user
200		* @param IGroup $group
201		* @return bool
202		*/
203		public function isSubAdminOfGroup(IUser $user, IGroup $group) {
204		$qb = $this->dbConn->getQueryBuilder();
205
206		/*
207		* Primary key is ('gid', 'uid') so max 1 result possible here
208		*/
209		$result = $qb->select('*')
210		->from('group_admin')
211		->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID())))
212		->andWhere($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
213		->execute();
214
215		$fetch = $result->fetch();
216		$result->closeCursor();
217		$result = !empty($fetch) ? true : false;
218
219		return $result;
220		}
221
222		/**
223		* checks if a user is a SubAdmin
224		* @param IUser $user
225		* @return bool
226		*/
227		public function isSubAdmin(IUser $user) {
228		// Check if the user is already an admin
229		if ($this->groupManager->isAdmin($user->getUID())) {
230		return true;
231		}
232
233		$qb = $this->dbConn->getQueryBuilder();
234
235		$result = $qb->select('gid')
236		->from('group_admin')
237		->andWhere($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
238		->setMaxResults(1)
239		->execute();
240
241		$isSubAdmin = $result->fetch();
242		$result->closeCursor();
243
244		return $isSubAdmin !== false;
245		}
246
247		/**
248		* checks if a user is a accessible by a subadmin
249		* @param IUser $subadmin
250		* @param IUser $user
251		* @return bool
252		*/
253		public function isUserAccessible($subadmin, $user) {
254		if(!$this->isSubAdmin($subadmin)) {
255		return false;
256		}
257		if($this->groupManager->isAdmin($user->getUID())) {
258		return false;
259		}
260		$accessibleGroups = $this->getSubAdminsGroups($subadmin);
261		foreach($accessibleGroups as $accessibleGroup) {
262		if($accessibleGroup->inGroup($user)) {
263		return true;
264		}
265		}
266		return false;
267		}
268
269		/**
270		* delete all SubAdmins by $user
271		* @param IUser $user
272		* @return boolean
273		*/
274	View Code Duplication	private function post_deleteUser($user) {
275		$qb = $this->dbConn->getQueryBuilder();
276
277		$qb->delete('group_admin')
278		->where($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
279		->execute();
280
281		return true;
282		}
283
284		/**
285		* delete all SubAdmins by $group
286		* @param IGroup $group
287		* @return boolean
288		*/
289	View Code Duplication	private function post_deleteGroup($group) {
290		$qb = $this->dbConn->getQueryBuilder();
291
292		$qb->delete('group_admin')
293		->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID())))
294		->execute();
295
296		return true;
297		}
298		}
299

nextcloud / server

Push — master ( fde08a...208e38 )

SubAdmin::getGroupsSubAdmins() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like