Intelligent warehouse management method capable of offline operation on multiple terminals

Abstract

The intelligent warehouse management system can operate in online mode and offline mode and switch seamlessly, reducing the cost and time required for warehouse construction and renovation. It not only realizes the integrated management of online intelligent warehouses with multi-point configuration, but also meets the warehouse's independent operation capability when the network is disconnected. [Solution] The intelligent warehouse management method proposed in this invention, which can be operated offline by multiple terminals, includes: configuring an MQTT server in the management server; adding a local database to the intelligent terminal; setting up corresponding connection interfaces in the management server according to multiple terminal identifiers of the intelligent warehouse; and registering multiple message queues in the MQTT server according to the connection interfaces and terminal identifiers; determining the network status after receiving a data transmission command; if the network status is normal, transmitting data between the intelligent terminal and the management server via the MQTT server; if the network status is abnormal, the intelligent terminal stores the data to be transmitted in a local database, stores the data transmission command in the corresponding message queue, and attempts to transmit the data several times.

Description

[Technical Field]

[0001] The present invention relates to the technical field of warehouse management, and more particularly to an intelligent warehouse management method capable of multi-terminal offline operation. [Background technology]

[0002] An intelligent warehouse refers to a warehouse that uses modern technologies such as computer technology, network technology, artificial intelligence technology, IoT sensor technology, and robot technology as modern management tools, thereby achieving functions such as automatic registration of materials being put into and taken out of the warehouse, automatic shelving, automatic collection, automatic inventory, and automatic statistical analysis, and compared with traditional warehouses, it has the characteristics of highly informatized, automated, and intelligent, and can greatly improve the efficiency and sophistication of warehouse management. Currently, there are mainly three types of overall structures for intelligent warehouses:

[0003] 1. Standalone intelligent warehouses are mainly used in small warehouses with single-point configurations or self-service counters. Data storage, operation logic control, and hardware device control all run on intelligent terminals on the network or the warehouse's local LAN, and the system operates independently, making it suitable for small-scale, special scenarios in off-network environments.

[0004] 2. Online intelligent warehousing is mainly applied to small and medium-sized multi-site warehouses. The system uses a network structure of server + network + intelligent terminal, with data storage and operation logic control both running on the server, and the intelligent terminals in each site-located warehouse only function as interactive terminals and hardware control hosts. The terminals and server form an integrated system using the Internet or a company's internal network, working together through real-time data exchange and command control to jointly achieve intelligent warehouse operation. This structure is suitable for scenarios where the site-located warehouse is scattered and the network conditions are poor.

[0005] 3. Distributed cloud-based intelligent warehouses are primarily used in large, cross-regional warehouses and logistics stations. The system uses a distributed architecture of cloud server + WAN + local server + LAN + intelligent terminals. Data storage and high-level operation logic control run on the cloud server, while local data storage and front-end operation logic control run on the local server. The local server serves as data storage and operation logic control for the warehouse in its current region, communicating with the warehouse's intelligent terminals via the LAN to perform control. The cloud server and local server occasionally synchronize data and automatically execute tasks via the WAN, and even if the connection between the two is lost, it does not affect the basic functions of the local warehouse management system. This architecture is applicable to scenarios such as widely distributed enterprise multi-site warehouses or large-scale chain warehouses and logistics stations.

[0006] When it comes to meeting actual needs, there are still many scenarios that the above three intelligent warehousing technologies cannot solve, for example, many enterprises have factories and warehouses scattered across different regions, each with its own internal network system, and they need to place their information systems within the internal network system, but it is impossible to guarantee that the internal network will always be operational, so the warehouse management system not only provides integrated management across regions, but can also operate offline when the internal network is down, and also reduces the construction and maintenance costs of the warehouse system. Although the three existing types of intelligent warehousing have their own characteristics, when targeting this scenario, the following problems still exist:

[0007] 1. In stand-alone intelligent warehouses, the number of manageable materials is small, data is closed, and only local input and inquiry is supported using information such as material data and warehouse records. Warehouse information in various regions is not interconnected, and the level of informationization is low, making it impossible to meet enterprises' requirements for integrated management and allocation of warehouse materials.

[0008] 2. In an online intelligent warehouse, the network must be constantly connected and data must be constantly exchanged between the server and terminal devices. If the network is interrupted or the server goes down, the entire system will be paralyzed, preventing normal stocking and retrieval from all warehouses and reducing the system's fault isolation ability.

[0009] 3. Distributed cloud intelligent warehouses have a complex structure, requiring regional servers to be located at centralized points in each warehouse, operation data and operation logic to be divided according to stages, and the cloud server and regional server to cooperate and exchange data. This requires complex software system design, a long system construction cycle, and high costs. Summary of the Invention [Problem to be solved by the invention]

[0010] The present invention proposes an intelligent warehouse management method that allows for multi-terminal offline operation, thereby enabling the intelligent warehouse management system to operate in online mode and offline mode and switch seamlessly between them, reducing the cost and time required for warehouse construction and renovation, and not only realizing the integrated management of multi-point deployment warehouses in an online intelligent warehouse, but also meeting the warehouse's ability to operate independently even when the network is disconnected. [Means for solving the problem]

[0011] S1: Deploy an MQTT server on the management server and add a local database to the intelligent terminal; S2: Set up corresponding connection interfaces in the management server according to multiple terminal identifiers of the intelligent warehouse, and register multiple message queues in the MQTT server according to the connection interfaces and terminal identifiers; S3: After receiving a data transmission command, determine the network status, and if the network status is normal, transmit data between the intelligent terminal and the management server through the MQTT server; S4: When the network status is abnormal, the intelligent terminal stores the data to be transmitted in a local database, stores the data transmission command in a corresponding message queue, and attempts to transmit the data several times until the maximum transmission number is exceeded.

[0012] Preferably, when detecting data transmission between a plurality of intelligent terminals and the management server, establishing a communication connection between the current transmitting intelligent terminal and other intelligent terminals through the LAN based on the terminal identification; The method further includes transmitting new data generated during the data transmission to another intelligent terminal based on the communication connection.

[0013] Preferably, in the step of S1: configuring an MQTT server in the management server and adding a local database to the intelligent terminal, The substep of deploying the MQTT server on the management server is Obtaining an MQTT data transmission format between the server and the 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 a connection between the deployed MQTT server, the management server and the intelligent terminal through a communication protocol, and deploying the deployed MQTT server on the management server; The substep of adding a local database to the intelligent terminal is Adding a local database to the intelligent terminal; Establishing a storage connection between the data information managed by the intelligent terminal and the local database, and establishing a storage connection for the user's operation information in the intelligent terminal.

[0014] Preferably, the step of: S2: setting up corresponding connection interfaces in the management server according to a plurality of terminal identifiers of the intelligent warehouse, and registering a plurality of message queues in the MQTT server according to the connection interfaces and the terminal identifiers; S21: Achieving the configuration of connection interfaces according to the network information of a plurality of terminals of the intelligent warehouse and the local LAN; S22: After the configuration of the connection interface is completed, register a message queue according to the address information of the connection interface and the indicator information of the terminal indicator, and perform integrated management on the message queue according to the management information of the communication protocol.

[0015] Preferably, the substep of accomplishing the configuration of the connection interface according to the network information of the plurality of terminals of the intelligent warehouse and the local LAN is: Determine model parameters and data transmission type of the intelligent warehouse according to multiple terminal symbols of the intelligent warehouse; determine an interface type of the connection interface according to the model parameters; determine a data processing mode of the connection interface according to the data transmission type; and determine a connection protocol of the connection interface according to the local LAN; The method includes generating interface configuration information of the connection interface based on the interface type, the data processing mode, and the connection protocol, determining the execution unit of the required management server to be called by the connection interface based on the interface configuration information, and configuring the execution unit and the connection interface according to the interface configuration information, thereby realizing the configuration of the connection interface.

[0016] Preferably, the substep of registering a message queue according to the address information of the connection interface and the indicator information of the terminal indicator, and performing integrated management on the message queue according to management information of a communication protocol, comprises: Obtaining first registration information according to the address information of the connection interface, obtaining second registration information according to the identification information of the terminal identification, obtaining target registration information according to the first registration information and the second registration information, and determining management parameters according to a communication protocol; Build a message queue set according to the target registration information, and obtain corresponding target registration information sent to the MQTT server from the message queue in the message queue set, and build a connection relationship between the message queue and the corresponding target registration information, and register message queues corresponding to each intelligent terminal according to the connection relationship and the target registration information; and performing integrated management of all message queues in the message queue set using the management parameters.

[0017] Preferably, the step of: S3: determining a network status after receiving a data transmission command; and transmitting data between the intelligent terminal and the management server through the MQTT server if the network status is normal; After receiving the data transmission command, obtain the data flow rate generated by the MQTT server in a preset period and the average cached data amount per unit time, and calculate a first network detection value of the MQTT server according to the data flow rate generated in the preset period and the average cached data amount per unit time; determining whether the first network detection value is greater than a first preset detection value; If so, determine that the network condition is functioning normally; otherwise, determining that the network condition is abnormally functioning; Calculating a second network detection value of the MQTT server based on the first network detection value in combination with a numerical range of the amount of data actually received by the MQTT server in a unit time, a change rate of the amount of data cached in the MQTT server between adjacent time points, and the number of recent data transmissions, the amount of data transmission, and the time of data transmission; determining whether the second network detection value is greater than a second preset detection value; If so, it determines that the network state is congested, adds the data transmission command to a data transmission message queue, and waits for a response; otherwise, determining that the network condition is functioning abnormally.

[0018] Preferably, the step of: S4: when the network status is abnormal, the intelligent terminal stores the data to be transmitted in a local database, and stores the data transmission command in a corresponding message queue, and tries to transmit the data several times until the maximum transmission number is exceeded; S41: When it is determined that the data transmission from the intelligent terminal to the MQTT server fails due to an abnormal network state, the transmitted data is stored in a local database, and a data transmission command is stored in a corresponding message queue, and the synchronous state is marked as asynchronous; S42: Detecting the data transmission status before the network state is normal, and determining the final transmission information; S43: Obtain the latest transmission command corresponding to the last sent information, and update the data transmission command in the corresponding message queue according to the latest transmission command, and mark the synchronization status in the corresponding message queue as synchronized after the data transmission of the MQTT server is completed according to the latest transmission command; S44: If it is detected that the network status is still functioning abnormally after the maximum number of transmissions has been exceeded based on the first fixed-time task, sending a warning to the intelligent terminal that the execution of the data transmission command has failed.

[0019] Preferably, the sub-step of detecting a data transmission situation before the network state is functioning normally and determining final transmission information includes: Setting a first time period and combining it with a network judgment task to obtain a first fixed-time task, setting a second time period and combining it with a transmission monitoring task to obtain a second fixed-time task, and detecting the network status according to the first time period until it is determined that the network status is functioning normally, and determining the time when the network status is functioning normally; According to the second scheduled task, detect the transmission status before the time point, obtain multiple groups of transmission information, and determine whether there is a contradiction between the multiple groups of transmission information; If so, select the transmission information closest to said time as the final transmission information; Otherwise, the multiple groups of transmissions are combined into a final transmission.

[0020] Preferably, the method further includes, when the intelligent terminal receives data transmission from the MQTT server and the transmission is successful, updating a local database based on the received data, and transmitting the received data to other intelligent terminals using a local LAN and a terminal identifier. [Effects of the Invention]

[0021] Additional features and advantages of the invention will be set forth hereinafter and in part will be apparent from the description or may become apparent through the practice of the invention. The objectives and other advantages of the invention will be attained through the structure set forth in the written description and claims, as well as in the drawings.

[0022] We will now explain the technical means of the present invention in more detail in combination with drawings and embodiments. [Brief explanation of the drawings]

[0023] The drawings serve to provide a further understanding of the invention and constitute a part of the description and serve to explain the invention together with examples of the invention, but do not limit the invention.

[0024] [Figure 1] 1 is a flowchart of a multi-terminal offline intelligent warehouse management method according to an embodiment of the present invention; [Figure 2] 1 is a flow diagram for registering multiple message queues in an embodiment of the present invention. [Figure 3] 3 is a flow chart illustrating data transmission under network abnormality conditions in an embodiment of the present invention; DETAILED DESCRIPTION OF THE INVENTION

[0025] We will now describe in more detail preferred embodiments of the present invention in combination with the drawings. It should be understood that the preferred embodiments described herein are for the purpose of explaining and interpreting the present invention, and are not intended to limit the present invention.

[0026] Example 1 As shown in FIG. 1, the intelligent warehouse management method proposed in the present invention allows offline operation of multiple terminals. S1: Deploy an MQTT server on the management server and add a local database to the intelligent terminal; S2: Set up corresponding connection interfaces in the management server according to multiple terminal identifiers of the intelligent warehouse, and register multiple message queues in the MQTT server according to the connection interfaces and terminal identifiers; S3: After receiving a data transmission command, determine the network status, and if the network status is normal, transmit data between the intelligent terminal and the management server through the MQTT server; S4: When the network status is abnormal, the intelligent terminal stores the data to be transmitted in a local database, and stores the data transmission command in a corresponding message queue, and tries to transmit the data several times until the maximum transmission number is exceeded.

[0027] In this embodiment, one intelligent terminal corresponds to one local database, and for a Windows system terminal, it may use databases such as MS-SQL, MySql, MS-Access, or SQLite for local data cache, and for an Android terminal, it may use a SQLite database for local data cache.

[0028] In this embodiment, a unique identifier is set in the software for each intelligent terminal, and a multi-terminal configuration interface is set in the software on the server side. Multiple message queues are registered in the MQTT server according to the number and identifiers of configured terminals, so that each terminal can monopolize one message queue and can ensure that each terminal receives synchronous data from the server.

[0029] In this embodiment, multiple transmission attempts are performed after the network is restored.

[0030] The beneficial effects of the above technical measures are as follows: By using the MQTT service as an intermediary, the data synchronization interfaces of the online and offline systems can be unified, avoiding the development of two sets of data interfaces, reducing the complexity of the software system and the development and conversion costs. It also focuses on software alone, eliminating the need for additional hardware facilities. This means that the intelligent warehouse management system can operate in both online and offline modes and seamlessly switch between them. This reduces the cost and time required for warehouse construction and renovation. It not only realizes the integrated management of multi-location warehouses in online intelligent warehouses, but also allows warehouses to operate independently even when the network is disconnected. This not only solves the problem of online intelligent warehouses becoming completely paralyzed when the network is disconnected, but also addresses the shortcomings of standalone intelligent warehouses, such as limited manageable materials, closed data, and low informationization.

[0031] Example 2 According to the first embodiment, the intelligent warehouse management method proposed in the present invention can be implemented offline on multiple terminals: When detecting data transmission between a plurality of intelligent terminals and the management server, establishing a communication connection between the current transmitting intelligent terminal and other intelligent terminals through the LAN based on terminal identification; The method further includes transmitting new data generated during the data transmission to another intelligent terminal based on the communication connection.

[0032] The beneficial effects of the above technical measures are as follows: When there are multiple intelligent terminals in a warehouse, each terminal transmits the latest generated data to other intelligent terminals in the same warehouse via the local LAN and the terminal's unique identifier, thereby maintaining the consistency of the local cache data of multiple terminals in the same warehouse and realizing terminal data sharing.

[0033] Example 3 According to the first embodiment, the intelligent warehouse management method proposed in the present invention is capable of offline operation of multiple terminals. In the step S1: configuring an MQTT server in the management server and adding a local database to the intelligent terminal, The substep of deploying the MQTT server on the management server is Obtaining an MQTT data transmission format between the server and the 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; It includes establishing a connection between the deployed MQTT server, the management server and the intelligent terminal via a communication protocol, and deploying the deployed MQTT server on the management server.

[0034] The substep of adding a local database to the intelligent terminal is Adding a local database to the intelligent terminal; Establishing a storage connection between the data information managed by the intelligent terminal and the local database, and establishing a storage connection for the user's operation information in the intelligent terminal.

[0035] The beneficial effects of the above technical measures are as follows: by deploying an MQTT server on the management server and adding a local database on the intelligent terminal, a relay connection between the management server and the intelligent terminal can be achieved, data transmission can be realized in both online and offline modes, and the warehouse can operate independently even when the network is disconnected. Data can be stored in the intelligent terminal, avoiding the need to develop two sets of data interfaces and reducing the complexity of the software system and the development and conversion costs.

