Material configuration sheet auditing method, system and equipment and storage medium

Abstract

The invention provides a material configuration list auditing method, system and device and a storage medium, and particularly relates to the technical field of material configuration list auditing, and the method comprises the steps that a material configuration list automatic auditing system obtains a material configuration list auditing rule; obtaining a material configuration list; if the material code and the material configuration information do not conform to the material configuration list auditing rule, selecting first mismatching information; recording the first mismatching information, and generating an auditing log; and obtaining a first modification scheme fed back by the business personnel after analyzing the auditing log. According to the method, the material configuration list auditing efficiency is improved, the material configuration list auditing accuracy is ensured, the material configuration auditing rule making flexibility is improved, and the material configuration auditing rule generation error rate is reduced.

Description

Technical Field

[0001] The present application relates to the technical field of material configuration list review, and in particular to a material configuration list review method, system, device and storage medium. Background Art

[0002] As the number of product types and materials increases, it is easy to miss materials, make wrong quantities, or fail to meet business rules when manually configuring materials. Such problems often lead to delays in subsequent production planning and stocking, reducing overall efficiency.

[0003] The existing material configuration list review work usually relies on programmers to hard-code rules in the code, resulting in poor system flexibility, difficulty in generating and modifying review rules, and business personnel being unable to independently adjust review rules according to changes in business needs. In this mode, the system maintenance cost is high, and the response speed of review rule updates is slow, which cannot meet rapidly changing business needs.

[0004] Therefore, the lack of flexibility in generating and modifying audit rules in a hard-coded form is an issue that needs to be addressed urgently. Summary of the invention

[0005] In view of this, the purpose of this application is to provide a material configuration list review method, system, device and storage medium to solve the above-mentioned problems, realize the flexible generation and modification of review rules, and complete the automatic review function of the material configuration list by the material configuration list automatic review system.

[0006] In a first aspect, an embodiment of the present application provides a material configuration list review method, which is applied to a material configuration list automatic review system, and the method includes: Obtaining a material configuration list review rule; wherein the material configuration list review rule is used to characterize a mapping relationship between a reference material code and reference material configuration information; Obtain a material configuration list; wherein the material configuration list includes: a material code and material configuration information; If the material code and the material configuration information do not conform to the material configuration list review rules, the first mismatching information is selected; wherein the first mismatching information is the material configuration information corresponding to the material code in the material configuration list that does not conform to the material configuration list review rules; Recording the first mismatch information and generating an audit log; Obtaining a first modification plan fed back by a business person analyzing the audit log, wherein the first modification plan is a material configuration list after modifying the first mismatching information; If the material code and the material configuration information meet the material configuration sheet review rules, an audit pass mark is generated.

[0007] Preferably, the method further comprises: According to the material configuration list, materials that meet the material code and the material configuration information are obtained.

[0008] Preferably, the method further comprises: Acquire a test material configuration list review rule; wherein the test material configuration list review rule is used to characterize the mapping relationship between the reference test material code and the reference test material configuration information; Obtain a test material configuration list; wherein the test material configuration list includes: a test material code and test material configuration information; If the test material code and the test material configuration information do not comply with the test material configuration sheet review rules, then select the second non-matching information; wherein the second non-matching information is the part of the test material configuration information corresponding to the test material code that does not comply with the test material configuration sheet review rules; Recording the second mismatch information and generating a test log; A second modification plan fed back by the business personnel through analysis of the test log is obtained: wherein the second modification plan is a test material configuration sheet review rule after modifying the second mismatching information.

[0009] Preferably, the method further comprises: If the test material code and the test material configuration information meet the test material configuration sheet review rules, a test pass mark is generated.

[0010] Preferably, the method further comprises: Count the number of approved material configuration orders and the number of all material configuration orders to obtain pass rate data; The pass rate data is visualized.

[0011] Preferably, the method further comprises: Analyze the test log to generate a test report in a first format; wherein the first format is a text format; The test report in the first format is converted into a format to generate a test report in a second format; wherein the second format is a chart format.

[0012] Preferably, the method further comprises: Analyze the audit log to generate an audit report in the first format; wherein the first format is a text format; The audit report in the first format is converted into a format to generate an audit report in the second format; wherein the second format is a chart format.

[0013] The material configuration list review method provided in this application brings the following beneficial effects: The present application provides a material configuration list audit method, in which the material configuration list automatic audit system determines whether the material code and material configuration information comply with the material configuration list audit rules. If so, the first mismatching information is selected, and the first mismatching information is recorded to generate an audit log. The business personnel analyze the audit log to obtain a first modification plan. This method improves the efficiency of the material configuration list audit, ensures the accuracy of the material configuration list audit, improves the flexibility of the material configuration audit rule formulation, and reduces the error rate of the material configuration audit rule generation.

[0014] In a second aspect, the present application also provides a material configuration sheet automatic review system, the system comprising: a rule configuration module, a configuration sheet configuration module and a rule execution module; The rule configuration module is used to obtain the material configuration list review rule; wherein the material configuration list review rule is used to characterize the mapping relationship between the reference material code and the reference material configuration information; The configuration list configuration module is used to obtain a material configuration list; wherein the material configuration list includes: a material code and material configuration information; The rule execution module is also used to select the first non-matching information if the material code and the material configuration information do not comply with the material configuration list review rules; wherein the first non-matching information is the material configuration information corresponding to the material code in the material configuration list that does not comply with the material configuration list review rules; record the first non-matching information and generate an audit log; obtain the first modification plan fed back by the business personnel after analyzing the audit log: wherein the first modification plan is the material configuration list after modifying the first non-matching information; if the material code and the material configuration information comply with the material configuration list review rules, generate an audit pass mark.

[0015] The material configuration list automatic review system provided in the embodiment of the present application has the same technical features as the material configuration list review method provided in the above embodiment, so it can also solve the same technical problems and achieve the same technical effects.

[0016] In a third aspect, the present application provides a computing device, including a memory and a processor; One or more computer programs are stored in the memory, and the one or more computer programs include instructions; when the instructions are executed by the processor, the computing device executes the method as described in any one of the first aspects.

[0017] In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium is used to store a computer program, and the computer program is used to execute the method as described in any one of the first aspects.

[0018] In a fifth aspect, the present application provides a computer program product, wherein the computer program product comprises one or more computer instructions, and when the computer instructions are executed by a computer, the computer executes the method as described in any one of the first aspects.

[0019] Other features and advantages of the present application will be described in the following description, and partly become apparent from the description, or understood by practicing the present application. The purpose and other advantages of the present application are realized and obtained by the structures particularly pointed out in the description and the drawings.

[0020] In order to make the above-mentioned objects, features and advantages of the present application more obvious and easy to understand, preferred embodiments are specifically cited below and described in detail with reference to the attached drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] In order to more clearly illustrate the specific implementation methods of the present application or the technical solutions in the prior art, the drawings required for use in the specific implementation methods or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some implementation methods of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0022] Figure 1 A schematic diagram of a material configuration list review method provided in an embodiment of the present application; Figure 2 A schematic diagram of the structure of a material configuration list automatic review system provided in an embodiment of the present application; Figure 3 A schematic diagram of a computing device provided in an embodiment of the present application. DETAILED DESCRIPTION

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

[0024] To facilitate understanding of this embodiment, the embodiments of the present application are described in detail below.

[0025] The present application embodiment provides a material configuration list review method, which is applied to a material configuration list automatic review system, such as Figure 1 As shown, Figure 1 A schematic diagram of a material configuration list review method provided in an embodiment of the present application. The method comprises the following steps: S101, the material configuration list automatic review system obtains the material configuration list review rules.

[0026] Among them, the material configuration list review rule is used to characterize the mapping relationship between the reference material code and the reference material configuration information.

