Interactive sorting and grouping

[jimoblak]

I know my PHP and MySQL but am pretty weak on Javascript so I rely on existing frameworks and snippets to get me by. I am currently looking for a way to sort and group elements.

A step in the right direction seems to be found at:

http://www.cyberdummy.co.uk/test/dd.php

But what I want to do involves the following data example:

id|parent_id|item
1|0|fruits
2|0|vegetables
3|0|apples
4|0|pears
5|0|corn
6|0|Granny Smith

The user would be presented with a list that looks like this:

fruits
vegetables
apples
pears
corn
Granny Smith

The user would then drag elements around so that the database would be instantly updated to this:

id|parent_id|item
1|0|fruits
2|0|vegetables
3|1|apples
4|1|pears
5|2|corn
6|3|Granny Smith

And then the user would see something like this:

fruits
--apples
----Granny Smith
--pears
vegetables
--corn

I'm basically looking for the same functionality of any operating system's method of drag-n-drop file management - - - but I seem to be using the wrong keywords to search for something like this. The examples that I am finding only sort order in a list - - they do not offer the sub-grouping required in this sample.

Can someone point me to a good resource or existing library/framework for this?

 

[jimoblak]

Sorry - I'm nearsighted. I was looking at Dojo in the drag-drop section but I should have looked in the general widgets for 'tree'.

While I try to wrap my head around Dojo, any other suggestions are still welcome.

 

[1DMF]

This site might be of help

http://scbr.com/docs/products/jtree/jtree.shtml

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you.

 

[jimoblak]

Thanks - I am actually interested in the related package at

http://www.scbr.com/docs/products/dhtmlxTree/

but may be stuck with something more easily licensed with Dojo.

 

[tsdragon]

You could also take a look at . They have sortable functionality, and their documentation is better than most.

Tracy Dryden

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.

 

[rhyno2k]

Jim,

How about the Interface Sortables module for jQuery?

http://interface.eyecon.ro/demos/sort.html

Looks like you'd need to predefine your category blocks (fruits, vegetables, etc.), but the organization is there (click the "serialize" links at foot to see sorted arrays).


--RHYNO