CN-122021581-A - File management method and system based on online electronic form design filling

CN122021581ACN 122021581 ACN122021581 ACN 122021581ACN-122021581-A

Abstract

The invention provides a file management method and system based on online electronic form design filling, wherein the method comprises the steps of receiving user electronic form design operation through a design interface, including electronic form free layout operation, placing components to form cells and configuring component attributes in a dragging mode, obtaining a form file template based on the user electronic form design, generating form rendering resources used for rendering a form interface, enabling the form file template and the form interface to keep form visual features of the user design, wherein the form visual features comprise form styles and layout structures, creating a form instance, dynamically rendering the form interface through the form rendering resources, receiving and storing form filling data, conducting flow approval on the filled form based on a preconfigured approval process, and generating a project form file based on the form filling data passing through the form file template and approval after approval is completed, so that project file management efficiency is improved.

Inventors

WEI JINTAO
SUN HAOTIAN
YUAN YIXIN
Xia Yingyin

Assignees

浙江华东工程数字技术有限公司
中国电建集团华东勘测设计研究院有限公司

Dates

Publication Date: 20260512
Application Date: 20251212

Claims (10)

1. A method for managing files based on online spreadsheet design filling, comprising: Receiving a user electronic form design operation through a design interface, wherein the electronic form design operation comprises an electronic form free layout operation, placing components into form cells in a dragging mode and configuring component attributes; Obtaining a form file template based on user electronic form design, and generating form rendering resources for rendering a form interface, wherein the form file template and the form interface keep form visual features designed by a user, and the form visual features comprise form styles and layout structures; creating a form instance, dynamically rendering a form interface through a form rendering resource, receiving and storing form filling data, and performing flow approval on the filled form based on a preconfigured approval process; And after the approval is finished, generating a project table file based on the table file template and form filling data passing the approval.
2. The online electronic form design filling-based file management method according to claim 1, wherein the electronic form editing area provides basic electronic form free layout functions including cell merging, multi-level header generation, fixed text filling and text style setting.
3. The online spreadsheet design-based filing file management method of claim 1, wherein the design interface is provided by an online form designer based on Luckysheet open source framework secondary development implementation.
4. The online spreadsheet design-based filing method as recited in claim 1, wherein the form rendering resources comprise form configuration objects and HTML files.
5. The online spreadsheet design and filling-based file management method according to claim 4, wherein the form configuration object comprises a component code, a component identifier consisting of form fields, and attribute configuration information.
6. The file management method based on online electronic form design filling according to claim 1, wherein the creating a form instance, dynamically rendering a form interface through a form rendering resource, receiving and storing form filling data, specifically comprises: Creating a form instance, analyzing a occupation identifier in an HTML file, replacing the occupation identifier with a corresponding Vue component according to a component identifier in a form configuration object, and transmitting the component attribute configuration; Initializing form data objects, and establishing bidirectional binding of a Vue component and the form data objects; And receiving form filling data, updating the form filling data to form data objects, and serializing and storing the form filling data into a database form data table.
7. The method for managing files based on online electronic form design filling according to claim 1, wherein generating the project form file based on the form filling data passed by the form file template and the approval after the approval is completed, specifically comprises: after the approval is completed, the server loads a form file template and reads form filling data passing the approval; and generating the project table file containing the user data by matching the form field in the table file template identifier with the value in the form filling data and replacing the area occupied by the identifier with the value.
8. A file management system (100) based on online spreadsheet design filling, for running the file management method based on online spreadsheet design filling as claimed in any one of claims 1-7, said system comprising: The file design module (101) is used for receiving a user electronic form design operation through a design interface, wherein the electronic form design operation comprises an electronic form free layout operation, placing components into form cells in a dragging mode and configuring component attributes; The resource acquisition module (102) is used for obtaining a form file template based on the user electronic form design and generating form rendering resources for rendering a form interface, wherein the form file template and the form interface keep form visual features designed by the user, and the form visual features comprise form styles and layout structures; The form generation module (103) is used for creating a form instance, dynamically rendering a form interface through a form rendering resource, receiving and storing form filling data, and performing flow approval on the filled form based on a pre-configured approval process; And the file export module (104) is used for generating a project table file based on the table file template and the form filling data passing the approval after the approval is completed.
9. An electronic device, comprising: A memory for storing a computer program; A processor for executing a program stored on a memory, implementing the method steps of any one of claims 1-7.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium has stored therein a computer program which, when executed by a processor, implements the method steps of any of claims 1-7.

