SIMS - Smart Inventory Management System

Introduction

This is the inventory management system of the Automation & Robotics Club of BITS Pilani Hyderabad Campus. All the code is in Python 3 and PyQt5 with several autogenerated lines of code from QtCreator .ui files.

This application runs on a Raspberry Pi 3 connected to an 8" 1280x800 touchscreen. Combined with an upcoming Smart Lock project, this will make the management of inventory in small labs much easier.

Installation

On Ubuntu or derivative distros, simply run:

sudo apt install pyqt5-dev pyqt5-dev-tools python-sqlite python3-serial python3-crypto

Then, run the file using:

./main.py

Database

Users

ID	Name	Email ID	Phone call	Phone whatsapp	Room no.	Salt	Hashed Password	Fingerprint ID	Is Admin

• This table consists of all the registered users and their relevent information.
• The Is Admin field determines whether a particular user has access to the admin functions.
• Here ID is a primary key.

Transactions

ID	Name	Item ID	Quantity	Issue Datetime	Withdraw Datetime	Return Datetime

• This table is used to manaage all the withdran items from the inventory.
• A particular entry will be moved to the History table after the item is returned.
• Here ID is a foreign key.

History

ID	Name	Item ID	Quantity	Issue Datetime	Withdraw Datetime	Return Datetime

• this table has the details of all the transactions that have occurred previously.
• Here ID is a foreign key.

Inventory

Item ID	Name	RFID	Shelf no.	Box no.	Catagory	Quantity	Description

• This table consists of all list of Items present in the inventory along with their location and quantity.
• Here Item ID is a primary key.

Purchase

ID	Project	Price	Item	Date

• This table is used to record all the purchase requests from the users.
• Here ID is a foreign key.