Change List Order in PHP

In Progress Posted Jan 29, 2007 Paid on delivery
In Progress Paid on delivery

Basically I want to make some minor tweaks to the backend design and add the drag and drop functionality of [url removed, login to view] to reorder my listings.

Will give a bonus of up to $50 for completing this quickly and well.

Here are some tutorial links that explain how to do this:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

and this is the clearest one I've seen yet

[url removed, login to view]

Existing System Screen Shots:

[url removed, login to view] Category Editor

[url removed, login to view] Current Listing Editor View

Please see attached image: [url removed, login to view]

I want to add the ability to reorder listing items within a category via drag and drop using the [url removed, login to view] drag and drop reordering script.

I also want you to be able to reorder by clicking on up and down arrows, as shown in the image.

To see this in action go to: [url removed, login to view]

even better if you could have it work like this:

[url removed, login to view]

So when you hover over any non-link on this section it will show the move cursor (with the 4 arrow heads), if you hover over the move up/down link or edit listing link it will show the regular and with pointer finger cursor. Look at the image I created - it has a border around the section being moved - I would like the border to be coded on there as well.

The relavent code for this section is in the file ../include/[url removed, login to view] starting at line #1139.

Possible logic:

Add a field to the database to specify listing order, probably on the table default_classlistingsdb call it something like "listingorder"

Since each item is assigned to a category there are a couple options for the listingorder sorting.

The first is you can have repeated values per category so within each category you can have a listingorder value of 1 - X. Or you could have the listingorder actually be unique regardless of category, in this case when you're making the process to change the order you'll have to actually give the original listing the "listingorder" value of the listing you are moving. This can get to be a somewhat tricky sql operation when you are using the drag and drop ordering system and have to update all of the other listings' "listingorder" value at the same time. Also please notice the few visual changes I made on this and make these as well.

Category Editor Changes:

See [url removed, login to view]

Pretty much the same changes as above in terms of drag and drop functioning.

I also want this to be adjusted to match the way the listing editor looks - as shown in the jpeg. Where the category title is actually a hyperlink to modify it, and the rows are shaded differently.

Edit Images Changes:

Please see [url removed, login to view]

The only difference here is the portion with the thumbnails at the top.

This should be the easiest to do as it's not dealing with multiple categories and such. This also already has an image order function built in. I basically want the drag and drop ordering to integrate with the existing image ordering method, as pictured. One Portion which I didn't put into the jpeg that I would like is a "featured photo" function that allows you to select one image to show up as the first large image on the front end. I'm picturing something like a "Feature this Photo" link right above the link to delete the image - by default the first photo in any listing will be the featured photo. You can only have one featured photo, and if a photo is featured it will say "Featured Photo" in place of the "Feature this Photo" link.

PHP

Project ID: #121936

About the project

1 proposal Remote project Active Jan 30, 2007

1 freelancer is bidding on average $60 for this job

sitesound

I have been writing AJAX style applications for several years before someone coined the term and the development pattern became popular. Fast turn around time. Resume available.

$60 USD in 2 days
(2 Reviews)
4.2