A method and system for tracing product quality and safety of non-marking assembly line

Abstract

The present invention discloses a method system for tracing the quality and safety of unmarked assembly line products, which respectively creates online and offline product quality parameter tables; collects control signals of various production processes of the assembly line to obtain a start trigger signal and an end trigger signal of each production process; collects quality parameters and continuous quality parameters of the production process corresponding to the product to be traced in each production process; and stores or deletes data of relevant processes in the online product quality parameter table. After completing all assembly line production processes, all data related to the product are searched in the online parameter table and stored in the offline product quality parameter table, and the relevant data in the online parameter table are deleted at the same time; all data related to the product are traced back according to key fields of the offline product quality parameter table, and the most appropriate signal is selected from each control signal in each production process of the assembly line as the start and end trigger signal of each process data collection, so that the recorded quality parameters meet the requirements of accurate quality analysis.

Description

Technical Field

[0001] The present invention relates to the technical field of assembly line data tracing, and in particular to a method and system for tracing the quality and safety of unmarked assembly line products. Background Art

[0002] The purpose of quality traceability and evaluation is to improve the quality of parts. Quality traceability is equivalent to "post-event feedback". The quality problems that occur during the use of parts can be traced back to find out the causes, avoid similar problems from happening again, and investigate the personnel who caused the quality problems. Abnormalities in the key quality points of production line parts during the processing will cause the parts to fail the inspection and eventually become scrap, causing waste. Quality evaluation is equivalent to "in-process control". During the part processing process, the key quality points are evaluated in time through control charts to avoid the occurrence of quality problems and solve quality problems from the source.

[0003] For example, in the field of automobile manufacturing, its main parts are manufactured and integrated on the production line. The quality traceability of parts in this field is mainly based on the Internet of Things technology. RFID or QR codes, digital codes, one-dimensional codes and other identifiers are installed on the parts. When they are processed on the production line, their identifiers can be recognized by sensing devices or scanning devices, so that the identifiers can be stored in the database together with the quality parameters for subsequent statistical analysis and quality traceability needs; for discrete manufacturing, especially for small batches and multiple varieties of discrete manufacturing, it is generally organized in batches as production units. Usually, each batch of products will use a batch number to identify the material and its related information, which makes it possible to distinguish materials or products with different characteristics, and to query information about the production, inventory, procurement, etc. of the batch of materials.

[0004] At present, the global manufacturing industry is developing in the direction of digitalization, networking and informatization. Therefore, the production line quality traceability system is often used to collect, manage and trace the quality data generated in the product manufacturing process. The traditional production line quality traceability system often relies on physical markers installed on parts to associate, store and manage data. However, for some special products, it is forbidden to add any physical markers, so the quality traceability system based on this method cannot be applied to such products. In addition, if QR codes, RFID and other markers are directly added to the product, the product is prone to fall off, wear and tear during processing, packaging, transportation and use, which makes it impossible to query its quality data later. In addition, for most batch products, the quality traceability of a single product can often only be reflected through the quality parameters of the batch, and the quality data cannot be accurately located. The collection of quality data on traditional production lines is often implemented using one device and one thread. There are too few collection points for continuously changing quality parameters such as torque and pressure, which cannot meet the requirements of quality analysis. Moreover, current production line data collection is generally based on the end signal of each link, but the best recording time for some quality data is usually at the rising or falling edge of a certain control signal. Simply using the link end signal to trigger the data collection event, the recorded quality parameters are difficult to meet the requirements of accurate quality analysis. Summary of the invention

[0005] The technical problem to be solved by the present invention is how to realize the quality and safety traceability of unmarked assembly line products. A method and system for tracing the quality and safety of unmarked assembly line products are proposed. The method and system are based on the operation mode of synchronizing the production rhythm of the automated assembly line, and aiming at the characteristics of the product being prohibited from spraying codes and adding other identification marks. Taking into account the quality data in non-uniform formats generated by various special machines on the production line, combined with the production line control signal, the product quality data is quickly collected, processed and stored in multiple threads, thereby realizing product quality data management and making the product and its data more accurately associated, thereby meeting the quality data query and traceability of a single product on the unmarked production line.

[0006] The present invention is achieved through the following technical solutions:

[0007] A method for tracing the quality and safety of unmarked assembly line products, comprising the following steps:

