180 likes | 316 Vues
Cross Platform Web Based Home Inventory System. Project Team: Jon Garibay , Firas Assaad Faculty Advisor: Dr . Lawrence Thomas. Presentation Agenda. Background information Database Web Service Web Site Android Application. Background.
E N D
Cross Platform Web Based Home Inventory System Project Team: Jon Garibay, FirasAssaad Faculty Advisor: Dr. Lawrence Thomas
Presentation Agenda • Background information • Database • Web Service • Web Site • Android Application
Background • Shopping for home consumables is a very time consuming task • In order to make informed decisions while in the store, individuals must know what items they currently have • Needed a solution that was robust and mobile
Background • Designed a home inventory system that is available via web page or Android application • Design effort included Database, API, web application, web service, and Android application
Database Database API Web Service Website High Level Application Architecture Internet Android Application Client Browsers High Level Architecture Server
Database • Microsoft SQL Server 2008 • Table Relationships and Indexing
Web Service • Custom-tailored • TCP Communication • XML Technology • Unified Database Communication
Web Site • Admin Side • Manage System • Manage Admin Users • Manage Houses • Client Side • Manage House • Perform Inventory • SMS alerts for low items • Tablet Side • Perform Inventory
Android Application Goals • The Android application needed to recreate the functionality of the web application but optimized for the Android smart phone platform. • Needed to be able to scan objects into the inventory for quick data entry
Scanning Items (Add Scan) Search for Product name In Database? No Yes Increment Item
Communications • Android application uses TCP connection to connect to web service • Communicates using XML messages • Single class handles web service communication
Future Plans • Move server to a Virtual Private Server (VPS) • Create shopping list prediction engine using product usage data • Rework UI of web site to show a more visual representation of a house and allow for drag and drop interaction. • Creation of a discrete bar code scanner and tablet combination for use in high traffic areas • Geo Reminders