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
