Quick Response Code for Inventory System Development (Case study: Accounting Unit At Ujung Pandang State Polytechnic)

-QR stands for Quick Response, which is in accordance with its purpose is to convey information quickly and get a fast response as well. In contrast to barcodes which are only able to store information horizontally, QR codes are able to store information both horizontally and vertically. Therefore, that automatically QR codes have the ability to store more data than barcodes. QR codes can be used in the inventory system at the State Polytechnic of Ujung Padang to make it easier to read inventory data. In this study, the author will create an inventory system using a QR Code. The inventory system will be made online so that it can make it easier for admins and staff to process data and present information. This system is made in PHP and uses MySQL database for data storage, while the QR code is created using the Ciqrcode library. While in reading the QR code on the android application using the Zxing library. The inventory system built can make it easier to process inventory data and present information to the Accounting Unit at State Polytechnic of Ujung Padang.


I. Introduction
Information technology has a huge influence on human life in almost every area of life. One technology that is quite well known is the QR code. QR is an abbreviation of Quick Response, which is in accordance with its purpose is to convey information quickly and get a fast response [1]. In contrast to barcodes which are only able to store information horizontally, QR codes are able to store information both horizontally and vertically. So that automatically QR codes have the ability to store data larger than barcodes [2]. In addition, QR codes also have a smaller size than barcodes and are resistant to damage, even though some of the QR code symbols are dirty or damaged, the data can still be stored and read [3]. Therefore, QR codes are very suitable to be used as identification in inventory systems.
At the State Polytechnic of Ujung Pandang, the process of inventorying goods has been computerized with the SIMAK-BMN application (Sistem Informasi Manajemen dan Akuntansi Barang Milik Negara). This system helps in the search process, storing data files that become the inventory of the Ujung Pandang State Polytechnic. But sometimes it is still found that the goods were moved without any notification to the inventory admin, so that the inventory recording was not in accordance with the existing conditions [4].
The above problems are overcome by creating an information system that aims to improve performance in the inventory data processing process. This information system is made based on a QR code by utilizing the QR droid application as a scanner. However, until now, this system has never been applied to the Accounting Unit of the State Polytechnic of Ujung Pandang. The weakness of this system is that there is no facility to add large amounts of data at once, so that the input of inventory items is still done manually by inputting item data one by one. In addition, the QR code used only stores information in the form of a link to the localhost database or server, so that if there is a change in the server address, the QR code created automatically cannot function properly.
In this research, a system will be created that can input large amounts of inventory data by setting up import facilities for the application to be made. This system can be used by admins and staff to add data, view data, update data and delete data. In addition, the creation of a QR code using an application that can be adjusted as needed and makes it easier to view item information. This system is expected to be applied to the Accounting Unit of the Ujung Pandang State Polytechnic so that it can make it easier to carry out an inventory.

A. Inventory
Inventory is the activity of carrying out the management, administration, regulation, recording and registration of inventory/property goods [5]. Inventory aims to provide identification for all facilities in the industry. The inventory made must contain clear and easy to understand information quickly, so that it can help smooth the work.

B. Quick Response Code
QR code is an image in the form of a twodimensional matrix that has the ability to store data in it [6]. QR code is an evolution of barcode (bar code). QR Code stands for Quick Response Code, or can be translated into a quick response code. In contrast to barcodes which only store information horizontally, QR codes are able to store information horizontally and vertically, therefore automatically QR codes can accommodate more information than barcodes [2]. In addition, QR codes no longer require special devices because they only use the camera to read them [1].

C. Web Server
Website or site can be defined as a collection of pages that display text data information, still or motion image data, animation data, sound, video and or a combination of all of them, both static and dynamic which form a series of interrelated buildings where each linked to a network of pages (Hyperlink) [6]. Static if the information content of the website remains constant, rarely changes, and the information content is in the same direction only from the website owner. It is dynamic if the information content of the website is always changing, and the information content is interactive in two directions from the website owner and users [6].

1) PHP (Hypertext Preprocessor)
PHP is the most widely used script programming language today. PHP is widely used for programming dynamic websites, although it is possible to use it for other uses [7]. PHP (an acronym for PHP: Hypertext Preprocessor) is a programming language that functions to create dynamic websites and web applications that interact with databases, files and folders so that PHP can display dynamic content from a website [8].

