Workpiece tracing method and system based on identification code

Abstract

The invention generally relates to the technical field of identification codes. More specifically, the invention relates to a workpiece traceability method and system based on an identification code, and the method comprises the steps: constructing a workpiece ID of a workpiece and a record file mapped with the workpiece ID; generating an identification code on the workpiece according to the workpiece ID; obtaining a first data set and a second array, and configuring a current timestamp for the second data set; recording a second data set corresponding to a timestamp adjacent to the current timestamp in the record file as a standard data set; a record file is obtained through retrieval of the identification code, and a second data set corresponding to the current timestamp and a first data set corresponding to the processing equipment corresponding to the second data set are written into the record file; and in response to the manual judgment that the workpiece is unqualified, obtaining the traceability of the processing process of the workpiece by the record file corresponding to the workpiece through the identification code on the workpiece. According to the invention, the problem of wrong position of the traceability information written file caused by wrong scanning of the identification code is avoided.

Description

Technical Field

[0001] The present invention generally relates to the field of identification code technology, and more specifically, to an identification code-based workpiece traceability method and system. Background Art

[0002] Nowadays, when producing panel furniture, it is usually necessary to cut, edge-band, drill and other processes on the workpiece (board). At the same time, in order to improve product quality and strengthen management, the workpiece is usually traced through an identification code (usually a QR code). The prior art assigns a unique identification code to each product, associates the key elements and operation information in the production process with the QR code, and scans the QR code to view the production process of the raw materials, so as to grasp the production status and data operation of each process. The Chinese patent application document with publication number CN105894309A discloses a furniture product traceability method based on a QR code. The patent application document provides a furniture product traceability method based on a QR code. The patent application document assigns a QR code to each furniture product, and the manufacturer and seller can redefine the QR code to embed the traceability information of each link. Consumers can view all the information of the product by scanning the QR code, which improves consumer protection, protects consumer rights and interests, and helps consumers choose suitable products.

[0003] However, for workpieces that need to be customized for panel furniture, a separate processing flow is usually required. At this time, the equipment that processes two adjacent workpieces on the production line may also be different. The identification codes of the two workpieces are too close to each other. When scanning the QR code, the ID of another workpiece other than the expected workpiece is identified, resulting in an error in writing the traceability information corresponding to the workpiece (the traceability information of one workpiece is written into the file corresponding to another workpiece for storing traceability information), making the traceability information of the workpiece incorrect. Summary of the invention

[0004] In order to solve the technical problem that the identification codes of the two workpieces are too close to each other, which may cause the traceability information corresponding to the workpieces to be written incorrectly, the present invention provides solutions in the following aspects.

[0005] In a first aspect, the present invention provides a workpiece traceability method based on identification codes, the method comprising: constructing a workpiece ID of the workpiece and a record file mapped to the workpiece ID; generating an identification code on the workpiece according to the workpiece ID; for any processing equipment for processing the workpiece: in response to the workpiece starting to be processed in the processing equipment, recording the identity tag of the processing equipment, the working gear, and whether there is a fault prompt of the processing equipment as a first data group; in response to the workpiece completing processing in the processing equipment, recording the size of the workpiece and the center of gravity coordinates of each drilled hole in the workpiece as a second data group, and configuring the second data group with a current timestamp; wherein each processing equipment corresponds to a first data group and a second data group; recording the data corresponding to the current time in the record file A second data group corresponding to a timestamp adjacent to a previous timestamp is recorded as a standard data group, wherein the standard data group includes a standard size and a predetermined number of standard center-of-gravity coordinates; in response to the workpiece size in the second data group corresponding to the current timestamp being less than or equal to the standard size and the drilling center-of-gravity coordinates in the second data group covering the standard center-of-gravity coordinates, a record file is retrieved through the identification code, and the second data group corresponding to the current timestamp and the first data group corresponding to the processing equipment corresponding to the second data group are written into the record file; a result of manual judgment on whether the workpiece is qualified is obtained, and in response to manual judgment that the workpiece is unqualified, a record file corresponding to the workpiece is obtained through the identification code on the workpiece to trace the processing process of the workpiece.

[0006] The beneficial effects of the present invention are: The present invention compares the standard data for describing the workpiece features (the size of the workpiece and the position of the holes drilled on the workpiece) stored in the record file with the second data group for describing the workpiece features at the current moment (current timestamp). If the workpiece corresponding to the second data group is compared with the workpiece corresponding to the standard data, the size is unchanged or smaller, the number of holes drilled is unchanged or more, and the holes corresponding to the standard data can find holes at the same position in the holes corresponding to the second data group, then it is determined that the workpiece corresponding to the second data group for describing the workpiece features at the current moment and the workpiece corresponding to the standard data in the record file are one workpiece, and the second data group is written into the record file. Based on this, the present invention avoids the situation where the identification codes of the two workpieces are too close to each other, and the ID of another workpiece other than the expected workpiece is identified when scanning the QR code, resulting in the error of writing the traceability information corresponding to the workpiece.

[0007] Preferably, the workpiece traceability method based on identification codes further includes: issuing an alarm in response to the workpiece size in the second data group corresponding to the current timestamp being larger than the standard size and the drilling center of gravity coordinates in the second data group not covering the standard center of gravity coordinates.

[0008] Preferably, generating an identification code on a workpiece according to the workpiece ID includes: obtaining a text of the workpiece ID; converting the text into coded data; generating a two-dimensional code according to the coded data, and using the two-dimensional code as the identification code.

[0009] The present invention uses a two-dimensional code as an identification code. Since the data encoded in the two-dimensional code has a certain complexity, the identification code is more difficult to be forged or tampered with, thereby improving the security and reliability of the information.

[0010] Preferably, tracing the processing of the workpiece by obtaining a record file corresponding to the workpiece through an identification code on the workpiece includes: obtaining a first data group corresponding to each processing device in the record file; and performing visualization processing based on the first data group corresponding to each processing device.

[0011] Preferably, retrieving the record file through the identification code includes: obtaining the corresponding workpiece ID through the identification code; and obtaining the address of the record file according to the workpiece ID.

[0012] Preferably, judging whether the borehole center-of-gravity coordinates in the second data group corresponding to the current timestamp cover the standard center-of-gravity coordinates includes: taking the borehole center-of-gravity coordinates in the second data group corresponding to the current timestamp as the coordinates to be detected; for any standard center-of-gravity coordinate, obtaining the distance between the standard center-of-gravity coordinate and the nearest coordinate to be detected, and recording the distance as the target distance of the standard center-of-gravity coordinate; in response to the target distance corresponding to any standard center-of-gravity coordinate being greater than a preset distance threshold, determining that the borehole center-of-gravity coordinates in the second data group corresponding to the current timestamp do not cover the standard center-of-gravity coordinates; in response to the target distance corresponding to any standard center-of-gravity coordinate being less than or equal to the distance threshold, determining that the borehole center-of-gravity coordinates in the second data group corresponding to the current timestamp cover the standard center-of-gravity coordinates.

[0013] The present invention takes into account that when obtaining the data of the borehole center of gravity coordinates twice, the data may be noisy, that is, the coordinates of the same borehole center of gravity obtained twice may be slightly different. Therefore, in this embodiment, it is determined whether the distance between the coordinates is greater than the distance threshold, and then it is determined whether the two coordinates belong to the same hole position. Based on this, the accuracy of determining whether the borehole center of gravity coordinates in the second data group corresponding to the current timestamp cover the standard center of gravity coordinates is improved.

[0014] Preferably, for a standard center of gravity coordinate, the coordinate to be detected that is closest to it is selected and marked as the selected coordinate; in response to another standard center of gravity coordinate, the coordinate to be detected other than the selected coordinate in the coordinates to be detected is selected, and it is iterated to obtain the coordinate to be detected that is closest to each standard center of gravity coordinate.

[0015] The present invention iteratively selects the nearest coordinates to be detected, marks the selected coordinates and excludes the already matched points, thereby effectively avoiding the situation of repeated matching in the pairing process.

