PHP REORDER DATABASE ITEMS

PHP REORDER DATABASE ITEMS is project number 121471 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Cancelled by Service Buyer)
Selected Providers:	-
Budget:	$100-300
Created:	01/26/2007 at 17:18 EST
Bidding Ends:	02/05/2007 at 17:18 EST
Project Creator:	sethnick99   Buyer Rating: (19 reviews)
Description:	Basically I want to make some minor tweaks to the backend design and add the drag and drop functionality of script.aculo.us to reorder my listings. Here are some tutorial links that explain how to do this: http://www.phpriot.com/d/articles/client-side/sortable-lists-with-php-and-ajax/index.html http://ryan.cfwebtools.com/2006/12/31/drag-and-drop-sort-order-with-scriptaculous/ Existing System Screen Shots: catorder.jpg Category Editor adminlistings.jpg Current Listing Editor View Please see attached image: reordercategoryitems.jpg I want to add the ability to reorder listing items within a category via drag and drop using the http://script.aculo.us/ 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: http://wiki.script.aculo.us/scriptaculous/page/print/GhostlySortableDemo even better if you could have it work like this: http://demo.script.aculo.us/ajax/sortable_elements 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/listing_editor.inc.php 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 catreorder.jpg 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 imageorder.jpg 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. Additional information submitted: 01/26/2007 at 19:05 EST: Here's another tutorial :-) http://www.cyberdummy.co.uk/2005/07/13/multi-list-drag-and-drop/ 01/26/2007 at 19:06 EST: and this is the clearest one I've seen yet http://wiseguysonly.com/2006/08/11/drag-and-drop-reordering-of-database-fields-with-ajax/ Additional files submitted: adminlistings.jpg catorder.jpg reordercategoryitems.jpg catreorder.jpg imageorder.jpg
Job Type:	PHP
Database:	MySQL
Operating system:	Linux
Bid count:	4
Average bid:	$ 280