Product quality detection method, quality detection system and storage medium

Abstract

The invention relates to the technical field of quality detection, and provides a product quality detection method, a quality detection system and a storage medium, and the quality detection method comprises the following steps: setting inspection items corresponding to a product on an inspection list, storing the inspection items through a data table, and configuring an inspection scheme group for the product, inspection schemes in one-to-one correspondence with the products are arranged in the inspection scheme group, the inspection scheme group is stored through the data table, inspection data are obtained by inspecting the inspection items through the inspection schemes, the inspection data are input and stored in an inspection list, and a quality inspection report is generated according to the inspection list. Through flattening of the database design structure, the quality inspection items can be flexibly added, modified and adjusted, IT personnel do not need to intervene in modifying database fields every time, and operation convenience and efficiency are greatly improved. And the quality inspection report can be automatically generated from the inspection list, so that the risks of manual operation and human errors are reduced.

Description

Technical Field

[0001] The present application relates to the technical field of quality inspection, and in particular to a product quality inspection method, a quality inspection system and a storage medium. Background Art

[0002] In the manufacturing industry, when conducting quality inspections, companies mainly rely on paper-based manual recording and traditional software input and storage methods to record data and generate reports.

[0003] The paper-based manual recording method has its limitations. First, it requires printing templates in advance and then recording data by hand on site, which not only wastes paper resources but also increases the workload of quality inspectors. Secondly, paper data is extremely inconvenient for later data statistics and analysis, and data loss or errors are prone to occur, and the traceability of paper documents is also very cumbersome. In addition, paper inspection sheets cannot directly generate external quality inspection reports, and quality inspectors need to re-enter and save or organize data, adding additional workload.

[0004] Although the traditional software input and save method has improved the efficiency of data processing to a certain extent, it still has shortcomings. Traditional software cannot formulate personalized quality inspection document formats for different customers. Once a customer requires the addition of new quality inspection items, the IT department needs to intervene to modify the database structure. The operation process is complicated and time-consuming. In addition, traditional software cannot achieve the integrated processing of internal inspections and external quality inspection reports. There is a disconnect between internal inspections and external quality inspection reports. Quality inspectors need to repeatedly enter and save the same data, which increases the risk of errors and workload. Summary of the invention

[0005] In order to help solve the problem that the paper manual recording method cannot generate external quality inspection reports and the traditional software input and storage method cannot add new quality inspection items, the present application provides a product quality inspection method, a quality inspection system and a storage medium.

[0006] In the first aspect, the present application provides a product quality detection method, which adopts the following technical solution: A product quality detection method, wherein the quality detection method comprises the following steps: Setting inspection items corresponding to the product on the inspection sheet and storing the inspection items in a data table, An inspection scheme group is configured for the product, wherein the inspection scheme group is provided with the inspection schemes corresponding to the products one by one, and the inspection scheme group is stored in the data table, The inspection items are inspected by the inspection plan to obtain inspection data. The inspection data is entered and saved into the inspection form, and a quality inspection report is generated based on the inspection form.

[0007] By adopting the above technical solution, inspection items and inspection plans are stored and managed based on data tables, abandoning the traditional method of adding database fields for each inspection item. Whether adding, modifying or deleting inspection items, there is no need to change the underlying database structure, thus avoiding cumbersome IT intervention and potential system downtime. All inspection data are stored in a unified data table for centralized management and analysis, which not only helps to improve data security and integrity, but also provides a solid foundation for subsequent data mining and decision support.

[0008] Preferably, the data table has data table rows and data table columns, When the data table stores the inspection items, the inspection items that all products have that exceed a preset ratio are stored in the data table rows, and the remaining inspection items are stored in the data table columns. When the data table stores the inspection scheme groups, the inspection scheme groups corresponding to the products of the preset ratio are stored through the data table rows, and the remaining inspection scheme groups are stored through the data table columns.

[0009] By adopting the above technical solutions, the specific structure of the data table is further clarified, and inspection items and inspection plan groups are stored through a combination of rows and columns to achieve more efficient data access and management. The design of the data table reserves enough space to accommodate inspection items and plans that may be added in the future. This scalability ensures that the system can be flexibly adjusted as business needs change.

