An intelligent design method for online forms

Through the intelligent design method of online form, editing conflicts are detected and resolved in real time, and the new report structure is automatically generated using historical report data, which solves the problems of editing conflicts and inefficient report generation in a multi-user collaboration environment, and realizes efficient data management and report production.

CN119250046BActive Publication Date: 2025-05-30ZHEJIANG MAI XIN TECH CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202411773703.8
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-12-05
Publication Date
2025-05-30
Estimated Expiration
2044-12-05

AI Technical Summary

Technical Problem

In a multi-user collaboration environment, existing report editing systems are difficult to effectively detect and resolve editing conflicts, resulting in data loss or errors, and the inability to automatically generate new report structures using historical report data, resulting in inefficient report production.

Method used

The online form intelligent design method is adopted, and by setting dynamic data grids and location information identification, editing conflicts are detected and resolved in real time, conflict resolution strategies are provided, and a new report structure is automatically generated based on existing reports.

Benefits of technology

It improves the collaborative efficiency of report editing, reduces errors and delays caused by conflicts, improves data quality and work efficiency, and significantly improves the efficiency of report generation and production.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119250046B_ABST
    Figure CN119250046B_ABST
Patent Text Reader

Abstract

The present invention relates to the technical field of intelligent report processing, and discloses an online form intelligent design method, aiming to improve the flexibility of report production and the intelligence of data processing. The method includes the following steps: constructing a report structure containing multiple dynamic data cells, extracting keywords in the report name to form a report name keyword set, classifying similar reports to form a similar report set, obtaining the corresponding similar report set according to the keyword information to generate a keyword field set, each similar report set corresponding to a keyword field set, generating a new report according to the keyword field set and the keyword information input by the user, and marking the newly generated report as the first report. For the first report, a row title data conflict strategy is executed, and a row data sorting strategy is executed to optimize the position information of the data cells edited by the user.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of intelligent report processing, and specifically to an online form intelligent design method. Background Art

[0002] In the context of the rapid development of information technology, data management and report editing in enterprise operations have become increasingly dependent on spreadsheets and intelligent forms, which make data entry, processing, and analysis more efficient. However, new challenges have also emerged. Especially in a multi-user collaboration environment, when users with different permissions edit the same report, how to effectively resolve data conflicts and ensure data consistency and accuracy has become an urgent problem to be solved.

[0003] During the traditional report editing process, when multiple users edit the same data cell or the same row of data simultaneously, "editing conflicts" often occur. This phenomenon not only leads to data loss or errors but may also affect the accuracy and timeliness of decision-making. Existing reports often lack effective conflict detection and resolution mechanisms, resulting in users unknowingly overwriting others' changes or losing their own work results.

[0004] In a multi-user collaboration environment, when users with different permissions attempt to edit the same data cell simultaneously, the lack of real-time conflict prompts and solutions may lead to duplicate work and increased communication costs. In addition, when multiple users edit the same row of data, existing methods often fail to provide intuitive conflict markers and handling suggestions, making it difficult for users to quickly identify and resolve conflicts.

[0005] Furthermore, in existing technologies, it is impossible to generate a new report structure based on previously completed reports, resulting in the need to start from scratch every time a report is made, with low efficiency. This means that although enterprises may already have a large amount of historical report data and structures, these valuable resources cannot be effectively utilized to accelerate the creation process of new reports.

[0006] Therefore, developing an intelligent form method that can effectively resolve editing conflicts is of great significance for improving the efficiency of data management and ensuring data accuracy and integrity. It is necessary to be able to detect conflicts in real time when users edit reports, provide conflict resolution strategies, and allow users with different permissions to choose the most suitable solution according to the actual situation. Through this method, the collaboration efficiency of report editing can be significantly improved, errors and delays caused by conflicts can be reduced, thereby enhancing the work efficiency and data quality of the entire organization. At the same time, the function of automatically generating a new report structure based on existing reports will greatly improve the efficiency of report production, reduce repetitive labor, and speed up the decision-making process. Summary of the Invention

[0007] The present invention provides an intelligent design method for online forms to facilitate the solution of the problems mentioned in the above background art.

[0008] The present invention provides the following technical solutions: An intelligent design method for online forms,

[0009] Optionally, set the report structure;

[0010] The report structure includes multiple dynamic data cells;

[0011] Each dynamic data cell corresponds to a position information identifier;

[0012] The dynamic data cell is used to store and display the data edited by the user;

[0013] The position information identifier includes a row identifier and a column identifier, and the position information identifier is expressed as ( , ), where the column identifier is expressed as , and the row identifier is expressed as ;

[0014] If there is data edited by the user in the dynamic data cell, mark the dynamic data cell as an edited data cell;

[0015] Set column headers and row headers to identify the content of the edited data cells;

[0016] In a report, if there is one or more column headers, obtain the position information of the column headers and form a column header set;

[0017] According to the position information of the column headers, obtain the content of the edited data cells to which the position information belongs, denoted as column header content;

[0018] For example, if the content in the edited data cell to which the column header belongs is "Name", then the column header content corresponding to this column header is "Name";

[0019] In a report, if there are multiple row headers, form a row header set;

[0020] Set report information;

[0021] The report information includes a report name, a column header set, and a row header set, and each report corresponds to a report information;

[0022] Obtain the report name of each report and execute a report classification strategy according to the report name;

[0023] The report classification strategy is used to classify reports with similar report names and form a set, denoted as a similar report set;

[0024] Obtain the keyword information input by the user, and obtain the corresponding set of similar reports according to the keyword information;

[0025] Set the keyword fields, execute the keyword field marking strategy, and generate a set of keyword fields;

[0026] Each set of similar reports corresponds to a set of keyword fields;

[0027] According to the set of keyword fields and the keyword information input by the user, execute the report generation strategy, and mark the newly generated report as the first report;

[0028] Set the monitoring time period, and divide the monitoring time period every 30s;

[0029] For the first report, if multiple users perform editing operations on the dynamic data cells corresponding to the same row title in the same monitoring time period, then execute the row title data conflict strategy;

[0030] For the first report, execute the row data sorting strategy.

[0031] Optionally, obtain the report name of each report, and execute the report classification strategy according to the report name, including:

[0032] The specific steps of the report classification strategy are as follows;

[0033] Extract the keywords in each report name to form a set, denoted as the report name keyword set;

[0034] Obtain the reports corresponding to each keyword in the report name keyword set, and form a set, denoted as the set of similar reports;

[0035] Each keyword corresponds to a set of similar reports;

[0036] Setting the report structure provides a framework for report production, allowing users to customize the report structure according to different needs to adapt to the data input requirements of different users. The dynamic data cells can be updated in real time according to the user's operations, improving the real-time performance and flexibility of the report. By uniquely identifying each data cell, the positioning and retrieval of data are ensured. An interactive platform is provided where users can directly edit data in the data cells, making data input more intuitive and convenient. Through the identification of rows and columns, users can quickly understand and identify the content and location of the data cells. Mark the dynamic data cells as edited data cells. By marking the edited data cells, it can be shown which data has been modified, facilitating tracking and auditing. According to the keyword field set and the keyword information input by the user, execute the report generation strategy to quickly generate a new report, improving the efficiency of report generation. Set the monitoring time period, divide the monitoring time period every 30s. Through regular monitoring, execute the row data sorting strategy to organize multiple rows of data edited by the same user together, improving the readability and neatness of the report. If a user edits multiple rows of data, these data will be presented together instead of being mixed with the data of other users;

[0037] Optionally, set the keyword fields and execute the keyword field marking strategy to generate a keyword field set, including:

[0038] The specific steps of the keyword field marking strategy are as follows;

[0039] Obtain a set of similar reports;

[0040] Form a set of column header contents by including all the column header contents in each report in the set of similar reports;

[0041] Calculate the frequency of occurrence of each column header content, denoted as the column header content frequency. The formula is: column header content frequency = ;

[0042] According to the frequency of occurrence of each column header content, form a set of column header content frequencies, where one column header content corresponds to one column header content frequency;

[0043] According to the set of column header frequencies, obtain the frequency corresponding to each column header content and sort them from high to low in frequency to form a first sorted sequence;

[0044] Perform keyword field marking on each column header content in the first sorted sequence, and the marking order is carried out sequentially starting from the first in the sequence, specifically as the first keyword field, the second keyword field... the Qth keyword field;

[0045] where Q is the number of elements in the set of column header frequencies;

[0046] Form a set of the marked keyword fields, denoted as the keyword field set;

[0047] Form a set of all the marked keyword fields. By assigning specific position information identifiers to each element in the keyword field set and filling them in the newly generated report, it ensures the correct placement of the keyword fields in the report, improves the accuracy of the report, automatically fills the report according to the keyword field set, reduces the workload of manual input, and improves the efficiency of report generation;

[0048] Optionally, according to the keyword field set and the keyword information input by the user, execute the report generation strategy, and mark the newly generated report as the first report, including:

[0049] The specific steps of the report generation strategy are as follows;

[0050] Assign position information identifiers to each element in the keyword field set and fill them in the newly generated report. Specifically, the position information identifier corresponding to the first keyword field is ( , ), the position information identifier corresponding to the second keyword field is ( , ),... the position information identifier corresponding to the Qth keyword field is ( , );

[0051] Among them, ( , ) represents the column identifier corresponding to the Qth keyword field, represents the row identifier corresponding to the Qth keyword field; represents the row identifier corresponding to the Qth keyword field;

[0052] Mark the generated report as the first report.

[0053] Optionally, for the first report, if multiple users perform edit operations on the dynamic data cells corresponding to the same row title during the same monitoring time period, then execute the row title data conflict strategy, including:

[0054] The edit operations on the dynamic data cells are divided into three methods, specifically filling in content, deleting content, and modifying content;

[0055] When a user performs an edit operation on the report, obtain the user identification ID and the data cell operation information;

[0056] The data cell operation information is the position information, edit method, edit start time, and edit end time of the dynamic data cell where the user performs the edit.

[0057] Optionally, if multiple users perform editing operations on the dynamic data cells corresponding to the same row title within the same monitoring time period, the row title data conflict strategy is also executed, and it further includes:

[0058] The row title data conflict strategy is divided into the same data cell conflict strategy and the different data cell conflict strategy;

[0059] Mark multiple users who perform editing operations on the same dynamic data cell within the same monitoring time period as the first users and form a first user set;

[0060] Execute the same data cell conflict strategy for the first user set;

[0061] Mark multiple users who perform editing operations on different dynamic data cells within the same monitoring time period as the second users and form a second user set;

[0062] Execute the different data cell conflict strategy under the same row title for the second user set.

[0063] Optionally, the execution of the same data cell conflict strategy for the first user set includes:

[0064] Mark the dynamic data cell edited by multiple first users as the first data cell;

[0065] Obtain the position information identifier of the first data cell, denoted as ( , ), where is the column identifier of the first data cell, and is the row identifier of the first data cell;

[0066] Set user permission levels, divided into high permission level and low permission level;

[0067] Each user identifier ID corresponds to a user permission level;

[0068] Obtain the user identifier ID of each first user in the first user set, and obtain the user permission level of each first user according to the user identifier ID;

[0069] If there is a high-permission first user and one or more low-permission first users in the first user set, obtain the data cell operation information of one or more low-permission first users, and according to the data cell operation information, obtain the editing start time of each low-permission user. If there is only one low-permission first user, mark the editing start time of this user as the first start time;

[0070] If there are multiple first users with low permissions, they are sorted in ascending order of the editing start times of the first users with low permissions to form a sorted sequence, denoted as the second sorted sequence;

[0071] Obtain the editing start time with the first rank in the second sorted sequence, and mark it as the first start time;

[0072] Obtain the editing start time with the second rank in the second sorted sequence, and mark it as the second start time;

[0073] Obtain the editing start time with the Z-th rank in the second sorted sequence, and mark it as the Z-th start time;

[0074] where Z is the number of first users with low permissions in the first user set;

[0075] If the number of first users with high permissions in the first user set is equal to 1 and the number of first users with low permissions is equal to 1, the first user with high permissions and the first user with low permissions perform an editing operation on the first data cell. When the first user with high permissions completes the editing operation, obtain the editing method and the corresponding edited content of the first user with high permissions, and update them to the first data cell; when the first user with low permissions completes the editing operation, obtain the editing method and the corresponding edited content of the first user with low permissions, and update them to the dynamic data cell directly below the first data cell, and the position information identifier of this dynamic data cell is ( , );

[0076] If the number of first users with high permissions in the first user set is equal to 1 and the number of first users with low permissions is greater than 1, one first user with high permissions and multiple first users with low permissions perform an editing operation on the first data cell. When the first user with high permissions completes the editing operation, obtain the editing method and the corresponding edited content of the first user with high permissions, and update them to the first data cell; when the first user with low permissions completes the editing operation, obtain the editing start time of the first user with low permissions, and obtain the corresponding first target data cell according to the editing start time;

[0077] The first target data cell is the first target data cell corresponding to the first start time to the Z-th start time in the second sorted sequence, and each start time corresponds to the position information identifier of a first target data cell. Specifically, the first start time corresponds to ( , ), the second start time corresponds to , )... the Z-th start time corresponds to ( , );

[0078] Obtain the editing method and the corresponding edited content of the first user with low permissions, and update them to the corresponding first target data cell.

[0079] Optionally, performing the same data cell conflict strategy for the first user set further includes:

[0080] If the number of high-privilege first users in the first user set is greater than 1 and the number of low-privilege first users is equal to 0, obtain the data cell operation information of each high-privilege first user, and according to the data cell operation information, obtain the editing start time of each high-privilege first user, and sort them in chronological order to form a sorting sequence, denoted as the third sorting sequence;

[0081] Obtain the editing start time ranked first in the third sorting sequence, and mark it as the first start time;

[0082] Obtain the editing start time ranked second in the third sorting sequence, and mark it as the second start time;

[0083] Obtain the editing start time ranked Jth in the third sorting sequence, and mark it as the Jth start time;

[0084] Where J is the number of high-privilege first users in the first user set;

[0085] For multiple high-privilege first users to perform editing operations on the first data cell, when the high-privilege first user corresponding to the first start time in the third sorting sequence completes the editing operation, obtain the editing method and the corresponding editing content of the high-privilege first user, and update them to the first data cell;

[0086] When the remaining high-privilege first users complete the editing operation, obtain the editing start time of the high-privilege first user, and obtain the corresponding second target data cell according to the editing start time;

[0087] The remaining high-privilege first users are users other than the high-privilege first user corresponding to the first start time in the first user set;

[0088] The second target data cell is the second target data cell corresponding to the second start time to the Jth start time in the third sorting sequence, and each start time corresponds to a position information identifier of a second target data cell. Specifically, the second start time corresponds to ( , ), the third start time corresponds to , ),... the Jth start time corresponds to ( , );

[0089] Obtain the editing method and the corresponding editing content of the remaining high-privilege first users, and update them to the corresponding second target data cells;

[0090] If the number of high-privilege first users in the first user set is equal to 0 and the number of low-privilege first users is greater than 1, obtain the data cell operation information of each low-privilege first user, and based on the data cell operation information, obtain the editing start time of each low-privilege first user, and sort them in chronological order to form a sorted sequence, denoted as the fourth sorted sequence;

[0091] Obtain the editing start time with the first rank in the fourth sorted sequence, and mark it as the first start time;

[0092] Obtain the editing start time with the second rank in the fourth sorted sequence, and mark it as the second start time;

[0093] Obtain the editing start time with the Kth rank in the fourth sorted sequence, and mark it as the Kth start time;

[0094] where K is the number of low-privilege first users in the first user set;

[0095] For multiple low-privilege first users to perform editing operations on the first data cell, when the low-privilege first user corresponding to the first start time in the fourth sorted sequence completes the editing operation, obtain the editing method and the corresponding edited content of this low-privilege first user, and update them to the first data cell;

[0096] When the remaining low-privilege first users complete the editing operation, obtain the editing start time of the low-privilege first user, and obtain the corresponding third target data cell according to the editing start time;

[0097] The remaining low-privilege first users are users other than the low-privilege first user corresponding to the first start time in the first user set;

[0098] The third target data cell is the third target data cell corresponding to the second start time to the Kth start time in the fourth sorted sequence, and each start time corresponds to a position information identifier of a third target data cell. Specifically, the second start time corresponds to ( , ), the third start time corresponds to , )... the Kth start time corresponds to ( , );

[0099] Obtain the editing method and the corresponding edited content of the remaining low-privilege first users, and update them to the corresponding third target data cells.

[0100] Optionally, the implementation of different data cell conflict strategies for the second user set under the same row title includes:

[0101] Mark the row title corresponding to the edit operation performed by the second user on the dynamic data cell as the target row title;

[0102] Obtain the position information identifiers corresponding to the dynamic data cells edited by the second user and form a set, denoted as the position information identifier set. Each second user corresponds to a position information identifier set;

[0103] Execute the dynamic data cell conflict matching strategy according to the position information identifier set of each second user;

[0104] The dynamic data cell conflict matching strategy is to obtain the position information identifier set of each second user and determine whether each position information identifier set intersects with other position information identifier sets;

[0105] If the number of position information identifier sets with intersections is equal to 0, obtain the editing method of the second user and the corresponding edited content, and update the dynamic data cells corresponding to each element in the position information identifier set;

[0106] If the number of position information identifier sets with intersections is greater than 0, mark the position information identifier sets with intersections, denoted as conflict sets. Each conflict set corresponds to a second user;

[0107] Classify the conflict sets, merge the conflict sets whose intersections contain one or more identical elements into one category, and mark it as the first classification;

[0108] Obtain the second user corresponding to each conflict set in the first classification and the corresponding edit start time, and sort them in chronological order to form a sorting sequence, denoted as the fifth sorting sequence;

[0109] Obtain the edit start time with the first rank in the fifth sorting sequence and mark it as the first start time;

[0110] Obtain the edit start time with the second rank in the fifth sorting sequence and mark it as the second start time;

[0111] Obtain the edit start time with the L-th rank in the fifth sorting sequence and mark it as the L-th start time;

[0112] Where L is the number of conflict sets in one category;

[0113] According to the fifth sorting sequence, obtain the editing method and the corresponding edited content of each element in the position information mark set of the second user corresponding to the first start time, and update them to the dynamic data cells corresponding to the target row title;

[0114] According to the fifth sorting sequence, obtain the editing method and corresponding edited content of each element in the set of location information markers of the second user corresponding to the I-th start time, increase the line identification subscript corresponding to each element in the location information identification set by I-1, and update it to the corresponding dynamic data cell;

[0115] where I is the I-th start time in the fifth sorting sequence;

[0116] By setting different user permission levels, it is possible to give priority to the data editing operations of high-privilege users, ensure the priority update of critical data, sort according to the user's editing start time, reasonably arrange the priority of editing operations, and avoid editing conflicts. It can ensure that the data of the user who starts editing earliest is processed first. According to the user's permission level and editing time, the edited content is assigned to the corresponding dynamic data cell, improving the flexibility of data processing. The edited content of low-privilege users can be placed below the edited content of high-privilege users to maintain the data hierarchy. When dealing with the editing operations of multiple high-privilege or low-privilege users on the same data cell, through the sorting and assignment mechanism, it is ensured that all users' edits are reasonably considered, and conflicts between multiple high-privilege or multiple low-privilege users are ensured to be handled. By recording the editing start time and edited content of each user, the editing history is retained, facilitating subsequent traceability and auditing.

[0117] Optionally, the execution of the row data sorting strategy for the first report includes:

[0118] The row data sorting strategy specifically includes the following steps;

[0119] The row data is all the edited data cell contents included in each row title in the report;

[0120] Mark the row data edited by the same user as the target row data;

[0121] When the first report is generated, divide it into groups every five monitoring time periods, and mark each group as the first group of monitoring time periods, the second group of monitoring time periods... the H-th group of monitoring time periods;

[0122] Obtain all the target row data within each group of monitoring time periods, and obtain the user identification ID corresponding to each target row data, and form a set, denoted as the optimized user set;

[0123] One group of monitoring time periods corresponds to one optimized user set, and obtain the number of target row data corresponding to each user identification ID;

[0124] If there is a user identification ID with multiple target row data, obtain the number of target row titles, denoted as r; obtain the row title corresponding to the target row data with the earliest editing start time, and the position information corresponding to this row title, denoted as ( , ); optimize the position information corresponding to the edited data cells included in the target row data under this user identification ID, and this optimization process is denoted as the first optimization process;

[0125] The specific expression of the first optimization process is that the first target row data is ( , ), ( , )... ( , ); the second target row data is ( , ), ( , )... ( , ); the r-th target row data is ( , ), ( , )... ( , );

[0126] where a is the number of edited data cells in the target row data minus one;

[0127] If, during the first optimization process, there is a conflict in the position information of the target row data under other user identification IDs, then place the position information of this target row data below the r-th target row data;

[0128] If each user identification ID has only one target row data, then do not change the position information of the edited data cells corresponding to the target row data;

[0129] By marking the row data edited by the same user as target row data, the editing content of each user is centrally managed within the monitoring time period. It is divided into groups with every five monitoring time periods as a group, and each group is marked. This grouping strategy helps manage data editing in different time periods. By obtaining all the target row data within each group of monitoring time periods and obtaining the user identification ID corresponding to each target row data, an optimized user set is formed, enabling the analysis of each user's editing behavior. Optimize the target row data according to the user identification ID. Especially when a user identification ID has multiple target row data, organize these row data to improve the readability and neatness of the data. If a user edits in multiple rows, organize these row data together for easy viewing and analysis by the user. In the first optimization process, if there is a conflict in location information, place the conflicting target row data at the bottom to avoid data coverage and loss. If there is only one target row data under each user identification ID, do not change the location information of the edited data cell to maintain the originality and integrity of the data.

[0130] The present invention has the following beneficial effects:

[0131] 1. For this online form intelligent design method, setting the report structure provides a framework for report production, allowing users to customize the report structure according to different needs to adapt to the data input requirements of different users. The dynamic data cells can be updated in real time according to the user's operations, improving the real-time performance and flexibility of the report. By uniquely identifying each data cell, it ensures the positioning and retrieval of data, provides an interactive platform, and users can directly edit data in the data cell, making data input more intuitive and convenient. Through the identification of rows and columns, users can quickly understand and identify the content and location of the data cell. Mark the dynamic data cell as an edited data cell. By marking the edited data cells, it can show which data has been modified, facilitating tracking and auditing. According to the keyword field set and the keyword information input by the user, execute the report generation strategy to quickly generate a new report, improving the efficiency of report generation. Set the monitoring time period, divide the monitoring time period every 30s, and through regular monitoring, execute the row data sorting strategy to organize multiple rows of data edited by the same user together, improving the readability and neatness of the report. If a user edits multiple rows of data, these data will be centrally displayed instead of being mixed with the data of other users.

[0132] 2. The online form intelligent design method extracts keywords from the report name and forms a set to quickly classify reports, improving the efficiency of report management. Users can quickly retrieve relevant report sets through any keyword, enhancing the flexibility and convenience of report retrieval. This method automatically organizes reports containing the same keyword into similar report sets. Through the report classification strategy, users can more intuitively view the classification and organizational structure of reports, optimizing the user experience. By implementing the keyword field marking strategy, it identifies and marks the column header content that frequently appears in similar report sets. By calculating the occurrence frequency of each column header content, it can determine which column header content is the key information in the report. Sorting the column header content from high to low frequency forms a priority sequence, and keyword field marking is performed on the column header content according to the sorted sequence.

[0133] All marked keyword fields are formed into a set. By assigning specific position information identifiers to each element in the keyword field set and filling them in the newly generated report, it ensures the correct placement of keyword fields in the report, improving the accuracy of the report. Automatically filling the report according to the keyword field set reduces the workload of manual input and improves the efficiency of report generation.

[0134] 3. The online form intelligent design method identifies three editing operations (filling, deleting, modifying), which helps handle data conflicts and ensure data integrity and accuracy. For example, if user A fills in data and user B attempts to delete the same data, this conflict can be identified and corresponding measures can be taken. By obtaining the user identification ID and data cell operation information, it can track the editing behavior of each user, including location, editing method, and time, for conflict resolution. Real-time monitoring and resolution of data conflicts within the monitoring time period avoid data loss or error accumulation, improving the real-time performance and response speed of data management. By distinguishing between the same data cell conflict strategy and different data cell conflict strategies, it resolves conflicts in different situations. By marking the first user and the second user and forming corresponding user sets, it can manage the operations of different users on data cells, improving the efficiency of conflict resolution. By implementing the row header data conflict strategy, it optimizes the experience of multi-person collaborative editing and reduces conflicts and misunderstandings among users.

[0135] 4. The intelligent online form design method can prioritize the data editing operations of high-privilege users by setting different user privilege levels, ensuring the priority update of critical data. It sorts according to the start time of user editing, reasonably arranges the priority of editing operations, and avoids editing conflicts. It can ensure that the data of the user who starts editing earliest is processed first. According to the user's privilege level and editing time, the edited content is assigned to the corresponding dynamic data cells, improving the flexibility of data processing. The edited content of low-privilege users can be placed below that of high-privilege users to maintain the data hierarchy. When processing the editing operations of multiple high-privilege or low-privilege users on the same data cell, through the sorting and assignment mechanism, it ensures that all users' edits are reasonably considered and that conflicts between multiple high-privilege or multiple low-privilege users are resolved. By recording the start time and edited content of each user, the editing history is retained, facilitating subsequent traceability and auditing.

[0136] 5. The intelligent online form design method marks the row data edited by the same user as target row data, centrally manages the edited content of each user within the monitoring time period, divides it into groups with every five monitoring time periods as a group, and marks each group. This grouping strategy helps manage data editing within different time periods. By obtaining all the target row data within each group of monitoring time periods and the user identification ID corresponding to each target row data, an optimized user set is formed, enabling the analysis of each user's editing behavior. The target row data is optimized according to the user identification ID. Especially when a user identification ID has multiple target row data, these row data are sorted out, improving the readability and neatness of the data. If a user edits in multiple rows, these row data are sorted together for easy viewing and analysis by the user. In the first optimization process, if there is a conflict in location information, the conflicting target row data is placed at the bottom to avoid data overwriting and loss. If there is only one target row data under each user identification ID, the location information of the edited data cell is not changed, maintaining the originality and integrity of the data. Brief Description of the Drawings

[0137] Figure 1 It is the flowchart of the steps of the present invention.

[0138] Figure 2 It is the schematic diagram of the report structure. Detailed Embodiment

[0139] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts shall fall within the protection scope of the present invention.

[0140] Refer to Figure 1 , optionally, set the report structure;

[0141] The report structure includes multiple dynamic data cells;

[0142] Each dynamic data cell corresponds to a location information identifier;

[0143] The dynamic data cell is used to store the data edited by the user and display the data edited by the user;

[0144] Refer to Figure 2 , the location information identifier includes a row identifier and a column identifier, and the location information identifier is expressed as ( , ), where the column identifier is expressed as , and the row identifier is expressed as ;

[0145] If there is data edited by the user in the dynamic data cell, mark the dynamic data cell as an edited data cell;

[0146] Set column headers and row headers to identify the content of the edited data cells;

[0147] In a report, if there is one or more column headers, obtain the location information of the column headers and form a column header set;

[0148] According to the location information of the column headers, obtain the content of the edited data cells to which the location information belongs, and record it as the column header content;

[0149] For example, if the content in the edited data cell to which the column header belongs is "Name", then the column header content corresponding to this column header is "Name";

[0150] In a report, if there are multiple row headers, form a row header set;

[0151] Set the report information;

[0152] The report information includes a report name, a column header set, and a row header set, and each report corresponds to a report information;

[0153] Obtain the report name of each report and execute a report classification strategy according to the report name;

[0154] The report classification strategy is used to classify reports with similar report names and form a set, denoted as the similar report set;

[0155] Obtain the keyword information input by the user, and obtain the corresponding similar report set according to the keyword information;

[0156] Set the keyword field, execute the keyword field marking strategy, and generate the keyword field set;

[0157] Each similar report set corresponds to a keyword field set;

[0158] According to the keyword field set and the keyword information input by the user, execute the report generation strategy, and mark the newly generated report as the first report;

[0159] Set the monitoring time period, and divide the monitoring time period every 30s;

[0160] For the first report, if multiple users perform edit operations on the dynamic data cells corresponding to the same row title in the same monitoring time period, then execute the row title data conflict strategy;

[0161] For the first report, execute the row data sorting strategy.

[0162] Optionally, the obtaining of the report name of each report and the execution of the report classification strategy according to the report name include:

[0163] The specific steps of the report classification strategy are as follows;

[0164] Extract the keywords in each report name to form a set, denoted as the report name keyword set;

[0165] Obtain the reports corresponding to each keyword in the report name keyword set and form a set, denoted as the similar report set;

[0166] Each keyword corresponds to a similar report set.

[0167] Optionally, the setting of the keyword field and the execution of the keyword field marking strategy to generate the keyword field set include:

[0168] The specific steps of the keyword field marking strategy are as follows;

[0169] Obtain the similar report set;

[0170] Form a column title content set by combining all the column title contents included in each report in the similar report set;

[0171] Calculate the frequency of occurrence of each column title content, denoted as the column title content frequency. The formula is: column title content frequency = ;

[0172] According to the frequencies of the content of each column header, a set of column header content frequencies is formed, where one column header content corresponds to one column header content frequency;

[0173] According to the set of column header frequencies, obtain the frequencies corresponding to each column header content, and sort them in descending order of frequency to form the first sorting sequence;

[0174] Perform keyword field marking on each column header content in the first sorting sequence, and the marking order is carried out sequentially starting from the first in the sequence. Specifically, it is the first keyword field, the second keyword field... the Qth keyword field;

[0175] where Q is the number of elements in the set of column header frequencies;

[0176] Form a set of the marked keyword fields, denoted as the keyword field set.

[0177] Optionally, according to the keyword field set and the keyword information input by the user, execute a report generation strategy, and mark the newly generated report as the first report, including:

[0178] The specific steps of the report generation strategy are as follows;

[0179] Assign position information identifiers to each element in the keyword field set and fill them in the newly generated report. Specifically, the position information identifier corresponding to the first keyword field is ( , ), the position information identifier corresponding to the second keyword field is ( , )... the position information identifier corresponding to the Qth keyword field is ( , );

[0180] where ( , ) represents the column identifier corresponding to the Qth keyword field, represents the row identifier corresponding to the Qth keyword field; represents the row identifier corresponding to the Qth keyword field;

[0181] Mark the generated report as the first report.

[0182] Optionally, for the first report, if multiple users perform editing operations on the dynamic data cells corresponding to the same row header during the same monitoring time period, then execute a row header data conflict strategy, including:

[0183] The editing operations on the dynamic data cells are divided into three methods, specifically filling in content, deleting content, and modifying content;

[0184] When the user performs an editing operation in the report, obtain the user identification ID and the data cell operation information;

[0185] The data cell operation information is the dynamic data cell position information, editing method, editing start time, and editing end time for the user to perform the editing.

[0186] Optionally, if multiple users perform editing operations on the dynamic data cells corresponding to the same row title during the same monitoring period, then implementing the row title data conflict strategy further includes:

[0187] The row title data conflict strategy is divided into the same data cell conflict strategy and the different data cell conflict strategy;

[0188] Mark multiple users who perform editing operations on the same dynamic data cell during the same monitoring period, denote them as the first users, and form a first user set;

[0189] Implement the same data cell conflict strategy for the first user set;

[0190] Mark multiple users who perform editing operations on different dynamic data cells during the same monitoring period, denote them as the second users, and form a second user set;

[0191] Implement the different data cell conflict strategy under the same row title for the second user set.

[0192] Optionally, implementing the same data cell conflict strategy for the first user set includes:

[0193] Mark the dynamic data cell edited by multiple first users as the first data cell;

[0194] Obtain the position information identifier of the first data cell, denoted as ( , )), where is the column identifier of the first data cell, and is the row identifier of the first data cell;

[0195] Set the user permission levels, divided into high permission level and low permission level;

[0196] Each user identification ID corresponds to a user permission level;

[0197] Obtain the user identification ID of each first user in the first user set, and obtain the user permission level of each first user according to the user identification ID;

[0198] If there is a high-privilege first user and one or more low-privilege first users in the first user set, obtain the data grid operation information of the one or more low-privilege first users, and according to the data grid operation information, obtain the editing start time of each low-privilege user. If there is only one low-privilege first user, mark the editing start time of this user as the first start time;

[0199] If there are multiple low-privilege first users, sort them in the order of their editing start times, forming a sorting sequence, denoted as the second sorting sequence;

[0200] Obtain the editing start time with the first rank in the second sorting sequence, and mark it as the first start time;

[0201] Obtain the editing start time with the second rank in the second sorting sequence, and mark it as the second start time;

[0202] Obtain the editing start time with the Z-th rank in the second sorting sequence, and mark it as the Z-th start time;

[0203] where Z is the number of low-privilege first users in the first user set;

[0204] If the number of high-privilege first users in the first user set is equal to 1 and the number of low-privilege first users is equal to 1, the high-privilege first user and the low-privilege first user perform an editing operation on the first data grid. When the high-privilege first user completes the editing operation, obtain the editing method and the corresponding edited content of the high-privilege first user, and update them to the first data grid; when the low-privilege first user completes the editing operation, obtain the editing method and the corresponding edited content of the low-privilege first user, and update them to the dynamic data grid directly below the first data grid, and the position information identifier of this dynamic data grid is ( , );

[0205] If the number of high-privilege first users in the first user set is equal to 1 and the number of low-privilege first users is greater than 1, one high-privilege first user and multiple low-privilege first users perform an editing operation on the first data grid. When the high-privilege first user completes the editing operation, obtain the editing method and the corresponding edited content of the high-privilege first user, and update them to the first data grid; when the low-privilege first user completes the editing operation, obtain the editing start time of the low-privilege first user, and obtain the corresponding first target data grid according to the editing start time;

[0206] The first target data grid is the first target data grid corresponding to the first start time to the Z-th start time in the second sorting sequence, and each start time corresponds to the position information identifier of a first target data grid. Specifically, the first start time corresponds to ( , ), the second start time corresponds to , ),... the Z-th start time corresponds to ( , );

[0207] Obtain the editing method of the first user with low permissions and the corresponding edited content, and update them to the corresponding first target data cell.

[0208] Optionally, the execution of the same data cell conflict policy for the first user set further includes:

[0209] If the number of first users with high permissions in the first user set is greater than 1 and the number of first users with low permissions is equal to 0, obtain the data cell operation information of each first user with high permissions, and according to the data cell operation information, obtain the editing start time of each first user with high permissions, and sort them in chronological order to form a sorting sequence, denoted as the third sorting sequence;

[0210] Obtain the editing start time with the first rank in the third sorting sequence, and mark it as the first start time;

[0211] Obtain the editing start time with the second rank in the third sorting sequence, and mark it as the second start time;

[0212] Obtain the editing start time with the J-th rank in the third sorting sequence, and mark it as the J-th start time;

[0213] Where J is the number of first users with high permissions in the first user set;

[0214] For multiple first users with high permissions to perform editing operations on the first data cell, when the first user with high permissions corresponding to the first start time in the third sorting sequence completes the editing operation, obtain the editing method of this first user with high permissions and the corresponding edited content, and update them to the first data cell;

[0215] When the remaining first users with high permissions complete the editing operation, obtain the editing start time of this first user with high permissions, and obtain the corresponding second target data cell according to the editing start time;

[0216] The remaining first users with high permissions are users other than the first user with high permissions corresponding to the first start time in the first user set;

[0217] The second target data cell is the second target data cell corresponding to the second start time to the J-th start time in the third sorting sequence, and each start time corresponds to a position information identifier of a second target data cell. Specifically, the second start time corresponds to ( , ), the third start time corresponds to , ), corresponding to the J-th start time , );

[0218] Obtain the editing methods and corresponding editing contents of the remaining first users with high permissions, and update them to the corresponding second target data cells;

[0219] If the number of first users with high permissions in the first user set is equal to 0 and the number of first users with low permissions is greater than 1, obtain the data cell operation information of each first user with low permissions, and according to the data cell operation information, obtain the editing start time of each first user with low permissions, and sort them in chronological order to form a sorted sequence, denoted as the fourth sorted sequence;

[0220] Obtain the editing start time with the first rank in the fourth sorted sequence, and mark it as the first start time;

[0221] Obtain the editing start time with the second rank in the fourth sorted sequence, and mark it as the second start time;

[0222] Obtain the editing start time with the K-th rank in the fourth sorted sequence, and mark it as the K-th start time;

[0223] Where K is the number of first users with low permissions in the first user set;

[0224] For multiple first users with low permissions to perform editing operations on the first data cell, when the first user with low permissions corresponding to the first start time in the fourth sorted sequence completes the editing operation, obtain the editing method and corresponding editing content of the first user with low permissions, and update them to the first data cell;

[0225] When the remaining first users with low permissions complete the editing operation, obtain the editing start time of the first user with low permissions, and obtain the corresponding third target data cell according to the editing start time;

[0226] The remaining first users with low permissions are users other than the first user with low permissions corresponding to the first start time in the first user set;

[0227] The third target data cell is the third target data cell corresponding to the second start time to the K-th start time in the fourth sorted sequence, and each start time corresponds to a position information identifier of a third target data cell. Specifically, the second start time corresponds to ( , ), the third start time corresponds to , ),... the K-th start time corresponds to ( , );

[0228] Obtain the editing methods and corresponding edited contents of the remaining first users with low permissions, and update them to the corresponding third target data cells.

[0229] Optionally, the different data cell conflict strategies for the second user set executed under the same row title include:

[0230] Mark the row title corresponding to the second user's editing operation on the dynamic data cell as the target row title;

[0231] Obtain the position information identifiers corresponding to the dynamic data cells edited by the second user, and form a set, denoted as the position information identifier set. Each second user corresponds to a position information identifier set;

[0232] Execute the dynamic data cell conflict matching strategy according to the position information identifier set of each second user;

[0233] The dynamic data cell conflict matching strategy is to obtain the position information identifier set of each second user, and determine whether each position information identifier set intersects with other position information identifier sets;

[0234] If the number of position information identifier sets with intersections is equal to 0, obtain the editing method of the second user and the corresponding edited content, and update the dynamic data cells corresponding to each element in the position information identifier set;

[0235] If the number of position information identifier sets with intersections is greater than 0, mark the position information identifier sets with intersections as the conflict set. Each conflict set corresponds to a second user;

[0236] Classify the conflict sets, and merge the conflict sets whose intersections contain one or more identical elements into one category, and mark it as the first classification;

[0237] Obtain the second user corresponding to each conflict set in the first classification, and the corresponding editing start time, and sort them in the order of time, forming a sorting sequence, denoted as the fifth sorting sequence;

[0238] Obtain the editing start time with the first rank in the fifth sorting sequence, and mark it as the first start time;

[0239] Obtain the editing start time with the second rank in the fifth sorting sequence, and mark it as the second start time;

[0240] Obtain the editing start time with the L-th rank in the fifth sorting sequence, and mark it as the L-th start time;

[0241] Where L is the number of conflict sets in one category;

[0242] According to the fifth sorting sequence, obtain the editing method and corresponding edited content of each element in the set of location information markers of the second user corresponding to the first start time, and update them to the dynamic data cells corresponding to the target row title;

[0243] According to the fifth sorting sequence, obtain the editing method and corresponding edited content of each element in the set of location information markers of the second user corresponding to the I-th start time, increase the row identifier subscript corresponding to each element in the location information identifier set by I - 1, and update it to the corresponding dynamic data cell;

[0244] Where I is the I-th start time in the fifth sorting sequence.

[0245] Optionally, the execution of the row data sorting strategy for the first report includes:

[0246] The row data sorting strategy specifically includes the following steps;

[0247] The row data is all the edited data cell contents included in each row title in the report;

[0248] Mark the row data edited by the same user as the target row data;

[0249] When the first report is generated, divide it into groups with every five monitoring time periods, and mark each group as the first group of monitoring time periods, the second group of monitoring time periods... the H-th group of monitoring time periods;

[0250] Obtain all the target row data within each group of monitoring time periods, and obtain the user identification ID corresponding to each target row data, and form a set, denoted as the optimized user set;

[0251] One group of monitoring time periods corresponds to one optimized user set, and obtain the number of target row data corresponding to each user identification ID;

[0252] If there exists a user identification ID with multiple target row data, then obtain the number of target row titles, denoted as r; obtain the row title corresponding to the target row data with the earliest editing start time, and the location information corresponding to this row title, denoted as ( , ); Optimize the location information corresponding to the edited data cells included in the target row data under this user identification ID, and this optimization process is denoted as the first optimization process;

[0253] The first optimization process is specifically expressed as the first target row data being ( , ), ( , )... ( , ); The second target row data is ( , ), ( , )... ( , ); The r-th target row data is ( , ), ( , )... ( , );

[0254] where a is the number of edited data cells in the target row data minus one;

[0255] If, during the first optimization process, there is a conflict in the position information of the target row data under other user identification IDs, then place the position information of this target row data below the r-th target row data;

[0256] If there is only one target row data under each user identification ID, then do not change the position information of the edited data cells corresponding to the target row data.

