INVENTORY MANAGEMENT SYSTEM
By
RAJ SHAH/SHAIVAL SHAH
16BCE060/16BCE063
DEPARTMENT OF COMPUTER ENGINEERING
Ahmedabad 382481
INVENTORY MANAGEMENT SYSTEM
Mini Project ‘ I
Submitted in fulfillment of the requirements
For the degree of
Bachelor of Technology in Computer Engineering
By
RAJ SHAH/SHAIVAL SHAH
16BCE060/16BCE063
Guided By
DR. VIJAY UKANI
[DEPARTMENT OF COMPUTER ENGINEERING]
DEPARTMENT OF COMPUTER ENGINEERING
Ahmedabad – 382481
CERTIFICATE
This is to certify that the project entitled ‘Inventory Management System’ submitted by Raj Shah(16BCE060) & Shaival Shah(16BCE063) towards the partial fulfillment of the requirements for the degree of Bachelor of Technology in Computer Engineering of Nirma University is the record of work carried out by him under my supervision and guidance. In my opinion, the submitted work has reached a level required for being accepted for examination.
Dr. Vijay Ukani Dr. Sanjay Garg,
Associate Professor Dept. of Computer Engineering,
Department of Computer Engineering, Institute of Technology,
Institute of Technology, Nirma University,
Nirma University, Ahmedabad
Ahmedabad
ACKNOWLEDGEMENT
We would like to express our deepest appreciation to all those who provided us the possibility to complete this report. We acknowledge with thanks, the support rendered by Dr. Vijay Ukani (Department of Computer Engineering), under whose aegis we were able to complete the task in a given period of time. We also appreciate the constructive suggestions given by our friends to further enhance content of the report.
At the home front, we are extremely grateful to our family members for the support and encouragement we got from them in successfully completing the report.
Abstract
The project Inventory Management System is based on an Retail Shoes Selling Store and also an online purchase portal. This project enables to reduce the maintenance of data of the stock manually by a person and thus saves time. A detailed report is being provided in our stock management system.
Our stock Inventory system involves four sub parts:
‘Purchase
‘Sales (new bill and sales bill)
‘Inventory
‘Contact
CONTENTS
Certificate
Acknowledgement
Abstract
Table of Contents
List of figures
List of tables
Chapter 1 Introduction
1.1 General
1.2 Scope of Work
Chapter 2 Overall description
2.1Product Perspective
2.2Functions
2.3Software Requirements
Chapter 3 Functional requirements
3.1 Initial Setup
3.2 Home Page
3.3 Inventory
3.4 Purchase
3.5 Sales
Chapter 4 Preliminary diagram
Chapter 5 Implementation
5.1 Database Creation
5.2 Implementation Of Various Pages
5.3 Database Connection Using JDBC
Chapter 6 Portal pages
6.1 Login page
6.2 Registration page
6.3 Home page
6.4 Product details
6.5 Adding new product
6.6 Supplier details
Chapter 7 Conclusion
CHAPTER 1:INTRODUCTION
1.1 General
This document gives the detailed report of our stock management system. it gives the description of scope and various parts of our software. In this project we have taken care of the activities related to maintaining the stock of all purchases that we have made or are going to purchase. This project enables to reduce the maintenance of data of the stock manually by a person and thus saves time.
The existing system involves maintenance of data of stocks manually. The proposed system enables to maintain accuracy and is time efficient.
1.2 Scope of work
Our project is based on an Retail Shoes Selling Store and is also an online purchase portal. This project can be used by customer to buy products online. using this software sales manager can keep record of purchase and sales of stocks and also of contact details of customers.
CHAPTER 2: OVERALL DESCRIPTION
2.1 Product perspective
This system is made with the perspective sales manager. This system helps manager to keep track of purchase and sales of stock . also this system allows customer to buy product online. This system is easy to use and is more efficient than manual one.
2.2 Functions
This system provides following functions:
1.Purchase – Purchase allows manager or one to add a new item they purchased and they can also add quantities of existing items.
2.Sales – Sales manager can create a bill and also view the previous records.
3.Inventory – It can be used to view the existing and changes can be also applied to them.
4.Contact – It can be used by owner to keep record and manage contacts of customer and supplier.
2.3 Software requirements
1.Eclipse
2.MySQL for database management
3.Tomcat Server
CHAPTER 3: FUNCTIONAL REQUIREMENTS
Functional requirements include minimum task that system must be capable of performing.
3.1 Initial setup
Admin will have to setup a database for keeping track of purchase and sales of stock, contact and registration details of customers and supplier.
3.2 Home page
The Home Page contains the following tabs like Purchase, Sales, Inventory, Contact, Logout and different user can have access of particular functions only. By clicking on one of them will allow user to complete one of the task outlined below.
3.3 Inventory
Inventory provides the stock of any particular product at any time and it gets updated on selling or purchasing an item from the customer or dealer respectively. If by mistake entered the wrong details we can also update the inventory details of any product. For purchasing we have provided an ADD option in tab of every shoes where we can add the quantity of any product and also we can change the profit percentage by UPDATE function.
3.4 Purchase
In purchase we store the purchase details of products and dealer. Suppose we add a particular quantity in inventory section then that detail gets stored in the purchase database section and it thus keeps a record of our purchases.
3.5 Sales
In sales we can create a new bill by giving a dropdown menu at every product in which a salesman can enter a particular quantity upto the available quantity as shown in the inventory and the sale is made. We can view the previous sales detail in the sales bill part and can check the sale detail at any time.
CHAPTER 4:PRELIMINARY DIAGRAM
Preliminary diagram involves use-case diagram which is as shown below:
Figure 4.1 Use-Case Diagram
CHAPTER 5:IMPLEMENTATION
5.1 Database creation
MYSQL has been used for database creation. The database includes following tables and their fields:
1.Contact Details
a.Name
b.Contact Number
c.Address
d.ID number
2.Sign-up Page
a.Username
b.Password
c.Role
3.Product Details
a.Product ID
b.Product Brand
c.Product Name
d.Purchase Price
e.Quantity
f.Supplier ID
4.Sales Details
a.Sale Price
b.Sale quantity
5.2 Implementation of various pages in JSP
Various pages like admin_home, client_home, sales_home, manager_home, new_product, supplier pages are implemented in jsp and java code is also included in jsp by using scripting elements in jsp the design of pages is done using CSS and html.
Admin_home:
It is the home page and it has navigation of all pages and using implicit of object of session available in jsp the authentication of admin is done.
New_product:
This page can only be accessed by Admin. With the help of this page Admin can add new products from the list of available suppliers and can set the profit percentage for that product.
New_supplier:
This page can be accessed by admin and manage and they can enter the details of any new supplier added and can also view the data of the suppliers which they had already entered.
Purchase:
This page can store the database of the purchases made from every supplier of every products.
Sales:
This page can be used to create a new bill and is also used to store the database of already sold products.
Inventory:
We can store the stock of our shop in this inventory and it gets updated on every purchase we have made or sales done.
5.3 Database connection using JDBC
In order to connect the database to the application, Java provides Java Database Connection Drivers. The package java.sql has been imported in order to access the classes present in it for connecting the database. The class used for connection has been named as Database Connection wherein an object of Statement interface ‘stmt’ and an object of Connection interface ‘con’ have been made. First, the class associated with the URL is retrieved using the forname(String URL) method of the class ‘Class’. Thereafter, the method getConnection(String URL, String root, String password) of class DriverManager has been called which, on establishing connection, returns it to con. A statement is created by the createStatement() method called by con and the resultant statement object is return to stmt. Two methods, getCon() and getStmt() are created which return con and stmt respectively. The method queryDatabase() is used for executing the queries which returns a ResultSet object while updateDatabase(), as the name suggests, updates the database.
CHAPTER 6:Online Portal Pages
6.1 Login Page
Figure 6.1 Login Page
The Login page constitutes of two text field with labels Username and Password wherein the user has to enter the username and password respectively. On entering the details, the user will have to click on the Login button. New user can Sign Up using the link provided below login dialog box.Also the Username and Password are differentiated according to the title of the person i.e Manager,Owner,Employee etc.
6.2 Registration Page
Figure 6.2 Sign-Up Page
New users can register with the help of this page. For successful registration they have to provide above mentioned details like their Name, Username, Phone Number, Email Id and password and these details gets stored in the database and one can register as customer, manager or as a salesman.
6.3 Home Page(DashBoard)
Figure 6.3 Home Page
This is how the first page of our Inventory Management System will look like.This will be seen only after we Log In properly with the correct username and password.Also you can pick up any option from the dashboard panel which you see in the image and you will be directed to that particular page.Each option in this page has a respective drop-down list which gives you various options.Let’s say for example you select the Contact drop-down list,over here you will have the options like Supplier,Consumer etc.
6.4 Product Details
Figure 6.4 Product Details
This page shows the list of all products with their product ID, purchase and selling price, quantity and id of supplier from whom product is brought. Also this page provides a lot of options like updating and adding the quantity of an existing product. We also have the option of adding a new product altogether as seen in the picture,there is a ‘New Product’ button on the top-left which is used for the same.
6.5 Adding New Product
Figure 6.5 Adding New Product
This page allows the owner to add new product,i.e. the product which he bought from the supplier. He can add new product by entering details of new product which includes supplier ID, product brand, name, purchase price, quantity, and profit percentage which he wants to earn. by clicking submit button new product is added to the store.
6.6 Supplier Details
Figure 6.6 Supplier Details
This page shows the details of the supplier from which owner has bought one or more products. You can also add new supplier by clicking the ‘ New supplier ‘ button. Owner can also update information of Supplier by clicking on the Update link. He can also delete the existing Supplier by clicking delete button.
CHAPTER 7: CONCLUSION
First of all,we made a Use-Case diagram regarding the different types of entities that are required for our project i.e Product,Inventory,Contacts etc. We also discuss our project’s functional requirements, the design process and its successful implementation.Our system is designed to reduce human labor and efficiently manage the stock.
After completing this project we acquired good knowledge about using JSP(Java Server Pages) for project development and also the use of JDBC and a little bit about MySQL server i.e database management.
REFERENCES:
1. https://www.tutorialspoint.com/jsp/index.htm
2. https://www.javatpoint.com/jsp-tutorial
3. https://www.w3schools.com