[0010] Preferably, after the inspection data is entered and saved in the inspection form, the inspection data is stored as historical data, and after the inspection plan group is configured for the product, the inspection plan is selected or calculated for the product based on the historical data.

[0011] By adopting the above technical solution, it is proposed to save the inspection data as historical data, and select or calculate the appropriate inspection plan for new products based on this data. By analyzing the historical inspection data, the system can automatically recommend or calculate the most appropriate inspection plan for new products. The accuracy and objectivity of decision-making are improved. By using historical data for plan selection or calculation, it can ensure that the quality inspection standards of similar products at different times or in different batches are consistent. This consistency improves the reliability of product quality.

[0012] Preferably, when selecting or calculating the inspection plan for the product based on the historical data, a high-correlation inspection plan that meets the high-correlation conditions is selected from the historical data, and the inspection plan for the product is calculated or selected based on the high-correlation inspection plan, and the high-correlation conditions include at least: the closest distance to the production date of the product, the same name as the product, the same specifications as the product, the same target customers as the product, and the same supplier as the product.

[0013] By adopting the above technical solution, a method for selecting or inferring inspection plans based on historical data is specifically described. By comprehensively considering multiple relevance conditions, the system can more accurately match appropriate inspection plans for new products. This precise matching helps to ensure the accuracy and effectiveness of quality inspection results.

[0014] Preferably, in the quality inspection method, the inspection sheet is selected by full inspection or screening, and the quality inspection report is generated according to the inspection sheet through a quality inspection report generation algorithm.

[0015] By adopting the above technical solution, the process of selecting inspection orders through full inspection or screening and automatically generating quality inspection reports using the quality inspection report generation algorithm is introduced. From the selection of inspection orders to the generation of quality inspection reports, the entire process is highly automated, which not only reduces the links of manual intervention, but also significantly improves the efficiency and accuracy of quality inspection work.

[0016] Preferably, before inspecting the product, When the product is purchased and put into storage, the basic information of the product is entered and saved, and a purchase and storage QR code label is generated, and the purchase and storage QR code label is attached to the product. During the production phase of the product, relevant information is input and saved, and a production tracking QR code label is generated, and the production tracking QR code label is affixed to the product. The inspection personnel use a code scanning device to scan the purchase warehousing QR code label and the production tracking QR code label, the database identifies the product, and generates the inspection sheet based on a preset inspection template.

[0017] By adopting the above technical solution, a method of using QR code labels to track products during the procurement, warehousing and production stages is proposed, and inspection orders are generated based on these labels. By equipping products with unique QR code labels, the system can easily track information on each link of product procurement, warehousing, production and quality inspection, which helps to ensure the safety and reliability of products and improves the efficiency of subsequent inspections.

[0018] In a second aspect, the present application provides a quality inspection system using the product quality inspection method as described in the first aspect, adopting the following technical solution: A quality inspection system using the product quality inspection method according to the first aspect, wherein the quality inspection system comprises a purchase warehousing order acquisition module, a production tracking order acquisition module, an inspection order module, an inspection plan module, a historical data module and a quality inspection report module, The inspection form module is respectively connected to the purchase warehouse form acquisition module, the production tracking form acquisition module and the inspection plan module, and the inspection plan module is respectively connected to the historical data module and the quality inspection report module. The purchase receipt acquisition module is used to acquire the purchase receipt acquisition module, the production tracking order acquisition module is used to acquire the production tracking order, the inspection order module is used to generate the inspection order according to the purchase receipt QR code label and the production tracking QR code label, the inspection plan module is used to configure the inspection plan group, the historical data module is used to select the inspection plan for the product, and the quality inspection report module is used to generate the quality inspection report.

[0019] By adopting the above technical solution, a quality inspection system integrating multiple modules is described, including functional modules such as data acquisition, data processing, solution selection, and report generation. The seamless integration between the functional modules ensures the consistency and efficiency of the quality inspection process.

