IMS Wiki Page03.05.2012

7/29/2019 IMS Wiki Page03.05.2012

1/13

IMS

1

Department of Computer Science University of Jaffna

Project wiki pages

Group- 04

Submitted in partial 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 02/05/2012

7/29/2019 IMS Wiki Page03.05.2012

2/13

IMS

2


Introduction page

Our project is Inventory Management System. Our project was prepared for ourComputer science department. This system maintains the details of latest

equipments, 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.

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.

Developer page

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 createdatabase as the back end for this system.

7/29/2019 IMS Wiki Page03.05.2012

3/13

IMS

3


Tables

Our database contain eleven tables for our system.

Users:

This table consist 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 consist some attributes such as Articles, Identification number, folio

number, name of supplier, date, unit price, officer in charge and remarks. le table

helps to lab equipments details, . oe table helps to office equipments details and .

fu table helps to furniture details.

Consumable (cons), Stationary (sta), Maintenance (mai):

This table consist some attributes such as id, item, number, action, date and

balance. Cons table helps to consumable details, sta table helps to stationary details

and mai table helps to maintenance details.

Loan issue:

This table consist 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 consist 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 consist some attributes such as id number, article, reason, date and

authorized by. These details help to remove, view and show the individual articles.

7/29/2019 IMS Wiki Page03.05.2012

4/13

IMS

4


User Page

This is our login page, this helps to login our system.

This is our sign up interface , this helps to create a new account.

7/29/2019 IMS Wiki Page03.05.2012

5/13

IMS

5


This is our about us interface , It helps to know our system.

This is our main interface,

7/29/2019 IMS Wiki Page03.05.2012

6/13

IMS

6


This is our change password interface, it helps to change the password.

This is our add inventory interface.

7/29/2019 IMS Wiki Page03.05.2012

7/13

IMS

7


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.

This is our consumable interface, it helps to add the new equipment details to the database table.

Other interfaces maintenance and stationary do the same work.

7/29/2019 IMS Wiki Page03.05.2012

8/13

IMS

8


This is our Inventory search interface. It contains main equipment search and other

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/29/2019 IMS Wiki Page03.05.2012

9/13

IMS

9


This is our view all interface. It shows all details of main equipment and otherequipment.

This is our other equipment search interface. If we select category and article, we

can see the full details of that item.

7/29/2019 IMS Wiki Page03.05.2012

10/13

IMS

10


This is our Loan interface. It contains loan issue and loan taken.

This is our loan issue interface. It helps to add, edit and view the details

.

7/29/2019 IMS Wiki Page03.05.2012

11/13

IMS

11


This is our loan taken interface. It helps to add, edit and view the details.

This is our user management interface. It helps to edit, delete, view and add user.

7/29/2019 IMS Wiki Page03.05.2012

12/13

IMS

12


This is our remove inventory interface. It helps to remove the item and show theindividual item.

7/29/2019 IMS Wiki Page03.05.2012

13/13

IMS

13


Contact page

This project done by group4. Our group contains three members:

Mr. Yogarajah Kesavan 2009/SP/014

Mr.Maheswaran Nitharsan 2009/SP/042

Miss. Jeyapratheepa Jeyanantharajah 2009/CSC/009

Blog : www.inventorymanagementsystemims.blogspot.com

Email :[email protected]
http://www.inventorymanagementsystemims.blogspot.com/http://www.inventorymanagementsystemims.blogspot.com/mailto:[email protected]:[email protected]:[email protected]:[email protected]://www.inventorymanagementsystemims.blogspot.com/

IMS Wiki Page03.05.2012

Documents

Transcript of IMS Wiki Page03.05.2012