[0036] Example 4 Based on the first embodiment, as shown in FIG. 2, the intelligent warehouse management method proposed in the present invention is capable of offline operation of multiple terminals, and includes the steps of: S2: setting up corresponding connection interfaces in the management server according to the multiple terminal identifiers of the intelligent warehouse, and registering multiple message queues in the MQTT server according to the connection interfaces and the terminal identifiers; S21: Achieve the configuration of connection interfaces according to the network information of a plurality of terminals of the intelligent warehouse and the local LAN; S22: After the configuration of the connection interface is completed, register a message queue according to the address information of the connection interface and the indicator information of the terminal indicator, and perform integrated management on the message queue according to the management information of the communication protocol.

[0037] In this embodiment, the substep of accomplishing the configuration of the connection interface according to the network information of the plurality of terminals in the intelligent warehouse and the local LAN includes: Determine model parameters and data transmission type of the intelligent warehouse according to multiple terminal symbols of the intelligent warehouse; determine an interface type of the connection interface according to the model parameters; determine a data processing mode of the connection interface according to the data transmission type; and determine a connection protocol of the connection interface according to the local LAN; The method includes generating interface configuration information of the connection interface based on the interface type, the data processing mode, and the connection protocol, determining the execution unit of the required management server to be called by the connection interface based on the interface configuration information, and configuring the execution unit and the connection interface according to the interface configuration information, thereby realizing the configuration of the connection interface.

[0038] In this embodiment, after the configuration of the connection interface is completed, the substep of registering a message queue according to the address information of the connection interface and the indicator information of the terminal indicator, and performing integrated management of the message queue according to the management information of the communication protocol is performed: Obtaining first registration information according to the address information of the connection interface, obtaining second registration information according to the identification information of the terminal identification, obtaining target registration information according to the first registration information and the second registration information, and determining management parameters according to a communication protocol; Build a message queue set according to the target registration information, and obtain corresponding target registration information sent to the MQTT server from the message queue in the message queue set, and build a connection relationship between the message queue and the corresponding target registration information, and register message queues corresponding to each intelligent terminal according to the connection relationship and the target registration information; and performing integrated management of all message queues in the message queue set using the management parameters.

[0039] The beneficial effects of the above technical measures are as follows: a unique connection interface is set up for each intelligent terminal, enabling a safe and orderly connection between each intelligent terminal and the management server, preventing mis-transmission and theft of information; then, multiple message queues are registered in the MQTT server according to the number and identification of deployed terminals, ensuring that each terminal has exclusive access to one message queue and receives synchronized data from the server; this addresses the shortcomings of stand-alone intelligent warehouses, such as limited manageable materials, closed data, and low informationization.

[0040] Example 5 According to the fourth embodiment, in the intelligent warehouse management method capable of multi-terminal offline operation proposed in the present invention, the substep of accomplishing the configuration of connection interfaces according to the network information of the multiple terminals of the intelligent warehouse and the local LAN includes: Determine model parameters and data transmission type of the intelligent warehouse according to multiple terminal symbols of the intelligent warehouse; determine an interface type of the connection interface according to the model parameters; determine a data processing mode of the connection interface according to the data transmission type; and determine a connection protocol of the connection interface according to the local LAN; The method includes generating interface configuration information of the connection interface based on the interface type, the data processing mode, and the connection protocol, determining the execution unit of the required management server to be called by the connection interface based on the interface configuration information, and configuring the execution unit and the connection interface according to the interface configuration information, thereby realizing the configuration of the connection interface.

[0041] In this embodiment, the execution unit and the connection interface are configured according to the interface configuration information to perform the execution function of the connection interface.

[0042] The beneficial effects of the above technical measures are as follows: based on the unique connection interface set up for each intelligent terminal, it realizes a safe and orderly connection between each intelligent terminal and the management server, avoiding erroneous transmission and theft of information; and by generating interface configuration information for the connection interface based on the interface type, the data processing mode and the connection protocol, it ensures the feasibility and security of the generated connection interface.

[0043] Example 6 According to the fourth embodiment, in the intelligent warehouse management method capable of offline operation of multiple terminals proposed in the present invention, the substep of registering a message queue according to the address information of the connection interface and the identification information of the terminal identification, and performing integrated management of the message queue according to the management information of the communication protocol, Obtaining first registration information according to the address information of the connection interface, obtaining second registration information according to the identification information of the terminal identification, obtaining target registration information according to the first registration information and the second registration information, and determining management parameters according to a communication protocol; Build a message queue set according to the target registration information, and obtain corresponding target registration information sent to the MQTT server from the message queue in the message queue set, and build a connection relationship between the message queue and the corresponding target registration information, and register message queues corresponding to each intelligent terminal according to the connection relationship and the target registration information; and performing integrated management of all message queues in the message queue set using the management parameters.

[0044] In this embodiment, the communication protocol is designed according to the characteristics of the intelligent terminal and the management server.

[0045] The beneficial effects of the above technical measures are as follows: by establishing a connection relationship between a message queue and the corresponding target registration information, and registering a message queue corresponding to each intelligent terminal according to the connection relationship and the target registration information, a one-to-one correspondence between the message queues in the message queue set and the intelligent terminals is realized, and the management parameters are used to perform unified management of all message queues in the message queue set, ensuring that each terminal has exclusive access to one message queue and receives synchronous data from the server. This overcomes the shortcomings of stand-alone intelligent warehouses, such as limited manageable materials, closed data, and low informationization.

