CN114117297A - Development method and query system for page dynamic display and multi-dimensional analysis query - Google Patents

Abstract

The application discloses a development method and a query system for page dynamic display and multi-dimensional analysis query. The method can comprise the following steps: configuring a data source; creating a table on the display page; setting attributes for the cells; and configuring a query link on the presentation page. According to the invention, page dynamic display and multi-dimensional analysis query are realized through visual interface design and configuration, program codes are not required to be compiled for function development, a powerful account table function can be rapidly and flexibly designed, the development efficiency is greatly improved, and the cost is reduced.

Description

Development method and query system for page dynamic display and multi-dimensional analysis query

Technical Field

The invention relates to the field of software generation, in particular to a development method and a query system for page dynamic display and multi-dimensional analysis query.

Background

The account table function is an indispensable function in an information system, and the user requirement is an essential requirement of the account table of the current user according to various dimension statistical analysis and quick and flexible realization. In the development, it is essential to analyze the query page, including the query of a common data table, the statistical analysis query of different dimensions of multiple tables, and the combined analysis query of multiple query conditions, including the column to be displayed in the account table, and the user can decide the display and the hiding of the column.

Generally speaking, there are two implementations of developing an account table:

the first is to implement a common ledger sheet by writing codes, and the following description will take B/S project developed by JAVA as an example.

To develop a query function, firstly, a front-end page is established, and data and query conditions are displayed in the page;

secondly, creating JAVA classes, coding to realize service logic, and compiling SQL query statements to perform database query;

then, the front-end page is connected with the background JAVA code, and unified debugging is carried out;

finally, the accounting function can be completed through various tests.

The second method is realized by configuring the relationship among pages, data tables and data tables by means of a third-party account table tool;

for many requirements of complex business logic, the requirements cannot be realized only through configuration, and the requirements need to be assisted through writing codes, so that even if the freedom degree and the flexibility of the configured query conditions are not high, the user experience is not good.

This development process obviously takes a lot of time and cost, and the development and delivery of the functions to the customers cannot be completed quickly.

The functions are completed according to the requirements of the clients, the clients are inevitably required to be modified after experience, for example, the clients require to increase the dimension of statistics or adjust the dimension sequence to dynamically display, and developers must complete through modifying codes and SQL sentences or adjust the configuration of the account table through an account table tool to meet the requirements of the clients.

Therefore, research and development personnel inevitably spend a great deal of time and energy in the research and development process, and in a short time, the good experience of the client is influenced, and the information cannot be delivered to the client.

Therefore, there is a need for developing a method and a system for developing a dynamic page display and multidimensional analysis query.

The information disclosed in this background section is only for enhancement of understanding of the general background of the invention and should not be taken as an acknowledgement or any form of suggestion that this information forms the prior art already known to a person skilled in the art.

Disclosure of Invention

The invention provides a development method and a query system for page dynamic display and multi-dimensional analysis query, which can rapidly realize page dynamic display and multi-dimensional analysis query through visual interface design and configuration, and can generate dynamic query functions of configuring common conditions, self-selecting high-grade conditions, self-defining multi-dimension, freely appointing subtotals of columns, totaling and calculating columns by a user.

In a first aspect, an embodiment of the present disclosure provides a method for developing a page dynamic display and a multidimensional analysis query, including:

configuring a data source;

creating a table on the display page;

setting attributes for the cells;

and configuring a query link on the display page.

Preferably, the data source comprises a system preset variable data set and a service data set.

Preferably, a Sql statement is configured in the system preset variable data set.

Preferably, the Sql statement uses left join to perform data table left association, supporting aos variables.

Preferably, the system preset variables in the system preset variable data set are configured in the sql query condition for service isolation.

Preferably, creating the table on the presentation page includes:

and according to business needs, creating the table through the number of rows and columns, wherein the table comprises the header data of the 1 st behavior table and the 2 nd behavior data set data.

Preferably, setting the attributes for the cells includes:

setting cell type, data expansion direction and display format.

Preferably, the query link is configured on the presentation page:

setting condition fields including display names, data types and control types of the specified fields;

and establishing a corresponding instruction relation function between the condition field and the query link.

As a specific implementation of the embodiments of the present disclosure,

in a second aspect, the embodiment of the present disclosure further provides a system for dynamically displaying pages and performing multidimensional analysis and query, which is generated by the development method for dynamically displaying pages and performing multidimensional analysis and query.

The method and apparatus of the present invention have other features and advantages which will be apparent from or are set forth in detail in the accompanying drawings and the following detailed description, which are incorporated herein, and which together serve to explain certain principles of the invention.

Drawings

The above and other objects, features and advantages of the present invention will become more apparent by describing in more detail exemplary embodiments thereof with reference to the attached drawings, in which like reference numerals generally represent like parts.

FIG. 1 shows a flowchart of the steps of a method for the development of a page dynamic presentation and multidimensional analysis query, according to one embodiment of the invention.