[0008] S1. Create equipment online product quality parameter table and offline product quality parameter table;

[0009] S2. Collect control signals of each production process of the assembly line, select from multiple control signals of each production process, and obtain a start trigger signal and an end trigger signal of each production process;

[0010] S3. Collect the quality parameters of each production process corresponding to the product to be traced according to the control signal of each production process. For continuous quality parameters, take the start trigger signal or end trigger signal of each production process as the collection signal to collect the continuous quality parameters of the production process corresponding to the product to be traced in each production process; and store or delete the quality parameters and continuous quality parameters of the production process corresponding to the product to be traced in the online product quality parameter table;

[0011] S4. After completing all production processes of the assembly line, search for all data related to the product to be traced in the online product quality parameter table, store the searched data in the offline product quality parameter table, and delete all data related to the product to be traced in the online product quality parameter table;

[0012] S5. Trace back all data related to the product to be traced based on the key fields of the offline product quality parameter table.

[0013] Currently, there are few existing quality traceability methods for products that are prohibited from adding markers, and the trigger point for the current production line quality and safety parameter collection events is mostly the end signal of the process. This method is suitable for the collection of static parameters such as holding time, product model, etc., but for most dynamic and continuous data, the effectiveness of the record depends to a large extent on the start and end time of signal collection. If the start signal time is too late, many valid signals will be lost, and if it is too early, more useless information will be recorded. Similarly, if the end signal time is too late, invalid data will increase, causing trouble for subsequent data processing and storage, and if it is too early, valid information will be missing. The best recording time for quality data corresponding to most dynamic continuous signals is usually at the rising edge or falling edge of a certain control signal. If the process end signal is simply used to trigger the data collection event, the recorded quality parameters are difficult to meet the requirements of accurate quality analysis. Therefore, the present invention selects the most suitable signal from the numerous underlying control signals in each production process of the assembly line as the start and end trigger signals for data collection in each link, and uses asynchronous data storage technology to process and store the product quality data of the production line. For each production process of the assembly line, the start and end signals of each process are used as data collection, storage and processing nodes. When the online signal is triggered, the relevant data is recorded in the product quality parameter table of the equipment line. For some continuously changing quality safety parameters, when the start trigger signal is triggered, the data is recorded, and when the end trigger signal is triggered, the recording is stopped, and the collected data is uniformly processed and saved in the product quality parameter table of the equipment line. When the reject signal is triggered, the relevant records in the product quality parameter table of the equipment line are deleted. When the product offline signal is triggered, the corresponding product quality information is recorded in the offline product quality parameter table, and the relevant content in the product quality parameter table of the equipment line is deleted. Taking the packaging box as the smallest tracking unit, the key information of quality traceability is added to the box through key fields, so as to realize quality data association and query.

[0014] Furthermore, the production process of the assembly line includes the product online process, processing process, quality inspection process, waste rejection process and product offline process. The specific process of storing the data of the production process of the assembly line is as follows:

[0015] In the product launch process, when the start trigger signal of the product launch is triggered, a new piece of data is added to the online product quality parameter table, which records the launch time of the product to be traced;

[0016] The product to be traced goes through a processing procedure. When the processing is completed, the end trigger signal of the processing procedure is triggered, and a new data is added to the online product quality parameter table. This data records the quality parameters of the processing procedure.

[0017] The products to be traced go through the quality inspection process, which records the serial numbers of unqualified products in the quality inspection process and stores the quality parameters and serial numbers corresponding to the unqualified products in the online product quality data table; unqualified products enter the rejection process, and qualified products enter the product lower limit process;

[0018] Unqualified products in the quality inspection process go through the rejection process. When the rejection is completed, all data related to the unqualified products in the online product quality parameter table are deleted;

[0019] When a qualified product goes through the product offline process and the end trigger signal of the offline process is triggered, all data related to the qualified product is searched in the online product quality parameter table and stored in the offline product quality parameter table in a certain format. At the same time, all data related to the qualified product in the online product quality parameter table is deleted.

[0020] Furthermore, the present application selects the most appropriate signal from among the numerous underlying control signals of the production process as the trigger signal for starting and ending data collection in each link. The process for determining the collection signal of each production process is as follows:

[0021] The process start signal, process end signal, process action start signal, process action end signal, and valid data cutoff time signal of each production process are collected. The start trigger signal is selected between the process start signal and the process action start signal, and the end trigger signal is selected between the valid data cutoff time signal and the process end signal. Among them, the process start signal and the process end signal can be selected from the standard end signal, standard start signal, standard action signal, cylinder extension signal, or lever arm lifting signal given by the assembly line system.

[0022] Furthermore, the signals between the process start signal and the process action start signal are sorted in time sequence, and the signal corresponding to the median when sorted in time sequence is selected as the start trigger signal; the signals between the valid data cutoff time signal and the process end signal are sorted in time sequence, and the signal corresponding to the median when sorted in time sequence is selected as the end trigger signal.

[0023] Furthermore, since the existing production line quality and safety data collection usually relies on third-party collection software, its minimum collection unit is generally the device. One collection cycle needs to obtain all the data of the device, which not only contains a large amount of invalid data, occupies processing resources, but also increases the collection cycle. For some data with high real-time requirements, it often cannot collect valid data. Therefore, this solution uses multi-threaded data collection technology and takes data blocks as the minimum collection unit. When collecting various signals and quality parameters of each production process on the assembly line, the collection program uses the controller data block as the minimum collection unit, and one data block corresponds to one collection thread. In the thread pool, multiple threads are responsible for data collection and processing of multiple data blocks.

[0024] Furthermore, for each production process, in addition to continuous quality parameters, the content that needs to be collected also includes: collecting the start signal and end signal of the product online process, collecting product-related quality parameters and the end signal of the processing process in the processing process, collecting product-related quality parameters, the end signal of the quality inspection process and the serial number of unqualified products in the quality inspection process, and collecting the end signal of the scrap rejection process in the scrap rejection process and the end signal of the product offline process.

[0025] Furthermore, in S5, the key fields include the group number and the timestamp. The group number is used to record the position of the product to be traced in all products in this batch, and the timestamp is used to mark the exact offline time of the product to be traced. When the product is packed after completing the production process of the assembly line, the timestamp range and the group number range are marked on the product box. If there is a subsequent quality traceability requirement, the relevant product can be traced back based on the timestamp and group number.

[0026] In addition, the present invention provides a non-marking assembly line quality safety data tracing system, including a database, a signal selection module, a data acquisition module, a data storage module and a data tracing module, wherein:

[0027] The database is used to create two data tables: an online product quality parameter table and an offline product quality parameter table;

[0028] The signal selection module is used to collect the control signals of each production process of the assembly line, and select from multiple control signals of each production process to obtain the start trigger signal and end trigger signal of each production process;

[0029] The data acquisition module collects the quality parameters of each production process corresponding to the product to be traced according to the control signal of each production process, taking the controller data block as the minimum acquisition unit. For continuous quality parameters, the start trigger signal or end trigger signal of each production process is used as the acquisition signal to collect the continuous quality parameters of the production process corresponding to the product to be traced in each production process;

[0030] The data storage module is used to store or delete the online product quality parameter table and the offline product quality parameter table according to the collected quality parameters and continuous quality parameters of the corresponding production process;

[0031] The data traceability module is used to search for all data related to the product to be traced based on key fields in the offline product quality parameter table.

[0032] Furthermore, the control signals collected by the signal selection module include: process start signal, process end signal, process action start signal, process action end signal, and valid data cutoff time signal. The start trigger signal is selected between the process start signal and the process action start signal, and the end trigger signal is selected between the valid data cutoff time signal and the process end signal. Among them, the process start signal and the process end signal can be selected from the standard end signal, standard start signal, standard action signal, cylinder extension and retraction signal, or arm lifting signal given by the assembly line system.

[0033] Furthermore, the signal selection module sorts the signals between the process start signal and the process action start signal in time sequence, and selects the signal corresponding to the median when sorted in time sequence as the start trigger signal; sorts the signals between the valid data cutoff time signal and the process end signal in time sequence, and selects the signal corresponding to the median when sorted in time sequence as the end trigger signal.

[0034] Compared with the prior art, the present invention has the following advantages and beneficial effects:

