Insurance industry temporary data statistical method and system based on online table

Abstract

The invention provides an insurance industry temporary data statistical method and system based on an online table, and the method comprises the steps: obtaining an online table template, setting the original template of the online table as a parent table, and forming a to-be-counted and summarized spreadsheet as a sub-table set after filling data according to the template; creating a first temporary variable object, taking the first temporary variable object as a cell data set, obtaining header data in the parent table, and adding cell information in the header data of the parent table into the cell data set; obtaining and cyclically traversing cell information in sub-table data to be counted and summarized and corresponding to the parent table, and adding the cell information into a cell data set; the line number information of the cells in the cell data set after statistical summarization is recoded, and the re-numbered cell data is correspondingly assigned to a parent table; and the newest parent table data after statistical summarization is returned to the front-end online table, so that the efficiency and reliability of temporary data statistics in the insurance industry are improved.

Description

Technical Field

[0001] The present invention relates to the field of data statistics, and in particular to a temporary data statistics method and system for the insurance industry based on online tables. Background Art

[0002] In daily work in the insurance industry, collecting temporary data through Excel documents is a common work scenario, such as insurance industry training activity management data, insurance industry customer visit data, insurance industry salesperson daily data, insurance industry business personnel development data, insurance industry team building meeting data, etc.

[0003] The existing temporary data collection method is generally to distribute Excel templates through emails, group tools, etc., fill in the feedback results, and finally manually copy and paste the summarized data one by one; or collect through the online form Luckysheet. However, manually summarizing data from multiple Excel documents is a time-consuming and error-prone task, and there are many disadvantages:

[0004] Time consumption: Manually opening each document, copying the data one by one, and then pasting it into the summary document is a very time-consuming process, especially when a large number of files are involved. This not only reduces work efficiency, but may also cause project delays.

[0005] High error rate: In the process of manually entering or copying and pasting data, it is easy to make mistakes such as omissions, input errors, or format mismatches. Even small errors may lead to significant deviations in data analysis results.

[0006] Waste of resources: Manual aggregation consumes a lot of human resources, which could have been used for more valuable tasks such as data analysis, strategy formulation, etc.

[0007] Security risks: Frequent opening and transferring of multiple Excel files increases the risk of data leakage. If sensitive information is not properly protected, it may lead to privacy and security issues.

[0008] Luckysheet is a powerful, easy-to-configure and fully open source online spreadsheet tool. It is similar to the well-known Excel, but more flexible and easier to integrate. However, it is only a pure front-end spreadsheet tool with powerful functions, simple configuration, support for most Excel functions, and lack of back-end data batch summary and statistical functions.

[0009] In view of this problem, the present invention provides an insurance industry temporary data statistics method and system based on online tables to solve the above problem. Summary of the invention

[0010] In order to solve the problems existing in the prior art, the present invention innovatively proposes a temporary data statistics method and system for the insurance industry based on online tables, which effectively solves the problems of low efficiency and reliability of temporary data statistics in the insurance industry caused by the prior art, and effectively improves the efficiency and reliability of temporary data statistics in the insurance industry.

[0011] The first aspect of the present invention provides a temporary data statistics method for the insurance industry based on an online table, comprising:

[0012] Get the online form template, set the original online form template as the parent form, and the electronic form to be statistically summarized after filling in data according to the template as the child form set;

[0013] Create a first temporary variable object, use the first temporary variable object as a cell data set, obtain the header data in the parent table, and add the cell information in the header data of the parent table to the cell data set;

[0014] Get and loop through the cell information in the child table data corresponding to the parent table to be summarized and added to the cell data collection;

[0015] Recode the row number information of the cells in the statistically summarized cell data set, and assign the renumbered cell data to the parent table;

[0016] Return the latest parent table data after statistical aggregation to the front-end online table.

[0017] Optionally, the insurance industry temporary data is insurance industry training activity management data, insurance industry customer visit data, insurance industry salesperson daily data, insurance industry salesperson business development data, and insurance industry team building meeting data.

[0018] Optionally, the acquiring of header data in the parent table and adding cell information in the header data of the parent table to the cell data set specifically includes:

[0019] Get the sheet page data collection in the parent table file;

[0020] Get and traverse the header cell data in the sheet page in the sheet page data collection, determine the maximum number of columns in the template parent table, and limit the maximum number of columns obtained when aggregating the sub-table data;

[0021] Set the first temporary int variable headNum to indicate the number of header rows of the sheet page in the current parent table;

[0022] Get the current sheet page cell of the parent table, traverse the header cell data in the sheet page, and get the row attribute value r in a header cell data in the sheet page. If the row attribute value r is less than the value of the first temporary Int variable headNum, add the current header cell data to the cell data set.

[0023] Furthermore, the maximum number of columns in the parent table of the template is determined as follows:

[0024] Convert the cell data in the sheet page into JSONObject type data;

[0025] Get the data row attribute value r1 of the header cell in the sheet page, which is used to represent the row number to which the current header cell belongs;

[0026] Set the second temporary int variable head = 0, the number of columns traversed by the initial parent table is colcount = 0, when traversing the header cell data in each sheet page, if the header cell data row attribute value r1 is equal to the second temporary int variable head, then add 1 to the number of columns traversed by the current loop colcount. After the loop traversal ends, the maximum number of columns in the template parent table is the number of columns traversed by the last loop colcount.

[0027] Furthermore, the obtaining and looping through the cell information in the child table data corresponding to the parent table to be statistically summarized and added to the cell data set specifically includes:

[0028] Get and loop through the cell information in the child table data corresponding to the parent table to be summarized;

[0029] Get the column information col, row number information row, and value information val of the cell in the subtable data;

[0030] In the subtable, according to the column information col, row number information row, and value information val of the cell in the subtable data, the cell information in the subtable data is added to the cell data set.

[0031] Furthermore, the step of adding the cell information in the subtable data to the cell data set according to the column information col, the row number information row, and the value information val of the cell in the subtable data is specifically as follows:

[0032] If the column information col, row number information row, and value information val of the cell in the sub-table data all meet the preset adding conditions, the cell information in the sub-table data will be added to the cell data set; wherein, the first preset adding condition is that the row number information rowrow of the cell in the sub-table data is not less than the first temporary Int type variable headNum, the second preset adding condition is that the column information col of the cell in the sub-table data is less than the number of columns colcount traversed in the last loop, and the third preset adding condition is that the value information val of the cell in the sub-table data is contained in the attribute value ct.

[0033] Optionally, it also includes:

[0034] After each loop traverses the cell information of the sheet page in a subtable, create a JSONObject type temporary variable nextflagtemp, and set the key of the JSONObject type temporary variable nextflagtemp to the subtable separator identifier, and set the value of the JSONObject type temporary variable nextflagtemp to empty or any value key-value pair information; then add the JSONObject type temporary variable nextflagtemp to the cell data collection.

[0035] Furthermore, the recoding of the row number information of the cells in the statistically summarized cell data set specifically includes:

[0036] Create a second temporary variable object, which is used to store the recoded cell data set; set a third temporary int variable teamrow to identify whether the data comes from different subtables, and assign a default value of -1; set a fourth temporary int variable temprowid to identify the new row number, and assign a default value of -1;

[0037] Loop through the cell data set after statistics and aggregation, convert the cell data into JSONObject type data, and determine whether the key of the current cell is a subtable delimited identifier;

[0038] If the key of the current cell is a subtable delimiter, reassign the third temporary int variable teamrow to -1 and proceed to the next cell traversal;

[0039] If the key of the current cell is not a subtable delimiter, get the row number rtemp of the current cell, and determine whether the row number rtemp of the current cell is equal to the third temporary int variable teamrow. If they are not equal, assign the row number rtemp of the current cell to the third temporary int variable teamrow, and add 1 to the fourth temporary int variable temprowid. If they are equal, the fourth temporary int variable temprowid remains unchanged.

[0040] Store the recoded cell data set into the second temporary variable object.

[0041] Optionally, the method is characterized in that it further comprises:

[0042] The latest parent table data after the returned statistics are displayed on the Luckysheet front end.

[0043] A second aspect of the present invention provides an insurance industry temporary data statistics system based on an online form, comprising:

[0044] The acquisition and setting module acquires the online form template, sets the original online form template as the parent form, and the electronic form to be statistically summarized after filling in the data according to the template as the child form set;

[0045] Create and add modules, create a first temporary variable object, use the first temporary variable object as a cell data set, obtain the header data in the parent table, and add the cell information in the header data of the parent table to the cell data set;

[0046] The acquisition and addition module acquires and loops through the cell information in the child table data corresponding to the parent table to be summarized and added to the cell data set;

[0047] The recoding module recodes the row number information of the cells in the statistically summarized cell data set, and assigns the renumbered cell data to the parent table;

[0048] The return module returns the latest parent table data after statistical aggregation to the front-end online table.

[0049] The technical solution adopted by the present invention includes the following technical effects:

[0050] 1. The present invention obtains an online form template, sets the original template of the online form as the parent form, and sets the electronic form to be statistically summarized after filling in data according to the template as a child form set; creates a first temporary variable object, uses the first temporary variable object as a cell data set, obtains the header data in the parent form, and adds the cell information in the header data of the parent form to the cell data set; obtains and loops through the cell information in the child form data corresponding to the parent form to be statistically summarized, and adds it to the cell data set; recodes the row number information of the cells in the cell data set after statistical summary, and assigns the renumbered cell data to the parent form; returns the latest parent form data after statistical summary to the front-end online form, effectively solving the problem of low efficiency and reliability of temporary data statistics in the insurance industry caused by the prior art, and effectively improving the efficiency and reliability of temporary data statistics in the insurance industry.

[0051] 2. In the process of obtaining and traversing the cell data in the sheet page in the sheet page data set in the technical solution of the present invention, the maximum number of columns in the template parent table is determined, which is used to limit the maximum number of columns obtained when aggregating the child table data, thereby further improving the reliability of temporary data statistics in the insurance industry.

[0052] 3. In the technical solution of the present invention, if the column information col, row number information row, and value information val of a cell in the sub-table data all meet the preset adding conditions, the cell information in the sub-table data is added to the cell data set; wherein, the first preset adding condition is that the row number information rowrow of the cell in the sub-table data is not less than the first temporary Int type variable headNum, the second preset adding condition is that the column information col of the cell in the sub-table data is less than the number of columns colcount traversed in the last loop, and the third preset adding condition is that the value information val of the cell in the sub-table data is included in the attribute value ct, thereby ensuring the reliability of temporary data statistics in the insurance industry.

[0053] 4. In the technical solution of the present invention, the row number information of the cells in the statistically summarized cell data set is re-encoded through the second temporary variable object, the third temporary int variable teamrow, the fourth temporary int variable temprowid, the JSONObject type temporary variable nextflagtemp, etc., thereby avoiding the problem that the row number information cannot be accurately displayed in the Luckysheet front end due to the duplication of the cell data from multiple sub-tables, and further ensuring the reliability of temporary data statistics in the insurance industry.

[0054] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0055] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0056] Figure 1 A schematic diagram of a process of a method in Embodiment 1 of the present invention;

[0057] Figure 2 Schematic diagram of the process of step S2 in the method of embodiment 1 of the present invention;

[0058] Figure 3 Schematic diagram of the process of step S22 in the method of embodiment 1 of the present invention;

[0059] Figure 4 This is a flow chart of step S3 in the method of embodiment 1 of the present invention;

[0060] Figure 5 Another schematic flow chart of step S3 in the method of embodiment 1 of the present invention;

[0061] Figure 6 Schematic diagram of the process of step S4 in the method of embodiment 1 of the present invention;

[0062] Figure 7 Another schematic diagram of the process of the method of Embodiment 1 in the scheme of the present invention;

[0063] Figure 8 It is a schematic diagram of the structure of the system of Example 2 in the solution of the present invention. DETAILED DESCRIPTION

[0064] In order to clearly illustrate the technical features of the present solution, the present invention is described in detail below through specific implementation methods and in conjunction with the accompanying drawings. The disclosure below provides many different embodiments or examples for realizing different structures of the present invention. In order to simplify the disclosure of the present invention, the components and settings of specific examples are described below. In addition, the present invention may repeat reference numbers and / or letters in different examples. This repetition is for the purpose of simplification and clarity, and does not itself indicate the relationship between the various embodiments and / or settings discussed. It should be noted that the components illustrated in the accompanying drawings are not necessarily drawn to scale. The present invention omits the description of known components and processing techniques and processes to avoid unnecessary limitations on the present invention.

[0065] Embodiment 1

[0066] like Figure 1 As shown, the present invention provides a temporary data statistics method for the insurance industry based on an online table, comprising:

[0067] S1, obtaining an online form template, setting the original online form template as the parent form, and the electronic form to be statistically summarized after filling in data according to the template as the child form set;

[0068] S2, creating a first temporary variable object, using the first temporary variable object as a cell data set, obtaining header data in the parent table, and adding cell information in the header data of the parent table to the cell data set;

[0069] S3, obtaining and looping through the cell information in the child table data corresponding to the parent table to be summarized and added to the cell data set;

[0070] S4, re-encode the row number information of the cells in the statistically summarized cell data set, and assign the re-numbered cell data to the parent table;

[0071] S5, returning the latest parent table data after statistical aggregation to the front-end online table.

[0072] In step S1, the insurance industry temporary data includes insurance industry training activity management data, insurance industry customer visit data, insurance industry salesperson daily data, insurance industry salesperson business development data, and insurance industry team building meeting data.

[0073] As a pure front-end framework, Luckysheet can directly obtain the required CSS and JS dependency files through CDN (Content Delivery Network, a content distribution network built on the data network) and NPM (Node Package Manager, the default package management tool for Node.js) in the project, and convert the front-end table data information into JSON data for easy transmission to the back-end for summary statistics and parsing storage.

[0074] Use JAVA language to develop related processing programs. When summarizing data, first analyze the template data of the online form and obtain the header data information of the template. Set the original online template form as the parent form, and the electronic form to be summarized after filling in the data according to the template as the child form set.

[0075] In step S2, a first temporary variable object allCellData (JSONArray type) is created to store the header cell data of the parent table of the currently traversed sheet and the cell data of all child tables.

[0076] Among them, Figure 2 As shown, in step S2, obtaining the header data in the parent table and adding the cell information in the header data of the parent table to the cell data set specifically includes:

[0077] S21, obtaining a sheet page data set in the parent table file;

[0078] Specifically, set the JSON data of the parent table as object option0, and obtain the sheet data set in the parent table file by referencing the hutool toolkit. Obtain the sheet data set in JSONArray format through the option0.get("data") method, and record it as sheets0;

[0079] S22, obtaining and traversing the header cell data in the sheet page in the sheet page data set, determining the maximum number of columns in the template parent table, which is used to limit the maximum number of columns obtained when aggregating the sub-table data;

[0080] Specifically, the obtained JSONArray collection sheets0 is traversed to obtain the header cell information of each sheet. The traversal index is recorded as index0. The sheet data obtained by sheets0.get(index0) is converted into JSONObject type and recorded as sheetObject through the JSONUtil method in the hutool toolkit. Then the value of its attribute celldata is obtained through the sheetObject.getJSONArray method, which is the cell JSONArray data collection in the current sheet page, recorded as celldata.

[0081] S23, setting a first temporary int type variable headNum, which is used to represent the number of header rows of the sheet page in the current parent table (the headNum value can be dynamically set according to actual conditions, and the default value is 1);

[0082] S24, obtain the current sheet page cell of the parent table, traverse the header cell data in the sheet page, obtain the row attribute value r in a header cell data in the sheet page, if the row attribute value r is less than the value of the first temporary Int type variable headNum, then add the current header cell data to the cell data set.

[0083] First, the header cell of the current sheetObject of the parent table is obtained, and the obtained header cell collection celldata is traversed. The header cell information obtained by the traversal is converted into JSONObject type data using the JSONUtil.parseObj method and recorded as cellTemp. The value of the attribute r is obtained through the cellTemp.getInt method. If the value of r is less than the headNum value, the current cell cellTemp is added to the allCellData cell data collection. After the traversal is completed, the header cell data in the current sheet can be obtained.

[0084] Among them, Figure 3 As shown, the maximum number of columns in the template parent table determined in step S22 is specifically:

[0085] S221, converting the header cell data in the sheet page into JSONObject type data;

[0086] The obtained table header cell data information is converted into JSONObject type data using JSONUtil.parseObj method and recorded as cellHead;

[0087] S222, obtaining the row attribute value r1 of the header cell data in the sheet page (obtaining the row attribute value with the attribute r through the cellHead.getInt method, representing the row number to which the current header cell belongs, recorded as r1), which is used to represent the row number to which the current header cell belongs;

[0088] S223, set the second temporary int variable head = 0 (representing that the row number is 0, that is, the number of cells in the first row is the basis for judging the number of columns, and the head value can be dynamically adjusted according to the actual situation), the number of columns currently traversed in the initial parent table is colcount = 0, when traversing the header cell data in each sheet page, if the header cell data row attribute value r1 is equal to the second temporary int variable head (r1 = head), then the number of columns currently traversed in the loop colcount is increased by 1, and after the loop traversal is completed, the maximum number of columns in the template parent table is the number of columns colcount traversed in the last loop.

[0089] Preferably, in step S24, a JSONObject temporary variable nextflag can also be created, and a key-value pair with a key of "separator (row separator)" and a value of null or any value can be added through the put method. Nextflag is then added to the allCellData array data set to achieve identification of different rows of data.

[0090] Among them, Figure 4 As shown, in step S3, obtaining and looping through the cell information in the child table data corresponding to the parent table to be statistically summarized and added to the cell data set specifically includes:

[0091] S31, obtaining and looping through the cell information in the child table data corresponding to the parent table to be statistically summarized;

[0092] Specifically, the reported sub-table data is summarized. The JSON objects of all sub-tables to be summarized are set as the data set optionArr, the optionArr object is traversed and the current loop sub-table data is recorded as optionArrChild, and the sheet collection data of the current sub-table is obtained through the optionArrChild.get("data") method, and recorded as optionArrChildSheet.

[0093] For the sheet collection data optionArrChildSheet of the current child table, obtain the sheet data corresponding to the parent table through the optionArrChildSheet.get(index0) method, record it as sheetChildTemp, and then obtain the value of its attribute celldata through the sheetChildTemp.getJSONArray method, which is the cell JSONArray data collection in the current sheet page, record it as celldatalist.

[0094] Traverse the celldatalist and convert the cell information into JSONObject type data through the JSONUtil.parseObj method and record it as cellChild

[0095] S32, obtaining the column information col, row number information row, and value information val of the cell in the subtable data;

[0096] Specifically, the column information of the cell is obtained through cellChild.getInt("c") and recorded as col; the row number information of the cell is obtained through cellChild.getInt("r") and recorded as row; the cell value information is obtained through cellChild.get("v"), and the cell information is converted into JSONObject type through the JSONUtil.parseObj method and recorded as val.

[0097] S33. In the sub-table, according to the column information col, row number information row, and value information val of the cells in the sub-table data, the cell information in the sub-table data is added to the cell data set.

[0098] Specifically, according to the column information col, row number information row, and value information val of the cells in the sub-table data, adding the cell information in the sub-table data to the cell data set is specifically as follows:

[0099] If the column information col, row number information row, and value information val of the cells in the sub-table data all meet the preset addition conditions, then the cell information in the sub-table data is added to the cell data set; among them, the first preset addition condition is that the row number information row of the cell in the sub-table data is not less than the first temporary Int-type variable headNum, the second preset addition condition is that the column information col of the cell in the sub-table data is less than the last column number colcount traversed in the loop, and the third preset addition condition is that the value information val of the cell in the sub-table data contains the attribute value ct.

[0100] That is, in the sub-table, to obtain the cell data after removing the table header, and in terms of the number of columns, it should be less than the value of the last column number colcount calculated in the loop, that is, row >= headNum and col < colcount, and at the same time, the value information val of the cells in the sub-table data should contain the "ct" attribute value, indicating the existence of data values. The cell data cellChild that meets these three conditions is added to the allCellData data set.

[0101] As Figure 5 shown, step S3 also includes:

[0102] S34. After each loop traverses the cell information of a sheet page in the sub-table, create a JSONObject-type temporary variable nextflagtemp, and set the key of the JSONObject-type temporary variable nextflagtemp to the sub-table separator identifier (i.e., separator), and set the value of the JSONObject-type temporary variable nextflagtemp to a key-value pair information with an empty or arbitrary value; then add the JSONObject-type temporary variable nextflagtemp to the cell data set.

[0103] As Figure 6 shown, in step S4, re-encoding the row number information of the cells in the cell data set after statistical summarization specifically includes:

[0104] S41, creating a second temporary variable object, where the second temporary variable object is used to store the recoded cell data set;

[0105] Specifically, the second temporary variable object is of JSONArray type newAllCellData;

[0106] S42, set a third temporary int variable teamrow to identify whether the data comes from different subtables, and assign a default value of -1; set a fourth temporary int variable temprowid to identify a new row number, and assign a default value of -1;

[0107] S43, looping through the statistically summarized cell data set, and converting the cell data into JSONObject type data;

[0108] Specifically, the cell data set allCellData is looped through, and the cell information is converted into JSONObject type data through the JSONUtil.parseObj method and recorded as cellChildTemp.

[0109] S44, determining whether the key of the current cell is a subtable delimiter identifier, if the determination result is yes, executing step S45, if the determination result is no, executing step S46;

[0110] Specifically, the cellChildTemp.containsKey("separator") method is used to determine whether the key of the current cell is the subtable separator identifier (separator) added in the step.

[0111] S45, reassign the third temporary int variable teamrow to -1, and proceed to the next cell traversal;

[0112] S46, obtaining the current cell row number rtemp, and determining whether the current cell row number rtemp is equal to the third temporary int variable teamrow, if the determination result is yes, executing the result is S47; if the determination result is no, executing step S48;