[0020] In a third aspect, the present application provides a storage medium, which adopts the following technical solution: A storage medium, wherein the storage medium stores at least one instruction, at least one program, a code set or an instruction set, and the at least one instruction, the at least one program, the code set or the instruction set is loaded and executed by a processor to implement the product quality detection method as described in the first aspect.

[0021] By adopting the above technical solution, the product quality detection method is stored in the form of instructions, programs, etc. on the storage medium, so that these methods and programs can be easily deployed and executed on different computing devices. This not only simplifies the deployment process, but also makes subsequent maintenance and updates easier and more efficient.

[0022] In summary, the product quality inspection method of the present application flattens the database design structure, so that quality inspection items can be flexibly added, modified and adjusted, without the need for IT personnel to intervene and modify database fields every time, greatly improving the convenience and efficiency of operation. It can also automatically generate quality inspection reports from inspection sheets, breaking the disconnection problem between inspections and quality inspection reports in traditional quality inspection software, realizing full automation from inspections to quality inspection reports, and reducing the risk of manual operations and human errors. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1A schematic diagram of a process flow of an embodiment of a product quality detection method of the present application; Figure 2 for Figure 1 Another flow chart of the illustrated embodiment; and Figure 3 A schematic block diagram of an embodiment of a quality detection system of the present application.

[0024] Figure numerals: 1. Purchase receipt acquisition module; 2. Production tracking order acquisition module; 3. Inspection order module; 4. Inspection plan module; 5. Historical data module; 6. Quality inspection report module. DETAILED DESCRIPTION

[0025] With reference to the accompanying drawings and specific embodiments, the composition, characteristics and advantages of the product quality inspection method, quality inspection system and storage medium according to the present application will be described below in an exemplary manner. However, all descriptions should not be used to form any limitations on the present application.

[0026] In addition, for any single technical feature described or implied in the embodiments mentioned in this document, or any single technical feature displayed or implied in the drawings, this application still allows for continued arbitrary combination or deletion between these technical features (or their equivalents) without any technical obstacles, and thus it should be considered that these more embodiments according to this application are also within the scope of the description of this document.

[0027] It should also be noted that the terms "disposed" and the like should be understood in a broad sense, for example, it can be fixedly connected, detachably connected, or integrated; it can be directly connected, or indirectly connected through an intermediate medium. Unless otherwise clearly defined, those skilled in the art can understand the specific meanings of the above terms in this application according to specific circumstances.

[0028] Figure 1 This is a flow chart of an embodiment of a product quality detection method of the present application. Figure 1 It can be seen that product quality testing methods can include: Step S1: setting inspection items corresponding to the product on the inspection sheet, and storing the inspection items in a data table; Step S2: configuring an inspection plan group for the product, wherein the inspection plan group is provided with the inspection plans corresponding to the products one by one, and storing the inspection plan group through the data table; Step S3: inspecting the inspection items according to the inspection plan to obtain inspection data; Step S4: entering and saving the inspection data into the inspection form, and generating a quality inspection report based on the inspection form.

