Cancelado

PHP REORDER DATABASE ITEMS

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.

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

[url removed, login to view]

[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.

Here's another tutorial :-)
http://www.cyberdummy.co.uk/2005/07/13/multi-list-drag-and-drop/

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/

Habilidades: PHP

Ver mais: php reorder, reorder database, php reorder database, php reorder images, reorder items php, drag drop reordering database fields scriptaculous, php reorder script, php javascript reorder, reorder list ajax php, php reorder list, php reorder items database, reordering php, reorder items database, php script reorder pictures, php reorder items, drag drop reordering database fields, script reorder items database, php reordering, ajax reorder php, reorder entries php ajax, scriptaculous reorder mysql, drag drop reordering database, php scriptaculous reorder, php reordering database, x place com

Acerca do Empregador:
( 21 comentários ) New York, United States

ID do Projeto: #121471

4 freelancers estão ofertando em média $280 para este trabalho

MBarb

Hello, Thank you for considering our bid. We are a U.S. based Software and Web development company. We have over 4 years of Software / Web development experience. Please don't hesitate to contact me via PMB. Hope to he Mais

$300 USD in 14 dias
(3 Comentários)
5.6
phaseonemedia

You are aware that that script requires rails right? However I beleive similar effects can be produced using other ajax libraries and snippets.

$300 USD in 5 dias
(22 Comentários)
4.1
LenonJack

Ready to do it for you

$270 USD in 7 dias
(0 Comentários)
0.0
kolibri2

Please see pm

$250 USD in 7 dias
(0 Comentários)
0.0