[0035] 1. The present invention discloses a method and system for tracing product quality and safety of a non-marking assembly line. The method utilizes mature multi-threaded data acquisition technology to realize rapid data acquisition in units of data blocks, thereby shortening the acquisition cycle, acquiring as many continuous signals as possible between the start and end trigger signals, selecting appropriate underlying control signals as data recording trigger signals, and using asynchronous storage technology to complete data recording, thereby realizing a method for collecting, processing and storing product safety and quality data of an assembly line without markers, and solving the problems that product markers of existing production lines are easy to fall off and damaged, and that some production lines are prohibited from adding markers;

[0036] 2. The present invention provides a method and system for tracing the quality and safety of unmarked assembly line products. For the five main links of the assembly line, namely, feeding, processing, quality inspection, rejecting, and offline, the start and completion signals of each process are used as data collection, storage, and processing nodes. When the online signal is triggered, the relevant data is recorded in the online data table. For certain continuously changing quality and safety parameters, when the start trigger signal is triggered, the data is recorded. When the end trigger signal is triggered, the recording is stopped, and the collected data is uniformly processed and saved in the online data table. When the reject signal is triggered, the relevant records in the online product quality information table are deleted. When the product offline signal is triggered, the corresponding product quality information is recorded in the offline quality information table, and the relevant content in the online data table is deleted at the same time.

[0037] 3. The present invention provides a method and system for tracing the quality and safety of unmarked assembly line products. For continuous signal acquisition, its start trigger signal should select a control signal between the process start signal and the action start signal, and its end trigger signal should select a signal point between the effective data cutoff time and the process end signal. When determining the control signal and the signal point, the signal corresponding to the median is selected as the start trigger signal or the end trigger signal according to the time sequence sorting. When selecting the start and end signals, it is not limited to the standard end, start, action and other signals given by the assembly line system. Some signals such as cylinder extension and retraction, arm lifting and other signals are also suitable as target signals. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] In order to more clearly illustrate the technical solutions of the exemplary embodiments of the present invention, the following briefly introduces the drawings required for use in the embodiments. It should be understood that the following drawings only illustrate certain embodiments of the present invention and should not be regarded as limiting the scope. For those of ordinary skill in the art, other relevant drawings can be obtained based on these drawings without creative work. In the drawings:

[0039] Figure 1 The present invention is a flowchart of a method for tracing product quality and safety data of a non-marking assembly line in an embodiment of the present invention;

[0040] Figure 2 A flowchart of data storage of production process of an assembly line in one embodiment of the present invention;

[0041] Figure 3 The figure is a schematic diagram of signal selection in an embodiment of the present invention. DETAILED DESCRIPTION

[0042] In order to make the objectives, technical solutions and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with embodiments and drawings. The exemplary embodiments of the present invention and their description are only used to explain the present invention and are not intended to limit the present invention.

[0043] Example

[0044] like Figure 1 As shown, this embodiment provides a method for tracing the quality and safety of unmarked assembly line products, comprising the following steps:

[0045] S1. Create equipment online product quality parameter table and offline product quality parameter table;

[0046] S2. Collect control signals of each production process of the assembly line, select from multiple control signals of each production process, and obtain a start trigger signal and an end trigger signal of each production process;

[0047] S3. Collect the quality parameters of each production process corresponding to the product to be traced according to the control signal of each production process. For continuous quality parameters, take the start trigger signal or end trigger signal of each production process as the collection signal to collect the continuous quality parameters of the production process corresponding to the product to be traced in each production process; and store or delete the quality parameters and continuous quality parameters of the production process corresponding to the product to be traced in the online product quality parameter table;

[0048] Each process of a conventional assembly line basically has control signals such as start and end signals, but they are often not suitable as trigger signals for data collection of certain continuous quality parameters. Taking torque parameter collection as an example, using the start and end signals of conventional processes as collection trigger events will record a lot of invalid data, which will bring great storage pressure to the data. However, using the torque action signal as the trigger point for collection, considering the data collection delay and the slow change of the signal after the action ends, it will make it impossible to record the data during the start and end period. For some products, the parameters at the start and end of the action are very important. Therefore, the trigger signal should select the signal before the action signal starts and after the action signal ends. Therefore, according to the control signal of each production process collected, it is drawn as follows Figure 3 As shown in the continuous signal change curve diagram, the control signal includes a process start signal, a process end signal, a process action start signal, a process action end signal, and a valid data cut-off time signal. The start trigger signal is selected between the process start signal and the process action start signal, and the end trigger signal is selected between the valid data cut-off time signal and the process end signal. Among them, the process start signal, the process end signal, the process action start signal, the process action end signal, and the valid data cut-off time signal can all be selected from the standard end signal, standard start signal, standard action signal, cylinder extension signal or arm lifting signal given by the assembly line system.

[0049] In detail, the signals between the process start signal and the process action start signal are sorted in time sequence, and the signal corresponding to the median when sorted in time sequence is selected as the start trigger signal; the signals between the valid data cutoff time signal and the process end signal are sorted in time sequence, and the signal corresponding to the median when sorted in time sequence is selected as the end trigger signal.

[0050] S4. After completing all production processes of the assembly line, search for all data related to the product to be traced in the online product quality parameter table, store the searched data in the offline product quality parameter table, and delete all data related to the product to be traced in the online product quality parameter table;

[0051] S5. Trace back all data related to the product to be traced based on the key fields of the offline product quality parameter table. The key fields include group number and timestamp. The group number is used to record the position of the product to be traced in all products in this batch, and the timestamp is used to mark the exact offline time of the product to be traced. After completing the production process of the assembly line, the product is packed in the box. The timestamp range and group number range are marked on the product box. If there is a need for quality traceability later, the relevant products can be traced based on the timestamp and group number.

[0052] Specifically, the production process of the assembly line includes the product online process, processing process, quality inspection process, waste rejection process and product offline process, such as Figure 2 As shown in the figure, the specific process of data storage of assembly line production process is as follows:

[0053] In the product launch process, when the start trigger signal of the product launch is triggered, a new piece of data is added to the online product quality parameter table, which records the launch time of the product to be traced;

[0054] The product to be traced goes through a processing procedure. When the processing is completed, the end trigger signal of the processing procedure is triggered, and a new data is added to the online product quality parameter table. This data records the quality parameters of the processing procedure.

[0055] The products to be traced go through the quality inspection process, which records the serial numbers of unqualified products in the quality inspection process and stores the quality parameters and serial numbers corresponding to the unqualified products in the online product quality data table; unqualified products enter the rejection process, and qualified products enter the product lower limit process;

[0056] Unqualified products in the quality inspection process go through the rejection process. When the rejection is completed, all data related to the unqualified products in the online product quality parameter table are deleted;

[0057] When a qualified product goes through the product offline process and the end trigger signal of the offline process is triggered, all data related to the qualified product is searched in the online product quality parameter table and stored in the offline product quality parameter table in a certain format. At the same time, all data related to the qualified product in the online product quality parameter table is deleted.

[0058] During data collection, according to the start trigger signal and end trigger signal of each process on the selected assembly line and the quality parameters, conventional collection generally uses the device as the collection unit to acquire data. This is simple to implement, and all data will be collected in each collection cycle, including a lot of invalid data, which is time-consuming to read. The collection program optimizes the S7 data collection protocol, and only collects the data area where the required data is located at one time. The controller data block is the smallest collection unit, and one data block corresponds to one collection thread. Taking Siemens PLC as an example, if the valid data is only in the DB3 and DB55 data blocks, the data collection program with the data block as the smallest unit has two threads in the thread pool that are responsible for data collection and processing of the two data blocks respectively, which can realize rapid data acquisition, thereby shortening the collection cycle, and collecting as many continuous signals as possible between the start trigger signal and the end trigger signal. In addition to continuous quality parameters, it is also necessary to collect the start signal and end signal of the product on-line process, collect product-related quality parameters and the end signal of the processing process, collect product-related quality parameters, the end signal of the quality inspection process and the serial number of unqualified products in the quality inspection process, collect the end signal of the scrap rejection process in the scrap rejection process and then the end signal of the product off-line process. Whether the data needs to be stored depends on the rising edge trigger of the end signal of each process, that is, when the status of the previous collection process is incomplete and the status of the current collection process is completed, the storage strategy is triggered to perform operations such as adding data and deleting data.

[0059] In the specific implementation process, the data table structure of the above-mentioned equipment online product quality parameter table and offline product quality parameter table can be designed according to the format of Table 1 and Table 2:

[0060] Table 1 Equipment online product quality parameters

