nextcloud / circles

	 * @param IQueryBuilder $qb

	 * @param string $userId

	 */

	protected function leftJoinUserIdAsViewer(IQueryBuilder & $qb, $userId) {

		if ($qb->getType() !== QueryBuilder::SELECT) {

			return;

		}

		$expr = $qb->expr();

		$pf = $this->default_select_alias . '.';

		/** @noinspection PhpMethodParametersCountMismatchInspection */

		$qb->selectAlias('u.user_id', 'viewer_userid')

		   ->selectAlias('u.status', 'viewer_status')

		   ->selectAlias('u.level', 'viewer_level')

		   ->leftJoin(

			   $this->default_select_alias, CoreRequestBuilder::TABLE_MEMBERS, 'u',

			   $expr->andX(

				   $expr->eq($pf . 'id', 'u.circle_id'),

				   $expr->eq('u.user_id', $qb->createNamedParameter($userId))

			   )

		   );

	}

	/**

	 * Left Join members table to get the owner of the circle.

	 *

	 * @param IQueryBuilder $qb

	 */

	protected function leftJoinOwner(IQueryBuilder & $qb) {

		if ($qb->getType() !== QueryBuilder::SELECT) {

			return;

		}

		$expr = $qb->expr();

		$pf = $this->default_select_alias . '.';

		/** @noinspection PhpMethodParametersCountMismatchInspection */

		$qb->selectAlias('o.user_id', 'owner_userid')

		   ->selectAlias('o.status', 'owner_status')

		   ->selectAlias('o.level', 'owner_level')

		   ->leftJoin(

			   $this->default_select_alias, CoreRequestBuilder::TABLE_MEMBERS, 'o',

			   $expr->andX(

				   $expr->eq($pf . 'id', 'o.circle_id'),

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

			   )

		   );

	}

	/**