Journal of Electrical Engineering and Computer Sciences Vol.
No.
June 2018
ISSN : 2528 - 0260
INVENTORY MANAGEMENT SYSTEM USING QR CODE ON
ANDROID A CASE STUDY IN COMPUTER ENGINEERING
DEPARTMENT
1RENZA ILHAMI RIZQI, 2NURUL AZIZAH ROHMA 3DR.
KITTIWAN NIMKERDPHOL
Department of Computer Engineering.
Faculty of Engineering.
Rajamangala University of Technology Thanyaburi 39 Moo 1 Rangsit-Nakhonnayok Rd Thanyaburi Amphoe Khlong Luang.
Chang Wat Pathum Thani 12110 Informatics Department.
Faculty of Engineering.
Bhayangkara Surabaya University E-Mail : 1ilhamirisqi@gmail.
com, 2nurulazizahrohmah2903@gmail.
com, 3kittiwan.
n@en.
ABSTRACT
Inventory management is the practice overseeing and controlling of the ordering, storage and use of components that a company uses in the production of the items it sells.
Inventory management has been used as a decision-making in countless firms and has been extensively studied in the academic and corporate spheres.
The purposes of inventory system are to know the details of the items including code, name, condition, location of items and the year of It is also to make easy for manage the item.
Usually, creating inventory list can be done two ways either manually or computerized.
Manually inventorying is usually written data with handwriting on the data books.
It has many disadvantages.
One of them is when the admin staff input the data, it is prone to be typographical errors.
Here in the Computer Engineering Department in Rajamangala University of Technology Thanyaburi (RMUTT) the inventory management still using manual process for inventorying and collect the data of an item.
This inventory management system will help the process inventorying using web-based application and also mobile application for collecting data information.
Quick Response (QR) Code technology as a unique tagging solution for each item that store information from the server through the local network.
The implementation of this system for Inventory Management System could be a solution for manage inventorying process and stored information of inventory through QR Code.
Keywords: Inventory.
Management.
QR Code.
Web-based.
Mobile INTRODUCTION Inventory management is the practice overseeing and controlling of the ordering, storage and use of components that a company uses in the production of the items it sells.
Inventory management has been used as a decision-making in countless firms and has been extensively studied in the academic and corporate spheres.
The purposes of inventory system are to know the details of the items including code, name, condition, location of items and the year of It is also to make easy for manage the item.
Usually, creating inventory list can be done two ways either manually or computerized.
Manually inventorying is usually written data with handwriting on the data books.
It has many disadvantages.
One of them is when the admin staff input the data, it is prone to be typographical errors.
A number of institutes and companies are moving from manually collecting and processing data to a computerize Computerize system has many options.
Word processing or spreadsheet program .
Microsoft OfficeA) can be utilized to do the task but it has disadvantages.
Manually entering data into the spreadsheet can take a very long time especially if users have a lot of data to enter.
It is also possible to view or edit the important data which should not be shown.
This is very adverse for the institutes or companies.
DOI: https://doi.
org/10.
54732/jeecs.
Available online at: https://ejournal.
id/index.
php/jeecs Journal of Electrical Engineering and Computer Sciences Vol.
No.
June 2018
ISSN : 2528 - 0260
This project aims to develop a web based application and mobile application to collect and process inventory data for Computer Engineering Department.
Rajamangala University of Technology Thanyaburi (RMUTT).
Thailand.
Quick Response (QR) code will be used to encode the inventory ID and other related information in order to give general information of the particular item where the mobile application can display either online or offline.
Inventory management will be done on web based application where an authorized staff can handle the inventory lists along with QR Code.
DESIGN AND IMPLEMENTATION
Use Case Flowchart Figure 2.
Flowchart for Admin Staff Journal of Electrical Engineering and Computer Sciences Vol.
No.
June 2018
ISSN : 2528 - 0260
Admin Staff can login in the login page.
If admin staff success login, they will go to add user page.
Admin staff can add user and edit user.
If admin staff has finished, admin staff can log out from page.
START
LOGIN
SUCCESS?
YES
SHOW PROFILE
USER
SCAN QR CODE
SHOW ITEM ID
GET DETAIL?
YES
SHOW ITEM
INFO
FOUND NEW
LOCATION?
YES
REQUEST NEW
ITEM LOCATION
LOGOUT
END
Figure 3.
Flowchart for Department Staff (Onlin.
Department staff can inform new location, but they must login first.
If the login success, they can see their profile user.
Then, they can scan QR Code again until item ID show in page.
If Department staff wants to inform new location, they must go to get detail and the item info will be show.
They can request new item location.
After they have finished what they do, they can logout from the page.
Journal of Electrical Engineering and Computer Sciences Vol.
No.
June 2018
ISSN : 2528 - 0260
Figure 4.
Flowchart for Department Staff (Offlin.
This part for department staff who wants to scan QR Code.
They can scan QR Code and the item info will be The item info has not more detail of item.
Because they used offline.
Figure 5.
Flowchart for Inventory Staff Inventory staff must login first to go to web page.
After that, they can choose what they want to do.
If they want to know new notification, they can go to main page.
If they want to register new item, they can go to register item page.
If they done, they can logout from web page.
Journal of Electrical Engineering and Computer Sciences Vol.
No.
June 2018
TESTING AND RESULT
Functional Testing Result in Website ISSN : 2528 - 0260 Figure 7.
Admin Main Page This is a admin page.
In main page, admin staff can edit user profile and delete user.
In the add user account, admin staff can add new user.
Figure 8.
Inventory Main Page This is inventory page.
There are five menus in there.
In the main page, inventory staff will be know the new notification from mobile application.
They can accept or reject the new location that department staff has founded.
In the search page, inventory staff can search the item.
If inventory staff wants to see the report, they can go to report page.
And if they want to setting configuration, they can go to configuration page.
Journal of Electrical Engineering and Computer Sciences Vol.
No.
June 2018
ISSN : 2528 - 0260
Functional Testing Result in Mobile Figure 9.
Home Scanner This is home scanner in the android application.
If the department staff wants to scan, they can click scan button.
Sometimes, if the department staff found the new location of item, they can click login button.
They can login as usually, enter their email and password.
After that, they can scan again, get more detail of item and they also inform new location in mobile application.
Figure 10.
Scanner Reader When department staff click scan button, they will go to scanner reader.
Point the scanner reader to theQR Code After that, scanner reader will read QR Code and convert the data to be a text in the item info.
Journal of Electrical Engineering and Computer Sciences Vol.
No.
June 2018
ISSN : 2528 - 0260
CONCLUSION
Based on the results of research and discussion that already done, it can be concluded that:
Inventory Management System using QR Code on Android has been applied on Computer Engineering in Rajamangala University of Technology Thanyaburi was running well, where the results of testing the function of entity goes well.
Real-time reading QR Code through android successfully applied in this research.
The development of cloud computing-based applications has not run well because it only runs locally .
ocal web serve.
, but the use of web service has been applied in this research.
Based on the results of functional testing can be seen whether the program is in accordance with the procedure of Inventorying Management by the user.
User negligence in 11 events including Web and Android Applications.
From the above test results can be stated.
ACKNOWLEDGE
We would like to take this opportunity to acknowledge and thank those who made this work possible.
First of all, we would like to thankful to the God because without His bounty, this project will never be done.
Was made as one of the requirement to obtain a bachelorAos degree in Department of Informatics Engineering.
Faculty of Engineering.
Bhayangkara University Surabaya.
We also would like to extend our utmost gratitude to our advisors.
Dr.
Kittiwann Nimkerdphol.
Department of Computer Engineering at Rajamangala University of Technology Thanyaburi, whose sincerity and encouragement we will never forget and we also would like to express our sincerest appreciation to our mother, our father, our brother and sister and everyone that took place in our project.
The author realizes that this project has not been perfect, both in term of material and presentation.
For that advice and constructive is criticism is expected in the completion of this project.
The author hope that this project can give benefits and insight to the reader, and especially for the writer too.
REFERENCES