[0016] In a second aspect, the present invention provides an artifact traceability system based on identification codes, comprising a processor and a memory, wherein the memory stores a computer program, and the processor executes the computer program to implement the artifact traceability method based on identification codes described in any one of the above invention contents.

[0017] The beneficial effects of the present invention are: The present invention ensures the consistency of the workpiece size and drilling characteristics by comparing the standard data with the data collected at the current moment, thereby avoiding the problem that the file location of the traceability information is written incorrectly due to an error in scanning the identification code. The present invention effectively prevents confusion in workpiece identification caused by an error in QR code recognition and ensures the accuracy of the information in the recorded file. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] By reading the following detailed description with reference to the accompanying drawings, the above and other objects, features and advantages of the exemplary embodiments of the present invention will become readily understood. In the accompanying drawings, several embodiments of the present invention are shown in an exemplary and non-limiting manner, and the same or corresponding reference numerals represent the same or corresponding parts, wherein: Figure 1 is a flowchart schematically illustrating the steps of an artifact traceability method based on an identification code according to an embodiment of the present invention; Figure 2 It is a block diagram schematically showing the structure of the workpiece traceability system based on identification code according to this embodiment. DETAILED DESCRIPTION

[0019] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative work are within the scope of protection of the present invention.

[0020] The specific embodiments of the present invention are described in detail below with reference to the accompanying drawings.

[0021] Figure 1 It is a flowchart schematically showing the steps of an artifact traceability method based on an identification code according to an embodiment of the present invention.

[0022] like Figure 1 As shown, the workpiece traceability method based on identification code includes steps S1 to S7.

[0023] Step S1: construct an artifact ID of an artifact and a record file mapped to the artifact ID.

[0024] There is a mapping relationship between the record file and the workpiece ID. The address of the record file can be obtained through the workpiece ID to implement indexing of the record file. Furthermore, data can be read or written in the record file corresponding to the workpiece through the workpiece ID.

[0025] It should be noted that one artifact corresponds to one artifact ID, and one artifact ID corresponds to one record file.

[0026] Step S2: Generate an identification code on the workpiece according to the workpiece ID.

[0027] In one embodiment, obtaining an identification code on a workpiece according to the workpiece ID includes: obtaining a text of the workpiece ID; converting the text into coded data; generating a two-dimensional code according to the coded data, and using the two-dimensional code as the identification code.

[0028] Step S3: In response to the workpiece starting to be processed in the processing equipment, the identity tag of the processing equipment, the working gear position, and whether there is a fault prompt of the processing equipment are recorded as the first data group.

[0029] The processing equipment is used to process the workpiece. For example, one processing equipment trims the workpiece to adjust the size and shape of the workpiece; another processing equipment punches holes in the workpiece so that the workpiece is provided with holes.

[0030] Furthermore, for a plurality of processing devices used to process the same workpiece, each processing device corresponds to a second data set.

[0031] Step S4: In response to the workpiece being processed in the processing equipment, the size of the workpiece and the coordinates of the center of gravity of each drilled hole in the workpiece are marked as a second data group, and the second data group is configured with a current timestamp.

[0032] Among them, for a plurality of processing devices used for processing a same workpiece, each processing device corresponds to a second data set.

[0033] Step S5: Record a second data group corresponding to a timestamp adjacent to the current timestamp in the record file as a standard data group.

[0034] The standard data group includes a standard size and a predetermined number of standard center of gravity coordinates. One or more second data groups are included in a record file corresponding to a workpiece. Each data group corresponds to the size of the workpiece after a processing device processes the workpiece and the coordinates of the center of gravity of all drill holes. A second data group corresponding to a timestamp adjacent to the current timestamp in the record file is recorded as a standard data group. Based on this, after the previous processing device of the processing device that completes the processing of the workpiece at the current moment processes the workpiece, the size of the workpiece is the standard size, and the coordinates of the center of gravity of all drill holes in the workpiece are the standard coordinates.

