diff options
author | Nicolas BERNSTEIN <alexis211@gmail.com> | 2011-09-17 16:48:29 +0200 |
---|---|---|
committer | Nicolas BERNSTEIN <alexis211@gmail.com> | 2011-09-17 16:48:29 +0200 |
commit | d0060968b77c39bdf8abffb071c971c166b59edb (patch) | |
tree | 0be52e00a25bd298235a0cf916fb07496d3ab95f /tpl/notes/inc_relativestree.php | |
download | Bits-d0060968b77c39bdf8abffb071c971c166b59edb.tar.gz Bits-d0060968b77c39bdf8abffb071c971c166b59edb.zip |
First commit.
Diffstat (limited to 'tpl/notes/inc_relativestree.php')
-rw-r--r-- | tpl/notes/inc_relativestree.php | 139 |
1 files changed, 139 insertions, 0 deletions
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>'; + |