CN111444696B - Report form display and editing method and device - Google Patents
Report form display and editing method and device Download PDFInfo
- Publication number
- CN111444696B CN111444696B CN202010223220.6A CN202010223220A CN111444696B CN 111444696 B CN111444696 B CN 111444696B CN 202010223220 A CN202010223220 A CN 202010223220A CN 111444696 B CN111444696 B CN 111444696B
- Authority
- CN
- China
- Prior art keywords
- report
- data
- editing
- result
- display
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000012423 maintenance Methods 0.000 claims abstract description 59
- 238000012545 processing Methods 0.000 claims abstract description 9
- 238000009877 rendering Methods 0.000 claims description 37
- 230000004048 modification Effects 0.000 claims description 14
- 238000012986 modification Methods 0.000 claims description 14
- 238000004590 computer program Methods 0.000 claims description 13
- 238000012795 verification Methods 0.000 claims description 9
- 238000010586 diagram Methods 0.000 description 12
- 230000006870 function Effects 0.000 description 7
- 230000008569 process Effects 0.000 description 5
- 230000008859 change Effects 0.000 description 4
- 238000011161 development Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 4
- 238000013079 data visualisation Methods 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000004043 dyeing Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
Abstract
The invention provides a report form display and editing method and device, and relates to the field of data processing, wherein the method comprises the following steps: acquiring configuration information of a report; the configuration information is used for determining a display area, display rules and maintenance rules of the report; when a query instruction is received, generating a query result of a report according to the query instruction, the display area and the display rule, and sending the query result to the data display module so that the data display module displays the query result; and when receiving the editing instruction, editing the report according to the editing instruction and the maintenance rule to obtain an editing result of the report, and sending the editing result to the storage module so as to enable the storage module to store the editing result. According to the invention, the display area, the display rule and the maintenance rule can be set through the configuration information, so that the efficiency of developing the diversity report form at the front end is improved, the robustness of the program is improved, and if the subsequent requirement is changed, only the configuration information of the report form is required to be modified, and all relevant report form codes are not required to be modified.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a report display and editing method and device.
Background
With the development of big data, data visualization has become a focus of attention for enterprises and individuals, and report presentation is one of the most commonly used and effective ways of data visualization for banking systems. In order to support the display of various reports and the dynamic rendering of the form components, different codes are required to be developed for different types of reports by the front end and the background, so that the development efficiency is low. And for the same type of problem, if the subsequent requirement change exists, a plurality of report codes need to be modified, and the code robustness is poor.
Disclosure of Invention
The invention provides a report displaying and editing method and device, which can improve the efficiency of front-end development of various reports and facilitate the modification of report demand related information when demand change occurs.
In a first aspect, an embodiment of the present invention provides a report presentation and editing method, where the method includes: acquiring configuration information of a report; the configuration information is used for determining a display area, display rules and maintenance rules of the report; when a query instruction is received, generating a query result of the report according to the query instruction, the display area and the display rule, and sending the query result to a data display module so that the data display module displays the query result; when an editing instruction is received, editing the report according to the editing instruction and the maintenance rule to obtain an editing result of the report, and sending the editing result to a storage module so that the storage module stores the editing result;
The report is edited according to the editing instruction and the maintenance rule to obtain an editing result of the report, and the method comprises the following steps:
determining data to be edited according to the editing instruction;
Checking the data to be edited according to the maintenance rule;
and if the data to be edited passes the verification, editing the report according to the data to be edited, and obtaining the editing result of the report.
In a second aspect, an embodiment of the present invention further provides a report presentation and editing apparatus, where the apparatus includes: the configuration information module is used for acquiring the configuration information of the report; the configuration information is used for determining a display area, display rules and maintenance rules of the report; the data display module is used for generating a query result of the report according to the query instruction, the display area and the display rule when receiving the query instruction, and sending the query result to the data display module so that the data display module displays the query result; the data maintenance module is used for editing the report according to the editing instruction and the maintenance rule when receiving the editing instruction, so as to obtain the editing result of the report, and sending the editing result to the storage module so that the storage module stores the editing result;
the data maintenance module is specifically configured to:
determining data to be edited according to the editing instruction;
Checking the data to be edited according to the maintenance rule;
and if the data to be edited passes the verification, editing the report according to the data to be edited, and obtaining the editing result of the report.
In a third aspect, an embodiment of the present invention further provides a computer device, including a memory, and a processor, where the memory stores a computer program that can run on the processor, and when the processor executes the computer program, the method for displaying and editing a report is implemented.
In a fourth aspect, embodiments of the present invention also provide a computer readable medium having non-volatile program code executable by a processor, the program code causing the processor to perform the report presentation and editing method described above.
The embodiment of the invention has the following beneficial effects: the embodiment of the invention provides a report form display and editing scheme, which can determine the display area, display rules and maintenance rules of a report form by acquiring pre-stored report form configuration information; when a query instruction is received, generating a query result of a report according to the query instruction, the display area determined by the configuration information and the display rule determined by the configuration information, and then sending the query result to a data display module for display; when receiving the editing instruction, editing the report according to the editing instruction and the maintenance rule determined by the configuration information to obtain an editing result of the report, and then sending the editing result to the storage module for storage. According to the embodiment of the invention, the display area, the display rule and the maintenance rule can be set through the configuration information, so that the efficiency of developing the diversified report forms at the front end is improved, the robustness of the program is improved, and if the subsequent requirement is changed, only the configuration information of the report forms is required to be modified, and all relevant report form codes are not required to be modified.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
In order to make the above objects, features and advantages of the present invention more comprehensible, preferred embodiments accompanied with figures are described in detail below.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are needed in the description of the embodiments or the prior art will be briefly described, and it is obvious that the drawings in the description below are some embodiments of the present invention, and other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flowchart of a report presentation and editing method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a report presentation and editing method according to an embodiment of the present invention;
FIG. 3 is a block diagram of a report presentation and editing apparatus according to an embodiment of the present invention;
fig. 4 is a block diagram of a computer device according to an embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Currently, existing report presentation schemes do not take into account the following three points. First, the dynamic rendering of the form component, such as dynamically rendering a drop-down box according to configuration when modifying data with selectable options, to ensure that the data range is correct, does not take into account the user editing the report; secondly, data format verification is automatically carried out according to the configuration when a maintenance request is not submitted; thirdly, operations supported by the report under different application scenes are not considered to be different, for example, some reports only allow new operations, but other reports already determine the data range, and only allow modification and approval operations.
According to the report display and editing method and device provided by the embodiment of the invention, front-end developers develop report components according to the interfaces and configure a small amount of attribute information, so that different types of reports can be dynamically rendered.
For the sake of understanding the present embodiment, a report displaying and editing method disclosed in the present embodiment is first described in detail.
For ease of understanding, first, the terms involved are explained as follows:
front end: and running the web pages displayed to the user and browsed on browsers such as a PC end and a mobile end.
Back end (background): the logic function module corresponding to the front end is invisible to the user.
Form component: the usual components on the web page for interaction with the user mainly comprise an input box, a drop-down menu, a date selector and the like.
JSON (JavaScript Object Notation, JS object numbered musical notation): a lightweight data exchange format.
The embodiment of the invention provides a report form display and editing method, referring to a report form display and editing method flow chart shown in fig. 1, comprising the following steps:
Step S102, obtaining configuration information of a report.
In the embodiment of the invention, the configuration information is used for determining the display area, the display rule and the maintenance rule of the report. The display area refers to a position of the report needing to be displayed at the front end; the presentation rule refers to a specification of data for determining a visual effect presented by a report, for example, the presentation rule may be used to determine data such as a presentation format, a presentation color, and a presentation order of the report, and the maintenance rule is used to specify a modification maintenance requirement of the report.
In order to realize the function of the configuration information, a developer may configure the attribute information of the report in the background to obtain the configuration information. For example, a front end display column name, a back end column name, etc. may be configured for determining a display area; the display rule can be determined by configuration, front page display elements (such as an input box, a drop-down menu, a date selector and the like), the sequence of front display columns and the like; front end data formats (e.g., type and length of data), regions that allow modification, etc. may be configured for determining maintenance rules.
It should be further noted that some report attributes are related to a plurality of functional rules, for example, the front-end data format and the presentation rules are related to the maintenance rules. Therefore, the display and editing effects to be realized can be realized respectively or together by a plurality of kinds of data configured in advance in the configuration information.
In addition, it should be noted that, corresponding configuration information is provided for each report, so that when the configuration information is obtained, a display area, a display rule and a maintenance rule of the report corresponding to the configuration information can be obtained.
Step S104, when a query instruction is received, generating a query result of the report according to the query instruction, the display area and the display rule, and sending the query result to the data display module so that the data display module displays the query result.
In the embodiment of the invention, the report to be queried can be determined through the query instruction, the region to be displayed of the report to be queried can be determined according to the query instruction and the display region, the visual effect of the report to be displayed can be determined according to the query instruction and the display rule, so that the query result of the report is obtained, and the obtained query result is sent to the data display module so that the data display module displays the query result, wherein the data display module can be a browser of a PC end or a mobile end.
And S106, when receiving the editing instruction, editing the report according to the editing instruction and the maintenance rule to obtain an editing result of the report, and sending the editing result to the storage module so that the storage module stores the editing result.
In the embodiment of the invention, the report to be edited can be determined through the editing instruction, the area to be edited of the table to be edited and the related editing requirement can be determined according to the editing instruction and the maintenance rule, the report is edited according to the area and the requirement to obtain the editing result of the report, and then the editing result is sent to the storage module so that the storage module stores the editing result.
Considering that the query result of the report is generated according to the query instruction, the display area and the display rule in order to optimize the display effect, the method can be implemented as follows:
Determining report data according to the query instruction; rendering the header of the report and the report area where the report data are located according to the display area to obtain a rendering result; setting a display format and a display sequence of report data according to the display rule to obtain a setting result; and taking the rendering result and the setting result as query results of the report.
In the embodiment of the invention, the report data are data in the report to be queried, which are transmitted by the query instruction, and after the report data are acquired from the report according to the query instruction, the specific positions of the header of the report and the report area where the report data are located can be known after the display area is determined, so that the header of the report and the report area where the report data are located are rendered according to the display area, and different areas can be rendered into different effects so as to be convenient for a user to view. The display format and the display order in the report can be set according to the display rule, for example, the display order can be a sorting result obtained by sorting each data column according to the column names in the report, the setting result is obtained after the display format and the display order are determined, and the rendering result and the setting result are used as query results of the report.
For example, when a user queries report data on a front-end web page, the front-end queries attribute information of a report, stores the attribute information in the front-end, renders a header according to the attribute, queries report data information in the background, and renders a dyeing and finishing sheet report.
Considering that the report is edited according to the editing instruction and the maintenance rule in order to optimize the editing process, the editing result of the report is obtained, and the method can be implemented according to the following steps:
Determining data to be edited according to the editing instruction; checking the data to be edited according to the maintenance rule; and if the data to be edited passes the verification, the report is edited according to the data to be edited, and an editing result of the report is obtained.
In the embodiment of the invention, the data to be edited is data for maintaining the report transmitted according to the editing instruction, the maintenance rule can be used for limiting the editing of the report, for example, through the maintenance rule, the data at a certain position in the report can be limited to only modify any one of the first data content, the second data content or the third data content, if the data to be edited is the fourth data content according to the maintenance rule, the data to be edited cannot pass the verification, and if the data to be edited is any one of the first data content, the second data content or the third data content, the data to be edited passes the verification, and the report is maintained according to the data to be edited, so as to obtain the editing result of the report.
It should be noted that, the maintenance rule not only can limit the data to be edited from the data content, but also can limit the data to be edited from the data format, so as to meet various report maintenance requirements.
In order to improve the accuracy of the editing result, the report is edited according to the data to be edited, and the method can be implemented as follows:
Generating a hypertext markup language tag according to the configuration information; rendering the report according to the hypertext markup language tag to obtain an editing rendering result; and editing the report according to the data to be edited and the editing rendering result.
In the embodiment of the present invention, the data to be edited may be determined according to the maintenance rule in the configuration information, for example, if the data a in a certain row and a certain column is to be modified to data B, the data a and the data B are the data to be edited. To delete data C in a certain row and a certain column, C is the data to be edited. If the data D is newly added in a certain row and a certain column, D is the data to be edited. The setting of the display effect of the report area corresponding to the data to be edited can be realized by presetting the display area and the display rule related data in the configuration information, for example, the rendering color, the rendering area, the rendering sequence, the rendering time and the like can be set. And then generating HTML (HyperText Markup Language hypertext markup language) labels based on the data to be edited and attribute information of the report corresponding to the data to be edited, such as the report region, and dynamically rendering the report region in the editing process, and editing the report according to the data to be edited and the editing rendering result, so that the accuracy of the editing result can be improved.
For example, in a specific implementation, when a user maintains report data on a front-end webpage, the front-end dynamically generates an HTML tag, i.e. an automatic rendering form component, according to the saved report attribute information. After the user maintains information in the form component according to the rendering result, clicking and submitting, the front end verifies the correctness of the data format according to the report attribute information, if the data format is correct, submitting the data to the background, otherwise, prompting the user to input errors.
Considering that the report is edited in order to realize different report editing requirements, the method can be implemented according to the following steps:
and processing the report by adding data, deleting data and/or modifying data.
In the embodiment of the invention, the report can be edited by adding data to the report, deleting data in the report, modifying data in the report, or executing one or more of the above operations.
The implementation of the method is described in a specific embodiment.
1. Pre-generating configuration information: the developer configures relevant attributes of the report form (namely front-end and back-end configuration information interfaces) in the background, and information to be configured is shown in tables 1 and 2, wherein the information comprises column attribute configuration information and field value information:
1) Column attribute configuration information table: COLUMN_INFO;
Table 12) field value table (mainly designed for drop-down boxes): COLUMN_DECODE.
TABLE 2
2. When the developer multiplexes the front-end report components, the developer needs to input parameters to specify maintenance operations supported by the corresponding report, and provide a background URL (Uniform Resource Locator, the same resource positioning system) for the support operations. Operations supported by the front-end component may include: adding a piece of data, modifying a piece of data, deleting one or more pieces of data, approving one or more pieces of data, and supporting extended maintenance operations by an open interface. In addition, the approval operation is used as a common operation of the bank report, and has relevance with the modification and deletion operation, namely, the lower-level operator is not allowed to modify and delete any more for the records passed by the approval of the upper-level operator.
3. And inquiring report data.
1) The front end inquires the configuration parameters of the report form from the background according to the TABLE_ID, the background returns the configuration parameters of the Json format, the form is { colInfo: [ { key1: value1, … }, … ], decodeInfo: [ { key1: value1, … }, … }, the front end analyzes and stores the data returned by the background, and then the header information is dynamically generated according to COL_INDEX (column sequence number) and COL_DISPLAY (front end DISPLAY column name).
2) The front end calls a background report data query service to query report data, the background returns the report data in the JSON format (keys and configured COL_NAME are consistent), and the front end places the data in a corresponding COL_NAME (background list NAME) column according to the keys.
3) The front end judges whether the data are approved or not according to the modified FLAG, the DEFAULT VALUE of the field and the current VALUE of the data in the cells, if so, the background color of the data is set to be gray, otherwise, the background color is set to be normal background color.
4. And modifying report data.
1) The user clicks on a cell of the report.
2) The front end judges whether the column allows modification according to the stored configuration information read_only, pk_flag (whether the main key does not allow modification), modify_flag (modification FLAG bit). If not, prompting the user that the column is not allowed to be modified, otherwise, dynamically generating an html label according to display_TYPE (front page element DISPLAY format), SUB_TYPE (subtype), COL_CODE (field value CODE) and COL_DECODE (field value meaning), and taking the current value of the source cell as the value of the label.
3) The user modifies the data and clicks on commit.
4) The front end automatically checks whether the user input meets the requirements according to the fields of COL_TYPE (field attribute), COL_LENGTH (field maximum LENGTH), FORMAT_DATE (DATE FORMAT) and the like, if not, the front end prompts an error, otherwise, the front end submits the data to the background.
5. And a step of adding report data.
1) The user clicks the new button.
2) The front end dynamically generates an html tag according to display_type (front end page element DISPLAY format), sub_type (subtype), col_code (field VALUE CODE), col_decode (field VALUE meaning), and takes default_value (field DEFAULT VALUE) as the VALUE of the tag.
3) The user enters data and clicks on the submission.
4) The front end automatically checks whether the user input meets the requirements according to the fields of PK_FLAG (whether the primary key is needed to be input), COL_TYPE (field attribute), COL_LENGTH (field maximum LENGTH), FORMAT_DATE (DATE FORMAT) and the like, if not, the user input prompts an error, otherwise, the data is submitted to the background.
6. And (5) data approval.
1) The user selects the data to be approved and clicks on the approval.
2) The background modifies the approval status of these data.
In the embodiment of the invention, the requirement change can be met by modifying the configuration information, however, when a relatively complex requirement change is met, the front-end report component may also need to be modified. For example, there may be cases where the types of HTML elements supporting rendering need to be added, or there may be cases where the mechanism for handling trigger events changes (e.g., the response actions when a button is clicked changes, the actual scene may be that the approval button is clicked, the approval status of the selected record changes, the subordinate operator may not modify the approved data, and the subordinate operator may be required to modify the approved data after the demand changes). The more complex requirements can be satisfied by combining the modification of the reporting component and the modification of the configuration information.
In addition, an open interface can be reserved in the report component, so that the extended maintenance operation can be supported through the reserved open interface.
The embodiment of the invention provides a report displaying and editing method and device, which improve the efficiency of front-end development of various reports, enable front-end developers to dynamically render the report by adding a small amount of configuration information, realize the dynamic display of different types of report information at the front end and support various online maintenance report functions. In addition, the invention improves the robustness of the program, and if the subsequent requirement is changed, only configuration information or front-end report components are required to be modified, and all relevant report codes are not required to be modified.
The embodiment of the invention also provides a report display and editing device, referring to the structural block diagram of the report display and editing device shown in fig. 3, the device comprises:
A configuration information module 71, configured to obtain configuration information of a report; the configuration information is used for determining a display area, display rules and maintenance rules of the report; the data display module 72 is configured to generate a query result of the report according to the query instruction, the display area and the display rule, and send the query result to the data display module, so that the data display module displays the query result; and the data maintenance module 73 is used for editing the report according to the editing instruction and the maintenance rule when receiving the editing instruction, obtaining the editing result of the report, and sending the editing result to the storage module so that the storage module stores the editing result.
In one embodiment, the data presentation module is specifically configured to: determining report data according to the query instruction; rendering the header of the report and the report area where the report data are located according to the display area to obtain a rendering result; setting a display format and a display sequence of report data according to the display rule to obtain a setting result; and taking the rendering result and the setting result as query results of the report.
In one embodiment, the data maintenance module is specifically configured to: determining data to be edited according to the editing instruction; checking the data to be edited according to the maintenance rule; and if the data to be edited passes the verification, the report is edited according to the data to be edited, and an editing result of the report is obtained.
In one embodiment, the data maintenance module is specifically configured to: generating a hypertext markup language tag according to the configuration information; rendering the report according to the hypertext markup language tag to obtain an editing rendering result; and editing the report according to the data to be edited and the editing rendering result.
In one embodiment, the data maintenance module is specifically configured to: and processing the report by adding data, deleting data and/or modifying data.
Referring to a schematic diagram of a report presentation and editing method implementation flow shown in fig. 2, the scheme can be implemented by cooperation of a front end and a background.
The user inquires report data on the webpage, and the front-end configuration information module invokes the background configuration information inquiry service to inquire the configuration information of the corresponding report and store the configuration information. The data display module renders the header according to the configuration information, and then invokes the background report data query service to query data and render the data.
The user maintains (adds/deletes) report data on the webpage, the front-end report component dynamically renders the report component according to the stored configuration information, and after user input is completed and the user clicks and submits, the front-end report component checks the data format according to the stored configuration information, and if the format is correct, the back-end report data maintenance service is invoked to newly add or modify data.
The user approves report data on the webpage, and the front-end data maintenance module invokes the background report data approval service to complete updating of the data approval state. When the data is in the approved state, no modification operation is allowed.
The embodiment of the present invention further provides a computer device, referring to the schematic block diagram of the structure of the computer device shown in fig. 4, where the computer device includes a memory 81 and a processor 82, and the memory stores a computer program that can be run on the processor, and when the processor executes the computer program, the processor implements the steps of any of the methods described above.
It will be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the computer device described above may refer to the corresponding process in the foregoing method embodiment, which is not repeated herein.
Embodiments of the present invention also provide a computer readable medium having non-volatile program code executable by a processor, the program code causing the processor to perform the steps of any of the methods described above.
It will be appreciated by those skilled in the art that 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 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.
Finally, it should be noted that: the above examples are only specific embodiments of the present invention, and are not intended to limit the scope of the present invention, but it should be understood by those skilled in the art that the present invention is not limited thereto, and that the present invention is described in detail with reference to the foregoing examples: any person skilled in the art may modify or easily conceive of the technical solution described in the foregoing embodiments, or perform equivalent substitution of some of the technical features, while remaining within the technical scope of the present disclosure; such modifications, changes or substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (7)
1. A report form displaying and editing method is characterized by comprising the following steps:
Acquiring configuration information of a report; the configuration information is used for determining a display area, display rules and maintenance rules of the report;
When a query instruction is received, generating a query result of the report according to the query instruction, the display area and the display rule, and sending the query result to a data display module so that the data display module displays the query result;
When an editing instruction is received, editing the report according to the editing instruction and the maintenance rule to obtain an editing result of the report, and sending the editing result to a storage module so that the storage module stores the editing result;
The report is edited according to the editing instruction and the maintenance rule to obtain an editing result of the report, and the method comprises the following steps:
determining data to be edited according to the editing instruction;
Checking the data to be edited according to the maintenance rule; the maintenance rule is used for prescribing the modification maintenance requirement of the report, and limiting the editing of the report;
if the data to be edited passes the verification, the report is edited according to the data to be edited, and an editing result of the report is obtained;
wherein editing the report according to the data to be edited comprises:
Generating a hypertext markup language tag according to the configuration information;
rendering a report according to the hypertext markup language tag to obtain an editing rendering result;
And editing the report according to the data to be edited and the editing rendering result.
2. The method of claim 1, wherein generating the query result of the report according to the query instruction, the presentation area, and the presentation rule comprises:
determining report data according to the query instruction;
rendering the header of the report and the report area where the report data are located according to the display area to obtain a rendering result;
setting a display format and a display sequence of the report data according to the display rule to obtain a setting result;
And taking the rendering result and the setting result as query results of the report.
3. The method according to claim 1 or 2, wherein editing the report comprises:
and processing the report by adding data, deleting data and/or modifying data.
4. The report display and editing device is characterized by comprising:
the configuration information module is used for acquiring the configuration information of the report; the configuration information is used for determining a display area, display rules and maintenance rules of the report;
The data display module is used for generating a query result of the report according to the query instruction, the display area and the display rule when receiving the query instruction, and sending the query result to the data display module so that the data display module displays the query result;
The data maintenance module is used for editing the report according to the editing instruction and the maintenance rule when receiving the editing instruction, so as to obtain the editing result of the report, and sending the editing result to the storage module so that the storage module stores the editing result;
the data maintenance module is specifically configured to:
determining data to be edited according to the editing instruction;
Checking the data to be edited according to the maintenance rule; the maintenance rule is used for prescribing the modification maintenance requirement of the report, and limiting the editing of the report;
if the data to be edited passes the verification, the report is edited according to the data to be edited, and an editing result of the report is obtained;
The data maintenance module is specifically used for: generating a hypertext markup language tag according to the configuration information; rendering the report according to the hypertext markup language tag to obtain an editing rendering result; and editing the report according to the data to be edited and the editing rendering result.
5. The device according to claim 4, wherein the data presentation module is specifically configured to:
determining report data according to the query instruction;
rendering the header of the report and the report area where the report data are located according to the display area to obtain a rendering result;
setting a display format and a display sequence of the report data according to the display rule to obtain a setting result;
And taking the rendering result and the setting result as query results of the report.
6. A computer device comprising a memory, a processor, the memory having stored therein a computer program executable on the processor, characterized in that the processor, when executing the computer program, implements the steps of the method of any of the preceding claims 1 to 3.
7. A computer readable medium having non-volatile program code executable by a processor, the program code causing the processor to perform the method of any one of the preceding claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010223220.6A CN111444696B (en) | 2020-03-26 | 2020-03-26 | Report form display and editing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010223220.6A CN111444696B (en) | 2020-03-26 | 2020-03-26 | Report form display and editing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111444696A CN111444696A (en) | 2020-07-24 |
| CN111444696B true CN111444696B (en) | 2024-04-19 |
Family
ID=71652512
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010223220.6A Active CN111444696B (en) | 2020-03-26 | 2020-03-26 | Report form display and editing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111444696B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112183041A (en) * | 2020-09-28 | 2021-01-05 | 建信金融科技有限责任公司 | Report form adjusting method, device, equipment and storage medium based on indexes |
| CN112631481A (en) * | 2020-12-30 | 2021-04-09 | 航天信息软件技术有限公司 | Interaction method and system under editable list |
| CN113157754B (en) * | 2021-03-22 | 2023-01-31 | 招银云创信息技术有限公司 | Method, device and equipment for displaying flow form data and storage medium |
| CN113741897A (en) * | 2021-09-06 | 2021-12-03 | 北京字节跳动网络技术有限公司 | Question list generation method, device, equipment and storage medium |
| CN114546205B (en) * | 2022-04-26 | 2022-07-15 | 北京金堤科技有限公司 | Method and device for editing display information |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN105740219A (en) * | 2016-01-29 | 2016-07-06 | 浪潮软件集团有限公司 | Report self-defining method and device |
| CN109325053A (en) * | 2018-06-29 | 2019-02-12 | 平安科技（深圳）有限公司 | Data processing method, device and the computer readable storage medium of reporting system |
| CN109710237A (en) * | 2019-01-10 | 2019-05-03 | 厦门商集网络科技有限责任公司 | A kind of online modification method of calibration and equipment based on customized two-dimentional report |
| CN110222321A (en) * | 2019-04-16 | 2019-09-10 | 中国平安人寿保险股份有限公司 | Report form generation method, device, computer installation and computer readable storage medium |
| CN110473080A (en) * | 2019-07-30 | 2019-11-19 | 阿里巴巴集团控股有限公司 | A kind of report processing method, device and computer equipment |
| CN110597851A (en) * | 2019-09-20 | 2019-12-20 | 四川长虹电器股份有限公司 | Big data based data processing and report display method |
| CN110647573A (en) * | 2019-09-17 | 2020-01-03 | 泰华智慧产业集团股份有限公司 | Chart visual editing method and system based on database technology |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB0905953D0 (en) * | 2009-04-06 | 2009-05-20 | Bowling Anthony | Document editing method |
-
2020
- 2020-03-26 CN CN202010223220.6A patent/CN111444696B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN105740219A (en) * | 2016-01-29 | 2016-07-06 | 浪潮软件集团有限公司 | Report self-defining method and device |
| CN109325053A (en) * | 2018-06-29 | 2019-02-12 | 平安科技（深圳）有限公司 | Data processing method, device and the computer readable storage medium of reporting system |
| CN109710237A (en) * | 2019-01-10 | 2019-05-03 | 厦门商集网络科技有限责任公司 | A kind of online modification method of calibration and equipment based on customized two-dimentional report |
| CN110222321A (en) * | 2019-04-16 | 2019-09-10 | 中国平安人寿保险股份有限公司 | Report form generation method, device, computer installation and computer readable storage medium |
| CN110473080A (en) * | 2019-07-30 | 2019-11-19 | 阿里巴巴集团控股有限公司 | A kind of report processing method, device and computer equipment |
| CN110647573A (en) * | 2019-09-17 | 2020-01-03 | 泰华智慧产业集团股份有限公司 | Chart visual editing method and system based on database technology |
| CN110597851A (en) * | 2019-09-20 | 2019-12-20 | 四川长虹电器股份有限公司 | Big data based data processing and report display method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111444696A (en) | 2020-07-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111444696B (en) | Report form display and editing method and device | |
| US20240086627A1 (en) | Electronic form automation | |
| US9026898B2 (en) | System and method for managing web-based forms and dynamic content of website | |
| US9098481B2 (en) | Increasing accuracy in determining purpose of fields in forms | |
| KR101255506B1 (en) | Data-driven actions for network forms | |
| US7752536B2 (en) | Designating, setting and discovering parameters for spreadsheet documents | |
| US7278096B2 (en) | Method and apparatus for declarative updating of self-describing, structured documents | |
| US8954950B2 (en) | Web portal application customization method and system using profiles | |
| JP7316349B2 (en) | Customizable enterprise automation test framework | |
| US7392510B1 (en) | System for tracking and providing access to information about server components invoked during the dynamic generation of web pages | |
| US20160124914A1 (en) | Page Processing for Mobile App | |
| US20100131869A1 (en) | Technology for generating service program | |
| US20140237341A1 (en) | System and method for creating integrated web form and database applications | |
| US8838627B2 (en) | Systems and methods for providing template based output management | |
| US20070214422A1 (en) | Framework for implementing skins into a portal server | |
| CN111259303A (en) | System and method for automatically generating front-end page of WEB information system | |
| CN108762743B (en) | Data table operation code generation method and device | |
| US9235561B2 (en) | Contextual report element mapping to web service input parameter | |
| CN108268525A (en) | A kind of report implementation method and device based on Excel template | |
| WO2001050234A1 (en) | A method and system for modeling data | |
| US9826027B2 (en) | User interfaces generated by a workflow engine | |
| US20160292143A1 (en) | System and method for automated online wizard generation | |
| US20110271184A1 (en) | Client application and web page integration | |
| US20200026802A1 (en) | Image quality independent searching of screenshots of web content | |
| US20160012551A1 (en) | Apparatus and Application Server for Providing a Service to a User |
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 |