A simple web based demo application is required. Here's the specifications:
1. it contains four tables, business, hours, user, changes tables, all sql definition will be given as attached.
2. the web application must be written in php, use mysql as database, all web pages are tempalte driven.
3. the web page template contains a 728 x 90 graphic logo at the top, anything you can create.
4. use a clean, simple and modern Look and Feel templates.
5. user can log in using email and password.
6. user can retrieve password by email. (an php email script is also attached for reference.)
7. after log in, user can add a new business to his account. ( a php script does the db insert can be see as reference)
8. after log in, user can update the information of any business in his account.
9. after log in, user can deactive the status any business in his account to inactive.
10. after each of the 7-9 is exectuted, a row is inserted into the changes table with the following data. user id, time, action update, biz id, userip)
what the application should not do.
if a user is not logged in a session, he should not be allowed to any changes, in another word, the authentication is required before 4-6 can be executed, disallow hacking by methods such as enter the url with parameters.
Before and after your bid, makes sure send me some reference of your previous work.
50% payment after it is finished and runs well on your test environment. 50% payment after it is installed and tested runs on my godaddy hosting.
If you need to clearfy anything or have any question, pm me anytime.
user with fields: userid(int), email(String), password (String), status(int, default 1), group(int, default 1), createdDate(time), lastLoginTime(Time), lastLoginIP(String)
business with field, businessId(int, auto), names (String), userid(int, reference user table), address1(String), address2(String), city(String), state(String), postal code(String), phonenumber(10digit string), fax(10 digits string), comment(text).
hours with field, businessId(int, reference business table), monday(String), tuesday(String), wednesday(String), thursday(String), friday(String), Saturaday(String), Sunday(String). potential values 11:00am-11:00pm, default closed.
changes with fields: user id(int, reference user table), time (timestamp), action(String), businessID(int, reference business table), ip(String)
11. after log in, user can add up to 3 pictures to each of the business. each pictures needs to be smaller than 300K
pictures with fields: id(int), businessID(int, /*the associated business reference business table*/), fileLocation(String, system file path), relativeURL(String, relativeURL) time (timestamp),
add a preview page to show the business information.
add a field max_business(int, default 10) to the user table, each user can add max of 10 business to its account. -1 means no limit.