Intelligent auxiliary filling method and device

Abstract

The invention relates to the technical field of data filling and reporting, and particularly provides an intelligent auxiliary filling and reporting method and device, and the method comprises the following specific steps: S1, creating an auxiliary filling and reporting basic information table; s2, creating a form, and configuring form permissions according to department requirements; s3, based on user historical data field association, realizing automatic filling of a mapping relation between a field needing to be configured by form creation personnel and data center source data; s4, the user enters the service form for filling; s5, searching a mapping relation between a data source field related to the data source field and a current form field in a database; s6, providing personalized data recommendation service for the user; and S7, the user edits and modifies the automatically filled data according to the actual situation, and after modification is completed, the data is stored in the database and the personnel information table is updated. Compared with the prior art, the method and the device have the advantages that repeated input of the data can be reduced, the filling time of the user is reduced, and the data filling efficiency and accuracy are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of data reporting, and specifically provides an intelligent auxiliary reporting method and device. Background Art

[0002] In recent years, as relevant departments and enterprises actively promote digital transformation, more and more information is gradually changing from paper form to digital management. However, the current data reporting system still has significant pain points:

[0003] Faced with numerous complex related data, users have to perform a large number of repetitive manual input operations. This not only leads to the problem of repeated entry, greatly consumes human resources and reduces work efficiency, but also introduces the risk of data errors due to human factors, and greatly reduces the efficiency of data reporting. Improving reporting efficiency, reducing error rates, and improving user experience have become issues that need to be urgently addressed. Summary of the invention

[0004] The present invention aims at the deficiencies of the above-mentioned prior art and provides an intelligent auxiliary reporting method with strong practicality.

[0005] A further technical task of the present invention is to provide an intelligent auxiliary filling device with reasonable design, safety and applicability.

[0006] The technical solution adopted by the present invention to solve its technical problem is:

[0007] Intelligent assisted reporting method, which uses database query and data mapping technology, combined with user input information, automatically generates and fills in relevant data to achieve intelligent assisted reporting;

[0008] The specific steps are as follows:

[0009] S1. Create an auxiliary basic information table, the fields in the table include configuration form id, associated data source form id, configuration form field id, and associated data source field id;

[0010] S2. First, you need to create a form. The department designs the form according to the department's business, configures the form's unique key field information, and configures the form permissions according to the department's needs;

[0011] S3. Automatically fill in the required form based on the association of user historical data fields. Create a mapping relationship between personnel configuration fields and data center source data. Select the data source form, and then configure the mapping between form fields and data center source data fields to quickly bind data center data.

[0012] S4. The user enters the business form to fill in the form, searches for the auxiliary filling basic information table according to the business form ID, and determines whether auxiliary filling mapping relationships are set for each field in the form;

[0013] S5. First, according to the fields in the form, find the mapping relationship between the relevant data source fields and the current form fields in the database;

[0014] S6. For fields that do not have auxiliary reporting mapping, the collaborative filtering recommendation method is combined to provide users with personalized data recommendation services;

[0015] S7. The user edits and modifies the automatically filled data according to the actual situation. After the modification is completed, the data is saved to the database and the personnel information table is updated.

[0016] Furthermore, in step S2, the form field configuration attributes include whether it is unique, required, desensitized, displayed in a list, used as a query condition, uneditable, displayed on a mobile terminal, and whether it is encrypted and stored. For sensitive fields, desensitization rules need to be maintained.

[0017] Furthermore, when creating a form according to business needs, the field information needs to add the city, district, town, village, update time, person filling out the form, and data source fields by default. These fields are used to control data permissions and record data change time. The default fields cannot be deleted and are display columns by default.

[0018] Furthermore, in step S3, the form is associated with the data source form through a unique key. One form field can only be mapped to one data source field, but one data source field can be referenced by multiple form fields.

[0019] Furthermore, the data source refers to the source data of the data center. During the data source management process, it is necessary to configure the data source in detail, select the database type, configure the data source connection information, and effectively associate the form data with the source data of the data center.

[0020] Furthermore, in step S4, it is determined whether auxiliary reporting mapping relationships are set for each field in the form. If auxiliary reporting mapping relationships are set, the auxiliary reporting method step S5 is entered; if no auxiliary reporting mapping relationships are set, the intelligent recommendation method step S6 is entered.

[0021] Furthermore, in step S5, a query statement is used to retrieve matching data from the database. Afterwards, the returned results are processed accordingly according to the encryption and desensitizing attributes of the fields, and then organized into a format that is easy for users to understand and return. Part of the desensitized data will be replaced with a *** symbol, and the user can choose to remove the desensitization to view the complete data.

[0022] Furthermore, in step S6, the collaborative filtering recommendation method is:

[0023] (B1) using the user's unique identifier to determine whether the user is a new user, if the database has historical data of the current user, then the user is not a new user, and the process goes to step (B3); otherwise, the user is regarded as a new user, and the process goes to step (B4);

[0024] (B2) According to the current reporting requirements, historical data within a period of time is collected from the personnel information form. Since the data may not only be numerical data, the text data is converted into numerical data through label encoding, and the similarity scores between users are calculated through cosine similarity;

[0025] (B3) When the target user starts filling out the form, the similarity score between users is calculated by cosine similarity based on the user's login information and the filled-in field content;

[0026] (B4) finding other user data similar to the target user based on the similarity score, and recording the similarity score of the target user in the personnel information table for later use, querying the data reported by similar users in other fields, and generating a recommendation data for the target user;

[0027] (B5) If there are multiple fields to be recommended, the recommended content is sorted according to whether the field is required, its importance, and the frequency of filling in by similar users.

[0028] An intelligent auxiliary reporting device, comprising: at least one memory and at least one processor;

[0029] The at least one memory is used to store a machine-readable program;

[0030] The at least one processor is used to call the machine-readable program to execute the intelligent assisted reporting method.

[0031] Compared with the prior art, the intelligent auxiliary reporting method and device of the present invention has the following outstanding beneficial effects:

[0032] The present invention realizes automatic filling of data through the intelligent functions of auxiliary filling and intelligent recommendation methods, reduces repeated data entry, reduces the filling time of users, and improves the efficiency and accuracy of data filling.

[0033] At the same time, it can also be flexibly configured and expanded according to actual needs, suitable for data reporting needs in different scenarios, comprehensively optimizing the efficiency, security, user experience, flexibility and intelligent management level of data reporting, and providing strong power and security guarantees for the digital transformation of various industries. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0035] Attached Figure 1 It is a flowchart of the intelligent auxiliary reporting method;

[0036] Attached Figure 2 It is a flowchart of the collaborative filtering recommendation method in the intelligent assisted reporting method. DETAILED DESCRIPTION

[0037] In order to enable those skilled in the art to better understand the solution of the present invention, the present invention is further described in detail below in conjunction with specific implementation methods. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0038] A best embodiment is given below:

[0039] like Figure 1 As shown, the intelligent assisted reporting method in this embodiment aims to optimize the data entry process and improve data accuracy and efficiency through automated processing and intelligent matching.

[0040] By utilizing database query and data mapping technology, combined with user input information, relevant data is automatically generated and filled in to achieve intelligent assisted reporting.

[0041] The method comprises the following steps:

[0042] S1. Create an auxiliary reporting basic information table, the fields in the table include configuration form id, associated data source form id, configuration form field id, associated data source field id. Create a personnel information table, the table maintains the basic login information and reporting information of the personnel.

[0043] S2. First, you need to create a form. The department designs the form according to the department's business, configures the form's unique key and other field information, and configures the form permissions according to the department's needs.

[0044] Create a form according to business needs. The field information needs to add the city, district, town, village, update time, filler, and data source fields (user addition, data synchronization, data return) by default to control data permissions and record data change time. The default fields cannot be deleted and are displayed by default.

[0045] Desensitization rules need to be maintained for sensitive fields, and desensitization rules for ID card number, mobile phone number, name, address, email address, and bank card need to be supported. The ledger field configuration attributes include whether it is unique, required, desensitized, displayed in a list, used as a query condition, uneditable, displayed on the mobile terminal, and encrypted storage. Desensitized display is selected for the fields that are desensitized, and encrypted storage is required for the fields that are selected. The data type of the ledger can be configured as text, integer, decimal, date, time, single choice, multiple choice, etc., to meet the standard settings of various ledger data.

[0046] For sensitive data such as personnel names, contact information, and ID numbers, data desensitization is configured, and some desensitized data on the page will be replaced with ** symbols to ensure data security. By authorizing and managing different types of forms, the visible scope of ledger data can be controlled to avoid over-use of data.

[0047] S3. To achieve automatic filling based on the association of user historical data fields, the form creator needs to configure the mapping relationship between the fields and the data center source data, select the data source form, and then configure the mapping between the form fields and the data center source data fields to quickly bind the data center data. The form is associated with the data source form through a unique key. A form field can only be mapped to one data source field, but a data source field can be referenced by multiple form fields.

[0048] The data source mainly refers to the source data of the data center. In the process of data source management, it is necessary to configure the data source in detail, select the database type, and configure the data source connection information, including specifying the physical path, logical path, library table name, data access permission, etc. of the data source, so as to effectively associate the ledger data with the source data of the data center. In this way, the accuracy and integrity of the data can be ensured, providing a reliable foundation for subsequent data processing and analysis.

[0049] S4. The user enters the business form to fill in the form, searches the auxiliary filling basic information table according to the business form ID, and determines whether the auxiliary filling mapping relationship is set for each field in the form. If the auxiliary filling mapping relationship is set, enter the auxiliary filling method step S5; if the auxiliary filling mapping relationship is not set, enter the intelligent recommendation method step S6.

[0050] S5 is an auxiliary reporting method. First, according to the fields in the form, the mapping relationship between the relevant data source fields and the current form fields is searched in the database. Then, according to the primary key field data and the field mapping relationship table entered by the user, an SQL query statement is dynamically constructed. The query statement is used to retrieve matching data from the database.

[0051] Afterwards, the returned results are processed accordingly according to the encryption and desensitization attributes of the fields, such as date format conversion or data decryption, and then organized into a format that is easy for users to understand and return. The desensitized part of the data will be replaced with a *** symbol, and users can choose to remove the desensitization to view the complete data.

[0052] S6 is an intelligent recommendation method. For fields that do not have auxiliary reporting mapping, it combines collaborative filtering recommendation methods to provide users with personalized data recommendation services.

[0053] S7. The user can edit and modify the automatically filled data according to the actual situation. After the modification is completed, save the data to the database and update the personnel information table.

[0054] By authorizing and managing different types of forms, the visible scope of form data can be controlled to avoid overreaching of data usage. Specifically, permissions can be set for different users. Ordinary users can only query form data under the current department, administrators can view form data under the current division, and super administrators can view all data in all forms. The creator of the form can manage the permissions of the form and grant different permissions to people in different departments, including viewing permissions, editing permissions, approval permissions, etc.

[0055] The collaborative filtering recommendation method is:

[0056] (B1) using the user's unique identifier (such as user name, ID, etc.) to determine whether the user is a new user. If the database contains historical data of the current user, the user is not a new user and the process proceeds to step (B3). Otherwise, the user is considered a new user and the process proceeds to step (B4).

[0057] (B2) According to the current reporting requirements, historical data within a period of time is collected from the personnel information form. Since the data may not only be numerical data, the text data is converted into numerical data through label encoding, and the similarity scores between users are calculated through cosine similarity;

[0058] (B3) When the target user starts filling out the form, the similarity score between users is calculated by cosine similarity based on the user's login information and the filled-in field content;

[0059] (B4) finding other user data similar to the target user based on the similarity score, and recording the similarity score of the target user in the personnel information table for later use, querying the data reported by similar users in other fields, and generating a recommendation data for the target user;

[0060] (B5) If there are multiple fields to be recommended, the recommended content is sorted according to whether the field is required, its importance, and the frequency of filling in by similar users.

[0061] Based on the above method, the intelligent auxiliary reporting device in this embodiment includes: at least one memory and at least one processor;

[0062] The at least one memory is used to store a machine-readable program;

[0063] The at least one processor is used to call the machine-readable program to execute the intelligent assisted reporting method.

[0064] The above-mentioned specific implementations are only specific cases of the present invention. The patent protection scope of the present invention includes but is not limited to the above-mentioned specific implementations. Any technical solutions that conform to the above-mentioned specific implementations of the present invention and any appropriate changes or substitutions made by ordinary technicians in the relevant technical field shall fall within the patent protection scope of the present invention.

[0065] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.

Claims

