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(

						   'SUBSTR(' . $pf . '`unique_id`, 1, ' . Circle::SHORT_UNIQUE_ID_LENGTH

						   . ')'

					   )

				   ),

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

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

			   )

		   );

	}

	/**

	 *

	 * @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(

						   'SUBSTR(' . $pf . '`unique_id`, 1, ' . Circle::SHORT_UNIQUE_ID_LENGTH

						   . ')'

					   )

					   , 'o.circle_id'

				   ),

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

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

			   )

		   );

	}