Wine DB

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