Method and system for automatically classifying, auditing and uploading steel product quality guarantee book

Abstract

The invention provides a method and system for automatically classifying, auditing and uploading steel product warranty books, and belongs to the technical field of product quality management, and the method comprises the steps: building and storing a warranty book manual auditing and uploading rule maintenance base table; after the material warranty book is generated and the pre-examination is qualified, judging whether a material ordering standard code in the material warranty book is in the base table or not; when the material ordering standard code is maintained in the base table, outputting a prompt that the warranty book needs to be manually audited, waiting for receiving an audit result of manual audit, and uploading and publishing the warranty book after the audit result of manual audit is obtained; and when the material ordering standard code is not maintained in the base table, automatic auditing is carried out, and the warranty book is uploaded and published after the auditing is passed. According to the invention, related functions of an existing quality system are optimized, the preset rules are added by considering factors such as supply stability and user loyalty, and whether the product warranty book needs to be uploaded after manual auditing is automatically judged, so that the conformity of the warranty book is ensured, and manpower is liberated to the maximum extent.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of quality management, in particular to a method and system for automatically classifying, auditing and uploading a steel product quality guarantee book. BACKGROUND

[0002] The steel product quality guarantee book, as a quality commitment document provided by a steel production enterprise to users, plays a key role in product quality control and market transactions. The quality guarantee book records key quality data such as product chemical composition and mechanical properties, and its accuracy is directly related to the traceability of product quality and the trust of users. With the development of information technology, the quality guarantee book has gradually changed from the traditional paper form to electronic and automated direction.

[0003] Currently, there are two technical solutions for steel industry quality guarantee book auditing: the first is to rely completely on system automatic auditing. Although this method is efficient, it can only check numerical quality data and cannot ensure the accuracy of non-structured information such as quality guarantee book format and text description, which may lead to non-compliant quality guarantee books flowing into the market. The second is to add manual review on the basis of system automatic auditing. Although this method can significantly reduce the error rate, continuous manual auditing will waste human resources for users or standardized products that have established stable cooperative relationships.

[0004] In the prior art, patent CN113688344A discloses a method for publishing an electronic quality guarantee book file based on quality management, which realizes electronic management and centralized backup of the quality guarantee book, but does not solve the efficiency problem of the auditing link; patent CN114036536A discloses a method for issuing a ship steel plate quality guarantee book, which proposes a forgery-proof issuing scheme for the quality guarantee book, but does not consider the differentiated auditing needs of different users and products; and patent CN102930426A discloses a steel product quality guarantee book automatic generation system and method, which realizes automatic generation of the quality guarantee book, but lacks an intelligent judgment mechanism for the auditing link. These prior arts focus on information collection, automatic generation of the steel product quality guarantee book, and transmission and publication of the quality guarantee book file, and do not involve the details of the quality guarantee book auditing, which cannot effectively balance the relationship between auditing accuracy and labor cost, especially when handling orders for users with stable cooperative relationships, unnecessary manual auditing resources are still required. SUMMARY

[0005] Therefore, the present application provides a method and system for automatically classifying, auditing and uploading a steel product quality guarantee book, which optimizes the related functions of the existing quality system, considers factors such as stability of supply and user loyalty to increase preset rules, and automatically determines by the system whether the product quality guarantee book needs manual auditing before uploading, so as to ensure compliance of the quality guarantee book and maximize the liberation of human resources.

[0006] Therefore, the present invention provides the following technical solution: On the one hand, this invention provides a method for automatically classifying, reviewing, and uploading quality assurance certificates for steel products, including the following steps: Establish and store a base table for maintaining the rules for manual review of quality assurance certificates. The base table includes standard codes, standard text, standard text descriptions, and fields for key points of focus during manual review. After the material quality assurance certificate is generated and pre-approved, determine whether the material ordering standard code in the material quality assurance certificate is in the base table; When the material ordering standard code is maintained in the base table, a prompt will be output indicating that the quality assurance certificate needs to be manually reviewed, and the review result will be received. After the manual review is approved, the quality assurance certificate will be uploaded and published. When the material ordering standard code is not maintained in the base table, it will be automatically reviewed, and the quality assurance certificate will be uploaded and published after the review is approved.

[0007] Furthermore, the standard code is the primary key of the base table and duplicates are not allowed.

[0008] Furthermore, automatic review includes reviewing the standard text in the base table.

[0009] Furthermore, the method also includes dynamically adjusting the standard codes in the base table based on the stability of user cooperation and the degree of product standardization.

[0010] Furthermore, the standard codes in the base table are dynamically adjusted based on user cooperation stability and product standardization, including: Obtain users' historical cooperation data and calculate users' cooperation stability score; Obtain historical product quality data and calculate the product standardization score; Based on the user cooperation stability score and the product standardization score, the corresponding standard code is removed from the base table or added to the base table.

[0011] Furthermore, the method also includes: periodically analyzing the differences between manual review results and automatic review results, and dynamically adjusting the standard code maintenance strategy in the base table.

[0012] Furthermore, after prompting that the quality assurance certificate requires manual review, the system also includes: pushing the key points for manual review corresponding to the standard codes in the base table to the reviewers.

[0013] Furthermore, after receiving the audit result that the manual review failed, the warranty certificate is modified and regenerated.

[0014] In another aspect, the present invention also provides a system for automatically classifying, reviewing, and uploading quality assurance certificates for steel products, comprising: The base table maintenance unit is used to establish and store the base table for maintaining the manual review and upload rules of the quality assurance certificate. The base table includes standard code, standard text, standard text description and fields for key content to be focused on during manual review. The logic judgment unit is used to determine whether the material ordering standard code in the material quality assurance certificate is in the base table maintained by the base table maintenance unit after the material quality assurance certificate is generated. The manual review unit is used to output a prompt that the quality assurance certificate needs to be manually reviewed when the logic judgment unit determines that the material ordering standard code is maintained in the base table, and wait to receive the review result of the manual review. After receiving the review result of the manual review, the quality assurance certificate is uploaded and published. The automatic review unit is used to automatically review the material ordering standard code when the logic judgment unit determines that it is not maintained in the base table, and upload and publish the quality assurance certificate after the review is passed.

[0015] In another aspect, the present invention also provides a quality system, including: a quality assurance certificate management module, a quality assurance certificate generation module, and a quality assurance certificate review module. The quality assurance certificate management module is connected to the quality assurance certificate management module and the quality assurance certificate generation module, respectively. The quality assurance certificate management module includes the aforementioned base table maintenance unit. The quality assurance certificate review module includes the aforementioned logical judgment unit, manual review unit, and automatic review unit.

[0016] The above technical solution achieves intelligent classification and review of steel product quality assurance certificates by establishing a base table for maintaining manual review and upload rules. Its advantages are as follows: Since the base table maintains the correspondence between standard codes and manual review rules, when the system detects that a standard code for a quality assurance certificate exists in the base table, it automatically triggers the manual review process, ensuring the accuracy of reviewing high-risk quality assurance certificates. For standard codes not maintained in the base table, an automatic review process is used, thereby reducing unnecessary manual reviews for stable cooperative users and standardized products, and improving overall review efficiency. Furthermore, by dynamically adjusting the standard code maintenance strategy in the base table, this invention can automatically optimize the allocation of review resources based on changes in user cooperation stability and product standardization, significantly reducing manual review costs while ensuring the quality of quality assurance certificates. Attached Figure Description

[0017] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0018] Figure 1 This is a flowchart illustrating a method for automatically classifying, reviewing, and uploading quality assurance certificates for steel products according to an embodiment of the present invention; Figure 2 This is a schematic diagram of the interface for maintaining the base table of manual review and upload rules for quality assurance certificates in an embodiment of the present invention; Figure 3 This is a system structure diagram of an embodiment of the present invention for automatically classifying, reviewing, and uploading quality assurance certificates for steel products. Detailed Implementation

[0019] To enable those skilled in the art to better understand the present invention, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of the present invention.

[0020] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this invention are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of the invention described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover a non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.

[0021] like Figure 1 As shown in the figure, a method for automatically classifying, reviewing, and uploading quality assurance certificates for steel products in an embodiment of the present invention specifically includes the following steps: S1. Establish and store the maintenance base table for the manual review and upload rules of quality assurance certificates; Among them, such as Figure 2As shown, the base table includes standard codes, standard text, standard text descriptions, and fields for key points of manual review. The standard code is the primary key of the base table and cannot be duplicated. The standard code is a unique identifier for the technical standards / quality specifications followed by steel products, such as: international standards (e.g., ISO 630:2021 "Structural Steel"), national standards (e.g., GB / T 700 "Carbon Structural Steel"), industry standards (e.g., YB / T 4159 "High-Strength Cold-Rolled Steel Plate for Automobiles"), and enterprise-defined standards (e.g., a steel mill's special process product standards). The maintenance status of the standard code (whether manual review is required) will be dynamically adjusted based on the following factors: user cooperation stability (e.g., years of cooperation, complaint rate), and product standardization degree (e.g., quality data volatility). The system determines whether to proceed with manual or automatic review by matching the material ordering standard code in the quality assurance certificate with the standard code in the base table. The standard text is used to store the digitized full text or core clauses of the standard document. This provides a basis for automated auditing, such as: allowable ranges for numerical parameters (e.g., tensile strength ≥370MPa), lists of mandatory inspection items (e.g., chemical composition, mechanical properties), etc. The standard text description is a human-readable summary of the standard text, using natural language to describe key requirements, assisting human auditors in quickly understanding the standard's key points and generating quality assurance certificate completion guidelines (e.g., prompts to "specify heat treatment status"), etc. Human audits focus on high-risk audit items corresponding to the structured storage of the standard code within the content. When a standard code is marked as requiring human review, the system automatically prompts auditors to focus on checking these contents.

[0022] In practical implementation, the standard codes in the base table can be dynamically adjusted based on user cooperation stability and product standardization. Specifically, historical user cooperation data is obtained to calculate a user cooperation stability score; historical product quality data is obtained to calculate a product standardization score; based on the user cooperation stability score and the product standardization score, the corresponding standard codes are removed from or added to the base table. The calculation of the user cooperation stability score includes at least one of the following factors: user cooperation duration; historical order fulfillment rate; historical number of quality complaints; historical warranty certificate approval rate. The calculation of the product standardization score includes at least one of the following factors: product manufacturing process maturity; historical quality data volatility; historical warranty certificate automatic approval rate; product standard change frequency.

[0023] S2. After the material quality assurance certificate is generated and pre-approved, determine whether the material ordering standard code in the material quality assurance certificate is in the base table; S3. When the material ordering standard code is maintained in the base table, output a prompt that the quality assurance certificate needs to be manually reviewed, and wait to receive the review result. After receiving the review result that the manual review is passed, upload and publish the quality assurance certificate; after receiving the review result that the manual review is not passed, modify the quality assurance certificate and regenerate the quality assurance certificate.

[0024] The prompt indicating that the output quality assurance certificate requires manual review also includes: pushing the key points for manual review corresponding to the standard codes in the base table to the reviewers.

[0025] S4. When the material ordering standard code is not maintained in the base table, it will be automatically reviewed, and the quality assurance certificate will be uploaded and published after the review is approved.

[0026] The automatic review includes: the system automatically reviews the text according to the standard text in the base table.

[0027] In the above embodiments, by establishing a base table for maintaining manual review and upload rules for quality assurance certificates, intelligent classification and review of steel product quality assurance certificates are achieved. Since the base table maintains the correspondence between standard codes and manual review rules, when the system detects that a standard code for a quality assurance certificate exists in the base table, it automatically triggers the manual review process, ensuring the accuracy of reviewing high-risk quality assurance certificates. For standard codes not maintained in the base table, an automatic review process is used, thereby reducing unnecessary manual review for stable cooperative users and standardized products, and improving overall review efficiency. Simultaneously, by dynamically adjusting the standard code maintenance strategy in the base table, this invention can automatically optimize the allocation of review resources based on changes in user cooperation stability and product standardization, significantly reducing manual review costs while ensuring the quality of quality assurance certificates.

[0028] In another embodiment, the above method further includes: S5, periodically analyzing the differences between manual review results and automatic review results, and dynamically adjusting the standard code maintenance strategy in the base table.

[0029] In another embodiment, corresponding to the method described above, such as Figure 3 As shown, a system for automatically classifying, reviewing, and uploading quality assurance certificates for steel products includes: The base table maintenance unit 100 is used to establish and store the base table for maintaining the rules for manual review and upload of quality assurance certificates. The base table includes standard code, standard text, standard text description, and fields for key content to be focused on during manual review. The logic judgment unit 200 is used to determine whether the material ordering standard code in the material quality assurance document is in the base table maintained by the base table maintenance unit 100 after the material quality assurance document is generated. The manual review unit 300 is used to output a prompt that the quality assurance certificate needs to be manually reviewed when the logic judgment unit 200 determines that the material ordering standard code is maintained in the base table, and wait to receive the review result of the manual review. After obtaining the review result of the manual review, the quality assurance certificate is uploaded and published. The automatic review unit 400 is used to automatically review the material ordering standard code when the logic judgment unit 200 determines that it is not maintained in the base table, and upload and publish the quality assurance certificate after the review is passed.

[0030] In another embodiment, a quality system, based on an existing quality system, adds a base table called "Maintenance of Manual Review and Upload Rules for Quality Assurance Certificates" to the quality assurance certificate management module. This table contains four fields: standard code, standard text, standard text description, and key points for manual review. The standard code is the primary key and cannot be duplicated. The quality system also adds processing logic after the material quality assurance certificate is generated. That is, if the material ordering standard code is maintained in the "Maintenance of Manual Review and Upload Rules for Quality Assurance Certificates" table, the quality assurance certificate must be manually reviewed and approved before it can be uploaded and published. Otherwise, the quality system defaults to automatically uploading and publishing the material quality assurance certificate after it is generated and approved by the system.

[0031] In the above embodiments, the relevant functions of the existing quality system are optimized. Considering factors such as supply stability and user loyalty, preset rules are added so that the system can automatically determine whether the product warranty certificate needs to be manually reviewed before being uploaded, so as to ensure the compliance of the warranty certificate and maximize the liberation of manpower.

[0032] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some or all of the technical features; and these modifications or substitutions 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.

Claims

1. A method for automatically classifying, reviewing, and uploading quality assurance certificates for steel products, characterized in that, The method comprises the following steps: A quality guarantee book artificial review upload rule maintenance base table is established and stored, and the base table comprises a standard code, a standard text, a standard text description, and an artificial review focus content field; After the material quality guarantee book is generated and pre-audited, it is determined whether the material order standard code in the material quality guarantee book is in the base table; When the material order standard code is maintained in the base table, a prompt that the quality guarantee book needs to be reviewed by an artificial is output, and an artificial review result is received, and after a passed artificial review result is obtained, the quality guarantee book is uploaded and published; When the material order standard code is not maintained in the base table, automatic review is performed, and after the review is passed, the quality guarantee book is uploaded and published.

2. The method of claim 1, wherein, The standard code is the primary key of the base table, and is not allowed to be repeated.

3. The method of claim 1, wherein, The artificial review focus content comprises accuracy verification of the quality guarantee book format, word description, and unstructured information.

4. The method of claim 1, wherein, Automatic review comprises: auditing according to the standard text in the base table.

5. The method of claim 4, wherein, The standard code in the base table is dynamically adjusted according to user cooperation stability and product standardization degree, comprising: User historical cooperation data is obtained, and a user cooperation stability score is calculated; Product historical quality data is obtained, and a product standardization degree score is calculated; Based on the user cooperation stability score and the product standardization degree score, the corresponding standard code is removed from the base table or added to the base table.

6. The method of claim 1, wherein, The method further comprises: periodically analyzing the difference between the artificial review result and the automatic review result, and dynamically adjusting the standard code maintenance strategy in the base table.

7. The method of claim 1, wherein, After the prompt that the quality guarantee book needs to be reviewed by an artificial is output, the artificial review focus content corresponding to the standard code in the base table is pushed to the reviewer.

8. The method of claim 1, wherein, After a failed artificial review result is obtained, the quality guarantee book is modified and a new quality guarantee book is generated.

9. A system for automatically classifying, reviewing, and uploading quality assurance certificates for steel products, characterized in that, Comprise: A base table maintenance unit is configured to establish and store a quality guarantee book artificial review upload rule maintenance base table, and the base table comprises a standard code, a standard text, a standard text description, and an artificial review focus content field; A logical judgment unit is configured to determine whether a material order standard code in a material quality guarantee book is in the base table maintained by the base table maintenance unit after the material quality guarantee book is generated; An artificial review unit is configured to output a prompt that the quality guarantee book needs to be reviewed by an artificial when the logical judgment unit determines that the material order standard code is maintained in the base table, and to receive an artificial review result, and to upload and publish the quality guarantee book after a passed artificial review result is obtained; An automatic review unit is configured to automatically review when the logical judgment unit determines that the material order standard code is not maintained in the base table, and to upload and publish the quality guarantee book after the review is passed.

10. A mass system characterized by, Comprise: A quality guarantee book management module, a quality guarantee book generation module, and a quality guarantee book review module, the quality guarantee book management module is connected with the quality guarantee book management module and the quality guarantee book generation module, and the quality guarantee book management module comprises the base table maintenance unit of claim 9; the quality guarantee book review module comprises the logical judgment unit, the artificial review unit, and the automatic review unit of claim 9.

Images