I would like the following system made in PHP/mySQL (NO design needed):
1. login page
- a form with email and password field
- a “forgot password” link
- user logs in: if user entered wrong login, show error, else user gets redirected to account page
- must use sessions
2. forgot password page
- a form with email field
- user enters email and password will be mailed to the user
- if the entered email is not in the database, show error
3. account page
- on top show user info (like name, address, website URL, etc)
- below that is a field with a unique link (link generated with user ID and the end)
- below that are a few banners (I will provide those)
- below that are two numbers: revenue approved, reventue not yet approved (this data will be extracted from the database, see database layout below)
- below that is a table showing the current month and days in that month (up to the current day). Each line will contain: date, revenue, commission (this data will be extracted from the database, see database layout below). In the last line of the table there will be calculated the total revenue and total commission.
- above the table there will be a dropdown menu to choose: orders approved, orders not approved, total orders
- also above the table will be a dropdown to choose month and year
- depending on the status, below the table the user sees: nothing, status pending or status paid (data from database). If status is paid then there will also be a link to an invoice.
- if the invoice link is clicked a new window will open and show my company info, user info (like address), the total amount of that months earnings. This can all be in HTML or a generated PDF.
Database layout (all tables are already made). I will only mention the fields that should be used :
- earnings table: autoincr. id, user id, revenue, commission, date (Y-M-D), status (1, 2 or 3)
- user table: autoincr. id, user id, first name, last name, address, zip code, city, country, email, website URL, VAT number, company number, company name, bankaccount no, iban no, bic code, bank name
My hosting has PHP 4.3.2 and mysql 3.23.58.
I will provide layout and sample data.
Look at the attachment for a quick overview of what I mean (this is NOT the actuall layout of course)