[0035] Step S6: in response to the fact that the workpiece size in the second data group corresponding to the current timestamp is less than or equal to the standard size and the drilling center of gravity coordinates in the second data group cover the standard center of gravity coordinates, a record file is retrieved through the identification code; the second data group corresponding to the current timestamp and the first data group corresponding to the processing equipment corresponding to the second data group are written into the record file In one embodiment, whether the borehole center-of-gravity coordinates in the second data group corresponding to the current timestamp cover the standard center-of-gravity coordinates includes: taking the borehole center-of-gravity coordinates in the second data group corresponding to the current timestamp as the coordinates to be detected; for any standard center-of-gravity coordinate, obtaining the distance between the standard center-of-gravity coordinate and the nearest coordinate to be detected, and recording the distance as the target distance of the standard center-of-gravity coordinate; in response to the target distance corresponding to any standard center-of-gravity coordinate being greater than a preset distance threshold, determining that the borehole center-of-gravity coordinates in the second data group corresponding to the current timestamp do not cover the standard center-of-gravity coordinates; in response to the target distance corresponding to any standard center-of-gravity coordinate being less than or equal to the distance threshold, determining that the borehole center-of-gravity coordinates in the second data group corresponding to the current timestamp cover the standard center-of-gravity coordinates.

[0036] It should be noted that when adding a second data group corresponding to a processing device to a record file corresponding to a workpiece, the record file of the workpiece needs to be retrieved due to the need to scan the identification code on the workpiece. In order to avoid the situation where the identification codes of two workpieces are very close to each other, resulting in the first data group and the second data group of the workpiece being written into the record file corresponding to the workpiece due to the scanning of the identification code of another workpiece when the first data group or the second data group of the workpiece is written into the record file corresponding to the other workpiece, the present invention compares the standard size and standard coordinates in the record file with the second data group of the current timestamp. When the standard size is greater than the size of the workpiece corresponding to the second data group of the current timestamp, and the drilling center of gravity coordinates of the second data group cover the standard coordinates (that is, the drilling center of gravity coordinates include all coordinates in the standard coordinates), it means that the workpiece corresponding to the second data group is the same as the workpiece corresponding to the record file; otherwise, it means that the workpiece corresponding to the second data group is not the same as the workpiece corresponding to the record file. The reason is: under normal circumstances, the size of the workpiece will only be reduced by the trimming process; the position of the hole in the workpiece remains unchanged and will only increase and not decrease.

[0037] Furthermore, for a standard center of gravity coordinate, the coordinate to be detected that is closest to it is selected and marked as the selected coordinate; in response to another standard center of gravity coordinate, the coordinate to be detected other than the selected coordinate in the coordinates to be detected is selected, and it is iterated to obtain the coordinate to be detected that is closest to each standard center of gravity coordinate.

[0038] Table 1

[0039] In one implementation, the data in the third column of Table 1 is the standard data set for the data in the fourth column. That is, the data in the third column can be used to determine whether the data in the fourth column is wrong. The judgment method is: when S2 is greater than S1, it means that the size of the workpiece becomes larger after being processed by the processing equipment with the identity tag A3 (the process is trimming and cutting, and the processing equipment will only make the size of the workpiece smaller). At this time, it is determined that the workpiece corresponding to the data in the third column is not the same as the workpiece corresponding to the data in the fourth column. At this time, the data in the fourth column is not written into the record file. Furthermore, in (x 2,1 ,y 2,1 ) and (x 2,2 ,y 2,2 ) Any one of the two coordinates, and (x 3,1 ,y 3,1 )、(x 3,2 ,y 3,2 ) and (x 3,3 ,y 3,3 ) The distance between any of the three coordinates is greater than the distance threshold, indicating that the positions of one or two drill holes of the workpiece corresponding to the third column of data do not exist in the workpiece corresponding to the fourth column of data. Therefore, it is determined that the workpiece corresponding to the third column of data is not the same workpiece as the workpiece corresponding to the fourth column of data.

[0040] It should be noted that, considering that when the data of the coordinates of the center of gravity of a borehole are obtained twice, there may be noise in the data, that is, there may be slight differences in the coordinates of the center of gravity of the same borehole obtained twice, therefore, in this embodiment, it is determined whether the distance between the coordinates is greater than the distance threshold, and then whether the two coordinates belong to the same hole position.

[0041] In one embodiment, in response to the workpiece size in the second data group corresponding to the current timestamp being larger than the standard size and the drilling center of gravity coordinates in the second data group not covering the standard center of gravity coordinates, the second data group is deleted and an alarm is issued.

[0042] Step S7: Obtain the result of manual judgment on whether the workpiece is qualified. In response to the manual judgment that the workpiece is unqualified, obtain the record file corresponding to the workpiece through the identification code on the workpiece to trace the processing process of the workpiece.

[0043] In one embodiment, for any first data group corresponding to a processing device for processing a workpiece, the data group also includes a working mode of the processing device. In different working modes, the processing device will process the workpiece differently. For example, when a device with an identification tag of A1 processes a workpiece in the working mode of A1N1, the workpiece will be cut into a rectangle of a predetermined size and shape; when a device with an identification tag of A2 processes a workpiece in the working mode of A2N1, a predetermined position (such as the center of gravity) of the workpiece will be punched.

[0044] Further, obtaining the record file corresponding to the workpiece through the identification code on the workpiece to trace the processing process of the workpiece includes: obtaining the first data group corresponding to each processing device in the record file; and performing visualization processing according to the first data group corresponding to each processing device. In one embodiment, the first data group corresponding to each processing device in the record file is visualized to obtain Table 2.

[0045] Table 2

[0046] It should be noted that the unqualified part of the workpiece is obtained manually, and then the equipment for processing the unqualified part of the workpiece can be obtained in combination with Table 1. For example: the size of the workpiece with the workpiece ID of P001 is manually determined to be unqualified, and it is obtained from Table 1 that the workpiece is processed by the processing equipment with the identity tag of A1 in the working mode of A1N1 to obtain a predetermined shape and size. At this time, the processing equipment with the identity tag of A1 fails when processing the workpiece, but does not display a failure or alarm, so the processing equipment with the identity tag of A1 is repaired.

[0047] Figure 2 It is a block diagram schematically showing the structure of the workpiece traceability system based on identification code according to this embodiment.

[0048] The present invention also provides a workpiece traceability system based on identification codes. Figure 2 As shown, the system includes a processor and a memory, wherein the memory stores computer program instructions, and when the computer program instructions are executed by the processor, the workpiece traceability method based on the identification code according to the first aspect of the present invention is implemented.

[0049] In the present invention, the aforementioned memory may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, apparatus or device. For example, a computer-readable storage medium may be any appropriate magnetic storage medium or magneto-optical storage medium, such as a resistive random access memory RRAM (Resistive Random Access Memory), a dynamic random access memory DRAM (Dynamic Random Access Memory), a static random access memory SRAM (Static Random-Access Memory), an enhanced dynamic random access memory EDRAM (Enhanced Dynamic Random Access Memory), a high-bandwidth memory HBM (High-Bandwidth Memory), a hybrid memory cube HMC (Hybrid Memory Cube), etc., or any other medium that can be used to store the required information and can be accessed by an application, a module, or both. Any such computer storage medium may be part of a device or accessible or connectable to a device. Any application or module described in the present invention may be implemented using computer-readable / executable instructions that may be stored or otherwise maintained by such a computer-readable medium.

[0050] In the description of this specification, "plurality" or "several" means at least two, such as two, three or more, etc., unless otherwise clearly and specifically defined.

[0051] Although this specification has shown and described a number of embodiments of the present invention, it will be apparent to those skilled in the art that such embodiments are provided by way of example only. Those skilled in the art will conceive of many modifications, changes and alternatives without departing from the ideas and spirit of the present invention. It should be understood that in the practice of the present invention, various alternatives to the embodiments of the present invention described herein may be employed.

Claims

1. The artifact traceability method based on identification code is characterized by: include: Constructing a workpiece ID of the workpiece and a record file mapped to the workpiece ID; generating an identification code on the workpiece according to the workpiece ID; for any processing equipment for processing the workpiece: in response to the workpiece starting to be processed in the processing equipment, recording the identity tag of the processing equipment, the working gear, and whether there is a fault prompt of the processing equipment as a first data group; in response to the workpiece completing processing in the processing equipment, recording the size of the workpiece and the coordinates of the center of gravity of each drilled hole in the workpiece as a second data group, and configuring the second data group with a current timestamp; wherein each processing equipment corresponds to a first data group and a second data group; Recording a second data group corresponding to a timestamp adjacent to the current timestamp in the record file as a standard data group, wherein the standard data group includes a standard size and a predetermined number of standard center-of-gravity coordinates; in response to the fact that the workpiece size in the second data group corresponding to the current timestamp is less than or equal to the standard size and the drilling center-of-gravity coordinates in the second data group cover the standard center-of-gravity coordinates, retrieving the record file through the identification code, and writing the second data group corresponding to the current timestamp and the first data group corresponding to the processing equipment corresponding to the second data group into the record file; The result of manual judgment on whether the workpiece is qualified is obtained. In response to the manual judgment that the workpiece is unqualified, the record file corresponding to the workpiece is obtained through the identification code on the workpiece to trace the processing process of the workpiece.

2. The workpiece traceability method based on identification code according to claim 1 is characterized in that: Also includes: In response to the workpiece size in the second data group corresponding to the current timestamp being larger than the standard size and the drilling center of gravity coordinates in the second data group not covering the standard center of gravity coordinates, an alarm is issued.

3. The workpiece traceability method based on identification code according to claim 1 is characterized in that: Generating an identification code on an artifact based on the artifact ID includes: Get the text of the artifact ID; converting the text into encoded data; A two-dimensional code is generated according to the coded data, and the two-dimensional code is used as the identification code.

4. The workpiece traceability method based on identification code according to claim 1 is characterized in that: Obtaining the record file corresponding to the workpiece through the identification code on the workpiece can trace the processing process of the workpiece, including: Obtain a first data group corresponding to each processing device in the record file; Visualization processing is performed according to the first data group corresponding to each processing equipment.

5. The workpiece traceability method based on identification code according to claim 1 is characterized in that: The record files retrieved by the identification code include: Obtaining a corresponding workpiece ID through the identification code; The address of the record file is obtained according to the workpiece ID.

6. The workpiece traceability method based on identification code according to claim 1 is characterized in that: Determining whether the borehole center of gravity coordinates in the second data group corresponding to the current timestamp cover the standard center of gravity coordinates includes: Taking the coordinates of the center of gravity of the borehole in the second data group corresponding to the current timestamp as the coordinates to be detected; For any standard barycentric coordinate, obtain the distance between the standard barycentric coordinate and the nearest coordinate to be detected, and record the distance as the target distance of the standard barycentric coordinate; In response to a target distance corresponding to any standard barycentric coordinate being greater than a preset distance threshold, determining that the borehole barycentric coordinate in the second data group corresponding to the current timestamp is not covered by the standard barycentric coordinate; In response to a target distance corresponding to any standard barycentric coordinate being less than or equal to a distance threshold, it is determined that the borehole barycentric coordinate in the second data group corresponding to the current timestamp covers the standard barycentric coordinate.

7. The workpiece traceability method based on identification code according to claim 6 is characterized in that: For a standard center of gravity coordinate, select the coordinate to be detected that is closest to it and mark it as the selected coordinate; in response to another standard center of gravity coordinate, select the coordinate to be detected other than the selected coordinate in the coordinates to be detected, and iterate to obtain the coordinate to be detected that is closest to each standard center of gravity coordinate.

8. An artifact traceability system based on identification code, comprising a processor and a memory, wherein the memory stores a computer program, characterized in that: The processor executes the computer program to implement the workpiece traceability method based on the identification code as described in any one of claims 1-7.

Images