On Wed, Nov 5, 2008 at 1:47 AM, Rene Veerman <[EMAIL PROTECTED]> wrote:
> Hi.
>
> I'm trying to build a new admin interface for my cms, in a single screen.
>
> I was thinking to have a tree-view on the left side of that screen,
> something like
> +Site-Name
> + UserGroups and Users (node-type section)
> + Administrators (node-type usergroup)
> - administrator (node-type user)
> + Editors (node-type usergroup)
> - Joe
> + Regular users
> - guest
> + Site main pages (node-type section)
> - frontpage (node-type article)
> - contactpage
>
> Then on the right side of the screen, i'd have pieces of HTML+JS ("weblets")
> provide a "form service" to display/edit properties of different node-types.
>
> Since i have to store access-rights for the different nodes, i have created
> a sql table that holds my tree, like:
>
> CREATE TABLE master_admin_tree (
> /* tn == tree node */
> tn_id integer,
> tn_language_id integer,
> tn_parent_id integer,
> tn_path longtext,
> tn_level_order integer,
> tn_label varchar(250),
> tn_description longtext,
> tn_type_id integer,
> tn_value_int integer,
> tn_value_vc varchar(250), tn_value_text
> longtext,
> /* stores many values in JSON format */
> tn_flags_int integer,
> tn_flags_text longtext,
> tn_owner_user_id integer,
> tn_owner_group_id integer,
> resource_rights_id integer,
> PRIMARY KEY (tn_id, tn_language_id)
> );
>
> The problem is that i'd rather not store all user-groups and users in this
> table.
> Users and groups are stored in their own tables, just 2 flat list tables
> without tree-structure.
>
> I wonder if it would get too complicated to load the users and groups from
> their own tables, format them to be tree-nodes in master_admin_tree, put
> them in the tree and work with them.
> I can't fully envision the problems that might arise with a dynamic loading
> approach like this, but i do know it would be a bitch to put a tree-node in
> master_admin_tree that loads up the desired groups-list (that's doable), but
> then to load the users in those groups as nodes under each group.
>
> Should i just go for redundant data in master_admin_tree and on creation of
> a user also put a tree record in master_admin_tree?
>
> Or is there a way to load,store and manage tree-nodes that represent records
> in other flat-list tables?
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
I use the YUI TreeView for rendering the tree. As for storing it I
use the modified pre-order tree traversal method.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
