CN107679819B - Financial data processing method and device, computer equipment and storage medium - Google Patents
Financial data processing method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN107679819B CN107679819B CN201710438759.1A CN201710438759A CN107679819B CN 107679819 B CN107679819 B CN 107679819B CN 201710438759 A CN201710438759 A CN 201710438759A CN 107679819 B CN107679819 B CN 107679819B
- Authority
- CN
- China
- Prior art keywords
- financial
- certification
- data
- making
- data table
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- 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/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Economics (AREA)
- Human Resources & Organizations (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Computational Linguistics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a financial data processing method, a financial data processing device, computer equipment and a storage medium, wherein the method comprises the following steps: acquiring input data screening conditions; sending the obtained data screening conditions to a server; receiving a financial data table screened from a financial database by the server according to the obtained data screening conditions; acquiring a financial certification instruction; acquiring a certification making template from the server according to the financial certification making instruction; and carrying out batch certification on the financial data in the financial data table according to the obtained certification making template. According to the financial data processing method, the financial data processing device, the computer equipment and the storage medium, excessive manual operation on financial data in the financial data table is not needed, data processing can be directly performed on each piece of financial data in the financial data table according to the certification making template, batch certification on the financial data in the financial data table is realized, and the certification making efficiency is improved.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a financial data processing method, an apparatus, a computer device, and a storage medium.
Background
As computer technology has developed, more and more data is dependent on computers for processing. Particularly in the aspect of financial data processing, a large amount of financial data is processed by a computer due to the continuous increase of data processing capacity of the computer.
In the financial data processing process, according to business needs, sometimes the certification is required to be made according to financial data, and the financial data is required to be checked, analyzed and the like in the certification process. In the traditional certification process, the financial certification is mainly carried out by manually operating the financial data. However, as the amount of business of various financial businesses increases and the amount of financial data also increases in large quantities, the financial data is manually operated, so that the efficiency of making certificates from the financial data is low.
Disclosure of Invention
In view of the above, it is desirable to provide a financial data processing method, apparatus, computer device, and storage medium, which address the problem of inefficiency in making a certificate from financial data.
A method of financial data processing, the method comprising:
acquiring input data screening conditions;
sending the obtained data screening conditions to a server;
receiving a financial data table screened from a financial database by the server according to the obtained data screening conditions;
acquiring a financial certification instruction;
acquiring a certification making template from the server according to the financial certification making instruction;
and carrying out batch certification on the financial data in the financial data table according to the obtained certification making template.
A financial data processing apparatus, the apparatus comprising:
the condition acquisition module is used for acquiring input data screening conditions;
the condition sending module is used for sending the obtained data screening conditions to the server;
the data table receiving module is used for receiving the financial data table screened from the financial database by the server according to the obtained data screening conditions;
the instruction acquisition module is used for acquiring a financial certification instruction;
the template acquisition module is used for acquiring the certification making template from the server according to the financial certification making instruction;
and the data certification making module is used for making the financial data in the financial data table in batches according to the obtained certification making template.
A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
acquiring input data screening conditions;
sending the obtained data screening conditions to a server;
receiving a financial data table screened from a financial database by the server according to the obtained data screening conditions;
acquiring a financial certification instruction;
acquiring a certification making template from the server according to the financial certification making instruction;
and carrying out batch certification on the financial data in the financial data table according to the obtained certification making template.
One or more storage media storing computer-executable instructions that, when executed by one or more processors, cause the one or more processors to perform the steps of:
acquiring input data screening conditions;
sending the obtained data screening conditions to a server;
receiving a financial data table screened from a financial database by the server according to the obtained data screening conditions;
acquiring a financial certification instruction;
acquiring a certification making template from the server according to the financial certification making instruction;
and carrying out batch certification on the financial data in the financial data table according to the obtained certification making template.
According to the financial data processing method, the financial data processing device, the computer equipment and the storage medium, the input data screening conditions are sent to the server, the receiving server screens the financial data tables from the financial data in the financial database according to the data screening conditions, the evidence making template is obtained from the server according to the financial evidence making instruction, and batch evidence making is carried out on the financial data in the financial data tables according to the obtained evidence making template. In the certificate making process, excessive operation on financial data in the financial data table is not needed manually, data processing can be directly carried out on each piece of financial data in the financial data table according to the certificate making template, batch certificate making on the financial data in the financial data table is realized, and certificate making efficiency is improved.
Drawings
FIG. 1 is a diagram of an exemplary financial data processing application environment;
FIG. 2 is a block diagram of a terminal in the financial data processing system in one embodiment;
FIG. 3 is a schematic flow chart diagram illustrating a method for financial data processing according to one embodiment;
FIG. 4 is a flowchart illustrating the steps of generating a forensic log in one embodiment;
FIG. 5 is a flowchart illustrating the steps of importing financial data in one embodiment;
FIG. 6 is a flowchart illustrating steps for updating a forensic template in one embodiment;
FIG. 7 is a block diagram of a financial data processing apparatus according to one embodiment;
FIG. 8 is a block diagram showing the construction of a financial data processing apparatus according to another embodiment;
FIG. 9 is a block diagram showing the construction of a financial data processing apparatus according to still another embodiment;
FIG. 10 is a block diagram showing the construction of a financial data processing apparatus according to still another embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
FIG. 1 is a diagram of an exemplary financial data processing system. Referring to fig. 1, the financial data processing method is applied to a financial data processing system. The financial data processing system comprises a terminal 110 and a server 120, wherein the terminal 110 is connected with the server 120 through a network. The terminal 110 may be a fixed terminal, which may specifically be at least one of a printer, a scanner, and a monitor, or a mobile terminal, which may specifically be at least one of a tablet, a smartphone, a personal data assistant, and a digital camera. The server 120 may be a single server or a server cluster consisting of multiple servers.
FIG. 2 is a schematic diagram illustrating an internal configuration of the terminal 110 in the financial data processing system of FIG. 1, according to one embodiment. As shown in fig. 2, the terminal 110 includes a processor, a memory, a network interface, an input device, and a display screen, which are connected through a system bus. Among other things, the processor is used to provide computing and control capabilities, to support the operation of the entire terminal 110, the memory is used to store data, code instructions, etc., and the network interface is used to communicate with the server 120 over a network. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch screen covered on the display screen, a key, a track ball or a touch pad of the equipment on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like. The touch layer and the display screen form a touch screen. The memory has stored thereon at least one computer executable instruction executable by the processor to implement the method of financial data processing for the terminal 110 provided in the embodiments of the present application. The Memory may include a non-volatile storage medium such as a magnetic disk, an optical disk, a Read-Only Memory (ROM), or a Random Access Memory (RAM). For example, in one embodiment, the memory includes a non-volatile storage medium and an internal memory; the non-volatile storage medium stores an operating system, a database in which various policy data is stored, and computer-executable instructions executable by the processor to implement the policy service task assignment method described above; the internal memory provides a cached execution environment for the operating system and computer-executable instructions in the non-volatile storage medium.
As shown in fig. 3, in an embodiment, a financial data processing method is provided, and this embodiment is illustrated by applying the method to the terminal 110 in the financial data processing system in fig. 1, where the method specifically includes the following steps:
s302, acquiring the input data screening conditions.
Specifically, the user inputs a user account and a user password in the terminal 110 through the input device, logs in to the input page of the screening condition, and inputs the data screening condition on the input page of the screening condition. And a data screening button is arranged on an input page of the screening condition, and a user clicks the data screening button through input equipment to trigger a data screening instruction. The terminal 110 obtains the data filtering instruction, and obtains the data filtering condition input in the input page of the filtering condition according to the data filtering instruction.
And S304, sending the acquired data screening conditions to a server.
Specifically, the data screening conditions obtained by the terminal 110 are encapsulated, and the encapsulated data screening conditions are sent to the server. The server is provided with a financial database, and financial data are stored in the financial database.
S306, receiving a financial data table screened from the financial database by the server according to the obtained data screening conditions.
Specifically, the server 120, upon receiving the data filtering condition sent by the terminal 110, filters the financial data meeting the data filtering condition in the financial database, and generates the financial data table according to the filtered financial data. The financial data table comprises a plurality of pieces of financial data, and each piece of financial data at least comprises financial data corresponding to one data identifier. The server 120 returns the financial data table to the terminal 110. The terminal 110 receives the financial data table returned by the server 120. After receiving the financial data table, the terminal 110 displays a financial data display page, and displays the received financial data table in the financial data display page.
And S308, acquiring a financial certification instruction.
Specifically, be provided with financial system certificate button in the financial data show page that terminal 110 shows, the user clicks financial system certificate button through input device and triggers financial system certificate instruction. The terminal 110 obtains financial certification instructions. The financial certification instruction is an instruction for triggering the terminal 110 to perform financial certification on the financial data in the financial data table.
And S310, acquiring a certification making template from the server according to the financial certification making instruction.
Specifically, the financial certification instruction carries one or more certification template numbers. After the financial certification making instruction is obtained, the terminal 110 analyzes the financial certification making instruction, and extracts the certification making template number in the financial certification making instruction through analysis. The certification making template number is a unique identifier for identifying the certification making template. The certification making template is used for performing financial certification on each piece of financial data in the financial data table. The terminal 110 generates a template acquisition request according to the extracted certification template number, and the terminal 110 transmits the template acquisition request to the server 120. The server 120 extracts the certification making template number in the template acquisition request, queries a certification making template corresponding to the extracted certification making template number, and sends the queried certification making template to the terminal 110. The terminal 110 receives the certification template returned by the server 120.
And S312, performing batch certification on the financial data in the financial data table according to the obtained certification making template.
Specifically, the terminal 110 reads each piece of financial data according to the arrangement order of each piece of financial data in the financial data table, and makes a certificate for the read financial data according to the obtained certificate making template. The terminal 110 performs batch certification on the financial data in the financial data table.
In one embodiment, the acquired forensic templates are a plurality of forensic templates; s312 specifically includes the following steps: acquiring data conditions to be certified matched with each certification template; extracting financial data from the financial data table according to the data conditions to be certified to obtain a corresponding data table to be certified; and making the certificate of each piece of certificate making data in the corresponding data table to be made with the certificate making templates.
Specifically, the financial certification instruction carries a plurality of certification template numbers. The terminal 110 extracts a plurality of certification making template numbers from the financial certification making instruction, and acquires the certification making templates corresponding to the certification making template numbers from the server 120 according to the extracted plurality of certification making template numbers. And aiming at each extracted certificate making template, extracting the data conditions to be certified in the certificate making template, extracting financial data from the financial data table according to the extracted data conditions to be certified, obtaining the data table to be certified matched with the certificate making template according to the extracted financial data, and making the certificate of each certificate making data in the data table to be certified according to the certificate making rule in the certificate making template. The terminal 110 performs batch certification on the financial data in the financial data table according to each certification template.
In this embodiment, send the data screening condition of input to the server, receive the financial data table that the server was screened from the financial data in the financial database according to the data screening condition, obtain the system certificate template from the server according to financial system certificate instruction, carry out batch system certificate to the financial data in the financial data table according to the system certificate template that obtains. In the certificate making process, excessive operation on financial data in the financial data table is not needed manually, data processing can be directly carried out on each piece of financial data in the financial data table according to the certificate making template, batch certificate making on the financial data in the financial data table is realized, and certificate making efficiency is improved.
As shown in fig. 4, in an embodiment, the financial data processing method further includes a step of generating a certification log, where the step includes the following steps:
s402, changing the certification making state of each piece of certification making data in the data table to be certified from the state to be certified into the certified state, and acquiring the certified data table.
Specifically, the data table to be certified includes a certification making state corresponding to each piece of certification making data, and the certification making state includes a certification making state and a certified state. After the certificate making data in the certificate making data table is not certified by the terminal, the certificate making state corresponding to the certificate making data is the certificate making state, and if the certificate making data is certified by the terminal, the certificate making state corresponding to the certificate making data is the certified state. After each piece of certification making data in the data table to be certified is certified, the terminal 110 changes the certification making state corresponding to each piece of certification making data in the data table to be certified from the certification making state to the certified state. The terminal 110 obtains the certified data table after changing the certification making state corresponding to each piece of certified data in the to-be-certified data table from the to-be-certified state to the certified state.
S404, recording the certification result of each piece of certification data in the certified data table.
Specifically, the certification result includes certification success and certification failure. The terminal 110 records the certification making result corresponding to each piece of certification making data in the certified data table, and stores the certification making result and the corresponding certification making data.
S406, counting the number of the certificate making data corresponding to various certificate making results in the certificate making data table.
Specifically, the terminal 110 reads the certification result of each piece of certification data according to the arrangement sequence of the certification data in the certified data table, counts the read times of each certification result, and takes the read times of each certification result as the number of the pieces of certification data corresponding to each certification result.
In an embodiment, the terminal 110 classifies the certification making data in the certified data table according to the certification making results, and counts the number of the certification making data corresponding to each certification making result after classification to obtain the number of the certification making data corresponding to each certification making result.
And S408, generating a certification making log according to the counted number of the certification making data corresponding to various certification making results.
Specifically, the certification log records historical data for the user to certify based on financial data. The certificate making log comprises the counted number of certificate making data corresponding to various certificate making results, and also comprises at least one of a user account number, certificate making time and certificate making template numbers adopted by certificate making. The user account in the certification log is the logged-in user account acquired by the terminal 110, and the user account is used as the certification maker identifier in the certification log. The terminal 110 may store the certification log in correspondence with the certified data table.
In one embodiment, the terminal 110 stores the certification log to the server 120. The terminal 110 obtains the certificate making log query instruction, extracts the certificate making query condition in the certificate making query instruction, generates a certificate making query request according to the certificate making query condition, and sends the certificate making query request to the server 120. The server 120 queries for the request based on the certificate
In this embodiment, the certification making state of each piece of certification making data is changed to obtain a certified data table, the certification making result of each piece of certification making data in the certified data table is recorded, the number of pieces of certification making data corresponding to various certification making results is counted, and the number of pieces of certification making data corresponding to various certification making results counted is used to generate a certification making log, so that the certification making condition can be queried through the certification making log.
As shown in fig. 5, in an embodiment, the financial data processing method further includes a step of importing financial data, where the step includes the following steps:
s502, a data table importing instruction is obtained.
Specifically, a data table import page is displayed on the display screen of the terminal 110, and a data table import button is arranged in the data table import page. And clicking a data sheet import button through the input equipment by the user to trigger a data sheet import instruction.
S504, extracting the data table identification in the data table import command.
Specifically, the terminal 110 parses the data table import instruction, and extracts the data table identifier in the data table import instruction through parsing. The data table identification is a unique identification of the data table, and the data table identification can be at least one of a data table name, a data table number and a data table storage path.
S506, inquiring the local data table according to the data table identification.
Specifically, after the terminal 110 extracts the data table identifier, the local data table corresponding to the data table identifier is queried in the locally stored data table. And storing the financial data to be uploaded in the inquired local data table.
And S508, uploading the inquired local data table to a server, and enabling the server to store the financial data in the local data table to a financial database.
Specifically, the terminal 110 uploads the queried local data table to the server 120. The server 120 receives the data table uploaded by the terminal 110, the server 120 reads the financial data according to the data identification in the received data table, and the read financial data and the same data identification in the financial database are correspondingly stored.
In this embodiment, through uploading the local data table to the server, financial data storage to financial database in the local data table that the time server will upload has improved financial data's in the local data table storage efficiency, stores up financial data through financial database, can improve financial data's security and utilization ratio.
As shown in fig. 6, in an embodiment, the financial data processing method further includes a step of updating the certification template, where the step includes the following steps:
s602, obtaining a certificate making template updating instruction.
Specifically, the terminal 110 displays a certification making template display page, where template update information and a certification making template number to be updated may be input, and a certification making template update button for triggering a certification making template update instruction is provided in the certification making template display page. And clicking the certificate making template updating button through the input equipment by the user to trigger the certificate making template updating instruction. The template updating information comprises the data condition to be certified and the certification rule information.
S604, extracting the certificate making template number and the template updating information in the certificate making template updating instruction.
Specifically, the terminal 110 obtains the certificate making template updating instruction, analyzes the certificate making template updating instruction, and extracts the certificate making template number and the template updating information in the certificate making template updating instruction through analysis.
S606, the certification making template corresponding to the extracted certification making template number is acquired from the server.
Specifically, the terminal 110 transmits the extracted certification template number to the server 120. The server 120 queries the corresponding certification making template according to the extracted certification making template number, and sends the queried certification making template to the terminal 110. The terminal 110 receives the certification template returned by the server 120.
In one embodiment, if the server 120 queries the forensic template corresponding to the extracted forensic template number, the server 120 returns a query failure alert. The terminal 110 receives the query failure prompt returned by the server 120, creates the certification making template according to the extracted certification making template number and the template updating information, and stores the created certification making template in the server 120.
And S608, updating the acquired certificate making template according to the extracted template updating information.
Specifically, the terminal 110 queries the information to be updated in the acquired certification making template according to the extracted template update information, and replaces the queried information to be updated with the update information in the template update information.
And S610, storing the updated certificate making template to a server.
Specifically, the terminal 110 sends the updated certification making template to the server 120, so that the server 120 stores the updated certification making template in correspondence with the certification making template number.
In one embodiment, the terminal 110 acquires the template query instruction, extracts the certification making template number in the template query instruction, acquires the certification making template from the server 120 according to the certification making template number, and displays the certification making template information in the acquired certification making template on the display screen. The user can update the displayed certificate making template information through the input device and input the template updating information. The terminal 110 acquires the template update information and updates the certification template according to the edit update information.
In this embodiment, can update the system card template, make according to the system card template of difference to financial data system card through the update to the system card template, can guarantee to update the system card template according to the demand, simplified the operability of financial data system card greatly, improved the system card efficiency to financial data.
As shown in fig. 7, in one embodiment, a financial data processing apparatus 700 is provided, which comprises in particular the following: a condition acquisition module 702, a condition sending module 704, a data table receiving module 706, an instruction acquisition module 708, a template acquisition module 710, and a data certification module 712.
A condition obtaining module 702, configured to obtain an input data screening condition.
A condition sending module 704, configured to send the obtained data screening condition to the server.
And the data table receiving module 706 is configured to receive the financial data table screened by the server from the financial database according to the obtained data screening condition.
And the instruction acquisition module 708 is used for acquiring the financial certification instruction.
And the template acquisition module 710 is used for acquiring the certification template from the server according to the financial certification instruction.
And the data certification making module 712 is used for making batch certification on the financial data in the financial data table according to the obtained certification making template.
In one embodiment, the acquired forensic templates are a plurality of forensic templates; the data certification module 712 is further configured to obtain data conditions to be certified matched with each certification template; extracting financial data from the financial data table according to the data conditions to be certified to obtain a corresponding data table to be certified; and making the certificate of each piece of certificate making data in the corresponding data table to be made with the certificate making templates.
In this embodiment, send the data screening condition of input to the server, receive the financial data table that the server was screened from the financial data in the financial database according to the data screening condition, obtain the system certificate template from the server according to financial system certificate instruction, carry out batch system certificate to the financial data in the financial data table according to the system certificate template that obtains. In the certificate making process, excessive operation on financial data in the financial data table is not needed manually, data processing can be directly carried out on each piece of financial data in the financial data table according to the certificate making template, batch certificate making on the financial data in the financial data table is realized, and certificate making efficiency is improved.
As shown in fig. 8, in an embodiment, the financial data processing apparatus 700 further includes: a certification status changing module 714, a certification result recording module 716, a data number counting module 718 and a certification log generating module 720.
The certification making state changing module 714 is configured to change the certification making state of each piece of certification making data in the data table to be certified from the state to be certified into the certified state, and acquire the certified data table.
The certification result recording module 716 is configured to record a certification result of each piece of certification data in the certified data table.
And the data number counting module 718 is configured to count the number of the certification making data corresponding to each certification making result in the certified data table.
And the certification making log generating module 720 is configured to generate a certification making log according to the counted number of the certification making data corresponding to each certification making result.
In this embodiment, the certification making state of each piece of certification making data is changed to obtain a certified data table, the certification making result of each piece of certification making data in the certified data table is recorded, the number of pieces of certification making data corresponding to various certification making results is counted, and the number of pieces of certification making data corresponding to various certification making results counted is used to generate a certification making log, so that the certification making condition can be queried through the certification making log.
As shown in fig. 9, in an embodiment, the financial data processing apparatus 700 further includes: a data table import module 722.
A data table importing module 722, configured to obtain a data table importing instruction; extracting a data table identifier in a data table import instruction; inquiring a local data table according to the data table identification; and uploading the inquired local data table to a server, and enabling the server to store the financial data in the local data table to a financial database.
In this embodiment, through uploading the local data table to the server, financial data storage to the financial database in the local data table that the server will upload has improved financial data's in the local data table storage efficiency, stores up financial data through the financial database, can improve financial data's security and utilization ratio.
As shown in fig. 10, in an embodiment, the financial data processing apparatus 700 further includes: a certification template update module 724.
The system certificate making template updating module 724 is used for acquiring a system certificate making template updating instruction; extracting the certificate making template number and the template updating information in the certificate making template updating instruction; acquiring the certification making template corresponding to the extracted certification making template number from the server; updating the acquired certificate making template according to the extracted template updating information; and storing the updated certificate making template to a server.
In this embodiment, can update the system card template, make according to the system card template of difference to financial data system card through the update to the system card template, can guarantee to update the system card template according to the demand, simplified the operability of financial data system card greatly, improved the system card efficiency to financial data.
A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program: acquiring input data screening conditions; sending the obtained data screening conditions to a server; receiving a financial data table screened from a financial database by a server according to the obtained data screening conditions; acquiring a financial certification instruction; acquiring a certification making template from a server according to the financial certification making instruction; and carrying out batch certification on the financial data in the financial data table according to the obtained certification making template.
In one embodiment, the acquired forensic templates are a plurality of forensic templates; according to the certificate making template that obtains carry out batch certificate making to the financial data in the financial data table, include: acquiring data conditions to be certified matched with each certification template; extracting financial data from the financial data table according to the data conditions to be certified to obtain a corresponding data table to be certified; and making the certificate of each piece of certificate making data in the corresponding data table to be made with the certificate making templates.
In one embodiment, after each piece of certification data in the corresponding data table to be certified is certified according to each certification template, the method further includes: changing the certification making state of each piece of certification making data in the data table to be certified from the certification making state to a certified state to obtain a certified data table; recording the certification result of each piece of certification data in the certified data table; counting the number of the certificate making data corresponding to various certificate making results in the certificate making data table; and generating a certificate making log according to the counted number of the certificate making data corresponding to various certificate making results.
In one embodiment, the processor, when executing the computer program, further performs the steps of: acquiring a data table import instruction; extracting a data table identifier in a data table import instruction; inquiring a local data table according to the data table identification; and uploading the inquired local data table to a server, and enabling the server to store the financial data in the local data table to a financial database.
In one embodiment, the processor, when executing the computer program, further performs the steps of: acquiring a certificate making template updating instruction; extracting the certificate making template number and the template updating information in the certificate making template updating instruction; acquiring the certification making template corresponding to the extracted certification making template number from the server; updating the acquired certificate making template according to the extracted template updating information; and storing the updated certificate making template to a server.
In this embodiment, send the data screening condition of input to the server, receive the financial data table that the server was screened from the financial data in the financial database according to the data screening condition, obtain the system certificate template from the server according to financial system certificate instruction, carry out batch system certificate to the financial data in the financial data table according to the system certificate template that obtains. In the certificate making process, excessive operation on financial data in the financial data table is not needed manually, data processing can be directly carried out on each piece of financial data in the financial data table according to the certificate making template, batch certificate making on the financial data in the financial data table is realized, and certificate making efficiency is improved.
One or more storage media storing computer-executable instructions that, when executed by one or more processors, cause the one or more processors to perform the steps of: acquiring input data screening conditions; sending the obtained data screening conditions to a server; receiving a financial data table screened from a financial database by a server according to the obtained data screening conditions; acquiring a financial certification instruction; acquiring a certification making template from a server according to the financial certification making instruction; and carrying out batch certification on the financial data in the financial data table according to the obtained certification making template.
In one embodiment, the acquired forensic templates are a plurality of forensic templates; according to the certificate making template that obtains carry out batch certificate making to the financial data in the financial data table, include: acquiring data conditions to be certified matched with each certification template; extracting financial data from the financial data table according to the data conditions to be certified to obtain a corresponding data table to be certified; and making the certificate of each piece of certificate making data in the corresponding data table to be made with the certificate making templates.
In one embodiment, after each piece of certification data in the corresponding data table to be certified is certified according to each certification template, the method further includes: changing the certification making state of each piece of certification making data in the data table to be certified from the certification making state to a certified state to obtain a certified data table; recording the certification result of each piece of certification data in the certified data table; counting the number of the certificate making data corresponding to various certificate making results in the certificate making data table; and generating a certificate making log according to the counted number of the certificate making data corresponding to various certificate making results.
In one embodiment, the processor further implements the steps of: acquiring a data table import instruction; extracting a data table identifier in a data table import instruction; inquiring a local data table according to the data table identification; and uploading the inquired local data table to a server, and enabling the server to store the financial data in the local data table to a financial database.
In one embodiment, the processor further implements the steps of: acquiring a certificate making template updating instruction; extracting the certificate making template number and the template updating information in the certificate making template updating instruction; acquiring the certification making template corresponding to the extracted certification making template number from the server; updating the acquired certificate making template according to the extracted template updating information; and storing the updated certificate making template to a server.
In this embodiment, send the data screening condition of input to the server, receive the financial data table that the server was screened from the financial data in the financial database according to the data screening condition, obtain the system certificate template from the server according to financial system certificate instruction, carry out batch system certificate to the financial data in the financial data table according to the system certificate template that obtains. In the certificate making process, excessive operation on financial data in the financial data table is not needed manually, data processing can be directly carried out on each piece of financial data in the financial data table according to the certificate making template, batch certificate making on the financial data in the financial data table is realized, and certificate making efficiency is improved.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and can include the processes of the embodiments of the methods described above when the computer program is executed. The storage medium may be a non-volatile storage medium such as a magnetic disk, an optical disk, a Read-Only Memory (ROM), or a Random Access Memory (RAM).
The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (12)
1. A method of financial data processing, the method comprising:
acquiring input data screening conditions;
sending the obtained data screening conditions to a server;
receiving a financial data table screened from a financial database by the server according to the obtained data screening conditions; the financial data table comprises a plurality of pieces of financial data which accord with the data screening conditions;
acquiring a financial certification instruction; the financial certification making instruction carries a plurality of certification making template numbers; the financial certification instruction is used for triggering financial certification on the financial data in the financial data table;
acquiring the certification making templates corresponding to the plurality of certification making template numbers from the server according to the financial certification making instruction;
and carrying out batch certification on the financial data in the financial data table according to the obtained certification making template.
2. The method of claim 1, wherein batch certification of the financial data in the financial data table according to the obtained certification template comprises:
acquiring data conditions to be certified matched with each certification template;
extracting financial data from a financial data table according to the data conditions to be certified to obtain a corresponding data table to be certified;
and making the certificate of each piece of certificate making data in the corresponding data table to be made with the certificate making templates.
3. The method according to claim 2, wherein after the validating each of the validation data in the corresponding to-be-validated data table according to each validation template, further comprising:
changing the certification making state of each piece of certification making data in the data table to be certified from the certification making state to a certified state to obtain a certified data table;
recording the certification result of each piece of certification data in the certified data table;
counting the number of the certificate making data corresponding to various certificate making results in the certificate making data table;
and generating a certificate making log according to the counted number of the certificate making data corresponding to various certificate making results.
4. The method of claim 1, further comprising:
acquiring a data table import instruction;
extracting a data table identifier in a data table import instruction;
inquiring a local data table according to the data table identification;
and uploading the inquired local data table to the server, and enabling the server to store the financial data in the local data table to the financial database.
5. The method of claim 1, further comprising:
acquiring a certificate making template updating instruction;
extracting the certificate making template number and the template updating information in the certificate making template updating instruction;
acquiring the certification making template corresponding to the extracted certification making template number from the server;
updating the acquired certificate making template according to the extracted template updating information;
and storing the updated certificate making template to the server.
6. A financial data processing apparatus, characterised in that the apparatus comprises:
the condition acquisition module is used for acquiring input data screening conditions;
the condition sending module is used for sending the obtained data screening conditions to the server;
the data table receiving module is used for receiving the financial data table screened from the financial database by the server according to the obtained data screening conditions; the financial data table comprises a plurality of pieces of financial data which accord with the data screening conditions;
the instruction acquisition module is used for acquiring a financial certification instruction; the financial certification making instruction carries a plurality of certification making template numbers; the financial certification instruction is used for triggering financial certification on the financial data in the financial data table;
the template acquisition module is used for acquiring the certification making templates corresponding to the plurality of certification making template numbers from the server according to the financial certification making instruction;
and the data certification making module is used for making the financial data in the financial data table in batches according to the obtained certification making template.
7. The apparatus of claim 6, wherein the data certification module is further configured to obtain the data condition to be certified matched with each certification template; extracting financial data from a financial data table according to the data conditions to be certified to obtain a corresponding data table to be certified; and making the certificate of each piece of certificate making data in the corresponding data table to be made with the certificate making templates.
8. The apparatus of claim 7, further comprising:
the system comprises a system certificate state changing module, a system certificate state obtaining module and a verification processing module, wherein the system certificate state changing module is used for changing the system certificate state of each piece of system certificate data in a data table to be subjected to system certificate from the state to be subjected to system certificate to the state of the system certificate, and obtaining the data table to be subjected to system certificate;
the system certificate result recording module is used for recording the system certificate result of each piece of system certificate data in the system certificate data table;
the data number counting module is used for counting the number of the certificate making data corresponding to various certificate making results in the certificate making data table;
and the certificate making log generating module is used for generating certificate making logs according to the counted number of the certificate making data corresponding to various certificate making results.
9. The apparatus of claim 6, further comprising:
the data table importing module is used for acquiring a data table importing instruction; extracting a data table identifier in a data table import instruction; inquiring a local data table according to the data table identification; and uploading the inquired local data table to the server, and enabling the server to store the financial data in the local data table to the financial database.
10. The apparatus of claim 6, further comprising:
the system certificate making template updating module is used for acquiring a system certificate making template updating instruction; extracting the certificate making template number and the template updating information in the certificate making template updating instruction; acquiring the certification making template corresponding to the extracted certification making template number from the server; updating the acquired certificate making template according to the extracted template updating information; and storing the updated certificate making template to the server.
11. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
acquiring input data screening conditions;
sending the obtained data screening conditions to a server;
receiving a financial data table screened from a financial database by the server according to the obtained data screening conditions; the financial data table comprises a plurality of pieces of financial data which accord with the data screening conditions;
acquiring a financial certification instruction; the financial certification making instruction carries a plurality of certification making template numbers; the financial certification instruction is used for triggering financial certification on the financial data in the financial data table;
acquiring the certification making templates corresponding to the plurality of certification making template numbers from the server according to the financial certification making instruction;
and carrying out batch certification on the financial data in the financial data table according to the obtained certification making template.
12. One or more storage media storing computer-executable instructions that, when executed by one or more processors, cause the one or more processors to perform the steps of:
acquiring input data screening conditions;
sending the obtained data screening conditions to a server;
receiving a financial data table screened from a financial database by the server according to the obtained data screening conditions; the financial data table comprises a plurality of pieces of financial data which accord with the data screening conditions;
acquiring a financial certification instruction; the financial certification making instruction carries a plurality of certification making template numbers; the financial certification instruction is used for triggering financial certification on the financial data in the financial data table;
acquiring the certification making templates corresponding to the plurality of certification making template numbers from the server according to the financial certification making instruction;
and carrying out batch certification on the financial data in the financial data table according to the obtained certification making template.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710438759.1A CN107679819B (en) | 2017-06-12 | 2017-06-12 | Financial data processing method and device, computer equipment and storage medium |
| PCT/CN2017/108277 WO2018227848A1 (en) | 2017-06-12 | 2017-10-30 | Financial data processing method and apparatus, and computer device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710438759.1A CN107679819B (en) | 2017-06-12 | 2017-06-12 | Financial data processing method and device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107679819A CN107679819A (en) | 2018-02-09 |
| CN107679819B true CN107679819B (en) | 2020-05-26 |
Family
ID=61133641
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710438759.1A Active CN107679819B (en) | 2017-06-12 | 2017-06-12 | Financial data processing method and device, computer equipment and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN107679819B (en) |
| WO (1) | WO2018227848A1 (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108717429A (en) * | 2018-05-11 | 2018-10-30 | 平安科技（深圳）有限公司 | Financial data accreditation method, apparatus, computer equipment and storage medium |
| CN109255108B (en) * | 2018-07-19 | 2022-06-17 | 平安科技（深圳）有限公司 | Method and device for managing running data, computer equipment and storage medium |
| CN109255692B (en) * | 2018-08-16 | 2023-06-27 | 中国平安人寿保险股份有限公司 | Intelligent control method, terminal equipment and medium for electronic accounting period |
| CN109254768B (en) * | 2018-08-16 | 2024-04-12 | 中国平安人寿保险股份有限公司 | Method for acquiring certificate making information, terminal equipment and medium |
| CN109376191A (en) * | 2018-09-18 | 2019-02-22 | 深圳壹账通智能科技有限公司 | Financial report data processing method, device, computer equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103049563A (en) * | 2012-12-31 | 2013-04-17 | 深圳中兴网信科技有限公司 | Server, accounting document generating system and accounting document generating method |
| CN103577591A (en) * | 2013-11-12 | 2014-02-12 | 广东金宇恒科技有限公司 | Method and device for generating accounting voucher |
| CN103679525A (en) * | 2013-12-26 | 2014-03-26 | 北京德信易税网络技术有限公司 | Fiscal taxation source monitoring method device and system |
| WO2014063127A1 (en) * | 2012-10-18 | 2014-04-24 | Intuit Inc. | Method and system for creating tax configuration templates |
-
2017
- 2017-06-12 CN CN201710438759.1A patent/CN107679819B/en active Active
- 2017-10-30 WO PCT/CN2017/108277 patent/WO2018227848A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2014063127A1 (en) * | 2012-10-18 | 2014-04-24 | Intuit Inc. | Method and system for creating tax configuration templates |
| CN103049563A (en) * | 2012-12-31 | 2013-04-17 | 深圳中兴网信科技有限公司 | Server, accounting document generating system and accounting document generating method |
| CN103577591A (en) * | 2013-11-12 | 2014-02-12 | 广东金宇恒科技有限公司 | Method and device for generating accounting voucher |
| CN103679525A (en) * | 2013-12-26 | 2014-03-26 | 北京德信易税网络技术有限公司 | Fiscal taxation source monitoring method device and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107679819A (en) | 2018-02-09 |
| WO2018227848A1 (en) | 2018-12-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107679819B (en) | Financial data processing method and device, computer equipment and storage medium | |
| CN107733968B (en) | Application information pushing method and device, computer equipment and storage medium | |
| US10764139B2 (en) | Information processing system and report creation method | |
| US11240224B2 (en) | Systems, methods and apparatuses for identity access management and web services access | |
| CN110688598B (en) | Service parameter acquisition method and device, computer equipment and storage medium | |
| CN111639066A (en) | Data cleaning method and device | |
| US20190026487A1 (en) | Management server, data viewing system, and non-transitory computer readable medium | |
| CN103970828B (en) | Network system and method for reporting information | |
| US20220138179A1 (en) | Private blockchain system and method | |
| US20230418984A1 (en) | Artwork managing method, computer, and program | |
| JP6784124B2 (en) | Information processing system, usage information generation method, information processing device and program | |
| CN109815351B (en) | Information query method and related product | |
| US10586059B2 (en) | System, method of controlling access right, and information processing apparatus | |
| CN110119337B (en) | Data analysis method and device and server | |
| JP7322472B2 (en) | File management device, file management program, file management system, and information processing program | |
| CN112035205A (en) | Data processing method, device, equipment and storage medium | |
| CN113392121A (en) | Data query method, device, equipment and storage medium | |
| CN112783920A (en) | Industrial Internet of things data real-time computing method and system based on data arrangement | |
| CN114371866A (en) | Version reconfiguration test method, device and equipment of service system | |
| CN112256689A (en) | Service data cleaning method and device and electronic equipment | |
| JP2006072783A (en) | Data entry system and data entry method | |
| CN114513583B (en) | Compression uploading method, device, equipment and medium for image data | |
| CN108765169B (en) | Policy risk identification method, device, computer equipment and storage medium | |
| JP6859560B2 (en) | Information processing methods, computer programs, information processing servers and information processing equipment | |
| EP3635585A1 (en) | Enrichment of user specific information |
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 |