140 likes | 285 Views
Automated Inventory Management Chao Li CS491 Spring 2006. Background. Traditional method of managing inventory Inaccuracy and inefficiency Wasting time and human efforts to check inventory weekly. Prone to human errors Hard to maintain inventory levels. Introduction.
E N D
Automated Inventory Management Chao Li CS491 Spring 2006 AIM
Background • Traditional method of managing inventory • Inaccuracy and inefficiency • Wasting time and human efforts to check inventory weekly. • Prone to human errors • Hard to maintain inventory levels. AIM
Introduction • An stand alone program that automatically manages restaurant’s liquor inventory • Orders, sales, etc. • Improve efficiency and accuracy • Up-to-date inventory info • Reduced errors due to human factors • However, still exists inevitable human errors in using it. AIM
Users • Regular users: waiter/waitress • Place orders • Check inventory levels • View past order information AIM
Users • Managers • Order inventory from liquor vendors • Delete certain orders • Check sales in the past • Re-stock inventory • All functions as regular users AIM
Technology and Development • J2SE: Swing and awt • MySQL and JDBC • CS server • Auto_increment of mysql and Serial type of postgreSql. • netBeans 5.0 AIM
Technology • Some useful JTable class • setValueAt(row, col) • getValueAt(row, col) • Print() • setRowSelectionInterval(index0, index1), inclusive AIM
Architecture • Client Tier • User Interface • Displaying menu, sales summary, inventory, orders information, ect. AIM
Architecture • Client Tier • Summary: sales summary in the past periods • Inventory: current inventory levels • Orders: orders information in time fashion • Restock: out going orders that send to vendors AIM
Architecture • Business Tier • Methods to retrieve or store data from or to database • Methods to support all the functionality, verify user’s input AIM
Architecture • Data Tier • Actual data stored in database • Inventory: inventory’s info such as id, name, vendor’s email, total • order detail: id, item, total, order time • outgoing orders: orders that send to vendors AIM
Summary • Automated Inventory System that manages inventory accurately, provide inventory level up-to-date, store orders information • Improved efficiency of inventory management and accuracy • A lot to do in the future AIM
Thank You – Any Questions? • Demo AIM