Gecko [ paroquia-rio-de-mouro.pt ]

Name	Size	Permission	Date
Activity	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
App	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
AppFramework	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Archive	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Authentication	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
BackgroundJob	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Cache	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Command	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Comments	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Console	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
DB	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Diagnostics	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Encryption	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Files	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Group	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Hooks	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Http	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Image	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
IntegrityCheck	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
L10N	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Lock	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Log	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Mail	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Memcache	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Migration	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Notification	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
OCS	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Preview	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Repair	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Route	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Search	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Security	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Session	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Settings	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Setup	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Share	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Share20	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
SystemTag	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Tagging	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Template	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Theme	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Updater	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
User	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
legacy	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
AllConfig.php	13.67 KB	-rw-r--r--	2018-04-19 18:15
AppConfig.php	8.29 KB	-rw-r--r--	2018-04-19 18:15
AppHelper.php	1.41 KB	-rw-r--r--	2018-04-19 18:15
Avatar.php	4.73 KB	-rw-r--r--	2018-04-19 18:15
AvatarManager.php	3.24 KB	-rw-r--r--	2018-04-19 18:15
CapabilitiesManager.php	1.85 KB	-rw-r--r--	2018-04-19 18:15
Config.php	9.76 KB	-rw-r--r--	2018-04-19 18:15
ContactsManager.php	5.5 KB	-rw-r--r--	2018-04-19 18:15
DatabaseException.php	1.13 KB	-rw-r--r--	2018-04-19 18:15
DatabaseSetupException.php	867 B	-rw-r--r--	2018-04-19 18:15
DateTimeFormatter.php	10.2 KB	-rw-r--r--	2018-04-19 18:15
DateTimeZone.php	3.52 KB	-rw-r--r--	2018-04-19 18:15
ForbiddenException.php	981 B	-rw-r--r--	2018-04-19 18:15
HTTPHelper.php	3.11 KB	-rw-r--r--	2018-04-19 18:15
HintException.php	1.38 KB	-rw-r--r--	2018-04-19 18:15
Installer.php	19.03 KB	-rw-r--r--	2018-04-19 18:15
LargeFileHelper.php	5.48 KB	-rw-r--r--	2018-04-19 18:15
Log.php	11.18 KB	-rw-r--r--	2018-04-19 18:15
NaturalSort.php	3.98 KB	-rw-r--r--	2018-04-19 18:15
NaturalSort_DefaultCollator.php	1.06 KB	-rw-r--r--	2018-04-19 18:15
NavigationManager.php	5.04 KB	-rw-r--r--	2018-04-19 18:15
NeedsUpdateException.php	880 B	-rw-r--r--	2018-04-19 18:15
NotSquareException.php	865 B	-rw-r--r--	2018-04-19 18:15
Preview.php	35.2 KB	-rw-r--r--	2018-04-19 18:15
PreviewManager.php	11.99 KB	-rw-r--r--	2018-04-19 18:15
RedisFactory.php	2.89 KB	-rw-r--r--	2018-04-19 18:15
Repair.php	7.62 KB	-rw-r--r--	2018-04-19 18:15
RepairException.php	945 B	-rw-r--r--	2018-04-19 18:15
Search.php	3.85 KB	-rw-r--r--	2018-04-19 18:15
Server.php	45.65 KB	-rw-r--r--	2018-04-19 18:15
ServerContainer.php	2.38 KB	-rw-r--r--	2018-04-19 18:15
ServerNotAvailableException.php	823 B	-rw-r--r--	2018-04-19 18:15
ServiceUnavailableException.php	870 B	-rw-r--r--	2018-04-19 18:15
Setup.php	14.89 KB	-rw-r--r--	2018-04-19 18:15
Streamer.php	3.64 KB	-rw-r--r--	2018-04-19 18:15
SubAdmin.php	7.71 KB	-rw-r--r--	2018-04-19 18:15
SystemConfig.php	4.28 KB	-rw-r--r--	2018-04-19 18:15
TagManager.php	2.72 KB	-rw-r--r--	2018-04-19 18:15
Tags.php	21.39 KB	-rw-r--r--	2018-04-19 18:15
TempManager.php	7.31 KB	-rw-r--r--	2018-04-19 18:15
TemplateLayout.php	6.48 KB	-rw-r--r--	2018-04-19 18:15
URLGenerator.php	6.8 KB	-rw-r--r--	2018-04-19 18:15
Updater.php	10.74 KB	-rw-r--r--	2018-04-19 18:15

Rename

<?php
/**
 * @author Arthur Schiwon <blizzz@arthur-schiwon.de>
 * @author Bart Visscher <bartv@thisnet.nl>
 * @author Georg Ehrke <georg@owncloud.com>
 * @author Lukas Reschke <lukas@statuscode.ch>
 * @author Morris Jobke <hey@morrisjobke.de>
 * @author Roeland Jago Douma <rullzer@owncloud.com>
 *
 * @copyright Copyright (c) 2018, ownCloud GmbH
 * @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\Events\EventEmitterTrait;
use OCP\IUser;
use OCP\IUserManager;
use OCP\IGroup;
use OCP\IGroupManager;
use OCP\IDBConnection;

class SubAdmin extends PublicEmitter {

use EventEmitterTrait;
	/** @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) {
		return $this->emittingCall(function () use (&$user, &$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;
		}, [
			'before' => ['user' => $user, 'feature' => 'groupAdmin', 'value' => 'create', 'group' => $group],
			'after' => ['user' => $user, 'feature' => 'groupAdmin', 'value' => 'create', 'group' => $group]
		], 'user', 'featurechange');
	}

/**
	 * 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) {
		return $this->emittingCall(function () use (&$user, &$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;
		}, [
			'before' => ['user' => $user, 'feature' => 'groupAdmin', 'value' => 'remove', 'group' => $group],
			'after' => ['user' => $user, 'feature' => 'groupAdmin', 'value' => 'remove', 'group' => $group]
		], 'user', 'featurechange');
	}

/**
	 * 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;
			}
		}
		$result->closeCursor();

return $groups;
	}

/**
	 * 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();

$result = $isSubAdmin === false ? false : true;

return $result;
	}

/**
	 * 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;
	}
}