nextcloud / circles

	 *

	 * @return \OCP\DB\QueryBuilder\IQueryBuilder

	 */

	private function getMemberFromCircleSql($circleId, $userId) {

		$qb = $this->db->getQueryBuilder();

		$expr = $qb->expr();

		/** @noinspection PhpMethodParametersCountMismatchInspection */

		$qb->select(

			'circle_id', 'user_id', 'level', 'status', 'note', 'joined'

		)

		   ->from(self::TABLENAME)

		   ->where(

			   $expr->eq('circle_id', $qb->createNamedParameter($circleId))

		   )

		   ->andWhere(

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

		   );

		return $qb;

	}

	/**

	 * get members list from a circle. If moderator, returns also notes about each member.

	 *

	 * @return \OCP\DB\QueryBuilder\IQueryBuilder

	 */

	private function getMembersFromCircleSql($circleId) {

		$qb = $this->db->getQueryBuilder();

		$expr = $qb->expr();

		/** @noinspection PhpMethodParametersCountMismatchInspection */

		$qb->select(

			'circle_id', 'user_id', 'level', 'status', 'note', 'joined'

		)

		   ->from(self::TABLENAME)

		   ->where(

			   $expr->eq('circle_id', $qb->createNamedParameter($circleId))

		   )

		   ->andwhere(

			   $expr->neq('status', $qb->createNamedParameter(Member::STATUS_NONMEMBER))

		   );

		return $qb;

	}

	public function editMember(Member $member) {