CN117094300A - Report data generation method and device, electronic equipment and storage medium - Google Patents
Report data generation method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN117094300A CN117094300A CN202311337446.9A CN202311337446A CN117094300A CN 117094300 A CN117094300 A CN 117094300A CN 202311337446 A CN202311337446 A CN 202311337446A CN 117094300 A CN117094300 A CN 117094300A
- Authority
- CN
- China
- Prior art keywords
- configuration
- effect display
- area
- data
- display area
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 59
- 238000003860 storage Methods 0.000 title claims abstract description 16
- 230000000694 effects Effects 0.000 claims abstract description 160
- 238000007639 printing Methods 0.000 claims description 4
- 230000001960 triggered effect Effects 0.000 claims description 4
- 238000012795 verification Methods 0.000 claims description 4
- 238000004590 computer program Methods 0.000 claims description 2
- 230000008878 coupling Effects 0.000 abstract description 10
- 238000010168 coupling process Methods 0.000 abstract description 10
- 238000005859 coupling reaction Methods 0.000 abstract description 10
- 230000004048 modification Effects 0.000 abstract description 6
- 238000012986 modification Methods 0.000 abstract description 6
- 238000005516 engineering process Methods 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 9
- 230000008859 change Effects 0.000 description 4
- 238000011161 development Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 238000001228 spectrum Methods 0.000 description 4
- 238000003780 insertion Methods 0.000 description 3
- 230000037431 insertion Effects 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 230000000717 retained effect Effects 0.000 description 1
- 230000000630 rising effect Effects 0.000 description 1
- 238000009517 secondary packaging Methods 0.000 description 1
- 238000007711 solidification Methods 0.000 description 1
- 230000008023 solidification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/04817—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance using icons
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/0486—Drag-and-drop
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Human Computer Interaction (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses a report data generation method, a report data generation device, electronic equipment and a storage medium, and relates to the internet application technology. The method comprises the following steps: receiving a drag operation of a user on a basic element icon in a basic data area, wherein the termination position of the drag operation is an effect display area; outputting basic elements in the effect display area; acquiring configuration parameters of the basic elements, and displaying the configuration parameters in a data configuration area; determining a target parameter value of the configuration parameter according to the configuration operation of a user on the configuration parameter in the data configuration area; and generating a report or a template according to the target parameter values of the basic elements in the effect display area. The quick configuration of the basic elements is realized through the editing operation of the configuration parameters, the code programming is not needed, the operation of a user is simplified, and the usability is improved. The user can complete report editing through simple operation of dragging or configuration parameter modification, the user does not need to edit codes, and the coupling between the codes and the report is reduced.
Description
Technical Field
The present invention relates to internet application technologies, and in particular, to a method and apparatus for generating report data, an electronic device, and a storage medium.
Background
With popularization and commercialization of the internet, internet office has become a major way of daily office work. For a value added service, if the service data of the value added service needs to be exported, a project report needs to be formed.
At present, a programmer is required to edit the project report in a code editing mode, the coupling degree of the code and the report is high, more convenient report production is realized, and the problem that the coupling degree of the code and report generation is reduced is to be solved urgently.
Disclosure of Invention
The invention provides a report data generation method, a report data generation device, electronic equipment and a storage medium, which are used for improving report making convenience, improving usability and reducing coupling degree of codes and reports.
In a first aspect, the present invention provides a report data generating method, including:
receiving a drag operation of a user on a basic element icon in a basic data area, wherein the termination position of the drag operation is an effect display area; outputting basic elements in the effect display area;
acquiring configuration parameters of the basic elements, and displaying the configuration parameters in a data configuration area;
Determining a target parameter value of the configuration parameter according to the configuration operation of a user on the configuration parameter in the data configuration area;
and generating a report or a template according to the target parameter values of the basic elements in the effect display area.
In a second aspect, the present invention further provides a report data generating device, including:
the basic element icon dragging module is used for receiving the dragging operation of a user on the basic element icon in the basic data area, and the ending position of the dragging operation is an effect display area; outputting basic elements in the effect display area;
the configuration parameter display module is used for acquiring the configuration parameters of the basic elements and displaying the configuration parameters in a data configuration area;
the target parameter determining module is used for determining a target parameter value of the configuration parameter according to the configuration operation of a user on the configuration parameter in the data configuration area;
and the generating module is used for generating a report or a template according to the target parameter values of the basic elements in the effect display area.
In a third aspect, the present invention further provides a computer device, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor, where the processor implements a method for generating report data according to the embodiment of the present invention when the processor executes the program.
In a fourth aspect, embodiments of the present invention also provide a storage medium containing computer-executable instructions, which when executed by a computer processor, are configured to perform a method of generating report data as shown in the embodiments of the present invention.
According to the report data generation method, the drag operation of a user on the basic element icon in the basic data area is received, and the termination position of the drag operation is an effect display area; outputting basic elements in the effect display area; acquiring configuration parameters of the basic elements, and displaying the configuration parameters in a data configuration area; determining a target parameter value of the configuration parameter according to the configuration operation of a user on the configuration parameter in the data configuration area; and generating a report or a template according to the target parameter values of the basic elements in the effect display area. Compared with the problems of high coupling between codes and reports and long development period caused by manual editing of report codes at present, the technical scheme provided by the invention can output the basic elements forming the report in the effect display area, and a user can drag the basic elements to the effect display area in a dragging mode, so that the quick configuration of the basic elements is realized through the editing operation of configuration parameters, the code programming is not needed, the user operation is simplified, and the usability is improved. According to the technical scheme provided by the invention, the user can complete report editing through simple operation of dragging or parameter configuration modification, the user is not required to edit codes, and the coupling between the codes and the report is reduced.
Drawings
FIG. 1 is a flowchart of a report data generating method according to a first embodiment of the present invention;
FIG. 2 is a schematic illustration of an interface in accordance with a first embodiment of the present invention;
FIG. 3 is a flowchart of a report data generating method in a second embodiment of the present invention;
FIG. 4 is a schematic diagram showing the variation of the effect display area according to the second embodiment of the present invention;
FIG. 5 is a flowchart of a report data generating method in a third embodiment of the present invention;
FIG. 6 is a flowchart of a report data generating method in a fourth embodiment of the present invention;
fig. 7 is a schematic structural diagram of a report data generating device in a sixth embodiment of the present invention;
fig. 8 is a schematic structural diagram of a computer device in a seventh embodiment of the present invention.
Detailed Description
The invention is described in further detail below with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting thereof. It should be further noted that, for convenience of description, only some, but not all of the structures related to the present invention are shown in the drawings.
Example 1
Fig. 1 is a flowchart of a report data generating method according to an embodiment of the present invention, where the method may be applied to a case of automatically generating a report, and the method may be performed by an electronic device for providing report generation or report template editing for a user, and the electronic device may be a server or a computer device, and specifically includes the following steps:
Step 101, receiving a drag operation of a user on a basic element icon in a basic data area, wherein the termination position of the drag operation is an effect display area; and outputting basic elements in the effect display area.
Fig. 2 is a schematic diagram of an interface according to a first embodiment of the present invention, which includes three areas, namely a base data area, an effect display area, and a data configuration area. The base data area includes a base element area. A plurality of basic element icons are output in the basic element area. Each base element icon corresponds to the structural data of one base element.
And the user can drag the basic element icon from the basic data area to the effect display area by carrying out drag operation on the basic element icon through a mouse or a touch screen. And when the user finishes the drag operation, obtaining the structured data corresponding to the basic elements, determining the output data displayed in the effect display area according to the structured data, and outputting the output data in the effect display area.
Illustratively, the user drags the icon of the basic element a to the effect display area, the basic element a is displayed in the effect display area, and the input boxes of the configuration parameter a, the configuration parameter b and the configuration parameter c contained in the basic element a are displayed in the data configuration area.
Step 102, acquiring configuration parameters of the basic elements, and displaying the configuration parameters in a data configuration area.
The structured data of the base element includes a plurality of configuration parameters of the base element that are open for configuration by a user. The structured data of the base element also comprises hidden parameters which are not configured by the open user, and the hidden parameters are not displayed in the data configuration area.
And when the user drags the basic element, obtaining the structured data of the basic element. Configuration parameters are determined from the structured data. And outputting a plurality of configuration parameters opened for configuration by a user in the data configuration area. Different base element openings allow for different configuration parameters for user configuration. The display mode can be a configuration parameter title and an input box. Such as configuration parameters titled "width", "height", "x-axis field", "y-axis field", etc.
Optionally, accessing a server to obtain project information according to the interface parameters; and outputting a basic element for representing the project information in an effect display area according to the project information. The interface parameters are used to connect to a data source to provide data input for the base element. For example, the base element is a histogram, the interface parameters are database addresses, and the x-axis field and the y-axis field may be used to represent specific fields provided by the acquisition database. By configuring interface parameters, x-axis fields and y-axis fields of the histogram, corresponding data can be read from the database, and the histogram matched with the content of the corresponding fields in the database can be drawn according to the data.
Step 103, determining a target parameter value of the configuration parameter according to the configuration operation of the user on the configuration parameter in the data configuration area.
And the user performs configuration operation according to the configuration parameters output in the data configuration area. The configuration operation may be a user entering specific content of configuration parameters in an input box. The specific content can be numerical values, characters and the like. After the user clicks the save button, the specific content input by the user is determined as the target parameter value of the configuration parameter.
Further, after determining the target parameter value of the configuration parameter according to the configuration operation of the user on the configuration parameter in the data configuration area, the method further comprises:
and adjusting and outputting the basic element content in real time according to the target parameter value in the effect display area.
The predetermined number of clock cycles may be used as update cycles, each update cycle determining a target parameter value according to the content in the input box, and generating the base element content according to the target parameter. The predetermined number of clock cycles may be one or more clock cycles.
The basic element content is output in the effect display area, and a more visual basic element configuration effect can be provided for a user by adjusting the output basic element content in real time, so that the configuration efficiency is improved.
And 104, generating a report or a template according to the target parameter values of the basic elements in the effect display area.
And editing the basic elements and the configuration parameters of the basic elements in the effect display area according to the requirements by a user. And after the configuration is completed, generating a report or a template according to the target parameter values of the basic elements configured by the user.
Optionally, the generating a report or a template according to the target parameter values of the base elements in the effect display area may be implemented as:
determining template structural data according to target parameter values of basic elements in the effect display area; or respectively printing the basic elements in the effect display area as image data; and generating a report according to the image data.
If the template is stored, converting the target parameter value of the basic element into template structural data, and storing the template structural data. When used again, the templates may be displayed in the effects presentation area according to the template structured data.
If saved as a report, the report content needs to be fixed. For example, a report is a statistical report for a certain index of a certain year. If only structured data is retained, the report content is changed due to the update of the data corresponding to the interface. Therefore, in order to change the mode structured data through the data called by the interface, the basic elements in the effect display area are respectively printed as image data; and generating a report according to the image data so as to ensure the stability of report content.
According to the report data generation method provided by the embodiment of the invention, the drag operation of a user on the basic element icon in the basic data area is received, and the termination position of the drag operation is an effect display area; outputting basic elements in the effect display area; acquiring configuration parameters of the basic elements, and displaying the configuration parameters in a data configuration area; determining a target parameter value of the configuration parameter according to the configuration operation of a user on the configuration parameter in the data configuration area; and generating a report or a template according to the target parameter values of the basic elements in the effect display area. Compared with the problems of high coupling between codes and reports and long development period caused by manual editing of report codes at present, the technical scheme provided by the invention can output the basic elements forming the report in the effect display area, and a user can drag the basic elements to the effect display area in a dragging mode, so that the quick configuration of the basic elements is realized through the editing operation of configuration parameters, the code programming is not needed, the user operation is simplified, and the usability is improved. According to the technical scheme provided by the invention, the user can complete report editing through simple operation of dragging or parameter configuration modification, the user is not required to edit codes, and the coupling between the codes and the report is reduced.
Example two
Fig. 3 is a flowchart of a report data generating method according to the second embodiment of the present invention, and as a further explanation of the foregoing embodiment, a template may be preset with preset basic elements. The method specifically comprises the following steps:
step 201, receiving a target template selected by a user in a template area.
The base data area includes not only the base element area but also the template area. And a plurality of template labels are displayed in the template area, each end class label corresponds to one template, and the template comprises a plurality of base elements of the threshold value.
The user may select a target template in the template area and drag a label of the target template to the effect presentation area.
Step 202, obtaining preset basic elements in the target template.
And when the drag operation of the label of the target template is detected, acquiring the structured data of the target template, and displaying the threshold basic element in the effect display area according to the structured data.
And 203, outputting the preset basic elements in an extended effect display area, wherein the area of the extended effect display area is larger than that of the effect display area.
Optionally, in the embodiment of the present invention, after the user selects the template, the threshold base element included in the template is displayed in the extended effect display area.
Further, after outputting the preset basic element in the effect display area, the method further comprises the following steps:
step 204, responding to the configuration button of the preset basic element triggered by the user in the expansion effect display area.
Step 205, reducing the area of the extended effect display area to the effect display area.
Each preset base element includes a configuration button. Fig. 4 is a schematic diagram showing the change of the effect display area according to the embodiment of the invention. After the user clicks the configuration button, the area of the extended effect display area is reduced to the effect display area. The reduced area is used as a data configuration area.
And 206, displaying a data configuration area, and outputting configuration parameters of the preset basic elements in the data configuration area.
Step 207, receiving a drag operation of a user on a basic element icon in a basic data area, wherein the termination position of the drag operation is an effect display area; and outputting basic elements in the effect display area.
Step 208, obtaining the configuration parameters of the basic elements, and displaying the configuration parameters in a data configuration area.
Step 209, determining a target parameter value of the configuration parameter according to the configuration operation of the user on the configuration parameter in the data configuration area.
And 210, generating a report or a template according to the target parameter values of the basic elements in the effect display area.
The report data generation method provided by the embodiment of the invention can pre-configure the threshold basic elements in the target template, and avoid the user from adding the basic elements on a zero basis in the blank template. The target templates provided for different scenes can be different and are suitable for different use scenes. And a template editing foundation is provided for users in different scenes, so that the user operation is simplified. In addition, by means of shrinking and expanding the effect display area, screen space is effectively utilized, and the utilization rate of the screen space is improved.
Example III
Fig. 5 is a flowchart of a report data generating method according to a third embodiment of the present invention, which is used as a further explanation of the foregoing embodiment, and specifically includes:
step 301, receiving a drag operation of a user on a basic element icon in a basic data area, wherein the termination position of the drag operation is an effect display area; and outputting basic elements in the effect display area.
And 302, receiving a drag operation of a user on the basic element in the effect display area.
And the starting point and the ending point of the drag operation executed by the user on the basic element in the effect display area are both positioned in the effect display area.
And step 303, determining the position of the basic element in the effect display area according to the drag operation.
And determining the position of the basic element in the effect display area according to the terminal position of the drag operation. The location information is stored into hidden parameters of the base element.
Step 304, obtaining configuration parameters of the basic elements, and displaying the configuration parameters in a data configuration area.
Step 305, determining a target parameter value of the configuration parameter according to the configuration operation of the user on the configuration parameter in the data configuration area.
And 306, generating a report or a template according to the positions of the basic elements in the effect display area and the target parameter values.
The report data generation method provided by the embodiment of the invention can provide the dragging function of the basic elements for the user in the effect display area, and the user can change the position relationship among the basic components of the set by dragging, so that the usability is improved.
Example IV
Fig. 6 is a flowchart of a report data generating method according to a fourth embodiment of the present invention, as a further explanation of the foregoing embodiment, the method specifically includes:
step 401, receiving a drag operation of a user on a basic element icon in a basic data area, wherein the termination position of the drag operation is an effect display area; and outputting basic elements in the effect display area.
Step 402, obtaining configuration parameters of the basic elements, and displaying the configuration parameters in a data configuration area.
Step 403, receiving configuration parameters output by the user on the configuration parameters in the data configuration area.
And 404, checking the configuration parameters according to a preset checking rule.
And step 405, if the verification is successful, taking the configuration parameter as a target parameter value of the configuration parameter.
And 406, generating a report or a template according to the target parameter values of the basic elements in the effect display area.
The report data generation method provided by the embodiment of the invention can verify the data content and format input by the user when the user edits the configuration parameters, avoid the user from inputting the content which cannot be processed or identified, and improve the editing reliability of the user.
Example five
The embodiment of the invention provides a report data generation method, which can be used for report generation in an implementation mode, and comprises the following steps:
step 501, receiving a drag operation of a user on a basic element icon in a basic data area, wherein the termination position of the drag operation is an effect display area; and outputting basic elements in the effect display area.
Step 502, obtaining configuration parameters of the basic elements, and displaying the configuration parameters in a data configuration area;
step 503, determining a target parameter value of the configuration parameter according to a configuration operation of a user on the configuration parameter in the data configuration area;
and 504, generating a report or a template according to the target parameter values of the basic elements in the effect display area.
Wherein, the basic data area comprises a report template and basic elements for forming a report. The basic elements of the report comprise a line graph, a bar graph, a pie chart, a scatter graph, a geographic coordinate/map, a K line graph, a radar graph, a box demand graph, a thermodynamic diagram, a relation graph, a path graph, a tree graph, a rectangular tree graph, a rising sun graph, a parallel coordinate system, sang Jitu, a funnel graph, a dashboard, an ivory bar graph, a theme river graph, a calendar coordinate system, a custom graph, a text, a multi-line text, a table, a topological graph and a spectrogram based on the echarts secondary package. The report template is provided with a common data analysis report, a month use report, a financial report, a subject study including the like. The report template data is read from the database, and the template data is updated in time. Furthermore, each user only displays the self-stored and self-defined report template in the data authority processing.
And in the effect display area, interaction between the basic data area and the effect display area is realized based on the vueldragcable. Optionally, the report template or the report element is dragged from the left side data area to the effect display area, the template and the report base element on the left side are structured preset data, and the structured data preset in the dragging to the effect display area are analyzed to generate corresponding base charts such as a line chart, a column chart, a pie chart, a scatter chart and the like, and meanwhile, texts, a plurality of lines of texts, tables, a topological chart and a spectrogram are supported. Optionally, the topology is based on a 3d model, based on a topology data rasterization technology, and combined with hierarchical domain-division management network elements, the hierarchical domain-division display of the large-scale network elements is performed in a two-dimensional scene. Optionally, the frequency spectrum is triple chart display, and is composed of three parts of frequency spectrum, language spectrum and time spectrum, and based on a large number of background modes, the data chart display is carried out by automatically thinning the processed data, and three-table linkage check can be carried out during preview.
Data configuration area: the report style of the final effect display area is controlled by configuring global parameters, icon management, interface management and element management for the main functional area of the embodiment of the invention. Configuration parameters include global parameters, icon parameters, interface parameters, element parameters, and the like.
Global parameters: the report of each project is bound with different parameters, so that the parameters need to be extracted, and when different tasks need to be exported, the global parameters of the report name need to be dynamically modified through an interface.
Icon parameters: the public identification is used for the charts, and unified management is facilitated. The type or content of the base element is more intuitively identified by the icon corresponding to the icon parameter flowing over the base element.
Interface parameters: the method is used for binding different background interfaces by elements. The interfaces of each item are different, but the interfaces of each item are fixed, supporting the unified configuration and management of interfaces.
Element parameters: the elements of the report are broken down into finer classifications, mainly of the following types: line graphs, bar graphs, pie charts, scatter graphs, geographic coordinates/maps, K-grams, radar graphs, box demand graphs, thermodynamic diagrams, relationship graphs, path graphs, tree graphs, rectangular tree graphs, sunglass graphs, parallel coordinate systems, sang Jitu, funnel graphs, dashboards, ivory pole graphs, theme river graphs, calendar coordinate systems, custom charts, and text, multi-line text, tables, topological graphs, spectrograms, tables, forms, multi-line text, labels, pictures, topologies, etc., support the addition, modification, duplication, and deletion operations of elements.
From the user operation point of view, a quick configuration can be achieved by the following steps.
Step one, dragging a left template to an effect display area, analyzing the structured data of the template into a final display html page in batches through a preset algorithm, storing the structured data and the html, and storing a chart part as a base64 for generating a report. Multiple templates can be dragged at a time to combine one report, and the insertion position can be freely selected when the report is dragged to the effect display area.
And secondly, dragging the left report element to an effect display area, analyzing the structural data of the report minimum unit into a structural html page through a preset algorithm, storing the structural html page, and dragging the structural html page to the effect display area to freely select an inserting position.
Step three, dragging the positions of elements which are freely arranged up and down, and deleting and configuring the information such as the title, the size, the position, the color, the data source and the like of the elements
And fourthly, clicking an element setting button to jump and open a data configuration area, configuring basic information such as key, title, type, width, height, tipsShow, tipsForamt, html, style, direction, color, dataApi, xAxis, xAxisName, yAxis, yAxisName, explain of the element, and converting the exposed configurable data into structured data through a preset algorithm.
And step five, saving the report as a new report or a template. When the template is stored, only the structured data is stored in the database, and the personal template library is updated. When the data is stored as a new report, not only the structured data is stored, but also each minimum unit module is converted into base64 for storage together, so that the solidification of the data is ensured not to change during preview.
The embodiment of the invention provides a method for generating form data, which can be used for generating templates in another implementation mode, and comprises the following steps:
step 501, receiving a drag operation of a user on a basic element icon in a basic data area, wherein the termination position of the drag operation is an effect display area; and outputting basic elements in the effect display area.
Step 502, obtaining configuration parameters of the basic elements, and displaying the configuration parameters in a data configuration area;
step 503, determining a target parameter value of the configuration parameter according to a configuration operation of a user on the configuration parameter in the data configuration area;
and step 504, generating a form or a template according to the target parameter values of the basic elements in the effect display area.
Wherein, basic data area: the method comprises the steps of embedding a complete form template and basic elements for forming a form, wherein the basic elements comprise a single selection frame, a multi-selection frame, an input frame, a counter, a selector, a cascade selector, a switch, a slider, a time selector, a date-time selector, uploading, scoring, a color selector and a shuttle frame based on element secondary packaging. The form template is internally provided with a common examination form and a new form, the form template data is read from a database, the template data can be updated in time, and meanwhile, each person only displays a self-stored and self-defined form template when the data is subjected to authority processing.
Effect display area: based on the interaction between the base data area and the effect display area, a form template or a form element is dragged from a left side base data area to the effect display area, the left side template and the report base element are structured preset data, and the preset data are analyzed to generate a corresponding single selection frame, a multi-selection frame, an input frame, a counter, a selector, a cascade selector, a switch, a slider, a time selector, a date and time selector, uploading, scoring, a color selector and a shuttle frame after being dragged to the effect display area.
Data configuration area: the report style of the final effect display area is controlled by configuring global parameters, interface management and element management for the main functional area of the embodiment of the invention.
Global parameters: each item binds different parameters, so that the parameters need to be extracted, and when different forms are generated, the global parameters of the report names need only be dynamically modified through an interface.
Interface parameters: the method is used for binding different background interfaces by elements. The interfaces of each item are different, but the interfaces of each item are fixed, supporting the unified configuration and management of interfaces.
Element parameters: the elements of the flow form are split into finer classifications, which are mainly of the following types: single selection box, multiple selection box, input box, counter, selector, cascade selector, switch, slider, time selector, date and time selector, upload, score, color selector, shuttle box, etc., support elements' new addition, modification, duplication and deletion operations.
From the user operation point of view, a quick configuration can be achieved by the following steps.
Step one, dragging a left template to an effect display area, analyzing the structured data of the template into final display html pages in batches through a preset algorithm, and storing the structured data and the html. A plurality of templates can be dragged at a time to be overlapped and combined into a new flow form, and the insertion position can be freely selected when the new flow form is dragged to the effect display area.
Step two, dragging the left side flow Cheng Biaoshan element to an effect display area, analyzing the structured data of the minimum unit of the flow form into a final html page through a preset algorithm, storing the final html page, and dragging the final html page to the effect display area, wherein the insertion position can be freely selected.
And step three, dragging the positions of the elements which are freely arranged up and down, and deleting and configuring the information such as the title, the size, the position, the color, the data source and the like of the elements.
And fourthly, clicking an element setting button to jump and open a data configuration area, configuring basic information such as key, title, type, width, height, len, tips, rule, appendType, appendInfo, afterType, afterInfo, html, style, direction, dataApi, explain of the element, and converting the exposed configurable data into structured data through a preset algorithm.
And fifthly, storing the new flow form or template. When the template is stored, only the structured data is stored in the database, and the personal template library is updated. When the new flow form is stored, only the structured data needs to be stored.
According to the technical scheme provided by the embodiment of the invention, the configuration parameters exposed to the outside control the configuration of the final report and the flow form through the analysis and the generation of the structured data. The method has the advantages that the method has restriction prompt and rule check for parameter setting and editing operation in operation, ensures the legal compliance of input, and improves the whole operation efficiency. Meanwhile, the opening settings of custom checking rules, data interfaces and the like are opened, and the opening settings are simultaneously made when the limitations exist.
In addition, the operation flow can also design a cache mechanism, lazy loading can be carried out on data and settings when the data is opened for the first time, and the data request times are reduced so as to achieve the purpose of local quick operation.
Extracting the data type of the structured data, matching the data type with corresponding algorithm selection, identifying the service type of the data packet according to the service type parameter in the structured data, and adopting corresponding data limiting rules to carry out splicing generation of service logic. The method mainly uses a concise setting interface, and is matched with a core algorithm and a fault tolerance mechanism to rapidly configure the flow form and generate a flow form template, so that the project development cost and the iteration period duration are reduced.
Example six
Fig. 7 is a schematic structural diagram of a report data generating apparatus according to a fourth embodiment of the present invention, where the present embodiment is applicable to a case of automatically generating a report, and the method may be performed by an electronic device for providing report generation or report template editing for a user, and the electronic device may be a server or a computer device, and specifically includes:
the basic element icon dragging module 51 is configured to receive a dragging operation of a user on a basic element icon in a basic data area, where a termination position of the dragging operation is an effect display area; outputting basic elements in the effect display area;
a configuration parameter display module 52, configured to obtain configuration parameters of the base element, and display the configuration parameters in a data configuration area;
a target parameter determining module 53, configured to determine a target parameter value of the configuration parameter according to a configuration operation of the user on the configuration parameter in the data configuration area;
and the generating module 54 is used for generating a report or a template according to the target parameter values of the basic elements in the effect display area.
On the basis of the above embodiment, the system further includes a template selection module, configured to receive, before receiving a drag operation of a user on a base element icon in a base data area, where a termination position of the drag operation is an effect display area, a target template selected by the user in a template area;
Acquiring preset basic elements in the target template;
outputting the preset basic elements in an extended effect display area, wherein the area of the extended effect display area is larger than that of the effect display area.
On the basis of the above embodiment, the system further comprises a template selection module, an effect display area adjustment module, a configuration button, a display area adjustment module and a display area adjustment module, wherein the template selection module is used for responding to the preset basic element configuration button triggered by a user in the expansion effect display area after the preset basic element is output in the effect display area;
reducing the area of the extended effect display area to the effect display area;
and displaying a data configuration area, and outputting configuration parameters of the preset basic elements in the data configuration area.
On the basis of the above embodiment, the display device further includes an effect display area drag response module, configured to receive a drag operation of a user on the base element in the effect display area after the base element is output by the effect display area;
determining the position of the basic element in the effect display area according to the drag operation;
the generating module 54 is configured to generate a report or a template according to the location of the base element in the effect display area and the target parameter value.
On the basis of the above embodiment, the generating module 54 is configured to:
determining template structural data according to target parameter values of basic elements in the effect display area; or,
printing basic elements in the effect display area as image data respectively; and generating a report according to the image data.
On the basis of the above embodiment, the system further includes a real-time adjustment module, configured to adjust and output, in real time, the content of the base element in the effect display area according to the target parameter value after determining the target parameter value of the configuration parameter according to the configuration operation of the user on the configuration parameter in the data configuration area.
On the basis of the above embodiment, the target parameter determination module 53 is configured to:
receiving configuration parameters output by a user to the configuration parameters in the data configuration area;
checking the configuration parameters according to a preset checking rule;
and if the verification is successful, taking the configuration parameter as a target parameter value of the configuration parameter.
According to the report data generating device provided by the embodiment of the invention, the basic element icon dragging module 51 is used for receiving the dragging operation of a user on the basic element icon in the basic data area, and the ending position of the dragging operation is an effect display area; outputting basic elements in the effect display area; a configuration parameter display module 52, configured to obtain configuration parameters of the base element, and display the configuration parameters in a data configuration area; a target parameter determining module 53, configured to determine a target parameter value of the configuration parameter according to a configuration operation of the user on the configuration parameter in the data configuration area; and the generating module 54 is used for generating a report or a template according to the target parameter values of the basic elements in the effect display area. Compared with the problems of high coupling between codes and reports and long development period caused by manual editing of report codes at present, the technical scheme provided by the invention can output the basic elements forming the report in the effect display area, and a user can drag the basic elements to the effect display area in a dragging mode, so that the quick configuration of the basic elements is realized through the editing operation of configuration parameters, the code programming is not needed, the user operation is simplified, and the usability is improved. According to the technical scheme provided by the invention, the user can complete report editing through simple operation of dragging or parameter configuration modification, the user is not required to edit codes, and the coupling between the codes and the report is reduced.
The report data generating device provided by the embodiment of the invention can execute the report data generating method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the executing method.
Example seven
Fig. 8 is a schematic structural diagram of a computer device according to a seventh embodiment of the present invention, and as shown in fig. 8, the computer device includes a processor 60, a memory 61, an input device 62 and an output device 63; the number of processors 60 in the computer device may be one or more, one processor 60 being taken as an example in fig. 8; the processor 60, the memory 61, the input means 62 and the output means 63 in the computer device may be connected by a bus or by other means, in fig. 8 by way of example.
The memory 61 is a computer readable storage medium, and may be used to store software programs, computer executable programs, and modules, such as program instructions/modules corresponding to the report data generating method in the embodiment of the present invention (for example, the basic element icon dragging module 51, the configuration parameter display module 52, the target parameter determining module 53, and the generating module 54 in the report data generating device). The processor 60 executes various functional applications of the computer device and data processing, that is, implements the report data generation method described above, by running software programs, instructions, and modules stored in the memory 61.
The memory 61 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, at least one application program required for functions; the storage data area may store data created according to the use of the terminal, etc. In addition, the memory 61 may include high-speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid-state storage device. In some examples, memory 61 may further comprise memory remotely located relative to processor 60, which may be connected to the computer device via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 62 is operable to receive input numeric or character information and to generate key signal inputs related to user settings and function control of the computer device. The output 63 may comprise a display device such as a display screen.
Example eight
An eighth embodiment of the present invention also provides a storage medium containing computer-executable instructions, which when executed by a computer processor, are configured to perform a method of generating report data, the method comprising:
Receiving a drag operation of a user on a basic element icon in a basic data area, wherein the termination position of the drag operation is an effect display area; outputting basic elements in the effect display area;
acquiring configuration parameters of the basic elements, and displaying the configuration parameters in a data configuration area;
determining a target parameter value of the configuration parameter according to the configuration operation of a user on the configuration parameter in the data configuration area;
and generating a report or a template according to the target parameter values of the basic elements in the effect display area.
On the basis of the above embodiment, before receiving a drag operation of a user on a base element icon in a base data area, the termination position of the drag operation is an effect display area, the method further includes:
receiving a target template selected by a user in a template area;
acquiring preset basic elements in the target template;
outputting the preset basic elements in an extended effect display area, wherein the area of the extended effect display area is larger than that of the effect display area.
On the basis of the above embodiment, after outputting the preset base element in the effect display area, the method further includes:
a configuration button of the preset basic element triggered by a user in the expansion effect display area is responded;
Reducing the area of the extended effect display area to the effect display area;
and displaying a data configuration area, and outputting configuration parameters of the preset basic elements in the data configuration area.
On the basis of the above embodiment, after the effect display area outputs the base element, the method further includes:
receiving a drag operation of a user on the basic element in the effect display area;
determining the position of the basic element in the effect display area according to the drag operation;
generating a report or a template according to the target parameter values of the basic elements in the effect display area, wherein the report or the template comprises the following steps:
and generating a report or a template according to the positions of the basic elements in the effect display area and the target parameter values.
On the basis of the above embodiment, the generating a report or a template according to the target parameter values of the base elements in the effect display area includes:
determining template structural data according to target parameter values of basic elements in the effect display area; or,
printing basic elements in the effect display area as image data respectively; and generating a report according to the image data.
On the basis of the above embodiment, after determining the target parameter value of the configuration parameter according to the configuration operation of the user on the configuration parameter in the data configuration area, the method further includes:
And adjusting and outputting the basic element content in real time according to the target parameter value in the effect display area.
On the basis of the foregoing embodiment, the determining, according to the configuration operation of the user on the configuration parameter in the data configuration area, the target parameter value of the configuration parameter includes:
receiving configuration parameters output by a user to the configuration parameters in the data configuration area;
checking the configuration parameters according to a preset checking rule;
and if the verification is successful, taking the configuration parameter as a target parameter value of the configuration parameter.
Of course, the storage medium containing the computer executable instructions provided in the embodiments of the present invention is not limited to the above-described method operations, and may also perform the related operations in the report data generating method provided in any embodiment of the present invention.
From the above description of embodiments, it will be clear to a person skilled in the art that the present invention may be implemented by means of software and necessary general purpose hardware, but of course also by means of hardware, although in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, etc., and include several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method according to the embodiments of the present invention.
It should be noted that, in the embodiment of the report data generating apparatus, each unit and module included are only divided according to the functional logic, but not limited to the above-mentioned division, so long as the corresponding functions can be implemented; in addition, the specific names of the functional units are also only for distinguishing from each other, and are not used to limit the protection scope of the present invention.
Note that the above is only a preferred embodiment of the present invention and the technical principle applied. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, while the invention has been described in connection with the above embodiments, the invention is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit or scope of the invention, which is set forth in the following claims.
Claims (10)
1. The report data generation method is characterized by comprising the following steps:
receiving a drag operation of a user on a basic element icon in a basic data area, wherein the termination position of the drag operation is an effect display area; outputting basic elements in the effect display area;
Acquiring configuration parameters of the basic elements, and displaying the configuration parameters in a data configuration area;
determining a target parameter value of the configuration parameter according to the configuration operation of a user on the configuration parameter in the data configuration area;
and generating a report or a template according to the target parameter values of the basic elements in the effect display area.
2. The method according to claim 1, wherein before receiving a drag operation of the base element icon in the base data area by the user, the termination position of the drag operation is the effect presentation area, further comprising:
receiving a target template selected by a user in a template area;
acquiring preset basic elements in the target template;
outputting the preset basic elements in an extended effect display area, wherein the area of the extended effect display area is larger than that of the effect display area.
3. The method according to claim 2, further comprising, after outputting the preset base element in the effect presentation area:
a configuration button of the preset basic element triggered by a user in the expansion effect display area is responded;
reducing the area of the extended effect display area to the effect display area;
And displaying a data configuration area, and outputting configuration parameters of the preset basic elements in the data configuration area.
4. The method of claim 1, further comprising, after the effect presentation area outputs the base element:
receiving a drag operation of a user on the basic element in the effect display area;
determining the position of the basic element in the effect display area according to the drag operation;
generating a report or a template according to the target parameter values of the basic elements in the effect display area, wherein the report or the template comprises the following steps:
and generating a report or a template according to the positions of the basic elements in the effect display area and the target parameter values.
5. The method of claim 1, wherein generating a report or template from the target parameter values of the base elements in the effects presentation area comprises:
determining template structural data according to target parameter values of basic elements in the effect display area; or,
printing basic elements in the effect display area as image data respectively; and generating a report according to the image data.
6. The method of claim 1, further comprising, after determining the target parameter value for the configuration parameter based on a user's configuration operation of the configuration parameter in the data configuration area:
And adjusting and outputting the basic element content in real time according to the target parameter value in the effect display area.
7. The method of claim 1, wherein said determining the target parameter value of the configuration parameter based on the user's configuration operation of the configuration parameter in the data configuration area comprises:
receiving configuration parameters output by a user to the configuration parameters in the data configuration area;
checking the configuration parameters according to a preset checking rule;
and if the verification is successful, taking the configuration parameter as a target parameter value of the configuration parameter.
8. A report data generating apparatus, comprising:
the basic element icon dragging module is used for receiving the dragging operation of a user on the basic element icon in the basic data area, and the ending position of the dragging operation is an effect display area; outputting basic elements in the effect display area;
the configuration parameter display module is used for acquiring the configuration parameters of the basic elements and displaying the configuration parameters in a data configuration area;
the target parameter determining module is used for determining a target parameter value of the configuration parameter according to the configuration operation of a user on the configuration parameter in the data configuration area;
And the generating module is used for generating a report or a template according to the target parameter values of the basic elements in the effect display area.
9. An electronic device, the electronic device comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the report data generating method of any one of claims 1-7.
10. A computer readable storage medium storing computer instructions for causing a processor to perform the method of generating report data according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311337446.9A CN117094300A (en) | 2023-10-17 | 2023-10-17 | Report data generation method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311337446.9A CN117094300A (en) | 2023-10-17 | 2023-10-17 | Report data generation method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117094300A true CN117094300A (en) | 2023-11-21 |
Family
ID=88771999
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311337446.9A Pending CN117094300A (en) | 2023-10-17 | 2023-10-17 | Report data generation method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117094300A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107844297A (en) * | 2017-10-17 | 2018-03-27 | 广东广业开元科技有限公司 | A kind of data visualization realizes system and method |
| CN108345456A (en) * | 2018-03-07 | 2018-07-31 | 平安普惠企业管理有限公司 | Page code generation method, device, computer equipment and storage medium |
| CN114254602A (en) * | 2021-12-14 | 2022-03-29 | 航天信息股份有限公司 | Design system and storage medium for custom forms |
| CN115186643A (en) * | 2022-07-21 | 2022-10-14 | 平安科技（深圳）有限公司 | Self-defined configuration method, device, equipment and storage medium of sign-up template |
-
2023
- 2023-10-17 CN CN202311337446.9A patent/CN117094300A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107844297A (en) * | 2017-10-17 | 2018-03-27 | 广东广业开元科技有限公司 | A kind of data visualization realizes system and method |
| CN108345456A (en) * | 2018-03-07 | 2018-07-31 | 平安普惠企业管理有限公司 | Page code generation method, device, computer equipment and storage medium |
| CN114254602A (en) * | 2021-12-14 | 2022-03-29 | 航天信息股份有限公司 | Design system and storage medium for custom forms |
| CN115186643A (en) * | 2022-07-21 | 2022-10-14 | 平安科技（深圳）有限公司 | Self-defined configuration method, device, equipment and storage medium of sign-up template |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108228169B (en) | Chart making method, device, equipment and medium based on eCharts tool | |
| US9575950B2 (en) | Systems and methods for managing spreadsheet models | |
| US8392828B2 (en) | Open theme builder and API | |
| CN112926288B (en) | Business intelligent data visualization method, system, equipment and readable storage medium | |
| US8065267B2 (en) | Information processing device, file data merging method, file naming method, and file data output method | |
| CN103714492A (en) | Automatic report generating method capable of meeting power distribution network management specific data standards | |
| CN111881662A (en) | Form generation method, device, processing equipment and storage medium | |
| CN110705231A (en) | Webpage editing method and device | |
| KR101950126B1 (en) | Mathematical formula processing method, device, apparatus and computer storage medium | |
| CN111414405A (en) | Data acquisition method and device and electronic equipment | |
| CN112307109A (en) | Visual chart generation method and device, electronic equipment and storage medium | |
| CN114138269A (en) | Visual application construction method and device of business data | |
| CN115828873A (en) | Method and device for setting expression in electronic form | |
| CN112560422A (en) | Chart processing method, device, equipment and medium | |
| CN116245052A (en) | Drawing migration method, device, equipment and storage medium | |
| JP2007109221A (en) | Part management system, part management method, program and recording medium | |
| CN117032675B (en) | Dynamic form design method | |
| CN117032666A (en) | Page editing method and device based on editor, terminal equipment and storage medium | |
| CN113010829A (en) | Data partition visualization method and device, computer equipment and storage medium | |
| US20080086324A1 (en) | Parts managing system, parts managing method, and computer program product | |
| CN117094300A (en) | Report data generation method and device, electronic equipment and storage medium | |
| CN116127234A (en) | Front-end general management system and method based on VUE architecture | |
| CN115713572A (en) | Text image generation method and device, electronic equipment and readable storage medium | |
| JPWO2006137564A1 (en) | Document processing device | |
| CN114116686A (en) | Data visualization method for realizing data large screen |
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 |