Intelligent visual management and control method, device and equipment for steel structural member storage and medium

Abstract

The invention relates to the technical field of intelligent warehousing, and discloses an intelligent visual management and control method, device and equipment for steel structural member warehousing and a medium, and the method comprises the steps: storing basic information, warehousing layout information and association relationship information of steel structural members through a first database; constructing a warehouse body model and steel structural member models, and determining the position of each steel structural member model according to the corresponding relationship between each steel structural member and the warehouse storage point location to obtain a warehouse three-dimensional model; according to the basic information, generating a statistical chart of various profile steel structural members, and recording unique identifiers of the steel structural members counted by the statistical chart; outputting the statistical chart and the warehouse three-dimensional model on a user interface, and obtaining a click position input by a user on the user interface; and determining a unique identifier based on the click position, and highlighting the steel structural part model or the statistical chart according to the unique identifier. According to the method, the change of visual display from static interaction to dynamic interaction can be realized, and the convenience of information acquisition is improved.

Description

Technical Field

[0001] This invention relates to the field of intelligent warehousing technology, specifically to an intelligent visual management and control method, device, equipment, and medium for steel structure component warehousing. Background Technology

[0002] In the rapid development of modern industry, steel structural components, with their advantages of high strength, light weight, and convenient construction, are widely used in many industries such as construction, machinery manufacturing, and bridges, leading to a continuous expansion of steel structural component warehousing. Traditional steel structural component warehousing management mainly relies on manual operation and simple recording methods, such as paper ledgers or basic spreadsheets recording inventory details. This approach has many obvious drawbacks: information retrieval is extremely inconvenient; when needing to query key information such as the precise location, real-time quantity, and detailed specifications of a specific steel structural component, it often consumes a lot of time and accuracy is difficult to guarantee; the display format is monotonous and ineffective, failing to present the entire warehouse space layout and the actual storage status of each steel structural component in a visually intuitive way; inventory counting is not only inefficient but also prone to errors due to human negligence, resulting in high warehousing management costs and difficulty in quickly responding to dynamic market changes. Furthermore, when presenting warehousing status to customers, partners, or internal teams, there is a lack of advanced, efficient, and highly interactive display methods, failing to meet the objective requirements of modern warehousing management and efficient information exchange and interaction.

[0003] The relevant solutions use charts to statically count the quantity of different types of steel structural components and use 3D models to dynamically display the steel structural components. However, the charts and 3D models lack connection and interaction, making information acquisition inconvenient. Summary of the Invention

[0004] In view of this, the present invention provides an intelligent visual management and control method, device, equipment and medium for steel structure component storage, in order to solve the technical problems of the lack of linkage and interaction between dynamic three-dimensional models and static charts in the prior art, and the inconvenience of information acquisition.

[0005] In a first aspect, the present invention provides an intelligent and visual management method for the storage of steel structural components, comprising:

[0006] The first database stores basic information, warehouse layout information, and relationship information for steel structural components. The relationship information includes the correspondence between each steel structural component and a warehouse storage location. Based on the basic information and warehouse layout information, a warehouse body model and a steel structural component model are constructed. The location of each steel structural component model is determined according to its correspondence with a warehouse storage location, resulting in a 3D warehouse model. Each steel structural component model is associated with a unique identifier. Statistical charts for various types of steel structural components are generated based on the basic information, and the unique identifiers of the steel structural components included in the charts are recorded. The statistical charts and the 3D warehouse model are output to the user interface, and the user's click locations are obtained. A unique identifier is determined based on the click location, and the steel structural component model or statistical chart is highlighted according to the unique identifier.

[0007] The intelligent visual management and control method for steel structure component storage of the present invention associates unique identifiers with the steel structure component model, enabling each steel structure component to be accurately identified and located. Simultaneously, the unique identifiers of the corresponding steel structure components are recorded in statistical charts, establishing a close link between the statistical charts and the warehouse 3D model. The statistical charts and the warehouse 3D model are then output to the user interface, allowing users to intuitively view storage data and layout. Furthermore, by acquiring the user's click location, the statistical chart corresponding to the clicked steel structure component model or the steel structure component model corresponding to the clicked statistical chart is highlighted. Through the interaction and information linkage between diverse statistical charts and the warehouse 3D model display area, the visualization display transforms from static to dynamic interaction, improving the convenience and efficiency of information acquisition.

[0008] In some optional implementations, a unique identifier is determined based on the click location, and the steel structure model or statistical chart is highlighted according to the unique identifier. This includes: if the click location is on a statistical chart, then the unique identifier of the steel structure in the current statistical chart is determined based on the clicked statistical chart, and the steel structure corresponding to the unique identifier in the warehouse 3D model is highlighted; if the click location is on a steel structure model, then the unique identifier is determined based on the clicked steel structure model, and the statistical chart corresponding to the unique identifier is highlighted.

[0009] This method enables two-way linkage between statistical charts and 3D models. Whether it is locating specific steel structural components from statistical data or tracing back to relevant statistical data from specific steel structural components, it can be done quickly and accurately, helping users to have a more comprehensive understanding of warehousing information.

[0010] In some alternative implementations, the intelligent visual management and control method for steel structure component storage also includes: storing real-time sensor data collected by sensors in a second database; and updating statistical charts and warehouse 3D models based on the real-time sensor data.

[0011] The introduction of a second database to store real-time sensor data collected by sensors provides the system with a timely and accurate data source. By updating statistical charts and warehouse 3D models based on this real-time data, the system can ensure that the warehouse information seen by users in the user interface is up-to-date and reflects changes in the warehouse situation in real time.

[0012] In some alternative implementations, the sensors include position sensors and weight sensors, and the real-time sensing data includes real-time position information and real-time weight information. The position sensors are located at key nodes of the shelves and at the intersections of aisles in the warehouse, while the weight sensors are located at the bottom of the storage shelves in the warehouse or at the load-bearing parts of the goods handling equipment.

[0013] This solution specifically collects real-time location and weight information of steel structural components, and sets up sensors at key locations to ensure the accuracy and reliability of the collected data, providing strong support for real-time monitoring of warehouse status.

[0014] In some alternative implementations, the first database is a relational database and the second database is a non-relational database.

[0015] This solution fully leverages the advantages of different databases, improving the overall system performance and data management efficiency.

[0016] In some optional implementations, the steel structure model is associated with the basic information of the corresponding steel structure. After outputting the statistical charts and the warehouse 3D model to the user interface, the implementation also includes: receiving query information input by the user, querying the target steel structure model based on the query information and quickly locating the target steel structure model; and visually outputting the associated basic information on the target steel structure model.

[0017] This method adds a query function, so users no longer need to search for relevant information one by one in a large amount of data or models. They can quickly obtain detailed information about the target steel structure through a simple query operation, which helps users make decisions and take corresponding management measures more promptly.

[0018] In some optional implementations, after updating the statistical charts and the warehouse 3D model based on real-time sensor data, the process includes: performing early warning analysis on the data in the updated statistical charts according to a preset inventory early warning strategy, and determining whether to perform an early warning operation based on the early warning analysis results.

[0019] The early warning function can promptly remind managers to take appropriate measures, such as replenishing or adjusting inventory, to avoid risks such as production interruptions and increased costs caused by inventory problems, thus helping to optimize inventory management.

[0020] Secondly, the present invention provides an intelligent visual management and control device for steel structure component storage, comprising: a data storage module for storing basic information, storage layout information, and correlation information of steel structure components in a first database, wherein the correlation information includes the correspondence between each steel structure component and a storage location in the warehouse; a model building module for building a warehouse body model and a steel structure component model based on the basic information and the storage layout information, respectively, and determining the position of each steel structure component model according to the correspondence between each steel structure component and a storage location in the warehouse, thereby obtaining a three-dimensional warehouse model, wherein each steel structure component model is associated with a unique identifier; a chart generation module for generating statistical charts of various types of steel structure components based on the basic information, and recording the unique identifier of the steel structure components statistically analyzed in the charts; a human-computer interaction module for outputting the statistical charts and the three-dimensional warehouse model on the user interface, and obtaining the click position input by the user on the user interface; and an interactive highlighting module for determining the unique identifier based on the click position, and highlighting the steel structure component model or statistical chart according to the unique identifier.

[0021] Thirdly, the present invention provides a computer device, comprising: a memory and a processor, wherein the memory and the processor are communicatively connected to each other, the memory stores computer instructions, and the processor executes the computer instructions to perform the intelligent visual management and control method for steel structure component storage described in the first aspect or any corresponding embodiment.

[0022] Fourthly, the present invention provides a computer-readable storage medium storing computer instructions, which are used to cause a computer to execute the intelligent visual management and control method for steel structure component storage described in the first aspect or any corresponding embodiment. Attached Figure Description

[0023] To more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the specific embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0024] Figure 1 This is a flowchart illustrating the intelligent visual management and control method for steel structure component storage according to an embodiment of the present invention;

[0025] Figure 2 This is a schematic diagram of a three-dimensional warehouse model according to an embodiment of the present invention;

[0026] Figure 3 This is a schematic diagram of the user interface in the intelligent display platform of this invention.

[0027] Figure 4 This is a structural block diagram of the intelligent visual management and control device for steel structure component storage according to an embodiment of the present invention;

[0028] Figure 5 This is a schematic diagram of the hardware structure of a computer device according to an embodiment of the present invention. Detailed Implementation

[0029] 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.

[0030] To address the issues of limited display formats and low management efficiency in steel structure component warehousing, this invention proposes an intelligent and visual management method for steel structure component warehousing. This method aims to overcome numerous challenges in traditional steel structure component warehousing management regarding intuitive information display, efficient query and retrieval, and interactive collaboration. It achieves intelligent, precise management and visual presentation of warehousing information, significantly improving warehousing operational efficiency, effectively reducing management costs, and greatly enhancing information interaction efficiency with external systems and personnel.

[0031] According to an embodiment of the present invention, an embodiment of an intelligent visual management and control method for steel structure component storage is provided. It should be noted that the steps shown in the flowchart in the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions. Furthermore, although a logical order is shown in the flowchart, in some cases, the steps shown or described may be executed in a different order than that shown here.

[0032] This embodiment provides an intelligent and visual management method for steel structure component storage, which can be used on mobile terminals such as mobile phones and tablets, combined with Figure 1 , Figure 2 and Figure 3 As shown, the process includes the following steps:

[0033] Step S101: The basic information, storage layout information and relationship information of the steel structure components are stored in the first database. The relationship information includes the correspondence between each steel structure component and the warehouse storage location.

[0034] Specifically, the first database is a relational database. Relational databases are suitable for storing data with fixed structures and relationships, such as basic information of steel structural components, warehouse layout information, and related relationship information, which can ensure data integrity, consistency, and query efficiency.

[0035] Design the table structure of the first database, and create a basic information table, a storage layout table, and a relationship table for steel structural components in the first database. The basic information table, the storage layout table, and the relationship table store the basic information, storage layout information, and relationship information of the steel structural components, respectively.

[0036] Basic information includes the unique identifier, name, dimensions, material, and production date of each steel structural component. Warehouse layout information includes the coordinates, number, capacity, and availability of each warehouse storage location. The steel structural components are linked to each warehouse storage location through relationship information.

[0037] Step S102: Construct a warehouse body model and a steel structure model based on basic information and warehouse layout information, respectively. Determine the position of each steel structure model according to the correspondence between each steel structure and warehouse storage point to obtain a three-dimensional warehouse model. Each steel structure model is associated with a unique identifier.

[0038] Specifically, the Three.js 3D engine is introduced and integrated into the platform's front-end project.

[0039] The code is written using Three.js to construct a warehouse body model based on the actual shape, size, and storage layout information of the warehouse. It also reads the basic information of the steel structure components and constructs a steel structure component model based on the size, material, and other information in the basic information. The steel structure components are placed according to the correspondence between each steel structure component and the warehouse storage location to ensure that the 3D model display area can accurately reflect the storage status of the steel structure components in the warehouse and realize the visualization of the data.

[0040] Step S103: Generate statistical charts of various types of steel structural components based on basic information, and record the unique identifiers of the steel structural components statistically represented in the charts.

[0041] Specifically, data such as the quantity distribution, material proportion, and inventory change trend of steel structural components are preprocessed, such as counting the quantity of steel structural components of different materials, calculating the proportion, analyzing inventory change trends, and generating statistical charts.

[0042] Statistical charts can be of various styles, such as bar charts, pie charts, and dynamic line charts. When displaying information such as the quantity distribution of steel structural components, material proportions, and inventory change trends, they can work in conjunction with the 3D model display area to achieve information linkage.

[0043] By establishing a correlation table, the preprocessed data is associated with the steel structure model, and the unique identifier of the steel structure for each statistical chart is recorded.

[0044] Step S104: Output the statistical charts and warehouse 3D model to the user interface, and obtain the click positions entered by the user in the user interface.

[0045] Specifically, the user interface and interactive functions of the intelligent display platform are developed using front-end development technology and a 3D engine. The data visualization chart library is integrated into the intelligent display platform, and the warehouse 3D model and statistical charts are then visualized on the user interface. User input information is detected through the user interface.

[0046] For example, front-end development technologies can be HTML5, CSS3, JavaScript, etc., the 3D engine can be Three.js, and the data visualization chart library can be Echarts.

[0047] Step S105: Determine a unique identifier based on the click location, and highlight the steel structure model or statistical chart according to the unique identifier.

[0048] Specifically, when a user clicks on a steel structure model, the associated statistical chart is highlighted based on the unique identifier of the steel structure model. When the user clicks on a statistical chart, the steel structure model is highlighted based on the unique identifier of the steel structure component in the statistical chart.

[0049] It should be understood that the specific methods of highlighting can include highlighting, adding arrows, or labeling.

[0050] The intelligent visual management and control method for steel structure component storage in this invention associates unique identifiers with the steel structure component model, enabling each steel structure component to be accurately identified and located. Simultaneously, the unique identifiers of the corresponding steel structure components are recorded in statistical charts, establishing a close link between the statistical charts and the warehouse 3D model. The statistical charts and the warehouse 3D model are then output to the user interface, allowing users to intuitively view storage data and layout. Furthermore, by acquiring the user's click location, the method highlights the statistical chart corresponding to the clicked steel structure component model or the steel structure component model corresponding to the clicked statistical chart. Through the interaction and information linkage between diverse statistical charts and the warehouse 3D model display area, the visualization display transforms from static to dynamic interaction, improving the convenience and efficiency of information acquisition.

[0051] In some optional implementations, step S105, determining a unique identifier based on the click location, and highlighting the steel structure model or statistical chart according to the unique identifier, includes:

[0052] Step S1051: If the clicked location is on a statistical chart, then determine the unique identifier of the steel structure component in the current statistical chart based on the clicked statistical chart, and highlight the steel structure component corresponding to the unique identifier in the warehouse 3D model.

[0053] Step S1052: If the clicked location is on the steel structure model, a unique identifier is determined based on the clicked steel structure model, and the statistical chart corresponding to the unique identifier is highlighted.

[0054] Using JavaScript and relevant front-end frameworks, the interaction logic between statistical charts and steel structure models in the 3D model display area is implemented. When a user clicks on a statistical chart, such as the bar for the quantity of steel structure components of a certain material in a bar chart, the front-end code captures the event to obtain the material type, queries the database for the unique identifier of the steel structure component of that material, obtains the location information of the steel structure model associated with the unique identifier, and highlights or marks the obtained steel structure model. Conversely, when a user selects a steel structure model in the 3D model display area, the front-end code obtains its unique identifier, queries the relevant information, and highlights or updates the data in the corresponding chart.

[0055] This method enables two-way linkage between statistical charts and 3D models. Whether it is locating specific steel structural components from statistical data or tracing back to relevant statistical data from specific steel structural components, it can be done quickly and accurately, helping users to have a more comprehensive understanding of warehousing information.

[0056] In some alternative implementations, the intelligent visual management and control method for steel structure component storage also includes:

[0057] Step S201: Store the real-time sensing data collected by the sensors in the second database;

[0058] Step S202: Update the statistical charts and warehouse 3D model based on real-time sensor data.

[0059] Specifically, the second database is a non-relational database, suitable for storing real-time sensor data, which has a relatively flexible structure and may have a large data volume. It can efficiently handle the storage and retrieval of real-time data. This solution fully leverages the advantages of different databases, improving the overall system performance and data management efficiency.

[0060] The introduction of a second database to store real-time sensor data collected by sensors provides the system with a timely and accurate data source. By updating statistical charts and warehouse 3D models based on this real-time data, the system can ensure that the warehouse information seen by users in the user interface is up-to-date and reflects changes in the warehouse situation in real time.

[0061] A collaborative architecture combining relational and non-relational databases is employed to store data, optimizing storage and efficient management for different data types. It can rapidly handle massive real-time data read / write requests. Even when dealing with frequent updates to the location and dynamic changes in weight data of numerous steel structural components, it maintains the timeliness and stability of data storage and retrieval, effectively solving the performance bottleneck problem of traditional single-database architectures when processing complex warehouse data.

[0062] Furthermore, the sensors include position sensors and weight sensors. Real-time sensing data includes real-time position information and real-time weight information. Position sensors are located at key nodes of the shelves and at the intersections of warehouse aisles, while weight sensors are installed at the bottom of the storage shelves in the warehouse or at the load-bearing parts of the goods handling equipment.

[0063] Specifically, based on the layout and structural characteristics of the steel structure warehouse, position sensors and weight sensors are installed to ensure that the accuracy of the position sensors meets the requirements for determining the position coordinates of the steel structural components, and that the range and accuracy of the weight sensors match the weight range of the steel structural components. By integrating multiple sensors such as position tracking and weight sensing, synchronous acquisition of comprehensive and multi-dimensional data of the steel structural components is achieved.

[0064] The specific data collection process is as follows:

[0065] 1. Position Sensor Data Acquisition: High-precision position sensors are installed at key nodes of the shelving and at intersections of warehouse aisles. These sensors employ advanced positioning technologies, such as Ultra Wide Band (UWB) based positioning technology, to accurately measure the distance between the steel structure components and the sensors. The precise coordinates of the steel structure components are then calculated using triangulation algorithms. The position sensors transmit the collected position data to the data acquisition terminal via a wireless transmission module at set time intervals, such as once per second.

[0066] 2. Weight Sensor Data Acquisition: Weight sensors are installed at the bottom of storage shelves or on the load-bearing parts of handling equipment in the warehouse. When steel structural components are placed on shelves or handling equipment equipped with weight sensors, the sensors detect weight changes in real time and convert the weight data into electrical signals. These electrical signals are amplified and filtered by a signal conditioning circuit before being converted into digital signals by the data acquisition module. Similarly, the weight data is transmitted wirelessly to the data acquisition terminal for processing and storage along with location data. The data collected by the data acquisition terminal is further sent to the intelligent display platform for processing.

[0067] This invention specifically collects real-time location and weight information of steel structural components, and sets up sensors at key locations to ensure the accuracy and reliability of the collected data, providing strong support for real-time monitoring of warehouse status.

[0068] In some optional implementations, the steel structure model is associated with the basic information of the corresponding steel structure. After outputting the statistical charts and the warehouse 3D model to the user interface in step S104, the method further includes:

[0069] Step S301: Receive query information input by the user, query the target steel structure model based on the query information, and quickly locate the target steel structure model.

[0070] Step S302: Visualize and output the associated basic information on the target steel structure model.

[0071] Specifically, the query information can be entered using keywords, such as the name or number of the steel structure component. The search will be conducted based on the entered keywords to obtain comprehensive and detailed query results, including navigation information on the location of the steel structure component.

[0072] Furthermore, the query method also supports click-based queries. When a user clicks on the steel structure model, basic information about the steel structure model is displayed. By combining multiple query methods, the limitations of traditional warehouse management systems—such as limited query functions and brief results—are overcome. This allows staff to quickly locate and operate steel structure components in complex warehouse environments, significantly improving the efficiency of warehouse operations.

[0073] This method adds a query function, so users no longer need to search for relevant information one by one in a large amount of data or models. They can quickly obtain detailed information about the target steel structure through a simple query operation, which helps users make decisions and take corresponding management measures more promptly.

[0074] In some alternative implementations, after updating the statistical charts and the warehouse 3D model based on real-time sensor data, the process includes:

[0075] Step S401: Based on the preset inventory warning strategy, perform warning analysis on the data in the updated statistical charts, and determine whether to execute the warning operation based on the warning analysis results.

[0076] Specifically, inventory early warning strategies can be set according to the company's own needs. For example, the set inventory early warning strategy can be a minimum inventory quantity, a safety stock period, etc. The early warning threshold is calculated based on the data analysis results of historical inbound and outbound data and market demand forecast data. The early warning algorithm is integrated into the intelligent display platform. When the inventory quantity triggers the early warning condition, the platform automatically executes the early warning operation and pushes a notification message to notify the management to perform operations such as replenishment and inventory adjustment.

[0077] The early warning function can promptly remind managers to take appropriate measures, such as replenishing or adjusting inventory, to avoid risks such as production interruptions and increased costs caused by inventory problems, thus helping to optimize inventory management.

[0078] The intelligent display platform developed using the intelligent visual management and control method for steel structure component warehousing according to embodiments of the present invention can be deployed on a server, ensuring that the platform can be accessed via the network. Performance testing and optimization are conducted to guarantee the platform's response speed and stability under heavy user access and data processing. Furthermore, based on the interface specifications of internal systems such as MES, ERP, and logistics systems, Web API technology can be used to develop data interaction interfaces with external systems, achieving seamless integration and real-time information collaboration between different systems.

[0079] This invention also provides an intelligent visual management and control device for steel structure component storage, such as... Figure 4 As shown, it includes:

[0080] The data storage module 401 is used to store basic information, storage layout information and correlation information of steel structural components through the first database. The correlation information includes the correspondence between each steel structural component and the warehouse storage location.

[0081] The model building module 402 is used to build a warehouse body model and a steel structure model based on basic information and warehouse layout information, respectively. It also determines the position of each steel structure model according to the correspondence between each steel structure and warehouse storage point, thus obtaining a three-dimensional warehouse model. Each steel structure model is associated with a unique identifier.

[0082] The chart generation module 403 is used to generate statistical charts of various types of steel structural components based on basic information, and to record the unique identifier of the steel structural components statistically analyzed in the charts.

[0083] The human-computer interaction module 404 is used to output statistical charts and warehouse 3D models to the user interface and to obtain the click positions of the user input in the user interface.

[0084] The interactive highlighting module 405 is used to determine a unique identifier based on the click location and highlight the steel structure model or statistical chart according to the unique identifier.

[0085] The intelligent visual management and control system for steel structure component storage of this invention associates unique identifiers with the steel structure component model, enabling each steel structure component to be accurately identified and located. Simultaneously, the unique identifiers of the corresponding steel structure components are recorded in statistical charts, establishing a close link between the statistical charts and the warehouse 3D model. The statistical charts and the warehouse 3D model are then output to the user interface, allowing users to intuitively view storage data and layout. Furthermore, by acquiring the user's click location, the system highlights the statistical chart corresponding to the clicked steel structure component model or the steel structure component model corresponding to the clicked statistical chart. Through the interaction and information linkage between diverse statistical charts and the warehouse 3D model display area, the system achieves a transformation from static to dynamic interactive visualization, improving the convenience and efficiency of information acquisition.

[0086] Furthermore, the interactive highlighting module includes:

[0087] The chart interaction module is used to determine the unique identifier of the steel structure component in the current statistical chart if the clicked position is on the statistical chart, and to highlight the steel structure component corresponding to the unique identifier in the warehouse 3D model.

[0088] The model interaction module is used to determine a unique identifier based on the clicked steel structure model if the clicked location is on the steel structure model, and then highlight the statistical chart corresponding to the unique identifier.

[0089] Furthermore, the intelligent visual management and control system for steel structure component storage also includes:

[0090] The real-time data acquisition module is used to store real-time sensing data acquired by the sensors in a second database.

[0091] The data update module is used to update statistical charts and warehouse 3D models based on real-time sensor data.

[0092] Furthermore, the sensors include position sensors and weight sensors. Real-time sensing data includes real-time position information and real-time weight information. Position sensors are located at key nodes of the shelves and at the intersections of warehouse aisles, while weight sensors are installed at the bottom of the storage shelves in the warehouse or at the load-bearing parts of the goods handling equipment.

[0093] Furthermore, the first database is a relational database, and the second database is a non-relational database.

[0094] Furthermore, the steel structure component model is associated with the basic information of the corresponding steel structure component. The intelligent visual management and control system for steel structure component storage also includes:

[0095] The query module is used to receive query information input by the user, query the target steel structure model based on the query information, and quickly locate the target steel structure model.

[0096] The output module is used to visualize the associated basic information on the target steel structure model.

[0097] Furthermore, the intelligent visual management and control system for steel structure component storage also includes:

[0098] The early warning module is used to perform early warning analysis on the data in the updated statistical charts based on the preset inventory early warning strategy, and to determine whether to execute early warning operations based on the early warning analysis results.

[0099] This invention also provides a computer device, such as... Figure 5 As shown, the computer device includes one or more processors 10, memory 20, and interfaces for connecting the components, including high-speed interfaces and low-speed interfaces. The components communicate with each other via different buses and can be mounted on a common motherboard or otherwise installed as needed. The processors can process instructions executed within the computer device, including instructions stored in or on memory to display graphical information of a GUI on external input / output devices (such as display devices coupled to the interfaces). In some alternative implementations, multiple processors and / or multiple buses can be used with multiple memories and multiple memory modules, if desired. Similarly, multiple computer devices can be connected, each providing some of the necessary operations (e.g., as a server array, a group of blade servers, or a multiprocessor system). Figure 5 Take a processor 10 as an example.

[0100] Processor 10 may be a central processing unit, a network processor, or a combination thereof. Processor 10 may further include a hardware chip. The hardware chip may be an application-specific integrated circuit (ASIC), a programmable logic device (PLD), or a combination thereof. The programmable logic device may be a complex programmable logic device (CAMP), a field-programmable gate array (FPGA), a general-purpose array logic (GDA), or any combination thereof.

[0101] The memory 20 stores instructions executable by at least one processor 10 to cause at least one processor 10 to perform the method shown in the above embodiments.

[0102] The memory 20 may include a program storage area and a data storage area. The program storage area may store the operating system and applications required for at least one function; the data storage area may store data created based on the use of the computer device. Furthermore, the memory 20 may include high-speed random access memory and may also include non-transitory memory, such as at least one disk storage device, flash memory device, or other non-transitory solid-state storage device. In some alternative embodiments, the memory 20 may optionally include memory remotely located relative to the processor 10, and these remote memories may be connected to the computer device via a network. Examples of such networks include, but are not limited to, the Internet, intranets, local area networks, mobile communication networks, and combinations thereof.

[0103] The memory 20 may include volatile memory, such as random access memory; the memory may also include non-volatile memory, such as flash memory, hard disk or solid-state drive; the memory 20 may also include a combination of the above types of memory.

[0104] The computer device also includes an input device 30 and an output device 40. The processor 10, memory 20, input device 30, and output device 40 can be connected via a bus or other means. Figure 5 Taking the example of a connection between China and Israel via a bus.

[0105] Input device 30 can receive input numerical or character information, and generate key signal inputs related to user settings and function control of the computer device, such as a touchscreen, keypad, mouse, trackpad, touchpad, joystick, one or more mouse buttons, trackball, joystick, etc. Output device 40 may include display devices, auxiliary lighting devices (e.g., LEDs), and haptic feedback devices (e.g., vibration motors). The aforementioned display devices include, but are not limited to, liquid crystal displays, light-emitting diodes, displays, and plasma displays. In some alternative embodiments, the display device may be a touchscreen.

[0106] This invention also provides a computer-readable storage medium. The methods described above according to embodiments of the invention can be implemented in hardware or firmware, or implemented as computer code that can be recorded on a storage medium, or implemented as computer code downloaded via a network and originally stored on a remote storage medium or a non-transitory machine-readable storage medium and then stored on a local storage medium. Thus, the methods described herein can be processed by software stored on a storage medium using a general-purpose computer, a dedicated processor, or programmable or dedicated hardware. The storage medium can be a magnetic disk, optical disk, read-only memory, random access memory, flash memory, hard disk, or solid-state drive, etc.; further, the storage medium can also include combinations of the above types of memory. It is understood that computers, processors, microprocessor controllers, or programmable hardware include storage components capable of storing or receiving software or computer code, which, when accessed and executed by the computer, processor, or hardware, implements the methods shown in the above embodiments.

[0107] A portion of this invention can be applied as a computer program product, such as computer program instructions, which, when executed by a computer, can invoke or provide the methods and / or technical solutions according to the invention through the operation of the computer. Those skilled in the art will understand that the forms in which computer program instructions exist in a computer-readable medium include, but are not limited to, source files, executable files, installation package files, etc. Correspondingly, the ways in which computer program instructions are executed by a computer include, but are not limited to: the computer directly executing the instructions, or the computer compiling the instructions and then executing the corresponding compiled program, or the computer reading and executing the instructions, or the computer reading and installing the instructions and then executing the corresponding installed program. Here, the computer-readable medium can be any available computer-readable storage medium or communication medium accessible to a computer.

[0108] Although embodiments of the invention have been described in conjunction with the accompanying drawings, those skilled in the art can make various modifications and variations without departing from the spirit and scope of the invention, and all such modifications and variations fall within the scope of protection.

Claims

1. An intelligent visual management and control method for steel structure component storage, characterized in that, include: The first database stores basic information, warehouse layout information, and relationship information of steel structural components. The relationship information includes the correspondence between each steel structural component and the warehouse storage location. Based on the basic information and the warehouse layout information, a warehouse body model and a steel structure model are constructed respectively. The position of each steel structure model is determined according to the correspondence between each steel structure and the warehouse storage point, thus obtaining a three-dimensional warehouse model. Each steel structure model is associated with a unique identifier. Based on the basic information, generate statistical charts for various types of steel structural components, and record the unique identifier of the steel structural components statistically analyzed in the charts; The statistical charts and the 3D model of the warehouse are output to the user interface, and the click positions entered by the user in the user interface are obtained; The unique identifier is determined based on the click location, and the steel structure model or the statistical chart is highlighted according to the unique identifier.

2. The method of claim 1, wherein the steel structural member warehouse is a steel structural member warehouse of a steel structural member manufacturer. The unique identifier is determined based on the click location, and the steel structure model or the statistical chart is highlighted according to the unique identifier, including: If the clicked location is on the statistical chart, then the unique identifier of the steel structure component in the current statistical chart is determined based on the clicked statistical chart, and the steel structure component corresponding to the unique identifier in the warehouse 3D model is highlighted. If the clicked location is on the steel structure model, then the unique identifier is determined based on the clicked steel structure model, and the statistical chart corresponding to the unique identifier is highlighted.

3. The method of claim 1, wherein the steel structural member warehouse is a steel structural member warehouse of a steel structural member manufacturer. Also includes: The second database stores real-time sensing data collected by sensors. The statistical charts and the warehouse 3D model are updated based on the real-time sensor data.

4. The intelligent visual management and control method for steel structure component storage according to claim 3, characterized in that, The sensors include position sensors and weight sensors. The real-time sensing data includes real-time position information and real-time weight information. The position sensors are located at key nodes of the shelves and at the intersections of warehouse aisles. The weight sensors are installed at the bottom of the storage shelves in the warehouse or at the load-bearing parts of the goods handling equipment.

5. The intelligent visual management and control method for steel structure component storage according to claim 3, characterized in that, The first database is a relational database, and the second database is a non-relational database.

6. The intelligent visual management and control method for steel structure component storage according to claim 1, characterized in that, The steel structure model is associated with the basic information of the corresponding steel structure. After outputting the statistical charts and the warehouse 3D model to the user interface, the following is also included: Receive query information input by the user, query the target steel structure model based on the query information, and quickly locate the target steel structure model; The associated basic information is visualized and output on the target steel structure model.

7. The intelligent visual management and control method for steel structure component storage according to claim 3, characterized in that, After updating the statistical charts and the warehouse 3D model based on the real-time sensor data, the process includes: According to the preset inventory warning strategy, the data in the updated statistical charts are analyzed for warning, and the result of the warning analysis determines whether to perform a warning operation.

8. An intelligent visual control device for steel structure component storage, characterized in that, include: The data storage module is used to store basic information, warehouse layout information and correlation information of steel structural components through a first database. The correlation information includes the correspondence between each steel structural component and the warehouse storage location. The model building module is used to build a warehouse body model and a steel structure model based on the basic information and the warehouse layout information, respectively, and to determine the position of each steel structure model according to the correspondence between each steel structure and the warehouse storage point, so as to obtain a three-dimensional warehouse model. Each steel structure model is associated with a unique identifier. The chart generation module is used to generate statistical charts of various types of steel structural components based on the basic information, and record the unique identifier of the steel structural components statistically analyzed in the charts. The human-computer interaction module is used to output the statistical charts and the warehouse 3D model on the user interface, and to obtain the click position input by the user on the user interface; An interactive highlighting module is used to determine the unique identifier based on the click location, and to highlight the steel structure model or the statistical chart according to the unique identifier.

9. A computer device, characterized in that, include: The system includes a memory and a processor, which are interconnected. The memory stores computer instructions, and the processor executes the computer instructions to perform the intelligent visual management and control method for steel structure component storage as described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer instructions, which are used to cause the computer to execute the intelligent visual management and control method for steel structure component storage as described in any one of claims 1 to 7.

Images