A method, system and storage medium for quality inspection data management in the pharmaceutical industry

Abstract

The present invention discloses a method, system and storage medium for quality inspection data management in the pharmaceutical industry. The method comprises scanning a material QR code through a mobile terminal to obtain material record information, setting a quality inspection sample QR code according to the obtained material type, and generating a sampling operation record; scanning the sample QR code again through a mobile terminal, adding disposal opinions to the quality inspection sample according to the sample inspection process, and recording the quality inspection sample disposal information and the corresponding disposal quantity in real time, generating a disposal operation record, generating a second quality inspection sample snapshot ID associated with the disposal operation record in a circulation record table, and generating an association record of the second quality inspection sample snapshot ID and the sample QR code in a QR code snapshot relationship table. The full process information of product sample management is fully recorded through QR codes, snapshot identifiers, and quality inspection operations, a complete quality inspection sample information flow is established, and the efficiency of quality inspection is improved.

Description

Technical Field

[0001] The present invention relates to the field of information technology, and in particular to a method, system and storage medium for quality inspection data management in the pharmaceutical industry. Background Art

[0002] At present, product quality inspection in traditional factories is mostly based on manual sampling, and quality inspectors manually fill out paper inspection forms, which cannot store product inspection information at a later stage. Due to the manual method, human errors may occur in inspection results and inspection disposal opinions, and problems such as repeated inspections of products require manual review and investigation, resulting in a large amount of manpower and time consumption. With the popularization of the application of computers and other equipment, in order to solve the above-mentioned drawbacks of manual quality inspection, online quality inspection systems have emerged. Such systems use computers to perform product quality inspection-related work and record product quality inspection information through computers. Although paperless operation has been achieved, some basic product information still needs to be manually entered into the computer, and there is still a risk of human error. The efficiency of product quality inspection is also relatively low, and mobile quality inspection cannot be achieved. Summary of the invention

[0003] In view of the deficiencies in the prior art, the present invention provides a method for managing quality inspection data in the pharmaceutical industry, comprising the following steps:

[0004] S1, scanning the material QR code through the mobile terminal to obtain material record information, wherein the material record information includes the plain text of the QR code, material composition, material batch, material quantity and material type;

[0005] S2, set the quality inspection sample QR code according to the acquired material type. When the material type is a single piece type, reference the material QR code as the sample ID of the quality inspection sample QR code. When the material type is a batch type, scan the corresponding inspection container as the sample ID of the quality inspection sample QR code.

[0006] S3, input and confirm the number of quality inspection samples to be sampled, bind the material information and the sampling quantity with the sample QR code in plain text, generate a sampling operation record, generate a record associating the first quality inspection sample snapshot ID with the sampling operation in the circulation record table, and generate a corresponding record between the material QR code and the first quality inspection sample snapshot ID in the QR code snapshot relationship table; the sample snapshot is the material barcode state formed after the same operation is performed on the material from the same source at the same time, including the sample QR code information, operation information, sample information and sample quantity;

[0007] S4, scan the sample QR code again through the mobile terminal, add disposal opinions to the quality inspection sample according to the sample inspection process, and record the quality inspection sample disposal information and the corresponding disposal quantity in real time, generate a disposal operation record, generate a second quality inspection sample snapshot ID associated with the disposal operation record in the circulation record table, and generate an association record between the second quality inspection sample snapshot ID and the sample QR code in the QR code snapshot relationship table.

[0008] Preferably, the step S4 specifically includes: the first quality inspection sample snapshot ID and the second quality inspection sample snapshot ID are generated by UUID.

[0009] Preferably, the circulation record table is configured to record various quality inspection information and corresponding circulation records of logistics, including but not limited to interrelated source material snapshot ID, operation record ID, target material snapshot ID and source material deduction quantity.

[0010] Preferably, the QR code snapshot relationship table is configured to record the snapshot identifier of the operation record and the quality inspection sample QR code record of the operation after the quality inspection operation on the material is completed, and generate a flow record in the flow record table by using the snapshot identifier as the source material snapshot ID.

[0011] Preferably, the step S3 further comprises:

[0012] In the QR code snapshot relationship table, find the material snapshot ID corresponding to the raw material barcode according to the container barcode, and generate a record in the material flow record table that associates the material snapshot ID with the merging operation;

[0013] A record is generated in the QR code snapshot relationship table that associates the material snapshot ID with the barcode. If all the quantities of materials in the container have been boxed, the record corresponding to the QR code in the QR code snapshot relationship table is deleted.

[0014] The present invention also discloses a pharmaceutical industry quality inspection data management system, including: a first information acquisition module, which obtains material record information by scanning a material QR code, wherein the material record information includes the QR code plain text, material composition, material batch, material quantity and material type; a quality inspection sample QR code setting module, which is used to set the quality inspection sample QR code according to the acquired material type, and when the material type is a single-piece type, the material QR code is referenced as the sample ID of the quality inspection sample QR code; when the material type is a batch type, the corresponding inspection container is scanned as the sample ID of the quality inspection sample QR code; a record generation module, which is used to input and confirm the number of quality inspection sample samples, bind the material information and the sampling quantity with the sample QR code plain text, generate a sampling operation record, and generate a flow record table in the flow record table. A record is associated with the first quality inspection sample snapshot ID and the sampling operation, and a corresponding record of the material QR code and the first quality inspection sample snapshot ID is generated in the QR code snapshot relationship table; the sample snapshot is the material barcode state formed after the same operation is performed on the material from the same source at the same time, including sample QR code information, operation information, sample information and sample quantity; the quality inspection disposal module scans the sample QR code again, adds disposal opinions to the quality inspection sample according to the sample inspection process, and records the quality inspection sample disposal information and the corresponding disposal quantity in real time, generates a disposal operation record, generates a second quality inspection sample snapshot ID associated with the disposal operation record in the circulation record table, and generates an association record of the second quality inspection sample snapshot ID and the sample QR code in the QR code snapshot relationship table.

[0015] Preferably, the first quality inspection sample snapshot ID and the second quality inspection sample snapshot ID are generated by UUID.

[0016] Preferably, the circulation record table is configured to record various quality inspection information and corresponding circulation records of logistics, including but not limited to interrelated source material snapshot ID, operation record ID, target material snapshot ID and source material deduction quantity.

[0017] The present invention also discloses a pharmaceutical industry quality inspection data management device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of any of the aforementioned methods when executing the computer program.

[0018] The present invention also discloses a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of any of the aforementioned methods are implemented.

[0019] The pharmaceutical industry quality inspection data management method, system and storage medium disclosed in this embodiment completely record the whole process information of product sample management through QR code, snapshot identification and quality inspection operation, and establish a complete quality inspection sample information flow. Based on mobile terminal application scanning, it eliminates the work of on-site desktop computer deployment, solves the limitation that quality inspection can only be carried out in the laboratory, improves the portability of operation, and greatly improves the efficiency of quality inspection; through the sampling, disposal, return and other operations of quality inspection samples, the quality inspection sample processing process is standardized, and the full process operation and information of quality inspection samples are recorded using QR code image recognition technology, an accurate and real-time quality file is established, and complete product quality traceability information is provided.

[0020] Additional aspects and advantages of the present invention will be given in part in the following description and in part will be obvious from the following description, or will be learned through practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of this application. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings:

[0022] Figure 1 The present invention is a flowchart of a method for managing quality inspection data in the pharmaceutical industry disclosed in an embodiment. DETAILED DESCRIPTION

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

[0024] In the present invention, unless otherwise clearly specified and limited, the technical terms or scientific terms used herein shall have the common meanings understood by persons with ordinary skills in the field to which the present invention belongs. The words "first", "second" and similar words used in the patent application specification and claims of the present invention do not indicate any order, quantity or importance, but are only used to distinguish different components. Similarly, words such as "one" or "an" do not indicate a quantity limitation, but indicate the existence of at least one.

[0025] The present invention proposes a mobile-based quality inspection sample data management method, which can standardize the quality inspection sample processing process and establish a complete quality traceability data chain through efficient data recording and query methods. Figure 1As shown, this embodiment discloses a method for managing quality inspection data in the pharmaceutical industry, comprising the following steps:

