OCA\NextNote\Db\NotebookMapper

Complexity

Total Complexity

19

Size/Duplication

Total Lines	130
Duplicated Lines	50.77 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
C	find()	33	33	7
C	findByName()	33	33	7
A	update()	0	4	1
A	delete()	0	3	1
A	makeEntityFromDBResult()	0	12	1
A	insert()	0	4	1

<?php
/**
 * Nextcloud - NextNote
 *
 * @copyright Copyright (c) 2015, Ben Curtis <ownclouddev@nosolutions.com>
 * @copyright Copyright (c) 2017, Sander Brand (brantje@gmail.com)
 * @license GNU AGPL version 3 or any later version
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as
 * published by the Free Software Foundation, either version 3 of the
 * License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 */

namespace OCA\NextNote\Db;

use \OCA\NextNote\Utility\Utils;
use OCP\AppFramework\Db\Entity;
use OCP\IDBConnection;
use OCP\AppFramework\Db\Mapper;

class NotebookMapper extends Mapper {
	private $utils;

	public function __construct(IDBConnection $db, Utils $utils) {
		parent::__construct($db, 'nextnote_groups');
		$this->utils = $utils;
	}


	public function find($notebook_id, $user_id = null, $deleted = false) {
		$params = [];
		$where = [];
		if($notebook_id){
			$where[] = 'g.id= ?';
			$params[] = $notebook_id;
		}

		if ($user_id) {
			$params[] = $user_id;
			$where[] = 'g.uid = ?';
		}

		if ($deleted !== false) {
			$params[] = $deleted;
			$where[] = 'g.deleted = ?';
		}
		$where = implode(' AND ', $where);
		if($where){
			$where = 'WHERE '. $where;
		}
		$sql = "SELECT g.*, g.guid as guid, COUNT(n.id) as note_count FROM *PREFIX*nextnote_groups g LEFT JOIN *PREFIX*nextnote_notes n ON g.name=n.grouping $where  GROUP BY g.id";
		$results = [];
		foreach ($this->execute($sql, $params)->fetchAll() as $item) {
			$results[] = $this->makeEntityFromDBResult($item);
		}
//		var_dump($results);
		if(count($results) === 1){
			return reset($results);
		}

		return $results;
	}


	public function findByName($group_name, $user_id = null, $deleted = false) {
		$params = [];
		$where = [];
		if($group_name){
			$where[] = 'g.name = ?';
			$params[] = $group_name;
		}

		if ($user_id) {
			$params[] = $user_id;
			$where[] = 'g.uid = ?';
		}

		if ($deleted !== false) {
			$params[] = $deleted;
			$where[] = 'g.deleted = ?';
		}
		$where = implode(' AND ', $where);
		if($where){
			$where = 'WHERE '. $where;
		}
		$sql = "SELECT g.*, COUNT(n.id) as note_count FROM *PREFIX*nextnote_groups g LEFT JOIN *PREFIX*nextnote_notes n ON g.name=n.grouping $where  GROUP BY g.id";
		$results = [];
		foreach ($this->execute($sql, $params)->fetchAll() as $item) {
			$results[] = $this->makeEntityFromDBResult($item);
		}

		if(count($results) === 1){
			return reset($results);
		}

		return $results;
	}

   	/**
	 * Creates a group
	 *
	 * @param Notebook|Entity $group
	 * @return Note|Entity
	 * @internal param $userId
	 */
	public function insert(Entity $group) {
		$group->setNoteCount(null);
		return parent::insert($group);
	}

	/**
	 * Update group
	 *
	 * @param Notebook|Entity $group
	 * @return Notebook|Entity
	 */
	public function update(Entity $group) {
		$group->setNoteCount(null);
		return parent::update($group);
	}

	/**
	 * Delete group
	 *
	 * @param Notebook|Entity $group
	 * @return Notebook|Entity
	 */
	public function delete(Entity $group) {
		return parent::delete($group);
	}

	/**
	 * @param $arr
	 * @return Notebook
	 */
	public function makeEntityFromDBResult($arr) {
		$group = new Notebook();
		$group->setId($arr['id']);
		$group->setName($arr['name']);
		$group->setGuid($arr['guid']);
		$group->setParentId($arr['parent_id']);
		$group->setColor($arr['color']);
		$group->setNoteCount($arr['note_count']);
		$group->setDeleted($arr['deleted']);

		return $group;
	}


}