cadmium-org / cadmium-cms

		# Disconnect subtree from current position

		private function disconnectSubtree() {

			$query = ("DELETE rla FROM " . static::$table_relations . " rla ") .

			         ("JOIN "  . static::$table_relations . " rlb ON rlb.descendant = rla.descendant ") .

					 ("LEFT JOIN " . static::$table_relations . " rlx ") .

					 ("ON rlx.ancestor = rlb.ancestor AND rlx.descendant = rla.ancestor ") .

					 ("WHERE rlb.ancestor = " . $this->id . " AND rlx.ancestor IS NULL");

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

			# Set path

			$this->data['parent_id'] = 0;

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

			return true;

		}

		# Connect subtree under new position

		# Connect subtree under new position

		private function connectSubtree(int $parent_id) {

			$query = ("INSERT INTO " . static::$table_relations . " (ancestor, descendant, depth) ") .

			         ("SELECT sup.ancestor, sub.descendant, sup.depth + sub.depth + 1 ") .

					 ("FROM " . static::$table_relations . " sup ") .

					 ("JOIN " . static::$table_relations . " sub ") .

					 ("WHERE sub.ancestor = " . $this->id . " AND sup.descendant = " . $parent_id);

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

			# Set path

			$this->data['parent_id'] = $parent_id;

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

			return true;

		}

		# Create entity entry in DB