[0257] It should be noted that in this article, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any actual relationship or order between these entities or operations. Moreover, the term "comprising", "including" or any other variant thereof is intended to cover non-exclusive inclusion, so that a process, method, article or device comprising a series of elements not only includes those elements, but also includes other elements not expressly listed, or also includes elements inherent to such process, method, article or device.

[0258] The above are only the preferred embodiments of the present invention. It should be pointed out that for those of ordinary skill in the art, without departing from the technical principle of the present invention, several improvements and refinements can be made, and these improvements and refinements should also be regarded as the protection scope of the present invention.

Claims

1. An online form intelligent design method, characterized in that: include: Set up the report structure; The report structure includes multiple dynamic data grids; Each dynamic data grid corresponds to a location information identifier; The dynamic data grid is used to store the data edited by the user and display the data edited by the user; The position information identifier includes a row identifier and a column identifier. The position information identifier is represented as , where the column identifiers are represented as , the row identifier is represented by ; If there is data edited by the user in the dynamic data grid, the dynamic data grid is marked as an edited data grid; Set column and row headers to identify the contents of the edited data grid; In a report, if there are one or more column headers, the position information of the column headers is obtained and a column header set is formed; According to the position information of the column title, the content of the edited data grid to which the position information belongs is obtained and recorded as the column title content; In a report, if there are multiple row headers, they form a row header set; Set report information; The report information includes a report name, a column title set and a row title set, and each report corresponds to a report information; Get the report name of each report and execute the report classification strategy according to the report name; The report classification strategy is used to classify reports with similar report names and form a set, which is recorded as a similar report set; Obtain the keyword information entered by the user, and obtain the corresponding similar report set based on the keyword information; Set keyword fields, execute keyword field tagging strategy, and generate keyword field sets; The specific steps of the keyword field marking strategy are: Get a collection of similar reports; All column header contents contained in each report in the similar report set are combined into a column header content set; Calculate the frequency of occurrence of each column title content, recorded as column title content frequency, the formula is: column title content frequency = ; According to the frequency of occurrence of each column title content, a column title content frequency set is formed, where one column title content corresponds to one column title content frequency; According to the column title frequency set, obtain the frequency corresponding to each column title content, and sort them from high to low in frequency to form a first sorting sequence; Marking the content of each column header in the first sorting sequence with a keyword field, with the marking order starting from the first column in the sequence, specifically the first keyword field, the second keyword field, ... the Qth keyword field; Where Q is the number of elements in the column header frequency set; The marked keyword fields are grouped into a set, which is recorded as a keyword field set; Each similarity report set corresponds to a keyword field set; Execute the report generation strategy according to the keyword field set and the keyword information input by the user, and mark the newly generated report as the first report; The specific steps of the report generation strategy are: Assign a location information identifier to each element in the keyword field set and fill it in the newly generated report. Specifically, the location information identifier corresponding to the first keyword field is , the location information corresponding to the second keyword field is identified as ...The position information corresponding to the Qth keyword field is identified as ; in In Indicates the column identifier corresponding to the Qth keyword field. Indicates the row ID corresponding to the Qth keyword field; Mark the generated report as the first report; Set the monitoring time period and divide the monitoring time period every 30 seconds; For the first report, if multiple users perform editing operations on the dynamic data grid corresponding to the same row title in the same monitoring time period, the row title data conflict strategy is executed; For the first report, execute the row data sorting strategy.

2. The online form intelligent design method according to claim 1, characterized in that: The obtaining of the report name of each report and executing the report classification strategy according to the report name include: The specific steps of the report classification strategy are: Extract the keywords in each report name and form a set, which is recorded as the report name keyword set; Obtain the report corresponding to each keyword in the report name keyword set, and form a set, which is recorded as a similar report set; Each keyword corresponds to a similarity report set.

3. The online form intelligent design method according to claim 1, characterized in that: For the first report, if multiple users perform editing operations on the dynamic data grid corresponding to the same row title in the same monitoring time period, the row title data conflict strategy is executed, including: The dynamic data grid can be edited in three ways, namely, filling in content, deleting content and modifying content; When a user performs an editing operation in a report, the user ID and data grid operation information are obtained; The data grid operation information is the dynamic data grid position information, editing method, editing start time and editing end time edited by the user.

4. The online form intelligent design method according to claim 1, characterized in that: If multiple users perform editing operations on the dynamic data grid corresponding to the same row title in the same monitoring time period, the row title data conflict strategy is executed, and further includes: The row header data conflict strategy is divided into the same data grid conflict strategy and the different data grid conflict strategy; Mark multiple users who perform editing operations on the same dynamic data grid in the same monitoring time period as first users and form a first user set; executing the same data grid conflict strategy for the first user set; Mark multiple users who perform editing operations on different dynamic data grids in the same monitoring time period as second users and form a second user set; A conflict strategy for different data grids under the same row header is executed for the second user set.

5. The online form intelligent design method according to claim 4, characterized in that: The executing the same data grid conflict strategy for the first user set includes: marking the dynamic data grid edited by the plurality of first users as the first data grid; Get the location information identifier of the first data grid, recorded as ,in is the column identifier of the first data cell, is the row identifier of the first data cell; Set the user authority level, which is divided into high authority level and low authority level; Each user ID corresponds to a user permission level; Obtaining a user identification ID of each first user in the first user set, and obtaining a user authority level of each first user according to the user identification ID; If there is a high-authority first user and one or more low-authority first users in the first user set, then obtain data grid operation information of the one or more low-authority first users, and obtain the editing start time of each low-authority user according to the data grid operation information; if there is only one low-authority first user, then mark the editing start time of the user as the first start time; If there are multiple low-authority first users, they are sorted in the order of the editing start time of the low-authority first users to form a sorting sequence, which is recorded as the second sorting sequence; Get the edit start time with the first position in the second sorting sequence, and mark it as the first start time; Obtain the second edit start time in the second sorting sequence and mark it as the second start time; Get the edit start time of the Zth position in the second sorting sequence, and mark it as the Zth start time; Where Z is the number of low-authority first users in the first user set; If the number of high-authority first users in the first user set is equal to 1, and the number of low-authority first users is equal to 1, the high-authority first user and the low-authority first user perform an editing operation on the first data grid. When the high-authority first user completes the editing operation, the editing method and corresponding editing content of the high-authority first user are obtained and updated to the first data grid; when the low-authority first user completes the editing operation, the editing method and corresponding editing content of the low-authority first user are obtained and updated to the dynamic data grid directly below the first data grid. The position information of the dynamic data grid is identified as ; If the number of high-authority first users in the first user set is equal to 1, and the number of low-authority first users is greater than 1, then one high-authority first user and multiple low-authority first users perform an editing operation on the first data grid, and when the high-authority first user completes the editing operation, the editing method and corresponding editing content of the high-authority first user are obtained, and updated to the first data grid; when the low-authority first user completes the editing operation, the editing start time of the low-authority first user is obtained, and the corresponding first target data grid is obtained according to the editing start time; The first target data grid is the first target data grid corresponding to the first starting time to the Zth starting time in the second sorting sequence, each starting time corresponds to a first target data grid position information identifier, specifically the first starting time corresponds to , the second start time corresponds to ...The Zth starting time corresponds to ; The editing mode and corresponding editing content of the low-authority first user are obtained, and updated into the corresponding first target data grid.

6. The online form intelligent design method according to claim 4, characterized in that: The executing the same data grid conflict strategy for the first user set further includes: If the number of high-authority first users in the first user set is greater than 1 and the number of low-authority first users is equal to 0, then the data grid operation information of each high-authority first user is obtained, and according to the data grid operation information, the editing start time of each high-authority first user is obtained, and ... Obtain the first edit start time in the third sorting sequence and mark it as the first start time; Obtain the second edit start time in the third sorting sequence and mark it as the second start time; Obtain the edit start time of the Jth position in the third sorting sequence, and mark it as the Jth start time; Where J is the number of high-authority first users in the first user set; Performing editing operations on the first data grid for multiple high-authority first users, when the high-authority first user corresponding to the first start time in the third sorting sequence completes the editing operation, obtaining the editing mode and corresponding editing content of the high-authority first user, and updating them to the first data grid; When the other high-authority first users complete the editing operation, the editing start time of the high-authority first users is obtained, and the corresponding second target data grid is obtained according to the editing start time; The remaining high-authority first users are users other than the high-authority first users corresponding to the first starting time in the first user set; The second target data grid is the second target data grid corresponding to the second starting time to the Jth starting time in the third sorting sequence, and each starting time corresponds to a position information identifier of the second target data grid. Specifically, the second starting time corresponds to , the third starting time corresponds to ...The Jth starting time corresponds to ; Obtain the editing methods and corresponding editing contents of other high-authority first users, and update them into the corresponding second target data grid; If the number of high-authority first users in the first user set is equal to 0 and the number of low-authority first users is greater than 1, then the data grid operation information of each low-authority first user is obtained, and the editing start time of each low-authority first user is obtained according to the data grid operation information, and the editing start time of each low-authority first user is obtained ..., and the editing start time of each low-authority first user is obtained, and the editing start time of each low-authority first user is obtained, and the editing start time of each low-authority first user is obtained, and the editing start time of each low-authority first user is obtained, and the editing start time of each low-authority first Obtain the first edit start time in the fourth sorting sequence, and mark it as the first start time; Obtain the second edit start time in the fourth sorting sequence, and mark it as the second start time; Obtain the Kth editing start time in the fourth sorting sequence, and mark it as the Kth start time; Where K is the number of low-authority first users in the first user set; Performing editing operations on the first data grid for multiple low-authority first users, when the low-authority first user corresponding to the first start time in the fourth sorting sequence completes the editing operation, obtaining the editing mode and corresponding editing content of the low-authority first user, and updating them to the first data grid; When the remaining low-authority first users complete the editing operation, the editing start time of the low-authority first users is obtained, and the corresponding third target data grid is obtained according to the editing start time; The remaining low-authority first users are users other than the low-authority first users corresponding to the first starting time in the first user set; The third target data grid is the third target data grid corresponding to the second starting time to the Kth starting time in the fourth sorting sequence, and each starting time corresponds to a position information identifier of the third target data grid. Specifically, the second starting time corresponds to , the third starting time corresponds to ...The Kth starting time corresponds to ; The editing methods and corresponding editing contents of the remaining low-authority first users are obtained, and updated into the corresponding third target data grid.

7. The online form intelligent design method according to claim 4, characterized in that: The executing of different data grid conflict strategies under the same row title for the second user set includes: Mark the row title corresponding to the editing operation performed by the second user on the dynamic data grid as the target row title; Obtaining the location information identifiers corresponding to the dynamic data grid edited by the second user and forming a set, recorded as a location information identifier set, where each second user corresponds to a location information identifier set; Executing a dynamic data grid conflict matching strategy according to the location information identifier set of each second user; The dynamic data grid conflict matching strategy is to obtain the location information identification set of each second user, and determine whether each location information identification set intersects with other location information identification sets; If the number of the location information identification sets that generate the intersection is equal to 0, the editing mode and the corresponding editing content of the second user are obtained to update the dynamic data grid corresponding to each element in the location information identification set; If the number of location information identification sets that generate the intersection is greater than 0, the location information identification sets that generate the intersection are marked as conflict sets, and each conflict set corresponds to a second user; Classify the conflicting sets, merge the conflicting sets containing one or more identical elements in the intersection into one category, and mark it as the first category; Obtain the second user corresponding to each conflict set in the first category and the corresponding editing start time, and sort them in chronological order to form a sorted sequence, which is recorded as a fifth sorted sequence; Get the first edit start time in the fifth sorting sequence and mark it as the first start time; Obtain the second edit start time in the fifth sorting sequence and mark it as the second start time; Obtain the edit start time of the Lth position in the fifth sorting sequence, and mark it as the Lth start time; Where L is the number of conflicting sets in a category; According to the fifth sorting sequence, the editing mode and corresponding editing content of each element in the location information tag set of the second user corresponding to the first start time are obtained, and updated to the dynamic data grid corresponding to the target row title; According to the fifth sorting sequence, the editing mode and corresponding editing content of each element in the location information tag set of the second user corresponding to the I start time are obtained, the row identifier subscript corresponding to each element in the location information identifier set is increased by I-1, and updated to the corresponding dynamic data grid; Wherein I is the Ith starting time in the fifth sorting sequence.

8. The online form intelligent design method according to claim 1, characterized in that: The executing of the row data sorting strategy for the first report includes: The row data sorting strategy specifically includes the following steps: The row data refers to all edited data grid contents included in each row title in the report; Mark the row data edited by the same user as the target row data; When the first report is generated, every five monitoring time periods are divided into a group, and each group is marked as the first group of monitoring time periods, the second group of monitoring time periods, and the Hth group of monitoring time periods; Obtain all target row data in each monitoring time period, and obtain the user ID corresponding to each target row data to form a set, which is recorded as the optimized user set; One set of monitoring time periods corresponds to an optimized user set, and the number of target row data corresponding to each user ID is obtained; If there is a user ID with multiple target row data, then get the number of target row titles, recorded as r; get the row title corresponding to the target row data with the earliest editing start time, and the position information corresponding to the row title, recorded as ; Optimizing the position information corresponding to the edited data cell contained in the target row data under the user identification ID, and the optimization process is recorded as the first optimization process; The first optimization process is specifically represented as follows: the first target row data is , … ; The second target row data is , … ; The rth target row data is , … ; Where a is the number of edited data cells in the target row minus one; If, in the first optimization process, there is a conflict in the position information of the target row data under other user identification IDs, the position information of the target row data is placed below the rth target row data; If there is only one target row of data under each user identification ID, the position information of the edited data cell corresponding to the target row of data will not be changed.

Citation Information

Patent Citations

  • Table keyword information locating method based on hypertext

    CN103455498A

  • Automatic report generation method and device, computer equipment and storage medium

    CN114626352A