I require a complete website built. I will supply images and text
content, as well as a description for the layout for most pages.
1: Main index page: this will have specified images & content on the
left, and a box on the right for a user to enter a 'PIN' for a prize
code, along with an image verification code to prevent automated bots
from submitting the form.
Upon entering a code, a query should be made to a DB, containing 10000
records (I will supply DB in excel format) If a match is found for the
PIN number, a corresponding Prize page should be displayed (there will
be 10 different prize pages, I will supply images and content for each
page) If no match is found, an error page should be displayed. Once a
PIN has been entered and claimed, it should be marked in the DB as
already used, and if another user tries to enter that PIN in the future,
it should be rejected indicating an error page that says it is already
claimed (I will supply text for this page too)
On the prize pages, the user will be asked for contact information,
which should be written to a winners database, along with their winning
PIN number, and corresponding prize number. Also the current date/time.
The user should receive a standard confirmation page after submitting
2: Distributor Registration: This page will be a standard form, where
information collected will be written to a Distributors table in the DB.
3: Distributor Rebate page: This page will allow distributors to log
in using a username/password. Once in, there should be a place for
distributor to enter up to 10 PIN numbers. Upon submit, the script
should verify that PIN numbers exist in prize table, and what each prize is. If a PIN number matches one in DB, that prize & PIN number should be written to a Distributors Rebate table, assigned to that distributor login ID and the PIN should be marked as used in the prize DB. A results page should be displayed, showing which of the PIN numbers entered match the Prize DB, and the associated prize for that PIN. If a PIN does not match, it should show the PIN number entered on the results
page, and indicate that it does not match any prize. The prizes will be dollar amounts, and the results page should show the total amount of all prizes won based on the PIN numbers entered.
4: No Purchase Contest Entry Page: This page will be a form (including image verification link to prevent submit) Fields should be written to a No Purchase Table upon submit, including a unique field identifier number for the record. After successful submit, a confirmation page should be displayed, showing the information they entered, and allowing them to edit any errors, after final submit, a success page should be displayed.
5: Admin area: Admin should be able to search and display records from each individual table (Distributor Registration Table, Distributor Rebate Table, No Purchase entries table, and Winners table) Admin should also be able to export the search results they are viewing into
an excel format file.