Method, apparatus and storage medium for generating records of batching ratio changes in a mixing yard

Abstract

This invention provides a method, apparatus, and storage medium for generating batching ratio change records in a mixing yard. The method includes: an OPC server collecting and storing in real-time the material number and material ratio of materials stored in each hopper and bin of each material shed in the mixing yard, as well as the location of the stacker and the pile number; when any of the material number, material ratio, stacker location, or pile number changes, the OPC server records the change using a historical data table, the historical data table including: data address, insertion time, data type, and data value; and generating a batching ratio change record for each shed. Using this technical solution, the historical changes in materials and / or material ratios in sheds or piles can be conveniently provided or displayed to operators.

Description

Technical Field

[0001] This invention relates to the field of automatic control technology, and in particular to a method, apparatus and storage medium for generating records of changes in the batching ratio of a mixing yard. Background Technology

[0002] The blending yard is a crucial component of the raw material yard in modern steel enterprises. It consists of multiple sheds, each containing multiple bins, which are then stacked by conveyor belts and stackers. Different bins contain different materials, and the proportions of each material vary during stacking. The batching and proportions in the blending yard are frequently and dynamically changing. At the start of each stacking operation, the OPC server generates a large stack number. Field operators are interested in the historical changes in the batching and proportions of a specific large stack in the blending yard. Currently, while primary PLC data in the steel industry collects real-time material and batching data for each bin, typical secondary systems do not display records of batching and proportion changes for a specific large stack in the blending yard. Therefore, to facilitate field operations, a method for obtaining records of batching and proportion changes in the blending yard is urgently needed. Summary of the Invention

[0003] The embodiments of the present invention provide a method, apparatus and storage medium for generating records of changes in batching ratios in a mixing yard, so that operators can understand the historical changes in the batching ratios of the shed or stockpile.

[0004] This invention provides a method for generating records of batching ratio changes in a mixing yard, comprising:

[0005] The OPC server collects and stores in real time the material number and material ratio of each material in each shed and bin of the mixing yard, as well as the location and pile number of the stacker.

[0006] When any of the material number, material ratio, stacker location, or bulk pile number changes, the OPC server records the changes through a historical data table. The historical data table records the following information: data address, insertion time, data type, and data value.

[0007] Generate a record of changes in the batching ratio for each material shed, including:

[0008] Obtain the latest stockpile number generated in the material shed;

[0009] Retrieve the insertion time of the latest bulk pile number from the historical data table, as well as all records related to the material number and material ratio of all silos in the material shed after the insertion time of the latest bulk pile number;

[0010] When the number of all relevant records N obtained is greater than 1, where N is a natural number, N-1 batching ratio change records are generated based on the N obtained records. The batching ratio change records include the following items: material shed number, bulk pile number, silo number, previous material number, current material number, previous material ratio, current material ratio, change content, and change time.

[0011] Preferably, the method further includes, if the number of records N obtained is greater than 1:

[0012] Based on the insertion time of the last record among all records related to the material number and material ratio of all silos in the material shed, find the stacker position in the historical data table that is closest to the insertion time of the last record under the same material shed and is used as the current stacker position.

[0013] The current stacker location is included in the batching ratio change record.

[0014] Preferably, the method, wherein the step of pre-establishing a batching ratio change record table for storing batching ratio records and obtaining the latest large pile number generated in the material shed includes:

[0015] S31, retrieve the latest large pile number of the material shed from the batching ratio change record table according to the change time; if the latest large pile number is not retrieved from the batching ratio change record table, select a large pile number of the material shed before the selected time period from the historical data table as the old large pile number, and obtain the insertion time of the old large pile number.

[0016] S32, based on the insertion time of the old pile number, determine from the historical data table whether there is a pile number newer than the old pile number in the material shed; if so, take the latest pile number among the pile numbers newer than the old pile number as the latest pile number; if not, take the old pile number as the latest pile number.

[0017] Preferably, in the method, in step S32, if there is no newest large pile number among the large pile numbers that is newer than the old large pile number, the insertion time of the old large pile number is subtracted by a predetermined first duration to obtain the first update insertion time, and the first update insertion time and all records related to the material number and material ratio of all silos in the material shed after the first update insertion time are obtained from the historical data table to generate the batching ratio change record.

[0018] Preferably, in the method, after step S32, the latest large-scale pile number among those newer than the old large-scale pile number is used as the latest large-scale pile number, the method further includes:

[0019] The first update insertion time is obtained by subtracting the predetermined first duration from the insertion time of the old bulk pile number. The second update insertion time is obtained by subtracting the predetermined second duration from the insertion time of the latest bulk pile number. All records related to the material number and material ratio of all silos in the material shed are obtained from the historical data table, with the insertion time after the first update insertion time and before the second update insertion time, to generate the batching ratio change record.

[0020] Preferably, the method further includes, after generating the ingredient ratio change record:

[0021] The deletion time is determined based on the insertion time of the last data record used to generate the ingredient ratio change record in the historical data table. Data records before the deletion time in the historical data table are deleted. The deletion time is obtained by subtracting the selected duration from the insertion time of the last data record.

[0022] Preferably, in the method, the changes occurring are recorded when any of the material number, material proportion, stacker location, and bulk pile number changes, based on the storage address of each data item, using KepWare software subscription events.

[0023] Preferably, in the method, a historical data table and the following tables are created in a relational database:

[0024] A separate stacker position change table is used to store stacker position change records, and the stacker position change is only recorded in the table when the stacker position change exceeds one meter;

[0025] The address table is used to store the addresses of material numbers and material ratios of materials stored in each shed and silo in the OPC server. It includes: primary key ID, corresponding shed number and corresponding silo material number address or material ratio address.

[0026] On the other hand, an apparatus is provided for generating a record of changes in the batching ratio of a mixing yard, including a memory and a processor, wherein the memory stores at least one program, and the at least one program is executed by the processor to implement any of the methods described above.

[0027] In another aspect, a computer-readable storage medium is provided, wherein at least one program is stored in the storage medium, the at least one program being executed by a processor to implement any of the methods described above.

[0028] The above technical solution has the following technical effects:

[0029] The technical solution of this invention utilizes data collected in real time by an OPC server. When changes occur in the material number and material ratio of the materials stored in the silo, the location of the stacker, and the pile number, the changes are recorded in a historical data table. For each silo, the historical data table is used to obtain the records of changes in the material number and material ratio of all silos related to the latest pile number in that silo to generate a batching ratio change record. This links a large amount of scattered and independent data, allowing operators to easily understand the historical changes in the materials and material ratios of the silo or pile.

[0030] In a further embodiment of the present invention, in order to improve data processing efficiency, a separate stacker position change table and a separate address table are established; and when obtaining historical data from the historical data table, the insertion time is processed to avoid missing possible historical changes; in addition, by deleting the processed data, the program can run repeatedly to continuously record variables without worrying about server lag caused by the increasing amount of data. Attached Figure Description

[0031] Figure 1 This is a flowchart illustrating a method for generating a batching ratio change record in a mixing field according to an embodiment of the present invention.

[0032] Figure 2 This is a schematic diagram of the device for generating a record of changes in the batching ratio of a mixing yard according to an embodiment of the present invention. Detailed Implementation

[0033] To further illustrate the various embodiments, the present invention provides accompanying drawings. These drawings are part of the disclosure of the present invention, primarily used to illustrate the embodiments and to explain the operating principles of the embodiments in conjunction with the relevant descriptions in the specification. With reference to these drawings, those skilled in the art should be able to understand other possible implementations and the advantages of the present invention. Components in the drawings are not drawn to scale, and similar component symbols are generally used to represent similar components.

[0034] The present invention will now be further described in conjunction with the accompanying drawings and specific embodiments.

[0035] Example 1:

[0036] Figure 1 This is a schematic flowchart illustrating a method for generating a record of changes in the batching ratio of a mixing yard according to an embodiment of the present invention. Figure 1 The method for generating a batching ratio change record of a mixing yard according to an embodiment of the present invention includes the following steps:

[0037] S1, the OPC server collects and stores in real time the material number and material ratio of each material in each shed and bin of the mixing yard, as well as the location of the stacker and the pile number; in specific implementation, each shed and bin will have its own shed number and bin number, and this data will not change continuously; the material number and material ratio will be associated with the corresponding bin number and shed number; the pile number will also be associated with the corresponding shed number;

[0038] S2, when any of the material number, material ratio, stacker location, and pile number changes, the OPC server records the changes through a historical data table. The historical data table records the data address, insertion time, data type, and data value. Preferably, in the OPC server, based on the storage address of each data item, KepWare software subscription events are used to record the changes when any of the material number, material ratio, stacker location, and pile number changes.

[0039] S3 generates batching ratio change records for each material shed, including: obtaining the latest bulk pile number generated in the material shed; obtaining the insertion time of the latest bulk pile number from the historical data table, and all records related to the material number and material ratio of all silos in the material shed after the insertion time of the latest bulk pile number; when the number N of all relevant records obtained is greater than 1, where N is a natural number, generating N-1 batching ratio change records based on the N records obtained. The batching ratio change record includes the following items: material shed number, bulk pile number, silo number, previous material number, current material number, previous material ratio, current material ratio, change content, and change time. Among them, the change content reflects the change from the data value before the change to the data value after the change.

[0040] The above-mentioned acquisition of N records means that N-1 changes have occurred. If there is only one record, there is no change; if there are two records, it means there has been one change. And so on.

[0041] Preferably, in the method of this embodiment, if the number of records N obtained is greater than 1, the method further includes: based on the insertion time of the last record among all records related to the material number and material ratio of all silos in the material shed, searching in the historical data table for the stacker position under the same material shed that has an insertion time less than or equal to the insertion time of the last record and is closest to the insertion time of the last record as the current stacker position; and including the current stacker position in the batching ratio change record.

[0042] The current stacker position included in the batching ratio change record is used by the operator to determine whether the material is uniform during stacking and whether the stacker is malfunctioning.

[0043] Preferably, in the method of this embodiment of the invention, the step of pre-establishing a batching ratio change record table for storing batching ratio records and obtaining the latest large pile number generated in the material shed includes:

[0044] S31, retrieve the latest large pile number of the material shed from the batching ratio change record table according to the change time; if the latest large pile number is not retrieved from the batching ratio change record table, select a large pile number of the material shed before the selected time period from the historical data table as the old large pile number, and obtain the insertion time of the old large pile number.

[0045] S32, based on the insertion time of the old pile number, determine from the historical data table whether there is a pile number newer than the old pile number in the material shed; if so, take the latest pile number among the pile numbers newer than the old pile number as the latest pile number; if not, take the old pile number as the latest pile number.

[0046] In the initial ingredient ratio change record table, all data were empty when there were no records of ingredient ratio changes.

[0047] In other embodiments of the invention, the latest stockpile number generated in the shed can also be obtained in other ways; for example, by looking up a historical data table.

[0048] Preferably, in the method of this embodiment of the invention, in step S32 above, if there is no newest large pile number among the large pile numbers that is newer than the old large pile number, then the insertion time of the old large pile number is subtracted by a predetermined first duration to obtain the first update insertion time, and the first update insertion time and all records related to the material number and material ratio of all silos in the material shed after the first update insertion time are obtained from the historical data table to generate a batching ratio change record. Preferably, the first duration is 1 second or 2 seconds.

[0049] Preferably, in step S32, after taking the latest large pile number from the large pile numbers that are newer than the old large pile number as the latest large pile number, the method further includes:

[0050] The first update insertion time is obtained by subtracting a predetermined first duration from the insertion time of the old bulk pile number. The second update insertion time is obtained by subtracting a predetermined second duration from the insertion time of the latest bulk pile number. All records related to the material number and material ratio of all silos in the material shed, with insertion times after the first update insertion time and before the second update insertion time, are retrieved from the historical data table to generate the batching ratio change record. Preferably, the second duration is 1 second or 2 seconds.

[0051] Using the update insertion time is to avoid data omissions. For example, in the recorded data, material B was at 14:10:999, and now it is 14:15:000. A record A->B is generated, with the change time being 14:10:999. The program used to implement the method of this invention runs continuously in a loop. At 14:16, it starts scanning again from the beginning and finds the latest change record that occurred at 14:10:999. However, due to unpredictable reasons such as different computer operating system versions, it rounds up and assumes that the latest change record occurred at 14:11:000, then finds that material C changed to material C at 14:15:555. If the time is not reduced by one second, the record B->C might be missed.

[0052] Preferably, the method of this embodiment further includes, after generating the ingredient ratio change record:

[0053] The deletion time is determined based on the insertion time of the last data record used to generate the ingredient ratio change record in the historical data table. Data records before the deletion time in the historical data table are deleted. The deletion time is obtained by subtracting the selected duration from the insertion time of the last data record. To avoid excessive data volume, expired data will be deleted. The specific retention period is set according to the specific scenario.

[0054] The method of this invention can be implemented by a program or software. In specific applications, the above-mentioned method of this invention runs continuously and is a process of continuously monitoring and recording the material and / or material ratio changes in the mixing yard shed or large pile.

[0055] Example 2:

[0056] In this embodiment, data tables are created using a relational database such as MySQL. The steps of this embodiment are described in detail below:

[0057] 1. The on-site OPC server collects the material number and material ratio stored in each silo in real time, and collects the location and stack number of the stacker in real time; where OPC refers to Object Linking and Embedding OLE Process Control.

[0058] 2. Based on the address of each data item in the OPC server, the KepWare industrial IoT communication platform software is used to subscribe to events. When the subscribed data in the OPC changes, it is stored in a MySQL database table. In this example, the subscribed data includes the material number and material ratio stored in each silo, as well as the location and pile number of the stacker crane. When the subscribed data changes, it is stored in a pre-created table named PLCDataHistory. This table has four fields, for example: Data Address (NodeId), Insert Time (InsertTime), Data Type (DataType), and Data Value (DataVal). NodeId and InsertTime form a joint component for easy subsequent lookup. Data Address refers to the address where the data is stored in the OPC server; Insert Time is the time when the changed data is inserted into this table; Data Type refers to whether the data is integer or floating-point; Data Value is the specific numerical value corresponding to the parameter, such as the value of the material number.

[0059] Since large stack numbers are typically generated only every few days, and the materials and material ratios in each silo change only every few tens of minutes, KepWare software's event subscription is used. Data is only stored in the database when the subscribed data in OPC changes, significantly saving database storage space. Specifically, because the stacker crane's position is constantly changing during the stacking process, generating several data entries per second, which puts a significant burden on the database, data is only stored when the stacker crane's position changes by more than one meter. Observations show this reduces data by approximately three-quarters. Furthermore, the stacker crane's position is stored in a separate table, PlcDataMoveDistance, with the same fields as PlcDataHistory. This reduces the time spent retrieving data from PlcDataHistory and facilitates the later deletion of expired data in the PlcDataMoveDistance table according to certain rules, preventing server slowdowns caused by excessive data volume in the PlcDataMoveDistance table.

[0060] 3. Create a table named PlcDataAddress in the MySQL database to store the addresses of OPC data. This table has three fields: primary key Id, shed number RegionNo, and OPC address Address. This table stores only two types of OPC addresses: the addresses of material numbers for all silos, and the addresses of material proportions for all silos. In one specific implementation, these addresses can be obtained from the Kepware configuration. Next, create a table named BlendChangedRecord to store records of batching proportion changes in the blending yard. This table has the following fields: primary key Id, shed number RegionNo, bulk pile number BlendPlanNo, silo number SiloNo, previous material number OldMaterialNo, current material number NewMaterialNo, previous material proportion OldFormula, current material proportion NewFormula, current stacker position MoveDistance, change content ChangeContent, and change time ChangeTime.

[0061] 4. The mixing yard consists of multiple sheds, which are independent of each other, but the method for generating batch ratio change records is the same for each shed. The following only describes the method for generating batch ratio change records for a single shed; the same principle applies to other sheds. Create a timed, repetitive program that retrieves all shed numbers from PlcDataAddress, iterates through all shed numbers, and performs the following processing sequentially.

[0062] 5. First, retrieve the material number addresses and material ratio addresses of all silos for a single shed from the PlcDataAddress table, naming the list opcAddressList. Scan the BlendChangedRecord table, sorting by change time in reverse order, to obtain the latest bulk pile number for a given shed. If the return value is empty, retrieve the earliest bulk pile number for a given shed from the PlcDataHistory table, sorted by insertion time in ascending order. Name the obtained bulk pile number oldBlend.

[0063] This step retrieves the latest stockpile number for a specific material shed from the BlendChangedRecord table, which records changes in the batching ratio. An empty return value indicates that no record with the latest stockpile number was found in the table. In this case, a stockpile number can be retrieved from the PlcDataHistory table, which records historical data. To ensure the integrity of the change records, this stockpile number can be an earlier stockpile number, i.e., an earlier oldBlend. The specific stockpile number can be set, for example, it can be a stockpile number from one year earlier.

[0064] 6. After obtaining the large pile `oldBlend`, retrieve the insertion time `oldTime` of that large pile number from the `PLcDataHistory` table. First, determine if the data for this large pile number has been processed. If it has, proceed to process new large piles; otherwise, continue processing the current large pile. The method for determining completion is to check if there have been any new material or ratio changes in a particular silo within a certain time period. This time period is determined by whether new large pile numbers have been generated. If no new large pile numbers have been generated, it is assumed that the time from the last change record up to the current moment is still considered an unprocessed large pile number and processing should continue. For example, the specific implementation of this determination method is as follows: Add one second to `oldTime`, retrieve the large pile numbers of the silo whose insertion time is greater than `oldTime` from the `PLcDataHistory` table, and sort them in ascending order by insertion time, naming them `blendList`. If `blendList` is empty, it means there are no new large piles; if it is not empty, it means there are new large piles. Take the first object in `blendList`, which is the new large pile to be processed, named `newBlend`, and its insertion time named `newTime`.

[0065] Since oldBlend might be an older heap number, there might be a new heap number. If there is a new heap number, process that new heap number; otherwise, continue processing the old heap number.

[0066] 7. If no new large heap is found, subtract two seconds from oldTime, retrieve all data from the PlcDataHistory table whose insertion time is greater than oldTime and whose NodeId is equal to the sub-item in opcAddressList, and name it plcDataHisList.

[0067] To avoid missing records, retrieve the historical data records from the PLCDataHistory table, specifically the corresponding material number address and material number ratio address, two seconds before the insertion time of this old batch.

[0068] 8. If there is a new large heap, subtract two seconds from oldTime and one second from newTime. Retrieve all data from the PLCDataHistory table whose insertion time is greater than oldTime and less than newTime, and whose NodeId is equal to the child item in opcAddressList, and name it plcDataHisList.

[0069] Subtracting two seconds from oldTime and one second from newTime here is also to avoid missing changed data; that is, considering the historical data records in the historical data table from two seconds before oldTime to one second before newTime, corresponding to the material number address and material number ratio address, to determine the changes that have occurred in the materials or material ratios related to this pile during this time period; among them, the changes in materials are reflected through changes in material numbers.

[0070] 9. Iterate through opcAddressList, processing each OPC address one by one, and name the result opcAddress. Filter from plcDataHisList, selecting NodeId equal to opcAddress, sorting them in ascending order by insertion time, and name the result samePlcList.

[0071] 10. Iterate through `samePlcList`. For every two child items, generate a `blendChangedRecord`. The two child items are `lastItem` and `currentItem`. The corresponding siloNo can be obtained from `opcAddress`. If `opcAddress` represents the material number of siloNo, then every two child items have two material numbers: the old material number `oldMaterialNo` and the new material number `newMaterialNo`. The change content `ChangeContent` is "oldMaterialNo->newMaterialNo". If `opcAddress` represents the material ratio of a siloNo, then every two child items have two material ratios: the old material ratio `oldFormula` and the new material ratio `newFormula`. It is also necessary to find which material ratio has changed. Search the `plcDataHisList` table for the material number `materialNo` whose insertion time is less than and closest to the insertion time of `lastItem`, and whose silo number is equal to `siloNo`. The change content `ChangeContent` is "materialNo: oldFormula->newFormula".

[0072] 11. Next, obtain the current position of the stacker. Obtain the insertion time (lastInsertTime) of the last item in samePlcList. Then, obtain the data in the PLCDataMoveDistance table that is in the same material shed and whose insertion time is less than or equal to lastInsertTime and is closest to lastInsertTime. This data can be used to obtain the position (moveDistance) of the stacker.

[0073] 12. Based on the above, a complete record of the ingredient ratio change can be generated. Before inserting this record into the BlendChangedRecord table, check if there is any identical data in the table based on the change content and insertion time. Only store it if there is none. To avoid long query times due to an excessively large database table, some data in the PLcDataHistory and PLcDataMoveDistance tables can be partially deleted. Using the lastInsertTime obtained in the previous step, delete data from the PLcDataHistory table whose insertion time is less than lastInsertTime and whose NodeId equals opcAddress. After iterating through each opcAddress, a lastInsertTime is generated. Take the minimum value from these lastInsertTimes and name it minDateTime. Delete data from the PLcDataMoveDistance table whose insertion time is less than minDateTime.

[0074] 13. The above steps not only generate the batching ratio record for the mixing yard, but also delete the data in the database that has already been processed in the OPC, allowing the program to run repeatedly without worrying about the program lag due to the increasing amount of data. Other secondary systems can retrieve and display the batching ratio change records from the BlendChangedRecord table in the database, and can also filter the data by time, shed number, stockpile number, bin number, etc.

[0075] The specific names of the variables and tables described above are merely illustrative and may be changed to other names, and are not intended to limit the scope of protection of this invention.

[0076] Example 3:

[0077] The present invention also provides an apparatus for generating records of changes in the batching ratio of a mixing yard, such as... Figure 2 As shown, the device includes a processor 201, a memory 202, a bus 203, and a computer program stored in the memory 202 and executable on the processor 201. The processor 201 includes one or more processing cores. The memory 202 is connected to the processor 201 via the bus 203. The memory 202 is used to store program instructions. When the processor executes the computer program, it implements the steps in the above-described method embodiment of Embodiment 1 of the present invention.

[0078] Furthermore, as an executable solution, the device for generating records of batching ratio changes in the mixing yard can be a computer unit, which can be a desktop computer, laptop, handheld computer, or cloud server, etc. The computer unit may include, but is not limited to, a processor and memory. Those skilled in the art will understand that the above-described structure of the computer unit is merely an example and does not constitute a limitation on the computer unit. It may include more or fewer components, or combine certain components, or use different components. For example, the computer unit may also include input / output devices, network access devices, buses, etc., and this embodiment of the invention does not limit this.

[0079] Furthermore, as an executable solution, the processor can be a Central Processing Unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor can be a microprocessor or any conventional processor, etc. The processor is the control center of the computer unit, connecting various parts of the entire computer unit via various interfaces and lines.

[0080] The memory can be used to store the computer programs and / or modules. The processor implements various functions of the computer unit by running or executing the computer programs and / or modules stored in the memory and by calling data stored in the memory. The memory may mainly include a program storage area and a data storage area. The program storage area may store the operating system and at least one application program required for a function; the data storage area may store data created based on the use of the mobile phone, etc. In addition, the memory may include high-speed random access memory and may also include non-volatile memory, such as hard disk, RAM, plug-in hard disk, smart media card (SMC), secure digital card (SD), flash card, at least one disk storage device, flash memory device, or other volatile solid-state storage device.

[0081] Example 4:

[0082] The present invention also provides a computer-readable storage medium storing a computer program, which, when executed by a processor, implements the steps of the method described in the embodiments of the present invention.

[0083] If the modules / units integrated in the computer unit are implemented as software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, all or part of the processes in the methods of the above embodiments can also be implemented by a computer program instructing related hardware. The computer program can be stored in a computer-readable storage medium, and when executed by a processor, it can implement the steps of the various method embodiments described above. The computer program includes computer program code, which can be in the form of source code, object code, executable files, or certain intermediate forms. The computer-readable medium can include: any entity or device capable of carrying the computer program code, recording media, USB flash drives, portable hard drives, magnetic disks, optical disks, computer memory, read-only memory (ROM), random access memory (RAM), and software distribution media, etc. It should be noted that the content contained in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction.

[0084] Although the invention has been specifically shown and described in conjunction with preferred embodiments, those skilled in the art should understand that various changes in form and detail may be made to the invention without departing from the spirit and scope of the invention as defined in the appended claims, all of which shall be within the scope of protection of the invention.

Claims

1. A method for generating records of batching ratio changes in a mixing yard, characterized in that, include: The OPC server collects and stores in real time the material number and material ratio of each material in each shed and bin of the mixing yard, as well as the location and pile number of the stacker. When any of the material number, material ratio, stacker location, and bulk pile number changes, the OPC server records the changes through a historical data table. The historical data table records the following information: data address, insertion time, data type, and data value. Generate a record of changes in the batching ratio for each material shed, including: Obtain the latest stockpile number generated in the material shed; Obtain the insertion time of the latest bulk pile number from the historical data table, and all records related to the material number and material ratio of all silos in the material shed after the insertion time of the latest bulk pile number; When the number of all relevant records N is greater than 1, where N is a natural number, N-1 batching ratio change records are generated based on the N records. The batching ratio change records include the following items: shed number, stockpile number, silo number, previous material number, current material number, previous material ratio, current material ratio, change content, and change time.

2. The method according to claim 1, characterized in that, If the number of records N obtained is greater than 1, then it also includes: Based on the insertion time of the last record among all records related to the material number and material ratio of all silos in the material shed, the current stacker position is found in the historical data table under the same material shed, with an insertion time less than or equal to the insertion time of the last record and closest to the insertion time of the last record. The current stacker position is included in the batching ratio change record.

3. The method according to claim 1, characterized in that, A pre-established table for storing ingredient ratio change records is used. The step of obtaining the latest bulk pile number generated in the material shed includes: S31, obtain the latest large pile number of the material shed from the batching ratio change record table according to the change time; if the latest large pile number is not obtained from the batching ratio change record table, select a large pile number of the material shed before the selected time period from the historical data table as the old large pile number, and obtain the insertion time of the old large pile number. S32, based on the insertion time of the old large pile number, determine from the historical data table whether there is a large pile number newer than the old large pile number in the material shed; if so, take the latest large pile number among the large pile numbers newer than the old large pile number as the latest large pile number; if not, take the old large pile number as the latest large pile number.

4. The method according to claim 3, characterized in that In step S32, if there is no newest large pile number among the large pile numbers that is newer than the old large pile number, the insertion time of the old large pile number is subtracted by a predetermined first duration to obtain the first update insertion time. Then, the first update insertion time and all records related to the material number and material ratio of all silos in the material shed after the first update insertion time are obtained from the historical data table to generate the batching ratio change record.

5. The method according to claim 3, characterized in that, In step S32, after taking the latest large-pile number from the large-pile numbers that is newer than the old large-pile number as the latest large-pile number, the method further includes: The first update insertion time is obtained by subtracting a predetermined first duration from the insertion time of the old bulk pile number, and the second update insertion time is obtained by subtracting a predetermined second duration from the insertion time of the latest bulk pile number. The batching ratio change record is generated by retrieving all records from the historical data table that are inserted after the first update insertion time and before the second update insertion time and are related to the material number and material ratio of all silos in the material shed.

6. The method according to claim 1, characterized in that, After generating the ingredient ratio change record, the following is also included: The deletion time is determined based on the insertion time of the last data record used to generate the ingredient ratio change record in the historical data table. Data records before the deletion time in the historical data table are deleted. The deletion time is obtained by subtracting the selected duration from the insertion time of the last data record.

7. The method according to claim 1, characterized in that, In the OPC server, based on the storage address of each data item, KepWare software subscription events are used to record changes when any of the material number, material ratio, stacker location, and bulk pile number changes.

8. The method according to claim 1, characterized in that, Create the historical data table and the following table in the relational database: A separate stacker position change table is used to store stacker position change records, and the stacker position change is only recorded in the table when the stacker position change exceeds one meter; The address table is used to store the addresses of the material numbers and material ratios of the materials stored in each shed and each bin in the OPC server. It includes: primary key ID, the corresponding shed number and the address of the corresponding bin material number or the address of the material ratio.

9. An apparatus for generating records of batching ratio changes in a mixing yard, characterized in that, It includes a memory and a processor, the memory storing at least one program, the at least one program being executed by the processor to implement the method as claimed in any one of claims 1 to 8.

10. A computer-readable storage medium, characterized in that, The storage medium stores at least one program segment, which is executed by a processor to implement the method as described in any one of claims 1 to 8.

Images