123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111 |
- <?php
- namespace OC\Settings;
- use OCP\AppFramework\Db\Entity;
- use OCP\AppFramework\Db\QBMapper;
- use OCP\DB\Exception;
- use OCP\DB\QueryBuilder\IQueryBuilder;
- use OCP\IDBConnection;
- use OCP\IGroup;
- use OCP\IGroupManager;
- use OCP\IUser;
- class AuthorizedGroupMapper extends QBMapper {
- public function __construct(IDBConnection $db) {
- parent::__construct($db, 'authorized_groups', AuthorizedGroup::class);
- }
-
- public function findAllClassesForUser(IUser $user): array {
- $qb = $this->db->getQueryBuilder();
-
- $groupManager = \OC::$server->get(IGroupManager::class);
- $groups = $groupManager->getUserGroups($user);
- if (count($groups) === 0) {
- return [];
- }
- $result = $qb->select('class')
- ->from($this->getTableName(), 'auth')
- ->where($qb->expr()->in('group_id', array_map(function (IGroup $group) use ($qb) {
- return $qb->createNamedParameter($group->getGID());
- }, $groups), IQueryBuilder::PARAM_STR))
- ->executeQuery();
- $classes = [];
- while ($row = $result->fetch()) {
- $classes[] = $row['class'];
- }
- $result->closeCursor();
- return $classes;
- }
-
- public function find(int $id): AuthorizedGroup {
- $queryBuilder = $this->db->getQueryBuilder();
- $queryBuilder->select('*')
- ->from($this->getTableName())
- ->where($queryBuilder->expr()->eq('id', $queryBuilder->createNamedParameter($id)));
-
- $authorizedGroup = $this->findEntity($queryBuilder);
- return $authorizedGroup;
- }
-
- public function findAll(): array {
- $qb = $this->db->getQueryBuilder();
- $qb->select('*')->from($this->getTableName());
- return $this->findEntities($qb);
- }
- public function findByGroupIdAndClass(string $groupId, string $class) {
- $qb = $this->db->getQueryBuilder();
- $qb->select('*')
- ->from($this->getTableName())
- ->where($qb->expr()->eq('group_id', $qb->createNamedParameter($groupId)))
- ->andWhere($qb->expr()->eq('class', $qb->createNamedParameter($class)));
- return $this->findEntity($qb);
- }
-
- public function findExistingGroupsForClass(string $class): array {
- $qb = $this->db->getQueryBuilder();
- $qb->select('*')
- ->from($this->getTableName())
- ->where($qb->expr()->eq('class', $qb->createNamedParameter($class)));
- return $this->findEntities($qb);
- }
-
- public function removeGroup(string $gid) {
- $qb = $this->db->getQueryBuilder();
- $qb->delete($this->getTableName())
- ->where($qb->expr()->eq('group_id', $qb->createNamedParameter($gid)))
- ->executeStatement();
- }
- }
|