Beverage Inventory – CSE Senior Design

Team Name

The Drunken Masters

Timeline

Summer 2019 – Fall 2019

Students

Bikesh Shrestha
Ishwar Silwal
Bidur Karki
Bibhusan Manandhar
Bhaskar Man Banepali

Abstract

To store and edit the information on the personal collection of beverages like whisky, beer, wine, or coffee. Information includes volume, weigh, acquisition date, consumption trends, and/or position of them item in the store.
To reduce the waste of time writing down each beverage item as well their information in record book which is tedious.
Makes easier to sort the items saved allowing the option of sorting by date, name, volumes.
Allows to see the products which are already saved in the database.

Background

The beverage inventory application will help user to keep track of their beverage or any inventory
products like, beer, wine, coffee etc. which is also the main purpose of the application. The intended
audience of the product is the single user who want to keep track of the products at their place. In
addition, it can be used by small businesses like bar, restaurants etc. The main part of the application is
the user end view and the back-end view. The user end view consists of how the app will look from the
user perspective whereas the back-end view will consist of the back-end parts such as storing data and
how the back end runs for the projects. User will be able to add inventory, change inventory, remove
inventory and keep track of the inventory using this application. The Beverage app would be able to
change the inventory of the beverage by manually entering the value or by using a bar code scanner to
input the value. The user will be provided with many features like, sign up, log-in, create profile, create
product as well as individual information, add and subtract any products manually or by scanning etc. with the
help of different buttons and features available in the product. The application will be available for the
android mobile operating system.
Once the user download and open the application they will be directed to the login screen where they
will sign up for the first time. They will enter the information like their name, email, password, DOB,
phone no, address etc. This information will be saved on the database and can be edited later, which
can be access by the user using profile button once they log into the application. User can log in using
email and password which will lead them into the main screen of the application with features/buttons
like:
1. Profile: This button will help the user to view their own information which they entered while
signing up. This information like phone no, username, bio etc. can be edited whenever user want to.
2. Scan/ Manual: This button will help the user to store the information about the products. User
can do so either manually or using the bar code scan feature. If the product is new, then they will need
to store the information of the product initially. If the product is already stored, then it will lead the user
to the product information and edit them. Where they can add, update and delete the product information.
3. Products: This button helps the user to easily access the information of the product already stored
in database. It will lead the user to the list of products which can be sorted using name, time, date etc.
User can also search the product using the search button available at the top of the screen.
All the information about the user and product like, username, password, phone no, type, age etc.
will be saved in the Firebase Realtime database. Which is displayed to the user through the application whenever they request it.

Project Requirements

To design a system that will allow user to keep track of his/her Beer, Wine and Liquor inventory.
Create a system that allows user to add, delete or edit new beverage according to its types manually or using the bar code scanner.
Create a system that allows user to give the real time number of his/her beverage using the pie chart.
Create a system that allows user to sort the beverage inventory.
Collect user Full name, Email and Date of Birth.
System verifies the user to be at least 21 years old to be able to use the app.
An android phone with a camera
The user should have a valid email address.

System Overview

Our System overview comprises of three parts: Beverage Inventory Interface Portal, Beverage Inventory System Database, Beverage Inventory System Controller. The Beverage Inventory Interface Portal is back-end system that handles the user’s authentication into the application, registers the new users to the application etc. The Beverage Inventory System Controller is a responsible for providing the User Interface of the application. Every query of the users is handled through this system like scanning the bar code, filling the user’s inventory, entering the user’s information, on the top of that this also handles as the output screen for the user’s queries. This system acts as a bridge between the database system and the Interface Portal. Finally, Beverage Inventory System Database is responsible for accessing, updating or deleting the contents from our online Firebase database. In other words, this system helps push or retrieve the users and their info from the database, along with their inventories.

Results

App Demo

Future Work

Add the feature to display the details of the inventory when user taps their beverage and view info like type of product, quantity, volume etc.
Implementing the image recognition of various beverage products.
Launch the app in iOS.