[0027] Specifically, the above-mentioned material configuration list automatic review system uses the open source Drools rule engine as the material configuration list review rule management engine based on the Odoo low-code platform. The Odoo low-code platform is an open source ERP (Enterprise Resource Planning) platform that supports low-code development mode and provides a highly modular architecture. Developers can use the Odoo low-code platform to quickly build custom modules and seamlessly integrate them with the existing modules of the material configuration list automatic review system. Through the ORM (Object-Relational Mapping) framework of the Odoo low-code platform, the material configuration list automatic review system can directly associate the execution results of the material configuration list review rules imported into the Odoo low-code platform with the materials and order information in the database to ensure data consistency and real-time performance.

[0028] Drools is an open source Java-based BRMS (Business Rules Management System) that provides powerful rule definition and execution capabilities. It supports the definition of complex business logic through if and then conditional statements, and can quickly judge and process complex business scenarios such as material configuration, quantity, and associated conditions.

[0029] The use of the Drools rule engine separates rules from code and enables dynamic adjustment of material configuration list audit rules without restarting the system or making code modifications, thereby improving the flexibility and scalability of the system. The Drools rule engine allows business personnel to write complex audit logic in natural language. This visual rule configuration interface allows non-technical personnel to participate in the configuration and management of rules, reducing the burden on developers. The Drools rule engine supports controlling the execution order of material configuration list audit rules through rule flows, and can also combine more reasoning mechanisms to make the judgment process of material configuration list audit rules more accurate and flexible.

[0030] Business personnel can input the above-mentioned material configuration list review rules into the material configuration list automatic review system through Excel tables. In order to process the material configuration list review rules in the Excel table, the system uses the Pandas database, which is a powerful data analysis and processing library in Python. The Pandas database can efficiently process structured data and supports interaction with files in various formats such as Excel tables, ensuring that the material configuration review system can quickly and accurately read and write the material configuration list review rules. The process of the Pandas database processing the imported material configuration list review rules includes: reading the Excel table, parsing the material configuration list review rules in the table, and performing data cleaning and format conversion on the material configuration list review rules. The material configuration review system converts the material configuration list review rules in the Excel table into a format that can be processed by the Drools rule engine through the Pandas database, and verifies the correctness of the material configuration list review rules when the material configuration list review rules are imported to prevent incorrect configuration.

[0031] Python is one of the main development languages ​​of the material configuration review system, and is widely used in the import and processing of material configuration list review rules, and backend services. Python is combined with the Pandas database to read the material configuration list review rules from Excel tables, and integrates with the Odoo low-code platform to parse, verify, and store the material configuration list review rules. In addition, Python is also used to schedule and manage the call of the backend Drools rule engine.

[0032] The material configuration list automatic review system supports batch import and export of material configuration list review rules, and also supports single import and export of material configuration review rules. In order to facilitate the material configuration review rules, each material configuration review rule is set with a unique label. Since the Odoo low-code platform also supports a variety of user interface components, such as Tree view and Kanban view, it is convenient for business personnel to browse, configure and manage material configuration list review rules.

[0033] With this setting, business personnel do not need to manually input the material configuration list review rules into the material configuration list automatic review system through cumbersome command line operations, which saves time, improves work efficiency, and reduces the probability of errors in the material configuration list review rules caused by command line input errors.

[0034] S102, the material configuration list automatic review system obtains the material configuration list.

[0035] Among them, the material configuration list includes: material code and material configuration information.

[0036] Specifically, the material configuration information includes the material description, material name, single set quantity of the material, total number of materials and special instructions for the material. The following takes a type A server as an example. For example, the material configuration list of a type A server includes server chassis-690000001-server-12*3.5-inch hard disk pass-through chassis-24 / 32C-1-1. Among them, server chassis is the material name, 690000001 is the material code, server 12*3.5-inch hard disk pass-through chassis-24 / 32C is the material description, -1-1 means that the single set quantity of the material is 1, and the total number of materials is 1, which means that 1 type A server needs to be equipped with 1 12*3.5-inch hard disk pass-through chassis.

[0037] S103, the material configuration list automatic review system determines whether the material code and material configuration information comply with the material configuration list review rules, if so, execute step S107, if not, execute step S104.

