nextcloud / circles

	/**

	 * @param IQueryBuilder $qb

	 */

	protected function linkToCircleOwner(IQueryBuilder &$qb) {

		$expr = $qb->expr();

		$qb->selectAlias('mo.user_id', 'circle_owner');

		/** @noinspection PhpMethodParametersCountMismatchInspection */

		$qb->leftJoin(

			'c', CoreRequestBuilder::TABLE_MEMBERS, 'mo', $expr->andX(

			$expr->eq(

				'mo.circle_id',

        $qb->createFunction('SUBSTR(`c`.`unique_id`, 1, ' . Circle::SHORT_UNIQUE_ID_LENGTH . ')')

			), $expr->eq('mo.user_type', $qb->createNamedParameter(Member::TYPE_USER)),

			$expr->eq('mo.level', $qb->createNamedParameter(Member::LEVEL_OWNER))

		)

		);

	}

	/**

	 *

	 * @return \OCP\DB\QueryBuilder\ICompositeExpression

	 */

	private function exprLinkToMemberAsGroupMember(IQueryBuilder &$qb, $userId) {

		$expr = $qb->expr();

		/** @noinspection PhpMethodParametersCountMismatchInspection */

		$qb->leftJoin(

			'c', CoreRequestBuilder::TABLE_GROUPS, 'g',

			$expr->andX(

				$expr->eq(

					'g.circle_id',

					$qb->createFunction('SUBSTR(`c`.`unique_id`, 1, ' . Circle::SHORT_UNIQUE_ID_LENGTH . ')')

				)

			)

		);

		$qb->leftJoin(

			'g', CoreRequestBuilder::NC_TABLE_GROUP_USER, 'ncgu',

			$expr->eq('ncgu.gid', 'g.group_id')

		);

		return $expr->andX($expr->eq('ncgu.uid', $qb->createNamedParameter($userId)));

	}

	/**