CN108804401B - Report template merging method and device - Google Patents
Report template merging method and device Download PDFInfo
- Publication number
- CN108804401B CN108804401B CN201810612101.2A CN201810612101A CN108804401B CN 108804401 B CN108804401 B CN 108804401B CN 201810612101 A CN201810612101 A CN 201810612101A CN 108804401 B CN108804401 B CN 108804401B
- Authority
- CN
- China
- Prior art keywords
- report
- data area
- processed
- template
- total data
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/197—Version control
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention provides a method and a device for combining report templates, wherein the method comprises the following steps: acquiring at least two report templates to be processed, wherein the report templates to be processed comprise public attributes and data areas; deleting the public attribute of each report template to be processed, and respectively generating a data area of each report template to be processed; merging the data areas of the report templates to be processed to generate a total data area; and adding a public attribute corresponding to the total data area in the total data area to obtain a combined report template. The method solves the technical problem that the combining mode of the report forms in the prior art is not high in flexibility.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a device for combining report templates.
Background
With the development of informatization and datamation, the processing of the report forms is widely applied.
At present, a report can be generated by filling data in a report template, when a plurality of reports are combined, processing is usually performed according to attributes determined during design of the report template corresponding to each report, where the attributes include the number and content of the reports, and since the number and the content of the reports are fixed during design of each report template, processing can be performed only according to the attributes determined by each template during combination of the reports, and requirements for personalized customization cannot be met. Therefore, the report template in the prior art has low combination mode flexibility.
Disclosure of Invention
The embodiment of the invention provides a method and a device for combining report templates, which are used for solving or at least partially solving the technical problem that the combining mode of the report templates in the prior art is not high in flexibility.
In order to solve the above problem, a first aspect of the present invention provides a method for merging report templates, including:
acquiring at least two report templates to be processed, wherein the report templates to be processed comprise public attributes and data areas;
deleting the public attribute of each report template to be processed, and respectively generating a data area of each report template to be processed;
merging the data areas of the report templates to be processed to generate a total data area;
and adding a public attribute corresponding to the total data area in the total data area to obtain a combined report template, wherein the public attribute corresponding to the total data area is obtained by integrating the public attribute of each report template.
Optionally, the public attributes include report versions and report numbers, and the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template, including:
acquiring each report version of each report template to be processed, and acquiring a target report version based on each report version;
acquiring the quantity of each report template to be processed, and taking the sum of the quantities of the reports as the target quantity of the reports;
and taking the target version and the target report quantity as common attributes corresponding to the total data area.
Optionally, obtaining a target report version based on the respective report versions includes:
and taking the latest version in the report versions as the target version.
Optionally, after the public attribute is added to the total data area and a combined report template is obtained, the method further includes:
and generating a target report by the combined report template through a preset report engine.
Optionally, the data area includes a cell, and the method further includes:
the dependency relationships between the cells are stored using an expression tree.
Optionally, the dependency relationship is managed according to a preset rule.
Based on the same inventive concept, the second aspect of the present invention provides a report template merging device, including:
the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring at least two report templates to be processed, and the report templates to be processed comprise public attributes and data areas;
the deleting module is used for deleting the public attribute of each report template to be processed and respectively generating the data area of each report template to be processed;
the generating module is used for combining the data areas of the report templates to be processed to generate a total data area;
and the merging module is used for adding the public attributes corresponding to the total data area in the total data area to obtain the merged report template, wherein the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template.
Optionally, the public attribute includes a report version and a report quantity, and the merging module is further configured to:
acquiring each report version of each report template to be processed, and acquiring a target report version based on each report version;
acquiring the quantity of each report template to be processed, and taking the sum of the quantities of the reports as the target quantity of the reports;
and taking the target version and the target report quantity as common attributes corresponding to the total data area.
Optionally, the merging module is further configured to:
and taking the latest version in the report versions as the target version.
Optionally, the apparatus provided in this embodiment further includes an execution module, configured to, after the common attribute is added to the total data area and the combined report template is obtained:
and generating a target report by the combined report template through a preset report engine.
Optionally, the apparatus provided in this embodiment further includes a storage module, where the storage module is configured to:
the dependency relationships between the cells are stored using an expression tree.
Optionally, the apparatus provided in this embodiment further includes a management module, configured to:
and managing the dependency relationship according to a preset rule.
Based on the same inventive concept, a third aspect of the present invention provides a computer-readable storage medium having stored thereon a computer program which, when executed, performs the steps of:
acquiring at least two report templates to be processed, wherein the report templates to be processed comprise public attributes and data areas;
deleting the public attribute of each report template to be processed, and respectively generating a data area of each report template to be processed;
merging the data areas of the report templates to be processed to generate a total data area;
and adding a public attribute corresponding to the total data area in the total data area to obtain a combined report template, wherein the public attribute corresponding to the total data area is obtained by integrating the public attribute of each report template.
Based on the same inventive concept, a fourth aspect of the present invention provides a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the program:
acquiring at least two report templates to be processed, wherein the report templates to be processed comprise a public attribute and a data area;
deleting the public attribute of each report template to be processed, and respectively generating a data area of each report template to be processed;
merging the data areas of the report templates to be processed to generate a total data area;
and adding a public attribute corresponding to the total data area in the total data area to obtain a combined report template, wherein the public attribute corresponding to the total data area is obtained by integrating the public attribute of each report template.
One or more technical solutions in the embodiments of the present application have at least one or more of the following technical effects:
in the method provided by the invention, before the report templates are combined, the data area of each report template can be respectively generated after the public attribute of each to-be-processed report template is deleted, and then the data areas are combined to generate the total data area.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
FIG. 1 is a flowchart illustrating a method for merging report templates according to an embodiment of the present invention;
FIG. 2 is a schematic diagram illustrating a generation manner of a total data area according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating a report template according to an embodiment of the present invention;
FIG. 4 is a diagram illustrating another reporting model in an embodiment of the present invention;
FIG. 5 is a diagram illustrating a merged report template according to an embodiment of the present invention;
FIG. 6 is a block diagram of a merging device for report templates in an embodiment of the present invention;
FIG. 7 is a schematic diagram illustrating a dependency relationship between cells in a report template according to an embodiment of the present invention;
FIG. 8 is a schematic diagram illustrating a dependency relationship of another cell in the report template according to an embodiment of the present invention;
FIG. 9 is a block diagram of a computer-readable storage medium according to an embodiment of the present invention;
fig. 10 is a block diagram of a computer device according to an embodiment of the present invention.
Detailed Description
The embodiment of the invention provides a method and a device for combining report templates, which are used for solving the technical problem that the combining mode of the report templates in the prior art is not high in flexibility.
The technical scheme in the embodiment of the application has the following general idea:
in other words, the embodiment of the invention can combine a plurality of templates into a large template, firstly respectively extract the content of each single template, and then form a large template by adding the format conditions required to be met by the templates. According to the method, the data areas of the report templates can be combined as required, so that the report templates can be dynamically combined according to requirements in time, the combining flexibility of the report templates is improved, and the technical problem that the combining mode of the report templates in the prior art is not high in flexibility is solved.
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example one
The embodiment provides a method for merging report templates, as shown in fig. 1, the method includes:
step S101 is first executed: at least two report templates to be processed are obtained, wherein the report templates comprise public attributes and data areas.
In particular, the reporting model may be provided by a third party vendor, and in general, the reporting model includes common attributes and a data area, wherein the common data may include a report version, a report number, and the like. The data area represents the private attributes of the reporting form template, and may include, for example, cells, data contents, rows, columns, and the like, the number of the reporting form templates to be processed is at least two, for example, 2, 3, 5, and the like, and the reporting form template includes an enterprise basic information table, a general enterprise income detail table, a general enterprise cost expenditure detail table, and the like, which may be selected according to actual situations, and is not specifically limited herein.
Then, step S102 is executed: and deleting the public attribute of each report template to be processed, and respectively generating the data area of each report template.
Specifically, the common attribute of the report template to be processed may be deleted, and then the data area of each report template may be generated. The deleting mode may be to delete the public attribute of the report template through a tool, or to delete the public attribute code corresponding to the report template, which is not specifically limited herein.
Taking the number of report templates to be processed as three as an example, the following describes in detail the process of generating the data area of each report template, for example, there are three different report templates: the first report template, the second report template and the third report template respectively generate corresponding data areas: a first data area, and a third data area.
Step S103 is performed next: and combining the data areas of the plurality of report templates to generate a total data area.
Specifically, the manner of merging the data areas of each report template into the total data area may be a manner of tool operation, or a manner of code, and is not particularly limited herein. To illustrate the manner of the total data area more clearly, a detailed description is given below by using a specific embodiment, taking the number of report templates to be processed as 3 as an example, please refer to fig. 2, the first report template, the second report template, and the third report template are respectively processed, that is, the respective public attributes are deleted, the first data area, and the third data area are respectively generated, and then the three data areas are combined to generate the total data area.
And step S104 is executed again: and adding public attributes corresponding to the total data area in the total data area to obtain combined report templates, wherein the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template.
Specifically, the total data area includes the data area of each report template, and the combined report template can be generated by adding the corresponding public attribute on the basis of the total data area. The common attributes corresponding to the total data area may be obtained in the following manners:
firstly, the public attribute of each report template to be processed is updated, and the public attribute of the total data area is obtained.
And secondly, analyzing and calculating the public attributes of the report templates to be processed, and then obtaining the public attributes of the total data area according to the relation among the public attributes.
In an optional implementation manner, the public attributes include report version and report number, and the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template, including:
acquiring each report version of each report template to be processed, and acquiring a target report version based on each report version;
acquiring the quantity of each report template to be processed, and taking the sum of the quantities of the reports as the quantity of a target report;
and taking the target version and the target report quantity as common attributes corresponding to the total data area.
Specifically, the target report version is determined by the report version of each report template to be processed, and the target version may be the latest version, the oldest version, or the version with a large number of versions of the report template in each report template. In addition, the report number can be obtained through a summation operation. The combined public attribute is obtained based on each report template to be processed, so that the accuracy can be ensured.
In an alternative embodiment, the latest version of the report versions may be used as the target version.
Specifically, the association between the new version and the old version may be set so that the respective versions are compatible with each other, and then the latest version is taken as the target version.
In an optional implementation manner, after adding the common attribute to the total data area and obtaining the combined report template, the method further includes:
and generating a target report by the combined report template through a preset report engine.
Specifically, the report engine mainly refers to the flow operation principle of the workflow engine, defines the format of the report and the algorithm of the report on the basis of the original data, automatically executes calculation according to the defined algorithm, outputs the calculated result, and displays the content of the report according to the defined report format. Because the existing report engine generally generates reports by adding business data to the output of the template design, the existing report engine cannot dynamically merge and combine report templates, and in the embodiment, a merging function is added before executing the report engine: generating a combined report template according with report engine rules by combining the report templates before the report engine executes the template, wherein the combined report template comprises the contents of a plurality of single templates, and submitting the combined template to the report engine to execute and generate a report; therefore, the report can be dynamically generated according to the requirements, the report template can be single enough during manufacturing, the business requirements can be met through free combination, the utilization rate of the single template is greatly improved, and the repeated work of report manufacturing is reduced.
In order to more clearly illustrate the beneficial effects of the embodiments of the present invention, a specific example is described below:
at present, there are a plurality of reports, for example, 38 reports, the 38 reports are separately made, and include an a000000 enterprise basic information table, an a100000 annual tax declaration form of the enterprise with the common name of Chinese, an a101010 general enterprise income statement table, an a101020 financial enterprise income statement table, an a102010 general enterprise cost expenditure statement table, and the like, each report has a corresponding report template, as shown in fig. 3, the report template of the a000000 enterprise basic information table includes a report attribute, a report name, a main body cell, a line number, a column number, and the like, as shown in fig. 4, the report template of the a101010 general enterprise income statement table also includes contents of the report attribute, the report name, the main body cell, the line number, the column number, and the like, and the report templates of other reports can also be set according to requirements, and are not introduced one by one. If in practical application, a certain enterprise only needs to use one part of the 38 reports, for example, 14 reports, according to the method provided by the embodiment of the present invention, step S1 is first executed: acquiring fourteen report templates to be processed, wherein the report templates include common attributes and data areas, for example, the attributes of the report templates include versions, the data areas are body units and corresponding formats, and then executing step S2: deleting the public attribute of each report template to be processed, and respectively generating a data area of each report template to be processed; then, step S3 is executed: merging the data areas of each report template to be processed to generate a total data area; step S4 is executed next: and adding a public attribute corresponding to the total data area to obtain a combined report template, as shown in fig. 5, the combined report template is the combined report template, wherein a square frame indicates the combined total data area, and a list on the left side indicates the combined 14 report templates. By the method, the report forms can be dynamically combined according to the requirements of enterprises. That is, before the report is output, the templates of all reports can be merged and spliced to meet the requirements of various enterprises, so that the merging flexibility of the report templates can be improved.
In an alternative embodiment, the data area includes cells, the method further comprising:
the dependency relationships between the cells are stored using an expression tree.
Specifically, the expression tree may be obtained by customizing a data structure, and the dependency relationship between the cells mainly includes a calculation relationship between the cells: for example, there are four cells A, B, C, D, a ═ B +5, and C ═ a × 6, then there is a dependency between cells A, B, C, i.e., a depends on B and C depends on a. When the report data is less, the calculation result can be filled in the report in a manual calculation mode. However, when the report data is large and the dependency relationship between reports or between cells of a single report is complex, the manual calculation method is inefficient and prone to errors. In the specific implementation process, one report is a set arranged as a matrix, and one cell contains three main factors, namely (1) value; (2) a formula; (3) an affiliation attribute. The value of a cell with a formula attribute is determined by the calculation of its formula. The attributes of the cells have the following characteristics: the value of the cell is determined by the execution result of the formula, and the formula of the report contains the dependency relationship of the cell. The embodiment of the invention can store the dependency relationship among the cells through the expression tree, so that when the data changes, the data in each cell can be automatically calculated and updated through the dependency relationship, and the calculation efficiency and accuracy can be improved.
In an alternative embodiment, the dependency relationships are managed according to preset rules.
Specifically, the preset rule may be set according to the dependency relationship, for example, setting the priority, the hierarchy, and the like. Taking a mode of setting a hierarchy as an example, referring to fig. 4 in particular, the dependency relationship of cells is represented by using a directed graph, because the dependency relationship exists between reports or between report cells, the dependency relationship can be well described by using the directed graph, and a path of cyclic dependency can be found by performing depth-first traversal (DFS) by using the directed graph, so that the calculation efficiency is improved.
More specifically, the cell dependency relationship shown in fig. 4 is N1 ═ N2+ N3, N2 ═ N3+4, and N3 ═ 6, so that the number of layers is N3, N2, and N1 in the order from low to high, the calculation is started from the lowest layer of the dependency relationship, and the calculation order is N3- > N2- > N1. The sequential calculation of report dependence can be ensured through the calculation path, the regression calculation after the calculation of N1 and the calculation of N2 is avoided, and the accuracy is improved.
In a specific implementation process, if the data of the node N1 is modified, the calculation order is calculated according to the level numbers of the nodes from low to high, and the calculation order of the nodes with the same level number is the same, so that the values of all the nodes are the latest values after being changed, and therefore, the method is a safe calculation order. Optionally, when data is updated, a cyclic dependency of the formula needs to be detected, and when one cell directly refers to itself or indirectly refers to itself, the dependency of the cell occurs, thereby causing an error. The embodiment may determine whether a cyclic reference exists by determining whether the child of the node references itself, or whether the child of the node is in a reference list. When the loop reference exists, a processing scheme of throwing the exception is adopted, such as a bullet box or an alarm, and the like, so as to prevent the exception from occurring when the system runs.
In one embodiment, the expression tree may be represented by a doubly linked list, and referring specifically to fig. 5, for node N1 in the expression tree G, the right side of the node combines all the child nodes into a single linked list with a head node, which is the child adjacency list of node N1. The left side of the node forms all parent nodes into a single linked list with head nodes, and the linked list is a parent adjacency list of the node N1.
Specifically, because the report form cells have upper and lower dependency relationships, the dependency relationship between the cells can be accurately and visually represented by adopting the bidirectional linked list to enable the head node to point to the dependent father node and the tail node to point to the dependent child node, and in addition, the bidirectional linked list can be sequentially searched from front to back and can also be searched from back to front in a reverse order, so that the searching and more-going flexibility is increased.
Based on the same inventive concept, the application also provides a device corresponding to the report template merging method in the embodiment, which is detailed in the second embodiment.
Example two
The present embodiment provides a report template merging device, please refer to fig. 3, the device includes:
the acquiring module 201 is configured to acquire at least two to-be-processed report templates, where each to-be-processed report template includes a common attribute and a data area;
the deleting module 202 is used for deleting the public attribute of each report template to be processed and respectively generating a data area of each report template to be processed;
the generating module 203 is configured to merge the data areas of each to-be-processed report template to generate a total data area;
and the merging module 204 is configured to add a common attribute corresponding to the total data area to obtain a merged report template, where the common attribute corresponding to the total data area is obtained by integrating the common attributes of each report template.
As an optional implementation manner, in the above apparatus, the common attribute includes a report version and a report number, and the merging module 204 is further configured to:
acquiring each report version of each report template to be processed, and acquiring a target report version based on each report version;
acquiring the quantity of each report template to be processed, and taking the sum of the quantities of the reports as the target quantity of the reports;
and taking the target version and the target report quantity as common attributes corresponding to the total data area.
As an alternative embodiment, in the above apparatus, the merging module 204 is further configured to: and taking the latest version in the report versions as a target version.
As an optional implementation manner, the apparatus further includes a target report execution module, configured to add a common attribute in the total data area, and after obtaining the combined report template:
and generating a target report by the combined report template through a preset report engine.
As an optional implementation, the data area includes a cell, and the apparatus further includes a storage module configured to:
the dependency relationships between the cells are stored using an expression tree.
As an optional implementation manner, the apparatus further includes a management module, configured to:
and managing the dependency relationship according to a preset rule.
Since the apparatus introduced in the second embodiment of the present invention is an apparatus used for implementing the method for merging report templates in the first embodiment of the present invention, a person skilled in the art can understand the specific structure and the deformation of the apparatus based on the method introduced in the first embodiment of the present invention, and thus the details are not described herein again. All the devices adopted in the method of the first embodiment of the present invention belong to the protection scope of the present invention.
EXAMPLE III
Based on the same inventive concept, the present application also provides a computer-readable storage medium 300, on which a computer program 311 is stored, which when executed by a processor implements a method in one implementation.
Specifically, the above program is configured to be able to execute the following steps:
acquiring at least two report templates to be processed, wherein the report templates to be processed comprise public attributes and data areas;
deleting the public attribute of each report template to be processed, and respectively generating a data area of each report template to be processed;
merging the data areas of the report templates to be processed to generate a total data area;
and adding public attributes corresponding to the total data area in the total data area to obtain combined report templates, wherein the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template.
Example four
Based on the same inventive concept, the present application further provides a computer device, please refer to fig. 4, which includes a storage 401, a processor 402, and a computer program 403 stored in the storage and running on the processor, wherein the processor 402 implements the method in one embodiment when executing the program.
Specifically, the processor is configured to perform the following steps:
acquiring at least two report templates to be processed, wherein the report templates to be processed comprise public attributes and data areas;
deleting the public attribute of each report template to be processed, and respectively generating a data area of each report template to be processed;
merging the data areas of the report templates to be processed to generate a total data area;
and adding public attributes corresponding to the total data area in the total data area to obtain the combined report template, wherein the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template.
One or more technical solutions in the embodiments of the present application have at least one or more of the following technical effects:
in the method provided by the invention, because the data area of each report template can be respectively generated after the public attribute of each report template to be processed is deleted before the report templates are combined, and then the data areas are combined to generate the total data area, compared with the prior method that the number of reports and the contents of the reports need to be combined when each report template is designed, the method can combine the data areas of each report template according to the needs, thereby realizing the dynamic combination of the report templates according to the needs in due time, improving the flexibility of combining the report templates and solving the technical problem that the flexibility of a combination mode of the report templates in the prior art is not high.
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, and the like) 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 of 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 a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
While preferred embodiments of the present invention have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the invention.
It will be apparent to those skilled in the art that various modifications and variations can be made in the embodiments of the present invention without departing from the spirit or scope of the embodiments of the invention. Thus, if such modifications and variations of the embodiments of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to encompass such modifications and variations.
Claims (8)
1. A method for merging report templates is characterized by comprising the following steps:
acquiring at least two report templates to be processed, wherein the report templates to be processed comprise public attributes and data areas;
deleting the public attribute of each report template to be processed, and respectively generating a data area of each report template to be processed;
merging the data areas of the report templates to be processed to generate a total data area;
adding public attributes corresponding to the total data area in the total data area to obtain combined report templates, wherein the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template;
the public attributes comprise report versions and report numbers; the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template, and the method comprises the following steps:
acquiring each report version of each report template to be processed, and acquiring a target report version based on each report version;
acquiring the quantity of each report template to be processed, and taking the sum of the quantities of the reports as the target quantity of the reports;
and taking the target report version and the target report quantity as the common attribute corresponding to the total data area.
2. The method of claim 1, wherein obtaining a target report version based on the respective report versions comprises:
and taking the latest version in the report versions as the target report version.
3. The method of claim 1, wherein after adding the common attribute to the total data area and obtaining the consolidated report template, the method further comprises:
and generating a target report by the combined report template through a preset report engine.
4. The method of claim 1, wherein the data area comprises a cell, the method further comprising:
the dependency relationships between the cells are stored using an expression tree.
5. The method of claim 4, wherein the dependencies are managed according to preset rules.
6. A merging device of report forms is characterized by comprising:
the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring at least two report templates to be processed, and the report templates to be processed comprise public attributes and data areas;
the deleting module is used for deleting the public attribute of each report template to be processed and respectively generating the data area of each report template to be processed;
the generating module is used for combining the data areas of the report templates to be processed to generate a total data area;
the merging module is used for adding public attributes corresponding to the total data area in the total data area to obtain merged report templates, wherein the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template;
the public attributes comprise report versions and report numbers; the merging module is further configured to:
acquiring each report version of each report template to be processed, and acquiring a target report version based on each report version;
acquiring the quantity of each report template to be processed, and taking the sum of the quantities of the reports as the target quantity of the reports;
and taking the target report version and the target report quantity as common attributes corresponding to the total data area.
7. A computer-readable storage medium having a computer program stored thereon, the program when executed implementing the steps of:
acquiring at least two report templates to be processed, wherein the report templates to be processed comprise a public attribute and a data area;
deleting the public attribute of each report template to be processed, and respectively generating a data area of each report template to be processed;
merging the data areas of the report templates to be processed to generate a total data area;
adding public attributes corresponding to the total data area in the total data area to obtain combined report templates, wherein the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template;
the public attributes comprise report versions and report quantity; the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template, and the method comprises the following steps:
acquiring each report version of each report template to be processed, and acquiring a target report version based on each report version;
acquiring the quantity of each report template to be processed, and taking the sum of the quantities of the reports as the quantity of a target report;
and taking the target report version and the target report quantity as the common attribute corresponding to the total data area.
8. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor when executing the program performs the steps of:
acquiring at least two report templates to be processed, wherein the report templates to be processed comprise public attributes and data areas;
deleting the public attribute of each report template to be processed, and respectively generating a data area of each report template to be processed;
merging the data areas of the report templates to be processed to generate a total data area;
adding public attributes corresponding to the total data area in the total data area to obtain combined report templates, wherein the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template;
the public attributes comprise report versions and report quantity; the public attributes corresponding to the total data area are obtained by integrating the public attributes of each report template, and the method comprises the following steps:
acquiring each report version of each report template to be processed, and acquiring a target report version based on each report version;
acquiring the quantity of each report template to be processed, and taking the sum of the quantities of the reports as the quantity of a target report;
and taking the target report version and the target report quantity as the common attribute corresponding to the total data area.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810612101.2A CN108804401B (en) | 2018-06-14 | 2018-06-14 | Report template merging method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810612101.2A CN108804401B (en) | 2018-06-14 | 2018-06-14 | Report template merging method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108804401A CN108804401A (en) | 2018-11-13 |
| CN108804401B true CN108804401B (en) | 2022-06-21 |
Family
ID=64087012
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810612101.2A Active CN108804401B (en) | 2018-06-14 | 2018-06-14 | Report template merging method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108804401B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111104784B (en) * | 2019-12-19 | 2024-03-12 | 金蝶软件（中国）有限公司 | Data integration method and related device |
| CN111737539A (en) * | 2020-08-24 | 2020-10-02 | 成都四方伟业软件股份有限公司 | Complex report engine method and device |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101876970A (en) * | 2009-12-22 | 2010-11-03 | 金蝶软件（中国）有限公司 | Method for combining reports and device thereof |
| CN101908039A (en) * | 2010-06-29 | 2010-12-08 | 北京科技大学 | Report template customizing system |
| US8051103B1 (en) * | 2008-04-08 | 2011-11-01 | United Services Automobile Association (Usaa) | Systems and methods for creating documents from templates |
| CN103440557A (en) * | 2013-08-19 | 2013-12-11 | 远光软件股份有限公司 | Generation method and system for group consolidated accounts and consolidated statements |
| CN104142952A (en) * | 2013-05-10 | 2014-11-12 | 中国电信股份有限公司 | Method and device for showing reports |
| CN104881275A (en) * | 2015-02-11 | 2015-09-02 | 中国农业银行股份有限公司 | Electronic spreadsheet generating method and device |
| CN107608951A (en) * | 2017-09-22 | 2018-01-19 | 上海金智晟东电力科技有限公司 | Report form generation method and system |
| CN107741971A (en) * | 2017-10-10 | 2018-02-27 | 国网浙江省电力公司电力科学研究院 | A kind of method of the online visual analysis PPT based on self-defined dynamic data |
| CN107885709A (en) * | 2017-09-29 | 2018-04-06 | 深圳市共济科技股份有限公司 | A kind of report form generation method, system and storage medium |
-
2018
- 2018-06-14 CN CN201810612101.2A patent/CN108804401B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8051103B1 (en) * | 2008-04-08 | 2011-11-01 | United Services Automobile Association (Usaa) | Systems and methods for creating documents from templates |
| CN101876970A (en) * | 2009-12-22 | 2010-11-03 | 金蝶软件（中国）有限公司 | Method for combining reports and device thereof |
| CN101908039A (en) * | 2010-06-29 | 2010-12-08 | 北京科技大学 | Report template customizing system |
| CN104142952A (en) * | 2013-05-10 | 2014-11-12 | 中国电信股份有限公司 | Method and device for showing reports |
| CN103440557A (en) * | 2013-08-19 | 2013-12-11 | 远光软件股份有限公司 | Generation method and system for group consolidated accounts and consolidated statements |
| CN104881275A (en) * | 2015-02-11 | 2015-09-02 | 中国农业银行股份有限公司 | Electronic spreadsheet generating method and device |
| CN107608951A (en) * | 2017-09-22 | 2018-01-19 | 上海金智晟东电力科技有限公司 | Report form generation method and system |
| CN107885709A (en) * | 2017-09-29 | 2018-04-06 | 深圳市共济科技股份有限公司 | A kind of report form generation method, system and storage medium |
| CN107741971A (en) * | 2017-10-10 | 2018-02-27 | 国网浙江省电力公司电力科学研究院 | A kind of method of the online visual analysis PPT based on self-defined dynamic data |
Non-Patent Citations (1)
| Title |
|---|
| 合并会计报表软件开发;许明强 等;《杭州电子工业学院学报》;20030831;第23卷(第4期);94-98 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108804401A (en) | 2018-11-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6916403B2 (en) | Specifying and applying logical validation rules to data | |
| US9021440B1 (en) | System and method for automated test script generation | |
| US10089294B2 (en) | Systems and methods for tracking and modifying actions in an action history | |
| KR20150132858A (en) | System for metadata management | |
| CN107748752B (en) | Data processing method and device | |
| CN106611037A (en) | Method and device for distributed diagram calculation | |
| US20160012110A1 (en) | General and automatic approach to incrementally computing sliding window aggregates in streaming applications | |
| Dudoladov et al. | Optimistic recovery for iterative dataflows in action | |
| CN108804401B (en) | Report template merging method and device | |
| CN108255479A (en) | Creation method, device, storage medium and the terminal of cube files | |
| US10331643B2 (en) | Generating context tree data based on a tailored data model | |
| US10664653B2 (en) | Automated structured cloud datatester | |
| US11055275B2 (en) | Database revalidation using parallel distance-based groups | |
| CN115878589A (en) | Version management method and device of structured data and related equipment | |
| US20130346845A1 (en) | Interactive multi device in memory form generation | |
| US20230259337A1 (en) | Application development platform | |
| US10198473B2 (en) | Hierarchical document flow determination | |
| CN113157934A (en) | Knowledge graph origin processing method and system, electronic device and storage medium | |
| CN112130849A (en) | Automatic code generation method and device | |
| CN116860227B (en) | Data development system and method based on big data ETL script arrangement | |
| US20240144033A1 (en) | Knowledge reuse methods and systems | |
| CN112000366B (en) | System parameter configuration method and device based on code generator | |
| CN110084564B (en) | ICE architecture for project data management | |
| US20230289241A1 (en) | Automatic data pipeline generation | |
| US20230367957A1 (en) | System and method for document branching |
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 |