CN114528251A - Report generation method and device - Google Patents

Abstract

The invention provides a report generation method and device, belonging to big data. The method includes: establishing a report index table in a database; obtaining file attribute information of a target uploading system according to the report index table; according to the report index table and the target uploading system The attribute information of the file is called, the report generation program is called, and the report data entity is generated; the report data entity is converted into a report file and sent to the target uploading system. The invention uses the report index table established in the database to record the generation conditions of different reports, and generates the report entity content by calling the report generation process, so that the same uploading system can reuse the same set of codes, and generate corresponding reports according to the requirements of different uploading systems. document.

Description

A method and device for generating a report

technical field

The invention relates to the technical field of computer data processing, in particular to a method and device for generating a report.

Background technique

This section is intended to provide a background or context for the embodiments of the invention that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section.

With the continuous development of the trend of electronic office, more and more enterprises or units begin to use reports to make statistics on their own operation and management status. There are various types of reports. Some enterprises use daily reports, that is, the time range of one day is used as the statistical cycle; some companies use weekly reports, that is, the time range of one week is used as the statistical cycle. In the prior art, once the statistical period of the report is determined, the format of the report is determined accordingly. Taking the daily report as an example, the daily report only has statistical results for data within a 24-hour time range. If it is necessary to count the data within a month from the daily report, then in the prior art, only all (about 30) daily reports in this month can be obtained, and then the statistics can be obtained according to the data in all the daily reports. Statistics for the month. Since a large number of daily reports need to be processed, in the prior art, when the period required for statistics is not the same as the statistical period of the reports, the process of obtaining statistical data is very complicated, and a large number of hardware resources of statistical equipment are occupied.

Therefore, how to provide a new solution that can solve the above-mentioned technical problems is a technical problem to be solved urgently in the art.

SUMMARY OF THE INVENTION

The embodiment of the present invention provides a report generation method. The report index table established in the database is used to record the generation conditions of different reports, and the report entity content is generated by invoking the report generation process, so that the same upload system can reuse the same set of codes. The corresponding report files are generated according to the requirements of different uploading systems, and the method includes:

Create a report index table in the database;

Obtain the file attribute information of the target upload system according to the report index table;

According to the report index table and the file attribute information of the target uploading system, call the report generation program to generate the report data entity;

Convert report data entities into report files and send them to the target uploading system.

The embodiment of the present invention also provides a report generation device, including:

The report index table building module is used to build the report index table in the database;

The file attribute information acquisition module of the target uploading system is used to obtain the file attribute information of the target uploading system according to the report index table;

The report data entity generation module is used to call the report generation program according to the report index table and the file attribute information of the target uploading system to generate the report data entity;

The report file sending module is used to convert report data entities into report files and send them to the target uploading system.

An embodiment of the present invention further provides a computer device, including a memory, a processor, and a computer program stored in the memory and running on the processor, where the processor implements the above-mentioned method for generating a report when executing the computer program.

An embodiment of the present invention further provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, implements the foregoing method for generating a report.

An embodiment of the present invention further provides a computer program product, where the computer program product includes a computer program, and when the computer program is executed by a processor, the above-mentioned method for generating a report is implemented.

A report generation method and device provided by the embodiments of the present invention include: establishing a report index table in a database; obtaining file attribute information of a target uploading system according to the report index table; according to the report index table and the file attribute information of the target uploading system , call the report generation program to generate the report data entity; convert the report data entity into a report file and send it to the target uploading system. The invention uses the report index table established in the database to record the generation conditions of different reports, and generates the report entity content by calling the report generation process, so that the same uploading system can reuse the same set of codes, and generate corresponding reports according to the requirements of different uploading systems. document. When adding report files, you only need to configure the report index table in the database, and realize the splicing of report entity content according to different requirements, which is convenient for report file management, and effectively reduces code redundancy and labor and material costs.

Description of drawings

In order to explain the embodiments of the present invention or the technical solutions in the prior art more clearly, the following briefly introduces the accompanying drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments of the present invention. For those of ordinary skill in the art, other drawings can also be obtained according to these drawings without creative efforts. In the attached image:

FIG. 1 is a schematic diagram of a method for generating a report according to an embodiment of the present invention.

FIG. 2 is a schematic diagram of a process of establishing a report index table in a report generation method according to an embodiment of the present invention.

FIG. 3 is a schematic diagram of a process of generating a report data entity in a report generation method according to an embodiment of the present invention.

FIG. 4 is a schematic diagram of a report file sending process of a report generation method according to an embodiment of the present invention.

FIG. 5 is a schematic diagram of a computer device running a report generation method implemented by the present invention.

FIG. 6 is a schematic diagram of an apparatus for generating a report according to an embodiment of the present invention.

Detailed ways

In order to make the purposes, technical solutions and advantages of the embodiments of the present invention more clearly understood, the embodiments of the present invention will be further described in detail below with reference to the accompanying drawings. Here, the exemplary embodiments of the present invention and their descriptions are used to explain the present invention, but not to limit the present invention.

The present invention belongs to big data technology. FIG. 1 is a schematic diagram of a report generation method according to an embodiment of the present invention. As shown in FIG. 1 , an embodiment of the present invention provides a report generation method. The report index table established in the database is used to record the generation conditions of different reports. The generation process generates report entity content, realizes that the same upload system can reuse the same set of codes, and generates corresponding report files according to the requirements of different upload systems. The method includes:

Step 101: establish a report index table in the database;

Step 102: Obtain the file attribute information of the target uploading system according to the report index table;

Step 103: according to the report index table and the file attribute information of the target uploading system, call the report generation program to generate the report data entity;

Step 104: Convert the report data entity into a report file and send it to the target uploading system.

A report generation method provided by an embodiment of the present invention includes: establishing a report index table in a database; obtaining file attribute information of a target uploading system according to the report index table; calling the report index table and the file attribute information of the target uploading system according to the report index table The report generation program generates report data entities; converts report data entities into report files and sends them to the target uploading system. The invention uses the report index table established in the database to record the generation conditions of different reports, and generates the report entity content by calling the report generation process, so that the same uploading system can reuse the same set of codes, and generate corresponding reports according to the requirements of different uploading systems. document. When adding report files, you only need to configure the report index table in the database, and realize the splicing of report entity content according to different requirements, which is convenient for report file management, and effectively reduces code redundancy and labor and material costs.

Since the business data of the product needs to be given to other systems or the systems in charge of the provinces in the form of reports, different report files are generated through different classification methods to meet different needs. According to different requirements, reports need to be transmitted to different systems at different frequencies. How to efficiently realize report generation is the problem solved by the embodiments of the present invention.

When specifically implementing the report generation method provided by the embodiment of the present invention, in one embodiment, the method further includes:

Create a report index table in the database;

Obtain the file attribute information of the target upload system according to the report index table;

According to the report index table and the file attribute information of the target uploading system, call the report generation program to generate the report data entity;

Convert report data entities into report files and send them to the target uploading system.

In the embodiment, a report index table is established, and then the records in the report index table in the database are obtained according to the system name of the uploaded report to classify and implement the report generation of the system in different ways, and the method is reflected and invoked through the information recorded in the database to obtain The final statistical report data entity content is converted into report files and uploaded to the target uploading system.

FIG. 2 is a schematic diagram of a process of building a report index table of a report generation method according to an embodiment of the present invention. As shown in FIG. 2 , when a report generation method provided by an embodiment of the present invention is specifically implemented, in one embodiment, in a database Create a report index table, including:

Step 201: Obtain all uploading systems connected to the database, and obtain the report generation conditions corresponding to each uploading system;

Step 202: According to the generating conditions of the report corresponding to each uploading system, configure field records corresponding to each uploading system in the database, and establish a report index table.

In the embodiment, since different uploading systems have different requirements for reports, it is necessary to establish a corresponding generation condition table for different uploading systems, that is, a report index table; the specific process includes:

First, obtain all upload systems connected to the database, and obtain the report generation conditions corresponding to each upload system; then, according to the report generation conditions corresponding to each upload system, configure the field records corresponding to each upload system in the database, and create a report direction chart. By establishing a report index table, it is possible to record the requirements of all uploading systems for reports in all aspects, so that reports can be made and generated according to the requirements of each uploading system, and targeted adaptation.

When implementing the report generation method provided by the embodiment of the present invention, in one embodiment, the report index table includes a plurality of fields, and the fields at least include: uploading system name, report output frequency, report implementation method name;

Obtain the file attribute information of the target upload system according to the report index table, including:

According to the name of the target uploading system, the report output frequency of the target uploading system and the method name implemented by the report of the target uploading system are filtered out in the report index table as the file attribute information of the target uploading system.

In the embodiment, the report index table established above includes a plurality of fields, the fields at least include: upload system name, report output frequency, and report implementation method name; and may also include: report name, report start time, report end other fields such as time. Obtaining the file attribute information of the target uploading system according to the report index table, the main process may include: according to the name of the target uploading system, filtering out the report output frequency of the target uploading system and the report realization method of the target uploading system in the report index table The name is the file attribute information of the target upload system. Specifically, to obtain the file attributes is to filter records in the report index table through the report upload frequency and the down-loading system.

FIG. 3 is a schematic diagram of a process of generating a report data entity in a report generating method according to an embodiment of the present invention. As shown in FIG. 3 , when a report generating method provided by an embodiment of the present invention is specifically implemented, in one embodiment, according to the report index The table and target upload the file attribute information of the system, call the report generation program, and generate the report data entity, including:

Step 301: Create a timed task, generate basic report data of different time lengths according to the current system date, and store it in the information record table;

Step 302: According to the name of the target uploading system, obtain the fields corresponding to the target uploading system in the report index table, and put them into the report object; the fields put into the report object include: report start time, report end time, report name, Report output frequency, report upload system name and report implementation method name;

Step 303: Obtain all method names for generating reports through the report interface, and match with the method names implemented by the report of the target uploading system;

Step 304: When the method names match the same, call the report generation program corresponding to the matching method name by means of reflection, obtain the basic report data of the adapted report object from the information record table, and upload the generation of the corresponding report to the system according to the target. Conditional splicing, generating report data entities according to the report output frequency of the target upload system.

In the embodiment, the process of generating the report data entity mainly includes:

First, create a timed task, generate basic report data of different time lengths according to the current system date, and store them in the information record table; the basic report data can take days as the time length, or weeks as the time length, or Months may be the time length, more may be quarters as the time length, and further may be years as the time length, and so on, all within the protection scope of the embodiments of the present invention. Scheduled task refers to the program that generates reports by calling regularly through reflection; the report generation program is used to generate the corresponding report with the required fields in the report in the format specified by the uploading system;

Then, according to the name of the target upload system, get the fields corresponding to the target upload system in the report index table, and put them into the report object; if it is a monthly report, get the start and end time of the month before the current month, and if it is a daily report, get the start time of the previous day time and end time; the fields to be put into the report object include: report start time, report end time, report name, report output frequency, report upload system name and report implementation method name;

Then, obtain all the method names for generating reports through the report interface, and match them with the method names implemented by the report of the target uploading system; the matching process is to determine whether all the method names for generating reports are consistent with the method names implemented by the report of the target uploading system. ;When the method names match the same, call the report generation program corresponding to the matching method name by reflection, obtain the basic report data of the adapted report object from the information record table, and splicing according to the generation conditions of the corresponding report of the target upload system , and generate report data entities according to the report output frequency of the target upload system report.

Specifically, to obtain the file attributes is to filter records in the report index table through the report upload frequency and the down-loading system. If it is a monthly report, get the start and end time of the month before the current month, and if it is a daily report, get the start time and end time of the previous day. Generate the local storage path of the report, obtain the content in the report index table in the database, and put the report start and end time, report name, report output frequency, report upload system, report generation calling method name and other information in the report object. Generate a report file. The method of report generation is to obtain all the method names for generating the report through the report interface, and then judge whether it is consistent with the method name in the report index table. If it is consistent, the method is called by reflection. The entity that obtains the data that meets the report conditions in the record table and splices it together in the format specified by the report uploading system to obtain the final statistical data.

In the embodiment of the present invention, a report index table is established, and the fields include uploading system, report name of uploading system, report output frequency, report classification, and method name of report realization. Write a scheduled task, first determine the current date to generate a daily report or a monthly report, and then obtain the records in the report index table in the database according to the name of the system that uploaded the report to classify and use different methods to realize the report generation of the system, through the records in the database The information reflection calls the method to obtain the final statistical report data entity content.

In the embodiment of the present invention, the corresponding information of each report is configured in the database in the form of a record. First, all records that meet the conditions in the database are obtained through the report generation frequency and upload report system, and the corresponding files to be uploaded to the system are obtained. property to record it in the list. Then use reflection to call the method of generating the corresponding report, obtain the entity of the final statistical data, and create the generated file locally.

FIG. 4 is a schematic diagram of a report file sending process of a report generation method according to an embodiment of the present invention. As shown in FIG. 4 , when a report generation method provided by an embodiment of the present invention is specifically implemented, in one embodiment, the method further includes: The local storage path of the report file and the file name of the report file in the report object;

Convert report data entities into report files and send them to the target upload system, including:

Step 401: obtain the local storage path of the report file and the file name of the report file through the report object;

Step 402: According to the local storage path of the report file, define the upload path of the report file, create a file stream, and write the report data entity into the report file;

Step 403: Send the report file to the target uploading system according to the file name of the report file.

In the embodiment, after the report data entity is obtained, the report data entity needs to be converted into a report file and sent to the target uploading system. The main process includes:

First, obtain the local storage path of the report file and the file name of the report file through the report object; in the aforementioned report object, the local storage path of the report file and the file name of the report file have been placed in advance; then, according to the local storage path of the report file Path, define the upload path of the report file, create a file stream, and write the report data entity into the report file; finally, send the report file to the target upload system according to the file name of the report file.

Specifically, to create a generated file locally, first obtain the generated file file name and local output path through the report object, and judge the correctness of the address format. If the folder does not exist, create a new folder. Then define the local full path for file upload, create a file stream, write the report entity to the file, and send the report file to the target upload system according to the file name of the report file.

When specifically implementing the report generation method provided by the embodiment of the present invention, in one embodiment, sending the report file to the target uploading system according to the file name of the report file includes:

According to the file disk of the report file, analyze the report upload mode; the report upload mode includes: the whole jurisdiction upload mode and the provincial upload mode;

When the report upload mode is the full jurisdiction upload mode, upload the report file to the FTP directory of the target upload system within the jurisdiction according to the preset report receiving time of the target system;

When the report upload mode is the provincial upload mode, switch to the FTP directory of the target upload system corresponding to each province according to the province identification number corresponding to the file name of the report file, and upload the report file to the target corresponding to each province by province. Upload the system's FTP directory.

In the embodiment, since the target system is distributed in the whole jurisdiction, if the whole jurisdiction upload is required, the whole jurisdiction upload mode needs to be used. If the provincial upload mode is required, the provincial upload mode needs to be used. The main upload process includes:

First, analyze the report upload mode according to the file disk of the report file; when the report upload mode is the full jurisdiction upload mode, upload the report file to the FTP directory of the target upload system within the jurisdiction according to the preset report receiving time of the target system; When the report upload mode is the provincial upload mode, switch to the FTP directory of the target upload system corresponding to each province according to the province identification number corresponding to the file name of the report file, and upload the report file to the target corresponding to each province by province. Upload the system's FTP directory.

Upload files in batches to the FTP of the corresponding uploading system. When uploading, you need to distinguish one copy for the entire jurisdiction or need to upload by province. If you need to upload by province, it involves switching the corresponding report transmission according to the provincial branch number in the generated report file name. Directory. Upload report files to the FTP of the report system in batches. There are two report modes: one for the whole jurisdiction and one for each province. You can judge which mode is by analyzing the file name of the report. Then upload it to a different file directory. After the uploading system is successful, the temporary report file will be renamed.

Due to the large number of types of report files that need to be generated, it takes a lot of time to generate report files according to different requirements, resulting in high code redundancy and inconvenient management. The invention uses the database index table to record the generation conditions of different reports, generates daily, monthly and annual reports through timed tasks, and utilizes reflection calls to generate the method of report entity content, and the same uploading system can reuse the same set of codes. Therefore, when adding report files, you only need to configure database records, and realize the splicing of report entity content according to different requirements. This method facilitates the management of report files and effectively reduces code redundancy and human and material costs.

A method for generating a report provided by an embodiment of the present invention is briefly described below with reference to specific scenarios:

In the embodiment of the present invention, a report index table is established, and the fields include uploading system, report name of uploading system, report output frequency, report classification, and method name of report realization. Write a scheduled task, first determine the current date to generate a daily report or a monthly report, and then obtain the records in the report index table in the database according to the name of the system that uploaded the report to classify and use different methods to realize the report generation of the system, through the records in the database The information reflection calls the method to obtain the final statistical report data entity content.

However, when the number of reports increases and there are many application scenarios, the corresponding information of each report is configured in the database in the form of a record. First, all records that meet the conditions in the database are obtained through the report generation frequency and upload report system. The properties of the corresponding files uploaded to the system record them in the list. Then use reflection to call the method of generating the corresponding report, obtain the entity of the final statistical data, and create the generated file locally. Then upload the files in batches to the FTP of the corresponding uploading system. When uploading, it is necessary to distinguish one copy for the whole jurisdiction or for uploading by province. If it needs to upload by province, it involves switching the corresponding report according to the provincial branch number in the file name of the generated report. directory to transfer.

When implementing the embodiments of the present invention, the technical personnel need to pay attention to: the field settings in the database should be perfect, and the configurable type of the generated report should be high; the corresponding report is generated by calling the corresponding method through reflection; the connection method of the report uploading system needs to be confirmed, The transmission form and transmission directory are realized through code configuration; reports with complete and correct contents are transmitted to the corresponding system in the specified format at the corresponding time, and reports of different frequencies can be generated on time.

The process of a report generation method further provided by an embodiment of the present invention includes:

First, create a timed task to obtain all the file attributes of the report upload system to be generated.

Obtaining file attributes is to filter records in the report index table through the report upload frequency and the next upload system. If it is a monthly report, get the start and end time of the month before the current month, and if it is a daily report, get the start time and end time of the previous day. Generate the local storage path of the report, obtain the content in the report index table in the database, and put the report start and end time, report name, report output frequency, report upload system, report generation calling method name and other information in the report object. Scheduled task refers to calling the program that generates reports regularly by means of reflection; report index table refers to configuring corresponding fields in the database and inserting various report records; report generating program refers to uploading the required fields in the report to The corresponding report is generated in the format specified by the system; connecting to the uploading system program means that the file is first generated locally and then the generated report file is uploaded to the FTP of the corresponding system in batches.

Generate a report file. The method of report generation is to obtain all the method names for generating the report through the report interface, and then judge whether it is consistent with the method name in the report index table. If it is consistent, the method is called by reflection. The entity that obtains the data that meets the report conditions in the record table and splices it together in the format specified by the report uploading system to obtain the final statistical data.

To create a generated file locally, first obtain the generated file file name and local output path through the report object, and judge the correctness of the address format. If the folder does not exist, create a new folder. Then define the local full path for file upload, create a file stream, and write the report entity to the file.

Then upload the report files to the FTP of the report system in batches. There are two report modes: one for the whole jurisdiction and one for each province. You can determine which mode is by analyzing the file name of the report. Then upload it to a different file directory. After the uploading system is successful, the temporary report file will be renamed.

The core of the embodiment of the present invention is to configure the corresponding report records in the database, to reflect and call the method names recorded in the report index table, to generate the report entity content, and to upload them to the specified system directory in batches. few. The key point is to configure the report record mode in the database, filter the report record mode, reflect the method to generate the report entity content, upload files in batches, etc.

Due to the large number of types of report files that need to be generated, it takes a lot of time to generate report files according to different requirements, resulting in high code redundancy and inconvenient management. The invention uses the database index table to record the generation conditions of different reports, generates daily, monthly and annual reports through timed tasks, and utilizes reflection calls to generate the method of report entity content, and the same uploading system can reuse the same set of codes. Therefore, when adding report files, you only need to configure database records, and realize the splicing of report entity content according to different requirements. This method facilitates the management of report files and effectively reduces code redundancy and human and material costs.

FIG. 5 is a schematic diagram of a computer device running a report generation method implemented by the present invention. As shown in FIG. 5 , an embodiment of the present invention further provides a computer device 500, including a memory 510, a processor 520, and a computer stored in the memory and can The computer program 530 running on the processor, when the processor executes the computer program, implements the above-mentioned method for generating a report.

An embodiment of the present invention further provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, implements the foregoing method for generating a report.

An embodiment of the present invention further provides a computer program product, where the computer program product includes a computer program, and when the computer program is executed by a processor, the above-mentioned method for generating a report is implemented.

The embodiment of the present invention also provides a report generating apparatus, as described in the following embodiments. Since the principle of the device for solving the problem is similar to a method for generating a report, the implementation of the device can refer to the implementation of a method for generating a report, and the repetition will not be repeated.

FIG. 6 is a schematic diagram of a report generating apparatus according to an embodiment of the present invention. As shown in FIG. 6 , an embodiment of the present invention also provides a report generating apparatus, which may include:

A report index table establishment module 601 is used to establish a report index table in the database;

The file attribute information acquisition module 602 of the target uploading system is configured to acquire the file attribute information of the target uploading system according to the report index table;

The report data entity generation module 603 is used to call the report generation program according to the report index table and the file attribute information of the target uploading system to generate the report data entity;

The report file sending module 604 is configured to convert the report data entity into a report file and send it to the target uploading system.

When implementing the report generation device provided by the embodiment of the present invention, in one embodiment, the report index table establishment module is specifically used for:

Obtain all uploading systems connected to the database, and obtain the report generation conditions corresponding to each uploading system;

According to the generation conditions of the report corresponding to each uploading system, configure the field records corresponding to each uploading system in the database, and establish the report index table.

When implementing the report generating apparatus provided by the embodiment of the present invention, in one embodiment, the report index table includes a plurality of fields, and the fields at least include: uploading system name, report output frequency, report implementation method name;

The file attribute information acquisition module of the target upload system, which is specifically used for:

According to the name of the target uploading system, the report output frequency of the target uploading system and the method name implemented by the report of the target uploading system are filtered out in the report index table as the file attribute information of the target uploading system.

When implementing the report generation device provided by the embodiment of the present invention, in one embodiment, the report data entity generation module is specifically used for:

Create timed tasks, generate basic report data of different time lengths according to the current system date, and store them in the information record table;

According to the name of the target uploading system, obtain the fields corresponding to the target uploading system in the report index table and put them into the report object; the fields put into the report object include: report start time, report end time, report name, report output Report frequency, report upload system name and report implementation method name;

Obtain all method names for generating reports through the report interface, and match the method names implemented by the report of the target uploading system;

When the method names match the same, the report generation program corresponding to the matching method name is invoked through reflection, and the basic report data of the adapted report object is obtained from the information record table, and is spliced according to the generation conditions of the corresponding report of the target upload system. Generate report data entities according to the report output frequency of the target upload system report.

When specifically implementing the report generation device provided by the embodiment of the present invention, in one embodiment, the report data entity generation module is further configured to: put the local storage path of the report file and the file name of the report file in the report object;

Report file sending module, specifically used for:

Obtain the local storage path of the report file and the file name of the report file through the report object;

According to the local storage path of the report file, define the upload path of the report file, create a file stream, and write the report data entity into the report file;

Send the report file to the target upload system based on the file name of the report file.

When implementing the device for generating a report provided by the embodiment of the present invention, in one embodiment, the report file sending module is further configured to:

According to the file disk of the report file, analyze the report upload mode; the report upload mode includes: the whole jurisdiction upload mode and the provincial upload mode;

When the report upload mode is the full jurisdiction upload mode, upload the report file to the FTP directory of the target upload system within the jurisdiction according to the preset report receiving time of the target system;

When the report upload mode is the provincial upload mode, switch to the FTP directory of the target upload system corresponding to each province according to the province identification number corresponding to the file name of the report file, and upload the report file to the target corresponding to each province by province. Upload the system's FTP directory.

To sum up, a method and device for generating a report provided by the embodiments of the present invention include: establishing a report index table in a database; obtaining file attribute information of a target uploading system according to the report index table; File attribute information, call the report generation program to generate report data entities; convert the report data entities into report files and send them to the target uploading system. The invention uses the report index table established in the database to record the generation conditions of different reports, and generates the report entity content by calling the report generation process, so that the same uploading system can reuse the same set of codes, and generate corresponding reports according to the requirements of different uploading systems. document. When adding report files, you only need to configure the report index table in the database, and realize the splicing of report entity content according to different needs, which is convenient for the management of report files, and effectively reduces code redundancy and labor and material costs.

As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) having computer-usable program code embodied therein.

The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block in the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to the processor of a general purpose computer, special purpose computer, embedded processor or other programmable data processing device to produce a machine such that the instructions executed by the processor of the computer or other programmable data processing device produce Means for implementing the functions specified in a flow or flow of a flowchart and/or a block or blocks of a block diagram.

These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory result in an article of manufacture comprising instruction means, the instructions The apparatus implements the functions specified in the flow or flow of the flowcharts and/or the block or blocks of the block diagrams.

These computer program instructions can also be loaded on a computer or other programmable data processing device to cause a series of operational steps to be performed on the computer or other programmable device to produce a computer-implemented process such that The instructions provide steps for implementing the functions specified in the flow or blocks of the flowcharts and/or the block or blocks of the block diagrams.

The specific embodiments described above further describe the purpose, technical solutions and beneficial effects of the present invention in detail. It should be understood that the above-mentioned specific embodiments are only specific embodiments of the present invention, and are not intended to limit the scope of the present invention. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included within the protection scope of the present invention.

Claims (15)

1. a report generation method, is characterized in that, comprises: Create a report index table in the database; Obtain the file attribute information of the target upload system according to the report index table; According to the report index table and the file attribute information of the target uploading system, call the report generation program to generate the report data entity; Convert report data entities into report files and send them to the target uploading system. 2. method as claimed in claim 1 is characterized in that, in database, set up report index table, comprising: Obtain all uploading systems connected to the database, and obtain the report generation conditions corresponding to each uploading system; According to the generation conditions of the report corresponding to each uploading system, configure the field records corresponding to each uploading system in the database, and establish the report index table. 3. The method according to claim 2, wherein the report index table comprises a plurality of fields, and the field includes at least: uploading system name, report output frequency of report, and method name of report realization; Obtain the file attribute information of the target upload system according to the report index table, including: According to the name of the target uploading system, the report output frequency of the target uploading system and the method name implemented by the report of the target uploading system are filtered out in the report index table as the file attribute information of the target uploading system. 4. The method of claim 3, wherein, according to the report index table and the file attribute information of the target uploading system, the report generation program is invoked to generate the report data entity, comprising: Create timed tasks, generate basic report data of different time lengths according to the current system date, and store them in the information record table; According to the name of the target uploading system, the fields corresponding to the target uploading system in the report index table are obtained and put into the report object; the fields put into the report object include: report start time, report end time, report name, report output Report frequency, report upload system name and report implementation method name; Obtain all method names for generating reports through the report interface, and match the method names implemented by the report of the target uploading system; When the method name matches the same, the report generation program corresponding to the matching method name is called by reflection, and the basic report data of the adapted report object is obtained from the information record table, and the corresponding report generation conditions are spliced according to the target upload system. Generate report data entities according to the report output frequency of the target upload system report. 5. method as claimed in claim 4, is characterized in that, also comprises: in report object, put into the filename of the local storage path of report file and report file; Convert report data entities into report files and send them to the target upload system, including: Obtain the local storage path of the report file and the file name of the report file through the report object; According to the local storage path of the report file, define the upload path of the report file, create a file stream, and write the report data entity into the report file; Send the report file to the target upload system based on the file name of the report file. 6. The method of claim 5, wherein, according to the file name of the report file, the report file is sent to the target uploading system, comprising: According to the file disk of the report file, analyze the report upload mode; the report upload mode includes: the whole jurisdiction upload mode and the provincial upload mode; When the report upload mode is the full jurisdiction upload mode, upload the report file to the FTP directory of the target upload system within the jurisdiction according to the preset report receiving time of the target system; When the report upload mode is the provincial upload mode, switch to the FTP directory of the target upload system corresponding to each province according to the province identification number corresponding to the file name of the report file, and upload the report file to the target corresponding to each province by province. Upload the system's FTP directory. 7. A report generation device, characterized in that, comprising: The report index table building module is used to build the report index table in the database; The file attribute information acquisition module of the target uploading system is used to obtain the file attribute information of the target uploading system according to the report index table; The report data entity generation module is used to call the report generation program according to the report index table and the file attribute information of the target uploading system to generate the report data entity; The report file sending module is used to convert report data entities into report files and send them to the target uploading system. 8. device as claimed in claim 7 is characterized in that, report index table establishment module is specially used for: Obtain all uploading systems connected to the database, and obtain the report generation conditions corresponding to each uploading system; According to the generation conditions of the report corresponding to each uploading system, configure the field records corresponding to each uploading system in the database, and establish the report index table. 9. The device according to claim 8, wherein the report index table comprises a plurality of fields, and the fields at least include: uploading system name, report output frequency, and report implementation method name; The file attribute information acquisition module of the target upload system, which is specifically used for: According to the name of the target uploading system, the report output frequency of the target uploading system and the method name implemented by the report of the target uploading system are filtered out in the report index table as the file attribute information of the target uploading system. 10. The device according to claim 9, wherein the report data entity generation module is specifically used for: Create timed tasks, generate basic report data of different time lengths according to the current system date, and store them in the information record table; According to the name of the target uploading system, the fields corresponding to the target uploading system in the report index table are obtained and put into the report object; the fields put into the report object include: report start time, report end time, report name, report output Report frequency, report upload system name and report implementation method name; Obtain all method names for generating reports through the report interface, and match the method names implemented by the report of the target uploading system; When the method name matches the same, the report generation program corresponding to the matching method name is called by reflection, and the basic report data of the adapted report object is obtained from the information record table, and the corresponding report generation conditions are spliced according to the target upload system. Generate report data entities according to the report output frequency of the target upload system report. 11. device as claimed in claim 10, is characterized in that, report data entity generation module is also used for: in report object, the local storage path of report file and the filename of report file are put into; Report file sending module, specifically used for: Obtain the local storage path of the report file and the file name of the report file through the report object; According to the local storage path of the report file, define the upload path of the report file, create a file stream, and write the report data entity into the report file; Send the report file to the target upload system based on the file name of the report file. 12. The device of claim 11, wherein the report file sending module is also used for: According to the file disk of the report file, analyze the report upload mode; the report upload mode includes: the whole jurisdiction upload mode and the provincial upload mode; When the report upload mode is the full jurisdiction upload mode, upload the report file to the FTP directory of the target upload system within the jurisdiction according to the preset report receiving time of the target system; When the report upload mode is the provincial upload mode, switch to the FTP directory of the target upload system corresponding to each province according to the province identification number corresponding to the file name of the report file, and upload the report file to the target corresponding to each province by province. Upload the system's FTP directory. 13. A computer device comprising a memory, a processor and a computer program stored on the memory and running on the processor, wherein the processor implements any one of claims 1 to 6 when the processor executes the computer program method described in item. 14 . A computer-readable storage medium, characterized in that, the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method of any one of claims 1 to 6 is implemented. 15. A computer program product, characterized in that the computer program product comprises a computer program, and when the computer program is executed by a processor, implements the method of any one of claims 1 to 6.

Images