Description

File management method and system based on online electronic form design filling Technical Field The disclosure relates to the field of engineering file management application, in particular to a file management method and system based on online electronic form design filling. Background In engineering project management, file management is a vital link, and in the prior art, two types of defects mainly exist in engineering project file management: The first category is a systematic defect of traditional localization management, and is mainly represented by: (1) Form standard confusion, each project department and department rely on a local Excel tool to design a template by themselves, and due to lack of unified version control and field specification, construction log field error and omission and inconsistent acceptance report patterns are caused, file auditing needs repeated communication, and efficiency is low; (2) The collaborative process is low in efficiency, files are transferred to an approver through mails or paper after being filled, approval lag and version conflict are easy to occur, files of different versions are needed to be manually tidied during archiving, and risks of untimely archiving or version loss exist; (3) The data island is serious, the file information is stored in local equipment in a scattered manner, key data such as project names, acceptance results and the like cannot be extracted for statistical analysis, and project decisions are difficult to support. The second type is the technical defect of the existing improved online form system, and is mainly characterized in that a form system provides an online form approval interface shown in fig. 2, but the form interface cannot support complex form styles and layout designs, if a user needs to export files meeting specifications, the user needs to additionally configure independent file templates and manually fill form data, the operation flow is complicated, the final file format cannot be previewed in the design stage, and the user experience is cracked and the operation efficiency is low. The related art can be found in patent application (publication No. CN113987398A, CN 115826950A). Another form of system adopts a technical path of "preset field identification-local Excel template design-upload and parse into online form", but the following obvious disadvantages still exist although online approval is realized: (1) The user needs to manually define the field identification in advance, the learning cost is high, and the operation is easy to make mistakes; (2) The field identification lacks standardization, the similar templates can not be reused, and the development and management cost is high; (3) After the template is updated, the new form data and the old form data are not associated, so that data faults are easily caused, and traceability is affected. Therefore, there is a need for an engineering project file management scheme that can not only maintain the operation habit of the electronic form of the user, but also reduce the use threshold, and improve the file operation efficiency and the user experience, so as to solve the above technical problems. Disclosure of Invention In view of the above, the present disclosure provides a file management method and system based on online electronic form design filling, so as to solve the problems existing in the existing method. In a first aspect, the present disclosure provides a file management method based on online spreadsheet design filling, comprising: Receiving a user electronic form design operation through a design interface, wherein the electronic form design operation comprises an electronic form free layout operation, placing components into form cells in a dragging mode and configuring component attributes; Obtaining a form file template based on user electronic form design, and generating form rendering resources for rendering a form interface, wherein the form file template and the form interface keep form visual features designed by a user, and the form visual features comprise form styles and layout structures; creating a form instance, dynamically rendering a form interface through a form rendering resource, receiving and storing form filling data, and performing flow approval on the filled form based on a preconfigured approval process; And after the approval is finished, generating a project table file based on the table file template and form filling data passing the approval. In some embodiments, the spreadsheet editing area provides the functionality of the underlying free layout of the spreadsheet, including cell merging, multi-level header generation, fixed text filling, and text style setting. In some embodiments, the design interface is provided by an online form designer that is implemented based on Luckysheet open source framework secondary development. In some embodiments, the form rendering resources include form configuration objects and HTML file