CN113947064A

CN113947064A - Report data acquisition method and device, computer equipment and storage medium

Info

Publication number: CN113947064A
Application number: CN202111119149.8A
Authority: CN
Inventors: 董佳佳; 曹传奎; 王秋胤; 杜海; 鲁增强
Original assignee: Nanjing Suning Yuncai Information Technology Co Ltd
Current assignee: Nanjing Suning Yuncai Information Technology Co Ltd
Priority date: 2021-09-24
Filing date: 2021-09-24
Publication date: 2022-01-18

Abstract

The application relates to a report data acquisition method, a report data acquisition device, report data acquisition equipment and a storage medium. The method comprises the following steps: receiving first parameter information which is sent by a first client and used for pulling report data of a target report; checking whether the report data of the target report meets the pull condition or not according to the first parameter information; when the pull condition is met, acquiring report data of a target report from the database, and transmitting the report data to the first client, so that the first client presents the report data of the target report on the first operation interface according to a report template of the target report stored locally by the first client; receiving report data editing information sent by a first client, wherein the report data editing information is generated by the first client in response to the first user editing operation on the report data of the target report presented by the first client; and updating the report data of the target report in the database according to the report data editing information. The invention can acquire the report data through the Exce l client developed with low cost, and improve the acquisition efficiency of the report data.

Description

Report data acquisition method and device, computer equipment and storage medium

Technical Field

The present application relates to the field of data processing technologies, and in particular, to a report data collection method and apparatus, a computer device, and a storage medium.

Background

Many tax payment subjects (such as more than 1000) are involved in some group companies, each tax collection period needs a plurality of tax administration departments in the group to perform account and bill inspection and collect tax payment declaration draft data, after the data is inspected and processed, an online manual declaration form is compiled, a compilation result is used as an OA (Office Automation) process accessory to perform data transfer, the approval or refund process is performed after the data is downloaded manually, and finally, an applicant downloads the accessory in one link and manually logs in an electronic tax Office to perform declaration.

The data volume of the tax declaration data is huge, and the traditional tax declaration data acquisition mode is as follows:

1. and importing the excel file into the system after the excel file is collected under the line.

2. And the online data acquisition is completed by using a programming program provided by the declaration system.

3. And developing a client for financial staff to compile reports, and acquiring data through the client.

However, the above-mentioned method 1 lacks prior data verification, requires multi-step operation, and has a high operation cost; in the mode 2, the use cost of learning software is high, and the cost of data re-entry is high; mode 3 needs to implement a large number of functions and compiling functions of EXCEL (spreadsheet software) for the client, and the development cost is high.

Disclosure of Invention

Aiming at the defects or shortcomings, the invention provides a report data acquisition method, a report data acquisition device, computer equipment and a storage medium.

The invention provides a report data acquisition method according to a first aspect, which comprises the following steps in one embodiment:

receiving first parameter information sent by a first client; the first parameter information is used for pulling report data of the target report; the first client is any Excel client which logs in an account with report making authority, and provides a first operation interface for a first user to make a report;

checking whether the report data of the target report meets the pull condition or not according to the first parameter information;

when the pull condition is met, acquiring report data of a target report from a database, and transmitting the report data to a first client, so that the first client presents the report data of the target report on a first operation interface according to a report template of the target report stored locally by the first client;

receiving report data editing information sent by a first client, wherein the report data editing information is generated by the first client in response to the first user editing operation on the report data of the target report presented by the first client;

and updating the report data of the target report in the database according to the report data editing information.

In one embodiment, the step of checking whether the report data of the target report meets the pull condition according to the first parameter information includes:

whether the first client side has report making authority is judged according to the first parameter information;

when the first client has the report formulation right, inquiring corresponding report data from the database according to the report template code of the target report included in the first parameter information;

and inquiring the editing state of the report data, and judging that the report data of the target report meets the pull condition when the editing state of the report data is unlocked.

In one embodiment, before the step of receiving the first parameter information sent by the first client, the method further includes:

receiving a version updating request sent by a first client; the version updating request is automatically sent by the first client after the first client successfully logs in the account with the report making authority; a plurality of report templates are locally stored in the first client;

and responding to the version updating request, detecting whether each report template has version updating, and sending the latest version of any report template to the first client when the version of any report template has version updating, so that the version of each report template locally stored by the first client is the latest version.

In one embodiment, the method further comprises:

receiving a report template made by a user and sent by a second client; the second client is any Excel client which logs in an account with the management authority of the report template and provides a second operation interface for the second user to make the report template or modify the report template;

and storing the received report template into a database.

In one embodiment, the method further comprises:

receiving report template editing information sent by a second client, wherein the report template editing information is generated by the second client in response to the editing operation of a second user on any report template presented by the second client through a second operation interface;

and updating any report template stored in the database according to the report template editing information.

In one embodiment, the method further comprises:

receiving second parameter information sent by a third client; the second parameter information is used for pulling the compiling data of the compiled target report; the third client is any Excel client which logs in an account with report form auditing authority and provides a third operation interface for a third user to audit the compiled report form;

and acquiring the compilation data of the compiled target report from the database according to the second parameter information, and sending the compilation data to the third client so that the third client presents the compilation data of the compiled target report through a third operation interface for a third user to check.

In one embodiment, after the step of obtaining the compiling data of the compiled target report from the database according to the second parameter information and sending the compiling data to the third client, the method further includes:

when compilation data editing information sent by a third client is received, the compilation data of the compiled target report stored in the database is updated according to the compilation data editing information, and the compilation data editing information is generated by the third client in response to the compilation operation of the compilation data of the compiled target report presented by the third client; or the like, or, alternatively,

and when a report request sent by a third client is received, locking the compilation data of the compiled target report and reporting the compilation data, wherein the report request is generated by the third client in response to a compilation data audit passing instruction which is triggered by a third user and represents the compiled target report.

The present invention provides a report data collecting device according to a second aspect, in one embodiment, the device comprises:

the first parameter receiving module is used for receiving first parameter information sent by a first client; the first parameter information is used for pulling report data of the target report; the first client is any Excel client which logs in an account with report making authority, and provides a first operation interface for a first user to make a report;

the checking module is used for checking whether the report data of the target report meets the pull condition or not according to the first parameter information;

the first data feedback module is used for acquiring report data of the target report from the database when the pull condition is met, and transmitting the report data to the first client so that the first client presents the report data of the target report on the first operation interface according to a report template of the target report stored locally by the first client;

the first editing information receiving module is used for receiving the report data editing information sent by the first client, wherein the report data editing information is generated by the first client in response to the first user editing the report data of the target report presented by the first client;

and the report data updating module is used for updating the report data of the target report in the database according to the report data editing information.

The present invention provides according to a third aspect a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of an embodiment of any of the methods described above when executing the computer program.

The present invention provides according to a fourth aspect a computer-readable storage medium having stored thereon a computer program which, when being executed by a processor, carries out the steps of the embodiments of the method of any one of the above.

The embodiment of the invention can realize the seamless butt joint of the server and the EXCEL client by customizing and developing the small program for acquiring the report data on the basis of the original client of the existing EXCEL and completely reserving all the existing functions in the original client of the EXCEL, all the compiling personnel can carry out the original report compiling operation completely based on the EXCEL client, and the small program in each EXCEL client can automatically upload the report data compiled by the user to the server for storage.

Drawings

FIG. 1 is a diagram of an exemplary embodiment of a report data collection application;

FIG. 2 is a schematic flow chart illustrating a report data collection method according to an embodiment;

FIG. 3 is a schematic flow chart illustrating a report data collection method according to another embodiment;

FIG. 4 is an application scenario interaction diagram in one embodiment;

FIG. 5 is a schematic diagram of user operation in one embodiment;

FIG. 6 is a second interface diagram in one embodiment;

FIG. 7 is a schematic illustration of a first operator interface in one embodiment;

FIG. 8 is a schematic view of a first interface for operation in another embodiment;

FIG. 9 is a schematic illustration of a third interface for operations in one embodiment;

FIG. 10 is a technical interaction diagram in one embodiment;

FIG. 11 is a flow diagram that illustrates the flow of traffic through the interfaces in one embodiment;

FIG. 12 is a block diagram of an embodiment of a report data collection apparatus;

FIG. 13 is a diagram illustrating an internal structure of a computer device according to an embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

The invention provides a report data acquisition method. In one embodiment, the report data collection method can be applied to the application environment shown in fig. 1. The Excel client 10 and the server 20 perform data interaction through a network. The Excel Client 10 and the Server 20 are developed based on a CS (Client-Server) software architecture, the Excel Client 10 is responsible for data operation and compilation, and the Server 20 is responsible for data storage and synchronization.

The report data collection method provided by this embodiment includes the steps shown in fig. 2, and the following description will take the example that the method is applied to the server side in fig. 1 as an example.

S110: and receiving first parameter information sent by a first client.

For the compiling personnel, EXCEL is the only way for compiling the past offline tax declaration data, in order to reserve the traditional use habit of the user to EXCEL, the EXCEL client of the embodiment realizes the secondary development of the original client completely based on EXCEL, and the EXCEL client is developed based on a vsto (visual Studio Tools for Office) toolkit, for example, by using a C # language, and interacts with EXCEL through an Office interoperation interface.

According to the method, the applet used for acquiring the report data is customized and developed on the basis of the existing EXCEL original client, and all existing functions in the EXCEL original client are completely reserved, so that seamless connection with the EXCEL client can be achieved, a user can complete the original report compiling operation based on the EXCEL client, and the applet in the EXCEL client can automatically acquire and upload the report data compiled by the user to the server. The Excel client 10 can operate in a programming terminal, such as various personal computers, notebook computers, desktop computers, and the like, and the server 20 can be implemented by an independent server or a server cluster formed by a plurality of servers.

In this embodiment, the first user refers to a user who has an account with report making authority, the first client refers to any Excel client which has logged in the account with report making authority, and the first client provides a first operation interface for the first user to make a report; the user can compile report data through the first client side, and can pull the report data compiled by other users to modify the report data or continue compiling on the basis of the report data. When the report data compiled by other users needs to be pulled, the first client sends first parameter information to the server, wherein the first parameter information is the input parameter of the report data which is transmitted to the server and used for pulling the target report. The parameters contained in the first parameter information may be different in different scenarios. In one example scenario, the first parameter information may include information such as a seller, a report template code, a user job number, and the like.

S120: and checking whether the report data of the target report meets the pull condition or not according to the first parameter information.

When the server side checks whether the report data of the target report meets the pull condition according to the first parameter information, whether the first client side has the report making authority is judged according to the first parameter information, when the first client side has the report making authority, the report data of the target report is judged not to meet the pull condition, and a relevant prompt (such as a prompt that a user does not have the authority of pulling the report data of the target report at present) is returned to the first client side; when the first client side has the report making right, inquiring corresponding report data from the database according to the report template code of the target report included in the first parameter information, then inquiring the editing state of the report data, judging that the report data of the target report meets the pull condition when the editing state of the report data is unlocked (indicating that the data is not operated by any user currently), and when the editing state of the report data is locked (indicating that the data is operated by other users currently, the other users are any users except the user), judging that the report data of the target report does not meet the pull condition, and returning a relevant prompt (for example, prompting that the report data of the current target report of the user is operated by other users) to the first client side.

S130: and when the pull condition is met, acquiring report data of the target report from the database and transmitting the report data to the first client, so that the first client presents the report data of the target report on the first operation interface according to a report template of the target report stored locally by the first client.

The first client locally stores a plurality of report templates, and the report templates are downloaded from the server.

S140: and receiving report data editing information sent by the first client.

The report data editing information is generated by the first client in response to the first user editing the report data of the target report presented by the first client.

S150: and updating the report data of the target report in the database according to the report data editing information.

The method has the advantages that the small programs for acquiring the report data are customized and developed on the basis of the existing EXCEL original client, all the functions existing in the EXCEL original client are completely reserved, the seamless butt joint of the server and the EXCEL client can be realized, all the compiling personnel can completely carry out the past report compiling operation based on the EXCEL client, the small programs in the EXCEL clients can automatically upload the report data compiled by the user to the server for storage, the embodiment can realize that the EXCEL clients developed with low cost acquire the report data compiled by the compiling personnel, and the acquisition efficiency of the report data is improved.

