Php and mySql website.? The site is a DB where users will be able to log in and insert wine names and other data. For each wine name the site will create a code following the rules that? I will explain.? User page to list the wines user has added, etc.? Admin page where I can delete wines, users and see some statistics.
## Deliverables
**Home**
(Menu: Sign In, Wine Page, About and Contact Us)
Below de Menu, Search bar with search by name, country,? wine code, and two big buttons (see image attached): include wine and include producer
?
**Sign In Page**
User signs in with email confirmation
(fields user name, password, city, country and email)
?
**Wine Page (is also the Home, below the menu)**
**(when Home is oppened, show the last x wines that were added)**
Include Wine (login necessary)
Exclude Wine (login necessary, user can exclude only wines they have included in the last 48 hours)
?
List in this page the wines selected by the search criteria that user chooses
List one per line (mouse over change line color), when user clicks in that line a small window is open with the wine data.? Format:
Wine Name ??" Wine code ??" Country Name ??" Country Code ??" Label Picture (miniature of the FIRST label picture)
?
**Wine Data (when adding a wine)**
Wine Name
Country (within the ones admin has added)
Area (within that specific country that admin has added)
? ? ? ? ? ? ? ? Note: area names/codes are connected with a specific country
Type (white, red, spumante, etc)
Year (format xxxx , example, 1999 or 2002)
Grapes (add until 10 grapes per wine, using grapes that admin has added)
Producer (select coutry then show a scroll list if all the producers in that country, alphabetic listed ??" see below ??" note: to add a wine, the user will need to add the producer first, if it is not listed yet).
Comments (text field)
Pictures (Label Pictures): upload label picture.
?
**Important:** The Wine Code is created by the system when the user adds the wine.
The user selects the Country name, in a scroll selection, within the ones Admin has added (see below), Area (by name, within the ones admin has added), etc.
The system generates the Wine Code, using the format below:
?
xxx ??" first 3 letters ??" country code
xxxx ??" 4 letters ??" area code
xxxx ??" 4 letters ??" counter (00001 for the first wine added... )
?
For example, one Wine Code could be:
Country code ??" 055
Area Code ??" 0031
Counter ??" 0002
So, Wine Code will be: 05500310002
?
**Let’s call this format Short Code**
?
Every time that a wine is added, the system will create two codes:
-? ? ? ? ? ? ? ? short code
-? ? ? ? ? ? ? ? long code (see below)
?
***Long Code = Wine Code + Space + Producer Code***
?
**Producer Data / Code**
?
Producer Code will have almost the same format that Wine Code (and must be created first by the user if it doesn’t exist)
?
xxx ??" first 3 letters ??" country code (same rules that wine code)
xxxx ??" 4 letters ??" area code (same rules that wine code)
xxx ??" 3 letters ??" counter (00001 for the first wine added... )
?
For example, one Producer Code could be:
Country code ??" 055
Area Code ??" 0031
Counter ??" 078
So, Wine Code will be: 0550031078
?
In this case, Long Code will be:
?
05500310002 0550031078
?
Two other fields must be avaliable when adding producer data: producer site, producer e-mail.? The system must also registrer date and user e-mail (that added the producer).
?
?
**Admin Page**
Add/Delete/Edit Country/Country Code
Add/Delete/Edit Area (within a specific country)
Add/Delete/Edit Wine Type
Add/Delete/Edit? Grapes
List/Add/Delete/Edit? Any Wine / Any Wine Data
List/Add/Delete/Edit? Any Producer / Producer Data
List users (name, city, country and e-mail)
Export Date (download the data table with all wine data)
?
**User Pages**
User log in and Add/Delete/Edit User data
List wines user has added
Delete/Edit wines user has added (maximum 48 hours after data has been added, after that, only admin can delete the data)
?
**About Page**
Just add de button, I will make the html page about us
?
**Contac Us**
Just add de button, I will make the html page “contact us