[0046] Example 7 According to Example 1, in the intelligent warehouse management method capable of offline operation of multiple terminals proposed in the present invention, the step of S3: determining the network status after receiving a data transmission command, and transmitting data between the intelligent terminal and the management server via the MQTT server if the network status is normal, includes the following substeps:

[0047] After receiving a data transmission command, obtain the data flow rate generated by the MQTT server in a preset period and the average cached data volume per unit time, and calculate a first network detection value of the MQTT server according to the data flow rate generated in the preset period and the average cached data volume per unit time.

[0048] The calculation formula for the first network detection value is as follows:

number

[0049] In the formula, R1 represents the first network detection value, and Q r represents the data flow generated by the MQTT server in a preset period, and Q max represents the maximum data flow generated by the MQTT server in the preset period during the historical flow monitoring of the MQTT server, and Q min represents the minimum data flow generated by the MQTT server in a preset period during historical flow monitoring of the MQTT server, and N r represents the average amount of cached data in the MQTT server in a unit time, and N0 represents the standard average amount of cached data generated in the MQTT server in a unit time when the network condition is normal.

[0050] determining whether the first network detection value is greater than a first preset detection value; If so, it determines that the network is functioning normally. If not, it determines that the network condition is functioning abnormally.

[0051] Based on the first network detection value, a second network detection value of the MQTT server is calculated in combination with a numerical range of the amount of data actually received by the MQTT server in a unit time, a rate of change of the amount of data cached in the MQTT server between adjacent time points, and the number of recent data transmissions, the amount of data transmission, and the data transmission time.

[0052] The calculation formula for the second network detection value is as follows:

number

[0053] In the formula, R2 represents the second network detection value of the MQTT server, and ε a represents the rate of change in the amount of data cached in the MQTT server between adjacent points in time, and N a represents the range of the amount of data received by the MQTT server in real time per unit time, n represents the number of recent data transmissions, and S i represents the data transmission volume of the i-th data transmission, and t i represents the data transmission time of the i-th data transmission, and S i+1 represents the data transmission amount of the (i+1)th data transmission, and t i+1 represents the data transmission time of the (i+1)th data transmission.

[0054] determining whether the second network detection value is greater than a second preset detection value; If so, it determines that the network is congested, adds a data transmission command to the data transmission message queue, and waits for a response; If not, it determines that the network condition is functioning abnormally.

[0055] In this embodiment, the abnormal network status indicates that the network is offline.

[0056] The beneficial effects of the above technical measures are as follows: by calculating and analyzing the network status parameters and events of the MQTT server, and determining whether the network status is functioning abnormally through a single calculation, it is possible to avoid determining that the network status is functioning abnormally due to excessive transmission tasks that cause network congestion, thereby ensuring the accuracy of network status determination and thereby ensuring the validity of the data transmission method.

[0057] Example 8 Based on the first embodiment, as shown in FIG. 3, the present invention proposes an intelligent warehouse management method capable of offline operation of multiple terminals, comprising the steps of: S4: when the network status is abnormal, the intelligent terminal stores the data to be transmitted in a local database, and stores a data transmission command in a corresponding message queue, and transmits the data several times until the maximum transmission number is exceeded; S41: When it is determined that the data transmission from the intelligent terminal to the MQTT server fails due to an abnormal network state, the transmitted data is stored in a local database, and a data transmission command is stored in a corresponding message queue, and the synchronous state is marked as asynchronous; S42: Detecting the data transmission status before the network state is normal, and determining the final transmission information; S43: Obtain the latest transmission command corresponding to the last sent information, and update the data transmission command in the corresponding message queue according to the latest transmission command, and mark the synchronization status in the corresponding message queue as synchronized after the data transmission of the MQTT server is completed according to the latest transmission command; S44: If it is detected that the network status is still functioning abnormally after the maximum number of transmissions has been exceeded based on the first fixed-time task, sending a warning to the intelligent terminal that the execution of the data transmission command has failed.

[0058] In this embodiment, the substep of detecting the data transmission status before the network state is functioning normally and determining the final transmission information is: Setting a first time period and combining it with a network judgment task to obtain a first fixed-time task, setting a second time period and combining it with a transmission monitoring task to obtain a second fixed-time task, and detecting the network status according to the first time period until it is determined that the network status is functioning normally, and determining the time when the network status is functioning normally; According to the second scheduled task, detect the transmission status before the time point, obtain multiple groups of transmission information, and determine whether there is a contradiction between the multiple groups of transmission information; If so, select the transmission information closest to said time as the final transmission information; Otherwise, the multiple groups of transmissions are combined into a final transmission.

[0059] The beneficial effects of the above technical measures are as follows: When the network is malfunctioning, the warehouse's intelligent terminals fail to send newly generated data messages to the MQTT server. They attempt to cache the data in a local database (including the updated data content, generation time, message type, synchronization status, etc.), and then perform scheduled tasks to determine the network status. When the network returns to normal, they attempt to send the data to the MQTT server again. If the data is successfully sent to the MQTT server, the synchronization status of the locally cached data is changed; otherwise, the data is resent until the preset maximum transmission count is exceeded. This enables the warehouse to operate independently even when the network is disconnected. This not only solves the problem of online intelligent warehouses becoming completely paralyzed when the network is disconnected, but also addresses the shortcomings of standalone intelligent warehouses: limited manageable resources, closed data, and low informationization. By using the MQTT service as an intermediary, the data synchronization interfaces of the online and offline systems can be unified, avoiding the development of two sets of data interfaces and reducing the complexity of the software system and the development and conversion costs.

[0060] Example 9 According to the eighth embodiment, in the intelligent warehouse management method capable of offline operation of multiple terminals proposed in the present invention, the substep of detecting the data transmission status before the network state is normal and determining the final transmission information is: Setting a first time period and combining it with a network judgment task to obtain a first fixed-time task, setting a second time period and combining it with a transmission monitoring task to obtain a second fixed-time task, and detecting the network status according to the first time period until it is determined that the network status is functioning normally, and determining the time when the network status is functioning normally; According to the second scheduled task, detect the transmission status before the time point, obtain multiple groups of transmission information, and determine whether there is a contradiction between the multiple groups of transmission information; If so, select the transmission information closest to said time as the final transmission information; Otherwise, the multiple groups of transmissions are combined into a final transmission.

[0061] The beneficial effects of the above technical measures are as follows: by setting up network task monitoring and transmission task monitoring and analyzing them in the time dimension, the latest transmission information can be determined, and whether there is a contradiction between the multiple groups of transmission information can be determined. When offline data is synchronized, if the receiver finds multiple conflicting data transmissions, the latest data can be selected as the final data transmission according to the time of data generation, preventing the transmission of old data from wasting resources and causing data confusion, and realizing data synchronization between the intelligent terminal and the MQTT server.

[0062] Example 10 According to the first embodiment, the intelligent warehouse management method capable of multi-terminal offline operation proposed in the present invention further includes: when an intelligent terminal receives data transmission from an MQTT server and the transmission is successful, updating a local database according to the received data, and transmitting the received data to other intelligent terminals using a local LAN and a terminal identifier.

[0063] The beneficial effects of the above technical means are as follows: When there are multiple intelligent terminals in a warehouse, each terminal transmits the latest generated data to other intelligent terminals in the same warehouse via the local LAN and the unique identifier of the terminal, thereby maintaining the consistency of the local cache data of multiple terminals in the same warehouse.

[0064] (Addendum) (Appendix 1) S1: Deploy an MQTT server on the management server and add a local database to the intelligent terminal; S2: Set up corresponding connection interfaces in the management server according to multiple terminal identifiers of the intelligent warehouse, and register multiple message queues in the MQTT server according to the connection interfaces and terminal identifiers; S3: After receiving a data transmission command, determine the network status, and if the network status is normal, transmit data between the intelligent terminal and the management server through the MQTT server; S4: When the network status is abnormal, the intelligent terminal stores the data to be transmitted in a local database and stores the data transmission command in a corresponding message queue, and tries to transmit the data several times until the maximum transmission number is exceeded; An intelligent warehouse management method capable of offline operation of multiple terminals.

[0065] (Appendix 2) When detecting data transmission between a plurality of intelligent terminals and the management server, establishing a communication connection between the current transmitting intelligent terminal and other intelligent terminals through the LAN based on terminal identification; and transmitting new data generated during the data transmission to another intelligent terminal based on the communication connection. The intelligent warehouse management method according to claim 1, characterized in that it allows offline operation of multiple terminals.

[0066] (Appendix 3) S1: In the step of deploying the MQTT server on the management server and adding a local database to the intelligent terminal, The substep of deploying the MQTT server on the management server is Obtaining an MQTT data transmission format between the server and the 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 a connection between the deployed MQTT server, the management server and the intelligent terminal through a communication protocol, and deploying the deployed MQTT server on the management server; The substep of adding a local database to the intelligent terminal is Adding a local database to the intelligent terminal; establishing a storage connection between the data information managed by the intelligent terminal and a local database, and establishing a storage connection of the user's operation information in the intelligent terminal; The intelligent warehouse management method according to claim 1, characterized in that it allows offline operation of multiple terminals.

[0067] (Appendix 4) S2: setting up corresponding connection interfaces in the management server according to multiple terminal identifiers of the intelligent warehouse, and registering multiple message queues in the MQTT server according to the connection interfaces and terminal identifiers; Achieving the configuration of connection interfaces according to the network information of the multiple terminals of the intelligent warehouse and the local LAN; After the configuration of the connection interface is completed, registering a message queue according to the address information of the connection interface and the indicator information of the terminal indicator, and performing integrated management of the message queue according to the management information of the communication protocol; The intelligent warehouse management method according to claim 1, characterized in that it allows offline operation of multiple terminals.

[0068] (Appendix 5) a substep of accomplishing the configuration of connection interfaces according to the network information of the plurality of terminals in the intelligent warehouse and the local LAN; Determine model parameters and data transmission type of the intelligent warehouse according to multiple terminal symbols of the intelligent warehouse; determine an interface type of the connection interface according to the model parameters; determine a data processing mode of the connection interface according to the data transmission type; and determine a connection protocol of the connection interface according to the local LAN; generating interface configuration information of the connection interface according to the interface type, the data processing mode and the connection protocol; determining an execution unit of a required management server to be called by the connection interface according to the interface configuration information; and configuring the execution unit and the connection interface according to the interface configuration information to realize the configuration of the connection interface; The intelligent warehouse management method according to claim 4, characterized in that it is capable of offline operation of multiple terminals.

[0069] (Appendix 6) a sub-step of registering a message queue according to the address information of the connection interface and the indicator information of the terminal indicator, and performing integrated management of the message queue according to management information of a communication protocol; Obtaining first registration information according to the address information of the connection interface, obtaining second registration information according to the identification information of the terminal identification, obtaining target registration information according to the first registration information and the second registration information, and determining management parameters according to a communication protocol; Build a message queue set according to the target registration information, and obtain corresponding target registration information sent to the MQTT server from the message queue in the message queue set, and build a connection relationship between the message queue and the corresponding target registration information, and register message queues corresponding to each intelligent terminal according to the connection relationship and the target registration information; performing integrated management of all message queues in the message queue set using the management parameters; The intelligent warehouse management method according to claim 4, characterized in that it is capable of offline operation of multiple terminals.

[0070] (Appendix 7) S3: After receiving a data transmission command, determine the network status; if the network status is normal, transmit data between the intelligent terminal and the management server through the MQTT server; After receiving the data transmission command, obtain the data flow rate generated by the MQTT server in a preset period and the average cached data amount per unit time, and calculate a first network detection value of the MQTT server according to the data flow rate generated in the preset period and the average cached data amount per unit time; determining whether the first network detection value is greater than a first preset detection value; If so, determine that the network condition is functioning normally; otherwise, determining that the network condition is abnormally functioning; Calculating a second network detection value of the MQTT server based on the first network detection value in combination with a numerical range of the amount of data actually received by the MQTT server in a unit time, a change rate of the amount of data cached in the MQTT server between adjacent time points, and the number of recent data transmissions, the amount of data transmission, and the time of data transmission; determining whether the second network detection value is greater than a second preset detection value; If so, it determines that the network state is congested, adds the data transmission command to a data transmission message queue, and waits for a response; otherwise, determining that the network condition is abnormally functioning. The intelligent warehouse management method according to claim 1, characterized in that it allows offline operation of multiple terminals.

[0071] (Appendix 8) S4: when the network status is abnormal, the intelligent terminal stores the data to be transmitted in a local database and stores the data transmission command in a corresponding message queue, and tries to transmit the data several times until the maximum transmission number is exceeded; When it is determined that the data transmission from the intelligent terminal to the MQTT server fails due to an abnormal network function, the transmitted data is stored in a local database, and the data transmission command is stored in a corresponding message queue, and the synchronous state is marked as asynchronous; Detecting the data transmission status before the network state is normal and determining the final transmission information; Obtain the latest transmission command corresponding to the last sent information, and update the data transmission command in the corresponding message queue according to the latest transmission command, and mark the synchronization status in the corresponding message queue as synchronized after the data transmission of the MQTT server is completed according to the latest transmission command; and sending a warning to the intelligent terminal that the execution of the data transmission command has failed when the network status is still abnormally functioning after the detection of the network status based on the first fixed-time task exceeds the maximum number of transmissions. The intelligent warehouse management method according to claim 1, characterized in that it allows offline operation of multiple terminals.

[0072] (Appendix 9) a substep of detecting the data transmission status before the network state is functioning normally and determining the final transmission information; Setting a first time period and combining it with a network judgment task to obtain a first fixed-time task, setting a second time period and combining it with a transmission monitoring task to obtain a second fixed-time task, and detecting the network status according to the first time period until it is determined that the network status is functioning normally, and determining the time when the network status is functioning normally; According to the second scheduled task, detect the transmission status before the time point, obtain multiple groups of transmission information, and determine whether there is a contradiction between the multiple groups of transmission information; If so, select the transmission information closest to said time as the final transmission information; otherwise, the multiple groups of transmission information are collectively treated as the final transmission information. The intelligent warehouse management method according to claim 8, characterized in that it is capable of offline operation of multiple terminals.

[0073] (Appendix 10) The method further includes, when the intelligent terminal receives data transmitted from the MQTT server and the transmission is successful, updating a local database according to the received data, and transmitting the received data to other intelligent terminals using a local LAN and a terminal identifier; The intelligent warehouse management method according to claim 1, characterized in that it allows offline operation of multiple terminals.

Claims

1. S1: Deploy an MQTT server on the management server and add a local database to the intelligent terminal; S2: Set up corresponding connection interfaces in the management server according to multiple terminal identifiers of the intelligent warehouse, and register multiple message queues in the MQTT server according to the connection interfaces and terminal identifiers; S3: After receiving the data transmission command, determine the network status, and if the network status is normal, transmit data between the intelligent terminal and the management server through the MQTT server; S4: When the network status is abnormal, the intelligent terminal stores the data to be transmitted in a local database, and stores the data transmission command in a corresponding message queue, and tries to transmit the data several times until the maximum transmission number is exceeded; An intelligent warehouse management method capable of offline operation of multiple terminals.

2. When detecting data transmission between the plurality of intelligent terminals and the management server, establishing a communication connection between the current transmitting intelligent terminal and other intelligent terminals through the LAN based on the terminal identification; and transmitting new data generated during the data transmission to another intelligent terminal based on the communication connection.

2. The intelligent warehouse management method according to claim 1, wherein the intelligent warehouse management method is operable offline from multiple terminals.

3. S1: In the step of deploying an MQTT server on the management server and adding a local database to the intelligent terminal, The substep of deploying the MQTT Server on the Management Server is Obtaining an MQTT data transmission format between the server and the 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 a connection between the deployed MQTT server, the management server, and the intelligent terminal via a communication protocol, and deploying the deployed MQTT server on the management server; The substep of adding a local database to the intelligent terminal is Adding a local database to the intelligent terminal; establishing a storage connection between the data information managed by the intelligent terminal and the local database, and establishing a storage connection of the user's operation information in the intelligent terminal; 2. The intelligent warehouse management method according to claim 1, wherein the intelligent warehouse management method is operable offline from multiple terminals.

4. S2: Setting up corresponding connection interfaces in the management server according to multiple terminal identifiers of the intelligent warehouse, and registering multiple message queues in the MQTT server according to the connection interfaces and terminal identifiers; Achieving the configuration of connection interfaces according to the network information of the plurality of terminals of the intelligent warehouse and the local LAN; After the configuration of the connection interface is completed, registering a message queue according to the address information of the connection interface and the indicator information of the terminal indicator, and performing integrated management of the message queue according to the management information of the communication protocol; 2. The intelligent warehouse management method according to claim 1, wherein the intelligent warehouse management method is operable offline from multiple terminals.

5. A substep of accomplishing the configuration of connection interfaces according to the network information of the plurality of terminals of the intelligent warehouse and the local LAN; Determine model parameters and data transmission type of the intelligent warehouse according to multiple terminal identifiers of the intelligent warehouse; determine an interface type of the connection interface according to the model parameters; determine a data processing mode of the connection interface according to the data transmission type; and determine a connection protocol of the connection interface according to a local LAN; generating interface configuration information of the connection interface according to the interface type, the data processing mode and the connection protocol; determining an execution unit of a required management server to be called by the connection interface according to the interface configuration information; and configuring the execution unit and the connection interface according to the interface configuration information to realize the configuration of the connection interface; 5. The intelligent warehouse management method according to claim 4, wherein the intelligent warehouse management method is operable offline from multiple terminals.

6. a sub-step of registering a message queue according to the address information of the connection interface and the indicator information of the terminal indicator, and performing integrated management of the message queue according to management information of a communication protocol; Obtaining first registration information according to the address information of the connection interface, obtaining second registration information according to the identification information of the terminal identification, obtaining target registration information according to the first registration information and the second registration information, and determining management parameters according to a communication protocol; Build a message queue set according to the target registration information, and obtain corresponding target registration information sent from the message queues in the message queue set to the MQTT Server, and build a connection relationship between the message queues and the corresponding target registration information, and register message queues corresponding to each intelligent terminal according to the connection relationship and the target registration information; performing integrated management of all message queues in the message queue set using the management parameters; 5. The intelligent warehouse management method according to claim 4, wherein the intelligent warehouse management method is operable offline from multiple terminals.

7. S3: After receiving the data transmission command, determine the network status, and if the network status is normal, transmit data between the intelligent terminal and the management server through the MQTT server; After receiving the data transmission command, obtain the data flow rate generated in the MQTT server in a preset period and the average cached data amount per unit time, and calculate a first network detection value of the MQTT server based on the data flow rate generated in the preset period and the average cached data amount per unit time; determining whether the first network detection value is greater than a first preset detection value; If so, determine that the network condition is functioning normally; otherwise, determining that the network condition is abnormally functioning; Calculating a second network detection value for the MQTT server based on the first network detection value in combination with a numerical range of the amount of data actually received by the MQTT server in a unit time, a rate of change in the amount of data cached in the MQTT server between adjacent points in time, and the number of recent data transmissions, the amount of data transmission, and the time of data transmission; determining whether the second network detection value is greater than a second preset detection value; If so, it determines that the network state is congested, adds the data transmission command to a data transmission message queue, and waits for a response; otherwise, determining that the network condition is abnormally functioning.

2. The intelligent warehouse management method according to claim 1, wherein the intelligent warehouse management method is operable offline from multiple terminals.

8. S4: when the network status is abnormal, the intelligent terminal stores the data to be transmitted in a local database and stores the data transmission command in a corresponding message queue, and tries to transmit the data several times until the maximum transmission number is exceeded; When it is determined that the data transmission from the intelligent terminal to the MQTT server fails due to an abnormal network condition, the transmitted data is stored in a local database, and a data transmission command is stored in a corresponding message queue, and the synchronous state is marked as asynchronous; Detecting the data transmission status before the network state is normal and determining the final transmission information; Obtaining the latest transmission command corresponding to the last sent information, updating the data transmission command in the corresponding message queue according to the latest transmission command, and marking the synchronization status in the corresponding message queue as synchronized after the MQTT server completes data transmission according to the latest transmission command; and sending a warning to the intelligent terminal that the execution of the data transmission command has failed when the network status is still abnormally functioning after the detection of the network status based on the first fixed-time task exceeds the maximum number of transmissions.

2. The intelligent warehouse management method according to claim 1, wherein the intelligent warehouse management method is operable offline from multiple terminals.

9. a substep of detecting the data transmission status before the network state is functioning normally and determining the final transmission information; Setting a first time period and combining it with a network judgment task to obtain a first fixed-time task, setting a second time period and combining it with a transmission monitoring task to obtain a second fixed-time task, and detecting the network status according to the first time period until it is determined that the network status is functioning normally, and determining the time when the network status is functioning normally; According to the second scheduled task, detect the transmission status before the time point, obtain multiple groups of transmission information, and determine whether there is a contradiction between the multiple groups of transmission information; If so, select the transmission information closest to said time as the final transmission information; otherwise, the multiple groups of transmission information are collectively treated as the final transmission information. The intelligent warehouse management method according to claim 8, wherein the intelligent warehouse management method is operable offline from multiple terminals.

10. The method further includes, when the intelligent terminal receives data transmission from the MQTT server and the transmission is successful, updating a local database based on the received data, and transmitting the received data to other intelligent terminals using a local LAN and a terminal identifier.

2. The intelligent warehouse management method according to claim 1, wherein the intelligent warehouse management method is operable offline from multiple terminals.

Images