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(

					   'u.circle_id',

					   $qb->createFunction(

						   'LEFT(' . $pf . 'unique_id, ' . Circle::UNIQUEID_SHORT_LENGTH . ')'

					   )

				   ),

				   $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(

					   $qb->createFunction(

						   'LEFT(' . $pf . 'unique_id, ' . Circle::UNIQUEID_SHORT_LENGTH . ')'

					   )

					   , 'o.circle_id'

				   ),

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

			   )

		   );

	}

	/**