CN111144083B - Report generation method, device, equipment and computer readable storage medium - Google Patents
Report generation method, device, equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN111144083B CN111144083B CN201911330075.5A CN201911330075A CN111144083B CN 111144083 B CN111144083 B CN 111144083B CN 201911330075 A CN201911330075 A CN 201911330075A CN 111144083 B CN111144083 B CN 111144083B
- Authority
- CN
- China
- Prior art keywords
- report
- data
- fixed data
- generating
- configuration information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 45
- 238000004590 computer program Methods 0.000 claims description 9
- 238000013500 data storage Methods 0.000 claims description 6
- 238000001514 detection method Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 14
- 230000001960 triggered effect Effects 0.000 description 7
- 238000012986 modification Methods 0.000 description 6
- 230000004048 modification Effects 0.000 description 6
- 238000004364 calculation method Methods 0.000 description 4
- 230000000007 visual effect Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 3
- 238000012544 monitoring process Methods 0.000 description 2
- 238000009825 accumulation Methods 0.000 description 1
- 230000006978 adaptation Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000945 filler Substances 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 239000011159 matrix material Substances 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000737 periodic effect Effects 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D30/00—Reducing energy consumption in communication networks
- Y02D30/70—Reducing energy consumption in communication networks in wireless communication networks
Landscapes
- Debugging And Monitoring (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a report generation method, which comprises the following steps: detecting a generation instruction for generating a first report, wherein the generation instruction carries an identifier of the first report; acquiring a report template file and configuration information corresponding to the identifier; acquiring data corresponding to the identification; and generating the first report according to the report template file, the data and the configuration information. By adopting the method and the system, the report can be quickly generated according to the requirements of the user, the platform does not need to be customized and developed, and the expansibility and the applicability of the platform are improved.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method, an apparatus, a device, and a computer readable storage medium for generating a report.
Background
With the continuous expansion of business of enterprises, when facing data generated by a plurality of businesses, a report forms a preferred mode of data statistics and data analysis. Currently, in order to generate a report faster, a general report generation platform provides components of a general report template, and a user can select the components by himself to combine into a required report style and manually input data to generate a report.
However, in practice, the existing report template components are limited, and cannot meet the requirements of users in various industries on report diversity. Therefore, how to improve the expansibility of the report platform is a problem to be solved.
Disclosure of Invention
The embodiment of the application provides a report generation method, a report generation device and a report generation computer readable storage medium, which can rapidly generate a report according to the requirements of users, do not need to be customized and developed on a platform, and improve the expansibility and the applicability of the platform.
In a first aspect, an embodiment of the present application provides a report generating method, where the report generating method includes:
detecting a generation instruction for generating a first report, wherein the generation instruction carries an identifier of the first report;
acquiring a report template file and configuration information corresponding to the identifier;
acquiring data corresponding to the identification;
and generating the first report according to the report template file, the data and the configuration information.
In a possible implementation manner, the configuration information is information of data required by cells in the report template file;
the generating the first report according to the report template file, the data and the configuration information includes:
Generating a first table according to the report template file;
and respectively adding the data to the corresponding cells in the first table according to the configuration information to obtain the first report.
In a possible implementation manner, the generating instruction further carries time information;
the obtaining the data corresponding to the identifier includes:
acquiring first fixed data corresponding to the identification and the time information;
obtaining variable data corresponding to the identification and the time information;
calculating result data according to the fixed data and the variable data;
and determining the fixed data, the variable data and the result data as data corresponding to the identification.
In one possible implementation, the method further includes:
acquiring an effective time period of the first fixed data to obtain a first effective time period;
receiving second fixed data and an effective time period of the second fixed data corresponding to the identification input by a user, and obtaining the second fixed data and the second effective time period;
storing the second fixed data and the second valid period in the case that there is no coincidence time between the first valid period and the second valid period;
The obtaining the fixed data corresponding to the identifier and the time information includes:
acquiring all fixed data corresponding to the identification;
and acquiring first fixed data of which the corresponding effective time period comprises the time information in the fixed data.
In one possible implementation, the method further includes:
and outputting prompt information for prompting data storage failure under the condition that the coincidence time exists between the first effective time period and the second effective time period.
In one possible implementation manner, the generating instruction is generated when the report template file corresponding to the identifier is an online file;
and under the condition that the report template file corresponding to the identifier is a offline file, the generation instruction is input by a user.
In a possible implementation manner, the adding the data to the corresponding cells in the first table according to the configuration information to obtain the first report includes:
respectively adding the data to corresponding cells in the first table according to the configuration information;
and calculating the values of cells except the cells included in the configuration information in the first table according to the formula included in the first table and the added data.
In a second aspect, an embodiment of the present application provides a report generating apparatus, where the report generating apparatus includes:
the detection unit is used for detecting a generation instruction for generating a first report, wherein the generation instruction carries an identifier of the first report;
the first acquisition unit is used for acquiring the report template file and the configuration information corresponding to the identifier;
the second acquisition unit is used for acquiring the data corresponding to the identification;
and the generating unit is used for generating the first report according to the report template file, the data and the configuration information.
In a possible implementation manner, the configuration information is information of data required by cells in the report template file;
the generating unit is specifically configured to:
generating a first table according to the report template file;
and respectively adding the data to the corresponding cells in the first table according to the configuration information to obtain the first report.
In a possible implementation manner, the generating instruction further carries time information;
the second obtaining unit is specifically configured to:
acquiring first fixed data corresponding to the identification and the time information;
Obtaining variable data corresponding to the identification and the time information;
calculating result data according to the fixed data and the variable data;
and determining the fixed data, the variable data and the result data as data corresponding to the identification.
In one possible implementation, the apparatus further includes:
the third acquisition unit is used for acquiring the effective time period of the first fixed data to obtain a first effective time period;
the receiving unit is used for receiving second fixed data and a valid time period of the second fixed data corresponding to the identification input by a user, and obtaining the second fixed data and the second valid time period;
a storage unit configured to store the second fixed data and the second valid period when there is no coincidence time between the first valid period and the second valid period;
the first obtaining unit is specifically configured to:
acquiring all fixed data corresponding to the identification;
and acquiring first fixed data of which the corresponding effective time period comprises the time information in the fixed data.
In one possible implementation, the apparatus further includes:
The output unit is used for outputting prompt information for prompting data storage failure under the condition that the coincidence time exists between the first effective time period and the second effective time period.
In one possible implementation manner, the generating instruction is generated when the report template file corresponding to the identifier is an online file;
and under the condition that the report template file corresponding to the identifier is a offline file, the generation instruction is input by a user.
In a possible implementation manner, the generating unit is specifically configured to:
respectively adding the data to corresponding cells in the first table according to the configuration information;
and calculating the values of cells except the cells included in the configuration information in the first table according to the formula included in the first table and the added data.
In a third aspect, an embodiment of the present application provides an electronic device, including an output device, an input device, a processor, a transceiver, and a memory, where the output device, the input device, the processor, the transceiver, and the memory are connected to each other. The memory is for storing a computer program supporting the terminal device to perform the method provided in the first aspect and/or any of the possible implementation manners of the first aspect, and the transceiver is for receiving information from and sending information to other devices than the device. The computer program comprises program instructions, the processor being configured to invoke the program instructions described above, to perform the method provided by the first aspect and/or any of the possible implementation manners of the first aspect.
In a fourth aspect, embodiments of the present application provide a computer readable storage medium storing a computer program comprising program instructions which, when executed by a processor, cause the processor to perform the method provided by the first aspect and/or any of the possible implementations of the first aspect.
In a fifth aspect, embodiments of the present application provide a computer program product which, when run on a computer, causes the computer to perform the method of generating a report disclosed in the first aspect or any possible implementation manner of the first aspect.
When the generation instruction for generating the first report is detected, the embodiment of the application acquires the report template file and the configuration information corresponding to the identification of the first report carried by the instruction, acquires the corresponding data according to the identification, and can quickly generate the first report according to the acquired data and the configuration information. Meanwhile, the report template file can be provided by a report generating platform or uploaded by a user, and when the template or the component of the platform cannot meet the requirement of the user on the report file, the user only needs to upload the report file and input configuration information, so that the scheme provided by the application does not need to customize and develop the platform, the expansibility and the applicability of the platform are improved, and more convenient report generating service is provided for the user.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present application, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a schematic diagram of a network architecture according to an embodiment of the present application;
FIG. 2 is a schematic flow chart of a report generation method according to an embodiment of the present application;
FIG. 3a is a schematic diagram of a report according to an embodiment of the present application;
FIG. 3b is a schematic diagram of a report configuration information containing cells according to an embodiment of the present application;
FIG. 3c is a schematic diagram of a report cell containing a generation formula according to an embodiment of the present application;
FIG. 3d is a schematic diagram of report generation according to an embodiment of the present application;
FIG. 4 is a flowchart of a report generating method according to another embodiment of the present application;
FIG. 5a is a schematic diagram of an interface for entering fixed data according to an embodiment of the present application;
FIG. 5b is a schematic diagram of an interface for importing a report template file according to an embodiment of the present application;
FIG. 5c is a schematic diagram of an interface for inputting configuration information of a report template file according to an embodiment of the present application;
FIG. 5d is an interface schematic diagram of a configuration information list according to an embodiment of the present application;
fig. 6 is a schematic structural diagram of a report generating device according to an embodiment of the present application;
fig. 7 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
The embodiment of the application provides a report generating method, which improves the expansibility and applicability of a report generating platform, wherein the report generating scheme can be applied to electronic equipment, and the electronic equipment can comprise but is not limited to: servers, desktop computers, laptop computers, smartphones, tablet computers, desktop computers, and the like. The user can call the corresponding application client to execute the report generating method according to the actual report generating requirement. For example, a report generation client may be invoked to generate a report, where the report generation client may include, but is not limited to: a client on a mobile terminal, a client on computer software, a web page client, etc. For another example, a report generator may be invoked by an office class client to generate a report, and so on.
In order to better understand the report generation method, device, equipment and computer readable storage medium provided by the embodiment of the present application, a network architecture used by the embodiment of the present application is described below. Fig. 1 is a schematic diagram of a network architecture according to the present application. As shown in fig. 1, the network architecture includes a report generating device 100 and one or more report receiving devices (as shown in fig. 1, specifically including an electronic device 200a, an electronic device 200b, and an electronic device 200 c), where the report generating device 100 may communicate with each report receiving device through a network, and each report receiving device may install a report generating client, where the client includes an application program, a web client, an applet client, and so on. The report generation device comprises a report receiving device, a report generation device and a report generation device, wherein the report generation device is used for generating a report, and the report generation device is used for generating the report. For example, the report generating instruction triggered by the user through the platform a may be a report generating instruction, where the device corresponding to the platform a (e.g. 200d in fig. 1) transmits the instruction to the report generating device (e.g. 100 in fig. 1) through the client or other manners, and the report generating device transmits the generated report to the device corresponding to the platform a.
Therefore, the report generation scheme provided by the application can upload report template files and configuration information through the user, is suitable for various scenes needing report generation, can also meet the requirements of more users, and has wide applicability.
Referring to fig. 2, fig. 2 is a flowchart of a report generation method according to an embodiment of the present application, where the method may include:
201, a generation instruction for generating a first report is detected.
Specifically, when the report generating device detects a first report generating instruction, the instruction mainly comes from two aspects, one aspect is an instruction triggered by a user through a report generating client, and the other aspect is a report generating instruction periodically generated and triggered by a report generating platform, wherein the instruction carries identification and time information of the first report, the identification and the time information are data, a report template file and configuration information required for acquiring the report from a database, and it is understood that the identification corresponding to the report can be uniquely pointed to one identification.
For example, when company a has contracted with a plurality of record companies and needs to generate a report for settling copyright fees each month, the report generation platform of the report may receive a report generation instruction corresponding to the record company name and corresponding month input by a user, or may generate and trigger a report generation instruction including the record company name and month at the beginning of month end or month next, where the identifier may be the record company name, or may be a number corresponding to and stored by the record company.
202. And acquiring the report template file and the configuration information corresponding to the identification.
Specifically, before generating the report instruction, the report generating platform needs to store the report template file and configuration information corresponding to the report identifier. The report template file can be stored by a report generating platform, can be a report template file imported by a user, and can be a template file manufactured by a form editor or an existing form component on the report generating platform. After the report template file is imported, configuration information is needed to be input, wherein the configuration information is information of data needed by cells in the report template file, namely, positions of the cells of a report correspond to the data, and after the data needed by the report is acquired, the data is added into the cells corresponding to the positions input in the configuration information.
If the report template file corresponding to the identifier and the configuration information cannot be found in the database after the report generation instruction is received, the prompt information of whether the report template file corresponding to the temporary absence is needed or not can be output to the user, various general report templates are provided for the user to select, the report template file input by the user can be received, the user is prompted to input the configuration information related to the report template file, and the report template file and the configuration information are stored for subsequent calling.
The report template file is an editable table file, such as an Excel table file, a numers table file, an uploaded document file with a table, and the like, which is not limited herein. After receiving the report template file imported by the user, the report template file can be stored in a database for subsequent retrieval.
Further, when uploading the template file, the state selection of the report template file can be provided and divided into an online state and a offline state. When the template file is just uploaded, the template file of the report can be set to be in a offline state, and the fact that the template file of the report in the offline state can only be called by a report generation instruction input by a configurator to generate a report can be provided for the configurator to debug. After the debugging is finished, the state of the report template file can be set to be an on-line state, and when the report template file is in the on-line state, the report template file can be called through report generation instructions which are periodically generated and triggered by a platform, and can also be called through generation instructions input by a user.
For example, after the company a makes contracts with a plurality of album companies, the report template file corresponding to each album company may be uploaded to the platform, and the configuration information is correspondingly uploaded, that is, the report template file and the configuration information of the unit cell in the report template file corresponding to each album company are stored, and the state of the report template file selected by the user is received when the report template file is uploaded.
203. And acquiring data corresponding to the identification.
Specifically, before generating the report, the data filled into the report needs to be acquired and processed, and the generating instruction of the report carries time information. The time information may be accurate to each day or to a specific time, which is not limited herein. After the identification and time information is obtained, fixed data and variable data can be obtained according to the identification and time information, and it is to be understood that the fixed data herein does not change from beginning to end, but does not change actively during the time period contained in the time information unless the user inputs a modification request. Here, the variable data refers to data collected in real time in the time information or data uploaded by a user in the time information, and it is understood that the variable data is unpredictable in the time information and can be obtained only from the stored data.
Further, according to the data required by the report, a calculation formula or a calculation method can be determined, and the result data calculated by the fixed data and the variable data is stored as the data required by the report so as to be directly acquired in the subsequent process of generating the report.
For example, after signing up with a plurality of record companies, the fixed data recorded by the user may be received respectively, where the fixed data may be the business data of signing up with the record company, and the data may be the data that does not change in any special situation in the time range of the period of the contract period, such as the unit price of the member user who is agreed with the contract period, and the like, and is a value in the whole contract period. If the obtained time information is the variable data of the last month, the time information can be the number of times of listening to songs and the income of the month, the data can be changed every month, and the data can only be obtained when the report of every month is generated. Therefore, the data corresponding to the identifier may be the variable data and the fixed data, and the result data calculated in the two aspects may be the data required by the report.
204. And generating the first report according to the report template file, the data and the configuration information.
Specifically, first, a table may be generated according to the report template file, so as to obtain a first table, where the table includes all contents, format information, configuration information corresponding to cells and a built-in generation formula in the report template file. After the first table is obtained, the obtained data, i.e. the fixed data, the variable data and the result data, may be assembled into a table, wherein the table includes the three data. And then, respectively adding the corresponding data into the cells in the corresponding first table according to the configuration information, and storing to obtain a first report, and providing the first report for a user to download or automatically downloading in batches after the first report is generated.
Further, the formulas generated in the cells in the form template file, such as formulas for generating the data of the current cell from the data of the existing cells, may generate the data of the cells in which the formulas are generated from the data already added to the first form.
Optionally, the platform includes a table editor, and may receive a modification instruction input by a user after obtaining the first report, modify the generated first report, and output the modified first report after the modification is completed.
In a possible implementation manner, when a user judges that the data in the first report has errors or the user finds that the recorded fixed data is wrong and the recorded fixed data is not timely after the first report is generated, the platform cannot completely acquire and calculate the result data when acquiring the data, so that the generation of the first report is wrong or incomplete, or the report template file is not the corresponding report template file, the user input modification data can be received, and the modified report template file can be uploaded again. When a generation instruction of the first report manually input by a user is received, the fixed data and the variable data are acquired again, calculated again and added to the first table, and therefore the first report is generated. It is to be noted that the fixed data corresponds to a valid time, so that the fixed data corresponding to two entries of the same identifier is ensured to be unique, that is, when a user modifies the fixed data, if the valid time is modified, the time period before modification and the time period after modification need to be compared, and when no coincident time period exists, the modified data is stored. Or the user adds the fixed data corresponding to the mark, and also needs to judge whether the effective time period corresponding to the newly added fixed data and the effective time period corresponding to the mark have the overlapping time, and the user can store the fixed data only when judging that the effective time period does not exist, if judging that the effective time period does not exist, the user is output with prompt information of data storage failure, and the re-input fixed data is not stored until the effective time period does not exist.
For example, after signing contracts with a plurality of record companies, a user inputs fixed data of each record company, wherein the fixed data refers to data which is not changed in the current date of the contract, a platform stores the data in a database by taking the start effective time of the record company and the fixed data as a main key, and the platform checks the start effective time and the failure time at the same time to ensure that the duration of the fixed data of the same record company is not overlapped.
When the generation instruction for generating the first report is detected, the embodiment of the application acquires the report template file and the configuration information corresponding to the identification of the first report carried by the instruction, acquires the corresponding data according to the identification, and can quickly generate the first report according to the acquired data and the configuration information. Meanwhile, the report template file can be provided by a report generating platform or uploaded by a user, and when the template or the component of the platform cannot meet the requirement of the user on the report file, the user only needs to upload the report file and input configuration information, so that the scheme provided by the application does not need to customize and develop the platform, the expansibility and the applicability of the platform are improved, and more convenient report generating service is provided for the user.
Fig. 3a to fig. 3d are schematic diagrams of report generation according to an embodiment of the present application. As shown in FIG. 3a, the report template file required to be generated by a record company signed by company A is not completely the same as the report template of each record company, and a general structure can be abstracted, or each record company can independently have a structure of a report template. Wherein, as shown in fig. 3a, the report is typeset in matrix, the list head is the parameter name corresponding to the data, the list head is the region and the currency identifier corresponding to the region (as shown in fig. 3 a), such as HDK represents harbor coin, MYR represents horse coin, THB represents taper, IDR represents indonesia ratio, ZAR represents south african coin, and USD represents dollar. For example, taking record company settlement as an example, the list header may be "subscription service revenue (a)", "distribution fee (b)", and "licensor revenue percentage (c)", etc. As shown in fig. 3b, the part of the report frame that comes out of the square frame is composed of the acquired data (fixed data, variable data, and result data calculated by both), after the platform receives the generation instruction for generating the first report, the data is acquired and calculated, and after the calculation is completed, the cells configured according to the configuration information are respectively filled in the report generated by the template. As shown in fig. 3c, the cells in the box include a generation formula, and after the data is filled into the cells corresponding to the configuration information, the cells capable of generating data from the cells of the existing data according to the generation formula, where the generation formula may be a functional formula based on the cells, and is pre-deployed in the table, for example, in the cells in fig. 3c, the generation formula may be "content usage D" for the cell D16 may be "=round (D14/D15, 6)", the generation formula may be "= (D11-D12) ×d13×d16" for the cell D17, and similarly, the generation formula may be "=e18×e19" for the cell E20, where the value of a, b, c, D may be the data filled in according to the configuration information, or the data generated according to the configuration information and the generation formula. The whole report can be obtained according to the filled data and the data generated by the generation formula, as shown in fig. 3d, it can be understood that the obtained report file can be modified by an online editor or the platform provides a download link, and the download table file is modified.
The report generation method provided by the embodiment of the application is taken as an example to be applied to the report generation of the corresponding record company, and the report generation method is described in detail below. The specific flow can be seen in fig. 4:
firstly, after a company and a record company sign a contract, fixed data in a report corresponding to the contract can be input, and the input fixed data is stored by a platform, wherein the platform can provide a visual interface, standard input data or input data forms set by a user (as shown in fig. 5 a), and necessary filled information and fillable information can be set. Taking record company as an example, in a record company, for a fixed data, the content that can be filled in is the amount of money in the record company contract, such as the content that is not marked by the form in fig. 5a, the content that must be filled in may be the content that is marked by the sign in fig. 5a, such as the contract validity period, the contract starting time, the contract ending time, etc., it is required to know that the contract from the starting time to the ending time can be used as the fixed data and the variable data in the acquired term when the data is acquired after receiving the report generating instruction, it is understood that the fixed data is the data that is not modified in special cases after being recorded once, and the current form may be input and filled in by the user, or may be selected by the user.
Secondly, importing the report template file, and storing the report template file by a platform, wherein the stored identification can be the name of a record company, the serial number of the record company and the like, the report template name input by a user, the name of the record company, the uploaded report template file and the state of the current template file can be provided in a visual interface (shown in fig. 5 b) of the report template file, wherein the difference between the online state and the offline state of the report template file is the source of a generating instruction, and when a user sets a task of periodically generating report data, the platform only generates the instruction by using the report template file to be online, so that a debugging space can be provided for the user. It can be understood that the fixed data is input and the report template file is input in no sequence, the fixed data is input before the report template file is input, the report template file is input before the report template file is input, the fixed data is input after the report template file is input, the fixed data and the report file are simultaneously input, and the fixed data and the report file are simultaneously operated, so that the method is not limited.
Then, after the report template file is stored, the configuration information still needs to be uploaded for each template, where the configuration information may be configured for each cell to be configured, and the visual interface may be as shown in fig. 5c, and the content to be filled may include: template name (template), cell (excel), parameter (params), type (type), and label group (label group), and other data related to record company settlement business, and also can be divided into filler items and fillable items. Further, since the record company report is generated according to month, the selectable item which can be added is "whether to accumulate to the next month" (amass to next month), when yes, the configuration data of the cell is accumulated to the report generated in the next month, otherwise, no accumulation is performed.
After each specific cell is configured, the platform outputs a configuration summary table, as shown in fig. 5d, where the data may be "cell" (cell name), "report template name" (template name), "tab group/tab group+" (label group+), "type" (type), "parameter name" (parameter name), "whether to accumulate to the next month" (amass to next month), and so on, optionally, the added data may be deleted, for example, "delete" in "operation" in fig. 5d, may be added again (for example, "create" button in fig. 5 d), and the configured information may be copied in one key (for example, "copy parameters" button in fig. 5 d) so as to be pasted to other places.
Further, under the condition of daily periodic tasks, such as periodically generating a settlement report of a record company every month, a report generation instruction generated by the platform can be triggered and also can be a report generation instruction input by a user, wherein the report generation instruction generated by the platform can only be generated and triggered under the condition that a report template file is in an up state, and the report generation instruction input by the user can be received and can be the report template file which is being debugged by the user, so that the report generation instruction is manually input, and also can be the report generation instruction which is manually input by the platform, and the user needs to manually modify fixed data under the condition that the fixed data is not timely input or the fixed data is input in error, and then manually input the report generation instruction, so that the platform regenerates a new report. The operation of the report generated by the platform may be to obtain fixed data recorded by the user and obtain variable data which changes in each month, such as income of the month, number of songs listened to in the month, and the like, and the variable data may be data stored in other servers or databases. After the fixed data and the variable data are acquired, the result data is calculated from the fixed data and the variable data. The fixed data, the variable data and the result data can be data configured in the configuration information, after receiving the report generating instruction, the report is filled into cells in a table generated by the template file according to the configuration information, and the contents of other cells can be generated according to a generating formula. It can be understood that the report generation can be one report generation or a plurality of reports batch generation to improve the efficiency.
After the report is generated, the report can be stored in the current server or in a special file server, and a download link is generated for the user to download.
In one possible implementation, after the report is generated, the generated report may be uploaded to the blockchain system through the blockchain node device, where the blockchain node device may be the current server or a dedicated file server. For example, uploading the generated report to a blockchain system, i.e. a distributed system, may generate a new block on the chain for storing the hash value corresponding to the file, where it is understood that the block header data of a block includes: the version number, the hash value of the father block, the Merker Tree (MT), the timestamp, the difficulty target and the like can be calculated according to the current generated file to store the hash value corresponding to the file, and when more blocks are generated later, the hash corresponding to the current file is stored in the form of the hash value corresponding to the Merker tree root, so that the safety and the tamper resistance of the file are ensured.
Further, the blockchain bottom platform may include processing modules for user management, basic services, intelligent contracts, operation monitoring, and the like. After a new report file is generated, the basic service can verify the interface adaptation and public and private keys, then the report file is encrypted (hash value is calculated) through a consensus algorithm, and the encrypted report file is transmitted to a shared account book and recorded for storage. The intelligent contract can be issued by registering the contract and triggered by the contract and executed by the contract, for example, the storage of the current document can be determined according to the definition of a developer and the logic of the contract, and optionally, the real-time state of the whole system or the process of uploading the file can be monitored by an operation monitoring module and output in a visual interface.
Therefore, the report generation scheme can decouple the data acquisition and calculation of the report from the report generation, a limited small amount of data can support the generation of a large number of reports, a generation formula of the cells is preset in the report, the unavailable cell data can be generated by the available cell data, the work of a user is reduced, the development of platform customization is not needed, and the expansibility is improved.
When the generation instruction for generating the first report is detected, the embodiment of the application acquires the report template file and the configuration information corresponding to the identification of the first report carried by the instruction, acquires the corresponding data according to the identification, and can quickly generate the first report according to the acquired data and the configuration information. Meanwhile, the report template file can be provided by a report generating platform or uploaded by a user, and when the template or the component of the platform cannot meet the requirement of the user on the report file, the user only needs to upload the report file and input configuration information, so that the scheme provided by the application does not need to customize and develop the platform, the expansibility and the applicability of the platform are improved, and more convenient report generating service is provided for the user.
Referring to fig. 6, fig. 6 is a report generating apparatus 6000 according to an embodiment of the present application, as shown in fig. 6, the report generating apparatus 6000 includes:
the detecting unit 601 is configured to detect a generating instruction for generating a first report, where the generating instruction carries an identifier of the first report;
a first obtaining unit 602, configured to obtain a report template file and configuration information corresponding to the identifier;
a second obtaining unit 603, configured to obtain data corresponding to the identifier;
and a generating unit 604, configured to generate the first report according to the report template file, the data, and the configuration information.
In one possible implementation manner, the configuration information is information of data required by the unit cells in the report template file;
the generating unit 604 is specifically configured to:
generating a first table according to the report template file;
and respectively adding the data to the corresponding cells in the first table according to the configuration information to obtain the first report.
In a possible implementation manner, the generating instruction further carries time information;
the second acquiring unit 603 is specifically configured to:
acquiring first fixed data corresponding to the identification and the time information;
Obtaining variable data corresponding to the identification and the time information;
calculating result data based on the fixed data and the variable data;
and determining the fixed data, the variable data and the result data as data corresponding to the identification.
In one possible implementation manner, the apparatus 6000 further includes:
a third obtaining unit 605, configured to obtain a first valid period of time of the first fixed data;
a receiving unit 606, configured to receive second fixed data corresponding to the identifier and an effective period of the second fixed data, where the second fixed data and the second effective period are input by a user;
a storage unit 607 configured to store the second fixed data and the second valid period when there is no overlapping time between the first valid period and the second valid period;
the first obtaining unit 602 is specifically configured to:
acquiring all fixed data corresponding to the identification;
and acquiring first fixed data of which the corresponding effective time period comprises the time information in the fixed data.
In one possible implementation manner, the apparatus 6000 further includes:
And an output unit 608 configured to output a prompt message for prompting a failure in data storage when there is a coincidence time between the first valid period and the second valid period.
In one possible implementation manner, the generating instruction is generated when the report template file corresponding to the identifier is an online file;
and under the condition that the report template file corresponding to the identifier is a offline file, the generation instruction is input by a user.
In one possible implementation manner, the generating unit 604 is specifically configured to:
respectively adding the data to the corresponding cells in the first table according to the configuration information;
and calculating the values of cells except the cells included in the configuration information in the first table according to the formula included in the first table and the added data.
The detailed descriptions of the detecting unit 601, the first acquiring unit 602, the second acquiring unit 603, the generating unit 604, the third acquiring unit 605, the receiving unit 606, the storage unit 607 and the output unit 608 may be directly obtained by directly referring to the related descriptions in the method embodiments shown in fig. 2 to 4, which are not repeated herein.
When the generation instruction for generating the first report is detected, the embodiment of the application acquires the report template file and the configuration information corresponding to the identification of the first report carried by the instruction, acquires the corresponding data according to the identification, and can quickly generate the first report according to the acquired data and the configuration information. Meanwhile, the report template file can be provided by a report generating platform or uploaded by a user, and when the template or the component of the platform cannot meet the requirement of the user on the report file, the user only needs to upload the report file and input configuration information, so that the scheme provided by the application does not need to customize and develop the platform, the expansibility and the applicability of the platform are improved, and more convenient report generating service is provided for the user.
Referring to fig. 7, fig. 7 is a schematic structural diagram of an electronic device according to an embodiment of the application. As shown in fig. 7, the electronic device 7000 may include:
one or more processors 701, input devices 702, output devices 703, memory 704, and a transceiver 705. The processor 701, the input device 702, the output device 703, the memory 704, and the transceiver 705 are connected by a bus. Where input device 702 may include a touch screen, keyboard, microphone, etc., and output device 703 may include a display screen, audio, etc., transceiver 705 is used to receive and transmit data. The memory 704 is used for storing a computer program comprising program instructions, the processor 701 is used for executing the program instructions stored by the memory 704, wherein the processor 701 is configured for invoking the program instructions to perform the steps of:
Detecting a generation instruction for generating a first report, wherein the generation instruction carries an identifier of the first report;
acquiring a report template file and configuration information corresponding to the identifier;
acquiring data corresponding to the identification;
and generating the first report according to the report template file, the data and the configuration information.
In one possible implementation manner, the configuration information is information of data required by the unit cells in the report template file;
the processor 701 generates the first report from the report template file, the data, and the configuration information, including:
generating a first table according to the report template file;
and respectively adding the data to the corresponding cells in the first table according to the configuration information to obtain the first report.
In a possible implementation manner, the generating instruction further carries time information;
the processor 701 obtains data corresponding to the identifier, including:
acquiring first fixed data corresponding to the identification and the time information;
obtaining variable data corresponding to the identification and the time information;
calculating result data based on the fixed data and the variable data;
And determining the fixed data, the variable data and the result data as data corresponding to the identification.
In one possible implementation, the processor 701 is configured to invoke program instructions to perform the following steps:
acquiring the effective time period of the first fixed data to obtain a first effective time period;
receiving second fixed data and a valid time period of the second fixed data corresponding to the identification input by a user, and obtaining the second fixed data and the second valid time period;
storing the second fixed data and the second valid period when there is no overlapping time between the first valid period and the second valid period;
the processor 701 obtains fixed data corresponding to the identifier and the time information, including:
acquiring all fixed data corresponding to the identification;
and acquiring first fixed data of which the corresponding effective time period comprises the time information in the fixed data.
In one possible implementation, the processor 701 is configured to invoke program instructions to perform the following steps:
and outputting prompt information for prompting data storage failure under the condition that the coincidence time exists between the first effective time period and the second effective time period.
In one possible implementation manner, the generating instruction is generated when the report template file corresponding to the identifier is an online file;
and under the condition that the report template file corresponding to the identifier is a offline file, the generation instruction is input by a user.
In a possible implementation manner, the processor 701 adds the data to corresponding cells in the first table according to the configuration information to obtain the first report, where the method includes:
respectively adding the data to the corresponding cells in the first table according to the configuration information;
and calculating the values of cells except the cells included in the configuration information in the first table according to the formula included in the first table and the added data.
It should be appreciated that in some possible embodiments, the above-described processor 701 may be a central processing unit (central processing unit, CPU), the processor 701 may also be other general purpose processors, digital signal processors (digital signal processor, DSP), application specific integrated circuits (application specific integrated circuit, ASIC), off-the-shelf programmable gate arrays (field-programmable gate array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
Steps 201 to 204 may be performed by the processor 701 and the memory 704 in the report generating apparatus.
The detection unit 601, the first acquisition unit 602, the second acquisition unit 603, the generation unit 604, the third acquisition unit 605, the reception unit 606, the storage unit 607, and the output unit 608 may be implemented by the processor 701 and the memory 704 in the server.
The above server may also be used to execute various methods executed in the foregoing method embodiments, which are not described herein.
Furthermore, it should be noted here that: the embodiment of the present application further provides a computer storage medium, in which a computer program executed by the report generating device mentioned above is stored, and the computer program includes program instructions, when the processor executes the program instructions, the processor can execute the description of any method in any of the embodiments corresponding to fig. 2 and fig. 4, and therefore, a detailed description will not be given here. In addition, the description of the beneficial effects of the same method is omitted. For technical details not disclosed in the embodiments of the computer storage medium according to the present application, please refer to the description of the method embodiments of the present application.
Those skilled in the art will appreciate that all or part of the processes in the methods of the above embodiments may be implemented by hardware associated with computer program instructions, and the above programs may be stored in a computer readable storage medium, and the programs may include processes in the embodiments of the methods when executed. The storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM), a random-access memory (random access memory, RAM), or the like.
The foregoing disclosure is illustrative of the present invention and is not to be construed as limiting the scope of the invention, which is defined by the appended claims.
Claims (8)
1. A report generation method is characterized by comprising the following steps:
detecting a generation instruction for generating a first report, wherein the generation instruction carries the identification and time information of the first report;
acquiring a report template file and configuration information corresponding to the identifier;
acquiring all fixed data corresponding to the identifier, acquiring first fixed data of which the effective time period comprises the time information in all fixed data corresponding to the identifier, and acquiring variable data corresponding to the identifier and the time information;
Calculating result data according to the first fixed data and the variable data;
determining the first fixed data, the variable data and the result data as data corresponding to the identification;
generating the first report according to the report template file, the data and the configuration information;
acquiring an effective time period of the first fixed data to obtain a first effective time period;
receiving second fixed data and an effective time period of the second fixed data corresponding to the identification input by a user, and obtaining the second fixed data and the second effective time period;
and storing the second fixed data and the second valid period when no coincidence time exists between the first valid period and the second valid period.
2. The method of claim 1, wherein the configuration information is information of data required by cells in the report template file;
the generating the first report according to the report template file, the data and the configuration information includes:
generating a first table according to the report template file;
and respectively adding the data to the corresponding cells in the first table according to the configuration information to obtain the first report.
3. The method according to claim 2, wherein the method further comprises:
and outputting prompt information for prompting data storage failure under the condition that the coincidence time exists between the first effective time period and the second effective time period.
4. A method according to claim 3, wherein the generation instruction is generated in the case that the report template file corresponding to the identifier is an online file;
and under the condition that the report template file corresponding to the identifier is a offline file, the generation instruction is input by a user.
5. The method according to any one of claims 2-4, wherein the adding the data to the corresponding cells in the first table according to the configuration information to obtain the first report includes:
respectively adding the data to corresponding cells in the first table according to the configuration information;
and calculating the values of cells except the cells included in the configuration information in the first table according to the formula included in the first table and the added data.
6. The report generating device is characterized by comprising the following components:
The detection unit is used for detecting a generation instruction for generating a first report, wherein the generation instruction carries the identification and time information of the first report;
the first acquisition unit is used for acquiring the report template file and the configuration information corresponding to the identifier;
the second acquisition unit is used for acquiring all fixed data corresponding to the identifier, acquiring first fixed data of which the effective time period corresponding to the fixed data comprises the time information, and acquiring variable data corresponding to the identifier and the time information; calculating result data according to the first fixed data and the variable data; determining the first fixed data, the variable data and the result data as data corresponding to the identification;
the generating unit is used for generating the first report according to the report template file, the data and the configuration information;
the third acquisition unit is used for acquiring the effective time period of the first fixed data to obtain a first effective time period;
the receiving unit is used for receiving second fixed data and a valid time period of the second fixed data corresponding to the identification input by a user, and obtaining the second fixed data and the second valid time period;
And the storage unit is used for storing the second fixed data and the second effective time period when no coincidence time exists between the first effective time period and the second effective time period.
7. An electronic device, comprising: a processor and a memory;
the processor is connected to a memory, wherein the memory is adapted to store program code, and the processor is adapted to invoke the program code to perform the method according to any of claims 1-5.
8. A computer storage medium, characterized in that the computer storage medium stores a computer program comprising program instructions which, when executed by a processor, perform the method of any of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911330075.5A CN111144083B (en) | 2019-12-20 | 2019-12-20 | Report generation method, device, equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911330075.5A CN111144083B (en) | 2019-12-20 | 2019-12-20 | Report generation method, device, equipment and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111144083A CN111144083A (en) | 2020-05-12 |
| CN111144083B true CN111144083B (en) | 2023-11-03 |
Family
ID=70519216
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911330075.5A Active CN111144083B (en) | 2019-12-20 | 2019-12-20 | Report generation method, device, equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111144083B (en) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111538731B (en) * | 2020-05-14 | 2023-08-29 | 山东慧泰智能科技有限公司 | Automatic report generation system for industrial data |
| CN112131843A (en) * | 2020-09-02 | 2020-12-25 | 苏宁云计算有限公司 | Business report generation method and device, computer equipment and storage medium |
| CN112446707A (en) * | 2020-11-13 | 2021-03-05 | 泰康保险集团股份有限公司 | Rule updating method and device, electronic equipment and storage medium |
| CN112906363A (en) * | 2021-02-05 | 2021-06-04 | 广东智能财税数据科技发展有限公司 | Report adding method, device, equipment and storage medium |
| CN112906362A (en) * | 2021-02-05 | 2021-06-04 | 广东智能财税数据科技发展有限公司 | Report summarizing method, device, equipment and storage medium |
| CN113743060B (en) * | 2021-08-30 | 2023-05-26 | 建信金融科技有限责任公司 | Customizable report generation method, device, computer equipment and storage medium |
| CN115841096A (en) * | 2021-09-18 | 2023-03-24 | 北京字跳网络技术有限公司 | Document processing method, device, equipment and medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5819293A (en) * | 1996-06-06 | 1998-10-06 | Microsoft Corporation | Automatic Spreadsheet forms |
| CN108132925A (en) * | 2017-12-15 | 2018-06-08 | 中盈优创资讯科技有限公司 | A kind of report file generation method and device |
| CN109582936A (en) * | 2017-09-28 | 2019-04-05 | 北京国双科技有限公司 | The method and apparatus for configuring report messages |
| CN109725933A (en) * | 2018-05-24 | 2019-05-07 | 中国平安人寿保险股份有限公司 | Big data document structure tree method, apparatus, equipment and computer readable storage medium |
| CN110096683A (en) * | 2019-03-15 | 2019-08-06 | 中国平安人寿保险股份有限公司 | Report form generation method, system, computer installation and computer readable storage medium |
| WO2019218454A1 (en) * | 2018-05-16 | 2019-11-21 | 平安科技（深圳）有限公司 | Subscription report generation method and apparatus, computer device and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10657324B2 (en) * | 2016-02-03 | 2020-05-19 | Global Software Innovation Pty Ltd | Systems and methods for generating electronic document templates and electronic documents |
-
2019
- 2019-12-20 CN CN201911330075.5A patent/CN111144083B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5819293A (en) * | 1996-06-06 | 1998-10-06 | Microsoft Corporation | Automatic Spreadsheet forms |
| CN109582936A (en) * | 2017-09-28 | 2019-04-05 | 北京国双科技有限公司 | The method and apparatus for configuring report messages |
| CN108132925A (en) * | 2017-12-15 | 2018-06-08 | 中盈优创资讯科技有限公司 | A kind of report file generation method and device |
| WO2019218454A1 (en) * | 2018-05-16 | 2019-11-21 | 平安科技（深圳）有限公司 | Subscription report generation method and apparatus, computer device and storage medium |
| CN109725933A (en) * | 2018-05-24 | 2019-05-07 | 中国平安人寿保险股份有限公司 | Big data document structure tree method, apparatus, equipment and computer readable storage medium |
| CN110096683A (en) * | 2019-03-15 | 2019-08-06 | 中国平安人寿保险股份有限公司 | Report form generation method, system, computer installation and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111144083A (en) | 2020-05-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111144083B (en) | Report generation method, device, equipment and computer readable storage medium | |
| US11281751B2 (en) | Digital asset traceability and assurance using a distributed ledger | |
| CN110263024B (en) | Data processing method, terminal device and computer storage medium | |
| CN108132926B (en) | Contract generation device and system | |
| CN107896244B (en) | Version file distribution method, client and server | |
| CN108305055B (en) | Payment testing method and device | |
| CN111078140B (en) | Nuclear power station file uploading management method and device, terminal equipment and medium | |
| CN111309745B (en) | Virtual resource processing method and device, electronic equipment and storage medium | |
| CN110941630A (en) | Database operation and maintenance method, device and system | |
| RU2723916C2 (en) | Apparatus and method of processing published information and an information publishing system | |
| CN109284331B (en) | Certificate making information acquisition method based on service data resources, terminal equipment and medium | |
| CN112738138A (en) | Cloud security hosting method, device, equipment and storage medium | |
| CN113011907A (en) | Data processing method, device, storage medium and equipment | |
| CN116049901B (en) | Detection task traceable management system based on timestamp encryption | |
| CN110347657A (en) | Data creation method, device, electronic equipment and storage medium | |
| CN114240335A (en) | Data processing method and device | |
| CN112150299B (en) | Annuity data processing method, annuity data processing device, medium and electronic equipment | |
| CN109388527B (en) | Method for confirming operation validity, data processing method, device and equipment | |
| CN112668998A (en) | Flow implementation method, device, system, electronic equipment and readable storage medium | |
| CN112100534A (en) | Information processing method, device, medium and electronic equipment in page sharing | |
| CN111694991A (en) | Data transmission method based on DDEX protocol | |
| CN114596092B (en) | Charging method, device and equipment based on blockchain and readable storage medium | |
| CN112165512B (en) | File release method and device, terminal equipment and storage medium | |
| CN114596092A (en) | Charging method, device and equipment based on block chain and readable storage medium | |
| CN114119255A (en) | Block chain based information disclosure method, apparatus, device and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |