CN111476010A - High-flexibility report method and system - Google Patents

High-flexibility report method and system Download PDF

Info

Publication number
CN111476010A
CN111476010A CN202010260754.6A CN202010260754A CN111476010A CN 111476010 A CN111476010 A CN 111476010A CN 202010260754 A CN202010260754 A CN 202010260754A CN 111476010 A CN111476010 A CN 111476010A
Authority
CN
China
Prior art keywords
report
data
flexibility
configuration
sql
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.)
Granted
Application number
CN202010260754.6A
Other languages
Chinese (zh)
Other versions
CN111476010B (en
Inventor
丘斌
叶伟城
刘志军
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
XIAMEN ZHIYE SOFTWARE ENGINEERING CO LTD
Original Assignee
XIAMEN ZHIYE SOFTWARE ENGINEERING CO LTD
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by XIAMEN ZHIYE SOFTWARE ENGINEERING CO LTD filed Critical XIAMEN ZHIYE SOFTWARE ENGINEERING CO LTD
Priority to CN202010260754.6A priority Critical patent/CN111476010B/en
Publication of CN111476010A publication Critical patent/CN111476010A/en
Application granted granted Critical
Publication of CN111476010B publication Critical patent/CN111476010B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/34Graphical or visual programming
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/38Creation or generation of source code for implementing user interfaces
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/40Transformation of program code
    • G06F8/41Compilation
    • G06F8/44Encoding

Landscapes

  • Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Human Computer Interaction (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention relates to the technical field of report development, in particular to a high-flexibility report method and a high-flexibility report system. The method comprises a configuration step and a display step. In the high-flexibility report method and the system, a convenient and quick secondary development scaffold is provided for developers of the system with high personalized degree, and the secondary developers can use web-oriented developers and daily-used development skills to perform secondary development because the technology selection all uses open technologies, so that the learning cost is saved, the reports with high personalized degree can be quickly matched in color and flexibly developed in layout, and the uniform requirements of vi can be met.

Description

High-flexibility report method and system
Technical Field
The invention relates to the technical field of report development, in particular to a high-flexibility report method and a high-flexibility report system.
Background
Developers of reports in the existing method are basically positioned in groups with certain SQ L capacity, but the developers are not enough to self-develop complete report flows, so that convenient operation is exchanged at the cost of sacrificing flexibility, and therefore the report layout, color matching and linkage effect of a plurality of report graphs are necessarily restricted or cannot be realized, and the developers are not flexible.
The existing method provides a method which can enable programmers to carry out secondary development, but the used technology is relatively closed, the learning and development cost is high, and the operation is difficult.
The current use situation of the report system is that a system with high individuation degree is provided, report developers normally have certain programming capacity, and the secondary development is carried out by using the existing method, so that time and labor are wasted; the development is carried out from the beginning, the commonalities exist among different reports, and a large amount of repeated work easily exists.
Disclosure of Invention
The present invention provides a reporting method and system with high flexibility to solve the problems of the background art.
In order to solve the above technical problems, an object of the present invention is to provide a high-flexibility reporting method, which includes a configuration step and a display step, wherein:
the method of the configuring step comprises the steps of:
s1.1, layout configuration, a short html can be written into a table er _ element _ block, all records of the table can be designated by A, a designates one record in the A table, it needs to be explained that a complete html which can enable a page to complete display is not needed to be written, the simplest case is that only the id of one html element is needed, and if custom layout is needed, the html element needs to be positioned by using a native css. And configuring the written table as er _ element _ block in the attached table. The value of the css _ class field in the table may select a built-in layout from the drop-down box, the built-in layout having: a query area layout, a single diagram layout, a three-column layout, a three-row layout, a four-grid layout and a nine-grid layout;
s1.2, configuring the graphs and the color matching, modularizing js scripts in a seajs mode, and modularizing and storing a single graph report into a database, wherein the stored table is an er _ option _ block in an attached table;
s1.3, data query configuration, namely configuring data query Sql, persisting the data query Sql to a database to form query of single graphic data, receiving query parameters and dynamically splicing the Sql in a velocity mode to further accurately query intention data, and storing an Sql template into an er _ Sql _ block in an attached table;
s1.4, report combination configuration, wherein one record of S1.1, S1.2 and S1.3 selects the configuration of the components from S1.1, S1.2 and S1.3, a plurality of components are organically combined to form a complete report page, the record of the report is stored in an er _ report in an attached table, one er _ report record is a report page, one record is selected from $1.1, $1.2 and $1.3 respectively, and the record is combined to form a new er _ report _ selection record and is stored in a database. The report page represents a graph in the report corresponding to the last er _ report _ selection. And establishing a one-to-many relationship with the er _ report;
the method of the displaying step comprises the following steps:
s2.1, jumping to a container page of the report through a container page transmission parameter (an id field value of a table er _ report);
s2.2, acquiring complete configuration according to the parameters in the S2.1; the obtained data structure is detailed in a data structure 1;
data structure 1, complete configuration example of target report:
Figure BDA0002439198820000021
Figure BDA0002439198820000031
Figure BDA0002439198820000041
s2.3, gradually requesting the needed script and data.
Preferably, in S1.2, the method for configuring the graphics and the color scheme includes the following steps:
s1.2.1, pattern color matching:
the Echarts plug-in is built in, and color matching of different parts of various graphs such as bar charts, pie charts, scatter charts and the like can be indicated at js of declaring Echarts. The configuration method of color matching is provided by Echarts;
grid of EasyUI is built in, and color matching can be carried out on the table by using a configuration method built in the EasyUI;
the graphical presentation may be selected from drop-down boxes for Echarts charts, easy UI forms, and custom component configurations. Storing the shape field of the er _ option _ block;
s1.2.2, communication between multiple components:
description of the drawings: a statistical graph, a table or an html component formed by combining a + b + c is collectively called a component;
declaring in js that _ event receives the event of Echarts and continues to execute the code written in _ event;
the code written in event covers: code to operate other components; if the parameter is changed, the reload method provided by the device can be called to declare the component of the _ reloadable, the step iii is executed again in response to the reload operation, the query condition is changed to obtain new data and a statistical chart corresponding to the new data is displayed, and the communication and mutual scheduling among the components can be realized through the open event processing;
s1.2.3, mapping data query parameters and a number map:
the device defines the identification of the _ reportParam method, and a second-start worker needs to write the _ reportParam method by himself, transmit a return value to the c and perform data query according to the query condition;
the device definition identifies the _ setData method, and the second-generation personnel need to compile the _ setData method, receive the data returned from the step c, process the data and transmit the data to the executor of the shape scheme;
the data processing method is used for converting data obtained by database query into a data structure which can be received and executed by a built-in scheme or a self-defined scheme, so as to establish mapping of data and graphs;
s1.2.4, reference third-party extension plug-in:
identifying an init method in device definition, selecting a custom graph in a shape drop-down box, then writing the init method, and introducing the init by using sea.
Due to the built-in third-party plug-in: echarts and easy UI-Grid can not necessarily meet the actual requirement, so the device opens the use interface of seajs, and the second-division personnel can introduce the third-party plug-ins required by the second-division personnel according to the actual situation. The device has the function of extracting report commonality, and a complete data stream is formed by serially connecting identification of the init method, the report param method, the event method and the setData method and identification of the reloadable attribute, so that a second-generation person can concentrate on business more.
Preferably, in S2.3, the method for gradually requesting the required scripts and data includes the following steps:
s2.3.1, layout of components, obtain els configuration in data structure 1, create html div elements in container page by for loop batch, and put into container page, to play the role of placeholder, minimum unit of layout: a pixel. The elements retain information such as: an eld;
s2.3.2, assembling the data in the data structure 1 into a plurality of independent component configurations through the mapping relationship established by internal selections, as detailed in the data structure 2;
data structure 2, single component configuration example:
Figure BDA0002439198820000061
s2.3.3, assembling a plurality of components by for-loop configuration in the plurality of data structures 2, and selecting the placeholder element as the container of the current component if the placeholder element and the element with the elId in the elementId comparison S2.3.1 are consistent;
s2.3.4, selecting a built-in presentation scheme, Echart, easy UI-Grid, or a custom scheme, by shape in data structure 2. When the shape does not exist, a user-defined scheme is selected by default;
s2.3.5, mapping and displaying a number map;
s2.3.6, presented to the user.
Preferably, in S2.3.3, the method for assembling a plurality of components by means of a for-loop configuration in a plurality of data structures 2 includes the following steps:
s2.3.3.1, acquiring a color scheme and number map mapping relation script through the optiId in the data structure 2;
s2.3.3.2, obtaining an sql template configured by the second developer through the sql Id query in the data structure 2;
s2.3.3.3, forming an executable sql script through the assembly of velocity by the parameter submitted by the _ reportParam;
s2.3.3.4, directly acquiring service data from the database by the executable sql in a JDBC mode;
s2.3.3.5, after obtaining the business data ResultSet of JDBC specification, processing different field types, and converting the format of ResultSet into json format;
s2.3.3.6, and returns the data to the container page.
Preferably, in S2.3.5, the specific method for mapping and displaying the number map includes the following steps:
s2.3.5.1, after the data is taken, the format available for the data structure scheme is modified again by calling the method of _ setData;
s2.3.5.2, the data after format conversion is delivered to the shape scheme executor to be displayed as corresponding graph, table or custom effect.
Another object of the present invention is to provide a high-flexibility reporting system, which includes:
the configuration module is used for developing the plug-in;
and the display module is used for processing the report in the single report using process by the user.
The present invention also provides a high-flexibility reporting apparatus, which includes a processor, a memory, and a computer program stored in the memory and running on the processor, wherein the processor implements the steps of the high-flexibility reporting method when executing the computer program.
The fourth objective of the present invention is to provide a computer-readable storage medium, wherein at least one program is stored in the storage medium, and the at least one program is executed by the processor to implement the steps of the high-flexibility reporting method as described in any one of the above.
Compared with the prior art, the invention has the beneficial effects that: in the high-flexibility report method and the system, a convenient and quick secondary development scaffold is provided for developers of the system with high personalized degree, and the secondary developers can use web-oriented developers and daily-used development skills to perform secondary development because the technology selection all uses open technologies, so that the learning cost is saved, the reports with high personalized degree can be quickly matched in color and flexibly developed in layout, and the uniform requirements of vi can be met.
Drawings
FIG. 1 is one of the flow charts of the present invention from a pure data to a schema presentation;
FIG. 2 is one of the flow charts of the present invention from a pure data to a schema presentation;
FIG. 3 is one of the algorithm flow diagrams for converting the ResultSet format of JDBC to json according to the present invention;
FIG. 4 is a second flowchart of the algorithm for converting the ResultSet format of JDBC to json according to the present invention;
FIG. 5 is an element splitting and overall flow diagram of the present invention;
FIG. 6 is a structural schematic diagram of the high-flexibility reporting device of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1-6, the present invention provides a technical solution:
the invention provides a high-flexibility report method, which comprises a configuration step and a display step, wherein the configuration step comprises the following steps:
the method of the configuration step comprises the steps of:
s1.1, layout configuration, a short html can be written into a table er _ element _ block, all records of the table can be designated by A, a designates one record in the A table, it needs to be explained that a complete html which can enable a page to complete display is not needed to be written, the simplest case is that only the id of one html element is needed, and if custom layout is needed, the html element needs to be positioned by using a native css. And configuring the written table as er _ element _ block in the attached table. The value of the css _ class field in the table may select a built-in layout from the drop-down box, the built-in layout having: a query area layout, a single diagram layout, a three-column layout, a three-row layout, a four-grid layout and a nine-grid layout;
s1.2, configuring the graphs and the color matching, modularizing js scripts in a seajs mode, and modularizing and storing a single graph report into a database, wherein the stored table is an er _ option _ block in an attached table;
s1.3, data query configuration, namely configuring data query Sql, persisting the data query Sql to a database to form query of single graphic data, receiving query parameters and dynamically splicing the Sql in a velocity mode to further accurately query intention data, and storing an Sql template into an er _ Sql _ block in an attached table;
s1.4, report combination configuration, wherein one record of S1.1, S1.2 and S1.3 selects the configuration of the components from S1.1, S1.2 and S1.3, a plurality of components are organically combined to form a complete report page, the record of the report is stored in an er _ report in an attached table, one er _ report record is a report page, one record is selected from $1.1, $1.2 and $1.3 respectively, and the record is combined to form a new er _ report _ selection record and is stored in a database. The report page represents a graph in the report corresponding to the last er _ report _ selection. And establishing a one-to-many relationship with the er _ report;
the method of the display step comprises the following steps:
s2.1, jumping to a container page of the report through a container page transmission parameter (an id field value of a table er _ report);
s2.2, acquiring complete configuration according to the parameters in the S2.1; the obtained data structure is detailed in a data structure 1;
wherein, the data structure 1, the complete configuration example of the target report:
Figure BDA0002439198820000091
Figure BDA0002439198820000101
Figure BDA0002439198820000111
s2.3, gradually requesting the needed script and data.
In this embodiment, in S1.2, the method for configuring the graphics and the color matching includes the following steps:
s1.2.1, pattern color matching:
the Echarts plug-in is built in, and color matching of different parts of various graphs such as bar charts, pie charts, scatter charts and the like can be indicated at js of declaring Echarts. The configuration method of color matching is provided by Echarts;
grid of EasyUI is built in the table, and color matching can be performed on the table by using a configuration method built in the EasyUI;
the graphic display mode can select Echarts charts, easy UI tables and custom component configuration from a drop-down box. Storing the shape field of the er _ option _ block;
s1.2.2, communication between multiple components:
description of the drawings: a statistical graph, a table or an html component formed by combining a + b + c is collectively called a component;
it is worth noting that event _ event receives Echarts is declared in js and continues to execute the code written in _ event;
specifically, the code written in the event covers: code to operate other components; if the parameter is changed, the reload method provided by the device can be called to declare the component of the _ reloadable, the step iii is executed again in response to the reload operation, the query condition is changed to obtain new data and a statistical chart corresponding to the new data is displayed, and the communication and mutual scheduling among the components can be realized through the open event processing;
s1.2.3, mapping data query parameters and a number map:
further, the device defines the identification of the _ reportParam method, and a second-start worker needs to write the _ reportParam method by himself, transmit a return value to the c, and perform data query according to the query condition;
specifically, the device defines the identification of the _ setData method, and a second-generation worker needs to compile the _ setData method, receive the data returned from the step c, process the data and transmit the data to an executor of the shape scheme;
it is worth mentioning that the data processing method is intended to convert the data obtained by database query into a data structure that can be received and executed by a built-in scheme or a custom scheme, thereby establishing the mapping of data and graphics;
s1.2.4, reference third-party extension plug-in:
the method comprises the steps that an init method is identified in device definition, a user-defined graph is selected from a shape drop-down box, then the init method is written, and sea. use ('url') is used for leading in the init;
due to the built-in third-party plug-in: echarts and easy UI-Grid can not necessarily meet the actual requirement, so the device opens the use interface of seajs, and the second-division personnel can introduce the third-party plug-ins required by the second-division personnel according to the actual situation. The device has the function of extracting report commonality, and a complete data stream is formed by serially connecting identification of the init method, the report param method, the event method and the setData method and identification of the reloadable attribute, so that a second-generation person can concentrate on business more.
Still further, in S2.3, the method for requesting the required scripts and data step by step includes the following steps:
s2.3.1, layout of components, obtain els configuration in data structure 1, create html div elements in container page by for loop batch, and put into container page, to play the role of placeholder, minimum unit of layout: a pixel. The elements retain information such as: an eld;
s2.3.2, assembling the data in the data structure 1 into a plurality of independent component configurations through the mapping relationship established by internal selections, as detailed in the data structure 2;
it is worth noting that data structure 2, a single component configuration example:
Figure BDA0002439198820000131
Figure BDA0002439198820000141
s2.3.3, assembling a plurality of components by for-loop configuration in the plurality of data structures 2, and selecting the placeholder element as the container of the current component if the placeholder element and the element with the elId in the elementId comparison S2.3.1 are consistent;
s2.3.4, selecting a built-in presentation scheme, Echart, easy UI-Grid, or a custom scheme, by shape in data structure 2. When the shape does not exist, a user-defined scheme is selected by default;
s2.3.5, mapping and displaying a number map;
s2.3.6, presented to the user.
Further, S2.3.3, the method for assembling a plurality of components by means of for-cycling the configuration in the plurality of data structures 2 includes the steps of:
s2.3.3.1, acquiring a color scheme and number map mapping relation script through the optiId in the data structure 2;
s2.3.3.2, obtaining an sql template configured by the second developer through the sql Id query in the data structure 2;
s2.3.3.3, forming an executable sql script through the assembly of velocity by the parameter submitted by the _ reportParam;
s2.3.3.4, directly acquiring service data from the database by the executable sql in a JDBC mode;
s2.3.3.5, after obtaining the business data ResultSet of JDBC specification, processing different field types, and converting the format of ResultSet into json format;
s2.3.3.6, and returns the data to the container page.
It should be noted that, in S2.3.5, the specific method for mapping and displaying the data map includes the following steps:
s2.3.5.1, after the data is taken, the format available for the data structure scheme is modified again by calling the method of _ setData;
s2.3.5.2, the data after format conversion is delivered to the shape scheme executor to be displayed as corresponding graph, table or custom effect.
In this embodiment, a processing procedure of RE L tion- > JSON based on JDBC and backend template technology is shown in fig. 3 and 4, a parameter scheme of report data query dynamic sql is vector, and data access and serialization directly use native JDBC to improve process performance.
Specifically, the patterning process is as follows:
and (3) a graph scheme: an EChats and easy UI third-party tool is built in, but not limited to the EChats and easy UI third-party tool, and plug-ins required by third-party expansion can be loaded in the graphic script in a CDN (content delivery network) mode;
and (4) using seajs as a graphic script loader and matching jquery to finish graphic processing.
Attached table:
report name table (er _ report)
Field(s) Remarks for note
id Main key
name Name (R)
Element layout configuration table (er _ element _ block responsible layout)
Field(s) Remarks for note
id Main key
el_id Element id
css_class Styles classes
style Inline style
sort_no Sorting
el_inner_html In-element text
js script configuration table (er _ option _ block)
Field(s) Remarks for note
id Main key
js js script
shape Exhibit form (gridption)
sql script configuration table (er _ sql _ block)
Field(s) Remarks for note
id Main key
name Name (R)
sql_text sql script
Note: is responsible for the access of data.
sql script configuration Table (er _ report _ selection)
Field(s) Remarks for note
id Main key
report_id Report form id
element Layout id
option_id js script id
sql_id sql script
Note: the display device is responsible for combining the parts which perform the functions of each other to jointly complete the display effect of a graph. In contrast to the prior art, the following table shows:
comparison table
Different points Prior Art This example
Framework CS framework BS architecture
People who use the food General staff Two-division person
Purpose(s) to Fast data visualization report Rapid development data visualization plug-in
Deploying Cold deployment Thermal deployment
Minimum unit of layout Cell grid Pixel
Color matching Limiting the color matching range of an existing insert All colour values of rgb
Configuring storage locations File system Database with a plurality of databases
Another object of the present invention is to provide a high-flexibility reporting system, which includes:
the configuration module is used for developing the plug-in;
and the display module is used for processing the report in the single report using process by the user.
It should be noted that, for the functions of the configuration module and the presentation module, reference is specifically made to the description of the method portion corresponding to each module, and details are not described here again.
Referring to fig. 6, a schematic structural diagram of a high-flexibility reporting apparatus according to an embodiment of the present invention is shown, where the apparatus includes a processor, a memory, and a bus.
The processor comprises one or more processing cores, the processor is connected with the processor through a bus, the memory is used for storing program instructions, and the high-flexibility reporting method is realized when the processor executes the program instructions in the memory.
Alternatively, the memory may be implemented by any type or combination of volatile or non-volatile memory devices, such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disks.
In addition, the present invention further provides a computer-readable storage medium, in which at least one program is stored, and the at least one program is executed by the processor to implement the steps of any one of the above-mentioned high-flexibility reporting methods.
Optionally, the present invention further provides a computer program product containing instructions, which when run on a computer, causes the computer to perform the steps of the above-mentioned high-flexibility reporting method in each aspect.
It will be understood by those skilled in the art that all or part of the steps for implementing the above embodiments may be implemented by hardware, or may be implemented by hardware related to instructions of a program, where the program may be stored in a computer readable storage medium, and the above mentioned storage medium may be a read-only memory, a magnetic disk or an optical disk, etc.
The foregoing shows and describes the general principles, essential features, and advantages of the invention. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, and the preferred embodiments of the present invention are described in the above embodiments and the description, and are not intended to limit the present invention. The scope of the invention is defined by the appended claims and equivalents thereof.

Claims (8)

1. A high-flexibility report method comprises a configuration step and a display step, wherein:
the method of the configuring step comprises the steps of:
s1.1, layout configuration, namely writing a short html into a table er _ element _ block;
s1.2, configuring the graphs and the color matching, modularizing js scripts in a seajs mode, and modularizing and storing a single graph report into a database, wherein the stored table is an er _ option _ block in an attached table;
s1.3, data query configuration, namely configuring data query Sql, persisting the data query Sql to a database to form query of single graphic data, receiving query parameters and dynamically splicing the Sql in a velocity mode to accurately query intention data, and storing an Sql template into an er _ Sql _ block in an attached table;
s1.4, report combination configuration, wherein one record of S1.1, S1.2 and S1.3 selects the configuration of the components from S1.1, S1.2 and S1.3, a plurality of components are organically combined to form a complete report page, the record of the report is stored in an er _ report in an attached table, one er _ report record is a report page, one record is selected from S1.1, S1.2 and S1.3 respectively, and a new er _ report _ selection record is formed by combination and stored in a database. The report page represents a graph in the report corresponding to the last er _ report _ selection. And establishing a one-to-many relationship with the er _ report;
the method of the displaying step comprises the following steps:
s2.1, skipping to a container page of the report through a container page transmission parameter;
s2.2, acquiring complete configuration according to the parameters in the S2.1 to obtain a data structure;
s2.3, gradually requesting the needed script and data.
2. The high-flexibility reporting method of claim 1, wherein: in S1.2, the method for configuring the graphics and color matching includes the following steps:
s1.2.1, matching colors of graphs;
s1.2.2, communication among multiple components;
s1.2.3, mapping data query parameters and a number map;
s1.2.4, reference is made to a third party extension plug-in.
3. The high-flexibility reporting method of claim 1, wherein: in S2.3, the method for gradually requesting the required script and data includes the following steps:
s2.3.1, layout of components, obtaining els configuration, creating html div elements in a container page through for circulation batch, and putting the elements into the container page to play a role in occupying space;
s2.3.2, assembling the subassemblies into a plurality of independent subassembly configurations by the mapping relationship established by the internal selections of the data;
s2.3.3, assembling a plurality of components through a for loop configuration, and selecting the placeholder element as the container of the current component if the placeholder element and the element with the eleld are consistent according to the elementId comparison S2.3.1;
s2.3.4, selecting a built-in display scheme through shape;
s2.3.5, mapping and displaying a number map;
s2.3.6, presented to the user.
4. The high-flexibility reporting method of claim 3, wherein: s2.3.3, the method for assembling a plurality of components by cycling through a plurality of configurations includes the steps of:
s2.3.3.1, acquiring a color scheme and number map mapping relation script through the optiId;
s2.3.3.2, obtaining an sql template configured by the second-generation member through sql Id query;
s2.3.3.3, forming an executable sql script through the assembly of velocity by the parameter submitted by the _ reportParam;
s2.3.3.4, directly acquiring service data from the database by the executable sql in a JDBC mode;
s2.3.3.5, after obtaining the business data ResultSet of JDBC specification, processing different field types, and converting the format of ResultSet into json format;
s2.3.3.6, and returns the data to the container page.
5. The high-flexibility reporting method of claim 3, wherein: in S2.3.5, the method for mapping and displaying the number map comprises the following steps:
s2.3.5.1, after the data is taken, the format available for the data structure scheme is modified again by calling the method of _ setData;
s2.3.5.2, the data after format conversion is delivered to the shape scheme executor to be displayed as corresponding graph, table or custom effect.
6. A high-flexibility reporting system, comprising:
the configuration module is used for developing the plug-in;
and the display module is used for processing the report in the single report using process by the user.
7. The utility model provides a high flexibility report device which characterized in that: comprising a processor, a memory and a computer program stored in said memory and running on said processor, said processor implementing the steps of the high-flexibility reporting method according to any of claims 1-5 when executing said computer program.
8. A computer-readable storage medium, wherein at least one program is stored in the storage medium, and the at least one program is executed by the processor to implement the steps of the high-flexibility reporting method according to any one of claims 1-5.
CN202010260754.6A 2020-04-03 2020-04-03 High-flexibility reporting method and system Active CN111476010B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010260754.6A CN111476010B (en) 2020-04-03 2020-04-03 High-flexibility reporting method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010260754.6A CN111476010B (en) 2020-04-03 2020-04-03 High-flexibility reporting method and system

Publications (2)

Publication Number Publication Date
CN111476010A true CN111476010A (en) 2020-07-31
CN111476010B CN111476010B (en) 2022-12-06

Family

ID=71749784

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010260754.6A Active CN111476010B (en) 2020-04-03 2020-04-03 High-flexibility reporting method and system

Country Status (1)

Country Link
CN (1) CN111476010B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113419733A (en) * 2021-07-02 2021-09-21 北京轨道交通技术装备集团有限公司 User interface rendering method and device in rail transit industry and electronic equipment

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101247620A (en) * 2008-03-24 2008-08-20 中兴通讯股份有限公司 Method for realizing user-defined report forms
US7640496B1 (en) * 2003-10-31 2009-12-29 Emc Corporation Method and apparatus for generating report views
CN106503202A (en) * 2016-10-26 2017-03-15 广州市勤思网络科技有限公司 The Dynamic Configuration that a kind of data drawing list linkage shows
CN107491427A (en) * 2017-06-08 2017-12-19 北京小度信息科技有限公司 Data sheet processing method and processing device

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7640496B1 (en) * 2003-10-31 2009-12-29 Emc Corporation Method and apparatus for generating report views
CN101247620A (en) * 2008-03-24 2008-08-20 中兴通讯股份有限公司 Method for realizing user-defined report forms
CN106503202A (en) * 2016-10-26 2017-03-15 广州市勤思网络科技有限公司 The Dynamic Configuration that a kind of data drawing list linkage shows
CN107491427A (en) * 2017-06-08 2017-12-19 北京小度信息科技有限公司 Data sheet processing method and processing device

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113419733A (en) * 2021-07-02 2021-09-21 北京轨道交通技术装备集团有限公司 User interface rendering method and device in rail transit industry and electronic equipment

Also Published As

Publication number Publication date
CN111476010B (en) 2022-12-06

Similar Documents

Publication Publication Date Title
CN104778241B (en) A kind of report form generation method and system
CN106528129B (en) A kind of Web application interface generation system and method
US7475080B2 (en) Adaptive data warehouse meta model method
US7707490B2 (en) Systems and methods for flexible report designs including table, matrix and hybrid designs
CN109597954A (en) Data item methods of exhibiting, calculates equipment and medium at device
CN106557457B (en) QT-based system for automatically generating cross-platform complex flow chart
US20210406981A1 (en) Method and apparatus of determining display page, electronic device, and medium
US9304746B2 (en) Creating a user model using component based approach
CN110532041A (en) Regulation engine method for parameter configuration, device, computer equipment and storage medium
US20150317336A1 (en) Data reconstruction
CN114707474A (en) Report generation method and device, electronic equipment and computer readable storage medium
CN111476010B (en) High-flexibility reporting method and system
CN104199648B (en) A kind of General Mobile information system adaptation method and device
CN111078564B (en) UI test case management method, device, computer equipment and computer readable storage medium
CN112527918A (en) Data processing method and device
CN109471904B (en) Method and system for organizing labels
US8711142B2 (en) Visual model importation
CN110968679A (en) Data query method and device
CN111680478B (en) Report generation method, device, equipment and storage medium based on configuration software
CN101159049A (en) Dynamic configuring arrange method and system
CN115187330A (en) Product recommendation method, device, equipment and medium based on user label
CN115718825B (en) Method and device for determining duration label and electronic equipment
CN113407164B (en) Software code generation method and system based on mind map and tree structure technology
CN112259099B (en) Task processing method and device based on voice interaction and storage medium
Stackowiak et al. Analyzing and Visualizing Data in Azure

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
CB02 Change of applicant information

Address after: 361000 unit 404, No. 24, guanri Road, phase II, software park, Xiamen, Fujian

Applicant after: XIAMEN ZHIYE SOFTWARE ENGINEERING CO.,LTD.

Address before: 361000 No.24 guanri Road, Siming District, Xiamen City, Fujian Province

Applicant before: XIAMEN ZHIYE SOFTWARE ENGINEERING CO.,LTD.

CB02 Change of applicant information
GR01 Patent grant
GR01 Patent grant