inventory management system wiki page 08.02.2013
TRANSCRIPT
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
1/34
IMS
1
Department of Computer Science University of Jaffna
Project wiki pages
Group- 04
Submitted in fulfillment of the requirements of
CSC301GC2 Project
Advisor - Mr. K. Sarveswaran
Members -
Yogarajah Kesavan 2009/SP/014
Maheswaran Nitharsan 2009/SP/042
Jeyapratheepa Jeyanantharajah 2009/CSc/009
Date 08/02/2013
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
2/34
IMS
2
Department of Computer Science University of Jaffna
Introduction page
Introduction
Inventory Management System was developed for anyone who needs a simple and
easy way to keep track of their inventory.
Inventory is basically the total amount of goods and materials held in stock by a
factory, store and other business. An inventory system is a process whereby a
business keeps track of the goods and material it has available. Todays
competitive environment is forcing companies to optimize the procurementprocesses and inventory levels while at the same time ensure accuracy of controls
and implementation of standard procedures for the flow of materials. However, in
the absence of appropriate systems and information infrastructure, companies are
finding it difficult to achieve smooth and efficient.
Nowadays each and every organization has a computerized system. These systems
must be secure, efficient, and also economical. So, in this project we are trying to
make inventory management system which will help employees to keep records in
a systematic way, provide easy recovery of errors, have an overall end user highsubjective satisfaction, produce report about the inventory and stock currently
available in the department in automatic way and help them in decision making.
From this application only the administrative level staff can read, insert, update
and delete a record or details of inventory and users. Other staff only view the
information about inventory.
Our project is Inventory Management System. Our project was prepared for our
Computer science department. This system maintains the details of latestequipments, details of equipment use in lab, discard and repair equipment details
and loan details. When new equipment enters our lab, we check that equipment is
main (lab, office, furniture) equipments or other (consumable, stationary,
maintenance) equipments.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
3/34
IMS
3
Department of Computer Science University of Jaffna
If that equipment is main, when we select that equipment in our system,
automatically fill new identification number, new folio number and date. If that
equipment is other, when we select that equipment and then select issued,
automatically fill the increased balance or we select received, automatically fill the
decreased balance in our system.
We can search main and other equipments. If we search main equipment, we can
see these (Articles, Identification number, folio number, name of supplier, date,
unit price, officer in charge and remarks) details. If search other equipment, we can
see these (article, date, quality, balance, action) details. We maintain two kinds of
loan details those are loan issue and loan taken. We can add and edit details in both
categories. We can see these (articles, identification number, status, return date,
department) details in both categories.
Features
We can divide the inventory into two main categories.
1. Main equipmentThere are three categories of property that will be recorded, each with a life
expectancy of more than two years which have the unique inventory
identification no.
a. Office equipment.b. Lab equipment.c. Furniture.
When we adding main equipment system will automatically generates the
identification no.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
4/34
IMS
4
Department of Computer Science University of Jaffna
2. Other equipmentThere are three categories of property that will be recorded, each with a life
expectancy of less than two years.
a. Stationary.b. Maintenance.c. Consumables.
When we adding or issuing the other equipment, system will automatically
generates the balance. So it reduces the unexpected shortages of critical
items and unnecessary purchases (orders) of items already on hand.
Managing obtained Loan detail
The one department can issue an item to another department by a loan, this
process is called loan issued.
Also one department can received an item from another department, this
process is called loan taken.
This system provides easy way to keep track of the inventory loan details.
So it reduces the undetected theft or loss.
Managing the details of Removed Item
When a department has property it wants to remove (as either scrap or
surplus), the Unserviceable Articles form must be completed by the data
entry officer and forwarded to the administration branch.
Serviceable & should be sold.
Unserviceable & should be destroyed.
Repairable & should be preserved.
The data entry officer can remove the item when he received the
approval of removal from technical evaluation committee.
This system provides easy way to keep track of the remove inventory details.
So it reduces the hazardous working condition to appropriate personnel and
easy to identifying surplus or underutilized items and for reporting items that
require repair.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
5/34
IMS
5
Department of Computer Science University of Jaffna
User Authentication
The system will provide functionality to allow the user to log in to the
system with a username and password. It is implemented as a very securesystem to control unauthorized access through encrypted password. Only the
Data entry officer can insert, edit and delete inventory and user details.Our
system use CAPTCHA to check if the person registering is a real live human
being as opposed to a computer program attempting to spam the site.
Our system facilitates the search through different type of queries. So it is
easy to identify inventory through id no or type.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
6/34
IMS
6
Department of Computer Science University of Jaffna
Developer page
Technologies
This project has been designed by using the CSS templates. This is help to design
our interfaces and also help Adobe Dreamweaver CS5.5 and HTML 5. PHP have
been used to develop the coding in our system. SQL server is used to create
database as the back end for this system.
Tables
Our database contains eleven tables for our system.
Users :
This table consists of some attributes such as user id, first name, last name, email,
username, password and user level. These details help to create an account and
login the system.
Lab equipments (le), Office equipments (oe), Furniture (fu) :
This table consists of some attributes such as Articles, Identification number, folio
number, name of supplier, date, unit price, officer in charge and remarks. le tableuses to lab equipments details, . oe table uses to office equipments details and . fu
table uses to furniture details.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
7/34
IMS
7
Department of Computer Science University of Jaffna
Consumable (cons), Stationary (sta), Maintenance (mai) :
This table consists of some attributes such as id, item, number, action, date and
balance. Cons table uses to consumable details, sta table uses to stationary details
and mai table uses to maintenance details.
Loan issue :
This table consists of some attributes such as loan id, article, id, issued date, issued
by, received by, received department, status, return date and remarks. This table
helps to add, edit and show the issued items.
Loan taken :
This table consists of some attributes such as loan id, article, id, issued department,
received date, received by, status, return date and remarks. This table helps to add,
edit and show the taken items.
Remove :
This table consists of some attributes such as id number, article, reason, date and
authorized by. These details help to remove, view and show the individual articles.
Current Status :
This table consists of some attributes such as id number, status( in, issued,
removed ) and location. These details help to track the current status and locationof the equipments.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
8/34
IMS
8
Department of Computer Science University of Jaffna
User Page
Software Requirements
o Apache
o MySQL
o PHP 5.3
Installation
Install XAMPP
Access your phpMyAdmin web interface from XAMPP
Place all the documents into the XAMPP "htdocs" folder(e.g. c:/xampp/htdocs/)
Create a database called ims
Select this database then click Import Browse to /ims.sql/ and click Go
The database is now set up
Edit the file config.php - This file contains your database login informationand location.Edit these two lines to contain your database login andpassword
$user = "root";
$password ="";
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
9/34
IMS
9
Department of Computer Science University of Jaffna
Interfaces
Login :
This is our login page, this helps to login our system.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
10/34
IMS
10
Department of Computer Science University of Jaffna
Sign Up :
This is our sign up interface , this helps to create a new account.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
11/34
IMS
11
Department of Computer Science University of Jaffna
About us :
This is our about us interface , It helps to know our system.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
12/34
IMS
12
Department of Computer Science University of Jaffna
Main :This is our main interface,
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
13/34
IMS
13
Department of Computer Science University of Jaffna
Change Password :
This is our change password interface, it helps to change the password.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
14/34
IMS
14
Department of Computer Science University of Jaffna
Add Inventory :
This is our add inventory interface.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
15/34
IMS
15
Department of Computer Science University of Jaffna
Main Equipment :
This is our Lab equipment interface, it helps to add the new equipment details to
the database table. Other interfaces office equipment and furniture do the same
work.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
16/34
IMS
16
Department of Computer Science University of Jaffna
Other Equipment :
This is our consumable interface, it helps to add the new equipment details to thedatabase table. Other interfaces maintenance and stationary do the same work.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
17/34
IMS
17
Department of Computer Science University of Jaffna
Inventory Search :
This is our Inventory search interface. It contains main equipment search and other
equipment search.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
18/34
IMS
18
Department of Computer Science University of Jaffna
Main Equipment Search :
This is our main equipment search interface. If we select category andidentification number, we can see the full details of that item.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
19/34
IMS
19
Department of Computer Science University of Jaffna
Main Equipment Update :
This is our main equipment update interface. Administrator can update the detailsof main equipments.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
20/34
IMS
20
Department of Computer Science University of Jaffna
Main Equipment view all :
This is our main equipment view all interface. It shows all details of main
equipment.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
21/34
IMS
21
Department of Computer Science University of Jaffna
Main Equipment print :
This is our main equipment print interface. Administrator can print the search
results.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
22/34
IMS
22
Department of Computer Science University of Jaffna
Other Equipment Search :
This is our other equipment search interface. If we select category and article, we
can see the full details of that item.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
23/34
IMS
23
Department of Computer Science University of Jaffna
Other Equipment view all :
This is our other equipment view all interface. It shows all details of other
equipment.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
24/34
IMS
24
Department of Computer Science University of Jaffna
Other Equipment print :
This is our other equipment print interface. Administrator can print the search
results.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
25/34
IMS
25
Department of Computer Science University of Jaffna
Loan :This is our Loan interface. It contains loan issue and loan taken.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
26/34
IMS
26
Department of Computer Science University of Jaffna
Loan Issue:
This is our loan issue interface. It helps to add, edit and view the details.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
27/34
IMS
27
Department of Computer Science University of Jaffna
Loan Issue update:
This is our loan issue update interface. Administrator can update the details of loanissue.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
28/34
IMS
28
Department of Computer Science University of Jaffna
Loan Taken :
This is our loan taken interface. It helps to add, edit and view the details.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
29/34
IMS
29
Department of Computer Science University of Jaffna
Loan Taken update:
This is our loan taken update interface. Administrator can update the details of loantaken.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
30/34
IMS
30
Department of Computer Science University of Jaffna
User Management :
This is our user management interface. It helps to edit, delete, view and add user.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
31/34
IMS
31
Department of Computer Science University of Jaffna
User Management update :
This is our user management update interface. Administrator can add the users andupdate the users privilege.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
32/34
IMS
32
Department of Computer Science University of Jaffna
Remove Inventory :
This is our remove inventory interface. It helps to remove the item and show the
individual item.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
33/34
IMS
33
Department of Computer Science University of Jaffna
Remove Inventory added :
This is our remove inventory added interface. It helps to remove the item.
-
7/30/2019 Inventory Management System Wiki Page 08.02.2013
34/34
IMS
Contact page
Contact Details
The project entitled Inventory Management System is submitted fulfillment of
Course unit CSC301GC2 in Computer Science for the Degree of Bachelor of
Science, 2011 at the University of Jaffna by group-4.
Our project advisor :
Mr. K. Sarveswaran ( [email protected] )
Our group contains three members :
Mr. Yogarajah Kesavan ( [email protected] ) 2009/SP/014
Mr.Maheswaran Nitharsan ( [email protected] ) 2009/SP/042
Miss. Jeyapratheepa Jeyanantharajah ([email protected] ) 2009/CSC/009
Blog : www.inventorymanagementsystemims.blogspot.com
Email :[email protected]
Google code : https://code.google.com/p/inventory-management-
system-ims/
Thank you
http://www.inventorymanagementsystemims.blogspot.com/http://www.inventorymanagementsystemims.blogspot.com/mailto:[email protected]:[email protected]:[email protected]:[email protected]://www.inventorymanagementsystemims.blogspot.com/