[0113] Specifically, the current cell row number rtemp is obtained through cellChildTemp.getInt("r").

[0114] S47, the fourth temporary int variable temprowid remains unchanged (indicating that the row number of the current cell and the previous cell belong to the same row);

[0115] S48, assigning the current cell row number rtemp to the third temporary int variable teamrow, and adding 1 to the fourth temporary int variable temprowid;

[0116] S49, storing the recoded cell data set into a second temporary variable object;

[0117] Specifically, the cell row number of cellChildTemp is reassigned through the cellChildTemp.put("r",temprowid) method, and the cellChildTemp with the new row number is added to the new cell data set newAllCellData through the add method.

[0118] After completing the renumbering of all cells, the new cell data set newAllCellData (the second temporary variable object) can be reassigned to the parent sheet page sheetObject, that is, sheetObject.put("celldata", newAllCellData), completing the data aggregation of all sub-sheets of the current sheet. Repeat the above steps to loop through the data aggregation of cells in all sheets, that is, complete the automatic aggregation of data of multiple sub-sheets with reported data in the same template table (parent table).

[0119] like Figure 7 As shown, the technical solution of the present invention also provides a temporary data statistics method for the insurance industry based on an online table, which also includes:

[0120] S6, displays the latest parent table data after the returned statistics and summary on the Luckysheet front end.

[0121] In steps S5-S6, the first temporary variable object option0 is the parent table JSON data. For this purpose, all the summarized sheets are reassigned to the first temporary variable object option0. In this way, the first temporary variable object option0 is the front-end table display data format that can be directly recognized in the Luckysheet front-end framework, so that multi-table data can be automatically summarized and redisplayed in the Luckysheet front-end.

[0122] The present invention obtains an online table template, sets the original template of the online table as a parent table, and sets the electronic table to be statistically summarized after filling in data according to the template as a child table set; creates a first temporary variable object, uses the first temporary variable object as a cell data set, obtains the header data in the parent table, and adds the cell information in the header data of the parent table to the cell data set; obtains and loops through the cell information in the child table data corresponding to the parent table to be statistically summarized, and adds it to the cell data set; recodes the row number information of the cells in the cell data set after statistical summary, and assigns the renumbered cell data to the parent table; returns the latest parent table data after statistical summary to the front-end online table, effectively solves the problem of low efficiency and reliability of temporary data statistics in the insurance industry caused by the prior art, and effectively improves the efficiency and reliability of temporary data statistics in the insurance industry.

[0123] In the process of acquiring and traversing the cell data in the sheet page in the sheet page data set in the technical solution of the present invention, the maximum number of columns in the template parent table is determined, which is used to limit the maximum number of columns obtained when aggregating the child table data, thereby further improving the reliability of temporary data statistics in the insurance industry.

[0124] In the technical solution of the present invention, if the column information col, row number information row, and value information val of a cell in the sub-table data all meet the preset adding conditions, the cell information in the sub-table data is added to the cell data set; wherein, the first preset adding condition is that the row number information rowrow of the cell in the sub-table data is not less than the first temporary Int type variable headNum, the second preset adding condition is that the column information col of the cell in the sub-table data is less than the number of columns colcount traversed in the last loop, and the third preset adding condition is that the value information val of the cell in the sub-table data is included in the attribute value ct, thereby ensuring the reliability of temporary data statistics in the insurance industry.

[0125] In the technical solution of the present invention, the row number information of the cells in the statistically summarized cell data set is re-encoded through the second temporary variable object, the third temporary int variable teamrow, the fourth temporary int variable temprowid, the JSONObject type temporary variable nextflagtemp, etc., thereby avoiding the problem that the row number information cannot be accurately displayed in the Luckysheet front end due to the duplication of the cell data from multiple sub-tables, and further ensuring the reliability of temporary data statistics in the insurance industry.

[0126] Embodiment 2

[0127] like Figure 8As shown, the technical solution of the present invention also provides an insurance industry temporary data statistics system based on an online form, including:

[0128] The acquisition and setting module 101 acquires the online form template, sets the original online form template as the parent form, and sets the electronic form to be statistically summarized after filling in data according to the template as the child form set;

[0129] The creation and addition module 102 creates a first temporary variable object, uses the first temporary variable object as a cell data set, obtains header data in the parent table, and adds cell information in the header data of the parent table to the cell data set;

[0130] The acquisition and addition module 103 acquires and traverses the cell information in the child table data corresponding to the parent table to be statistically summarized, and adds it to the cell data set;

