nextcloud / circles

	 *

	 * @return IQueryBuilder

	 */

	protected function getBaseSelectSql($shareId = -1) {

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

		/** @noinspection PhpMethodParametersCountMismatchInspection */

		$qb->select(

			's.id', 's.share_type', 's.share_with', 's.uid_owner', 's.uid_initiator',

			's.parent', 's.item_type', 's.item_source', 's.item_target', 's.file_source',

			's.file_target', 's.permissions', 's.stime', 's.accepted', 's.expiration',

			's.token', 's.mail_send', 'c.type AS circle_type', 'c.name AS circle_name',

			'mo.user_id AS circle_owner'

		);

		$this->linkToCircleOwner($qb);

		$this->joinShare($qb);

		// TODO: Left-join circle and REMOVE this line

		$this->linkCircleField($qb, $shareId);

		return $qb;

	}

	/**

	}

	protected function getCompleteSelectSql() {

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

		/** @noinspection PhpMethodParametersCountMismatchInspection */

		$qb->select(

			's.*', 'f.fileid', 'f.path', 'f.permissions AS f_permissions', 'f.storage',

			'f.path_hash', 'f.parent AS f_parent', 'f.name', 'f.mimetype', 'f.mimepart',

			'f.size', 'f.mtime', 'f.storage_mtime', 'f.encrypted', 'f.unencrypted_size',

			'f.etag', 'f.checksum', 'c.type AS circle_type', 'c.name AS circle_name',

			'mo.user_id AS circle_owner'

		)

		   ->selectAlias('st.id', 'storage_string_id');

		$this->linkToCircleOwner($qb);

		$this->joinShare($qb);

		$this->linkCircleField($qb);

		return $qb;

	}

	/**