Method for displaying real-time inventory data of steel coils in silicon steel reservoir area

Abstract

The invention discloses a method for displaying real-time inventory data of steel coils in a silicon steel reservoir area, which comprises the following steps of: determining a reservoir area layout according to input design information; processing the data table according to the received message; and displaying a visual display graph of the reservoir area according to the layout of the reservoir area and the data table. According to the invention, integration and visual display of the steel coil stock information are realized, the display intuition of the stock information is improved, a decision maker can adjust a production plan according to the stock information, and the production efficiency is improved.

Description

Technical Field

[0001] The invention relates to the field of warehouse management, and in particular to a method for displaying real-time inventory data of steel coils in a silicon steel warehouse. Background Art

[0002] Today's existing steel coil inventory management systems are generally aimed at on-site operators, which facilitates on-site allocation of storage locations, and allows them to see whether there are steel coils in the storage locations, as well as the basic information of the steel coils. However, the company's decision-makers cannot clearly and intuitively understand the real-time inventory situation on site, and thus it is difficult to reasonably arrange production plans based on the inventory. Summary of the invention

[0003] The purpose of the present invention is to provide a method for displaying real-time inventory data of steel coils in a silicon steel warehouse area, so as to intuitively and clearly display the real-time inventory situation, so as to facilitate the decision-makers to arrange production plans in a targeted manner.

[0004] In order to solve the above technical problems, the present invention provides a technical solution: a method for displaying real-time inventory data of steel coils in a silicon steel warehouse, comprising:

[0005] S1. Determine the layout of the storage area based on the input design information;

[0006] S2. Process the data table according to the received message;

[0007] S3. Display a visualization diagram of the storage area based on the storage area layout and data table.

[0008] According to the above scheme, the design information is CAD design information used to manufacture the warehouse area.

[0009] According to the above scheme, step S1 includes:

[0010] S101, storing the storage area size information, shape information, and location information in the design information into a data table, and drawing the storage area in a storage area visualization display diagram;

[0011] S102, storing the number of storage locations and storage location numbers in the design information into a data table, and drawing the storage locations in a storage area visualization display diagram;

[0012] S103: Store the storage location partition information in the design information into a data table, and partition the storage locations in a storage area visualization display diagram.

[0013] According to the above scheme, the telegram comes from the production task issuing system, and the telegram includes the telegram number, operation mark, operation time, steel coil number, warehouse area, warehouse location, steel coil length, steel coil width, steel coil thickness, steel coil brand, steel coil weight, information mark, warehouse entry time, warehouse reversal time, and warehouse exit time.

[0014] According to the above scheme, step S2 includes:

[0015] S201, when the operation mark of the received message is added, the information in the message is stored in the data table;

[0016] S202, when the operation mark of the received electronic message is modification, and the steel coil in the electronic message already exists in the data table, modify the corresponding steel coil information in the data table;

[0017] S203, when the operation mark of the received message is modification, and the steel coil in the message does not exist in the data table, the information in the message is stored in the data table;

[0018] S204, when the operation mark of the received electronic message is deleted, and the steel coil in the electronic message already exists in the data table, delete the corresponding steel coil information in the data table;

[0019] S205. When the operation mark of the received message is deleted and the steel coil in the message does not exist in the data table, the message is ignored.

[0020] According to the above scheme, step S2 includes:

[0021] S206: Store the received electronic message in a log table.

[0022] According to the above scheme, the display information of the warehouse area visualization display diagram includes real-time inventory, steel coil information, the amount of steel coils with a storage age of more than seven days, and the amount of steel coils with a storage age of more than twenty days.

[0023] According to the above scheme, the display information of the warehouse area visualization display diagram includes monthly inventory trends and monthly over-age inventory trends; the over-age inventory includes the amount of steel coils with an age of more than seven days and the amount of steel coils with an age of more than twenty days.

[0024] A computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the method for displaying real-time inventory data of steel coils in a silicon steel warehouse area as described above is implemented.

[0025] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the above-mentioned method for displaying real-time inventory data of steel coils in a silicon steel warehouse.

[0026] The beneficial effects of the present invention are as follows: the present invention realizes real-time and visual monitoring of steel coils in the warehouse area by determining the warehouse area layout, processing data tables and displaying a visual display diagram of the warehouse area. This method can ensure the real-time update of inventory data and provide decision makers with accurate and intuitive inventory information, so that decision makers can adjust production tasks in a targeted manner, thereby improving production efficiency.

[0027] Furthermore, the present invention provides traceability for inventory data by storing received electronic messages in a log table. Through the log table, the history of each inventory change can be tracked, thereby enhancing the transparency and auditability of the data.

[0028] Furthermore, the present invention enables decision makers to take timely measures to deal with overage inventory by real-time monitoring of overage inventory, thereby reducing inventory costs and improving capital turnover. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] Figure 1 This is a flow chart of a method for displaying real-time inventory data of steel coils in a silicon steel warehouse area according to an embodiment of the present invention;

[0030] Figure 2 This is a diagram of a storage area management configuration interface according to an embodiment of the present invention;

[0031] Figure 3 This is a diagram of a reservoir area boundary configuration interface according to an embodiment of the present invention;

[0032] Figure 4 It is a stack position (storage position) attribute configuration of an embodiment of the present invention;

[0033] Figure 5 This is a diagram of a storage area stack position (storage position) configuration interface according to an embodiment of the present invention;

[0034] Figure 6 This is a diagram of a storage area partition configuration interface according to an embodiment of the present invention;

[0035] Figure 7 This is a steel coil inventory trend interface diagram according to an embodiment of the present invention;

[0036] Figure 8 This is a diagram of a steel coil information interface according to an embodiment of the present invention. DETAILED DESCRIPTION

[0037] In order to make the purpose, technical solution and advantages of the embodiments of the present disclosure clearer, the technical solution of the embodiments of the present disclosure will be clearly and completely described below in conjunction with the drawings of the embodiments of the present disclosure. Obviously, the described embodiments are part of the embodiments of the present disclosure, not all of the embodiments. Based on the described embodiments of the present disclosure, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present disclosure.

[0038] See also Figure 1 This embodiment discloses a method for displaying real-time inventory data of steel coils in a silicon steel warehouse, including:

[0039] S1. Determine the layout of the storage area based on the input design information;

[0040] S2. Process the data table according to the received message;

[0041] S3. Display a visualization diagram of the storage area based on the storage area layout and data table.

[0042] Furthermore, the design information is CAD design information used to manufacture the warehouse area.

[0043] Further, step S1 includes:

[0044] S101, storing the size information, shape information, and location information of the storage area in the design information into a data table, and drawing the storage area in a storage area visualization display diagram; specifically, drawing the shape, area, length, width, and height of the storage area on the page according to the given scale of the design drawing, and saving them into the storage area data table;

[0045] S102, storing the number of storage locations and the storage location number in the design information into a data table, and drawing the storage location in the storage area visualization display diagram; specifically, according to the number and number of stacking locations (storage locations) given by the design drawing, generating stacking locations (storage locations) in proportion to the design drawing, and saving the stacking locations (storage locations) into the stacking location data table;

[0046] S103, storing the storage location partition information in the design information into a data table, and partitioning the storage location in the storage area visualization display diagram; specifically, partitioning the generated stack locations (storage locations) according to the area distribution given in the design diagram, and saving the partitions into the stack location data table.

[0047] Furthermore, the telegram comes from the production task issuing system, and the telegram includes the telegram number, operation mark, operation time, steel coil number, warehouse area, warehouse location, steel coil length, steel coil width, steel coil thickness, steel coil brand, steel coil weight, information mark, warehouse entry time, warehouse reversal time, and warehouse exit time.

[0048] Further, step S2 includes:

[0049] S201, when the operation mark of the received message is added, the information in the message is stored in the data table;

[0050] S202, when the operation mark of the received electronic message is modification, and the steel coil in the electronic message already exists in the data table, modify the corresponding steel coil information in the data table;

[0051] S203, when the operation mark of the received message is modification, and the steel coil in the message does not exist in the data table, the information in the message is stored in the data table;

[0052] S204, when the operation mark of the received electronic message is deleted, and the steel coil in the electronic message already exists in the data table, delete the corresponding steel coil information in the data table;

[0053] S205. When the operation mark of the received message is deleted and the steel coil in the message does not exist in the data table, the message is ignored.

[0054] Further, step S2 includes:

[0055] S206: Store the received electronic message in a log table.

[0056] Furthermore, the display information of the warehouse area visualization display diagram includes real-time inventory, steel coil information, the amount of steel coils with a storage age of more than seven days, and the amount of steel coils with a storage age of more than twenty days.

[0057] Furthermore, the display information of the warehouse area visualization display diagram includes monthly inventory trends and monthly over-age inventory trends; the over-age inventory includes the amount of steel coils with an age of more than seven days and the amount of steel coils with an age of more than twenty days.

[0058] This embodiment uses XCOM technology to collect inventory transportation data, tracks steel coil data for ORACLE database storage, uses bladeX for back-end development, calculates and analyzes the collected data, and uses front-end development technology to visualize the analyzed data. For the visualization interface, see Figure 2 to Figure 8 In the visual operation interface of this embodiment, the detailed information of the steel coil can be viewed by clicking on the steel coil, and the monthly inventory trend and the monthly overage inventory trend can be viewed according to the month filtering function.

[0059] The previous inventory management system only allows the site to see the distribution of warehouse locations. If the leadership needs relevant information, the site can only provide reports, and the data is not intuitive. The present invention breaks the information barrier between the site and the leadership, allowing the decision-makers to intuitively see the inventory information on site, improving the visualization effect, and saving the time of making reports in the past, allowing the leadership to better arrange production tasks and improve production efficiency.

[0060] The above descriptions are merely embodiments of the present invention and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention specification and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. A method for displaying real-time inventory data of steel coils in a silicon steel warehouse, characterized in that: include: S1. Determine the layout of the storage area based on the input design information; S2. Process the data table according to the received message; S3. Display a visualization diagram of the storage area based on the storage area layout and data table.

2. The method for displaying real-time inventory data of steel coils in a silicon steel warehouse area according to claim 1 is characterized in that: The design information is CAD design information used to manufacture the warehouse area.

3. The method for displaying real-time inventory data of steel coils in a silicon steel warehouse area according to claim 1, characterized in that: Step S1 includes: S101, storing the storage area size information, shape information, and location information in the design information into a data table, and drawing the storage area in a storage area visualization display diagram; S102, storing the number of storage locations and storage location numbers in the design information into a data table, and drawing the storage locations in a storage area visualization display diagram; S103: Store the storage location partition information in the design information into a data table, and partition the storage locations in a storage area visualization display diagram.

4. The method for displaying real-time inventory data of steel coils in a silicon steel warehouse area according to claim 1, characterized in that: The telegram comes from the production task issuing system, and includes the telegram number, operation mark, operation time, steel coil number, warehouse area, warehouse location, steel coil length, steel coil width, steel coil thickness, steel coil brand, steel coil weight, information mark, warehouse entry time, warehouse reversal time, and warehouse exit time.

5. The method for displaying real-time inventory data of steel coils in a silicon steel warehouse area according to claim 4 is characterized in that: Step S2 includes: S201, when the operation mark of the received message is added, the information in the message is stored in the data table; S202, when the operation mark of the received electronic message is modification, and the steel coil in the electronic message already exists in the data table, modify the corresponding steel coil information in the data table; S203, when the operation mark of the received message is modification, and the steel coil in the message does not exist in the data table, the information in the message is stored in the data table; S204, when the operation mark of the received electronic message is deleted, and the steel coil in the electronic message already exists in the data table, delete the corresponding steel coil information in the data table; S205. When the operation mark of the received message is deleted and the steel coil in the message does not exist in the data table, the message is ignored.

6. The method for displaying real-time inventory data of steel coils in a silicon steel warehouse area according to claim 1, characterized in that: Step S2 includes: S206: Store the received electronic message in a log table.

7. The method for displaying real-time inventory data of steel coils in a silicon steel warehouse area according to claim 1, characterized in that: The information displayed on the warehouse area visualization display diagram includes real-time inventory, steel coil information, the amount of steel coils with a storage age of more than seven days, and the amount of steel coils with a storage age of more than twenty days.

8. The method for displaying real-time inventory data of steel coils in a silicon steel warehouse area according to claim 7, characterized in that: The display information of the warehouse area visualization display diagram includes monthly inventory trends and monthly over-age inventory trends; the over-age inventory includes the amount of steel coils with an age of more than seven days and the amount of steel coils with an age of more than twenty days.

9. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the method for displaying real-time inventory data of steel coils in a silicon steel storage area according to any one of claims 1 to 8 is implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the method for displaying real-time inventory data of steel coils in a silicon steel storage area according to any one of claims 1 to 8 is implemented.

Images