Modules\Entitizer\Utils\Treeview

Complexity

Total Complexity

28

Size/Duplication

Total Lines	143
Duplicated Lines	19.58 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes	2
Bugs	0	Features	0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	getQueryJoin()	0	8	2
A	getSelectQuery()	0	12	2
A	getCountQuery()	0	6	1
A	getDepthQuery()	0	10	1
B	subtreeCount()	14	14	5
B	subtreeDepth()	14	14	5
B	path()	0	26	6
B	subtree()	0	27	6

<?php

namespace Modules\Entitizer\Utils {

	use Modules\Entitizer, DB;

	abstract class Treeview extends Collection {

		# Get join statement

		protected function getQueryJoin(int $parent_id) {

			return (0 !== $parent_id) ? (("JOIN " . static::$table_relations . " rel ") .

			       ("ON rel.ancestor = " . $parent_id . " AND rel.descendant = ent.id AND rel.depth >= 1")) :

				   ("JOIN " . static::$table_relations . " rel ON rel.descendant = ent.id");
		}

		# Get select query

		private function getSelectQuery(int $parent_id, array $config, array $order_by) {

			return ("SELECT " . $this->getSelection() . ", COALESCE(par.ancestor, 0) as parent_id ") .

			       ("FROM " . static::$table . " ent " . $this->getQueryJoin($parent_id) . " ") .

			       ("LEFT JOIN " . static::$table_relations . " par ON par.descendant = ent.id AND par.depth = 1 ") .

			       (('' !== ($condition = $this->getCondition($config))) ? ("WHERE " . $condition . " ") : "") .

			       ("GROUP BY ent.id ORDER BY MAX(rel.depth) ASC, " . $this->getOrderBy($order_by));
		}

		# Get count query

		private function getCountQuery(int $parent_id) {

			return ("SELECT COUNT(DISTINCT ent.id) as count FROM " . static::$table . " ent ") .

			       $this->getQueryJoin($parent_id);
		}

		# Get depth query

		private function getDepthQuery(int $parent_id) {

			$query = ("SELECT COUNT(DISTINCT rel.depth) as depth FROM " . static::$table . " ent ") .

			         $this->getQueryJoin($parent_id);

			# ------------------------

			return $query;
		}

		# Get subtree

		public function subtree(int $parent_id = 0, array $config = [], array $order_by = []) {

			if (!(static::$nesting && ($parent_id >= 0))) return false;

			# Select entities

			$query = $this->getSelectQuery($parent_id, $config, $order_by);

			if (!(DB::send($query) && DB::last()->status)) return false;

			# Process results

			$items = [$parent_id => ['children' => []]];

			while (null !== ($data = DB::last()->row())) {

				$dataset = Entitizer::dataset(static::$table, $data);

				$items[$dataset->id] = ['dataset' => $dataset, 'children' => []];

				$items[intval($data['parent_id'])]['children'][] = $dataset->id;
			}

			# ------------------------

			return $items;
		}

		# Get subtree count

		public function subtreeCount(int $parent_id = 0) {

This method seems to be duplicated in your project.

			if (!(static::$nesting && ($parent_id >= 0))) return false;

			# Get count

			$query = $this->getCountQuery($parent_id);

			if (!(DB::send($query) && DB::last()->status)) return false;

			# ------------------------

			return intval(DB::last()->row()['count']);
		}

		# Get subtree depth

		public function subtreeDepth(int $parent_id = 0) {

This method seems to be duplicated in your project.

			if (!(static::$nesting && ($parent_id >= 0))) return false;

			# Get depth

			$query = $this->getDepthQuery($parent_id);

			if (!(DB::send($query) && DB::last()->status)) return false;

			# ------------------------

			return intval(DB::last()->row()['depth']);
		}

		# Get path

		public function path(int $parent_id = 0) {

			if (!(static::$nesting && ($parent_id >= 0))) return false;

			# Process query

			$query = ("SELECT " . $this->getSelection() . " FROM " . static::$table . " ent ") .

			         ("JOIN " . static::$table_relations . " rel ON rel.ancestor = ent.id ") .

					 ("WHERE rel.descendant = " . $parent_id . " ORDER BY rel.depth DESC");

			# Select path

			if (!(DB::send($query) && DB::last()->status)) return false;

			# Process results

			$path = [];

			while (null !== ($data = DB::last()->row())) $path[] = Entitizer::dataset(static::$table, $data)->data();

			# ------------------------

			return $path;
		}
	}
}