[0038] Specifically, by comparing the material code and material configuration information with the material configuration list review rules, it is possible to determine whether the correspondence between the material code and material configuration information in the material configuration list is correct, and then determine whether the material configuration list can proceed to the next quotation operation.

[0039] S104, the material configuration list automatic review system selects the first unmatched information.

[0040] The first mismatched information is the material configuration information corresponding to the material code in the material configuration list that does not comply with the material configuration list review rules.

[0041] Specifically, if the material configuration information corresponding to the material code in the material configuration list does not comply with the material configuration list review rules, it indicates whether the correspondence between the material code and the material configuration information in the material configuration list is incorrect. For example, the correspondence between the material code and the material configuration information in the material configuration list is type A. Server-network card dual 200G-0, and the material configuration list review rule is {network card dual 200G==4}. Since the number of network cards dual 200G in the material configuration list review rule is 4, and the number of network cards dual 200G in the material configuration list is 0, it indicates whether the correspondence between the material code and the material configuration information in the material configuration list is incorrect. In this case, the first mismatching information is selected, and the first mismatching information is that the 200G flexible network card is required, and the quantity is 4. The above material configuration list review rule can also include other operators, such as if, then, and or.

[0042] S105, the material configuration list automatic audit system records the first mismatch information and generates an audit log.

[0043] Specifically, the material configuration list automatic review system uses the PostgreSQL database as the database management system, which is an open source object-relational database that supports complex queries and efficient processing of large data sets. The PostgreSQL database provides powerful data storage, query and transaction processing capabilities for the material configuration list automatic review system. It can be seen that the material configuration list automatic review system stores the audit log through the PostgreSQL database, and business personnel can retrieve the audit log from the PostgreSQL database at any time through simple operations.

[0044] The above audit log describes the content in the first matching information, including the reason why the material configuration information corresponding to the material code does not comply with the material configuration sheet audit rules, for example, the number of expansion cards must not exceed the total number of PIE slots.

[0045] After the Drools rule engine executes the rule judgment, the material configuration list automatic audit system will store the audit results, logs and material configuration information in the PostgreSQL database to ensure data persistence and reliability. In addition, PostgreSQL supports complex SQL queries, allowing the system to quickly and accurately retrieve the required material information and rule matching results from the database.

[0046] With this setting, business personnel can clearly understand whether the material configuration information corresponding to each material code can pass the review. If a material code fails, business personnel can view the audit log and deeply understand the specific reasons for failure, so as to make further adjustments and optimize the material configuration list. It improves the operational efficiency of business personnel, ensures the accuracy of material configuration and the transparency of audit, and helps business personnel quickly locate and solve material configuration problems. In addition, the built-in report generation tool of the Odoo low-code platform helps users easily view and analyze audit logs.

[0047] S106, the material configuration list automatic review system obtains the first modification plan fed back by the business personnel after analyzing the review log.

[0048] Among them, the first modification plan is the material configuration list after modifying the first mismatching information.

[0049] Specifically, the user developed a first modification method by analyzing the audit log. The first modification plan was developed for the correspondence between the erroneous material code and the material configuration information in the material configuration list.

[0050] With this setting, through the analysis of the audit log, the incorrect correspondence between the material code and the material configuration information in the material configuration list can be accurately located and targeted modifications can be made. The generated first modification plan helps to eliminate the problem of data inconsistency and ensure the accuracy of material information. During the modification process, the root cause of the error can be deeply analyzed and corresponding preventive measures (first modification plan) can be taken to avoid the same problem in the material configuration list generated later.

[0051] S107, the material configuration list automatic review system generates a review pass mark.

[0052] Specifically, if the material configuration sheet contains material configuration information corresponding to the material code that meets the material configuration sheet review rules, it means that the correspondence between the material code and the material configuration information in the material configuration sheet is correct. At this time, the material configuration sheet automatic review system will mark the material configuration sheet and generate a review pass indication. Only material configuration sheets with a review pass mark can enter the subsequent quotation process.

[0053] The embodiment of the present application provides a material configuration list audit method, in which the material configuration list automatic audit system determines whether the material code and material configuration information comply with the material configuration list audit rules. If so, the first mismatching information is selected, and the first mismatching information is recorded to generate an audit log. The business personnel analyze the audit log to obtain the first modification plan. Compared with the prior art, which relies on programmers to edit and adjust the material configuration audit rules through code, this method does not require business personnel to edit the material configuration audit rules through complex codes, and the material configuration audit rules can be imported into the material configuration list automatic audit system through Excel tables, which is convenient for backup, sharing or application in other systems. The material configuration list automatic audit system provides the functions of adding, deleting, checking and modifying material configuration audit rules to facilitate business personnel to manage various material configuration audit rules. The method can ensure the flexible use and adjustment of material configuration audit rules. The import function supports batch rule configuration to ensure standardized management and efficient operation and maintenance of rules. Users can edit and update the rules at any time, and adjust the rules through simple interface operations, without relying on programmers to manually modify the code. This mode greatly improves the flexibility of the system and shortens the rule response time. This method improves the efficiency of material configuration list review, ensures the accuracy of material configuration list review, improves the flexibility of material configuration review rule formulation, and reduces the error rate of material configuration review rule generation. In addition, the above-mentioned material configuration list automatic review system uses REST (Representational State Transfer) API (Application Programming Interface) to achieve docking with other external systems (such as quotation systems). Through the REST API, the material configuration list automatic review system can receive material configuration lists from external systems, automatically make judgments based on material configuration review rules, and generate review results. The REST API ensures the interoperability and scalability of the material configuration list automatic review system, and supports data interaction with external systems.

[0054] In one implementation, the material configuration list automatic review system obtains materials that conform to the material code and material configuration information according to the material configuration list.

[0055] Specifically, the material configuration list automatic review system will automatically obtain the material code and the material configuration information corresponding to the material configuration list based on the operator action during the material configuration process. For example, if {chassis 8*2.5}==1and {RAID card-8i}-{RAID card-9560-8i}>0, then 302-000857, {RAID card}*2 is obtained.

[0056] In this way, the material configuration list automatic review system can automatically obtain the material corresponding to the material code and material configuration information, saving manpower and avoiding the situation where the wrong material is obtained due to human error.

[0057] In one embodiment, a material configuration sheet automatic review system obtains a test material configuration sheet review rule; wherein the test material configuration sheet review rule is used to characterize the mapping relationship between a reference test material code and reference test material configuration information; obtains a test material configuration sheet; wherein the test material configuration sheet includes: a test material code and a test material configuration information; if the test material code and the test material configuration information do not conform to the test material configuration sheet review rule, then a second non-matching information is selected; wherein the second non-matching information is the portion of the test material configuration information corresponding to the non-compliant test material code in the test material configuration sheet review rule; the second non-matching information is recorded to generate a test log; obtains a second modification plan fed back by business personnel analyzing the test log: wherein the second modification plan is the test material configuration sheet review rule after modifying the second non-matching information, and if the test material code and the test material configuration information conform to the test material configuration sheet review rule, then a test pass mark is generated.

[0058] Specifically, the material configuration list automatic audit system determines whether the test material code and the test material configuration information meet the test material configuration list audit rules. If so, the second mismatching information is selected, and the second mismatching information is recorded to generate a test log. The business personnel analyze the test log to obtain the second modification plan. During the test process, the above-mentioned test material configuration list is set to be accurate, so as a standard for judging whether the test material configuration list audit rules are correct during the test process, if the test material configuration list audit rules meet the standard, it means that the test material configuration list audit rules are correct. Then, the test material configuration list audit rules are saved in the material configuration audit system as the material configuration list audit rules, and a test pass mark is generated. Otherwise, the test material configuration list audit rules are deleted or marked as invalid, and the second mismatching information is recorded to generate a test log. Among them, the test material configuration list audit rules marked as invalid can be reactivated in the subsequent audit process.

[0059] In this way, business personnel can clearly understand whether each test material configuration sheet review rule can pass the test. If a test material configuration sheet review rule fails, business personnel can view the test log and deeply understand the specific reasons for failure, so as to make further adjustments and optimize the test material configuration sheet review rule. It improves the accuracy of the formulation of the test material configuration sheet review rule and ensures the transparency of the review of the test material configuration sheet review rule, helping business personnel to quickly locate and solve the problems in the formulation of the test material configuration sheet review rule.

[0060] In one implementation, the material configuration sheet automatic review system counts the number of material configuration sheets that have passed the review and the number of all material configuration sheets to obtain pass rate data; and visualizes the pass rate data.

[0061] Specifically, after the review of the material configuration list is completed, the material configuration list automatic review system can automatically count the number of material configuration lists that have passed the review, the number of material configuration lists that have not passed the review, and the number of all material configuration lists to obtain the pass rate data, and display the pass rate data on the user interface. Through charts and statistical data, users can intuitively understand the review progress in the material configuration list automatic review system, the number of matches between the material configuration list review rules and the material configuration list, pass rate data and other indicators.

[0062] In this method, the visual display converts the pass rate data into intuitive charts or graphs, allowing users to quickly know the review status of the material configuration list. Through simple visual elements (such as color, size, shape, etc.), users can quickly identify the changing trend of the pass rate data. The visual display provides intuitive data support, and users can make decisions quickly through the visual display of the pass rate data. When abnormal pass rate data is identified, measures can be taken immediately to intervene, thereby improving the review efficiency of the material configuration list.

[0063] In one embodiment, the material configuration list automatic review system analyzes the test log to generate a test report in a first format; wherein the first format is a text format; the test report in the first format is format converted to generate a test report in a second format; wherein the second format is a chart format.

[0064] Specifically, the above-mentioned material configuration list automatic review system is based on the Odoo low-code platform and uses its flexible model, view and controller mechanism to build charts, that is, converting text-formatted test logs into chart-formatted test logs. The MVC (Model-View-Controller) architecture of the Odoo low-code platform allows developers to convert text format into chart format with a small amount of code.

[0065] This method can visually display the test results of the test material configuration list review rules by converting the text-based test log into a chart format, thus improving the readability of the test log. The chart format can clearly present the relationship between the data, which helps testers and developers to better analyze the test results and improve the test material configuration list review rules.

[0066] In one embodiment, the material configuration list automatic audit system analyzes the audit log to generate an audit report in a first format; wherein the first format is a text format; the audit report in the first format is format converted to generate an audit report in a second format; wherein the second format is a chart format.

[0067] Specifically, the above-mentioned material configuration list automatic review system is based on the Odoo low-code platform, which also allows developers to convert text-format audit logs into chart-format audit logs through a small amount of code.

[0068] This method can visually display the audit results of the material configuration list by converting the audit log in text format into a chart format, thereby improving the readability of the audit log. The chart format can clearly present the matching relationship between the material configuration list and the material configuration list audit rules, which helps testers and developers to better analyze the audit results and improve the accuracy of the next material configuration list.

[0069] Based on the above method embodiment, the present application embodiment also provides a material configuration list automatic review system, such as Figure 2 As shown, Figure 2 This is a schematic diagram of the structure of a material configuration list automatic review system provided in an embodiment of the present application. The system includes: a rule configuration module 21, a configuration list configuration module 22 and a rule execution module 23. The functions of each module are as follows: A rule configuration module 21 is used to obtain a material configuration list review rule; wherein the material configuration list review rule is used to characterize a mapping relationship between a reference material code and reference material configuration information; The configuration list configuration module 22 is used to obtain the material configuration list; wherein the material configuration list includes: material code and material configuration information; The rule execution module 23 is also used to select the first non-matching information if the material code and material configuration information do not comply with the material configuration list review rules; wherein the first non-matching information is the material configuration information corresponding to the material code in the material configuration list that does not comply with the material configuration list review rules; the first non-matching information is recorded to generate an audit log; and a first modification plan fed back by the business personnel after analyzing the audit log is obtained: wherein the first modification plan is the material configuration list after modifying the first non-matching information; and if the material code and material configuration information comply with the material configuration list review rules, an audit pass mark is generated.

[0070] Preferably, the rule execution module 23 is also used to obtain materials that meet the material code and material configuration information according to the material configuration list.

[0071] Preferably, the test module (not shown in the figure) is used to obtain the test material configuration list review rule; wherein the test material configuration list review rule is used to characterize the mapping relationship between the reference test material code and the reference test material configuration information; Obtain a test material configuration list; wherein the test material configuration list includes: a test material code and test material configuration information; If the test material code and the test material configuration information do not comply with the test material configuration sheet review rules, the second non-matching information is selected; wherein the second non-matching information is the part of the test material configuration information corresponding to the non-compliant test material code in the test material configuration sheet review rules; Record the second mismatch information and generate a test log; A second modification plan fed back by the business personnel through analysis of the test log is obtained: wherein the second modification plan is a test material configuration sheet review rule after modifying the second mismatching information.

[0072] Preferably, the test module (not shown in the figure) is also used to generate a test pass mark if the test material code and the test material configuration information meet the test material configuration sheet review rules.

[0073] Preferably, a visualization module (not shown in the figure) is used to count the number of material configuration orders that have passed the review and the number of all material configuration orders to obtain pass rate data; The visualization module is also used to visualize the pass rate data.

[0074] Preferably, the visualization module is also used to analyze the test log to generate a test report in a first format; wherein the first format is a text format; and to convert the test report in the first format to generate a test report in a second format; wherein the second format is a chart format.

[0075] Preferably, the visualization module is also used to analyze the audit log to generate an audit report in a first format; wherein the first format is a text format; and to convert the audit report in the first format to generate an audit report in a second format; wherein the second format is a chart format.

[0076] The material configuration list automatic review system provided in the embodiment of the present application has the same technical features as the material configuration list review method provided in the above embodiment, so it can also solve the same technical problems and achieve the same technical effects.

[0077] The present application also provides a computing device. Figure 3As shown, this figure is a schematic diagram of a computing device provided in an embodiment of the present application, and the computing device 400 includes a bus 401, a processor 402, a communication interface 403 and a memory 404. The processor 402, the memory 404 and the communication interface 403 communicate with each other through the bus 401.

[0078] The bus 401 may be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 3 Only one thick line is used in the diagram, but this does not mean that there is only one bus or only one type of bus.

[0079] The processor 402 may be any one or more of a central processing unit (CPU), a graphics processing unit (GPU), a microprocessor (MP), or a digital signal processor (DSP).

[0080] The communication interface 403 is used for communicating with the outside. The memory 404 may include a volatile memory, such as a random access memory (RAM). The memory 404 may also include a non-volatile memory, such as a read-only memory (ROM), a flash memory, a hard disk drive (HDD) or a solid state drive (SSD).

[0081] The memory 404 stores executable codes, and the processor 402 executes the executable codes to perform the aforementioned material configuration list review method.

[0082] The embodiment of the present application also provides a computer-readable storage medium. The computer-readable storage medium can be any available medium that can be stored by a computing device or a data storage device such as a data center containing one or more available media. The available medium can be a magnetic medium (such as a floppy disk, a hard disk, a tape), an optical medium (such as a DVD), or a semiconductor medium (such as a solid-state hard disk). The computer-readable storage medium includes instructions that instruct the computing device to execute the above-mentioned material configuration list review method.

[0083] The embodiment of the present application further provides a computer program product, which includes one or more computer instructions. When the computer instructions are loaded and executed on a computing device, the process or function described in the embodiment of the present application is generated in whole or in part.

[0084] The computer instructions may be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer instructions may be transmitted from one website, computer or data center to another website, computer or data center via wired (e.g., coaxial cable, optical fiber) or wireless (e.g., infrared, wireless, microwave, etc.) means.

[0085] When the computer program product is executed by a computer, the computer executes any of the aforementioned material configuration list review methods. The computer program product may be a software installation package, and when any of the aforementioned material configuration list review methods is needed, the computer program product may be downloaded and executed on a computer.

[0086] The descriptions of the processes or structures corresponding to the above-mentioned figures have different emphases. For parts that are not described in detail in a certain process or structure, please refer to the relevant descriptions of other processes or structures.

[0087] The above description is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any changes or substitutions within the technical scope disclosed in the present application should be included in the protection scope of the present application.

Claims

1. A material configuration list review method, characterized in that: Applied to the material configuration list automatic review system, the method includes: Obtaining a material configuration list review rule; wherein the material configuration list review rule is used to characterize a mapping relationship between a reference material code and reference material configuration information; Obtain a material configuration list; wherein the material configuration list includes: a material code and material configuration information; If the material code and the material configuration information do not conform to the material configuration list review rules, the first mismatching information is selected; wherein the first mismatching information is the material configuration information corresponding to the material code in the material configuration list that does not conform to the material configuration list review rules; Recording the first mismatch information and generating an audit log; Obtaining a first modification plan fed back by a business person analyzing the audit log, wherein the first modification plan is a material configuration list after modifying the first mismatching information; If the material code and the material configuration information meet the material configuration sheet review rules, an audit pass mark is generated.

2. The material configuration list review method according to claim 1, characterized in that: The method further comprises: According to the material configuration list, materials that meet the material code and the material configuration information are obtained.

3. The material configuration list review method according to claim 1, characterized in that: The method further comprises: Acquire a test material configuration list review rule; wherein the test material configuration list review rule is used to characterize the mapping relationship between the reference test material code and the reference test material configuration information; Obtain a test material configuration list; wherein the test material configuration list includes: a test material code and test material configuration information; If the test material code and the test material configuration information do not comply with the test material configuration sheet review rules, then select the second non-matching information; wherein the second non-matching information is the part of the test material configuration information corresponding to the test material code that does not comply with the test material configuration sheet review rules; Recording the second mismatch information and generating a test log; A second modification plan fed back by the business personnel through analysis of the test log is obtained: wherein the second modification plan is a test material configuration sheet review rule after modifying the second mismatching information.

4. The material configuration list review method according to claim 3, characterized in that: The method further comprises: If the test material code and the test material configuration information meet the test material configuration sheet review rules, a test pass mark is generated.

5. The material configuration list review method according to any one of claims 1 to 3, characterized in that: The method further comprises: Count the number of approved material configuration orders and the number of all material configuration orders to obtain pass rate data; The pass rate data is visualized.

6. The material configuration list review method according to claim 5, characterized in that: The method further comprises: Analyze the test log to generate a test report in a first format; wherein the first format is a text format; The test report in the first format is converted into a format to generate a test report in a second format; wherein the second format is a chart format.

7. The material configuration list review method according to claim 5, characterized in that: The method further comprises: Analyze the audit log to generate an audit report in the first format; wherein the first format is a text format; The audit report in the first format is converted into a format to generate an audit report in the second format; wherein the second format is a chart format.

8. A material configuration list automatic review system, characterized in that: The system comprises: a rule configuration module, a configuration sheet configuration module and a rule execution module; The rule configuration module is used to obtain the material configuration list review rule; wherein the material configuration list review rule is used to characterize the mapping relationship between the reference material code and the reference material configuration information; The configuration list configuration module is used to obtain a material configuration list; wherein the material configuration list includes: a material code and material configuration information; The rule execution module is also used to select the first non-matching information if the material code and the material configuration information do not comply with the material configuration list review rules; wherein the first non-matching information is the material configuration information corresponding to the material code in the material configuration list that does not comply with the material configuration list review rules; record the first non-matching information and generate an audit log; obtain the first modification plan fed back by the business personnel after analyzing the audit log: wherein the first modification plan is the material configuration list after modifying the first non-matching information; if the material code and the material configuration information comply with the material configuration list review rules, generate an audit pass mark.

9. A computing device, characterized in that including memory and processor; One or more computer programs are stored in the memory, and the one or more computer programs include instructions; when the instructions are executed by the processor, the computing device executes the method as claimed in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium is used to store a computer program, and the computer program is used to execute the method according to any one of claims 1 to 7.

Images