[0131] The recoding module 104 recodes the row number information of the cells in the statistically summarized cell data set, and assigns the renumbered cell data to the parent table;

[0132] Return module 105 returns the latest parent table data after statistics and aggregation to the front-end online table.

[0133] It should be noted that the execution function steps of the acquisition and setting module 101, the creation and addition module 102, the acquisition and addition module 103, the re-encoding module 104, and the return module 105 in the embodiment of the present invention correspond to the method flow of the first embodiment, and this embodiment will not be repeated here.

[0134] The present invention obtains an online table template, sets the original template of the online table as a parent table, and sets the electronic table to be statistically summarized after filling in data according to the template as a child table set; creates a first temporary variable object, uses the first temporary variable object as a cell data set, obtains the header data in the parent table, and adds the cell information in the header data of the parent table to the cell data set; obtains and loops through the cell information in the child table data corresponding to the parent table to be statistically summarized, and adds it to the cell data set; recodes the row number information of the cells in the cell data set after statistical summary, and assigns the renumbered cell data to the parent table; returns the latest parent table data after statistical summary to the front-end online table, effectively solves the problem of low efficiency and reliability of temporary data statistics in the insurance industry caused by the prior art, and effectively improves the efficiency and reliability of temporary data statistics in the insurance industry.

[0135] In the process of acquiring and traversing the cell data in the sheet page in the sheet page data set in the technical solution of the present invention, the maximum number of columns in the template parent table is determined, which is used to limit the maximum number of columns obtained when aggregating the child table data, thereby further improving the reliability of temporary data statistics in the insurance industry.

[0136] In the technical solution of the present invention, if the column information col, row number information row, and value information val of a cell in the sub-table data all meet the preset adding conditions, the cell information in the sub-table data is added to the cell data set; wherein, the first preset adding condition is that the row number information rowrow of the cell in the sub-table data is not less than the first temporary Int type variable headNum, the second preset adding condition is that the column information col of the cell in the sub-table data is less than the number of columns colcount traversed in the last loop, and the third preset adding condition is that the value information val of the cell in the sub-table data is included in the attribute value ct, thereby ensuring the reliability of temporary data statistics in the insurance industry.

[0137] In the technical solution of the present invention, the row number information of the cells in the statistically summarized cell data set is re-encoded through the second temporary variable object, the third temporary int variable teamrow, the fourth temporary int variable temprowid, the JSONObject type temporary variable nextflagtemp, etc., thereby avoiding the problem that the row number information cannot be accurately displayed in the Luckysheet front end due to the duplication of the cell data from multiple sub-tables, and further ensuring the reliability of temporary data statistics in the insurance industry.

[0138] Although the above describes the specific implementation mode of the present invention in conjunction with the accompanying drawings, it is not intended to limit the scope of protection of the present invention. Those skilled in the art should understand that various modifications or variations that can be made by those skilled in the art on the basis of the technical solution of the present invention without creative work are still within the scope of protection of the present invention.

Claims

1. A temporary data statistics method for the insurance industry based on online tables, characterized by: include: Get the online form template, set the original online form template as the parent form, and the electronic form to be statistically summarized after filling in data according to the template as the child form set; Create a first temporary variable object, use the first temporary variable object as a cell data set, obtain the header data in the parent table, and add the cell information in the header data of the parent table to the cell data set; Get and loop through the cell information in the child table data corresponding to the parent table to be summarized and added to the cell data collection; Recode the row number information of the cells in the statistically summarized cell data set, and assign the renumbered cell data to the parent table; Return the latest parent table data after statistical aggregation to the front-end online table.

2. The method for calculating temporary insurance industry data based on online tables according to claim 1 is characterized in that: The insurance industry temporary data includes insurance industry training activity management data, insurance industry customer visit data, insurance industry salesperson daily data, insurance industry salesperson business development data, and insurance industry team building meeting data.

3. The method for calculating temporary insurance industry data based on online tables according to claim 1 is characterized in that: The method of obtaining the header data in the parent table and adding the cell information in the header data of the parent table to the cell data set specifically includes: Get the sheet page data collection in the parent table file; Get and traverse the header cell data in the sheet page in the sheet page data collection, determine the maximum number of columns in the template parent table, and limit the maximum number of columns obtained when aggregating the sub-table data; Set the first temporary int variable headNum to indicate the number of header rows of the sheet page in the current parent table; Get the current sheet page cell of the parent table, traverse the header cell data in the sheet page, and get the row attribute value r in a header cell data in the sheet page. If the row attribute value r is less than the value of the first temporary Int variable headNum, add the current header cell data to the cell data set.

4. The method for calculating temporary insurance industry data based on online tables according to claim 3 is characterized in that: The method of determining the maximum number of columns in the template parent table is specifically: Convert the cell data in the sheet page into JSONObject type data; Get the data row attribute value r1 of the header cell in the sheet page, which is used to represent the row number to which the current header cell belongs; Set the second temporary int variable head = 0, the number of columns traversed by the initial parent table is colcount = 0, when traversing the header cell data in each sheet page, if the header cell data row attribute value r1 is equal to the second temporary int variable head, then add 1 to the number of columns traversed by the current loop colcount. After the loop traversal ends, the maximum number of columns in the template parent table is the number of columns traversed by the last loop colcount.

5. The method for calculating temporary insurance industry data based on online tables according to claim 4 is characterized in that: The obtaining and looping through the cell information in the child table data corresponding to the parent table to be statistically summarized and added to the cell data set specifically includes: Get and loop through the cell information in the child table data corresponding to the parent table to be summarized; Get the column information col, row number information row, and value information val of the cell in the subtable data; In the subtable, according to the column information col, row number information row, and value information val of the cell in the subtable data, the cell information in the subtable data is added to the cell data set.

6. The insurance industry temporary data statistics method based on online tables according to claim 5 is characterized in that: The method of adding the cell information in the subtable data to the cell data set according to the column information col, the row number information row, and the value information val of the cell in the subtable data is specifically as follows: If the column information col, row number information row, and value information val of the cell in the sub-table data all meet the preset adding conditions, the cell information in the sub-table data will be added to the cell data set; wherein, the first preset adding condition is that the row number information rowrow of the cell in the sub-table data is not less than the first temporary Int type variable headNum, the second preset adding condition is that the column information col of the cell in the sub-table data is less than the number of columns colcount traversed in the last loop, and the third preset adding condition is that the value information val of the cell in the sub-table data is contained in the attribute value ct.

7. The insurance industry temporary data statistics method based on online tables according to claim 5 is characterized in that: include: After each loop traverses the cell information of the sheet page in a subtable, create a JSONObject type temporary variable nextflagtemp, and set the key of the JSONObject type temporary variable nextflagtemp to the subtable separator identifier, and set the value of the JSONObject type temporary variable nextflagtemp to empty or any value key-value pair information; then add the JSONObject type temporary variable nextflagtemp to the cell data collection.

8. The method for calculating temporary insurance industry data based on online tables according to claim 7 is characterized in that: The recoding of the row number information of the cells in the statistically summarized cell data set specifically includes: Create a second temporary variable object, which is used to store the recoded cell data set; set a third temporary int variable teamrow to identify whether the data comes from different subtables, and assign a default value of -1; set a fourth temporary int variable temprowid to identify the new row number, and assign a default value of -1; Loop through the cell data set after statistics and aggregation, convert the cell data into JSONObject type data, and determine whether the key of the current cell is a subtable delimited identifier; If the key of the current cell is a subtable delimiter, reassign the third temporary int variable teamrow to -1 and proceed to the next cell traversal; If the key of the current cell is not a subtable delimiter, get the row number rtemp of the current cell, and determine whether the row number rtemp of the current cell is equal to the third temporary int variable teamrow. If they are not equal, assign the row number rtemp of the current cell to the third temporary int variable teamrow, and add 1 to the fourth temporary int variable temprowid. If they are equal, the fourth temporary int variable temprowid remains unchanged. Store the recoded cell data set into the second temporary variable object.

9. The insurance industry temporary data statistics method based on online tables according to any one of claims 1 to 8, characterized in that: include: The latest parent table data after the returned statistics are displayed on the Luckysheet front end.

10. An insurance industry temporary data statistics system based on online tables, characterized by: include: The acquisition and setting module acquires the online form template, sets the original online form template as the parent form, and the electronic form to be statistically summarized after filling in the data according to the template as the child form set; Create and add modules, create a first temporary variable object, use the first temporary variable object as a cell data set, obtain the header data in the parent table, and add the cell information in the header data of the parent table to the cell data set; The acquisition and addition module acquires and loops through the cell information in the child table data corresponding to the parent table to be summarized and added to the cell data set; The recoding module recodes the row number information of the cells in the statistically summarized cell data set, and assigns the renumbered cell data to the parent table; The return module returns the latest parent table data after statistical aggregation to the front-end online table.

Images