Report verification input method and device, computer equipment and readable storage medium
By generating verification expressions automatically verifying and entering report data, the problem of high efficiency and low entry cost in the existing technology is solved, and efficient and low-cost report data entry is achieved.
Patent Information
- Application Number
- CN202510420977.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-04-03
- Publication Date
- 2025-07-18
AI Technical Summary
In the prior art, the report verification entry method in medical and financial scenarios is costly and inefficient, and the authority and business capabilities of operation personnel and developers are misaligned, resulting in a waste of cost and time in multi-system development.
By obtaining the title text and data content of the sample report, a regular expression is generated, and a verification expression is obtained based on the regular expression selection and/or correction, which is used to verify the data content of the report to be entered, and the verified data is entered into the database to record the error information of the verification failure.
There is no need to develop an import system for each business type, which saves operation and development costs, improves the efficiency of report verification entry, and reduces entry costs.
Smart Images
Figure CN120337886A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical fields of information management and database, and is applicable to medical and financial scenarios. In particular, it relates to a method, device, computer device and readable storage medium for verifying and inputting reports. Background Art
[0002] Information management systems, especially knowledge base management systems, usually require data maintenance. In scenarios such as medical and finance where data updates are large in volume and frequent, data maintenance is particularly important. When performing data maintenance, it is usually necessary for operators to first fill in data forms and then input the forms into the background database. Background databases such as the common MySQL (an open-source relational database management system) support the direct input of forms. However, when inputting forms for a large number of different services, due to the operators' lack of knowledge about the relevant structure of the background database, they can only perform manual verification and import operations, which have a high error rate and cannot perform batch verification and import operations. Developers have the knowledge required for batch verification and import, but are not familiar with the data business, do not have the operation permissions, and also cannot perform batch verification and import operations. The actual situation has led to a mismatch between operators and developers in terms of permissions and business capabilities. At this time, a batch import system is needed to assist operators in form input. Under the existing technology, developing corresponding batch input systems for inputting forms of different services will cause a great waste of costs and time, resulting in a high input cost and low efficiency. Summary of the Invention
[0003] The present invention provides a method, device, computer device and readable storage medium for verifying and inputting reports to solve the technical problems of high cost and low efficiency of the existing report verification and input methods.
[0004] In a first aspect, a method for verifying and inputting reports is provided. The method for verifying and inputting reports includes:
[0005] Obtaining a sample report and a report to be input;
[0006] Obtaining the title text and the corresponding first data content in the sample report, and obtaining at least one regular expression corresponding to the first data content according to the title text;
[0007] Selecting and / or correcting the regular expression according to the first data content to obtain a verification expression;
[0008] Obtaining the second data content in the report to be input, verifying the second data content through the verification expression. If the verification is successful, the second data content is input into the database; if the verification fails, error information is recorded through a log file.
[0009] In a second aspect, a report verification and entry device is provided. The report verification and entry device includes:
[0010] A report acquisition module for acquiring a sample report and a report to be entered;
[0011] A rule acquisition module for acquiring the title text and the corresponding first data content in the sample report, and acquiring at least one regular expression corresponding to the first data content according to the title text;
[0012] A rule correction module for selecting and / or correcting the regular expression according to the first data content to obtain a verification expression;
[0013] A data verification module for acquiring the second data content in the report to be entered, verifying the second data content through the verification expression, and if the verification is successful, entering the second data content into the database; if the verification fails, recording error information through a log file.
[0014] In a third aspect, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the steps of the above-mentioned report verification and entry method are implemented.
[0015] In a fourth aspect, a computer-readable storage medium is provided. The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the above-mentioned report verification and entry method are implemented.
[0016] In the solution implemented by the above-mentioned report verification and entry method, device, computer device, and readable storage medium, at least one regular expression corresponding to the first data content is obtained through the title text of the imported sample report, and then the verification expression is obtained by selecting and / or correcting according to the first data content. Since the other parts of the sample report and the report to be entered are the same except for the filled data content, the verification expression obtained through the sample report can be used to verify the second data content in the report to be entered. The second data content in the report to be entered is verified through the verification expression, and the verified second data content is stored in the database. When the user performs form entry, only by importing the sample report to obtain the verification expression can the report to be entered be verified and entered. There is no need to develop a corresponding import system for the business type of the report to be entered, nor to customize verification rules for a certain business type separately, which greatly saves the operation and development costs, thereby reducing the cost of report verification and entry and improving the efficiency of report verification and entry. Description of the Drawings
[0017] To more clearly illustrate the technical solutions of the embodiments of the present invention, the following will briefly introduce the drawings required for the description of the embodiments of the present invention. Obviously, the drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other drawings can also be obtained based on these drawings.
[0018] Figure 1 It is a schematic diagram of an application environment of a report verification and entry method provided by an embodiment of the present invention.
[0019] Figure 2 It is a schematic flowchart of the first implementation manner of the report verification and entry method provided by an embodiment of the present invention.
[0020] Figure 3 It is Figure 2 A schematic flowchart of a specific implementation manner of step S20 in
[0021] Figure 4 It is Figure 2 A schematic flowchart of a specific implementation manner of step S30 in
[0022] Figure 5 It is Figure 2 A schematic flowchart of the first specific implementation manner of step S40 in
[0023] Figure 6 It is Figure 5 A schematic flowchart of a specific implementation manner of step S410 in
[0024] Figure 7 It is Figure 2 A schematic flowchart of the second specific implementation manner of step S40 in
[0025] Figure 8 It is Figure 2 A schematic flowchart of the third specific implementation manner of step S40 in
[0026] Figure 9 It is a schematic diagram of a report verification and entry device in an embodiment of the present invention
[0027] Figure 10 It is a schematic diagram of the structure of a computer device in an embodiment of the present invention. Specific implementation manner
[0028] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention. Obviously, the described embodiments are some, but not all, of the embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts belong to the scope of protection of the present invention.
[0029] The report verification and entry method provided by the embodiments of the present invention can be applied in an application environment such as Figure 1 the following. Figure 1 FIG. is a schematic diagram of an application environment of the report verification and entry method provided by an embodiment of the present invention. As Figure 1 shown, in this application environment, it includes a client 10 and a server 20. The client 10 is a terminal device used by a user, and the server 20 is a database terminal. The client 10 and the server 20 jointly execute the report verification and entry method. It should be noted that the client 10 and the server 20 can be a smart phone, a tablet computer, a notebook computer, a desktop computer, etc., but are not limited thereto. The client 10 and the server 20 can be connected through Bluetooth, USB (Universal Serial Bus), or other communication connection methods, and the present invention does not limit this here.
[0030] Figure 2 FIG. is a schematic flowchart of a first implementation manner of the report verification and entry method provided by an embodiment of the present invention. As Figure 2 shown, the report verification and entry method specifically may include the following steps:
[0031] S10. Obtain a sample report and a report to be entered.
[0032] In this step, the sample report can be selected from the report data pre-stored in the system or uploaded by the user, and the report to be entered is generally uploaded by the user. The title text, row and column formats, etc. of the sample report and the report to be entered are exactly the same except for the specific data content. That is, if the first data content in the sample report is swapped with the second data content in the report to be entered, it will not affect the reading and viewing of the form. The data content is all the content filled in the data cells, and the data content includes data formats, text types, text lengths, text languages, etc., which describe the data in the data cells.
[0033] In the above implementation manner, before obtaining the sample report and the report to be entered uploaded by the user, first detect the operation authority of the user. Only when the user has the operation authority, will the sample report and the report to be entered uploaded by the user be obtained.
[0034] S20. Obtain the title text in the sample report and the corresponding first data content, and obtain at least one regular expression corresponding to the first data content according to the title text.
[0035] In this step, obtain the title text in the sample report and the first data content corresponding to the title text. For example, if the title text name is "Mobile Phone Number" and the second data content is "133****5555". According to the title text name "Mobile Phone Number", it can be known that the first data content corresponding to this title text should be eleven digits, that is, obtain the regular expression corresponding to eleven digits. If the title text name is "Contact Information" and the corresponding first data content is "133****5555", according to the title text name "Contact Information", it can be known that the first data content corresponding to this title text may be a mobile phone number, a landline number, or an email address. At this time, obtain the regular expressions corresponding to eleven digits, seven digits, and those with email characteristics.
[0036] In a specific embodiment, the regular expression for a mobile phone number can be " / ^1[3-9]\d{9}$ / ", which means starting with 1, the second digit is a number between 3 and 9, followed by 9 digits, for a total of 11 digits. The regular expression for an email address can be "^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$", where "^" represents the start of the string match. "[a-zA-Z0-9._%+-]+" represents matching the local-part (the part before the @ symbol in the email address), which can contain one or more letters, numbers, dots (.), underscores (_), percent signs (%), plus signs (+), hyphens (-). "@" represents matching the @ symbol in the email address. "[a-zA-Z0-9.-]+" represents matching the main part of the domain, which can contain one or more letters, numbers, dots (.), hyphens (-). "\." represents matching the dot (.), which is used to separate the main part of the domain and the top-level domain. "[a-zA-Z]{2,}" represents matching the top-level domain, usually containing at least two letters (such as.com,.org). "$" represents the end of the string match.
[0037] S30. Select and / or correct the regular expression according to the first data content to obtain a verification expression.
[0038] In this step, when there are situations such as non-standard or ambiguous title texts, multiple or inaccurate regular expressions may occur for the regular expressions generated by the title texts. At this time, it is necessary to select and / or correct the regular expression according to the first data content. Since the first data content is the known correct content in the sample report, the verification expression obtained by selecting and / or correcting through the first data content is a regular expression that can accurately reflect the data content corresponding to the title text.
[0039] In a specific embodiment, there may be multiple title texts and corresponding data contents in the sample report and the report to be entered. By using the above method to obtain the verification expressions for the data contents corresponding to each title text, a group of verification expressions is obtained.
[0040] S40. Obtain the second data content in the report to be entered, and verify the second data content by using the verification expression. If the verification is successful, enter the second data content into the database; if the verification fails, record the error information through a log file.
[0041] In this step, obtain the second data content of the report to be entered, and verify the second data content by using the verification expressions obtained by the above method. When there are multiple title texts and corresponding data contents in the sample report and the report to be entered, obtain the corresponding relationship between each verification expression in the group of verification expressions and the second data content, and then verify the corresponding second data content according to each verification expression. If the verification is successful, enter the first data content into the database; if the verification fails, record the error information through a log file.
[0042] For the report verification and entry method of this embodiment, when the user performs form entry, they only need to obtain the verification expressions through the sample report to verify and enter the report to be entered, without having to develop a corresponding import system for the business type of the report to be entered, nor having to customize verification rules for a certain business type separately, which greatly saves the operation and development costs, thereby reducing the cost of report verification and entry and improving the efficiency of report verification and entry.
[0043] In a specific embodiment, in the application scenario of medical information entry, the title texts of the sample report and the report to be entered may include name, gender, date of birth, age, ID number, medical insurance card number, contact information, body temperature, blood pressure, heart rate, respiratory rate, etc. In the application scenario of financial information entry, the title texts of the sample report and the report to be entered may include basic enterprise information, account type, account annotation, credit transaction information, credit inquiry record, etc. In the above two application scenarios, due to the large differences in the data types corresponding to each title text and usually a large amount of data, conventional entry methods have problems such as slow entry and easy errors. At this time, by obtaining the verification expressions through the sample report, the report to be entered can be verified and entered, which can greatly accelerate the information entry and improve the work efficiency of the staff.
[0044] Figure 3 Yes Figure 2 is a schematic flowchart of a specific implementation manner of step S20 in Figure 3 As shown, in some embodiments, step S20 can be implemented in the following manner:
[0045] S201. Obtain the regular expression set corresponding to the pre-established data content and the mapping relationship between the pre-established keywords and regular expressions.
[0046] In this step, the regular expression set is a set of regular expressions corresponding to all possible data content, which is pre-established by developers. The mapping relationship between keywords and regular expressions is also pre-established by developers, and the corresponding regular expression can be directly mapped through keywords.
[0047] S202. Obtain the keywords in the title text, and obtain at least one regular expression from the regular expression set according to the keywords and the mapping relationship.
[0048] In this step, the keywords in the title text name are obtained by performing natural language analysis on the title text. The specific analysis process includes lexical analysis, semantic analysis, syntactic analysis, etc. of the title text. Multiple keywords may be parsed from the title text, and each keyword may also correspond to multiple regular expressions. For example, if the title text is "Patient discharge date", the keyword "date" is obtained. If the title text is "Family member contact information", the keyword "contact information" is obtained. When there is only one keyword and the keyword corresponds to only one regular expression, the regular expression corresponding to the keyword is obtained. When there are multiple keywords or a keyword corresponds to multiple regular expressions, all regular expressions corresponding to all keywords are obtained. For example, if the keyword is "date", the regular expressions describing the date are obtained. Since the date has multiple expressions such as "year / month / day" and "month / day / year", multiple regular expressions may be obtained. When the keyword is "contact information", the contact information may be a mobile phone number, a landline number or an email address. At this time, the regular expressions corresponding to eleven-digit numbers, seven-digit numbers and email characteristics are obtained.
[0049] Figure 4 Yes Figure 2 It is a schematic flowchart of a specific implementation manner of step S30 in Figure 4 As shown, in some implementation manners, in step S30, the regular expression is selected and / or corrected according to the second data content to obtain a verification expression, which specifically includes:
[0050] S301. When the title text corresponds to one regular expression, verify whether the regular expression is correct according to the first data content. If it is correct, select the regular expression as the verification expression. If it is incorrect, correct the regular expression according to the first data content, and use the corrected regular expression as the verification expression.
[0051] In this step, when the title text corresponds to only one regular expression, the regular expression is verified according to the first data content. When the first data content completely matches the obtained regular expression, the regular expression is determined to be a correct regular expression, and this regular expression is selected as the verification expression. When the first data content does not match the obtained regular expression, the obtained regular expression is corrected according to the first data content to obtain the verification expression. Since the first data content is known to be correct data content, the regular expression that can match the first data content can be used as the verification expression for verifying the second data content.
[0052] S302. When the title text corresponds to multiple regular expressions, the regular expressions are verified according to the first data content. If at least one of the multiple regular expressions is verified successfully, a verified successful regular expression is selected as the verification expression. If all of the multiple regular expressions fail the verification, first select the regular expression with the highest degree of compliance with the first data content, and then correct the regular expression with the highest degree of compliance according to the first data content to obtain the verification expression.
[0053] In this step, when the first data content completely matches at least one of the obtained regular expressions, the regular expression is determined to be a correct regular expression, and this regular expression is selected as the verification expression. If all of the multiple regular expressions fail the verification, first select the regular expression with the highest degree of compliance with the first data content, where the degree of compliance is judged by a pre-established matching scoring mechanism for regular expressions, and then correct the regular expression with the highest degree of compliance according to the first data content to obtain the verification expression.
[0054] In the above steps, the matching scoring mechanism disassembles the regular expression into multiple key conditions, assigns weights to each condition, and calculates the weighted score. For example, for a regular expression " / ^1[3-9]\d{9}$ / ", the matching scoring mechanism can be set as follows: the weight of "starting with 1" is 20%, the weight of "the second digit is a number from 3 to 9" is 30%, the weight of "the total length is equal to 11 digits" is 30%, and the weight of "all are digits" is 20%. If the first data content is "1391234567", it meets the conditions of "starting with 1", "the second digit is a number from 3 to 9", and "all are digits", but does not meet the condition of "the total length is equal to 11 digits". The sum of the weights of the conditions it meets is 0.7, and the compliance is 0.7. According to the above scoring mechanism, the compliance of the first data content and each regular expression can be calculated. Assuming that the above regular expression " / ^1[3-9]\d{9}$ / " is the regular expression with the highest similarity to the first data content "1391234567", it is only necessary to change the regular expression to " / ^1[3-9]\d{8}$ / ". It should be noted that in actual applications, when selecting the regular expression with the highest compliance with the first data content and correcting the regular expression according to the first data content, multiple first data contents will be used for determination. The above specific embodiments are only for more concisely explaining the technical solution and do not constitute the limiting content of the present invention.
[0055] In the above steps, when correcting the regular expression, it is also possible to directly obtain the correct regular expression from the first data content to replace the incorrect regular expression, or to correct the incorrect regular expression based on the user's own experience.
[0056] Figure 5 Yes Figure 2 is the schematic flowchart of the first specific implementation manner of step S40 in Figure 5 As shown, in some embodiments, step S40 may include:
[0057] S410. Obtain the second data content entered by the user in the data content entry text box, and verify the second data content entered by the user in the data content entry text box through the verification expression. The data content entry text box is displayed on the report entry page.
[0058] In this embodiment, obtaining the second data content entered by the user in the data content entry text box is applicable to application scenarios where the data content in the report to be entered is less or other scenarios that require manual entry by the user. The verification of the second data content filled in by the user in the data content entry text box is achieved by establishing a mapping relationship between the data content entry text box and the corresponding verification expression. The data content entry text box is displayed on the report entry page, and the report entry page also includes a title text element, which is set around the data content entry text box in a prominent manner to remind the user to enter data content related to the title text in the data content entry text box.
[0059] Figure 6 Yes Figure 5 A schematic flowchart of a specific implementation manner of step S410 in Figure 6 As shown, before step S410, it further includes:
[0060] S409. Generate the report entry page according to the design instructions input by the user in the report design interface; wherein, the report design interface includes multiple component modules, each component module corresponds to a report element, and the design instructions include a drag operation and a cell definition input operation.
[0061] In this embodiment, the user can render and design the report entry page according to their own needs. Each component module is displayed in the report design interface. The component module includes a title text and a data content entry text box. The user only needs to perform a drag operation to select the required component module and place it in the required position to complete the report design. In addition, the user can also modify the name of the title text element by themselves through the cell definition input operation. Since the verification expression has been selected at this time, this operation will not affect the verification effect.
[0062] Figure 7 Yes Figure 2 A schematic flowchart of the second specific implementation manner of step S40 in Figure 7 As shown, in some embodiments, step S40 may include:
[0063] S420. Import the report to be entered, extract all the second data content from the report to be entered, and verify all the second data content according to the verification expression.
[0064] In this embodiment, the report to be entered is directly imported to obtain all the second data contents in the report to be entered, and all the second data contents are verified according to the verification expression. When importing the report to be entered, the user who performs the import operation is subject to permission review, and the import operation is performed only after the review is passed. The process of importing the report to be entered includes receiving the form document of the report to be entered in the form of a binary table from the front end and storing it in the cache, then converting the binary table document into a structured and parsable document object, and finally obtaining all the second data contents in the report to be entered and verifying all the second data contents according to the verification expression.
[0065] Figure 8 Yes Figure 2 Schematic flow diagram of the third specific implementation manner of step S40 in, as Figure 8 shown, in some embodiments, step S40 may include:
[0066] S430. Cache the second data content in the cache pool, and after the cache pool is full or all the second data contents are completely verified, batch-enter all the second data contents in the cache pool into the database.
[0067] In this step, to avoid frequent writes to the database caused by frequent insertions, the second data content that passes the verification is first cached in the cache pool, and after the cache pool is full or all the second data contents are completely verified, the second data content is batch-entered into the database from the cache pool.
[0068] The report verification and entry method provided by the embodiments of the present invention can be constructed based on artificial intelligence, and relevant data is acquired and processed based on artificial intelligence technology to achieve unattended report verification and entry. Among them, artificial intelligence (AI) is the theory, method, technology and application system that uses a digital computer or a machine controlled by a digital computer to simulate, extend and expand human intelligence, perceive the environment, acquire knowledge and use knowledge to obtain the best results. Artificial intelligence basic technologies generally include technologies such as sensors, dedicated artificial intelligence chips, cloud computing, distributed storage, big data processing technology, operation / interaction systems, and mechatronics. Artificial intelligence software technologies mainly include several major directions such as computer vision technology, robotics, biometric technology, speech processing technology, natural language processing technology, and machine learning / deep learning.
[0069] In one embodiment, a report verification and entry device is provided, and the report verification and entry device corresponds one-to-one to the report verification and entry method in the above embodiment. As Figure 9 shown, the report verification and entry device includes:
[0070] Report acquisition module 100, which is used to acquire sample reports and reports to be entered;
[0071] Rule acquisition module 200, which is used to acquire the title text and corresponding first data content in the sample report, and acquire at least one regular expression corresponding to the first data content according to the title text;
[0072] Rule correction module 300, which is used to select and / or correct the regular expression according to the first data content to obtain a verification expression;
[0073] Data verification module 400, which is used to acquire the second data content in the report to be entered, verify the second data content through the verification expression, and if the verification is successful, enter the second data content into the database; if the verification fails, record the error information through a log file.
[0074] Specifically, the rule acquisition module 200 includes a first acquisition unit and a second acquisition unit.
[0075] The first acquisition unit is used to acquire the set of regular expressions corresponding to the pre-established data content and the mapping relationship between the pre-established keywords and regular expressions.
[0076] The second acquisition unit is used to acquire the keywords in the title text, and acquire at least one regular expression from the set of regular expressions according to the keywords and the mapping relationship.
[0077] Specifically, the rule correction module 300 includes a first rule correction unit and a second rule correction unit.
[0078] The first rule correction unit is used to verify whether the regular expression is correct according to the first data content when the title text corresponds to one regular expression. If it is correct, select the regular expression as the verification expression. If it is incorrect, correct the regular expression according to the first data content, and use the corrected regular expression as the verification expression.
[0079] The second rule correction unit is used to verify the regular expressions according to the first data content when the title text corresponds to multiple regular expressions. If at least one of the multiple regular expressions is verified successfully, select a verified successful regular expression as the verification expression. If all the multiple regular expressions fail the verification, first select the regular expression with the highest degree of conformity with the first data content, and then correct the regular expression with the highest degree of conformity according to the first data content to obtain the verification expression.
[0080] Specifically, the data verification module 400 includes a page verification unit.
[0081] A page verification unit, configured to obtain the second data content entered by the user in the data content entry text box, and verify the second data content entered by the user in the data content entry text box through the verification expression, where the data content entry text box is displayed on a report entry page.
[0082] Specifically, the page verification unit is further configured to generate the report entry page according to a design instruction input by the user in a report design interface; wherein, the report design interface includes a plurality of component modules, each component module corresponds to a report element, and the design instruction includes a drag operation and a cell definition input operation.
[0083] Specifically, the data verification module 400 further includes a batch verification unit.
[0084] The batch verification unit is configured to import the to-be-entered report, extract all the second data content from the to-be-entered report, and verify all the second data content according to the verification expression.
[0085] Specifically, the data verification module 400 is further configured to cache the second data content in a cache pool, and after the cache pool is full or all the second data content is completely verified, batch-enter all the second data content in the cache pool into a database.
[0086] For specific limitations on the report verification and entry device, reference may be made to the limitations on the report verification and entry method in the foregoing text, which will not be elaborated herein. Each module in the foregoing report verification and entry device can be implemented in whole or in part by software, hardware, and their combination. The foregoing modules can be embedded in a processor in a computer device in a hardware form or be independent of the processor, or can be stored in a memory in the computer device in a software form, so as to facilitate the processor to call and execute the operations corresponding to the foregoing respective modules.
[0087] Figure 10 As a schematic structural diagram of an embodiment of a computer device according to the present application, as Figure 10 shown, the present application further provides a computer device, including:
[0088] A memory and a processor, where computer-readable instructions are stored in the processor, and when the computer-readable instructions are executed by the processor, the processor executes any step of the foregoing report verification and entry method.
[0089] The present application also provides a computer-readable storage medium. When computer-readable instructions are executed by one or more processors, the one or more processors are caused to execute any steps in the report verification and entry method. It can be understood that the readable storage medium in this embodiment may be a volatile readable storage medium or a non-volatile readable storage medium.
[0090] The above-described embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit them. Although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that they can still modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements for some of the technical features. These modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the various embodiments of the present invention and should all be included within the protection scope of the present invention.
Claims
1. A method for verifying and entering reports, characterized in that, Including: Obtain a sample report and a report to be entered; Obtain the title text and corresponding first data content in the sample report, and obtain at least one regular expression corresponding to the first data content according to the title text; Select and / or correct the regular expression according to the first data content to obtain a verification expression; Obtain the second data content in the report to be entered, and verify the second data content through the verification expression. If the verification is successful, enter the second data content into the database; If the verification fails, record the error information through a log file.
2. The report verification and entry method according to claim 1, wherein The obtaining at least one regular expression corresponding to the first data content according to the title text includes: Obtain a set of regular expressions corresponding to the pre-established data content and the mapping relationship between the pre-established keywords and regular expressions; Obtain the keywords in the title text, and obtain at least one regular expression from the set of regular expressions according to the keywords and the mapping relationship.
3. The report verification and entry method according to claim 1, wherein The selecting and / or correcting the regular expression according to the first data content to obtain a verification expression includes: When the title text corresponds to one regular expression, verify whether the regular expression is correct according to the first data content. If it is correct, select the regular expression as the verification expression. If it is incorrect, correct the regular expression according to the first data content, and use the corrected regular expression as the verification expression; When the title text corresponds to multiple regular expressions, verify the regular expressions according to the first data content. If at least one of the multiple regular expressions is verified successfully, select a verified successful regular expression as the verification expression. If all the multiple regular expressions fail the verification, first select the regular expression with the highest degree of conformity to the first data content, and then correct the regular expression with the highest degree of conformity according to the first data content to obtain a verification expression.
4. The report verification and entry method according to claim 1, wherein, The obtaining the second data content in the report to be entered and verifying the second data content through the verification expression includes: Obtain the second data content entered by the user in the data content input text box, and verify the second data content entered by the user in the data content input text box through the verification expression. The data content input text box is displayed on the report entry page.
5. The report verification and entry method according to claim 4, wherein The report verification and entry method further includes: Generate the report entry page according to the design instructions input by the user on the report design interface; wherein, the report design interface includes multiple component modules, each component module corresponds to a report element, and the design instructions include drag-and-drop operations and cell definition input operations.
6. The report verification and entry method according to claim 1, characterized in that The obtaining the second data content in the report to be entered and verifying the second data content through the verification expression includes: Import the report to be entered, extract all the second data content from the report to be entered, and verify all the second data content according to the verification expression.
7. The report verification and entry method according to claim 1, characterized in that, Said inputting the second data content into the database includes: Caching the second data content in a cache pool, and after the cache pool is full or all the second data content is completely verified, batch inputting all the second data content in the cache pool into the database.
8. A report verification and entry device, characterized in that, It includes: A report acquisition module, configured to acquire an example report and a report to be input; A rule acquisition module, configured to acquire the title text in the example report and the corresponding first data content, and acquire at least one regular expression corresponding to the first data content according to the title text; A rule correction module, configured to select and / or correct the regular expression according to the first data content to obtain a verification expression; A data verification module, configured to acquire the second data content in the report to be input, verify the second data content through the verification expression, and if the verification is successful, input the second data content into the database; If the verification fails, record the error information through a log file.
9. A computer device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the steps of the report verification and input method according to any one of claims 1 to 7.
10. A computer-readable storage medium storing a computer program, characterized in that, When the computer program is executed by the processor, it implements the steps of the report verification and input method according to any one of claims 1 to 7.