In one embodiment, as shown in fig. 3, before the step of receiving the first parameter information sent by the first client, the method further includes:

s210: receiving a version updating request sent by a first client; the version updating request is automatically sent by the first client after the first client successfully logs in the account with the report making authority; a plurality of report templates are locally stored in the first client;

s220: and responding to the version updating request, detecting whether each report template has version updating, and sending the latest version of any report template to the first client when the version of any report template has version updating, so that the version of each report template locally stored by the first client is the latest version.

In the past, the tax return template needs to be changed, all branch companies need to be informed of the synchronous updating of the financial lines, and the mode of changing the tax return template has high error and leakage rate under the conditions of numerous branch companies and numerous financial staff.

Therefore, this embodiment provides a way for changing a report template, when a user successfully logs in an account with a report making authority on an Excel client, the Excel client (i.e., a first client) automatically sends a version update request to a server, where the request includes version numbers of report templates locally stored by the first client, after the server receives the version update request sent by the first client, the server verifies the version numbers of the report templates included in the request and the version numbers of the report templates locally (locally at the server), for any report template, if the server finds that there is a version update, the server sends the latest version of the report template locally (locally at the server) to the first client, and after the first client receives the latest version of any report template returned by the server, the first client strongly covers the latest version of the report template over the current version of the report template locally (locally at the first client) Therefore, the version of each report template locally stored by the first client is guaranteed to be the latest version.

In the embodiment, the version numbers of the currently stored report templates are forcibly and synchronously checked after the Excel client successfully logs in the account with the report making authority each time, and if the version of the report template is updated, the changed report template can be obtained in a quasi-real-time manner, so that the problem that the report template is not timely changed in the past is solved.

In one embodiment, the method further comprises:

and storing the received report template into a database.

Further, the method further comprises:

In this embodiment, in addition to customizing and developing the applet for acquiring the report data based on the existing EXCEL original client, the applet for synchronizing the development template may be further customized and developed for synchronizing the report template made/modified by the user. The second user is a user who has an account with a report template management authority, can be a template manager, and can complete making and modifying of the report template through the template management applet, and the template management applet can synchronize the report template to the server after the report template is made or modified.

In one embodiment, the method further comprises:

In this embodiment, a data auditing applet for auditing the report forms can be further customized and developed on the basis of the existing EXCEL original client. After the builder finishes making up, the third user is the user who has the account with the report form auditing authority, wherein the third user can be an auditing worker, and report form data (namely making up data of a made up report form) of the report form which has been made up by the builder is pulled from the server through the Excel client, so that the report form data can be audited.

Correspondingly, after the step of obtaining the compiling data of the compiled target report form from the database according to the second parameter information and sending the compiling data to the third client, the method further comprises the following steps:

When the auditor audits the compiled data of the compiled report, if the place is found to be needed to be modified, the auditor can modify the compiled data through a third operation interface provided by a third client, and if the place is found not to be needed to be modified, the auditor can instruct to submit the compiled data of the compiled report to be reported.

It should be noted that, the first operation interface, the second operation interface, and the third operation interface mentioned in the above embodiments all refer to operation interfaces provided by the Excel client for a user to operate, where the operation interfaces include a working area and a table area, the working area is used for presenting various operation instructions, the table area is used for presenting report data of each report, some of the operation instructions of the Excel client are general operation instructions (that is, the user can use the operation instructions after logging in an account with any authority), and the rest of the operation instructions are non-general operation instructions (that is, the user can use the operation instructions after logging in an account with a specified authority, for example, if using the operation instructions a needs to have a report authority, the user can use the operation instructions a after logging in an account with a report authority).

For better understanding of the present invention, a specific embodiment related to a tax payment data declaration scenario is provided below, in which a tax payment declaration platform is provided, and includes an Excel client (client) and a server (server), and an interaction diagram of the tax payment data declaration scenario can be seen in fig. 4.

This example will be described in detail below.

As shown in fig. 5, in the embodiment, VSTO technology is used for developing in C # language, and the applet shown in fig. 5 is developed on an original client of Excel through interaction between an Office interoperation interface and Excel, and a user manages a report template, compiles a report, and audits the report through the applet.

The template management personnel can use an Excel tool to manufacture a report template meeting the business requirements according to the business requirements, the template management small program can analyze the Excel and synchronize template data to the server side, the server side updates the report template and the version of the client side, and the purpose of updating the template can be achieved by updating the client side.

In the embodiment, a set of reasonable and standard tax data interaction standards, including authentication and specific defect data verification, is defined through the abstract service interface, and a set of business languages suitable for being used in the tax field, such as different data, are displayed according to different personnel authorities. In the embodiment, a plurality of roles (such as template managers, editors and auditors) are divided, and after a user logs in an Excel client, the operation authority specified by the roles is returned through a server. The template manager can complete modification and synchronization of the tax declaration template through the template management applet, wherein an operation interface of the template manager during template modification through the Excel client can be shown in fig. 6; the builder can obtain the effective authority compilation form to compile and store data, wherein an operation interface of the builder compiling a certain report through the Excel client can be shown in fig. 7 and 8, in fig. 7, the builder can check each report through a catalog when compiling, and fig. 8 is an operation interface of the builder compiling a certain report; the auditor can check the compiled report, and perform data auditing and locking, where an operation interface when the auditor audits a report through the Excel client is shown in fig. 9. Further, this embodiment provides 2 reporting methods, in a first manner: collecting the data from the tax bureau system by an RPA (robot Process Automation) technology based on the client data to perform data declaration; the second method comprises the following steps: and the server side collects and stores data and performs tax declaration through the API interface.

As shown in fig. 10, the service end provides interface services to interact with the Excel client, for example, interfaces such as an authentication interface, an inquiry interface, a check interface, and a save interface, and the service flow of each interface is as follows (or as shown in fig. 11):

and (3) authentication interface: inquiring public configuration authority data through the input of an Excel client, wherein if information including a seller, a template code, a job number and the like exists, the public configuration authority data is loaded on the Excel client if the public configuration authority data exists, and a prompt is returned if the public configuration authority data does not exist;

and (3) inquiring an interface: after authentication, the user has authority, template information is inquired through public configuration, a database is inquired through the template information, and finally the inquired data is loaded to an Excel client;

detecting an interface: after the data query is completed, judging whether the data is locked, if so, indicating that the data is processed by other users and cannot be operated, returning an error prompt, and if not, returning a result set after locking so as to display the Excel client, so that the user can perform editing operation;

saving the interface: and editing such as modifying, deleting and the like by the user through the Excel client, storing the edited data, verifying the authority by the server background, verifying the parameters after template query, storing the data in a warehouse if the data is legal, and returning the stored result.

Furthermore, related business operators interact with the service end through a WEB service developed by Java, the WEB service is provided with an operation page, and authority configuration and business rule formulation can be performed through the operation page. In the data interaction process, a database (such as a Mysql database) and a distributed cache (such as Redis) lazy loading mode are adopted for frequently-dependent public parameter configuration data, so that the performance of an interface is improved. Flow control, switching and other control of the interface can be solved by a distributed coordination service (zookeeper) to ensure that the system is stable, and a system degradation scheme can be provided through configuration when an unstable factor occurs.

Further, in the embodiment, a user-defined development is performed on a working area in the Excel through a Ribbon designer, and basic functions of the Excel are expanded through a user-defined function button, including user-defined sample design, loading, fixed area demarcation Range and List area demarcation List. Existing functions in Excel are strengthened through the design of the function buttons, so that a user can directly perform operations such as data checking, verification and editing on familiar tools, and meanwhile, related applets can automatically store data to a server through related interfaces, and financial data can be conveniently checked and shared.

Specifically, the present embodiment plans and standardizes the presentation of data in different scenes through an abstract fixed table (Form table) and a floating table (List table). The fixed table (Form table) is suitable for displaying tax data in a fixed area, and a user can check, correct, re-edit and calculate the data in the area, trade the correctness of the tax data in real time through an Excel formula and the like. The detail data with larger data volume can be loaded in batch through the floating table (List table), and simultaneously, the information such as the summary result of the detail data can be displayed at the head part of the table, thereby greatly facilitating the work of tax staff and improving the efficiency of tax checking and checking.

The present embodiment can produce the following effects:

1. the familiar habit of EXCEL compilation of the user is reserved, the interaction between the EXCEL client and the server is strengthened, and the management and control on the compilation of the tax declaration statement of the user are enhanced;

2. realizing online management of the tax declaration template, and supporting forced upgrade from the original passive push; the consistency of the woven template is enhanced;

3. the scheduling is managed in a unified mode, and the service can quickly collect and display the current overall scheduling progress;

4. the constraint conditions of the compilation form are strengthened, and the default reform check rule is forcibly set through type check, read-only constraint, state management and the like, so that the data accuracy is greatly improved;

5. and realizing scattered compilation, centralized audit and tax declaration.

Fig. 2 and fig. 3 are schematic flow charts of report data collection methods in an embodiment. It should be understood that, although the steps in the flowcharts of fig. 2 and 3 are shown in sequence as indicated by the arrows, the steps are not necessarily performed in sequence as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2 and 3 may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the sub-steps or stages is not necessarily sequential, but may be performed alternately or alternately with other steps or at least some of the sub-steps or stages of other steps.

Based on the same inventive concept, the invention also provides a report data acquisition device. In this embodiment, as shown in fig. 12, the report data collecting device includes the following modules:

a first parameter receiving module 110, configured to receive first parameter information sent by a first client; the first parameter information is used for pulling report data of the target report; the first client is any Excel client which logs in an account with report making authority, and provides a first operation interface for a first user to make a report;

the checking module 120 is used for checking whether the report data of the target report meets the pull condition according to the first parameter information;

the first data feedback module 130 is configured to, when the pull condition is met, obtain report data of the target report from the database and transmit the report data to the first client, so that the first client presents the report data of the target report on the first operation interface according to a report template of the target report stored locally by the first client;

the first editing information receiving module 140 is configured to receive report data editing information sent by a first client, where the report data editing information is generated by the first client in response to an editing operation performed by a first user on report data of a target report presented by the first client;

and the report data updating module 150 is configured to update the report data of the target report in the database according to the report data editing information.

In one embodiment, a verification module, comprises:

the identification submodule is used for identifying whether the first client side has report making authority or not according to the first parameter information;

the query submodule is used for querying corresponding report data from the database according to the report template code of the target report included in the first parameter information when the first client has the report making right;

and the checking sub-module is used for inquiring the editing state of the report data and judging that the report data of the target report meets the pull condition when the editing state of the report data is unlocked.

In one embodiment, the report data collecting device further includes:

the updating request receiving module is used for receiving a version updating request sent by a first client; the version updating request is automatically sent by the first client after the first client successfully logs in the account with the report making authority; a plurality of report templates are locally stored in the first client;

and the update request response module is used for responding to the version update request, detecting whether each report template has version update or not, and sending the latest version of any report template to the first client when the version of the report template is updated, so that the version of each report template locally stored by the first client is the latest version.

In one embodiment, the report data collecting device further includes:

the report template receiving module is used for receiving a report template which is sent by the second client and made by the user; the second client is any Excel client which logs in an account with the management authority of the report template and provides a second operation interface for the second user to make the report template or modify the report template;

and the report template storage module is used for storing the received report template into a database.

In one embodiment, the report data collecting device further includes:

the second editing information receiving module is used for receiving the report template editing information sent by the second client, wherein the report template editing information is generated by the second client in response to the second user editing any report template presented by the second client through the second operation interface;

and the report template updating module is used for updating any report template stored in the database according to the report template editing information.

In one embodiment, the report data collecting device further includes:

the second parameter receiving module is used for receiving second parameter information sent by a third client; the second parameter information is used for pulling the compiling data of the compiled target report; the third client is any Excel client which logs in an account with report form auditing authority and provides a third operation interface for a third user to audit the compiled report form;

and the second data feedback module is used for acquiring the compiling data of the compiled target report from the database according to the second parameter information and sending the compiling data to the third client so that the third client presents the compiling data of the compiled target report through a third operation interface for a third user to check.

