CN113761859B

CN113761859B - Electronic report definition method and device and electronic equipment

Info

Publication number: CN113761859B
Application number: CN202111320870.3A
Authority: CN
Inventors: 左少杰; 陈奕杉
Original assignee: Wuhan Xianfeng Data Co ltd
Current assignee: Wuhan Xianfeng Data Co ltd
Priority date: 2021-11-09
Filing date: 2021-11-09
Publication date: 2022-04-12
Anticipated expiration: 2041-11-09
Also published as: CN113761859A

Abstract

The disclosure provides an electronic report definition method and device and electronic equipment. The method comprises the following steps: acquiring first parameters of the electronic report, wherein the first parameters comprise basic parameters, global parameters and global variables of the electronic report; generating a root node of the electronic report on a first interface of the electronic report based on the first parameter, wherein the root node is a title of the electronic report; responding to a new child node adding instruction under the root node, generating child nodes of the electronic report on a first interface of the electronic report, wherein the child nodes are grouped for report pages of the electronic report; responding to a new leaf node adding instruction under the child nodes, and generating leaf nodes of the electronic report on a first interface of the electronic report, wherein the leaf nodes are the titles of report pages of the electronic report; acquiring a second parameter of the leaf node, wherein the second parameter is used for indicating a local parameter and a local variable of a report page of an electronic report and a structure of the report page; and generating a report page corresponding to the leaf node on a second interface of the electronic report based on the second parameter.

Description

Electronic report definition method and device and electronic equipment

Technical Field

The present disclosure relates to the field of electronic reports, and in particular, to an electronic report defining method and apparatus, and an electronic device.

Background

The electronic report is a tabular file which records various indexes of the equipment after the equipment is checked. For more complex equipment, the electronic report is more complex due to more components of the equipment, for example, the content page number of a check report inside a utility boiler can be as much as 100 pages, even more than 200 pages.

Electronic reports are usually formulated by WORD or EXCEL software, and the disadvantages of this method are mainly: (1) the free classification management of a plurality of content pages of a complex report is difficult, or the classification assembly operation is time-consuming; (2) although WORD can perform hierarchical navigation by using the size of a title, the page content is continuous page by page, if the position and the sequence of the title and the content in a document are required to be changed, the title and the content below the title need to be moved to another content position through a cutting operation, and the hierarchical navigation display of the title is easily disordered.

Disclosure of Invention

The embodiment of the disclosure provides an electronic report definition method and device, and electronic equipment, which can realize an electronic report with a tree structure, enable a plurality of content pages of the electronic report to be freely classified and managed and to be classified and assembled, and can realize hierarchical navigation. The technical scheme is as follows:

at least one embodiment of the present disclosure provides an electronic report definition method, including:

acquiring first parameters of an electronic report, wherein the first parameters comprise basic parameters, global parameters and global variables of the electronic report;

generating a root node of the electronic report on a first interface of the electronic report based on the first parameter, wherein the root node is a title of the electronic report;

generating child nodes of the electronic report on a first interface of the electronic report in response to a new child node adding instruction under the root node, wherein the child nodes are grouped into report pages of the electronic report;

generating a leaf node of the electronic report on a first interface of the electronic report in response to a new leaf node adding instruction under the child node, wherein the leaf node is a title of a report page of the electronic report;

acquiring a second parameter of the leaf node, wherein the second parameter is used for indicating a local parameter, a local variable and a report page structure of a report page of the electronic report;

and generating a report page corresponding to the leaf node on a second interface of the electronic report based on the second parameter, wherein the first interface and the second interface of the electronic report are arranged side by side.

Optionally, the obtaining a first parameter of the first interface of the electronic report includes:

responding to the newly-built electronic report instruction, and outputting a report attribute input interface;

and acquiring the first parameter input through the report attribute input interface.

Optionally, the obtaining the second parameter of the leaf node includes:

responding to the leaf node attribute configuration instruction, and outputting a report page attribute input interface;

and acquiring the second parameter input through the report page attribute input interface.

Optionally, the method further comprises:

adjusting the report page format in response to a report page format adjustment instruction;

the report page format adjustment instruction is to indicate one of: adding rows or columns, deleting rows or columns, setting the height or width of rows or columns, merging cells, splitting cells.

Optionally, the method further comprises:

responding to the cell attribute setting instruction, and outputting a cell attribute setting interface;

acquiring cell attribute parameters input through the cell attribute setting interface;

changing the appearance of the cell or the data of the cell according to the cell attribute parameter.

Optionally, the data of the cells is obtained through an automatic formula;

the automation formula to reference one of the global parameter, the global variable, the local parameter, the local variable, an external parameter, and an external variable.

Optionally, the method further comprises:

moving the selected first report page from the first report page group to the second report page group in response to a first movement instruction of the first report page;

moving the selected first report page in the first report page group to adjust the position of the first report page in response to the second movement instruction of the first report page;

and generating the same report page as the second report page in the fourth report page group under the third report page group in response to the copy instruction of the second report page.

At least one embodiment of the present disclosure provides an electronic report definition apparatus, including:

the system comprises an acquisition module, a processing module and a display module, wherein the acquisition module is used for acquiring first parameters of an electronic report, and the first parameters comprise basic parameters, global parameters and global variables of the electronic report;

a generating module, configured to generate a root node of the electronic report on a first interface of the electronic report based on the first parameter, where the root node is a title of the electronic report; generating child nodes of the electronic report on a first interface of the electronic report in response to a new child node adding instruction under the root node, wherein the child nodes are grouped into report pages of the electronic report; generating a leaf node of the electronic report on a first interface of the electronic report in response to a new leaf node adding instruction under the child node, wherein the leaf node is a title of a report page of the electronic report;

the obtaining module is further configured to obtain a second parameter of the leaf node, where the second parameter is used to indicate a local parameter, a local variable, and a structure of a report page of the electronic report;

the generating module is further configured to generate a report page corresponding to the leaf node on a second interface of the electronic report based on the second parameter, where the first interface and the second interface of the electronic report are arranged side by side.

At least one embodiment of the present disclosure provides an electronic device comprising a processor and a memory, the memory storing at least one program code, the program code being loaded and executed by the processor to implement the electronic report definition method as set forth above.

At least one embodiment of the present disclosure provides a computer-readable storage medium having at least one program code stored therein, the program code being loaded and executed by a processor to implement the electronic report definition method as in any one of the preceding claims.

The technical scheme provided by the embodiment of the disclosure has the following beneficial effects:

in the embodiment of the present disclosure, in the electronic report definition process, the electronic report of the tree structure is formed by defining the root node first, then defining the child nodes, and finally defining the leaf nodes. By adopting the tree structure, the relation between report page pages in the electronic report can be clearer, and the tree structure can be utilized to conveniently realize the functions of moving, copying and the like of the report pages. A plurality of content pages (report pages) of the electronic report can realize free classification management and classification assembly operation by means of the structural relationship between the child nodes and the leaf nodes, and can realize hierarchical navigation.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present disclosure, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present disclosure, and it is obvious for those skilled in the art to obtain other drawings based on the drawings without creative efforts.

Fig. 1 is a flowchart of an electronic report definition method provided by an embodiment of the present disclosure;

FIG. 2 is a flow chart of an electronic report definition method provided by an embodiment of the present disclosure;

FIG. 3 is a schematic diagram of a report attribute input interface provided by an embodiment of the present disclosure;

fig. 4 is a schematic process diagram of a new child node provided by an embodiment of the present disclosure;

FIG. 5 is a schematic diagram of a report page property input interface provided by an embodiment of the present disclosure;

FIG. 6 is a schematic diagram of a local parameter input interface provided by an embodiment of the present disclosure;

FIG. 7 is a schematic diagram of a local variable input interface provided by an embodiment of the present disclosure;

FIG. 8 is a diagram illustrating a report page format adjustment provided by an embodiment of the present disclosure;

FIG. 9 is a diagram illustrating a report page format adjustment provided by an embodiment of the present disclosure;

FIG. 10 is a schematic diagram of a cell attribute setting provided by an embodiment of the present disclosure;

FIG. 11 is a schematic diagram of a rich text editor provided by an embodiment of the present disclosure;

FIG. 12 is a schematic diagram of a cell attribute setting provided by an embodiment of the present disclosure;

FIG. 13 is a schematic diagram of a cell attribute setting provided by an embodiment of the present disclosure;

fig. 14 is a schematic structural diagram of an electronic report definition apparatus provided in an embodiment of the present disclosure;

fig. 15 is a block diagram of an electronic device according to an embodiment of the present disclosure.

Detailed Description

To make the objects, technical solutions and advantages of the present disclosure more apparent, embodiments of the present disclosure will be described in detail with reference to the accompanying drawings.

Unless defined otherwise, technical or scientific terms used herein shall have the ordinary meaning as understood by one of ordinary skill in the art to which this disclosure belongs. The use of "first," "second," "third," and similar terms in the description and claims of the present disclosure are not intended to indicate any order, quantity, or importance, but rather are used to distinguish one element from another. Also, the use of the terms "a" or "an" and the like do not denote a limitation of quantity, but rather denote the presence of at least one. The word "comprise" or "comprises", and the like, means that the element or item listed before "comprises" or "comprising" covers the element or item listed after "comprising" or "comprises" and its equivalents, and does not exclude other elements or items.

Fig. 1 is a flowchart of an electronic report definition method provided in an embodiment of the present disclosure. Referring to fig. 1, the method includes:

101: acquiring first parameters of an electronic report, wherein the first parameters comprise basic parameters, global parameters and global variables of the electronic report.

In the disclosed embodiments, the basic parameters of an electronic report refer to parameters that define the basic characteristics of an electronic report. The global parameter and the global variable of the electronic report refer to parameters that can be referred to by a report page of the electronic report, and the value of the global parameter is constant while the value of the global variable is variable.

Illustratively, the basic parameters of an electronic report include: report name, report unique identification, report author, report version, report creation and modification time, report description, report catalog type, current active report page identification, and number of report pages, etc.

The global parameters of the electronic report and the global variables of the electronic report can be defined according to the requirements, and the definition contents of the global parameters and the global variables comprise: name of parameter/variable, value of parameter/variable, data type of parameter/variable.

In the disclosed embodiment, the first parameter of the electronic report may be saved in xml format. The following is an example of a first parameter in xml format provided by an embodiment of the present disclosure:

< Report Name ═ power plant boiler internal inspection Report "ID ═ 88F770DA-3F24-BC20-8094-E1191263C36E" >)

<Author>admin</Author>

<Desc/>

</ReportParams>

</ReportVars>

<SheetsActiveSheet＝"2668DB20-E782-A307-BA69-3A448FOE88CC"SheetCount＝"36"/>

</Report>

Wherein the report is named as ' electronic boiler internal inspection report ', the unique identifier of the report is ' 88F770DA-3F24-BC20-8094-E1191263C36E ', the report author is ' admin ', the report version is ' 1.0 ', the report creation time is ' 2019-05-24 ', the modification time is ' 2019-05-2414: 17: 04 ", report description is empty, report catalog type is" 0", current active report page is identified as" 2668DB20-E782-a307-BA69-3a448FOE88CC ", and report page number is" 36 ".

In addition to the basic parameters described above, a global parameter and a global variable are defined. Wherein the name of the global parameter is 'ReportCode', the value of the global parameter is null, and the data type of the global parameter is 'String'; the name of the global variable is "PageCount", the value of the global variable is null, and the data type of the global variable is "Long".

102: generating a root node of the electronic report at a first interface of the electronic report based on the first parameter, wherein the root node is a title of the electronic report.

In an embodiment of the present disclosure, the electronic report is a tree structure including a root node and a plurality of leaf nodes, wherein the leaf nodes include child nodes of the root node and leaf nodes. By adopting the tree structure, the relation between report page pages in the electronic report can be clearer, and the tree structure can be utilized to conveniently realize the functions of moving, copying and the like of the report pages.

103: generating child nodes of the electronic report at a first interface of the electronic report in response to a new child node instruction under the root node, the child nodes grouping report pages of the electronic report.

The report page group refers to a combination of report pages of the same type in an electronic report, for example, one report page group is defined as "inspection conclusion", and a plurality of report pages used for presenting inspection conclusions for respective devices may be set under the group.

104: generating a leaf node of the electronic report at a first interface of the electronic report in response to a new leaf node instruction under the child node, the leaf node being a header of a report page of the electronic report.

105: and acquiring a second parameter of the leaf node, wherein the second parameter is used for indicating a local parameter, a local variable and a report page structure of a report page of the electronic report.

The local parameters and local variables of the report page generally refer to the parameters and variables in the report page.

In the disclosed embodiment, the portion of the second parameter used to indicate the structure of the report page generally includes: node name, node identification, father node identification, whether leaf nodes exist, page paper size, horizontal and vertical directions, page margin, whether automatic paging exists, whether page sleeving is performed, whether directory pages exist, whether page numbers are calculated, whether page continuation exists, and user-defined data.

The following is an example of a part of the second parameters of an xml format provided by the embodiments of the present disclosure:

< sheetnodededpagebreak ═ false "needle" continuous ═ true "IsLeaf ═" false "NodeData ═ ParentID ═"0 "nodaname ═" cover and directory "NodelD ═"1DB78F0B-B858-8C4D-9A42-DC3B91181923 ">", and

< sheetnodededpagebreak ═ false "needle" continuous ═ false "needle" no ═ false "continuous ═" true "IsLeaf ═" false "NodeData ═ ParentID ═"0 "nodaname ═" inspection conclusion "NodeID ═"779A8CEE-C974-6812-

< sheetnodededpagebreak ═ false "needle" continuous ═ false "IsLeaf ═" true "node data ═ ParentID ═ 779A8 CEE-C974-C6812-

< sheetnodededpagebreak ═ false "needle" continuous ═ false "IsLeaf ═" true "NodeData ═ ParentID ═ 779A8CEE-C974-6812-

< sheetnodededpagebreak ═ false "needle" continuous ═ true "IsLeaf ═" false "NodeData ═ fractional" partial id ═ "0" nodaname ═ "tube partial report" nodeidd ═ "FADA9433-7219-7160-51C3-837FB6A9DA2C" >)

< sheetnodededpagebreak ═ false "needle" continuous ═ true "IsLeaf ═ false" NodeData ═ ParentID ═ 0 "nodaname ═" water-cooled branch report "NodelD ═"421C66AD-760D-95E4-7BB2-CC45067446F4"

< sheetnodededpagebreak ═ false "needle" continuity ═ false "needle" no ═ false "continuous ═" true "IsLeaf ═" false "NodeData ═" ParentID ═ "0" NodeName ═ "superheater section report" NodeID ═ "4705B1AE-5AB3-945C-F62E-B373D0329D1D >

< sheetnodeenededpagebreak ═ false "needle textonly ═ false" needle directory ═ false "needle pageno ═" false "continuous ═" true "IsLeaf ═" false "NodeData ═ ParentiD ═ 0" NodeName ═ "device branch report" NodeD ═ "85A0D09B-2CAD-9436-B4C0-85EC9F24A2A9"

< sheetnodededpagebreak ═ false "needle" continuous ═ true "IsLeaf ═" false "NodeData ═ para ═"0 "nodaname ═" economizer branch report "NodeID ═" F81F5592-6035-DE22-EA9B-0691CC201B5C ">", and

< sheetnodededpagebreak ═ false "needle" continuous ═ true "IsLeaf ═" false "NodeData ═ part id ═"0 "nodaname ═" other parts report "NodeID ═"03E77741-FAA5-8C21-4A8F-7C 22563814 ">", and

< sheetnodededpagebreak ═ false "needle" continuous ═ true "IsLeaf ═" false "NodeData ═ para ═"0 "nodaname ═" general report page "NodeID ═" E7097D30-B535-04F4-5C6F-EE4 EFE02 ">" FO

The second parameter of the multiple report pages is shown in the xml format, such as "tube itemized report", "water cooled itemized report", and so on. In the xml format, the NodeName identifies the node name, the NodeID represents the node identification, the ParentID represents the father node identification, IsLeaf represents whether leaf node exists, the needlepagebreak represents whether automatic paging exists, the needletextonly represents whether page is paged in a sleeving manner, the needledirectory represents whether directory page exists, the needlepageno represents whether page number is calculated, the Continued represents whether page is Continued, and the noddata represents custom data.

The following is an example of another part of the second parameters in an xml format provided by the embodiments of the present disclosure:

<PrintSetMarginRight＝"18"MarginBottom＝"15"MarginLeft＝"20"MarginTop＝"15"Height＝"297"Width＝"210"PageSize＝"A4"Orientation＝"1"/>

</SheetVars>

illustratively, the xml format with parameters and variables is as follows:

< Param Name ═ auditor "Type ═ String" Value ═/>, and

</SheetParams>

</SheetVars>

wherein, MarginRight represents the right margin, MarginBottom represents the lower margin, MarginLeft represents the sitting margin, MarginTop represents the upper margin, Height represents the longitudinal Height, Width represents the transverse Width, PageSize represents the page size, and Orientation represents the transverse and longitudinal directions. SheetParams denotes local parameters and SheetVars denotes local variables.

106: and generating a report page corresponding to the leaf node on a second interface of the electronic report based on the second parameter, wherein the first interface and the second interface of the electronic report are arranged side by side.

In the embodiment of the disclosure, the electronic report includes a first interface and a second interface, the first interface is used for displaying a tree structure of the electronic report, and when a user clicks a node in the tree structure, a report page corresponding to the node is displayed in the second interface.

It should be noted that the electronic report defined by the embodiments of the present disclosure is actually a report template, and after the report template is defined, the report template may be uploaded to a server or stored locally, so that a report maker can use the report template to make an electronic report.

Optionally, before uploading the electronic report or saving locally, the method may further comprise: and compressing the electronic report and storing the electronic report in a binary compressed file form.

Fig. 2 is a flowchart of an electronic report definition method provided in an embodiment of the present disclosure. Referring to fig. 2, the method includes:

201: and responding to the new electronic report command, and outputting a report attribute input interface.

In the disclosed embodiment, the electronic report definition is implemented by a software, and a report attribute input interface is output in response to a new electronic report command input by a user through the software.

Fig. 3 is a schematic diagram of a report attribute input interface provided by an embodiment of the present disclosure, and referring to fig. 3, the report attribute input interface includes a plurality of input boxes for inputting values of respective fields in a first parameter.

202: and acquiring the first parameter input through the report attribute input interface.

Wherein the first parameters include basic parameters, global parameters, and global variables of the electronic report.

203: generating a root node of the electronic report at a first interface of the electronic report based on the first parameter, wherein the root node is a title of the electronic report.

At this time, the electronic report is an empty report, and although basic parameters and the like of the electronic report are set, there is no specific report page at this time.

204: generating child nodes of the electronic report at a first interface of the electronic report in response to a new child node instruction under the root node, the child nodes grouping report pages of the electronic report.

Fig. 4 is a schematic process diagram of a new child node according to an embodiment of the present disclosure. Referring to fig. 4, in response to a right button instruction on the root node, a right button menu is output; and receiving a new sub-node adding instruction input through a right-click menu, namely an instruction of adding a group in the graph.

As shown in FIG. 4, after the new packet is completed, the first interface of the electronic report has the root node "station boiler internal inspection report" and the child node "inspection conclusion".

205: generating a leaf node of the electronic report at a first interface of the electronic report in response to a new leaf node instruction under the child node, the leaf node being a header of a report page of the electronic report.

Here, the leaf node is generated in the same manner as the child node.

206: and responding to the leaf node attribute configuration instruction, and outputting a report page attribute input interface.

207: and acquiring the second parameter input through the report page attribute input interface.

Fig. 5 is a schematic diagram of a report sheet property input interface provided by an embodiment of the present disclosure, and referring to fig. 5, the report sheet property input interface includes a plurality of input boxes for inputting values of respective fields in a second parameter. Partial parameters indicating the structure of the report page are mainly shown in fig. 5, and mainly include parameters of page paper size, horizontal and vertical directions, margin, whether to automatically page, whether to page in a suit, whether to page in a catalog, whether to calculate page number, whether to continue pages, and the like. The parameters such as the node name, the node identifier, the father node identifier, whether the leaf node exists and the like can be input through another report page attribute input interface, and the parameters can also be input through the same report page attribute input interface.

As shown in fig. 5, the report sheet property input interface is displayed on the second interface, and a default report sheet may be output simultaneously with the display of the report sheet property input interface.

Alternatively, the default report page may be related to the group in which the report page is located, for example, if the group name is the verification conclusion, the output default report page is the default report page associated with the verification conclusion.

In a possible implementation manner, the local parameters, the local variables and the structural parameters indicating the report page are input by using the same report page attribute input interface. In another possible implementation, the local parameters, the local variables and the aforementioned structural parameters indicating the report page are input by using different report page attribute input interfaces.

The following description will take the examples of inputting local parameters and local variables using different report page attribute input interfaces:

fig. 6 is a schematic diagram of a local parameter input interface provided by an embodiment of the present disclosure, referring to fig. 6, in this implementation, a local parameter (i.e., a page parameter) mainly includes two items, namely, a report number and a check date, and a user only needs to select a parameter type, and a report number and a check date are automatically generated at a corresponding position of the report page, for example, a header of the report page shown in fig. 6.

Fig. 7 is a schematic diagram of a local variable input interface provided by an embodiment of the present disclosure, referring to fig. 7, in this implementation, a local variable (i.e., a page variable) mainly includes two items, namely a page number and a total page number, and a user only needs to select a variable type and an expression, and will automatically generate the page number and the total page number at a corresponding position of the report page without inputting a value by the user, for example, at the bottom of the report page shown in fig. 7.

In fig. 6 and 7, the user may also add a new local parameter and a new local variable by adding a button, which is not described again.

208: and generating a report page corresponding to the leaf node on a second interface of the electronic report based on the second parameter, wherein the first interface and the second interface of the electronic report are arranged side by side.

And when the second parameter is acquired, setting the default report page according to the second parameter, thereby outputting the report page corresponding to the second parameter.

209: and adjusting the report page format in response to a report page format adjustment instruction.

Wherein the report page format adjustment instruction is to indicate one of: adding rows or columns, deleting rows or columns, setting the height or width of rows or columns, merging cells, splitting cells.

Fig. 8 and 9 are schematic diagrams illustrating a report page format adjustment provided by an embodiment of the present disclosure. Referring to fig. 8 and 9, when a cell of a report page is selected, a right button menu is output in response to a right button command on the cell; a report page formatting adjustment command, such as an insert line (i.e., add line) command in fig. 8 or a cell merge command in fig. 9, which is input through the right-click menu, is received, a line is inserted at the selected cell, or a cell merge operation is performed on the selected cell.

In the embodiment of the present disclosure, the report page format data is also stored in xml format, and when the row data, the column data, and the cell data are stored, in addition to the parameters (height, width, etc.) of the row, the column, and the cell, indexes corresponding to the row, the column, and the cell need to be stored. For example:

it can be seen that the column with index 0, the width 27, the row with index 0, the height 80, etc.

210: and responding to the cell attribute setting instruction, and outputting a cell attribute setting interface.

211: and acquiring cell attribute parameters input through the cell attribute setting interface.

Fig. 10 is a schematic diagram of setting a cell attribute according to an embodiment of the present disclosure. Referring to fig. 10, when a cell of a report page is selected, a right button menu is output in response to a right button command on the cell; and receiving a cell attribute setting instruction input through a right-click menu, and outputting a cell attribute setting interface. As shown in fig. 10, the cell attribute setting interface is located in the second interface, and is displayed side by side with the report page.

As shown in fig. 10, the cell attributes that can be set in the cell attribute setting interface include, but are not limited to: cell identification, cell coding, cell name, cell width, cell height, horizontal alignment, vertical alignment, top left bottom right gap, border style, font setting, underlining, foreground color, background color, lock editing (data access rights control), allowed copying, data type, picture extension attachment (may support attached drawing, attached rich text), formatting string, data length, allowed to be blank, initial reading formula (or called automation formula), write data formula, dynamic pull-down data formula, content annotation, custom data, whether to use a chapter (whether to allow signing a report page to be sealed), whether to use a set (whether to use a set of cell contents), other extensible data (up to 9 can be supported), and the like.

If the picture expansion accessory is an accessory drawing, the user can draw a vector diagram, and if the picture expansion accessory is an accessory rich text, the user can edit a piece of rich text content through a rich text editor, as shown in fig. 11. After the editing is quitted, the corresponding drawing schematic diagram or the rich text content can be automatically placed into the corresponding cell and displayed in the picture effect, and after double-click is performed again, the user can modify the schematic diagram or modify the content of the rich text.

Among them, the data types include but are not limited to: text, values, sets, time of day, boolean values, pictures, vector graphics, rich text, attachments, audio and video, etc.

Similarly, the cell attributes may also be saved in an xml format, which is not described herein.

212: changing the appearance of the cell or the data of the cell according to the cell attribute parameter.

Here, the appearance refers to attributes such as the shape and size of the cell. The data of the cell is the content filled in the cell.

The data of the cells correspond to data types, the data types are different, the values corresponding to the cells are different, for example, if the data types are vector graphics, the values stored in the cells are vector graphics.

Data such as text, numerical values, sets, time of day, boolean values, etc. may be obtained through input or formulas that may be used to reference one of the global parameter, the global variable, the local parameter, the local variable, an external parameter, and an external variable.

For data such as pictures, vector graphics, rich text and the like, data of cells can be obtained by drawing, text editing and the like.

For data such as pictures, attachments, audios and videos, the data of the cells can be obtained in the modes of importing, uploading and the like.

Fig. 12 is a schematic diagram of setting a cell attribute according to an embodiment of the present disclosure. Referring to fig. 12, a cell for displaying a local parameter "report number" is provided with an automation formula, so that the cell can automatically obtain and display the "report number" from a global variable.

For example, the value of the "report number" cell may automatically refer to the global parameter of the report: report code, the defined format of its formula is: m { $ P { Reportcode } }, M represents an automatic filling formula, $ P represents a reference report parameter, the Reportcode represents a specific parameter name, { } is used for identifying the variable action range in an expression,

illustratively, the report number ReportCode of the utility boiler periodic inspection report is generated according to the rule: when a new plant boiler regular inspection report is built, once a user selects the report template, the system automatically matches the corresponding report number rule, automatically generates the report number of the report and transmits the report number to the report template in a parameter value mode, so that the generated report number value is automatically filled in each report page in the report template as long as a cell which refers to the parameter of the report number exists: dzgl _ dqjy _2021_08_ 0001.

In addition, in addition to the implementation of automatically filling cells, which uses global parameters, global variables, and the like to automatically fill all the cited cells, there is another implementation manner: setting an initialization reading formula of the cell on the cell. For example, basic information of the device is pre-stored in a data table, and in order to reduce the repeated entry of device data in a report by a user, the capability of setting a cell reading formula is provided. For example, the reading formula is expressed as R { TBS _ EQU _ NAME }, where R represents an automatic data reading formula, and the server system may first obtain an xml description file of each template report page in the report from the remote file system, and analyze all cells defining the reading formula from the xml description file, then automatically query one or more lines of data in the device data table corresponding to the report (TBS _ EQU represents a device data table NAME), and then obtain one or more attribute information of the corresponding device, for example: if a certain cell in the electronic report page defines the above-mentioned automatic reading formula of the device NAME, the server-side system may extract the data value of the device NAME and automatically fill the data value into the cell corresponding to the formula.

That is, the automation formula may reference one of the global parameter, the global variable, the local parameter, the local variable, an external parameter, and an external variable, where the external parameter and the external variable may be parameters and variables stored in the server.

Fig. 13 is a schematic diagram of setting a cell attribute according to an embodiment of the present disclosure. As shown in fig. 13, in response to the data type being a picture or a vector graphic, the picture extended auxiliary is set as a vector drawing, an auxiliary picture drawing interface is displayed in the second interface, a user input is received through the auxiliary picture drawing interface, and a corresponding auxiliary drawing is output.

Illustratively, for vector graphics, a graphic name, a graphic byte number, a graphic width and height, a graphic description, a graphic format (PNG, JPG, BMP, GIF, etc.), vector graphics extension data, byte content (encoded using Base 64) in a report cell displaying a PNG diagram, and the like may be further set.

As shown in FIG. 13, a large cell in the "boiler barrel map" report page defines a corresponding data format as: the picture, set up the picture to expand and attach to do: vector drawing (extending the type of attached drawing). Then, double-clicking the cell by a mouse, popping up a tool for designing vector graphics, selecting a tube part, and quickly drawing a tube pattern. After the vector graphics are designed, the current report page can be returned.

In addition to vector drawing tools, for text, mathematical formulas may also be entered by extending the mathematical formula tools. For rich text, the rich text can be input by expanding the rich text tool, such as setting the font, color, size, bold italics, upper and lower corner marks of paragraphs, text content, and the ability to insert pictures and special characters.

213: and moving the selected first report page from the first report page group to the second report page group in response to the first moving instruction of the first report page. Or, in response to the second movement instruction of the first report page, moving the selected first report page in the first report page group to adjust the position of the first report page.

Illustratively, the moving the selected first report page from the first report page group to the second report page group in response to the moving instruction of the first report page includes:

acquiring a first tree structure relationship of the electronic report;

adjusting the first tree structure relationship according to the child node of the group where the starting point of the moving instruction is located and the child node of the group where the end point of the moving instruction is located to obtain a second tree structure relationship;

and displaying the second report page under the second report page group according to the second tree structure relationship.

The first tree structure relationship and the second tree structure relationship are contents displayed in the first interface, and corresponding data of the contents can be stored in the xml file.

Taking the diagram shown in fig. 13 as an example, when the leaf node "superheater tube" is selected and it is detected that the "superheater tube" is dragged from the "superheater itemized report" group to the "reheater itemized report" group, the "superheater tube" report page is moved from the "superheater itemized report" group to the "reheater itemized report" group, that is, the "superheater tube" report page is newly added to the "reheater itemized report" group, and the "superheater tube" report page of the "superheater itemized report" group is deleted.

In the embodiment of the present disclosure, the implementation manner of the second move instruction is similar to that of the first move instruction, and the position of the report page is moved according to the tree structure relationship, which is not described herein again.

214: and generating the same report page as the second report page in the fourth report page group under the third report page group in response to the copy instruction of the second report page.

The report page is copied similarly to the move in step S213, except for the instruction generation manner, and the original report page is not deleted after the copy.

Optionally, the method may further include:

in response to a report page export instruction, exporting the report page selected by the report page export instruction into an xml file;

and responding to the report page import instruction, and generating a corresponding report page in the report page group selected by the report page import instruction according to the xml file to be imported.

Wherein, the steps 209 to 214 are optional steps, and there is no sequence restriction among the

steps

209, 210, 212, 213, and 214.

In the embodiment of the disclosure, a plurality of independent report pages in a complex report are freely classified, organized in a dragging way and quickly located in a tree structure mode. The complexity of organizing and searching the structure of the report page is greatly reduced, and the time cost is saved. The data content of each individual report page is defined in a table form, and the characteristics of the page such as paper size, horizontal and vertical directions, margin, automatic paging, whether to calculate page number, and printing in a nested mode can be additionally set. Each data cell in the report page corresponds to each cell in the table, and the row and column position, the width and the height, the content identification (used when the analysis is used again), the font style, the frame style, the locking edition, the copy permission, the data type, the automatic filling formula and the like of the data cell can be recorded. Thus, a complex electronic report content can be formed from unstructured data into a structurable data file, thereby realizing report data electronization, report content accurate printing and report data reanalysis and reuse. One node may point to a single report page file or to a group classified for a plurality of report page files, and the level and number of nodes are not limited. The organization structure of the report is not continuous page by page, but forms a tree hierarchy, the composition structure of a plurality of pages is flexible, and the page sequence can be changed at any time. The scheme can rapidly organize, move, circulate and distribute the report page contents of a certain node and the subordinate child nodes thereof, and control the access rights of the report page and the data contents. All report pages of a certain tree node and child nodes thereof are quickly copied to generate a new tree node, and the issuing efficiency of large-scale complex electronic reports is greatly improved. And a plurality of external report page files can be classified and imported to a certain tree node, so that the report pages can be shared and reused conveniently. An unlimited number of parameters and variables are allowed to be customized for a certain tree node, so that the corresponding parameter values and variable values are automatically filled in a cell data area of a report page in the following process, and the automatic issuing capability of the report is improved.

Fig. 14 is a schematic structural diagram of an electronic report definition apparatus according to an embodiment of the present disclosure. Referring to fig. 14, the apparatus includes: an acquisition module 301 and a generation module 302.

The obtaining module 301 is configured to obtain a first parameter of an electronic report, where the first parameter includes a basic parameter, a global parameter, and a global variable of the electronic report;

the generating module 302 is configured to generate a root node of the electronic report in a first interface of the electronic report based on the first parameter, where the root node is a title of the electronic report; generating child nodes of the electronic report on a first interface of the electronic report in response to a new child node adding instruction under the root node, wherein the child nodes are grouped into report pages of the electronic report; generating a leaf node of the electronic report on a first interface of the electronic report in response to a new leaf node adding instruction under the child node, wherein the leaf node is a title of a report page of the electronic report;

the obtaining module 301 is further configured to obtain a second parameter of the leaf node, where the second parameter is used to indicate a local parameter, a local variable, and a structure of a report page of the electronic report;

the generating module 302 is further configured to generate a report page corresponding to the leaf node on a second interface of the electronic report based on the second parameter, where the first interface and the second interface of the electronic report are arranged side by side.

Optionally, the obtaining module 301 is configured to output a report attribute input interface in response to a newly-built electronic report instruction; and acquiring the first parameter input through the report attribute input interface.

Optionally, the obtaining module 301 is configured to output a report page attribute input interface in response to the leaf node attribute configuration instruction; and acquiring the second parameter input through the report page attribute input interface.

Optionally, the apparatus comprises: a processing module 303, configured to adjust a report page format in response to a report page format adjustment instruction; the report page format adjustment instruction is to indicate one of: adding rows or columns, deleting rows or columns, setting the height or width of rows or columns, merging cells, splitting cells.

Optionally, the processing module 303 is further configured to output a cell attribute setting interface in response to the cell attribute setting instruction; acquiring cell attribute parameters input through the cell attribute setting interface; changing the appearance of the cell or the data of the cell according to the cell attribute parameter.

Optionally, the data of the cells is obtained through an automatic formula;

Optionally, the processing module 303 is further configured to move the selected first report page from the first report page group to the second report page group in response to the first moving instruction of the first report page; moving the selected first report page in the first report page group to adjust the position of the first report page in response to the second movement instruction of the first report page; and generating the same report page as the second report page in the fourth report page group under the third report page group in response to the copy instruction of the second report page.

Optionally, the processing module 303 is configured to obtain a first tree structure relationship of the electronic report; adjusting the first tree structure relationship according to the child node of the group where the starting point of the moving instruction is located and the child node of the group where the end point of the moving instruction is located to obtain a second tree structure relationship; and displaying the second report page under the second report page group according to the second tree structure relationship.

It should be noted that: in the electronic report definition apparatus provided in the above embodiment, when defining a report, only the division of the above functional modules is used as an example, and in practical applications, the above function distribution may be completed by different functional modules according to needs, that is, the internal structure of the device is divided into different functional modules to complete all or part of the above described functions. In addition, the electronic report definition apparatus provided in the above embodiments and the electronic report definition method embodiments belong to the same concept, and specific implementation processes thereof are described in the method embodiments and are not described herein again.

Fig. 15 is a block diagram of an electronic device according to an embodiment of the present disclosure. Generally, an electronic device includes: a processor 401 and a memory 402.

Processor 401 may include one or more processing cores, such as a 4-core processor, an 8-core processor, or the like. The processor 401 may be implemented in at least one hardware form of a DSP (Digital Signal Processing), an FPGA (Field-Programmable Gate Array), and a PLA (Programmable Logic Array). The processor 401 may also include a main processor and a coprocessor, where the main processor is a processor for Processing data in an awake state, and is also called a Central Processing Unit (CPU); a coprocessor is a low power processor for processing data in a standby state.

Memory 402 may include one or more computer-readable storage media, which may be non-transitory. Memory 402 may also include high speed random access memory, as well as non-volatile memory, such as one or more magnetic disk storage devices, flash memory storage devices. In some embodiments, a non-transitory computer readable storage medium in memory 402 is used to store at least one instruction for execution by processor 401 to implement the electronic report definition method performed by a client or the electronic report definition method performed by a server provided by method embodiments herein.

It will be understood by those skilled in the art that all or part of the steps for implementing the above embodiments may be implemented by hardware, or may be implemented by a program instructing relevant hardware, where the program may be stored in a computer-readable storage medium, and the above-mentioned storage medium may be a read-only memory, a magnetic disk or an optical disk, etc.

The above description is intended to be exemplary only and not to limit the present disclosure, and any modification, equivalent replacement, or improvement made without departing from the spirit and scope of the present disclosure is to be considered as the same as the present disclosure.

Claims

1. A method of electronic report definition, wherein the electronic report includes a plurality of report pages, the method comprising:

acquiring first parameters of an electronic report, wherein the first parameters comprise basic parameters, global parameters and global variables of the electronic report, the basic parameters of the electronic report refer to parameters for defining basic characteristics of the electronic report, the global parameters and the global variables of the electronic report refer to parameters referred by a report page of the electronic report, and the basic parameters of the electronic report comprise: report name, report unique identification, report author, report version, report creation and modification time, report description, report catalog type, currently active report page identification, and report page quantity, the global parameters and global variables comprising: name of parameter/variable, parameter/variable value, data type of parameter/variable;

generating a child node of the electronic report on a first interface of the electronic report in response to a new child node adding instruction under the root node, wherein the child node is a report page group of the electronic report, and the report page group refers to a combination of report pages of the same type in the electronic report;

acquiring a second parameter of the leaf node, where the second parameter is used to indicate a local parameter, a local variable, and a structure of a report page of the electronic report, where the local parameter and the local variable of the report page refer to parameters and variables in the report page, and the structure of the report page includes: node name, node identification, father node identification, whether leaf nodes exist, page paper size, horizontal direction and longitudinal direction, page margin, whether automatic paging exists, whether page sleeving is performed, whether directory pages exist, whether page numbers are calculated, whether page continuation is performed, and data are defined by users;

generating a report page corresponding to the leaf node on a second interface of the electronic report based on the second parameter, wherein the first interface and the second interface of the electronic report are arranged side by side;

and moving the selected first report page in the first report page group in response to the second movement instruction of the first report page to adjust the position of the first report page.

2. The method of claim 1, further comprising:

3. The method of claim 1, wherein moving the selected first report page from the first report page group to the second report page group in response to the moving instruction of the first report page comprises:

acquiring a first tree structure relationship of the electronic report;

4. The method of any of claims 1 to 3, wherein obtaining the first parameter of the first interface of the electronic report comprises:

acquiring the first parameter input through the report attribute input interface;

the obtaining of the second parameter of the leaf node includes:

5. The method according to any one of claims 1 to 3, further comprising:

6. The method according to any one of claims 1 to 3, further comprising:

7. The method of claim 6, wherein the data of the cells is obtained by an automated formula;

8. An electronic report definition apparatus, wherein the electronic report includes a plurality of report pages, the apparatus comprising:

an obtaining module, configured to obtain first parameters of an electronic report, where the first parameters include basic parameters, global parameters, and global variables of the electronic report, the basic parameters of the electronic report refer to parameters for defining basic characteristics of the electronic report, and the global parameters and global variables of the electronic report refer to parameters referred to by a report page of the electronic report, and the basic parameters of the electronic report include: report name, report unique identification, report author, report version, report creation and modification time, report description, report catalog type, currently active report page identification, and report page quantity, the global parameters and global variables comprising: name of parameter/variable, parameter/variable value, data type of parameter/variable;

a generating module, configured to generate a root node of the electronic report on a first interface of the electronic report based on the first parameter, where the root node is a title of the electronic report; generating a child node of the electronic report on a first interface of the electronic report in response to a new child node adding instruction under the root node, wherein the child node is a report page group of the electronic report, and the report page group refers to a combination of report pages of the same type in the electronic report; generating a leaf node of the electronic report on a first interface of the electronic report in response to a new leaf node adding instruction under the child node, wherein the leaf node is a title of a report page of the electronic report;

the obtaining module is further configured to obtain a second parameter of the leaf node, where the second parameter is used to indicate a local parameter and a local variable of a report page of the electronic report, and a structure of the report page, where the local parameter and the local variable of the report page refer to parameters and variables in the report page, and the structure of the report page includes: node name, node identification, father node identification, whether leaf nodes exist, page paper size, horizontal direction and longitudinal direction, page margin, whether automatic paging exists, whether page sleeving is performed, whether directory pages exist, whether page numbers are calculated, whether page continuation is performed, and data are defined by users;

the generating module is further configured to generate a report page corresponding to the leaf node on a second interface of the electronic report based on the second parameter, where the first interface and the second interface of the electronic report are arranged side by side;

the processing module is used for responding to a first moving instruction of the first report page, and moving the selected first report page from the first report page group to the second report page group; and moving the selected first report page in the first report page group in response to the second movement instruction of the first report page to adjust the position of the first report page.

9. An electronic device, characterized in that the electronic device comprises a processor and a memory, the memory storing at least one program code, the program code being loaded and executed by the processor to implement the electronic report definition method according to any of the claims 1 to 7.

10. A computer-readable storage medium, having stored therein at least one program code, which is loaded and executed by a processor, to implement the electronic report definition method according to any of claims 1 to 7.