2) HTML (Hyper Text Markup Language)
HTML is the original language of www, which has become the standard language for displaying data on the internet. The development of html is very rapid, currently the latest version of html has reached html 5 [9].

3) CSS (Cascading Style Sheets)
CSS is a stylesheet language that is used to set the appearance of a document written in a markup language [11]. The most common use of CSS is to format web pages written with HTML, XML, and XHTML [9].

E. MySQL
MySQL is a SQL database management system software or DBMS that is multithreaded, multi-user, with about 6 million installations worldwide. MySQL is a Relational Database Management System (RDBMS) which is distributed free of charge under the GPL (General Public License). Where everyone is free to use MySQL, but it should not be used as a commercial derivative product. MySQL is actually a derivative of one of the main concepts in databases for a long time, namely SQL (Structured Query Language) [7].
MySQL is a database server program that is capable of receiving and sending data very quickly, multi-user and using SQL (Structured Query Language) basic commands [10].

F. Android
Android is a Linux-based mobile device operating system that includes an operating system, middleware and applications. Android provides an open platform for developers to create their applications [11]. Android is the first mobile platform that is complete, open, and free [12]. Complete (Complete Platform) means developers can take a comprehensive approach when they are developing the android platform. Open (Open Source Platform) means the android platform is licensed Open Source so that developers can freely develop applications. While free (Free), that is, there are no licenses or royalty fees for the development of the Android platform, no membership fees are required, Android applications can be distributed and traded in any form.

G. Black Box Testing
Black box is a test that is focused on functional requirements or the correctness of input and output resulting from the software being built [13]. Black box testing will be done by giving input from the user to the system that is already running and observing the output of the system.

II. Research methods
The research method is needed so that this research can be structured so that the results obtained are in accordance with the objectives of the research. The stages of this research procedure can be seen in Figure 2.

A. Data collection
At this stage, observations were made on the data studied by conducting interviews with staff related to the creation of an inventory system and looking for literature studies related to the problems studied.

B. Need Analysis
This analysis aims to find out what kind of system is suitable to be applied. Appropriate hardware and software, and who will be using the system.

1) Hardware
The hardware needed to create the "Inventory System using QR code" application is a laptop and a smartphone. The minimum requirements for the required equipment can be seen in Table 1 and Table 2 below.  2) Software The software needed in working on this system can be seen in the following table. 3) Brainware Those who will be users of the "Inventory System using QR Code" application are the room attendant, staff and head of the Ujung Pandang State Polytechnic Accounting Unit.

1) Diagram Use Case
The use case diagram describes an interaction between one or more actors and the system to be created. Use case diagrams are used to find out what functions exist in a system and who has the right to use these functions. Figure 3 explains the use case diagram in the system to be built. 2) Entity Relationship diagram ERD data model (Entity relationship diagram) is a diagram that describes the relationship between data objects [14]. The design of the ERD on the inventory system can be seen in Figure 4.

D. Testing Step
Tests are carried out to check whether a system that has been produced can be run in accordance with the purpose of system design. System testing is the most important thing that aims to find errors or deficiencies in the system that has been built. The testing technique used in this study is black box testing.

E. Data collection technique
The research data is sourced from the test results which will later be analyzed as research results.

III. Results and Discussion
The system built in this study consists of 2 main parts, namely a web-based system and an android application. a web-based inventory system is used by users to process inventory data while the android application is used to read data on the QR code contained in inventory items. The following are the results of tests carried out on a web-based inventory system and android application. Adding room item data with the import data button on the list page room items on the inventory module.

A. Inventory Web
The system will add item data according to the data entered The system will add item data according to the data entered Success 5 Downloading room item data with the export data button on the room item list page on the inventory module The system will download the room item data in excel file format The system will download the room item data in excel file format success Result :   Pressing the scan QR code button on the home page.
The system will scan the QR code on the inventory item.
The system will scan the QR code on the inventory item.
success Result : Figure 10. Scan QR code page 3 Press the scan QR code button.
The aplicatation scans the QR code and displays item data on the datascan page.
The aplicatation scans the QR code and displays item data on the datascan page.

Success
Result : Figure 11. Data scan page

IV. Conclusion
After designing to testing, the following conclusions are obtained.
1. The inventory system using a quick response code can be completed properly. This can be seen from the test with a success rate of 100%.
2. The application can integrate the QR code found on the inventory item label with the inventory module. This can be seen from the test with a 100% success rate.