[0029] Figure 2 for Figure 1 Another flow chart of the embodiment shown. Figure 1 and Figure 2 It can be understood that in this embodiment, before the product is inspected, when the product is purchased and put into storage, the basic information of the product is entered to form a purchase storage order, and a purchase storage QR code label is generated, and the purchase storage QR code label is affixed to the product. Then, in the production stage of the product, relevant information is entered to form a production tracking order, and a production tracking QR code label is generated, and the production tracking QR code label is affixed to the product. The inspection personnel (i.e. Figure 2 The quality inspector in the system then uses a code scanning device to scan the purchase and warehousing QR code label and the production tracking QR code label. The database identifies the product and generates an inspection form based on the preset inspection template. By equipping the product with a unique QR code label, the system can easily track the information of each link of the product, such as procurement, warehousing, production and quality inspection, which helps to ensure the safety and reliability of the product and improve the efficiency of subsequent inspections.

[0030] After the inspection form is generated, the inspection items corresponding to the product are set on the inspection form, and the inspection items are stored in the data table. The inspection items may include the name, specification, quantity, length and width of the product. It should be noted here that the database is an organized data collection used to store and manage related data. The data table is an object in the database, which is used to store data records with the same structure. The data table supports operations such as addition, deletion, modification and query, and is the carrier for actual storage and management of data.

[0031] After the inspection items are stored, an inspection plan group is configured for the product. The inspection plan group is set with inspection plans corresponding to the products one by one, and the inspection plan group is stored through a data table. The data table has data table rows and data table columns. When the data table stores inspection items, the data table rows are used to store inspection items that all products have that exceed the preset ratio, and the data table columns are used to store the remaining inspection items. When the data table stores inspection plan groups, the data table rows are used to store inspection plan groups corresponding to the preset ratio of products, and the data table columns are used to store the remaining inspection plan groups. The design of the data table reserves enough space to accommodate inspection items and plans that may be added in the future. This scalability ensures that the system can be flexibly adjusted as business needs change.

[0032] After the inspection data is entered into the inspection form, the inspection data is stored as historical data. After the inspection plan group is configured for the product, when the corresponding inspection plan is configured for each product, the inspection plan is selected or inferred for the product based on the historical data. When selecting or inferring the inspection plan for the product based on the historical data, a high-relevance inspection plan that meets the high-relevance conditions is selected from the historical data, and the inspection plan for the product is inferred or selected based on the high-relevance inspection plan. The high-relevance conditions at least include: the closest distance to the production date of the product, the same product name, the same product specifications, the same target customers as the product, and the same supplier as the product. By comprehensively considering multiple relevance conditions, the system can more accurately match the appropriate inspection plan for the new product. This precise matching helps to ensure the accuracy and effectiveness of the quality inspection results.

[0033] After selecting the corresponding inspection plan for each product, the inspection items are inspected through the inspection plan to obtain the inspection data, and the inspection data is entered and saved in the inspection form, and finally the quality inspection report is generated according to the inspection form. It should be noted that after the inspection data is entered and saved in the inspection form, the inspection form is selected through full inspection or screening, and the quality inspection report is generated according to the selected inspection form through the quality inspection report generation algorithm. Here, an example is used to illustrate the quality inspection report generation algorithm. Assuming that the inspection form has the inspection item "length", the values ​​of the inspection item "length" in multiple inspection forms (that is, the product is inspected multiple times) are saved, and the average value of "length" is calculated or the "length" is calculated by other more appropriate mathematical calculation methods. The whole process is highly automated, which not only reduces the links of manual intervention, but also significantly improves the efficiency and accuracy of quality inspection work.

[0034] Figure 3 This is a schematic block diagram of an embodiment of a quality inspection system of the present application, which uses the aforementioned product quality inspection method. Figure 3 It can be seen that the quality inspection system can include a purchase warehouse order acquisition module 1, a production tracking order acquisition module 2, an inspection order module 3, an inspection plan module 4, a historical data module 5 and a quality inspection report module 6. The inspection order module 3 is connected to the purchase warehouse order acquisition module 1, the production tracking order acquisition module 2 and the inspection plan module 4 respectively. The inspection plan module 4 is connected to the historical data module 5 and the quality inspection report module 6 respectively. The purchase warehouse order acquisition module 1 is used to obtain the purchase warehouse order acquisition module 1, the production tracking order acquisition module 2 is used to obtain the production tracking order, the inspection order module 3 is used to generate the inspection order according to the purchase warehouse QR code label and the production tracking QR code label, the inspection plan module 4 is used to configure the inspection plan group, the historical data module 5 is used to select the inspection plan for the product, and the quality inspection report module 6 is used to generate the quality inspection report. The seamless integration between the functional modules ensures the consistency and efficiency of the quality inspection process.

[0035] The present application also provides a storage medium, which stores at least one instruction, at least one program, code set or instruction set, and the at least one instruction, at least one program, code set or instruction set is loaded and executed by a processor to implement the above-mentioned product quality detection method.

[0036] Among them, the storage medium can be a computer storage medium or a communication medium. The communication medium includes any medium that facilitates the transmission of a computer program from one place to another. The computer storage medium can be any available medium that can be accessed by a general-purpose or special-purpose computer. For example, the storage medium is coupled to the processor so that the processor can read information from the storage medium and write information to the storage medium. Of course, the storage medium can also be a component of the processor. The processor and the storage medium can be located in an application-specific integrated circuit (Application Specific Integrated Circuits, abbreviated as: ASIC). In addition, the ASIC can be located in a user device. Of course, the processor and the storage medium can also exist in a communication device as discrete components. The storage medium can be a read-only memory (ROM), a random access memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, and an optical data storage device, etc.

[0037] The above are all preferred embodiments of the present application, and the protection scope of the present application is not limited thereto. Therefore, any equivalent changes made according to the structure, shape, and principle of the present application should be included in the protection scope of the present application.

Claims

1. A product quality detection method, characterized in that ,The quality detection method comprises the following steps: Setting inspection items corresponding to the product on the inspection sheet and storing the inspection items in a data table, An inspection scheme group is configured for the product, wherein the inspection scheme group is provided with the inspection schemes corresponding to the products one by one, and the inspection scheme group is stored in the data table, The inspection items are inspected by the inspection plan to obtain inspection data. The inspection data is entered and saved into the inspection form, and a quality inspection report is generated based on the inspection form.

2. The product quality detection method according to claim 1, characterized in that: The data table has data table rows and data table columns, When the data table stores the inspection items, the inspection items that all products have that exceed a preset ratio are stored in the data table rows, and the remaining inspection items are stored in the data table columns. When the data table stores the inspection scheme groups, the inspection scheme groups corresponding to the products of the preset ratio are stored through the data table rows, and the remaining inspection scheme groups are stored through the data table columns.

3. The product quality detection method according to claim 1 or 2, characterized in that: After the inspection data is entered and saved in the inspection sheet, the inspection data is stored as historical data, and after the inspection plan group is configured for the product, the inspection plan is selected or calculated for the product based on the historical data.

4. The product quality detection method according to claim 3, characterized in that: When selecting or calculating the inspection plan for the product based on the historical data, a high-correlation inspection plan that meets the high-correlation conditions is selected from the historical data, and the inspection plan for the product is calculated or selected based on the high-correlation inspection plan, and the high-correlation conditions at least include: the closest distance to the production date of the product, the same name as the product, the same specifications as the product, the same target customers as the product, and the same supplier as the product.

5. The product quality detection method according to claim 1 or 2, characterized in that: In the quality inspection method, the inspection list is selected through full inspection or screening, and the quality inspection report is generated according to the inspection list through a quality inspection report generation algorithm.

6. The product quality detection method according to claim 5, characterized in that: Before inspecting the product, When the product is purchased and put into storage, the basic information of the product is entered and saved, and a purchase and storage QR code label is generated, and the purchase and storage QR code label is attached to the product. During the production phase of the product, relevant information is input and saved, and a production tracking QR code label is generated, and the production tracking QR code label is affixed to the product. The inspection personnel use a code scanning device to scan the purchase warehousing QR code label and the production tracking QR code label, the database identifies the product, and generates the inspection sheet based on a preset inspection template.

7. A quality inspection system using the product quality inspection method according to claim 1, characterized in that: The quality inspection system includes a purchase order acquisition module, a production tracking order acquisition module, an inspection order module, an inspection plan module, a historical data module and a quality inspection report module. The inspection form module is respectively connected to the purchase warehouse form acquisition module, the production tracking form acquisition module and the inspection plan module, and the inspection plan module is respectively connected to the historical data module and the quality inspection report module. The purchase receipt acquisition module is used to acquire the purchase receipt acquisition module, the production tracking order acquisition module is used to acquire the production tracking order, the inspection order module is used to generate the inspection order according to the purchase receipt QR code label and the production tracking QR code label, the inspection plan module is used to configure the inspection plan group, the historical data module is used to select the inspection plan for the product, and the quality inspection report module is used to generate the quality inspection report.

8. A storage medium, characterized in that: The storage medium stores at least one instruction, at least one program, a code set or an instruction set, and the at least one instruction, the at least one program, the code set or the instruction set is loaded and executed by the processor to implement the product quality detection method as described in claim 1.

Images