From d0060968b77c39bdf8abffb071c971c166b59edb Mon Sep 17 00:00:00 2001
From: Nicolas BERNSTEIN <alexis211@gmail.com>
Date: Sat, 17 Sep 2011 16:48:29 +0200
Subject: First commit.

---
 tpl/notes/inc_relativestree.php | 139 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 139 insertions(+)
 create mode 100644 tpl/notes/inc_relativestree.php

(limited to 'tpl/notes/inc_relativestree.php')

diff --git a/tpl/notes/inc_relativestree.php b/tpl/notes/inc_relativestree.php
new file mode 100644
index 0000000..be0e224
--- /dev/null
+++ b/tpl/notes/inc_relativestree.php
@@ -0,0 +1,139 @@
+<?php
+
+/* OLD WAY
+
+// ******* FETCH DATA
+
+if ($note['parent_id'] != 0) {
+	$brothers = array();
+	$n = sql("SELECT id, title, owner FROM notes WHERE parent = " . $note['parent_id'] . " ".
+		($note['owner'] == $user['id'] ? "" : " AND public != 0 ").
+		"ORDER BY title ASC");
+	while ($nn = mysql_fetch_assoc($n)) $brothers[] = $nn;
+}
+$children = array();
+$n = sql("SELECT id, title, owner FROM notes WHERE parent = " . $note['id'] . " " .
+	($note['owner'] == $user['id'] ? "" : " AND public != 0 ") .
+	"ORDER BY title ASC");
+while ($nn = mysql_fetch_assoc($n)) $children[] = $nn;
+
+$user_root_notes = array();
+$n = sql("SELECT id, title, owner FROM notes WHERE parent = 0 AND owner = " . $note['owner'] . " " .
+	($note['owner'] == $user['id'] ? "" : " AND public != 0 ") .
+	"ORDER BY title ASC");
+while ($nn = mysql_fetch_assoc($n)) $user_root_notes[] = $nn;
+
+// ****** DISPLAY TREE
+
+echo '</div><div class="contents-left">';
+echo '<h1>' . $note['ownername'] . '</h1><br />';
+echo '<div class="small_right"><a href="user-notes-' . $note['owner'] . '">complete tree</a></div>';
+
+function list_brothers_and_children() {
+	global $brothers, $children, $note, $user, $can_new;
+	echo '<div class="tree_branch">';
+	foreach($brothers as $b) {
+		if ($b['id'] == $note['id']) {
+			echo '<p>' . $b['title'] . '</p><div class="tree_branch">';
+			foreach($children as $nn) {
+				echo '<p><a href="view-notes-' . $nn['id'] . '">' . $nn['title'] . '</a></p>';
+			}
+			if ($can_new) {
+				echo '<p><a class="tool_link" href="new-notes-' . $b['id'] . '">+ new note</a></p>';
+			}
+			echo '</div>';
+		} else {
+			echo '<p><a href="view-notes-' . $b['id'] .'">' . $b['title'] . '</a></p>';
+		}
+	}
+	if ($can_new) {
+		echo '<p><a class="tool_link" href="new-notes-' . $note['parent_id'] . '">+ new note</a></p>';
+	}
+	echo '</div>';
+}
+
+echo '<div class="tree_branch">';
+$did_show_up = false;
+foreach($user_root_notes as $n) {
+	if ($n['id'] == $note['id']) {
+		$did_show_up = true;
+		echo '<p>' . $n['title'] . '</p><div class="tree_branch">';
+		foreach($children as $nn) {
+			echo '<p><a href="view-notes-' . $nn['id'] . '">' . $nn['title'] . '</a></p>';
+		}
+		if ($can_new) {
+			echo '<p><a class="tool_link" href="new-notes-' . $note['id'] . '">+ new note</a></p>';
+		}
+		echo '</div>';
+	} else {
+		echo '<p><a href="view-notes-' . $n['id'] . '">' . $n['title'] . '</a></p>';
+		if ($n['id'] == $note['parent_id']) {
+			$did_show_up = true;
+			list_brothers_and_children();
+		}
+	}
+}
+if ($can_new) {
+	echo '<p><a class="tool_link" href="new-notes-0">+ new note</a></p>';
+}
+echo '</div>';
+
+if (!$did_show_up) {
+	echo '<br /><br />';
+	echo '<a href="view-notes-' . $note['parent_id'] . '">' . $note['parent_title'] . '</a>';
+	list_brothers_and_children();
+}
+
+*/
+
+// *** NEW WAY
+
+$notes_tree = array();
+$notes_parents = array();
+$n = sql("SELECT id, parent, title FROM notes ".
+	"WHERE owner = " . $note['owner'] .
+	($note['owner'] == $user['id'] ? " " : " AND public != 0 ") .
+	"ORDER BY title ASC");
+while ($nn = mysql_fetch_assoc($n)) {
+	$notes_parents[$nn['id']] = $nn['parent'];
+	if (isset($notes_tree[$nn['parent']])) {
+		$notes_tree[$nn['parent']][] = $nn;
+	} else {
+		$notes_tree[$nn['parent']] = array($nn);
+	}
+}
+
+$notest = array(0 => @$notes_tree[0]);
+for($id = $note['id']; $id != 0; $id = $notes_parents[$id]) {
+	$notest[$id] = @$notes_tree[$id];
+}
+
+echo '</div><div class="contents-left">';
+echo '<h1>' . $note['ownername'] . '</h1><br />';
+echo '<div class="small_right"><a href="user-notes-' . $note['owner'] . '">complete tree</a></div>';
+
+function n_tree_branch($id) {
+	global $notest, $note, $can_new;
+	if (!isset($notest[$id])) return;
+	foreach($notest[$id] as $branch) {
+		if ($branch['id'] == $note['id'])
+			echo '<p>' . $branch['title'] . '</p>';
+		else
+			echo '<p><a href="view-notes-' . $branch['id'] . '">' . $branch['title'] . '</a></p>';
+		if (isset($notest[$branch['id']])) {
+			echo '<div class="tree_branch">';
+			n_tree_branch($branch['id']);
+			echo '</div>';
+		} else if ($can_new && $branch['id'] == $note['id']) {
+			echo '<div class="tree_branch">';
+			if ($can_new) echo '<p><a class="tool_link" href="new-notes-' . $branch['id'] . '">+ new note</a></p>';
+			echo '</div>';
+		}
+	}
+	if ($can_new) echo '<p><a class="tool_link" href="new-notes-' . $id . '">+ new note</a></p>';
+}
+
+echo '<div class="tree_root">';
+n_tree_branch(0);
+echo '</div>';
+
-- 
cgit v1.2.3