[0026] Step S1, scan the material QR code through the mobile terminal to obtain material record information, the material record information includes the QR code plain text, material composition, material batch, material quantity and material type. Specifically, scan the product or material QR code through the mobile terminal, and obtain product-related information including: QR code plain text, material, batch, quantity, product type and other related information. Using the mobile terminal to scan the code, the relevant data can be quickly parsed, avoiding the risk of human input errors.

[0027] Step S2, set the quality inspection sample QR code according to the acquired material type. When the material type is a single piece type, reference the material QR code as the sample ID of the quality inspection sample QR code. When the material type is a batch type, scan the corresponding inspection container as the sample ID of the quality inspection sample QR code.

[0028] Specifically, when setting the quality inspection sample QR code, there will be different processing procedures depending on the product type; when the product type is a single piece type, the quality inspection sample QR code can reference the product QR code as the sample identifier; when the product type is a batch type, the quality inspection sample QR code can be automatically generated by the system as the sample identifier, or an existing inspection container or other external QR code can be scanned as the sample identifier. By coding the sample, the quality inspection sample information can be fully recorded.

[0029] Step S3, input and confirm the quantity of quality inspection samples, bind the material information and sampling quantity with the sample QR code in plain text, generate a sampling operation record, generate a record associating the first quality inspection sample snapshot ID with the sampling operation in the circulation record table, and generate a corresponding record between the material QR code and the first quality inspection sample snapshot ID in the QR code snapshot relationship table; the sample snapshot is the material barcode state formed after the same operation is performed on the material from the same source at the same time, including sample QR code information, operation information, sample information and sample quantity.

[0030] In a factory, the circulation process of materials or products is that the materials become another material after a certain operation. We can establish the association relationship of all materials in the workshop by recording the following relationships. Material 1-operation 1-material 2, material 2-operation 2-material 3. Although theoretically we can establish the association described above through material barcodes, there are several problems: the container frame will be reused, the material barcode cannot be unique, and the time factor must be considered when associating, and the association efficiency is very low; although the single barcode is unique, it will be repeatedly used in different processes, and the time factor must also be considered when associating; the input, output and other actions on the equipment are not related through the material barcode, but through a certain deduction algorithm; there are multiple operation record sheets, and many other actions may occur between output and input. If you look for them one by one, the association efficiency is very low.

[0031] Therefore, in this embodiment, the material is identified by material snapshot ID instead of material barcode. Then the record of material 1-operation 1-material 2 can be converted into the record of material snapshot ID1-operation-material snapshot ID2. The logistics snapshot is configured as a state record of the material. At the same time, the material formed by the same operation from the same source is recorded as a barcode state. All information of this barcode state is recorded as a material snapshot. The information record in the system is triggered by the operation. After each operation occurs, there will be a corresponding operation record in the system. The operation record contains information such as the source material barcode, time, location, operator, target material barcode, etc.

[0032] Specifically, the product / material information and sampling quantity and other information are plainly bound to the sample QR code to generate a "sampling" operation record, a record of the product snapshot identifier and the "sampling" operation is added to the circulation record table, and a record of the product QR code and the snapshot identifier is generated in the QR code snapshot relationship table.

[0033] The record of quality traceability data mainly includes two parts: the source of the product / quality inspection sample and the operation of the product / quality inspection sample. The quality inspection process data is recorded through the product / quality inspection sample QR code and operation to establish a complete product quality inspection association relationship. Considering that the product / quality inspection sample QR code will be reused, the product quality inspection sample barcode cannot be unique, and it is necessary to record it by time when associating, and the association efficiency will be very low; there will also be product / quality inspection sample QR codes that will be used repeatedly in different operations, and the time factor needs to be considered when associating, which also causes low association efficiency. Therefore, in this embodiment, the snapshot identifier is used to identify the product / quality inspection sample instead of the QR code, so the record "product / quality inspection sample"-"operation"-"product / quality inspection sample" can be converted to "snapshot identifier 1"-"operation"-"snapshot identifier 2". Among them, "snapshot identifier 1" is the first quality inspection sample snapshot ID, and "snapshot identifier 2" is the second quality inspection sample snapshot ID.

[0034] The quality inspection information record is triggered by sampling, disposal, and return operations. After each operation occurs, we will record the corresponding operation record. The operation record contains information such as product QR code / sample identification QR code, product information, operation time, quantity, target QR code, etc. The operation record contains information about the snapshot of the product / quality inspection sample.