FIG. 2 shows a schematic diagram of creating a table according to one embodiment of the invention.

FIG. 3 illustrates a schematic diagram of query condition control specification, according to one embodiment of the invention.

FIG. 4 shows a schematic diagram of a query condition configuration according to one embodiment of the invention.

FIG. 5 shows a schematic diagram of an "advanced" key according to one embodiment of the invention.

FIG. 6 shows a schematic diagram of a "Format" key in accordance with one embodiment of the present invention.

FIG. 7 shows a schematic diagram of a "subtotal" key in accordance with one embodiment of the present invention.

FIG. 8 shows a schematic diagram of a generated ledger sheet, according to one embodiment of the invention.

Detailed Description

Preferred embodiments of the present invention will be described in more detail below. While the following describes preferred embodiments of the present invention, it should be understood that the present invention may be embodied in various forms and should not be limited by the embodiments set forth herein.

Example 1

FIG. 1 shows a flowchart of the steps of a method for the development of a page dynamic presentation and multidimensional analysis query, according to one embodiment of the invention.

As shown in fig. 1, the present invention provides a method for developing a page dynamic display and a multidimensional analysis query, including: step 101, configuring a data source; 102, creating a table on a display page; 103, setting attributes for the cells; step 104, configuring the inquiry link on the display page.

In one example, the data sources include a system preset variable data set and a business data set.

In one example, the Sql statement is configured in a system preset variable dataset.

In one example, the Sql statement uses a left join for data table left association, supporting aos variables.

In one example, the system preset variables in the system preset variable data set are configured in sql query conditions for service isolation.

In one example, creating a form at a presentation page includes:

and creating a table according to business needs by the number of rows and columns, wherein the table comprises the header data of the 1 st behavior table and the 2 nd behavior data set data.

In one example, setting attributes for a cell includes:

setting cell type, data expansion direction and display format.

In one example, a query link is configured at the presentation page:

setting condition fields including display names, data types and control types of the specified fields;

and establishing a corresponding instruction relation function for the condition field and the query link.

Specifically, the method for developing page dynamic display and multi-dimensional analysis query according to the invention comprises the following steps: step 101, configuring a data source; 102, creating a table on a display page; 103, setting attributes for the cells; step 104, configuring the inquiry link on the display page.

Configuring a data source: the data source of the system supports two data sets including a system preset variable data set and a service data set, the system can preset the system preset variable data set during creation, and a user only needs to preset the service data set.

The method comprises the steps that Sql sentences are configured in a system preset variable data set, and the Sql query sentences can be simple queries and complex queries; the query may be a single table query or a multi-table association query, as long as the query is a standard sql statement and supports aos variables.

The Sql statement uses a standard Sql statement, and left join is used for carrying out data table left association; assigning an alias to the data table; it is proposed to assign a Chinese alias to the column of data on select.

The system preset variables are generally configured in sql query conditions, and isolated use of services is performed, for example, using "financial organization" isolation and "user" isolation.

The use mode is that the system variables are added firstly, and the added variables are displayed in a list.

FIG. 2 shows a schematic diagram of creating a table according to one embodiment of the invention.

Creating a table on the presentation page: creating a table according to the number of rows and columns according to the business needs; the title data of the general 1 st behavior table and the 2 nd behavior data set data are shown in fig. 2.

Set attributes for the cells: and setting attributes for each unit, and assigning values.

The method comprises the steps of selecting a cell to be set currently, setting attributes, setting cell types (most commonly used are texts and expressions), data types (text types and numerical types), data expansion directions and formatting (mainly used for date type display formats, decimal accuracy and the like), and also supporting setting of a left father cell and an upper father cell and setting of expressions.

FIG. 3 illustrates a schematic diagram of query condition control specification, according to one embodiment of the invention.

FIG. 4 shows a schematic diagram of a query condition configuration according to one embodiment of the invention.

Configuring a query link on a display page: setting condition fields including display names, data types and control types of the specified fields; the field for setting the condition is derived from the column queried in the 2 nd data set of the data source, and a corresponding instruction relation function is established between the condition field and the query link, as shown in fig. 3 and 4.

The inquiry function comprises five parts:

1) common key

The conditions are set and rendered in the common query.

FIG. 5 shows a schematic diagram of an "advanced" key according to one embodiment of the invention.

2) Advanced key

The high-level condition is a very flexible query, and any field of all data tables in the sql statement of the data source configuration can be used as a query condition. Multiple fields can be selected for querying, any logical combination can be made, and operators (larger than, smaller than, equal to, fuzzy matching, intervening, null, non-null) can be freely selected, as shown in fig. 5.

FIG. 6 shows a schematic diagram of a "Format" key in accordance with one embodiment of the present invention.

3) The "format" button, as shown in FIG. 6:

3.1) display name: the user can set the display name by himself;

3.2) summarization: setting fields for grouping;

3.3) grade: not all tables have grades, and the tables aps _ level _ setting are configured in a grading way;

3.4) Total: only the numerical column can be set to total; at least one numerical field is marked with a cross-check, and the 'total' appears in the last line;

3.5) subtotal: the subtotal can be set only by the numerical value column, and the subtotal can be effective only when used together with the setting of '4) subtotal', or can be used together with the summary field;

3.6) precision: only the numeric field can be set;

3.7) alignment: left alignment, center alignment, right alignment;

3.8) shows: the default is display, and the opposite hook is removed, so that the display is not performed;

3.9) sorting: ascending, descending and not sorting;

3.10) condition setting: and rendering according to a specified style according to the set condition.

FIG. 7 shows a schematic diagram of a "subtotal" key in accordance with one embodiment of the present invention.

4) The "subtotal" button, as shown in FIG. 7:

the method is used together with the summary and subtotal in the format;

the effective precondition is as follows:

the fields configured in the subtotal are marked with a check corresponding to the summary column

In the fields configured in the subtotal, at least one field in the 'subtotal' column is checked.

5) 'calculate column' key

The columns generated by the data source are limited to numerical columns, and new columns generated by operators (addition, subtraction, multiplication and division) are displayed on the page. After the addition is completed, the data is automatically added into a 'format' data list.

The "common" button, "advanced" button, "format" button, "subtotal" button, "calculation column" button, i.e. the above 5 buttons, can be stored into different combination inquiry schemes, like a custom account table.

The embodiment of the disclosure also provides a system for dynamically displaying the page and analyzing and querying the multiple dimensions, which is generated by the development method for dynamically displaying the page and analyzing and querying the multiple dimensions.

FIG. 8 shows a schematic diagram of a generated ledger sheet, according to one embodiment of the invention.

Through a visual configuration ledger sheet parsing process:

1) querying a data set of a data source;

2) acquiring SQL sentences from a system preset variable data set of a data source;

3) detecting whether the SQL is configured with a system variable, if so, acquiring a value of the system variable, and analyzing and assembling the value on the SQL;

4) acquiring high-level data, and assembling the high-level data on SQL according to field names, condition values, data types, operational characters and logical operators;

5) acquiring 'common' condition data, and analyzing and assembling the upper surface of the SQL outermost layer;

6) acquiring data of 'format' and 'subtotal' to dynamically generate a table through a js method and dynamically generate a data object consistent with an account table configurator for a cell;

7) sending the SQL generated in the step 5) into an actuator for execution to generate a query result;

8) and (4) performing back-end processing on the query result generated in the step (7) and sending the query result to a report renderer for processing, wherein the processing result is displayed on an interface, as shown in fig. 8.

The configuration of the account table can be performed by those skilled in the art according to specific situations.

It will be appreciated by persons skilled in the art that the above description of embodiments of the invention is intended only to illustrate the benefits of embodiments of the invention and is not intended to limit embodiments of the invention to any examples given.

Having described embodiments of the present invention, the foregoing description is intended to be exemplary, not exhaustive, and not limited to the embodiments disclosed. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the described embodiments.

Claims (9)

1. A development method for page dynamic display and multi-dimensional analysis query is characterized by comprising the following steps:

configuring a data source;

creating a table on the display page;

setting attributes for the cells;

and configuring a query link on the display page.

2. The method for page dynamic presentation and multi-dimensional analytical query development according to claim 1, wherein the data sources include system preset variable data sets and business data sets.

3. The method for page dynamic presentation and multi-dimensional analytical query development according to claim 2, wherein a Sql statement is configured in the system preset variable dataset.

4. The method for developing page dynamic display and multidimensional analysis query as claimed in claim 3, wherein said Sql statement uses left join to make data table left association, supporting aos variable.

5. The method for page dynamic display and multi-dimensional analysis query development according to claim 3, wherein the system preset variables in the system preset variable data set are configured in sql query conditions for service isolation.

6. The method for page dynamic presentation and multi-dimensional analysis query development of claim 1, wherein creating a table on a presentation page comprises:

and according to business needs, creating the table through the number of rows and columns, wherein the table comprises the header data of the 1 st behavior table and the 2 nd behavior data set data.

7. The method for page dynamic presentation and multi-dimensional analytical query development according to claim 1, wherein setting attributes for cells comprises:

setting cell type, data expansion direction and display format.

8. The method for developing page dynamic presentation and multidimensional analysis query of claim 1, wherein, the query link is configured on the presentation page:

setting condition fields including display names, data types and control types of the specified fields;

and establishing a corresponding instruction relation function between the condition field and the query link.

9. A system for dynamically displaying pages and analyzing and querying in multiple dimensions, which is generated according to the development method of the dynamically displaying pages and analyzing and querying in multiple dimensions of any one of claims 1 to 8.

Images