CN112036118A - Configurable dynamic data report display method and system - Google Patents
Configurable dynamic data report display method and system Download PDFInfo
- Publication number
- CN112036118A CN112036118A CN202010630267.4A CN202010630267A CN112036118A CN 112036118 A CN112036118 A CN 112036118A CN 202010630267 A CN202010630267 A CN 202010630267A CN 112036118 A CN112036118 A CN 112036118A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- data report
- displayed
- cells
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 30
- 238000004458 analytical method Methods 0.000 claims abstract description 120
- 238000011049 filling Methods 0.000 claims abstract description 7
- 238000004364 calculation method Methods 0.000 claims description 62
- 238000011068 loading method Methods 0.000 claims description 15
- 238000001914 filtration Methods 0.000 claims description 3
- 239000011159 matrix material Substances 0.000 description 9
- 230000001351 cycling effect Effects 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 238000003825 pressing Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000009191 jumping Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/103—Formatting, i.e. changing of presentation of documents
- G06F40/106—Display of layout of documents; Previewing
-
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Digital Computer Display Output (AREA)
Abstract
The invention discloses a configurable dynamic data report showing method and a configurable dynamic data report showing system, which belong to the field of computer system data processing and aim to solve the technical problems of how to realize flexible configuration of a user on a data report showing mode, how to flexibly store the shown data and facilitating data access. The method comprises the following steps: configuring basic elements and a data report display mode; constructing a data set according to the configured basic elements; carrying out change processing on the data report according to the configured basic elements and the configured data report display mode, and filling data to be displayed into the data report after the change processing; and storing each piece of displayed data and the corresponding data position information as a piece of data. The system comprises a background configuration module, a report analysis module, a storage analysis module and a database.
Description
Technical Field
The invention belongs to the field of computer system data processing, and particularly relates to a configurable dynamic data report display method and system
Background
In current enterprise-level applications, data dominates, but common lists and forms are difficult to complete the display work of large data volume, and thus a data report form is required to complete the work.
When a common data report displays data, the selected data report is a fixed header, that is, the number of data columns displayed in the data report is specified in advance, so that dynamic expansion of rows and columns in the data report cannot be realized in a configuration mode. And a common data report has certain difficulty in data storage, and the data report and the data are often stored together, and the data cannot be extracted and used independently.
Based on the above problems, how to implement a display mode in which a user flexibly constructs a data report in a configuration mode, and can flexibly store data after the data is displayed, which is convenient for data extraction and utilization, is a technical problem to be solved.
Disclosure of Invention
The technical task of the invention is to provide a configurable dynamic data report display method and a configurable dynamic data report display system aiming at the defects, so as to solve the problems of how to realize flexible configuration of a data report display mode by a user, how to flexibly store the displayed data and convenience for data access.
The technical scheme adopted by the invention for solving the technical problems is as follows:
a configurable dynamic presentation method for data reports comprises the following steps:
configuring basic elements and a data report display mode, wherein the data display mode can be controlled by configuring the basic elements, the data display mode comprises data display rules, data classification and data position information, the extended area type in the data report can be controlled by configuring the data report display mode, and the extended area type in the data report comprises changed cells, row change, column change and fixed cells;
constructing a data set according to the configured basic elements, wherein the data set comprises data to be displayed;
carrying out change processing on the data report according to the configured basic elements and the configured data report display mode, and filling data to be displayed into the data report after the change processing;
and storing each piece of displayed data and the corresponding data position information as a piece of data.
Further, the base elements include:
the module is used for dividing different types of function frames, data objects, parameter objects and coding objects;
the function frame is used for identifying the data access list names, the incidence relation among the data access list names can be configured, and the function frame is attached to a certain template;
the data object is used for identifying the name and the data type of the number field in the data table, the data object belongs to a certain function frame, and each function frame can define a plurality of data objects;
the parameter object is used as a filtering condition when a user acquires data, the parameter object belongs to a certain function frame, and each function frame can define a corresponding parameter object;
and the coding object is used as a grouping condition when a user aggregates or groups data, the coding object belongs to a certain function frame, and one function frame can define a plurality of coding objects.
Further, the setting the configurable basic element before the configuring the basic element comprises:
creating a basic element information table, wherein the basic element information table comprises a module information table, a function frame table, a data object table, a parameter object table and a data column object table;
and establishing a flexible function, wherein the data information corresponding to the basic element information table is stored in the object information of the flexible function in a key value pair mode, and the flexible function can be loaded by a data display configuration interface.
Further, the basic element configuration and the data report form configuration display mode include:
loading a flexible function on a data display configuration interface and acquiring basic elements, configuring the basic elements according to configuration rules to generate a data result set, wherein each unit of the data result set is marked with a data display rule, a data classification and data position information corresponding to data to be displayed, and the configuration rules can form an access SQL statement for acquiring and formatting the data to be displayed;
traversing the data result set, and splitting the data result set into data matrixes;
the display mode of the configuration data report comprises the variable attributes of the configuration data report, the variable attributes of the data report comprise a fixed table and a variable table, the data report with the variable attributes being the variable table is a variable data report, the area variable attributes of the variable data report are configured, the area variable attributes of the variable data report comprise a fixed area and an extended area, the extended area type of the extended area is configured, and the extended area type of the variable data report comprises a variable cell, a row variable, a column variable and a fixed cell;
configuring formula type attributes of the data report cells, and configuring analysis formulas for the data report cells with formula type attributes as analysis formulas, wherein the analysis formulas comprise JSON format data matrixes corresponding to the data report cells, access SQL statements and display modes of configured data reports, and the analysis formulas can be loaded by a data report foreground.
Further, changing the data report according to the configured basic elements and the configured data report display mode, and filling the data to be displayed into the changed data report, including:
analyzing a data display mode of data to be displayed and generating a data result set, storing the data result set according to the variation type of the corresponding data report cell, if the data report cell is a fixed cell, storing the data result set as data information, and if the data report cell is a fixed cell, storing the data result set as variation data information;
judging the variable attribute of the data report, if the data report is a fixed table, maintaining the state of the data report, and if the data report is a variable table, deleting the extended rows and the extended columns of the data report;
and judging the variation type of the data report cells, if the data report cells are fixed cells, inserting the data to be displayed into the corresponding data report cells according to the data information, and if the data report cells are variable cells, performing variation processing on the data report cells according to the variable data information and inserting the data to be displayed into the corresponding data report cells subjected to variation processing.
Further, changing the data report table cell according to the changed data information, and inserting the data to be displayed into the changed corresponding data report table cell, including:
initializing a change area in a corresponding data report;
performing row-column expansion on the data table cells as the variation cells;
changing the names of the row and column coordinators of the data report cells and the names of the row and column coordinators of the variation areas in the data report;
circulating the data report cells and inserting the data to be displayed into the corresponding data report cells;
storing the changed data information and the format information into data information;
merging data table cells;
and modifying the editable state of all the data report cells in the data report.
Further, before performing change processing on the data report according to the configured basic elements and the configured data report display mode and filling the data to be displayed into the data report after the change processing, configuring a data report foreground, comprising:
configuring a background object, wherein the background object comprises a format storage object, a changed data list, an analysis formula list, a data object and a macro function, the format storage object is used for storing format information, the changed data list is used for storing changed data information, and the analysis formula list is used for storing an analysis formula;
the configured data report foreground can acquire and display background data, and the background data comprises data to be displayed and an analysis formula.
Further, configuring a data report foreground, further comprising:
setting a form calculation mode of the data report, wherein the form calculation mode of the data report comprises single-form calculation and table set calculation, if the form calculation mode of the data report is the single-form calculation, executing the single-form calculation, and if the form calculation mode of the data report is the table set calculation, circulating the data report and respectively performing the single-form calculation on each data report;
correspondingly, before the change attribute of the data report is judged, the form calculation mode of the data report is judged and selected.
And further, storing each piece of displayed data and the corresponding data position information as a piece of data, including storing the data to be displayed, the report number of the data report corresponding to the data to be displayed and the row-column coordinates of the data report cell corresponding to the data to be displayed to a database.
A configurable dynamic presentation system for data reports, comprising:
the background configuration module is used for supporting a user to configure basic elements and a data report display mode, forming an analysis formula and analyzing and calculating data to be displayed;
the report analysis module is used for carrying out dynamic change processing on the data report according to the analysis formula and presenting data to be displayed through the data report after the change processing;
the storage analysis module is used for storing each displayed data and the corresponding data position information as a piece of data;
and the database is used for storing background data, and the background data comprises but is not limited to data to be displayed, an analysis formula and data generated by the storage analysis module.
Compared with the prior art, the configurable dynamic data report display method and the configurable dynamic data report display system have the following beneficial effects:
1. the display mode of the data is controlled by the configuration element, and the display mode of the data report can be configured, so that the cells in the data report can be flexibly expanded, and the data can be displayed in a mode that a user wants to display;
2. after the data display is finished, the data and the data position information thereof are stored as a piece of data, and the data is not bound with the currently displayed data report, so that the data can be flexibly processed by a user.
Drawings
The invention is further described below with reference to the accompanying drawings.
FIG. 1 is a flow chart of a method for dynamically displaying a configurable data report according to embodiment 1;
fig. 2 is a basic element configuration interface of a data presentation configuration interface in a configurable data report dynamic presentation method according to embodiment 1;
FIG. 3 is a data object configuration interface of FIG. 2;
fig. 4 is a condition configuration interface of fig. 2.
Detailed Description
The configurable data report dynamic presentation method and system according to the present invention will be further described with reference to the accompanying drawings and specific embodiments.
Example 1:
as shown in fig. 1-4, the configurable dynamic data report display method of the present invention includes the following steps:
and S100, setting configurable basic elements, wherein the basic elements comprise modules, function frames, data objects, parameter objects and coding objects, and a user can control a data display mode through the configured basic elements, so that the configuration of the data display mode by the user is realized.
The module is used for dividing different types of function frames, data objects, parameter objects and coding objects; the function frame is used for identifying data access list names, the incidence relation among the data access list names can be configured, and the function frame is attached to a certain template; the data objects are used for identifying the names and data types of the number sections in the data table, the data objects belong to a certain function frame, and each function frame can define a plurality of data objects; the parameter object is used as a filtering condition when a user acquires data, the parameter object belongs to a certain function frame, and each function frame can define a corresponding parameter object; and the coding object is used as a grouping condition when a user aggregates or groups data, the coding object belongs to a certain function frame, and one function frame can define a plurality of coding objects.
The basic elements set in step S100 can be loaded and acquired by the data display configuration interface, so that the user can acquire the basic elements and configure the basic elements, and setting the configurable basic elements includes the following steps:
s101, creating a basic element storage table, wherein the basic element storage table comprises a module element storage table, a function frame storage table, a data object storage table, a parameter object storage table and a data column object storage table.
The structure of the module element storage table is shown in table 1, and the module element storage table can be added, deleted, modified and searched.
Table 1:
the structure of the function frame storage table is shown in table 2, and the function frame storage table can be subjected to adding, deleting, modifying and searching operations.
Table 2:
the structure of the data object storage table is shown in table 3, and the data object storage table can be added, deleted, modified and searched.
Table 3:
the structure of the parameter object storage table is shown in table 4, and the parameter object storage table can be added, deleted, modified and searched.
Table 4:
the structure of the data column object storage table is shown in table 5, and the data column object storage table can be subjected to adding, deleting, modifying and searching operations.
Table 5:
and S102, creating a flexible function which can be loaded by a data display configuration interface, wherein the data information corresponding to the basic element storage table is stored in the object information of the flexible function in a key-value pair mode.
The object information of the flexible function mainly has a four-level structure, wherein the first-level object is a report form object (reportTemplateObj) and is a common object, which is not described herein; the secondary object is a flexible function object (LhhsObject); the three-level objects are object lists, including a module list (MkList), a flexible function list (FuncList), a data object list (SjList), a parameter object list (CsList) and a data column object list (SjlList); the four-level objects are an object set and a list set, and comprise a module set (MkCollect), a flexible function set (FuncCollect), a data object set (SjCollect), a parameter object set (CsCollect) and a data column object set (SjlCollect), and a module list set (MkListCollect), a flexible function list set (FuncListCollect), a data object list set (SjListCollect), a parameter object list set (CsListCollect) and a data column object list set (SjlListCollect).
The second-level object flexible function object LhhsObject is a set object at the outermost layer of the flexible function, stores a module set, a flexible function set, a data object set, a parameter object set and a data column set related to the flexible function, and stores the second-level set object in the form of KEY VALUE pairs (KEY, VALUE), wherein KEY is the name of each set object, and VALUE is a set object.
And the three-level object module list MkList encapsulates the four-level object module set MkCollect and the module list set MkListCollect and stores four-level object information in a KEY VALUE pair (KEY, VALUE) form, wherein the KEY is respectively 'MkCollect' and 'MkListCollect', and the VALUE is a four-level object.
The three-level object flexible function list FuncList encapsulates the four-level object flexible function set FuncCollect and the flexible function list set FuncListCollect, and stores four-level object information in a KEY VALUE pair (KEY, VALUE) form, wherein the KEY is respectively 'FuncCollect' and 'FuncListCollect', and the VALUE is a four-level object.
And the three-level object data object list SjList encapsulates the four-level object data set SjCollect and the data list set SjListCollect and stores four-level object information in a KEY VALUE pair (KEY, VALUE) form, wherein the KEY is respectively 'SjCollect' and 'SjListCollect', and the VALUE is a four-level object.
And the three-level object parameter list CsList encapsulates the four-level object parameter set CsCollect and the parameter list set CSListCollect and stores four-level object information in a KEY VALUE pair (KEY, VALUE) form, wherein the KEY is respectively 'CsCollect' and 'CsListCollect', and the VALUE is a four-level object.
The three-level object data column list SjlList encapsulates the four-level object data column set SjlCollect and the data column list set MkListCollect, and stores four-level object information in the form of KEY VALUE pairs (KEY, VALUE), wherein the KEY is 'SjlCollect' and 'SjlListCollect' respectively, and the VALUE is a four-level object.
The four-level set object module set MkCollect stores all module information corresponding to the data table NFROOMK, and stores the module information in the form of KEY VALUE pairs (KEY, VALUE), where KEY is the module number and VALUE is the corresponding module object.
The four-level set object flexible function set FuncCollect stores all flexible function information corresponding to the data table NFROOFUNC, and stores the flexible function information in a KEY VALUE pair (KEY, VALUE) form, wherein the KEY is a character string formed by a module number and a function number, and the VALUE is a corresponding flexible function object.
The four-level set object data object set SjCollect stores all data object information corresponding to the data table NFROOSJDX and stores the data object information in a KEY VALUE pair (KEY, VALUE) form, wherein the KEY is a character string consisting of a module number, a function number and a data object number, and the VALUE is a corresponding data object.
A four-level set object parameter object set CsCollect for storing all parameter object information corresponding to the data table NFROOCS and storing the parameter object information in a KEY VALUE pair (KEY, VALUE) form; KEY is a character string consisting of module number, function number and parameter object number, and VALUE is a corresponding parameter object.
The four-level set object data column object set sjlCollect stores all data column object information corresponding to the data table NFROOSJL, and stores the data column object information in a KEY VALUE pair (KEY, VALUE) form, wherein the KEY is a character string consisting of a module number, a function number and a data column object number, and the VALUE is a corresponding data column object.
And a fourth-level set object flexible function list set FuncList Collection, which stores the flexible function lists under the modules and stores the flexible function lists in a KEY VALUE pair (KEY, VALUE) form, wherein the KEY is the module number, and the VALUE is a list formed by all the flexible functions under the corresponding modules.
A four-level set object data object list set SjListCollect which stores data object lists under various modules and functions and stores the data object lists in a KEY VALUE pair (KEY, VALUE) form; KEY is a character string consisting of a module number and a function number, and VALUE is a list consisting of all data objects under the corresponding modules and functions.
And a four-level set object parameter object list set CsListCollect for storing parameter object lists under each module and function, and storing the parameter object lists in a KEY VALUE pair (KEY, VALUE) form, wherein KEY is a character string formed by 'module number-function number', and VALUE is a list formed by all parameter objects under the corresponding module and function.
The four-level set object data column object list set SjlListColllect stores data column object lists under various modules and functions and stores the data column object lists in a KEY VALUE pair (KEY, VALUE) mode. KEY is a character string consisting of a module number and a function number, and VALUE is a list consisting of all data column objects under the corresponding module and function.
The first-level object is a report form sample object and is an existing report form raise structure, the structures of the second-level object, the third-level object and the fourth-level object are as shown in the attached figure 1, the flexible function object of the second-level object comprises the third-level object, the third-level object comprises a fourth-level object set and a fourth-level object list set, and object information is stored in the fourth-level object in a key value pair mode.
Step S200, configuring basic elements and a data report display mode, controlling the data display mode through the configured basic elements, wherein the data display mode comprises data display rules, data classification and data position information, controlling the type of an extended area in the data report through the configured data report display mode, and the type of the extended area in the data report comprises changed cells, row change, column change and fixed cells.
In step S200, executing a configuration basic element and a data report display mode on the data display configuration interface, where the step of configuring the basic element is: the data display configuration interface acquires and presents the basic elements by loading flexible functions, a user can flexibly configure the basic elements according to configuration rules to generate a data result set, the data result set comprises a plurality of units, each unit corresponds to data to be displayed, each unit corresponds to the data display rule, data classification and data position information of the data to be displayed, the configuration rules form access SQL statements for acquiring and formatting the data to be displayed, and the data result set is split to form a data matrix in a JSON format for facilitating loading and acquiring the data information in the data result set.
The method for configuring the display mode of the data report comprises the following steps: the configuration data report comprises the variable attributes of the configuration data report, the variable attributes of the data report comprise a fixed table and a variable table, the data report with the variable attributes being the variable table is a variable data report, the area variable attributes of the variable data report are configured, the area variable attributes of the variable data report comprise a fixed area and an extended area, the extended area type of the extended area is configured, and the extended area type of the variable data report comprises a variable cell, a line variable, a column variable and a fixed cell. The configured change type of the data report comprises a fixed cell and a change cell.
Configuring formula type attributes of the data report table cells, and configuring analysis formulas for the data report table cells with formula type attributes as analysis formulas, wherein the analysis formulas comprise JSON format data matrixes corresponding to the data report table cells, access SQL statements, variation attributes of configured data reports and variation types of the configured data report table cells, and the analysis formulas can be loaded by a data report table foreground; the data report table can be changed through an analysis formula. Therefore, dynamic change processing on the data report can be realized.
In this embodiment, a user obtains and configures a basic element through a data presentation configuration interface, and configures an analysis formula for a data report cell, so as to change and process the data report through the analysis formula, where configuring the basic element and configuring the analysis formula for the data report cell include the following operation procedures:
s210, configuring an analysis formula for the data table cells, and specifically comprising the following processes:
s211, checking whether the data table cell has logic of an analysis formula: obtaining formula type attributes of the data report table cells, wherein if the formula type attributes of the data report table cells are analysis formulas, the data report table cells correspond to the analysis formulas;
s212, double clicking the data report cell in the analysis formula state, checking whether an analysis formula is configured in the data report cell, if the analysis formula is configured in the data report cell, acquiring the analysis formula and loading the analysis formula into an analysis formula definition window, and if no analysis formula is in the data report cell, inputting the analysis formula into the data report cell;
s213, selecting the data cell and clicking an analysis formula definition button to check whether an analysis formula is configured in the data report cell, if the analysis formula is configured in the data report cell, obtaining the analysis formula and loading the analysis formula to an analysis formula definition window, and if no analysis formula is configured in the data report cell, adding the analysis formula.
S220, configuring an analysis formula definition interface, wherein the analysis formula definition interface is shown in the attached figure 2, and the specific operation flow is as follows:
s221, when configuring the analysis formula definition interface, acquiring and loading the following data from the background: self-defining object information of cover items, macro functions and flexible functions (including all modules, flexible functions, data objects, data column objects and parameter objects defined by the current unit, and a list set);
s222, if the data table cell is configured with an analysis formula, obtaining the analysis formula contained in the data table cell, and performing the following operations:
s222-1, acquiring a module defined by an analysis formula, and pointing to a corresponding record in a module list;
the specific operation flow comprises the following steps: acquiring all module information from a module set (MkCollect) of a flexible function object (LhhsObject), and loading the module information into a module selection drop-down box of an interface, such as an area (r) in FIG. 2;
s222-2, acquiring a flexible function corresponding to the analysis formula, pointing to a corresponding record in a flexible function list, acquiring a function description, an access list and default association conditions of the flexible function, and displaying the function description, the access list and the default association conditions in a dialog box;
the specific operation flow comprises the following steps: selecting a first module by default, acquiring a flexible function set corresponding to the module, and loading the flexible function set into a flexible function selection drop-down box of an interface; acquiring function description, a number taking table and default association conditions of the flexible functions, and displaying the function description, the number taking table and the default association conditions in a dialog box;
according to the selected module and flexible function, acquiring a data column object list from a data column object list set (BmListCollect) of flexible function objects (LhhsObject); the data column object list is rotated to see whether or not there is an object of "data column name" (data column number: "0000"), and if not, the object is added to the list. Displaying the data column object list in a dialog box, such as an area c in fig. 2;
s222-3, acquiring a data column object list according to a module and a flexible function corresponding to the analysis formula, then acquiring a row data column and a column data column of the analysis formula, circulating the data column object list, removing the row data column and the column data column in the analysis formula from the data column object list, and then respectively adding the data column object list and the column data column list to a dialog box;
the specific operation flow comprises the following steps:
as shown in fig. 2, there are three lists related to the data column objects in the analysis formula definition interface: the data column object list, the line list and the list, and the storage form of the data column object in the list: storing data column object information, whether data statistics and whether names are displayed or not in a key value pair mode;
when a data column object is added from the data column object list to the row/column list, the object is removed from the data column object list and added to the row/column list. When a data column object is removed from the row/column list, removing the data column object from the row/column list, and adding the data column object to the data column object list;
s222-4, acquiring data object information of the analysis formula, and loading the data object information into a data object list of the dialog box;
the specific operation flow comprises the following steps:
as shown in the area of fig. 2, the data objects of the analysis formula are shown in the data object list. When an add button or an edit button on the left side of the data object list is clicked, entering an edit data object interface, as shown in fig. 3;
when entering a dialog box for editing data objects, acquiring a data object list from a data object list set (SjListCollect) of flexible function objects (LhhsObject) according to the selected module and flexible functions, and loading the data object list into the data object list in the dialog box for editing data objects. Loading the data name and the data object of the selected data object into the data name and the data expression of the dialog box respectively;
monitoring is added to the data object list, and when items in the list are double-clicked, the data name and the data object of the selected item are added to the data name and the data expression of the dialog box respectively;
monitoring a 'confirm' button, if the 'confirm' button is added, forming a data object by the edited data name and the edited data expression, and adding the data object into a data object list of an analysis formula definition interface; if the data object is edited, acquiring a data object list of an analysis formula definition interface, and changing the selected data object information into an edited data name and a data expression;
s222-5, acquiring a data column object display format of the analysis formula, and modifying the selected states of display row/column names and display row/column aliases under the row data columns and the column data columns;
s222-6, acquiring conditions of the analysis formula, and displaying the conditions in a condition text box of the dialog box;
s222-7, acquiring the condition type of the analysis formula, and pointing to a corresponding record in a drop-down box on the right side of the data area;
the specific operation flow is as follows:
as shown in the area (v) of fig. 2, when the "guide" button is clicked, the "specify condition parameters" dialog box is entered, as shown in fig. 4;
when entering a dialog box with specified condition parameters under the condition of conditional conditions, analyzing the existing condition text, generating a condition list and loading the condition list into the dialog box;
when a button behind a comparison item is clicked, entering a flexible function condition parameter help dialog box, acquiring a parameter object list from a parameter object list set (CsListCollect) of a flexible function object (LhhsObject) according to a selected module and a flexible function, and displaying the parameter object list in the dialog box for selection;
when the button after the comparison value is clicked, entering a dialogue box of inquiring parameter help, acquiring all macro functions and cover self-defining items to form a parameter list, and displaying the parameter list in the dialogue box for selection;
when the 'insert row' button is clicked, adding a row in the condition list, and when the 'delete row' button is clicked, deleting the selected row in the condition list;
when the 'check' button is clicked, checking whether the assembly condition is legal or not, if not, prompting the reason, and if so, prompting that the inspection is passed;
when the 'confirm' button is clicked, automatically executing the 'check' operation, prompting a reason if the 'confirm' button is not matched, generating a condition character string from the assembled condition if the 'confirm' button is matched, and assigning the character string to a condition text box of an analysis formula definition interface;
s230, generating an analysis formula, wherein the specific operation flow is as follows:
s231, when the 'confirm' button of the analysis formula definition interface is clicked, an analysis formula is generated, and the following judgment is carried out:
the row and column data columns must both be defined, and if not, prompt "Please select row/column! ";
the data column object "data column name" must be on either the row data column or the column data column, and if not, it indicates "data column name must be on either the row or column! ";
the data object must have been defined and if not prompt "please select data field! ";
if there is a column object that selects "show statistics line" but no column object selects "do or not count", then the user prompts "please select the data field to be counted! ";
if there is a data object selected "whether to count" but no data column object selected "show count row", then prompt "please select the data column field to show count row! ";
s232, if the judgment is passed, executing the process of storing the analysis formula;
s233, when saving the analysis formula, saving the generated analysis formula information in the rpFxgsObj object of reporttesteboj, wherein the specific information saving format is as follows:
module information: the module number selected in the module list;
flexible function information: the flexible function numbers selected from the flexible function list;
row data column information and column data column information: each data column object is represented by a character string composed of "display statistic line" check boxes, ", data column object numbers," and "display name" check boxes, "1" indicates check box checking, and "0" indicates check box non-checking. For example, "1,1001, 0" indicates a data column object with a data column object number "1001", an execution line is displayed, and a data column name is not displayed. Multiple data column inter-object; "spacing;
data column setting: the checkboxes "display row name", "display row alias", "display column name", "display alias" constitute character strings, "1" indicates check, and "0" indicates uncheck. If the "0110" label indicates that "display row alias" and "display column name" are selected, "display row name" and "display column alias" are not selected;
the data object information is represented by a string of "whether or not to count" check boxes, "$", a data object number, "$", a data object result type, "$", and a data object name combination for each data object. "1" indicates check box check, "0" indicates check box unchecked, result type "S" indicates a string, and "D" indicates a numeric value. For example, "1 $0004$ D $ score" indicates that the number of the data object is "0004", the data is subjected to statistics, the result type is a numerical value, and the data object name is "score";
conditions are as follows: a string in a conditional dialog;
the statistical type is as follows: english identification of selected mode in statistical type drop-down box (average: AVG, SUM: SUM, MAX: MAX, MIN: MIN, number: COUNT, subtotal: XJ)
The structure of the analysis formula storage table at S234 is shown in table 6.
Table 6:
and S300, constructing a data set according to the configured basic elements, wherein the data set comprises data to be displayed and is stored in a database, and the data set can be used for analyzing and displaying data reports, and the data reports are loaded and acquired in a foreground.
And S400, configuring a data report foreground, including configuring background objects, wherein the configured data report can acquire and display background data, and the background data includes data to be displayed and an analysis formula. The background objects comprise a macro function, an analysis formula list FxgsList, a format object FormatSaveObject, a change data list BdzdList and a data object DataSaveObject, wherein the analysis formula list is used for storing analysis formulas, the format storage object is used for storing format information, and the change data list is used for storing change data information.
And S500, performing change processing on the data report according to the configured basic elements and the configured data report display mode, and filling the data to be displayed into the changed data report. The method specifically comprises the following operation flows:
step S510, analyzing a data display mode of data to be displayed and generating a data result set, storing the data result set according to the variation type of a corresponding data table cell, if the data table cell is a fixed cell, storing the data result set as data information, and if the data table cell is a fixed cell, storing the data result set as varied data information;
step S520, judging the variable attribute of the data report, if the data report is a fixed table, maintaining the state of the data report, and if the data report is a variable table, deleting the extended rows and the extended columns of the data report;
step S530, judging the variation type of the data report table cell, if the data report table cell is a fixed cell, inserting the data to be displayed into the corresponding data report table cell according to the data information, and if the data report table cell is a variation cell, performing variation processing on the data report table according to the variation data information and inserting the data to be displayed into the corresponding data report table cell after the variation processing.
Step S510 includes the following steps:
s511, loading an analysis formula, and acquiring data to be displayed according to the access SQL statement;
s512, creating a temporary data table, and temporarily storing data to be displayed through the temporary data table;
s513, analyzing the analysis formula and acquiring a data matrix in a JSON format;
s514, executing insert statement;
s515, executing a select statement;
s516, generating a data result set dataMap;
s517, judging the variation type of the data report table cell corresponding to the analysis formula, if the variation type of the data report table cell is a fixed cell, storing the data result set dataMap into a data object DataSaveObject, and if the data report table cell is a variation cell, storing the data result set dataMap into a variation data list BdzdList;
s518, deleting the temporary data table;
s519, obtaining and analyzing data information in the change list and the format object to generate data column information;
and S5110, loading the data object to the data report foreground.
In step S530, when the data report cell is a change cell, performing change processing on the data report according to the change data information, and inserting the data to be displayed into the corresponding data report after the change processing, the specific operation flow is as follows:
s531, initializing a change area in the corresponding data report;
s532, performing row-column expansion on the data report cells serving as the variation cells;
s533, changing the name of the row and column coordinatometer of the data report cell and the name of the row and column coordinatometer of the variation area in the data report;
s534, circulating the data report form cells and inserting the data to be displayed into the corresponding data report form cells;
s535, storing the changed data information and the format information into data information;
s536, merging the data table cells;
and S537, modifying the editable state of all the data report cells in the data report.
In this embodiment, a specific implementation step is given for performing row-column expansion on the changed cells and inserting the data to be displayed into the expanded data report when the data report is in the changed cell format, and the specific flow is as follows:
(1) pointing to the data report according to the object information of the changed data list BdzList;
(2) initializing coordinates of a data report change area;
(3) cycling each change cell;
(4) expanding rows and columns of the data report;
(5) changing the scale names of the extended rows and the extended columns of the data report;
(6) changing the name of the row and column scale of the changed data report;
(7) acquiring data position information of the data to be displayed, circulating data report form cells, and inserting the data to be displayed into corresponding data report form cells;
(8) storing the changed data information and the format information into a data object DataSaveObjext;
(9) merging data report cells;
(10) modify the editable state of all data table cells.
Step S600, storing each piece of displayed data and the corresponding data position information as a piece of data to form a data table information table, where the structure of the data table information table is shown in table 7.
Table 7:
in step S600, the data to be displayed, the report number of the data report corresponding to the data to be displayed, and the row-column coordinates of the data report cell corresponding to the data to be displayed are stored as a piece of data in the database.
In step S600, when the data location information is obtained, it is necessary to determine and analyze the change type of the data table cell corresponding to the display data and the change attribute of the data table cell, and the specific operation flow is as follows:
step (1), circulating a data report;
step (2), cycling the data report cells subjected to the change processing;
step (3), judging the variation type of the data report table cell, if the variation type of the data report table cell is a fixed cell, jumping out to be executed, and if the variation type of the data report table cell is a variation cell, executing the next step;
step (4), judging the variation attribute of the data report, if the data report is a variation table, executing step (5), and if the data report is a fixed table, executing step (7);
step (5), judging the expansion area of the data report table cell in the data report table, if the data report table cell is in the variation area in the data report table, executing step (10), if the data report table cell is in the non-variation area in the data report table, executing step (6);
step (6), acquiring a row scale of the data report cells, re-acquiring row coordinates, acquiring a column scale of the data report cells, and re-acquiring column coordinates;
step (7), acquiring row and column coordinates of the data report cells, namely acquiring position coordinate information of the data report cells;
step (8), report data is obtained, wherein the report data comprises the serial number of a data report, row and column coordinates of data report cells and data to be displayed;
step (9), adding the report data into the reportDataRootObject object, and then executing step (11);
step (10), acquiring a reportDataRootObject object, and then executing step (11);
step (11), transmitting the reportDataRootObject object to a database;
and (12) saving the information in the reportDataRootObject object into an NRPRWBBSJ information table.
Example 2:
this embodiment is a further improvement on embodiment 1, and the difference between this embodiment and embodiment 1 is: when the data report front is configured in step S400, a data report calculation mode is further configured, where the data report calculation mode includes single-table calculation and table-set calculation, when the data report calculation mode is the single-table calculation, the single-table calculation is performed on the current data report, and when the data report calculation mode is the table-set calculation, all the data reports are circulated and the single-table calculation is performed on each data report.
Accordingly, when step S500 is executed, the calculation method of the data report needs to be determined and selected. The specific step S500 includes the following steps:
step S510, analyzing a data display mode of data to be displayed and generating a data result set, storing the data result set according to the variation type of a corresponding data table cell, if the data table cell is a fixed cell, storing the data result set as data information, and if the data table cell is a fixed cell, storing the data result set as varied data information;
step S520, judging and selecting a form calculation mode of the data report;
step S530, judging the variable attribute of the data report, if the data report is a fixed table, maintaining the state of the data report, and if the data report is a variable table, deleting the extended rows and the extended columns of the data report;
and step S540, judging the variation type of the data report table cell, inserting the data to be displayed into the corresponding data report table cell according to the data information if the data report table cell is a fixed cell, and performing variation processing on the data report table cell according to the variation data information and inserting the data to be displayed into the corresponding data report table cell after the variation processing if the data report table cell is a variation cell.
Example 3:
a configurable dynamic data report display system comprises a background configuration module, a report analysis module, a storage analysis module and a database.
The background configuration module is used for supporting a display mode of a user configuration basic element and a data report, and forming an analysis formula according to the basic element configured by the user and the data display mode. The background configuration module interacts with a user through a data display configuration interface, the user can select and configure the display modes of the basic elements and the data report through the data display configuration interface, the background configuration module analyzes and calculates the configured display modes of the basic elements and the data report through an analysis and calculation unit of the background configuration module and generates an analysis formula, and the background configuration module acquires data to be displayed from a database through the analysis and calculation unit of the background configuration module and according to the configured basic elements and forms a data set.
The background configuration module forms the configuration rule into an access SQL statement through an analysis and calculation unit of the background configuration module, and the access SQL statement can be loaded and called by the report analysis module.
When a user configures basic elements through a data display configuration interface, the configured basic elements can form a data result set through an analysis and calculation unit, the data result set is split to form a data matrix, each unit in the formed data matrix comprises a data display rule, a data classification and data position information corresponding to data to be displayed, and the analysis and calculation unit converts the data matrix into a data matrix in a JSON format, wherein the data matrix can be loaded by a report analysis module.
Meanwhile, the analysis and calculation unit of the background configuration module analyzes and processes the configuration rule, the data matrix and the display mode of the configured data report to form an analysis formula which can be loaded by the report analysis module.
The report analysis module is connected with the database and used for displaying data through the data report.
The report analysis module interacts with the user through a data report foreground, presents the data report through a data report interface in the data report foreground, and presents data through the data report after change processing.
The report analysis module obtains the data to be displayed from the database through the calculation analysis module, analyzes the data to be displayed according to the analysis formula, and generates data information corresponding to the fixed cells and fluctuating data information corresponding to the fluctuating cells, so that calculation preparation before data report expansion is realized.
The report analysis module obtains the analysis formula, the data information and the changed data information through the data report foreground, carries out expansion processing on the data report according to the information and inserts the data to be displayed into the corresponding data report cell after the change processing.
The storage analysis module is connected with the database and used for storing each displayed data and the corresponding data position information as a piece of data.
And the database is used for storing background data, wherein the background data comprises data generated by the background analysis module, data generated by the report analysis module and data generated by the storage analysis module, such as a basic element information table, a data set, a data result set, a data matrix, a yarn-taking SQL statement, an analysis formula and the like.
By the configurable dynamic data report presentation system of the embodiment, the configurable dynamic data report presentation method disclosed in embodiment 1 can be implemented.
Example 4:
the present embodiment is a further improvement on the basis of embodiment 3, and the difference between the present embodiment and embodiment 3 is: the report analysis module has a form calculation function, and specifically, a form calculation subunit is arranged in a calculation analysis unit of the report analysis calculation module, the form calculation subunit can judge a form calculation mode of the data report and support a user to select the form calculation mode of the data report, wherein the form calculation mode of the data report comprises single-form calculation and table-set calculation, the single-form calculation is used for executing calculation of a single data report, and the table-set calculation is used for respectively executing the single-form calculation on all the data reports. Correspondingly, a form selection key is arranged in a data report interface of the data report foreground, the form selection key is respectively a single-label calculation key and a table sleeve calculation key, and a user selects single-label calculation by pressing the single-label calculation key and selects table sleeve calculation by pressing the table sleeve calculation key.
By the configurable dynamic data report presentation system of the embodiment, the configurable dynamic data report presentation method disclosed in embodiment 1 or embodiment 2 can be implemented.
The present invention can be easily implemented by those skilled in the art from the above detailed description. It should be understood, however, that the intention is not to limit the invention to the particular embodiments described. On the basis of the disclosed embodiments, a person skilled in the art can combine different technical features at will, thereby implementing different technical solutions. In addition to the technical features described in the specification, the technology is known to those skilled in the art.
Claims (10)
1. A configurable dynamic presentation method for data reports is characterized by comprising the following steps:
configuring basic elements and a data report display mode, wherein the data display mode can be controlled by configuring the basic elements, the data display mode comprises data display rules, data classification and data position information, the extended area type in the data report can be controlled by configuring the data report display mode, and the extended area type in the data report comprises changed cells, row change, column change and fixed cells;
constructing a data set according to the configured basic elements, wherein the data set comprises data to be displayed;
carrying out change processing on the data report according to the configured basic elements and the configured data report display mode, and filling data to be displayed into the data report after the change processing;
and storing each piece of displayed data and the corresponding data position information as a piece of data.
2. The method according to claim 1, wherein the basic elements include:
the module is used for dividing different types of function frames, data objects, parameter objects and coding objects;
the function frame is used for identifying the data access list names, the incidence relation among the data access list names can be configured, and the function frame is attached to a certain template;
the data object is used for identifying the name and the data type of the number field in the data table, the data object belongs to a certain function frame, and each function frame can define a plurality of data objects;
the parameter object is used as a filtering condition when a user acquires data, the parameter object belongs to a certain function frame, and each function frame can define a corresponding parameter object;
and the coding object is used as a grouping condition when a user aggregates or groups data, the coding object belongs to a certain function frame, and one function frame can define a plurality of coding objects.
3. The method according to claim 2, wherein the setting of the configurable base element before the configuration of the base element comprises:
creating a basic element information table, wherein the basic element information table comprises a module information table, a function frame table, a data object table, a parameter object table and a data column object table;
and establishing a flexible function, wherein the data information corresponding to the basic element information table is stored in the object information of the flexible function in a key value pair mode, and the flexible function can be loaded by a data display configuration interface.
4. The method according to claim 3, wherein the configuring of the basic elements and the configuring of the data report presentation mode comprise:
loading a flexible function on a data display configuration interface and acquiring basic elements, configuring the basic elements according to configuration rules to generate a data result set, wherein each unit of the data result set is marked with a data display rule, a data classification and data position information corresponding to data to be displayed, and the configuration rules can form an access SQL statement for acquiring and formatting the data to be displayed;
traversing the data result set, and splitting the data result set into data matrixes;
the display mode of the configuration data report comprises the variable attributes of the configuration data report, the variable attributes of the data report comprise a fixed table and a variable table, the data report with the variable attributes being the variable table is a variable data report, the area variable attributes of the variable data report are configured, the area variable attributes of the variable data report comprise a fixed area and an extended area, the extended area type of the extended area is configured, and the extended area type of the variable data report comprises a variable cell, a row variable, a column variable and a fixed cell;
configuring formula type attributes of the data report cells, and configuring analysis formulas for the data report cells with formula type attributes as analysis formulas, wherein the analysis formulas comprise JSON format data matrixes corresponding to the data report cells, access SQL statements and display modes of configured data reports, and the analysis formulas can be loaded by a data report foreground.
5. The method according to claim 4, wherein the step of performing change processing on the data report according to the configured basic elements and the configured data report display mode, and filling the data to be displayed into the changed data report comprises:
analyzing a data display mode of data to be displayed and generating a data result set, storing the data result set according to the variation type of the corresponding data report cell, if the data report cell is a fixed cell, storing the data result set as data information, and if the data report cell is a fixed cell, storing the data result set as variation data information;
judging the variable attribute of the data report, if the data report is a fixed table, maintaining the state of the data report, and if the data report is a variable table, deleting the extended rows and the extended columns of the data report;
and judging the variation type of the data report cells, if the data report cells are fixed cells, inserting the data to be displayed into the corresponding data report cells according to the data information, and if the data report cells are variable cells, performing variation processing on the data report cells according to the variable data information and inserting the data to be displayed into the corresponding data report cells subjected to variation processing.
6. The method according to claim 5, wherein the changing of the data report cells according to the changed data information and the inserting of the data to be displayed into the changed corresponding data report cells comprises:
initializing a change area in a corresponding data report;
performing row-column expansion on the data table cells as the variation cells;
changing the names of the row and column coordinators of the data report cells and the names of the row and column coordinators of the variation areas in the data report;
circulating the data report cells and inserting the data to be displayed into the corresponding data report cells;
storing the changed data information and the format information as data information;
merging data table cells;
and modifying the editable state of all the data report cells in the data report.
7. The method according to claim 5 or 6, wherein before the change processing is performed on the data report according to the configured basic elements and the configured data report display mode and the data to be displayed is filled in the changed data report, configuring a data report front stage, comprises:
configuring a background object, wherein the background object comprises a format storage object, a changed data list, an analysis formula list, a data object and a macro function, the format storage object is used for storing format information, the changed data list is used for storing changed data information, and the analysis formula list is used for storing an analysis formula;
the configured data report foreground can acquire and display background data, and the background data comprises data to be displayed and an analysis formula.
8. The method according to claim 7, wherein the step of configuring the data reporting foreground further comprises:
setting a form calculation mode of the data report, wherein the form calculation mode of the data report comprises single-form calculation and table set calculation, if the form calculation mode of the data report is the single-form calculation, executing the single-form calculation, and if the form calculation mode of the data report is the table set calculation, circulating the data report and respectively performing the single-form calculation on each data report;
correspondingly, before the change attribute of the data report is judged, the form calculation mode of the data report is judged and selected.
9. The method according to claim 8, wherein storing each of the data after being displayed and the corresponding data location information as a piece of data, comprises storing the data after being displayed, the report number of the data report corresponding to the data after being displayed, and the row and column coordinates of the data report cell corresponding to the data after being displayed as a piece of data in a database.
10. A configurable dynamic presentation system for data reports, comprising:
the background configuration module is used for supporting a user to configure basic elements and a data report display mode, forming an analysis formula and analyzing and calculating data to be displayed;
the report analysis module is used for carrying out dynamic change processing on the data report according to the analysis formula and presenting data to be displayed through the data report after the change processing;
the storage analysis module is used for storing each displayed data and the corresponding data position information as a piece of data;
and the database is used for storing background data, and the background data comprises but is not limited to data to be displayed, an analysis formula and data generated by the storage analysis module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010630267.4A CN112036118B (en) | 2020-07-03 | 2020-07-03 | Configurable data report dynamic display method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010630267.4A CN112036118B (en) | 2020-07-03 | 2020-07-03 | Configurable data report dynamic display method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112036118A true CN112036118A (en) | 2020-12-04 |
| CN112036118B CN112036118B (en) | 2024-01-26 |
Family
ID=73579486
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010630267.4A Active CN112036118B (en) | 2020-07-03 | 2020-07-03 | Configurable data report dynamic display method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112036118B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112434507A (en) * | 2020-12-10 | 2021-03-02 | 四川长虹电器股份有限公司 | Electronic bill generating method based on bill element configuration |
| CN112560413A (en) * | 2020-12-15 | 2021-03-26 | 中国人寿保险股份有限公司 | Report form expansion method, device and equipment based on configuration mode |
| CN114611478A (en) * | 2022-03-22 | 2022-06-10 | 孙向军 | Information processing method and system based on artificial intelligence and cloud platform |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| US20150154170A1 (en) * | 2013-12-02 | 2015-06-04 | G360Link, Inc. | Data collection and analysis tool |
| WO2017028611A1 (en) * | 2015-08-18 | 2017-02-23 | 中兴通讯股份有限公司 | Form implementation method and apparatus |
| CN111259104A (en) * | 2020-01-22 | 2020-06-09 | 山东浪潮通软信息科技有限公司 | Report data synchronization method and device capable of defining rules |
-
2020
- 2020-07-03 CN CN202010630267.4A patent/CN112036118B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| US20150154170A1 (en) * | 2013-12-02 | 2015-06-04 | G360Link, Inc. | Data collection and analysis tool |
| WO2017028611A1 (en) * | 2015-08-18 | 2017-02-23 | 中兴通讯股份有限公司 | Form implementation method and apparatus |
| CN111259104A (en) * | 2020-01-22 | 2020-06-09 | 山东浪潮通软信息科技有限公司 | Report data synchronization method and device capable of defining rules |
Non-Patent Citations (2)
| Title |
|---|
| 成红伦;裴奇;范瑞辉;: "如何实现SAP ERP财务报表的灵活定制", 电脑与电信, no. 11 * |
| 李辉;陈玉石;: "基于B/S架构的动态报表设计及实现", 科学家, no. 09 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112434507A (en) * | 2020-12-10 | 2021-03-02 | 四川长虹电器股份有限公司 | Electronic bill generating method based on bill element configuration |
| CN112560413A (en) * | 2020-12-15 | 2021-03-26 | 中国人寿保险股份有限公司 | Report form expansion method, device and equipment based on configuration mode |
| CN112560413B (en) * | 2020-12-15 | 2023-08-04 | 中国人寿保险股份有限公司 | Report form expansion method, device and equipment based on configuration mode |
| CN114611478A (en) * | 2022-03-22 | 2022-06-10 | 孙向军 | Information processing method and system based on artificial intelligence and cloud platform |
| CN114611478B (en) * | 2022-03-22 | 2022-11-11 | 广西电网有限责任公司 | Information processing method and system based on artificial intelligence and cloud platform |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112036118B (en) | 2024-01-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112036118A (en) | Configurable dynamic data report display method and system | |
| US6654744B2 (en) | Method and apparatus for categorizing information, and a computer product | |
| CN108664509B (en) | Method, device and server for ad hoc query | |
| CN106844190A (en) | test script automatic generation method and device | |
| US20030182296A1 (en) | Association candidate generating apparatus and method, association-establishing system, and computer-readable medium recording an association candidate generating program therein | |
| KR20140015812A (en) | Methodology of gis based automatic schematic diagram creation system for supporting input data generation of 1-dimensional water quality model | |
| CN111062520A (en) | Hostname feature prediction method based on random forest algorithm | |
| CN115859935A (en) | Data analysis report template generation system and method based on index library | |
| EP2348403A1 (en) | Method and system for analyzing a legacy system based on trails through the legacy system | |
| CN112214473A (en) | Data migration method and system between databases | |
| US7882114B2 (en) | Data processing method and data processing program | |
| CN116341059A (en) | Tunnel intelligent design method based on similarity | |
| JP4922644B2 (en) | Time series analysis program, time series analysis system, and time series analysis apparatus used therefor | |
| CN111737465A (en) | Method and device for realizing multi-level and multi-class Chinese text classification | |
| CN113609155A (en) | Test point rapid screening method, system and device for test flight data analysis | |
| CN113609698A (en) | Process reliability analysis method and system based on process fault database | |
| CN113221548A (en) | BOM table identification method and device based on machine learning, computer equipment and medium | |
| JP4351578B2 (en) | Production planning support system and computer program | |
| US20200042926A1 (en) | Analysis method and computer | |
| JPH10232874A (en) | Information processing know-how sharing method | |
| CN115860676A (en) | Automatic promotion recommending method and system for crop breeding materials | |
| CN115544985B (en) | Statistical chart making method, device, equipment and medium based on geographic computing language | |
| Firdaus et al. | Implementation of Document Management System using Levenshtein Distance Algorithm | |
| CN116167113B (en) | Automatic graph cutting method based on graph range | |
| CN117648339B (en) | Data exploration method and device, server and storage medium |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20231228 Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |