Intelligent online form template arrangement method for simply fusing form model and Text2SQL (Structured Query Language)

Abstract

The invention discloses an intelligent template arrangement method for simply fusing a table model and a Text2SQL online form. The method comprises the following methods: a template method for producing thousands of people, a method for rendering an employee online template in combination with the table model, and a method for separating and storing employee online reported data. The method has the advantages that the online form is what you see is what you get, the problem that designers, developers and testers face repeated module design and management work in the same presentation interface is effectively solved, cognitive deviation and understanding errors do not exist, conversion loss between workshops is reduced, the working efficiency is improved, and the result quality is improved; meanwhile, industry and enterprise data are analyzed, arranged and designed based on an LLM model, and a thousand-person and thousand-face employee template is output through a Text2SQL function, so that the labor efficiency is improved by hundreds of times, and the effect achieves geometric progression improvement; in addition, the template effect is evaluated in a visualized and online mode, and the illusion of a large model is eliminated.

Description

Technical Field

[0001] The present invention relates to the technical field of online form intelligent template editing methods, and in particular to a simple fusion table model and Text2SQL online form intelligent template editing method. Background Art

[0002] For a long time, the data form module of the IT software development industry, no matter in the development and use of various industries, the R&D personnel have designed a large number of documents and reports according to various types of layouts. When converting IT technology development, they all use traditional hard coding technology. Especially on the relevant interfaces of computers or mobile phones, it occupies one-third of the invalid interface space, and the format, type and the content of each form are not accurate enough. It needs to be corrected and written repeatedly, and the operation is complicated and inconvenient, which seriously affects the work efficiency and leads to high labor costs for IT R&D companies in various industries. Similarly, the system developed in this way will also cause employees of various industries to use it, because they also need to fill in a large number of forms and reports, resulting in technical BUG problems in the development or inadequate algorithms when modifying and upgrading, which will cause serious settlement impacts on various forms. These traditional manual filling methods have obvious problems such as low efficiency and easy errors.

[0003] Currently, online form tools have appeared in the data form module of the IT software development industry. Although they can be used by multiple people for online collaborative operations, they lack direct integration with table models and cannot meet the user's convenient work management methods and tools. They have become just simple online Excel tools.

[0004] With the development of information technology, digital form processing tools have gradually become popular, but some existing methods still have problems such as complex template design, inconvenient use, and insufficient customization.

[0005] A large amount of form data is submitted and displayed through WEB pages. On the one hand, due to the limitations of WEB pages themselves, the data display is incomplete and non-intuitive, which is not suitable for business scenarios with more financial needs; on the other hand, a large number of offline Excel spreadsheets are used for data management, and users who are more involved in data processing are more accustomed to and like this method. Summary of the invention

[0006] The purpose of the present invention is to provide a simple fusion table model and Text2SQL online form intelligent template editing method in order to solve the above problems.

[0007] The present invention achieves the above-mentioned purpose through the following technical solutions:

[0008] A simple method for merging a table model with Text2SQL online form intelligent template arrangement includes the following methods: a method for producing templates with different faces for different people, a method for rendering an employee online template combined with a table model, and a method for separating and saving data submitted by employees online; wherein the method for producing templates with different faces for different people includes a basic template due to differences in employee categories, an employee key indicator extraction module, an LLM business indicator template, an indicator business SQL module formed by Text2SQL, a visualization intervention module, and a template for saving individualized templates with different faces for different people; the method for rendering an employee online template combined with a table model includes loading an individualized employee template, executing a template business SQL to load a table model module, constructing structural data according to the template and style data according to the template style, and rendering json data containing a table model, structural data, and style data through a medium and finally outputting it; the method for separating and saving data submitted by employees online includes an employee data submission and review module, a template data engine module to separate data from a template, and save the table model, and LLM understands the business and optimizes the personalized template.

[0009] Furthermore, the method for producing a template with a thousand faces for a thousand people specifically comprises the following steps:

[0010] Step 1: Configure the basic template by category, including data block structure and style;

[0011] Step 2: Train the LLM private model through the enterprise and industry table models;

[0012] Step 3: Understand employee KPIs through the LLM private model and form key employee prompts;

[0013] Step 4: Use the key words to drive the LLM private model Text2SQL to generate the employee's private business SQL;

[0014] Step 5: Integrate the employee-specific business SQL with the basic template to form complete template data that is individualized and personalized for the employee;

[0015] Step 6: Visually execute the complete individualized template of the employee, judge the execution effect of the template, eliminate the illusion of the large model, perform visual arrangement, and form a template suitable for individual employees;

[0016] Step 7: Save individual employee templates for data submission and presentation.

[0017] Furthermore, the employee online template combined with the table model rendering method specifically includes the following steps:

[0018] Step 1: Load the employee's individual template and extract the employee's exclusive business SQ;

[0019] Step 2: The data engine, combined with the table model, executes the exclusive business SQL to obtain the exclusive table model: own table model, subordinate table model, and approval table model;

[0020] Step 3: The data engine creates the header and the overall structure of rows and columns based on the individualized template. Driven by the dedicated table model, it creates multiple rows, multiple columns, and merges rows and columns to calculate and form structural data.

[0021] Step 4: For each title item in the data table header, configure a button. Click it to pop up the data aggregation of the column where the title item is located as a condition for filtering. After filtering, the list data content changes in a linked manner; data aggregation filtering includes: category selection of major categories and successively smaller categories, duplicate removal selection of data in this column, quantity / price formula selection, etc., and comprehensive condition selection;

[0022] Step 5: The data engine calculates the structural data and table model style according to the individualized template, including font: weight, color, centering, underline, bold and other style data;

[0023] Step 6: The data engine integrates the table model, structure data and style data to form json data;

[0024] Step 7: Output json data and present it to the user through front-end rendering.

[0025] Furthermore, the method for separating and saving the data submitted online by employees specifically includes the following steps:

[0026] Step 1: Employees submit comprehensive data through the front end, which includes: table model, structure data and style data;

[0027] Step 2: Data engine, extracting individualized employee templates;

[0028] Step 3: The data engine parses and decomposes the comprehensive data into a table model according to the individual templates, and discards the structure and style data;

[0029] Step 4: Data engine, follow up business rules to save table models (own business, approval data);

[0030] Step 5: The LLM model continues to understand the employee table model, outputs the business SQL through Text2SQL, and forms a new version of the template data;

[0031] Step 6: Visually manage new template data and directly publish it as an official template for employees.

[0032] The beneficial effects of the present invention are:

[0033] The online form described in the present invention is what you see is what you get, which effectively solves the repeated module design and management work faced by designers, developers, and testers in the same presentation interface, without cognitive bias and comprehension error, reducing the loss of work transition, improving work efficiency, and improving the quality of results; at the same time, based on the LLM model, industry and enterprise data analysis and layout design, and outputting employee templates with thousands of faces for thousands of people through the Text2SQL function, labor efficiency is improved by a hundred times, and the effect is improved exponentially; in addition, the template effect is evaluated by visual online execution to eliminate the illusion of a large model. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] Figure 1 It is a flow chart of the process of producing employee individualized templates in a simple fusion table model and Text2SQL online form intelligent template arrangement method described in the present invention;

[0035] Figure 2 It is a flowchart of the rendering process of the employee online template combined with the table model in the simple fusion table model and Text2SQL online form intelligent template arrangement method described in the present invention;

[0036] Figure 3 The present invention discloses a flowchart of separating and saving the table model of the online submitted data through the template style in the method of compiling a simple fusion table model and Text2SQL online form intelligent template. DETAILED DESCRIPTION

[0037] A simple method for merging a table model with Text2SQL online form intelligent template arrangement includes the following methods: a method for producing templates with different faces for different people, a method for rendering an employee online template combined with a table model, and a method for separating and saving data submitted by employees online; wherein the method for producing templates with different faces for different people includes a basic template due to differences in employee categories, an employee key indicator extraction module, an LLM business indicator template, an indicator business SQL module formed by Text2SQL, a visualization intervention module, and a template for saving individualized templates with different faces for different people; the method for rendering an employee online template combined with a table model includes loading an individualized employee template, executing a template business SQL to load a table model module, constructing structural data according to the template and style data according to the template style, and rendering json data containing a table model, structural data, and style data through a medium and finally outputting it; the method for separating and saving data submitted by employees online includes an employee data submission and review module, a template data engine module to separate data from a template, and save the table model, and LLM understands the business and optimizes the personalized template.

[0038] In this embodiment, the method for producing a template with a thousand faces for a thousand people specifically comprises the following steps:

[0039] Step 1: Configure the basic template by category, including data block structure and style;

[0040] Step 2: Train the LLM private model through the enterprise and industry table models;

[0041] Step 3: Understand employee KPIs through the LLM private model and form key employee prompts;

[0042] Step 4: Use the key words to drive the LLM private model Text2SQL to generate the employee's private business SQL;

[0043] Step 5: Integrate the employee-specific business SQL with the basic template to form complete template data that is individualized and personalized for the employee;

[0044] Step 6: Visually execute the complete individualized template of the employee, judge the execution effect of the template, eliminate the illusion of the large model, perform visual arrangement, and form a template suitable for individual employees;

[0045] Step 7: Save individual employee templates for data submission and presentation.

[0046] In this embodiment, the employee online template combined with the table model rendering method specifically includes the following steps:

[0047] Step 1: Load the employee's individual template and extract the employee's exclusive business SQ;

[0048] Step 2: The data engine, combined with the table model, executes the exclusive business SQL to obtain the exclusive table model: own table model, subordinate table model, and approval table model;

[0049] Step 3: The data engine creates the header and the overall structure of rows and columns based on the individualized template. Driven by the dedicated table model, it creates multiple rows, multiple columns, and merges rows and columns to calculate and form structural data.

[0050] Step 4: For each title item in the data table header, configure a button. Click it to pop up the data aggregation of the column where the title item is located as a condition for filtering. After filtering, the list data content changes in a linked manner; data aggregation filtering includes: category selection of major categories and successively smaller categories, duplicate removal selection of data in this column, quantity / price formula selection, etc., and comprehensive condition selection;

[0051] Step 5: The data engine calculates the structural data and table model style according to the individualized template, including font: weight, color, centering, underline, bold and other style data;

[0052] Step 6: The data engine integrates the table model, structure data and style data to form json data;

[0053] Step 7: Output json data and present it to the user through front-end rendering.

[0054] In this embodiment, the method for separating and saving employee online reporting data specifically includes the following steps:

[0055] Step 1: Employees submit comprehensive data through the front end, which includes: table model, structure data and style data;

[0056] Step 2: Data engine, extracting individualized employee templates;

[0057] Step 3: The data engine parses and decomposes the comprehensive data into a table model according to the individual templates, and discards the structure and style data;

[0058] Step 4: Data engine, follow up business rules to save table models (own business, approval data);

[0059] Step 5: The LLM model continues to understand the employee table model, outputs the business SQL through Text2SQL, and forms a new version of the template data;

[0060] Step 6: Visually manage new template data and directly publish it as an official template for employees.

[0061] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A simple fusion table model and Text2SQL online form intelligent template editing method, characterized by: It includes the following methods: a method for producing templates that are different for each person, a method for rendering online employee templates combined with table models, and a method for separating and saving data submitted by employees online; the method for producing templates that are different for each person includes basic templates due to differences in employee categories, employee key indicator extraction modules, LLM business indicator templates, indicator business SQL modules formed by Text2SQL, as well as visualization intervention modules, and templates for saving individualized templates that are different for each person; the method for rendering online employee templates combined with table models includes loading individualized employee templates, executing template business SQL to load table model modules, constructing structural data according to templates and style data according to template styles, and rendering json data containing table models, structural data, and style data through a medium and finally outputting them; the method for separating and saving data submitted by employees online includes employee data submission and review modules, and the template data engine module separates data from templates, saves table models, and LLM understands business and optimizes personalized templates.

2. According to claim 1, a simple fusion table model and Text2SQL online form intelligent template editing method is characterized by: The method for producing a template with a thousand faces for a thousand people specifically comprises the following steps: Step 1: Configure the basic template by category, including data block structure and style; Step 2: Train the LLM private model through the enterprise and industry table models; Step 3: Understand employee KPIs through the LLM private model and form key employee prompts; Step 4: Use the key words to drive the LLM private model Text2SQL to generate the employee's private business SQL; Step 5: Integrate the employee-specific business SQL with the basic template to form complete template data that is individualized and personalized for the employee; Step 6: Visually execute the complete individualized template of the employee, judge the execution effect of the template, eliminate the illusion of the large model, perform visual arrangement, and form a template suitable for individual employees; Step 7: Save individual employee templates for data submission and presentation.

3. According to claim 1, a simple fusion table model and Text2SQL online form intelligent template editing method is characterized by: The employee online template combined with the table model rendering method specifically includes the following steps: Step 1: Load the employee's individual template and extract the employee's exclusive business SQ; Step 2: The data engine, combined with the table model, executes the exclusive business SQL to obtain the exclusive table model: own table model, subordinate table model, and approval table model; Step 3: The data engine creates the header and the overall structure of rows and columns based on the individualized template. Driven by the dedicated table model, it creates multiple rows, multiple columns, and merges rows and columns to calculate and form structural data. Step 4: For each title item in the data table header, configure a button. Click it to pop up the data aggregation of the column where the title item is located as a condition for filtering. After filtering, the list data content changes in a linked manner; data aggregation filtering includes: category selection of major categories and successively smaller categories, duplicate removal selection of data in this column, quantity / price formula selection, etc., and comprehensive condition selection; Step 5: The data engine calculates the structural data and table model style according to the individualized template, including font: weight, color, centering, underline, bold and other style data; Step 6: The data engine integrates the table model, structure data and style data to form json data; Step 7: Output json data and present it to the user through front-end rendering.

4. According to claim 1, a simple fusion table model and Text2SQL online form intelligent template editing method is characterized by: The method for separating and saving employee online submission data specifically includes the following steps: Step 1: Employees submit comprehensive data through the front end, which includes: table model, structure data and style data; Step 2: Data engine, extracting individualized employee templates; Step 3: The data engine parses and decomposes the comprehensive data into a table model according to the individual templates, and discards the structure and style data; Step 4: Data engine, follow up business rules to save table models (own business, approval data); Step 5: The LLM model continues to understand the employee table model, outputs the business SQL through Text2SQL, and forms a new version of the template data; Step 6: Visually manage new template data and directly publish it as an official template for employees.

Images