A digital space display system and method based on intelligent warehousing

Abstract

A digital space display system based on intelligent warehousing includes a map generation module, a data integration module, a data visualization module, an inventory synchronization engine, an interactive terminal, and a map interaction module. The map generation module generates a 3D digital space display of the warehouse based on warehouse drawings and equipment lists, supporting the import of CAD-formatted floor plans and Excel-formatted shelf lists, and automatically generates a 3D model through coordinate analysis and coordinate system mapping algorithms. The data integration module interfaces with the WMS system and hardware system, obtaining inbound / outbound instructions and inventory change data through API interfaces. The inventory synchronization engine is electrically connected to the data integration module and a local database, used to increase or decrease inventory based on the acquired data. After an inventory update, it triggers the data visualization module to refresh the inventory status indicator on the 3D digital space display. This invention enables visualization, automation, and real-time management of warehouses, improving management efficiency.

Description

Technical Field

[0001] This invention relates to the field of warehouse management technology, and in particular to a digital space display system based on intelligent warehousing, and more specifically to a display method using the above-mentioned digital space display system based on intelligent warehousing. Background Technology

[0002] Currently, warehouse management generally relies on traditional WMS systems and static floor plans, which suffer from low visualization, fragmented data, and delayed response. After warehouse layout adjustments, 3D modeling requires manual operation by professionals, which is time-consuming and costly; key indicators such as inbound and outbound operations and inventory levels cannot be displayed intuitively on a unified interface; and data synchronization with external systems such as WMS systems is delayed, leading to discrepancies between records and actual inventory, and affecting the efficiency of management decisions. Summary of the Invention

[0003] The technical problem to be solved by the present invention is to provide a digital space display system based on intelligent warehousing, which can realize the visualization, automation and real-time of warehouse management, improve management efficiency, and effectively solve the problems of low visualization, data synchronization lag and low mapping efficiency of existing warehouse management systems.

[0004] Another technical problem to be solved by the present invention is to provide a display method using the above-mentioned intelligent warehousing-based digital space display system.

[0005] The technical problem to be solved by this invention is achieved through the following technical solution. This invention is a digital spatial display system based on intelligent warehousing, which includes a map generation module, a data integration module, a data visualization module, an inventory synchronization engine, an interactive terminal, and a map interaction module; The map generation module is used to generate a three-dimensional digital space display of the warehouse based on warehouse drawings and equipment lists. It supports importing CAD format floor plans and Excel format shelf lists, automatically generates a three-dimensional model through coordinate analysis and coordinate system mapping algorithms, and allows users to fine-tune the automatically generated three-dimensional map. The data integration module is used to interface with the WMS system and hardware system, and obtain inbound and outbound instructions and inventory change data through API interface; The inventory synchronization engine is electrically connected to the data integration module and the local database. It is used to increase or decrease inventory based on the acquired data. After the inventory is updated, the data visualization module is triggered to refresh the inventory status indicator on the three-dimensional digital space display. The data visualization module is electrically connected to the map generation module, the inventory synchronization engine, and the data integration module. It is used to overlay and display the inbound and outbound operation volume, operation efficiency, and inventory information on a three-dimensional digital space display. It uses a heat map to display the operation volume of each area and uses labels to display the shelf inventory. The interactive terminal is electrically connected to the data visualization module and is used to display three-dimensional digital space display and overlay information for large-screen data display on PC. The map interaction module is electrically connected to the interaction terminal and the local database, and is used to respond to user click operations, display the inventory details of the selected shelf, and view the operation history of each item.

[0006] The technical problem to be solved by this invention can also be further achieved through the following technical solution: For the above-mentioned digital space display system based on intelligent warehousing, the map generation module generates a three-dimensional digital map based on CAD drawings and Excel lists through the following steps: (1) Read the coordinates of the graphic elements in the CAD drawing, extract the coordinates of the four vertices of all "rectangle" graphic elements, calculate the coordinates of the center point of each rectangle, and determine the aspect ratio of the rectangle to determine the shelf, wall, or equipment; (2) Find the corresponding shelf number in the Excel list based on the center point coordinates. After a successful match, obtain the shelf type, size, and number of layers attributes. (3) The engineering coordinate system of the CAD drawing is converted into the world coordinate system of the 3D engine through a coordinate system mapping algorithm; (4) Traverse all successfully matched shelves, call the corresponding type of prefabricated model in the 3D model library, instantiate the model to world coordinates, copy the Z-axis to generate the shelf structure of each layer, generate ground grid and path markers according to the aisle boundary, add work area labels, and output as a 3D scene file.

[0007] The technical problem to be solved by this invention can also be further achieved through the following technical solution: For the above-mentioned digital space display system based on intelligent warehousing, the data visualization module uses the following heat map generation algorithm to display the workload of each area: (1) Divide the warehouse into a 2m×2m grid; (2) Count the number of job events Q that occur in each cell. ij Determine the maximum workload Q max ; (3) Calculate the color intensity value and perform color mapping based on the color intensity value; (4) Generate a semi-transparent texture layer in the 3D engine and overlay it on the ground grid.

[0008] The technical problem to be solved by the present invention can also be further achieved through the following technical solutions: For the above-mentioned digital space display system based on intelligent warehousing, the operational efficiency information displayed by the data visualization module includes the number of picking orders and the number of outbound orders per unit time.

[0009] The technical problem to be solved by the present invention can also be further achieved through the following technical solutions. For the above-mentioned digital space display system based on intelligent warehousing, the inventory status indicator refresh rule triggered by the inventory synchronization engine is as follows: when the inventory is ≥80% of the capacity, the label is red and marked "sufficient"; when the inventory is 30%≤inventory<80%, the label is green and marked "normal"; when the inventory is <30%, the label is yellow and marked "warning".

[0010] The technical problem to be solved by the present invention can also be further achieved through the following technical solution: In the above-mentioned digital space display system based on intelligent warehousing, the user can display the current warehouse materials and inventory information by hovering the mouse over a specific warehouse location on the interactive terminal.

[0011] The technical problem to be solved by the present invention can also be further achieved through the following technical solution: For the above-mentioned digital space display system based on intelligent warehousing, a digital space display method based on intelligent warehousing has the following steps: (1) Generation and initialization of three-dimensional digital space (1.1) Data Input and Parsing (1.1.1) CAD drawing processing: Read the coordinates of the "rectangle" element in the CAD drawing, extract the vertex coordinates, and calculate the center point; Determine the element type by aspect ratio and mark the shelf location; (1.1.2) Excel list matching: Find the corresponding shelf number in the Excel list based on the center point coordinates and obtain the shelf attributes; (1.2) Coordinate system transformation and model generation (1.2.1) Coordinate mapping: Convert the CAD engineering coordinate system to the world coordinate system of the 3D engine; (1.2.2) Model instantiation: Call the prefabricated shelf model from the 3D model library, locate it according to world coordinates, and instantiate it; The Z-axis is used to replicate the structure of each shelf layer, and the ground grid and path markers are generated based on the aisle boundaries. (1.2.3) Output scene file: Generate a 3D scene file containing shelves, floor, and paths for the visualization module to use; (2) Data integration and inventory synchronization (2.1) Real-time data acquisition Connect to the WMS system and hardware devices via API interface to obtain inbound and outbound instructions and inventory change data; The data integration module transmits data to the inventory synchronization engine and the local database; (2.2) Inventory status update and trigger refresh (2.2.1) Inventory Calculation: The inventory synchronization engine adjusts inventory levels based on data and updates the local database. (2.2.2) Refresh Rules: Inventory ≥ 80% capacity: Label displayed in red, indicating "Sufficient"; 30% ≤ Inventory < 80%: Label displays green, indicating "Normal"; Inventory <30%: Labels turn yellow, indicating "Warning"; (2.2.3) Visual refresh: Trigger the data visualization module to update the inventory status indicator in the 3D scene; (3) 3D scene visualization and information overlay (3.1) Basic scene rendering Load the 3D scene file and render the basic elements of shelves, ground, and paths; (3.2) Dynamic information overlay (3.2.1) Workload Heat Map: Divide the warehouse into a 2m×2m grid and count the number of job events Q in each grid. ij ; Calculate the color intensity value and map it to a color gradient: red-yellow-green; Generate a semi-transparent thermal layer and overlay it on the ground grid; (3.2.2) Work efficiency label: Displays the number of picking orders and outbound orders per unit of time, presented in numerical or chart form; (3.2.3) Inventory label: Labels are overlaid on the shelf model to display the current inventory and status; (3.3) Implementation of interactive functions (3.3.1) Mouse hover interaction: When a user hovers the mouse over a specific storage location, information such as the name of the material in the current storage location, the inventory quantity, and the status are displayed. (3.3.2) Click operation response: Clicking on the shelf model will redirect you to the inventory details page, which displays historical transaction records. (4) Large screen display and terminal adaptation (4.1) Large-screen rendering on PC The interactive terminal loads 3D scenes, supporting full-screen display and zoom / rotation operations; Optimize rendering performance to ensure smooth, real-time updates of dynamic data. (4.2) Multi-terminal adaptation It supports viewing scenes on mobile devices using a lightweight 3D engine.

[0012] Compared with the prior art, the beneficial effects of the present invention are as follows: 1. Automated 3D modeling method driven by drawings and lists Traditional 3D mapping relies on manual modeling, which takes 3-5 days. This invention achieves automatic conversion from CAD drawings to 3D models by developing coordinate analysis and coordinate system mapping algorithms. The system automatically identifies the shelf outline and aisle boundaries in the drawings, and combines the shelf type, size, number and other information in the Excel list. It calls the built-in 3D model library to generate a 3D digital map containing shelves, aisles and work areas with one click, reducing the mapping time to within 5 minutes. 2. Real-time map status update mechanism driven by external system This invention constructs a closed-loop control mechanism of "WMS → inventory synchronization → map refresh". When an external system issues a warehouse command, the inventory synchronization engine immediately updates the data and triggers the data visualization module to refresh the map status, achieving a second-level response of "business event → spatial feedback" and improving the anomaly identification efficiency by 3 times. 3. A 3D spatial visualization architecture based on multi-source data fusion This invention maps multiple sources of information, such as spatial layout, inventory data, workload, and logistics flow, onto a three-dimensional digital map. It uses heat maps, dynamic labels, and flow arrows to overlay and display the data, achieving "one map to manage the entire warehouse." Managers can intuitively grasp operational hotspots, inventory status, and logistics routes, improving decision-making efficiency by more than 50%. Attached Figure Description

[0013] Figure 1 This is a schematic diagram illustrating how the present invention automatically generates maps from CAD drawings; Figure 2 This is a schematic diagram of the interface for displaying and overlaying three-dimensional digital space in this invention; Figure 3 This is a schematic diagram of map interaction operations in this invention. Figure 1 ; Figure 4 This is a schematic diagram of map interaction operations in this invention. Figure 2 ; Figure 3 , Figure 4 Heat maps and inventory tags can be displayed according to different warehouse types: Yellow indicates inventory levels below a certain value, green indicates normal levels, and red indicates levels above a certain value. Hovering the mouse over a specific storage location displays the current storage location's materials and inventory information. Detailed Implementation

[0014] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0015] Reference Figure 1-4 This system is a digital spatial display system based on intelligent warehousing. Through a map generation module, it can convert drawings and inventory lists into a 3D digital spatial display with a single click, significantly improving mapping efficiency. Through a data integration module and inventory synchronization engine, it enables real-time data interaction with external systems, ensuring inventory accuracy. Through a data visualization module, it intuitively displays key information such as workload, efficiency, and inventory on a 3D map, achieving "one map for managing the entire warehouse." Through an interactive terminal, managers can monitor warehouse operational status anytime, anywhere. This system effectively enhances the intelligence, visualization, and real-time capabilities of warehouse management.

[0016] Example 1: Automated 3D Drawing Method Driven by Drawings and Bill of Quantities This embodiment describes in detail how the map generation module generates a 3D digital map with one click based on CAD drawings and an Excel list, through automatic coordinate parsing and coordinate system mapping algorithms: (1) Input data CAD drawings: DWG format, including warehouse outline, shelf locations, aisle boundaries and other geometric shapes; Excel list: Includes fields such as: shelf number, type (e.g., heavy-duty shelf, light-duty shelf), length (m), width (m), height (m), number of layers, etc.

[0017] (2) Automatic coordinate analysis process After the system starts up, the map generation module performs the following steps: Step 1: Read the coordinates of the elements in the CAD drawing Use the AutoCADCOM interface or open-source libraries (such as dxfgrabber) to parse DWG files; Extract the coordinates of the four vertices of all "rectangle" primitives: (x1, y1), (x2, y2), (x3, y3), and (x4, y4). Calculate the coordinates of the center point of each rectangle:

[0018] Determine the aspect ratio of the rectangle. If the aspect ratio is greater than 3, then it is a shelf; otherwise, it is a wall or equipment. Step 2: Match shelf information from the Excel list Based on the center point coordinates (x c y c Find the corresponding shelf number in the Excel list; If a match is found, retrieve the shelf's type, size, number of layers, and other attributes.

[0019] (3) Coordinate system mapping algorithm Since CAD drawings use an engineering coordinate system (unit: millimeters, origin arbitrary), while the 3D engine uses a world coordinate system (unit: meters, origin at the lower left corner of the warehouse), coordinate transformation is required.

[0020] Let the coordinates of a point in the CAD drawing be (x cad y cad) Its coordinates in the three-dimensional world (x w y w ) is calculated using the following mapping formula:

[0021] in: x min y min The minimum x and y coordinate values ​​for all elements in the CAD drawing; Dividing by 1000 converts millimeters to meters; This transformation shifts the origin of the drawing to (0, 0), achieving coordinate alignment.

[0022] (4) Generate 3D digital map with one click The system executes the following process: Iterate through all successfully matched shelves and call the corresponding type of prefabricated model in the 3D model library (e.g., "Heavy-duty shelf_6m×2m×6m"). Instantiate the model to world coordinates (x) w y w ,0); Z-axis replication generates the structure of each shelf layer; Generate ground grid and path markers based on the channel boundaries; Add labels to the work area (such as "Inbound Area" and "Packaging Area"); The output is a 3D scene file (such as glTF format) for the data visualization module to load.

[0023] Through the above process, the system can complete the 3D mapping within 5 minutes without manual intervention.

[0024] Example 2: Real-time map status update mechanism driven by an external system This embodiment describes the collaborative workflow of the data integration module, the inventory synchronization engine, and the data visualization module: (1) Data access The WMS system sends outbound instructions to the data integration module through an interface; (2) Inventory synchronization After receiving the instruction, the inventory synchronization engine performs an update on the local database: After a successful update, send a refresh command to the data visualization module: (3) Map status feedback After receiving the instruction, the data visualization module locates the shelf with the corresponding number in the 3D map; "Update its inventory"; If the inventory falls below the safety threshold, a yellow warning will be displayed and an SMS notification will be sent. Managers can immediately perceive inventory changes on the interactive terminal.

[0025] Example 3: 3D Spatial Visualization Architecture Based on Multi-Source Data Fusion This embodiment describes in detail how the data visualization module maps spatial data, inventory data, operational data, and logistics data onto a unified 3D digital map to achieve the integrated display of multi-source information.

[0026] (1) Spatial coordinate binding mechanism Establish a spatial coordinate binding table to precisely associate business data with 3D objects:

[0027] (2) Heatmap generation algorithm The warehouse was divided into a 2m x 2m grid. Count the number of job events Q that occur in each cell. ij The maximum workload is Q. max ; Calculate the color intensity value: ; Color mapping: C ij <0.3: Yellow (Warning); 0.3≤C ij <0.7: Green (normal); C ij ≥0.7: Red (sufficient); A semi-transparent texture layer is generated in the 3D engine and overlaid on the ground mesh.

[0028] State determination rules: If inventory is ≥80% of capacity: mark it in red as "sufficient"; If 30% ≤ Inventory < 80%: Green, marked "Normal"; If inventory is less than 30%: yellow, marked "Warning"; (3) Multi-layer blending rendering The system adopts a layered rendering architecture:

[0029] All layers are managed uniformly in the 3D engine, supporting scaling, rotation, and translation operations.

[0030] Through the above technical solutions, the system achieves deep integration of spatial layout and business data, allowing managers to intuitively grasp the overall operating status of the warehouse in a single interface, significantly improving management efficiency.

[0031] Furthermore, the map generation module allows users to fine-tune the automatically generated 3D map to match the actual warehouse layout.

[0032] Furthermore, after the inventory is updated, the inventory synchronization engine triggers the data visualization module to refresh the inventory status indicators on the 3D digital space display. For example, when the inventory is below a safety threshold, the label turns yellow. Furthermore, the data visualization module displays operational efficiency information including the number of picking orders and the number of outbound orders per unit time.

[0033] Although embodiments of this application have been shown and described, it will be understood by those skilled in the art that various changes, modifications, substitutions and variations can be made to these embodiments without departing from the principles and spirit of this application, the scope of which is defined by the appended claims and their equivalents.

Claims

1. A digital space display system based on intelligent warehousing, characterized in that: The system includes a map generation module, a data integration module, a data visualization module, an inventory synchronization engine, an interactive terminal, and a map interaction module; The map generation module is used to generate a three-dimensional digital space display of the warehouse based on warehouse drawings and equipment lists. It supports importing CAD format floor plans and Excel format shelf lists, automatically generates a three-dimensional model through coordinate analysis and coordinate system mapping algorithms, and allows users to fine-tune the automatically generated three-dimensional map. The data integration module is used to interface with the WMS system and hardware system, and obtain inbound and outbound instructions and inventory change data through API interface; The inventory synchronization engine is electrically connected to the data integration module and the local database. It is used to increase or decrease inventory based on the acquired data. After the inventory is updated, the data visualization module is triggered to refresh the inventory status indicator on the three-dimensional digital space display. The data visualization module is electrically connected to the map generation module, the inventory synchronization engine, and the data integration module. It is used to overlay and display the inbound and outbound operation volume, operation efficiency, and inventory information on a three-dimensional digital space display. It uses a heat map to display the operation volume of each area and uses labels to display the shelf inventory. The interactive terminal is electrically connected to the data visualization module and is used to display three-dimensional digital space display and overlay information for large-screen data display on PC. The map interaction module is electrically connected to the interaction terminal and the local database, and is used to respond to user click operations, display the inventory details of the selected shelf, and view the operation history of each item.

2. The digital space display system based on intelligent warehousing according to claim 1, characterized in that: The map generation module generates a 3D digital map based on CAD drawings and an Excel list through the following steps: (1) Read the coordinates of the graphic elements in the CAD drawing, extract the coordinates of the four vertices of all "rectangle" graphic elements, calculate the coordinates of the center point of each rectangle, and determine the aspect ratio of the rectangle to determine the shelf, wall, or equipment; (2) Find the corresponding shelf number in the Excel list based on the center point coordinates. After a successful match, obtain the shelf type, size, and number of layers attributes. (3) The engineering coordinate system of the CAD drawing is converted into the world coordinate system of the 3D engine through a coordinate system mapping algorithm; (4) Traverse all successfully matched shelves, call the corresponding type of prefabricated model in the 3D model library, instantiate the model to world coordinates, copy the Z-axis to generate the shelf structure of each layer, generate ground grid and path markers according to the aisle boundary, add work area labels, and output as a 3D scene file.

3. The digital space display system based on intelligent warehousing according to claim 1, characterized in that: The data visualization module uses the following heatmap generation algorithm to display the workload of each area: (1) Divide the warehouse into a 2m×2m grid; (2) Count the number of job events Q that occur in each cell. ij Determine the maximum workload Q max ; (3) Calculate the color intensity value and perform color mapping based on the color intensity value; (4) Generate a semi-transparent texture layer in the 3D engine and overlay it on the ground grid.

4. The digital space display system based on intelligent warehousing according to claim 1, characterized in that: The data visualization module displays operational efficiency information including the number of picking orders and the number of outbound orders per unit time.

5. The digital space display system based on intelligent warehousing according to claim 1, characterized in that: The inventory status indicator refresh rules triggered by the inventory synchronization engine are as follows: when the inventory is ≥80% of the capacity, the label is red and marked "sufficient"; when the inventory is 30% ≤ inventory < 80%, the label is green and marked "normal"; when the inventory is <30%, the label is yellow and marked "warning".

6. The digital space display system based on intelligent warehousing according to claim 1, characterized in that: In this system, users can hover their mouse over a specific storage location on the interactive terminal to view the current storage location's materials and inventory information.

7. A digital space display method based on intelligent warehousing, characterized in that: This method uses the digital space display system based on intelligent warehousing as described in any one of claims 1-6, and its steps are as follows: (1) Generation and initialization of three-dimensional digital space (1.1) Data Input and Parsing (1.1.1) CAD drawing processing: Read the coordinates of the "rectangle" element in the CAD drawing, extract the vertex coordinates, and calculate the center point; Determine the element type by aspect ratio and mark the shelf location; (1.1.2) Excel list matching: Find the corresponding shelf number in the Excel list based on the center point coordinates and obtain the shelf attributes; (1.2) Coordinate system transformation and model generation (1.2.1) Coordinate mapping: Convert the CAD engineering coordinate system to the world coordinate system of the 3D engine; (1.2.2) Model instantiation: Call the prefabricated shelf model from the 3D model library, locate it according to world coordinates, and instantiate it; The Z-axis is used to replicate the structure of each shelf layer, and the ground grid and path markers are generated based on the aisle boundaries. (1.2.3) Output scene file: Generate a 3D scene file containing shelves, floor, and paths for the visualization module to use; (2) Data integration and inventory synchronization (2.1) Real-time data acquisition Connect to the WMS system and hardware devices via API interface to obtain inbound and outbound instructions and inventory change data; The data integration module transmits data to the inventory synchronization engine and the local database; (2.2) Inventory status update and trigger refresh (2.2.1) Inventory Calculation: The inventory synchronization engine adjusts inventory levels based on data and updates the local database. (2.2.2) Refresh Rules: Inventory ≥ 80% capacity: Label displayed in red, indicating "Sufficient"; 30% ≤ Inventory < 80%: Label displays green, indicating "Normal"; Inventory <30%: Labels turn yellow, indicating "Warning"; (2.2.3) Visual refresh: Trigger the data visualization module to update the inventory status indicator in the 3D scene; (3) 3D scene visualization and information overlay (3.1) Basic scene rendering Load the 3D scene file and render the basic elements of shelves, ground, and paths; (3.2) Dynamic information overlay (3.2.1) Workload Heat Map: Divide the warehouse into a 2m×2m grid and count the number of job events Q in each grid. ij ; Calculate the color intensity value and map it to a color gradient: red-yellow-green; Generate a semi-transparent thermal layer and overlay it on the ground grid; (3.2.2) Work efficiency label: Displays the number of picking orders and outbound orders per unit of time, presented in numerical or chart form; (3.2.3) Inventory label: Labels are overlaid on the shelf model to display the current inventory and status; (3.3) Implementation of interactive functions (3.3.1) Mouse hover interaction: When a user hovers the mouse over a specific storage location, information such as the name of the material in the current storage location, the inventory quantity, and the status are displayed. (3.3.2) Click operation response: Clicking on the shelf model will redirect you to the inventory details page, which displays historical transaction records. (4) Large screen display and terminal adaptation (4.1) Large-screen rendering on PC The interactive terminal loads 3D scenes, supporting full-screen display and zoom / rotation operations; Optimize rendering performance to ensure smooth, real-time updates of dynamic data. (4.2) Multi-terminal adaptation It supports viewing scenes on mobile devices using a lightweight 3D engine.

Images