Transcript - Marlon Rodrigo Hernandez

Building the
Archivist’s Beer Vault
Designed & built by : Marlon Rodrigo Hernandez
Site: http://www.mr-hernandez.com/projects/ABV
INDEX
1. Purpose
2. Development
I. SLIS 5200
II. SLIS 5745
III. SLIS 5707
IV. SLIS 5717
3. Site Demo
I. Home Page
II. Beer List
III. Shopping Cart
IV. Order Search
V. About
VI. Admin
4. Cheers!
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
2
PURPOSE
The Archivist’s Beer Vault (ABV) is a database that I have worked on since my second
semester at the University of North Texas (UNT). It began as a very basic database built using InMagic.
Throughout my time at UNT I have used the idea for projects with each class adding new dimensions to
the concept and design. The current version is a simple storefront website and a multiple entity SQL
database. This presentation will guide you through the development and a site demo of its current state.
Cheers!
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
3
DEVELOPMENT – SLIS 5200 – Spring 2014
Introduction to Information Organization (SLIS 5200) presented the first version of this
database, built using InMagic.
Key features at this stage:
Single Entity – Beer
Classification Scheme
Basic Record Structure – 19 elements
Authority Control – Fictional encyclopedia of beers
Controlled Vocabulary
User Test
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
4
DEVELOPMENT – SLIS 5745 – Summer 2014
Information Architecture (SLIS 5745) did not feature a version of the ABV but lessons learned
included: usability, user testing, and benchmarking.
During the rollout of the current site, other beer store sites were analyzed for desirable
features and layouts. Additionally, user testing was conducted at every major step.
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
5
DEVELOPMENT – SLIS 5707 – Fall 2014
The final project in Data Modeling for Information Professionals (SLIS 5707) moved the
database to Microsoft Access.
Key features at this stage:
Multiple Entity
Beer Record Structure
1.
Customer
4.
Brewery
UPC
Name
IBU
2.
Beer
5.
Style
ABV
Year
Availability
3.
Purchase
6.
Distributor
Awards
Rating
Price
First Entity Relationship Diagram
Queries and Reports
Business Rules Created
Fictional User Requirements
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
6
SLIS 5707
ABV in
Microsoft Access
Project write up and more
screenshots are available at:
www.mr-hernandez.com
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
7
DEVELOPMENT – SLIS 5717 – Fall 2014
Dynamic WWW Control Structures (SLIS 5717) did not feature a version of the ABV but the term
project, wine store website, provided practical applications.
Key features at this stage:
Site Map Developed
ERD – Slightly restructured
SQL – Insert, Modify and Select commands created
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
PHP – Developed dynamic pages
8
SITE DEMO
Now lets see how it all turned out!
http://www.mr-hernandez.com/ABV
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
9
Main Page
PURPOSE: Presents user with list of
STYLES currently in database
SITE DEMO
PROCESS:
• PHP function creates header and
menu.
• SQL queries database and retrieves
all STYLE entries.
• PHP takes array and for each displays
generic image saved as STYLE_ID.
• PHP function creates footer.
Project hosted on:
www.mr-hernandez.com/projects/ABV
Page shown: /index.php
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
10
Style Page
PURPOSE: Displays BEERS in STYLE
SITE DEMO
PROCESS:
• SQL queries database and retrieves
BEERS from selected STYLE.
• PHP takes array and for each displays
logo, STYLE_Name, BEER_Rating,
and BEER_Container. Link is also
created to BEER details page.
• PHP function creates a back button
to main page.
Project hosted on:
www.mr-hernandez.com/projects/ABV
Page shown: /show_style.php
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
11
Beer Page
PURPOSE: Displays selected BEER
SITE DEMO
PROCESS:
• SQL queries database and retrieves
BEER, STYLE and DISTRIBUTOR
information. The information is
joined into an array.
• PHP takes array and creates four
sections.
o Introduction – parses
STYLE_Name,
DISTRIBUTOR_ACity & AState,
and BEER_Description.
o Vitals – BEER details with values
and ignores NULL.
Project hosted on:
www.mr-hernandez.com/projects/ABV
Page shown: /show_beer.php
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
12
Beer Page, Cont.
o Enjoy With – STYLE_Glass and
STYLE_FoodPairings
o Find Me – BEER_Availability,
STYLE_Location,
BEER_Classification and
BEER_Price
• PHP function creates a add to cart
button, back button for style and a
button to browse beer list page.
SITE DEMO
Project hosted on:
www.mr-hernandez.com/projects/ABV
Page shown: /show_beer.php
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
13
Browse Beer List Page
PURPOSE: Presents user with list of all
BEERS in the database.
SITE DEMO
PROCESS:
• SQL queries the database for every
BEER record.
• PHP takes array and for each displays
logo, STYLE_Name, BEER_Rating,
and BEER_Container. Link is also
created to BEER details page.
Project hosted on:
www.mr-hernandez.com/projects/ABV
Page shown: /browse.php
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
14
Cart Page - View
• PHP uses session to store selection.
• PHP functions allows users to change
quantity, go to checkout or main
page.
SITE DEMO
Project hosted on:
www.mr-hernandez.com/projects/ABV
Cart Page - Checkout
• HTML form collects USER
information. First visible business
rule: the store only ships to
California.
• All fields are required.
• PHP function creates buttons to
continue or head back to cart.
Pages shown: /show_cart.php
/checkout.php
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
15
Cart Page - Purchase
• HTML form displays fictional
payment process.
• PHP function creates buttons to
finalize purchase or back to
checkout.
SITE DEMO
Project hosted on:
www.mr-hernandez.com/projects/ABV
Cart Page - Checkout
Pages shown: /purchase.php
/checkout.php
• PHP inserts PURCHASE, CUSTOMER,
and PURCHASE_ITEMS details into
database.
• Users provided with message of
either database verification or
failure.
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
16
Order Search
• HTML form takes user details.
SITE DEMO
Project hosted on:
www.mr-hernandez.com/projects/ABV
Order Search Results
Pages shown: /query_order.php
• PHP selects orders that match the
CUST_Email and PURCHASE_Date.
• If a match, CUST_Name,
CUST_Email, PURCHASE_Status, and
PURCHASE_Total are displayed.
/query_order_process php
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
17
About
• HTML displays:
o Purpose
o Entity-Relationship Diagram
o Site Map
o Future
o Contact
o Thank You
SITE DEMO
Project hosted on:
www.mr-hernandez.com/projects/ABV
Page shown: /about.php
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
18
Admin
• I could add more slides on how this
works… or how about you try it out?
• See SAMPLE sheet next to laptop for
instructions how to ADD A BEER to
the database.
• To see reports use laptop to navigate
to the admin page, link in footer.
o Username = admin
o Password = admin
SITE DEMO
Project hosted on:
www.mr-hernandez.com/projects/ABV
Page shown: /admin.php
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
19
CHEERS!
Thank you for your time and special thanks to the wonderful Marla Ross!
MARLON HERNANDEZ | UNIVERSITY OF NORTH TEXAS
20