Pokémon - People UBC's Okanagan Campus

Pokémon.netYour Black Market Dealer of Pokémon - Gotta Catch ‘em All 11.30.2019 Emily MedemaKathryn LechaNoah MarshallLauren St. Clair

11 Introduction1.1 Mission StatementPokémon.net - Your Black Market Dealer of Pokémon. Gotta catch ‘em all : To exploit yourlove of Pokémon for monetary gain and good grades. As Pokémon fans, we have alwayswanted to collect and capture Pokémon with ease. We almost achieved it when during adislocated knee incident, one of our team was wheeled around playing Pokémon Go. BUTwe knew we could make the process even easier for ALL trainers. Thus, Pokémon.net.1.2 Purpose of DocumentThis document highlights the design, features, and a walkthrough for Pokémon.net BlackMarket Site. There will be both an administrator walkthrough, and a user walkthroughincluded.1.3 Executive SummaryPokémon.net - Your Black Market Dealer of Pokémon is a web-based e-commerce site thatallows trainers to complete their pokédex with ease at the click of a button. Unlike thetroublesome endeavor the traditional hunting of pokémon is becoming with the surplus oftrainers. Pokémon.net allows you to outshine those traditionalist and truly “catch ‘em all” for only a small fee, no walking necessary.

22 System FeaturesFinal Overall System FeaturesCategoryPossiblePointsPointsDocumentation (10 total points)Executive Summary (up to 1 page)Core2System Features (2 pages)Core2Walkthrough with screenshots (up to 10pages)Core6Core55Search for a product by nameCore11Browse products by categoryCore11List products (by search/browse)Core11List products with imageCore11Page header with menuBasic11Page header shows current logged inuserBasic11Dynamic products on page based onsalesBasic2Improved UI (user-friendly, images, etc.)Basic2Product recommendation based on userAdvanced4Add to shopping cartCore11View shopping cartCore11Update quantity (with data validation)Basic22Hosting (5 total points)Running on cosc304 or external serverMain/Home Page (up to 14 total points)2Shopping Cart (up to 9 total points)Comments / CodeFiles

3Remove item from shopping cartBasic11Improved formatting/UI (e.g. in headerbar)Basic11Cart stored in database betweensessionsBasic3Checkout with customer idCore11Checkout with payment/shipment infoBasic22Checkout with data validationBasic22Multiple shipments per order supportedAdvanced2Note: Requires DBchange.Calculate taxes/shipping (byitems/state)Advanced2Note: Requires DBchange.Product detail page and item descriptionCore11Product detail has an imageCore11Product detail has an image fromdatabaseCore1Checkout (up to 9 total points)Product Detail Page (up to 3 total points)User Accounts/Login (up to 16 total points)Create user account pageBasic33Create account with data validationBasic33Edit user account info (address, Register user/Forgot password emailPage listing all orders for user

4Product Reviews (up to 5 total points)Ability to enter a review on a productBasic22Display product review on product detail pageBasic11Advanced22i used a subquery bcreasonsBasic2Advanced3Secured by loginCore11only admin loginList all customersCore11List report showing total sales/ordersCore11Advanced3Add new productBasic22Update/delete productBasic21Change order status/ship orderBasic1Upload a photo to file system for productAdvanced2OR: Upload a photo to database for productAdvanced4Database restore with SQL scriptBasic2Add/update warehouse, customerBasic2Advanced2Restrict to one review per user on itempurchasedWarehouses/Inventory (up to 5 total points)Display item inventory by store/warehouseEdit item inventory by store/warehouseAdministrator Portal (up to 21 total points)Report with a graphDatabase System/GeneralImplement some validation using triggers2

5Use AJAX for some pagesAdvanced4User interface and navigation/usabilityUp to 5Others (your suggestions)Up to 5Autoplay of Pokerap by BDGTotal: (out of 50 with maximum of 10 bonusmarks. i.e. 60 points out of 50 is max.)555

63 WalkthroughFor this walkthrough please use https://cosc304.ok.ubc.ca/91175448/lab8/Admin Users:Professor Samuel Oak:Gym Leader Misty:userid: profuserid: mistpassword: oakpassword: pysduckNonAdmin Users:Gary Oak:Ash Ketchum:Sapphire Birch;userid: ggoakuserid: ashuserid: sapphirepassword: smellyalaterpassword: pikachupassword: passpass3.1 User WalkthroughThe following walkthrough demonstrates the user view of the websitehttps://cosc304.ok.ubc.ca/91175448/lab8/ . All functionality specific to the user is includedbelow.1Welcome to the Pokemon.nethomepage. Here you will findinformation about what we do and theservices that we provide. To login orcreate an account visit the respectivelinks ‘Create an account’ or ‘Log in’above the navigation bar.The homepage also autoplays a loopedversion of the Pokérap by Brian DavidGilbert.2To learn more about our goals, how tocontact us, and our service, visit ourabout page via the ‘About Us’ button onthe navigation bar.

73The login page may be accessedthrough the ‘Log in’ button above thenavigation bar or during checkout. Auser will be prompted to log in duringcheckout if they have not already.To login as a user, use the usernameand password created fromregistration.If you have forgotten your password,click the forgot password link.3aEnter your email. If you enter the wrongemail you receive a message statingthat there is no user with that email.Once a valid email has been submitted,the user is directed to a pending pageand an email is sent.When the user goes to the providedURL. They can then reset theirpassword.

84The sign up page may be accessed‘Create an account’ button above thenavigation bar. A user will be promptedto fill out the fields for their username,first name, last name, email, phonenumber, address, city, state/province,postal code, country, and password.Users will need to confirm theirpassword in order to submit the form.Users will also be redirected to thelogin page at the bottom of the form ifthey have previously registered for anaccount.Once their account is created they willreceive an email congratulating themon their new account and providingtheir username.

95Once logged in ‘Customer info’ is nowviewable alongside ‘Shopping cart’,‘Log out’, and ‘Reset Password’ abovethe navigation bar. To view yourinformation visit ‘Customer info’.6The customer information pagecontains all information specific to theuser that the user completed duringregistration. The user is also given theability to view their order history andedit their information.7To reset your password use the ‘ResetPassword’ button above the navigationbar. You will be redirected to the resetpassword page, where you will beprompted to create and confirm yournew password.

108To begin shopping for Pokemon, youcan view the list of Pokemon availablefor purchase. All listed Pokemoninclude a name, price, and categorybased on type (i.e. Fire, Water, etc.). Toadd a Pokemon to your cart, click thebutton ‘Add to Cart’ on the bottom ofthe card.9To sort by type or by name, use thesearch bar above the product table.You may select a type and/or aspecific Pokemon by name to show onthe product table.10We have selected by type ‘Grass’. Herewe can now see all Pokemon availablefor purchase that are of the ‘Grass’ type.For more information about a particularPokemon, click on the product name ofthe specific Pokemon to be redirectedto product details.11The product details page can beaccessed through the product list pageby clicking on the specific Pokemonname. Product details include thePokemon name, id, price, description,and customer reviews. The productdetails page also allows to go back tothe product list page by the link‘Continue Shopping’. To add aPokemon to your cart via the productdetails page, click the ‘Add to Cart’button below the table.

11If the user is logged in, they will alsohave the option to review the Pokémonon this page.12A Pokemon can be added to yourshopping cart via the product list orproduct details page through thebuttons ‘Add’ on the product list pageor ‘Add to cart’ on the product detailspage. Once a Pokemon is added toyour cart, you will be redirected to theshopping cart page, including all itemsthat have been added during thesession.13To change the quantity of a Pokemonin your shopping cart, change the valuewithin the quantity field of thePokemon you wish to add to removequantities of, and then use the ‘UpdateQuantity’ button to update the quantityof that Pokemon. The price of thatPokemon will be updated according toit quantity, and the total of the shoppingcart will be updated.14To remove a Pokemon entirely fromyour shopping cart, use the button‘Remove from cart’. The Pokemon willbe removed entirely from the shoppingcart. We can see after removing‘Chaizard’ both are removed afteradding a quantity of 2.15Checkout. Here users can pick if theywant to pay with PayPal or Credit Card.

1215aIf they pick to pay with a credit card,they will need to enter the type,CSV/Payment Number and ExpiryDate.15bIf the customer picks PayPal, they willbe prompted to sign into PayPal.16Once checkout is complete the userwill be given their order summary withthe product id, name, quantity, price,and subtotal.3.2 Administrator WalkthroughThe following walkthrough demonstrates the administrator view of the websitehttps://cosc304.ok.ubc.ca/91175448/lab8/ . All functionality specific to the administrator isincluded below.

131Welcome to the Pokemon.nethomepage. Here you will findinformation about what we do and theservices that we provide. To login usethe ‘Log in’ button above thenavigation bar.2The login page may be accessedthrough the ‘Log in’ button above thenavigation bar or during checkout. Youwill be prompted to log in duringcheckout if they have not already.If you are an administrator, your adminstatus will be recognized upon loggingin.3Once logged in as an administrator, anAdministrator portal will becomeavailable above the navigation baralongside the option to view yourcustomer information, shopping cart,reset password, and log out. Anadministrator will see a button reading‘Administrator’, which a normal userwill not be able to see.4The admin portal can be accessed viathe ‘Administrator’ button above thenavigation bar, where the admin will beredirected to the admin portal. Theadmin portal includes the ‘AdminPage’, ‘All Orders’, ‘All Customers’, and‘Manage Database’. The admin pagepage can be accessed via the ‘AdminPage’’ button on the navigation bar inthe admin portal. The admin pageincludes a list of orders with theirrespective date and total orderamount.

145The ‘All Orders’ page can be accessedvia the ‘All Orders’ button on thenavigation bar in the admin portal. The‘All Orders’ page includes all orderinformation, such as the order Id, orderdate, customer id, customer name,total amount of order, and all productids, quantities, and prices specific toeach item purchased.6The all customers page can beaccessed via the ‘All Customers’button on the navigation bar in theadmin portal. The ‘All Customers’ pageincludes all registered customers withtheir respective customer id, user id,name, email, and phone number.7The ‘Manage Database’ page can beaccessed via the ‘Manage Database’button on the navigation bar in theadmin portal. The ‘Manage Database’page allows an administrator reloadthe database from default, add a newproduct to the database, and delete aproduct from the database. To add aproduct to the database the admin isrequired to complete the fields:product name, category name,product price, description, andrelevant image. To delete a productfrom the specific Pokemon name canbe used as an input, and will beremoved from the database aftersubmission.

1.2 Purpose of Document This document highlights the design, features, and a walkthrough for Pokémon.net Black Market Site. There will be both an administrator walkthrough, and a user walkthrough included. 1.3 Executive Summary Pokémon.net - Your Black Mar