CN116506434B - Multi-terminal offline-operation intelligent warehouse management method - Google Patents

Multi-terminal offline-operation intelligent warehouse management method Download PDF

Info

Publication number
CN116506434B
CN116506434B CN202310471532.2A CN202310471532A CN116506434B CN 116506434 B CN116506434 B CN 116506434B CN 202310471532 A CN202310471532 A CN 202310471532A CN 116506434 B CN116506434 B CN 116506434B
Authority
CN
China
Prior art keywords
data
data transmission
network
intelligent
information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202310471532.2A
Other languages
Chinese (zh)
Other versions
CN116506434A (en
Inventor
江旭
陈中新
秦燕
胡钦波
曹松黎
孙树彬
黄璐
方玲
陈永雷
古庭
杨霖
徐云生
肖宇
何小勇
朱晓觅
秦超凡
谭仕娇
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Three Gorges High Technology Information Technology Co ltd
Hubei Qingjiang Hydroelectric Development Co ltd
Original Assignee
Three Gorges High Technology Information Technology Co ltd
Hubei Qingjiang Hydroelectric Development Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Three Gorges High Technology Information Technology Co ltd, Hubei Qingjiang Hydroelectric Development Co ltd filed Critical Three Gorges High Technology Information Technology Co ltd
Priority to CN202310471532.2A priority Critical patent/CN116506434B/en
Publication of CN116506434A publication Critical patent/CN116506434A/en
Application granted granted Critical
Publication of CN116506434B publication Critical patent/CN116506434B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00—Network arrangements or protocols for supporting network services or applications
    • H04L67/01—Protocols
    • H04L67/10—Protocols in which an application is distributed across nodes in the network
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00—Network arrangements or protocols for supporting network services or applications
    • H04L67/01—Protocols
    • H04L67/10—Protocols in which an application is distributed across nodes in the network
    • H04L67/1097—Protocols in which an application is distributed across nodes in the network for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00—Network arrangements or protocols for supporting network services or applications
    • H04L67/14—Session management
    • H04L67/141—Setup of application sessions
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00—Network arrangements or protocols for supporting network services or applications
    • H04L67/50—Network services
    • H04L67/56—Provisioning of proxy services
    • H04L67/568—Storing data temporarily at an intermediate stage, e.g. caching

Landscapes

  • Engineering & Computer Science (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Signal Processing (AREA)
  • Business, Economics & Management (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Quality & Reliability (AREA)
  • Finance (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Accounting & Taxation (AREA)
  • Operations Research (AREA)
  • Development Economics (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Data Exchanges In Wide-Area Networks (AREA)

Abstract

The invention provides an intelligent warehouse management method with multiple terminals capable of operating offline, which comprises the following steps: the method comprises the steps that an MQTT server is deployed in a management server, and a local database is added on an intelligent terminal; configuring a corresponding connection interface on a management server according to a plurality of terminal identifiers of the intelligent warehouse, and registering a plurality of message queues to an MQTT server according to the connection interface and the terminal identifiers; after receiving the data transmission instruction, judging the network state, and when the network is normal, carrying out data transmission between the intelligent terminal and the management server through the MQTT server; when the network is abnormal, the intelligent terminal stores the transmission data to a local database, stores the data transmission instruction in a corresponding message queue, and tries to transmit for a plurality of times, so that the operation and seamless switching of the intelligent warehouse management system in an online mode and an offline mode are realized, the warehouse construction and transformation cost is low, the time is short, the unified management of the multi-point warehouse of the common online intelligent warehouse can be realized, and the independent operation capability of the warehouse in a broken network state can be realized.

Description

Multi-terminal offline-operation intelligent warehouse management method
Technical Field
The invention relates to the technical field of warehouse management, in particular to an intelligent warehouse management method with multiple terminals capable of operating offline.
Background
The intelligent warehouse is a warehouse with a modern management means established by utilizing a plurality of modern technologies such as a computer technology, a network technology, an artificial intelligence technology, an internet of things sensing technology, a robot technology and the like, can realize the functions of automatic registration, automatic loading, automatic goods taking, automatic inventory, automatic statistical analysis and the like of the warehouse in and out of the warehouse, and has the characteristics of high informatization, automation and intelligent degree compared with the traditional warehouse, and can greatly improve the management efficiency and the refinement degree of the warehouse. The general structure of the intelligent warehouse mainly adopts the following three types:
1. the isolated intelligent warehouse is mainly used for a single-point miniature warehouse or a self-service container. The data storage, the service logic control and the hardware equipment control are all arranged on an intelligent terminal of a local area network without a network or a warehouse, and the system operates in an isolated mode, so that the system is suitable for special application scenes of a small-sized network-free environment;
2. the on-line intelligent warehouse is mainly used for medium-sized and small-sized multi-point warehouses. The system adopts a network structure of a server, a network and an intelligent terminal, the data storage and the service logic control are both at the server end, the intelligent terminals of each point warehouse are only used as user interaction terminals and hardware control hosts, the terminals and the server form a system whole by using the Internet or an enterprise internal network, and the intelligent operation of the warehouse is completed jointly through real-time data exchange and instruction control coordination operation. The structure is suitable for application scenes with scattered warehouse points and better network conditions;
3. the distributed cloud intelligent warehouse is mainly used for large-scale warehouses and logistics stations in cross areas. The system adopts a distributed network structure of a cloud server, a wide area network, a local server, a local area network and an intelligent terminal, wherein data storage and upper-layer service logic are controlled at the cloud server end, and local data storage and front-end service logic are controlled at the local server end. The local server is responsible for data storage and business logic control of the warehouse in the current area, and communicates and controls with the intelligent terminal of the warehouse through the local area network; the cloud server and the local server perform data synchronization and task scheduling irregularly through the wide area network, and basic function operation of the warehouse local management system is not affected after the cloud server and the local server lose contact. The structure is suitable for application scenes such as enterprise multi-point warehouses or large-scale chain warehouse logistics stations with wider regional distribution.
In actual demand, many application scenarios cannot be solved by the three intelligent warehouse technologies, for example, many enterprises have factories and warehouses scattered in different areas and own intranet systems, the information system is required to be deployed in the intranet systems, the intranet systems cannot be ensured to be kept smooth at any moment, and the warehouse management system is required to realize cross-regional unified management and control, and can operate offline when the intranet is not enabled, and meanwhile, the construction and maintenance costs of the warehouse system are also controlled. Although the intelligent warehouse with three existing structures has the characteristics, the following problems exist for the application scene:
1. the isolated intelligent warehouse has the advantages that the manageable materials are less, the data are closed, the information such as material data, warehouse entry and warehouse exit records and the like only support local input and inquiry, the warehouse information of all areas is not communicated with each other, the informatization degree is low, and the requirements of enterprises on unified management and allocation of the warehouse materials can not be met;
2. the online intelligent warehouse requires that the network is always kept smooth, the server and the terminal equipment can exchange data at any time, once the network is interrupted or the server is down, the whole system is in paralysis, all the warehouses cannot normally go out of the warehouse, and the fault isolation capability of the system is poor;
3. the distributed cloud intelligent warehouse is complex in structure, regional servers are required to be arranged at the centralized points of all warehouses, business data and business logic are required to be divided according to the hierarchy, the cloud servers and the regional servers are required to cooperate in a labor division manner and exchange data, a software system is complex in design, the system construction period is long, and the cost is high.
Disclosure of Invention
The invention provides an intelligent warehouse management method with multiple terminals capable of operating offline, which can realize the operation and seamless switching of an intelligent warehouse management system in two modes of online and offline, has low warehouse construction and transformation cost and short time, and can realize the unified management of a multi-point warehouse of a common online intelligent warehouse and the independent operation capability of the warehouse in a broken network state.
An intelligent warehouse management method for multi-terminal offline operation, comprising the following steps:
s1: the method comprises the steps that an MQTT server is deployed in a management server, and a local database is added on an intelligent terminal;
s2: configuring a corresponding connection interface on a management server according to a plurality of terminal identifiers of the intelligent warehouse, and registering a plurality of message queues to an MQTT server according to the connection interface and the terminal identifiers;
s3: after receiving the data transmission instruction, judging the network state, and when the network is normal, carrying out data transmission between the intelligent terminal and the management server through the MQTT server;
s4: when the network is abnormal, the intelligent terminal stores the transmission data to a local database, and stores the data transmission instruction in the intelligent terminal, and the intelligent terminal tries to transmit for many times until the maximum sending times are exceeded.
Preferably, the method further comprises:
when detecting that a plurality of intelligent terminals and a management server perform data transmission, determining communication connection between the current transmission intelligent terminal and other intelligent terminals through a local area network based on terminal identification;
and transmitting new data generated by data transmission to other intelligent terminals based on the communication connection.
Preferably, in S1, the management server deploys an MQTT server, and adds a local database to the intelligent terminal, including:
the management server deploys an MQTT server comprising:
acquiring an MQTT data transmission format between a server and an intelligent terminal, determining the function type of the MQTT server according to the MQTT data transmission format, and determining the configuration parameters of the MQTT server;
establishing connection between the configured MQTT server and the management server and between the configured MQTT server and the intelligent terminal through a communication protocol, and configuring the configured MQTT server on the management server;
adding a local database on the intelligent terminal comprises the following steps:
adding a local database on the intelligent terminal;
and establishing storage connection between the data information managed by the intelligent terminal and the local database, and establishing storage connection between the operation information of the user at the intelligent terminal.
Preferably, in S2, according to a plurality of terminal identifiers of the intelligent repository, a corresponding connection interface is configured on the management server, and a plurality of message queues are registered to the MQTT server according to the connection interface and the terminal identifiers, including:
according to the multiple terminal identifiers of the intelligent warehouse, the network information of the local area network realizes the configuration of the connection interface;
after the configuration of the connection interface is completed, a message queue is obtained by registration according to the address information of the connection interface and the identification information of the terminal identification, and the message queue is managed in a unified way according to the management information of the communication protocol.
Preferably, according to the network information of the local area network according to the plurality of terminal identifiers of the intelligent warehouse, the configuration of the connection interface is realized, including:
determining model parameters and data transmission types of the intelligent warehouse according to a plurality of terminal identifiers of the intelligent warehouse, determining interface types of the connection interfaces based on the model parameters, determining a data processing mode of the connection interfaces based on the data transmission types, and determining connection protocols of the connection interfaces based on the local area network;
based on the interface type, the data processing mode and the connection protocol, generating interface configuration information of the connection interface, determining that the connection interface needs to call an execution unit of the management server according to the interface configuration information, and configuring the execution unit and the connection interface according to the interface configuration information to realize configuration of the connection interface.
Preferably, the method includes registering to obtain a message queue according to address information of the connection interface and identification information of the terminal identification, and uniformly managing the message queue according to management information of a communication protocol, including:
acquiring first registration information according to the address information of the connection interface, acquiring second registration information according to the identification information of the terminal identification, acquiring target registration information according to the first registration information and the second registration information, and determining management parameters according to a communication protocol;
establishing a message queue set according to the target registration information, acquiring corresponding target registration information sent by a message queue sequence in the message queue set to an MQTT server, establishing a connection relationship between the message queue sequence and the corresponding target registration information, and respectively registering to obtain a message queue corresponding to each intelligent terminal according to the connection relationship and the target registration information;
and uniformly managing all the message queues in the message queue set by using the management parameters.
Preferably, in S3, after receiving the data transmission instruction, the network state is determined, and when the network is normal, data transmission between the intelligent terminal and the management server is performed through the MQTT server, including:
after receiving a data transmission instruction, acquiring data flow generated by an MQTT server in a preset period and average cache data quantity in unit time, and calculating to obtain a first network detection value of the MQTT server according to the data flow generated in the preset period and the average cache data quantity in the unit time;
judging whether the first network detection value is larger than a first preset detection value or not;
if yes, determining that the network state is normal;
otherwise, determining that the network state may have an anomaly;
according to the first network detection value, combining the real-time received data quantity and the change rate of the data quantity cached by the MQTT server between the size and the adjacent time in the unit time of the MQTT server, and the latest data transmission times, the data transmission quantity and the data transmission time, and calculating to obtain a second network detection value of the MQTT server;
judging whether the second network detection value is larger than a second preset detection value or not;
if yes, determining that the network state is network congestion, and adding the data transmission instruction into a data transmission message queue to wait for response;
otherwise, determining the network state as abnormal.
Preferably, in S4, when the network is abnormal, the intelligent terminal stores the transmission data in the local database, and stores the data transmission instruction in the intelligent terminal, and the transmission is tried several times until the maximum number of times of transmission is exceeded, including:
when network abnormality occurs, after determining that the data transmission from the intelligent terminal to the MQTT server fails, storing transmission data to a local database, storing a data transmission instruction in the intelligent terminal, and marking the synchronization state as unsynchronized;
detecting the data transmission condition before the network is normal, and determining final transmission information;
acquiring the latest transmission instruction corresponding to the final transmission information, updating the data transmission instruction in the corresponding intelligent terminal based on the latest transmission instruction, and marking the synchronous state as synchronous after finishing the data transmission of the MQTT server based on the latest transmission instruction;
and when the network state is detected to exceed the maximum sending times based on the first timing task, sending out a data transmission instruction execution failure reminding when the detected network state is still abnormal.
Preferably, detecting a data transmission condition before a network is normal, and determining final transmission information includes:
setting a first interval and a network judgment task combination to obtain a first timing task, setting a second interval and a transmission monitoring task combination to obtain a second timing task, and detecting the network state based on the first timing task until the network is determined to be normal, and determining a time point when the network is normal;
detecting transmission conditions before the time point according to a second timing task to obtain a plurality of groups of transmission information, and judging whether the plurality of groups of transmission information have conflict or not;
if yes, selecting the transmission information closest to the time point as final transmission information;
otherwise, the multiple sets of transmission information are taken as final transmission information together.
Preferably, the method further comprises the steps that after the intelligent terminal receives data transmission from the MQTT server and the data transmission is successful, the local database is updated according to the received data, and the received data is pushed to other intelligent terminals by utilizing the local area network and the terminal identification.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims thereof as well as the appended drawings.
The technical scheme of the invention is further described in detail through the drawings and the embodiments.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention. In the drawings:
FIG. 1 is a flowchart of an intelligent warehouse management method with multiple terminals capable of offline operation in an embodiment of the invention;
FIG. 2 is a flow chart of registering multiple message queues according to an embodiment of the present invention;
fig. 3 is a flowchart of data transmission performed by network anomaly in an embodiment of the present invention.
Detailed Description
The preferred embodiments of the present invention will be described below with reference to the accompanying drawings, it being understood that the preferred embodiments described herein are for illustration and explanation of the present invention only, and are not intended to limit the present invention.
Example 1
The invention provides an intelligent warehouse management method with multiple terminals capable of operating offline, as shown in fig. 1, comprising the following steps:
s1: the method comprises the steps that an MQTT server is deployed in a management server, and a local database is added on an intelligent terminal;
s2: configuring a corresponding connection interface on a management server according to a plurality of terminal identifiers of the intelligent warehouse, and registering a plurality of message queues to an MQTT server according to the connection interface and the terminal identifiers;
s3: after receiving the data transmission instruction, judging the network state, and when the network is normal, carrying out data transmission between the intelligent terminal and the management server through the MQTT server;
s4: when the network is abnormal, the intelligent terminal stores the transmission data to a local database, and stores the data transmission instruction in the intelligent terminal, and the intelligent terminal tries to transmit for many times until the maximum sending times are exceeded.
In this embodiment, one intelligent terminal corresponds to one local database, and for a terminal of a Windows system, the local data cache can use a database such as MS-SQL, mySql, MS-Access, SQLite; for an Android terminal, the local data cache can adopt an SQLite database.
In this embodiment, each intelligent terminal sets a unique identifier in the software, the server side software sets a multi-terminal configuration interface, registers a plurality of message queues to the MQTT server according to the number of configured terminals and the identifiers, and enables each terminal to independently share one message queue, so as to ensure that each terminal can receive synchronous data of the server.
In this embodiment, the multiple attempted transmissions are made after network recovery.
The beneficial effects of above-mentioned design scheme are: according to the scheme, the MQTT service is introduced as the transfer, the unification of the data synchronous interfaces of the system in the on-line mode and the off-line mode is realized, the development of two sets of data interfaces is avoided, the complexity degree and development and transformation costs of a software system are reduced, and the operation and seamless switching of the intelligent warehouse management system in the on-line mode and the off-line mode can be realized only by starting from the software layer without adding any hardware facilities, so that the warehouse construction and transformation costs are low and the time is short, the unified management of the multi-point warehouse of the common on-line intelligent warehouse can be realized, the independent operation capability of the warehouse in the off-line state can be realized, the problem that the system is completely paralyzed in the off-line state of the on-line intelligent warehouse is solved, and the defects of little manageable materials, data sealing, low informatization degree and the like of the isolated intelligent warehouse are overcome.
Example 2
Based on embodiment 1, the embodiment of the invention provides an intelligent warehouse management method capable of offline operation of multiple terminals, which further comprises the following steps:
when detecting that a plurality of intelligent terminals and a management server perform data transmission, determining communication connection between the current transmission intelligent terminal and other intelligent terminals through a local area network based on terminal identification;
and transmitting new data generated by data transmission to other intelligent terminals based on the communication connection.
The beneficial effects of above-mentioned design scheme are: when a plurality of intelligent terminals exist in a warehouse, each terminal can push the latest generated data to other intelligent terminals in the same warehouse through a local area network and a terminal unique identifier so as to keep the consistency of the local cache data of the plurality of terminals in the same warehouse and realize terminal data sharing.
Example 3
Based on embodiment 1, the embodiment of the invention provides an intelligent warehouse management method capable of offline operation of multiple terminals, in S1, a management server deploys an MQTT server, and a local database is added on the intelligent terminal, comprising:
the management server deploys an MQTT server comprising:
acquiring an MQTT data transmission format between a server and an intelligent terminal, determining the function type of the MQTT server according to the MQTT data transmission format, and determining the configuration parameters of the MQTT server;
establishing connection between the configured MQTT server and the management server and between the configured MQTT server and the intelligent terminal through a communication protocol, and configuring the configured MQTT server on the management server;
adding a local database on the intelligent terminal comprises the following steps:
adding a local database on the intelligent terminal;
and establishing storage connection between the data information managed by the intelligent terminal and the local database, and establishing storage connection between the operation information of the user at the intelligent terminal.
The design scheme has the beneficial effects that: the MQTT server is deployed on the management server, the local database is added on the intelligent terminal, the transfer connection between the management server and the intelligent terminal is realized, the data transmission in two modes of wire and off-line is realized, the independent operation capability of the warehouse in the disconnected network state is realized, the data storage of the intelligent terminal is realized, the development of two sets of data interfaces is avoided, and the complexity, development and modification cost of the software system are reduced.
Example 4
Based on embodiment 1, an embodiment of the present invention provides an intelligent warehouse management method capable of offline operation of multiple terminals, as shown in fig. 2, in S2, according to multiple terminal identifiers of an intelligent warehouse, configuring corresponding connection interfaces on a management server, and registering multiple message queues to an MQTT server according to the connection interfaces and the terminal identifiers, including:
s21: according to the multiple terminal identifiers of the intelligent warehouse, the network information of the local area network realizes the configuration of the connection interface;
s22: after the configuration of the connection interface is completed, a message queue is obtained by registration according to the address information of the connection interface and the identification information of the terminal identification, and the message queue is managed in a unified way according to the management information of the communication protocol.
In this embodiment, according to the network information of the local area network according to the plurality of terminal identifiers of the intelligent repository, the configuration of the connection interface is implemented, including:
determining model parameters and data transmission types of the intelligent warehouse according to a plurality of terminal identifiers of the intelligent warehouse, determining interface types of the connection interfaces based on the model parameters, determining a data processing mode of the connection interfaces based on the data transmission types, and determining connection protocols of the connection interfaces based on the local area network;
based on the interface type, the data processing mode and the connection protocol, generating interface configuration information of the connection interface, determining that the connection interface needs to call an execution unit of the management server according to the interface configuration information, and configuring the execution unit and the connection interface according to the interface configuration information to realize configuration of the connection interface.
In this embodiment, the registering to obtain the message queue according to the address information of the connection interface and the identification information of the terminal identification, and the unified management of the message queue according to the management information of the communication protocol includes:
acquiring first registration information according to the address information of the connection interface, acquiring second registration information according to the identification information of the terminal identification, acquiring target registration information according to the first registration information and the second registration information, and determining management parameters according to a communication protocol;
establishing a message queue set according to the target registration information, acquiring corresponding target registration information sent by a message queue sequence in the message queue set to an MQTT server, establishing a connection relationship between the message queue sequence and the corresponding target registration information, and respectively registering to obtain a message queue corresponding to each intelligent terminal according to the connection relationship and the target registration information;
and uniformly managing all the message queues in the message queue set by using the management parameters.
The beneficial effects of above-mentioned design scheme are: according to the method, a corresponding unique connection interface is set for each intelligent terminal, so that safe and orderly connection between each intelligent terminal and a management server is realized, error sending and theft of information are avoided, and then a plurality of message queues are registered to an MQTT server according to the number and the identification of the configured terminals, so that each terminal independently shares one message queue, and each terminal can be ensured to receive synchronous data of the server; the defects of small manageable materials, closed data, low informatization degree and the like of the isolated intelligent warehouse are overcome.
Example 5
Based on embodiment 4, the embodiment of the invention provides an intelligent warehouse management method capable of offline operation of multiple terminals, according to multiple terminal identifiers of an intelligent warehouse, network information of a local area network is used for configuring a connection interface, and the method comprises the following steps:
determining model parameters and data transmission types of the intelligent warehouse according to a plurality of terminal identifiers of the intelligent warehouse, determining interface types of the connection interfaces based on the model parameters, determining a data processing mode of the connection interfaces based on the data transmission types, and determining connection protocols of the connection interfaces based on the local area network;
based on the interface type, the data processing mode and the connection protocol, generating interface configuration information of the connection interface, determining that the connection interface needs to call an execution unit of the management server according to the interface configuration information, and configuring the execution unit and the connection interface according to the interface configuration information to realize configuration of the connection interface.
In this embodiment, the execution unit and the connection interface are configured according to the interface configuration information to implement the execution function of the connection interface.
The beneficial effects of above-mentioned design scheme are: the intelligent terminals are connected with the management server in a safe and orderly mode by setting the corresponding unique connection interface for each intelligent terminal, so that information is prevented from being sent and stolen in error, interface configuration information of the connection interface is generated through the interface type, the data processing mode and the connection protocol, and feasibility and safety of the generation of the connection interface are guaranteed.
Example 6
Based on embodiment 4, the embodiment of the invention provides an intelligent warehouse management method capable of offline operation of multiple terminals, which registers to obtain a message queue according to address information of a connection interface and identification information of a terminal identification, and uniformly manages the message queue according to management information of a communication protocol, and comprises the following steps:
acquiring first registration information according to the address information of the connection interface, acquiring second registration information according to the identification information of the terminal identification, acquiring target registration information according to the first registration information and the second registration information, and determining management parameters according to a communication protocol;
establishing a message queue set according to the target registration information, acquiring corresponding target registration information sent by a message queue sequence in the message queue set to an MQTT server, establishing a connection relationship between the message queue sequence and the corresponding target registration information, and respectively registering to obtain a message queue corresponding to each intelligent terminal according to the connection relationship and the target registration information;
and uniformly managing all the message queues in the message queue set by using the management parameters.
In this embodiment, the communication protocol is designed according to the characteristics of the intelligent terminal and the management server.
The beneficial effects of above-mentioned design scheme are: through establishing a connection relation between a message queue sequence and corresponding target registration information, respectively registering to obtain a message queue corresponding to each intelligent terminal according to the connection relation and the target registration information, realizing one-to-one correspondence between the message queues in a message queue set and the intelligent terminals, and uniformly managing all the message queues in the message queue set by using the management parameters, ensuring that each terminal independently shares one message queue, and ensuring that each terminal can receive synchronous data of a server; the defects of small manageable materials, closed data, low informatization degree and the like of the isolated intelligent warehouse are overcome.
Example 7
Based on embodiment 1, the embodiment of the invention provides an intelligent warehouse management method capable of offline operation of multiple terminals, in S3, after receiving a data transmission instruction, the method judges the network state, and when the network is normal, the method performs data transmission between the intelligent terminals and a management server through an MQTT server, and comprises the following steps:
after receiving a data transmission instruction, acquiring data flow generated by an MQTT server in a preset period and average cache data quantity in unit time, and calculating to obtain a first network detection value of the MQTT server according to the data flow generated in the preset period and the average cache data quantity in the unit time;
the calculation formula of the first network detection value is as follows:
；
wherein,representing said first network detection value,/->Representing the data traffic generated by the MQTT server within a preset period,/for example>Representing generation of a predetermined period in historical traffic monitoring of an MQTT serverMaximum data flow, +.>Representing the minimum data traffic generated during a preset period in the historical traffic monitoring of the MQTT server,/->Representing the average buffered data amount per unit time of the MQTT server,/for the data amount per unit time>Representing a standard average cache data amount generated by the MQTT server in unit time when the network state is normal;
judging whether the first network detection value is larger than a first preset detection value or not;
if yes, determining that the network state is normal;
otherwise, determining that the network state may have an anomaly;
according to the first network detection value, combining the real-time received data quantity and the change rate of the data quantity cached by the MQTT server between the size and the adjacent time in the unit time of the MQTT server, and the latest data transmission times, the data transmission quantity and the data transmission time, and calculating to obtain a second network detection value of the MQTT server;
the calculation formula of the second network detection value is as follows:
；
wherein,a second network detection value representing the MQTT server, < >>Representing the rate of change of the amount of buffered data of the MQTT server between adjacent times, < >>Representing real-time received data per unit time of MQTT serverSize of quantity,/->Indicates the latest data transmission times +.>Indicating the data transmission amount of the ith data transmission,/-for the data transmission>Data transmission time representing the ith data transmission, < >>Data transmission quantity representing the (i+1) -th data transmission,>the data transmission time of the (i+1) -th data transmission is represented;
judging whether the second network detection value is larger than a second preset detection value or not;
if yes, determining that the network state is network congestion, and adding the data transmission instruction into a data transmission message queue to wait for response;
otherwise, determining the network state as abnormal.
In this embodiment, a network state being abnormal indicates that the network is in an offline state.
The beneficial effects of above-mentioned design scheme are: by carrying out calculation analysis according to the network state parameters and events of the MQTT server, whether the network state is abnormal or not is determined through one-time calculation, the condition that the network state is determined to be abnormal due to network congestion caused by excessive transmission tasks is avoided, the accuracy of determining the network state is ensured, and therefore the rationality of a data transmission mode is ensured.
Example 8
Based on embodiment 1, an embodiment of the present invention provides an intelligent warehouse management method capable of offline operation of multiple terminals, as shown in fig. 3, in S4, when a network is abnormal, the intelligent terminal stores transmission data to a local database, and stores a data transmission instruction in the intelligent terminal, and attempts transmission for multiple times until the maximum number of times of transmission is exceeded, including:
s41: when network abnormality occurs, after determining that the data transmission from the intelligent terminal to the MQTT server fails, storing transmission data to a local database, storing a data transmission instruction in the intelligent terminal, and marking the synchronization state as unsynchronized;
s42: detecting the data transmission condition before the network is normal, and determining final transmission information;
s43: acquiring the latest transmission instruction corresponding to the final transmission information, updating the data transmission instruction in the corresponding intelligent terminal based on the latest transmission instruction, and marking the synchronous state as synchronous after finishing the data transmission of the MQTT server based on the latest transmission instruction;
s44: and when the network state is detected to exceed the maximum sending times based on the first timing task, sending out a data transmission instruction execution failure reminding when the detected network state is still abnormal.
In this embodiment, detecting a data transmission condition before the network is normal, and determining final transmission information includes:
setting a first interval and a network judgment task combination to obtain a first timing task, setting a second interval and a transmission monitoring task combination to obtain a second timing task, and detecting the network state based on the first timing task until the network is determined to be normal, and determining a time point when the network is normal;
detecting transmission conditions before the time point according to a second timing task to obtain a plurality of groups of transmission information, and judging whether the plurality of groups of transmission information have conflict or not;
if yes, selecting the transmission information closest to the time point as final transmission information;
otherwise, the multiple sets of transmission information are taken as final transmission information together.
The beneficial effects of above-mentioned design scheme are: when the network is abnormal, after the intelligent warehouse terminal fails to send the newly generated data message to the MQTT server, the data is cached in a local database (comprising the content of updated data, the generation time, the message type, the synchronous state and the like), and then the network state is judged through a timing task. When the network is recovered to be normal, attempting to send data to the MQTT server again, if the data is successfully sent to the MQTT server, changing the synchronous state of the local cache data, otherwise, attempting to send the data again until the set maximum sending times are exceeded, and realizing the independent operation capability of the warehouse in the broken network state, thereby solving the problem that the system is completely paralyzed in the broken network state of the online intelligent warehouse, and overcoming the defects of less manageable materials, closed data, low informatization degree and the like of the isolated intelligent warehouse; by introducing the MQTT service as the transfer, the unification of the data synchronization interfaces of the system in the online mode and the offline mode can be realized, two sets of data interfaces are avoided from being developed, and the complexity degree, the development cost and the reconstruction cost of the software system are reduced.
Example 9
Based on embodiment 8, the intelligent warehouse management method capable of offline operation of multiple terminals in the embodiment of the invention detects the data transmission condition before the network is normal and determines the final transmission information, and the method comprises the following steps:
setting a first interval and a network judgment task combination to obtain a first timing task, setting a second interval and a transmission monitoring task combination to obtain a second timing task, and detecting the network state based on the first timing task until the network is determined to be normal, and determining a time point when the network is normal;
detecting transmission conditions before the time point according to a second timing task to obtain a plurality of groups of transmission information, and judging whether the plurality of groups of transmission information have conflict or not;
if yes, selecting the transmission information closest to the time point as final transmission information;
otherwise, the multiple sets of transmission information are taken as final transmission information together.
The beneficial effects of above-mentioned design scheme are: by setting network task monitoring and transmission task monitoring and analyzing the network task monitoring and the transmission task monitoring from the time dimension, the latest transmission information is determined, whether the multiple groups of transmission information have conflict is judged, and when offline data synchronization is realized, if a receiver finds multiple data transmissions which conflict with each other, the latest data is selected as final data transmission according to the time of data generation, so that the waste of resources and the confusion of data caused by the transmission of outdated data are avoided, and the data synchronization of the intelligent terminal and the MQTT server is realized.
Example 10
Based on embodiment 1, the intelligent warehouse management method capable of offline operation of multiple terminals in the embodiment of the invention further comprises the steps of updating data of a local database according to received data after the intelligent terminals receive data from the MQTT server and successfully transmit the data, and pushing the received data to other intelligent terminals by utilizing a local area network and a terminal identifier.
The beneficial effects of above-mentioned design scheme are: when a plurality of intelligent terminals exist in the warehouse, each terminal can push the latest generated data to other intelligent terminals in the same warehouse through the local area network and the unique terminal identifier so as to keep the consistency of the local cache data of the plurality of terminals in the same warehouse.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present invention without departing from the spirit or scope of the invention. Thus, it is intended that the present invention also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.

Claims (8)

1. An intelligent warehouse management method capable of offline operation of multiple terminals is characterized by comprising the following steps:
s1: the method comprises the steps that an MQTT server is deployed in a management server, and a local database is added on an intelligent terminal;
s2: configuring a corresponding connection interface on a management server according to a plurality of terminal identifiers of the intelligent warehouse, and registering a plurality of message queues to an MQTT server according to the connection interface and the terminal identifiers; wherein,
according to the multiple terminal identifiers of the intelligent warehouse, the network information of the local area network realizes the configuration of the connection interface; the method comprises the steps of determining model parameters and data transmission types of an intelligent warehouse according to a plurality of terminal identifiers of the intelligent warehouse, determining interface types of a connection interface based on the model parameters, determining a data processing mode of the connection interface based on the data transmission types, and determining a connection protocol of the connection interface based on a local area network; based on the interface type, the data processing mode and the connection protocol, generating interface configuration information of the connection interface, determining that the connection interface needs to call an execution unit of the management server according to the interface configuration information, and configuring the execution unit and the connection interface according to the interface configuration information to realize configuration of the connection interface;
after the configuration of the connection interface is completed, a message queue is obtained by registration according to the address information of the connection interface and the identification information of the terminal identification, and the message queue is managed in a unified way according to the management information of the communication protocol;
s3: after receiving the data transmission instruction, judging the network state, and when the network is normal, carrying out data transmission between the intelligent terminal and the management server through the MQTT server;
s4: when the network is abnormal, the intelligent terminal stores the transmission data to a local database, and stores the data transmission instruction in the intelligent terminal, and the intelligent terminal tries to transmit for many times until the maximum sending times are exceeded.
2. The intelligent warehouse management method for enabling multiple terminals to operate offline according to claim 1, further comprising:
when detecting that a plurality of intelligent terminals and a management server perform data transmission, determining communication connection between the current transmission intelligent terminal and other intelligent terminals through a local area network based on terminal identification;
and transmitting new data generated by data transmission to other intelligent terminals based on the communication connection.
3. The intelligent warehouse management method capable of off-line operation of multiple terminals according to claim 1, wherein in S1, the management server deploys an MQTT server, and adding a local database on the intelligent terminal comprises:
the management server deploys an MQTT server comprising:
acquiring an MQTT data transmission format between a server and an intelligent terminal, determining the function type of the MQTT server according to the MQTT data transmission format, and determining the configuration parameters of the MQTT server;
establishing connection between the configured MQTT server and the management server and between the configured MQTT server and the intelligent terminal through a communication protocol, and configuring the configured MQTT server on the management server;
adding a local database on the intelligent terminal comprises the following steps:
adding a local database on the intelligent terminal;
and establishing storage connection between the data information managed by the intelligent terminal and the local database, and establishing storage connection between the operation information of the user at the intelligent terminal.
4. The intelligent warehouse management method of multiple terminals capable of operating offline according to claim 1, wherein the steps of registering to obtain a message queue according to the address information of the connection interface and the identification information of the terminal identification, and uniformly managing the message queue according to the management information of the communication protocol include:
acquiring first registration information according to the address information of the connection interface, acquiring second registration information according to the identification information of the terminal identification, acquiring target registration information according to the first registration information and the second registration information, and determining management parameters according to a communication protocol;
establishing a message queue set according to the target registration information, acquiring corresponding target registration information sent by a message queue sequence in the message queue set to an MQTT server, establishing a connection relationship between the message queue sequence and the corresponding target registration information, and respectively registering to obtain a message queue corresponding to each intelligent terminal according to the connection relationship and the target registration information;
and uniformly managing all the message queues in the message queue set by using the management parameters.
5. The intelligent warehouse management method of claim 1, wherein in S3, after receiving the data transmission command, the network state is determined, and when the network is normal, the data transmission between the intelligent terminal and the management server is performed through the MQTT server, comprising:
after receiving a data transmission instruction, acquiring data flow generated by an MQTT server in a preset period and average cache data quantity in unit time, and calculating to obtain a first network detection value of the MQTT server according to the data flow generated in the preset period and the average cache data quantity in the unit time; the calculation formula of the first network detection value is as follows:
；
wherein,representing said first network detection value,/->Representing the data traffic generated by the MQTT server within a preset period,/for example>Representing the maximum data traffic generated during a preset period in the historical traffic monitoring of the MQTT server,/->Representing the minimum data traffic generated during a preset period in the historical traffic monitoring of the MQTT server,/->Representing the average buffered data amount per unit time of the MQTT server,/for the data amount per unit time>Representing a standard average cache data amount generated by the MQTT server in unit time when the network state is normal;
judging whether the first network detection value is larger than a first preset detection value or not;
if yes, determining that the network state is normal;
otherwise, determining that the network state may have an anomaly;
according to the first network detection value, combining the real-time received data quantity and the change rate of the data quantity cached by the MQTT server between the size and the adjacent time in the unit time of the MQTT server, and the latest data transmission times, the data transmission quantity and the data transmission time, and calculating to obtain a second network detection value of the MQTT server; the calculation formula of the second network detection value is as follows:
；
wherein,a second network detection value representing the MQTT server, < >>Representing the rate of change of the amount of buffered data of the MQTT server between adjacent times, < >>Representing the size of the data quantity received by the MQTT server in real time per unit time,/for the data quantity>Indicates the latest data transmission times +.>Indicating the data transmission amount of the ith data transmission,/-for the data transmission>Representing the ith time dataThe time of transmission of the data to be transmitted,data transmission quantity representing the (i+1) -th data transmission,>the data transmission time of the (i+1) -th data transmission is represented;
judging whether the second network detection value is larger than a second preset detection value or not;
if yes, determining that the network state is network congestion, and adding the data transmission instruction into a data transmission message queue to wait for response;
otherwise, determining the network state as abnormal.
6. The intelligent warehouse management method of claim 1, wherein in S4, when the network is abnormal, the intelligent terminal stores the transmission data in a local database, and stores the data transmission instruction in the intelligent terminal, and the intelligent terminal tries to transmit for a plurality of times until the maximum number of times of sending is exceeded, comprising:
when network abnormality occurs, after determining that the data transmission from the intelligent terminal to the MQTT server fails, storing transmission data to a local database, storing a data transmission instruction in the intelligent terminal, and marking the synchronization state as unsynchronized;
detecting the data transmission condition before the network is normal, and determining final transmission information;
acquiring the latest transmission instruction corresponding to the final transmission information, updating the data transmission instruction in the corresponding intelligent terminal based on the latest transmission instruction, and marking the synchronous state as synchronous after finishing the data transmission of the MQTT server based on the latest transmission instruction;
when the network state is detected to exceed the maximum sending times based on the first timing task, sending out a data transmission instruction execution failure reminding when the detected network state is still abnormal; and setting a first interval and combining network judgment tasks to obtain a first timing task.
7. The intelligent warehouse management method of claim 6, wherein detecting the data transmission condition before the network is normal to determine the final transmission information, comprising:
setting a second time interval and a transmission monitoring task combination to obtain a second timing task, detecting the network state based on the first timing task until the network is determined to be normal, and determining a time point when the network is normal;
detecting transmission conditions before the time point according to a second timing task to obtain a plurality of groups of transmission information, and judging whether the plurality of groups of transmission information have conflict or not;
if yes, selecting the transmission information closest to the time point as final transmission information;
otherwise, the multiple sets of transmission information are taken as final transmission information together.
8. The intelligent warehouse management method capable of running off-line for multiple terminals according to claim 1, further comprising, after the intelligent terminal receives the data transmission from the MQTT server and the data transmission is successful, updating the local database according to the received data, and pushing the received data to other intelligent terminals by using the local area network and the terminal identifier.
CN202310471532.2A 2023-04-27 2023-04-27 Multi-terminal offline-operation intelligent warehouse management method Active CN116506434B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310471532.2A CN116506434B (en) 2023-04-27 2023-04-27 Multi-terminal offline-operation intelligent warehouse management method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310471532.2A CN116506434B (en) 2023-04-27 2023-04-27 Multi-terminal offline-operation intelligent warehouse management method

Publications (2)

Publication Number Publication Date
CN116506434A CN116506434A (en) 2023-07-28
CN116506434B true CN116506434B (en) 2024-01-30

Family

ID=87329800

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310471532.2A Active CN116506434B (en) 2023-04-27 2023-04-27 Multi-terminal offline-operation intelligent warehouse management method

Country Status (1)

Country Link
CN (1) CN116506434B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117914930B (en) * 2024-03-15 2024-07-12 苔花科迈(西安)信息技术有限公司 Mobile equipment operation method and device based on network state detection under coal mine

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101388833A (en) * 2008-07-18 2009-03-18 广东工业大学 Network controlling method based on adaptive threshold mechanism
CN104809609A (en) * 2015-05-26 2015-07-29 南通职业大学 Intelligent warehouse management system and management method
CN105515819A (en) * 2015-07-14 2016-04-20 国家电网公司 IEC61850-based communication component and application component data interface method
CN107193255A (en) * 2017-06-30 2017-09-22 周英 Intelligent repository long-distance management system based on internet
CN111555945A (en) * 2020-05-20 2020-08-18 四川九州电子科技股份有限公司 General network communication system based on MQTT protocol
CN111586171A (en) * 2020-05-07 2020-08-25 广州虎牙信息科技有限公司 Server operation method and device, electronic equipment and storage medium
CN112786188A (en) * 2021-02-05 2021-05-11 北京致医健康信息技术有限公司 Offline working method and device of auxiliary diagnosis system, terminal equipment and medium
CN113141383A (en) * 2020-01-18 2021-07-20 佛山市云米电器科技有限公司 Device information subscription method, client, server, system and storage medium
CN115412468A (en) * 2021-05-10 2022-11-29 中国电信股份有限公司 Method, device, controller and medium for detecting port traffic of network equipment

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7032002B1 (en) * 2000-09-06 2006-04-18 Xanboo, Inc. Service broker for processing data from a data network

Patent Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101388833A (en) * 2008-07-18 2009-03-18 广东工业大学 Network controlling method based on adaptive threshold mechanism
CN104809609A (en) * 2015-05-26 2015-07-29 南通职业大学 Intelligent warehouse management system and management method
CN105515819A (en) * 2015-07-14 2016-04-20 国家电网公司 IEC61850-based communication component and application component data interface method
CN107193255A (en) * 2017-06-30 2017-09-22 周英 Intelligent repository long-distance management system based on internet
CN113141383A (en) * 2020-01-18 2021-07-20 佛山市云米电器科技有限公司 Device information subscription method, client, server, system and storage medium
CN111586171A (en) * 2020-05-07 2020-08-25 广州虎牙信息科技有限公司 Server operation method and device, electronic equipment and storage medium
CN111555945A (en) * 2020-05-20 2020-08-18 四川九州电子科技股份有限公司 General network communication system based on MQTT protocol
CN112786188A (en) * 2021-02-05 2021-05-11 北京致医健康信息技术有限公司 Offline working method and device of auxiliary diagnosis system, terminal equipment and medium
CN115412468A (en) * 2021-05-10 2022-11-29 中国电信股份有限公司 Method, device, controller and medium for detecting port traffic of network equipment

Also Published As

Publication number Publication date
CN116506434A (en) 2023-07-28

Similar Documents

Publication Publication Date Title
EP3734913A1 (en) Communication method and communication apparatus
CN110535965A (en) A kind of data processing method and device, storage medium
CN101873005B (en) Method for realizing balanced acquisition of electric energy
CN106210099B (en) Data processing system and method
CN116506434B (en) Multi-terminal offline-operation intelligent warehouse management method
CN101784968B (en) Programming device for a network of control nodes and system with such a programming device
CN102045192A (en) Apparatus and system for estimating network configuration
EP2826265A2 (en) Group operations in machine-to-machine networks using a shared identifier
CN109597723A (en) Two-node cluster hot backup redundancy for subway comprehensive monitoring system realizes system and method
CN104079599A (en) Real-time message synchronizing method and container wharf operation system
CN111093220B (en) Autonomous unmanned cluster dynamic management method and management platform
US10554497B2 (en) Method for the exchange of data between nodes of a server cluster, and server cluster implementing said method
CN112630557A (en) Equipment state detection method, device, equipment and medium
CN103929377A (en) Wired network and wireless network combined dispatching method and system and related devices
CN112698838A (en) Multi-cloud container deployment system and container deployment method thereof
CN116915827A (en) Data transmission method and device of internet of things edge gateway, electronic equipment and medium
CN114500644A (en) Internet of things data management method in municipal facility monitoring system
CN109542841A (en) The method and terminal device of data snapshot are created in cluster
CN113452732A (en) Power Internet of things network management system and method
EP3386171B1 (en) Common gateway platform
CN113848834B (en) Workshop equipment access system and method based on edge cloud cooperation
CN113873033B (en) Intelligent edge computing gateway platform with fault-tolerant function
CN115858196A (en) Agile event processing method and notification system thereof
EP2506605B1 (en) Service management system and method based on machine to machine
CN111782322A (en) Intranet and extranet message communication server and system based on cloud desktop server

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant