CN111124411A - Method and system for personalized setting of form based on dynamic page - Google Patents
Method and system for personalized setting of form based on dynamic page Download PDFInfo
- Publication number
- CN111124411A CN111124411A CN201911412352.7A CN201911412352A CN111124411A CN 111124411 A CN111124411 A CN 111124411A CN 201911412352 A CN201911412352 A CN 201911412352A CN 111124411 A CN111124411 A CN 111124411A
- Authority
- CN
- China
- Prior art keywords
- page
- column
- setting
- selected table
- information
- 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.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/957—Browsing optimisation, e.g. caching or content distillation
- G06F16/9574—Browsing optimisation, e.g. caching or content distillation of access to content, e.g. by caching
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
Abstract
The invention discloses a method and a system for personalized setting of a table based on a dynamic page, wherein the method comprises the following steps: receiving modification information from a user; parsing the modification information to determine at least one configuration item to configure a selected table with each configuration item; setting configuration information of the configured selected form as customization settings of the selected form, storing the customization settings in a customization database, and storing the configured selected form in a system cache.
Description
Technical Field
The present invention relates to the field of data processing, and more particularly, to a method and system for configuring personalized settings for a form based on a dynamic page.
Background
Form controls are very common in web development, are common components for managing information systems, and are mainly used for editing and displaying various business data. As an important component of the view layer, the format of the table (such as column width, column title, etc.) is often set during the development process, and cannot be modified by the user. However, the client environment (such as display size and resolution), the focus on data, and the preference of habit are different for each user, and a personalized table format is often required to be customized. Therefore, the data display function with a single form cannot meet the needs of users, and is not friendly in terms of user experience.
Disclosure of Invention
The invention provides a scheme for personalized setting of table formats, wherein a user can set the table formats through a specific format design interface, and the configurable contents comprise display and hiding of columns, column titles, column widths, column alignment modes and column sequences; the column width adjustment and the meter head sequence adjustment can be realized by directly dragging the meter heads. The user configuration information is stored in the database, and when the user loads the page again, the last configuration information is read according to the current login user, and the form information is dynamically modified and displayed.
According to an aspect of the present invention, there is provided a method for personalizing a form based on a dynamic page, the method including:
when a processing request aiming at a page is received, acquiring a page cache, searching whether a table exists in the page, if so, searching whether a configuration information cache of the table exists, determining a table identifier of the selected table and a requester identifier of a user according to the processing request, and determining whether the table information of the selected table is in a system cache or not based on the table identifier;
upon determining that the form information for the selected form is not in the system cache, retrieving in a customization database based on the requestor identifier to obtain customization settings associated with the user and corresponding to a predetermined form in a form settings page;
initializing and presenting a preset form in a form setting page according to the customized setting, and receiving modification information from a user after the initialization and presentation;
analyzing the modification information to determine at least one configuration item, and performing personalized setting on a plurality of configuration items in a table setting page to configure the selected table by using each configuration item;
setting configuration information of the configured selected form as customization settings of the selected form, storing the customization settings in a customization database, and storing the configured selected form in a system cache.
When storing the configured selected table in the system cache, the dynamic page modifies the selected table before configuration only according to the changed content of the configured selected table compared with the selected table before configuration.
When storing the configured selected table in the relational database, the dynamic page modifies the selected table before configuration only according to the changed content of the configured selected table compared with the selected table before configuration.
And reading and/or setting the configuration information of the selected form at the service side based on a dynamic page generation mechanism during loading.
The configuration items include: column name, column order, column width, and/or display status.
In response to receiving a reset indication for the selected table, the pair restores the configuration item of the selected table to an initial state.
And calling an interface of the form control, acquiring the form header information and transmitting the form header information to a form setting page, so that the form setting page records and displays the form header information.
When the selected table relates to a composite header, the table setup page will load the table information using the tree list;
when the configuration information is stored, the character strings in the preset format are used and the format information of the selected table is stored according to an array structure, wherein each element of the array structure represents the format information of one column and comprises a column identifier, a column name, a column width, a display state, a data alignment mode and a serial number.
Detecting a user-adjusted column width at predetermined time intervals, detecting a user-adjusted column order at predetermined time intervals, and transmitting column width information of at least one selected table and/or column order information of the selected table at predetermined time intervals.
Information about the adjusted column width, the adjusted column order, and the table design is stored in three fields of the relational database.
And when the configuration information of the set page of the table is saved, clearing the column width field and the column sequence field to show the priority of the column width and the column sequence.
After the configuration information is stored, the form setting page is closed, the configuration data returned by the form setting page is obtained, an interface of the form control is called, and the view of the selected form is refreshed immediately.
And based on the form configuration information read from the system cache and based on a dynamic page generation mechanism, acquiring the page cache, modifying the selected form in the page according to the form configuration information, and returning the modified form to the user.
When a page associated with a selected table is loaded, acquiring page configuration of column titles, alignment modes and display states; when setting the column width, if the storage field of the column width is not empty, modifying the page by using the width attribute of the column width field, otherwise, using the column width in the customized setting;
when the column sequence is set, if the storage field of the column sequence is not empty, the page is modified by using the field of the column sequence, otherwise, the column sequence in the customized setting is used.
Traversing the stored column information, and acquiring column tags in the page according to the field attributes;
when the sequence number N field is smaller than the sequence of the columns in the page, moving the labels of the columns to the front of the N labels of the current page;
when the sequence number N field is larger than the sequence of the columns in the page, moving the labels of the columns to the back of the N labels of the current page; otherwise, no processing is performed.
By adding a display attribute on the column label;
setting the display attribute to be 0, wherein the display attribute of 0 represents that the display state is hidden;
the display attribute is set to 1, and a display attribute of 1 indicates that the display state is display.
According to another aspect of the present invention, there is provided a system for personalizing a form based on a dynamic page, the system comprising:
the device comprises a determining device, a system cache and a processing device, wherein the determining device is used for acquiring a page cache when receiving a processing request aiming at a page, searching whether a table exists in the page, if so, searching whether a configuration information cache of the table exists, determining a table identifier of a selected table and a requester identifier of a user according to the processing request, and determining whether the table information of the selected table is in the system cache or not based on the table identifier;
retrieving means for retrieving in the customization database based on the requestor identifier to obtain customization settings associated with the user and corresponding to a predetermined form in a form settings page when it is determined that form information of the selected form is not in the system cache;
the presentation device is used for carrying out initialization presentation on a preset form in the form setting page according to the customized setting;
the analysis device receives modification information from a user after the initialization presentation, and analyzes the modification information to determine at least one configuration item;
the processing device is used for carrying out personalized setting on a plurality of configuration items in the table setting page so as to configure the selected table by utilizing each configuration item;
and the setting device is used for setting the configuration information of the configured selected table as the customization setting of the selected table, storing the customization setting in the customization database and storing the configured selected table in the system cache.
When storing the configured selected table in the system cache, the dynamic page modifies the selected table before configuration only according to the changed content of the configured selected table compared with the selected table before configuration.
When storing the configured selected table in the relational database, the dynamic page modifies the selected table before configuration only according to the changed content of the configured selected table compared with the selected table before configuration.
And reading and/or setting the configuration information of the selected form at the service side based on a dynamic page generation mechanism during loading.
The configuration items include: column name, column order, column width, and/or display status.
In response to receiving a reset indication for the selected table, the pair restores the configuration item of the selected table to an initial state.
And calling an interface of the form control, acquiring the form header information and transmitting the form header information to a form setting page, so that the form setting page records and displays the form header information.
When the selected table relates to a composite header, the table setup page will load the table information using the tree list;
when the configuration information is stored, the character strings in the preset format are used and the format information of the selected table is stored according to an array structure, wherein each element of the array structure represents the format information of one column and comprises a column identifier, a column name, a column width, a display state, a data alignment mode and a serial number.
Detecting a user-adjusted column width at predetermined time intervals, detecting a user-adjusted column order at predetermined time intervals, and transmitting column width information of at least one selected table and/or column order information of the selected table at predetermined time intervals.
Information about the adjusted column width, the adjusted column order, and the table design is stored in three fields of the relational database.
And when the configuration information of the set page of the table is saved, clearing the column width field and the column sequence field to show the priority of the column width and the column sequence.
After the configuration information is stored, the form setting page is closed, the configuration data returned by the form setting page is obtained, an interface of the form control is called, and the view of the selected form is refreshed immediately.
And based on the form configuration information read from the system cache and based on a dynamic page generation mechanism, acquiring the page cache, modifying the selected form in the page according to the form configuration information, and returning the modified form to the user.
When a page associated with a selected table is loaded, acquiring page configuration of column titles, alignment modes and display states; when setting the column width, if the storage field of the column width is not empty, modifying the page by using the width attribute of the column width field, otherwise, using the column width in the customized setting;
when the column sequence is set, if the storage field of the column sequence is not empty, the page is modified by using the field of the column sequence, otherwise, the column sequence in the customized setting is used.
Traversing the stored column information, and acquiring column tags in the page according to the field attributes;
when the sequence number N field is smaller than the sequence of the columns in the page, moving the labels of the columns to the front of the N labels of the current page;
when the sequence number N field is larger than the sequence of the columns in the page, moving the labels of the columns to the back of the N labels of the current page; otherwise, no processing is performed.
By adding a display attribute on the column label;
setting the display attribute to be 0, wherein the display attribute of 0 represents that the display state is hidden;
the display attribute is set to 1, and a display attribute of 1 indicates that the display state is display.
The invention designs a set of personalized storage and display scheme of form format based on a dynamic page generation mechanism, and a user can flexibly configure the form format meeting the own requirements, thereby improving the user experience. In the aspect of system efficiency, the invention optimizes the storage structure, uses cache and dynamic page loading, and improves the space efficiency and time efficiency of the system. The system performance is considered under the condition of improving the user experience.
Drawings
A more complete understanding of exemplary embodiments of the present invention may be had by reference to the following drawings in which:
FIG. 1 is a flow chart of a method for personalizing a table based on a dynamic page in accordance with a preferred embodiment of the present invention;
FIG. 2 is a block diagram illustrating a system for personalizing tables based on dynamic pages in accordance with a preferred embodiment of the present invention;
FIG. 3 is a schematic diagram of a header of student information and a corresponding form design page in accordance with a preferred embodiment of the present invention; and
fig. 4 is a flowchart of a method of processing priorities in accordance with a preferred embodiment of the present invention.
Detailed Description
The exemplary embodiments of the present invention will now be described with reference to the accompanying drawings, however, the present invention may be embodied in many different forms and is not limited to the embodiments described herein, which are provided for complete and complete disclosure of the present invention and to fully convey the scope of the present invention to those skilled in the art. The terminology used in the exemplary embodiments illustrated in the accompanying drawings is not intended to be limiting of the invention. In the drawings, the same units/elements are denoted by the same reference numerals.
Unless otherwise defined, terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. Further, it will be understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the relevant art and will not be interpreted in an idealized or overly formal sense.
FIG. 1 is a flow chart of a method for processing a table based on a dynamic page in accordance with a preferred embodiment of the present invention. The method starts at step 101.
In step 101, when a processing request for a page is received, a page cache is obtained, whether a table exists in the page is searched, if yes, whether a configuration information cache of the table exists is searched, a table identifier of the selected table and a requester identifier of a user are determined according to the processing request, and whether table information of the selected table is in a system cache is determined based on the table identifier.
At step 102, upon determining that the form information for the selected form is not in the system cache, a search is made in a customization database based on the requestor identifier to obtain customization settings associated with the user and corresponding to the predetermined form in a form settings page.
In step 103, a predetermined form is initially presented in a form setting page according to the customized setting, and modification information is received from a user after the initial presentation.
At step 104, the modification information is parsed to determine at least one configuration item.
At step 105, a plurality of configuration items are personalized in a form settings page to configure a selected form with each configuration item.
At step 106, the configuration information of the configured selected form is set to the customization settings of the selected form, the customization settings are stored in the customization database, and the configured selected form is stored in the system cache.
When storing the configured selected table in the system cache, the dynamic page modifies the selected table before configuration only according to the changed content of the configured selected table compared with the selected table before configuration. When storing the configured selected table in the relational database, the dynamic page modifies the selected table before configuration only according to the changed content of the configured selected table compared with the selected table before configuration.
And reading and/or setting the configuration information of the selected form at the service side based on a dynamic page generation mechanism during loading. The configuration items include: column name, column order, column width, and/or display status. In response to receiving a reset indication for the selected table, the pair restores the configuration item of the selected table to an initial state. And calling an interface of the form control, acquiring the form header information and transmitting the form header information to a form setting page, so that the form setting page records and displays the form header information.
When the selected table relates to a composite header, the table setup page will load the table information using the tree list; when the configuration information is stored, the character strings in the preset format are used and the format information of the selected table is stored according to an array structure, wherein each element of the array structure represents the format information of one column and comprises a column identifier, a column name, a column width, a display state, a data alignment mode and a serial number.
Detecting a user-adjusted column width at predetermined time intervals, detecting a user-adjusted column order at predetermined time intervals, and transmitting column width information of at least one selected table and/or column order information of the selected table at predetermined time intervals. Information about the adjusted column width, the adjusted column order, and the table design is stored in three fields of the relational database. And when the configuration information of the set page of the table is saved, clearing the column width field and the column sequence field to show the priority of the column width and the column sequence. After the configuration information is stored, the form setting page is closed, the configuration data returned by the form setting page is obtained, an interface of the form control is called, and the view of the selected form is refreshed immediately. And based on the form configuration information read from the system cache and based on a dynamic page generation mechanism, acquiring the page cache, modifying the selected form in the page according to the form configuration information, and returning the modified form to the user.
When a page associated with a selected table is loaded, acquiring page configuration of column titles, alignment modes and display states; when setting the column width, if the storage field of the column width is not empty, modifying the page by using the width attribute of the column width field, otherwise, using the column width in the customized setting; when the column sequence is set, if the storage field of the column sequence is not empty, the page is modified by using the field of the column sequence, otherwise, the column sequence in the customized setting is used.
Traversing the stored column information, and acquiring column tags in the page according to the field attributes; when the sequence number N field is smaller than the sequence of the columns in the page, moving the labels of the columns to the front of the N labels of the current page; when the sequence number N field is larger than the sequence of the columns in the page, moving the labels of the columns to the back of the N labels of the current page; otherwise, no processing is performed. By adding a display attribute on the column label; setting the display attribute to be 0, wherein the display attribute of 0 represents that the display state is hidden; the display attribute is set to 1, and a display attribute of 1 indicates that the display state is display.
The embodiment of the invention provides a table format design and display method under a dynamic page generation mechanism. The embodiment of the invention is realized based on a dynamic page loading mechanism, which is different from the traditional jsp development. When the web container is started, the mechanism reads an html file written by a developer, calls a jsup interface for parsing, caches the jsup interface in a server and provides an access interface. When the server receives an access request of the page, the html page is obtained from the cache, an interface reserved for a developer is called, the developer can dynamically modify the page content, and then the page content is returned to the browser end.
The form format design is based on the support of the existing front-end form control, and a user can customize the form format according to own habits by interacting with a form design page, and the form format design specifically comprises the following steps: modifying column names, modifying column order, modifying column width, controlling the display and hiding of columns, and restoring the table format to the original state by a reset button. The invention focuses on solving the problem of how to store the table settings by the user, so as to realize the memorability of the user settings.
The general scene of the application of the invention is that a form design button is defined on a page for displaying a data form, a click event is bound, when a user clicks the button, the form design page is popped up through a front-end interface, simultaneously, an interface of a form control is called, form header information is obtained and transmitted to the form design page, and the form design page is loaded into a list after receiving the form header information. Fig. 3 shows a header of student information and a corresponding form design page. Fig. 3 is a schematic diagram of a header of student information and a corresponding form design page according to a preferred embodiment of the invention. The invention can set the format of common header and support the design of composite header. When a data form uses a composite header, the form design page will load the form information using a tree list. And after the user clicks the determined button, the configuration information is sent to the background and stored. When the invention is set by a user, a json format character string is used for storing table format information, because a table contains a plurality of columns of data, an array structure is used for storing, each element of the array represents one column of format information, including column id, column name, column width, whether hidden, data alignment mode and serial number, such as [ { field: 'student _ no', header: 'academic number', width:100, visible: true, align: left, seq:1},. ], ] concrete information is shown as the following table:
| properties | Description of the invention |
| field | Column id, unique identification of a column |
| header | Column name, displayed in ui interface |
| width | Column width, which may be a number, a percentage |
| visible | Whether to hide columns, values of Boolean type |
| align | The alignment mode of the row of data includes left, center, right |
| seq | The order of the columns in the peer nodes |
Because the method is based on the dynamic page generation mechanism, after the background receives the table configuration information, the page cache can be obtained by calling the background interface, then the table part of the page is obtained through the jsup, the configuration information is compared with the page table, only the changed part is reserved, the storage space is saved, the configuration information is stored in the database and is backed up in the cache, and the loading efficiency is improved.
Besides the table design page, the user can adjust the column width and the column sequence of the table in a mode of directly dragging the table. The method binds a table dragging event, and when the column width is dragged and adjusted, the foreground sends current table column width information to the background; when the column sequence is dragged and adjusted, the foreground sends the column sequence information of the current table to the background, and due to efficiency reasons, data is sent out not immediately but uniformly after several seconds. After the background receives the data, the original information of the page is obtained from the cache for comparison, and only the changed part is stored. The information of the drag adjustment column width, the drag adjustment column sequence and the table design is not stored in the same field, but respectively stored in three fields of the database. In the design consideration, the information stored in the table design is an array structure and occupies a large space, but in practical application, the table design is not used for every table, and compared with the prior art, the conditions of dragging the column width and the header are possibly more. When data of drag column width and header order are separately saved, simplified json structures such as { student _ no:100, student _ name: 100. } and { student _ no:0, student _ name: 1. } can be used, which are simpler and lighter than table design information. Because the column width and the column sequence exist in a plurality of fields, a priority problem exists when a page is loaded, so that when configuration information of a form design page is stored, a dragged column width field and a dragged column sequence field need to be cleared, and a specific loading mode is described in a configuration information loading part.
And after the configuration information is stored, closing the form design page, acquiring configuration data returned by the form design page by the form, calling an interface of a form control, and refreshing the form view in real time.
When the page is refreshed or the table page is revisited, the system reads the table configuration information from the cache, can acquire the page cache based on a dynamic page generation mechanism, and returns the modified table configuration information to the user after modifying the table configuration information in the page according to the table configuration information and the jsup interface. Configuration information loading specifically involves the following problems:
column width and priority of column order. There is a priority issue when loading a page because column width and column order exist in multiple fields. Fig. 4 is a flowchart of a method of processing priorities in accordance with a preferred embodiment of the present invention. As shown in fig. 4, when loading a page, first obtaining a column title of a table design field, an alignment mode, and whether to hide 3 attributes to modify the page configuration, when setting a column width, if a storage field dragging the column width is not empty, using a width attribute dragging the column width field to modify the page, otherwise, using a column width in the table design; similarly, when the column sequence is set, if the storage field of the dragged column sequence is not empty, the page is modified by using the field of the dragged column sequence, otherwise, the column sequence in the table design is used.
A column ordering algorithm. When the user configuration information is stored, the column sequence is identified by seq fields, and when the page is loaded, the columns need to be reordered by using the information. The specific method is that the stored column information is traversed, and the column labels in the page are obtained according to the field attribute. When the seq field is smaller than the sequence of the column in the page (namely, the user adjusts the column to a position more ahead), moving the html tag of the column to the front of the seq tag of the current page by using a jsup interface; when the seq field is larger than the sequence of the column in the page (namely, the user adjusts the column to a more rear position), the html tag of the column is moved to the rear of the seq tag of the current page by using a jsup interface; otherwise, no processing is performed. Since it is difficult to record the sequence of the user's column moving operation when the user performs table design, it is necessary to record all columns whose sequence changes during storage, rather than only columns that the user moves, and in some cases, there may be more data stored in the database. However, the sorting algorithm is simple and effective, does not depend on the sequence of user operation, and does not affect the final sorting result when the configuration information of which column is taken first for sorting, so that the final sorting is ensured to be correct.
Regarding the handling of hidden columns. In the page development process, developers often write some hidden columns in a table, and the hidden columns are hidden by adding attributes, such as visible ═ false, to column labels. These columns are used to record background information and are not displayed on the page and should not be viewed by the user.
Likewise, these hidden columns should not appear on the table design page. Since the present invention allows the user to hide columns, while columns hidden by the user still need to be displayed on the form design page when the form design page is opened again, it is necessary to distinguish between columns hidden by the developer and columns hidden by the user. Based on a page dynamic loading mechanism, when a page is loaded, before user-defined table configuration information is loaded, a system acquires original page information through a page cache, an allowDesign attribute is added to a visible column of false, the false is assigned, and the column is identified to be incapable of being designed.
The embodiment of the invention provides rich personalized setting modes, and a user can set column titles, column widths, column alignment modes, column sequences and column display states through a table design page, and can also set the column widths and the header sequences of tables through dragging to take care of the operation habits of different users. The table configuration information is stored in the relational database through json, only the changed content is stored, the space efficiency is improved, and the time efficiency is improved by setting a cache in the memory; when the page is loaded, the reading and the setting of the configuration information of the table are completely finished in the background on the basis of a dynamic page generation mechanism, and redundant ajax requests do not need to be sent.
Fig. 2 is a schematic structural diagram of a system for personalizing a table based on a dynamic page according to a preferred embodiment of the present invention. The system comprises: determination means 201, retrieval means 202, presentation means 203, parsing means 204, processing means 205 and setting means 206.
The determining device 201, when receiving a processing request for a page, obtains a page cache, searches whether a table exists in the page, if so, searches whether a configuration information cache of the table exists, determines a table identifier of the selected table and a requester identifier of a user according to the processing request, and determines whether table information of the selected table is in a system cache based on the table identifier.
Retrieving means 202, when it is determined that the form information of the selected form is not in the system cache, retrieving in the customization database based on the requestor identifier to obtain customization settings associated with the user and corresponding to the predetermined form in the form settings page.
The presentation device 203 performs initial presentation on a predetermined form in the form setting page according to the customized setting.
The parsing device 204, after initiating the presentation, receives the modification information from the user, and parses the modification information to determine at least one configuration item.
The processing device 205 personalizes a plurality of configuration items in a table setting page to configure the selected table with each configuration item.
The setting device 206 sets the configuration information of the configured selected form as the customization setting of the selected form, stores the customization setting in the customization database, and stores the configured selected form in the system cache.
When storing the configured selected table in the system cache, the dynamic page modifies the selected table before configuration only according to the changed content of the configured selected table compared with the selected table before configuration. When storing the configured selected table in the relational database, the dynamic page modifies the selected table before configuration only according to the changed content of the configured selected table compared with the selected table before configuration.
And reading and/or setting the configuration information of the selected form at the service side based on a dynamic page generation mechanism during loading. The configuration items include: column name, column order, column width, and/or display status. In response to receiving a reset indication for the selected table, the pair restores the configuration item of the selected table to an initial state. And calling an interface of the form control, acquiring the form header information and transmitting the form header information to a form setting page, so that the form setting page records and displays the form header information. When the selected table relates to a composite header, the table setup page will load the table information using the tree list; when the configuration information is stored, the character strings in the preset format are used and the format information of the selected table is stored according to an array structure, wherein each element of the array structure represents the format information of one column and comprises a column identifier, a column name, a column width, a display state, a data alignment mode and a serial number.
Detecting a user-adjusted column width at predetermined time intervals, detecting a user-adjusted column order at predetermined time intervals, and transmitting column width information of at least one selected table and/or column order information of the selected table at predetermined time intervals. Information about the adjusted column width, the adjusted column order, and the table design is stored in three fields of the relational database. And when the configuration information of the set page of the table is saved, clearing the column width field and the column sequence field to show the priority of the column width and the column sequence. After the configuration information is stored, the form setting page is closed, the configuration data returned by the form setting page is obtained, an interface of the form control is called, and the view of the selected form is refreshed immediately. And based on the form configuration information read from the system cache and based on a dynamic page generation mechanism, acquiring the page cache, modifying the selected form in the page according to the form configuration information, and returning the modified form to the user. When a page associated with a selected table is loaded, acquiring page configuration of column titles, alignment modes and display states; when setting the column width, if the storage field of the column width is not empty, modifying the page by using the width attribute of the column width field, otherwise, using the column width in the customized setting; when the column sequence is set, if the storage field of the column sequence is not empty, the page is modified by using the field of the column sequence, otherwise, the column sequence in the customized setting is used. Traversing the stored column information, and acquiring column tags in the page according to the field attributes; when the sequence number N field is smaller than the sequence of the columns in the page, moving the labels of the columns to the front of the N labels of the current page; when the sequence number N field is larger than the sequence of the columns in the page, moving the labels of the columns to the back of the N labels of the current page; otherwise, no processing is performed. By adding a display attribute on the column label; setting the display attribute to be 0, wherein the display attribute of 0 represents that the display state is hidden; the display attribute is set to 1, and a display attribute of 1 indicates that the display state is display.
The invention has been described with reference to a few embodiments. However, other embodiments of the invention than the one disclosed above are equally possible within the scope of the invention, as would be apparent to a person skilled in the art from the appended patent claims.
Generally, all terms used in the claims are to be interpreted according to their ordinary meaning in the technical field, unless explicitly defined otherwise herein. All references to "a/an/the [ device, component, etc ]" are to be interpreted openly as referring to at least one instance of said device, component, etc., unless explicitly stated otherwise. The steps of any method disclosed herein do not have to be performed in the exact order disclosed, unless explicitly stated.
Claims (10)
1. A method of personalizing a form based on a dynamic page, the method comprising:
when a processing request aiming at a page is received, acquiring a page cache, searching whether a table exists in the page, if so, searching whether a configuration information cache of the table exists, determining a table identifier of the selected table and a requester identifier of a user according to the processing request, and determining whether the table information of the selected table is in a system cache or not based on the table identifier;
upon determining that the form information for the selected form is not in the system cache, retrieving in a customization database based on the requestor identifier to obtain customization settings associated with the user and corresponding to a predetermined form in a form settings page;
initializing and presenting a preset form in a form setting page according to the customized setting, and receiving modification information from a user after the initialization and presentation;
parsing the modification information to determine at least one configuration item;
the method comprises the steps that a plurality of configuration items are set in a table setting page in a personalized mode, so that a selected table is configured through each configuration item;
setting configuration information of the configured selected form as customization settings of the selected form, storing the customization settings in a customization database, and storing the configured selected form in a system cache.
2. The method of claim 1, wherein the dynamic page modifies the selected table prior to the configuring based only on the changed contents of the selected table prior to the configuring as compared to the selected table prior to the configuring when the selected table is stored in the system cache.
3. The method of claim 1, wherein upon storing the configured selected table in the relational database, the dynamic page modifies the pre-configured selected table based only on the changed contents of the configured selected table compared to the pre-configured selected table.
4. The method of claim 1, wherein reading and/or setting configuration information of the selected table is performed at the service side based on a dynamic page generation mechanism at the time of loading.
5. The method of claim 1, the configuration item comprising: column name, column order, column width, and/or display status.
6. A system for processing a table based on a dynamic page, the system comprising:
the device comprises a determining device, a system cache and a processing device, wherein the determining device is used for acquiring a page cache when receiving a processing request aiming at a page, searching whether a table exists in the page, if so, searching whether a configuration information cache of the table exists, determining a table identifier of a selected table and a requester identifier of a user according to the processing request, and determining whether the table information of the selected table is in the system cache or not based on the table identifier;
retrieving means for retrieving in the customization database based on the requestor identifier to obtain customization settings associated with the user and corresponding to a predetermined form in a form settings page when it is determined that form information of the selected form is not in the system cache;
the presentation device is used for carrying out initialization presentation on a preset form in the form setting page according to the customized setting;
the analysis device receives modification information from a user after the initialization presentation, and analyzes the modification information to determine at least one configuration item;
the processing device is used for carrying out personalized setting on a plurality of configuration items in the table setting page so as to configure the selected table by utilizing each configuration item;
and the setting device is used for setting the configuration information of the configured selected table as the customization setting of the selected table, storing the customization setting in the customization database and storing the configured selected table in the system cache.
7. The system of claim 6, wherein the dynamic page modifies the selected table prior to configuration based only on changes to the selected table prior to configuration as compared to the selected table prior to configuration when the selected table is stored in the system cache.
8. The system of claim 6, wherein, when storing the configured selected table in the relational database, the dynamic page modifies the pre-configured selected table based only on the changed contents of the configured selected table compared to the pre-configured selected table.
9. The system of claim 6, wherein the reading and/or setting of the configuration information of the selected form is performed at the service side based on a dynamic page generation mechanism at the time of loading.
10. The system of claim 6, the configuration items comprising: column name, column order, column width, and/or display status.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911412352.7A CN111124411A (en) | 2019-12-31 | 2019-12-31 | Method and system for personalized setting of form based on dynamic page |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911412352.7A CN111124411A (en) | 2019-12-31 | 2019-12-31 | Method and system for personalized setting of form based on dynamic page |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111124411A true CN111124411A (en) | 2020-05-08 |
Family
ID=70506465
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911412352.7A Pending CN111124411A (en) | 2019-12-31 | 2019-12-31 | Method and system for personalized setting of form based on dynamic page |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111124411A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112035104A (en) * | 2020-08-28 | 2020-12-04 | 重庆长安汽车股份有限公司 | Modeling method for dynamically changing function configuration of mobile application |
| CN112099898A (en) * | 2020-11-06 | 2020-12-18 | 广州市玄武无线科技股份有限公司 | Form processing system and method based on Web front end |
| CN112417836A (en) * | 2020-11-27 | 2021-02-26 | 智业软件股份有限公司 | Automatic table generation method, terminal equipment and storage medium |
| CN112580315A (en) * | 2020-12-14 | 2021-03-30 | 深圳市金证前海金融科技有限公司 | Webpage table display method and device, terminal equipment and medium |
| CN113095055A (en) * | 2021-04-20 | 2021-07-09 | 山石网科通信技术股份有限公司 | Table modification method and device, nonvolatile storage medium and processor |
| CN113378533A (en) * | 2021-06-08 | 2021-09-10 | 傲普(上海)新能源有限公司 | Energy system based form processing method for mass data |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107370786A (en) * | 2017-06-02 | 2017-11-21 | 广州杰赛科技股份有限公司 | A kind of general information management system based on micro services framework |
| CN107526755A (en) * | 2016-09-27 | 2017-12-29 | 腾讯科技（深圳）有限公司 | The processing method and processing device of data |
| CN109840303A (en) * | 2019-01-02 | 2019-06-04 | 平安科技（深圳）有限公司 | Original list method for customizing, device, equipment and computer readable storage medium |
-
2019
- 2019-12-31 CN CN201911412352.7A patent/CN111124411A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107526755A (en) * | 2016-09-27 | 2017-12-29 | 腾讯科技（深圳）有限公司 | The processing method and processing device of data |
| CN107370786A (en) * | 2017-06-02 | 2017-11-21 | 广州杰赛科技股份有限公司 | A kind of general information management system based on micro services framework |
| CN109840303A (en) * | 2019-01-02 | 2019-06-04 | 平安科技（深圳）有限公司 | Original list method for customizing, device, equipment and computer readable storage medium |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112035104A (en) * | 2020-08-28 | 2020-12-04 | 重庆长安汽车股份有限公司 | Modeling method for dynamically changing function configuration of mobile application |
| CN112035104B (en) * | 2020-08-28 | 2024-03-22 | 重庆长安汽车股份有限公司 | Modeling method for dynamically changing functional configuration of mobile application |
| CN112099898A (en) * | 2020-11-06 | 2020-12-18 | 广州市玄武无线科技股份有限公司 | Form processing system and method based on Web front end |
| CN112099898B (en) * | 2020-11-06 | 2021-02-09 | 广州市玄武无线科技股份有限公司 | Form processing system and method based on Web front end |
| CN112417836A (en) * | 2020-11-27 | 2021-02-26 | 智业软件股份有限公司 | Automatic table generation method, terminal equipment and storage medium |
| CN112580315A (en) * | 2020-12-14 | 2021-03-30 | 深圳市金证前海金融科技有限公司 | Webpage table display method and device, terminal equipment and medium |
| CN113095055A (en) * | 2021-04-20 | 2021-07-09 | 山石网科通信技术股份有限公司 | Table modification method and device, nonvolatile storage medium and processor |
| CN113378533A (en) * | 2021-06-08 | 2021-09-10 | 傲普(上海)新能源有限公司 | Energy system based form processing method for mass data |
| CN113378533B (en) * | 2021-06-08 | 2023-12-05 | 傲普(上海)新能源有限公司 | Form processing method for large amount of data based on energy system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111124411A (en) | Method and system for personalized setting of form based on dynamic page | |
| EP2260413B1 (en) | Web content management | |
| US8060634B1 (en) | Determining and displaying a count of unread items in content feeds | |
| US8819542B2 (en) | Enterprise web application constructor system and method | |
| US8935620B1 (en) | Dynamic content management | |
| US7917846B2 (en) | Web clip using anchoring | |
| US8725719B2 (en) | Managing web page links using structured data | |
| US9075505B2 (en) | Content feed user interface | |
| US8549097B2 (en) | Web application for accessing media streams | |
| US7590939B2 (en) | Storage and utilization of slide presentation slides | |
| US9519713B2 (en) | Method for searching for multimedia content items on the internet | |
| US20100257466A1 (en) | Method and system for generating a mini-software application corresponding to a web site | |
| US8645497B2 (en) | Bookmark-based access to content feeds | |
| US20080086755A1 (en) | Recursive Subscriptions to Content Feeds | |
| US20060155728A1 (en) | Browser application and search engine integration | |
| US20080184102A1 (en) | Browser extension for web form capture | |
| US20080086484A1 (en) | Server System for Serving Extended Content Feeds to Clients | |
| US20100070862A1 (en) | In-page embeddable platform for media selection and playlist creation | |
| US20100070871A1 (en) | Extendable Recommender Framework for Web-Based Systems | |
| US20090089248A1 (en) | System and method of filtering search results | |
| US20070266321A1 (en) | Visualizing Navigable Object Hierarchy | |
| US8131743B1 (en) | Object searching in data storage systems | |
| KR20090061666A (en) | Content feed user interface | |
| US20060156243A1 (en) | Systems and methods for sharing loops | |
| US8135697B2 (en) | Search-friendly templates |
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 |