SUGISAKAMASANORI

Journal of Advances in Artificial Life Robotics
Vol. 3(2); September (2022), pp. 77–80
ON LINE ISSN 2435-8061; ISSN-L 2435-8061
https://alife-r79obotics.org/jallr.html

Research Article

A system designed for inventory management
Yiting Gao, Peng Lu
Tianjin University of Science and Technology, Tianjin, China

ARTICLE INFO
Article History
Received 22 November 2021
Accepted 13 September 2022
Keywords
ERP
B\S
Management system
AutonomousABSTRACT
Most of the enterprises in the economic development .at the same time, his production pressureis heavy, inventory management has become particularly important. In response to this change,
we aim to move away from traditional manual management, which leads to inefficient supplies.
Material Management and data acquisition issues. Inventory requirements in the enterprise havebeen unable to meet. Traditional inventory decision-making needs manual transmission, and wedesign the inventory management is a brand-new management method, it can be used as aplatform for managers to directly complete the communication operation. Makes it possible forpeople to implement tasks faster.
© 2022 The Author. Published by Sugisaka Masanori at ALife Robotics Corporation Ltd
This is an open access article distributed under the CC BY-NC 4.0 license(http://creativecommons.org/licenses/by-nc/4.0/).

1. Introduction
Through careful investigation of these situations, thefollowing warehouse inventory management system isdeveloped.

Due to the variety of items in the inventory, their ordering,management and distribution channels are different,
management systems are not the same, a variety ofstatistical statements for the inventory management
manual-free operation, to realize the computerized
operation of Management, an inventory management
information system must be prepared[1].
According to the current enterprise management system,
the general inventory management system is always
divided into several departments according to the masteredmaterial categories, which are respectively responsible forplanning, ordering, write off, delegated collection,acceptance and warehousing of materials.
At the same time, according to the needs of corporate
leadership and their own management, quarterly andannual statistical analysis after the generation of thecorresponding statements. To meet the needs of all
departments of the enterprise for the delivery of materials
and equipment, at any time for inventory and accounting.

2. Operating Environment
The system is modeled on the structure of layui. The front
end adopts bootstrap framework and the back end adopts
SSM framework to realize the function of front and backend. In addition, it also applies other related technologies,
such as Baidu echarts diagram. At the same time,a good
configuration environment is also required. Configuration
environment is shown in Table 1.
Table 1. configuration environment server

Corresponding author’s E-mail: 2801110578@qq.com URL: www.tust.edu.cn77

Server nameServerOperating system name
Back end server nameBack end server model

Window10
TomcatApache Tomcat/9.0.12

The database server is shown in Table 2, and othersoftwares are shown in Table 3.

and output to customers. The function layer is responsible
for establishing the connection to the database, generating
SQL statements to access the database according to theuser's request and returning the results to the client. The
data layer is responsible for the actual database storage andretrieval and responding to the data processing request ofthe function layer, And return the result to the functionlayer.
Overall architecture design is shown in Fig.1.

Table 2. configuration environment server
Database server type

Server

Database name

MySQL

Database version

Mysql/8.0.15

Table 3. configuration environment server
Other software type

ServerDevelopment platform

Myeclipse2015

Software name

Myeclipse

Software version number

Myeclipse5.0

3. Software Design
The importance of software architecture [2] is that it
determines the main structure, macro characteristics, basic
functions and characteristics of a system. For example, themain structure determines the success of the design, themacro-structure of the design is correct and rational todetermine the success of software design. Therefore, thesoftware architecture plays an important role in the wholesoftware design.

Fig.1. overall architecture design

3.3. System structure design
The structural design of the system is the main body of
the whole design. The system is mainly designed for theadministrator. It is divided into 9 modules: setting
module, transfer document module, disassembly
document module, count document module,
miscellaneous issue document module, miscellaneousreceipt document module, cost adjustment document
module, inventory history module and statistical analysis
module. The users in this program are inventory
managers, which has nothing to do with customers.
System structure design is shown in Fig.2.

3.1. System structure design
The following four parts are the structure of the wholesystem.
(1) The initial inventory quantity and price information
can only be entered into the system by the administrator(2) For logical operations, it can only be performed by
the administrator, such as transferring, changing numbers,encoding.
(3) The administrator can view the issue / receipt
documents and generate and print the documents
corresponding to the above operations.
(4) The inventory history can only be viewed by theadministrator, and the administrator can print out theinformation.
3.2. Architecture design

Fig.2. system structure design

The system adopts the system design style of browsing /server. The presentation layer is responsible for user input
78

4. Project Testing and Statistic
The purpose of the test is to find out the possible problems
in the system before the system goes online, check thesystem performance [3],[4], and test whether the network
request can be sent normally, whether the function can berealized stably and whether the operation is stable underthe condition of cross domain. The project test is shown inTable 4.
Table 4. Project test
Test unit

Function description

Issue / receipt
category

New，modify，delete issue / receipt
type
Manually enter (add), view and output(document) inventory goods
Add, modify, delete, query and output
transfer documents
Add, modify, delete, query and output
transfer documents
Add, modify, delete, query and output
transfer documents

openinginventory
Transfer order
Disassemblyorder
Inventory sheet
Miscellaneous
issue doc
Miscellaneousreceipt doc

test result
success
success
success
success
successQuery and output issue doc

success

Query and output issue doc

success

Fig.3.Statistical analysis

Transfer doc operation generation record

5. Conclusion
success

Inventory history

Disassembly order operation generation
recordsuccess

Count sheet operation generation record

success

Dream cloud ERP system based on Java-inventory
management subsystem v10. It is used in the managementof inventory software, can be widely used in enterprises.
Its features can do most of the work. When applied to an
enterprise, the inventory management function of the workof an administrator can be replaced. such as inventory
setting[5], opening inventory, transfer doc, disassemblydoc, count doc, other receipt doc and other issue doc, In
addition, there are functions such as inventory history andstatistical analysis. The software interface is clean andsimple to operate. Users can intuitively view the real-time
results of system management. The system has a good user
experience effect.
At present, most enterprises use traditional inventory
management, which can not meet the requirements ofenterprises, because it needs people to do most of theoperation. Today, with the rapid development of Computer
1, this kind of management will be replace.
Therefore, in this case, it is very necessary to replace themanual inventory management system with such acollection, which has the advantages of fast retrieval,

Statistical analysis can be used as a tool to display its
data information in an image in such a way that it can seechanges in inventory, where the edges of the image aredifferent, the realistic information data can enable themanager to make the corresponding judgment. The
statistical analysis is shown in Fig.3.

79

convenient search, high reliability, good confidentiality
and low cost. Dream cloud ERP system based on Java inventory management subsystem v10 provides great
convenience for enterprises to process the data statistics ofinventory information management, make the informationclearer, make the data query easier, and promote better
communication between enterprises. The system runs
stably and is convenient for daily maintenance.
References
1. Chuangming Cao, Shaohua Dong, Yuhang Duan. Analysisof enterprise storage system management mode under theInternet plus background, Logistics engineering andmanagement, 2021, 43(11): pp. 44-48+21.
2. Ying Li. Design of inventory management software forlightweight Supermarket Based on CS structure, Procedia
Engineering, 2018, 21(05): pp.38-41.
3. Qile Qi, Research on Key Technologies of embedded
computer software testing, Electronic production, 2021,
21:pp. 99-100+78.
4. Bo Weng, Yanfeng Yan, Research on software testing in big
data environment, Internet Weekly, 2021, 22:pp. 42-44.
5. Lina Ma. Discussion on teaching reform of applied
multivariate statistical analysis under the background of big
data, Mapping and spatial geographic information,
2021,44(11): pp.87-88+92.
6.

Authors Introduction
7. Ms. Yiting Gao
She is a first-year master candidate inTianjin University of Science andTechnology, majoring in neural network,deep learning.

8. Mr. Peng Lu
9. He is a second-year master candidate inTianjin University of Science andTechnology. His research is about deeplearning, pattern recognition.

80