In one embodiment, the report data collecting device further includes:

the compilation data updating module is used for updating compilation data of the compiled target report stored in the database according to compilation data editing information when the compilation data editing information sent by the third client is received, wherein the compilation data editing information is generated by the third client in response to the compilation operation of the compilation data of the compiled target report presented by the third client;

and the data reporting module is used for locking the compiled data of the compiled target report and reporting the compiled data when a reporting request sent by a third client is received, wherein the reporting request is generated by the third client in response to an instruction which is triggered by a third user and represents that the compiled data of the compiled target report passes the audit.

For the specific definition of the report data collecting device, reference may be made to the above definition of the report data collecting method, which is not described herein again. All modules in the report data acquisition device can be completely or partially realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, the internal structure of which may be as shown in FIG. 13.

The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing data such as report data and report templates of each report, and the specific stored data can also refer to the limitations in the above method embodiments. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to realize a report data acquisition method.

Those skilled in the art will appreciate that the architecture shown in fig. 13 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

The embodiment also provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and when the processor executes the computer program, the following steps are implemented:

receiving first parameter information sent by a first client; the first parameter information is used for pulling report data of the target report; the first client is any Excel client which logs in an account with report making authority, and provides a first operation interface for a first user to make a report; checking whether the report data of the target report meets the pull condition or not according to the first parameter information; when the pull condition is met, acquiring report data of a target report from a database, and transmitting the report data to a first client, so that the first client presents the report data of the target report on a first operation interface according to a report template of the target report stored locally by the first client; receiving report data editing information sent by a first client, wherein the report data editing information is generated by the first client in response to the first user editing operation on the report data of the target report presented by the first client; and updating the report data of the target report in the database according to the report data editing information.

In one embodiment, when the processor executes the computer program to check whether the report data of the target report meets the pull condition according to the first parameter information, the following steps are also implemented:

whether the first client side has report making authority is judged according to the first parameter information; when the first client has the report formulation right, inquiring corresponding report data from the database according to the report template code of the target report included in the first parameter information; and inquiring the editing state of the report data, and judging that the report data of the target report meets the pull condition when the editing state of the report data is unlocked.

In one embodiment, the processor executes the computer program, and before the step of receiving the first parameter information sent by the first client, the following steps are further implemented:

receiving a version updating request sent by a first client; the version updating request is automatically sent by the first client after the first client successfully logs in the account with the report making authority; a plurality of report templates are locally stored in the first client; and responding to the version updating request, detecting whether each report template has version updating, and sending the latest version of any report template to the first client when the version of any report template has version updating, so that the version of each report template locally stored by the first client is the latest version.

In one embodiment, the processor executes the computer program and further performs the steps of:

receiving a report template made by a user and sent by a second client; the second client is any Excel client which logs in an account with the management authority of the report template and provides a second operation interface for the second user to make the report template or modify the report template; and storing the received report template into a database.

receiving report template editing information sent by a second client, wherein the report template editing information is generated by the second client in response to the editing operation of a second user on any report template presented by the second client through a second operation interface; and updating any report template stored in the database according to the report template editing information.

receiving second parameter information sent by a third client; the second parameter information is used for pulling the compiling data of the compiled target report; the third client is any Excel client which logs in an account with report form auditing authority and provides a third operation interface for a third user to audit the compiled report form; and acquiring the compilation data of the compiled target report from the database according to the second parameter information, and sending the compilation data to the third client so that the third client presents the compilation data of the compiled target report through a third operation interface for a third user to check.

In one embodiment, when the processor executes the computer program, the following steps are further implemented after the step of obtaining the preparation data of the prepared target report from the database according to the second parameter information and sending the preparation data to the third client:

when compilation data editing information sent by a third client is received, the compilation data of the compiled target report stored in the database is updated according to the compilation data editing information, and the compilation data editing information is generated by the third client in response to the compilation operation of the compilation data of the compiled target report presented by the third client; or when a report request sent by a third client is received, the compilation data of the compiled target report is locked and reported, and the report request is generated by the third client in response to a compilation data audit passing instruction which is triggered by a third user and represents the compiled target report.

