Dynamic page configuration method and system

By converting business logic into database language and dynamically configuring tables and charts, the problem of list column header fixation is solved, and users can adjust independently and zero-code configuration is realized, reducing costs, improving efficiency, and adapting to diversified Business needs.

CN119225723APending Publication Date: 2024-12-31SHENZHEN LANYOU TECHNOLOGY CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202310815784.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Priority Date
2023-06-28
Filing Date
2023-07-04
Publication Date
2024-12-31

Smart Images

  • Figure CN119225723A_ABST
    Figure CN119225723A_ABST
Patent Text Reader

Abstract

The invention discloses a page dynamic configuration method, which comprises the following steps of: converting business logic into a database language, storing the database language into a dynamic table, and marking a column field to which the database language corresponding to the business logic belongs; selecting a column needing to be displayed in the dynamic column set according to the column field; selecting a style of the column, and selecting a style of the chart associated with the column; and performing dynamic column configuration on tables and charts containing columns. According to the method, through a mode that the visual chart is combined with the list, the dynamic configuration chart and the chart details, and the modules of the list after real-time display configuration, dynamic configuration and the like supplement each other, a user can rapidly process list heads of various scenes and rapidly configure the list, the problem that the user cannot dynamically configure the list in real time is solved, and the user experience is improved. The method has the advantages of reducing cost, increasing efficiency and improving efficiency.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a page dynamic configuration method and system. Background Art

[0002] Since there are many business roles in an enterprise and they focus on different business points, there is an urgent need to customize the column headers according to the business roles on the system pages to meet the diversity of the column headers involved in various roles. At the same time, after the list headers are customized, users can adjust the list headers themselves in real time and with low thresholds according to the particularity of the role without knowing the code. At present, after the software party delivers the customized development system to the business, the problems are: the list headers are usually fixed, even if the page has width and height adjustment or hidden display columns, they will disappear after refreshing. If the list headers need to be changed permanently, the business needs to contact professional technicians separately to adjust the code, which not only consumes more manpower and material resources and has a long change cycle, but also after development, there will be a risk of repeated changes due to reduced communication quality, thus failing to meet business expectations, and ultimately reducing customer satisfaction. For software companies, it is unnecessary to spend the costs brought by a series of work such as demand analysis, modeling, development, testing, and deployment in simple list header changes. It can be seen that both business enterprises and software enterprises are in urgent need of a dynamic, persistent, low-cost, diversified, real-time, low-threshold, visual, cost-reducing, and efficient zero-code configuration management terminal, a highly flexible, real-time, user-oriented collaborative office tool. It can adapt to the problem of dynamic configuration of lists in various business scenarios faced by enterprise development, save manpower and material resources, and allow users who do not understand code to customize list headers. When faced with various role changes, they can also meet needs more calmly and elegantly. This list management terminal will become an important support for reducing costs and increasing efficiency in enterprise management, and effectively solve the problem of rigid list header configuration that needs to be flexibly responded to due to different roles, changes in business scenarios, and changes in positions, and reduce unnecessary manpower and material resources in simple things. Summary of the invention

[0003] The main purpose of the present invention is to provide a page dynamic configuration method and system to address the shortcomings of the prior art in that when implementing list changes dynamically and persistently, it cannot be zero-code and user-oriented, and cannot achieve cost reduction, efficiency improvement and efficiency improvement.

[0004] To achieve the above object, the present invention provides a page dynamic configuration method, comprising the following steps:

[0005] Convert the business logic into database language and store it in the dynamic table, marking the column field of the database language corresponding to the business logic;

[0006] Select the columns to be displayed in the dynamic column set based on the column fields;

[0007] Select the style of the column and the style of the chart associated with the column;

[0008] Dynamically configure columns for tables and charts that contain columns.

[0009] In the page dynamic configuration method provided by the present invention, before converting the business logic into the database language and storing it in the dynamic table, and marking the column field to which the database language corresponding to the business logic belongs, the method includes:

