We are developing an online directory in classic asp along with MS access. We would like some help on a product management module adding, editing, approving & deleting products. To add products we also need to give our users the ability to upload product images. We have some classic asp upload routines (which we have used with our other websites) but they're not that great.
For our [add products] module, we need a classic asp routine to upload images & store product information in our products table. The products table has between 20 to 30 fields including 8 images (designed to store image file names not files). The table looks something like this: (ProductTitle,ProductShortDesc, ProductLongDesc,ModelNo, BrandName, Unit price img1,img2,img3,img4,img5,img6,img7,img8..... etc)
The upload needs to be more sophisticated than the technology we have now and should have the following features:
*Ability to allow file types specified by us (ex: only jpg & gif)
*The ability to restrict file sizes being uploaded onto our server
*Progress bar for files being uploaded
*The uploaded files can be uploaded to the folder of our choice & renamed & resize (any size) the uploaded images making a thumbnail copy of the image. (ex: if the companyid is 120 then we could rename the images to as they're being uploaded [url removed, login to view] & [url removed, login to view])
*The functionality to *watermark the images too
The process is this:
WHAT WE ALREADY HAVE
*We have a company profile page with category (such as Agriculture) and up to 5 sub categories (such as Flower Extracts)
*Opposite each Sub Category there is a submit button with caption "add product", the submit button can send form values companyid & productid into the pages you will create.
WHAT WE NEED:
*[Add Product] Upon clicking "add product" button we would like to see a classic Asp product form with about 20 to 30 normal fields (numerics, text, memo) and up to 8 images, which would allow the user to add new products.
The product data (such as ProductTitle, ProductShortDesc, ....etc) will be stored in the access database. The image filenames (just names not the files themselves) will be stored in their corresponding fields (img1 to img8), and the images (.gif & jpg) themselves will be stored in "Images" folder. PLEASE NOTE at this point, the product added will have the bHide (boolean) flag set to true.
Products added above should be listed with checkboxes next to each (20 per page). Images (thumbnails) should also be displayed below each line of product. Checkboxes to be ticked by default & one approval button for the whole 20. Upon clicking the approve button, the bHide is set to False and product will be visible to the public.
*[Edit Product] A similar form as [add product] which allows user to change product details including imags. Images must be synched and updated on the folder accordingly. If some images are removed by user, then they should also physically be deleted from the folder they live in.
*[Delete Product] A form with a list of products and the functionality to delete one or more of the products from the database
We are computer & programming literate so Please make your proposals in some detail & let us know how long you will take to do the job.
By undertaking the above job you agree that ALL source code developed by you will be delivered to us.
By undertaking the above job you agree that All source code you write including scripts, code for dlls (if any) will not only be made available to us, we will also have the right to edit & re-use the source codes and scripts at any time and for any other projects we choose.