Automatic container wharf quay crane production operation history playback method and application

Abstract

The invention discloses an automatic container wharf quay crane production operation history playback method and application. The method comprises the following steps: S1, a storage process of automatic container wharf quay crane production operation history data; and S2, carrying out playback and GUI (Graphical User Interface) display flow on the production operation historical data of the quay crane of the automatic container terminal. The technical problems that in the prior art, automatic container wharf quay crane production operation is difficult to trace, causes of problems cannot be analyzed, and the production operation rate is affected are solved, a historical playback function is added in the GUI, monitoring playback and scene reproduction of quay crane production operation task information are added, and the production operation efficiency is improved. The problem root in the production operation can be conveniently searched, the potential optimization nodes in the operation process can be analyzed, and the overall production efficiency is improved.

Description

Technical Field

[0001] The present invention relates to the field of monitoring playback technology, and more specifically, to a method and application for playback of production operation history of an automated container terminal quay crane. Background Art

[0002] In recent years, influenced by the industrial wave, the automation transformation and construction of port terminals have been accelerated. As we all know, the various resources of port terminals are limited, but the growth of cargo volume is immeasurable. This makes how to optimize the corresponding production operation process and improve loading and unloading efficiency an urgent problem for terminal users.

[0003] Traditional container terminals monitor the production operations related to shore container gantry cranes (hereinafter referred to as quay cranes) basically only for equipment-related information including the status of container terminal loading and unloading equipment; and the functional modules related to automated container terminal loading and unloading equipment are not integrated with the user graphical interface (hereinafter referred to as GUI) of terminal production operations, but are scattered in other business systems. Due to the lack of background information on relevant production operations such as task information and operation scenarios, some delayed production operation problems (such as actual production operation data not matching business scenarios) are often difficult to trace to their source, and even the cause of the problem cannot be analyzed, resulting in the inability to solve the problem through conventional means, thus affecting the production operation rate. Summary of the invention

[0004] The purpose of the present invention is to provide a method and application for historical playback of production operations of automated container terminal quay cranes, so as to solve the technical problems existing in the prior art such as difficulty in tracing the source of automated container terminal quay crane production operations, inability to analyze the causes of problems, and affecting the production operation rate. By adding a historical playback function in the GUI, and increasing the monitoring, playback and scene reproduction of quay crane production operation task information, it is not only convenient to find the root causes of problems in production operations, but also conducive to analyzing potential optimization nodes in the operation process, thereby improving overall production efficiency.

[0005] In order to achieve the above object, the present invention adopts the following technical solutions:

[0006] The present invention provides a method for replaying the production operation history of an automated container terminal quay crane, comprising the following steps:

[0007] S1. Storage process of historical data of automated container terminal quay crane production operations;

[0008] S2. Playback and GUI display process of historical data of automated container terminal gantry crane production operations.

[0009] As one aspect of the method for replaying the history of production operations of an automated container terminal quay crane of the present invention, S1 comprises the following steps:

[0010] S11. Storage process of equipment historical data of automated container terminal quay crane production operations;

[0011] S12. The process of storing the task history data of the automated container terminal gantry crane production operation.

[0012] As one aspect of the method for replaying the history of production operations of an automated container terminal quay crane of the present invention, the S11 comprises the following steps:

[0013] S111. Read the configuration file information as initialization subscription information;

[0014] S112. Connect the device data collector according to the information of the configuration file in step S111;

[0015] S113. Subscribe to real-time data according to the configuration file information in step S111;

[0016] S114. After the subscription is successful, the callback function is used to determine if there are updated data items. If the subscription fails, the process returns to step S113 to re-subscribe to the device real-time data.

[0017] S115. Receive real-time data and store it in a time series database.

[0018] As one aspect of the method for replaying the history of production operations of an automated container terminal quay crane of the present invention, the S111 comprises the following steps:

[0019] S1111. Write the server information, subscription point information and device attribute information corresponding to the subscription point in the system configuration file in advance;

[0020] S1112. When the history playback function module starts running, it reads the server information, subscription point information, and device attribute information corresponding to the subscription point as initialization subscription information.

[0021] As one aspect of the method for replaying the history of production operations of an automated container terminal quay crane of the present invention, the S12 comprises the following steps:

[0022] S121. Select a type of task, define a historical data table containing all such real-time task information in the database, for storing task history data;

[0023] S122. Write corresponding SQL statements for the creation, update, and deletion operations of data in the historical data table in step S121, and create triggers;

[0024] S123. Determine whether the currently created trigger is the trigger of the last task type. If it is not the trigger of the last task type, select a task of a type that has not created a trigger, and continue to repeat steps S121 and S122;

[0025] S124. If the trigger of the last task type, that is, the trigger of all types of tasks is created, when the real-time task information changes, the corresponding trigger is automatically activated to record the historical data of the real-time task information.

[0026] As one aspect of a method for replaying the history of production operations of an automated container terminal quay crane of the present invention, S2 comprises the following steps:

[0027] S21. Open the GUI history playback interface and initialize the history data playback function module;

[0028] S22. Set the query condition related parameters in the opened GUI history playback interface, and confirm the history playback operation by clicking the play button;

[0029] S23. The historical data playback function module receives and updates the query condition related parameters from step S22 and starts the playback process;

[0030] S24. The GUI history playback interface continuously refreshes the display content according to the history data pushed in step S23, starting from the set playback start time until the history data playback function module no longer pushes new history data.

[0031] As one aspect of the method for replaying the history of production operations of an automated container terminal quay crane of the present invention, the S23 comprises the following steps:

[0032] S231 determines whether the current playback time history data has been played back. If playback is complete, the process ends;

[0033] S232. If the playback is not completed, determine whether there is any unplayed historical data cached at present. If not, read the equipment and task historical data storing the production operation; otherwise, proceed to step S234;

[0034] S233. Read the stored equipment and task history data to determine whether all history data has been completely read. If not, return to step S232. Otherwise, proceed to step S234.

[0035] S234. The GUI analyzes the historical data of the organization changes, outputs the historical data of the organization changes, and pushes it to the GUI history playback function interface for display;

[0036] S235. Calculate the next play time according to the specified rules, and use it as the new current play time, and return to step S231.

[0037] As one aspect of the method for replaying the history of production operations of an automated container terminal gantry crane of the present invention, the specified rule in S235 is: next current play time = current play time + play frequency x play speed.

[0038] The present invention also provides an application for replaying the production operations of automated container terminal quay cranes, which corresponds to the method for replaying the production operations of automated container terminal quay cranes and is comprehensively applied to multiple types of quay cranes, such as single-trolley and double-trolley quay cranes, to realize historical monitoring of the production operations of automated container terminal quay cranes.

[0039] An application for replaying the production operation history of an automated container terminal quay crane is used for monitoring and replaying the equipment status related information of the automated container terminal quay crane, and is also used for the backtracking of operation task information and the simulation of production operation scenes.

[0040] By adopting the above technical solution, the present invention has the following advantages:

[0041] The present invention provides a method and application for replaying the history of production operations of a quay crane at an automated container terminal. The method adds a history replay function in the GUI, and increases the monitoring, playback and scene reproduction of the quay crane production operation task information. This method can not only facilitate finding the root causes of problems in the equipment and task history data in the production operation, but also facilitate analyzing the potential optimization nodes in the operation process and improving the overall production efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] Other features, objectives and advantages of the present invention will become more apparent from a reading of the detailed description of non-limiting embodiments made with reference to the following accompanying drawings.

[0043] Figure 1 It is a structural block diagram of the relationship between the functional modules of the present invention;

[0044] Figure 2 It is the storage process of equipment historical data of automated container terminal quay crane production operations;

[0045] Figure 3 It is the storage process of task history data of automated container terminal quay crane production operations;

[0046] Figure 4 It is the playback and GUI display process of historical data of automated container terminal quay crane production operation;

[0047] Figure 5 It is a screenshot of the query conditions of the GUI historical data playback function interface of the present invention. DETAILED DESCRIPTION

[0048] The technical solution of the present invention is specifically described below in conjunction with the drawings in the specification. The detailed features and advantages of the present invention are described in detail in the specific implementation mode. The content is sufficient to enable any technical personnel in the field to understand the technical content of the present invention and implement it accordingly. According to the description, claims and drawings disclosed in this specification, the technical personnel in the field can easily understand the relevant purposes and advantages of the present invention.

[0049] The present invention provides a method for replaying the history of production operations of automated container terminal quay cranes. The functional module for implementing the above method is mainly composed of a data source, an attribute cache, and a device. The relationship between them is as follows: Figure 1 As shown, the attribute cache is written through the data source, and the attribute cache is provided for the device to use. When designing the functional module, the device class is made independent of the data source and can take into account the drive of OPC data.

[0050] By comprehensively applying the above-mentioned automated container terminal quay crane production operation history playback method to various types of quay cranes such as single trolleys and double trolleys, the operation history monitoring of automated container terminal quay crane production is realized. The automated container terminal quay crane production operation history playback method is not only used for monitoring and playback of equipment status related information of automated container terminal quay cranes, but also for the backtracking of operation status task information and the simulation of production operation scenes.

[0051] A method for replaying the production operation history of an automated container terminal quay crane includes the following steps:

[0052] S1. The storage process of the historical data of the automated container terminal quay crane production operation is divided into a storage method for the equipment historical data and a storage method for the task historical data.

[0053] Among them, S1 includes the following specific steps:

[0054] S11. Storage process of equipment historical data of automated container terminal quay crane production operations;

[0055] Among them, S11 includes the following specific steps: Figure 2 As shown:

[0056] S111. Read the configuration file information as initialization subscription information;

[0057] Wherein, S111 includes the following specific steps:

[0058] S1111. Write the server information, subscription point information and device attribute information corresponding to the subscription point into the system configuration file in advance; in a specific embodiment, the device attribute information includes the quay crane trolley position, trolley position, lifting position, etc.

[0059] S1112. When the history playback function module starts running, it reads the server information, subscription point information, and device attribute information corresponding to the subscription point as initialization subscription information.

[0060] S112. According to the information of the configuration file in step S111, connect the device data collector. In a specific embodiment, the data collector refers to ZPMC OPC UA.

[0061] S113. Subscribe to real-time data according to the configuration file information in step S111;

[0062] S114. After the subscription is successful, the callback function is used to determine if there are updated data items. If the subscription fails, the process returns to step S113 to re-subscribe to the device real-time data.

[0063] S115. Receive real-time data and store it in a time series database. In a specific embodiment, InfluxDB is used as the storage database.

[0064] S12. The process of storing the task history data of the automated container terminal gantry crane production operation.

[0065] Among them, S12 includes the following specific steps: Figure 3 As shown:

[0066] S121. Select a type of task, and define a historical data table containing all real-time task information of this type in the database for storing task history data; in a specific embodiment, for a double-trolley shore container gantry crane equipment, there are 4 types of task data that need to be stored, such as QC Order table, QC Command table, QC Status table and QCEvent table.

[0067] S122. Write corresponding SQL statements for the creation, update, and deletion operations of data in the historical data table in step S121, and create triggers;

[0068] S123. Determine whether the currently created trigger is the trigger of the last task type. If it is not the trigger of the last task type, select a task of a type that has not created a trigger, and continue to repeat steps S121 and S122;

[0069] S124. If the trigger of the last task type, that is, the trigger of all types of tasks is created, when the real-time task information changes, the corresponding trigger is automatically activated to record the historical data of the real-time task information.

[0070] S2. The specific process of playback and GUI display of historical data of automated container terminal quay crane production operation is as follows: Figure 4 shown.

[0071] Among them, S2 includes the following specific steps:

[0072] S21. Open the GUI history playback interface and initialize the history data playback function module;

[0073] S22. Set the query condition related parameters in the opened GUI history playback interface, and confirm the history playback operation by clicking the play button;

[0074] S23. The historical data playback function module receives and updates the query condition related parameters from step S22 and starts the playback process; in a specific embodiment, a screenshot of the query condition of the GUI historical data playback function interface is as follows Figure 5 As shown, the query conditions include the historical playback start time, end time, current playback time, playback speed, the list of quay crane equipment data points used in the current screen, and the quay crane historical task database query statement.

[0075] Wherein, S23 includes the following specific steps:

[0076] S231 determines whether the current playback time history data has been played back. If the playback is complete, the process ends and proceeds to the next step;

[0077] S232. If the playback is not completed, determine whether there is any unplayed historical data cached at present. If not, read the equipment and task historical data storing the production operation; otherwise, proceed to step S234;

[0078] S233. Read the stored equipment and task history data of the automated container terminal quay crane production operation, and determine whether all historical data has been completely read. If not, return to step S232, otherwise, proceed to step S234;

[0079] S234. The GUI analyzes the historical data of the organization changes, outputs the historical data of the organization changes, and pushes it to the GUI history playback function interface for display;

[0080] S235. Calculate the next play time according to the specified rule and use it as the new current play time, and return to step S231. The specified rule is: next current play time = current play time + play frequency x play speed.

[0081] S24. The GUI history playback interface continuously refreshes the display content according to the history data pushed in step S23, starting from the set playback start time until the history data playback function module no longer pushes new history data.

[0082] Finally, it should be pointed out that although the present invention has been described with reference to the current specific embodiments, ordinary technicians in this technical field should realize that the above embodiments are only used to illustrate the present invention and are not used as a limitation of the present invention. Various equivalent changes or substitutions can be made without departing from the concept of the present invention. Therefore, as long as the changes and modifications to the above embodiments are within the essential spirit of the present invention, they will fall within the scope of the claims of the present invention.

Claims

1. A method for replaying the production operation history of an automated container terminal quay crane, characterized in that: The following steps are involved: S1. Storage process of historical data of automated container terminal quay crane production operations; S2. Playback and GUI display process of historical data of automated container terminal gantry crane production operations.

2. The method for replaying the production operation history of an automated container terminal gantry crane according to claim 1, characterized in that: The S1 comprises the following steps: S11. Storage process of equipment historical data of automated container terminal quay crane production operations; S12. The process of storing the task history data of the automated container terminal gantry crane production operation.

3. The method for replaying the production operation history of an automated container terminal gantry crane according to claim 2, characterized in that: The S11 comprises the following steps: S111. Read the configuration file information as initialization subscription information; S112. Connect the device data collector according to the information of the configuration file in step S111; S113. Subscribe to real-time data according to the configuration file information in step S111; S114. After the subscription is successful, the callback function is used to determine if there are updated data items. If the subscription fails, the process returns to step S113 to re-subscribe to the device real-time data. S115. Receive real-time data and store it in a time series database.

4. The method for replaying the production operation history of an automated container terminal gantry crane according to claim 3, characterized in that: The S111 comprises the following steps: S1111. Write the server information, subscription point information and device attribute information corresponding to the subscription point in the system configuration file in advance; S1112. When the history playback function module starts running, it reads the server information, subscription point information, and device attribute information corresponding to the subscription point as initialization subscription information.

5. The method for replaying the production operation history of an automated container terminal gantry crane according to claim 2, characterized in that: The S12 comprises the following steps: S121. Select a type of task, define a historical data table containing all such real-time task information in the database, for storing task history data; S122. Write corresponding SQL statements for the creation, update, and deletion operations of data in the historical data table in step S121, and create triggers; S123. Determine whether the currently created trigger is the trigger of the last task type. If it is not the trigger of the last task type, select a task of a type that has not created a trigger, and continue to repeat steps S121 and S122; S124. If the trigger of the last task type, that is, the trigger of all types of tasks is created, when the real-time task information changes, the corresponding trigger is automatically activated to record the historical data of the real-time task information.

6. The method for replaying the production operation history of an automated container terminal gantry crane according to claim 1, characterized in that: The S2 comprises the following steps: S21. Open the GUI history playback interface and initialize the history data playback function module; S22. Set the query condition related parameters in the opened GUI history playback interface, and confirm the history playback operation by clicking the play button; S23. The historical data playback function module receives and updates the query condition related parameters from step S22 and starts the playback process; S24. The GUI history playback interface continuously refreshes the display content according to the history data pushed in step S23, starting from the set playback start time until the history data playback function module no longer pushes new history data.

7. The method for replaying the production operation history of an automated container terminal gantry crane according to claim 6, characterized in that: The S23 comprises the following steps: S231 determines whether the current playback time history data has been played back. If playback is complete, the process ends; S232. If the playback is not completed, determine whether there is any unplayed historical data cached at present. If not, read the equipment and task historical data storing the production operation; otherwise, proceed to step S234; S233. Read the stored equipment and task history data to determine whether all history data has been completely read. If not, return to step S232. Otherwise, proceed to step S234. S234. The GUI analyzes the historical data of the organization changes, outputs the historical data of the organization changes, and pushes it to the GUI history playback function interface for display; S235. Calculate the next play time according to the specified rules, and use it as the new current play time, and return to step S231.

8. The method for replaying the production operation history of an automated container terminal gantry crane according to claim 7, characterized in that: The specified rule in S235 is: next current play time = current play time + play frequency x play speed.

9. An automated container terminal quay crane production operation history playback application, corresponding to the automated container terminal quay crane production operation history playback method, characterized in that: It is comprehensively applied to single-trolley and double-trolley quay cranes to realize historical monitoring of the production operations of automated container terminal quay cranes.

10. The automated container terminal quay crane production operation history playback application as claimed in claim 9, characterized in that: It is used for monitoring and playback of equipment status information of automated container terminal quay cranes, and is also used for backtracking of operation status task information and simulation of production operation scenarios.

Images