In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of:

In one embodiment, when the computer program is executed by the processor and checks whether the report data of the target report meets the pull condition according to the first parameter information, the following steps are further implemented:

In one embodiment, the computer program is executed by a processor, and before the step of receiving the first parameter information sent by the first client, the following steps are further implemented:

In one embodiment, the computer program is executed by a processor and further implements the steps of:

In one embodiment, when the computer program is executed by the processor, the following steps are further implemented after the step of obtaining the preparation data of the prepared target report from the database according to the second parameter information and sending the preparation data to the third client:

It will be understood by those skilled in the art that all or part of the processes of the embodiments of the methods described above can be implemented by a computer program, which can be stored in a non-volatile computer-readable storage medium, and can include the processes of the embodiments of the methods described above when the computer program is executed. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.

Claims

1. A report data acquisition method is characterized by comprising the following steps:

receiving first parameter information sent by a first client; the first parameter information is used for pulling report data of a target report; the first client side is any Excel client side which is logged in an account with report making authority, and provides a first operation interface for a first user to make a report;

checking whether report data of the target report meets a pull condition according to the first parameter information;

when the pull condition is met, acquiring report data of the target report from a database, and transmitting the report data to the first client, so that the first client presents the report data of the target report on a first operation interface according to a report template of the target report locally stored by the first client;

receiving report data editing information sent by the first client, wherein the report data editing information is generated by the first client in response to a first user editing operation on report data of the target report presented by the first client;

2. The method according to claim 1, wherein the step of checking whether the report data of the target report satisfies the pull condition according to the first parameter information comprises:

when the first client side has report formulation authority, inquiring corresponding report data from a database according to the report template code of the target report included in the first parameter information;

3. The method of claim 1, wherein the step of receiving the first parameter information sent by the first client is preceded by the step of:

receiving a version updating request sent by the first client; the version updating request is automatically sent by the first client after the first client successfully logs in the account with the report making authority; a plurality of report templates are locally stored in the first client;

responding to the version updating request, detecting whether each report template has version updating or not, and sending the latest version of any report template to the first client when the version of the report template has version updating, so that the version of each report template locally stored by the first client is the latest version.

4. The method of claim 1, wherein the method further comprises:

and storing the received report template into a database.

5. The method of claim 4, wherein the method further comprises:

receiving report template editing information sent by the second client, wherein the report template editing information is generated by the second client in response to the editing operation of a second user on any report template presented by the second client through a second operation interface;

and updating any report template stored in a database according to the report template editing information.

6. The method of claim 1, wherein the method further comprises:

and acquiring the compilation data of the compiled target report from a database according to the second parameter information, and sending the compilation data to the third client so that the third client presents the compilation data of the compiled target report through a third operation interface for a third user to check.

7. The method of claim 6, wherein after the step of obtaining the compilation data of the compiled target report from the database according to the second parameter information and sending the compilation data to the third client, the method further comprises:

when compilation data editing information sent by the third client is received, the compilation data of the compiled target report stored in the database is updated according to the compilation data editing information, and the compilation data editing information is generated by the third client in response to the compilation operation of the compilation data of the compiled target report presented by the third client; or the like, or, alternatively,

and when a report request sent by the third client is received, locking the compilation data of the compiled target report and reporting the compilation data, wherein the report request is generated by the third client in response to a command which is triggered by a third user and represents that the compilation data of the compiled target report passes the audit.

8. A report data acquisition device, characterized in that the device comprises:

the first parameter receiving module is used for receiving first parameter information sent by a first client; the first parameter information is used for pulling report data of a target report; the first client side is any Excel client side which is logged in an account with report making authority, and provides a first operation interface for a first user to make a report;

the checking module is used for checking whether the report data of the target report meets the pull condition according to the first parameter information;

the data feedback module is used for acquiring the report data of the target report from a database when the pull condition is met, and transmitting the report data to the first client so that the first client presents the report data of the target report on a first operation interface according to a report template of the target report locally stored by the first client;

9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1 to 7 are implemented when the computer program is executed by the processor.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.