how to approach this?

kark_1999

I have a call tracking system that I built in PHP and MySQL. Mgr of Development just told me to add a feature to it that I have no idea how to approach....

Say a developer has 40 calls assigned to him. He wants to be able to prioritize these calls by assigning them numbers 1 through 40. There will be only one #1, one #2, etc.

At first I thought I could display a form that lists all of the issues with a text box that would take a number. However, I'd have to dynamically accept and process an unknown number of text boxes. Plus, I don't want the user to be able to have 2 #1s.

Then I thought I could javascript the whole thing by adding the issues and brief desciption to a wide list box. I could have a move-up or move-down controls, then when satisfied, you could click SAVE. It would go through the rows in the list box and assign a priority number. Admittedly, I don't know how to do this.

Does anyone have any suggestions?
Thanks.
NOTE: I think this is ridiculous, but when management wants it, I have to do it.

vaaaska

It can be done...but you'll likely need to add a separate page for prioritizing the calls...

Just add a new field for the order of things and then every time a new one is added, deleted or order changed then you'll need to run a separate query...well queries...

To get the total number of calls and then updates the order field accordingly.

Give the priorities page some links to move the order around by +1 or -1 or to the top or bottom of the list. Or, give each call a drop down that allows them to set the order to exactly they want it...

It's kind of messy, but I've done it before...

Edit: Actually, this might be a good process to use Ajax on...do a search for javascript and ajax on Google if you don't know that that is...you'll still need PHP though...