The following is what I am looking to have added to my web site. The theory and /or workflow is what I have thought of. If you can provide the outcome with other workflow I am open to ideas. All databases need to be mysql and placed/built into my site.
Zip code Database:
Need to track zip codes our company are working.
Need mysql DB to track the following.
Zip Code, State, Town, Sales person, Sales person email address, URL link of web page
Need a form to use to update new activated zips and other data into DB.
Need Zip code query for home page for user to enter zipcode. It needs to look up the zip they enter and follow the URL link in the DB. If zip is not in DB default link should be used to go to a coming soon page. Cookie for returning users.
User registration database:
Need DB created to track the following: Name, address, gender, age group, email address. Last Survey
Need form created for registration page. User to enter info to register. Submit button enters into DB.
Need this to run on home page and links from a few other pages will point back to this.
Need DB created to track the following: Advertiser name, state, town, art name, creator, art location, Sales person, Date entered, web page location, Issue, day run (1-15), ad # (1-10),
Need a button created “Click Button” to place on page to take survey. It needs to prompt the user for there email address before continuing. Validate if registered user if not display please register with link to registration page. If registered go to webpage #1. Each day (1-15) logic needs to either update code on the button so it knows what day it is on or look up in DB what day to use. We should talk before you start on this so we are clear on what I am looking for. Once it knows what day to display it will display page 1 of X number of pages (5 or so).
Need Button created that will not be clickable until a timer counts down from 15 to zero. Timer should be visible. Idea is the user has to stay on that page for minimum 15 seconds before they can advance to the next page. We will use this button dozens of time so we need to be able to update the link (webpage) the button points at if it will be in the code.
When the user is directed to page #1 (from above take survey) the button (timer 15-0) will be on this page. When time is up and the user click to go to next page it will go to page 2, page 3, 4 etc… until it gets to the last page.
Need Button created that when clicked will look up by user email address what the last survey they completed (User registration database) and point them to the next survey in the list. Looked up in survey DB. If priority A surveys exist and have not been completed then go to priority level B surveys.
Need survey database created to track the following:
Survey name. Priority, region, zone, area, town, category,
If we start off with 100 or so surveys set to, lets say priority level B (or something) and the need arises to get 10 questions pushed to the front of the line we can enter them in as priority A and all users should start with this survey on there next attempt.