[0010] Determine whether the dynamic table needs paging;

[0011] If the dynamic table needs to be paginated, the target threshold is calculated based on the paging amount. After matching the target threshold, the business logic is converted into database language and stored in the dynamic table.

[0012] If the dynamic table does not require paging, a threshold is set and the business logic is converted into database language and stored in the dynamic table.

[0013] In the page dynamic configuration method provided by the present invention, the step of dynamically configuring columns of a table and a chart containing columns includes:

[0014] Perform at least one of the following configurations on a table or chart containing columns: display, hide, add, modify, delete, select, adjust font color, adjust font style, or adjust background color of the columns;

[0015] If the column status is displayed, the column fields are added to the dynamic column set; if the column status is hidden, the column fields are stopped from being added to the dynamic column set;

[0016] After the table is reorganized, the columns are reorganized, data is extracted each time at the target threshold or minimum paging amount, and the final result is output;

[0017] The column field includes at least one of the column name, column style, and column width.

[0018] In the page dynamic configuration method provided by the present invention, the step of dynamically configuring columns of tables and charts containing columns further includes:

[0019] The user clicks the chart's button, and the table containing the columns displays the data associated with the chart;

[0020] Or the user clicks a chart button to refresh the chart or go to another page;

[0021] The data displayed in the chart is the same as the data displayed in the table, and the data at least includes quantity.

[0022] In addition, to achieve the above-mentioned purpose, the present invention also provides a page dynamic configuration system, which includes a conversion module, a first selection module, a second selection module and a configuration module.

[0023] The conversion module is used to convert the business logic into database language and store it in the dynamic table, marking the column field of the database language corresponding to the business logic;

[0024] The first selection module is used to select the columns to be displayed in the dynamic column set according to the column fields;

[0025] The second selection module is used to select the style of the column and the style of the chart associated with the column;

[0026] The configuration module is used to dynamically configure columns for tables and charts that contain columns.

[0027] In the page dynamic configuration system provided by the present invention, the system also includes a judgment module,

[0028] The judgment module is used to judge whether the dynamic table needs paging;

[0029] If the dynamic table needs to be paginated, the target threshold is calculated based on the paging amount. After matching the target threshold, the business logic is converted into database language and stored in the dynamic table.

[0030] If the dynamic table does not require paging, a threshold is set and the business logic is converted into database language and stored in the dynamic table.

[0031] In the page dynamic configuration system provided by the present invention, the configuration module is used to perform at least one of the following configurations on the table and chart containing columns: display, hide, add, modify, delete, select, adjust font color, adjust font style, or adjust background color of the columns;

[0032] If the column status is displayed, the column fields are added to the dynamic column set; if the column status is hidden, the column fields are stopped from being added to the dynamic column set;

[0033] After the table is reorganized, the columns are reorganized, data is extracted each time at the target threshold or minimum paging amount, and the final result is output;

[0034] The column field includes at least one of the column name, column style, and column width.

[0035] In the page dynamic configuration system provided by the present invention, the configuration module is used for displaying data associated with the chart in a table containing columns when a user clicks a button of the chart;

[0036] Or the user clicks a chart button to refresh the chart or go to another page;

[0037] The data displayed in the chart is the same as the data displayed in the table, and the data at least includes quantity.

[0038] In addition, to achieve the above object, the present invention also provides a terminal device, including:

[0039] Memory for storing computer programs;

[0040] The processor is used to implement the steps of the above page dynamic configuration method when executing a computer program.

[0041] In addition, to achieve the above-mentioned purpose, the present invention also provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, the steps of the above page dynamic configuration method are implemented.

[0042] The present invention discloses a page dynamic configuration method, including: converting business logic into database language and storing it in a dynamic table, marking the column field to which the database language corresponding to the business logic belongs; selecting the column to be displayed in the dynamic column set according to the column field; selecting the style of the column, selecting the style of the chart associated with the column; and dynamically configuring the columns of the table and chart containing the column. The present invention complements each other by using modules such as visual charts combined with lists, dynamically configured charts and chart details, and real-time display of configured lists and dynamic configuration. Users can quickly process list headers of various scenarios and quickly configure lists, solving the pain point that users cannot dynamically and real-time configure lists, and has the advantages of reducing costs and increasing efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art are briefly introduced below. Obviously, the drawings in the following description are only embodiments of the present invention. For those of ordinary skill in the art, other drawings can be obtained based on the provided drawings without creative work:

[0044] Figure 1 FIG. 1 is a flow chart of a page dynamic configuration method provided by an embodiment of the present invention.

[0045] Figure 2 FIG. 1 is a schematic diagram of the structure of a page dynamic configuration system provided by an embodiment of the present invention.

[0046] Figure 3 Shown is a schematic diagram of a terminal device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0047] In order to facilitate understanding of the present invention, the present invention will be described more fully below with reference to the relevant drawings. Typical embodiments of the present invention are given in the drawings. However, the present invention can be implemented in many different forms and is not limited to the embodiments described herein. On the contrary, the purpose of providing these embodiments is to make the disclosure of the present invention more thorough and comprehensive.

[0048] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art of the present invention. The terms used in the specification of the present invention herein are only for the purpose of describing specific embodiments and are not intended to limit the present invention.

[0049] In order to better understand the above-mentioned technical scheme, the above-mentioned technical scheme will be described in detail below in conjunction with the accompanying drawings and specific implementation methods. It should be understood that the embodiments of the present invention and the specific features in the embodiments are detailed descriptions of the technical scheme of the present application, rather than limitations on the technical scheme of the present application. In the absence of conflict, the embodiments of the present invention and the technical features in the embodiments can be combined with each other.

[0050] Reference Figure 1 , Figure 1 FIG. 1 is a flow chart of a page dynamic configuration method provided by an embodiment of the present invention. In this embodiment, the page dynamic configuration method includes:

[0051] Step S10, converting the business logic into database language and storing it in a dynamic table, marking the column field to which the database language corresponding to the business logic belongs;

[0052] Step S20, selecting a column to be displayed from the dynamic column set according to the column field;

[0053] Step S30, selecting a column style, and selecting a chart style associated with the column;

[0054] Step S40, dynamically configuring the columns of the table and chart containing the columns.

[0055] Step S10 converts the business logic into database language and stores it in the dynamic table, before marking the column field to which the database language corresponding to the business logic belongs, including:

[0056] Step S11, determining whether the dynamic table needs paging;

[0057] Step S12: if the dynamic table needs paging, the target threshold is calculated according to the paging amount, and after matching the target threshold, the business logic is converted into database language and stored in the dynamic table;

[0058] Step S13: If the dynamic table does not need paging, a threshold is set and the business logic is converted into a database language and stored in the dynamic table.

[0059] The default threshold is 200, and other thresholds can also be set.

[0060] The data structure is divided into five layers. The first layer is dynamic table, which defines basic information such as dynamic table ID, role code, table name, table menu, table code, table SQL, table conditions, etc., as one of the basic sources to support column configuration; the second layer is dynamic column storage, which defines basic information such as dynamic column ID, dynamic table ID, column name, column code, column SQL, column status, column order, column style, column type, column width, etc.; the third layer defines dynamic column library storage, which is basically consistent with the second layer in column definition; the fourth layer is dynamic chart storage, which defines chart information such as dynamic chart ID, chart role code, chart name, chart code, chart status, etc.; the fifth layer is chart detail storage, which defines chart detail information such as chart detail ID, chart ID, dynamic column SQL, dynamic column status, dynamic column order, etc.

[0061] Write the business logic as SQL statements and store them in the dynamic table, and mark which column field they belong to. Then set the dynamic columns in the table. This step supports users to select from the dynamic column list and select the required style for each column. The same is true for setting dynamic charts. You can define the dynamic chart in the database first, and then define the columns involved in the chart. After initializing one version, you can perform dynamic configuration on the page later. Configuration operations include: reordering, display, hiding, modifying, deleting, selecting, etc.

[0062] Reorder: The system will use the default sorting rules to give users a default display order, and users can also adjust the display order themselves; Add: As long as the new columns can exist in the database, they can be added; Modify: The columns can be modified according to the user's preferences; Display: Columns that do not need to be displayed can be displayed in the list; Hide: Columns that do not need to be displayed can be hidden in the list; Delete: Columns that are not needed can be deleted; Select: Required columns can be selected from the dynamic column library.

[0063] First enter the table information and store it. In the middle, select the column in the dynamic column library. The column provides fixed information such as "name", "encoding", "SQL", etc. Then select the fixed information, and then adjust the status, order, style, type, width, etc., and then save the column configuration. The configuration of other columns is similar.

[0064] The dynamic chart includes the dynamic chart ID, dynamic chart role code, dynamic chart name, dynamic chart code, and dynamic chart status; the spare parts dynamic chart details include the dynamic chart details ID, dynamic chart ID, dynamic column SQL, dynamic column status, and dynamic column order; the dynamic table includes the dynamic table ID, dynamic table role code, dynamic table name, dynamic table menu, dynamic table code, dynamic table SQL, and dynamic table conditions; the dynamic column list includes the dynamic column list ID, dynamic table ID, dynamic column name (column name), dynamic column code (alias), dynamic column SQL, dynamic column status, dynamic column order, dynamic column style, dynamic column type, and dynamic column width; the dynamic column includes the dynamic column ID, dynamic table ID, dynamic column name (column name), dynamic column code (alias), dynamic column SQL, dynamic column order, dynamic column style, dynamic column type, and dynamic column width.

[0065] The dynamic chart is associated with the dynamic table through role coding, and the dynamic chart ID is consistent with the dynamic table ID.

[0066] The design of dynamic tables and dynamic column collections is a master-slave relationship. The slave table depends on the master table. In the dynamic column collection, if the master table A uses the B1 column of the slave table B, the B1 column will no longer appear in the selected list, effectively preventing duplicate selection or erroneous operation.

[0067] The design of dynamic columns allows users to set basic information of columns, as well as additional information of columns, such as status, order, style, type, and width, which helps meet users' needs for column diversity and improve personalization capabilities.

[0068] Step S40 dynamically configures columns of tables and charts containing columns, including:

[0069] Step S41, performing at least one of displaying, hiding, adding, modifying, deleting, selecting, adjusting font color, adjusting font style or adjusting background color of the table and chart containing columns;

[0070] Step S42, if the state of the column is displayed, the column field of the column is added to the dynamic column set; if the state of the column is hidden, the column field of the column is stopped from being added to the dynamic column set;

[0071] Step S43, after the table is reorganized, the columns are reorganized, data is extracted each time at a target threshold or a minimum paging amount, and the final result is output;

[0072] The column field includes at least one of the column name, column style, and column width.

[0073] In one embodiment, the user can freely adjust the columns. After the display, hiding, adding, modifying, deleting, and selecting the columns are saved, they will take effect immediately. If the status of the column is displayed, the column fields of the column will be added to the dynamic column set. If the status of the column is hidden, the column fields of the column will stop being added to the dynamic column set.

[0074] In another embodiment, the user can customize the font style. The user can adjust the font color, font style or background color. The first column of the table can be green font, the second column can be red font, the third column can be black font, the fourth column can be blue font and light blue background color, the fifth column can be green font and light green background color, the sixth column can be gray font and light gray background color, the seventh column can be orange font and light orange background color, the eighth column can be red font and light red background color, the ninth column can be blue font, or other colors, styles or colors.

[0075] If the column status is displayed, the column fields of the column are added to the dynamic column set. If the column status is hidden, the column fields of the column are stopped from being added to the dynamic column set.

[0076] After configuring the table, reorganize the table, optimize the SQL statement, set the target threshold, which is the optimal threshold for matching paging, extract data each time at the target threshold or the minimum paging amount, and merge the table header and data if necessary, and output them in batches to the total collection. The total collection includes the dynamic column collection, statement collection, and condition collection. The statement collection is a collection of basic database statements related to database commands and statements that can operate on data, and the condition collection is a collection of the most basic conditional query statements.

[0077] Render the processed table, parse the JSON statement, parse the encoding, render the table style, bind the table data, and output the final result to the user.

[0078] Step S40 dynamically configures columns for tables and charts containing columns, and also includes:

[0079] Step S44, the user clicks the button of the chart, and the table containing the columns displays the data associated with the chart;

[0080] Step S45, or the user clicks a button on the chart to refresh the chart or enter another page;

[0081] The data displayed in the chart is the same as the data displayed in the table, and the data at least includes quantity.

[0082] In one embodiment, a bar graph is displayed on the left side of the page and a list is displayed on the right side. At the same time, if the user clicks on the bar graph on the left, the button switch can be automatically controlled. The button switch is controlled through various stages. At the same time, the number displayed in the bar graph on the left is equal to the number displayed in the list on the right.

[0083] In another embodiment, a chart area provides a bar chart showing the progress of each stage on the upper side, and a button for refreshing the chart separately and a processing button on the lower side. When the processing button is clicked, the detailed processing page is entered. For example, when the processing button of the packaging material price area is clicked, a detailed processing page pops up. Each time the content of the area is processed, the specific area is refreshed.

[0084] The statistics of the bar chart allow users to clearly see which node each stage is at, and know the number of pending processes in each stage in a short time. Each time the content of that area is processed, the specific area will be refreshed.

[0085] Based on the above methods, through the complementary methods of visual charts combined with lists, dynamic configuration charts and chart details, real-time display of configured lists, dynamic configuration and other modules, users can quickly process list headers in various scenarios and quickly configure lists, which solves the pain point that users cannot configure lists dynamically and in real time, and has the advantages of reducing costs and increasing efficiency.

[0086] Reference Figure 2 Accordingly, the present invention also provides a page dynamic configuration system, which includes a conversion module 201, a first selection module 202, a second selection module 203 and a configuration module 204.

[0087] The conversion module 201 is used to convert the business logic into database language and store it in the dynamic table, marking the column field to which the database language corresponding to the business logic belongs;

[0088] The first selection module 202 is used to select a column to be displayed in the dynamic column set according to the column field;

[0089] The second selection module 203 is used to select the style of the column and the style of the chart associated with the column;

[0090] The configuration module 204 is used to dynamically configure columns of tables and charts containing columns.

[0091] Furthermore, in an embodiment of the present invention, the system further includes a determination module 205, which is used to determine whether the dynamic table needs paging;

[0092] If the dynamic table needs to be paginated, the target threshold is calculated based on the paging amount. After matching the target threshold, the business logic is converted into database language and stored in the dynamic table.

[0093] If the dynamic table does not require paging, a threshold is set and the business logic is converted into database language and stored in the dynamic table.

[0094] Further, in an embodiment of the present invention, the configuration module 204 is used to perform at least one of the following configurations of displaying, hiding, adding, modifying, deleting, selecting, adjusting font color, adjusting font style, or adjusting background color of a table or chart containing columns;

[0095] If the column status is displayed, the column fields are added to the dynamic column set; if the column status is hidden, the column fields are stopped from being added to the dynamic column set;

[0096] After the table is reorganized, the columns are reorganized, data is extracted each time at the target threshold or minimum paging amount, and the final result is output;

[0097] The column field includes at least one of the column name, column style, and column width.

[0098] Further, in one embodiment of the present invention, the configuration module 204 is used for displaying data associated with the chart in a table containing columns when a user clicks a button of the chart;

[0099] Or the user clicks a chart button to refresh the chart or go to another page;

[0100] The data displayed in the chart is the same as the data displayed in the table, and the data at least includes quantity.

[0101] Reference Figure 3 The embodiment of the present invention further provides a terminal device 100, which may include:

[0102] A memory 101, used for storing computer programs;

[0103] The processor 102, when used to execute the computer program stored in the memory 101, can implement the following steps:

[0104] Select the columns to be displayed in the dynamic column set based on the column fields;

[0105] Select the style of the column and the style of the chart associated with the column;

[0106] Dynamically configure columns for tables and charts that contain columns.

[0107] The embodiment of the present invention further provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the following steps can be implemented;

[0108] Select the columns to be displayed in the dynamic column set based on the column fields;

[0109] Select the style of the column and the style of the chart associated with the column;

[0110] Dynamically configure columns for tables and charts that contain columns.

[0111] The computer-readable storage medium may include: a USB flash drive, a mobile hard disk, a read-only memory (ROM)> a random access memory (RAM), a magnetic disk or an optical disk, and other media that can store program codes.

[0112] In the description provided herein, a large number of specific details are described. However, it is understood that embodiments of the present invention can be practiced without these specific details. In some instances, well-known methods, structures and techniques are not shown in detail so as not to obscure the understanding of this description.

[0113] Similarly, it should be understood that in order to streamline the present disclosure and aid in understanding one or more of the various inventive aspects, in the above description of exemplary embodiments of the present invention, various features of the present invention are sometimes grouped together into a single embodiment, figure, or description thereof. However, this disclosed method should not be interpreted as reflecting the intention that the claimed invention requires more features than those explicitly recited in each claim. More specifically, as reflected in the claims below, inventive aspects lie in less than all the features of the individual embodiments disclosed above. Therefore, the claims that follow the specific embodiment are hereby expressly incorporated into the specific embodiment, with each claim itself serving as a separate embodiment of the present invention.

[0114] Those skilled in the art will appreciate that the modules in the devices in the embodiments may be adaptively changed and arranged in one or more devices different from the embodiments. The modules or units or components in the embodiments may be combined into one module or unit or component, and in addition they may be divided into a plurality of submodules or subunits or subcomponents. Except that at least some of such features and / or processes or units are mutually exclusive, all features disclosed in this specification (including the accompanying claims, abstracts and drawings) and all processes or units of any method or device disclosed in this manner may be combined in any combination. Unless otherwise expressly stated, each feature disclosed in this specification (including the accompanying claims, abstracts and drawings) may be replaced by an alternative feature providing the same, equivalent or similar purpose.

[0115] In addition, those skilled in the art will appreciate that, although some embodiments herein include certain features included in other embodiments but not other features, the combination of features of different embodiments is meant to be within the scope of the present invention and form different embodiments. For example, in the claims below, any one of the claimed embodiments may be used in any combination.

[0116] The various component embodiments of the present invention can be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. It should be understood by those skilled in the art that a microprocessor or digital signal processor (DSP) can be used in practice to implement some or all of the functions of some or all of the components in the embodiments of the present invention. The present invention can also be implemented as a device or apparatus program (e.g., computer program and computer program product) for executing part or all of the methods described herein. Such a program implementing the present invention can be stored on a computer-readable medium, or can have the form of one or more signals. Such a signal can be downloaded from an Internet website, or provided on a carrier signal, or provided in any other form.

[0117] It should be noted that the above embodiments illustrate the present invention rather than limit it, and that those skilled in the art may devise alternative embodiments without departing from the scope of the appended claims. In the claims, any reference symbol between brackets shall not be construed as a limitation on the claims. The word "comprising" does not exclude the presence of elements or steps not listed in the claims. The word "one" or "an" preceding an element does not exclude the presence of a plurality of such elements. The present invention may be implemented by means of hardware comprising a number of different elements and by means of a suitably programmed computer. In a unit claim enumerating a number of devices, several of these devices may be embodied by the same hardware item. The use of the words first, second, and third, etc., does not indicate any order. These words may be interpreted as names.

Claims

1. A page dynamic configuration method, characterized in that: The following steps are involved: Convert the business logic into database language and store it in a dynamic table, marking the column field to which the database language corresponding to the business logic belongs; Select the column to be displayed in the dynamic column set according to the column field; Select the style of the column, and select the style of the chart associated with the column; Dynamically configure the columns of the table and the chart.

2. The page dynamic configuration method according to claim 1, characterized in that: Before the step of converting the business logic into database language and storing it in a dynamic table, and marking the column field to which the database language corresponding to the business logic belongs, the method includes: Determine whether the dynamic table needs paging; If the dynamic table needs paging, the target threshold is calculated according to the paging amount, and after matching the target threshold, the business logic is converted into database language and stored in the dynamic table; If the dynamic table does not need paging, a threshold is set and the business logic is converted into a database language and stored in the dynamic table.

3. The page dynamic configuration method as claimed in claim 2, characterized in that: The step of dynamically configuring the columns of the table containing the columns and the chart comprises: Perform at least one of the following configurations on a table or chart containing columns: display, hide, add, modify, delete, select, adjust font color, adjust font style, or adjust background color of the columns; If the state of the column is displayed, the column field of the column is added to the dynamic column set; if the state of the column is hidden, the column field of the column is stopped from being added to the dynamic column set; After reorganizing the table, reorganize the columns, extract data at a target threshold or a minimum paging amount each time, and output the final result; The column field includes at least one of a column name, a column style, and a column width.

4. The page dynamic configuration method according to claim 1, characterized in that: The step of dynamically configuring the columns of the table containing the columns and the chart further includes: The user clicks a button of a chart, and a table containing columns displays data associated with the chart; Or the user clicks a button on the chart to refresh the chart or enter another page; The data displayed in the chart is the same as the data displayed in the table, and the data at least includes quantity.

5. A page dynamic configuration system, the system comprising a conversion module, a first selection module, a second selection module and a configuration module, The conversion module is used to convert the business logic into a database language and store it in a dynamic table, marking the column field to which the database language corresponding to the business logic belongs; The first selection module is used to select a column to be displayed in the dynamic column set according to the column field; The second selection module is used to select the style of the column and the style of the chart associated with the column; The configuration module is used to dynamically configure the columns of the table containing the columns and the chart.

6. The page dynamic configuration system as claimed in claim 5, characterized in that: The system also includes a judgment module. The judging module is used to judge whether the dynamic table needs paging; If the dynamic table needs paging, the target threshold is calculated according to the paging amount, and after matching the target threshold, the business logic is converted into database language and stored in the dynamic table; If the dynamic table does not need paging, a threshold is set and the business logic is converted into a database language and stored in the dynamic table.

7. The page dynamic configuration system of claim 6, wherein the configuration module is used to perform at least one of the following configurations on the table and chart containing columns: display, hide, add, modify, delete, select, adjust font color, adjust font style, or adjust background color of the columns; If the state of the column is displayed, the column field of the column is added to the dynamic column set; if the state of the column is hidden, the column field of the column is stopped from being added to the dynamic column set; After reorganizing the table, reorganize the columns, extract data at a target threshold or a minimum paging amount each time, and output the final result; in, The column field includes at least one of a column name, a column style, and a column width.

8. The page dynamic configuration system as claimed in claim 5, characterized in that: The configuration module is used for displaying data associated with the chart in a table containing columns when a user clicks a button of the chart; Or the user clicks a button on the chart to refresh the chart or enter another page; The data displayed in the chart is the same as the data displayed in the table, and the data at least includes quantity.

9. A terminal device, characterized in that: The terminal device comprises: a memory, a processor, and a data processing program stored in the memory and executable on the processor, wherein the data processing program implements the method according to any one of claims 1 to 4 when executed by the processor.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a data processing program, and when the data processing program is executed by a processor, the method according to any one of claims 1 to 4 is implemented.