CN117291156A - Engineering form data generation system and method based on dynamic interpretation - Google Patents
Engineering form data generation system and method based on dynamic interpretation Download PDFInfo
- Publication number
- CN117291156A CN117291156A CN202311322267.8A CN202311322267A CN117291156A CN 117291156 A CN117291156 A CN 117291156A CN 202311322267 A CN202311322267 A CN 202311322267A CN 117291156 A CN117291156 A CN 117291156A
- Authority
- CN
- China
- Prior art keywords
- data
- filling
- template
- generating
- engineering
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 37
- 238000009877 rendering Methods 0.000 claims abstract description 30
- 238000007639 printing Methods 0.000 claims description 3
- 238000005516 engineering process Methods 0.000 abstract description 4
- 230000004048 modification Effects 0.000 abstract description 4
- 238000012986 modification Methods 0.000 abstract description 4
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000005429 filling process Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/183—Tabulation, i.e. one-dimensional positioning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- Strategic Management (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a dynamic interpretation-based engineering form data generation system and a method thereof, wherein the method comprises the steps of S1, drawing a filling form to generate interface data in a Json format; s2, selecting cells in the filled form and binding data items to generate a data template in a Json file format; s3, invoking a Json file of the target data template, and rendering the Json file as a filling interface; s4, storing the filling data of the user to a server; s5, acquiring the filled data and the target data template from the server, and rendering to generate an engineering data report. The invention adopts the dynamic report technology to well solve the final result output problem of the data form, reduces the custom modification engineering quantity of the report, is a working method for intuitiveness and usability of filling interfaces and improving filling efficiency when engineering personnel perform data filling and approval work, and can reduce the workload and improve the working convenience.
Description
Technical Field
The invention belongs to the technical field of form filling, and particularly relates to an engineering form data generation system and method based on dynamic interpretation.
Background
The project construction process involves various system forms to be filled and approved, the related forms also have differences due to different regions, project grades and professions, and data among the forms in the professions involve data pushing and calculating relations, so that the project data filling system has higher adaptability difficulty among various projects, most scenes need to be redeveloped, and therefore, a lot of extra workload can be generated.
Disclosure of Invention
Aiming at the defects in the prior art, the engineering form data generation system and the engineering form data generation method based on dynamic interpretation solve the problems of high difficulty and high workload in the existing engineering form filling process.
In order to achieve the aim of the invention, the invention adopts the following technical scheme: an engineering form data generation system based on dynamic interpretation, comprising:
and a template generation module: the data input method comprises the steps of generating a data template, wherein corresponding data items are bound in input positions of the form template;
and a filling and rendering module: rendering the data template into a filling interface;
a table generation module: and the method is used for rendering the filling data into a filling interface to generate an engineering data report.
Further, the template generation module comprises a filling interface drawing unit and a data item binding unit;
the filling interface drawing unit is used for drawing a filling form and converting the filling form into interface data in a Json format;
the data item binding unit is used for binding corresponding data items at the input position of the filling form to generate a data template; the data items are the associated field names of the selected cells in the filling table, the input control types and the circulation item information of the data items needing circulation, and the selected and bound cells are configured with corresponding Tag attributes.
Further, the template generating unit further comprises a grouping configuration unit for expanding the filling area of the form template when the data amount of the filling data is larger than the number of the filling form cells.
A method for generating engineering form data comprises the following steps:
s1, drawing a filling form to generate interface data in a Json format;
s2, selecting cells in the filled form and binding data items to generate a data template in a Json file format;
s3, invoking a Json file of the target data template, and rendering the Json file as a filling interface;
s4, storing the filling data of the user to a server;
s5, acquiring the filled data and the target data template from the server, and rendering to generate an engineering data report.
Further, the method for drawing the filled-in table in the step S1 specifically includes:
drawing a table style by using Excel, and converting the table style into interface data in a Json format after the table style is imported into a system;
and/or using a form online editor to draw the filled form and generating interface data in the Json format.
Further, the step S2 specifically includes:
s21, selecting cells in the filling form;
s22, configuring the associated fields of the cells and the input control types, and configuring circulation item information for the data items needing to be circulated;
s23, binding data item information of the unit cells, setting the Tag attribute of the unit cells, and generating a data template in a Json file format.
Further, the step S2 further includes table grouping configuration, and the method specifically includes:
and selecting a data filling area needing multiplexing in the filling table, and setting a corresponding grouping attribute record.
Further, the step S3 specifically includes:
s31, invoking a Json file of a target data template;
s32, creating a data domain object store for storing the filling data;
s33, circulating the Page in the Json file, generating a corresponding table label according to the Page, and setting a default style for the table;
s34, circulating the TrArray in the Json file to generate a tr tag;
s35, circulating TdARRAy in the Json file, generating a td tag, and setting TdStyle in the data domain object as a td pattern;
s36, analyzing Tag attributes in the Json file, and generating data items in a data field according to the field of the field name;
s37, generating a specific input control according to the field type field of the Tag attribute, and bidirectionally binding an input value of an input box to the specific attribute of the data domain object to finish the rendering of the filling interface.
Further, the step S5 specifically includes:
s51, acquiring a target data template and filling data from a server;
s52, generating an Html label from the target data template, and binding corresponding report data;
s53, creating an iframe, and rendering the generated Html tag in a new iframe;
s54, when rendering is completed, the printing method of the iframe is removed, and then the engineering data report in the PDF format is exported.
The beneficial effects of the invention are as follows:
(1) When the method is used, no plug-in is required to be installed, the native Html is adopted for rendering, and the compatibility of the browser is better.
(2) The invention adopts the standard filling interface rendering technology, so that the filling interface is obtained and the usability is increased.
(3) The data are filled in the partitions and stored in a classified mode, so that multiplexing and digital application of the data are facilitated.
(4) According to the invention, the Excel and the online editor are used for drawing the template, so that the drawing efficiency of the form template is improved.
Drawings
FIG. 1 is a flow chart of a method for generating engineering form data according to the present invention.
Detailed Description
The following description of the embodiments of the present invention is provided to facilitate understanding of the present invention by those skilled in the art, but it should be understood that the present invention is not limited to the scope of the embodiments, and all the inventions which make use of the inventive concept are protected by the spirit and scope of the present invention as defined and defined in the appended claims to those skilled in the art.
Example 1:
the embodiment of the invention provides an engineering form data generation system based on dynamic interpretation, which comprises the following steps:
and a template generation module: the data input method comprises the steps of generating a data template, wherein corresponding data items are bound in input positions of the form template;
and a filling and rendering module: rendering the data template into a filling interface;
a table generation module: and the method is used for rendering the filling data into a filling interface to generate an engineering data report.
In the embodiment of the invention, the template generation module comprises a filling interface drawing unit and a data item binding unit; the filling interface drawing unit is used for drawing the filling form and converting the filling form into interface data in a Json format; the data item binding unit is used for binding the corresponding data item at the input position of the filling form to generate a data template; the data item is the associated field name of the selected cell in the filling table, the input control type and the circulation item information of the data item needing circulation, and the selected and bound cell is configured with the corresponding Tag attribute.
In this embodiment, the form filling drawing has two modes, one mode is to draw a form style by using Excel, and then import the system, and the system converts the Excel data into interface data in Json format; another way is to use an online editor (without plug-ins) to draw and output interface data in Json format.
In this embodiment, when binding data items, the specific operations are as follows: firstly, selecting cells in a table, then selecting data items, then, configuring input control types (text, date, picture and signature), and simultaneously configuring circulation item information for the data items needing circulation, wherein the circulation item information specifically comprises circulation types, circulation times and intervals; the method comprises the steps of setting a Tag attribute for cells of a table when binding is executed, wherein the Tag attribute is a Json object, and the name of an associated field, the type of an input control and circulation item information are stored in the Tag attribute.
In the embodiment of the invention, the template generating unit further comprises a grouping configuration unit for expanding the filling area of the form template when the data quantity of the filling data is larger than the number of the filling form cells. Specifically, in this embodiment, the data amount of some tables in actual report filling is far greater than the number of cells of the table template, and for such a scenario, it is necessary to perform grouping configuration, first select a data filling area to be multiplexed in the tables, and then click setting, and set a grouping attribute record for the area. Based on the setting, the data filling area can be increased and selected through interface operation during filling, so as to expand the filling area and be used for filling data.
In the report rendering module in the embodiment of the invention, a specific data template is required to be selected to obtain a Json file of the data template, and then the Json file is rendered into a filling interface by using an interface interpreter module.
In the table generation module in the embodiment of the invention, firstly, data in a data domain is acquired, then the data in the data domain is sent to a server end for storage, and the data is rendered into a data module by utilizing an interface interpreter to generate an engineering data report.
According to the method for rendering the filling interface of the engineering form data, under the condition that main business logic of the filling system is unchanged, according to the actual project standard form, the system interface interpreter automatically generates a filling interface technology consistent with the standard form according to the rule through dynamic rule configuration, so that an engineering data report is formed rapidly.
Example 2:
the embodiment of the invention provides a method for generating engineering form data corresponding to the engineering form data generating system in the embodiment 1, as shown in fig. 1, comprising the following steps:
s1, drawing a filling form to generate interface data in a Json format;
s2, selecting cells in the filled form and binding data items to generate a data template in a Json file format;
s3, invoking a Json file of the target data template, and rendering the Json file as a filling interface;
s4, storing the filling data of the user to a server;
s5, acquiring the filled data and the target data template from the server, and rendering to generate an engineering data report.
In step S1 of the embodiment of the present invention, the method for drawing the filled form specifically includes:
drawing a table style by using Excel, and converting the table style into interface data in a Json format after the table style is imported into a system;
and/or using a form online editor to draw the filled form and generating interface data in the Json format.
The step S2 in the embodiment of the present invention specifically includes:
s21, selecting cells in the filling form;
s22, configuring the associated fields of the cells and the input control types, and configuring circulation item information for the data items needing to be circulated;
s23, binding data item information of the unit cells, setting the Tag attribute of the unit cells, and generating a data template in a Json file format.
In this embodiment, the control types include text, date, picture and signature, and the loop item information includes a loop type, a loop number and an interval, where the loop type includes four types of horizontal, vertical, horizontal-first-then-vertical, vertical-first-then-horizontal, and finally click binding, and when binding is performed, a Tag attribute is set for a cell of the table, where the Tag attribute is a Json object, and a name of an associated field, a type of an input control, and loop item information are stored therein.
In the embodiment of the present invention, step S2 further includes grouping configuration of tables, where the data amount of some tables during actual report filling is far beyond the number of cells of the table template, and for this scenario, grouping configuration is required, and the configuration method is as follows:
selecting a data filling area to be multiplexed in a filling table, and setting a corresponding grouping attribute record; based on the setting, the data filling area can be increased and selected through interface operation during filling, so as to expand the filling area and be used for filling data.
In the embodiment of the invention, after the data template is set, the data template is generated into the Json file, the style and configuration information of the table are stored in the Json text, and then the Json file is stored in the server.
The step S3 in the embodiment of the present invention specifically includes:
s31, invoking a Json file of a target data template;
the Json file format is exemplified as follows:
{"Pages":[{"Index":0,"Name":"sheet1","Row":1,"Col":1,
"TrArray":[{"TdArray":[{"Value":"","Alias":
"","Style":"","TdStyle":"","Colspan":0,"Rowspan":
0,"IsRender":true,"IsMerge":false,"RowIndex":
0,"ColIndex":0,"IsEdit":true,"Tag":
{"FieldName":"userName","FieldType":"text","IsArray":
false,"TableType":0,"TablePage":
false,"TableHNumber":0,"TableHStep":0,"TableVNumber":
0,"TableVStep":0}}]}]}]}
s32, creating a data field object store= { } for storing the filling data;
s33, circulating the Page in the Json file, generating a corresponding table label according to the Page, and setting a default style for the table;
s34, circulating the TrArray in the Json file to generate a tr tag;
s35, circulating TdARRAy in the Json file, generating a td tag, and setting TdStyle in the data domain object as a td pattern;
s36, analyzing Tag attributes in the Json file, and generating data items in a data field according to the field of the field name; such as store [ "userName" ] = ";
s37, generating a specific input control according to the field type field of the Tag attribute, and bidirectionally binding an input value of an input box to the specific attribute of the data domain object to finish the rendering of the filling interface.
In the present embodiment, for a data template with configuration groupings, regions are newly added or deleted by adding and subtracting page operations; if the deletion area has the filled value, the corresponding data in the data field is deleted.
The step S5 of the embodiment of the invention specifically comprises the following steps:
s51, acquiring a target data template and filling data from a server;
s52, generating an Html label from the target data template, and binding corresponding report data;
s53, creating an iframe, and rendering the generated Html tag in a new iframe;
s54, when rendering is completed, the printing method of the iframe is removed, and then the engineering data report in the PDF format is exported.
The embodiment of the invention can well solve the final result output problem of the data form by adopting a dynamic report technology, reduces the custom modification engineering quantity of the report, is a working method for intuitiveness and usability of filling interfaces and improving filling efficiency when engineering personnel perform data filling and approval work, and can reduce the workload and improve the working convenience.
The principles and embodiments of the present invention have been described in detail with reference to specific examples, which are provided to facilitate understanding of the method and core ideas of the present invention; meanwhile, as those skilled in the art will have variations in the specific embodiments and application scope in accordance with the ideas of the present invention, the present description should not be construed as limiting the present invention in view of the above.
Those of ordinary skill in the art will recognize that the embodiments described herein are for the purpose of aiding the reader in understanding the principles of the present invention and should be understood that the scope of the invention is not limited to such specific statements and embodiments. Those of ordinary skill in the art can make various other specific modifications and combinations from the teachings of the present disclosure without departing from the spirit thereof, and such modifications and combinations remain within the scope of the present disclosure.
Claims (9)
1. An engineering form data generation system based on dynamic interpretation, comprising:
and a template generation module: the data input method comprises the steps of generating a data template, wherein corresponding data items are bound in input positions of the form template;
and a filling and rendering module: rendering the data template into a filling interface;
a table generation module: and the method is used for rendering the filling data into a filling interface to generate an engineering data report.
2. The dynamic interpretation-based engineering form data generation system of claim 1, wherein the template generation module includes a filling interface drawing unit and a data item binding unit;
the filling interface drawing unit is used for drawing a filling form and converting the filling form into interface data in a Json format;
the data item binding unit is used for binding corresponding data items at the input position of the filling form to generate a data template; the data items are the associated field names of the selected cells in the filling table, the input control types and the circulation item information of the data items needing circulation, and the selected and bound cells are configured with corresponding Tag attributes.
3. The dynamic interpretation-based engineering form data generating system of claim 2, wherein the template generating unit further includes a grouping configuration unit for expanding a filling area of the form template when the amount of the filled data is greater than the number of the filled form cells.
4. A method for generating engineering form data based on the dynamic interpretation-based engineering form data generating system as claimed in any one of claims 1 to 3, characterized by comprising the steps of:
s1, drawing a filling form to generate interface data in a Json format;
s2, selecting cells in the filled form and binding data items to generate a data template in a Json file format;
s3, invoking a Json file of the target data template, and rendering the Json file as a filling interface;
s4, storing the filling data of the user to a server;
s5, acquiring the filled data and the target data template from the server, and rendering to generate an engineering data report.
5. The method for generating engineering form data according to claim 4, wherein the method for drawing the filled form in step S1 specifically comprises:
drawing a table style by using Excel, and converting the table style into interface data in a Json format after the table style is imported into a system;
and/or using a form online editor to draw the filled form and generating interface data in the Json format.
6. The method for generating engineering form data according to claim 4, wherein the step S2 specifically comprises:
s21, selecting cells in the filling form;
s22, configuring the associated fields of the cells and the input control types, and configuring circulation item information for the data items needing to be circulated;
s23, binding data item information of the unit cells, setting the Tag attribute of the unit cells, and generating a data template in a Json file format.
7. The method for generating engineering form data according to claim 6, wherein the step S2 further includes form grouping configuration, and the method specifically includes:
and selecting a data filling area needing multiplexing in the filling table, and setting a corresponding grouping attribute record.
8. The method for generating engineering form data according to claim 6, wherein the step S3 specifically comprises:
s31, invoking a Json file of a target data template;
s32, creating a data domain object store for storing the filling data;
s33, circulating the Page in the Json file, generating a corresponding table label according to the Page, and setting a default style for the table;
s34, circulating the TrArray in the Json file to generate a tr tag;
s35, circulating TdARRAy in the Json file, generating a td tag, and setting TdStyle in the data domain object as a td pattern;
s36, analyzing Tag attributes in the Json file, and generating data items in a data field according to the field of the field name;
s37, generating a specific input control according to the field type field of the Tag attribute, and bidirectionally binding an input value of an input box to the specific attribute of the data domain object to finish the rendering of the filling interface.
9. The method for generating engineering form data according to claim 8, wherein the step S5 specifically comprises:
s51, acquiring a target data template and filling data from a server;
s52, generating an Html label from the target data template, and binding corresponding report data;
s53, creating an iframe, and rendering the generated Html tag in a new iframe;
s54, when rendering is completed, the printing method of the iframe is removed, and then the engineering data report in the PDF format is exported.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311322267.8A CN117291156A (en) | 2023-10-12 | 2023-10-12 | Engineering form data generation system and method based on dynamic interpretation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311322267.8A CN117291156A (en) | 2023-10-12 | 2023-10-12 | Engineering form data generation system and method based on dynamic interpretation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117291156A true CN117291156A (en) | 2023-12-26 |
Family
ID=89247880
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311322267.8A Pending CN117291156A (en) | 2023-10-12 | 2023-10-12 | Engineering form data generation system and method based on dynamic interpretation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117291156A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
| CN111414742A (en) * | 2020-03-18 | 2020-07-14 | 苏宁云计算有限公司 | Method and device for self-service configuration of form template |
| CN113032633A (en) * | 2021-04-15 | 2021-06-25 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
| WO2023000012A1 (en) * | 2021-07-18 | 2023-01-26 | Hong Lin | Template systems for template-based document and report generation |
| CN116468010A (en) * | 2023-02-27 | 2023-07-21 | 河钢数字技术股份有限公司 | Report generation method, device, terminal and storage medium |
-
2023
- 2023-10-12 CN CN202311322267.8A patent/CN117291156A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
| CN111414742A (en) * | 2020-03-18 | 2020-07-14 | 苏宁云计算有限公司 | Method and device for self-service configuration of form template |
| CN113032633A (en) * | 2021-04-15 | 2021-06-25 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
| WO2023000012A1 (en) * | 2021-07-18 | 2023-01-26 | Hong Lin | Template systems for template-based document and report generation |
| CN116468010A (en) * | 2023-02-27 | 2023-07-21 | 河钢数字技术股份有限公司 | Report generation method, device, terminal and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104866426B (en) | Software test integrated control method and system | |
| CN101661460B (en) | Method and device for generating management system report | |
| US20030050995A1 (en) | Method and system for delivering dynamic information in a network | |
| CN108763171A (en) | A kind of document automation generation method based on format module | |
| CN104035754A (en) | XML (Extensible Markup Language)-based custom code generation method and generator | |
| CN114115883B (en) | Method for quickly constructing front-end application by using middle station service capability | |
| CN103530407B (en) | Method and device for generating rich text document | |
| CN108009243B (en) | Multi-user synchronous editing processing system and processing method for same document | |
| CN106293664A (en) | Code generating method and device | |
| CN110705237B (en) | Automatic document generation method, data processing device and storage medium | |
| CN106844307B (en) | System and method for converting Excel into Word based on mark | |
| CN111221522A (en) | Automatic code generation method of front-end and back-end separation architecture for government intensive application development | |
| CN104317839A (en) | Method and device for generating report form template | |
| CN110543303A (en) | Visual business platform | |
| CN107608894A (en) | Software testing generation method, system and storage medium based on dynamic model | |
| CN111309313A (en) | Method for quickly generating HTML (hypertext markup language) and storing form data | |
| CN107608895A (en) | Software testing generation method, system and storage medium based on static models | |
| CN108388753B (en) | Method, device and system for designing SIS cabinet wiring and storage medium | |
| CN113283228A (en) | Document generation method and device, electronic equipment and storage medium | |
| CN106156306A (en) | A kind of template rendering intent and device | |
| CN104750463B (en) | A kind of developing plug method and system | |
| CN104298705A (en) | Converting method of relational data and unstructured data | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN117291156A (en) | Engineering form data generation system and method based on dynamic interpretation | |
| CN110502735B (en) | Method and system for quickly manufacturing universal process file of electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |