Gallery Backend Development
MySQL version: 4
PHP version: 5
Overview:
We are putting together a Portfolio Management System and need someone to help develop a jQuery based image gallery backend. Some of the parameters or settings for the gallery or gallery images will come from a MySQL table. The use of Flash is strongly discouraged. The gallery “frontend” we are using is Gallerific. We are using an implementation very similar to the “Thumbnail rollover effects and slideshow crossfades” on the Gallerific website. (http://www.twospy.com/galleriffic/example-2.html)
The MySQL tables have not been put together yet. The chosen developer will have the option of building them them-self’s or working with me to build them.
1) No ajax save calls. Must use a “Save” button.
2) Dashboard
The end user must be presented with a screen indicating how many galleries they currently have and how many images are in each gallery. The number of galleries and the number of images per gallery is subject to change. This info is stored in a MySQL table.
3) Allow end user to set each images’s title and description
See example of title/description here http://www.twospy.com/galleriffic/example-2.html
4) Allow for multiple galleries
The system must allow the end user to create and manage multiple galleries. The number of galleries and images per gallery is set in a MySQL table.
5) Password protected galleries
The end user must be able to set passwords for any of their galleries. Some gallery content might be private therefore the end user must be able to set a password so the gallery can be viewed by others the end user chooses to share the password with.
6) Gallery Thumbnails
The end user must be able to mark one of the thumbnails in each gallery to help identify that gallery from the list of that users galleries.
7) Image Flagging
End user must be able to flag photos intended for mature audiences only.
Upload images
Would like to see some neat ajaxy type upload. Would really prefer not to use Flash.
9) Delete images
End user must have a way of removing a thumbnail and all the images that go with that thumbnail.
10) Automatically scale the uploaded images
Some end users will upload extremely large digital camera images. These need to be scaled down to any number of sizes determined in the MySQL table. The original can be deleted.
11) Crop images into thumbnails
The end user must have the option to be able to crop images to make thumbnails similar to http://www.webmotionuk.co.uk/jquery/image_upload_crop.php
12) Sorting of thumbnails
The end user must be able to change the order of the images by dragging the thumbnails.
13) Sorting of galleries
The end user must be able to change the order of the galleries by dragging the thumbnails.
14) Image transfer to a different gallery
End user must have a way (other than re-uploading) of moving an image to a different gallery.
15) Error checking/handling/validation
Your software must use validation to help minimize error input. Your software must employ client side and server side validation.
16) Compatibility
Your software must be compatible with IE 7 and greater, Safari 4 and greater, Firefox 3 and greater, Chrome 5 and greater on both Windows and Mac OS X.
17) Security
Your software must be free of any potential attacks and exploits such as but not limited to Cross-site scripting (XSS), Injection Attacks, etc.