CN109447820B - Data processing method, device, computer equipment and storage medium - Google Patents
Data processing method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109447820B CN109447820B CN201811084480.9A CN201811084480A CN109447820B CN 109447820 B CN109447820 B CN 109447820B CN 201811084480 A CN201811084480 A CN 201811084480A CN 109447820 B CN109447820 B CN 109447820B
- Authority
- CN
- China
- Prior art keywords
- data
- audit
- content
- identifier
- basic
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data processing method, a device, computer equipment and a storage medium, wherein the method comprises the following steps: when receiving an application form uploaded by a client, generating a basic form identifier according to a preset form identifier generation mode, storing the corresponding relation between the application form and the basic form identifier, the application form and the basic form identifier into a database, acquiring the audit form identifier and the audit form contained in the audit form identifier when receiving an audit request sent by a management end, acquiring the basic form identifier corresponding to the audit form identifier from the database, acquiring a corresponding target application form according to the corresponding relation, writing the content in the target application form into the corresponding position of the audit form by using a preset script, and sending the data content to the management end, so that the audit data in the audit form is automatically generated, and the audit personnel in the client are presented for review, thereby improving the filling efficiency and the accuracy of the audit form.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a data processing method, a data processing device, a computer device, and a storage medium.
Background
With the development of social economy, people pay more attention to insurance financial products, the data volume of an insurance financial system is increased, the processing of insurance data is more frequent, in the current insurance financial system, a business operator needs to upload a business application form when transacting business, an approval person needs to fill in approval form information aiming at the application form, and if necessary, relevant contents in the application form are adjusted appropriately according to the strategic layout of a current enterprise.
In the current insurance approval process, due to the fact that the application form and the auditing form relate to more data, when an approval person is required to fill in a large amount of data which is the same as or related to the application form in comparison with the application form in auditing, the manual filling mode of the large amount of data is easy to cause data filling errors, so that the accuracy of filling in the auditing form is low, and the efficiency is low.
Disclosure of Invention
The embodiment of the invention provides a data processing method, a data processing device, computer equipment and a storage medium, which are used for solving the problems of low filling accuracy and low efficiency of an approval form caused by manually filling the approval form.
A data processing method, comprising:
if an application form uploaded by a client is received, generating a basic form identifier according to a preset form identifier generation mode, wherein the application form comprises at least one piece of basic data, and each piece of basic data comprises data content and data identifiers;
Establishing a corresponding relation between the application form and the basic form identifier, and storing the application form, the basic form identifier and the corresponding relation into a preset database;
if an audit request sent by a management end is received, acquiring an audit form identifier and an audit form contained in the audit request, wherein the audit form comprises audit data, and each audit data comprises data content and data identifier;
acquiring a basic form identifier which is the same as the auditing form identifier from the preset database, taking the basic form identifier as a target form identifier, and acquiring an application form corresponding to the target form identifier according to the corresponding relation, and taking the application form as a target application form;
obtaining basic data with the same data identification as the auditing data in the auditing table from the target application table as effective data;
using a preset script to assign the data content of the effective data to the data content of the audit data with the same data identification as the effective data;
and sending the assigned data content of the auditing data to the management end, so that auditing personnel of the management end audit the data content of the auditing data.
A data processing apparatus comprising:
the system comprises an identifier generation module, a client and a client, wherein the identifier generation module is used for generating a basic form identifier according to a preset form identifier generation mode if an application form uploaded by the client is received, the application form comprises at least one piece of basic data, and each piece of basic data comprises data content and data identifiers;
the mapping establishing module is used for establishing a corresponding relation between the application form and the basic form identifier and storing the application form, the basic form identifier and the corresponding relation into a preset database;
the audit table acquisition module is used for acquiring audit table identifiers and audit tables contained in the audit request if the audit request sent by the management terminal is received, wherein the audit tables comprise audit data, and each audit data comprises data content and data identifiers;
the target table acquisition module is used for acquiring a basic table identifier which is the same as the auditing table identifier from the preset database, taking the basic table identifier as a target table identifier, and acquiring an application table corresponding to the target table identifier according to the corresponding relation, and taking the application table as a target application table;
the data acquisition module is used for acquiring basic data with the same data identification as the auditing data in the auditing table from the target application table as effective data;
The data assignment module is used for assigning the data content of the effective data to the data content of the audit data with the same data identification as the effective data by using a preset script;
and the data transmitting module is used for transmitting the assigned data content of the audit data to the management end, so that audit personnel of the management end audit the data content of the audit data.
A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the data processing method described above when the computer program is executed.
A computer readable storage medium storing a computer program which, when executed by a processor, implements the steps of the data processing method described above.
According to the data processing method, the device, the computer equipment and the storage medium, when the application form uploaded by the client is received, a basic form identifier is generated according to a preset form identifier generation mode, the corresponding relation between the application form and the basic form identifier, the application form and the basic form identifier are stored in the database, when an audit request sent by the management end is received, the audit form identifier and the audit form contained in the audit request are acquired, the basic form identifier which is the same as the audit form identifier is acquired from the database and used as a target form identifier, the application form corresponding to the target form identifier is acquired according to the corresponding relation and used as a target application form, further, basic data with the same data identifier as audit data in the audit form is acquired from the target application form and used as effective data, the preset script is used, the data content of the effective data is assigned to the data content of the audit data, and the data content of the audit data is sent to the management end after the data content of the audit data is assigned to the audit end, the audit personnel can carry out audit on the data content of the audit data, automatic generation of the data in the audit form is realized, and the data efficiency of the audit personnel is improved and the data content of the audit data is correctly filled out by the audit personnel.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the description of the embodiments of the present invention will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of an application environment of a data processing method according to an embodiment of the present invention;
FIG. 2 is a flowchart of an implementation of a data processing method provided by an embodiment of the present invention;
fig. 3 is a flowchart illustrating implementation of step S60 in the data processing method according to the embodiment of the present invention;
FIG. 4 is a flowchart of a method for implementing quick filling of audit data according to basic data associated with the audit data in a data processing method according to an embodiment of the present invention;
FIG. 5 is a flowchart for updating the data content of the effective data according to the audit coefficient in the data processing method according to the embodiment of the present invention;
FIG. 6 is a flowchart illustrating modification of the audit data in the data processing method according to the embodiment of the present invention;
FIG. 7 is a schematic diagram of a data processing apparatus according to an embodiment of the present invention;
Fig. 8 is a schematic diagram of a computer device according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Referring to fig. 1, fig. 1 illustrates an application environment of a data processing method according to an embodiment of the present invention. The data processing method is applied to the data filling scene of the approval form in the insurance field. The data filling scene comprises a server, a client and a management end, wherein the server and the client are connected through a network, the server and the monitoring end are connected through the network, the client uploads an application form to the server, the server receives and stores the application form, and when an audit request is received, filling of contents in the audit form is automatically completed according to the application form, the filled audit form is sent to the management end, and the management end audits the audit form contents and modifies the audit form contents as required. The client and the management end can be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers and portable wearable devices, and the server can be realized by an independent server or a server cluster formed by a plurality of servers.
Referring to fig. 2, fig. 2 shows a data processing method according to an embodiment of the present invention, and the method is applied to the server in fig. 1 for illustration, and is described in detail as follows:
s10: if the application form uploaded by the client is received, generating a basic form identifier according to a preset form identifier generation mode, wherein the application form comprises at least one piece of basic data, and each piece of basic data comprises data content and data identifiers.
Specifically, a service person inputs data content of basic data of an application form at a client, uploads the application form to a server after finishing the input of the application form, and the server receives the application form through a network transmission protocol and generates a unique single number according to a preset form identification generation mode.
The preset form identifier generating mode may be set according to actual requirements, which is not limited herein, for example, the form generating mode of a vehicle insurance application form is: the first letter is Q, the 8 digits behind Q represent the organization number, the 13 digits behind the organization number represent the policy serial number, and the generated insurance policy is identified as Q090100190000007833027.
The application form comprises one or more pieces of basic data, each piece of basic data comprises data content and data identification, the data identification is used for uniquely identifying the basic data, and the data identification of each piece of basic data corresponds to the data content of the basic data.
For example, in one embodiment, a submitter enters an application form for a vehicle insurance comprising basic data: the number of the vehicles to be hung, the number of the single insurance traffic intensity, the proportion of the applied sales cost, the channel coefficient and the like are shown in fig. 1, a brief example is taken as basic data of the number of the vehicles to be hung, the data content of the basic data is 35, the data mark is GKCLTS, and after a submitter uploads the application form to a background server through a client, the background server automatically generates a single number Q090100190000007833027 for the application form.
Among them, network transport protocols include, but are not limited to: internet control message protocol (Internet Control Message Protocol, ICMP), address resolution protocol (ARP Address Resolution Protocol, ARP), and file transfer protocol (File Transfer Protocol, FTP), among others.
S20: establishing a corresponding relation between the application form and the basic form identifier, and storing the application form, the basic form identifier and the corresponding relation into a preset database.
Specifically, after the basic form identifier is generated, the corresponding relation between the application form and the basic form identifier is established, and the application form, the basic form identifier and the corresponding relation are stored into a preset database, so that when the basic data in the application form is needed to be used later, the new application can be obtained through the basic form identifier and the corresponding relation, and the basic data in the application form can be read.
S30: if an audit request sent by a management end is received, an audit form identifier and an audit table contained in the audit request are obtained, wherein the audit table comprises audit data, and each audit data comprises data content and data identifier.
Specifically, after an auditing personnel of the management end starts an auditing function, the management end sends an auditing request to the service end, the service end receives the auditing request and acquires an auditing form identifier and an auditing table contained in the auditing request, wherein the auditing table comprises auditing data, and each auditing data comprises data content and data identifier.
For example, an audit table includes two audit data, namely audit data 1 and audit data 2, wherein the data of audit data 1 is identified as GKCLTS, the data content of audit data 1 is empty, the audit personnel is required to fill in, the data of audit data 2 is identified as DBJQTS, and the data content of audit data 2 is empty, and the audit personnel is required to fill in.
It is worth to say that the auditing table is selected from preset auditing table templates according to auditing types by the server side, and each auditing table is used for auditing an application table, so that the obtained auditing table identification is the same as a basic table identification stored in a preset database.
S40: and acquiring a basic form identifier which is the same as the auditing form identifier from a preset database, taking the basic form identifier as a target form identifier, and acquiring an application form corresponding to the target form identifier according to the corresponding relation, and taking the application form as a target application form.
Specifically, a traversing mode is adopted, a basic form identifier identical to the auditing form identifier is obtained from a preset database and is used as a target form identifier, and an application form corresponding to the target form identifier is determined according to the corresponding relation between the application form and the basic form identifier in the step S20 and is used as a target application form.
For example, in a specific embodiment, the auditing form identifier is Q090100190000007833027, the basic form identifier identified as Q090100190000007833027 is found by traversing the basic form identifiers in the preset database, the basic form identifier is used as the target form identifier, and the application form with the application form name of "fee 4 verification" corresponding to the target form identifier is found according to the stored correspondence, and the application form is used as the target application form.
Wherein, traversal (Traversal) refers to access to information of all nodes in the node tree of the policy data in the task table, i.e. each node in the node tree is accessed once and only once in turn. Traversing means include, but are not limited to: preamble traversal, midamble traversal, and postamble traversal, etc.
Preferably, the traversal method used in the embodiment of the present invention is a preamble traversal, where the sequence of the preamble traversal includes NLR or NRL, where N refers to a root (Node), L refers to a Left Node (Left subtree) of the root, and R refers to a Right Node (Right subtree) of the root.
It should be noted that, the objective of the traversal operation in this step is to obtain the basic form identifier identical to the audit form identifier from the preset database, and each basic form identifier only appears once in all the basic form identifiers of the preset database, so the embodiment of the invention provides a preferred scheme, that is, in the basic form identifiers of the preset database, a basic form identifier identical to the audit form identifier is found, that is, the traversal is ended, and the basic form identifier is used as the traversal result, that is, the target expression identifier.
S50: and obtaining basic data with the same data identification as the auditing data in the auditing table from the target application table as effective data.
Specifically, each piece of audit data contained in the audit table is obtained, a data identifier of the audit data is obtained for each piece of audit data, and basic data with the same data identifier as the data identifier of the audit data is selected from the obtained target application table to serve as effective data.
Taking the application form of the vehicle insurance in step S10 as an example, in a specific embodiment, the target application form is an application form corresponding to the single number Q090100190000007833027, the data identifier of one obtained audit data is GKCLTS, then the basic data "number of vehicles to be attached" of the data identifier of the target application form is selected as the basic data "number of vehicles to be attached" of the GKCLTS, and the basic data "number of vehicles to be attached" is taken as one effective data.
It should be understood that each piece of effective data corresponds to one piece of basic data, and the effective data and the basic data with the corresponding relation have the same data identifier.
S60: and assigning the data content of the effective data to the data content of the audit data with the same data identification as the effective data by using a preset script.
Specifically, by using a preset script, the data content of the effective data is assigned to the data content of the audit data with the same data identifier as the effective data, so that the audit data in the audit table is automatically filled.
The preset script is used for acquiring the data content of the effective data, writing the data content of the effective data into the data content of the audit data with the same data identification as the effective data, and the script types of the preset script include but are not limited to: shell script, javaScript script, lua script, python script, etc., preferably JavaScript is used in this embodiment.
S70: and sending the data content of the assigned auditing data to the management end, so that auditing personnel of the management end audit the data content of the auditing data.
Specifically, the audit data filled with the data content is sent to the management end through a network transmission protocol, so that audit personnel of the management end audit the data content of the audit data.
In this embodiment, when receiving an application form uploaded by a client, according to a preset form identifier generation mode, generating a basic form identifier corresponding to the application form, establishing a corresponding relation between the application form and the basic form identifier, storing the application form, the basic form identifier and the corresponding relation into a database, when receiving an audit request sent by a management end, acquiring the audit form identifier and the audit form contained in the audit request, acquiring the basic form identifier identical to the audit form identifier from the database as a target form identifier, acquiring the application form corresponding to the target form identifier as a target application form, further acquiring basic data with identical data identifier as audit data in the audit form from the target application form, using the preset script again, assigning the data content of the effective data to the data content of the audit data, and sending the data content of the audit data to the management end, so that audit personnel of the management end can review the data content of the audit data, automatically generate the data content of the audit data in the audit form, display the audit data to the client, and improve the efficiency and correct rate of filling out the audit data.
Based on the corresponding embodiment of fig. 2, a detailed description will be given below of a specific implementation method for assigning the data content of the valid data to the data content of the audit data having the same data identifier as the valid data using the preset script mentioned in step S60 by using a specific embodiment.
Referring to fig. 3, fig. 3 shows a specific implementation flow of step S60 provided in the embodiment of the present invention, which is described in detail below:
s61: and acquiring data content corresponding to the data identifier based on the data identifier in the effective data as the content to be copied.
Specifically, according to the data identifier of the effective data, the data content corresponding to the data identifier is obtained and used as the content to be copied.
For example, the data of one valid data is identified as GKCLTS, the data content of the valid data corresponding to the identification is "35", and the data content "35" is taken as the content to be copied.
S62: copying the content to be copied to the clipboard by using the assignment class in the preset script.
Specifically, the assignment class adopted in the present embodiment is a Zero Clipboard class, and the content to be copied is copied into the temporary cut-out board by a Clipboard.
The Zero Clipboard is a class for copying the Clipboard, the copying function across the browser is realized based on Flash, when the function in the Zero Clipboard class is called, the class creates a transparent Flash area in the background, the Flash area is used as a temporary Clipboard, and the copied content is temporarily stored in the Flash area, so that the copying across the browser is realized without influencing the current user interface. "Zero" in Zero Clipboard means "invisible, zero interference".
It is worth to describe that the temporary clipboard can store a plurality of contents to be copied at the same time, and each content to be copied inherits the data identifier of the effective data corresponding to the content to be copied.
S63: and obtaining audit data with the same data identification as the valid data as target data.
Specifically, in a traversal manner, audit data having the same data identifier as the valid data is acquired from audit data of an audit table as target data.
S64: and writing the content in the clipboard into the data content of the target data through the assignment class to serve as the data content of the target data.
Specifically, the content to be copied is copied into the temporary cut-out by assigning a Clipboard.
In this embodiment, based on the data identifier in the effective data, the data content corresponding to the data identifier is obtained and is used as the content to be copied, and the assignment class in the preset script is used to copy the content to be copied to the clipboard, so as to obtain the audit data with the same data identifier as the effective data, and then the assignment class is used to write the content in the clipboard into the data content of the target data and is used as the data content of the target data, thereby realizing the rapid copying of the data content of the effective data into the data content of the audit data and improving the filling efficiency of the core table.
In one embodiment, as shown in fig. 4, after step S40, before step S70, the audit data and the base data do not have the same data identifier, but have an association between the data identifiers, and the audit data needs to be quickly filled according to the base data associated with the audit data, and the data processing method further includes:
s101: and acquiring basic data with relevance between the data identification of the basic data and the data identification of the auditing data in the auditing table from the target application table as relevant data.
Specifically, some audit data exist, which do not have the same data identifier as the basic data, but are associated with one or more basic data, i.e. the data content of the audit data can be determined according to the data content of one or more basic data, at this time, the basic data with the correlation between the data identifier of the basic data and the data identifier of the audit data in the audit table is obtained from the target application table as the correlation data.
It is worth to say that different audit table templates correspond to different audit tables, and data identifiers of audit data with relevance in the audit tables and data identifiers of corresponding basic data are recorded in the audit table templates.
For example, in one embodiment, an audit data is a premium total, the data identifier is BFZE, two basic data associated with the audit data exist in the basic data, namely, premium 1 and premium 2, and the data identifiers of the two basic data are BF1 and BF2, respectively, and the data identifiers of the audit data are different from the data identifiers of the two basic data, but a preset association relationship exists in the audit table template, that is, the premium total has an association with the basic data of each identified premium, so that the three data can be determined as association data.
S102: and calculating the data content of the auditing data in the auditing table associated with the associated data through the data content of the associated data and a preset formula.
Specifically, a calculation formula among the associated data is preset in a template of the audit table, and the data content of the audit data is calculated through the calculation formula and the data content of the basic data contained in the associated data.
Continuing with the example in step S101, the preset calculation formula of the associated data is: premium total = premium 1+ premium 2, and thus, the data contents of premium 1 and premium 2 are added, and the obtained result is taken as the data content of premium total.
In this embodiment, the basic data with correlation between the data identifier of the basic data and the data identifier of the audit data in the audit table is obtained from the target application table and is used as the correlation data, and the data content of the audit data in the audit table correlated with the correlation data is obtained through calculation by using the data content of the correlation data and a preset formula, so that the data content of the audit data of the audit table can be obtained through calculation by using the data content of the basic data of the correlated application table, and the automatic filling of the audit table can be realized only by copying the obtained data content of the audit data to the corresponding position of the audit table, thereby improving the filling efficiency of the audit table.
In one embodiment, as shown in fig. 5, after step S50, before step S70, the data content of the valid data is updated according to the received audit coefficient, and the data processing method further includes:
s201: and if the verification coefficient sent by the auditor through the management end is received, acquiring the verification coefficient, and multiplying the data content of the effective data by the verification coefficient to obtain updated effective data.
Specifically, the auditor can adjust some business data in batches according to the current business requirement, namely, set verification coefficients for some audit data, update the data content of the effective data by using the verification coefficients, namely, multiply the verification coefficients by the data content of the effective data, and take the obtained result as the updated data content of the effective data.
For example, in one embodiment, a valid data is used to identify the insurance standard premium amount, the data of the valid data is identified as CXBZBF, the data content of the valid data is 260.00, the obtained verification coefficient is 1.1, and the data content of the updated valid data is 286.00.
It should be noted that, one verification coefficient may be specific to one piece of valid data, may be specific to a plurality of pieces of valid data, or may be specific to different valid data, and may be specifically determined according to actual situations, which is not limited herein.
S202: and assigning the data content of the updated effective data to the data content of the audit data with the same data identification as the effective data by using a preset script.
Specifically, the data content of the updated valid data is assigned to the data content of the audit data having the same data identifier as the valid data by using the preset script, and the specific process may refer to the description of step S60, or the method provided in steps S61 to S64 is used, so that repetition is avoided and no further description is given here.
In this embodiment, if the verification coefficient sent by the auditor through the management end is received, the verification coefficient is obtained, the data content of the effective data is multiplied by the verification coefficient to obtain updated effective data, and the data content of the updated effective data is assigned to the data content of the audit data with the same data identifier as the effective data by using the preset script, so that filling of the audit table can be completed quickly according to the verification coefficient given by the auditor, and filling efficiency of the audit table is improved.
In one embodiment, as shown in fig. 6, after step S70, if a modification request sent by the management end is received, the request is processed, and the data processing method further includes:
s301: and if the modification request uploaded by the management end is received, acquiring modification data in the modification request.
Specifically, after the data content of the audit data is sent to the management end through step S70, the audit personnel of the management end audit the data content of the audit data, and according to the actual situation, when the audit data needs to be modified, a modification request is generated and sent to the server end, the server end receives the modification request, and modification data in the modification request is obtained, wherein the modification data comprises a data identifier and data content.
S302: and acquiring assigned audit data with the same data identifier as the modification data, and taking the audit data as the data to be modified.
Specifically, the assigned audit data with the same data identifier as the modified data is obtained from all the assigned audit data of the audit table and is used as the data to be modified.
S303: and replacing the data content of the data to be modified with the data content in the modified data.
Specifically, the data content of the data to be modified is replaced by the data content in the modification data, so that the data to be modified is updated.
S304: and sending the data content of the replaced data to be modified to the management end so that an auditing personnel of the management end can audit the data content of the auditing data.
Specifically, the data content of the replaced data to be modified is sent to the management end through a network transmission protocol, so that an auditing person of the management end can audit the data content of the auditing data.
In this embodiment, when a modification request uploaded by a management end is received, modification data in the modification request is obtained, and assigned audit data with the same data identifier as the modification data is obtained to be used as data to be modified, and further, data content of the data to be modified is replaced by data content in the modification data, and the replaced data content of the data to be modified is sent to the management end, so that audit personnel of the management end audit the data content of the audit data, quick response to the modification request is achieved, modification of the audit data by audit personnel is facilitated, and efficiency of filling an audit table is improved.
It should be understood that the sequence number of each step in the foregoing embodiment does not mean that the execution sequence of each process should be determined by the function and the internal logic, and should not limit the implementation process of the embodiment of the present invention.
Fig. 7 shows a schematic block diagram of a data processing apparatus in one-to-one correspondence with the data processing method of the above embodiment. As shown in fig. 7, the data processing apparatus includes an identification generating module 10, a mapping establishing module 20, an audit table acquiring module 30, a target table acquiring module 40, a data acquiring module 50, a data assigning module 60, and a data transmitting module 70. The functional modules are described in detail as follows:
the identifier generating module 10 is configured to generate a basic form identifier according to a preset form identifier generating manner if an application form uploaded by the client is received, where the application form includes at least one piece of basic data, and each piece of basic data includes data content and a data identifier;
the mapping establishing module 20 is configured to establish a correspondence between the application form and the base form identifier, and store the application form, the base form identifier, and the correspondence into a preset database;
the audit table acquisition module 30 is configured to acquire an audit table identifier and an audit table included in the audit request if an audit request sent by the management end is received, where the audit table includes audit data, and each audit data includes a data content and a data identifier;
The target table obtaining module 40 is configured to obtain, from a preset database, a basic table identifier that is the same as the audit table identifier, as a target table identifier, and obtain, according to a correspondence, an application table corresponding to the target table identifier, as a target application table;
the data acquisition module 50 is configured to acquire, from the target application form, base data having the same data identifier as the audit data in the audit form as valid data;
the data assignment module 60 is configured to assign, using a preset script, data contents of the valid data to data contents of audit data having the same data identifier as the valid data;
the data transmitting module 70 is configured to transmit the assigned data content of the audit data to the management end, so that an audit personnel of the management end performs audit on the data content of the audit data.
Further, the data assignment module 60 includes:
the content to be copied acquisition unit is used for acquiring data content corresponding to the data identifier based on the data identifier in the effective data as the content to be copied;
the content copying unit to be copied is used for copying the content to be copied to the cutting board by using the assignment class in the preset script;
the target data acquisition unit is used for acquiring audit data with the same data identifier as the effective data as target data;
And the data content acquisition unit of the target data is used for writing the content in the clipboard into the data content of the target data through the assignment class as the data content of the target data.
The data processing apparatus further includes:
the associated data acquisition module is used for acquiring basic data with association between the data identification of the basic data and the data identification of the audit data in the audit table from the target application table as associated data;
and the calculation module is used for calculating the data content of the audit data in the audit table associated with the associated data through the data content of the associated data and a preset formula.
The data processing apparatus further includes:
the updating module is used for acquiring the verification coefficient if the verification coefficient sent by the auditor through the management end is received, and multiplying the data content of the effective data by the verification coefficient to obtain updated effective data;
and the assignment module is used for assigning the data content of the updated effective data to the data content of the audit data with the same data identifier as the effective data by using a preset script.
The data processing apparatus further includes:
the modification data acquisition module is used for acquiring modification data in the modification request if the modification request uploaded by the management end is received;
The data to be modified is used for acquiring the assigned audit data with the same data identifier as the modified data as the data to be modified;
a replacing module, configured to replace data content of the data to be modified with data content in the modification data;
the data sending module is used for sending the data content of the replaced data to be modified to the management end, so that an auditor of the management end can audit the data content of the audit data.
For specific limitations of the data processing apparatus, reference may be made to the above limitations of the data processing method, and no further description is given here. Each of the modules in the above-described data processing apparatus may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
Fig. 8 is a schematic diagram of a computer device according to an embodiment of the present invention. The computer device may be a server, and its internal structure may be as shown in fig. 8. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer device is used for storing application forms, basic form identifiers, corresponding relations and the like. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a data processing method.
In one embodiment, a computer device is provided that includes a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the data processing method of the above embodiments when the computer program is executed, such as steps S10 to S70 shown in fig. 2. Alternatively, the processor when executing a computer program implements the functions of the modules/units of the data processing apparatus of the above embodiment, such as the functions of the modules 10 to 70 shown in fig. 7. In order to avoid repetition, a description thereof is omitted.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions.
In an embodiment, a computer readable storage medium is provided, on which a computer program is stored, which computer program when being executed by a processor implements the steps of the data processing method of the above embodiment, or which computer program when being executed by a processor implements the functions of the modules/units in the data processing apparatus of the above embodiment. In order to avoid repetition, a description thereof is omitted.
It will be appreciated that the computer readable storage medium may comprise: any entity or device capable of carrying the computer program code, a recording medium, a U disk, a removable hard disk, a magnetic disk, an optical disk, a computer Memory, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), an electrical carrier wave signal, a telecommunications signal, and the like.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the 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 scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention.
Claims (8)
1. A data processing method, characterized in that the data processing method comprises:
if an application form uploaded by a client is received, generating a basic form identifier according to a preset form identifier generation mode, wherein the application form comprises at least one piece of basic data, and each piece of basic data comprises data content and data identifiers;
Establishing a corresponding relation between the application form and the basic form identifier, and storing the application form, the basic form identifier and the corresponding relation into a preset database;
if an audit request sent by a management end is received, acquiring an audit form identifier and an audit form contained in the audit request, wherein the audit form comprises audit data, and each audit data comprises data content and data identifier;
acquiring a basic form identifier which is the same as the auditing form identifier from the preset database, taking the basic form identifier as a target form identifier, and acquiring an application form corresponding to the target form identifier according to the corresponding relation, and taking the application form as a target application form;
acquiring basic data with relevance between a data identifier of basic data and a data identifier of audit data in the audit table from the target application table as relevant data;
calculating the data content of the auditing data in the auditing table associated with the associated data through the data content of the associated data and a preset formula;
obtaining basic data with the same data identification as the auditing data in the auditing table from the target application table as effective data;
Using a preset script to assign the data content of the effective data to the data content of the audit data with the same data identification as the effective data;
if a verification coefficient sent by an auditor through the management end is received, acquiring the verification coefficient, and multiplying the data content of the effective data by the verification coefficient to obtain updated effective data;
using the preset script to assign the data content of the updated effective data to the data content of the audit data with the same data identification as the effective data;
and sending the assigned data content of the auditing data to the management end, so that auditing personnel of the management end audit the data content of the auditing data.
2. The data processing method as claimed in claim 1, wherein assigning the data content of the effective data to the data content of the audit data having the same data identification as the effective data using a preset script comprises:
based on a data identifier in the effective data, acquiring data content corresponding to the data identifier as content to be copied;
copying the content to be copied to a clipboard by using the assignment class in the preset script;
Obtaining audit data with the same data identification as the effective data as target data;
and writing the content in the clipboard into the data content of the target data through the assignment class to serve as the data content of the target data.
3. A data processing method according to any one of claims 1 to 2, wherein after said transmitting the assigned data content of said audit data to said management side, said data processing method further comprises:
if a modification request uploaded by the management end is received, acquiring modification data in the modification request;
acquiring assigned audit data with the same data identification as the modification data as data to be modified;
replacing the data content of the data to be modified by using the data content in the modification data;
and sending the data content of the replaced data to be modified to the management end.
4. A data processing apparatus, characterized in that the data processing apparatus comprises:
the system comprises an identifier generation module, a client and a client, wherein the identifier generation module is used for generating a basic form identifier according to a preset form identifier generation mode if an application form uploaded by the client is received, the application form comprises at least one piece of basic data, and each piece of basic data comprises data content and data identifiers;
The mapping establishing module is used for establishing a corresponding relation between the application form and the basic form identifier and storing the application form, the basic form identifier and the corresponding relation into a preset database;
the audit table acquisition module is used for acquiring audit table identifiers and audit tables contained in the audit request if the audit request sent by the management terminal is received, wherein the audit tables comprise audit data, and each audit data comprises data content and data identifiers;
the target table acquisition module is used for acquiring a basic table identifier which is the same as the auditing table identifier from the preset database, taking the basic table identifier as a target table identifier, and acquiring an application table corresponding to the target table identifier according to the corresponding relation, and taking the application table as a target application table;
the data acquisition module is used for acquiring basic data with relevance between the data identification of the basic data and the data identification of the auditing data in the auditing table from the target application table as relevant data; calculating the data content of the auditing data in the auditing table associated with the associated data through the data content of the associated data and a preset formula; obtaining basic data with the same data identification as the auditing data in the auditing table from the target application table as effective data;
The data assignment module is used for assigning the data content of the effective data to the data content of the audit data with the same data identification as the effective data by using a preset script; if a verification coefficient sent by an auditor through the management end is received, acquiring the verification coefficient, and multiplying the data content of the effective data by the verification coefficient to obtain updated effective data; using the preset script to assign the data content of the updated effective data to the data content of the audit data with the same data identification as the effective data;
and the data transmitting module is used for transmitting the assigned data content of the audit data to the management end, so that audit personnel of the management end audit the data content of the audit data.
5. The data processing apparatus of claim 4, wherein the data assignment module comprises:
the content to be copied acquisition unit is used for acquiring data content corresponding to the data identifier based on the data identifier in the effective data as the content to be copied;
the content to be copied copying unit is used for copying the content to be copied to the clipboard by using the assignment class in the preset script;
The target data acquisition unit is used for acquiring audit data with the same data identifier as the effective data as target data;
and the data content acquisition unit of the target data is used for writing the content in the clipboard into the data content of the target data through the assignment class as the data content of the target data.
6. The data processing apparatus of claim 4, wherein the data processing apparatus further comprises:
the modification data acquisition module is used for acquiring modification data in the modification request if the modification request uploaded by the management end is received;
the data to be modified is used for acquiring the assigned audit data with the same data identifier as the modification data, and is used as the data to be modified;
a replacing module, configured to replace data content of the data to be modified with data content in the modification data;
and the data sending module is used for sending the data content of the replaced data to be modified to the management end, so that an auditor of the management end can audit the data content of the audit data.
7. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of the data processing method according to any of claims 1 to 3 when the computer program is executed.
8. A computer-readable storage medium storing a computer program, characterized in that the computer program, when executed by a processor, implements the steps of the data processing method according to any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811084480.9A CN109447820B (en) | 2018-09-18 | 2018-09-18 | Data processing method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811084480.9A CN109447820B (en) | 2018-09-18 | 2018-09-18 | Data processing method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109447820A CN109447820A (en) | 2019-03-08 |
| CN109447820B true CN109447820B (en) | 2023-09-15 |
Family
ID=65532901
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811084480.9A Active CN109447820B (en) | 2018-09-18 | 2018-09-18 | Data processing method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109447820B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110490181B (en) * | 2019-08-14 | 2022-04-22 | 北京思图场景数据科技服务有限公司 | Form filling and auditing method, device and equipment based on OCR (optical character recognition) technology and computer storage medium |
| CN111126956B (en) * | 2019-12-19 | 2023-05-30 | 贵州惠智电子技术有限责任公司 | Organization architecture management system for multi-unit information interconnection |
| CN112346726B (en) * | 2020-03-16 | 2023-12-12 | 成都华微电子科技股份有限公司 | Method for automatically generating design codes based on form information |
| CN113495887B (en) * | 2020-03-20 | 2024-09-20 | 北京沃东天骏信息技术有限公司 | Data form processing method, device and system |
| CN111966673B (en) * | 2020-08-18 | 2021-06-25 | 深圳市维度数据科技股份有限公司 | Big data based data auditing method and device and storage medium |
| CN113407163B (en) * | 2021-05-18 | 2024-07-26 | 中广核工程有限公司 | Module association assignment method, device, computer equipment and readable storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106446184A (en) * | 2016-09-29 | 2017-02-22 | 中国银联股份有限公司 | Method and device for data processing of service system |
| CN107729376A (en) * | 2017-09-13 | 2018-02-23 | 平安科技（深圳）有限公司 | Insurance data checking method, device, computer equipment and storage medium |
| CN107918865A (en) * | 2017-12-08 | 2018-04-17 | 中国平安财产保险股份有限公司 | Declaration form data correct processing method, device, server and storage medium |
-
2018
- 2018-09-18 CN CN201811084480.9A patent/CN109447820B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106446184A (en) * | 2016-09-29 | 2017-02-22 | 中国银联股份有限公司 | Method and device for data processing of service system |
| CN107729376A (en) * | 2017-09-13 | 2018-02-23 | 平安科技（深圳）有限公司 | Insurance data checking method, device, computer equipment and storage medium |
| CN107918865A (en) * | 2017-12-08 | 2018-04-17 | 中国平安财产保险股份有限公司 | Declaration form data correct processing method, device, server and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109447820A (en) | 2019-03-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109447820B (en) | Data processing method, device, computer equipment and storage medium | |
| CN109325729B (en) | Method and server for generating electronic contract | |
| CN109558525B (en) | Test data set generation method, device, equipment and storage medium | |
| CN108132926B (en) | Contract generation device and system | |
| CN111240763A (en) | Configuration updating method, device, equipment and storage medium | |
| US20210049711A1 (en) | Method of automatically transmitting data information and device of automatically transmitting data information | |
| CN111245642A (en) | Method and device for acquiring dependency relationship between multiple systems and electronic equipment | |
| CN108093026A (en) | The processing method and processing device of multi-tenant request | |
| CN110719345A (en) | Virtual machine MAC address generation method, system, equipment and computer medium | |
| CN109271564A (en) | Declaration form querying method and equipment | |
| CN112989313A (en) | Identification registration method and device, electronic equipment and storage medium | |
| CN110807035A (en) | Serial number generation method, device, equipment and storage medium | |
| CN110572451A (en) | Data processing method, device and storage medium | |
| CN116360769A (en) | Code generation method, device, equipment and storage medium | |
| CN113791730B (en) | Method, system, device and storage medium for adjusting placement groups based on double storage pools | |
| CN105187399A (en) | Resource processing method and device | |
| CN112733510A (en) | Financial certificate generation method, device, equipment and computer readable storage medium | |
| CN111651488B (en) | Method, device, medium and electronic equipment for processing database business | |
| CN112784566A (en) | Document generation method, device, equipment and storage medium | |
| CN105988785A (en) | RPC (remote procedure call) service development method and device | |
| CN110866229B (en) | Multi-platform account authority unified management method and system | |
| CN108196921B (en) | Document development method and device, computer equipment and storage medium | |
| CN116842984A (en) | Decoding method of graphic code and code making method thereof | |
| CN115293685A (en) | Logistics order state tracking method, device, equipment and storage medium | |
| CN114205329A (en) | Equipment coding method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |