Project Detail

Description

We would like to add review and rating system for our web site(s). We hired someone who has done something simple but it does not look good, so I would like to ask you if you can do it, if so how long would it take. Here is the summary:

• It needs to be in ASP with SQL database in the back.
• It will record star rating of the current product
• Optionally people will be able to leave a review about the product
• Star rating should be java script + AJAX so 1) it looks good 2) page doesn’t refresh (as soon as they click on the star, it will be recorded to the database using AJAX)
• There should be some cookie and/or IP checking so same people should not give ratings over and over again
• The optional review form contains email field and review text field. Once a review is submitted, automated email will ask for confirmation. Once the confirmation link is clicked, we know the email is verified (and so the isVerified = true in the database).
• We need an admin page so we can list and approve the reviews (it will list reviews, whether the poster is verified or not)
• There should be an ASP file which we can include into our product pages. This ASP script will show 1) Average rating of the current product 2) Stars for rating 3) Approved reviews 4) Review form. This is important. This will be the main file which we include in all the product pages.
• Database can be as simple as 2 tables: Rating table will have ProductID, StoreID, Rating, DatePosted fields. Product ID and Store ID will be supplied before the ASP include, and Rating will be supplied by the end user. Review table, similarly, will have ProductID, StoreID, Email, isVerified, ReviewText, DatePosted, isApproved fields.
• Example: Our web store (StoreID = 1) has a product page, displaying a T-shirt (ProductID = TS1). This product page will have variables ProductID and StoreID ready for your include. When we include the ASP script that you provided, it will display 1)Average star rating (if there is any star rating for that StoreID-ProductID pair in the database) 2) Five empty stars for user input so it can be recorded with ProductID and StoreID 3) All the reviews in Reviews table with matching ProductID ans StoreID, and isApproved field is true. 4)Review form so when it is submitted, it will record the user input with ProductID StoreID pair.

This is the basic idea.
This can be developed totally independent from our servers (to test the ASP include file, simply add something like ProductID = “test1” : StoreID = 1 at the top)
After the project is done, all we need is the database file, include file, the admin file, and other related files (images, function includes etc.)
It doesn’t have to be exactly like this - If you have already done something like this or better, that’s fine.

Please let me know if this is doable, and if so how long would it take.