CN112380278A - Financial data report generation method, device, equipment and storage medium - Google Patents
Financial data report generation method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN112380278A CN112380278A CN202011282956.7A CN202011282956A CN112380278A CN 112380278 A CN112380278 A CN 112380278A CN 202011282956 A CN202011282956 A CN 202011282956A CN 112380278 A CN112380278 A CN 112380278A
- Authority
- CN
- China
- Prior art keywords
- data
- target
- financial
- financial data
- report
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 46
- 230000004048 modification Effects 0.000 claims description 36
- 238000012986 modification Methods 0.000 claims description 36
- 238000012795 verification Methods 0.000 claims description 18
- 238000007781 pre-processing Methods 0.000 claims description 6
- 238000005516 engineering process Methods 0.000 abstract description 3
- 230000001360 synchronised effect Effects 0.000 description 13
- 230000008569 process Effects 0.000 description 9
- 238000010586 diagram Methods 0.000 description 6
- 238000012545 processing Methods 0.000 description 4
- 230000008676 import Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001052 transient effect Effects 0.000 description 1
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/248—Presentation of query results
-
- 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/242—Query formulation
- G06F16/2433—Query languages
-
- 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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- 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)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Accounting & Taxation (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Finance (AREA)
- Probability & Statistics with Applications (AREA)
- Mathematical Physics (AREA)
- Development Economics (AREA)
- General Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Fuzzy Systems (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the technical field of big data, and discloses a method, a device, equipment and a storage medium for generating a financial data report, which are used for improving the accuracy of the financial data report and further reducing the time consumed by the statistics of financial data. The method comprises the following steps: acquiring a first instruction input by a user; reading the financial data of the target month from a preset TiDB database according to the first instruction, and calling a preset Sqoop tool to synchronize the financial data of the target month to a financial month end database to obtain the target financial data; determining a plurality of report indexes according to preset configuration information in a financial monthly database, wherein the preset configuration information is used for indicating a Structured Query Language (SQL) query statement mark; counting the target financial data according to the multiple report indexes to generate multiple target index data; and generating a financial data report of the target month according to the plurality of items of target index data. In addition, the invention also relates to a block chain technology, and the target index data can be stored in the block chain.
Description
Technical Field
The invention relates to the field of data reports of big data technology, in particular to a method, a device, equipment and a storage medium for generating a financial data report.
Background
Generally, financial colleagues gather detailed data through Excel to obtain indexes under various dimensions. And then audited by each department. This manual process is restarted when the design data fixes the adjustments.
The method usually consumes manpower, and has the problems of hand error and the like to a certain extent. And Excel is not friendly to processing of large data volume, and can possibly cause the system to be stuck, so that the method has the advantages of being abandoned, incapable of ensuring the accuracy of financial data and long in time consumption.
Disclosure of Invention
The invention provides a method, a device, equipment and a storage medium for generating a financial data report, which are used for improving the accuracy of the financial data report and further reducing the time consumed by the statistics of financial data.
A first aspect of an embodiment of the present invention provides a method for generating a financial data report, including: acquiring a first instruction input by a user, wherein the first instruction is used for indicating the start of counting financial data of a target month; reading the financial data of the target month from a preset TiDB database according to the first instruction, and calling a preset Sqoop tool to synchronize the financial data of the target month to a financial month junction database to obtain target financial data; determining a plurality of report indexes according to preset configuration information in the financial monthly database, wherein the preset configuration information is used for indicating a Structured Query Language (SQL) query statement mark; counting the target financial data according to the multiple report indexes to generate multiple target index data; and generating a financial data report of the target month according to the plurality of items of target index data.
Optionally, in a first implementation manner of the first aspect of the embodiment of the present invention, the reading, according to the first instruction, the financial data of the target month from a preset TiDB database, and calling a preset Sqoop tool to synchronize the financial data of the target month to a financial month end database to obtain the target financial data includes: analyzing the first instruction to obtain a first identifier, wherein the first identifier is used for indicating a target month; querying financial data corresponding to the target month in a preset TiDB database according to the first identifier to obtain candidate data corresponding to the target month, wherein the candidate data comprise a plurality of financial index data; and calling a preset Sqoop tool to synchronize the candidate data corresponding to the target month to the financial month junction database to generate target financial data.
Optionally, in a second implementation manner of the first aspect of the embodiment of the present invention, the determining multiple report indicators according to preset configuration information in the financial monthly database, where the preset configuration information is used to indicate a structured query language SQL query statement identifier, includes: reading preset configuration information in the financial monthly database to obtain target configuration information; analyzing the target configuration information to obtain a plurality of SQL query statement identifications; determining an SQL query condition corresponding to each SQL query statement identifier according to the SQL query statement identifiers to obtain a plurality of SQL query conditions; and determining indexes corresponding to each SQL query condition according to the SQL query conditions to obtain multiple report indexes.
Optionally, in a third implementation manner of the first aspect of the embodiment of the present invention, the performing statistics on the target financial data according to the multiple report indicators to generate multiple target indicator data includes: traversing the target financial data according to the multiple report indexes, and determining multiple financial data corresponding to each report index; summarizing the multiple financial data corresponding to each report index to obtain multiple index candidate data, wherein each index candidate data comprises multiple financial data; and sequentially checking the multiple index candidate data, and determining the multiple index candidate data as multiple target index data when all the multiple index candidate data pass the check.
Optionally, in a fourth implementation manner of the first aspect of the embodiment of the present invention, after the multiple items of index candidate data are sequentially checked, and when all the multiple items of index candidate data pass the check, the multiple items of index candidate data are determined as multiple items of target index data, the method for generating a financial data report further includes: when all the report form index data do not pass the verification, generating a modification page; when the modification page obtains a modification instruction input by a user, updating data according to the modification instruction, and simultaneously generating an operation log; and performing statistics again on the target financial data according to the operation log to generate a plurality of items of target index data.
Optionally, in a fifth implementation manner of the first aspect of the embodiment of the present invention, the generating a financial data report of a target month according to the multiple items of target index data includes: determining an initial report template according to the multiple items of target index data, wherein the initial report template is in a target template format; and respectively importing the multiple items of target index data into the initial report template according to the target template format to obtain a financial data report of a target month.
Optionally, in a sixth implementation manner of the first aspect of the embodiment of the present invention, before the obtaining the first instruction input by the user, the method for generating the financial data report further includes: acquiring initial data through a big data service platform, wherein the initial data comprises data generated in each business system; and preprocessing the initial data to obtain various index data sets, and synchronizing the various index data sets to a TiDB database.
A second aspect of the present invention provides an apparatus for generating a financial data report, including: the instruction acquisition module is used for acquiring a first instruction input by a user, wherein the first instruction is used for indicating the start of counting financial data of a target month; the synchronization module is used for reading the financial data of the target month from a preset TiDB database according to the first instruction, and calling a preset Sqoop tool to synchronize the financial data of the target month to a financial month junction database to obtain the target financial data; the determining module is used for determining a plurality of report indexes according to preset configuration information in the financial monthly database, wherein the preset configuration information is used for indicating the marks of Structured Query Language (SQL) query sentences; the statistical module is used for carrying out statistics on the target financial data according to the multiple report indexes to generate multiple target index data; and the generating module is used for generating a financial data report of the target month according to the plurality of items of target index data.
Optionally, in a first implementation manner of the second aspect of the embodiment of the present invention, the synchronization module is specifically configured to: analyzing the first instruction to obtain a first identifier, wherein the first identifier is used for indicating a target month; querying financial data corresponding to the target month in a preset TiDB database according to the first identifier to obtain candidate data corresponding to the target month, wherein the candidate data comprise a plurality of financial index data; and calling a preset Sqoop tool to synchronize the candidate data corresponding to the target month to the financial month junction database to generate target financial data.
Optionally, in a second implementation manner of the second aspect of the embodiment of the present invention, the determining module is specifically configured to: reading preset configuration information in the financial monthly database to obtain target configuration information; analyzing the target configuration information to obtain a plurality of SQL query statement identifications; determining an SQL query condition corresponding to each SQL query statement identifier according to the SQL query statement identifiers to obtain a plurality of SQL query conditions; and determining indexes corresponding to each SQL query condition according to the SQL query conditions to obtain multiple report indexes.
Optionally, in a third implementation manner of the second aspect of the embodiment of the present invention, the statistics module includes: the traversal unit is used for traversing the target financial data according to the multiple report indexes and determining the multiple financial data corresponding to each report index; the summarizing unit is used for summarizing the multiple items of financial data corresponding to each report index to obtain multiple items of index candidate data, and each item of index candidate data comprises multiple items of financial data; and the verification determining unit is used for sequentially verifying the multiple items of index candidate data, and determining the multiple items of index candidate data as multiple items of target index data when all the multiple items of index candidate data pass the verification.
Optionally, in a fourth implementation manner of the second aspect of the embodiment of the present invention, the statistics module further includes: the first generation unit is used for generating a modification page when all the report index data do not pass the verification; the second generation unit is used for updating data according to the modification instruction and generating an operation log when the modification page acquires the modification instruction input by the user; and the third generation unit is used for carrying out statistics again on the target financial data according to the operation log to generate a plurality of items of target index data.
Optionally, in a fifth implementation manner of the second aspect of the embodiment of the present invention, the generating module is specifically configured to: determining an initial report template according to the multiple items of target index data, wherein the initial report template is in a target template format; and respectively importing the multiple items of target index data into the initial report template according to the target template format to obtain a financial data report of a target month.
Optionally, in a sixth implementation manner of the second aspect of the embodiment of the present invention, the apparatus for generating a financial data report further includes: the data acquisition module is used for acquiring initial data through the big data service platform, wherein the initial data comprises data generated in each service system; and the preprocessing module is used for preprocessing the initial data to obtain various index data sets and synchronizing the various index data sets to the TiDB database.
A third aspect of the embodiment of the present invention provides a financial data report generation device, a memory and at least one processor, where the memory stores instructions, and the memory and the at least one processor are interconnected through a line; the at least one processor invokes the instructions in the memory to cause the financial data report generation device to perform the financial data report generation method described above.
A fourth aspect of the embodiments of the present invention provides a computer-readable storage medium, where instructions are stored, and when the instructions are executed by a processor, the steps of the method for generating a financial data report according to any one of the above embodiments are implemented.
According to the technical scheme provided by the embodiment of the invention, a first instruction input by a user is obtained, wherein the first instruction is used for indicating the start of counting the financial data of a target month; reading the financial data of the target month from a preset TiDB database according to the first instruction, and calling a preset Sqoop tool to synchronize the financial data of the target month to a financial month end database to obtain the target financial data; determining a plurality of report indexes according to preset configuration information in a financial monthly database, wherein the preset configuration information is used for indicating a Structured Query Language (SQL) query statement mark; counting the target financial data according to the multiple report indexes to generate multiple target index data; and generating a financial data report of the target month according to the plurality of items of target index data. According to the embodiment of the invention, the financial data of the target month is synchronized to the financial monthly database from the TiDB through the Sqoop tool, the financial data of the target month is automatically collected and counted, and a financial data report is automatically generated, so that manual participation is reduced, the accuracy of the financial data report is improved, and the time consumed by financial data counting is further reduced.
Drawings
FIG. 1 is a schematic diagram of an embodiment of a method for generating a financial data report according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of another embodiment of a method for generating a financial data report according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of an embodiment of a financial data report generation apparatus according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of another embodiment of a financial data report generation apparatus according to an embodiment of the present invention;
FIG. 5 is a diagram of an embodiment of a financial data report generation device according to an embodiment of the present invention.
Detailed Description
The invention provides a method, a device, equipment and a storage medium for generating a financial data report, which are used for improving the accuracy of the financial data report and further reducing the time consumed by the statistics of financial data.
In order to make the technical field of the invention better understand the scheme of the invention, the embodiment of the invention will be described in conjunction with the attached drawings in the embodiment of the invention.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims, as well as in the drawings, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that the embodiments described herein may be practiced otherwise than as specifically illustrated or described herein. Furthermore, the terms "comprises," "comprising," or "having," and any variations thereof, are intended to cover non-exclusive inclusions, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Referring to fig. 1, a flowchart of a method for generating a financial data report according to an embodiment of the present invention specifically includes:
101. acquiring a first instruction input by a user, wherein the first instruction is used for indicating the start of counting financial data of a target month.
The server acquires a first instruction input by a user, wherein the first instruction is used for indicating the start of counting the financial data of the target month. The financial data may include various financial index data, such as sales, balance, etc., which is not limited herein.
It is understood that the executing subject of the present invention may be a generating device of financial data report, and may also be a server, which is not limited herein. The embodiment of the present invention is described by taking a server as an execution subject.
102. And reading the financial data of the target month from a preset TiDB database according to the first instruction, and calling a preset Sqoop tool to synchronize the financial data of the target month to a financial month end database to obtain the target financial data.
Specifically, the server analyzes the first instruction to obtain a first identifier, wherein the first identifier is used for indicating a target month; the server inquires financial data corresponding to the target month in a preset TiDB database according to the first identification to obtain candidate data corresponding to the target month, wherein the candidate data comprise a plurality of financial index data; and the server calls a preset Sqoop tool to synchronize the candidate data corresponding to the target month to the financial month end database to generate the target financial data.
It should be noted that before each data statistics, the financial data for the target month (e.g., the previous month) is synchronized from the TiDB distributed database to the financial lunar junction database (i.e., the database of the financial lunar junction system) via the Sqoop tool. This process solidifies the data for the target month, and does not affect the corresponding data in the financial monthly node database when the source data (data for the target month) in the TiDB database is modified.
103. And determining a plurality of report indexes according to preset configuration information in the financial monthly database, wherein the preset configuration information is used for indicating the Structured Query Language (SQL) query statement identification.
Specifically, the server reads preset configuration information in a financial monthly database to obtain target configuration information; the server analyzes the target configuration information to obtain a plurality of SQL query statement identifications; the server determines an SQL query condition corresponding to each SQL query statement identifier according to the SQL query statement identifiers to obtain a plurality of SQL query conditions; and the server determines the index corresponding to each SQL query condition according to the SQL query conditions to obtain a plurality of report indexes.
It should be noted that, after the data synchronization is finished, the server automatically starts the summary statistical process. For example, the information shown in table 1 is obtained through configuration calculation, then the SQL query condition (SQL condition) is determined through the SQL query statement identifier (SQL _ id), and then the corresponding report index is calculated according to the SQL query condition, as shown in table 2.
TABLE 1
TABLE 2
| Report index | sql conditions | sql_id |
| Total up to | queryLoanAmtByCondition | |
| Without mortgage | { "biz _ line": No mortgage "} | queryLoanAmtByCondition |
| With mortgage | { "biz _ line": there is a mortgage "} | queryLoanAmtByCondition |
104. And counting the target financial data according to the multiple report indexes to generate multiple target index data.
And the server counts the target financial data according to the multiple report indexes to generate multiple target index data. Specifically, the server traverses the target financial data according to a plurality of report indexes, and determines a plurality of financial data corresponding to each report index; the server collects the multiple financial data corresponding to each report index to obtain multiple index candidate data, wherein each index candidate data comprises multiple financial data; and the server checks the multiple index candidate data in sequence, and when all the multiple index candidate data pass the check, the multiple index candidate data are determined as multiple target index data.
Optionally, after the server sequentially performs verification on the multiple index candidate data, the method further includes:
(1) when the index data of the multiple reports do not pass the verification, the server generates a modification page;
specifically, when the plurality of report index data do not pass the verification, the server determines the report index data which do not pass the verification as candidate report index data to obtain at least one item of candidate report index data; and generating a modification page according to the at least one item of candidate report form index data.
(2) When the modification page obtains a modification instruction input by a user, the server updates data according to the modification instruction and generates an operation log;
specifically, the server acquires a modification instruction input by a user through a modification page, wherein the modification instruction is used for indicating a correct data value corresponding to at least one candidate report form index data; and the server generates an operation log according to the at least one item of candidate report index data and the corresponding correct data value.
(3) And the server performs statistics again on the target financial data according to the operation log to generate a plurality of items of target index data.
Specifically, the server modifies at least one item of candidate report index data according to the operation log to obtain a plurality of modified report index data, and determines the plurality of modified report index data as a plurality of target index data.
105. And generating a financial data report of the target month according to the plurality of items of target index data.
Specifically, the server determines an initial report template according to the multiple items of target index data, wherein the initial report template is in a target template format; and the server respectively imports a plurality of items of target index data into the initial report template according to the target template format to obtain the financial data report of the target month.
According to the embodiment of the invention, the financial data of the target month is synchronized to the financial monthly database from the TiDB through the Sqoop tool, the financial data of the target month is automatically collected and counted, and a financial data report is automatically generated, so that manual participation is reduced, the accuracy of the financial data report is improved, and the time consumed by financial data counting is further reduced.
Referring to fig. 2, another flowchart of a method for generating a financial data report according to an embodiment of the present invention specifically includes:
201. and acquiring initial data through the big data service platform, wherein the initial data comprises data generated in each business system.
The server obtains initial data through the big data service platform, and the initial data comprises data generated in each business system.
It should be noted that, the data generated in the service system may include a dynamic sales table, a dynamic balance table, a completion status table, and the like, which is not limited herein.
The big data service platform may simply summarize the collected data to obtain the collected original data, for example, a T +1 synchronous dynamic sales table, a T +1 synchronous dynamic balance table, a monthly synchronous cutting sales table, a synchronous completion status table, and the like, which is not limited herein.
It is understood that the executing subject of the present invention may be a generating device of financial data report, and may also be a server, which is not limited herein. The embodiment of the present invention is described by taking a server as an execution subject.
202. And preprocessing the initial data to obtain various index data sets, and synchronizing the various index data sets to the TiDB database.
The server preprocesses the initial data to obtain various index data sets, and synchronizes the various index data sets to the TiDB database.
The big data platform BDSP collects raw data from various business systems using tools such as Sqoop, Debezium, golden Gate, ftp, etc. The collected original data can be processed daily to generate useful index data, such as application numbers, cost information, proportion information, dimension information, balance data, sales table data and the like, and the information can be stored in the hive library and is synchronized to the TiDB library at regular time.
Note that, each index data synchronized to the TiDB database includes data related to finance, and is determined as financial data.
203. Acquiring a first instruction input by a user, wherein the first instruction is used for indicating the start of counting financial data of a target month.
The server acquires a first instruction input by a user, wherein the first instruction is used for indicating the start of counting the financial data of the target month. The financial data may include various financial index data, such as sales, balance, etc., which is not limited herein.
204. And reading the financial data of the target month from a preset TiDB database according to the first instruction, and calling a preset Sqoop tool to synchronize the financial data of the target month to a financial month end database to obtain the target financial data.
Specifically, the server analyzes the first instruction to obtain a first identifier, wherein the first identifier is used for indicating a target month; the server inquires financial data corresponding to the target month in a preset TiDB database according to the first identification to obtain candidate data corresponding to the target month, wherein the candidate data comprise a plurality of financial index data; and the server calls a preset Sqoop tool to synchronize the candidate data corresponding to the target month to the financial month end database to generate the target financial data.
It should be noted that before each data statistics, the financial data for the target month (e.g., the previous month) is synchronized from the TiDB distributed database to the financial lunar junction database (i.e., the database of the financial lunar junction system) via the Sqoop tool. This process solidifies the data for the target month, and does not affect the corresponding data in the financial monthly node database when the source data (data for the target month) in the TiDB database is modified.
205. And determining a plurality of report indexes according to preset configuration information in the financial monthly database, wherein the preset configuration information is used for indicating the Structured Query Language (SQL) query statement identification.
Specifically, the server reads preset configuration information in a financial monthly database to obtain target configuration information; the server analyzes the target configuration information to obtain a plurality of SQL query statement identifications; the server determines an SQL query condition corresponding to each SQL query statement identifier according to the SQL query statement identifiers to obtain a plurality of SQL query conditions; and the server determines the index corresponding to each SQL query condition according to the SQL query conditions to obtain a plurality of report indexes.
It should be noted that, after the automatic processing, the workload of financial staff is reduced, and the indexes of the automatic processing can ensure that the indexes of each month are consistent, so that the process efficiency of automatic summarization is higher.
206. And counting the target financial data according to the multiple report indexes to generate multiple target index data.
And the server counts the target financial data according to the multiple report indexes to generate multiple target index data. Specifically, the server traverses the target financial data according to a plurality of report indexes, and determines a plurality of financial data corresponding to each report index; the server collects the multiple financial data corresponding to each report index to obtain multiple index candidate data, wherein each index candidate data comprises multiple financial data; and the server checks the multiple index candidate data in sequence, and when all the multiple index candidate data pass the check, the multiple index candidate data are determined as multiple target index data.
Optionally, after the server sequentially performs verification on the multiple index candidate data, the method further includes:
(1) when the index data of the multiple reports do not pass the verification, the server generates a modification page;
specifically, when the plurality of report index data do not pass the verification, the server determines the report index data which do not pass the verification as candidate report index data to obtain at least one item of candidate report index data; and generating a modification page according to the at least one item of candidate report form index data.
Part of index data in the index data of the multiple reports does not meet the requirements, for example, sales data in the monthly summary data have errors, modification and adjustment of the unqualified sales data are required, that is, a modification page corresponding to the sales data is generated, and a user can adjust a specific numerical value of the sales data in the modification page.
(2) When the modification page obtains a modification instruction input by a user, the server updates data according to the modification instruction and generates an operation log;
specifically, the server acquires a modification instruction input by a user through a modification page, wherein the modification instruction is used for indicating a correct data value corresponding to at least one candidate report form index data; and the server generates an operation log according to the at least one item of candidate report index data and the corresponding correct data value.
(3) And the server performs statistics again on the target financial data according to the operation log to generate a plurality of items of target index data.
Specifically, the server modifies at least one item of candidate report index data according to the operation log to obtain a plurality of modified report index data, and determines the plurality of modified report index data as a plurality of target index data.
207. And generating a financial data report of the target month according to the plurality of items of target index data.
Specifically, the server determines an initial report template according to the multiple items of target index data, wherein the initial report template is in a target template format; and the server respectively imports a plurality of items of target index data into the initial report template according to the target template format to obtain the financial data report of the target month.
It should be noted that the server mind to send the financial data report to the relevant personnel through the pre-configured mail template. The server can also lock the multiple items of target index data for later calling.
According to the embodiment of the invention, the financial data of the target month is synchronized to the financial monthly database from the TiDB through the Sqoop tool, the financial data of the target month is automatically collected and counted, and a financial data report is automatically generated, so that manual participation is reduced, the accuracy of the financial data report is improved, and the time consumed by financial data counting is further reduced.
In the above description of the method for generating a financial data report in the embodiment of the present invention, referring to fig. 3, a device for generating a financial data report in the embodiment of the present invention is described below, where an embodiment of the device for generating a financial data report in the embodiment of the present invention includes:
an instruction obtaining module 301, configured to obtain a first instruction input by a user, where the first instruction is used to instruct to start counting financial data of a target month;
a synchronization module 302, configured to read the financial data of the target month from a preset TiDB database according to the first instruction, and call a preset Sqoop tool to synchronize the financial data of the target month to a financial month end database, so as to obtain target financial data;
a determining module 303, configured to determine multiple report indicators according to preset configuration information in the financial monthly database, where the preset configuration information is used to indicate a structured query language SQL query statement identifier;
the statistical module 304 is used for performing statistics on the target financial data according to the multiple report indexes to generate multiple target index data;
a generating module 305, configured to generate a financial data report of the target month according to the multiple items of target index data.
According to the embodiment of the invention, the financial data of the target month is synchronized to the financial monthly database from the TiDB through the Sqoop tool, the financial data of the target month is automatically collected and counted, and a financial data report is automatically generated, so that manual participation is reduced, the accuracy of the financial data report is improved, and the time consumed by financial data counting is further reduced.
Referring to fig. 4, another embodiment of the apparatus for generating a financial data report according to the embodiment of the present invention includes:
an instruction obtaining module 301, configured to obtain a first instruction input by a user, where the first instruction is used to instruct to start counting financial data of a target month;
a synchronization module 302, configured to read the financial data of the target month from a preset TiDB database according to the first instruction, and call a preset Sqoop tool to synchronize the financial data of the target month to a financial month end database, so as to obtain target financial data;
a determining module 303, configured to determine multiple report indicators according to preset configuration information in the financial monthly database, where the preset configuration information is used to indicate a structured query language SQL query statement identifier;
the statistical module 304 is used for performing statistics on the target financial data according to the multiple report indexes to generate multiple target index data;
a generating module 305, configured to generate a financial data report of the target month according to the multiple items of target index data.
Optionally, the synchronization module 302 is specifically configured to:
analyzing the first instruction to obtain a first identifier, wherein the first identifier is used for indicating a target month;
querying financial data corresponding to the target month in a preset TiDB database according to the first identifier to obtain candidate data corresponding to the target month, wherein the candidate data comprise a plurality of financial index data;
and calling a preset Sqoop tool to synchronize the candidate data corresponding to the target month to the financial month junction database to generate target financial data.
Optionally, the determining module 303 is specifically configured to:
reading preset configuration information in the financial monthly database to obtain target configuration information;
analyzing the target configuration information to obtain a plurality of SQL query statement identifications;
determining an SQL query condition corresponding to each SQL query statement identifier according to the SQL query statement identifiers to obtain a plurality of SQL query conditions;
and determining indexes corresponding to each SQL query condition according to the SQL query conditions to obtain multiple report indexes.
Optionally, the statistic module 304 includes:
a traversal unit 3041, configured to traverse the target financial data according to the multiple report indexes, and determine multiple financial data corresponding to each report index;
a summarizing unit 3042, configured to summarize multiple items of financial data corresponding to each report indicator to obtain multiple items of indicator candidate data, where each item of indicator candidate data includes multiple items of financial data;
a verification determination unit 3043, configured to sequentially perform verification on the multiple items of index candidate data, and determine the multiple items of index candidate data as multiple items of target index data when all the multiple items of index candidate data pass the verification.
Optionally, the statistic module 304 further includes:
a first generating unit 3044, configured to generate a modification page when all the report index data passes the verification;
a second generating unit 3045, configured to, when the modification page obtains a modification instruction input by a user, update data according to the modification instruction, and generate an operation log at the same time;
a third generating unit 3046, configured to perform statistics again on the target financial data according to the operation log, and generate multiple items of target index data.
Optionally, the generating module 305 is specifically configured to:
determining an initial report template according to the multiple items of target index data, wherein the initial report template is in a target template format;
and respectively importing the multiple items of target index data into the initial report template according to the target template format to obtain a financial data report of a target month.
Optionally, the generating device of the financial data report further includes:
a data obtaining module 306, configured to obtain initial data through a big data service platform, where the initial data includes data generated in each service system;
and a preprocessing module 307, configured to preprocess the initial data to obtain multiple index data sets, and synchronize the multiple index data sets to the TiDB database.
According to the embodiment of the invention, the financial data of the target month is synchronized to the financial monthly database from the TiDB through the Sqoop tool, the financial data of the target month is automatically collected and counted, and a financial data report is automatically generated, so that manual participation is reduced, the accuracy of the financial data report is improved, and the time consumed by financial data counting is further reduced.
The above fig. 3 to fig. 4 describe in detail the generating device of the financial data report in the embodiment of the present invention from the perspective of the modular functional entity, and the following describes in detail the generating device of the financial data report in the embodiment of the present invention from the perspective of hardware processing.
FIG. 5 is a schematic structural diagram of a financial data report generating device according to an embodiment of the present invention, where the financial data report generating device 500 may generate relatively large differences due to different configurations or performances, and may include one or more processors (CPUs) 510 (e.g., one or more processors) and a memory 520, and one or more storage media 530 (e.g., one or more mass storage devices) for storing applications 533 or data 532. Memory 520 and storage media 530 may be, among other things, transient or persistent storage. The program stored on the storage medium 530 may include one or more modules (not shown), each of which may include a series of instruction operations in the generation device 500 for financial data reports. Still further, the processor 510 may be configured to communicate with the storage medium 530 to execute a series of instruction operations in the storage medium 530 on the financial data statement generating device 500.
The financial data statement generating device 500 may also include one or more power supplies 540, one or more wired or wireless network interfaces 550, one or more input-output interfaces 560, and/or one or more operating systems 531, such as Windows Server, Mac OS X, Unix, Linux, FreeBSD, and the like. Those skilled in the art will appreciate that the configuration of the generating device of the financial data report shown in FIG. 5 does not constitute a limitation of the generating device of the financial data report and may include more or fewer components than shown, or some components may be combined, or a different arrangement of components.
The present invention also provides a computer-readable storage medium, which may be a non-volatile computer-readable storage medium, and which may also be a volatile computer-readable storage medium, having stored therein instructions, which, when run on a computer, cause the computer to perform the steps of the method for generating a financial data statement.
Further, the computer-readable storage medium may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function, and the like; the storage data area may store data created according to the use of the blockchain node, and the like.
The block chain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A block chain (Blockchain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A method for generating a financial data statement, comprising:
acquiring a first instruction input by a user, wherein the first instruction is used for indicating the start of counting financial data of a target month;
reading the financial data of the target month from a preset TiDB database according to the first instruction, and calling a preset Sqoop tool to synchronize the financial data of the target month to a financial month junction database to obtain target financial data;
determining a plurality of report indexes according to preset configuration information in the financial monthly database, wherein the preset configuration information is used for indicating a Structured Query Language (SQL) query statement mark;
counting the target financial data according to the multiple report indexes to generate multiple target index data;
and generating a financial data report of the target month according to the plurality of items of target index data.
2. A method for generating a financial data report according to claim 1, wherein the reading the financial data of the target month from a preset TiDB database according to the first instruction, and invoking a preset Sqoop tool to synchronize the financial data of the target month to a financial monthly database to obtain the target financial data comprises:
analyzing the first instruction to obtain a first identifier, wherein the first identifier is used for indicating a target month;
querying financial data corresponding to the target month in a preset TiDB database according to the first identifier to obtain candidate data corresponding to the target month, wherein the candidate data comprise a plurality of financial index data;
and calling a preset Sqoop tool to synchronize the candidate data corresponding to the target month to the financial month junction database to generate target financial data.
3. The method of generating a financial data statement according to claim 1 wherein said determining a plurality of statement indicators based on preset configuration information in said financial monthly database, said preset configuration information indicating Structured Query Language (SQL) query statement identifiers comprises:
reading preset configuration information in the financial monthly database to obtain target configuration information;
analyzing the target configuration information to obtain a plurality of SQL query statement identifications;
determining an SQL query condition corresponding to each SQL query statement identifier according to the SQL query statement identifiers to obtain a plurality of SQL query conditions;
and determining indexes corresponding to each SQL query condition according to the SQL query conditions to obtain multiple report indexes.
4. A method for generating a financial data statement according to claim 1 wherein said accounting for said target financial data in accordance with said plurality of statement indicators to generate a plurality of target indicator data includes:
traversing the target financial data according to the multiple report indexes, and determining multiple financial data corresponding to each report index;
summarizing the multiple financial data corresponding to each report index to obtain multiple index candidate data, wherein each index candidate data comprises multiple financial data;
and sequentially checking the multiple index candidate data, and determining the multiple index candidate data as multiple target index data when all the multiple index candidate data pass the check.
5. The method of generating a financial data report according to claim 4 wherein, after said sequentially verifying said plurality of index candidates and determining said plurality of index candidates as a plurality of target index data when all of said plurality of index candidates pass said verification, said method of generating a financial data report further comprises:
when all the report form index data do not pass the verification, generating a modification page;
when the modification page obtains a modification instruction input by a user, updating data according to the modification instruction, and simultaneously generating an operation log;
and performing statistics again on the target financial data according to the operation log to generate a plurality of items of target index data.
6. A method of generating a financial data report according to claim 1 in which generating a financial data report for a target month from the plurality of target index data includes:
determining an initial report template according to the multiple items of target index data, wherein the initial report template is in a target template format;
and respectively importing the multiple items of target index data into the initial report template according to the target template format to obtain a financial data report of a target month.
7. A method of generating a financial data statement according to any one of claims 1-6 further including, prior to said obtaining the first user-entered instruction:
acquiring initial data through a big data service platform, wherein the initial data comprises data generated in each business system;
and preprocessing the initial data to obtain various index data sets, and synchronizing the various index data sets to a TiDB database.
8. An apparatus for generating a financial data statement, comprising:
the instruction acquisition module is used for acquiring a first instruction input by a user, wherein the first instruction is used for indicating the start of counting financial data of a target month;
the synchronization module is used for reading the financial data of the target month from a preset TiDB database according to the first instruction, and calling a preset Sqoop tool to synchronize the financial data of the target month to a financial month junction database to obtain the target financial data;
the determining module is used for determining a plurality of report indexes according to preset configuration information in the financial monthly database, wherein the preset configuration information is used for indicating the marks of Structured Query Language (SQL) query sentences;
the statistical module is used for carrying out statistics on the target financial data according to the multiple report indexes to generate multiple target index data;
and the generating module is used for generating a financial data report of the target month according to the plurality of items of target index data.
9. A financial data statement generation device, wherein the financial data statement generation device comprises: a memory having instructions stored therein and at least one processor, the memory and the at least one processor interconnected by a line;
the at least one processor invoking the instructions in the memory to cause the financial data statement generation device to perform the financial data statement generation method of any one of claims 1-7.
10. A computer-readable storage medium storing instructions which, when executed by a processor, implement a method of generating a financial data statement as claimed in any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011282956.7A CN112380278A (en) | 2020-11-17 | 2020-11-17 | Financial data report generation method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011282956.7A CN112380278A (en) | 2020-11-17 | 2020-11-17 | Financial data report generation method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112380278A true CN112380278A (en) | 2021-02-19 |
Family
ID=74584888
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011282956.7A Pending CN112380278A (en) | 2020-11-17 | 2020-11-17 | Financial data report generation method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112380278A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115099922A (en) * | 2022-08-29 | 2022-09-23 | 江西科技学院 | Financial data query method, system, readable storage medium and computer equipment |
| CN115293871A (en) * | 2022-10-08 | 2022-11-04 | 山东工程职业技术大学 | Multi-terminal financial data management method and system |
| CN116737762A (en) * | 2023-08-08 | 2023-09-12 | 北京衡石科技有限公司 | Structured query statement generation method, device and computer readable medium |
| DE202023103820U1 (en) | 2023-07-09 | 2023-09-19 | Ankit Agarwal | System based on artificial intelligence and blockchain technology to improve the quality of financial reporting and relationships between auditors and clients |
-
2020
- 2020-11-17 CN CN202011282956.7A patent/CN112380278A/en active Pending
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115099922A (en) * | 2022-08-29 | 2022-09-23 | 江西科技学院 | Financial data query method, system, readable storage medium and computer equipment |
| CN115099922B (en) * | 2022-08-29 | 2022-11-08 | 江西科技学院 | Financial data query method, system, readable storage medium and computer equipment |
| CN115293871A (en) * | 2022-10-08 | 2022-11-04 | 山东工程职业技术大学 | Multi-terminal financial data management method and system |
| DE202023103820U1 (en) | 2023-07-09 | 2023-09-19 | Ankit Agarwal | System based on artificial intelligence and blockchain technology to improve the quality of financial reporting and relationships between auditors and clients |
| CN116737762A (en) * | 2023-08-08 | 2023-09-12 | 北京衡石科技有限公司 | Structured query statement generation method, device and computer readable medium |
| CN116737762B (en) * | 2023-08-08 | 2023-10-27 | 北京衡石科技有限公司 | Structured query statement generation method, device and computer readable medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112380278A (en) | Financial data report generation method, device, equipment and storage medium | |
| CN110292775B (en) | Method and device for acquiring difference data | |
| CN110908997A (en) | Data blood margin construction method and device, server and readable storage medium | |
| US8489639B2 (en) | Information source alignment | |
| CN110837520A (en) | Data processing method, platform and system | |
| US6708185B2 (en) | SQL execution analysis | |
| CN106844320B (en) | Financial statement integration method and equipment | |
| CN112579586A (en) | Data processing method, device, equipment and storage medium | |
| CN102890720A (en) | Database inspection and maintenance method | |
| CN111125116B (en) | Method and system for positioning code field in service table and corresponding code table | |
| CN109714249B (en) | Method and related device for pushing applet messages | |
| CN110659282A (en) | Data route construction method and device, computer equipment and storage medium | |
| CN113420026A (en) | Database table structure changing method, device, equipment and storage medium | |
| CN110781183A (en) | Method and device for processing incremental data in Hive database and computer equipment | |
| CN104199945A (en) | Data storing method and device | |
| CN114461644A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN116719822B (en) | Method and system for storing massive structured data | |
| CN112527818A (en) | Report generation method, device, equipment and storage medium | |
| CN116701355A (en) | Data view processing method, device, computer equipment and readable storage medium | |
| CN116362212A (en) | Report generation method, device, equipment and storage medium | |
| CN106682107B (en) | Method and device for determining incidence relation of database table | |
| CN115618825A (en) | Financial statement merging method and device, computer readable medium and terminal equipment | |
| CN115034917A (en) | Screening method and device for social security fund release data risk information | |
| CN114238328A (en) | Data paging query method, device, equipment and storage medium | |
| CN114090558A (en) | Data quality management method and device for database |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20210219 |
|
| WD01 | Invention patent application deemed withdrawn after publication |