Form management method and system, electronic equipment and storage medium
Through dynamic data source configuration and form template presets, combined with WEBGL technology to generate data rules, the problem of insufficient flexibility and applicability of form design is solved, design efficiency and user experience are improved, and flexible management of multiple data sources is achieved.
Patent Information
- Application Number
- CN202411131883.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-16
- Publication Date
- 2024-11-26
AI Technical Summary
In the prior art, form design is difficult to adapt to different data needs and structural differences, resulting in insufficient flexibility and applicability of forms, high design thresholds, and reduced design efficiency and user experience.
Provide a form management method and system. Through dynamic data source configuration, form templates and presets of data rules, users can generate forms without deep understanding of technology. The system uses WEBGL technology to generate data rules and extract and fill them from multiple data sources. Data, supports multi-data source management and form export.
It improves the flexibility and applicability of form design, reduces user learning costs, improves design efficiency and user experience, and realizes the flexibility of dynamic management of multiple data sources and form generation.
Smart Images

Figure CN119026581A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer technology, and more specifically, to a form management method, system, electronic device and storage medium. Background Art
[0002] As the pace of enterprise digitalization accelerates, various business types of forms have gradually become an indispensable tool for information transmission within the enterprise.
[0003] In the prior art, the form design is generally completed manually by relevant technical personnel, and the corresponding data source is manually configured; however, the data source configured in this way is relatively static, and it is difficult to adapt to different data requirements and structural differences, which limits the flexibility and applicability of the generated form; and, in this way, only technical personnel who have a deep understanding of the relevant technology can complete the form design. For non-technical personnel, the design threshold is relatively high, which reduces the design efficiency and user experience of the form. Summary of the invention
[0004] In view of this, the present invention provides a form management method, system, electronic device and storage medium to solve the problems in the prior art that it is difficult to adapt to different data requirements and structural differences, limits the flexibility and applicability of the generated forms, and has high requirements for form design, resulting in low form design efficiency and poor user experience.
[0005] The first aspect of the present application provides a form management method, which is applied to a form management system, and the method includes:
[0006] In response to a data source configuration operation by a user, a data source configuration interface corresponding to the data source configuration operation is displayed, so that the user can input corresponding data source connection information based on the data source configuration interface;
[0007] When the data source connection information input by the user is detected, binding the database indicated by the data source connection information with the form management system;
[0008] Responding to the user's form creation operation, and receiving a form name sent by the user based on the form creation operation, and acquiring a corresponding form template according to the form name; wherein the form template includes a plurality of data items to be filled in;
[0009] Extracting the filling data corresponding to each data item to be filled in from the database bound to the form management system according to the rule configuration information and data rules corresponding to each data item to be filled in; wherein the data rules of the data item to be filled in are generated according to the rule configuration information of the data item to be filled in;
[0010] Fill the filling data of each of the data items to be filled into the corresponding data items to be filled, and generate a form corresponding to the form name.
[0011] Optionally, the database includes a plurality of data tables, and after binding the database indicated by the data source connection information with the form management system, the method includes:
[0012] In response to the user's data source viewing operation, displaying a data source viewing interface related to the database indicated by the data source viewing operation;
[0013] detecting in real time whether a data table query request sent by the user based on the data source viewing interface is received; wherein the data table query request at least includes a data table name;
[0014] When the data table query request is received, the table structure information of the data table corresponding to the data table name is queried and displayed.
[0015] Optionally, generating the data rule of the data item to be filled according to the rule configuration information of the data item to be filled includes:
[0016] When a parameter configuration operation of the user on the data to be filled in the form template is detected, a data attribute configuration interface corresponding to the parameter configuration operation is displayed, so that the user can input rule configuration information corresponding to the data to be filled in the data attribute configuration interface;
[0017] When the rule configuration information input by the user based on the data attribute configuration interface is detected, the data rule corresponding to the data to be filled item is generated according to the rule configuration information using WEBGL technology.
[0018] Optionally, the rule configuration information at least includes the first data table, the first data field, the associated query information and the screening condition information;
[0019] The step of using the WEBGL technology to generate the data rules corresponding to the data to be filled items according to the rule configuration information includes:
[0020] Determine the association type, the second data table, and the second data field in the association query information;
[0021] Using WEBGL technology to associate the first data table and the first data field with the second data table and the third data field according to the association type and the second data field, and to associate the third data field with condition configuration information, so as to generate data rules for the data to be filled item; wherein the screening condition information at least includes the third data field and the condition configuration information;
[0022] The data item to be filled is converted into a rich text node element, and the rich text node element of the data item to be filled is bound to the data rule of the data item to be filled.
[0023] Optionally, if the rule configuration information also includes result text format information and sorting information, the rule configuration information also includes:
[0024] The WEBGL technology is used to configure corresponding sorting operations and result data processing operations for the data rules of the data to be filled items according to the result text format information and sorting information, and the data rules of the data to be filled items are regenerated.
[0025] Optionally, extracting the filling data corresponding to each data item to be filled in from a database bound to the form management system according to the rule configuration information and data rules corresponding to each data item to be filled in, includes:
[0026] Deconstruct the form template by using a custom data rule interpreter to obtain each data item to be filled in the form template and its parameters;
[0027] Acquire the data rule of the data to be filled item according to the rich text node element of the data to be filled item, and process the data rule of the data to be filled item by using the parameters of the data to be filled item;
[0028] The corresponding initial filling data is extracted from the database bound to the form management system according to the processed data rules, and the initial filling data is processed using the processed data rules and rule configuration information to obtain the filling data of the data to be filled item.
[0029] Optionally, after generating the form corresponding to the form name, the method further includes:
[0030] When a form export operation performed by the user on the form is detected, the form is exported as a word file.
[0031] A second aspect of the present application provides a form management system, the system comprising:
[0032] A dynamic multi-data source configuration unit is used to respond to a data source configuration operation of a user, display a data source configuration interface corresponding to the data source configuration operation, so that the user can input corresponding data source connection information based on the data source configuration interface; when the data source connection information input by the user is detected, the database indicated by the data source connection information is bound to the form management system;
[0033] The form online making unit responds to the form making operation of the user, receives the form name sent by the user based on the form making operation, and obtains the corresponding form template according to the form name; wherein the form template includes a plurality of data items to be filled; for each of the data items to be filled, extracts the corresponding filling data from the database bound to the form management system according to the data rule corresponding to the data item to be filled; wherein the data rule of the data item to be filled is generated by the data rule configuration unit according to the rule configuration information of the data item to be filled;
[0034] The form online preview unit is used to fill in the filling data of each data item to be filled in into the corresponding data item to be filled in, and generate and display the form corresponding to the form name.
[0035] The third aspect of the present application provides an electronic device, comprising: a processor and a memory, wherein the processor and the memory are connected via a communication bus; wherein the processor is used to call and execute a program stored in the memory; and the memory is used to store a program, wherein the program is used to implement the form management method provided in the first aspect of the present application.
[0036] A fourth aspect of the present application provides a computer-readable storage medium, in which computer-executable instructions are stored, and the computer-executable instructions are used to execute the form management method provided in the first aspect of the present application.
[0037] The present invention provides a form management method, system, electronic device and storage medium. By responding to a user's data source configuration operation, a data source configuration interface corresponding to the data source configuration operation is displayed, so that the user can input corresponding data source connection information based on the data source configuration interface; when the data source connection information input by the user is detected, the database indicated by the data source connection information is bound to the form management system. It can be seen that dynamic management and loading of multiple data sources can be realized according to the data source connection information input by the user, that is, multiple data sources are dynamically bound to the form management system, so that the form management system can flexibly adapt to different data requirements and structural differences, thereby avoiding the flexibility and applicability of the form generated by the limit value; and the application can also pre-set a form template and a data rule for each data item to be filled in the form template, so that when the user's form making operation is detected, the corresponding form template is obtained according to the form name corresponding to the form making operation, and the corresponding filling data is extracted from the data source bound to the form management system by using the data rule corresponding to each data item to be filled in the form template, and finally the filling data of each data item to be filled is filled into the corresponding data item to be filled, and a form corresponding to the form name is generated. It can be seen that the entire form generation process does not require the user to have a deep understanding of the relevant technology, which greatly reduces the user's learning cost, improves the design efficiency of the form and improves the user experience. BRIEF DESCRIPTION OF THE DRAWINGS
[0038] 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, the drawings described below are only embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying creative work.
[0039] Figure 1 A flowchart of a form management method provided in an embodiment of the present application;
[0040] Figure 2 An example diagram of a data source configuration interface provided in an embodiment of the present application;
[0041] Figure 3 An example diagram of a binding database and real-time viewing of database information of a bound database and table structure information of each data table in the database provided in an embodiment of the present application;
[0042] Figure 4 An example diagram of a data source viewing interface related to a MySQL database provided in an embodiment of the present application;
[0043] Figure 5 An example diagram of a form creation interface provided in an embodiment of the present application;
[0044] Figure 6 An example diagram for implementing data extraction, data filling and association calculation provided in an embodiment of the present application;
[0045] Figure 7 An example diagram of a data attribute configuration interface corresponding to a data item to be filled in corresponding to a project name provided in an embodiment of the present application;
[0046] Figure 8 An example diagram of a data rule for a data item to be filled provided in an embodiment of the present application;
[0047] Fig. 9 A schematic diagram of the structure of a form management system provided by an embodiment of the present invention;
[0048] Fig.10 A schematic diagram of the structure of another form management system provided by an embodiment of the present invention;
[0049] Fig.11 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION
[0050] 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.
[0051] In this application, relational terms such as first and second, etc. are used only 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 "comprise", "include" 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. In the absence of further restrictions, an element defined by the statement "comprises a ..." does not exclude the presence of other identical elements in the process, method, article or device including the element.
[0052] In order to better understand this application, the technical names involved in this application are explained below:
[0053] Multiple data sources: multiple databases, support online expansion links and management of databases, multiple databases include MySQL, SQLServer, etc.
[0054] Low code: Replace coding with page operations to achieve dynamic configuration.
[0055] Middleware form engine: As a middleware that connects various data sources within the enterprise, it realizes data integration, circulation and management, and provides form editing and filling functions.
[0056] See also Figure 1 , shows a flow chart of a form management method provided in an embodiment of the present application, the form management method is applied to a form management system, and the form management method specifically includes the following steps:
[0057] S101: In response to a data source configuration operation of a user, a data source configuration interface corresponding to the data source configuration operation is displayed, so that the user can input corresponding data source connection information based on the data source configuration interface.
[0058] In the specific process of executing step S101, the form management system provides a form management interface. When the user wants to dynamically configure multiple data sources (databases) for the system, the user can click the data source configuration button on the form management interface provided by the form management system to perform the corresponding data source configuration operation, so that when the form management system detects the user's data source configuration operation, it responds to the user's data source configuration operation and displays the data source configuration interface corresponding to the data source configuration operation, such as Figure 2 As shown, the user can input the corresponding data source connection information based on the data source configuration interface. The data source connection information at least includes the data source type (database type), host address, port number, data source name (database name) and corresponding authentication information of the data source.
[0059] It should be noted that the authentication information may include a user name and password, etc., which is not limited in the embodiment of the present application.
[0060] In some embodiments, Figure 2 For example, the user can click Figure 2 Click the Add button displayed in the form management system to add a data source (database) that you want to bind. Specifically, enter the data source connection information related to the data source that you want to bind, so that the form management system can bind the corresponding data source (database) according to the data source connection information entered by the user. Figure 2 You can also see that users can click Figure 2 Click the Modify button in the form management system to modify the data source connection information of the data source bound to the form management system; Figure 2 You can also see that users can click Figure 2 Click the Delete button in to unbind the data source bound to the form management system.
[0061] It should be noted that the database type can be MySQL, SQL Server, etc., which is not limited in the embodiments of this application.
[0062] As another implementation method of the embodiment of the present application, a corresponding data source configuration file can also be pre-set, wherein the data source configuration file includes multiple data sources and their related data source connection information; when the user's data source configuration operation is detected, the data source configuration file corresponding to the data source configuration operation can also be displayed, so that the user can view the data sources (databases) that can be bound to the system and their related data source connection information, and enter the data source connection information related to the database that wants to be bound to the system.
[0063] S102: When the data source connection information input by the user is detected, the database indicated by the data source connection information is bound to the form management system, and the data source connection information is stored.
[0064] In the specific process of executing step S102, when the form management system detects the data source connection information input by the user, it stores the data source connection information, and can determine the database to be bound to the form management system based on the database type and database name in the data source connection information, and bind the database corresponding to the database type and database name to the form management system through the middleware form engine according to the host address and port number.
[0065] It should be noted that storing the data source connection information is beneficial to subsequent data source connections, that is, it is beneficial to bind the database of the database type and database name to the form management system, and to perform corresponding authentication operations; wherein the user name and password in the data source connection information can be used to complete the corresponding authentication operations.
[0066] It can be seen that the present application realizes dynamic management and loading of multiple data sources according to the data source connection information input by the user through the middleware form engine, that is, dynamically binds multiple data sources to the form management system through the middleware form engine, so that the form management system can flexibly adapt to different data requirements and structural differences, thereby avoiding the flexibility and applicability of the form generated by the limit.
[0067] Furthermore, in the embodiment of the present application, the form management system can bind and authenticate the corresponding data source with the form management system according to the data source connection information such as the host address, port, user name, password, etc. of the data source (MySQL database, SQL Server data, etc.) input by the user, and manage the table structure and table data of the bound and authenticated data source (database). Specifically, the data extraction engine can be used to view the database information of the bound database and the table structure information of each data table in the database in real time through the system interface or command line tool, such as Figure 3 The table structure information includes the data table, field name and data type of the data table, etc., and the database information may include the host IP address, port number, user name, password, database version, number of data tables, etc., which are not limited in this embodiment of the present application.
[0068] Optionally, as an implementation method of an embodiment of the present application, a data source viewing interface related to the database indicated by the data source viewing operation can be displayed in response to a user's data source viewing operation; real-time detection can be performed to determine whether a data table query request sent by the user based on the data source viewing interface is received; wherein the data table query request includes at least a data table name; and when a data table query request is received, table structure information of the data table corresponding to the data table name is queried and displayed.
[0069] For example, when a user wants to view the table structure information of each table in the bound MySQL database, the user can perform the corresponding data source viewing operation on the displayed data source configuration interface. When the data source viewing operation is detected, the data source viewing interface related to the MySQL database is displayed in response to the data source viewing operation, such as Figure 4 As shown, so that users can Figure 4 Enter the data table name of the data table you want to view in the input box shown to send a corresponding data table query request to the form management system; when the data table query request is received, query and display the table structure information of the data table corresponding to the data table name indicated by the data table query request.
[0070] It is worth noting that from Figure 4 It can be seen that the user can also view the database information related to the MySQL database through the displayed data source viewing interface; wherein the database information may include the host IP address, port number, user name, password and database version, etc., which is not limited in this embodiment of the present application.
[0071] S103: responding to the user's form creation operation, receiving a form name sent by the user based on the form creation operation, and acquiring a corresponding form template according to the form name; wherein the form template includes a plurality of data items to be filled in.
[0072] In an embodiment of the present application, the form management system provides a form management interface. When a user wants to create a corresponding form, he or she can click a form creation button in the form management interface to perform the corresponding form creation operation. When the form management system detects the user's form creation operation, it responds to the user's form creation operation, and at the same time receives the form name input by the user based on the form creation operation, obtains the form parameters corresponding to the form name, and finally obtains the form template corresponding to the form name according to the form parameters.
[0073] It should be noted that users can pre-configure multiple low-code form templates through the online rich text editor, and pre-set corresponding form parameters for each form template, and finally establish a corresponding association relationship between each form parameter and the corresponding form template, so that when the form management system receives the form name input by the user based on the form making operation, it can query the form template that matches the form parameters corresponding to the form name according to the association relationship between the form parameters and the form template. Among them, each form template includes multiple data items to be filled.
[0074] In some embodiments, during the process of a user configuring a corresponding form template through an online rich text editor, each time a data item to be filled in the form template is detected to be configured by the user, the online rich text editor dynamically converts the data item to be filled in the form template into a browser native HTML element through an HTML-FormNode converter developed through JavaScript, thereby ensuring that the preview effect of the data item to be filled is restored 1:1 with the production and preview, thereby ensuring that the preview effect of the form template is restored 1:1 with the production and preview.
[0075] It can be seen that the HTML-FormNode converter developed through JavaScript can realize the mutual conversion between data items to be filled in and HTML elements, ensuring that the preview effect of the form template can be restored 1:1 between production and preview. That is, the HTML-FormNode converter can be developed based on JavaScript to use the HTML-FormNode converter to achieve compatible form template production and form template preview effects.
[0076] In actual application, the form management system responds to the user's form creation operation and displays the form creation interface corresponding to the form creation operation, such as Figure 5 As shown, the user enters the form name of the form they want to create in the input box of the form creation interface; when the form name entered by the user is detected, the form parameters corresponding to the form name are obtained, and according to the association between the form parameters and the form template, the form template matching the form parameters is queried from the pre-configured low-code form templates to obtain the form template corresponding to the form name. Among them, Figure 5 It includes various low-code form templates that users pre-set through the online rich text editor.
[0077] It should be noted that the form template corresponding to the form name can be accurately determined through the association between the form parameters and the form template, thereby avoiding the situation where the wrong form template is obtained when there is the same form name.
[0078] In some embodiments, each form template includes multiple data items to be filled in. For each data item to be filled in, data rules for each data item to be filled in can be set in advance, so that after obtaining the form template corresponding to the form name, the data filling of each data item to be filled in is completed according to the data rules corresponding to each data item to be filled in the form template, and the form corresponding to the form name is obtained.
[0079] S104: extracting filling data corresponding to each data item to be filled in from a database bound to the form management system according to the rule configuration information and data rules corresponding to each data item to be filled in.
[0080] In an embodiment of the present application, for each data item to be filled in each pre-set form template, the rule configuration information of the data item to be filled is obtained, and the data rules of the data item to be filled are generated according to the rule configuration information of the data item to be filled; specifically, the rule configuration information of the data item to be filled input by the user can be obtained, and the data rules of the data item to be filled are generated according to the rule configuration information using WEBGL technology.
[0081] Optionally, the process of generating data rules for the data item to be filled in according to the rule configuration information of the data item to be filled in can be specifically as follows: when a user's parameter configuration operation on the data item to be filled in the form template is detected, a data attribute configuration interface corresponding to the parameter configuration operation is displayed, so that the user can enter the rule configuration information corresponding to the data item to be filled in the data attribute configuration interface; when the rule configuration information input by the user based on the data attribute configuration interface is detected, the data rules corresponding to the data item to be filled are generated according to the rule configuration information using WEBGL technology.
[0082] In an embodiment of the present application, an online rich text editor can be pre-configured on the form management system so that the form template pasted by the user can be received and displayed through the online rich text editor, and when the user's parameter configuration operation on the data to be filled in the form template is detected in real time, the corresponding data attribute configuration interface can be displayed in response to the parameter configuration operation, so that the user can enter the corresponding rule configuration information on the data attribute interface, wherein the rule configuration information includes at least at least one form item, a first data table, a first data field, associated query information and filtering condition information, and the form item is the field item corresponding to the data to be filled; when the rule configuration information input by the user based on the data attribute interface is detected, the data rule corresponding to the data to be filled item is generated according to the first data table, the first data field, the associated query information and the filtering condition information in the rule configuration information by using WEBGL technology; wherein the form item is the field item corresponding to the data to be filled item.
[0083] It can be seen that the present application combines low-code design and provides a low-code form creation function in the online rich text editor configured in the form management system, allowing users to paste form templates in the online rich text editor and display the data attribute configuration interface corresponding to the data to be filled in to the user, so that users can directly configure the rule configuration information corresponding to the data to be filled in on the data attribute configuration interface without the need for in-depth understanding of coding knowledge, greatly reducing the learning cost; and, the present application can also generate corresponding data rules according to the rule configuration information input by the user through WEBGL technology, so that the data rules can be used to extract the filling data corresponding to the data to be filled in, so as to complete the corresponding data filling and generate the corresponding form, thereby improving the design efficiency of the form and enhancing the user experience.
[0084] As a preferred method of an embodiment of the present application, the process of generating data rules corresponding to data items to be filled according to rule configuration information using WEBGL technology can specifically be: determining the association type, the second data table and the second data field in the association query information; using WEBGL technology to associate the first data table and the first data field with the second data table and the third data field based on the association type and the second data field, and associating the third data field with the conditional configuration information to generate data rules for the data items to be filled; wherein the screening condition information includes at least the third data field and the conditional configuration information; converting the data items to be filled into rich text node elements, and binding the rich text node elements of the data items to be filled with the data rules of the data items to be filled.
[0085] From the above content, it can be seen that users can configure the data source (first data table and second data table), table association (associated query information), screening conditions and other rule configuration information related to the data items to be filled, and use WEBGL technology to implement graphical configuration plug-ins, and use the rule configuration information configured by the user to generate data rules in the form of graphs, that is, use WEBGL technology to implement graphical configuration of data rules for data items to be filled, without the need for users to have an in-depth understanding of coding knowledge, lowering the design threshold of forms, and improving form design efficiency and user experience. In addition, displaying data rules in a graphical way can also vividly display the relationship between data, making it easier for users to understand and adjust extraction rules, thereby improving the efficiency and accuracy of data extraction. In other words, using WEBGL technology can realize the visualization of data rules for data items to be filled, and display data rules in the form of data modules and connections to help users remember and understand.
[0086] It should be noted that the online rich text editor provided by this application can also edit form content by graphically dragging nodes, connecting nodes (form nodes), etc., that is, users can use the graphical configuration plug-in provided by WEBGL technology to configure the data rules corresponding to the data to be filled in the online rich text editor through a graphical interface. Users do not need to have an in-depth understanding of coding knowledge, which lowers the design threshold of the form, improves the design efficiency of the form and enhances the user experience.
[0087] It is worth noting that the user can associate the first data table, the first data field, the second data table, the second data field and the third data field in the rule configuration information corresponding to the data to be filled in by graphically dragging nodes and connecting nodes, and associate the third data field with the conditional configuration information to obtain the data rules for the data to be filled in. The entire data rule configuration process does not require in-depth understanding of coding knowledge, which lowers the design threshold of the form, improves the design efficiency of the form and enhances the user experience; and, displaying the data rules in a graphical way can also vividly display the relationship between the data, making it easier for users to understand and adjust the extraction rules, thereby improving the efficiency and accuracy of data extraction.
[0088] Optionally, the process of extracting the filling data corresponding to each data item to be filled in from the database bound to the form management system according to the rule configuration information and data rules corresponding to each data item to be filled in can be specifically as follows: deconstructing the form template through a custom data rule interpreter to obtain each data item to be filled in and its parameters in the expression template; obtaining the data rules of the data item to be filled in according to the rich text node elements of the data item to be filled in, and processing the data rules of the data item to be filled in using the parameters of the data item to be filled in; extracting the corresponding initial filling data from the database bound to the form management system according to the processed data rules, and processing the initial filling data using the processed data rules and rule configuration information to obtain the filling data of the data item to be filled in, so that the filling data of the data item to be filled in can be subsequently included in the data item to be filled in through the middleware form engine.
[0089] It should be noted that the application uses a custom data rule interpreter, which is more interpretable and extensible than XML and custom text. In addition, the custom data rule interpreter is written in Java, provides a standard input and output interface, and has a certain degree of decoupling, so that the form management system can better call the custom data rule interpreter through the input and output interface to deconstruct the form template. It can be seen that the custom data rule interpreter can ensure the dynamic and real-time nature of data processing, improve the efficiency and extensibility of data processing, and be compatible with complex data query and processing scenarios.
[0090] In actual application, see Figure 6After obtaining the corresponding form template, the form template can be previewed; the form template is deconstructed through a custom data rule interpreter to parse out each data item to be filled in the form template and its parameters, that is, to parse the parameters of the form template, and the form can also be echoed; the data rule of the data item to be filled is obtained according to the rich text node element of the data item to be filled, so as to extract data by using the data rule of each data item to be filled and its parameters and rule configuration, that is, to dynamically match the parameters of the data item to be filled with the data rule, so as to replace the conditional configuration information in the data rule with the parameters of the data item to be filled, complete the processing of the data rule, and form an initial query function; the initial query function is used to query the data corresponding to each form item in the rule configuration information from the database bound to the form management system according to each data table and each data field, so as to complete the corresponding data extraction; if there is only one form item in the rule configuration information, then it can be determined that the data of the form item is the initial filling data of the data to be filled in, and the parameters in the initial query function are used to perform secondary processing on the initial filling data to obtain the filling data of the data to be filled in, and finally the filling data of each data to be filled in is filled in the corresponding data to be filled in, so as to complete the corresponding data filling; if there is more than one form item in the rule configuration information, then the data of each form item together constitute the initial filling data, and the parameters in the initial query function are used to perform secondary processing on the data of each form item, and the data of each form item after the secondary processing are used to perform association calculation to complete the corresponding association calculation to obtain the filling data of the data to be filled in, and finally the filling data of each data to be filled in is filled in the corresponding data to be filled in, so as to complete the corresponding data filling.
[0091] Furthermore, in an embodiment of the present application, the user can also configure the result data text format information and sorting information of the data to be filled in through the data parameter configuration interface, that is, the rule configuration information also includes the result data text format information, then the form management system can further use WEBGL technology to configure corresponding sorting operations and result data processing operations for the data rules of the data to be filled in according to the result text format information and sorting information, and regenerate the data rules of the data to be filled in.
[0092] It is worth noting that by further configuring sorting operations and result data processing operations for the data rules of the data items to be filled, it is possible to solve the problem in the existing technology that the data filling and calculation functions are relatively limited and cannot meet the real-time and dynamic requirements, thereby improving the efficiency and accuracy of data processing.
[0093] It should be noted that users can also configure the font size and color of the data items to be filled in through the data parameter configuration interface. That is to say, the data rules of the data items to be filled in can also include corresponding font size and color, etc., which is not limited in the embodiments of the present application.
[0094] In actual application, when the user wants to configure the data rules of the field items (form items) in the design quality review record table as the data items to be filled in corresponding to the project name, the form template of the design quality review record table can be pasted into the online rich text editor configured on the form management system, so that the form management system receives and displays the form template of the design quality review record table through the online rich text editor; when it is detected that the user clicks on the data item to be filled in corresponding to the project name (form item) in the form template, it can be determined that the user has performed the corresponding parameter configuration operation on the data item to be filled in, and then the parameter configuration operation can be responded to and the corresponding data attribute configuration interface can be displayed, such as Figure 7 As shown, the user can enter the form item (project name), the first data table (project technical data table), the first data field (project name), the associated query information (internal association (association type), the second data table (process business table) and the second data field (project ID)), the screening condition information (the third data field (business data ID) and the condition configuration information (business ID)) and the result data text format information (result data processing - text segmentation (separator and index (1))) and other rule configuration information related to the data to be filled in the data configuration attribute interface.
[0095] When the rule configuration information input by the user based on the data attribute configuration interface is detected, it can be determined that the association type in the rule configuration information is an internal association, and then the first data table and the first data field can be internally associated with the second data table and the third data field through the second data field (project ID) by using WEBGL technology, and the condition configuration information (business ID) can be associated with the third data field in a search manner, and finally the corresponding result data processing-text segmentation operation is configured on the first data table to generate data rules corresponding to the data to be filled items, such as Figure 8 shown.
[0096] It should be noted that from Figure 8 It can be seen that the use of WEBGL technology can realize the visualization of data rules for data items to be filled, and the relationship between each data table, data field and corresponding operations of the data rules can be displayed in the form of data modules and connections, which can help users remember and understand.
[0097] Optionally, in an embodiment of the present application, the rule configuration information of the data item to be filled in also includes result data text format information and sorting information. Then, after obtaining the filling information of the data item to be filled in, the corresponding result data processing operation and sorting operation in the data rule of the data item to be filled in can further utilize the result data processing operation and sorting operation in the data rule to process the filling information of the data item to be filled in, so that the processed filling information can be subsequently filled into the data item to be filled in through the middleware form engine.
[0098] S105: Fill the filling data of each data item to be filled into the corresponding data item to be filled, and generate a form corresponding to the form name.
[0099] In the specific process of executing step S105, after obtaining the filling data of each data item to be filled in the form template, the filling data of each data item to be filled can be filled into the data item to be filled by the middleware form engine to generate a corresponding form.
[0100] S106: When a form export operation performed by the user on the form is detected, the form is exported as a word file.
[0101] In the specific process of executing step S106, the user can perform the corresponding form export operation by clicking the export option on the form management system, so that when the form management system detects the corresponding form export operation, it determines the export type indicated by the form export operation. If the export type is word, the form indicated by the form export operation can be generated into a corresponding Wrod file for the user to save or print.
[0102] It should be noted that the present application can also export the form to corresponding PDF, EXCEL and perform corresponding watermark overlay. Specifically, if the export type indicated by the form export operation instruction is PDF, the form indicated by the form export operation can be generated and exported to a corresponding PDF file; if the export type indicated by the form export operation instruction is EXCEL, the form indicated by the form export operation instruction can be generated and exported to a corresponding EXCEL file; if the export type indicated by the form export operation instruction is watermark overlay, the watermark of the form export operation instruction can be overlaid on the form indicated by the form export operation instruction, thereby completing the corresponding watermark overlay operation for the form.
[0103] Furthermore, in an embodiment of the present application, the form management system provided by the present application also includes a form management function, through which the version content corresponding to the form and the data rules of each data to be filled in the form template corresponding to the form are recorded to facilitate subsequent management and modification by the user; at the same time, the user's editing operations on the form and their editing content can also be recorded.
[0104] The present invention provides a form management method, which displays a data source configuration interface corresponding to the data source configuration operation in response to a user's data source configuration operation, so that the user can input corresponding data source connection information based on the data source configuration interface; when the data source connection information input by the user is detected, the database indicated by the data source connection information is bound to the form management system, thus it can be seen that dynamic management and loading of multiple data sources can be realized according to the data source connection information input by the user, that is, multiple data sources are dynamically bound to the form management system, so that the form management system can flexibly adapt to different data requirements and structural differences, thereby avoiding the flexibility and applicability of the form generated by the limit value; and, the present application can also pre-set a form template and a data rule for each data item to be filled in the form template, so that when the user's form making operation is detected, the corresponding form template is obtained according to the form name corresponding to the form making operation, and the corresponding filling data is extracted from the data source bound to the form management system by using the data rule corresponding to each data item to be filled in the form template, and finally the filling data of each data item to be filled is filled into the corresponding data item to be filled, and a form corresponding to the form name is generated, thus it can be seen that the entire form generation process does not require the user to have a deep understanding of the relevant technology, greatly reducing the user's learning cost, improving the form design efficiency and improving the user experience.
[0105] Based on the form management method provided by the above embodiment of the present invention, the embodiment of the present invention also provides a form management system, such as Fig. 9 As shown, the form management system includes:
[0106] The dynamic multi-data source configuration unit 91 is used to respond to the user's data source configuration operation, display the data source configuration interface corresponding to the data source configuration operation, so that the user can input the corresponding data source connection information based on the data source configuration interface; when the data source connection information input by the user is detected, the database indicated by the data source connection information is bound to the form management system;
[0107] The form online making unit 92 responds to the user's form making operation, receives the form name sent by the user based on the form making operation, and obtains the corresponding form template according to the form name; wherein the form template includes multiple data items to be filled; for each data item to be filled, the corresponding filling data is extracted from the database bound to the form management system according to the data rule corresponding to the data item to be filled; wherein the data rule of the data item to be filled is generated by the data rule configuration unit according to the rule configuration information of the data item to be filled;
[0108] The form online preview unit 93 is used to fill in the filling data of each data item to be filled in into the corresponding data item to be filled in, and generate and display a form corresponding to the form name.
[0109] The specific principles and execution processes of each unit in the form management system disclosed in the above embodiment of the present invention are the same as the form management method disclosed in the above embodiment of the present invention. Please refer to the corresponding parts of the form management method disclosed in the above embodiment of the present invention, and no further details will be given here.
[0110] The present invention provides a form management system, which displays a data source configuration interface corresponding to the data source configuration operation in response to a user's data source configuration operation, so that the user can input corresponding data source connection information based on the data source configuration interface; when the data source connection information input by the user is detected, the database indicated by the data source connection information is bound to the form management system, thus it can be seen that dynamic management and loading of multiple data sources can be realized according to the data source connection information input by the user, that is, multiple data sources are dynamically bound to the form management system, so that the form management system can flexibly adapt to different data requirements and structural differences, thereby avoiding the flexibility and applicability of the form generated by the limit value; and, the present application can also pre-set a form template and a data rule for each data item to be filled in the form template, so that when the user's form making operation is detected, the corresponding form template is obtained according to the form name corresponding to the form making operation, and the corresponding filling data is extracted from the data source bound to the form management system by using the data rule corresponding to each data item to be filled in the form template, and finally the filling data of each data item to be filled is filled into the corresponding data item to be filled, and a form corresponding to the form name is generated, thus it can be seen that the entire form generation process does not require the user to have a deep understanding of the relevant technology, greatly reducing the user's learning cost, improving the form design efficiency and improving the user experience.
[0111] Optionally, the form management system provided by this application also includes:
[0112] A dynamic multi-data source management unit is used to respond to a user's data source viewing operation, display a data source viewing interface related to the database indicated by the data source viewing operation; detect in real time whether a data table query request sent by the user based on the data source viewing interface is received; wherein the data table query request at least includes a data table name; when a data table query request is received, query and display table structure information of the data table corresponding to the data table name.
[0113] Optionally, a data rule configuration unit for generating data rules for the data to be filled item is generated according to the rule configuration information of the data to be filled item, specifically for:
[0114] When a user's parameter configuration operation on a data item to be filled in a form template is detected, a data attribute configuration interface corresponding to the parameter configuration operation is displayed, so that the user can enter rule configuration information corresponding to the data item to be filled in the data attribute configuration interface; when rule configuration information input by the user based on the data attribute configuration interface is detected, data rules corresponding to the data item to be filled are generated according to the rule configuration information using WEBGL technology.
[0115] Optionally, the rule configuration information at least includes the first data table, the first data field, the associated query information and the screening condition information, and the data rule configuration unit for generating the data rule corresponding to the data to be filled item according to the rule configuration information by using WEBGL technology is specifically used for:
[0116] Determine the association type, the second data table and the second data field in the association query information; use WEBGL technology to associate the first data table and the first data field with the second data table and the third data field according to the association type and the second data field, and associate the third data field with the condition configuration information to generate data rules for the data to be filled items; wherein the screening condition information includes at least the third data field and the condition configuration information; convert the data to be filled items into rich text node elements, and bind the rich text node elements of the data to be filled items with the data rules of the data to be filled items.
[0117] Optionally, the data rule configuration unit provided in the embodiment of the present application is further used to:
[0118] WEBGL technology is used to configure corresponding sorting operations and result data processing operations for the data rules of the data to be filled items according to the format information and sorting information of the result text, and the data rules of the data to be filled items are regenerated.
[0119] Optionally, the form online making unit for filling in data corresponding to each data item to be filled in is extracted from the database bound to the form management system according to the rule configuration information and data rules corresponding to each data item to be filled in, specifically used for:
[0120] The form template is deconstructed through a custom data rule interpreter to obtain each data item to be filled in the form template and its parameters; the data rules of the data item to be filled are obtained according to the rich text node elements of the data item to be filled, and the data rules of the data item to be filled are processed using the parameters of the data item to be filled; according to the processed data rules, the corresponding initial filling data is extracted from the database bound to the form management system, and the initial filling data is processed using the processed data rules and rule configuration information to obtain the filling data of the data item to be filled.
[0121] Optional, combined Fig. 9 See also Fig.10, the form management system provided in the embodiment of the present application further includes:
[0122] The form exporting unit 94 is used to export the form into a word file when a form exporting operation performed by the user on the form is detected.
[0123] The present application embodiment provides an electronic device, such as Fig.11 As shown, the electronic device includes a processor 1101 and a memory 1102, the memory 1102 is used to store program codes and data for form management, and the processor 1101 is used to call program instructions in the memory to execute the steps shown in the form management method in the above embodiment.
[0124] An embodiment of the present application provides a storage medium, which includes a storage program, wherein when the program is running, the device where the storage medium is located is controlled to execute the form management method shown in the above embodiment.
[0125] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the system or system embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment. The system and system embodiments described above are merely schematic, in which the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules can be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative labor.
[0126] Professionals may further appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in the above description according to function. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professionals and technicians may use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.
[0127] The above description of the disclosed embodiments enables one skilled in the art to implement or use the present invention. Various modifications to these embodiments will be apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention will not be limited to the embodiments shown herein, but rather to the widest scope consistent with the principles and novel features disclosed herein.
[0128] The above are only preferred embodiments 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 principles of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.
Claims
1. A form management method, It is characterized in that Applied to a form management system, the method comprises: In response to a data source configuration operation by a user, a data source configuration interface corresponding to the data source configuration operation is displayed, so that the user can input corresponding data source connection information based on the data source configuration interface; When the data source connection information input by the user is detected, binding the database indicated by the data source connection information with the form management system; Responding to the user's form creation operation, and receiving a form name sent by the user based on the form creation operation, and acquiring a corresponding form template according to the form name; wherein the form template includes a plurality of data items to be filled in; Extracting the filling data corresponding to each data item to be filled in from the database bound to the form management system according to the rule configuration information and data rules corresponding to each data item to be filled in; wherein the data rules of the data item to be filled in are generated according to the rule configuration information of the data item to be filled in; Fill the filling data of each of the data items to be filled into the corresponding data items to be filled, and generate a form corresponding to the form name.
2. The method according to claim 1, It is characterized in that The database includes a plurality of data tables. After binding the database indicated by the data source connection information with the form management system, the method includes: In response to the user's data source viewing operation, displaying a data source viewing interface related to the database indicated by the data source viewing operation; detecting in real time whether a data table query request sent by the user based on the data source viewing interface is received; wherein the data table query request at least includes a data table name; When the data table query request is received, the table structure information of the data table corresponding to the data table name is queried and displayed.
3. The method according to claim 1, It is characterized in that The step of generating the data rule of the data item to be filled according to the rule configuration information of the data item to be filled includes: When a parameter configuration operation of the user on the data to be filled in the form template is detected, a data attribute configuration interface corresponding to the parameter configuration operation is displayed, so that the user can input rule configuration information corresponding to the data to be filled in the data attribute configuration interface; When the rule configuration information input by the user based on the data attribute configuration interface is detected, the data rule corresponding to the data to be filled item is generated according to the rule configuration information using WEBGL technology.
4. The method according to claim 3, It is characterized in that The rule configuration information at least includes the first data table, the first data field, the associated query information and the screening condition information; The step of using the WEBGL technology to generate the data rules corresponding to the data to be filled items according to the rule configuration information includes: Determine the association type, the second data table, and the second data field in the association query information; Using WEBGL technology to associate the first data table and the first data field with the second data table and the third data field according to the association type and the second data field, and to associate the third data field with condition configuration information, so as to generate data rules for the data to be filled item; wherein the screening condition information at least includes the third data field and the condition configuration information; The data item to be filled is converted into a rich text node element, and the rich text node element of the data item to be filled is bound to the data rule of the data item to be filled.
5. The method according to claim 4, It is characterized in that If the rule configuration information also includes result data text format information and sorting information, the rule configuration information also includes: The WEBGL technology is used to configure corresponding sorting operations and result data processing operations for the data rules of the data to be filled items according to the result text format information and sorting information, and the data rules of the data to be filled items are regenerated.
6. The method according to claim 4, It is characterized in that The step of extracting the filling data corresponding to each data item to be filled in from the database bound to the form management system according to the rule configuration information and data rules corresponding to each data item to be filled in includes: Deconstruct the form template by using a custom data rule interpreter to obtain each data item to be filled in the form template and its parameters; Acquire the data rule of the data to be filled item according to the rich text node element of the data to be filled item, and process the data rule of the data to be filled item by using the parameters of the data to be filled item; The corresponding initial filling data is extracted from the database bound to the form management system according to the processed data rules, and the initial filling data is processed using the processed data rules and rule configuration information to obtain the filling data of the data to be filled item.
7. The method according to claim 1, It is characterized in that After generating the form corresponding to the form name, the method further includes: When a form export operation performed by the user on the form is detected, the form is exported as a word file.
8. A form management system, It is characterized in that The system comprises: A dynamic multi-data source configuration unit is used to respond to a data source configuration operation of a user, display a data source configuration interface corresponding to the data source configuration operation, so that the user can input corresponding data source connection information based on the data source configuration interface; when the data source connection information input by the user is detected, the database indicated by the data source connection information is bound to the form management system; The form online making unit responds to the form making operation of the user, receives the form name sent by the user based on the form making operation, and obtains the corresponding form template according to the form name; wherein the form template includes a plurality of data items to be filled; for each of the data items to be filled, extracts the corresponding filling data from the database bound to the form management system according to the data rule corresponding to the data item to be filled; wherein the data rule of the data item to be filled is generated by the data rule configuration unit according to the rule configuration information of the data item to be filled; The form online preview unit is used to fill in the filling data of each data item to be filled in into the corresponding data item to be filled in, and generate and display the form corresponding to the form name.
9. An electronic device, It is characterized in that include: A processor and a memory, wherein the processor and the memory are connected via a communication bus; wherein the processor is used to call and execute a program stored in the memory; The memory is used to store a program, and the program is used to implement the form management method according to any one of claims 1 to 7.
10. A computer-readable storage medium, It is characterized in that The computer-readable storage medium stores computer-executable instructions, and the computer-executable instructions are used to execute the form management method according to any one of claims 1 to 7.
