Visual chart and digital graph linkage configuration method and configuration system

Abstract

The invention belongs to the field of chart linkage configuration, and discloses a visual chart and digital chart linkage configuration method and a configuration system, which are used for reducing the workload of handwriting SQL (Structured Query Language) or scripts and greatly reducing the costs of development, debugging and maintenance by uniformly configuring a mapping relationship of'input control-query condition-chart display 'on a page. Due to logic configuration and visualization of linkage of query conditions, data ranges and charts, developers can more quickly modify or expand requirements, and quick iteration and agile response are realized. According to the method, the complex linkage logic is packaged on a visual configuration layer, so that direct operation on a database dynamic SQL or deep compiling of front-end calling logic is avoided, and the requirement on professional skills of developers is reduced.

Description

Technical Field

[0001] The present invention belongs to the field of chart linkage configuration, and specifically relates to a method for visual chart number-chart linkage configuration and a configuration system. Background Art

[0002] Under the changing market rules, higher requirements are put forward for the efficiency, flexibility, and agility of the human-machine interface of trading platforms, which are mainly reflected in: the business scope supported by the trading system has greatly increased, and new trading varieties and trading rules are constantly introduced. Objectively, it is required that the human-machine interface of the trading system can provide a fast, flexible, and configurable mechanism and tool for generating business screens in engineering, which can meet the needs of flexible and rapid generation of business display pages. The current power market trading system is built based on the B / S microservice architecture. For the front-end pages, a relatively traditional custom development mode is mainly adopted at present. Through standardized processes such as "requirement submission -> page design -> development -> debugging -> testing -> maintenance -> online", the front-end business pages are constructed or modified, resulting in disadvantages such as too long process, too slow demand response, and insufficient agility and tooling level.

[0003] The current human-machine interface of the power market operation system mainly constructs the front-end pages in a custom development manner. The traditional custom development mode can complete the page construction function, but this method causes that any change in business operations or page design will lead to the redevelopment of the custom page. Its agility and tooling level are insufficient, and its ability to quickly respond to changes in front-end requirements is poor, making it difficult to meet the actual needs of quickly generating various business pages in the power trading scenario. Summary of the Invention

[0004] The purpose of the present invention is to overcome the problems of insufficient agility and tooling level in the above traditional custom development mode, and provide a method for visual chart number-chart linkage configuration and a configuration system.

[0005] To achieve the above purpose, the present invention adopts the following technical solutions: In the first aspect, the present invention provides a method for visual chart number-chart linkage configuration, including the following steps: Create an input control graphic element on the page to be displayed, and configure the corresponding graphic element data code for the input control graphic element; Create a query button graphic element, select a dynamic SQL (Structured Query Language) of a trading data set, and disassemble it to obtain the query conditions of the dynamic SQL of the trading data set. Configure the SQL query conditions to be associated with the graphic element data code to generate a mapping relationship between the query conditions of the dynamic SQL of the trading data set and the corresponding graphic element data code; Generate the final trading data set query SQL according to the mapping relationship between the query conditions of the dynamic SQL of the trading data set and the corresponding graphic element data code; Create chart primitive elements of different types, configure different data ranges corresponding to the query result data sets for chart primitive elements of different types, associate the data ranges of the chart primitive elements with the query SQL of the final transaction data set, and complete the configuration of the visualization chart data-chart linkage.

[0006] A further improvement of the present invention is that the input control primitive element includes any one of an input text box, a time selection box, and a drop-down selection box.

[0007] A further improvement of the present invention is that a query button primitive element is established, a dynamic SQL of a transaction data set is selected, and the SQL query conditions are disassembled. The specific method for configuring the association between the dynamic SQL query conditions of the transaction data set and the primitive element data code to generate the mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding primitive element data code is as follows: Establish an input control primitive element; Select the corresponding dynamic SQL of the transaction data set according to the requirement, and disassemble the internal format of the statement of the dynamic SQL of the transaction data set; Configure the required internal format of the statement to be associated with the input control primitive element, and generate the mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding primitive element data code.

[0008] A further improvement of the present invention is that the chart primitive elements of different types include chart display primitive elements such as bar charts, pie charts, and line charts.

[0009] A further improvement of the present invention is that the data ranges corresponding to the chart primitive elements of different types include the X-axis data range and the Y-axis data range corresponding to the chart primitive elements of different types.

[0010] A further improvement of the present invention is that the specific method for creating chart primitive elements of different types, configuring different data ranges corresponding to the query result data sets for chart primitive elements of different types, associating the data ranges of the chart primitive elements with the query SQL of the final transaction data set, and completing the configuration of the visualization chart data-chart linkage is as follows: Analyze the chart primitive elements of different types to obtain the data ranges corresponding to the chart primitive elements of different types; Determine whether the data range is associated with the multi-series data set linkage code in the query SQL of the final transaction data set, and the data set linkage code is generated according to the different data ranges corresponding to the query result data sets; If the data range is not associated with the multi-series data set linkage code, read two columns of data within the data set query result range, form the corresponding single-series chart data, and perform chart visualization display; If the data range has been associated with the multi-series dataset linkage code, all data in the dataset query result is read to form corresponding multi-series chart data, and chart visualization is performed.

[0011] In a second aspect, the present invention provides a visualization chart data-chart linkage configuration system, including: A data control establishment module for establishing input control graphic elements on the page to be displayed and configuring corresponding graphic element data codes for the input control graphic elements; A database execution module for establishing a query button graphic element, selecting a dynamic SQL for a transaction dataset, disassembling the dynamic SQL query conditions of the transaction dataset, associating the SQL query conditions with the graphic element data codes, and generating a mapping relationship between the query conditions of the dynamic SQL of the transaction dataset and the corresponding graphic element data codes; A database generation module for generating a final transaction dataset query SQL according to the mapping relationship between the query conditions of the dynamic SQL of the transaction dataset and the corresponding graphic element data codes; A chart data-chart linkage module for creating different types of chart graphic elements, configuring different data ranges corresponding to the query result datasets for different types of chart graphic elements, and associating the data ranges of the chart graphic elements with the final transaction dataset query SQL to complete the visualization chart data-chart linkage configuration.

[0012] A further improvement of the present invention lies in that the specific function of the mapping relationship generation module is realized by the following method: Establish input control graphic elements; Select the corresponding dynamic SQL of the transaction dataset as required and disassemble the internal format of the dynamic SQL statement of the transaction dataset; Associate the required internal format of the statement with the input control graphic elements to generate a mapping relationship between the query conditions of the dynamic SQL of the transaction dataset and the corresponding graphic element data codes.

[0013] A further improvement of the present invention lies in that the specific function of the chart data-chart linkage module is realized by the following method: Analyze different types of chart graphic elements to obtain the data ranges corresponding to different types of chart graphic elements; Judge whether the data range is associated with the multi-series dataset linkage code in the final transaction dataset query result, and the dataset linkage code is generated according to different data ranges corresponding to the query result dataset; If the data range is not associated with the multi-series dataset linkage code, read two columns of data within the dataset query result range to form corresponding single-series chart data, and perform chart visualization; If a multi-series dataset linkage code is associated with the data range, all data within the query result range of the dataset is read to form corresponding multi-series chart data, and chart visualization is performed.

[0014] In a third aspect, the present invention provides an electronic device, including a memory and a processor. The memory stores a computer program, and when the processor executes the computer program, the steps of a visual chart data-chart linkage configuration method are implemented.

[0015] In a fourth aspect, the present invention provides a storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of a visual chart data-chart linkage configuration method are implemented.

[0016] Compared with the prior art, the present invention has the following beneficial effects: By uniformly configuring the mapping relationship of "input control - query condition - chart display" on the page, the present invention reduces the workload of writing SQL or scripts by hand, and significantly reduces the costs of development, debugging, and maintenance. Since the logic of linking query conditions, data ranges, and charts is configured and visualized, developers can modify or expand requirements faster, achieving rapid iteration and agile response. The present invention encapsulates complex linkage logic at the visual configuration level, avoiding direct operation of database dynamic SQL or in-depth writing of front-end call logic, and reducing the requirements for developers' professional skills. With the "what you see is what you get" style configuration of graphic element metadata codes and query conditions, non-professional developers can also easily get started, significantly improving the efficiency of team collaboration and cross-role collaboration. The present invention adopts the mode of "graphic element configuration - dynamic query - data range" to decouple logic from data sources. In the later stage, only modifications at the configuration level are required to achieve adjustments for front-end and back-end linkage. The unified configuration method makes the structure of the system clearer, facilitating later maintenance and function expansion, and reducing duplicate coding and invasive changes to system logic. In summary, the present invention links front-end chart display and back-end data dynamic query in a configured, componentized, and visualized manner, improving both development and maintenance efficiency, while also taking into account usability and scalability, effectively overcoming the problems of insufficient agility and tooling level in traditional custom development models. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] Figure 1 is a flowchart of Embodiment 1; Figure 2 is a system diagram of Embodiment 2; Figure 3 is a flowchart of Embodiment 6; Figure 4 is a structure diagram of Embodiment 6; Figure 5 is a system diagram of Embodiment 7. Detailed Implementation Modes

[0018] To further understand the content of the present invention, the present invention will be described in detail below with reference to the accompanying drawings and specific embodiments. It should be understood that the embodiments are only for explaining the present invention and not for limiting it.

[0019] Embodiment 1: Refer to Figure 1 , a method for visual chart and digital chart linkage configuration, comprising the following steps: S1. Establish an input control graphic element on the required display page, and configure the corresponding graphic element data code for the input control graphic element.

[0020] S2. Establish a query button graphic element, select a dynamic SQL of a transaction data set, disassemble the dynamic SQL query conditions of the transaction data set, configure the association between the SQL query conditions and the graphic element data code, and generate a mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding graphic element data code.

[0021] S3. Generate a final transaction data set query SQL according to the mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding graphic element data code.

[0022] S4. Create graphic elements of different types of charts, configure different data ranges corresponding to the query result data sets for the graphic elements of different types of charts, associate the data ranges of the chart graphic elements with the final transaction data set query SQL, and complete the visual chart and digital chart linkage configuration. Embodiment 2: Refer to Figure 2 , a visual chart and digital chart linkage configuration system, comprising: A data control establishment module, used to establish an input control graphic element on the required display page and configure the corresponding graphic element data code for the input control graphic element; A database execution module, used to establish a query button graphic element, select a dynamic SQL of a transaction data set, disassemble the dynamic SQL query conditions of the transaction data set, configure the association between the SQL query conditions and the graphic element data code, and generate a mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding graphic element data code; A database generation module, used to generate a final transaction data set query SQL according to the mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding graphic element data code; A chart and digital chart linkage module, used to create graphic elements of different types of charts, configure different data ranges corresponding to the query result data sets for the graphic elements of different types of charts, associate the data ranges of the chart graphic elements with the final transaction data set query SQL, and complete the visual chart and digital chart linkage configuration.

[0023] Embodiment 3: See Figure 3 , a method for configuring the linkage between a visual chart and a digital chart, comprising the following steps: First, create a blank business display page. On this basis, use an editing tool to create various types of input control primitives according to actual needs, such as input text boxes, time selection boxes, drop-down selection boxes, etc. The input control primitives can be moved freely to meet the aesthetic needs of the actual page layout.

[0024] Secondly, configure a primitive data code for each input control primitive. For example, the primitive data code of control A is configured as [CodeA], and the primitive data code of control B is configured as [CodeB].

[0025] Then, select a dynamic SQL definition of a transaction data set according to actual business needs, disassemble the internal format of the dynamic SQL statement of the transaction data set, and associate and set the parameter values in the query conditions of the dynamic SQL of the transaction data set as the primitive data codes of the aforementioned input primitives.

[0026] Thirdly, create a query button primitive, associate the click event of the query button primitive with the execution of the SQL instruction for loading and parsing the transaction dynamic data set, and save it in the response event of the query button after completion of the configuration.

[0027] Finally, create different types of chart primitives, such as bar charts, pie charts, line charts, etc. Configure the linkage codes for the query results of the data set according to the actual situation of the transaction business, and configure the data ranges of the data set query result table into the chart primitives in sequence. For example, {[X-axis data range]:[Y-axis data range]}. If the primitive requires multi-series data display, it is {[X-axis data range]:[Y-axis data range of series 1]:[Y-axis data range of series 2]}. Here, the multi-series data share the same X-axis data range.

[0028] After the above primitive association configuration is completed, save all the configuration information. Thus, the configuration process of the visual chart display page is completed. During subsequent browsing operations, after the data of the page is loaded, a chart query display page is generated according to the configuration information, and the matching of the page primitives with the associated data is completed to achieve linkage interaction.

[0029] Example 4: When in use, open the page, load all the input control primitives in the configuration page, and read the information of the input primitives and the primitive data codes; Create a query button, load the dynamic SQL definition of the transaction query data set associated with the above control primitives, and associate its click event with the parsing and loading of the relevant transaction dynamic data set query SQL; Create all defined chart - type graphic elements in the configuration screen, and read the linkage codes of the query results of the configured data set; Complete the content input of the input control graphic element. Click the query button. According to the mapping relationship of the graphic element data codes, generate the final transaction data set query SQL, submit it to the database for query, and form a relational two - dimensional table - like result set from the query - returned data result set; Process the data visualization display of the chart - type graphic elements according to the following rules: Rule 1: If the chart has no associated multi - series data set linkage code, read two columns of data within the query result range of the data set to form single - series chart data; Rule 2: If the chart is associated with a multi - series data set linkage code, read multiple columns of data within the query result range of the data set to form the corresponding multi - series chart data, and perform chart visualization display; When the input content of the input graphic element changes, repeat the above operations after re - querying to achieve the linkage interaction display of the screen graphic elements and data; Example 5: The specific implementation method of this example is as follows: The relationship [InputCodeCfg] between the input graphic element and the input value, the graphic element name and the graphic element data code form the following relationship linked list. The specific configuration description is as follows [InputCodeCfg] = {[Input Graphic Element 1]:[CodeA]; [Input Graphic Element 2]:[CodeB]; [Input Graphic Element 3]:[CodeC]...}; Obtain the relationship [QuerySQLCfg] between the query button and the execution of the dynamic SQL instruction of the transaction query data set. The specific configuration description is as follows [QuerySQLCfg] = [SQL command:{Condition 1:CodeA}:{Condition 2:CodeB}:...]; Obtain the data linkage strategy [DataRelateCfg] between the chart - type graphic element and the query result of the aforementioned data set. The specific configuration description is as follows [DataRelateCfg] = { [X - axis data range]:[Series 1 - Y - axis data range]:[ Series 2 - Y - axis data range]:...}, where if the data range description uses the following format definition [DataRange] = [R(start row number)C(specified column number)->R(end row number)C(specified column number)]; Configure the linkage relationship between each graphic element and each data configuration graphic element in different transaction scenarios: including saving the rule description texts of [InputCodeCfg], [QuerySQLCfg], and [DataRelateCfg] to the configuration graphic file. The configuration graphic browsing page reads the graphic file and loads the transaction display configuration screen configured above. The following parsing process is used to finally realize the whole process of mapping data to the actual chart-type graphic elements for display after querying the transaction data set: read [InputCodeCfg] to establish the relationship between the input graphic element and the input value, read [QuerySQLCfg] to establish the relationship between the query button and the execution of the dynamic SQL instruction of the transaction query data set, read [DataRelateCfg] to establish the data association strategy between the chart-type graphic element and the query result of the above data set. Complete the data input operation on the generated business query page, click the query button, obtain the final transaction data set query SQL according to [QuerySQLCfg] and [InputCodeCfg], and submit the database query to form a relational result set. Traverse each chart-type graphic element in turn. According to [DataRelateCfg], analyze the data result set association range and content inside the graphic element, and read the data within different data set ranges according to different single-series or multi-series association ranges to form the corresponding single-series or multi-series internal display elements of the chart.

[0030] Once the input content of the input graphic element changes, repeat the above parsing process to re-query and parse the display of the transaction data set, and finally realize the visual linkage interaction display of the visual chart of the dynamic transaction data set.

[0031] Example 6: See Figure 4 and Figure 5 This example describes the implementation steps of this method through a specific case: 1. Create a blank page in the human-machine configuration tool software, create the following graphic elements, and complete the position setting; Text input box control 1, and set its graphic element data code to {CodeA}; Drop-down selection box control 2, and set its graphic element data code to {CodeB}; Select a certain transaction data set SQL query command from the transaction query data set list according to the actual situation, [SQL command: {condition 1: CodeA}: {condition 2: CodeB}], in this example it is: [select time, power, electricity, profit and loss, area from query table name where profit and loss > {CodeA} and area!= {CodeB}]; 2. Create a query button and configure the following click event response operations for the query button: Configure the relationship between the query button and the dynamic SQL instruction of the transaction data set [QuerySQLCfg]. In this embodiment, [QuerySQLCfg] = [SQL command]: {Condition 1: CodeA}: {Condition 2: CodeB}:...]; 3. Create a pie chart and configure the data set query result linkage code for it. In this embodiment, {[R1C5->R5C5]: [R1C4->R5C4]}, which means: the association range of the X classification axis of the pie chart is from the first row to the fifth row of the area column of the two-dimensional result set, and the association range of the Y data axis of the pie chart is from the first row to the fifth row of the profit and loss column of the two-dimensional result set; 4. Create a line chart and configure the data set query result linkage code for it. In this instance, {[R1C1->R4C1]: [R1C2->R4C2]: [R1C3->R4C3]}, which means: the association range of the X time axis of the line chart is from the first row to the fourth row of the time column of the two-dimensional result set, the association range of the Y data axis of the curve of series 1 of the line chart is from the first row to the fourth row of the power column of the two-dimensional result set, and the association range of the Y data axis of the curve of series 2 of the line chart is from the first row to the fourth row of the electricity column of the two-dimensional result set; 5. After configuration, save all the configuration information in the scene of the configuration visualization chart into the database. The saved file name is the transaction display scene A.

[0032] 6. Start the human-machine configuration browsing page, load the transaction display scene A screen configured above, and complete the following steps to implement the parsing of the graphic data association relationship and complete the screen display and interaction process: Open the transaction configuration screen, load all the graphic elements in the created scene of the configuration file, including 2 input control graphic elements, and read the information of the graphic elements and the graphic element data codes, [Control 1]: [CodeA]; [Control 2]: [CodeB]; Load and parse the associated transaction query data set SQL command [select time, power, electricity, profit and loss, area from query table name where profit and loss > {1} and area!= {Beijing}], where CodeA is parsed as 1 and CodeB is parsed as Beijing here; Create a query button, read [QuerySQLCfg], and establish the relationship between the query button and the execution of the dynamic SQL instruction of the transaction query data set; Create an empty pie chart primitive, load the dataset query result linkage code, and the instance here is {[R1C5->R5C5]:[R1C4->R5C4]}; create an empty line chart primitive, load the dataset query result linkage code, and the instance here is {[R1C1->R4C1]:[R1C2->R4C2]:[R1C3->R4C3]}; Complete the content input of the input primitive, click the query button, and generate the final transaction dataset query SQL as [select time, power, electricity, profit and loss, area from query table name where profit and loss>{CodeA} and area!={CodeB}] according to the primitive data code mapping relationship, submit the database query, and form a two-dimensional data result set with the query results; Parse the dataset linkage code of the pie chart {[R1C5->R5C5]:[R1C4->R5C4]}. This is a single-series data. Read the range associated with the X category axis of the pie chart from the first row to the fifth row of the area column of the two-dimensional result set, and the range associated with the Y data axis of the pie chart from the first row to the fifth row of the profit and loss column of the two-dimensional result set; The data here is parsed as: {(Jiangsu, Shanghai, Zhejiang, Shandong, Guangdong): (45, 37, 48, 145, 39)}. Generate the internal elements of the pie chart according to this data for display; Parse the dataset linkage code of the line chart {[R1C1->R4C1]:[R1C2->R4C2]:[R1C3->R4C3]}. This is multi-series data. Read the range associated with the X time axis of the line chart from the first row to the fourth row of the time column of the two-dimensional result set. The range associated with the Y data axis of the first curve of the line chart series is from the first row to the fourth row of the power column of the two-dimensional result set, and the range associated with the Y data axis of the second curve of the line chart series is from the first row to the fourth row of the electricity column of the two-dimensional result set; The data here is parsed as: {(2023-4-1, 2023-4-2, 2023-4-3, 2023-4-4):(23, 2, 34, 56):(120, 12, 4, 55)}. Generate the internal elements of the two series of curves of the line chart according to this data for display; If the input content of the input primitive changes, repeat the above operations after re-querying to perform screen linkage interaction display.

[0033] Embodiment 7: Please refer to Figure 5 As shown, the present invention also provides an electronic device 100 for a visualization chart number chart linkage configuration method; the electronic device 100 includes a memory 101, at least one processor 102, a computer program 103 stored in the memory 101 and executable on the at least one processor 102, and at least one communication bus 104.

[0034] The memory 101 can be used to store the computer program 103, and the processor 102 implements the steps of a method for configuring a visual chart and digital graph linkage described in Example 1 by running or executing the computer program stored in the memory 101 and calling the data stored in the memory 101. The memory 101 can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, an application required for at least one function (such as a sound playback function, an image playback function, etc.), etc.; the data storage area can store data (such as audio data) created according to the use of the electronic device 100, etc. In addition, the memory 101 can include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (FlashCard), at least one disk storage device, a flash memory device, or other non-volatile solid-state storage devices.

[0035] The at least one processor 102 may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The processor 102 may be a microprocessor or any conventional processor, etc. The processor 102 is the control center of the electronic device 100, and uses various interfaces and lines to connect various parts of the entire electronic device 100.

[0036] The memory 101 in the electronic device 100 stores a plurality of instructions to implement a method for configuring a visual chart and digital graph linkage, and the processor 102 can execute the plurality of instructions to implement: Create an input control graphic element on the required display page, and configure the corresponding graphic data code for the input control graphic element; Create a query button element, select a transaction data set dynamic SQL, and disassemble the transaction data set dynamic SQL query conditions, configure the SQL query conditions to associate with the element data code, and generate a mapping relationship between the query conditions of the transaction data set dynamic SQL and the corresponding element data code; Generate the final transaction data set query SQL according to the mapping relationship between the query conditions of the transaction data set dynamic SQL and the corresponding metadata code; Create different types of chart primitives, configure different data ranges corresponding to the query result data sets for different types of chart primitives, associate the data ranges of the chart primitives with the query SQL of the final transaction data set, and complete the configuration of the digital chart linkage of the visualization chart.

[0037] Example 8: If the modules / units integrated in the electronic device 100 are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on such an understanding, to implement all or part of the processes in the above-described embodiment methods of the present invention, it can also be completed by a computer program instructing relevant hardware. The computer program can be stored in a computer-readable storage medium. When the computer program is executed by a processor, the steps of the above-described method embodiments can be implemented. Among them, the computer program includes computer program code, and the computer program code can be in the form of source code, object code, executable file, or some intermediate form, etc. The computer-readable medium can include: any entity or device that can carry the computer program code, recording medium, USB flash drive, mobile hard disk, magnetic disk, optical disk, computer memory, and read-only memory (ROM, Read-Only Memory).

[0038] Those skilled in the art should understand that the embodiments of the present invention can be provided as a method, a system, or a computer program product. Therefore, the present invention can take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects. Moreover, the present invention can take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk memory, CD-ROM, optical memory, etc.) that contain computer-usable program code.

[0039] The present invention is described with reference to the flowcharts and / or block diagrams of methods, apparatuses (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram can be implemented by computer program instructions, and the combination of processes and / or blocks in the flowchart and / or block diagram can also be implemented by computer program instructions. These computer program instructions can be provided to the processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing devices to generate a machine, such that the instructions executed by the processor of the computer or other programmable data processing devices generate means for implementing the specified functions in Figure 1 one process or multiple processes and / or blocks Figure 1 one block or multiple blocks.

[0040] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to work in a particular manner, such that the instructions stored in the computer-readable memory produce a manufacture including an instruction device that implements the functions specified in one or more of the processes Figure 1 one or more of the processes and / or blocks Figure 1 specified in the blocks.

[0041] These computer program instructions can also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer-implemented process, so that the instructions executed on the computer or other programmable apparatus provide steps for implementing the functions specified in one or more of the processes Figure 1 one or more of the processes and / or blocks Figure 1 specified in the blocks.

[0042] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit them. Although the present invention has been described in detail with reference to the above embodiments, those of ordinary skill in the art should understand that: modifications or equivalent replacements can still be made to the specific embodiments of the present invention, and any modifications or equivalent replacements that do not depart from the spirit and scope of the present invention should be covered by the protection scope of the claims of the present invention.

Claims

1. A method for configuring the linkage between a visual chart and a digital chart, characterized in that It includes the following steps: An input control primitive is established on the required display page, and corresponding primitive data codes are configured for the input control primitive; A query button primitive is established, a dynamic SQL of a transaction data set is selected, and the query conditions of the dynamic SQL of the transaction data set are disassembled. The SQL query conditions are configured to be associated with the primitive data codes to generate a mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding primitive data codes; According to the mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding primitive data codes, a final transaction data set query SQL is generated; Chart primitive of different types are created, different data ranges corresponding to the query result data set are configured for the chart primitive of different types, and the data range of the chart primitive is associated with the final transaction data set query SQL to complete the visual chart data-chart linkage configuration.

2. The visualization chart and number chart linkage configuration method according to claim 1, characterized in that The input control primitive includes any one of an input text box, a time selection box, and a drop-down selection box.

3. A visual chart number-chart linkage configuration method according to claim 1, characterized in that A query button primitive is established, a dynamic SQL of a transaction data set is selected, and the SQL query conditions are disassembled. The specific method for configuring the query conditions of the dynamic SQL of the transaction data set to be associated with the primitive data codes to generate a mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding primitive data codes is as follows: An input control primitive is established; The corresponding dynamic SQL of the transaction data set is selected according to the requirement, and the internal format of the statement of the dynamic SQL of the transaction data set is disassembled; the required internal format of the statement is configured to be associated with the input control primitive to generate a mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding primitive data codes.

4. A method for visualizing chart and data chart linkage configuration according to claim 1, characterized in that Chart primitive of different types include chart display primitives such as bar charts, pie charts, and line charts.

5. A method for visual chart and digital chart linkage configuration according to claim 1, characterized in that The data ranges corresponding to the chart primitive of different types include the X-axis data range and the Y-axis data range corresponding to the chart primitive of different types.

6. A method for configuring the linkage between a visual chart and a digital chart according to claim 1, characterized in that The specific method for creating chart primitive of different types, configuring different data ranges corresponding to the query result data set for the chart primitive of different types, and associating the data range of the chart primitive with the final transaction data set query SQL to complete the visual chart data-chart linkage configuration is as follows: Analyze the chart primitive of different types to obtain the data ranges corresponding to the chart primitive of different types; Judge whether the data range is associated with the multi-series data set linkage code in the query result of the final transaction data set. The data set linkage code is generated according to the different data ranges corresponding to the query result data set; If the data range is not associated with the multi-series data set linkage code, read two columns of data within the data set query result range to form corresponding single-series chart data and perform chart visualization display; If the data range is already associated with the multi-series data set linkage code, read all the data within the data set query result to form corresponding multi-series chart data and perform chart visualization display.

7. A visual chart number chart linkage configuration system, characterized in that, It includes: A data control establishment module for establishing an input control primitive on the required display page and configuring corresponding primitive data codes for the input control primitive; The database execution module is used to establish a query button primitive, select a dynamic SQL of a transaction data set, disassemble it to obtain the query conditions of the dynamic SQL of the transaction data set, configure the association between the SQL query conditions and the primitive data code, and generate the mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding primitive data code; The database generation module is used to generate the final transaction data set query SQL according to the mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding primitive data code; The chart and figure linkage module is used to create different types of chart primitives, configure different data ranges corresponding to the query result data sets for different types of chart primitives, associate the data ranges of the chart primitives with the final transaction data set query SQL, and complete the visual chart and figure linkage configuration.

8. A visual chart number-chart linkage configuration system according to claim 7, characterized in that The specific functions of the database execution module are implemented by the following method: Establish an input control primitive; Select the corresponding dynamic SQL of the transaction data set according to the requirements, and disassemble the internal format of the statement of the dynamic SQL of the transaction data set; Configure the required internal format of the statement to be associated with the input control primitive, and generate the mapping relationship between the query conditions of the dynamic SQL of the transaction data set and the corresponding primitive data code.

9. A visual chart number-chart linkage configuration system according to claim 7, characterized in that The specific functions of the chart and figure linkage module are implemented by the following method: Analyze different types of chart primitives to obtain the data ranges corresponding to different types of chart primitives; Judge whether the data range is associated with the multi-series data set linkage code in the final transaction data set query SQL, and the data set linkage code is generated according to the different data ranges corresponding to the query result data sets; If the data range is not associated with the multi-series data set linkage code, read two columns of data within the data set query result range to form the corresponding single-series chart data, and perform chart visualization display; If the data range is already associated with the multi-series data set linkage code, read all the data within the data set query result range to form the corresponding multi-series chart data, and perform chart visualization display.

10. An electronic device, comprising a memory and a processor, the memory storing a computer program, characterized in that, When the processor executes the computer program, it implements the steps of a visual chart and figure linkage configuration method according to any one of claims 1 to 6.

11. A storage medium, on which a computer program is stored, characterized in that, When the computer program is executed by the processor, it implements the steps of a visual chart and figure linkage configuration method according to any one of claims 1 to 6.

Images