brantje / nextnote

	 * @param null $user_id

	 * @return OwnNote if not found

	 */

	public function find($note_id, $user_id = null) {

		$params = [$note_id];

		$uidSql = '';

		if($user_id){

			$params[] = $user_id;

			$uidSql = 'and n.uid = ?';

		}

		$sql = "SELECT n.id, n.uid, n.name, n.grouping, n.shared, n.mtime, n.deleted, p.pid, GROUP_CONCAT(p.note SEPARATOR '') as note FROM *PREFIX*ownnote n INNER JOIN *PREFIX*ownnote_parts p ON n.id = p.id WHERE n.id= ? $uidSql and n.deleted = 0 GROUP BY p.id";

		$results = [];

		foreach($this->execute($sql, $params)->fetchAll() as $item){

			$note = new OwnNote();

			$note->setId($item['id']);

			$note->setName($item['name']);

			$note->setGrouping($item['grouping']);

			$note->setMtime($item['mtime']);

			$note->setDeleted($item['deleted']);

			$note->setNote($item['note']);

			$note->setUid($item['uid']);

			$results[] = $note;

		}

		return array_shift($results);

	}

	/**

	 * @throws \OCP\AppFramework\Db\MultipleObjectsReturnedException if more than one result

	 * @return OwnNote[]

	 */

	public function findNotesByGroup($group, $userId) {

		$params = [$group];

		$uidSql = '';

		if($userId){

			$params[] = $userId;

			$uidSql = 'and n.uid = ?';

		}

		$sql = "SELECT n.uid, n.id, n.name, n.grouping, n.shared, n.mtime, n.deleted, p.pid, GROUP_CONCAT(p.note SEPARATOR '') as note FROM *PREFIX*ownnote n INNER JOIN *PREFIX*ownnote_parts p ON n.id = p.id WHERE n.deleted = 0 $uidSql and n.grouping = ? GROUP BY p.id";

		$results = [];

		foreach($this->execute($sql, $params)->fetchAll() as $item){

			$note = new OwnNote();

			$note->setId($item['id']);

			$note->setName($item['name']);

			$note->setGrouping($item['grouping']);

			$note->setMtime($item['mtime']);

			$note->setDeleted($item['deleted']);

			$note->setNote($item['note']);

			$note->setUid($item['uid']);

			$results[] = $note;

		}

		return $results;

	}

	/**

	 * Creates a note