[0035] The operation record ID will be used as the product / quality inspection sample snapshot ID. All operation record IDs should be generated by the UUID universal unique identifier, so that the operation record IDs in different tables can be guaranteed to be globally unique. When tracing product quality inspections, the operation record ID is used to associate the corresponding actual quality inspection sample operations.

[0036] In this embodiment, the circulation record table is configured to record various quality inspection information and corresponding circulation records of logistics, including but not limited to the mutually related source material snapshot ID, operation record ID, target material snapshot ID and source material deduction quantity. The circulation record table is used to record the associated records of "source QR code snapshot identification", "operation record identification" and "target QR code snapshot identification". Through the snapshot identification, the quality inspection circulation relationship of the product can be connected in series to find all the quality inspection information of the product. In addition, an operation record table can be added to record the sampling, disposal and return operation records corresponding to the product / quality inspection sample.

[0037] In this embodiment, for situations where the barcode of a material is associated, such as output and input, since there are many possibilities for the last operation of inputting, if you want to directly record the relationship between the input and the previous material snapshot ID of the material when inputting, you need to search in various tables, which is very time-consuming. In order to improve this time-consuming, this implementation introduces a QR code snapshot relationship table, and immediately records the material snapshot ID of the operation record and the target material QR code of the operation after the operation is executed, so that the material snapshot ID corresponding to the QR code can be quickly found through the material QR code during the next operation, so that the material snapshot ID can be used as the source material snapshot ID to generate a record in the material flow record table.

[0038] The QR code snapshot relationship table is configured to record the snapshot identifier of the operation record and the QR code of the quality inspection sample of the operation after the quality inspection operation on the material is completed, and generate a circulation record in the circulation record table by using the snapshot identifier as the source material snapshot ID. Specifically, a QR code snapshot relationship table is added, and the snapshot identifier of the operation record and the target QR code of the operation are recorded after the operation is completed. Before the next operation, the snapshot identifier corresponding to the QR code can be quickly found by using the product / sample identifier QR code, and a circulation record is generated in the circulation record table by using the snapshot identifier as the source QR code snapshot identifier.

[0039] Step S4, scan the sample QR code again through the mobile terminal, add disposal opinions to the quality inspection sample according to the sample inspection process, and record the quality inspection sample disposal information and the corresponding disposal quantity in real time, generate a disposal operation record, generate a second quality inspection sample snapshot ID associated with the disposal operation record in the circulation record table, and generate an association record of the second quality inspection sample snapshot ID and the sample QR code in the QR code snapshot relationship table. The first quality inspection sample snapshot ID and the second quality inspection sample snapshot ID are generated by UUID.

[0040] Specifically, the sample QR code is scanned again through the mobile terminal, and relevant information of the quality inspection sample is obtained, including: the plain text of the QR code, the plain text of the QR code of the product to which it belongs, and other related information.

[0041] According to the actual sample inspection, the quality inspection samples are disposed of accordingly, including three disposal opinions: qualified, scrapped and returned, and the quality inspection sample disposal information and the corresponding disposal quantity are recorded in real time.

[0042] Through the analysis of the samples, the final inspection results of the products are selected and the inspection information of the products is recorded; a "disposal" operation record is generated, and the snapshot identifier corresponding to the QR code is found in the QR code snapshot relationship table according to the sample QR code, and an association record between the quality inspection sample snapshot identifier and the "disposal" operation record is generated in the circulation record table, and an association record between the sample snapshot identifier and the sample QR code is generated in the QR code snapshot relationship table.

[0043] In this embodiment, step S4 may further specifically include the following contents.

[0044] Step S401, scan the sample QR code through the mobile terminal, and obtain relevant information of the quality inspection sample including: plain text of the QR code, plain text of the product QR code, sample disposal method, product type and other related information. Only the relevant quality inspection samples whose disposal method is return will be processed later.

[0045] Step S402, when setting the QR code for the returned product, there will be different processing procedures depending on the type of product; when the product type is a single-piece type, the returned product barcode automatically uses the product barcode; when the product type is a batch type, the quality inspection sample can be returned to the product to which the quality inspection sample belongs, or the product QR code with the same attributes as the quality inspection sample can be scanned through the mobile terminal.

