CN117592757A - Report data processing method, device, computer equipment and storage medium - Google Patents
Report data processing method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN117592757A CN117592757A CN202311787817.3A CN202311787817A CN117592757A CN 117592757 A CN117592757 A CN 117592757A CN 202311787817 A CN202311787817 A CN 202311787817A CN 117592757 A CN117592757 A CN 117592757A
- Authority
- CN
- China
- Prior art keywords
- report
- reporting
- comparison
- item
- mapping relation
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06313—Resource planning in a project environment
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/123—Tax preparation or submission
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- General Physics & Mathematics (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Technology Law (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Educational Administration (AREA)
- Biodiversity & Conservation Biology (AREA)
- Life Sciences & Earth Sciences (AREA)
- Game Theory and Decision Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application relates to a report data processing method, a report data processing device, computer equipment and a storage medium. The method comprises the following steps: responding to the received report comparison request, and acquiring an item mapping relation between the reporting report and the reporting report, wherein the item mapping relation is established based on the identification corresponding to each reporting item in the reporting report and the identification corresponding to each reporting item in the reporting report; comparing the report form and the reporting report form according to the project mapping relation to generate a comparison difference result; and returning a comparison difference result. By adopting the method, the report comparison efficiency can be improved. The present invention can be applied to various business systems such as enterprise resource planning systems (Enterprise Resource Planning, ERP), enterprise management systems, tax systems, financial systems, human systems, supply chain systems, etc.
Description
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a report data processing method, apparatus, computer device, and storage medium.
Background
Enterprises need to budget the annual tax in the beginning of the year each year to generate a billing report. However, due to the influence of external factors, the budget data always has a certain difference from the actual reporting data in the reporting report, so that the accounting data in the account needs to be corrected according to the actual reporting data. Before correction, it is often necessary to determine the difference between the declared report and the submitted report.
In the conventional technology, a user usually defines comparison items and performs comparison rule configuration for each comparison item, so that differences between a declaration report and a planning report are determined according to manually configured comparison rules.
However, the method of user-defining comparison items and configuring the comparison rules for each comparison item is cumbersome to operate and time-consuming, and cannot meet the requirement of quickly obtaining the difference between the declared report and the log report.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a report data processing method, apparatus, computer device, computer readable storage medium, and computer program product that can improve the alignment efficiency.
In a first aspect, the present application provides a report data processing method. The method comprises the following steps: responding to the received report comparison request, and acquiring an item mapping relation between a report form and a reporting report form, wherein the item mapping relation is established based on the identification corresponding to each report item in the report form and the identification corresponding to each reporting item in the reporting report form; comparing the report form with the report form according to the project mapping relation to generate a comparison difference result; and returning the comparison difference result.
In a second aspect, the present application further provides a report data processing apparatus. The device comprises: the system comprises a mapping relation acquisition module, a reporting module and a reporting module, wherein the mapping relation acquisition module is used for responding to a received report comparison request to acquire an item mapping relation between a reporting report and a reporting report, and the item mapping relation is established based on an identifier corresponding to each reporting item in the reporting report and an identifier corresponding to each reporting item in the reporting report; the report comparison module is used for comparing the report form and the reporting report form according to the project mapping relation to generate a comparison difference result; and the result returning module is used for returning the comparison difference result.
In some embodiments, the report data processing apparatus further includes a mapping relation establishment module, where the mapping relation establishment module is configured to: acquiring a planning report and a reporting report generated based on the same report template; determining identifiers corresponding to each reporting item in the reporting report from the report template, and determining identifiers corresponding to each reporting item in the reporting report from the report template; and establishing an item mapping relation between the counting report and the reporting report based on the identifiers corresponding to the counting items and the identifiers corresponding to the reporting items.
In some embodiments, the mapping relationship establishment module is further configured to: determining a reporting item with the same identification as the reporting item from the reporting report for each reporting item in the reporting report; determining the counting item and the reporting item with the same identification as a comparison item group; and obtaining an item mapping relation between the statement and the reporting statement based on the mapping relation between the statement and the reporting item in each comparison item group.
In some embodiments, the report comparison module is further to: for each comparison item group, determining a count-up value corresponding to a count-up item in the comparison item group from the count-up report, and determining a reporting value corresponding to a reporting item in the comparison item group from the reporting report; determining a preset comparison formula corresponding to the comparison item group; substituting the count value and the declaration value into the preset comparison formula to obtain a difference value corresponding to the comparison item group; and obtaining a comparison difference result between the report form and the reporting report form based on the difference value corresponding to the comparison item group.
In some embodiments, the report comparison module is further to: determining a first comparison result according to the difference value corresponding to each comparison item group; determining target time-keeping items which do not belong to any comparison item group from the time-keeping report, and determining a second comparison result based on time-keeping values corresponding to the target time-keeping items; determining target reporting items which do not belong to any one of the comparison item groups from the reporting report, and determining a third comparison result based on reporting values corresponding to the target reporting items; and obtaining a comparison difference result between the statement and the declaration statement based on the first comparison result, the second comparison result and the third comparison result.
In some embodiments, the reporting template is a table comprising a plurality of cells; the mapping relation establishing module is further used for: determining the position information of a corresponding cell of each counting item in the report template aiming at each counting item; and determining the identification corresponding to the time-to-day item according to the position information.
In some embodiments, the report comparison module is further to: acquiring a preset comparison scheme under the condition that the preset comparison scheme exists between the report form and the reporting form; and comparing the report form with the reporting report form according to the project mapping relation and the preset comparison method, and generating a comparison difference result.
In a third aspect, the present application also provides a computer device. The computer device comprises a memory and a processor, wherein the memory stores a computer program, and the processor realizes the steps in the report data processing method when executing the computer program.
In a fourth aspect, the present application also provides a computer-readable storage medium. The computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the steps of the report data processing method described above.
In a fifth aspect, the present application also provides a computer program product. The computer program product comprises a computer program which, when executed by a processor, implements the steps of the report data processing method described above.
According to the report data processing method, the device, the computer equipment, the storage medium and the computer program product, the received report comparison request is responded, the project mapping relation between the count-up report and the reporting report is obtained, and because the project mapping relation is established based on the identification corresponding to each count-up project in the count-up report and the identification corresponding to each reporting project in the reporting report, the count-up report and the reporting report can be directly compared according to the project mapping relation, comparison difference results can be quickly generated, automatic report comparison is realized, time consumption of manual rule configuration is reduced, and therefore the report comparison efficiency is improved.
Drawings
FIG. 1 is a diagram of an application environment for a method of processing tabular data in one embodiment;
FIG. 2 is a flow chart of a method of processing report data in one embodiment;
FIG. 3 is a flow chart of the prior report alignment in one embodiment;
FIG. 4 is a flow chart of a method for generating a differential comparison result in one embodiment;
FIG. 5 is a block diagram of a newspaper table data processing apparatus in one embodiment;
FIG. 6 is an internal block diagram of a computer device in one embodiment;
fig. 7 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.
The report data processing method provided by the embodiment of the application can be applied to an application environment shown in fig. 1. The application environment includes a terminal 102 and a server 104, wherein the terminal 102 may be a terminal used by an audit or tax related manager of the enterprise, and the server 104 is a background server of a management platform of the enterprise. The terminal 102 communicates with the server 104 via a network. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104 or may be located on a cloud or other network server.
Specifically, the terminal 102 sends a report alignment request to the server. The server 104 responds to the received report comparison request to acquire an item mapping relation between the count-up report and the reporting report, wherein the item mapping relation is established based on the identification corresponding to each count-up item in the count-up report and the identification corresponding to each reporting item in the reporting report; comparing the report form and the reporting report form according to the project mapping relation to generate a comparison difference result; the server 104 returns a comparison discrepancy result. The terminal 102 receives the comparison difference result returned by the server 104 and displays the comparison difference result.
The terminal 102 may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers. The server 104 may be implemented as a stand-alone server or as a server cluster of multiple servers.
Those skilled in the art will appreciate that the application environment shown in fig. 1 is only a partial scenario related to the present application scenario, and does not constitute a limitation on the application environment of the present application scenario.
In some embodiments, as shown in fig. 3, a flow chart of the existing report form comparison is shown, the data format of the difference comparison result is shown in (a) in fig. 3, the comparison items are manually filled in by the user, and the amounts are obtained one by one according to the entered comparison items. Fig. 3 (B) shows the process and comparison result of comparing report a and report B. Obviously, the existing report comparison needs to take more time to carry out comparison rule configuration, and the comparison result is not clear and comprehensive enough.
In some embodiments, as shown in fig. 2, a report data processing method is provided, where the method may be performed by a terminal or a server, and may also be performed by the terminal and the server together, and the method is applied to the server 104 in fig. 1, and is described by taking as an example, the following steps are included:
step 202, obtaining an item mapping relation between the statement and the reporting statement in response to the received statement comparison request, wherein the item mapping relation is established based on the identification corresponding to each statement item in the statement and the identification corresponding to each reporting item in the reporting statement.
The report comparison request is used for comparing the report form and the reporting report form. The statement of account is a statement obtained by multiplying a predetermined rate by a predetermined base, calculating and extracting the expense which has not yet occurred but will occur, and listing a subject, and is also called a statement of account manuscript. The counting item is a subject in the counting report. The declaration report is a report for recording the actual declaration tax of the enterprise, and is also called a declaration manuscript, and the declaration item is a subject in the declaration report. The project mapping relation refers to the mapping relation between the project of the project report and the project of the report.
Specifically, the terminal responds to report comparison operation triggered by a report comparison page, acquires report screening information input by a user from the report comparison page, and sends a report comparison request carrying the report screening information to the server, wherein the report screening information comprises at least one of tax organization, tax system, account book type, comparison year and the like. The server receives a report comparison request sent by the terminal, acquires a report form and a reporting form which accord with report screening information from a plurality of locally stored reports, and acquires a project mapping relation between the report form and the reporting form.
In some embodiments, the project mapping relationship may be pre-established based on the identifier corresponding to each of the count-up items in the count-up report and the identifier corresponding to each of the reporting items in the reporting report, and stored in the server, so that the server may directly obtain the project mapping relationship between the count-up report and the reporting report.
In some embodiments, the project map may also be established in real-time in response to a report alignment request. The server responds to the report comparison request, acquires a report form and a reporting report form generated based on the same report template, determines the identifiers corresponding to the report items in the report form from the report template, determines the identifiers corresponding to the reporting items in the reporting report form from the report template, and establishes an item mapping relation between the report form and the reporting report form based on the identifiers corresponding to the report items and the identifiers corresponding to the reporting items. The report template is a table template for generating a report form and a declaration form.
And 204, comparing the report form with the declaration report form according to the project mapping relation to generate a comparison difference result.
Wherein, the comparison difference results represent the difference between the report form and the report form.
Specifically, the project mapping relationship includes mapping relationships of each of a plurality of comparison project groups, and the comparison project groups include at least one time-to-mention project and at least one declaration project. For each comparison item group, the server can determine the count-up value corresponding to the count-up item in the comparison item group from the count-up report, determine the reporting value corresponding to the reporting item in the comparison item group from the reporting report, and calculate the difference between the count-up value and the reporting value, thereby obtaining the difference value corresponding to the comparison item group. And then the server obtains a comparison difference result between the report form and the reporting report form based on the difference values corresponding to the comparison items respectively.
And 206, returning a comparison difference result.
Specifically, the server may return the comparison difference result to the terminal. The terminal receives the comparison difference result returned by the server and displays the comparison difference result according to a preset format, for example, the preset format may be a table, and the terminal may display the comparison difference result in a table form, for example, as shown in fig. 4, the comparison difference result in a table form is displayed, and one line of data in the table includes a count-up item, a count-up value, a reporting item, a reporting value and a difference value.
In some embodiments, the terminal may respond to the editing operation for the comparison difference result, acquire the target item and the updated value, and send an editing request carried by the target item and the updated value to the server, where the target item may be any one of each statement item in the statement or each declaration item in the declaration statement. The server receives an editing request for the comparison difference result sent by the terminal, updates the item value of the target item in the comparison difference result based on the updated value, obtains an updated comparison difference result, and returns the updated comparison difference result to the terminal.
Alternatively, the report data processing method provided by the embodiment of the application can be applied to various business systems, such as an enterprise resource planning system (Enterprise Resource Planning, ERP), an enterprise management system, a tax system, a financial system, a human power system, a supply chain system and the like.
In the report data processing method, the received report comparison request is responded, the project mapping relation between the count-up report and the reporting report is obtained, and because the project mapping relation is established based on the identification corresponding to each count-up project in the count-up report and the identification corresponding to each reporting project in the reporting report, the count-up report and the reporting report can be directly compared according to the project mapping relation, a comparison difference result is quickly generated, automatic report comparison is realized, the time consumption of manual rule configuration is reduced, and the report comparison efficiency is improved. In addition, the simultaneous comparison of a plurality of rows and a plurality of columns is pulled based on the project mapping relation, so that the report comparison efficiency is further improved.
In some embodiments, the method for establishing the project mapping relation between the report form and the declaration form comprises the following steps: acquiring a planning report and a reporting report generated based on the same report template; determining the identifiers corresponding to each reporting item in the reporting report from the report template, and determining the identifiers corresponding to each reporting item in the reporting report from the report template; and establishing an item mapping relation between the report form and the reporting report form based on the identifiers corresponding to the reporting items and the identifiers corresponding to the reporting items.
The report template is a form template and is used for generating a timing report and a reporting report, and each cell in the report template has a unique identifier.
Specifically, the server obtains a report form and a reporting form generated based on the same report template according to the report comparison request, determines the cell corresponding to each report item in the report form from the report template, determines the cell identifier corresponding to each report item in the report form as the cell corresponding to each report item in the report form, and determines the cell identifier corresponding to each reporting item in the reporting form as the reporting item identifier, thereby establishing an item mapping relation between the report form and the reporting form according to the identifier corresponding to each report item and the identifier corresponding to each reporting item, for example, the mapping relation can be established for the same report item and reporting item identifier.
In this embodiment, since the report form and the report form are generated based on the same report form template, the identifiers corresponding to the report form and the report form can be determined from the report form template, and the project mapping relationship between the report form and the report form is established according to the identifiers corresponding to the report form and the report form, so that the association relationship between different report forms is mapped, and the automatic comparison can be performed without configuration.
In some embodiments, establishing an item mapping relationship between the statement and the declared report based on the identifiers corresponding to the respective statement items and the identifiers corresponding to the respective declared items includes: determining a reporting item with the same identification as the reporting item from the reporting report for each reporting item in the reporting report; determining the counting item and the reporting item with the same identification as a comparison item group; and obtaining the project mapping relation between the report form and the reporting form based on the mapping relation between the report form and the reporting form in each comparison project group.
The comparison item group comprises at least one counting item and at least one reporting item, wherein at least one refers to one or more counting items and reporting items in the comparison item group have the same identification.
Specifically, for each counting item in the counting report, the server can search in each reporting item in the reporting report according to the identifier corresponding to the counting item, if the counting item with the same identifier corresponding to the counting item is obtained by searching, the counting item with the same identifier and the reporting item are determined to be a comparison item group, and the item mapping relation between the counting report and the reporting report is obtained based on the mapping relation between the counting item and the reporting item in each comparison item group.
In the embodiment, the project mapping relation between the report form and the reporting form is established based on each comparison project group by determining the same identification of the report project and the reporting project as one comparison project group, so that a foundation is provided for automatic report comparison.
In some embodiments, comparing the statement of statement and the claim statement according to the project mapping relation, generating a comparison difference result comprises: for each comparison item group, determining a count-up value corresponding to the count-up item in the comparison item group from a count-up report, and determining a reporting value corresponding to the reporting item in the comparison item group from a reporting report; determining a preset comparison formula corresponding to the comparison item group; substituting the counting and reporting values into a preset comparison formula to obtain a difference value corresponding to the comparison item group; and obtaining a comparison difference result between the statement and the reporting statement based on the difference value corresponding to the comparison item group.
The count-up value refers to the budget amount corresponding to the count-up item, and the reporting value refers to the actual amount corresponding to the reporting item. The preset comparison formula is a preset formula for calculating the difference value.
Specifically, for each comparison item group, the server may obtain, from the report table, a count-up value corresponding to the count-up item in the comparison item group, obtain, from the report table, a reporting value corresponding to the reporting item in the comparison item group, and substitute the count-up value and the reporting value into a preset comparison formula to obtain a difference value corresponding to the comparison item group. For example, as shown in fig. 4, the preset comparison formula between the item a and the item b is F (), and the difference value between the item a and the item b may be represented as F (x 1, y 1).
In some embodiments, the server may determine the count-up item, count-up value, reporting item, reporting value, and difference value corresponding to the comparison item group in the comparison item group as a comparison difference record, so as to combine the comparison difference records corresponding to the comparison item groups to obtain a comparison difference result between the count-up report and the reporting report.
In the embodiment, the data in the statement of the count and report are automatically pulled through the project mapping relation, the count and report values are substituted into a preset comparison formula, the difference value corresponding to the comparison project group is obtained rapidly, and the report comparison efficiency is improved.
In some embodiments, obtaining a comparison difference result between the statement and the declared report based on the difference value corresponding to the comparison item group includes: determining a first comparison result according to the difference value corresponding to each comparison item group; determining target counting items which do not belong to any comparison item group from the counting report, and determining a second comparison result based on counting values corresponding to the target counting items; determining target reporting items which do not belong to any comparison item group from the reporting report, and determining a third comparison result based on reporting values corresponding to the target reporting items; and obtaining a comparison difference result between the report form and the reporting report form based on the first comparison result, the second comparison result and the third comparison result.
Wherein the first comparison result is a comparison result between the same count-up item and the claim item. The report forms can be generated based on part of the cells in the report form template, and the reporting forms can be generated based on part of the cells in the report form template, and because the part of the cells corresponding to the report forms in the report form template and the part of the cells corresponding to the reporting forms in the report form template are not necessarily the same, each report item and each reporting item do not correspond to each other one by one. The target counting items are counting items in which corresponding reporting items with the same identification do not exist in the counting items, and the second comparison result is determined based on the collective amount of the target counting items. The target reporting item is a reporting item of which the corresponding reporting item with the same identification does not exist, and the third comparison result is determined based on the reporting value corresponding to the target reporting item.
Specifically, the server may determine target counting items that do not belong to any comparison item group from the counting item table, and for each target counting item, generate a comparison difference record based on the target counting item and counting values corresponding to the target counting item, so as to obtain a second comparison result; and generating a comparison difference record according to each target declaration item and the counting extraction value corresponding to the target declaration item, thereby obtaining a third comparison result. For example, as shown in fig. 4, the 2 nd line data in the differential comparison result is the second comparison result, and the 3 rd line data in the differential comparison result is the third comparison result.
In this embodiment, the second comparison result is determined based on the count value corresponding to the target count item, and the third comparison result is determined based on the reporting value corresponding to the target reporting item, so that the comparison difference result is obtained based on the first comparison result, the second comparison result and the third comparison result, so that the comparison difference result can include a union of the count report and the reporting report, and the difference between the count report and the reporting report can be more comprehensively displayed.
In some embodiments, the reporting template is a table comprising a plurality of cells; from the report template, determining the identification corresponding to each report item in the report, including: determining the position information of a corresponding cell of each counting item in the report template aiming at each counting item; and determining the identification corresponding to the counting and lifting item according to the position information.
Wherein a reporting template may be understood as a table comprising a plurality of cells, such as an excel table, the location information of the cells in the reporting template comprising a row number and a column number,
specifically, since the counting and extracting report is generated based on the report template, the server can determine a corresponding cell of the counting and extracting item in the report template for each counting and extracting item in the counting and extracting report, and acquire a row serial number and a column serial number of the cell, so that an identifier corresponding to the counting and extracting item is determined according to the row serial number and the column serial number, for example, a sequence code obtained by splicing the row serial number and the column serial number can be determined as the identifier corresponding to the counting and extracting item. In addition, the process of determining the identifier corresponding to each reporting item may refer to the method for determining the identifier corresponding to the lifting item, which is not described herein.
In this embodiment, since the position of each cell in the report template is unique, by determining the position information of the corresponding cell in the report template for the counting item, the unique identifier corresponding to the counting item can be quickly determined according to the position information.
In some embodiments, comparing the statement of statement and the claim statement according to the project mapping relation, generating a comparison difference result comprises: under the condition that a preset comparison scheme exists between the report form and the reporting report form, acquiring the preset comparison scheme; and comparing the report form and the reporting report form according to the project mapping relation and a preset comparison scheme to generate a comparison difference result.
The preset comparison scheme is a comparison scheme preset by a user, and may also be referred to as a custom scheme, for example, the preset comparison scheme may be a special comparison rule set for some report items in a report form or a reporting report form, or may be a screening condition for a difference comparison result generated by default.
Specifically, under the condition that a preset comparison scheme does not exist between the statement and the reporting statement, the server defaults to compare the statement and the reporting statement according to the project mapping relation, and a comparison difference result is generated; under the condition that a preset comparison scheme exists between the report form and the reporting report form, the server acquires the preset comparison scheme, compares the report form with the reporting report form according to the project mapping relation and the preset comparison scheme, for example, can compare the report form with the reporting report form according to the project mapping relation to generate candidate difference results, and then selects comparison difference records conforming to the preset comparison scheme from the candidate difference results as comparison difference results. And comparing the specific counting item with the reporting item according to a preset comparison result to generate a fourth comparison result, and generating a comparison difference result based on the first comparison result, the second comparison result, the third comparison result and the fourth comparison result.
In the embodiment, the statement and the declaration statement are compared according to the project mapping relation and the preset comparison method, and comparison difference results are generated, so that personalized requirements of different users can be met, and user experience is improved.
It should be understood that, although the steps in the flowcharts related to the above embodiments are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides a report data processing device for realizing the report data processing method. The implementation scheme of the solution to the problem provided by the device is similar to the implementation scheme described in the above method, so the specific limitation in the embodiments of one or more report data processing devices provided below may refer to the limitation of the report data processing method in the above description, and will not be repeated here.
In some embodiments, as shown in fig. 5, there is provided a report data processing apparatus, including: a mapping relationship obtaining module 502, a report comparison module 504 and a result returning module 506, wherein:
the mapping relation obtaining module 502 is configured to obtain, in response to the received report comparison request, an item mapping relation between the reporting report and the reporting report, where the item mapping relation is established based on an identifier corresponding to each reporting item in the reporting report and an identifier corresponding to each reporting item in the reporting report.
The report comparison module 504 is configured to compare the report form with the reporting report form according to the project mapping relationship, and generate a comparison difference result.
The result returning module 506 is configured to return a comparison difference result.
In some embodiments, the report data processing apparatus further includes a mapping relation establishment module, where the mapping relation establishment module is configured to: acquiring a planning report and a reporting report generated based on the same report template; determining the identifiers corresponding to each reporting item in the reporting report from the report template, and determining the identifiers corresponding to each reporting item in the reporting report from the report template; and establishing an item mapping relation between the report form and the reporting report form based on the identifiers corresponding to the reporting items and the identifiers corresponding to the reporting items.
In some embodiments, the mapping relationship establishment module is further configured to: determining a reporting item with the same identification as the reporting item from the reporting report for each reporting item in the reporting report; determining the counting item and the reporting item with the same identification as a comparison item group; and obtaining the project mapping relation between the report form and the reporting form based on the mapping relation between the report form and the reporting form in each comparison project group.
In some embodiments, the report comparison module 504 is further configured to: for each comparison item group, determining a count-up value corresponding to the count-up item in the comparison item group from a count-up report, and determining a reporting value corresponding to the reporting item in the comparison item group from a reporting report; determining a preset comparison formula corresponding to the comparison item group; substituting the counting and reporting values into a preset comparison formula to obtain a difference value corresponding to the comparison item group; and obtaining a comparison difference result between the statement and the reporting statement based on the difference value corresponding to the comparison item group.
In some embodiments, the report comparison module 504 is further configured to: determining a first comparison result according to the difference value corresponding to each comparison item group; determining target counting items which do not belong to any comparison item group from the counting report, and determining a second comparison result based on counting values corresponding to the target counting items; determining target reporting items which do not belong to any comparison item group from the reporting report, and determining a third comparison result based on reporting values corresponding to the target reporting items; and obtaining a comparison difference result between the report form and the reporting report form based on the first comparison result, the second comparison result and the third comparison result.
In some embodiments, the reporting template is a table comprising a plurality of cells; the mapping relation establishing module is also used for: determining the position information of a corresponding cell of each counting item in the report template aiming at each counting item; and determining the identification corresponding to the counting and lifting item according to the position information.
In some embodiments, the report comparison module 504 is further configured to: under the condition that a preset comparison scheme exists between the report form and the reporting report form, acquiring the preset comparison scheme; and comparing the report form and the reporting report form according to the project mapping relation and a preset comparison scheme to generate a comparison difference result.
The modules in the report data processing device can be all or partially realized by software, hardware and a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In some embodiments, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 6. The computer device includes a processor, a memory, an Input/Output interface (I/O) and a communication interface. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface is connected to the system bus through the input/output interface. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer equipment is used for storing related data related to the report data processing method. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for communicating with an external terminal through a network connection. The computer program, when executed by a processor, implements a report data processing method.
In some embodiments, a computer device is provided, which may be a terminal, and the internal structure of which may be as shown in fig. 7. The computer device includes a processor, a memory, an input/output interface, a communication interface, a display unit, and an input means. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input/output interface. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program, when executed by a processor, implements a report data processing method. The display unit of the computer device is used for forming a visual picture, and can be a display screen, a projection device or a virtual reality imaging device. The display screen 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 layer covered on the display screen, can also be a key, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the structures shown in fig. 6 or 7 are merely block diagrams of portions of structures related to the aspects of the present application and are not intended to limit the computer devices to which the aspects of the present application may be applied, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or may have a different arrangement of components.
In some embodiments, a computer device is provided that includes a memory having a computer program stored therein and a processor that when executing the computer program performs the steps of the report data processing method described above.
In some embodiments, a computer readable storage medium is provided, on which a computer program is stored, which when executed by a processor, implements the steps of the report data processing method described above.
In some embodiments, a computer program product is provided, comprising a computer program which, when executed by a processor, implements the steps of the report data processing method described above.
It should be noted that, the user information (including, but not limited to, user equipment information, user personal information, etc.) and the data (including, but not limited to, data for analysis, stored data, presented data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party, and the collection, use and processing of the related data are required to comply with the related laws and regulations and standards of the related countries and regions.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic units, quantum computing-based data processing logic units, etc., without being limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples only represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.
Claims (10)
1. A method for processing report data, the method comprising:
responding to the received report comparison request, and acquiring an item mapping relation between a report form and a reporting report form, wherein the item mapping relation is established based on the identification corresponding to each report item in the report form and the identification corresponding to each reporting item in the reporting report form;
Comparing the report form with the report form according to the project mapping relation to generate a comparison difference result;
and returning the comparison difference result.
2. The method of claim 1, wherein the manner in which the project mapping relationship between the statement and the declaration statement is established comprises:
acquiring a planning report and a reporting report generated based on the same report template;
determining identifiers corresponding to each reporting item in the reporting report from the report template, and determining identifiers corresponding to each reporting item in the reporting report from the report template;
and establishing an item mapping relation between the counting report and the reporting report based on the identifiers corresponding to the counting items and the identifiers corresponding to the reporting items.
3. The method of claim 2, wherein the establishing an item mapping relationship between the statement and the declared report based on the identifier corresponding to each of the statement items and the identifier corresponding to each of the declared items comprises:
determining a reporting item with the same identification as the reporting item from the reporting report for each reporting item in the reporting report;
Determining the counting item and the reporting item with the same identification as a comparison item group;
and obtaining an item mapping relation between the statement and the reporting statement based on the mapping relation between the statement and the reporting item in each comparison item group.
4. The method of claim 3, wherein the comparing the statement to the claim statement according to the item mapping relationship to generate a comparison difference result comprises:
for each comparison item group, determining a count-up value corresponding to a count-up item in the comparison item group from the count-up report, and determining a reporting value corresponding to a reporting item in the comparison item group from the reporting report;
determining a preset comparison formula corresponding to the comparison item group;
substituting the count value and the declaration value into the preset comparison formula to obtain a difference value corresponding to the comparison item group;
and obtaining a comparison difference result between the report form and the reporting report form based on the difference value corresponding to the comparison item group.
5. The method of claim 4, wherein the obtaining a comparison difference result between the statement and the claim statement based on the difference value corresponding to the comparison item group comprises:
Determining a first comparison result according to the difference value corresponding to each comparison item group;
determining target time-keeping items which do not belong to any comparison item group from the time-keeping report, and determining a second comparison result based on time-keeping values corresponding to the target time-keeping items;
determining target reporting items which do not belong to any one of the comparison item groups from the reporting report, and determining a third comparison result based on reporting values corresponding to the target reporting items;
and obtaining a comparison difference result between the statement and the declaration statement based on the first comparison result, the second comparison result and the third comparison result.
6. The method of claim 2, wherein the reporting template is a table comprising a plurality of cells; and determining the identification corresponding to each report item in the log report from the report template, wherein the identification comprises the following steps:
determining the position information of a corresponding cell of each counting item in the report template aiming at each counting item;
and determining the identification corresponding to the time-to-day item according to the position information.
7. The method of claim 1, wherein the comparing the statement to the claim statement according to the item mapping relationship to generate a comparison difference result comprises:
Acquiring a preset comparison scheme under the condition that the preset comparison scheme exists between the report form and the reporting form;
and comparing the report form with the reporting report form according to the project mapping relation and the preset comparison method, and generating a comparison difference result.
8. A report data processing apparatus, the apparatus comprising:
the system comprises a mapping relation acquisition module, a reporting module and a reporting module, wherein the mapping relation acquisition module is used for responding to a received report comparison request to acquire an item mapping relation between a reporting report and a reporting report, and the item mapping relation is established based on an identifier corresponding to each reporting item in the reporting report and an identifier corresponding to each reporting item in the reporting report;
the report comparison module is used for comparing the report form and the reporting report form according to the project mapping relation to generate a comparison difference result;
and the result returning module is used for returning the comparison difference result.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 7 when the computer program is executed.
10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311787817.3A CN117592757A (en) | 2023-12-22 | 2023-12-22 | Report data processing method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311787817.3A CN117592757A (en) | 2023-12-22 | 2023-12-22 | Report data processing method, device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117592757A true CN117592757A (en) | 2024-02-23 |
Family
ID=89915224
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311787817.3A Pending CN117592757A (en) | 2023-12-22 | 2023-12-22 | Report data processing method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117592757A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN119047441A (en) * | 2024-10-30 | 2024-11-29 | 浙江五疆科技发展有限公司 | Report data acquisition method and system |
-
2023
- 2023-12-22 CN CN202311787817.3A patent/CN117592757A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN119047441A (en) * | 2024-10-30 | 2024-11-29 | 浙江五疆科技发展有限公司 | Report data acquisition method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN115544183B (en) | Data visualization method, device, computer equipment and storage medium | |
| CN117592757A (en) | Report data processing method, device, computer equipment and storage medium | |
| CN116303657B (en) | Group portrait generation method, apparatus, computer equipment and storage medium | |
| US20190266526A1 (en) | Multi-dimensional organization of data for efficient analysis | |
| CN109840250B (en) | Method, device, equipment and storage medium for managing access authority of intermediate field | |
| CN114519062B (en) | Basic data updating method, device, computer equipment and storage medium | |
| CN115495452B (en) | Data processing methods, apparatus, computer equipment and storage media | |
| CN115408396B (en) | Method, device, computer equipment and storage medium for storing business data | |
| CN117519543A (en) | Document data input method, device, computer equipment and storage medium | |
| CN117435651A (en) | Test data processing methods, devices, computer equipment and storage media | |
| CN117435589A (en) | Data transfer method, device, computer equipment, storage medium | |
| CN117493377A (en) | Financial index report configuration method, device, equipment and storage medium | |
| CN112465612B (en) | Document information processing method, device, computer equipment and storage medium | |
| CN117172720A (en) | Audit doubt tracking and troubleshooting methods, systems, computer equipment and storage media | |
| CN117390011A (en) | Report data processing methods, devices, computer equipment and storage media | |
| CN116069865A (en) | Inventory sharing method, apparatus, computer equipment and storage medium | |
| CN114462362A (en) | Report file generation method and device, computer equipment and storage medium | |
| CN114676675B (en) | Data processing method, device, computer equipment and storage medium | |
| CN114490537B (en) | Multi-server data processing method, device, computer equipment, and storage medium | |
| CN116541454B (en) | Event configuration method, device, computer equipment and storage medium | |
| CN118332002A (en) | Data query method, device, computer equipment and storage medium | |
| CN114416235B (en) | Document display method, device, computer equipment and storage medium | |
| CN114781341B (en) | Report processing method, device, computer equipment and storage medium | |
| CN119621727A (en) | Data mapping method, device, computer equipment and storage medium | |
| CN118353009A (en) | Power resource allocation method, device, equipment, medium and product |
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 |