[0061] Field Name Data Types describe Remark GroupNumber Int Product Group No. Beat number Number Int Product group serial number The sequence number in this beat Name Varchar Parameter name Value Varchar Parameter Value

[0062] Table 1 records the quality data of the products being processed on the production line. When the process is completed, a new entry is added to the table to record the quality parameters of the products in the process. When the product is offline, the quality data of the qualified product is stored in the offline product quality parameter table, and the relevant records of the product in Table 1 are deleted. The beat in the remarks is the corresponding production process.

[0063] Table 2 Offline product quality parameters

[0064] Field Name Data Types describe Remark Ti Time Product offline time GroupNumber Int Product Group No. Beat number Number Int Product group serial number The sequence number in this beat Para1 Varchar Parameter 1 Quality data The field name can be named according to the actual field Para2 Varchar Parameter 2 Quality data The field name can be named according to the actual field …… …… …… …… Paran Varchar Parameter n Quality data The field name can be named according to the actual field

[0065] When the product on the assembly line is off the line, the relevant quality data of the product is queried from the product quality data table of the equipment line and stored in Table 2. The parameter fields in Table 2 can be adjusted according to the actual production line. That is, if there are several quality parameters on the production line, there will be corresponding fields in the table.

[0066] The data storage process of the five production processes of the assembly line:

[0067] Product launch process: When the product is put into processing and the launch signal is triggered, a new record is added to the product quality parameter table of the equipment line. The value of the field "GroupNumber" is the maximum value of the field in the current table plus 1. The same amount of data is added to the table as the number of products in this cycle.

[0068] Processing procedure: Similar to the product launch procedure, when each processing procedure is completed, the relevant quality parameters of the procedure are temporarily recorded in the product quality parameter table on the equipment line. For continuous safety quality parameters containing multiple data, each data is separated by a semicolon and stored in a field in the form of a string to facilitate later traceability.

[0069] Quality inspection process: Products will go through several quality inspection processes during the processing. After each quality inspection is completed, in addition to recording the relevant quality parameters in the online quality parameter table, the serial numbers of unqualified products in the process must also be recorded.

[0070] Scrap rejection process: There is usually a scrap rejection process after the quality inspection process. The scrap rejection process performs scrap rejection operations according to the scrap rejection sequence number generated by the quality inspection process. The scrap rejection operation is completed in two steps. The current scrap rejection process deletes the beats that are all scraps in the quality parameter table of the equipment line. When the product is offline, the scrap contained in other scrap rejection sequences will be deleted.

[0071] Product offline process: When the product is offline and the offline completion signal is triggered, the quality data related to the offline beat is stored in the offline quality parameter table, and the timestamp is recorded in Table 2. At the same time, the relevant data in the equipment online quality parameter table is deleted. Five main links follow the beat speed and are based on the product sequence production characteristics to complete the unmarked quality data traceability.

[0072] Example 2

[0073] This embodiment provides a non-marking assembly line quality safety data tracing system, including a database, a signal selection module, a data acquisition module, a data storage module and a data tracing module, wherein:

[0074] The database is used to create two data tables: an online product quality parameter table and an offline product quality parameter table;

[0075] The signal selection module is used to collect the control signals of each production process of the assembly line, and select from multiple control signals of each production process to obtain the start trigger signal and end trigger signal of each production process;

[0076] The control signals include: process start signal, process end signal, process action start signal, process action end signal, and effective data cutoff time signal. Figure 3 The continuous signal change curve shown in the figure selects the start trigger signal between the process start signal and the process action start signal, and selects the end trigger signal between the valid data cutoff time signal and the process end signal, wherein the process start signal, process end signal, process action start signal, process action end signal, and valid data cutoff time signal can all be selected from the standard end signal, standard start signal, standard action signal, cylinder extension signal, or lever arm lifting signal given by the assembly line system.

[0077] The signal selection module sorts the signals between the process start signal and the process action start signal in time sequence, and selects the signal corresponding to the median when sorted in time sequence as the start trigger signal; sorts the signals between the valid data cutoff time signal and the process end signal in time sequence, and selects the signal corresponding to the median when sorted in time sequence as the end trigger signal.

[0078] The data acquisition module collects the quality parameters of each production process corresponding to the product to be traced according to the control signal of each production process, taking the controller data block as the minimum acquisition unit. For continuous quality parameters, the start trigger signal or end trigger signal of each production process is used as the acquisition signal to collect the continuous quality parameters of the production process corresponding to the product to be traced in each production process;

[0079] The data storage module is used to store or delete the online product quality parameter table and the offline product quality parameter table according to the collected quality parameters and continuous quality parameters of the corresponding production process;

[0080] The data traceability module is used to search for all data related to the product to be traced based on key fields in the offline product quality parameter table.

[0081] It can be understood that the present invention designs two data tables, one offline and one online, based on the characteristics of sequential production and stable beat of assembly line products. Based on the completion signals of each link, the online quality parameters are temporarily stored. When the offline process is completed, all quality parameters are stored in the offline quality parameter table, so that the product quality can be traced without adding physical identifiers to the product. In the selection of the trigger signal for continuous quality parameter acquisition, the appropriate signal acquisition trigger point is selected based on the signal change curve, so as to collect as much valid data as possible and reduce the number of collection points for invalid data.

[0082] When designing the acquisition program, the controller data block is used as the minimum acquisition unit, thereby increasing the frequency of data acquisition and collecting more valid data points. The present invention takes into account the rejection process in the assembly line, and each rejection process generates a rejection sequence number. When the current rejection process is completed, the sequence number of all waste products completes the data rejection operation, and other types of rejection sequence numbers complete the rejection operation before the product goes offline, thereby achieving accurate and efficient storage of quality data.

[0083] The present invention solves the problem that batch-type product quality parameters cannot be accurately found and located, so that each product in each batch of products has quality data corresponding to it, and all products can be checked and traced. In addition, by selecting the trigger acquisition signal, the effective data collection range is more accurately controlled, the start and end time period signals are effectively collected, and a certain amount of invalid data is reduced, thereby improving the collection efficiency of continuous quality data, shortening its collection cycle as much as possible, and obtaining more data points.

[0084] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

[0085] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0086] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0087] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0088] A person of ordinary skill in the art can understand that all or part of the steps in realizing the above-mentioned facts and methods can be completed by instructing the relevant hardware through a program, and the program involved or the program described can be stored in a computer-readable storage medium. When the program is executed, it includes the following steps: At this time, the corresponding method steps are derived, and the storage medium can be ROM / RAM, a disk, an optical disk, etc.

[0089] The specific implementation methods described above further illustrate the objectives, technical solutions and beneficial effects of the present invention in detail. It should be understood that the above description is only a specific implementation method of the present invention and is not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A method for tracing the quality and safety of unmarked assembly line products, characterized in that: The following steps are involved: S1. Create equipment online product quality parameter table and offline product quality parameter table; S2. Collect control signals of each production process of the assembly line, select from multiple control signals of each production process, and obtain a start trigger signal and an end trigger signal of each production process; S3. Collect the quality parameters of each production process corresponding to the product to be traced according to the control signal of each production process. For continuous quality parameters, take the start trigger signal or end trigger signal of each production process as the collection signal to collect the continuous quality parameters of the production process corresponding to the product to be traced in each production process; and store or delete the quality parameters and continuous quality parameters of the production process corresponding to the product to be traced in the online product quality parameter table; S4. After completing all production processes of the assembly line, search for all data related to the product to be traced in the online product quality parameter table, store the searched data in the offline product quality parameter table, and delete all data related to the product to be traced in the online product quality parameter table; S5. Trace back all data related to the product to be traced based on the key fields of the offline product quality parameter table.

2. A method for tracing product quality and safety of a non-marking assembly line according to claim 1, characterized in that: The production process of the assembly line includes the product online process, processing process, quality inspection process, waste rejection process and product offline process. The specific process of data storage in the production process of the assembly line is as follows: In the product launch process, when the start trigger signal of the product launch is triggered, a new piece of data is added to the online product quality parameter table, which records the launch time of the product to be traced; The product to be traced goes through a processing procedure. When the processing is completed, the end trigger signal of the processing procedure is triggered, and a new data is added to the online product quality parameter table. This data records the quality parameters of the processing procedure. The product to be traced goes through the quality inspection process, which records the serial number of the unqualified product in the quality inspection process and stores the quality parameters and serial number corresponding to the unqualified product in the online product quality data table; Unqualified products enter the rejection process, and qualified products enter the product lower limit process; Unqualified products in the quality inspection process go through the rejection process. When the rejection is completed, all data related to the unqualified products in the online product quality parameter table are deleted; When a qualified product goes through the product offline process and the end trigger signal of the offline process is triggered, all data related to the qualified product is searched in the online product quality parameter table and stored in the offline product quality parameter table in a certain format. At the same time, all data related to the qualified product in the online product quality parameter table is deleted.

3. A method for tracing product quality and safety of a non-marking assembly line according to claim 1, characterized in that: The process of determining the collected signal for each production process is as follows: The control signals of each production process are collected. The control signals include process start signal, process end signal, process action start signal, process action end signal, and valid data cutoff time signal. The start trigger signal is selected between the process start signal and the process action start signal, and the end trigger signal is selected between the valid data cutoff time signal and the process end signal. Among them, the process start signal and the process end signal can be selected from the standard end signal, standard start signal, standard action signal, cylinder extension signal or lever arm lifting signal given by the assembly line system.

4. A method for tracing product quality and safety of a non-marking assembly line according to claim 3, characterized in that: Sort the signals between the process start signal and the process action start signal in time sequence, and select the signal corresponding to the median when sorted in time sequence as the start trigger signal; sort the signals between the valid data cutoff time signal and the process end signal in time sequence, and select the signal corresponding to the median when sorted in time sequence as the end trigger signal.

5. The method for tracing product quality and safety of a non-marking assembly line according to claim 1 is characterized in that: When collecting control signals and quality parameters of each production process on the assembly line, the collection program uses the controller data block as the smallest collection unit, and one data block corresponds to one collection thread. In the thread pool, multiple threads are responsible for data collection and processing of multiple data blocks.

6. A method for tracing product quality and safety of a non-marking assembly line according to claim 5, characterized in that: For each production process, the content that needs to be collected also includes: collecting the start signal and end signal of the product online process, collecting the product-related quality parameters and the end signal of the processing process in the processing process, collecting the product-related quality parameters, the end signal of the quality inspection process and the serial number of unqualified products in the quality inspection process, collecting the end signal of the waste rejection process in the waste rejection process and the end signal of the product offline process.

7. The method for tracing product quality and safety of a non-marking assembly line according to claim 1 is characterized in that: In S5, the key fields include a group number and a timestamp. The group number is used to record the position of the product to be traced among all products in this batch, and the timestamp is used to mark the offline time of the product to be traced.

8. A non-marking assembly line product quality and safety traceability system, characterized in that: It includes database, signal selection module, data acquisition module, data storage module and data tracing module, among which: The database is used to create two data tables: an online product quality parameter table and an offline product quality parameter table; The signal selection module is used to collect the control signals of each production process of the assembly line, and select from multiple control signals of each production process to obtain the start trigger signal and end trigger signal of each production process; The data acquisition module collects the quality parameters of each production process corresponding to the product to be traced according to the control signal of each production process, taking the controller data block as the minimum acquisition unit. For continuous quality parameters, the start trigger signal or end trigger signal of each production process is used as the acquisition signal to collect the continuous quality parameters of the production process corresponding to the product to be traced in each production process; The data storage module is used to store or delete the online product quality parameter table and the offline product quality parameter table according to the collected quality parameters and continuous quality parameters of the corresponding production process; The data traceability module is used to search for all data related to the product to be traced based on key fields in the offline product quality parameter table.

9. The label-free assembly line product quality and safety tracing system according to claim 8 is characterized in that: The control signals collected by the signal selection module include: process start signal, process end signal, process action start signal, process action end signal, and valid data cutoff time signal. The start trigger signal is selected between the process start signal and the process action start signal, and the end trigger signal is selected between the valid data cutoff time signal and the process end signal. Among them, the process start signal and the process end signal can be selected from the standard end signal, standard start signal, standard action signal, cylinder extension signal or lever arm lifting signal given by the assembly line system.

10. The label-free assembly line product quality and safety tracing system according to claim 9, characterized in that: The signal selection module sorts the signals between the process start signal and the process action start signal in time sequence, and selects the signal corresponding to the median when sorted in time sequence as the start trigger signal; sorts the signals between the valid data cutoff time signal and the process end signal in time sequence, and selects the signal corresponding to the median when sorted in time sequence as the end trigger signal.

Images