[0046] Step S403, generate an operation record of the return action, find the second quality inspection sample snapshot ID corresponding to the QR code according to the sample QR code in the QR code snapshot relationship table, generate a sample snapshot identifier in the flow record table and associate it with the operation record of the return action, and generate a record of the quality inspection sample QR code and the second quality inspection sample snapshot ID in the QR code snapshot relationship table.

[0047] In this embodiment, the quality inspection traceability information can also be quickly queried by scanning the product QR code, including the records of all operations on the sample during the quality inspection process. Specifically, the quality inspection traceability information is obtained by scanning the product QR code on the mobile terminal. The snapshot identifier of the product is obtained through the product QR code. The operation record identifier, sample operation type, and source QR code snapshot identifier in the circulation record table are obtained through the product snapshot identifier. The previous operation record identifier, sample operation type, and previous source QR code snapshot identifier are found through the source QR code snapshot identifier; the aforementioned steps are repeated until the next operation in the circulation record cannot be found.

[0048] In the QR code snapshot relationship table, due to reasons such as the recycling of frame barcodes, when the material in this state decreases, the material quantity in the QR code snapshot relationship table must be deducted. When the quantity is deducted to 0, the association between the barcode and this material snapshot no longer exists, and the barcode status record must be deleted.

[0049] In another embodiment, when multiple material frames are combined, a combined frame record may be generated. Specifically, the material snapshot ID corresponding to the raw material barcode is found in the QR code snapshot relationship table according to the container barcode, and a record associating the material snapshot ID with the combined frame operation is generated in the material flow record table. A record associating the material snapshot ID with the barcode is generated in the QR code snapshot relationship table. If all the materials in the container have been combined, the record corresponding to the QR code in the QR code snapshot relationship table is deleted.

[0050] When multiple material frames are split, a split record can be generated. Specifically, the material snapshot ID corresponding to the raw material barcode is found in the QR code snapshot relationship table according to the container barcode, and a record is generated in the material flow record table that associates the material snapshot ID with the split operation. A record is generated in the QR code snapshot relationship table that associates the material snapshot ID with the barcode, and the material quantity corresponding to the QR code in the QR code snapshot relationship table is deducted.

[0051] In this embodiment, the deduction of the quantity of materials in a container such as a material box can be implemented according to the following steps:

[0052] If the ratio of the quantity of the current material sample snapshot to the overall quantity is less than 1 / 100, and the current sample quantity is greater than the quantity of the current material sample snapshot, the quantity of the material sample snapshot will be fully deducted.

[0053] On the basis of the last deduction, the deduction quantity of the current material sample snapshot is calculated according to the ratio of the quantity of the current material sample snapshot to the remaining overall quantity and the remaining quantity. Specifically, the decimal deduction principle can be adopted, and if the division is not exact, it is accurate to 3 decimal places. Or the integer deduction principle can be adopted, and if the division is not exact, the decimal place is rounded up.

[0054] For the last material sample snapshot, deduct all remaining quantities from the previous ones.

[0055] The quality inspection data management method for the pharmaceutical industry disclosed in this embodiment completely records the full process information of product sample management through QR codes, snapshot identification, and quality inspection operations, and establishes a complete quality inspection sample information flow. Based on mobile terminal application scanning, it eliminates the work of on-site desktop computer deployment, solves the limitation that quality inspection can only be carried out in the laboratory, improves the portability of operation, and greatly improves the efficiency of quality inspection; through the sampling, disposal, return and other operations of quality inspection samples, the quality inspection sample processing process is standardized, and the full process operation and information of quality inspection samples are recorded using QR code image recognition technology, an accurate and real-time quality file is established, and complete product quality traceability information is provided.

[0056] In another embodiment, a pharmaceutical industry quality inspection data management system is also disclosed, including:

[0057] The first information acquisition module obtains material record information by scanning the material QR code, and the material record information includes the QR code plain text, material composition, material batch, material quantity and material type. The quality inspection sample QR code setting module is used to set the quality inspection sample QR code according to the acquired material type. When the material type is a single-piece type, the material QR code is referenced as the sample ID of the quality inspection sample QR code. When the material type is a batch type, the corresponding inspection container is scanned as the sample ID of the quality inspection sample QR code. The record generation module is used to input and confirm the number of quality inspection sample samples, bind the material information and the sampling quantity with the sample QR code plain text, generate a sampling operation record, generate a record of the first quality inspection sample snapshot ID associated with the sampling operation in the circulation record table, and generate a corresponding record of the material QR code and the first quality inspection sample snapshot ID in the QR code snapshot relationship table; the sample snapshot is the material barcode state formed after the same operation is performed on the material from the same source at the same time, including sample QR code information, operation information, sample information and sample quantity. The quality inspection and disposal module scans the sample QR code again, adds disposal opinions to the quality inspection sample according to the sample inspection process, and records the quality inspection sample disposal information and the corresponding disposal quantity in real time, generates a disposal operation record, generates a second quality inspection sample snapshot ID associated with the disposal operation record in the circulation record table, and generates an association record between the second quality inspection sample snapshot ID and the sample QR code in the QR code snapshot relationship table.

[0058] In this embodiment, the first quality inspection sample snapshot ID and the second quality inspection sample snapshot ID are generated by UUID.

[0059] In this embodiment, the circulation record table is configured to record various quality inspection information and corresponding circulation records of logistics, including but not limited to interrelated source material snapshot ID, operation record ID, target material snapshot ID and source material deduction quantity.

[0060] The specific functions of the above-mentioned pharmaceutical industry quality inspection data tracing system correspond one-to-one to the pharmaceutical industry quality inspection data tracing method disclosed in the previous embodiment, so it will not be described in detail here. For details, please refer to the various embodiments of the pharmaceutical industry quality inspection data tracing method disclosed in the previous embodiment. It should be noted that the various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same and similar parts between the various embodiments can be referred to each other.

[0061] In other embodiments, a pharmaceutical industry quality inspection data tracing device is also provided, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the various steps of the pharmaceutical industry quality inspection data tracing method described in the above embodiments when executing the computer program.

[0062] The pharmaceutical industry quality inspection data tracing device may include, but not limited to, a processor and a memory. The server may include, but not limited to, a processor and a memory. Those skilled in the art will appreciate that the schematic diagram is merely an example of a server and does not constitute a limitation on the server device. The server device may include more or fewer components than shown in the diagram, or may combine certain components, or different components. For example, the server device may also include input and output devices, network access devices, buses, etc.

[0063] The processor may be a central processing unit (CPU), other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or any conventional processor, etc. The processor is the control center of the server device, and uses various interfaces and lines to connect various parts of the entire server device.

[0064] The memory can be used to store the computer program and / or module, and the processor realizes various functions of the server device by running or executing the computer program and / or module stored in the memory, and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application required for a function, etc. In addition, the memory can include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (SmartMedia Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (Flash Card), at least one disk storage device, a flash memory device, or other volatile solid-state storage devices.

[0065] If the pharmaceutical industry quality inspection data traceability method is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the present invention implements all or part of the processes in the above-mentioned embodiment method, and can also be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium. When the computer program is executed by the processor, the steps of the above-mentioned various method embodiments can be implemented. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, U disk, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium. It should be noted that the content contained in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, the computer-readable medium does not include electric carrier signals and telecommunication signals.

[0066] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

[0067] In conclusion, the above is only a preferred embodiment of the present invention, and all equivalent changes and modifications made according to the scope of the patent application of the present invention should fall within the scope of the patent of the present invention.

Claims

1. A method for managing quality inspection data in the pharmaceutical industry, characterized in that: The steps include: S1, scanning the material QR code through the mobile terminal to obtain material record information, wherein the material record information includes the plain text of the QR code, material composition, material batch, material quantity and material type; S2, set the quality inspection sample QR code according to the acquired material type. When the material type is a single piece type, reference the material QR code as the sample ID of the quality inspection sample QR code. When the material type is a batch type, scan the corresponding inspection container as the sample ID of the quality inspection sample QR code. S3, input and confirm the number of quality inspection samples to be sampled, bind the material information and the sampling quantity with the sample QR code in plain text, generate a sampling operation record, generate a record associating the first quality inspection sample snapshot ID with the sampling operation in the circulation record table, and generate a corresponding record between the material QR code and the first quality inspection sample snapshot ID in the QR code snapshot relationship table; the sample snapshot is the material barcode state formed after the same operation is performed on the material from the same source at the same time, including the sample QR code information, operation information, sample information and sample quantity; S4, scan the sample QR code again through the mobile terminal, add disposal opinions to the quality inspection sample according to the sample inspection process, and record the quality inspection sample disposal information and the corresponding disposal quantity in real time, generate a disposal operation record, generate a second quality inspection sample snapshot ID associated with the disposal operation record in the circulation record table, and generate an association record between the second quality inspection sample snapshot ID and the sample QR code in the QR code snapshot relationship table.

2. The pharmaceutical industry quality inspection data tracing method according to claim 1, characterized in that: The step S4 specifically includes: the first quality inspection sample snapshot ID and the second quality inspection sample snapshot ID are generated by UUID.

3. The method for tracing quality inspection data in the pharmaceutical industry according to claim 2, characterized in that: The circulation record table is configured to record various quality inspection information and corresponding circulation records of logistics, including but not limited to the mutually related source material snapshot ID, operation record ID, target material snapshot ID and source material deduction quantity.

4. The method for tracing quality inspection data in the pharmaceutical industry according to claim 3, characterized in that: The QR code snapshot relationship table is configured to record the snapshot identifier of the operation record and the quality inspection sample QR code of the operation after the quality inspection operation on the material is completed, and generate a circulation record in the circulation record table by using the snapshot identifier as the source material snapshot ID.

5. The method for tracing quality inspection data in the pharmaceutical industry according to claim 4, characterized in that: The step S3 further comprises: In the QR code snapshot relationship table, find the material snapshot ID corresponding to the raw material barcode according to the container barcode, and generate a record in the material flow record table that associates the material snapshot ID with the merging operation; A record is generated in the QR code snapshot relationship table that associates the material snapshot ID with the barcode. If all the quantities of materials in the container have been boxed, the record corresponding to the QR code in the QR code snapshot relationship table is deleted.

6. A quality inspection data management system for the pharmaceutical industry, characterized in that: include: The first information acquisition module acquires material record information by scanning the material QR code, wherein the material record information includes the plain text of the QR code, material composition, material batch, material quantity and material type; The quality inspection sample QR code setting module is used to set the quality inspection sample QR code according to the acquired material type. When the material type is a single piece type, the material QR code is referenced as the sample ID of the quality inspection sample QR code. When the material type is a batch type, the corresponding inspection container is scanned as the sample ID of the quality inspection sample QR code. A record generation module is used to input and confirm the number of quality inspection sample samples, bind the material information and the sampling quantity with the sample QR code in plain text, generate a sampling operation record, generate a record associating the first quality inspection sample snapshot ID with the sampling operation in the circulation record table, and generate a corresponding record between the material QR code and the first quality inspection sample snapshot ID in the QR code snapshot relationship table; the sample snapshot is the material barcode state formed after the same operation is performed on the material from the same source at the same time, including the sample QR code information, operation information, sample information and sample quantity; The quality inspection and disposal module scans the sample QR code again, adds disposal opinions to the quality inspection sample according to the sample inspection process, and records the quality inspection sample disposal information and the corresponding disposal quantity in real time, generates a disposal operation record, generates a second quality inspection sample snapshot ID associated with the disposal operation record in the circulation record table, and generates an association record between the second quality inspection sample snapshot ID and the sample QR code in the QR code snapshot relationship table.

7. The pharmaceutical industry quality inspection data tracing system according to claim 6, characterized in that: The first quality inspection sample snapshot ID and the second quality inspection sample snapshot ID are generated by UUID.

8. The pharmaceutical industry quality inspection data tracing system according to claim 7, characterized in that: The circulation record table is configured to record various quality inspection information and corresponding circulation records of logistics, including but not limited to the mutually related source material snapshot ID, operation record ID, target material snapshot ID and source material deduction quantity.

9. A pharmaceutical industry quality inspection data management device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 5 are implemented.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 5 are implemented.

Images