1. Intelligent auxiliary reporting method, characterized in that: Utilize database query and data mapping technology, combined with user input information, to automatically generate and fill in relevant data, and realize intelligent auxiliary reporting; The specific steps are as follows: S1. Create an auxiliary basic information table, the fields in the table include configuration form id, associated data source form id, configuration form field id, and associated data source field id; S2. First, you need to create a form. The department designs the form according to the department's business, configures the form's unique key field information, and configures the form permissions according to the department's needs; S3. Automatically fill in the required form based on the association of user historical data fields. Create a mapping relationship between personnel configuration fields and data center source data. Select the data source form, and then configure the mapping between form fields and data center source data fields to quickly bind data center data. S4. The user enters the business form to fill in the form, searches for the auxiliary filling basic information table according to the business form ID, and determines whether the auxiliary filling mapping relationship is set for each field in the form; S5. First, according to the fields in the form, find the mapping relationship between the relevant data source fields and the current form fields in the database; S6. For fields that do not have auxiliary reporting mapping, the collaborative filtering recommendation method is combined to provide users with personalized data recommendation services; S7. The user edits and modifies the automatically filled data according to the actual situation. After the modification is completed, the data is saved to the database and the personnel information table is updated.

2. The intelligent auxiliary reporting method according to claim 1 is characterized in that: In step S2, the form field configuration attributes include whether it is unique, required, desensitized, displayed in a list, used as a query condition, uneditable, displayed on a mobile terminal, and whether it is encrypted and stored. For sensitive fields, desensitization rules need to be maintained.

3. The intelligent auxiliary reporting method according to claim 2 is characterized in that: Create a form according to business needs. The field information needs to add the city, district, town, village, update time, person filling out the form and data source fields by default. These fields are used to control data permissions and record data change time. The default fields cannot be deleted and are display columns by default.

4. The intelligent auxiliary reporting method according to claim 3 is characterized in that: In step S3, the form is associated with the data source form through a unique key. One form field can only be mapped to one data source field, but one data source field can be referenced by multiple form fields.

5. The intelligent auxiliary reporting method according to claim 4 is characterized in that: The data source refers to the source data of the data center. During the data source management process, it is necessary to configure the data source in detail, select the database type, configure the data source connection information, and effectively associate the form data with the source data of the data center.

6. The intelligent auxiliary reporting method according to claim 5 is characterized in that: In step S4, it is determined whether auxiliary reporting mapping relationships are set for each field in the form. If auxiliary reporting mapping relationships are set, the auxiliary reporting method step S5 is entered; if no auxiliary reporting mapping relationships are set, the intelligent recommendation method step S6 is entered.

7. The intelligent auxiliary reporting method according to claim 6, characterized in that: In step S5, the query statement is used to retrieve the matching data from the database. After that, the returned results are processed accordingly according to the encryption attributes and desensitization attributes of the fields, and then organized into a format that is easy for users to understand and return. The desensitized part of the data will be replaced by the *** symbol, and the user can choose to remove the desensitization to view the complete data.

8. The intelligent auxiliary reporting method according to claim 7, characterized in that: In step S6, the collaborative filtering recommendation method is: (B1) using the user's unique identifier to determine whether the user is a new user, if the database has historical data of the current user, then the user is not a new user, and the process goes to step (B3); otherwise, the user is regarded as a new user, and the process goes to step (B4); (B2) According to the current reporting requirements, historical data within a period of time is collected from the personnel information form. Since the data may not only be numerical data, the text data is converted into numerical data through label encoding, and the similarity scores between users are calculated through cosine similarity; (B3) When the target user starts filling out the form, the similarity score between users is calculated by cosine similarity based on the user's login information and the filled-in field content; (B4) finding other user data similar to the target user based on the similarity score, and recording the similarity score of the target user in the personnel information table for later use, querying the reported data of similar users in other fields, and generating a recommendation data for the target user; (B5) If there are multiple fields to be recommended, the recommended content is sorted according to whether the field is required, its importance, and the frequency of filling in by similar users.

9. Intelligent auxiliary reporting device, characterized in that: include: at least one memory and at least one processor; The at least one memory is used to store a machine-readable program; The at least one processor is configured to call the machine-readable program to execute the method according to any one of claims 1 to 8.

Images