CN112381496A

CN112381496A - Method and electronic equipment for online automatic review of purchase plan

Info

Publication number: CN112381496A
Application number: CN202011056891.4A
Authority: CN
Inventors: 刘康丽; 李卓伦; 李雪; 皮海营; 彭超; 运晓飞; 李士雷; 张丽君; 郝娟
Original assignee: Materials Branch of State Grid Jibei Electric Power Co Ltd
Current assignee: Materials Branch of State Grid Jibei Electric Power Co Ltd
Priority date: 2020-09-29
Filing date: 2020-09-29
Publication date: 2021-02-19

Abstract

The invention relates to the technical field of material management and control, in particular to an online automatic review method for a purchase plan and electronic equipment, wherein the online automatic review method for the purchase plan is started, and calibration rule parameters are adjusted according to actual conditions; grouping data to be verified according to batches, and respectively performing automatic verification of an examination rule; acquiring batch types and applicable rules according to the batch numbers, and checking the mandatory examination rules one by one; after the compulsory verification rule passes, continuously verifying the non-compulsory rule one by one; after the experts are automatically extracted, the expert examination stage is carried out to obtain calculated indexes, and the material plan management and control are completed. The invention automatically judges and extracts the quantity of the experts required by each professional group of the examination meeting, avoids the possibility of easily making mistakes by manually screening the experts, effectively reduces the workload of expert examination, and can also manually extract and replace according to different professional groups if meeting special conditions after the extraction is finished, thereby doubly ensuring the accuracy of the extracted experts.

Description

Method and electronic equipment for online automatic review of purchase plan

Technical Field

The invention relates to the technical field of material management and control, in particular to an online automatic review method for a purchase plan and electronic equipment.

Background

The national grid company starts the construction work of a modern (intelligent) supply chain at the end of 2017, and builds an intelligent supply chain system with large data support, networked sharing and intelligent cooperation. The national grid Ji North electric power company actively responds to the construction of a national grid modern (intelligent) supply chain system, explores innovative management ideas of a material plan reporting link, solves the problems of error reporting, missing reporting, late reporting and the like easily occurring in a traditional material purchasing plan reporting mode, and leads the material plan reporting work level to step forward to a new step.

In order to establish an information management means in the aspects of demand report index management, protocol inventory demand management, demand report intelligent review and the like, the management level and the operation efficiency are further improved. The method and the system have the advantages that the operation management level of the auxiliary system for the requirement plan review of the planning department of the material company is comprehensively improved, the material resource management capacity is improved, the system perfection and improvement work is well done, and the information operation and maintenance service of centralized management and control, unified scheduling, lean management and efficient operation is realized.

According to the construction history and the system application condition of the demand plan review auxiliary system, the business, integration and non-functional construction requirements of the construction of the demand plan review auxiliary system of the material company planning department in 2018 are combined, the existing problems of the known production environment and the test environment of the operation system are considered comprehensively, the horizontal integration of the company material resource management information system is followed, the new generation of supply chain management requirements are longitudinally and stereoscopically realized, the purchasing plan intelligent declaration system of the material company planning department needs to continuously improve and promote the existing functions on the basis of the original system construction results, so that the business development requirements of the material company planning department are supported more firmly, meanwhile, in order to adapt to the work of the material company planning department in a new situation, the lean management is strengthened, the innovation is promoted, the service quality is improved, and the country network intensive construction is completed, optimization and promotion in the aspects of flow, automation and standardization are required to be realized on the functions of an audition conference business flow, a self-selection scene reporting business function, material index calculation and the like.

Disclosure of Invention

Aiming at the defects of the prior art, the invention discloses a method for automatically examining on a purchasing plan line and electronic equipment.

The invention is realized by the following technical scheme:

in a first aspect, the invention discloses an online automatic review method for a purchase plan, which comprises the following steps:

s1, starting automatic examination of the purchasing planning line, and adjusting the parameters of the checking rule according to the actual situation;

s2, storing the data to be checked into the demand line information buffer area for automatic checking;

s3, grouping the data to be checked according to batches, and respectively carrying out automatic checking on the checking rules;

s4, obtaining batch types and applicable rules according to the batch numbers, checking the mandatory examination rules one by one, and updating the checking information to the buffer area;

s5, after the mandatory check rule passes, continuously checking the non-mandatory rule one by one, and updating check information to a buffer area;

s6, when the mandatory examination rule passes the verification process, the automatic examination of the batch is finished after the mandatory examination rule is executed;

and S7, returning the result of the demand line information buffer area after the verification of all batches is completed, and completing the material plan control after the expert review stage is entered.

Further, in the method, the automatically checked rules comprise general rules and complex rules; the general rule is configured through a system, and the complex rule is developed in a targeted mode through a customization mode.

Furthermore, the general rule configures a rule expression through a background, and the rule expression is interpreted and executed through a rule engine during automatic examination and verification is completed.

Further, the complex customized rule comprises a java technology implementation and a database storage process and function technology implementation.

Furthermore, the rule realized based on the java technology is used for carrying out operations such as related logic calculation, judgment and the like on data with less interaction with other business data but with logic complex rules;

furthermore, the rules realized based on the database storage process and the function technology are used for rules with more interaction with other business data, the associated data can be conveniently obtained from the database, and the interactive operation among servers when the data are obtained is reduced.

Furthermore, in the method, when the matched examination rule is executed, dynamic execution of the matched rule is realized through a java reflection mechanism, and automatic examination of the required line is completed.

Furthermore, when the expert reviews, the automatic expert extraction is carried out, and the method comprises the following steps:

t1, importing the review demand data into a demand line information buffer area, and performing professional grouping on demand plan lines according to material grouping configuration;

t2 calls technical specification verification synchronously when the requirement line is grouped professionally, and identifies the technical specification type used by the requirement line to a buffer area;

t3 analyzing the quantity of the review required lines of each professional expert according to the review history record, and storing the quantity in a buffer area;

t4 calculating the expert quantity needed by each professional according to the quantity of the expert experts available to review the requirement line and the grouping information of the requirement line;

and T5 extracting each professional expert according to the expert evaluation result, the expert evaluation frequency, the avoidance criterion and other factors.

T6 returns the first extraction result and informs the appraisal expert to confirm by the way of short message, mail, etc.;

t7 judges whether the expert can participate in the conference, performs replacement extraction on the experts which cannot participate in the conference, and confirms whether the expert can participate in the conference until the quantity required by the expert is met.

Furthermore, before the expert is extracted, the historical examination of the expert in advance can record and analyze the performance, and the method comprises the following steps:

through the face attendance equipment, after the attendance of an expert is finished, the attendance condition of the expert is recorded, and data storage is completed through a data interface as one of the preconditions of preferential extraction;

setting an evaluation system, giving a score by a group leader in each performance of professional level, working attitude and error condition aiming at expert performance, and automatically recording the score condition and storing the score condition into a database by a system after the score is finished;

setting an annual assessment function, maintaining different threshold score ratios of annual assessment of experts in the system, maintaining the annual comprehensive score intervals of experts in all levels, analyzing the experts in each season, giving annual assessment scores by the system after the annual assessment is completed in each season, and giving a grade-up and grade-down suggestion according to the score condition of each expert after the annual assessment is completed.

In a second aspect, an electronic device is disclosed that includes at least one processor and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method for automated review on a purchase score of the first aspect.

The invention has the beneficial effects that:

the invention automatically judges and extracts the quantity of the experts required by each professional group of the examination meeting, avoids the possibility of easily making mistakes by manually screening the experts, effectively reduces the workload of expert examination, and can also manually extract and replace according to different professional groups if meeting special conditions after the extraction is finished, thereby doubly ensuring the accuracy of the extracted experts.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.

FIG. 1 is a flow diagram of automated review by a procurement planning line according to an embodiment of the invention;

FIG. 2 is a flow chart of an embodiment of the present invention for automatically extracting experts.

Detailed Description

In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

Example 1

The embodiment discloses an online automatic review method for a purchasing plan, which comprises the following steps:

In the method of the embodiment, the rules for automatic examination include general rules and complex rules; the general rule is configured through a system, and the complex rule is developed in a targeted mode through a customization mode.

The general rule configures a rule expression through a background, and the rule expression is interpreted and executed through a rule engine and verification is completed during automatic examination.

The complex customized rule comprises java technology-based implementation and database storage process-based and function technology-based implementation.

The rules realized based on the java technology are used for carrying out operations such as related logic calculation, judgment and the like on data with less interaction with other service data but complex logic rules;

the rules realized based on the database storage process and the function technology are used for rules with more interaction with other business data, the associated data is conveniently acquired in the database, and the interaction operation among servers during data acquisition is reduced.

In the method of the embodiment, when the matched examination rule is executed, dynamic execution of the matched rule is realized through a java reflection mechanism, and automatic examination of the required line is completed.

Example 2

The embodiment discloses the automatic review of the purchasing plan shown in fig. 1, wherein the required data to be checked is maintained in advance and the parameters of the checking rules are configured before the automatic review, the reviewing rules are divided into mandatory rules and non-mandatory rules, the mandatory rules are executed first when the automatic review is executed, and the non-mandatory rules are checked only after the mandatory rules are verified.

