Online form intelligent design method
Through the intelligent design method of online form, the problems of report editing conflicts and low data utilization efficiency in multi-user collaboration environment are solved, real-time conflict detection and automated report generation are realized, and data management and decision-making efficiency are improved.
Patent Information
- Application Number
- CN202411773703.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-05
- Publication Date
- 2025-01-03
- Estimated Expiration
- 2044-12-05
AI Technical Summary
In a multi-user collaboration environment, the existing report editing system lacks effective conflict detection and resolution mechanisms, resulting in data loss, errors and decision-making delays, and the inability to effectively utilize historical report data to accelerate the creation process of new reports.
Adopt the intelligent design method of online form, providing interactive platform and automated report generation by setting dynamic data grids, real-time monitoring and marking editing operations, and executing conflict policies and report classification policies to ensure data consistency and accuracy, and according to user permissions Priority is given to editing operations.
Improves the collaborative efficiency of report editing, reduces errors and delays, improves data quality and work efficiency, and reduces repetitive labor and decision-making time through automated generation of new report structures.
Smart Images

Figure CN119250046A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of intelligent report processing, and in particular to an online form intelligent design method. Background Art
[0002] With the rapid development of information technology, data management and report editing in enterprise operations have become increasingly dependent on electronic spreadsheets and smart forms, which make data entry, processing and analysis more efficient, but also bring new challenges. Especially in a multi-user collaborative 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] In the traditional report editing process, when multiple users edit the same data grid or the same row of data at the same time, "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, causing users to unknowingly overwrite others' changes or lose their own work results.
[0004] In a multi-user collaborative environment, when users with different permissions try to edit the same data grid at the same time, the lack of real-time conflict prompts and solutions may lead to duplication of work and increased communication costs. In addition, when multiple users edit the same row of data at the same time, existing methods often fail to provide intuitive conflict marking and handling suggestions, making it difficult for users to quickly identify and resolve conflicts.
[0005] In addition, existing technologies cannot generate new report structures based on previously completed reports, resulting in each report being created from scratch, which is inefficient. This means that although the company may already have a large amount of historical report data and structures, these valuable resources cannot be effectively used to speed up the creation of new reports.
[0006] Therefore, developing an intelligent form method that can effectively resolve editing conflicts is of great significance to improving the efficiency of data management and ensuring the accuracy and integrity of data. 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 appropriate solution according to actual conditions. Through this method, the collaborative efficiency of report editing can be significantly improved, and errors and delays caused by conflicts can be reduced, thereby improving the work efficiency and data quality of the entire organization. At the same time, the function of automatically generating new report structures based on existing reports will greatly improve the efficiency of report production, reduce duplication of work, and speed up the decision-making process. Summary of the invention
[0007] The present invention provides an online form intelligent design method for facilitating solving the problems mentioned in the above background technology.
[0008] The present invention provides the following technical solution: an online form intelligent design method,
[0009] Optionally, set 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, and the position information identifier is expressed as ( , ), where the column identifier is represented by , 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; For example, if the content in the edited data cell to which the column title belongs is "Name", then the column title content corresponding to the column title is "Name"; 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; 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; 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.
[0010] Optionally, obtaining the report name of each report and executing the report classification strategy according to the report name includes: 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 similar report set; Set the report structure to provide a report making framework, allowing users to customize the report structure according to different needs and adapt to the data input needs of different users. The dynamic data grid can be updated in real time according to the user's operation, which improves the real-time and flexibility of the report. By uniquely identifying each data grid, the location and retrieval of data are ensured, and an interactive platform is provided. Users can edit data directly in the data grid, 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 grid. Mark the dynamic data grid as the edited data grid. By marking the edited data grid, you can show which data has been modified, which is convenient for tracking and review. According to the keyword field set and the keyword information entered by the user, the report generation strategy is executed to quickly generate new reports, which improves the efficiency of report generation. Set the monitoring time period and divide the monitoring time period every 30 seconds. Through regular monitoring, the row data sorting strategy is executed to organize multiple rows of data edited by the same user together, which improves the readability and neatness of the report. If a user edits multiple rows of data, these data will be displayed together instead of being mixed with other users' data. Optionally, the step of setting a keyword field and executing a keyword field marking strategy to generate a keyword field set includes: 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; All marked keyword fields are grouped into sets. By assigning specific location information identifiers to each element in the keyword field set and filling them in the newly generated report, the correct placement of the keyword fields in the report is ensured, the accuracy of the report is improved, and the report is automatically filled according to the keyword field set, which reduces the workload of manual input and improves the efficiency of report generation; Optionally, executing a report generation strategy according to the keyword field set and the keyword information input by the user, and marking the newly generated report as the first report, includes: 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 location information corresponding to the Qth keyword field is identified as ( , ); 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.
[0011] Optionally, 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.
[0012] Optionally, if multiple users perform editing operations on the dynamic data grid corresponding to the same row title in the same monitoring time period, executing the row title data conflict strategy also 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; The conflict strategy of different data grids under the same row header is executed for the second user set.
[0013] Optionally, 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, and each starting time corresponds to a position information identifier of a first target data grid, 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.
[0014] Optionally, 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 a 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.
[0015] Optionally, executing 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; By setting different user permission levels, data editing operations of high-authority users can be given priority, ensuring priority updates of key data. Sorting is performed according to the user's editing start time, and the priority of editing operations is reasonably arranged to avoid editing conflicts. It can ensure that the data of the user who starts editing the earliest is processed first. According to the user's permission level and editing time, the editing content is allocated to the corresponding dynamic data grid, which improves the flexibility of data processing. The editing content of low-authority users can be placed below the editing content of high-authority users to maintain the hierarchical structure of the data, and handle the editing operations of multiple high-authority or low-authority users on the same data grid. Through the sorting and allocation mechanism, it is ensured that all users' edits are reasonably considered, and conflicts between multiple high-authority or multiple low-authority users are handled. By recording the editing start time and editing content of each user, the editing history is retained, which is convenient for subsequent tracing and auditing.
[0016] Optionally, executing 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 obtain the number of target row titles, recorded as r; obtain 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 expressed 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; By marking the row data edited by the same user as the target row data, the editing content of each user is centrally managed within the monitoring time period, and every five monitoring time periods are divided into a group, and each group is marked. This grouping strategy is helpful to manage data editing in different time periods. By obtaining all the target row data in each group of monitoring time periods and obtaining the user identification ID corresponding to each target row data, an optimized user set is formed, and the editing behavior of each user can be analyzed. The target row data is optimized according to the user identification ID. In particular, when a user identification ID has multiple target row data, these row data are sorted to improve the readability and neatness of the data. If a user edits in multiple rows, these row data are sorted together for user viewing and analysis. In the first optimization process, if there is a conflict in position 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 position information of the edited data grid is not changed, thereby maintaining the originality and integrity of the data.
[0017] The present invention has the following beneficial effects: 1. The online form intelligent design method sets the report structure to provide a report making framework, allowing users to customize the report structure according to different needs and adapt to the data input needs of different users. The dynamic data grid can be updated in real time according to the user's operation, which improves the real-time and flexibility of the report. By uniquely identifying each data grid, the location and retrieval of data are ensured, and an interactive platform is provided. Users can edit data directly in the data grid, 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 grid, mark the dynamic data grid as the edited data grid, and by marking the edited data grid, it can be shown which data has been modified, which is convenient for tracking and review. According to the keyword field set and the keyword information entered by the user, the report generation strategy is executed to quickly generate a new report, which improves the efficiency of report generation. The monitoring time period is set, and the monitoring time period is divided every 30 seconds. Through regular monitoring, the row data sorting strategy is executed to organize multiple rows of data edited by the same user together, which improves the readability and neatness of the report. If a user edits multiple rows of data, these data will be displayed in a centralized manner instead of being mixed with the data of other users.
[0018] 2. The online form intelligent design method extracts keywords from the report name and forms a set to quickly classify the report, thereby improving the efficiency of report management. Users can quickly retrieve related report sets through any keyword, which improves the flexibility and convenience of report retrieval. The method automatically organizes reports containing the same keywords into similar report sets. Through the report classification strategy, users can more intuitively see the classification and organizational structure of the report, which optimizes the user experience. By executing the keyword field marking strategy, the column title content that frequently appears in the similar report set is identified and marked. By calculating the frequency of occurrence of each column title content, it can be determined which column title content is the key information in the report. The column title content is sorted from high to low according to its frequency, forming a priority sequence, and the column title content is marked with keyword fields according to the sorting sequence. All marked keyword fields are grouped into a set. By assigning specific location information identifiers to each element in the keyword field set and filling them in the newly generated report, the correct placement of the keyword fields in the report is ensured, the accuracy of the report is improved, and the report is automatically filled according to the keyword field set, which reduces the workload of manual input and improves the efficiency of report generation.
[0019] 3. The online form intelligent design method helps to handle data conflicts and ensure the integrity and accuracy of data by identifying three editing operations (filling, deleting, and modifying). For example, if user A fills in data and user B tries to delete the same data, it can identify this conflict and take corresponding measures. By obtaining the user identification ID and data grid operation information, it can track each user's editing behavior, including location, editing method and time, for conflict resolution. Data conflicts are monitored and resolved in real time during the monitoring period, avoiding data loss or error accumulation, and improving the real-time and response speed of data management. By distinguishing between the same data grid conflict strategy and different data grid conflict strategies, conflicts in different situations are resolved. By marking the first user and the second user and forming a corresponding user set, it can manage the operations of different users on the data grid, improving the efficiency of conflict resolution. By executing the row header data conflict strategy, the experience of multi-person collaborative editing is optimized and conflicts and misunderstandings between users are reduced.
[0020] 4. The online form intelligent design method can give priority to the data editing operations of high-authority users by setting different user authority levels, ensure the priority update of key 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 the earliest is processed first, and the editing content is allocated to the corresponding dynamic data grid according to the user's authority level and editing time, which improves the flexibility of data processing. The editing content of low-authority users can be placed below the editing content of high-authority users to maintain the hierarchical structure of data, and handle the editing operations of multiple high-authority or low-authority users on the same data grid. Through the sorting and allocation mechanism, it is ensured that the editing of all users is reasonably considered, and the conflicts between multiple high-authority or multiple low-authority users are handled. By recording the editing start time and editing content of each user, the editing history is retained, which is convenient for subsequent tracing and auditing.
[0021] 5. The online form intelligent design method marks the row data edited by the same user as the target row data, centrally manages the editing content of each user within the monitoring time period, divides every five monitoring time periods into a group, and marks each group. This grouping strategy is helpful to manage data editing in different time periods. By obtaining all the target row data in each group of monitoring time periods and obtaining the user identification ID corresponding to each target row data, an optimized user set is formed, and the editing behavior of each user can be analyzed. The target row data is optimized according to the user identification ID. In particular, when a user identification ID has multiple target row data, these row data are sorted to improve the readability and neatness of the data. If a user edits in multiple rows, these row data are sorted together for user viewing and analysis. In the first optimization process, if there is a conflict in position information, the conflicting target row data is placed at the bottom to avoid data coverage and loss. If there is only one target row data under each user identification ID, the position information of the edited data grid is not changed, thereby maintaining the originality and integrity of the data. BRIEF DESCRIPTION OF THE DRAWINGS
[0022] Figure 1 It is a flow chart of the steps of the present invention.
[0023] Figure 2 This is a diagram of the report structure. DETAILED DESCRIPTION
[0024] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0025] Reference Figure 1 ,Optional, set 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; Reference Figure 2 , 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 represented by , 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; For example, if the content in the edited data cell to which the column title belongs is "Name", then the column title content corresponding to the column title is "Name"; 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; 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; 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.
[0026] Optionally, obtaining the report name of each report and executing the report classification strategy according to the report name includes: 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.
[0027] Optionally, the step of setting a keyword field and executing a keyword field marking strategy to generate a keyword field set includes: 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.
[0028] Optionally, executing a report generation strategy according to the keyword field set and the keyword information input by the user, and marking the newly generated report as the first report, includes: 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 location information corresponding to the Qth keyword field is identified as ( , ); 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.
[0029] Optionally, 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.
[0030] Optionally, if multiple users perform editing operations on the dynamic data grid corresponding to the same row title in the same monitoring time period, executing the row title data conflict strategy also 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.
[0031] Optionally, 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, and each starting time corresponds to a position information identifier of a first target data grid, 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.
[0032] Optionally, 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 a 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.
[0033] Optionally, executing 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.
[0034] Optionally, executing 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 obtain the number of target row titles, recorded as r; obtain 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 expressed 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.
[0035] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device.
[0036] The above is only a preferred embodiment of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the technical principles of the present invention. These improvements and modifications should also be regarded as the scope of protection 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, and the position information identifier is expressed as ( , ), where the column identifier is represented by , 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; 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 location information corresponding to the Qth keyword field is identified as ( , ); 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: The step of setting keyword fields and executing keyword field marking strategies to generate keyword field sets includes: 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.
4. 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.
5. 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.
6. The online form intelligent design method according to claim 5, 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, and each starting time corresponds to a position information identifier of a first target data grid, 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.
7. The online form intelligent design method according to claim 5, 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 a 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 ... 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.
8. The online form intelligent design method according to claim 5, 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 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.
9. 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 obtain the number of target row titles, recorded as r; obtain 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 expressed 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
Data processing method and system, electronic equipment and computer readable storage medium
CN110109910A
Automatic report generation method and device, computer equipment and storage medium
CN114626352A
Multi-user online collaborative spreadsheet editing method, storage medium and computer
CN117113948A
Online table collaborative editing method, system and device, medium and product
CN118839672A
Cited By
Intelligent form creation system and method
CN121052230A