Eric Butera wrote: > On Thu, May 15, 2008 at 2:49 PM, afan pasalic <afan@xxxxxxxx> wrote: > >> Iv Ray wrote: >> >>> afan pasalic wrote: >>> >>>> this one bugs me for a while. how to change order. >>>> >>>> I have a list of tasks. by status, task could be 1 (todo) or 0 (done) - >>>> status value stored in mysql. I can list tasks per status or all. >>>> order number is stored in mysql too. >>>> the easiest way to change order is to have form for each task where you >>>> will enter manually number and then submit (one submit button for whole >>>> form). but, if you change order number for any task you have to change >>>> then all order numbers "below" the task manually >>>> >>>> solution with "arrows" (or up/down buttons) where you click on arrow and >>>> the task switch the place with its "neighbor" is easy and fancy. Though, >>>> I get in trouble if, e.g. tasks 10, 11, 12, and 13 change status from 1 >>>> to 0 and I have to move task 14 to place 6. I have to click first 4 >>>> times (to switch places with tasks 13, 12, 11, and 10) - but nothing is >>>> actually happening on screen (of course) before start switching places >>>> with 9, 8, 7, and 6. >>>> >>>> how do you avoid this "gap"? >>>> what solution do you use at all? >>>> >>> You have two different issues - a) how to execute the change, and b) >>> what interface to provide. >>> >>> To execute the change, basically you have to reorder. The best >>> algorithm is question of mathematics - you can implement "something" >>> and improve it independently from the interface. >>> >>> As for the interface, the first is kind of the simplest, but somehow >>> primitive. The second is a bit better, but you have noticed, not much >>> better. The most elegant, considering the time we live in, would be >>> drag & drop AJAX (here - http://tool-man.org/examples/, there are >>> excellent examples, perhaps there are more). >>> >>> It's also a question if tasks really need to be reordered manually. If >>> all tasks have a deadline, you might sort them by date. If some don't, >>> you can provide them unsorted, until they get one. Sorting tasks by >>> moving them up/down works when you have 25 tasks, but it does not work >>> when you have 50, 100, 1 000 (if you are a team leader and have 5-7 >>> people team) - in that case sort by date might be better. >>> >>> If you get more advanced, and store time needed to complete a task, >>> you could automatically shift all tasks (of a person) - when one gets >>> delayed or takes longer, than planned. >>> >>> Hope that helps, >>> Iv >>> >> thanks Iv, >> though, in my case, the task list will never be more then 25 and we can >> talk about "small" list. >> and, I need to sort them by order_no (bitter to say "priority_no") >> >> thanks for link. the Dag & Drop sortable list is really cool! >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> >> > > I use this: > > http://developer.yahoo.com/yui/examples/dragdrop/dd-reorder.html > This one is good too. But, actually, I need something more simple. Nothing "fancy" :D. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