The mandatory examination rule is mainly a rule which needs to be met by some report requirements related to the material types in a demand line; non-mandatory rules are mainly rules that check specific requirement rows.

The examination rules can carry out different rule checks on different bidding batches, and the examination rules which are not matched with each other in batch types such as a single source, an agreement stock, a service batch and the like are different.

When the unified data verification is performed on the whole batch, the mandatory review rule is verified firstly, and after the verification is passed, other non-mandatory review rules such as data accuracy, data uniqueness and the like are verified respectively.

The main process is as follows:

1) checking the starting state of the examination rule, and adjusting the parameters of the check rule according to the actual condition;

2) storing the data to be inspected into a demand line information buffer area, and preparing for automatic inspection;

3) grouping data to be verified according to batches, and respectively carrying out automatic verification on the inspection rules;

4) obtaining the batch type and an applicable rule according to the batch number;

5) checking the mandatory examination rules one by one, and updating checking information to a buffer area;

6) after the mandatory check rule passes, continuously checking the non-mandatory rule one by one, and updating check information to a buffer area;

7) when the mandatory examination rule passes the verification process, the automatic examination of the batch is finished after the mandatory examination rule is executed;

8) and returning the result of the demand line information buffer area after the verification of all batches is completed.

The examination rules are realized by adopting different technical modes according to the characteristics of the rules, the general rules are carried out through system configuration, and the complex rules are purposefully developed through a customization mode:

the general rule, such as the technical specification field, cannot be an examination rule such as null, delivery date and the like, the rule expression is configured through the background, and the rule expression is explained and executed through the rule engine during automatic examination and verification is completed;

the complex customized rules are divided into two types of implementation based on java technology and implementation based on database storage process and function technology. The rules realized based on the java technology are suitable for rules which have less interaction with other service data but have complex logic, can fully exert the data processing capacity of java, and perform operations such as related logic calculation, judgment and the like on the data; the rules realized based on the database storage process and the function technology are suitable for rules with more interaction with other business data, the associated data can be conveniently obtained from the database, the interaction operation between servers during data acquisition can be effectively reduced, and the execution efficiency of the examination rules is improved.

When the matched examination rule is executed, the dynamic execution of the matched rule is realized through a java reflection mechanism, and the automatic examination of the required line is completed.

Example 3

The embodiment discloses the automatic extraction expert as shown in fig. 2, when the expert is automatically extracted, an expert database and expert professional information need to be maintained, and the expert have a 1-to-many relationship; the system can evaluate all experts in the expert database, and evaluation results such as attendance rate, late arrival rate, early retreat rate, average examination time, error submission number and the like are used as one of conditions for expert promotion and also used as extraction factors of the optimized experts.

The main process is as follows:

1) the evaluation demand data is imported into a demand line information buffer area which comprises the following steps: and (5) the information of the requirement line needing to be checked.

2) And performing professional grouping on the demand planning lines according to the material grouping configuration, wherein part of the materials need to be reviewed by experts of different specialties, and the demand planning lines and the specialties have the same one-to-many relationship.

3) And synchronously calling technical specification verification when the demand line is subjected to professional grouping, and identifying the technical specification type used by the demand line to the buffer area.

4) And analyzing the quantity of the evaluation required lines of each professional expert according to the evaluation historical record, and storing the quantity into a buffer area.

5) And calculating the quantity of the experts required by each professional according to the quantity of the required lines which can be reviewed by each professional expert and the grouping information of the required lines.

6) And extracting each professional expert according to factors such as expert evaluation results, expert evaluation frequency, avoidance criteria and the like.

7) And returning the primary extraction result.

8) And informing the appraisal experts to participate in the confirmation in the modes of short messages, mails and the like.

9) The expert confirms whether participation is possible.

10) And (4) carrying out replacement extraction on the experts which cannot participate in the conference, and confirming whether the experts can participate in the conference or not until the quantity required by the experts is met.

And (4) grouping the participating experts according to the specialty, setting group leader and finishing extraction.

Before the system extracts, the historical examination of experts is recorded and analyzed in advance, and before the system preferably extracts:

1. through the face attendance equipment, after the attendance is finished, the expert records the attendance condition of the expert, completes data storage through the data interface as one of the preconditions of preferential extraction,

2. the system is additionally provided with an evaluation system, and the group leader gives a score in each performance of professional level, working state degree and error condition aiming at expert performance, and the score is finished. The system automatically records the scoring condition and stores the scoring condition in a database;

3. in addition to the two types, the annual assessment function is added, the annual assessment of different threshold score proportions of experts is well maintained in the system, the comprehensive annual assessment intervals of the experts of all levels are maintained, the experts are analyzed in each quarter, the system finally gives annual assessment scores after the annual assessment is completed, and after the scores are completed, a grading recommendation is given according to the scoring condition of each expert.

Example 4

This example discusses the effect of automatic review, examples of which are as follows:

example 1:

rule name: checking the estimated amount of money

Type of batch used: service classes

Checking the content: the estimated amount is too high (more than 50 ten thousand) and too low (less than 20 ten thousand)

Example 2:

rule name: whether the manufacturer fills in the earlier stage

Type of batch used: single source

Checking the content: the former manufacturer must fill in the item

The system automatically judges and executes without manually screening the check rule, thereby solving the work of examining the conventional content by the expert and improving the examination efficiency of the expert.

The specific cases of expert extraction are as follows:

example 1:

professional group name: automation and secondary group

Historical total audit demand quantity: 2100

Historical total censorship number: 70

Example 2:

professional group name: set of device materials

Historical total audit demand quantity: 3600

Historical total censorship number: 60

The quantity of the experts required by each professional group of the examination meeting is automatically judged and extracted, the possibility that the experts are easily mistaken by manual screening is avoided, and after extraction is finished, if special conditions are met, the experts can be manually extracted and replaced according to different professional groups, so that the accuracy of the extracted experts is dually ensured.

Example 5

The embodiment discloses an electronic device, which comprises at least one processor and a memory which is in communication connection with the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the at least one processor to perform a method for online automated review of a procurement plan.

In conclusion, the invention automatically judges and extracts the quantity of the experts required by each professional group of the examination meeting, avoids the possibility of easily making mistakes by manually screening the experts, effectively reduces the workload of expert examination, and can manually extract and replace the experts according to different professional groups if special conditions happen after extraction is finished, thereby doubly ensuring the accuracy of the extracted experts.

The above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.

Claims

1. A method for online automated review of a procurement plan, the method comprising the steps of:

s4, obtaining batch type and applicable rules according to the batch number, checking the mandatory examination rules one by one, and updating the checking information to the buffer area;

s7, returning the result of the demand line information buffer area after the verification of all batches is completed;

and S8, automatically extracting experts, entering an expert examination stage, obtaining calculated indexes, and finishing the management and control of the material plan.

2. The method for on-line automatic review of procurement plans of claim 1, characterized in that, in the method, the rules of automatic review include general-type rules and complex rules; the general rule is configured through a system, and the complex rule is developed in a targeted mode through a customization mode.

3. The method of on-line automatic review for procurement planning as claimed in claim 2, wherein the general rule configures the rule expression in the background, and the rule expression is interpreted and executed by the rule engine during automatic review, and the verification is completed.

4. The method of on-line automated review for procurement plans of claim 2, characterized in that the complex customized rules comprise java-technology-based implementation and database-storage-process-based, functional-technology-based implementation.

5. The method of claim 4, wherein the rules implemented based on java technology are used for interacting with other business data with less logic complex rules, and performing related logic calculation, judgment and the like on the data.

6. The method of on-line automatic review for procurement planning of claim 4 characterized by that, the rules implemented based on database storage process and function technology are used for rules with more interaction with other business data, the acquisition of associated data in the database is convenient, and the interaction operation between servers when acquiring data is reduced.

7. The method of on-line automatic review for procurement planning as claimed in claim 1, wherein in the method, dynamic execution of the matching rules is realized through a java reflection mechanism when the matching review rules are executed, thereby completing the automatic review of the required rows.

8. The method for on-line automatic review of procurement planning according to claim 1, wherein the expert is automatically extracted during review, comprising the steps of:

t3 analyzes the quantity of the lines required by each professional expert according to the evaluation history record and stores the lines in a buffer area;

t4 calculating the expert quantity according to the expert review requirement line quantity and the requirement line grouping information;

T6 returns the first extraction result and informs the appraisal expert to confirm by short message, mail and other ways;

t7 judges whether the expert can participate in the meeting, replaces and extracts the experts which can not participate in the meeting, and confirms whether the expert can participate in the meeting until the quantity required by the expert is met.

9. The method of claim 8, wherein prior to extracting the expert, prior to pre-reviewing the expert's historical reviews, the method further comprises:

setting an annual assessment function, maintaining different threshold score ratios of annual assessment of experts in the system, maintaining the annual comprehensive score intervals of experts in all levels, analyzing the experts in each quarter, giving annual assessment scores by the system after the annual assessment is completed, and giving up-down suggestions according to the score conditions of the experts after the scores are completed.

10. An electronic device comprising at least one processor and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method for online automated review of a procurement plan of any of claims 1-9.